{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","1 - Management Representation","2 - Enrolment Worksheet","3 - Provider Information","4 - Base Funding Details","6 - Subsidy Reconciliation","5-Base Operating Admin Expenses","5 - Transition Operating Grant","Definitions","4 - COVID Spending","4a - Child Absenteeism Tool","4b - Closure by PPH Tool","5 - Staff Absenteeism Tool","6 - GovGrants Input","Legend","Legend2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":15,"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":"Instructions","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Licensed Home Child Care (LHCC) 2023 Base Funding Reconciliation Template"]
[]
["Instructions"]
[]
["You will be required to use this template to complete the final reconciliation report."]
[]
["Please submit the completed template through GovGrants by the due date of January 31, 2024."]
[]
["Reference Materials"]
[]
["2023 LHCC Base Funding Memo"]
["2023 LHCC Base Funding Guideline"]
["2023 LHCC Base Funding Quick Look"]
["2023 LHCC Base Funding Question and answers"]
["2023 LHCC Base Funding Parent notice – 2023 LHCC fee reduction programs"]
[]
["https://www.peelregion.ca/children/working/service-providers/#homecc"]
[]
["For any questions, please email: EarlyYearsSystemDivision@peelregion.ca. "]

{"sheet":"1 - Management Representation","index":1,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[54,0,54,2],[11,1,13,5],[48,0,48,6],[35,1,35,8],[36,1,36,8],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[28,0,28,9],[33,1,33,8],[34,1,34,8],[48,7,48,10],[49,0,49,2],[49,3,49,6],[49,7,52,10],[50,0,50,2],[50,3,50,6],[51,0,51,2],[51,3,51,6],[52,0,52,2],[52,3,52,6],[11,8,11,10],[17,0,17,8],[21,0,23,8],[0,0,0,10],[7,1,7,5],[7,8,7,10],[9,1,9,5],[9,8,9,10],[4,0,5,0],[4,1,5,5]]}
["Tab 1 - Agency Information and Management Representation"]
[]
[null,"Please complete all fields highlighted in green"]
[]
["Do you have a CWELCC agreement and a head office in Peel?"]
[]
[]
["Agency Name:",null,null,null,null,null,null,"Contact Name: "]
[]
["Legal Name: ",null,null,null,null,null,null,"Email Address: "]
[]
["Address: ",null,null,null,null,null,null,"Phone No: "]
[]
[]
[null,"Hold \"ALT\" and press \"Enter\" to go to next line in Address box"]
["-------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
["General"]
["I/We certify, to the best of my/our knowledge, that the data provided in this reconciliation template is true and accurate."]
[]
["Attestation"]
[]
["I/We certify that the organization has exhausted all other available funding and that expenses claimed and supported through 2023 Base Funding have not been covered through other Peel Early Years and Child Care funding streams or other government funding programs and that all eligible expenses were only claimed once in the appropriate section."]
[]
[]
[]
[]
["-------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[]
["By submitting this file, I/we understand that Peel Region reserves the right to require any supporting documents during the reconciliation review, and the information provided in this template may be subject to audit from Peel Region after the approval of the reconciliation by Peel staff. Providers are required to keep all original documentation for a minimum of 7 years."]
[]
[]
["AUTHORIZED SIGNING OFFICER"]
[]
["Name:"]
["Signature:",null,null,null,null,null,null,null,null,null,"Please insert electronic signature or type your name. "]
["Title:"]
["Date:"]
[]
[]
["CO-AUTHORIZED SIGNING OFFICER (IF APPLICABLE)"]
[]
["Name:"]
["Signature:",null,null,null,null,null,null,null,null,null,"Please insert electronic signature or type your name. "]
["Title:"]
["Date:"]
[]
[]
[]
["For Office Use Only",null,null,null,null,null,null,"Comments"]
["Reconciliation Reviewed By:"]
["Signature:"]
["Name (Please Print):"]
["Date:"]
[]
["Vendor ID:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yes"]
["Not Applicable"]

{"sheet":"2 - Enrolment Worksheet","index":2,"n_rows":179,"n_cols":23,"rows_kept":179,"cut":false,"hidden":false,"merged":[[2,1,2,12],[0,1,0,12],[1,1,1,12],[20,0,20,1]]}
["Tab 2 - Enrolment Worksheet"]
["Fee Reduction Operating Grant only applies to School Age children  6 - 12 years old."]
["Programs Serving Ages 6-12 yrs. ","Full Fee Enrolment for January - December 2023"]
["School age (6-12 years)","January \nActual Enrolment","February \nActual Enrolment","March \nActual Enrolment","April \nActual Enrolment","May        \n Actual Enrolment","June         \n Actual Enrolment","July Actual Enrolment","August Actual Enrolment","September Actual Enrolment","October Actual Enrolment","November Actual Enrolment","December Actual Enrolment"]
["FULL-FEE PAYING FAMILIES (Based on # of Children Enrolled)",null,null,null,null,null,"BASED ON # of CHILDREN ENROLLED"]
["School age (6-12 years)"]
["Total",{"$f":"IF(SUM(B6:B6)=0,\"\",SUM(B6:B6))","v":""},"","","","","","","","","","",""]
[]
[]
[]
["LHCC BASE FUNDING - FEE REDUCTION OPERATING GRANT (FROG) (Ages 6-12 yrs)"]
[]
["School age (6-12 years)","TOTAL"]
[]
[]
["# of children supported by FROG ($6 Daily)",{"$f":"SUM(B7:M7)","v":0}]
["      Total Rate Reduction Amount"]
[]
[]
[]
["Maximum Cap"]
["Estimated maximum total amount (21.75 x $6 x number of children supported)",{"$f":"B16*21.75*6","v":0}]
["Reasonable(Not over the cap)?",{"$f":"IF(B17<=B22,\"Yes\", \"No\")","v":"Yes"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Home-Based"]
[]
[]
[]
["Part-Day"]
["Full-Day"]
[]
[]
[]
[]
["Municipal"]
[]
["Market"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home-Based"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full fee paying families"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Families who pay parental contribution greater than the Part 2 adjusted rate:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full fee paying families"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Families who pay parental contribution less than the Part 2 adjusted rate:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part-Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full-Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Municipal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Market"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Market"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 day a week"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 days a week"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 days a week"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 days a week"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 days a week"]

{"sheet":"3 - Provider Information","index":3,"n_rows":113,"n_cols":8,"rows_kept":113,"cut":false,"hidden":false,"merged":[[2,0,2,7],[4,4,4,6],[110,0,110,2],[111,0,111,2],[112,0,112,2],[5,0,6,0],[5,1,6,1],[5,2,6,2],[4,0,4,2]]}
["Tab 3 - Provider Information"]
[]
["NOTE: If you are experiencing a reduced number of active homes (compared to January 2020), you must reduce your monthly allocation based on the number of current active homes before you allocate payments to home child care providers. For details, please refer to the 2023 LHCC Base Funding Guideline (p. 5-6). If your number of active homes has increased (compared to January 2020), you can distribute the full amount of your provider payment allocation. If you are experiencing a significant increase in the number of home child care providers that are caring for children, please inform your Early Years Specialist."]
[]
["FINAL RECONCILIATION",null,null,null,"FOR FINAL RECONCILIATION ONLY"]
["Home Child Care Provider (Initials)","Postal Code","Total Number of Days Worked YTD Dec 31, 2023",null,"Original (Base) ","LHCC - Payments to HCC Providers","LHCC - Historical Funding","TOTAL PAYMENTS"]
[null,null,null,null,"Payments (Excluding ROP Subsidies)","2023 LHCC Payments to Providers","2023 Historical Funding Used for Providers","Total Payments (Including ROP Subsidies)"]
[null,null,null,null,null,null,null,{"$f":"IF(+E8+F8+G8=0,\"\",+E8+F8+G8)","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(+E106+F106+G106=0,\"\",+E106+F106+G106)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(+E107+F107+G107=0,\"\",+E107+F107+G107)","v":""}]
[null,null,{"$f":"SUM(C8:C107)","v":0},null,{"$f":"SUM(E8:E107)","v":0},{"$f":"SUM(F8:F107)","v":0},0,{"$f":"SUM(H8:H107)","v":0}]
[]
[]
["# OF PROVIDERS",null,null,null,{"$f":"COUNTIF(E8:E107,\">0\")","v":0},{"$f":"COUNTIF(F8:F107,\">0\")","v":0},{"$f":"COUNTIF(G8:G107,\">0\")","v":0},0]
["AVG $ / PROVIDER",null,null,null,{"$f":"IF(ISERROR(+E108/E111),\"\",+E108/E111)","v":""},{"$f":"IF(ISERROR(+F108/F111),\"\",+F108/F111)","v":""},"",""]
["% IMPROVEMENT DUE TO ROP SUBSIDIES",null,null,null,null,{"$f":"IF(ISERROR(+F112/$E$112),\"\",+F112/$E$112)","v":""},{"$f":"IF(ISERROR(+G112/$E$112),\"\",+G112/$E$112)","v":""},{"$f":"IF(ISERROR(+H112/E112-1),\"\",+H112/E112-1)","v":""}]

{"sheet":"4 - Base Funding Details","index":4,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,8],[7,0,7,4],[3,10,4,10],[3,11,4,11],[3,9,4,9],[3,0,3,8],[6,0,6,4],[5,0,5,4],[4,0,4,4]]}
["Tab 4 - Base Funding Details"]
["Note: If you used Historical Funding in 2022 to enhance payments to providers, you may use underspending from the SWB component to continue to do so in 2023.\nEffective January 1, 2023, Historical Funding (applicable to eligible agencies only) has been merged with Staff Wages and Benefits (SWB) allocation to streamline funding and reduce reporting requirements."]
[]
["LHCC - PAYMENTS TO HOME VISITORS AND SUPERVISORS (SWB) ALLOCATION SUMMARY",null,null,null,null,null,null,null,null,"Benefit %","Hourly Rate Enhancement\nReasonability Check @ $5","FTE Calculation \n(/ 1754.5)"]
["POSITIONS ELIGIBLE TO RECEIVE STAFF WAGES & BENEFITS",null,null,null,null,"Total Number of hours worked/paid for each Position Category Based on Distribution Policy","Salaries Employer Paid","Benefits Employer Paid","SWB $ Paid  (Salaries & Benefits)"]
["Home Child Care Visitors",null,null,null,null,null,null,null,{"$f":"G6+H6","v":0},{"$f":"H6/G6","v":{"$error":"#DIV/0!"}},{"$f":"G6/F6","v":{"$error":"#DIV/0!"}},{"$f":"F6/1754.5","v":0}]
["Supervisors and non-Program Staff that spend at least 25% of their time in a Home Visitor position",null,null,null,null,null,null,null,0,{"$f":"H7/G7","v":{"$error":"#DIV/0!"}},{"$f":"G7/F7","v":{"$error":"#DIV/0!"}},{"$f":"F7/1754.5","v":0}]
["TOTAL ",null,null,null,null,{"$f":"SUM(F6:F7)","v":0},{"$f":"SUM(G6:G7)","v":0},{"$f":"SUM(H6:H7)","v":0},{"$f":"SUM(I6:I7)","v":0},{"$f":"H8/G8","v":{"$error":"#DIV/0!"}},{"$f":"G8/F8","v":{"$error":"#DIV/0!"}},{"$f":"F8/1754.5","v":0}]

{"sheet":"6 - Subsidy Reconciliation","index":5,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+'4 - Base Funding Details'!A1","v":"Tab 4 - Base Funding Details"}]
["Subsidy / Funds Reconciliation (Jan to Dec 2022)"]
[{"$f":"\"Account # \" &#REF!","v":{"$error":"#REF!"}}]
[]
[null,"LHCC Base Funding",null,"Approved & Paid By Region of Peel",null,"Total Amounts $ Used by Agency",null,"Total Subsidy Entitlement $","Adjustment","Tota Revised Subsidy Entitlement $",null,"Subsidy Payable to Agency (Repayable to Region)",null,"Additional Notes"]
[]
[null,"Fee Reduction Operating Grant (FROG)",null,null,null,{"$f":"+'2 - Enrolment Worksheet'!B17","v":0},null,{"$f":"+F7","v":0},0,{"$f":"+H7+I7","v":0},null,{"$f":"J7-D7","v":0}]
[]
[null,"Payments to HCC Providers",null,null,null,{"$f":"+'3 - Provider Information'!F108","v":0},null,{"$f":"IF(D9>F9,F9,D9)","v":0},0,{"$f":"+H9+I9","v":0},null,{"$f":"J9-D9","v":0}]
[]
[null,"Payments to Home Vistors and Supervisors (SWB)",null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(D11>F11,F11,D11)","v":{"$error":"#REF!"}},0,{"$f":"+H11+I11","v":{"$error":"#REF!"}},null,{"$f":"J11-D11","v":{"$error":"#REF!"}}]
[]
[null,"Historical Funding",null,null,null,{"$f":"+'4 - Base Funding Details'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(D13>F13,F13,D13)","v":{"$error":"#REF!"}},0,{"$f":"+H13+I13","v":{"$error":"#REF!"}},null,{"$f":"J13-D13","v":{"$error":"#REF!"}},null,"Part 4 - Historical Allocation Funding = Use to fund staff wages and benefits"]
[]
[null,"Base Operating / Administrative Funding ",null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(D15>F15,F15,D15)","v":{"$error":"#REF!"}},0,{"$f":"+H15+I15","v":{"$error":"#REF!"}},null,{"$f":"J15-D15","v":{"$error":"#REF!"}}]
[]
[null,"Related COVID Expense",null,null,null,{"$f":"'4 - COVID Spending'!O56","v":0},null,{"$f":"+F17","v":0},0,{"$f":"+H17+I17","v":0},null,{"$f":"J17-D17","v":0}]
[]
[null,"GRAND TOTAL - LHCC Base Funding",null,null,null,{"$f":"+F15+F13+F11+F9+F7+F17","v":{"$error":"#REF!"}},null,{"$f":"+H15+H13+H11+H9+H7+H17","v":{"$error":"#REF!"}},{"$f":"+I15+I13+I11+I9+I7+I17","v":0},{"$f":"+J15+J13+J11+J9+J7+J17","v":{"$error":"#REF!"}},null,{"$f":"+L15+L13+L11+L9+L7+L17","v":{"$error":"#REF!"}}]

{"sheet":"5-Base Operating Admin Expenses","index":6,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["5 - Base Operating Admin Expenses"]
["For eligible expenses, please refer to the 2023 Base Funding Guideline:"]
["https://www.peelregion.ca/children/working/service-providers/#homecc"]
[]
["Item","Amount $","Comments"]
["Administration Expenses",null,"Offset incremental audit and/or \nadministration/bookkeeping costs to administer reporting requirements"]
["Occupancy costs",null,"Agency lease/rent, utilities"]
["Special Purpose Expenses",null,"All eligible costs must be accounted for only once"]
["Additional Staff Wages/Benefits and/or Payments to Providers\nAmount reported on this line is in addition to amounts reported in tabs 3 and 4",null,"Support enhancements in these Base Funding components, based on agency discretion"]
["Total Spent",{"$f":"SUM(B6:B9)","v":0}]

{"sheet":"5 - Transition Operating Grant","index":7,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Tab 5 -Transition Operating Grant (TOG)"]
["The TOG is only for agencies with a head office in Peel that receive CWELCC funding. Please see page 7 of the 2023 LHCC Base Funding Guideline for details. Refer to the 2023 CWELCC LHCC Guideline for a list of ineligible TOG expenses (page 13)."]
["Please note, your existing base admin funding to support EYCC programs (WEG, WIF, Base Funding) has been consolidated and flowed through TOG."]
[]
["Particulars","Expenses"]
["Inflationary Rent/Lease Costs"]
["Inflationary Nutrition/Food Costs"]
["Inflationary Staff salaries and benefits"]
["Cost of audited financial statements for the licensed child care portion of your business"]
["Cost to implement CWELCC (ex. Software upgrades)"]
["Cost to meet reporting requirements"]
["Special purpose expenses"]
["Payments to home providers"]
["Other Eligible Expenses (Refer to guideline - list as needed)"]
["1)"]
["2)"]
["3)"]
["4)"]
["5)"]
["Other inflationary expenses (list as needed):"]
["1)"]
["2)"]
["3)"]
["4)"]
["5)"]
["Administrative Expenses associated with existing EYCCS programs (list as needed) :"]
["1)"]
["2)"]
["3)"]
["4)"]
["5)"]
["Total TOG Expenditure",{"$f":"SUM(B6:B31)","v":0}]

{"sheet":"Definitions","index":8,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,"Definitions"]
[]
[null,"Term","Definition"]
[null,"Fiscal period","The budgetary accounting cycle. It is the length of time covered by an organization's financial statements. "]
[null,"Full-day","6 hours or more per day."]
[null,"Part-day","Less than 6 hours per day."]
[null,"Market rate","The rate charged to full fee paying parents."]
[null,"Municipal rate","The rate approved by the Region of Peel. Refer to schedule A1 in your Fee Subsidy and Funding Agreement."]
[null,"Reduced rate","Daily Market or Municipal Rate minus GOF Part 2 Daily Rate (Full-Day Rate = $12, Part-Day Rate = $6)"]
[]
[]
[]
[]
[null,"Acronyms"]
[]
[null,"EYS","Early Years Specialist"]
[null,"GOF","General Operating Fund"]
[null,"RECE","Registered Early Childhood Educator"]
[null,"SWB","Staff Wages and Benefits"]

{"sheet":"4 - COVID Spending","index":9,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":true,"merged":[[42,16,44,16],[61,1,61,13],[63,16,64,16],[8,0,9,5],[24,1,24,13],[29,16,31,16],[37,16,38,16],[33,16,35,16],[50,16,51,16]]}
["Tab 4 - Covid Spending"]
["Instructions: "]
["Please enter the total Approved 2022 Base Funding contract amount in cell B14"]
["Cells B15 to B19 are automatically populated with the results from other tabs. Please feel free to modify the amounts if necessary."]
["Please use columns B - M for planning purposes. For In-Year Reporting and Year-End Reconciliation, please provide Actuals $ in column O. "]
["Agencies will be required to submit any supporting invoices for audited financial statements and bookkeeping/accounting expenses over $15,000 by January 31, 2022, unless otherwise directed earlier by the Region."]
["Please refer to the instructions in column Q and/or LHCC Base Funding Guideline for additional details. "]
[]
["IMPORTANT NOTE: All eligible costs must be accounted for only once under the various categories. If an agency is found to be using more than one eligible funding category to fund the same eligible cost, it may result in a funding recovery."]
[]
[]
[]
["COVID Related Expenses Summary Calculator"]
["2022 Approved LHCC Base Funding (from January to December 2022), per Contract",100,{"$f":"B14","v":100},0]
["Less: Fee Reduction Operating Grant (FROG) Used",{"$f":"+'2 - Enrolment Worksheet'!B17","v":0},{"$f":"IF(B15<0,\"Postive Number Only\",\"\")","v":""}]
["Less: Payments to HCC Providers Used",{"$f":"+'3 - Provider Information'!F108","v":0},{"$f":"IF(B16<0,\"Postive Number Only\",\"\")","v":""}]
["Less: Payments to Home Visitors and Supervisors (SWB)",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Less: Historical Funding",{"$f":"+'4 - Base Funding Details'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Less: Base Operating / Administrative Funding ",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Total Maximum Funding Available to be used for COVID Related Expenses:",{"$f":"B14-SUM(B15:B19)","v":{"$error":"#REF!"}}]
[]
["2022 Actual COVID Related Expenses $",{"$f":"IF(O56<B20,O56,B20)","v":{"$error":"#REF!"}}]
["Projected Repayable to Region ",{"$f":"+B20-B22","v":{"$error":"#REF!"}},{"$f":"IF(B23>0,\"This is the projected repayable amount.\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column O"]
[null,"PLANNING SECTION",null,null,null,null,null,null,null,null,null,null,null,null,"IN-YEAR & RECONCILIATION"]
[null,"Plan January","Plan February","Plan March","Plan April ","Plan May","Plan June","Plan July","Plan August","Plan September","Plan October","Plan November","Plan December","Plan Total",{"$f":"IF('1 - Management Representation'!#REF!=\"January to June 2022\",\"Actuals\nJanuary to June 2022\",IF('1 - Management Representation'!#REF!=\"January to December 2022\",\"Actuals\nJanuary to December 2022\",\"\"))","v":{"$error":"#REF!"}},null,"Region of Peel Instructions"]
["General Eligible Expenses"]
["1. PPE and Enhanced Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B28:M28)","v":0},null,null,"*Must exhaust PPE supplies from Government of Ontario first before using Base Funding. Refer to 2022 Base Funding Guideline for more information."]
[]
["2. Support for Child Absenteeism - Complete tab 4a first (Mandatory to complete)",{"$f":"'4a - Child Absenteeism Tool'!I23","v":0},{"$f":"'4a - Child Absenteeism Tool'!J23","v":0},{"$f":"'4a - Child Absenteeism Tool'!K23","v":0},{"$f":"'4a - Child Absenteeism Tool'!L23","v":0},{"$f":"'4a - Child Absenteeism Tool'!M23","v":0},{"$f":"'4a - Child Absenteeism Tool'!N23","v":0},{"$f":"'4a - Child Absenteeism Tool'!O23","v":0},{"$f":"'4a - Child Absenteeism Tool'!P23","v":0},{"$f":"'4a - Child Absenteeism Tool'!Q23","v":0},{"$f":"'4a - Child Absenteeism Tool'!R23","v":0},{"$f":"'4a - Child Absenteeism Tool'!S23","v":0},{"$f":"'4a - Child Absenteeism Tool'!T23","v":0},{"$f":"SUM(B30:M30)","v":0},{"$f":"+'4a - Child Absenteeism Tool'!U23","v":0},null,"From January to March, you must have used your Base Funding to support a Child Absenteeism Policy that covered a minimum of 5 days per month per child (as needed), to support families whose children did not pass provincial screening and must self-isolate. Starting April 1, 2022, you can determine the number of days you will support under your Child Absenteeism policy. You must complete Tab 4a - Child Absenteeism Tool. "]
["Number of Children related to Child Absenteeism",{"$f":"'4a - Child Absenteeism Tool'!I19","v":0},{"$f":"'4a - Child Absenteeism Tool'!J19","v":0},{"$f":"'4a - Child Absenteeism Tool'!K19","v":0},{"$f":"'4a - Child Absenteeism Tool'!L19","v":0},{"$f":"'4a - Child Absenteeism Tool'!M19","v":0},{"$f":"'4a - Child Absenteeism Tool'!N19","v":0},{"$f":"'4a - Child Absenteeism Tool'!O19","v":0},{"$f":"'4a - Child Absenteeism Tool'!P19","v":0},{"$f":"'4a - Child Absenteeism Tool'!Q19","v":0},{"$f":"'4a - Child Absenteeism Tool'!R19","v":0},{"$f":"'4a - Child Absenteeism Tool'!S19","v":0},{"$f":"'4a - Child Absenteeism Tool'!T19","v":0},{"$f":"SUM(B31:M31)","v":0},{"$f":"N31","v":0}]
["Number of Days related to Child Absenteeism",{"$f":"'4a - Child Absenteeism Tool'!I20","v":0},{"$f":"'4a - Child Absenteeism Tool'!J20","v":0},{"$f":"'4a - Child Absenteeism Tool'!K20","v":0},{"$f":"'4a - Child Absenteeism Tool'!L20","v":0},{"$f":"'4a - Child Absenteeism Tool'!M20","v":0},{"$f":"'4a - Child Absenteeism Tool'!N20","v":0},{"$f":"'4a - Child Absenteeism Tool'!O20","v":0},{"$f":"'4a - Child Absenteeism Tool'!P20","v":0},{"$f":"'4a - Child Absenteeism Tool'!Q20","v":0},{"$f":"'4a - Child Absenteeism Tool'!R20","v":0},{"$f":"'4a - Child Absenteeism Tool'!S20","v":0},{"$f":"'4a - Child Absenteeism Tool'!T20","v":0},{"$f":"SUM(B32:M32)","v":0},{"$f":"N32","v":0}]
[]
["3. Home Closure Directed by Peel Public Health - Complete tab 4b first (Mandatory to complete)",{"$f":"'4b - Closure by PPH Tool'!I22","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"B34","v":0},{"$f":"'4b - Closure by PPH Tool'!I22","v":0},null,"2022 Base Funding is available to support child absenteeism due to mandated closures and self-isolations from Jan 1-31, 2022. You must complete Tab 4b - Closure by PPH Tool."]
["Number of Children who used Closure Absenteeism days",{"$f":"'4b - Closure by PPH Tool'!I18","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"B35","v":0},{"$f":"'4b - Closure by PPH Tool'!I18","v":0}]
["Total Number of Days supported through Closure Absenteeism",{"$f":"'4b - Closure by PPH Tool'!I19","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"B36","v":0},{"$f":"'4b - Closure by PPH Tool'!I19","v":0}]
[]
["4. Support for Fixed Operating Expenses - Use Section B (See Below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Funding can be used to offset a maximum of 75% of eligible expenses net any federal/provincial/municipal grants/discounts etc. "]
["Maximum Eligible Amount",{"$f":"B74","v":0},{"$f":"C74","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B39:M39)","v":0},{"$f":"O74","v":0}]
["Amount Claimed",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B40:M40)","v":0},null,null,"Refer to Section B below. Enter the amount claimed. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O40>O39,\"ERROR. Cannot Exceed the maximum amt of $\"& TEXT(O39,\"#.##\"),\"\")","v":""},null,"All eligible costs must be accounted for only once under the various categories."]
["5. Additional Staff Absenteeism Policy (Optional) - Complete tab 5 first"]
["Staff Wages and Mandatory Benefits-Portion not covered through CEWS. Paid to staff as part of regular payroll process. ",{"$f":"'5 - Staff Absenteeism Tool'!H22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!I22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!J22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!K22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!L22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!M22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!N22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!O22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!P22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!Q22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!R22","v":0},{"$f":"'5 - Staff Absenteeism Tool'!S22","v":0},{"$f":"SUM(B43:M43)","v":0},{"$f":"+'5 - Staff Absenteeism Tool'!T22","v":0},null,"To support additional staff sick/absenteeism days if staff do not pass screening and are unable to work AFTER your agency's existing sick day policy has been exhausted. It is up to agencies to determine the number of additional staff sick/absenteeism days they will cover and to communicate their staff sick/absenteeism policy to staff.  "]
["Number of absent days",{"$f":"'5 - Staff Absenteeism Tool'!H19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!I19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!J19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!K19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!L19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!M19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!N19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!O19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!P19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!Q19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!R19","v":0},{"$f":"'5 - Staff Absenteeism Tool'!S19","v":0},{"$f":"SUM(B44:M44)","v":0},{"$f":"N44","v":0}]
["Number of staff  ",{"$f":"'5 - Staff Absenteeism Tool'!H16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!I16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!J16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!K16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!L16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!M16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!N16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!O16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!P16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!Q16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!R16","v":0},{"$f":"'5 - Staff Absenteeism Tool'!S16","v":0},{"$f":"SUM(B45:M45)","v":0},{"$f":"N45","v":0}]
[]
["6. One-time cost related to the completion of: "]
["Audited financial statements or financial statements - Jan 1 to Dec 31, 2022",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B48:M48)","v":0},null,null,"For Peel sites only. Agencies are required to submit any supporting invoices for expenses over $15,000 with the Reconciliation"]
["Bookkeeping and accounting costs incurred - Jan 1 to Dec 31, 2022",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B49:M49)","v":0},null,null,"For Peel sites only. Agencies are required to submit any supporting invoices for expenses over $15,000 with the Reconciliation"]
[]
["7. Recruitment Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wages and mandatory benefits for hours spent conducting recruitment and hiring activities and participating in job fairs (for recruitment purposes). For more details refer to the guideline."]
["Wages and Benefits for hours spent on recruitment and hiring activities - Jan 1 to Dec 31, 2022",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B52:M52)","v":0}]
["Other Recruitment Costs - Jan 1 to Dec 31, 2022",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B53:M53)","v":0},null,null,"To support: A) job posting ads with an external company or post-secondary institution; B) professional and consulting fees for a third-party recruiter/recruitment company not claimed under Administrative Expenses; and C)  job fair registration fees. "]
["# of Hours on Recruitment and Hiring Activities",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B54:M54)","v":0}]
[]
[" Total COVID Related Expenses ",{"$f":"SUM(B28:B53)-B31-B32-B35-B36-B39-B44-B45","v":0},{"$f":"SUM(C28:C53)-C31-C32-C35-C36-C39-C44-C45","v":0},{"$f":"SUM(D28:D53)-D31-D32-D35-D36-D39-D44-D45","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B56:M56)","v":0},{"$f":"SUM(O28:O53)-O31-O32-O35-O36-O39-O44-O45","v":0}]
[]
[]
[]
[]
[]
["Section B- FIXED OPERATING EXPENSE WORKSHEET","PLANNING SECTION",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O25","v":"IN-YEAR & RECONCILIATION"}]
["See Instructions in Column Q","Plan January","Plan February","Plan March","Plan April ","Plan May","Plan June","Plan July","Plan August","Plan September","Plan October","Plan November","Plan December","Plan Total",{"$f":"O26","v":{"$error":"#REF!"}},null,"Region of Peel Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Funding can be used to offset a maximum of 75% of eligible expenses net any federal/provincial/municipal grants/discounts etc. "]
["Eligible Fixed Cost Expenses: "]
["Lease / Rental Costs (net of any federal/provincial grants or discounts)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B66:M66)","v":0}]
["Utilities",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B67:M67)","v":0}]
["Insurance",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Health and Dental Benefits",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Telephone / Internet",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Program Supplies (consumables only)",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total ",{"$f":"SUM(B66:B71)","v":0},0,0,0,0,{"$f":"SUM(G66:G71)","v":0},0,0,0,0,0,0,0,0]
[]
["Maximum Eligible Amount for Fixed Costs Capped at 75%",{"$f":"(0.75*B72)","v":0},{"$f":"(0.75*C72)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B74:M74)","v":0},0]

{"sheet":"4a - Child Absenteeism Tool","index":10,"n_rows":66,"n_cols":21,"rows_kept":66,"cut":false,"hidden":true,"merged":[[32,7,39,12],[15,0,15,5],[25,7,25,16],[31,7,31,12]]}
["Tab 4a - Child Absenteeism Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,"Infant","Jan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toddler","Feb"]
["Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kindergarten","Mar"]
["This Absenteeism tool will calculate the cost for child absenteeism from January 1, 2022 to December 31, 2022, as applicable. Please note that you must cover a minimum of 5 days per month per child (as needed) from January to March 2022. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Preschool","Apr"]
["This tab is mandatory and must be completed. The Region may request your Child Absenteeism policy and communication to parents at any time. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"School Age","May"]
["Only add the parent contribution if a family is in receipt of partial fee subsidy as the Region's contribution will be funded through your fee subsidy payment. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jun"]
["If the family is not in receipt of fee subsidy, please enter the municipal rate.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jul"]
["For families that are fully subsidized and pay no parental contribution, no entry needs to be made below as the cost will be covered through Fee Subsidy. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aug"]
["You will be required to report the number of days, number of children and expense claimed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sep"]
["Important Note: Agencies should not claim the FROG for the same absent days covered under the absenteeism policy for full fee families.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oct"]
["If you need additional rows for input, please click on row 63 and insert the number of rows required.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nov"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dec"]
[]
["Please complete all fields highlighted in green and the Comment Box"]
[]
["January 1, 2022 - March 31, 2022 (Optional April 1 - December 31, 2022)"]
["Child Initials","Month","Care Type","Municipal Rate for Full Fee Family OR Parent Contribution if partially subsidized\n","Number Of Absent Days Supported","Expense Claimed",null,null,null,null,null,"Optional","Optional","Optional","Optional","Optional","Optional","Optional","Optional","Optional"]
[null,null,null,null,null,{"$f":"D18*E18","v":0},{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Summary","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Number of Children",{"$f":"COUNTIF($B$18:$B$65,I$18)","v":0},0,0,0,0,0,0,0,0,0,0,0,"KPI #14"]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Number of Days",{"$f":"SUMIF($B$18:$B$65,I$18,$E$18:$E$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,"KPI #15"]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Expense Entered",{"$f":"SUMIF($B$18:$B$65,I$18,$F$18:$F$65)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},null,{"$f":"IF(I23>I21,\"ERROR\",\"\")","v":""},{"$f":"IF(J23>J21,\"ERROR\",\"\")","v":""},"","","","","","","",{"$f":"IF(R23>R21,\"ERROR\",\"\")","v":""},"",{"$f":"IF(T23>T21,\"ERROR\",\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Amount $ claimed",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I23:T23)","v":0}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},{"$f":"IF(COUNTIF(I22:T22,\">\"\"\")>0,\"Amount claimed cannot exceed expense entered in row 21 above.\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"D25*E25","v":0},{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Enter the maximum number of absent days per child covered through your Child Absenteeism Policy."]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Number Days in Policy ",null,null,null,null,null,null,null,null,null,null,null,null,"KPI #13"]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"D29*E29","v":0},{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Number of HCC Providers paid"]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Expense Paid To Providers"]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Add Comments in box below if absent days have not been claimed."]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"D57*E57","v":0},{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"D63*E63","v":0},"If you need additional rows for input, please click on row 63 and insert the number of rows required."]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,null,0,{"$f":"IF(Table1[[#This Row],[Expense Claimed]]>0,IF(Table1[[#This Row],[Child Initials]]=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[{"$f":"COUNTA(A18:A65)","v":0},null,null,null,{"$f":"SUM(E18:E65)","v":0},{"$f":"SUM(F18:F65)","v":0}]

{"sheet":"4b - Closure by PPH Tool","index":11,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":true,"merged":[[14,0,14,5]]}
["Tab 4b - Home Closure Directed by Peel Public Health (PPH)"]
["PLEASE DO NOT RECORD ABSENCES RELATED TO SCREENING ON THIS TAB. THOSE ABSENCES SHOULD ONLY BE RECORDED ON TAB 4a - CHILD ABSENTEEISM TOOL. "]
[]
["Instructions"]
["The Closure by PPH tool will calculate the cost of absenteeism related to mandatory self-isolations and home closures due to a COVID-19 outbreak from January 1-31, 2022."]
["Absences related to positives cases of COVID-19 cannot be counted towards the number of maximum absent days in your child absenteeism policy and should only be recorded on this tab."]
["This tab is mandatory and must be completed."]
["Only add the parent contribution if a family is in receipt of partial fee subsidy as the Region's contribution will be funded through your fee subsidy payment. "]
["If the family is not in receipt of fee subsidy, please enter the municipal rate."]
["For families that are fully subsidized and pay no parental contribution, no entry needs to be made below as the cost will be covered through Fee Subsidy. "]
["If you need additional rows for input, please click on row 64 and insert the number of rows required. Do not insert rows before row 63.  "]
[]
[]
["PLEASE RECORD ABSENCES RELATED TO PPH DIRECTED CLOSURES ONLY ON THIS TAB"]
["January 1-31, 2022"]
["Serious Occurrence Number \n(if applicable)","Care Type","Municipal Rate for Full Fee Family OR Parent Contribution if partially subsidized\n","# of Children Impacted","Number of Days","Expense Claimed"]
[null,null,null,null,null,{"$f":"C17*D17*E17","v":0},null,"Summary","January"]
[null,null,null,null,null,0,null,"Number of Children",{"$f":"D66","v":0}]
[null,null,null,null,null,0,null,"Number of Days",{"$f":"E66","v":0}]
[null,null,null,null,null,0,null,"Expense Entered",{"$f":"F66","v":0}]
[null,null,null,null,null,0,null,null,{"$f":"IF(I22>I20,\"ERROR\",\"\")","v":""}]
[null,null,null,null,null,0,null,"Amount claimed "]
[null,null,null,null,null,0,null,{"$f":"IF(COUNTIF(I21:I21,\">\"\"\")>0,\"Amount claimed cannot exceed expense entered in row 21 above.\",\"\")","v":""}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,"Add comments in the box below, if necessary."]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,"If you need additional rows for input, please click on row 64 and insert the number of rows required."]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D17:D65)","v":0},{"$f":"SUM(E17:E65)","v":0},{"$f":"SUM(F17:F65)","v":0}]

{"sheet":"5 - Staff Absenteeism Tool","index":12,"n_rows":64,"n_cols":20,"rows_kept":64,"cut":false,"hidden":true,"merged":[[28,6,35,11],[12,0,12,4],[13,6,13,15],[27,6,27,11],[5,0,5,5]]}
["Tab 5 - Staff Absenteeism Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feb"]
["Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mar"]
["This tab must be completed if you used your 2022 Base Funding to support an Additional Staff Absenteeism Policy (including optional staff wellness days).",null,null,null,null,null,null,null,null,null,null,null,null,null,"Apr"]
["The Region may request your additional Staff Absenteeism policy and communication to staff at any time. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"May"]
["The Staff Absenteeism Tool calculates the cost from January 1, 2022 to December 31, 2022 AFTER your existing absenteeism policy has been exhausted. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Jun"]
["Eligible absences must be paid to staff as part of your regular payroll process. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Jul"]
["If you need additional rows for input, please click on row 61 and insert the number of rows required. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Aug"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sep"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oct"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nov"]
["Please complete all fields highlighted in green and the Comment Box",null,null,null,null,null,null,null,null,null,null,null,null,null,"Dec"]
["January to December 2022"]
["Staff Initials","Month","Wages and Employer Portion Benefits Per Hour Net of CEWS","Number Of Hours Supported","Expense Claimed",null,"SUMMARY - STAFF ABSENTEEISM"]
[null,null,null,null,{"$f":"C15*D15","v":0},null,"Summary","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E16>0,IF('5 - Staff Absenteeism Tool'!$A16=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Number of Staff ",{"$f":"COUNTIF($B$15:$B$63,H$15)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E17>0,IF('5 - Staff Absenteeism Tool'!$A17=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Number of Hours",{"$f":"SUMIF($B$15:$B$63,H$15,$D$15:$D$63)","v":0},0,0,0,0,0,0,0,0,0,0,0,"KPI #16"]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E18>0,IF('5 - Staff Absenteeism Tool'!$A18=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Number of FTE",{"$f":"H17/(1820/12)","v":0},{"$f":"I17/(1820/12)","v":0},0,0,0,0,0,0,0,{"$f":"Q17/(1820/12)","v":0},0,0]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E19>0,IF('5 - Staff Absenteeism Tool'!$A19=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E20>0,IF('5 - Staff Absenteeism Tool'!$A20=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Expense Entered",{"$f":"SUMIF($B$15:$B$63,H$15,$E$15:$E$63)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E21>0,IF('5 - Staff Absenteeism Tool'!$A21=\"\",\"Initials Missing\",\"\"),\"\")","v":""},null,{"$f":"IF(H22>H20,\"ERROR\",\"\")","v":""},{"$f":"IF(I22>I20,\"ERROR\",\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E22>0,IF('5 - Staff Absenteeism Tool'!$A22=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Amount $ claimed ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H22:S22)","v":0}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E23>0,IF('5 - Staff Absenteeism Tool'!$A23=\"\",\"Initials Missing\",\"\"),\"\")","v":""},{"$f":"IF(COUNTIF(H21:S21,\">\"\"\")>0,\"Amount claimed cannot exceed expense entered in row 20 above.\",\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E24>0,IF('5 - Staff Absenteeism Tool'!$A24=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E25>0,IF('5 - Staff Absenteeism Tool'!$A25=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Enter the maximum number of absent days for staff covered through your Staff Absenteeism Policy"]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E26>0,IF('5 - Staff Absenteeism Tool'!$A26=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Number of days in Policy"]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E27>0,IF('5 - Staff Absenteeism Tool'!$A27=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E28>0,IF('5 - Staff Absenteeism Tool'!$A28=\"\",\"Initials Missing\",\"\"),\"\")","v":""},"Comments:"]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E29>0,IF('5 - Staff Absenteeism Tool'!$A29=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E30>0,IF('5 - Staff Absenteeism Tool'!$A30=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E31>0,IF('5 - Staff Absenteeism Tool'!$A31=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E32>0,IF('5 - Staff Absenteeism Tool'!$A32=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E33>0,IF('5 - Staff Absenteeism Tool'!$A33=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E34>0,IF('5 - Staff Absenteeism Tool'!$A34=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E35>0,IF('5 - Staff Absenteeism Tool'!$A35=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E36>0,IF('5 - Staff Absenteeism Tool'!$A36=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E37>0,IF('5 - Staff Absenteeism Tool'!$A37=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E38>0,IF('5 - Staff Absenteeism Tool'!$A38=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E39>0,IF('5 - Staff Absenteeism Tool'!$A39=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E40>0,IF('5 - Staff Absenteeism Tool'!$A40=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E41>0,IF('5 - Staff Absenteeism Tool'!$A41=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E42>0,IF('5 - Staff Absenteeism Tool'!$A42=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E43>0,IF('5 - Staff Absenteeism Tool'!$A43=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E44>0,IF('5 - Staff Absenteeism Tool'!$A44=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E45>0,IF('5 - Staff Absenteeism Tool'!$A45=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E46>0,IF('5 - Staff Absenteeism Tool'!$A46=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"C47*D47","v":0},{"$f":"IF('5 - Staff Absenteeism Tool'!$E47>0,IF('5 - Staff Absenteeism Tool'!$A47=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E48>0,IF('5 - Staff Absenteeism Tool'!$A48=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E49>0,IF('5 - Staff Absenteeism Tool'!$A49=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E50>0,IF('5 - Staff Absenteeism Tool'!$A50=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E51>0,IF('5 - Staff Absenteeism Tool'!$A51=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E52>0,IF('5 - Staff Absenteeism Tool'!$A52=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E53>0,IF('5 - Staff Absenteeism Tool'!$A53=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E54>0,IF('5 - Staff Absenteeism Tool'!$A54=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E55>0,IF('5 - Staff Absenteeism Tool'!$A55=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E56>0,IF('5 - Staff Absenteeism Tool'!$A56=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E57>0,IF('5 - Staff Absenteeism Tool'!$A57=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E58>0,IF('5 - Staff Absenteeism Tool'!$A58=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E59>0,IF('5 - Staff Absenteeism Tool'!$A59=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E60>0,IF('5 - Staff Absenteeism Tool'!$A60=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,"If you need additional rows for input, please click on row 61 and insert the number of rows required."]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E62>0,IF('5 - Staff Absenteeism Tool'!$A62=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[null,null,null,null,0,{"$f":"IF('5 - Staff Absenteeism Tool'!$E63>0,IF('5 - Staff Absenteeism Tool'!$A63=\"\",\"Initials Missing\",\"\"),\"\")","v":""}]
[{"$f":"COUNTA(A15:A63)","v":0},null,null,null,{"$f":"SUM(E15:E63)","v":0}]

{"sheet":"6 - GovGrants Input","index":13,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Tab 6 - GovGrants Input"]
["Please input the awarded budget amounts from GovGrants and then report the amounts, highlighted in yellow, under the applicable budget categories in GovGrants."]
[]
[]
[]
[]
[]
[]
[]
[]
["Budget Category","Awarded Budget","Spent this Period","Underspent/Recovery","Budget Category Explanation"]
["Staff wages and benefits",null,{"$f":"MIN('4 - Base Funding Details'!I8,B12)","v":0},{"$f":"B12-C12","v":0}]
["Operating",null,{"$f":"MIN('2 - Enrolment Worksheet'!B17,B13)","v":0},{"$f":"B13-C13","v":0},"Fee Reduction Operating Grant"]
["Pay Equity"]
["Administrative Funding",null,{"$f":"IF('1 - Management Representation'!B5=\"NO\", MIN('5-Base Operating Admin Expenses'!B10,B15), 0)","v":0},{"$f":"B15-C15","v":0},"Base \nOperating/ \nAdministration \nFunding"]
["Historical Fund"]
["Other (eligible agencies only)",null,{"$f":"IF('1 - Management Representation'!B5=\"YES\",B17,0)","v":0},{"$f":"B17-C17","v":0},"Part A TOG Funding"]
["Base Operating (eligible agencies only)",null,{"$f":"IF('1 - Management Representation'!B5=\"YES\",MIN(B18,'5 - Transition Operating Grant'!B32),0)","v":0},0,"Part B TOG Funding, including Special Purpose Funding"]
["Payments to Providers",null,{"$f":"MIN('3 - Provider Information'!F108+'3 - Provider Information'!G108,B19)","v":0},0]
["Total",{"$f":"SUM(B12:B19)","v":0},{"$f":"SUM(C12:C19)","v":0},{"$f":"SUM(D12:D19)","v":0}]

{"sheet":"Legend","index":14,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":true,"merged":[[10,0,10,1]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop Down Menu"]
["Name of Age Category","Age Range of Age Category",null,null,null,null,null,null,null,null,null,null,null,null,"Infant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toddler"]
["Infant","Younger than 18 months",null,null,null,null,null,null,null,null,null,null,null,null,"Pre-School (Not Eligible for Kindergarten)"]
["Toddler","18 months or older but younger than 30 months"]
["Pre-School (Not Eligible for Kindergarten)","30 months or older but younger than 6 years",null,null,null,null,null,null,null,null,null,null,null,null,"Part-Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full-Day"]
[]
["Centre-Based - Daily Fee Reduction Amounts (as per Guideline)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre-Based"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home-Based"]
[]
["Infant"]
["Part-Day",6]
["Full-Day",6,null,null,null,null,null,null,null,null,null,null,null,null,"Auspice"]
[]
["Toddler",null,null,null,null,null,null,null,null,null,null,null,null,null,"For-Profit"]
["Part-Day",6,null,null,null,null,null,null,null,null,null,null,null,null,"Not-For-Profit"]
["Full-Day",6]
[]
["Pre-schooler"]
["Part-Day",6,null,null,null,null,null,null,null,null,null,null,null,null,"Municipal"]
["Full-Day",6,null,null,null,null,null,null,null,null,null,null,null,null,"Market"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["# of Weeks","# Billable Days per Year",null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["1 day a week",53,{"$f":"365-(6*52)","v":53},null,null,null,null,null,null,null,null,null,null,null,4]
["2 days a week",105,{"$f":"365-(5*52)","v":105},null,null,null,null,null,null,null,null,null,null,null,5]
["3 days a week",157,{"$f":"365-(4*52)","v":157},null,null,null,null,null,null,null,null,null,null,null,6]
["4 days a week",209,{"$f":"365-(3*52)","v":209},null,null,null,null,null,null,null,null,null,null,null,7]
["5 days a week",261,{"$f":"365-(2*52)","v":261},null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]

{"sheet":"Legend2","index":15,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":true,"merged":[[42,0,42,1]]}
["DROP DOWN MENU ITEMS"]
[]
["Age Group"]
[]
["Infant"]
["Toddler"]
["Pre-School (Not Eligible for Kindergarten)"]
[]
["Municipal or Market"]
[]
["Market"]
["Municipal"]
[]
["Centre-Based or Home-Based"]
[]
["Centre-Based"]
["Home-Based"]
[]
["Part-Day or Full-Day"]
[]
["Part-Day"]
["Full-Day"]
[]
["# of Programs Days per Week","Billing Days per Year"]
[]
["1 day a week",53,{"$f":"365-(6*52)","v":53}]
["2 days a week",105,{"$f":"365-(5*52)","v":105}]
["3 days a week",157,{"$f":"365-(4*52)","v":157}]
["4 days a week",209,{"$f":"365-(3*52)","v":209}]
["5 days a week",261,{"$f":"365-(2*52)","v":261}]
[]
["Funding Programs"]
[]
["Part I"]
["Part II"]
[]
["Auspice"]
[]
["For Profit"]
["Not-For-Profit"]
[]
[]
["Centre-Based - Daily Fee Reduction Amounts (as per Guideline)"]
[]
[]
["Infant"]
["Part-Day",6]
["Full-Day",12]
[]
["Toddler"]
["Part-Day",6]
["Full-Day",12]
[]
["Preschooler"]
["Part-Day",6]
["Full-Day",12]