{"text_format":"1","workbook":"xlsx","n_sheets":28,"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 2 Adjustment","D1.3 Rate 3 Adjustment","D1.4 Rate 4 Adjustment","D1.5 Rate 5 Adjustment","D1.6 Rate 6 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 Proposed Rate Riders","F2.1 Deferred Revenue Recovery","G1.1 Rate 1 Bill Impact","G1.2 Rate 2 Bill Impact","G1.3 Rate 3 Bill Impact","G1.4 Rate 4 Bill Impact","G1.5 Rate 5 Bill Impact","G1.6 Rate 6 Bill Impact","G1.7 Summary of Bill Impacts"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"A1.1 Distributor Information","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":" \"Name of LDC:       \" &D21","v":"Name of LDC:       EPCOR Natural Gas Limited Partnership"}]
[null,null,{"$f":" \"OEB Application Number:          \" & D23","v":"OEB Application Number:          EB-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Distributor Information"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Distributor Name","EPCOR Natural Gas Limited Partnership"]
[]
[null,null,"OEB Application Number","EB-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"]
[]
[]
[]
[]
[]
[]
[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":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,2,25,13],[26,2,26,13]]}
[]
[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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Current Distribution Tariff Sheet Rates"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Monthly  Service Charge","Delivery\nFirst 1,000 m3","Delivery\nOver 1,000 m3","Delivery\nNext 24,000 m3","Delivery\nOver 25,000 m3","Delivery - Firm","Demand - Firm","Commodity","Delivery - Int - Lower","Delivery - Int - Upper"]
[null,null,"RATE 1 - General Service Rate - Residential",null,13.5,16.231200000000001,10.9099,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 1 - General Service Rate - Commercial",null,13.5,16.231200000000001,10.9099,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 1 - General Service Rate - Industrial",null,13.5,16.231200000000001,10.9099,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,15,15.821199999999999,null,9.4825999999999997,6.1698000000000004,null,null,3.6299999999999999E-2]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,15,19.942399999999999,null,15.696,15.289899999999999,null,null,3.6299999999999999E-2]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,150,null,null,null,null,4.0357000000000003,29.0974,3.6299999999999999E-2,7.9412000000000003,10.9612]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,15,15.8149,10.521800000000001,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,15,20.1755,16.905200000000001,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,150,null,null,null,null,7.1994999999999996,1,3.6299999999999999E-2,5.4611999999999998,8.4611999999999998]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,150,null,null,null,null,3.8894000000000002,18.839200000000002,null,7.9412000000000003,10.9612]
[]
[null,null,"1 Placeholder rate for average application"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"B1.1 Current Distribution Rates"}]

{"sheet":"B1.2 Billing Determinants","index":2,"n_rows":30,"n_cols":14,"rows_kept":30,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Billing Determinants - Actuals October 1, 2016 to September 30, 2017"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Monthly  Service Charge","Delivery\nFirst 1,000 m3","Delivery\nOver 1,000 m3","Delivery\nNext 24,000 m3","Delivery\nOver 25,000 m3","Delivery - Firm","Demand - Firm","Commodity","Delivery - Int - Lower","Delivery - Int - Upper"]
[null,null,"RATE 1 - General Service Rate - Residential",null,8148,{"$f":"L16-SUM(G16:K16)","v":13875993.481266305},{"$f":"L16*(733800/13103581)","v":823151.51873369585},null,null,null,null,14699145]
[null,null,"RATE 1 - General Service Rate - Commercial",null,462,{"$f":"L17-SUM(G17:K17)","v":1843267.5518121859},{"$f":"L17*2371550/4131750","v":2483468.4481878141},null,null,null,null,4326736]
[null,null,"RATE 1 - General Service Rate - Industrial",null,66,{"$f":"L18-SUM(G18:K18)","v":338676.82683753944},{"$f":"L18*466928/598028","v":1206237.1731624606},null,null,null,null,1544914]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,53,{"$f":"L19-SUM(G19:K19)","v":383293.93127922353},null,{"$f":"$L19*(329621/453400)","v":1020704.0687207765},0,null,null,1403998]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,53,{"$f":"L20-SUM(G20:K20)","v":5767.2363930448846},null,{"$f":"$L20*(43772/49460)","v":44381.763606955115},0,null,null,50149]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,5,null,null,null,null,{"$f":"1485572","v":1485572},224723,{"$f":"J21","v":1485572}]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,36,{"$f":"L22-SUM(G22:K22)","v":231194.94509342586},{"$f":"L22*221214/436924","v":237094.05490657414},null,null,null,null,468289]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,36,{"$f":"L23-SUM(G23:K23)","v":112019.62487022724},{"$f":"L23*12970/17338","v":332622.37512977276},null,null,null,null,444642]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,4,null,null,null,null,553894,null,{"$f":"J24","v":553894}]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,1,null,null,null,null,38423518,1606140]
[null,null,null,null,{"$f":"SUM(E16:E19,E21:E22,E24:E25)","v":8775},{"$f":"SUM(F16:F25)","v":16790213.597551953},5082573.5701203169,1065085.8323277317,0,40462984,1830863,24977339,{"$f":"SUM(M16:M25)","v":0},{"$f":"SUM(N16:N25)","v":0}]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"B1.2 Billing Determinants"}]

{"sheet":"B1.3 Current Rev From Rates","index":3,"n_rows":29,"n_cols":15,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Revenue from Current Rates"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Monthly  Service Charge","Delivery\nFirst 1,000 m3","Delivery\nOver 1,000 m3","Delivery\nNext 24,000 m3","Delivery\nOver 25,000 m3","Demand - Firm","Delivery - Firm","Commodity","Delivery - Int - Lower","Delivery - Int - Upper","Total"]
[null,null,"RATE 1 - General Service Rate - Residential",null,{"$f":"'B1.1 Current Distribution Rates'!E16*'B1.2 Billing Determinants'!E16*12","v":1319976},{"$f":"'B1.1 Current Distribution Rates'!F16*'B1.2 Billing Determinants'!F16/100","v":2252240.253931297},{"$f":"'B1.1 Current Distribution Rates'!G16*'B1.2 Billing Determinants'!G16/100","v":89805.007542327498},{"$f":"'B1.1 Current Distribution Rates'!H16*'B1.2 Billing Determinants'!H16/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!I16*'B1.2 Billing Determinants'!I16/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J16*'B1.2 Billing Determinants'!J16/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!K16*'B1.2 Billing Determinants'!K16/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L16*'B1.2 Billing Determinants'!L16/100","v":5335.7896349999992},{"$f":"'B1.1 Current Distribution Rates'!M16*'B1.2 Billing Determinants'!M16/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N16*'B1.2 Billing Determinants'!N16/100","v":0},{"$f":"SUM(E16:N16)","v":3667357.0511086243}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'B1.1 Current Distribution Rates'!E17*'B1.2 Billing Determinants'!E17*12","v":74844},{"$f":"'B1.1 Current Distribution Rates'!F17*'B1.2 Billing Determinants'!F17/100","v":299184.44286973955},{"$f":"'B1.1 Current Distribution Rates'!G17*'B1.2 Billing Determinants'!G17/100","v":270943.92422884231},{"$f":"'B1.1 Current Distribution Rates'!H17*'B1.2 Billing Determinants'!H17/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!I17*'B1.2 Billing Determinants'!I17/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J17*'B1.2 Billing Determinants'!J17/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!K17*'B1.2 Billing Determinants'!K17/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L17*'B1.2 Billing Determinants'!L17/100","v":1570.6051679999998},{"$f":"'B1.1 Current Distribution Rates'!M17*'B1.2 Billing Determinants'!M17/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N17*'B1.2 Billing Determinants'!N17/100","v":0},{"$f":"SUM(E17:N17)","v":646542.97226658184}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'B1.1 Current Distribution Rates'!E18*'B1.2 Billing Determinants'!E18*12","v":10692},{"$f":"'B1.1 Current Distribution Rates'!F18*'B1.2 Billing Determinants'!F18/100","v":54971.313117654703},{"$f":"'B1.1 Current Distribution Rates'!G18*'B1.2 Billing Determinants'!G18/100","v":131599.26935485128},{"$f":"'B1.1 Current Distribution Rates'!H18*'B1.2 Billing Determinants'!H18/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!I18*'B1.2 Billing Determinants'!I18/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J18*'B1.2 Billing Determinants'!J18/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!K18*'B1.2 Billing Determinants'!K18/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L18*'B1.2 Billing Determinants'!L18/100","v":560.80378199999996},{"$f":"'B1.1 Current Distribution Rates'!M18*'B1.2 Billing Determinants'!M18/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N18*'B1.2 Billing Determinants'!N18/100","v":0},197823.38625450598]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'B1.1 Current Distribution Rates'!E19*'B1.2 Billing Determinants'!E19*7","v":5565},{"$f":"'B1.1 Current Distribution Rates'!F19*'B1.2 Billing Determinants'!F19/100","v":60641.699455548507},{"$f":"'B1.1 Current Distribution Rates'!G19*'B1.2 Billing Determinants'!G19/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!H19*'B1.2 Billing Determinants'!H19/100","v":96789.284020516352},{"$f":"'B1.1 Current Distribution Rates'!I19*'B1.2 Billing Determinants'!I19/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J19*'B1.2 Billing Determinants'!J19/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!K19*'B1.2 Billing Determinants'!K19/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L19*'B1.2 Billing Determinants'!L19/100","v":509.651274},{"$f":"'B1.1 Current Distribution Rates'!M19*'B1.2 Billing Determinants'!M19/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N19*'B1.2 Billing Determinants'!N19/100","v":0},163505.63475006487]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'B1.1 Current Distribution Rates'!E20*'B1.2 Billing Determinants'!E20*5","v":3975},{"$f":"'B1.1 Current Distribution Rates'!F20*'B1.2 Billing Determinants'!F20/100","v":1150.1253504465831},{"$f":"'B1.1 Current Distribution Rates'!G20*'B1.2 Billing Determinants'!G20/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!H20*'B1.2 Billing Determinants'!H20/100","v":6966.1616157476747},{"$f":"'B1.1 Current Distribution Rates'!I20*'B1.2 Billing Determinants'!I20/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J20*'B1.2 Billing Determinants'!J20/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!K20*'B1.2 Billing Determinants'!K20/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L20*'B1.2 Billing Determinants'!L20/100","v":18.204087000000001},{"$f":"'B1.1 Current Distribution Rates'!M20*'B1.2 Billing Determinants'!M20/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N20*'B1.2 Billing Determinants'!N20/100","v":0},12109.491053194257]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.1 Current Distribution Rates'!E21*'B1.2 Billing Determinants'!E21*12","v":9000},{"$f":"'B1.1 Current Distribution Rates'!F21*'B1.2 Billing Determinants'!F21/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!G21*'B1.2 Billing Determinants'!G21/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!H21*'B1.2 Billing Determinants'!H21/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!I21*'B1.2 Billing Determinants'!I21/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J21*'B1.2 Billing Determinants'!J21/100","v":59953.229204000003},{"$f":"'B1.1 Current Distribution Rates'!K21*'B1.2 Billing Determinants'!K21/100","v":65388.550201999999},{"$f":"'B1.1 Current Distribution Rates'!L21*'B1.2 Billing Determinants'!L21/100","v":539.26263599999993},{"$f":"'B1.1 Current Distribution Rates'!M21*'B1.2 Billing Determinants'!M21/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N21*'B1.2 Billing Determinants'!N21/100","v":0},134881.04204199999]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,{"$f":"'B1.1 Current Distribution Rates'!E22*'B1.2 Billing Determinants'!E22*9","v":4860},{"$f":"'B1.1 Current Distribution Rates'!F22*'B1.2 Billing Determinants'!F22/100","v":36563.249371580205},{"$f":"'B1.1 Current Distribution Rates'!G22*'B1.2 Billing Determinants'!G22/100","v":24946.56226915992},{"$f":"'B1.1 Current Distribution Rates'!H22*'B1.2 Billing Determinants'!H22/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!I22*'B1.2 Billing Determinants'!I22/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J22*'B1.2 Billing Determinants'!J22/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!K22*'B1.2 Billing Determinants'!K22/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L22*'B1.2 Billing Determinants'!L22/100","v":169.98890700000001},{"$f":"'B1.1 Current Distribution Rates'!M22*'B1.2 Billing Determinants'!M22/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N22*'B1.2 Billing Determinants'!N22/100","v":0},66539.800547740131]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,{"$f":"'B1.1 Current Distribution Rates'!E23*'B1.2 Billing Determinants'!E23*3","v":1620},{"$f":"'B1.1 Current Distribution Rates'!F23*'B1.2 Billing Determinants'!F23/100","v":22600.519415692695},{"$f":"'B1.1 Current Distribution Rates'!G23*'B1.2 Billing Determinants'!G23/100","v":56230.477760438349},{"$f":"'B1.1 Current Distribution Rates'!H23*'B1.2 Billing Determinants'!H23/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!I23*'B1.2 Billing Determinants'!I23/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J23*'B1.2 Billing Determinants'!J23/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!K23*'B1.2 Billing Determinants'!K23/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L23*'B1.2 Billing Determinants'!L23/100","v":161.405046},{"$f":"'B1.1 Current Distribution Rates'!M23*'B1.2 Billing Determinants'!M23/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N23*'B1.2 Billing Determinants'!N23/100","v":0},80612.402222131044]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.1 Current Distribution Rates'!E24*'B1.2 Billing Determinants'!E24*12","v":7200},{"$f":"'B1.1 Current Distribution Rates'!F24*'B1.2 Billing Determinants'!F24/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!G24*'B1.2 Billing Determinants'!G24/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!H24*'B1.2 Billing Determinants'!H24/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!I24*'B1.2 Billing Determinants'!I24/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J24*'B1.2 Billing Determinants'!J24/100","v":39877.598529999996},{"$f":"'B1.1 Current Distribution Rates'!K24*'B1.2 Billing Determinants'!K24/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!L24*'B1.2 Billing Determinants'!L24/100","v":201.06352200000001},{"$f":"'B1.1 Current Distribution Rates'!M24*'B1.2 Billing Determinants'!M24/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N24*'B1.2 Billing Determinants'!N24/100","v":0},47278.662051999992]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.1 Current Distribution Rates'!E25*'B1.2 Billing Determinants'!E25*12","v":1800},{"$f":"'B1.1 Current Distribution Rates'!F25*'B1.2 Billing Determinants'!F25/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!G25*'B1.2 Billing Determinants'!G25/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!H25*'B1.2 Billing Determinants'!H25/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!I25*'B1.2 Billing Determinants'!I25/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!J25*'B1.2 Billing Determinants'!J25/100","v":1494444.3090920001},{"$f":"'B1.1 Current Distribution Rates'!K25*'B1.2 Billing Determinants'!K25/100","v":302583.92687999998},{"$f":"'B1.1 Current Distribution Rates'!L25*'B1.2 Billing Determinants'!L25/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!M25*'B1.2 Billing Determinants'!M25/100","v":0},{"$f":"'B1.1 Current Distribution Rates'!N25*'B1.2 Billing Determinants'!N25/100","v":0},1798828.2359720001]
[null,null,null,null,{"$f":"SUM(E16:E25)","v":1439532},{"$f":"SUM(F16:F25)","v":2727351.6035119593},573525.24115561938,103755.44563626402,0,1594275.1368260002,367972.477082,9066.7740570000005,0,0,6815478.6782688424]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"B1.3 Current Rev From Rates"}]

{"sheet":"C1.1 Current Rate Riders","index":4,"n_rows":29,"n_cols":5,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Current Rate Riders"]
[]
[null,null,"Description",null,"Shared Tax Changes"]
[null,null,"Effective Until",null,"September 30, 2016"]
[null,null,null,null,"per customer per month assuming all months"]
[null,null,"Rate Group"]
[null,null,"RATE 1 - General Service Rate - Residential",null,0.13]
[null,null,"RATE 1 - General Service Rate - Commercial",null,0.13]
[null,null,"RATE 1 - General Service Rate - Industrial",null,0.13]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,0.24]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,0.24]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,10.53]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,0.69]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,0.69]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,3.81]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,380.13]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"C1.1 Current Rate Riders"}]

{"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[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'!O16:O18)","v":4511723.4096297119},null,{"$f":"E16/$E$22","v":0.66198188309433714},null,{"$f":"$I$22*G16","v":16465.294837691876},null,{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":8676},null,12,null,{"$f":"I16/K16/M16","v":0.15814982747129894}]
[null,null,"RATE 2 - Seasonal Service ",null,{"$f":"SUM('B1.3 Current Rev From Rates'!O19:O20)","v":175615.12580325911},null,2.5767100755990632E-2,null,640.89806971263977,null,{"$f":"'B1.2 Billing Determinants'!E19","v":53},null,12,null,{"$f":"I17/K17/M17","v":1.007701367472704}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.3 Current Rev From Rates'!O21","v":134881.04204199999},null,1.9790398944694563E-2,null,492.2411955698575,null,{"$f":"'B1.2 Billing Determinants'!E21","v":5},null,12,null,8.2040199261642908]
[null,null,"RATE 4 - General Service Peaking",null,{"$f":"SUM('B1.3 Current Rev From Rates'!O22:O23)","v":147152.20276987116},null,2.1590883005630411E-2,null,537.02414457640725,null,{"$f":"'B1.2 Billing Determinants'!E22","v":36},null,12,null,1.2431114457787205]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.3 Current Rev From Rates'!O24","v":47278.662051999992},null,6.9369539960190962E-3,null,172.54096484643861,null,{"$f":"'B1.2 Billing Determinants'!E24","v":4},null,12,null,3.5946034343008044]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.3 Current Rev From Rates'!O25","v":1798828.2359720001},null,0.26393278020332817,null,6564.7280603300533,null,{"$f":"'B1.2 Billing Determinants'!E25","v":1},null,12,null,547.06067169417111]
[null,null,null,null,{"$f":"SUM(E16:E21)","v":6815478.6782688424},null,{"$f":"SUM(G16:G21)","v":1},null,{"$f":"'C2.1 Regulatory Cost Adjustment'!E16","v":24872.727272727272},null,{"$f":"SUM(K16:K21)","v":8775}]
[]
[]
[]
[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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[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":30,"n_cols":12,"rows_kept":30,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[null,null,"Rate 1 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"E24","v":2.1000000000000001E-2}]
[null,null,"Less Productivity",null,0]
[null,null,"Less Stretch Factor",null,{"$f":"I27","v":4.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":1.7000000000000001E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue",null,"Balanced Rates","Revenue"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I16","v":13.5},{"$f":"E14","v":1.7000000000000001E-2},{"$f":"E17*(1+F17)","v":13.729499999999998},{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":8676},{"$f":"G17*H17*12","v":1429405.7039999997},"No Change",{"$f":"E17+H11","v":13.5},{"$f":"H17*K17*12","v":1405512}]
[null,null,"Delivery\nFirst 1,000 m3",null,{"$f":"'B1.1 Current Distribution Rates'!F16","v":16.231200000000001},{"$f":"E14","v":1.7000000000000001E-2},{"$f":"E18*(1+F18)","v":16.507130400000001},{"$f":"SUM('B1.2 Billing Determinants'!F16:F18)","v":16057937.859916031},{"$f":"G18*H18/100","v":2650704.7420873088},"Re-Balance",{"$f":"L18/H18*100","v":16.656717766606427},{"$f":"($I$21-SUM($L$17,$L$20,$L$19))","v":2674725.3884632536}]
[null,null,"Delivery\nOver 1,000 m3",null,{"$f":"'B1.1 Current Distribution Rates'!G16","v":10.9099},{"$f":"E14","v":1.7000000000000001E-2},11.095368299999999,{"$f":"SUM('B1.2 Billing Determinants'!G16:G18)","v":4512857.1400839705},{"$f":"G19*H19/100","v":500718.1205451634},"Change",{"$f":"G19","v":11.095368299999999},{"$f":"H19*K19/100","v":500718.1205451634}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L16","v":3.6299999999999999E-2},{"$f":"E14","v":1.7000000000000001E-2},3.6917099999999994E-2,{"$f":"SUM('B1.2 Billing Determinants'!L16:L18)","v":20570795},7594.1409609449993,"No Change",{"$f":"E20","v":3.6299999999999999E-2},{"$f":"H20*K20/100","v":7467.1985850000001}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I20)","v":4588422.7075934168},null,null,{"$f":"SUM(L17:L20)","v":4588422.7075934168}]
[]
[null,null,"Data from 2014 IRM Rate Generator for Electric LDC.",null,null,null,null,null,null,null,null,{"$f":"I21-L21","v":0}]
[null,null,"Price Escalator",null,2.1000000000000001E-2,"Choose Stretch Factor Group",null,null,"III","Mid Group"]
[null,null,"Productivity Factor",null,0,"Associated Stretch Factor Value",null,null,3.0000000000000001E-3]
[null,null,"Price Cap Index",null,{"$f":"E24-E25-I27","v":1.7000000000000001E-2},"Settlement Agreement Adjustment",null,null,1E-3]
[null,null,null,null,null,"Total Stretch Factor",null,null,{"$f":"SUM(I25:I26)","v":4.0000000000000001E-3}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.1 Rate 1 Adjustment"}]

{"sheet":"D1.2 Rate 2 Adjustment","index":9,"n_rows":31,"n_cols":12,"rows_kept":31,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[null,null,"Rate 2 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":2.1000000000000001E-2}]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":0}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":4.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":1.7000000000000001E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue",null,"Balanced Rates","Revenue"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I19","v":15},{"$f":"$E$14","v":1.7000000000000001E-2},{"$f":"E17*(1+F17)","v":15.254999999999999},{"$f":"'B1.2 Billing Determinants'!E19","v":53},{"$f":"G17*H17*12","v":9702.18},"No Change",{"$f":"E17+H11","v":15},{"$f":"H17*K17*12","v":9540}]
[null,null,"Delivery First 1,000 m3 - Apr To Oct",null,{"$f":"'B1.1 Current Distribution Rates'!F19","v":15.821199999999999},{"$f":"$E$14","v":1.7000000000000001E-2},{"$f":"E18*(1+F18)","v":16.090160399999998},{"$f":"'B1.2 Billing Determinants'!F19","v":383293.93127922353},{"$f":"G18*H18/100","v":61672.608346292836},"Re-Balance",{"$f":"L18/H18*100","v":16.585597468927183},{"$f":"(I18/($I$18+$I$21))*(I25-SUM(L17,L19:L20,L22:L24))","v":63571.588564798396}]
[null,null,"Delivery Next 24,000 m3 - Apr To Oct",null,{"$f":"'B1.1 Current Distribution Rates'!H19","v":9.4825999999999997},1.7000000000000001E-2,9.6438041999999982,{"$f":"'B1.2 Billing Determinants'!H19","v":1020704.0687207765},{"$f":"G19*H19/100","v":98434.701848865108},"No Change",{"$f":"E19","v":9.4825999999999997},{"$f":"H19*K19/100","v":96789.284020516352}]
[null,null,"Delivery Over 25,000 m3 - Apr To Oct",null,{"$f":"'B1.1 Current Distribution Rates'!I19","v":6.1698000000000004},1.7000000000000001E-2,6.2746865999999999,{"$f":"'B1.2 Billing Determinants'!I19","v":0},0,"No Change",{"$f":"E20","v":6.1698000000000004},0]
[null,null,"Delivery First 1,000 m3 - Nov To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!F20","v":19.942399999999999},1.7000000000000001E-2,20.281420799999996,{"$f":"'B1.2 Billing Determinants'!F20","v":5767.2363930448846},1169.6774814041748,"Re-Balance",{"$f":"L21/H21*100","v":20.905912254717308},{"$f":"(I21/($I$18+$I$21))*(I25-SUM(L17,L19:L20,L22:L24))","v":1205.693379852087}]
[null,null,"Delivery Next 24,000 m3 - Nov To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!H20","v":15.696},1.7000000000000001E-2,15.962831999999999,{"$f":"'B1.2 Billing Determinants'!H20","v":44381.763606955115},7084.5863632153851,"No Change",{"$f":"E22","v":15.696},{"$f":"H22*K22/100","v":6966.1616157476747}]
[null,null,"Delivery Over 25,000 m3 - Nov To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!I20","v":15.289899999999999},1.7000000000000001E-2,15.549828299999998,{"$f":"'B1.2 Billing Determinants'!I20","v":0},0,"No Change",{"$f":"E23","v":15.289899999999999},0]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L19","v":3.6299999999999999E-2},1.7000000000000001E-2,3.6917099999999994E-2,{"$f":"SUM('B1.2 Billing Determinants'!L19:L20)","v":1454147},536.82890213699989,"No Change",3.6299999999999999E-2,527.85536100000002]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I24)","v":178600.5829419145},null,null,{"$f":"SUM(L17:L24)","v":178600.58294191447}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I25-L25","v":0}]
[]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.2 Rate 2 Adjustment"}]

{"sheet":"D1.3 Rate 3 Adjustment","index":10,"n_rows":26,"n_cols":12,"rows_kept":26,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[null,null,"Rate 3 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":2.1000000000000001E-2}]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":0}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":4.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":1.7000000000000001E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue",null,"Balanced Rates","Revenue"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I21","v":150},{"$f":"E14","v":1.7000000000000001E-2},{"$f":"E17*(1+F17)","v":152.54999999999998},{"$f":"'B1.2 Billing Determinants'!E21","v":5},{"$f":"G17*H17*12","v":9152.9999999999982},"No Change",{"$f":"E17+H11","v":150},{"$f":"H17*K17*12","v":9000}]
[null,null,"Delivery Firm",null,{"$f":"'B1.1 Current Distribution Rates'!J21","v":4.0357000000000003},{"$f":"E14","v":1.7000000000000001E-2},{"$f":"E18*(1+F18)","v":4.1043069000000001},{"$f":"'B1.2 Billing Determinants'!J21","v":1485572},{"$f":"G18*H18/100","v":60972.434100468003},"Re-Balance",{"$f":"L18/H18*100","v":4.1900498204539396},{"$f":"I21-(L17+L19+L20)","v":62246.206918714}]
[null,null,"Demand Firm",null,{"$f":"'B1.1 Current Distribution Rates'!K21","v":29.0974},{"$f":"E14","v":1.7000000000000001E-2},29.592055799999997,{"$f":"'B1.2 Billing Determinants'!K21","v":224723},{"$f":"G19*H19/100","v":66500.155555434001},"No Change",29.0974,{"$f":"H19*K19/100","v":65388.550201999999}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L21","v":3.6299999999999999E-2},{"$f":"E14","v":1.7000000000000001E-2},3.6917099999999994E-2,{"$f":"'B1.2 Billing Determinants'!L21","v":1485572},548.43010081199998,"No Change",{"$f":"E20","v":3.6299999999999999E-2},{"$f":"H20*K20/100","v":539.26263599999993}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I20)","v":137174.019756714},null,null,{"$f":"SUM(L17:L20)","v":137174.019756714}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I21-L21","v":0}]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.3 Rate 3 Adjustment"}]

{"sheet":"D1.4 Rate 4 Adjustment","index":11,"n_rows":28,"n_cols":12,"rows_kept":28,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[null,null,"Rate 4 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":2.1000000000000001E-2}]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":0}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":4.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":1.7000000000000001E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue",null,"Balanced Rates","Revenue"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I22","v":15},{"$f":"$E$14","v":1.7000000000000001E-2},{"$f":"E17*(1+F17)","v":15.254999999999999},{"$f":"'B1.2 Billing Determinants'!E22","v":36},{"$f":"G17*H17*12","v":6590.16},"No Change",{"$f":"E17+H11","v":15},{"$f":"H17*K17*12","v":6480}]
[null,null,"Delivery First 1,000 m3 - Apr To Dec",null,{"$f":"'B1.1 Current Distribution Rates'!F22","v":15.8149},{"$f":"$E$14","v":1.7000000000000001E-2},{"$f":"E18*(1+F18)","v":16.083753299999998},{"$f":"'B1.2 Billing Determinants'!F22","v":231194.94509342586},{"$f":"G18*H18/100","v":37184.824610897063},"Re-Balance",{"$f":"L18/H18*100","v":16.483592277856697},{"$f":"(I18/($I$18+$I$20))*($I$23-SUM($L$17,$L$19,$L$21:$L$22))","v":38109.232116214982}]
[null,null,"Delivery Over 1,000 m3 - Apr To Dec",null,{"$f":"'B1.1 Current Distribution Rates'!G22","v":10.521800000000001},1.7000000000000001E-2,10.7006706,{"$f":"'B1.2 Billing Determinants'!G22","v":237094.05490657414},{"$f":"G19*H19/100","v":25370.653827735638},"No Change",10.521800000000001,{"$f":"H19*K19/100","v":24946.56226915992}]
[null,null,"Delivery First 1,000 m3 - Jan To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!F23","v":20.1755},1.7000000000000001E-2,20.518483499999999,{"$f":"'B1.2 Billing Determinants'!F23","v":112019.62487022724},22984.72824575947,"Re-Balance",{"$f":"L20/H20*100","v":21.028569007827926},{"$f":"(I20/($I$18+$I$20))*($I$23-SUM($L$17,$L$19,$L$21:$L$22))","v":23556.124118145708}]
[null,null,"Delivery Over 1,000 m3 - Jan To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!G23","v":16.905200000000001},1.7000000000000001E-2,17.192588399999998,{"$f":"'B1.2 Billing Determinants'!G23","v":332622.37512977276},57186.395882365789,"No Change",16.905200000000001,{"$f":"H21*K21/100","v":56230.477760438349}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L22","v":3.6299999999999999E-2},1.7000000000000001E-2,3.6917099999999994E-2,{"$f":"SUM('B1.2 Billing Determinants'!L22:L23)","v":912931},337.02765020099991,"No Change",{"$f":"E22","v":3.6299999999999999E-2},331.39395299999995]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I22)","v":149653.79021695897},null,null,{"$f":"SUM(L17:L22)","v":149653.79021695894}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I23-L23","v":0}]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.4 Rate 4 Adjustment"}]

{"sheet":"D1.5 Rate 5 Adjustment","index":12,"n_rows":26,"n_cols":12,"rows_kept":26,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[null,null,"Rate 5 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":2.1000000000000001E-2}]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":0}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":4.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":1.7000000000000001E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue",null,"Balanced Rates","Revenue"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I24","v":150},{"$f":"E14","v":1.7000000000000001E-2},{"$f":"E17*(1+F17)","v":152.54999999999998},{"$f":"'B1.2 Billing Determinants'!E24","v":4},{"$f":"G17*H17*12","v":7322.4},"No Change",{"$f":"E17+H11","v":150},{"$f":"H17*K17*12","v":7200}]
[null,null,"Delivery Firm",null,{"$f":"'B1.1 Current Distribution Rates'!J24","v":7.1994999999999996},{"$f":"E14","v":1.7000000000000001E-2},{"$f":"E18*(1+F18)","v":7.3218914999999987},{"$f":"'B1.2 Billing Determinants'!J24","v":553894},{"$f":"G18*H18/100","v":40555.517705009996},"Re-Balance",{"$f":"L18/H18*100","v":7.3446066909704744},{"$f":"I20-L17-L19","v":40681.335784884002}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L24","v":3.6299999999999999E-2},{"$f":"E14","v":1.7000000000000001E-2},3.6917099999999994E-2,{"$f":"'B1.2 Billing Determinants'!L24","v":553894},{"$f":"G19*H19/100","v":204.48160187399998},"No Change",{"$f":"E19","v":3.6299999999999999E-2},{"$f":"H19*K19/100","v":201.06352200000001}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I19)","v":48082.399306883999},null,null,{"$f":"SUM(L17:L19)","v":48082.399306883999}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I20-L20","v":0}]
[]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.5 Rate 5 Adjustment"}]

{"sheet":"D1.6 Rate 6 Adjustment","index":13,"n_rows":24,"n_cols":12,"rows_kept":24,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[null,null,"Rate 6 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":2.1000000000000001E-2}]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":0}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":4.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":1.7000000000000001E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue",null,"Balanced Rates","Revenue"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I25","v":150},{"$f":"E14","v":1.7000000000000001E-2},{"$f":"E17*(1+F17)","v":152.54999999999998},{"$f":"'B1.2 Billing Determinants'!E25","v":1},{"$f":"G17*H17*12","v":1830.6},"No Change",{"$f":"E17+H11","v":150},{"$f":"H17*K17*12","v":1800}]
[null,null,"Delivery Firm",null,{"$f":"'B1.1 Current Distribution Rates'!J25","v":3.8894000000000002},{"$f":"E14","v":1.7000000000000001E-2},{"$f":"E18*(1+F18)","v":3.9555197999999998},{"$f":"'B1.2 Billing Determinants'!J25","v":38423518},{"$f":"G18*H18/100","v":1519849.862346564},"Re-Balance",{"$f":"L18/H18*100","v":3.9555994387254287},{"$f":"I20-(L17+L19)","v":1519880.462346564}]
[null,null,"Demand Firm",null,{"$f":"'B1.1 Current Distribution Rates'!K25","v":18.839200000000002},{"$f":"E14","v":1.7000000000000001E-2},19.159466399999999,{"$f":"'B1.2 Billing Determinants'!K25","v":1606140},{"$f":"G19*H19/100","v":307727.85363695998},"Change",{"$f":"G19","v":19.159466399999999},{"$f":"H19*K19/100","v":307727.85363695998}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I19)","v":1829408.3159835241},null,null,{"$f":"SUM(L17:L19)","v":1829408.3159835241}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I20-L20","v":0}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"D1.6 Rate 6 Adjustment"}]

{"sheet":"E1.1 Proposed Dist Rates ","index":14,"n_rows":30,"n_cols":14,"rows_kept":30,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Proposed Distribution Tariff Sheet Rates"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Monthly  Service Charge","Delivery\nFirst 1,000 m3","Delivery\nOver 1,000 m3","Delivery\nNext 24,000 m3","Delivery\nOver 25,000 m3","Delivery - Firm","Demand - Firm","Commodity","Delivery - Int - Lower","Delivery - Int - Upper"]
[null,null,"RATE 1 - General Service Rate - Residential",null,{"$f":"'D1.1 Rate 1 Adjustment'!K17","v":13.5},{"$f":"'D1.1 Rate 1 Adjustment'!K18","v":16.656717766606427},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":11.095368299999999},null,null,null,null,{"$f":"'D1.1 Rate 1 Adjustment'!K20","v":3.6299999999999999E-2}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'D1.1 Rate 1 Adjustment'!K17","v":13.5},{"$f":"'D1.1 Rate 1 Adjustment'!K18","v":16.656717766606427},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":11.095368299999999},null,null,null,null,{"$f":"'D1.1 Rate 1 Adjustment'!K20","v":3.6299999999999999E-2}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'D1.1 Rate 1 Adjustment'!K17","v":13.5},{"$f":"'D1.1 Rate 1 Adjustment'!K18","v":16.656717766606427},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":11.095368299999999},null,null,null,null,{"$f":"'D1.1 Rate 1 Adjustment'!K20","v":3.6299999999999999E-2}]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'D1.2 Rate 2 Adjustment'!K17","v":15},{"$f":"'D1.2 Rate 2 Adjustment'!K18","v":16.585597468927183},null,{"$f":"'D1.2 Rate 2 Adjustment'!K19","v":9.4825999999999997},{"$f":"'D1.2 Rate 2 Adjustment'!K20","v":6.1698000000000004},null,null,{"$f":"'D1.2 Rate 2 Adjustment'!K24","v":3.6299999999999999E-2}]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'D1.2 Rate 2 Adjustment'!K17","v":15},{"$f":"'D1.2 Rate 2 Adjustment'!K21","v":20.905912254717308},null,{"$f":"'D1.2 Rate 2 Adjustment'!K22","v":15.696},{"$f":"'D1.2 Rate 2 Adjustment'!K23","v":15.289899999999999},null,null,{"$f":"'D1.2 Rate 2 Adjustment'!K24","v":3.6299999999999999E-2}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'D1.3 Rate 3 Adjustment'!K17","v":150},null,null,null,null,{"$f":"'D1.3 Rate 3 Adjustment'!K18","v":4.1900498204539396},{"$f":"'D1.3 Rate 3 Adjustment'!K19","v":29.0974},{"$f":"'D1.3 Rate 3 Adjustment'!K20","v":3.6299999999999999E-2},{"$f":"'B1.1 Current Distribution Rates'!M21","v":7.9412000000000003},{"$f":"'B1.1 Current Distribution Rates'!N21","v":10.9612}]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,{"$f":"'D1.4 Rate 4 Adjustment'!K17","v":15},{"$f":"'D1.4 Rate 4 Adjustment'!K18","v":16.483592277856697},{"$f":"'D1.4 Rate 4 Adjustment'!K19","v":10.521800000000001},null,null,null,null,{"$f":"'D1.4 Rate 4 Adjustment'!K22","v":3.6299999999999999E-2}]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,{"$f":"'D1.4 Rate 4 Adjustment'!K17","v":15},{"$f":"'D1.4 Rate 4 Adjustment'!K20","v":21.028569007827926},{"$f":"'D1.4 Rate 4 Adjustment'!K21","v":16.905200000000001},null,null,null,null,{"$f":"'D1.4 Rate 4 Adjustment'!K22","v":3.6299999999999999E-2}]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'D1.5 Rate 5 Adjustment'!K17","v":150},null,null,null,null,{"$f":"'D1.5 Rate 5 Adjustment'!K18","v":7.3446066909704744},1,{"$f":"'D1.5 Rate 5 Adjustment'!K19","v":3.6299999999999999E-2},{"$f":"'B1.1 Current Distribution Rates'!M24","v":5.4611999999999998},{"$f":"'B1.1 Current Distribution Rates'!N24","v":8.4611999999999998}]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'D1.6 Rate 6 Adjustment'!K17","v":150},null,null,null,null,{"$f":"'D1.6 Rate 6 Adjustment'!K18","v":3.9555994387254287},{"$f":"'D1.6 Rate 6 Adjustment'!K19","v":19.159466399999999},null,{"$f":"'B1.1 Current Distribution Rates'!M25","v":7.9412000000000003},{"$f":"'B1.1 Current Distribution Rates'!N25","v":10.9612}]
[]
[null,null,"1 Placeholder rate for average application"]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"E1.1 Proposed Dist Rates "}]

{"sheet":"E1.2 Billing Determinants","index":15,"n_rows":30,"n_cols":14,"rows_kept":30,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Billing Determinants - Actuals October 1, 2016 to September 30, 2017"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Monthly  Service Charge","Delivery\nFirst 1,000 m3","Delivery\nOver 1,000 m3","Delivery\nNext 24,000 m3","Delivery\nOver 25,000 m3","Delivery - Firm","Demand - Firm","Commodity","Delivery - Int - Lower","Delivery - Int - Upper"]
[null,null,"RATE 1 - General Service Rate - Residential",null,{"$f":"'B1.2 Billing Determinants'!E16","v":8148},{"$f":"'B1.2 Billing Determinants'!F16","v":13875993.481266305},{"$f":"'B1.2 Billing Determinants'!G16","v":823151.51873369585},{"$f":"'B1.2 Billing Determinants'!H16","v":0},{"$f":"'B1.2 Billing Determinants'!I16","v":0},{"$f":"'B1.2 Billing Determinants'!J16","v":0},{"$f":"'B1.2 Billing Determinants'!K16","v":0},{"$f":"'B1.2 Billing Determinants'!L16","v":14699145},{"$f":"'B1.2 Billing Determinants'!M16","v":0},{"$f":"'B1.2 Billing Determinants'!N16","v":0}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'B1.2 Billing Determinants'!E17","v":462},{"$f":"'B1.2 Billing Determinants'!F17","v":1843267.5518121859},{"$f":"'B1.2 Billing Determinants'!G17","v":2483468.4481878141},{"$f":"'B1.2 Billing Determinants'!H17","v":0},{"$f":"'B1.2 Billing Determinants'!I17","v":0},{"$f":"'B1.2 Billing Determinants'!J17","v":0},{"$f":"'B1.2 Billing Determinants'!K17","v":0},{"$f":"'B1.2 Billing Determinants'!L17","v":4326736},{"$f":"'B1.2 Billing Determinants'!M17","v":0},{"$f":"'B1.2 Billing Determinants'!N17","v":0}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'B1.2 Billing Determinants'!E18","v":66},{"$f":"'B1.2 Billing Determinants'!F18","v":338676.82683753944},{"$f":"'B1.2 Billing Determinants'!G18","v":1206237.1731624606},{"$f":"'B1.2 Billing Determinants'!H18","v":0},{"$f":"'B1.2 Billing Determinants'!I18","v":0},{"$f":"'B1.2 Billing Determinants'!J18","v":0},{"$f":"'B1.2 Billing Determinants'!K18","v":0},{"$f":"'B1.2 Billing Determinants'!L18","v":1544914},{"$f":"'B1.2 Billing Determinants'!M18","v":0},{"$f":"'B1.2 Billing Determinants'!N18","v":0}]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'B1.2 Billing Determinants'!E19","v":53},{"$f":"'B1.2 Billing Determinants'!F19","v":383293.93127922353},{"$f":"'B1.2 Billing Determinants'!G19","v":0},{"$f":"'B1.2 Billing Determinants'!H19","v":1020704.0687207765},{"$f":"'B1.2 Billing Determinants'!I19","v":0},{"$f":"'B1.2 Billing Determinants'!J19","v":0},{"$f":"'B1.2 Billing Determinants'!K19","v":0},{"$f":"'B1.2 Billing Determinants'!L19","v":1403998},{"$f":"'B1.2 Billing Determinants'!M19","v":0},{"$f":"'B1.2 Billing Determinants'!N19","v":0}]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'B1.2 Billing Determinants'!E20","v":53},{"$f":"'B1.2 Billing Determinants'!F20","v":5767.2363930448846},{"$f":"'B1.2 Billing Determinants'!G20","v":0},{"$f":"'B1.2 Billing Determinants'!H20","v":44381.763606955115},{"$f":"'B1.2 Billing Determinants'!I20","v":0},{"$f":"'B1.2 Billing Determinants'!J20","v":0},{"$f":"'B1.2 Billing Determinants'!K20","v":0},{"$f":"'B1.2 Billing Determinants'!L20","v":50149},{"$f":"'B1.2 Billing Determinants'!M20","v":0},{"$f":"'B1.2 Billing Determinants'!N20","v":0}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.2 Billing Determinants'!E21","v":5},{"$f":"'B1.2 Billing Determinants'!F21","v":0},{"$f":"'B1.2 Billing Determinants'!G21","v":0},{"$f":"'B1.2 Billing Determinants'!H21","v":0},{"$f":"'B1.2 Billing Determinants'!I21","v":0},{"$f":"'B1.2 Billing Determinants'!J21","v":1485572},{"$f":"'B1.2 Billing Determinants'!K21","v":224723},{"$f":"'B1.2 Billing Determinants'!L21","v":1485572},{"$f":"'B1.2 Billing Determinants'!M21","v":0},{"$f":"'B1.2 Billing Determinants'!N21","v":0}]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,{"$f":"'B1.2 Billing Determinants'!E22","v":36},{"$f":"'B1.2 Billing Determinants'!F22","v":231194.94509342586},{"$f":"'B1.2 Billing Determinants'!G22","v":237094.05490657414},{"$f":"'B1.2 Billing Determinants'!H22","v":0},{"$f":"'B1.2 Billing Determinants'!I22","v":0},{"$f":"'B1.2 Billing Determinants'!J22","v":0},{"$f":"'B1.2 Billing Determinants'!K22","v":0},{"$f":"'B1.2 Billing Determinants'!L22","v":468289},{"$f":"'B1.2 Billing Determinants'!M22","v":0},{"$f":"'B1.2 Billing Determinants'!N22","v":0}]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,{"$f":"'B1.2 Billing Determinants'!E23","v":36},{"$f":"'B1.2 Billing Determinants'!F23","v":112019.62487022724},{"$f":"'B1.2 Billing Determinants'!G23","v":332622.37512977276},{"$f":"'B1.2 Billing Determinants'!H23","v":0},{"$f":"'B1.2 Billing Determinants'!I23","v":0},{"$f":"'B1.2 Billing Determinants'!J23","v":0},{"$f":"'B1.2 Billing Determinants'!K23","v":0},{"$f":"'B1.2 Billing Determinants'!L23","v":444642},{"$f":"'B1.2 Billing Determinants'!M23","v":0},{"$f":"'B1.2 Billing Determinants'!N23","v":0}]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.2 Billing Determinants'!E24","v":4},{"$f":"'B1.2 Billing Determinants'!F24","v":0},{"$f":"'B1.2 Billing Determinants'!G24","v":0},{"$f":"'B1.2 Billing Determinants'!H24","v":0},{"$f":"'B1.2 Billing Determinants'!I24","v":0},{"$f":"'B1.2 Billing Determinants'!J24","v":553894},{"$f":"'B1.2 Billing Determinants'!K24","v":0},{"$f":"'B1.2 Billing Determinants'!L24","v":553894},{"$f":"'B1.2 Billing Determinants'!M24","v":0},{"$f":"'B1.2 Billing Determinants'!N24","v":0}]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.2 Billing Determinants'!E25","v":1},{"$f":"'B1.2 Billing Determinants'!F25","v":0},{"$f":"'B1.2 Billing Determinants'!G25","v":0},{"$f":"'B1.2 Billing Determinants'!H25","v":0},{"$f":"'B1.2 Billing Determinants'!I25","v":0},{"$f":"'B1.2 Billing Determinants'!J25","v":38423518},{"$f":"'B1.2 Billing Determinants'!K25","v":1606140},{"$f":"'B1.2 Billing Determinants'!L25","v":0},{"$f":"'B1.2 Billing Determinants'!M25","v":0},{"$f":"'B1.2 Billing Determinants'!N25","v":0}]
[null,null,null,null,{"$f":"SUM(E16:E19,E21:E22,E24:E25)","v":8775},{"$f":"SUM(F16:F25)","v":16790213.597551953},5082573.5701203169,1065085.8323277317,0,40462984,1830863,24977339,0,0]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"E1.2 Billing Determinants"}]

{"sheet":"E1.3 Proposed Rev From Rate","index":16,"n_rows":33,"n_cols":15,"rows_kept":33,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Proposed Revenue from Rates"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Monthly  Service Charge","Delivery\nFirst 1,000 m3","Delivery\nOver 1,000 m3","Delivery\nNext 24,000 m3","Delivery\nOver 25,000 m3","Demand - Firm","Delivery - Firm","Commodity","Delivery - Int - Lower","Delivery - Int - Upper","Total"]
[null,null,"RATE 1 - General Service Rate - Residential",null,{"$f":"'E1.1 Proposed Dist Rates '!E16*'E1.2 Billing Determinants'!E16*12","v":1319976},{"$f":"'E1.1 Proposed Dist Rates '!F16*'E1.2 Billing Determinants'!F16/100","v":2311285.0714872344},{"$f":"'E1.1 Proposed Dist Rates '!G16*'E1.2 Billing Determinants'!G16/100","v":91331.692670547025},{"$f":"'E1.1 Proposed Dist Rates '!H16*'E1.2 Billing Determinants'!H16/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I16*'E1.2 Billing Determinants'!I16/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J16*'E1.2 Billing Determinants'!J16/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K16*'E1.2 Billing Determinants'!K16/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L16*'E1.2 Billing Determinants'!L16/100","v":5335.7896349999992},{"$f":"'E1.1 Proposed Dist Rates '!M16*'E1.2 Billing Determinants'!M16/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N16*'E1.2 Billing Determinants'!N16/100","v":0},{"$f":"SUM(E16:N16)","v":3727928.5537927812}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'E1.1 Proposed Dist Rates '!E17*'E1.2 Billing Determinants'!E17*12","v":74844},{"$f":"'E1.1 Proposed Dist Rates '!F17*'E1.2 Billing Determinants'!F17/100","v":307027.87378879171},{"$f":"'E1.1 Proposed Dist Rates '!G17*'E1.2 Billing Determinants'!G17/100","v":275549.97094073263},{"$f":"'E1.1 Proposed Dist Rates '!H17*'E1.2 Billing Determinants'!H17/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I17*'E1.2 Billing Determinants'!I17/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J17*'E1.2 Billing Determinants'!J17/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K17*'E1.2 Billing Determinants'!K17/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L17*'E1.2 Billing Determinants'!L17/100","v":1570.6051679999998},{"$f":"'E1.1 Proposed Dist Rates '!M17*'E1.2 Billing Determinants'!M17/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N17*'E1.2 Billing Determinants'!N17/100","v":0},{"$f":"SUM(E17:N17)","v":658992.44989752432}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'E1.1 Proposed Dist Rates '!E18*'E1.2 Billing Determinants'!E18*12","v":10692},{"$f":"'E1.1 Proposed Dist Rates '!F18*'E1.2 Billing Determinants'!F18/100","v":56412.443187227313},{"$f":"'E1.1 Proposed Dist Rates '!G18*'E1.2 Billing Determinants'!G18/100","v":133836.45693388375},{"$f":"'E1.1 Proposed Dist Rates '!H18*'E1.2 Billing Determinants'!H18/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I18*'E1.2 Billing Determinants'!I18/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J18*'E1.2 Billing Determinants'!J18/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K18*'E1.2 Billing Determinants'!K18/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L18*'E1.2 Billing Determinants'!L18/100","v":560.80378199999996},{"$f":"'E1.1 Proposed Dist Rates '!M18*'E1.2 Billing Determinants'!M18/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N18*'E1.2 Billing Determinants'!N18/100","v":0},201501.70390311108]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'E1.1 Proposed Dist Rates '!E19*'E1.2 Billing Determinants'!E19*7","v":5565},{"$f":"'E1.1 Proposed Dist Rates '!F19*'E1.2 Billing Determinants'!F19/100","v":63571.588564798396},{"$f":"'E1.1 Proposed Dist Rates '!G19*'E1.2 Billing Determinants'!G19/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!H19*'E1.2 Billing Determinants'!H19/100","v":96789.284020516352},{"$f":"'E1.1 Proposed Dist Rates '!I19*'E1.2 Billing Determinants'!I19/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J19*'E1.2 Billing Determinants'!J19/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K19*'E1.2 Billing Determinants'!K19/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L19*'E1.2 Billing Determinants'!L19/100","v":509.651274},{"$f":"'E1.1 Proposed Dist Rates '!M19*'E1.2 Billing Determinants'!M19/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N19*'E1.2 Billing Determinants'!N19/100","v":0},166435.52385931474]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'E1.1 Proposed Dist Rates '!E20*'E1.2 Billing Determinants'!E20*5","v":3975},{"$f":"'E1.1 Proposed Dist Rates '!F20*'E1.2 Billing Determinants'!F20/100","v":1205.693379852087},{"$f":"'E1.1 Proposed Dist Rates '!G20*'E1.2 Billing Determinants'!G20/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!H20*'E1.2 Billing Determinants'!H20/100","v":6966.1616157476747},{"$f":"'E1.1 Proposed Dist Rates '!I20*'E1.2 Billing Determinants'!I20/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J20*'E1.2 Billing Determinants'!J20/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K20*'E1.2 Billing Determinants'!K20/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L20*'E1.2 Billing Determinants'!L20/100","v":18.204087000000001},{"$f":"'E1.1 Proposed Dist Rates '!M20*'E1.2 Billing Determinants'!M20/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N20*'E1.2 Billing Determinants'!N20/100","v":0},12165.059082599762]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'E1.1 Proposed Dist Rates '!E21*'E1.2 Billing Determinants'!E21*12","v":9000},{"$f":"'E1.1 Proposed Dist Rates '!F21*'E1.2 Billing Determinants'!F21/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!G21*'E1.2 Billing Determinants'!G21/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!H21*'E1.2 Billing Determinants'!H21/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I21*'E1.2 Billing Determinants'!I21/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J21*'E1.2 Billing Determinants'!J21/100","v":62246.206918714},{"$f":"'E1.1 Proposed Dist Rates '!K21*'E1.2 Billing Determinants'!K21/100","v":65388.550201999999},{"$f":"'E1.1 Proposed Dist Rates '!L21*'E1.2 Billing Determinants'!L21/100","v":539.26263599999993},{"$f":"'E1.1 Proposed Dist Rates '!M21*'E1.2 Billing Determinants'!M21/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N21*'E1.2 Billing Determinants'!N21/100","v":0},137174.019756714]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,{"$f":"'E1.1 Proposed Dist Rates '!E22*'E1.2 Billing Determinants'!E22*9","v":4860},{"$f":"'E1.1 Proposed Dist Rates '!F22*'E1.2 Billing Determinants'!F22/100","v":38109.232116214975},{"$f":"'E1.1 Proposed Dist Rates '!G22*'E1.2 Billing Determinants'!G22/100","v":24946.56226915992},{"$f":"'E1.1 Proposed Dist Rates '!H22*'E1.2 Billing Determinants'!H22/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I22*'E1.2 Billing Determinants'!I22/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J22*'E1.2 Billing Determinants'!J22/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K22*'E1.2 Billing Determinants'!K22/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L22*'E1.2 Billing Determinants'!L22/100","v":169.98890700000001},{"$f":"'E1.1 Proposed Dist Rates '!M22*'E1.2 Billing Determinants'!M22/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N22*'E1.2 Billing Determinants'!N22/100","v":0},68085.783292374908]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,{"$f":"'E1.1 Proposed Dist Rates '!E23*'E1.2 Billing Determinants'!E23*3","v":1620},{"$f":"'E1.1 Proposed Dist Rates '!F23*'E1.2 Billing Determinants'!F23/100","v":23556.124118145708},{"$f":"'E1.1 Proposed Dist Rates '!G23*'E1.2 Billing Determinants'!G23/100","v":56230.477760438349},{"$f":"'E1.1 Proposed Dist Rates '!H23*'E1.2 Billing Determinants'!H23/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I23*'E1.2 Billing Determinants'!I23/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J23*'E1.2 Billing Determinants'!J23/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!K23*'E1.2 Billing Determinants'!K23/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L23*'E1.2 Billing Determinants'!L23/100","v":161.405046},{"$f":"'E1.1 Proposed Dist Rates '!M23*'E1.2 Billing Determinants'!M23/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N23*'E1.2 Billing Determinants'!N23/100","v":0},81568.006924584057]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'E1.1 Proposed Dist Rates '!E24*'E1.2 Billing Determinants'!E24*12","v":7200},{"$f":"'E1.1 Proposed Dist Rates '!F24*'E1.2 Billing Determinants'!F24/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!G24*'E1.2 Billing Determinants'!G24/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!H24*'E1.2 Billing Determinants'!H24/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I24*'E1.2 Billing Determinants'!I24/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J24*'E1.2 Billing Determinants'!J24/100","v":40681.335784883995},{"$f":"'E1.1 Proposed Dist Rates '!K24*'E1.2 Billing Determinants'!K24/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!L24*'E1.2 Billing Determinants'!L24/100","v":201.06352200000001},{"$f":"'E1.1 Proposed Dist Rates '!M24*'E1.2 Billing Determinants'!M24/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N24*'E1.2 Billing Determinants'!N24/100","v":0},48082.399306883992]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'E1.1 Proposed Dist Rates '!E25*'E1.2 Billing Determinants'!E25*12","v":1800},{"$f":"'E1.1 Proposed Dist Rates '!F25*'E1.2 Billing Determinants'!F25/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!G25*'E1.2 Billing Determinants'!G25/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!H25*'E1.2 Billing Determinants'!H25/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!I25*'E1.2 Billing Determinants'!I25/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!J25*'E1.2 Billing Determinants'!J25/100","v":1519880.462346564},{"$f":"'E1.1 Proposed Dist Rates '!K25*'E1.2 Billing Determinants'!K25/100","v":307727.85363695998},{"$f":"'E1.1 Proposed Dist Rates '!L25*'E1.2 Billing Determinants'!L25/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!M25*'E1.2 Billing Determinants'!M25/100","v":0},{"$f":"'E1.1 Proposed Dist Rates '!N25*'E1.2 Billing Determinants'!N25/100","v":0},1829408.3159835241]
[null,null,null,null,{"$f":"SUM(E16:E25)","v":1439532},{"$f":"SUM(F16:F25)","v":2801168.0266422643},581895.16057476168,103755.44563626402,0,1622808.0050501621,373116.40383895999,9066.7740570000005,0,0,6931341.8157994114]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Revenue",{"$f":"O26","v":6931341.8157994114}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Revenue",{"$f":"'B1.3 Current Rev From Rates'!O26","v":6815478.6782688424}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change",{"$f":"O28-O29","v":115863.13753056899}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O30/O29","v":1.6999999999999803E-2}]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"E1.3 Proposed Rev From Rate"}]

{"sheet":"F1.1 Calc Shared Tax Changes","index":17,"n_rows":38,"n_cols":19,"rows_kept":38,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[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":18,"n_rows":28,"n_cols":15,"rows_kept":28,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[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'!O16:O18)","v":4511723.4096297119},null,{"$f":"E16/$E$22","v":0.66198188309433714},null,{"$f":"$I$22*G16","v":11287.772155323548},null,{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":8676},null,12,null,{"$f":"ROUND(I16/K16/M16,4)","v":0.1084}]
[null,null,"RATE 2 - Seasonal Service ",null,{"$f":"SUM('B1.3 Current Rev From Rates'!O19:O20)","v":175615.12580325911},null,2.5767100755990632E-2,null,439.36725439877142,null,{"$f":"'B1.2 Billing Determinants'!E19","v":53},null,12,null,0.69079999999999997]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.3 Current Rev From Rates'!O21","v":134881.04204199999},null,1.9790398944694563E-2,null,337.4556311216046,null,{"$f":"'B1.2 Billing Determinants'!E21","v":5},null,12,null,5.6242999999999999]
[null,null,"RATE 4 - General Service Peaking",null,{"$f":"SUM('B1.3 Current Rev From Rates'!O22:O23)","v":147152.20276987116},null,2.1590883005630411E-2,null,368.15655265458753,null,{"$f":"'B1.2 Billing Determinants'!E22","v":36},null,12,null,0.85219999999999996]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.3 Current Rev From Rates'!O24","v":47278.662051999992},null,6.9369539960190962E-3,null,118.28534610797811,null,{"$f":"'B1.2 Billing Determinants'!E24","v":4},null,12,null,2.4643000000000002]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.3 Current Rev From Rates'!O25","v":1798828.2359720001},null,0.26393278020332817,null,4500.445047423902,null,{"$f":"'B1.2 Billing Determinants'!E25","v":1},null,12,null,375.03710000000001]
[null,null,null,null,{"$f":"SUM(E16:E21)","v":6815478.6782688424},null,{"$f":"SUM(G16:G21)","v":1},null,{"$f":"-'F1.1 Calc Shared Tax Changes'!S33","v":17051.481987030391},null,{"$f":"SUM(K16:K21)","v":8775}]
[]
[]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"F1.2 Alloc Shared Tax Changes"}]

{"sheet":"F1.3 Proposed Rate Riders","index":19,"n_rows":28,"n_cols":7,"rows_kept":28,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[null,null,"Proposed Shared Tax Rate Rider"]
[]
[null,null,"Description",null,"Shared Tax Changes",null,"Deferred Revenue Recovery"]
[null,null,null,null,"Effective for 12 months",null,"September 30, 2014"]
[null,null,null,null,"$ Per Customer Per Month",null,"Per Customer Per Month"]
[null,null,"Rate Group"]
[null,null,"RATE 1 - General Service Rate - Residential",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$16","v":0.1084},null,{"$f":"'F2.1 Deferred Revenue Recovery'!J17","v":0.37290000000000001}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$16","v":0.1084},null,{"$f":"G13","v":0.37290000000000001}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$16","v":0.1084},null,{"$f":"G14","v":0.37290000000000001}]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$17","v":0.69079999999999997},null,{"$f":"'F2.1 Deferred Revenue Recovery'!J18","v":0.20530000000000001}]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$17","v":0.69079999999999997},null,{"$f":"G16","v":0.20530000000000001}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$18","v":5.6242999999999999},null,{"$f":"'F2.1 Deferred Revenue Recovery'!J19","v":0.15429999999999999}]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$19","v":0.85219999999999996},null,{"$f":"'F2.1 Deferred Revenue Recovery'!J20","v":0.27400000000000002}]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$19","v":0.85219999999999996},null,{"$f":"G19","v":0.27400000000000002}]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$20","v":2.4643000000000002},null,{"$f":"'F2.1 Deferred Revenue Recovery'!J21","v":0.14510000000000001}]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$21","v":375.03710000000001},null,{"$f":"'F2.1 Deferred Revenue Recovery'!J22","v":7.9600000000000004E-2}]
[]
[]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A15),FIND(\"]\",CELL(\"filename\",A15))+1,255)","v":"F1.3 Proposed Rate Riders"}]

{"sheet":"F2.1 Deferred Revenue Recovery","index":20,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[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'!O16:O18)","v":4588422.7075934159},{"$f":"SUM('B1.3 Current Rev From Rates'!O16:O18)","v":4511723.4096297119},{"$f":"D17-E17","v":76699.297963703983},{"$f":"F17/12*12","v":76699.297963703983},{"$f":"'F1.2 Alloc Shared Tax Changes'!K16","v":8676},{"$f":"'E1.2 Billing Determinants'!L16+'E1.2 Billing Determinants'!L17+'E1.2 Billing Determinants'!L18","v":20570795},{"$f":"ROUND(G17/I17*100,4)","v":0.37290000000000001},82174,{"$f":"F17-K17","v":-5474.7020362960175},0.36109999999999998,{"$f":"M17*I17/100","v":74281.140744999997},{"$f":"G17-N17","v":2418.1572187039856},{"$f":"L17/H17","v":-0.63101683221484761},{"$f":"D17/H17","v":528.86384365991421},{"$f":"P17/Q17","v":-1.1931555537016874E-3}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C17","v":"RATE 2 - Seasonal Service "},{"$f":"SUM('E1.3 Proposed Rev From Rate'!O19:O20)","v":178600.5829419145},{"$f":"SUM('B1.3 Current Rev From Rates'!O19:O20)","v":175615.12580325911},2985.4571386553871,2985.4571386553871,{"$f":"'F1.2 Alloc Shared Tax Changes'!K17","v":53},{"$f":"'E1.2 Billing Determinants'!L19+'E1.2 Billing Determinants'!L20","v":1454147},0.20530000000000001,2161,{"$f":"F18-K18","v":824.4571386553871},0.21990000000000001,{"$f":"M18*I18/100","v":3197.669253},-212.21211434461293,{"$f":"L18/H18","v":15.555795068969568},{"$f":"D18/H18","v":3369.8223196587642},{"$f":"P18/Q18","v":4.6162063139711124E-3}]
[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'!O21","v":137174.019756714},{"$f":"'B1.3 Current Rev From Rates'!O21","v":134881.04204199999},2292.9777147140121,2292.9777147140121,{"$f":"'F1.2 Alloc Shared Tax Changes'!K18","v":5},{"$f":"'E1.2 Billing Determinants'!L21","v":1485572},0.15429999999999999,1735,557.97771471401211,0.1923,{"$f":"M19*I19/100","v":2856.7549560000002},-563.77724128598811,111.59554294280242,27434.803951342801,4.0676632186154322E-3]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C19","v":"RATE 4 - General Service Peaking"},{"$f":"SUM('E1.3 Proposed Rev From Rate'!O22:O23)","v":149653.79021695897},{"$f":"SUM('B1.3 Current Rev From Rates'!O22:O23)","v":147152.20276987116},2501.5874470878043,2501.5874470878043,{"$f":"'F1.2 Alloc Shared Tax Changes'!K19","v":36},{"$f":"'E1.2 Billing Determinants'!L22+'E1.2 Billing Determinants'!L23","v":912931},0.27400000000000002,2125,376.58744708780432,0.23749999999999999,{"$f":"M20*I20/100","v":2168.2111249999998},333.37632208780451,10.460762419105675,4157.0497282488604,2.516390975075544E-3]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C20","v":"RATE 5 - Interruptible Peaking Contract Rate"},{"$f":"'E1.3 Proposed Rev From Rate'!O24","v":48082.399306883992},{"$f":"'B1.3 Current Rev From Rates'!O24","v":47278.662051999992},803.73725488399941,803.73725488399941,{"$f":"'F1.2 Alloc Shared Tax Changes'!K20","v":4},{"$f":"'E1.2 Billing Determinants'!L24","v":553894},0.14510000000000001,844,-40.262745116000588,0.1439,{"$f":"M21*I21/100","v":797.05346600000007},6.6837888839993411,-10.065686279000147,12020.599826720998,-8.37369717326817E-4]
[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'!O25","v":1829408.3159835241},{"$f":"'B1.3 Current Rev From Rates'!O25","v":1798828.2359720001},30580.080011524027,30580.080011524027,{"$f":"'F1.2 Alloc Shared Tax Changes'!K21","v":1},{"$f":"'E1.2 Billing Determinants'!J25","v":38423518},7.9600000000000004E-2,30580,8.0011524027213454E-2,7.9600000000000004E-2,{"$f":"G22","v":30580.080011524027},0,{"$f":"L22/H22*0","v":0},{"$f":"D22/H22","v":1829408.3159835241},0]
[null,null,null,{"$f":"SUM(D17:D22)","v":6931341.8157994114},{"$f":"SUM(E17:E22)","v":6815478.6782688424},{"$f":"SUM(F17:F22)","v":115863.13753056922},{"$f":"SUM(G17:G22)","v":115863.13753056922},{"$f":"SUM(H17:H22)","v":8775},{"$f":"SUM(I17:I22)","v":63400857},null,{"$f":"SUM(K17:K22)","v":119619},{"$f":"SUM(L17:L22)","v":-3755.8624694307873},null,{"$f":"SUM(N17:N22)","v":113880.90955652403},1982.2279740451922]
[null,null,null,null,null,{"$f":"F23/E23","v":1.6999999999999838E-2}]
[]
[]
[]
[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":21,"n_rows":116,"n_cols":12,"rows_kept":116,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[null,null,"Rate 1 Delivery Bill Impact"]
[]
[]
[null,null,"Rate 1 - Residential",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E16","v":13.5},null,{"$f":"'E1.1 Proposed Dist Rates '!E16","v":13.5}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!F16","v":16.231200000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!F16","v":16.656717766606427}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G16","v":10.9099},null,{"$f":"'E1.1 Proposed Dist Rates '!G16","v":11.095368299999999}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L16","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L16","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$16","v":0.13}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$13,4)","v":0.1084}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!F16/'B1.2 Billing Determinants'!E16,0)","v":1703}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!G16/'B1.2 Billing Determinants'!E16,0)","v":101}]
[]
[null,null,"Delivery",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F12*E26","v":162},null,{"$f":"H12*E26","v":162},null,{"$f":"H26-F26","v":0},null,{"$f":"IF(ISERROR(J26/F26),0,J26/F26)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E22","v":1703},{"$f":"F13*E27/100","v":276.41733600000003},null,{"$f":"H13*E27/100","v":283.66390356530746},null,{"$f":"H27-F27","v":7.24656756530743},null,{"$f":"IF(ISERROR(J27/F27),0,J27/F27)","v":2.62160386543463E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E23","v":101},{"$f":"F14*E28/100","v":11.018999000000001},null,{"$f":"H14*E28/100","v":11.206321982999999},null,0.18732298299999783,null,{"$f":"IF(ISERROR(J28/F28),0,J28/F28)","v":1.6999999999999803E-2}]
[null,null,"System Gas Charge",null,{"$f":"SUM(E27:E28)","v":1804},{"$f":"ROUND(F15*E29/100,2)","v":0.65},null,{"$f":"ROUND(H15*E29/100,2)","v":0.65},null,0,null,{"$f":"IF(ISERROR(J29/F29),0,J29/F29)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F26:F29)","v":450.08633500000002},null,{"$f":"SUM(H26:H29)","v":457.52022554830745},null,7.4338905483074313,null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":1.6516587974854717E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,12,{"$f":"F18*E35","v":1.56},null,0,null,{"$f":"H35-F35","v":-1.56},null,{"$f":"IF(ISERROR(J35/F35),1,J35/F35)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,12,0,null,{"$f":"H19*E36","v":1.3008},null,{"$f":"H36-F36","v":1.3008},null,{"$f":"IF(ISERROR(J36/F36),1,J36/F36)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F35:F36)","v":1.56},null,{"$f":"SUM(H35:H36)","v":1.3008},null,{"$f":"SUM(J35:J36)","v":-0.2592000000000001},null,{"$f":"IF(ISERROR(J37/F37),0,J37/F37)","v":-0.16615384615384621}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F30,F37)","v":451.64633500000002},null,{"$f":"SUM(H30,H37)","v":458.82102554830743},null,{"$f":"SUM(J30,J37)","v":7.1746905483074315},null,{"$f":"IF(ISERROR(J39/F39),0,J39/F39)","v":1.5885638811410772E-2}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.1 Rate 1 Bill Impact"}]
[]
[null,null,"Rate 1 Delivery Bill Impact"]
[]
[null,null,"Rate 1 - Commercial",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E17","v":13.5},null,{"$f":"'E1.1 Proposed Dist Rates '!E17","v":13.5}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!F17","v":16.231200000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!F17","v":16.656717766606427}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G17","v":10.9099},null,{"$f":"'E1.1 Proposed Dist Rates '!G17","v":11.095368299999999}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L16","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L17","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$17","v":0.13}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!E14,4)","v":0.1084}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!F17/'B1.2 Billing Determinants'!E17,0)","v":3990}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!G17/'B1.2 Billing Determinants'!E17,0)","v":5375}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F48*E62","v":162},null,{"$f":"H48*E62","v":162},null,{"$f":"H62-F62","v":0},null,{"$f":"IF(ISERROR(J62/F62),0,J62/F62)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E58","v":3990},{"$f":"F49*E63/100","v":647.62488000000008},null,{"$f":"H49*E63/100","v":664.60303888759654},null,{"$f":"H63-F63","v":16.978158887596464},null,{"$f":"IF(ISERROR(J63/F63),0,J63/F63)","v":2.6216038654346421E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E59","v":5375},{"$f":"F50*E64/100","v":586.40712500000006},null,{"$f":"H50*E64/100","v":596.3760461249999},null,9.968921124999838,null,{"$f":"IF(ISERROR(J64/F64),0,J64/F64)","v":1.699999999999972E-2}]
[null,null,"System Gas Charge",null,{"$f":"SUM(E63:E64)","v":9365},{"$f":"F51*E65/100","v":3.3994949999999999},null,{"$f":"H51*E65/100","v":3.3994949999999999},null,0,null,{"$f":"IF(ISERROR(J65/F65),0,J65/F65)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F62:F65)","v":1399.4314999999999},null,{"$f":"SUM(H62:H65)","v":1426.3785800125963},null,26.947080012596416,null,{"$f":"IF(ISERROR(J66/F66),0,J66/F66)","v":1.925573349792142E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,12,{"$f":"F54*E71","v":1.56},null,0,null,{"$f":"H71-F71","v":-1.56},null,{"$f":"IF(ISERROR(J71/F71),1,J71/F71)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,12,0,null,{"$f":"H55*E72","v":1.3008},null,{"$f":"H72-F72","v":1.3008},null,{"$f":"IF(ISERROR(J72/F72),1,J72/F72)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F71:F72)","v":1.56},null,{"$f":"SUM(H71:H72)","v":1.3008},null,{"$f":"SUM(J71:J72)","v":-0.2592000000000001},null,{"$f":"IF(ISERROR(J73/F73),0,J73/F73)","v":-0.16615384615384621}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F66,F73)","v":1400.9914999999999},null,{"$f":"SUM(H66,H73)","v":1427.6793800125963},null,{"$f":"SUM(J66,J73)","v":26.687880012596416},null,{"$f":"IF(ISERROR(J75/F75),0,J75/F75)","v":1.9049280465010972E-2}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A34),FIND(\"]\",CELL(\"filename\",A34))+1,255)","v":"G1.1 Rate 1 Bill Impact"}]
[]
[]
[]
[]
[null,null,"Rate 1 Delivery Bill Impact"]
[]
[null,null,"Rate 1 - Industrial",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E18","v":13.5},null,{"$f":"'E1.1 Proposed Dist Rates '!E18","v":13.5}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!F18","v":16.231200000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!F18","v":16.656717766606427}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G18","v":10.9099},null,{"$f":"'E1.1 Proposed Dist Rates '!G18","v":11.095368299999999}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L18","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L18","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!E18","v":0.13}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!E15,4)","v":0.1084}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!F18/'B1.2 Billing Determinants'!E18,0)","v":5131}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!G18/'B1.2 Billing Determinants'!E18,0)","v":18276}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F87*E101","v":162},null,{"$f":"H87*E101","v":162},null,{"$f":"H101-F101","v":0},null,{"$f":"IF(ISERROR(J101/F101),0,J101/F101)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E97","v":5131},{"$f":"F88*E102/100","v":832.82287200000007},null,{"$f":"H88*E102/100","v":854.65618860457573},null,{"$f":"H102-F102","v":21.833316604575657},null,{"$f":"IF(ISERROR(J102/F102),0,J102/F102)","v":2.6216038654346244E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E98","v":18276},{"$f":"F89*E103/100","v":1993.8933240000001},null,{"$f":"H89*E103/100","v":2027.7895105079997},null,33.896186507999573,null,{"$f":"IF(ISERROR(J103/F103),0,J103/F103)","v":1.6999999999999786E-2}]
[null,null,"System Gas Charge",null,{"$f":"SUM(E102:E103)","v":23407},{"$f":"F90*E104/100","v":8.4967410000000001},null,{"$f":"H90*E104/100","v":8.4967410000000001},null,0,null,{"$f":"IF(ISERROR(J104/F104),0,J104/F104)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F101:F104)","v":2997.2129370000002},null,{"$f":"SUM(H101:H104)","v":3052.9424401125752},null,55.729503112575003,null,{"$f":"IF(ISERROR(J105/F105),0,J105/F105)","v":1.8593775045011092E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,12,{"$f":"F93*E110","v":1.56},null,0,null,{"$f":"H110-F110","v":-1.56},null,{"$f":"IF(ISERROR(J110/F110),1,J110/F110)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,12,0,null,{"$f":"H94*E111","v":1.3008},null,{"$f":"H111-F111","v":1.3008},null,{"$f":"IF(ISERROR(J111/F111),1,J111/F111)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F110:F111)","v":1.56},null,{"$f":"SUM(H110:H111)","v":1.3008},null,{"$f":"SUM(J110:J111)","v":-0.2592000000000001},null,{"$f":"IF(ISERROR(J112/F112),0,J112/F112)","v":-0.16615384615384621}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F105,F112)","v":2998.7729370000002},null,{"$f":"SUM(H105,H112)","v":3054.2432401125752},null,{"$f":"SUM(J105,J112)","v":55.470303112575003},null,{"$f":"IF(ISERROR(J114/F114),0,J114/F114)","v":1.8497666971767458E-2}]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A68),FIND(\"]\",CELL(\"filename\",A68))+1,255)","v":"G1.1 Rate 1 Bill Impact"}]

{"sheet":"G1.2 Rate 2 Bill Impact","index":22,"n_rows":111,"n_cols":12,"rows_kept":111,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[null,null,"Rate 2 Delivery Bill Impact"]
[]
[null,null,"Rate 2 - April to October",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E19","v":15},null,{"$f":"'E1.1 Proposed Dist Rates '!E19","v":15}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!F19","v":15.821199999999999},null,{"$f":"'E1.1 Proposed Dist Rates '!F19","v":16.585597468927183}]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!H19","v":9.4825999999999997},null,{"$f":"'E1.1 Proposed Dist Rates '!H19","v":9.4825999999999997}]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!I19","v":6.1698000000000004},null,{"$f":"'E1.1 Proposed Dist Rates '!I19","v":6.1698000000000004}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L19","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L20","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$19","v":0.24}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$16,4)","v":0.69079999999999997}]
[]
[null,null,"Average Seasonal Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!F19/'B1.2 Billing Determinants'!E19,0)","v":7232}]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!H19/'B1.2 Billing Determinants'!E19,0)","v":19259}]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!I19/'B1.2 Billing Determinants'!E19,0)","v":0}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,7,{"$f":"F11*E27","v":105},null,{"$f":"H11*E27","v":105},null,{"$f":"H27-F27","v":0},null,{"$f":"IF(ISERROR(J27/F27),0,J27/F27)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E22","v":7232},{"$f":"F12*E28/100","v":1144.1891839999998},null,{"$f":"H12*E28/100","v":1199.4704089528138},null,{"$f":"H28-F28","v":55.281224952814},null,{"$f":"IF(ISERROR(J28/F28),0,J28/F28)","v":4.831475924248381E-2}]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"E23","v":19259},{"$f":"F13*E29/100","v":1826.2539340000001},null,{"$f":"H13*E29/100","v":1826.2539340000001},null,0,null,{"$f":"IF(ISERROR(J29/F29),0,J29/F29)","v":0}]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"E24","v":0},{"$f":"F14*E30/100","v":0},null,{"$f":"H14*E30/100","v":0},null,0,null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E28:E29)","v":26491},{"$f":"F15*E31/100","v":9.6162329999999994},null,{"$f":"H15*E31/100","v":9.6162329999999994},null,0,null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F27:F31)","v":3085.0593510000003},null,{"$f":"SUM(H27:H31)","v":3140.3405759528141},null,55.281224952813773,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":1.7919015053922627E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,7,{"$f":"F18*E37","v":1.68},null,0,null,{"$f":"H37-F37","v":-1.68},null,{"$f":"IF(ISERROR(J37/F37),0,J37/F37)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,7,0,null,{"$f":"H19*E38","v":4.8355999999999995},null,{"$f":"H38-F38","v":4.8355999999999995},null,{"$f":"IF(ISERROR(J38/F38),0,J38/F38)","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F37:F38)","v":1.68},null,{"$f":"SUM(H37:H38)","v":4.8355999999999995},null,{"$f":"SUM(J37:J38)","v":3.1555999999999997},null,1.8783333333333332]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F32,F39)","v":3086.7393510000002},null,{"$f":"SUM(H32,H39)","v":3145.176175952814},null,{"$f":"SUM(J32,J39)","v":58.436824952813772},null,{"$f":"IF(ISERROR(J41/F41),0,J41/F41)","v":1.8931570925767412E-2}]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.2 Rate 2 Bill Impact"}]
[]
[]
[]
[null,null,"Rate 2 Delivery Bill Impact"]
[]
[null,null,"Rate 2 - November to March",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E20","v":15},null,{"$f":"'E1.1 Proposed Dist Rates '!E20","v":15}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!F20","v":19.942399999999999},null,{"$f":"'E1.1 Proposed Dist Rates '!F20","v":20.905912254717308}]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!H20","v":15.696},null,{"$f":"'E1.1 Proposed Dist Rates '!H20","v":15.696}]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!I20","v":15.289899999999999},null,{"$f":"'E1.1 Proposed Dist Rates '!I20","v":15.289899999999999}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L20","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L20","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$20","v":0.24}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$17,4)","v":0.69079999999999997}]
[]
[null,null,"Average Seasonal Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!F20/'B1.2 Billing Determinants'!E20,0)","v":109}]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!H20/'B1.2 Billing Determinants'!E20,0)","v":837}]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!I20/'B1.2 Billing Determinants'!E20,0)","v":0}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,5,{"$f":"F51*E67","v":75},null,{"$f":"H51*E67","v":75},null,{"$f":"H67-F67","v":0},null,{"$f":"IF(ISERROR(J67/F67),0,J67/F67)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E62","v":109},{"$f":"F52*E68/100","v":21.737216},null,{"$f":"H52*E68/100","v":22.787444357641867},null,{"$f":"H68-F68","v":1.0502283576418669},null,4.831475924248381E-2]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"E63","v":837},{"$f":"F53*E69/100","v":131.37551999999999},null,{"$f":"H53*E69/100","v":131.37551999999999},null,0,null,0]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"E64","v":0},{"$f":"F54*E70/100","v":0},null,{"$f":"H54*E70/100","v":0},null,{"$f":"H70-F70","v":0},null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E68:E69)","v":946},{"$f":"F55*E71/100","v":0.34339799999999998},null,{"$f":"H55*E71/100","v":0.34339799999999998},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F67:F71)","v":228.45613399999999},null,{"$f":"SUM(H67:H71)","v":229.50636235764188},null,1.0502283576418847,null,4.5970678889361086E-3]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,5,{"$f":"F58*E77","v":1.2},null,0,null,{"$f":"H77-F77","v":-1.2},null,{"$f":"IF(ISERROR(J77/F77),0,J77/F77)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,5,0,null,{"$f":"H59*E78","v":3.4539999999999997},null,{"$f":"H78-F78","v":3.4539999999999997},null,{"$f":"IF(ISERROR(J78/F78),0,J78/F78)","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F77:F78)","v":1.2},null,{"$f":"SUM(H77:H78)","v":3.4539999999999997},null,{"$f":"SUM(J77:J78)","v":2.2539999999999996},null,1.878333333333333]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F72,F79)","v":229.65613399999998},null,{"$f":"SUM(H72,H79)","v":232.96036235764188},null,{"$f":"SUM(J72,J79)","v":3.3042283576418843},null,{"$f":"IF(ISERROR(J81/F81),0,J81/F81)","v":1.4387720894238709E-2}]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A41),FIND(\"]\",CELL(\"filename\",A41))+1,255)","v":"G1.2 Rate 2 Bill Impact"}]
[]
[null,null,"Rate 2 Delivery Bill Impact"]
[]
[null,null,"Rate 2 - Annual"]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E22+E62","v":7341}]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"E23+E63","v":20096}]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"E24+E64","v":0}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,{"$f":"E27+E67","v":12},{"$f":"F27+F67","v":180},null,{"$f":"H27+H67","v":180},null,{"$f":"H95-F95","v":0},null,{"$f":"IF(ISERROR(J95/F95),0,J95/F95)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E90","v":7341},{"$f":"F28+F68","v":1165.9263999999998},null,{"$f":"H28+H68","v":1222.2578533104556},null,{"$f":"H96-F96","v":56.3314533104558},null,4.8314759242483754E-2]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"E91","v":20096},{"$f":"F29+F69","v":1957.6294540000001},null,{"$f":"H29+H69","v":1957.6294540000001},null,0,null,0]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"E92","v":0},{"$f":"F30+F70","v":0},null,{"$f":"H30+H70","v":0},null,{"$f":"H98-F98","v":0},null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E96:E97)","v":27437},{"$f":"F31+F71","v":9.9596309999999999},null,{"$f":"H31+H71","v":9.9596309999999999},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F95:F99)","v":3313.5154850000004},null,{"$f":"SUM(H95:H99)","v":3369.8469383104562},null,56.3314533104558,null,1.7000510052077152E-2]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,{"$f":"E37+E77","v":12},{"$f":"F37+F77","v":2.88},null,{"$f":"H37+H77","v":0},null,{"$f":"H105-F105","v":-2.88},null,{"$f":"IF(ISERROR(J105/F105),1,J105/F105)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,{"$f":"E38+E78","v":12},{"$f":"F38+F78","v":0},null,{"$f":"H38+H78","v":8.2896000000000001},null,{"$f":"H106-F106","v":8.2896000000000001},null,{"$f":"IF(ISERROR(J106/F106),1,J106/F106)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F105:F106)","v":2.88},null,{"$f":"SUM(H105:H106)","v":8.2896000000000001},null,{"$f":"SUM(J105:J106)","v":5.4096000000000002},null,{"$f":"IF(ISERROR(J107/F107),0,J107/F107)","v":1.8783333333333334}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F100,F107)","v":3316.3954850000005},null,{"$f":"SUM(H100,H107)","v":3378.1365383104562},null,{"$f":"SUM(J100,J107)","v":61.741053310455797},null,{"$f":"IF(ISERROR(J109/F109),0,J109/F109)","v":1.8616915138652646E-2}]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.2 Rate 2 Bill Impact"}]

{"sheet":"G1.3 Rate 3 Bill Impact","index":23,"n_rows":47,"n_cols":12,"rows_kept":47,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Rate 3 Delivery Bill Impact"]
[]
[]
[]
[]
[null,null,"Special Large Volume Contract Rate",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E21","v":150},null,{"$f":"'E1.1 Proposed Dist Rates '!E21","v":150}]
[null,null,"Delivery - Firm",null,null,{"$f":"'B1.1 Current Distribution Rates'!J21","v":4.0357000000000003},null,{"$f":"'E1.1 Proposed Dist Rates '!J21","v":4.1900498204539396}]
[null,null,"Demand - Firm",null,null,{"$f":"'B1.1 Current Distribution Rates'!K21","v":29.0974},null,{"$f":"'E1.1 Proposed Dist Rates '!K21","v":29.0974}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L21","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L21","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$21","v":10.53}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$18,4)","v":5.6242999999999999}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Delivery - Firm",null,{"$f":"ROUND('B1.2 Billing Determinants'!J21/'B1.2 Billing Determinants'!E21,0)","v":297114}]
[null,null,"Demand - Firm",null,{"$f":"ROUND('B1.2 Billing Determinants'!K21/'B1.2 Billing Determinants'!E21,0)","v":44945}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F17*E31","v":1800},null,{"$f":"H17*E31","v":1800},null,{"$f":"H31-F31","v":0},null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":0}]
[null,null,"Delivery - Firm",null,{"$f":"E27","v":297114},{"$f":"F18*E32/100","v":11990.629698000001},null,{"$f":"H18*E32/100","v":12449.224623543518},null,{"$f":"H32-F32","v":458.59492554351709},null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":3.8246108594280855E-2}]
[null,null,"Demand - Firm",null,{"$f":"E28","v":44945},{"$f":"F19*E33/100","v":13077.826429999999},null,{"$f":"H19*E33/100","v":13077.826429999999},null,0,null,{"$f":"IF(ISERROR(J33/F33),0,J33/F33)","v":0}]
[null,null,"System Gas Charge",null,{"$f":"E27","v":297114},{"$f":"F20*E34/100","v":107.85238199999999},null,{"$f":"H20*E34/100","v":107.85238199999999},null,0,null,{"$f":"IF(ISERROR(J34/F34),0,J34/F34)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F31:F34)","v":26976.308509999999},null,{"$f":"SUM(H31:H34)","v":27434.903435543518},null,458.59492554351891,null,{"$f":"IF(ISERROR(J35/F35),0,J35/F35)","v":1.6999914030992037E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,12,{"$f":"F23*E40","v":126.35999999999999},null,0,null,{"$f":"H40-F40","v":-126.35999999999999},null,{"$f":"IF(ISERROR(J40/F40),1,J40/F40)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,12,0,null,{"$f":"H24*E41","v":67.491600000000005},null,{"$f":"H41-F41","v":67.491600000000005},null,{"$f":"IF(ISERROR(J41/F41),1,J41/F41)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F40:F41)","v":126.35999999999999},null,{"$f":"SUM(H40:H41)","v":67.491600000000005},null,{"$f":"SUM(J40:J41)","v":-58.86839999999998},null,{"$f":"IF(ISERROR(J42/F42),0,J42/F42)","v":-0.46587844254510913}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F35,F42)","v":27102.66851},null,{"$f":"SUM(H35,H42)","v":27502.395035543519},null,{"$f":"SUM(J35,J42)","v":399.72652554351896},null,{"$f":"IF(ISERROR(J44/F44),0,J44/F44)","v":1.4748604012775824E-2}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.3 Rate 3 Bill Impact"}]

{"sheet":"G1.4 Rate 4 Bill Impact","index":24,"n_rows":106,"n_cols":12,"rows_kept":106,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[null,null,"Rate 4 Delivery Bill Impact"]
[]
[]
[]
[null,null,"Rate 4 - April to December",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E22","v":15},null,{"$f":"'E1.1 Proposed Dist Rates '!E22","v":15}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!F22","v":15.8149},null,{"$f":"'E1.1 Proposed Dist Rates '!F22","v":16.483592277856697}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G22","v":10.521800000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!G22","v":10.521800000000001}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L19","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L22","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$22","v":0.69}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$19,4)","v":0.85219999999999996}]
[]
[null,null,"Average Seasonal Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!F22/'B1.2 Billing Determinants'!E22,0)","v":6422}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!G22/'B1.2 Billing Determinants'!E22,0)","v":6586}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,9,{"$f":"F13*E27","v":135},null,{"$f":"H13*E27","v":135},null,{"$f":"H27-F27","v":0},null,{"$f":"IF(ISERROR(J27/F27),0,J27/F27)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E23","v":6422},{"$f":"F14*E28/100","v":1015.632878},null,{"$f":"H14*E28/100","v":1058.5762960839572},null,{"$f":"H28-F28","v":42.943418083957226},null,{"$f":"IF(ISERROR(J28/F28),0,J28/F28)","v":4.2282422137142776E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E24","v":6586},{"$f":"F15*E29/100","v":692.96574800000008},null,{"$f":"H15*E29/100","v":692.96574800000008},null,0,null,{"$f":"IF(ISERROR(J29/F29),0,J29/F29)","v":0}]
[null,null,"System Gas Charge",null,{"$f":"SUM(E28:E29)","v":13008},{"$f":"F16*E30/100","v":4.7219040000000003},null,{"$f":"H16*E30/100","v":4.7219040000000003},null,0,null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F27:F30)","v":1848.32053},null,{"$f":"SUM(H27:H30)","v":1891.2639480839573},null,42.94341808395734,null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":2.3233750524838535E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,9,{"$f":"F19*E36","v":6.2099999999999991},null,0,null,{"$f":"H36-F36","v":-6.2099999999999991},null,{"$f":"IF(ISERROR(J36/F36),1,J36/F36)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,9,0,null,{"$f":"H20*E37","v":7.6697999999999995},null,{"$f":"H37-F37","v":7.6697999999999995},null,{"$f":"IF(ISERROR(J37/F37),1,J37/F37)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F36:F37)","v":6.2099999999999991},null,{"$f":"SUM(H36:H37)","v":7.6697999999999995},null,{"$f":"SUM(J36:J37)","v":1.4598000000000004},null,{"$f":"IF(ISERROR(J38/F38),0,J38/F38)","v":0.23507246376811605}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F31,F38)","v":1854.53053},null,{"$f":"SUM(H31,H38)","v":1898.9337480839572},null,{"$f":"SUM(J31,J38)","v":44.403218083957341},null,{"$f":"IF(ISERROR(J40/F40),0,J40/F40)","v":2.3943104395244084E-2}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.4 Rate 4 Bill Impact"}]
[]
[null,null,"Rate 4 Delivery Bill Impact"]
[]
[null,null,"Rate 4 - January to March",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E23","v":15},null,{"$f":"'E1.1 Proposed Dist Rates '!E23","v":15}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!F23","v":20.1755},null,{"$f":"'E1.1 Proposed Dist Rates '!F23","v":21.028569007827926}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G23","v":16.905200000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!G23","v":16.905200000000001}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L23","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L23","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$23","v":0.69}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$20,4)","v":0.85219999999999996}]
[]
[null,null,"Average Seasonal Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!F23/'B1.2 Billing Determinants'!E23,0)","v":3112}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"ROUND('B1.2 Billing Determinants'!G23/'B1.2 Billing Determinants'!E23,0)","v":9240}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,3,{"$f":"F49*E63","v":45},null,{"$f":"H49*E63","v":45},null,{"$f":"H63-F63","v":0},null,{"$f":"IF(ISERROR(J63/F63),0,J63/F63)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E59","v":3112},{"$f":"F50*E64/100","v":627.86155999999994},null,{"$f":"H50*E64/100","v":654.40906752360502},null,{"$f":"H64-F64","v":26.547507523605077},null,4.2282422137142908E-2]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E60","v":9240},{"$f":"F51*E65/100","v":1562.0404800000001},null,{"$f":"H51*E65/100","v":1562.0404800000001},null,0,null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E64:E65)","v":12352},{"$f":"F52*E66/100","v":4.4837759999999998},null,{"$f":"H52*E66/100","v":4.4837759999999998},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F63:F66)","v":2239.385816},null,{"$f":"SUM(H63:H66)","v":2265.9333235236054},null,26.547507523605418,null,1.1854816322372124E-2]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,3,{"$f":"F55*E72","v":2.0699999999999998},null,0,null,{"$f":"H72-F72","v":-2.0699999999999998},null,{"$f":"IF(ISERROR(J72/F72),1,J72/F72)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,3,0,null,{"$f":"H56*E73","v":2.5566},null,{"$f":"H73-F73","v":2.5566},null,{"$f":"IF(ISERROR(J73/F73),1,J73/F73)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F72:F73)","v":2.0699999999999998},null,{"$f":"SUM(H72:H73)","v":2.5566},null,{"$f":"SUM(J72:J73)","v":0.48660000000000014},null,{"$f":"IF(ISERROR(J74/F74),0,J74/F74)","v":0.23507246376811602}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F67,F74)","v":2241.4558160000001},null,{"$f":"SUM(H67,H74)","v":2268.4899235236053},null,{"$f":"SUM(J67,J74)","v":27.034107523605417},null,{"$f":"IF(ISERROR(J76/F76),0,J76/F76)","v":1.206095936874154E-2}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A33),FIND(\"]\",CELL(\"filename\",A33))+1,255)","v":"G1.4 Rate 4 Bill Impact"}]
[]
[null,null,"Rate 4 Delivery Bill Impact"]
[]
[null,null,"Rate 4 - Annual"]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E23+E59","v":9534}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E24+E60","v":15826}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,{"$f":"E27+E63","v":12},{"$f":"F27+F63","v":180},null,{"$f":"H27+H63","v":180},null,{"$f":"H90-F90","v":0},null,{"$f":"IF(ISERROR(J90/F90),0,J90/F90)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E86","v":9534},{"$f":"F28+F64","v":1643.4944379999999},null,{"$f":"H28+H64","v":1712.9853636075622},null,{"$f":"H91-F91","v":69.490925607562303},null,4.2282422137142825E-2]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E87","v":15826},{"$f":"F29+F65","v":2255.0062280000002},null,{"$f":"H29+H65","v":2255.0062280000002},null,0,null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E91:E92)","v":25360},{"$f":"F30+F66","v":9.205680000000001},null,{"$f":"H30+H66","v":9.205680000000001},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F90:F93)","v":4087.7063459999999},null,{"$f":"SUM(H90:H93)","v":4157.1972716075625},null,69.490925607562531,null,1.6999979872713324E-2]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,{"$f":"E72+E36","v":12},{"$f":"F72+F36","v":8.2799999999999994},null,{"$f":"H72+H36","v":0},null,{"$f":"H99-F99","v":-8.2799999999999994},null,{"$f":"IF(ISERROR(J99/F99),1,J99/F99)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,{"$f":"E73+E37","v":12},{"$f":"F73+F37","v":0},null,{"$f":"H73+H37","v":10.2264},null,{"$f":"H100-F100","v":10.2264},null,{"$f":"IF(ISERROR(J100/F100),1,J100/F100)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F99:F100)","v":8.2799999999999994},null,{"$f":"SUM(H99:H100)","v":10.2264},null,{"$f":"SUM(J99:J100)","v":1.9464000000000006},null,{"$f":"IF(ISERROR(J101/F101),0,J101/F101)","v":0.23507246376811602}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F94,F101)","v":4095.9863460000001},null,{"$f":"SUM(H94,H101)","v":4167.423671607562},null,{"$f":"SUM(J94,J101)","v":71.437325607562528},null,{"$f":"IF(ISERROR(J103/F103),0,J103/F103)","v":1.7440811461035696E-2}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A61),FIND(\"]\",CELL(\"filename\",A61))+1,255)","v":"G1.4 Rate 4 Bill Impact"}]

{"sheet":"G1.5 Rate 5 Bill Impact","index":25,"n_rows":44,"n_cols":12,"rows_kept":44,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Rate 5 Delivery Bill Impact"]
[]
[]
[]
[]
[null,null,"Interruptible Peaking Contract Rate",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E24","v":150},null,{"$f":"'E1.1 Proposed Dist Rates '!E24","v":150}]
[null,null,"Delivery - Firm",null,null,{"$f":"'B1.1 Current Distribution Rates'!J24","v":7.1994999999999996},null,{"$f":"'E1.1 Proposed Dist Rates '!J24","v":7.3446066909704744}]
[null,null,"System Gas Charge",null,null,{"$f":"'B1.1 Current Distribution Rates'!L24","v":3.6299999999999999E-2},null,{"$f":"'E1.1 Proposed Dist Rates '!L24","v":3.6299999999999999E-2}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$24","v":3.81}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$21,4)","v":2.4643000000000002}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Delivery - Firm",null,{"$f":"ROUND('B1.2 Billing Determinants'!J24/'B1.2 Billing Determinants'!E24,0)","v":138474}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F17*E29","v":1800},null,{"$f":"H17*E29","v":1800},null,{"$f":"H29-F29","v":0},null,{"$f":"IF(ISERROR(J29/F29),0,J29/F29)","v":0}]
[null,null,"Delivery - Firm",null,{"$f":"E26","v":138474},{"$f":"F18*E30/100","v":9969.4356299999999},null,{"$f":"H18*E30/100","v":10170.370669254455},null,{"$f":"H30-F30","v":200.93503925445475},null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":2.0155106739422796E-2}]
[null,null,"System Gas Charge",null,{"$f":"E26","v":138474},{"$f":"F19*E31/100","v":50.266062000000005},null,{"$f":"H19*E31/100","v":50.266062000000005},null,0,null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F29:F31)","v":11819.701692000001},null,{"$f":"SUM(H29:H31)","v":12020.636731254455},null,200.93503925445475,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":1.700000934799013E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,12,{"$f":"F22*E37","v":45.72},null,0,null,{"$f":"H37-F37","v":-45.72},null,{"$f":"IF(ISERROR(J37/F37),1,J37/F37)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,12,0,null,{"$f":"H23*E38","v":29.571600000000004},null,{"$f":"H38-F38","v":29.571600000000004},null,{"$f":"IF(ISERROR(J38/F38),1,J38/F38)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F37:F38)","v":45.72},null,{"$f":"SUM(H37:H38)","v":29.571600000000004},null,{"$f":"SUM(J37:J38)","v":-16.148399999999995},null,{"$f":"IF(ISERROR(J39/F39),0,J39/F39)","v":-0.35320209973753269}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F32,F39)","v":11865.421692},null,{"$f":"SUM(H32,H39)","v":12050.208331254455},null,{"$f":"SUM(J32,J39)","v":184.78663925445477},null,{"$f":"IF(ISERROR(J41/F41),0,J41/F41)","v":1.5573541678593952E-2}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.5 Rate 5 Bill Impact"}]

{"sheet":"G1.6 Rate 6 Bill Impact","index":26,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[]
[]
[]
[]
[]
[null,null,"Rate 6 Delivery Bill Impact"]
[]
[]
[]
[]
[null,null,"Special Large Volume Contract Rate",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Customer",null,null,{"$f":"'B1.1 Current Distribution Rates'!E25","v":150},null,{"$f":"'E1.1 Proposed Dist Rates '!E25","v":150}]
[null,null,"Delivery - Firm",null,null,{"$f":"'B1.1 Current Distribution Rates'!J25","v":3.8894000000000002},null,{"$f":"'E1.1 Proposed Dist Rates '!J25","v":3.9555994387254287}]
[null,null,"Demand - Firm",null,null,{"$f":"'B1.1 Current Distribution Rates'!K25","v":18.839200000000002},null,{"$f":"'E1.1 Proposed Dist Rates '!K25","v":19.159466399999999}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2015",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$25","v":380.13}]
[null,null,"Shared Tax Changes 2016",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$22,4)","v":375.03710000000001}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Delivery - Firm",null,{"$f":"'B1.2 Billing Determinants'!J25","v":38423518}]
[null,null,"Demand - Firm",null,{"$f":"'B1.2 Billing Determinants'!K25","v":1606140}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F17*E30","v":1800},null,{"$f":"H17*E30","v":1800},null,{"$f":"H30-F30","v":0},null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":0}]
[null,null,"Delivery - Firm",null,{"$f":"E26","v":38423518},{"$f":"F18*E31/100","v":1494444.3090920001},null,{"$f":"H18*E31/100","v":1519880.462346564},null,{"$f":"H31-F31","v":25436.15325456392},null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":1.7020475838285677E-2}]
[null,null,"Demand - Firm",null,{"$f":"E27","v":1606140},{"$f":"F19*E32/100","v":302583.92687999998},null,{"$f":"H19*E32/100","v":307727.85363695998},null,5143.9267569599906,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":1.699999999999997E-2}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F30:F32)","v":1798828.2359720001},null,{"$f":"SUM(H30:H32)","v":1829408.3159835241},null,30580.080011524027,null,{"$f":"IF(ISERROR(J33/F33),0,J33/F33)","v":1.7000000000000015E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Changes 2015",null,12,{"$f":"F22*E38","v":4561.5599999999995},null,0,null,{"$f":"H38-F38","v":-4561.5599999999995},null,{"$f":"IF(ISERROR(J38/F38),1,J38/F38)","v":-1}]
[null,null,"Shared Tax Changes 2016",null,12,0,null,{"$f":"H23*E39","v":4500.4452000000001},null,{"$f":"H39-F39","v":4500.4452000000001},null,{"$f":"IF(ISERROR(J39/F39),1,J39/F39)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F38:F39)","v":4561.5599999999995},null,{"$f":"SUM(H38:H39)","v":4500.4452000000001},null,{"$f":"SUM(J38:J39)","v":-61.114799999999377},null,{"$f":"IF(ISERROR(J40/F40),0,J40/F40)","v":-1.3397784968300182E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F33,F40)","v":1803389.7959720001},null,{"$f":"SUM(H33,H40)","v":1833908.761183524},null,{"$f":"SUM(J33,J40)","v":30518.965211524028},null,{"$f":"IF(ISERROR(J42/F42),0,J42/F42)","v":1.6923110732738045E-2}]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.6 Rate 6 Bill Impact"}]

{"sheet":"G1.7 Summary of Bill Impacts","index":27,"n_rows":30,"n_cols":8,"rows_kept":30,"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-2018-0235   Exhibit A - 2016 IRM Application Amended October 24, 2018"}]
[]
[null,null,"Summary of Bill Impacts"]
[]
[null,null,"Rate Class","Fixed Change","Volumetric Change","Shared Tax Rate Rider","Total Change $","Total Change %"]
[]
[null,null,"Rate 1 - Residential",{"$f":"'G1.1 Rate 1 Bill Impact'!J26","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J27:J29)","v":7.4338905483074278},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J37)","v":-0.2592000000000001},{"$f":"'G1.1 Rate 1 Bill Impact'!J39","v":7.1746905483074315},{"$f":"'G1.1 Rate 1 Bill Impact'!L39","v":1.5885638811410772E-2}]
[null,null,"Rate 1 - Commercial",{"$f":"'G1.1 Rate 1 Bill Impact'!J62","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J63:J65)","v":26.947080012596302},{"$f":"'G1.1 Rate 1 Bill Impact'!J73","v":-0.2592000000000001},{"$f":"'G1.1 Rate 1 Bill Impact'!J75","v":26.687880012596416},{"$f":"'G1.1 Rate 1 Bill Impact'!L75","v":1.9049280465010972E-2}]
[null,null,"Rate 1 - Industrial",{"$f":"'G1.1 Rate 1 Bill Impact'!J101","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J102:J104)","v":55.72950311257523},{"$f":"'G1.1 Rate 1 Bill Impact'!J112","v":-0.2592000000000001},{"$f":"'G1.1 Rate 1 Bill Impact'!J114","v":55.470303112575003},{"$f":"'G1.1 Rate 1 Bill Impact'!L114","v":1.8497666971767458E-2}]
[]
[null,null,{"$f":"'G1.2 Rate 2 Bill Impact'!C9","v":"Rate 2 - April to October"},{"$f":"'G1.2 Rate 2 Bill Impact'!J27","v":0},{"$f":"'G1.2 Rate 2 Bill Impact'!J32-'G1.7 Summary of Bill Impacts'!D13","v":55.281224952813773},{"$f":"'G1.2 Rate 2 Bill Impact'!J39","v":3.1555999999999997},{"$f":"SUM(D13:F13)","v":58.436824952813772},{"$f":"'G1.2 Rate 2 Bill Impact'!L41","v":1.8931570925767412E-2}]
[null,null,{"$f":"'G1.2 Rate 2 Bill Impact'!C49","v":"Rate 2 - November to March"},{"$f":"'G1.2 Rate 2 Bill Impact'!J67","v":0},{"$f":"'G1.2 Rate 2 Bill Impact'!J72-'G1.7 Summary of Bill Impacts'!D14","v":1.0502283576418847},{"$f":"'G1.2 Rate 2 Bill Impact'!J79","v":2.2539999999999996},{"$f":"SUM(D14:F14)","v":3.3042283576418843},{"$f":"'G1.2 Rate 2 Bill Impact'!L81","v":1.4387720894238709E-2}]
[null,null,{"$f":"'G1.2 Rate 2 Bill Impact'!C87","v":"Rate 2 - Annual"},{"$f":"'G1.2 Rate 2 Bill Impact'!J95","v":0},{"$f":"'G1.2 Rate 2 Bill Impact'!J100-'G1.7 Summary of Bill Impacts'!D15","v":56.3314533104558},{"$f":"'G1.2 Rate 2 Bill Impact'!J107","v":5.4096000000000002},{"$f":"SUM(D15:F15)","v":61.741053310455797},{"$f":"'G1.2 Rate 2 Bill Impact'!L109","v":1.8616915138652646E-2}]
[]
[null,null,{"$f":"\"Rate 3 -  \"& 'G1.3 Rate 3 Bill Impact'!C15","v":"Rate 3 -  Special Large Volume Contract Rate"},{"$f":"'G1.3 Rate 3 Bill Impact'!J31","v":0},{"$f":"'G1.3 Rate 3 Bill Impact'!J35-'G1.7 Summary of Bill Impacts'!D17","v":458.59492554351891},{"$f":"'G1.3 Rate 3 Bill Impact'!J42","v":-58.86839999999998},{"$f":"SUM(D17:F17)","v":399.72652554351896},{"$f":"'G1.3 Rate 3 Bill Impact'!L44","v":1.4748604012775824E-2}]
[]
[null,null,{"$f":"'G1.4 Rate 4 Bill Impact'!C11","v":"Rate 4 - April to December"},{"$f":"'G1.4 Rate 4 Bill Impact'!J27","v":0},{"$f":"'G1.4 Rate 4 Bill Impact'!J31-'G1.7 Summary of Bill Impacts'!D19","v":42.94341808395734},{"$f":"'G1.4 Rate 4 Bill Impact'!J38","v":1.4598000000000004},{"$f":"SUM(D19:F19)","v":44.403218083957341},{"$f":"'G1.4 Rate 4 Bill Impact'!L40","v":2.3943104395244084E-2}]
[null,null,{"$f":"'G1.4 Rate 4 Bill Impact'!C47","v":"Rate 4 - January to March"},{"$f":"'G1.4 Rate 4 Bill Impact'!J63","v":0},{"$f":"'G1.4 Rate 4 Bill Impact'!J67-'G1.7 Summary of Bill Impacts'!D20","v":26.547507523605418},{"$f":"'G1.4 Rate 4 Bill Impact'!J74","v":0.48660000000000014},{"$f":"SUM(D20:F20)","v":27.034107523605417},{"$f":"'G1.4 Rate 4 Bill Impact'!L76","v":1.206095936874154E-2}]
[null,null,{"$f":"'G1.4 Rate 4 Bill Impact'!C83","v":"Rate 4 - Annual"},{"$f":"'G1.4 Rate 4 Bill Impact'!J90","v":0},{"$f":"'G1.4 Rate 4 Bill Impact'!J94-'G1.7 Summary of Bill Impacts'!D21","v":69.490925607562531},{"$f":"'G1.4 Rate 4 Bill Impact'!J101","v":1.9464000000000006},{"$f":"SUM(D21:F21)","v":71.437325607562528},{"$f":"'G1.4 Rate 4 Bill Impact'!L103","v":1.7440811461035696E-2}]
[]
[null,null,{"$f":"\"Rate 5 - \" &'G1.5 Rate 5 Bill Impact'!C15","v":"Rate 5 - Interruptible Peaking Contract Rate"},{"$f":"'G1.5 Rate 5 Bill Impact'!J29","v":0},{"$f":"'G1.5 Rate 5 Bill Impact'!J32-'G1.7 Summary of Bill Impacts'!D23","v":200.93503925445475},{"$f":"'G1.5 Rate 5 Bill Impact'!J39","v":-16.148399999999995},{"$f":"SUM(D23:F23)","v":184.78663925445477},{"$f":"'G1.5 Rate 5 Bill Impact'!L41","v":1.5573541678593952E-2}]
[]
[null,null,{"$f":"\"Rate 6 - \" &'G1.6 Rate 6 Bill Impact'!C15","v":"Rate 6 - Special Large Volume Contract Rate"},{"$f":"'G1.6 Rate 6 Bill Impact'!J30","v":0},{"$f":"'G1.6 Rate 6 Bill Impact'!J33-'G1.7 Summary of Bill Impacts'!D25","v":30580.080011524027},{"$f":"'G1.6 Rate 6 Bill Impact'!J40","v":-61.114799999999377},{"$f":"SUM(D25:F25)","v":30518.965211524028},{"$f":"'G1.6 Rate 6 Bill Impact'!L42","v":1.6923110732738045E-2}]
[]
[]
[]
[]
[null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"G1.7 Summary of Bill Impacts"}]