{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["3. Data_Input_Sheet","4. Rate_Base","5. Utility Income","6. Taxes_PILs","7. Cost_of_Capital","8. Rev_Def_Suff","9. Rev_Reqt","10. Load Forecast","11. Cost_Allocation","12. Res_Rate_Design","13. Rate Design","1. Info","2. Table of Contents","Hidden_Data Input","Hidden Data_Rev Reqt","14. Tracking_Sheet","Sheet4"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":43,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"3. Data_Input_Sheet","index":0,"n_rows":78,"n_cols":31,"rows_kept":78,"cut":false,"hidden":false,"merged":[[87,2,88,20],[85,2,85,30],[86,2,86,30],[80,2,80,30],[81,2,81,30],[82,2,82,30],[83,2,83,30],[84,2,84,30],[11,16,12,16],[11,4,12,4],[11,8,12,8],[11,20,12,20],[11,12,12,12],[0,2,0,12],[7,4,7,20],[3,2,3,10],[1,2,1,10],[2,2,2,10],[11,24,12,24],[11,28,12,28],[11,22,12,22],[79,2,79,30],[68,2,68,30],[69,2,69,30],[70,2,70,30],[71,2,71,30],[72,2,72,30],[73,2,73,30],[74,2,74,30],[75,2,75,30],[76,2,76,30],[77,2,78,30],[11,14,12,14],[11,6,12,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[null,"Data Input Sheet (1)"]
[]
[]
[null,null,null,null,"Initial Application",null,"(2)",null,{"$f":"IF(ISBLANK(M12),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Interrogatory Responses",null,"(6)",null,{"$f":"IF(ISBLANK(M12),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Settlement Agreement",null,"(6)",null,{"$f":"IF(ISBLANK(U12),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Per Board Decision"]
[]
[]
[null,1,"Rate Base"]
[null,null,"   Gross Fixed Assets (average)",null,130756206,null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E16),0,E16+I16)","v":130756206},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E16),0,E16+I16+Q16)","v":130756206},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E16),\"\",E16+I16+Q16+Y16)","v":130756206}]
[null,null,"   Accumulated Depreciation (average)",null,-53584409,null,"(5)",null,0,null,null,null,{"$f":"IF(ISBLANK(E17),0,E17+I17)","v":-53584409},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E17),0,E17+I17+Q17)","v":-53584409},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",E17+I17+Q17+Y17)","v":-53584409}]
[null,null,"Allowance for Working Capital:"]
[null,null,"   Controllable Expenses",null,{"$f":"10312735+44000","v":10356735},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E19),0,E19+I19)","v":10356735},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E19),0,E19+I19+Q19)","v":10356735},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",E19+I19+Q19+Y19)","v":10356735}]
[null,null,"   Cost of Power",null,73507386,null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E20),0,E20+I20)","v":73507386},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E20),0,E20+I20+Q20)","v":73507386},null,null,null,null,null,null,null,73507386]
[null,null,"   Working Capital Rate (%)",null,7.4999999999999997E-2,null,"(9)",null,{"$f":"IF(ISBLANK(M21),\"\",IF(ISBLANK(E21),\"\",M21-E21))","v":""},null,null,null,null,null,"(9)",null,{"$f":"IF(ISBLANK(U21),\"\",IF(ISBLANK(M21),\"\",U21-M21))","v":""},null,null,null,null,null,"(9)",null,{"$f":"IF(ISBLANK(AC21),\"\",IF(ISBLANK(U21),\"\",AC21-U21))","v":""},null,null,null,null,null,"(9)"]
[]
[null,2,"Utility Income"]
[null,null,"Operating Revenues:"]
[null,null,"   Distribution Revenue at Current Rates",null,16063795.901793666,null,null,null,{"$f":"IF(ISBLANK(M25),\"\",IF(ISBLANK(E25),\"\",M25-E25))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U25),\"\",IF(ISBLANK(M25),\"\",U25-M25))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC25),\"\",IF(ISBLANK(U25),\"\",AC25-U25))","v":""}]
[null,null,"   Distribution Revenue at Proposed Rates",null,{"$f":"+'9. Rev_Reqt'!F28","v":18388097.712427843},null,null,null,{"$f":"IF(ISBLANK(M26),\"\",IF(ISBLANK(E26),\"\",M26-E26))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U26),\"\",IF(ISBLANK(M26),\"\",U26-M26))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC26),\"\",IF(ISBLANK(U26),\"\",AC26-U26))","v":""}]
[null,null,"   Other Revenue:"]
[null,null,"      Specific Service Charges",null,152000,null,null,null,{"$f":"IF(ISBLANK(M28),\"\",IF(ISBLANK(E28),\"\",M28-E28))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U28),\"\",IF(ISBLANK(M28),\"\",U28-M28))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC28),\"\",IF(ISBLANK(U28),\"\",AC28-U28))","v":""}]
[null,null,"      Late Payment Charges",null,210000,null,null,null,{"$f":"IF(ISBLANK(M29),\"\",IF(ISBLANK(E29),\"\",M29-E29))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U29),\"\",IF(ISBLANK(M29),\"\",U29-M29))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC29),\"\",IF(ISBLANK(U29),\"\",AC29-U29))","v":""}]
[null,null,"      Other Distribution Revenue",null,520033,null,null,null,{"$f":"IF(ISBLANK(M30),\"\",IF(ISBLANK(E30),\"\",M30-E30))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U30),\"\",IF(ISBLANK(M30),\"\",U30-M30))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC30),\"\",IF(ISBLANK(U30),\"\",AC30-U30))","v":""}]
[null,null,"      Other Income and Deductions",null,224211,null,null,null,{"$f":"IF(ISBLANK(M31),\"\",IF(ISBLANK(E31),\"\",M31-E31))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U31),\"\",IF(ISBLANK(M31),\"\",U31-M31))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC31),\"\",IF(ISBLANK(U31),\"\",AC31-U31))","v":""}]
[]
[null,null,null,"Total Revenue Offsets",1106244,null,"(7)",null,{"$f":"IF(ISBLANK(M33),\"\",IF(ISBLANK(E33),\"\",M33-E33))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U33),\"\",IF(ISBLANK(M33),\"\",U33-M33))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC33),\"\",IF(ISBLANK(U33),\"\",AC33-U33))","v":""}]
[]
[null,null,"Operating Expenses:"]
[null,null,"   OM+A Expenses",null,10312735,null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36)","v":10312735},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36+Q36)","v":10312735},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36+Q36+Y36)","v":10312735}]
[null,null,"   Depreciation/Amortization",null,4050033.3,null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37)","v":4050033.3},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37+Q37)","v":4050033.3},null,null,null,null,null,null,null,4050033.3]
[null,null,"   Property taxes",null,44000,null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38)","v":44000},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38+Q38)","v":44000},null,null,null,null,null,null,null,44000]
[null,null,"   Capital taxes",null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M48),\"\",M48)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U48),\"\",U48)","v":""},null,null,null,null,null,null,null,""]
[null,null,"   Other expenses",null,null,null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(E40),\"\",E40+I40)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E40),\"\",E40+I40+Q40)","v":""},null,null,null,null,null,null,null,""]
[]
[null,3,"Taxes/PILs"]
[null,null,"Taxable Income:"]
[null,null,null,"Adjustments required to arrive at taxable income",-2520502,null,"(3)",null,{"$f":"IF(ISBLANK(M44),\"\",IF(ISBLANK(E44),\"\",M44-E44))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U44),\"\",IF(ISBLANK(M44),\"\",U44-M44))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC44),\"\",IF(ISBLANK(U44),\"\",AC44-U44))","v":""}]
[null,null,"Utility Income Taxes and Rates:"]
[null,null,"   Income taxes (not grossed up)",null,144837,null,null,null,{"$f":"IF(ISBLANK(M46),\"\",IF(ISBLANK(E46),\"\",M46-E46))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U46),\"\",IF(ISBLANK(M46),\"\",U46-M46))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC46),\"\",IF(ISBLANK(U46),\"\",AC46-U46))","v":""}]
[null,null,"   Income taxes (grossed up)",null,{"$f":"IF(ISBLANK(E46),\"\",E46/(1-SUM(E49:E50)))","v":197057.14285714287},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M46),\"\",M46/(1-SUM(M49:M50)))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U46),\"\",U46/(1-SUM(U49:U50)))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC46),\"\",AC46/(1-SUM(AC49:AC50)))","v":""}]
[null,null,"   Capital Taxes"]
[null,null,"   Federal tax (%)",null,0.15,null,null,null,{"$f":"IF(ISBLANK(M49),\"\",IF(ISBLANK(E49),\"\",M49-E49))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U49),\"\",IF(ISBLANK(M49),\"\",U49-M49))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC49),\"\",IF(ISBLANK(U49),\"\",AC49-U49))","v":""}]
[null,null,"   Provincial tax (%)",null,0.115,null,null,null,{"$f":"IF(ISBLANK(M50),\"\",IF(ISBLANK(E50),\"\",M50-E50))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U50),\"\",IF(ISBLANK(M50),\"\",U50-M50))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC50),\"\",IF(ISBLANK(U50),\"\",AC50-U50))","v":""}]
[null,null,"Income Tax Credits",null,null,null,null,null,{"$f":"IF(ISBLANK(M51),\"\",IF(ISBLANK(E51),\"\",M51-E51))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U51),\"\",IF(ISBLANK(M51),\"\",U51-M51))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC51),\"\",IF(ISBLANK(U51),\"\",AC51-U51))","v":""}]
[null,null,"   "]
[null,4,"Capitalization/Cost of Capital"]
[null,null,"Capital Structure:"]
[null,null,"   Long-term debt Capitalization Ratio (%)",null,0.56000000000000005,null,null,null,{"$f":"IF(ISBLANK(M55),\"\",IF(ISBLANK(E55),\"\",M55-E55))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U55),\"\",IF(ISBLANK(M55),\"\",U55-M55))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC55),\"\",IF(ISBLANK(U55),\"\",AC55-U55))","v":""}]
[null,null,"   Short-term debt Capitalization Ratio (%)",null,0.04,null,"(8)",null,{"$f":"IF(ISBLANK(M56),\"\",IF(ISBLANK(E56),\"\",M56-E56))","v":""},null,null,null,null,null,"(8)",null,{"$f":"IF(ISBLANK(U56),\"\",IF(ISBLANK(M56),\"\",U56-M56))","v":""},null,null,null,null,null,"(8)",null,{"$f":"IF(ISBLANK(AC56),\"\",IF(ISBLANK(U56),\"\",AC56-U56))","v":""},null,null,null,null,null,"(8)"]
[null,null,"   Common Equity Capitalization Ratio (%)",null,0.4,null,null,null,{"$f":"IF(ISBLANK(M57),\"\",IF(ISBLANK(E57),\"\",M57-E57))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U57),\"\",IF(ISBLANK(M57),\"\",U57-M57))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC57),\"\",IF(ISBLANK(U57),\"\",AC57-U57))","v":""}]
[null,null,"   Prefered Shares Capitalization Ratio (%)",null,0,null,null,null,{"$f":"IF(ISBLANK(M58),\"\",IF(ISBLANK(E58),\"\",M58-E58))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U58),\"\",IF(ISBLANK(M58),\"\",U58-M58))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC58),\"\",IF(ISBLANK(U58),\"\",AC58-U58))","v":""}]
[null,null,null,null,{"$f":"SUM(E55:E58)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(M55:M58)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(U55:U58)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AC55:AC58)","v":0}]
[null,null,null,null,{"$f":"IF(ISBLANK(E57),\"\",IF(SUM(E55:E58)=100%,\"\",\"Capital Structure must total 100%\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M57),\"\",IF(SUM(M55:M58)=100%,\"\",\"Capital Structure must total 100%\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U57),\"\",IF(SUM(U55:U58)=100%,\"\",\"Capital Structure must total 100%\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC57),\"\",IF(SUM(AC55:AC58)=100%,\"\",\"Capital Structure must total 100%\"))","v":""}]
[null,null,"Cost of Capital"]
[null,null,"   Long-term debt Cost Rate (%)",null,3.44E-2,null,null,null,{"$f":"IF(ISBLANK(M62),\"\",IF(ISBLANK(E62),\"\",M62-E62))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U62),\"\",IF(ISBLANK(M62),\"\",U62-M62))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC62),\"\",IF(ISBLANK(U62),\"\",AC62-U62))","v":""}]
[null,null,"   Short-term debt Cost Rate (%)",null,6.2300000000000001E-2,null,null,null,{"$f":"IF(ISBLANK(M63),\"\",IF(ISBLANK(E63),\"\",M63-E63))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U63),\"\",IF(ISBLANK(M63),\"\",U63-M63))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC63),\"\",IF(ISBLANK(U63),\"\",AC63-U63))","v":""}]
[null,null,"   Common Equity Cost Rate (%)",null,9.2100000000000001E-2,null,null,null,{"$f":"IF(ISBLANK(M64),\"\",IF(ISBLANK(E64),\"\",M64-E64))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U64),\"\",IF(ISBLANK(M64),\"\",U64-M64))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC64),\"\",IF(ISBLANK(U64),\"\",AC64-U64))","v":""}]
[null,null,"   Prefered Shares Cost Rate (%)",null,0,null,null,null,{"$f":"IF(ISBLANK(M65),\"\",IF(ISBLANK(E65),\"\",M65-E65))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U65),\"\",IF(ISBLANK(M65),\"\",U65-M65))","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(AC65),\"\",IF(ISBLANK(U65),\"\",AC65-U65))","v":""}]
[]
[]
["Notes:"]
[null,"General","Data inputs are required on Sheets 3. Data from Sheet 3 will automatically complete calculations on sheets 4 through 9 (Rate Base through Revenue Requirement).  Sheets 4 through 9 do not require any inputs except for notes that the Applicant may wish to enter to support the results.  Pale green cells are available on sheets 4 through 9 to enter both footnotes beside key cells and the related text for the notes at the bottom of each sheet."]
[null,"(1)","Some Applicants may have a unique rate as a result of a lead-lag study.  The default rate for cost of service applications is 7.5%, per the letter issued by the Board on June 3, 2015."]
[null,"(2)","Data in column E is for Application as originally filed.  For updated revenue requirement as a result of interrogatory responses, technical or settlement conferences, etc., use column M and Adjustments in column I"]
[null,"(3)","Net of addbacks and deductions to arrive at taxable income."]
[null,"(4)","Average of Gross Fixed Assets at beginning and end of the Test Year"]
[null,"(5)","Average of Accumulated Depreciation at the beginning and end of the Test Year.  Enter as a negative amount."]
[null,"(6)","Select option from drop-down list by clicking on cell M12 or U12.  This column allows for the application update reflecting the end of discovery or Argument-in-Chief.  Also, the outcome of any Settlement Process can be reflected. Beginning for 2023,two intermediate stages can be shown (e.g., Interrogatory Responses and Settlement Agreement)."]
[null,"(7)","Input total revenue offsets for deriving the base revenue requirement from the service revenue requirement"]
[null,"(8)","4.0% unless an Applicant has proposed or been approved another amount."]
[null,"(9)","The default Working Capital Allowance factor is 7.5% (of Cost of Power plus controllable expenses), per the letter issued by the Board on June 3, 2015.  Alternatively, a WCA factor based on lead-lag study with supporting rationale could be provided."]

{"sheet":"4. Rate_Base","index":1,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[[41,3,41,28],[2,2,2,6],[3,2,3,6],[0,2,0,10],[1,2,1,22],[32,1,32,22],[17,6,18,6],[17,10,18,10],[17,22,18,22],[17,3,18,3],[21,3,21,22],[17,14,18,14],[17,18,18,18],[36,3,36,28],[37,3,37,28],[38,3,38,28],[39,3,39,28],[40,3,40,28],[17,24,18,24],[17,28,18,28],[33,3,33,28],[34,3,34,28],[35,3,35,28]]}
[]
[]
[]
[]
[]
[null,"Rate Base and Working Capital"]
[]
[]
[]
[null,null,null,"Rate Base"]
[null,"Line No.",null,"Particulars",null,null,"Initial Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!I12)","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\" \",'3. Data_Input_Sheet'!M12)","v":"Interrogatory Responses"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Q12),\"\",'3. Data_Input_Sheet'!Q12)","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U12),\" \",'3. Data_Input_Sheet'!U12)","v":"Settlement Agreement"},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Y12),\"\",'3. Data_Input_Sheet'!Y12)","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC12),\" \",'3. Data_Input_Sheet'!AC12)","v":"Per Board Decision"}]
[]
[null,1,null,"Gross Fixed Assets (average)","(2)",null,{"$f":"'3. Data_Input_Sheet'!E16","v":130756206},null,null,null,{"$f":"'3. Data_Input_Sheet'!I16","v":0},null,null,null,{"$f":"G13+K13","v":130756206},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q16","v":0},null,null,null,{"$f":"G13+K13+S13","v":130756206},null,{"$f":"'3. Data_Input_Sheet'!Y16","v":0},null,null,null,{"$f":"Y13+W13","v":130756206}]
[null,2,null,"Accumulated Depreciation (average)","(2)",null,{"$f":"'3. Data_Input_Sheet'!E17","v":-53584409},null,null,null,{"$f":"'3. Data_Input_Sheet'!I17","v":0},null,null,null,{"$f":"G14+K14","v":-53584409},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q17","v":0},null,null,null,{"$f":"G14+K14+S14","v":-53584409},null,{"$f":"'3. Data_Input_Sheet'!Y17","v":0},null,null,null,{"$f":"Y14+W14","v":-53584409}]
[null,3,null,"Net Fixed Assets (average)","(2)",null,{"$f":"SUM(G13:G14)","v":77171797},null,null,null,{"$f":"SUM(K13:K14)","v":0},null,null,null,{"$f":"SUM(O13:O14)","v":77171797},null,null,null,{"$f":"SUM(S13:S14)","v":0},null,null,null,{"$f":"SUM(W13:W14)","v":77171797},null,{"$f":"SUM(Y13:Y14)","v":0},null,null,null,{"$f":"SUM(AC13:AC14)","v":77171797}]
[]
[null,4,null,"Allowance for Working Capital","(1)",null,{"$f":"G30","v":6289809.0750000002},null,null,null,{"$f":"K30","v":-6289809.0750000002},null,null,null,{"$f":"O30","v":0},null,null,null,{"$f":"S30","v":0},null,null,null,{"$f":"W30","v":0},null,{"$f":"Y30","v":0},null,null,null,{"$f":"AC30","v":0}]
[null,null,null,"Total Rate Base",null,null,{"$f":"G17+G15","v":83461606.075000003},null,null,null,{"$f":"K17+K15","v":-6289809.0750000002},null,null,null,{"$f":"O17+O15","v":77171797},null,null,null,{"$f":"S17+S15","v":0},null,null,null,{"$f":"W15+W17","v":77171797},null,{"$f":"Y17+Y15","v":0},null,null,null,{"$f":"AC15+AC17","v":77171797}]
[null,5]
[null,null,"(1)","Allowance for Working Capital - Derivation"]
[]
[]
[]
[null,6,null,"Controllable Expenses",null,null,{"$f":"'3. Data_Input_Sheet'!E19","v":10356735},null,null,null,{"$f":"'3. Data_Input_Sheet'!I19","v":0},null,null,null,{"$f":"G24+K24","v":10356735},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q19","v":0},null,null,null,{"$f":"G24+K24+S24","v":10356735},null,{"$f":"'3. Data_Input_Sheet'!Y19","v":0},null,null,null,{"$f":"Y24+W24","v":10356735}]
[null,7,null,"Cost of Power",null,null,{"$f":"'3. Data_Input_Sheet'!E20","v":73507386},null,null,null,{"$f":"'3. Data_Input_Sheet'!I20","v":0},null,null,null,{"$f":"G25+K25","v":73507386},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q20","v":0},null,null,null,{"$f":"G25+K25+S25","v":73507386},null,{"$f":"'3. Data_Input_Sheet'!Y20","v":0},null,null,null,{"$f":"Y25+W25","v":73507386}]
[null,8,null,"Working Capital Base",null,null,{"$f":"SUM(G24:G25)","v":83864121},null,null,null,{"$f":"K24+K25","v":0},null,null,null,{"$f":"SUM(O24:O25)","v":83864121},null,null,null,{"$f":"S24+S25","v":0},null,null,null,{"$f":"SUM(W24:W25)","v":83864121},null,{"$f":"Y24+Y25","v":0},null,null,null,{"$f":"SUM(AC24:AC25)","v":83864121}]
[]
[null,9,null,"Working Capital Rate % ","(1)",null,{"$f":"'3. Data_Input_Sheet'!E21","v":7.4999999999999997E-2},null,null,null,{"$f":"O28-G28","v":-7.4999999999999997E-2},null,null,null,{"$f":"'3. Data_Input_Sheet'!M21","v":0},null,null,null,{"$f":"W28-O28","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U21","v":0},null,{"$f":"AC28-W28","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC21","v":0}]
[]
[null,10,null,"Working Capital Allowance",null,null,{"$f":"G26*G28","v":6289809.0750000002},null,null,null,{"$f":"O30-G30","v":-6289809.0750000002},null,null,null,{"$f":"O26*O28","v":0},null,null,null,{"$f":"W30-O30","v":0},null,null,null,{"$f":"W26*W28","v":0},null,{"$f":"AC30-W30","v":0},null,null,null,{"$f":"AC26*AC28","v":0}]
[]
[]
[null,"Notes"]
[null,"(1)",null,"Some Applicants may have a unique rate as a result of a lead-lag study.  The default rate for cost of service applications is 7.5%, per the letter issued by the Board on June 3, 2015. "]
[null,"(2)",null,"Average of opening and closing balances for the year."]

{"sheet":"5. Utility Income","index":2,"n_rows":49,"n_cols":30,"rows_kept":49,"cut":false,"hidden":false,"merged":[[52,3,52,29],[53,3,53,29],[54,3,54,29],[55,3,55,29],[56,3,56,29],[36,25,37,25],[36,29,37,29],[47,25,48,25],[47,29,48,29],[51,3,51,29],[47,9,48,9],[47,13,48,13],[47,17,48,17],[47,5,48,5],[47,21,48,21],[41,1,41,21],[36,13,37,13],[17,25,18,25],[17,29,18,29],[26,25,27,25],[26,29,27,29],[34,25,35,25],[34,29,35,29],[26,9,27,9],[34,21,35,21],[34,5,35,5],[36,21,37,21],[36,5,37,5],[36,17,37,17],[34,9,35,9],[36,9,37,9],[26,5,27,5],[26,21,27,21],[26,13,27,13],[34,13,35,13],[26,17,27,17],[34,17,35,17],[0,2,0,11],[2,2,2,7],[3,2,3,7],[1,2,1,21],[17,21,18,21],[17,13,18,13],[17,17,18,17],[7,5,7,21],[17,5,18,5],[17,9,18,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Utility Income"]
[]
[null,"Line No.",null,"Particulars                                ",null,"Initial Application   ",null,null,null,{"$f":"IF(N13=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"Interrogatory Responses"},null,null,null,{"$f":"IF(N13=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U12),\"\",'3. Data_Input_Sheet'!U12)","v":"Settlement Agreement"},null,null,null,{"$f":"IF(V13=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC12","v":"Per Board Decision"}]
[]
[null,null,null,"Operating Revenues:"]
[null,1,null,"Distribution Revenue (at Proposed Rates)",null,{"$f":"'3. Data_Input_Sheet'!E26","v":18388097.712427843},null,null,null,{"$f":"N16-F16","v":-18388097.712427843},null,null,null,{"$f":"'3. Data_Input_Sheet'!M26","v":0},null,null,null,{"$f":"V16-N16","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),'5. Utility Income'!N16,'3. Data_Input_Sheet'!U26)","v":0},null,null,null,{"$f":"AD16-V16","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC26),'5. Utility Income'!V16,'3. Data_Input_Sheet'!AC26)","v":0}]
[null,2,null,"Other Revenue","(1)",{"$f":"F48","v":1106244},null,null,null,{"$f":"N17-F17","v":-1106244},null,null,null,{"$f":"N48","v":0},null,null,null,{"$f":"V17-N17","v":0},null,null,null,{"$f":"V48","v":0},null,null,null,{"$f":"AD17-V17","v":0},null,null,null,{"$f":"AD48","v":0}]
[null,null,null,null,null,{"$f":"SUM(F16:F17)","v":19494341.712427843},null,null,null,{"$f":"SUM(J16:J17)","v":-19494341.712427843},null,null,null,{"$f":"SUM(N16:N17)","v":0},null,null,null,{"$f":"SUM(R16:R17)","v":0},null,null,null,{"$f":"SUM(V16:V17)","v":0},null,null,null,{"$f":"SUM(Z16:Z17)","v":0},null,null,null,{"$f":"SUM(AD16:AD17)","v":0}]
[null,3,null,"Total Operating Revenues"]
[]
[null,null,null,"Operating Expenses:"]
[null,4,null,"OM+A Expenses",null,{"$f":"'3. Data_Input_Sheet'!E36","v":10312735},null,null,null,{"$f":"'3. Data_Input_Sheet'!I36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M36","v":10312735},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U36","v":10312735},null,null,null,{"$f":"'3. Data_Input_Sheet'!Y36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC36","v":10312735}]
[null,5,null,"Depreciation/Amortization",null,{"$f":"'3. Data_Input_Sheet'!E37","v":4050033.3},null,null,null,{"$f":"'3. Data_Input_Sheet'!I37","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M37","v":4050033.3},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q37","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U37","v":4050033.3},null,null,null,{"$f":"'3. Data_Input_Sheet'!Y37","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC37","v":4050033.3}]
[null,6,null,"Property taxes",null,{"$f":"'3. Data_Input_Sheet'!E38","v":44000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M38","v":44000},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U38","v":44000},null,null,null,{"$f":"'3. Data_Input_Sheet'!Y38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC38","v":44000}]
[null,7,null,"Capital taxes",null,{"$f":"'6. Taxes_PILs'!G25","v":0},null,null,null,{"$f":"N25-F25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!K25","v":0},null,null,null,{"$f":"V25-N25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!O25","v":0},null,null,null,{"$f":"AD25-V25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!W25","v":0}]
[null,8,null,"Other expense",null,{"$f":"'3. Data_Input_Sheet'!E40","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!I40","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M40","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q40","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U40","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!Y40","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC40","v":""}]
[null,null,null,null,null,{"$f":"SUM(F22:F26)","v":14406768.300000001},null,null,null,{"$f":"SUM(J22:J26)","v":0},null,null,null,{"$f":"SUM(N22:N26)","v":14406768.300000001},null,null,null,{"$f":"SUM(R22:R26)","v":0},null,null,null,{"$f":"SUM(V22:V26)","v":14406768.300000001},null,null,null,{"$f":"SUM(Z22:Z26)","v":0},null,null,null,{"$f":"SUM(AD22:AD26)","v":14406768.300000001}]
[null,9,null,"Subtotal (lines 4 to 8)"]
[]
[null,10,null,"Deemed Interest Expense",null,{"$f":"'7. Cost_of_Capital'!P19","v":1815790.7017677003},null,null,null,{"$f":"N30-F30","v":-1815790.7017677003},null,null,null,{"$f":"'7. Cost_of_Capital'!P35","v":0},null,null,null,{"$f":"V30-N30","v":0},null,null,null,{"$f":"'7. Cost_of_Capital'!P51","v":0},null,null,null,{"$f":"AD30-V30","v":0},null,null,null,{"$f":"'7. Cost_of_Capital'!P67","v":0}]
[]
[null,11,null,"Total Expenses (lines 9 to 10)",null,{"$f":"F27+F30","v":16222559.001767701},null,null,null,{"$f":"J30+J27","v":-1815790.7017677003},null,null,null,{"$f":"N30+N27","v":14406768.300000001},null,null,null,{"$f":"R30+R27","v":0},null,null,null,{"$f":"V27+V30","v":14406768.300000001},null,null,null,{"$f":"Z30+Z27","v":0},null,null,null,{"$f":"AD27+AD30","v":14406768.300000001}]
[]
[null,12,null,"Utility income before income taxes",null,{"$f":"F18-(F32)","v":3271782.7106601428},null,null,null,{"$f":"J18-(J32)","v":-17678551.010660142},null,null,null,{"$f":"N18-(N32)","v":-14406768.300000001},null,null,null,{"$f":"R18-(R32)","v":0},null,null,null,{"$f":"V18-(V32)","v":-14406768.300000001},null,null,null,{"$f":"Z18-(Z32)","v":0},null,null,null,{"$f":"AD18-(AD32)","v":-14406768.300000001}]
[null,null,null,null,null,{"$f":"'6. Taxes_PILs'!G31","v":197057.14285714287},null,null,null,{"$f":"N35-F35","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!K31","v":197057.14285714287},null,null,null,{"$f":"V35-N35","v":0},null,null,null,{"$f":"IF('6. Taxes_PILs'!O31=0,N35,'6. Taxes_PILs'!O31)","v":197057.14285714287},null,null,null,{"$f":"AD35-V35","v":0},null,null,null,{"$f":"IF('6. Taxes_PILs'!S31=0,V35,'6. Taxes_PILs'!S31)","v":197057.14285714287}]
[null,13,null,"Income taxes (grossed-up)"]
[null,null,null,null,null,{"$f":"F34-F35","v":3074725.5678030001},null,null,null,{"$f":"J34-J35","v":-17678551.010660142},null,null,null,{"$f":"N34-N35","v":-14603825.442857144},null,null,null,{"$f":"R34-R35","v":0},null,null,null,{"$f":"V34-V35","v":-14603825.442857144},null,null,null,{"$f":"Z34-Z35","v":0},null,null,null,{"$f":"AD34-AD35","v":-14603825.442857144}]
[null,14,null,"Utility net income"]
[]
[]
[]
[null,"Notes"]
[]
[null,"(1)",null,"  Specific Service Charges",null,{"$f":"'3. Data_Input_Sheet'!E28","v":152000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I28","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!M28","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q28","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U28),N44,'3. Data_Input_Sheet'!U28)","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Y28","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC28),V44,'3. Data_Input_Sheet'!AC28)","v":0}]
[null,null,null,"  Late Payment Charges",null,{"$f":"'3. Data_Input_Sheet'!E29","v":210000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I29","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!M29","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q29","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U29),N45,'3. Data_Input_Sheet'!U29)","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Y29","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC29),V45,'3. Data_Input_Sheet'!AC29)","v":0}]
[null,null,null,"  Other Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E30","v":520033},null,null,null,{"$f":"'3. Data_Input_Sheet'!I30","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!M30","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q30","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U30),N46,'3. Data_Input_Sheet'!U30)","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Y30","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC30),V46,'3. Data_Input_Sheet'!AC30)","v":0}]
[null,null,null,"  Other Income and Deductions",null,{"$f":"'3. Data_Input_Sheet'!E31","v":224211},null,null,null,{"$f":"'3. Data_Input_Sheet'!I31","v":""},null,null,null,{"$f":"'3. Data_Input_Sheet'!M31","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q31","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U31),N47,'3. Data_Input_Sheet'!U31)","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!Y31","v":""},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC31),V47,'3. Data_Input_Sheet'!AC31)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F44:F47)","v":1106244},null,null,null,{"$f":"SUM(J44:J47)","v":0},null,null,null,{"$f":"SUM(N44:N47)","v":0},null,null,null,{"$f":"SUM(R44:R47)","v":0},null,null,null,{"$f":"SUM(V44:V47)","v":0},null,null,null,{"$f":"SUM(Z44:Z47)","v":0},null,null,null,{"$f":"SUM(AD44:AD47)","v":0}]
[null,null,null,"Total Revenue Offsets"]

{"sheet":"6. Taxes_PILs","index":3,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,3,0,12],[2,2,2,6],[3,2,3,6],[1,2,1,14],[43,1,43,14],[8,1,8,12],[25,6,26,6],[25,14,26,14],[15,3,15,4],[17,3,17,4],[19,3,19,4],[32,3,32,4],[52,3,52,20],[25,10,26,10],[44,3,44,14],[49,3,49,20],[50,3,50,20],[51,3,51,20],[25,18,26,18],[45,3,45,20],[46,3,46,20],[48,3,48,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Taxes/PILs"]
[]
[]
[null,"Line No.",null,"Particulars ",null,null,"Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"Interrogatory Responses"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U12),\"\",'3. Data_Input_Sheet'!U12)","v":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC12","v":"Per Board Decision"}]
[]
[null,null,null,"Determination of Taxable Income"]
[]
[null,1,null,"Utility net income before taxes",null,null,{"$f":"'7. Cost_of_Capital'!P22","v":3074725.5678030006},null,null,null,{"$f":"'7. Cost_of_Capital'!P38","v":0},null,null,null,{"$f":"'7. Cost_of_Capital'!P54","v":0},null,null,null,{"$f":"'7. Cost_of_Capital'!P70","v":0}]
[]
[null,2,null,"Adjustments required to arrive at taxable utility income",null,null,{"$f":"'3. Data_Input_Sheet'!E44","v":-2520502},null,null,null,{"$f":"'3. Data_Input_Sheet'!M44","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),K18,'3. Data_Input_Sheet'!U44)","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC44),O18,'3. Data_Input_Sheet'!AC44)","v":0}]
[]
[null,3,null,"Taxable income",null,null,{"$f":"G16+G18","v":554223.56780300057},null,null,null,{"$f":"K16+K18","v":0},null,null,null,{"$f":"O16+O18","v":0},null,null,null,{"$f":"S16+S18","v":0}]
[]
[null,null,null,"Calculation of Utility income Taxes"]
[]
[null,4,null,"Income taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E46","v":144837},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M46),'6. Taxes_PILs'!G24,'3. Data_Input_Sheet'!M46)","v":144837},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U46),'6. Taxes_PILs'!K24,'3. Data_Input_Sheet'!U46)","v":144837},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC46),'6. Taxes_PILs'!O24,'3. Data_Input_Sheet'!AC46)","v":144837}]
[null,5,null,"Capital taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E48","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M48),'6. Taxes_PILs'!G25,'3. Data_Input_Sheet'!M48)","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U48),'6. Taxes_PILs'!K25,'3. Data_Input_Sheet'!U48)","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Y48),'6. Taxes_PILs'!O25,'3. Data_Input_Sheet'!Y48)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G24:G25)","v":144837},null,null,null,{"$f":"SUM(K24:K25)","v":144837},null,null,null,{"$f":"SUM(O24:O25)","v":144837},null,null,null,{"$f":"SUM(S24:S25)","v":144837}]
[null,6,null,"Total taxes"]
[]
[null,7,null,"Gross-up of Income Taxes",null,null,{"$f":"(G24/(1-G41))-G24","v":52220.14285714287},null,null,null,{"$f":"(K24/(1-K41))-K24","v":52220.14285714287},null,null,null,{"$f":"(O24/(1-O41))-O24","v":52220.14285714287},null,null,null,{"$f":"(S24/(1-S41))-S24","v":52220.14285714287}]
[]
[null,8,null,"Grossed-up Income Taxes",null,null,{"$f":"G24+G29","v":197057.14285714287},null,null,null,{"$f":"K24+K29","v":197057.14285714287},null,null,null,{"$f":"O24+O29","v":197057.14285714287},null,null,null,{"$f":"S24+S29","v":197057.14285714287}]
[]
[null,9,null,"PILs / tax Allowance (Grossed-up Income taxes + Capital taxes)",null,null,{"$f":"G26+G29","v":197057.14285714287},null,null,null,{"$f":"K29+K26","v":197057.14285714287},null,null,null,{"$f":"O29+O26","v":197057.14285714287},null,null,null,{"$f":"S29+S26","v":197057.14285714287}]
[]
[null,10,null,"Other tax Credits",null,null,{"$f":"'3. Data_Input_Sheet'!E51","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),G35,'3. Data_Input_Sheet'!M51)","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),K35,'3. Data_Input_Sheet'!U51)","v":0},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC51),O35,'3. Data_Input_Sheet'!AC51)","v":0}]
[]
[null,null,null,"Tax Rates"]
[]
[null,11,null,"Federal tax (%)",null,null,{"$f":"'3. Data_Input_Sheet'!E49","v":0.15},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M49),G39,'3. Data_Input_Sheet'!M49)","v":0.15},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U49),K39,'3. Data_Input_Sheet'!U49)","v":0.15},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC49),O39,'3. Data_Input_Sheet'!AC49)","v":0.15}]
[null,12,null,"Provincial tax (%)",null,null,{"$f":"'3. Data_Input_Sheet'!E50","v":0.115},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M50),G40,'3. Data_Input_Sheet'!M50)","v":0.115},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U50),K40,'3. Data_Input_Sheet'!U50)","v":0.115},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC50),O40,'3. Data_Input_Sheet'!AC50)","v":0.115}]
[null,13,null,"Total tax rate (%)",null,null,{"$f":"G39+G40","v":0.26500000000000001},null,null,null,{"$f":"K39+K40","v":0.26500000000000001},null,null,null,{"$f":"O39+O40","v":0.26500000000000001},null,null,null,{"$f":"S39+S40","v":0.26500000000000001}]
[]
[]
[null,"Notes"]
[null,null,null,"Capital Taxes not applicable after July 1, 2010 (i.e. for 2011 and later test years)"]

{"sheet":"7. Cost_of_Capital","index":4,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,2,0,13],[2,2,2,13],[3,2,3,9],[1,2,1,17],[12,5,12,9],[4,1,4,13],[10,5,10,9],[83,3,83,15],[81,3,81,15],[78,3,78,15],[79,3,79,15],[80,3,80,15],[13,3,13,15],[29,3,29,15],[44,5,44,9],[28,5,28,9],[82,3,82,15],[76,1,76,15],[45,3,45,15],[60,5,60,9],[61,3,61,15]]}
[]
[]
[]
[]
[null,"Capitalization/Cost of Capital"]
[]
[]
[]
[]
[]
[null,"Line No.",null,"Particulars",null,"Capitalization Ratio",null,null,null,null,null,"Cost Rate",null,null,null,"Return"]
[]
[null,null,null,null,null,"Initial Application"]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,1,null,"  Long-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E55","v":0.56000000000000005},null,null,null,{"$f":"$J$26*F17","v":46738499.402000003},null,{"$f":"'3. Data_Input_Sheet'!E62","v":3.44E-2},null,null,null,{"$f":"L17*J17","v":1607804.3794288002}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E56","v":0.04},null,null,null,{"$f":"$J$26*F18","v":3338464.2430000002},null,{"$f":"'3. Data_Input_Sheet'!E63","v":6.2300000000000001E-2},null,null,null,{"$f":"L18*J18","v":207986.32233890003}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F17:F18)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J17:J18)","v":50076963.645000003},null,{"$f":"IF(F19=0,0,SUMPRODUCT(F17:F18,L17:L18)/F19)","v":3.6260000000000001E-2},null,null,null,{"$f":"SUM(P17:P18)","v":1815790.7017677003}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!E57","v":0.4},null,null,null,{"$f":"$J$26*F22","v":33384642.430000003},null,{"$f":"'3. Data_Input_Sheet'!E64","v":9.2100000000000001E-2},null,null,null,{"$f":"L22*J22","v":3074725.5678030006}]
[null,5,null,"  Preferred Shares",null,{"$f":"'3. Data_Input_Sheet'!E58","v":0},null,null,null,{"$f":"$J$26*F23","v":0},null,{"$f":"'3. Data_Input_Sheet'!E65","v":0},null,null,null,{"$f":"L23*J23","v":0}]
[null,6,null,"Total Equity",null,{"$f":"SUM(F22:F23)","v":0.4},null,null,null,{"$f":"SUM(J22:J23)","v":33384642.430000003},null,{"$f":"IF(F24=0,0,SUMPRODUCT(F22:F23,L22:L23)/F24)","v":9.2100000000000001E-2},null,null,null,{"$f":"SUM(P22:P23)","v":3074725.5678030006}]
[]
[null,7,null,"Total",null,{"$f":"SUM(F19,F24)","v":1},null,null,null,{"$f":"'4. Rate_Base'!G18","v":83461606.075000003},null,{"$f":"(L19*F19)+(L24*F24)","v":5.8596000000000009E-2},null,null,null,{"$f":"P19+P24","v":4890516.2695707008}]
[]
[]
[null,null,null,null,null,{"$f":"'1. Info'!AC1","v":"Interrogatory Responses"}]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,1,null,"  Long-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M55","v":0},null,null,null,{"$f":"$J$42*F33","v":0},null,{"$f":"'3. Data_Input_Sheet'!M62","v":0},null,null,null,{"$f":"L33*J33","v":0}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M56","v":0},null,null,null,{"$f":"$J$42*F34","v":0},null,{"$f":"'3. Data_Input_Sheet'!M63","v":0},null,null,null,{"$f":"L34*J34","v":0}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F33:F34)","v":0},null,null,null,{"$f":"SUM(J33:J34)","v":0},null,{"$f":"IF(F35=0,0,SUMPRODUCT(F33:F34,L33:L34)/F35)","v":0},null,null,null,{"$f":"SUM(P33:P34)","v":0}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!M57","v":0},null,null,null,{"$f":"$J$42*F38","v":0},null,{"$f":"'3. Data_Input_Sheet'!M64","v":0},null,null,null,{"$f":"L38*J38","v":0}]
[null,5,null,"  Preferred Shares",null,{"$f":"'3. Data_Input_Sheet'!M58","v":0},null,null,null,{"$f":"$J$42*F39","v":0},null,{"$f":"'3. Data_Input_Sheet'!M65","v":0},null,null,null,{"$f":"L39*J39","v":0}]
[null,6,null,"Total Equity",null,{"$f":"SUM(F38:F39)","v":0},null,null,null,{"$f":"SUM(J38:J39)","v":0},null,{"$f":"IF(F40=0,0,SUMPRODUCT(F38:F39,L38:L39)/F40)","v":0},null,null,null,{"$f":"SUM(P38:P39)","v":0}]
[]
[null,7,null,"Total",null,{"$f":"F35+F40","v":0},null,null,null,{"$f":"'4. Rate_Base'!O18","v":77171797},null,{"$f":"(L35*F35)+(L40*F40)","v":0},null,null,null,{"$f":"P35+P40","v":0}]
[]
[]
[null,null,null,null,null,{"$f":"'1. Info'!AC2","v":"Settlement Agreement"}]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,8,null,"  Long-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U55),F33,'3. Data_Input_Sheet'!U55)","v":0},null,null,null,{"$f":"$J$58*F49","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U62),L17,'3. Data_Input_Sheet'!U62)","v":3.44E-2},null,null,null,{"$f":"L49*J49","v":0}]
[null,9,null,"  Short-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U56),F34,'3. Data_Input_Sheet'!U56)","v":0},null,null,null,{"$f":"$J$58*F50","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U63),L18,'3. Data_Input_Sheet'!U63)","v":6.2300000000000001E-2},null,null,null,{"$f":"L50*J50","v":0}]
[null,10,null,"Total Debt",null,{"$f":"SUM(F49:F50)","v":0},null,null,null,{"$f":"SUM(J49:J50)","v":0},null,{"$f":"IF(F51=0,0,SUMPRODUCT(F49:F50,L49:L50)/F51)","v":0},null,null,null,{"$f":"SUM(P49:P50)","v":0}]
[]
[null,null,null,"Equity"]
[null,11,null,"  Common Equity",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U57),F38,'3. Data_Input_Sheet'!U57)","v":0},null,null,null,{"$f":"$J$58*F54","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U64),L22,'3. Data_Input_Sheet'!U64)","v":9.2100000000000001E-2},null,null,null,{"$f":"L54*J54","v":0}]
[null,12,null,"  Preferred Shares",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U58),F39,'3. Data_Input_Sheet'!U58)","v":0},null,null,null,{"$f":"$J$58*F55","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U65),L23,'3. Data_Input_Sheet'!U65)","v":0},null,null,null,{"$f":"L55*J55","v":0}]
[null,13,null,"Total Equity",null,{"$f":"SUM(F54:F55)","v":0},null,null,null,{"$f":"SUM(J54:J55)","v":0},null,{"$f":"IF(F56=0,0,SUMPRODUCT(F54:F55,L54:L55)/F56)","v":0},null,null,null,{"$f":"SUM(P54:P55)","v":0}]
[]
[null,14,null,"Total",null,{"$f":"F51+F56","v":0},null,null,null,{"$f":"'4. Rate_Base'!W18","v":77171797},null,{"$f":"(L51*F51)+(L56*F56)","v":0},null,null,null,{"$f":"P51+P56","v":0}]
[]
[]
[null,null,null,null,null,"Per Board Decision"]
[]
[null,null,null,null,null,"(%)",null,null,null,"($)",null,"(%)",null,null,null,"($)"]
[null,null,null,"Debt"]
[null,8,null,"  Long-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC55),F49,'3. Data_Input_Sheet'!AC55)","v":0},null,null,null,{"$f":"$J$74*F65","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC62),L49,'3. Data_Input_Sheet'!AC62)","v":3.44E-2},null,null,null,{"$f":"L65*J65","v":0}]
[null,9,null,"  Short-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC56),F50,'3. Data_Input_Sheet'!AC56)","v":0},null,null,null,{"$f":"$J$74*F66","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC63),L50,'3. Data_Input_Sheet'!AC63)","v":6.2300000000000001E-2},null,null,null,{"$f":"L66*J66","v":0}]
[null,10,null,"Total Debt",null,{"$f":"SUM(F65:F66)","v":0},null,null,null,{"$f":"SUM(J65:J66)","v":0},null,{"$f":"IF(F67=0,0,SUMPRODUCT(F65:F66,L65:L66)/F67)","v":0},null,null,null,{"$f":"SUM(P65:P66)","v":0}]
[]
[null,null,null,"Equity"]
[null,11,null,"  Common Equity",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC57),F54,'3. Data_Input_Sheet'!AC57)","v":0},null,null,null,{"$f":"$J$74*F70","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC64),L54,'3. Data_Input_Sheet'!AC64)","v":9.2100000000000001E-2},null,null,null,{"$f":"L70*J70","v":0}]
[null,12,null,"  Preferred Shares",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC58),F55,'3. Data_Input_Sheet'!AC58)","v":0},null,null,null,{"$f":"$J$58*F71","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC65),L55,'3. Data_Input_Sheet'!AC65)","v":0},null,null,null,{"$f":"L71*J71","v":0}]
[null,13,null,"Total Equity",null,{"$f":"SUM(F70:F71)","v":0},null,null,null,{"$f":"SUM(J70:J71)","v":0},null,{"$f":"IF(F72=0,0,SUMPRODUCT(F70:F71,L70:L71)/F72)","v":0},null,null,null,{"$f":"SUM(P70:P71)","v":0}]
[]
[null,14,null,"Total",null,{"$f":"F67+F72","v":0},null,null,null,{"$f":"'4. Rate_Base'!AC18","v":77171797},null,{"$f":"(L67*F67)+(L72*F72)","v":0},null,null,null,{"$f":"P67+P72","v":0}]
[]
[]
[null,"Notes"]

{"sheet":"8. Rev_Def_Suff","index":5,"n_rows":56,"n_cols":20,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,2,0,14],[1,2,1,14],[2,2,2,14],[3,2,3,7],[54,1,54,8],[14,3,15,3],[14,1,15,1],[12,5,12,7],[7,5,7,15],[14,7,15,7],[14,15,15,15],[14,5,15,5],[12,13,12,15],[14,13,15,13],[12,9,12,11],[14,9,15,9],[14,11,15,11],[12,17,12,19],[14,17,15,17],[14,19,15,19],[59,3,59,15],[55,3,55,15],[57,3,57,15],[58,3,58,15],[56,3,56,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('2. Table of Contents'!$F$6,\" \",'2. Table of Contents'!$G$6)","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Revenue Deficiency/Sufficiency"]
[]
[]
[null,null,null,null,null,"Initial Application",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"Interrogatory Responses"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U12),\"\",'3. Data_Input_Sheet'!U12)","v":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC12","v":"Per Board Decision"}]
[]
[null,"Line No.",null,"Particulars",null,"At Current Approved Rates",null,"At Proposed Rates",null,"At Current Approved Rates",null,"At Proposed Rates",null,"At Current Approved Rates",null,"At Proposed Rates",null,"At Current Approved Rates",null,"At Proposed Rates"]
[]
[]
[]
[null,1,null,"Revenue Deficiency from Below",null,null,null,{"$f":"F52","v":2894210.4323497075},null,null,null,{"$f":"J52","v":-2254459.3221682524},null,null,null,{"$f":"N52","v":19601045.306122452},null,null,null,{"$f":"R52","v":19601045.306122452}]
[null,2,null,"Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E25","v":16063795.901793666},null,{"$f":"'3. Data_Input_Sheet'!E26-H19","v":15493887.280078135},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M25),'3. Data_Input_Sheet'!E25,'3. Data_Input_Sheet'!M25)","v":16063795.901793666},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M26),'3. Data_Input_Sheet'!E26-L19,'3. Data_Input_Sheet'!M26-L19)","v":20642557.034596097},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U25),'3. Data_Input_Sheet'!M25,'3. Data_Input_Sheet'!U25)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),'3. Data_Input_Sheet'!M26-P19,'3. Data_Input_Sheet'!U26-P19)","v":-19601045.306122452},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC25),'3. Data_Input_Sheet'!U25,'3. Data_Input_Sheet'!AC25)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC26),'3. Data_Input_Sheet'!U26-T19,'3. Data_Input_Sheet'!AC26-T19)","v":-19601045.306122452}]
[null,3,null,"Other Operating Revenue Offsets - net",null,{"$f":"'5. Utility Income'!F48","v":1106244},null,{"$f":"'5. Utility Income'!F48","v":1106244},null,{"$f":"'5. Utility Income'!N48","v":0},null,{"$f":"J21","v":0},null,{"$f":"'5. Utility Income'!V48","v":0},null,{"$f":"'5. Utility Income'!V48","v":0},null,{"$f":"'5. Utility Income'!AD48","v":0},null,{"$f":"'5. Utility Income'!AD48","v":0}]
[null,4,null,"Total Revenue",null,{"$f":"SUM(F20:F21)","v":17170039.901793666},null,{"$f":"SUM(H19:H21)","v":19494341.712427843},null,{"$f":"SUM(J20:J21)","v":16063795.901793666},null,{"$f":"SUM(L19:L21)","v":18388097.712427843},null,{"$f":"SUM(N20:N21)","v":0},null,{"$f":"SUM(P19:P21)","v":0},null,{"$f":"SUM(R20:R21)","v":0},null,{"$f":"SUM(T19:T21)","v":0}]
[]
[null,5,null,"Operating Expenses",null,{"$f":"'5. Utility Income'!F27","v":14406768.300000001},null,{"$f":"'5. Utility Income'!F27","v":14406768.300000001},null,{"$f":"'5. Utility Income'!N27","v":14406768.300000001},null,{"$f":"'5. Utility Income'!N27","v":14406768.300000001},null,{"$f":"'5. Utility Income'!V27","v":14406768.300000001},null,{"$f":"'5. Utility Income'!V27","v":14406768.300000001},null,{"$f":"'5. Utility Income'!AD27","v":14406768.300000001},null,{"$f":"'5. Utility Income'!AD27","v":14406768.300000001}]
[null,6,null,"Deemed Interest Expense",null,{"$f":"'5. Utility Income'!F30","v":1815790.7017677003},null,{"$f":"'5. Utility Income'!F30","v":1815790.7017677003},null,{"$f":"'5. Utility Income'!N30","v":0},null,{"$f":"'5. Utility Income'!N30","v":0},null,{"$f":"'5. Utility Income'!V30","v":0},null,{"$f":"'5. Utility Income'!V30","v":0},null,{"$f":"'5. Utility Income'!AD30","v":0},null,{"$f":"'5. Utility Income'!AD30","v":0}]
[null,8,null,"Total Cost and Expenses",null,{"$f":"SUM(F24:F25)","v":16222559.001767701},null,{"$f":"SUM(H24:H25)","v":16222559.001767701},null,{"$f":"SUM(J24:J25)","v":14406768.300000001},null,{"$f":"SUM(L24:L25)","v":14406768.300000001},null,{"$f":"SUM(N24:N25)","v":14406768.300000001},null,{"$f":"SUM(P24:P25)","v":14406768.300000001},null,{"$f":"SUM(R24:R25)","v":14406768.300000001},null,{"$f":"SUM(T24:T25)","v":14406768.300000001}]
[]
[null,9,null,"Utility Income Before Income Taxes",null,{"$f":"F22-F26","v":947480.90002596565},null,{"$f":"H22-H26","v":3271782.7106601428},null,{"$f":"J22-J26","v":1657027.6017936654},null,{"$f":"L22-L26","v":3981329.4124278426},null,{"$f":"N22-N26","v":-14406768.300000001},null,{"$f":"P22-P26","v":-14406768.300000001},null,{"$f":"R22-R26","v":-14406768.300000001},null,{"$f":"T22-T26","v":-14406768.300000001}]
[null,null,null,"   "]
[null,10,null,"Tax Adjustments to Accounting               Income per 2013 PILs model",null,{"$f":"'3. Data_Input_Sheet'!E44","v":-2520502},null,{"$f":"'3. Data_Input_Sheet'!E44","v":-2520502},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-2520502},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-2520502},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Y44),'3. Data_Input_Sheet'!Q44,'3. Data_Input_Sheet'!AC44)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!AC44),'3. Data_Input_Sheet'!U44,'3. Data_Input_Sheet'!AC44)","v":0}]
[null,11,null,"Taxable Income",null,{"$f":"SUM(F28:F30)","v":-1573021.0999740344},null,{"$f":"SUM(H28:H30)","v":751280.71066014282},null,{"$f":"SUM(J28+J30)","v":-863474.39820633456},null,{"$f":"L28+L30","v":1460827.4124278426},null,{"$f":"SUM(N28+N30)","v":-14406768.300000001},null,{"$f":"P28+P30","v":-14406768.300000001},null,{"$f":"SUM(R28+R30)","v":-14406768.300000001},null,{"$f":"T28+T30","v":-14406768.300000001}]
[]
[null,12,null,"Income Tax Rate",null,{"$f":"'6. Taxes_PILs'!G41","v":0.26500000000000001},null,{"$f":"'6. Taxes_PILs'!G41","v":0.26500000000000001},null,{"$f":"'6. Taxes_PILs'!K41","v":0.26500000000000001},null,{"$f":"'6. Taxes_PILs'!K41","v":0.26500000000000001},null,{"$f":"'6. Taxes_PILs'!O41","v":0.26500000000000001},null,{"$f":"'6. Taxes_PILs'!O41","v":0.26500000000000001},null,{"$f":"'6. Taxes_PILs'!S41","v":0.26500000000000001},null,{"$f":"'6. Taxes_PILs'!S41","v":0.26500000000000001}]
[null,13,null,"Income Tax on Taxable Income",null,{"$f":"MAX(F31*F33,0)","v":0},null,{"$f":"MAX(H31*H33,0)","v":199089.38832493787},null,{"$f":"MAX(J31*J33,0)","v":0},null,{"$f":"MAX(L31*L33,0)","v":387119.26429337834},null,{"$f":"MAX(N31*N33,0)","v":0},null,{"$f":"MAX(P31*P33,0)","v":0},null,{"$f":"MAX(R31*R33,0)","v":0},null,{"$f":"MAX(T31*T33,0)","v":0}]
[null,14,null,"Income Tax Credits",null,{"$f":"'3. Data_Input_Sheet'!E51","v":0},null,{"$f":"'3. Data_Input_Sheet'!E51","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":0},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Y51),'3. Data_Input_Sheet'!Q51,'3. Data_Input_Sheet'!Y51)","v":""},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Y51),'3. Data_Input_Sheet'!Q51,'3. Data_Input_Sheet'!Y51)","v":""}]
[null,15,null,"Utility Net Income ",null,{"$f":"F28-SUM(F34:F35)","v":947480.90002596565},null,{"$f":"'5. Utility Income'!F37","v":3074725.5678030001},null,{"$f":"J28-SUM(J34:J35)","v":1657027.6017936654},null,{"$f":"'5. Utility Income'!N37","v":-14603825.442857144},null,{"$f":"N28-SUM(N34:N35)","v":-14406768.300000001},null,{"$f":"'5. Utility Income'!V37","v":-14603825.442857144},null,{"$f":"R28-SUM(R34:R35)","v":-14406768.300000001},null,{"$f":"'5. Utility Income'!AD37","v":-14603825.442857144}]
[]
[null,16,null,"Utility Rate Base",null,{"$f":"'4. Rate_Base'!G18","v":83461606.075000003},null,{"$f":"'4. Rate_Base'!G18","v":83461606.075000003},null,{"$f":"'4. Rate_Base'!O18","v":77171797},null,{"$f":"'4. Rate_Base'!O18","v":77171797},null,{"$f":"'4. Rate_Base'!W18","v":77171797},null,{"$f":"'4. Rate_Base'!W18","v":77171797},null,{"$f":"'4. Rate_Base'!AC18","v":77171797},null,{"$f":"'4. Rate_Base'!AC18","v":77171797}]
[]
[null,17,null,"Deemed Equity Portion of Rate Base ",null,{"$f":"'7. Cost_of_Capital'!J24","v":33384642.430000003},null,{"$f":"F40","v":33384642.430000003},null,{"$f":"'7. Cost_of_Capital'!J40","v":0},null,{"$f":"J40","v":0},null,{"$f":"'7. Cost_of_Capital'!J56","v":0},null,{"$f":"N40","v":0},null,{"$f":"'7. Cost_of_Capital'!J72","v":0},null,{"$f":"R40","v":0}]
[]
[null,18,null,"Income/(Equity Portion of Rate Base)",null,{"$f":"IF(F40=0,0,F36/F40)","v":2.8380741294821935E-2},null,{"$f":"IF(H40=0,0,H36/H40)","v":9.2099999999999987E-2},null,{"$f":"IF(J40=0,0,J36/J40)","v":0},null,{"$f":"IF(L40=0,0,L36/L40)","v":0},null,{"$f":"IF(N40=0,0,N36/N40)","v":0},null,{"$f":"IF(P40=0,0,P36/P40)","v":0},null,{"$f":"IF(R40=0,0,R36/R40)","v":0},null,{"$f":"IF(T40=0,0,T36/T40)","v":0}]
[null,19,null,"Target Return - Equity on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L24","v":9.2100000000000001E-2},null,{"$f":"'7. Cost_of_Capital'!L24","v":9.2100000000000001E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":0},null,{"$f":"'7. Cost_of_Capital'!L40","v":0},null,{"$f":"'7. Cost_of_Capital'!L56","v":0},null,{"$f":"'7. Cost_of_Capital'!L56","v":0},null,{"$f":"'7. Cost_of_Capital'!L72","v":0},null,{"$f":"'7. Cost_of_Capital'!L72","v":0}]
[null,20,null,"Deficiency/Sufficiency in Return on Equity",null,{"$f":"F42-F43","v":-6.371925870517807E-2},null,{"$f":"H42-H43","v":0},null,{"$f":"J42-J43","v":0},null,{"$f":"L42-L43","v":0},null,{"$f":"N42-N43","v":0},null,{"$f":"P42-P43","v":0},null,{"$f":"R42-R43","v":0},null,{"$f":"T42-T43","v":0}]
[]
[null,21,null,"Indicated Rate of Return",null,{"$f":"IF(F38=0,0,(F36+F25)/F38)","v":3.3108296517928779E-2},null,{"$f":"IF(H38=0,0,(H36+H25)/H38)","v":5.8596000000000009E-2},null,{"$f":"IF(J38=0,0,(J36+J25)/J38)","v":2.1471932314776412E-2},null,{"$f":"IF(L40=0,0,(L36+L25)/L38)","v":0},null,{"$f":"IF(N38=0,0,(N36+N25)/N38)","v":-0.18668436993892989},null,{"$f":"IF(P40=0,0,(P36+P25)/P38)","v":0},null,{"$f":"IF(R38=0,0,(R36+R25)/R38)","v":-0.18668436993892989},null,{"$f":"IF(T40=0,0,(T36+T25)/T38)","v":0}]
[null,22,null,"Requested Rate of Return on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L26","v":5.8596000000000009E-2},null,{"$f":"'7. Cost_of_Capital'!L26","v":5.8596000000000009E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":0},null,{"$f":"'7. Cost_of_Capital'!L42","v":0},null,{"$f":"'7. Cost_of_Capital'!L58","v":0},null,{"$f":"'7. Cost_of_Capital'!L58","v":0},null,{"$f":"'7. Cost_of_Capital'!L74","v":0},null,{"$f":"'7. Cost_of_Capital'!L74","v":0}]
[null,23,null,"Deficiency/Sufficiency in Rate of Return",null,{"$f":"F46-F47","v":-2.5487703482071231E-2},null,{"$f":"H46-H47","v":0},null,{"$f":"J46-J47","v":2.1471932314776412E-2},null,{"$f":"L46-L47","v":0},null,{"$f":"N46-N47","v":-0.18668436993892989},null,{"$f":"P46-P47","v":0},null,{"$f":"R46-R47","v":-0.18668436993892989},null,{"$f":"T46-T47","v":0}]
[]
[null,24,null,"Target Return on Equity",null,{"$f":"H50","v":3074725.5678030006},null,{"$f":"'7. Cost_of_Capital'!P24","v":3074725.5678030006},null,{"$f":"L50","v":0},null,{"$f":"'7. Cost_of_Capital'!P40","v":0},null,{"$f":"P50","v":0},null,{"$f":"'7. Cost_of_Capital'!P56","v":0},null,{"$f":"T50","v":0},null,{"$f":"'7. Cost_of_Capital'!P72","v":0}]
[null,25,null,"Revenue Deficiency/(Sufficiency)",null,{"$f":"F50-F36","v":2127244.6677770349}," ",{"$f":"H38*H48","v":0},null,{"$f":"J50-J36","v":-1657027.6017936654},null,{"$f":"L38*L48","v":0},null,{"$f":"N50-N36","v":14406768.300000001},null,{"$f":"P38*P48","v":0},null,{"$f":"R50-R36","v":14406768.300000001},null,{"$f":"T38*T48","v":0}]
[null,26,null,"Gross Revenue Deficiency/(Sufficiency)",null,{"$f":"F51/(1-F33)","v":2894210.4323497075},"(1)",null,null,{"$f":"J51/(1-J33)","v":-2254459.3221682524},"(1)",null,null,{"$f":"N51/(1-N33)","v":19601045.306122452},"(1)",null,null,{"$f":"R51/(1-R33)","v":19601045.306122452},"(1)"]
[]
[]
[null,"Notes:"]
[null,"(1)",null,"Revenue Deficiency/Sufficiency divided by (1 - Tax Rate)"]

{"sheet":"9. Rev_Reqt","index":6,"n_rows":51,"n_cols":20,"rows_kept":51,"cut":false,"hidden":false,"merged":[[56,3,56,20],[0,2,0,13],[0,14,0,15],[1,2,1,16],[2,2,2,16],[3,2,3,13],[7,5,7,13],[48,1,48,13],[38,3,38,15],[49,3,49,20],[50,3,50,20],[51,3,51,20],[52,3,52,20],[53,3,53,20],[54,3,54,20],[55,3,55,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Revenue Requirement"]
[]
[null,"Line No.",null,"Particulars",null,"Application   ",null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"Interrogatory Responses"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U12),\"\",'3. Data_Input_Sheet'!U12)","v":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC12","v":"Per Board Decision"}]
[]
[null,1,null,"OM&A Expenses",null,{"$f":"'5. Utility Income'!F22","v":10312735},null,null,null,{"$f":"'5. Utility Income'!N22","v":10312735},null,null,null,{"$f":"'5. Utility Income'!V22","v":10312735},null,null,null,{"$f":"'5. Utility Income'!AD22","v":10312735}]
[null,2,null,"Amortization/Depreciation",null,{"$f":"'5. Utility Income'!F23","v":4050033.3},null,null,null,{"$f":"'5. Utility Income'!N23","v":4050033.3},null,null,null,{"$f":"'5. Utility Income'!V23","v":4050033.3},null,null,null,{"$f":"'5. Utility Income'!AD23","v":4050033.3}]
[null,3,null,"Property Taxes",null,{"$f":"'5. Utility Income'!F24","v":44000},null,null,null,{"$f":"'5. Utility Income'!N24","v":44000},null,null,null,{"$f":"'5. Utility Income'!V24","v":44000},null,null,null,{"$f":"'5. Utility Income'!AD24","v":44000}]
[null,4,null,"Capital Taxes",null,{"$f":"'6. Taxes_PILs'!G25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!K25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!O25","v":0},null,null,null,{"$f":"'6. Taxes_PILs'!S25","v":0}]
[null,5,null,"Income Taxes (Grossed up)",null,{"$f":"'6. Taxes_PILs'!G33","v":197057.14285714287},null,null,null,{"$f":"'6. Taxes_PILs'!K33","v":197057.14285714287},null,null,null,{"$f":"'6. Taxes_PILs'!O33","v":197057.14285714287},null,null,null,{"$f":"'6. Taxes_PILs'!S33","v":197057.14285714287}]
[null,6,null,"Other Expenses",null,{"$f":"'5. Utility Income'!F26","v":0},null,null,null,{"$f":"'5. Utility Income'!N26","v":""},null,null,null,{"$f":"'5. Utility Income'!V26","v":""},null,null,null,{"$f":"'5. Utility Income'!AD26","v":""}]
[null,7,null,"Return"]
[null,null,null,"Deemed Interest Expense",null,{"$f":"'8. Rev_Def_Suff'!F25","v":1815790.7017677003},null,null,null,{"$f":"'8. Rev_Def_Suff'!L25","v":0},null,null,null,{"$f":"'8. Rev_Def_Suff'!P25","v":0},null,null,null,{"$f":"'8. Rev_Def_Suff'!T25","v":0}]
[null,null,null,"Return on Deemed Equity",null,{"$f":"'8. Rev_Def_Suff'!F50","v":3074725.5678030006},null,null,null,{"$f":"'8. Rev_Def_Suff'!L50","v":0},null,null,null,{"$f":"'8. Rev_Def_Suff'!P50","v":0},null,null,null,{"$f":"'8. Rev_Def_Suff'!T50","v":0}]
[]
[null,8,null,"Service Revenue Requirement (before Revenues)",null,{"$f":"SUM(F15:F23)","v":19494341.712427843},null,null,null,{"$f":"SUM(J15:J23)","v":14603825.442857144},null,null,null,{"$f":"SUM(N15:N23)","v":14603825.442857144},null,null,null,{"$f":"SUM(R15:R23)","v":14603825.442857144}]
[]
[null,9,null,"Revenue Offsets",null,{"$f":"'3. Data_Input_Sheet'!E33","v":1106244},null,null,null,{"$f":"'3. Data_Input_Sheet'!M33","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U33","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!AC33","v":0}]
[null,10,null,"Base Revenue Requirement",null,{"$f":"F25-F27","v":18388097.712427843},null,null,null,{"$f":"J25-J27","v":14603825.442857144},null,null,null,{"$f":"N25-N27","v":14603825.442857144},null,null,null,{"$f":"R25-R27","v":14603825.442857144}]
[null,null,null,"(excluding Tranformer Owership Allowance credit adjustment)"]
[]
[null,11,null,"Distribution revenue",null,{"$f":"'5. Utility Income'!F16","v":18388097.712427843},null,null,null,{"$f":"'5. Utility Income'!N16","v":0},null,null,null,{"$f":"'5. Utility Income'!V16","v":0},null,null,null,{"$f":"'5. Utility Income'!AD16","v":0}]
[null,12,null,"Other revenue",null,{"$f":"'5. Utility Income'!F17","v":1106244},null,null,null,{"$f":"'5. Utility Income'!N17","v":0},null,null,null,{"$f":"'5. Utility Income'!V17","v":0},null,null,null,{"$f":"'5. Utility Income'!AD17","v":0}]
[]
[null,13,null,"Total revenue",null,{"$f":"SUM(F31:F32)","v":19494341.712427843},null,null,null,{"$f":"SUM(J31:J32)","v":0},null,null,null,{"$f":"SUM(N31:N32)","v":0},null,null,null,{"$f":"SUM(R31:R32)","v":0}]
[]
[null,14,null,"Difference (Total Revenue Less Distribution Revenue Requirement before Revenues)",null,{"$f":"F34-F25","v":0},null,"(1)",null,{"$f":"J34-J25","v":-14603825.442857144},null,"(1)",null,{"$f":"N34-N25","v":-14603825.442857144},null,"(1)",null,{"$f":"R34-R25","v":-14603825.442857144},null,"(1)"]
[]
[]
[null,null,null,"Summary Table of Revenue Requirement and Revenue Deficiency/Sufficiency"]
[]
[null,null,null,null,null,{"$f":"F13","v":"Application   "},null,null,null,{"$f":"J13","v":"Interrogatory Responses"},null,"Δ% (2)",null,{"$f":"N13","v":"Settlement Agreement"},null,"Δ% (2)",null,{"$f":"R13","v":"Per Board Decision"},null,"Δ% (2)"]
[null,null,null,"Service Revenue Requirement",null,{"$f":"F25","v":19494341.712427843},null,null,null,{"$f":"J25","v":14603825.442857144},null,{"$f":"IF($F42=0,\" \",(J42-$F42)/$F42)","v":-0.25086850029169977},null,{"$f":"N25","v":14603825.442857144},null,{"$f":"IF($F42=0,\" \",(N42-$F42)/$F42)","v":-0.25086850029169977},null,{"$f":"R25","v":14603825.442857144},null,{"$f":"IF($F42=0,\" \",(R42-$F42)/$F42)","v":-0.25086850029169977}]
[null,null,null,"Grossed-Up Revenue Deficiency/(Sufficiency)",null,{"$f":"'8. Rev_Def_Suff'!F52","v":2894210.4323497075},null,null,null,{"$f":"'8. Rev_Def_Suff'!J52","v":-2254459.3221682524},null,{"$f":"IF($F43=0,\" \",(J43-$F43)/$F43)","v":-1.7789548738299363},null,{"$f":"'8. Rev_Def_Suff'!N52","v":19601045.306122452},null,{"$f":"IF($F43=0,\" \",(N43-$F43)/$F43)","v":5.7725017804628163},null,{"$f":"'8. Rev_Def_Suff'!R52","v":19601045.306122452},null,{"$f":"IF($F43=0,\" \",(R43-$F43)/$F43)","v":5.7725017804628163}]
[]
[null,null,null,"Base Revenue Requirement (to be recovered from Distribution Rates)",null,{"$f":"F28","v":18388097.712427843},null,null,null,{"$f":"J28","v":14603825.442857144},null,{"$f":"IF($F45=0,\" \",(J45-$F45)/$F45)","v":-0.20580009573328772},null,{"$f":"N28","v":14603825.442857144},null,{"$f":"IF($F45=0,\" \",(N45-$F45)/$F45)","v":-0.20580009573328772},null,{"$f":"R28","v":14603825.442857144},null,{"$f":"IF($F45=0,\" \",(R45-$F45)/$F45)","v":-0.20580009573328772}]
[null,null,null,"Revenue Deficiency/(Sufficiency) Associated with Base Revenue Requirement",null,{"$f":"'3. Data_Input_Sheet'!E26-'3. Data_Input_Sheet'!E25","v":2324301.8106341772},null,null,null,{"$f":"'3. Data_Input_Sheet'!M26-'3. Data_Input_Sheet'!M25","v":0},null,{"$f":"IF($F46=0,\" \",(J46-$F46)/$F46)","v":-1},null,{"$f":"'3. Data_Input_Sheet'!U26-'3. Data_Input_Sheet'!U25","v":0},null,{"$f":"IF($F46=0,\" \",(N46-$F46)/$F46)","v":-1},null,{"$f":"'3. Data_Input_Sheet'!AC26-'3. Data_Input_Sheet'!AC25","v":0},null,{"$f":"IF($F46=0,\" \",(R46-$F46)/$F46)","v":-1}]
[]
[]
[null,"Notes"]
[null,"(1)",null,"Line 11 - Line 8"]
[null,"(2)",null,"Percentage Change Relative to Initial Application"]

{"sheet":"10. Load Forecast","index":7,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":false,"merged":[[63,2,63,27],[58,2,58,27],[59,2,59,27],[60,2,60,27],[61,2,61,27],[62,2,62,27],[13,1,13,21],[25,3,26,3],[23,5,23,9],[23,11,23,15],[23,17,23,21],[15,1,15,21],[17,1,17,21],[21,5,21,9],[19,1,19,21],[23,23,23,27],[54,2,54,27],[55,2,55,27],[56,2,56,27],[57,2,57,27]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Load Forecast Summary"]
[]
[null,"This spreadsheet provides a summary of the customer and load forecast on which the test year revenue requirement is derived. The amounts serve as the denominators for deriving the rates to recover the test year revenue requirement for purposes of this RRWF."]
[]
[null,"The information to be input is inclusive of any adjustments to kWh and kW to reflect the impacts of CDM programs up to and including CDM programs planned to be executed in the test year. i.e., the load forecast adjustments determined in Appendix 2-I should be incorporated into the entries. The inputs should correspond with the summary of the Load Forecast for the Test Year in Appendix 2-IB and in Exhibit 3 of the application."]
[]
[null,"Appendix 2-IB is still required to be filled out, as it also provides a year-over-year variance analysis of demand growth andf trends from historical actuals to the Bridge and Test Year forecasts."]
[]
[null,null,null,"Stage in Process:",null,"Initial Application"]
[]
[null,null,null,"Customer Class",null,{"$f":"'3. Data_Input_Sheet'!E12","v":"Initial Application"},null,null,null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\" \",'3. Data_Input_Sheet'!M12)","v":"Interrogatory Responses"},null,null,null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","v":"Settlement Agreement"},null,null,null,null,null,{"$f":"'3. Data_Input_Sheet'!AC12","v":"Per Board Decision"}]
[]
[null,null,null,"Input the name of each customer class.",null,"Customer / Connections",null,"kWh",null,"kW/kVA (1)",null,{"$f":"F26","v":"Customer / Connections"},null,{"$f":"H26","v":"kWh"},null,"kW/kVA (1)",null,{"$f":"F26","v":"Customer / Connections"},null,{"$f":"H26","v":"kWh"},null,"kW/kVA (1)",null,{"$f":"L26","v":"Customer / Connections"},null,{"$f":"N26","v":"kWh"},null,"kW/kVA (1)"]
[null,null,null,null,null,"Test Year average or mid-year",null,"Annual",null,"Annual",null,{"$f":"F27","v":"Test Year average or mid-year"},null,{"$f":"H27","v":"Annual"},null,{"$f":"J27","v":"Annual"},null,{"$f":"F27","v":"Test Year average or mid-year"},null,{"$f":"H27","v":"Annual"},null,{"$f":"J27","v":"Annual"},null,{"$f":"L27","v":"Test Year average or mid-year"},null,{"$f":"N27","v":"Annual"},null,{"$f":"P27","v":"Annual"}]
[]
[null,1,null,"Residential",null,29454.272853389488,null,284634105.84651595]
[null,2,null,"GS<50",null,2097.7595691542842,null,70835308.350547194]
[null,3,null,"GS>50",null,234.51571426576166,null,197879032.77457455,null,698414.05914110714]
[null,4,null,"Embedded Distributor",null,4,null,34244754.121491976,null,90871.252838385451]
[null,5,null,"Street Light",null,2828.2632585547244,null,2433600.5248393081,null,7372.4856525959021]
[null,6,null,"Sentinel Light",null,215.94544680445384,null,262327.78873529832,null,716.34708302108174]
[null,7,null,"USL",null,122.76948833843458,null,1383562.2195668274]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[]
[null,null,null,"Total",null,null,null,{"$f":"SUM(H29:H48)","v":591672691.62627113},null,{"$f":"SUM(J29:J48)","v":797374.14471510949},null,null,null,{"$f":"SUM(N29:N48)","v":0},null,{"$f":"SUM(P29:P48)","v":0},null,null,null,{"$f":"SUM(T29:T48)","v":0},null,{"$f":"SUM(V29:V48)","v":0}]
[]
[null,"Notes:"]
[]
[null,"(1)","Input kW or kVA for those customer classes for which billing is based on demand (kW or kVA) versus energy consumption (kWh)"]

{"sheet":"11. Cost_Allocation","index":8,"n_rows":152,"n_cols":15,"rows_kept":152,"cut":false,"hidden":false,"merged":[[85,2,85,12],[151,2,151,12],[123,2,123,12],[93,6,94,6],[86,2,86,12],[87,2,87,12],[88,2,88,12],[119,2,119,12],[90,2,90,12],[126,6,126,8],[125,4,125,8],[120,2,120,12],[121,2,121,12],[13,1,13,12],[56,2,56,12],[21,2,21,12],[19,4,19,6],[15,1,15,12],[52,2,52,12],[53,2,53,12],[54,2,54,12],[50,4,50,6],[23,4,24,4],[23,8,24,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cost Allocation and Rate Design"]
[]
[null,"This spreadsheet replaces Appendix 2-P and provides a summary of the results from the Cost Allocation spreadsheet, and is used in the determination of the class revenue requirement and, hence, ultimately, the determination of rates from customers in all classes to recover the revenue requirement."]
[]
[]
[]
[null,null,"Stage in Application Process:",null,{"$f":"IF(ISBLANK('10. Load Forecast'!F22),\"\",'10. Load Forecast'!F22)","v":"Initial Application"}]
[]
[null,"A)","Allocated Costs"]
[]
[null,null,"Name of Customer Class (3)",null,"Costs Allocated from Previous Study (1)",null,"%",null,"Allocated Class Revenue Requirement (1)",null,"%"]
[null,null,"From Sheet 10. Load Forecast"]
[null,null,null,null,null,null,null,null,"(7A)"]
[]
[null,1,{"$f":"IF(ISBLANK('10. Load Forecast'!D29),\"\",'10. Load Forecast'!D29)","v":"Residential"},null,9625174.4773035366,null,{"$f":"IF(E$49=0,\"\",E28/E$49)","v":0.74194109898931038},null,14684863.808037223,null,{"$f":"IF(I$49=0,\"\",I28/I$49)","v":0.75328854666115985}]
[null,2,{"$f":"IF(ISBLANK('10. Load Forecast'!D30),\"\",'10. Load Forecast'!D30)","v":"GS<50"},null,1467051.5156213513,null,{"$f":"IF(E$49=0,\"\",E29/E$49)","v":0.11308530731995305},null,2078386.778201622,null,{"$f":"IF(I$49=0,\"\",I29/I$49)","v":0.10661487746957397}]
[null,3,{"$f":"IF(ISBLANK('10. Load Forecast'!D31),\"\",'10. Load Forecast'!D31)","v":"GS>50"},null,1555011.375733909,null,0.1198655517126905,null,2201557.7019894957,null,0.11293316869678294]
[null,4,{"$f":"IF(ISBLANK('10. Load Forecast'!D32),\"\",'10. Load Forecast'!D32)","v":"Embedded Distributor"},null,98707.53083042764,null,7.6087113096536124E-3,null,117414.35839306729,null,6.0229970497007968E-3]
[null,5,{"$f":"IF(ISBLANK('10. Load Forecast'!D33),\"\",'10. Load Forecast'!D33)","v":"Street Light"},null,155290.35124441574,null,1.1970307046007475E-2,null,305066.3703650721,null,1.5648970652470472E-2]
[null,6,{"$f":"IF(ISBLANK('10. Load Forecast'!D34),\"\",'10. Load Forecast'!D34)","v":"Sentinel Light"},null,21704.156827304938,null,1.6730300325525354E-3,null,56492.103935938838,null,2.8978719467894357E-3]
[null,7,{"$f":"IF(ISBLANK('10. Load Forecast'!D35),\"\",'10. Load Forecast'!D35)","v":"USL"},null,50023.66243905422,null,3.8559935898325368E-3,null,50559.889737723614,null,2.5935675235226373E-3]
[null,8,{"$f":"IF(ISBLANK('10. Load Forecast'!D36),\"\",'10. Load Forecast'!D36)","v":""},null,null,null,0,null,null,null,0]
[null,9,{"$f":"IF(ISBLANK('10. Load Forecast'!D37),\"\",'10. Load Forecast'!D37)","v":""},null,null,null,0,null,null,null,0]
[null,10,{"$f":"IF(ISBLANK('10. Load Forecast'!D38),\"\",'10. Load Forecast'!D38)","v":""},null,null,null,0,null,null,null,0]
[null,11,{"$f":"IF(ISBLANK('10. Load Forecast'!D39),\"\",'10. Load Forecast'!D39)","v":""},null,null,null,0,null,null,null,0]
[null,12,{"$f":"IF(ISBLANK('10. Load Forecast'!D40),\"\",'10. Load Forecast'!D40)","v":""},null,null,null,0,null,null,null,0]
[null,13,{"$f":"IF(ISBLANK('10. Load Forecast'!D41),\"\",'10. Load Forecast'!D41)","v":""},null,null,null,0,null,null,null,0]
[null,14,{"$f":"IF(ISBLANK('10. Load Forecast'!D42),\"\",'10. Load Forecast'!D42)","v":""},null,null,null,0,null,null,null,0]
[null,15,{"$f":"IF(ISBLANK('10. Load Forecast'!D43),\"\",'10. Load Forecast'!D43)","v":""},null,null,null,0,null,null,null,0]
[null,16,{"$f":"IF(ISBLANK('10. Load Forecast'!D44),\"\",'10. Load Forecast'!D44)","v":""},null,null,null,0,null,null,null,0]
[null,17,{"$f":"IF(ISBLANK('10. Load Forecast'!D45),\"\",'10. Load Forecast'!D45)","v":""},null,null,null,0,null,null,null,0]
[null,18,{"$f":"IF(ISBLANK('10. Load Forecast'!D46),\"\",'10. Load Forecast'!D46)","v":""},null,null,null,0,null,null,null,0]
[null,19,{"$f":"IF(ISBLANK('10. Load Forecast'!D47),\"\",'10. Load Forecast'!D47)","v":""},null,null,null,0,null,null,null,0]
[null,20,{"$f":"IF(ISBLANK('10. Load Forecast'!D48),\"\",'10. Load Forecast'!D48)","v":""},null,null,null,0,null,null,null,0]
[]
[null,null,"Total",null,{"$f":"SUM(E28:E47)","v":12972963.069999998},null,{"$f":"SUM(G28:G47)","v":1},null,{"$f":"SUM(I28:I47)","v":19494341.010660142},null,{"$f":"SUM(K28:K47)","v":1.0000000000000002}]
[]
[null,null,{"$f":"IF(I51=0,\"\",IF(ABS(I51-I49)<(0.001*I51),\" \",\"Allocated Revenue Requirement does not match Base Revenue Requirement from Sheet 9. Check data.\"))","v":" "},null,"Service Revenue Requirement (from Sheet 9)",null,null,null,{"$f":"IF(ISBLANK(E20),\"\",IF(E20='13. Rate Design'!AC4,'9. Rev_Reqt'!F25,IF(E20='13. Rate Design'!AC6,'9. Rev_Reqt'!N25,'9. Rev_Reqt'!J25)))","v":19494341.712427843}]
[]
[null,"(1)","Class Allocated Revenue Requirement, from Sheet O-1, Revenue to Cost || RR, row 40, from the Cost Allocation Study in this application. This excludes costs in deferral and variance accounts. For Embedded Distributors, Account 4750 - Low Voltage (LV) Costs are also excluded."]
[null,"(2)","Host Distributors - Provide information on any embedded distributor(s) as a separate class, if applicable. If embedded distributors are billed in a General Service class, include the allocated costs and revenues of the embedded distributor(s) in the applicable class, and also complete Appendix 2-Q."]
[null,"(3)","Customer Classes - If these differ from those in place in the previous cost allocation study, modify the customer classes to match the proposal in the current application as closely as possible."]
[]
[null,"B)","Calculated Class Revenues"]
[]
[null,null,"Name of Customer Class",null,"Load Forecast (LF) X current approved rates",null,"LF X current approved rates X (1+d)",null,"LF X Proposed Rates",null,"Miscellaneous Revenues"]
[null,null,null,null,"(7B)",null,"(7C)",null,"(7D)",null,"(7E)"]
[]
[null,1,{"$f":"IF(ISBLANK(C28),\"\",C28)","v":"Residential"},null,10992334.628884956,null,12582836.38346065,null,12956334.042950923,null,883263.24177085306]
[null,2,{"$f":"IF(ISBLANK(C29),\"\",C29)","v":"GS<50"},null,2075033.6827669521,null,2375274.2435457394,null,2375274.2435457394,null,117224.67271344381]
[null,3,"GS>50",null,2549448.4832819761,null,2918333.021713431,null,2555629.4907543552,null,86239.751633039486]
[null,4,"Embedded Distributor",null,161603.34482535382,null,184986.03941824022,null,140321.79438677261,null,575.43568490812447]
[null,5,"Street Light",null,208081.54263988393,null,238189.2558634145,null,273940.7664471335,null,13565.863927853343]
[null,6,"Sentinel Light",null,17145.171335945786,null,19625.938708207708,null,28182.085124913337,null,3117.7540349383098]
[null,7,"USL",null,60149.048058601838,null,68852.12795046356,null,58414.587450304687,null,2257.2802349636477]
[null,8,""]
[null,9,""]
[null,10,""]
[null,11,""]
[null,12,""]
[null,13,""]
[null,14,""]
[null,15,""]
[null,16,""]
[null,17,""]
[null,18,""]
[null,19,""]
[null,20,""]
[]
[null,null,"Total",null,{"$f":"SUM(E62:E81)","v":16063795.901793666},null,{"$f":"SUM(G62:G81)","v":18388097.010660145},null,{"$f":"SUM(I62:I81)","v":18388097.010660142},null,{"$f":"SUM(K62:K81)","v":1106243.9999999998}]
[]
[]
[null,"(4)","In columns 7B to 7D, LF means Load Forecast of Annual Billing Quantities (i.e., customers or connections, as applicable X 12 months, and kWh, kW or kVA as applicable. Revenue quantities should be net of the Transformer Ownership Allowance for applicable customer classes. Exclude revenues from rate adders and rate riders."]
[null,"(5)","Columns 7C and 7D - Column Total should equal the Base Revenue Requirement for each."]
[null,"(6)","Column 7C - The OEB-issued cost allocation model calculates \"1+d\" on worksheet O-1, cell C22. \"d\" is defined as Revenue Deficiency/Revenue at Current Rates."]
[null,"(7)","Column 7E - If using the OEB-issued cost allocation model, enter Miscellaneous Revenues as it appears on worksheet O-1, row 19."]
[]
[null,"C)","Rebalancing Revenue-to-Cost Ratios"]
[]
[null,null,"Name of Customer Class",null,"Previously Approved Ratios",null,"Status Quo Ratios",null,"Proposed Ratios",null,"Policy Range"]
[null,null,null,null,"Most Recent Year:",null,"(7C + 7E) / (7A)",null,"(7D + 7E) / (7A)"]
[null,null,null,null,2018]
[null,null,null,null,"%",null,"%",null,"%",null,"%"]
[]
[null,1,{"$f":"IF(ISBLANK(C62),\"\",C62)","v":"Residential"},null,0.96160000000000001,null,{"$f":"IF(ISBLANK(I28),\"\",(G62+K62)/I28)","v":0.91700541464070817},null,{"$f":"IF(ISBLANK(I28),\"\",(I62+K62)/I28)","v":0.94243960758745193},null,"85 - 115",null,{"$f":"IF(ISBLANK(K98),\"\",LEFT(K98,2)/100)","v":0.85},{"$f":"IF(ISBLANK(K98),\"\",RIGHT(K98,3)/100)","v":1.1499999999999999},"85 - 115"]
[null,2,"GS<50",null,1.1681999999999999,null,1.1992469074576593,null,1.1992469074576593,null,"80 - 120",null,{"$f":"IF(ISBLANK(K99),\"\",LEFT(K99,2)/100)","v":0.8},{"$f":"IF(ISBLANK(K99),\"\",RIGHT(K99,3)/100)","v":1.2},"80 - 120"]
[null,3,"GS>50",null,1.0369999999999999,null,1.3647485917045505,null,1.2,null,"80 - 120",null,0.8,1.2]
[null,4,"Embedded Distributor",null,1.2,null,1.5803984933592652,null,1.2,null,"80 - 120",null,0.8,1.2]
[null,5,"Street Light",null,1.2,null,0.82524704211084687,null,0.94243960758745204,null,"80 - 120",null,0.8,1.2]
[null,6,"Sentinel Light",null,1.2,null,0.40259949901913744,null,0.55405688546040299,null,"80 - 120",null,0.8,1.2]
[null,7,"USL",null,1.2,null,1.4064391468079338,null,1.2,null,"80 - 120",null,0.8,1.2]
[null,8,"",null,null,null,"",null,"",null,null,null,"",""]
[null,9,"",null,null,null,"",null,"",null,null,null,"",""]
[null,10,"",null,null,null,"",null,"",null,null,null,"",""]
[null,11,"",null,null,null,"",null,"",null,null,null,"",""]
[null,12,"",null,null,null,"",null,"",null,null,null,"",""]
[null,13,"",null,null,null,"",null,"",null,null,null,"",""]
[null,14,"",null,null,null,"",null,"",null,null,null,"",""]
[null,15,"",null,null,null,"",null,"",null,null,null,"",""]
[null,16,"",null,null,null,"",null,"",null,null,null,"",""]
[null,17,"",null,null,null,"",null,"",null,null,null,"",""]
[null,18,"",null,null,null,"",null,"",null,null,null,"",""]
[null,19,"",null,null,null,"",null,"",null,null,null,"",""]
[null,20,"",null,null,null,"",null,"",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[]
[null,"(8)","Previously Approved Revenue-to-Cost (R/C) Ratios - For most applicants, the most recent year would be the third year (at the latest) of the Price Cap IR period. For example, if the applicant, rebased in 2020 with further adjustments to move within the range over two years, the Most Recent Year would be 2023. However, the ratios in 2023 would be equal to those after the adjustment in 2022."]
[null,"(9)","Status Quo Ratios - The OEB-issued cost allocation model provides the Status Quo Ratios on Worksheet O-1. The Status Quo means \"Before Rebalancing\"."]
[null,"(10)","Ratios shown in red are outside of the allowed range. Applies to both Tables C and D."]
[]
[null,"(D)","Proposed Revenue-to-Cost Ratios (11)"]
[]
[null,null,"Name of Customer Class",null,"Proposed Revenue-to-Cost Ratio",null,null,null,null,null,"Policy Range"]
[null,null,null,null,"Test Year",null,"Price Cap IR Period"]
[null,null,null,null,2025,null,{"$f":"E128+1","v":2026},null,{"$f":"G128+1","v":2027}]
[]
[null,1,{"$f":"IF(ISBLANK(C98),\"\",C98)","v":"Residential"},null,{"$f":"I98","v":0.94243960758745193},null,0.94210000000000005,null,0.94169999999999998,null,{"$f":"IF(ISBLANK(K98),\"\",K98)","v":"85 - 115"},null,{"$f":"IF(K130=\"\",\"\",LEFT(K130,2)/100)","v":0.85},{"$f":"IF(K130=\"\",\"\",RIGHT(K130,3)/100)","v":1.1499999999999999}]
[null,2,{"$f":"IF(ISBLANK(C99),\"\",C99)","v":"GS<50"},null,{"$f":"I99","v":1.1992469074576593},null,{"$f":"IF(E131=0,\"\",E131)","v":1.1992469074576593},null,{"$f":"IF(G131=0,\"\",G131)","v":1.1992469074576593},null,{"$f":"IF(ISBLANK(K99),\"\",K99)","v":"80 - 120"},null,{"$f":"IF(K131=\"\",\"\",LEFT(K131,2)/100)","v":0.8},{"$f":"IF(K131=\"\",\"\",RIGHT(K131,3)/100)","v":1.2}]
[null,3,"GS>50",null,1.2,null,1.2,null,1.2,null,"80 - 120",null,0.8,1.2]
[null,4,"Embedded Distributor",null,1.2,null,1.2,null,1.2,null,"80 - 120",null,0.8,1.2]
[null,5,"Street Light",null,0.94243960758745204,null,{"$f":"G130","v":0.94210000000000005},null,{"$f":"I130","v":0.94169999999999998},null,"80 - 120",null,0.8,1.2]
[null,6,"Sentinel Light",null,0.55405688546040299,null,0.63149999999999995,null,0.74239999999999995,null,"80 - 120",null,0.8,1.2]
[null,7,"USL",null,1.2,null,1.2,null,1.2,null,"80 - 120",null,0.8,1.2]
[null,8,"",null,"",null,"",null,"",null,"",null,"",""]
[null,9,"",null,"",null,"",null,"",null,"",null,"",""]
[null,10,"",null,"",null,"",null,"",null,"",null,"",""]
[null,11,"",null,"",null,"",null,"",null,"",null,"",""]
[null,12,"",null,"",null,"",null,"",null,"",null,"",""]
[null,13,"",null,"",null,"",null,"",null,"",null,"",""]
[null,14,"",null,"",null,"",null,"",null,"",null,"",""]
[null,15,"",null,"",null,"",null,"",null,"",null,"",""]
[null,16,"",null,"",null,"",null,"",null,"",null,"",""]
[null,17,"",null,"",null,"",null,"",null,"",null,"",""]
[null,18,"",null,"",null,"",null,"",null,"",null,"",""]
[null,19,"",null,"",null,"",null,"",null,"",null,"",""]
[null,20,"",null,"",null,"",null,"",null,"",null,"",""]
[]
[]
[null,"(11)","The applicant should complete Table D if it is applying for approval of a revenue-to-cost ratio in 2025 that is outside of the OEB's policy range for any customer class. Table D will show that the distributor is likely to enter into the 2026 and 2027 Price Cap IR models, as necessary. For 2026 and 2027, enter the planned revenue-to-cost ratios that will be \"Change\" or \"No Change\" in 2026 (in the current Revenue/Cost Ratio Adjustment Workform, Worksheet C1.1 'Decision - Cost Revenue Adjustment, column d), and enter TBD for class(es) that will be entered as 'Rebalance'."]

{"sheet":"12. Res_Rate_Design","index":9,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[58,2,59,6],[66,2,67,6],[13,1,13,8],[19,2,19,3],[25,2,25,3],[51,2,51,3],[53,2,54,2],[23,5,23,6],[25,5,28,6],[61,2,64,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"New Rate Design Policy For Residential Customers"]
[]
[null,"Please complete the following tables."]
[]
[null,"A","Data Inputs (from Sheet 10. Load Forecast)"]
[]
[null,null,"Test Year Billing Determinants for Residential Class"]
[null,null,"Customers",{"$f":"VLOOKUP(\"Residential\",'13. Rate Design'!D28:L47,5,FALSE)","v":29454.272853389488}]
[null,null,"kWh",{"$f":"VLOOKUP(\"Residential\",'13. Rate Design'!D28:L47,7,FALSE)","v":284634105.84651595}]
[]
[null,null,"Proposed Residential Class Specific Revenue Requirement1",{"$f":"VLOOKUP(\"Residential\",'11. Cost_Allocation'!C62:K81,7,FALSE)","v":12956334.042950923}]
[]
[null,null,"Residential Base Rates on Current Tariff"]
[null,null,"Monthly Fixed Charge ($)"]
[null,null,"Distribution Volumetric Rate ($/kWh)"]
[]
[]
[null,"B","Current Fixed/Variable Split"]
[]
[null,null,null,"Base Rates","Billing Determinants","Revenue","% of Total Revenue"]
[null,null,"Fixed",{"$f":"IF(D27=\"\",\"\",D27)","v":""},{"$f":"IF(D21=\"\",\"\",D21)","v":29454.272853389488},{"$f":"IF(ISERROR(D34*E34*12),\"\",D34*E34*12)","v":""},{"$f":"IF(ISERROR(F34/F36),\"\",F34/F36)","v":""}]
[null,null,"Variable",{"$f":"IF(D28=\"\",\"\",D28)","v":""},{"$f":"IF(D22=\"\",\"\",D22)","v":284634105.84651595},{"$f":"IF(ISERROR(D35*E35),\"\",D35*E35)","v":""},{"$f":"IF(ISERROR(F35/F36),\"\",F35/F36)","v":""}]
[null,null,"TOTAL","-","-",{"$f":"IF(ISERROR(F34+F35),\"\",F34+F35)","v":""},"-"]
[]
[null,"C","Calculating Test Year Base Rates"]
[]
[null,null,"Number of Remaining Rate Design Policy Transition Years2"]
[]
[null,null,null,"Test Year Revenue @ Current F/V Split","Test Year Base Rates @ Current F/V Split","Reconciliation - Test Year Base Rates @ Current F/V Split"]
[null,null,"Fixed",{"$f":"IF(ISERROR(D$24*G34),\"\",D$24*G34)","v":""},{"$f":"IF(ISERROR(ROUND(D43/D21/12,2)),\"\",ROUND(D43/D21/12,2))","v":""},{"$f":"IF(ISERROR(E43*D21*12),\"\",E43*D21*12)","v":""}]
[null,null,"Variable",{"$f":"IF(ISERROR(D$24*G35),\"\",D$24*G35)","v":""},{"$f":"IF(ISERROR(ROUND(D44/D22,4)),\"\",ROUND(D44/D22,4))","v":""},{"$f":"IF(ISERROR(E44*D22),\"\",E44*D22)","v":""}]
[null,null,"TOTAL",{"$f":"IF(ISERROR(D43+D44),\"\",D43+D44)","v":""},"-",{"$f":"IF(ISERROR(F43+F44),\"\",F43+F44)","v":""}]
[]
[null,null,null,"New F/V Split","Revenue @ new\n F/V Split","Final Adjusted \nBase Rates","Revenue Reconciliation @ Adjusted Rates"]
[null,null,"Fixed",{"$f":"IF(ISERROR(((1-G34)/D40)+G34),\"\",((1-G34)/D40)+G34)","v":""},{"$f":"IF(ISERROR(D48*D$24),\"\",D48*D$24)","v":""},{"$f":"IF(ISERROR(ROUND(E48/D21/12,2)),\"\",ROUND(E48/D21/12,2))","v":""},{"$f":"IF(ISERROR(F48*12*D21),\"\",F48*12*D21)","v":""}]
[null,null,"Variable",{"$f":"IF(ISERROR(1-D48),\"\",1-D48)","v":""},{"$f":"IF(ISERROR(D49*D$24),\"\",D49*D$24)","v":""},{"$f":"IF(ISERROR(ROUND(E49/D22,4)),\"\",ROUND(E49/D22,4))","v":""},{"$f":"IF(ISERROR(F49*D22),\"\",F49*D22)","v":""}]
[null,null,"TOTAL","-",{"$f":"IF(ISERROR(SUM(E48:E49)),\"\",SUM(E48:E49))","v":0},"-",{"$f":"IF(ISERROR(G48+G49),\"\",G48+G49)","v":""}]
[]
[null,null,"Checks3"]
[null,null,"Change in Fixed Rate",{"$f":"IF(ISERROR(F48-E43),\"\",F48-E43)","v":""}]
[null,null,"Difference Between Revenues @ Proposed Rates and Class Specific Revenue Requirement",{"$f":"IF(ISERROR((F48*12*D21)+(F49*D22)-D24),\"\",(F48*12*D21)+(F49*D22)-D24)","v":""}]
[null,null,null,{"$f":"IF(ISERROR(D54/D24), \"\", D54/D24)","v":""}]
[]
[null,"Notes:"]
[]
[null,1,"The final residential class specific revenue requirement, excluding allocated Miscellaneous Revenues, as shown on Sheet 11. Cost Allocation, should be used (i.e. the revenue requirement after any proposed adjustments to R/C ratios)."]
[]
[]
[null,2,"The distributor should enter the number of years remaining before the transition to fully fixed rates is completed. The change in residential rate design is almost complete and distributors should have either 0 or 1 year remaining. If the distributor has fully transitioned to fixed rates put \"0\" in cell D40. If the distributor has proposed an additional transition year because the change in the residential rate design will result in the fixed charge increasing by more than $4/year, put \"1\" in cell D40."]
[]
[]
[]
[]
[null,3,"Change in fixed rate due to rate design policy should be less than $4. The difference between the proposed class revenue requirement and the revenue at calculated base rates should be minimal (i.e. should be reasonably considered as a rounding error)"]

{"sheet":"13. Rate Design","index":10,"n_rows":59,"n_cols":43,"rows_kept":59,"cut":false,"hidden":false,"merged":[[14,1,14,40],[16,1,16,40],[23,30,23,34],[23,11,25,11],[21,3,21,11],[23,24,25,24],[19,26,19,34],[23,40,25,40],[19,7,19,11],[23,5,25,5],[23,7,25,7],[23,9,25,9],[19,14,19,18],[23,14,25,14],[23,16,25,16],[58,3,58,40],[23,18,25,18],[44,42,46,42],[19,36,19,40],[50,30,53,34],[21,20,21,22],[21,14,22,18],[22,20,22,22],[48,18,48,22],[23,26,23,28],[55,3,56,33]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3. Data_Input_Sheet'!E12","v":"Initial Application"},1,"F","H","J"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\" \",'3. Data_Input_Sheet'!M12)","v":"Interrogatory Responses"},2,"L","N","P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U12),\" \",'3. Data_Input_Sheet'!U12)","v":"Settlement Agreement"},3,"R","T","V"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'3. Data_Input_Sheet'!AC12","v":"Per Board Decision"}]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate Design and Revenue Reconciliation"]
[]
[null,"This sheet replaces Appendix 2-V, and provides a simplified model for calculating the standard monthly and voluemtric rates based on the allocated class revenues and fixed/variable split resulting from the cost allocation study and rate design and as proposed by the applicant. However, the RRWF does not replace the rate generator model that an applicant distributor may use in support of its application. The RRWF provides a demonstrative check on the derivation of the revenue requirement and on the proposed base distribution rates to recover the revenue requirement, based on summary information from a more detailed rate generator model and other models that applicants use for cost allocation, load forecasting, taxes/PILs, etc. "]
[]
[]
[null,null,null,"Stage in Process:",null,null,null,{"$f":"IF(ISBLANK('10. Load Forecast'!F22),\"\",'10. Load Forecast'!F22)","v":"Initial Application"},null,null,null,null,null,null,"Class Allocated Revenues",null,null,null,null,null,null,null,null,null,null,null,"Distribution Rates",null,null,null,null,null,null,null,null,null,"Revenue Reconciliation"]
[]
[null,null,null,"Customer and Load Forecast",null,null,null,null,null,null,null,null,null,null,"From Sheet 11. Cost Allocation and Sheet 12. Residential Rate Design",null,null,null,null,null,"Fixed / Variable Splits 2,3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage to be entered as a fraction between 0 and 1"]
[null,null,null,"Customer Class",null,"Volumetric Charge Determinant",null,"Customers / Connections",null,"kWh",null,"kW or kVA",null,null,"Total Class Revenue Requirement",null,"Monthly Service Charge",null,"Volumetric",null,null,null,null,null,"Transformer Ownership Allowance 1 ($)",null,"Monthly Service Charge 2",null,null,null,"Volumetric Rate 3",null,null,null,null,null,null,null,null,null,"Distribution Revenues less Transformer Ownership Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed",null,"Variable"]
[null,null,null,"From sheet 10. Load Forecast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate",null,"No. of decimals",null,"Rate",null,null,null,"No. of decimals",null,"MSC Revenues",null,"Volumetric revenues"]
[]
[null,1,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D29),\"\",'10. Load Forecast'!D29)","v":"Residential"},null,"kWh",null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F29,IF($H$20=$AC$5,'10. Load Forecast'!L29,IF($H$20=$AC$6,'10. Load Forecast'!R29,'10. Load Forecast'!X29))))","v":29454.272853389488},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H29,IF($H$20=$AC$5,'10. Load Forecast'!N29,IF($H$20=$AC$6,'10. Load Forecast'!T29,'10. Load Forecast'!Z29))))","v":284634105.84651595},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J29,IF($H$20=$AC$5,'10. Load Forecast'!P29,IF($H$20=$AC$6,'10. Load Forecast'!V29,'10. Load Forecast'!AB29))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I62),\"\",'11. Cost_Allocation'!I62)","v":12956334.042950923},null,{"$f":"IF(ISBLANK(U28),\"\",O28*U28)","v":12956334.042950923},null,{"$f":"IF(Q28=\"\",\"\",O28-Q28)","v":0},null,1,null,{"$f":"IF(ISBLANK(U28),\"\",1-U28)","v":0},null,null,null,{"$f":"IF(O28=\"\",\"\",IF(H28=0,0,IF(U28=0,0,ROUND(Q28/(H28*12),AC28))))","v":36.659999999999997},null,2,null,{"$f":"IF(S28=\"\",\"\",ROUND(IF(F28=\"kWh\",(S28+Y28)/J28,(S28+Y28)/L28),AI28))","v":0},null,{"$f":"IF(ISBLANK(F28),\"\",CONCATENATE(\"/\",F28))","v":"/kWh"},null,4,null,{"$f":"IF(AA28=\"\",0,AA28*H28*12)","v":12957523.713663101},null,{"$f":"ROUND(IF(AE28=\"\",0,IF(F28=\"kWh\",J28*AE28,IF(F28=\"kW\",IF(AE28=\"\",0,AE28*L28)))),AI28)","v":0},null,{"$f":"ROUND(AK28+AM28-Y28,2)","v":12957523.710000001}]
[null,2,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D30),\"\",'10. Load Forecast'!D30)","v":"GS<50"},null,"kWh",null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F30,IF($H$20=$AC$5,'10. Load Forecast'!L30,IF($H$20=$AC$6,'10. Load Forecast'!R30,'10. Load Forecast'!X30))))","v":2097.7595691542842},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H30,IF($H$20=$AC$5,'10. Load Forecast'!N30,IF($H$20=$AC$6,'10. Load Forecast'!T30,'10. Load Forecast'!Z30))))","v":70835308.350547194},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J30,IF($H$20=$AC$5,'10. Load Forecast'!P30,IF($H$20=$AC$6,'10. Load Forecast'!V30,'10. Load Forecast'!AB30))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I63),\"\",'11. Cost_Allocation'!I63)","v":2375274.2435457394},null,{"$f":"IF(ISBLANK(U29),\"\",O29*U29)","v":1124986.5017460596},null,{"$f":"IF(Q29=\"\",\"\",O29-Q29)","v":1250287.7417996798},null,0.47362383724866775,null,{"$f":"IF(ISBLANK(U29),\"\",1-U29)","v":0.52637616275133225},null,null,null,{"$f":"IF(O29=\"\",\"\",IF(H29=0,0,IF(U29=0,0,ROUND(Q29/(H29*12),AC29))))","v":44.69},null,{"$f":"AC28","v":2},null,{"$f":"IF(S29=\"\",\"\",ROUND(IF(F29=\"kWh\",(S29+Y29)/J29,(S29+Y29)/L29),AI29))","v":1.77E-2},null,"/kWh",null,{"$f":"AI28","v":4},null,{"$f":"IF(AA29=\"\",0,AA29*H29*12)","v":1124986.5017460596},null,{"$f":"ROUND(IF(AE29=\"\",0,IF(F29=\"kWh\",J29*AE29,IF(F29=\"kW\",IF(AE29=\"\",0,AE29*L29)))),AI29)","v":1253784.9578},null,{"$f":"ROUND(AK29+AM29-Y29,2)","v":2378771.46}]
[null,3,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D31),\"\",'10. Load Forecast'!D31)","v":"GS>50"},null,"kW",null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F31,IF($H$20=$AC$5,'10. Load Forecast'!L31,IF($H$20=$AC$6,'10. Load Forecast'!R31,'10. Load Forecast'!X31))))","v":234.51571426576166},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H31,IF($H$20=$AC$5,'10. Load Forecast'!N31,IF($H$20=$AC$6,'10. Load Forecast'!T31,'10. Load Forecast'!Z31))))","v":197879032.77457455},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J31,IF($H$20=$AC$5,'10. Load Forecast'!P31,IF($H$20=$AC$6,'10. Load Forecast'!V31,'10. Load Forecast'!AB31))))","v":698414.05914110714},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I64),\"\",'11. Cost_Allocation'!I64)","v":2555629.4907543552},null,772157.06016287627,null,1783472.4305914789,null,0.30213967359366933,null,0.69786032640633067,null,75810.599999999991,null,274.38,null,{"$f":"AC29","v":2},null,2.6621999999999999,null,"/kW",null,{"$f":"AI29","v":4},null,772157.06016287627,null,1859317.9081999999,null,2555664.37]
[null,4,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D32),\"\",'10. Load Forecast'!D32)","v":"Embedded Distributor"},null,"kW",null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F32,IF($H$20=$AC$5,'10. Load Forecast'!L32,IF($H$20=$AC$6,'10. Load Forecast'!R32,'10. Load Forecast'!X32))))","v":4},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H32,IF($H$20=$AC$5,'10. Load Forecast'!N32,IF($H$20=$AC$6,'10. Load Forecast'!T32,'10. Load Forecast'!Z32))))","v":34244754.121491976},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J32,IF($H$20=$AC$5,'10. Load Forecast'!P32,IF($H$20=$AC$6,'10. Load Forecast'!V32,'10. Load Forecast'!AB32))))","v":90871.252838385451},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I65),\"\",'11. Cost_Allocation'!I65)","v":140321.79438677261},null,27030.720000000001,null,113291.07438677261,null,0.19263379661105617,null,0.80736620338894383,null,null,null,563.14,null,2,null,1.2466999999999999,null,"/kW",null,4,null,27030.720000000001,null,113289.1909,null,140319.91]
[null,5,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D33),\"\",'10. Load Forecast'!D33)","v":"Street Light"},null,"kW",null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F33,IF($H$20=$AC$5,'10. Load Forecast'!L33,IF($H$20=$AC$6,'10. Load Forecast'!R33,'10. Load Forecast'!X33))))","v":2828.2632585547244},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H33,IF($H$20=$AC$5,'10. Load Forecast'!N33,IF($H$20=$AC$6,'10. Load Forecast'!T33,'10. Load Forecast'!Z33))))","v":2433600.5248393081},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J33,IF($H$20=$AC$5,'10. Load Forecast'!P33,IF($H$20=$AC$6,'10. Load Forecast'!V33,'10. Load Forecast'!AB33))))","v":7372.4856525959021},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I66),\"\",'11. Cost_Allocation'!I66)","v":273940.7664471335},null,172410.928241496,null,101529.8382056375,null,0.62937302277997664,null,0.37062697722002336,null,null,null,5.08,null,2,null,13.7715,null,"/kW",null,4,null,172410.928241496,null,101530.1862,null,273941.11]
[null,6,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D34),\"\",'10. Load Forecast'!D34)","v":"Sentinel Light"},null,"kW",null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F34,IF($H$20=$AC$5,'10. Load Forecast'!L34,IF($H$20=$AC$6,'10. Load Forecast'!R34,'10. Load Forecast'!X34))))","v":215.94544680445384},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H34,IF($H$20=$AC$5,'10. Load Forecast'!N34,IF($H$20=$AC$6,'10. Load Forecast'!T34,'10. Load Forecast'!Z34))))","v":262327.78873529832},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J34,IF($H$20=$AC$5,'10. Load Forecast'!P34,IF($H$20=$AC$6,'10. Load Forecast'!V34,'10. Load Forecast'!AB34))))","v":716.34708302108174},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I67),\"\",'11. Cost_Allocation'!I67)","v":28182.085124913337},null,15729.466345236418,null,12452.618779676919,null,0.55813706741419788,null,0.44186293258580212,null,null,null,6.07,null,2,null,17.383500000000002,null,"/kW",null,4,null,15729.466345236418,null,12452.619500000001,null,28182.09]
[null,7,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D35),\"\",'10. Load Forecast'!D35)","v":"USL"},null,"kWh",null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F35,IF($H$20=$AC$5,'10. Load Forecast'!L35,IF($H$20=$AC$6,'10. Load Forecast'!R35,'10. Load Forecast'!X35))))","v":122.76948833843458},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H35,IF($H$20=$AC$5,'10. Load Forecast'!N35,IF($H$20=$AC$6,'10. Load Forecast'!T35,'10. Load Forecast'!Z35))))","v":1383562.2195668274},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J35,IF($H$20=$AC$5,'10. Load Forecast'!P35,IF($H$20=$AC$6,'10. Load Forecast'!V35,'10. Load Forecast'!AB35))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I68),\"\",'11. Cost_Allocation'!I68)","v":58414.587450304687},null,14879.661986618274,null,43534.925463686413,null,0.25472510610944427,null,0.74527489389055579,null,null,null,10.1,null,2,null,3.15E-2,null,"/kWh",null,4,null,14879.661986618272,null,43582.209900000002,null,58461.87]
[null,8,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D36),\"\",'10. Load Forecast'!D36)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F36,IF($H$20=$AC$5,'10. Load Forecast'!L36,IF($H$20=$AC$6,'10. Load Forecast'!R36,'10. Load Forecast'!X36))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H36,IF($H$20=$AC$5,'10. Load Forecast'!N36,IF($H$20=$AC$6,'10. Load Forecast'!T36,'10. Load Forecast'!Z36))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J36,IF($H$20=$AC$5,'10. Load Forecast'!P36,IF($H$20=$AC$6,'10. Load Forecast'!V36,'10. Load Forecast'!AB36))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I69),\"\",'11. Cost_Allocation'!I69)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,9,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D37),\"\",'10. Load Forecast'!D37)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F37,IF($H$20=$AC$5,'10. Load Forecast'!L37,IF($H$20=$AC$6,'10. Load Forecast'!R37,'10. Load Forecast'!X37))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H37,IF($H$20=$AC$5,'10. Load Forecast'!N37,IF($H$20=$AC$6,'10. Load Forecast'!T37,'10. Load Forecast'!Z37))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J37,IF($H$20=$AC$5,'10. Load Forecast'!P37,IF($H$20=$AC$6,'10. Load Forecast'!V37,'10. Load Forecast'!AB37))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I70),\"\",'11. Cost_Allocation'!I70)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,10,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D38),\"\",'10. Load Forecast'!D38)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F38,IF($H$20=$AC$5,'10. Load Forecast'!L38,IF($H$20=$AC$6,'10. Load Forecast'!R38,'10. Load Forecast'!X38))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H38,IF($H$20=$AC$5,'10. Load Forecast'!N38,IF($H$20=$AC$6,'10. Load Forecast'!T38,'10. Load Forecast'!Z38))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J38,IF($H$20=$AC$5,'10. Load Forecast'!P38,IF($H$20=$AC$6,'10. Load Forecast'!V38,'10. Load Forecast'!AB38))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I71),\"\",'11. Cost_Allocation'!I71)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,11,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D39),\"\",'10. Load Forecast'!D39)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F39,IF($H$20=$AC$5,'10. Load Forecast'!L39,IF($H$20=$AC$6,'10. Load Forecast'!R39,'10. Load Forecast'!X39))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H39,IF($H$20=$AC$5,'10. Load Forecast'!N39,IF($H$20=$AC$6,'10. Load Forecast'!T39,'10. Load Forecast'!Z39))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J39,IF($H$20=$AC$5,'10. Load Forecast'!P39,IF($H$20=$AC$6,'10. Load Forecast'!V39,'10. Load Forecast'!AB39))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I72),\"\",'11. Cost_Allocation'!I72)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,12,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D40),\"\",'10. Load Forecast'!D40)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F40,IF($H$20=$AC$5,'10. Load Forecast'!L40,IF($H$20=$AC$6,'10. Load Forecast'!R40,'10. Load Forecast'!X40))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H40,IF($H$20=$AC$5,'10. Load Forecast'!N40,IF($H$20=$AC$6,'10. Load Forecast'!T40,'10. Load Forecast'!Z40))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J40,IF($H$20=$AC$5,'10. Load Forecast'!P40,IF($H$20=$AC$6,'10. Load Forecast'!V40,'10. Load Forecast'!AB40))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I73),\"\",'11. Cost_Allocation'!I73)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,13,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D41),\"\",'10. Load Forecast'!D41)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F41,IF($H$20=$AC$5,'10. Load Forecast'!L41,IF($H$20=$AC$6,'10. Load Forecast'!R41,'10. Load Forecast'!X41))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H41,IF($H$20=$AC$5,'10. Load Forecast'!N41,IF($H$20=$AC$6,'10. Load Forecast'!T41,'10. Load Forecast'!Z41))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J41,IF($H$20=$AC$5,'10. Load Forecast'!P41,IF($H$20=$AC$6,'10. Load Forecast'!V41,'10. Load Forecast'!AB41))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I74),\"\",'11. Cost_Allocation'!I74)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,14,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D42),\"\",'10. Load Forecast'!D42)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F42,IF($H$20=$AC$5,'10. Load Forecast'!L42,IF($H$20=$AC$6,'10. Load Forecast'!R42,'10. Load Forecast'!X42))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H42,IF($H$20=$AC$5,'10. Load Forecast'!N42,IF($H$20=$AC$6,'10. Load Forecast'!T42,'10. Load Forecast'!Z42))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J42,IF($H$20=$AC$5,'10. Load Forecast'!P42,IF($H$20=$AC$6,'10. Load Forecast'!V42,'10. Load Forecast'!AB42))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I75),\"\",'11. Cost_Allocation'!I75)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,15,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D43),\"\",'10. Load Forecast'!D43)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F43,IF($H$20=$AC$5,'10. Load Forecast'!L43,IF($H$20=$AC$6,'10. Load Forecast'!R43,'10. Load Forecast'!X43))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H43,IF($H$20=$AC$5,'10. Load Forecast'!N43,IF($H$20=$AC$6,'10. Load Forecast'!T43,'10. Load Forecast'!Z43))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J43,IF($H$20=$AC$5,'10. Load Forecast'!P43,IF($H$20=$AC$6,'10. Load Forecast'!V43,'10. Load Forecast'!AB43))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I76),\"\",'11. Cost_Allocation'!I76)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,16,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D44),\"\",'10. Load Forecast'!D44)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F44,IF($H$20=$AC$5,'10. Load Forecast'!L44,IF($H$20=$AC$6,'10. Load Forecast'!R44,'10. Load Forecast'!X44))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H44,IF($H$20=$AC$5,'10. Load Forecast'!N44,IF($H$20=$AC$6,'10. Load Forecast'!T44,'10. Load Forecast'!Z44))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J44,IF($H$20=$AC$5,'10. Load Forecast'!P44,IF($H$20=$AC$6,'10. Load Forecast'!V44,'10. Load Forecast'!AB44))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I77),\"\",'11. Cost_Allocation'!I77)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,17,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D45),\"\",'10. Load Forecast'!D45)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F45,IF($H$20=$AC$5,'10. Load Forecast'!L45,IF($H$20=$AC$6,'10. Load Forecast'!R45,'10. Load Forecast'!X45))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H45,IF($H$20=$AC$5,'10. Load Forecast'!N45,IF($H$20=$AC$6,'10. Load Forecast'!T45,'10. Load Forecast'!Z45))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J45,IF($H$20=$AC$5,'10. Load Forecast'!P45,IF($H$20=$AC$6,'10. Load Forecast'!V45,'10. Load Forecast'!AB45))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I78),\"\",'11. Cost_Allocation'!I78)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,18,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D46),\"\",'10. Load Forecast'!D46)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F46,IF($H$20=$AC$5,'10. Load Forecast'!L46,IF($H$20=$AC$6,'10. Load Forecast'!R46,'10. Load Forecast'!X46))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H46,IF($H$20=$AC$5,'10. Load Forecast'!N46,IF($H$20=$AC$6,'10. Load Forecast'!T46,'10. Load Forecast'!Z46))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J46,IF($H$20=$AC$5,'10. Load Forecast'!P46,IF($H$20=$AC$6,'10. Load Forecast'!V46,'10. Load Forecast'!AB46))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I79),\"\",'11. Cost_Allocation'!I79)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0,null,"Distribution Revenues including TOA Credit Recovery in Rates"]
[null,19,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D47),\"\",'10. Load Forecast'!D47)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F47,IF($H$20=$AC$5,'10. Load Forecast'!L47,IF($H$20=$AC$6,'10. Load Forecast'!R47,'10. Load Forecast'!X47))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H47,IF($H$20=$AC$5,'10. Load Forecast'!N47,IF($H$20=$AC$6,'10. Load Forecast'!T47,'10. Load Forecast'!Z47))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J47,IF($H$20=$AC$5,'10. Load Forecast'!P47,IF($H$20=$AC$6,'10. Load Forecast'!V47,'10. Load Forecast'!AB47))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I80),\"\",'11. Cost_Allocation'!I80)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[null,20,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D48),\"\",'10. Load Forecast'!D48)","v":""},null,null,null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!F48,IF($H$20=$AC$5,'10. Load Forecast'!L48,IF($H$20=$AC$6,'10. Load Forecast'!R48,'10. Load Forecast'!X48))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!H48,IF($H$20=$AC$5,'10. Load Forecast'!N48,IF($H$20=$AC$6,'10. Load Forecast'!T48,'10. Load Forecast'!Z48))))","v":0},null,{"$f":"IF(ISBLANK($H$20),0,IF($H$20=$AC$4,'10. Load Forecast'!J48,IF($H$20=$AC$5,'10. Load Forecast'!P48,IF($H$20=$AC$6,'10. Load Forecast'!V48,'10. Load Forecast'!AB48))))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I81),\"\",'11. Cost_Allocation'!I81)","v":""},null,"",null,"",null,null,null,"",null,null,null,"",null,2,null,"",null,"",null,4,null,0,null,0,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Transformer Ownership Allowance",null,null,null,null,null,{"$f":"SUM(Y28:Y47)","v":75810.599999999991},null,null,null,null,null,null,null,null,null,null,"Total Distribution Revenues",null,null,null,null,{"$f":"SUM(AO28:AO47)","v":18392864.520000003},null,{"$f":"SUM(AK28:AK47)+SUM(AM28:AM47)","v":18468675.12464539}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO49+Y49","v":18468675.120000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO54=\"\",\"\",IF((ABS(AO54)<=0.5%),\"Rates recover revenue requirement\",\"Revenues recovered from rates deviate materially from revenue requirement - check data inputs and calculations\"))","v":"Rates recover revenue requirement"},null,null,null,null,"Base Revenue Requirement",null,null,null,null,{"$f":"IF(H20=\"\",0,IF(H20=AC4,'9. Rev_Reqt'!F28,IF(H20=AC5,'9. Rev_Reqt'!J28,'9. Rev_Reqt'!N28)))","v":18388097.712427843}]
[null,"Notes:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Difference",null,null,null,null,{"$f":"AO49-AO51","v":4766.8075721599162}]
[null,1,null,"Transformer Ownership Allowance is entered as a positive amount, and only for those classes to which it applies.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Difference",null,null,null,null,{"$f":"IF(AO51=0,\"\",AO53/AO51)","v":2.5923331748113377E-4}]
[]
[null,2,null,"The Fixed/Variable split, for each customer class, drives the \"rate generator\" portion of this sheet of the RRWF. Only the \"fixed\" fraction is entered, as the sum of the \"fixed\" and \"variable\" portions must sum to 100%. For a distributor that may set the Monthly Service Charge, the \"fixed\" ratio is calcutated as: [MSC x (average number of customers or connections) x 12 months] / (Class Allocated Revenue Requirement)."]
[]
[]
[null,3,null,"The Volumetric rate is calculated as [(allocated volumetric revenue requirement for the class + transformer allowance credit for the class)/(annual estimate of the charge determinant for the test year (either kW or kVA for demand-billed customer classes, or kWh for non-demand-billed classes)]"]

{"sheet":"1. Info","index":11,"n_rows":92,"n_cols":29,"rows_kept":92,"cut":false,"hidden":false,"merged":[[38,0,38,16],[35,1,35,3],[43,1,49,11],[0,2,1,12],[2,2,3,12],[35,4,35,9],[25,6,25,10],[21,1,21,2],[15,6,15,12],[17,6,17,10],[19,6,19,10],[21,6,21,10],[23,6,23,10],[23,1,23,2],[25,1,25,3],[36,0,36,16],[27,4,27,5],[29,4,29,5],[31,4,31,5],[27,6,27,10],[29,6,29,10],[31,6,31,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenue Requirement Workform\n(RRWF) for 2025 Filers\n",null,{"$f":"IF('3. Data_Input_Sheet'!M12=0, \"\", '3. Data_Input_Sheet'!M12)","v":"Interrogatory Responses"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,null,{"$f":"IF('3. Data_Input_Sheet'!U12=0, \"\", '3. Data_Input_Sheet'!U12)","v":"Settlement Agreement"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"$AA$2","v":1.1000000000000001}]
[]
[]
[]
[]
[null,null,null,null,null,"Utility Name   ","Essex Powerlines Corporation"]
[]
[null,null,null,null,null,"Service Territory"]
[]
[null,null,null,null,null,"Assigned EB Number","EB-2024-0020",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Alectra Utilities Corporation-Brampton Rate Zone"]
[null,null,null,null,null,"Name and Title","Grace Flood, Director Finance & Regulatory Affairs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Alectra Utilities Corporation-Enersource Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Alectra Utilities Corporation-Horizon Utilities Rate Zone"]
[null,null,null,null,null,"Phone Number   ","519-737-9811 X 163",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Alectra Utilities Corporation-PowerStream Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Alectra Utilities Corporation-Guelph Rate Zone"]
[null,null,null,null,null,"Email Address   ","gflood@essexpowerlines,ca",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Algoma Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Atikokan Hydro Inc."]
[null,null,null,null,"Test Year",null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Bluewater Power Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Burlington Hydro Inc."]
[null,null,null,null,"Bridge Year",null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Canadian Niagara Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Centre Wellington Hydro Ltd."]
[null,null,null,null,"Last Rebasing Year",null,2018,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Chapleau Public Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"Cooperative Hydro Embrun Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"E.L.K. Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Elexicon Energy Inc.-Whitby Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Elexicon Energy Inc.-Veridian Rate Zone"]
["The RRWF has been enhanced commencing with 2017 rate applications to provide estimated base distribution rates.  The enhanced RRWF is not intended to replace a utility’s formal rate generator model which should continue to be the source of the proposed rates as well as the final ones at the conclusion of the proceeding. The load forecasting addition made to this model is intended to be demonstrative only and does not replace the information filed in the utility’s application. In an effort to minimize the incremental work required from utilities, the cost allocation and rate design additions to this model do in fact replace former appendices that were required to be filed as part of the cost of service (Chapter 2) filing requirements.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Enova Power Corp.-Kitchener-Wilmot Hydro Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enova Power Corp.-Waterloo North Rate Zone"]
["Commencing with 2023 rate applications, the RRWF has been enhanced with an additional column, so that two stages of processing of an application (e.g. interrogatory responses and settlement agreement) between the initial application filing and the OEB decision and draft rate order (\"Per Board Decision\") can be used. Functionality of the RRWF is the same as in previous versions of the RRWF. (May 2022)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Entegrus Powerlines Inc.-For Entegrus-Main Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Entegrus Powerlines Inc.-For Former St. Thomas Energy Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"ENWIN Utilities Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"EPCOR Electricity Distribution Ontario Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"ERTH Power Corporation - ERTH Power Main Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"ERTH POWER CORPORATION – GODERICH RATE ZONE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"Espanola Regional Hydro Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"Essex Powerlines Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"Festival Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"Fort Frances Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"GrandBridge Energy Inc.-Brantford Power Rate Zone "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"GrandBridge Energy Inc.-Energy+ Rate Zone "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Greater Sudbury Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"Grimsby Power Incorporated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"Halton Hills Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"Hearst Power Distribution Co. Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"Hydro 2000 Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"Hydro Hawkesbury Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"Hydro One Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"Hydro One Networks Inc.-Former Orillia Power Distribution Corporation Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Hydro One Networks Inc.-Former Peterborough Distribution Inc. Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"Hydro One Networks Inc.-Former Haldimand County Hydro Inc. Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"Hydro One Networks Inc.-Former Norfolk Power Distribution Inc. Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"Hydro One Networks Inc.-Former Woodstock Hydro Services Inc. Service Area"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"Hydro One Remote Communites Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"Hydro Ottawa Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"InnPower Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"Kingston Hydro Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"Lakefront Utilities Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"Lakeland Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"London Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"Milton Hydro Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"Newmarket-Tay Power Distribution Ltd.-For Former Midland Power Utility Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"Newmarket-Tay Power Distribution Ltd.-For Newmarket-Tay Power Main Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Niagara Peninsula Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"Niagara-on-the-Lake Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,"North Bay Hydro Distribution Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"Northern Ontario Wires Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,"Oakville Hydro Electricity Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,"Orangeville Hydro Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,"Oshawa PUC Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,"Ottawa River Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"PUC Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"Renfrew Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,"Rideau St. Lawrence Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,"Sioux Lookout Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,"Synergy North Corporation-Kenora Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,"Synergy North Corporation-Thunder Bay Rate Zone "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,"Tillsonburg Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"Toronto Hydro-Electric System Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,"Wasaga Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,"Welland Hydro-Electric System Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,"Wellington North Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,"Westario Power Inc."]

{"sheet":"2. Table of Contents","index":12,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,1,29,13],[30,1,30,13],[28,1,28,7],[0,2,0,4],[1,3,1,6],[3,3,3,4],[26,1,26,7],[27,1,27,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table of Contents"]
[]
[null,null,null,"1. Info",null,null,null,null,"8. Rev_Def_Suff"]
[]
[null,null,null,"2. Table of Contents",null,null,null,null,"9. Rev_Reqt"]
[]
[null,null,null,"3. Data_Input_Sheet",null,null,null,null,"10. Load Forecast"]
[]
[null,null,null,"4. Rate_Base",null,null,null,null,"11. Cost Allocation"]
[]
[null,null,null,"5. Utility Income",null,null,null,null,"12. Residential Rate Design - hidden. Contact OEB staff if needed."]
[]
[null,null,null,"6. Taxes_PILs",null,null,null,null,"13. Rate Design and Revenue Reconciliation"]
[]
[null,null,null,"7. Cost_of_Capital",null,null,null,null,"14. Tracking Sheet"]
[]
["Notes:"]
["(1)","Pale green cells represent inputs"]
["(2)","Pale green boxes at the bottom of each page are for additional notes"]
["(3)","Pale blue cells represent drop-down lists"]
["(4)","Please note that this model uses MACROS.  Before starting, please ensure that macros have been enabled."]
["(5)","Completed versions of the Revenue Requirement Work Form are required to be filed in working Microsoft Excel format."]

{"sheet":"Hidden_Data Input","index":13,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Utility Name","EB Number","Test Year","Bridge Year","Last Rebasing Year","Data Elements","Heading","Intital Application","Per Board Decision"]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Gross Fixed Assets (average)","Rate Base",{"$f":"'3. Data_Input_Sheet'!E16","v":130756206},{"$f":"'3. Data_Input_Sheet'!U16","v":130756206}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Accumulated Depreciation (average)","Rate Base",{"$f":"'3. Data_Input_Sheet'!E17","v":-53584409},{"$f":"'3. Data_Input_Sheet'!U17","v":-53584409}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Controllable Expenses","Allowance for Working Capital",{"$f":"'3. Data_Input_Sheet'!E19","v":10356735},{"$f":"'3. Data_Input_Sheet'!U19","v":10356735}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Cost of Power","Allowance for Working Capital",{"$f":"'3. Data_Input_Sheet'!E20","v":73507386},{"$f":"'3. Data_Input_Sheet'!U20","v":73507386}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Working Capital Rate (%)","Allowance for Working Capital",{"$f":"'3. Data_Input_Sheet'!E21","v":7.4999999999999997E-2},{"$f":"'3. Data_Input_Sheet'!U21","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Distribution Revenue at Current Rates","Utility Income",{"$f":"'3. Data_Input_Sheet'!E25","v":16063795.901793666},{"$f":"'3. Data_Input_Sheet'!U25","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Distribution Revenue at Proposed Rates","Utility Income",{"$f":"'3. Data_Input_Sheet'!E26","v":18388097.712427843},{"$f":"'3. Data_Input_Sheet'!U26","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Specific Service Charges","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E28","v":152000},{"$f":"'3. Data_Input_Sheet'!U28","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Late Payment Charges","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E29","v":210000},{"$f":"'3. Data_Input_Sheet'!U29","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Other Distribution Revenue","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E30","v":520033},{"$f":"'3. Data_Input_Sheet'!U30","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},"Other Income and Deductions","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E31","v":224211},{"$f":"'3. Data_Input_Sheet'!U31","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},"Total Revenue Offsets","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E33","v":1106244},{"$f":"'3. Data_Input_Sheet'!U33","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"OM+A Expenses","Operating Expenses",{"$f":"'3. Data_Input_Sheet'!E36","v":10312735},{"$f":"'3. Data_Input_Sheet'!U36","v":10312735}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Depreciation/Amortization","Operating Expenses",{"$f":"'3. Data_Input_Sheet'!E37","v":4050033.3},{"$f":"'3. Data_Input_Sheet'!U37","v":4050033.3}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Property taxes","Operating Expenses",{"$f":"'3. Data_Input_Sheet'!E38","v":44000},{"$f":"'3. Data_Input_Sheet'!U38","v":44000}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Other expenses","Operating Expenses",{"$f":"'3. Data_Input_Sheet'!E40","v":0},{"$f":"'3. Data_Input_Sheet'!U40","v":""}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Adjustments required to arrive at taxable income","Taxable Income",{"$f":"'3. Data_Input_Sheet'!E44","v":-2520502},{"$f":"'3. Data_Input_Sheet'!U44","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Income taxes (not grossed up)","Utility Income Taxes",{"$f":"'3. Data_Input_Sheet'!E46","v":144837},{"$f":"'3. Data_Input_Sheet'!U46","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Federal tax (%)","Income taxes (grossed up)",{"$f":"'3. Data_Input_Sheet'!E49","v":0.15},{"$f":"'3. Data_Input_Sheet'!U49","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Provincial tax (%)","Income taxes (grossed up)",{"$f":"'3. Data_Input_Sheet'!E50","v":0.115},{"$f":"'3. Data_Input_Sheet'!U50","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Income Tax Credits","Income taxes (grossed up)",{"$f":"'3. Data_Input_Sheet'!E51","v":0},{"$f":"'3. Data_Input_Sheet'!U51","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Long-term debt Capitalization Ratio (%)","Capitalization",{"$f":"'3. Data_Input_Sheet'!E55","v":0.56000000000000005},{"$f":"'3. Data_Input_Sheet'!U55","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Short-term debt Capitalization Ratio (%)","Capitalization",{"$f":"'3. Data_Input_Sheet'!E56","v":0.04},{"$f":"'3. Data_Input_Sheet'!U56","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Common Equity Capitalization Ratio (%)","Capitalization",{"$f":"'3. Data_Input_Sheet'!E57","v":0.4},{"$f":"'3. Data_Input_Sheet'!U57","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Prefered Shares Capitalization Ratio (%)","Capitalization",{"$f":"'3. Data_Input_Sheet'!E58","v":0},{"$f":"'3. Data_Input_Sheet'!U58","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Long-term debt Cost Rate (%)","Cost of Capital",{"$f":"'3. Data_Input_Sheet'!E62","v":3.44E-2},{"$f":"'3. Data_Input_Sheet'!U62","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Short-term debt Cost Rate (%)","Cost of Capital",{"$f":"'3. Data_Input_Sheet'!E63","v":6.2300000000000001E-2},{"$f":"'3. Data_Input_Sheet'!U63","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Common Equity Cost Rate (%)","Cost of Capital",{"$f":"'3. Data_Input_Sheet'!E64","v":9.2100000000000001E-2},{"$f":"'3. Data_Input_Sheet'!U64","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Prefered Shares Cost Rate (%)","Cost of Capital",{"$f":"'3. Data_Input_Sheet'!E65","v":0},{"$f":"'3. Data_Input_Sheet'!U65","v":0}]

{"sheet":"Hidden Data_Rev Reqt","index":14,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Utility Name","EB Number","Test Year","Bridge Year","Last Rebasing Year","Data Elements","Intital Application","Per Board Decision"]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Service Revenue Requirement (before Revenues)",{"$f":"'9. Rev_Reqt'!F25","v":19494341.712427843},{"$f":"'9. Rev_Reqt'!N25","v":14603825.442857144}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Base Revenue Requirement",{"$f":"'9. Rev_Reqt'!F28","v":18388097.712427843},{"$f":"'9. Rev_Reqt'!N28","v":14603825.442857144}]
[{"$f":"'1. Info'!$G$16","v":"Essex Powerlines Corporation"},{"$f":"'1. Info'!$G$20","v":"EB-2024-0020"},{"$f":"'1. Info'!$G$28","v":2025},{"$f":"'1. Info'!$G$30","v":2024},{"$f":"'1. Info'!$G$32","v":2018},"Revenue Deficiency/(Sufficiency) Associated with Base Revenue Requirement",{"$f":"'9. Rev_Reqt'!F46","v":2324301.8106341772},{"$f":"'9. Rev_Reqt'!N46","v":0}]

{"sheet":"14. Tracking_Sheet","index":15,"n_rows":203,"n_cols":18,"rows_kept":203,"cut":false,"hidden":false,"merged":[[14,1,14,14],[199,0,201,0],[199,1,200,1],[190,0,192,0],[190,1,191,1],[193,0,195,0],[193,1,194,1],[196,0,198,0],[196,1,197,1],[181,0,183,0],[181,1,182,1],[184,0,186,0],[184,1,185,1],[187,0,189,0],[187,1,188,1],[172,0,174,0],[172,1,173,1],[175,0,177,0],[175,1,176,1],[178,0,180,0],[178,1,179,1],[163,0,165,0],[163,1,164,1],[166,0,168,0],[166,1,167,1],[169,0,171,0],[169,1,170,1],[154,0,156,0],[154,1,155,1],[157,0,159,0],[157,1,158,1],[160,0,162,0],[160,1,161,1],[145,0,147,0],[145,1,146,1],[148,0,150,0],[148,1,149,1],[151,0,153,0],[151,1,152,1],[136,0,138,0],[136,1,137,1],[139,0,141,0],[139,1,140,1],[142,0,144,0],[142,1,143,1],[127,0,129,0],[127,1,128,1],[130,0,132,0],[130,1,131,1],[133,0,135,0],[133,1,134,1],[118,0,120,0],[118,1,119,1],[121,0,123,0],[121,1,122,1],[124,0,126,0],[124,1,125,1],[109,0,111,0],[109,1,110,1],[112,0,114,0],[112,1,113,1],[115,0,117,0],[115,1,116,1],[100,0,102,0],[100,1,101,1],[103,0,105,0],[103,1,104,1],[106,0,108,0],[106,1,107,1],[91,0,93,0],[91,1,92,1],[94,0,96,0],[94,1,95,1],[97,0,99,0],[97,1,98,1],[82,0,84,0],[82,1,83,1],[85,0,87,0],[85,1,86,1],[88,0,90,0],[88,1,89,1],[17,3,17,4],[17,8,17,10],[17,5,17,7],[17,11,17,14],[22,1,23,1],[25,1,26,1],[22,0,24,0],[25,0,27,0],[28,0,30,0],[28,1,29,1],[55,0,57,0],[55,1,56,1],[58,0,60,0],[58,1,59,1],[37,0,39,0],[37,1,38,1],[40,0,42,0],[40,1,41,1],[31,0,33,0],[31,1,32,1],[34,0,36,0],[34,1,35,1],[49,0,51,0],[49,1,50,1],[210,1,210,14],[211,1,211,14],[15,1,15,14],[73,0,75,0],[73,1,74,1],[208,1,208,14],[76,0,78,0],[76,1,77,1],[79,0,81,0],[79,1,80,1],[67,0,69,0],[67,1,68,1],[70,0,72,0],[70,1,71,1],[61,0,63,0],[52,0,54,0],[52,1,53,1],[43,0,45,0],[43,1,44,1],[46,0,48,0],[46,1,47,1],[61,1,62,1],[64,0,66,0],[64,1,65,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tracking Form"]
[null,"The first row shown, labelled \"Original Application\", summarizes key statistics based on the data inputs into the RRWF. After the original application filing, the applicant provides key changes in capital and operating expenses, load forecasts, cost of capital, etc., as revised through the processing of the application. This could be due to revisions or responses to interrogatories. The last row shown is the most current estimate of the cost of service data reflecting the original application and any updates provided by the applicant distributor (for updated evidence, responses to interrogatories, undertakings, etc.)\nPlease ensure a Reference (Column B) and/or Item Description (Column C) is entered.  Please note that unused rows will automatically be hidden and the PRINT AREA set when the PRINT BUTTON on Sheet 1 is activated.\n(1) Short reference to evidence material (interrogatory response, undertaking, exhibit number, Board Decision, Code, Guideline, Report of the Board, etc.)\n(2) Short description of change, issue, etc.\n\n60 Tracking Rows have been provided below.  If you require more, please contact Industry Relations @ IndustryRelations@ontarioenergyboard.ca. "]
[null,"Summary of Proposed Changes"]
[]
[null,null,null,"Cost of Capital",null,"Rate Base and Capital Expenditures",null,null,"Operating Expenses",null,null,"Revenue Requirement"]
[null,"Reference (1)","Item / Description (2)","Regulated Return on Capital","Regulated Rate of Return","Rate Base","Working Capital","Working Capital Allowance ($)","Amortization / Depreciation","Taxes/PILs","OM&A","Service Revenue Requirement","Other Revenues","Base Revenue Requirement","Grossed up Revenue Deficiency / Sufficiency"]
[]
[null,null,"Original Application",{"$f":"'7. Cost_of_Capital'!P26","v":4890516.2695707008},{"$f":"'7. Cost_of_Capital'!L26","v":5.8596000000000009E-2},{"$f":"'4. Rate_Base'!G18","v":83461606.075000003},{"$f":"'4. Rate_Base'!G26","v":83864121},{"$f":"'4. Rate_Base'!G30","v":6289809.0750000002},{"$f":"'9. Rev_Reqt'!F16","v":4050033.3},{"$f":"'9. Rev_Reqt'!F19","v":197057.14285714287},{"$f":"'9. Rev_Reqt'!F15","v":10312735},{"$f":"'9. Rev_Reqt'!F25","v":19494341.712427843},{"$f":"'9. Rev_Reqt'!F32","v":1106244},{"$f":"'9. Rev_Reqt'!F28","v":18388097.712427843},{"$f":"'8. Rev_Def_Suff'!F52","v":2894210.4323497075}]
[]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B23), ISBLANK(C23)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D23=\"\",\"\",D23-D21)","v":""},{"$f":"IF(E23=\"\",\"\",E23-E21)","v":""},"","","","","","","","","",""]
[]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B26), ISBLANK(C26)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D26=\"\",\"\",D26-D23)","v":""},"","","","","","","","","","",""]
[]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B29), ISBLANK(C29)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D29=\"\",\"\",D29-D26)","v":""},"","","","","","","","","","",""]
[]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B32), ISBLANK(C32)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D32=\"\",\"\",D32-D29)","v":""},"","","","","","","","","","",""]
[]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B35), ISBLANK(C35)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D35=\"\",\"\",D35-D32)","v":""},"","","","","","","","","","",""]
[]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B38), ISBLANK(C38)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D38=\"\",\"\",D38-D35)","v":""},"","","","","","","","","","",""]
[]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B41), ISBLANK(C41)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D41=\"\",\"\",D41-D38)","v":""},"","","","","","","","","","",""]
[]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B44), ISBLANK(C44)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D44=\"\",\"\",D44-D41)","v":""},"","","","","","","","","","",""]
[]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B47), ISBLANK(C47)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D47=\"\",\"\",D47-D44)","v":""},"","","","","","","","","","",""]
[]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B50), ISBLANK(C50)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D50=\"\",\"\",D50-D47)","v":""},"","","","","","","","","","",""]
[]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B53), ISBLANK(C53)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D53=\"\",\"\",D53-D50)","v":""},"","","","","","","","","","",""]
[]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B56), ISBLANK(C56)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D56=\"\",\"\",D56-D53)","v":""},"","","","","","","","","","",""]
[]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B59), ISBLANK(C59)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D59=\"\",\"\",D59-D56)","v":""},"","","","","","","","","","",""]
[]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B62), ISBLANK(C62)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D62=\"\",\"\",D62-D59)","v":""},"","","","","","","","","","",""]
[]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B65), ISBLANK(C65)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D65=\"\",\"\",D65-D62)","v":""},"","","","","","","","","","",""]
[]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B68), ISBLANK(C68)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D68=\"\",\"\",D68-D65)","v":""},"","","","","","","","","","",""]
[]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B71), ISBLANK(C71)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D71=\"\",\"\",D71-D68)","v":""},"","","","","","","","","","",""]
[]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B74), ISBLANK(C74)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D74=\"\",\"\",D74-D71)","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Break 1"]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B77), ISBLANK(C77)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D77=\"\",\"\",D77-D74)","v":""},"","","","","","","","","","",""]
[]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B80), ISBLANK(C80)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D80=\"\",\"\",D80-D77)","v":""},"","","","","","","","","","",""]
[]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B83), ISBLANK(C83)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D83=\"\",\"\",D83-D80)","v":""},"","","","","","","","","","",""]
[]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B86), ISBLANK(C86)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D86=\"\",\"\",D86-D83)","v":""},"","","","","","","","","","",""]
[]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B89), ISBLANK(C89)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D89=\"\",\"\",D89-D86)","v":""},"","","","","","","","","","",""]
[]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B92), ISBLANK(C92)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D92=\"\",\"\",D92-D89)","v":""},"","","","","","","","","","",""]
[]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B95), ISBLANK(C95)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D95=\"\",\"\",D95-D92)","v":""},"","","","","","","","","","",""]
[]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B98), ISBLANK(C98)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D98=\"\",\"\",D98-D95)","v":""},"","","","","","","","","","",""]
[]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B101), ISBLANK(C101)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D101=\"\",\"\",D101-D98)","v":""},"","","","","","","","","","",""]
[]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B104), ISBLANK(C104)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D104=\"\",\"\",D104-D101)","v":""},"","","","","","","","","","",""]
[]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B107), ISBLANK(C107)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D107=\"\",\"\",D107-D104)","v":""},"","","","","","","","","","",""]
[]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B110), ISBLANK(C110)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D110=\"\",\"\",D110-D107)","v":""},"","","","","","","","","","",""]
[]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B113), ISBLANK(C113)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D113=\"\",\"\",D113-D110)","v":""},"","","","","","","","","","",""]
[]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B116), ISBLANK(C116)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D116=\"\",\"\",D116-D113)","v":""},"","","","","","","","","","",""]
[]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B119), ISBLANK(C119)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D119=\"\",\"\",D119-D116)","v":""},"","","","","","","","","","",""]
[]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B122), ISBLANK(C122)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D122=\"\",\"\",D122-D119)","v":""},"","","","","","","","","","",""]
[]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B125), ISBLANK(C125)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D125=\"\",\"\",D125-D122)","v":""},"","","","","","","","","","",""]
[]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B128), ISBLANK(C128)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D128=\"\",\"\",D128-D125)","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Break 2"]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B131), ISBLANK(C131)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D131=\"\",\"\",D131-D128)","v":""},"","","","","","","","","","",""]
[]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B134), ISBLANK(C134)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D134=\"\",\"\",D134-D131)","v":""},"","","","","","","","","","",""]
[]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B137), ISBLANK(C137)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D137=\"\",\"\",D137-D134)","v":""},"","","","","","","","","","",""]
[]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B140), ISBLANK(C140)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D140=\"\",\"\",D140-D137)","v":""},"","","","","","","","","","",""]
[]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B143), ISBLANK(C143)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D143=\"\",\"\",D143-D140)","v":""},"","","","","","","","","","",""]
[]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B146), ISBLANK(C146)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D146=\"\",\"\",D146-D143)","v":""},"","","","","","","","","","",""]
[]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B149), ISBLANK(C149)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D149=\"\",\"\",D149-D146)","v":""},"","","","","","","","","","",""]
[]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B152), ISBLANK(C152)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D152=\"\",\"\",D152-D149)","v":""},"","","","","","","","","","",""]
[]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B155), ISBLANK(C155)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D155=\"\",\"\",D155-D152)","v":""},"","","","","","","","","","",""]
[]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B158), ISBLANK(C158)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D158=\"\",\"\",D158-D155)","v":""},"","","","","","","","","","",""]
[]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B161), ISBLANK(C161)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D161=\"\",\"\",D161-D158)","v":""},"","","","","","","","","","",""]
[]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B164), ISBLANK(C164)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D164=\"\",\"\",D164-D161)","v":""},"","","","","","","","","","",""]
[]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B167), ISBLANK(C167)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D167=\"\",\"\",D167-D164)","v":""},"","","","","","","","","","",""]
[]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B170), ISBLANK(C170)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D170=\"\",\"\",D170-D167)","v":""},"","","","","","","","","","",""]
[]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B173), ISBLANK(C173)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D173=\"\",\"\",D173-D170)","v":""},"","","","","","","","","","",""]
[]
[52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B176), ISBLANK(C176)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D176=\"\",\"\",D176-D173)","v":""},"","","","","","","","","","",""]
[]
[53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B179), ISBLANK(C179)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D179=\"\",\"\",D179-D176)","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Break 3"]
[54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B182), ISBLANK(C182)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D182=\"\",\"\",D182-D179)","v":""},"","","","","","","","","","",""]
[]
[55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B185), ISBLANK(C185)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D185=\"\",\"\",D185-D182)","v":""},"","","","","","","","","","",""]
[]
[56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B188), ISBLANK(C188)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D188=\"\",\"\",D188-D185)","v":""},"","","","","","","","","","",""]
[]
[57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B191), ISBLANK(C191)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D191=\"\",\"\",D191-D188)","v":""},"","","","","","","","","","",""]
[]
[58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B194), ISBLANK(C194)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D194=\"\",\"\",D194-D191)","v":""},"","","","","","","","","","",""]
[]
[59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B197), ISBLANK(C197)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D197=\"\",\"\",D197-D194)","v":""},"","","","","","","","","","",""]
[]
[60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B200), ISBLANK(C200)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D200=\"\",\"\",D200-D197)","v":""},"","","","","","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Break 4"]

{"sheet":"Sheet4","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}