{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Employee","Accruals","Options","Add Leave","Leave Planner","Records","Settings","Setup 1","Setup 2","Setup 3","Setup 4","Help"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":122,"comments":1,"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","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[5,"Employee details","<< Previous ","Next >>"]
[1]
[null,{"$f":"Settings!B5","v":"First Name"},"d",null,null,{"$f":"Settings!E5","v":"Leave Entitlement"},null,null,null,null,{"$f":"Settings!B20","v":"Full Day Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K3,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B6","v":"Last Name"},"d",null,null,{"$f":"Settings!E6","v":"Leave Accrued"},null,null,null,null,{"$f":"Settings!B21","v":"Half Day Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K5,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B7","v":"Department"},null,null,null,{"$f":"Settings!E7","v":"Leave Carried Over"},null,null,null,null,{"$f":"Settings!B22","v":"Flexi Earned"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K7,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B8","v":"Employee Number"},null,null,null,{"$f":"Settings!E8","v":"Bonus Leave"},null,null,null,null,{"$f":"Settings!B23","v":"Flexi Taken"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K9,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B9","v":"Job Grade"},null,null,null,{"$f":"Settings!E9","v":"Total Annual Leave"},{"$f":"Leave1+Leave2+Leave3+Leave4","v":0},null,null,null,{"$f":"Settings!B24","v":"Purchased Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K11,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B10","v":"Notes"},null,null,null,{"$f":"DaysTaken","v":"Taken Annual Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!F13,'Leave Planner'!$4:$4,0)-1)","v":0},null,null,null,{"$f":"Settings!B25","v":"Compassionate"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K13,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B11","v":"Misc1"},null,null,null,{"$f":"DaysLeft","v":"Remaining Annual Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!F15,'Leave Planner'!$4:$4,0)-1)","v":0},null,null,null,{"$f":"Settings!B26","v":"Sickness - Paid"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K15,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B12","v":"Misc2"},null,null,null,null,null,null,null,null,{"$f":"Settings!B27","v":"Sickness - Unpaid"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K17,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B13","v":"Misc3"},null,null,null,{"$f":"Settings!E12","v":"Total Flexi Time"},null,null,null,null,{"$f":"Settings!B28","v":"Public holidays"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K19,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,{"$f":"Settings!B14","v":"Misc4"},null,null,null,{"$f":"Settings!E13","v":"Taken Flexi Time"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!F21,'Leave Planner'!$4:$4,0)-1)","v":0},null,null,null,{"$f":"Settings!B29","v":"Training"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K21,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,"<< Back","Save",null,null,{"$f":"Settings!E14","v":"Remaining Flexi Time"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!F23,'Leave Planner'!$4:$4,0)-1)","v":0},null,null,null,{"$f":"Settings!B30","v":"Day in Lieu"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K23,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,null,null,null,null,{"$f":"Settings!E15","v":"Total Purchased Leave"},null,null,null,null,{"$f":"Settings!B31","v":"Unpaid"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K25,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,null,null,null,null,{"$f":"Settings!E16","v":"Taken Purchased Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!F27,'Leave Planner'!$4:$4,0)-1)","v":0},null,null,null,{"$f":"Settings!B32","v":"Work from home"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K27,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[null,"Details of leave",null,null,null,{"$f":"Settings!E17","v":"Remaining Purchased Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!F29,'Leave Planner'!$4:$4,0)-1)","v":0},null,null,null,{"$f":"Settings!B33","v":"Other"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRowNumber-1,MATCH(Employee!K29,'Leave Planner'!$4:$4,0)-1)","v":0}]
[]
[]
[null,"Date Requested","Type","Amount",null,"Date of Leave",null,null,null,"Note"]

{"sheet":"Accruals","index":1,"n_rows":6,"n_cols":21,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Select a month",3,{"$f":"DATE(YEAR(FirstDate),AccrualMonth+1,1)","v":"1900-04-01"}]
[{"$f":"IF(ISERROR(FIND(\"RATE\",UPPER(B4))),\"\",1)","v":""},"","","","","","",{"$f":"IF(ISERROR(FIND(\"RATE\",UPPER(M4))),\"\",1)","v":""},null,null,null,null,"","",0]
[null,{"$f":"'Leave Planner'!A4","v":"ID"},{"$f":"'Leave Planner'!B4","v":"First Name"},{"$f":"'Leave Planner'!C4","v":"Last Name"},{"$f":"'Leave Planner'!D4","v":"Department"},{"$f":"'Leave Planner'!E4","v":"Employee Number"},{"$f":"'Leave Planner'!F4","v":"Job Grade"},{"$f":"'Leave Planner'!G4","v":"Notes"},{"$f":"'Leave Planner'!H4","v":"Misc1"},{"$f":"'Leave Planner'!I4","v":"Misc2"},{"$f":"'Leave Planner'!J4","v":"Misc3"},{"$f":"'Leave Planner'!K4","v":"Misc4"},{"$f":"'Leave Planner'!R4","v":"Total Annual Leave"},{"$f":"'Leave Planner'!S4","v":"Taken Annual Leave"},{"$f":"'Leave Planner'!T4","v":"Remaining Annual Leave"},{"$f":"'Leave Planner'!U4","v":"Total Flexi Time"},{"$f":"'Leave Planner'!V4","v":"Taken Flexi Time"},{"$f":"'Leave Planner'!W4","v":"Remaining Flexi Time"},{"$f":"'Leave Planner'!X4","v":"Total Purchased Leave"},{"$f":"'Leave Planner'!Y4","v":"Taken Purchased Leave"},{"$f":"'Leave Planner'!Z4","v":"Remaining Purchased Leave"}]
[null,{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!/12*AccrualMonth","v":{"$error":"#REF!"}},{"$f":"SUMIFS(Records!H:H,Records!C:C,\"<\"&AccrualDate,Records!E:E,Accruals!B5,Records!G:G,'Setup 3'!$F$3)","v":0},{"$f":"M5-N5","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!/12*AccrualMonth","v":{"$error":"#REF!"}},{"$f":"SUMIFS(Records!H:H,Records!C:C,\"<\"&AccrualDate,Records!E:E,Accruals!B5,Records!G:G,'Setup 3'!$F$4)","v":0},{"$f":"P5-Q5","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!/12*AccrualMonth","v":{"$error":"#REF!"}},{"$f":"SUMIFS(Records!H:H,Records!C:C,\"<\"&AccrualDate,Records!E:E,Accruals!B5,Records!G:G,'Setup 3'!$F$5)","v":0},{"$f":"S5-T5","v":{"$error":"#REF!"}}]
[null,{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!/12*AccrualMonth","v":{"$error":"#REF!"}},{"$f":"SUMIFS(Records!H:H,Records!C:C,\"<\"&AccrualDate,Records!E:E,Accruals!B6,Records!G:G,'Setup 3'!$F$3)","v":0},{"$f":"M6-N6","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!/12*AccrualMonth","v":{"$error":"#REF!"}},{"$f":"SUMIFS(Records!H:H,Records!C:C,\"<\"&AccrualDate,Records!E:E,Accruals!B6,Records!G:G,'Setup 3'!$F$4)","v":0},{"$f":"P6-Q6","v":{"$error":"#REF!"}},{"$f":"'Leave Planner'!#REF!/12*AccrualMonth","v":{"$error":"#REF!"}},{"$f":"SUMIFS(Records!H:H,Records!C:C,\"<\"&AccrualDate,Records!E:E,Accruals!B6,Records!G:G,'Setup 3'!$F$5)","v":0},{"$f":"S6-T6","v":{"$error":"#REF!"}}]

{"sheet":"Options","index":2,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Report Options"]
[]
[null,"Employee information",null,"Show",null,"Leave Allowance",null,"Show"]
[null,{"$f":"Settings!B5","v":"First Name"},null,null,null,{"$f":"Settings!E5","v":"Leave Entitlement"}]
[null,{"$f":"Settings!B6","v":"Last Name"},null,null,null,{"$f":"Settings!E6","v":"Leave Accrued"}]
[null,{"$f":"Settings!B7","v":"Department"},null,null,null,{"$f":"Settings!E7","v":"Leave Carried Over"}]
[null,{"$f":"Settings!B8","v":"Employee Number"},null,null,null,{"$f":"Settings!E8","v":"Bonus Leave"}]
[null,{"$f":"Settings!B9","v":"Job Grade"},null,null,null,{"$f":"Settings!E9","v":"Total Annual Leave"}]
[null,{"$f":"Settings!B10","v":"Notes"},null,null,null,{"$f":"Settings!E10","v":"Taken Annual Leave"}]
[null,{"$f":"Settings!B11","v":"Misc1"},null,null,null,{"$f":"Settings!E11","v":"Remaining Annual Leave"}]
[null,{"$f":"Settings!B12","v":"Misc2"},null,null,null,{"$f":"Settings!E12","v":"Total Flexi Time"}]
[null,{"$f":"Settings!B13","v":"Misc3"},null,null,null,{"$f":"Settings!E13","v":"Taken Flexi Time"}]
[null,{"$f":"Settings!B14","v":"Misc4"},null,null,null,{"$f":"Settings!E14","v":"Remaining Flexi Time"}]
[null,null,null,null,null,{"$f":"Settings!E15","v":"Total Purchased Leave"}]
[null,null,null,null,null,{"$f":"Settings!E16","v":"Taken Purchased Leave"}]
[null,"Count of Leave by Type",null,"Show",null,{"$f":"Settings!E17","v":"Remaining Purchased Leave"}]
[null,{"$f":"Settings!H2","v":"Full Day Leave"}]
[null,{"$f":"Settings!H3","v":"Half Day Leave"}]
[null,{"$f":"Settings!H4","v":"Flexi Earned"},null,null,null,"Date Filters"]
[null,{"$f":"Settings!H5","v":"Flexi Taken"}]
[null,{"$f":"Settings!H6","v":"Purchased Leave"},null,null,null,"From Date"]
[null,{"$f":"Settings!H7","v":"Compassionate"},null,null,null,"To Date"]
[null,{"$f":"Settings!H8","v":"Sickness - Paid"}]
[null,{"$f":"Settings!H9","v":"Sickness - Unpaid"},null,null,null,null,null,"Run Report"]
[null,{"$f":"Settings!H10","v":"Public holidays"}]
[null,{"$f":"Settings!H11","v":"Training"},null,null,null,null,null,"Other reports:"]
[null,{"$f":"Settings!H12","v":"Day in Lieu"},null,null,null,null,null,"Create PDF for all employees"]
[null,{"$f":"Settings!H13","v":"Unpaid"},null,null,null,null,null,"Accrual Report"]
[null,{"$f":"Settings!H14","v":"Work from home"}]
[null,{"$f":"Settings!H15","v":"Other"}]

{"sheet":"Add Leave","index":3,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[{"$f":"MATCH(C1,Employees,)","v":{"$error":"#N/A"}},"<< back",1,"08/02/2018, 09/02/2018, 10/02/2018"]
[null,"Add Leave"]
[null,null,null,null,{"$f":"Settings!E9","v":"Total Annual Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E3,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E3,LEN($E$15))=$E$15,1,0)","v":1},null,null,{"$f":"Settings!B20","v":"Full Day Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J3,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[1,{"$f":"Settings!B5","v":"First Name"},{"$f":"IFERROR(INDEX('Leave Planner'!A:T,'Add Leave'!$A$1,A4+1),\"Multiple\")","v":"Multiple"}," ",{"$f":"Settings!E10","v":"Taken Annual Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E4,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E4,LEN($E$15))=$E$15,1,0)","v":1},null,null,{"$f":"Settings!B21","v":"Half Day Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J4,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[{"$f":"A4+1","v":2},{"$f":"Settings!B6","v":"Last Name"},{"$f":"IFERROR(INDEX('Leave Planner'!A:T,'Add Leave'!$A$1,A5+1),\"Multiple\")","v":"Multiple"}," ",{"$f":"Settings!E11","v":"Remaining Annual Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E5,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E5,LEN($E$15))=$E$15,1,0)","v":1},null,null,{"$f":"Settings!B22","v":"Flexi Earned"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J5,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[{"$f":"A5+1","v":3},{"$f":"Settings!B7","v":"Department"},{"$f":"IFERROR(INDEX('Leave Planner'!A:T,'Add Leave'!$A$1,A6+1),\"Multiple\")","v":"Multiple"}," ",null,null,null,null,null,{"$f":"Settings!B23","v":"Flexi Taken"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J6,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[4,{"$f":"Settings!B8","v":"Employee Number"},{"$f":"IFERROR(INDEX('Leave Planner'!A:T,'Add Leave'!$A$1,A7+1),\"Multiple\")","v":"Multiple"}," ",{"$f":"Settings!E12","v":"Total Flexi Time"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E7,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E7,LEN($E$15))=$E$15,1,0)","v":0},null,null,{"$f":"Settings!B24","v":"Purchased Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J7,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[5,{"$f":"Settings!B9","v":"Job Grade"},{"$f":"IFERROR(INDEX('Leave Planner'!A:T,'Add Leave'!$A$1,A8+1),\"Multiple\")","v":"Multiple"}," ",{"$f":"Settings!E13","v":"Taken Flexi Time"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E8,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E8,LEN($E$15))=$E$15,1,0)","v":0},null,null,{"$f":"Settings!B25","v":"Compassionate"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J8,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[6,{"$f":"Settings!B10","v":"Notes"},{"$f":"IFERROR(INDEX('Leave Planner'!A:T,'Add Leave'!$A$1,A9+1),\"Multiple\")","v":"Multiple"}," ",{"$f":"Settings!E14","v":"Remaining Flexi Time"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E9,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E9,LEN($E$15))=$E$15,1,0)","v":0},null,null,{"$f":"Settings!B26","v":"Sickness - Paid"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J9,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[null,null,null," ",null,null,null,null,null,{"$f":"Settings!B27","v":"Sickness - Unpaid"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J10,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[null,"Dates Selected","08/02/2018 - 10/02/2018 (3 dates)"," ",{"$f":"Settings!E15","v":"Total Purchased Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E11,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E11,LEN($E$15))=$E$15,1,0)","v":0},null,null,{"$f":"Settings!B28","v":"Public holidays"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J11,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[null,null,null," ",{"$f":"Settings!E16","v":"Taken Purchased Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E12,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E12,LEN($E$15))=$E$15,1,0)","v":0},null,null,{"$f":"Settings!B29","v":"Training"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J12,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[null,"Leave","Full Day Leave"," ",{"$f":"Settings!E17","v":"Remaining Purchased Leave"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(E13,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}},{"$f":"IF(RIGHT(E13,LEN($E$15))=$E$15,1,0)","v":0},null,null,{"$f":"Settings!B30","v":"Day in Lieu"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J13,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[null,null,null," ",null,null,null,null,null,{"$f":"Settings!B31","v":"Unpaid"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J14,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[null,"Amount per date",1," ",{"$f":"VLOOKUP(LeaveType,SavedLeaveTypes,2,FALSE)","v":"Annual Leave"},null,null,null,null,{"$f":"Settings!B32","v":"Work from home"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J15,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[null,null,null," ",null,null,null,null,null,{"$f":"Settings!B33","v":"Other"},{"$f":"OFFSET('Leave Planner'!$A$1,EmployeeRow-1,MATCH(J16,'Leave Planner'!$4:$4,0)-1)","v":{"$error":"#N/A"}}]
[null,"Notes",null," "]
[null,null,null," "]
[null,null,"Add Leave"]

{"sheet":"Leave Planner","index":4,"n_rows":4,"n_cols":407,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[0,"Menu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"MID(TEXT(AP4,\"MMMM YYYY\"),DAY(AP4),1)","v":{"$error":"#VALUE!"}},{"$f":"MID(TEXT(AQ4,\"MMMM YYYY\"),DAY(AQ4),1)","v":"J"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"MID(TEXT(DC4,\"MMMM YYYY\"),DAY(DC4),1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"MID(TEXT(FO4,\"MMMM YYYY\"),DAY(FO4),1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"MID(TEXT(IA4,\"MMMM YYYY\"),DAY(IA4),1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"MID(TEXT(KM4,\"MMMM YYYY\"),DAY(KM4),1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"MID(TEXT(MY4,\"MMMM YYYY\"),DAY(MY4),1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"WEEKDAY(AP4,FirstDayOfTheWeekNumber)","v":6},7]
[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,{"$f":"IF(VLOOKUP(AP2,Settings!$C$37:$E$43,3,FALSE)=\"Working\",IF(TEXT(AP4,\"ddd\")<>\"ddd\",LEFT(TEXT(AP4,\"ddd\"),1),LEFT(TEXT(AP4,\"ttt\"),1)),\"\")","v":"S"},{"$f":"IF(VLOOKUP(AQ2,Settings!$C$37:$E$43,3,FALSE)=\"Working\",IF(TEXT(AQ4,\"ddd\")<>\"ddd\",LEFT(TEXT(AQ4,\"ddd\"),1),LEFT(TEXT(AQ4,\"ttt\"),1)),\"\")","v":"S"}]
["ID",{"$f":"IF(Settings!$B5<>\"\",Settings!$B5,\"\")","v":"First Name"},{"$f":"IF(Settings!$B6<>\"\",Settings!$B6,\"\")","v":"Last Name"},{"$f":"IF(Settings!$B7<>\"\",Settings!$B7,\"\")","v":"Department"},{"$f":"IF(Settings!$B8<>\"\",Settings!$B8,\"\")","v":"Employee Number"},{"$f":"IF(Settings!$B9<>\"\",Settings!$B9,\"\")","v":"Job Grade"},{"$f":"IF(Settings!$B10<>\"\",Settings!$B10,\"\")","v":"Notes"},{"$f":"IF(Settings!$B11<>\"\",Settings!$B11,\"\")","v":"Misc1"},{"$f":"IF(Settings!$B12<>\"\",Settings!$B12,\"\")","v":"Misc2"},{"$f":"IF(Settings!$B13<>\"\",Settings!$B13,\"\")","v":"Misc3"},{"$f":"IF(Settings!$B14<>\"\",Settings!$B14,\"\")","v":"Misc4"},"Unused","Unused2",{"$f":"Settings!E5","v":"Leave Entitlement"},{"$f":"Settings!E6","v":"Leave Accrued"},{"$f":"Settings!E7","v":"Leave Carried Over"},{"$f":"Settings!E8","v":"Bonus Leave"},{"$f":"Settings!E9","v":"Total Annual Leave"},{"$f":"Settings!E10","v":"Taken Annual Leave"},{"$f":"Settings!E11","v":"Remaining Annual Leave"},{"$f":"Settings!E12","v":"Total Flexi Time"},{"$f":"Settings!E13","v":"Taken Flexi Time"},{"$f":"Settings!E14","v":"Remaining Flexi Time"},{"$f":"Settings!E15","v":"Total Purchased Leave"},{"$f":"Settings!E16","v":"Taken Purchased Leave"},{"$f":"Settings!E17","v":"Remaining Purchased Leave"},{"$f":"Settings!B20","v":"Full Day Leave"},{"$f":"Settings!B21","v":"Half Day Leave"},{"$f":"Settings!B22","v":"Flexi Earned"},{"$f":"Settings!B23","v":"Flexi Taken"},{"$f":"Settings!B24","v":"Purchased Leave"},{"$f":"Settings!B25","v":"Compassionate"},{"$f":"Settings!B26","v":"Sickness - Paid"},{"$f":"Settings!B27","v":"Sickness - Unpaid"},{"$f":"Settings!B28","v":"Public holidays"},{"$f":"Settings!B29","v":"Training"},{"$f":"Settings!B30","v":"Day in Lieu"},{"$f":"Settings!B31","v":"Unpaid"},{"$f":"Settings!B32","v":"Work from home"},{"$f":"Settings!B33","v":"Other"},"Unused",null,{"$f":"AP4+1","v":"1900-01-01"}]

{"sheet":"Records","index":5,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Date requested","Date confirmed","Date of leave","Date cancelled","EmployeeID","Leave type","From allocation","Add to column","Note"]

{"sheet":"Settings","index":6,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"Type of Leave","Show"]
[null,"Employee Information",null,"Leave Information",null,null,null,{"$f":"B20","v":"Full Day Leave"},false]
[null,null,null,null,null,null,null,{"$f":"B21","v":"Half Day Leave"},false]
[null,"Columns","Show",null,"Columns","Show",null,"Flexi Earned",false]
[null,{"$f":"IF('Setup 1'!B8<>\"\",'Setup 1'!B8,\"\")","v":"First Name"},true,null,{"$f":"'Setup 2'!B8","v":"Leave Entitlement"},true,null,"Flexi Taken",false]
[null,{"$f":"IF('Setup 1'!B9<>\"\",'Setup 1'!B9,\"\")","v":"Last Name"},true,null,{"$f":"'Setup 2'!B9","v":"Leave Accrued"},true,null,"Purchased Leave",false]
[null,{"$f":"IF('Setup 1'!B10<>\"\",'Setup 1'!B10,\"\")","v":"Department"},false,null,{"$f":"'Setup 2'!B10","v":"Leave Carried Over"},true,null,"Compassionate",false]
[null,{"$f":"IF('Setup 1'!B11<>\"\",'Setup 1'!B11,\"\")","v":"Employee Number"},false,null,{"$f":"'Setup 2'!B11","v":"Bonus Leave"},false,null,"Sickness - Paid",false]
[null,{"$f":"IF('Setup 1'!B12<>\"\",'Setup 1'!B12,\"\")","v":"Job Grade"},false,null,{"$f":"\"Total \" &'Setup 3'!F3","v":"Total Annual Leave"},false,null,"Sickness - Unpaid",false]
[null,{"$f":"IF('Setup 1'!B13<>\"\",'Setup 1'!B13,\"\")","v":"Notes"},false,null,{"$f":"\"Taken \" &'Setup 3'!F3","v":"Taken Annual Leave"},false,null,"Public holidays",false]
[null,{"$f":"IF('Setup 1'!B14<>\"\",'Setup 1'!B14,\"\")","v":"Misc1"},false,null,{"$f":"\"Remaining \" &'Setup 3'!F3","v":"Remaining Annual Leave"},false,null,"Training",false]
[null,{"$f":"IF('Setup 1'!B15<>\"\",'Setup 1'!B15,\"\")","v":"Misc2"},false,null,{"$f":"\"Total \" &'Setup 3'!F4","v":"Total Flexi Time"},false,null,{"$f":"B30","v":"Day in Lieu"},false]
[null,{"$f":"IF('Setup 1'!B16<>\"\",'Setup 1'!B16,\"\")","v":"Misc3"},false,null,{"$f":"\"Taken \" &'Setup 3'!F4","v":"Taken Flexi Time"},false,null,"Unpaid",false]
[null,{"$f":"IF('Setup 1'!B17<>\"\",'Setup 1'!B17,\"\")","v":"Misc4"},false,null,{"$f":"\"Remaining \" &'Setup 3'!F4","v":"Remaining Flexi Time"},false,null,"Work from home",false]
[null,null,null,null,{"$f":"\"Total \" &'Setup 3'!F5","v":"Total Purchased Leave"},false,null,"Other",false]
[null,null,null,null,{"$f":"\"Taken \" &'Setup 3'!F5","v":"Taken Purchased Leave"},false]
[null,"Buttons",null,null,{"$f":"\"Remaining \" &'Setup 3'!F5","v":"Remaining Purchased Leave"},false]
[null,null,null,null,null,null,null,null,null,null,null,null,"Defaults:"]
[null,"Type of Leave","From allocation","Default amount","Cell Text and Format",null,null,"Default leave types….  (these get copied into setup 4 sheet in prepare for share)",null,null,null,null,"Setup1","Setup2","Setup3"]
[null,"Full Day Leave","Annual Leave",1,"F",null,null,"Full Day Leave","Annual Leave",1,"F",null,"First Name","Leave Entitlement","Annual Leave"]
[null,"Half Day Leave","Annual Leave",0.5,"H",null,null,"Half Day Leave","Annual Leave",0.5,"H",null,"Last Name","Leave Accrued","Flexi Time"]
[null,"Flexi Earned","Flexi Time",0,"FE",null,null,"Flexi Earned","Flexi Time",0,"FE",null,"Department","Leave Carried Over","Purchased Leave"]
[null,"Flexi Taken","Flexi Time",1,"FT",null,null,"Flexi Taken","Flexi Time",1,"FT",null,"Employee Number","Bonus Leave"]
[null,"Purchased Leave","Purchased Leave",1,"P",null,null,"Purchased Leave","Purchased Leave",1,"P",null,"Job Grade"]
[null,"Compassionate",null,1,"C",null,null,"Compassionate",null,1,"C",null,"Notes"]
[null,"Sickness - Paid",null,1,"SP",null,null,"Sickness - Paid",null,1,"SP",null,"Misc1"]
[null,"Sickness - Unpaid",null,1,"SU",null,null,"Sickness - Unpaid",null,1,"SU",null,"Misc2"]
[null,"Public holidays",null,1,"PH",null,null,"Public holidays",null,1,"PH",null,"Misc3"]
[null,"Training",null,1,"T",null,null,"Training",null,1,"T",null,"Misc4"]
[null,"Day in Lieu",null,1,"L",null,null,"Day in Lieu",null,1,"L"]
[null,"Unpaid",null,1,"U",null,null,"Unpaid",null,1,"U"]
[null,"Work from home",null,1,"W",null,null,"Work from home",null,1,"W"]
[null,"Other",null,1,"O",null,null,"Other",null,1,"O"]
[]
[null,"Other Settings",null,"Working Days"]
[]
[null,null,{"$f":"IF(D37=$H$38,1,C43+1)","v":1},"Monday",{"$f":"ShowMonday","v":"Working"},1,null,"First day of the week"]
[null,null,{"$f":"IF(D38=$H$38,1,C37+1)","v":2},"Tuesday",{"$f":"ShowTuesday","v":"Working"},2,null,{"$f":"FirstDayOfTheWeek","v":"Monday"},{"$f":"IF(H38=D43,1,IF(H38=D37,2,VLOOKUP(H38,$D$38:$F$42,3,FALSE)+10))","v":2}]
[null,null,{"$f":"IF(D39=$H$38,1,C38+1)","v":3},"Wednesday",{"$f":"ShowWednesday","v":"Working"},3]
[null,null,4,"Thursday",{"$f":"ShowThursday","v":"Working"},4]
[null,null,5,"Friday",{"$f":"ShowFriday","v":"Working"},5]
[null,null,6,"Saturday",{"$f":"ShowSaturday","v":"Working"},6]
[null,null,7,"Sunday",{"$f":"ShowSunday","v":"Working"},7]
[]
[null,"Hidden settings"]
[null,"Version",2.5]
[null,"Mode","Production"]

{"sheet":"Setup 1","index":7,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Setup - Step 1 of 4"]
[null,"What information would you like to store about your employees?"]
[null,"You are allowed to store up to 10 different pieces of information about each employee. "]
[null,"This is used for sorting or filtering employees, and for reporting purposes."]
[]
[null,"Employee Information:"]
[1,"First Name"]
[2,"Last Name"]
[3,"Department"]
[4,"Employee Number"]
[5,"Job Grade"]
[6,"Notes"]
[7,"Misc1"]
[8,"Misc2"]
[9,"Misc3"]
[10,"Misc4",null,"Continue to step 2"]

{"sheet":"Setup 2","index":8,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Setup - Step 2 of 4"]
[null,"What information would you like to store about total leave?"]
[null,"You are allowed to store 4 different pieces of information which make up the total leave. "]
[null,"These 4 numbers are added together to calculate the Total Leave allocation."]
[]
[null,"Total Leave ="]
[1,"Leave Entitlement","+"]
[2,"Leave Accrued","+"]
[3,"Leave Carried Over","+"]
[4,"Bonus Leave",null,"Continue to Step 3"]

{"sheet":"Setup 3","index":9,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Setup - Step 3 of 4",null,null,null,"Leave categories:"]
[null,"What different types of leave would you like to use?",null,null,null,"Annual Leave"]
[null,"We allow 14 different types of leave in the tool",null,null,null,"Flexi Time"]
[null,"You can use them however you wish. Please read the instructions carefully.",null,null,null,"Purchased Leave"]
[]
[null,"Types of Leave","From allocation","Default amount","Cell Format & Text"]
[null,"Full Day Leave","Annual Leave",1,"F"]
[null,"Half Day Leave","Annual Leave",0.5,"H"]
[null,"Flexi Earned","Flexi Time",0,"FE"]
[null,"Flexi Taken","Flexi Time",1,"FT"]
[null,"Purchased Leave","Purchased Leave",1,"P"]
[null,"Compassionate",null,1,"C"]
[null,"Sickness - Paid",null,1,"SP"]
[null,"Sickness - Unpaid",null,1,"SU"]
[null,"Public holidays",null,1,"PH"]
[null,"Training",null,1,"T"]
[null,"Day in Lieu",null,1,"L"]
[null,"Unpaid",null,1,"U"]
[null,"Work from home",null,1,"W"]
[null,"Other",null,1,"O"]
[]
[null,null,null,null,null,"Continue to Step 4"]

{"sheet":"Setup 4","index":10,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Setup - Step 4 of 4"]
[null,"What days of the week do you work?"]
[null,"The tool will highlight working vs non-working days differently"]
[null,"Configure your working week here",null,null,{"$f":"NOW()-365","v":"2017-02-28T11:16:58.190"}]
[null,null,null,null,{"$f":"NOW()+1000","v":"2020-11-24T11:16:58.190"}]
[null,"Day of the week","Working or Non-Working"]
[null,"Monday","Working",null,"First day of the week"]
[null,"Tuesday","Working",null,"Monday"]
[null,"Wednesday","Working"]
[null,"Thursday","Working",null,"Year Start Date"]
[null,"Friday","Working"]
[null,"Saturday","Working"]
[null,"Sunday","Working",null,"Complete Setup"]

{"sheet":"Help","index":11,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,{"$f":"\"v\" &Version","v":"v2.5"}]
[]
[]
[null,null,"This free Team Holiday Spreadsheet was created by:"]
[null,null,"http://www.excel-macros.co.uk/"]
[null,null,"Please visit the site to download more free Excel tools and games"]
[null,null,"We really hope you have found this tool useful"]
[]
[null,null,"If you need any help or advice please contact us on:"]
[]
[null,null,"Great@Excel-Macros.co.uk"]