{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Holiday Card","Auto Part-time worksheet","Grade Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":17,"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 Card","index":0,"n_rows":66,"n_cols":8,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Manual Annual Leave Calculation",null,null,{"$f":"'Auto Part-time worksheet'!A8","v":"Bank Holidays loaded from: 01/01/2018 to 01/04/2024"}]
["Leave year start","2023-04-01",{"$f":"\"Leave Year end: \"&TEXT((DATE(YEAR(B2)+1,MONTH(B2),DAY(B2))-1),\"dd/mm/yyyy\")","v":"Leave Year end: 31/03/2024"},null,null,{"$f":"'Auto Part-time worksheet'!H71+'Auto Part-time worksheet'!O71&\"  Bank holidays in calculations\"","v":"10  Bank holidays in calculations"},null,"All bank holidays in this leave year"]
["Staff name","Employee Name",null,{"$f":"(IF(NOT($B$9=Standard_Week),\"Enter Working Pattern in Hours below\",\"Post is Full Time, 7.4 hours each day Mon-Fri\"))","v":"Post is Full Time, 7.4 hours each day Mon-Fri"},null,{"$f":"_xlfn._xlws.FILTER('Auto Part-time worksheet'!$Q$53:$Q$62,_xlfn.XLOOKUP(1,'Auto Part-time worksheet'!$P$10:$P$63,Bank_hols))","v":"2023-04-07"},null,"2023-04-07"]
["Post name","Employee Post Name",null,{"$f":"IF($B$9=37,\"\",\"Mon\")","v":""},null,"2023-04-10",null,"2023-04-10"]
["Grade","GRD7-GRD8",{"$f":"'Auto Part-time worksheet'!C76","v":"NJC (Green Book)"},{"$f":"IF($B$9=37,\"\",\"Tue\")","v":""},null,"2023-05-01",null,"2023-05-01"]
["Hols Period Start or Start date","2023-04-01",null,{"$f":"IF($B$9=37,\"\",\"Wed\")","v":""},null,"2023-05-08",null,"2023-05-08"]
["Cont Service Date",null,null,{"$f":"IF($B$9=37,\"\",\"Thu\")","v":""},null,"2023-05-29",null,"2023-05-29"]
["Contract End Date",null,null,{"$f":"IF($B$9=37,\"\",\"Fri\")","v":""},null,"2023-08-28",null,"2023-08-28"]
["Hours in Your Working Week",37,null,{"$f":"IF($B$9=37,\"\",\"Sat\")","v":""},null,"2023-12-25",null,"2023-12-25"]
["Base Days Ent.",{"$f":"'Auto Part-time worksheet'!B83","v":28},null,{"$f":"(IF(NOT($B$9=Standard_Week),(IF(NOT('Auto Part-time worksheet'!$H$66=($B$9)),\"Sub-total\",\"\")),\"\"))","v":""},{"$f":"(IF(NOT($B$9=37),(IF(NOT('Auto Part-time worksheet'!H66=($B$9)),SUM($E$4:$E$9),\"\")),\"\"))","v":""},"2023-12-26",null,"2023-12-26"]
["Years Service at Holiday Start",{"$f":"'Auto Part-time worksheet'!B82","v":0},null,null,{"$f":"(IF(NOT(ROUND($B$9,10)=Standard_Week),(IF(NOT(ROUND('Auto Part-time worksheet'!$H$66,10)=ROUND($B$9,10)),\"Doesn't match Your Working Week\",\"\")),\"\"))","v":""},"2024-01-01",null,"2024-01-01"]
[null,null,null,"Hours Carried Forward",null,"2024-03-29",null,"2024-03-29"]
[]
[]
[]
["Holiday Card for ",{"$f":"TEXT('Auto Part-time worksheet'!$B$1,\"dd/mm/yyyy\")&\" to \"&TEXT('Auto Part-time worksheet'!$D$1,\"dd/mm/yyyy\")","v":"01/04/2023 to 31/03/2024"}]
[]
["Name",{"$f":"B3","v":"Employee Name"},null,{"$f":"'Auto Part-time worksheet'!D67","v":""}]
["Post name",{"$f":"B4","v":"Employee Post Name"},null,{"$f":"IF(NOT(Working_Week=Standard_Week),Working_Week,\"\")","v":""},{"$f":"IF(NOT(Working_Week=Standard_Week),\"= std hours\",\"\")","v":""}]
[null,null,null,{"$f":"(IF(Working_Week=Standard_Week,(ROUND('Auto Part-time worksheet'!B104,1))&'Auto Part-time worksheet'!C104,ROUND(D22/7.4,1)&\" days entitlement\"))","v":"28 days entitlement"}]
[null,null,"Carried Forward",{"$f":"E12","v":0},{"$f":"IF(D13=\"\",\"\",D13)","v":""}]
[null,null,"Total hours for this year",{"$f":"IF(Working_Week=Standard_Week,IF(B13=\"No\",A65+C65,B65+D65),B65+D65)","v":207.20000000000002},"Hours"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'Auto Part-time worksheet'!D104","v":207.20000000000002},{"$f":"IF(B13=\"Yes\",'Auto Part-time worksheet'!E104,'Auto Part-time worksheet'!B102)","v":207.20000000000002},{"$f":"E12","v":0},{"$f":"IF(E12<0,E12/24,E12)","v":0}]
["Hours for full timers","Hours for 9 days","C/F days","C/F hours"]

{"sheet":"Auto Part-time worksheet","index":1,"n_rows":117,"n_cols":17,"rows_kept":117,"cut":false,"hidden":true,"merged":[[7,1,7,6],[7,8,7,14]]}
["New Automatic Annual Leave calculation",{"$f":"'Holiday Card'!B2","v":"2023-04-01"},"to",{"$f":"(DATE(YEAR(B1)+1,MONTH(B1),DAY(B1))-1)","v":"2024-03-31"}]
[]
["Name",{"$f":"'Holiday Card'!B3","v":"Employee Name"}]
[]
["Job Title",{"$f":"'Holiday Card'!B4","v":"Employee Post Name"}]
[]
["Number of hours worked per week:",{"$f":"'Holiday Card'!B9","v":37},null,"Standard week",{"$f":"37","v":37}]
[{"$f":"\"Bank Holidays loaded from: \"&TEXT(MIN(A10:A63),\"dd/mm/yyyy\")&\" to \"&TEXT(MAX(A10:A63),\"dd/mm/yyyy\")","v":"Bank Holidays loaded from: 01/01/2018 to 01/04/2024"},"-------------------Base period for single annual entitlement ---------------------",null,null,null,null,null,"Weekday","-------Additional entitlement for service anniversary increase------"]
["Bank Holiday Date","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday",null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday",null,"IsBH","BHToReturn"]
["2018-01-01",{"$f":"IF(AND($A10>Hol_Period_Start-1,$A10<BaseRatePeriodEnd+1,B$9=$H10),1,0)","v":0},0,0,0,0,0,{"$f":"CHOOSE(WEEKDAY(A10),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Monday"},{"$f":"IF(AND($A10>BaseRatePeriodEnd,$A10<HolEndDate+1,I$9=$H10),1,0)","v":0},0,0,0,0,0,null,{"$f":"SUM(B10:G10)","v":0},{"$f":"IF(P10=1,A10,\"\")","v":""}]
["2018-03-30",{"$f":"IF(AND($A11>$B$77-1,$A11<$B$80+1,B$9=$H11),1,0)","v":0},0,0,0,0,0,{"$f":"CHOOSE(WEEKDAY(A11),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Friday"},0,0,0,0,0,0,null,{"$f":"SUM(B11:G11)","v":0},{"$f":"IF(P11=1,A11,\"\")","v":""}]
["2018-04-02",0,0,0,0,0,0,"Monday",{"$f":"IF(AND($A12>$B$80,$A12<$B$81+1,I$9=$H12),1,0)","v":0},0,0,0,0,0,null,0,""]
["2018-05-07",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2018-05-28",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2018-08-27",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2018-12-25",0,0,0,0,0,0,"Tuesday",0,0,0,0,0,0,null,0,""]
["2018-12-26",0,0,0,0,0,0,"Wednesday",0,0,0,0,0,0,null,0,""]
["2019-01-01",0,0,0,0,0,0,"Tuesday",0,0,0,0,0,0,null,0,""]
["2019-04-19",0,0,0,0,0,0,"Friday",0,0,0,0,0,0,null,0,""]
["2019-04-22",0,0,0,0,0,0,{"$f":"CHOOSE(WEEKDAY(A20),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Monday"},0,0,0,0,0,0,null,0,""]
["2019-05-06",{"$f":"IF(AND($A21>$B$77-1,$A21<$B$80+1,B$9=$H21),1,0)","v":0},0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2019-05-27",0,0,0,0,0,0,"Monday",{"$f":"IF(AND($A22>$B$80,$A22<$B$81+1,I$9=$H22),1,0)","v":0},0,0,0,0,0,null,0,""]
["2019-08-26",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2019-12-25",0,0,0,0,0,0,"Wednesday",0,0,0,0,0,0,null,0,""]
["2019-12-26",0,0,0,0,0,0,"Thursday",0,0,0,0,0,0,null,0,""]
["2020-01-01",0,0,0,0,0,0,"Wednesday",0,0,0,0,0,0,null,0,""]
["2020-04-10",0,0,0,0,0,0,"Friday",0,0,0,0,0,0,null,0,""]
["2020-04-13",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2020-05-08",0,0,0,0,0,0,"Friday",0,0,0,0,0,0,null,0,""]
["2020-05-25",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2020-08-31",{"$f":"IF(AND($A31>$B$77-1,$A31<$B$80+1,B$9=$H31),1,0)","v":0},0,0,0,0,0,{"$f":"CHOOSE(WEEKDAY(A31),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Monday"},0,0,0,0,0,0,null,0,""]
["2020-12-25",0,0,0,0,0,0,{"$f":"CHOOSE(WEEKDAY(A32),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Friday"},{"$f":"IF(AND($A32>$B$80,$A32<$B$81+1,I$9=$H32),1,0)","v":0},0,0,0,0,0,null,0,""]
["2020-12-28",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2021-01-01",0,0,0,0,0,0,"Friday",0,0,0,0,0,0,null,0,""]
["2021-04-02",0,0,0,0,0,0,"Friday",0,0,0,0,0,0,null,0,""]
["2021-04-05",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2021-05-03",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2021-05-31",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2021-08-30",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2021-12-27",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2021-12-28",{"$f":"IF(AND($A41>$B$77-1,$A41<$B$80+1,B$9=$H41),1,0)","v":0},0,0,0,0,0,"Tuesday",0,0,0,0,0,0,null,0,""]
["2022-01-03",0,0,0,0,0,0,"Monday",{"$f":"IF(AND($A42>$B$80,$A42<$B$81+1,I$9=$H42),1,0)","v":0},0,0,0,0,0,null,0,""]
["2022-04-15",0,0,0,0,0,0,"Friday",0,0,0,0,0,0,null,0,""]
["2022-04-18",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2022-05-02",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2022-06-02",0,0,0,0,0,0,"Thursday",0,0,0,0,0,0,null,0,""]
["2022-06-03",0,0,0,0,0,0,"Friday",0,0,0,0,0,0,null,0,""]
["2022-08-29",0,0,0,0,0,0,{"$f":"CHOOSE(WEEKDAY(A48),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Monday"},0,0,0,0,0,0,null,0,""]
["2022-09-19",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2022-12-26",0,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,0,""]
["2022-12-27",{"$f":"IF(AND($A51>$B$77-1,$A51<$B$80+1,B$9=$H51),1,0)","v":0},0,0,0,0,0,"Tuesday",0,0,0,0,0,0,null,0,""]
["2023-01-02",0,0,0,0,0,0,"Monday",{"$f":"IF(AND($A52>$B$80,$A52<$B$81+1,I$9=$H52),1,0)","v":0},0,0,0,0,0,null,0,""]
["2023-04-07",0,0,0,0,1,0,"Friday",0,0,0,0,0,0,null,1,"2023-04-07"]
["2023-04-10",1,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,1,"2023-04-10"]
["2023-05-01",1,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,1,"2023-05-01"]
["2023-05-08",1,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,1,"2023-05-08"]
["2023-05-29",1,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,1,"2023-05-29"]
["2023-08-28",1,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,1,"2023-08-28"]
["2023-12-25",1,0,0,0,0,0,{"$f":"CHOOSE(WEEKDAY(A59),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Monday"},0,0,0,0,0,0,null,1,"2023-12-25"]
["2023-12-26",0,1,0,0,0,0,"Tuesday",0,0,0,0,0,0,null,1,"2023-12-26"]
["2024-01-01",1,0,0,0,0,0,"Monday",0,0,0,0,0,0,null,1,"2024-01-01"]
["2024-03-29",0,0,0,0,1,0,{"$f":"CHOOSE(WEEKDAY(A62),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Friday"},0,0,0,0,0,0,null,1,"2024-03-29"]
["2024-04-01",0,0,0,0,0,0,{"$f":"CHOOSE(WEEKDAY(A63),\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\")","v":"Monday"},0,0,0,0,0,0,null,0,""]
[null,"Mon","Tues","Wed","Thurs","Fri","Sat","Total"]
[]
["DAILY HOURS:",{"$f":"'Holiday Card'!E4","v":0},{"$f":"'Holiday Card'!E5","v":0},{"$f":"'Holiday Card'!E6","v":0},{"$f":"'Holiday Card'!E7","v":0},{"$f":"'Holiday Card'!E8","v":0},{"$f":"'Holiday Card'!E9","v":0},{"$f":"SUM(B66:G66)","v":0},{"$f":"B66","v":0},0,0,0,0,0,{"$f":"ROUND(SUM(I66:N66),10)","v":0}]
[null,null,null,{"$f":"IF(AND(NOT(Working_Week=ROUND(H66,10)),NOT(Working_Week=Standard_Week)),\"Wrong Result!  Working pattern does not match Your Working Week Hours\",\"\")","v":""}]
[]
[null,"Mon","Tues","Wed","Thurs","Fri","Sat","Total","Mon","Tues","Wed","Thurs","Fri","Sat","Total"]
["Number of Bank Holidays which fall "]
["within the part year:",{"$f":"SUM(B10:B63)","v":7},1,0,0,2,0,{"$f":"SUM(B71:G71)","v":10},{"$f":"SUM(I10:I63)","v":0},0,0,0,0,0,{"$f":"SUM(I71:N71)","v":0}]
["Total hours worked",{"$f":"SUM(B71*B66)","v":0},0,0,0,0,0,{"$f":"SUM(B72:G72)","v":0},{"$f":"SUM(I71*I66)","v":0},0,0,0,0,0,{"$f":"SUM(I72:N72)","v":0}]
[]
["(A) Pro rata entitlement ",null,null,null,null,null,null,{"$f":"(H71*7.4)/37","v":2}]
["Grade",{"$f":"'Holiday Card'!B5","v":"GRD7-GRD8"},null,null,null,null,null,{"$f":"H74*H66","v":0}]
["Scale Point",null,{"$f":"IF(ISERROR(VLOOKUP(B75&C82,Grade_Table,4,FALSE)),\"NO ENTITLEMENT FOR THIS GRADE/SCALE COMBINATION\",(VLOOKUP(B75&C82,Grade_Table,4,FALSE)))","v":"NJC (Green Book)"}]
["Hols Period Start or Start date",{"$f":"IF('Holiday Card'!B6=\"\",B1,'Holiday Card'!B6)","v":"2023-04-01"}]
["Continuous Service Date",{"$f":"IF('Holiday Card'!B7=\"\",B77,'Holiday Card'!B7)","v":"2023-04-01"},{"$f":"(DATE(YEAR(B1)+(DATE(YEAR(B1),MONTH(B78),DAY(B78))<=B1),MONTH(B78),DAY(B78)))-1","v":"2024-03-31"}]
["Hols Period End (or blank if end of Holiday Year)",{"$f":"IF(OR('Holiday Card'!B8=\"\",'Holiday Card'!B8>D1-1),D1,'Holiday Card'!B8)","v":"2024-03-31"}]
["Base rate period end",{"$f":"IF(AND(AND(C78+1>B77,C78<B81+1),(OR(B82=4,B82=9))),C78,B81)","v":"2024-03-31"},{"$f":"DATEDIF(B$77,(B80),\"ym\")+(DATEDIF(B$77,B80,\"md\"))/(DAY(DATE(YEAR(B81),MONTH(B81)+1,1)-1))","v":11.967741935483872}]
["Calculation holiday period end",{"$f":"IF(B79=\"\",D1,B79)","v":"2024-03-31"},{"$f":"DATEDIF(B$77,(B81),\"ym\")+(DATEDIF(B$77,B81,\"md\")+1)/(DAY(DATE(YEAR(B81),MONTH(B81)+1,1)-1))","v":12},null,null,null,null,null,{"$f":"DATEDIF(B$80,(B81),\"ym\")+(DATEDIF(B$80,B81,\"md\")+1)/(DAY(DATE(YEAR(B81),MONTH(B81)+1,1)-1))","v":3.2258064516129031E-2}]
["Years service and Band",{"$f":"IF(OR(B78>B1,B78=\"\"),0,DATEDIF(B78,B77,\"y\"))","v":0},{"$f":"IF(AND(B75=\"NHSconsultant\",B82<7),\"7-\",(IF(AND(B75=\"NHSconsultant\",B82>6),\"7+\",(IF(B82>9,\"10+\",IF(B82<5,\"5-\",IF(AND(B82>4,B82<10),\">5<10\",\"10+\")))))))","v":"5-"}]
["Full-time entitlement in days",{"$f":"IF(ISERROR(VLOOKUP(B75&C82,Grade_Table,7,FALSE)),\"NO ENTITLEMENT FOR THIS GRADE/SCALE COMBINATION\",(VLOOKUP(B75&C82,Grade_Table,7,FALSE)))","v":28},{"$f":"B83/12","v":2.3333333333333335},"days/month",null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP((B75&B76&(IF(C82=\"5-\",\">5<10\",IF(C82=\"7-\",\"7+\",IF(C82=\"7+\",\"7+\",IF(C82=\">5<10\",\"10+\",\"10+\")))))),Grade_Table,7,FALSE)),\"NO ENTITLEMENT\",(VLOOKUP((B75&B76&(IF(C82=\"5-\",\">5<10\",IF(C82=\"7-\",\"7+\",IF(C82=\"7+\",\"7+\",IF(C82=\">5<10\",\"10+\",\"10+\")))))),Grade_Table,7,FALSE)))","v":30},{"$f":"I83/12","v":2.5},"days/month"]
["Entitlement in hours",{"$f":"SUM(B83)*7.4","v":207.20000000000002},"hours",null,null,null,null,null,{"$f":"SUM(I83)*7.4","v":222},"hours"]
["Proportion of year worked",{"$f":"IF(OR(B77>B80,B77>B81),0,(IF(B80+1>B81,C81,C80)))","v":12},"in months",null,null,null,null,null,{"$f":"IF(B81<B80+1,0,I81)","v":0},"in months"]
["Pro rata entitlement for months worked if F/T",{"$f":"B85*C83","v":28},"days","or",{"$f":"SUM(B86*7.4)","v":207.20000000000002},null,"hours/minutes",null,{"$f":"I85*J83","v":0},"days","or",{"$f":"SUM(I86*7.4)","v":0},null,"hours/minutes"]
["(A) Therefore entitlement for part-time hours",{"$f":"SUM((Working_Week/Standard_Week)*B86)","v":28},"days","or",{"$f":"B87*7.4","v":207.20000000000002},null,"hours/minutes",null,{"$f":"SUM((Working_Week/Standard_Week)*I86)","v":0},"days","or",{"$f":"(I87*7.4)","v":0},null,"hours/minutes"]
[]
["Bank Holiday Entitlement "]
["Bank Holiday hrs for part year if full-time",{"$f":"SUM(H71*7.4)","v":74},"hours",null,null,null,null,null,{"$f":"SUM(O71*7.4)","v":0},"hours"]
["Pro rata entitlement to Bank Holiday hours",{"$f":"SUM(((H71*7.4)/37*H66))","v":0},"hours/minutes",null,null,null,null,null,{"$f":"SUM(((O71*7.4)/37*O66))","v":0},"hours/minutes"]
["Employee's Bank Holiday hours ",{"$f":"SUM(H72)","v":0},"hours/minutes",null,null,null,null,null,{"$f":"SUM(O72)","v":0},"hours/minutes"]
["(B) Bank Holiday Adjustment (Difference)",{"$f":"IF(Working_Week=Standard_Week,0,ABS(B92-B91))","v":0},{"$f":"IF(B92>B91,\"(Minus)\",\"\")","v":""},"hrs/mins",null,null,null,null,{"$f":"IF(Working_Week=Standard_Week,0,ABS(I92-I91))","v":0},{"$f":"IF(I92>I91,\"(Minus)\",\"\")","v":""},"hrs/mins"]
[{"$f":"IF(Working_Week=0,\"WARNING: WEEKLY HOURS NOT ENTERED IN CELL working_week\",\"\")","v":""}]
["(C) Pro Rata Holiday Entitlement"]
["Annual leave in hours (A)",{"$f":"E87","v":207.20000000000002},"hours/minutes",null,null,null,null,null,{"$f":"L87","v":0},"hours/minutes"]
["Bank Holiday Adjustment (Difference) (B) ",{"$f":"IF(NOT(Working_Week=Standard_Week),ABS(B92-B91),0)","v":0},"hrs/mins",null,null,null,null,null,{"$f":"IF(NOT(Working_Week=Standard_Week),ABS(I92-I91),0)","v":0},"hrs/mins"]
["This period leave totals",{"$f":"SUM(B96+(IF(Working_Week=Standard_Week,0,B91-B92)))","v":207.20000000000002},null,null,null,null,null,null,{"$f":"SUM(I96+(IF(Working_Week=Standard_Week,0,I91-I92)))","v":0}]
["Total Leave",{"$f":"SUM(B98+I98)","v":207.20000000000002},"hours/minutes",null,null,null,null,null,null,"hours/minutes"]
[]
["Rounded to nearest minute value","Rounding Disabled"]
["Rounded up to Hours and Minutes",{"$f":"B99","v":207.20000000000002},"hours/minutes"]
["Rounded to nearest day value","Rounding Disabled",null,null,"rounded Hrs for 9-day",null,null,null,null,null,null,"v6 Modified by Sam Drury"]
["Rounded up to next half Day",{"$f":"B99/7.4","v":28}," days entitlement",{"$f":"B104*7.4","v":207.20000000000002},{"$f":"D104","v":207.20000000000002}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2008-08-22","EOMONTH issue sorted"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2008-09-03","Rounding to 10dp"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2009-03-10","Adult Ed. Grades reviewed"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2009-04-16","9-day fortnight & BH service increase issue"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","New Adult Ed. Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2010-12-20","Kate & Will's wedding bank holiday & small format changes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2011-02-01","Rounding improved, message for Neg hours etc Bhols to 2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2011-08-10","Extra BH for 2012 added"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2012-03-20","Grade table fixed"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-13","Include the NHS non consultant entitlements"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-20","Include the NHS consultant entitlements"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-30","group pay band in response to introduction of the new greenbook pay grade"]

{"sheet":"Grade Table","index":2,"n_rows":2381,"n_cols":17,"rows_kept":2381,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Group","Min>>",{"$f":"DMIN(Grade_Pivot,\"Level\",J1:J2)","v":1},"    VV message VV"]
[null,null,null,"Old list (for Auto process)",null,null,null,null,null,{"$f":"\"=\"&('Holiday Card'!B5)","v":"=GRD7-GRD8"},"Max >>",{"$f":"DMAX(Grade_Pivot,\"Level\",J1:J2)","v":1},{"$f":"\"     Min \"&(DMIN(Grade_Pivot,\"Level\",J1:J2))&\" to Max \"&(DMAX(Grade_Pivot,\"Level\",J1:J2))","v":"     Min 1 to Max 1"}]
[null,"Count of Level",null,null,null,"Count of Level"]
["Display order ","Group",null,null,null,"Level","Total",null,"Key","Group","Level","Pay scale text","Annual Salary","Service","Entitlement"]
[1,"GRD1-GRD6",null,"GRD1",null,1,87,null,"NHS5-","NHS",1,"NHS",null,"5-",27]
[2,"GRD7-GRD8",null,"GRD1/2",null,2,66,null,"NHS>5<10","NHS",1,"NHS",null,">5<10",29]
[3,"GRD9-GRD18",null,"GRD2",null,3,84,null,"NHS10+","NHS",1,"NHS",null,"10+",33]
[4,"Chief Officer",null,"GRD2/3",null,4,93,null,"NHSconsultant7-","NHSconsultant",1,"NHSconsultant",null,"7-",30]
[5,"Soulbury",null,"GRD2/4",null,5,93,null,"NHSconsultant7+","NHSconsultant",1,"NHSconsultant",null,"7+",32]
[6,"NHS",null,"GRD2/5",null,6,81,null,{"$f":"J10&N10","v":"Chief Officer5-"},"Chief Officer",1,"JNC Chief Officers",null,"5-",30]
[7,"NHSconsultant",null,"GRD3",null,7,87,null,"GRD1-GRD65-","GRD1-GRD6",1,"NJC (Green Book)",null,"5-",25]
[8,null,null,"GRD3/6",null,8,87,null,"GRD7-GRD85-","GRD7-GRD8",1,"NJC (Green Book)",null,"5-",28]
[9,null,null,"GRD4",null,9,81,null,"GRD9-GRD185-","GRD9-GRD18",1,"NJC (Green Book)",null,"5-",30]
[10,null,null,"GRD4/5",null,10,84,null,"Soulbury5-","Soulbury",1,"SOULBURY",null,"5-",29]
[11,null,null,"GRD4/5A",null,11,96,null,{"$f":"J15&N15","v":"Chief Officer>5<10"},"Chief Officer",1,"JNC Chief Officers",null,">5<10",30]
[12,null,null,"GRD4/6",null,12,81,null,"GRD1-GRD6>5<10","GRD1-GRD6",1,"NJC (Green Book)",null,">5<10",30]
[13,null,null,"GRD4/7",null,13,81,null,"GRD7-GRD8>5<10","GRD7-GRD8",1,"NJC (Green Book)",null,">5<10",30]
[14,null,null,"GRD5",null,14,81,null,"GRD9-GRD18>5<10","GRD9-GRD18",1,"NJC (Green Book)",null,">5<10",30]
[15,null,null,"GRD5A",null,15,84,null,"Soulbury>5<10","Soulbury",1,"SOULBURY",null,">5<10",29]
[16,null,null,"GRD5B",null,16,75,null,"Chief Officer10+","Chief Officer",1,"JNC Chief Officers",null,"10+",33]
[17,null,null,"GRD6",null,17,72,null,"GRD1-GRD610+","GRD1-GRD6",1,"NJC (Green Book)",null,"10+",31]
[18,null,null,"GRD6/7",null,18,69,null,"GRD7-GRD810+","GRD7-GRD8",1,"NJC (Green Book)",null,"10+",31]
[19,null,null,"GRD6/8",null,19,66,null,"GRD9-GRD1810+","GRD9-GRD18",1,"NJC (Green Book)",null,"10+",33]
[20,null,null,"GRD6A",null,20,60,null,"Soulbury10+","Soulbury",1,"SOULBURY",null,"10+",32]
[21,null,null,"GRD7",null,21,57]
[22,null,null,"GRD7/8",null,22,60]
[23,null,null,"GRD7/9",null,23,57]
[24,null,null,"GRD8",null,24,57]
[25,null,null,"GRD8/10",null,25,57]
[26,null,null,"GRD8/11",null,26,54]
[27,null,null,"GRD9",null,27,57]
[28,null,null,"GRD9C",null,28,57]
[29,null,null,"GRD9/10",null,29,81]
[30,null,null,"GRD9/10A",null,30,72]
[31,null,null,"GRD9/11",null,31,69]
[32,null,null,"GRD9/11A",null,32,69]
[33,null,null,"GRD9/11B",null,33,69]
[34,null,null,"GRD9/11C",null,34,66]
[35,null,null,"GRD10",null,35,60]
[36,null,null,"GRD10/11",null,36,54]
[37,null,null,"GRD10/12",null,37,54]
[38,null,null,"GRD11",null,38,54]
[39,null,null,"GRD11/12",null,39,54]
[40,null,null,"GRD11/13",null,40,51]
[41,null,null,"GRD12",null,41,57]
[42,null,null,"GRD12A",null,42,54]
[43,null,null,"GRD12B",null,43,51]
[44,null,null,"GRD12C",null,44,48]
[45,null,null,"GRD12/13",null,45,54]
[46,null,null,"GRD12/14",null,46,45]
[47,null,null,"GRD13",null,47,36]
[48,null,null,"GRD13/14",null,48,27]
[49,null,null,"GRD13/15",null,49,24]
[50,null,null,"GRD13A",null,50,21]
[51,null,null,"GRD13B",null,51,18]
[52,null,null,"GRD13C",null,52,18]
[53,null,null,"GRD14",null,53,12]
[54,null,null,"GRD14/16",null,54,12]
[55,null,null,"GRD15",null,55,12]
[56,null,null,"GRD16",null,56,12]
[57,null,null,"GRD16/17",null,57,12]
[58,null,null,"GRD17",null,58,12]
[59,null,null,"GRD17/18",null,59,12]
[60,null,null,"GRD18",null,60,12]
[61,null,null,"POLITASS",null,61,12]
[62,null,null,"COA",null,62,12]
[63,null,null,"COB",null,63,12]
[64,null,null,"COC",null,64,12]
[65,null,null,"COD",null,65,9]
[66,null,null,"CHEXEC",null,66,9]
[67,null,null,"DIRECTOR",null,67,6]
[68,null,null,"ACHEXEC",null,68,6]
[69,null,null,"ICTDEP",null,"Grand Total",3444]
[70,null,null,"SCP04"]
[71,null,null,"SCP05"]
[72,null,null,"SCP06"]
[73,null,null,"SCP07"]
[74,null,null,"SCP08"]
[75,null,null,"SCP09"]
[76,null,null,"SCP10"]
[77,null,null,"SCP11"]
[78,null,null,"SCP12"]
[79,null,null,"SCP13"]
[80,null,null,"SCP14"]
[81,null,null,"SCP15"]
[95,null,null,"SCP16"]
[96,null,null,"SCP17"]
[97,null,null,"SCP18"]
[98,null,null,"SCP19"]
[99,null,null,"SCP20"]
[100,null,null,"SCP21"]
[101,null,null,"SCP22"]
[102,null,null,"SCP23"]
[103,null,null,"SCP24"]
[104,null,null,"SCP25"]
[105,null,null,"SCP26"]
[106,null,null,"SCP27"]
[107,null,null,"SCP28"]
[108,null,null,"SCP29"]
[109,null,null,"SCP30"]
[110,null,null,"SCP31"]
[111,null,null,"SCP32"]
[112,null,null,"SCP33"]
[113,null,null,"SCP34"]
[114,null,null,"SCP35"]
[115,null,null,"SCP36"]
[116,null,null,"SCP37"]
[117,null,null,"SCP38"]
[118,null,null,"SCP39"]
[119,null,null,"SCP40"]
[120,null,null,"SCP41"]
[121,null,null,"SCP42"]
[122,null,null,"SCP43"]
[123,null,null,"SCP44"]
[124,null,null,"SCP45"]
[125,null,null,"SCP46"]
[126,null,null,"SCP47"]
[127,null,null,"SCP48"]
[128,null,null,"SCP49"]
[129,null,null,"SCP50"]
[130,null,null,"SCP51"]
[131,null,null,"SCP52"]
[132,null,null,"SCP53"]
[133,null,null,"SCP54"]
[134,null,null,"SCP55"]
[135,null,null,"SCP56"]
[136,null,null,"SCP57"]
[137,null,null,"SCP58"]
[138,null,null,"SCP59"]
[139,null,null,"SCP60"]
[140,null,null,"SCP61"]
[141,null,null,"SCP62"]
[142,null,null,"SCP63"]
[143,null,null,"SCP64"]
[144,null,null,"SCP65"]
[145,null,null,"SCP66"]
[146,null,null,"WFTBLIND"]
[147,null,null,"CO10"]
[148,null,null,"CO15"]
[149,null,null,"CO20"]
[150,null,null,"CO5"]
[151,null,null,"CO-D(P)"]
[152,null,null,"70%CO15"]
[153,null,null,"74%CO15"]
[154,null,null,"75%CO20"]
[155,null,null,"DRHANDY1"]
[156,null,null,"DRHANDY2"]
[157,null,null,"HYDRANTI"]
[158,null,null,"MVFITTER"]
[159,null,null,"IA5"]
[160,null,null,"IA7"]
[161,null,null,"IA8"]
[162,null,null,"IA9"]
[163,null,null,"IA10"]
[164,null,null,"IA11"]
[165,null,null,"IA12"]
[166,null,null,"IA13"]
[167,null,null,"IA14"]
[168,null,null,"IA15"]
[169,null,null,"IA16"]
[170,null,null,"IA17"]
[171,null,null,"IA18"]
[172,null,null,"IA19"]
[173,null,null,"IA20"]
[174,null,null,"IA21"]
[175,null,null,"IA22"]
[176,null,null,"IA23"]
[177,null,null,"IA24"]
[178,null,null,"IA25"]
[179,null,null,"IA26"]
[180,null,null,"IA27"]
[181,null,null,"IA28"]
[182,null,null,"IA29"]
[183,null,null,"IA30"]
[184,null,null,"IA31"]
[185,null,null,"IA32"]
[186,null,null,"IA33"]
[187,null,null,"IA34"]
[188,null,null,"IA35"]
[189,null,null,"IA36"]
[190,null,null,"IA37"]
[191,null,null,"IA38"]
[192,null,null,"IA39"]
[193,null,null,"IA40"]
[194,null,null,"IA41"]
[195,null,null,"IA42"]
[196,null,null,"IA43"]
[197,null,null,"IA44"]
[198,null,null,"IA45"]
[199,null,null,"IA46"]
[200,null,null,"IA47"]
[201,null,null,"IASPOT04"]
[202,null,null,"IASPOT06"]
[203,null,null,"IASPOT08"]
[204,null,null,"IASPOT10"]
[205,null,null,"IASPOT15"]
[206,null,null,"ADULT1"]
[207,null,null,"ADULT2"]
[208,null,null,"ADULT3"]
[209,null,null,"ADULT4"]
[210,null,null,"ADULT5"]
[211,null,null,"ADULT6"]
[212,null,null,"ADULT7"]
[213,null,null,"ADULT8"]
[214,null,null,"ADULT9"]
[215,null,null,"ADULT10"]
[216,null,null,"ADULT11"]
[217,null,null,"ADULT12"]
[218,null,null,"ADULT13"]
[219,"Grand Total",null,"ADGR1"]
[220,null,null,"ADGR2"]
[221,null,null,"ADGR3"]
[222,null,null,"ADGR4"]
[223,null,null,"ADULT18"]
[224,null,null,"APP SCP7"]
[225,null,null,"APP SCP8"]
[226,null,null,"EP1"]
[227,null,null,"EP2"]
[228,null,null,"EP3"]
[229,null,null,"JNCLOC04"]
[230,null,null,"JNCLOC07"]
[231,null,null,"JNCLOC10"]
[232,null,null,"JNCLOC13"]
[233,null,null,"JNCLOC14"]
[234,null,null,"JNCLOC17"]
[235,null,null,"JNCLOC18"]
[236,null,null,"JNCLOC22"]
[237,null,null,"JNCLOC25"]
[238,null,null,"JNCLOC30"]
[239,null,null,"TRAINEP"]
[240,null,null,"YCO1"]
[241,null,null,"YCO10"]
[242,null,null,"YCO11"]
[243,null,null,"YCO12"]
[244,null,null,"YCO13"]
[245,null,null,"YCO2"]
[246,null,null,"YCO3"]
[247,null,null,"YCO4"]
[248,null,null,"YCO5"]
[249,null,null,"YCO6"]
[250,null,null,"YCO7"]
[251,null,null,"YCO8"]
[null,null,null,"YCO9"]
[null,null,null,"YOUNAT1"]
[null,null,null,"YOUNAT21"]
[null,null,null,"YOUNAT22"]
[null,null,null,"YOUNAT23"]
[null,null,null,"YOUNAT31"]
[null,null,null,"YOUNAT32"]
[null,null,null,"YOUNAT33"]
[null,null,null,"YOUNAT34"]
[null,null,null,"YOUNAT35"]
[null,null,null,"YOUNAT36"]
[null,null,null,"YOUTRAIN"]
[null,null,null,"SCP100"]
[null,null,null,{"$f":"VLOOKUP(B210,#REF!,1,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"DCOUNT(J4:K360,\"level\",\"adult16\")","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]