{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Funding Application","1x Funding Reconciliation","Validations","Site Details"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"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":"Funding Application","index":0,"n_rows":73,"n_cols":18,"rows_kept":73,"cut":false,"hidden":false,"merged":[[62,1,62,7],[68,1,68,5],[25,1,25,2],[14,1,14,6],[13,1,13,10],[16,1,16,7],[17,1,17,2],[21,1,21,7],[22,1,22,7],[12,1,12,4],[11,1,11,7],[15,1,15,7],[25,3,25,7],[40,14,40,17]]}
[]
[null,"2024 ONE-TIME SPECIAL PURPOSE FUNDING APPLICATION"]
[null,"AGENCY INFORMATION"]
[null,"Legal Name"]
[null,"Contact Name"]
[null,"Phone Number"]
[null,"Email Address"]
[]
[null,"Please refer to the Child Care Special Purpose Funding - Application Guidelines for Licensed Child Care Services Providers available at ",null,null,"www.dnssab.ca"]
[]
[null,"PLEASE NOTE:"]
[null,"•  In order to be considered, the application form must be completed in detail and submitted in the prescribed electronic format (Excel document).  Faxed, hand written or hard copy applications will not be considered.      "]
[null,"•  Expenses incurred any time in the current calendar year are eligible to be considered for reimbursement."]
[null,"•  Funding will be alloted based on identified priorities:  1) Requests that demonstrate the most critical and time sensitive needs (i.e. non-compliant or at risk of being non-compliant with licensing requirements) - must include written documentation. 2) Allocated within priorities identified by the service provider.  "]
[null,"•  Funding allocation will be determined within the allocated budget.  The availability of one-time Funding will depend on Ministry funding and DNSSAB’s Children’s Services budget flexibility."]
[null,"•  All supporting documentation (i.e. quotes, receipts, invoices, third party recommendations, etc.) related to this request must be included in order to be considered. "]
[null,"•  Quotations:  Agencies must ensure to solicit and submit the minimum number of quotes as described in the chart below.  If unable to meet the established quotation requirement (i.e. supplier with special knowledge, skills or expertise), documentation that demonstrates the every effort was undertaken to meet the requirement must be provided (i.e. written documentation of failed search.) "]
[null,"Quotation Requirements for Purchase of Goods and Services"]
[null,"$0 – $24,999","1 written quote detailing purchase and/or scope of work to be completed"]
[null,"$25,000 - $49,999","2 written quotes detailing purchase and/or scope of work to be completed"]
[null,"$50,000 +","3 written quotes detailing purchase and/or scope of work to be completed"]
[null,"•   When applying for funding related to Play-Based Materials and Equipment, please ensure to complete request for all materials and equipment using one \"row/line\" per site."]
[null,"•   When applying for funding related to Transformation,  if the request results in an increase of the licensed capacity of a child care program, the service provider is asked to complete the \"CWELCC Start-Up Grant Application\" form which will be made available on the DNSSAB website."]
[null,"•   All applications and supporting documents must be electronically submitted, using this format to the following email address by or before 12pm on May 10, 2024. ",null,null,null,"csfundingrequest@dnssab.ca"]
[]
[null,null,null,"CURRENT LICENSED CAPACITY",null,null,null,null,"NEW LICENSED CAPACITY"]
[null,"#","SITE NAME","INFANT","TODDLER","PRESCHOOL","JK/SK","SCHOOL AGE","Applicable when applying for Transformation Funding","ADDITIONAL DETAILS"]
[null,"Site 1",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 2",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 3",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 4",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 5",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 6",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 7",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 8",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 9",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 10",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[null,"Site 11",null,{"$f":"IFERROR(INDEX(Provider[INFANT],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[TODDLER],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[PRESCHOOL],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[JK/SK],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Provider[SCHOOL AGE],MATCH(Capacities[[#This Row],[SITE NAME]],Provider[Name],0)),\"\")","v":""}]
[]
[null,"APPLICATION DETAILS"]
[null,null,null,"Please Select All that Apply (i.e. infant, toddler, … etc.)",null,"Please Provide a Brief Description of the Project or Purchase or Repair.",null,null,"Please Assign a Priority for Each Request (i.e.1,2, 3, …etc.) by ranking in order of importance.",null,null,null,null,null,"FOR DNSSAB USE ONLY"]
[null,"REQUEST #","SITE NAME","AGE GROUP(S)","PROJECT, PURCHASE or REPAIR","DESCRIPTION","FUNDING TYPE","COST","AGENCY PRIORITY","REASON FOR REQUEST","ADDITIONAL DETAILS","PROJECT CURRENT STATUS","Add","Del","APPROVED","APPROVED ALLOCATION","TYPE OF SUPPORTING DOCUMENT(S) RECEIVED ","COMMENTS"]
[null,{"$f":"ROW()-42","v":1},null,null,null,null,null,0,null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,{"$f":"ROW()-42","v":2},null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,{"$f":"ROW()-42","v":3},null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,4,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,5,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,6,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,"+","-"]
[null,7,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,"+","-"]
[null,{"$f":"ROW()-42","v":8},null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,9,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,"+","-"]
[null,10,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,"+","-"]
[null,11,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,"+","-"]
[null,12,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,13,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,14,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,"+","-"]
[null,15,null,null,null,null,null,{"$f":"0","v":0},null,null,null,null,{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"}]
[null,null,null,null,null,null,"Repairs & Maintenance Funding",{"$f":"SUMIFS(FundingDetails[COST],FundingDetails[FUNDING TYPE],G58)","v":0},null,null,null,null,null,null,"Repairs & Maintenance Funding",{"$f":"SUMIFS(FundingDetails[APPROVED ALLOCATION],FundingDetails[FUNDING TYPE],O58)","v":0}]
[null,null,null,null,null,null,"Play-Based Materials & Equipment Funding",{"$f":"SUMIFS(FundingDetails[COST],FundingDetails[FUNDING TYPE],G59)","v":0},null,null,null,null,null,null,"Play-Based Materials & Equipment Funding",{"$f":"SUMIFS(FundingDetails[APPROVED ALLOCATION],FundingDetails[FUNDING TYPE],O59)","v":0}]
[null,null,null,null,null,null,"Transformation Funding",{"$f":"SUMIFS(FundingDetails[COST],FundingDetails[FUNDING TYPE],G60)","v":0},null,null,null,null,null,null,"Transformation Funding",{"$f":"SUMIFS(FundingDetails[APPROVED ALLOCATION],FundingDetails[FUNDING TYPE],O60)","v":0}]
[null,null,null,null,null,null,"TOTAL FUNDING 1x SPECIAL PURPOSE FUNDING REQUESTED",{"$f":"SUM(H58:H60)","v":0},null,null,null,null,null,null,"TOTAL FUNDING 1x SPECIAL PURPOSE FUNDING ALLOCATION",{"$f":"SUM(P58:P60)","v":0}]
[null,"IMPORTANT TO NOTE:"]
[null,"•   Any application does not guarantee a funding allocation for projects proposed, in progress or complete."]
[null,"•   Funding will be allocated based upon a priority rating as noted above and within policies and guidelines."]
[null,"•   Funding is dependent on Ministry funding allocations and DNSSAB’s Children’s Services budget flexibility."]
[null,"•   Any financial or contractual agreement the Service Provider undertakes is at their own risk and DNSSAB takes no responsibility for any financial investments the Service Provider makes prior to entering into a contractual agreement."]
[null,"•   All special purpose funding allocations must be expended by December 31st, annually.  If concerns arise with meeting this timeline, the Service Provider must advise DNSSAB as soon as possible to discuss potential solutions. "]
[]
[null,"ATTESTATION: I hereby certify that I have legal signing authority and agree with all terms and conditions related to the 1x special purpose funding."]
[]
[null,"Name:"]
[null,"Title:"]
[null,"Date:"]

{"sheet":"1x Funding Reconciliation","index":1,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,2,1,4],[60,1,60,4],[51,1,58,4],[18,5,18,6],[4,5,4,6],[32,5,32,6]]}
[null,"2024 ONE-TIME SPECIAL PURPOSE FUNDING RECONCILIATION"]
[null,"PURPOSE:  ","To report the actual expenditures related to one-time special purpose funding allocaiton for the calendar year and identify any adjustments and recoveries of funding."]
[null,"DUE DATE:  ","December 31st, annually"]
[]
[null,"TOTAL AMOUNT OF TRANSFORMATION FUNDING RECEIVED FOR THIS YEAR",null,null,{"$f":"SUMIFS(FundingDetails[APPROVED ALLOCATION],FundingDetails[FUNDING TYPE],\"Transformation Funding\")","v":0},"FOR DNSSAB USE ONLY"]
[null,"SITE ","APPROVED ITEMS","APPROVED ALLOCATION","ACTUAL AMOUNT PAID","SUPPORTING DOCUMENTATION","NOTES"]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(1:1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(1:1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(1:1)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},0]
[null,"ANNUAL VARIANCE (POSITIVE VARIANCE INDICATES A SURPLUS FUNDING)",null,{"$f":"SUM(Trans_Rec[APPROVED ALLOCATION])","v":0},{"$f":"E5-SUBTOTAL(109,Trans_Rec[ACTUAL AMOUNT PAID])","v":0}]
[]
[null,"TOTAL AMOUNT OF PLAY-BASED MATERIALS AND EQUIPMENT FUNDING RECEIVED FOR THIS YEAR",null,null,{"$f":"SUMIFS(FundingDetails[APPROVED ALLOCATION],FundingDetails[FUNDING TYPE],\"Play-Based Materials & Equipment Funding\")","v":0},"FOR DNSSAB USE ONLY"]
[null,"SITE ","APPROVED ITEMS","APPROVED ALLOCATION","ACTUAL AMOUNT PAID","SUPPORTING DOCUMENTATION","NOTES"]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(1:1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(15:15)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Transformation Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(15:15)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Play-Based Materials & Equipment Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},0]
[null,"ANNUAL VARIANCE (POSITIVE VARIANCE INDICATES A SURPLUS FUNDING)",null,{"$f":"SUM(Play_Rec[APPROVED ALLOCATION])","v":0},{"$f":"E19-SUBTOTAL(109,Play_Rec[ACTUAL AMOUNT PAID])","v":0}]
[]
[null,"TOTAL AMOUNT OF REPAIRS AND MAINTENANCE FUNDING RECEIVED FOR THIS YEAR",null,null,{"$f":"SUMIFS(FundingDetails[APPROVED ALLOCATION],FundingDetails[FUNDING TYPE],\"Repairs & Maintenance Funding\")","v":0},"FOR DNSSAB USE ONLY"]
[null,"SITE ","APPROVED ITEMS","APPROVED ALLOCATION","ACTUAL AMOUNT PAID","SUPPORTING DOCUMENTATION","NOTES"]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(1:1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(1:1)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(1:1)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(2:2)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(3:3)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(4:4)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(5:5)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(6:6)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(7:7)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(8:8)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(9:9)),1),\"\")","v":""},0]
[null,{"$f":"IFERROR(INDEX(FundingDetails[SITE NAME],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[PROJECT, PURCHASE or REPAIR])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[DESCRIPTION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[DESCRIPTION])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},{"$f":"IFERROR(INDEX(FundingDetails[APPROVED ALLOCATION],_xlfn.AGGREGATE(15,6,IF((FundingDetails[APPROVED]=\"✓\")*(FundingDetails[FUNDING TYPE]=\"Repairs & Maintenance Funding\"),ROW(FundingDetails[APPROVED ALLOCATION])-ROW(FundingDetails[#Headers])),ROW(10:10)),1),\"\")","v":""},0]
[null,"ANNUAL VARIANCE (POSITIVE VARIANCE INDICATES A SURPLUS FUNDING)",null,{"$f":"SUM(Maint_Rec[APPROVED ALLOCATION])","v":0},{"$f":"E33-SUBTOTAL(109,Maint_Rec[ACTUAL AMOUNT PAID])","v":0}]
[]
[null,"TOTAL VARIANCE (POSITIVE VARIANCE INDICATES A SURPLUS FUNDING)",null,null,{"$f":"Trans_Rec[[#Totals],[ACTUAL AMOUNT PAID]]+Play_Rec[[#Totals],[ACTUAL AMOUNT PAID]]+Maint_Rec[[#Totals],[ACTUAL AMOUNT PAID]]","v":0}]
[]
[null,"IMPORTANT NOTE:  A copy of all receipts, invoices and proof of payment must be submitted to DNSSAB as well as kept on file for a minimum of 7 years."]
[]
[null,"COMMENTS:      "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ATTESTATION: I hereby certify that, to the best of my knowledge, the information contained herein and the attached financial information is true, correct and agrees with the agency's financial records."]
[]
[null,"REPORT COMPLETED BY:"]
[null,"Name:"]
[null,"Title:"]
[null,"Date:"]

{"sheet":"Validations","index":2,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
[null,"AGE GROUP",null,"AGENCY PRIORITY",null,"Legal Name","ID",null,"Sites","Sites","Sites","Sites","Sites","Sites","Sites","Sites","Sites","Sites","Sites","Sites","Sites","Sites","Sites"]
[null,"Infant",null,"Non-Compliant",null,"1890390 Ontario Inc O/A Friends Forever Child Care","FFCC",null,"Friends Forever Child Care Centre","Garderie Beausoleil-Ecole Lorrain","Kidz Kastle","KIND Forest School","Kids Campus - Holy Cross","Little Wings Child Care Center","Mattawa Child Care Centre","Montessori Children's House (2685594 Ltd)","Montessori Learning Centre","NBDC - Main","North Bay Indigenous Hub","Garderie de Temagami Day Care","Ferris Glen Learning Centre-Ferris Glen","Centre Base","Alliance School Age Program"]
[null,"Toddler",null,"At Risk of Non-Compliance",null,"Les Compagnons des Franc Loisirs","GS",null,"Friends Forever Home Agency","Garderie Dragon d'or - Ecole Heritage",null,null,"Kids' Club- St. Lukes",null,null,null,null,"NBDC - School Age Program",null,null,"Silver Birches Child Care-Silver Birches","Home Child Care","Chippewa Early Learning Child Care Centre"]
[null,"Preschool",null,1,null,"Community Resource Centre (Killaloe) Inc","CRCK",null,null,"Garderie la Place ensoleillee-St. Vincent",null,null,"Kids Connection- St. Huberts",null,null,null,null,null,null,null,"West Ferris Day Nursery - Main","La Niche des Lionceaux- Résurrection","E.T. Carmicheal School Age Program"]
[null,"JK/SK",null,2,null,"KIND Forest School","KIND",null,null,"Garderie Le Petit Dragon - Ecole Odyssée",null,null,"Kids Corner - Mother St. Bride",null,null,null,null,null,null,null,"West Ferris SA Learning Ctr. Sunset Park","La Ruche des Petites Abeilles-Margueritt D'Youville","EW Norman Early Learning Child Care Centre"]
[null,"School Age",null,3,null,"The Lindsay Weld Centre for Children","LWCFC",null,null,"Garderie Rayons de Soleil-Ecole Ste. Anne",null,null,"Kids Crew - St. Alexander",null,null,null,null,null,null,null,null,"La Tanière des Tout-Petits-Jeunesse Active","Home Child Care"]
[null,"Family Grouping",null,4,null,"North Bay Military Family Resource Centre","LWCC",null,null,"Garderie Sol La-Ecole St. Thomas d'Aquin",null,null,"Lindsay Weld Centre for Children - Main",null,null,null,null,null,null,null,null,"Service de Garde des Louveteaux-St. Joseph","Mother St. Bride Early Learning Child Care Centre"]
[null,"All Age Groups",null,5,null,"Mattawa Child Care Centre","MCC",null,null,"Garderie Soleil La- Main Site",null,null,null,null,null,null,null,null,null,null,null,"Service de garde Ecole Christ- Roi","Our Lady of Fatima-Early Learning CCC"]
[null,"Infant/Toddler",null,6,null,"Montessori Children's House (2685594 Ltd)","MCH",null,null,"Garderie Tournesol-Ecole St. Raymond",null,null,null,null,null,null,null,null,null,null,null,"White Woods After School Program","Our Lady of Sorrows Early Learning CCC"]
[null,"Infant/Toddler/Preschool",null,7,null,"Montessori Learning Centre","MLC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Francis Early Learning Child Care Centre"]
[null,"Infant/Preschool",null,8,null,"1168108 Ontario Inc. O/A North Bay Daycare Centre","NBDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vincent Massey School Age Program"]
[null,"Toddler/Preschool",null,9,null,"North Bay Indigenous Hub","NBIH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodland Early Learning Child Care Centre"]
[null,"JK/SK/School Age",null,10,null,"Garderie de Temagami Day Care","TCC"]
[null,null,null,11,null,"West Ferris Day Nursery Inc.","WFDN"]
[null,null,null,12,null,"West Nipissing Child Care Corporation","WNCCC"]
[null,null,null,13,null,"YMCA of North Bay & District","YMCA"]
[null,"FUNDING TYPE",null,14]
[null,"Repairs & Maintenance Funding",null,15]
[null,"Play-Based Materials & Equipment Funding",null,16]
[null,"Transformation Funding",null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,"REASON FOR REQUEST"]
[null,"Licensing Requirement",null,"Marks"]
[null,"Ordered by Health Unit",null,"✓"]
[null,"Ordered by Fire Inspector",null,"x"]
[null,"Ordered by Health & Safety Authority"]
[null,"Health & Safety Concern"]
[null,"Other"]
[]
[]
[null,"PROJECT CURRENT STATUS"]
[null,"Proposed"]
[null,"In Progress"]
[null,"Completed"]

{"sheet":"Site Details","index":3,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["LegalName","Name","INFANT","TODDLER","PRESCHOOL","JK/SK","SCHOOL AGE","FAMILY AGE GROUPING"]
["1890390 Ontario Inc O/A Friends Forever Child Care","Friends Forever Child Care Centre",10,30,44,20,20,0]
["1890390 Ontario Inc O/A Friends Forever Child Care","Friends Forever Home Agency"]
["Les Compagnons des Franc Loisirs","Garderie Soleil La- Main Site",10,15,48,52,60,0]
["Les Compagnons des Franc Loisirs","Garderie Rayons de Soleil-Ecole Ste. Anne",6,15,0,0,18,0]
["Les Compagnons des Franc Loisirs","Garderie Tournesol-Ecole St. Raymond",6,0,24,20,15,0]
["Les Compagnons des Franc Loisirs","Garderie Beausoleil-Ecole Lorrain",0,0,0,0,0,15]
["Les Compagnons des Franc Loisirs","Garderie Le Petit Dragon - Ecole Odyssée",10,0,24,0,30,0]
["Les Compagnons des Franc Loisirs","Garderie Dragon d'or - Ecole Heritage",0,0,0,26,60,0]
["Les Compagnons des Franc Loisirs","Garderie Sol La-Ecole St. Thomas d'Aquin",6,0,24,0,30,0]
["Les Compagnons des Franc Loisirs","Garderie la Place ensoleillee-St. Vincent",6,0,20,0,30,0]
["Community Resource Centre (Killaloe) Inc","Kidz Kastle",0,0,0,0,15,15]
["KIND Forest School","KIND Forest School",0,0,0,13,13,0]
["The Lindsay Weld Centre for Children","Kids Crew - St. Alexander",0,0,0,20,24,0]
["The Lindsay Weld Centre for Children","Lindsay Weld Centre for Children - Main",6,15,24,0,0,0]
["The Lindsay Weld Centre for Children","Kids' Club- St. Lukes",0,0,0,0,60,0]
["The Lindsay Weld Centre for Children","Kids Campus - Holy Cross",0,0,0,0,30,0]
["The Lindsay Weld Centre for Children","Kids Corner - Mother St. Bride"]
["The Lindsay Weld Centre for Children","Kids Connection- St. Huberts",0,0,0,0,30,0]
["NORTH BAY MILITARY FAMILY RESOURCE CENTRE","Little Wings Child Care Center",3,15,24,0,45,0]
["Mattawa Child Care Centre","Mattawa Child Care Centre",6,15,16,0,24,0]
["Montessori Children's House (2685594 Ltd)","Montessori Children's House",0,10,24,13,0,0]
["Montessori Learning Centre","Montessori Learning Centre",0,10,33,0,0,0]
["1168108 Ontario Inc. O/A North Bay Daycare Centre","NBDC - Main",0,10,19,10,0,0]
["1168108 Ontario Inc. O/A North Bay Daycare Centre","NBDC - School Age Program",0,0,0,0,60,0]
["North Bay Indigenous Hub","North Bay Indigenous Hub",10,15,32,0,30,0]
["Garderie de Temagami Day Care","Garderie de Temagami Day Care",0,0,0,0,15,15]
["West Ferris Day Nursery Inc.","West Ferris Day Nursery - Main",6,10,16,0,0,0]
["West Ferris Day Nursery Inc.","West Ferris SA Learning Ctr. Sunset Park",0,0,0,26,60,0]
["West Ferris Day Nursery Inc.","Ferris Glen Learning Centre-Ferris Glen",0,0,16,13,30,0]
["West Ferris Day Nursery Inc.","Silver Birches Child Care-Silver Birches",6,10,38,26,90,0]
["West Nipissing Child Care Corporation","Service de garde Ecole Christ- Roi"]
["West Nipissing Child Care Corporation","La Ruche des Petites Abeilles-Margueritt D'Youville",0,0,19,0,30,0]
["West Nipissing Child Care Corporation","White Woods After School Program",0,0,0,0,30,0]
["West Nipissing Child Care Corporation","La Niche des Lionceaux- Résurrection",6,15,38,20,30,0]
["West Nipissing Child Care Corporation","Service de Garde des Louveteaux-St. Joseph",0,15,24,26,30,0]
["West Nipissing Child Care Corporation","La Tanière des Tout-Petits-Jeunesse Active",10,30,48,26,30,0]
["West Nipissing Child Care Corporation","Centre Base",16,15,48,0,30,0]
["West Nipissing Child Care Corporation","Home Child Care"]
["YMCA of North Bay & District","Mother St. Bride Early Learning Child Care Centre",10,15,24,0,30,0]
["YMCA of North Bay & District","Our Lady of Sorrows Early Learning CCC",0,0,0,0,30,15]
["YMCA of North Bay & District","E.T. Carmicheal School Age Program",0,0,0,48,24,0]
["YMCA of North Bay & District","Vincent Massey School Age Program",0,0,0,26,28,0]
["YMCA of North Bay & District","Alliance School Age Program",0,0,0,26,81,0]
["YMCA of North Bay & District","Woodland Early Learning Child Care Centre",10,15,32,104,60,0]
["YMCA of North Bay & District","Chippewa Early Learning Child Care Centre",10,25,64,24,60,0]
["YMCA of North Bay & District","EW Norman Early Learning Child Care Centre",0,0,20,0,30,0]
["YMCA of North Bay & District","Our Lady of Fatima-Early Learning CCC",0,15,24,0,56,0]
["YMCA of North Bay & District","St. Francis Early Learning Child Care Centre",10,15,48,26,50,0]
["YMCA of North Bay & District","Home Child Care"]