{"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 Req 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 Req From Rate","F1.1 Calc Shared Tax Changes","F1.2 Alloc Shared Tax Changes","F2.1 Deferred Revenue Recovery","F1.3 Proposed Rate Riders","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":2,"macros":1,"external_links":0,"defined_names":3,"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":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":" \"Name of LDC:       \" &D21","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":" \"OEB Application Number:          \" & D23","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[null,null,"Crtl Q to Unlock"]
[]
[]
[]
[null,null,"Distributor Information"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Distributor Name","Natural Resource Gas Limited"]
[]
[null,null,"OEB Application Number","EB-2015-0115"]

{"sheet":"B1.1 Current Distribution Rates","index":1,"n_rows":27,"n_cols":14,"rows_kept":27,"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:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[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,15.9437,10.7805,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 1 - General Service Rate - Commercial",null,13.5,15.9437,10.7805,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 1 - General Service Rate - Industrial",null,13.5,15.9437,10.7805,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,15,15.1677,null,9.4825999999999997,6.1698000000000004,null,null,3.6299999999999999E-2]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,15,19.1187,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,3.9430999999999998,29.0974,3.6299999999999999E-2,7.9412000000000003,10.9612]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,15,15.4678,10.521800000000001,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,15,19.732700000000001,16.905200000000001,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,150,null,null,null,null,7.1024000000000003,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.8431999999999999,18.6158,null,7.9412000000000003,10.9612]
[]
[null,null,"1 Placeholder rate for average application"]

{"sheet":"B1.2 Billing Determinants","index":2,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Re-Basing Billing Determinants"]
[]
[]
[]
[]
[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,6559.916666666667,12369781,733799.79984444298,null,null,null,null,13103580.799844444]
[null,null,"RATE 1 - General Service Rate - Commercial",null,414,1760200,2371550.0078849494,null,null,null,null,4131750.0078849494]
[null,null,"RATE 1 - General Service Rate - Industrial",null,42,131099.99999999997,466927.66606406035,null,null,null,null,598027.66606406029]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,73,123779,null,329621.00000000006,0,null,null,453400.00000000006]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,73,5688,null,43772.000000000007,0,null,null,49460.000000000007]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,4,null,null,null,null,2195299.0893468545,256932,2195299.0893468545]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,23,215710,221214.44489017199,null,null,null,null,436924.44489017199]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,23,4368.1919191919205,12970,null,null,null,null,17338.191919191922]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,5,null,null,null,null,947161.70962962962,null,947161.70962962962]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,1,null,null,null,null,33416816,1298256]
[null,null,null,null,{"$f":"SUM(E16:E19,E21:E22,E24:E25)","v":7121.916666666667},{"$f":"SUM(F16:F25)","v":14610626.191919193},3806461.9186836248,373393.00000000006,0,36559276.798976481,1555188,21932941.909579303,{"$f":"SUM(M16:M25)","v":0},{"$f":"SUM(N16:N25)","v":0}]

{"sheet":"B1.3 Current Rev Req From Rates","index":3,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Revenue Requirement 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":"'B1.1 Current Distribution Rates'!E16*'B1.2 Billing Determinants'!E16*12","v":1062706.5},{"$f":"'B1.1 Current Distribution Rates'!F16*'B1.2 Billing Determinants'!F16/100","v":1972200.773297},{"$f":"'B1.1 Current Distribution Rates'!G16*'B1.2 Billing Determinants'!G16/100","v":79107.287422230176},{"$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":4756.5998303435326},{"$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":3118771.1605495731}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'B1.1 Current Distribution Rates'!E17*'B1.2 Billing Determinants'!E17*12","v":67068},{"$f":"'B1.1 Current Distribution Rates'!F17*'B1.2 Billing Determinants'!F17/100","v":280641.0074},{"$f":"'B1.1 Current Distribution Rates'!G17*'B1.2 Billing Determinants'!G17/100","v":255664.94860003699},{"$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":1499.8252528622365},{"$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":604873.78125289921}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'B1.1 Current Distribution Rates'!E18*'B1.2 Billing Determinants'!E18*12","v":6804},{"$f":"'B1.1 Current Distribution Rates'!F18*'B1.2 Billing Determinants'!F18/100","v":20902.190699999996},{"$f":"'B1.1 Current Distribution Rates'!G18*'B1.2 Billing Determinants'!G18/100","v":50337.137040036025},{"$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":217.08404278125388},{"$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},78260.411782817275]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'B1.1 Current Distribution Rates'!E19*'B1.2 Billing Determinants'!E19*7","v":7665},{"$f":"'B1.1 Current Distribution Rates'!F19*'B1.2 Billing Determinants'!F19/100","v":18774.427383000002},{"$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":31256.640946000003},{"$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":164.58420000000001},{"$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},57860.652528999999]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'B1.1 Current Distribution Rates'!E20*'B1.2 Billing Determinants'!E20*5","v":5475},{"$f":"'B1.1 Current Distribution Rates'!F20*'B1.2 Billing Determinants'!F20/100","v":1087.4716560000002},{"$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":6870.4531200000019},{"$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":17.953980000000001},{"$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},13450.878756000002]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.1 Current Distribution Rates'!E21*'B1.2 Billing Determinants'!E21*12","v":7200},{"$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":86562.838392035817},{"$f":"'B1.1 Current Distribution Rates'!K21*'B1.2 Billing Determinants'!K21/100","v":74760.531768000001},{"$f":"'B1.1 Current Distribution Rates'!L21*'B1.2 Billing Determinants'!L21/100","v":796.89356943290807},{"$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},169320.26372946872]
[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":3105},{"$f":"'B1.1 Current Distribution Rates'!F22*'B1.2 Billing Determinants'!F22/100","v":33365.591380000005},{"$f":"'B1.1 Current Distribution Rates'!G22*'B1.2 Billing Determinants'!G22/100","v":23275.741462454116},{"$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":158.60357349513242},{"$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},59904.936415949254]
[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":1035},{"$f":"'B1.1 Current Distribution Rates'!F23*'B1.2 Billing Determinants'!F23/100","v":861.96220683838419},{"$f":"'B1.1 Current Distribution Rates'!G23*'B1.2 Billing Determinants'!G23/100","v":2192.6044400000001},{"$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":6.293763666666667},{"$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},4095.8604105050508]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.1 Current Distribution Rates'!E24*'B1.2 Billing Determinants'!E24*12","v":9000},{"$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":67271.213264734819},{"$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":343.81970059555556},{"$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},76615.032965330378]
[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":1284275.0725120001},{"$f":"'B1.1 Current Distribution Rates'!K25*'B1.2 Billing Determinants'!K25/100","v":241680.740448},{"$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},1527755.81296]
[null,null,null,null,{"$f":"SUM(E16:E25)","v":1171858.5},{"$f":"SUM(F16:F25)","v":2327833.4240228385},410577.71896475734,38127.094066000005,0,1438109.1241687709,316441.27221600001,7961.6579131772869,0,0,5710908.7913515437]

{"sheet":"C1.1 Current Rate Riders","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Current Rate Riders"]
[]
[null,null,"Description",null,"Shared Tax Changes"]
[null,null,"Effective Until",null,"September 30, 2015"]
[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.11]
[null,null,"RATE 1 - General Service Rate - Commercial",null,-0.11]
[null,null,"RATE 1 - General Service Rate - Industrial",null,-0.11]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,-0.19]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,-0.19]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,-8.34]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,-0.55000000000000004]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,-0.55000000000000004]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,-3.02]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,-301.13]

{"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:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[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":22,"n_cols":15,"rows_kept":22,"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:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[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 Req From Rates'!O16:O18)","v":3801905.3535852898},null,{"$f":"E16/$E$22","v":0.66572685582770985},null,{"$f":"$I$22*G16","v":16558.442523132857},null,{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":7015.916666666667},null,12,null,{"$f":"I16/K16/M16","v":0.19667710946696029}]
[null,null,"RATE 2 - Seasonal Service ",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O19:O20)","v":71311.531285000005},null,1.2486897250572867E-2,null,310.5831897960669,null,{"$f":"'B1.2 Billing Determinants'!E19","v":73},null,12,null,{"$f":"I17/K17/M17","v":0.35454702031514485}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.3 Current Rev Req From Rates'!O21","v":169320.26372946872},null,2.9648567314869929E-2,null,737.44072884985565,null,{"$f":"'B1.2 Billing Determinants'!E21","v":4},null,12,null,15.363348517705326]
[null,null,"RATE 4 - General Service Peaking",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O22:O23)","v":64000.796826454301},null,1.1206762209786206E-2,null,278.74274005431874,null,{"$f":"'B1.2 Billing Determinants'!E22","v":23},null,12,null,1.009937463964923]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.3 Current Rev Req From Rates'!O24","v":76615.032965330378},null,1.3415558847893746E-2,null,333.68153643488444,null,{"$f":"'B1.2 Billing Determinants'!E24","v":5},null,12,null,5.5613589405814068]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.3 Current Rev Req From Rates'!O25","v":1527755.81296},null,0.2675153585491673,null,6653.836554459288,null,{"$f":"'B1.2 Billing Determinants'!E25","v":1},null,12,null,554.48637953827404]
[null,null,null,null,{"$f":"SUM(E16:E21)","v":5710908.7913515437},null,{"$f":"SUM(G16:G21)","v":0.99999999999999989},null,{"$f":"'C2.1 Regulatory Cost Adjustment'!E16","v":24872.727272727272},null,{"$f":"SUM(K16:K21)","v":7121.916666666667}]

{"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:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Adjustment to Monthly Service Charge"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Current Monthly  Service Charge",null,"Reulatory Cost Adjustment",null,"Adjusted Monthly  Service Charge"]
[null,null,"RATE 1 - General Service Rate - Residential",null,13.5,null,0,null,{"$f":"E16+G16","v":13.5}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,13.5,null,0,null,{"$f":"E17+G17","v":13.5}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,13.5,null,0,null,13.5]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,15,null,0,null,15]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,15,null,0,null,15]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,150,null,0,null,150]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,15,null,0,null,15]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,15,null,0,null,15]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,150,null,0,null,150]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,150,null,0,null,150]
[]
[]
[null,null,"1 Placeholder rate for average application"]

{"sheet":"D1.1 Rate 1 Adjustment","index":8,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[null,null,"Rate 1 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"E24","v":1.6E-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.2E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue Requirement",null,"Balanced Rates","Revenue Requirement"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I16","v":13.5},{"$f":"E14","v":1.2E-2},{"$f":"E17*(1+F17)","v":13.662000000000001},{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":7015.916666666667},{"$f":"G17*H17*12","v":1150217.442},"No Change",{"$f":"E17+H11","v":13.5},{"$f":"H17*K17*12","v":1136578.5}]
[null,null,"Delivery\nFirst 1,000 m3",null,{"$f":"'B1.1 Current Distribution Rates'!F16","v":15.9437},{"$f":"E14","v":1.2E-2},{"$f":"E18*(1+F18)","v":16.135024399999999},{"$f":"SUM('B1.2 Billing Determinants'!F16:F18)","v":14261081},{"$f":"G18*H18/100","v":2301028.8990537636},"Re-Balance",{"$f":"L18/H18*100","v":16.231206618651665},{"$f":"($I$21-SUM($L$17,$L$20,$L$19))","v":2314745.5231632753}]
[null,null,"Delivery\nOver 1,000 m3",null,{"$f":"'B1.1 Current Distribution Rates'!G16","v":10.7805},{"$f":"E14","v":1.2E-2},10.909866000000001,{"$f":"SUM('B1.2 Billing Determinants'!G16:G18)","v":3572277.4737934526},{"$f":"G19*H19/100","v":389730.68553905084},"Change",{"$f":"G19","v":10.909866000000001},{"$f":"H19*K19/100","v":389730.68553905084}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L16","v":3.6299999999999999E-2},{"$f":"E14","v":1.2E-2},3.67356E-2,{"$f":"SUM('B1.2 Billing Determinants'!L16:L18)","v":17833358.473793454},6551.191235498869,"No Change",{"$f":"E20","v":3.6299999999999999E-2},{"$f":"H20*K20/100","v":6473.5091259870233}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I20)","v":3847528.2178283134},null,null,{"$f":"SUM(L17:L20)","v":3847528.2178283134}]
[]
[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,1.6E-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.2E-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}]

{"sheet":"D1.2 Rate 2 Adjustment","index":9,"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:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[null,null,"Rate 2 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":1.6E-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.2E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue Requirement",null,"Balanced Rates","Revenue Requirement"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I19","v":15},{"$f":"$E$14","v":1.2E-2},{"$f":"E17*(1+F17)","v":15.18},{"$f":"'B1.2 Billing Determinants'!E19","v":73},{"$f":"G17*H17*12","v":13297.679999999998},"No Change",{"$f":"E17+H11","v":15},{"$f":"H17*K17*12","v":13140}]
[null,null,"Delivery First 1,000 m3 - Apr To Oct",null,{"$f":"'B1.1 Current Distribution Rates'!F19","v":15.1677},{"$f":"$E$14","v":1.2E-2},{"$f":"E18*(1+F18)","v":15.3497124},{"$f":"'B1.2 Billing Determinants'!F19","v":123779},{"$f":"G18*H18/100","v":18999.720511595999},"Re-Balance",{"$f":"L18/H18*100","v":15.821191538315226},{"$f":"(I18/($I$18+$I$21))*(I25-SUM(L17,L19:L20,L22:L24))","v":19583.312674211204}]
[null,null,"Delivery Next 24,000 m3 - Apr To Oct",null,{"$f":"'B1.1 Current Distribution Rates'!H19","v":9.4825999999999997},1.2E-2,9.5963911999999993,{"$f":"'B1.2 Billing Determinants'!H19","v":329621.00000000006},{"$f":"G19*H19/100","v":31631.720637352006},"No Change",{"$f":"E19","v":9.4825999999999997},{"$f":"H19*K19/100","v":31256.640946000003}]
[null,null,"Delivery Over 25,000 m3 - Apr To Oct",null,{"$f":"'B1.1 Current Distribution Rates'!I19","v":6.1698000000000004},1.2E-2,6.2438376000000009,{"$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.1187},1.2E-2,19.3481244,{"$f":"'B1.2 Billing Determinants'!F20","v":5688},1100.5213158720001,"Re-Balance",{"$f":"L21/H21*100","v":19.942418076807122},{"$f":"(I21/($I$18+$I$21))*(I25-SUM(L17,L19:L20,L22:L24))","v":1134.3247402087891}]
[null,null,"Delivery Next 24,000 m3 - Nov To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!H20","v":15.696},1.2E-2,15.884352,{"$f":"'B1.2 Billing Determinants'!H20","v":43772.000000000007},6952.8985574400003,"No Change",{"$f":"E22","v":15.696},{"$f":"H22*K22/100","v":6870.4531200000019}]
[null,null,"Delivery Over 25,000 m3 - Nov To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!I20","v":15.289899999999999},1.2E-2,15.473378799999999,{"$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.2E-2,3.67356E-2,{"$f":"SUM('B1.2 Billing Determinants'!L19:L20)","v":502860.00000000006},184.72863816,"No Change",3.6299999999999999E-2,182.53818000000004]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I24)","v":72167.269660420003},null,null,{"$f":"SUM(L17:L24)","v":72167.269660420003}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I25-L25","v":0}]

{"sheet":"D1.3 Rate 3 Adjustment","index":10,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[null,null,"Rate 3 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":1.6E-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.2E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue Requirement",null,"Balanced Rates","Revenue Requirement"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I21","v":150},{"$f":"E14","v":1.2E-2},{"$f":"E17*(1+F17)","v":151.80000000000001},{"$f":"'B1.2 Billing Determinants'!E21","v":4},{"$f":"G17*H17*12","v":7286.4000000000005},"No Change",{"$f":"E17+H11","v":150},{"$f":"H17*K17*12","v":7200}]
[null,null,"Delivery Firm",null,{"$f":"'B1.1 Current Distribution Rates'!J21","v":3.9430999999999998},{"$f":"E14","v":1.2E-2},{"$f":"E18*(1+F18)","v":3.9904172},{"$f":"'B1.2 Billing Determinants'!J21","v":2195299.0893468545},{"$f":"G18*H18/100","v":87601.592452740239},"Re-Balance",{"$f":"L18/H18*100","v":4.0356542753884224},{"$f":"I21-(L17+L19+L20)","v":88594.681556789437}]
[null,null,"Demand Firm",null,{"$f":"'B1.1 Current Distribution Rates'!K21","v":29.0974},{"$f":"E14","v":1.2E-2},29.446568800000001,{"$f":"'B1.2 Billing Determinants'!K21","v":256932},{"$f":"G19*H19/100","v":75657.658149216004},"No Change",29.0974,{"$f":"H19*K19/100","v":74760.531768000001}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L21","v":3.6299999999999999E-2},{"$f":"E14","v":1.2E-2},3.67356E-2,{"$f":"'B1.2 Billing Determinants'!L21","v":2195299.0893468545},806.45629226610311,"No Change",{"$f":"E20","v":3.6299999999999999E-2},{"$f":"H20*K20/100","v":796.89356943290807}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I20)","v":171352.10689422235},null,null,{"$f":"SUM(L17:L20)","v":171352.10689422232}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I21-L21","v":0}]

{"sheet":"D1.4 Rate 4 Adjustment","index":11,"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:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[null,null,"Rate 4 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":1.6E-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.2E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue Requirement",null,"Balanced Rates","Revenue Requirement"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I22","v":15},{"$f":"$E$14","v":1.2E-2},{"$f":"E17*(1+F17)","v":15.18},{"$f":"'B1.2 Billing Determinants'!E22","v":23},{"$f":"G17*H17*12","v":4189.68},"No Change",{"$f":"E17+H11","v":15},{"$f":"H17*K17*12","v":4140}]
[null,null,"Delivery First 1,000 m3 - Apr To Dec",null,{"$f":"'B1.1 Current Distribution Rates'!F22","v":15.4678},{"$f":"$E$14","v":1.2E-2},{"$f":"E18*(1+F18)","v":15.6534136},{"$f":"'B1.2 Billing Determinants'!F22","v":215710},{"$f":"G18*H18/100","v":33765.978476559998},"Re-Balance",{"$f":"L18/H18*100","v":15.814871790324938},{"$f":"(I18/($I$18+$I$20))*($I$23-SUM($L$17,$L$19,$L$21:$L$22))","v":34114.259938909927}]
[null,null,"Delivery Over 1,000 m3 - Apr To Dec",null,{"$f":"'B1.1 Current Distribution Rates'!G22","v":10.521800000000001},1.2E-2,10.6480616,{"$f":"'B1.2 Billing Determinants'!G22","v":221214.44489017199},{"$f":"G19*H19/100","v":23555.050360003566},"No Change",10.521800000000001,{"$f":"H19*K19/100","v":23275.741462454116}]
[null,null,"Delivery First 1,000 m3 - Jan To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!F23","v":19.732700000000001},1.2E-2,19.9694924,{"$f":"'B1.2 Billing Determinants'!F23","v":4368.1919191919205},872.30575332044475,"Re-Balance",{"$f":"L20/H20*100","v":20.175469076206372},{"$f":"(I20/($I$18+$I$20))*($I$23-SUM($L$17,$L$19,$L$21:$L$22))","v":881.30320984591162}]
[null,null,"Delivery Over 1,000 m3 - Jan To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!G23","v":16.905200000000001},1.2E-2,17.108062400000001,{"$f":"'B1.2 Billing Determinants'!G23","v":12970},2218.9156932800001,"No Change",16.905200000000001,{"$f":"H21*K21/100","v":2192.6044400000001}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L22","v":3.6299999999999999E-2},1.2E-2,3.67356E-2,{"$f":"SUM('B1.2 Billing Determinants'!L22:L23)","v":454262.6368093639},166.87610520774069,"No Change",{"$f":"E22","v":3.6299999999999999E-2},164.89733716179907]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I22)","v":64768.806388371755},null,null,{"$f":"SUM(L17:L22)","v":64768.806388371755}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I23-L23","v":0}]

{"sheet":"D1.5 Rate 5 Adjustment","index":12,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[null,null,"Rate 5 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":1.6E-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.2E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue Requirement",null,"Balanced Rates","Revenue Requirement"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I24","v":150},{"$f":"E14","v":1.2E-2},{"$f":"E17*(1+F17)","v":151.80000000000001},{"$f":"'B1.2 Billing Determinants'!E24","v":5},{"$f":"G17*H17*12","v":9108},"No Change",{"$f":"E17+H11","v":150},{"$f":"H17*K17*12","v":9000}]
[null,null,"Delivery Firm",null,{"$f":"'B1.1 Current Distribution Rates'!J24","v":7.1024000000000003},{"$f":"E14","v":1.2E-2},{"$f":"E18*(1+F18)","v":7.1876288000000006},{"$f":"'B1.2 Billing Determinants'!J24","v":947161.70962962962},{"$f":"G18*H18/100","v":68078.467823911633},"Re-Balance",{"$f":"L18/H18*100","v":7.1994668879703196},{"$f":"I20-L17-L19","v":68190.593660318773}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L24","v":3.6299999999999999E-2},{"$f":"E14","v":1.2E-2},3.67356E-2,{"$f":"'B1.2 Billing Determinants'!L24","v":947161.70962962962},{"$f":"G19*H19/100","v":347.94553700270217},"No Change",{"$f":"E19","v":3.6299999999999999E-2},{"$f":"H19*K19/100","v":343.81970059555556}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I19)","v":77534.413360914332},null,null,{"$f":"SUM(L17:L19)","v":77534.413360914332}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I20-L20","v":0}]

{"sheet":"D1.6 Rate 6 Adjustment","index":13,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[null,null,"Rate 6 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":1.6E-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.2E-2}]
[]
[null,null,null,null,"Current Rate","Price Cap","Adjusted Rates","Billing Determinants","Revenue Requirement",null,"Balanced Rates","Revenue Requirement"]
[null,null,"Monthly Service Charge",null,{"$f":"'C2.3 Adj Monthly Service Chg'!I25","v":150},{"$f":"E14","v":1.2E-2},{"$f":"E17*(1+F17)","v":151.80000000000001},{"$f":"'B1.2 Billing Determinants'!E25","v":1},{"$f":"G17*H17*12","v":1821.6000000000001},"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.8431999999999999},{"$f":"E14","v":1.2E-2},{"$f":"E18*(1+F18)","v":3.8893184000000001},{"$f":"'B1.2 Billing Determinants'!J25","v":33416816},{"$f":"G18*H18/100","v":1299686.3733821439},"Re-Balance",{"$f":"L18/H18*100","v":3.8893830381151338},{"$f":"I20-(L17+L19)","v":1299707.973382144}]
[null,null,"Demand Firm",null,{"$f":"'B1.1 Current Distribution Rates'!K25","v":18.6158},{"$f":"E14","v":1.2E-2},18.839189600000001,{"$f":"'B1.2 Billing Determinants'!K25","v":1298256},{"$f":"G19*H19/100","v":244580.90933337604},"Change",{"$f":"G19","v":18.839189600000001},{"$f":"H19*K19/100","v":244580.90933337604}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I19)","v":1546088.88271552},null,null,{"$f":"SUM(L17:L19)","v":1546088.88271552}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I20-L20","v":0}]

{"sheet":"E1.1 Proposed Dist Rates ","index":14,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[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.231206618651665},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":10.909866000000001},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.231206618651665},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":10.909866000000001},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.231206618651665},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":10.909866000000001},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":15.821191538315226},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":19.942418076807122},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.0356542753884224},{"$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":15.814871790324938},{"$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":20.175469076206372},{"$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.1994668879703196},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.8893830381151338},{"$f":"'D1.6 Rate 6 Adjustment'!K19","v":18.839189600000001},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"]

{"sheet":"E1.2 Billing Determinants","index":15,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Re-Basing Billing Determinants"]
[]
[]
[]
[]
[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":6559.916666666667},{"$f":"'B1.2 Billing Determinants'!F16","v":12369781},{"$f":"'B1.2 Billing Determinants'!G16","v":733799.79984444298},{"$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":13103580.799844444},{"$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":414},{"$f":"'B1.2 Billing Determinants'!F17","v":1760200},{"$f":"'B1.2 Billing Determinants'!G17","v":2371550.0078849494},{"$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":4131750.0078849494},{"$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":42},{"$f":"'B1.2 Billing Determinants'!F18","v":131099.99999999997},{"$f":"'B1.2 Billing Determinants'!G18","v":466927.66606406035},{"$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":598027.66606406029},{"$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":73},{"$f":"'B1.2 Billing Determinants'!F19","v":123779},{"$f":"'B1.2 Billing Determinants'!G19","v":0},{"$f":"'B1.2 Billing Determinants'!H19","v":329621.00000000006},{"$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":453400.00000000006},{"$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":73},{"$f":"'B1.2 Billing Determinants'!F20","v":5688},{"$f":"'B1.2 Billing Determinants'!G20","v":0},{"$f":"'B1.2 Billing Determinants'!H20","v":43772.000000000007},{"$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":49460.000000000007},{"$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":4},{"$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":2195299.0893468545},{"$f":"'B1.2 Billing Determinants'!K21","v":256932},{"$f":"'B1.2 Billing Determinants'!L21","v":2195299.0893468545},{"$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":23},{"$f":"'B1.2 Billing Determinants'!F22","v":215710},{"$f":"'B1.2 Billing Determinants'!G22","v":221214.44489017199},{"$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":436924.44489017199},{"$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":23},{"$f":"'B1.2 Billing Determinants'!F23","v":4368.1919191919205},{"$f":"'B1.2 Billing Determinants'!G23","v":12970},{"$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":17338.191919191922},{"$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":5},{"$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":947161.70962962962},{"$f":"'B1.2 Billing Determinants'!K24","v":0},{"$f":"'B1.2 Billing Determinants'!L24","v":947161.70962962962},{"$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":33416816},{"$f":"'B1.2 Billing Determinants'!K25","v":1298256},{"$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":7121.916666666667},{"$f":"SUM(F16:F25)","v":14610626.191919193},3806461.9186836248,373393.00000000006,0,36559276.798976481,1555188,21932941.909579303,0,0]

{"sheet":"E1.3 Proposed Rev Req From Rate","index":16,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Revenue Requirement 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":1062706.5},{"$f":"'E1.1 Proposed Dist Rates '!F16*'E1.2 Billing Determinants'!F16/100","v":2007764.7123847164},{"$f":"'E1.1 Proposed Dist Rates '!G16*'E1.2 Billing Determinants'!G16/100","v":80056.574871296951},{"$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":4756.5998303435326},{"$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":3155284.387086357}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'E1.1 Proposed Dist Rates '!E17*'E1.2 Billing Determinants'!E17*12","v":67068},{"$f":"'E1.1 Proposed Dist Rates '!F17*'E1.2 Billing Determinants'!F17/100","v":285701.69890150661},{"$f":"'E1.1 Proposed Dist Rates '!G17*'E1.2 Billing Determinants'!G17/100","v":258732.92798323743},{"$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":1499.8252528622365},{"$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":613002.45213760622}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'E1.1 Proposed Dist Rates '!E18*'E1.2 Billing Determinants'!E18*12","v":6804},{"$f":"'E1.1 Proposed Dist Rates '!F18*'E1.2 Billing Determinants'!F18/100","v":21279.111877052328},{"$f":"'E1.1 Proposed Dist Rates '!G18*'E1.2 Billing Determinants'!G18/100","v":50941.182684516461},{"$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":217.08404278125388},{"$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},79241.378604350044]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'E1.1 Proposed Dist Rates '!E19*'E1.2 Billing Determinants'!E19*7","v":7665},{"$f":"'E1.1 Proposed Dist Rates '!F19*'E1.2 Billing Determinants'!F19/100","v":19583.312674211204},{"$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":31256.640946000003},{"$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":164.58420000000001},{"$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},58669.537820211204]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'E1.1 Proposed Dist Rates '!E20*'E1.2 Billing Determinants'!E20*5","v":5475},{"$f":"'E1.1 Proposed Dist Rates '!F20*'E1.2 Billing Determinants'!F20/100","v":1134.3247402087891},{"$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":6870.4531200000019},{"$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":17.953980000000001},{"$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},13497.731840208791]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'E1.1 Proposed Dist Rates '!E21*'E1.2 Billing Determinants'!E21*12","v":7200},{"$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":88594.681556789423},{"$f":"'E1.1 Proposed Dist Rates '!K21*'E1.2 Billing Determinants'!K21/100","v":74760.531768000001},{"$f":"'E1.1 Proposed Dist Rates '!L21*'E1.2 Billing Determinants'!L21/100","v":796.89356943290807},{"$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},171352.10689422232]
[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":3105},{"$f":"'E1.1 Proposed Dist Rates '!F22*'E1.2 Billing Determinants'!F22/100","v":34114.259938909927},{"$f":"'E1.1 Proposed Dist Rates '!G22*'E1.2 Billing Determinants'!G22/100","v":23275.741462454116},{"$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":158.60357349513242},{"$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},60653.604974859176]
[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":1035},{"$f":"'E1.1 Proposed Dist Rates '!F23*'E1.2 Billing Determinants'!F23/100","v":881.30320984591162},{"$f":"'E1.1 Proposed Dist Rates '!G23*'E1.2 Billing Determinants'!G23/100","v":2192.6044400000001},{"$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":6.293763666666667},{"$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},4115.2014135125783]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'E1.1 Proposed Dist Rates '!E24*'E1.2 Billing Determinants'!E24*12","v":9000},{"$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":68190.593660318773},{"$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":343.81970059555556},{"$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},77534.413360914332]
[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":1299707.9733821442},{"$f":"'E1.1 Proposed Dist Rates '!K25*'E1.2 Billing Determinants'!K25/100","v":244580.90933337604},{"$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},1546088.8827155202]
[null,null,null,null,{"$f":"SUM(E16:E25)","v":1171858.5},{"$f":"SUM(F16:F25)","v":2370458.7237264509},415199.03144150501,38127.094066000005,0,1456493.2485992524,319341.44110137603,7961.6579131772869,0,0,5779439.6968477629]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Revenue Requirement",{"$f":"O26","v":5779439.6968477629}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Revenue Requirement",{"$f":"'B1.3 Current Rev Req From Rates'!O26","v":5710908.7913515437}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change",{"$f":"O28-O29","v":68530.905496219173}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O30/O29","v":1.2000000000000113E-2}]

{"sheet":"F1.1 Calc Shared Tax Changes","index":17,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Tax Change Rate Rider"]
[]
[]
[]
[null,null,null,null,2010,null,2011,null,2012,null,2013,null,2014,null,2015,null,2016]
[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,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,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,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,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,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,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,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,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,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,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}]

{"sheet":"F1.2 Alloc Shared Tax Changes","index":18,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Allocation of Shared Tax Chances"]
[]
[]
[]
[]
[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 Rate Rider"]
[null,null,"RATE 1 - General Service Rate",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O16:O18)","v":3801905.3535852898},null,{"$f":"E16/$E$22","v":0.66572685582770985},null,{"$f":"$I$22*G16","v":11351.629490428573},null,{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":7015.916666666667},null,12,null,{"$f":"ROUND(I16/K16/M16,2)","v":0.13}]
[null,null,"RATE 2 - Seasonal Service ",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O19:O20)","v":71311.531285000005},null,1.2486897250572867E-2,null,212.92010354204254,null,{"$f":"'B1.2 Billing Determinants'!E19","v":73},null,12,null,{"$f":"ROUND(I17/K17/M17,2)","v":0.24}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.3 Current Rev Req From Rates'!O21","v":169320.26372946872},null,2.9648567314869929E-2,null,505.55201151076261,null,{"$f":"'B1.2 Billing Determinants'!E21","v":4},null,12,null,10.53]
[null,null,"RATE 4 - General Service Peaking",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O22:O23)","v":64000.796826454301},null,1.1206762209786206E-2,null,191.09190395310239,null,{"$f":"'B1.2 Billing Determinants'!E22","v":23},null,12,null,0.69]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.3 Current Rev Req From Rates'!O24","v":76615.032965330378},null,1.3415558847893746E-2,null,228.7551600408064,null,{"$f":"'B1.2 Billing Determinants'!E24","v":5},null,12,null,3.81]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.3 Current Rev Req From Rates'!O25","v":1527755.81296},null,0.2675153585491673,null,4561.5333175551032,null,{"$f":"'B1.2 Billing Determinants'!E25","v":1},null,12,null,{"$f":"ROUND(I21/K21/M21,2)","v":380.13}]
[null,null,null,null,{"$f":"SUM(E16:E21)","v":5710908.7913515437},null,{"$f":"SUM(G16:G21)","v":0.99999999999999989},null,{"$f":"-'F1.1 Calc Shared Tax Changes'!Q33","v":17051.481987030391},null,{"$f":"SUM(K16:K21)","v":7121.916666666667}]

{"sheet":"F2.1 Deferred Revenue Recovery","index":19,"n_rows":24,"n_cols":15,"rows_kept":24,"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:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Deferred Revenue Recovery"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Proposed Revenue Requirement ",null,"Current Revenue Requirement",null,"Change In Revenue Requirement",null,"Deferred Revenue",null,"Number of Customers",null,"Proposed Deferred Revenue Recovery Rate Rider"]
[null,null,null,null,"A",null,"B",null,"C = A- B",null,"D = C / 12 * 6",null,"E",null,"F = D / E / 6"]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C16","v":"RATE 1 - General Service Rate"},null,{"$f":"SUM('E1.3 Proposed Rev Req From Rate'!O16:O18)","v":3847528.2178283134},null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O16:O18)","v":3801905.3535852898},null,{"$f":"E17-G17","v":45622.864243023563},null,{"$f":"I17/12*0","v":0},null,{"$f":"'F1.2 Alloc Shared Tax Changes'!K16","v":7015.916666666667},null,{"$f":"ROUND(K17/M17/6,2)","v":0}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C17","v":"RATE 2 - Seasonal Service "},null,{"$f":"SUM('E1.3 Proposed Rev Req From Rate'!O19:O20)","v":72167.269660419988},null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O19:O20)","v":71311.531285000005},null,{"$f":"E18-G18","v":855.73837541998364},null,{"$f":"I18/12*0","v":0},null,{"$f":"'F1.2 Alloc Shared Tax Changes'!K17","v":73},null,{"$f":"ROUND(K18/M18/6,2)","v":0}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C18","v":"RATE 3 - Special Large Volume Contract Rate"},null,{"$f":"'E1.3 Proposed Rev Req From Rate'!O21","v":171352.10689422232},null,{"$f":"'B1.3 Current Rev Req From Rates'!O21","v":169320.26372946872},null,2031.8431647536054,null,0,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!K18","v":4},null,0]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C19","v":"RATE 4 - General Service Peaking"},null,{"$f":"SUM('E1.3 Proposed Rev Req From Rate'!O22:O23)","v":64768.806388371755},null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O22:O23)","v":64000.796826454301},null,768.00956191745354,null,0,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!K19","v":23},null,0]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C20","v":"RATE 5 - Interruptible Peaking Contract Rate"},null,{"$f":"'E1.3 Proposed Rev Req From Rate'!O24","v":77534.413360914332},null,{"$f":"'B1.3 Current Rev Req From Rates'!O24","v":76615.032965330378},null,919.38039558395394,null,0,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!K20","v":5},null,0]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!C21","v":"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility"},null,{"$f":"'E1.3 Proposed Rev Req From Rate'!O25","v":1546088.8827155202},null,{"$f":"'B1.3 Current Rev Req From Rates'!O25","v":1527755.81296},null,18333.069755520206,null,0,null,{"$f":"'F1.2 Alloc Shared Tax Changes'!K21","v":1},null,0]
[null,null,null,null,{"$f":"SUM(E17:E22)","v":5779439.696847762},null,{"$f":"SUM(G17:G22)","v":5710908.7913515437},null,{"$f":"SUM(I17:I22)","v":68530.905496218766},null,{"$f":"SUM(K17:K22)","v":0},null,{"$f":"SUM(M17:M22)","v":7121.916666666667}]
[null,null,null,null,null,null,null,null,{"$f":"I23/G23","v":1.2000000000000042E-2}]

{"sheet":"F1.3 Proposed Rate Riders","index":20,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[null,null,"Proposed Rate Riders"]
[]
[null,null,"Description",null,"Shared Tax Changes",null,"Deferred Revenue Recovery"]
[null,null,"Effective Until",null,"September 30, 2016",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.13},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O17","v":0}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$16","v":0.13},null,{"$f":"G16","v":0}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$16","v":0.13},null,{"$f":"G17","v":0}]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$17","v":0.24},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O18","v":0}]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$17","v":0.24},null,{"$f":"G19","v":0}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$18","v":10.53},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O19","v":0}]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$19","v":0.69},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O20","v":0}]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$19","v":0.69},null,{"$f":"G22","v":0}]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$20","v":3.81},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O21","v":0}]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'F1.2 Alloc Shared Tax Changes'!$O$21","v":380.13},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O22","v":0}]

{"sheet":"G1.1 Rate 1 Bill Impact","index":21,"n_rows":102,"n_cols":12,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[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":15.9437},null,{"$f":"'E1.1 Proposed Dist Rates '!F16","v":16.231206618651665}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G16","v":10.7805},null,{"$f":"'E1.1 Proposed Dist Rates '!G16","v":10.909866000000001}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$16","v":-0.11}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$16,2)","v":0.13}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,2002]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,0]
[]
[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":2002},{"$f":"F13*E27/100","v":319.19287400000002},null,{"$f":"H13*E27/100","v":324.94875650540632},null,{"$f":"H27-F27","v":5.755882505406305},null,{"$f":"IF(ISERROR(J27/F27),0,J27/F27)","v":1.803261593304337E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E23","v":0},{"$f":"F14*E28/100","v":0},null,{"$f":"H14*E28/100","v":0},null,0,null,{"$f":"IF(ISERROR(J28/F28),0,J28/F28)","v":0}]
[null,null,"System Gas Charge",null,{"$f":"SUM(E27:E28)","v":2002},{"$f":"ROUND(F15*E29/100,2)","v":0.73},null,{"$f":"ROUND(H15*E29/100,2)","v":0.73},null,0,null,{"$f":"IF(ISERROR(J29/F29),0,J29/F29)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F26:F29)","v":481.92287400000004},null,{"$f":"SUM(H26:H29)","v":487.67875650540634},null,5.755882505406305,null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":1.1943576069822128E-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 2014",null,12,{"$f":"F18*E35","v":-1.32},null,0,null,{"$f":"H35-F35","v":1.32},null,{"$f":"IF(ISERROR(J35/F35),1,J35/F35)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,12,0,null,{"$f":"H19*E36","v":1.56},null,{"$f":"H36-F36","v":1.56},null,{"$f":"IF(ISERROR(J36/F36),1,J36/F36)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F35:F36)","v":-1.32},null,{"$f":"SUM(H35:H36)","v":1.56},null,{"$f":"SUM(J35:J36)","v":2.88},null,{"$f":"IF(ISERROR(J37/F37),0,J37/F37)","v":-2.1818181818181817}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F30,F37)","v":480.60287400000004},null,{"$f":"SUM(H30,H37)","v":489.23875650540634},null,{"$f":"SUM(J30,J37)","v":8.635882505406304},null,{"$f":"IF(ISERROR(J39/F39),0,J39/F39)","v":1.796885323121539E-2}]
[]
[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":15.9437},null,{"$f":"'E1.1 Proposed Dist Rates '!F17","v":16.231206618651665}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G17","v":10.7805},null,{"$f":"'E1.1 Proposed Dist Rates '!G17","v":10.909866000000001}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$17","v":-0.11}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!E17,2)","v":0.13}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,4252]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,5728]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F43*E57","v":162},null,{"$f":"H43*E57","v":162},null,{"$f":"H57-F57","v":0},null,{"$f":"IF(ISERROR(J57/F57),0,J57/F57)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E53","v":4252},{"$f":"F44*E58/100","v":677.92612399999996},null,{"$f":"H44*E58/100","v":690.1509054250688},null,{"$f":"H58-F58","v":12.224781425068841},null,{"$f":"IF(ISERROR(J58/F58),0,J58/F58)","v":1.8032615933043526E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E54","v":5728},{"$f":"F45*E59/100","v":617.50703999999996},null,{"$f":"H45*E59/100","v":624.9171244800001},null,7.4100844800001369,null,{"$f":"IF(ISERROR(J59/F59),0,J59/F59)","v":1.2000000000000222E-2}]
[null,null,"System Gas Charge",null,{"$f":"SUM(E58:E59)","v":9980},{"$f":"F46*E60/100","v":3.6227399999999998},null,{"$f":"H46*E60/100","v":3.6227399999999998},null,0,null,{"$f":"IF(ISERROR(J60/F60),0,J60/F60)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F57:F60)","v":1461.0559040000001},null,{"$f":"SUM(H57:H60)","v":1480.6907699050689},null,19.634865905068864,null,{"$f":"IF(ISERROR(J61/F61),0,J61/F61)","v":1.3438819042661945E-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 2014",null,12,{"$f":"F49*E66","v":-1.32},null,0,null,{"$f":"H66-F66","v":1.32},null,{"$f":"IF(ISERROR(J66/F66),1,J66/F66)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,12,0,null,{"$f":"H50*E67","v":1.56},null,{"$f":"H67-F67","v":1.56},null,{"$f":"IF(ISERROR(J67/F67),1,J67/F67)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F66:F67)","v":-1.32},null,{"$f":"SUM(H66:H67)","v":1.56},null,{"$f":"SUM(J66:J67)","v":2.88},null,{"$f":"IF(ISERROR(J68/F68),0,J68/F68)","v":-2.1818181818181817}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F61,F68)","v":1459.7359040000001},null,{"$f":"SUM(H61,H68)","v":1482.2507699050689},null,{"$f":"SUM(J61,J68)","v":22.514865905068863},null,{"$f":"IF(ISERROR(J70/F70),0,J70/F70)","v":1.5423931029834326E-2}]
[]
[]
[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":15.9437},null,{"$f":"'E1.1 Proposed Dist Rates '!F18","v":16.231206618651665}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G18","v":10.7805},null,{"$f":"'E1.1 Proposed Dist Rates '!G18","v":10.909866000000001}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!E18","v":-0.11}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!E18,2)","v":0.13}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,3122]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,11117]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,12,{"$f":"F75*E89","v":162},null,{"$f":"H75*E89","v":162},null,{"$f":"H89-F89","v":0},null,{"$f":"IF(ISERROR(J89/F89),0,J89/F89)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E85","v":3122},{"$f":"F76*E90/100","v":497.76231399999995},null,{"$f":"H76*E90/100","v":506.73827063430502},null,{"$f":"H90-F90","v":8.9759566343050778},null,{"$f":"IF(ISERROR(J90/F90),0,J90/F90)","v":1.8032615933043655E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E86","v":11117},{"$f":"F77*E91/100","v":1198.4681849999999},null,{"$f":"H77*E91/100","v":1212.8498032200002},null,14.381618220000291,null,{"$f":"IF(ISERROR(J91/F91),0,J91/F91)","v":1.2000000000000243E-2}]
[null,null,"System Gas Charge",null,{"$f":"SUM(E90:E91)","v":14239},{"$f":"F78*E92/100","v":5.1687569999999994},null,{"$f":"H78*E92/100","v":5.1687569999999994},null,0,null,{"$f":"IF(ISERROR(J92/F92),0,J92/F92)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F89:F92)","v":1863.3992559999997},null,{"$f":"SUM(H89:H92)","v":1886.7568308543052},null,23.35757485430554,null,{"$f":"IF(ISERROR(J93/F93),0,J93/F93)","v":1.2534927648541222E-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 2014",null,12,{"$f":"F81*E98","v":-1.32},null,0,null,{"$f":"H98-F98","v":1.32},null,{"$f":"IF(ISERROR(J98/F98),1,J98/F98)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,12,0,null,{"$f":"H82*E99","v":1.56},null,{"$f":"H99-F99","v":1.56},null,{"$f":"IF(ISERROR(J99/F99),1,J99/F99)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F98:F99)","v":-1.32},null,{"$f":"SUM(H98:H99)","v":1.56},null,{"$f":"SUM(J98:J99)","v":2.88},null,{"$f":"IF(ISERROR(J100/F100),0,J100/F100)","v":-2.1818181818181817}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F93,F100)","v":1862.0792559999998},null,{"$f":"SUM(H93,H100)","v":1888.3168308543052},null,{"$f":"SUM(J93,J100)","v":26.237574854305539},null,{"$f":"IF(ISERROR(J102/F102),0,J102/F102)","v":1.4090471589629019E-2}]

{"sheet":"G1.2 Rate 2 Bill Impact","index":22,"n_rows":108,"n_cols":12,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[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.1677},null,{"$f":"'E1.1 Proposed Dist Rates '!F19","v":15.821191538315226}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$19","v":-0.19}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$19,2)","v":0.24}]
[]
[null,null,"Average Seasonal Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,2831.2000000000003]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,3379.8]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,1.1368683772161603E-13]
[]
[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":2831.2000000000003},{"$f":"F12*E28/100","v":429.4279224},null,{"$f":"H12*E28/100","v":447.9295748327807},null,{"$f":"H28-F28","v":18.501652432780702},null,{"$f":"IF(ISERROR(J28/F28),0,J28/F28)","v":4.3084418752693344E-2}]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"E23","v":3379.8},{"$f":"F13*E29/100","v":320.49291479999999},null,{"$f":"H13*E29/100","v":320.49291479999999},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":1.1368683772161603E-13},{"$f":"F14*E30/100","v":7.0142505137482661E-15},null,{"$f":"H14*E30/100","v":7.0142505137482661E-15},null,0,null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E28:E29)","v":6211},{"$f":"F15*E31/100","v":2.2545929999999998},null,{"$f":"H15*E31/100","v":2.2545929999999998},null,0,null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F27:F31)","v":857.17543019999994},null,{"$f":"SUM(H27:H31)","v":875.67708263278064},null,18.501652432780702,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":2.1584440921812019E-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 2014",null,7,{"$f":"F18*E37","v":-1.33},null,0,null,{"$f":"H37-F37","v":1.33},null,{"$f":"IF(ISERROR(J37/F37),0,J37/F37)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,7,0,null,{"$f":"H19*E38","v":1.68},null,{"$f":"H38-F38","v":1.68},null,{"$f":"IF(ISERROR(J38/F38),0,J38/F38)","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F37:F38)","v":-1.33},null,{"$f":"SUM(H37:H38)","v":1.68},null,{"$f":"SUM(J37:J38)","v":3.01},null,-2.263157894736842]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F32,F39)","v":855.8454301999999},null,{"$f":"SUM(H32,H39)","v":877.35708263278059},null,{"$f":"SUM(J32,J39)","v":21.5116524327807},null,{"$f":"IF(ISERROR(J41/F41),0,J41/F41)","v":2.513497376243945E-2}]
[]
[]
[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.1187},null,{"$f":"'E1.1 Proposed Dist Rates '!F20","v":19.942418076807122}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$20","v":-0.19}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$20,2)","v":0.24}]
[]
[null,null,"Average Seasonal Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,677.60000000000014]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,0]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,0]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,5,{"$f":"F46*E62","v":75},null,{"$f":"H46*E62","v":75},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":"E57","v":677.60000000000014},{"$f":"F47*E63/100","v":129.54831120000003},null,{"$f":"H47*E63/100","v":135.12982488844509},null,{"$f":"H63-F63","v":5.5815136884450567},null,4.3084418752693518E-2]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"E58","v":0},{"$f":"F48*E64/100","v":0},null,{"$f":"H48*E64/100","v":0},null,0,null,0]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"E59","v":0},{"$f":"F49*E65/100","v":0},null,{"$f":"H49*E65/100","v":0},null,{"$f":"H65-F65","v":0},null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E63:E64)","v":677.60000000000014},{"$f":"F50*E66/100","v":0.24596880000000007},null,{"$f":"H50*E66/100","v":0.24596880000000007},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F62:F66)","v":204.79428000000004},null,{"$f":"SUM(H62:H66)","v":210.3757936884451},null,5.5815136884450567,null,2.7254246009434713E-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 2014",null,5,{"$f":"F53*E72","v":-0.95},null,0,null,{"$f":"H72-F72","v":0.95},null,{"$f":"IF(ISERROR(J72/F72),0,J72/F72)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,5,0,null,{"$f":"H54*E73","v":1.2},null,{"$f":"H73-F73","v":1.2},null,{"$f":"IF(ISERROR(J73/F73),0,J73/F73)","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F72:F73)","v":-0.95},null,{"$f":"SUM(H72:H73)","v":1.2},null,{"$f":"SUM(J72:J73)","v":2.15},null,-2.263157894736842]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F67,F74)","v":203.84428000000005},null,{"$f":"SUM(H67,H74)","v":211.57579368844509},null,{"$f":"SUM(J67,J74)","v":7.731513688445057},null,{"$f":"IF(ISERROR(J76/F76),0,J76/F76)","v":3.792852901462359E-2}]
[]
[]
[null,null,"Rate 2 - Annual",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E22+E57","v":3508.8}]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"E23+E58","v":3379.8}]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"E24+E59","v":1.1368683772161603E-13}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,{"$f":"E27+E62","v":12},{"$f":"F27+F62","v":180},null,{"$f":"H27+H62","v":180},null,{"$f":"H87-F87","v":0},null,{"$f":"IF(ISERROR(J87/F87),0,J87/F87)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E82","v":3508.8},{"$f":"F28+F63","v":558.9762336},null,{"$f":"H28+H63","v":583.05939972122576},null,{"$f":"H88-F88","v":24.083166121225759},null,4.3084418752693386E-2]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,{"$f":"E83","v":3379.8},{"$f":"F29+F64","v":320.49291479999999},null,{"$f":"H29+H64","v":320.49291479999999},null,0,null,0]
[null,null,"Block 3 (Over 25,000 m3 per month)",null,{"$f":"E84","v":1.1368683772161603E-13},{"$f":"F30+F65","v":7.0142505137482661E-15},null,{"$f":"H30+H65","v":7.0142505137482661E-15},null,{"$f":"H90-F90","v":0},null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E88:E89)","v":6888.6},{"$f":"F31+F66","v":2.5005617999999998},null,{"$f":"H31+H66","v":2.5005617999999998},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F87:F91)","v":1061.9697102},null,{"$f":"SUM(H87:H91)","v":1086.0528763212258},null,24.083166121225759,null,2.2677827710067353E-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 2014",null,{"$f":"E37+E72","v":12},{"$f":"F37+F72","v":-2.2800000000000002},null,{"$f":"H37+H72","v":0},null,{"$f":"H97-F97","v":2.2800000000000002},null,{"$f":"IF(ISERROR(J97/F97),1,J97/F97)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,{"$f":"E38+E73","v":12},{"$f":"F38+F73","v":0},null,{"$f":"H38+H73","v":2.88},null,{"$f":"H98-F98","v":2.88},null,{"$f":"IF(ISERROR(J98/F98),1,J98/F98)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F97:F98)","v":-2.2800000000000002},null,{"$f":"SUM(H97:H98)","v":2.88},null,{"$f":"SUM(J97:J98)","v":5.16},null,{"$f":"IF(ISERROR(J99/F99),0,J99/F99)","v":-2.263157894736842}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F92,F99)","v":1059.6897102},null,{"$f":"SUM(H92,H99)","v":1088.9328763212259},null,{"$f":"SUM(J92,J99)","v":29.243166121225759},null,{"$f":"IF(ISERROR(J101/F101),0,J101/F101)","v":2.7595970631541344E-2}]
[]
[]
[]
[]
[null,null,"Rate 2 - April to October"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,2831.2000000000003]
[null,null,"Block 2 (Next 24,000 m3 per month)",null,3379.8]

{"sheet":"G1.3 Rate 3 Bill Impact","index":23,"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:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[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":3.9430999999999998},null,{"$f":"'E1.1 Proposed Dist Rates '!J21","v":4.0356542753884224}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$21","v":-8.34}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$21,2)","v":10.53}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Delivery - Firm",null,548824.77]
[null,null,"Demand - Firm",null,64233]
[]
[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":548824.77},{"$f":"F18*E32/100","v":21640.709505869996},null,{"$f":"H18*E32/100","v":22148.670294895674},null,{"$f":"H32-F32","v":507.96078902567751},null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":2.3472464656849362E-2}]
[null,null,"Demand - Firm",null,{"$f":"E28","v":64233},{"$f":"F19*E33/100","v":18690.132942},null,{"$f":"H19*E33/100","v":18690.132942},null,0,null,{"$f":"IF(ISERROR(J33/F33),0,J33/F33)","v":0}]
[null,null,"System Gas Charge",null,{"$f":"E27","v":548824.77},{"$f":"F20*E34/100","v":199.22339151},null,{"$f":"H20*E34/100","v":199.22339151},null,0,null,{"$f":"IF(ISERROR(J34/F34),0,J34/F34)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F31:F34)","v":42330.065839379997},null,{"$f":"SUM(H31:H34)","v":42838.026628405678},null,507.96078902568115,null,{"$f":"IF(ISERROR(J35/F35),0,J35/F35)","v":1.199999997526867E-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 2014",null,12,{"$f":"F23*E40","v":-100.08},null,0,null,{"$f":"H40-F40","v":100.08},null,{"$f":"IF(ISERROR(J40/F40),1,J40/F40)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,12,0,null,{"$f":"H24*E41","v":126.35999999999999},null,{"$f":"H41-F41","v":126.35999999999999},null,{"$f":"IF(ISERROR(J41/F41),1,J41/F41)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F40:F41)","v":-100.08},null,{"$f":"SUM(H40:H41)","v":126.35999999999999},null,{"$f":"SUM(J40:J41)","v":226.44},null,{"$f":"IF(ISERROR(J42/F42),0,J42/F42)","v":-2.2625899280575541}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F35,F42)","v":42229.985839379995},null,{"$f":"SUM(H35,H42)","v":42964.386628405678},null,{"$f":"SUM(J35,J42)","v":734.40078902568121},null,{"$f":"IF(ISERROR(J44/F44),0,J44/F44)","v":1.7390505216339506E-2}]

{"sheet":"G1.4 Rate 4 Bill Impact","index":24,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[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.4678},null,{"$f":"'E1.1 Proposed Dist Rates '!F22","v":15.814871790324938}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$22","v":-0.55000000000000004}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$22,2)","v":0.69}]
[]
[null,null,"Average Seasonal Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,5579.7300000000005]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,13417]
[]
[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":5579.7300000000005},{"$f":"F14*E28/100","v":863.06147694000015},null,{"$f":"H14*E28/100","v":882.42714574629781},null,{"$f":"H28-F28","v":19.365668806297663},null,{"$f":"IF(ISERROR(J28/F28),0,J28/F28)","v":2.243834225455061E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E24","v":13417},{"$f":"F15*E29/100","v":1411.7099060000003},null,{"$f":"H15*E29/100","v":1411.7099060000003},null,0,null,{"$f":"IF(ISERROR(J29/F29),0,J29/F29)","v":0}]
[null,null,"System Gas Charge",null,{"$f":"SUM(E28:E29)","v":18996.73},{"$f":"F16*E30/100","v":6.8958129899999996},null,{"$f":"H16*E30/100","v":6.8958129899999996},null,0,null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F27:F30)","v":2416.6671959300006},null,{"$f":"SUM(H27:H30)","v":2436.0328647362985},null,19.36566880629789,null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":8.0133784407353803E-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 2014",null,9,{"$f":"F19*E36","v":-4.95},null,0,null,{"$f":"H36-F36","v":4.95},null,{"$f":"IF(ISERROR(J36/F36),1,J36/F36)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,9,0,null,{"$f":"H20*E37","v":6.2099999999999991},null,{"$f":"H37-F37","v":6.2099999999999991},null,{"$f":"IF(ISERROR(J37/F37),1,J37/F37)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F36:F37)","v":-4.95},null,{"$f":"SUM(H36:H37)","v":6.2099999999999991},null,{"$f":"SUM(J36:J37)","v":11.16},null,{"$f":"IF(ISERROR(J38/F38),0,J38/F38)","v":-2.2545454545454544}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F31,F38)","v":2411.7171959300008},null,{"$f":"SUM(H31,H38)","v":2442.2428647362985},null,{"$f":"SUM(J31,J38)","v":30.52566880629789},null,{"$f":"IF(ISERROR(J40/F40),0,J40/F40)","v":1.2657233964999222E-2}]
[]
[]
[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":19.732700000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!F23","v":20.175469076206372}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$23","v":-0.55000000000000004}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$23,2)","v":0.69}]
[]
[null,null,"Average Seasonal Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,753.83999999999992]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,0]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,3,{"$f":"F45*E59","v":45},null,{"$f":"H45*E59","v":45},null,{"$f":"H59-F59","v":0},null,{"$f":"IF(ISERROR(J59/F59),0,J59/F59)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E55","v":753.83999999999992},{"$f":"F46*E60/100","v":148.75298567999999},null,{"$f":"H46*E60/100","v":152.09075608407412},null,{"$f":"H60-F60","v":3.3377704040741207},null,2.243834225455071E-2]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E56","v":0},{"$f":"F47*E61/100","v":0},null,{"$f":"H47*E61/100","v":0},null,0,null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E60:E61)","v":753.83999999999992},{"$f":"F48*E62/100","v":0.27364391999999993},null,{"$f":"H48*E62/100","v":0.27364391999999993},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F59:F62)","v":194.02662960000001},null,{"$f":"SUM(H59:H62)","v":197.36440000407413},null,3.3377704040741207,null,1.720264074552641E-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 2014",null,3,{"$f":"F51*E68","v":-1.6500000000000001},null,0,null,{"$f":"H68-F68","v":1.6500000000000001},null,{"$f":"IF(ISERROR(J68/F68),1,J68/F68)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,3,0,null,{"$f":"H52*E69","v":2.0699999999999998},null,{"$f":"H69-F69","v":2.0699999999999998},null,{"$f":"IF(ISERROR(J69/F69),1,J69/F69)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F68:F69)","v":-1.6500000000000001},null,{"$f":"SUM(H68:H69)","v":2.0699999999999998},null,{"$f":"SUM(J68:J69)","v":3.7199999999999998},null,{"$f":"IF(ISERROR(J70/F70),0,J70/F70)","v":-2.2545454545454544}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F63,F70)","v":192.3766296},null,{"$f":"SUM(H63,H70)","v":199.43440000407412},null,{"$f":"SUM(J63,J70)","v":7.0577704040741205},null,{"$f":"IF(ISERROR(J72/F72),0,J72/F72)","v":3.6687254677187253E-2}]
[]
[]
[null,null,"Rate 4 - Annual",null,null,"Current Rate",null,"Proposed Rate"]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E23+E55","v":6333.5700000000006}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E24+E56","v":13417}]
[]
[null,null,null,null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Customer",null,{"$f":"E27+E59","v":12},{"$f":"F27+F59","v":180},null,{"$f":"H27+H59","v":180},null,{"$f":"H82-F82","v":0},null,{"$f":"IF(ISERROR(J82/F82),0,J82/F82)","v":0}]
[null,null,"Block 1 (First 1,000 m3 per month)",null,{"$f":"E78","v":6333.5700000000006},{"$f":"F28+F60","v":1011.8144626200001},null,{"$f":"H28+H60","v":1034.517901830372},null,{"$f":"H83-F83","v":22.703439210371926},null,2.2438342254550766E-2]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E79","v":13417},{"$f":"F29+F61","v":1411.7099060000003},null,{"$f":"H29+H61","v":1411.7099060000003},null,0,null,0]
[null,null,"System Gas Charge",null,{"$f":"SUM(E83:E84)","v":19750.57},{"$f":"F30+F62","v":7.1694569099999992},null,{"$f":"H30+H62","v":7.1694569099999992},null,0,null,0]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F82:F85)","v":2610.6938255300001},null,{"$f":"SUM(H82:H85)","v":2633.3972647403725},null,22.70343921037238,null,8.6963239382401823E-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 2014",null,{"$f":"E68+E36","v":12},{"$f":"F68+F36","v":-6.6000000000000005},null,{"$f":"H68+H36","v":0},null,{"$f":"H91-F91","v":6.6000000000000005},null,{"$f":"IF(ISERROR(J91/F91),1,J91/F91)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,{"$f":"E69+E37","v":12},{"$f":"F69+F37","v":0},null,{"$f":"H69+H37","v":8.2799999999999994},null,{"$f":"H92-F92","v":8.2799999999999994},null,{"$f":"IF(ISERROR(J92/F92),1,J92/F92)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F91:F92)","v":-6.6000000000000005},null,{"$f":"SUM(H91:H92)","v":8.2799999999999994},null,{"$f":"SUM(J91:J92)","v":14.879999999999999},null,{"$f":"IF(ISERROR(J93/F93),0,J93/F93)","v":-2.2545454545454544}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F86,F93)","v":2604.0938255300002},null,{"$f":"SUM(H86,H93)","v":2641.6772647403727},null,{"$f":"SUM(J86,J93)","v":37.583439210372376},null,{"$f":"IF(ISERROR(J95/F95),0,J95/F95)","v":1.4432444346633008E-2}]

{"sheet":"G1.5 Rate 5 Bill Impact","index":25,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[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.1024000000000003},null,{"$f":"'E1.1 Proposed Dist Rates '!J24","v":7.1994668879703196}]
[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 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$24","v":-3.02}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$24,2)","v":3.81}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Delivery - Firm",null,189432.34]
[]
[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":189432.34},{"$f":"F18*E30/100","v":13454.24251616},null,{"$f":"H18*E30/100","v":13638.118593407355},null,{"$f":"H30-F30","v":183.87607724735426},null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":1.3666772917650265E-2}]
[null,null,"System Gas Charge",null,{"$f":"E26","v":189432.34},{"$f":"F19*E31/100","v":68.76393942},null,{"$f":"H19*E31/100","v":68.76393942},null,0,null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":0}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F29:F31)","v":15323.00645558},null,{"$f":"SUM(H29:H31)","v":15506.882532827354},null,183.87607724735426,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":1.1999999985668234E-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 2014",null,12,{"$f":"F22*E37","v":-36.24},null,0,null,{"$f":"H37-F37","v":36.24},null,{"$f":"IF(ISERROR(J37/F37),1,J37/F37)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,12,0,null,{"$f":"H23*E38","v":45.72},null,{"$f":"H38-F38","v":45.72},null,{"$f":"IF(ISERROR(J38/F38),1,J38/F38)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F37:F38)","v":-36.24},null,{"$f":"SUM(H37:H38)","v":45.72},null,{"$f":"SUM(J37:J38)","v":81.960000000000008},null,{"$f":"IF(ISERROR(J39/F39),0,J39/F39)","v":-2.26158940397351}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F32,F39)","v":15286.76645558},null,{"$f":"SUM(H32,H39)","v":15552.602532827354},null,{"$f":"SUM(J32,J39)","v":265.8360772473543},null,{"$f":"IF(ISERROR(J41/F41),0,J41/F41)","v":1.7389948228738614E-2}]

{"sheet":"G1.6 Rate 6 Bill Impact","index":26,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[]
[]
[]
[]
[]
[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.8431999999999999},null,{"$f":"'E1.1 Proposed Dist Rates '!J25","v":3.8893830381151338}]
[null,null,"Demand - Firm",null,null,{"$f":"'B1.1 Current Distribution Rates'!K25","v":18.6158},null,{"$f":"'E1.1 Proposed Dist Rates '!K25","v":18.839189600000001}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Changes 2014",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$25","v":-301.13}]
[null,null,"Shared Tax Changes 2015",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$25,2)","v":380.13}]
[]
[null,null,"Average Annual Consumption"]
[null,null,"Delivery - Firm",null,33416816.000000004]
[null,null,"Demand - Firm",null,1297416]
[]
[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":33416816.000000004},{"$f":"F18*E31/100","v":1284275.0725120001},null,{"$f":"H18*E31/100","v":1299707.9733821442},null,{"$f":"H31-F31","v":15432.900870144134},null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":1.2016818826793767E-2}]
[null,null,"Demand - Firm",null,{"$f":"E27","v":1297416},{"$f":"F19*E32/100","v":241524.36772799998},null,{"$f":"H19*E32/100","v":244422.66014073603},null,2898.2924127360457,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":1.2000000000000189E-2}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F30:F32)","v":1527599.4402400001},null,{"$f":"SUM(H30:H32)","v":1545930.6335228803},null,18331.193282880122,null,{"$f":"IF(ISERROR(J33/F33),0,J33/F33)","v":1.2000000000000078E-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 2014",null,12,{"$f":"F22*E38","v":-3613.56},null,0,null,{"$f":"H38-F38","v":3613.56},null,{"$f":"IF(ISERROR(J38/F38),1,J38/F38)","v":-1}]
[null,null,"Shared Tax Changes 2015",null,12,0,null,{"$f":"H23*E39","v":4561.5599999999995},null,{"$f":"H39-F39","v":4561.5599999999995},null,{"$f":"IF(ISERROR(J39/F39),1,J39/F39)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F38:F39)","v":-3613.56},null,{"$f":"SUM(H38:H39)","v":4561.5599999999995},null,{"$f":"SUM(J38:J39)","v":8175.119999999999},null,{"$f":"IF(ISERROR(J40/F40),0,J40/F40)","v":-2.2623451665393683}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F33,F40)","v":1523985.8802400001},null,{"$f":"SUM(H33,H40)","v":1550492.1935228803},null,{"$f":"SUM(J33,J40)","v":26506.313282880121},null,{"$f":"IF(ISERROR(J42/F42),0,J42/F42)","v":1.7392755160373176E-2}]

{"sheet":"G1.7 Summary of Bill Impacts","index":27,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C4","v":"OEB Application Number:          EB-2015-0115"}]
[]
[null,null,"Summary of Bill Impacts"]
[]
[null,null,"Rate Class","Fixed","Volumetric","Rate Rider","Change $","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":5.755882505406305},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J37)","v":2.88},{"$f":"'G1.1 Rate 1 Bill Impact'!J39","v":8.635882505406304},{"$f":"'G1.1 Rate 1 Bill Impact'!L39","v":1.796885323121539E-2}]
[null,null,"Rate 1 - Commercial",{"$f":"'G1.1 Rate 1 Bill Impact'!J57","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J58:J60)","v":19.634865905068978},{"$f":"'G1.1 Rate 1 Bill Impact'!J68","v":2.88},{"$f":"'G1.1 Rate 1 Bill Impact'!J70","v":22.514865905068863},{"$f":"'G1.1 Rate 1 Bill Impact'!L70","v":1.5423931029834326E-2}]
[null,null,"Rate 1 - Industrial",{"$f":"'G1.1 Rate 1 Bill Impact'!J89","v":0},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J90:J92)","v":23.357574854305369},{"$f":"'G1.1 Rate 1 Bill Impact'!J100","v":2.88},{"$f":"'G1.1 Rate 1 Bill Impact'!J102","v":26.237574854305539},{"$f":"'G1.1 Rate 1 Bill Impact'!L102","v":1.4090471589629019E-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":18.501652432780702},{"$f":"'G1.2 Rate 2 Bill Impact'!J39","v":3.01},{"$f":"SUM(D13:F13)","v":21.5116524327807},{"$f":"'G1.2 Rate 2 Bill Impact'!L41","v":2.513497376243945E-2}]
[null,null,{"$f":"'G1.2 Rate 2 Bill Impact'!C44","v":"Rate 2 - November to March"},{"$f":"'G1.2 Rate 2 Bill Impact'!J62","v":0},{"$f":"'G1.2 Rate 2 Bill Impact'!J67-'G1.7 Summary of Bill Impacts'!D14","v":5.5815136884450567},{"$f":"'G1.2 Rate 2 Bill Impact'!J74","v":2.15},{"$f":"SUM(D14:F14)","v":7.731513688445057},{"$f":"'G1.2 Rate 2 Bill Impact'!L76","v":3.792852901462359E-2}]
[null,null,{"$f":"'G1.2 Rate 2 Bill Impact'!C79","v":"Rate 2 - Annual"},{"$f":"'G1.2 Rate 2 Bill Impact'!J87","v":0},{"$f":"'G1.2 Rate 2 Bill Impact'!J92-'G1.7 Summary of Bill Impacts'!D15","v":24.083166121225759},{"$f":"'G1.2 Rate 2 Bill Impact'!J99","v":5.16},{"$f":"SUM(D15:F15)","v":29.243166121225759},{"$f":"'G1.2 Rate 2 Bill Impact'!L101","v":2.7595970631541344E-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":507.96078902568115},{"$f":"'G1.3 Rate 3 Bill Impact'!J42","v":226.44},{"$f":"SUM(D17:F17)","v":734.40078902568121},{"$f":"'G1.3 Rate 3 Bill Impact'!L44","v":1.7390505216339506E-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":19.36566880629789},{"$f":"'G1.4 Rate 4 Bill Impact'!J38","v":11.16},{"$f":"SUM(D19:F19)","v":30.52566880629789},{"$f":"'G1.4 Rate 4 Bill Impact'!L40","v":1.2657233964999222E-2}]
[null,null,{"$f":"'G1.4 Rate 4 Bill Impact'!C43","v":"Rate 4 - January to March"},{"$f":"'G1.4 Rate 4 Bill Impact'!J59","v":0},{"$f":"'G1.4 Rate 4 Bill Impact'!J63-'G1.7 Summary of Bill Impacts'!D20","v":3.3377704040741207},{"$f":"'G1.4 Rate 4 Bill Impact'!J70","v":3.7199999999999998},{"$f":"SUM(D20:F20)","v":7.0577704040741205},{"$f":"'G1.4 Rate 4 Bill Impact'!L72","v":3.6687254677187253E-2}]
[null,null,{"$f":"'G1.4 Rate 4 Bill Impact'!C75","v":"Rate 4 - Annual"},{"$f":"'G1.4 Rate 4 Bill Impact'!J82","v":0},{"$f":"'G1.4 Rate 4 Bill Impact'!J86-'G1.7 Summary of Bill Impacts'!D21","v":22.70343921037238},{"$f":"'G1.4 Rate 4 Bill Impact'!J93","v":14.879999999999999},{"$f":"SUM(D21:F21)","v":37.583439210372376},{"$f":"'G1.4 Rate 4 Bill Impact'!L95","v":1.4432444346633008E-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":183.87607724735426},{"$f":"'G1.5 Rate 5 Bill Impact'!J39","v":81.960000000000008},{"$f":"SUM(D23:F23)","v":265.8360772473543},{"$f":"'G1.5 Rate 5 Bill Impact'!L41","v":1.7389948228738614E-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":18331.193282880122},{"$f":"'G1.6 Rate 6 Bill Impact'!J40","v":8175.119999999999},{"$f":"SUM(D25:F25)","v":26506.313282880121},{"$f":"'G1.6 Rate 6 Bill Impact'!L42","v":1.7392755160373176E-2}]