{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Employee Vacation Tracker "],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Employee Vacation Tracker ","index":0,"n_rows":63,"n_cols":14,"rows_kept":63,"merged":[[1,2,1,7],[1,9,1,13],[3,1,4,1],[3,2,4,2],[3,5,3,7],[7,1,8,1],[7,2,7,4],[7,5,7,7],[7,8,7,10],[7,11,7,13],[62,1,62,13]]}
[null,"EMPLOYEE VACATION TRACKER TEMPLATE"]
[null,"COMPANY NAME",{"$nulls":6},"EMPLOYEE NAME"]
[]
[null,"PAY PERIOD START DATE","# OF DAYS IN PAY PERIOD",null,null,"HOURS ACCRUED PER PAY PERIOD"]
[{"$nulls":5},"VACATION","SICK","PERSONAL"]
[null,"2018-01-07",14,null,null,0.38,0.27,0.19]
[]
[null,"PAY PERIOD END DATE","HOURS USED PER PAY PERIOD",null,null,"HOURS ACCRUED PER PAY PERIOD",null,null,"CUMULATIVE HOURS ACCRUED",null,null,"HOURS AVAILABLE"]
[null,null,"VACATION","SICK","PERSONAL","VACATION","SICK","PERSONAL","VACATION","SICK","PERSONAL","VACATION","SICK","PERSONAL"]
[null,{"$f":"B6+C6-1","v":"2018-01-20"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},{"$f":"H6","v":0.19},{"$f":"F10","v":0.38},{"$f":"G10","v":0.27},{"$f":"H10","v":0.19},{"$f":"I10-C10","v":0.38},0.27,0.19]
[null,{"$f":"B10+C6","v":"2018-02-03"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},{"$f":"H6","v":0.19},{"$f":"I10+F11","v":0.76},{"$f":"J10+G11","v":0.54},{"$f":"K10+H11","v":0.38},0.76,0.54,0.38]
[null,{"$f":"B11+C6","v":"2018-02-17"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},{"$f":"H6","v":0.19},{"$f":"I11+F12","v":1.1400000000000001},{"$f":"J11+G12","v":0.81},{"$f":"K11+H12","v":0.5700000000000001},{"$f":"I12-C12","v":{"v":1.1400000000000001,"d":"1.14"}},{"$f":"J12-D12","v":0.81},{"$f":"K12-E12","v":{"v":0.5700000000000001,"d":"0.57"}}]
[null,{"$f":"B12+C6","v":"2018-03-03"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},{"$f":"H6","v":0.19},1.52,1.08,0.76,1.52,1.08,0.76]
[null,{"$f":"B13+C6","v":"2018-03-17"},null,{"v":1,"d":"1.00"},null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,{"$f":"I13+F14","v":1.9},1.35,0.95,{"v":1.9,"d":"1.90"},{"$f":"J14-D14","v":{"v":0.3500000000000001,"d":"0.35"}},0.95]
[null,{"$f":"B14+C6","v":"2018-03-31"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,{"$f":"I14+F15","v":2.28},1.62,1.14,2.28,{"$f":"J15-D15","v":1.62},1.14]
[null,{"$f":"B15+C6","v":"2018-04-14"},null,null,{"v":0.5,"d":"0.50"},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,{"$f":"I15+F16","v":2.6599999999999997},1.8900000000000001,1.3299999999999998,{"v":2.6599999999999997,"d":"2.66"},{"v":1.8900000000000001,"d":"1.89"},{"v":0.8299999999999998,"d":"0.83"}]
[null,{"$f":"B16+C6","v":"2018-04-28"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,3.0399999999999996,2.16,1.5199999999999998,{"v":3.0399999999999996,"d":"3.04"},2.16,{"v":1.5199999999999998,"d":"1.52"}]
[null,{"$f":"B17+C6","v":"2018-05-12"},{"v":3,"d":"3.00"},null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,3.4199999999999995,2.43,1.7099999999999997,{"v":0.4199999999999995,"d":"0.42"},2.43,{"v":1.7099999999999997,"d":"1.71"}]
[null,{"$f":"B18+C6","v":"2018-05-26"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,3.7999999999999994,2.7,1.8999999999999997,{"v":3.7999999999999994,"d":"3.80"},{"v":2.7,"d":"2.70"},{"v":1.8999999999999997,"d":"1.90"}]
[null,{"$f":"B19+C6","v":"2018-06-09"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,4.18,2.97,2.09,4.18,2.97,2.09]
[null,{"$f":"B20+C6","v":"2018-06-23"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,4.56,3.24,2.28,4.56,3.24,2.28]
[null,{"$f":"B21+C6","v":"2018-07-07"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,4.9399999999999995,3.5100000000000002,2.4699999999999998,{"v":4.9399999999999995,"d":"4.94"},{"v":3.5100000000000002,"d":"3.51"},{"v":2.4699999999999998,"d":"2.47"}]
[null,{"$f":"B22+C6","v":"2018-07-21"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,5.319999999999999,3.7800000000000002,2.6599999999999997,{"v":5.319999999999999,"d":"5.32"},{"v":3.7800000000000002,"d":"3.78"},{"v":2.6599999999999997,"d":"2.66"}]
[null,{"$f":"B23+C6","v":"2018-08-04"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,5.699999999999999,4.050000000000001,2.8499999999999996,{"v":5.699999999999999,"d":"5.70"},{"v":4.050000000000001,"d":"4.05"},{"v":2.8499999999999996,"d":"2.85"}]
[null,{"$f":"B24+C6","v":"2018-08-18"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,6.079999999999999,4.32,3.0399999999999996,{"v":6.079999999999999,"d":"6.08"},4.32,{"v":3.0399999999999996,"d":"3.04"}]
[null,{"$f":"B25+C6","v":"2018-09-01"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,6.459999999999999,4.59,3.2299999999999995,{"v":6.459999999999999,"d":"6.46"},4.59,{"v":3.2299999999999995,"d":"3.23"}]
[null,{"$f":"B26+C6","v":"2018-09-15"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,6.839999999999999,4.859999999999999,3.4199999999999995,{"v":6.839999999999999,"d":"6.84"},{"v":4.859999999999999,"d":"4.86"},{"v":3.4199999999999995,"d":"3.42"}]
[null,{"$f":"B27+C6","v":"2018-09-29"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,7.219999999999999,5.129999999999999,3.6099999999999994,{"v":7.219999999999999,"d":"7.22"},{"v":5.129999999999999,"d":"5.13"},{"v":3.6099999999999994,"d":"3.61"}]
[null,{"$f":"B28+C6","v":"2018-10-13"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,7.599999999999999,5.399999999999999,3.7999999999999994,{"v":7.599999999999999,"d":"7.60"},{"v":5.399999999999999,"d":"5.40"},{"v":3.7999999999999994,"d":"3.80"}]
[null,{"$f":"B29+C6","v":"2018-10-27"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,7.979999999999999,5.669999999999998,3.9899999999999993,{"v":7.979999999999999,"d":"7.98"},{"v":5.669999999999998,"d":"5.67"},{"v":3.9899999999999993,"d":"3.99"}]
[null,{"$f":"B30+C6","v":"2018-11-10"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,8.36,5.939999999999998,4.18,8.36,{"v":5.939999999999998,"d":"5.94"},4.18]
[null,{"$f":"B31+C6","v":"2018-11-24"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,8.74,6.209999999999997,4.37,8.74,{"v":6.209999999999997,"d":"6.21"},4.37]
[null,{"$f":"B32+C6","v":"2018-12-08"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,9.120000000000001,6.479999999999997,4.5600000000000005,{"v":9.120000000000001,"d":"9.12"},{"v":6.479999999999997,"d":"6.48"},{"v":4.5600000000000005,"d":"4.56"}]
[null,{"$f":"B33+C6","v":"2018-12-22"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,9.500000000000002,6.7499999999999964,4.750000000000001,{"v":9.500000000000002,"d":"9.50"},{"v":6.7499999999999964,"d":"6.75"},{"v":4.750000000000001,"d":"4.75"}]
[null,{"$f":"B34+C6","v":"2019-01-05"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,9.880000000000003,7.019999999999996,4.940000000000001,{"v":9.880000000000003,"d":"9.88"},{"v":7.019999999999996,"d":"7.02"},{"v":4.940000000000001,"d":"4.94"}]
[null,{"$f":"B35+C6","v":"2019-01-19"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,10.260000000000003,7.289999999999996,5.130000000000002,{"v":10.260000000000003,"d":"10.26"},{"v":7.289999999999996,"d":"7.29"},{"v":5.130000000000002,"d":"5.13"}]
[null,{"$f":"B36+C6","v":"2019-02-02"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,10.640000000000004,7.559999999999995,5.320000000000002,{"v":10.640000000000004,"d":"10.64"},{"v":7.559999999999995,"d":"7.56"},{"v":5.320000000000002,"d":"5.32"}]
[null,{"$f":"B37+C6","v":"2019-02-16"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,11.020000000000005,7.829999999999995,5.5100000000000025,{"v":11.020000000000005,"d":"11.02"},{"v":7.829999999999995,"d":"7.83"},{"v":5.5100000000000025,"d":"5.51"}]
[null,{"$f":"B38+C6","v":"2019-03-02"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,11.400000000000006,8.099999999999994,5.700000000000003,{"$f":"I39-C39","v":{"v":11.400000000000006,"d":"11.40"}},{"v":8.099999999999994,"d":"8.10"},{"v":5.700000000000003,"d":"5.70"}]
[null,{"$f":"B39+C6","v":"2019-03-16"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,11.780000000000006,8.369999999999994,5.890000000000003,{"v":11.780000000000006,"d":"11.78"},{"v":8.369999999999994,"d":"8.37"},{"v":5.890000000000003,"d":"5.89"}]
[null,{"$f":"B40+C6","v":"2019-03-30"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,12.160000000000007,8.639999999999993,6.080000000000004,{"$f":"I41-C41","v":{"v":12.160000000000007,"d":"12.16"}},{"$f":"J41-D41","v":{"v":8.639999999999993,"d":"8.64"}},{"$f":"K41-E41","v":{"v":6.080000000000004,"d":"6.08"}}]
[null,{"$f":"B41+C6","v":"2019-04-13"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,12.540000000000008,8.909999999999993,6.270000000000004,{"v":12.540000000000008,"d":"12.54"},{"v":8.909999999999993,"d":"8.91"},{"v":6.270000000000004,"d":"6.27"}]
[null,{"$f":"B42+C6","v":"2019-04-27"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,12.920000000000009,9.179999999999993,6.460000000000004,{"v":12.920000000000009,"d":"12.92"},{"v":9.179999999999993,"d":"9.18"},{"v":6.460000000000004,"d":"6.46"}]
[null,{"$f":"B43+C6","v":"2019-05-11"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,13.30000000000001,9.449999999999992,6.650000000000005,{"v":13.30000000000001,"d":"13.30"},{"v":9.449999999999992,"d":"9.45"},{"v":6.650000000000005,"d":"6.65"}]
[null,{"$f":"B44+C6","v":"2019-05-25"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,13.68000000000001,9.719999999999992,6.840000000000005,{"v":13.68000000000001,"d":"13.68"},{"v":9.719999999999992,"d":"9.72"},{"v":6.840000000000005,"d":"6.84"}]
[null,{"$f":"B45+C6","v":"2019-06-08"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,14.060000000000011,9.989999999999991,7.030000000000006,{"v":14.060000000000011,"d":"14.06"},{"v":9.989999999999991,"d":"9.99"},{"v":7.030000000000006,"d":"7.03"}]
[null,{"$f":"B46+C6","v":"2019-06-22"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,14.440000000000012,10.259999999999991,7.220000000000006,{"v":14.440000000000012,"d":"14.44"},{"v":10.259999999999991,"d":"10.26"},{"v":7.220000000000006,"d":"7.22"}]
[null,{"$f":"B47+C6","v":"2019-07-06"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,14.820000000000013,10.52999999999999,7.410000000000006,{"v":14.820000000000013,"d":"14.82"},{"v":10.52999999999999,"d":"10.53"},{"v":7.410000000000006,"d":"7.41"}]
[null,{"$f":"B48+C6","v":"2019-07-20"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,15.200000000000014,10.79999999999999,7.600000000000007,{"v":15.200000000000014,"d":"15.20"},{"v":10.79999999999999,"d":"10.80"},{"v":7.600000000000007,"d":"7.60"}]
[null,{"$f":"B49+C6","v":"2019-08-03"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,15.580000000000014,11.06999999999999,7.790000000000007,{"v":15.580000000000014,"d":"15.58"},{"v":11.06999999999999,"d":"11.07"},{"v":7.790000000000007,"d":"7.79"}]
[null,{"$f":"B50+C6","v":"2019-08-17"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,15.960000000000015,11.33999999999999,7.9800000000000075,{"v":15.960000000000015,"d":"15.96"},{"v":11.33999999999999,"d":"11.34"},{"v":7.9800000000000075,"d":"7.98"}]
[null,{"$f":"B51+C6","v":"2019-08-31"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,16.340000000000014,11.609999999999989,8.170000000000007,{"v":16.340000000000014,"d":"16.34"},{"v":11.609999999999989,"d":"11.61"},{"v":8.170000000000007,"d":"8.17"}]
[null,{"$f":"B52+C6","v":"2019-09-14"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,16.720000000000013,11.879999999999988,8.360000000000007,{"v":16.720000000000013,"d":"16.72"},{"v":11.879999999999988,"d":"11.88"},{"v":8.360000000000007,"d":"8.36"}]
[null,{"$f":"B53+C6","v":"2019-09-28"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,17.100000000000012,12.149999999999988,8.550000000000006,{"v":17.100000000000012,"d":"17.10"},{"v":12.149999999999988,"d":"12.15"},{"v":8.550000000000006,"d":"8.55"}]
[null,{"$f":"B54+C6","v":"2019-10-12"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,17.48000000000001,12.419999999999987,8.740000000000006,{"v":17.48000000000001,"d":"17.48"},{"v":12.419999999999987,"d":"12.42"},{"v":8.740000000000006,"d":"8.74"}]
[null,{"$f":"B55+C6","v":"2019-10-26"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,17.86000000000001,12.689999999999987,8.930000000000005,{"v":17.86000000000001,"d":"17.86"},{"v":12.689999999999987,"d":"12.69"},{"v":8.930000000000005,"d":"8.93"}]
[null,{"$f":"B56+C6","v":"2019-11-09"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,18.24000000000001,12.959999999999987,9.120000000000005,{"v":18.24000000000001,"d":"18.24"},{"v":12.959999999999987,"d":"12.96"},{"v":9.120000000000005,"d":"9.12"}]
[null,{"$f":"B57+C6","v":"2019-11-23"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,18.620000000000008,13.229999999999986,9.310000000000004,{"v":18.620000000000008,"d":"18.62"},{"v":13.229999999999986,"d":"13.23"},{"v":9.310000000000004,"d":"9.31"}]
[null,{"$f":"B58+C6","v":"2019-12-07"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,19.000000000000007,13.499999999999986,9.500000000000004,{"v":19.000000000000007,"d":"19.00"},{"v":13.499999999999986,"d":"13.50"},{"v":9.500000000000004,"d":"9.50"}]
[null,{"$f":"B59+C6","v":"2019-12-21"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,19.380000000000006,13.769999999999985,9.690000000000003,{"v":19.380000000000006,"d":"19.38"},{"v":13.769999999999985,"d":"13.77"},{"v":9.690000000000003,"d":"9.69"}]
[null,{"$f":"B60+C6","v":"2020-01-04"},{"$nulls":3},{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,19.760000000000005,14.039999999999985,9.880000000000003,{"v":19.760000000000005,"d":"19.76"},{"v":14.039999999999985,"d":"14.04"},{"v":9.880000000000003,"d":"9.88"}]
[]
[null,"CLICK HERE TO CREATE EMPLOYEE VACATION TRACKER TEMPLATES IN SMARTSHEET"]