{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["1. Info","2. Table of Contents","3. Data_Input_Sheet","Hidden_Data Input","4. Rate_Base","5. Utility Income","6. Taxes_PILs","7. Cost_of_Capital","8. Rev_Def_Suff","9. Rev_Reqt","Hidden Data_Rev Reqt","10. Load Forecast","11. Cost_Allocation","12. Res_Rate_Design","13. Rate Design","14. Tracking_Sheet","Sheet4"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":40,"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":"1. Info","index":0,"n_rows":93,"n_cols":29,"rows_kept":93,"cut":false,"hidden":false,"merged":[[29,4,29,5],[31,4,31,5],[27,6,27,10],[29,6,29,10],[31,6,31,10],[35,1,35,3],[42,1,48,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]]}
[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 2021 Filers\n",null,{"$f":"IF('3. Data_Input_Sheet'!M12=0, \"\", '3. Data_Input_Sheet'!M12)","v":"Settlement Agreement"}]
[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]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",{"$f":"$AA$2","v":1}]
[]
[]
[]
[]
[null,null,null,null,null,"Utility Name   ","Waterloo North Hydro Inc."]
[]
[null,null,null,null,null,"Service Territory"]
[]
[null,null,null,null,null,"Assigned EB Number","EB-2020-0059",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","Albert P. Singh, VP Finance & CFO",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-888-5542",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   ","asingh@wnhydro.com",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,2021,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,"Brantford Power Inc."]
[null,null,null,null,"Bridge Year",null,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Burlington 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,11,"Canadian Niagara Power Inc."]
[null,null,null,null,"Last Rebasing Year",null,2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Centre Wellington Hydro 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,13,"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,14,"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,15,"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,16,"Elexicon Energy Inc.-Whitby 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,"Elexicon Energy Inc.-Veridian 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,18,"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,19,"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,20,"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,21,"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,22,"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,23,"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,24,"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,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,"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,29,"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,30,"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,31,"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,32,"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,33,"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,34,"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,35,"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,36,"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,37,"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,38,"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,39,"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,40,"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,41,"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,42,"Kitchener-Wilmot 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,43,"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,44,"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,45,"Lakeland Power Distribution Ltd.-Parry Sound 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,46,"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,47,"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,48,"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,49,"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,50,"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,51,"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,52,"North Bay Hydro Distribution Limited - Espanola service territory"]
[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,"North Bay Hydro Distribution Limited - North Bay service territory"]
[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,"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,55,"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,56,"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,57,"Orillia 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,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,"Peterborough Distribution 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,61,"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,62,"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,63,"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,64,"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,65,"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,66,"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,67,"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,68,"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,69,"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,70,"Waterloo North 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,71,"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,72,"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,73,"Westario Power Inc."]

{"sheet":"2. Table of Contents","index":1,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,1,28,13],[29,1,29,13],[27,1,27,7],[0,2,0,4],[1,3,1,6],[3,3,3,4],[25,1,25,7],[26,1,26,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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"]
[]
[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 yellow 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":"3. Data_Input_Sheet","index":2,"n_rows":87,"n_cols":23,"rows_kept":87,"cut":false,"hidden":false,"merged":[[79,2,79,20],[77,2,78,20],[0,2,0,12],[7,4,7,20],[19,24,20,24],[68,2,68,20],[3,2,3,10],[1,2,1,10],[2,2,2,10],[11,14,12,14],[11,6,12,6],[11,16,12,16],[11,4,12,4],[11,8,12,8],[11,20,12,20],[11,12,12,12],[87,2,88,20],[70,2,70,20],[71,2,71,20],[69,2,69,20],[86,2,86,20],[74,2,74,20],[80,2,80,20],[72,2,72,20],[75,2,75,20],[76,2,76,20],[81,2,81,20],[82,2,82,20],[83,2,83,20],[84,2,84,20],[85,2,85,20],[73,2,73,20]]}
[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 (1)"]
[]
[]
[null,null,null,null,"Initial Application",null,"(2)",null,{"$f":"IF(ISBLANK(M12),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Settlement Agreement",null,"(6)",null,{"$f":"IF(ISBLANK(M12),\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,"Per Board Decision"]
[]
[]
[null,1,"Rate Base"]
[null,null,"   Gross Fixed Assets (average)",null,421683875,null,null,null,-1161034,null,"(10)",null,{"$f":"IF(ISBLANK(E16),0,E16+I16)","v":420522841},null,"(22)",null,null,null,null,null,{"$f":"IF(ISBLANK(E16),\"\",E16+I16+Q16)","v":420522841}]
[null,null,"   Accumulated Depreciation (average)",null,-193127986,null,"(5)",null,2057342,null,"(10)",null,{"$f":"IF(ISBLANK(E17),0,E17+I17)","v":-191070644},null,"(21, 22)",null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",E17+I17+Q17)","v":-191070644}]
[null,null,"Allowance for Working Capital:"]
[null,null,"   Controllable Expenses",null,15524190,null,null,null,{"$f":"72343+10000+5668-5000+49815-775000+53753","v":-588421},null,"(11)",null,{"$f":"IF(ISBLANK(E19),0,E19+I19)","v":14935769},null,"(17, 19-20)",null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",E19+I19+Q19)","v":14935769}]
[null,null,"   Cost of Power",null,199535876,null,null,null,-25481643,null,"(12)",null,{"$f":"IF(ISBLANK(E20),0,E20+I20)","v":174054233},null,"(17, 18, 23)",null,null,null,null,null,{"$f":"IF(ISBLANK(E20),\"\",E20+I20+Q20)","v":174054233}]
[null,null,"   Working Capital Rate (%)",null,7.4999999999999997E-2,null,"(9)",null,{"$f":"IF(ISBLANK(M21),\"\",IF(ISBLANK(E21),\"\",M21-E21))","v":0},null,null,null,7.4999999999999997E-2,null,"(9)",null,{"$f":"IF(ISBLANK(U21),\"\",IF(ISBLANK(M21),\"\",U21-M21))","v":""},null,null,null,null,null,"(9)"]
[]
[null,2,"Utility Income"]
[null,null,"Operating Revenues:"]
[null,null,"   Distribution Revenue at Current Rates",null,36673723,null,null,null,{"$f":"IF(ISBLANK(M25),\"\",IF(ISBLANK(E25),\"\",M25-E25))","v":76752},null,null,null,36750475,null,"(13), (18)",null,{"$f":"IF(ISBLANK(U25),\"\",IF(ISBLANK(M25),\"\",U25-M25))","v":""}]
[null,null,"   Distribution Revenue at Proposed Rates",null,{"$f":"36673723+2624364","v":39298087},null,null,null,{"$f":"IF(ISBLANK(M26),\"\",IF(ISBLANK(E26),\"\",M26-E26))","v":-1764747.8982589692},null,null,null,37533339.101741031,null,"(16, 17-23)",null,{"$f":"IF(ISBLANK(U26),\"\",IF(ISBLANK(M26),\"\",U26-M26))","v":""}]
[null,null,"   Other Revenue:"]
[null,null,"      Specific Service Charges",null,382269,null,null,null,{"$f":"IF(ISBLANK(M28),\"\",IF(ISBLANK(E28),\"\",M28-E28))","v":49815},null,null,null,{"$f":"382269+49815","v":432084},null,"(19)",null,{"$f":"IF(ISBLANK(U28),\"\",IF(ISBLANK(M28),\"\",U28-M28))","v":""}]
[null,null,"      Late Payment Charges",null,144453,null,null,null,{"$f":"IF(ISBLANK(M29),\"\",IF(ISBLANK(E29),\"\",M29-E29))","v":0},null,null,null,144453,null,null,null,{"$f":"IF(ISBLANK(U29),\"\",IF(ISBLANK(M29),\"\",U29-M29))","v":""}]
[null,null,"      Other Distribution Revenue",null,{"$f":"1385932+172012","v":1557944},null,null,null,{"$f":"IF(ISBLANK(M30),\"\",IF(ISBLANK(E30),\"\",M30-E30))","v":-10863},null,null,null,1547081,null,"(14, 21)",null,{"$f":"IF(ISBLANK(U30),\"\",IF(ISBLANK(M30),\"\",U30-M30))","v":""}]
[null,null,"      Other Income and Deductions",null,{"$f":"764470-749397+95929+55000","v":166002},null,null,null,{"$f":"IF(ISBLANK(M31),\"\",IF(ISBLANK(E31),\"\",M31-E31))","v":0},null,null,null,{"$f":"764470-749397+95929+55000","v":166002},null,null,null,{"$f":"IF(ISBLANK(U31),\"\",IF(ISBLANK(M31),\"\",U31-M31))","v":""}]
[]
[null,null,null,"Total Revenue Offsets",2250668,null,"(7)",null,{"$f":"IF(ISBLANK(M33),\"\",IF(ISBLANK(E33),\"\",M33-E33))","v":38952},null,null,null,{"$f":"SUM(M28:M31)","v":2289620},null,null,null,{"$f":"IF(ISBLANK(U33),\"\",IF(ISBLANK(M33),\"\",U33-M33))","v":""}]
[]
[null,null,"Operating Expenses:"]
[null,null,"   OM+A Expenses",null,{"$f":"7515225+8213832+48000","v":15777057},null,null,null,{"$f":"72343+10000-5000+49815-775000","v":-647842},null,"(11, 17, 19, 20)",null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36)","v":15129215},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36+Q36)","v":15129215}]
[null,null,"   Depreciation/Amortization",null,11100527,null,null,null,-355203,null,"(10, 21)",null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37)","v":10745324},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37+Q37)","v":10745324}]
[null,null,"   Property taxes",null,471620,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38)","v":471620},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38+Q38)","v":471620}]
[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,"   Other expenses",null,null,null,null,null,null,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,3,"Taxes/PILs"]
[null,null,"Taxable Income:"]
[null,null,null,"Adjustments required to arrive at taxable income",-5676173,null,"(3)",null,{"$f":"IF(ISBLANK(M44),\"\",IF(ISBLANK(E44),\"\",M44-E44))","v":-412836},null,null,null,-6089009,null,"(15, 21, 22)",null,{"$f":"IF(ISBLANK(U44),\"\",IF(ISBLANK(M44),\"\",U44-M44))","v":""}]
[null,null,"Utility Income Taxes and Rates:"]
[null,null,"   Income taxes (not grossed up)",null,653653,null,null,null,{"$f":"IF(ISBLANK(M46),\"\",IF(ISBLANK(E46),\"\",M46-E46))","v":-189256},null,null,null,464397,null,"(15, 17-23)",null,{"$f":"IF(ISBLANK(U46),\"\",IF(ISBLANK(M46),\"\",U46-M46))","v":""}]
[null,null,"   Income taxes (grossed up)",null,{"$f":"IF(ISBLANK(E46),\"\",E46/(1-SUM(E49:E50)))","v":889323.80952380958},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M46),\"\",M46/(1-SUM(M49:M50)))","v":631832.6530612245},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(U46),\"\",U46/(1-SUM(U49:U50)))","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":0},null,null,null,0.15,null,null,null,{"$f":"IF(ISBLANK(U49),\"\",IF(ISBLANK(M49),\"\",U49-M49))","v":""}]
[null,null,"   Provincial tax (%)",null,0.115,null,null,null,{"$f":"IF(ISBLANK(M50),\"\",IF(ISBLANK(E50),\"\",M50-E50))","v":0},null,null,null,0.115,null,null,null,{"$f":"IF(ISBLANK(U50),\"\",IF(ISBLANK(M50),\"\",U50-M50))","v":""}]
[null,null,"Income Tax Credits",null,{"$f":"-3717-48247","v":-51964},null,null,null,{"$f":"IF(ISBLANK(M51),\"\",IF(ISBLANK(E51),\"\",M51-E51))","v":-23807},null,null,null,-75771,null,"(15)",null,{"$f":"IF(ISBLANK(U51),\"\",IF(ISBLANK(M51),\"\",U51-M51))","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":0},null,null,null,0.56000000000000005,null,null,null,{"$f":"IF(ISBLANK(U55),\"\",IF(ISBLANK(M55),\"\",U55-M55))","v":""}]
[null,null,"   Short-term debt Capitalization Ratio (%)",null,0.04,null,"(8)",null,{"$f":"IF(ISBLANK(M56),\"\",IF(ISBLANK(E56),\"\",M56-E56))","v":0},null,null,null,0.04,null,"(8)",null,{"$f":"IF(ISBLANK(U56),\"\",IF(ISBLANK(M56),\"\",U56-M56))","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":0},null,null,null,0.4,null,null,null,{"$f":"IF(ISBLANK(U57),\"\",IF(ISBLANK(M57),\"\",U57-M57))","v":""}]
[null,null,"   Prefered Shares Capitalization Ratio (%)",null,0,null,null,null,{"$f":"IF(ISBLANK(M58),\"\",IF(ISBLANK(E58),\"\",M58-E58))","v":0},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(U58),\"\",IF(ISBLANK(M58),\"\",U58-M58))","v":""}]
[null,null,null,null,{"$f":"SUM(E55:E58)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(M55:M58)","v":1},null,null,null,null,null,null,null,{"$f":"SUM(U55:U58)","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,"Cost of Capital"]
[null,null,"   Long-term debt Cost Rate (%)",null,3.4316623389776028E-2,null,null,null,{"$f":"IF(ISBLANK(M62),\"\",IF(ISBLANK(E62),\"\",M62-E62))","v":-9.8800322482913566E-4},null,null,null,3.3328620164946893E-2,null,null,null,{"$f":"IF(ISBLANK(U62),\"\",IF(ISBLANK(M62),\"\",U62-M62))","v":""}]
[null,null,"   Short-term debt Cost Rate (%)",null,2.75E-2,null,null,null,{"$f":"IF(ISBLANK(M63),\"\",IF(ISBLANK(E63),\"\",M63-E63))","v":-9.9999999999999985E-3},null,null,null,1.7500000000000002E-2,null,null,null,{"$f":"IF(ISBLANK(U63),\"\",IF(ISBLANK(M63),\"\",U63-M63))","v":""}]
[null,null,"   Common Equity Cost Rate (%)",null,8.5199999999999998E-2,null,null,null,{"$f":"IF(ISBLANK(M64),\"\",IF(ISBLANK(E64),\"\",M64-E64))","v":-1.799999999999996E-3},null,null,null,8.3400000000000002E-2,null,null,null,{"$f":"IF(ISBLANK(U64),\"\",IF(ISBLANK(M64),\"\",U64-M64))","v":""}]
[null,null,"   Prefered Shares Cost Rate (%)",null,0,null,null,null,{"$f":"IF(ISBLANK(M65),\"\",IF(ISBLANK(E65),\"\",M65-E65))","v":0},null,null,null,0,null,null,null,{"$f":"IF(ISBLANK(U65),\"\",IF(ISBLANK(M65),\"\",U65-M65))","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)","All inputs are in dollars ($) except where inputs are individually identified as percentages (%)"]
[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.  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."]
[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 for 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."]
[]
[null,"(10) - (16)","Interrogatory Adjustments - Please refer to Waterloo_IRR_Rev_Reqt_Workform_2021_COS_20200928"]
[null,"(17)","Pre-settlement updates: 4-Staff-100 OM&A reduction, SEC-73 OER inclusion, related PILs adjustment"]
[null,"(18)","Settlement: VECC-63 correction to CDM activity variable in Load Forecast"]
[null,"(19)","Settlement: Reclassify disconnect/reconnect specific service charges from OM&A to Other Revenue"]
[null,"(20)","Settlement: Reduction to 2021 OM&A of $775,000"]
[null,"(21)","Settlement: Change to half-year rule for depreciation (fixed assets & capital contributions/deferred revenue)"]
[null,"(22)","Settlement: Reduction to 2021 CAPEX of $550,000"]
[null,"(23)","Settlement: OER & RPP rate update to Cost of Power"]

{"sheet":"Hidden_Data Input","index":3,"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Gross Fixed Assets (average)","Rate Base",{"$f":"'3. Data_Input_Sheet'!E16","v":421683875},{"$f":"'3. Data_Input_Sheet'!U16","v":420522841}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Accumulated Depreciation (average)","Rate Base",{"$f":"'3. Data_Input_Sheet'!E17","v":-193127986},{"$f":"'3. Data_Input_Sheet'!U17","v":-191070644}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Controllable Expenses","Allowance for Working Capital",{"$f":"'3. Data_Input_Sheet'!E19","v":15524190},{"$f":"'3. Data_Input_Sheet'!U19","v":14935769}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Cost of Power","Allowance for Working Capital",{"$f":"'3. Data_Input_Sheet'!E20","v":199535876},{"$f":"'3. Data_Input_Sheet'!U20","v":174054233}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Distribution Revenue at Current Rates","Utility Income",{"$f":"'3. Data_Input_Sheet'!E25","v":36673723},{"$f":"'3. Data_Input_Sheet'!U25","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Distribution Revenue at Proposed Rates","Utility Income",{"$f":"'3. Data_Input_Sheet'!E26","v":39298087},{"$f":"'3. Data_Input_Sheet'!U26","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Specific Service Charges","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E28","v":382269},{"$f":"'3. Data_Input_Sheet'!U28","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Late Payment Charges","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E29","v":144453},{"$f":"'3. Data_Input_Sheet'!U29","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Other Distribution Revenue","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E30","v":1557944},{"$f":"'3. Data_Input_Sheet'!U30","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},"Other Income and Deductions","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E31","v":166002},{"$f":"'3. Data_Input_Sheet'!U31","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},"Total Revenue Offsets","Other Revenue",{"$f":"'3. Data_Input_Sheet'!E33","v":2250668},{"$f":"'3. Data_Input_Sheet'!U33","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"OM+A Expenses","Operating Expenses",{"$f":"'3. Data_Input_Sheet'!E36","v":15777057},{"$f":"'3. Data_Input_Sheet'!U36","v":15129215}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Depreciation/Amortization","Operating Expenses",{"$f":"'3. Data_Input_Sheet'!E37","v":11100527},{"$f":"'3. Data_Input_Sheet'!U37","v":10745324}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Property taxes","Operating Expenses",{"$f":"'3. Data_Input_Sheet'!E38","v":471620},{"$f":"'3. Data_Input_Sheet'!U38","v":471620}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Adjustments required to arrive at taxable income","Taxable Income",{"$f":"'3. Data_Input_Sheet'!E44","v":-5676173},{"$f":"'3. Data_Input_Sheet'!U44","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Income taxes (not grossed up)","Utility Income Taxes",{"$f":"'3. Data_Input_Sheet'!E46","v":653653},{"$f":"'3. Data_Input_Sheet'!U46","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Income Tax Credits","Income taxes (grossed up)",{"$f":"'3. Data_Input_Sheet'!E51","v":-51964},{"$f":"'3. Data_Input_Sheet'!U51","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Long-term debt Cost Rate (%)","Cost of Capital",{"$f":"'3. Data_Input_Sheet'!E62","v":3.4316623389776028E-2},{"$f":"'3. Data_Input_Sheet'!U62","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Short-term debt Cost Rate (%)","Cost of Capital",{"$f":"'3. Data_Input_Sheet'!E63","v":2.75E-2},{"$f":"'3. Data_Input_Sheet'!U63","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Common Equity Cost Rate (%)","Cost of Capital",{"$f":"'3. Data_Input_Sheet'!E64","v":8.5199999999999998E-2},{"$f":"'3. Data_Input_Sheet'!U64","v":0}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Prefered Shares Cost Rate (%)","Cost of Capital",{"$f":"'3. Data_Input_Sheet'!E65","v":0},{"$f":"'3. Data_Input_Sheet'!U65","v":0}]

{"sheet":"4. Rate_Base","index":4,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,3,33,22],[34,3,34,22],[35,3,35,22],[40,3,40,22],[41,3,41,22],[36,3,36,22],[37,3,37,22],[38,3,38,22],[39,3,39,22],[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]]}
[]
[]
[]
[]
[]
[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":"Settlement Agreement"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!Q12),\"\",'3. Data_Input_Sheet'!Q12)","v":"Adjustments"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","v":"Per Board Decision"}]
[]
[null,1,null,"Gross Fixed Assets (average)","(2)",null,{"$f":"'3. Data_Input_Sheet'!E16","v":421683875},null,null,null,{"$f":"'3. Data_Input_Sheet'!I16","v":-1161034},null,null,null,{"$f":"G13+K13","v":420522841},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q16","v":0},null,null,null,{"$f":"G13+K13+S13","v":420522841}]
[null,2,null,"Accumulated Depreciation (average)","(2)",null,{"$f":"'3. Data_Input_Sheet'!E17","v":-193127986},null,null,null,{"$f":"'3. Data_Input_Sheet'!I17","v":2057342},null,null,null,{"$f":"G14+K14","v":-191070644},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q17","v":0},null,null,null,{"$f":"G14+K14+S14","v":-191070644}]
[null,3,null,"Net Fixed Assets (average)","(2)",null,{"$f":"SUM(G13:G14)","v":228555889},null,null,null,{"$f":"SUM(K13:K14)","v":896308},null,null,null,{"$f":"SUM(O13:O14)","v":229452197},null,null,null,{"$f":"SUM(S13:S14)","v":0},null,null,null,{"$f":"SUM(W13:W14)","v":229452197}]
[]
[null,4,null,"Allowance for Working Capital","(1)",null,{"$f":"G30","v":16129504.949999999},null,null,null,{"$f":"K30","v":-1955254.7999999989},null,null,null,{"$f":"O30","v":14174250.15},null,null,null,{"$f":"S30","v":-14174250.15},null,null,null,{"$f":"W30","v":0}]
[null,null,null,"Total Rate Base",null,null,{"$f":"G17+G15","v":244685393.94999999},null,null,null,{"$f":"K17+K15","v":-1058946.7999999989},null,null,null,{"$f":"O17+O15","v":243626447.15000001},null,null,null,{"$f":"S17+S15","v":-14174250.15},null,null,null,{"$f":"W15+W17","v":229452197}]
[null,5]
[null,null,"(1)","Allowance for Working Capital - Derivation"]
[]
[]
[]
[null,6,null,"Controllable Expenses",null,null,{"$f":"'3. Data_Input_Sheet'!E19","v":15524190},null,null,null,{"$f":"'3. Data_Input_Sheet'!I19","v":-588421},null,null,null,{"$f":"G24+K24","v":14935769},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q19","v":0},null,null,null,{"$f":"G24+K24+S24","v":14935769}]
[null,7,null,"Cost of Power",null,null,{"$f":"'3. Data_Input_Sheet'!E20","v":199535876},null,null,null,{"$f":"'3. Data_Input_Sheet'!I20","v":-25481643},null,null,null,{"$f":"G25+K25","v":174054233},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q20","v":0},null,null,null,{"$f":"G25+K25+S25","v":174054233}]
[null,8,null,"Working Capital Base",null,null,{"$f":"SUM(G24:G25)","v":215060066},null,null,null,{"$f":"K24+K25","v":-26070064},null,null,null,{"$f":"SUM(O24:O25)","v":188990002},null,null,null,{"$f":"S24+S25","v":0},null,null,null,{"$f":"SUM(W24:W25)","v":188990002}]
[]
[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":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M21","v":7.4999999999999997E-2},null,null,null,{"$f":"W28-O28","v":-7.4999999999999997E-2},null,null,null,{"$f":"'3. Data_Input_Sheet'!U21","v":0}]
[]
[null,10,null,"Working Capital Allowance",null,null,{"$f":"G26*G28","v":16129504.949999999},null,null,null,{"$f":"O30-G30","v":-1955254.7999999989},null,null,null,{"$f":"O26*O28","v":14174250.15},null,null,null,{"$f":"W30-O30","v":-14174250.15},null,null,null,{"$f":"W26*W28","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 2021 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":5,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,9,48,9],[47,13,48,13],[47,17,48,17],[34,9,35,9],[36,9,37,9],[26,9,27,9],[34,21,35,21],[34,5,35,5],[36,21,37,21],[36,5,37,5],[36,17,37,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],[56,3,56,21],[54,3,54,21],[55,3,55,21],[51,3,51,21],[26,5,27,5],[53,3,53,21],[52,3,52,21],[47,5,48,5],[47,21,48,21],[41,1,41,21],[36,13,37,13],[26,21,27,21],[26,13,27,13],[34,13,35,13],[26,17,27,17],[34,17,35,17]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Settlement Agreement"},null,null,null,{"$f":"IF(N13=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","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":39298087},null,null,null,{"$f":"N16-F16","v":-1764747.8982589692},null,null,null,{"$f":"'3. Data_Input_Sheet'!M26","v":37533339.101741031},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":37533339.101741031}]
[null,2,null,"Other Revenue","(1)",{"$f":"F48","v":2250668},null,null,null,{"$f":"N17-F17","v":38952},null,null,null,{"$f":"N48","v":2289620},null,null,null,{"$f":"V17-N17","v":0},null,null,null,{"$f":"V48","v":2289620}]
[null,null,null,null,null,{"$f":"SUM(F16:F17)","v":41548755},null,null,null,{"$f":"SUM(J16:J17)","v":-1725795.8982589692},null,null,null,{"$f":"SUM(N16:N17)","v":39822959.101741031},null,null,null,{"$f":"SUM(R16:R17)","v":0},null,null,null,{"$f":"SUM(V16:V17)","v":39822959.101741031}]
[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":15777057},null,null,null,{"$f":"'3. Data_Input_Sheet'!I36","v":-647842},null,null,null,{"$f":"'3. Data_Input_Sheet'!M36","v":15129215},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U36","v":15129215}]
[null,5,null,"Depreciation/Amortization",null,{"$f":"'3. Data_Input_Sheet'!E37","v":11100527},null,null,null,{"$f":"'3. Data_Input_Sheet'!I37","v":-355203},null,null,null,{"$f":"'3. Data_Input_Sheet'!M37","v":10745324},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q37","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U37","v":10745324}]
[null,6,null,"Property taxes",null,{"$f":"'3. Data_Input_Sheet'!E38","v":471620},null,null,null,{"$f":"'3. Data_Input_Sheet'!I38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M38","v":471620},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U38","v":471620}]
[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,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,null,null,{"$f":"SUM(F22:F26)","v":27349204},null,null,null,{"$f":"SUM(J22:J26)","v":-1003045},null,null,null,{"$f":"SUM(N22:N26)","v":26346159},null,null,null,{"$f":"SUM(R22:R26)","v":0},null,null,null,{"$f":"SUM(V22:V26)","v":26346159}]
[null,9,null,"Subtotal (lines 4 to 8)"]
[]
[null,10,null,"Deemed Interest Expense",null,{"$f":"'7. Cost_of_Capital'!P19","v":4971348.7807152346},null,null,null,{"$f":"N30-F30","v":-253759.60895943362},null,null,null,{"$f":"'7. Cost_of_Capital'!P35","v":4717589.171755801},null,null,null,{"$f":"V30-N30","v":-55737.96202861052},null,null,null,{"$f":"'7. Cost_of_Capital'!P51","v":4661851.2097271904}]
[]
[null,11,null,"Total Expenses (lines 9 to 10)",null,{"$f":"F27+F30","v":32320552.780715235},null,null,null,{"$f":"J30+J27","v":-1256804.6089594336},null,null,null,{"$f":"N30+N27","v":31063748.171755802},null,null,null,{"$f":"R30+R27","v":-55737.96202861052},null,null,null,{"$f":"V27+V30","v":31008010.20972719}]
[]
[null,12,null,"Utility income before income taxes",null,{"$f":"F18-(F32)","v":9228202.2192847654},null,null,null,{"$f":"J18-(J32)","v":-468991.28929953557},null,null,null,{"$f":"N18-(N32)","v":8759210.9299852289},null,null,null,{"$f":"R18-(R32)","v":55737.96202861052},null,null,null,{"$f":"V18-(V32)","v":8814948.8920138404}]
[null,null,null,null,null,{"$f":"'6. Taxes_PILs'!G31","v":889323.80952380958},null,null,null,{"$f":"N35-F35","v":-257491.15646258509},null,null,null,{"$f":"'6. Taxes_PILs'!K31","v":631832.6530612245},null,null,null,{"$f":"V35-N35","v":0},null,null,null,{"$f":"IF('6. Taxes_PILs'!O31=0,N35,'6. Taxes_PILs'!O31)","v":631832.6530612245}]
[null,13,null,"Income taxes (grossed-up)"]
[null,null,null,null,null,{"$f":"F34-F35","v":8338878.4097609557},null,null,null,{"$f":"J34-J35","v":-211500.13283695048},null,null,null,{"$f":"N34-N35","v":8127378.2769240048},null,null,null,{"$f":"R34-R35","v":55737.96202861052},null,null,null,{"$f":"V34-V35","v":8183116.2389526162}]
[null,14,null,"Utility net income"]
[]
[]
[]
[null,"Notes"]
[]
[null,"(1)",null,"  Specific Service Charges",null,{"$f":"'3. Data_Input_Sheet'!E28","v":382269},null,null,null,{"$f":"'3. Data_Input_Sheet'!I28","v":49815},null,null,null,{"$f":"'3. Data_Input_Sheet'!M28","v":432084},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":432084}]
[null,null,null,"  Late Payment Charges",null,{"$f":"'3. Data_Input_Sheet'!E29","v":144453},null,null,null,{"$f":"'3. Data_Input_Sheet'!I29","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M29","v":144453},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":144453}]
[null,null,null,"  Other Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E30","v":1557944},null,null,null,{"$f":"'3. Data_Input_Sheet'!I30","v":-10863},null,null,null,{"$f":"'3. Data_Input_Sheet'!M30","v":1547081},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":1547081}]
[null,null,null,"  Other Income and Deductions",null,{"$f":"'3. Data_Input_Sheet'!E31","v":166002},null,null,null,{"$f":"'3. Data_Input_Sheet'!I31","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M31","v":166002},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":166002}]
[null,null,null,null,null,{"$f":"SUM(F44:F47)","v":2250668},null,null,null,{"$f":"SUM(J44:J47)","v":38952},null,null,null,{"$f":"SUM(N44:N47)","v":2289620},null,null,null,{"$f":"SUM(R44:R47)","v":0},null,null,null,{"$f":"SUM(V44:V47)","v":2289620}]
[null,null,null,"Total Revenue Offsets"]

{"sheet":"6. Taxes_PILs","index":6,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,3,44,14],[51,3,51,14],[52,3,52,14],[45,3,45,14],[49,3,49,14],[50,3,50,14],[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],[25,10,26,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","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":8338878.2258159993},null,null,null,{"$f":"'7. Cost_of_Capital'!P38","v":8127378.2769240011},null,null,null,{"$f":"'7. Cost_of_Capital'!P54","v":7819730.8737600008}]
[]
[null,2,null,"Adjustments required to arrive at taxable utility income",null,null,{"$f":"'3. Data_Input_Sheet'!E44","v":-5676173},null,null,null,{"$f":"'3. Data_Input_Sheet'!M44","v":-6089009},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),K18,'3. Data_Input_Sheet'!U44)","v":-6089009}]
[]
[null,3,null,"Taxable income",null,null,{"$f":"G16+G18","v":2662705.2258159993},null,null,null,{"$f":"K16+K18","v":2038369.2769240011},null,null,null,{"$f":"O16+O18","v":1730721.8737600008}]
[]
[null,null,null,"Calculation of Utility income Taxes"]
[]
[null,4,null,"Income taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E46","v":653653},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M46),'6. Taxes_PILs'!G24,'3. Data_Input_Sheet'!M46)","v":464397},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U46),'6. Taxes_PILs'!K24,'3. Data_Input_Sheet'!U46)","v":464397}]
[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,null,null,null,{"$f":"SUM(G24:G25)","v":653653},null,null,null,{"$f":"SUM(K24:K25)","v":464397},null,null,null,{"$f":"SUM(O24:O25)","v":464397}]
[null,6,null,"Total taxes"]
[]
[null,7,null,"Gross-up of Income Taxes",null,null,{"$f":"(G24/(1-G41))-G24","v":235670.80952380958},null,null,null,{"$f":"(K24/(1-K41))-K24","v":167435.6530612245},null,null,null,{"$f":"(O24/(1-O41))-O24","v":167435.6530612245}]
[]
[null,8,null,"Grossed-up Income Taxes",null,null,{"$f":"G24+G29","v":889323.80952380958},null,null,null,{"$f":"K24+K29","v":631832.6530612245},null,null,null,{"$f":"O24+O29","v":631832.6530612245}]
[]
[null,9,null,"PILs / tax Allowance (Grossed-up Income taxes + Capital taxes)",null,null,{"$f":"G26+G29","v":889323.80952380958},null,null,null,{"$f":"K29+K26","v":631832.6530612245},null,null,null,{"$f":"O29+O26","v":631832.6530612245}]
[]
[null,10,null,"Other tax Credits",null,null,{"$f":"'3. Data_Input_Sheet'!E51","v":-51964},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),G35,'3. Data_Input_Sheet'!M51)","v":-75771},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),K35,'3. Data_Input_Sheet'!U51)","v":-75771}]
[]
[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,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,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,"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":7,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[[13,3,13,15],[29,3,29,15],[44,5,44,9],[28,5,28,9],[66,3,66,15],[60,1,60,15],[45,3,45,15],[67,3,67,15],[65,3,65,15],[62,3,62,15],[63,3,63,15],[64,3,64,15],[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]]}
[]
[]
[]
[]
[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":137023820.61200002},null,{"$f":"'3. Data_Input_Sheet'!E62","v":3.4316623389776028E-2},null,null,null,{"$f":"L17*J17","v":4702194.8473702343}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E56","v":0.04},null,null,null,{"$f":"$J$26*F18","v":9787415.7579999994},null,{"$f":"'3. Data_Input_Sheet'!E63","v":2.75E-2},null,null,null,{"$f":"L18*J18","v":269153.93334499997}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F17:F18)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J17:J18)","v":146811236.37},null,{"$f":"IF(F19=0,0,SUMPRODUCT(F17:F18,L17:L18)/F19)","v":3.3862181830457624E-2},null,null,null,{"$f":"SUM(P17:P18)","v":4971348.7807152346}]
[]
[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":97874157.579999998},null,{"$f":"'3. Data_Input_Sheet'!E64","v":8.5199999999999998E-2},null,null,null,{"$f":"L22*J22","v":8338878.2258159993}]
[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":97874157.579999998},null,{"$f":"IF(F24=0,0,SUMPRODUCT(F22:F23,L22:L23)/F24)","v":8.5199999999999998E-2},null,null,null,{"$f":"SUM(P22:P23)","v":8338878.2258159993}]
[]
[null,7,null,"Total",null,{"$f":"SUM(F19,F24)","v":1},null,null,null,{"$f":"'4. Rate_Base'!G18","v":244685393.94999999},null,{"$f":"(L19*F19)+(L24*F24)","v":5.4397309098274574E-2},null,null,null,{"$f":"P19+P24","v":13310227.006531235}]
[]
[]
[null,null,null,null,null,{"$f":"'1. Info'!AC1","v":"Settlement Agreement"}]
[]
[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.56000000000000005},null,null,null,{"$f":"$J$42*F33","v":136430810.40400001},null,{"$f":"'3. Data_Input_Sheet'!M62","v":3.3328620164946893E-2},null,null,null,{"$f":"L33*J33","v":4547050.6587508013}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M56","v":0.04},null,null,null,{"$f":"$J$42*F34","v":9745057.8859999999},null,{"$f":"'3. Data_Input_Sheet'!M63","v":1.7500000000000002E-2},null,null,null,{"$f":"L34*J34","v":170538.51300500002}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F33:F34)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J33:J34)","v":146175868.29000002},null,{"$f":"IF(F35=0,0,SUMPRODUCT(F33:F34,L33:L34)/F35)","v":3.22733788206171E-2},null,null,null,{"$f":"SUM(P33:P34)","v":4717589.171755801}]
[]
[null,null,null,"Equity"]
[null,4,null,"  Common Equity",null,{"$f":"'3. Data_Input_Sheet'!M57","v":0.4},null,null,null,{"$f":"$J$42*F38","v":97450578.860000014},null,{"$f":"'3. Data_Input_Sheet'!M64","v":8.3400000000000002E-2},null,null,null,{"$f":"L38*J38","v":8127378.2769240011}]
[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.4},null,null,null,{"$f":"SUM(J38:J39)","v":97450578.860000014},null,{"$f":"IF(F40=0,0,SUMPRODUCT(F38:F39,L38:L39)/F40)","v":8.3400000000000002E-2},null,null,null,{"$f":"SUM(P38:P39)","v":8127378.2769240011}]
[]
[null,7,null,"Total",null,{"$f":"F35+F40","v":1},null,null,null,{"$f":"'4. Rate_Base'!O18","v":243626447.15000001},null,{"$f":"(L35*F35)+(L40*F40)","v":5.272402729237026E-2},null,null,null,{"$f":"P35+P40","v":12844967.448679801}]
[]
[]
[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'!U55),F33,'3. Data_Input_Sheet'!U55)","v":0.56000000000000005},null,null,null,{"$f":"$J$58*F49","v":128493230.32000001},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U62),L17,'3. Data_Input_Sheet'!U62)","v":3.4316623389776028E-2},null,null,null,{"$f":"L49*J49","v":4409453.7930271905}]
[null,9,null,"  Short-term Debt",null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U56),F34,'3. Data_Input_Sheet'!U56)","v":0.04},null,null,null,{"$f":"$J$58*F50","v":9178087.8800000008},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U63),L18,'3. Data_Input_Sheet'!U63)","v":2.75E-2},null,null,null,{"$f":"L50*J50","v":252397.41670000003}]
[null,10,null,"Total Debt",null,{"$f":"SUM(F49:F50)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J49:J50)","v":137671318.20000002},null,{"$f":"IF(F51=0,0,SUMPRODUCT(F49:F50,L49:L50)/F51)","v":3.3862181830457624E-2},null,null,null,{"$f":"SUM(P49:P50)","v":4661851.2097271904}]
[]
[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.4},null,null,null,{"$f":"$J$58*F54","v":91780878.800000012},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U64),L22,'3. Data_Input_Sheet'!U64)","v":8.5199999999999998E-2},null,null,null,{"$f":"L54*J54","v":7819730.8737600008}]
[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.4},null,null,null,{"$f":"SUM(J54:J55)","v":91780878.800000012},null,{"$f":"IF(F56=0,0,SUMPRODUCT(F54:F55,L54:L55)/F56)","v":8.5199999999999998E-2},null,null,null,{"$f":"SUM(P54:P55)","v":7819730.8737600008}]
[]
[null,14,null,"Total",null,{"$f":"F51+F56","v":1},null,null,null,{"$f":"'4. Rate_Base'!W18","v":229452197},null,{"$f":"(L51*F51)+(L56*F56)","v":5.4397309098274574E-2},null,null,null,{"$f":"P51+P56","v":12481582.08348719}]
[]
[]
[null,"Notes"]

{"sheet":"8. Rev_Def_Suff","index":8,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[[59,3,59,15],[55,3,55,15],[57,3,57,15],[58,3,58,15],[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],[56,3,56,15],[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]]}
[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":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","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,1,null,"Revenue Deficiency from Below",null,null,null,{"$f":"F52","v":2624363.6593764583},null,null,null,{"$f":"J52","v":782863.90906736813},null,null,null,{"$f":"N52","v":308558.05157753226}]
[null,2,null,"Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E25","v":36673723},null,{"$f":"'3. Data_Input_Sheet'!E26-H19","v":36673723.340623543},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M25),'3. Data_Input_Sheet'!E25,'3. Data_Input_Sheet'!M25)","v":36750475},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M26),'3. Data_Input_Sheet'!E26-L19,'3. Data_Input_Sheet'!M26-L19)","v":36750475.192673661},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U25),'3. Data_Input_Sheet'!M25,'3. Data_Input_Sheet'!U25)","v":36750475},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),'3. Data_Input_Sheet'!M26-P19,'3. Data_Input_Sheet'!U26-P19)","v":37224781.0501635}]
[null,3,null,"Other Operating Revenue Offsets - net",null,{"$f":"'5. Utility Income'!F48","v":2250668},null,{"$f":"'5. Utility Income'!F48","v":2250668},null,{"$f":"'5. Utility Income'!N48","v":2289620},null,{"$f":"J21","v":2289620},null,{"$f":"'5. Utility Income'!V48","v":2289620},null,{"$f":"'5. Utility Income'!V48","v":2289620}]
[null,4,null,"Total Revenue",null,{"$f":"SUM(F20:F21)","v":38924391},null,{"$f":"SUM(H19:H21)","v":41548755},null,{"$f":"SUM(J20:J21)","v":39040095},null,{"$f":"SUM(L19:L21)","v":39822959.101741031},null,{"$f":"SUM(N20:N21)","v":39040095},null,{"$f":"SUM(P19:P21)","v":39822959.101741031}]
[]
[null,5,null,"Operating Expenses",null,{"$f":"'5. Utility Income'!F27","v":27349204},null,{"$f":"'5. Utility Income'!F27","v":27349204},null,{"$f":"'5. Utility Income'!N27","v":26346159},null,{"$f":"'5. Utility Income'!N27","v":26346159},null,{"$f":"'5. Utility Income'!V27","v":26346159},null,{"$f":"'5. Utility Income'!V27","v":26346159}]
[null,6,null,"Deemed Interest Expense",null,{"$f":"'5. Utility Income'!F30","v":4971348.7807152346},null,{"$f":"'5. Utility Income'!F30","v":4971348.7807152346},null,{"$f":"'5. Utility Income'!N30","v":4717589.171755801},null,{"$f":"'5. Utility Income'!N30","v":4717589.171755801},null,{"$f":"'5. Utility Income'!V30","v":4661851.2097271904},null,{"$f":"'5. Utility Income'!V30","v":4661851.2097271904}]
[null,8,null,"Total Cost and Expenses",null,{"$f":"SUM(F24:F25)","v":32320552.780715235},null,{"$f":"SUM(H24:H25)","v":32320552.780715235},null,{"$f":"SUM(J24:J25)","v":31063748.171755802},null,{"$f":"SUM(L24:L25)","v":31063748.171755802},null,{"$f":"SUM(N24:N25)","v":31008010.20972719},null,{"$f":"SUM(P24:P25)","v":31008010.20972719}]
[]
[null,9,null,"Utility Income Before Income Taxes",null,{"$f":"F22-F26","v":6603838.2192847654},null,{"$f":"H22-H26","v":9228202.2192847654},null,{"$f":"J22-J26","v":7976346.8282441981},null,{"$f":"L22-L26","v":8759210.9299852289},null,{"$f":"N22-N26","v":8032084.7902728096},null,{"$f":"P22-P26","v":8814948.8920138404}]
[null,null,null,"   "]
[null,10,null,"Tax Adjustments to Accounting               Income per 2013 PILs model",null,{"$f":"'3. Data_Input_Sheet'!E44","v":-5676173},null,{"$f":"'3. Data_Input_Sheet'!E44","v":-5676173},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-6089009},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-6089009},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":-6089009},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":-6089009}]
[null,11,null,"Taxable Income",null,{"$f":"SUM(F28:F30)","v":927665.21928476542},null,{"$f":"SUM(H28:H30)","v":3552029.2192847654},null,{"$f":"SUM(J28+J30)","v":1887337.8282441981},null,{"$f":"L28+L30","v":2670201.9299852289},null,{"$f":"SUM(N28+N30)","v":1943075.7902728096},null,{"$f":"P28+P30","v":2725939.8920138404}]
[]
[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,13,null,"Income Tax on Taxable Income",null,{"$f":"MAX(F31*F33,0)","v":245831.28311046286},null,{"$f":"MAX(H31*H33,0)","v":941287.74311046291},null,{"$f":"MAX(J31*J33,0)","v":500144.52448471251},null,{"$f":"MAX(L31*L33,0)","v":707603.51144608576},null,{"$f":"MAX(N31*N33,0)","v":514915.08442229457},null,{"$f":"MAX(P31*P33,0)","v":722374.07138366776}]
[null,14,null,"Income Tax Credits",null,{"$f":"'3. Data_Input_Sheet'!E51","v":-51964},null,{"$f":"'3. Data_Input_Sheet'!E51","v":-51964},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":-75771},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":-75771},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":-75771},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":-75771}]
[null,15,null,"Utility Net Income ",null,{"$f":"F28-SUM(F34:F35)","v":6409970.9361743024},null,{"$f":"'5. Utility Income'!F37","v":8338878.4097609557},null,{"$f":"J28-SUM(J34:J35)","v":7551973.3037594855},null,{"$f":"'5. Utility Income'!N37","v":8127378.2769240048},null,{"$f":"N28-SUM(N34:N35)","v":7592940.7058505146},null,{"$f":"'5. Utility Income'!V37","v":8183116.2389526162}]
[]
[null,16,null,"Utility Rate Base",null,{"$f":"'4. Rate_Base'!G18","v":244685393.94999999},null,{"$f":"'4. Rate_Base'!G18","v":244685393.94999999},null,{"$f":"'4. Rate_Base'!O18","v":243626447.15000001},null,{"$f":"'4. Rate_Base'!O18","v":243626447.15000001},null,{"$f":"'4. Rate_Base'!W18","v":229452197},null,{"$f":"'4. Rate_Base'!W18","v":229452197}]
[]
[null,17,null,"Deemed Equity Portion of Rate Base ",null,{"$f":"'7. Cost_of_Capital'!J24","v":97874157.579999998},null,{"$f":"F40","v":97874157.579999998},null,{"$f":"'7. Cost_of_Capital'!J40","v":97450578.860000014},null,{"$f":"J40","v":97450578.860000014},null,{"$f":"'7. Cost_of_Capital'!J56","v":91780878.800000012},null,{"$f":"N40","v":91780878.800000012}]
[]
[null,18,null,"Income/(Equity Portion of Rate Base)",null,{"$f":"IF(F40=0,0,F36/F40)","v":6.5491965342689626E-2},null,{"$f":"IF(H40=0,0,H36/H40)","v":8.5200001879402701E-2},null,{"$f":"IF(J40=0,0,J36/J40)","v":7.7495417596326888E-2},null,{"$f":"IF(L40=0,0,L36/L40)","v":8.3400000000000044E-2},null,{"$f":"IF(N40=0,0,N36/N40)","v":8.2729004179577695E-2},null,{"$f":"IF(P40=0,0,P36/P40)","v":8.9159270928146905E-2}]
[null,19,null,"Target Return - Equity on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L24","v":8.5199999999999998E-2},null,{"$f":"'7. Cost_of_Capital'!L24","v":8.5199999999999998E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":8.3400000000000002E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":8.3400000000000002E-2},null,{"$f":"'7. Cost_of_Capital'!L56","v":8.5199999999999998E-2},null,{"$f":"'7. Cost_of_Capital'!L56","v":8.5199999999999998E-2}]
[null,20,null,"Deficiency/Sufficiency in Return on Equity",null,{"$f":"F42-F43","v":-1.9708034657310372E-2},null,{"$f":"H42-H43","v":1.8794027029089833E-9},null,{"$f":"J42-J43","v":-5.9045824036731143E-3},null,{"$f":"L42-L43","v":0},null,{"$f":"N42-N43","v":-2.4709958204223031E-3},null,{"$f":"P42-P43","v":3.9592709281469074E-3}]
[]
[null,21,null,"Indicated Rate of Return",null,{"$f":"IF(F38=0,0,(F36+F25)/F38)","v":4.6514095235350432E-2},null,{"$f":"IF(H38=0,0,(H36+H25)/H38)","v":5.4397309850035658E-2},null,{"$f":"IF(J38=0,0,(J36+J25)/J38)","v":5.0362194330901021E-2},null,{"$f":"IF(L40=0,0,(L36+L25)/L38)","v":5.2724027292370274E-2},null,{"$f":"IF(N38=0,0,(N36+N25)/N38)","v":5.3408910770105664E-2},null,{"$f":"IF(P40=0,0,(P36+P25)/P38)","v":5.5981017469533344E-2}]
[null,22,null,"Requested Rate of Return on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L26","v":5.4397309098274574E-2},null,{"$f":"'7. Cost_of_Capital'!L26","v":5.4397309098274574E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":5.272402729237026E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":5.272402729237026E-2},null,{"$f":"'7. Cost_of_Capital'!L58","v":5.4397309098274574E-2},null,{"$f":"'7. Cost_of_Capital'!L58","v":5.4397309098274574E-2}]
[null,23,null,"Deficiency/Sufficiency in Rate of Return",null,{"$f":"F46-F47","v":-7.8832138629241419E-3},null,{"$f":"H46-H47","v":7.5176108393915086E-10},null,{"$f":"J46-J47","v":-2.3618329614692388E-3},null,{"$f":"L46-L47","v":0},null,{"$f":"N46-N47","v":-9.8839832816891016E-4},null,{"$f":"P46-P47","v":1.5837083712587699E-3}]
[]
[null,24,null,"Target Return on Equity",null,{"$f":"H50","v":8338878.2258159993},null,{"$f":"'7. Cost_of_Capital'!P24","v":8338878.2258159993},null,{"$f":"L50","v":8127378.2769240011},null,{"$f":"'7. Cost_of_Capital'!P40","v":8127378.2769240011},null,{"$f":"P50","v":7819730.8737600008},null,{"$f":"'7. Cost_of_Capital'!P56","v":7819730.8737600008}]
[null,25,null,"Revenue Deficiency/(Sufficiency)",null,{"$f":"F50-F36","v":1928907.289641697}," ",{"$f":"H38*H48","v":0.18394495697993013},null,{"$f":"J50-J36","v":575404.97316451557},null,{"$f":"L38*L48","v":0},null,{"$f":"N50-N36","v":226790.16790948622},null,{"$f":"P38*P48","v":363385.36519261642}]
[null,26,null,"Gross Revenue Deficiency/(Sufficiency)",null,{"$f":"F51/(1-F33)","v":2624363.6593764583},"(1)",null,null,{"$f":"J51/(1-J33)","v":782863.90906736813},"(1)",null,null,{"$f":"N51/(1-N33)","v":308558.05157753226},"(1)"]
[]
[]
[null,"Notes:"]
[null,"(1)",null,"Revenue Deficiency/Sufficiency divided by (1 - Tax Rate)"]

{"sheet":"9. Rev_Reqt","index":9,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,2,0,13],[0,14,0,16],[19,13,19,14],[30,13,30,14],[17,13,17,14],[18,13,18,14],[21,13,21,14],[22,13,22,14],[29,13,29,14],[26,13,26,14],[27,13,27,14],[1,2,1,17],[2,2,2,17],[3,2,3,13],[14,13,14,14],[13,13,13,14],[12,13,12,14],[7,5,7,14],[53,3,53,16],[32,13,33,14],[34,13,35,14],[40,13,40,14],[41,13,41,14],[42,13,42,14],[44,13,44,14],[45,13,45,14],[54,3,54,16],[55,3,55,16],[56,3,56,16],[15,13,15,14],[16,13,16,14],[20,13,20,14],[24,13,24,14],[51,3,51,16],[52,3,52,16],[48,1,48,14],[31,13,31,14],[32,9,33,9],[34,9,35,9],[34,5,35,5],[32,5,33,5],[38,3,38,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Settlement Agreement"},null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","v":"Per Board Decision"}]
[]
[null,1,null,"OM&A Expenses",null,{"$f":"'5. Utility Income'!F22","v":15777057},null,null,null,{"$f":"'5. Utility Income'!N22","v":15129215},null,null,null,{"$f":"'5. Utility Income'!V22","v":15129215}]
[null,2,null,"Amortization/Depreciation",null,{"$f":"'5. Utility Income'!F23","v":11100527},null,null,null,{"$f":"'5. Utility Income'!N23","v":10745324},null,null,null,{"$f":"'5. Utility Income'!V23","v":10745324}]
[null,3,null,"Property Taxes",null,{"$f":"'5. Utility Income'!F24","v":471620},null,null,null,{"$f":"'5. Utility Income'!N24","v":471620},null,null,null,{"$f":"'5. Utility Income'!V24","v":471620}]
[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,5,null,"Income Taxes (Grossed up)",null,{"$f":"'6. Taxes_PILs'!G33-F18","v":889323.80952380958},null,null,null,{"$f":"'6. Taxes_PILs'!K33-J18","v":631832.6530612245},null,null,null,{"$f":"'6. Taxes_PILs'!O33-N18","v":631832.6530612245}]
[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,7,null,"Return"]
[null,null,null,"Deemed Interest Expense",null,{"$f":"'8. Rev_Def_Suff'!F25","v":4971348.7807152346},null,null,null,{"$f":"'8. Rev_Def_Suff'!L25","v":4717589.171755801},null,null,null,{"$f":"'8. Rev_Def_Suff'!P25","v":4661851.2097271904}]
[null,null,null,"Return on Deemed Equity",null,{"$f":"'8. Rev_Def_Suff'!F50","v":8338878.2258159993},null,null,null,{"$f":"'8. Rev_Def_Suff'!L50","v":8127378.2769240011},null,null,null,{"$f":"'8. Rev_Def_Suff'!P50","v":7819730.8737600008}]
[]
[null,8,null,"Service Revenue Requirement (before Revenues)",null,{"$f":"SUM(F15:F23)","v":41548754.816055045},null,null,null,{"$f":"SUM(J15:J23)","v":39822959.101741031},null,null,null,{"$f":"SUM(N15:O23)","v":39459573.736548416}]
[]
[null,9,null,"Revenue Offsets",null,{"$f":"'3. Data_Input_Sheet'!E33","v":2250668},null,null,null,{"$f":"'3. Data_Input_Sheet'!M33","v":2289620},null,null,null,{"$f":"'3. Data_Input_Sheet'!U33","v":0}]
[null,10,null,"Base Revenue Requirement",null,{"$f":"F25-F27","v":39298086.816055045},null,null,null,{"$f":"J25-J27","v":37533339.101741031},null,null,null,{"$f":"N25-N27","v":39459573.736548416}]
[null,null,null,"(excluding Tranformer Owership Allowance credit adjustment)"]
[]
[null,11,null,"Distribution revenue",null,{"$f":"'5. Utility Income'!F16","v":39298087},null,null,null,{"$f":"'5. Utility Income'!N16","v":37533339.101741031},null,null,null,{"$f":"'5. Utility Income'!V16","v":37533339.101741031}]
[null,12,null,"Other revenue",null,{"$f":"'5. Utility Income'!F17","v":2250668},null,null,null,{"$f":"'5. Utility Income'!N17","v":2289620},null,null,null,{"$f":"'5. Utility Income'!V17","v":2289620}]
[null,null,null,null,null,{"$f":"SUM(F31:F32)","v":41548755},null,null,null,{"$f":"SUM(J31:J32)","v":39822959.101741031},null,null,null,{"$f":"SUM(N31:N32)","v":39822959.101741031}]
[null,13,null,"Total revenue"]
[null,null,null,null,null,{"$f":"F33-F25","v":0.1839449554681778},null,null,null,{"$f":"J33-J25","v":0},null,null,null,{"$f":"N33-N25","v":363385.3651926145}]
[null,14,null,"Difference (Total Revenue Less Distribution Revenue Requirement before Revenues)",null,null,null,"(1)",null,null,null,"(1)",null,null,null,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":"Settlement Agreement"},null,"Δ% (2)",null,{"$f":"N13","v":"Per Board Decision"},null,null,{"$f":"L41","v":"Δ% (2)"}]
[null,null,null,"Service Revenue Requirement",null,{"$f":"F25","v":41548754.816055045},null,null,null,{"$f":"J25","v":39822959.101741031},null,{"$f":"IF($F42=0,\" \",(J42-$F42)/$F42)","v":-4.1536641036644041E-2},null,{"$f":"N25","v":39459573.736548416},null,null,{"$f":"IF($F42=0,\" \",(O42-$F42)/$F42)","v":-1}]
[null,null,null,"Grossed-Up Revenue Deficiency/(Sufficiency)",null,{"$f":"'8. Rev_Def_Suff'!F52","v":2624363.6593764583},null,null,null,{"$f":"'8. Rev_Def_Suff'!J52","v":782863.90906736813},null,{"$f":"IF($F43=0,\" \",(J43-$F43)/$F43)","v":-0.7016938158435807},null,{"$f":"'8. Rev_Def_Suff'!N52","v":308558.05157753226},null,null,{"$f":"IF($F43=0,\" \",(O43-$F43)/$F43)","v":-1}]
[]
[null,null,null,"Base Revenue Requirement (to be recovered from Distribution Rates)",null,{"$f":"F28","v":39298086.816055045},null,null,null,{"$f":"J28","v":37533339.101741031},null,{"$f":"IF($F45=0,\" \",(J45-$F45)/$F45)","v":-4.4906708119771231E-2},null,{"$f":"N28","v":39459573.736548416},null,null,{"$f":"IF($F45=0,\" \",(O45-$F45)/$F45)","v":-1}]
[null,null,null,"Revenue Deficiency/(Sufficiency) Associated with Base Revenue Requirement",null,{"$f":"'3. Data_Input_Sheet'!E26-'3. Data_Input_Sheet'!E25","v":2624364},null,null,null,{"$f":"'3. Data_Input_Sheet'!M26-'3. Data_Input_Sheet'!M25","v":782864.10174103081},null,{"$f":"IF($F46=0,\" \",(J46-$F46)/$F46)","v":-0.70169378114429604},null,{"$f":"'3. Data_Input_Sheet'!U26-'3. Data_Input_Sheet'!U25","v":0},null,null,{"$f":"IF($F46=0,\" \",(O46-$F46)/$F46)","v":-1}]
[]
[]
[null,"Notes"]
[null,"(1)",null,"Line 11 - Line 8"]
[null,"(2)",null,"Percentage Change Relative to Initial Application"]

{"sheet":"Hidden Data_Rev Reqt","index":10,"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":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Service Revenue Requirement (before Revenues)",{"$f":"'9. Rev_Reqt'!F25","v":41548754.816055045},{"$f":"'9. Rev_Reqt'!N25","v":39459573.736548416}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Base Revenue Requirement",{"$f":"'9. Rev_Reqt'!F28","v":39298086.816055045},{"$f":"'9. Rev_Reqt'!N28","v":39459573.736548416}]
[{"$f":"'1. Info'!$G$16","v":"Waterloo North Hydro Inc."},{"$f":"'1. Info'!$G$20","v":"EB-2020-0059"},{"$f":"'1. Info'!$G$28","v":2021},{"$f":"'1. Info'!$G$30","v":2020},{"$f":"'1. Info'!$G$32","v":2016},"Revenue Deficiency/(Sufficiency) Associated with Base Revenue Requirement",{"$f":"'9. Rev_Reqt'!F46","v":2624364},{"$f":"'9. Rev_Reqt'!N46","v":0}]

{"sheet":"10. Load Forecast","index":11,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[[13,1,13,21],[25,3,26,3],[59,2,59,21],[60,2,60,21],[61,2,61,21],[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],[62,2,62,21],[63,2,63,21],[54,2,54,21],[55,2,55,21],[56,2,56,21],[57,2,57,21],[58,2,58,21]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Settlement Agreement"]
[]
[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":"Settlement Agreement"},null,null,null,null,null,{"$f":"'3. Data_Input_Sheet'!U12","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,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,1,null,"Residential",null,51719,null,395056934,null,null,null,51719,null,398047339]
[null,2,null,"GS <50",null,5989,null,195573807,null,null,null,5989,null,197054213]
[null,3,null,"GS >50-Regular",null,774,null,697140723,null,1764636,null,774,null,700573709,null,1773328]
[null,4,null,"Large Use >5MW",null,1,null,95699867,null,169287,null,1,null,96424273,null,170568]
[null,5,null,"Street Light",null,15005,null,3347727,null,9302,null,15005,null,3347727,null,9302]
[null,6,null,"Unmetered Scattered Load",null,540,null,2947114,null,null,null,540,null,2947114]
[null,7,null,"Embedded Distributor",null,1,null,41857714,null,103033,null,1,null,41857714,null,103033]
[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":1431623886},null,{"$f":"SUM(J29:J48)","v":2046258},null,null,null,{"$f":"SUM(N29:N48)","v":1440252089},null,{"$f":"SUM(P29:P48)","v":2056231},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)"]
[null,null,"Please refer to Waterloo_Settlement_Load_Forecast_2021_COS_20201022"]

{"sheet":"11. Cost_Allocation","index":12,"n_rows":152,"n_cols":15,"rows_kept":152,"cut":false,"hidden":false,"merged":[[53,2,53,14],[54,2,54,14],[85,2,85,14],[15,1,15,14],[13,1,13,14],[23,8,24,8],[19,4,19,6],[52,2,52,14],[86,2,86,14],[87,2,87,14],[88,2,88,14],[93,6,94,6],[119,2,119,14],[151,2,154,14],[120,2,120,14],[121,2,121,14],[123,2,123,14],[126,6,126,8],[125,4,125,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":"Settlement Agreement"}]
[]
[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,18260988,null,{"$f":"IF(E$49=0,\"\",E28/E$49)","v":0.52203600292655961},null,21815752,null,{"$f":"IF(I$49=0,\"\",I28/I$49)","v":0.54781845819141661}]
[null,2,{"$f":"IF(ISBLANK('10. Load Forecast'!D30),\"\",'10. Load Forecast'!D30)","v":"GS <50"},null,5261206,null,{"$f":"IF(E$49=0,\"\",E29/E$49)","v":0.15040472896719678},null,6162078,null,{"$f":"IF(I$49=0,\"\",I29/I$49)","v":0.15473681902944481}]
[null,3,{"$f":"IF(ISBLANK('10. Load Forecast'!D31),\"\",'10. Load Forecast'!D31)","v":"GS >50-Regular"},null,10167367,null,0.29065960883208541,null,10511311,null,0.26395102885247679]
[null,4,{"$f":"IF(ISBLANK('10. Load Forecast'!D32),\"\",'10. Load Forecast'!D32)","v":"Large Use >5MW"},null,937129,null,2.6790175722505478E-2,null,1005147,null,2.5240389595358799E-2]
[null,5,{"$f":"IF(ISBLANK('10. Load Forecast'!D33),\"\",'10. Load Forecast'!D33)","v":"Street Light"},null,254785,null,7.2836663057685314E-3,null,211573,null,5.3128397616058615E-3]
[null,6,{"$f":"IF(ISBLANK('10. Load Forecast'!D34),\"\",'10. Load Forecast'!D34)","v":"Unmetered Scattered Load"},null,97398,null,2.7843653702111326E-3,null,114987,null,2.8874549477852715E-3]
[null,7,{"$f":"IF(ISBLANK('10. Load Forecast'!D35),\"\",'10. Load Forecast'!D35)","v":"Embedded Distributor"},null,1450,null,4.145187567307483E-5,null,2111,null,5.3009621911822273E-5]
[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":34980323},null,{"$f":"SUM(G28:G47)","v":1},null,{"$f":"SUM(I28:I47)","v":39822959},null,{"$f":"SUM(K28:K47)","v":1}]
[]
[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,null,null,"Service Revenue Requirement (from Sheet 9)",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":39822959.101741031}]
[]
[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,19891127,null,20314851,null,20314851,null,1482349]
[null,2,{"$f":"IF(ISBLANK(C29),\"\",C29)","v":"GS <50"},null,5675723,null,5796628,null,5796628,null,326629]
[null,3,"GS >50-Regular",null,10101178,null,10316354,null,10316354,null,419728]
[null,4,"Large Use >5MW",null,811698,null,828989,null,828989,null,39955]
[null,5,"Street Light",null,155034,null,158336,null,158336,null,14148]
[null,6,"Unmetered Scattered Load",null,113541,null,115960,null,115960,null,6745]
[null,7,"Embedded Distributor",null,2174,null,2220,null,2220,null,67]
[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":36750475},null,{"$f":"SUM(G62:G81)","v":37533338},null,{"$f":"SUM(I62:I81)","v":37533338},null,{"$f":"SUM(K62:K81)","v":2289621}]
[]
[]
[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,2016]
[null,null,null,null,"%",null,"%",null,"%",null,"%"]
[]
[null,1,{"$f":"IF(ISBLANK(C62),\"\",C62)","v":"Residential"},null,1.0298,null,{"$f":"IF(ISBLANK(I28),\"\",(G62+K62)/I28)","v":0.99914960529437624},null,{"$f":"IF(ISBLANK(I28),\"\",(I62+K62)/I28)","v":0.99914960529437624},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.0247999999999999,null,0.99370001483265868,null,0.99370001483265868,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-Regular",null,0.94489999999999996,null,1.021383726539915,null,1.021383726539915,null,"80 - 120",null,0.8,1.2]
[null,4,"Large Use >5MW",null,0.85,null,0.86449444708087475,null,0.86449444708087475,null,"85 - 115",null,0.85,1.1499999999999999]
[null,5,"Street Light",null,1.0298,null,0.81524580168547023,null,0.81524580168547023,null,"80 - 120",null,0.8,1.2]
[null,6,"Unmetered Scattered Load",null,1.2,null,1.0671206310278554,null,1.0671206310278554,null,"80 - 120",null,0.8,1.2]
[null,7,"Embedded Distributor",null,1,null,1.0833728090952155,null,1.0833728090952155,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 2012 with further adjustments to move within the range over two years, the Most Recent Year would be 2015. However, the ratios in 2015 would be equal to those after the adjustment in 2014."]
[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,2021,null,{"$f":"E128+1","v":2022},null,{"$f":"G128+1","v":2023}]
[]
[null,1,{"$f":"IF(ISBLANK(C98),\"\",C98)","v":"Residential"},null,{"$f":"I98","v":0.99914960529437624},null,{"$f":"IF(E130=0,\"\",E130)","v":0.99914960529437624},null,{"$f":"IF(G130=0,\"\",G130)","v":0.99914960529437624},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":0.99370001483265868},null,{"$f":"IF(E131=0,\"\",E131)","v":0.99370001483265868},null,{"$f":"IF(G131=0,\"\",G131)","v":0.99370001483265868},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-Regular",null,1.021383726539915,null,1.021383726539915,null,1.021383726539915,null,"80 - 120",null,0.8,1.2]
[null,4,"Large Use >5MW",null,0.86449444708087475,null,0.86449444708087475,null,0.86449444708087475,null,"85 - 115",null,0.85,1.1499999999999999]
[null,5,"Street Light",null,0.81524580168547023,null,0.81524580168547023,null,0.81524580168547023,null,"80 - 120",null,0.8,1.2]
[null,6,"Unmetered Scattered Load",null,1.0671206310278554,null,1.0671206310278554,null,1.0671206310278554,null,"80 - 120",null,0.8,1.2]
[null,7,"Embedded Distributor",null,1.0833728090952155,null,1.0833728090952155,null,1.0833728090952155,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 2021 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 2022 and 2023 Price Cap IR models, as necessary. For 2022 and 2023, enter the planned revenue-to-cost ratios that will be \"Change\" or \"No Change\" in 2019 (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":13,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":true,"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":51719}]
[null,null,"kWh",{"$f":"VLOOKUP(\"Residential\",'13. Rate Design'!D28:L47,7,FALSE)","v":398047339}]
[]
[null,null,"Proposed Residential Class Specific Revenue Requirement1",{"$f":"VLOOKUP(\"Residential\",'11. Cost_Allocation'!C62:K81,7,FALSE)","v":20314851}]
[]
[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":51719},{"$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":398047339},{"$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":14,"n_rows":56,"n_cols":43,"rows_kept":56,"cut":false,"hidden":false,"merged":[[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],[55,3,56,33],[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]]}
[]
[]
[]
[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":"Settlement Agreement"},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":"'3. Data_Input_Sheet'!U12","v":"Per Board Decision"},3,"R","T","V"]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Settlement Agreement"},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"]
[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,{"$f":"Q24","v":"Monthly Service Charge"},null,null,null,"Volumetric Rate",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,'10. Load Forecast'!R29)))","v":51719},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,'10. Load Forecast'!T29)))","v":398047339},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,'10. Load Forecast'!V29)))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I62),\"\",'11. Cost_Allocation'!I62)","v":20314851},null,{"$f":"IF(ISBLANK(U28),\"\",O28*U28)","v":20314851},null,{"$f":"IF(Q28=\"\",\"\",O28-Q28)","v":0},null,1,null,{"$f":"IF(ISBLANK(U28),\"\",1-U28)","v":0},null,0,null,{"$f":"IF(O28=\"\",\"\",IF(H28=0,0,IF(U28=0,0,ROUND(Q28/(H28*12),AC28))))","v":32.729999999999997},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":20313154.439999998},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":20313154.440000001}]
[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,'10. Load Forecast'!R30)))","v":5989},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,'10. Load Forecast'!T30)))","v":197054213},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,'10. Load Forecast'!V30)))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I63),\"\",'11. Cost_Allocation'!I63)","v":5796628},null,{"$f":"IF(ISBLANK(U29),\"\",O29*U29)","v":2422670.1475688135},null,{"$f":"IF(Q29=\"\",\"\",O29-Q29)","v":3373957.8524311865},null,0.41794473400204629,null,{"$f":"IF(ISBLANK(U29),\"\",1-U29)","v":0.58205526599795365},null,57458,null,{"$f":"IF(O29=\"\",\"\",IF(H29=0,0,IF(U29=0,0,ROUND(Q29/(H29*12),AC29))))","v":33.71},null,{"$f":"AC28","v":2},null,{"$f":"IF(S29=\"\",\"\",ROUND(IF(F29=\"kWh\",(S29+Y29)/J29,(S29+Y29)/L29),AI29))","v":1.7399999999999999E-2},null,"/kWh",null,{"$f":"AI28","v":4},null,{"$f":"IF(AA29=\"\",0,AA29*H29*12)","v":2422670.2800000003},null,{"$f":"ROUND(IF(AE29=\"\",0,IF(F29=\"kWh\",J29*AE29,IF(F29=\"kW\",IF(AE29=\"\",0,AE29*L29)))),AI29)","v":3428743.3062},null,{"$f":"ROUND(AK29+AM29-Y29,2)","v":5793955.5899999999}]
[null,3,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D31),\"\",'10. Load Forecast'!D31)","v":"GS >50-Regular"},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,'10. Load Forecast'!R31)))","v":774},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,'10. Load Forecast'!T31)))","v":700573709},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,'10. Load Forecast'!V31)))","v":1773328},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I64),\"\",'11. Cost_Allocation'!I64)","v":10316354},null,1169916.439257723,null,9146437.5607422777,null,0.11340406109151771,null,0.88659593890848232,null,545049,null,125.96,null,{"$f":"AC29","v":2},null,5.4650999999999996,null,"/kW",null,{"$f":"AI29","v":4},null,1169916.48,null,9691414.8528000005,null,10316282.33]
[null,4,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D32),\"\",'10. Load Forecast'!D32)","v":"Large Use >5MW"},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,'10. Load Forecast'!R32)))","v":1},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,'10. Load Forecast'!T32)))","v":96424273},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,'10. Load Forecast'!V32)))","v":170568},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I65),\"\",'11. Cost_Allocation'!I65)","v":828989},null,88319.485680906029,null,740669.51431909401,null,0.10653879084150215,null,0.8934612091584978,null,0,null,7359.96,null,2,null,4.3423999999999996,null,"/kW",null,4,null,88319.52,null,740674.48320000002,null,828994]
[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,'10. Load Forecast'!R33)))","v":15005},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,'10. Load Forecast'!T33)))","v":3347727},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,'10. Load Forecast'!V33)))","v":9302},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I66),\"\",'11. Cost_Allocation'!I66)","v":158336},null,64363.583999999995,null,93972.415999999997,null,0.40649999999999997,null,0.59350000000000003,null,0,null,0.36,null,2,null,10.102399999999999,null,"/kW",null,4,null,64821.600000000006,null,93972.524799999999,null,158794.12]
[null,6,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D34),\"\",'10. Load Forecast'!D34)","v":"Unmetered Scattered Load"},null,"kWh",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,'10. Load Forecast'!R34)))","v":540},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,'10. Load Forecast'!T34)))","v":2947114},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,'10. Load Forecast'!V34)))","v":0},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I67),\"\",'11. Cost_Allocation'!I67)","v":115960},null,72576.282544468602,null,43383.717455531398,null,0.62587342656492417,null,0.37412657343507583,null,0,null,11.2,null,2,null,1.47E-2,null,"/kWh",null,4,null,72576,null,43322.575799999999,null,115898.58]
[null,7,null,{"$f":"IF(ISBLANK('10. Load Forecast'!D35),\"\",'10. Load Forecast'!D35)","v":"Embedded Distributor"},null,"kW",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,'10. Load Forecast'!R35)))","v":1},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,'10. Load Forecast'!T35)))","v":41857714},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,'10. Load Forecast'!V35)))","v":103033},null,null,{"$f":"IF(ISBLANK('11. Cost_Allocation'!I68),\"\",'11. Cost_Allocation'!I68)","v":2220},null,0,null,2220,null,0,null,1,null,0,null,0,null,2,null,2.1499999999999998E-2,null,"/kW",null,4,null,0,null,2215.2094999999999,null,2215.21]
[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,'10. Load Forecast'!R36)))","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,'10. Load Forecast'!T36)))","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,'10. Load Forecast'!V36)))","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,'10. Load Forecast'!R37)))","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,'10. Load Forecast'!T37)))","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,'10. Load Forecast'!V37)))","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,'10. Load Forecast'!R38)))","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,'10. Load Forecast'!T38)))","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,'10. Load Forecast'!V38)))","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,'10. Load Forecast'!R39)))","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,'10. Load Forecast'!T39)))","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,'10. Load Forecast'!V39)))","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,'10. Load Forecast'!R40)))","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,'10. Load Forecast'!T40)))","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,'10. Load Forecast'!V40)))","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,'10. Load Forecast'!R41)))","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,'10. Load Forecast'!T41)))","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,'10. Load Forecast'!V41)))","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,'10. Load Forecast'!R42)))","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,'10. Load Forecast'!T42)))","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,'10. Load Forecast'!V42)))","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,'10. Load Forecast'!R43)))","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,'10. Load Forecast'!T43)))","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,'10. Load Forecast'!V43)))","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,'10. Load Forecast'!R44)))","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,'10. Load Forecast'!T44)))","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,'10. Load Forecast'!V44)))","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,'10. Load Forecast'!R45)))","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,'10. Load Forecast'!T45)))","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,'10. Load Forecast'!V45)))","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,'10. Load Forecast'!R46)))","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,'10. Load Forecast'!T46)))","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,'10. Load Forecast'!V46)))","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,'10. Load Forecast'!R47)))","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,'10. Load Forecast'!T47)))","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,'10. Load Forecast'!V47)))","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,'10. Load Forecast'!R48)))","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,'10. Load Forecast'!T48)))","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,'10. Load Forecast'!V48)))","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":602507},null,null,null,null,null,null,null,null,null,null,"Total Distribution Revenues",null,null,null,null,{"$f":"SUM(AO28:AO47)","v":37529294.269999996},null,{"$f":"SUM(AK28:AK47)+SUM(AM28:AM47)","v":38131801.272300005}]
[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":38131801.269999996}]
[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":37533339.101741031}]
[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":-4044.8317410349846}]
[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":-1.0776637085420838E-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)."]

{"sheet":"14. Tracking_Sheet","index":15,"n_rows":203,"n_cols":18,"rows_kept":203,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":13310227.006531235},{"$f":"'7. Cost_of_Capital'!L26","v":5.4397309098274574E-2},{"$f":"'4. Rate_Base'!G18","v":244685393.94999999},{"$f":"'4. Rate_Base'!G26","v":215060066},{"$f":"'4. Rate_Base'!G30","v":16129504.949999999},{"$f":"'9. Rev_Reqt'!F16","v":11100527},{"$f":"'9. Rev_Reqt'!F19","v":889323.80952380958},{"$f":"'9. Rev_Reqt'!F15","v":15777057},{"$f":"'9. Rev_Reqt'!F25","v":41548754.816055045},{"$f":"'9. Rev_Reqt'!F32","v":2250668},{"$f":"'9. Rev_Reqt'!F28","v":39298086.816055045},{"$f":"'8. Rev_Def_Suff'!F52","v":2624363.6593764583}]
[]
[1,"Load Forecast Update\n3-Staff-36, 9-Staff-78-79","Updated load forecast per 1-Staff-1",13317222.048983607,5.4397309098274574E-2,244813985.65000001,216774622,16258096.649999999,11100527,889323.80952380958,15777057,41555749.858507417,2250668,39305081.858507417,2554177.8585074171,null,{"$f":"IF(AND(ISBLANK(B23), ISBLANK(C23)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D23=\"\",\"\",D23-D21)","v":6995.0424523726106},{"$f":"IF(E23=\"\",\"\",E23-E21)","v":0},128591.70000001788,1714556,128591.69999999925,0,0,0,6995.0424523726106,0,6995.0424523726106,-70185.800869041122]
[]
[2,"Capital Update\n2-Staff-8","Updated capital additions and depreciation",13268313.32501846,5.4397309098274574E-2,243914883.75,216780290,16258521.75,11048476,889323.80952380958,15777057,41454790.134542271,2250668,39204122.134542271,2453218.1345422715,null,{"$f":"IF(AND(ISBLANK(B26), ISBLANK(C26)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D26=\"\",\"\",D26-D23)","v":-48908.72396514751},0,-899101.90000000596,5668,425.10000000149012,-52051,0,0,-100959.72396514565,0,-100959.72396514565,-100959.72396514565]
[]
[3,"OM&A Update\n4-Staff-53(b), 4-Staff-51(c )","OM&A Updates - union ratification & intervenor costs",13268649.267840192,5.4397309098274574E-2,243921059.47499999,216862633,16264697.475,11048476,889323.80952380958,15859400,41537469.077364005,2250668,39286801.077364005,2535897.0773640051,null,{"$f":"IF(AND(ISBLANK(B29), ISBLANK(C29)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D29=\"\",\"\",D29-D26)","v":335.9428217317909},0,6175.7249999940395,82343,6175.7249999996275,0,0,82343,82678.942821733654,0,82678.942821733654,82678.942821733654]
[]
[4,"Other Revenue Update\n3-Staff-38, 3-VECC-35(b)","Other revenue updates - retail service charges",13268649.267840192,5.4397309098274574E-2,243921059.47499999,216862633,16264697.475,11048476,889323.80952380958,15859400,41537469.077364005,2262317,39275152.077364005,2524248.0773640051,null,{"$f":"IF(AND(ISBLANK(B32), ISBLANK(C32)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D32=\"\",\"\",D32-D29)","v":0},0,0,0,0,0,0,0,0,11649,-11649,-11649]
[]
[5,"PILs Update\n4-Staff-59, 1-Staff-1","PILs model updates incorporating all changes",13268649.267840192,5.4397309098274574E-2,243921059.47499999,216862633,16264697.475,11048476,782125.17006802722,15859400,41430270.437908217,2262317,39167953.437908217,2417049.4379082173,null,{"$f":"IF(AND(ISBLANK(B35), ISBLANK(C35)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D35=\"\",\"\",D35-D32)","v":0},0,0,0,0,0,-107198.63945578237,0,-107198.63945578784,0,-107198.63945578784,-107198.63945578784]
[]
[6,"Pre-Settlement\n4-Staff-100, SEC-73","OM&A, COP adjustments & related PILs",13145336.506940626,5.4397309098274574E-2,241654168.65000001,186637422,13997806.65,11048476,754270.74829931976,15854400,41274103.255239941,2262317,39011786.255239941,2260882.9054601882,null,{"$f":"IF(AND(ISBLANK(B38), ISBLANK(C38)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D38=\"\",\"\",D38-D35)","v":-123312.76089956611},0,-2266890.8249999881,-30225211,-2266890.8249999993,0,-27854.421768707456,-5000,-156167.18266827613,0,-156167.18266827613,-156166.53244802915]
[]
[7,"Settlement\nVECC-63, 3.1","CDM in LF correction",13145313.321447555,5.4397309098274574E-2,241653742.42500001,186631739,13997380.424999999,11048476,754265.30612244899,15854400,41274074.627570003,2262317,39011757.627570003,2261283.4827926732,null,{"$f":"IF(AND(ISBLANK(B41), ISBLANK(C41)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D41=\"\",\"\",D41-D38)","v":-23.185493070632219},0,-426.22499999403954,-5683,-426.22500000149012,0,-5.4421768707688898,0,-28.627669937908649,0,-28.627669937908649,400.57733248500153]
[]
[8,"Settlement 1.2, 2.1","Reallocate specific service charges from OM&A to Revenue",13145516.55659401,5.4397309098274574E-2,241657478.55000001,186681554,14001116.549999999,11048476,754311.5646258503,15904215,41324139.121219859,2312132,39012007.121219859,2261532.625003207,null,{"$f":"IF(AND(ISBLANK(B44), ISBLANK(C44)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D44=\"\",\"\",D44-D41)","v":203.23514645546675},0,3736.125,49815,3736.125,0,46.258503401302733,49815,50064.493649855256,49815,249.49364985525608,249.14221053384244]
[]
[9,"Settlement 1.2, 2.1","Reduction to 2021 OM&A of $775,000",13142354.713002672,5.4397309098274574E-2,241599353.55000001,185906554,13942991.549999999,11048476,753597.27891156462,15129215,40545262.991914235,2312132,38233130.991914235,1482656.5793710526,null,{"$f":"IF(AND(ISBLANK(B47), ISBLANK(C47)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D47=\"\",\"\",D47-D44)","v":-3161.8435913380235},0,-58125,-775000,-58125,0,-714.28571428568102,-775000,-778876.12930562347,0,-778876.12930562347,-778876.04563215445]
[]
[10,"Settlement 2.1","Change to half-year rule for depreciation",13246563.47485031,5.4397309098274574E-2,243515050.55000001,185906554,13942991.549999999,10752582,665435.37414965988,15129215,40265415.84899997,{"$f":"2312132-22512","v":2289620},{"$f":"37953283.849+22512","v":37975795.848999999},{"$f":"1202808.16808454+22512","v":1225320.1680845399},null,{"$f":"IF(AND(ISBLANK(B50), ISBLANK(C50)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D50=\"\",\"\",D50-D47)","v":104208.76184763759},0,1915697,0,0,-295894,-88161.904761904734,0,-279847.14291426539,-22512,-257335.14291423559,-257336.41128651262]
[]
[11,"Settlement 1.1","Reduction to 2021 CAPEX of $550,000",{"$f":"13239948.6532693+95","v":13240043.6532693},5.4397309098274574E-2,{"$f":"243393448.55+1740","v":243395188.55000001},185906554,13942991.549999999,{"$f":"10751824-6500","v":10745324},{"$f":"694138.775510204-1905","v":692233.77551020402},15129215,{"$f":"40286746.4287795-8310","v":40278436.428779498},{"$f":"2312132-22512","v":2289620},{"$f":"37974614.4287795-8310+22512","v":37988816.428779498},{"$f":"1224139.28258194-8310+22512","v":1238341.2825819401},null,{"$f":"IF(AND(ISBLANK(B53), ISBLANK(C53)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D53=\"\",\"\",D53-D50)","v":-6519.8215810097754},0,-119862,0,0,-7258,26798.401360544143,0,13020.579779528081,0,13020.579779498279,13021.114497400122]
[]
[12,"Settlement 2.1","OER & RPP rate update to Cost of Power",13252623.150133006,5.4397309098274574E-2,243626447.15000001,188990002,14174250.15,10745324,695076.19047619053,15129215,40293858.340609193,{"$f":"2312132-22512","v":2289620},{"$f":"37981726.3406092+22512","v":38004238.3406092},{"$f":"1231251.04741339+22512","v":1253763.0474133899},null,{"$f":"IF(AND(ISBLANK(B56), ISBLANK(C56)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D56=\"\",\"\",D56-D53)","v":12579.496863706037},0,231258.59999999404,3083448,231258.60000000149,0,2842.414965986507,0,15421.911829695106,0,15421.911829702556,15421.764831449836]
[]
[13,"Settlement 2.1","2021 Cost of Capital parameters",12844967.448679801,5.272402729237026E-2,243626447.15000001,188990002,14174250.15,10745324,631832.6530612245,15129215,39822959.101741031,2289620,37533339.101741031,782863.90906736813,null,{"$f":"IF(AND(ISBLANK(B59), ISBLANK(C59)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D59=\"\",\"\",D59-D56)","v":-407655.7014532052},-1.6732818059043142E-3,0,0,0,0,-63243.537414966035,0,-470899.23886816204,0,-470899.23886816949,-470899.13834602176]
[]
[14,"Balance Check",null,{"$f":"'7. Cost_of_Capital'!$P$42","v":12844967.448679801},{"$f":"'7. Cost_of_Capital'!$L$42","v":5.272402729237026E-2},{"$f":"'4. Rate_Base'!$O$18","v":243626447.15000001},{"$f":"'4. Rate_Base'!$O$26","v":188990002},{"$f":"'4. Rate_Base'!$O$30","v":14174250.15},{"$f":"'9. Rev_Reqt'!$J$16","v":10745324},{"$f":"'9. Rev_Reqt'!$J$19","v":631832.6530612245},{"$f":"'9. Rev_Reqt'!$J$15","v":15129215},{"$f":"'9. Rev_Reqt'!$J$25","v":39822959.101741031},{"$f":"'9. Rev_Reqt'!$J$32","v":2289620},{"$f":"'9. Rev_Reqt'!$J$28","v":37533339.101741031},{"$f":"'8. Rev_Def_Suff'!$J$52","v":782863.90906736813},null,{"$f":"IF(AND(ISBLANK(B62), ISBLANK(C62)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D62=\"\",\"\",D62-D59)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[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":[]}