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

{"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/2018:"]
[]
[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},335,{"$f":"(E7/365.26)*G7","v":226.07906535139358},{"$f":"(F7/365.26)*G7","v":259.3257783274243}]
[null,18.125,822.51300000000003,804.38800000000003,{"$f":"C8*0.149846","v":123.25028299800002},{"$f":"D8*0.175755","v":141.37521294000001},335,{"$f":"(E8/365.26)*G8","v":113.03960139169361},{"$f":"(F8/365.26)*G8","v":129.66296976099218}]
[]
[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,0,0,0,{"$f":"C15*0.149846","v":0},{"$f":"D15*0.175755","v":0},0,{"$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":"2020 Template","index":4,"n_rows":367,"n_cols":29,"rows_kept":367,"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 2020",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","2020-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","2020-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,"2020-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,"2020-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,"2020-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,"2020-01-06"]
[null,null,null,null,"Start date",null,null,null,null,null,{"$f":"VALUE(SList)","v":43831},{"$f":"K8-1","v":43830},null,null,"2020-01-01",null,null,null,null,null,null,null,null,null,7,null,null,null,"2020-01-07"]
[null,null,null,null,"End date",null,null,null,null,null,{"$f":"VALUE(O9)","v":44196},{"$f":"K9+1","v":44197},null,null,"2020-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-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,"2020-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,"2020-01-10"]
[null,null,null,null,"Hours taking start and end dates into account",null,null,null,null,{"$f":"O9-O8+ 1","v":366},{"$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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-01-23"]
[{"$f":"VALUE(B25)","v":43829},"2019-12-30",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,"2020-01-24"]
[{"$f":"VALUE(B26)","v":43836},{"$f":"B25+7","v":"2020-01-06"},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,"2020-01-25"]
[43843,"2020-01-13",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,"2020-01-26"]
[43850,"2020-01-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,"2020-01-27"]
[43857,"2020-01-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,"2020-01-28"]
[43864,"2020-02-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,"2020-01-29"]
[43871,"2020-02-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,"2020-01-30"]
[43878,"2020-02-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,"2020-01-31"]
[43885,"2020-02-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,"2020-02-01"]
[43892,"2020-03-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,"2020-02-02"]
[43899,"2020-03-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,"2020-02-03"]
[43906,"2020-03-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,"2020-02-04"]
[43913,"2020-03-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,"2020-02-05"]
[43920,"2020-03-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,"2020-02-06"]
[43927,"2020-04-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,"2020-02-07"]
[43934,"2020-04-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,"2020-02-08"]
[43941,"2020-04-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,"2020-02-09"]
[43948,"2020-04-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,"2020-02-10"]
[43955,"2020-05-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,"2020-02-11"]
[43962,"2020-05-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,"2020-02-12"]
[43969,"2020-05-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,"2020-02-13"]
[43976,"2020-05-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,"2020-02-14"]
[43983,"2020-06-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,"2020-02-15"]
[43990,"2020-06-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,"2020-02-16"]
[43997,"2020-06-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,"2020-02-17"]
[44004,"2020-06-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,"2020-02-18"]
[44011,"2020-06-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,"2020-02-19"]
[44018,"2020-07-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,"2020-02-20"]
[44025,"2020-07-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,"2020-02-21"]
[44032,"2020-07-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,"2020-02-22"]
[44039,"2020-07-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,"2020-02-23"]
[44046,"2020-08-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,"2020-02-24"]
[44053,"2020-08-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,"2020-02-25"]
[44060,{"$f":"B57+7","v":"2020-08-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,"2020-02-26"]
[44067,"2020-08-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,"2020-02-27"]
[44074,"2020-08-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,"2020-02-28"]
[44081,"2020-09-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,"2020-02-29"]
[44088,"2020-09-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,"2020-03-01"]
[44095,"2020-09-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,"2020-03-02"]
[44102,"2020-09-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,"2020-03-03"]
[44109,"2020-10-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,"2020-03-04"]
[44116,"2020-10-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,"2020-03-05"]
[44123,"2020-10-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,"2020-03-06"]
[44130,"2020-10-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,"2020-03-07"]
[44137,"2020-11-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,"2020-03-08"]
[44144,"2020-11-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,"2020-03-09"]
[44151,"2020-11-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,"2020-03-10"]
[44158,"2020-11-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,"2020-03-11"]
[44165,"2020-11-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,"2020-03-12"]
[44172,"2020-12-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,"2020-03-13"]
[44179,"2020-12-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,"2020-03-14"]
[44186,"2020-12-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,"2020-03-15"]
[44193,"2020-12-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,"2020-03-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,"2020-03-17"]
[null,null,null,null,"ANNUAL LEAVE AND PUBLIC HOLIDAY (AL/PH):",null,null,null,null,{"$f":"J12/7","v":52.285714285714285},{"$f":"K12/7","v":52.18},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-18"]
[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,"2020-03-19"]
[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,"2020-03-20"]
[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,"2020-03-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-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,"2020-12-31"]