{"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":35,"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":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Reporting Template for Owners of Electric Distribution Systems"]
[null,"AUC Rule 002 - Service Quality and Reliability Performance "]
[null,"Monitoring and Reporting for Owners of Electric Distribution Systems"]
[null,"and Gas Distributors"]
[]
["Instructions"]
[]
["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."]
[]
["4.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 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, take the total number of sites (based on the site cycle catalogue (SCF) count on the date you are using) and separate them into two groups: (1) sites billed and (2) sites not billed (for sites that were not billed at all during the month). The metric \"Meters not read\" (i.e., cumulative metered energized sites without MDM actual meter readings) is for billed sites that did not have actual meter readings released to market (other than customer reads) at any point in time throughout the month. This report is intended to reflect sites that were active at the end of the month. However, sites that were retired or salvaged during the month for which DCM and billing data was created may be included as long as they are consistently included or excluded. "]
["4.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."]
[]
["4.2 Work completion performance measures"]
[null,"For ENCs and DECs, report monthly numbers of those transactions sent, average number of days to send responses to retailers after they send the requests and average time to actually complete the work. Optionally, you can also report the average time from when the request comes in until when the site is ready."]
[]
["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:"]
[]
["4.3 Worker safety performance measures"]
[null,"Please provide annual numbers for lost time injuries, medical treatment injuries, fatalities, exposure hours, recordable motor vehicle incidents and the annual number of actual kilometres driven by corporate fleet vehicles for the previous five years using the definitions provided by the CEA. "]
[]
["4.4 Interruption duration and frequency"]
[null,"Please provide annual SAIFI and SAIDI in two versions: with major events included and with major events excluded. Provide SAIFI and SAIDI for the previous five years. Also, provide the service standard for the owner as identified in Appendix A of Rule 002 in the \"maximum service standard excluding major events\" column."]
[]
[null,"The three per cent worst performing circuits on the system and their SAIDI values are to be reported annually. Circuits that were formerly on the worst performing circuit list and are no longer among the three per cent worst performing are to be included on the \"Monitoring of Former Worst Performing Circuits\" list for five years after they are no longer currently worst performers. When reporting the former worst performing circuits, report the current SAIDI values and not the SAIDI that they had when they were among the worst performing circuits."]
[]
["4.5 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":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,5,1,8],[13,2,15,5],[24,1,24,6],[33,2,33,3],[34,2,34,3],[18,2,18,5],[32,6,32,14],[33,6,33,14],[34,6,34,14],[1,0,1,4],[35,6,35,14],[36,6,36,14],[43,2,44,5],[43,6,43,12],[13,6,13,12],[30,2,30,3],[30,6,30,14],[31,2,31,3],[31,6,31,14],[28,2,28,4],[28,6,29,14],[29,2,29,4],[13,13,20,13],[21,2,21,5],[37,2,37,3],[32,2,32,3],[35,2,35,3],[36,2,36,3],[46,2,46,12],[52,2,52,12],[16,2,16,5],[37,6,37,14],[38,2,38,3],[38,6,38,14],[39,2,39,3],[39,6,39,14],[20,2,20,5],[26,2,26,4],[47,2,47,5],[19,2,19,5],[17,2,17,5],[14,12,17,12],[56,2,56,5],[55,2,55,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[53,2,53,5],[54,2,54,5]]}
["Rule 002: Service Quality and Reliability Performance Monitoring and Reporting for Owners of Electric Distribution Systems and for Gas Distributors ReportingTemplate (Electric)"]
["Company name:",{"$nulls":4}," "]
[]
[null,"Reporting for year:",{"$nulls":5}," "]
[null,"Date six-month report prepared:",{"$nulls":5}," "]
[null,"Date six-month report last modified (if applicable):",{"$nulls":5}," "]
[null,"Date six-month reports generated:",{"$nulls":5}," "]
[{"$nulls":7}," "]
[]
[null,"4.1 Billing and meter reading performance measures"]
[]
[null,"4.1.1 Monthly billing and meter reading performance"]
[]
[null,null,"Monthly billing and meter reading performance\n(by meter type)",null,null,null,{"$f":"Year","v":" "},{"$nulls":6},"Minimum annual service standard"]
[{"$nulls":6},"January","February","March","April","May","June","Average monthly"]
[{"$nulls":6},"Total number","Total number","Total number","Total number","Total number","Total number"]
[null,null,"Date of last cycle run for the month or last date used in reports",null,null,null," "," "," "," "," "," "]
[null,null,"Total sites",null,null,null,{"$f":"G19+G20","v":{"$error":"#VALUE!"}},{"$f":"H19+H20","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Total sites billed",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(G19:L19)","v":{"$error":"#DIV/0!"}}]
[null,null,"Total sites not billed",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(G20:L20)","v":{"$error":"#DIV/0!"}}]
[null,null,"Sites billed with meters not read*",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(G21:L21)","v":{"$error":"#DIV/0!"}}]
[null,null,"Percentage of sites not read",null,null,null,{"$f":"G21/G19","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"AVERAGE(G22:L22)","v":{"$error":"#VALUE!"}},"< 10%"]
[null,null,"*Cumulative metered energized sites without actual meter readings provided to parties in accordance with Section 10 of Rule 021: Settlement System Code Rules"]
[]
[null,"4.1.2 Cumulative meters not read within six months, and not read within one year "]
[]
[null,null,"Number of sites not read within 6 months (as of June 30)",null,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,null,"Total",null,null,{"$f":"SUM(F31:F40)","v":0}]
[null,null,"Reason 1",null,null,"  "]
[null,null,"Reason 2",null,null," "]
[null,null,"Reason 3",null,null," "]
[null,null,"Reason 4",null,null," "]
[null,null,"Reason 5",null,null,"  "]
[null,null,"Reason 6",null,null," "]
[null,null,"Reason 7",null,null," "]
[null,null,"Reason 8",null,null," "]
[null,null,"Reason 9",null,null," "]
[null,null,"Reason 10",null,null," "]
[]
[null,"4.2 Work completion performance measures "]
[]
[null,null,"4.2 Work completion performance measures ",null,null,null,{"$f":"Year","v":" "}]
[{"$nulls":6},"January","February","March","April","May","June","Average monthly"]
[]
[null,null,"Energizations (ENCs)"]
[null,null,"Average days from energization order creation to site energized",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(G48:L48)","v":{"$error":"#DIV/0!"}}]
[null,null,"Average days from energization order creation to site ready for energization or requested energization date (optional metric)",null,null,null," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[null,null,"Average difference in days between the time when the request is received by the distributor and the retailer is notified of the completion",null,null,null," "," "," "," ","  "," ",{"$error":"#DIV/0!"}]
[null,null,"Total number of ENCs",null,null,null," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[{"$nulls":6}," "," "]
[null,null,"De-energizations (DECs)"]
[null,null,"Average days from de-energization order creation to site de-energized",null,null,null," "," "," "," "," "," ",{"$f":"AVERAGE(G54:L54)","v":{"$error":"#DIV/0!"}}]
[null,null,"Average days from de-energization order creation to site ready for de-energization or requested de-energization date (optional metric)",null,null,null," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[null,null,"Average difference in days between the time when the request is received by the distributor and the date the retailer is notified of completion",null,null,null," "," "," "," ","   "," ",{"$error":"#DIV/0!"}]
[null,null,"Total number of DECs",null,null,null," "," "," "," "," "," ",{"$error":"#DIV/0!"}]

{"sheet":"Annual Report","index":2,"n_rows":172,"n_cols":19,"rows_kept":172,"cut":false,"hidden":false,"merged":[[10,18,17,18],[76,4,76,5],[84,5,85,14],[82,2,83,14],[77,14,78,14],[77,8,77,9],[76,12,76,13],[77,12,77,13],[77,10,77,11],[76,10,76,11],[76,8,76,9],[44,1,44,18],[50,1,50,18],[41,1,42,5],[23,1,23,3],[25,1,25,3],[36,1,36,2],[77,4,77,5],[10,1,12,4],[26,1,26,3],[10,5,10,17],[84,2,85,2],[15,1,15,4],[101,5,101,14],[102,5,102,14],[103,5,103,14],[104,5,104,14],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[86,5,86,14],[87,5,87,14],[88,5,88,14],[89,5,89,14],[90,5,90,14],[91,5,91,14],[92,5,92,14],[93,5,93,14],[94,5,94,14],[95,5,95,14],[84,4,85,4],[163,8,163,9],[164,8,164,9],[165,8,165,9],[166,8,166,9],[167,8,167,9],[168,8,168,9],[169,8,169,9],[154,8,154,9],[155,8,155,9],[156,8,156,9],[157,8,157,9],[158,8,158,9],[159,8,159,9],[160,8,160,9],[161,8,161,9],[162,8,162,9],[145,8,145,9],[146,8,146,9],[147,8,147,9],[148,8,148,9],[149,8,149,9],[150,8,150,9],[151,8,151,9],[152,8,152,9],[153,8,153,9],[138,8,138,9],[139,8,139,9],[140,8,140,9],[141,8,141,9],[142,8,142,9],[133,8,133,9],[134,8,134,9],[143,8,143,9],[144,8,144,9],[107,5,107,14],[108,5,108,14],[109,5,109,14],[110,5,110,14],[111,5,111,14],[135,8,135,9],[128,10,129,10],[136,8,136,9],[137,8,137,9],[130,8,130,9],[131,8,131,9],[132,8,132,9],[98,5,98,14],[99,5,99,14],[100,5,100,14],[123,5,123,14],[124,5,124,14],[125,5,125,14],[128,3,129,3],[128,7,129,7],[76,6,76,7],[128,5,129,5],[128,4,129,4],[115,5,115,14],[116,5,116,14],[117,5,117,14],[118,5,118,14],[119,5,119,14],[121,5,121,14],[120,5,120,14],[122,5,122,14],[105,5,105,14],[106,5,106,14],[112,5,112,14],[113,5,113,14],[114,5,114,14],[0,0,0,19],[41,6,41,18],[63,1,63,4],[17,1,17,4],[16,1,16,4],[11,17,13,17],[14,1,14,4],[25,5,26,13],[128,11,129,11],[128,8,129,9],[127,7,127,11],[77,6,77,7],[76,1,78,3],[84,3,85,3],[128,2,129,2],[127,2,127,5],[1,3,1,4],[1,0,1,2],[67,1,69,4],[70,1,70,4],[71,1,71,4],[79,1,79,3],[80,1,80,3],[64,1,64,4],[13,1,13,4],[96,5,96,14],[97,5,97,14],[65,1,65,4],[48,1,48,5],[45,1,45,5],[46,1,46,5],[47,1,47,5],[54,1,54,5],[51,1,51,5],[52,1,52,5],[53,1,53,5],[59,1,61,4],[59,5,59,9],[62,1,62,4],[18,1,18,4]]}
["Rule 002: Service Quality and Reliability Performance Monitoring and Reporting for Owners of Electric Distribution Systems and for Gas Distributors ReportingTemplate (Electric)   "]
["Company name:",null,null,{"$f":"Company","v":" "},{"$nulls":10},"Prepared:"," "]
[{"$f":"\"Annual Report for \" &Year","v":"Annual Report for  "},{"$nulls":13},"Date modified (if applicable):"," "]
[{"$nulls":14},"Based on system reports generated:"," "]
[]
[]
[null,{"$f":"+'Six-month Report'!B10","v":"4.1 Billing and meter reading performance measures"}]
[]
[null,{"$f":"+'Six-month Report'!B12","v":"4.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'!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":"'Six-month Report'!L17","v":" "}," "," "," "," "," "," "]
[null,"Total sites",null,null,null,{"$f":"'Six-month Report'!G18","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!H18","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!I18","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!J18","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!K18","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!L18","v":{"$error":"#VALUE!"}},{"$f":"L16+L17","v":{"$error":"#VALUE!"}},{"$f":"M16+M17","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"AVERAGE(F15:Q15)","v":{"$error":"#VALUE!"}}]
[null,"Total sites billed",null,null,null,{"$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":"'Six-month Report'!L19","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(F16:Q16)","v":{"$error":"#DIV/0!"}}]
[null,"Total sites not billed",null,null,null,{"$f":"'Six-month Report'!G20","v":" "},{"$f":"'Six-month Report'!H20","v":" "},{"$f":"'Six-month Report'!I20","v":" "},{"$f":"'Six-month Report'!J20","v":" "},{"$f":"'Six-month Report'!K20","v":" "},{"$f":"'Six-month Report'!L20","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(F17:Q17)","v":{"$error":"#DIV/0!"}}]
[null,"Sites billed with meters not read*",null,null,null,{"$f":"'Six-month Report'!G21","v":" "},{"$f":"'Six-month Report'!H21","v":" "},{"$f":"'Six-month Report'!I21","v":" "},{"$f":"'Six-month Report'!J21","v":" "},{"$f":"'Six-month Report'!K21","v":" "},{"$f":"'Six-month Report'!L21","v":" "}," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[null,"Percentage of sites not read",null,null,null,{"$f":"'Six-month Report'!G22","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!H22","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!I22","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!J22","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!K22","v":{"$error":"#VALUE!"}},{"$f":"'Six-month Report'!L22","v":{"$error":"#VALUE!"}},{"$f":"L18/L16","v":{"$error":"#VALUE!"}},{"$f":"M18/M16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"AVERAGE(F19:Q19)","v":{"$error":"#VALUE!"}},"< 10%"]
[null,"*Cumulative metered energized sites without actual meter readings provided to parties in accordance with Section 10 of Rule 021: Settlement System Code Rules"]
[]
[null,"4.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," "]
[]
[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(E28:E37)","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'!B42","v":"4.2 Work completion performance measures "}]
[]
[null,"4.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,"Average days from energization order creation to site energized",{"$nulls":4},{"$f":"'Six-month Report'!G48","v":" "},{"$f":"'Six-month Report'!H48","v":" "},{"$f":"'Six-month Report'!I48","v":" "},{"$f":"'Six-month Report'!J48","v":" "},{"$f":"'Six-month Report'!K48","v":" "},{"$f":"'Six-month Report'!L48","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(G46:R46)","v":{"$error":"#DIV/0!"}}]
[null,"Average days from energization order creation to site ready for energization or requested energization date (optional metric)",{"$nulls":4},{"$f":"'Six-month Report'!G49","v":" "},{"$f":"'Six-month Report'!H49","v":" "},{"$f":"'Six-month Report'!I49","v":" "},{"$f":"'Six-month Report'!J49","v":" "},{"$f":"'Six-month Report'!K49","v":" "},{"$f":"'Six-month Report'!L49","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(G47:R47)","v":{"$error":"#DIV/0!"}}]
[null,"Average difference in days between the time when the request is received by the distributor and the retailer is notified of the completion",{"$nulls":4},{"$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":"'Six-month Report'!L50","v":" "}," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[null,"Total number of ENCs",{"$nulls":4},{"$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":"'Six-month Report'!L51","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'!G54","v":" "},{"$f":"'Six-month Report'!H54","v":" "},{"$f":"'Six-month Report'!I54","v":" "},{"$f":"'Six-month Report'!J54","v":" "},{"$f":"'Six-month Report'!K54","v":" "},{"$f":"'Six-month Report'!L54","v":" "}," "," "," "," "," "," ",{"$f":"AVERAGE(G52:R52)","v":{"$error":"#DIV/0!"}}]
[null,"Average days from de-energization order creation to site ready for de-energization or requested de-energization date (optional metric)",{"$nulls":4},{"$f":"'Six-month Report'!G55","v":" "},{"$f":"'Six-month Report'!H55","v":" "},{"$f":"'Six-month Report'!I55","v":" "},{"$f":"'Six-month Report'!J55","v":" "},{"$f":"'Six-month Report'!K55","v":" "},{"$f":"'Six-month Report'!L55","v":" "}," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[null,"Average difference in days between the time when the request is received by the distributor and the date the retailer is notified of completion",{"$nulls":4},{"$f":"'Six-month Report'!G56","v":" "},{"$f":"'Six-month Report'!H56","v":" "},{"$f":"'Six-month Report'!I56","v":" "},{"$f":"'Six-month Report'!J56","v":" "},{"$f":"'Six-month Report'!K56","v":"   "},{"$f":"'Six-month Report'!L56","v":" "}," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[null,"Total number of DECs",{"$nulls":4},{"$f":"'Six-month Report'!G57","v":" "},{"$f":"'Six-month Report'!H57","v":" "},{"$f":"'Six-month Report'!I57","v":" "},{"$f":"'Six-month Report'!J57","v":" "},{"$f":"'Six-month Report'!K57","v":" "},{"$f":"'Six-month Report'!L57","v":" "}," "," "," "," "," "," ",{"$error":"#DIV/0!"}]
[]
[]
[null,"4.3 Worker safety performance measures"]
[]
[null,"4.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":"((F65+F63+F64)*200000)/F66","v":{"$error":"#VALUE!"}},{"$f":"((G65+G63+G64)*200000)/G66","v":{"$error":"#VALUE!"}},{"$f":"((H65+H63+H64)*200000)/H66","v":{"$error":"#VALUE!"}},{"$f":"((I65+I63+I64)*200000)/I66","v":{"$error":"#VALUE!"}},{"$f":"((J65+J63+J64)*200000)/J66","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,"4.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":"(F71*1000000)/F72","v":{"$error":"#VALUE!"}},{"$f":"(G71*1000000)/G72","v":{"$error":"#VALUE!"}},{"$f":"(H71*1000000)/H72","v":{"$error":"#VALUE!"}},{"$f":"(I71*1000000)/I72","v":{"$error":"#VALUE!"}},{"$f":"(J71*1000000)/J72","v":{"$error":"#VALUE!"}}]
[null,"Number of reportable vehicle incidents",null,null,null," "," "," "," "," "]
[null,"Corporate fleet vehicle actual kilometres",null,null,null," "," "," "," "," "]
[]
[]
[null,"4.4 Interruption duration and frequency"]
[]
[null,"Interruption duration and frequency",null,null,{"$f":"Year-4","v":{"$error":"#VALUE!"}},null,{"$f":"Year-3","v":{"$error":"#VALUE!"}},null,{"$f":"Year-2","v":{"$error":"#VALUE!"}},null,{"$f":"Year-1","v":{"$error":"#VALUE!"}},null,{"$f":"Year","v":" "},null,{"$f":"Year","v":" "}]
[{"$nulls":4},"Annual measure",null,"Annual measure",null,"Annual measure",null,"Annual measure",null,"Annual measure",null,"Maximum service standard excluding major events"]
[{"$nulls":4},"With major events included","With major events excluded","With major events included","With major events excluded","With major events included","With major events excluded","With major events included","With major events excluded","With major events included","With major events excluded"]
[null,"SAIFI",null,null," "," "," "," "," "," "," "," "," "," "," "]
[null,"SAIDI",null,null," "," "," "," "," "," "," "," "," "," "," "]
[{"$nulls":5}," "]
[null,null," 3% worst performing circuits on the system for the year  "]
[]
[null,null,"No.","Name and/or identification","SAIDI","Factors underlying the poor performance of these circuits and describe the actions that are being considered or have been implemented to improve the reliability of these circuits"]
[]
[null,null,1,null," "]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5,null,null," "]
[null,null,6]
[null,null,7,null," "]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[null,null,23]
[null,null,24]
[null,null,25]
[null,null,26]
[null,null,27]
[null,null,28]
[null,null,29]
[null,null,30]
[null,null,31]
[null,null,32]
[null,null,33]
[null,null,34]
[null,null,35]
[null,null,36]
[null,null,37]
[null,null,38]
[null,null,39]
[null,null,40]
[]
[null,null,"Monitoring of former worst performing circuits",{"$nulls":4},{"$f":"+C128","v":"Monitoring of former worst performing circuits"}]
[null,null,"No.","Name and/or identification","Current year SAIDI","Last year on the worst performing list",null,{"$f":"+C129","v":"No."},{"$f":"+D129","v":"Name and/or identification"},null,{"$f":"+E129","v":"Current year SAIDI"},{"$f":"+F129","v":"Last year on the worst performing list"}]
[]
[null,null,1,null," ",null,null,41]
[null,null,2,null," ",null,null,42]
[null,null,3,{"$nulls":4},43]
[null,null,4,null," ",null,null,44]
[null,null,5,{"$nulls":4},45]
[null,null,6,{"$nulls":4},46]
[null,null,7,{"$nulls":4},47,null,null," "]
[null,null,8,{"$nulls":4},48]
[null,null,9,{"$nulls":4},49]
[null,null,10,{"$nulls":4},50]
[null,null,11,{"$nulls":4},51]
[null,null,12,{"$nulls":4},52]
[null,null,13,null," ",null,null,53]
[null,null,14,{"$nulls":4},54]
[null,null,15,{"$nulls":4},55]
[null,null,16,{"$nulls":4},56," "]
[null,null,17,{"$nulls":4},57]
[null,null,18,{"$nulls":4},58]
[null,null,19,{"$nulls":4},59]
[null,null,20,{"$nulls":4},60,null,null," "]
[null,null,21,{"$nulls":4},61]
[null,null,22,{"$nulls":4},62]
[null,null,23,{"$nulls":4},63]
[null,null,24,{"$nulls":4},64]
[null,null,25,null,null," ",null,65]
[null,null,26,{"$nulls":4},66]
[null,null,27,{"$nulls":4},67]
[null,null,28,{"$nulls":4},68]
[null,null,29,{"$nulls":4},69]
[null,null,30,{"$nulls":4},70]
[null,null,31,{"$nulls":4},71]
[null,null,32,{"$nulls":4},72]
[null,null,33,{"$nulls":4},73]
[null,null,34,{"$nulls":4},74]
[null,null,35,{"$nulls":4},75]
[null,null,36,{"$nulls":4},76]
[null,null,37,{"$nulls":4},77]
[null,null,38,{"$nulls":4},78]
[null,null,39,{"$nulls":4},79]
[null,null,40,{"$nulls":4},80]
[]
[null," "]

{"sheet":"Sheet1","index":3,"n_rows":82,"n_cols":16,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"\"4.1.1 Monthly billing and meter reading performance - \nPercentage of sites billed\nby month, for \"&Year","v":"4.1.1 Monthly billing and meter reading performance - \nPercentage of sites billed\nby month, for  "}]
[]
[{"$f":"\"4.1.1 Monthly billing and meter reading performance - \nPercentage of billed sites without actual (MDM) meter readings by month, for \"&Year","v":"4.1.1 Monthly billing and meter reading performance - \nPercentage of billed sites without actual (MDM) meter readings by month, for  "}]
["Maximum annual service standard",null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
["Annual average (year-to-date)",null,null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"4.1.2 Cumulative meters not read within three months \nand not read within one year  \nas of the end of each quarter in \"&Year","v":"4.1.2 Cumulative meters not read within three months \nand not read within one year  \nas of the end of each quarter in  "}]
["Meters not read within 3 months of quarter's end",null,null,null,{"$f":"+'Six-month Report'!$G$27","v":0},{"$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,null,null,{"$f":"+'Six-month Report'!$G$30","v":0},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"4.1.3 Identified meter errors  \n by quarter, \"&Year","v":"4.1.3 Identified meter errors  \n by quarter,  "}]
[{"$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":"\"4.1.4 Currency of tariff bill file content\n\"&Year","v":"4.1.4 Currency of tariff bill file content\n "}]
["Minimum annual service standard",null,null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}}]
["Annual average (year-to-date)",null,null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"4.1.5 Tariff bill file completeness\n\"&Year","v":"4.1.5 Tariff bill file completeness\n "}]
["Minimum annual service standard",null,null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}}]
["Annual average (year-to-date)",null,null,null,{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'Annual Report'!#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"4.1.6 Tariff bill file rejection response timing - \nTariff bill rejections (TBRs) responded to within one business day \"&Year","v":"4.1.6 Tariff bill file rejection response timing - \nTariff bill rejections (TBRs) responded to within one business day  "}]
[]
[{"$f":"\"4.1.7 Tariff bill file dispute resolution timing - \nTariff bill disputes (TBDs) resolved within 35 and 70 calendar days \n\"&Year","v":"4.1.7 Tariff bill file dispute resolution timing - \nTariff bill disputes (TBDs) resolved within 35 and 70 calendar days \n "}]
["Number of TBDs resolved within 35 days"]
["Number of TBDs  resolved within 70 days"]
["Number of TBDs not resolved within 70 days"]
[]
[{"$f":"\"4.2 Work completion performance measures - \nEnergizations by month, for \"&Year","v":"4.2 Work completion performance measures - \nEnergizations by month, for  "}]
["Average days from energize order creation to site energized"]
["Average days from when request is received by distributor and retailer is notified of completion"]
["Average days from energize order creation to site ready or requested energize date (optional)"]
["Number of energize completions"]
[]
[{"$f":"\"4.2 Work completion performance measures - \nDe-energizations by month, for \"&Year","v":"4.2 Work completion performance measures - \nDe-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"]
["Average days from de-energize order creation to site ready or requested date (optional)"]
["Number of de-energize completions"]
[]
[{"$f":"#REF!&\" \nby year\"","v":{"$error":"#REF!"}}]
["All injury/illness frequency rate (injuries and illnesses per 100 employees)",{"$nulls":5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Motor vehicle incident frequency rate (vehicle incidents per million km)",{"$nulls":5},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"4.4 Interruption duration and frequency - \n SAIFI by year\"","v":"4.4 Interruption duration and frequency - \n SAIFI by year"}]
[{"$f":"\"Maximum SAIFI excluding major events (\"&Year&\" service standard)\"","v":"Maximum SAIFI excluding major events (  service standard)"},{"$nulls":5},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[{"$f":" \"4.4 Interruption duration and frequency- \nSAIDI by year\"","v":"4.4 Interruption duration and frequency- \nSAIDI by year"}]
[{"$f":"\"Maximum SAIDI excluding major events (\"&Year&\" service standard)\"","v":"Maximum SAIDI excluding major events (  service standard)"},{"$nulls":5},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"4.5 Post-final adjustment mechanism (PFAM) adjustments processed\nby month, \"&Year","v":"4.5 Post-final adjustment mechanism (PFAM) adjustments processed\nby month,  "}]
["Total number of sites adjusted through PFAMs"]
["Total kWh over- or under-allocated and adjusted through PFAMs"]
[]
[{"$f":"\"4.6 Customer satisfaction measures\n4.6.1 Customer satisfaction following customer-initiated contact with the owner\n\"&Year","v":"4.6 Customer satisfaction measures\n4.6.1 Customer satisfaction following customer-initiated contact with the owner\n "}]
[]
[{"$f":"\"4.6 Customer satisfaction measures\n4.6.2 Overall customer satisfaction measures\n\"&Year","v":"4.6 Customer satisfaction measures\n4.6.2 Overall customer satisfaction measures\n "}]
[]
[{"$f":"\"4.6 Customer satisfaction measures  - \nPercentage AUC complaints/inquiries closed within each time period during \"&Year","v":"4.6 Customer satisfaction measures  - \nPercentage AUC complaints/inquiries closed within each time period during  "}]
[]
[{"$f":"#REF! & \" - \nPercentage AUC Complaints/Inquiries\nClosed in 30 Days \"","v":{"$error":"#REF!"}}]
["Jan",0.98,null,0.95,null,0.1]
["Feb",0.98,"Q1",0.95,null,0.1]
["Mar",0.98,"Q2",0.95,null,0.1]
["Apr",0.98,"Q3",0.95,null,0.1]
["May",0.98,"Q4",0.95,null,0.1]
["Jun",0.98,null,0.95,null,0.1]
["Jul",0.98,null,0.95,null,0.1]
["Aug",0.98,null,0.95,null,0.1]
["Sep",0.98,null,0.95,null,0.1]
["Oct",0.98,null,0.95,null,0.1]
["Nov",0.98,null,0.95,null,0.1]
["Dec",0.98,null,0.95,null,0.1]
["Target"]
[]
[{"$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":" "}]