{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guidance","calendar2023","Working Hours Calculator","2023 Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":12,"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":"Guidance","index":0,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":false,"merged":[[22,0,22,10],[20,0,20,10],[21,0,21,10],[0,0,0,10],[10,0,10,10],[1,0,1,10],[3,0,3,10],[7,0,7,10],[2,0,2,10],[4,0,4,10],[5,0,5,10],[8,0,8,10],[9,0,9,10],[6,0,6,10],[11,0,11,10],[13,0,13,10],[15,0,15,10],[16,0,16,10],[19,0,19,10],[14,0,14,10],[18,0,18,10],[17,0,17,10],[41,0,41,10],[34,0,34,10],[36,0,36,10],[39,0,39,10],[35,0,35,10],[40,0,40,10],[37,0,37,10],[38,0,38,10],[31,0,31,10],[29,0,29,10],[23,0,23,10],[33,0,33,10],[30,0,30,10],[32,0,32,10],[28,0,28,10],[27,0,27,10],[24,0,24,10],[25,0,25,10],[26,0,26,10]]}
[]
["RESOURCES:"]
[]
["The following resources can be accessed via the tabs below:"]
[]
["a)  2023 Template - Helps to plan the hours to be worked by an employee.  Will assist in ensuring that allocated hours equate to total hours to be worked during the leave year."]
[]
["b) Working Hours Calculator - Assists in calculating the total number of hours to be worked per year (excluding Annual Leave and Public Holiday)."]
[]
["The '2023 Template' and 'Working Hours Calculator' can be used to help plan an employees annualised hours working pattern.  The Annual Leave Calculator for the current year (found on Arcadia under HR Policies and Procedure/Resource Pack) will help when working out AL/PH entitlement to be set up in Bodet.  "]
[]
["GUIDANCE:"]
[]
["A copy of the spreadsheet should be taken for each employee/post."]
[]
["1. Input employee name and job title."]
[]
["2. Input contractual hours per annum (excluding annual leave and public holiday). If hours given include AL/PH  the Working Hours Calculator worksheet can be used to calculate the contractual hours per annum (excluding annual leave and public holiday). "]
[]
["3. Input the start and end dates for this year by clicking on the relevant cells (M8/M9) and using the dropdowns.  "]
["      (i) For an employee who is expected to work for the whole year these will be 01/01/2023 and 31/12/2023."]
["      (ii) For any days that are outside the start and end dates entered the cells automatically turn red."]
[]
["4. Ensure that all of the cells highlighted in red have a value of 0.00."]
[]
["5. Confirm whether the employee has greater than 5 years service by clicking on the relevant cell (M10) and using the dropdown to select \"Yes\" or \"No\"."]
[]
["6. Enter the average number of days worked per week. The standard is 5 if there is no predicted work pattern, but if a rota is being used then the total number of days to be worked divided by weeks this year that are expected to be worked (maximum 52.18) should be used. Please note this figure is fixed for the whole year."]
[]
["7. If there are hours bought forward from the previous year/spreadsheet input the total number of hours to be added.  "]
["The Annualised Hours Planner:"]
[]
["The planned number of hours to be worked each day is entered in the appropriate cells.  "]
[]
["The \"Weekly Total (Excl. AL/PH)\" column totals the hours to be worked during each week.  "]
[]
["The \"Hours Remaining (Excl. AL/PH)\" column shows the total hours remaining to be worked during this calendar year."]
["      (i) If, at the end of the calendar year, the figure in this column is negative then the hours that the employee has worked exceeded the total contracted hours by the number indicated.  These hours should be claimed as additional hours, however, if any of these hours exceed the annual overtime threshold (1931 hours pro rata) they should be claimed as overtime."]
["      (ii) If, at the end of the calendar year, the figure in this column is positive then the hours that the employee has worked is less than the total contracted hours by the number indicated.  These hours should be added to the following year's total. "]

{"sheet":"calendar2023","index":1,"n_rows":367,"n_cols":4,"rows_kept":367,"cut":false,"hidden":false,"merged":[]}
["Calendar for ",2023]
[null,"Date","Day","Number of days"]
[null,"2023-01-01","Sunday",1]
[null,"2023-01-02","Monday",2]
[null,"2023-01-03","Tuesday",3]
[null,"2023-01-04","Wednesday",4]
[null,"2023-01-05","Thursday",5]
[null,"2023-01-06","Friday",6]
[null,"2023-01-07","Saturday",7]
[null,"2023-01-08","Sunday",8]
[null,"2023-01-09","Monday",9]
[null,"2023-01-10","Tuesday",10]
[null,"2023-01-11","Wednesday",11]
[null,"2023-01-12","Thursday",12]
[null,"2023-01-13","Friday",13]
[null,"2023-01-14","Saturday",14]
[null,"2023-01-15","Sunday",15]
[null,"2023-01-16","Monday",16]
[null,"2023-01-17","Tuesday",17]
[null,"2023-01-18","Wednesday",18]
[null,"2023-01-19","Thursday",19]
[null,"2023-01-20","Friday",20]
[null,"2023-01-21","Saturday",21]
[null,"2023-01-22","Sunday",22]
[null,"2023-01-23","Monday",23]
[null,"2023-01-24","Tuesday",24]
[null,"2023-01-25","Wednesday",25]
[null,"2023-01-26","Thursday",26]
[null,"2023-01-27","Friday",27]
[null,"2023-01-28","Saturday",28]
[null,"2023-01-29","Sunday",29]
[null,"2023-01-30","Monday",30]
[null,"2023-01-31","Tuesday",31]
[null,"2023-02-01","Wednesday",32]
[null,"2023-02-02","Thursday",33]
[null,"2023-02-03","Friday",34]
[null,"2023-02-04","Saturday",35]
[null,"2023-02-05","Sunday",36]
[null,"2023-02-06","Monday",37]
[null,"2023-02-07","Tuesday",38]
[null,"2023-02-08","Wednesday",39]
[null,"2023-02-09","Thursday",40]
[null,"2023-02-10","Friday",41]
[null,"2023-02-11","Saturday",42]
[null,"2023-02-12","Sunday",43]
[null,"2023-02-13","Monday",44]
[null,"2023-02-14","Tuesday",45]
[null,"2023-02-15","Wednesday",46]
[null,"2023-02-16","Thursday",47]
[null,"2023-02-17","Friday",48]
[null,"2023-02-18","Saturday",49]
[null,"2023-02-19","Sunday",50]
[null,"2023-02-20","Monday",51]
[null,"2023-02-21","Tuesday",52]
[null,"2023-02-22","Wednesday",53]
[null,"2023-02-23","Thursday",54]
[null,"2023-02-24","Friday",55]
[null,"2023-02-25","Saturday",56]
[null,"2023-02-26","Sunday",57]
[null,"2023-02-27","Monday",58]
[null,"2023-02-28","Tuesday",59]
[null,"2023-03-01","Wednesday",60]
[null,"2023-03-02","Thursday",61]
[null,"2023-03-03","Friday",62]
[null,"2023-03-04","Saturday",63]
[null,"2023-03-05","Sunday",64]
[null,"2023-03-06","Monday",65]
[null,"2023-03-07","Tuesday",66]
[null,"2023-03-08","Wednesday",67]
[null,"2023-03-09","Thursday",68]
[null,"2023-03-10","Friday",69]
[null,"2023-03-11","Saturday",70]
[null,"2023-03-12","Sunday",71]
[null,"2023-03-13","Monday",72]
[null,"2023-03-14","Tuesday",73]
[null,"2023-03-15","Wednesday",74]
[null,"2023-03-16","Thursday",75]
[null,"2023-03-17","Friday",76]
[null,"2023-03-18","Saturday",77]
[null,"2023-03-19","Sunday",78]
[null,"2023-03-20","Monday",79]
[null,"2023-03-21","Tuesday",80]
[null,"2023-03-22","Wednesday",81]
[null,"2023-03-23","Thursday",82]
[null,"2023-03-24","Friday",83]
[null,"2023-03-25","Saturday",84]
[null,"2023-03-26","Sunday",85]
[null,"2023-03-27","Monday",86]
[null,"2023-03-28","Tuesday",87]
[null,"2023-03-29","Wednesday",88]
[null,"2023-03-30","Thursday",89]
[null,"2023-03-31","Friday",90]
[null,"2023-04-01","Saturday",91]
[null,"2023-04-02","Sunday",92]
[null,"2023-04-03","Monday",93]
[null,"2023-04-04","Tuesday",94]
[null,"2023-04-05","Wednesday",95]
[null,"2023-04-06","Thursday",96]
[null,"2023-04-07","Friday",97]
[null,"2023-04-08","Saturday",98]
[null,"2023-04-09","Sunday",99]
[null,"2023-04-10","Monday",100]
[null,"2023-04-11","Tuesday",101]
[null,"2023-04-12","Wednesday",102]
[null,"2023-04-13","Thursday",103]
[null,"2023-04-14","Friday",104]
[null,"2023-04-15","Saturday",105]
[null,"2023-04-16","Sunday",106]
[null,"2023-04-17","Monday",107]
[null,"2023-04-18","Tuesday",108]
[null,"2023-04-19","Wednesday",109]
[null,"2023-04-20","Thursday",110]
[null,"2023-04-21","Friday",111]
[null,"2023-04-22","Saturday",112]
[null,"2023-04-23","Sunday",113]
[null,"2023-04-24","Monday",114]
[null,"2023-04-25","Tuesday",115]
[null,"2023-04-26","Wednesday",116]
[null,"2023-04-27","Thursday",117]
[null,"2023-04-28","Friday",118]
[null,"2023-04-29","Saturday",119]
[null,"2023-04-30","Sunday",120]
[null,"2023-05-01","Monday",121]
[null,"2023-05-02","Tuesday",122]
[null,"2023-05-03","Wednesday",123]
[null,"2023-05-04","Thursday",124]
[null,"2023-05-05","Friday",125]
[null,"2023-05-06","Saturday",126]
[null,"2023-05-07","Sunday",127]
[null,"2023-05-08","Monday",128]
[null,"2023-05-09","Tuesday",129]
[null,"2023-05-10","Wednesday",130]
[null,"2023-05-11","Thursday",131]
[null,"2023-05-12","Friday",132]
[null,"2023-05-13","Saturday",133]
[null,"2023-05-14","Sunday",134]
[null,"2023-05-15","Monday",135]
[null,"2023-05-16","Tuesday",136]
[null,"2023-05-17","Wednesday",137]
[null,"2023-05-18","Thursday",138]
[null,"2023-05-19","Friday",139]
[null,"2023-05-20","Saturday",140]
[null,"2023-05-21","Sunday",141]
[null,"2023-05-22","Monday",142]
[null,"2023-05-23","Tuesday",143]
[null,"2023-05-24","Wednesday",144]
[null,"2023-05-25","Thursday",145]
[null,"2023-05-26","Friday",146]
[null,"2023-05-27","Saturday",147]
[null,"2023-05-28","Sunday",148]
[null,"2023-05-29","Monday",149]
[null,"2023-05-30","Tuesday",150]
[null,"2023-05-31","Wednesday",151]
[null,"2023-06-01","Thursday",152]
[null,"2023-06-02","Friday",153]
[null,"2023-06-03","Saturday",154]
[null,"2023-06-04","Sunday",155]
[null,"2023-06-05","Monday",156]
[null,"2023-06-06","Tuesday",157]
[null,"2023-06-07","Wednesday",158]
[null,"2023-06-08","Thursday",159]
[null,"2023-06-09","Friday",160]
[null,"2023-06-10","Saturday",161]
[null,"2023-06-11","Sunday",162]
[null,"2023-06-12","Monday",163]
[null,"2023-06-13","Tuesday",164]
[null,"2023-06-14","Wednesday",165]
[null,"2023-06-15","Thursday",166]
[null,"2023-06-16","Friday",167]
[null,"2023-06-17","Saturday",168]
[null,"2023-06-18","Sunday",169]
[null,"2023-06-19","Monday",170]
[null,"2023-06-20","Tuesday",171]
[null,"2023-06-21","Wednesday",172]
[null,"2023-06-22","Thursday",173]
[null,"2023-06-23","Friday",174]
[null,"2023-06-24","Saturday",175]
[null,"2023-06-25","Sunday",176]
[null,"2023-06-26","Monday",177]
[null,"2023-06-27","Tuesday",178]
[null,"2023-06-28","Wednesday",179]
[null,"2023-06-29","Thursday",180]
[null,"2023-06-30","Friday",181]
[null,"2023-07-01","Saturday",182]
[null,"2023-07-02","Sunday",183]
[null,"2023-07-03","Monday",184]
[null,"2023-07-04","Tuesday",185]
[null,"2023-07-05","Wednesday",186]
[null,"2023-07-06","Thursday",187]
[null,"2023-07-07","Friday",188]
[null,"2023-07-08","Saturday",189]
[null,"2023-07-09","Sunday",190]
[null,"2023-07-10","Monday",191]
[null,"2023-07-11","Tuesday",192]
[null,"2023-07-12","Wednesday",193]
[null,"2023-07-13","Thursday",194]
[null,"2023-07-14","Friday",195]
[null,"2023-07-15","Saturday",196]
[null,"2023-07-16","Sunday",197]
[null,"2023-07-17","Monday",198]
[null,"2023-07-18","Tuesday",199]
[null,"2023-07-19","Wednesday",200]
[null,"2023-07-20","Thursday",201]
[null,"2023-07-21","Friday",202]
[null,"2023-07-22","Saturday",203]
[null,"2023-07-23","Sunday",204]
[null,"2023-07-24","Monday",205]
[null,"2023-07-25","Tuesday",206]
[null,"2023-07-26","Wednesday",207]
[null,"2023-07-27","Thursday",208]
[null,"2023-07-28","Friday",209]
[null,"2023-07-29","Saturday",210]
[null,"2023-07-30","Sunday",211]
[null,"2023-07-31","Monday",212]
[null,"2023-08-01","Tuesday",213]
[null,"2023-08-02","Wednesday",214]
[null,"2023-08-03","Thursday",215]
[null,"2023-08-04","Friday",216]
[null,"2023-08-05","Saturday",217]
[null,"2023-08-06","Sunday",218]
[null,"2023-08-07","Monday",219]
[null,"2023-08-08","Tuesday",220]
[null,"2023-08-09","Wednesday",221]
[null,"2023-08-10","Thursday",222]
[null,"2023-08-11","Friday",223]
[null,"2023-08-12","Saturday",224]
[null,"2023-08-13","Sunday",225]
[null,"2023-08-14","Monday",226]
[null,"2023-08-15","Tuesday",227]
[null,"2023-08-16","Wednesday",228]
[null,"2023-08-17","Thursday",229]
[null,"2023-08-18","Friday",230]
[null,"2023-08-19","Saturday",231]
[null,"2023-08-20","Sunday",232]
[null,"2023-08-21","Monday",233]
[null,"2023-08-22","Tuesday",234]
[null,"2023-08-23","Wednesday",235]
[null,"2023-08-24","Thursday",236]
[null,"2023-08-25","Friday",237]
[null,"2023-08-26","Saturday",238]
[null,"2023-08-27","Sunday",239]
[null,"2023-08-28","Monday",240]
[null,"2023-08-29","Tuesday",241]
[null,"2023-08-30","Wednesday",242]
[null,"2023-08-31","Thursday",243]
[null,"2023-09-01","Friday",244]
[null,"2023-09-02","Saturday",245]
[null,"2023-09-03","Sunday",246]
[null,"2023-09-04","Monday",247]
[null,"2023-09-05","Tuesday",248]
[null,"2023-09-06","Wednesday",249]
[null,"2023-09-07","Thursday",250]
[null,"2023-09-08","Friday",251]
[null,"2023-09-09","Saturday",252]
[null,"2023-09-10","Sunday",253]
[null,"2023-09-11","Monday",254]
[null,"2023-09-12","Tuesday",255]
[null,"2023-09-13","Wednesday",256]
[null,"2023-09-14","Thursday",257]
[null,"2023-09-15","Friday",258]
[null,"2023-09-16","Saturday",259]
[null,"2023-09-17","Sunday",260]
[null,"2023-09-18","Monday",261]
[null,"2023-09-19","Tuesday",262]
[null,"2023-09-20","Wednesday",263]
[null,"2023-09-21","Thursday",264]
[null,"2023-09-22","Friday",265]
[null,"2023-09-23","Saturday",266]
[null,"2023-09-24","Sunday",267]
[null,"2023-09-25","Monday",268]
[null,"2023-09-26","Tuesday",269]
[null,"2023-09-27","Wednesday",270]
[null,"2023-09-28","Thursday",271]
[null,"2023-09-29","Friday",272]
[null,"2023-09-30","Saturday",273]
[null,"2023-10-01","Sunday",274]
[null,"2023-10-02","Monday",275]
[null,"2023-10-03","Tuesday",276]
[null,"2023-10-04","Wednesday",277]
[null,"2023-10-05","Thursday",278]
[null,"2023-10-06","Friday",279]
[null,"2023-10-07","Saturday",280]
[null,"2023-10-08","Sunday",281]
[null,"2023-10-09","Monday",282]
[null,"2023-10-10","Tuesday",283]
[null,"2023-10-11","Wednesday",284]
[null,"2023-10-12","Thursday",285]
[null,"2023-10-13","Friday",286]
[null,"2023-10-14","Saturday",287]
[null,"2023-10-15","Sunday",288]
[null,"2023-10-16","Monday",289]
[null,"2023-10-17","Tuesday",290]
[null,"2023-10-18","Wednesday",291]
[null,"2023-10-19","Thursday",292]
[null,"2023-10-20","Friday",293]
[null,"2023-10-21","Saturday",294]
[null,"2023-10-22","Sunday",295]
[null,"2023-10-23","Monday",296]
[null,"2023-10-24","Tuesday",297]
[null,"2023-10-25","Wednesday",298]
[null,"2023-10-26","Thursday",299]
[null,"2023-10-27","Friday",300]
[null,"2023-10-28","Saturday",301]
[null,"2023-10-29","Sunday",302]
[null,"2023-10-30","Monday",303]
[null,"2023-10-31","Tuesday",304]
[null,"2023-11-01","Wednesday",305]
[null,"2023-11-02","Thursday",306]
[null,"2023-11-03","Friday",307]
[null,"2023-11-04","Saturday",308]
[null,"2023-11-05","Sunday",309]
[null,"2023-11-06","Monday",310]
[null,"2023-11-07","Tuesday",311]
[null,"2023-11-08","Wednesday",312]
[null,"2023-11-09","Thursday",313]
[null,"2023-11-10","Friday",314]
[null,"2023-11-11","Saturday",315]
[null,"2023-11-12","Sunday",316]
[null,"2023-11-13","Monday",317]
[null,"2023-11-14","Tuesday",318]
[null,"2023-11-15","Wednesday",319]
[null,"2023-11-16","Thursday",320]
[null,"2023-11-17","Friday",321]
[null,"2023-11-18","Saturday",322]
[null,"2023-11-19","Sunday",323]
[null,"2023-11-20","Monday",324]
[null,"2023-11-21","Tuesday",325]
[null,"2023-11-22","Wednesday",326]
[null,"2023-11-23","Thursday",327]
[null,"2023-11-24","Friday",328]
[null,"2023-11-25","Saturday",329]
[null,"2023-11-26","Sunday",330]
[null,"2023-11-27","Monday",331]
[null,"2023-11-28","Tuesday",332]
[null,"2023-11-29","Wednesday",333]
[null,"2023-11-30","Thursday",334]
[null,"2023-12-01","Friday",335]
[null,"2023-12-02","Saturday",336]
[null,"2023-12-03","Sunday",337]
[null,"2023-12-04","Monday",338]
[null,"2023-12-05","Tuesday",339]
[null,"2023-12-06","Wednesday",340]
[null,"2023-12-07","Thursday",341]
[null,"2023-12-08","Friday",342]
[null,"2023-12-09","Saturday",343]
[null,"2023-12-10","Sunday",344]
[null,"2023-12-11","Monday",345]
[null,"2023-12-12","Tuesday",346]
[null,"2023-12-13","Wednesday",347]
[null,"2023-12-14","Thursday",348]
[null,"2023-12-15","Friday",349]
[null,"2023-12-16","Saturday",350]
[null,"2023-12-17","Sunday",351]
[null,"2023-12-18","Monday",352]
[null,"2023-12-19","Tuesday",353]
[null,"2023-12-20","Wednesday",354]
[null,"2023-12-21","Thursday",355]
[null,"2023-12-22","Friday",356]
[null,"2023-12-23","Saturday",357]
[null,"2023-12-24","Sunday",358]
[null,"2023-12-25","Monday",359]
[null,"2023-12-26","Tuesday",360]
[null,"2023-12-27","Wednesday",361]
[null,"2023-12-28","Thursday",362]
[null,"2023-12-29","Friday",363]
[null,"2023-12-30","Saturday",364]
[null,"2023-12-31","Sunday",365]

{"sheet":"Working Hours Calculator","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,0,7,6],[15,0,15,6]]}
[]
["Please use whichever calculator is relevant:"]
[]
["There are 260 potential working days in 2023 (all days minus weekends)"]
[]
[]
[]
["Hours Per Week "]
["Contracted Hours Per Week (Including AL/PH) for the whole year","Working Hours in 2023","Daily hours","Under 5 Years(35Xdaily hours)","Over 5 Years(40xdaily hours)","Total Hours Per Year (Excluding AL/PH) Under 5 Years Cont. Service","Total Hours Per Year (Excluding AL/PH) Over 5 Years Cont. Service","F*0.15494","G*0.18108","H+F","G+I"]
[18.25,{"$f":"C10*260","v":949},{"$f":"A10/5","v":3.65},{"$f":"35*C10","v":127.75},{"$f":"40*C10","v":146},{"$f":"B10-D10","v":821.25},{"$f":"B10-E10","v":803},{"$f":"F10*0.15494","v":127.24447499999999},{"$f":"G10*0.18108","v":145.40724},{"$f":"F10+H10","v":948.49447499999997},{"$f":"G10+I10","v":948.40724}]
[]
[]
[]
[]
[]
["Total Hours Per Year "]
["Hours for the whole year (Including AL/PH)","Daily Hours","Under 5 Years(35Xdaily hours)","Over 5 Years(39xdaily hours)",null,"Total Hours Per Year (Excluding AL/PH) Under 5 Years Cont. Service","Total Hours Per Year (Excluding AL/PH) Over 5 Years Cont. Service","F*0.15494","G*0.18108","H+F","G+I"]
[1885,{"$f":"A18/260","v":7.25},{"$f":"35*B18","v":253.75},{"$f":"40*B18","v":290},null,{"$f":"A18-C18","v":1631.25},{"$f":"A18-D18","v":1595},{"$f":"F18*0.15494","v":252.74587499999998},{"$f":"G18*0.18108","v":288.82259999999997},{"$f":"F18+H18","v":1883.9958750000001},{"$f":"G18+I18","v":1883.8226}]

{"sheet":"2023 Template","index":3,"n_rows":370,"n_cols":35,"rows_kept":370,"cut":false,"hidden":false,"merged":[[79,4,79,8],[80,4,80,8],[81,4,81,8],[12,4,12,8],[18,4,18,8],[13,4,13,8],[16,4,16,8],[14,4,14,8],[15,4,15,8],[22,1,22,14],[21,4,21,8],[19,4,19,8],[10,4,10,8],[2,4,2,8],[78,4,78,8],[0,1,0,11],[8,4,8,8],[9,4,9,8],[4,1,9,2],[20,4,20,8],[11,4,11,8],[4,4,4,8],[5,4,5,8],[7,4,7,8],[6,4,6,8],[1,4,1,8],[3,4,3,8],[17,4,17,8]]}
[null,"ANNUALISED HOURS PLANNER 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days",null,null,"Y/N","Date","Day","Number of days","Working Days","Count working days for these dates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,"Yes","2023-01-01","Sunday",1,0,{"$f":"IF($AC2>=$AI$2,IF($AC2<=$AI$3,AF2,0),0)","v":0},null,{"$f":"SList","v":"2023-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,"No","2023-01-02","Monday",2,1,{"$f":"IF($AC3>=$AI$2,IF($AC3<=$AI$3,AF3,0),0)","v":1},null,{"$f":"O9","v":"2023-12-31"}]
[null,null,null,null,"EMPLOYEE DETAILS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,"2023-01-03","Tuesday",3,1,1]
[null,"For guidance on using the spreadsheet, please click on the Guidance tab below.",null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,"2023-01-04","Wednesday",4,1,1]
[null,null,null,null,"Job Title",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,"2023-01-05","Thursday",5,1,1]
[null,null,null,null,"Contracted hours this year (excluding AL and PH)",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,6,null,null,null,"2023-01-06","Friday",6,1,1]
[null,null,null,null,"Start date",null,null,null,null,null,{"$f":"VALUE(SList)","v":44927},{"$f":"K8-1","v":44926},null,null,"2023-01-01",null,null,null,null,null,null,null,null,null,7,null,null,null,"2023-01-07","Saturday",7,0,0]
[null,null,null,null,"End date",null,null,null,null,null,{"$f":"VALUE(O9)","v":45291},{"$f":"K9+1","v":45292},null,null,"2023-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-08","Sunday",8,0,0]
[null,null,null,null,"Greater than  5 Years Service?",null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-09","Monday",9,1,1]
[null,null,null,null,"Average number of days worked per week",null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-10","Tuesday",10,1,1]
[null,null,null,null,"Hours taking start and end dates into account",null,null,null,null,{"$f":"O9-O8+ 1","v":365},{"$f":"IF(J12 >= 365,365,J12)","v":365},null,null,null,{"$f":"SUM(O7/260)*AG368","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-11","Wednesday",11,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-12","Thursday",12,1,1]
[null,null,null,null,"BROUGHT FORWARD HOURS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-13","Friday",13,1,1]
[null,null,null,null,"Outstanding hours B/F from previous sheet",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-14","Saturday",14,0,0]
[null,null,null,null,"Outstanding AL/PH hours from previous sheet",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-15","Sunday",15,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-16","Monday",16,1,1]
[null,null,null,null,"TOTALS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-17","Tuesday",17,1,1]
[null,null,null,null,"Total hours plus holiday entitlement (excluding B/F)",null,null,null,null,null,null,null,null,null,{"$f":"+O12+O80-O16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-18","Wednesday",18,1,1]
[null,null,null,null,"Average weekly hours ",null,null,null,null,null,{"$f":"O12/K79","v":0},null,null,null,{"$f":"ROUND(O19/AG370,4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-19","Thursday",19,1,1]
[null,null,null,null,"Average daily hours",null,null,null,null,null,{"$f":"K20/5","v":0},null,null,null,{"$f":"ROUND(O20/O11,6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-20","Friday",20,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-21","Saturday",21,0,0]
[null,"ANNUALISED HOURS PLANNER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-22","Sunday",22,0,0]
[null,"Week Start Date","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Sickness","Holiday","Special Leave","AL/PH Hours (Not Daily Average)","Weekly Total (Excl. AL/PH)","Hours Remaining (Excl. AL/PH)",null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-23","Monday",23,1,1]
[{"$f":"VALUE(B25)","v":44921},"2022-12-26",0,0,0,0,0,0,0,{"$f":"IF(M25=0,COUNTIF(C25:I25,\"LSA\"),0)","v":0},{"$f":"IF(M25=0,COUNTIF(C25:I25,\"LHE\"),0)","v":0},{"$f":"COUNTIF(C25:I25,\"LSL\")","v":0},0,0,{"$f":"O12+O15-N25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-24","Tuesday",24,1,1]
[{"$f":"VALUE(B26)","v":44928},{"$f":"B25+7","v":"2023-01-02"},0,0,0,0,0,0,0,{"$f":"COUNTIF(C26:I26,\"LSA\")","v":0},{"$f":"IF(M26=0,COUNTIF(C26:I26,\"LHE\"),0)","v":0},{"$f":"COUNTIF(C26:I26,\"LSL\")","v":0},0,{"$f":"SUM(C26:I26)+(J26*$O$21)+(L26*$O$21)","v":0},{"$f":"O25-N26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-25","Wednesday",25,1,1]
[44935,"2023-01-09",0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C27:I27)+(J27*$O$21)+(L27*$O$21)","v":0},{"$f":"O26-N27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-26","Thursday",26,1,1]
[44942,"2023-01-16",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-27","Friday",27,1,1]
[44949,"2023-01-23",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-28","Saturday",28,0,0]
[44956,"2023-01-30",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-29","Sunday",29,0,0]
[44963,"2023-02-06",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-30","Monday",30,1,1]
[44970,"2023-02-13",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-31","Tuesday",31,1,1]
[44977,"2023-02-20",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01","Wednesday",32,1,1]
[44984,"2023-02-27",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-02","Thursday",33,1,1]
[44991,"2023-03-06",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-03","Friday",34,1,1]
[44998,"2023-03-13",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-04","Saturday",35,0,0]
[45005,"2023-03-20",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-05","Sunday",36,0,0]
[45012,"2023-03-27",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-06","Monday",37,1,1]
[45019,"2023-04-03",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-07","Tuesday",38,1,1]
[45026,"2023-04-10",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-08","Wednesday",39,1,1]
[45033,"2023-04-17",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-09","Thursday",40,1,1]
[45040,"2023-04-24",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-10","Friday",41,1,1]
[45047,"2023-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-11","Saturday",42,0,0]
[45054,"2023-05-08",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-12","Sunday",43,0,0]
[45061,"2023-05-15",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-13","Monday",44,1,1]
[45068,"2023-05-22",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-14","Tuesday",45,1,1]
[45075,"2023-05-29",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-15","Wednesday",46,1,1]
[45082,"2023-06-05",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-16","Thursday",47,1,1]
[45089,"2023-06-12",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-17","Friday",48,1,1]
[45096,"2023-06-19",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-18","Saturday",49,0,0]
[45103,"2023-06-26",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-19","Sunday",50,0,0]
[45110,"2023-07-03",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-20","Monday",51,1,1]
[45117,"2023-07-10",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-21","Tuesday",52,1,1]
[45124,"2023-07-17",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-22","Wednesday",53,1,1]
[45131,"2023-07-24",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-23","Thursday",54,1,1]
[45138,"2023-07-31",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-24","Friday",55,1,1]
[45145,"2023-08-07",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-25","Saturday",56,0,0]
[45152,{"$f":"B57+7","v":"2023-08-14"},0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-26","Sunday",57,0,0]
[45159,"2023-08-21",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-27","Monday",58,1,1]
[45166,"2023-08-28",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-28","Tuesday",59,1,1]
[45173,"2023-09-04",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01","Wednesday",60,1,1]
[45180,"2023-09-11",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-02","Thursday",61,1,1]
[45187,"2023-09-18",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-03","Friday",62,1,1]
[45194,"2023-09-25",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-04","Saturday",63,0,0]
[45201,"2023-10-02",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-05","Sunday",64,0,0]
[45208,"2023-10-09",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-06","Monday",65,1,1]
[45215,"2023-10-16",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-07","Tuesday",66,1,{"$f":"IF($AC67>=$AI$2,IF($AC67<=$AI$3,AF67,0),0)","v":1}]
[45222,"2023-10-23",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-08","Wednesday",67,1,1]
[45229,"2023-10-30",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-09","Thursday",68,1,1]
[45236,"2023-11-06",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-10","Friday",69,1,1]
[45243,"2023-11-13",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-11","Saturday",70,0,0]
[45250,"2023-11-20",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-12","Sunday",71,0,0]
[45257,"2023-11-27",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-13","Monday",72,1,1]
[45264,"2023-12-04",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-14","Tuesday",73,1,1]
[45271,"2023-12-11",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-15","Wednesday",74,1,1]
[45278,"2023-12-18",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-16","Thursday",75,1,1]
[45285,"2023-12-25",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-17","Friday",76,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-18","Saturday",77,0,0]
[null,null,null,null,"ANNUAL LEAVE AND PUBLIC HOLIDAY (AL/PH):",null,null,null,null,{"$f":"J12/7","v":52.142857142857146},{"$f":"K12/7","v":52.142857142857146},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-19","Sunday",78,0,0]
[null,null,null,null,"Annual leave and public holiday entitlement (Inc. B/F) ",null,null,null,null,null,null,null,null,null,{"$f":"IF($O$10= \"Yes\",$O$12*0.181818182,$O$12*0.155555556)+O16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-20","Monday",79,1,1]
[null,null,null,null,"Annual leave and public holiday taken",null,null,null,null,{"$f":"SUM($K$25:$K$77)","v":0},{"$f":"SUM($M$25:$M$77)","v":0},null,null,null,{"$f":"J81*$O$21+K81","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-21","Tuesday",80,1,1]
[null,null,null,null,"Annual leave and public holiday remaining",null,null,null,null,null,null,null,null,null,{"$f":"O80-O81","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-22","Wednesday",81,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-23","Thursday",82,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-24","Friday",83,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-25","Saturday",84,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-26","Sunday",85,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-27","Monday",86,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-28","Tuesday",87,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-29","Wednesday",88,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-30","Thursday",89,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-31","Friday",90,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01","Saturday",91,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-02","Sunday",92,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-03","Monday",93,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-04","Tuesday",94,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-05","Wednesday",95,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-06","Thursday",96,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-07","Friday",97,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-08","Saturday",98,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-09","Sunday",99,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-10","Monday",100,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-11","Tuesday",101,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-12","Wednesday",102,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-13","Thursday",103,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-14","Friday",104,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-15","Saturday",105,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-16","Sunday",106,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-17","Monday",107,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-18","Tuesday",108,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-19","Wednesday",109,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-20","Thursday",110,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-21","Friday",111,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-22","Saturday",112,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-23","Sunday",113,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-24","Monday",114,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-25","Tuesday",115,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-26","Wednesday",116,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-27","Thursday",117,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-28","Friday",118,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-29","Saturday",119,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-30","Sunday",120,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01","Monday",121,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-02","Tuesday",122,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-03","Wednesday",123,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-04","Thursday",124,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-05","Friday",125,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-06","Saturday",126,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-07","Sunday",127,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-08","Monday",128,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-09","Tuesday",129,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-10","Wednesday",130,1,{"$f":"IF($AC131>=$AI$2,IF($AC131<=$AI$3,AF131,0),0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-11","Thursday",131,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-12","Friday",132,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-13","Saturday",133,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-14","Sunday",134,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-15","Monday",135,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-16","Tuesday",136,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-17","Wednesday",137,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-18","Thursday",138,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-19","Friday",139,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-20","Saturday",140,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-21","Sunday",141,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-22","Monday",142,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-23","Tuesday",143,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-24","Wednesday",144,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-25","Thursday",145,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-26","Friday",146,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-27","Saturday",147,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-28","Sunday",148,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-29","Monday",149,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-30","Tuesday",150,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-31","Wednesday",151,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01","Thursday",152,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-02","Friday",153,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-03","Saturday",154,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-04","Sunday",155,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-05","Monday",156,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-06","Tuesday",157,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-07","Wednesday",158,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-08","Thursday",159,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-09","Friday",160,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-10","Saturday",161,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-11","Sunday",162,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-12","Monday",163,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-13","Tuesday",164,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-14","Wednesday",165,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-15","Thursday",166,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-16","Friday",167,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-17","Saturday",168,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-18","Sunday",169,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-19","Monday",170,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-20","Tuesday",171,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-21","Wednesday",172,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-22","Thursday",173,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-23","Friday",174,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-24","Saturday",175,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-25","Sunday",176,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-26","Monday",177,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-27","Tuesday",178,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-28","Wednesday",179,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-29","Thursday",180,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-30","Friday",181,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01","Saturday",182,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-02","Sunday",183,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-03","Monday",184,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-04","Tuesday",185,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-05","Wednesday",186,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-06","Thursday",187,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-07","Friday",188,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-08","Saturday",189,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-09","Sunday",190,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-10","Monday",191,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-11","Tuesday",192,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-12","Wednesday",193,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-13","Thursday",194,1,{"$f":"IF($AC195>=$AI$2,IF($AC195<=$AI$3,AF195,0),0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-14","Friday",195,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-15","Saturday",196,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-16","Sunday",197,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-17","Monday",198,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-18","Tuesday",199,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-19","Wednesday",200,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-20","Thursday",201,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-21","Friday",202,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-22","Saturday",203,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-23","Sunday",204,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-24","Monday",205,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-25","Tuesday",206,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-26","Wednesday",207,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-27","Thursday",208,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-28","Friday",209,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-29","Saturday",210,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-30","Sunday",211,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-31","Monday",212,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01","Tuesday",213,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-02","Wednesday",214,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-03","Thursday",215,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-04","Friday",216,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-05","Saturday",217,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-06","Sunday",218,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-07","Monday",219,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-08","Tuesday",220,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-09","Wednesday",221,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-10","Thursday",222,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-11","Friday",223,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-12","Saturday",224,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-13","Sunday",225,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-14","Monday",226,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-15","Tuesday",227,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-16","Wednesday",228,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-17","Thursday",229,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-18","Friday",230,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-19","Saturday",231,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-20","Sunday",232,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-21","Monday",233,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-22","Tuesday",234,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-23","Wednesday",235,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-24","Thursday",236,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-25","Friday",237,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-26","Saturday",238,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-27","Sunday",239,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-28","Monday",240,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-29","Tuesday",241,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-30","Wednesday",242,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-31","Thursday",243,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01","Friday",244,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-02","Saturday",245,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-03","Sunday",246,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-04","Monday",247,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-05","Tuesday",248,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-06","Wednesday",249,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-07","Thursday",250,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-08","Friday",251,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-09","Saturday",252,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-10","Sunday",253,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-11","Monday",254,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-12","Tuesday",255,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-13","Wednesday",256,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-14","Thursday",257,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-15","Friday",258,1,{"$f":"IF($AC259>=$AI$2,IF($AC259<=$AI$3,AF259,0),0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-16","Saturday",259,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-17","Sunday",260,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-18","Monday",261,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-19","Tuesday",262,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-20","Wednesday",263,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-21","Thursday",264,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-22","Friday",265,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-23","Saturday",266,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-24","Sunday",267,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-25","Monday",268,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-26","Tuesday",269,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-27","Wednesday",270,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-28","Thursday",271,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-29","Friday",272,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-30","Saturday",273,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01","Sunday",274,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-02","Monday",275,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-03","Tuesday",276,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-04","Wednesday",277,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-05","Thursday",278,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-06","Friday",279,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-07","Saturday",280,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-08","Sunday",281,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-09","Monday",282,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-10","Tuesday",283,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-11","Wednesday",284,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-12","Thursday",285,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-13","Friday",286,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-14","Saturday",287,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-15","Sunday",288,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-16","Monday",289,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-17","Tuesday",290,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-18","Wednesday",291,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-19","Thursday",292,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-20","Friday",293,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-21","Saturday",294,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-22","Sunday",295,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-23","Monday",296,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-24","Tuesday",297,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-25","Wednesday",298,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-26","Thursday",299,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-27","Friday",300,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-28","Saturday",301,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-29","Sunday",302,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-30","Monday",303,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-31","Tuesday",304,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-01","Wednesday",305,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-02","Thursday",306,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-03","Friday",307,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-04","Saturday",308,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-05","Sunday",309,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-06","Monday",310,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-07","Tuesday",311,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-08","Wednesday",312,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-09","Thursday",313,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-10","Friday",314,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-11","Saturday",315,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-12","Sunday",316,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-13","Monday",317,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-14","Tuesday",318,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-15","Wednesday",319,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-16","Thursday",320,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-17","Friday",321,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-18","Saturday",322,0,{"$f":"IF($AC323>=$AI$2,IF($AC323<=$AI$3,AF323,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-19","Sunday",323,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-20","Monday",324,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-21","Tuesday",325,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-22","Wednesday",326,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-23","Thursday",327,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-24","Friday",328,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-25","Saturday",329,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-26","Sunday",330,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-27","Monday",331,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-28","Tuesday",332,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-29","Wednesday",333,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-30","Thursday",334,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-01","Friday",335,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-02","Saturday",336,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-03","Sunday",337,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-04","Monday",338,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-05","Tuesday",339,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-06","Wednesday",340,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-07","Thursday",341,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-08","Friday",342,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-09","Saturday",343,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-10","Sunday",344,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-11","Monday",345,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-12","Tuesday",346,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-13","Wednesday",347,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-14","Thursday",348,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-15","Friday",349,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-16","Saturday",350,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-17","Sunday",351,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-18","Monday",352,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-19","Tuesday",353,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-20","Wednesday",354,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-21","Thursday",355,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-22","Friday",356,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-23","Saturday",357,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-24","Sunday",358,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-25","Monday",359,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-26","Tuesday",360,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-27","Wednesday",361,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-28","Thursday",362,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-29","Friday",363,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-30","Saturday",364,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-31","Sunday",365,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AF2:AF367)","v":260},{"$f":"SUM(AG2:AG367)","v":260}]
[]
[null,null,null,null,null,null,null,null,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":"AG368/5","v":52}]