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

{"sheet":"Annual Leave Calculator","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,5,4,7],[2,0,2,6],[11,0,11,2],[11,3,11,4],[11,5,11,7],[4,3,4,4],[4,0,4,2],[9,0,9,2]]}
[]
[]
["EXAMPLE FOR EMPLOYEES ON ANNUALISED HOURS STARTING 01/02/2018:"]
[]
["BASIC DETAILS",null,null,"WHOLE YEAR",null,"PART YEAR"]
["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)"]
[36.25,1645.0250000000001,1608.7750000000001,{"$f":"B7*0.149846","v":246.50041615000004},{"$f":"C7*0.175755","v":282.75025012499998},335,{"$f":"(D7/365.26)*F7","v":226.07906535139358},{"$f":"(E7/365.26)*F7","v":259.3257783274243}]
[18.125,822.51300000000003,804.38800000000003,{"$f":"B8*0.149846","v":123.25028299800002},{"$f":"C8*0.175755","v":141.37521294000001},335,{"$f":"(D8/365.26)*F8","v":113.03960139169361},{"$f":"(E8/365.26)*F8","v":129.66296976099218}]
[]
["CALCULATOR:"]
[]
["BASIC DETAILS",null,null,"WHOLE YEAR",null,"PART YEAR"]
["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,{"$f":"B14*0.149846","v":0},{"$f":"C14*0.175755","v":0},null,{"$f":"(D14/365.26)*F14","v":0},{"$f":"(E14/365.26)*F14","v":0}]
[0,0,0,{"$f":"B15*0.149846","v":0},{"$f":"C15*0.175755","v":0},0,{"$f":"(D15/365.26)*F15","v":0},{"$f":"(E15/365.26)*F15","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":"2019 Template","index":4,"n_rows":366,"n_cols":29,"rows_kept":366,"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 2019",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","2019-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","2019-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,"2019-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,"2019-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,"2019-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,"2019-01-06"]
[null,null,null,null,"Start date",null,null,null,null,null,{"$f":"VALUE(SList)","v":43466},{"$f":"K8-1","v":43465},null,null,"2019-01-01",null,null,null,null,null,null,null,null,null,7,null,null,null,"2019-01-07"]
[null,null,null,null,"End date",null,null,null,null,null,{"$f":"VALUE(O9)","v":43830},{"$f":"K9+1","v":43831},null,null,"2019-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-08"]
[null,null,null,null,"Greater than  5 Years Service?",null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-01-23"]
[{"$f":"VALUE(B25)","v":43465},"2018-12-31",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,{"$f":"SUM(C25:I25)+(J25*$O$21)+(L25*$O$21)","v":0},{"$f":"O12+O15-N25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-24"]
[{"$f":"VALUE(B26)","v":43472},{"$f":"B25+7","v":"2019-01-07"},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,"2019-01-25"]
[43479,"2019-01-14",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,"2019-01-26"]
[43486,"2019-01-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,"2019-01-27"]
[43493,"2019-01-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,"2019-01-28"]
[43500,"2019-02-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,"2019-01-29"]
[43507,"2019-02-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,"2019-01-30"]
[43514,"2019-02-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,"2019-01-31"]
[43521,"2019-02-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,"2019-02-01"]
[43528,"2019-03-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,"2019-02-02"]
[43535,"2019-03-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,"2019-02-03"]
[43542,"2019-03-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,"2019-02-04"]
[43549,"2019-03-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,"2019-02-05"]
[43556,"2019-04-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,"2019-02-06"]
[43563,"2019-04-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,"2019-02-07"]
[43570,"2019-04-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,"2019-02-08"]
[43577,"2019-04-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,"2019-02-09"]
[43584,"2019-04-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,"2019-02-10"]
[43591,"2019-05-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,"2019-02-11"]
[43598,"2019-05-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,"2019-02-12"]
[43605,"2019-05-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,"2019-02-13"]
[43612,"2019-05-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,"2019-02-14"]
[43619,"2019-06-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,"2019-02-15"]
[43626,"2019-06-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,"2019-02-16"]
[43633,"2019-06-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,"2019-02-17"]
[43640,"2019-06-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,"2019-02-18"]
[43647,"2019-07-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,"2019-02-19"]
[43654,"2019-07-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,"2019-02-20"]
[43661,"2019-07-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,"2019-02-21"]
[43668,"2019-07-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,"2019-02-22"]
[43675,"2019-07-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,"2019-02-23"]
[43682,"2019-08-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,"2019-02-24"]
[43689,"2019-08-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,"2019-02-25"]
[43696,{"$f":"B57+7","v":"2019-08-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,"2019-02-26"]
[43703,"2019-08-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,"2019-02-27"]
[43710,"2019-09-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,"2019-02-28"]
[43717,"2019-09-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,"2019-03-01"]
[43724,"2019-09-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,"2019-03-02"]
[43731,"2019-09-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,"2019-03-03"]
[43738,"2019-09-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,"2019-03-04"]
[43745,"2019-10-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,"2019-03-05"]
[43752,"2019-10-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,"2019-03-06"]
[43759,"2019-10-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,"2019-03-07"]
[43766,"2019-10-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,"2019-03-08"]
[43773,"2019-11-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,"2019-03-09"]
[43780,"2019-11-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,"2019-03-10"]
[43787,"2019-11-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,"2019-03-11"]
[43794,"2019-11-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,"2019-03-12"]
[43801,"2019-12-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,"2019-03-13"]
[43808,"2019-12-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,"2019-03-14"]
[43815,"2019-12-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,"2019-03-15"]
[43822,"2019-12-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,"2019-03-16"]
[43829,"2019-12-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-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,"2019-12-31"]