{"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 Savings","F1.2 Alloc Shared Tax Savings","F2.1 Deferred Revenue Recovery","F1.3 Proposed Rate Riders","G1.7 Summary of Bill Impacts","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"],"not_rendered":{"charts":0,"images":5,"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":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,"GD Rate Generator   release 1.0    © Elenchus Research Associates"]
[null,null,{"$f":" \"Name of LDC:       \" &D20","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":" \"OEB Application Number:          \" & D22","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[null,null,"Distributor Information"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Distributor Name","Natural Resource Gas Limited"]
[]
[null,null,"OEB Application Number","EB-2012-0342"]

{"sheet":"B1.1 Current Distribution Rates","index":1,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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.401400000000001,10.5303,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 1 - General Service Rate - Commercial",null,13.5,15.401400000000001,10.5303,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 1 - General Service Rate - Industrial",null,13.5,15.401400000000001,10.5303,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,15,13.904999999999999,null,9.4825999999999997,6.1698000000000004,null,null,3.6299999999999999E-2]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,15,17.527000000000001,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.7644000000000002,29.0974,3.6299999999999999E-2,7.9412000000000003,10.9612]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,15,14.7971,10.521800000000001,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,15,18.877199999999998,16.905200000000001,null,null,null,null,3.6299999999999999E-2]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,150,null,null,null,null,6.915,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.7538999999999998,18.183700000000002,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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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":1905119.4509340001},{"$f":"'B1.1 Current Distribution Rates'!G16*'B1.2 Billing Determinants'!G16/100","v":77271.320323019376},{"$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":3049853.871087363}]
[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":271095.44280000002},{"$f":"'B1.1 Current Distribution Rates'!G17*'B1.2 Billing Determinants'!G17/100","v":249731.33048030882},{"$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":589394.598533171}]
[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":20191.235399999994},{"$f":"'B1.1 Current Distribution Rates'!G18*'B1.2 Billing Determinants'!G18/100","v":49168.884019543751},{"$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},76381.203462324993]
[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":17211.469949999999},{"$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},56297.695095999996]
[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":996.93575999999996},{"$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},13360.342860000002]
[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":82639.838919372996},{"$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},165397.26425680588]
[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":31918.824410000001},{"$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},58458.169445949243]
[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":824.59232496969719},{"$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},4058.4905286363637]
[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":65496.232220888895},{"$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},74840.051921484453]
[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":1254433.855824},{"$f":"'B1.1 Current Distribution Rates'!K25*'B1.2 Billing Determinants'!K25/100","v":236070.97627200003},{"$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},1492304.832096]
[null,null,null,null,{"$f":"SUM(E16:E25)","v":1171858.5},{"$f":"SUM(F16:F25)","v":2247357.9515789696},401639.88072532613,38127.094066000005,0,1402569.9269642618,310831.50804000004,7961.6579131772869,0,0,5580346.5192877352]

{"sheet":"C1.1 Current Rate Riders","index":4,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[null,null,"Current Rate Riders"]
[]
[null,null,"Description",null,"Shared Tax Savings","PGTVA/REDA","System Gas Over-Recovery"]
[null,null,"Effective Until",null,"September 30, 2012","September 30, 2011","September 30, 2011"]
[null,null,null,null,"per customer per month","per customer per month","per m3"]
[null,null,"Rate Group"]
[null,null,"RATE 1 - General Service Rate - Residential",null,-0.11,0,0]
[null,null,"RATE 1 - General Service Rate - Commercial",null,-0.11,0,0]
[null,null,"RATE 1 - General Service Rate - Industrial",null,-0.11,0,0]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,-0.2,0,0]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,-0.2,0,0]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,-8.84,0,0]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,-0.57999999999999996,0,0]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,-0.57999999999999996,0,0]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,-3.2,0,0]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,-319.14,0]

{"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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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":3715629.6730828593},null,{"$f":"E16/$E$22","v":0.66584210500911956},null,{"$f":"$I$22*G16","v":16561.309084590463},null,{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":7015.916666666667},null,12,null,{"$f":"I16/K16/M16","v":0.1967111577792218}]
[null,null,"RATE 2 - Seasonal Service ",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O19:O20)","v":69658.037956},null,1.2482744165659988E-2,null,310.47989124768844,null,{"$f":"'B1.2 Billing Determinants'!E19","v":73},null,12,null,{"$f":"I17/K17/M17","v":0.35442909959781788}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.3 Current Rev Req From Rates'!O21","v":165397.26425680588},null,2.9639246180345961E-2,null,737.20888681296867,null,{"$f":"'B1.2 Billing Determinants'!E21","v":4},null,12,null,15.358518475270181]
[null,null,"RATE 4 - General Service Peaking",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O22:O23)","v":62516.659974585607},null,1.1203006795098652E-2,null,278.64933264899918,null,{"$f":"'B1.2 Billing Determinants'!E22","v":23},null,12,null,1.0095990313369536]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.3 Current Rev Req From Rates'!O24","v":74840.051921484453},null,1.3411362836126688E-2,null,333.57717017856925,null,{"$f":"'B1.2 Billing Determinants'!E24","v":5},null,12,null,5.5596195029761546]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.3 Current Rev Req From Rates'!O25","v":1492304.832096},null,0.26742153501364913,null,6651.5029072485813,null,{"$f":"'B1.2 Billing Determinants'!E25","v":1},null,12,null,554.29190893738178]
[null,null,null,null,{"$f":"SUM(E16:E21)","v":5580346.5192877352},null,{"$f":"SUM(G16:G21)","v":1},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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[null,null,"Rate 1 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,0.02,null,"MSC Increment",0]
[null,null,"Less Productivity",null,7.1999999999999998E-3]
[null,null,"Less Stretch Factor",null,5.0000000000000001E-3]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":7.8000000000000005E-3}]
[]
[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":7.8000000000000005E-3},{"$f":"E17*(1+F17)","v":13.6053},{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":7015.916666666667},{"$f":"G17*H17*12","v":1145443.8122999999},"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.401400000000001},{"$f":"E14","v":7.8000000000000005E-3},{"$f":"E18*(1+F18)","v":15.521530920000002},{"$f":"SUM('B1.2 Billing Determinants'!F16:F18)","v":14261081},{"$f":"G18*H18/100","v":2213538.0969412457},"Re-Balance",{"$f":"L18/H18*100","v":15.574907691239225},{"$f":"(I18/SUM($I$18,$I$19))*($I$21-SUM($L$17,$L$20))","v":2221150.201522856}]
[null,null,"Delivery\nOver 1,000 m3",null,{"$f":"'B1.1 Current Distribution Rates'!G16","v":10.5303},{"$f":"E14","v":7.8000000000000005E-3},10.61243634,{"$f":"SUM('B1.2 Billing Determinants'!G16:G18)","v":3572277.4737934526},{"$f":"G19*H19/100","v":379105.67279449035},"Change",{"$f":"G19","v":10.61243634},{"$f":"(I19/SUM($I$18,$I$19))*($I$21-SUM($L$17,$L$20))","v":380409.37388406321}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L16","v":3.6299999999999999E-2},{"$f":"E14","v":7.8000000000000005E-3},3.658314E-2,{"$f":"SUM('B1.2 Billing Determinants'!L16:L18)","v":17833358.473793454},6524.0024971697221,"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":3744611.5845329058},null,null,{"$f":"SUM(L17:L20)","v":3744611.5845329063}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"I21-L21","v":0}]

{"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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[null,null,"Rate 2 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":0.02},null,"MSC Increment",0]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":7.1999999999999998E-3}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":5.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":7.8000000000000005E-3}]
[]
[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":7.8000000000000005E-3},{"$f":"E17*(1+F17)","v":15.117000000000001},{"$f":"'B1.2 Billing Determinants'!E19","v":73},{"$f":"G17*H17*12","v":13242.492000000002},"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":13.904999999999999},{"$f":"$E$14","v":7.8000000000000005E-3},{"$f":"E18*(1+F18)","v":14.013458999999999},{"$f":"'B1.2 Billing Determinants'!F19","v":123779},{"$f":"G18*H18/100","v":17345.719415610001},"Re-Balance",{"$f":"L18/H18*100","v":14.319920518522972},{"$f":"(I18/($I$18+$I$21))*(I25-SUM(L17,L19:L20,L22:L24))","v":17725.054418622549}]
[null,null,"Delivery Next 24,000 m3 - Apr To Oct",null,{"$f":"'B1.1 Current Distribution Rates'!H19","v":9.4825999999999997},7.8000000000000005E-3,9.5565642799999999,{"$f":"'B1.2 Billing Determinants'!H19","v":329621.00000000006},{"$f":"G19*H19/100","v":31500.442745378805},"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},7.8000000000000005E-3,6.2179244400000009,{"$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":17.527000000000001},7.8000000000000005E-3,17.663710600000002,{"$f":"'B1.2 Billing Determinants'!F20","v":5688},1004.7118589280002,"Re-Balance",{"$f":"L21/H21*100","v":18.049999779083219},{"$f":"(I21/($I$18+$I$21))*(I25-SUM(L17,L19:L20,L22:L24))","v":1026.6839874342534}]
[null,null,"Delivery Next 24,000 m3 - Nov To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!H20","v":15.696},7.8000000000000005E-3,15.8184288,{"$f":"'B1.2 Billing Determinants'!H20","v":43772.000000000007},6924.0426543360009,"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},7.8000000000000005E-3,15.40916122,{"$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},7.8000000000000005E-3,3.658314E-2,{"$f":"SUM('B1.2 Billing Determinants'!L19:L20)","v":502860.00000000006},183.96197780400001,"No Change",3.6299999999999999E-2,182.53818000000004]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I24)","v":70201.370652056808},null,null,{"$f":"SUM(L17:L24)","v":70201.370652056808}]
[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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[null,null,"Rate 3 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":0.02},null,"MSC Increment",0]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":7.1999999999999998E-3}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":5.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":7.8000000000000005E-3}]
[]
[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":7.8000000000000005E-3},{"$f":"E17*(1+F17)","v":151.17000000000002},{"$f":"'B1.2 Billing Determinants'!E21","v":4},{"$f":"G17*H17*12","v":7256.1600000000008},"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.7644000000000002},{"$f":"E14","v":7.8000000000000005E-3},{"$f":"E18*(1+F18)","v":3.7937623200000004},{"$f":"'B1.2 Billing Determinants'!J21","v":2195299.0893468545},{"$f":"G18*H18/100","v":83284.429662944109},"Re-Balance",{"$f":"L18/H18*100","v":3.8231664190024763},{"$f":"I21-(L17+L19+L20)","v":83929.937580576108}]
[null,null,"Demand Firm",null,{"$f":"'B1.1 Current Distribution Rates'!K21","v":29.0974},{"$f":"E14","v":7.8000000000000005E-3},29.32435972,{"$f":"'B1.2 Billing Determinants'!K21","v":256932},{"$f":"G19*H19/100","v":75343.663915790399},"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":7.8000000000000005E-3},3.658314E-2,{"$f":"'B1.2 Billing Determinants'!L21","v":2195299.0893468545},803.1093392744848,"No Change",3.6299999999999999E-2,{"$f":"H20*K20/100","v":796.89356943290807}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I20)","v":166687.36291800902},null,null,{"$f":"SUM(L17:L20)","v":166687.36291800899}]
[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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[null,null,"Rate 4 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":0.02},null,"MSC Increment",0]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":7.1999999999999998E-3}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":5.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":7.8000000000000005E-3}]
[]
[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":7.8000000000000005E-3},{"$f":"E17*(1+F17)","v":15.117000000000001},{"$f":"'B1.2 Billing Determinants'!E22","v":23},{"$f":"G17*H17*12","v":4172.2920000000004},"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":14.7971},{"$f":"$E$14","v":7.8000000000000005E-3},{"$f":"E18*(1+F18)","v":14.912517380000001},{"$f":"'B1.2 Billing Determinants'!F22","v":215710},{"$f":"G18*H18/100","v":32167.791240398001},"Re-Balance",{"$f":"L18/H18*100","v":15.01746518543624},{"$f":"(I18/($I$18+$I$20))*($I$23-SUM($L$17,$L$19,$L$21:$L$22))","v":32394.174151504514}]
[null,null,"Delivery Over 1,000 m3 - Apr To Dec",null,{"$f":"'B1.1 Current Distribution Rates'!G22","v":10.521800000000001},7.8000000000000005E-3,10.60387004,{"$f":"'B1.2 Billing Determinants'!G22","v":221214.44489017199},{"$f":"G19*H19/100","v":23457.292245861259},"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":18.877199999999998},7.8000000000000005E-3,19.02444216,{"$f":"'B1.2 Billing Determinants'!F23","v":4368.1919191919205},831.0241451044609,"Re-Balance",{"$f":"L20/H20*100","v":19.158327901988699},{"$f":"(I20/($I$18+$I$20))*($I$23-SUM($L$17,$L$19,$L$21:$L$22))","v":836.87253126696135}]
[null,null,"Delivery Over 1,000 m3 - Jan To Mar",null,{"$f":"'B1.1 Current Distribution Rates'!G23","v":16.905200000000001},7.8000000000000005E-3,17.03706056,{"$f":"'B1.2 Billing Determinants'!G23","v":12970},2209.706754632,"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},7.8000000000000005E-3,3.658314E-2,{"$f":"SUM('B1.2 Billing Determinants'!L22:L23)","v":454262.6368093639},166.18353639166114,"No Change",3.6299999999999999E-2,164.89733716179907]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I22)","v":63004.28992238739},null,null,{"$f":"SUM(L17:L22)","v":63004.28992238739}]
[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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[null,null,"Rate 5 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":0.02},null,"MSC Increment",0]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":7.1999999999999998E-3}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":5.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":7.8000000000000005E-3}]
[]
[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":7.8000000000000005E-3},{"$f":"E17*(1+F17)","v":151.17000000000002},{"$f":"'B1.2 Billing Determinants'!E24","v":5},{"$f":"G17*H17*12","v":9070.2000000000007},"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":6.915},{"$f":"E14","v":7.8000000000000005E-3},{"$f":"E18*(1+F18)","v":6.9689370000000004},{"$f":"'B1.2 Billing Determinants'!J24","v":947161.70962962962},{"$f":"G18*H18/100","v":66007.102832211822},"Re-Balance",{"$f":"L18/H18*100","v":6.9766317571807068},{"$f":"I20-L17-L19","v":66079.984625876459}]
[null,null,"Commodity",null,{"$f":"'B1.1 Current Distribution Rates'!L24","v":3.6299999999999999E-2},{"$f":"E14","v":7.8000000000000005E-3},3.658314E-2,{"$f":"'B1.2 Billing Determinants'!L24","v":947161.70962962962},{"$f":"G19*H19/100","v":346.50149426020084},"No Change",3.6299999999999999E-2,{"$f":"H19*K19/100","v":343.81970059555556}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I19)","v":75423.804326472018},null,null,{"$f":"SUM(L17:L19)","v":75423.804326472018}]
[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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[null,null,"Rate 6 Price Cap Adjustment"]
[]
[]
[null,null,"GDP-IPI",null,{"$f":"'D1.1 Rate 1 Adjustment'!E11","v":0.02},null,"MSC Increment",0]
[null,null,"Less Productivity",null,{"$f":"'D1.1 Rate 1 Adjustment'!E12","v":7.1999999999999998E-3}]
[null,null,"Less Stretch Factor",null,{"$f":"'D1.1 Rate 1 Adjustment'!E13","v":5.0000000000000001E-3}]
[null,null,"Price Cap Adjustment",null,{"$f":"E11-E12-E13","v":7.8000000000000005E-3}]
[]
[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":7.8000000000000005E-3},{"$f":"E17*(1+F17)","v":151.17000000000002},{"$f":"'B1.2 Billing Determinants'!E25","v":1},{"$f":"G17*H17*12","v":1814.0400000000002},"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.7538999999999998},{"$f":"E14","v":7.8000000000000005E-3},{"$f":"E18*(1+F18)","v":3.7831804199999999},{"$f":"'B1.2 Billing Determinants'!J25","v":33416816},{"$f":"G18*H18/100","v":1264218.4398994271},"Re-Balance",{"$f":"L18/H18*100","v":3.7832224347748364},{"$f":"I20-(L17+L19)","v":1264232.4798994272}]
[null,null,"Demand Firm",null,{"$f":"'B1.1 Current Distribution Rates'!K25","v":18.183700000000002},{"$f":"E14","v":7.8000000000000005E-3},18.325532860000003,{"$f":"'B1.2 Billing Determinants'!K25","v":1298256},{"$f":"G19*H19/100","v":237912.32988692165},"Change",{"$f":"G19","v":18.325532860000003},{"$f":"H19*K19/100","v":237912.32988692165}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I19)","v":1503944.8097863488},null,null,{"$f":"SUM(L17:L19)","v":1503944.8097863488}]
[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":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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":15.574907691239225},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":10.61243634},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":15.574907691239225},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":10.61243634},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":15.574907691239225},{"$f":"'D1.1 Rate 1 Adjustment'!K19","v":10.61243634},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":14.319920518522972},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":18.049999779083219},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":3.8231664190024763},{"$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.01746518543624},{"$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":19.158327901988699},{"$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":6.9766317571807068},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.7832224347748364},{"$f":"'D1.6 Rate 6 Adjustment'!K19","v":18.325532860000003},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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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":1926581.9723584484},{"$f":"'E1.1 Proposed Dist Rates '!G16*'E1.2 Billing Determinants'!G16/100","v":77874.036621538937},{"$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":3071919.1088103307}]
[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":274149.52518119285},{"$f":"'E1.1 Proposed Dist Rates '!G17*'E1.2 Billing Determinants'!G17/100","v":251679.23485805525},{"$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":594396.58529211022}]
[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":20418.703983214622},{"$f":"'E1.1 Proposed Dist Rates '!G18*'E1.2 Billing Determinants'!G18/100","v":49552.401314896189},{"$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},76992.189340892059]
[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":17725.054418622549},{"$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},56811.27956462255]
[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":1026.6839874342536},{"$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},13390.091087434255]
[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":83929.937580576108},{"$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},166687.36291800899]
[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":32394.174151504514},{"$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},58933.519187453756]
[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":836.87253126696135},{"$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},4070.7707349336279]
[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":66079.984625876459},{"$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},75423.804326472018]
[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":1264232.4798994272},{"$f":"'E1.1 Proposed Dist Rates '!K25*'E1.2 Billing Determinants'!K25/100","v":237912.32988692165},{"$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},1503944.8097863488]
[null,null,null,null,{"$f":"SUM(E16:E25)","v":1171858.5},{"$f":"SUM(F16:F25)","v":2273132.9866116839},404574.01869694452,38127.094066000005,0,1414242.4021058797,312672.86165492167,7961.6579131772869,0,0,5622569.5210486073]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Revenue Requirement",{"$f":"O26","v":5622569.5210486073}]
[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":5580346.5192877352}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Change",{"$f":"O28-O29","v":42223.001760872081}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O30/O29","v":7.5663763199890575E-3}]

{"sheet":"F1.1 Calc Shared Tax Savings","index":17,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[null,null,"Tax Sharing Rate Rider"]
[]
[]
[]
[null,null,null,null,2010,null,2011,null,2012,null,2013,null,2014]
[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,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,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,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":"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,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,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,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,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,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,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,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}]

{"sheet":"F1.2 Alloc Shared Tax Savings","index":18,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[null,null,"Allocation of Shared Tax Sharing"]
[]
[]
[]
[]
[null,null,"Rate Group",null,"Revenue By Rate Class",null,"Proportionate Revenue",null,"Shared Tax Sharing",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":3715629.6730828593},null,{"$f":"E16/$E$22","v":0.66584210500911956},null,{"$f":"$I$22*G16","v":-8994.3169562972307},null,{"$f":"SUM('B1.2 Billing Determinants'!E16:E18)","v":7015.916666666667},null,6,null,{"$f":"ROUND(I16/K16/M16,2)","v":-0.21}]
[null,null,"RATE 2 - Seasonal Service ",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O19:O20)","v":69658.037956},null,1.2482744165659988E-2,null,-168.61919164571037,null,{"$f":"'B1.2 Billing Determinants'!E19","v":73},null,6,null,{"$f":"ROUND(I17/K17/M17,2)","v":-0.38}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'B1.3 Current Rev Req From Rates'!O21","v":165397.26425680588},null,2.9639246180345961E-2,null,-400.37235928193871,null,{"$f":"'B1.2 Billing Determinants'!E21","v":4},null,6,null,-16.68]
[null,null,"RATE 4 - General Service Peaking",null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O22:O23)","v":62516.659974585607},null,1.1203006795098652E-2,null,-151.33226514308345,null,{"$f":"'B1.2 Billing Determinants'!E22","v":23},null,6,null,-1.1000000000000001]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'B1.3 Current Rev Req From Rates'!O24","v":74840.051921484453},null,1.3411362836126688E-2,null,-181.16314251766437,null,{"$f":"'B1.2 Billing Determinants'!E24","v":5},null,6,null,-6.04]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'B1.3 Current Rev Req From Rates'!O25","v":1492304.832096},null,0.26742153501364913,null,-3612.3790141198028,null,{"$f":"'B1.2 Billing Determinants'!E25","v":1},null,6,null,-602.05999999999995]
[null,null,null,null,{"$f":"SUM(E16:E21)","v":5580346.5192877352},null,{"$f":"SUM(G16:G21)","v":1},null,{"$f":"-'F1.1 Calc Shared Tax Savings'!I33","v":-13508.18292900543},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":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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 Savings'!C16","v":"RATE 1 - General Service Rate"},null,{"$f":"SUM('E1.3 Proposed Rev Req From Rate'!O16:O18)","v":3743307.8834433332},null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O16:O18)","v":3715629.6730828593},null,{"$f":"E17-G17","v":27678.210360473953},null,{"$f":"I17/12*6","v":13839.105180236977},null,{"$f":"'F1.2 Alloc Shared Tax Savings'!K16","v":7015.916666666667},null,{"$f":"ROUND(K17/M17/6,2)","v":0.33}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!C17","v":"RATE 2 - Seasonal Service "},null,{"$f":"SUM('E1.3 Proposed Rev Req From Rate'!O19:O20)","v":70201.370652056808},null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O19:O20)","v":69658.037956},null,{"$f":"E18-G18","v":543.33269605680835},null,{"$f":"I18/12*6","v":271.66634802840417},null,{"$f":"'F1.2 Alloc Shared Tax Savings'!K17","v":73},null,{"$f":"ROUND(K18/M18/6,2)","v":0.62}]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!C18","v":"RATE 3 - Special Large Volume Contract Rate"},null,{"$f":"'E1.3 Proposed Rev Req From Rate'!O21","v":166687.36291800899},null,{"$f":"'B1.3 Current Rev Req From Rates'!O21","v":165397.26425680588},null,1290.098661203112,null,645.04933060155599,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!K18","v":4},null,26.88]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!C19","v":"RATE 4 - General Service Peaking"},null,{"$f":"SUM('E1.3 Proposed Rev Req From Rate'!O22:O23)","v":63004.289922387383},null,{"$f":"SUM('B1.3 Current Rev Req From Rates'!O22:O23)","v":62516.659974585607},null,487.62994780177542,null,243.81497390088771,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!K19","v":23},null,1.77]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!C20","v":"RATE 5 - Interruptible Peaking Contract Rate"},null,{"$f":"'E1.3 Proposed Rev Req From Rate'!O24","v":75423.804326472018},null,{"$f":"'B1.3 Current Rev Req From Rates'!O24","v":74840.051921484453},null,583.75240498756466,null,291.87620249378233,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!K20","v":5},null,9.73]
[null,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!C21","v":"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility"},null,{"$f":"'E1.3 Proposed Rev Req From Rate'!O25","v":1503944.8097863488},null,{"$f":"'B1.3 Current Rev Req From Rates'!O25","v":1492304.832096},null,11639.977690348867,null,5819.9888451744337,null,{"$f":"'F1.2 Alloc Shared Tax Savings'!K21","v":1},null,970]
[null,null,null,null,{"$f":"SUM(E17:E22)","v":5622569.5210486073},null,{"$f":"SUM(G17:G22)","v":5580346.5192877352},null,{"$f":"SUM(I17:I22)","v":42223.001760872081},null,{"$f":"SUM(K17:K22)","v":21111.50088043604},null,{"$f":"SUM(M17:M22)","v":7121.916666666667}]
[null,null,null,null,null,null,null,null,{"$f":"I23/G23","v":7.5663763199890575E-3}]

{"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'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[null,null,"Proposed Rate Riders"]
[]
[null,null,"Description",null,"Shared Tax Savings",null,"Deferred Revenue Recovery"]
[null,null,"Effective Until",null,"September 30, 2013",null,"September 30, 2013"]
[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 Savings'!$O$16","v":-0.21},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O17","v":0.33}]
[null,null,"RATE 1 - General Service Rate - Commercial",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$16","v":-0.21},null,{"$f":"G16","v":0.33}]
[null,null,"RATE 1 - General Service Rate - Industrial",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$16","v":-0.21},null,{"$f":"G17","v":0.33}]
[null,null,"RATE 2 - Seasonal Service - Apr to Oct",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$17","v":-0.38},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O18","v":0.62}]
[null,null,"RATE 2 - Seasonal Service - Nov to Mar",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$17","v":-0.38},null,{"$f":"G19","v":0.62}]
[null,null,"RATE 3 - Special Large Volume Contract Rate",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$18","v":-16.68},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O19","v":26.88}]
[null,null,"RATE 4 - General Service Peaking - Apr to Dec",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$19","v":-1.1000000000000001},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O20","v":1.77}]
[null,null,"RATE 4 - General Service Peaking - Jan to Mar",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$19","v":-1.1000000000000001},null,{"$f":"G22","v":1.77}]
[null,null,"RATE 5 - Interruptible Peaking Contract Rate",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$20","v":-6.04},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O21","v":9.73}]
[null,null,"RATE 6 - Integrated Grain Processors Co-Operative Aylmer Ethanol Production Facility",null,{"$f":"'F1.2 Alloc Shared Tax Savings'!$O$21","v":-602.05999999999995},null,{"$f":"'F2.1 Deferred Revenue Recovery'!O22","v":970}]

{"sheet":"G1.7 Summary of Bill Impacts","index":21,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"GD Rate Generator   release 1.0    © Elenchus Research Associates"]
[null,null,"Name of LDC:       Natural Resource Gas Limited"]
[null,null,"OEB Application Number:          EB-2012-0342"]
[]
[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":3.4736239786092824},{"$f":"SUM('G1.1 Rate 1 Bill Impact'!J37)","v":6.0000000000000053E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J39","v":3.5336239786092825},{"$f":"'G1.1 Rate 1 Bill Impact'!L39","v":7.522413746964737E-3}]
[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":12.082316586691832},{"$f":"'G1.1 Rate 1 Bill Impact'!J68","v":6.0000000000000053E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J70","v":12.142316586691832},{"$f":"'G1.1 Rate 1 Bill Impact'!L70","v":8.5368242678939034E-3}]
[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":14.548007038288688},{"$f":"'G1.1 Rate 1 Bill Impact'!J100","v":6.0000000000000053E-2},{"$f":"'G1.1 Rate 1 Bill Impact'!J102","v":14.608007038288688},{"$f":"'G1.1 Rate 1 Bill Impact'!L102","v":8.0381524329008833E-3}]
[]
[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":11.747229720422411},{"$f":"'G1.2 Rate 2 Bill Impact'!J39","v":-0.88000000000000012},{"$f":"SUM(D13:F13)","v":10.86722972042241},{"$f":"'G1.2 Rate 2 Bill Impact'!L41","v":1.3252301112863027E-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":3.5438465030678685},{"$f":"'G1.2 Rate 2 Bill Impact'!J74","v":1},{"$f":"SUM(D14:F14)","v":4.5438465030678685},{"$f":"'G1.2 Rate 2 Bill Impact'!L76","v":2.3542157969870723E-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":15.291076223490109},{"$f":"'G1.2 Rate 2 Bill Impact'!J99","v":0.12000000000000011},{"$f":"SUM(D15:F15)","v":15.41107622349011},{"$f":"'G1.2 Rate 2 Bill Impact'!L101","v":1.5212780841206848E-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":322.52466392757196},{"$f":"'G1.3 Rate 3 Bill Impact'!J42","v":6},{"$f":"SUM(D17:F17)","v":328.52466392757196},{"$f":"'G1.3 Rate 3 Bill Impact'!L44","v":7.9655404373120461E-3}]
[]
[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":12.295782361341935},{"$f":"'G1.4 Rate 4 Bill Impact'!J38","v":-1.3800000000000008},{"$f":"SUM(D19:F19)","v":10.915782361341934},{"$f":"'G1.4 Rate 4 Bill Impact'!L40","v":4.5980085314487234E-3}]
[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":2.1192545763516364},{"$f":"'G1.4 Rate 4 Bill Impact'!J70","v":1.7399999999999998},{"$f":"SUM(D20:F20)","v":3.8592545763516362},{"$f":"'G1.4 Rate 4 Bill Impact'!L72","v":2.0766820402630993E-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":14.415036937693458},{"$f":"'G1.4 Rate 4 Bill Impact'!J93","v":0.35999999999999854},{"$f":"SUM(D21:F21)","v":14.775036937693457},{"$f":"'G1.4 Rate 4 Bill Impact'!L95","v":5.7718111236560793E-3}]
[]
[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":116.75047981053103},{"$f":"'G1.5 Rate 5 Bill Impact'!J39","v":2.1600000000000037},{"$f":"SUM(D23:F23)","v":118.91047981053103},{"$f":"'G1.5 Rate 5 Bill Impact'!L41","v":7.9647410626265906E-3}]
[]
[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":11638.786294324789},{"$f":"'G1.6 Rate 6 Bill Impact'!J40","v":217.32000000000016},{"$f":"SUM(D25:F25)","v":11856.106294324789},{"$f":"'G1.6 Rate 6 Bill Impact'!L42","v":7.9660873359848269E-3}]

{"sheet":"G1.1 Rate 1 Bill Impact","index":22,"n_rows":102,"n_cols":12,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[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.401400000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!F16","v":15.574907691239225}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G16","v":10.5303},null,{"$f":"'E1.1 Proposed Dist Rates '!G16","v":10.61243634}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$16","v":-0.11}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$16,2)","v":-0.21}]
[]
[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":308.336028},null,{"$f":"H13*E27/100","v":311.80965197860928},null,{"$f":"H27-F27","v":3.4736239786092824},null,{"$f":"IF(ISERROR(J27/F27),0,J27/F27)","v":1.1265709041984812E-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":471.06602800000002},null,{"$f":"SUM(H26:H29)","v":474.5396519786093},null,3.4736239786092824,null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":7.3739640987426124E-3}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",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 Savings 2012",null,6,0,null,{"$f":"H19*E36","v":-1.26},null,{"$f":"H36-F36","v":-1.26},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.26},null,{"$f":"SUM(J35:J36)","v":6.0000000000000053E-2},null,{"$f":"IF(ISERROR(J37/F37),0,J37/F37)","v":-4.5454545454545491E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F30,F37)","v":469.74602800000002},null,{"$f":"SUM(H30,H37)","v":473.27965197860931},null,{"$f":"SUM(J30,J37)","v":3.5336239786092825},null,{"$f":"IF(ISERROR(J39/F39),0,J39/F39)","v":7.522413746964737E-3}]
[]
[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.401400000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!F17","v":15.574907691239225}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G17","v":10.5303},null,{"$f":"'E1.1 Proposed Dist Rates '!G17","v":10.61243634}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$17","v":-0.11}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!E17,2)","v":-0.21}]
[]
[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":654.86752799999999},null,{"$f":"H44*E58/100","v":662.24507503149187},null,{"$f":"H58-F58","v":7.3775470314918721},null,{"$f":"IF(ISERROR(J58/F58),0,J58/F58)","v":1.1265709041984859E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E54","v":5728},{"$f":"F45*E59/100","v":603.17558400000007},null,{"$f":"H45*E59/100","v":607.88035355520003},null,4.7047695551999595,null,{"$f":"IF(ISERROR(J59/F59),0,J59/F59)","v":7.799999999999932E-3}]
[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":1423.6658520000001},null,{"$f":"SUM(H57:H60)","v":1435.7481685866919},null,12.082316586691832,null,{"$f":"IF(ISERROR(J61/F61),0,J61/F61)","v":8.4867643413082516E-3}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",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 Savings 2012",null,6,0,null,{"$f":"H50*E67","v":-1.26},null,{"$f":"H67-F67","v":-1.26},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.26},null,{"$f":"SUM(J66:J67)","v":6.0000000000000053E-2},null,{"$f":"IF(ISERROR(J68/F68),0,J68/F68)","v":-4.5454545454545491E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F61,F68)","v":1422.3458520000001},null,{"$f":"SUM(H61,H68)","v":1434.4881685866919},null,{"$f":"SUM(J61,J68)","v":12.142316586691832},null,{"$f":"IF(ISERROR(J70/F70),0,J70/F70)","v":8.5368242678939034E-3}]
[]
[]
[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.401400000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!F18","v":15.574907691239225}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,null,{"$f":"'B1.1 Current Distribution Rates'!G18","v":10.5303},null,{"$f":"'E1.1 Proposed Dist Rates '!G18","v":10.61243634}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!E18","v":-0.11}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!E18,2)","v":-0.21}]
[]
[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":480.83170799999999},null,{"$f":"H76*E90/100","v":486.24861812048863},null,{"$f":"H90-F90","v":5.4169101204886374},null,{"$f":"IF(ISERROR(J90/F90),0,J90/F90)","v":1.1265709041984888E-2}]
[null,null,"Block 2 (Over 1,000 m3 per month)",null,{"$f":"E86","v":11117},{"$f":"F77*E91/100","v":1170.6534510000001},null,{"$f":"H77*E91/100","v":1179.7845479178002},null,9.1310969178000505,null,{"$f":"IF(ISERROR(J91/F91),0,J91/F91)","v":7.8000000000000421E-3}]
[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":1818.653916},null,{"$f":"SUM(H89:H92)","v":1833.2019230382887},null,14.548007038288688,null,{"$f":"IF(ISERROR(J93/F93),0,J93/F93)","v":7.9993268154537039E-3}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",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 Savings 2012",null,6,0,null,{"$f":"H82*E99","v":-1.26},null,{"$f":"H99-F99","v":-1.26},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.26},null,{"$f":"SUM(J98:J99)","v":6.0000000000000053E-2},null,{"$f":"IF(ISERROR(J100/F100),0,J100/F100)","v":-4.5454545454545491E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F93,F100)","v":1817.333916},null,{"$f":"SUM(H93,H100)","v":1831.9419230382887},null,{"$f":"SUM(J93,J100)","v":14.608007038288688},null,{"$f":"IF(ISERROR(J102/F102),0,J102/F102)","v":8.0381524329008833E-3}]

{"sheet":"G1.2 Rate 2 Bill Impact","index":23,"n_rows":101,"n_cols":12,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[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":13.904999999999999},null,{"$f":"'E1.1 Proposed Dist Rates '!F19","v":14.319920518522972}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$19","v":-0.2}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$19,2)","v":-0.38}]
[]
[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":393.67836000000005},null,{"$f":"H12*E28/100","v":405.42558972042241},null,{"$f":"H28-F28","v":11.747229720422354},null,{"$f":"IF(ISERROR(J28/F28),0,J28/F28)","v":2.9839663324197834E-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":821.42586779999999},null,{"$f":"SUM(H27:H31)","v":833.1730975204224},null,11.747229720422411,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":1.4301022381830585E-2}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,7,{"$f":"F18*E37","v":-1.4000000000000001},null,0,null,{"$f":"H37-F37","v":1.4000000000000001},null,{"$f":"IF(ISERROR(J37/F37),0,J37/F37)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,6,0,null,{"$f":"H19*E38","v":-2.2800000000000002},null,{"$f":"H38-F38","v":-2.2800000000000002},null,{"$f":"IF(ISERROR(J38/F38),0,J38/F38)","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F37:F38)","v":-1.4000000000000001},null,{"$f":"SUM(H37:H38)","v":-2.2800000000000002},null,{"$f":"SUM(J37:J38)","v":-0.88000000000000012},null,0.62857142857142856]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F32,F39)","v":820.02586780000001},null,{"$f":"SUM(H32,H39)","v":830.89309752042243},null,{"$f":"SUM(J32,J39)","v":10.86722972042241},null,{"$f":"IF(ISERROR(J41/F41),0,J41/F41)","v":1.3252301112863027E-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":17.527000000000001},null,{"$f":"'E1.1 Proposed Dist Rates '!F20","v":18.049999779083219}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$20","v":-0.2}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$20,2)","v":-0.38}]
[]
[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":118.76295200000003},null,{"$f":"H47*E63/100","v":122.30679850306791},null,{"$f":"H63-F63","v":3.5438465030678827},null,2.9839663324197952E-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":194.00892080000006},null,{"$f":"SUM(H62:H66)","v":197.55276730306792},null,3.5438465030678685,null,1.8266410062252495E-2]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,5,{"$f":"F53*E72","v":-1},null,0,null,{"$f":"H72-F72","v":1},null,{"$f":"IF(ISERROR(J72/F72),0,J72/F72)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,0,0,null,{"$f":"H54*E73","v":0},null,{"$f":"H73-F73","v":0},null,{"$f":"IF(ISERROR(J73/F73),0,J73/F73)","v":0}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F72:F73)","v":-1},null,{"$f":"SUM(H72:H73)","v":0},null,{"$f":"SUM(J72:J73)","v":1},null,-1]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F67,F74)","v":193.00892080000006},null,{"$f":"SUM(H67,H74)","v":197.55276730306792},null,{"$f":"SUM(J67,J74)","v":4.5438465030678685},null,{"$f":"IF(ISERROR(J76/F76),0,J76/F76)","v":2.3542157969870723E-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":512.44131200000004},null,{"$f":"H28+H63","v":527.73238822349026},null,{"$f":"H88-F88","v":15.291076223490222},null,2.9839663324197838E-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":1015.4347886},null,{"$f":"SUM(H87:H91)","v":1030.7258648234902},null,15.291076223490109,null,1.5058649157147962E-2]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,{"$f":"E37+E72","v":12},{"$f":"F37+F72","v":-2.4000000000000004},null,{"$f":"H37+H72","v":0},null,{"$f":"H97-F97","v":2.4000000000000004},null,{"$f":"IF(ISERROR(J97/F97),1,J97/F97)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,{"$f":"E38+E73","v":6},{"$f":"F38+F73","v":0},null,{"$f":"H38+H73","v":-2.2800000000000002},null,{"$f":"H98-F98","v":-2.2800000000000002},null,{"$f":"IF(ISERROR(J98/F98),1,J98/F98)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F97:F98)","v":-2.4000000000000004},null,{"$f":"SUM(H97:H98)","v":-2.2800000000000002},null,{"$f":"SUM(J97:J98)","v":0.12000000000000011},null,{"$f":"IF(ISERROR(J99/F99),0,J99/F99)","v":-5.0000000000000037E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F92,F99)","v":1013.0347886000001},null,{"$f":"SUM(H92,H99)","v":1028.4458648234902},null,{"$f":"SUM(J92,J99)","v":15.41107622349011},null,{"$f":"IF(ISERROR(J101/F101),0,J101/F101)","v":1.5212780841206848E-2}]

{"sheet":"G1.3 Rate 3 Bill Impact","index":24,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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.7644000000000002},null,{"$f":"'E1.1 Proposed Dist Rates '!J21","v":3.8231664190024763}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$21","v":-8.84}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$21,2)","v":-16.68}]
[]
[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":20659.959641880003},null,{"$f":"H18*E32/100","v":20982.484305807575},null,{"$f":"H32-F32","v":322.52466392757196},null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":1.5611098449281532E-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":41349.315975390004},null,{"$f":"SUM(H31:H34)","v":41671.840639317576},null,322.52466392757196,null,{"$f":"IF(ISERROR(J35/F35),0,J35/F35)","v":7.799999983543378E-3}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,12,{"$f":"F23*E40","v":-106.08},null,0,null,{"$f":"H40-F40","v":106.08},null,{"$f":"IF(ISERROR(J40/F40),1,J40/F40)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,6,0,null,{"$f":"H24*E41","v":-100.08},null,{"$f":"H41-F41","v":-100.08},null,{"$f":"IF(ISERROR(J41/F41),1,J41/F41)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F40:F41)","v":-106.08},null,{"$f":"SUM(H40:H41)","v":-100.08},null,{"$f":"SUM(J40:J41)","v":6},null,{"$f":"IF(ISERROR(J42/F42),0,J42/F42)","v":-5.6561085972850679E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F35,F42)","v":41243.235975390002},null,{"$f":"SUM(H35,H42)","v":41571.760639317574},null,{"$f":"SUM(J35,J42)","v":328.52466392757196},null,{"$f":"IF(ISERROR(J44/F44),0,J44/F44)","v":7.9655404373120461E-3}]

{"sheet":"G1.4 Rate 4 Bill Impact","index":25,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[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":14.7971},null,{"$f":"'E1.1 Proposed Dist Rates '!F22","v":15.01746518543624}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$22","v":-0.57999999999999996}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$22,2)","v":-1.1000000000000001}]
[]
[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":825.63822783000012},null,{"$f":"H14*E28/100","v":837.93401019134171},null,{"$f":"H28-F28","v":12.295782361341594},null,{"$f":"IF(ISERROR(J28/F28),0,J28/F28)","v":1.4892457673209035E-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":2379.2439468200005},null,{"$f":"SUM(H27:H30)","v":2391.5397291813424},null,12.295782361341935,null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":5.1679368052090545E-3}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,9,{"$f":"F19*E36","v":-5.22},null,0,null,{"$f":"H36-F36","v":5.22},null,{"$f":"IF(ISERROR(J36/F36),1,J36/F36)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,6,0,null,{"$f":"H20*E37","v":-6.6000000000000005},null,{"$f":"H37-F37","v":-6.6000000000000005},null,{"$f":"IF(ISERROR(J37/F37),1,J37/F37)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F36:F37)","v":-5.22},null,{"$f":"SUM(H36:H37)","v":-6.6000000000000005},null,{"$f":"SUM(J36:J37)","v":-1.3800000000000008},null,{"$f":"IF(ISERROR(J38/F38),0,J38/F38)","v":0.2643678160919542}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F31,F38)","v":2374.0239468200007},null,{"$f":"SUM(H31,H38)","v":2384.9397291813425},null,{"$f":"SUM(J31,J38)","v":10.915782361341934},null,{"$f":"IF(ISERROR(J40/F40),0,J40/F40)","v":4.5980085314487234E-3}]
[]
[]
[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":18.877199999999998},null,{"$f":"'E1.1 Proposed Dist Rates '!F23","v":19.158327901988699}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$23","v":-0.57999999999999996}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$23,2)","v":-1.1000000000000001}]
[]
[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":142.30388447999997},null,{"$f":"H46*E60/100","v":144.4231390563516},null,{"$f":"H60-F60","v":2.1192545763516364},null,1.4892457673209097E-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":187.57752839999998},null,{"$f":"SUM(H59:H62)","v":189.69678297635161},null,2.1192545763516364,null,1.1298019514536031E-2]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,3,{"$f":"F51*E68","v":-1.7399999999999998},null,0,null,{"$f":"H68-F68","v":1.7399999999999998},null,{"$f":"IF(ISERROR(J68/F68),1,J68/F68)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,0,0,null,{"$f":"H52*E69","v":0},null,{"$f":"H69-F69","v":0},null,{"$f":"IF(ISERROR(J69/F69),1,J69/F69)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F68:F69)","v":-1.7399999999999998},null,{"$f":"SUM(H68:H69)","v":0},null,{"$f":"SUM(J68:J69)","v":1.7399999999999998},null,{"$f":"IF(ISERROR(J70/F70),0,J70/F70)","v":-1}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F63,F70)","v":185.83752839999997},null,{"$f":"SUM(H63,H70)","v":189.69678297635161},null,{"$f":"SUM(J63,J70)","v":3.8592545763516362},null,{"$f":"IF(ISERROR(J72/F72),0,J72/F72)","v":2.0766820402630993E-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":967.94211231000008},null,{"$f":"H28+H60","v":982.35714924769331},null,{"$f":"H83-F83","v":14.41503693769323},null,1.4892457673209044E-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":2566.8214752200001},null,{"$f":"SUM(H82:H85)","v":2581.2365121576936},null,14.415036937693458,null,5.6159094338487084E-3]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,{"$f":"E68+E36","v":12},{"$f":"F68+F36","v":-6.9599999999999991},null,{"$f":"H68+H36","v":0},null,{"$f":"H91-F91","v":6.9599999999999991},null,{"$f":"IF(ISERROR(J91/F91),1,J91/F91)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,{"$f":"E69+E37","v":6},{"$f":"F69+F37","v":0},null,{"$f":"H69+H37","v":-6.6000000000000005},null,{"$f":"H92-F92","v":-6.6000000000000005},null,{"$f":"IF(ISERROR(J92/F92),1,J92/F92)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F91:F92)","v":-6.9599999999999991},null,{"$f":"SUM(H91:H92)","v":-6.6000000000000005},null,{"$f":"SUM(J91:J92)","v":0.35999999999999854},null,{"$f":"IF(ISERROR(J93/F93),0,J93/F93)","v":-5.1724137931034281E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F86,F93)","v":2559.8614752200001},null,{"$f":"SUM(H86,H93)","v":2574.6365121576937},null,{"$f":"SUM(J86,J93)","v":14.775036937693457},null,{"$f":"IF(ISERROR(J95/F95),0,J95/F95)","v":5.7718111236560793E-3}]

{"sheet":"G1.5 Rate 5 Bill Impact","index":26,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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":6.915},null,{"$f":"'E1.1 Proposed Dist Rates '!J24","v":6.9766317571807068}]
[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 Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$24","v":-3.2}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$24,2)","v":-6.04}]
[]
[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":13099.246310999999},null,{"$f":"H18*E30/100","v":13215.99679081053},null,{"$f":"H30-F30","v":116.75047981053103},null,{"$f":"IF(ISERROR(J30/F30),0,J30/F30)","v":8.9127631497768426E-3}]
[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":14968.010250419999},null,{"$f":"SUM(H29:H31)","v":15084.76073023053},null,116.75047981053103,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":7.7999999904633313E-3}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,12,{"$f":"F22*E37","v":-38.400000000000006},null,0,null,{"$f":"H37-F37","v":38.400000000000006},null,{"$f":"IF(ISERROR(J37/F37),1,J37/F37)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,6,0,null,{"$f":"H23*E38","v":-36.24},null,{"$f":"H38-F38","v":-36.24},null,{"$f":"IF(ISERROR(J38/F38),1,J38/F38)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F37:F38)","v":-38.400000000000006},null,{"$f":"SUM(H37:H38)","v":-36.24},null,{"$f":"SUM(J37:J38)","v":2.1600000000000037},null,{"$f":"IF(ISERROR(J39/F39),0,J39/F39)","v":-5.6250000000000085E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F32,F39)","v":14929.610250419999},null,{"$f":"SUM(H32,H39)","v":15048.52073023053},null,{"$f":"SUM(J32,J39)","v":118.91047981053103},null,{"$f":"IF(ISERROR(J41/F41),0,J41/F41)","v":7.9647410626265906E-3}]

{"sheet":"G1.6 Rate 6 Bill Impact","index":27,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'A1.1 Distributor Information'!C1","v":"GD Rate Generator   release 1.0    © Elenchus Research Associates"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C2","v":"Name of LDC:       Natural Resource Gas Limited"}]
[null,null,{"$f":"'A1.1 Distributor Information'!C3","v":"OEB Application Number:          EB-2012-0342"}]
[]
[]
[]
[]
[]
[]
[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.7538999999999998},null,{"$f":"'E1.1 Proposed Dist Rates '!J25","v":3.7832224347748364}]
[null,null,"Demand - Firm",null,null,{"$f":"'B1.1 Current Distribution Rates'!K25","v":18.183700000000002},null,{"$f":"'E1.1 Proposed Dist Rates '!K25","v":18.325532860000003}]
[]
[null,null,"Rate Riders"]
[null,null,"Shared Tax Savings 2011",null,null,{"$f":"'C1.1 Current Rate Riders'!$E$25","v":-319.14}]
[null,null,"Shared Tax Savings 2012",null,null,null,null,{"$f":"ROUND('F1.3 Proposed Rate Riders'!$E$25,2)","v":-602.05999999999995}]
[]
[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":1254433.8558240002},null,{"$f":"H18*E31/100","v":1264232.4798994274},null,{"$f":"H31-F31","v":9798.6240754271857},null,{"$f":"IF(ISERROR(J31/F31),0,J31/F31)","v":7.8111922999644819E-3}]
[null,null,"Demand - Firm",null,{"$f":"E27","v":1297416},{"$f":"F19*E32/100","v":235918.23319200001},null,{"$f":"H19*E32/100","v":237758.39541089762},null,1840.1622188976035,null,{"$f":"IF(ISERROR(J32/F32),0,J32/F32)","v":7.8000000000000144E-3}]
[null,null,"Total Delivery",null,null,{"$f":"SUM(F30:F32)","v":1492152.0890160003},null,{"$f":"SUM(H30:H32)","v":1503790.8753103251},null,11638.786294324789,null,{"$f":"IF(ISERROR(J33/F33),0,J33/F33)","v":7.799999999999991E-3}]
[]
[null,null,"Rate Riders"]
[]
[null,null,"Rate Riders",null,"Metric","Current Rate",null,"Proposed Rate",null,"Change $",null,"Change %"]
[null,null,"Shared Tax Savings 2011",null,12,{"$f":"F22*E38","v":-3829.68},null,0,null,{"$f":"H38-F38","v":3829.68},null,{"$f":"IF(ISERROR(J38/F38),1,J38/F38)","v":-1}]
[null,null,"Shared Tax Savings 2012",null,6,0,null,{"$f":"H23*E39","v":-3612.3599999999997},null,{"$f":"H39-F39","v":-3612.3599999999997},null,{"$f":"IF(ISERROR(J39/F39),1,J39/F39)","v":1}]
[null,null,"Total Rate Riders",null,null,{"$f":"SUM(F38:F39)","v":-3829.68},null,{"$f":"SUM(H38:H39)","v":-3612.3599999999997},null,{"$f":"SUM(J38:J39)","v":217.32000000000016},null,{"$f":"IF(ISERROR(J40/F40),0,J40/F40)","v":-5.6746255561822445E-2}]
[]
[null,null,"Total Bill Impact",null,null,{"$f":"SUM(F33,F40)","v":1488322.4090160003},null,{"$f":"SUM(H33,H40)","v":1500178.515310325},null,{"$f":"SUM(J33,J40)","v":11856.106294324789},null,{"$f":"IF(ISERROR(J42/F42),0,J42/F42)","v":7.9660873359848269E-3}]