{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["A1.1 Distributor Information","B1.1 Current Distribution Rates","B1.2 Billing Determinants","B1.3 Current Rev From Rates","C1.1 Current Rate Riders","C1.2 - PCA","D1.1 Rate 1 Adjustment","D1.2 Rate 6 Adjustment","D1.3 Rate 11 Adjustment","D1.4 Rate 16 Adjustment","E1.1 Proposed Dist Rates ","E1.2 Billing Determinants","E1.3 Proposed Rev From Rate","F1.3 Proposed Rate Riders","G1.1 Rate 1 Bill Impact","G1.2 Rate 6 Bill Impact","G1.3 Rate 11 Bill Impact","G1.4 Rate 16 Bill Impact","G1.7 Summary of Bill Impacts","Staff-2","Staff-2 CVVA Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"A1.1 Distributor Information","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"D8","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":" \"OEB Application Number:  \" & D9","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Distributor Information"]
[]
[null,null,"Distributor Name","EPCOR Natural Gas Limited Partnership"]
[null,null,"OEB Application Number","EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"A1.1 Distributor Information"}]

{"sheet":"B1.1 Current Distribution Rates","index":1,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,6,6,8]]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Current Distribution Tariff Sheet Rates"]
[]
[null,null,null,null,"Fixed ",null,"Delivery Charge",null,null,"Delivery Charge"]
[null,null,"Rate Class",null,"Monthly Base",{"$f":"OneDollar","v":"Bill 32 Rate"},"Tier 1","Tier 2","Tier 3","Contract Demand","Gas Supply","Upstream Recovery \nCharge","Transportation & \nStorage Charge","Transportation Charge \nFrom Dawn","Transportation Charge \nFrom Kirkwall","Transportation Charge From Parkway","Federal Carbon Charge","Facility Carbon Charge"]
[null,null,null,null," $/month","$ / month","₵ / m3","₵ / m3","₵ / m3","₵ /contracted m3","₵  / m3","(A)","₵  / m3","₵ /contracted m3","₵ /contracted m3","₵ /contracted m3","₵ / m3","₵ / m3"]
[null,null,"Rate 1","General Firm Service",27.448077999999999,1,29.403535999999999,28.824269960000002,27.972877880000002,null,12.9848,1.474,2.6981999999999999,null,null,null,15.25,1.2999999999999999E-3]
[null,null,"Rate 6","Large Volume General Firm Service",111.93205400000001,1,27.125478620000003,24.413022900000001,23.192141400000001,null,12.9848,2.92,5.6413000000000002,null,null,null,15.25,1.2999999999999999E-3]
[null,null,"Rate 11","Large Volume Seasonal Service",223.86410800000002,1,16.849495640000001,16.849495640000001,16.849495640000001,null,12.9848,3.5200000000000002E-2,1.8166,null,null,null,15.25,1.2999999999999999E-3]
[null,null,"Rate 16","Contracted Firm Service",1646.034926,1,null,null,null,112.27502700000001,null,14.243399999999999,null,18.299900000000001,11.848000000000001,11.848000000000001,15.25,1.2999999999999999E-3]
[null,null,"(A) Rates 1, 6, and 11 all charged on cents / m3 basis. Rate 16 billed on cents / m3 of contracted demand basis"]
[]
[]
[]
[null,null,"Name for $1 Charge:","Bill 32 Rate"]

{"sheet":"B1.2 Billing Determinants","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,5,6,7]]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Billing Determinants"]
[]
[null,null,null,null,"Fixed","Delivery Charge",null,null,"Delivery Charge"]
[null,null,"Rate Class",null,"Monthly Base","Tier 1","Tier 2","Tier 3","Contract Demand","Gas Supply"]
[null,null,"Rate 1","General Firm Service",5516,4885012,3296557,89051,null,8270620]
[null,null,"Rate 6","Large Volume General Firm Service",54,525661,1137819,564677,null,2228157]
[null,null,"Rate 11","Large Volume Seasonal Service",9,null,null,1431902,null,1431902]
[null,null,"Rate 16","Contracted Firm Service",3,null,null,null,95824,0]

{"sheet":"B1.3 Current Rev From Rates","index":3,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,2,17,3],[10,6,10,8]]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[]
[null,null,"Forecasted Revenue from Current Rates"]
[]
[null,null,"Months / Year",12]
[null,null,null,"EB-2023-0161  Exhibit A - 2024 Custom Incentive Application"]
[]
[null,null,null,null,"Fixed Monthly",null,"Delivery Charge",null,null,"Delivery  Charge"]
[null,null,"Rate Class",null,"Base",{"$f":"OneDollar","v":"Bill 32 Rate"},"Tier 1","Tier 2","Tier 3","Contract  Demand","Gas Supply","Upstream Recovery \nCharge","Transportation & \nStorage Charge","Federal Carbon Charge","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(A)"]
[null,null,"Rate 1","General Firm Service",{"$f":"'B1.2 Billing Determinants'!E9*'B1.1 Current Distribution Rates'!E10*$D$8","v":1816843.1789759998},{"$f":"'B1.1 Current Distribution Rates'!F10*'B1.2 Billing Determinants'!E9*$D$8","v":66192},{"$f":"'B1.2 Billing Determinants'!F9*'B1.1 Current Distribution Rates'!G10/100","v":1436366.26202432},{"$f":"'B1.2 Billing Determinants'!G9*'B1.1 Current Distribution Rates'!H10/100","v":950208.48906527727},{"$f":"'B1.2 Billing Determinants'!H9*'B1.1 Current Distribution Rates'!I10/100","v":24910.127480918803},{"$f":"'B1.2 Billing Determinants'!I9*'B1.1 Current Distribution Rates'!J10/100*$D$8","v":0},{"$f":"'B1.2 Billing Determinants'!J9*'B1.1 Current Distribution Rates'!K10/100","v":1073923.4657600001},{"$f":"'B1.1 Current Distribution Rates'!L10*'B1.2 Billing Determinants'!$J9/100","v":121908.93879999999},{"$f":"'B1.1 Current Distribution Rates'!M10*'B1.2 Billing Determinants'!$J9/100","v":223157.86884000001},{"$f":"'B1.1 Current Distribution Rates'!Q10*'B1.2 Billing Determinants'!J9/100","v":1261269.55},{"$f":"SUM(E14:N14)","v":6974779.8809465151}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'B1.2 Billing Determinants'!E10*'B1.1 Current Distribution Rates'!E11*$D$8","v":72531.970992000017},{"$f":"'B1.1 Current Distribution Rates'!F11*'B1.2 Billing Determinants'!E10*$D$8","v":648},{"$f":"'B1.2 Billing Determinants'!F10*'B1.1 Current Distribution Rates'!G11/100","v":142588.06216867821},{"$f":"'B1.2 Billing Determinants'!G10*'B1.1 Current Distribution Rates'!H11/100","v":277776.01303055102},{"$f":"'B1.2 Billing Determinants'!H10*'B1.1 Current Distribution Rates'!I11/100","v":130960.68829327801},{"$f":"'B1.2 Billing Determinants'!I10*'B1.1 Current Distribution Rates'!J11/100*$D$8","v":0},{"$f":"'B1.2 Billing Determinants'!J10*'B1.1 Current Distribution Rates'!K11/100","v":289321.73013599997},{"$f":"'B1.1 Current Distribution Rates'!L11*'B1.2 Billing Determinants'!$J10/100","v":65062.184399999998},{"$f":"'B1.1 Current Distribution Rates'!M11*'B1.2 Billing Determinants'!$J10/100","v":125697.02084100001},{"$f":"'B1.1 Current Distribution Rates'!Q11*'B1.2 Billing Determinants'!J10/100","v":339793.9425},{"$f":"SUM(E15:N15)","v":1444379.612361507}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'B1.2 Billing Determinants'!E11*'B1.1 Current Distribution Rates'!E12*$D$8","v":24177.323664000003},{"$f":"'B1.1 Current Distribution Rates'!F12*'B1.2 Billing Determinants'!E11*$D$8","v":108},{"$f":"'B1.2 Billing Determinants'!F11*'B1.1 Current Distribution Rates'!G12/100","v":0},{"$f":"'B1.2 Billing Determinants'!G11*'B1.1 Current Distribution Rates'!H12/100","v":0},{"$f":"'B1.2 Billing Determinants'!H11*'B1.1 Current Distribution Rates'!I12/100","v":241268.26505907282},{"$f":"'B1.2 Billing Determinants'!I11*'B1.1 Current Distribution Rates'!J12/100*$D$8","v":0},{"$f":"'B1.2 Billing Determinants'!J11*'B1.1 Current Distribution Rates'!K12/100","v":185929.610896},{"$f":"'B1.1 Current Distribution Rates'!L12*'B1.2 Billing Determinants'!$J11/100","v":504.02950400000003},{"$f":"'B1.1 Current Distribution Rates'!M12*'B1.2 Billing Determinants'!$J11/100","v":26011.931732000001},{"$f":"'B1.1 Current Distribution Rates'!Q12*'B1.2 Billing Determinants'!J11/100","v":218365.05499999999},{"$f":"SUM(E16:N16)","v":696364.21585507283}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'B1.2 Billing Determinants'!E12*'B1.1 Current Distribution Rates'!E13*$D$8","v":59257.257335999995},{"$f":"'B1.1 Current Distribution Rates'!F13*'B1.2 Billing Determinants'!E12*$D$8","v":36},{"$f":"'B1.2 Billing Determinants'!F12*'B1.1 Current Distribution Rates'!G13/100","v":0},{"$f":"'B1.2 Billing Determinants'!G12*'B1.1 Current Distribution Rates'!H13/100","v":0},{"$f":"'B1.2 Billing Determinants'!H12*'B1.1 Current Distribution Rates'!I13/100","v":0},{"$f":"'B1.2 Billing Determinants'!I12*'B1.1 Current Distribution Rates'!J13/100*$D$8","v":1291037.0624697602},{"$f":"'B1.2 Billing Determinants'!J12*'B1.1 Current Distribution Rates'!K13/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L13*'B1.2 Billing Determinants'!$I12*$D$8/100","v":163783.14739199998},{"$f":"'B1.1 Current Distribution Rates'!N13*'B1.2 Billing Determinants'!$I12/100*$D$8","v":210428.35411200003},{"$f":"'B1.1 Current Distribution Rates'!Q13*'B1.2 Billing Determinants'!I12/100*D8","v":175357.91999999998},{"$f":"SUM(E17:N17)","v":1899899.7413097601}]
[null,null,"Total Revenue",null,{"$f":"SUM(E14:E17)","v":1972809.7309679999},66984,1578954.3241929982,1227984.5020958283,397139.08083326963,1291037.0624697602,1549174.8067920001,351258.30009599996,585295.17552500009,1994786.4675,11015423.450472856]
[null,null,"(A) Transportation & Storage for Rates 1, 6, and 11. Transportation only for Rate 16."]

{"sheet":"C1.1 Current Rate Riders","index":4,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Current Rate Riders"]
[]
[null,null,"Description:",null,"Delay in Revenue Recovery Rate Rider"]
[null,null,"Effective Until:",null,"Dec 31, 2028"]
[]
[null,null,"Rate 1 | General Firm Service","cents / m3 volume",1.633,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service","cents / m3 volume",0.90900000000000003,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service","cents / m3 volume",0.5524,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service","cents / contracted demand / month",6.0100000000000001E-2,"$/contracted demand m3"]
[]
[]
[null,null,"Energy Content Variance Account (ECVA)"]
[null,null,null,null,"ECVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,0.1727480445706312,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.19051597258377229,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.14267864933646654,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,0,"Cents/contracted demand m3"]
[]
[]
[null,null,"Contribution in Aid of Construction Variance Account (CIACVA)"]
[null,null,null,null,"CIACVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,2.3327246951066174,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,3.1292490684040697,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.60585649438223443,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,4.7721417037354747,"Cents/contracted demand m3"]
[]
[]
[null,null,"Municipal Tax Variance Account (MTVA)"]
[null,null,null,null,"MTVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,-2.2906015564479656,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,-3.987512919623855,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,-0.77397951503382845,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,-5.6379529980995775,"Cents/contracted demand m3"]
[]
[]
[null,null,"Other Revenue Deferral Account (ORDA)"]
[null,null,null,null,"ORDA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,-8.9275245292738045E-2,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,-7.5936581997670949E-2,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,-2.9381537908305999E-2,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,-5.0585942560899509E-2,"Cents/contracted demand m3/month"]

{"sheet":"C1.2 - PCA","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'C1.1 Current Rate Riders'!C2","v":"EPCOR Natural Gas Limited Partnership"}]
[{"$f":"'C1.1 Current Rate Riders'!C3","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
["2025 OEB Inflation Factor",null,null,null,null,null,null,3.5999999999999997E-2]
[]
["Incentive Rate Adjustment (IR) = [(1.0 – 0.314) x 0.0127] + [0.314 x Inflation (I)]"]
[]
[null,null,null,1,-0.314,1.2699999999999999E-2,"+",0.314]
[null,null,null,null,{"$f":"D8+E8","v":0.68599999999999994},{"$f":"F8","v":1.2699999999999999E-2},null,{"$f":"H8*H4","v":1.1304E-2}]
[null,null,null,null,null,{"$f":"E9*F9","v":8.7121999999999981E-3},null,{"$f":"H9","v":1.1304E-2}]
[]
["2025 PCA Used in Application",null,null,null,null,null,null,{"$f":"F10+H10","v":2.0016199999999998E-2}]

{"sheet":"D1.1 Rate 1 Adjustment","index":6,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Rate 1 Incentive Rate Adjustment"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.1 Rate 1 Adjustment"}]
[]
[null,null,"Rate 1"]
[]
[null,null,"GDP-IPI"]
[null,null,"Less Productivity"]
[null,null,"Less Stretch Factor"]
[null,null,"Incentive Rate Adjustment",null,{"$f":"'C1.2 - PCA'!H12","v":2.0016199999999998E-2}]
[null,null,"Months / Year",null,12]
[]
[null,null,null,"Unit","Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue"]
[null,null,"Monthly Base","$/month",{"$f":"'B1.1 Current Distribution Rates'!E10","v":27.448077999999999},{"$f":"$E$13","v":2.0016199999999998E-2},{"$f":"E17*(1+F17)","v":27.997484218863598},{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C17,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":5516},{"$f":"G17*H17*$E$14","v":1853209.4754150193}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},"$/month",{"$f":"'B1.1 Current Distribution Rates'!F10","v":1},0,{"$f":"E18*(1+F18)","v":1},{"$f":"H17","v":5516},{"$f":"G18*H18*$E$14","v":66192}]
[null,null,"Tier 1","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!G10","v":29.403535999999999},{"$f":"$E$13","v":2.0016199999999998E-2},{"$f":"E19*(1+F19)","v":29.992083057283196},{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C19,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":4885012},{"$f":"G19*H19/100","v":1465116.8563982511}]
[null,null,"Tier 2","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!H10","v":28.824269960000002},{"$f":"$E$13","v":2.0016199999999998E-2},29.401222312373353,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C20,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":3296557},{"$f":"G20*H20/100","v":969228.05222410557}]
[null,null,"Tier 3","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!I10","v":27.972877880000002},{"$f":"$E$13","v":2.0016199999999998E-2},28.532788598221657,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C21,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":89051},25408.733574602367]
[null,null,"Contract Demand","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!J10","v":0},{"$f":"$E$13","v":2.0016199999999998E-2},0,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C22,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G22*H22/100*$E$14","v":0}]
[null,null,"Gas Supply","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!K10","v":12.9848},0,12.9848,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C23,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":8270620},1073923.4657600001]
[null,null,"Upstream Recovery \nCharge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!L10","v":1.474},0,1.474,{"$f":"H23","v":8270620},121908.93879999999]
[null,null,"Transportation & \nStorage Charge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!M10","v":2.6981999999999999},0,2.6981999999999999,{"$f":"H24","v":8270620},223157.86884000001]
[null,null,"Federal Carbon Charge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!Q10","v":15.25},0,15.25,{"$f":"H25","v":8270620},{"$f":"G26*H26/100","v":1261269.55}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":7059414.9410119774}]

{"sheet":"D1.2 Rate 6 Adjustment","index":7,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Rate 6 Incentive Rate Adjustment"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.2 Rate 6 Adjustment"}]
[]
[null,null,"Rate 6"]
[]
[null,null,"GDP-IPI"]
[null,null,"Less Productivity"]
[null,null,"Less Stretch Factor"]
[null,null,"Incentive Rate Adjustment",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":2.0016199999999998E-2}]
[null,null,"Months / Year",null,12]
[]
[null,null,null,"Unit","Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue"]
[null,null,"Monthly Base","$/month",{"$f":"'B1.1 Current Distribution Rates'!E11","v":111.93205400000001},{"$f":"$E$13","v":2.0016199999999998E-2},{"$f":"E17*(1+F17)","v":114.1725083792748},{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C17,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":54},{"$f":"G17*H17*12","v":73983.785429770069}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},"$/month",{"$f":"'B1.1 Current Distribution Rates'!F11","v":1},0,{"$f":"E18*(1+F18)","v":1},{"$f":"H17","v":54},{"$f":"G18*H18*12","v":648}]
[null,null,"Tier 1","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!G11","v":27.125478620000003},{"$f":"$E$13","v":2.0016199999999998E-2},{"$f":"E19*(1+F19)","v":27.668427625153644},{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C19,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":525661},{"$f":"G19*H19/100","v":145442.1333386589}]
[null,null,"Tier 2","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!H11","v":24.413022900000001},{"$f":"$E$13","v":2.0016199999999998E-2},24.901678848970981,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C20,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":1137819},{"$f":"G20*H20/100","v":283336.03326257312}]
[null,null,"Tier 3","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!I11","v":23.192141400000001},{"$f":"$E$13","v":2.0016199999999998E-2},23.656359940690677,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C21,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":564677},133582.0236222939]
[null,null,"Contract Demand","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!J11","v":0},{"$f":"$E$13","v":2.0016199999999998E-2},0,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C22,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G22*H22/100*12","v":0}]
[null,null,"Gas Supply","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!K11","v":12.9848},0,12.9848,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C23,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":2228157},289321.73013599997]
[null,null,"Upstream Recovery \nCharge","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C24,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":2.92},0,2.92,{"$f":"H23","v":2228157},65062.184399999998]
[null,null,"Transportation & \nStorage Charge","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C25,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":5.6413000000000002},{"$f":"'D1.1 Rate 1 Adjustment'!$F$25","v":0},5.6413000000000002,{"$f":"H24","v":2228157},125697.02084100001]
[null,null,"Federal Carbon Charge","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C26,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":15.25},0,15.25,{"$f":"H25","v":2228157},339793.9425]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":1456866.8535302961}]

{"sheet":"D1.3 Rate 11 Adjustment","index":8,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Rate 11 Incentive Rate Adjustment"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.3 Rate 11 Adjustment"}]
[]
[null,null,"Rate 11"]
[]
[null,null,"GDP-IPI"]
[null,null,"Less Productivity"]
[null,null,"Less Stretch Factor"]
[null,null,"Incentive Rate Adjustment",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":2.0016199999999998E-2}]
[null,null,"Months / Year",null,12]
[]
[null,null,null,"Unit","Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue"]
[null,null,"Monthly Base","$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C17,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":223.86410800000002},{"$f":"$E$13","v":2.0016199999999998E-2},{"$f":"E17*(1+F17)","v":228.3450167585496},{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C17,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":9},{"$f":"G17*H17*12","v":24661.261809923359}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C18,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":1},0,{"$f":"E18*(1+F18)","v":1},{"$f":"H17","v":9},{"$f":"G18*H18*12","v":108}]
[null,null,"Tier 1","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C19,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":16.849495640000001},{"$f":"$E$13","v":2.0016199999999998E-2},17.186758514629368,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C19,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G19*H19/100","v":0}]
[null,null,"Tier 2","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C20,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":16.849495640000001},{"$f":"$E$13","v":2.0016199999999998E-2},17.186758514629368,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C20,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G20*H20/100","v":0}]
[null,null,"Tier 3","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C21,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":16.849495640000001},{"$f":"$E$13","v":2.0016199999999998E-2},17.186758514629368,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C21,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":1431902},246097.53890614823]
[null,null,"Contract Demand","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C22,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":0},{"$f":"$E$13","v":2.0016199999999998E-2},0,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C22,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G22*H22/100*12","v":0}]
[null,null,"Gas Supply","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C23,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":12.9848},0,12.9848,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C23,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":1431902},185929.610896]
[null,null,"Upstream Recovery \nCharge","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C24,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":3.5200000000000002E-2},0,3.5200000000000002E-2,{"$f":"H23","v":1431902},504.02950400000003]
[null,null,"Transportation & \nStorage Charge","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C25,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":1.8166},{"$f":"'D1.1 Rate 1 Adjustment'!$F$25","v":0},1.8166,{"$f":"H24","v":1431902},26011.931732000001]
[null,null,"Federal Carbon Charge","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C26,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":15.25},0,15.25,{"$f":"H25","v":1431902},218365.05499999999]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":701677.42784807156}]

{"sheet":"D1.4 Rate 16 Adjustment","index":9,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Rate 16 Incentive Rate Adjustment"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.4 Rate 16 Adjustment"}]
[]
[null,null,"Rate 16"]
[]
[null,null,"GDP-IPI"]
[null,null,"Less Productivity"]
[null,null,"Less Stretch Factor"]
[null,null,"Incentive Rate Adjustment",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":2.0016199999999998E-2}]
[null,null,"Months / Year",null,12]
[]
[null,null,null,"Unit","Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue"]
[null,null,"Monthly Base","$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C17,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":1646.034926},{"$f":"$E$13","v":2.0016199999999998E-2},{"$f":"E17*(1+F17)","v":1678.9822902858011},{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C17,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":3},{"$f":"G17*H17*$E$14","v":60443.362450288842}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C18,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":1},0,{"$f":"E18*(1+F18)","v":1},{"$f":"H17","v":3},{"$f":"G18*H18*$E$14","v":36}]
[null,null,"Tier 1","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C19,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":0},2.0016199999999998E-2,0,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C19,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G19*H19/100","v":0}]
[null,null,"Tier 2","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C20,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":0},2.0016199999999998E-2,0,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C20,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G20*H20/100","v":0}]
[null,null,"Tier 3","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C21,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":0},2.0016199999999998E-2,0,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C21,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G21*H21/100","v":0}]
[null,null,"Contract Demand","Cents/contracted demand m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C22,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":112.27502700000001},2.0016199999999998E-2,114.5223463954374,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C22,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":95824},{"$f":"G22*H22/100*$E$14","v":1316878.718519567}]
[null,null,"Gas Supply","cents / m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C23,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":0},0,0,{"$f":"INDEX('B1.2 Billing Determinants'!$E$9:$J$12,MATCH($C$8,'B1.2 Billing Determinants'!$C$9:$C$12,0),MATCH(C23,'B1.2 Billing Determinants'!$E$8:$J$8,0))","v":0},{"$f":"G23*H23/100","v":0}]
[null,null,"Upstream Recovery \nCharge","Cents/contracted demand m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C24,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":14.243399999999999},0,14.243399999999999,{"$f":"H22","v":95824},{"$f":"G24*H24/100*$E$14","v":163783.14739199998}]
[null,null,"Transportation Charge \nFrom Dawn","Cents/contracted demand m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C25,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":18.299900000000001},{"$f":"'D1.1 Rate 1 Adjustment'!$F$25","v":0},18.299900000000001,{"$f":"H24","v":95824},{"$f":"G25*H25/100*$E$14","v":210428.35411200003}]
[null,null,"Transportation Charge \nFrom Kirkwall","Cents/contracted demand m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C26,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":11.848000000000001},{"$f":"'D1.1 Rate 1 Adjustment'!$F$25","v":0},11.848000000000001,0,{"$f":"G26*H26/100*$E$14","v":0}]
[null,null,"Transportation Charge From Parkway","Cents/contracted demand m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C27,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":11.848000000000001},{"$f":"'D1.1 Rate 1 Adjustment'!$F$25","v":0},11.848000000000001,0,{"$f":"G27*H27/100*$E$14","v":0}]
[null,null,"Federal Carbon Charge","Cents/contracted demand m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),MATCH(C28,'B1.1 Current Distribution Rates'!$E$8:$Q$8,0))","v":15.25},0,15.25,{"$f":"H25","v":95824},{"$f":"G28*H28/100*$E$14","v":175357.91999999998}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I28)","v":1926927.5024738559}]

{"sheet":"E1.1 Proposed Dist Rates ","index":10,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Proposed Distribution Tariff Sheet Rates"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"E1.1 Proposed Dist Rates "}]
[]
[null,null,"Rate Class",null,"Monthly Base",{"$f":"OneDollar","v":"Bill 32 Rate"},"Tier 1","Tier 2","Tier 3","Contract Demand","Gas Supply","Upstream Recovery \nCharge","Transportation & \nStorage Charge","Transportation Charge \nFrom Dawn","Transportation Charge \nFrom Kirkwall","Transportation Charge From Parkway","Federal Carbon Charge","Facililty Carbon Charge"]
[null,null,null,null,"$/month","$/month","₵ / m3","₵ / m3","₵ / m3","₵/contracted m3","₵/m3","(A)","₵  / m3","₵ /contracted m3","₵ /contracted m3","₵ /contracted m3","₵ / m3","₵ / m3"]
[null,null,"Rate 1","General Firm Service",{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(E$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":27.997484218863598},{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(F$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":1},{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(G$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":29.992083057283196},{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(H$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":29.401222312373353},{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(I$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":28.532788598221657},null,{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(K$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":12.9848},{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(L$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":1.474},{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(M$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":2.6981999999999999},null,null,null,{"$f":"INDEX('D1.1 Rate 1 Adjustment'!$G$17:$G$26,MATCH(Q$8,'D1.1 Rate 1 Adjustment'!$C$17:$C$26,0))","v":15.25},1.1000000000000001E-3]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(E8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":114.1725083792748},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(F8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":1},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(G8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":27.668427625153644},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(H8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":24.901678848970981},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(I8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":23.656359940690677},null,{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(K8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":12.9848},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(L8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":2.92},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(M8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":5.6413000000000002},null,null,null,{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(Q8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":15.25},1.1000000000000001E-3]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(E8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":228.3450167585496},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(F8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":1},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(G8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":17.186758514629368},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(H8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":17.186758514629368},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(I8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":17.186758514629368},null,{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(K8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":12.9848},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(L8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":3.5200000000000002E-2},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(M8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":1.8166},null,null,null,{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(Q8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":15.25},1.1000000000000001E-3]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"INDEX('D1.4 Rate 16 Adjustment'!$G$17:$G$28,MATCH(E8,'D1.4 Rate 16 Adjustment'!$C$17:$C$28,0))","v":1678.9822902858011},{"$f":"INDEX('D1.4 Rate 16 Adjustment'!$G$17:$G$28,MATCH(F8,'D1.4 Rate 16 Adjustment'!$C$17:$C$28,0))","v":1},null,null,null,{"$f":"INDEX('D1.4 Rate 16 Adjustment'!$G$17:$G$28,MATCH(J8,'D1.4 Rate 16 Adjustment'!$C$17:$C$28,0))","v":114.5223463954374},null,{"$f":"INDEX('D1.4 Rate 16 Adjustment'!$G$17:$G$28,MATCH(L8,'D1.4 Rate 16 Adjustment'!$C$17:$C$28,0))","v":14.243399999999999},null,{"$f":"'D1.4 Rate 16 Adjustment'!G25","v":18.299900000000001},{"$f":"INDEX('D1.4 Rate 16 Adjustment'!$G$17:$G$28,MATCH(O8,'D1.4 Rate 16 Adjustment'!$C$17:$C$28,0))","v":11.848000000000001},{"$f":"INDEX('D1.4 Rate 16 Adjustment'!$G$17:$G$28,MATCH(P8,'D1.4 Rate 16 Adjustment'!$C$17:$C$28,0))","v":11.848000000000001},{"$f":"INDEX('D1.4 Rate 16 Adjustment'!$G$17:$G$28,MATCH(Q8,'D1.4 Rate 16 Adjustment'!$C$17:$C$28,0))","v":15.25},1.1000000000000001E-3]
[null,null,"(A) Rates 1, 6, and 11 all charged on cents / m3 basis. Rate 16 billed on cents / m3 of contracted demand basis"]

{"sheet":"E1.2 Billing Determinants","index":11,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Billing Determinants"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"E1.2 Billing Determinants"}]
[]
[]
[null,null,"Rate Class","Description","Base","Tier 1","Tier 2","Tier 3","Firm Demand","Gas Supply"]
[null,null,null,null,"cx's","m3","m3","m3","Contracted m3","m3"]
[null,null,"Rate 1","General Firm Service",{"$f":"(5560+5472)/2","v":5516},4885012,3296557,89051,null,{"$f":"SUM(F11:H11)","v":8270620}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"(55+53)/2","v":54},525661,1137819,564677,null,{"$f":"SUM(F12:H12)","v":2228157}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"(9+9)/2","v":9},null,null,1431902,null,1431902]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"(3+3)/2","v":3},null,null,null,95824,0]

{"sheet":"E1.3 Proposed Rev From Rate","index":12,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Proposed Revenue from Rates"]
[]
[null,null,"Months / Year",12]
[]
[null,null,"Rate Class",null,"Monthly Base",{"$f":"OneDollar","v":"Bill 32 Rate"},"Tier 1","Tier 2","Tier 3","Contracted\nDemand","Gas Supply","Upstream Recovery \nCharge","Transportation & \nStorage Charge","Federal Carbon \nCharge","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(A)"]
[null,null,"Rate 1","General Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E10*'E1.2 Billing Determinants'!E11*$D$7","v":1853209.4754150193},{"$f":"'E1.1 Proposed Dist Rates '!F10*'E1.2 Billing Determinants'!E11*$D$7","v":66192},{"$f":"'E1.1 Proposed Dist Rates '!G10*'E1.2 Billing Determinants'!F11/100","v":1465116.8563982511},{"$f":"'E1.1 Proposed Dist Rates '!H10*'E1.2 Billing Determinants'!G11/100","v":969228.05222410557},{"$f":"'E1.1 Proposed Dist Rates '!I10*'E1.2 Billing Determinants'!H11/100","v":25408.733574602367},{"$f":"'E1.1 Proposed Dist Rates '!J10*'E1.2 Billing Determinants'!I11/100*$D$7","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K10*'E1.2 Billing Determinants'!J11/100","v":1073923.4657600001},{"$f":"'E1.1 Proposed Dist Rates '!L10*'E1.2 Billing Determinants'!$J11/100","v":121908.93879999999},{"$f":"'E1.1 Proposed Dist Rates '!M10*'E1.2 Billing Determinants'!$J11/100","v":223157.86884000001},{"$f":"'E1.1 Proposed Dist Rates '!Q10*'E1.2 Billing Determinants'!J11/100","v":1261269.55},{"$f":"SUM(E11:N11)","v":7059414.9410119774}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E11*'E1.2 Billing Determinants'!E12*$D$7","v":73983.785429770069},{"$f":"'E1.1 Proposed Dist Rates '!F11*'E1.2 Billing Determinants'!E12*$D$7","v":648},{"$f":"'E1.1 Proposed Dist Rates '!G11*'E1.2 Billing Determinants'!F12/100","v":145442.1333386589},{"$f":"'E1.1 Proposed Dist Rates '!H11*'E1.2 Billing Determinants'!G12/100","v":283336.03326257312},{"$f":"'E1.1 Proposed Dist Rates '!I11*'E1.2 Billing Determinants'!H12/100","v":133582.0236222939},{"$f":"'E1.1 Proposed Dist Rates '!J11*'E1.2 Billing Determinants'!I12/100*$D$7","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K11*'E1.2 Billing Determinants'!J12/100","v":289321.73013599997},{"$f":"'E1.1 Proposed Dist Rates '!L11*'E1.2 Billing Determinants'!$J12/100","v":65062.184399999998},{"$f":"'E1.1 Proposed Dist Rates '!M11*'E1.2 Billing Determinants'!$J12/100","v":125697.02084100001},{"$f":"'E1.1 Proposed Dist Rates '!Q11*'E1.2 Billing Determinants'!J12/100","v":339793.9425},{"$f":"SUM(E12:N12)","v":1456866.8535302961}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'E1.1 Proposed Dist Rates '!E12*'E1.2 Billing Determinants'!E13*$D$7","v":24661.261809923359},{"$f":"'E1.1 Proposed Dist Rates '!F12*'E1.2 Billing Determinants'!E13*$D$7","v":108},{"$f":"'E1.1 Proposed Dist Rates '!G12*'E1.2 Billing Determinants'!F13/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!H12*'E1.2 Billing Determinants'!G13/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I12*'E1.2 Billing Determinants'!H13/100","v":246097.53890614823},{"$f":"'E1.1 Proposed Dist Rates '!J12*'E1.2 Billing Determinants'!I13/100*$D$7","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K12*'E1.2 Billing Determinants'!J13/100","v":185929.610896},{"$f":"'E1.1 Proposed Dist Rates '!L12*'E1.2 Billing Determinants'!$J13/100","v":504.02950400000003},{"$f":"'E1.1 Proposed Dist Rates '!M12*'E1.2 Billing Determinants'!$J13/100","v":26011.931732000001},{"$f":"'E1.1 Proposed Dist Rates '!Q12*'E1.2 Billing Determinants'!J13/100","v":218365.05499999999},{"$f":"SUM(E13:N13)","v":701677.42784807156}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E13*'E1.2 Billing Determinants'!E14*$D$7","v":60443.362450288842},{"$f":"'E1.1 Proposed Dist Rates '!F13*'E1.2 Billing Determinants'!E14*$D$7","v":36},{"$f":"'E1.1 Proposed Dist Rates '!G13*'E1.2 Billing Determinants'!F14/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!H13*'E1.2 Billing Determinants'!G14/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I13*'E1.2 Billing Determinants'!H14/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J13*'E1.2 Billing Determinants'!I14/100*$D$7","v":1316878.718519567},{"$f":"'E1.1 Proposed Dist Rates '!K13*'E1.2 Billing Determinants'!J14/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L13*'E1.2 Billing Determinants'!$I14/100*$D$7","v":163783.14739199998},{"$f":"'E1.1 Proposed Dist Rates '!N13*'E1.2 Billing Determinants'!$I14/100*$D$7","v":210428.35411200003},{"$f":"'E1.1 Proposed Dist Rates '!Q13*'E1.2 Billing Determinants'!I14/100*$D$7","v":175357.91999999998},{"$f":"SUM(E14:N14)","v":1926927.5024738559}]
[null,null,"(A) Transportation & Storage for Rates 1, 6, and 11. Transportation only (no seasonal storage) for Rate 16 from Dawn.",null,null,null,null,null,null,null,null,null,null,"Proposed Revenue",{"$f":"SUM(O11:O14)","v":11144886.7248642}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Revenue",{"$f":"'B1.3 Current Rev From Rates'!O18","v":11015423.450472856}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change",{"$f":"O15-O16","v":129463.27439134382}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"% Change",{"$f":"O17/O16","v":1.1752909452226857E-2}]

{"sheet":"F1.3 Proposed Rate Riders","index":13,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[null,null,"F1.3 Rate Riders"]
[]
[null,null,"Delay in Revenue Recovery Rate Rider"]
[null,null,null,null,"Delay in Revenue Recovery Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,1.633,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.90900000000000003,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.5524,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,6.0100000000000001E-2,"Cents/contracted demand m3/month"]
[]
[]
[null,null,"Energy Content Variance Account (ECVA)"]
[null,null,null,null,"ECVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,0.24809999999999999,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.28149999999999997,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.1847,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,0,"Cents/contracted demand m3"]
[]
[]
[null,null,"Contribution in Aid of Construction Variance Account (CIACVA)"]
[null,null,null,null,"CIACVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,2.3088000000000002,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,3.0468999999999999,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.57889999999999997,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,4.7092000000000001,"Cents/contracted demand m3/month"]
[]
[]
[null,null,"Municipal Tax Variance Account (MTVA)"]
[null,null,null,null,"MTVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,0.50516000000000005,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.86511000000000005,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.16478999999999999,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,1.2396799999999999,"Cents/contracted demand m3/month"]
[]
[]
[null,null,"Other Revenue Deferral Account (ORDA)"]
[null,null,null,null,"ORDA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,-0.27379999999999999,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,-0.2291,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,-8.6999999999999994E-2,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,-0.1547,"Cents/contracted demand m3/month"]
[]
[]
[null,null,"Customer Volume Variance Account (CVVA)"]
[null,null,null,null,"CVVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,5.37,"$/Month"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,-43.46,"$/Month"]
[null,null,"Rate 11 | Large Volume Seasonal Service"]
[null,null,"Rate 16 | Contracted Firm Service"]

{"sheet":"G1.1 Rate 1 Bill Impact","index":14,"n_rows":189,"n_cols":12,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Rate 1 Delivery Bill Impact"]
[null,null,"G1.1 Rate 1 Bill Impact"]
[]
[null,null,"Rate 1"]
[]
[null,null,"Rate 1 - Existing Residential",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C12))","v":27.448077999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C12))","v":27.997484218863598}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C13))","v":1},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C13))","v":1}]
[null,null,"First 100 m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C14))","v":29.403535999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C14))","v":29.992083057283196}]
[null,null,"Next 400 m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C15))","v":28.824269960000002},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C15))","v":29.401222312373353}]
[null,null,"GT 500m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C16))","v":27.972877880000002},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C16))","v":28.532788598221657}]
[null,null,"Contracted Demand",null,"₵ / contracted m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C17))","v":0},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C17))","v":0}]
[null,null,"Gas Supply",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C18))","v":12.9848},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C18))","v":12.9848}]
[null,null,"Upstream Recovery \nCharge",null,"$/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C19))","v":1.474},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C19))","v":1.474}]
[null,null,"Transportation & \nStorage Charge",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,MATCH($C$8,'B1.1 Current Distribution Rates'!$C$10:$C$13,0),COUNTA('G1.1 Rate 1 Bill Impact'!$C$12:C20))","v":2.6981999999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($C$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($C$12:C20))","v":2.6981999999999999}]
[null,null,"Federal Carbon Charge",null,"₵/m3",{"$f":"'B1.1 Current Distribution Rates'!Q10","v":15.25},null,{"$f":"'E1.1 Proposed Dist Rates '!Q10","v":15.25}]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$10","v":1.633},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$9","v":1.633}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$19","v":0.1727480445706312},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$18","v":0.24809999999999999}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$28","v":2.3327246951066174},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$27","v":2.3088000000000002}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$37","v":-2.2906015564479656},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$36","v":0.50516000000000005}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$43","v":"ORDA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$46","v":-8.9275245292738045E-2},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$45","v":-0.27379999999999999}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$52","v":"CVVA Rate Rider"},null,"$/month",0,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$54","v":5.37}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F12*$E32","v":329.376936},null,{"$f":"H12*$E32","v":335.96981062636314},null,{"$f":"H32-F32","v":6.592874626363141},null,{"$f":"J32/F32","v":2.0016199999999821E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"F13*$E33","v":12},null,{"$f":"H13*$E33","v":12},null,{"$f":"H33-F33","v":0},null,{"$f":"J33/F33","v":0}]
[null,null,"First 100 m3",null,1001.3160527512506,{"$f":"F14*$E34/100","v":294.42232604449293},null,{"$f":"H14*$E34/100","v":300.31554220706471},null,{"$f":"H34-F34","v":5.8932161625717754},null,{"$f":"J34/F34","v":2.0016199999999987E-2}]
[null,null,"Next 400 m3",null,1147.6839472487493,330.81151924256352,null,337.43310877402649,null,6.6215895314629734,null,2.0016199999999918E-2]
[null,null,"GT 500m3",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E34:E37)","v":2149},279.04335200000003,null,279.04335200000003,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E38","v":2149},31.676259999999999,null,31.676259999999999,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E39","v":2149},57.984318000000002,null,57.984318000000002,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E38","v":2149},327.72250000000003,null,327.72250000000003,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F32:F41)","v":1663.0372112870566},null,{"$f":"SUM(H32:H41)","v":1682.1448916074544},null,{"$f":"SUM(J32:J41)","v":19.10768032039789},null,{"$f":"J42/F42","v":1.1489628849381E-2}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C24","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E38","v":2149},{"$f":"$E45*F24/100","v":35.093170000000001},null,{"$f":"$E45*H24/100","v":35.093170000000001},null,{"$f":"H45-F45","v":0},null,{"$f":"J45/F45","v":0}]
[null,null,{"$f":"C25","v":"ECVA Rate Rider"},null,{"$f":"E45","v":2149},{"$f":"$E46*F25/100","v":3.7123554778228645},null,{"$f":"$E46*H25/100","v":5.3316689999999998},null,{"$f":"H46-F46","v":1.6193135221771353},null,{"$f":"J46/F46","v":0.43619570697114179}]
[null,null,"CIACVA Rate Rider",null,{"$f":"E45","v":2149},50.130253697841205,null,{"$f":"$E47*H26/100","v":49.616112000000001},null,{"$f":"H47-F47","v":-0.51414169784120389},null,{"$f":"J47/F47","v":-1.0256116016092389E-2}]
[null,null,"MTVA Rate Rider",null,{"$f":"E46","v":2149},-49.225027448066783,null,{"$f":"$E48*H27/100","v":10.855888400000001},null,60.08091584806678,null,-1.220535954224772]
[null,null,"ORDA Rate Rider",null,{"$f":"E47","v":2149},-1.9185250213409406,null,{"$f":"$E49*H28/100","v":-5.8839620000000004},null,{"$f":"H49-F49","v":-3.96543697865906},null,{"$f":"J49/F49","v":2.06691960466976}]
[null,null,"CVVA Rate Rider",null,12,{"$f":"$E50*F29","v":0},null,{"$f":"$E50*H29","v":64.44},null,64.44,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F45:F50)","v":37.792226706256344},null,{"$f":"SUM(H45:H50)","v":159.45287740000001},null,{"$f":"SUM(J45:J50)","v":121.66065069374365},null,{"$f":"J51/F51","v":3.2191977371262763}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F42+F51","v":1700.8294379933129},null,{"$f":"H42+H51","v":1841.5977690074544},null,{"$f":"J42+J51","v":140.76833101414155},null,{"$f":"J53/F53","v":8.2764519398384848E-2}]
[]
[]
[null,null,"Rate 1 - New Residential",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F12","v":27.448077999999999},null,{"$f":"H12","v":27.997484218863598}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",29.403535999999999,null,29.992083057283196]
[null,null,"Next 400 m3",null,"₵/m3",28.824269960000002,null,29.401222312373353]
[null,null,"GT 500m3",null,"₵/m3",27.972877880000002,null,28.532788598221657]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",12.9848,null,12.9848]
[null,null,"Upstream Recovery \nCharge",null,"₵/m3",1.474,null,1.474]
[null,null,"Transportation & \nStorage Charge",null,"₵/m3",2.6981999999999999,null,2.6981999999999999]
[null,null,"Federal Carbon Charge",null,"₵/m3",15.25,null,15.25]
[]
[null,null,"Rate Riders"]
[null,null,{"$f":"C24","v":"Delay in Revenue Recovery Rate Rider"},null,"₵/m3",{"$f":"F24","v":1.633},null,{"$f":"H24","v":1.633}]
[null,null,{"$f":"C25","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F25","v":0.1727480445706312},null,{"$f":"H25","v":0.24809999999999999}]
[null,null,"CIACVA Rate Rider",null,"₵/m3",2.3327246951066174,null,2.3088000000000002]
[null,null,"MTVA Rate Rider",null,"₵/m3",-2.2906015564479656,null,0.50516000000000005]
[null,null,"ORDA Rate Rider",null,"₵/m3",-8.9275245292738045E-2,null,-0.27379999999999999]
[null,null,"CVVA Rate Rider",null,{"$f":"E58","v":"$/month"},0,null,5.37]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F58*$E78","v":329.376936},null,{"$f":"H58*$E78","v":335.96981062636314},null,{"$f":"H78-F78","v":6.592874626363141},null,{"$f":"J78/F78","v":2.0016199999999821E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E78","v":12},{"$f":"F59*$E79","v":12},null,{"$f":"H59*$E79","v":12},null,{"$f":"H79-F79","v":0},null,{"$f":"J79/F79","v":0}]
[null,null,"First 100 m3",null,993.12960436562071,{"$f":"F60*$E80/100","v":292.01522074630282},null,{"$f":"H60*$E80/100","v":297.86025580780495},null,{"$f":"H80-F80","v":5.8450350615021307},null,{"$f":"J80/F80","v":2.0016199999999946E-2}]
[null,null,"Next 400 m3",null,1072.8703956343793,309.24705915857356,null,315.4370101441034,null,6.1899509855298334,null,2.0016199999999977E-2]
[null,null,"GT 500m3",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E80:E83)","v":2066},268.26596799999999,null,268.26596799999999,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E84","v":2066},30.452840000000002,null,30.452840000000002,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E85","v":2066},55.744812000000003,null,55.744812000000003,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E84","v":2066},315.065,null,315.065,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F78:F87)","v":1612.1678359048763},null,{"$f":"SUM(H78:H87)","v":1630.7956965782714},null,{"$f":"SUM(J78:J87)","v":18.627860673395105},null,{"$f":"J88/F88","v":1.1554541815393355E-2}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C70","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E84","v":2066},{"$f":"$E91*F70/100","v":33.737780000000001},null,{"$f":"$E91*H70/100","v":33.737780000000001},null,{"$f":"H91-F91","v":0},null,{"$f":"J91/F91","v":0}]
[null,null,{"$f":"C71","v":"ECVA Rate Rider"},null,{"$f":"E91","v":2066},{"$f":"$E92*F71/100","v":3.5689746008292405},null,{"$f":"$E92*H71/100","v":5.1257459999999995},null,{"$f":"H92-F92","v":1.556771399170759},null,{"$f":"J92/F92","v":0.43619570697114174}]
[null,null,"CIACVA Rate Rider",null,{"$f":"E91","v":2066},48.194092200902716,null,47.699808000000004,null,-0.49428420090271175,null,-1.025611601609239E-2]
[null,null,"MTVA Rate Rider",null,{"$f":"E92","v":2066},-47.323828156214965,null,10.4366056,null,57.760433756214965,null,-1.220535954224772]
[null,null,"ORDA Rate Rider",null,{"$f":"E93","v":2066},-1.8444265677479681,null,-5.6567080000000001,null,-3.812281432252032,null,2.0669196046697595]
[null,null,"CVVA Rate Rider",null,{"$f":"E50","v":12},{"$f":"$E96*F75","v":0},null,{"$f":"$E96*H75","v":64.44},null,64.44,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F91:F96)","v":36.332592077769036},null,{"$f":"SUM(H91:H96)","v":155.78323160000002},null,{"$f":"SUM(J91:J96)","v":119.45063952223097},null,{"$f":"J97/F97","v":3.2876993545230619}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F88+F97","v":1648.5004279826453},null,{"$f":"H88+H97","v":1786.5789281782713},null,{"$f":"J88+J97","v":138.07850019562608},null,{"$f":"J99/F99","v":8.3760063298618515E-2}]
[]
[null,null,"Rate 1 - Small Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F58","v":27.448077999999999},null,{"$f":"H58","v":27.997484218863598}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",29.403535999999999,null,29.992083057283196]
[null,null,"Next 400 m3",null,"₵/m3",28.824269960000002,null,29.401222312373353]
[null,null,"GT 500m3",null,"₵/m3",27.972877880000002,null,28.532788598221657]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",12.9848,null,12.9848]
[null,null,"Upstream Recovery \nCharge",null,"₵/m3",1.474,null,1.474]
[null,null,"Transportation & \nStorage Charge",null,"₵/m3",2.6981999999999999,null,2.6981999999999999]
[null,null,"Federal Carbon Charge",null,"₵/m3",15.25,null,15.25]
[]
[null,null,"Rate Riders"]
[null,null,{"$f":"C70","v":"Delay in Revenue Recovery Rate Rider"},null,"₵/m3",{"$f":"F70","v":1.633},null,{"$f":"H70","v":1.633}]
[null,null,{"$f":"C71","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F71","v":0.1727480445706312},null,{"$f":"H71","v":0.24809999999999999}]
[null,null,"CIACVA Rate Rider",null,"₵/m3",2.3327246951066174,null,2.3088000000000002]
[null,null,"MTVA Rate Rider",null,"₵/m3",-2.2906015564479656,null,0.50516000000000005]
[null,null,"ORDA Rate Rider",null,"₵/m3",-8.9275245292738045E-2,null,-0.27379999999999999]
[null,null,"CVVA Rate Rider",null,"₵/m3",0,null,5.37]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F103*$E123","v":329.376936},null,{"$f":"H103*$E123","v":335.96981062636314},null,{"$f":"H123-F123","v":6.592874626363141},null,{"$f":"J123/F123","v":2.0016199999999821E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E123","v":12},{"$f":"F104*$E124","v":12},null,{"$f":"H104*$E124","v":12},null,{"$f":"H124-F124","v":0},null,{"$f":"J124/F124","v":0}]
[null,null,"First 100 m3",null,1198.1709868121873,{"$f":"F105*$E125/100","v":352.30463744887675},null,{"$f":"H105*$E125/100","v":359.35643753298092},null,{"$f":"H125-F125","v":7.0518000841041726},null,{"$f":"J125/F125","v":2.0016199999999904E-2}]
[null,null,"Next 400 m3",null,2475.0040927694408,713.40186122091256,null,727.68145555548256,null,14.279594334569992,null,2.0016199999999946E-2]
[null,null,"GT 500m3",null,1019.8249204183721,285.27437957843847,null,290.98448861495638,null,5.7101090365179061,null,2.001619999999988E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E125:E128)","v":4693},609.37666400000001,null,609.37666400000001,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E129","v":4693},69.174819999999997,null,69.174819999999997,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E130","v":4693},126.626526,null,126.626526,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E129","v":4693},715.6825,null,715.6825,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F123:F132)","v":3213.2183242482279},null,{"$f":"SUM(H123:H132)","v":3246.8527023297829},null,{"$f":"SUM(J123:J132)","v":33.634378081555212},null,{"$f":"J133/F133","v":1.0467504753018733E-2}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C45","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E129","v":4693},{"$f":"$E136*F115/100","v":76.636690000000002},null,{"$f":"$E136*H115/100","v":76.636690000000002},null,{"$f":"H136-F136","v":0},null,{"$f":"J136/F136","v":0}]
[null,null,{"$f":"C46","v":"ECVA Rate Rider"},null,{"$f":"E130","v":4693},{"$f":"$E137*F116/100","v":8.1070657316997217},null,{"$f":"$E137*H116/100","v":11.643333},null,{"$f":"H137-F137","v":3.5362672683002785},null,{"$f":"J137/F137","v":0.43619570697114196}]
[null,null,"CIACVA Rate Rider",null,4693,109.47476994135356,null,108.35198400000002,null,-1.1227859413535413,null,-1.0256116016092347E-2]
[null,null,"MTVA Rate Rider",null,4693,-107.49793104410303,null,23.707158800000002,null,131.20508984410304,null,-1.2205359542247722]
[null,null,"ORDA Rate Rider",null,{"$f":"E136","v":4693},-4.1896872615881966,null,-12.849433999999999,null,-8.6597467384118012,null,2.0669196046697591]
[null,null,"CVVA Rate Rider",null,12,{"$f":"$E141*F120","v":0},null,{"$f":"$E141*H120","v":64.44},null,64.44,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F136:F141)","v":82.530907367362062},null,{"$f":"SUM(H136:H141)","v":271.92973180000001},null,{"$f":"SUM(J136:J141)","v":189.39882443263798},null,{"$f":"J142/F142","v":2.2948835833051588}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F133+F142","v":3295.7492316155899},null,{"$f":"H133+H142","v":3518.7824341297828},null,{"$f":"J133+J142","v":223.03320251419319},null,{"$f":"J144/F144","v":6.7672989308370832E-2}]
[]
[null,null,"Rate 1 - Small Agricultural",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F103","v":27.448077999999999},null,{"$f":"H103","v":27.997484218863598}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",{"$f":"F105","v":29.403535999999999},null,{"$f":"H105","v":29.992083057283196}]
[null,null,"Next 400 m3",null,"₵/m3",28.824269960000002,null,29.401222312373353]
[null,null,"GT 500m3",null,"₵/m3",27.972877880000002,null,28.532788598221657]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",12.9848,null,12.9848]
[null,null,"Upstream Recovery \nCharge",null,"₵/m3",1.474,null,1.474]
[null,null,"Transportation & \nStorage Charge",null,"₵/m3",2.6981999999999999,null,2.6981999999999999]
[null,null,"Federal Carbon Charge",null,"₵/m3",15.25,null,15.25]
[]
[null,null,"Rate Riders"]
[null,null,{"$f":"C24","v":"Delay in Revenue Recovery Rate Rider"},null,"₵/m3",{"$f":"F115","v":1.633},null,{"$f":"H115","v":1.633}]
[null,null,{"$f":"C25","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F116","v":0.1727480445706312},null,{"$f":"H116","v":0.24809999999999999}]
[null,null,"CIACVA Rate Rider",null,"₵/m3",2.3327246951066174,null,2.3088000000000002]
[null,null,"MTVA Rate Rider",null,"₵/m3",-2.2906015564479656,null,0.50516000000000005]
[null,null,"ORDA Rate Rider",null,"₵/m3",-8.9275245292738045E-2,null,-0.27379999999999999]
[null,null,"CVVA Rate Rider",null,{"$f":"E148","v":"$/month"},0,null,5.37]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F148*$E168","v":329.376936},null,{"$f":"H148*$E168","v":335.96981062636314},null,{"$f":"H168-F168","v":6.592874626363141},null,{"$f":"J168/F168","v":2.0016199999999821E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E168","v":12},{"$f":"F149*$E169","v":12},null,{"$f":"H149*$E169","v":12},null,{"$f":"H169-F169","v":0},null,{"$f":"J169/F169","v":0}]
[null,null,"First 100 m3",null,1198.7357889949976,{"$f":"F150*$E170/100","v":352.47070926202815},null,{"$f":"H150*$E170/100","v":359.52583347275873},null,{"$f":"H170-F170","v":7.0551242107305825},null,{"$f":"J170/F170","v":2.0016199999999928E-2}]
[null,null,"Next 400 m3",null,2484.0654843110506,716.01374118099875,null,730.34561542722588,null,14.33187424622713,null,2.0016200000000033E-2]
[null,null,"GT 500m3",null,1037.1987266939518,290.13433319101409,null,295.9417200310321,null,5.8073868400180118,null,2.0016200000000123E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Commodity",null,{"$f":"SUM(E170:E173)","v":4720},612.88256000000001,null,612.88256000000001,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E174","v":4720},69.572800000000001,null,69.572800000000001,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E175","v":4720},127.35503999999999,null,127.35503999999999,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E174","v":4720},719.8,null,719.8,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F168:F177)","v":3229.6061196340406},null,{"$f":"SUM(H168:H177)","v":3263.3933795573794},null,{"$f":"SUM(J168:J177)","v":33.787259923338866},null,{"$f":"J178/F178","v":1.0461727737612609E-2}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C136","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E174","v":4720},{"$f":"$E181*F160/100","v":77.077600000000004},null,{"$f":"$E181*H160/100","v":77.077600000000004},null,{"$f":"H181-F181","v":0},null,{"$f":"J181/F181","v":0}]
[null,null,{"$f":"C137","v":"ECVA Rate Rider"},null,{"$f":"E175","v":4720},{"$f":"$E182*F161/100","v":8.1537077037337937},null,{"$f":"$E182*H161/100","v":11.710319999999999},null,{"$f":"H182-F182","v":3.5566122962662057},null,{"$f":"J182/F182","v":0.43619570697114157}]
[null,null,"CIACVA Rate Rider",null,4720,110.10460560903233,null,108.97535999999999,null,-1.1292456090323384,null,-1.0256116016092444E-2]
[null,null,"MTVA Rate Rider",null,4720,-108.11639346434399,null,23.843552000000003,null,131.959945464344,null,-1.220535954224772]
[null,null,"ORDA Rate Rider",null,{"$f":"E184","v":4720},-4.2137915778172355,null,-12.923360000000001,null,-8.7095684221827661,null,2.0669196046697604]
[null,null,"CVVA Rate Rider",null,{"$f":"E141","v":12},{"$f":"$E186*F165","v":0},null,{"$f":"$E186*H165","v":64.44},null,64.44,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F181:F186)","v":83.005728270604919},null,{"$f":"SUM(H181:H186)","v":273.12347199999999},null,{"$f":"SUM(J181:J186)","v":190.1177437293951},null,{"$f":"J187/F187","v":2.290417151809053}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F178+F187","v":3312.6118479046454},null,{"$f":"H178+H187","v":3536.5168515573796},null,{"$f":"J178+J187","v":223.90500365273397},null,{"$f":"J189/F189","v":6.7591681106364002E-2}]

{"sheet":"G1.2 Rate 6 Bill Impact","index":15,"n_rows":97,"n_cols":12,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Rate 6 Delivery Bill Impact"]
[null,null,"G1.2 Rate 6 Bill Impact"]
[]
[null,null,"Rate 6 - Medium Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C10))","v":111.93205400000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C10))","v":114.1725083792748}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C11))","v":1},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C11))","v":1}]
[null,null,"First 1000 m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C12))","v":27.125478620000003},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C12))","v":27.668427625153644}]
[null,null,"Next 6000 m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C13))","v":24.413022900000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C13))","v":24.901678848970981}]
[null,null,"GT 7000m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C14))","v":23.192141400000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C14))","v":23.656359940690677}]
[null,null,"Contracted Demand",null,"₵ / contracted m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C15))","v":0},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C15))","v":0}]
[null,null,"Gas Supply",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C16))","v":12.9848},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C16))","v":12.9848}]
[null,null,"Upstream Recovery \nCharge",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C17))","v":2.92},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C17))","v":2.92}]
[null,null,"Transportation & \nStorage Charge",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C18))","v":5.6413000000000002},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C18))","v":5.6413000000000002}]
[null,null,"Federal Carbon Charge",null,"₵/m3",{"$f":"'B1.1 Current Distribution Rates'!Q11","v":15.25},null,{"$f":"'E1.1 Proposed Dist Rates '!Q11","v":15.25}]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$11","v":0.90900000000000003},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$10","v":0.90900000000000003}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$20","v":0.19051597258377229},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$19","v":0.28149999999999997}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$29","v":3.1292490684040697},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$28","v":3.0468999999999999}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$38","v":-3.987512919623855},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$37","v":0.86511000000000005}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$43","v":"ORDA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$47","v":-7.5936581997670949E-2},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$46","v":-0.2291}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$52","v":"CVVA Rate Rider"},null,{"$f":"E10","v":"$/month"},0,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$55","v":-43.46}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E30","v":1343.1846480000002},null,{"$f":"H10*$E30","v":1370.0701005512976},null,{"$f":"H30-F30","v":26.885452551297476},null,{"$f":"J30/F30","v":2.0016199999999904E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E30","v":12},{"$f":"E31*F11","v":12},null,{"$f":"E31*H11","v":12},null,0,null,0]
[null,null,"First 1000 m3",null,9831.5433379437527,{"$f":"F12*$E32/100","v":2666.8531861499673},null,{"$f":"H12*$E32/100","v":2720.2334528945817},null,53.380266744614346,null,2.0016199999999765E-2]
[null,null,"Next 6000 m3",null,17101.456662056247,4174.9825311413679,null,4258.5498164811988,null,83.56728533983096,null,2.0016199999999786E-2]
[null,null,"GT 7000m3",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E32:E35)","v":26933},3497.1961839999999,null,3497.1961839999999,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E36","v":26933},786.44360000000006,null,786.44360000000006,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E37","v":26933},1519.3713290000001,null,1519.3713290000001,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E38","v":26933},4107.2825000000003,null,4107.2825000000003,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F30:F39)","v":18107.313978291335},null,{"$f":"SUM(H30:H39)","v":18271.146982927079},null,{"$f":"SUM(J30:J39)","v":163.83300463574278},null,9.0478910804860629E-3]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C22","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E36","v":26933},{"$f":"$E43*F22/100","v":244.82097000000002},null,{"$f":"$E43*H22/100","v":244.82097000000002},null,{"$f":"H43-F43","v":0},null,{"$f":"J43/F43","v":0}]
[null,null,{"$f":"C23","v":"ECVA Rate Rider"},null,{"$f":"E43","v":26933},{"$f":"$E44*F23/100","v":51.311666895987393},null,{"$f":"$E44*H23/100","v":75.816395},null,{"$f":"H44-F44","v":24.504728104012607},null,{"$f":"J44/F44","v":0.47756640129593786}]
[null,null,"CIACVA Rate Rider",null,{"$f":"E43","v":26933},842.80065159326807,null,820.621577,null,-22.179074593268069,null,-2.6315920083046632E-2]
[null,null,"MTVA Rate Rider",null,{"$f":"E45","v":26933},-1073.9568546422929,null,233.00007629999999,null,1306.956930942293,null,-1.2169547829531815]
[null,null,"ORDA Rate Rider",null,{"$f":"E44","v":26933},-20.451999629432716,null,-61.703502999999998,null,-41.251503370567278,null,2.0169912046742731]
[null,null,"CVVA Rate Rider",null,{"$f":"E30","v":12},{"$f":"$E48*F27","v":0},null,{"$f":"$E48*H27","v":-521.52},null,-521.52,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F43:F48)","v":44.524434217529944},null,{"$f":"SUM(H43:H48)","v":791.03551530000004},null,{"$f":"SUM(J43:J48)","v":746.51108108247035},null,{"$f":"J49/F49","v":16.766323799541009}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F40+F49","v":18151.838412508863},null,{"$f":"H40+H49","v":19062.182498227077},null,{"$f":"J40+J49","v":910.34408571821314},null,{"$f":"J51/F51","v":5.0151619082884374E-2}]
[]
[]
[null,null,"Rate 6 - Large Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F10","v":111.93205400000001},null,{"$f":"H10","v":114.1725083792748}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 1000 m3",null,"₵/m3",27.125478620000003,null,27.668427625153644]
[null,null,"Next 6000 m3",null,"₵/m3",24.413022900000001,null,24.901678848970981]
[null,null,"GT 7000m3",null,"₵/m3",23.192141400000001,null,23.656359940690677]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",12.9848,null,12.9848]
[null,null,"Upstream Recovery \nCharge",null,"₵/m3",2.92,null,2.92]
[null,null,"Transportation & \nStorage Charge",null,"₵/m3",5.6413000000000002,null,5.6413000000000002]
[null,null,"Federal Carbon Charge",null,"₵/m3",15.25,null,15.25]
[]
[null,null,"Rate Riders"]
[null,null,{"$f":"C22","v":"Delay in Revenue Recovery Rate Rider"},null,"₵/m3",{"$f":"F22","v":0.90900000000000003},null,{"$f":"H22","v":0.90900000000000003}]
[null,null,{"$f":"C23","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F23","v":0.19051597258377229},null,{"$f":"H23","v":0.28149999999999997}]
[null,null,"CIACVA Rate Rider",null,"₵/m3",3.1292490684040697,null,3.0468999999999999]
[null,null,"MTVA Rate Rider",null,"₵/m3",-3.987512919623855,null,0.86511000000000005]
[null,null,"ORDA Rate Rider",null,"₵/m3",-7.5936581997670949E-2,null,-0.2291]
[null,null,"CVVA Rate Rider",null,"$/month",0,null,-43.46]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F56*$E76","v":1343.1846480000002},null,{"$f":"H56*$E76","v":1370.0701005512976},null,{"$f":"H76-F76","v":26.885452551297476},null,{"$f":"J76/F76","v":2.0016199999999904E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"E77*F57","v":12},null,{"$f":"E77*H57","v":12},null,{"$f":"H77-F77","v":0},null,{"$f":"J77/F77","v":0}]
[null,null,"First 1000 m3",null,11715.326187183033,{"$f":"F58*$E78/100","v":3177.8383001675952},null,{"$f":"H58*$E78/100","v":3241.4465471514095},null,{"$f":"H78-F78","v":63.608246983814297},null,{"$f":"J78/F78","v":2.0016199999999897E-2}]
[null,null,"Next 6000 m3",null,40792.718418626093,9958.7356890717074,null,10158.071734371302,null,199.33604529959484,null,2.0016199999999772E-2]
[null,null,"GT 7000m3",null,23176.955394190867,5375.2322672356731,null,5482.8239913431162,null,107.59172410744304,null,2.0016200000000067E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E78:E81)","v":75685},9827.5458799999997,null,9827.5458799999997,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E82","v":75685},2210.002,null,2210.002,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E83","v":75685},4269.6179050000001,null,4269.6179050000001,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E84","v":75685},11541.9625,null,11541.9625,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F76:F85)","v":47716.119189474972},null,{"$f":"SUM(H76:H85)","v":48113.540658417129},null,{"$f":"SUM(J76:J85)","v":397.42146894214966},null,{"$f":"J86/F86","v":8.3288724165525036E-3}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C43","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E82","v":75685},{"$f":"$E89*F68/100","v":687.97665000000006},null,{"$f":"$E89*H68/100","v":687.97665000000006},null,{"$f":"H89-F89","v":0},null,{"$f":"J89/F89","v":0}]
[null,null,{"$f":"C44","v":"ECVA Rate Rider"},null,{"$f":"E89","v":75685},{"$f":"$E90*F69/100","v":144.19201385002805},null,{"$f":"$E90*H69/100","v":213.05327499999999},null,{"$f":"H90-F90","v":68.861261149971938},null,{"$f":"J90/F90","v":0.47756640129593797}]
[null,null,"CIACVA Rate Rider",null,{"$f":"E90","v":75685},2368.3721574216202,null,2306.0462649999999,null,-62.32589242162021,null,-2.631592008304668E-2]
[null,null,"MTVA Rate Rider",null,75685,-3017.9491532173147,null,654.75850349999996,null,3672.7076567173144,null,-1.2169547829531813]
[null,null,"ORDA Rate Rider",null,75685,-57.472602084937265,null,-173.39433499999998,null,-115.92173291506272,null,2.0169912046742726]
[null,null,"CVVA Rate Rider",null,{"$f":"E48","v":12},{"$f":"$E94*F73","v":0},null,{"$f":"$E94*H73","v":-521.52},null,-521.52,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F89:F94)","v":125.11906596939643},null,{"$f":"SUM(H89:H94)","v":3166.9203585},null,{"$f":"SUM(J89:J94)","v":3041.8012925306034},null,{"$f":"J95/F95","v":24.311253196811862}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F86+F95","v":47841.238255444368},null,{"$f":"H86+H95","v":51280.461016917128},null,{"$f":"J86+J95","v":3439.2227614727531},null,{"$f":"J97/F97","v":7.1888247187694126E-2}]

{"sheet":"G1.3 Rate 11 Bill Impact","index":16,"n_rows":96,"n_cols":12,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Rate 11 Delivery Bill Impact"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.3 Rate 11 Bill Impact"}]
[]
[null,null,"Rate 11 - Large Seasonal Service Sample Dryer 1",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C10:C$10))","v":223.86410800000002},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C10:C$10))","v":228.3450167585496}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C11))","v":1},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C11))","v":1}]
[null,null,"All Volumes",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C12))","v":16.849495640000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C12))","v":17.186758514629368}]
[null,null,"Tier 2",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C13))","v":16.849495640000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C13))","v":17.186758514629368}]
[null,null,"Tier 3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C14))","v":16.849495640000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C14))","v":17.186758514629368}]
[null,null,"Contracted Demand",null,"₵ / contracted m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C15))","v":0},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C15))","v":0}]
[null,null,"Gas Supply",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C16))","v":12.9848},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C16))","v":12.9848}]
[null,null,"Upstream Recovery \nCharge",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C17))","v":3.5200000000000002E-2},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C17))","v":3.5200000000000002E-2}]
[null,null,"Transportation & \nStorage Charge",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C18))","v":1.8166},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C18))","v":1.8166}]
[null,null,"Federal Carbon Charge",null,"₵/m3",{"$f":"'B1.1 Current Distribution Rates'!Q12","v":15.25},null,{"$f":"'E1.1 Proposed Dist Rates '!Q12","v":15.25}]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$12","v":0.5524},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$11","v":0.5524}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$21","v":0.14267864933646654},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$20","v":0.1847}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$30","v":0.60585649438223443},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$29","v":0.57889999999999997}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$39","v":-0.77397951503382845},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$38","v":0.16478999999999999}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$43","v":"ORDA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!$E$48","v":-2.9381537908305999E-2},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$47","v":-8.6999999999999994E-2}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$52","v":"CVVA Rate Rider"},null,"₵/m3",0,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$56","v":0}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E30","v":2686.3692960000003},null,{"$f":"H10*$E30","v":2740.1402011025953},null,{"$f":"H30-F30","v":53.770905102594952},null,{"$f":"J30/F30","v":2.0016199999999904E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"$E31*F11","v":12},null,{"$f":"$E31*H11","v":12},null,0,null,0]
[null,null,"All Volumes",null,101499.48573593894,{"$f":"F12*$E32/100","v":17102.151423699455},null,{"$f":"H12*$E32/100","v":17444.471507026508},null,342.320083327053,null,2.0016199999999998E-2]
[null,null,"Tier 2",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 3",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E32:E35)","v":101499.48573593894},13179.5052238402,null,13179.5052238402,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E36","v":101499.48573593894},35.727818979050511,null,35.727818979050511,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E37","v":101499.48573593894},1843.8396578790669,null,1843.8396578790669,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E38","v":101499.48573593894},{"$f":"$E39*F19/100","v":15478.67157473069},null,{"$f":"$E39*H19/100","v":15478.67157473069},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F30:F39)","v":50338.264995128462},null,{"$f":"SUM(H30:H39)","v":50734.355983558111},null,{"$f":"SUM(J30:J39)","v":396.09098842964795},null,7.8685864216412708E-3]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C22","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E36","v":101499.48573593894},{"$f":"$E43*F22/100","v":560.68315920532677},null,{"$f":"$E43*H22/100","v":560.68315920532677},null,{"$f":"H43-F43","v":0},null,{"$f":"J43/F43","v":0}]
[null,null,{"$f":"C23","v":"ECVA Rate Rider"},null,{"$f":"E37","v":101499.48573593894},{"$f":"$E44*F23/100","v":144.8180953314972},null,{"$f":"$E44*H23/100","v":187.46955015427923},null,{"$f":"H44-F44","v":42.651454822782028},null,{"$f":"J44/F44","v":0.29451744082913339}]
[null,null,"CIACVA Rate Rider",null,101499.48573593894,614.94122609575572,null,587.58052292535058,null,-27.360703170405145,null,-4.4493200340652829E-2]
[null,null,"MTVA Rate Rider",null,101499.48573593894,-785.58522746085009,null,167.26100254425378,null,952.84623000510385,null,-1.2129126117669891]
[null,null,"ORDA Rate Rider",null,{"$f":"E46","v":101499.48573593894},-29.822109878240539,null,-88.304552590266866,null,-58.482442712026327,null,1.9610430969103754]
[null,null,"CVVA Rate Rider",null,{"$f":"E47","v":101499.48573593894},0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F43:F48)","v":505.035143293489},null,{"$f":"SUM(H43:H48)","v":1414.6896822389435},null,909.65453894545442,null,{"$f":"J49/F49","v":1.8011707720245334}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F40+F49","v":50843.300138421953},null,{"$f":"H40+H49","v":52149.045665797057},null,{"$f":"J40+J49","v":1305.7455273751025},null,{"$f":"J51/F51","v":2.5681761880526694E-2}]
[]
[null,null,"Rate 11 - Large Seasonal Service Sample Dryer 2",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F10","v":223.86410800000002},null,{"$f":"H10","v":228.3450167585496}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"All Volumes",null,"₵/m3",{"$f":"F12","v":16.849495640000001},null,{"$f":"H12","v":17.186758514629368}]
[null,null,"Tier 2",null,"₵/m3",16.849495640000001,null,17.186758514629368]
[null,null,"Tier 3",null,"₵/m3",16.849495640000001,null,17.186758514629368]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",12.9848,null,12.9848]
[null,null,"Upstream Recovery \nCharge",null,"₵/m3",3.5200000000000002E-2,null,3.5200000000000002E-2]
[null,null,"Transportation & \nStorage Charge",null,"₵/m3",1.8166,null,1.8166]
[null,null,"Federal Carbon Charge",null,"₵/m3",12.39,null,{"$f":"F64","v":12.39}]
[]
[null,null,"Rate Riders"]
[null,null,{"$f":"C22","v":"Delay in Revenue Recovery Rate Rider"},null,"₵/m3",{"$f":"F22","v":0.5524},null,{"$f":"H22","v":0.5524}]
[null,null,{"$f":"C23","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F23","v":0.14267864933646654},null,{"$f":"H23","v":0.1847}]
[null,null,"CIACVA Rate Rider",null,"₵/m3",0.60585649438223443,null,0.57889999999999997]
[null,null,"MTVA Rate Rider",null,"₵/m3",-0.77397951503382845,null,0.16478999999999999]
[null,null,"ORDA Rate Rider",null,"₵/m3",-2.9381537908305999E-2,null,-8.6999999999999994E-2]
[null,null,"CVVA Rate Rider",null,"₵/m3",0,null,0]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F55*$E75","v":2686.3692960000003},null,{"$f":"H55*$E75","v":2740.1402011025953},null,{"$f":"H75-F75","v":53.770905102594952},null,{"$f":"J75/F75","v":2.0016199999999904E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"$E76*F56","v":12},null,{"$f":"$E76*H56","v":12},null,{"$f":"H76-F76","v":0},null,{"$f":"J76/F76","v":0}]
[null,null,"All Volumes",null,338331.61911979644,{"$f":"F57*$E77/100","v":57007.171412331511},null,{"$f":"H57*$E77/100","v":58148.238356755013},null,{"$f":"H77-F77","v":1141.0669444235027},null,{"$f":"J77/F77","v":2.0016199999999873E-2}]
[null,null,"Tier 2",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 3",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E77:E80)","v":338331.61911979644},43931.684079467326,null,43931.684079467326,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E81","v":338331.61911979644},119.09272993016835,null,119.09272993016835,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E82","v":338331.61911979644},6146.1321929302221,null,6146.1321929302221,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E83","v":338331.61911979644},{"$f":"$E84*F64/100","v":41919.287608942781},null,{"$f":"$E84*H64/100","v":41919.287608942781},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F75:F84)","v":151821.73731960199},null,{"$f":"SUM(H75:H84)","v":153016.5751691281},null,{"$f":"SUM(J75:J84)","v":1194.8378495260977},null,{"$f":"J85/F85","v":7.8700051166640805E-3}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C67","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E81","v":338331.61911979644},{"$f":"$E88*F67/100","v":1868.9438640177555},null,{"$f":"$E88*H67/100","v":1868.9438640177555},null,{"$f":"H88-F88","v":0},null,{"$f":"J88/F88","v":0}]
[null,null,{"$f":"C68","v":"ECVA Rate Rider"},null,{"$f":"E82","v":338331.61911979644},{"$f":"$E89*F68/100","v":482.72698443832394},null,{"$f":"$E89*H68/100","v":624.89850051426401},null,{"$f":"H89-F89","v":142.17151607594008},null,{"$f":"J89/F89","v":0.29451744082913339}]
[null,null,"CIACVA Rate Rider",null,338331.61911979644,2049.8040869858523,null,1958.6017430845013,null,-91.202343901351014,null,-4.4493200340653086E-2]
[null,null,"MTVA Rate Rider",null,338331.61911979644,-2618.6174248695002,null,557.53667514751248,null,3176.1541000170128,null,-1.2129126117669891]
[null,null,"ORDA Rate Rider",null,{"$f":"E91","v":338331.61911979644},-99.407032927468464,null,-294.34850863422287,null,-194.9414757067544,null,1.9610430969103751]
[null,null,"CVVA Rate Rider",null,{"$f":"E92","v":338331.61911979644},0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F88:F93)","v":1683.4504776449633},null,{"$f":"SUM(H88:H93)","v":4715.63227412981},null,{"$f":"SUM(J88:J93)","v":3032.1817964848474},null,{"$f":"J94/F94","v":1.8011707720245331}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F85+F94","v":153505.18779724697},null,{"$f":"H85+H94","v":157732.20744325791},null,{"$f":"J85+J94","v":4227.0196460109455},null,{"$f":"J96/F96","v":2.7536656621625622E-2}]

{"sheet":"G1.4 Rate 16 Bill Impact","index":17,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Rate 16 Delivery Bill Impact"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.4 Rate 16 Bill Impact"}]
[]
[null,null,"Rate 16 - Contracted Demand",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C10))","v":1646.034926},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C10))","v":1678.9822902858011}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C11))","v":1},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C11))","v":1}]
[null,null,"Tier 1",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C12))","v":0},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C12))","v":0}]
[null,null,"Tier 2",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C13))","v":0},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C13))","v":0}]
[null,null,"Tier 3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C14))","v":0},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C14))","v":0}]
[null,null,"Contracted Demand",null,"₵ / contracted m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C15))","v":112.27502700000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C15))","v":114.5223463954374}]
[null,null,"Gas Supply",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C16))","v":0},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C16))","v":0}]
[null,null,"Upstream Recovery \nCharge",null,"₵ / contracted m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C17))","v":14.243399999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C17))","v":14.243399999999999}]
[null,null,"Transportation Charge From Dawn",null,"₵ / contracted m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C18)+1)","v":18.299900000000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C18)+1)","v":18.299900000000001}]
[null,null,"Transportation Charge \nFrom Kirkwall",null,"₵ / contracted m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C19)+1)","v":11.848000000000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C19)+1)","v":11.848000000000001}]
[null,null,"Transportation Charge From Parkway",null,"₵ / contracted m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C20)+1)","v":11.848000000000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C20)+1)","v":11.848000000000001}]
[null,null,"Federal Carbon Charge",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,4,COUNTA($C$10:C21)+1)","v":15.25},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C21)+1)","v":15.25}]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!$E$13","v":6.0100000000000001E-2},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$12","v":6.0100000000000001E-2}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!$E$22","v":0},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$21","v":0}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!$E$31","v":4.7721417037354747},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$30","v":4.7092000000000001}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!$E$40","v":-5.6379529980995775},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$39","v":1.2396799999999999}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$43","v":"ORDA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!$E$49","v":-5.0585942560899509E-2},null,{"$f":"'F1.3 Proposed Rate Riders'!$E$48","v":-0.1547}]
[null,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$52","v":"CVVA Rate Rider"},null,"₵ / contracted m3",0,null,{"$f":"'F1.3 Proposed Rate Riders'!$E$57","v":0}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E32","v":19752.419112},null,{"$f":"H10*$E32","v":20147.787483429613},null,{"$f":"H32-F32","v":395.36837142961303},null,{"$f":"J32/F32","v":2.0016199999999932E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E32","v":12},{"$f":"$E33*F11","v":12},null,{"$f":"$E33*H11","v":12},null,0,null,0]
[null,null,"Tier 1",null,0,{"$f":"F12*$E34/100","v":0},null,{"$f":"H12*$E34/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 2",null,0,{"$f":"F13*$E35/100","v":0},null,{"$f":"H13*$E35/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 3",null,0,{"$f":"F14*$E36/100","v":0},null,{"$f":"H14*$E36/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,50000,{"$f":"F15*$E37/100*$E$32","v":673650.16200000013},null,{"$f":"H15*$E37/100*$E$32","v":687134.07837262447},null,13483.916372624342,null,2.0016199999999911E-2]
[null,null,"Gas Supply",null,0,{"$f":"F16*$E38/100","v":0},null,{"$f":"H16*$E38/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"$E$37","v":50000},{"$f":"F17*$E39/100*$E$32","v":85460.4},null,{"$f":"H17*$E39/100*$E$32","v":85460.4},null,0,null,0]
[null,null,"Transportation Charge From Dawn",null,{"$f":"$E$37","v":50000},{"$f":"F18*$E40/100*$E$32","v":109799.40000000001},null,{"$f":"H18*$E40/100*$E$32","v":109799.40000000001},null,0,null,0]
[null,null,"Transportation Charge \nFrom Kirkwall",null,0,{"$f":"F19*$E41/100*$E$32","v":0},null,{"$f":"H19*$E41/100*$E$32","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Transportation Charge From Parkway",null,0,{"$f":"F20*$E42/100*$E$32","v":0},null,{"$f":"H20*$E42/100*$E$32","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Federal Carbon Charge",null,{"$f":"$E$37","v":50000},{"$f":"$E43*F21/100*$E$32","v":91500},null,{"$f":"$E43*H21/100*$E$32","v":91500},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F32:F43)","v":980174.38111200021},null,{"$f":"SUM(H32:H43)","v":994053.66585605417},null,{"$f":"SUM(J32:J43)","v":13879.284744053955},null,1.4160015821172571E-2]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,{"$f":"C24","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"E32","v":12},{"$f":"$E$47*$E37*$F24/100","v":360.6},null,{"$f":"$E$47*$E37*$H24/100","v":360.6},null,{"$f":"H47-F47","v":0},null,{"$f":"J47/F47","v":0}]
[null,null,{"$f":"C25","v":"ECVA Rate Rider"},null,{"$f":"E47","v":12},{"$f":"$E$47*$E38*$F25/100","v":0},null,{"$f":"$E$47*$E38*$H25/100","v":0},null,{"$f":"H48-F48","v":0},null,{"$f":"J48/F48","v":{"$error":"#DIV/0!"}}]
[null,null,"CIACVA Rate Rider",null,{"$f":"E48","v":12},28632.85022241285,null,28255.200000000001,null,-377.65022241284896,null,-1.3189403761042162E-2]
[null,null,"MTVA Rate Rider",null,{"$f":"E47","v":12},-33827.717988597469,null,7438.079999999999,null,41265.797988597471,null,-1.2198812229221967]
[null,null,"ORDA Rate Rider",null,{"$f":"E48","v":12},{"$f":"$E$47*$E40*$F28/100","v":-303.51565536539709},null,{"$f":"$E$47*$E40*$H28/100","v":-928.2},null,-624.68434463460289,null,2.0581618562065818]
[null,null,"CVVA Rate Rider",null,{"$f":"E51","v":12},0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F47:F52)","v":-5137.7834215500179},{"$f":"SUM(G47:G52)","v":0},35125.68,0,40263.463421550019,null,{"$f":"J53/F53","v":-7.836738164685606}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F44+F53","v":975036.59769045014},null,{"$f":"H44+H53","v":1029179.3458560542},null,{"$f":"J44+J53","v":54142.748165603974},null,{"$f":"J55/F55","v":5.5528939420172362E-2}]

{"sheet":"G1.7 Summary of Bill Impacts","index":18,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2024-0238  Exhibit A - 2025 Custom Incentive Application"}]
[]
[null,null,"Summary of Bill Impacts"]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.7 Summary of Bill Impacts"}]
[null,null,"Rate Class",null,"Fixed Charge",{"$f":"E8","v":"Fixed Charge"},{"$f":"OneDollar","v":"Bill 32 Rate"},"Volumetric Charge",{"$f":"H8","v":"Volumetric Charge"},"Rate Riders",{"$f":"J8","v":"Rate Riders"},"Upstream Recovery \nCharge","Transportation & \nStorage Charge","Federal Carbon Charge Change","Total",{"$f":"O8","v":"Total"},null,null,"Check"]
[null,null,null,null,"($/year)","(%)","($/year)","($/year)","(%)","($/year)","(%)","($/year)","($/year)","($/year)","($/year)","(%)"]
[null,null,"Rate 1","Existing Residential",{"$f":"'G1.1 Rate 1 Bill Impact'!J32","v":6.592874626363141},{"$f":"'G1.1 Rate 1 Bill Impact'!L32","v":2.0016199999999821E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J33","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J34:J37)","v":12.514805694034749},{"$f":"F10","v":2.0016199999999821E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J51","v":121.66065069374365},{"$f":"'G1.1 Rate 1 Bill Impact'!L51","v":3.2191977371262763},{"$f":"'G1.1 Rate 1 Bill Impact'!J39","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J40","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J41","v":0},{"$f":"E10+H10+J10","v":140.76833101414155},{"$f":"'G1.1 Rate 1 Bill Impact'!L53","v":8.2764519398384848E-2},null,null,{"$f":"'G1.1 Rate 1 Bill Impact'!J53-O10","v":0}]
[null,null,"Rate 1","New Residential",{"$f":"'G1.1 Rate 1 Bill Impact'!J78","v":6.592874626363141},{"$f":"'G1.1 Rate 1 Bill Impact'!L78","v":2.0016199999999821E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J79","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J80:J81)","v":12.034986047031964},{"$f":"F11","v":2.0016199999999821E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J97","v":119.45063952223097},{"$f":"'G1.1 Rate 1 Bill Impact'!L97","v":3.2876993545230619},{"$f":"'G1.1 Rate 1 Bill Impact'!J85","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J86","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J87","v":0},{"$f":"E11+H11+J11","v":138.07850019562608},{"$f":"'G1.1 Rate 1 Bill Impact'!L99","v":8.3760063298618515E-2},null,null,{"$f":"'G1.1 Rate 1 Bill Impact'!J99-O11","v":0}]
[null,null,"Rate 1","Small Commercial",{"$f":"'G1.1 Rate 1 Bill Impact'!J123","v":6.592874626363141},{"$f":"'G1.1 Rate 1 Bill Impact'!L123","v":2.0016199999999821E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J124","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J125:J128)","v":27.041503455192071},2.0016199999999821E-2,{"$f":"'G1.1 Rate 1 Bill Impact'!J142","v":189.39882443263798},{"$f":"'G1.1 Rate 1 Bill Impact'!L142","v":2.2948835833051588},{"$f":"'G1.1 Rate 1 Bill Impact'!J130","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J131","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J132","v":0},223.03320251419319,{"$f":"'G1.1 Rate 1 Bill Impact'!L144","v":6.7672989308370832E-2},null,null,{"$f":"'G1.1 Rate 1 Bill Impact'!J144-O12","v":0}]
[null,null,"Rate 1","Small Agricultural",{"$f":"'G1.1 Rate 1 Bill Impact'!J168","v":6.592874626363141},{"$f":"'G1.1 Rate 1 Bill Impact'!L168","v":2.0016199999999821E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J169","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J170:J173)","v":27.194385296975724},2.0016199999999821E-2,{"$f":"'G1.1 Rate 1 Bill Impact'!J187","v":190.1177437293951},{"$f":"'G1.1 Rate 1 Bill Impact'!L187","v":2.290417151809053},{"$f":"'G1.1 Rate 1 Bill Impact'!J175","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J176","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J177","v":0},223.90500365273397,{"$f":"'G1.1 Rate 1 Bill Impact'!L189","v":6.7591681106364002E-2},null,null,{"$f":"'G1.1 Rate 1 Bill Impact'!J189-O13","v":0}]
[null,null,"Rate 6","Medium Commercial",{"$f":"'G1.2 Rate 6 Bill Impact'!J30","v":26.885452551297476},{"$f":"'G1.2 Rate 6 Bill Impact'!L30","v":2.0016199999999904E-2},{"$f":"'G1.2 Rate 6 Bill Impact'!J31","v":0},{"$f":"SUM('G1.2 Rate 6 Bill Impact'!J32:J35)","v":136.94755208444531},2.0016199999999904E-2,{"$f":"'G1.2 Rate 6 Bill Impact'!J49","v":746.51108108247035},{"$f":"'G1.2 Rate 6 Bill Impact'!L49","v":16.766323799541009},{"$f":"'G1.2 Rate 6 Bill Impact'!J37","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J38","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J39","v":0},910.34408571821314,{"$f":"'G1.2 Rate 6 Bill Impact'!L51","v":5.0151619082884374E-2},null,null,{"$f":"'G1.2 Rate 6 Bill Impact'!J51-O14","v":0}]
[null,null,"Rate 6","Large Commercial",{"$f":"'G1.2 Rate 6 Bill Impact'!J76","v":26.885452551297476},{"$f":"'G1.2 Rate 6 Bill Impact'!L76","v":2.0016199999999904E-2},{"$f":"'G1.2 Rate 6 Bill Impact'!J77","v":0},{"$f":"SUM('G1.2 Rate 6 Bill Impact'!J78:J81)","v":370.53601639085218},2.0016199999999904E-2,{"$f":"'G1.2 Rate 6 Bill Impact'!J95","v":3041.8012925306034},{"$f":"'G1.2 Rate 6 Bill Impact'!L95","v":24.311253196811862},{"$f":"'G1.2 Rate 6 Bill Impact'!J83","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J84","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J85","v":0},3439.2227614727531,{"$f":"'G1.2 Rate 6 Bill Impact'!L97","v":7.1888247187694126E-2},null,null,{"$f":"'G1.2 Rate 6 Bill Impact'!J97-O15","v":0}]
[null,null,"Rate 11","Sample Dryer 1",{"$f":"'G1.3 Rate 11 Bill Impact'!J30","v":53.770905102594952},{"$f":"'G1.3 Rate 11 Bill Impact'!L30","v":2.0016199999999904E-2},{"$f":"'G1.3 Rate 11 Bill Impact'!J31","v":0},{"$f":"SUM('G1.3 Rate 11 Bill Impact'!J32:J35)","v":342.320083327053},2.0016199999999904E-2,{"$f":"'G1.3 Rate 11 Bill Impact'!J49","v":909.65453894545442},{"$f":"'G1.3 Rate 11 Bill Impact'!L49","v":1.8011707720245334},{"$f":"'G1.3 Rate 11 Bill Impact'!J37","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J38","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J39","v":0},1305.7455273751025,{"$f":"'G1.3 Rate 11 Bill Impact'!L51","v":2.5681761880526694E-2},null,null,{"$f":"'G1.3 Rate 11 Bill Impact'!J51-O16","v":0}]
[null,null,"Rate 11","Sample Dryer 2",{"$f":"'G1.3 Rate 11 Bill Impact'!J75","v":53.770905102594952},{"$f":"'G1.3 Rate 11 Bill Impact'!L75","v":2.0016199999999904E-2},{"$f":"'G1.3 Rate 11 Bill Impact'!J76","v":0},{"$f":"SUM('G1.3 Rate 11 Bill Impact'!J77:J80)","v":1141.0669444235027},2.0016199999999904E-2,{"$f":"'G1.3 Rate 11 Bill Impact'!J94","v":3032.1817964848474},{"$f":"'G1.3 Rate 11 Bill Impact'!L94","v":1.8011707720245331},{"$f":"'G1.3 Rate 11 Bill Impact'!J82","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J83","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J84","v":0},4227.0196460109455,{"$f":"'G1.3 Rate 11 Bill Impact'!L96","v":2.7536656621625622E-2},null,null,{"$f":"'G1.3 Rate 11 Bill Impact'!J96-O17","v":0}]
[null,null,"Rate 16","Contracted Demand",{"$f":"'G1.4 Rate 16 Bill Impact'!J32","v":395.36837142961303},{"$f":"'G1.4 Rate 16 Bill Impact'!L32","v":2.0016199999999932E-2},{"$f":"'G1.4 Rate 16 Bill Impact'!J33","v":0},{"$f":"SUM('G1.4 Rate 16 Bill Impact'!J34:J37)","v":13483.916372624342},2.0016199999999932E-2,{"$f":"'G1.4 Rate 16 Bill Impact'!J53","v":40263.463421550019},{"$f":"'G1.4 Rate 16 Bill Impact'!L53","v":-7.836738164685606},{"$f":"'G1.4 Rate 16 Bill Impact'!J39","v":0},{"$f":"SUM('G1.4 Rate 16 Bill Impact'!J40:J42)","v":0},{"$f":"'G1.4 Rate 16 Bill Impact'!J43","v":0},54142.748165603974,{"$f":"'G1.4 Rate 16 Bill Impact'!L55","v":5.5528939420172362E-2},null,null,{"$f":"'G1.4 Rate 16 Bill Impact'!J55-O18","v":0}]

{"sheet":"Staff-2","index":19,"n_rows":151,"n_cols":22,"rows_kept":151,"cut":false,"hidden":false,"merged":[[2,18,2,21],[2,16,2,17]]}
[]
[{"$f":"'A1.1 Distributor Information'!C3","v":"EPCOR Natural Gas Limited Partnership"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E","F","G"]
["OEB Staff-2 Bill Impacts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage","CVVA",null,"Total Bill"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3","Fixed ","Variable","Fixed","Variable","Variance $","Variance %"]
["Rate 1 Delivery Bill Impact"]
["G1.1 Rate 1 Bill Impact"]
[]
["Rate 1"]
[]
["Rate 1 Residential - Average Usage",null,"Units","Fixed CVVA","Variable CVVA","Variance $","Variance %",null,null,null,null,null,null,1,"Average User",{"$f":"C35+C36","v":2149},{"$f":"D51","v":64.44},{"$f":"E52","v":92.400525374306213},{"$f":"D55","v":1841.5977690074544},{"$f":"E55","v":1869.5582943817606},{"$f":"R10-Q10","v":27.960525374306215},{"$f":"G55","v":1.5182753717917306E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Bottom 10 %",{"$f":"C83+C84","v":264},{"$f":"D99","v":64.44},{"$f":"E100","v":11.351204606243293},{"$f":"D103","v":588.81551629759076},{"$f":"E103","v":535.72672090383412},{"$f":"R11-Q11","v":-53.088795393756705},-9.0162018364552163E-2]
["Customer",null,"$/month",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A12))","v":27.997484218863598},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B12))","v":27.997484218863598},null,null,null,null,null,null,null,null,3,"Top 10 %",{"$f":"C131+C132","v":3100},{"$f":"D147","v":64.44},{"$f":"E148","v":133.290660149069},{"$f":"D151","v":2472.6140912488554},{"$f":"E151","v":2541.4647513979244},68.850660149069,2.7845291504544581E-2]
[{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A13))","v":1},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B13))","v":1}]
["First 100 m3",null,"₵/m3",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A14))","v":29.992083057283196},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B14))","v":29.992083057283196}]
["Next 400 m3",null,"₵/m3",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A15))","v":29.401222312373353},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B15))","v":29.401222312373353}]
["GT 500m3",null,"₵/m3",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A16))","v":28.532788598221657},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B16))","v":28.532788598221657}]
["Contracted Demand",null,"₵ / contracted m3",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A17))","v":0},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B17))","v":0}]
["Gas Supply",null,"₵/m3",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A18))","v":12.9848},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B18))","v":12.9848}]
["Upstream Recovery \nCharge",null,"$/m3",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A19))","v":1.474},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B19))","v":1.474}]
["Transportation & \nStorage Charge",null,"₵/m3",{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:A20))","v":2.6981999999999999},{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,MATCH($A$8,'E1.1 Proposed Dist Rates '!$C$10:$C$13,0),COUNTA($A$12:B20))","v":2.6981999999999999}]
["Federal Carbon Charge",null,"₵/m3",{"$f":"'E1.1 Proposed Dist Rates '!$Q$10","v":15.25},{"$f":"'E1.1 Proposed Dist Rates '!$Q$10","v":15.25}]
[]
["Rate Riders"]
["Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"'F1.3 Proposed Rate Riders'!$E$9","v":1.633},{"$f":"'F1.3 Proposed Rate Riders'!$E$9","v":1.633}]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"'F1.3 Proposed Rate Riders'!$E$18","v":0.24809999999999999},{"$f":"'F1.3 Proposed Rate Riders'!$E$18","v":0.24809999999999999}]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"'F1.3 Proposed Rate Riders'!$E$27","v":2.3088000000000002},{"$f":"'F1.3 Proposed Rate Riders'!$E$27","v":2.3088000000000002}]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"'F1.3 Proposed Rate Riders'!$E$36","v":0.50516000000000005},{"$f":"'F1.3 Proposed Rate Riders'!$E$36","v":0.50516000000000005}]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$43","v":"ORDA Rate Rider"},null,"₵/m3",{"$f":"'F1.3 Proposed Rate Riders'!$E$45","v":-0.27379999999999999},{"$f":"'F1.3 Proposed Rate Riders'!$E$45","v":-0.27379999999999999}]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$52","v":"CVVA Rate Rider"},null,"$/month",{"$f":"'F1.3 Proposed Rate Riders'!$E$54","v":5.37}]
["CVVA Rate Rider - Variable",null,null,null,{"$f":"'Staff-2 CVVA Calculation'!D13","v":4.2996987144860963}]
[]
["Delivery",null,"Metric"]
["Customer",null,12,{"$f":"D12*$C33","v":335.96981062636314},{"$f":"E12*$C33","v":335.96981062636314}]
[{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"D13*$C34","v":12},{"$f":"E13*$C34","v":12}]
["First 100 m3",null,1001.3160527512506,{"$f":"D14*$C35/100","v":300.31554220706471},300.31554220706471]
["Next 400 m3",null,1147.6839472487493,337.43310877402649,337.43310877402649]
["GT 500m3",null,0,0,0]
["Contracted Demand",null,0,0,0]
["Gas Supply",null,{"$f":"SUM(C35:C38)","v":2149},279.04335200000003,279.04335200000003]
["Upstream Recovery \nCharge",null,{"$f":"C39","v":2149},31.676259999999999,31.676259999999999]
["Transportation & \nStorage Charge",null,{"$f":"C40","v":2149},57.984318000000002,57.984318000000002]
["Federal Carbon Charge",null,{"$f":"C39","v":2149},327.72250000000003,327.72250000000003]
["Total Delivery",null,null,{"$f":"SUM(D33:D42)","v":1682.1448916074544},{"$f":"SUM(E33:E42)","v":1682.1448916074544}]
[]
["Rate Riders",null,"Metric",null,null,"Variance $","Variance %"]
[{"$f":"A24","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"C39","v":2149},{"$f":"$C46*D24/100","v":35.093170000000001},35.093170000000001]
["ECVA Rate Rider",null,{"$f":"C46","v":2149},5.3316689999999998,5.3316689999999998]
["CIACVA Rate Rider",null,{"$f":"C46","v":2149},49.616112000000001,49.616112000000001]
["MTVA Rate Rider",null,{"$f":"C47","v":2149},10.855888400000001,10.855888400000001]
["ORDA Rate Rider",null,{"$f":"C48","v":2149},-5.8839620000000004,-5.8839620000000004]
["CVVA Rate Rider",null,12,{"$f":"$C51*D29","v":64.44},{"$f":"$C51*E29","v":0},{"$f":"E51-D51","v":-64.44}]
["CVVA Rate Rider - Variable",null,{"$f":"C50","v":2149},{"$f":"$C52*D30","v":0},{"$f":"$C52*E30/100","v":92.400525374306213},92.400525374306213]
["Total Rate Riders",null,null,{"$f":"SUM(D46:D52)","v":159.45287740000001},{"$f":"SUM(E46:E52)","v":187.41340277430623},27.960525374306229,{"$f":"F53/D53","v":0.17535290569993958}]
[]
["Total Bill Impact",null,null,{"$f":"D43+D53","v":1841.5977690074544},{"$f":"E43+E53","v":1869.5582943817606},27.960525374306144,{"$f":"F55/D55","v":1.5182753717917306E-2}]
[]
[]
["Rate 1 Residential - Bottom 10 Percentile",null,"Units","Fixed CVVA","Variable CVVA","Variance $","Variance %"]
[]
["Customer",null,"$/month",{"$f":"D12","v":27.997484218863598},{"$f":"E12","v":27.997484218863598}]
[{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",{"$f":"D13","v":1},{"$f":"E13","v":1}]
["First 100 m3",null,"₵/m3",29.992083057283196,{"$f":"E14","v":29.992083057283196}]
["Next 400 m3",null,"₵/m3",29.401222312373353,{"$f":"E15","v":29.401222312373353}]
["GT 500m3",null,"₵/m3",28.532788598221657,{"$f":"E16","v":28.532788598221657}]
["Contracted Demand",null,"₵ / contracted m3",0,{"$f":"E17","v":0}]
["Gas Supply",null,"₵/m3",12.9848,{"$f":"E18","v":12.9848}]
["Upstream Recovery \nCharge",null,"$/m3",1.474,{"$f":"E19","v":1.474}]
["Transportation & \nStorage Charge",null,"₵/m3",2.6981999999999999,{"$f":"E20","v":2.6981999999999999}]
["Federal Carbon Charge",null,"₵/m3",15.25,{"$f":"E21","v":15.25}]
[]
["Rate Riders"]
["Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"D24","v":1.633},1.633]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"D25","v":0.24809999999999999},0.24809999999999999]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"D26","v":2.3088000000000002},2.3088000000000002]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"D27","v":0.50516000000000005},0.50516000000000005]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$43","v":"ORDA Rate Rider"},null,"₵/m3",{"$f":"D28","v":-0.27379999999999999},-0.27379999999999999]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$52","v":"CVVA Rate Rider"},null,"$/month",{"$f":"D29","v":5.37},0]
["CVVA Rate Rider - Variable",null,null,{"$f":"D30","v":0},4.2996987144860963]
[]
["Delivery",null,"Metric"]
["Customer",null,12,{"$f":"D60*$C81","v":335.96981062636314},{"$f":"E60*$C81","v":335.96981062636314}]
[{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"D61*$C82","v":12},{"$f":"E61*$C82","v":12}]
["First 100 m3",null,264,{"$f":"D62*$C83/100","v":79.179099271227642},79.179099271227642]
["Next 400 m3",null,0,0,0]
["GT 500m3",null,0,0,0]
["Contracted Demand",null,0,0,0]
["Gas Supply",null,{"$f":"SUM(C83:C86)","v":264},34.279871999999997,34.279871999999997]
["Upstream Recovery \nCharge",null,{"$f":"C87","v":264},3.8913599999999997,3.8913599999999997]
["Transportation & \nStorage Charge",null,{"$f":"C88","v":264},7.1232480000000002,7.1232480000000002]
["Federal Carbon Charge",null,{"$f":"C87","v":264},40.26,40.26]
["Total Delivery",null,null,{"$f":"SUM(D81:D90)","v":512.7033898975908},{"$f":"SUM(E81:E90)","v":512.7033898975908}]
[]
["Rate Riders",null,"Metric",null,null,"Variance $","Variance %"]
[{"$f":"A72","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"C87","v":264},{"$f":"$C94*D72/100","v":4.3111199999999998},4.3111199999999998]
["ECVA Rate Rider",null,{"$f":"C94","v":264},0.65498400000000001,0.65498400000000001]
["CIACVA Rate Rider",null,{"$f":"C94","v":264},6.0952320000000011,6.0952320000000011]
["MTVA Rate Rider",null,{"$f":"C95","v":264},1.3336224000000001,1.3336224000000001]
["ORDA Rate Rider",null,{"$f":"C96","v":264},-0.72283199999999992,-0.72283199999999992]
["CVVA Rate Rider",null,12,{"$f":"$C99*D77","v":64.44},{"$f":"$C99*E77","v":0},{"$f":"E99-D99","v":-64.44}]
["CVVA Rate Rider - Variable",null,{"$f":"C98","v":264},{"$f":"$C100*D78","v":0},{"$f":"$C100*E78/100","v":11.351204606243293},11.351204606243293]
["Total Rate Riders",null,null,{"$f":"SUM(D94:D100)","v":76.112126399999994},{"$f":"SUM(E94:E100)","v":23.023331006243293},-53.088795393756698,{"$f":"F101/D101","v":-0.69750771532454126}]
[]
["Total Bill Impact",null,null,{"$f":"D91+D101","v":588.81551629759076},{"$f":"E91+E101","v":535.72672090383412},{"$f":"E103-D103","v":-53.088795393756641},{"$f":"F103/D103","v":-9.0162018364552163E-2}]
[]
[]
["Rate 1 Residential - Top 10 Percentile",null,"Units","Fixed CVVA","Variable CVVA","Variance $","Variance %"]
[]
["Customer",null,"$/month",{"$f":"D60","v":27.997484218863598},{"$f":"E60","v":27.997484218863598}]
[{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",{"$f":"D61","v":1},1]
["First 100 m3",null,"₵/m3",29.992083057283196,29.992083057283196]
["Next 400 m3",null,"₵/m3",29.401222312373353,29.401222312373353]
["GT 500m3",null,"₵/m3",28.532788598221657,28.532788598221657]
["Contracted Demand",null,"₵ / contracted m3",0,0]
["Gas Supply",null,"₵/m3",12.9848,12.9848]
["Upstream Recovery \nCharge",null,"$/m3",1.474,1.474]
["Transportation & \nStorage Charge",null,"₵/m3",2.6981999999999999,2.6981999999999999]
["Federal Carbon Charge",null,"₵/m3",15.25,15.25]
[]
["Rate Riders"]
["Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"D72","v":1.633},1.633]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",0.24809999999999999,0.24809999999999999]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",2.3088000000000002,2.3088000000000002]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",0.50516000000000005,0.50516000000000005]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$43","v":"ORDA Rate Rider"},null,"₵/m3",-0.27379999999999999,-0.27379999999999999]
[{"$f":"'F1.3 Proposed Rate Riders'!$E$52","v":"CVVA Rate Rider"},null,"$/month",5.37,0]
["CVVA Rate Rider - Variable",null,null,0,4.2996987144860963]
[]
["Delivery",null,"Metric"]
["Customer",null,12,{"$f":"D108*$C129","v":335.96981062636314},{"$f":"E108*$C129","v":335.96981062636314}]
[{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"D109*$C130","v":12},{"$f":"E109*$C130","v":12}]
["First 100 m3",null,1200,{"$f":"D110*$C131/100","v":359.90499668739835},359.90499668739835]
["Next 400 m3",null,{"$f":"3100-C131","v":1900},{"$f":"D111*$C132/100","v":558.62322393509373},558.62322393509373]
["GT 500m3",null,0,{"$f":"D112*$C133/100","v":0},0]
["Contracted Demand",null,0,{"$f":"D113*$C134/100","v":0},0]
["Gas Supply",null,{"$f":"SUM(C131:C134)","v":3100},{"$f":"D114*$C135/100","v":402.52879999999999},402.52879999999999]
["Upstream Recovery \nCharge",null,{"$f":"C135","v":3100},{"$f":"D115*$C136/100","v":45.693999999999996},45.693999999999996]
["Transportation & \nStorage Charge",null,{"$f":"C136","v":3100},{"$f":"D116*$C137/100","v":83.644199999999998},83.644199999999998]
["Federal Carbon Charge",null,{"$f":"C135","v":3100},{"$f":"D117*$C138/100","v":472.75},472.75]
["Total Delivery",null,null,{"$f":"SUM(D129:D138)","v":2271.1150312488553},{"$f":"SUM(E129:E138)","v":2271.1150312488553}]
[]
["Rate Riders",null,"Metric"]
[{"$f":"A120","v":"Delay in Revenue Recovery Rate Rider"},null,{"$f":"C135","v":3100},{"$f":"$C142*D120/100","v":50.623000000000005},50.623000000000005,{"$f":"E142-D142","v":0}]
["ECVA Rate Rider",null,{"$f":"C142","v":3100},{"$f":"$C143*D121/100","v":7.6911000000000005},7.6911000000000005,0]
["CIACVA Rate Rider",null,{"$f":"C142","v":3100},{"$f":"$C144*D122/100","v":71.572800000000001},71.572800000000001,0]
["MTVA Rate Rider",null,{"$f":"C143","v":3100},{"$f":"$C145*D123/100","v":15.659960000000002},15.659960000000002,0]
["ORDA Rate Rider",null,{"$f":"C144","v":3100},{"$f":"$C146*D124/100","v":-8.4878},-8.4878,0]
["CVVA Rate Rider",null,12,{"$f":"$C147*D125","v":64.44},{"$f":"$C147*E125","v":0},-64.44]
["CVVA Rate Rider - Variable",null,{"$f":"C146","v":3100},{"$f":"$C148*D126","v":0},{"$f":"$C148*E126/100","v":133.290660149069},133.290660149069]
["Total Rate Riders",null,null,{"$f":"SUM(D142:D148)","v":201.49906000000001},{"$f":"SUM(E142:E148)","v":270.34972014906901},68.850660149069,{"$f":"F149/D149","v":0.34169221508561376}]
[]
["Total Bill Impact",null,null,{"$f":"D139+D149","v":2472.6140912488554},{"$f":"E139+E149","v":2541.4647513979244},{"$f":"E151-D151","v":68.850660149068972},{"$f":"F151/D151","v":2.7845291504544581E-2}]

{"sheet":"Staff-2 CVVA Calculation","index":20,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["CVVA Fixed Rate Rider"]
[null,null,"A","B"]
[null,null,"Unit","Rate 1"]
[1,"Customer Count","#",{"$f":"'B1.2 Billing Determinants'!E9","v":5516}]
[2,"Sum","$",355611.74182002997]
[3,"Rate Rider","$/month",{"$f":"D5/D4/12","v":5.3724278133313694}]
[]
["CVVA Variable Rate Rider"]
[null,null,"A","B"]
[null,null,"Unit","Rate 1"]
[1,"Consumption","m3",{"$f":"'B1.2 Billing Determinants'!F9+'B1.2 Billing Determinants'!G9+'B1.2 Billing Determinants'!H9","v":8270620}]
[2,"Sum","$",355611.74182002997]
[3,"Rate Rider","¢/m3",{"$f":"D12/D11*100","v":4.2996987144860963}]