{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Record of Leave","Leave Calculator","Leave Information","Guidance","Lists","Input Variables"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":11,"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":"Record of Leave","index":0,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[28,8,28,11],[30,8,30,11],[42,4,42,5],[42,8,42,11],[41,4,41,5],[41,8,41,11],[40,4,40,5],[40,8,40,11],[0,1,0,13],[36,4,36,5],[36,8,36,11],[28,4,28,5],[35,4,35,5],[35,8,35,11],[33,4,33,5],[32,4,32,5],[8,3,8,6],[9,7,9,8],[12,1,12,4],[11,1,11,6],[1,1,1,13],[2,1,2,13],[13,12,13,13],[16,1,16,13],[8,7,8,8],[13,5,13,6],[13,1,13,4],[13,8,13,11],[9,1,9,2],[4,1,4,9],[5,7,5,8],[11,8,11,13],[12,8,12,11],[7,7,7,8],[6,7,6,8],[7,1,7,2],[5,1,5,2],[6,1,6,2],[12,5,12,6],[5,3,5,6],[9,3,9,6],[7,3,7,6],[6,3,6,6],[12,12,12,13],[8,1,8,2],[17,1,17,4],[14,8,14,11],[17,12,17,13],[14,12,14,13],[17,5,17,6],[14,5,14,6],[17,8,17,11],[14,1,14,4],[18,12,18,13],[22,12,22,13],[19,12,19,13],[22,4,23,5],[18,8,18,11],[19,8,19,11],[19,1,19,4],[18,1,18,4],[22,8,23,11],[22,7,23,7],[22,1,22,2],[22,6,23,6],[19,5,19,6],[22,3,23,3],[21,1,21,13],[24,4,24,5],[25,4,25,5],[26,4,26,5],[30,4,30,5],[18,5,18,6],[34,4,34,5],[29,4,29,5],[27,4,27,5],[31,4,31,5],[39,4,39,5],[39,8,39,11],[37,4,37,5],[37,8,37,11],[38,4,38,5],[38,8,38,11]]}
[null,"This sheet should only be used for planning purposes until annual leave can be managed on Business World"]
[]
[4]
[]
[4,"RECORD OF LEAVE - 2022/23 FINANCIAL YEAR ONLY"]
[4,"Name of officer:",null,null,null,null,null," Hours per week: * †",null,37]
[4,"Name of manager:",null,null,null,null,null," Job grade: *",null,"1-7"]
[4,"Service area:",null,null,null,null,null," 5+ years service:",null,"No"]
[4,"Record start date: *",null,"2022-04-01",null,null,null," Number of weeks:",null,{"$f":"IF(K10=\"\", \"\", IF(OR(K10<0), \"Dates!\", IF(Weeks>52, \"Dates!\", Weeks)))","v":52}]
[4,"Record end date: *",null,"2023-03-31",null,null,null," Compressed hours:",null,null,{"$f":"IF(OR(D10=\"\",D9=\"\"), \"\", D10-D9)","v":364},{"$f":"IF(K10=\"\", \"\", ROUND((K10/7)/0.5, 0)*0.5)","v":52},null,"* Indicates a mandatory field"]
[4,null,null,null,null,null,null,null,{"$f":"IF(J6=\"\",\"Days\",IF(OR(J6<37,J6>37),\"Hours\",IF(J10=\"Yes\",\"Hours\",\"Days\")))","v":"Days"},{"$f":"J6/'Input Variables'!E3","v":1},{"$f":"IF(OR(J9=\"Dates!\",J9=\"\"), 0, J9/52)","v":1},null,null,"† Calculator in Guidance sheet"]
[4,"Carried Forward / Additional Leave",null,null,null,null,null,null,"Annual Leave Entitlement"]
[4,{"$f":"Lists!D9","v":"Number of days carried forward:"},null,null,null,0,null,null,"Basic leave entitlement:",null,null,null,{"$f":"IF(I16=\"\", \"\", IF(I11=\"Hours\", (I16*('Input Variables'!E3/5))*J11*K11, ROUND(I16*J11*K11,0)))","v":24}]
[4,{"$f":"Lists!D11","v":"Additional days:"},null,null,null,0,null,null,"Bank holiday entitlement:",null,null,null,{"$f":"IF(OR(I16=\"\", D9=\"\",D10=\"\"), \"\", IF(I11=\"Hours\", ('Input Variables'!F20*('Input Variables'!E3/5))*J11, 'Input Variables'!F20*J11))","v":9}]
[4,{"$f":"Lists!D14","v":"Additional days for 5+ years service:"},null,null,null,{"$f":"IF(OR(J6=\"\",J8=\"\",J9=\"\"),\"\",IF(AND(J8=\"Yes\",I11=\"Hours\"),('Input Variables'!E8*('Input Variables'!E3/5))*J11*K11,IF(AND(J8=\"Yes\",I11=\"Days\"),ROUND('Input Variables'!E8*J11*K11,0),0)))","v":0},null,null,"TOTAL LEAVE ENTITLEMENT:",null,null,null,{"$f":"IF(OR(J7=\"\", J6=\"\", J9=\"\"), \"\", SUM(F13,F14,M13,M14,F15,N16))","v":33}]
[4,null,null,null,null,null,null,null,{"$f":"IF(OR(J7=\"\",J6=\"\",J9=\"\"),\"\",IF(J7='Input Variables'!E4,'Input Variables'!E6,IF(J7='Input Variables'!E5,'Input Variables'!E7)))","v":24},{"$f":"IF(I16=\"\", \"\", IF(I11=\"Hours\", (I16*'Input Variables'!E3/5)*J11, I16*J11))","v":24}]
[4,"Summary of Leave"]
[4,"Cumulative annual/bank hol leave taken:",null,null,null,{"$f":"IF(M15=\"\",\"\",(SUM(SUMIF(H25:H10016,\"Annual\",D25:D10016),SUMIF(H25:H10016,\"Bank Hol\",D25:D10016),SUMIF(H25:H10016,\"\",D25:D10016))))","v":0},null,null,"Cumulative special leave taken:",null,null,null,{"$f":"IF(M15=\"\", \"\", SUMIF(H25:H1019, \"Special\", D25:D1019))","v":0}]
[4,"Cumulative designated leave taken:",null,null,null,{"$f":"IF(M15=\"\",\"\",(SUM(SUMIF(H25:H10016,\"Designated\",D25:D10016))))","v":0},null,null,"Cumulative disability leave taken:",null,null,null,{"$f":"IF(M15=\"\", \"\", SUMIF(H25:H1019, \"Disability\", D25:D1019))","v":0}]
[4,"Cumulative flexi leave taken:",null,null,null,{"$f":"IF(M15=\"\", \"\", SUMIF(H25:H1019, \"Flexi\", D25:D1019))","v":0},null,null,"Cumulative other leave taken:",null,null,null,{"$f":"IF(M15=\"\", \"\", SUMIF(H25:H1019, \"Other\", D25:D1019))","v":0}]
[4]
[4,"Detailed Record of Leave"]
[4,"Inclusive dates",null,{"$f":"Lists!D12","v":"Number of leave days"},{"$f":"Lists!D13","v":"Cumulative days taken"},null,{"$f":"CONCATENATE(I11, \" remaining\")","v":"Days remaining"},"Leave type","Comments",null,null,null,"Approved by"]
[4,"From","To",null,null,null,null,null,null,null,null,null,"Manager","Date"]
[1,"2022-04-15","2022-04-15",0,{"$f":"IF(OR(D25=\"\",$M$15=\"\"),\"\",IF(OR(H25=\"\",H25=\"Annual\",H25=\"Designated\",H25=\"Bank Hol\"),D25,0))","v":0},null,{"$f":"IF(E25=\"\", \"\", $M$15-E25)","v":33},"Bank Hol","Good Friday (FRIDAY)"]
[1,"2022-04-18","2022-04-18",0,{"$f":"IF(OR(E25=\"\",D26=\"\"),\"\",IF(OR(H26=\"\",H26=\"Annual\",H26=\"Bank Hol\",H26=\"Designated\"),SUM(E25,D26),E25))","v":0},null,{"$f":"IF(E26=\"\", \"\", $M$15-E26)","v":33},"Bank Hol","Easter Monday (MONDAY)"]
[null,"2022-05-02","2022-05-02",0,{"$f":"IF(OR(E26=\"\",D27=\"\"),\"\",IF(OR(H27=\"\",H27=\"Annual\",H27=\"Bank Hol\",H27=\"Designated\"),SUM(E26,D27),E26))","v":0},null,{"$f":"IF(E27=\"\", \"\", $M$15-E27)","v":33},"Bank Hol","May Day Bank Holiday (MONDAY)"]
[null,"2022-06-02","2022-06-02",0,0,null,33,"Bank Hol","Spring Bank Holiday (THURSDAY)"]
[null,"2022-06-03","2022-06-03",0,0,null,33,"Bank Hol","Platinum Jubilee bank holiday (FRIDAY)"]
[null,"2022-08-29","2022-08-29",0,0,null,33,"Bank Hol","Late Summer Bank Holiday (MONDAY)"]
[null,"2022-12-26","2022-12-26",0,0,null,33,"Bank Hol","Boxing Day (MONDAY)"]
[null,"2022-12-27","2022-12-27",0,0,null,33,"Bank Hol","Christmas Day - Substitute Day (TUESDAY)"]
[null,"2023-01-02","2023-01-02",0,0,null,33,"Bank Hol","New Year's Day -Substitute Day (MONDAY)"]
[null,null,null,null,"",null,""]
[null,null,null,null,"",null,""]
[null,null,null,null,"",null,""]
[null,null,null,null,"",null,""]
[null,null,null,null,"",null,""]
[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(OR(E42=\"\",D43=\"\"),\"\",IF(OR(H43=\"\",H43=\"Annual\",H43=\"Bank Hol\",H43=\"Designated\"),SUM(E42,D43),E42))","v":""},null,{"$f":"IF(E43=\"\", \"\", $M$15-E43)","v":""}]
[2]
[]
[null,"End"]

{"sheet":"Leave Calculator","index":1,"n_rows":44,"n_cols":36,"rows_kept":44,"cut":false,"hidden":true,"merged":[[1,1,1,14],[2,8,2,12],[2,1,2,7],[2,13,2,14]]}
[]
[null,"ANNUAL LEAVE ENTITLEMENT CALCULATOR"]
[null,"Employee Details",null,null,null,null,null,null,"Annual Leave Entitlement",null,null,null,null,"Additional Leave"]
[null,"Name","Leave start date","Leave end date","Hours per week","Job grade","5+ years service","Compressed hours","Days or hours","Basic leave","Bank hol leave","5+ years service","Total (including Carry forward and Additional)","Carry forward","Additional leave"]
[null,null,null,null,null,null,null,null,{"$f":"IF(W5=\"\", \"\", V5)","v":""},{"$f":"IF(W5=\"\", \"\", IF(V5=\"Hours\", (W5*('Input Variables'!$E$3/5))*U5*T5, W5*U5*T5))","v":""},{"$f":"IF(OR(W5=\"\", C5=\"\",D5=\"\"), \"\", IF(V5=\"Hours\", (AJ5*('Input Variables'!$E$3/5))*U5, AJ5*U5))","v":""},{"$f":"IF(OR(E5=\"\",G5=\"\",S5=\"\"),\"\",IF(AND(G5=\"Yes\",V5=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U5*T5,IF(G5=\"Yes\",'Input Variables'!$E$8*U5*T5,0)))","v":""},{"$f":"IF(OR(F5=\"\", E5=\"\", S5=\"\"), \"\", SUM(N5,O5,J5,K5,L5))","v":""},null,null,{"$f":"IF(S5=\"Check dates!\", CONCATENATE(\" \",S5), \"\")","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"), \"\", D5-C5)","v":""},{"$f":"IF(Q5=\"\", \"\", ROUND((Q5/7)/0.5, 0)*0.5)","v":""},{"$f":"IF(Q5=\"\", \"\", IF(OR(Q5<0), \"Check dates!\", IF(R5>52, \"Check dates!\", R5)))","v":""},{"$f":"IF(OR(S5=\"Check dates!\",S5=\"\"), 0, S5/52)","v":0},{"$f":"E5/'Input Variables'!$E$3","v":0},{"$f":"IF(E5=\"\",\"Days\",IF(E5<37,\"Hours\",IF(H5=\"Yes\",\"Hours\",\"Days\")))","v":"Days"},{"$f":"IF(OR(F5=\"\",E5=\"\",S5=\"\"),\"\",IF(F5='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F5='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W5=\"\", \"\", IF(V5=\"Hours\", (W5*'Input Variables'!$E$3/5)*U5, W5*U5))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C5,'Input Variables'!$E$9<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C5,'Input Variables'!$E$10<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C5,'Input Variables'!$E$11<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C5,'Input Variables'!$E$12<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C5,'Input Variables'!$E$13<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C5,'Input Variables'!$E$14<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C5,'Input Variables'!$E$15<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C5,'Input Variables'!$E$16<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C5,'Input Variables'!$E$17<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C5,'Input Variables'!$E$18<=D5),1,0))","v":""},{"$f":"IF(OR(C5=\"\",D5=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C5,'Input Variables'!$E$19<=D5),1,0))","v":""},{"$f":"SUM(Y5:AI5)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(W6=\"\", \"\", V6)","v":""},{"$f":"IF(W6=\"\", \"\", IF(V6=\"Hours\", (W6*('Input Variables'!$E$3/5))*U6*T6, W6*U6*T6))","v":""},{"$f":"IF(OR(W6=\"\", C6=\"\",D6=\"\"), \"\", IF(V6=\"Hours\", (AJ6*('Input Variables'!$E$3/5))*U6, AJ6*U6))","v":""},{"$f":"IF(OR(E6=\"\",G6=\"\",S6=\"\"),\"\",IF(AND(G6=\"Yes\",V6=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U6*T6,IF(G6=\"Yes\",'Input Variables'!$E$8*U6*T6,0)))","v":""},"",null,null,"","",{"$f":"IF(Q6=\"\", \"\", ROUND((Q6/7)/0.5, 0)*0.5)","v":""},{"$f":"IF(Q6=\"\", \"\", IF(OR(Q6<0), \"Check dates!\", IF(R6>52, \"Check dates!\", R6)))","v":""},{"$f":"IF(OR(S6=\"Check dates!\",S6=\"\"), 0, S6/52)","v":0},{"$f":"E6/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F6=\"\",E6=\"\",S6=\"\"),\"\",IF(F6='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F6='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W6=\"\", \"\", IF(V6=\"Hours\", (W6*'Input Variables'!$E$3/5)*U6, W6*U6))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C6,'Input Variables'!$E$9<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C6,'Input Variables'!$E$10<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C6,'Input Variables'!$E$11<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C6,'Input Variables'!$E$12<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C6,'Input Variables'!$E$13<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C6,'Input Variables'!$E$14<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C6,'Input Variables'!$E$15<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C6,'Input Variables'!$E$16<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C6,'Input Variables'!$E$17<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C6,'Input Variables'!$E$18<=D6),1,0))","v":""},{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C6,'Input Variables'!$E$19<=D6),1,0))","v":""},{"$f":"SUM(Y6:AI6)","v":0}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W7=\"\", \"\", IF(V7=\"Hours\", (W7*('Input Variables'!$E$3/5))*U7*T7, W7*U7*T7))","v":""},{"$f":"IF(OR(W7=\"\", C7=\"\",D7=\"\"), \"\", IF(V7=\"Hours\", (AJ7*('Input Variables'!$E$3/5))*U7, AJ7*U7))","v":""},{"$f":"IF(OR(E7=\"\",G7=\"\",S7=\"\"),\"\",IF(AND(G7=\"Yes\",V7=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U7*T7,IF(G7=\"Yes\",'Input Variables'!$E$8*U7*T7,0)))","v":""},"",null,null,"","","","",0,{"$f":"E7/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F7=\"\",E7=\"\",S7=\"\"),\"\",IF(F7='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F7='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W7=\"\", \"\", IF(V7=\"Hours\", (W7*'Input Variables'!$E$3/5)*U7, W7*U7))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C7,'Input Variables'!$E$9<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C7,'Input Variables'!$E$10<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C7,'Input Variables'!$E$11<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C7,'Input Variables'!$E$12<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C7,'Input Variables'!$E$13<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C7,'Input Variables'!$E$14<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C7,'Input Variables'!$E$15<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C7,'Input Variables'!$E$16<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C7,'Input Variables'!$E$17<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C7,'Input Variables'!$E$18<=D7),1,0))","v":""},{"$f":"IF(OR(C7=\"\",D7=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C7,'Input Variables'!$E$19<=D7),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W8=\"\", \"\", IF(V8=\"Hours\", (W8*('Input Variables'!$E$3/5))*U8*T8, W8*U8*T8))","v":""},{"$f":"IF(OR(W8=\"\", C8=\"\",D8=\"\"), \"\", IF(V8=\"Hours\", (AJ8*('Input Variables'!$E$3/5))*U8, AJ8*U8))","v":""},{"$f":"IF(OR(E8=\"\",G8=\"\",S8=\"\"),\"\",IF(AND(G8=\"Yes\",V8=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U8*T8,IF(G8=\"Yes\",'Input Variables'!$E$8*U8*T8,0)))","v":""},"",null,null,"","","","",0,{"$f":"E8/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F8=\"\",E8=\"\",S8=\"\"),\"\",IF(F8='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F8='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W8=\"\", \"\", IF(V8=\"Hours\", (W8*'Input Variables'!$E$3/5)*U8, W8*U8))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C8,'Input Variables'!$E$9<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C8,'Input Variables'!$E$10<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C8,'Input Variables'!$E$11<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C8,'Input Variables'!$E$12<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C8,'Input Variables'!$E$13<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C8,'Input Variables'!$E$14<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C8,'Input Variables'!$E$15<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C8,'Input Variables'!$E$16<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C8,'Input Variables'!$E$17<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C8,'Input Variables'!$E$18<=D8),1,0))","v":""},{"$f":"IF(OR(C8=\"\",D8=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C8,'Input Variables'!$E$19<=D8),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W9=\"\", \"\", IF(V9=\"Hours\", (W9*('Input Variables'!$E$3/5))*U9*T9, W9*U9*T9))","v":""},{"$f":"IF(OR(W9=\"\", C9=\"\",D9=\"\"), \"\", IF(V9=\"Hours\", (AJ9*('Input Variables'!$E$3/5))*U9, AJ9*U9))","v":""},{"$f":"IF(OR(E9=\"\",G9=\"\",S9=\"\"),\"\",IF(AND(G9=\"Yes\",V9=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U9*T9,IF(G9=\"Yes\",'Input Variables'!$E$8*U9*T9,0)))","v":""},"",null,null,"","","","",0,{"$f":"E9/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F9=\"\",E9=\"\",S9=\"\"),\"\",IF(F9='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F9='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W9=\"\", \"\", IF(V9=\"Hours\", (W9*'Input Variables'!$E$3/5)*U9, W9*U9))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C9,'Input Variables'!$E$9<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C9,'Input Variables'!$E$10<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C9,'Input Variables'!$E$11<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C9,'Input Variables'!$E$12<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C9,'Input Variables'!$E$13<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C9,'Input Variables'!$E$14<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C9,'Input Variables'!$E$15<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C9,'Input Variables'!$E$16<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C9,'Input Variables'!$E$17<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C9,'Input Variables'!$E$18<=D9),1,0))","v":""},{"$f":"IF(OR(C9=\"\",D9=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C9,'Input Variables'!$E$19<=D9),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W10=\"\", \"\", IF(V10=\"Hours\", (W10*('Input Variables'!$E$3/5))*U10*T10, W10*U10*T10))","v":""},{"$f":"IF(OR(W10=\"\", C10=\"\",D10=\"\"), \"\", IF(V10=\"Hours\", (AJ10*('Input Variables'!$E$3/5))*U10, AJ10*U10))","v":""},{"$f":"IF(OR(E10=\"\",G10=\"\",S10=\"\"),\"\",IF(AND(G10=\"Yes\",V10=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U10*T10,IF(G10=\"Yes\",'Input Variables'!$E$8*U10*T10,0)))","v":""},"",null,null,"","","","",0,{"$f":"E10/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F10=\"\",E10=\"\",S10=\"\"),\"\",IF(F10='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F10='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W10=\"\", \"\", IF(V10=\"Hours\", (W10*'Input Variables'!$E$3/5)*U10, W10*U10))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C10,'Input Variables'!$E$9<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C10,'Input Variables'!$E$10<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C10,'Input Variables'!$E$11<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C10,'Input Variables'!$E$12<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C10,'Input Variables'!$E$13<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C10,'Input Variables'!$E$14<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C10,'Input Variables'!$E$15<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C10,'Input Variables'!$E$16<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C10,'Input Variables'!$E$17<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C10,'Input Variables'!$E$18<=D10),1,0))","v":""},{"$f":"IF(OR(C10=\"\",D10=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C10,'Input Variables'!$E$19<=D10),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W11=\"\", \"\", IF(V11=\"Hours\", (W11*('Input Variables'!$E$3/5))*U11*T11, W11*U11*T11))","v":""},{"$f":"IF(OR(W11=\"\", C11=\"\",D11=\"\"), \"\", IF(V11=\"Hours\", (AJ11*('Input Variables'!$E$3/5))*U11, AJ11*U11))","v":""},{"$f":"IF(OR(E11=\"\",G11=\"\",S11=\"\"),\"\",IF(AND(G11=\"Yes\",V11=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U11*T11,IF(G11=\"Yes\",'Input Variables'!$E$8*U11*T11,0)))","v":""},"",null,null,"","","","",0,{"$f":"E11/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F11=\"\",E11=\"\",S11=\"\"),\"\",IF(F11='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F11='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W11=\"\", \"\", IF(V11=\"Hours\", (W11*'Input Variables'!$E$3/5)*U11, W11*U11))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C11,'Input Variables'!$E$9<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C11,'Input Variables'!$E$10<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C11,'Input Variables'!$E$11<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C11,'Input Variables'!$E$12<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C11,'Input Variables'!$E$13<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C11,'Input Variables'!$E$14<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C11,'Input Variables'!$E$15<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C11,'Input Variables'!$E$16<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C11,'Input Variables'!$E$17<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C11,'Input Variables'!$E$18<=D11),1,0))","v":""},{"$f":"IF(OR(C11=\"\",D11=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C11,'Input Variables'!$E$19<=D11),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W12=\"\", \"\", IF(V12=\"Hours\", (W12*('Input Variables'!$E$3/5))*U12*T12, W12*U12*T12))","v":""},{"$f":"IF(OR(W12=\"\", C12=\"\",D12=\"\"), \"\", IF(V12=\"Hours\", (AJ12*('Input Variables'!$E$3/5))*U12, AJ12*U12))","v":""},{"$f":"IF(OR(E12=\"\",G12=\"\",S12=\"\"),\"\",IF(AND(G12=\"Yes\",V12=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U12*T12,IF(G12=\"Yes\",'Input Variables'!$E$8*U12*T12,0)))","v":""},"",null,null,"","","","",0,{"$f":"E12/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F12=\"\",E12=\"\",S12=\"\"),\"\",IF(F12='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F12='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W12=\"\", \"\", IF(V12=\"Hours\", (W12*'Input Variables'!$E$3/5)*U12, W12*U12))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C12,'Input Variables'!$E$9<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C12,'Input Variables'!$E$10<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C12,'Input Variables'!$E$11<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C12,'Input Variables'!$E$12<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C12,'Input Variables'!$E$13<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C12,'Input Variables'!$E$14<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C12,'Input Variables'!$E$15<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C12,'Input Variables'!$E$16<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C12,'Input Variables'!$E$17<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C12,'Input Variables'!$E$18<=D12),1,0))","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C12,'Input Variables'!$E$19<=D12),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W13=\"\", \"\", IF(V13=\"Hours\", (W13*('Input Variables'!$E$3/5))*U13*T13, W13*U13*T13))","v":""},{"$f":"IF(OR(W13=\"\", C13=\"\",D13=\"\"), \"\", IF(V13=\"Hours\", (AJ13*('Input Variables'!$E$3/5))*U13, AJ13*U13))","v":""},{"$f":"IF(OR(E13=\"\",G13=\"\",S13=\"\"),\"\",IF(AND(G13=\"Yes\",V13=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U13*T13,IF(G13=\"Yes\",'Input Variables'!$E$8*U13*T13,0)))","v":""},"",null,null,"","","","",0,{"$f":"E13/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F13=\"\",E13=\"\",S13=\"\"),\"\",IF(F13='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F13='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W13=\"\", \"\", IF(V13=\"Hours\", (W13*'Input Variables'!$E$3/5)*U13, W13*U13))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C13,'Input Variables'!$E$9<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C13,'Input Variables'!$E$10<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C13,'Input Variables'!$E$11<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C13,'Input Variables'!$E$12<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C13,'Input Variables'!$E$13<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C13,'Input Variables'!$E$14<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C13,'Input Variables'!$E$15<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C13,'Input Variables'!$E$16<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C13,'Input Variables'!$E$17<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C13,'Input Variables'!$E$18<=D13),1,0))","v":""},{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C13,'Input Variables'!$E$19<=D13),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W14=\"\", \"\", IF(V14=\"Hours\", (W14*('Input Variables'!$E$3/5))*U14*T14, W14*U14*T14))","v":""},{"$f":"IF(OR(W14=\"\", C14=\"\",D14=\"\"), \"\", IF(V14=\"Hours\", (AJ14*('Input Variables'!$E$3/5))*U14, AJ14*U14))","v":""},{"$f":"IF(OR(E14=\"\",G14=\"\",S14=\"\"),\"\",IF(AND(G14=\"Yes\",V14=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U14*T14,IF(G14=\"Yes\",'Input Variables'!$E$8*U14*T14,0)))","v":""},"",null,null,"","","","",0,{"$f":"E14/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F14=\"\",E14=\"\",S14=\"\"),\"\",IF(F14='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F14='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W14=\"\", \"\", IF(V14=\"Hours\", (W14*'Input Variables'!$E$3/5)*U14, W14*U14))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C14,'Input Variables'!$E$9<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C14,'Input Variables'!$E$10<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C14,'Input Variables'!$E$11<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C14,'Input Variables'!$E$12<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C14,'Input Variables'!$E$13<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C14,'Input Variables'!$E$14<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C14,'Input Variables'!$E$15<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C14,'Input Variables'!$E$16<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C14,'Input Variables'!$E$17<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C14,'Input Variables'!$E$18<=D14),1,0))","v":""},{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C14,'Input Variables'!$E$19<=D14),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W15=\"\", \"\", IF(V15=\"Hours\", (W15*('Input Variables'!$E$3/5))*U15*T15, W15*U15*T15))","v":""},{"$f":"IF(OR(W15=\"\", C15=\"\",D15=\"\"), \"\", IF(V15=\"Hours\", (AJ15*('Input Variables'!$E$3/5))*U15, AJ15*U15))","v":""},{"$f":"IF(OR(E15=\"\",G15=\"\",S15=\"\"),\"\",IF(AND(G15=\"Yes\",V15=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U15*T15,IF(G15=\"Yes\",'Input Variables'!$E$8*U15*T15,0)))","v":""},"",null,null,"","","","",0,{"$f":"E15/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F15=\"\",E15=\"\",S15=\"\"),\"\",IF(F15='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F15='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W15=\"\", \"\", IF(V15=\"Hours\", (W15*'Input Variables'!$E$3/5)*U15, W15*U15))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C15,'Input Variables'!$E$9<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C15,'Input Variables'!$E$10<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C15,'Input Variables'!$E$11<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C15,'Input Variables'!$E$12<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C15,'Input Variables'!$E$13<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C15,'Input Variables'!$E$14<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C15,'Input Variables'!$E$15<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C15,'Input Variables'!$E$16<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C15,'Input Variables'!$E$17<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C15,'Input Variables'!$E$18<=D15),1,0))","v":""},{"$f":"IF(OR(C15=\"\",D15=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C15,'Input Variables'!$E$19<=D15),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W16=\"\", \"\", IF(V16=\"Hours\", (W16*('Input Variables'!$E$3/5))*U16*T16, W16*U16*T16))","v":""},{"$f":"IF(OR(W16=\"\", C16=\"\",D16=\"\"), \"\", IF(V16=\"Hours\", (AJ16*('Input Variables'!$E$3/5))*U16, AJ16*U16))","v":""},{"$f":"IF(OR(E16=\"\",G16=\"\",S16=\"\"),\"\",IF(AND(G16=\"Yes\",V16=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U16*T16,IF(G16=\"Yes\",'Input Variables'!$E$8*U16*T16,0)))","v":""},"",null,null,"","","","",0,{"$f":"E16/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F16=\"\",E16=\"\",S16=\"\"),\"\",IF(F16='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F16='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W16=\"\", \"\", IF(V16=\"Hours\", (W16*'Input Variables'!$E$3/5)*U16, W16*U16))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C16,'Input Variables'!$E$9<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C16,'Input Variables'!$E$10<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C16,'Input Variables'!$E$11<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C16,'Input Variables'!$E$12<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C16,'Input Variables'!$E$13<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C16,'Input Variables'!$E$14<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C16,'Input Variables'!$E$15<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C16,'Input Variables'!$E$16<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C16,'Input Variables'!$E$17<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C16,'Input Variables'!$E$18<=D16),1,0))","v":""},{"$f":"IF(OR(C16=\"\",D16=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C16,'Input Variables'!$E$19<=D16),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W17=\"\", \"\", IF(V17=\"Hours\", (W17*('Input Variables'!$E$3/5))*U17*T17, W17*U17*T17))","v":""},{"$f":"IF(OR(W17=\"\", C17=\"\",D17=\"\"), \"\", IF(V17=\"Hours\", (AJ17*('Input Variables'!$E$3/5))*U17, AJ17*U17))","v":""},{"$f":"IF(OR(E17=\"\",G17=\"\",S17=\"\"),\"\",IF(AND(G17=\"Yes\",V17=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U17*T17,IF(G17=\"Yes\",'Input Variables'!$E$8*U17*T17,0)))","v":""},"",null,null,"","","","",0,{"$f":"E17/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F17=\"\",E17=\"\",S17=\"\"),\"\",IF(F17='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F17='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W17=\"\", \"\", IF(V17=\"Hours\", (W17*'Input Variables'!$E$3/5)*U17, W17*U17))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C17,'Input Variables'!$E$9<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C17,'Input Variables'!$E$10<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C17,'Input Variables'!$E$11<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C17,'Input Variables'!$E$12<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C17,'Input Variables'!$E$13<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C17,'Input Variables'!$E$14<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C17,'Input Variables'!$E$15<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C17,'Input Variables'!$E$16<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C17,'Input Variables'!$E$17<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C17,'Input Variables'!$E$18<=D17),1,0))","v":""},{"$f":"IF(OR(C17=\"\",D17=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C17,'Input Variables'!$E$19<=D17),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W18=\"\", \"\", IF(V18=\"Hours\", (W18*('Input Variables'!$E$3/5))*U18*T18, W18*U18*T18))","v":""},{"$f":"IF(OR(W18=\"\", C18=\"\",D18=\"\"), \"\", IF(V18=\"Hours\", (AJ18*('Input Variables'!$E$3/5))*U18, AJ18*U18))","v":""},{"$f":"IF(OR(E18=\"\",G18=\"\",S18=\"\"),\"\",IF(AND(G18=\"Yes\",V18=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U18*T18,IF(G18=\"Yes\",'Input Variables'!$E$8*U18*T18,0)))","v":""},"",null,null,{"$f":"IF(S18=\"Check dates!\", CONCATENATE(\" \",S18), \"\")","v":""},"","","",0,{"$f":"E18/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F18=\"\",E18=\"\",S18=\"\"),\"\",IF(F18='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F18='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W18=\"\", \"\", IF(V18=\"Hours\", (W18*'Input Variables'!$E$3/5)*U18, W18*U18))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C18,'Input Variables'!$E$9<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C18,'Input Variables'!$E$10<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C18,'Input Variables'!$E$11<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C18,'Input Variables'!$E$12<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C18,'Input Variables'!$E$13<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C18,'Input Variables'!$E$14<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C18,'Input Variables'!$E$15<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C18,'Input Variables'!$E$16<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C18,'Input Variables'!$E$17<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C18,'Input Variables'!$E$18<=D18),1,0))","v":""},{"$f":"IF(OR(C18=\"\",D18=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C18,'Input Variables'!$E$19<=D18),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W19=\"\", \"\", IF(V19=\"Hours\", (W19*('Input Variables'!$E$3/5))*U19*T19, W19*U19*T19))","v":""},{"$f":"IF(OR(W19=\"\", C19=\"\",D19=\"\"), \"\", IF(V19=\"Hours\", (AJ19*('Input Variables'!$E$3/5))*U19, AJ19*U19))","v":""},{"$f":"IF(OR(E19=\"\",G19=\"\",S19=\"\"),\"\",IF(AND(G19=\"Yes\",V19=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U19*T19,IF(G19=\"Yes\",'Input Variables'!$E$8*U19*T19,0)))","v":""},"",null,null,{"$f":"IF(S19=\"Check dates!\", CONCATENATE(\" \",S19), \"\")","v":""},"","","",0,{"$f":"E19/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F19=\"\",E19=\"\",S19=\"\"),\"\",IF(F19='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F19='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W19=\"\", \"\", IF(V19=\"Hours\", (W19*'Input Variables'!$E$3/5)*U19, W19*U19))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C19,'Input Variables'!$E$9<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C19,'Input Variables'!$E$10<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C19,'Input Variables'!$E$11<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C19,'Input Variables'!$E$12<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C19,'Input Variables'!$E$13<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C19,'Input Variables'!$E$14<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C19,'Input Variables'!$E$15<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C19,'Input Variables'!$E$16<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C19,'Input Variables'!$E$17<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C19,'Input Variables'!$E$18<=D19),1,0))","v":""},{"$f":"IF(OR(C19=\"\",D19=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C19,'Input Variables'!$E$19<=D19),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W20=\"\", \"\", IF(V20=\"Hours\", (W20*('Input Variables'!$E$3/5))*U20*T20, W20*U20*T20))","v":""},{"$f":"IF(OR(W20=\"\", C20=\"\",D20=\"\"), \"\", IF(V20=\"Hours\", (AJ20*('Input Variables'!$E$3/5))*U20, AJ20*U20))","v":""},{"$f":"IF(OR(E20=\"\",G20=\"\",S20=\"\"),\"\",IF(AND(G20=\"Yes\",V20=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U20*T20,IF(G20=\"Yes\",'Input Variables'!$E$8*U20*T20,0)))","v":""},"",null,null,"","","","",0,{"$f":"E20/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F20=\"\",E20=\"\",S20=\"\"),\"\",IF(F20='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F20='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W20=\"\", \"\", IF(V20=\"Hours\", (W20*'Input Variables'!$E$3/5)*U20, W20*U20))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C20,'Input Variables'!$E$9<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C20,'Input Variables'!$E$10<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C20,'Input Variables'!$E$11<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C20,'Input Variables'!$E$12<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C20,'Input Variables'!$E$13<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C20,'Input Variables'!$E$14<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C20,'Input Variables'!$E$15<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C20,'Input Variables'!$E$16<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C20,'Input Variables'!$E$17<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C20,'Input Variables'!$E$18<=D20),1,0))","v":""},{"$f":"IF(OR(C20=\"\",D20=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C20,'Input Variables'!$E$19<=D20),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W21=\"\", \"\", IF(V21=\"Hours\", (W21*('Input Variables'!$E$3/5))*U21*T21, W21*U21*T21))","v":""},{"$f":"IF(OR(W21=\"\", C21=\"\",D21=\"\"), \"\", IF(V21=\"Hours\", (AJ21*('Input Variables'!$E$3/5))*U21, AJ21*U21))","v":""},{"$f":"IF(OR(E21=\"\",G21=\"\",S21=\"\"),\"\",IF(AND(G21=\"Yes\",V21=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U21*T21,IF(G21=\"Yes\",'Input Variables'!$E$8*U21*T21,0)))","v":""},"",null,null,"","","","",0,{"$f":"E21/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F21=\"\",E21=\"\",S21=\"\"),\"\",IF(F21='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F21='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W21=\"\", \"\", IF(V21=\"Hours\", (W21*'Input Variables'!$E$3/5)*U21, W21*U21))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C21,'Input Variables'!$E$9<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C21,'Input Variables'!$E$10<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C21,'Input Variables'!$E$11<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C21,'Input Variables'!$E$12<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C21,'Input Variables'!$E$13<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C21,'Input Variables'!$E$14<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C21,'Input Variables'!$E$15<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C21,'Input Variables'!$E$16<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C21,'Input Variables'!$E$17<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C21,'Input Variables'!$E$18<=D21),1,0))","v":""},{"$f":"IF(OR(C21=\"\",D21=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C21,'Input Variables'!$E$19<=D21),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W22=\"\", \"\", IF(V22=\"Hours\", (W22*('Input Variables'!$E$3/5))*U22*T22, W22*U22*T22))","v":""},{"$f":"IF(OR(W22=\"\", C22=\"\",D22=\"\"), \"\", IF(V22=\"Hours\", (AJ22*('Input Variables'!$E$3/5))*U22, AJ22*U22))","v":""},{"$f":"IF(OR(E22=\"\",G22=\"\",S22=\"\"),\"\",IF(AND(G22=\"Yes\",V22=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U22*T22,IF(G22=\"Yes\",'Input Variables'!$E$8*U22*T22,0)))","v":""},"",null,null,"","","","",0,{"$f":"E22/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F22=\"\",E22=\"\",S22=\"\"),\"\",IF(F22='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F22='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W22=\"\", \"\", IF(V22=\"Hours\", (W22*'Input Variables'!$E$3/5)*U22, W22*U22))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C22,'Input Variables'!$E$9<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C22,'Input Variables'!$E$10<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C22,'Input Variables'!$E$11<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C22,'Input Variables'!$E$12<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C22,'Input Variables'!$E$13<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C22,'Input Variables'!$E$14<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C22,'Input Variables'!$E$15<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C22,'Input Variables'!$E$16<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C22,'Input Variables'!$E$17<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C22,'Input Variables'!$E$18<=D22),1,0))","v":""},{"$f":"IF(OR(C22=\"\",D22=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C22,'Input Variables'!$E$19<=D22),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W23=\"\", \"\", IF(V23=\"Hours\", (W23*('Input Variables'!$E$3/5))*U23*T23, W23*U23*T23))","v":""},{"$f":"IF(OR(W23=\"\", C23=\"\",D23=\"\"), \"\", IF(V23=\"Hours\", (AJ23*('Input Variables'!$E$3/5))*U23, AJ23*U23))","v":""},{"$f":"IF(OR(E23=\"\",G23=\"\",S23=\"\"),\"\",IF(AND(G23=\"Yes\",V23=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U23*T23,IF(G23=\"Yes\",'Input Variables'!$E$8*U23*T23,0)))","v":""},"",null,null,"","","","",0,{"$f":"E23/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F23=\"\",E23=\"\",S23=\"\"),\"\",IF(F23='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F23='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W23=\"\", \"\", IF(V23=\"Hours\", (W23*'Input Variables'!$E$3/5)*U23, W23*U23))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C23,'Input Variables'!$E$9<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C23,'Input Variables'!$E$10<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C23,'Input Variables'!$E$11<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C23,'Input Variables'!$E$12<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C23,'Input Variables'!$E$13<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C23,'Input Variables'!$E$14<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C23,'Input Variables'!$E$15<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C23,'Input Variables'!$E$16<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C23,'Input Variables'!$E$17<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C23,'Input Variables'!$E$18<=D23),1,0))","v":""},{"$f":"IF(OR(C23=\"\",D23=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C23,'Input Variables'!$E$19<=D23),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W24=\"\", \"\", IF(V24=\"Hours\", (W24*('Input Variables'!$E$3/5))*U24*T24, W24*U24*T24))","v":""},{"$f":"IF(OR(W24=\"\", C24=\"\",D24=\"\"), \"\", IF(V24=\"Hours\", (AJ24*('Input Variables'!$E$3/5))*U24, AJ24*U24))","v":""},{"$f":"IF(OR(E24=\"\",G24=\"\",S24=\"\"),\"\",IF(AND(G24=\"Yes\",V24=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U24*T24,IF(G24=\"Yes\",'Input Variables'!$E$8*U24*T24,0)))","v":""},"",null,null,"","","","",0,{"$f":"E24/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F24=\"\",E24=\"\",S24=\"\"),\"\",IF(F24='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F24='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W24=\"\", \"\", IF(V24=\"Hours\", (W24*'Input Variables'!$E$3/5)*U24, W24*U24))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C24,'Input Variables'!$E$9<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C24,'Input Variables'!$E$10<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C24,'Input Variables'!$E$11<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C24,'Input Variables'!$E$12<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C24,'Input Variables'!$E$13<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C24,'Input Variables'!$E$14<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C24,'Input Variables'!$E$15<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C24,'Input Variables'!$E$16<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C24,'Input Variables'!$E$17<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C24,'Input Variables'!$E$18<=D24),1,0))","v":""},{"$f":"IF(OR(C24=\"\",D24=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C24,'Input Variables'!$E$19<=D24),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W25=\"\", \"\", IF(V25=\"Hours\", (W25*('Input Variables'!$E$3/5))*U25*T25, W25*U25*T25))","v":""},{"$f":"IF(OR(W25=\"\", C25=\"\",D25=\"\"), \"\", IF(V25=\"Hours\", (AJ25*('Input Variables'!$E$3/5))*U25, AJ25*U25))","v":""},{"$f":"IF(OR(E25=\"\",G25=\"\",S25=\"\"),\"\",IF(AND(G25=\"Yes\",V25=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U25*T25,IF(G25=\"Yes\",'Input Variables'!$E$8*U25*T25,0)))","v":""},"",null,null,{"$f":"IF(S25=\"Check dates!\", CONCATENATE(\" \",S25), \"\")","v":""},"","",{"$f":"IF(Q25=\"\", \"\", IF(OR(Q25<0), \"Check dates!\", IF(R25>52, \"Check dates!\", R25)))","v":""},0,{"$f":"E25/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F25=\"\",E25=\"\",S25=\"\"),\"\",IF(F25='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F25='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W25=\"\", \"\", IF(V25=\"Hours\", (W25*'Input Variables'!$E$3/5)*U25, W25*U25))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C25,'Input Variables'!$E$9<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C25,'Input Variables'!$E$10<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C25,'Input Variables'!$E$11<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C25,'Input Variables'!$E$12<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C25,'Input Variables'!$E$13<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C25,'Input Variables'!$E$14<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C25,'Input Variables'!$E$15<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C25,'Input Variables'!$E$16<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C25,'Input Variables'!$E$17<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C25,'Input Variables'!$E$18<=D25),1,0))","v":""},{"$f":"IF(OR(C25=\"\",D25=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C25,'Input Variables'!$E$19<=D25),1,0))","v":""},{"$f":"SUM(Y25:AI25)","v":0}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W26=\"\", \"\", IF(V26=\"Hours\", (W26*('Input Variables'!$E$3/5))*U26*T26, W26*U26*T26))","v":""},{"$f":"IF(OR(W26=\"\", C26=\"\",D26=\"\"), \"\", IF(V26=\"Hours\", (AJ26*('Input Variables'!$E$3/5))*U26, AJ26*U26))","v":""},{"$f":"IF(OR(E26=\"\",G26=\"\",S26=\"\"),\"\",IF(AND(G26=\"Yes\",V26=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U26*T26,IF(G26=\"Yes\",'Input Variables'!$E$8*U26*T26,0)))","v":""},"",null,null,"","","","",0,{"$f":"E26/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F26=\"\",E26=\"\",S26=\"\"),\"\",IF(F26='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F26='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W26=\"\", \"\", IF(V26=\"Hours\", (W26*'Input Variables'!$E$3/5)*U26, W26*U26))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C26,'Input Variables'!$E$9<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C26,'Input Variables'!$E$10<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C26,'Input Variables'!$E$11<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C26,'Input Variables'!$E$12<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C26,'Input Variables'!$E$13<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C26,'Input Variables'!$E$14<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C26,'Input Variables'!$E$15<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C26,'Input Variables'!$E$16<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C26,'Input Variables'!$E$17<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C26,'Input Variables'!$E$18<=D26),1,0))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C26,'Input Variables'!$E$19<=D26),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W27=\"\", \"\", IF(V27=\"Hours\", (W27*('Input Variables'!$E$3/5))*U27*T27, W27*U27*T27))","v":""},{"$f":"IF(OR(W27=\"\", C27=\"\",D27=\"\"), \"\", IF(V27=\"Hours\", (AJ27*('Input Variables'!$E$3/5))*U27, AJ27*U27))","v":""},{"$f":"IF(OR(E27=\"\",G27=\"\",S27=\"\"),\"\",IF(AND(G27=\"Yes\",V27=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U27*T27,IF(G27=\"Yes\",'Input Variables'!$E$8*U27*T27,0)))","v":""},"",null,null,"","","","",0,{"$f":"E27/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F27=\"\",E27=\"\",S27=\"\"),\"\",IF(F27='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F27='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W27=\"\", \"\", IF(V27=\"Hours\", (W27*'Input Variables'!$E$3/5)*U27, W27*U27))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C27,'Input Variables'!$E$9<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C27,'Input Variables'!$E$10<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C27,'Input Variables'!$E$11<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C27,'Input Variables'!$E$12<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C27,'Input Variables'!$E$13<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C27,'Input Variables'!$E$14<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C27,'Input Variables'!$E$15<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C27,'Input Variables'!$E$16<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C27,'Input Variables'!$E$17<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C27,'Input Variables'!$E$18<=D27),1,0))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C27,'Input Variables'!$E$19<=D27),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W28=\"\", \"\", IF(V28=\"Hours\", (W28*('Input Variables'!$E$3/5))*U28*T28, W28*U28*T28))","v":""},{"$f":"IF(OR(W28=\"\", C28=\"\",D28=\"\"), \"\", IF(V28=\"Hours\", (AJ28*('Input Variables'!$E$3/5))*U28, AJ28*U28))","v":""},{"$f":"IF(OR(E28=\"\",G28=\"\",S28=\"\"),\"\",IF(AND(G28=\"Yes\",V28=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U28*T28,IF(G28=\"Yes\",'Input Variables'!$E$8*U28*T28,0)))","v":""},"",null,null,"","","","",0,{"$f":"E28/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F28=\"\",E28=\"\",S28=\"\"),\"\",IF(F28='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F28='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W28=\"\", \"\", IF(V28=\"Hours\", (W28*'Input Variables'!$E$3/5)*U28, W28*U28))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C28,'Input Variables'!$E$9<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C28,'Input Variables'!$E$10<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C28,'Input Variables'!$E$11<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C28,'Input Variables'!$E$12<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C28,'Input Variables'!$E$13<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C28,'Input Variables'!$E$14<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C28,'Input Variables'!$E$15<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C28,'Input Variables'!$E$16<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C28,'Input Variables'!$E$17<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C28,'Input Variables'!$E$18<=D28),1,0))","v":""},{"$f":"IF(OR(C28=\"\",D28=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C28,'Input Variables'!$E$19<=D28),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W29=\"\", \"\", IF(V29=\"Hours\", (W29*('Input Variables'!$E$3/5))*U29*T29, W29*U29*T29))","v":""},{"$f":"IF(OR(W29=\"\", C29=\"\",D29=\"\"), \"\", IF(V29=\"Hours\", (AJ29*('Input Variables'!$E$3/5))*U29, AJ29*U29))","v":""},{"$f":"IF(OR(E29=\"\",G29=\"\",S29=\"\"),\"\",IF(AND(G29=\"Yes\",V29=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U29*T29,IF(G29=\"Yes\",'Input Variables'!$E$8*U29*T29,0)))","v":""},"",null,null,"","","","",0,{"$f":"E29/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F29=\"\",E29=\"\",S29=\"\"),\"\",IF(F29='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F29='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W29=\"\", \"\", IF(V29=\"Hours\", (W29*'Input Variables'!$E$3/5)*U29, W29*U29))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C29,'Input Variables'!$E$9<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C29,'Input Variables'!$E$10<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C29,'Input Variables'!$E$11<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C29,'Input Variables'!$E$12<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C29,'Input Variables'!$E$13<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C29,'Input Variables'!$E$14<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C29,'Input Variables'!$E$15<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C29,'Input Variables'!$E$16<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C29,'Input Variables'!$E$17<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C29,'Input Variables'!$E$18<=D29),1,0))","v":""},{"$f":"IF(OR(C29=\"\",D29=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C29,'Input Variables'!$E$19<=D29),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W30=\"\", \"\", IF(V30=\"Hours\", (W30*('Input Variables'!$E$3/5))*U30*T30, W30*U30*T30))","v":""},{"$f":"IF(OR(W30=\"\", C30=\"\",D30=\"\"), \"\", IF(V30=\"Hours\", (AJ30*('Input Variables'!$E$3/5))*U30, AJ30*U30))","v":""},{"$f":"IF(OR(E30=\"\",G30=\"\",S30=\"\"),\"\",IF(AND(G30=\"Yes\",V30=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U30*T30,IF(G30=\"Yes\",'Input Variables'!$E$8*U30*T30,0)))","v":""},"",null,null,"","","","",0,{"$f":"E30/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F30=\"\",E30=\"\",S30=\"\"),\"\",IF(F30='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F30='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W30=\"\", \"\", IF(V30=\"Hours\", (W30*'Input Variables'!$E$3/5)*U30, W30*U30))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C30,'Input Variables'!$E$9<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C30,'Input Variables'!$E$10<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C30,'Input Variables'!$E$11<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C30,'Input Variables'!$E$12<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C30,'Input Variables'!$E$13<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C30,'Input Variables'!$E$14<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C30,'Input Variables'!$E$15<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C30,'Input Variables'!$E$16<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C30,'Input Variables'!$E$17<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C30,'Input Variables'!$E$18<=D30),1,0))","v":""},{"$f":"IF(OR(C30=\"\",D30=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C30,'Input Variables'!$E$19<=D30),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W31=\"\", \"\", IF(V31=\"Hours\", (W31*('Input Variables'!$E$3/5))*U31*T31, W31*U31*T31))","v":""},{"$f":"IF(OR(W31=\"\", C31=\"\",D31=\"\"), \"\", IF(V31=\"Hours\", (AJ31*('Input Variables'!$E$3/5))*U31, AJ31*U31))","v":""},{"$f":"IF(OR(E31=\"\",G31=\"\",S31=\"\"),\"\",IF(AND(G31=\"Yes\",V31=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U31*T31,IF(G31=\"Yes\",'Input Variables'!$E$8*U31*T31,0)))","v":""},"",null,null,"","","","",0,{"$f":"E31/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F31=\"\",E31=\"\",S31=\"\"),\"\",IF(F31='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F31='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W31=\"\", \"\", IF(V31=\"Hours\", (W31*'Input Variables'!$E$3/5)*U31, W31*U31))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C31,'Input Variables'!$E$9<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C31,'Input Variables'!$E$10<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C31,'Input Variables'!$E$11<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C31,'Input Variables'!$E$12<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C31,'Input Variables'!$E$13<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C31,'Input Variables'!$E$14<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C31,'Input Variables'!$E$15<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C31,'Input Variables'!$E$16<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C31,'Input Variables'!$E$17<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C31,'Input Variables'!$E$18<=D31),1,0))","v":""},{"$f":"IF(OR(C31=\"\",D31=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C31,'Input Variables'!$E$19<=D31),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W32=\"\", \"\", IF(V32=\"Hours\", (W32*('Input Variables'!$E$3/5))*U32*T32, W32*U32*T32))","v":""},{"$f":"IF(OR(W32=\"\", C32=\"\",D32=\"\"), \"\", IF(V32=\"Hours\", (AJ32*('Input Variables'!$E$3/5))*U32, AJ32*U32))","v":""},{"$f":"IF(OR(E32=\"\",G32=\"\",S32=\"\"),\"\",IF(AND(G32=\"Yes\",V32=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U32*T32,IF(G32=\"Yes\",'Input Variables'!$E$8*U32*T32,0)))","v":""},"",null,null,"","","","",0,{"$f":"E32/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F32=\"\",E32=\"\",S32=\"\"),\"\",IF(F32='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F32='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W32=\"\", \"\", IF(V32=\"Hours\", (W32*'Input Variables'!$E$3/5)*U32, W32*U32))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C32,'Input Variables'!$E$9<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C32,'Input Variables'!$E$10<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C32,'Input Variables'!$E$11<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C32,'Input Variables'!$E$12<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C32,'Input Variables'!$E$13<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C32,'Input Variables'!$E$14<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C32,'Input Variables'!$E$15<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C32,'Input Variables'!$E$16<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C32,'Input Variables'!$E$17<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C32,'Input Variables'!$E$18<=D32),1,0))","v":""},{"$f":"IF(OR(C32=\"\",D32=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C32,'Input Variables'!$E$19<=D32),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W33=\"\", \"\", IF(V33=\"Hours\", (W33*('Input Variables'!$E$3/5))*U33*T33, W33*U33*T33))","v":""},{"$f":"IF(OR(W33=\"\", C33=\"\",D33=\"\"), \"\", IF(V33=\"Hours\", (AJ33*('Input Variables'!$E$3/5))*U33, AJ33*U33))","v":""},{"$f":"IF(OR(E33=\"\",G33=\"\",S33=\"\"),\"\",IF(AND(G33=\"Yes\",V33=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U33*T33,IF(G33=\"Yes\",'Input Variables'!$E$8*U33*T33,0)))","v":""},"",null,null,"","","","",0,{"$f":"E33/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F33=\"\",E33=\"\",S33=\"\"),\"\",IF(F33='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F33='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W33=\"\", \"\", IF(V33=\"Hours\", (W33*'Input Variables'!$E$3/5)*U33, W33*U33))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C33,'Input Variables'!$E$9<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C33,'Input Variables'!$E$10<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C33,'Input Variables'!$E$11<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C33,'Input Variables'!$E$12<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C33,'Input Variables'!$E$13<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C33,'Input Variables'!$E$14<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C33,'Input Variables'!$E$15<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C33,'Input Variables'!$E$16<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C33,'Input Variables'!$E$17<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C33,'Input Variables'!$E$18<=D33),1,0))","v":""},{"$f":"IF(OR(C33=\"\",D33=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C33,'Input Variables'!$E$19<=D33),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W34=\"\", \"\", IF(V34=\"Hours\", (W34*('Input Variables'!$E$3/5))*U34*T34, W34*U34*T34))","v":""},{"$f":"IF(OR(W34=\"\", C34=\"\",D34=\"\"), \"\", IF(V34=\"Hours\", (AJ34*('Input Variables'!$E$3/5))*U34, AJ34*U34))","v":""},{"$f":"IF(OR(E34=\"\",G34=\"\",S34=\"\"),\"\",IF(AND(G34=\"Yes\",V34=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U34*T34,IF(G34=\"Yes\",'Input Variables'!$E$8*U34*T34,0)))","v":""},"",null,null,"","","","",0,{"$f":"E34/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F34=\"\",E34=\"\",S34=\"\"),\"\",IF(F34='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F34='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W34=\"\", \"\", IF(V34=\"Hours\", (W34*'Input Variables'!$E$3/5)*U34, W34*U34))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C34,'Input Variables'!$E$9<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C34,'Input Variables'!$E$10<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C34,'Input Variables'!$E$11<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C34,'Input Variables'!$E$12<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C34,'Input Variables'!$E$13<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C34,'Input Variables'!$E$14<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C34,'Input Variables'!$E$15<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C34,'Input Variables'!$E$16<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C34,'Input Variables'!$E$17<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C34,'Input Variables'!$E$18<=D34),1,0))","v":""},{"$f":"IF(OR(C34=\"\",D34=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C34,'Input Variables'!$E$19<=D34),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W35=\"\", \"\", IF(V35=\"Hours\", (W35*('Input Variables'!$E$3/5))*U35*T35, W35*U35*T35))","v":""},{"$f":"IF(OR(W35=\"\", C35=\"\",D35=\"\"), \"\", IF(V35=\"Hours\", (AJ35*('Input Variables'!$E$3/5))*U35, AJ35*U35))","v":""},{"$f":"IF(OR(E35=\"\",G35=\"\",S35=\"\"),\"\",IF(AND(G35=\"Yes\",V35=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U35*T35,IF(G35=\"Yes\",'Input Variables'!$E$8*U35*T35,0)))","v":""},"",null,null,{"$f":"IF(S35=\"Check dates!\", CONCATENATE(\" \",S35), \"\")","v":""},"","",{"$f":"IF(Q35=\"\", \"\", IF(OR(Q35<0), \"Check dates!\", IF(R35>52, \"Check dates!\", R35)))","v":""},0,{"$f":"E35/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F35=\"\",E35=\"\",S35=\"\"),\"\",IF(F35='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F35='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W35=\"\", \"\", IF(V35=\"Hours\", (W35*'Input Variables'!$E$3/5)*U35, W35*U35))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C35,'Input Variables'!$E$9<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C35,'Input Variables'!$E$10<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C35,'Input Variables'!$E$11<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C35,'Input Variables'!$E$12<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C35,'Input Variables'!$E$13<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C35,'Input Variables'!$E$14<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C35,'Input Variables'!$E$15<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C35,'Input Variables'!$E$16<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C35,'Input Variables'!$E$17<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C35,'Input Variables'!$E$18<=D35),1,0))","v":""},{"$f":"IF(OR(C35=\"\",D35=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C35,'Input Variables'!$E$19<=D35),1,0))","v":""},{"$f":"SUM(Y35:AI35)","v":0}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W36=\"\", \"\", IF(V36=\"Hours\", (W36*('Input Variables'!$E$3/5))*U36*T36, W36*U36*T36))","v":""},{"$f":"IF(OR(W36=\"\", C36=\"\",D36=\"\"), \"\", IF(V36=\"Hours\", (AJ36*('Input Variables'!$E$3/5))*U36, AJ36*U36))","v":""},{"$f":"IF(OR(E36=\"\",G36=\"\",S36=\"\"),\"\",IF(AND(G36=\"Yes\",V36=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U36*T36,IF(G36=\"Yes\",'Input Variables'!$E$8*U36*T36,0)))","v":""},"",null,null,"","","","",0,{"$f":"E36/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F36=\"\",E36=\"\",S36=\"\"),\"\",IF(F36='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F36='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W36=\"\", \"\", IF(V36=\"Hours\", (W36*'Input Variables'!$E$3/5)*U36, W36*U36))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C36,'Input Variables'!$E$9<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C36,'Input Variables'!$E$10<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C36,'Input Variables'!$E$11<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C36,'Input Variables'!$E$12<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C36,'Input Variables'!$E$13<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C36,'Input Variables'!$E$14<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C36,'Input Variables'!$E$15<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C36,'Input Variables'!$E$16<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C36,'Input Variables'!$E$17<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C36,'Input Variables'!$E$18<=D36),1,0))","v":""},{"$f":"IF(OR(C36=\"\",D36=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C36,'Input Variables'!$E$19<=D36),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W37=\"\", \"\", IF(V37=\"Hours\", (W37*('Input Variables'!$E$3/5))*U37*T37, W37*U37*T37))","v":""},{"$f":"IF(OR(W37=\"\", C37=\"\",D37=\"\"), \"\", IF(V37=\"Hours\", (AJ37*('Input Variables'!$E$3/5))*U37, AJ37*U37))","v":""},{"$f":"IF(OR(E37=\"\",G37=\"\",S37=\"\"),\"\",IF(AND(G37=\"Yes\",V37=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U37*T37,IF(G37=\"Yes\",'Input Variables'!$E$8*U37*T37,0)))","v":""},"",null,null,"","","","",0,{"$f":"E37/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F37=\"\",E37=\"\",S37=\"\"),\"\",IF(F37='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F37='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W37=\"\", \"\", IF(V37=\"Hours\", (W37*'Input Variables'!$E$3/5)*U37, W37*U37))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C37,'Input Variables'!$E$9<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C37,'Input Variables'!$E$10<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C37,'Input Variables'!$E$11<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C37,'Input Variables'!$E$12<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C37,'Input Variables'!$E$13<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C37,'Input Variables'!$E$14<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C37,'Input Variables'!$E$15<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C37,'Input Variables'!$E$16<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C37,'Input Variables'!$E$17<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C37,'Input Variables'!$E$18<=D37),1,0))","v":""},{"$f":"IF(OR(C37=\"\",D37=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C37,'Input Variables'!$E$19<=D37),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W38=\"\", \"\", IF(V38=\"Hours\", (W38*('Input Variables'!$E$3/5))*U38*T38, W38*U38*T38))","v":""},{"$f":"IF(OR(W38=\"\", C38=\"\",D38=\"\"), \"\", IF(V38=\"Hours\", (AJ38*('Input Variables'!$E$3/5))*U38, AJ38*U38))","v":""},{"$f":"IF(OR(E38=\"\",G38=\"\",S38=\"\"),\"\",IF(AND(G38=\"Yes\",V38=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U38*T38,IF(G38=\"Yes\",'Input Variables'!$E$8*U38*T38,0)))","v":""},"",null,null,"","","","",0,{"$f":"E38/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F38=\"\",E38=\"\",S38=\"\"),\"\",IF(F38='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F38='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W38=\"\", \"\", IF(V38=\"Hours\", (W38*'Input Variables'!$E$3/5)*U38, W38*U38))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C38,'Input Variables'!$E$9<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C38,'Input Variables'!$E$10<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C38,'Input Variables'!$E$11<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C38,'Input Variables'!$E$12<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C38,'Input Variables'!$E$13<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C38,'Input Variables'!$E$14<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C38,'Input Variables'!$E$15<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C38,'Input Variables'!$E$16<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C38,'Input Variables'!$E$17<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C38,'Input Variables'!$E$18<=D38),1,0))","v":""},{"$f":"IF(OR(C38=\"\",D38=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C38,'Input Variables'!$E$19<=D38),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W39=\"\", \"\", IF(V39=\"Hours\", (W39*('Input Variables'!$E$3/5))*U39*T39, W39*U39*T39))","v":""},{"$f":"IF(OR(W39=\"\", C39=\"\",D39=\"\"), \"\", IF(V39=\"Hours\", (AJ39*('Input Variables'!$E$3/5))*U39, AJ39*U39))","v":""},{"$f":"IF(OR(E39=\"\",G39=\"\",S39=\"\"),\"\",IF(AND(G39=\"Yes\",V39=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U39*T39,IF(G39=\"Yes\",'Input Variables'!$E$8*U39*T39,0)))","v":""},"",null,null,"","","","",0,{"$f":"E39/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F39=\"\",E39=\"\",S39=\"\"),\"\",IF(F39='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F39='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W39=\"\", \"\", IF(V39=\"Hours\", (W39*'Input Variables'!$E$3/5)*U39, W39*U39))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C39,'Input Variables'!$E$9<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C39,'Input Variables'!$E$10<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C39,'Input Variables'!$E$11<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C39,'Input Variables'!$E$12<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C39,'Input Variables'!$E$13<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C39,'Input Variables'!$E$14<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C39,'Input Variables'!$E$15<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C39,'Input Variables'!$E$16<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C39,'Input Variables'!$E$17<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C39,'Input Variables'!$E$18<=D39),1,0))","v":""},{"$f":"IF(OR(C39=\"\",D39=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C39,'Input Variables'!$E$19<=D39),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W40=\"\", \"\", IF(V40=\"Hours\", (W40*('Input Variables'!$E$3/5))*U40*T40, W40*U40*T40))","v":""},{"$f":"IF(OR(W40=\"\", C40=\"\",D40=\"\"), \"\", IF(V40=\"Hours\", (AJ40*('Input Variables'!$E$3/5))*U40, AJ40*U40))","v":""},{"$f":"IF(OR(E40=\"\",G40=\"\",S40=\"\"),\"\",IF(AND(G40=\"Yes\",V40=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U40*T40,IF(G40=\"Yes\",'Input Variables'!$E$8*U40*T40,0)))","v":""},"",null,null,"","","","",0,{"$f":"E40/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F40=\"\",E40=\"\",S40=\"\"),\"\",IF(F40='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F40='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W40=\"\", \"\", IF(V40=\"Hours\", (W40*'Input Variables'!$E$3/5)*U40, W40*U40))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C40,'Input Variables'!$E$9<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C40,'Input Variables'!$E$10<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C40,'Input Variables'!$E$11<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C40,'Input Variables'!$E$12<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C40,'Input Variables'!$E$13<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C40,'Input Variables'!$E$14<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C40,'Input Variables'!$E$15<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C40,'Input Variables'!$E$16<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C40,'Input Variables'!$E$17<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C40,'Input Variables'!$E$18<=D40),1,0))","v":""},{"$f":"IF(OR(C40=\"\",D40=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C40,'Input Variables'!$E$19<=D40),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W41=\"\", \"\", IF(V41=\"Hours\", (W41*('Input Variables'!$E$3/5))*U41*T41, W41*U41*T41))","v":""},{"$f":"IF(OR(W41=\"\", C41=\"\",D41=\"\"), \"\", IF(V41=\"Hours\", (AJ41*('Input Variables'!$E$3/5))*U41, AJ41*U41))","v":""},{"$f":"IF(OR(E41=\"\",G41=\"\",S41=\"\"),\"\",IF(AND(G41=\"Yes\",V41=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U41*T41,IF(G41=\"Yes\",'Input Variables'!$E$8*U41*T41,0)))","v":""},"",null,null,"","","","",0,{"$f":"E41/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F41=\"\",E41=\"\",S41=\"\"),\"\",IF(F41='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F41='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W41=\"\", \"\", IF(V41=\"Hours\", (W41*'Input Variables'!$E$3/5)*U41, W41*U41))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C41,'Input Variables'!$E$9<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C41,'Input Variables'!$E$10<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C41,'Input Variables'!$E$11<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C41,'Input Variables'!$E$12<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C41,'Input Variables'!$E$13<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C41,'Input Variables'!$E$14<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C41,'Input Variables'!$E$15<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C41,'Input Variables'!$E$16<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C41,'Input Variables'!$E$17<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C41,'Input Variables'!$E$18<=D41),1,0))","v":""},{"$f":"IF(OR(C41=\"\",D41=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C41,'Input Variables'!$E$19<=D41),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W42=\"\", \"\", IF(V42=\"Hours\", (W42*('Input Variables'!$E$3/5))*U42*T42, W42*U42*T42))","v":""},{"$f":"IF(OR(W42=\"\", C42=\"\",D42=\"\"), \"\", IF(V42=\"Hours\", (AJ42*('Input Variables'!$E$3/5))*U42, AJ42*U42))","v":""},{"$f":"IF(OR(E42=\"\",G42=\"\",S42=\"\"),\"\",IF(AND(G42=\"Yes\",V42=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U42*T42,IF(G42=\"Yes\",'Input Variables'!$E$8*U42*T42,0)))","v":""},"",null,null,"","","","",0,{"$f":"E42/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F42=\"\",E42=\"\",S42=\"\"),\"\",IF(F42='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F42='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W42=\"\", \"\", IF(V42=\"Hours\", (W42*'Input Variables'!$E$3/5)*U42, W42*U42))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C42,'Input Variables'!$E$9<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C42,'Input Variables'!$E$10<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C42,'Input Variables'!$E$11<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C42,'Input Variables'!$E$12<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C42,'Input Variables'!$E$13<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C42,'Input Variables'!$E$14<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C42,'Input Variables'!$E$15<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C42,'Input Variables'!$E$16<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C42,'Input Variables'!$E$17<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C42,'Input Variables'!$E$18<=D42),1,0))","v":""},{"$f":"IF(OR(C42=\"\",D42=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C42,'Input Variables'!$E$19<=D42),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W43=\"\", \"\", IF(V43=\"Hours\", (W43*('Input Variables'!$E$3/5))*U43*T43, W43*U43*T43))","v":""},{"$f":"IF(OR(W43=\"\", C43=\"\",D43=\"\"), \"\", IF(V43=\"Hours\", (AJ43*('Input Variables'!$E$3/5))*U43, AJ43*U43))","v":""},{"$f":"IF(OR(E43=\"\",G43=\"\",S43=\"\"),\"\",IF(AND(G43=\"Yes\",V43=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U43*T43,IF(G43=\"Yes\",'Input Variables'!$E$8*U43*T43,0)))","v":""},"",null,null,"","","","",0,{"$f":"E43/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F43=\"\",E43=\"\",S43=\"\"),\"\",IF(F43='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F43='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W43=\"\", \"\", IF(V43=\"Hours\", (W43*'Input Variables'!$E$3/5)*U43, W43*U43))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C43,'Input Variables'!$E$9<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C43,'Input Variables'!$E$10<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C43,'Input Variables'!$E$11<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C43,'Input Variables'!$E$12<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C43,'Input Variables'!$E$13<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C43,'Input Variables'!$E$14<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C43,'Input Variables'!$E$15<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C43,'Input Variables'!$E$16<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C43,'Input Variables'!$E$17<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C43,'Input Variables'!$E$18<=D43),1,0))","v":""},{"$f":"IF(OR(C43=\"\",D43=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C43,'Input Variables'!$E$19<=D43),1,0))","v":""},0]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(W44=\"\", \"\", IF(V44=\"Hours\", (W44*('Input Variables'!$E$3/5))*U44*T44, W44*U44*T44))","v":""},{"$f":"IF(OR(W44=\"\", C44=\"\",D44=\"\"), \"\", IF(V44=\"Hours\", (AJ44*('Input Variables'!$E$3/5))*U44, AJ44*U44))","v":""},{"$f":"IF(OR(E44=\"\",G44=\"\",S44=\"\"),\"\",IF(AND(G44=\"Yes\",V44=\"Hours\"),('Input Variables'!$E$8*('Input Variables'!$E$3/5))*U44*T44,IF(G44=\"Yes\",'Input Variables'!$E$8*U44*T44,0)))","v":""},"",null,null,"","","","",0,{"$f":"E44/'Input Variables'!$E$3","v":0},"Days",{"$f":"IF(OR(F44=\"\",E44=\"\",S44=\"\"),\"\",IF(F44='Input Variables'!$E$4,'Input Variables'!$E$6,IF(F44='Input Variables'!$E$5,'Input Variables'!$E$7)))","v":""},{"$f":"IF(W44=\"\", \"\", IF(V44=\"Hours\", (W44*'Input Variables'!$E$3/5)*U44, W44*U44))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$9>=C44,'Input Variables'!$E$9<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$10>=C44,'Input Variables'!$E$10<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$11>=C44,'Input Variables'!$E$11<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$12>=C44,'Input Variables'!$E$12<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$13>=C44,'Input Variables'!$E$13<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$14>=C44,'Input Variables'!$E$14<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$15>=C44,'Input Variables'!$E$15<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$16>=C44,'Input Variables'!$E$16<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$17>=C44,'Input Variables'!$E$17<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$18>=C44,'Input Variables'!$E$18<=D44),1,0))","v":""},{"$f":"IF(OR(C44=\"\",D44=\"\"),\"\",IF(AND('Input Variables'!$E$19>=C44,'Input Variables'!$E$19<=D44),1,0))","v":""},0]

{"sheet":"Leave Information","index":2,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,1,49,9],[48,1,48,9],[47,1,47,9],[42,1,42,9],[39,1,39,9],[45,1,45,9],[44,1,44,9],[43,1,43,9],[41,1,41,9],[11,5,11,6],[11,3,11,4],[13,1,13,9],[12,1,12,2],[11,1,11,2],[1,1,1,6],[6,1,6,9],[5,1,5,9],[12,7,12,8],[11,7,11,8],[12,3,12,4],[4,1,4,9],[10,1,10,2],[3,1,3,9],[10,3,10,4],[10,5,10,6],[10,7,10,8],[9,1,9,9],[8,1,8,9],[7,1,7,9],[12,5,12,6],[14,1,14,9],[46,1,46,9],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[15,1,15,9],[40,1,40,9],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[17,1,17,2],[17,3,17,4],[17,5,17,6],[17,7,17,8],[20,1,20,9],[19,1,19,9],[21,1,21,9],[22,1,22,9],[23,1,23,9],[24,1,24,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[28,1,28,9],[29,1,29,9],[30,1,30,9],[31,1,31,9],[33,1,33,9],[32,1,32,9],[35,1,35,9],[34,1,34,9],[36,1,36,9],[37,1,37,9],[38,1,38,9]]}
[]
[null,"LEAVE INFORMATION"]
[]
[null,"Leave year / Timing of leave:"]
[null,"> The leave year normally runs from 1st April to 31st March but may be varied to suit service needs."]
[null,"> The timing of all leave is subject to the approval of the manager."]
[]
[null,"Entitlement:"]
[null,"> The annual leave entitlement excluding bank holidays is as follows:"]
[]
[null,"Grade",null,"Spine Point",null,"Less than 5 years continuous Local Government Service",null,"5 years or more continuous Local Government Service"]
[null,"1-7",null,"1-21",null,"24 days / 177.6 hrs",null,"29 days / 214.6 hrs"]
[null,"8-16",null,"22-48",null,"27 days / 199.8 hrs",null,"32 days / 236.8 hrs"]
[]
[null,"> The annual leave entitlement including bank holidays is as follows:"]
[]
[null,"Grade",null,"Spine Point",null,"Less than 5 years continuous Local Government Service",null,"5 years or more continuous Local Government Service"]
[null,"1-7",null,"1-21",null,"32 days / 236.8 hrs",null,"37 days / 273.8 hrs"]
[null,"8-16",null,"22-48",null,"35 days / 259 hrs",null,"40 days / 296 hrs"]
[]
[null,"> The bank holidays currently logged in this annual leave record are:"]
[null,{"$f":"IF('Input Variables'!E9=\"\", \"\", CONCATENATE(\"          - Good Friday: \",TEXT('Input Variables'!E9,\"dd mmm yyyy\")))","v":"          - Good Friday: 15 Apr 2022"}]
[null,{"$f":"IF('Input Variables'!E10=\"\",\"\",CONCATENATE(\"          - Easter Monday: \",TEXT('Input Variables'!E10,\"dd mmm yyyy\")))","v":"          - Easter Monday: 18 Apr 2022"}]
[null,{"$f":"IF('Input Variables'!E11=\"\",\"\",CONCATENATE(\"          - May Day: \",TEXT('Input Variables'!E11,\"dd mmm yyyy\")))","v":"          - May Day: 02 May 2022"}]
[null,{"$f":"IF('Input Variables'!E12=\"\",\"\",CONCATENATE(\"          - Spring Bank Holiday: \",TEXT('Input Variables'!E12,\"dd mmm yyyy\")))","v":"          - Spring Bank Holiday: 02 Jun 2022"}]
[null,{"$f":"IF('Input Variables'!E13=\"\",\"\",CONCATENATE(\"          - Late Summer Bank Holiday: \",TEXT('Input Variables'!E13,\"dd mmm yyyy\")))","v":"          - Late Summer Bank Holiday: 29 Aug 2022"}]
[null,{"$f":"IF('Input Variables'!E14=\"\",\"\",CONCATENATE(\"          - Christmas Day: \",TEXT('Input Variables'!E14,\"dd mmm yyyy\")))","v":"          - Christmas Day: 27 Dec 2022"}]
[null,{"$f":"IF('Input Variables'!E15=\"\",\"\",CONCATENATE(\"          - Boxing Day: \",TEXT('Input Variables'!E15,\"dd mmm yyyy\")))","v":"          - Boxing Day: 26 Dec 2022"}]
[null,{"$f":"IF('Input Variables'!E16=\"\",\"\",CONCATENATE(\"          - New Year's Day: \",TEXT('Input Variables'!E16,\"dd mmm yyyy\")))","v":"          - New Year's Day: 02 Jan 2023"}]
[null,{"$f":"IF('Input Variables'!E17=\"\",\"\",CONCATENATE(\"          - Additional Bank Holiday: \",TEXT('Input Variables'!E17,\"dd mmm yyyy\")))","v":"          - Additional Bank Holiday: 03 Jun 2022"}]
[null,{"$f":"IF('Input Variables'!E18=\"\",\"\",CONCATENATE(\"          - Additional Bank Holiday: \",TEXT('Input Variables'!E18,\"dd mmm yyyy\")))","v":""}]
[null,{"$f":"IF('Input Variables'!E19=\"\",\"\",CONCATENATE(\"          - Additional Bank Holiday: \",TEXT('Input Variables'!E19,\"dd mmm yyyy\")))","v":""}]
[]
[null,"Designated leave:"]
[null,"> A maximum of 2 days per year may be designated as mandatory leave days.  If an employee is due to work on these days they MUST be taken as annual leave and will be taken off the employee's total leave entitlement.  These days should be recorded as Designated leave type."]
[null,"> The designated leave days currently logged in this annual leave record are:"]
[null,{"$f":"IF('Input Variables'!E20=\"\",\"\",CONCATENATE(\"          - Designated Leave Day: \",TEXT('Input Variables'!E20,\"dd mmm yyyy\")))","v":""}]
[null,{"$f":"IF('Input Variables'!E21=\"\",\"\",CONCATENATE(\"          - Designated Leave Day: \",TEXT('Input Variables'!E21,\"dd mmm yyyy\")))","v":""}]
[]
[null,"Carried forward and advanced leave:"]
[null,"> Employees may carry forward to the following year or bring into a current year up to five days \n(37 hrs) of their leave entitlement.  This figure should be checked with the manager."]
[null,"> Additional days may be transferred but with the approval of the manager."]
[]
[null,"Flexi-leave:"]
[null,"> Flexi-leave cannot be taken unless hours have been accrued."]
[null,"> Flexi-leave may be subject to a maximum limit based on service needs."]
[null,"> Flexi-leave should be agreed and signed by the manager."]
[]
[null,"Other leave:"]
[null,"> Special Leave includes leave for family or personal reasons, leave for public duties, jury service etc.  Please see Local Scheme of Conditions of Service booklet for further information."]

{"sheet":"Guidance","index":3,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[17,1,17,9],[16,1,16,9],[23,1,23,9],[22,1,22,9],[18,1,18,9],[1,1,1,6],[21,1,21,9],[4,1,4,9],[3,1,3,9],[13,1,13,9],[5,1,5,9],[6,1,6,9],[10,1,10,9],[11,1,11,9],[12,1,12,9],[14,1,14,9],[7,1,7,9],[19,1,19,9],[20,1,20,9],[9,1,9,9],[15,1,15,9],[39,1,39,9],[25,1,25,9],[29,1,29,9],[27,1,27,5],[24,1,24,9]]}
[]
[null,"GUIDANCE"]
[]
[null,"Completing the Record of Leave:"]
[null,"> Complete each of the fields under the RECORD OF LEAVE heading: Name of officer, Name of manager, Service area, Record start date, Record end date and Hours per week. Select your Job grade, whether you qualify for Additional days for 5+ years continuous service and whether or not you work Compressed hours."]
[null,"> Your leave entitlements (excluding carry forward and additional) will be calculated based on what you put in Hours per week, the Job grade you select, whether you qualify for Additional days for 5+ years continuous service, the Record start and end dates you enter and the Number of weeks (calculated based on Record start and end dates)."]
[null,"> Carried Forward / Advanced Leave: You should enter the Number of days/hours carried forward in this section."]
[null,"> Annual Leave Entitlement: You should enter any Additional days/hours in this section, for example agreed unpaid leave.  The TOTAL LEAVE ENTITLEMENT will be calculated based on combining Basic leave entitlement, Bank holiday entitlement, Additional days for continuous service, Number of days carried forward and Additional days (e.g. unpaid)."]
[]
[null,"Completing Detailed Record of Leave:"]
[null,"> This table is where you record each instance of leave to be authorised."]
[null,"> Inclusive Dates From / To: This should be the first day of leave and last day of leave (not the day of return) and should be entered as dd/mm/yy."]
[null,"> Number of leave days/hours: This should be the total number of days/hours leave required for this instance (NOT including weekends).  For example 2 weeks leave for someone who works full time would be 10 days (unless there are any bank holidays during those 2 weeks) Bank holidays should be recorded on a separate row to Annual leave."]
[null,"> Cumulative days taken and Days remaining: These help you track your leave as you enter new records throughout the leave year.  Only Annual and Bank hol leave types will count towards this."]
[null,"> Leave type: Select the leave type for the record you are entering.  Annual, Designated and Bank Hol will take it off your cumulative leave entitlement remaining, whilst any of the other types will just be shown cumulatively in the summary.  The Cancelled option should be used for leave that has already been authorised and will exclude it from the leave taken / remaining summary calculations."]
[null,"> Comments: This can be used for any notes you would like to make about the leave instance."]
[null,"> Approve by (Manager / Date): Once leave has been approved the managers name and the date of approval should be recorded."]
[null,"> Insert / Delete Row: Additional rows can be inserted by clicking the Insert Row button or rows deleted by selecting any cell in the row and clicking the Delete Row button (please note the first two rows cannot be deleted)."]
[]
[null,"> Update Bank Holiday / Designated Leave Dates: The bank holiday dates will need updating each year (usually 1 April to 31 March) or based on your chosen Record start and end dates, any designated leave dates will also need updating. You can click the Update Bank Holiday / Designated Leave Dates button to enter the dates for the regular 8 bank holidays or any additional bank holidays (e.g. royal occasions) and a maximum of 2 designated leave dates.  There may also be instances where one or both of the Easter bank holidays fall within the same financial year period as the previous Easter bank holidays, you should use the Additional Bank Holiday fields to record the dates for the second Easter bank holiday(s)."]
[]
[]
[null,"Summary of Leave:"]
[null,"> This section contains calculations which will make it easier to track and review leave taken and remaining.  It also summarises flexi, special and other leave types taken."]
[]
[null,"CALCULATE AVERAGE HOURS PER WEEK FOR NON-STANDARD WORKING PATTERNS"]
[]
[null,"How many weeks per year are you contracted for?"]
[]
[null,"What are your working hours over a 2 weeks period? \n(This must be entered as decimal, e.g. 7 hours 30 minutes would be 7.5 hours)"]
[]
[null,null,"Mon","Tue","Wed","Thu","Fri","Sat","Sun","Total"]
[null,"Week 1:",null,null,null,null,null,null,null,{"$f":"IF(AND(C33=\"\",D33=\"\",E33=\"\",F33=\"\",G33=\"\",H33=\"\",I33=\"\"), \"\", SUM(C33:I33))","v":""}]
[null,"Week 2:",null,null,null,null,null,null,null,{"$f":"IF(AND(C34=\"\",D34=\"\",E34=\"\",F34=\"\",G34=\"\",H34=\"\",I34=\"\"), \"\", SUM(C34:I34))","v":""}]
[null,{"$f":"SUM(J33:J34)/2","v":0}]
[null,{"$f":"IF(B35=0, \"Enter your daily working hours over a 2 week period in the table above.\", CONCATENATE(\"This works out as an average of \",TEXT(ROUND(B35,3),\"0.00\"),\" hours per week.\"))","v":"Enter your daily working hours over a 2 week period in the table above."}]
[]
[null,"If this is incorrect, what are your contracted hours per week?",null,null,null,null,null,null,{"$f":"IF(OR(H38=\"\", H38=0), 0, 1)","v":0}]
[null,{"$f":"IF(I38=1, H38, B35)","v":0},{"$f":"B39*H28/52","v":0}]
[null,{"$f":"IF(OR(OR(H28=\"\",H28=0), AND(B35=0,I38=0)), \"Enter your contracted weeks per year and contracted hours per week to calculate your average hours per week.\", CONCATENATE(\"Based on the above, the average 'Hours per week' figure to use for calculating leave is \", TEXT(ROUND(C39,3),\"0.00\"), \".\"))","v":"Enter your contracted weeks per year and contracted hours per week to calculate your average hours per week."}]

{"sheet":"Lists","index":4,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[{"$f":"UserNameWindows()","v":"Graham.Johnson"},23,"Annual",170.2,28,{"$f":"E1*7.4","v":207.20000000000002}]
[{"$f":"TODAY()","v":"2021-12-30"},24,"Bank Hol",177.6,29,{"$f":"E2*7.4","v":214.60000000000002}]
[null,27,"Designated",199.8,32,{"$f":"E3*7.4","v":236.8}]
[null,28,"Flexi",207.2,33,{"$f":"E4*7.4","v":244.20000000000002}]
[null,null,"Special"]
[null,"Days","Disability"]
[null,"Hours","Cancelled"]
[null,{"$f":"IF('Record of Leave'!I11=\"Hours\", \"hours\", \"days\")","v":"days"},"Other"]
[null,"Number of "," carried forward:",{"$f":"CONCATENATE(B9,$B$8,C9)","v":"Number of days carried forward:"}]
[null,"Number of standard ",":",{"$f":"CONCATENATE(B10,$B$8,C10)","v":"Number of standard days:"}]
[null,"Additional ",":",{"$f":"CONCATENATE(B11,$B$8,C11)","v":"Additional days:"}]
[null,"Number of leave ",null,{"$f":"CONCATENATE(B12,$B$8)","v":"Number of leave days"}]
[null,"Cumulative "," taken",{"$f":"CONCATENATE(B13,$B$8,C13)","v":"Cumulative days taken"}]
[null,"Additional "," for 5+ years service:",{"$f":"CONCATENATE(B14,$B$8,C14)","v":"Additional days for 5+ years service:"}]
[null,{"$f":"'Input Variables'!E4","v":"1-7"}]
[null,{"$f":"'Input Variables'!E5","v":"8-16"}]
[null,"Total "," leave remaining:",{"$f":"CONCATENATE(B17,$B$8,C17)","v":"Total days leave remaining:"}]
[]
[]
[null,"HOW YOUR ANNUAL LEAVE HAS BEEN CALCULATED",null,null,null,null,null,null,null,"DAYS","HOURS"]
[null,"You have indicated that you work "," hours per week, which equates to "," full-time equivalent (FTE).  Your basic leave, bank holiday and continuous service entitlements have been prorated based on this FTE and on the number of weeks, which is calculated from the record start and end dates you have entered.",null,null,null,null,null,{"$f":"CONCATENATE(Lists!B21,'Record of Leave'!J6, Lists!C21, TEXT(ROUND('Record of Leave'!J11,3),\"0.00\"), Lists!D21)","v":"You have indicated that you work 37 hours per week, which equates to 1.00 full-time equivalent (FTE).  Your basic leave, bank holiday and continuous service entitlements have been prorated based on this FTE and on the number of weeks, which is calculated from the record start and end dates you have entered."},{"$f":"CONCATENATE(Lists!B21,'Record of Leave'!J6, Lists!C21, TEXT(ROUND('Record of Leave'!J11,3),\"0.00\"), Lists!D21)","v":"You have indicated that you work 37 hours per week, which equates to 1.00 full-time equivalent (FTE).  Your basic leave, bank holiday and continuous service entitlements have been prorated based on this FTE and on the number of weeks, which is calculated from the record start and end dates you have entered."}]
[null,"  The basic leave entitlement for grades "," is "," days.   This gives you "," hours. This gives you "," days of basic leave."," hours of basic leave.",{"$f":"IF('Record of Leave'!J7='Input Variables'!E5, TEXT(ROUND('Input Variables'!E7,3),\"0.00\"), TEXT(ROUND('Input Variables'!E6,3),\"0.00\"))","v":"24.00"},{"$f":"TEXT(ROUND(H22*('Input Variables'!E3/5),3),\"0.00\")","v":"177.60"},{"$f":"CONCATENATE(B22,'Record of Leave'!J7, Lists!C22, H22, D22, TEXT(ROUND('Record of Leave'!M13,3),\"0.00\"), Lists!F22)","v":"  The basic leave entitlement for grades 1-7 is 24.00 days.   This gives you 24.00 days of basic leave."},{"$f":"CONCATENATE(B22,'Record of Leave'!J7, Lists!C22, I22, E22, TEXT(ROUND('Record of Leave'!M13,3),\"0.00\"), Lists!G22)","v":"  The basic leave entitlement for grades 1-7 is 177.60 hours. This gives you 24.00 hours of basic leave."}]
[null,"  You are entitled to "," days for bank holidays during this period.  Which prorated gives you "," hours for bank holidays during this period.  Which prorated gives you "," days of bank holiday leave.  If you are due to work on a bank holiday this leave MUST be taken on those days."," hours of bank holiday leave.  If you are due to work on a bank holiday this leave MUST be taken on those days.",{"$f":"TEXT(ROUND('Input Variables'!F20,3),\"0.00\")","v":"9.00"},{"$f":"TEXT(ROUND(G23*('Input Variables'!E3/5),3),\"0.00\")","v":"66.60"},null,{"$f":"CONCATENATE(B23, G23, C23, TEXT(ROUND('Record of Leave'!M14,3),\"0.00\"),Lists!E23)","v":"  You are entitled to 9.00 days for bank holidays during this period.  Which prorated gives you 9.00 days of bank holiday leave.  If you are due to work on a bank holiday this leave MUST be taken on those days."},{"$f":"CONCATENATE(B23, H23, D23, TEXT(ROUND('Record of Leave'!M14,3),\"0.00\"),Lists!F23)","v":"  You are entitled to 66.60 hours for bank holidays during this period.  Which prorated gives you 9.00 hours of bank holiday leave.  If you are due to work on a bank holiday this leave MUST be taken on those days."}]
[null,"  The entitlement for 5 years or more local government continuous service is "," days.  Prorated this gives you "," hours.  Prorated this gives you "," days of additional leave for continuous service."," hours of additional leave for continuous service.",{"$f":"TEXT(ROUND('Input Variables'!E8,3),\"0.00\")","v":"5.00"},{"$f":"TEXT(ROUND(G24*('Input Variables'!E3/5),3),\"0.00\")","v":"37.00"},null,{"$f":"IF('Record of Leave'!J8=\"No\", \"\", CONCATENATE(B24, G24, C24, TEXT(ROUND('Record of Leave'!F15,3),\"0.00\"), Lists!E24))","v":""},{"$f":"IF('Record of Leave'!J8=\"No\", \"\", CONCATENATE(B24, H24, D24, TEXT(ROUND('Record of Leave'!F15,3),\"0.00\"), Lists!F24))","v":""}]
[null,"  You have entered a carry forward of "," days and additional leave of "," hours and additional leave of "," days."," hours."," weeks from "," to the "," of ",{"$f":"CONCATENATE(B26, F26,'Record of Leave'!J9, Lists!G25, TEXT('Record of Leave'!D9,\"dd mmm yyyy\"), Lists!H25, TEXT('Record of Leave'!D10,\"dd mmm yyyy\"), Lists!I25, TEXT(ROUND('Record of Leave'!M15,3),\"0.00\"), Lists!H26)","v":"  This gives you a total entitlement for the 52 weeks from 01 Apr 2022 to the 31 Mar 2023 of 33.00 days."},{"$f":"CONCATENATE(C26,F26, 'Record of Leave'!J9, Lists!G25, TEXT('Record of Leave'!D9,\"dd mmm yyyy\"), Lists!H25, TEXT('Record of Leave'!D10,\"dd mmm yyyy\"), Lists!I25, TEXT(ROUND('Record of Leave'!M15,3),\"0.00\"), Lists!I26)","v":"  This gives you a total entitlement for the 52 weeks from 01 Apr 2022 to the 31 Mar 2023 of 33.00 hours."}]
[null,{"$f":"IF(SUM('Record of Leave'!F13:G14)=0, \"\", CONCATENATE(B25, TEXT(ROUND('Record of Leave'!F13,3),\"0.00\"), Lists!C25, TEXT(ROUND('Record of Leave'!F14,3),\"0.00\"), Lists!E25))","v":""},{"$f":"IF(SUM('Record of Leave'!F13:G14)=0, \"\", CONCATENATE(B25, TEXT(ROUND('Record of Leave'!F13,3),\"0.00\"), Lists!D25, TEXT(ROUND('Record of Leave'!F14,3),\"0.00\"), Lists!F25))","v":""},null,null,"  This gives you a total entitlement for the ",null," days."," hours.",{"$f":"IF(OR('Record of Leave'!D9=\"\",'Record of Leave'!D10=\"\",'Record of Leave'!J6=\"\",'Record of Leave'!J7=\"\",'Record of Leave'!J8=\"\",'Record of Leave'!J9=\"\"), \"You have not completed all necessary fields in the 'Record of Leave' sheet; record start date, record end date, hours per week, job grade, continuous service and number of weeks.\", CONCATENATE(J21,J22,J23,J24,J25))","v":"You have indicated that you work 37 hours per week, which equates to 1.00 full-time equivalent (FTE).  Your basic leave, bank holiday and continuous service entitlements have been prorated based on this FTE and on the number of weeks, which is calculated from the record start and end dates you have entered.  The basic leave entitlement for grades 1-7 is 24.00 days.   This gives you 24.00 days of basic leave.  You are entitled to 9.00 days for bank holidays during this period.  Which prorated gives you 9.00 days of bank holiday leave.  If you are due to work on a bank holiday this leave MUST be taken on those days.  This gives you a total entitlement for the 52 weeks from 01 Apr 2022 to the 31 Mar 2023 of 33.00 days."},{"$f":"IF(OR('Record of Leave'!D9=\"\",'Record of Leave'!D10=\"\",'Record of Leave'!J6=\"\",'Record of Leave'!J7=\"\",'Record of Leave'!J8=\"\",'Record of Leave'!J9=\"\"), \"You have not completed all necessary fields in the 'Record of Leave' sheet; record start date, record end date, hours per week, job grade, continuous service and number of weeks.\", CONCATENATE(K21,K22,K23,K24,K25))","v":"You have indicated that you work 37 hours per week, which equates to 1.00 full-time equivalent (FTE).  Your basic leave, bank holiday and continuous service entitlements have been prorated based on this FTE and on the number of weeks, which is calculated from the record start and end dates you have entered.  The basic leave entitlement for grades 1-7 is 177.60 hours. This gives you 24.00 hours of basic leave.  You are entitled to 66.60 hours for bank holidays during this period.  Which prorated gives you 9.00 hours of bank holiday leave.  If you are due to work on a bank holiday this leave MUST be taken on those days.  This gives you a total entitlement for the 52 weeks from 01 Apr 2022 to the 31 Mar 2023 of 33.00 hours."}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"'Record of Leave'!I11","v":"Days"},{"$f":"IF(J28=\"Hours\", K26, J26)","v":"You have indicated that you work 37 hours per week, which equates to 1.00 full-time equivalent (FTE).  Your basic leave, bank holiday and continuous service entitlements have been prorated based on this FTE and on the number of weeks, which is calculated from the record start and end dates you have entered.  The basic leave entitlement for grades 1-7 is 24.00 days.   This gives you 24.00 days of basic leave.  You are entitled to 9.00 days for bank holidays during this period.  Which prorated gives you 9.00 days of bank holiday leave.  If you are due to work on a bank holiday this leave MUST be taken on those days.  This gives you a total entitlement for the 52 weeks from 01 Apr 2022 to the 31 Mar 2023 of 33.00 days."}]
[]
[]
[]
[]
[]
[]
[{"$f":"TODAY()","v":"2021-12-30"}]
[{"$f":"YEAR(A35-730)","v":2019}]
[{"$f":"YEAR(A35-365)","v":2020}]
[{"$f":"YEAR(A35)","v":2021}]
[{"$f":"YEAR(A35+365)","v":2022}]
[{"$f":"YEAR(A35+730)","v":2023}]
[]
[{"$f":"CONCATENATE(A36,\"/\",A37)","v":"2019/2020"}]
[{"$f":"CONCATENATE(A37,\"/\",A38)","v":"2020/2021"}]
[{"$f":"CONCATENATE(A38,\"/\",A39)","v":"2021/2022"}]
[{"$f":"CONCATENATE(A39,\"/\",A40)","v":"2022/2023"}]

{"sheet":"Input Variables","index":5,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[[7,1,7,3],[1,1,1,4],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[13,1,13,3],[19,1,19,3],[20,1,20,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3]]}
[]
[null,"INPUT VARABLES"]
[null,"FTE Hours:",null,null,37]
[null,"Lower grade band:",null,null,"1-7"]
[null,"Higher grade band:",null,null,"8-16"]
[null,"Lower grade band leave:",null,null,24]
[null,"Higher grade band leave:",null,null,27]
[null,"Continuous service days:",null,null,5]
[null,"Bank holiday 1:",null,null,"2022-04-15",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E9>='Record of Leave'!$D$9,E9<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 2:",null,null,"2022-04-18",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E10>='Record of Leave'!$D$9,E10<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 3:",null,null,"2022-05-02",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E11>='Record of Leave'!$D$9,E11<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 4:",null,null,"2022-06-02",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E12>='Record of Leave'!$D$9,E12<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 5:",null,null,"2022-08-29",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E13>='Record of Leave'!$D$9,E13<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 6:",null,null,"2022-12-27",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E14>='Record of Leave'!$D$9,E14<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 7:",null,null,"2022-12-26",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E15>='Record of Leave'!$D$9,E15<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 8:",null,null,"2023-01-02",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E16>='Record of Leave'!$D$9,E16<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 9:",null,null,"2022-06-03",{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E17>='Record of Leave'!$D$9,E17<='Record of Leave'!$D$10),1,0))","v":1}]
[null,"Bank holiday 10:",null,null,null,{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E18>='Record of Leave'!$D$9,E18<='Record of Leave'!$D$10),1,0))","v":0}]
[null,"Bank holiday 11:",null,null,null,{"$f":"IF(OR('Record of Leave'!$D$9=\"\",'Record of Leave'!$D$10=\"\"),\"\",IF(AND(E19>='Record of Leave'!$D$9,E19<='Record of Leave'!$D$10),1,0))","v":0}]
[null,"Designated leave 1:",null,null,null,{"$f":"SUM(F9:F19)","v":9}]
[null,"Designated leave 2:"]