{"text_format":"1","workbook":"xlsx","n_sheets":18,"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","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 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"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":" \"Name of LDC:       \" &D8","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":" \"OEB Application Number:  \" & D9","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 Custom Incentive Application"}]
[]
[null,null,"Distributor Information"]
[]
[null,null,"Distributor Name","EPCOR Natural Gas Limited Partnership"]
[null,null,"OEB Application Number","EB-2022-0184  Exhibit A - 2023 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":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,6,6,8]]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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"]
[null,null,null,null," $/month","$ / month","₵ / m3","₵ / m3","₵ / m3","₵ /contracted m3","₵  / m3","(A)","₵  / m3","₵ /contracted m3","₵ /contracted m3","₵ /contracted m3","₵ / m3"]
[null,null,"Rate 1","General Firm Service",26.272397999999999,1,28.148561099999995,27.594068789999994,26.77899261,null,30.690200000000001,1.474,2.6981999999999999,null,null,null,9.7899999999999991]
[null,null,"Rate 6","Large Volume General Firm Service",107.15836499999999,1,25.967789009999997,23.371020299999998,22.202316419999999,null,{"$f":"K10","v":30.690200000000001},2.92,5.6413000000000002,null,null,null,9.7899999999999991]
[null,null,"Rate 11","Large Volume Seasonal Service",214.30653899999996,1,16.130314799999997,16.130314799999997,16.130314799999997,null,{"$f":"K10","v":30.690200000000001},3.5200000000000002E-2,1.8166,null,null,null,9.7899999999999991]
[null,null,"Rate 16","Contracted Firm Service",1575.7833749999998,1,null,null,null,107.48305025999998,null,14.243399999999999,null,18.299900000000001,11.848000000000001,11.848000000000001,9.7899999999999991]
[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":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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",4887,3391849,1847677,263269,null,5502795]
[null,null,"Rate 6","Large Volume General Firm Service",35,287896,903329,890107,null,2081331]
[null,null,"Rate 11","Large Volume Seasonal Service",7,null,null,1313149,null,1313149]
[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":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 Custom Incentive Application"}]
[]
[]
[null,null,"Forecasted Revenue from Current Rates"]
[]
[null,null,"Months / Year",12]
[]
[]
[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":1540718.508312},{"$f":"'B1.1 Current Distribution Rates'!F10*'B1.2 Billing Determinants'!E9*$D$8","v":58644},{"$f":"'B1.2 Billing Determinants'!F9*'B1.1 Current Distribution Rates'!G10/100","v":954756.68818473874},{"$f":"'B1.2 Billing Determinants'!G9*'B1.1 Current Distribution Rates'!H10/100","v":509849.26239700819},{"$f":"'B1.2 Billing Determinants'!H9*'B1.1 Current Distribution Rates'!I10/100","v":70500.786054420896},{"$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":1688818.79109},{"$f":"'B1.1 Current Distribution Rates'!L10*'B1.2 Billing Determinants'!$J9/100","v":81111.198300000004},{"$f":"'B1.1 Current Distribution Rates'!M10*'B1.2 Billing Determinants'!$J9/100","v":148476.41469000001},{"$f":"'B1.1 Current Distribution Rates'!Q10*'B1.2 Billing Determinants'!J9/100","v":538723.63049999997},{"$f":"SUM(E14:N14)","v":5591599.279528168}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'B1.2 Billing Determinants'!E10*'B1.1 Current Distribution Rates'!E11*$D$8","v":45006.513299999991},{"$f":"'B1.1 Current Distribution Rates'!F11*'B1.2 Billing Determinants'!E10*$D$8","v":420},{"$f":"'B1.2 Billing Determinants'!F10*'B1.1 Current Distribution Rates'!G11/100","v":74760.225848229587},{"$f":"'B1.2 Billing Determinants'!G10*'B1.1 Current Distribution Rates'!H11/100","v":211117.20396578699},{"$f":"'B1.2 Billing Determinants'!H10*'B1.1 Current Distribution Rates'!I11/100","v":197624.3726165694},{"$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":638764.64656200004},{"$f":"'B1.1 Current Distribution Rates'!L11*'B1.2 Billing Determinants'!$J10/100","v":60774.865199999993},{"$f":"'B1.1 Current Distribution Rates'!M11*'B1.2 Billing Determinants'!$J10/100","v":117414.125703},{"$f":"'B1.1 Current Distribution Rates'!Q11*'B1.2 Billing Determinants'!J10/100","v":203762.30489999999},{"$f":"SUM(E15:N15)","v":1549644.2580955857}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'B1.2 Billing Determinants'!E11*'B1.1 Current Distribution Rates'!E12*$D$8","v":18001.749275999995},{"$f":"'B1.1 Current Distribution Rates'!F12*'B1.2 Billing Determinants'!E11*$D$8","v":84},{"$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":211815.06749305196},{"$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":403008.05439800001},{"$f":"'B1.1 Current Distribution Rates'!L12*'B1.2 Billing Determinants'!$J11/100","v":462.22844800000007},{"$f":"'B1.1 Current Distribution Rates'!M12*'B1.2 Billing Determinants'!$J11/100","v":23854.664734000002},{"$f":"'B1.1 Current Distribution Rates'!Q12*'B1.2 Billing Determinants'!J11/100","v":128557.28709999999},{"$f":"SUM(E16:N16)","v":785783.05144905194}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'B1.2 Billing Determinants'!E12*'B1.1 Current Distribution Rates'!E13*$D$8","v":56728.201499999988},{"$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":1235934.6969737087},{"$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":112574.03519999998},{"$f":"SUM(E17:N17)","v":1779484.4351777087}]
[null,null,"Total Revenue",null,{"$f":"SUM(E14:E17)","v":1660454.972388},59184,1029516.9140329683,720966.46636279521,479940.22616404225,1235934.6969737087,2730591.4920500005,306131.43933999998,500173.55923900002,983617.25769999996,9706511.0242505148]
[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":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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.14030000000000001,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.14030000000000001,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.14030000000000001,"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,0.54339999999999999,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.71350000000000002,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,9.9199999999999997E-2,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,0.96030000000000004,"Cents/contracted demand m3"]
[]
[]
[null,null,"External Funding Variance Account (EFVA)"]
[null,null,null,null,"EFVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,0.51970000000000005,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.66080000000000005,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.1075,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,0.7964,"Cents/contracted demand m3"]

{"sheet":"D1.1 Rate 1 Adjustment","index":5,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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,2.0299999999999999E-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":26.272397999999999},{"$f":"$E$13","v":2.0299999999999999E-2},{"$f":"E17*(1+F17)","v":26.8057276794},{"$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":4887},{"$f":"G17*H17*$E$14","v":1571995.0940307337}]
[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":4887},{"$f":"G18*H18*$E$14","v":58644}]
[null,null,"Tier 1","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!G10","v":28.148561099999995},{"$f":"$E$13","v":2.0299999999999999E-2},{"$f":"E19*(1+F19)","v":28.719976890329995},{"$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":3391849},{"$f":"G19*H19/100","v":974138.24895488902}]
[null,null,"Tier 2","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!H10","v":27.594068789999994},{"$f":"$E$13","v":2.0299999999999999E-2},28.154228386436994,{"$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":1847677},{"$f":"G20*H20/100","v":520199.20242366748}]
[null,null,"Tier 3","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!I10","v":26.77899261},{"$f":"$E$13","v":2.0299999999999999E-2},27.322606159983,{"$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":263269},71931.952011325644]
[null,null,"Contract Demand","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!J10","v":0},{"$f":"$E$13","v":2.0299999999999999E-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":30.690200000000001},0,30.690200000000001,{"$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":5502795},1688818.79109]
[null,null,"Upstream Recovery \nCharge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!L10","v":1.474},0,1.474,{"$f":"H23","v":5502795},81111.198300000004]
[null,null,"Transportation & \nStorage Charge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!M10","v":2.6981999999999999},0,2.6981999999999999,{"$f":"H24","v":5502795},148476.41469000001]
[null,null,"Federal Carbon Charge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!Q10","v":9.7899999999999991},0,9.7899999999999991,{"$f":"H25","v":5502795},{"$f":"G26*H26/100","v":538723.63049999997}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":5654038.5320006162}]

{"sheet":"D1.2 Rate 6 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":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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.0299999999999999E-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":107.15836499999999},{"$f":"$E$13","v":2.0299999999999999E-2},{"$f":"E17*(1+F17)","v":109.33367980949998},{"$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":35},{"$f":"G17*H17*12","v":45920.145519989994}]
[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":35},{"$f":"G18*H18*12","v":420}]
[null,null,"Tier 1","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!G11","v":25.967789009999997},{"$f":"$E$13","v":2.0299999999999999E-2},{"$f":"E19*(1+F19)","v":26.494935126902998},{"$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":287896},{"$f":"G19*H19/100","v":76277.858432948648}]
[null,null,"Tier 2","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!H11","v":23.371020299999998},{"$f":"$E$13","v":2.0299999999999999E-2},23.845452012089996,{"$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":903329},{"$f":"G20*H20/100","v":215402.88320629243}]
[null,null,"Tier 3","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!I11","v":22.202316419999999},{"$f":"$E$13","v":2.0299999999999999E-2},22.653023443325999,{"$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":890107},201636.14738068578]
[null,null,"Contract Demand","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!J11","v":0},{"$f":"$E$13","v":2.0299999999999999E-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":30.690200000000001},0,30.690200000000001,{"$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":2081331},638764.64656200004]
[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":2081331},60774.865199999993]
[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":2081331},117414.125703]
[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":9.7899999999999991},0,9.7899999999999991,{"$f":"H25","v":2081331},203762.30489999999]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":1560372.9769049166}]

{"sheet":"D1.3 Rate 11 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":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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.0299999999999999E-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":214.30653899999996},{"$f":"$E$13","v":2.0299999999999999E-2},{"$f":"E17*(1+F17)","v":218.65696174169994},{"$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":7},{"$f":"G17*H17*12","v":18367.184786302794}]
[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":7},{"$f":"G18*H18*12","v":84}]
[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.130314799999997},{"$f":"$E$13","v":2.0299999999999999E-2},16.457760190439998,{"$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.130314799999997},{"$f":"$E$13","v":2.0299999999999999E-2},16.457760190439998,{"$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.130314799999997},{"$f":"$E$13","v":2.0299999999999999E-2},16.457760190439998,{"$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":1313149},216114.91336316094]
[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.0299999999999999E-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":30.690200000000001},0,30.690200000000001,{"$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":1313149},403008.05439800001]
[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":1313149},462.22844800000007]
[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":1313149},23854.664734000002]
[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":9.7899999999999991},0,9.7899999999999991,{"$f":"H25","v":1313149},128557.28709999999]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":790448.33282946376}]

{"sheet":"D1.4 Rate 16 Adjustment","index":8,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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.0299999999999999E-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":1575.7833749999998},{"$f":"$E$13","v":2.0299999999999999E-2},{"$f":"E17*(1+F17)","v":1607.7717775124997},{"$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":57879.783990449985}]
[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.0299999999999999E-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.0299999999999999E-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.0299999999999999E-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":107.48305025999998},2.0299999999999999E-2,109.66495618027798,{"$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":1261024.171322275}]
[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":9.7899999999999991},0,9.7899999999999991,{"$f":"H25","v":95824},{"$f":"G28*H28/100*$E$14","v":112574.03519999998}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I28)","v":1805725.492016725}]

{"sheet":"E1.1 Proposed Dist Rates ","index":9,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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"]
[null,null,null,null,"$/month","$/month","₵ / m3","₵ / m3","₵ / m3","₵/contracted m3","₵/m3","(A)","₵  / m3","₵ /contracted m3","₵ /contracted m3","₵ /contracted 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":26.8057276794},{"$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":28.719976890329995},{"$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":28.154228386436994},{"$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":27.322606159983},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":30.690200000000001},{"$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":9.7899999999999991}]
[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":109.33367980949998},{"$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":26.494935126902998},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(H8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":23.845452012089996},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(I8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":22.653023443325999},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":30.690200000000001},{"$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":9.7899999999999991}]
[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":218.65696174169994},{"$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":16.457760190439998},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(H8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":16.457760190439998},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(I8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":16.457760190439998},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":30.690200000000001},{"$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":9.7899999999999991}]
[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":1607.7717775124997},{"$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":109.66495618027798},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":9.7899999999999991}]
[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":10,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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":"'B1.2 Billing Determinants'!E9","v":4887},{"$f":"'B1.2 Billing Determinants'!F9","v":3391849},{"$f":"'B1.2 Billing Determinants'!G9","v":1847677},{"$f":"'B1.2 Billing Determinants'!H9","v":263269},{"$f":"'B1.2 Billing Determinants'!I9","v":0},{"$f":"'B1.2 Billing Determinants'!J9","v":5502795}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'B1.2 Billing Determinants'!E10","v":35},{"$f":"'B1.2 Billing Determinants'!F10","v":287896},{"$f":"'B1.2 Billing Determinants'!G10","v":903329},{"$f":"'B1.2 Billing Determinants'!H10","v":890107},{"$f":"'B1.2 Billing Determinants'!I10","v":0},{"$f":"'B1.2 Billing Determinants'!J10","v":2081331}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'B1.2 Billing Determinants'!E11","v":7},{"$f":"'B1.2 Billing Determinants'!F11","v":0},{"$f":"'B1.2 Billing Determinants'!G11","v":0},{"$f":"'B1.2 Billing Determinants'!H11","v":1313149},{"$f":"'B1.2 Billing Determinants'!I11","v":0},{"$f":"'B1.2 Billing Determinants'!J11","v":1313149}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'B1.2 Billing Determinants'!E12","v":3},{"$f":"'B1.2 Billing Determinants'!F12","v":0},{"$f":"'B1.2 Billing Determinants'!G12","v":0},{"$f":"'B1.2 Billing Determinants'!H12","v":0},{"$f":"'B1.2 Billing Determinants'!I12","v":95824},{"$f":"'B1.2 Billing Determinants'!J12","v":0}]

{"sheet":"E1.3 Proposed Rev From Rate","index":11,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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":1571995.0940307337},{"$f":"'E1.1 Proposed Dist Rates '!F10*'E1.2 Billing Determinants'!E11*$D$7","v":58644},{"$f":"'E1.1 Proposed Dist Rates '!G10*'E1.2 Billing Determinants'!F11/100","v":974138.24895488902},{"$f":"'E1.1 Proposed Dist Rates '!H10*'E1.2 Billing Determinants'!G11/100","v":520199.20242366748},{"$f":"'E1.1 Proposed Dist Rates '!I10*'E1.2 Billing Determinants'!H11/100","v":71931.952011325644},{"$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":1688818.79109},{"$f":"'E1.1 Proposed Dist Rates '!L10*'E1.2 Billing Determinants'!$J11/100","v":81111.198300000004},{"$f":"'E1.1 Proposed Dist Rates '!M10*'E1.2 Billing Determinants'!$J11/100","v":148476.41469000001},{"$f":"'E1.1 Proposed Dist Rates '!Q10*'E1.2 Billing Determinants'!J11/100","v":538723.63049999997},{"$f":"SUM(E11:N11)","v":5654038.5320006162}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E11*'E1.2 Billing Determinants'!E12*$D$7","v":45920.145519989994},{"$f":"'E1.1 Proposed Dist Rates '!F11*'E1.2 Billing Determinants'!E12*$D$7","v":420},{"$f":"'E1.1 Proposed Dist Rates '!G11*'E1.2 Billing Determinants'!F12/100","v":76277.858432948648},{"$f":"'E1.1 Proposed Dist Rates '!H11*'E1.2 Billing Determinants'!G12/100","v":215402.88320629243},{"$f":"'E1.1 Proposed Dist Rates '!I11*'E1.2 Billing Determinants'!H12/100","v":201636.14738068578},{"$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":638764.64656200004},{"$f":"'E1.1 Proposed Dist Rates '!L11*'E1.2 Billing Determinants'!$J12/100","v":60774.865199999993},{"$f":"'E1.1 Proposed Dist Rates '!M11*'E1.2 Billing Determinants'!$J12/100","v":117414.125703},{"$f":"'E1.1 Proposed Dist Rates '!Q11*'E1.2 Billing Determinants'!J12/100","v":203762.30489999999},{"$f":"SUM(E12:N12)","v":1560372.9769049166}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'E1.1 Proposed Dist Rates '!E12*'E1.2 Billing Determinants'!E13*$D$7","v":18367.184786302794},{"$f":"'E1.1 Proposed Dist Rates '!F12*'E1.2 Billing Determinants'!E13*$D$7","v":84},{"$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":216114.91336316094},{"$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":403008.05439800001},{"$f":"'E1.1 Proposed Dist Rates '!L12*'E1.2 Billing Determinants'!$J13/100","v":462.22844800000007},{"$f":"'E1.1 Proposed Dist Rates '!M12*'E1.2 Billing Determinants'!$J13/100","v":23854.664734000002},{"$f":"'E1.1 Proposed Dist Rates '!Q12*'E1.2 Billing Determinants'!J13/100","v":128557.28709999999},{"$f":"SUM(E13:N13)","v":790448.33282946376}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E13*'E1.2 Billing Determinants'!E14*$D$7","v":57879.783990449985},{"$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":1261024.171322275},{"$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":112574.03519999998},{"$f":"SUM(E14:N14)","v":1805725.492016725}]
[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":9810585.3337517213}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Revenue",{"$f":"'B1.3 Current Rev From Rates'!O18","v":9706511.0242505148}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change",{"$f":"O15-O16","v":104074.3095012065}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"% Change",{"$f":"O17/O16","v":1.0722113150769595E-2}]

{"sheet":"F1.3 Rate Riders","index":12,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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.34370175899425925,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.27783639709160213,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.18567839639491462,"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,3.3388371724887351,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,3.1384513317011078,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.60738113261839544,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,4.531061257605967,"Cents/contracted demand m3/month"]
[]
[]
[null,null,"Municipal Tax Variance Account"]
[null,null,null,null,"MTVA Rate Rider"]
[]
[null,null,"Rate 1 | General Firm Service",null,-2.7906,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,-3.4039999999999999,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,-0.66039999999999999,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,-4.5564,"Cents/contracted demand m3/month"]

{"sheet":"G1.1 Rate 1 Bill Impact","index":13,"n_rows":181,"n_cols":12,"rows_kept":181,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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":26.272397999999999},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":26.8057276794}]
[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":28.148561099999995},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":28.719976890329995}]
[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":27.594068789999994},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":28.154228386436994}]
[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":26.77899261},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":27.322606159983}]
[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":30.690200000000001},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":30.690200000000001}]
[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":9.7899999999999991},null,{"$f":"'E1.1 Proposed Dist Rates '!Q10","v":9.7899999999999991}]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E10","v":1.633},null,{"$f":"'F1.3 Rate Riders'!E9","v":1.633}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E19","v":0.14030000000000001},null,{"$f":"'F1.3 Rate Riders'!E18","v":0.34370175899425925}]
[null,null,{"$f":"'C1.1 Current Rate Riders'!E35","v":"EFVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E37","v":0.51970000000000005},null,{"$f":"'F1.3 Rate Riders'!E26","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E28","v":0.54339999999999999},null,{"$f":"'F1.3 Rate Riders'!E27","v":3.3388371724887351}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",0,null,{"$f":"'F1.3 Rate Riders'!E36","v":-2.7906}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F12*$E31","v":315.268776},null,{"$f":"H12*$E31","v":321.66873215279998},null,{"$f":"H31-F31","v":6.3999561527999731},null,{"$f":"J31/F31","v":2.0299999999999915E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"F13*$E32","v":12},null,{"$f":"H13*$E32","v":12},null,{"$f":"H32-F32","v":0},null,{"$f":"J32/F32","v":0}]
[null,null,"First 100 m3",null,1001.3160527512506,{"$f":"F14*$E33/100","v":281.85606091279396},null,{"$f":"H14*$E33/100","v":287.5777389493237},null,{"$f":"H33-F33","v":5.7216780365297382},null,{"$f":"J33/F33","v":2.0300000000000075E-2}]
[null,null,"Next 400 m3",null,1147.6839472487493,316.69269789560713,null,323.12155966288793,null,6.4288617672808073,null,2.0299999999999947E-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(E33:E36)","v":2149},659.53239799999994,null,659.53239799999994,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E37","v":2149},31.676259999999999,null,31.676259999999999,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E38","v":2149},57.984318000000002,null,57.984318000000002,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E37","v":2149},210.3871,null,210.3871,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F31:F40)","v":1885.3976108084009},null,{"$f":"SUM(H31:H40)","v":1903.9481067650113},null,{"$f":"SUM(J31:J40)","v":18.550495956610519},null,{"$f":"J41/F41","v":9.8390365248509203E-3}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E37","v":2149},{"$f":"$E44*F24/100","v":35.093170000000001},null,{"$f":"$E44*H24/100","v":35.093170000000001},null,{"$f":"H44-F44","v":0},null,{"$f":"J44/F44","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E44","v":2149},{"$f":"$E45*F25/100","v":3.015047},null,{"$f":"$E45*H25/100","v":7.3861508007866314},null,{"$f":"H45-F45","v":4.3711038007866314},null,{"$f":"J45/F45","v":1.4497630719476782}]
[null,null,{"$f":"'C1.1 Current Rate Riders'!E35","v":"EFVA Rate Rider"},null,{"$f":"E44","v":2149},{"$f":"$E46*F26/100","v":11.168353000000002},null,{"$f":"$E46*H26/100","v":0},null,{"$f":"H46-F46","v":-11.168353000000002},null,{"$f":"J46/F46","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E45","v":2149},{"$f":"$E47*F27/100","v":11.677665999999999},null,{"$f":"$E47*H27/100","v":71.751610836782916},null,60.073944836782914,null,5.1443451830856377]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,{"$f":"E47","v":2149},{"$f":"$E48*F28/100","v":0},null,{"$f":"$E48*H28/100","v":-59.969994},null,-59.969994,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F44:F48)","v":60.954236000000009},null,{"$f":"SUM(H44:H48)","v":54.26093763756954},null,{"$f":"SUM(J44:J48)","v":-6.6932983624304541},null,{"$f":"J49/F49","v":-0.10980858430299173}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F41+F49","v":1946.351846808401},null,{"$f":"H41+H49","v":1958.2090444025807},null,{"$f":"J41+J49","v":11.857197594180064},null,{"$f":"J51/F51","v":6.092011376886107E-3}]
[]
[]
[null,null,"Rate 1 - New Residential",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F12","v":26.272397999999999},null,{"$f":"H12","v":26.8057276794}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",28.148561099999995,null,28.719976890329995]
[null,null,"Next 400 m3",null,"₵/m3",27.594068789999994,null,28.154228386436994]
[null,null,"GT 500m3",null,"₵/m3",26.77899261,null,27.322606159983]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",30.690200000000001,null,30.690200000000001]
[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",9.7899999999999991,null,9.7899999999999991]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F24","v":1.633},null,{"$f":"H24","v":1.633}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F25","v":0.14030000000000001},null,{"$f":"H25","v":0.34370175899425925}]
[null,null,{"$f":"C46","v":"EFVA Rate Rider"},null,"₵/m3",{"$f":"F26","v":0.51970000000000005},null,{"$f":"H26","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"F27","v":0.54339999999999999},null,{"$f":"H27","v":3.3388371724887351}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"F28","v":0},null,{"$f":"H28","v":-2.7906}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F56*$E75","v":315.268776},null,{"$f":"H56*$E75","v":321.66873215279998},null,{"$f":"H75-F75","v":6.3999561527999731},null,{"$f":"J75/F75","v":2.0299999999999915E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E75","v":12},{"$f":"F57*$E76","v":12},null,{"$f":"H57*$E76","v":12},null,{"$f":"H76-F76","v":0},null,{"$f":"J76/F76","v":0}]
[null,null,"First 100 m3",null,993.12960436562071,{"$f":"F58*$E77/100","v":279.55169348704499},null,{"$f":"H58*$E77/100","v":285.22659286483196},null,{"$f":"H77-F77","v":5.6748993777869714},null,{"$f":"J77/F77","v":2.0299999999999849E-2}]
[null,null,"Next 400 m3",null,1072.8703956343793,296.04859499889574,null,302.0583814773733,null,6.0097864784775652,null,2.029999999999994E-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(E77:E80)","v":2066},634.05953199999999,null,634.05953199999999,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E81","v":2066},30.452840000000002,null,30.452840000000002,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E82","v":2066},55.744812000000003,null,55.744812000000003,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E81","v":2066},202.26139999999998,null,202.26139999999998,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F75:F84)","v":1825.3876484859406},null,{"$f":"SUM(H75:H84)","v":1843.4722904950049},null,{"$f":"SUM(J75:J84)","v":18.08464200906451},null,{"$f":"J85/F85","v":9.9072884732537402E-3}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E81","v":2066},{"$f":"$E88*F68/100","v":33.737780000000001},null,{"$f":"$E88*H68/100","v":33.737780000000001},null,{"$f":"H88-F88","v":0},null,{"$f":"J88/F88","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E88","v":2066},{"$f":"$E89*F69/100","v":2.8985980000000002},null,{"$f":"$E89*H69/100","v":7.1008783408213958},null,{"$f":"H89-F89","v":4.202280340821396},null,{"$f":"J89/F89","v":1.449763071947678}]
[null,null,{"$f":"C70","v":"EFVA Rate Rider"},null,{"$f":"E88","v":2066},{"$f":"$E90*F70/100","v":10.737002},null,{"$f":"$E90*H70/100","v":0},null,{"$f":"H90-F90","v":-10.737002},null,{"$f":"J90/F90","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E89","v":2066},{"$f":"$E91*F71/100","v":11.226643999999999},null,{"$f":"$E91*H71/100","v":68.980375983617265},null,57.753731983617264,null,5.1443451830856377]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,{"$f":"E91","v":2066},{"$f":"$E92*F72/100","v":0},null,{"$f":"$E92*H72/100","v":-57.653796},null,-57.653796,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F88:F92)","v":58.600023999999998},null,{"$f":"SUM(H88:H92)","v":52.165238324438661},null,{"$f":"SUM(J88:J92)","v":-6.4347856755613435},null,{"$f":"J93/F93","v":-0.10980858430299181}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F85+F93","v":1883.9876724859407},null,{"$f":"H85+H93","v":1895.6375288194436},null,{"$f":"J85+J93","v":11.649856333503166},null,{"$f":"J95/F95","v":6.1836160096159568E-3}]
[]
[null,null,"Rate 1 - Small Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F56","v":26.272397999999999},null,{"$f":"H56","v":26.8057276794}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",28.148561099999995,null,28.719976890329995]
[null,null,"Next 400 m3",null,"₵/m3",27.594068789999994,null,28.154228386436994]
[null,null,"GT 500m3",null,"₵/m3",26.77899261,null,27.322606159983]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",30.690200000000001,null,30.690200000000001]
[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",9.7899999999999991,null,9.7899999999999991]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F68","v":1.633},null,{"$f":"H68","v":1.633}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F69","v":0.14030000000000001},null,{"$f":"H69","v":0.34370175899425925}]
[null,null,{"$f":"C90","v":"EFVA Rate Rider"},null,"₵/m3",{"$f":"F70","v":0.51970000000000005},null,{"$f":"H70","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"F71","v":0.54339999999999999},null,{"$f":"H71","v":3.3388371724887351}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"F72","v":0},null,{"$f":"H72","v":-2.7906}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F99*$E118","v":315.268776},null,{"$f":"H99*$E118","v":321.66873215279998},null,{"$f":"H118-F118","v":6.3999561527999731},null,{"$f":"J118/F118","v":2.0299999999999915E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E118","v":12},{"$f":"F100*$E119","v":12},null,{"$f":"H100*$E119","v":12},null,{"$f":"H119-F119","v":0},null,{"$f":"J119/F119","v":0}]
[null,null,"First 100 m3",null,1198.1709868121873,{"$f":"F101*$E120/100","v":337.26789230530142},null,{"$f":"H101*$E120/100","v":344.11443051909902},null,{"$f":"H120-F120","v":6.8465382137976007},null,{"$f":"J120/F120","v":2.0299999999999947E-2}]
[null,null,"Next 400 m3",null,2475.0040927694408,682.95433191411473,null,696.81830485197133,null,13.863972937856602,null,2.0300000000000106E-2]
[null,null,"GT 500m3",null,1019.8249204183721,273.09884007377428,null,278.64274652727187,null,5.5439064534975842,null,2.0299999999999877E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E120:E123)","v":4693},1440.2910860000002,null,1440.2910860000002,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E124","v":4693},69.174819999999997,null,69.174819999999997,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E125","v":4693},126.626526,null,126.626526,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E124","v":4693},459.44469999999995,null,459.44469999999995,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F118:F127)","v":3716.1269722931906},null,{"$f":"SUM(H118:H127)","v":3748.7813460511425},null,{"$f":"SUM(J118:J127)","v":32.65437375795176},null,{"$f":"J128/F128","v":8.7872061426902803E-3}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E124","v":4693},{"$f":"$E131*F111/100","v":76.636690000000002},null,{"$f":"$E131*H111/100","v":76.636690000000002},null,{"$f":"H131-F131","v":0},null,{"$f":"J131/F131","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E131","v":4693},{"$f":"$E132*F112/100","v":6.5842790000000004},null,{"$f":"$E132*H112/100","v":16.129923549600587},null,{"$f":"H132-F132","v":9.5456445496005866},null,{"$f":"J132/F132","v":1.4497630719476782}]
[null,null,{"$f":"C113","v":"EFVA Rate Rider"},null,{"$f":"E131","v":4693},{"$f":"$E133*F113/100","v":24.389521000000006},null,{"$f":"$E133*H113/100","v":0},null,{"$f":"H133-F133","v":-24.389521000000006},null,{"$f":"J133/F133","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E132","v":4693},{"$f":"$E134*F114/100","v":25.501761999999999},null,{"$f":"$E134*H114/100","v":156.69162850489636},null,131.18986650489637,null,5.1443451830856386]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,{"$f":"E134","v":4693},{"$f":"$E135*F115/100","v":0},null,{"$f":"$E135*H115/100","v":-130.96285799999998},null,-130.96285799999998,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F131:F135)","v":133.11225200000001},null,{"$f":"SUM(H131:H135)","v":118.49538405449698},null,{"$f":"SUM(J131:J135)","v":-14.616867945503031},null,{"$f":"J136/F136","v":-0.10980858430299135}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F128+F136","v":3849.2392242931905},null,{"$f":"H128+H136","v":3867.2767301056392},null,{"$f":"J128+J136","v":18.037505812448728},null,{"$f":"J138/F138","v":4.6859924160106816E-3}]
[]
[null,null,"Rate 1 - Small Agricultural",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F99","v":26.272397999999999},null,{"$f":"H99","v":26.8057276794}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",{"$f":"F101","v":28.148561099999995},null,{"$f":"H101","v":28.719976890329995}]
[null,null,"Next 400 m3",null,"₵/m3",27.594068789999994,null,28.154228386436994]
[null,null,"GT 500m3",null,"₵/m3",26.77899261,null,27.322606159983]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",30.690200000000001,null,30.690200000000001]
[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",9.7899999999999991,null,9.7899999999999991]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F111","v":1.633},null,{"$f":"H111","v":1.633}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F112","v":0.14030000000000001},null,{"$f":"H112","v":0.34370175899425925}]
[null,null,{"$f":"C133","v":"EFVA Rate Rider"},null,"₵/m3",{"$f":"F113","v":0.51970000000000005},null,{"$f":"H113","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"F114","v":0.54339999999999999},null,{"$f":"H114","v":3.3388371724887351}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"F115","v":0},null,{"$f":"H115","v":-2.7906}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F142*$E161","v":315.268776},null,{"$f":"H142*$E161","v":321.66873215279998},null,{"$f":"H161-F161","v":6.3999561527999731},null,{"$f":"J161/F161","v":2.0299999999999915E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E161","v":12},{"$f":"F143*$E162","v":12},null,{"$f":"H143*$E162","v":12},null,{"$f":"H162-F162","v":0},null,{"$f":"J162/F162","v":0}]
[null,null,"First 100 m3",null,1198.7357889949976,{"$f":"F144*$E163/100","v":337.42687599282391},null,{"$f":"H144*$E163/100","v":344.27664157547827},null,{"$f":"H163-F163","v":6.8497655826543564},null,{"$f":"J163/F163","v":2.0300000000000092E-2}]
[null,null,"Next 400 m3",null,2484.0654843110506,685.45473852943769,null,699.36946972158535,null,13.914731192147656,null,2.0300000000000103E-2]
[null,null,"GT 500m3",null,1037.1987266939518,277.75137037238744,null,283.38972319094688,null,5.63835281855944,null,2.0299999999999908E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Commodity",null,{"$f":"SUM(E163:E166)","v":4720},1448.57744,null,1448.57744,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E167","v":4720},69.572800000000001,null,69.572800000000001,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E168","v":4720},127.35503999999999,null,127.35503999999999,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E167","v":4720},462.08799999999997,null,462.08799999999997,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F161:F170)","v":3735.4950408946488},null,{"$f":"SUM(H161:H170)","v":3768.2978466408103},null,{"$f":"SUM(J161:J170)","v":32.802805746161425},null,{"$f":"J171/F171","v":8.781381152176599E-3}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E167","v":4720},{"$f":"$E174*F154/100","v":77.077600000000004},null,{"$f":"$E174*H154/100","v":77.077600000000004},null,{"$f":"H174-F174","v":0},null,{"$f":"J174/F174","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E174","v":4720},{"$f":"$E175*F155/100","v":6.62216},null,{"$f":"$E175*H155/100","v":16.222723024529035},null,{"$f":"H175-F175","v":9.6005630245290341},null,{"$f":"J175/F175","v":1.4497630719476777}]
[null,null,{"$f":"C156","v":"EFVA Rate Rider"},null,{"$f":"E174","v":4720},{"$f":"$E176*F156/100","v":24.529840000000004},null,{"$f":"$E176*H156/100","v":0},null,{"$f":"H176-F176","v":-24.529840000000004},null,{"$f":"J176/F176","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,4720,25.648479999999999,null,157.59311454146828,null,131.94463454146828,null,5.1443451830856359]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,{"$f":"E177","v":4720},{"$f":"$E178*F158/100","v":0},null,{"$f":"$E178*H158/100","v":-131.71632},null,-131.71632,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F174:F178)","v":133.87808000000001},null,{"$f":"SUM(H174:H178)","v":119.17711756599732},null,{"$f":"SUM(J174:J178)","v":-14.70096243400269},null,{"$f":"J179/F179","v":-0.10980858430299187}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F171+F179","v":3869.3731208946488},null,{"$f":"H171+H179","v":3887.4749642068077},null,{"$f":"J171+J179","v":18.101843312158735},null,{"$f":"J181/F181","v":4.6782366927626134E-3}]

{"sheet":"G1.2 Rate 6 Bill Impact","index":14,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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":107.15836499999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C10))","v":109.33367980949998}]
[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":25.967789009999997},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C12))","v":26.494935126902998}]
[null,null,"Next 6000 m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C13))","v":23.371020299999998},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C13))","v":23.845452012089996}]
[null,null,"GT 7000m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C14))","v":22.202316419999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C14))","v":22.653023443325999}]
[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":30.690200000000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C16))","v":30.690200000000001}]
[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":9.7899999999999991},null,{"$f":"'E1.1 Proposed Dist Rates '!Q11","v":9.7899999999999991}]
[]
[null,null,"Rate Riders"]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$7","v":"Delay in Revenue Recovery Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E11","v":0.90900000000000003},null,{"$f":"'F1.3 Rate Riders'!E10","v":0.90900000000000003}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,null,{"$f":"'C1.1 Current Rate Riders'!E20","v":0.14030000000000001},null,{"$f":"'F1.3 Rate Riders'!$E$19","v":0.27783639709160213}]
[null,null,{"$f":"'C1.1 Current Rate Riders'!E35","v":"EFVA Rate Rider"},null,null,{"$f":"'C1.1 Current Rate Riders'!E38","v":0.66080000000000005},null,0]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,null,{"$f":"'C1.1 Current Rate Riders'!E29","v":0.71350000000000002},null,{"$f":"'F1.3 Rate Riders'!$E$28","v":3.1384513317011078}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,null,0,null,{"$f":"'F1.3 Rate Riders'!$E$37","v":-3.4039999999999999}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E29","v":1285.9003799999998},null,{"$f":"H10*$E29","v":1312.0041577139998},null,{"$f":"H29-F29","v":26.103777713999989},null,{"$f":"J29/F29","v":2.0299999999999995E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E29","v":12},{"$f":"E30*F11","v":12},null,{"$f":"E30*H11","v":12},null,0,null,0]
[null,null,"First 1000 m3",null,9831.5433379437527,{"$f":"F12*$E31/100","v":2553.0344304239447},null,{"$f":"H12*$E31/100","v":2604.8610293615507},null,51.826598937605922,null,2.029999999999994E-2]
[null,null,"Next 6000 m3",null,17101.456662056247,3996.7849080848678,null,4077.9196417189901,null,81.134733634122313,null,2.0299999999999874E-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(E31:E34)","v":26933},8265.7915659999999,null,8265.7915659999999,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E35","v":26933},786.44360000000006,null,786.44360000000006,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E36","v":26933},1519.3713290000001,null,1519.3713290000001,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E37","v":26933},2636.7406999999994,null,2636.7406999999994,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F29:F38)","v":21056.06691350881},null,{"$f":"SUM(H29:H38)","v":21215.13202379454},null,{"$f":"SUM(J29:J38)","v":159.06511028572822},null,7.5543600302522699E-3]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E35","v":26933},{"$f":"$E42*F22/100","v":244.82097000000002},null,{"$f":"$E42*H22/100","v":244.82097000000002},null,{"$f":"H42-F42","v":0},null,{"$f":"J42/F42","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E42","v":26933},{"$f":"$E43*F23/100","v":37.786999000000002},null,{"$f":"$E43*H23/100","v":74.829676828681201},null,{"$f":"H43-F43","v":37.0426778286812},null,{"$f":"J43/F43","v":0.98030218882111275}]
[null,null,{"$f":"C24","v":"EFVA Rate Rider"},null,{"$f":"E42","v":26933},{"$f":"$E44*F24/100","v":177.97326400000003},null,{"$f":"$E44*H24/100","v":0},null,{"$f":"H44-F44","v":-177.97326400000003},null,{"$f":"J44/F44","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E43","v":26933},{"$f":"$E45*F25/100","v":192.16695500000003},null,{"$f":"$E45*H25/100","v":845.27909716705938},null,653.11214216705935,null,{"$f":"J45/F45","v":3.3986704018235563}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,{"$f":"E45","v":26933},{"$f":"$E46*F26/100","v":0},null,{"$f":"$E46*H26/100","v":-916.79931999999997},null,-916.79931999999997,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F42:F46)","v":652.74818800000003},null,{"$f":"SUM(H42:H46)","v":248.13042399574067},null,{"$f":"SUM(J42:J46)","v":-404.61776400425947},null,{"$f":"J47/F47","v":-0.61986807691338919}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F39+F47","v":21708.815101508811},null,{"$f":"H39+H47","v":21463.262447790279},null,{"$f":"J39+J47","v":-245.55265371853125},null,{"$f":"J49/F49","v":-1.1311195593603116E-2}]
[]
[]
[null,null,"Rate 6 - Medium Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F10","v":107.15836499999999},null,{"$f":"H10","v":109.33367980949998}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 1000 m3",null,"₵/m3",25.967789009999997,null,26.494935126902998]
[null,null,"Next 6000 m3",null,"₵/m3",23.371020299999998,null,23.845452012089996]
[null,null,"GT 7000m3",null,"₵/m3",22.202316419999999,null,22.653023443325999]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",30.690200000000001,null,30.690200000000001]
[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",9.7899999999999991,null,9.7899999999999991]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F22","v":0.90900000000000003},null,{"$f":"H22","v":0.90900000000000003}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,null,{"$f":"F23","v":0.14030000000000001},null,{"$f":"'F1.3 Rate Riders'!E19","v":0.27783639709160213}]
[null,null,{"$f":"C44","v":"EFVA Rate Rider"},null,null,0.66080000000000005,null,0]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,null,0.71350000000000002,null,{"$f":"'F1.3 Rate Riders'!E28","v":3.1384513317011078}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,null,0,null,{"$f":"'F1.3 Rate Riders'!$E$37","v":-3.4039999999999999}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F54*$E73","v":1285.9003799999998},null,{"$f":"H54*$E73","v":1312.0041577139998},null,{"$f":"H73-F73","v":26.103777713999989},null,{"$f":"J73/F73","v":2.0299999999999995E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"E74*F55","v":12},null,{"$f":"E74*H55","v":12},null,{"$f":"H74-F74","v":0},null,{"$f":"J74/F74","v":0}]
[null,null,"First 1000 m3",null,11715.326187183033,{"$f":"F56*$E75/100","v":3042.2111861209669},null,{"$f":"H56*$E75/100","v":3103.968073199223},null,{"$f":"H75-F75","v":61.756887078256113},null,{"$f":"J75/F75","v":2.0300000000000158E-2}]
[null,null,"Next 6000 m3",null,40792.718418626093,9533.6745025389428,null,9727.2080949404826,null,193.53359240153986,null,2.0299999999999929E-2]
[null,null,"GT 7000m3",null,23176.955394190867,5145.8209731405141,null,5250.2811388952668,null,104.46016575475278,null,2.0300000000000068E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E75:E78)","v":75685},23227.87787,null,23227.87787,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E79","v":75685},2210.002,null,2210.002,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E80","v":75685},4269.6179050000001,null,4269.6179050000001,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E81","v":75685},7409.5614999999989,null,7409.5614999999989,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F73:F82)","v":56136.666316800416},null,{"$f":"SUM(H73:H82)","v":56522.520739748972},null,{"$f":"SUM(J73:J82)","v":385.85442294854874},null,{"$f":"J83/F83","v":6.8734830239299653E-3}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E79","v":75685},{"$f":"$E86*F66/100","v":687.97665000000006},null,{"$f":"$E86*H66/100","v":687.97665000000006},null,{"$f":"H86-F86","v":0},null,{"$f":"J86/F86","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!E16","v":"ECVA Rate Rider"},null,{"$f":"E86","v":75685},{"$f":"$E87*F67/100","v":106.18605500000001},null,{"$f":"$E87*H67/100","v":210.28047713877905},null,{"$f":"H87-F87","v":104.09442213877904},null,{"$f":"J87/F87","v":0.98030218882111242}]
[null,null,{"$f":"C68","v":"EFVA Rate Rider"},null,{"$f":"E86","v":75685},{"$f":"$E88*F68/100","v":500.12648000000002},null,{"$f":"$E88*H68/100","v":0},null,{"$f":"H88-F88","v":-500.12648000000002},null,{"$f":"J88/F88","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!E25","v":"CIACVA Rate Rider"},null,{"$f":"E87","v":75685},{"$f":"$E89*F69/100","v":540.01247499999999},null,{"$f":"$E89*H69/100","v":2375.3368903979836},null,1835.3244153979836,null,3.3986704018235572]
[null,null,{"$f":"'F1.3 Rate Riders'!E34","v":"MTVA Rate Rider"},null,{"$f":"E89","v":75685},{"$f":"$E90*F70/100","v":0},null,{"$f":"$E90*H70/100","v":-2576.3173999999999},null,-2576.3173999999999,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F86:F90)","v":1834.3016600000001},null,{"$f":"SUM(H86:H90)","v":697.27661753676284},null,{"$f":"SUM(J86:J90)","v":-1137.0250424632372},null,{"$f":"J91/F91","v":-0.61986807691338908}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F83+F91","v":57970.967976800413},null,{"$f":"H83+H91","v":57219.797357285737},null,{"$f":"J83+J91","v":-751.1706195146885},null,{"$f":"J93/F93","v":-1.2957703583892231E-2}]

{"sheet":"G1.3 Rate 11 Bill Impact","index":15,"n_rows":92,"n_cols":12,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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":214.30653899999996},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C10:C$10))","v":218.65696174169994}]
[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.130314799999997},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C12))","v":16.457760190439998}]
[null,null,"Tier 2",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C13))","v":16.130314799999997},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C13))","v":16.457760190439998}]
[null,null,"Tier 3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C14))","v":16.130314799999997},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C14))","v":16.457760190439998}]
[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":30.690200000000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C16))","v":30.690200000000001}]
[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":9.7899999999999991},null,{"$f":"'E1.1 Proposed Dist Rates '!Q12","v":9.7899999999999991}]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E12","v":0.5524},null,{"$f":"'F1.3 Rate Riders'!E11","v":0.5524}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E21","v":0.14030000000000001},null,{"$f":"'F1.3 Rate Riders'!E20","v":0.18567839639491462}]
[null,null,{"$f":"'C1.1 Current Rate Riders'!E35","v":"EFVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E39","v":0.1075},null,0]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E30","v":9.9199999999999997E-2},null,{"$f":"'F1.3 Rate Riders'!E30","v":4.531061257605967}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",0,null,{"$f":"'F1.3 Rate Riders'!E39","v":-4.5564}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E29","v":2571.6784679999996},null,{"$f":"H10*$E29","v":2623.8835409003996},null,{"$f":"H29-F29","v":52.205072900399955},null,{"$f":"J29/F29","v":2.0299999999999985E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"$E30*F11","v":12},null,{"$f":"$E30*H11","v":12},null,0,null,0]
[null,null,"All Volumes",null,101499.48573593894,{"$f":"F12*$E31/100","v":16372.186569588044},null,{"$f":"H12*$E31/100","v":16704.541956950685},null,332.35538736264061,null,2.0300000000000203E-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(E31:E34)","v":101499.48573593894},31150.395171331136,null,31150.395171331136,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E35","v":101499.48573593894},35.727818979050511,null,35.727818979050511,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E36","v":101499.48573593894},1843.8396578790669,null,1843.8396578790669,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E37","v":101499.48573593894},{"$f":"$E38*F19/100","v":9936.7996535484217},null,{"$f":"$E38*H19/100","v":9936.7996535484217},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F29:F38)","v":61922.627339325714},null,{"$f":"SUM(H29:H38)","v":62307.187799588755},null,{"$f":"SUM(J29:J38)","v":384.56046026304057},null,6.2103382363883413E-3]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E35","v":101499.48573593894},{"$f":"$E42*F22/100","v":560.68315920532677},null,{"$f":"$E42*H22/100","v":560.68315920532677},null,{"$f":"H42-F42","v":0},null,{"$f":"J42/F42","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E42","v":101499.48573593894},{"$f":"$E43*F23/100","v":142.40377848752235},null,{"$f":"$E43*H23/100","v":188.46261746357652},null,{"$f":"H43-F43","v":46.058838976054176},null,{"$f":"J43/F43","v":0.3234383207050221}]
[null,null,{"$f":"C24","v":"EFVA Rate Rider"},null,{"$f":"E42","v":101499.48573593894},{"$f":"$E44*F24/100","v":109.11194716613436},null,{"$f":"$E44*H24/100","v":0},null,{"$f":"H44-F44","v":-109.11194716613436},null,{"$f":"J44/F44","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E43","v":101499.48573593894},{"$f":"$E45*F25/100","v":100.68748985005142},null,{"$f":"$E45*H25/100","v":4599.0038748504239},null,4498.3163850003721,null,44.676020741995636]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,{"$f":"E45","v":101499.48573593894},{"$f":"$E46*F26/100","v":0},null,{"$f":"$E46*H26/100","v":-4624.7225680723222},null,-4624.7225680723222,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F42:F46)","v":912.88637470903484},null,{"$f":"SUM(H42:H46)","v":723.42708344700532},null,-189.45929126203009,null,{"$f":"J47/F47","v":-0.20753874360586949}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F39+F47","v":62835.513714034751},null,{"$f":"H39+H47","v":63030.614883035763},null,{"$f":"J39+J47","v":195.10116900101048},null,{"$f":"J49/F49","v":3.1049506476372338E-3}]
[]
[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":214.30653899999996},null,{"$f":"H10","v":218.65696174169994}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"All Volumes",null,"₵/m3",{"$f":"F12","v":16.130314799999997},null,{"$f":"H12","v":16.457760190439998}]
[null,null,"Tier 2",null,"₵/m3",16.130314799999997,null,16.457760190439998]
[null,null,"Tier 3",null,"₵/m3",16.130314799999997,null,16.457760190439998]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",30.690200000000001,null,30.690200000000001]
[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",3.91,null,3.91]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F22","v":0.5524},null,{"$f":"H22","v":0.5524}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m3",{"$f":"F23","v":0.14030000000000001},null,{"$f":"H23","v":0.18567839639491462}]
[null,null,{"$f":"C44","v":"EFVA Rate Rider"},null,"₵/m3",{"$f":"F24","v":0.1075},null,{"$f":"H24","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",{"$f":"F25","v":9.9199999999999997E-2},null,{"$f":"H25","v":4.531061257605967}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵/m3",{"$f":"F26","v":0},null,{"$f":"H26","v":-4.5564}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F53*$E72","v":2571.6784679999996},null,{"$f":"H53*$E72","v":2623.8835409003996},null,{"$f":"H72-F72","v":52.205072900399955},null,{"$f":"J72/F72","v":2.0299999999999985E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"$E73*F54","v":12},null,{"$f":"$E73*H54","v":12},null,{"$f":"H73-F73","v":0},null,{"$f":"J73/F73","v":0}]
[null,null,"All Volumes",null,338331.61911979644,{"$f":"F55*$E74/100","v":54573.955231960143},null,{"$f":"H55*$E74/100","v":55681.806523168947},null,{"$f":"H74-F74","v":1107.8512912088045},null,{"$f":"J74/F74","v":2.0300000000000248E-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(E74:E77)","v":338331.61911979644},103834.65057110376,null,103834.65057110376,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E78","v":338331.61911979644},119.09272993016835,null,119.09272993016835,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E79","v":338331.61911979644},6146.1321929302221,null,6146.1321929302221,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E80","v":338331.61911979644},{"$f":"$E81*F62/100","v":13228.766307584041},null,{"$f":"$E81*H62/100","v":13228.766307584041},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F72:F81)","v":180486.27550150832},null,{"$f":"SUM(H72:H81)","v":181646.33186561754},null,{"$f":"SUM(J72:J81)","v":1160.0563641092044},null,{"$f":"J82/F82","v":6.4273937776477075E-3}]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E78","v":338331.61911979644},{"$f":"$E85*F65/100","v":1868.9438640177555},null,{"$f":"$E85*H65/100","v":1868.9438640177555},null,{"$f":"H85-F85","v":0},null,{"$f":"J85/F85","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E85","v":338331.61911979644},{"$f":"$E86*F66/100","v":474.67926162507445},null,{"$f":"$E86*H66/100","v":628.20872487858844},null,{"$f":"H86-F86","v":153.529463253514},null,{"$f":"J86/F86","v":0.32343832070502226}]
[null,null,{"$f":"C67","v":"EFVA Rate Rider"},null,{"$f":"E85","v":338331.61911979644},{"$f":"$E87*F67/100","v":363.70649055378118},null,{"$f":"$E87*H67/100","v":0},null,{"$f":"H87-F87","v":-363.70649055378118},null,{"$f":"J87/F87","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E86","v":338331.61911979644},{"$f":"$E88*F68/100","v":335.62496616683808},null,{"$f":"$E88*H68/100","v":15330.01291616808},null,14994.387950001241,null,44.676020741995636]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,{"$f":"E88","v":338331.61911979644},{"$f":"$E89*F69/100","v":0},null,{"$f":"$E89*H69/100","v":-15415.741893574404},null,-15415.741893574404,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F85:F89)","v":3042.9545823634494},null,{"$f":"SUM(H85:H89)","v":2411.4236114900177},null,{"$f":"SUM(J85:J89)","v":-631.53097087343122},null,{"$f":"J90/F90","v":-0.20753874360586871}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F82+F90","v":183529.23008387178},null,{"$f":"H82+H90","v":184057.75547710757},null,{"$f":"J82+J90","v":528.52539323577321},null,{"$f":"J92/F92","v":2.879788647259296E-3}]

{"sheet":"G1.4 Rate 16 Bill Impact","index":16,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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":1575.7833749999998},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C10))","v":1607.7717775124997}]
[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":107.48305025999998},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C15))","v":109.66495618027798}]
[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":9.7899999999999991},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C21)+1)","v":9.7899999999999991}]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!E13","v":6.0100000000000001E-2},null,{"$f":"'F1.3 Rate Riders'!E12","v":6.0100000000000001E-2}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!E23","v":0},null,{"$f":"'F1.3 Rate Riders'!E21","v":0}]
[null,null,{"$f":"'C1.1 Current Rate Riders'!E35","v":"EFVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!E40","v":0.7964},null,0]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!E31","v":0.96030000000000004},null,{"$f":"'F1.3 Rate Riders'!E30","v":4.531061257605967}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!E16","v":0},null,{"$f":"'F1.3 Rate Riders'!E39","v":-4.5564}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E31","v":18909.400499999996},null,{"$f":"H10*$E31","v":19293.261330149995},null,{"$f":"H31-F31","v":383.86083014999895},null,{"$f":"J31/F31","v":2.029999999999995E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E31","v":12},{"$f":"$E32*F11","v":12},null,{"$f":"$E32*H11","v":12},null,0,null,0]
[null,null,"Tier 1",null,0,{"$f":"F12*$E33/100","v":0},null,{"$f":"H12*$E33/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 2",null,0,{"$f":"F13*$E34/100","v":0},null,{"$f":"H13*$E34/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 3",null,0,{"$f":"F14*$E35/100","v":0},null,{"$f":"H14*$E35/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,50000,{"$f":"F15*$E36/100*$E$31","v":644898.30155999993},null,{"$f":"H15*$E36/100*$E$31","v":657989.73708166799},null,13091.435521668056,null,2.0300000000000089E-2]
[null,null,"Gas Supply",null,0,{"$f":"F16*$E37/100","v":0},null,{"$f":"H16*$E37/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"$E$36","v":50000},{"$f":"F17*$E38/100*$E$31","v":85460.4},null,{"$f":"H17*$E38/100*$E$31","v":85460.4},null,0,null,0]
[null,null,"Transportation Charge From Dawn",null,{"$f":"$E$36","v":50000},{"$f":"F18*$E39/100*$E$31","v":109799.40000000001},null,{"$f":"H18*$E39/100*$E$31","v":109799.40000000001},null,0,null,0]
[null,null,"Transportation Charge \nFrom Kirkwall",null,0,{"$f":"F19*$E40/100*$E$31","v":0},null,{"$f":"H19*$E40/100*$E$31","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Transportation Charge From Parkway",null,0,{"$f":"F20*$E41/100*$E$31","v":0},null,{"$f":"H20*$E41/100*$E$31","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Federal Carbon Charge",null,{"$f":"$E$36","v":50000},{"$f":"$E42*F21/100*$E$31","v":58739.999999999985},null,{"$f":"$E42*H21/100*$E$31","v":58739.999999999985},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F31:F42)","v":917819.50205999997},null,{"$f":"SUM(H31:H42)","v":931294.79841181799},null,{"$f":"SUM(J31:J42)","v":13475.296351818055},null,1.4681858820360024E-2]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,{"$f":"E31","v":12},{"$f":"$E$46*$E36*$F24/100","v":360.6},null,{"$f":"$E$46*$E36*$H24/100","v":360.6},null,{"$f":"H46-F46","v":0},null,{"$f":"J46/F46","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E46","v":12},{"$f":"$E$46*$E42*$F25/100","v":0},null,{"$f":"$E$46*$E42*$H25/100","v":0},null,{"$f":"H47-F47","v":0},null,{"$f":"J47/F47","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'C1.1 Current Rate Riders'!E35","v":"EFVA Rate Rider"},null,{"$f":"E46","v":12},{"$f":"$E$46*$E38*$F26/100","v":4778.3999999999996},null,{"$f":"$E$46*$E37*$H26/100","v":0},null,{"$f":"H48-F48","v":-4778.3999999999996},null,{"$f":"J48/F48","v":-1}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E47","v":12},{"$f":"$E$46*$E38*$F27/100","v":5761.8},null,{"$f":"$E$46*$E38*$H27/100","v":27186.367545635803},null,21424.567545635804,null,3.7183809826158152]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"MTVA Rate Rider"},null,{"$f":"E49","v":12},{"$f":"$E$46*$E39*$F28/100","v":0},null,{"$f":"$E$46*$E39*$H28/100","v":-27338.400000000001},null,-27338.400000000001,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F46:F50)","v":10900.8},{"$f":"SUM(G46:G50)","v":0},208.56754563580034,0,-10692.232454364195,null,{"$f":"J51/F51","v":-0.98086676705968334}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F43+F51","v":928720.30206000002},null,{"$f":"H43+H51","v":931503.36595745385},null,{"$f":"J43+J51","v":2783.0638974538597},null,{"$f":"J53/F53","v":2.9966652944710364E-3}]

{"sheet":"G1.7 Summary of Bill Impacts","index":17,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:  EB-2022-0184  Exhibit A - 2023 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 Change",{"$f":"OneDollar","v":"Bill 32 Rate"},"Volumetric Change","Rate Riders","Upstream Recovery \nCharge","Transportation & \nStorage Charge","Federal Carbon Charge Change","Total Change","Total Change %"]
[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'!J31","v":6.3999561527999731},{"$f":"'G1.1 Rate 1 Bill Impact'!J32","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J33:J36)","v":12.150539803810545},{"$f":"'G1.1 Rate 1 Bill Impact'!J49","v":-6.6932983624304541},{"$f":"'G1.1 Rate 1 Bill Impact'!J38","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J39","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J40","v":0},{"$f":"SUM(E10:K10)","v":11.857197594180064},{"$f":"'G1.1 Rate 1 Bill Impact'!L51","v":6.092011376886107E-3}]
[null,null,"Rate 1","New Residential",{"$f":"'G1.1 Rate 1 Bill Impact'!J75","v":6.3999561527999731},{"$f":"'G1.1 Rate 1 Bill Impact'!J76","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J77:J78)","v":11.684685856264537},{"$f":"'G1.1 Rate 1 Bill Impact'!J93","v":-6.4347856755613435},{"$f":"'G1.1 Rate 1 Bill Impact'!J82","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J83","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J84","v":0},{"$f":"SUM(E11:K11)","v":11.649856333503166},{"$f":"'G1.1 Rate 1 Bill Impact'!L95","v":6.1836160096159568E-3}]
[null,null,"Rate 1","Small Commercial",{"$f":"'G1.1 Rate 1 Bill Impact'!J118","v":6.3999561527999731},{"$f":"'G1.1 Rate 1 Bill Impact'!J119","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J120:J123)","v":26.254417605151787},{"$f":"'G1.1 Rate 1 Bill Impact'!J136","v":-14.616867945503031},{"$f":"'G1.1 Rate 1 Bill Impact'!J125","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J126","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J127","v":0},18.037505812448728,{"$f":"'G1.1 Rate 1 Bill Impact'!L138","v":4.6859924160106816E-3}]
[null,null,"Rate 1","Small Agricultural",{"$f":"'G1.1 Rate 1 Bill Impact'!J161","v":6.3999561527999731},{"$f":"'G1.1 Rate 1 Bill Impact'!J162","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J163:J166)","v":26.402849593361452},{"$f":"'G1.1 Rate 1 Bill Impact'!J179","v":-14.70096243400269},{"$f":"'G1.1 Rate 1 Bill Impact'!J168","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J169","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J170","v":0},18.101843312158735,{"$f":"'G1.1 Rate 1 Bill Impact'!L181","v":4.6782366927626134E-3}]
[null,null,"Rate 6","Medium Commercial",{"$f":"'G1.2 Rate 6 Bill Impact'!J29","v":26.103777713999989},{"$f":"'G1.2 Rate 6 Bill Impact'!J30","v":0},{"$f":"SUM('G1.2 Rate 6 Bill Impact'!J31:J34)","v":132.96133257172824},{"$f":"'G1.2 Rate 6 Bill Impact'!J47","v":-404.61776400425947},{"$f":"'G1.2 Rate 6 Bill Impact'!J36","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J37","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J38","v":0},-245.55265371853125,{"$f":"'G1.2 Rate 6 Bill Impact'!L49","v":-1.1311195593603116E-2}]
[null,null,"Rate 6","Large Commercial",{"$f":"'G1.2 Rate 6 Bill Impact'!J73","v":26.103777713999989},{"$f":"'G1.2 Rate 6 Bill Impact'!J74","v":0},{"$f":"SUM('G1.2 Rate 6 Bill Impact'!J75:J78)","v":359.75064523454876},{"$f":"'G1.2 Rate 6 Bill Impact'!J91","v":-1137.0250424632372},{"$f":"'G1.2 Rate 6 Bill Impact'!J80","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J81","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J82","v":0},-751.1706195146885,{"$f":"'G1.2 Rate 6 Bill Impact'!L93","v":-1.2957703583892231E-2}]
[null,null,"Rate 11","Sample Dryer 1",{"$f":"'G1.3 Rate 11 Bill Impact'!J29","v":52.205072900399955},{"$f":"'G1.3 Rate 11 Bill Impact'!J30","v":0},{"$f":"SUM('G1.3 Rate 11 Bill Impact'!J31:J34)","v":332.35538736264061},{"$f":"'G1.3 Rate 11 Bill Impact'!J47","v":-189.45929126203009},{"$f":"'G1.3 Rate 11 Bill Impact'!J36","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J37","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J38","v":0},195.10116900101048,{"$f":"'G1.3 Rate 11 Bill Impact'!L49","v":3.1049506476372338E-3}]
[null,null,"Rate 11","Sample Dryer 2",{"$f":"'G1.3 Rate 11 Bill Impact'!J72","v":52.205072900399955},{"$f":"'G1.3 Rate 11 Bill Impact'!J73","v":0},{"$f":"SUM('G1.3 Rate 11 Bill Impact'!J74:J77)","v":1107.8512912088045},{"$f":"'G1.3 Rate 11 Bill Impact'!J90","v":-631.53097087343122},{"$f":"'G1.3 Rate 11 Bill Impact'!J79","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J80","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J81","v":0},528.52539323577321,{"$f":"'G1.3 Rate 11 Bill Impact'!L92","v":2.879788647259296E-3}]
[null,null,"Rate 16","Contracted Demand",{"$f":"'G1.4 Rate 16 Bill Impact'!J31","v":383.86083014999895},{"$f":"'G1.4 Rate 16 Bill Impact'!J32","v":0},{"$f":"SUM('G1.4 Rate 16 Bill Impact'!J33:J36)","v":13091.435521668056},{"$f":"'G1.4 Rate 16 Bill Impact'!J51","v":-10692.232454364195},{"$f":"'G1.4 Rate 16 Bill Impact'!J38","v":0},{"$f":"SUM('G1.4 Rate 16 Bill Impact'!J39:J41)","v":0},{"$f":"'G1.4 Rate 16 Bill Impact'!J42","v":0},2783.0638974538597,{"$f":"'G1.4 Rate 16 Bill Impact'!L53","v":2.9966652944710364E-3}]