{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["service","service(2)","Wastewater","Water","Drainage and Flood Protection","Transportation","Fire Protection","Parks and Recreation","Solid Waste","Civic Facilities"],"not_rendered":{"charts":2,"images":13,"macros":1,"external_links":0,"defined_names":4,"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":"service","index":0,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"CURRENT PERFORMANCE",null,"PREPAREDNESS FOR THE FUTURE",null,null,"OVERALL SUSTAINABILITY",null,"TREND"]
[null,null,"Water"]
[null,null,"Wastewater"]
[null,null,"Drainage and Flood Protection"]
[null,null,"Parks and Recreation"]
[null,null,"Civic Facilities"]
[null,null,"Transportation"]
[null,null,"Fire Protection"]
[null,null,"Solid Waste"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Value","Max"]
[null,0,100]
[]
[null,"Graph",null,0,0]
[null,180,null,{"$f":"SIN(((((B22+C22)*180/C22)+90))*PI()/180)","v":-1},{"$f":"COS(((((B22+C22)*180/C22)+90))*PI()/180)","v":-1.83772268236293E-16}]
[null,180,0,0,0]
[null,45,1]
[null,45,2]
[null,45,3]
[null,null,"n/a"]

{"sheet":"service(2)","index":1,"n_rows":36,"n_cols":35,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Water","Current Performance","Preparedness For The Future",null,null,"Parks & Recreation","Current Performance","Preparedness For The Future"]
[null,null,"Service Delivery",null,null,null,null,"Service Delivery"]
[]
[null,null,"Finance",null,null,null,null,"Finance"]
[]
[null,null,"Governance",null,null,null,null,"Governance"]
[]
[null,null,null,{"$f":"IF(SUM(D3,D5,D7) <> 0,AVERAGE(D7,D5,D3),0)","v":0},{"$f":"IF(SUM(E3,E5,E7) <> 0,AVERAGE(E7,E5,E3),0)","v":0},null,null,null,{"$f":"IF(SUM(I3,I5,I7) <> 0, AVERAGE(I7,I5,I3),0)","v":0},{"$f":"IF(SUM(J3,J5,J7) <> 0,AVERAGE(J7,J5,J3),0)","v":0}]
[]
[null,null,"Wastewater","Current Performance","Preparedness For The Future",null,null,"Civic Facilities","Current Performance","Preparedness For The Future"]
[null,null,"Service Delivery",null,null,null,null,"Service Delivery"]
[]
[null,null,"Finance",null,null,null,null,"Finance"]
[]
[null,null,"Governance",null,null,null,null,"Governance"]
[]
[null,null,null,{"$f":"IF(SUM(D12,D14,D16) <> 0,AVERAGE(D16,D14,D12),0)","v":0},{"$f":"IF(SUM(E12,E14,E16) <> 0,AVERAGE(E16,E14,E12),0)","v":0},null,null,null,{"$f":"IF(SUM(I12,I14,I16) <> 0,AVERAGE(I16,I14,I12),0)","v":0},{"$f":"IF(SUM(J12,J14,J16) <> 0,AVERAGE(J16,J14,J12),0)","v":0}]
[]
[null,null,"Drainage and Flood Protection","Current Performance","Preparedness For The Future",null,null,"Transportation","Current Performance","Preparedness For The Future"]
[null,null,"Service Delivery",null,null,null,null,"Service Delivery"]
[]
[null,null,"Finance",null,null,null,null,"Finance"]
[]
[null,null,"Governance",null,null,null,null,"Governance"]
[]
[null,null,null,{"$f":"IF(SUM(D21,D23,D25) <> 0, AVERAGE(D25,D23,D21),0)","v":0},{"$f":"IF(SUM(E21,E23,E25) <> 0,AVERAGE(E25,E23,E21),0)","v":0},null,null,null,{"$f":"IF(SUM(I21,I23,I25) <> 0, AVERAGE(I25,I23,I21),0)","v":0},{"$f":"IF(SUM(J21,J23,J25) <> 0,AVERAGE(J25,J23,J21),0)","v":0}]
[]
[null,null,"Fire Protection","Current Performance","Preparedness For The Future",null,null,"Solid Waste","Current Performance","Preparedness For The Future"]
[null,null,"Service Delivery",null,null,null,null,"Service Delivery"]
[]
[null,null,"Finance",null,null,null,null,"Finance"]
[]
[null,null,"Governance",null,null,null,null,"Governance"]
[]
[null,null,null,{"$f":"IF(SUM(D30,D32,D34) <> 0,AVERAGE(D34,D32,D30),0)","v":0},{"$f":"IF(SUM(E30,E32,E34) <> 0,AVERAGE(E34,E32,E30),0)","v":0},null,null,null,{"$f":"IF(SUM(I30,I32,I34) <> 0,AVERAGE(I34,I32,I30),0)","v":0},{"$f":"IF(SUM(J30,J32,J34) <> 0,AVERAGE(J34,J32,J30),0)","v":0}]

{"sheet":"Wastewater","index":2,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,0,31,0],[15,5,15,6],[2,0,7,0],[9,0,10,0],[12,0,14,0],[20,0,26,0]]}
["CURRENT PERFORMANCE",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","Capacity","Treatment plant is operating at >90% on one or more design parameters.","Treatment plant is operating at 80-90% on one or more design parameters.","Treatment plant is operating at 65-79% on one or more design parameters.","Treatment plant is operating at <65% on all design parameters. "]
[null,"Effluent Quality","Continual exceedances of Federal or Provincial regulatory requirements. ","Intermittent exceedances of Federal or Provincial regulatory requirements. ","No exceedances of Federal and Provincial regulatory requirements. ","Surpasses Federal and Provincial regulatory requirements. "]
[null,"Reliability","Frequent major disruptions (>24hrs) to service provision to a large number of customers (>10% of connected users).","Frequent minor disruptions (<4hrs) to service provision, but few major disruptions.","Some minor disruptions to service provision, but few major disruptions.","Few minor disruptions to service provision, and no major disruptions."]
[null,"Accessibility/availability","Large areas of the community do not have the opportunity to connect to the public wastewater service (but want/need to).","Some areas of the community do not have the opportunity to connect to the public wastewater service (but want/need to).","Nearly all areas of the community have public wastewater service.","All residents who want/need public wastewater service are connected to the service."]
[null,"Asset condition","<20% of sanitary system (by replacement value) in fair condition or better.","20-49% of sanitary system (by replacement value) in fair condition or better.","50-99% of sanitary system (by replacement value) in fair condition or better.","100% of sanitary system (by replacement value) in fair condition or better."]
[null,"GHG Emissions","No reductions in GHG emissions (compared to baseline). ","Minimal reductions in GHG emissions (compared to baseline). ","Moderate reductions in GHG emissions (compared to baseline). ","Significant reductions in GHG emissions (compared to baseline). "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H3:H8)/(18-3*COUNTIF(H3:H8,\"=n/a\"))","v":0},{"$f":"SUM(I3:I8)/(18-3*COUNTIF(I3:I8,\"=n/a\"))","v":0},{"$f":"SUM(J3:J8)/(18-3*COUNTIF(J3:J8,\"=n/a\"))","v":0},{"$f":"SUM(K3:K8)/(18-3*COUNTIF(K3:K8,\"=n/a\"))","v":0},{"$f":"SUM(L3:L8)/(18-3*COUNTIF(L3:L8,\"=n/a\"))","v":0}]
["Finance","Revenue","Revenue is year to year and there is no linkage between revenues and long term requirements. Revenues are not sufficient to meet needs without reliance on grants or subsidies.","Revenue is sufficient and reliable to fund the requirements for the next 5 years, but there is a significant gap between revenues and sustainable funding levels for later years.","Revenue is sufficient and reliable to fund the requirements in the 10 year capital plan, but there is still a gap between revenues and sustainable funding levels for the long term. ","Revenues are sufficient, predictable, and stable to fund long term sustainable service delivery in alignment with the long term financial plan and the asset replacement plan."]
[null,"Reserves","No reserves are in place.","Minimal reserves are in place that can buffer short term fluctuations in revenue (e.g. 6 weeks operating expenses).","Reserves are in place to buffer short term revenue fluctuations. There are dedicated reserves for future capital renewal, but do not meet the levels required as identified in the financial plan.","Reserves are held at levels established in accordance with the financial plan in order to meet long term requirements."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H10:H11)/(6-3*COUNTIF(H10:H11,\"=n/a\"))","v":0},{"$f":"SUM(I10:I11)/(6-3*COUNTIF(I10:I11,\"=n/a\"))","v":0},{"$f":"SUM(J10:J11)/(6-3*COUNTIF(J10:J11,\"=n/a\"))","v":0},{"$f":"SUM(K10:K11)/(6-3*COUNTIF(K10:K11,\"=n/a\"))","v":0},{"$f":"SUM(L10:L11)/(6-3*COUNTIF(L10:L11,\"=n/a\"))","v":0}]
["Governance","Decision-making (Council and staff)","Decisions about wastewater services are made on an ad-hoc basis, typically consider only short-term impacts, and are not properly informed. ","Decisions about wastewater services consider both short and long-term impacts, but are informed by incomplete or anecdotal information.","Decisions about wastewater services consider both short and long-term impacts and are informed by appropriate information.","Decisions about wastewater services are formalized and consistent– they consider both short and long-term impacts, are based on appropriate information, and reflect community priorities."]
[null,"Public communications and engagement","Citizen engagement is not considered at all. (Note: If your community considers community engagement and decides it is not warranted, then score 1, 2, or 3 as appropriate.)","Citizen engagement (when required) is ad hoc for wastewater service delivery.","Deliberate, well-planned citizen engagement occurs only for major wastewater infrastructure projects that require citizen engagement– little consideration of citizen engagement outside of major infrastructure projects.","Citizens are engaged as per formal communications and engagement plans for all wastewater service delivery matters that require citizen engagement."]
[null,"Customer satisfaction","Frequent customer complaints about significant wastewater service issues.","Frequent customer complaints about minor wastewater service issues.","Few customer complaints about wastewater service issues - most pertain to minor issues.","Almost no customer complaints about wastewater service."]
[null,null,null,null,null,"Governance Percentage",null,{"$f":"SUM(H13:H15)/(9-3*COUNTIF(H13:H15,\"=n/a\"))","v":0},{"$f":"SUM(I13:I15)/(9-3*COUNTIF(I13:I15,\"=n/a\"))","v":0},{"$f":"SUM(J13:J15)/(9-3*COUNTIF(J13:J15,\"=n/a\"))","v":0},{"$f":"SUM(K13:K15)/(9-3*COUNTIF(K13:K15,\"=n/a\"))","v":0},{"$f":"SUM(L13:L15)/(9-3*COUNTIF(L13:L15,\"=n/a\"))","v":0}]
[null,null,null,null,null,null,"Current Performance - Overall Percentage",{"$f":"AVERAGE(H16,H12,H9)","v":0},{"$f":"AVERAGE(I16,I12,I9)","v":0},{"$f":"AVERAGE(J16,J12,J9)","v":0},{"$f":"AVERAGE(K16,K12,K9)","v":0},{"$f":"AVERAGE(L16,L12,L9)","v":0}]
[]
["PREPAREDNESS FOR FUTURE SERVICE PROVISION",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","What measures have been taken to ensure future treatment capacity?","None.","At least one of the following (or equivalent) is in place: \n• I/I reduction program\n• sewer separation program (if applicable)\n• water conservation programs\n• wastewater master plan\n• LWMP\n• Emergency preparedness plan","All of the following (or equivalent) are in place, but funding is insufficient for implementation:\n• I/I reduction program\n• sewer separation program (if applicable)\n• water conservation programs\n• wastewater master plan\n• LWMP\n• Emergency preparedness plan","All of the following (or equivalent) are in place and funding is sufficient for implementation: \n• I/I reduction program\n• sewer separation program (if applicable)\n• water conservation programs\n• wastewater master plan\n• LWMP\n• Emergency preparedness plan\n"]
[null,"What measures have been taken to ensure effluent quality?","None.","An ad-hoc sampling program is in place; however, results are not used to inform long range plans for  WWTP improvements. ","A formal sampling program is in place; however, results are not used to inform long range plans for WWTP improvements. ","A formal sampling program is in place and results are used to inform long range plans for WWTP improvements. "]
[null,"What measures have been taken to ensure service reliability?","None. ","Ad hoc preventative maintenance program in place. No consideration of climate change impacts on design standards or O&M practices. ","Formal preventative maintenance program in place.  Climate change impacts have been considered in design standards and O&M practices.  However, funding is insufficient to fully implement the program.    ","Formal preventative maintenance program in place.  Climate change impacts have been considered in design standards and O&M practices.  Funding is sufficient to fully implement the program.    "]
[null,"What measures have been taken to improve asset condition?","None.","An asset management program is in place for some major wastewater assets, but not based on actual condition data (CCTV inspection or other).","An asset management program is in place for most major wastewater assets, but minimal actual condition data (CCTV inspection or other) available.","An asset management program is in place for all major wastewater assets, and based on actual condition data (CCTV inspection or other) where possible."]
[null,"What measures have been taken to ensure future accessibility/availability?","None.","A wastewater master plan (or other suitable plan/policy document) is in place, but needs to be updated. ","Up-to-date wastewater master plan (or other suitable plan/policy document) is in place, but funding not sufficient to fully implement plan.","Up-to-date wastewater master plan (or other suitable plan/policy document) is in place, and funding sufficient to fully implement plan."]
[null,"What measures have been taken to ensure future human resource needs are filled?","None.","Ad-hoc succession and training planning in place.","Formal succession and training plans in place, but without sufficient funding.","Formal succession and training plans in place, and fully funded. "]
[null,"What measures have been taken to ensure future service provision minimizes GHG production? ","None.","Ad-hoc GHG reduction planning in place. ","Formal GHG reduction plans in place, but without sufficient funding. ","Formal GHG reduction plans in place, and fully funded. "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H21:H27)/(21-3*COUNTIF(H21:H27,\"=n/a\"))","v":0},{"$f":"SUM(I21:I27)/(21-3*COUNTIF(I21:I27,\"=n/a\"))","v":0},{"$f":"SUM(J21:J27)/(21-3*COUNTIF(J21:J27,\"=n/a\"))","v":0},{"$f":"SUM(K21:K27)/(21-3*COUNTIF(K21:K27,\"=n/a\"))","v":0},{"$f":"SUM(L21:L27)/(21-3*COUNTIF(L21:L27,\"=n/a\"))","v":0}]
["Finance","What measures have been taken to ensure adequate future revenues?","None.","A financial plan is in place but it covers <10 years or does not reflect the future costs of replacing existing assets.","A long term (10+ years) financial plan is in place that reflects the revenue required and funding sources to fund new assets and asset replacements, but the plan is not being followed or updated.","A comprehensive long term financial plan exists and is based on up to date information. The plan looks forward 10 years or more and is integrated with long term capital plan. The plan is being tracked and followed."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"H29/(3-3*COUNTIF(H29,\"=n/a\"))","v":0},{"$f":"I29/(3-3*COUNTIF(I29,\"=n/a\"))","v":0},{"$f":"J29/(3-3*COUNTIF(J29,\"=n/a\"))","v":0},{"$f":"K29/(3-3*COUNTIF(K29,\"=n/a\"))","v":0},{"$f":"L29/(3-3*COUNTIF(L29,\"=n/a\"))","v":0}]
["Governance","What measures have been taken to improve decision-making?","None.","Limited, ad-hoc attempts to improve the consistency and clarity re: decision-making; however, no organization-wide uptake. ","Policies in place to guide decision-making at the administrative level, but not at the Council level.","Policies are in place to guide decision-making at both the Council and administrative levels."]
[null,"What measures have been taken to improve public communications and engagement?","None.","Incomplete policies in place to guide C&E.","Complete policies are in place requiring departmental C&E plans, but not other materials/guidance available to help departments prepare them. ","Complete policies are in place requiring departmental C&E plans. Standard templates/procedures for developing C&E plans available. "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H31:H32)/(6-3*COUNTIF(H31:H32,\"=n/a\"))","v":0},{"$f":"SUM(I31:I32)/(6-3*COUNTIF(I31:I32,\"=n/a\"))","v":0},{"$f":"SUM(J31:J32)/(6-3*COUNTIF(J31:J32,\"=n/a\"))","v":0},{"$f":"SUM(K31:K32)/(6-3*COUNTIF(K31:K32,\"=n/a\"))","v":0},{"$f":"SUM(L31:L32)/(6-3*COUNTIF(L31:L32,\"=n/a\"))","v":0}]
[null,null,null,null,null,null,"Future Preparedness - Overall Percentage",{"$f":"AVERAGE(H33,H30,H28)","v":0},{"$f":"AVERAGE(I33,I30,I28)","v":0},{"$f":"AVERAGE(J33,J30,J28)","v":0},{"$f":"AVERAGE(K33,K30,K28)","v":0},{"$f":"AVERAGE(L33,L30,L28)","v":0}]
[]
[null,null,null,null,null,null,"Sustainability Percentage",{"$f":"AVERAGE(H34,H17)","v":0},{"$f":"AVERAGE(I34,I17)","v":0},{"$f":"AVERAGE(J34,J17)","v":0},{"$f":"AVERAGE(K34,K17)","v":0},{"$f":"AVERAGE(L34,L17)","v":0}]

{"sheet":"Water","index":3,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,0,10,0],[2,0,7,0],[15,5,15,6],[36,5,36,6],[37,6,38,7],[20,0,25,0],[30,0,31,0],[12,0,14,0]]}
["CURRENT PERFORMANCE",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","Quantity ","Total ban on outdoor water use occurs almost every summer (due to supply constraints).","Restrictions on outdoor water use occur almost every summer (due to supply constraints).","Water restrictions occur infrequently (due to supply constraints). ","Water restrictions occur rarely (due to supply constraints)."]
[null,"Water Quality - Safety","Boil water advisories occur in most years.","Boil water advisories occur, but infrequently (no more than every 5 years).","Water quality consistently meets Schedule B testing requirement of the DWPR.","Water quality consistently meets Schedule B of DWPR requirements, plus testing  is done for additional identified risk parameters."]
[null,"Water Quality - Aesthetics","Fails to meet customer expectations on more than one of: taste, colour, odour, staining year round.","Fails to meet customer expectations on one of: taste, colour, odour, staining year round.","Fails to meet customer expectations on one or more of: taste, colour, odour, staining, but only seasonally.","Meets customer expectations on all of: taste, colour, odour, staining year round."]
[null,"Reliability","Frequent major disruptions (>24hrs) to service provision to a large number of customers (>10% of connected users).","Frequent minor disruptions (<4hrs) to service provision, but few major disruptions.","Some minor disruptions to service provision, but few major disruptions.","Few minor disruptions to service provision, and no major disruptions."]
[null,"Accessibility/availability","Large areas of the community do not have the opportunity to connect to public water service (but want/need to).","Some areas of the community do not have the opportunity to connect to public water service (but want/need to).","Nearly all areas of the community that want/need public water service have public water service.","All residents who want/need public water service are connected to the service."]
[null,"GHG Emissions (generated by providing the service)","No reductions in GHG emissions (compared to baseline). ","Minimal reductions in GHG emissions (compared to baseline). ","Moderate reductions in GHG emissions (compared to baseline). ","Significant reductions in GHG emissions (compared to baseline). "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H3:H8)/(18-3*COUNTIF(H3:H8,\"=n/a\"))","v":0},{"$f":"SUM(I3:I8)/(18-3*COUNTIF(I3:I8,\"=n/a\"))","v":0},{"$f":"SUM(J3:J8)/(18-3*COUNTIF(J3:J8,\"=n/a\"))","v":0},{"$f":"SUM(K3:K8)/(18-3*COUNTIF(K3:K8,\"=n/a\"))","v":0},{"$f":"SUM(L3:L8)/(18-3*COUNTIF(L3:L8,\"=n/a\"))","v":0}]
["Finance","Revenue","Revenue is year to year and there is no linkage between revenues and long term requirements. Revenues are not sufficient to meet needs without reliance on grants or subsidies.","Revenue is sufficient and reliable to fund the requirements for the next 5 years, but there is a significant gap between revenues and sustainable funding levels for later years.","Revenue is sufficient and reliable to fund the requirements in the 10 year capital plan, but there is still a gap between revenues and sustainable funding levels for the long term. ","Revenues are sufficient, predictable, and stable to fund long term sustainable service delivery in alignment with the long term financial plan and the asset replacement plan."]
[null,"Reserves","No reserves are in place.","Minimal reserves are in place that can buffer short term fluctuations in revenue (e.g. 6 weeks operating expenses).","Reserves are in place to buffer short term revenue fluctuations. There are dedicated reserves for future capital renewal, but do not meet the levels required as identified in the financial plan.","Reserves are held at levels established in accordance with the financial plan in order to meet long term requirements."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H10:H11)/(6-3*COUNTIF(H10:H11,\"=n/a\"))","v":0},{"$f":"SUM(I10:I11)/(6-3*COUNTIF(I10:I11,\"=n/a\"))","v":0},{"$f":"SUM(J10:J11)/(6-3*COUNTIF(J10:J11,\"=n/a\"))","v":0},{"$f":"SUM(K10:K11)/(6-3*COUNTIF(K10:K11,\"=n/a\"))","v":0},{"$f":"SUM(L10:L11)/(6-3*COUNTIF(L10:L11,\"=n/a\"))","v":0}]
["Governance","Decision-making (Council and staff)","Decisions about water services are made on an ad-hoc basis, typically consider only short-term impacts, and are not properly informed. Decisions are inconsistent.","Decisions about water services consider both short and long-term impacts, but are informed by incomplete or anecdotal information.","Decisions about water services consider both short and long-term impacts and are informed by appropriate information.","Decisions about water services are formalized and consistent– they consider both short and long-term impacts, are based on appropriate information, and reflect community priorities."," "]
[null,"Public communications and engagement","Citizen engagement is not considered at all. (Note: If your community considers community engagement and decides it is not warranted, then score 1, 2, or 3 as appropriate.)","Citizen engagement (when required) is ad hoc for water service delivery.","Deliberate, well-planned citizen engagement occurs only for major water infrastructure projects that require citizen engagement– little consideration of citizen engagement outside of major infrastructure projects.","Citizens are engaged as per formal communications and engagement plans for all water service delivery matters that require citizen engagement."," "]
[null,"Customer satisfaction","Frequent customer complaints about significant water service issues.","Frequent customer complaints about minor water service issues.","Few customer complaints about water service issues - most pertain to minor issues.","Almost no customer complaints about water service."]
[null,null,null,null,null,"Governance Percentage",null,{"$f":"SUM(H13:H15)/(9-3*COUNTIF(H13:H15,\"=n/a\"))","v":0},{"$f":"SUM(I13:I15)/(9-3*COUNTIF(I13:I15,\"=n/a\"))","v":0},{"$f":"SUM(J13:J15)/(9-3*COUNTIF(J13:J15,\"=n/a\"))","v":0},{"$f":"SUM(K13:K15)/(9-3*COUNTIF(K13:K15,\"=n/a\"))","v":0},{"$f":"SUM(L13:L15)/(9-3*COUNTIF(L13:L15,\"=n/a\"))","v":0}]
[null,null,null,null,null,null,"Current Performance - Overall Percentage",{"$f":"AVERAGE(H16,H12,H9)","v":0},{"$f":"AVERAGE(I16,I12,I9)","v":0},{"$f":"AVERAGE(J16,J12,J9)","v":0},{"$f":"AVERAGE(K16,K12,K9)","v":0},{"$f":"AVERAGE(L16,L12,L9)","v":0}]
[]
["PREPAREDNESS FOR FUTURE SERVICE PROVISION",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","What measures have been taken to ensure future water quality?","None.","At least one of the following (or equivalent) is in place: \n• source protection plan\n• cross connection control program\n• WTP improvement plan\n• sampling program\n• emergency response plan\n","All of the following (or equivalent) are in place, but funding is insufficient  for implementation: \n• source protection plan\n• cross connection control program\n• WTP improvement plans\n• sampling program\n• emergency response plan\n\n","All of the following (or equivalent) are in place and funding is sufficent for implementation: \n• source protection plan\n• cross connection control program\n• WTP improvement plans\n• sampling program\n• emergency response plan\n\n"]
[null,"What measures have been taken to ensure future water quantity?","None. ","At least one of the following (or equivalent) is in place: \n• drought protection plan\n• water conservation plan\n• master water plan\n• climate change adaptation plan\n\n","All of the following (or equivalent) are in place, but funding is insufficient for implementation: \n• drought protection plan\n• water conservation plan\n• master water plan\n• climate change adaptation plan\n\n","All of the following (or equivalent) are in place and funding is sufficient for implementation: \n• drought protection plan\n• water conservation plan\n• master water plan\n• climate change adaptation plan\n\n"]
[null,"What measures have been taken to improve asset condition?","None.","An asset management program is in place for some major water assets, but not based on actual condition data (break history or other).","An asset management program is in place for most major water assets, but minimal actual condition data (break history or other) available.","An asset management program is in place for all major water assets, and based on actual condition data (break history or other) where possible."]
[null,"What measures have been taken to ensure future accessibility/availability?","None.","A master water plan (or other suitable plan/policy document) is in place, but needs to be updated. ","Up-to-date master water plan (or other suitable plan/policy document) in place, but funding not sufficient to fully implement plan.","Up-to-date master water plan (or other suitable plan/policy document) in place, and funding sufficient to fully implement plan."]
[null,"What measures have been taken to ensure service reliability?","None.","Ad hoc preventative maintenance program in place.  No consideration of climate change impacts on design standards or O&M practices.","Formal preventative maintenance program in place. Climate change impacts have been considered in design standards and O&M practices.  However, funding is insufficient to fully implement the program.    ","Formal preventative maintenance program in place. Climate change impacts have been considered in design standards and O&M practices. Funding is sufficient to fully implement the program.    "]
[null,"What measures have been taken to ensure future human resource needs are filled?","None.","Ad-hoc succession and training planning in place.","Formal succession and training plans in place, but without sufficient funding.","Formal succession and training plans in place, and fully funded. "]
[null,"What measures have been taken to ensure future service provision minimizes GHG production? ","None.","Ad-hoc GHG reduction planning in place. ","Formal GHG reduction plans in place, but without sufficient funding. ","Formal GHG reduction plans in place, and fully funded. "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H21:H27)/(21-3*COUNTIF(H21:H27,\"=n/a\"))","v":0},{"$f":"SUM(I21:I27)/(21-3*COUNTIF(I21:I27,\"=n/a\"))","v":0},{"$f":"SUM(J21:J27)/(21-3*COUNTIF(J21:J27,\"=n/a\"))","v":0},{"$f":"SUM(K21:K27)/(21-3*COUNTIF(K21:K27,\"=n/a\"))","v":0},{"$f":"SUM(L21:L27)/(21-3*COUNTIF(L21:L27,\"=n/a\"))","v":0}]
["Finance","What measures have been taken to ensure adequate future revenues?","None.","A financial plan is in place but it covers <10 years or does not reflect the future costs of replacing existing assets.","A long term (10+ years) financial plan is in place that reflects the revenue required and funding sources to fund new assets and asset replacements, but the plan is not being followed or updated.","A comprehensive long term financial plan exists and is based on up to date information. The plan looks forward 10 years or more and is integrated with the  long term capital plan. The plan is being tracked and followed."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"H29/(3-3*COUNTIF(H29,\"=n/a\"))","v":0},{"$f":"I29/(3-3*COUNTIF(I29,\"=n/a\"))","v":0},{"$f":"J29/(3-3*COUNTIF(J29,\"=n/a\"))","v":0},{"$f":"K29/(3-3*COUNTIF(K29,\"=n/a\"))","v":0},{"$f":"L29/(3-3*COUNTIF(L29,\"=n/a\"))","v":0}]
["Governance","What measures have been taken to improve decision-making?","None.","Limited, ad-hoc attempts to improve the consistency and clarity re: decision-making; however, no organization-wide uptake. ","Policies in place to guide decision-making at the administrative level, but not at the Council level.","Policies are in place to guide decision-making at both the Council and administrative levels."]
[null,"What measures have been taken to improve public communications and engagement?","None.","Incomplete policies in place to guide C&E.","Complete policies in place requiring departmental C&E plans, but not other materials/guidance available to help departments prepare them. ","Complete policies are in place requiring departmental C&E plans. Standard templates/procedures for developing C&E plans available. "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H31:H32)/(6-3*COUNTIF(H31:H32,\"=n/a\"))","v":0},{"$f":"SUM(I31:I32)/(6-3*COUNTIF(I31:I32,\"=n/a\"))","v":0},{"$f":"SUM(J31:J32)/(6-3*COUNTIF(J31:J32,\"=n/a\"))","v":0},{"$f":"SUM(K31:K32)/(6-3*COUNTIF(K31:K32,\"=n/a\"))","v":0},{"$f":"SUM(L31:L32)/(6-3*COUNTIF(L31:L32,\"=n/a\"))","v":0}]
[null,null,null,null,null,null,"Future Preparedness - Overall Percentage",{"$f":"AVERAGE(H33,H30,H28)","v":0},{"$f":"AVERAGE(I33,I30,I28)","v":0},{"$f":"AVERAGE(J33,J30,J28)","v":0},{"$f":"AVERAGE(K33,K30,K28)","v":0},{"$f":"AVERAGE(L33,L30,L28)","v":0}]
[]
[null,null,null,null,null,null,"Sustainability Percentage",{"$f":"AVERAGE(H34,H17)","v":0},{"$f":"AVERAGE(I34,I17)","v":0},0,0,0]

{"sheet":"Drainage and Flood Protection","index":4,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[13,1,13,2]]}
["CURRENT PERFORMANCE",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery"]
[null,"Drainage"]
[null,"System Capacity","System is significantly undersized in most areas of the community to meet desired LoS.","System is significantly undersized in some areas of the community to meet desired LoS. ","System is moderately undersized in some areas of the community to meet desired LoS. ","System is sized appropriately to meet desired LoS in all areas of the community. Any flooding that occurs is intentional and/or part of an overall drainage plan (e.g. riparian flooding in a park)."]
[null,"Runoff Quality ","Facilities for rainwater water quality treatment are non-existent. Rainwater is essentially discharged with no treatment or regard for environmental impacts.","Facilities for rainwater exist, but are seriously limited in size/scope and/or in disrepair. ","Rainwater is managed to satisfy Provincial stormwater management guidelines as well as provisions of the Fisheries Act.","Local rainwater management yields discharges that exceed Provincial and Federal guidelines and provisions."]
[null,"Reliability ","Flooding due to overflow and/or backup is frequent and signficant (i.e. sufficient to potentially harm residents, damage property and/or limit access to critical community services such as hospitals, police, fire, etc).","Flooding due to overflow and/or backup is frequent but not signficant (i.e. no harm to residents, no damage to property and/or limit access to critical community services such as hospitals, police, fire, etc).","Flooding due to overflow and/or backup is infrequent and not signficant (i.e. no harm to residents, no damage to property and/or limit access to critical community services such as hospitals, police, fire, etc).","Flooding due to overflow and/or backup rarely occurs. "]
[null,"Availability","Large areas of the community do not have the opportunity to connect to or benefit from the service (but want/need to).","Some areas of the community do not have the opportunity to connect to the service (but want/need to).","Nearly all areas of the community are connected to and benefit from the service.","All residents and properties are connected to and benefit from the service."]
[null,"Asset condition","<20% of stormwater system (by replacement value) in fair condition or better. ","20-49% of stormwater system (by replacement value) in fair condition or better.","50-99% of stormwater system (by replacement value) in fair condition or better.","100% of stormwater system (by replacement value) in fair condition or better."]
[null,"Flood Protection"]
[null,"Level of Flood Protection","Many areas and/or critical services are exposed to significant flood risk, but do not have adequate flood protection.  ","All critical areas of the community have adequate flood protection, but some other areas of the community exposed to significant flood risk do not have adequate flood protection. ","Nearly all areas of the community exposed to significant flood risk have adequate flood protection.  ","All areas of the community exposed to significant flood risk have adequate flood protection.  "]
[null,"Reliability","Frequent failure of significant flood protection infrastructure. ","Several instances of failure of minor flood protection infrastructure; very few instances of failure of significant flood protection infrastructure.  ","Few instances of failure of minor flood protection infrastructure; rarely any instances of failure of significant flood protection infrastructure.  ","Flood protection infrastructure rarely fails."]
[null,"Asset condition","<20% of the flood protection system (by replacement value) in fair condition or better. ","20-49% of flood protection system (by replacement value) in fair condition or better.","50-99% of flood protection system (by replacement value) in fair condition or better.","100% of flood protection system (by replacement value) in fair condition or better."]
[null,"GHG Emissions (generated by providing both drainage and flood protection services)"]
[null,"Reduction Efforts","No reductions in GHG emissions (compared to baseline). ","Minimal reductions in GHG emissions (compared to baseline). ","Moderate reductions in GHG emissions (compared to baseline). ","Significant reductions in GHG emissions (compared to baseline). "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H5:H15)/(27-3*COUNTIF(H5:H15,\"=n/a\"))","v":0},{"$f":"SUM(I5:I15)/(27-3*COUNTIF(I5:I15,\"=n/a\"))","v":0},0,0,0]
["Finance","Revenue","Revenue is year to year and there is no linkage between revenues and long term requirements. Revenues are not sufficient to meet needs without reliance on grants or subsidies.","Revenue is sufficient and reliable to fund the requirements for the next 5 years, but there is a significant gap between revenues and sustainable funding levels for later years.","Revenue is sufficient and reliable to fund the requirements in the 10 year capital plan, but there is still a gap between revenues and sustainable funding levels for the long term. ","Revenues are sufficient, predictable, and stable to fund long term sustainable service delivery in alignment with the long term financial plan and the asset replacement plan."]
[null,"Reserves","No reserves are in place.","Minimal reserves are in place that can buffer short term fluctuations in revenue (e.g. 6 weeks operating expenses).","Reserves are in place to buffer short term revenue fluctuations. There are dedicated reserves for future capital renewal, but do not meet the levels required as identified in the financial plan.","Reserves are held at levels established in accordance with the financial plan in order to meet long term requirements."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H17:H18)/(6-3*COUNTIF(H17:H18,\"=n/a\"))","v":0},{"$f":"SUM(I17:I18)/(6-3*COUNTIF(I17:I18,\"=n/a\"))","v":0},0,0,0]
["Governance","Decision-making (Council and staff)","Decisions about drainage/flood protection services are made on an ad-hoc basis, typically consider only short-term impacts, and are not properly informed. ","Decisions about drainage/flood protection services consider both short and long-term impacts, but are informed by incomplete or anecdotal information.","Decisions about drainage/flood protection services consider both short and long-term impacts and are informed by appropriate information.","Decisions about drainage/flood protection services are formalized and consistent– they consider both short and long-term impacts, are based on appropriate information, and reflect community priorities."]
[null,"Public communications and engagement","Citizen engagement is not considered at all. (Note: If your community considers community engagement and decides it is not warranted, then score 1, 2, or 3 as appropriate.)","Citizen engagement (when required) is ad hoc for drainage/flood protection.","Deliberate, well-planned citizen engagement occurs only for major drainage/flood protection infrastructure projects that require citizen engagement– little consideration of citizen engagement outside of major infrastructure projects.","Citizens are engaged as per formal communications and engagement plans for all drainage/flood protection matters that require citizen engagement."]
[null,"Customer satisfaction","Frequent customer complaints about significant drainage/flood protection service issues.","Frequent customer complaints about minor drainage/flood protection service issues.","Few customer complaints about drainage/flood protection service issues - most pertain to minor issues.","Almost no customer complaints about drainage/flood protection service."]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H20:H22)/(9-3*COUNTIF(H20:H22,\"=n/a\"))","v":0},{"$f":"SUM(I20:I22)/(9-3*COUNTIF(I20:I22,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Current Performance - Overall Percentage",{"$f":"AVERAGE(H23,H19,H16)","v":0},{"$f":"AVERAGE(I23,I19,I16)","v":0},{"$f":"AVERAGE(J23,J19,J16)","v":0},{"$f":"AVERAGE(K23,K19,K16)","v":0},{"$f":"AVERAGE(L23,L19,L16)","v":0}]
[]
["PREPAREDNESS FOR FUTURE SERVICE PROVISION",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","What measures have been taken to ensure runoff quality? ","None.","At least one of the following is in place: \n• sewer separation program (if applicable)\n• BMP requirements\n• regulations re: runoff - oil and grit               • separators - monitoring program\n• street sweeping programs\n","All of the following are in place, but funding is insufficient for implementation: \n• sewer separation program (if applicable)\n• BMP requirements\n• regulations re: runoff - oil and grit          • separators - monitoring program\n• street sweeping programs\n\n","All of the following are in place and funding is sufficient for implementation: \n• sewer separation program (if applicable)\n• BMP requirements\n• regulations re: runoff - oil and grit   \n• separators - monitoring program\n• street sweeping programs\n\n"]
[null,"What measures have been taken to ensure future capacity of the drainage system?","None.","At least one of the following (or equivalent) is in place: \n• BMPs\n• limits to impervious area\n• tree protection\n• ISMP\n• master drainage plan\n","All of the following (or equivalent) are in place, but funding is insufficient for implementation: \n• BMPs\n• limits to impervious area\n• tree protection\n• ISMP\n• master drainage plan\n\n","All of the following (or equivalent) are in place and funding is sufficient for implementation: \n• BMPs\n• limits to impervious area\n• tree protection\n• ISMP\n• master drainage plan\n\n"]
[null,"What measures have been taken to mitigate future flood risks?","None.","A flood management plan is in place, but needs to be updated. ","An up-to-date flood management plan is in place, but funding is not sufficient to fully implement the plan. ","An up-to-date flood management plan is in place, and funding is sufficient to fully implement the plan. "]
[null,"What measures have been taken to improve asset condition?","None.","An asset management program is in place for some major drainage/flood protection assets, but not based on actual condition data (CCTV inspection or other).","An asset management program is in place for most major drainage/flood protection assets, but based on minimal actual condition data (CCTV inspection or other).","An asset management program is in place for all major drainage/flood protection assets, and based on actual condition data (CCTV inspection or other) where possible."]
[null,"What measures have been taken to ensure service reliability?","None.","Ad hoc preventative maintenance program in place. No consideration of climate change impacts on design standards or O&M practices.","Formal preventative maintenance program in place. Climate change impacts have been considered in design standards and O&M practices.  However, funding is insufficient to fully implement the program.    ","Formal preventative maintenance program in place. Climate change impacts have been considered in design standards and O&M practices. Funding is sufficient to fully implement the program.    "]
[null,"What measures have been taken to ensure future accessibility/availability (re: drainage system)?","None.","A master drainage plan (or other suitable plan/policy document) is in place, but needs to be updated. ","Up-to-date master drainage plan (or other suitable plan/policy document) in place, but funding not sufficient to fully implement plan.","Up-to-date master drainage plan (or other suitable plan/policy document) in place and funding sufficient to fully implement plan."]
[null,"What measures have been taken to ensure future human resource needs are filled?","None.","Ad-hoc succession and training planning in place.","Formal succession and training plans in place, but without sufficient funding.","Formal succession and training plans in place, and fully funded. "]
[null,"What measures have been taken to ensure future service provision minimizes GHG production? ","None.","Ad-hoc GHG reduction planning in place. ","Formal GHG reduction plans in place, but without sufficient funding. ","Formal GHG reduction plans in place, and fully funded. "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H28:H35)/(24-3*COUNTIF(H28:H35,\"=n/a\"))","v":0},{"$f":"SUM(I28:I35)/(24-3*COUNTIF(I28:I35,\"=n/a\"))","v":0},0,0,0]
["Finance","What measures have been taken to ensure adequate future revenues?","None.","A financial plan is in place but it covers <10 years or does not reflect the future costs of replacing existing assets.","A long term (10+ years) financial plan is in place that reflects the revenue required and funding sources to fund new assets and asset replacements, but the plan is not being followed or updated.","A comprehensive long term financial plan exists and is based on up to date information. The plan looks forward 10 years or more and is integrated with the long term capital plan. The plan is being tracked and followed."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"H37/(3-3*COUNTIF(H37,\"=n/a\"))","v":0},{"$f":"I37/(3-3*COUNTIF(I37,\"=n/a\"))","v":0},0,0,0]
["Governance","What measure have been taken to improve decision-making?","None.","Limited, ad-hoc attempts to improve the consistency and clarity re: decision-making; however, no organization-wide uptake. ","Policies in place to guide decision-making at the administrative level, but not at the Council level.","Policies are in place to guide decision-making at both the Council and administrative levels."]
[null,"What measures have been taken to improve public communications and engagement?","None.","Incomplete policies in place to guide C&E.","Complete policies in place requiring departmental C&E plans, but not other materials/guidance available to help departments prepare them. ","Complete policies are in place requiring departmental C&E plans. Standard templates/procedures for developing C&E plans available. "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H39:H40)/(6-3*COUNTIF(H39:H40,\"=n/a\"))","v":0},{"$f":"SUM(I39:I40)/(6-3*COUNTIF(I39:I40,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Future Preparedness - Overall Percentage",{"$f":"AVERAGE(H41,H38,H36)","v":0},{"$f":"AVERAGE(I41,I38,I36)","v":0},{"$f":"AVERAGE(J41,J38,J36)","v":0},{"$f":"AVERAGE(K41,K38,K36)","v":0},{"$f":"AVERAGE(L41,L38,L36)","v":0}]
[]
[null,null,null,null,null,null,"Sustainability Percentage",{"$f":"AVERAGE(H42,H24)","v":0},{"$f":"AVERAGE(I42,I24)","v":0},{"$f":"AVERAGE(J42,J24)","v":0},{"$f":"AVERAGE(K42,K24)","v":0},{"$f":"AVERAGE(L42,L24)","v":0}]

{"sheet":"Transportation","index":5,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["CURRENT PERFORMANCE",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","Walking (in urban areas of the municipality)","Most streets in the urban areas do not have sidewalks.","Most streets in the urban areas only have sidewalks on one side of the street.","Most major streets have sidewalks on both sides of the street, and most other streets have sidewalks on one side of the street (in urban areas).","Almost all streets in the urban areas have sidewalks on both sides of the street."]
[null,"Cycling ","There are no, or very few, bicycle routes.","There is a limited cycling network that connects only major destinations within the municipality. ","There is a municipal-wide cycling network, but most facilities are not comfortable for people of all ages and abilities.","There is a municipal-wide cycling network with cycling options for all ages and abilities. "]
[null,"Motor Vehicles","Most intersections operate with significant congestion and delay (LOS E or F) at most times of day.","Most intersections operate with significant congestion and delay (LOS E or F) at peak periods only.","Some intersections operate with significant congestion and delay (LOS E or F) at peak periods only.","Few intersections operate with significant congestion and delay (LOS E or F) at any time."]
[null,"Safety","On average, there are a high number of annual traffic-related fatalities or serious injuries.","On average, there are some annual traffic-related fatalities or serious injuries.","On average, there are few annual traffic-related fatalities or serious injuries.","On average, there are no annual traffic-related fatalities or serious injuries."]
[null,"Asset condition","<20% of transportation infrastructure (by replacement value) in fair condition or better.","20-49% of transportation infrastructure (by replacement value) in fair condition or better.","50-99% of transportation infrastructure (by replacement value) in fair condition or better.","100% of transportation infrastructure (by replacement value) in fair condition or better."]
[null,"GHG Emissions (generated by providing the service)","No reductions in GHG emissions (compared to baseline). ","Minimal reductions in GHG emissions (compared to baseline). ","Moderate reductions in GHG emissions (compared to baseline). ","Significant reductions in GHG emissions (compared to baseline). "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H3:H8)/(18-3*COUNTIF(H3:H8,\"=n/a\"))","v":0},{"$f":"SUM(I3:I8)/(18-3*COUNTIF(I3:I8,\"=n/a\"))","v":0},0,0,{"$f":"SUM(L3:L8)/(18-3*COUNTIF(L3:L8,\"=n/a\"))","v":0}]
["Finance","Revenue","Revenue is year to year, there is no linkage between revenues and long term requirements are not sufficient to meet needs without reliance on grants or subsidies.","Revenue is sufficient and reliable to fund the requirements for the next 5 years, but there is a significant gap between revenues and sustainable funding levels for later years.","Revenue is sufficient and reliable to fund the requirements in the 10 year capital plan, but there is still a gap between revenues and sustainable funding levels for the long term. ","Revenues are sufficient, predictable, and stable to fund long term sustainable service delivery in alignment with the long term financial plan and the asset replacement plan."]
[null,"Reserves","No reserves are in place.","Minimal reserves are in place that can buffer short term fluctuations in revenue (e.g. 6 weeks operating expenses).","Reserves are in place to buffer short term revenue fluctuations. There are dedicated reserves for future capital renewal, but do not meet the levels required as identified in the financial plan.","Reserves are held at levels established in accordance with the financial plan in order to meet long term requirements."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H10:H11)/(6-3*COUNTIF(H10:H11,\"=n/a\"))","v":0},{"$f":"SUM(I10:I11)/(6-3*COUNTIF(I10:I11,\"=n/a\"))","v":0},0,0,0]
["Governance","Decision-making (Council and staff)","Decisions about transportation are made on an ad-hoc basis, typically consider only short-term impacts, and are not properly informed. ","Decisions about transportation consider both short and long-term impacts, but are informed by incomplete or anecdotal information.","Decisions about transportation consider both short and long-term impacts and are informed by appropriate information.","Decisions about transportation are formalized and consistent – they consider both short and long-term impacts, are based on appropriate information, and reflect community priorities.",null,null,null,null,null,null,null,null,null," "]
[null,"Public communications and engagement","Citizen engagement is not considered at all. (Note: If your community considers community engagement and decides it is not warranted, then score 1, 2, or 3 as appropriate.)","Citizen engagement (when required) is ad hoc for transportation.","Deliberate, well-planned citizen engagement occurs only for major transportation infrastructure projects that require citizen engagement– little consideration of citizen engagement outside of major infrastructure projects.","Citizens are engaged as per formal communications and engagement plans for all transportation matters that require citizen engagement.",null,null,null,null,null,null,null,null,null," "]
[null,"Customer satisfaction","Frequent customer complaints about significant transportation issues.","Frequent customer complaints about minor transportation issues.","Few customer complaints about transportation issues - most pertain to minor issues.","Almost no customer complaints about transportation.",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H13:H15)/(9-3*COUNTIF(H13:H15,\"=n/a\"))","v":0},{"$f":"SUM(I13:I15)/(9-3*COUNTIF(I13:I15,\"=n/a\"))","v":0},0,0,{"$f":"SUM(L13:L15)/(9-3*COUNTIF(L13:L15,\"=n/a\"))","v":0}]
[null,null,null,null,null,null,"Current Performance - Overall Percentage",{"$f":"AVERAGE(H16,H12,H9)","v":0},{"$f":"AVERAGE(I16,I12,I9)","v":0},{"$f":"AVERAGE(J16,J12,J9)","v":0},{"$f":"AVERAGE(K16,K12,K9)","v":0},{"$f":"AVERAGE(L16,L12,L9)","v":0}]
[]
["PREPAREDNESS FOR FUTURE SERVICE PROVISION",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","What measures have been taken to improve walking?","None.","The community has a Pedestrian Master Plan or Transportation Master Plan (or other suitable plan/policy document) with a long-term list of projects, but no process to evaluate and prioritize projects, and insufficient funding in place to implement these plans.\n","The community has a Pedestrian Master Plan or Transportation Master Plan (or other suitable plan/policy document) with a long-term list of projects, along with an objective process for evaluating and prioritizing sidewalk projects, but with only partial funding to fully implement these plans. \n","The community has a Pedestrian Master Plan or Transportation Master Plan (or other suitable plan/policy document) with a long-term list of projects, along with an objective process for evaluating and prioritizing sidewalk projects, as well as sufficient funding to fully implement these plans. \n"]
[null,"What measures have been taken to improve cycling?","None.","The community has a Bicycle Master Plan or Transportation Master Plan (or other suitable plan/policy document) with a long-term list of projects, but no process to evaluate and prioritize projects, and insufficient funding in place to implement these plans.\n","The community has a Bicycle Master Plan or Transportation Master Plan (or other suitable plan/policy document) with a long-term list of projects, along with an objective process for evaluating and prioritizing bicycle network projects, but with only partial funding to fully implement these plans. \n","The community has a Bicycle Master Plan or Transportation Master Plan (or other suitable plan/policy document) with a long-term list of projects, along with an objective process for evaluating and prioritizing bicycle network projects, along with sufficient funding to fully implement these plans. \n"]
[null,"What measures have been taken to improve the efficient movement of people and goods?","None.","The community has a Transportation Master Plan (or other suitable plan/policy document) but without a clear list of prioritized projects and with insufficient funding to implement these projects.","The community has a Transportation Master Plan (or other suitable plan/policy document) along with a list of projects to ensure the efficient movement of people and goods at all times of day, but with only partial funding to fully implement these projects.","The community has a Transportation Master Plan (or other suitable plan/policy document) along with a list of projects to ensure the efficient movement of people and goods at all times of day, along with sufficient funding to fully implement these projects."]
[null,"What measures have been taken to improve safety?","None.","The community is reviewing transportation safety data on an annual basis and identifying collision hot spots.","The community has adopted a VisionZero framework and is reviewing transportation safety data on an annual basis and identifying collision hot spots.","The community has adopted a VisionZero framework and is actively monitoring the safety performance of the transportation network, and continuing to make safety interventions to eliminate transportation-related fatalities and serious injuries."]
[null,"What measures have been taken to ensure service reliability?","None.","Ad hoc preventative maintenance program in place. No consideration of climate change impacts on design standards or O&M practices.","Formal preventative maintenance program in place. Climate change impacts have been considered in design standards and O&M practices.  However, funding is insufficient to fully implement the program.    ","Formal preventative maintenance program in place. Climate change impacts have been considered in design standards and O&M practices.  Funding is sufficient to fully implement the program.    "]
[null,"What measures have been taken to improve asset condition?","None.","An asset management program is in place for some major transportation assets, but not based on actual condition data.","An asset management program is in place for most major transportation assets, but based on minimal actual condition data.","An asset management program is in place for all major transportation assets, and based on actual condition data."]
[null,"What measures have been taken to ensure future human resource needs are filled?","None.","Ad-hoc succession and training planning in place.","Formal succession and training plans in place, but without sufficient funding.","Formal succession and training plans in place, and fully funded. "]
[null,"What measures have been taken to ensure future service provision minimizes GHG production? ","None.","Ad-hoc GHG reduction planning in place. ","Formal GHG reduction plans in place, but without sufficient funding. ","Formal GHG reduction plans in place, and fully funded. "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H21:H28)/(24-3*COUNTIF(H21:H28,\"=n/a\"))","v":0},{"$f":"SUM(I21:I28)/(24-3*COUNTIF(I21:I28,\"=n/a\"))","v":0},0,0,0]
["Finance","What measures have been taken to ensure adequate future revenues?","None.","A financial plan is in place but it covers <10 years or does not reflect the future costs of replacing existing assets.","A long term (10+ years) financial plan is in place that reflects the revenue required and funding sources to fund new assets and asset replacements, but the plan is not being followed or updated.","A comprehensive long term financial plan exists and is based on up to date information. The plan looks forward 10 years or more and is integrated with long term capital plan. The plan is being tracked and followed."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H30)/(3-3*COUNTIF(H30,\"=n/a\"))","v":0},{"$f":"SUM(I30)/(3-3*COUNTIF(I30,\"=n/a\"))","v":0},0,0,0]
["Governance","What measures have been taken to improve decision-making?","None.","Limited, ad-hoc attempts to improve the consistency and clarity re: decision-making; however, no organization-wide uptake. ","Policies in place to guide decision-making at the administrative level, but not at the Council level.","Policies are in place  to guide decision-making at both the Council and administrative levels."]
[null,"What measures have been taken to improve public communications and engagement?","None.","Incomplete policies in place to guide C&E.","Complete policies in place requiring departmental C&E plans, but not other materials/guidance available to help departments prepare them. ","Complete policies are in place requiring departmental C&E plans. Standard templates/procedures for developing C&E plans available. "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H32:H33)/(6-3*COUNTIF(H32:H33,\"=n/a\"))","v":0},{"$f":"SUM(I32:I33)/(6-3*COUNTIF(I32:I33,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Future Preparedness - Overall Percentage",{"$f":"AVERAGE(H29,H31,H34)","v":0},{"$f":"AVERAGE(I29,I31,I34)","v":0},{"$f":"AVERAGE(J29,J31,J34)","v":0},{"$f":"AVERAGE(K29,K31,K34)","v":0},{"$f":"AVERAGE(L29,L31,L34)","v":0}]
[]
[null,null,null,null,null,null,"Sustainability Percentage",{"$f":"AVERAGE(H35,H17)","v":0},{"$f":"AVERAGE(I35,I17)","v":0},0,0,0]

{"sheet":"Fire Protection","index":6,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[28,0,29,0]]}
["CURRENT PERFORMANCE",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery"]
[null,"Quality"]
[null,"Fire Department","Fire department does not run efficiently. Equipment is poorly maintained, personnel are poorly trained, distrubution of fire stations creates gaps in service.","Fire department is not very efficient. Maintenance and training occur irregularly and service gaps exist.","Fire department is efficient. Equipment is maintained regularly and personnel are well trained. Distribution of fire stations limits gaps in service.","Fire department is highly efficient. Equipment is always well maintained and personnel have the most up-to-date training. The service area is well covered by approporiately distributed fire stations."]
[null,"Water supply","Water supply is unreliable. System is poorly maintained and has not been designed to handle stress and failures.","Water supply is not very reliable. System receives irregular maintenance and does not handle stress or failures well.","Water supply is reliable. System receives regular maintenance and handles most stress or failures well.","Water supply is very reliable. System receives frequent maintenance and is capable of providing required flows simultaneously with Maximum Daily Consumption. Redundancies throughout ensure the ability to handle stress or failures."]
[null,"Fire prevention and fire safety control","Nothing is done in terms of fire prevention. There is no staff dedicated to prevention, no public education program in place, no codes/bylaws used for managing risk.","Litltle is done in terms of fire prevention. Public education programs are not well developed and codes/bylaws used for managing risk are yet to be introduced.","Fire prevention measures are implemented, and public education programs are available. Codes/bylaws are in place, but not uniformly enforced.","A proactive approach to fire prevention is performed at various levels of the community. Qualified staff are assigned to a team focused on fire prevention. Community has a well developed fire prevention program and Code enforcement. Public education program is well developed and occurs regularly."]
[null,"Emergency communications system","Ineffective emergency communication system. Telephone systems, lines, staffing and dispatching are inefficient and require immediate upgrades.","Adequate emergency communications system, but improvements are needed in order to render it more efficient.","Reliable emergency communications system. There is room for improvement but receiving fire alarms and dispatching resources is effective.","The community has robust emergency communications facilities and support for handling and dispatching fire alarms."]
[null,"Asset Condition"]
[null,"Asset condition","<20% of fire fighting fleet and firehall (by replacement value) in fair condition or better.","20-49% of fire fighting fleet and firehall (by replacement value) in fair condition or better.","50-99% of fire fighting fleet and firehall (by replacement value) in fair condition or better.","100% of fire fighting fleet and firehall (by replacement value) in fair condition or better."]
[null,"Greenhouse Gas Emissions"]
[null,"GHG Emissions (generated by providing the service)","No reductions in GHG emissions (compared to baseline). ","Minimal reductions in GHG emissions (compared to baseline). ","Moderate reductions in GHG emissions (compared to baseline). ","Significant reductions in GHG emissions (compared to baseline). "," "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H5:H12)/(18-3*COUNTIF(H5:H12,\"=n/a\"))","v":0},{"$f":"SUM(I5:I12)/(18-3*COUNTIF(I5:I12,\"=n/a\"))","v":0},0,0,0]
["Finance","Revenue","Revenue is year to year and there is no linkage between revenues and long term requirements. Revenues are not sufficient to meet needs without reliance on grants or subsidies.","Revenue is sufficient and reliable to fund the requirements for the next 5 years, but there is a significant gap between revenues and sustainable funding levels for later years.","Revenue is sufficient and reliable to fund the requirements in the 10 year capital plan, but there is still a gap between revenues and sustainable funding levels for the long term. ","Revenues are sufficient, predictable, and stable to fund long term sustainable service delivery in alignment with the long term financial plan and the asset replacement. \n"]
[null,"Reserves","No reserves are in place.","Minimal reserves are in place that can buffer short term fluctuations in revenue (e.g. 6 weeks operating expenses).","Reserves are in place to buffer short term revenue fluctuations. There are dedicated reserves for future capital renewal, but do not meet the levels required as identified in the financial plan.","Reserves are held at levels established in accordance with the financial plan in order to meet long term requirements."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H14:H15)/(6-3*COUNTIF(H14:H15,\"=n/a\"))","v":0},{"$f":"SUM(I14:I15)/(6-3*COUNTIF(I14:I15,\"=n/a\"))","v":0},0,0,0]
["Governance","Decision-making (Council and staff)","Decisions about fire protection are made on an ad-hoc basis, typically consider only short-term impacts, and are not properly informed. ","Decisions about fire protection consider both short and long-term impacts, but are informed by incomplete or anecdotal information.","Decisions about fire protection consider both short and long-term impacts and are informed by appropriate information.","Decisions about fire protection are formalized and consistent– they consider both short and long-term impacts, are based on appropriate information, and reflect community priorities."]
[null,"Public communications and engagement","Citizen engagement is not considered at all. (Note: If your community considers community engagement and decides it is not warranted, then score 1, 2, or 3 as appropriate.)","Citizen engagement (when required) is ad hoc for fire protection.","Deliberate, well-planned citizen engagement occurs only for major fire protection projects that require citizen engagement– little consideration of citizen engagement outside of major infrastructure projects.","Citizens are engaged as per formal communications and engagement plans for all fire protection matters that require citizen engagement."]
[null,"Customer satisfaction","Frequent customer complaints about significant fire protection issues.","Frequent customer complaints about minor fire protection issues.","Few customer complaints about fire protection issues - most pertain to minor issues.","Almost no customer complaints about fire protection."]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H17:H19)/(9-3*COUNTIF(H17:H19,\"=n/a\"))","v":0},{"$f":"SUM(I17:I19)/(9-3*COUNTIF(I17:I19,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Current Performance - Overall Percentage",{"$f":"AVERAGE(H20,H16,H13)","v":0},{"$f":"AVERAGE(I20,I16,I13)","v":0},{"$f":"AVERAGE(J20,J16,J13)","v":0},{"$f":"AVERAGE(K20,K16,K13)","v":0},{"$f":"AVERAGE(L20,L16,L13)","v":0}]
[]
["PREPAREDNESS FOR FUTURE SERVICE PROVISION",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","What measures have been taken to ensure suitable fire protection services in the future?","None.","A Fire Services Plan is in place that considers levels of service, condition of facilities and infrastructure, and resources, but needs to be updated. ","Up-to-date Fire Services Plan in place, but funding not sufficient to fully implement plan.","Up-to-date Fire Services Plan in place, and funding sufficient to fully implement plan."]
[null,"What measures have been taken to recruit and retain volunteers?","None.","Ad-hoc volunteer recruitment and retention strategy in place.  ","Formal volunteer recruitment and retention strategy in place, but it needs to be updated and/or is not fully executed. ","Formal volunteer recruitment and retention strategy in place, and is up-to-date and fully executed. "]
[null,"What measures have been taken to improve asset condition?","None.","An asset management program is in place for some major fire protection assets, but not based on actual condition data.","An asset management program is in place for most major fire protection assets, but based  on minimal actual condition data.","An asset management program is in place for all major fire protection assets, and based on actual condition data."]
[null,"What measures have been taken to ensure service reliability?","None.","Ad hoc preventative maintenance program in place. ","Formal preventative maintenance program in place. However, funding is insufficient to fully implement the program.  ","Formal preventative maintenance program in place. Funding is sufficient to fully implement the program.  "]
[null,"What measures have been taken to ensure future human resource needs are filled?","None.","Ad-hoc succession and training planning in place.","Formal succession and training plans in place, but without sufficient funding.","Formal succession and training plans in place, and fully funded. "]
[null,"What measures have been taken to ensure future service provision minimizes GHG production? ","None.","Ad-hoc GHG reduction planning in place. ","Formal GHG reduction plans in place, but without sufficient funding. ","Formal GHG reduction plans in place, and fully funded. "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H25:H30)/(18-3*COUNTIF(H25:H30,\"=n/a\"))","v":0},{"$f":"SUM(I25:I30)/(18-3*COUNTIF(I25:I30,\"=n/a\"))","v":0},0,0,0]
["Finance","What measures have been taken to ensure adequate future revenues?","None.","A financial plan is in place but it covers <10 years or does not reflect the future costs of replacing existing assets.","A long term (10+ years) financial plan is in place that reflects the revenue required and funding sources to fund new assets and asset replacements, but the plan is not being followed or updated.","A comprehensive long term financial plan exists and is based on up to date information. The plan looks forward 10 years or more and is integrated with long term capital plan. The plan is being tracked and followed."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"H32/(3-3*COUNTIF(H32,\"=n/a\"))","v":0},{"$f":"I32/(3-3*COUNTIF(I32,\"=n/a\"))","v":0},0,0,0]
["Governance","What measures have been taken to improve decision-making?","None.","Limited, ad-hoc attempts to improve the consistency and clarity re: decision-making; however, no organization-wide uptake. ","Policies in place to guide decision-making at the administrative level, but not at the Council level.","Policies are in place to guide decision-making at both the Council and administrative levels."]
[null,"What measures have been taken to improve public communications and engagement?","None.","Incomplete policies in place to guide C&E.","Complete policies are in place requiring departmental C&E plans, but not other materials/guidance available to help departments prepare them. ","Complete policies are in place requiring departmental C&E plans. Standard templates/procedures for developing C&E plans available. "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H34:H35)/(6-3*COUNTIF(H34:H35,\"=n/a\"))","v":0},{"$f":"SUM(I34:I35)/(6-3*COUNTIF(I34:I35,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Future Preparedness - Overall Percentage",{"$f":"AVERAGE(H36,H33,H31)","v":0},{"$f":"AVERAGE(I36,I33,I31)","v":0},{"$f":"AVERAGE(J36,J33,J31)","v":0},{"$f":"AVERAGE(K36,K33,K31)","v":0},{"$f":"AVERAGE(L36,L33,L31)","v":0}]
[]
[null,null,null,null,null,null,"Sustainability Percentage",{"$f":"AVERAGE(H37,H21)","v":0},{"$f":"AVERAGE(I37,I21)","v":0},0,0,0]

{"sheet":"Parks and Recreation","index":7,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[33,0,37,0]]}
["CURRENT PERFORMANCE",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery"]
[null,"Sports Fields"]
[null,"Quantity/Type","Quantity and/or type of sports fields is insufficient to meet needs of several user groups. ","Quantity and/or type of sports fields is insufficient to meet needs of some user groups. ","Quantity and/or type of sports fields is sufficient to meet needs of most user groups. ","Quantity and type of sports fields is sufficient to meet needs of nearly all user groups.  "]
[null,"Maintenance","Most sports fields do not receive adequate maintenance to support the intended use. ","Some sports fields do not receive adequate maintenance to support the intended use. ","Nearly all sports fields receive adequate maintenance to support the intended use. ","All sports fields receive adequate maintenance to support the intended use. "]
[null,"Play Areas"]
[null,"Quantity/Type","Quantity and/or type of play areas is insufficient to meet needs of several user groups. ","Quantity and/or type of play areas is insufficient to meet needs of some user groups. ","Quantity and/or type of play areas is sufficient to meet needs of most user groups. ","Quantity and type of play areas is sufficient to meet needs of nearly all user groups.  "]
[null,"Other (skate park, water park, courts, etc)"]
[null,"Quantity/Type","Quantity and/or type of \"other parks\" is insufficient to meet needs of several user groups. ","Quantity and/or type of \"other parks\" is insufficient to meet needs of some user groups. ","Quantity and/or type of \"other parks\" is sufficient to meet needs of most user groups. ","Quantity and type of \"other parks\" is sufficient to meet needs of nearly all user groups.  "]
[null,"Trails and Pathways"]
[null,"Quantity/Type","Quantity and/or type of trails/pathways is insufficient to meet needs of several user groups. ","Quantity and/or type of trails/pathways is insufficient to meet needs of some user groups. ","Quantity and/or type of trails/pathways is sufficient to meet needs of most user groups. ","Quantity and type of trails/pathways is sufficient to meet needs of nearly all user groups.  "]
[null,"Natural Parks"]
[null,"Quantity/Type","Quantity and/or type of natural parks is insufficient to meet needs of several user groups. ","Quantity and/or type of natural parks is insufficient to meet needs of some user groups. ","Quantity and/or type of natural parks is sufficient to meet needs of most user groups. ","Quantity and type of natural parks is sufficient to meet needs of nearly all user groups.  "]
[null,"Asset Condition"]
[null,"Asset condition (for all types of parks and trails)","<20% of parks infrastructure (by replacement value) in fair condition or better.","20-49% of parks infrastructure (by replacement value) in fair condition or better.","50-99% of parks infrastructure (by replacement value) in fair condition or better.","100% of parks infrastructure (by replacement value) in fair condition or better."]
[null,"Recreation Facilities"]
[null,"Quantity/Type","Quantity and/or type of recreational facilities is insufficient to meet needs of several user groups. ","Quantity and/or type of recreational facilities is insufficient to meet needs of some user groups. ","Quantity and/or type of recreational facilities is sufficient to meet needs of most user groups. ","Quantity and type of recreational facilities is sufficient to meet needs of nearly all user groups.  "]
[null,"Asset condition (for recreation facilities)","<20% of recreation facilities infrastructure (by replacement value) in fair condition or better.","20-49% of recreation facilities (by replacement value) in fair condition or better.","50-99% of recreation facilities (by replacement value) in fair condition or better.","100% of recreation facilities (by replacement value) in fair condition or better."]
[null,"Green House Gas Emissions"]
[null,"GHG Emissions (generated by providing the service)","No reductions in GHG emissions (compared to baseline). ","Minimal reductions in GHG emissions (compared to baseline). ","Moderate reductions in GHG emissions (compared to baseline). ","Significant reductions in GHG emissions (compared to baseline). "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H5:H6,H8:H8,H10:H10,H12:H12,H14:H14,H16,H18:H19:H21)/(30-3*COUNTIF(H5:H21,\"=n/a\"))","v":0},{"$f":"SUM(I5:I6,I8:I8,I10:I10,I12:I12,I14:I14,I16,I18:I19:I21)/(30-3*COUNTIF(I5:I21,\"=n/a\"))","v":0},{"$f":"SUM(J5:J6,J8:J8,J10:J10,J12:J12,J14:J14,J16,J18:J19:J21)/(30-3*COUNTIF(J5:J21,\"=n/a\"))","v":0},{"$f":"SUM(K5:K6,K8:K8,K10:K10,K12:K12,K14:K14,K16,K18:K19:K21)/(30-3*COUNTIF(K5:K21,\"=n/a\"))","v":0},{"$f":"SUM(L5:L6,L8:L8,L10:L10,L12:L12,L14:L14,L16,L18:L19:L21)/(30-3*COUNTIF(L5:L21,\"=n/a\"))","v":0}]
["Finance","Revenue","Revenue is year to year and there is no linkage between revenues and long term requirements. Revenues are not sufficient to meet needs without reliance on grants or subsidies.","Revenue is sufficient and reliable to fund the requirements for the next 5 years, but there is a significant gap between revenues and sustainable funding levels for later years.","Revenue is sufficient and reliable to fund the requirements in the 10 year capital plan, but there is still a gap between revenues and sustainable funding levels for the long term. ","Revenues are sufficient, predictable, and stable to fund long term sustainable service delivery in alignment with the long term financial plan and the asset replacement plan."]
[null,"Reserves","No reserves are in place.","Minimal reserves are in place that can buffer short term fluctuations in revenue (e.g. 6 weeks operating expenses).","Reserves are in place to buffer short term revenue fluctuations. There are dedicated reserves for future capital renewal, but do not meet the levels required as identified in the financial plan.","Reserves are held at levels established in accordance with the financial plan in order to meet long term requirements."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H23:H24)/(6-3*COUNTIF(H23:H24,\"=n/a\"))","v":0},{"$f":"SUM(I23:I24)/(6-3*COUNTIF(I23:I24,\"=n/a\"))","v":0},0,0,0]
["Governance","Decision-making (Council and staff)","Decisions about parks and recreation are made on an ad-hoc basis, typically consider only short-term impacts, and are not properly informed. ","Decisions about parks and recreation consider both short and long-term impacts, but are informed by incomplete or anecdotal information.","Decisions about parks and recreation consider both short and long-term impacts and are informed by appropriate information.","Decisions about parks and recreation is formalized and consistent– it considers both short and long-term impacts, is based on appropriate information, and reflects community priorities."]
[null,"Public communications and engagement","Citizen engagement is not considered at all. (Note: If your community considers community engagement and decides it is not warranted, then score 1, 2, or 3 as appropriate.)","Citizen engagement (when required) is ad hoc for parks and recreation. ","Deliberate, well-planned citizen engagement occurs only for major parks and recreation infrastructure projects that require citizen engagement– little consideration of citizen engagement outside of major infrastructure projects.","Citizens are engaged as per formal communications and engagement plans for all parks and recreation matters that require citizen engagement."]
[null,"Customer satisfaction","Frequent, customer complaints about significant parks and recreation issues.","Frequent customer complaints about minor parks and recreation issues.","Few customer complaints about parks and recreation issues - most pertain to minor issues.","Almost no customer complaints about parks and recreation."]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H26:H28)/(9-3*COUNTIF(H26:H28,\"=n/a\"))","v":0},{"$f":"SUM(I26:I28)/(9-3*COUNTIF(I26:I28,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Current Performance - Overall Percentage",{"$f":"AVERAGE(H22,H25,H29)","v":0},{"$f":"AVERAGE(I22,I25,I29)","v":0},{"$f":"AVERAGE(J22,J25,J29)","v":0},{"$f":"AVERAGE(K22,K25,K29)","v":0},{"$f":"AVERAGE(L22,L25,L29)","v":0}]
[]
["PREPAREDNESS FOR FUTURE SERVICE PROVISION",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","What measures have been taken to ensure future service provision (quantity and type)?","None.","Parks and recreation master plan (or other suitable plan/policy document) is in place, but it needs to be updated. ","Up-to-date parks and recreation master plan (or other suitable plan/policy document) is in place, but funding not sufficient to fully implement plan.","Up-to-date parks and recreation master plan (or other suitable plan/policy document) is in place, and funding sufficient to fully implement plan. "]
[null,"What measures have been taken to ensure service reliability?","None.","Ad hoc preventative maintenance program in place. No consideration of climate change impacts on design standards or O&M practices. ","Formal preventative maintenance program in place. Climate change impacts have been considered in design standards and O&M practices. However, funding is insufficient to fully implement the program.  ","Formal preventative maintenance program in place. Climate change impacts have been considered in design standards and O&M practices. Funding is sufficient to fully implement the program.    "]
[null,"What measures have been taken to improve asset condition?","None.","An asset management program is in place for some major  parks/recreation assets, but not based on actual condition data.","An asset management program is in place for most major  parks/recreation assets, but based  on minimal actual condition data.","An asset management program is in place for all major parks/recreation assets, and based on actual condition data."]
[null,"What measures have been taken to ensure future human resource needs are filled?","None.","Ad-hoc succession and training planning in place.","Formal succession and training plans in place, but without sufficient funding.","Formal succession and training plans in place, and fully funded. "]
[null,"What measures have been taken to ensure future service provision minimizes GHG production? ","None.","Ad-hoc GHG reduction planning in place. ","Formal GHG reduction plans in place, but without sufficient funding. ","Formal GHG reduction plans in place, and fully funded. "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H34:H38)/(15-3*COUNTIF(H34:H38,\"=n/a\"))","v":0},{"$f":"SUM(I34:I38)/(15-3*COUNTIF(I34:I38,\"=n/a\"))","v":0},0,0,0]
["Finance","What measures have been taken to ensure adequate future revenues?","None.","A financial plan is in place but it covers <10 years or does not reflect the future costs of replacing existing assets.","A long term (10+ years) financial plan is in place that reflects the revenue required and funding sources to fund new assets and asset replacements, but the plan is not being followed or updated.","A comprehensive long term financial plan exists and is based on up to date information. The plan looks forward 10 years or more and is integrated with long term capital plan. The plan is being tracked and followed."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H40)/(3-3*COUNTIF(H40,\"=n/a\"))","v":0},{"$f":"SUM(I40)/(3-3*COUNTIF(I40,\"=n/a\"))","v":0},0,0,0]
["Governance","What measures have been taken to improve decision-making?","None.","Limited, ad-hoc attempts to improve the consistency and clarity re: decision-making; however, no organization-wide uptake. ","Policies in place to guide decision-making at the administrative level, but not at the Council level.","Policies are in place to guide decision-making at both the Council and administrative levels."]
[null,"What measures have been taken to improve public communications and engagement?","None.","Incomplete policies in place to guide C&E.","Complete policies in place requiring departmental C&E plans, but not other materials/guidance available to help departments prepare them. ","Complete policies are in place requiring departmental C&E plans. Standard templates/procedures for developing C&E plans available. "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H42:H43)/(6-3*COUNTIF(H42:H43,\"=n/a\"))","v":0},{"$f":"SUM(I42:I43)/(6-3*COUNTIF(I42:I43,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Future Preparedness - Overall percentage",{"$f":"AVERAGE(H44,H41,H39)","v":0},{"$f":"AVERAGE(I44,I41,I39)","v":0},{"$f":"AVERAGE(J44,J41,J39)","v":0},{"$f":"AVERAGE(K44,K41,K39)","v":0},{"$f":"AVERAGE(L44,L41,L39)","v":0}]
[]
[null,null,null,null,null,null,"Sustainability Percentage",{"$f":"AVERAGE(H45,H30)","v":0},{"$f":"AVERAGE(I45,I30)","v":0},0,0,0]

{"sheet":"Solid Waste","index":8,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[36,6,37,7],[35,5,35,6],[9,0,10,0],[2,0,7,0],[12,0,14,0],[20,0,25,0],[29,0,30,0]]}
["CURRENT PERFORMANCE",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","Services Provided - Residential","No curbside collection.","Curbside collection of garbage only.","Curbside collection of garbage and recyclables only. ","Curbside collection of garbage, recyclables and compostables provided. "]
[null,"Transfer station and/or landfill","No diversion of recyclables provided.","Diversion of some recylables provided.","Diversion of most recyclables provided.","Opportunity for diversion of full range of recyclables (including appliances, textiles) provided."]
[null,"Landfill capacity ","Landfill is nearing capacity. ","Landfill has capacity to accommodate next 5 - 10 years. ","Landfill has capacity to accommodate next 10 - 20 years. ","Landfill has capacity to accommodate next 20+ years. "]
[null,"Environmental stewardship - diversion of waste from landfills","Per capita quantity of solid waste disposal to landfill exceeds regional district target by more than 20%. ","Per capita quantity of solid waste disposal to landfill exceeds regional district target by less than 20%. ","Per capita quantity of solid waste disposal to landfill meets regional district target. ","Per capita quantity of solid waste disposal to landfill is less than regional district target. "]
[null,"Asset condition","<20% of waste management system (by replacement value) in fair condition or better.","20-49% of waste management system (by replacement value) in fair condition or better.","50-99% of waste management system (by replacement value) in fair condition or better.","100% of waste management system (by replacement value) in fair condition or better."]
[null,"GHG Emissions (generated by providing the service)","No reductions in GHG emissions (compared to baseline). ","Minimal reductions in GHG emissions (compared to baseline). ","Moderate reductions in GHG emissions (compared to baseline). ","Significant reductions in GHG emissions (compared to baseline). "," "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H3:H8)/(18-3*COUNTIF(H3:H8,\"=n/a\"))","v":0},{"$f":"SUM(I3:I8)/(18-3*COUNTIF(I3:I8,\"=n/a\"))","v":0},0,0,0]
["Finance","Revenue","Revenue is year to year and there is no linkage between revenues and long term requirements. Revenues are not sufficient to meet needs without reliance on grants or subsidies.","Revenue is sufficient and reliable to fund the requirements for the next 5 years, but there is a significant gap between revenues and sustainable funding levels for later years.","Revenue is sufficient and reliable to fund the requirements in the 10 year capital plan, but there is still a gap between revenues and sustainable funding levels for the long term. ","Revenues are sufficient, predictable, and stable to fund long term sustainable service delivery in alignment with the long term financial plan and the asset replacement plan."]
[null,"Reserves","No reserves are in place.","Minimal reserves are in place that can buffer short term fluctuations in revenue (e.g. 6 weeks operating expenses).","Reserves are in place to buffer short term revenue fluctuations. There are dedicated reserves for future capital renewal, but do not meet the levels required as identified in the financial plan.","Reserves are held at levels established in accordance with the financial plan in order to meet long term requirements."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H10:H11)/(6-3*COUNTIF(H10:H11,\"=n/a\"))","v":0},{"$f":"SUM(I10:I11)/(6-3*COUNTIF(I10:I11,\"=n/a\"))","v":0},0,0,0]
["Governance","Decision-making (Council and staff)","Decisions about solid waste are made on an ad-hoc basis, typically consider only short-term impacts, and are not properly informed. ","Decisions about solid waste consider both short and long-term impacts, but are informed by incomplete or anecdotal information.","Decisions about solid waste consider both short and long-term impacts and are informed by appropriate information.","Decisions about solid waste is formalized and consistent– it considers both short and long-term impacts, is based on appropriate information, and reflects community priorities."," "]
[null,"Public communications and engagement","Citizen engagement is not considered at all. (Note: If your community considers community engagement and decides it is not warranted, then score 1, 2, or 3 as appropriate.)","Citizen engagement (when required) is ad hoc for solid waste. ","Deliberate, well-planned citizen engagement occurs only for major solid waste issues that require citizen engagement– little consideration of citizen engagement outside of major issues.","Citizens are engaged as per formal communications and engagement plans for all solid waste matters that require citizen engagement."," "]
[null,"Customer satisfaction","Frequent customer complaints about significant solid waste issues.","Frequent customer complaints about minor solid waste issues.","Few customer complaints about solid waste issues - most pertain to minor issues.","Almost no customer complaints about solid waste."]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H13:H15)/(9-3*COUNTIF(H13:H15,\"=n/a\"))","v":0},{"$f":"SUM(I13:I15)/(9-3*COUNTIF(I13:I15,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Current Performance - Overall Percentage",{"$f":"AVERAGE(H9,H12,H16)","v":0},{"$f":"AVERAGE(I9,I12,I16)","v":0},{"$f":"AVERAGE(J9,J12,J16)","v":0},{"$f":"AVERAGE(K9,K12,K16)","v":0},{"$f":"AVERAGE(L9,L12,L16)","v":0}]
[]
["PREPAREDNESS FOR FUTURE SERVICE PROVISION",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","What measures have been taken to divert waste from landfills?","None.","Some of the following are in place: \n• disposal bans on recyclable materials\n• disposal quantity limits\n• user pay approach\n","All of the following are in place: \n• disposal bans on recyclable materials\n• disposal quantity limits\n• user pay approach\nHowever - restrictions could be more stringent.\n","All of the following are in place: \n• disposal bans on recyclable materials\n• disposal quantity limits\n• user pay approach\nAnd all requirements are sufficiently stringent. \n"]
[null,"What measures have been taken to ensure service reliability?","None.","Ad hoc preventative maintenance program in place. ","Formal preventative maintenance program in place. However, funding is insufficient to fully implement the program.  ","Formal preventative maintenance program in place. Funding is sufficient to fully implement the program.  "]
[null,"What measures have been taken to ensure future service provision?","None.","A waste management plan (or other suitable plan/policy document) is in place, but needs to be updated. ","Up-to-date waste management plan (or other suitable plan/policy document) in place, but funding not sufficient to fully implement plan.","Up-to-date waste management plan (or other suitable plan/policy document) in place, and funding sufficient to fully implement plan."]
[null,"What measures have been taken to improve asset condition?","None.","An asset management program is in place for some major solid waste assets, but not based on actual condition data.","An asset management program is in place for most major solid waste assets, but based on minimal actual condition data.","An asset management program is in place for all major solid waste assets, and based on actual condition data."]
[null,"What measures have been taken to ensure future human resource needs are filled?","None.","Ad-hoc succession and training planning in place.","Formal succession and training plans in place, but without sufficient funding.","Formal succession and training plans in place, and fully funded. "]
[null,"What measures have been taken to ensure future service provision minimizes GHG production? ","None.","Ad-hoc GHG reduction planning in place. ","Formal GHG reduction plans in place, but without sufficient funding. ","Formal GHG reduction plans in place, and fully funded. "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H21:H26)/(18-3*COUNTIF(H21:H26,\"=n/a\"))","v":0},{"$f":"SUM(I21:I26)/(18-3*COUNTIF(I21:I26,\"=n/a\"))","v":0},{"$f":"SUM(J21:J26)/(18-3*COUNTIF(J21:J26,\"=n/a\"))","v":0},{"$f":"SUM(K21:K26)/(18-3*COUNTIF(K21:K26,\"=n/a\"))","v":0},{"$f":"SUM(L21:L26)/(18-3*COUNTIF(L21:L26,\"=n/a\"))","v":0}]
["Finance","What measures have been taken to ensure adequate future revenues?","None.","A financial plan is in place but it covers <10 years or does not reflect the future costs of replacing existing assets.","A long term (10+ years) financial plan is in place that reflects the revenue required and funding sources to fund new assets and asset replacements, but the plan is not being followed or updated.","A comprehensive long term financial plan exists and is based on up to date information. The plan looks forward 10 years or more and is integrated with long term capital plan. The plan is being tracked and followed."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H28)/(3-3*COUNTIF(H28,\"=n/a\"))","v":0},{"$f":"SUM(I28)/(3-3*COUNTIF(I28,\"=n/a\"))","v":0},0,0,0]
["Governance","What measure have been taken to improve decision-making?","None.","Limited, ad-hoc attempts to improve the consistency and clarity re: decision-making; however, no organization-wide uptake. ","Policies in place to guide decision-making at the administrative level, but not at the Council level.","Policies are in place to guide decision-making at both the Council and administrative levels."]
[null,"What measures have been taken to improve public communications and engagement?","None.","Incomplete policies in place to guide C&E.","Complete policies are in place requiring departmental C&E plans, but not other materials/guidance available to help departments prepare them. ","Complete policies are in place requiring departmental C&E plans. Standard templates/procedures for developing C&E plans available. "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H30:H31)/(6-3*COUNTIF(H30:H31,\"=n/a\"))","v":0},{"$f":"SUM(I30:I31)/(6-3*COUNTIF(I30:I31,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null," Future Preparedness - Overall Percentage",{"$f":"AVERAGE(H27,H29,H32)","v":0},{"$f":"AVERAGE(I27,I29,I32)","v":0},{"$f":"AVERAGE(J27,J29,J32)","v":0},{"$f":"AVERAGE(K27,K29,K32)","v":0},{"$f":"AVERAGE(L27,L29,L32)","v":0}]
[]
[null,null,null,null,null,null,"Sustainability Percentage",{"$f":"AVERAGE(H33,H17)","v":0},{"$f":"AVERAGE(I33,I17)","v":0},0,0,0]

{"sheet":"Civic Facilities","index":9,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,0,12,0],[33,0,34,0],[25,0,29,0],[17,0,19,0],[14,0,15,0]]}
["CURRENT PERFORMANCE",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","Libraries"]
[null,"Quantity/Type ","Quantity and/or type of library space is insufficient to meet needs of several user groups. ","Quantity and/or type of library space is insufficient to meet needs of some user groups. ","Quantity and/or type of library space is sufficient to meet needs of most user groups. ","Quantity and type of library space is sufficient to meet needs of nearly all user groups.  "]
[null,"Asset condition","<20% of library infrastructure (by replacement value) in fair condition or better.","20-49% of library infrastructure (by replacement value) in fair condition or better.","50-99% of library infrastructure (by replacement value) in fair condition or better.","100% of library infrastructure (by replacement value) in fair condition or better."]
[null,"Municipal Hall"]
[null,"Quantity/Type ","Significant space constraints - not enough space to accommodate required staffing levels. ","Sufficient space to accommodate staff; however, signficant deficiencies in space for other civic purposes (council chambers, community meeting spaces, front counter).","Sufficient space to accommodate staff; only minor deficiencies in space for other civic purposes (council chambers, community meeting spaces, front counter).","Sufficient quantity and quality of space to accommodate all municipal hall needs."]
[null,"Asset condition","<20% of municipal hall infrastrucure  (by replacement value) in fair condition or better.","20-49% of municipal hall infrastrucure (by replacement value) in fair condition or better.","50-99% of municipal hall infrastructure (by replacement value) in fair condition or better.","100% of municipal hall infrastructure (by replacement value) in fair condition or better."]
[null,"Other Facilities (user to specify facility names here)"]
[null,"Quantity/Type ","Quantity and/or type of other civic facilities is insufficient to meet needs of several user groups. ","Quantity and/or type of other civic facilities is insufficient to meet needs of some user groups. ","Quantity and/or type of other civic facilities is sufficient to meet needs of most user groups. ","Quantity and type of other civic facilities is sufficient to meet needs of nearly all user groups.  "]
[null,"Asset condition","<20% of other civic facilities (by replacement value) in fair condition or better.","20-49% of other civic facilities  (by replacement value) in fair condition or better.","50-99% of other civic facilities (by replacement value) in fair condition or better.","100% of other civic facilities (by replacement value) in fair condition or better."]
[null,"Greenhouse Gas Emissions (for all civic facilities)"]
[null,"GHG Emissions (generated by providing the service)","No reductions in GHG emissions (compared to baseline). ","Minimal reductions in GHG emissions (compared to baseline). ","Moderate reductions in GHG emissions (compared to baseline). ","Significant reductions in GHG emissions (compared to baseline). "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H13,H11,H10,H8,H7,H5,H4)/(21-3*COUNTIF(H4:H13,\"=n/a\"))","v":0},{"$f":"SUM(I13,I11,I10,I8,I7,I5,I4)/(21-3*COUNTIF(I4:I13,\"=n/a\"))","v":0},0,0,0]
["Finance","Revenue","Revenue is year to year and there is no linkage between revenues and long term requirements. Revenues are not sufficient to meet needs without reliance on grants or subsidies.","Revenue is sufficient and reliable to fund the requirements for the next 5 years, but there is a significant gap between revenues and sustainable funding levels for later years.","Revenue is sufficient and reliable to fund the requirements in the 10 year capital plan, but there is still a gap between revenues and sustainable funding levels for the long term. ","Revenues are sufficient, predictable, and stable to fund long term sustainable service delivery in alignment with the long term financial plan and the asset replacement plan."]
[null,"Reserves","No reserves are in place.","Minimal reserves are in place that can buffer short term fluctuations in revenue (e.g. 6 weeks operating expenses).","Reserves are in place to buffer short term revenue fluctuations. There are dedicated reserves for future capital renewal, but do not meet the levels required as identified in the financial plan.","Reserves are held at levels established in accordance with the financial plan in order to meet long term requirements."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"SUM(H15:H16)/(6-3*COUNTIF(H15:H16,\"=n/a\"))","v":0},{"$f":"SUM(I15:I16)/(6-3*COUNTIF(I15:I16,\"=n/a\"))","v":0},0,0,0]
["Governance","Decision-making (Council and staff)","Decisions about civic facilities are made on an ad-hoc basis, typically consider only short-term impacts, and are not properly informed. ","Decisions about civic facilities consider both short and long-term impacts, but are informed by incomplete or anecdotal information.","Decisions about civic facilities consider both short and long-term impacts and are informed by appropriate information.","Decisions about civic facilities are formalized and consistent– they consider both short and long-term impacts, are based on appropriate information, and reflect community priorities."," "]
[null,"Public communications and engagement","Citizen engagement is not considered at all. (Note: If your community considers community engagement and decides it is not warranted, then score 1, 2, or 3 as appropriate.)","Citizen engagement (when required) is ad hoc for civic facilities.","Deliberate, well-planned citizen engagement occurs only for major building projects that require citizen engagement– little consideration of citizen engagement outside of major infrastructure projects.","Citizens are engaged as per formal communications and engagement plans for all matters related to civic facilities that require citizen engagement."," "]
[null,"Customer satisfaction","Frequent customer complaints about significant issues related to civic facilities.","Frequent customer complaints about minor issues related to civic facilities.","Few customer complaints about civic facilities - most pertain to minor issues.","Almost no customer complaints about civic facilities."]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H18:H20)/(9-3*COUNTIF(H18:H20,\"=n/a\"))","v":0},{"$f":"SUM(I18:I20)/(9-3*COUNTIF(I18:I20,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null," Current Performance - Overall Percentage",{"$f":"AVERAGE(H14,H17,H21)","v":0},{"$f":"AVERAGE(I14,I17,I21)","v":0},{"$f":"AVERAGE(J14,J17,J21)","v":0},{"$f":"AVERAGE(K14,K17,K21)","v":0},{"$f":"AVERAGE(L14,L17,L21)","v":0}]
[]
["PREPAREDNESS FOR FUTURE SERVICE PROVISION",null,null,null,null,null,null,2017,2018,2019,2020,2021]
[null,null,"Score 0","Score 1","Score 2","Score 3"]
["Service Delivery","What measures have been taken to ensure future service provision?","None.","Facilities master plan (or other suitable plan/policy document) in place, but needs to be updated. ","Up-to-date facilities master plan (or other suitable plan/policy document) in place, but funding insufficient to fully implement the plan. ","Up-to-date facilities master plan (or other suitable plan/policy document) in place, and funding sufficient to fully implement the plan. "]
[null,"What measures have been taken to ensure service reliability?","None.","Ad hoc preventative maintenance program in place.  ","Formal preventative maintenance program in place. However, funding is insufficient to fully implement the program.  ","Formal preventative maintenance program in place. Funding is sufficient to fully implement the program.  "]
[null,"What measures have been taken to improve asset condition?","None.","An asset management program is in place for some civic facilities, but not based on actual condition data.","An asset management program is in place for most  civic facilities, but based on minimal actual condition data.","An asset management program is in place for all civic facilities, and based on actual condition data."]
[null,"What measures have been taken to ensure future human resource needs are filled?","None.","Ad-hoc succession and training planning in place.","Formal succession and training plans in place, but without sufficient funding.","Formal succession and training plans in place, and fully funded. "]
[null,"What measures have been taken to ensure future service provision minimizes GHG production? ","None.","Ad-hoc GHG reduction planning in place. ","Formal GHG reduction plans in place, but without sufficient funding. ","Formal GHG reduction plans in place, and fully funded. "]
[null,null,null,null,null,null,"Service Delivery Percentage",{"$f":"SUM(H26:H30)/(15-3*COUNTIF(H26:H30,\"=n/a\"))","v":0},{"$f":"SUM(I26:I30)/(15-3*COUNTIF(I26:I30,\"=n/a\"))","v":0},{"$f":"SUM(J26:J30)/(15-3*COUNTIF(J26:J30,\"=n/a\"))","v":0},{"$f":"SUM(K26:K30)/(15-3*COUNTIF(K26:K30,\"=n/a\"))","v":0},{"$f":"SUM(L26:L30)/(15-3*COUNTIF(L26:L30,\"=n/a\"))","v":0}]
["Finance","What measures have been taken to ensure adequate future revenues?","None.","Long-term financial plans have been completed, but still show heavy reliance on grants. No dedicated source of revenue for asset renewal.  ","Long-term financial plans have been completed, but are not guided by adopted financial policies. No dedicated source of revenue for asset renewal.","Long-term financial plans have been completed in accordance with adopted financial policies – includes dedicated revenue sources for asset renewal."]
[null,null,null,null,null,null,"Finance Percentage",{"$f":"H32/(3-3*COUNTIF(H32,\"=n/a\"))","v":0},{"$f":"I32/(3-3*COUNTIF(I32,\"=n/a\"))","v":0},0,0,0]
["Governance","What measures have been taken to improve decision-making?","None.","Limited, ad-hoc attempts to improve the consistency and clarity re: decision-making; however, no organization-wide uptake. ","Policies in place to guide decision-making at the administrative level, but not at the Council level.","Policies are in place  to guide decision-making at both the Council and administrative levels."]
[null,"What measures have been taken to improve public communications and engagement?","None.","Incomplete policies in place to guide C&E.","Complete policies are in place requiring departmental C&E plans, but not other materials/guidance available to help departments prepare them. ","Complete policies are in place requiring departmental C&E plans. Standard templates/procedures for developing C&E plans available. "]
[null,null,null,null,null,null,"Governance Percentage",{"$f":"SUM(H34:H35)/(6-3*COUNTIF(H34:H35,\"=n/a\"))","v":0},{"$f":"SUM(I34:I35)/(6-3*COUNTIF(I34:I35,\"=n/a\"))","v":0},0,0,0]
[null,null,null,null,null,null,"Future Preparedness - Overall Percentage",{"$f":"AVERAGE(H31,H33,H36)","v":0},{"$f":"AVERAGE(I31,I33,I36)","v":0},0,0,0]
[]
[null,null,null,null,null,null,"Sustainability Percentage",{"$f":"AVERAGE(H37,H22)","v":0},{"$f":"AVERAGE(I37,I22)","v":0},0,0,0]