{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Instruction sheet","Sample form","Regulated Electricity","Non-regulated Electricity","Regulated Natural Gas","Non-regulated Natural Gas"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Instruction sheet","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Instructions for completing the Utility Payment Deferral Program spreadsheet"]
[]
[1,"Unless specifically requested, the information to be provided is only: (1) for the current charges portion of bills deferred; and (2) for customers enrolled in the deferral program; and (3) for eligible bills issued with a payment due date no earlier than March 18, 2020 and no later than May 8, 2020 inclusive."]
[2,"Only the cells highlighted in 'Blue' are required to be completed by the applicant."]
[3,"Please provide name and contact information (phone and email) of the best person to reach in case the AUC requires further correspondence in relation to the application."]
[4,"Please note that the terms “gas service provider” (GSP) and \"electricity service provider\" (ESP) as included in the spreadsheet are as defined in the Utility Payment Deferral Program Act."]
[5,"Line 22 in the spreadsheet includes all eligible customers as defined in the Utility Payment Deferral Program Act, which is a sum of all eligible customers who are enrolled and not enrolled under the Utility Payment Deferral Program. "]

{"sheet":"Sample form","index":1,"n_rows":94,"n_cols":10,"rows_kept":94,"cut":false,"hidden":false,"merged":[[43,0,43,2],[44,0,44,3],[91,0,91,3],[13,0,14,0],[13,1,14,3],[15,0,16,0],[15,1,16,3],[17,0,18,0],[17,1,18,3],[11,0,12,0],[11,1,12,3],[0,0,0,4],[3,0,3,3],[9,0,10,0],[9,1,9,2],[10,1,10,2]]}
["Utility Payment Deferral Program spreadsheet - regulated electricity/ natural gas service providers"]
[]
[]
["Reminder: This program is for bills issued with payment due date no earlier than March 18, 2020 and no later than June 18, 2020 inclusive."]
["Current charges portion of bills deferred only"]
["Enrolled customers only"]
[" "]
["Note - Blue = Input"]
[]
["Funding period","From (Month/Day/Year)",null,"To (Month/Day/Year)"]
[null,"2020-05-09",null,"2020-06-18"]
["Legal name of electricity service provider","XXXXX"]
[]
["Organizational name (if different than Legal Name)","XXXXX"]
[]
["Contact person","XXXXX"]
[]
["Contact information (phone and email)","XXXXX"]
[]
[]
[null,null,null,"electricity/natural gas"]
[]
["Aggregate number of eligible customers billed",null,null,{"$f":"SUM(D25,D27,D29,D31)","v":75}]
[]
["Residential",null,null,37]
[]
["Small commercial",null,null,13,{"$nulls":5}," "]
[]
["Farm",null,null,25]
[]
["All other classes"]
[]
["Aggregate eligible customers billed amount (including transmission-related) ",null,null,15000]
[]
["Aggregate number of eligible customers enrolled under Utility Payment Deferral Program  ",null,null,{"$f":"SUM(D37,D39,D41,D43)","v":13},null,null," "]
[]
["Residential",null,null,8]
[]
["Small commercial",null,null,2]
[]
["Farm",null,null,3]
[]
["All other classes"]
["If \"All other classes\" is populated, please explain why customers belong to this group:"]
[]
[]
["Uptake percentage",null,null,{"$f":"D35/D23","v":0.17333333333333334}]
[]
["Number of enrolled customers dropped in reporting period",null,null,5]
[]
["Number of enrolled customers that have left in this reporting period",null,null,3]
[]
[]
["Deferred amounts of enrolled customers to be collected from the Balancing Pool/ Province",{"$nulls":5}," "]
[null,null,null," "]
["Energy ",null,null,900]
[]
["ESP's/ GSP's administration",null,null,400]
[null,null,null," "]
["Distribution-related",null,null,1100]
[]
["GST (excluding transmission-related)",null,null,120]
[]
["Total deferred amount (excluding transmission-related)",null,null,{"$f":"D56+D60+D58+D62","v":2520}]
[]
["Total funding amount you are requesting from the Balancing Pool/ Province",null,null,2520]
[]
[]
["Balancing Pool/ Province funding requested per customer class"]
[]
["Residential",null,null,1500]
[]
["Small commercial",null,null,750]
[]
["Farm",null,null,270]
[]
["All other classes"]
[null,null,null," "]
["Sum of customer classes",null,null,{"$f":"SUM(D77,D75,D73,D71)","v":2520}]
[]
[]
["For information purposes only, transmission-related deferral amounts  "]
[]
["Transmission-related deferred amount",null,null,290]
[null,null,null," "]
["GST (transmission-related) deferred amount",null,null,14.5,null," "]
[]
["Total transmission-related deferred amount",null,null,{"$f":"SUM(D84,D86)","v":304.5}]
[]
[]
[]
["* Please note, the Commission has the authority to audit a service provider’s application at any time to confirm the funding amount and any other transaction amounts associated with the Utility Payment Deferral Program. The service provider must retain any documentation necessary to support the funding amount being requested. The service provider is to make this documentation available to the Commission upon request."]
[" "]
[" "]

{"sheet":"Regulated Electricity","index":2,"n_rows":94,"n_cols":7,"rows_kept":94,"cut":false,"hidden":false,"merged":[[43,0,43,2],[44,0,44,3],[91,0,91,3],[13,0,14,0],[13,1,14,3],[15,0,16,0],[15,1,16,3],[17,0,18,0],[17,1,18,3],[11,0,12,0],[11,1,12,3],[0,0,0,4],[3,0,3,3],[9,0,10,0],[9,1,9,2],[10,1,10,2]]}
["Utility Payment Deferral Program spreadsheet - regulated electricity service providers"]
[]
[]
["Reminder: This program is for bills issued with payment due date no earlier than March 18, 2020 and no later than June 18, 2020 inclusive."]
["Current charges portion of bills deferred only"]
["Enrolled customers only"]
[" "]
["Note - Blue = Input"]
[]
["Funding period","From (Month/Day/Year)",null,"To (Month/Day/Year)"]
[]
["Legal name of electricity service provider"," "]
[]
["Organizational name (if different than Legal Name)"," "]
[]
["Contact person"," "]
[]
["Contact information (phone and email)"," "]
[]
[]
[null,null,null,"regulated electricity"]
[]
["Aggregate number of eligible customers billed",null,null,{"$f":"SUM(D25,D27,D29,D31)","v":0}]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
[]
["Aggregate eligible customers billed amount (including transmission-related) "]
[]
["Aggregate number of eligible customers enrolled under Utility Payment Deferral Program  ",null,null,{"$f":"SUM(D37,D39,D41,D43)","v":0},null,null," "]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
["If \"All other classes\" is populated, please explain why customers belong to this group:"]
[]
[]
["Uptake percentage",null,null,{"$f":"D35/D23","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Number of enrolled customers that have left in this reporting period"]
[]
[]
["Deferred amounts of enrolled customers to be collected from the Balancing Pool",{"$nulls":5}," "]
[null,null,null," "]
["Energy "]
[]
["ESP's administration"]
[]
["Distribution-related"]
[]
["GST (excluding transmission-related)"]
[]
["Total deferred amount (excluding transmission-related)",null,null,{"$f":"D56+D60+D58+D62","v":0}]
[]
["Total funding amount you are requesting from the Balancing Pool"]
[]
[]
["Balancing Pool funding requested per customer class"]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
[null,null,null," "]
["Sum of customer classes",null,null,{"$f":"SUM(D77,D75,D73,D71)","v":0}]
[]
[]
["For information purposes only, transmission-related deferral amounts  "]
[]
["Transmission-related deferred amount"]
[]
["GST (transmission-related) deferred amount",{"$nulls":4}," "]
[]
["Total transmission-related deferred amount",null,null,{"$f":"SUM(D84,D86)","v":0}]
[]
[]
[]
["* Please note, the Commission has the authority to audit a service provider’s application at any time to confirm the funding amount and any other transaction amounts associated with the Utility Payment Deferral Program. The service provider must retain any documentation necessary to support the funding amount being requested. The service provider is to make this documentation available to the Commission upon request."]
[" "]
[" "]

{"sheet":"Non-regulated Electricity","index":3,"n_rows":94,"n_cols":8,"rows_kept":94,"cut":false,"hidden":false,"merged":[[91,0,91,3],[3,0,3,3],[0,0,0,4],[15,0,16,0],[15,1,16,3],[17,0,18,0],[17,1,18,3],[13,0,14,0],[13,1,14,3],[9,0,10,0],[11,0,12,0],[11,1,12,3],[9,1,9,2],[10,1,10,2],[44,0,44,3],[43,0,43,2]]}
["Utility Payment Deferral Program spreadsheet - non-regulated electricity service providers"]
[]
[]
["Reminder: This program is for bills issued with payment due date no earlier than March 18, 2020 and no later than June 18, 2020 inclusive."]
["Current charges portion of bills deferred only"]
["Enrolled customers only"]
[" "]
["Note - Blue = Input"]
[]
["Funding period","From (Month/Day/Year)",null,"To (Month/Day/Year)"]
[{"$nulls":7}," "]
["Legal name of electricity service provider"," "]
[{"$nulls":7}," "]
["Organizational name (if different than Legal Name)"," "]
[]
["Contact person"," "]
[]
["Contact information (phone and email)"," "]
[]
[]
[null,null,null,"non-regulated electricity"]
[]
["Aggregate number of eligible customers billed",null,null,{"$f":"SUM(D25,D27,D29,D31)","v":0}]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
[]
["Aggregate eligible customers billed amount (including transmission-related) "]
[]
["Aggregate number of eligible customers enrolled under Utility Payment Deferral Program  ",null,null,{"$f":"SUM(D37,D39,D41,D43)","v":0},null,null," "]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
["If \"All other classes\" is populated, please explain why customers belong to this group:"]
[]
[]
["Uptake percentage",null,null,{"$f":"D35/D23","v":{"$error":"#DIV/0!"}}]
[]
["Number of enrolled customers dropped in reporting period"]
[]
["Number of enrolled customers that have left in this reporting period"]
[]
[]
["Deferred amounts of enrolled customers to be collected from the Balancing Pool",{"$nulls":5}," "]
[null,null,null," "]
["Energy "]
[]
["ESP's administration"]
[]
["Distribution-related"]
[]
["GST (excluding transmission-related)"]
[]
["Total deferred amount (excluding transmission-related)",null,null,{"$f":"D56+D60+D58+D62","v":0}]
[]
["Total funding amount you are requesting from the Balancing Pool"]
[]
[]
["Balancing Pool funding requested per customer class"]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[null,null,null," "]
["All other classes"]
[null,null,null," "]
["Sum of customer classes",null,null,{"$f":"SUM(D77,D75,D73,D71)","v":0}]
[]
[]
["For information purposes only, transmission-related deferral amounts  "]
[]
["Transmission-related deferred amount"]
[]
["GST (transmission-related) deferred amount",{"$nulls":4}," "]
[]
["Total transmission-related deferred amount",null,null,{"$f":"SUM(D84,D86)","v":0}]
[]
[]
[]
["* Please note, the Commission has the authority to audit a service provider’s application at any time to confirm the funding amount and any other transaction amounts associated with the Utility Payment Deferral Program. The service provider must retain any documentation necessary to support the funding amount being requested. The service provider is to make this documentation available to the Commission upon request."]
[" "]
[" "]

{"sheet":"Regulated Natural Gas","index":4,"n_rows":98,"n_cols":7,"rows_kept":98,"cut":false,"hidden":false,"merged":[[19,0,20,0],[19,1,20,3],[45,0,45,2],[46,0,46,3],[95,0,95,3],[13,0,14,0],[13,1,14,3],[15,0,16,0],[15,1,16,3],[17,0,18,0],[17,1,18,3],[11,0,12,0],[11,1,12,3],[0,0,0,4],[3,0,3,3],[9,0,10,0],[9,1,9,2],[10,1,10,2]]}
["Utility Payment Deferral Program spreadsheet - regulated natural gas service providers"]
[]
[]
["Reminder: This program is for bills issued with payment due date no earlier than March 18, 2020 and no later than June 18, 2020 inclusive."]
["Current charges portion of bills deferred only"]
["Enrolled customers only"]
[" "]
["Note - Blue = Input"]
[]
["Funding period","From (Month/Day/Year)",null,"To (Month/Day/Year)"]
[]
["Legal name of electricity service provider"," "]
[]
["Organizational name (if different than Legal Name)"," "]
[]
["Contact person"," "]
[]
["Contact information (phone and email)"," "]
[]
["Name of distribution utility"]
[]
[]
[null,null,null,"regulated natural gas"]
[]
["Aggregate number of eligible customers billed",null,null,{"$f":"SUM(D27,D29,D31,D33)","v":0}]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
[]
["Aggregate eligible customers billed amount (including transmission-related) "]
[]
["Aggregate number of eligible customers enrolled under Utility Payment Deferral Program  ",null,null,{"$f":"SUM(D39,D41,D43,D45)","v":0},null,null," "]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
["If \"All other classes\" is populated, please explain why customers belong to this group:"]
[]
[]
["Uptake percentage",null,null,{"$f":"D37/D25","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Number of enrolled customers that have left in this reporting period"]
[]
[]
["Deferred amounts of enrolled customers to be collected from the Province",{"$nulls":5}," "]
[null,null,null," "]
["Energy "]
[]
["GSP's administration"]
[]
["Federal Carbon Tax"]
[]
["Distribution-related"]
[]
["GST (excluding transmission-related)"]
[]
["Total deferred amount (excluding transmission-related)",null,null,{"$f":"SUM(D66,D64,D62,D60,D58)","v":0}]
[]
["Total funding amount you are requesting from the Province"]
[]
[]
["Province funding requested per customer class"]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[null,null,null," "]
["All other classes"]
[null,null,null," "]
["Sum of customer classes",null,null,{"$f":"SUM(D81,D79,D77,D75)","v":0}]
[]
[]
["For information purposes only, transmission-related deferral amounts  "]
[]
["Transmission-related deferred amount"]
[]
["GST (transmission-related) deferred amount",{"$nulls":4}," "]
[]
["Total transmission-related deferred amount",null,null,{"$f":"SUM(D88,D90)","v":0}]
[]
[]
[]
["* Please note, the Commission has the authority to audit a service provider’s application at any time to confirm the funding amount and any other transaction amounts associated with the Utility Payment Deferral Program. The service provider must retain any documentation necessary to support the funding amount being requested. The service provider is to make this documentation available to the Commission upon request."]
[" "]
[" "]

{"sheet":"Non-regulated Natural Gas","index":5,"n_rows":98,"n_cols":7,"rows_kept":98,"cut":false,"hidden":false,"merged":[[45,0,45,2],[46,0,46,3],[95,0,95,3],[19,0,20,0],[19,1,20,3],[13,0,14,0],[13,1,14,3],[15,0,16,0],[15,1,16,3],[17,0,18,0],[17,1,18,3],[11,0,12,0],[11,1,12,3],[0,0,0,4],[3,0,3,3],[9,0,10,0],[9,1,9,2],[10,1,10,2]]}
["Utility Payment Deferral Program spreadsheet - non-regulated natural gas service providers"]
[]
[]
["Reminder: This program is for bills issued with payment due date no earlier than March 18, 2020 and no later than June 18, 2020 inclusive."]
["Current charges portion of bills deferred only"]
["Enrolled customers only"]
[" "]
["Note - Blue = Input"]
[]
["Funding period","From (Month/Day/Year)",null,"To (Month/Day/Year)"]
[]
["Legal name of electricity service provider"," "]
[]
["Organizational name (if different than Legal Name)"," "]
[]
["Contact person"," "]
[]
["Contact information (phone and email)"," "]
[]
["Name of distribution utility"]
[]
[]
[null,null,null,"non-regulated natural gas"]
[]
["Aggregate number of eligible customers billed",null,null,{"$f":"SUM(D27,D29,D31,D33)","v":0}]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
[]
["Aggregate eligible customers billed amount (including transmission-related) ",null,null," "]
[]
["Aggregate number of eligible customers enrolled under Utility Payment Deferral Program  ",null,null,{"$f":"SUM(D39,D41,D43,D45)","v":0},null,null," "]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[]
["All other classes"]
["If \"All other classes\" is populated, please explain why customers belong to this group:"]
[]
[]
["Uptake percentage",null,null,{"$f":"D37/D25","v":{"$error":"#DIV/0!"}}]
[]
["Number of enrolled customers dropped in reporting period"]
[]
["Number of enrolled customers that have left in this reporting period"]
[]
[]
["Deferred amounts of enrolled customers to be collected from the Province",{"$nulls":5}," "]
[null,null,null," "]
["Energy "]
[]
["GSP's administration"]
[]
["Federal Carbon Tax"]
[]
["Distribution-related"]
[]
["GST (excluding transmission-related)"]
[]
["Total deferred amount (excluding transmission-related)",null,null,{"$f":"SUM(D66,D64,D62,D60,D58)","v":0}]
[]
["Total funding amount you are requesting from the Province"]
[]
[]
["Province funding requested per customer class"]
[]
["Residential"]
[]
["Small commercial"]
[]
["Farm"]
[null,null,null," "]
["All other classes"]
[null,null,null," "]
["Sum of customer classes",null,null,{"$f":"SUM(D81,D79,D77,D75)","v":0}]
[]
[]
["For information purposes only, transmission-related deferral amounts  "]
[]
["Transmission-related deferred amount"]
[]
["GST (transmission-related) deferred amount",{"$nulls":4}," "]
[]
["Total transmission-related deferred amount",null,null,{"$f":"SUM(D88,D90)","v":0}]
[]
[]
[]
["* Please note, the Commission has the authority to audit a service provider’s application at any time to confirm the funding amount and any other transaction amounts associated with the Utility Payment Deferral Program. The service provider must retain any documentation necessary to support the funding amount being requested. The service provider is to make this documentation available to the Commission upon request."]
[" "]
[" "]