{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Employee Vacation Tracker "],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Employee Vacation Tracker ","index":0,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,2,1,7],[1,9,1,13],[7,2,7,4],[7,5,7,7],[7,8,7,10],[7,11,7,13],[3,1,4,1],[3,2,4,2],[3,5,3,7],[7,1,8,1],[62,1,62,13]]}
[null,"EMPLOYEE VACATION TRACKER TEMPLATE"]
[null,"COMPANY NAME",null,null,null,null,null,null,"EMPLOYEE NAME"]
[]
[null,"PAY PERIOD START DATE","# OF DAYS IN PAY PERIOD",null,null,"HOURS ACCRUED PER PAY PERIOD"]
[null,null,null,null,null,"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"},null,null,null,{"$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"},null,null,null,{"$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"},null,null,null,{"$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.57000000000000006},{"$f":"I12-C12","v":1.1400000000000001},{"$f":"J12-D12","v":0.81},{"$f":"K12-E12","v":0.57000000000000006}]
[null,{"$f":"B12+C6","v":"2018-03-03"},null,null,null,{"$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,1,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,{"$f":"I13+F14","v":1.9},1.35,0.95,1.9,{"$f":"J14-D14","v":0.35000000000000009},0.95]
[null,{"$f":"B14+C6","v":"2018-03-31"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,{"$f":"I14+F15","v":2.2799999999999998},1.62,1.1399999999999999,2.2799999999999998,{"$f":"J15-D15","v":1.62},1.1399999999999999]
[null,{"$f":"B15+C6","v":"2018-04-14"},null,null,0.5,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,{"$f":"I15+F16","v":2.6599999999999997},1.8900000000000001,1.3299999999999998,2.6599999999999997,1.8900000000000001,0.82999999999999985]
[null,{"$f":"B16+C6","v":"2018-04-28"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,3.0399999999999996,2.16,1.5199999999999998,3.0399999999999996,2.16,1.5199999999999998]
[null,{"$f":"B17+C6","v":"2018-05-12"},3,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,3.4199999999999995,2.4300000000000002,1.7099999999999997,0.41999999999999948,2.4300000000000002,1.7099999999999997]
[null,{"$f":"B18+C6","v":"2018-05-26"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,3.7999999999999994,2.7,1.8999999999999997,3.7999999999999994,2.7,1.8999999999999997]
[null,{"$f":"B19+C6","v":"2018-06-09"},null,null,null,{"$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"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,4.5599999999999996,3.24,2.2799999999999998,4.5599999999999996,3.24,2.2799999999999998]
[null,{"$f":"B21+C6","v":"2018-07-07"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,4.9399999999999995,3.5100000000000002,2.4699999999999998,4.9399999999999995,3.5100000000000002,2.4699999999999998]
[null,{"$f":"B22+C6","v":"2018-07-21"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,5.3199999999999994,3.7800000000000002,2.6599999999999997,5.3199999999999994,3.7800000000000002,2.6599999999999997]
[null,{"$f":"B23+C6","v":"2018-08-04"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,5.6999999999999993,4.0500000000000007,2.8499999999999996,5.6999999999999993,4.0500000000000007,2.8499999999999996]
[null,{"$f":"B24+C6","v":"2018-08-18"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,6.0799999999999992,4.32,3.0399999999999996,6.0799999999999992,4.32,3.0399999999999996]
[null,{"$f":"B25+C6","v":"2018-09-01"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,6.4599999999999991,4.59,3.2299999999999995,6.4599999999999991,4.59,3.2299999999999995]
[null,{"$f":"B26+C6","v":"2018-09-15"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,6.839999999999999,4.8599999999999994,3.4199999999999995,6.839999999999999,4.8599999999999994,3.4199999999999995]
[null,{"$f":"B27+C6","v":"2018-09-29"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,7.2199999999999989,5.129999999999999,3.6099999999999994,7.2199999999999989,5.129999999999999,3.6099999999999994]
[null,{"$f":"B28+C6","v":"2018-10-13"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,7.5999999999999988,5.3999999999999986,3.7999999999999994,7.5999999999999988,5.3999999999999986,3.7999999999999994]
[null,{"$f":"B29+C6","v":"2018-10-27"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,7.9799999999999986,5.6699999999999982,3.9899999999999993,7.9799999999999986,5.6699999999999982,3.9899999999999993]
[null,{"$f":"B30+C6","v":"2018-11-10"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,8.36,5.9399999999999977,4.18,8.36,5.9399999999999977,4.18]
[null,{"$f":"B31+C6","v":"2018-11-24"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,8.74,6.2099999999999973,4.37,8.74,6.2099999999999973,4.37]
[null,{"$f":"B32+C6","v":"2018-12-08"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,9.120000000000001,6.4799999999999969,4.5600000000000005,9.120000000000001,6.4799999999999969,4.5600000000000005]
[null,{"$f":"B33+C6","v":"2018-12-22"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,9.5000000000000018,6.7499999999999964,4.7500000000000009,9.5000000000000018,6.7499999999999964,4.7500000000000009]
[null,{"$f":"B34+C6","v":"2019-01-05"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,9.8800000000000026,7.019999999999996,4.9400000000000013,9.8800000000000026,7.019999999999996,4.9400000000000013]
[null,{"$f":"B35+C6","v":"2019-01-19"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,10.260000000000003,7.2899999999999956,5.1300000000000017,10.260000000000003,7.2899999999999956,5.1300000000000017]
[null,{"$f":"B36+C6","v":"2019-02-02"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,10.640000000000004,7.5599999999999952,5.3200000000000021,10.640000000000004,7.5599999999999952,5.3200000000000021]
[null,{"$f":"B37+C6","v":"2019-02-16"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,11.020000000000005,7.8299999999999947,5.5100000000000025,11.020000000000005,7.8299999999999947,5.5100000000000025]
[null,{"$f":"B38+C6","v":"2019-03-02"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,11.400000000000006,8.0999999999999943,5.7000000000000028,{"$f":"I39-C39","v":11.400000000000006},8.0999999999999943,5.7000000000000028]
[null,{"$f":"B39+C6","v":"2019-03-16"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,11.780000000000006,8.3699999999999939,5.8900000000000032,11.780000000000006,8.3699999999999939,5.8900000000000032]
[null,{"$f":"B40+C6","v":"2019-03-30"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,12.160000000000007,8.6399999999999935,6.0800000000000036,{"$f":"I41-C41","v":12.160000000000007},{"$f":"J41-D41","v":8.6399999999999935},{"$f":"K41-E41","v":6.0800000000000036}]
[null,{"$f":"B41+C6","v":"2019-04-13"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,12.540000000000008,8.909999999999993,6.270000000000004,12.540000000000008,8.909999999999993,6.270000000000004]
[null,{"$f":"B42+C6","v":"2019-04-27"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,12.920000000000009,9.1799999999999926,6.4600000000000044,12.920000000000009,9.1799999999999926,6.4600000000000044]
[null,{"$f":"B43+C6","v":"2019-05-11"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,13.30000000000001,9.4499999999999922,6.6500000000000048,13.30000000000001,9.4499999999999922,6.6500000000000048]
[null,{"$f":"B44+C6","v":"2019-05-25"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,13.68000000000001,9.7199999999999918,6.8400000000000052,13.68000000000001,9.7199999999999918,6.8400000000000052]
[null,{"$f":"B45+C6","v":"2019-06-08"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,14.060000000000011,9.9899999999999913,7.0300000000000056,14.060000000000011,9.9899999999999913,7.0300000000000056]
[null,{"$f":"B46+C6","v":"2019-06-22"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,14.440000000000012,10.259999999999991,7.220000000000006,14.440000000000012,10.259999999999991,7.220000000000006]
[null,{"$f":"B47+C6","v":"2019-07-06"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,14.820000000000013,10.52999999999999,7.4100000000000064,14.820000000000013,10.52999999999999,7.4100000000000064]
[null,{"$f":"B48+C6","v":"2019-07-20"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,15.200000000000014,10.79999999999999,7.6000000000000068,15.200000000000014,10.79999999999999,7.6000000000000068]
[null,{"$f":"B49+C6","v":"2019-08-03"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,15.580000000000014,11.06999999999999,7.7900000000000071,15.580000000000014,11.06999999999999,7.7900000000000071]
[null,{"$f":"B50+C6","v":"2019-08-17"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,15.960000000000015,11.339999999999989,7.9800000000000075,15.960000000000015,11.339999999999989,7.9800000000000075]
[null,{"$f":"B51+C6","v":"2019-08-31"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,16.340000000000014,11.609999999999989,8.170000000000007,16.340000000000014,11.609999999999989,8.170000000000007]
[null,{"$f":"B52+C6","v":"2019-09-14"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,16.720000000000013,11.879999999999988,8.3600000000000065,16.720000000000013,11.879999999999988,8.3600000000000065]
[null,{"$f":"B53+C6","v":"2019-09-28"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,17.100000000000012,12.149999999999988,8.550000000000006,17.100000000000012,12.149999999999988,8.550000000000006]
[null,{"$f":"B54+C6","v":"2019-10-12"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,17.480000000000011,12.419999999999987,8.7400000000000055,17.480000000000011,12.419999999999987,8.7400000000000055]
[null,{"$f":"B55+C6","v":"2019-10-26"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,17.86000000000001,12.689999999999987,8.930000000000005,17.86000000000001,12.689999999999987,8.930000000000005]
[null,{"$f":"B56+C6","v":"2019-11-09"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,18.240000000000009,12.959999999999987,9.1200000000000045,18.240000000000009,12.959999999999987,9.1200000000000045]
[null,{"$f":"B57+C6","v":"2019-11-23"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,18.620000000000008,13.229999999999986,9.3100000000000041,18.620000000000008,13.229999999999986,9.3100000000000041]
[null,{"$f":"B58+C6","v":"2019-12-07"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,19.000000000000007,13.499999999999986,9.5000000000000036,19.000000000000007,13.499999999999986,9.5000000000000036]
[null,{"$f":"B59+C6","v":"2019-12-21"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,19.380000000000006,13.769999999999985,9.6900000000000031,19.380000000000006,13.769999999999985,9.6900000000000031]
[null,{"$f":"B60+C6","v":"2020-01-04"},null,null,null,{"$f":"F6","v":0.38},{"$f":"G6","v":0.27},0.19,19.760000000000005,14.039999999999985,9.8800000000000026,19.760000000000005,14.039999999999985,9.8800000000000026]
[]
[null,"CLICK HERE TO CREATE EMPLOYEE VACATION TRACKER TEMPLATES IN SMARTSHEET"]