{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Table of Content","A. LDC Info","B. CurrentTariff","C. Revenues at Curr Rates","RATEBASE & REV REQ ->","D. Rate Base","E. Revenue Requirement","COST ALLOC. & RATE DESIGN ->","F. Cost Allocation & RevAllocn","G. RateDesign","H. Rev_Reconciliation","I. Res Rate Design","J. Cost Allocation","RATE RIDERS ->","K. SMRR","L. DVA","K. Summary of Tariffs","BILL IMPACT ->","Bill Impact - Res 10 Pct","Bill Impact - Residential","Bill Impact - GS<50","Bill Impact - GS>50","Bill Impact - StreetLight","Bill Impact - USL","Update to COS Application"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":9,"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":"Table of Content","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,3,6,7]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[null,null,null,"Table of Content"]
[]
[null,null,null,null,"A. LDC Info"]
[null,null,null,null,"B. CurrentTariff"]
[null,null,null,null,"C. Revenues at Curr Rates"]
[null,null,null,null,"RATEBASE & REV REQ ->"]
[null,null,null,null,"D. Rate Base"]
[null,null,null,null,"E. Revenue Requirement"]
[null,null,null,null,"COST ALLOC. & RATE DESIGN ->"]
[null,null,null,null,"F. Cost Allocation & RevAllocn"]
[null,null,null,null,"G. RateDesign"]
[null,null,null,null,"H. Rev_Reconciliation"]
[null,null,null,null,"RATE RIDERS ->"]
[null,null,null,null,"I. SMRR"]
[null,null,null,null,"J. DVA"]
[null,null,null,null,"K. Summary of Tariffs"]
[null,null,null,null,"RRWF ->"]
[null,null,null,null,"RRWF_Data_Input_Sheet"]
[null,null,null,null,"RRWF_Rate_Base"]
[null,null,null,null,"RRWF_Utility Income"]
[null,null,null,null,"RRWF_Taxes_PILs"]
[null,null,null,null,"RRWF_Cost_of_Capital"]
[null,null,null,null,"RRWF_Rev_Def_Suff"]
[null,null,null,null,"RRWF_Rev_Reqt"]
[null,null,null,null,"Update to COS Application"]

{"sheet":"A. LDC Info","index":1,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[17,4,17,8],[33,2,33,12],[19,4,19,8],[29,2,29,11],[31,2,31,13],[9,4,9,10],[11,4,11,8],[13,4,13,8],[15,4,15,8],[15,9,15,10]]}
["Rate Design Model version 1.0 © CHEC ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Utility Name   ","Renfrew Hydro Inc."]
[]
[null,null,null,"Service Territory"," "]
[]
[null,null,null,"Assigned EB Number"," "]
[]
[null,null,null,"Name of Contact and Title","Bill Nippard- President"]
[]
[null,null,null,"Phone Number   ","613-432-4884"]
[]
[null,null,null,"Email Address   ","bnippard@renfrewhydro.com"]
[]
[null,null,null,"Bridge Year",2016]
[]
[null,null,null,"Test Year",2017]
[]
[null,null,null,"Last Rebasing Year",2010]
[]
[null,"Notes"]
[]
[null,null,"Pale green cells represent input cells."]
[]
[null,null,"Pale blue cells represent drop-down lists.  The applicant should select the appropriate item from the drop-down list."]
[]
[null,null,"White cells contain fixed values, automatically generated values or formulae. "]

{"sheet":"B. CurrentTariff","index":2,"n_rows":217,"n_cols":4,"rows_kept":217,"cut":false,"hidden":false,"merged":[[8,0,8,3]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
["Customer Class & Current Tariff Sheet"]
[]
[]
["Customer Class Name","Existing/ Proposed","MSC\nMetric","Usage Metric"]
["Residential","Exisitng","Customer","kWh"]
["General Service < 50 kW","Existing","Customer","kWh"]
["General Service > 50 to 4999 kW","Existing","Customer","kW"]
["Unmetered Scattered Load","Existing","Connection","kWh"]
["Street Lighting ","Existing","Connection","kW"]
["other classes","Existing","Customer","kWh"]
["other classes","Existing","Connection","kW"]
["other classes","Existing","Connection","kW"]
["other classes","Existing","Connection","kW"]
[]
["Currently Approved Loss Factor"," "]
[]
["Total Loss Factor – Secondary Metered Customer < 5,000 kW",1.0389999999999999]
["Total Loss Factor – Secondary Metered Customer > 5,000 kW"]
["Total Loss Factor – Primary Metered Customer < 5,000 kW",1.0286]
["Total Loss Factor – Primary Metered Customer > 5,000 KW"," "]
[]
[{"$f":"A13","v":"Residential"},"Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,13.97,"$"]
["Distribution Volumetric Rate",null,1.4500000000000001E-2,"kWh"]
["Rate Rider for Smart Metering Entity Charge - effective until October 31, 2018",null,0.79,"kWh"]
["Low Voltage Service Rate",null,1.1000000000000001E-3,"kWh"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,6.4000000000000003E-3,"kWh"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,3.3E-3,"kWh"]
["Wholesale Market Service Rate",null,4.4000000000000003E-3,"kWh"]
["Rural Rate Protection Charge",null,1.2999999999999999E-3,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]
[]
[{"$f":"A14","v":"General Service < 50 kW"},"Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,31.25,"$"]
["Distribution Volumetric Rate",null,1.37E-2,"kWh"]
["Rate Rider for Smart Metering Entity Charge - effective until October 31, 2018",null,0.79,"kWh"]
["Low Voltage Service Rate",null,1E-3,"kWh"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,5.7999999999999996E-3,"kWh"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,3.0999999999999999E-3,"kWh"]
["Wholesale Market Service Rate",null,4.4000000000000003E-3,"kWh"]
["Rural Rate Protection Charge",null,1.2999999999999999E-3,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]
[]
[{"$f":"A15","v":"General Service > 50 to 4999 kW"},"Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,189.27,"$"]
["Distribution Volumetric Rate",null,2.5331000000000001,"kW"]
["Low Voltage Service Rate",null,0.35639999999999999,"kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,2.3668,"kW"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,1.1566000000000001,"kW"]
["Wholesale Market Service Rate",null,4.4000000000000003E-3,"kWh"]
["Rural Rate Protection Charge",null,1.2999999999999999E-3,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]
[]
[{"$f":"A16","v":"Unmetered Scattered Load"},"Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,43.63,"$"]
["Distribution Volumetric Rate",null,9.9000000000000008E-3,"kW"]
["Low Voltage Service Rate",null,1E-3,"kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,5.7999999999999996E-3,"kW"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,3.0999999999999999E-3,"kW"]
["Wholesale Market Service Rate",null,4.4000000000000003E-3,"kWh"]
["Rural Rate Protection Charge",null,1.2999999999999999E-3,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]
[]
[{"$f":"A17","v":"Street Lighting "},"Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,2.95,"$"]
["Distribution Volumetric Rate",null,7.2483000000000004,"kW"]
["Low Voltage Service Rate",null,0.27539999999999998,"kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,1.7848999999999999,"kW"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,0.89410000000000001,"kW"]
["Wholesale Market Service Rate",null,4.4000000000000003E-3,"kWh"]
["Rural Rate Protection Charge",null,1.2999999999999999E-3,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]
[]
[{"$f":"A18","v":"other classes"},"Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,6.25,"$"]
["Distribution Volumetric Rate",null,2E-3,"kWh"]
["Low Voltage Service Rate",null,1E-3,"kWh"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,5.7999999999999996E-3,"kWh"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,4.0000000000000001E-3,"kWh"]
["Wholesale Market Service Rate",null,0,"kWh"]
["Rural Rate Protection Charge",null,0,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]
[]
["Other Rate Classes","Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,0,"$"]
["Distribution Volumetric Rate",null,0,"kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,0,"kW"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,0,"kW"]
["Wholesale Market Service Rate",null,0,"kWh"]
["Rural Rate Protection Charge",null,0,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]
[]
["Other Rate Classes","Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,0,"$"]
["Distribution Volumetric Rate",null,0,"kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,0,"kW"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,0,"kW"]
["Wholesale Market Service Rate",null,0,"kWh"]
["Rural Rate Protection Charge",null,0,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]
[]
["Other Rate Classes","Effective Until mm/dd/yy","rate","Connection Type"]
[]
["Service Charge",null,0,"$"]
["Distribution Volumetric Rate",null,0,"kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Retail Transmission Rate – Network Service Rate",null,0,"kW"]
["Retail Transmission Rate – Line and Transformation Connection Service Rate",null,0,"kW"]
["Wholesale Market Service Rate",null,0,"kWh"]
["Rural Rate Protection Charge",null,0,"kWh"]
["Standard Supply Service – Administrative Charge (if applicable)",null,0.25,"$"]

{"sheet":"C. Revenues at Curr Rates","index":3,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[47,1,47,8],[9,0,9,8],[33,0,33,8],[8,0,8,10],[12,1,12,8],[23,1,23,8],[36,1,36,8]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[" "]
["Projected Revenues at Current Rates"]
[]
["2010 Rates at 2017 Load"]
[null,"Test Year Projected Revenue from Existing Variable Charges"]
["Customer Class Name","Variable\nDistribution\nRate","per","Test Year Volume","Gross\nVariable\nRevenue","Transform.\nAllowance\nRate","Transform.\nAllowance\nkW's","Transform.\nAllowance\n$'s","Net\nVariable\nRevenue"]
[{"$f":"'B. CurrentTariff'!A13","v":"Residential"},1.4500000000000001E-2,{"$f":"'B. CurrentTariff'!D13","v":"kWh"},28929065.912004169,{"$f":"B15*D15","v":419471.45572406048},null,null,{"$f":"F15*G15","v":0},{"$f":"E15+H15","v":419471.45572406048}]
[{"$f":"'B. CurrentTariff'!A14","v":"General Service < 50 kW"},1.37E-2,{"$f":"'B. CurrentTariff'!D14","v":"kWh"},11749297.376261501,{"$f":"B16*D16","v":160965.37405478256},null,null,{"$f":"F16*G16","v":0},{"$f":"E16+H16","v":160965.37405478256}]
[{"$f":"'B. CurrentTariff'!A15","v":"General Service > 50 to 4999 kW"},2.5331000000000001,{"$f":"'B. CurrentTariff'!D15","v":"kW"},118023.99702302532,298966.58685902547,-0.6,69011,-41406.6,257559.98685902546]
[{"$f":"'B. CurrentTariff'!A16","v":"Unmetered Scattered Load"},9.9000000000000008E-3,{"$f":"'B. CurrentTariff'!D16","v":"kWh"},149639.52272445985,1481.4312749721526,null,null,0,1481.4312749721526]
[{"$f":"'B. CurrentTariff'!A17","v":"Street Lighting "},7.2483000000000004,{"$f":"'B. CurrentTariff'!D17","v":"kW"},3007.3398175917232,21798.101199850087,null,null,0,21798.101199850087]
["Total Variable Revenue",null,null,{"$f":"SUM(D15:D19)","v":40949034.14783074},902682.94911269087,-0.6,69011,-41406.6,861276.34911269078]
[]
[]
["2010 Rates at 2017 Load"]
[null,"Test Year Projected Revenue from Proposed Fixed Charges"]
["Customer Class Name","Fixed\nRate","Customers\n(Connections)","Fixed Charge Revenue","Variable Revenue","TOTAL","% Fixed\nRevenue","% Variable\nRevenue","% Total\nRevenue"]
[{"$f":"A15","v":"Residential"},13.97,3834.9876147687037,{"$f":"B26*12*C26","v":642897.32373982552},{"$f":"I15","v":419471.45572406048},{"$f":"D26+E26","v":1062368.7794638861},{"$f":"IF(D26, ABS(D26/F26),\"\")","v":0.605154571714972},{"$f":"IF(E26,ABS(E26/F26),\"\")","v":0.39484542828502794},{"$f":"IF(F26,ABS(F26/$F$31),\"\")","v":0.57171615057026282}]
[{"$f":"A16","v":"General Service < 50 kW"},31.25,413.64109259168811,155115.40972188304,{"$f":"I16","v":160965.37405478256},{"$f":"D27+E27","v":316080.78377666557},0.49074609303513855,0.5092539069648615,{"$f":"IF(F27,ABS(F27/$F$31),\"\")","v":0.17009958543889023}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},189.27,61,138545.64000000001,{"$f":"I17","v":257559.98685902546},396105.62685902545,0.3497694317008746,0.65023056829912551,{"$f":"IF(F28,ABS(F28/$F$31),\"\")","v":0.21316513491797429}]
[{"$f":"A18","v":"Unmetered Scattered Load"},43.63,34.227155540162357,17919.969554607407,{"$f":"I18","v":1481.4312749721526},19401.400829579561,0.92364307670436097,7.6356923295638951E-2,{"$f":"IF(F29,ABS(F29/$F$31),\"\")","v":1.0440907538298939E-2}]
[{"$f":"A19","v":"Street Lighting "},2.95,1199.30798221087,{"$f":"B30*12*C30","v":42455.502570264805},{"$f":"I19","v":21798.101199850087},{"$f":"D30+E30","v":64253.603770114889},{"$f":"IF(D30, ABS(D30/F30),\"\")","v":0.66074897093960916},{"$f":"IF(E30,ABS(E30/F30),\"\")","v":0.3392510290603909},{"$f":"IF(F30,ABS(F30/$F$31),\"\")","v":3.4578221534573787E-2}]
["Total Fixed Revenue",null,{"$f":"SUM(C26:C30)","v":5543.1638451114241},{"$f":"SUM(D26:D30)","v":996933.84558658081},{"$f":"SUM(E26:E30)","v":861276.34911269078},{"$f":"SUM(F26:F30)","v":1858210.1946992713}]
[]
[]
["Projected Revenues at Proposed Rates"]
[]
["2017 Rates at 2017 Load"]
[null,"Test Year Projected Revenue from Existing Variable Charges"]
["Customer Class Name","Variable\nDistribution\nRate","per","Test Year Volume","Gross\nVariable\nRevenue","Transform.\nAllowance\nRate","Transform.\nAllowance\nkW's","Transform.\nAllowance\n$'s","Net\nVariable\nRevenue"]
[{"$f":"'B. CurrentTariff'!A13","v":"Residential"},{"$f":"'H. Rev_Reconciliation'!I15","v":1.3976689220655134E-2},{"$f":"'B. CurrentTariff'!D13","v":"kWh"},28929065.912004169,{"$f":"B39*D39","v":404332.56369593053},null,null,{"$f":"F15*G15","v":0},{"$f":"E39+H39","v":404332.56369593053}]
[{"$f":"'B. CurrentTariff'!A14","v":"General Service < 50 kW"},{"$f":"'H. Rev_Reconciliation'!I16","v":1.8040240945143494E-2},{"$f":"'B. CurrentTariff'!D14","v":"kWh"},11749297.376261501,{"$f":"B40*D40","v":211960.15560389974},null,null,{"$f":"F16*G16","v":0},{"$f":"E40+H40","v":211960.15560389974}]
[{"$f":"'B. CurrentTariff'!A15","v":"General Service > 50 to 4999 kW"},{"$f":"'H. Rev_Reconciliation'!J17","v":3.1921101160778975},{"$f":"'B. CurrentTariff'!D15","v":"kW"},118023.99702302532,376745.59483714681,-0.6,69011,{"$f":"F17*G17","v":-41406.6},335338.99483714683]
[{"$f":"'B. CurrentTariff'!A16","v":"Unmetered Scattered Load"},{"$f":"'H. Rev_Reconciliation'!I18","v":8.8690719314647067E-3},{"$f":"'B. CurrentTariff'!D16","v":"kWh"},149639.52272445985,1327.1636908332821,null,null,{"$f":"F18*G18","v":0},1327.1636908332821]
[{"$f":"'B. CurrentTariff'!A17","v":"Street Lighting "},{"$f":"'H. Rev_Reconciliation'!J19","v":6.9247617143185618},{"$f":"'B. CurrentTariff'!D17","v":"kW"},3007.3398175917232,20825.111630804931,null,null,{"$f":"F19*G19","v":0},20825.111630804931]
["Total Variable Revenue",null,null,{"$f":"SUM(D39:D43)","v":40949034.14783074},1015190.5894586153,-0.6,69011,-41406.6,973783.98945861531]
[]
[]
["2017 Rates at 2017 Load"]
[null,"Test Year Projected Revenue from Proposed Fixed Charges"]
["Customer Class Name","Fixed\nRate","Customers\n(Connections)","Fixed Charge Revenue","Variable Revenue","TOTAL","% Fixed\nRevenue","% Variable\nRevenue","% Total\nRevenue"]
[{"$f":"A15","v":"Residential"},{"$f":"'H. Rev_Reconciliation'!H15","v":17.91},3834.9876147687,{"$f":"B50*12*C50","v":824215.5381660891},{"$f":"I39","v":404332.56369593053},{"$f":"D50+E50","v":1228548.1018620196},{"$f":"IF(D50, ABS(D50/F50),\"\")","v":0.67088585047413807},{"$f":"IF(E50,ABS(E50/F50),\"\")","v":0.32911414952586188},{"$f":"IF(F50,ABS(F50/$F$55),\"\")","v":0.57181184156695741}]
[{"$f":"A16","v":"General Service < 50 kW"},{"$f":"'H. Rev_Reconciliation'!H16","v":31.25},413.64109259168799,{"$f":"B51*12*C51","v":155115.40972188298},{"$f":"I40","v":211960.15560389974},{"$f":"D51+E51","v":367075.56532578275},{"$f":"IF(D51, ABS(D51/F51),\"\")","v":0.42257078480344151},{"$f":"IF(E51,ABS(E51/F51),\"\")","v":0.57742921519655843},{"$f":"IF(F51,ABS(F51/$F$55),\"\")","v":0.17085057938312767}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},{"$f":"'H. Rev_Reconciliation'!H17","v":189.27},61,138545.64000000001,335338.99483714683,473884.63483714685,0.29236153657442809,0.70763846342557191,{"$f":"IF(F52,ABS(F52/$F$55),\"\")","v":0.22056348084850771}]
[{"$f":"A18","v":"Unmetered Scattered Load"},{"$f":"'H. Rev_Reconciliation'!H18","v":39.619999999999997},34.2271555401624,16272.95883001481,1327.1636908332821,17600.12252084809,0.92459349704746663,7.5406502952533455E-2,{"$f":"IF(F53,ABS(F53/$F$55),\"\")","v":8.1917496394296879E-3}]
[{"$f":"A19","v":"Street Lighting "},{"$f":"'H. Rev_Reconciliation'!H19","v":2.82},1199.30798221087,40584.582118015838,20825.111630804931,61409.69374882077,0.66088234023793957,0.33911765976206043,{"$f":"IF(F54,ABS(F54/$F$55),\"\")","v":2.8582348561977493E-2}]
["Total Fixed Revenue",null,{"$f":"SUM(C50:C54)","v":5543.1638451114204},{"$f":"SUM(D50:D54)","v":1174734.1288360027},{"$f":"SUM(E50:E54)","v":973783.98945861531},{"$f":"SUM(F50:F54)","v":2148518.1182946181}]

{"sheet":"RATEBASE & REV REQ ->","index":4,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Rate Base"]
[null,null,null,null,null,null,null,"&"]
[null,null,null,null,null,null,null,"Revenue Requirement"]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"D. Rate Base","index":5,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,1,8,3],[9,1,9,3],[11,2,11,3],[21,1,21,3],[23,2,23,3]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rate Base and Working Capital Allowance"]
[]
[null,"Particulars","Test Year 2014 (CGAAP)"]
[]
[null,"Test Year Net Fixed Asset Opening Balance",15495708.98]
[null,"Test Year Net Fixed Asset Closing Balance",-9556595.0500000007]
[null,"Average Balance",null,{"$f":"SUM(C14:C15)","v":5939113.9299999997}]
[]
[null,"Allowance for Working Capital",null,{"$f":"D31","v":994881.55012711952}]
[]
[null,"Total Rate Base",null,{"$f":"D16+D18","v":6933995.4801271195}]
[]
[null,"Allowance for Working Capital - Derivation"]
[]
[null,"Particulars","Test Year 2014 (CGAAP)",null,null,null," "," "]
[null,"Controllable Expenses",null,1549280]
[null,"Cost of Power/Power Supply Expense",null,11715807.335028261]
[null,"Working Capital Base",null,{"$f":"SUM(D25:D26)","v":13265087.335028261}]
[]
[null,"Working Capital Rate % ",null,7.4999999999999997E-2]
[]
[null,"Working Capital Allowance",null,{"$f":"D27*D29","v":994881.55012711952}]
[]
[null,null,null,null,null,null," "]

{"sheet":"E. Revenue Requirement","index":6,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,1,8,5],[9,1,9,2]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[null," "]
[null,"Distribution Revenue Requirement "]
[]
[null,"Particular","Test Year"]
[null,null," "]
[null,"OM&A Expenses",1549280]
[null,"Depreciation Expenses",247980.96000000002]
[null,"Property Taxes",0]
[null,"Total Distribution Expenses",{"$f":"SUM(C14:C16)","v":1797260.96}]
[]
[null,"Regulated Return On Capital",435760.01195310877]
[]
[null,"Grossed up PILs",23047.146341509921]
[null,"Service Revenue Requirement",{"$f":"C17+C19+C21","v":2256068.118294619}]
[]
[null,"Less: Revenue Offsets",-107550]
[]
[null,"Base Revenue Requirement",{"$f":"C22+C24","v":2148518.118294619}]

{"sheet":"COST ALLOC. & RATE DESIGN ->","index":7,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Cost Allocation"]
[null,null,null,null,null,null,null,"&"]
[null,null,null,null,null,null,null,"Rate Design"]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"F. Cost Allocation & RevAllocn","index":8,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[42,8,42,10],[40,0,40,3],[42,1,42,3],[42,5,42,6],[25,0,25,3],[27,1,27,6],[27,11,27,13],[28,1,28,2],[28,3,28,4],[28,5,28,6],[8,0,8,10],[9,0,9,10],[12,1,12,7],[12,8,12,10],[13,1,13,2],[13,3,13,4],[27,8,27,9],[13,5,13,6],[6,12,6,13],[0,12,0,13],[1,12,1,13],[2,12,2,13],[3,12,3,13],[4,12,4,13]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[]
["Cost Allocation Results and Revenue Allocation"]
[]
[]
["Cost Allocation Results","REVENUE ALLOCATION (sheet O1)",null,null,null,null,null,null,"CUSTOMER UNIT COST PER MONTH (sheet O2)"]
["Customer Class Name","Service Rev Req (row40)",null,"Misc. Revenue (mi) (row19)",null,"Base Rev Req (row80)",null,"Rev2Cost Expenses %","Avoided Costs\n(Minimum Charge)","Directly Related","Minimum System with PLCC * adjustment","Maximum Charge"]
[{"$f":"'B. CurrentTariff'!A13","v":"Residential"},1340506.6685747427,{"$f":"IF(B15,ABS(B15/$B$24),\"\")","v":0.59417823278214843},64906.685257473044,{"$f":"IF(D15,ABS(D15/$D$24),\"\")","v":0.60350241987422648},{"$f":"B15-D15","v":1275599.9833172697},{"$f":"IF(F15,ABS(F15/$F$24),\"\")","v":0.59371148491818249},0.9647466296054269,8.9455102936698445,14.283616454615341,20.875816275131893,{"$f":"MAX(J15,K15,'G. RateDesign'!B15)","v":20.875816275131893}]
[{"$f":"'B. CurrentTariff'!A14","v":"General Service < 50 kW"},316636.63385628455,{"$f":"IF(B16,ABS(B16/$B$24),\"\")","v":0.14034886953516509},14439.88599716373,{"$f":"IF(D16,ABS(D16/$D$24),\"\")","v":0.13426207342783572},302196.74785912083,{"$f":"IF(F16,ABS(F16/$F$24),\"\")","v":0.14065356087752404},1.1998041777957464,14.630440269812373,22.749356066227154,31.227922988154763,{"$f":"MAX(J16,K16,'G. RateDesign'!B16)","v":31.25}]
[{"$f":"'B. CurrentTariff'!A15","v":"General Service > 50 to 4999 kW"},548868.73195190751,0.24328551347477262,21993.51690432238,0.20449574062596357,526875.21504758508,0.24522724238283822,0.87449453714633618,50.380233129202274,78.715521552627379,106.73984241237923,{"$f":"MAX(J17,K17,'G. RateDesign'!B17)","v":189.27}]
[{"$f":"'B. CurrentTariff'!A16","v":"Unmetered Scattered Load"},8140.7535760600158,3.6083808359425517E-3,349.42367972218454,3.2489416989510424E-3,7791.3298963378311,3.6263735518500899E-3,2.7985006866129263,7.477097830080556,12.26974989967821,15.841918965402316,{"$f":"MAX(J18,K18,'G. RateDesign'!B18)","v":43.63}]
[{"$f":"'B. CurrentTariff'!A17","v":"Street Lighting "},41915.500335623576,1.8579003371971454E-2,5860.4881613186571,5.4490824373023321E-2,36055.012174304917,1.6781338269605095E-2,1.9122384049638184,0.48091944141156645,0.79005215693740405,2.383884995140511,{"$f":"MAX(J19,K19,'G. RateDesign'!B19)","v":2.95}]
[{"$f":"'B. CurrentTariff'!A18","v":"other classes"},null,"",null,"",0,"",null,null,null,null,{"$f":"MAX(J20,K20,'G. RateDesign'!B20)","v":0}]
[{"$f":"'B. CurrentTariff'!A19","v":"other classes"},null,"",null,"",0,"",null,null,null,null,{"$f":"MAX(J21,K21,'G. RateDesign'!B21)","v":0}]
[{"$f":"'B. CurrentTariff'!A20","v":"other classes"},null,"",null,"",0,"",null,null,null,null,{"$f":"MAX(J22,K22,'G. RateDesign'!B23)","v":0}]
[{"$f":"'B. CurrentTariff'!A21","v":"other classes"},null,"",null,"",0,"",null,null,null,null,{"$f":"MAX(J23,K23,'G. RateDesign'!B24)","v":0}]
["TOTAL",{"$f":"SUM(B15:B23)","v":2256068.288294618},1,107549.99999999999,1,2148518.2882946185,1]
[" "," "," "," "," "," "," "," "]
["Revenue Reallocation - Service Revenue Requirement"]
[]
[null,"Proposed Base Revenue Requirement %",null,null,null,null,null,null,"Revenue Offsets ",null,null,"Service Revenue Requirement $ "]
["Customer Class Name","Cost Allocation Results",null,"Existing Rates ",null,"Proposed Allocation",null,null,"%","$",null,"Existing\nRates","Cost Allocation","Rate Application"]
[{"$f":"A15","v":"Residential"},{"$f":"G15","v":0.59371148491818249},{"$f":"'E. Revenue Requirement'!$C$26*B30","v":1275599.8823863175},{"$f":"'C. Revenues at Curr Rates'!I26","v":0.57171615057026282},{"$f":"D30*'E. Revenue Requirement'!$C$26","v":1228342.5080218641},0.57181184156695752,{"$f":"'E. Revenue Requirement'!$C$26*F30","v":1228548.1018620203},null,{"$f":"E15","v":0.60350241987422648},{"$f":"D15","v":64906.685257473044},null,{"$f":"E30+J30","v":1293249.1932793371},{"$f":"C30+J30","v":1340506.5676437905},{"$f":"G30+J30","v":1293454.7871194934}]
[{"$f":"A16","v":"General Service < 50 kW"},0.14065356087752404,{"$f":"'E. Revenue Requirement'!$C$26*B31","v":302196.7239480156},{"$f":"'C. Revenues at Curr Rates'!I27","v":0.17009958543889023},{"$f":"D31*'E. Revenue Requirement'!$C$26","v":365462.04122985923},0.17085057938312764,{"$f":"'E. Revenue Requirement'!$C$26*F31","v":367075.56532578281},null,0.13426207342783572,14439.88599716373,null,379901.92722702294,316636.60994517931,381515.45132294652]
["General Service > 50 to 4999 kW",0.24522724238283822,{"$f":"'E. Revenue Requirement'!$C$26*B32","v":526875.17335895402},{"$f":"'C. Revenues at Curr Rates'!I28","v":0.21316513491797429},{"$f":"D32*'E. Revenue Requirement'!$C$26","v":457989.15455998469},{"$f":"1-SUM(F30+F31+F33+F34+F35)","v":0.22056348084850763},{"$f":"'E. Revenue Requirement'!$C$26*F32","v":473884.63483714685},null,0.20449574062596357,21993.51690432238,null,479982.67146430706,548868.69026327645,495878.15174146922]
["Unmetered Scattered Load",3.6263735518500899E-3,{"$f":"'E. Revenue Requirement'!$C$26*B33","v":7791.3292798543289},{"$f":"'C. Revenues at Curr Rates'!I29","v":1.0440907538298939E-2},{"$f":"D33*'E. Revenue Requirement'!$C$26","v":22432.479017474139},8.1917496394296758E-3,{"$f":"'E. Revenue Requirement'!$C$26*F33","v":17600.122520848072},null,3.2489416989510424E-3,349.42367972218454,null,22781.902697196325,8140.7529595765136,17949.546200570257]
["Street Lighting ",1.6781338269605095E-2,{"$f":"'E. Revenue Requirement'!$C$26*B34","v":36055.009321477417},{"$f":"'C. Revenues at Curr Rates'!I30","v":3.4578221534573787E-2},{"$f":"D34*'E. Revenue Requirement'!$C$26","v":74291.935465436953},2.8582348561977482E-2,{"$f":"'E. Revenue Requirement'!$C$26*F34","v":61409.69374882077},null,5.4490824373023321E-2,5860.4881613186571,null,80152.423626755612,41915.497482796076,67270.181910139421]
["other classes","",null,null,null,null,null,null,""]
["other classes"]
["other classes"]
["other classes"]
["TOTAL",{"$f":"SUM(B30:B38)","v":1},2148518.1182946186,1,2148518.118294619,1,2148518.118294619,null,{"$f":"SUM(I30:I38)","v":1},{"$f":"SUM(J30:J38)","v":107549.99999999999},null,{"$f":"SUM(L30:L38)","v":2256068.1182946195},{"$f":"SUM(M30:M38)","v":2256068.118294619},{"$f":"SUM(N30:N38)","v":2256068.1182946186}]
[]
["Revenue to Cost Ratio Allocation"]
[]
[null,null,null,null,null,"Target Range",null,null,"Revenue to Cost Adjustment",null,null,null,"Bill Impacts"]
["Customer Class Name","Calculated R/C Ratio ","Proposed R/C Ratio ","Variance",null,"Floor","Celiling",null,2017,2018,20.190000000000001,null," "]
[{"$f":"A15","v":"Residential"},{"$f":"H15","v":0.9647466296054269},{"$f":"N30/M30","v":0.96489999999999987},{"$f":"B45-C45","v":-1.5337039457297141E-4},null,0.85,1.1499999999999999,null,null,null,null,null,{"$f":"'Bill Impact - Residential'!O67","v":2.9266189119806552E-2}]
[{"$f":"A16","v":"General Service < 50 kW"},1.1998041777957464,1.2048999999999999,-5.0958222042534196E-3,null,0.8,1.2,null,null,null,null,null,{"$f":"'Bill Impact - GS<50'!O67","v":1.9445735914391239E-2}]
["General Service > 50 to 4999 kW",0.87449453714633618,0.90345498028610594,-2.8960443139769754E-2,null,0.8,1.2,null,null,null,null,null,{"$f":"'Bill Impact - GS>50'!O73","v":-3.6908330715122099E-4}]
["Unmetered Scattered Load",2.7985006866129263,2.2049000000000003,0.59360068661292598,null,0.8,1.2,null,2.2000000000000002,1.6,1.2,null,{"$f":"'Bill Impact - USL'!O73","v":1.1198198833594134E-2}]
["Street Lighting ",1.9122384049638184,1.6049,0.30733840496381837,null,0.8,1.2,null,1.6,1.2,null,null,{"$f":"'Bill Impact - StreetLight'!O73","v":-5.209299700899242E-2}]
["other classes",null,null,null,null,0.8,1.2]
["other classes"]
["other classes"]
["other classes"]

{"sheet":"G. RateDesign","index":9,"n_rows":79,"n_cols":10,"rows_kept":79,"cut":false,"hidden":false,"merged":[[8,0,8,7],[9,0,9,7],[12,1,12,3],[43,5,43,7]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[]
["Rate Design"]
[]
["Existing Rates"]
[null,"Current Rates and Fixed to Variable Split",null,null,null,null," Proposed Rates at Current Fixed to Variable Split"]
["Customer Class Name","Rate","Fixed %","Variable %",null,"Rate","Fixed %","Variable %"]
[{"$f":"'B. CurrentTariff'!$A$13","v":"Residential"},{"$f":"'C. Revenues at Curr Rates'!B26","v":13.97},{"$f":"'C. Revenues at Curr Rates'!G26","v":0.605154571714972},{"$f":"'C. Revenues at Curr Rates'!H26","v":0.39484542828502794},null,16.155234712068133,{"$f":"C15","v":0.605154571714972},{"$f":"1-G15","v":0.394845428285028}]
[{"$f":"'B. CurrentTariff'!$A$14","v":"General Service < 50 kW"},{"$f":"'C. Revenues at Curr Rates'!B27","v":31.25},{"$f":"'C. Revenues at Curr Rates'!G27","v":0.49074609303513855},{"$f":"'C. Revenues at Curr Rates'!H27","v":0.5092539069648615},null,36.291707706394135,0.49074609303513855,0.50925390696486139]
[{"$f":"'B. CurrentTariff'!$A$15","v":"General Service > 50 to 4999 kW"},{"$f":"'C. Revenues at Curr Rates'!B28","v":189.27},{"$f":"'C. Revenues at Curr Rates'!G28","v":0.3497694317008746},{"$f":"'C. Revenues at Curr Rates'!H28","v":0.65023056829912551},null,227.2546083468678,0.3497694317008746,0.6502305682991254]
[{"$f":"'B. CurrentTariff'!$A$16","v":"Unmetered Scattered Load"},{"$f":"'C. Revenues at Curr Rates'!B29","v":43.63},{"$f":"'C. Revenues at Curr Rates'!G29","v":0.92364307670436097},{"$f":"'C. Revenues at Curr Rates'!H29","v":7.6356923295638951E-2},null,39.579273287002245,0.92364307670436097,7.6356923295639034E-2]
[{"$f":"'B. CurrentTariff'!$A$17","v":"Street Lighting "},{"$f":"'C. Revenues at Curr Rates'!B30","v":2.95},{"$f":"'C. Revenues at Curr Rates'!G30","v":0.66074897093960916},{"$f":"'C. Revenues at Curr Rates'!H30","v":0.3392510290603909},null,2.819430910166012,0.66074897093960916,0.33925102906039084]
[{"$f":"'B. CurrentTariff'!$A$18","v":"other classes"},null," "," "]
[{"$f":"'B. CurrentTariff'!$A$19","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$20","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$21","v":"other classes"}]
["TOTAL"]
[]
[]
["Cost Allocation Results - Minimum and Maximum MSC"]
[null,null,"Cost Allocation - Minimum Fixed Rate (b)",null,null,null,"Cost Allocation - Maximun Fixed Rate (b)",null,null,"Minimum System with PLCC * adjustment"]
["Customer Class Name","Rate","Fixed %","Variable %",null,"Rate","Fixed %","Variable %"]
[{"$f":"'B. CurrentTariff'!$A$13","v":"Residential"},{"$f":"'F. Cost Allocation & RevAllocn'!I15","v":8.9455102936698445},0.33508745289189573,{"$f":"1-C30","v":0.66491254710810432},null,{"$f":"'F. Cost Allocation & RevAllocn'!L15","v":20.875816275131893},0.78198156092036386,{"$f":"1-G30","v":0.21801843907963614},null,20.875816275131893]
[{"$f":"'B. CurrentTariff'!$A$14","v":"General Service < 50 kW"},{"$f":"'F. Cost Allocation & RevAllocn'!I16","v":14.630440269812373},0.19783669205870369,0.80216330794129631,null,{"$f":"'F. Cost Allocation & RevAllocn'!L16","v":31.25},0.42257078480344162,0.57742921519655832,null,31.227922988154763]
[{"$f":"'B. CurrentTariff'!$A$15","v":"General Service > 50 to 4999 kW"},{"$f":"'F. Cost Allocation & RevAllocn'!I17","v":50.380233129202274},7.7540630039335909E-2,0.92245936996066413,null,{"$f":"'F. Cost Allocation & RevAllocn'!L17","v":189.27},0.29130700943577575,0.7086929905642243,null,106.73984241237923]
[{"$f":"'B. CurrentTariff'!$A$16","v":"Unmetered Scattered Load"},{"$f":"'F. Cost Allocation & RevAllocn'!I18","v":7.477097830080556},0.17448955150126716,0.82551044849873279,null,{"$f":"'F. Cost Allocation & RevAllocn'!L18","v":43.63},1.0181730004084042,-1.8173000408404194E-2,null,15.841918965402316]
[{"$f":"'B. CurrentTariff'!$A$17","v":"Street Lighting "},{"$f":"'F. Cost Allocation & RevAllocn'!I19","v":0.48091944141156645},0.11270608720070875,0.88729391279929126,null,{"$f":"'F. Cost Allocation & RevAllocn'!L19","v":2.95},0.69134854741202911,0.30865145258797089,null,2.383884995140511]
[{"$f":"'B. CurrentTariff'!$A$18","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$19","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$20","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$21","v":"other classes"}]
["TOTAL"]
[]
[]
[]
["Rate Design"]
[null,null,"Proposed Fixed Charge",null,null,"Resulting Variable",null,null,null,"Bill Impacts"]
["Customer Class Name","Fixed Rate","Fixed %","Variable %",null,"Variable (h)","Rate (i)","per",null,{"$f":"'Bill Impact - Res 10 Pct'!O73","v":8.8525502294450178E-2}]
[{"$f":"'B. CurrentTariff'!$A$13","v":"Residential"},{"$f":"'I. Res Rate Design'!D43","v":17.91},{"$f":"G61/F61","v":0.67088585047413829},{"$f":"1-C46","v":0.32911414952586171},null,{"$f":"H61+D61","v":404332.56369593053},1.3976689220655134E-2,{"$f":"'B. CurrentTariff'!D13","v":"kWh"},null,{"$f":"'Bill Impact - Residential'!O67","v":2.9266189119806552E-2}]
[{"$f":"'B. CurrentTariff'!$A$14","v":"General Service < 50 kW"},31.25,0.42257078480344162,0.57742921519655832,null,211960.15560389977,1.8040240945143494E-2,{"$f":"'B. CurrentTariff'!D14","v":"kWh"},null,{"$f":"'Bill Impact - GS<50'!O67","v":1.9445735914391239E-2}]
[{"$f":"'B. CurrentTariff'!$A$15","v":"General Service > 50 to 4999 kW"},189.27,0.29236153657442809,0.70763846342557191,null,376745.59483714681,3.1921101160778975,{"$f":"'B. CurrentTariff'!D15","v":"kW"},null,{"$f":"'Bill Impact - GS>50'!O73","v":-3.6908330715122099E-4}]
[{"$f":"'B. CurrentTariff'!$A$16","v":"Unmetered Scattered Load"},39.619999999999997,0.92459349704746652,7.5406502952533483E-2,null,1327.1636908332821,8.8690719314647067E-3,{"$f":"'B. CurrentTariff'!D16","v":"kWh"},null,{"$f":"'Bill Impact - GS>50'!O74","v":0}]
[{"$f":"'B. CurrentTariff'!$A$17","v":"Street Lighting "},2.82,0.66088234023793957,0.33911765976206043,null,20825.111630804931,6.9247617143185618,{"$f":"'B. CurrentTariff'!D17","v":"kW"},null,{"$f":"'Bill Impact - StreetLight'!O73","v":-5.209299700899242E-2}]
[{"$f":"'B. CurrentTariff'!$A$18","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$19","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$20","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$21","v":"other classes"}]
["TOTAL",null,null,null,null,null," "," "]
[]
[]
[]
[null,null,"Transf. Allowance ($/kW):",-0.60000000000000009,null,null,"Base Revenue Requirement $"]
["Customer Class Name","kW","Rate","Total $ (g)",null,"Total (d)","Fixed ","Variable"]
[{"$f":"'B. CurrentTariff'!$A$13","v":"Residential"},{"$f":"'C. Revenues at Curr Rates'!G15","v":0},{"$f":"IF(B61=0,0,-D$59)","v":0},{"$f":"B61*C61","v":0},null,{"$f":"'F. Cost Allocation & RevAllocn'!G30","v":1228548.1018620203},824215.5381660898,{"$f":"F61-G61","v":404332.56369593053}]
[{"$f":"'B. CurrentTariff'!$A$14","v":"General Service < 50 kW"},{"$f":"'C. Revenues at Curr Rates'!G16","v":0},{"$f":"IF(B62=0,0,-D$59)","v":0},0,null,{"$f":"'F. Cost Allocation & RevAllocn'!G31","v":367075.56532578281},155115.40972188304,211960.15560389977]
[{"$f":"'B. CurrentTariff'!$A$15","v":"General Service > 50 to 4999 kW"},{"$f":"'C. Revenues at Curr Rates'!G17","v":69011},0.60000000000000009,41406.600000000006,null,{"$f":"'F. Cost Allocation & RevAllocn'!G32","v":473884.63483714685},{"$f":"B48*12*'C. Revenues at Curr Rates'!C28","v":138545.64000000001},335338.99483714683]
[{"$f":"'B. CurrentTariff'!$A$16","v":"Unmetered Scattered Load"},{"$f":"'C. Revenues at Curr Rates'!G18","v":0},{"$f":"IF(B64=0,0,-D$59)","v":0},0,null,{"$f":"'F. Cost Allocation & RevAllocn'!G33","v":17600.122520848072},16272.95883001479,1327.1636908332821]
[{"$f":"'B. CurrentTariff'!$A$17","v":"Street Lighting "},{"$f":"'C. Revenues at Curr Rates'!G19","v":0},{"$f":"IF(B65=0,0,-D$59)","v":0},0,null,{"$f":"'F. Cost Allocation & RevAllocn'!G34","v":61409.69374882077},40584.582118015838,20825.111630804931]
[{"$f":"'B. CurrentTariff'!$A$18","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$19","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$20","v":"other classes"}]
[{"$f":"'B. CurrentTariff'!$A$21","v":"other classes"}]
["TOTAL",{"$f":"SUM(B61:B69)","v":69011},null,{"$f":"SUM(D61:D69)","v":41406.600000000006},null,{"$f":"SUM(F61:F69)","v":2148518.118294619},{"$f":"SUM(G61:G69)","v":1174734.1288360034},{"$f":"SUM(H61:H69)","v":973783.98945861531}]
[null,null,null,"Integrity Check",null,{"$f":"'E. Revenue Requirement'!C26","v":2148518.118294619}]
["Notes:"]
["Rows 15-23 show the current and proposed rates at the existing fixed to variable split"]
["Rows 30-38 show the minimum and maximum MSC results from the Cost Allocation Study."]
["At B46-B54, LDCs should use the proposed MSC at existing fixed to variable split (F15-F23) as a starting point to the Rate Design adjustment."]
["Values at F15-F23 should be copied to B46-B54"]
["Utilities should then use the Minimum and Maximum Cost Allocation results (rows 30-38) to determine wheter further adjustement are required at row B46-B54"]
["The variable charge is automatically calculated depending on the selected MSC"]
["Rows 60-69 act as an integrity check between the fixed and variable charge to the base revenue requirement."]

{"sheet":"H. Rev_Reconciliation","index":10,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[11,12,12,12],[12,8,12,9],[24,0,25,15],[26,0,27,15],[8,0,8,17],[9,0,9,17],[11,1,12,1],[11,2,11,4],[11,5,11,6],[11,7,11,9],[11,11,12,11],[11,14,12,14],[11,15,12,15],[11,16,12,16],[11,17,12,17],[11,10,12,10]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
["Appendix 2-V"]
["Revenue Reconciliation"]
[]
[null,"Customers/ Connections","Number of Customers/Connections",null,null,"Test Year Consumption",null,"Proposed Rates",null,null,"Revenues at Proposed Rates","Revenues at Proposed Rates","Total",null,"Class Specific Revenue Requirement","Transformer Allowance Credit","Total","Difference"]
[null,null,"Start of Test Year","End of Test Year","Average","kWh","kW","Monthly Service Charge","Volumetric"]
[null,null,null,null,null,null,null,null,"kWh","kW"]
[{"$f":"'B. CurrentTariff'!$A$13","v":"Residential"},"kWh",{"$f":"'C. Revenues at Curr Rates'!C26","v":3834.9876147687037},{"$f":"C15","v":3834.9876147687037},{"$f":"IF(SUM(C15:D15)=0,0,AVERAGE(C15:D15))","v":3834.9876147687037},28929065.912004169,0,{"$f":"'G. RateDesign'!B46","v":17.91},{"$f":"'G. RateDesign'!G46","v":1.3976689220655134E-2},null,{"$f":"H15*E15*12","v":824215.5381660898},{"$f":"I15*F15+J15*G15","v":404332.56369593053},{"$f":"K15+L15","v":1228548.1018620203},null,{"$f":"'G. RateDesign'!F61","v":1228548.1018620203},null,{"$f":"SUM(O15:P15)","v":1228548.1018620203},{"$f":"Q15-M15","v":0}]
[{"$f":"'B. CurrentTariff'!$A$14","v":"General Service < 50 kW"},"kWh",{"$f":"'C. Revenues at Curr Rates'!C27","v":413.64109259168811},413.64109259168811,413.64109259168811,11749297.376261501,0,{"$f":"'G. RateDesign'!B47","v":31.25},{"$f":"'G. RateDesign'!G47","v":1.8040240945143494E-2},null,155115.40972188304,211960.15560389974,367075.56532578275,null,{"$f":"'G. RateDesign'!F62","v":367075.56532578281},null,367075.56532578281,0]
[{"$f":"'B. CurrentTariff'!$A$15","v":"General Service > 50 to 4999 kW"},"kW",{"$f":"'C. Revenues at Curr Rates'!C28","v":61},61,61,43433993.545669392,118023.99702302532,{"$f":"'G. RateDesign'!B48","v":189.27},null,{"$f":"'G. RateDesign'!G48","v":3.1921101160778975},138545.64000000001,376745.59483714681,515291.23483714683,null,{"$f":"'G. RateDesign'!F63","v":473884.63483714685},{"$f":"'G. RateDesign'!D63","v":41406.600000000006},515291.23483714683,0]
[{"$f":"'B. CurrentTariff'!$A$16","v":"Unmetered Scattered Load"},"kWh",{"$f":"'C. Revenues at Curr Rates'!C29","v":34.227155540162357},34.227155540162357,34.227155540162357,149639.52272445985,0,{"$f":"'G. RateDesign'!B49","v":39.619999999999997},{"$f":"'G. RateDesign'!G49","v":8.8690719314647067E-3},null,16272.95883001479,{"$f":"I18*F18+J18*G18","v":1327.1636908332821},{"$f":"K18+L18","v":17600.122520848072},null,{"$f":"'G. RateDesign'!F64","v":17600.122520848072},null,17600.122520848072,0]
[{"$f":"'B. CurrentTariff'!$A$17","v":"Street Lighting "},"kW",{"$f":"'C. Revenues at Curr Rates'!C30","v":1199.30798221087},1199.30798221087,1199.30798221087,1082279.2807475766,3007.3398175917232,{"$f":"'G. RateDesign'!B50","v":2.82},null,{"$f":"'G. RateDesign'!G50","v":6.9247617143185618},40584.582118015838,20825.111630804931,61409.69374882077,null,{"$f":"'G. RateDesign'!F65","v":61409.69374882077},null,61409.69374882077,0]
[]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K15:K19)","v":1174734.1288360034},{"$f":"SUM(L15:L19)","v":1015190.5894586153},{"$f":"SUM(M15:M19)","v":2189924.7182946187},null,{"$f":"SUM(O15:O19)","v":2148518.118294619},{"$f":"SUM(P15:P19)","v":41406.600000000006},{"$f":"O21+P21","v":2189924.7182946191},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Note"]
[]
["1       The class specific revenue requirements in column N must be the amounts used in the final rate design process.  The total of column N should equate to the proposed base revenue requirement."]
[]
["2       Rates should be entered with the number of decimal places that will show on the Tariff of Rates and Charges."]

{"sheet":"I. Res Rate Design","index":11,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[53,0,54,4],[56,0,58,4],[59,0,60,4],[8,0,8,5],[9,0,9,5],[15,0,15,1],[21,0,21,1],[46,0,46,1],[48,0,49,0]]}
[null,null,null,null,"File Number:",0]
[null,null,null,null,"Exhibit:"]
[null,null,null,null,"Tab:"]
[null,null,null,null,"Schedule:"]
[null,null,null,null,"Page:"]
[]
[null,null,null,null,"Date:"]
[]
[]
["New Rate Design Policy For Residential Customers"]
[]
["Please complete the following tables."]
[]
["A)  Data Inputs"]
[]
["Test Year Billing Determinants for Residential Class"]
["Customers",3834.9876147687037]
["kWh",28929065.912004169]
[]
["Proposed Residential Class Specific Revenue Requirement1",{"$f":"'F. Cost Allocation & RevAllocn'!G30","v":1228548.1018620203}]
[]
["Residential Base Rates on Current Tariff"]
["Monthly Fixed Charge ($)",{"$f":"'C. Revenues at Curr Rates'!B26","v":13.97}]
["Distribution Volumetric Rate ($/kWh)",{"$f":"'C. Revenues at Curr Rates'!B15","v":1.4500000000000001E-2}]
[]
["B) Current Fixed/Variable Split"]
[]
[null,"Base Rates","Billing Determinants","Revenue","% of Total Revenue"]
["Fixed",{"$f":"IF(B23=\"\",\"\",B23)","v":13.97},{"$f":"IF(B17=\"\",\"\",B17)","v":3834.9876147687037},{"$f":"IF(ISERROR(B29*C29*12),\"\",B29*C29*12)","v":642897.32373982552},{"$f":"IF(ISERROR(D29/D31),\"\",D29/D31)","v":0.605154571714972}]
["Variable",{"$f":"IF(B24=\"\",\"\",B24)","v":1.4500000000000001E-2},{"$f":"IF(B18=\"\",\"\",B18)","v":28929065.912004169},{"$f":"IF(ISERROR(B30*C30),\"\",B30*C30)","v":419471.45572406048},{"$f":"IF(ISERROR(D30/D31),\"\",D30/D31)","v":0.39484542828502794}]
["TOTAL","-","-",{"$f":"IF(ISERROR(D29+D30),\"\",D29+D30)","v":1062368.7794638861},"-"]
[]
["C) Calculating Test Year Base Rates"]
[]
["Number of Required Rate Design Policy Transition Years2",6]
[]
[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"]
["Fixed",{"$f":"IF(ISERROR(B$20*E29),\"\",B$20*E29)","v":743461.50041355274},{"$f":"IF(ISERROR(ROUND(B38/B17/12,2)),\"\",ROUND(B38/B17/12,2))","v":16.16},{"$f":"IF(ISERROR(C38*B17*12),\"\",C38*B17*12)","v":743680.79825594707}]
["Variable",{"$f":"IF(ISERROR(B$20*E30),\"\",B$20*E30)","v":485086.60144846753},{"$f":"IF(ISERROR(ROUND(B39/B18,4)),\"\",ROUND(B39/B18,4))","v":1.6799999999999999E-2},{"$f":"IF(ISERROR(C39*B18),\"\",C39*B18)","v":486008.30732167}]
["TOTAL",{"$f":"IF(ISERROR(B38+B39),\"\",B38+B39)","v":1228548.1018620203},"-",{"$f":"IF(ISERROR(D38+D39),\"\",D38+D39)","v":1229689.105577617}]
[]
[null,"New F/V Split","Revenue @ new\n F/V Split","Final Adjusted \nBase Rates","Revenue Reconciliation @ Adjusted Rates",null,"Integrety Check with 8.1 RateDesign"]
["Fixed",{"$f":"IF(ISERROR(((1-E29)/B35)+E29),\"\",((1-E29)/B35)+E29)","v":0.67096214309581004},{"$f":"IF(ISERROR(B43*B$20),\"\",B43*B$20)","v":824309.26732163073},{"$f":"IF(ISERROR(ROUND(C43/B17/12,2)),\"\",ROUND(C43/B17/12,2))","v":17.91},{"$f":"IF(ISERROR(D43*12*B17),\"\",D43*12*B17)","v":824215.5381660898},null,{"$f":"'G. RateDesign'!G61","v":824215.5381660898}]
["Variable",{"$f":"IF(ISERROR(1-B43),\"\",1-B43)","v":0.32903785690418996},{"$f":"IF(ISERROR(B44*B$20),\"\",B44*B$20)","v":404238.83454038965},{"$f":"IF(ISERROR(ROUND(C44/B18,4)),\"\",ROUND(C44/B18,4))","v":1.4E-2},{"$f":"IF(ISERROR(D44*B18),\"\",D44*B18)","v":405006.92276805837},null,{"$f":"'G. RateDesign'!H61","v":404332.56369593053}]
["TOTAL","-",{"$f":"IF(ISERROR(SUM(C43:C44)),\"\",SUM(C43:C44))","v":1228548.1018620203},"-",{"$f":"IF(ISERROR(E43+E44),\"\",E43+E44)","v":1229222.4609341482},null,{"$f":"SUM(G43:G44)","v":1228548.1018620203}]
[]
["Checks3"]
["Change in Fixed Rate",{"$f":"IF(ISERROR(D43-C38),\"\",D43-C38)","v":1.75}]
["Difference Between Revenues @ Proposed Rates and Class Specific Revenue Requirement",{"$f":"IF(ISERROR((D43*12*B17)+(D44*B18)-B20),\"\",(D43*12*B17)+(D44*B18)-B20)","v":674.35907212784514}]
[null,{"$f":"IF(ISERROR(B49/B20), \"\", B49/B20)","v":5.4890734119874391E-4}]
[]
["Notes:"]
[]
["1     The final residential class specific revenue requirement, as shown in Appendix 2-P, should be used (i.e. the revenue requirement after any proposed adjustments to R/C ratios)."]
[]
[]
["2     Default number of transition years for rate design policy change is 4. Where the change in the residential rate design will result in the fixed charge increasing by more than $4/year, a distributor may propose an additional transition year."]
[]
[]
["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":"J. Cost Allocation","index":12,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[8,0,8,4],[9,0,9,4]]}
[null,null,null,null,"File Number:",{"$f":"EBNUMBER","v":{"$error":"#NAME?"}}]
[null,null,null,null,"Exhibit:"]
[null,null,null,null,"Tab:"]
[null,null,null,null,"Schedule:"]
[null,null,null,null,"Page:"]
[]
[null,null,null,null,"Date:"]
[]
["Appendix 2-P"]
["Cost Allocation"]
[]
["Please complete the following four tables."]
[]
["A)  Allocated Costs"]
[]
["Classes","Costs Allocated from Previous Study","%","Costs Allocated in Test Year Study                    (Column 7A)","%"]
["Residential",1061717.5352243828,{"$f":"IF(B$23=0,\"\",B17/B$23)","v":0.57179692664541182},{"$f":"'F. Cost Allocation & RevAllocn'!B15","v":1340506.6685747427},{"$f":"IF(D$23=0,\"\",D17/D$23)","v":0.59417823278214843}]
["General Service < 50 kW",315830.87935246178,0.1700933818666652,{"$f":"'F. Cost Allocation & RevAllocn'!B16","v":316636.63385628455},0.14034886953516509]
["General Service > 50 to 4999 kW",395641.47068143816,0.21307604846265119,{"$f":"'F. Cost Allocation & RevAllocn'!B17","v":548868.73195190751},0.24328551347477262]
["Unmetered Scattered Load",19399.100855240707,1.0447549259292178E-2,{"$f":"'F. Cost Allocation & RevAllocn'!B18","v":8140.7535760600158},3.6083808359425517E-3]
["Street Lighting ",64219.761448677295,3.4586093765979535E-2,{"$f":"'F. Cost Allocation & RevAllocn'!B19","v":41915.500335623576},1.8579003371971454E-2]
[" ",null,0,null,0]
["Total",{"$f":"SUM(B17:B22)","v":1856808.7475622008},{"$f":"SUM(C17:C22)","v":0.99999999999999989},{"$f":"SUM(D17:D22)","v":2256068.288294618},{"$f":"SUM(E17:E22)","v":1}]
[]
[]
[]
["B)  Calculated Class Revenues"]
[null,null,"(from CA - O1 row 18)"]
[null,null,"Column 7B","Column 7C","Column 7D","Column 7E"]
["Classes (same as previous table)",null,"Load Forecast (LF) X current approved rates","L.F. X current approved rates X (1 + d)","LF X proposed rates","Miscellaneous Revenue"]
[]
[{"$f":"A17","v":"Residential"},null,1061717.5352243828,{"$f":"'F. Cost Allocation & RevAllocn'!E30","v":1228342.5080218641},{"$f":"'F. Cost Allocation & RevAllocn'!G30","v":1228548.1018620203},{"$f":"'F. Cost Allocation & RevAllocn'!J30","v":64906.685257473044}]
["General Service < 50 kW",null,315830.87935246178,{"$f":"'F. Cost Allocation & RevAllocn'!E31","v":365462.04122985923},{"$f":"'F. Cost Allocation & RevAllocn'!G31","v":367075.56532578281},{"$f":"'F. Cost Allocation & RevAllocn'!J31","v":14439.88599716373}]
["General Service > 50 to 4999 kW",null,395641.47068143816,{"$f":"'F. Cost Allocation & RevAllocn'!E32","v":457989.15455998469},{"$f":"'F. Cost Allocation & RevAllocn'!G32","v":473884.63483714685},{"$f":"'F. Cost Allocation & RevAllocn'!J32","v":21993.51690432238}]
["Unmetered Scattered Load",null,19399.100855240707,{"$f":"'F. Cost Allocation & RevAllocn'!E33","v":22432.479017474139},{"$f":"'F. Cost Allocation & RevAllocn'!G33","v":17600.122520848072},{"$f":"'F. Cost Allocation & RevAllocn'!J33","v":349.42367972218454}]
["Street Lighting ",null,64219.761448677295,{"$f":"'F. Cost Allocation & RevAllocn'!E34","v":74291.935465436953},{"$f":"'F. Cost Allocation & RevAllocn'!G34","v":61409.69374882077},{"$f":"'F. Cost Allocation & RevAllocn'!J34","v":5860.4881613186571}]
[" "]
["Total",null,{"$f":"SUM(C32:C37)","v":1856808.7475622008},{"$f":"SUM(D32:D37)","v":2148518.118294619},{"$f":"SUM(E32:E37)","v":2148518.118294619},{"$f":"SUM(F32:F37)","v":107549.99999999999}]
[]
[]
["C)  Rebalancing Revenue-to-Cost (R/C) Ratios"]
[]
["Class",null,"Previously Approved Ratios","Status Quo Ratios","Proposed Ratios","Policy Range"]
[null,null,"Most Recent Year:","(7C + 7E) / (7A)","(7D + 7E) / (7A)"]
[null,null,2010]
[null,null,"%","%","%","%"]
[{"$f":"A32","v":"Residential"},null,107,{"$f":"IF(D17=0,\"\",(D32+F32)/D17*100)","v":96.474655710168847},{"$f":"IF(D17=0,\"\",(E32+F32)/D17*100)","v":96.489992734965199},"85 - 115"]
["General Service < 50 kW",null,88,119.98040864704662,120.48999090108734,"80 - 120"]
["General Service > 50 to 4999 kW",null,103,87.449447112313123,90.34549116653244,"80 - 120"]
["Unmetered Scattered Load",null,70,279.85004685797617,220.48998330271937,"80 - 120"]
["Street Lighting ",null,70,191.22382647221997,160.48998907682645,"85 - 115"]
[" ",null,null,"",""]
[]
[]
["D)  Proposed Revenue-to-Cost Ratios"]
[]
["Class",null,"Proposed Revenue-to-Cost Ratios",null,null,"Policy Range"]
[null,null,2017,{"$f":"C58+1","v":2018},{"$f":"D58+1","v":2019}]
[null,null,"%","%","%","%"]
[{"$f":"A47","v":"Residential"},null,{"$f":"E47","v":96.489992734965199},null,null,{"$f":"F47","v":"85 - 115"}]
[{"$f":"A48","v":"General Service < 50 kW"},null,{"$f":"E48","v":120.48999090108734},null,null,{"$f":"F48","v":"80 - 120"}]
[{"$f":"A49","v":"General Service > 50 to 4999 kW"},null,{"$f":"E49","v":90.34549116653244},null,null,{"$f":"F49","v":"80 - 120"}]
[{"$f":"A50","v":"Unmetered Scattered Load"},null,{"$f":"E50","v":220.48998330271937},1.6,1.2,{"$f":"F50","v":"80 - 120"}]
[{"$f":"A51","v":"Street Lighting "},null,{"$f":"E51","v":160.48998907682645},1.2,null,{"$f":"F51","v":"85 - 115"}]
[{"$f":"A52","v":" "},null,{"$f":"E52","v":""}]
[]
["Note"]

{"sheet":"RATE RIDERS ->","index":13,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Rate Riders"]
[]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"K. SMRR","index":14,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,0,8,8],[9,0,9,8]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
[" "]
["Stranded Meter Rate Rider"]
[]
["Customer Class Name","Net Book Value","% share","Annual $","Customer ","Rate ","per month"]
["Residential",{"$f":"$D$19*C13","v":31323.78},0.56999999999999995,{"$f":"$D$21*C13","v":6264.7559999999994},3834.9876147687037,{"$f":"D13/E13","v":1.6335792000668143},{"$f":"F13/12","v":0.13613160000556787}]
["General Service < 50 kW",{"$f":"$D$19*C14","v":6044.94},0.11,{"$f":"$D$21*C14","v":1208.9879999999998},413.64109259168811,{"$f":"D14/E14","v":2.9227947166105466},{"$f":"F14/12","v":0.24356622638421221}]
["General Service > 50 to 4999 kW",{"$f":"$D$19*C15","v":17585.28},0.32,{"$f":"$D$21*C15","v":3517.056},60.779977365656592,{"$f":"D15/E15","v":57.86537199316718},{"$f":"F15/12","v":4.822114332763932}]
[null,null,1]
[null,"TOTAL",{"$f":"SUM(C13:C15)","v":1}]
[]
["Total for Recovery",null,null,54954]
["Recovery Period (years)",null,5]
["Annual Recovery",null,null,{"$f":"D19/C20","v":10990.8}]
[]
["(1) The utility used the 2010 Cost Allocation model - Meter Capital, as a basis for the allocation "]

{"sheet":"L. DVA","index":15,"n_rows":201,"n_cols":7,"rows_kept":201,"cut":false,"hidden":false,"merged":[[8,0,8,10],[43,1,44,1],[43,2,44,2],[43,3,44,3],[43,4,44,4],[43,5,44,5],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[69,1,70,1],[69,2,70,2],[69,3,70,3],[69,4,70,4],[69,5,70,5],[95,1,96,1],[95,2,96,2],[95,3,96,3],[95,4,96,4],[95,5,96,5],[122,1,123,1],[122,2,123,2],[122,3,123,3],[122,4,123,4],[122,5,123,5],[150,1,151,1],[150,2,151,2],[150,3,151,3],[150,4,151,4],[150,5,151,5],[178,1,179,1],[178,2,179,2],[178,3,179,3],[178,4,179,4],[178,5,179,5]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[]
["Disposition of Deferral and Variance Account"]
[]
[]
[]
[null," Please indicate the Rate Rider Recovery Period (in years)",null,4]
[]
[]
[null,"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.)"]
[null,"1550, 1551, 1584, 1586, 1595"]
[null,"Rate Class \n(Enter Rate Classes in cells below)","Units","kW / kWh / # of Customers","Allocated Balance (excluding 1589)","Rate Rider for Deferral/Variance Accounts"]
[]
[null,"RESIDENTIAL","kWh",28929065.912004169,39387.447495027191,3.4037953052852717E-4,{"$f":"IF(C20=\"\", \"\", IF(C20=\"# of Customers\", \"per customer per month\", \"$/\"&C20))","v":"$/kWh"}]
[null,"GENERAL SERVICE < 50 KW","kWh",11749297.376261501,15993.237356634876,3.4030199518457824E-4,{"$f":"IF(C21=\"\", \"\", IF(C21=\"# of Customers\", \"per customer per month\", \"$/\"&C21))","v":"$/kWh"}]
[null,"GENERAL SERVICE > 50 TO 4999 KW","kW",118023.99702302532,61130.023661574116,0.12948642903876625,"$/kW"]
[null,"UNMETERED SCATTERED LOAD","kWh",149639.52272445985,210.60618234965276,3.5185587757028341E-4,"$/kWh"]
[null,"STREET LIGHTING ","kW",3007.3398175917232,1523.2253044142947,0.12662563900361723,"$/kW"]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Total",null,null,{"$f":"SUM(E20:E39)","v":118244.54000000014}]
[]
[null,"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.) - NON-WMP"]
[null,"1580 and 1588"]
[null,"Rate Class \n(Enter Rate Classes in cells below)","Units","kW / kWh / # of Customers","Allocated Balance (excluding 1589)","Rate Rider for Deferral/Variance Accounts"]
[]
[null,"RESIDENTIAL","kWh",28929065.912004169,-18644.187869891,-1.6111985715856246E-4,{"$f":"IF(C46=\"\", \"\", IF(C46=\"# of Customers\", \"per customer per month\", \"$/\"&C46))","v":"$/kWh"}]
[null,"GENERAL SERVICE < 50 KW","kWh",11749297.376261501,-7572.1804599069028,-1.6111985715856246E-4,{"$f":"IF(C47=\"\", \"\", IF(C47=\"# of Customers\", \"per customer per month\", \"$/\"&C47))","v":"$/kWh"}]
[null,"GENERAL SERVICE > 50 TO 4999 KW","kW",118023.99702302532,-27992.315343616705,-5.9293694608045851E-2,"$/kW"]
[null,"UNMETERED SCATTERED LOAD","kWh",149639.52272445985,-96.439594106561742,-1.6111985715856249E-4,"$/kWh"]
[null,"STREET LIGHTING ","kW",3007.3398175917232,-697.50673247888517,-5.7983697784895517E-2,"$/kW"]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"Total",null,null,{"$f":"SUM(E46:E65)","v":-55002.630000000048}]
[]
[null,"Rate Rider Calculation for RSVA - Power - Global Adjustment"]
[null,"Balance of Account 1589 Allocated to Non-WMPs"]
[null,"Rate Class \n(Enter Rate Classes in cells below)","Units","Non-RPP kW / kWh / # of Customers","Balance of RSVA - Power - Global Adjustment","Rate Rider for RSVA - Power - Global Adjustment"]
[]
[null,"RESIDENTIAL","kWh",969123.70805213973,3646.4386268808194,9.4065355036300426E-4,{"$f":"IF(C72=\"\", \"\", IF(C72=\"# of Customers\", \"per customer per month\", \"$/\"&C72))","v":"$/kWh"}]
[null,"GENERAL SERVICE < 50 KW","kWh",2030278.5866179874,7639.1550429127674,9.4065355036300415E-4,{"$f":"IF(C73=\"\", \"\", IF(C73=\"# of Customers\", \"per customer per month\", \"$/\"&C73))","v":"$/kWh"}]
[null,"GENERAL SERVICE > 50 TO 4999 KW","kW",117840.76131477827,163171.63828673516,0.34616977280651701,"$/kW"]
[null,"UNMETERED SCATTERED LOAD","kWh",149407,562.16089999634153,9.4065355036300426E-4,"$/kWh"]
[null,"STREET LIGHTING ","kW",3002.6708053628008,4065.8771434748483,0.33852172008109832,"$/kW"]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"Total",null,null,{"$f":"SUM(E72:E91)","v":179085.26999999996}]
[]
[null,"Rate Rider Calculation for RSVA - Power - Global Adjustment - Class A Non-WMP Customers"]
[null,"Balance of Account 1589 allocated to Class A Non-WMP Customers"]
[null,"Rate Class \n(Enter Rate Classes in cells below)","Units","Non-RPP kW / kWh / # of Customers","Balance of RSVA - Power - Global Adjustment","Rate Rider for RSVA - Power - Global Adjustment"]
[]
[null,"RESIDENTIAL","kWh",0,0,0,{"$f":"IF(C98=\"\", \"\", IF(C98=\"# of Customers\", \"per customer per month\", \"$/\"&C98))","v":"$/kWh"}]
[null,"GENERAL SERVICE < 50 KW","kWh",0,0,0,{"$f":"IF(C99=\"\", \"\", IF(C99=\"# of Customers\", \"per customer per month\", \"$/\"&C99))","v":"$/kWh"}]
[null,"GENERAL SERVICE > 50 TO 4999 KW","kW",0,0,0,"$/kW"]
[null,"UNMETERED SCATTERED LOAD","kWh",0,0,0,"$/kWh"]
[null,"STREET LIGHTING ","kW",0,0,0,"$/kW"]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"Total",null,null,{"$f":"SUM(E98:E117)","v":0}]
[]
[]
[null,"Rate Rider Calculation for Group 2 Accounts"]
[]
[null,"Rate Class \n(Enter Rate Classes in cells below)","Units","Non-RPP kW / kWh / # of Customers","Balance of Group 2 Accounts","Rate Rider for RSVA - Power - Global Adjustment"]
[]
[null,"RESIDENTIAL","# of Customers",3834.9876147687,18725.601450343234,0.10172567321463954,{"$f":"IF(C125=\"\", \"\", IF(C125=\"# of Customers\", \"per customer per month\", \"$/\"&C125))","v":"per customer per month"}]
[null,"GENERAL SERVICE < 50 KW","kWh",11749297.376261501,7605.2459024659238,1.6182341928445236E-4,{"$f":"IF(C126=\"\", \"\", IF(C126=\"# of Customers\", \"per customer per month\", \"$/\"&C126))","v":"$/kWh"}]
[null,"GENERAL SERVICE > 50 TO 4999 KW","kW",118023.99702302532,28114.549394956219,5.9552612401085149E-2,"$/kW"]
[null,"UNMETERED SCATTERED LOAD","kWh",149639.52272445985,96.860716909462411,1.6182341928445236E-4,"$/kWh"]
[null,"STREET LIGHTING ","kW",3007.3398175917232,700.55253532516247,5.8236895214436118E-2,"$/kW"]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"",null,0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"Total",null,null,{"$f":"SUM(E125:E144)","v":55242.810000000005}]
[]
[null,"Rate Rider Calculation for Accounts 1575 and 1576"]
[]
[null," Please indicate the Rate Rider Recovery Period (in years)",null,4]
[]
[null,"Rate Class \n(Enter Rate Classes in cells below)","Units","kW / kWh / # of Customers","Balance of Accounts 1575 and 1576","Rate Rider for Accounts 1575 and 1576"]
[]
[null,"RESIDENTIAL","kWh",28929065.912004169,-295027.41563752672,-2.5495760607595745E-3,{"$f":"IF(C153=\"\", \"\", IF(C153=\"# of Customers\", \"per customer per month\", \"$/\"&C153))","v":"$/kWh"}]
[null,"GENERAL SERVICE < 50 KW","kWh",11749297.376261501,-119822.90928504639,-2.5495760607595745E-3,"$/kWh"]
[null,"GENERAL SERVICE > 50 TO 4999 KW","kW",118023.99702302532,-442953.08066889812,-0.93826910594817914,"$/kW"]
[null,"UNMETERED SCATTERED LOAD","kWh",149639.52272445985,-1526.0693795270847,-2.5495760607595745E-3,"$/kWh"]
[null,"STREET LIGHTING ","kW",3007.3398175917232,-11037.413381000448,-0.91753959067379398,"$/kW"]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"Total",null,null,{"$f":"SUM(E153:E172)","v":-870366.88835199876}]
[]
[null,"Rate Rider Calculation for Accounts 1568"]
[]
[null," Please indicate the Rate Rider Recovery Period (in years)",null,4]
[]
[null,"Rate Class \n(Enter Rate Classes in cells below)","Units","kW / kWh / # of Customers","Balance of \nAccount 1568","Rate Rider for Account 1568"]
[]
[null,"RESIDENTIAL","kWh",28929065.912004169,21493.640858637307,1.8574433861791648E-4,{"$f":"IF(C181=\"\", \"\", IF(C181=\"# of Customers\", \"per customer per month\", \"$/\"&C181))","v":"$/kWh"}]
[null,"GENERAL SERVICE < 50 KW","kWh",11749297.376261501,8729.4618815156555,1.8574433861791648E-4,{"$f":"IF(C182=\"\", \"\", IF(C182=\"# of Customers\", \"per customer per month\", \"$/\"&C182))","v":"$/kWh"}]
[null,"GENERAL SERVICE > 50 TO 4999 KW","kW",118023.99702302532,32270.473618700857,6.8355746358101238E-2,"$/kW"]
[null,"UNMETERED SCATTERED LOAD","kWh",149639.52272445985,111.17877671822191,1.8574433861791648E-4,"$/kWh"]
[null,"STREET LIGHTING ","kW",3007.3398175917232,804.10899680933187,6.6845538381264655E-2,"$/kW"]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"","",0,0,0,""]
[null,"Total",null,null,{"$f":"SUM(E181:E200)","v":63408.864132381379}]

{"sheet":"K. Summary of Tariffs","index":16,"n_rows":158,"n_cols":7,"rows_kept":158,"cut":false,"hidden":true,"merged":[[7,0,7,6],[8,0,8,6],[11,0,11,2],[11,4,11,6],[0,6,0,7],[1,6,1,7],[2,6,2,7],[3,6,3,7],[4,6,4,7],[6,6,6,7]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[]
[" "]
["Summary of Tariff Sheet"]
[]
[]
["Current Rates",null,null,null,"Proposed Rates"]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A30),\"\",'B. CurrentTariff'!A30)","v":"Residential"},"rate","Connection Type",null,{"$f":"A13","v":"Residential"},{"$f":"B13","v":"rate"},{"$f":"C13","v":"Connection Type"}]
[null,""]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A32),\"\",'B. CurrentTariff'!A32)","v":"Service Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C32),\"\",'B. CurrentTariff'!C32)","v":13.97},{"$f":"IF(ISBLANK('B. CurrentTariff'!D32),\"\",'B. CurrentTariff'!D32)","v":"$"},null,{"$f":"A15","v":"Service Charge"},{"$f":"'G. RateDesign'!B46","v":17.91},{"$f":"C15","v":"$"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A33),\"\",'B. CurrentTariff'!A33)","v":"Distribution Volumetric Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C33),\"\",'B. CurrentTariff'!C33)","v":1.4500000000000001E-2},{"$f":"IF(ISBLANK('B. CurrentTariff'!D33),\"\",'B. CurrentTariff'!D33)","v":"kWh"},null,{"$f":"A16","v":"Distribution Volumetric Rate"},{"$f":"'G. RateDesign'!G46","v":1.3976689220655134E-2},{"$f":"C16","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A34),\"\",'B. CurrentTariff'!A34)","v":"Rate Rider for Smart Metering Entity Charge - effective until October 31, 2018"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C34),\"\",'B. CurrentTariff'!C34)","v":0.79},{"$f":"IF(ISBLANK('B. CurrentTariff'!D34),\"\",'B. CurrentTariff'!D34)","v":"kWh"},null,null,0.79,"kWh"]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A35),\"\",'B. CurrentTariff'!A35)","v":"Low Voltage Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C35),\"\",'B. CurrentTariff'!C35)","v":1.1000000000000001E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D35),\"\",'B. CurrentTariff'!D35)","v":"kWh"},null," "]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A36),\"\",'B. CurrentTariff'!A36)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C36),\"\",'B. CurrentTariff'!C36)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D36),\"\",'B. CurrentTariff'!D36)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A37),\"\",'B. CurrentTariff'!A37)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C37),\"\",'B. CurrentTariff'!C37)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D37),\"\",'B. CurrentTariff'!D37)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A38),\"\",'B. CurrentTariff'!A38)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C38),\"\",'B. CurrentTariff'!C38)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D38),\"\",'B. CurrentTariff'!D38)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A39),\"\",'B. CurrentTariff'!A39)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C39),\"\",'B. CurrentTariff'!C39)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D39),\"\",'B. CurrentTariff'!D39)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A40),\"\",'B. CurrentTariff'!A40)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C40),\"\",'B. CurrentTariff'!C40)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D40),\"\",'B. CurrentTariff'!D40)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A41),\"\",'B. CurrentTariff'!A41)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A42),\"\",'B. CurrentTariff'!A42)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A43),\"\",'B. CurrentTariff'!A43)","v":""},""]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A44),\"\",'B. CurrentTariff'!A44)","v":""},""]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A45),\"\",'B. CurrentTariff'!A45)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"'B. CurrentTariff'!C45","v":6.4000000000000003E-3},{"$f":"'B. CurrentTariff'!D45","v":"kWh"},null,{"$f":"A28","v":"Retail Transmission Rate – Network Service Rate"},5.7000000000000002E-3,{"$f":"C28","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A46),\"\",'B. CurrentTariff'!A46)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"'B. CurrentTariff'!C46","v":3.3E-3},{"$f":"'B. CurrentTariff'!D46","v":"kWh"},null,{"$f":"A29","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},4.5999999999999999E-3,{"$f":"C29","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A47),\"\",'B. CurrentTariff'!A47)","v":"Wholesale Market Service Rate"},{"$f":"'B. CurrentTariff'!C47","v":4.4000000000000003E-3},{"$f":"'B. CurrentTariff'!D47","v":"kWh"},null,{"$f":"A30","v":"Wholesale Market Service Rate"},4.4000000000000003E-3,{"$f":"C30","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A48),\"\",'B. CurrentTariff'!A48)","v":"Rural Rate Protection Charge"},{"$f":"'B. CurrentTariff'!C48","v":1.2999999999999999E-3},{"$f":"'B. CurrentTariff'!D48","v":"kWh"},null,{"$f":"A31","v":"Rural Rate Protection Charge"},1.2999999999999999E-3,{"$f":"C31","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A49),\"\",'B. CurrentTariff'!A49)","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"'B. CurrentTariff'!C49","v":0.25},{"$f":"'B. CurrentTariff'!D49","v":"$"},null,{"$f":"A32","v":"Standard Supply Service – Administrative Charge (if applicable)"},0.25,{"$f":"C32","v":"$"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A51),\"\",'B. CurrentTariff'!A51)","v":"General Service < 50 kW"},"rate","Connection Type",null,{"$f":"A34","v":"General Service < 50 kW"},{"$f":"B34","v":"rate"},{"$f":"C34","v":"Connection Type"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A53),\"\",'B. CurrentTariff'!A53)","v":"Service Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C53),\"\",'B. CurrentTariff'!C53)","v":31.25},{"$f":"IF(ISBLANK('B. CurrentTariff'!D53),\"\",'B. CurrentTariff'!D53)","v":"$"},null,{"$f":"A36","v":"Service Charge"},{"$f":"'G. RateDesign'!B47","v":31.25},{"$f":"C36","v":"$"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A54),\"\",'B. CurrentTariff'!A54)","v":"Distribution Volumetric Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C54),\"\",'B. CurrentTariff'!C54)","v":1.37E-2},{"$f":"IF(ISBLANK('B. CurrentTariff'!D54),\"\",'B. CurrentTariff'!D54)","v":"kWh"},null,{"$f":"A37","v":"Distribution Volumetric Rate"},{"$f":"'G. RateDesign'!G47","v":1.8040240945143494E-2},{"$f":"C37","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A55),\"\",'B. CurrentTariff'!A55)","v":"Rate Rider for Smart Metering Entity Charge - effective until October 31, 2018"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C55),\"\",'B. CurrentTariff'!C55)","v":0.79},{"$f":"IF(ISBLANK('B. CurrentTariff'!D55),\"\",'B. CurrentTariff'!D55)","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A56),\"\",'B. CurrentTariff'!A56)","v":"Low Voltage Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C56),\"\",'B. CurrentTariff'!C56)","v":1E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D56),\"\",'B. CurrentTariff'!D56)","v":"kWh"},null," "]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A57),\"\",'B. CurrentTariff'!A57)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C57),\"\",'B. CurrentTariff'!C57)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D57),\"\",'B. CurrentTariff'!D57)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A58),\"\",'B. CurrentTariff'!A58)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C58),\"\",'B. CurrentTariff'!C58)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D58),\"\",'B. CurrentTariff'!D58)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A59),\"\",'B. CurrentTariff'!A59)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C59),\"\",'B. CurrentTariff'!C59)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D59),\"\",'B. CurrentTariff'!D59)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A60),\"\",'B. CurrentTariff'!A60)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C60),\"\",'B. CurrentTariff'!C60)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D60),\"\",'B. CurrentTariff'!D60)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A61),\"\",'B. CurrentTariff'!A61)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C61),\"\",'B. CurrentTariff'!C61)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D61),\"\",'B. CurrentTariff'!D61)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A62),\"\",'B. CurrentTariff'!A62)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C62),\"\",'B. CurrentTariff'!C62)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D62),\"\",'B. CurrentTariff'!D62)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A63),\"\",'B. CurrentTariff'!A63)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C63),\"\",'B. CurrentTariff'!C63)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D63),\"\",'B. CurrentTariff'!D63)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A64),\"\",'B. CurrentTariff'!A64)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C64),\"\",'B. CurrentTariff'!C64)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D64),\"\",'B. CurrentTariff'!D64)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A65),\"\",'B. CurrentTariff'!A65)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C65),\"\",'B. CurrentTariff'!C65)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D65),\"\",'B. CurrentTariff'!D65)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A66),\"\",'B. CurrentTariff'!A66)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C66),\"\",'B. CurrentTariff'!C66)","v":5.7999999999999996E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D66),\"\",'B. CurrentTariff'!D66)","v":"kWh"},null,{"$f":"A49","v":"Retail Transmission Rate – Network Service Rate"},5.3E-3,{"$f":"C49","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A67),\"\",'B. CurrentTariff'!A67)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C67),\"\",'B. CurrentTariff'!C67)","v":3.0999999999999999E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D67),\"\",'B. CurrentTariff'!D67)","v":"kWh"},null,{"$f":"A50","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},4.1000000000000003E-3,{"$f":"C50","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A68),\"\",'B. CurrentTariff'!A68)","v":"Wholesale Market Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C68),\"\",'B. CurrentTariff'!C68)","v":4.4000000000000003E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D68),\"\",'B. CurrentTariff'!D68)","v":"kWh"},null,{"$f":"A51","v":"Wholesale Market Service Rate"},4.4000000000000003E-3,{"$f":"C51","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A69),\"\",'B. CurrentTariff'!A69)","v":"Rural Rate Protection Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C69),\"\",'B. CurrentTariff'!C69)","v":1.2999999999999999E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D69),\"\",'B. CurrentTariff'!D69)","v":"kWh"},null,{"$f":"A52","v":"Rural Rate Protection Charge"},1.1000000000000001E-3,{"$f":"C52","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A70),\"\",'B. CurrentTariff'!A70)","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C70),\"\",'B. CurrentTariff'!C70)","v":0.25},{"$f":"IF(ISBLANK('B. CurrentTariff'!D70),\"\",'B. CurrentTariff'!D70)","v":"$"},null,{"$f":"A53","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"B53","v":0.25},{"$f":"C53","v":"$"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A72),\"\",'B. CurrentTariff'!A72)","v":"General Service > 50 to 4999 kW"},"rate","Connection Type",null,{"$f":"A55","v":"General Service > 50 to 4999 kW"},{"$f":"B55","v":"rate"},{"$f":"C55","v":"Connection Type"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A74),\"\",'B. CurrentTariff'!A74)","v":"Service Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C74),\"\",'B. CurrentTariff'!C74)","v":189.27},{"$f":"IF(ISBLANK('B. CurrentTariff'!D74),\"\",'B. CurrentTariff'!D74)","v":"$"},null,{"$f":"A57","v":"Service Charge"},{"$f":"'G. RateDesign'!B48","v":189.27},{"$f":"C57","v":"$"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A75),\"\",'B. CurrentTariff'!A75)","v":"Distribution Volumetric Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C75),\"\",'B. CurrentTariff'!C75)","v":2.5331000000000001},{"$f":"IF(ISBLANK('B. CurrentTariff'!D75),\"\",'B. CurrentTariff'!D75)","v":"kW"},null,{"$f":"A58","v":"Distribution Volumetric Rate"},{"$f":"'G. RateDesign'!G48","v":3.1921101160778975},{"$f":"C58","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A76),\"\",'B. CurrentTariff'!A76)","v":"Low Voltage Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C76),\"\",'B. CurrentTariff'!C76)","v":0.35639999999999999},{"$f":"IF(ISBLANK('B. CurrentTariff'!D76),\"\",'B. CurrentTariff'!D76)","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A77),\"\",'B. CurrentTariff'!A77)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C77),\"\",'B. CurrentTariff'!C77)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D77),\"\",'B. CurrentTariff'!D77)","v":""},null," "]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A78),\"\",'B. CurrentTariff'!A78)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C78),\"\",'B. CurrentTariff'!C78)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D78),\"\",'B. CurrentTariff'!D78)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A79),\"\",'B. CurrentTariff'!A79)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C79),\"\",'B. CurrentTariff'!C79)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D79),\"\",'B. CurrentTariff'!D79)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A80),\"\",'B. CurrentTariff'!A80)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C80),\"\",'B. CurrentTariff'!C80)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D80),\"\",'B. CurrentTariff'!D80)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A81),\"\",'B. CurrentTariff'!A81)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C81),\"\",'B. CurrentTariff'!C81)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D81),\"\",'B. CurrentTariff'!D81)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A82),\"\",'B. CurrentTariff'!A82)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C82),\"\",'B. CurrentTariff'!C82)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D82),\"\",'B. CurrentTariff'!D82)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A83),\"\",'B. CurrentTariff'!A83)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C83),\"\",'B. CurrentTariff'!C83)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D83),\"\",'B. CurrentTariff'!D83)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A84),\"\",'B. CurrentTariff'!A84)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C84),\"\",'B. CurrentTariff'!C84)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D84),\"\",'B. CurrentTariff'!D84)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A85),\"\",'B. CurrentTariff'!A85)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C85),\"\",'B. CurrentTariff'!C85)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D85),\"\",'B. CurrentTariff'!D85)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A86),\"\",'B. CurrentTariff'!A86)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C86),\"\",'B. CurrentTariff'!C86)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D86),\"\",'B. CurrentTariff'!D86)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A87),\"\",'B. CurrentTariff'!A87)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C87),\"\",'B. CurrentTariff'!C87)","v":2.3668},{"$f":"IF(ISBLANK('B. CurrentTariff'!D87),\"\",'B. CurrentTariff'!D87)","v":"kW"},null,{"$f":"A70","v":"Retail Transmission Rate – Network Service Rate"},2.1448999999999998,{"$f":"C70","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A88),\"\",'B. CurrentTariff'!A88)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C88),\"\",'B. CurrentTariff'!C88)","v":1.1566000000000001},{"$f":"IF(ISBLANK('B. CurrentTariff'!D88),\"\",'B. CurrentTariff'!D88)","v":"kW"},null,{"$f":"A71","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},1.631,{"$f":"C71","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A89),\"\",'B. CurrentTariff'!A89)","v":"Wholesale Market Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C89),\"\",'B. CurrentTariff'!C89)","v":4.4000000000000003E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D89),\"\",'B. CurrentTariff'!D89)","v":"kWh"},null,{"$f":"A72","v":"Wholesale Market Service Rate"},{"$f":"B72","v":4.4000000000000003E-3},{"$f":"C72","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A90),\"\",'B. CurrentTariff'!A90)","v":"Rural Rate Protection Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C90),\"\",'B. CurrentTariff'!C90)","v":1.2999999999999999E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D90),\"\",'B. CurrentTariff'!D90)","v":"kWh"},null,{"$f":"A73","v":"Rural Rate Protection Charge"},{"$f":"B73","v":1.2999999999999999E-3},{"$f":"C73","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A91),\"\",'B. CurrentTariff'!A91)","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C91),\"\",'B. CurrentTariff'!C91)","v":0.25},{"$f":"IF(ISBLANK('B. CurrentTariff'!D91),\"\",'B. CurrentTariff'!D91)","v":"$"},null,{"$f":"A74","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"B74","v":0.25},{"$f":"C74","v":"$"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A93),\"\",'B. CurrentTariff'!A93)","v":"Unmetered Scattered Load"},"rate","Connection Type",null,{"$f":"A76","v":"Unmetered Scattered Load"},{"$f":"B76","v":"rate"},{"$f":"C76","v":"Connection Type"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A95),\"\",'B. CurrentTariff'!A95)","v":"Service Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C95),\"\",'B. CurrentTariff'!C95)","v":43.63},{"$f":"IF(ISBLANK('B. CurrentTariff'!D95),\"\",'B. CurrentTariff'!D95)","v":"$"},null,{"$f":"A78","v":"Service Charge"},{"$f":"'G. RateDesign'!B49","v":39.619999999999997},{"$f":"C78","v":"$"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A96),\"\",'B. CurrentTariff'!A96)","v":"Distribution Volumetric Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C96),\"\",'B. CurrentTariff'!C96)","v":9.9000000000000008E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D96),\"\",'B. CurrentTariff'!D96)","v":"kW"},null,{"$f":"A79","v":"Distribution Volumetric Rate"},{"$f":"'G. RateDesign'!G49","v":8.8690719314647067E-3},{"$f":"C79","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A97),\"\",'B. CurrentTariff'!A97)","v":"Low Voltage Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C97),\"\",'B. CurrentTariff'!C97)","v":1E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D97),\"\",'B. CurrentTariff'!D97)","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A98),\"\",'B. CurrentTariff'!A98)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C98),\"\",'B. CurrentTariff'!C98)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D98),\"\",'B. CurrentTariff'!D98)","v":""},null," "]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A99),\"\",'B. CurrentTariff'!A99)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C99),\"\",'B. CurrentTariff'!C99)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D99),\"\",'B. CurrentTariff'!D99)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A100),\"\",'B. CurrentTariff'!A100)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C100),\"\",'B. CurrentTariff'!C100)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D100),\"\",'B. CurrentTariff'!D100)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A101),\"\",'B. CurrentTariff'!A101)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C101),\"\",'B. CurrentTariff'!C101)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D101),\"\",'B. CurrentTariff'!D101)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A102),\"\",'B. CurrentTariff'!A102)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C102),\"\",'B. CurrentTariff'!C102)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D102),\"\",'B. CurrentTariff'!D102)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A103),\"\",'B. CurrentTariff'!A103)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C103),\"\",'B. CurrentTariff'!C103)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D103),\"\",'B. CurrentTariff'!D103)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A104),\"\",'B. CurrentTariff'!A104)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C104),\"\",'B. CurrentTariff'!C104)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D104),\"\",'B. CurrentTariff'!D104)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A105),\"\",'B. CurrentTariff'!A105)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C105),\"\",'B. CurrentTariff'!C105)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D105),\"\",'B. CurrentTariff'!D105)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A106),\"\",'B. CurrentTariff'!A106)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C106),\"\",'B. CurrentTariff'!C106)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D106),\"\",'B. CurrentTariff'!D106)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A107),\"\",'B. CurrentTariff'!A107)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C107),\"\",'B. CurrentTariff'!C107)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D107),\"\",'B. CurrentTariff'!D107)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A108),\"\",'B. CurrentTariff'!A108)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C108),\"\",'B. CurrentTariff'!C108)","v":5.7999999999999996E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D108),\"\",'B. CurrentTariff'!D108)","v":"kW"},null,{"$f":"A91","v":"Retail Transmission Rate – Network Service Rate"},6.7999999999999996E-3,{"$f":"C91","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A109),\"\",'B. CurrentTariff'!A109)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C109),\"\",'B. CurrentTariff'!C109)","v":3.0999999999999999E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D109),\"\",'B. CurrentTariff'!D109)","v":"kW"},null,{"$f":"A92","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},4.5999999999999999E-3,{"$f":"C92","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A110),\"\",'B. CurrentTariff'!A110)","v":"Wholesale Market Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C110),\"\",'B. CurrentTariff'!C110)","v":4.4000000000000003E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D110),\"\",'B. CurrentTariff'!D110)","v":"kWh"},null,{"$f":"A93","v":"Wholesale Market Service Rate"},{"$f":"B93","v":4.4000000000000003E-3},{"$f":"C93","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A111),\"\",'B. CurrentTariff'!A111)","v":"Rural Rate Protection Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C111),\"\",'B. CurrentTariff'!C111)","v":1.2999999999999999E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D111),\"\",'B. CurrentTariff'!D111)","v":"kWh"},null,{"$f":"A94","v":"Rural Rate Protection Charge"},{"$f":"B94","v":1.2999999999999999E-3},{"$f":"C94","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A112),\"\",'B. CurrentTariff'!A112)","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C112),\"\",'B. CurrentTariff'!C112)","v":0.25},{"$f":"IF(ISBLANK('B. CurrentTariff'!D112),\"\",'B. CurrentTariff'!D112)","v":"$"},null,{"$f":"A95","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"B95","v":0.25},{"$f":"C95","v":"$"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A114),\"\",'B. CurrentTariff'!A114)","v":"Street Lighting "},"rate","Connection Type",null,{"$f":"A97","v":"Street Lighting "},{"$f":"B97","v":"rate"},{"$f":"C97","v":"Connection Type"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A116),\"\",'B. CurrentTariff'!A116)","v":"Service Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C116),\"\",'B. CurrentTariff'!C116)","v":2.95},{"$f":"IF(ISBLANK('B. CurrentTariff'!D116),\"\",'B. CurrentTariff'!D116)","v":"$"},null,{"$f":"A99","v":"Service Charge"},{"$f":"'G. RateDesign'!B50","v":2.82},{"$f":"C99","v":"$"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A117),\"\",'B. CurrentTariff'!A117)","v":"Distribution Volumetric Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C117),\"\",'B. CurrentTariff'!C117)","v":7.2483000000000004},{"$f":"IF(ISBLANK('B. CurrentTariff'!D117),\"\",'B. CurrentTariff'!D117)","v":"kW"},null,{"$f":"A100","v":"Distribution Volumetric Rate"},{"$f":"'G. RateDesign'!G50","v":6.9247617143185618},{"$f":"C100","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A118),\"\",'B. CurrentTariff'!A118)","v":"Low Voltage Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C118),\"\",'B. CurrentTariff'!C118)","v":0.27539999999999998},{"$f":"IF(ISBLANK('B. CurrentTariff'!D118),\"\",'B. CurrentTariff'!D118)","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A119),\"\",'B. CurrentTariff'!A119)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C119),\"\",'B. CurrentTariff'!C119)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D119),\"\",'B. CurrentTariff'!D119)","v":""},null," "]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A120),\"\",'B. CurrentTariff'!A120)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C120),\"\",'B. CurrentTariff'!C120)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D120),\"\",'B. CurrentTariff'!D120)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A121),\"\",'B. CurrentTariff'!A121)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C121),\"\",'B. CurrentTariff'!C121)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D121),\"\",'B. CurrentTariff'!D121)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A122),\"\",'B. CurrentTariff'!A122)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C122),\"\",'B. CurrentTariff'!C122)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D122),\"\",'B. CurrentTariff'!D122)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A123),\"\",'B. CurrentTariff'!A123)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C123),\"\",'B. CurrentTariff'!C123)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D123),\"\",'B. CurrentTariff'!D123)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A124),\"\",'B. CurrentTariff'!A124)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C124),\"\",'B. CurrentTariff'!C124)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D124),\"\",'B. CurrentTariff'!D124)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A125),\"\",'B. CurrentTariff'!A125)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C125),\"\",'B. CurrentTariff'!C125)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D125),\"\",'B. CurrentTariff'!D125)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A126),\"\",'B. CurrentTariff'!A126)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C126),\"\",'B. CurrentTariff'!C126)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D126),\"\",'B. CurrentTariff'!D126)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A127),\"\",'B. CurrentTariff'!A127)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C127),\"\",'B. CurrentTariff'!C127)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D127),\"\",'B. CurrentTariff'!D127)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A128),\"\",'B. CurrentTariff'!A128)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C128),\"\",'B. CurrentTariff'!C128)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D128),\"\",'B. CurrentTariff'!D128)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A129),\"\",'B. CurrentTariff'!A129)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C129),\"\",'B. CurrentTariff'!C129)","v":1.7848999999999999},{"$f":"IF(ISBLANK('B. CurrentTariff'!D129),\"\",'B. CurrentTariff'!D129)","v":"kW"},null,{"$f":"A112","v":"Retail Transmission Rate – Network Service Rate"},1.6175999999999999,{"$f":"C112","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A130),\"\",'B. CurrentTariff'!A130)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C130),\"\",'B. CurrentTariff'!C130)","v":0.89410000000000001},{"$f":"IF(ISBLANK('B. CurrentTariff'!D130),\"\",'B. CurrentTariff'!D130)","v":"kW"},null,{"$f":"A113","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},1.2609999999999999,{"$f":"C113","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A131),\"\",'B. CurrentTariff'!A131)","v":"Wholesale Market Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C131),\"\",'B. CurrentTariff'!C131)","v":4.4000000000000003E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D131),\"\",'B. CurrentTariff'!D131)","v":"kWh"},null,{"$f":"A114","v":"Wholesale Market Service Rate"},{"$f":"B114","v":4.4000000000000003E-3},{"$f":"C114","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A132),\"\",'B. CurrentTariff'!A132)","v":"Rural Rate Protection Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C132),\"\",'B. CurrentTariff'!C132)","v":1.2999999999999999E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D132),\"\",'B. CurrentTariff'!D132)","v":"kWh"},null,{"$f":"A115","v":"Rural Rate Protection Charge"},{"$f":"B115","v":1.2999999999999999E-3},{"$f":"C115","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A133),\"\",'B. CurrentTariff'!A133)","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C133),\"\",'B. CurrentTariff'!C133)","v":0.25},{"$f":"IF(ISBLANK('B. CurrentTariff'!D133),\"\",'B. CurrentTariff'!D133)","v":"$"},null,{"$f":"A116","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"B116","v":0.25},{"$f":"C116","v":"$"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A135),\"\",'B. CurrentTariff'!A135)","v":"other classes"},"rate","Connection Type",null,{"$f":"A118","v":"other classes"},{"$f":"B118","v":"rate"},{"$f":"C118","v":"Connection Type"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A137),\"\",'B. CurrentTariff'!A137)","v":"Service Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C137),\"\",'B. CurrentTariff'!C137)","v":6.25},{"$f":"IF(ISBLANK('B. CurrentTariff'!D137),\"\",'B. CurrentTariff'!D137)","v":"$"},null,{"$f":"A120","v":"Service Charge"},{"$f":"'G. RateDesign'!B54","v":0},{"$f":"C120","v":"$"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A138),\"\",'B. CurrentTariff'!A138)","v":"Distribution Volumetric Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C138),\"\",'B. CurrentTariff'!C138)","v":2E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D138),\"\",'B. CurrentTariff'!D138)","v":"kWh"},null,{"$f":"A121","v":"Distribution Volumetric Rate"},{"$f":"'G. RateDesign'!G54","v":0},{"$f":"C121","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A139),\"\",'B. CurrentTariff'!A139)","v":"Low Voltage Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C139),\"\",'B. CurrentTariff'!C139)","v":1E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D139),\"\",'B. CurrentTariff'!D139)","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A140),\"\",'B. CurrentTariff'!A140)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C140),\"\",'B. CurrentTariff'!C140)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D140),\"\",'B. CurrentTariff'!D140)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A141),\"\",'B. CurrentTariff'!A141)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C141),\"\",'B. CurrentTariff'!C141)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D141),\"\",'B. CurrentTariff'!D141)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A142),\"\",'B. CurrentTariff'!A142)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C142),\"\",'B. CurrentTariff'!C142)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D142),\"\",'B. CurrentTariff'!D142)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A143),\"\",'B. CurrentTariff'!A143)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C143),\"\",'B. CurrentTariff'!C143)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D143),\"\",'B. CurrentTariff'!D143)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A144),\"\",'B. CurrentTariff'!A144)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C144),\"\",'B. CurrentTariff'!C144)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D144),\"\",'B. CurrentTariff'!D144)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A145),\"\",'B. CurrentTariff'!A145)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C145),\"\",'B. CurrentTariff'!C145)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D145),\"\",'B. CurrentTariff'!D145)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A146),\"\",'B. CurrentTariff'!A146)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C146),\"\",'B. CurrentTariff'!C146)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D146),\"\",'B. CurrentTariff'!D146)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A147),\"\",'B. CurrentTariff'!A147)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C147),\"\",'B. CurrentTariff'!C147)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D147),\"\",'B. CurrentTariff'!D147)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A148),\"\",'B. CurrentTariff'!A148)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C148),\"\",'B. CurrentTariff'!C148)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D148),\"\",'B. CurrentTariff'!D148)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A149),\"\",'B. CurrentTariff'!A149)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C149),\"\",'B. CurrentTariff'!C149)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D149),\"\",'B. CurrentTariff'!D149)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A150),\"\",'B. CurrentTariff'!A150)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C150),\"\",'B. CurrentTariff'!C150)","v":5.7999999999999996E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D150),\"\",'B. CurrentTariff'!D150)","v":"kWh"},null,{"$f":"A133","v":"Retail Transmission Rate – Network Service Rate"},2.0499000000000001,{"$f":"C133","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A151),\"\",'B. CurrentTariff'!A151)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C151),\"\",'B. CurrentTariff'!C151)","v":4.0000000000000001E-3},{"$f":"IF(ISBLANK('B. CurrentTariff'!D151),\"\",'B. CurrentTariff'!D151)","v":"kWh"},null,{"$f":"A134","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},1.42,{"$f":"C134","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A152),\"\",'B. CurrentTariff'!A152)","v":"Wholesale Market Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C152),\"\",'B. CurrentTariff'!C152)","v":0},{"$f":"IF(ISBLANK('B. CurrentTariff'!D152),\"\",'B. CurrentTariff'!D152)","v":"kWh"},null,{"$f":"A135","v":"Wholesale Market Service Rate"},{"$f":"B135","v":0},{"$f":"C135","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A153),\"\",'B. CurrentTariff'!A153)","v":"Rural Rate Protection Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C153),\"\",'B. CurrentTariff'!C153)","v":0},{"$f":"IF(ISBLANK('B. CurrentTariff'!D153),\"\",'B. CurrentTariff'!D153)","v":"kWh"},null,{"$f":"A136","v":"Rural Rate Protection Charge"},{"$f":"B136","v":0},{"$f":"C136","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A154),\"\",'B. CurrentTariff'!A154)","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C154),\"\",'B. CurrentTariff'!C154)","v":0.25},{"$f":"IF(ISBLANK('B. CurrentTariff'!D154),\"\",'B. CurrentTariff'!D154)","v":"$"},null,{"$f":"A137","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"B137","v":0.25},{"$f":"C137","v":"$"}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A156),\"\",'B. CurrentTariff'!A156)","v":"Other Rate Classes"},"",null,null,{"$f":"A139","v":"Other Rate Classes"},{"$f":"B139","v":""},{"$f":"C139","v":0}]
[]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A158),\"\",'B. CurrentTariff'!A158)","v":"Service Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C158),\"\",'B. CurrentTariff'!C158)","v":0},{"$f":"IF(ISBLANK('B. CurrentTariff'!D158),\"\",'B. CurrentTariff'!D158)","v":"$"},null,{"$f":"A141","v":"Service Charge"},{"$f":"'G. RateDesign'!B55","v":0},{"$f":"C141","v":"$"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A159),\"\",'B. CurrentTariff'!A159)","v":"Distribution Volumetric Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C159),\"\",'B. CurrentTariff'!C159)","v":0},{"$f":"IF(ISBLANK('B. CurrentTariff'!D159),\"\",'B. CurrentTariff'!D159)","v":"kW"},null,{"$f":"A142","v":"Distribution Volumetric Rate"},{"$f":"'G. RateDesign'!G55","v":" "},{"$f":"C142","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A160),\"\",'B. CurrentTariff'!A160)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C160),\"\",'B. CurrentTariff'!C160)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D160),\"\",'B. CurrentTariff'!D160)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A161),\"\",'B. CurrentTariff'!A161)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C161),\"\",'B. CurrentTariff'!C161)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D161),\"\",'B. CurrentTariff'!D161)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A162),\"\",'B. CurrentTariff'!A162)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C162),\"\",'B. CurrentTariff'!C162)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D162),\"\",'B. CurrentTariff'!D162)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A163),\"\",'B. CurrentTariff'!A163)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C163),\"\",'B. CurrentTariff'!C163)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D163),\"\",'B. CurrentTariff'!D163)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A164),\"\",'B. CurrentTariff'!A164)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C164),\"\",'B. CurrentTariff'!C164)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D164),\"\",'B. CurrentTariff'!D164)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A165),\"\",'B. CurrentTariff'!A165)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C165),\"\",'B. CurrentTariff'!C165)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D165),\"\",'B. CurrentTariff'!D165)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A166),\"\",'B. CurrentTariff'!A166)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C166),\"\",'B. CurrentTariff'!C166)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D166),\"\",'B. CurrentTariff'!D166)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A167),\"\",'B. CurrentTariff'!A167)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C167),\"\",'B. CurrentTariff'!C167)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D167),\"\",'B. CurrentTariff'!D167)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A168),\"\",'B. CurrentTariff'!A168)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C168),\"\",'B. CurrentTariff'!C168)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D168),\"\",'B. CurrentTariff'!D168)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A169),\"\",'B. CurrentTariff'!A169)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C169),\"\",'B. CurrentTariff'!C169)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D169),\"\",'B. CurrentTariff'!D169)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A170),\"\",'B. CurrentTariff'!A170)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!C170),\"\",'B. CurrentTariff'!C170)","v":""},{"$f":"IF(ISBLANK('B. CurrentTariff'!D170),\"\",'B. CurrentTariff'!D170)","v":""}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A171),\"\",'B. CurrentTariff'!A171)","v":"Retail Transmission Rate – Network Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C171),\"\",'B. CurrentTariff'!C171)","v":0},{"$f":"IF(ISBLANK('B. CurrentTariff'!D171),\"\",'B. CurrentTariff'!D171)","v":"kW"},null,{"$f":"A154","v":"Retail Transmission Rate – Network Service Rate"},2.0499000000000001,{"$f":"C154","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A172),\"\",'B. CurrentTariff'!A172)","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C172),\"\",'B. CurrentTariff'!C172)","v":0},{"$f":"IF(ISBLANK('B. CurrentTariff'!D172),\"\",'B. CurrentTariff'!D172)","v":"kW"},null,{"$f":"A155","v":"Retail Transmission Rate – Line and Transformation Connection Service Rate"},1.42,{"$f":"C155","v":"kW"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A173),\"\",'B. CurrentTariff'!A173)","v":"Wholesale Market Service Rate"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C173),\"\",'B. CurrentTariff'!C173)","v":0},{"$f":"IF(ISBLANK('B. CurrentTariff'!D173),\"\",'B. CurrentTariff'!D173)","v":"kWh"},null,{"$f":"A156","v":"Wholesale Market Service Rate"},{"$f":"B156","v":0},{"$f":"C156","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A174),\"\",'B. CurrentTariff'!A174)","v":"Rural Rate Protection Charge"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C174),\"\",'B. CurrentTariff'!C174)","v":0},{"$f":"IF(ISBLANK('B. CurrentTariff'!D174),\"\",'B. CurrentTariff'!D174)","v":"kWh"},null,{"$f":"A157","v":"Rural Rate Protection Charge"},{"$f":"B157","v":0},{"$f":"C157","v":"kWh"}]
[{"$f":"IF(ISBLANK('B. CurrentTariff'!A175),\"\",'B. CurrentTariff'!A175)","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"IF(ISBLANK('B. CurrentTariff'!C175),\"\",'B. CurrentTariff'!C175)","v":0.25},{"$f":"IF(ISBLANK('B. CurrentTariff'!D175),\"\",'B. CurrentTariff'!D175)","v":"$"},null,{"$f":"A158","v":"Standard Supply Service – Administrative Charge (if applicable)"},{"$f":"B158","v":0.25},{"$f":"C158","v":"$"}]

{"sheet":"BILL IMPACT ->","index":17,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Revenue"]
[null,null,null,null,null,null,null,"Requirement"]
[null,null,null,null,null,null,null,"Workform"]
[null,null,null,null,null,null,null,"('RRWF')"]

{"sheet":"Bill Impact - Res 10 Pct","index":18,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[72,1,72,3],[20,3,21,3],[20,13,21,13],[20,14,21,14],[65,1,65,3],[66,1,66,3],[71,1,71,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[19,5,19,7],[19,9,19,11],[19,13,19,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Residential"]
[]
[null,"TOU / non-TOU:",null,"TOU"]
[]
[null,null,null,"Consumption",null,286," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,{"$f":"'B. CurrentTariff'!C32","v":13.97},1,{"$f":"G23*F23","v":13.97},null,{"$f":"'G. RateDesign'!B46","v":17.91},1,{"$f":"K23*J23","v":17.91},null,{"$f":"L23-H23","v":3.9399999999999995},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":0.28203292770221899}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G24*F24","v":0},null,null,1,{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,{"$f":"'K. SMRR'!G13","v":0.13613160000556787},1,{"$f":"K25*J25","v":0.13613160000556787},null,{"$f":"L25-H25","v":0.13613160000556787},{"$f":"IF((H25)=0,\"\",(N25/H25))","v":""}]
[null,"Smart Meter Disposition Rider",null,null,null,null,1,0,null,1.42,1,1.42,null,1.42,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C33","v":1.4500000000000001E-2},{"$f":"$F$18","v":286},4.1470000000000002,null,{"$f":"'G. RateDesign'!G46","v":1.3976689220655134E-2},{"$f":"$F$18","v":286},3.9973331171073681,null,-0.14966688289263219,-3.6090398575508123E-2]
[null,"Smart Meter Disposition Rider",null,"per kWh",null,null,286,0,null,null,{"$f":"$F$18","v":286},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kWh",null,null,286,0,null,null,286,0,null,0,""]
[null,null,null,null,null,null,286,{"$f":"G32*F32","v":0},null,null,286,{"$f":"K32*J32","v":0},null,{"$f":"L32-H32","v":0},{"$f":"IF((H32)=0,\"\",(N32/H32))","v":""}]
[null,null,null,null,null,null,286,{"$f":"G33*F33","v":0},null,null,286,{"$f":"K33*J33","v":0},null,{"$f":"L33-H33","v":0},{"$f":"IF((H33)=0,\"\",(N33/H33))","v":""}]
[null,null,null,null,null,null,286,{"$f":"G34*F34","v":0},null,null,286,{"$f":"K34*J34","v":0},null,{"$f":"L34-H34","v":0},{"$f":"IF((H34)=0,\"\",(N34/H34))","v":""}]
[null,null,null,null,null,null,286,0,null,null,286,0,null,0,""]
[null,null,null,null,null,null,286,0,null,null,286,0,null,0,""]
[null,null,null,null,null,null,286,0,null,null,286,0,null,0,""]
[null,null,null,null,null,null,286,0,null,null,286,0,null,0,""]
[null,"Sub-Total A (excluding pass through)",null,null,null,null,null,{"$f":"SUM(H23:H38)","v":18.117000000000001},null,null,null,{"$f":"SUM(L23:L38)","v":23.463464717112934},null,5.3464647171129336,0.2951076180997369]
[null,{"$f":"'L. DVA'!$B$16","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.)"},null,"per kWh",null,null,{"$f":"$F$18","v":286},{"$f":"G40*F40","v":0},null,{"$f":"'L. DVA'!F20","v":3.4037953052852717E-4},{"$f":"$F$18","v":286},{"$f":"K40*J40","v":9.7348545731158767E-2},null,{"$f":"L40-H40","v":9.7348545731158767E-2},""]
[null,{"$f":"'L. DVA'!$B$42","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.) - NON-WMP"},null,"per kWh",null,null,286,0,null,{"$f":"'L. DVA'!F46","v":-1.6111985715856246E-4},286,-4.6080279147348864E-2,null,-4.6080279147348864E-2,""]
[null,{"$f":"'L. DVA'!$B$68","v":"Rate Rider Calculation for RSVA - Power - Global Adjustment"},null,"per kWh",null,null,286,null,null,null,286,0,null,0,""]
[null,{"$f":"'L. DVA'!$B$121","v":"Rate Rider Calculation for Group 2 Accounts"},null,"Monthly",null,null,286,null,null,{"$f":"'L. DVA'!F125","v":0.10172567321463954},1,0.10172567321463954,null,0.10172567321463954,""]
[null,{"$f":"'L. DVA'!$B$147","v":"Rate Rider Calculation for Accounts 1575 and 1576"},null,"per kWh",null,null,286,0,null,{"$f":"'L. DVA'!F153","v":-2.5495760607595745E-3},286,-0.72917875337723825,null,-0.72917875337723825,""]
[null,{"$f":"'L. DVA'!$B$175","v":"Rate Rider Calculation for Accounts 1568"},null,"per kWh",null,null,286,0,null,{"$f":"'L. DVA'!F181","v":1.8574433861791648E-4},286,5.3122880844724114E-2,null,5.3122880844724114E-2,""]
[null,"Low Voltage Charges",null,"per kWh",null,1.1000000000000001E-3,286,0.31460000000000005,null,1.1000000000000001E-3,286,0.31460000000000005,null,0,{"$f":"IF((H46)=0,\"\",(N46/H46))","v":0}]
[null,"Line Losses on Cost of Power",null,"per kWh",null,{"$f":"IF(ISBLANK(D16)=1, 0, IF(D16=\"TOU\", 0.64*$F$57+0.18*$F$58+0.18*$F$59, IF(AND(D16=\"non-TOU\", G61>0), F61,F60)))","v":0.10766000000000001},{"$f":"$F$18*(1+$F$76)-$F$18","v":23.165999999999997},2.4940515599999999,null,{"$f":"0.64*$F$57+0.18*$F$58+0.18*$F$59","v":0.10766000000000001},{"$f":"$F$18*(1+$J$76)-$F$18","v":23.165999999999997},2.4940515599999999,null,0,0]
[null,"Smart Meter Entity Charge",null,"per kWh",null,0.79,1,0.79,null,0.79,1,0.79,null,0]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H40:H48)+H39","v":21.715651560000001},null,null,null,{"$f":"SUM(L40:L48)+L39","v":26.539054344378869},null,4.8234027843788674,{"$f":"IF((H49)=0,\"\",(N49/H49))","v":0.22211642008769031}]
[null,"RTSR - Network",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C45","v":6.4000000000000003E-3},{"$f":"F18*(1+F76)","v":309.166},{"$f":"G50*F50","v":1.9786624000000002},null,6.4052580101589176E-3,{"$f":"F18*(1+J76)","v":309.166},{"$f":"K50*J50","v":1.980287997968792},null,1.6255979687918032E-3,8.2156408733081651E-4]
[null,"RTSR - Line and Transformation Connection",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C46","v":3.3E-3},{"$f":"G50","v":309.166},{"$f":"G51*F51","v":1.0202477999999999},null,3.4685241439288425E-3,{"$f":"K50","v":309.166},{"$f":"K51*J51","v":1.0723497354819045},null,5.210193548190456E-2,5.1067922402679586E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H49:H51)","v":24.714561760000002},null,null,null,{"$f":"SUM(L49:L51)","v":29.591692077829563},null,4.8771303178295611,0.19733832892489697]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,3.5999999999999999E-3,{"$f":"G51","v":309.166},{"$f":"G53*F53","v":1.1129975999999999},null,3.5999999999999999E-3,{"$f":"K51","v":309.166},{"$f":"K53*J53","v":1.1129975999999999},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.2999999999999999E-3,{"$f":"G51","v":309.166},0.40191579999999999,null,1.2999999999999999E-3,{"$f":"K51","v":309.166},0.40191579999999999,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"OEAP",null,"per kWh",null,1.1000000000000001E-3,{"$f":"F18","v":286},0.31460000000000005,null,1.1000000000000001E-3,{"$f":"F18","v":286},0.31460000000000005,null,0,0]
[null,"TOU - Off Peak",null,"per kWh",null,8.3000000000000004E-2,{"$f":"0.64*$F$18","v":183.04},15.19232,null,8.3000000000000004E-2,{"$f":"G57","v":183.04},15.19232,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.128,{"$f":"0.18*$F$18","v":51.48},6.5894399999999997,null,0.128,{"$f":"G58","v":51.48},6.5894399999999997,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.17499999999999999,{"$f":"0.18*$F$18","v":51.48},9.0089999999999986,null,0.17499999999999999,{"$f":"G59","v":51.48},9.0089999999999986,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,9.9000000000000005E-2,{"$f":"IF(AND($T$1=1, F18>=600), 600, IF(AND($T$1=1, AND(F18<600, F18>=0)), F18, IF(AND($T$1=2, F18>=1000), 1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), F18))))","v":286},{"$f":"G60*F60","v":28.314},null,9.9000000000000005E-2,{"$f":"G60","v":286},{"$f":"K60*J60","v":28.314},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,0.11600000000000001,{"$f":"IF(AND($T$1=1, F18>=600), F18-600, IF(AND($T$1=1, AND(F18<600, F18>=0)), 0, IF(AND($T$1=2, F18>=1000), F18-1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), 0))))","v":0},{"$f":"G61*F61","v":0},null,0.11600000000000001,{"$f":"G61","v":0},{"$f":"K61*J61","v":0},null,0,""]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H53:H59,H52)","v":57.584835160000004},null,null,null,{"$f":"SUM(L53:L59,L52)","v":62.461965477829565},null,{"$f":"L63-H63","v":4.8771303178295611},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":8.4694699642334809E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":7.4860285708000012},null,0.13,null,{"$f":"L63*J64","v":8.1200555121178439},null,0.63402694131784276,8.4694699642334781E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":65.070863730799999},null,null,null,{"$f":"L63+L64","v":70.582020989947409},null,5.5111572591474101,8.4694699642334906E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*0.1,2)","v":-6.51},null,null,null,{"$f":"ROUND(-L65*0.1,2)","v":-7.06},null,-0.54999999999999982,8.4485407066052204E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":58.560863730800001},null,null,null,{"$f":"L65+L66","v":63.522020989947407},null,4.9611572591474058,8.4717965943150744E-2]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H60:H61,H52,H53:H56)","v":55.108075159999999},null,null,null,{"$f":"SUM(L60:L61,L52,L53:L56)","v":59.98520547782956},null,{"$f":"L69-H69","v":4.8771303178295611},{"$f":"IF((H69)=0,\"\",(N69/H69))","v":8.8501191588880049E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H69*F70","v":7.1640497708000002},null,0.13,null,{"$f":"L69*J70","v":7.7980767121178429},null,{"$f":"L70-H70","v":0.63402694131784276},{"$f":"IF((H70)=0,\"\",(N70/H70))","v":8.8501191588880007E-2}]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H69+H70","v":62.272124930799997},null,null,null,{"$f":"L69+L70","v":67.7832821899474},null,{"$f":"L71-H71","v":5.511157259147403},{"$f":"IF((H71)=0,\"\",(N71/H71))","v":8.8501191588880021E-2}]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H71*0.1,2)","v":-6.23},null,null,null,{"$f":"ROUND(-L71*0.1,2)","v":-6.78},null,{"$f":"L72-H72","v":-0.54999999999999982},{"$f":"IF((H72)=0,\"\",(N72/H72))","v":8.8282504012841059E-2}]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H71:H72)","v":56.0421249308},null,null,null,{"$f":"SUM(L71:L72)","v":61.003282189947399},null,{"$f":"L73-H73","v":4.9611572591473987},{"$f":"IF((H73)=0,\"\",(N73/H73))","v":8.8525502294450178E-2}]
[]
[]
[null,"Loss Factor (%)",null,null,null,8.1000000000000003E-2,null,null,null,8.1000000000000003E-2]

{"sheet":"Bill Impact - Residential","index":19,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[72,1,72,3],[20,3,21,3],[20,13,21,13],[20,14,21,14],[65,1,65,3],[66,1,66,3],[71,1,71,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[19,5,19,7],[19,9,19,11],[19,13,19,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Residential"]
[]
[null,"TOU / non-TOU:",null,"TOU"]
[]
[null,null,null,"Consumption",null,750," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,{"$f":"'B. CurrentTariff'!C32","v":13.97},1,{"$f":"G23*F23","v":13.97},null,{"$f":"'G. RateDesign'!B46","v":17.91},1,{"$f":"K23*J23","v":17.91},null,{"$f":"L23-H23","v":3.9399999999999995},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":0.28203292770221899}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G24*F24","v":0},null,null,1,{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,{"$f":"'K. SMRR'!G13","v":0.13613160000556787},1,{"$f":"K25*J25","v":0.13613160000556787},null,{"$f":"L25-H25","v":0.13613160000556787},{"$f":"IF((H25)=0,\"\",(N25/H25))","v":""}]
[null,"Smart Meter Disposition Rider",null,null,null,null,1,0,null,1.42,1,1.42,null,1.42,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C33","v":1.4500000000000001E-2},{"$f":"$F$18","v":750},10.875,null,{"$f":"'G. RateDesign'!G46","v":1.3976689220655134E-2},{"$f":"$F$18","v":750},10.482516915491351,null,-0.39248308450864933,-3.6090398575507984E-2]
[null,"Smart Meter Disposition Rider",null,"per kWh",null,null,750,0,null,null,{"$f":"$F$18","v":750},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kWh",null,null,750,0,null,null,750,0,null,0,""]
[null,null,null,null,null,null,750,{"$f":"G32*F32","v":0},null,null,750,{"$f":"K32*J32","v":0},null,{"$f":"L32-H32","v":0},{"$f":"IF((H32)=0,\"\",(N32/H32))","v":""}]
[null,null,null,null,null,null,750,{"$f":"G33*F33","v":0},null,null,750,{"$f":"K33*J33","v":0},null,{"$f":"L33-H33","v":0},{"$f":"IF((H33)=0,\"\",(N33/H33))","v":""}]
[null,null,null,null,null,null,750,{"$f":"G34*F34","v":0},null,null,750,{"$f":"K34*J34","v":0},null,{"$f":"L34-H34","v":0},{"$f":"IF((H34)=0,\"\",(N34/H34))","v":""}]
[null,null,null,null,null,null,750,0,null,null,750,0,null,0,""]
[null,null,null,null,null,null,750,0,null,null,750,0,null,0,""]
[null,null,null,null,null,null,750,0,null,null,750,0,null,0,""]
[null,null,null,null,null,null,750,0,null,null,750,0,null,0,""]
[null,"Sub-Total A (excluding pass through)",null,null,null,null,null,{"$f":"SUM(H23:H38)","v":24.844999999999999},null,null,null,{"$f":"SUM(L23:L38)","v":29.94864851549692},null,5.1036485154969213,0.20541954177890609]
[null,{"$f":"'L. DVA'!$B$16","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.)"},null,"per kWh",null,null,{"$f":"$F$18","v":750},{"$f":"G40*F40","v":0},null,{"$f":"'L. DVA'!F20","v":3.4037953052852717E-4},{"$f":"$F$18","v":750},{"$f":"K40*J40","v":0.25528464789639538},null,{"$f":"L40-H40","v":0.25528464789639538},""]
[null,{"$f":"'L. DVA'!$B$42","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.) - NON-WMP"},null,"per kWh",null,null,750,0,null,{"$f":"'L. DVA'!F46","v":-1.6111985715856246E-4},750,-0.12083989286892184,null,-0.12083989286892184,""]
[null,{"$f":"'L. DVA'!$B$68","v":"Rate Rider Calculation for RSVA - Power - Global Adjustment"},null,"per kWh",null,null,750,null,null,null,750,0,null,0,""]
[null,{"$f":"'L. DVA'!$B$121","v":"Rate Rider Calculation for Group 2 Accounts"},null,"Monthly",null,null,750,null,null,{"$f":"'L. DVA'!F125","v":0.10172567321463954},1,0.10172567321463954,null,0.10172567321463954,""]
[null,{"$f":"'L. DVA'!$B$147","v":"Rate Rider Calculation for Accounts 1575 and 1576"},null,"per kWh",null,null,750,0,null,{"$f":"'L. DVA'!F153","v":-2.5495760607595745E-3},750,-1.9121820455696807,null,-1.9121820455696807,""]
[null,{"$f":"'L. DVA'!$B$175","v":"Rate Rider Calculation for Accounts 1568"},null,"per kWh",null,null,750,0,null,{"$f":"'L. DVA'!F181","v":1.8574433861791648E-4},750,0.13930825396343735,null,0.13930825396343735,""]
[null,"Low Voltage Charges",null,"per kWh",null,1.1000000000000001E-3,750,0.82500000000000007,null,1.1000000000000001E-3,750,0.82500000000000007,null,0,{"$f":"IF((H46)=0,\"\",(N46/H46))","v":0}]
[null,"Line Losses on Cost of Power",null,"per kWh",null,{"$f":"IF(ISBLANK(D16)=1, 0, IF(D16=\"TOU\", 0.64*$F$57+0.18*$F$58+0.18*$F$59, IF(AND(D16=\"non-TOU\", G61>0), F61,F60)))","v":0.10766000000000001},{"$f":"$F$18*(1+$F$76)-$F$18","v":60.75},6.5403450000000003,null,{"$f":"0.64*$F$57+0.18*$F$58+0.18*$F$59","v":0.10766000000000001},{"$f":"$F$18*(1+$J$76)-$F$18","v":60.75},6.5403450000000003,null,0,0]
[null,"Smart Meter Entity Charge",null,"per kWh",null,0.79,1,0.79,null,0.79,1,0.79,null,0]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H40:H48)+H39","v":33.000344999999996},null,null,null,{"$f":"SUM(L40:L48)+L39","v":36.567290152132792},null,3.5669451521327957,{"$f":"IF((H49)=0,\"\",(N49/H49))","v":0.10808811702219465}]
[null,"RTSR - Network",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C45","v":6.4000000000000003E-3},{"$f":"F18*(1+F76)","v":810.75},{"$f":"G50*F50","v":5.1888000000000005},null,6.4052580101589176E-3,{"$f":"F18*(1+J76)","v":810.75},{"$f":"K50*J50","v":5.1930629317363426},null,4.2629317363420682E-3,8.2156408733080242E-4]
[null,"RTSR - Line and Transformation Connection",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C46","v":3.3E-3},{"$f":"G50","v":810.75},{"$f":"G51*F51","v":2.675475},null,3.4685241439288425E-3,{"$f":"K50","v":810.75},{"$f":"K51*J51","v":2.8121059496903089},null,0.13663094969030887,5.1067922402679475E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H49:H51)","v":40.864619999999995},null,null,null,{"$f":"SUM(L49:L51)","v":44.57245903355944},null,3.7078390335594449,9.0734699932593171E-2]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,3.5999999999999999E-3,{"$f":"G51","v":810.75},{"$f":"G53*F53","v":2.9186999999999999},null,3.5999999999999999E-3,{"$f":"K51","v":810.75},{"$f":"K53*J53","v":2.9186999999999999},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.2999999999999999E-3,{"$f":"G51","v":810.75},1.0539749999999999,null,1.2999999999999999E-3,{"$f":"K51","v":810.75},1.0539749999999999,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"OEAP",null,"per kWh",null,1.1000000000000001E-3,{"$f":"F18","v":750},0.82500000000000007,null,1.1000000000000001E-3,{"$f":"F18","v":750},0.82500000000000007,null,0,0]
[null,"TOU - Off Peak",null,"per kWh",null,8.3000000000000004E-2,{"$f":"0.64*$F$18","v":480},39.840000000000003,null,8.3000000000000004E-2,{"$f":"G57","v":480},39.840000000000003,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.128,{"$f":"0.18*$F$18","v":135},17.28,null,0.128,{"$f":"G58","v":135},17.28,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.17499999999999999,{"$f":"0.18*$F$18","v":135},23.625,null,0.17499999999999999,{"$f":"G59","v":135},23.625,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,9.9000000000000005E-2,{"$f":"IF(AND($T$1=1, F18>=600), 600, IF(AND($T$1=1, AND(F18<600, F18>=0)), F18, IF(AND($T$1=2, F18>=1000), 1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), F18))))","v":600},{"$f":"G60*F60","v":59.400000000000006},null,9.9000000000000005E-2,{"$f":"G60","v":600},{"$f":"K60*J60","v":59.400000000000006},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,0.11600000000000001,{"$f":"IF(AND($T$1=1, F18>=600), F18-600, IF(AND($T$1=1, AND(F18<600, F18>=0)), 0, IF(AND($T$1=2, F18>=1000), F18-1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), 0))))","v":150},{"$f":"G61*F61","v":17.400000000000002},null,0.11600000000000001,{"$f":"G61","v":150},{"$f":"K61*J61","v":17.400000000000002},null,0,0]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H53:H59,H52)","v":126.657295},null,null,null,{"$f":"SUM(L53:L59,L52)","v":130.36513403355946},null,{"$f":"L63-H63","v":3.707839033559452},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":2.9274579356518327E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":16.465448350000003},null,0.13,null,{"$f":"L63*J64","v":16.947467424362731},null,0.48201907436272862,2.9274579356518313E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":143.12274335000001},null,null,null,{"$f":"L63+L64","v":147.3126014579222},null,4.1898581079221913,2.92745793565184E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*0.1,2)","v":-14.31},null,null,null,{"$f":"ROUND(-L65*0.1,2)","v":-14.73},null,-0.41999999999999993,2.935010482180293E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":128.81274335000001},null,null,null,{"$f":"L65+L66","v":132.58260145792221},null,3.7698581079222038,2.9266189119806552E-2]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H60:H61,H52,H53:H56)","v":122.71229500000001},null,null,null,{"$f":"SUM(L60:L61,L52,L53:L56)","v":126.42013403355945},null,{"$f":"L69-H69","v":3.7078390335594378},{"$f":"IF((H69)=0,\"\",(N69/H69))","v":3.0215709302474029E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H69*F70","v":15.952598350000002},null,0.13,null,{"$f":"L69*J70","v":16.434617424362727},null,{"$f":"L70-H70","v":0.48201907436272506},{"$f":"IF((H70)=0,\"\",(N70/H70))","v":3.0215709302473914E-2}]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H69+H70","v":138.66489335},null,null,null,{"$f":"L69+L70","v":142.85475145792219},null,{"$f":"L71-H71","v":4.1898581079221913},{"$f":"IF((H71)=0,\"\",(N71/H71))","v":3.0215709302474223E-2}]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H71*0.1,2)","v":-13.87},null,null,null,{"$f":"ROUND(-L71*0.1,2)","v":-14.29},null,{"$f":"L72-H72","v":-0.41999999999999993},{"$f":"IF((H72)=0,\"\",(N72/H72))","v":3.0281182408074977E-2}]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H71:H72)","v":124.79489335},null,null,null,{"$f":"SUM(L71:L72)","v":128.5647514579222},null,{"$f":"L73-H73","v":3.7698581079222038},{"$f":"IF((H73)=0,\"\",(N73/H73))","v":3.0208432466457203E-2}]
[]
[]
[null,"Loss Factor (%)",null,null,null,8.1000000000000003E-2,null,null,null,8.1000000000000003E-2]

{"sheet":"Bill Impact - GS<50","index":20,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[72,1,72,3],[20,3,21,3],[20,13,21,13],[20,14,21,14],[65,1,65,3],[66,1,66,3],[71,1,71,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[19,5,19,7],[19,9,19,11],[19,13,19,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"General Service < 50KW"]
[]
[null,"TOU / non-TOU:",null,"TOU"]
[]
[null,null,null,"Consumption",null,2000," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,{"$f":"'B. CurrentTariff'!C53","v":31.25},1,{"$f":"G23*F23","v":31.25},null,{"$f":"'G. RateDesign'!B47","v":31.25},1,{"$f":"K23*J23","v":31.25},null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":0}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G24*F24","v":0},null,null,1,{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,{"$f":"'K. SMRR'!G14","v":0.24356622638421221},1,{"$f":"K25*J25","v":0.24356622638421221},null,{"$f":"L25-H25","v":0.24356622638421221},{"$f":"IF((H25)=0,\"\",(N25/H25))","v":""}]
[null,"Smart Meter Disposition Rider",null,"Monthly",null,null,1,0,null,3.1,1,3.1,null,3.1,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C54","v":1.37E-2},{"$f":"$F$18","v":2000},27.400000000000002,null,{"$f":"'G. RateDesign'!G47","v":1.8040240945143494E-2},{"$f":"$F$18","v":2000},36.08048189028699,null,8.6804818902869876,0.31680590840463457]
[null,"Smart Meter Disposition Rider",null,"per kWh",null,null,2000,0,null,null,{"$f":"$F$18","v":2000},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kWh",null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,{"$f":"G32*F32","v":0},null,null,2000,{"$f":"K32*J32","v":0},null,{"$f":"L32-H32","v":0},{"$f":"IF((H32)=0,\"\",(N32/H32))","v":""}]
[null,null,null,null,null,null,2000,{"$f":"G33*F33","v":0},null,null,2000,{"$f":"K33*J33","v":0},null,{"$f":"L33-H33","v":0},{"$f":"IF((H33)=0,\"\",(N33/H33))","v":""}]
[null,null,null,null,null,null,2000,{"$f":"G34*F34","v":0},null,null,2000,{"$f":"K34*J34","v":0},null,{"$f":"L34-H34","v":0},{"$f":"IF((H34)=0,\"\",(N34/H34))","v":""}]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,"Sub-Total A (excluding pass through)",null,null,null,null,null,{"$f":"SUM(H23:H38)","v":58.650000000000006},null,null,null,{"$f":"SUM(L23:L38)","v":70.674048116671202},null,12.024048116671196,0.20501360812738609]
[null,{"$f":"'L. DVA'!$B$16","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.)"},null,"per kWh",null,null,{"$f":"$F$18","v":2000},{"$f":"G40*F40","v":0},null,{"$f":"'L. DVA'!F21","v":3.4030199518457824E-4},{"$f":"$F$18","v":2000},{"$f":"K40*J40","v":0.68060399036915653},null,{"$f":"L40-H40","v":0.68060399036915653},{"$f":"IF((H40)=0,\"\",(N40/H40))","v":""}]
[null,{"$f":"'L. DVA'!$B$42","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.) - NON-WMP"},null,"per kWh",null,null,2000,0,null,{"$f":"'L. DVA'!F47","v":-1.6111985715856246E-4},2000,-0.32223971431712489,null,-0.32223971431712489,{"$f":"IF((H41)=0,\"\",(N41/H41))","v":""}]
[null,{"$f":"'L. DVA'!$B$68","v":"Rate Rider Calculation for RSVA - Power - Global Adjustment"},null,null,null,null,2000,null,null,0,2000,0,null,0]
[null,{"$f":"'L. DVA'!$B$121","v":"Rate Rider Calculation for Group 2 Accounts"},null,null,null,null,2000,null,null,{"$f":"'L. DVA'!F126","v":1.6182341928445236E-4},2000,0.32364683856890469,null,0.32364683856890469]
[null,{"$f":"'L. DVA'!$B$147","v":"Rate Rider Calculation for Accounts 1575 and 1576"},null,"per kWh",null,null,2000,0,null,{"$f":"'L. DVA'!F154","v":-2.5495760607595745E-3},2000,-5.0991521215191487,null,-5.0991521215191487,{"$f":"IF((H44)=0,\"\",(N44/H44))","v":""}]
[null,{"$f":"'L. DVA'!$B$175","v":"Rate Rider Calculation for Accounts 1568"},null,"per kWh",null,null,2000,0,null,{"$f":"'L. DVA'!F182","v":1.8574433861791648E-4},2000,0.37148867723583295,null,0.37148867723583295,{"$f":"IF((H45)=0,\"\",(N45/H45))","v":""}]
[" ","Low Voltage Charges",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C56","v":1E-3},2000,2,null,1E-3,2000,2,null,0,{"$f":"IF((H46)=0,\"\",(N46/H46))","v":0}]
[null,"Line Losses on Cost of Power",null,"per kWh",null,{"$f":"IF(ISBLANK(D16)=1, 0, IF(D16=\"TOU\", 0.64*$F$57+0.18*$F$58+0.18*$F$59, IF(AND(D16=\"non-TOU\", G61>0), F61,F60)))","v":0.10766000000000001},{"$f":"$F$18*(1+$F$76)-$F$18","v":162},17.440920000000002,null,{"$f":"0.64*$F$57+0.18*$F$58+0.18*$F$59","v":0.10766000000000001},{"$f":"$F$18*(1+$J$76)-$F$18","v":162},{"$f":"K47*J47","v":17.440920000000002},null,0,0]
[null,"Smart Meter Entity Charge",null,"per kWh",null,0.79,1,0.79,null,0.79,1,{"$f":"K48*J48","v":0.79},null,0]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H40:H48)+H39","v":78.880920000000003},null,null,null,{"$f":"SUM(L40:L48)+L39","v":86.859315787008825},null,7.9783957870088216,{"$f":"IF((H49)=0,\"\",(N49/H49))","v":0.10114481153375013}]
[null,"RTSR - Network",null,"per kWh",null,5.7999999999999996E-3,{"$f":"F18*(1+F76)","v":2162},{"$f":"G50*F50","v":12.539599999999998},null,5.8047648614089316E-3,{"$f":"F18*(1+J76)","v":2162},{"$f":"K50*J50","v":12.54990163036611},null,1.0301630366111425E-2,8.2152782912624223E-4]
[null,"RTSR - Line and Transformation Connection",null,"per kWh",null,4.0000000000000001E-3,{"$f":"G50","v":2162},{"$f":"G51*F51","v":8.6479999999999997},null,3.2583104303272213E-3,{"$f":"K50","v":2162},{"$f":"K51*J51","v":7.0444671503674527},null,-1.6035328496325469,-0.18542239241819461]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H49:H51)","v":100.06851999999999},null,null,null,{"$f":"SUM(L49:L51)","v":106.45368456774239},null,6.3851645677423932,6.380792448756506E-2]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,3.5999999999999999E-3,{"$f":"G51","v":2162},{"$f":"G53*F53","v":7.7831999999999999},null,3.5999999999999999E-3,{"$f":"K51","v":2162},{"$f":"K53*J53","v":7.7831999999999999},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.2999999999999999E-3,{"$f":"G51","v":2162},2.8106,null,1.2999999999999999E-3,{"$f":"K51","v":2162},2.8106,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"OEAP",null,"per kWh",null,1.1000000000000001E-3,{"$f":"F18","v":2000},2.2000000000000002,null,1.1000000000000001E-3,{"$f":"F18","v":2000},2.2000000000000002,null,0,0]
[null,"TOU - Off Peak",null,"per kWh",null,8.3000000000000004E-2,{"$f":"0.64*$F$18","v":1280},106.24000000000001,null,8.3000000000000004E-2,{"$f":"G57","v":1280},106.24000000000001,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.128,{"$f":"0.18*$F$18","v":360},46.08,null,0.128,{"$f":"G58","v":360},46.08,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.17499999999999999,{"$f":"0.18*$F$18","v":360},62.999999999999993,null,0.17499999999999999,{"$f":"G59","v":360},62.999999999999993,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,9.9000000000000005E-2,{"$f":"IF(AND($T$1=1, F18>=600), 600, IF(AND($T$1=1, AND(F18<600, F18>=0)), F18, IF(AND($T$1=2, F18>=1000), 1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), F18))))","v":600},{"$f":"G60*F60","v":59.400000000000006},null,9.9000000000000005E-2,{"$f":"G60","v":600},{"$f":"K60*J60","v":59.400000000000006},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,0.11600000000000001,{"$f":"IF(AND($T$1=1, F18>=600), F18-600, IF(AND($T$1=1, AND(F18<600, F18>=0)), 0, IF(AND($T$1=2, F18>=1000), F18-1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), 0))))","v":1400},{"$f":"G61*F61","v":162.4},null,0.11600000000000001,{"$f":"G61","v":1400},{"$f":"K61*J61","v":162.4},null,0,0]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H53:H59,H52)","v":328.43232},null,null,null,{"$f":"SUM(L53:L59,L52)","v":334.81748456774244},null,{"$f":"L63-H63","v":6.3851645677424358},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":1.9441340510405417E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":42.696201600000002},null,0.13,null,{"$f":"L63*J64","v":43.526272993806522},null,0.83007139380652006,1.9441340510405497E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":371.1285216},null,null,null,{"$f":"L63+L64","v":378.34375756154895},null,7.2152359615489559,1.9441340510405428E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*0.1,2)","v":-37.11},null,null,null,{"$f":"ROUND(-L65*0.1,2)","v":-37.83},null,-0.71999999999999886,1.9401778496362137E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":334.01852159999999},null,null,null,{"$f":"L65+L66","v":340.51375756154897},null,6.4952359615489854,1.9445735914391239E-2]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H60:H61,H52,H53:H56)","v":334.91232000000002},null,null,null,{"$f":"SUM(L60:L61,L52,L53:L56)","v":341.29748456774246},null,{"$f":"L69-H69","v":6.3851645677424358},{"$f":"IF((H69)=0,\"\",(N69/H69))","v":1.9065182695406472E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H69*F70","v":43.538601600000007},null,0.13,null,{"$f":"L69*J70","v":44.36867299380652},null,{"$f":"L70-H70","v":0.83007139380651296},{"$f":"IF((H70)=0,\"\",(N70/H70))","v":1.9065182695406385E-2}]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H69+H70","v":378.45092160000002},null,null,null,{"$f":"L69+L70","v":385.66615756154897},null,{"$f":"L71-H71","v":7.2152359615489559},{"$f":"IF((H71)=0,\"\",(N71/H71))","v":1.9065182695406482E-2}]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H71*0.1,2)","v":-37.85},null,null,null,{"$f":"ROUND(-L71*0.1,2)","v":-38.57},null,{"$f":"L72-H72","v":-0.71999999999999886},{"$f":"IF((H72)=0,\"\",(N72/H72))","v":1.9022457067371171E-2}]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H71:H72)","v":340.60092159999999},null,null,null,{"$f":"SUM(L71:L72)","v":347.09615756154898},null,{"$f":"L73-H73","v":6.4952359615489854},{"$f":"IF((H73)=0,\"\",(N73/H73))","v":1.9069930671464706E-2}]
[]
[]
[null,"Loss Factor (%)",null,null,null,8.1000000000000003E-2,null,null,null,8.1000000000000003E-2]

{"sheet":"Bill Impact - GS>50","index":21,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[72,1,72,3],[20,3,21,3],[20,13,21,13],[20,14,21,14],[65,1,65,3],[66,1,66,3],[71,1,71,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[19,5,19,7],[19,9,19,11],[19,13,19,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"General Service > 50KW"]
[]
[null,"TOU / non-TOU:",null,"TOU"]
[]
[null,null,null,"Consumption",null,100," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,{"$f":"'B. CurrentTariff'!C74","v":189.27},1,{"$f":"G23*F23","v":189.27},null,{"$f":"'G. RateDesign'!B48","v":189.27},1,{"$f":"K23*J23","v":189.27},null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":0}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G24*F24","v":0},null,null,1,{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,{"$f":"'K. SMRR'!G15","v":4.822114332763932},1,{"$f":"K25*J25","v":4.822114332763932},null,{"$f":"L25-H25","v":4.822114332763932},{"$f":"IF((H25)=0,\"\",(N25/H25))","v":""}]
[null,"Smart Meter Disposition Rider",null,null,null,null,1,0,null,11.6,1,11.6,null,11.6,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,{"$f":"'B. CurrentTariff'!C75","v":2.5331000000000001},{"$f":"$F$18","v":100},253.31,null,{"$f":"'G. RateDesign'!G48","v":3.1921101160778975},{"$f":"$F$18","v":100},319.21101160778977,null,65.901011607789769,0.26015953419837262]
[null,"Smart Meter Disposition Rider",null,"per kW",null,null,100,0,null,null,{"$f":"$F$18","v":100},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,null,100,0,null,null,100,0,null,0,""]
[null,null,null,null,null,null,100,{"$f":"G32*F32","v":0},null,null,100,{"$f":"K32*J32","v":0},null,{"$f":"L32-H32","v":0},{"$f":"IF((H32)=0,\"\",(N32/H32))","v":""}]
[null,null,null,null,null,null,100,{"$f":"G33*F33","v":0},null,null,100,{"$f":"K33*J33","v":0},null,{"$f":"L33-H33","v":0},{"$f":"IF((H33)=0,\"\",(N33/H33))","v":""}]
[null,null,null,null,null,null,100,{"$f":"G34*F34","v":0},null,null,100,{"$f":"K34*J34","v":0},null,{"$f":"L34-H34","v":0},{"$f":"IF((H34)=0,\"\",(N34/H34))","v":""}]
[null,null,null,null,null,null,100,0,null,null,100,0,null,0,""]
[null,null,null,null,null,null,100,0,null,null,100,0,null,0,""]
[null,null,null,null,null,null,100,0,null,null,100,0,null,0,""]
[null,null,null,null,null,null,100,0,null,null,100,0,null,0,""]
[null,"Sub-Total A (excluding pass through)",null,null,null,null,null,{"$f":"SUM(H23:H38)","v":442.58000000000004},null,null,null,{"$f":"SUM(L23:L38)","v":524.90312594055376},null,82.323125940553723,0.18600733413293352]
[null,{"$f":"'L. DVA'!$B$16","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.)"},null,"per kW",null,null,{"$f":"$F$18","v":100},{"$f":"G40*F40","v":0},null,{"$f":"'L. DVA'!F22","v":0.12948642903876625},{"$f":"$F$18","v":100},{"$f":"K40*J40","v":12.948642903876625},null,{"$f":"L40-H40","v":12.948642903876625},{"$f":"IF((H40)=0,\"\",(N40/H40))","v":""}]
[null,{"$f":"'L. DVA'!$B$42","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.) - NON-WMP"},null,"per kW",null,null,100,0,null,{"$f":"'L. DVA'!F48","v":-5.9293694608045851E-2},100,-5.929369460804585,null,-5.929369460804585,""]
[null,{"$f":"'L. DVA'!$B$68","v":"Rate Rider Calculation for RSVA - Power - Global Adjustment"},null,"per kWh",null,null,100,null,null,{"$f":"'L. DVA'!F74","v":0.34616977280651701},100,34.616977280651703,null,34.616977280651703,""]
[null,{"$f":"'L. DVA'!$B$121","v":"Rate Rider Calculation for Group 2 Accounts"},null,"per kWh",null,null,100,null,null,{"$f":"'L. DVA'!F127","v":5.9552612401085149E-2},100,5.9552612401085145,null,5.9552612401085145,""]
[null,{"$f":"'L. DVA'!$B$147","v":"Rate Rider Calculation for Accounts 1575 and 1576"},null,"per kW",null,null,100,0,null,{"$f":"'L. DVA'!F155","v":-0.93826910594817914},100,-93.826910594817917,null,-93.826910594817917,""]
[null,{"$f":"'L. DVA'!$B$175","v":"Rate Rider Calculation for Accounts 1568"},null,"per kW",null,null,100,0,null,{"$f":"'L. DVA'!F183","v":6.8355746358101238E-2},100,6.8355746358101239,null,6.8355746358101239,""]
[null,"Low Voltage Charges",null,"per kW",null,0.39539999999999997,100,39.54,null,0.37330000000000002,100,37.330000000000005,null,-2.2099999999999937,-5.5892766818411578E-2]
[null,"Line Losses on Cost of Power",null,"per kW",null,{"$f":"IF(ISBLANK(D16)=1, 0, IF(D16=\"TOU\", 0.64*$F$57+0.18*$F$58+0.18*$F$59, IF(AND(D16=\"non-TOU\", G61>0), F61,F60)))","v":0.10766000000000001},{"$f":"$F$18*(1+$F$76)-$F$18","v":8.0999999999999943},0.87204599999999943,null,{"$f":"0.64*$F$57+0.18*$F$58+0.18*$F$59","v":0.10766000000000001},{"$f":"$F$18*(1+$J$76)-$F$18","v":8.0999999999999943},0.87204599999999943,null,0,0]
[null,"Smart Meter Entity Charge",null,"per kW",null,0.79,1,0.79,null,0.79,1,0.79,null,0]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H40:H48)+H39","v":483.78204600000004},null,null,null,{"$f":"SUM(L40:L48)+L39","v":524.49534794537828},null,40.713301945378248,{"$f":"IF((H49)=0,\"\",(N49/H49))","v":8.4156289556430217E-2}]
[null,"RTSR - Network",null,"per kW",null,2.3683000000000001,{"$f":"F18*(1+F76)","v":108.1},{"$f":"G50*F50","v":256.01323000000002},null,2.3687444459173985,{"$f":"F18*(1+J76)","v":108.1},{"$f":"K50*J50","v":256.06127460367077},null,4.8044603670746255E-2,1.8766453464434728E-4]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,1.5959000000000001,{"$f":"G50","v":108.1},{"$f":"G51*F51","v":172.51679000000001},null,1.2156652521185711,{"$f":"K50","v":108.1},{"$f":"K51*J51","v":131.41341375401754},null,-41.103376245982474,-0.23825725163320319]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H49:H51)","v":912.31206600000007},null,null,null,{"$f":"SUM(L49:L51)","v":911.97003630306654},null,-0.3420296969335368,-3.7490427856901412E-4]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,3.5999999999999999E-3,{"$f":"G51","v":108.1},{"$f":"G53*F53","v":0.38915999999999995},null,3.5999999999999999E-3,{"$f":"K51","v":108.1},{"$f":"K53*J53","v":0.38915999999999995},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.2999999999999999E-3,{"$f":"G51","v":108.1},0.14052999999999999,null,1.2999999999999999E-3,{"$f":"K51","v":108.1},0.14052999999999999,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"OEAP",null,"per kWh",null,1.1000000000000001E-3,{"$f":"F18","v":100},0.11,null,1.1000000000000001E-3,{"$f":"F18","v":100},0.11,null,0,0]
[null,"TOU - Off Peak",null,"per kWh",null,8.3000000000000004E-2,{"$f":"0.64*$F$18","v":64},5.3120000000000003,null,8.3000000000000004E-2,{"$f":"G57","v":64},5.3120000000000003,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.128,{"$f":"0.18*$F$18","v":18},2.3040000000000003,null,0.128,{"$f":"G58","v":18},2.3040000000000003,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.17499999999999999,{"$f":"0.18*$F$18","v":18},3.15,null,0.17499999999999999,{"$f":"G59","v":18},3.15,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,9.9000000000000005E-2,{"$f":"IF(AND($T$1=1, F18>=600), 600, IF(AND($T$1=1, AND(F18<600, F18>=0)), F18, IF(AND($T$1=2, F18>=1000), 1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), F18))))","v":100},{"$f":"G60*F60","v":9.9},null,9.9000000000000005E-2,{"$f":"G60","v":100},{"$f":"K60*J60","v":9.9},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,0.11600000000000001,{"$f":"IF(AND($T$1=1, F18>=600), F18-600, IF(AND($T$1=1, AND(F18<600, F18>=0)), 0, IF(AND($T$1=2, F18>=1000), F18-1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), 0))))","v":0},{"$f":"G61*F61","v":0},null,0.11600000000000001,{"$f":"G61","v":0},{"$f":"K61*J61","v":0},null,0,""]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H53:H59,H52)","v":923.96775600000012},null,null,null,{"$f":"SUM(L53:L59,L52)","v":923.62572630306659},null,{"$f":"L63-H63","v":-0.3420296969335368},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":-3.7017492733105371E-4}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":120.11580828000002},null,0.13,null,{"$f":"L63*J64","v":120.07134441939866},null,-4.446386060136831E-2,-3.7017492733112467E-4]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":1044.0835642800002},null,null,null,{"$f":"L63+L64","v":1043.6970707224652},null,-0.38649355753500458,-3.7017492733115709E-4]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*0.1,2)","v":-104.41},null,null,null,{"$f":"ROUND(-L65*0.1,2)","v":-104.37},null,3.9999999999992042E-2,-3.8310506656442911E-4]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":939.67356428000028},null,null,null,{"$f":"L65+L66","v":939.32707072246524},null,-0.34649355753504096,-3.6873822006531853E-4]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H60:H61,H52,H53:H56)","v":923.10175600000002},null,null,null,{"$f":"SUM(L60:L61,L52,L53:L56)","v":922.75972630306649},null,{"$f":"L69-H69","v":-0.3420296969335368},{"$f":"IF((H69)=0,\"\",(N69/H69))","v":-3.7052220376616505E-4}]
[null,"HST",null,null,null,0.13,null,{"$f":"H69*F70","v":120.00322828},null,0.13,null,{"$f":"L69*J70","v":119.95876441939865},null,{"$f":"L70-H70","v":-4.4463860601354099E-2},{"$f":"IF((H70)=0,\"\",(N70/H70))","v":-3.7052220376611772E-4}]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H69+H70","v":1043.1049842800001},null,null,null,{"$f":"L69+L70","v":1042.718490722465},null,{"$f":"L71-H71","v":-0.38649355753500458},{"$f":"IF((H71)=0,\"\",(N71/H71))","v":-3.7052220376626859E-4}]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H71*0.1,2)","v":-104.31},null,null,null,{"$f":"ROUND(-L71*0.1,2)","v":-104.27},null,{"$f":"L72-H72","v":4.0000000000006253E-2},{"$f":"IF((H72)=0,\"\",(N72/H72))","v":-3.8347234205738908E-4}]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H71:H72)","v":938.79498428000011},null,null,null,{"$f":"SUM(L71:L72)","v":938.44849072246507},null,{"$f":"L73-H73","v":-0.34649355753504096},{"$f":"IF((H73)=0,\"\",(N73/H73))","v":-3.6908330715122099E-4}]
[]
[]
[null,"Loss Factor (%)",null,null,null,8.1000000000000003E-2,null,null,null,8.1000000000000003E-2]

{"sheet":"Bill Impact - StreetLight","index":22,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[72,1,72,3],[20,3,21,3],[20,13,21,13],[20,14,21,14],[65,1,65,3],[66,1,66,3],[71,1,71,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[19,5,19,7],[19,9,19,11],[19,13,19,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"StreetLight"]
[]
[null,"TOU / non-TOU:",null,"TOU"]
[]
[null,null,null,"Consumption",null,115,"kW"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,{"$f":"'B. CurrentTariff'!C116","v":2.95},2300,{"$f":"G23*F23","v":6785},null,{"$f":"'G. RateDesign'!B50","v":2.82},2300,{"$f":"K23*J23","v":6486},null,{"$f":"L23-H23","v":-299},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":-4.4067796610169491E-2}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G24*F24","v":0},null,null,1,{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,null,null,null,null,null,1,0,null,null,1,{"$f":"K25*J25","v":0},null,{"$f":"L25-H25","v":0},{"$f":"IF((H25)=0,\"\",(N25/H25))","v":""}]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,{"$f":"'B. CurrentTariff'!C117","v":7.2483000000000004},{"$f":"$F$18","v":115},833.55450000000008,null,{"$f":"'G. RateDesign'!G50","v":6.9247617143185618},{"$f":"$F$18","v":115},796.3475971466346,null,-37.206902853365477,-4.463643691368168E-2]
[null,"Smart Meter Disposition Rider",null,"per kW",null,null,115,0,null,null,{"$f":"$F$18","v":115},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,null,115,0,null,null,115,0,null,0,""]
[null,"Stranded Meter Rate Rider",null,null,null,null,115,{"$f":"G32*F32","v":0},null,null,115,{"$f":"K32*J32","v":0},null,{"$f":"L32-H32","v":0},{"$f":"IF((H32)=0,\"\",(N32/H32))","v":""}]
[null,null,null,null,null,null,115,{"$f":"G33*F33","v":0},null,null,115,{"$f":"K33*J33","v":0},null,{"$f":"L33-H33","v":0},{"$f":"IF((H33)=0,\"\",(N33/H33))","v":""}]
[null,null,null,null,null,null,115,{"$f":"G34*F34","v":0},null,null,115,{"$f":"K34*J34","v":0},null,{"$f":"L34-H34","v":0},{"$f":"IF((H34)=0,\"\",(N34/H34))","v":""}]
[null,null,null,null,null,null,115,0,null,null,115,0,null,0,""]
[null,null,null,null,null,null,115,0,null,null,115,0,null,0,""]
[null,null,null,null,null,null,115,0,null,null,115,0,null,0,""]
[null,null,null,null,null,null,115,0,null,null,115,0,null,0,""]
[null,"Sub-Total A (excluding pass through)",null,null,null,null,null,{"$f":"SUM(H23:H38)","v":7618.5545000000002},null,null,null,{"$f":"SUM(L23:L38)","v":7282.3475971466341},null,-336.20690285336605,-4.4130012176636139E-2]
[null,{"$f":"'L. DVA'!$B$16","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.)"},null,"per kW",null,null,{"$f":"$F$18","v":115},{"$f":"G40*F40","v":0},null,{"$f":"'L. DVA'!F24","v":0.12662563900361723},{"$f":"$F$18","v":115},{"$f":"K40*J40","v":14.561948485415982},null,{"$f":"L40-H40","v":14.561948485415982},{"$f":"IF((H40)=0,\"\",(N40/H40))","v":""}]
[null,{"$f":"'L. DVA'!$B$42","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.) - NON-WMP"},null,"per kW",null,null,115,0,null,{"$f":"'L. DVA'!F50","v":-5.7983697784895517E-2},115,-6.6681252452629849,null,-6.6681252452629849,""]
[null,{"$f":"'L. DVA'!$B$68","v":"Rate Rider Calculation for RSVA - Power - Global Adjustment"},null,"per kW",null,null,115,null,null,{"$f":"'L. DVA'!F76","v":0.33852172008109832},115,38.929997809326309,null,38.929997809326309,""]
[null,{"$f":"'L. DVA'!$B$121","v":"Rate Rider Calculation for Group 2 Accounts"},null,"per kW",null,null,115,null,null,{"$f":"'L. DVA'!F129","v":5.8236895214436118E-2},115,6.6972429496601533,null,6.6972429496601533,""]
[null,{"$f":"'L. DVA'!$B$147","v":"Rate Rider Calculation for Accounts 1575 and 1576"},null,"per kW",null,null,115,0,null,{"$f":"'L. DVA'!F157","v":-0.91753959067379398},115,-105.5170529274863,null,-105.5170529274863,""]
[null,{"$f":"'L. DVA'!$B$175","v":"Rate Rider Calculation for Accounts 1568"},null,"per kW",null,null,115,0,null,{"$f":"'L. DVA'!F185","v":6.6845538381264655E-2},115,7.6872369138454353,null,7.6872369138454353,""]
[" ","Low Voltage Charges",null,"per kW",null,0.30570000000000003,115,35.155500000000004,null,0.28849999999999998,115,33.177499999999995,null,-1.9780000000000086,-5.6264311416421568E-2]
[null,"Line Losses on Cost of Power",null,"per kW",null,{"$f":"IF(ISBLANK(D16)=1, 0, IF(D16=\"TOU\", 0.64*$F$57+0.18*$F$58+0.18*$F$59, IF(AND(D16=\"non-TOU\", G61>0), F61,F60)))","v":0.10766000000000001},{"$f":"$F$18*(1+$F$76)-$F$18","v":9.3149999999999977},1.0028528999999997,null,{"$f":"0.64*$F$57+0.18*$F$58+0.18*$F$59","v":0.10766000000000001},{"$f":"$F$18*(1+$J$76)-$F$18","v":9.3149999999999977},1.0028528999999997,null,0,0]
[null,"Smart Meter Entity Charge",null,"per kW",null,0.79,1,0.79,null,0.79,1,0.79,null,0]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H40:H48)+H39","v":7655.5028529000001},null,null,null,{"$f":"SUM(L40:L48)+L39","v":7273.0091980321331},null,-382.49365486786701,{"$f":"IF((H49)=0,\"\",(N49/H49))","v":-4.9963230661324048E-2}]
[null,"RTSR - Network",null,"per kW",null,1.786,{"$f":"F18*(1+F76)","v":124.315},{"$f":"G50*F50","v":222.02659},null,1.7863680248851845,{"$f":"F18*(1+J76)","v":124.315},{"$f":"K50*J50","v":222.07234101360172},null,4.5751013601716295E-2,2.0606096594879151E-4]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,1.2338,{"$f":"G50","v":124.315},{"$f":"G51*F51","v":153.37984700000001},null,0.93976080978292686,{"$f":"K50","v":124.315},{"$f":"K51*J51","v":116.82636506816455},null,-36.553481931835464,-0.23831997910283129]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H49:H51)","v":8030.9092899000007},null,null,null,{"$f":"SUM(L49:L51)","v":7611.9079041138993},null,-419.00138578610131,-5.21735921376991E-2]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,3.5999999999999999E-3,{"$f":"G51","v":124.315},{"$f":"G53*F53","v":0.44753399999999999},null,3.5999999999999999E-3,{"$f":"K51","v":124.315},{"$f":"K53*J53","v":0.44753399999999999},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.2999999999999999E-3,{"$f":"G51","v":124.315},0.16160949999999999,null,1.2999999999999999E-3,{"$f":"K51","v":124.315},0.16160949999999999,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"OEAP",null,"per kWh",null,1.1000000000000001E-3,{"$f":"F18","v":115},0.1265,null,1.1000000000000001E-3,{"$f":"F18","v":115},0.1265,null,0,0]
[null,"TOU - Off Peak",null,"per kWh",null,8.3000000000000004E-2,{"$f":"0.64*$F$18","v":73.600000000000009},6.1088000000000013,null,8.3000000000000004E-2,{"$f":"G57","v":73.600000000000009},6.1088000000000013,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.128,{"$f":"0.18*$F$18","v":20.7},2.6496,null,0.128,{"$f":"G58","v":20.7},2.6496,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.17499999999999999,{"$f":"0.18*$F$18","v":20.7},3.6224999999999996,null,0.17499999999999999,{"$f":"G59","v":20.7},3.6224999999999996,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,9.9000000000000005E-2,{"$f":"IF(AND($T$1=1, F18>=600), 600, IF(AND($T$1=1, AND(F18<600, F18>=0)), F18, IF(AND($T$1=2, F18>=1000), 1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), F18))))","v":115},{"$f":"G60*F60","v":11.385},null,9.9000000000000005E-2,{"$f":"G60","v":115},{"$f":"K60*J60","v":11.385},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,0.11600000000000001,{"$f":"IF(AND($T$1=1, F18>=600), F18-600, IF(AND($T$1=1, AND(F18<600, F18>=0)), 0, IF(AND($T$1=2, F18>=1000), F18-1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), 0))))","v":0},{"$f":"G61*F61","v":0},null,0.11600000000000001,{"$f":"G61","v":0},{"$f":"K61*J61","v":0},null,0,""]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H53:H59,H52)","v":8044.2758334000009},null,null,null,{"$f":"SUM(L53:L59,L52)","v":7625.2744476138996},null,{"$f":"L63-H63","v":-419.00138578610131},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":-5.2086899363445349E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":1045.7558583420002},null,0.13,null,{"$f":"L63*J64","v":991.28567818980696},null,-54.470180152193279,-5.2086899363445446E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":9090.0316917420005},null,null,null,{"$f":"L63+L64","v":8616.5601258037059},null,-473.47156593829459,-5.2086899363445363E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*0.1,2)","v":-909},null,null,null,{"$f":"ROUND(-L65*0.1,2)","v":-861.66},null,47.340000000000032,-5.2079207920792112E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":8181.0316917420005},null,null,null,{"$f":"L65+L66","v":7754.900125803706},null,-426.13156593829444,-5.2087753964874028E-2]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H60:H61,H52,H53:H56)","v":8043.279933400001},null,null,null,{"$f":"SUM(L60:L61,L52,L53:L56)","v":7624.2785476138997},null,{"$f":"L69-H69","v":-419.00138578610131},{"$f":"IF((H69)=0,\"\",(N69/H69))","v":-5.2093348640793097E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H69*F70","v":1045.6263913420003},null,0.13,null,{"$f":"L69*J70","v":991.15621118980698},null,{"$f":"L70-H70","v":-54.470180152193279},{"$f":"IF((H70)=0,\"\",(N70/H70))","v":-5.2093348640793194E-2}]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H69+H70","v":9088.9063247420017},null,null,null,{"$f":"L69+L70","v":8615.4347588037072},null,{"$f":"L71-H71","v":-473.47156593829459},{"$f":"IF((H71)=0,\"\",(N71/H71))","v":-5.2093348640793104E-2}]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H71*0.1,2)","v":-908.89},null,null,null,{"$f":"ROUND(-L71*0.1,2)","v":-861.54},null,{"$f":"L72-H72","v":47.350000000000023},{"$f":"IF((H72)=0,\"\",(N72/H72))","v":-5.2096513329445836E-2}]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H71:H72)","v":8180.0163247420014},null,null,null,{"$f":"SUM(L71:L72)","v":7753.8947588037072},null,{"$f":"L73-H73","v":-426.12156593829422},{"$f":"IF((H73)=0,\"\",(N73/H73))","v":-5.209299700899242E-2}]
[]
[]
[null,"Loss Factor (%)",null,null,null,8.1000000000000003E-2,null,null,null,8.1000000000000003E-2]

{"sheet":"Bill Impact - USL","index":23,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[72,1,72,3],[20,3,21,3],[20,13,21,13],[20,14,21,14],[65,1,65,3],[66,1,66,3],[71,1,71,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[19,5,19,7],[19,9,19,11],[19,13,19,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"USL"]
[]
[null,"TOU / non-TOU:",null,"TOU"]
[]
[null,null,null,"Consumption",null,1800,"kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,{"$f":"'B. CurrentTariff'!C95","v":43.63},1,{"$f":"G23*F23","v":43.63},null,{"$f":"'G. RateDesign'!B49","v":39.619999999999997},1,{"$f":"K23*J23","v":39.619999999999997},null,{"$f":"L23-H23","v":-4.0100000000000051},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":-9.1909236763694821E-2}]
[null,"Smart Meter Rate Adder",null,null,null,null,1,{"$f":"G24*F24","v":0},null,null,1,{"$f":"K24*J24","v":0},null,{"$f":"L24-H24","v":0},{"$f":"IF((H24)=0,\"\",(N24/H24))","v":""}]
[null,null,null,null,null,null,1,0,null,null,1,{"$f":"K25*J25","v":0},null,{"$f":"L25-H25","v":0},{"$f":"IF((H25)=0,\"\",(N25/H25))","v":""}]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kWh",null,{"$f":"'B. CurrentTariff'!C138","v":2E-3},{"$f":"$F$18","v":1800},3.6,null,{"$f":"'G. RateDesign'!G49","v":8.8690719314647067E-3},{"$f":"$F$18","v":1800},15.964329476636472,null,12.364329476636472,3.4345359657323531]
[null,"Smart Meter Disposition Rider",null,"per kWh",null,null,1800,0,null,null,{"$f":"$F$18","v":1800},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kWh",null,null,1800,0,null,null,1800,0,null,0,""]
[null,"Stranded Meter Rate Rider",null,null,null,null,1800,{"$f":"G32*F32","v":0},null,null,1800,{"$f":"K32*J32","v":0},null,{"$f":"L32-H32","v":0},{"$f":"IF((H32)=0,\"\",(N32/H32))","v":""}]
[null,null,null,null,null,null,1800,{"$f":"G33*F33","v":0},null,null,1800,{"$f":"K33*J33","v":0},null,{"$f":"L33-H33","v":0},{"$f":"IF((H33)=0,\"\",(N33/H33))","v":""}]
[null,null,null,null,null,null,1800,{"$f":"G34*F34","v":0},null,null,1800,{"$f":"K34*J34","v":0},null,{"$f":"L34-H34","v":0},{"$f":"IF((H34)=0,\"\",(N34/H34))","v":""}]
[null,null,null,null,null,null,1800,0,null,null,1800,0,null,0,""]
[null,null,null,null,null,null,1800,0,null,null,1800,0,null,0,""]
[null,null,null,null,null,null,1800,0,null,null,1800,0,null,0,""]
[null,null,null,null,null,null,1800,0,null,null,1800,0,null,0,""]
[null,"Sub-Total A (excluding pass through)",null,null,null,null,null,{"$f":"SUM(H23:H38)","v":47.230000000000004},null,null,null,{"$f":"SUM(L23:L38)","v":55.584329476636469},null,8.3543294766364653,0.17688607826882202]
[null,{"$f":"'L. DVA'!$B$16","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.)"},null,"per kWh",null,null,{"$f":"$F$18","v":1800},{"$f":"G40*F40","v":0},null,{"$f":"'L. DVA'!F23","v":3.5185587757028341E-4},{"$f":"$F$18","v":1800},{"$f":"K40*J40","v":0.63334057962651014},null,{"$f":"L40-H40","v":0.63334057962651014},{"$f":"IF((H40)=0,\"\",(N40/H40))","v":""}]
[null,{"$f":"'L. DVA'!$B$42","v":"Rate Rider Calculation for Deferral / Variance Accounts Balances (excluding Global Adj.) - NON-WMP"},null,"per kWh",null,null,1800,0,null,{"$f":"'L. DVA'!F49","v":-1.6111985715856249E-4},1800,-0.29001574288541249,null,-0.29001574288541249,""]
[null,{"$f":"'L. DVA'!$B$68","v":"Rate Rider Calculation for RSVA - Power - Global Adjustment"},null,"per kWh",null,null,1800,null,null,0,1800,0,null,0,""]
[null,{"$f":"'L. DVA'!$B$121","v":"Rate Rider Calculation for Group 2 Accounts"},null,"per kWh",null,null,1800,null,null,{"$f":"'L. DVA'!F128","v":1.6182341928445236E-4},1800,0.29128215471201424,null,0.29128215471201424,""]
[null,{"$f":"'L. DVA'!$B$147","v":"Rate Rider Calculation for Accounts 1575 and 1576"},null,"per kWh",null,null,1800,0,null,{"$f":"'L. DVA'!F156","v":-2.5495760607595745E-3},1800,-4.5892369093672336,null,-4.5892369093672336,""]
[null,{"$f":"'L. DVA'!$B$175","v":"Rate Rider Calculation for Accounts 1568"},null,"per kWh",null,null,1800,0,null,{"$f":"'L. DVA'!F184","v":1.8574433861791648E-4},1800,0.33433980951224967,null,0.33433980951224967,""]
[null,"Low Voltage Charges",null,"per kWh",null,1E-3,1800,1.8,null,1E-3,1800,1.8,null,0,0]
[null,"Line Losses on Cost of Power",null,"per kWh",null,{"$f":"IF(ISBLANK(D16)=1, 0, IF(D16=\"TOU\", 0.64*$F$57+0.18*$F$58+0.18*$F$59, IF(AND(D16=\"non-TOU\", G61>0), F61,F60)))","v":0.10766000000000001},{"$f":"$F$18*(1+$F$76)-$F$18","v":145.79999999999995},15.696827999999996,null,{"$f":"0.64*$F$57+0.18*$F$58+0.18*$F$59","v":0.10766000000000001},{"$f":"$F$18*(1+$J$76)-$F$18","v":145.79999999999995},15.696827999999996,null,0,0]
[null,"Smart Meter Entity Charge",null,"per kWh",null,0.79,1,0.79,null,0.79,1,0.79,null,0]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H40:H48)+H39","v":65.516828000000004},null,null,null,{"$f":"SUM(L40:L48)+L39","v":70.250867368234594},null,4.7340393682345905,{"$f":"IF((H49)=0,\"\",(N49/H49))","v":7.2256846259934782E-2}]
[null,"RTSR - Network",null,"per kWh",null,5.7999999999999996E-3,{"$f":"F18*(1+F76)","v":1945.8},{"$f":"G50*F50","v":11.285639999999999},null,5.8047406928710644E-3,{"$f":"F18*(1+J76)","v":1945.8},{"$f":"K50*J50","v":11.294864440188517},null,9.2244401885182015E-3,8.1736083983878645E-4]
[null,"RTSR - Line and Transformation Connection",null,"per kWh",null,4.0000000000000001E-3,{"$f":"G50","v":1945.8},{"$f":"G51*F51","v":7.7831999999999999},null,3.2582907982664504E-3,{"$f":"K50","v":1945.8},{"$f":"K51*J51","v":6.3399822352668593},null,-1.4432177647331406,-0.18542730043338737]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H49:H51)","v":84.585667999999998},null,null,null,{"$f":"SUM(L49:L51)","v":87.885714043689973},null,3.3000460436899743,3.9014245813959576E-2]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,3.5999999999999999E-3,{"$f":"G51","v":1945.8},{"$f":"G53*F53","v":7.00488},null,3.5999999999999999E-3,{"$f":"K51","v":1945.8},{"$f":"K53*J53","v":7.00488},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.2999999999999999E-3,{"$f":"G51","v":1945.8},2.5295399999999999,null,1.2999999999999999E-3,{"$f":"K51","v":1945.8},2.5295399999999999,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"OEAP",null,"per kWh",null,1.1000000000000001E-3,{"$f":"F18","v":1800},1.9800000000000002,null,1.1000000000000001E-3,{"$f":"F18","v":1800},1.9800000000000002,null,0,0]
[null,"TOU - Off Peak",null,"per kWh",null,8.3000000000000004E-2,{"$f":"0.64*$F$18","v":1152},95.616,null,8.3000000000000004E-2,{"$f":"G57","v":1152},95.616,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.128,{"$f":"0.18*$F$18","v":324},41.472000000000001,null,0.128,{"$f":"G58","v":324},41.472000000000001,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.17499999999999999,{"$f":"0.18*$F$18","v":324},56.699999999999996,null,0.17499999999999999,{"$f":"G59","v":324},56.699999999999996,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,9.9000000000000005E-2,{"$f":"IF(AND($T$1=1, F18>=600), 600, IF(AND($T$1=1, AND(F18<600, F18>=0)), F18, IF(AND($T$1=2, F18>=1000), 1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), F18))))","v":600},{"$f":"G60*F60","v":59.400000000000006},null,9.9000000000000005E-2,{"$f":"G60","v":600},{"$f":"K60*J60","v":59.400000000000006},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,0.11600000000000001,{"$f":"IF(AND($T$1=1, F18>=600), F18-600, IF(AND($T$1=1, AND(F18<600, F18>=0)), 0, IF(AND($T$1=2, F18>=1000), F18-1000, IF(AND($T$1=2, AND(F18<1000, F18>=0)), 0))))","v":1200},{"$f":"G61*F61","v":139.20000000000002},null,0.11600000000000001,{"$f":"G61","v":1200},{"$f":"K61*J61","v":139.20000000000002},null,0,0]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H53:H59,H52)","v":290.13808799999998},null,null,null,{"$f":"SUM(L53:L59,L52)","v":293.43813404368996},null,{"$f":"L63-H63","v":3.3000460436899743},{"$f":"IF((H63)=0,\"\",(N63/H63))","v":1.1374053184254714E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H63*F64","v":37.71795144},null,0.13,null,{"$f":"L63*J64","v":38.146957425679695},null,0.42900598567969439,1.1374053184254653E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H63+H64","v":327.85603943999996},null,null,null,{"$f":"L63+L64","v":331.58509146936967},null,3.7290520293697114,1.1374053184254837E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H65*0.1,2)","v":-32.79},null,null,null,{"$f":"ROUND(-L65*0.1,2)","v":-33.159999999999997},null,-0.36999999999999744,1.1283928026837373E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H65+H66","v":295.06603943999994},null,null,null,{"$f":"L65+L66","v":298.4250914693697},null,3.3590520293697637,1.1384068582561527E-2]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H60:H61,H52,H53:H56)","v":294.95008800000005},null,null,null,{"$f":"SUM(L60:L61,L52,L53:L56)","v":298.25013404369003},null,{"$f":"L69-H69","v":3.3000460436899743},{"$f":"IF((H69)=0,\"\",(N69/H69))","v":1.118848977488684E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H69*F70","v":38.343511440000007},null,0.13,null,{"$f":"L69*J70","v":38.772517425679702},null,{"$f":"L70-H70","v":0.42900598567969439},{"$f":"IF((H70)=0,\"\",(N70/H70))","v":1.1188489774886781E-2}]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H69+H70","v":333.29359944000004},null,null,null,{"$f":"L69+L70","v":337.02265146936975},null,{"$f":"L71-H71","v":3.7290520293697114},{"$f":"IF((H71)=0,\"\",(N71/H71))","v":1.1188489774886963E-2}]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H71*0.1,2)","v":-33.33},null,null,null,{"$f":"ROUND(-L71*0.1,2)","v":-33.700000000000003},null,{"$f":"L72-H72","v":-0.37000000000000455},{"$f":"IF((H72)=0,\"\",(N72/H72))","v":1.1101110111011237E-2}]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H71:H72)","v":299.96359944000005},null,null,null,{"$f":"SUM(L71:L72)","v":303.32265146936976},null,{"$f":"L73-H73","v":3.3590520293697068},{"$f":"IF((H73)=0,\"\",(N73/H73))","v":1.1198198833594134E-2}]
[]
[]
[null,"Loss Factor (%)",null,null,null,8.1000000000000003E-2,null,null,null,8.1000000000000003E-2]

{"sheet":"Update to COS Application","index":24,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,3,3,9],[0,0,0,15]]}
["Rate Design Model version 1.0 © CHEC "]
[]
[]
[null,null,null," Updates to Cost of Service Application"]
[null,"Note: By clicking the camera icon, utilities can take a snapshot of that specific row. This feature is intended to help utilites keep track of the changes throughout the various stages of the application.. "]
["Snapshot/Reset",null,"Reference"," Description","Regulated Return on Capital","Regulated Rate of Return","Rate Base","WCA","Amortization","PILS","OM&A","Base Rev Req","Affects Cost Allocation Y/N","Affects Rate Design Y/N","Affects Rate Riders Y/N","Affects Final Rates Y/N"]
[null,{"$f":"TODAY()","v":"2016-06-13"},"Original Application","Filed on June 14, 2016",435760.01195310877,null,6933995.4801271195,994881.55012711952,247980.96000000002,23047.146341509921,1549280,2148518.118294619,"No","No","No","No"]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"E7-E8","v":0},{"$f":"F7-F8","v":0},0,0,0,0,0,0]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!C19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!D20","v":6933995.4801271195},{"$f":"'D. Rate Base'!D31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!C15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!C21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!C14","v":1549280},{"$f":"'E. Revenue Requirement'!C26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"E10-E11","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"E13-E14","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"E16-E17","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"E19-E20","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"E22-E23","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"E25-E26","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"'E. Revenue Requirement'!$C$19","v":435760.01195310877},null,{"$f":"'D. Rate Base'!$D$20","v":6933995.4801271195},{"$f":"'D. Rate Base'!$D$31","v":994881.55012711952},{"$f":"'E. Revenue Requirement'!$C$15","v":247980.96000000002},{"$f":"'E. Revenue Requirement'!$C$21","v":23047.146341509921},{"$f":"'E. Revenue Requirement'!$C$14","v":1549280},{"$f":"'E. Revenue Requirement'!$C$26","v":2148518.118294619},"No","No","No","No"]
[null,null,null,null,{"$f":"E28-E29","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"E31-E32","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"E34-E35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"E37-E38","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"E40-E41","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"E43-E44","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"E46-E47","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"SUM(#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"No","No","No","No"]
[null,null,null,null,{"$f":"E49-E50","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]