{"text_format":"1","workbook":"xlsx","n_sheets":24,"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","C2.1 Regulatory Cost Adjustment","C2.2 Alloc Reg Cost Adj","C2.3 Adj Monthly Service Chg","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.1 Calc Shared Tax Changes","F1.2 Alloc Shared Tax Changes","F1.3 Rate Riders","F2.1 Deferred Revenue Recovery","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":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"A1.1 Distributor Information","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":" \"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-2019-0264   Exhibit A - 2020 Custom Incentive Application"}]
[]
[null,null,"Distributor Information"]
[]
[null,null,"Distributor Name","EPCOR Natural Gas Limited Partnership"]
[null,null,"OEB Application Number","EB-2019-0264   Exhibit A - 2020 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-2019-0264   Exhibit A - 2020 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,1,26.79480281388777,26.26699125322687,25.491108259055345,null,11.5114,1.474,2.6981999999999999,null,null,null,3.91]
[null,null,"Rate 6","Large Volume General Firm Service",102,1,24.718900000000001,22.247,21.134599999999999,null,11.5114,2.92,5.6413000000000002,null,null,null,3.91]
[null,null,"Rate 11","Large Volume Seasonal Service",204,1,15.3546,15.3546,15.3546,null,11.5114,3.5200000000000002E-2,1.8166,null,null,null,3.91]
[null,null,"Rate 16","Contracted Firm Service",1500,1,null,null,null,102.3139,null,14.243399999999999,null,18.299900000000001,11.848000000000001,11.848000000000001,3.91]
[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-2019-0264   Exhibit A - 2020 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",1753,1774284.216007276,2138384.7044110959,101472.57958162803,0,4014141.5]
[null,null,"Rate 6","Large Volume General Firm Service",24,245078.5278000774,526295.05832646182,115884.77697095434,0,887258.36309749365]
[null,null,"Rate 11","Large Volume Seasonal Service",1,0,0,338331.61911979644,0,338331.61911979644]
[null,null,"Rate 16","Contracted Firm Service",2,0,0,0,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-2019-0264   Exhibit A - 2020 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":525900},{"$f":"'B1.1 Current Distribution Rates'!F10*'B1.2 Billing Determinants'!E9*$D$8","v":21036},{"$f":"'B1.2 Billing Determinants'!F9*'B1.1 Current Distribution Rates'!G10/100","v":475415.95703708415},{"$f":"'B1.2 Billing Determinants'!G9*'B1.1 Current Distribution Rates'!H10/100","v":561689.32326800388},{"$f":"'B1.2 Billing Determinants'!H9*'B1.1 Current Distribution Rates'!I10/100","v":25866.48511440889},{"$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":462083.88463099999},{"$f":"'B1.1 Current Distribution Rates'!L10*'B1.2 Billing Determinants'!$J9/100","v":59168.445709999993},{"$f":"'B1.1 Current Distribution Rates'!M10*'B1.2 Billing Determinants'!$J9/100","v":108309.565953},{"$f":"'B1.1 Current Distribution Rates'!Q10*'B1.2 Billing Determinants'!J9/100","v":156952.93265},{"$f":"SUM(E14:N14)","v":2396422.5943634966}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'B1.2 Billing Determinants'!E10*'B1.1 Current Distribution Rates'!E11*$D$8","v":29376},{"$f":"'B1.1 Current Distribution Rates'!F11*'B1.2 Billing Determinants'!E10*$D$8","v":288},{"$f":"'B1.2 Billing Determinants'!F10*'B1.1 Current Distribution Rates'!G11/100","v":60580.716208373335},{"$f":"'B1.2 Billing Determinants'!G10*'B1.1 Current Distribution Rates'!H11/100","v":117084.86162588796},{"$f":"'B1.2 Billing Determinants'!H10*'B1.1 Current Distribution Rates'!I11/100","v":24491.784073703311},{"$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":102135.85920960488},{"$f":"'B1.1 Current Distribution Rates'!L11*'B1.2 Billing Determinants'!$J10/100","v":25907.944202446812},{"$f":"'B1.1 Current Distribution Rates'!M11*'B1.2 Billing Determinants'!$J10/100","v":50052.906037418907},{"$f":"'B1.1 Current Distribution Rates'!Q11*'B1.2 Billing Determinants'!J10/100","v":34691.801997112001},{"$f":"SUM(E15:N15)","v":444609.87335454719}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'B1.2 Billing Determinants'!E11*'B1.1 Current Distribution Rates'!E12*$D$8","v":2448},{"$f":"'B1.1 Current Distribution Rates'!F12*'B1.2 Billing Determinants'!E11*$D$8","v":12},{"$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":51949.466789368264},{"$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":38946.706003356245},{"$f":"'B1.1 Current Distribution Rates'!L12*'B1.2 Billing Determinants'!$J11/100","v":119.09272993016835},{"$f":"'B1.1 Current Distribution Rates'!M12*'B1.2 Billing Determinants'!$J11/100","v":6146.1321929302221},{"$f":"'B1.1 Current Distribution Rates'!Q12*'B1.2 Billing Determinants'!J11/100","v":13228.766307584041},{"$f":"SUM(E16:N16)","v":112850.16402316894}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'B1.2 Billing Determinants'!E12*'B1.1 Current Distribution Rates'!E13*$D$8","v":36000},{"$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":1101503.2622880002},{"$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":42094.747199999998},{"$f":"SUM(E17:N17)","v":1529980.5738240001}]
[null,null,"Total Revenue",null,{"$f":"SUM(E14:E17)","v":593724},21360,535996.67324545747,678774.1848938918,102307.73597748046,1101503.2622880002,603166.44984396116,238538.78757037694,361523.8635913491,246968.24815469602,4483863.2055652123]
[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-2019-0264   Exhibit A - 2020 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":"C2.1 Regulatory Cost Adjustment","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!#REF!","v":{"$error":"#REF!"}}]
[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-2019-0264   Exhibit A - 2020 Custom Incentive Application"}]
[]
[]
[]
[]
[null,null,"Regulatory Cost Adjustment"]
[null,null,"Annual Regulatory  Adjustment"]
[null,null,22800,"for 3 years",{"$f":"C10*3","v":68400},"Total to be collected"]
[null,null,"A",null,"B= A * 3"]
[]
[null,null,{"$f":"E10","v":68400},"recovered over 33 months",{"$f":"C13/33","v":2072.7272727272725},"per month"]
[null,null,"B",null,"C = B / 33"]
[]
[null,null,{"$f":"E13","v":2072.7272727272725},"Monthly charge annualized 12 months",{"$f":"C16*12","v":24872.727272727272},"Adjusted Regulatory Adjustment Value"]
[null,null,"C",null,"D = C * 12"]
[]
[null,null,"Proposed recovery"]
[null,null,{"$f":"E16","v":24872.727272727272},"Recovered over 9 months",{"$f":"C20/12*9","v":18654.545454545452},"Recovered in 2011/2012"]
[null,null,{"$f":"C20","v":24872.727272727272},"Recovered over 12 months",{"$f":"C21","v":24872.727272727272},"Recovered in 2012/2013"]
[null,null,{"$f":"C21","v":24872.727272727272},"Recovered over 12 months",{"$f":"C22","v":24872.727272727272},"Recovered in 2013/2014"]
[null,null,null,null,{"$f":"SUM(E20:E22)","v":68400}]

{"sheet":"C2.2 Alloc Reg Cost Adj","index":6,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":true,"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-2019-0264   Exhibit A - 2020 Custom Incentive Application"}]
[]
[]
[]
[]
[]
[]
[null,null,"Allocation of Regualtory Cost Adjustment"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Revenue By Rate Class",null,"Proportionate Revenue",null,"Regulatory Cost Adjustment",null,"Number of Customers",null,"Number of Months",null,"Fixed Rate Adjustment"]
[null,null,"RATE 1 - General Service Rate",null,{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"E16/$E$22","v":{"$error":"#REF!"}},null,{"$f":"$I$22*G16","v":{"$error":"#REF!"}},null,{"$f":"SUM('B1.2 Billing Determinants'!#REF!)","v":{"$error":"#REF!"}},null,12,null,{"$f":"I16/K16/M16","v":{"$error":"#REF!"}}]
[null,null,"RATE 2 - Seasonal Service ",null,{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,"RATE 4 - General Service Peaking",null,{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(E16:E21)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G16:G21)","v":{"$error":"#REF!"}},null,{"$f":"'C2.1 Regulatory Cost Adjustment'!E16","v":24872.727272727272},null,{"$f":"SUM(K16:K21)","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"C2.2 Alloc Reg Cost Adj"}]

{"sheet":"C2.3 Adj Monthly Service Chg","index":7,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!#REF!","v":{"$error":"#REF!"}}]
[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-2019-0264   Exhibit A - 2020 Custom Incentive Application"}]
[]
[]
[]
[]
[]
[]
[null,null,"Adjustment to Monthly Service Charge"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Current Monthly  Service Charge",null,"Reulatory Cost Adjustment",null,"Adjusted Monthly  Service Charge"]
[null,null,"RATE 1 - General Service Rate - Residential",null,13.5,null,0,null,{"$f":"E16+G16","v":13.5}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,13.5,null,0,null,{"$f":"E17+G17","v":13.5}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,13.5,null,0,null,13.5]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,15,null,0,null,15]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,15,null,0,null,15]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,150,null,0,null,150]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,15,null,0,null,15]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,15,null,0,null,15]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,150,null,0,null,150]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,150,null,0,null,150]
[]
[]
[null,null,"1 Placeholder rate for average application"]

{"sheet":"D1.1 Rate 1 Adjustment","index":8,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2019-0264   Exhibit A - 2020 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.4999999999999999E-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},{"$f":"$E$13","v":1.4999999999999999E-2},{"$f":"E17*(1+F17)","v":25.374999999999996},{"$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":1753},{"$f":"G17*H17*$E$14","v":533788.49999999988}]
[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":1753},{"$f":"G18*H18*$E$14","v":21036}]
[null,null,"Tier 1","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!G10","v":26.79480281388777},{"$f":"$E$13","v":1.4999999999999999E-2},{"$f":"E19*(1+F19)","v":27.196724856096083},{"$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":1774284.216007276},{"$f":"G19*H19/100","v":482547.1963926403}]
[null,null,"Tier 2","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!H10","v":26.26699125322687},{"$f":"$E$13","v":1.4999999999999999E-2},26.660996122025271,{"$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":2138384.7044110959},{"$f":"G20*H20/100","v":570114.66311702388}]
[null,null,"Tier 3","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!I10","v":25.491108259055345},{"$f":"$E$13","v":1.4999999999999999E-2},25.873474882941174,{"$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":101472.57958162803},26254.482391125024]
[null,null,"Contract Demand","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!J10","v":0},{"$f":"$E$13","v":1.4999999999999999E-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.5114},0,11.5114,{"$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":4014141.5},462083.88463099999]
[null,null,"Upstream Recovery \nCharge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!L10","v":1.474},0,1.474,{"$f":"H23","v":4014141.5},59168.445709999993]
[null,null,"Transportation & \nStorage Charge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!M10","v":2.6981999999999999},0,2.6981999999999999,{"$f":"H24","v":4014141.5},108309.565953]
[null,null,"Federal Carbon Charge","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!Q10","v":3.91},0,3.91,{"$f":"H25","v":4014141.5},{"$f":"G26*H26/100","v":156952.93265}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":2420255.6708447891}]

{"sheet":"D1.2 Rate 6 Adjustment","index":9,"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-2019-0264   Exhibit A - 2020 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,1.4999999999999999E-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":102},{"$f":"$E$13","v":1.4999999999999999E-2},{"$f":"E17*(1+F17)","v":103.52999999999999},{"$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":24},{"$f":"G17*H17*12","v":29816.639999999999}]
[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":24},{"$f":"G18*H18*12","v":288}]
[null,null,"Tier 1","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!G11","v":24.718900000000001},{"$f":"$E$13","v":1.4999999999999999E-2},{"$f":"E19*(1+F19)","v":25.0896835},{"$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":245078.5278000774},{"$f":"G19*H19/100","v":61489.426951498928}]
[null,null,"Tier 2","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!H11","v":22.247},{"$f":"$E$13","v":1.4999999999999999E-2},22.580704999999998,{"$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":526295.05832646182},{"$f":"G20*H20/100","v":118841.13455027627}]
[null,null,"Tier 3","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!I11","v":21.134599999999999},{"$f":"$E$13","v":1.4999999999999999E-2},21.451618999999997,{"$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":115884.77697095434},24859.160834808863]
[null,null,"Contract Demand","cents / m3",{"$f":"'B1.1 Current Distribution Rates'!J11","v":0},{"$f":"$E$13","v":1.4999999999999999E-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.5114},0,11.5114,{"$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":887258.36309749365},102135.85920960488]
[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":887258.36309749365},25907.944202446812]
[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},0,5.6413000000000002,{"$f":"H24","v":887258.36309749365},50052.906037418907]
[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":3.91},0,3.91,{"$f":"H25","v":887258.36309749365},34691.801997112001]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":448082.87378316664}]

{"sheet":"D1.3 Rate 11 Adjustment","index":10,"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-2019-0264   Exhibit A - 2020 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,1.4999999999999999E-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":204},{"$f":"$E$13","v":1.4999999999999999E-2},{"$f":"E17*(1+F17)","v":207.05999999999997},{"$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":1},{"$f":"G17*H17*12","v":2484.7199999999998}]
[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":1},{"$f":"G18*H18*12","v":12}]
[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.3546},{"$f":"$E$13","v":1.4999999999999999E-2},15.584918999999998,{"$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.3546},{"$f":"$E$13","v":1.4999999999999999E-2},15.584918999999998,{"$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.3546},{"$f":"$E$13","v":1.4999999999999999E-2},15.584918999999998,{"$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":338331.61911979644},52728.708791208781]
[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.4999999999999999E-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.5114},0,11.5114,{"$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":338331.61911979644},38946.706003356245]
[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":338331.61911979644},119.09272993016835]
[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},0,1.8166,{"$f":"H24","v":338331.61911979644},6146.1321929302221]
[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":3.91},0,3.91,{"$f":"H25","v":338331.61911979644},13228.766307584041]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I26)","v":113666.12602500946}]

{"sheet":"D1.4 Rate 16 Adjustment","index":11,"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-2019-0264   Exhibit A - 2020 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,1.4999999999999999E-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":1500},{"$f":"$E$13","v":1.4999999999999999E-2},{"$f":"E17*(1+F17)","v":1522.4999999999998},{"$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":36539.999999999993}]
[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.4999999999999999E-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.4999999999999999E-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.4999999999999999E-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":102.3139},1.4999999999999999E-2,103.8486085,{"$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":1118025.81122232}]
[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},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},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},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":3.91},0,3.91,{"$f":"H25","v":89716},{"$f":"G28*H28/100*$E$14","v":42094.747199999998}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I28)","v":1547043.1227583201}]

{"sheet":"E1.1 Proposed Dist Rates ","index":12,"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-2019-0264   Exhibit A - 2020 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":25.374999999999996},{"$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":27.196724856096083},{"$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":26.660996122025271},{"$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":25.873474882941174},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.5114},{"$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":3.91}]
[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":103.52999999999999},{"$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.0896835},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(H8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":22.580704999999998},{"$f":"INDEX('D1.2 Rate 6 Adjustment'!$G$17:$G$26,MATCH(I8,'D1.2 Rate 6 Adjustment'!$C$17:$C$26,0))","v":21.451618999999997},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.5114},{"$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":3.91}]
[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":207.05999999999997},{"$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":15.584918999999998},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(H8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":15.584918999999998},{"$f":"INDEX('D1.3 Rate 11 Adjustment'!$G$17:$G$26,MATCH(I8,'D1.3 Rate 11 Adjustment'!$C$17:$C$26,0))","v":15.584918999999998},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.5114},{"$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":3.91}]
[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":1522.4999999999998},{"$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":103.8486085},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":3.91}]
[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":13,"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-2019-0264   Exhibit A - 2020 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":1753},{"$f":"'B1.2 Billing Determinants'!F9","v":1774284.216007276},{"$f":"'B1.2 Billing Determinants'!G9","v":2138384.7044110959},{"$f":"'B1.2 Billing Determinants'!H9","v":101472.57958162803},{"$f":"'B1.2 Billing Determinants'!I9","v":0},{"$f":"'B1.2 Billing Determinants'!J9","v":4014141.5}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'B1.2 Billing Determinants'!E10","v":24},{"$f":"'B1.2 Billing Determinants'!F10","v":245078.5278000774},{"$f":"'B1.2 Billing Determinants'!G10","v":526295.05832646182},{"$f":"'B1.2 Billing Determinants'!H10","v":115884.77697095434},{"$f":"'B1.2 Billing Determinants'!I10","v":0},{"$f":"'B1.2 Billing Determinants'!J10","v":887258.36309749365}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'B1.2 Billing Determinants'!E11","v":1},{"$f":"'B1.2 Billing Determinants'!F11","v":0},{"$f":"'B1.2 Billing Determinants'!G11","v":0},{"$f":"'B1.2 Billing Determinants'!H11","v":338331.61911979644},{"$f":"'B1.2 Billing Determinants'!I11","v":0},{"$f":"'B1.2 Billing Determinants'!J11","v":338331.61911979644}]
[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":14,"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-2019-0264   Exhibit A - 2020 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":533788.49999999988},{"$f":"'E1.1 Proposed Dist Rates '!F10*'E1.2 Billing Determinants'!E11*$D$7","v":21036},{"$f":"'E1.1 Proposed Dist Rates '!G10*'E1.2 Billing Determinants'!F11/100","v":482547.1963926403},{"$f":"'E1.1 Proposed Dist Rates '!H10*'E1.2 Billing Determinants'!G11/100","v":570114.66311702388},{"$f":"'E1.1 Proposed Dist Rates '!I10*'E1.2 Billing Determinants'!H11/100","v":26254.482391125024},{"$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":462083.88463099999},{"$f":"'E1.1 Proposed Dist Rates '!L10*'E1.2 Billing Determinants'!$J11/100","v":59168.445709999993},{"$f":"'E1.1 Proposed Dist Rates '!M10*'E1.2 Billing Determinants'!$J11/100","v":108309.565953},{"$f":"'E1.1 Proposed Dist Rates '!Q10*'E1.2 Billing Determinants'!J11/100","v":156952.93265},{"$f":"SUM(E11:N11)","v":2420255.6708447891}]
[null,null,"Rate 6","Large Volume General Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E11*'E1.2 Billing Determinants'!E12*$D$7","v":29816.639999999999},{"$f":"'E1.1 Proposed Dist Rates '!F11*'E1.2 Billing Determinants'!E12*$D$7","v":288},{"$f":"'E1.1 Proposed Dist Rates '!G11*'E1.2 Billing Determinants'!F12/100","v":61489.426951498928},{"$f":"'E1.1 Proposed Dist Rates '!H11*'E1.2 Billing Determinants'!G12/100","v":118841.13455027627},{"$f":"'E1.1 Proposed Dist Rates '!I11*'E1.2 Billing Determinants'!H12/100","v":24859.160834808863},{"$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":102135.85920960488},{"$f":"'E1.1 Proposed Dist Rates '!L11*'E1.2 Billing Determinants'!$J12/100","v":25907.944202446812},{"$f":"'E1.1 Proposed Dist Rates '!M11*'E1.2 Billing Determinants'!$J12/100","v":50052.906037418907},{"$f":"'E1.1 Proposed Dist Rates '!Q11*'E1.2 Billing Determinants'!J12/100","v":34691.801997112001},{"$f":"SUM(E12:N12)","v":448082.87378316664}]
[null,null,"Rate 11","Large Volume Seasonal Service",{"$f":"'E1.1 Proposed Dist Rates '!E12*'E1.2 Billing Determinants'!E13*$D$7","v":2484.7199999999998},{"$f":"'E1.1 Proposed Dist Rates '!F12*'E1.2 Billing Determinants'!E13*$D$7","v":12},{"$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":52728.708791208781},{"$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":38946.706003356245},{"$f":"'E1.1 Proposed Dist Rates '!L12*'E1.2 Billing Determinants'!$J13/100","v":119.09272993016835},{"$f":"'E1.1 Proposed Dist Rates '!M12*'E1.2 Billing Determinants'!$J13/100","v":6146.1321929302221},{"$f":"'E1.1 Proposed Dist Rates '!Q12*'E1.2 Billing Determinants'!J13/100","v":13228.766307584041},{"$f":"SUM(E13:N13)","v":113666.12602500946}]
[null,null,"Rate 16","Contracted Firm Service",{"$f":"'E1.1 Proposed Dist Rates '!E13*'E1.2 Billing Determinants'!E14*$D$7","v":36539.999999999993},{"$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":1118025.81122232},{"$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":42094.747199999998},{"$f":"SUM(E14:N14)","v":1547043.1227583201}]
[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":4529047.7934112847}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Revenue",{"$f":"'B1.3 Current Rev From Rates'!O18","v":4483863.2055652123}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change",{"$f":"O15-O16","v":45184.587846072391}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"% Change",{"$f":"O17/O16","v":1.0077155741502301E-2}]

{"sheet":"F1.1 Calc Shared Tax Changes","index":15,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":true,"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-2019-0264   Exhibit A - 2020 Custom Incentive Application"}]
[]
[]
[]
[]
[]
[]
[null,null,"Tax Change Rate Rider"]
[]
[]
[]
[null,null,null,null,2010,null,2011,null,2012,null,2013,null,2014,null,2015,null,2016,null,2017]
[null,null,"Regulatory Taxable Income",null,793363,null,{"$f":"E15","v":793363},null,{"$f":"E15","v":793363},null,{"$f":"E15","v":793363},null,{"$f":"E15","v":793363},null,{"$f":"G15","v":793363},null,{"$f":"E15","v":793363},null,{"$f":"G15","v":793363}]
[]
[null,null,"Federal Income Tax Rate",null,{"$f":"(0.18/12*3)+(0.165/12*9)","v":0.16875000000000001},null,{"$f":"(0.165/12*3)+(0.15/12*9)","v":0.15375},null,{"$f":"0.15","v":0.15},null,{"$f":"0.15","v":0.15},null,{"$f":"0.15","v":0.15},null,{"$f":"0.15","v":0.15},null,{"$f":"0.15","v":0.15},null,{"$f":"0.15","v":0.15}]
[null,null,"Federal Income Tax",null,{"$f":"E15*E17","v":133880.00625000001},null,{"$f":"G15*G17","v":121979.56125},null,{"$f":"I15*I17","v":119004.45},null,{"$f":"K15*K17","v":119004.45},null,{"$f":"M15*M17","v":119004.45},null,{"$f":"O15*O17","v":119004.45},null,{"$f":"Q15*Q17","v":119004.45},null,{"$f":"S15*S17","v":119004.45}]
[]
[null,null,"Provincial Income Tax"]
[null,null,"Provincial Income Tax Rate - First $500,000 ",null,4.4999999999999998E-2,null,{"$f":"E21","v":4.4999999999999998E-2},null,{"$f":"G21","v":4.4999999999999998E-2},null,{"$f":"I21","v":4.4999999999999998E-2},null,{"$f":"I21","v":4.4999999999999998E-2},null,{"$f":"K21","v":4.4999999999999998E-2}]
[null,null,"Provincial Income Tax - First $500,000 ",null,{"$f":"IF(E15>500000,500000*E21,E15*E21)","v":22500},null,{"$f":"IF(G15>500000,500000*G21,G15*G21)","v":22500},null,{"$f":"IF(I15>500000,500000*I21,I15*I21)","v":22500},null,{"$f":"IF(K15>500000,500000*K21,K15*K21)","v":22500},null,{"$f":"IF(M15>500000,500000*M21,M15*M21)","v":22500},null,{"$f":"IF(O15>500000,500000*O21,O15*O21)","v":22500},null,{"$f":"IF(Q15>500000,500000*Q21,Q15*Q21)","v":0},null,{"$f":"IF(S15>500000,500000*S21,S15*S21)","v":0}]
[null,null,"Provincial Income Tax Rate - Over $500,000 ",null,0.11874999999999999,null,{"$f":"0.1175/12*9+0.1125/12*3","v":0.11624999999999999},null,0.115,null,0.115,null,0.115,null,0.115,null,0.115,null,0.115]
[null,null,"Provincial Income Tax - Over $500,000 ",null,{"$f":"IF(E15>500000,(E15-500000)*E23,0)","v":34836.856249999997},null,{"$f":"IF(G15>500000,(G15-500000)*G23,0)","v":34103.448749999996},null,{"$f":"IF(I15>500000,(I15-500000)*I23,0)","v":33736.745000000003},null,{"$f":"IF(K15>500000,(K15-500000)*K23,0)","v":33736.745000000003},null,{"$f":"IF(M15>500000,(M15-500000)*M23,0)","v":33736.745000000003},null,{"$f":"IF(O15>500000,(O15-500000)*O23,0)","v":33736.745000000003},null,{"$f":"Q15*Q23","v":91236.74500000001},null,{"$f":"S15*S23","v":91236.74500000001}]
[]
[null,null,"Total Income Taxes Payable",null,{"$f":"E18+E22+E24","v":191216.86249999999},null,{"$f":"G18+G22+G24","v":178583.01},null,{"$f":"I18+I22+I24","v":175241.19500000001},null,{"$f":"K18+K22+K24","v":175241.19500000001},null,{"$f":"M18+M22+M24","v":175241.19500000001},null,{"$f":"O18+O22+O24","v":175241.19500000001},null,{"$f":"Q18+Q22+Q24","v":210241.19500000001},null,{"$f":"S18+S22+S24","v":210241.19500000001}]
[null,null,"Effective Tax Rate",null,{"$f":"E26/E15","v":0.24102064565652795},null,{"$f":"G26/G15","v":0.22509621699020499},null,{"$f":"I26/I15","v":0.2208840026570435},null,{"$f":"K26/K15","v":0.2208840026570435},null,{"$f":"M26/M15","v":0.2208840026570435},null,{"$f":"O26/O15","v":0.2208840026570435},null,{"$f":"Q26/Q15","v":0.26500000000000001},null,{"$f":"S26/S15","v":0.26500000000000001}]
[]
[null,null,"Grossed up Income Tax",null,{"$f":"E26/(1-E27)","v":251939.47820280999},null,{"$f":"G26/(1-G27)","v":230458.30194087807},null,{"$f":"I26/(1-I27)","v":224923.11234479913},null,{"$f":"K26/(1-K27)","v":224923.11234479913},null,{"$f":"M26/(1-M27)","v":224923.11234479913},null,{"$f":"O26/(1-O27)","v":224923.11234479913},null,{"$f":"Q26/(1-Q27)","v":286042.44217687077},null,{"$f":"S26/(1-S27)","v":286042.44217687077}]
[]
[null,null,"Change in Income Taxes",null,null,null,{"$f":"$E$29-G29","v":21481.17626193192},null,{"$f":"$E$29-I29","v":27016.36585801086},null,{"$f":"$E$29-K29","v":27016.36585801086},null,{"$f":"$E$29-M29","v":27016.36585801086},null,{"$f":"$E$29-O29","v":27016.36585801086},null,{"$f":"$E$29-Q29","v":-34102.963974060782},null,{"$f":"$E$29-S29","v":-34102.963974060782}]
[]
[null,null,"50 % Change in Taxes",null,null,null,{"$f":"G31/2","v":10740.58813096596},null,{"$f":"I31/2","v":13508.18292900543},null,{"$f":"K31/2","v":13508.18292900543},null,{"$f":"M31/2","v":13508.18292900543},null,{"$f":"O31/2","v":13508.18292900543},null,{"$f":"Q31/2","v":-17051.481987030391},null,{"$f":"S31/2","v":-17051.481987030391}]
[]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"F1.1 Calc Shared Tax Changes"}]

{"sheet":"F1.2 Alloc Shared Tax Changes","index":16,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"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-2019-0264   Exhibit A - 2020 Custom Incentive Application"}]
[]
[]
[]
[]
[]
[]
[null,null,"Allocation of Shared Tax Changes"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Revenue By Rate Class",null,"Proportionate Revenue",null,"Shared Tax Changes",null,"Number of Customers",null,"Number of Months",null,"Fixed Monthy Rate Rider"]
[null,null,"RATE 1 - General Service Rate",null,{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"E16/$E$22","v":{"$error":"#REF!"}},null,{"$f":"$I$22*G16","v":{"$error":"#REF!"}},null,{"$f":"SUM('B1.2 Billing Determinants'!#REF!)","v":{"$error":"#REF!"}},null,12,null,{"$f":"ROUND(I16/K16/M16,4)","v":{"$error":"#REF!"}}]
[null,null,"RATE 2 - Seasonal Service ",null,{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,"RATE 4 - General Service Peaking",null,{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,{"$f":"'B1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},null,12,null,{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(E16:E21)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G16:G21)","v":{"$error":"#REF!"}},null,{"$f":"-'F1.1 Calc Shared Tax Changes'!S33","v":17051.481987030391},null,{"$f":"SUM(K16:K21)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"F1.2 Alloc Shared Tax Changes"}]

{"sheet":"F1.3 Rate Riders","index":17,"n_rows":11,"n_cols":6,"rows_kept":11,"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-2019-0264   Exhibit A - 2020 Custom Incentive Application"}]
[]
[null,null,"Delay in Revenue Recovery Rate Rider"]
[null,null,"F1.3 Rate Riders",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"]

{"sheet":"F2.1 Deferred Revenue Recovery","index":18,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":true,"merged":[[11,10,11,17],[12,10,13,17]]}
[]
[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-2019-0264   Exhibit A - 2020 Custom Incentive Application"}]
[]
[]
[]
[]
[]
[]
[null,null,"Deferred Revenue Recovery"]
[]
[null,null,null,null,null,null,null,null,null,null,"Impact of October 24 Volume Change"]
[null,null,null,null,null,null,null,null,null,null,"Comparison of revenue applied for July 27 version"]
[]
[null,null,"Rate Group","Proposed Revenue","Current Revenue","Change In Revenue","Deferred Revenue","Number of Customers","Total Annual Consumption","Proposed Deferred Revenue Recovery Rate Rider cents per m3","Change in Revenue filed for July 27","Diference in revenue filed for","Old proposed rate rider","old rate rider at new consumption","Difference in collected revenue","Average Annual $ impact per customer","Annual average revenue per customer","% of average annual revenue "]
[null,null,null,"A","B","C = A- B","D = C / 12 * 12","E","F","H = D /F","I","J = C - I","K","L = K * F","M = D - L","K = J / E","L =  A / E","M = K / L"]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C16","v":"RATE 1 - General Service Rate"},{"$f":"SUM('E1.3 Proposed Rev From Rate'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},{"$f":"D17-E17","v":{"$error":"#REF!"}},{"$f":"F17/12*12","v":{"$error":"#REF!"}},{"$f":"'F1.2 Alloc Shared Tax Changes'!K16","v":{"$error":"#REF!"}},{"$f":"'E1.2 Billing Determinants'!#REF!+'E1.2 Billing Determinants'!#REF!+'E1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(G17/I17*100,4)","v":{"$error":"#REF!"}},82174,{"$f":"F17-K17","v":{"$error":"#REF!"}},0.36109999999999998,{"$f":"M17*I17/100","v":{"$error":"#REF!"}},{"$f":"G17-N17","v":{"$error":"#REF!"}},{"$f":"L17/H17","v":{"$error":"#REF!"}},{"$f":"D17/H17","v":{"$error":"#REF!"}},{"$f":"P17/Q17","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C17","v":"RATE 2 - Seasonal Service "},{"$f":"SUM('E1.3 Proposed Rev From Rate'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"'F1.2 Alloc Shared Tax Changes'!K17","v":{"$error":"#REF!"}},{"$f":"'E1.2 Billing Determinants'!#REF!+'E1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},2161,{"$error":"#REF!"},0.21990000000000001,{"$f":"M18*I18/100","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"L18/H18","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C18","v":"RATE 3 - Special Large Volume Contract Rate"},{"$f":"'E1.3 Proposed Rev From Rate'!#REF!","v":{"$error":"#REF!"}},{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"'F1.2 Alloc Shared Tax Changes'!K18","v":{"$error":"#REF!"}},{"$f":"'E1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},1735,{"$error":"#REF!"},0.1923,{"$f":"M19*I19/100","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"L19/H19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C19","v":"RATE 4 - General Service Peaking"},{"$f":"SUM('E1.3 Proposed Rev From Rate'!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM('B1.3 Current Rev From Rates'!#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"'F1.2 Alloc Shared Tax Changes'!K19","v":{"$error":"#REF!"}},{"$f":"'E1.2 Billing Determinants'!#REF!+'E1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},2125,{"$error":"#REF!"},0.23749999999999999,{"$f":"M20*I20/100","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"L20/H20","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C20","v":"RATE 5 - Interruptible Peaking Contract Rate"},{"$f":"'E1.3 Proposed Rev From Rate'!#REF!","v":{"$error":"#REF!"}},{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"'F1.2 Alloc Shared Tax Changes'!K20","v":{"$error":"#REF!"}},{"$f":"'E1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},844,{"$error":"#REF!"},0.1439,{"$f":"M21*I21/100","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"L21/H21","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C21","v":"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility"},{"$f":"'E1.3 Proposed Rev From Rate'!#REF!","v":{"$error":"#REF!"}},{"$f":"'B1.3 Current Rev From Rates'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"'F1.2 Alloc Shared Tax Changes'!K21","v":{"$error":"#REF!"}},{"$f":"'E1.2 Billing Determinants'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},30580,{"$error":"#REF!"},7.9600000000000004E-2,{"$f":"G22","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"L22/H22*0","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"SUM(D17:D22)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"SUM(K17:K22)","v":119619},{"$f":"SUM(L17:L22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N17:N22)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,{"$f":"F23/E23","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d"]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"F2.1 Deferred Revenue Recovery"}]

{"sheet":"G1.1 Rate 1 Bill Impact","index":19,"n_rows":149,"n_cols":12,"rows_kept":149,"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-2019-0264   Exhibit A - 2020 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},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":25.374999999999996}]
[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":26.79480281388777},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":27.196724856096083}]
[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":26.26699125322687},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":26.660996122025271}]
[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":25.491108259055345},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":25.873474882941174}]
[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.5114},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.5114}]
[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":3.91},null,{"$f":"'E1.1 Proposed Dist Rates '!Q10","v":3.91}]
[]
[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'!E8","v":1.633}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F12*$E27","v":300},null,{"$f":"H12*$E27","v":304.49999999999994},null,{"$f":"H27-F27","v":4.4999999999999432},null,{"$f":"J27/F27","v":1.499999999999981E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"F13*$E28","v":12},null,{"$f":"H13*$E28","v":12},null,{"$f":"H28-F28","v":0},null,{"$f":"J28/F28","v":0}]
[null,null,"First 100 m3",null,1001.3160527512506,{"$f":"F14*$E29/100","v":268.30066187850201},null,{"$f":"H14*$E29/100","v":272.32517180667952},null,{"$f":"H29-F29","v":4.0245099281775083},null,{"$f":"J29/F29","v":1.4999999999999918E-2}]
[null,null,"Next 400 m3",null,1147.6839472487493,301.46204203851789,null,305.98397266909558,null,4.5219306305776854,null,1.4999999999999725E-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(E29:E32)","v":2149},247.379986,null,247.379986,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E33","v":2149},31.676259999999999,null,31.676259999999999,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E34","v":2149},57.984318000000002,null,57.984318000000002,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E33","v":2149},84.025900000000007,null,84.025900000000007,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F27:F36)","v":1302.82916791702},null,{"$f":"SUM(H27:H36)","v":1315.8756084757752},null,{"$f":"SUM(J27:J36)","v":13.046440558755137},null,{"$f":"J37/F37","v":1.0013930360197534E-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":"E33","v":2149},{"$f":"$E40*F24/100","v":35.093170000000001},null,{"$f":"$E40*H24/100","v":35.093170000000001},null,{"$f":"H40-F40","v":0},null,{"$f":"J40/F40","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F40","v":35.093170000000001},null,{"$f":"H40","v":35.093170000000001},null,{"$f":"J40","v":0},null,{"$f":"J41/F41","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F37+F41","v":1337.9223379170201},null,{"$f":"H37+H41","v":1350.9687784757753},null,{"$f":"J37+J41","v":13.046440558755137},null,{"$f":"J43/F43","v":9.7512689556157901E-3}]
[]
[]
[null,null,"Rate 1 - New Residential",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F12","v":25},null,{"$f":"H12","v":25.374999999999996}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",26.79480281388777,null,27.196724856096083]
[null,null,"Next 400 m3",null,"₵/m3",26.26699125322687,null,26.660996122025271]
[null,null,"GT 500m3",null,"₵/m3",25.491108259055345,null,25.873474882941174]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.5114,null,11.5114]
[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",3.91,null,3.91]
[]
[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,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F48*$E63","v":300},null,{"$f":"H48*$E63","v":304.49999999999994},null,{"$f":"H63-F63","v":4.4999999999999432},null,{"$f":"J63/F63","v":1.499999999999981E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E63","v":12},{"$f":"F49*$E64","v":12},null,{"$f":"H49*$E64","v":12},null,{"$f":"H64-F64","v":0},null,{"$f":"J64/F64","v":0}]
[null,null,"First 100 m3",null,993.12960436562071,{"$f":"F50*$E65/100","v":266.10711917611184},null,{"$f":"H50*$E65/100","v":270.09872596375345},null,{"$f":"H65-F65","v":3.991606787641615},null,{"$f":"J65/F65","v":1.4999999999999765E-2}]
[null,null,"Next 400 m3",null,1072.8703956343793,281.81077297974292,null,286.03793457443908,null,4.227161594696156,null,1.5000000000000043E-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(E65:E68)","v":2066},237.825524,null,237.825524,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E69","v":2066},30.452840000000002,null,30.452840000000002,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E70","v":2066},55.744812000000003,null,55.744812000000003,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E69","v":2066},80.780600000000007,null,80.780600000000007,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F63:F72)","v":1264.7216681558548},null,{"$f":"SUM(H63:H72)","v":1277.4404365381924},null,{"$f":"SUM(J63:J72)","v":12.718768382337714},null,{"$f":"J73/F73","v":1.0056575057248366E-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":"E69","v":2066},{"$f":"$E76*F60/100","v":33.737780000000001},null,{"$f":"$E76*H60/100","v":33.737780000000001},null,{"$f":"H76-F76","v":0},null,{"$f":"J76/F76","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F76","v":33.737780000000001},null,{"$f":"H76","v":33.737780000000001},null,{"$f":"J76","v":0},null,{"$f":"J77/F77","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F73+F77","v":1298.4594481558547},null,{"$f":"H73+H77","v":1311.1782165381924},null,{"$f":"J73+J77","v":12.718768382337714},null,{"$f":"J79/F79","v":9.7952757788482541E-3}]
[]
[null,null,"Rate 1 - Small Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F48","v":25},null,{"$f":"H48","v":25.374999999999996}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",26.79480281388777,null,27.196724856096083]
[null,null,"Next 400 m3",null,"₵/m3",26.26699125322687,null,26.660996122025271]
[null,null,"GT 500m3",null,"₵/m3",25.491108259055345,null,25.873474882941174]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.5114,null,11.5114]
[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",3.91,null,3.91]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F60","v":1.633},null,{"$f":"H60","v":1.633}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F83*$E98","v":300},null,{"$f":"H83*$E98","v":304.49999999999994},null,{"$f":"H98-F98","v":4.4999999999999432},null,{"$f":"J98/F98","v":1.499999999999981E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E98","v":12},{"$f":"F84*$E99","v":12},null,{"$f":"H84*$E99","v":12},null,{"$f":"H99-F99","v":0},null,{"$f":"J99/F99","v":0}]
[null,null,"First 100 m3",null,1198.1709868121873,{"$f":"F85*$E100/100","v":321.04755328953883},null,{"$f":"H85*$E100/100","v":325.86326658888186},null,{"$f":"H100-F100","v":4.8157132993430309},null,{"$f":"J100/F100","v":1.499999999999984E-2}]
[null,null,"Next 400 m3",null,2475.0040927694408,650.10910856475607,null,659.86074519322733,null,9.7516366284712603,null,1.4999999999999876E-2]
[null,null,"GT 500m3",null,1019.8249204183721,259.96467451667223,null,263.86414463442236,null,3.899470117750127,null,1.5000000000000168E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E100:E103)","v":4693},540.23000200000001,null,540.23000200000001,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E104","v":4693},69.174819999999997,null,69.174819999999997,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E105","v":4693},126.626526,null,126.626526,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E104","v":4693},183.49630000000002,null,183.49630000000002,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F98:F107)","v":2462.6489843709669},null,{"$f":"SUM(H98:H107)","v":2485.6158044165313},null,{"$f":"SUM(J98:J107)","v":22.966820045564361},null,{"$f":"J108/F108","v":9.3260631910279182E-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":"E104","v":4693},{"$f":"$E111*F95/100","v":76.636690000000002},null,{"$f":"$E111*H95/100","v":76.636690000000002},null,{"$f":"H111-F111","v":0},null,{"$f":"J111/F111","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F111","v":76.636690000000002},null,{"$f":"H111","v":76.636690000000002},null,{"$f":"J111","v":0},null,{"$f":"J112/F112","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F108+F112","v":2539.2856743709667},null,{"$f":"H108+H112","v":2562.2524944165311},null,{"$f":"J108+J112","v":22.966820045564361},null,{"$f":"J114/F114","v":9.0445987536450449E-3}]
[]
[null,null,"Rate 1 - Small Agricultural",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F83","v":25},null,{"$f":"H83","v":25.374999999999996}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 100 m3",null,"₵/m3",{"$f":"F85","v":26.79480281388777},null,{"$f":"H85","v":27.196724856096083}]
[null,null,"Next 400 m3",null,"₵/m3",26.26699125322687,null,26.660996122025271]
[null,null,"GT 500m3",null,"₵/m3",25.491108259055345,null,25.873474882941174]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.5114,null,11.5114]
[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",3.91,null,3.91]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"F95","v":1.633},null,{"$f":"H95","v":1.633}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F118*$E133","v":300},null,{"$f":"H118*$E133","v":304.49999999999994},null,{"$f":"H133-F133","v":4.4999999999999432},null,{"$f":"J133/F133","v":1.499999999999981E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E133","v":12},{"$f":"F119*$E134","v":12},null,{"$f":"H119*$E134","v":12},null,{"$f":"H134-F134","v":0},null,{"$f":"J134/F134","v":0}]
[null,null,"First 100 m3",null,1198.7357889949976,{"$f":"F120*$E135/100","v":321.19889092071139},null,{"$f":"H120*$E135/100","v":326.01687428452203},null,{"$f":"H135-F135","v":4.8179833638106402},null,{"$f":"J135/F135","v":1.4999999999999904E-2}]
[null,null,"Next 400 m3",null,2484.0654843110506,652.48926348841132,null,662.27660244073752,null,9.7873389523261949,null,1.5000000000000038E-2]
[null,null,"GT 500m3",null,1037.1987266939518,264.39345028309884,null,268.35935203734533,null,3.9659017542464881,null,1.500000000000002E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Commodity",null,{"$f":"SUM(E135:E138)","v":4720},543.33807999999999,null,543.33807999999999,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E139","v":4720},69.572800000000001,null,69.572800000000001,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E140","v":4720},127.35503999999999,null,127.35503999999999,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E139","v":4720},184.55200000000002,null,184.55200000000002,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F133:F142)","v":2474.8995246922213},null,{"$f":"SUM(H133:H142)","v":2497.9707487626047},null,{"$f":"SUM(J133:J142)","v":23.071224070383266},null,{"$f":"J143/F143","v":9.3220851352550996E-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":"E139","v":4720},{"$f":"$E146*F130/100","v":77.077600000000004},null,{"$f":"$E146*H130/100","v":77.077600000000004},null,{"$f":"H146-F146","v":0},null,{"$f":"J146/F146","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F146","v":77.077600000000004},null,{"$f":"H146","v":77.077600000000004},null,{"$f":"J146","v":0},null,{"$f":"J147/F147","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F143+F147","v":2551.9771246922214},null,{"$f":"H143+H147","v":2575.0483487626047},null,{"$f":"J143+J147","v":23.071224070383266},null,{"$f":"J149/F149","v":9.0405293398410653E-3}]

{"sheet":"G1.2 Rate 6 Bill Impact","index":20,"n_rows":77,"n_cols":12,"rows_kept":77,"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-2019-0264   Exhibit A - 2020 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":102},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C10))","v":103.52999999999999}]
[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":24.718900000000001},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C12))","v":25.0896835}]
[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.247},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C13))","v":22.580704999999998}]
[null,null,"GT 7000m3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,2,COUNTA($C$10:C14))","v":21.134599999999999},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C14))","v":21.451618999999997}]
[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.5114},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,2,COUNTA($C$10:C16))","v":11.5114}]
[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":3.91},null,{"$f":"'E1.1 Proposed Dist Rates '!Q11","v":3.91}]
[]
[null,null,"Rate Riders"]
[null,null,"Delay in Revenue Recovery Rate Rider",null,"₵/m3",{"$f":"'C1.1 Current Rate Riders'!E11","v":0.90900000000000003},null,{"$f":"'F1.3 Rate Riders'!E9","v":0.90900000000000003}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E25","v":1224},null,{"$f":"H10*$E25","v":1242.3599999999999},null,{"$f":"H25-F25","v":18.3599999999999},null,{"$f":"J25/F25","v":1.4999999999999918E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E25","v":12},{"$f":"E26*F11","v":12},null,{"$f":"E26*H11","v":12},null,0,null,0]
[null,null,"First 1000 m3",null,9831.5433379437527,{"$f":"F12*$E27/100","v":2430.2493661629783},null,{"$f":"H12*$E27/100","v":2466.7031066554227},null,36.453740492444467,null,1.4999999999999914E-2]
[null,null,"Next 6000 m3",null,17101.456662056247,3804.5610636076535,null,3861.6294795617678,null,57.068415954114244,null,1.4999999999999854E-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(E27:E30)","v":26933},3100.3653619999995,null,3100.3653619999995,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E31","v":26933},786.44360000000006,null,786.44360000000006,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E32","v":26933},1519.3713290000001,null,1519.3713290000001,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E33","v":26933},1053.0803000000001,null,1053.0803000000001,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F25:F34)","v":13930.071020770631},null,{"$f":"SUM(H25:H34)","v":14041.953177217189},null,{"$f":"SUM(J25:J34)","v":111.88215644655861},null,8.0317003610200638E-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":"E31","v":26933},{"$f":"$E38*F22/100","v":244.82097000000002},null,{"$f":"$E38*H22/100","v":244.82097000000002},null,{"$f":"H38-F38","v":0},null,{"$f":"J38/F38","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F38","v":244.82097000000002},null,{"$f":"H38","v":244.82097000000002},null,{"$f":"J38","v":0},null,{"$f":"J39/F39","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F35+F39","v":14174.891990770631},null,{"$f":"H35+H39","v":14286.774147217189},null,{"$f":"J35+J39","v":111.88215644655861},null,{"$f":"J41/F41","v":7.892981231843307E-3}]
[]
[]
[null,null,"Rate 6 - Medium Commercial",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F10","v":102},null,{"$f":"H10","v":103.52999999999999}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"First 1000 m3",null,"₵/m3",24.718900000000001,null,25.0896835]
[null,null,"Next 6000 m3",null,"₵/m3",22.247,null,22.580704999999998]
[null,null,"GT 7000m3",null,"₵/m3",21.134599999999999,null,21.451618999999997]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.5114,null,11.5114]
[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",3.91,null,3.91]
[]
[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,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F46*$E61","v":1224},null,{"$f":"H46*$E61","v":1242.3599999999999},null,{"$f":"H61-F61","v":18.3599999999999},null,{"$f":"J61/F61","v":1.4999999999999918E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"E62*F47","v":12},null,{"$f":"E62*H47","v":12},null,{"$f":"H62-F62","v":0},null,{"$f":"J62/F62","v":0}]
[null,null,"First 1000 m3",null,11715.326187183033,{"$f":"F48*$E63/100","v":2895.8997648835871},null,{"$f":"H48*$E63/100","v":2939.3382613568406},null,{"$f":"H63-F63","v":43.438496473253508},null,{"$f":"J63/F63","v":1.4999999999999897E-2}]
[null,null,"Next 6000 m3",null,40792.718418626093,9075.1560665917459,null,9211.2834075906212,null,136.1273409988753,null,1.4999999999999902E-2]
[null,null,"GT 7000m3",null,23176.955394190867,4898.3568147406631,null,4971.8321669617726,null,73.475352221109461,null,1.4999999999999901E-2]
[null,null,"Contracted Demand",null,0,0,null,0,null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Gas Supply",null,{"$f":"SUM(E63:E66)","v":75685},8712.4030899999998,null,8712.4030899999998,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E67","v":75685},2210.002,null,2210.002,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E68","v":75685},4269.6179050000001,null,4269.6179050000001,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E69","v":75685},2959.2835000000005,null,2959.2835000000005,null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F61:F70)","v":36256.719141215995},null,{"$f":"SUM(H61:H70)","v":36528.120330909231},null,{"$f":"SUM(J61:J70)","v":271.40118969323817},null,{"$f":"J71/F71","v":7.4855418835929393E-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":"E67","v":75685},{"$f":"$E74*F58/100","v":687.97665000000006},null,{"$f":"$E74*H58/100","v":687.97665000000006},null,{"$f":"H74-F74","v":0},null,{"$f":"J74/F74","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F74","v":687.97665000000006},null,{"$f":"H74","v":687.97665000000006},null,{"$f":"J74","v":0},null,{"$f":"J75/F75","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F71+F75","v":36944.695791215992},null,{"$f":"H71+H75","v":37216.096980909228},null,{"$f":"J71+J75","v":271.40118969323817},null,{"$f":"J77/F77","v":7.3461476371871164E-3}]

{"sheet":"G1.3 Rate 11 Bill Impact","index":21,"n_rows":76,"n_cols":12,"rows_kept":76,"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-2019-0264   Exhibit A - 2020 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":204},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C10:C$10))","v":207.05999999999997}]
[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.3546},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C12))","v":15.584918999999998}]
[null,null,"Tier 2",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C13))","v":15.3546},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C13))","v":15.584918999999998}]
[null,null,"Tier 3",null,"₵/m3",{"$f":"INDEX('B1.1 Current Distribution Rates'!$E$10:$Q$13,3,COUNTA($C$10:C14))","v":15.3546},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C14))","v":15.584918999999998}]
[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.5114},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,3,COUNTA($C$10:C16))","v":11.5114}]
[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":3.91},null,{"$f":"'E1.1 Proposed Dist Rates '!Q12","v":3.91}]
[]
[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'!E10","v":0.5524}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E25","v":2448},null,{"$f":"H10*$E25","v":2484.7199999999998},null,{"$f":"H25-F25","v":36.7199999999998},null,{"$f":"J25/F25","v":1.4999999999999918E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"$E26*F11","v":12},null,{"$f":"$E26*H11","v":12},null,0,null,0]
[null,null,"All Volumes",null,101499.48573593894,{"$f":"F12*$E27/100","v":15584.840036810481},null,{"$f":"H12*$E27/100","v":15818.612637362636},null,233.77260055215447,null,1.4999999999999824E-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(E27:E30)","v":101499.48573593894},11684.011801006876,null,11684.011801006876,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E31","v":101499.48573593894},35.727818979050511,null,35.727818979050511,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E32","v":101499.48573593894},1843.8396578790669,null,1843.8396578790669,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E33","v":101499.48573593894},{"$f":"$E34*F19/100","v":3968.629892275213},null,{"$f":"$E34*H19/100","v":3968.629892275213},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F25:F34)","v":35577.049206950687},null,{"$f":"SUM(H25:H34)","v":35847.541807502843},null,{"$f":"SUM(J25:J34)","v":270.49260055215427},null,7.6030083039969523E-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":"E31","v":101499.48573593894},{"$f":"$E38*F22/100","v":560.68315920532677},null,{"$f":"$E38*H22/100","v":560.68315920532677},null,{"$f":"H38-F38","v":0},null,{"$f":"J38/F38","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F38","v":560.68315920532677},null,{"$f":"H38","v":560.68315920532677},null,{"$f":"J38","v":0},null,{"$f":"J39/F39","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F35+F39","v":36137.732366156015},null,{"$f":"H35+H39","v":36408.224966708171},null,{"$f":"J35+J39","v":270.49260055215427},null,{"$f":"J41/F41","v":7.4850463170035002E-3}]
[]
[null,null,"Rate 11 - Large Seasonal Service Sample Dryer 2",null,"Units","Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,"$/month",{"$f":"F10","v":204},null,{"$f":"H10","v":207.05999999999997}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,"$/month",1,null,1]
[null,null,"All Volumes",null,"₵/m3",{"$f":"F12","v":15.3546},null,{"$f":"H12","v":15.584918999999998}]
[null,null,"Tier 2",null,"₵/m3",15.3546,null,15.584918999999998]
[null,null,"Tier 3",null,"₵/m3",15.3546,null,15.584918999999998]
[null,null,"Contracted Demand",null,"₵ / contracted m3",0,null,0]
[null,null,"Gas Supply",null,"₵/m3",11.5114,null,11.5114]
[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,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F45*$E60","v":2448},null,{"$f":"H45*$E60","v":2484.7199999999998},null,{"$f":"H60-F60","v":36.7199999999998},null,{"$f":"J60/F60","v":1.4999999999999918E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,12,{"$f":"$E61*F46","v":12},null,{"$f":"$E61*H46","v":12},null,{"$f":"H61-F61","v":0},null,{"$f":"J61/F61","v":0}]
[null,null,"All Volumes",null,338331.61911979644,{"$f":"F47*$E62/100","v":51949.466789368264},null,{"$f":"H47*$E62/100","v":52728.708791208781},null,{"$f":"H62-F62","v":779.24200184051733},null,{"$f":"J62/F62","v":1.4999999999999873E-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(E62:E65)","v":338331.61911979644},38946.706003356245,null,38946.706003356245,null,0,null,0]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"E66","v":338331.61911979644},119.09272993016835,null,119.09272993016835,null,0,null,0]
[null,null,"Transportation & \nStorage Charge",null,{"$f":"E67","v":338331.61911979644},6146.1321929302221,null,6146.1321929302221,null,0,null,0]
[null,null,"Federal Carbon Charge",null,{"$f":"E68","v":338331.61911979644},{"$f":"$E69*F54/100","v":13228.766307584041},null,{"$f":"$E69*H54/100","v":13228.766307584041},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F60:F69)","v":112850.16402316894},null,{"$f":"SUM(H60:H69)","v":113666.12602500946},null,{"$f":"SUM(J60:J69)","v":815.96200184051713},null,{"$f":"J70/F70","v":7.2304901716668691E-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":"E66","v":338331.61911979644},{"$f":"$E73*F57/100","v":1868.9438640177555},null,{"$f":"$E73*H57/100","v":1868.9438640177555},null,{"$f":"H73-F73","v":0},null,{"$f":"J73/F73","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F73","v":1868.9438640177555},null,{"$f":"H73","v":1868.9438640177555},null,{"$f":"J73","v":0},null,{"$f":"J74/F74","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F70+F74","v":114719.10788718669},null,{"$f":"H70+H74","v":115535.06988902722},null,{"$f":"J70+J74","v":815.96200184051713},null,{"$f":"J76/F76","v":7.1126947974780603E-3}]

{"sheet":"G1.4 Rate 16 Bill Impact","index":22,"n_rows":45,"n_cols":12,"rows_kept":45,"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-2019-0264   Exhibit A - 2020 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":1500},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C10))","v":1522.4999999999998}]
[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":102.3139},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C15))","v":103.8486085}]
[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":3.91},null,{"$f":"INDEX('E1.1 Proposed Dist Rates '!$E$10:$Q$13,4,COUNTA($C$10:C21)+1)","v":3.91}]
[]
[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'!E11","v":6.0100000000000001E-2}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F10*$E27","v":18000},null,{"$f":"H10*$E27","v":18269.999999999996},null,{"$f":"H27-F27","v":269.99999999999636},null,{"$f":"J27/F27","v":1.4999999999999798E-2}]
[null,null,{"$f":"OneDollar","v":"Bill 32 Rate"},null,{"$f":"E27","v":12},{"$f":"$E28*F11","v":12},null,{"$f":"$E28*H11","v":12},null,0,null,0]
[null,null,"Tier 1",null,0,{"$f":"F12*$E29/100","v":0},null,{"$f":"H12*$E29/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 2",null,0,{"$f":"F13*$E30/100","v":0},null,{"$f":"H13*$E30/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Tier 3",null,0,{"$f":"F14*$E31/100","v":0},null,{"$f":"H14*$E31/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Contracted Demand",null,50000,{"$f":"F15*$E32/100*$E$27","v":613883.39999999991},null,{"$f":"H15*$E32/100*$E$27","v":623091.65100000007},null,9208.2510000001639,null,1.500000000000027E-2]
[null,null,"Gas Supply",null,0,{"$f":"F16*$E33/100","v":0},null,{"$f":"H16*$E33/100","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Upstream Recovery \nCharge",null,{"$f":"$E$32","v":50000},{"$f":"F17*$E34/100*$E$27","v":85460.4},null,{"$f":"H17*$E34/100*$E$27","v":85460.4},null,0,null,0]
[null,null,"Transportation Charge From Dawn",null,{"$f":"$E$32","v":50000},{"$f":"F18*$E35/100*$E$27","v":109799.40000000001},null,{"$f":"H18*$E35/100*$E$27","v":109799.40000000001},null,0,null,0]
[null,null,"Transportation Charge \nFrom Kirkwall",null,0,{"$f":"F19*$E36/100*$E$27","v":0},null,{"$f":"H19*$E36/100*$E$27","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Transportation Charge From Parkway",null,0,{"$f":"F20*$E37/100*$E$27","v":0},null,{"$f":"H20*$E37/100*$E$27","v":0},null,0,null,{"$error":"#DIV/0!"}]
[null,null,"Federal Carbon Charge",null,{"$f":"$E$32","v":50000},{"$f":"$E38*F21/100*$E$27","v":23460},null,{"$f":"$E38*H21/100*$E$27","v":23460},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F27:F38)","v":850615.2},null,{"$f":"SUM(H27:H38)","v":860093.45100000012},null,{"$f":"SUM(J27:J38)","v":9478.2510000001603},null,1.1142818750476315E-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":"E27","v":12},{"$f":"$E$42*$E32*$F24/100","v":360.6},null,{"$f":"$E$42*$E32*$H24/100","v":360.6},null,{"$f":"H42-F42","v":0},null,{"$f":"J42/F42","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"F42","v":360.6},null,{"$f":"H42","v":360.6},null,{"$f":"J42","v":0},null,{"$f":"J43/F43","v":0}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"F39+F43","v":850975.79999999993},null,{"$f":"H39+H43","v":860454.05100000009},null,{"$f":"J39+J43","v":9478.2510000001603},null,{"$f":"J45/F45","v":1.113809699406277E-2}]

{"sheet":"G1.7 Summary of Bill Impacts","index":23,"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-2019-0264   Exhibit A - 2020 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 Rider","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'!J27","v":4.4999999999999432},{"$f":"'G1.1 Rate 1 Bill Impact'!J28","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J29:J32)","v":8.5464405587551937},{"$f":"'G1.1 Rate 1 Bill Impact'!J41","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J34","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J35","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J36","v":0},{"$f":"SUM(E10:K10)","v":13.046440558755137},{"$f":"'G1.1 Rate 1 Bill Impact'!L43","v":9.7512689556157901E-3}]
[null,null,"Rate 1","New Residential",{"$f":"'G1.1 Rate 1 Bill Impact'!J63","v":4.4999999999999432},{"$f":"'G1.1 Rate 1 Bill Impact'!J64","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J65:J66)","v":8.2187683823377711},{"$f":"'G1.1 Rate 1 Bill Impact'!J77","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J70","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J71","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J72","v":0},{"$f":"SUM(E11:K11)","v":12.718768382337714},{"$f":"'G1.1 Rate 1 Bill Impact'!L79","v":9.7952757788482541E-3}]
[null,null,"Rate 1","Small Commercial",{"$f":"'G1.1 Rate 1 Bill Impact'!J98","v":4.4999999999999432},{"$f":"'G1.1 Rate 1 Bill Impact'!J99","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J100:J103)","v":18.466820045564418},{"$f":"'G1.1 Rate 1 Bill Impact'!J112","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J105","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J106","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J107","v":0},22.966820045564361,{"$f":"'G1.1 Rate 1 Bill Impact'!L114","v":9.0445987536450449E-3}]
[null,null,"Rate 1","Small Agricultural",{"$f":"'G1.1 Rate 1 Bill Impact'!J133","v":4.4999999999999432},{"$f":"'G1.1 Rate 1 Bill Impact'!J134","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J135:J138)","v":18.571224070383323},{"$f":"'G1.1 Rate 1 Bill Impact'!J147","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J140","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J141","v":0},{"$f":"'G1.1 Rate 1 Bill Impact'!J142","v":0},23.071224070383266,{"$f":"'G1.1 Rate 1 Bill Impact'!L149","v":9.0405293398410653E-3}]
[null,null,"Rate 6","Medium Commercial",{"$f":"'G1.2 Rate 6 Bill Impact'!J25","v":18.3599999999999},{"$f":"'G1.2 Rate 6 Bill Impact'!J26","v":0},{"$f":"SUM('G1.2 Rate 6 Bill Impact'!J27:J30)","v":93.522156446558711},{"$f":"'G1.2 Rate 6 Bill Impact'!J39","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J32","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J33","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J34","v":0},111.88215644655861,{"$f":"'G1.2 Rate 6 Bill Impact'!L41","v":7.892981231843307E-3}]
[null,null,"Rate 6","Large Commercial",{"$f":"'G1.2 Rate 6 Bill Impact'!J61","v":18.3599999999999},{"$f":"'G1.2 Rate 6 Bill Impact'!J62","v":0},{"$f":"SUM('G1.2 Rate 6 Bill Impact'!J63:J66)","v":253.04118969323827},{"$f":"'G1.2 Rate 6 Bill Impact'!J75","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J68","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J69","v":0},{"$f":"'G1.2 Rate 6 Bill Impact'!J70","v":0},271.40118969323817,{"$f":"'G1.2 Rate 6 Bill Impact'!L77","v":7.3461476371871164E-3}]
[null,null,"Rate 11","Sample Dryer 1",{"$f":"'G1.3 Rate 11 Bill Impact'!J25","v":36.7199999999998},{"$f":"'G1.3 Rate 11 Bill Impact'!J26","v":0},{"$f":"SUM('G1.3 Rate 11 Bill Impact'!J27:J30)","v":233.77260055215447},{"$f":"'G1.3 Rate 11 Bill Impact'!J39","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J32","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J33","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J34","v":0},270.49260055215427,{"$f":"'G1.3 Rate 11 Bill Impact'!L41","v":7.4850463170035002E-3}]
[null,null,"Rate 11","Sample Dryer 2",{"$f":"'G1.3 Rate 11 Bill Impact'!J60","v":36.7199999999998},{"$f":"'G1.3 Rate 11 Bill Impact'!J61","v":0},{"$f":"SUM('G1.3 Rate 11 Bill Impact'!J62:J65)","v":779.24200184051733},{"$f":"'G1.3 Rate 11 Bill Impact'!J74","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J67","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J68","v":0},{"$f":"'G1.3 Rate 11 Bill Impact'!J69","v":0},815.96200184051713,{"$f":"'G1.3 Rate 11 Bill Impact'!L76","v":7.1126947974780603E-3}]
[null,null,"Rate 16","Contracted Demand",{"$f":"'G1.4 Rate 16 Bill Impact'!J27","v":269.99999999999636},{"$f":"'G1.4 Rate 16 Bill Impact'!J28","v":0},{"$f":"SUM('G1.4 Rate 16 Bill Impact'!J29:J32)","v":9208.2510000001639},{"$f":"'G1.4 Rate 16 Bill Impact'!J43","v":0},{"$f":"'G1.4 Rate 16 Bill Impact'!J34","v":0},{"$f":"SUM('G1.4 Rate 16 Bill Impact'!J35:J37)","v":0},{"$f":"'G1.4 Rate 16 Bill Impact'!J38","v":0},9478.2510000001603,{"$f":"'G1.4 Rate 16 Bill Impact'!L45","v":1.113809699406277E-2}]