{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data Set","Record","Monthly Leave Record","Annual Leave"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Data Set","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Basic Information"]
[]
[null,"ID","Name",null,"Month",null,"Leave Type","Code"]
[null,"E-10001","Jessica",null,"2022-01-01",null,"Casual Leave","CL"]
[null,"E-10002","Henderson",null,"2022-02-01",null,"Sick Leave","SL"]
[null,"E-10003","Aaron",null,"2022-03-01",null,"Festive Leave","FL"]
[null,"E-10004","Mitchel",null,"2022-04-01",null,"Maternity Leave","ML"]
[null,"E-10005","John",null,"2022-05-01",null,"Unpaid Leave","UL"]
[null,"E-10006","Allisa",null,"2022-06-01"]
[null,"E-10007","Jose",null,"2022-07-01"]
[null,"E-10008","Joe",null,"2022-08-01"]
[null,"E-10009","Josef",null,"2022-09-01"]
[null,"E-10010","Rogers",null,"2022-10-01"]
[null,null,null,null,"2022-11-01"]
[null,null,null,null,"2022-12-01"]

{"sheet":"Record","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Leave Record"]
[]
[null,"Leave ID","Employee ID","Name","Date","Leave Code"]
[null,{"$f":"C5&E5","v":"E-1000144564"},"E-10001",{"$f":"IFERROR(VLOOKUP(C5,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Jessica"},"2022-01-03","SL"]
[null,{"$f":"C6&E6","v":"E-1000844574"},"E-10008",{"$f":"IFERROR(VLOOKUP(C6,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Joe"},"2022-01-13","UL"]
[null,"E-1000644593","E-10006",{"$f":"IFERROR(VLOOKUP(C7,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Allisa"},"2022-02-01","UL"]
[null,"E-1000644602","E-10006",{"$f":"IFERROR(VLOOKUP(C8,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Allisa"},"2022-02-10","FL"]
[null,"E-1000344620","E-10003",{"$f":"IFERROR(VLOOKUP(C9,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Aaron"},"2022-02-28","ML"]
[null,"E-1000944634","E-10009",{"$f":"IFERROR(VLOOKUP(C10,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Josef"},"2022-03-14","SL"]
[null,"E-1000644675","E-10006",{"$f":"IFERROR(VLOOKUP(C11,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Allisa"},"2022-04-24","ML"]
[null,"E-1000444687","E-10004",{"$f":"IFERROR(VLOOKUP(C12,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Mitchel"},"2022-05-06","ML"]
[null,"E-1000844701","E-10008",{"$f":"IFERROR(VLOOKUP(C13,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Joe"},"2022-05-20","SL"]
[null,"E-1001044706","E-10010",{"$f":"IFERROR(VLOOKUP(C14,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Rogers"},"2022-05-25","SL"]
[null,"E-1001044724","E-10010",{"$f":"IFERROR(VLOOKUP(C15,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Rogers"},"2022-06-12","FL"]
[null,"E-1000144727","E-10001",{"$f":"IFERROR(VLOOKUP(C16,'Data Set'!$B$5:$C$14,2,0),\"\")","v":"Jessica"},"2022-06-15","FL"]
[null,"E-1001045440","E-10010","Rogers","2024-05-28","CL"]
[null,"E-1001045441","E-10010","Rogers","2024-05-29","CL"]
[null,"E-1001045442","E-10010","Rogers","2024-05-30","CL"]
[null,"E-1001045443","E-10010","Rogers","2024-05-31","CL"]

{"sheet":"Monthly Leave Record","index":2,"n_rows":18,"n_cols":40,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,39,7,39],[5,34,6,34],[5,35,6,35],[5,36,6,36],[5,37,6,37],[5,38,6,38],[3,14,3,17],[3,18,3,19],[5,3,5,33],[1,1,1,38],[5,1,7,1],[5,2,7,2],[3,3,3,4],[3,8,3,11]]}
[]
[null,"Monthwise Leave Record"]
[]
[null,null,null,"Month",null,null,null,null,"Month Number",null,null,null,2,null,"Starting of Month",null,null,null,{"$f":"INDEX('Data Set'!E5:E16,'Monthly Leave Record'!M4)","v":"2022-02-01"}]
[]
[null,"ID","Name",{"$f":"S4","v":"2022-02-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Casual Leave","Sick Leave","Festive Leave","Maternity Leave","Unpaid Leave","Total"]
[null,null,null,{"$f":"S4","v":"2022-02-01"},{"$f":"IF(D7=\"\",\"\",IF(EOMONTH($S$4,0)<D7+1,\"\",D7+1))","v":"2022-02-02"},{"$f":"IF(E7=\"\",\"\",IF(EOMONTH($S$4,0)<E7+1,\"\",E7+1))","v":"2022-02-03"},"2022-02-04","2022-02-05","2022-02-06","2022-02-07","2022-02-08","2022-02-09","2022-02-10","2022-02-11","2022-02-12","2022-02-13","2022-02-14","2022-02-15","2022-02-16","2022-02-17","2022-02-18","2022-02-19","2022-02-20","2022-02-21","2022-02-22","2022-02-23","2022-02-24","2022-02-25","2022-02-26","2022-02-27","2022-02-28","","",""]
[null,null,null,{"$f":"TEXT(D7,\"ddd\")","v":"Tue"},{"$f":"TEXT(E7,\"ddd\")","v":"Wed"},"Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","","","","CL","SL","FL","ML","UL"]
[null,"E-10001","Jessica",{"$f":"IFERROR(VLOOKUP($B9&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"COUNTIF($D9:$AE9,AI$8)","v":0},{"$f":"COUNTIF($D9:$AE9,AJ$8)","v":0},0,0,0,{"$f":"SUM(AI9:AM9)","v":0}]
[null,"E-10002","Henderson",{"$f":"IFERROR(VLOOKUP($B10&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"COUNTIF($D10:$AE10,AI$8)","v":0},0,0,0,0,{"$f":"SUM(AI10:AM10)","v":0}]
[null,"E-10003","Aaron",{"$f":"IFERROR(VLOOKUP($B11&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&AE$7,Record!$B:$F,5,FALSE),\"\")","v":"ML"},{"$f":"IFERROR(VLOOKUP($B11&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},0,0,0,1,0,1]
[null,"E-10004","Mitchel",{"$f":"IFERROR(VLOOKUP($B12&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},0,0,0,0,0,0]
[null,"E-10005","John",{"$f":"IFERROR(VLOOKUP($B13&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B13&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},0,0,0,0,0,0]
[null,"E-10006","Allisa",{"$f":"IFERROR(VLOOKUP($B14&D$7,Record!$B:$F,5,FALSE),\"\")","v":"UL"},{"$f":"IFERROR(VLOOKUP($B14&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&M$7,Record!$B:$F,5,FALSE),\"\")","v":"FL"},{"$f":"IFERROR(VLOOKUP($B14&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},0,0,1,0,1,2]
[null,"E-10007","Jose",{"$f":"IFERROR(VLOOKUP($B15&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},0,0,0,0,0,0]
[null,"E-10008","Joe",{"$f":"IFERROR(VLOOKUP($B16&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},0,0,0,0,0,0]
[null,"E-10009","Josef",{"$f":"IFERROR(VLOOKUP($B17&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B17&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},0,0,0,0,0,0]
[null,"E-10010","Rogers",{"$f":"IFERROR(VLOOKUP($B18&D$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&E$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&F$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&G$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&H$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&I$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&J$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&K$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&L$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&M$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&N$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&O$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&P$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&Q$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&R$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&S$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&T$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&U$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&V$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&W$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&X$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&Y$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&Z$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&AA$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&AB$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&AC$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&AD$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&AE$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&AF$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&AG$7,Record!$B:$F,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B18&AH$7,Record!$B:$F,5,FALSE),\"\")","v":""},0,0,0,0,0,0]

{"sheet":"Annual Leave","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,7,8],[5,1,7,1],[5,2,7,2],[5,3,6,3],[5,4,6,4]]}
[]
[null,"Annual Leave Record"]
[]
[null,null,null,"Start","2022-01-01","End","2022-12-31"]
[]
[null,"ID","Name","Casual Leave","Sick Leave","Festive Leave","Maternity Leave","Unpaid Leave","Total"]
[]
[null,null,null,"CL","SL","FL","ML","UL"]
[null,"E-10001","Jessica",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B9,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B9,Record!$F:$F,'Annual Leave'!E$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B9,Record!$F:$F,'Annual Leave'!F$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B9,Record!$F:$F,'Annual Leave'!G$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B9,Record!$F:$F,'Annual Leave'!H$8)","v":0},{"$f":"SUM(D9:H9)","v":2}]
[null,"E-10002","Henderson",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B10,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B10,Record!$F:$F,'Annual Leave'!E$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B10,Record!$F:$F,'Annual Leave'!F$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B10,Record!$F:$F,'Annual Leave'!G$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B10,Record!$F:$F,'Annual Leave'!H$8)","v":0},{"$f":"SUM(D10:H10)","v":0}]
[null,"E-10003","Aaron",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B11,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B11,Record!$F:$F,'Annual Leave'!E$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B11,Record!$F:$F,'Annual Leave'!F$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B11,Record!$F:$F,'Annual Leave'!G$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B11,Record!$F:$F,'Annual Leave'!H$8)","v":0},1]
[null,"E-10004","Mitchel",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B12,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B12,Record!$F:$F,'Annual Leave'!E$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B12,Record!$F:$F,'Annual Leave'!F$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B12,Record!$F:$F,'Annual Leave'!G$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B12,Record!$F:$F,'Annual Leave'!H$8)","v":0},1]
[null,"E-10005","John",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B13,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B13,Record!$F:$F,'Annual Leave'!E$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B13,Record!$F:$F,'Annual Leave'!F$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B13,Record!$F:$F,'Annual Leave'!G$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B13,Record!$F:$F,'Annual Leave'!H$8)","v":0},0]
[null,"E-10006","Allisa",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B14,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B14,Record!$F:$F,'Annual Leave'!E$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B14,Record!$F:$F,'Annual Leave'!F$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B14,Record!$F:$F,'Annual Leave'!G$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B14,Record!$F:$F,'Annual Leave'!H$8)","v":1},3]
[null,"E-10007","Jose",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B15,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B15,Record!$F:$F,'Annual Leave'!E$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B15,Record!$F:$F,'Annual Leave'!F$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B15,Record!$F:$F,'Annual Leave'!G$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B15,Record!$F:$F,'Annual Leave'!H$8)","v":0},0]
[null,"E-10008","Joe",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B16,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B16,Record!$F:$F,'Annual Leave'!E$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B16,Record!$F:$F,'Annual Leave'!F$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B16,Record!$F:$F,'Annual Leave'!G$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B16,Record!$F:$F,'Annual Leave'!H$8)","v":1},2]
[null,"E-10009","Josef",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B17,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B17,Record!$F:$F,'Annual Leave'!E$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B17,Record!$F:$F,'Annual Leave'!F$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B17,Record!$F:$F,'Annual Leave'!G$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B17,Record!$F:$F,'Annual Leave'!H$8)","v":0},1]
[null,"E-10010","Rogers",{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B18,Record!$F:$F,'Annual Leave'!D$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B18,Record!$F:$F,'Annual Leave'!E$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B18,Record!$F:$F,'Annual Leave'!F$8)","v":1},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B18,Record!$F:$F,'Annual Leave'!G$8)","v":0},{"$f":"COUNTIFS(Record!$E:$E,\">=\"&'Annual Leave'!$E$4,Record!$E:$E,\"<=\"&'Annual Leave'!$G$4,Record!$C:$C,'Annual Leave'!$B18,Record!$F:$F,'Annual Leave'!H$8)","v":0},2]