{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Holiday Tracker","Help"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":18,"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":"Holiday Tracker","index":0,"n_rows":1000,"n_cols":13,"rows_kept":1000,"cut":false,"hidden":false,"merged":[]}
[null,null,1,1,null,1,1,1,1,1,1,1,"D"]
[null,null,null,null,null,{"$f":"WEEKDAY(F4,2)","v":6},{"$f":"WEEKDAY(G4,2)","v":7}]
[null,null,null,null,null,{"$f":"IF(TEXT(F4,\"ddd\")<>\"ddd\",LEFT(TEXT(F4,\"ddd\"),1),LEFT(TEXT(F4,\"ttt\"),1))","v":"S"},{"$f":"IF(TEXT(G4,\"ddd\")<>\"ddd\",LEFT(TEXT(G4,\"ddd\"),1),LEFT(TEXT(G4,\"ttt\"),1))","v":"S"}]
["Employee","Allocation","Days taken","Days left","Sick",null,{"$f":"F4+1","v":"1900-01-01"}]
["Barry",18,{"$f":"IF(A5<>\"\",SUM(F5:OA5)+(COUNTIF(F5:OA5,\"P\")+COUNTIF(F5:OA5,\"A\"))*0.5,\"\")","v":0},{"$f":"IF(A5<>\"\",B5-C5,\"\")","v":18},{"$f":"IF(A5<>\"\",COUNTIF(F5:OA5,\"S\"),\"\")","v":0}]
["Joan",24,0,24,0]
["Sue",21,0,21,0]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A69<>\"\",SUM(F69:OA69)+(COUNTIF(F69:OA69,\"P\")+COUNTIF(F69:OA69,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A69<>\"\",B69-C69,\"\")","v":""},{"$f":"IF(A69<>\"\",COUNTIF(F69:OA69,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A133<>\"\",SUM(F133:OA133)+(COUNTIF(F133:OA133,\"P\")+COUNTIF(F133:OA133,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A133<>\"\",B133-C133,\"\")","v":""},{"$f":"IF(A133<>\"\",COUNTIF(F133:OA133,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A197<>\"\",SUM(F197:OA197)+(COUNTIF(F197:OA197,\"P\")+COUNTIF(F197:OA197,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A197<>\"\",B197-C197,\"\")","v":""},{"$f":"IF(A197<>\"\",COUNTIF(F197:OA197,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A261<>\"\",SUM(F261:OA261)+(COUNTIF(F261:OA261,\"P\")+COUNTIF(F261:OA261,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A261<>\"\",B261-C261,\"\")","v":""},{"$f":"IF(A261<>\"\",COUNTIF(F261:OA261,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A325<>\"\",SUM(F325:OA325)+(COUNTIF(F325:OA325,\"P\")+COUNTIF(F325:OA325,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A325<>\"\",B325-C325,\"\")","v":""},{"$f":"IF(A325<>\"\",COUNTIF(F325:OA325,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A389<>\"\",SUM(F389:OA389)+(COUNTIF(F389:OA389,\"P\")+COUNTIF(F389:OA389,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A389<>\"\",B389-C389,\"\")","v":""},{"$f":"IF(A389<>\"\",COUNTIF(F389:OA389,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A453<>\"\",SUM(F453:OA453)+(COUNTIF(F453:OA453,\"P\")+COUNTIF(F453:OA453,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A453<>\"\",B453-C453,\"\")","v":""},{"$f":"IF(A453<>\"\",COUNTIF(F453:OA453,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A517<>\"\",SUM(F517:OA517)+(COUNTIF(F517:OA517,\"P\")+COUNTIF(F517:OA517,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A517<>\"\",B517-C517,\"\")","v":""},{"$f":"IF(A517<>\"\",COUNTIF(F517:OA517,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A581<>\"\",SUM(F581:OA581)+(COUNTIF(F581:OA581,\"P\")+COUNTIF(F581:OA581,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A581<>\"\",B581-C581,\"\")","v":""},{"$f":"IF(A581<>\"\",COUNTIF(F581:OA581,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A645<>\"\",SUM(F645:OA645)+(COUNTIF(F645:OA645,\"P\")+COUNTIF(F645:OA645,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A645<>\"\",B645-C645,\"\")","v":""},{"$f":"IF(A645<>\"\",COUNTIF(F645:OA645,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A709<>\"\",SUM(F709:OA709)+(COUNTIF(F709:OA709,\"P\")+COUNTIF(F709:OA709,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A709<>\"\",B709-C709,\"\")","v":""},{"$f":"IF(A709<>\"\",COUNTIF(F709:OA709,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A773<>\"\",SUM(F773:OA773)+(COUNTIF(F773:OA773,\"P\")+COUNTIF(F773:OA773,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A773<>\"\",B773-C773,\"\")","v":""},{"$f":"IF(A773<>\"\",COUNTIF(F773:OA773,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A837<>\"\",SUM(F837:OA837)+(COUNTIF(F837:OA837,\"P\")+COUNTIF(F837:OA837,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A837<>\"\",B837-C837,\"\")","v":""},{"$f":"IF(A837<>\"\",COUNTIF(F837:OA837,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A901<>\"\",SUM(F901:OA901)+(COUNTIF(F901:OA901,\"P\")+COUNTIF(F901:OA901,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A901<>\"\",B901-C901,\"\")","v":""},{"$f":"IF(A901<>\"\",COUNTIF(F901:OA901,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,{"$f":"IF(A965<>\"\",SUM(F965:OA965)+(COUNTIF(F965:OA965,\"P\")+COUNTIF(F965:OA965,\"A\"))*0.5,\"\")","v":""},{"$f":"IF(A965<>\"\",B965-C965,\"\")","v":""},{"$f":"IF(A965<>\"\",COUNTIF(F965:OA965,\"S\"),\"\")","v":""}]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]
[null,null,"","",""]

{"sheet":"Help","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,5,7,5],[12,5,14,5]]}
[]
[null,null,"v1.1",null,null,"Frequently asked questions"]
[]
[null,null,null,null,null,"The sheet is protected, what is the password?"]
[null,null,"This free Team Holiday Spreadsheet was created by:",null,null,"The sheet is protected to ensure that it cannot be changed in ways which may cause the macros to stop working. You do not need the password to fully use the tool. If you are prompted for a password and do not understand why then please watch the training video linked on the left."]
[null,null,"http://www.excel-macros.co.uk/"]
[null,null,"Please visit the site to download more free Excel tools and games"]
[]
[null,null,"For information on how to use the tool please watch this video:",null,null,"How do I add and delete employees"]
[null,null,null,null,null,"To add an employee, simply start typing their name below the last employee in the list. Once you have entered their name, you will see a new line appear where you can enter their leave allocation and leave information. If you need to delete an employee, the best way to do this is to rename them xxxx and then sort the column by double clicking the column title. They will then be moved to the bottom of the list. You can delete their name, allocation and clear their leave cells."]
[]
[null,null,null,null,null,"Can I modify the types of leave used by the tool"]
[null,null,null,null,null,"This is not possible in the free version as it has been created with ease of use in mind. If you would like a more flexible version of the tool please visit our site to find out about the premium leave tracker tool which allows you to customise leave types and other information."]
[]
[]
[null,null,null,null,null,"Find out about the premium version of the tool by clicking here"]