{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1. Info","2. Table of Contents","3. Data_Input_Sheet","4. Rate_Base","5. Utility Income","6. Taxes_PILs","7. Cost_of_Capital","8. Rev_Def_Suff","9. Rev_Reqt","10. Tracking_Sheet"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":14,"comments":0,"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":99,"n_cols":29,"rows_kept":99,"cut":false,"hidden":false,"merged":[[27,1,27,3],[34,1,40,11],[0,2,1,12],[2,2,3,12],[27,4,27,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]]}
[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('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,"Version",5]
[]
[]
[]
[]
[null,null,null,null,null,"Utility Name   ","Hydro Ottawa Limited"]
[]
[null,null,null,null,null,"Service Territory"]
[]
[null,null,null,null,null,"Assigned EB Number","EB-2015-0004 (Year 2018)",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,"Algoma Power Inc."]
[null,null,null,null,null,"Name and Title","April Barrie; Manager, Rates and Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Atikokan 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,3,"Attawapiskat Power Corp. "]
[null,null,null,null,null,"Phone Number   ","613-738-5499, ext 106",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"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,5,"Brant County Power Inc."]
[null,null,null,null,null,"Email Address   ","RegulatoryAffairs@HydroOttawa.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Brantford 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,"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,8,"Cambridge and North Dumfries 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,9,"Canadian Niagara Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"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,11,"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,12,"Clinton 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,13,"COLLUS 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,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,"Enersource Hydro Mississauga 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,17,"Entegrus Powerlines 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,18,"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,19,"Erie Thames 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,20,"Espanola Regional Hydro Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"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,22,"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,23,"Festival Hydro Inc. - Hensall"]
[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,"Fort Albany 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,25,"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,26,"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,27,"Grimsby 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,28,"Guelph Hydro Electric Systems 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,"Haldimand County 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,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 Company 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,32,"Horizon 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,33,"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,34,"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,35,"Hydro One Brampton 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,36,"Hydro One Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"Hydro 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,38,"Innisfil Hydro Distribution Systems 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,39,"Kashechewan 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,40,"Kenora Hydro Electric Corporation 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,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,"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,46,"Midland Power Utility 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,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."]
[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,"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,50,"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,51,"Norfolk Power 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,52,"North Bay Hydro Distribution Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"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,54,"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,55,"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,56,"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,57,"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,58,"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,59,"Parry Sound 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,"PowerStream 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,"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,63,"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,64,"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,65,"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,66,"St. Thomas 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,67,"Thunder Bay 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,68,"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,69,"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,70,"Veridian Connections 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,"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,72,"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,73,"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,74,"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,75,"West Coast Huron 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,76,"West Perth 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,77,"Westario 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,78,"Whitby Hydro Electric 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,79,"Woodstock Hydro Services Inc."]

{"sheet":"2. Table of Contents","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,3,1,6],[3,3,3,4],[28,1,28,11],[24,1,24,7],[25,1,25,7],[26,1,26,7],[27,1,27,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"1. Info",null,null,null,null,"6. Taxes_PILs"]
[]
[null,null,null,"2. Table of Contents",null,null,null,null,"7. Cost_of_Capital"]
[]
[null,null,null,"3. Data_Input_Sheet",null,null,null,null,"8. Rev_Def_Suff"]
[]
[null,null,null,"4. Rate_Base",null,null,null,null,"9. Rev_Reqt"]
[]
[null,null,null,"5. Utility Income",null,null,null,null,"10. 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":[[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],[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]]}
[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,1051985626.4095517,null,null,null,{"$f":"1047896939.5-E16-19492796-(10000000+4574748+5000000)-5000000/2","v":-45656230.90955174},null,12,null,{"$f":"IF(ISBLANK(E16),0,E16+I16)","v":1006329395.5},null,12,null,null,null,null,null,{"$f":"IF(ISBLANK(E16),\"\",E16+I16+Q16)","v":1006329395.5}]
[null,null,"   Accumulated Depreciation (average)",null,-179426301.98481479,null,"(5)",null,{"$f":"-176516401.1-E17+(333000*2+43724+166476)+((333000+222031)/2)","v":4063616.3848147988},null,12,null,{"$f":"IF(ISBLANK(E17),0,E17+I17)","v":-175362685.59999999},null,12,null,null,null,null,null,{"$f":"IF(ISBLANK(E17),\"\",E17+I17+Q17)","v":-175362685.59999999}]
[null,null,"Allowance for Working Capital:"]
[null,null,"   Controllable Expenses",null,92850437.373660594,null,null,null,-6539923.1919142604,null,null,null,{"$f":"IF(ISBLANK(E19),0,E19+I19)","v":86310514.181746334},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E19),\"\",E19+I19+Q19)","v":86310514.181746334}]
[null,null,"   Cost of Power",null,947558773.39195228,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E20),0,E20+I20)","v":947558773.39195228},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E20),\"\",E20+I20+Q20)","v":947558773.39195228}]
[null,null,"   Working Capital Rate (%)",null,0.14199999999999999,null,"(9)",null,null,null,null,null,7.9200000000000007E-2,null,"(9)",null,null,null,null,null,{"$f":"IF(ISBLANK(M21),IF(ISBLANK(E21),0,E21),M21)","v":7.9200000000000007E-2},null,"(9)"]
[]
[null,2,"Utility Income"]
[null,null,"Operating Revenues:"]
[null,null,"   Distribution Revenue at Current Rates",null,{"$f":"159418980.3746-1109103.075","v":158309877.29960001},null,10,null,{"$f":"IF(ISBLANK(M25),\"\",IF(ISBLANK(E25),\"\",M25-E25))","v":2167.7003999948502},null,null,null,158312045,null,13,null,{"$f":"IF(ISBLANK(U25),\"\",IF(ISBLANK(M25),\"\",U25-M25))","v":""}]
[null,null,"   Distribution Revenue at Proposed Rates",null,196398373.77836311,null,null,null,{"$f":"IF(ISBLANK(M26),\"\",IF(ISBLANK(E26),\"\",M26-E26))","v":-17523381.778363109},null,null,null,178874992,null,11,null,{"$f":"IF(ISBLANK(U26),\"\",IF(ISBLANK(M26),\"\",U26-M26))","v":""}]
[null,null,"   Other Revenue:"]
[null,null,"      Specific Service Charges",null,6014982,null,null,null,{"$f":"IF(ISBLANK(M28),\"\",IF(ISBLANK(E28),\"\",M28-E28))","v":-2550},null,null,null,{"$f":"+E28-2550","v":6012432},null,15,null,{"$f":"IF(ISBLANK(U28),\"\",IF(ISBLANK(M28),\"\",U28-M28))","v":""}]
[null,null,"      Late Payment Charges",null,720000,null,null,null,{"$f":"IF(ISBLANK(M29),\"\",IF(ISBLANK(E29),\"\",M29-E29))","v":0},null,null,null,{"$f":"+E29","v":720000},null,null,null,{"$f":"IF(ISBLANK(U29),\"\",IF(ISBLANK(M29),\"\",U29-M29))","v":""}]
[null,null,"      Other Distribution Revenue",null,1469736,null,null,null,{"$f":"IF(ISBLANK(M30),\"\",IF(ISBLANK(E30),\"\",M30-E30))","v":0},null,null,null,1469736,null,null,null,{"$f":"IF(ISBLANK(U30),\"\",IF(ISBLANK(M30),\"\",U30-M30))","v":""}]
[null,null,"      Other Income and Deductions",null,3517322.6836999999,null,null,null,{"$f":"IF(ISBLANK(M31),\"\",IF(ISBLANK(E31),\"\",M31-E31))","v":0},null,null,null,3517322.6836999999,null,null,null,{"$f":"IF(ISBLANK(U31),\"\",IF(ISBLANK(M31),\"\",U31-M31))","v":""}]
[]
[null,null,null,"Total Revenue Offsets",{"$f":"SUM(E28:E31)","v":11722040.683699999},null,"(7)",null,{"$f":"IF(ISBLANK(M33),\"\",IF(ISBLANK(E33),\"\",M33-E33))","v":-2550},null,null,null,{"$f":"SUM(M28:M31)","v":11719490.683699999},null,null,null,{"$f":"IF(ISBLANK(U33),\"\",IF(ISBLANK(M33),\"\",U33-M33))","v":""}]
[]
[null,null,"Operating Expenses:"]
[null,null,"   OM+A Expenses",null,90624893.793108985,null,null,null,-6539923.1919142604,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36)","v":84084970.601194724},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E36),\"\",E36+I36+Q36)","v":84084970.601194724}]
[null,null,"   Depreciation/Amortization",null,47047408.888888888,null,null,null,{"$f":"46943424-E37-333000-222031","v":-659015.88888888806},null,12,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37)","v":46388393},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E37),\"\",E37+I37+Q37)","v":46388393}]
[null,null,"   Property taxes",null,2225543.5805516103,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38)","v":2225543.5805516103},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E38),\"\",E38+I38+Q38)","v":2225543.5805516103}]
[null,null,"   Capital taxes",null,{"$f":"IF(ISBLANK(E48),\"\",E48)","v":""},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",{"$f":"48997962-68837331.9542137-120000","v":-19959369.954213694},null,"(3)",null,null,null,null,null,{"$f":"56812754-76286804","v":-19474050},null,14]
[null,null,"Utility Income Taxes and Rates:"]
[null,null,"   Income taxes (not grossed up)",null,4476359,null,null,null,null,null,null,null,3599306,null,14]
[null,null,"   Income taxes (grossed up)",null,{"$f":"IF(ISBLANK(E46),\"\",E46/(1-SUM(E49:E50)))","v":6074211.1674263114},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(M46),\"\",M46/(1-SUM(M49:M50)))","v":4897014.9659863943},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,null,null,null,null,{"$f":"+E49","v":0.15}]
[null,null,"   Provincial tax (%)",null,0.11305509034572024,null,null,null,null,null,null,null,0.115]
[null,null,"Income Tax Credits",null,-257500,null,null,null,null,null,null,null,-132500]
[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,null,null,null,null,{"$f":"+E55","v":0.56000000000000005}]
[null,null,"   Short-term debt Capitalization Ratio (%)",null,0.04,null,"(8)",null,null,null,null,null,{"$f":"+E56","v":0.04},null,"(8)",null,null,null,null,null,null,null,"(8)"]
[null,null,"   Common Equity Capitalization Ratio (%)",null,0.4,null,null,null,null,null,null,null,0.4]
[null,null,"   Prefered Shares Capitalization Ratio (%)"]
[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,4.0800000000000003E-2,null,null,null,null,null,null,null,3.6490000000000002E-2]
[null,null,"   Short-term debt Cost Rate (%)",null,2.1600000000000001E-2,null,null,null,null,null,null,null,{"$f":"+E63","v":2.1600000000000001E-2}]
[null,null,"   Common Equity Cost Rate (%)",null,9.2999999999999999E-2,null,null,null,null,null,null,null,9.1899999999999996E-2,null,17]
[null,null,"   Prefered Shares Cost Rate (%)"]
[]
[]
["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 colimn 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 M10.  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)","Starting with 2013, default Working Capital Allowance factor is 13% (of Cost of Power plus controllable expenses).  Alternatively, WCA factor based on lead-lag study or approved WCA factor for another distributor, with supporting rationale."]
[]
[null,10,"Revenue at current rates minus Transformer Ownership Allowance"]
[null,11,"Distribution Revenue not including Transformer Ownership Allowance, Total Revenue Requirement is $179,984,095, number reflects amended settlement agreement."]
[null,12,"Gross Fixed Assets (average) and Accumulated Depreciation (average)  - Updated for 2014 Actuals and flow through 2016 through 2020, Per Settlement Removal of new facilities Land $19.4M, $10M reduction in Capital and $14.6M in CCRA payments"]
[null,13,"Correction - To include Sentinel Light Variable Charge"]
[null,14,"PILs - Update per (12); Ontario Apprenticeship Tax Credit program legislative changes; Ontario Small Business Deduction Correction; Charitable Contributions Correction, Pils update per Settlement Agreement, Updated for October 2015 ROE and Settled Working Capital Rate %"]
[null,15,"Removal of missed appointment charge"]
[null,16,"Changes per settlement agreement, including using April 2015 consensus long-term forecast"]
[null,17,"Updated per October 2015 Deemed ROE, Also related to note (9) Settled Working Capital Rate %"]

{"sheet":"4. Rate_Base","index":3,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[]
[]
[]
[]
[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)","(3)",null,{"$f":"'3. Data_Input_Sheet'!E16","v":1051985626.4095517},null,null,null,{"$f":"'3. Data_Input_Sheet'!I16","v":-45656230.90955174},null,null,null,{"$f":"G13+K13","v":1006329395.5},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q16","v":0},null,null,null,{"$f":"G13+K13+S13","v":1006329395.5}]
[null,2,null,"Accumulated Depreciation (average)","(3)",null,{"$f":"'3. Data_Input_Sheet'!E17","v":-179426301.98481479},null,null,null,{"$f":"'3. Data_Input_Sheet'!I17","v":4063616.3848147988},null,null,null,{"$f":"G14+K14","v":-175362685.59999999},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q17","v":0},null,null,null,{"$f":"G14+K14+S14","v":-175362685.59999999}]
[null,3,null,"Net Fixed Assets (average)","(3)",null,{"$f":"SUM(G13:G14)","v":872559324.42473698},null,null,null,{"$f":"SUM(K13:K14)","v":-41592614.524736941},null,null,null,{"$f":"SUM(O13:O14)","v":830966709.89999998},null,null,null,{"$f":"SUM(S13:S14)","v":0},null,null,null,{"$f":"SUM(W13:W14)","v":830966709.89999998}]
[]
[null,4,null,"Allowance for Working Capital","(1)",null,{"$f":"G30","v":147738107.92871702},null,null,null,{"$f":"K30","v":-65855660.352880076},null,null,null,{"$f":"O30","v":81882447.575836942},null,null,null,{"$f":"S30","v":0},null,null,null,{"$f":"W30","v":81882447.575836942}]
[null,null,null,"Total Rate Base",null,null,{"$f":"G17+G15","v":1020297432.353454},null,null,null,{"$f":"K17+K15","v":-107448274.87761702},null,null,null,{"$f":"O17+O15","v":912849157.47583687},null,null,null,{"$f":"S17+S15","v":0},null,null,null,{"$f":"W15+W17","v":912849157.47583687}]
[null,5]
[null,null,"(1)","Allowance for Working Capital - Derivation"]
[]
[]
[]
[null,6,null,"Controllable Expenses",null,null,{"$f":"'3. Data_Input_Sheet'!E19","v":92850437.373660594},null,null,null,{"$f":"'3. Data_Input_Sheet'!I19","v":-6539923.1919142604},null,null,null,{"$f":"G24+K24","v":86310514.181746334},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q19","v":0},null,null,null,{"$f":"G24+K24+S24","v":86310514.181746334}]
[null,7,null,"Cost of Power",null,null,{"$f":"'3. Data_Input_Sheet'!E20","v":947558773.39195228},null,null,null,{"$f":"'3. Data_Input_Sheet'!I20","v":0},null,null,null,{"$f":"G25+K25","v":947558773.39195228},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q20","v":0},null,null,null,{"$f":"G25+K25+S25","v":947558773.39195228}]
[null,8,null,"Working Capital Base",null,null,{"$f":"SUM(G24:G25)","v":1040409210.7656128},null,null,null,{"$f":"K24+K25","v":-6539923.1919142604},null,null,null,{"$f":"SUM(O24:O25)","v":1033869287.5736986},null,null,null,{"$f":"S24+S25","v":0},null,null,null,{"$f":"SUM(W24:W25)","v":1033869287.5736986}]
[]
[null,9,null,"Working Capital Rate % ","(2)",null,{"$f":"'3. Data_Input_Sheet'!E21","v":0.14199999999999999},null,null,null,{"$f":"O28-G28","v":-6.2799999999999981E-2},null,null,null,{"$f":"'3. Data_Input_Sheet'!M21","v":7.9200000000000007E-2},null,null,null,{"$f":"W28-O28","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U21","v":7.9200000000000007E-2}]
[]
[null,10,null,"Working Capital Allowance",null,null,{"$f":"G26*G28","v":147738107.92871702},null,null,null,{"$f":"O30-G30","v":-65855660.352880076},null,null,null,{"$f":"O26*O28","v":81882447.575836942},null,null,null,{"$f":"W30-O30","v":0},null,null,null,{"$f":"W26*W28","v":81882447.575836942}]
[]
[]
[null,"Notes"]
[null,"(2)",null,"Some Applicants may have a unique rate as a result of a lead-lag study.  The default rate for 2014 cost of service applications is 13%."]
[null,"(3)",null,"Average of opening and closing balances for the year."]

{"sheet":"5. Utility Income","index":4,"n_rows":49,"n_cols":22,"rows_kept":49,"cut":false,"hidden":false,"merged":[[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],[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],[26,9,27,9],[34,21,35,21],[34,5,35,5],[36,21,37,21],[36,5,37,5],[36,17,37,17],[47,9,48,9],[47,13,48,13],[47,17,48,17],[34,9,35,9],[36,9,37,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Utility Income"]
[]
[null,"Line No.",null,"Particulars                                ",null,"Initial Application   ",null,null,null,{"$f":"IF(N13=\"\",\"\",\"Adjustments\")","v":"Adjustments"},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M12),\"\",'3. Data_Input_Sheet'!M12)","v":"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":196398373.77836311},null,null,null,{"$f":"N16-F16","v":-17523381.778363109},null,null,null,{"$f":"'3. Data_Input_Sheet'!M26","v":178874992},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":178874992}]
[null,2,null,"Other Revenue","(1)",{"$f":"F48","v":11722040.683699999},null,null,null,{"$f":"N17-F17","v":-2550},null,null,null,{"$f":"N48","v":11719490.683699999},null,null,null,{"$f":"V17-N17","v":0},null,null,null,{"$f":"V48","v":11719490.683699999}]
[null,null,null,null,null,{"$f":"SUM(F16:F17)","v":208120414.4620631},null,null,null,{"$f":"SUM(J16:J17)","v":-17525931.778363109},null,null,null,{"$f":"SUM(N16:N17)","v":190594482.6837},null,null,null,{"$f":"SUM(R16:R17)","v":0},null,null,null,{"$f":"SUM(V16:V17)","v":190594482.6837}]
[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":90624893.793108985},null,null,null,{"$f":"'3. Data_Input_Sheet'!I36","v":-6539923.1919142604},null,null,null,{"$f":"'3. Data_Input_Sheet'!M36","v":84084970.601194724},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q36","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U36","v":84084970.601194724}]
[null,5,null,"Depreciation/Amortization",null,{"$f":"'3. Data_Input_Sheet'!E37","v":47047408.888888888},null,null,null,{"$f":"'3. Data_Input_Sheet'!I37","v":-659015.88888888806},null,null,null,{"$f":"'3. Data_Input_Sheet'!M37","v":46388393},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q37","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U37","v":46388393}]
[null,6,null,"Property taxes",null,{"$f":"'3. Data_Input_Sheet'!E38","v":2225543.5805516103},null,null,null,{"$f":"'3. Data_Input_Sheet'!I38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M38","v":2225543.5805516103},null,null,null,{"$f":"'3. Data_Input_Sheet'!Q38","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!U38","v":2225543.5805516103}]
[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":139897846.26254949},null,null,null,{"$f":"SUM(J22:J26)","v":-7198939.0808031484},null,null,null,{"$f":"SUM(N22:N26)","v":132698907.18174633},null,null,null,{"$f":"SUM(R22:R26)","v":0},null,null,null,{"$f":"SUM(V22:V26)","v":132698907.18174633}]
[null,9,null,"Subtotal (lines 4 to 8)"]
[]
[null,10,null,"Deemed Interest Expense",null,{"$f":"'7. Cost_of_Capital'!P19","v":24193292.715965107},null,null,null,{"$f":"N30-F30","v":-4751066.2203817405},null,null,null,{"$f":"'7. Cost_of_Capital'!P35","v":19442226.495583367},null,null,null,{"$f":"V30-N30","v":2203252.7264836803},null,null,null,{"$f":"'7. Cost_of_Capital'!P51","v":21645479.222067047}]
[]
[null,11,null,"Total Expenses (lines 9 to 10)",null,{"$f":"F27+F30","v":164091138.97851461},null,null,null,{"$f":"J30+J27","v":-11950005.301184889},null,null,null,{"$f":"N30+N27","v":152141133.67732969},null,null,null,{"$f":"R30+R27","v":2203252.7264836803},null,null,null,{"$f":"V27+V30","v":154344386.40381339}]
[]
[null,12,null,"Utility income before income taxes",null,{"$f":"F18-(F32)","v":44029275.483548492},null,null,null,{"$f":"J18-(J32)","v":-5575926.4771782197},null,null,null,{"$f":"N18-(N32)","v":38453349.006370306},null,null,null,{"$f":"R18-(R32)","v":-2203252.7264836803},null,null,null,{"$f":"V18-(V32)","v":36250096.279886603}]
[null,null,null,null,null,{"$f":"'6. Taxes_PILs'!G31","v":6074211.1674263114},null,null,null,{"$f":"N35-F35","v":-1177196.2014399171},null,null,null,{"$f":"'6. Taxes_PILs'!K31","v":4897014.9659863943},null,null,null,{"$f":"V35-N35","v":0},null,null,null,{"$f":"IF('6. Taxes_PILs'!O31=0,N35,'6. Taxes_PILs'!O31)","v":4897014.9659863943}]
[null,13,null,"Income taxes (grossed-up)"]
[null,null,null,null,null,{"$f":"F34-F35","v":37955064.316122182},null,null,null,{"$f":"J34-J35","v":-4398730.2757383026},null,null,null,{"$f":"N34-N35","v":33556334.040383913},null,null,null,{"$f":"R34-R35","v":-2203252.7264836803},null,null,null,{"$f":"V34-V35","v":31353081.31390021}]
[null,14,null,"Utility net income"]
[]
[]
[]
[null,"Notes"]
[]
[null,"(1)",null,"  Specific Service Charges",null,{"$f":"'3. Data_Input_Sheet'!E28","v":6014982},null,null,null,{"$f":"'3. Data_Input_Sheet'!I28","v":-2550},null,null,null,{"$f":"'3. Data_Input_Sheet'!M28","v":6012432},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":6012432}]
[null,null,null,"  Late Payment Charges",null,{"$f":"'3. Data_Input_Sheet'!E29","v":720000},null,null,null,{"$f":"'3. Data_Input_Sheet'!I29","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M29","v":720000},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":720000}]
[null,null,null,"  Other Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E30","v":1469736},null,null,null,{"$f":"'3. Data_Input_Sheet'!I30","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M30","v":1469736},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":1469736}]
[null,null,null,"  Other Income and Deductions",null,{"$f":"'3. Data_Input_Sheet'!E31","v":3517322.6836999999},null,null,null,{"$f":"'3. Data_Input_Sheet'!I31","v":0},null,null,null,{"$f":"'3. Data_Input_Sheet'!M31","v":3517322.6836999999},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":3517322.6836999999}]
[null,null,null,null,null,{"$f":"SUM(F44:F47)","v":11722040.683699999},null,null,null,{"$f":"SUM(J44:J47)","v":-2550},null,null,null,{"$f":"SUM(N44:N47)","v":11719490.683699999},null,null,null,{"$f":"SUM(R44:R47)","v":0},null,null,null,{"$f":"SUM(V44:V47)","v":11719490.683699999}]
[null,null,null,"Total Revenue Offsets"]

{"sheet":"6. Taxes_PILs","index":5,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,3,0,12],[2,2,2,6],[3,2,3,6],[1,2,1,14],[43,1,43,14],[8,1,8,12],[25,6,26,6],[25,14,26,14],[15,3,15,4],[17,3,17,4],[19,3,19,4],[32,3,32,4],[25,10,26,10],[44,3,44,14],[51,3,51,14],[52,3,52,14],[45,3,45,14],[49,3,49,14],[50,3,50,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[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":37955064.483548492},null,null,null,{"$f":"'7. Cost_of_Capital'!P38","v":33556335.02881176},null,null,null,{"$f":"'7. Cost_of_Capital'!P54","v":33957988.658101134}]
[]
[null,2,null,"Adjustments required to arrive at taxable utility income",null,null,{"$f":"'3. Data_Input_Sheet'!E44","v":-19959369.954213694},null,null,null,{"$f":"'3. Data_Input_Sheet'!M44","v":-19474050},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),G18,'3. Data_Input_Sheet'!U44)","v":-19959369.954213694}]
[]
[null,3,null,"Taxable income",null,null,{"$f":"G16+G18","v":17995694.529334798},null,null,null,{"$f":"K16+K18","v":14082285.02881176},null,null,null,{"$f":"O16+O18","v":13998618.70388744}]
[]
[null,null,null,"Calculation of Utility income Taxes"]
[]
[null,4,null,"Income taxes",null,null,{"$f":"'3. Data_Input_Sheet'!E46","v":4476359},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M46),'6. Taxes_PILs'!G24,'3. Data_Input_Sheet'!M46)","v":3599306},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U46),'6. Taxes_PILs'!K24,'3. Data_Input_Sheet'!U46)","v":3599306}]
[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":4476359},null,null,null,{"$f":"SUM(K24:K25)","v":3599306},null,null,null,{"$f":"SUM(O24:O25)","v":3599306}]
[null,6,null,"Total taxes"]
[]
[null,7,null,"Gross-up of Income Taxes",null,null,{"$f":"(G24/(1-G41))-G24","v":1597852.1674263114},null,null,null,{"$f":"(K24/(1-K41))-K24","v":1297708.9659863943},null,null,null,{"$f":"(O24/(1-O41))-O24","v":1297708.9659863943}]
[]
[null,8,null,"Grossed-up Income Taxes",null,null,{"$f":"G24+G29","v":6074211.1674263114},null,null,null,{"$f":"K24+K29","v":4897014.9659863943},null,null,null,{"$f":"O24+O29","v":4897014.9659863943}]
[]
[null,9,null,"PILs / tax Allowance (Grossed-up Income taxes + Capital taxes)",null,null,{"$f":"G26+G29","v":6074211.1674263114},null,null,null,{"$f":"K29+K26","v":4897014.9659863943},null,null,null,{"$f":"O29+O26","v":4897014.9659863943}]
[]
[null,10,null,"Other tax Credits",null,null,{"$f":"'3. Data_Input_Sheet'!E51","v":-257500},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),G35,'3. Data_Input_Sheet'!M51)","v":-132500},null,null,null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),K35,'3. Data_Input_Sheet'!U51)","v":-132500}]
[]
[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.11305509034572024},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.26305509034572022},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":6,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,2,0,13],[2,2,2,13],[3,2,3,9],[1,2,1,17],[12,5,12,9],[4,1,4,13],[10,5,10,9],[67,3,67,15],[65,3,65,15],[61,3,61,15],[62,3,62,15],[63,3,63,15],[64,3,64,15],[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]]}
[]
[]
[]
[]
[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":571366562.11793435},null,{"$f":"'3. Data_Input_Sheet'!E62","v":4.0800000000000003E-2},null,null,null,{"$f":"L17*J17","v":23311755.734411724}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!E56","v":0.04},null,null,null,{"$f":"$J$26*F18","v":40811897.294138163},null,{"$f":"'3. Data_Input_Sheet'!E63","v":2.1600000000000001E-2},null,null,null,{"$f":"L18*J18","v":881536.98155338434}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F17:F18)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J17:J18)","v":612178459.41207254},null,{"$f":"IF(F19=0,0,SUMPRODUCT(F17:F18,L17:L18)/F19)","v":3.952E-2},null,null,null,{"$f":"SUM(P17:P18)","v":24193292.715965107}]
[]
[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":408118972.94138163},null,{"$f":"'3. Data_Input_Sheet'!E64","v":9.2999999999999999E-2},null,null,null,{"$f":"L22*J22","v":37955064.483548492}]
[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":408118972.94138163},null,{"$f":"IF(F24=0,0,SUMPRODUCT(F22:F23,L22:L23)/F24)","v":9.2999999999999999E-2},null,null,null,{"$f":"SUM(P22:P23)","v":37955064.483548492}]
[]
[null,7,null,"Total",null,{"$f":"SUM(F19,F24)","v":1},null,null,null,{"$f":"'4. Rate_Base'!G18","v":1020297432.353454},null,{"$f":"(L19*F19)+(L24*F24)","v":6.0912000000000008E-2},null,null,null,{"$f":"P19+P24","v":62148357.199513599}]
[]
[]
[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":511195528.18646872},null,{"$f":"'3. Data_Input_Sheet'!M62","v":3.6490000000000002E-2},null,null,null,{"$f":"L33*J33","v":18653524.823524244}]
[null,2,null,"  Short-term Debt",null,{"$f":"'3. Data_Input_Sheet'!M56","v":0.04},null,null,null,{"$f":"$J$42*F34","v":36513966.299033478},null,{"$f":"'3. Data_Input_Sheet'!M63","v":2.1600000000000001E-2},null,null,null,{"$f":"L34*J34","v":788701.67205912317}]
[null,3,null,"Total Debt",null,{"$f":"SUM(F33:F34)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J33:J34)","v":547709494.48550224},null,{"$f":"IF(F35=0,0,SUMPRODUCT(F33:F34,L33:L34)/F35)","v":3.5497333333333332E-2},null,null,null,{"$f":"SUM(P33:P34)","v":19442226.495583367}]
[]
[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":365139662.99033475},null,{"$f":"'3. Data_Input_Sheet'!M64","v":9.1899999999999996E-2},null,null,null,{"$f":"L38*J38","v":33556335.02881176}]
[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":365139662.99033475},null,{"$f":"IF(F40=0,0,SUMPRODUCT(F38:F39,L38:L39)/F40)","v":9.1899999999999996E-2},null,null,null,{"$f":"SUM(P38:P39)","v":33556335.02881176}]
[]
[null,7,null,"Total",null,{"$f":"F35+F40","v":1},null,null,null,{"$f":"'4. Rate_Base'!O18","v":912849157.47583687},null,{"$f":"(L35*F35)+(L40*F40)","v":5.8058400000000003E-2},null,null,null,{"$f":"P35+P40","v":52998561.524395123}]
[]
[]
[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":511195528.18646872},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U62),L17,'3. Data_Input_Sheet'!U62)","v":4.0800000000000003E-2},null,null,null,{"$f":"L49*J49","v":20856777.550007924}]
[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":36513966.299033478},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U63),L18,'3. Data_Input_Sheet'!U63)","v":2.1600000000000001E-2},null,null,null,{"$f":"L50*J50","v":788701.67205912317}]
[null,10,null,"Total Debt",null,{"$f":"SUM(F49:F50)","v":0.60000000000000009},null,null,null,{"$f":"SUM(J49:J50)","v":547709494.48550224},null,{"$f":"IF(F51=0,0,SUMPRODUCT(F49:F50,L49:L50)/F51)","v":3.952E-2},null,null,null,{"$f":"SUM(P49:P50)","v":21645479.222067047}]
[]
[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":365139662.99033475},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U64),L22,'3. Data_Input_Sheet'!U64)","v":9.2999999999999999E-2},null,null,null,{"$f":"L54*J54","v":33957988.658101134}]
[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":365139662.99033475},null,{"$f":"IF(F56=0,0,SUMPRODUCT(F54:F55,L54:L55)/F56)","v":9.2999999999999999E-2},null,null,null,{"$f":"SUM(P54:P55)","v":33957988.658101134}]
[]
[null,14,null,"Total",null,{"$f":"F51+F56","v":1},null,null,null,{"$f":"'4. Rate_Base'!W18","v":912849157.47583687},null,{"$f":"(L51*F51)+(L56*F56)","v":6.0912000000000008E-2},null,null,null,{"$f":"P51+P56","v":55603467.880168185}]
[]
[]
[null,"Notes"]
[null,"(1)",null,{"$f":"'3. Data_Input_Sheet'!C71","v":"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 colimn M and Adjustments in column I"}]

{"sheet":"8. Rev_Def_Suff","index":7,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,2,0,14],[1,2,1,14],[2,2,2,14],[3,2,3,7],[54,1,54,8],[14,3,15,3],[14,1,15,1],[12,5,12,7],[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]]}
[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":38088496.71437382},null,null,null,{"$f":"J52","v":20562947.352557261},null,null,null,{"$f":"N52","v":23312667.601883646}]
[null,2,null,"Distribution Revenue",null,{"$f":"'3. Data_Input_Sheet'!E25","v":158309877.29960001},null,{"$f":"'3. Data_Input_Sheet'!E26-H19","v":158309877.06398928},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M25),'3. Data_Input_Sheet'!E25,'3. Data_Input_Sheet'!M25)","v":158312045},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M26),'3. Data_Input_Sheet'!E26-L19,'3. Data_Input_Sheet'!M26-L19)","v":158312044.64744273},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U25),'3. Data_Input_Sheet'!M25,'3. Data_Input_Sheet'!U25)","v":158312045},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U26),'3. Data_Input_Sheet'!M26-P19,'3. Data_Input_Sheet'!U26-P19)","v":155562324.39811635}]
[null,3,null,"Other Operating Revenue Offsets - net",null,{"$f":"'5. Utility Income'!F48","v":11722040.683699999},null,{"$f":"'5. Utility Income'!F48","v":11722040.683699999},null,{"$f":"'5. Utility Income'!N48","v":11719490.683699999},null,{"$f":"J21","v":11719490.683699999},null,{"$f":"'5. Utility Income'!V48","v":11719490.683699999},null,{"$f":"'5. Utility Income'!V48","v":11719490.683699999}]
[null,4,null,"Total Revenue",null,{"$f":"SUM(F20:F21)","v":170031917.9833},null,{"$f":"SUM(H19:H21)","v":208120414.4620631},null,{"$f":"SUM(J20:J21)","v":170031535.6837},null,{"$f":"SUM(L19:L21)","v":190594482.6837},null,{"$f":"SUM(N20:N21)","v":170031535.6837},null,{"$f":"SUM(P19:P21)","v":190594482.6837}]
[]
[null,5,null,"Operating Expenses",null,{"$f":"'5. Utility Income'!F27","v":139897846.26254949},null,{"$f":"'5. Utility Income'!F27","v":139897846.26254949},null,{"$f":"'5. Utility Income'!N27","v":132698907.18174633},null,{"$f":"'5. Utility Income'!N27","v":132698907.18174633},null,{"$f":"'5. Utility Income'!V27","v":132698907.18174633},null,{"$f":"'5. Utility Income'!V27","v":132698907.18174633}]
[null,6,null,"Deemed Interest Expense",null,{"$f":"'5. Utility Income'!F30","v":24193292.715965107},null,{"$f":"'5. Utility Income'!F30","v":24193292.715965107},null,{"$f":"'5. Utility Income'!N30","v":19442226.495583367},null,{"$f":"'5. Utility Income'!N30","v":19442226.495583367},null,{"$f":"'5. Utility Income'!V30","v":21645479.222067047},null,{"$f":"'5. Utility Income'!V30","v":21645479.222067047}]
[null,8,null,"Total Cost and Expenses",null,{"$f":"SUM(F24:F25)","v":164091138.97851461},null,{"$f":"SUM(H24:H25)","v":164091138.97851461},null,{"$f":"SUM(J24:J25)","v":152141133.67732969},null,{"$f":"SUM(L24:L25)","v":152141133.67732969},null,{"$f":"SUM(N24:N25)","v":154344386.40381339},null,{"$f":"SUM(P24:P25)","v":154344386.40381339}]
[]
[null,9,null,"Utility Income Before Income Taxes",null,{"$f":"F22-F26","v":5940779.0047853887},null,{"$f":"H22-H26","v":44029275.483548492},null,{"$f":"J22-J26","v":17890402.006370306},null,{"$f":"L22-L26","v":38453349.006370306},null,{"$f":"N22-N26","v":15687149.279886603},null,{"$f":"P22-P26","v":36250096.279886603}]
[null,null,null,"   "]
[null,10,null,"Tax Adjustments to Accounting               Income per 2013 PILs model",null,{"$f":"'3. Data_Input_Sheet'!E44","v":-19959369.954213694},null,{"$f":"'3. Data_Input_Sheet'!E44","v":-19959369.954213694},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-19474050},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M44),'3. Data_Input_Sheet'!E44,'3. Data_Input_Sheet'!M44)","v":-19474050},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":-19474050},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U44),'3. Data_Input_Sheet'!M44,'3. Data_Input_Sheet'!U44)","v":-19474050}]
[null,11,null,"Taxable Income",null,{"$f":"SUM(F28:F30)","v":-14018590.949428305},null,{"$f":"SUM(H28:H30)","v":24069905.529334798},null,{"$f":"SUM(J28+J30)","v":-1583647.993629694},null,{"$f":"L28+L30","v":18979299.006370306},null,{"$f":"SUM(N28+N30)","v":-3786900.7201133966},null,{"$f":"P28+P30","v":16776046.279886603}]
[]
[null,12,null,"Income Tax Rate",null,{"$f":"'6. Taxes_PILs'!G41","v":0.26305509034572022},null,{"$f":"'6. Taxes_PILs'!G41","v":0.26305509034572022},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":"F31*F33","v":-3687661.7087215586},null,{"$f":"H31*H33","v":6331711.1736321161},null,{"$f":"J31*J33","v":-419666.7183118689},null,{"$f":"L31*L33","v":5029514.2366881315},null,{"$f":"N31*N33","v":-1003528.6908300502},null,{"$f":"P31*P33","v":4445652.26416995}]
[null,14,null,"Income Tax Credits",null,{"$f":"'3. Data_Input_Sheet'!E51","v":-257500},null,{"$f":"'3. Data_Input_Sheet'!E51","v":-257500},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":-132500},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!M51),'3. Data_Input_Sheet'!E51,'3. Data_Input_Sheet'!M51)","v":-132500},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":-132500},null,{"$f":"IF(ISBLANK('3. Data_Input_Sheet'!U51),'3. Data_Input_Sheet'!M51,'3. Data_Input_Sheet'!U51)","v":-132500}]
[null,15,null,"Utility Net Income ",null,{"$f":"F28-SUM(F34:F35)","v":9885940.7135069482},null,{"$f":"'5. Utility Income'!F37","v":37955064.316122182},null,{"$f":"J28-SUM(J34:J35)","v":18442568.724682175},null,{"$f":"'5. Utility Income'!N37","v":33556334.040383913},null,{"$f":"N28-SUM(N34:N35)","v":16823177.970716655},null,{"$f":"'5. Utility Income'!V37","v":31353081.31390021}]
[]
[null,16,null,"Utility Rate Base",null,{"$f":"'4. Rate_Base'!G18","v":1020297432.353454},null,{"$f":"'4. Rate_Base'!G18","v":1020297432.353454},null,{"$f":"'4. Rate_Base'!O18","v":912849157.47583687},null,{"$f":"'4. Rate_Base'!O18","v":912849157.47583687},null,{"$f":"'4. Rate_Base'!W18","v":912849157.47583687},null,{"$f":"'4. Rate_Base'!W18","v":912849157.47583687}]
[]
[null,17,null,"Deemed Equity Portion of Rate Base ",null,{"$f":"'7. Cost_of_Capital'!J24","v":408118972.94138163},null,{"$f":"F40","v":408118972.94138163},null,{"$f":"'7. Cost_of_Capital'!J40","v":365139662.99033475},null,{"$f":"J40","v":365139662.99033475},null,{"$f":"'7. Cost_of_Capital'!J56","v":365139662.99033475},null,{"$f":"N40","v":365139662.99033475}]
[]
[null,18,null,"Income/(Equity Portion of Rate Base)",null,{"$f":"IF(F40=0,0,F36/F40)","v":2.4223183358169607E-2},null,{"$f":"IF(H40=0,0,H36/H40)","v":9.2999999589761018E-2},null,{"$f":"IF(J40=0,0,J36/J40)","v":5.0508259151157593E-2},null,{"$f":"IF(L40=0,0,L36/L40)","v":9.1899997293014291E-2},null,{"$f":"IF(N40=0,0,N36/N40)","v":4.6073269151157552E-2},null,{"$f":"IF(P40=0,0,P36/P40)","v":8.5865997293014223E-2}]
[null,19,null,"Target Return - Equity on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L24","v":9.2999999999999999E-2},null,{"$f":"'7. Cost_of_Capital'!L24","v":9.2999999999999999E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":9.1899999999999996E-2},null,{"$f":"'7. Cost_of_Capital'!L40","v":9.1899999999999996E-2},null,{"$f":"'7. Cost_of_Capital'!L56","v":9.2999999999999999E-2},null,{"$f":"'7. Cost_of_Capital'!L56","v":9.2999999999999999E-2}]
[null,20,null,"Deficiency/Sufficiency in Return on Equity",null,{"$f":"F42-F43","v":-6.8776816641830385E-2},null,{"$f":"H42-H43","v":-4.1023898167402706E-10},null,{"$f":"J42-J43","v":-4.1391740848842402E-2},null,{"$f":"L42-L43","v":-2.7069857050365798E-9},null,{"$f":"N42-N43","v":-4.6926730848842448E-2},null,{"$f":"P42-P43","v":-7.1340027069857759E-3}]
[]
[null,21,null,"Indicated Rate of Return",null,{"$f":"IF(F38=0,0,(F36+F25)/F38)","v":3.3401273343267854E-2},null,{"$f":"IF(H38=0,0,(H36+H25)/H38)","v":6.0911999835904417E-2},null,{"$f":"IF(J38=0,0,(J36+J25)/J38)","v":4.1501703660463039E-2},null,{"$f":"IF(L40=0,0,(L36+L25)/L38)","v":5.8058398917205711E-2},null,{"$f":"IF(N38=0,0,(N36+N25)/N38)","v":4.214130766046302E-2},null,{"$f":"IF(P40=0,0,(P36+P25)/P38)","v":5.8058398917205697E-2}]
[null,22,null,"Requested Rate of Return on Rate Base",null,{"$f":"'7. Cost_of_Capital'!L26","v":6.0912000000000008E-2},null,{"$f":"'7. Cost_of_Capital'!L26","v":6.0912000000000008E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":5.8058400000000003E-2},null,{"$f":"'7. Cost_of_Capital'!L42","v":5.8058400000000003E-2},null,{"$f":"'7. Cost_of_Capital'!L58","v":6.0912000000000008E-2},null,{"$f":"'7. Cost_of_Capital'!L58","v":6.0912000000000008E-2}]
[null,23,null,"Deficiency/Sufficiency in Rate of Return",null,{"$f":"F46-F47","v":-2.7510726656732154E-2},null,{"$f":"H46-H47","v":-1.6409559128183204E-10},null,{"$f":"J46-J47","v":-1.6556696339536964E-2},null,{"$f":"L46-L47","v":-1.0827942917290834E-9},null,{"$f":"N46-N47","v":-1.8770692339536987E-2},null,{"$f":"P46-P47","v":-2.8536010827943104E-3}]
[]
[null,24,null,"Target Return on Equity",null,{"$f":"H50","v":37955064.483548492},null,{"$f":"'7. Cost_of_Capital'!P24","v":37955064.483548492},null,{"$f":"L50","v":33556335.02881176},null,{"$f":"'7. Cost_of_Capital'!P40","v":33556335.02881176},null,{"$f":"P50","v":33957988.658101134},null,{"$f":"'7. Cost_of_Capital'!P56","v":33957988.658101134}]
[null,25,null,"Revenue Deficiency/(Sufficiency)",null,{"$f":"F50-F36","v":28069123.770041544}," ",{"$f":"H38*H48","v":-0.16742631044537507},null,{"$f":"J50-J36","v":15113766.304129586},null,{"$f":"L38*L48","v":-0.98842785692453927},null,{"$f":"N50-N36","v":17134810.687384479},null,{"$f":"P38*P48","v":-2604907.3442009222}]
[null,26,null,"Gross Revenue Deficiency/(Sufficiency)",null,{"$f":"F51/(1-F33)","v":38088496.71437382},"(1)",null,null,{"$f":"J51/(1-J33)","v":20562947.352557261},"(1)",null,null,{"$f":"N51/(1-N33)","v":23312667.601883646},"(1)"]
[]
[]
[null,"Notes:"]
[null,"(1)",null,"Revenue Deficiency/Sufficiency divided by (1 - Tax Rate)"]

{"sheet":"9. Rev_Reqt","index":8,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[42,3,42,16],[43,3,43,16],[44,3,44,16],[15,13,15,14],[16,13,16,14],[20,13,20,14],[24,13,24,14],[39,3,39,16],[40,3,40,16],[37,1,37,14],[31,13,31,14],[32,9,33,9],[34,9,35,9],[34,5,35,5],[32,5,33,5],[12,13,12,14],[7,5,7,14],[41,3,41,16],[32,13,33,14],[34,13,35,14],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":90624893.793108985},null,null,null,{"$f":"'5. Utility Income'!N22","v":84084970.601194724},null,null,null,{"$f":"'5. Utility Income'!V22","v":84084970.601194724}]
[null,2,null,"Amortization/Depreciation",null,{"$f":"'5. Utility Income'!F23","v":47047408.888888888},null,null,null,{"$f":"'5. Utility Income'!N23","v":46388393},null,null,null,{"$f":"'5. Utility Income'!V23","v":46388393}]
[null,3,null,"Property Taxes",null,{"$f":"'5. Utility Income'!F24","v":2225543.5805516103},null,null,null,{"$f":"'5. Utility Income'!N24","v":2225543.5805516103},null,null,null,{"$f":"'5. Utility Income'!V24","v":2225543.5805516103}]
[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":6074211.1674263114},null,null,null,{"$f":"'6. Taxes_PILs'!K33-J18","v":4897014.9659863943},null,null,null,{"$f":"'6. Taxes_PILs'!O33-N18","v":4897014.9659863943}]
[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":24193292.715965107},null,null,null,{"$f":"'8. Rev_Def_Suff'!L25","v":19442226.495583367},null,null,null,{"$f":"'8. Rev_Def_Suff'!P25","v":21645479.222067047}]
[null,null,null,"Return on Deemed Equity",null,{"$f":"'8. Rev_Def_Suff'!F50","v":37955064.483548492},null,null,null,{"$f":"'8. Rev_Def_Suff'!L50","v":33556335.02881176},null,null,null,{"$f":"'8. Rev_Def_Suff'!P50","v":33957988.658101134}]
[]
[null,8,null,"Service Revenue Requirement (before Revenues)",null,{"$f":"SUM(F15:F23)","v":208120414.62948939},null,null,null,{"$f":"SUM(J15:J23)","v":190594483.67212784},null,null,null,{"$f":"SUM(N15:O23)","v":193199390.02790093}]
[]
[null,9,null,"Revenue Offsets",null,{"$f":"'3. Data_Input_Sheet'!E33","v":11722040.683699999},null,null,null,{"$f":"'3. Data_Input_Sheet'!M33","v":11719490.683699999},null,null,null,{"$f":"'3. Data_Input_Sheet'!U33","v":0}]
[null,10,null,"Base Revenue Requirement",null,{"$f":"F25-F27","v":196398373.9457894},null,null,null,{"$f":"J25-J27","v":178874992.98842785},null,null,null,{"$f":"N25-N27","v":193199390.02790093}]
[null,null,null,"(excluding Tranformer Owership Allowance credit adjustment)"]
[]
[null,11,null,"Distribution revenue",null,{"$f":"'5. Utility Income'!F16","v":196398373.77836311},null,2,null,{"$f":"'5. Utility Income'!N16","v":178874992},null,3,null,{"$f":"'5. Utility Income'!V16","v":178874992}]
[null,12,null,"Other revenue",null,{"$f":"'5. Utility Income'!F17","v":11722040.683699999},null,null,null,{"$f":"'5. Utility Income'!N17","v":11719490.683699999},null,null,null,{"$f":"'5. Utility Income'!V17","v":11719490.683699999}]
[null,null,null,null,null,{"$f":"SUM(F31:F32)","v":208120414.4620631},null,null,null,{"$f":"SUM(J31:J32)","v":190594482.6837},null,null,null,{"$f":"SUM(N31:N32)","v":190594482.6837}]
[null,13,null,"Total revenue"]
[null,null,null,null,null,{"$f":"F33-F25","v":-0.16742628812789917},null,null,null,{"$f":"J33-J25","v":-0.98842784762382507},null,null,null,{"$f":"N33-N25","v":-2604907.3442009389}]
[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,"Notes"]
[null,"(1)",null,"Line 11 - Line 8"]
[null,2,null,"Distribution Revenue not including Transformer Ownership Allowance, Total Revenue Requirement is $197,507,477"]
[null,3,null,"Distribution Revenue not including Transformer Ownership Allowance, Total Revenue Requirement is $179,984,095"]

{"sheet":"10. Tracking_Sheet","index":9,"n_rows":203,"n_cols":18,"rows_kept":203,"cut":false,"hidden":false,"merged":[[14,1,14,14],[199,0,201,0],[199,1,200,1],[190,0,192,0],[190,1,191,1],[193,0,195,0],[193,1,194,1],[196,0,198,0],[196,1,197,1],[181,0,183,0],[181,1,182,1],[184,0,186,0],[184,1,185,1],[187,0,189,0],[187,1,188,1],[172,0,174,0],[172,1,173,1],[175,0,177,0],[175,1,176,1],[178,0,180,0],[178,1,179,1],[163,0,165,0],[163,1,164,1],[166,0,168,0],[166,1,167,1],[169,0,171,0],[169,1,170,1],[154,0,156,0],[154,1,155,1],[157,0,159,0],[157,1,158,1],[160,0,162,0],[160,1,161,1],[145,0,147,0],[145,1,146,1],[148,0,150,0],[148,1,149,1],[151,0,153,0],[151,1,152,1],[136,0,138,0],[136,1,137,1],[139,0,141,0],[139,1,140,1],[142,0,144,0],[142,1,143,1],[127,0,129,0],[127,1,128,1],[130,0,132,0],[130,1,131,1],[133,0,135,0],[133,1,134,1],[118,0,120,0],[118,1,119,1],[121,0,123,0],[121,1,122,1],[124,0,126,0],[124,1,125,1],[109,0,111,0],[109,1,110,1],[112,0,114,0],[112,1,113,1],[115,0,117,0],[115,1,116,1],[100,0,102,0],[100,1,101,1],[103,0,105,0],[103,1,104,1],[106,0,108,0],[106,1,107,1],[91,0,93,0],[91,1,92,1],[94,0,96,0],[94,1,95,1],[97,0,99,0],[97,1,98,1],[82,0,84,0],[82,1,83,1],[85,0,87,0],[85,1,86,1],[88,0,90,0],[88,1,89,1],[17,3,17,4],[17,8,17,10],[17,5,17,7],[17,11,17,14],[22,1,23,1],[25,1,26,1],[22,0,24,0],[25,0,27,0],[28,0,30,0],[28,1,29,1],[55,0,57,0],[55,1,56,1],[58,0,60,0],[58,1,59,1],[37,0,39,0],[37,1,38,1],[40,0,42,0],[40,1,41,1],[31,0,33,0],[31,1,32,1],[34,0,36,0],[34,1,35,1],[49,0,51,0],[49,1,50,1],[210,1,210,14],[211,1,211,14],[15,1,15,14],[73,0,75,0],[73,1,74,1],[208,1,208,14],[76,0,78,0],[76,1,77,1],[79,0,81,0],[79,1,80,1],[67,0,69,0],[67,1,68,1],[70,0,72,0],[70,1,71,1],[61,0,63,0],[52,0,54,0],[52,1,53,1],[43,0,45,0],[43,1,44,1],[46,0,48,0],[46,1,47,1],[61,1,62,1],[64,0,66,0],[64,1,65,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tracking Form"]
[null,"The 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":62148357.199513599},{"$f":"'7. Cost_of_Capital'!L26","v":6.0912000000000008E-2},{"$f":"'4. Rate_Base'!G18","v":1020297432.353454},{"$f":"'4. Rate_Base'!G26","v":1040409210.7656128},{"$f":"'4. Rate_Base'!G30","v":147738107.92871702},{"$f":"'9. Rev_Reqt'!F16","v":47047408.888888888},{"$f":"'9. Rev_Reqt'!F19","v":6074211.1674263114},{"$f":"'9. Rev_Reqt'!F15","v":90624893.793108985},{"$f":"'9. Rev_Reqt'!F25","v":208120414.62948939},{"$f":"'9. Rev_Reqt'!F32","v":11722040.683699999},{"$f":"'9. Rev_Reqt'!F28","v":196398373.9457894},{"$f":"'8. Rev_Def_Suff'!F52","v":38088496.71437382}]
[]
[1,"2018 Year",null,62148357.199513599,6.0912000000000008E-2,1020297432.353454,1040409210.7656128,147738107.92871702,47047408.888888888,6074211.1674263114,90624893.793108985,208120414.62948939,11722040.683699999,196398373.9457894,38088496.71437382,null,{"$f":"IF(AND(ISBLANK(B23), ISBLANK(C23)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D23=\"\",\"\",D23-D21)","v":0},{"$f":"IF(E23=\"\",\"\",E23-E21)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[2,"Exhibit B-2-1, D-4-1 and F-1-1, IR OEB#1 and EP#38","See note 12, 13 & 14 on Data_Input_Sheet, Update 2014 Actual Capital, Sentinel Lights Correction and PILs Update",62076554.990000002,6.0900000000000003E-2,1019118646,1040409211,147738108,46943424,6154952,90624893.793108985,208025368,11722041,196303327,37991282,null,{"$f":"IF(AND(ISBLANK(B26), ISBLANK(C26)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D26=\"\",\"\",D26-D24)","v":62076554.990000002},6.0900000000000003E-2,1019118646,1040409211,147738108,46943424,6154952,90624893.793108985,208025368,11722041,196303327,37991282]
[]
[3,"Amended Settlement Agreement","See data Input Sheet for Notes",{"$f":"+'7. Cost_of_Capital'!P42","v":52998561.524395123},{"$f":"+'7. Cost_of_Capital'!L42","v":5.8058400000000003E-2},912849157,{"$f":"+'4. Rate_Base'!O26","v":1033869287.5736986},{"$f":"+'4. Rate_Base'!O30","v":81882447.575836942},{"$f":"+'9. Rev_Reqt'!J16","v":46388393},{"$f":"+'9. Rev_Reqt'!J19","v":4897014.9659863943},{"$f":"+'9. Rev_Reqt'!J15","v":84084970.601194724},{"$f":"+'9. Rev_Reqt'!J28+'9. Rev_Reqt'!J27","v":190594483.67212784},{"$f":"+'9. Rev_Reqt'!J27","v":11719490.683699999},{"$f":"+'9. Rev_Reqt'!J31","v":178874992},{"$f":"+'8. Rev_Def_Suff'!J52","v":20562947.352557261},null,{"$f":"IF(AND(ISBLANK(B29), ISBLANK(C29)), \"X\", \"\")","v":""}]
[null,null,"          Change",{"$f":"IF(D29=\"\",\"\",D29-D27)","v":-9077993.465604879},-2.8415999999999997E-3,-106269489,-6539923.4263013601,-65855660.424163058,-555031,-1257937.0340136057,-6539923.1919142604,-17430884.327872157,-2550.3163000009954,-17428335,-17428334.647442739]
[]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B32), ISBLANK(C32)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D32=\"\",\"\",D32-D30)","v":""},"","","","","","","","","","",""]
[]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B35), ISBLANK(C35)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D35=\"\",\"\",D35-D33)","v":""},"","","","","","","","","","",""]
[]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B38), ISBLANK(C38)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D38=\"\",\"\",D38-D36)","v":""},"","","","","","","","","","",""]
[]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B41), ISBLANK(C41)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D41=\"\",\"\",D41-D39)","v":""},"","","","","","","","","","",""]
[]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B44), ISBLANK(C44)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D44=\"\",\"\",D44-D42)","v":""},"","","","","","","","","","",""]
[]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B47), ISBLANK(C47)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D47=\"\",\"\",D47-D45)","v":""},"","","","","","","","","","",""]
[]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B50), ISBLANK(C50)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D50=\"\",\"\",D50-D48)","v":""},"","","","","","","","","","",""]
[]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B53), ISBLANK(C53)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D53=\"\",\"\",D53-D51)","v":""},"","","","","","","","","","",""]
[]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B56), ISBLANK(C56)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D56=\"\",\"\",D56-D54)","v":""},"","","","","","","","","","",""]
[]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B59), ISBLANK(C59)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D59=\"\",\"\",D59-D57)","v":""},"","","","","","","","","","",""]
[]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B62), ISBLANK(C62)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D62=\"\",\"\",D62-D60)","v":""},"","","","","","","","","","",""]
[]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(B65), ISBLANK(C65)), \"X\", \"\")","v":"X"}]
[null,null,"          Change",{"$f":"IF(D65=\"\",\"\",D65-D63)","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-D66)","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-D69)","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-D72)","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-D75)","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-D78)","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-D81)","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-D84)","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-D87)","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-D90)","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-D93)","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-D96)","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-D99)","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-D102)","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-D105)","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-D108)","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-D111)","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-D114)","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-D117)","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-D120)","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-D123)","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-D126)","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-D129)","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-D132)","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-D135)","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-D138)","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-D141)","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-D144)","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-D147)","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-D150)","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-D153)","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-D156)","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-D159)","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-D162)","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-D165)","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-D168)","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-D171)","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-D174)","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-D177)","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-D180)","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-D183)","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-D186)","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-D189)","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-D192)","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-D195)","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-D198)","v":""},"","","","","","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page Break 4"]