{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Guidance","calendar2021","Annual Leave Calculator","Working Hours Calculator","2021 Template"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"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":"Guidance","index":0,"n_rows":100,"n_cols":1,"rows_kept":100,"cut":false,"hidden":false,"merged":[[72,0,72,10],[45,0,45,10],[56,0,56,10],[50,0,50,10],[48,0,48,10],[52,0,52,10],[49,0,49,10],[38,0,38,10],[60,0,60,10],[51,0,51,10],[57,0,57,10],[101,0,101,10],[62,0,62,10],[59,0,59,10],[53,0,53,10],[55,0,55,10],[58,0,58,10],[64,0,64,10],[70,0,70,10],[54,0,54,10],[63,0,63,10],[66,0,66,10],[67,0,67,10],[28,2,28,10],[23,2,23,10],[47,0,47,10],[46,0,46,10],[43,0,43,10],[26,2,26,10],[35,0,35,10],[41,0,41,10],[42,0,42,10],[39,0,39,10],[32,0,32,10],[33,0,33,10],[37,0,37,10],[36,0,36,10],[40,0,40,10],[44,0,44,10],[82,0,82,10],[0,0,0,10],[12,0,12,10],[31,0,31,10],[1,0,1,10],[3,0,3,10],[7,0,7,10],[25,2,25,10],[27,2,27,10],[9,0,9,10],[24,2,24,10],[17,0,17,10],[19,0,19,10],[30,2,30,10],[22,2,22,10],[29,2,29,10],[2,0,2,10],[18,0,18,10],[4,0,4,10],[13,0,13,10],[14,0,14,10],[16,0,16,10],[5,0,5,10],[6,0,6,10],[10,0,10,10],[8,0,8,10],[11,0,11,10],[15,0,15,10],[73,0,73,10],[75,0,75,10],[76,0,76,10],[88,0,88,10],[20,2,20,10],[21,2,21,10],[34,0,34,10],[65,0,65,10],[71,0,71,10],[61,0,61,10],[80,0,80,10],[81,0,81,10],[77,0,77,10],[78,0,78,10],[79,0,79,10],[68,0,68,10],[98,0,98,10],[99,0,99,10],[90,0,90,10],[74,0,74,10],[100,0,100,10],[92,0,92,10],[93,0,93,10],[94,0,94,10],[95,0,95,10],[96,0,96,10],[97,0,97,10],[91,0,91,10],[86,0,86,10],[84,0,84,10],[85,0,85,10],[83,0,83,10]]}
[]
["RESOURCES:"]
[]
["The following resources can be accessed via the tabs below:"]
[]
["a)  2021 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)."]
[]
["c) Annual Leave Calculator - Assists in calculating the entitlement to annual leave and public holiday."]
[]
["The '2021 Template' and 'Working Hours Calculator' can be used to help plan an employees annualised hours working pattern.  The Annual Leave Calculator will help when working out AL/PH entitlement to be set up in Bodet.  The guidance below outlines the steps required in order to make use of these resources."]
[]
["GUIDANCE:"]
[]
["Copying and saving the spreadsheet:"]
[]
["Copy the 2021 template into another workbook by clicking on the \"2021 Template\" tab at the bottom of the spreadsheet.   Right mouse so that the following box appears:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Employee Details:"]
[]
["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/2021 and 31/12/2021."]
["      (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. "]
[]
["Completing an EMIS Employee Form when an employee starts in post:"]
[]
["Section C:"]
["Fixed hours per week is the average hours per week, which must be to 3 decimal places."]
[]
["Section F:"]
["Should state that the employee is working annualised hours and give the total number of hours to be worked in a full year including AL/PH, which must be to 3 decimal places."]
[]
["EMIS Form - Example:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The Annual Leave Calculator:"]
[]
["1. If there is a set pattern of work enter the hours of work."]
[]
["2. Enter the hours excluding AL/PH for both under and over 5 years service."]
[]
["4. Enter the number of calendar days that the employee will be on annualised hours in this year, the calendar2021 tab can be used to find this."]
[]
["5. The total number of hours of entitlement to AL/PH for the whole year will be shown in columns D and E and the totals for the part year will be shown in columns G and H."]

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

{"sheet":"Annual Leave Calculator","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,6,4,8],[2,1,2,7],[11,1,11,3],[11,4,11,5],[11,6,11,8],[4,4,4,5],[4,1,4,3],[9,1,9,3]]}
[]
[]
[null,"EXAMPLE FOR EMPLOYEES ON ANNUALISED HOURS STARTING 01/02/2021:"]
[]
[null,"BASIC DETAILS",null,null,"WHOLE YEAR",null,"PART YEAR"]
[null,"Hours per week","Hours excluding AL/PH (under  5 years service)","Hours excluding AL/PH (over  5 years service)","Total AL/PH (under 5 years service)","Total AL/PH (over 5 years service)","Calendar Days worked this year","Total AL/PH Feb-Dec (under 5 years service)","Total AL/PH Feb-Dec(over 5 years service)"]
[null,36.25,1645.0250000000001,1608.7750000000001,{"$f":"C7*0.149846","v":246.50041615000004},{"$f":"D7*0.175755","v":282.75025012499998},334,{"$f":"(E7/365.26)*G7","v":225.40420246974762},{"$f":"(F7/365.26)*G7","v":258.55167152644691}]
[null,18.125,822.51300000000003,804.38800000000003,{"$f":"C8*0.149846","v":123.25028299800002},{"$f":"D8*0.175755","v":141.37521294000001},334,{"$f":"(E8/365.26)*G8","v":112.70216974574826},{"$f":"(F8/365.26)*G8","v":129.2759161199146}]
[]
[null,"CALCULATOR:"]
[]
[null,"BASIC DETAILS",null,null,"WHOLE YEAR",null,"PART YEAR"]
[null,"Hours per week","Hours excluding AL/PH (under  5 years service)","Hours excluding AL/PH (over  5 years service)","Total AL/PH (under 5 years service)","Total AL/PH (over 5 years service)","Calendar Days worked this year","Total AL/PH Feb-Dec (under 5 years service)","Total AL/PH Feb-Dec(over 5 years service)"]
[null,null,null,null,{"$f":"C14*0.149846","v":0},{"$f":"D14*0.175755","v":0},null,{"$f":"(E14/365.26)*G14","v":0},{"$f":"(F14/365.26)*G14","v":0}]
[null,null,null,null,{"$f":"C15*0.149846","v":0},{"$f":"D15*0.175755","v":0},null,{"$f":"(E15/365.26)*G15","v":0},{"$f":"(F15/365.26)*G15","v":0}]

{"sheet":"Working Hours Calculator","index":3,"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:"]
[]
[]
[]
[]
[]
["Hours Per Week "]
["Contracted Hours Per Week (Including AL/PH) for the whole year","Hours X 52.18","Daily hours","Under 5 Years(34Xdaily hours)","Over 5 Years(39xdaily 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"]
[36.25,{"$f":"A10*52.18","v":1891.5250000000001},{"$f":"A10/5","v":7.25},{"$f":"34*C10","v":246.5},{"$f":"39*C10","v":282.75},{"$f":"B10-D10","v":1645.0250000000001},{"$f":"B10-E10","v":1608.7750000000001},{"$f":"F10*0.15494","v":254.88017350000001},{"$f":"G10*0.18108","v":291.31697700000001},{"$f":"F10+H10","v":1899.9051735},{"$f":"G10+I10","v":1900.091977}]
[]
[]
[]
[]
[]
["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"]
[1891.5250000000001,{"$f":"A18/52.18/5","v":7.25},{"$f":"34*B18","v":246.5},{"$f":"39*B18","v":282.75},null,{"$f":"A18-C18","v":1645.0250000000001},{"$f":"A18-D18","v":1608.7750000000001},{"$f":"F18*0.15494","v":254.88017350000001},{"$f":"G18*0.18108","v":291.31697700000001},{"$f":"F18+H18","v":1899.9051735},{"$f":"G18+I18","v":1900.091977}]

{"sheet":"2021 Template","index":4,"n_rows":366,"n_cols":29,"rows_kept":366,"cut":false,"hidden":false,"merged":[[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],[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]]}
[null,"ANNUALISED HOURS PLANNER 2021",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"]
[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","2021-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","2021-01-02"]
[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,"2021-01-03"]
[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,"2021-01-04"]
[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,"2021-01-05"]
[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,"2021-01-06"]
[null,null,null,null,"Start date",null,null,null,null,null,{"$f":"VALUE(SList)","v":44197},{"$f":"K8-1","v":44196},null,null,"2021-01-01",null,null,null,null,null,null,null,null,null,7,null,null,null,"2021-01-07"]
[null,null,null,null,"End date",null,null,null,null,null,{"$f":"VALUE(O9)","v":44561},{"$f":"K9+1","v":44562},null,null,"2021-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-08"]
[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,"2021-01-09"]
[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,"2021-01-10"]
[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.26,J12)","v":365.26},null,null,null,{"$f":"SUM(O7/365.26)*K12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-12"]
[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,"2021-01-13"]
[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,"2021-01-14"]
[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,"2021-01-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-16"]
[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,"2021-01-17"]
[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,"2021-01-18"]
[null,null,null,null,"Average weekly hours ",null,null,null,null,null,{"$f":"O12/K79","v":0},null,null,null,{"$f":"ROUND(O19/K79,4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-19"]
[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,"2021-01-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-21"]
[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,"2021-01-22"]
[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,"2021-01-23"]
[{"$f":"VALUE(B25)","v":44193},"2020-12-28",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,"2021-01-24"]
[{"$f":"VALUE(B26)","v":44200},{"$f":"B25+7","v":"2021-01-04"},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,"2021-01-25"]
[44207,"2021-01-11",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,"2021-01-26"]
[44214,"2021-01-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,"2021-01-27"]
[44221,"2021-01-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,"2021-01-28"]
[44228,"2021-02-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,"2021-01-29"]
[44235,"2021-02-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,"2021-01-30"]
[44242,"2021-02-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,"2021-01-31"]
[44249,"2021-02-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,"2021-02-01"]
[44256,"2021-03-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,"2021-02-02"]
[44263,"2021-03-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,"2021-02-03"]
[44270,"2021-03-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,"2021-02-04"]
[44277,"2021-03-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,"2021-02-05"]
[44284,"2021-03-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,"2021-02-06"]
[44291,"2021-04-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,"2021-02-07"]
[44298,"2021-04-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,"2021-02-08"]
[44305,"2021-04-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,"2021-02-09"]
[44312,"2021-04-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,"2021-02-10"]
[44319,"2021-05-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,"2021-02-11"]
[44326,"2021-05-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,"2021-02-12"]
[44333,"2021-05-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,"2021-02-13"]
[44340,"2021-05-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,"2021-02-14"]
[44347,"2021-05-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,"2021-02-15"]
[44354,"2021-06-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,"2021-02-16"]
[44361,"2021-06-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,"2021-02-17"]
[44368,"2021-06-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,"2021-02-18"]
[44375,"2021-06-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,"2021-02-19"]
[44382,"2021-07-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,"2021-02-20"]
[44389,"2021-07-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,"2021-02-21"]
[44396,"2021-07-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,"2021-02-22"]
[44403,"2021-07-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,"2021-02-23"]
[44410,"2021-08-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,"2021-02-24"]
[44417,"2021-08-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,"2021-02-25"]
[44424,{"$f":"B57+7","v":"2021-08-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,"2021-02-26"]
[44431,"2021-08-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,"2021-02-27"]
[44438,"2021-08-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,"2021-02-28"]
[44445,"2021-09-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,"2021-03-01"]
[44452,"2021-09-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,"2021-03-02"]
[44459,"2021-09-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,"2021-03-03"]
[44466,"2021-09-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,"2021-03-04"]
[44473,"2021-10-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,"2021-03-05"]
[44480,"2021-10-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,"2021-03-06"]
[44487,"2021-10-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,"2021-03-07"]
[44494,"2021-10-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,"2021-03-08"]
[44501,"2021-11-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,"2021-03-09"]
[44508,"2021-11-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,"2021-03-10"]
[44515,"2021-11-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,"2021-03-11"]
[44522,"2021-11-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,"2021-03-12"]
[44529,"2021-11-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,"2021-03-13"]
[44536,"2021-12-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,"2021-03-14"]
[44543,"2021-12-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,"2021-03-15"]
[44550,"2021-12-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,"2021-03-16"]
[44557,"2021-12-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,"2021-03-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-18"]
[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.18},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-19"]
[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.175755,$O$12*0.149846)+O16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-20"]
[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,"2021-03-21"]
[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,"2021-03-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-09-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-31"]