{"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-2021-0216  Exhibit A - 2022 Custom Incentive Application"}]
[]
[null,null,"Distributor Information"]
[]
[null,null,"Distributor Name","EPCOR Natural Gas Limited Partnership"]
[null,null,"OEB Application Number","EB-2021-0216  Exhibit A - 2022 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-2021-0216  Exhibit A - 2022 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",25.78,1,27.620999999999999,27.076899999999998,26.277100000000001,null,11.250999999999999,1.474,2.6981999999999999,null,null,null,7.83]
[null,null,"Rate 6","Large Volume General Firm Service",105.15,1,25.481100000000001,22.933,21.786200000000001,null,11.250999999999999,2.92,5.6413000000000002,null,null,null,7.83]
[null,null,"Rate 11","Large Volume Seasonal Service",210.29,1,15.827999999999999,15.827999999999999,15.827999999999999,null,11.250999999999999,3.5200000000000002E-2,1.8166,null,null,null,7.83]
[null,null,"Rate 16","Contracted Firm Service",1546.25,1,null,null,null,105.4686,null,14.243399999999999,null,18.299900000000001,11.848000000000001,11.848000000000001,7.83]
[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-2021-0216  Exhibit A - 2022 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",3703,3438479,3192323,78289,null,6709090]
[null,null,"Rate 6","Large Volume General Firm Service",56,465406,1108352,242837,null,1816595]
[null,null,"Rate 11","Large Volume Seasonal Service",6,null,null,1595894,null,1595894]
[null,null,"Rate 16","Contracted Firm Service",2,null,null,null,89716,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-2021-0216  Exhibit A - 2022 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":1145560.08},{"$f":"'B1.1 Current Distribution Rates'!F10*'B1.2 Billing Determinants'!E9*$D$8","v":44436},{"$f":"'B1.2 Billing Determinants'!F9*'B1.1 Current Distribution Rates'!G10/100","v":949742.28458999994},{"$f":"'B1.2 Billing Determinants'!G9*'B1.1 Current Distribution Rates'!H10/100","v":864382.10638699995},{"$f":"'B1.2 Billing Determinants'!H9*'B1.1 Current Distribution Rates'!I10/100","v":20572.078819000002},{"$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":754839.71590000007},{"$f":"'B1.1 Current Distribution Rates'!L10*'B1.2 Billing Determinants'!$J9/100","v":98891.986600000004},{"$f":"'B1.1 Current Distribution Rates'!M10*'B1.2 Billing Determinants'!$J9/100","v":181024.66638000001},{"$f":"'B1.1 Current Distribution Rates'!Q10*'B1.2 Billing Determinants'!J9/100","v":525321.74699999997},{"$f":"SUM(E14:N14)","v":4584770.6656759996}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'B1.2 Billing Determinants'!E10*'B1.1 Current Distribution Rates'!E11*$D$8","v":70660.800000000003},{"$f":"'B1.1 Current Distribution Rates'!F11*'B1.2 Billing Determinants'!E10*$D$8","v":672},{"$f":"'B1.2 Billing Determinants'!F10*'B1.1 Current Distribution Rates'!G11/100","v":118590.568266},{"$f":"'B1.2 Billing Determinants'!G10*'B1.1 Current Distribution Rates'!H11/100","v":254178.36416},{"$f":"'B1.2 Billing Determinants'!H10*'B1.1 Current Distribution Rates'!I11/100","v":52904.954494000005},{"$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":204385.10345},{"$f":"'B1.1 Current Distribution Rates'!L11*'B1.2 Billing Determinants'!$J10/100","v":53044.573999999993},{"$f":"'B1.1 Current Distribution Rates'!M11*'B1.2 Billing Determinants'!$J10/100","v":102479.57373500001},{"$f":"'B1.1 Current Distribution Rates'!Q11*'B1.2 Billing Determinants'!J10/100","v":142239.3885},{"$f":"SUM(E15:N15)","v":999155.32660500007}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'B1.2 Billing Determinants'!E11*'B1.1 Current Distribution Rates'!E12*$D$8","v":15140.880000000001},{"$f":"'B1.1 Current Distribution Rates'!F12*'B1.2 Billing Determinants'!E11*$D$8","v":72},{"$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":252598.10232000001},{"$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":179554.03393999996},{"$f":"'B1.1 Current Distribution Rates'!L12*'B1.2 Billing Determinants'!$J11/100","v":561.75468799999999},{"$f":"'B1.1 Current Distribution Rates'!M12*'B1.2 Billing Determinants'!$J11/100","v":28991.010403999997},{"$f":"'B1.1 Current Distribution Rates'!Q12*'B1.2 Billing Determinants'!J11/100","v":124958.50019999999},{"$f":"SUM(E16:N16)","v":601876.28155199997}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'B1.2 Billing Determinants'!E12*'B1.1 Current Distribution Rates'!E13*$D$8","v":37110},{"$f":"'B1.1 Current Distribution Rates'!F13*'B1.2 Billing Determinants'!E12*$D$8","v":24},{"$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":1135466.5101120002},{"$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":153343.30492799997},{"$f":"'B1.1 Current Distribution Rates'!N13*'B1.2 Billing Determinants'!$I12/100*$D$8","v":197015.25940799998},{"$f":"'B1.1 Current Distribution Rates'!Q13*'B1.2 Billing Determinants'!I12/100*D8","v":84297.153600000005},{"$f":"SUM(E17:N17)","v":1607256.2280480003}]
[null,null,"Total Revenue",null,{"$f":"SUM(E14:E17)","v":1268471.76},45204,1068332.852856,1118560.4705469999,326075.135633,1135466.5101120002,1138778.85329,305841.62021599995,509510.50992700004,876816.78929999995,7793058.5018809997]
[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":13,"n_cols":6,"rows_kept":13,"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-2021-0216  Exhibit A - 2022 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,"$/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service","cents / m3 volume",0.90900000000000003,"$/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service","cents / m3 volume",0.5524,"$/m3"]
[null,null,"Rate 16 | Contracted Firm Service","cents / contracted demand / month",6.0100000000000001E-2,"$/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-2021-0216  Exhibit A - 2022 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,1.9099999999999999E-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":25.78},{"$f":"$E$13","v":1.9099999999999999E-2},{"$f":"E17*(1+F17)","v":26.272397999999999},{"$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":3703},{"$f":"G17*H17*$E$14","v":1167440.2775279998}]
[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":3703},{"$f":"G18*H18*$E$14","v":44436}]
[null,null,"Tier 1","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!G10","v":27.620999999999999},{"$f":"$E$13","v":1.9099999999999999E-2},{"$f":"E19*(1+F19)","v":28.148561099999995},{"$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":3438479},{"$f":"G19*H19/100","v":967882.36222566885}]
[null,null,"Tier 2","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!H10","v":27.076899999999998},{"$f":"$E$13","v":1.9099999999999999E-2},27.594068789999994,{"$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":3192323},{"$f":"G20*H20/100","v":880891.80461899145}]
[null,null,"Tier 3","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!I10","v":26.277100000000001},{"$f":"$E$13","v":1.9099999999999999E-2},26.77899261,{"$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":78289},20965.005524442899]
[null,null,"Contract Demand","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!J10","v":0},{"$f":"$E$13","v":1.9099999999999999E-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":11.250999999999999},0,11.250999999999999,{"$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":6709090},754839.71590000007]
[null,null,"Upstream Recovery \nCharge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!L10","v":1.474},0,1.474,{"$f":"H23","v":6709090},98891.986600000004]
[null,null,"Transportation & \nStorage Charge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!M10","v":2.6981999999999999},0,2.6981999999999999,{"$f":"H24","v":6709090},181024.66638000001]
[null,null,"Federal Carbon Charge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!Q10","v":7.83},0,7.83,{"$f":"H25","v":6709090},{"$f":"G26*H26/100","v":525321.74699999997}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":4641693.5657771025}]

{"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-2021-0216  Exhibit A - 2022 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":1.9099999999999999E-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":105.15},{"$f":"$E$13","v":1.9099999999999999E-2},{"$f":"E17*(1+F17)","v":107.15836499999999},{"$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":56},{"$f":"G17*H17*12","v":72010.421279999995}]
[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":56},{"$f":"G18*H18*12","v":672}]
[null,null,"Tier 1","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!G11","v":25.481100000000001},{"$f":"$E$13","v":1.9099999999999999E-2},{"$f":"E19*(1+F19)","v":25.967789009999997},{"$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":465406},{"$f":"G19*H19/100","v":120855.6481198806}]
[null,null,"Tier 2","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!H11","v":22.933},{"$f":"$E$13","v":1.9099999999999999E-2},23.371020299999998,{"$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":1108352},{"$f":"G20*H20/100","v":259033.17091545596}]
[null,null,"Tier 3","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!I11","v":21.786200000000001},{"$f":"$E$13","v":1.9099999999999999E-2},22.202316419999999,{"$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":242837},53915.439124835393]
[null,null,"Contract Demand","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!J11","v":0},{"$f":"$E$13","v":1.9099999999999999E-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":11.250999999999999},0,11.250999999999999,{"$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":1816595},204385.10345]
[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":1816595},53044.573999999993]
[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":1816595},102479.57373500001]
[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":7.83},0,7.83,{"$f":"H25","v":1816595},142239.3885]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":1008635.319125172}]

{"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-2021-0216  Exhibit A - 2022 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":1.9099999999999999E-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":210.29},{"$f":"$E$13","v":1.9099999999999999E-2},{"$f":"E17*(1+F17)","v":214.30653899999996},{"$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":6},{"$f":"G17*H17*12","v":15430.070807999997}]
[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":6},{"$f":"G18*H18*12","v":72}]
[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":15.827999999999999},{"$f":"$E$13","v":1.9099999999999999E-2},16.130314799999997,{"$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":15.827999999999999},{"$f":"$E$13","v":1.9099999999999999E-2},16.130314799999997,{"$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":15.827999999999999},{"$f":"$E$13","v":1.9099999999999999E-2},16.130314799999997,{"$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":1595894},257422.72607431197]
[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":1.9099999999999999E-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":11.250999999999999},0,11.250999999999999,{"$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":1595894},179554.03393999996]
[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":1595894},561.75468799999999]
[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":1595894},28991.010403999997]
[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":7.83},0,7.83,{"$f":"H25","v":1595894},124958.50019999999]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":606990.09611431195}]

{"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-2021-0216  Exhibit A - 2022 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":1.9099999999999999E-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":1546.25},{"$f":"$E$13","v":1.9099999999999999E-2},{"$f":"E17*(1+F17)","v":1575.7833749999998},{"$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":2},{"$f":"G17*H17*$E$14","v":37818.800999999992}]
[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":2},{"$f":"G18*H18*$E$14","v":24}]
[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},1.9099999999999999E-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},1.9099999999999999E-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},1.9099999999999999E-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":105.4686},1.9099999999999999E-2,107.48305025999998,{"$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":89716},{"$f":"G22*H22/100*$E$14","v":1157153.9204551389}]
[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":89716},{"$f":"G24*H24/100*$E$14","v":153343.304928}]
[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":89716},{"$f":"G25*H25/100*$E$14","v":197015.25940799998}]
[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":7.83},0,7.83,{"$f":"H25","v":89716},{"$f":"G28*H28/100*$E$14","v":84297.153600000005}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I28)","v":1629652.439391139}]

{"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-2021-0216  Exhibit A - 2022 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.272397999999999},{"$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.148561099999995},{"$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":27.594068789999994},{"$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":26.77899261},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":11.250999999999999},{"$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":7.83}]
[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":107.15836499999999},{"$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":25.967789009999997},{"$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.371020299999998},{"$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.202316419999999},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":11.250999999999999},{"$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":7.83}]
[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":214.30653899999996},{"$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.130314799999997},{"$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.130314799999997},{"$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.130314799999997},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":11.250999999999999},{"$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":7.83}]
[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":1575.7833749999998},{"$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":107.48305025999998},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":7.83}]
[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-2021-0216  Exhibit A - 2022 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":3703},{"$f":"'B1.2 Billing Determinants'!F9","v":3438479},{"$f":"'B1.2 Billing Determinants'!G9","v":3192323},{"$f":"'B1.2 Billing Determinants'!H9","v":78289},{"$f":"'B1.2 Billing Determinants'!I9","v":0},{"$f":"'B1.2 Billing Determinants'!J9","v":6709090}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'B1.2 Billing Determinants'!E10","v":56},{"$f":"'B1.2 Billing Determinants'!F10","v":465406},{"$f":"'B1.2 Billing Determinants'!G10","v":1108352},{"$f":"'B1.2 Billing Determinants'!H10","v":242837},{"$f":"'B1.2 Billing Determinants'!I10","v":0},{"$f":"'B1.2 Billing Determinants'!J10","v":1816595}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'B1.2 Billing Determinants'!E11","v":6},{"$f":"'B1.2 Billing Determinants'!F11","v":0},{"$f":"'B1.2 Billing Determinants'!G11","v":0},{"$f":"'B1.2 Billing Determinants'!H11","v":1595894},{"$f":"'B1.2 Billing Determinants'!I11","v":0},{"$f":"'B1.2 Billing Determinants'!J11","v":1595894}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'B1.2 Billing Determinants'!E12","v":2},{"$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":89716},{"$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-2021-0216  Exhibit A - 2022 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":1167440.2775279998},{"$f":"'E1.1 Proposed Dist Rates '!F10*'E1.2 Billing Determinants'!E11*$D$7","v":44436},{"$f":"'E1.1 Proposed Dist Rates '!G10*'E1.2 Billing Determinants'!F11/100","v":967882.36222566885},{"$f":"'E1.1 Proposed Dist Rates '!H10*'E1.2 Billing Determinants'!G11/100","v":880891.80461899145},{"$f":"'E1.1 Proposed Dist Rates '!I10*'E1.2 Billing Determinants'!H11/100","v":20965.005524442899},{"$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":754839.71590000007},{"$f":"'E1.1 Proposed Dist Rates '!L10*'E1.2 Billing Determinants'!$J11/100","v":98891.986600000004},{"$f":"'E1.1 Proposed Dist Rates '!M10*'E1.2 Billing Determinants'!$J11/100","v":181024.66638000001},{"$f":"'E1.1 Proposed Dist Rates '!Q10*'E1.2 Billing Determinants'!J11/100","v":525321.74699999997},{"$f":"SUM(E11:N11)","v":4641693.5657771025}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E11*'E1.2 Billing Determinants'!E12*$D$7","v":72010.421279999995},{"$f":"'E1.1 Proposed Dist Rates '!F11*'E1.2 Billing Determinants'!E12*$D$7","v":672},{"$f":"'E1.1 Proposed Dist Rates '!G11*'E1.2 Billing Determinants'!F12/100","v":120855.6481198806},{"$f":"'E1.1 Proposed Dist Rates '!H11*'E1.2 Billing Determinants'!G12/100","v":259033.17091545596},{"$f":"'E1.1 Proposed Dist Rates '!I11*'E1.2 Billing Determinants'!H12/100","v":53915.439124835393},{"$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":204385.10345},{"$f":"'E1.1 Proposed Dist Rates '!L11*'E1.2 Billing Determinants'!$J12/100","v":53044.573999999993},{"$f":"'E1.1 Proposed Dist Rates '!M11*'E1.2 Billing Determinants'!$J12/100","v":102479.57373500001},{"$f":"'E1.1 Proposed Dist Rates '!Q11*'E1.2 Billing Determinants'!J12/100","v":142239.3885},{"$f":"SUM(E12:N12)","v":1008635.319125172}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'E1.1 Proposed Dist Rates '!E12*'E1.2 Billing Determinants'!E13*$D$7","v":15430.070807999997},{"$f":"'E1.1 Proposed Dist Rates '!F12*'E1.2 Billing Determinants'!E13*$D$7","v":72},{"$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":257422.72607431197},{"$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":179554.03393999996},{"$f":"'E1.1 Proposed Dist Rates '!L12*'E1.2 Billing Determinants'!$J13/100","v":561.75468799999999},{"$f":"'E1.1 Proposed Dist Rates '!M12*'E1.2 Billing Determinants'!$J13/100","v":28991.010403999997},{"$f":"'E1.1 Proposed Dist Rates '!Q12*'E1.2 Billing Determinants'!J13/100","v":124958.50019999999},{"$f":"SUM(E13:N13)","v":606990.09611431195}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E13*'E1.2 Billing Determinants'!E14*$D$7","v":37818.800999999992},{"$f":"'E1.1 Proposed Dist Rates '!F13*'E1.2 Billing Determinants'!E14*$D$7","v":24},{"$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":1157153.9204551389},{"$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":153343.304928},{"$f":"'E1.1 Proposed Dist Rates '!N13*'E1.2 Billing Determinants'!$I14/100*$D$7","v":197015.25940799998},{"$f":"'E1.1 Proposed Dist Rates '!Q13*'E1.2 Billing Determinants'!I14/100*$D$7","v":84297.153600000005},{"$f":"SUM(E14:N14)","v":1629652.439391139}]
[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":7886971.4204077255}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Revenue",{"$f":"'B1.3 Current Rev From Rates'!O18","v":7793058.5018809997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change",{"$f":"O15-O16","v":93912.918526725844}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"% Change",{"$f":"O17/O16","v":1.2050842234028939E-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-2021-0216  Exhibit A - 2022 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"]
[]
[]
[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.55769999999999997,"Cents/m3"]
[null,null,"Rate 6 | Large Volume General Firm Service",null,0.70909999999999995,"Cents/m3"]
[null,null,"Rate 11 | Large Volume Seasonal Service",null,0.1153,"Cents/m3"]
[null,null,"Rate 16 | Contracted Firm Service",null,0.85470000000000002,"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":"G1.1 Rate 1 Bill Impact","index":13,"n_rows":173,"n_cols":12,"rows_kept":173,"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-2021-0216  Exhibit A - 2022 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":25.78},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.272397999999999}]
[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":27.620999999999999},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.148561099999995}]
[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.076899999999998},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":27.594068789999994}]
[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.277100000000001},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":26.77899261}]
[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":11.250999999999999},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":11.250999999999999}]
[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":7.83},null,{"$f":"'E1.1 Proposed Dist Rates '!Q10","v":7.83}]
[]
[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",0,null,{"$f":"'F1.3 Rate Riders'!E18","v":0.14030000000000001}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",0,null,{"$f":"'F1.3 Rate Riders'!E27","v":0.55769999999999997}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,"₵/m3",0,null,{"$f":"'F1.3 Rate Riders'!E36","v":0.51970000000000005}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F12*$E30","v":309.36},null,{"$f":"H12*$E30","v":315.268776},null,{"$f":"H30-F30","v":5.9087759999999889},null,{"$f":"J30/F30","v":1.9099999999999964E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"F13*$E31","v":12},null,{"$f":"H13*$E31","v":12},null,{"$f":"H31-F31","v":0},null,{"$f":"J31/F31","v":0}]
[null,null,"First 100 m3",null,1001.3160527512506,{"$f":"F14*$E32/100","v":276.57350693042292},null,{"$f":"H14*$E32/100","v":281.85606091279396},null,{"$f":"H32-F32","v":5.2825539823710415},null,{"$f":"J32/F32","v":1.9099999999999867E-2}]
[null,null,"Next 400 m3",null,1147.6839472487493,310.75723471259658,null,316.69269789560713,null,5.9354631830105404,null,1.9099999999999825E-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(E32:E35)","v":2149},241.78398999999999,null,241.78398999999999,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E36","v":2149},31.676259999999999,null,31.676259999999999,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E37","v":2149},57.984318000000002,null,57.984318000000002,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E36","v":2149},168.26670000000001,null,168.26670000000001,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F30:F39)","v":1408.4020096430195},null,{"$f":"SUM(H30:H39)","v":1425.528802808401},null,{"$f":"SUM(J30:J39)","v":17.126793165381571},null,{"$f":"J40/F40","v":1.2160443572302636E-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":"E36","v":2149},{"$f":"$E43*F24/100","v":35.093170000000001},null,{"$f":"$E43*H24/100","v":35.093170000000001},null,{"$f":"H43-F43","v":0},null,{"$f":"J43/F43","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E43","v":2149},{"$f":"$E44*F25/100","v":0},null,{"$f":"$E44*H25/100","v":3.015047},null,{"$f":"H44-F44","v":3.015047},null,{"$f":"J44/F44","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E44","v":2149},0,null,11.984973,null,11.984973,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,2149,0,null,11.168353000000002,null,11.168353000000002,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F43:F46)","v":35.093170000000001},null,{"$f":"SUM(H43:H46)","v":61.26154300000001},null,{"$f":"SUM(J43:J46)","v":26.168373000000003},null,{"$f":"J47/F47","v":0.74568279240661361}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F40+F47","v":1443.4951796430196},null,{"$f":"H40+H47","v":1486.7903458084011},null,{"$f":"J40+J47","v":43.295166165381573},null,{"$f":"J49/F49","v":2.9993287664520356E-2}]
[]
[]
[null,null,"Rate 1 - New Residential",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F12","v":25.78},null,{"$f":"H12","v":26.272397999999999}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",27.620999999999999,null,28.148561099999995]
[null,null,"Next 400 m3",null,"₵/m3",27.076899999999998,null,27.594068789999994]
[null,null,"GT 500m3",null,"₵/m3",26.277100000000001,null,26.77899261]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.250999999999999,null,11.250999999999999]
[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",7.83,null,7.83]
[]
[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},null,{"$f":"H25","v":0.14030000000000001}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",0,null,0.55769999999999997]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,"₵/m3",0,null,0.51970000000000005]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F54*$E72","v":309.36},null,{"$f":"H54*$E72","v":315.268776},null,{"$f":"H72-F72","v":5.9087759999999889},null,{"$f":"J72/F72","v":1.9099999999999964E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E72","v":12},{"$f":"F55*$E73","v":12},null,{"$f":"H55*$E73","v":12},null,{"$f":"H73-F73","v":0},null,{"$f":"J73/F73","v":0}]
[null,null,"First 100 m3",null,993.12960436562071,{"$f":"F56*$E74/100","v":274.31232802182808},null,{"$f":"H56*$E74/100","v":279.55169348704499},null,{"$f":"H74-F74","v":5.2393654652169062},null,{"$f":"J74/F74","v":1.9099999999999964E-2}]
[null,null,"Next 400 m3",null,1072.8703956343793,290.50004415552525,null,296.04859499889574,null,5.5485508433704922,null,1.9099999999999864E-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(E74:E77)","v":2066},232.44565999999998,null,232.44565999999998,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E78","v":2066},30.452840000000002,null,30.452840000000002,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E79","v":2066},55.744812000000003,null,55.744812000000003,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E78","v":2066},161.76779999999999,null,161.76779999999999,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F72:F81)","v":1366.5834841773531},null,{"$f":"SUM(H72:H81)","v":1383.2801764859405},null,{"$f":"SUM(J72:J81)","v":16.696692308587387},null,{"$f":"J82/F82","v":1.2217835574559393E-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":"E78","v":2066},{"$f":"$E85*F66/100","v":33.737780000000001},null,{"$f":"$E85*H66/100","v":33.737780000000001},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":2066},{"$f":"$E86*F67/100","v":0},null,{"$f":"$E86*H67/100","v":2.8985980000000002},null,{"$f":"H86-F86","v":2.8985980000000002},null,{"$f":"J86/F86","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E86","v":2066},0,null,11.522082000000001,null,11.522082000000001,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,2066,0,null,10.737002,null,10.737002,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F85:F88)","v":33.737780000000001},null,{"$f":"SUM(H85:H88)","v":58.895462000000009},null,{"$f":"SUM(J85:J88)","v":25.157682000000001},null,{"$f":"J89/F89","v":0.74568279240661361}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F82+F89","v":1400.321264177353},null,{"$f":"H82+H89","v":1442.1756384859405},null,{"$f":"J82+J89","v":41.854374308587388},null,{"$f":"J91/F91","v":2.9889122860085673E-2}]
[]
[null,null,"Rate 1 - Small Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F54","v":25.78},null,{"$f":"H54","v":26.272397999999999}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",27.620999999999999,null,28.148561099999995]
[null,null,"Next 400 m3",null,"₵/m3",27.076899999999998,null,27.594068789999994]
[null,null,"GT 500m3",null,"₵/m3",26.277100000000001,null,26.77899261]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.250999999999999,null,11.250999999999999]
[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",7.83,null,7.83]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F66","v":1.633},null,{"$f":"H66","v":1.633}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m4",{"$f":"F67","v":0},null,{"$f":"H67","v":0.14030000000000001}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m5",0,null,0.55769999999999997]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,"₵/m6",0,null,0.51970000000000005]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F95*$E113","v":309.36},null,{"$f":"H95*$E113","v":315.268776},null,{"$f":"H113-F113","v":5.9087759999999889},null,{"$f":"J113/F113","v":1.9099999999999964E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E113","v":12},{"$f":"F96*$E114","v":12},null,{"$f":"H96*$E114","v":12},null,{"$f":"H114-F114","v":0},null,{"$f":"J114/F114","v":0}]
[null,null,"First 100 m3",null,1198.1709868121873,{"$f":"F97*$E115/100","v":330.9468082673942},null,{"$f":"H97*$E115/100","v":337.26789230530142},null,{"$f":"H115-F115","v":6.3210840379072124},null,{"$f":"J115/F115","v":1.909999999999995E-2}]
[null,null,"Next 400 m3",null,2475.0040927694408,670.15438319508871,null,682.95433191411473,null,12.79994871902602,null,1.9099999999999739E-2]
[null,null,"GT 500m3",null,1019.8249204183721,267.98041416325606,null,273.09884007377428,null,5.1184259105182264,null,1.9100000000000134E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E115:E118)","v":4693},528.00942999999995,null,528.00942999999995,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E119","v":4693},69.174819999999997,null,69.174819999999997,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E120","v":4693},126.626526,null,126.626526,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E119","v":4693},367.46190000000001,null,367.46190000000001,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F113:F122)","v":2681.7142816257392},null,{"$f":"SUM(H113:H122)","v":2711.8625162931903},null,{"$f":"SUM(J113:J122)","v":30.148234667451447},null,{"$f":"J123/F123","v":1.1242150170142153E-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":"E119","v":4693},{"$f":"$E126*F107/100","v":76.636690000000002},null,{"$f":"$E126*H107/100","v":76.636690000000002},null,{"$f":"H126-F126","v":0},null,{"$f":"J126/F126","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E126","v":4693},{"$f":"$E127*F108/100","v":0},null,{"$f":"$E127*H108/100","v":6.5842790000000004},null,{"$f":"H127-F127","v":6.5842790000000004},null,{"$f":"J127/F127","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E127","v":4693},0,null,26.172860999999997,null,26.172860999999997,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,4693,0,null,24.389521000000006,null,24.389521000000006,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F126:F129)","v":76.636690000000002},null,{"$f":"SUM(H126:H129)","v":133.78335100000001},null,{"$f":"SUM(J126:J129)","v":57.146661000000009},null,{"$f":"J130/F130","v":0.74568279240661373}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F123+F130","v":2758.350971625739},null,{"$f":"H123+H130","v":2845.6458672931903},null,{"$f":"J123+J130","v":87.294895667451456},null,{"$f":"J132/F132","v":3.1647493943093429E-2}]
[]
[null,null,"Rate 1 - Small Agricultural",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F95","v":25.78},null,{"$f":"H95","v":26.272397999999999}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",{"$f":"F97","v":27.620999999999999},null,{"$f":"H97","v":28.148561099999995}]
[null,null,"Next 400 m3",null,"₵/m3",27.076899999999998,null,27.594068789999994]
[null,null,"GT 500m3",null,"₵/m3",26.277100000000001,null,26.77899261]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.250999999999999,null,11.250999999999999]
[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",7.83,null,7.83]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F107","v":1.633},null,{"$f":"H107","v":1.633}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,"₵/m4",{"$f":"F108","v":0},null,{"$f":"H108","v":0.14030000000000001}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m5",0,null,0.55769999999999997]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,"₵/m6",0,null,0.51970000000000005]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F136*$E154","v":309.36},null,{"$f":"H136*$E154","v":315.268776},null,{"$f":"H154-F154","v":5.9087759999999889},null,{"$f":"J154/F154","v":1.9099999999999964E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E154","v":12},{"$f":"F137*$E155","v":12},null,{"$f":"H137*$E155","v":12},null,{"$f":"H155-F155","v":0},null,{"$f":"J155/F155","v":0}]
[null,null,"First 100 m3",null,1198.7357889949976,{"$f":"F138*$E156/100","v":331.10281227830825},null,{"$f":"H138*$E156/100","v":337.42687599282391},null,{"$f":"H156-F156","v":6.3240637145156597},null,{"$f":"J156/F156","v":1.9099999999999916E-2}]
[null,null,"Next 400 m3",null,2484.0654843110506,672.60792712141881,null,685.45473852943769,null,12.84681140801888,null,1.9099999999999673E-2]
[null,null,"GT 500m3",null,1037.1987266939518,272.54574661209642,null,277.75137037238744,null,5.2056237602910187,null,1.9099999999999916E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Commodity",null,{"$f":"SUM(E156:E159)","v":4720},531.04719999999998,null,531.04719999999998,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E160","v":4720},69.572800000000001,null,69.572800000000001,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E161","v":4720},127.35503999999999,null,127.35503999999999,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E160","v":4720},369.57599999999996,null,369.57599999999996,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F154:F163)","v":2695.1675260118236},null,{"$f":"SUM(H154:H163)","v":2725.452800894649},null,{"$f":"SUM(J154:J163)","v":30.285274882825547},null,{"$f":"J164/F164","v":1.1236880301700655E-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":"E160","v":4720},{"$f":"$E167*F148/100","v":77.077600000000004},null,{"$f":"$E167*H148/100","v":77.077600000000004},null,{"$f":"H167-F167","v":0},null,{"$f":"J167/F167","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E167","v":4720},{"$f":"$E168*F149/100","v":0},null,{"$f":"$E168*H149/100","v":6.62216},null,{"$f":"H168-F168","v":6.62216},null,{"$f":"J168/F168","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E168","v":4720},0,null,26.323440000000002,null,26.323440000000002,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,4720,0,null,24.529840000000004,null,24.529840000000004,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F167:F170)","v":77.077600000000004},null,{"$f":"SUM(H167:H170)","v":134.55304000000001},null,{"$f":"SUM(J167:J170)","v":57.475440000000006},null,{"$f":"J171/F171","v":0.74568279240661361}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F164+F171","v":2772.2451260118237},null,{"$f":"H164+H171","v":2860.0058408946488},null,{"$f":"J164+J171","v":87.760714882825553},null,{"$f":"J173/F173","v":3.1656910155372475E-2}]

{"sheet":"G1.2 Rate 6 Bill Impact","index":14,"n_rows":89,"n_cols":12,"rows_kept":89,"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-2021-0216  Exhibit A - 2022 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":105.15},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C10))","v":107.15836499999999}]
[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.481100000000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C12))","v":25.967789009999997}]
[null,null,"Next 6000 m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C13))","v":22.933},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C13))","v":23.371020299999998}]
[null,null,"GT 7000m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C14))","v":21.786200000000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C14))","v":22.202316419999999}]
[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":11.250999999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C16))","v":11.250999999999999}]
[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":7.83},null,{"$f":"'E1.1 Proposed Dist Rates '!Q11","v":7.83}]
[]
[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,0,null,{"$f":"'F1.3 Rate Riders'!$E$19","v":0.14030000000000001}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,null,0,null,{"$f":"'F1.3 Rate Riders'!$E$28","v":0.70909999999999995}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,null,0,null,{"$f":"'F1.3 Rate Riders'!$E$37","v":0.66080000000000005}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E28","v":1261.8000000000002},null,{"$f":"H10*$E28","v":1285.9003799999998},null,{"$f":"H28-F28","v":24.100379999999632},null,{"$f":"J28/F28","v":1.9099999999999704E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E28","v":12},{"$f":"E29*F11","v":12},null,{"$f":"E29*H11","v":12},null,0,null,0]
[null,null,"First 1000 m3",null,9831.5433379437527,{"$f":"F12*$E30/100","v":2505.1853894847859},null,{"$f":"H12*$E30/100","v":2553.0344304239447},null,47.84904093915884,null,1.9099999999999773E-2]
[null,null,"Next 6000 m3",null,17101.456662056247,3921.877056309359,null,3996.7849080848678,null,74.907851775508789,null,1.9100000000000009E-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(E30:E33)","v":26933},3030.2318299999997,null,3030.2318299999997,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E34","v":26933},786.44360000000006,null,786.44360000000006,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E35","v":26933},1519.3713290000001,null,1519.3713290000001,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E36","v":26933},2108.8539000000001,null,2108.8539000000001,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F28:F37)","v":15145.763104794145},null,{"$f":"SUM(H28:H37)","v":15292.620377508812},null,{"$f":"SUM(J28:J37)","v":146.85727271466726},null,9.6962610400384494E-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":"E34","v":26933},{"$f":"$E41*F22/100","v":244.82097000000002},null,{"$f":"$E41*H22/100","v":244.82097000000002},null,{"$f":"H41-F41","v":0},null,{"$f":"J41/F41","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E41","v":26933},{"$f":"$E42*F23/100","v":0},null,{"$f":"$E42*H23/100","v":37.786999000000002},null,{"$f":"H42-F42","v":37.786999000000002},null,{"$f":"J42/F42","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E42","v":26933},0,null,190.98190299999999,null,190.98190299999999,null,{"$f":"J43/F43","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,26933,0,null,177.97326400000003,null,177.97326400000003,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F41:F44)","v":244.82097000000002},null,{"$f":"SUM(H41:H44)","v":651.56313599999999},null,{"$f":"SUM(J41:J44)","v":406.742166},null,{"$f":"J45/F45","v":1.6613861386138613}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F38+F45","v":15390.584074794146},null,{"$f":"H38+H45","v":15944.183513508813},null,{"$f":"J38+J45","v":553.59943871466726},null,{"$f":"J47/F47","v":3.5970008417115375E-2}]
[]
[]
[null,null,"Rate 6 - Medium Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F10","v":105.15},null,{"$f":"H10","v":107.15836499999999}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 1000 m3",null,"₵/m3",25.481100000000001,null,25.967789009999997]
[null,null,"Next 6000 m3",null,"₵/m3",22.933,null,23.371020299999998]
[null,null,"GT 7000m3",null,"₵/m3",21.786200000000001,null,22.202316419999999]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.250999999999999,null,11.250999999999999]
[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",7.83,null,7.83]
[]
[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,0,null,{"$f":"'F1.3 Rate Riders'!$E$19","v":0.14030000000000001}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,null,0,null,{"$f":"'F1.3 Rate Riders'!$E$28","v":0.70909999999999995}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,null,0,null,{"$f":"'F1.3 Rate Riders'!$E$37","v":0.66080000000000005}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F52*$E70","v":1261.8000000000002},null,{"$f":"H52*$E70","v":1285.9003799999998},null,{"$f":"H70-F70","v":24.100379999999632},null,{"$f":"J70/F70","v":1.9099999999999704E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"E71*F53","v":12},null,{"$f":"E71*H53","v":12},null,{"$f":"H71-F71","v":0},null,{"$f":"J71/F71","v":0}]
[null,null,"First 1000 m3",null,11715.326187183033,{"$f":"F54*$E72/100","v":2985.1939810822955},null,{"$f":"H54*$E72/100","v":3042.2111861209669},null,{"$f":"H72-F72","v":57.017205038671364},null,{"$f":"J72/F72","v":1.9099999999999839E-2}]
[null,null,"Next 6000 m3",null,40792.718418626093,9354.9941149435217,null,9533.6745025389428,null,178.68038759542105,null,1.9099999999999978E-2]
[null,null,"GT 7000m3",null,23176.955394190867,5049.3778560892106,null,5145.8209731405141,null,96.443117051303489,null,1.9099999999999916E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E72:E75)","v":75685},8515.3193499999998,null,8515.3193499999998,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E76","v":75685},2210.002,null,2210.002,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E77","v":75685},4269.6179050000001,null,4269.6179050000001,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E78","v":75685},5926.1355000000003,null,5926.1355000000003,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F70:F79)","v":39584.440707115034},null,{"$f":"SUM(H70:H79)","v":39940.681796800418},null,{"$f":"SUM(J70:J79)","v":356.24108968539554},null,{"$f":"J80/F80","v":8.9995231288278275E-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":"E76","v":75685},{"$f":"$E83*F64/100","v":687.97665000000006},null,{"$f":"$E83*H64/100","v":687.97665000000006},null,{"$f":"H83-F83","v":0},null,{"$f":"J83/F83","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!E16","v":"ECVA Rate Rider"},null,{"$f":"E83","v":75685},{"$f":"$E84*F65/100","v":0},null,{"$f":"$E84*H65/100","v":106.18605500000001},null,{"$f":"H84-F84","v":106.18605500000001},null,{"$f":"J84/F84","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!E25","v":"CIACVA Rate Rider"},null,{"$f":"E84","v":75685},0,null,536.68233499999997,null,536.68233499999997,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"'F1.3 Rate Riders'!E34","v":"EFVA Rate Rider"},null,75685,0,null,500.12648000000002,null,500.12648000000002,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F83:F86)","v":687.97665000000006},null,{"$f":"SUM(H83:H86)","v":1830.9715200000001},null,{"$f":"SUM(J83:J86)","v":1142.99487},null,{"$f":"J87/F87","v":1.6613861386138613}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F80+F87","v":40272.417357115031},null,{"$f":"H80+H87","v":41771.653316800417},null,{"$f":"J80+J87","v":1499.2359596853955},null,{"$f":"J89/F89","v":3.7227364485994077E-2}]

{"sheet":"G1.3 Rate 11 Bill Impact","index":15,"n_rows":88,"n_cols":12,"rows_kept":88,"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-2021-0216  Exhibit A - 2022 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":210.29},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C10:C$10))","v":214.30653899999996}]
[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":15.827999999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C12))","v":16.130314799999997}]
[null,null,"Tier 2",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C13))","v":15.827999999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C13))","v":16.130314799999997}]
[null,null,"Tier 3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C14))","v":15.827999999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C14))","v":16.130314799999997}]
[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":11.250999999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C16))","v":11.250999999999999}]
[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":7.83},null,{"$f":"'E1.1 Proposed Dist Rates '!Q12","v":7.83}]
[]
[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",0,null,{"$f":"'F1.3 Rate Riders'!E20","v":0.14030000000000001}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",0,null,{"$f":"'F1.3 Rate Riders'!E29","v":0.1153}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,"₵/m3",0,null,{"$f":"'F1.3 Rate Riders'!E38","v":0.1075}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E28","v":2523.48},null,{"$f":"H10*$E28","v":2571.6784679999996},null,{"$f":"H28-F28","v":48.198467999999593},null,{"$f":"J28/F28","v":1.9099999999999839E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"$E29*F11","v":12},null,{"$f":"$E29*H11","v":12},null,0,null,0]
[null,null,"All Volumes",null,101499.48573593894,{"$f":"F12*$E30/100","v":16065.338602284413},null,{"$f":"H12*$E30/100","v":16372.186569588044},null,306.84796730363087,null,1.9099999999999912E-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(E30:E33)","v":101499.48573593894},11419.707140150489,null,11419.707140150489,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E34","v":101499.48573593894},35.727818979050511,null,35.727818979050511,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E35","v":101499.48573593894},1843.8396578790669,null,1843.8396578790669,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E36","v":101499.48573593894},{"$f":"$E37*F19/100","v":7947.4097331240191},null,{"$f":"$E37*H19/100","v":7947.4097331240191},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F28:F37)","v":39847.502952417039},null,{"$f":"SUM(H28:H37)","v":40202.549387720675},null,{"$f":"SUM(J28:J37)","v":355.04643530363046},null,8.9101300959209626E-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":"E34","v":101499.48573593894},{"$f":"$E41*F22/100","v":560.68315920532677},null,{"$f":"$E41*H22/100","v":560.68315920532677},null,{"$f":"H41-F41","v":0},null,{"$f":"J41/F41","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E41","v":101499.48573593894},{"$f":"$E42*F23/100","v":0},null,{"$f":"$E42*H23/100","v":142.40377848752235},null,{"$f":"H42-F42","v":142.40377848752235},null,{"$f":"J42/F42","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E42","v":101499.48573593894},0,null,117.02890705353761,null,117.02890705353761,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,101499.48573593894,0,null,109.11194716613436,null,109.11194716613436,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F41:F44)","v":560.68315920532677},null,{"$f":"SUM(H41:H44)","v":929.22779191252107},null,368.54463270719435,null,{"$f":"J45/F45","v":0.65731354091238237}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F38+F45","v":40408.186111622366},null,{"$f":"H38+H45","v":41131.777179633194},null,{"$f":"J38+J45","v":723.59106801082476},null,{"$f":"J47/F47","v":1.7907041558658396E-2}]
[]
[null,null,"Rate 11 - Large Seasonal Service Sample Dryer 2",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F10","v":210.29},null,{"$f":"H10","v":214.30653899999996}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"All Volumes",null,"₵/m3",{"$f":"F12","v":15.827999999999999},null,{"$f":"H12","v":16.130314799999997}]
[null,null,"Tier 2",null,"₵/m3",15.827999999999999,null,16.130314799999997]
[null,null,"Tier 3",null,"₵/m3",15.827999999999999,null,16.130314799999997]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.250999999999999,null,11.250999999999999]
[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},null,{"$f":"H23","v":0.14030000000000001}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵/m3",0,null,0.1153]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,"₵/m3",0,null,0.1075]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F51*$E69","v":2523.48},null,{"$f":"H51*$E69","v":2571.6784679999996},null,{"$f":"H69-F69","v":48.198467999999593},null,{"$f":"J69/F69","v":1.9099999999999839E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"$E70*F52","v":12},null,{"$f":"$E70*H52","v":12},null,{"$f":"H70-F70","v":0},null,{"$f":"J70/F70","v":0}]
[null,null,"All Volumes",null,338331.61911979644,{"$f":"F53*$E71/100","v":53551.128674281383},null,{"$f":"H53*$E71/100","v":54573.955231960143},null,{"$f":"H71-F71","v":1022.8265576787599},null,{"$f":"J71/F71","v":1.9099999999999728E-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(E71:E74)","v":338331.61911979644},38065.690467168293,null,38065.690467168293,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E75","v":338331.61911979644},119.09272993016835,null,119.09272993016835,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E76","v":338331.61911979644},6146.1321929302221,null,6146.1321929302221,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E77","v":338331.61911979644},{"$f":"$E78*F60/100","v":13228.766307584041},null,{"$f":"$E78*H60/100","v":13228.766307584041},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F69:F78)","v":113646.29037189411},null,{"$f":"SUM(H69:H78)","v":114717.31539757286},null,{"$f":"SUM(J69:J78)","v":1071.0250256787594},null,{"$f":"J79/F79","v":9.4241969726768567E-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":"E75","v":338331.61911979644},{"$f":"$E82*F63/100","v":1868.9438640177555},null,{"$f":"$E82*H63/100","v":1868.9438640177555},null,{"$f":"H82-F82","v":0},null,{"$f":"J82/F82","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E82","v":338331.61911979644},{"$f":"$E83*F64/100","v":0},null,{"$f":"$E83*H64/100","v":474.67926162507445},null,{"$f":"H83-F83","v":474.67926162507445},null,{"$f":"J83/F83","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E83","v":338331.61911979644},0,null,390.09635684512529,null,390.09635684512529,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,338331.61911979644,0,null,363.70649055378118,null,363.70649055378118,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F82:F85)","v":1868.9438640177555},null,{"$f":"SUM(H82:H85)","v":3097.4259730417366},null,{"$f":"SUM(J82:J85)","v":1228.4821090239809},null,{"$f":"J86/F86","v":0.65731354091238237}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F79+F86","v":115515.23423591186},null,{"$f":"H79+H86","v":117814.7413706146},null,{"$f":"J79+J86","v":2299.5071347027406},null,{"$f":"J88/F88","v":1.9906527047389738E-2}]

{"sheet":"G1.4 Rate 16 Bill Impact","index":16,"n_rows":51,"n_cols":12,"rows_kept":51,"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-2021-0216  Exhibit A - 2022 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":1546.25},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C10))","v":1575.7833749999998}]
[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":105.4686},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C15))","v":107.48305025999998}]
[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":7.83},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C21)+1)","v":7.83}]
[]
[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'!E14","v":0},null,{"$f":"'F1.3 Rate Riders'!E21","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!E15","v":0},null,{"$f":"'F1.3 Rate Riders'!E30","v":0.85470000000000002}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,"₵ / contracted m3",{"$f":"'C1.1 Current Rate Riders'!E16","v":0},null,{"$f":"'F1.3 Rate Riders'!E39","v":0.7964}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E30","v":18555},null,{"$f":"H10*$E30","v":18909.400499999996},null,{"$f":"H30-F30","v":354.4004999999961},null,{"$f":"J30/F30","v":1.9099999999999791E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E30","v":12},{"$f":"$E31*F11","v":12},null,{"$f":"$E31*H11","v":12},null,0,null,0]
[null,null,"Tier 1",null,0,{"$f":"F12*$E32/100","v":0},null,{"$f":"H12*$E32/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 2",null,0,{"$f":"F13*$E33/100","v":0},null,{"$f":"H13*$E33/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 3",null,0,{"$f":"F14*$E34/100","v":0},null,{"$f":"H14*$E34/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,50000,{"$f":"F15*$E35/100*$E$30","v":632811.60000000009},null,{"$f":"H15*$E35/100*$E$30","v":644898.30155999993},null,12086.701559999841,null,1.9099999999999746E-2]
[null,null,"Gas Supply",null,0,{"$f":"F16*$E36/100","v":0},null,{"$f":"H16*$E36/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"$E$35","v":50000},{"$f":"F17*$E37/100*$E$30","v":85460.4},null,{"$f":"H17*$E37/100*$E$30","v":85460.4},null,0,null,0]
[null,null,"Transportation Charge From Dawn",null,{"$f":"$E$35","v":50000},{"$f":"F18*$E38/100*$E$30","v":109799.40000000001},null,{"$f":"H18*$E38/100*$E$30","v":109799.40000000001},null,0,null,0]
[null,null,"Transportation Charge \nFrom Kirkwall",null,0,{"$f":"F19*$E39/100*$E$30","v":0},null,{"$f":"H19*$E39/100*$E$30","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Transportation Charge From Parkway",null,0,{"$f":"F20*$E40/100*$E$30","v":0},null,{"$f":"H20*$E40/100*$E$30","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Federal Carbon Charge",null,{"$f":"$E$35","v":50000},{"$f":"$E41*F21/100*$E$30","v":46980},null,{"$f":"$E41*H21/100*$E$30","v":46980},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F30:F41)","v":893618.40000000014},null,{"$f":"SUM(H30:H41)","v":906059.50205999997},null,{"$f":"SUM(J30:J41)","v":12441.102059999837},null,1.3922164158660828E-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":"E30","v":12},{"$f":"$E$45*$E35*$F24/100","v":360.6},null,{"$f":"$E$45*$E35*$H24/100","v":360.6},null,{"$f":"H45-F45","v":0},null,{"$f":"J45/F45","v":0}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$16","v":"ECVA Rate Rider"},null,{"$f":"E45","v":12},{"$f":"$E$45*$E36*$F25/100","v":0},null,{"$f":"$E$45*$E36*$H25/100","v":0},null,{"$f":"H46-F46","v":0},null,{"$f":"J46/F46","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$25","v":"CIACVA Rate Rider"},null,{"$f":"E46","v":12},0,null,{"$f":"$E$45*$E37*$H26/100","v":5128.2},null,5128.2,null,{"$error":"#DIV/0!"}]
[null,null,{"$f":"'F1.3 Rate Riders'!$E$34","v":"EFVA Rate Rider"},null,12,0,null,4778.3999999999996,null,4778.3999999999996,null,{"$error":"#DIV/0!"}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F45:F48)","v":360.6},{"$f":"SUM(G45:G48)","v":0},10267.200000000001,0,9906.5999999999985,null,{"$f":"J49/F49","v":27.47254575707154}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F42+F49","v":893979.00000000012},null,{"$f":"H42+H49","v":916326.70205999992},null,{"$f":"J42+J49","v":22347.702059999836},null,{"$f":"J51/F51","v":2.4998016799052138E-2}]

{"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-2021-0216  Exhibit A - 2022 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'!J30","v":5.9087759999999889},{"$f":"'G1.1 Rate 1 Bill Impact'!J31","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J32:J35)","v":11.218017165381582},{"$f":"'G1.1 Rate 1 Bill Impact'!J47","v":26.168373000000003},{"$f":"'G1.1 Rate 1 Bill Impact'!J37","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J38","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J39","v":0},{"$f":"SUM(E10:K10)","v":43.295166165381573},{"$f":"'G1.1 Rate 1 Bill Impact'!L49","v":2.9993287664520356E-2}]
[null,null,"Rate 1","New Residential",{"$f":"'G1.1 Rate 1 Bill Impact'!J72","v":5.9087759999999889},{"$f":"'G1.1 Rate 1 Bill Impact'!J73","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J74:J75)","v":10.787916308587398},{"$f":"'G1.1 Rate 1 Bill Impact'!J89","v":25.157682000000001},{"$f":"'G1.1 Rate 1 Bill Impact'!J79","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J80","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J81","v":0},{"$f":"SUM(E11:K11)","v":41.854374308587388},{"$f":"'G1.1 Rate 1 Bill Impact'!L91","v":2.9889122860085673E-2}]
[null,null,"Rate 1","Small Commercial",{"$f":"'G1.1 Rate 1 Bill Impact'!J113","v":5.9087759999999889},{"$f":"'G1.1 Rate 1 Bill Impact'!J114","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J115:J118)","v":24.239458667451458},{"$f":"'G1.1 Rate 1 Bill Impact'!J130","v":57.146661000000009},{"$f":"'G1.1 Rate 1 Bill Impact'!J120","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J121","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J122","v":0},87.294895667451456,{"$f":"'G1.1 Rate 1 Bill Impact'!L132","v":3.1647493943093429E-2}]
[null,null,"Rate 1","Small Agricultural",{"$f":"'G1.1 Rate 1 Bill Impact'!J154","v":5.9087759999999889},{"$f":"'G1.1 Rate 1 Bill Impact'!J155","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J156:J159)","v":24.376498882825558},{"$f":"'G1.1 Rate 1 Bill Impact'!J171","v":57.475440000000006},{"$f":"'G1.1 Rate 1 Bill Impact'!J161","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J162","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J163","v":0},87.760714882825553,{"$f":"'G1.1 Rate 1 Bill Impact'!L173","v":3.1656910155372475E-2}]
[null,null,"Rate 6","Medium Commercial",{"$f":"'G1.2 Rate 6 Bill Impact'!J28","v":24.100379999999632},{"$f":"'G1.2 Rate 6 Bill Impact'!J29","v":0},{"$f":"SUM('G1.2 Rate 6 Bill Impact'!J30:J33)","v":122.75689271466763},{"$f":"'G1.2 Rate 6 Bill Impact'!J45","v":406.742166},{"$f":"'G1.2 Rate 6 Bill Impact'!J35","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J36","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J37","v":0},553.59943871466726,{"$f":"'G1.2 Rate 6 Bill Impact'!L47","v":3.5970008417115375E-2}]
[null,null,"Rate 6","Large Commercial",{"$f":"'G1.2 Rate 6 Bill Impact'!J70","v":24.100379999999632},{"$f":"'G1.2 Rate 6 Bill Impact'!J71","v":0},{"$f":"SUM('G1.2 Rate 6 Bill Impact'!J72:J75)","v":332.1407096853959},{"$f":"'G1.2 Rate 6 Bill Impact'!J87","v":1142.99487},{"$f":"'G1.2 Rate 6 Bill Impact'!J77","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J78","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J79","v":0},1499.2359596853955,{"$f":"'G1.2 Rate 6 Bill Impact'!L89","v":3.7227364485994077E-2}]
[null,null,"Rate 11","Sample Dryer 1",{"$f":"'G1.3 Rate 11 Bill Impact'!J28","v":48.198467999999593},{"$f":"'G1.3 Rate 11 Bill Impact'!J29","v":0},{"$f":"SUM('G1.3 Rate 11 Bill Impact'!J30:J33)","v":306.84796730363087},{"$f":"'G1.3 Rate 11 Bill Impact'!J45","v":368.54463270719435},{"$f":"'G1.3 Rate 11 Bill Impact'!J35","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J36","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J37","v":0},723.59106801082476,{"$f":"'G1.3 Rate 11 Bill Impact'!L47","v":1.7907041558658396E-2}]
[null,null,"Rate 11","Sample Dryer 2",{"$f":"'G1.3 Rate 11 Bill Impact'!J69","v":48.198467999999593},{"$f":"'G1.3 Rate 11 Bill Impact'!J70","v":0},{"$f":"SUM('G1.3 Rate 11 Bill Impact'!J71:J74)","v":1022.8265576787599},{"$f":"'G1.3 Rate 11 Bill Impact'!J86","v":1228.4821090239809},{"$f":"'G1.3 Rate 11 Bill Impact'!J76","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J77","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J78","v":0},2299.5071347027406,{"$f":"'G1.3 Rate 11 Bill Impact'!L88","v":1.9906527047389738E-2}]
[null,null,"Rate 16","Contracted Demand",{"$f":"'G1.4 Rate 16 Bill Impact'!J30","v":354.4004999999961},{"$f":"'G1.4 Rate 16 Bill Impact'!J31","v":0},{"$f":"SUM('G1.4 Rate 16 Bill Impact'!J32:J35)","v":12086.701559999841},{"$f":"'G1.4 Rate 16 Bill Impact'!J49","v":9906.5999999999985},{"$f":"'G1.4 Rate 16 Bill Impact'!J37","v":0},{"$f":"SUM('G1.4 Rate 16 Bill Impact'!J38:J40)","v":0},{"$f":"'G1.4 Rate 16 Bill Impact'!J41","v":0},22347.702059999836,{"$f":"'G1.4 Rate 16 Bill Impact'!L51","v":2.4998016799052138E-2}]