{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Six-month Report","Annual Report","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":63,"n_cols":2,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null," Reporting Template for Gas Distributors"]
[null,"AUC Rule 002 - Service Quality and Reliability Performance "]
[null,"Monitoring and Reporting for Owners of Electric Distribution Systems"]
[null,"and Gas Distributors"]
[]
["Instructions:"]
[null," "]
["General:"]
[null,"Go to the six-month report tab and enter the name of your company as you will want it to appear on the header of the reports. On the same tab, enter the applicable year. "]
[]
[null,"The annual report builds from the six-month report, so when you are preparing the annual report, use the same template that you used to enter the six-month report data. "]
[null,"On the top of each report, enter the appropriate dates: the date you are preparing the report and the date the system reports were generated."]
[]
[null,"Please note that generally, within each table, cells that require your input are white and ones that contain formulas are shaded and should not be modified."]
[]
["5.1 Billing and meter reading performance measures"]
[]
["5.1.1 Monthly billing and meter reading performance"]
[]
[null,"For this metric, you have the option of reporting as of calendar month end or as of the date of the last cycle (billing or meter reading) of the month. Whichever method you use, please apply it consistently and enter the applicable dates at the top of the columns. For each month, report the counts based on the status on the date used. In the six-month report, enter the service standard for the owner as identified in Appendix B of Rule 002 in the \"minimum annual service standard\" column."]
[]
["5.1.2 Cumulative meters not read within six months, and not read within one year"]
[]
[null,"Please provide the site count for all sites  (other than de-energized sites) that have not had their meter read within six months. Include those sites that also appear in the metric of sites that have not had their meter read within one year. "]
[]
[null,"For sites that have not had their meters read within one year, include de-energized sites that still have a meter. Group the sites by reason that the meters were not read and, for each reason, briefly describe the reason, provide the number of sites and provide the course(s) of action the owner will take to get the meters read and ensure that the situation does not occur again in the future."]
[]
["5.2 Work completion performance measures"]
[]
[null,"For energizations and de-energizations, report monthly numbers of those performed. For de-energizations only, report the average number of days to send responses to retailers after they sent the requests and the average time to actually complete the work.  "]
[]
[{"$f":"+'Six-month Report'!B57","v":"5.5 Customer appointments"}]
[]
[null,"For each month, please provide the number of pre-arranged appointments with customers and the number of pre-arranged appointments met within the pre-arranged time period. In the six-month report, enter the service standard for the owner as identified in Appendix C of Rule 002 in the \"minimum annual service standard\" column."]
[]
[{"$f":"+'Six-month Report'!B66","v":"5.6 Emergency response time"}]
[]
[null,"Please provide the monthly percentage of emergencies responded to within the applicable time frame(s) specified in Appendix D of Rule 002. Also, in the six-month report, enter the service standard for the owner as identified in Appendix D of Rule 002 in the \"annual service standard\" column."]
[]
[{"$f":"+'Six-month Report'!B75","v":"5.7 Call answering service level"}]
[]
[null,"Provide the percentage of calls answered that are answered within 30 seconds. In the six-month report, enter the service standard for the owner as identified in Appendix E of Rule 002 in the \"minimum annual service standard\" column."]
[]
["Annual Report:"]
[]
[null,"The \"Annual Report\" tab is auto-populated from the data provided in the six-month report tab, except for the following metrics:"]
[]
["5.3 Worker safety performance measure"]
[]
["5.3.1 All injury/illness frequency rate (AIIFR)"]
[]
[null,"Please provide annual numbers for the metrics for the previous five years according to the definitions historically used by the owner."]
[]
["5.3.2 Motor vehicle incident frequency rate"]
[]
[null,"Please provide annual numbers for the metrics for the previous five years according to the definitions used by the Canadian Gas Association."]
[]
["5.4 Customer satisfaction measures"]
[]
[null,"Owners must measure the level of customer satisfaction. An owner is encouraged to include in its Rule 002 annual report the matters set out in the Rule."]
[null,"Please note, utilities can use the previous Customer Satisfaction format for their 2020 annual report, if they prefer."]

{"sheet":"Six-month Report","index":1,"n_rows":77,"n_cols":20,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,3],[69,1,69,4],[74,12,75,12],[65,12,66,12],[36,1,36,2],[34,5,34,13],[35,5,35,13],[32,1,32,2],[49,1,49,4],[50,1,50,4],[51,1,51,4],[33,1,33,2],[34,1,34,2],[35,1,35,2],[37,1,37,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[17,1,17,4],[27,1,27,3],[24,1,24,3],[26,1,26,3],[12,1,14,4],[15,1,15,4],[19,1,19,4],[18,1,18,4],[16,1,16,4],[76,1,76,4],[42,5,42,11],[45,1,45,11],[48,1,48,11],[56,1,58,4],[74,1,75,4],[65,1,66,4],[59,1,59,4],[56,5,56,18],[42,1,43,4],[68,1,68,4],[65,5,65,11],[58,18,59,18],[74,5,74,11],[60,1,60,4],[67,1,67,4],[1,4,1,8],[56,19,59,19],[30,5,30,13],[37,5,37,13],[32,5,32,13],[33,5,33,13],[36,5,36,13],[31,5,31,13],[57,17,57,18],[58,17,59,17],[29,5,29,13],[12,12,18,12],[13,11,15,11],[12,5,12,11],[26,5,27,13],[28,5,28,13]]}
["Rule 002: Service Quality and Reliability Performance Monitoring and Reporting for Owners of Electric Distribution Systems and for Gas Distributors ReportingTemplate (Gas)"]
["Company name:",null,null,null," "]
[]
["Reporting for year:",{"$nulls":4}," "]
["Date six-month report prepared:",{"$nulls":4}," "]
["Date six-month report last modified (if applicable):",{"$nulls":4}," "]
["Date six-month reports generated:",{"$nulls":4}," "]
[{"$nulls":6}," "]
[null,"5.1 Billing and meter reading performance measures"]
[]
[null,"5.1.1 Monthly billing and meter reading performance"]
[]
[null,"Monthly billing and meter reading performance\n(by meter type)",null,null,null,{"$f":"Year","v":" "},{"$nulls":6},"Minimum annual service standard"]
[{"$nulls":5},"January","February","March","April","May","June","Average monthly"]
[{"$nulls":5},"Total number","Total number","Total number","Total number","Total number","Total number"]
[null,"Date of last cycle run for the month or last date used in reports",null,null,null," "," "," "," "," "," "]
[null,"Total sites",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(F17:K17)","v":{"$error":"#DIV/0!"}}]
[null,"Total energized sites",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(F18:K18)","v":{"$error":"#DIV/0!"}}]
[null,"Sites with meters read*",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(F19:K19)","v":{"$error":"#DIV/0!"}}]
[null,"Percentage of meters read",null,null,null,{"$f":"F19/F18","v":{"$error":"#VALUE!"}},{"$f":"G19/G18","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"AVERAGE(F20:K20)","v":{"$error":"#VALUE!"}}," "]
[null,"* Cumulative metered energized sites with actual meter readings obtained by the MDM and provided to parties in accordance with Section 9 of Rule 028: Natural Gas Settlement System Code Rules"]
[]
[null,"5.1.2 Cumulative meters not read within six months, and not read within one year "]
[]
[null,"Number of sites not read within 6 months (as of June 30)",null,null," "]
[]
[null,"Number of sites not read within 1 year by reason (as of June 30)",null,null,"Sites not read","Future action"]
[null,"Total",null,null,{"$f":"SUM(E29:E38)","v":0}]
[null,"Reason 1",null,null," "]
[null,"Reason 2",null,null," "]
[null,"Reason 3",null,null," "]
[null,"Reason 4",null,null," "]
[null,"Reason 5",null,null," "]
[null,"Reason 6",null,null," "]
[null,"Reason 7",null,null," "]
[null,"Reason 8",null,null," "]
[null,"Reason 9",null,null," "]
[null,"Reason 10",null,null," "]
[]
[]
[null,"5.2 Work completion performance measures "]
[]
[null,"5.2 Work completion performance measures ",null,null,null,{"$f":"Year","v":" "}]
[{"$nulls":5},"January","February","March","April","May","June","Average monthly"]
[]
[null,"Energizations (ENCs)"]
[null,"Total number of completed connects and reconnects",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(F47:K47)","v":{"$error":"#DIV/0!"}}]
[]
[null,"De-energizations (DECs)"]
[null,"Average days from de-energization order creation to site de-energized",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(F50:K50)","v":{"$error":"#DIV/0!"}}]
[null,"Average difference in days between the date the DER request is received from the retailer and the date the retailer is notified of completion via sending of the DEC",null,null,null," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[null,"Total number of completed de-energizations",null,null,null," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
["5.4 Customer satisfaction measures"]
[]
[null,"5.5 Customer appointments"]
[]
[null,"5.5 Customer appointments",null,null,null,{"$f":"Year","v":" "},{"$nulls":13},"Minimum annual service standard "]
[{"$nulls":5},"January",null,"February",null,"March",null,"April",null,"May",null,"June",null,"Average monthly"]
[{"$nulls":5},"Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts."]
[null,"Number of pre-arranged appointments with customers",null,null,null," ",{"$f":"IF(ISERR(F60/F60),1,F60/F60)","v":1}," ",{"$f":"IF(ISERR(H60/H60),1,H60/H60)","v":1}," ",{"$f":"IF(ISERR(J60/J60),1,J60/J60)","v":1}," ",{"$f":"IF(ISERR(L60/L60),1,L60/L60)","v":1}," ",{"$f":"IF(ISERR(N60/N60),1,N60/N60)","v":1}," ",{"$f":"IF(ISERR(P60/P60),1,P60/P60)","v":1}]
[null,"Number of appointments within the pre-arranged time period",null,null,null," ",{"$f":"IF(ISERR(F61/F60),1,F61/F60)","v":1}," ",{"$f":"IF(ISERR(H61/H60),1,H61/H60)","v":1}," ",{"$f":"IF(ISERR(J61/J60),1,J61/J60)","v":1}," ",{"$f":"IF(ISERR(L61/L60),1,L61/L60)","v":1}," ",{"$f":"IF(ISERR(N61/N60),1,N61/N60)","v":1}," ",{"$f":"IF(ISERR(P61/P60),1,P61/P60)","v":1},{"$f":"AVERAGE(F61,H61,J61,L61,N61,P61)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G61,I61,K61,M61,O61,Q61)","v":1}," "]
[{"$nulls":6}," "]
[]
[null,"5.6 Emergency response time",{"$nulls":4}," "]
[]
[null,"5.6 Emergency response time",null,null,null,{"$f":"Year","v":" "},{"$nulls":6},"Minimum annual service standard"]
[{"$nulls":5},"January","February","March","April","May","June","Average monthly"]
[null,"Percentage of emergencies responded to within 60 minutes",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(F68:K68)","v":{"$error":"#DIV/0!"}}," "]
[null,"Percentage of emergencies responded to within 120 minutes (for Apex Utilities Inc. to respond to only)",null,null,null," "," ","  "," "," "," ",{"$f":"AVERAGE(F69:K69)","v":{"$error":"#DIV/0!"}}," "]
[null,"Percentage of emergency response survey results indicating \"not satisfied at all\" (for Apex Utilities Inc. to respond to only)",null,null,null," "," "," "," "," "," ",{"$error":"#DIV/0!"}," "]
[]
[]
[null,"5.7 Call answering service level"]
[]
[null,"5.7 Call answering service level",null,null,null,{"$f":"Year","v":" "},{"$nulls":6},"Minimum annual service standard "]
[{"$nulls":5},"January","February","March","April","May","June","Average monthly"]
[null,"Percentage of calls reaching an agent that are answered within 30 seconds. (For Apex Utilities Inc. the calls are emergency calls only received during normal call centre hours.)",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(F77:K77)","v":{"$error":"#DIV/0!"}}," "]

{"sheet":"Annual Report","index":2,"n_rows":92,"n_cols":32,"rows_kept":92,"cut":false,"hidden":false,"merged":[[1,3,1,5],[13,1,13,4],[47,1,47,5],[48,1,48,5],[46,1,46,18],[44,1,44,5],[43,1,43,18],[40,1,41,5],[28,5,28,13],[29,5,29,13],[30,5,30,13],[31,5,31,13],[32,5,32,13],[24,5,25,13],[65,1,65,4],[32,1,32,2],[31,1,31,2],[26,5,26,13],[27,5,27,13],[49,1,49,5],[54,1,56,4],[57,1,57,4],[58,1,58,4],[59,1,59,4],[60,1,60,4],[66,1,66,4],[62,1,64,4],[62,5,62,9],[33,5,33,13],[34,5,34,13],[35,5,35,13],[54,5,54,9],[33,1,33,2],[34,1,34,2],[22,1,22,3],[24,1,24,3],[17,1,17,4],[16,1,16,4],[26,1,26,2],[25,1,25,3],[1,16,1,17],[2,16,2,17],[3,16,3,17],[10,1,12,4],[15,1,15,4],[11,17,13,17],[14,1,14,4],[89,17,90,17],[80,17,81,17],[71,1,73,4],[75,1,75,4],[89,4,89,16],[80,4,80,16],[82,1,82,3],[83,1,83,3],[84,1,84,3],[91,1,91,3],[89,1,90,3],[80,1,81,3],[10,18,16,18],[71,31,74,31],[74,1,74,4],[73,29,74,29],[73,30,74,30],[72,29,72,30],[71,5,71,30],[40,6,40,18],[28,1,28,2],[29,1,29,2],[35,1,35,2],[30,1,30,2],[10,5,10,17],[27,1,27,2]]}
[{"$f":"'Six-month Report'!A1:T1","v":"Rule 002: Service Quality and Reliability Performance Monitoring and Reporting for Owners of Electric Distribution Systems and for Gas Distributors ReportingTemplate (Gas)"}]
["Company name:",null,null,{"$f":"Company","v":" "},{"$nulls":11},"Prepared:"," "]
[{"$f":"\"Annual Report for \" &Year","v":"Annual Report for  "},{"$nulls":14},"Modified (if applicable):"," "]
[{"$nulls":15},"Based on System Reports Generated:"," "]
[]
[]
[null,{"$f":"+'Six-month Report'!B9","v":"5.1 Billing and meter reading performance measures"}]
[]
[null,{"$f":"+'Six-month Report'!B11","v":"5.1.1 Monthly billing and meter reading performance"}]
[]
[null,"Monthly billing and meter reading performance\n",null,null,null,{"$f":"Year","v":" "},{"$nulls":12},"Minimum annual service standard"]
[{"$nulls":5},"January","February","March","April","May","June","July","August","September","October","November","December","Annual average"]
[{"$nulls":5},"Total number","Total number","Total number","Total number","Total number","Total number","Total number","Total number","Total number","Total number","Total number","Total number"]
[null,"Date of last cycle run for the month or last date used in reports",null,null,null,{"$f":"'Six-month Report'!F16","v":" "},{"$f":"'Six-month Report'!G16","v":" "},{"$f":"'Six-month Report'!H16","v":" "},{"$f":"'Six-month Report'!I16","v":" "},{"$f":"'Six-month Report'!J16","v":" "},{"$f":"'Six-month Report'!K16","v":" "}," "," "," "," "," "," "]
[null,"Total sites",null,null,null,{"$f":"'Six-month Report'!F17","v":" "},{"$f":"'Six-month Report'!G17","v":" "},{"$f":"'Six-month Report'!H17","v":" "},{"$f":"'Six-month Report'!I17","v":" "},{"$f":"'Six-month Report'!J17","v":" "},{"$f":"'Six-month Report'!K17","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(F15:Q15)","v":{"$error":"#DIV/0!"}}]
[null,"Total energized sites",null,null,null,{"$f":"'Six-month Report'!F18","v":" "},{"$f":"'Six-month Report'!G18","v":" "},{"$f":"'Six-month Report'!H18","v":" "},{"$f":"'Six-month Report'!I18","v":" "},{"$f":"'Six-month Report'!J18","v":" "},{"$f":"'Six-month Report'!K18","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(F16:Q16)","v":{"$error":"#DIV/0!"}}]
[null,"Sites with meters read*",null,null,null,{"$f":"'Six-month Report'!F19","v":" "},{"$f":"'Six-month Report'!G19","v":" "},{"$f":"'Six-month Report'!H19","v":" "},{"$f":"'Six-month Report'!I19","v":" "},{"$f":"'Six-month Report'!J19","v":" "},{"$f":"'Six-month Report'!K19","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(F17:Q17)","v":{"$error":"#DIV/0!"}}]
[null,"Percentage of meters read",null,null,null,{"$f":"'Six-month Report'!F20","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!G20","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!H20","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!I20","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!J20","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!K20","v":{"$error":"#VALUE!"}},{"$f":"L17/L16","v":{"$error":"#VALUE!"}},{"$f":"M17/M16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"'Six-month Report'!M20","v":" "}]
[null,"* Cumulative metered energized sites with actual meter readings obtained by the MDM and provided to parties in accordance with Section 9 of Rule 028: Natural Gas Settlement System Code Rules",{"$nulls":16}," "]
[]
[null,{"$f":"+'Six-month Report'!B23","v":"5.1.2 Cumulative meters not read within six months, and not read within one year "}]
[]
[null,{"$f":"\"Number of sites not read within 6 months (as of \" & Year & \" year end) \"","v":"Number of sites not read within 6 months (as of   year end) "},null,null," "]
[]
[null,{"$f":"\"Number of sites not read within 1 year by reason (as of \" & Year & \" year end) \"","v":"Number of sites not read within 1 year by reason (as of   year end) "},null,null,"Sites not read","Future action"]
[null,"Total",null,null,{"$f":"SUM(E27:E36)","v":0}]
[null,"Reason 1",null,null," "]
[null,"Reason 2",null,null," "," "]
[null,"Reason 3",null,null," "]
[null,"Reason 4",null,null," "]
[null,"Reason 5",null,null," "]
[null,"Reason 6",null,null," "]
[null,"Reason 7",null,null," "]
[null,"Reason 8",null,null," "]
[null,"Reason 9",null,null," "]
[null,"Reason 10",null,null," "]
[]
[]
[null,{"$f":"+'Six-month Report'!B41","v":"5.2 Work completion performance measures "}]
[]
[null,"5.2 Work completion performance measures ",{"$nulls":4},{"$f":"Year","v":" "}]
[{"$nulls":6},"January","February","March","April","May","June","July","August","September","October","November","December","Annual average"]
[]
[null,"Energizations (ENCs)"]
[null,"Total number of completed connects and reconnects",{"$nulls":4},{"$f":"'Six-month Report'!F47","v":" "},{"$f":"'Six-month Report'!G47","v":" "},{"$f":"'Six-month Report'!H47","v":" "},{"$f":"'Six-month Report'!I47","v":" "},{"$f":"'Six-month Report'!J47","v":" "},{"$f":"'Six-month Report'!K47","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(G45:R45)","v":{"$error":"#DIV/0!"}}]
[]
[null,"De-energizations (DECs)"]
[null,"Average days from de-energization order creation to site de-energized",{"$nulls":4},{"$f":"'Six-month Report'!F50","v":" "},{"$f":"'Six-month Report'!G50","v":" "},{"$f":"'Six-month Report'!H50","v":" "},{"$f":"'Six-month Report'!I50","v":" "},{"$f":"'Six-month Report'!J50","v":" "},{"$f":"'Six-month Report'!K50","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(G48:R48)","v":{"$error":"#DIV/0!"}}]
[null,"Average difference in days between the date the DER request is received from the retailer and the date the retailer is notified of completion via sending of the DEC",{"$nulls":4},{"$f":"'Six-month Report'!F51","v":" "},{"$f":"'Six-month Report'!G51","v":" "},{"$f":"'Six-month Report'!H51","v":" "},{"$f":"'Six-month Report'!I51","v":" "},{"$f":"'Six-month Report'!J51","v":" "},{"$f":"'Six-month Report'!K51","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(G49:R49)","v":{"$error":"#DIV/0!"}}]
[null,"Total number of completed de-energizations",{"$nulls":4},{"$f":"'Six-month Report'!F52","v":" "},{"$f":"'Six-month Report'!G52","v":" "},{"$f":"'Six-month Report'!H52","v":" "},{"$f":"'Six-month Report'!I52","v":" "},{"$f":"'Six-month Report'!J52","v":" "},{"$f":"'Six-month Report'!K52","v":" "}," "," "," "," ","  "," ",{"$error":"#DIV/0!"}]
[{"$nulls":16}," "]
[]
[null,"5.3 Worker safety performance measures"]
[]
[null,"5.3.1 All injury/illness frequency rate (AIIFR)",null,null,null," "]
[{"$nulls":5},{"$f":"Year - 4","v":{"$error":"#VALUE!"}},{"$f":"Year - 3","v":{"$error":"#VALUE!"}},{"$f":" Year -2","v":{"$error":"#VALUE!"}},{"$f":"Year -1","v":{"$error":"#VALUE!"}},{"$f":"Year","v":" "}]
[{"$nulls":5},{"$f":"((F60+F58+F59)*200000)/F61","v":{"$error":"#VALUE!"}},{"$f":"((G60+G58+G59)*200000)/G61","v":{"$error":"#VALUE!"}},{"$f":"((H60+H58+H59)*200000)/H61","v":{"$error":"#VALUE!"}},{"$f":"((I60+I58+I59)*200000)/I61","v":{"$error":"#VALUE!"}},{"$f":"((J60+J58+J59)*200000)/J61","v":{"$error":"#VALUE!"}}]
[null,"Lost time injuries",null,null,null," "," "," "," "," "]
[null,"Medical treatment injuries",null,null,null," "," "," "," "," "]
[null,"Fatalities",null,null,null," "," "," "," "," "]
[null,"Actual exposure hours",null,null,null," "," "," "," "," "]
[]
[null,"5.3.2 Motor vehicle incident frequency rate",null,null,null," "]
[{"$nulls":5},{"$f":"Year - 4","v":{"$error":"#VALUE!"}},{"$f":"Year - 3","v":{"$error":"#VALUE!"}},{"$f":" Year -2","v":{"$error":"#VALUE!"}},{"$f":"Year-1","v":{"$error":"#VALUE!"}},{"$f":"Year","v":" "}]
[{"$nulls":5},{"$f":"(F66*1000000)/F67","v":{"$error":"#VALUE!"}},{"$f":"(G66*1000000)/G67","v":{"$error":"#VALUE!"}},{"$f":"(H66*1000000)/H67","v":{"$error":"#VALUE!"}},{"$f":"(I66*1000000)/I67","v":{"$error":"#VALUE!"}},{"$f":"(J66*1000000)/J67","v":{"$error":"#VALUE!"}}]
[null,"Number of reportable vehicle incidents",null,null,null," "," "," "," "," "]
[null,"Corporate fleet vehicle actual kilometres",null,null,null," "," "," "," "," "]
[]
[]
[null,"5.5 Customer appointments"]
[]
[null,"5.5 Customer appointments",null,null,null,{"$f":"Year","v":" "},{"$nulls":25},"Minimum annual service standard "]
[{"$nulls":5},"January",null,"February",null,"March",null,"April",null,"May",null,"June",null,"July",null,"August",null,"September",null,"October",null,"November",null,"December",null,"Annual average"]
[{"$nulls":5},"Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts.","Total number"," as a % of  pre-arranged appts."]
[null,"Number of pre-arranged appointments with customers",null,null,null,{"$f":"'Six-month Report'!F60","v":" "},{"$f":"'Six-month Report'!G60","v":1},{"$f":"'Six-month Report'!H60","v":" "},{"$f":"'Six-month Report'!I60","v":1},{"$f":"'Six-month Report'!J60","v":" "},{"$f":"'Six-month Report'!K60","v":1},{"$f":"'Six-month Report'!L60","v":" "},{"$f":"'Six-month Report'!M60","v":1},{"$f":"'Six-month Report'!N60","v":" "},{"$f":"'Six-month Report'!O60","v":1},{"$f":"'Six-month Report'!P60","v":" "},{"$f":"'Six-month Report'!Q60","v":1}," ",{"$f":"IF(ISERR(R75/R75),1,R75/R75)","v":1}," ",{"$f":"IF(ISERR(T75/T75),1,T75/T75)","v":1}," ",{"$f":"IF(ISERR(V75/V75),1,V75/V75)","v":1}," ",{"$f":"IF(ISERR(X75/X75),1,X75/X75)","v":1}," ",{"$f":"IF(ISERR(Z75/Z75),1,Z75/Z75)","v":1}," ",{"$f":"IF(ISERR(AB75/AB75),1,AB75/AB75)","v":1}]
[null,"Number of appointments within the pre-arranged time period",null,null,null,{"$f":"'Six-month Report'!F61","v":" "},{"$f":"'Six-month Report'!G61","v":1},{"$f":"'Six-month Report'!H61","v":" "},{"$f":"'Six-month Report'!I61","v":1},{"$f":"'Six-month Report'!J61","v":" "},{"$f":"'Six-month Report'!K61","v":1},{"$f":"'Six-month Report'!L61","v":" "},{"$f":"'Six-month Report'!M61","v":1},{"$f":"'Six-month Report'!N61","v":" "},{"$f":"'Six-month Report'!O61","v":1},{"$f":"'Six-month Report'!P61","v":" "},{"$f":"'Six-month Report'!Q61","v":1}," ",{"$f":"IF(ISERR(R76/R75),1,R76/R75)","v":1}," ",{"$f":"IF(ISERR(T76/T75),1,T76/T75)","v":1}," ",{"$f":"IF(ISERR(V76/V75),1,V76/V75)","v":1}," ",{"$f":"IF(ISERR(X76/X75),1,X76/X75)","v":1}," ",{"$f":"IF(ISERR(Z76/Z75),1,Z76/Z75)","v":1}," ",{"$f":"IF(ISERR(AB76/AB75),1,AB76/AB75)","v":1},{"$f":"AVERAGE(AB76,Z76,X76,V76,T76,R76,P76,N76,L76,J76,H76,F76)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(AC76,AA76,Y76,W76,U76,S76,Q76,O76,M76,K76,I76,G76)","v":1},{"$f":"'Six-month Report'!T61","v":" "}]
[{"$nulls":7}," "]
[]
[null,"5.6 Emergency response time"]
[]
[null,{"$f":"+'Six-month Report'!B66","v":"5.6 Emergency response time"},null,null,{"$f":"Year","v":" "},{"$nulls":12},"Minimum annual service standard"]
[{"$nulls":4},"January","February","March","April","May","June","July","August","September","October","November","December","Annual average"]
[null,{"$f":"+'Six-month Report'!B68","v":"Percentage of emergencies responded to within 60 minutes"},null,null,{"$f":"IF(ISBLANK('Six-month Report'!F68),\"\",+'Six-month Report'!F68)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!G68),\"\",+'Six-month Report'!G68)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!H68),\"\",+'Six-month Report'!H68)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!I68),\"\",+'Six-month Report'!I68)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!J68),\"\",+'Six-month Report'!J68)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!K68),\"\",+'Six-month Report'!K68)","v":" "}," "," ",null," "," ",null,{"$f":"AVERAGE(E83:P83)","v":{"$error":"#DIV/0!"}},{"$f":"'Six-month Report'!M68","v":" "}]
[null,{"$f":"+'Six-month Report'!B69","v":"Percentage of emergencies responded to within 120 minutes (for Apex Utilities Inc. to respond to only)"},null,null,{"$f":"IF(ISBLANK('Six-month Report'!F69),\"\",+'Six-month Report'!F69)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!G69),\"\",+'Six-month Report'!G69)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!H69),\"\",+'Six-month Report'!H69)","v":"  "},{"$f":"IF(ISBLANK('Six-month Report'!I69),\"\",+'Six-month Report'!I69)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!J69),\"\",+'Six-month Report'!J69)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!K69),\"\",+'Six-month Report'!K69)","v":" "},null," "," "," "," ",null,{"$f":"AVERAGE(E84:P84)","v":{"$error":"#DIV/0!"}},{"$f":"'Six-month Report'!M69","v":" "}]
[null,{"$f":"+'Six-month Report'!B70","v":"Percentage of emergency response survey results indicating \"not satisfied at all\" (for Apex Utilities Inc. to respond to only)"},null,null,{"$f":"IF(ISBLANK('Six-month Report'!F70),\"\",+'Six-month Report'!F70)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!G70),\"\",+'Six-month Report'!G70)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!H70),\"\",+'Six-month Report'!H70)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!I70),\"\",+'Six-month Report'!I70)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!J70),\"\",+'Six-month Report'!J70)","v":" "},{"$f":"IF(ISBLANK('Six-month Report'!K70),\"\",+'Six-month Report'!K70)","v":" "},null," "," "," "," ",null,{"$error":"#DIV/0!"},{"$f":"'Six-month Report'!M70","v":" "}]
[]
[]
[null,"5.7 Call answering service level"]
[]
[null,{"$f":"+'Six-month Report'!B75","v":"5.7 Call answering service level"},null,null,{"$f":"Year","v":" "},{"$nulls":12},"Minimum annual service standard"]
[{"$nulls":4},"January","February","March","April","May","June","July","August","September","October","November","December","Annual average"]
[null,{"$f":"+'Six-month Report'!B77","v":"Percentage of calls reaching an agent that are answered within 30 seconds. (For Apex Utilities Inc. the calls are emergency calls only received during normal call centre hours.)"},null,null,{"$f":"'Six-month Report'!F77","v":" "},{"$f":"'Six-month Report'!G77","v":" "},{"$f":"'Six-month Report'!H77","v":" "},{"$f":"'Six-month Report'!I77","v":" "},{"$f":"'Six-month Report'!J77","v":" "},{"$f":"'Six-month Report'!K77","v":" "},{"$nulls":6},{"$f":"AVERAGE(E92:P92)","v":{"$error":"#DIV/0!"}},{"$f":"'Six-month Report'!M77","v":" "}]

{"sheet":"Sheet1","index":3,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+'Six-month Report'!B11&\" - \n \"&'Annual Report'!#REF!&\"\n\"&Year","v":{"$error":"#REF!"}}]
[{"$f":"\"Minimum annual service standard for \"&Year","v":"Minimum annual service standard for  "},null,null,{"$f":"+'Six-month Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+D2","v":{"$error":"#REF!"}},{"$f":"+E2","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Annual average (year-to-date)",null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+D3","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"+'Six-month Report'!B23&\"\n as of the end of each quarter in \"&Year","v":"5.1.2 Cumulative meters not read within six months, and not read within one year \n as of the end of each quarter in  "}]
[null,null,"Q1","Q2","Q3","Q4"]
["Meters not read within 3 months of quarter's end",null,{"$f":"'Six-month Report'!$E$25","v":" "},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Meters not read within a year of quarter's end",null,{"$f":"'Six-month Report'!E28","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"+'Six-month Report'!#REF! & \"- \n by Quarter, for \" &Year","v":{"$error":"#REF!"}}]
[{"$f":"+'Six-month Report'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'Six-month Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+'Six-month Report'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'Six-month Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"+'Six-month Report'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+'Six-month Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"5.1.4 Currency of tariff bill file content\n\"&Year","v":"5.1.4 Currency of tariff bill file content\n "}]
[{"$f":"\"Minimum annual service standard for \"&Year","v":"Minimum annual service standard for  "},null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+D16","v":{"$error":"#REF!"}},{"$f":"+E16","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Annual average (year-to-date)",null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+D17","v":{"$error":"#REF!"}},{"$f":"+E17","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"\"5.1.5 Tariff bill file completeness\n\"&Year","v":"5.1.5 Tariff bill file completeness\n "}]
["Percentage of tariff bill files that are sent on their scheduled publish date"]
[{"$f":"\"Minimum annual service standard for \"&Year","v":"Minimum annual service standard for  "},null,null,0.98,{"$f":"+D21","v":0.98},{"$f":"+E21","v":0.98},0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98]
["Annual average (year-to-date)",null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+D22","v":{"$error":"#REF!"}},{"$f":"+E22","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"\"5.1.6 Tariff bill file rejection response timing - \nTariff bill rejections (TBRs) responded to within one business day \n\"&Year","v":"5.1.6 Tariff bill file rejection response timing - \nTariff bill rejections (TBRs) responded to within one business day \n "}]
[]
[{"$f":"\"5.1.7 Tariff bill file dispute resolution timing - \nTariff bill disputes (TBDs) resolved within 35 and 70 calendar days \"&Year","v":"5.1.7 Tariff bill file dispute resolution timing - \nTariff bill disputes (TBDs) resolved within 35 and 70 calendar days  "}]
["Number of TBDs resolved within 35 days"]
["Number of TBDs  resolved within 70 days"]
["Number of TBDs not resolved within 70 days"]
[]
[{"$f":"\"5.2 Work completion performance measures - \nEnergizations and de-energizations by month, for \"&Year","v":"5.2 Work completion performance measures - \nEnergizations and de-energizations by month, for  "}]
["Average days from de-energize order creation to site de-energized"]
["Average days from when request is received by distributor and retailer is notified of completion"]
["Number of energize completions"]
["Number of de-energize completions"]
[]
[{"$f":"#REF!&\" \nby year\"","v":{"$error":"#REF!"}}]
[]
[{"$f":"'Annual Report'!#REF! & \" - \n5.4.1 Customer satisfaction following customer-initiated contact with the gas distributor\n\"&Year","v":{"$error":"#REF!"}}]
[]
[{"$f":"'Annual Report'!#REF!& \" - \n5.4.2 Overall customer satisfaction measures\n\"&Year","v":{"$error":"#REF!"}}]
[]
[{"$f":"'Annual Report'!#REF! & \" - \nPercentage AUC complaints/inquiries closed within each time period during \"&Year","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"5.5 Customer appointments\n\"&Year","v":"5.5 Customer appointments\n "}]
[{"$f":"\"Minimum annual service standard for \"&Year","v":"Minimum annual service standard for  "},null,null,{"$f":"+'Annual Report'!E74","v":0},{"$f":"+D46","v":0},{"$f":"+E46","v":0},0,0,0,0,0,0,0,0,0]
["Annual average (year-to-date)",null,null,{"$f":"+'Annual Report'!Q74","v":" as a % of  pre-arranged appts."},{"$f":"+D47","v":" as a % of  pre-arranged appts."},{"$f":"+E47","v":" as a % of  pre-arranged appts."}," as a % of  pre-arranged appts."," as a % of  pre-arranged appts."," as a % of  pre-arranged appts."," as a % of  pre-arranged appts."," as a % of  pre-arranged appts."," as a % of  pre-arranged appts."," as a % of  pre-arranged appts."," as a % of  pre-arranged appts."," as a % of  pre-arranged appts."]
[]
[{"$f":"\"5.6 Emergency response time\n\"&Year","v":"5.6 Emergency response time\n "}]
[{"$f":"\"Minimum annual service standard for emergencies responded to within 60 minutes for \"&Year","v":"Minimum annual service standard for emergencies responded to within 60 minutes for  "},null,null,{"$f":"+'Annual Report'!R83","v":" "},{"$f":"+D50","v":" "},{"$f":"+E50","v":" "}," "," "," "," "," "," "," "," "," "]
[{"$f":"\"Minimum annual service standard for emergencies responded to within 120 minutes for \"&Year&\" (AltaGas Utilities Inc. only)\"","v":"Minimum annual service standard for emergencies responded to within 120 minutes for   (AltaGas Utilities Inc. only)"},null,null,{"$f":"+'Annual Report'!R84","v":" "},{"$f":"+D51","v":" "}," "," "," "," "," "," "," "," "," "," "]
[{"$f":"\"Maximum annual service standard for operations survey results for \"&Year&\" (AltaGas Utilities Inc. only)\"","v":"Maximum annual service standard for operations survey results for   (AltaGas Utilities Inc. only)"},null,null,{"$f":"+'Annual Report'!R85","v":" "}," "," "," "," "," "," "," "," "," "," "," "]
["Annual average (year-to-date) for emergencies responded to within 60 minutes",null,null,{"$f":"+'Annual Report'!Q83","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Annual average (year-to-date) for emergencies responded to within 120 minutes (AltaGas Utilities Inc. only)",null,null,{"$f":"+'Annual Report'!Q84","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Annual average (year-to-date) for operation survey results  - per cent of responses indicating \"not satisfied at all\" (AltaGas Utilities Inc. only)",null,null,{"$f":"+'Annual Report'!Q85","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$f":"\"5.7 Call answering service level\n\"&Year","v":"5.7 Call answering service level\n "}]
["Percentage of calls reaching an agent that are answered within 30 seconds"]
[{"$f":"\"Minimum annual service standard for \"&Year","v":"Minimum annual service standard for  "},null,null,{"$f":"+'Annual Report'!R92","v":" "},{"$f":"+D59","v":" "},{"$f":"+E59","v":" "}," "," "," "," "," "," "," "," "," "]
["Annual average (year-to-date)",null,null,{"$f":"+'Annual Report'!Q92","v":{"$error":"#DIV/0!"}},{"$f":"+D60","v":{"$error":"#DIV/0!"}},{"$f":"+E60","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Jan",0.98,null,0.95,0.8,1,null,null,{"$f":"Year -4","v":{"$error":"#VALUE!"}}]
["Feb",0.98,"Q1",0.95,0.8,1,null,null,{"$f":"Year -3","v":{"$error":"#VALUE!"}}]
["Mar",0.98,"Q2",0.95,0.8,1,null,null,{"$f":"Year -2","v":{"$error":"#VALUE!"}}]
["Apr",0.98,"Q3",0.95,0.8,1,null,null,{"$f":"Year -1","v":{"$error":"#VALUE!"}}]
["May",0.98,"Q4",0.95,0.8,1,null,null,{"$f":"Year","v":" "}]
["Jun",0.98,null,0.95,0.8,1]
["Jul",0.98,null,0.95,0.8,1]
["Aug",0.98,null,0.95,0.8,1]
["Sep",0.98,null,0.95,0.8,1]
["Oct",0.98,null,0.95,0.8,1]
["Nov",0.98,null,0.95,0.8,1]
["Dec",0.98,null,0.95,0.8,1]
["Minimum service standard"]