{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Index","Input|2013-14 tariffs","Input|2014-2015 tariffs","Input|2015-16 tariffs","Input|2016-17 tariffs","Input|2017-18 tariffs","Input|2018-19 tariffs","Input|2019-20 tariffs","Input|Escalators","Input|2014-15 calcs","Calc|Customer outcomes"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":8,"defined_names":135,"comments":2,"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":"Index","index":0,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4],[6,2,13,12]]}
[null,null,"JGN Reference tariffs and customer outcomes"]
[null,null,"Index"]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,null,"JGN has completed Template 21 using the fixed percentages as required.\nHowever, this appendix calculates the customer impacts for each customer ‘archetype’ using our proposed network tariffs for the 2015-20 period.\nJGN considers these calculations better reflect the customer impacts for each customer ‘archetype’ given:\n1.            It uses movements in proposed tariff components (rather using than broad movements in revenues to calculate changes in network bills). This captures the effect of our proposed tariff strategies.\n2.            It does not rely on a fixed network percentage of a customer bill\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model Index"]
[]
[null,null,"Description of model","This model estimates the customer outcomes from JGN reference tariffs"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Input|2013-14 tariffs","Inputs the JGN tariffs by tariff basket for the year 2013-14"]
[null,null,"Input|2014-15 tariffs","Inputs the JGN tariffs by tariff basket for the year 2014-15"]
[null,null,"Input|2015-16 tariffs","Inputs the JGN tariffs by tariff basket for the year 2015-16"]
[null,null,"Input|2016-17 tariffs","Inputs the JGN tariffs by tariff basket for the year 2016-17"]
[null,null,"Input|2017-18 tariffs","Inputs the JGN tariffs by tariff basket for the year 2017-18"]
[null,null,"Input|2018-19 tariffs","Inputs the JGN tariffs by tariff basket for the year 2018-19"]
[null,null,"Input|2019-20 tariffs","Inputs the JGN tariffs by tariff basket for the year 2019-20"]
[null,null,"Input|Escalators","Inputs the historical and forecast CPI assumptions based on RBA's data"]
[null,null,"Input|2014-15 calcs","Inputs the calculations of revenues for the year 2014-15"]
[null,null,"Calc|Customer outcomes","Calculates the customer outcomes on tariffs"]
[]
[null,null,"Version Control","Developer","Comments","Date"]
[null,null,"Version 1","Jemena Gas Networks","Submission model","2014-06-30"]
[]
[]
[null,"End"]

{"sheet":"Input|2013-14 tariffs","index":1,"n_rows":81,"n_cols":51,"rows_kept":81,"cut":false,"hidden":false,"merged":[[9,46,9,50],[9,27,9,31],[9,5,9,9],[9,10,9,14],[9,15,9,19],[9,20,9,22],[9,23,9,26],[66,2,67,2],[9,32,9,36],[9,37,10,37],[9,38,9,39],[9,40,9,45]]}
[null,null,{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$21","v":"Input|2013-14 tariffs"}]
[]
[null,null,null,"Source","Unit","Basis"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Haulague and Reference Tariffs"]
[]
[null,null,"Tariff Type",null,null,"Demand Capacity",null,null,null,null,"Demand Capacity Distance",null,null,null,null,"Pressure Reduction",null,null,null,null,"Demand Throughput - DT",null,null,"Demand Throughput - DMT",null,null,null,"Metering - Single Meter",null,null,null,null,"Metering Double Meter",null,null,null,null,"Fixed charge","Basic Metering Volume",null,"Volume Market",null,null,null,null,null,"Ancillary Services"]
[null,null,"Tariff Block",null,null,"Block 1","Block 2","Block 3","Block 4","Block 5","Block 1","Block 2","Block 3","Block 4","Block 5","Block 1","Block 2","Block 3","Block 4","Block 5","Block 1","Block 2","Block 3","Fixed","Block 1","Block 2","Block 3","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater",null,"Fixed","Variable","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Requests For Service","Temporary Disconnections","Permanent Disconnection","Decommission small meter","Decommission large meter"]
[null,null,"Unit",null,null,"$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/Hr","$/Disconnection/Meter set","$/Disconnection/Meter set","$/Decommission/Meter","$/Decommission/Meter"]
[]
[null,null,"Volume Throughput"]
[null,null,"Volume Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.62,12.4,0.44900000000000001,21.43,8.3019999999999996,7.9779999999999998,7.8049999999999997,6.7889999999999997,4.1059999999999999,89.19,131.87,394.07,917.73,1965.09]
[null,null,"Volume Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.62,12.4,0.44900000000000001,21.021999999999998,8.0259999999999998,7.7039999999999997,7.5279999999999996,6.5129999999999999,3.8849999999999998,89.19,131.87,394.07,917.73,1965.09]
[]
[null,null,"Demand Capacity"]
[null,null,"DC1","JGN",null,249.34200000000001,130.976,99.956000000000003,88.16,84.876000000000005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC2","JGN",null,276.98599999999999,144.38,108.892,92.293999999999997,20.103999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC3","JGN",null,375.11200000000002,195.78200000000001,142.00200000000001,118.97799999999999,104.126,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC4","JGN",null,618.91600000000005,310.11599999999999,219.37799999999999,175.16,159.178,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC5","JGN",null,3142.6179999999999,1897.45,1279.7919999999999,972.31200000000001,670.37199999999996,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC6","JGN",null,126.31,71.346000000000004,61.405999999999999,59.628,59.32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC7","JGN",null,414.37400000000002,210.97200000000001,153.28800000000001,129.982,110.986,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC8","JGN",null,810.34199999999998,435.13600000000002,303.04399999999998,238.17400000000001,183.494,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC9","JGN",null,55.088000000000001,44.93,44.781999999999996,46.05,52.87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC10","JGN",null,197.09800000000001,105.654,83.073999999999998,72.932000000000002,79.213999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC11","JGN",null,2474.2660000000001,1496.434,1012.45,771.80200000000002,536.702,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC country","JGN",null,null,null,null,null,null,53.637,26,17.332999999999998,13.788,10.167999999999999,19.036000000000001,9.2260000000000009,6.1520000000000001,4.8920000000000003,3.6070000000000002,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[]
[null,null,"Demand Throughput"]
[null,null,"DT","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.63,3.74,3.33,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT1","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,212474.3,0,0.214,0.19400000000000001,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT2","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,242884.4,0,0.214,0.19600000000000001,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT3","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,285981.26,0,0.36399999999999999,0.30199999999999999,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT4","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,521616.48,0,0.78400000000000003,0.73199999999999998,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT5","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,978030.82,0,0.96199999999999997,1.044,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[]
[null,null,"Demand Capacity - First Response"]
[null,null,"DC1FR","JGN",null,124.67100000000001,65.488,49.978000000000002,44.08,42.438000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC2FR","JGN",null,138.49299999999999,72.19,54.445999999999998,46.146999999999998,10.052,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC3FR","JGN",null,187.55600000000001,97.891000000000005,71.001000000000005,59.488999999999997,52.063000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC4FR","JGN",null,309.45800000000003,155.05799999999999,109.68899999999999,87.58,79.588999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC5FR","JGN",null,1571.309,948.72500000000002,639.89599999999996,486.15600000000001,335.18599999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC6FR","JGN",null,63.155000000000001,35.673000000000002,30.702999999999999,29.814,29.66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC7FR","JGN",null,207.18700000000001,105.486,76.644000000000005,64.991,55.493000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC8FR","JGN",null,405.17099999999999,217.56800000000001,151.52199999999999,119.087,91.747,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC9FR","JGN",null,27.544,22.465,22.390999999999998,23.024999999999999,26.434999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC10FR","JGN",null,98.549000000000007,52.826999999999998,41.536999999999999,36.466000000000001,39.606999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DC11FR","JGN",null,1237.133,748.21699999999998,506.22500000000002,385.90100000000001,268.351,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[]
[null,null,"Demand Throughput - First Response"]
[null,null,"DMT1FR","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106237.15,0,0.107,9.7000000000000003E-2,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT2FR","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121442.2,0,0.107,9.8000000000000004E-2,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT3FR","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142990.63,0,0.182,0.151,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT4FR","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,260808.24,0,0.39200000000000002,0.36599999999999999,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[null,null,"DMT5FR","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,489015.41,0,0.48099999999999998,0.52200000000000002,4868,6571,12773,17253,22717,9736,13142,25546,34506,45434,null,null,null,null,null,null,null,null,null,89.19,131.87,394.07,917.73,1965.09]
[]
[]
[]
[null,"Input | Meter data service"]
[]
[null,null,"(a) Meter Reading Charges"]
[]
[null,null,null,"Meter Reading Cycle","Period ending 30 June 2014","Period ending 30 June 2015"]
[null,null,"All Volume Tariff Classes","Quarterly ",4.4690000000000003,4.5049999999999999]
[null,null,null,"Monthly ",47.241999999999997,47.622999999999998]
[null,null,"All Demand Tariff Classes","Daily Meter Reading ",829,837]
[]
[null,null,"(b) Provision of On Site Data and Communications Equipment Charge"]
[]
[null,null,null,"Period ending 30 June 2014","Period ending 30 June 2015"]
[null,null,"All Demand Tariff Classes",1548,1560]
[]
[null,null,"(c) Ancillary Reference Service: fees fro Meter Data Service"]
[]
[null,null,null,"Period ending 30 June 2014","Period ending 30 June 2015"]
[null,null,"Special Meter Read",38.619999999999997,38.93]
[]
[null,"End"]

{"sheet":"Input|2014-2015 tariffs","index":2,"n_rows":27,"n_cols":72,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,21,8,23],[8,24,8,27],[8,3,8,8],[8,9,8,14],[8,15,8,20],[8,59,8,65],[8,66,8,71],[8,54,8,58],[8,28,8,32],[8,33,8,37],[8,44,8,48],[8,49,8,53],[8,38,8,43]]}
[{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[{"$f":"Index!$C$22","v":"Input|2014-15 tariffs"}]
[]
[]
["Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
["Haulague and Reference Tariffs"]
[]
["Tariff Type",null,null,"Demand Capacity",null,null,null,null,null,"Demand Capacity Distance",null,null,null,null,null,"Pressure Reduction",null,null,null,null,null,"Demand Throughput - DT",null,null,"Demand Throughput - DMT",null,null,null,"Metering - Single Meter",null,null,null,null,"Metering Double Meter",null,null,null,null,"Volume Residential Distributed Generated Technology - VRT",null,null,null,null,null,"VRT Metering - Single Meter",null,null,null,null,"VRT Metering Double Meter",null,null,null,null,"Volume Boundary Meter - VB",null,null,null,null,"Volume Individual Meter- VI",null,null,null,null,null,null," Ancillary Charges      "]
["Tariff Block",null,null,"Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Fixed","Block 1","Block 2","Block 3","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Fixed charge","Band 1","Band 2","Band 3","Band 4","Fixed charge","Band 1","Band 2","Band 3","Band 4","Band 5","Band 6","Requests For Service","Disconnections Small Meters","Temporary Disconnections Large Meters","Decommission small meter","Decommission large meter","Special Meter Reads"]
["Unit",null,null,"$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/Hr","$/Disconnection/Meter set","$/Disconnection/Meter set","$/Decommission/Meter","$/Decommission/Meter","$/Meter read"]
[]
["Volume Individual Meter"]
["VI Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49.498999999999995,24.030999999999999,24.030999999999999,9.31,8.8490000000000002,7.8930625191630845,4.2596821897953161,99,146.86000000000001,146.86000000000001,1022.08,2188,40]
["VI Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49.498999999999995,23.573,23.573,9,8.5399999999999991,7.5736900472894337,4.0336328428198112,99,146.86000000000001,146.86000000000001,1022.08,2188,40]
[]
["Volume Boundary Meter"]
["VB Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,146.86000000000001,146.86000000000001,1022.08,2188,40]
["VB Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,146.86000000000001,146.86000000000001,1022.08,2188,40]
[]
["Volume Residential Distributed Generated Technology"]
["VRT3","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,146.86000000000001,146.86000000000001,1022.08,2188,40]
["VRT4","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,146.86000000000001,146.86000000000001,1022.08,2188,40]
["VRT6","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,146.86000000000001,146.86000000000001,1022.08,2188,40]
["VRT10","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,146.86000000000001,146.86000000000001,1022.08,2188,40]
[]
["End"]

{"sheet":"Input|2015-16 tariffs","index":3,"n_rows":27,"n_cols":72,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,3,8,8],[8,9,8,14],[8,15,8,20],[8,21,8,23],[8,24,8,27],[8,54,8,58],[8,59,8,65],[8,66,8,71],[8,28,8,32],[8,33,8,37],[8,38,8,43],[8,44,8,48],[8,49,8,53]]}
[{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[{"$f":"Index!$C$23","v":"Input|2015-16 tariffs"}]
[]
[]
["Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
["Haulague and Reference Tariffs"]
[]
["Tariff Type",null,null,"Demand Capacity",null,null,null,null,null,"Demand Capacity Distance",null,null,null,null,null,"Pressure Reduction",null,null,null,null,null,"Demand Throughput - DT",null,null,"Demand Throughput - DMT",null,null,null,"Metering - Single Meter",null,null,null,null,"Metering Double Meter",null,null,null,null,"Volume Residential Distributed Generated Technology - VRT",null,null,null,null,null,"VRT Metering - Single Meter",null,null,null,null,"VRT Metering Double Meter",null,null,null,null,"Volume Boundary Meter - VB",null,null,null,null,"Volume Individual Meter- VI",null,null,null,null,null,null," Ancillary Charges      "]
["Tariff Block",null,null,"Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Fixed","Block 1","Block 2","Block 3","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Fixed charge","Block 1","Block 2","Block 3","Block 4","Fixed charge","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Requests For Service","Disconnections Small Meters","Temporary Disconnections Large Meters","Decommission small meter","Decommission large meter","Special Meter Reads"]
["Unit",null,null,"$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/Hr","$/Disconnection/Meter set","$/Disconnection/Meter set","$/Decommission/Meter","$/Decommission/Meter","$/Meter read"]
[]
["Volume Individual Meter"]
["VI Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.676111756342785,24.587514263614608,21.150507581674187,9.58,9.5690000000000008,8.4930625191630842,4.9911349716533895,100,150,150,1050,2188,14.8]
["VI Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.676111756342785,24.09751426361461,20.660507581674189,9.27,9.26,8.1736900472894334,4.7611349716533891,100,150,150,1050,2188,14.8]
[]
["Volume Boundary Meter"]
["VB Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1550.2833526902834,22.128762837253149,19.03545682350677,8.6219999999999999,8.6121000000000016,null,null,null,null,null,null,null,100,150,150,1050,2188,14.8]
["VB Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1550.2833526902834,21.68776283725315,18.594456823506771,8.343,8.3339999999999996,null,null,null,null,null,null,null,100,150,150,1050,2188,14.8]
[]
["Volume Residential Distributed Generated Technology"]
["VRT3","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450.55560000000003,428.02782000000002,256.23572517860327,185.85085683613269,156.49443274185134,115.00230000000001,8288.7000000000007,10283.700000000001,17548.650000000001,22796.55,29198.400000000001,13991.25,17981.25,32511.15,43006.950000000004,55810.65,null,null,null,null,null,null,null,null,null,null,null,null,100,150,150,1050,2188,14.8]
["VRT4","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,743.3954,706.22562999999991,405.87640621602208,287.11810847814149,238.4180611021543,174.12780000000001,8288.7000000000007,10283.700000000001,17548.650000000001,22796.55,29198.400000000001,13991.25,17981.25,32511.15,43006.950000000004,55810.65,null,null,null,null,null,null,null,null,null,null,null,null,100,150,150,1050,2188,14.8]
["VRT6","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155.01420000000002,147.26349000000002,93.376161231262927,80.366313828910734,80.340184390464557,64.329300000000003,8288.7000000000007,10283.700000000001,17548.650000000001,22796.55,29198.400000000001,13991.25,17981.25,32511.15,43006.950000000004,55810.65,null,null,null,null,null,null,null,null,null,null,null,null,100,150,150,1050,2188,14.8]
["VRT10","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,241.88560000000001,229.79132000000001,138.2796012010204,108.72459337454809,95.450838643889497,85.820700000000002,8288.7000000000007,10283.700000000001,17548.650000000001,22796.55,29198.400000000001,13991.25,17981.25,32511.15,43006.950000000004,55810.65,null,null,null,null,null,null,null,null,null,null,null,null,100,150,150,1050,2188,14.8]
[]
["End"]

{"sheet":"Input|2016-17 tariffs","index":4,"n_rows":27,"n_cols":72,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,3,8,8],[8,9,8,14],[8,15,8,20],[8,21,8,23],[8,24,8,27],[8,54,8,58],[8,59,8,65],[8,66,8,71],[8,28,8,32],[8,33,8,37],[8,38,8,43],[8,44,8,48],[8,49,8,53]]}
[{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[{"$f":"Index!$C$24","v":"Input|2016-17 tariffs"}]
[]
[]
["Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
["Haulague and Reference Tariffs"]
[]
["Tariff Type",null,null,"Demand Capacity",null,null,null,null,null,"Demand Capacity Distance",null,null,null,null,null,"Pressure Reduction",null,null,null,null,null,"Demand Throughput - DT",null,null,"Demand Throughput - DMT",null,null,null,"Metering - Single Meter",null,null,null,null,"Metering Double Meter",null,null,null,null,"Volume Residential Distributed Generated Technology - VRT",null,null,null,null,null,"VRT Metering - Single Meter",null,null,null,null,"VRT Metering Double Meter",null,null,null,null,"Volume Boundary Meter - VB",null,null,null,null,"Volume Individual Meter- VI",null,null,null,null,null,null," Ancillary Charges      "]
["Tariff Block",null,null,"Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Fixed","Block 1","Block 2","Block 3","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Fixed charge","Block 1","Block 2","Block 3","Block 4","Fixed charge","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Requests For Service","Disconnections Small Meters","Temporary Disconnections Large Meters","Decommission small meter","Decommission large meter","Special Meter Reads"]
["Unit",null,null,"$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/Hr","$/Disconnection/Meter set","$/Disconnection/Meter set","$/Decommission/Meter","$/Decommission/Meter","$/Meter read"]
[]
["Volume Individual Meter"]
["VI Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.562212761151727,24.533321076981757,20.58310683582301,9.5588847818296543,9.5479090268609585,8.4743430131060364,4.9801340422333373,102.54599844036755,153.81899766055133,153.81899766055133,1076.7329836238594,2243.706445875242,15.176807769174399]
["VI Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.562212761151727,24.044401082921581,20.106251974983078,9.2495680508936218,9.2395900918311682,8.1556744681030775,4.7506409837969255,102.54599844036755,153.81899766055133,153.81899766055133,1076.7329836238594,2243.706445875242,15.176807769174399]
[]
["Volume Boundary Meter"]
["VB Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1546.8663828345518,22.079988969283583,18.524796152240711,8.6029963036466892,8.5931181241748629,null,null,null,null,null,null,null,102.54599844036755,153.81899766055133,153.81899766055133,1076.7329836238594,2243.706445875242,15.176807769174399]
["VB Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1546.8663828345518,21.639960974629425,18.095626777484771,8.3246112458042596,8.3156310826480517,null,null,null,null,null,null,null,102.54599844036755,153.81899766055133,153.81899766055133,1076.7329836238594,2243.706445875242,15.176807769174399]
[]
["Volume Residential Distributed Generated Technology"]
["VRT3","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,495.6111600000001,441.86168438145654,264.51726695269861,191.85755880388925,161.55233472355837,120.75241500000001,8703.135000000002,10797.885000000002,18426.082500000004,23936.377499999999,30658.320000000003,14690.8125,18880.3125,34136.707500000004,45157.297500000008,58601.182500000003,null,null,null,null,null,null,null,null,null,null,null,null,102.54599844036755,153.81899766055133,153.81899766055133,1076.7329836238594,2243.706445875242,15.176807769174399]
["VRT4","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,817.73494000000005,729.05085100579504,418.99433663284736,296.39776925847798,246.12373575521079,182.83419000000001,8703.135000000002,10797.885000000002,18426.082500000004,23936.377499999999,30658.320000000003,14690.8125,18880.3125,34136.707500000004,45157.297500000008,58601.182500000003,null,null,null,null,null,null,null,null,null,null,null,null,102.54599844036755,153.81899766055133,153.81899766055133,1076.7329836238594,2243.706445875242,15.176807769174399]
["VRT6","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170.51562000000004,152.02304779930375,96.394079905180689,82.96375407554406,82.936780133327488,67.545765000000003,8703.135000000002,10797.885000000002,18426.082500000004,23936.377499999999,30658.320000000003,14690.8125,18880.3125,34136.707500000004,45157.297500000008,58601.182500000003,null,null,null,null,null,null,null,null,null,null,null,null,102.54599844036755,153.81899766055133,153.81899766055133,1076.7329836238594,2243.706445875242,15.176807769174399]
["VRT10","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,266.07416000000001,237.21817827504364,142.74879960437841,112.2385735632015,98.535810917177386,90.11173500000001,8703.135000000002,10797.885000000002,18426.082500000004,23936.377499999999,30658.320000000003,14690.8125,18880.3125,34136.707500000004,45157.297500000008,58601.182500000003,null,null,null,null,null,null,null,null,null,null,null,null,102.54599844036755,153.81899766055133,153.81899766055133,1076.7329836238594,2243.706445875242,15.176807769174399]
[]
["End"]

{"sheet":"Input|2017-18 tariffs","index":5,"n_rows":27,"n_cols":72,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,3,8,8],[8,9,8,14],[8,15,8,20],[8,21,8,23],[8,24,8,27],[8,54,8,58],[8,59,8,65],[8,66,8,71],[8,28,8,32],[8,33,8,37],[8,38,8,43],[8,44,8,48],[8,49,8,53]]}
[{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[{"$f":"Index!$C$25","v":"Input|2017-18 tariffs"}]
[]
[]
["Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
["Haulague and Reference Tariffs"]
[]
["Tariff Type",null,null,"Demand Capacity",null,null,null,null,null,"Demand Capacity Distance",null,null,null,null,null,"Pressure Reduction",null,null,null,null,null,"Demand Throughput - DT",null,null,"Demand Throughput - DMT",null,null,null,"Metering - Single Meter",null,null,null,null,"Metering Double Meter",null,null,null,null,"Volume Residential Distributed Generated Technology - VRT",null,null,null,null,null,"VRT Metering - Single Meter",null,null,null,null,"VRT Metering Double Meter",null,null,null,null,"Volume Boundary Meter - VB",null,null,null,null,"Volume Individual Meter- VI",null,null,null,null,null,null," Ancillary Charges      "]
["Tariff Block",null,null,"Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Fixed","Block 1","Block 2","Block 3","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Fixed charge","Block 1","Block 2","Block 3","Block 4","Fixed charge","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Requests For Service","Disconnections Small Meters","Temporary Disconnections Large Meters","Decommission small meter","Decommission large meter","Special Meter Reads"]
["Unit",null,null,"$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/Hr","$/Disconnection/Meter set","$/Disconnection/Meter set","$/Decommission/Meter","$/Decommission/Meter","$/Meter read"]
[]
["Volume Individual Meter"]
["VI Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.448564810024635,24.479247337213113,19.980332011621723,9.537816103579809,9.526864540204091,8.4556647665953815,4.9691573598931154,105.15681796131865,157.73522694197797,157.73522694197797,1104.146588593846,2300.8311769936522,15.563209058275161]
["VI Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.448564810024635,23.991404968658411,19.517441811569157,9.2291811357186671,9.2192251690134661,8.1376985969422932,4.7401701256735587,105.15681796131865,157.73522694197797,157.73522694197797,1104.146588593846,2300.8311769936522,15.563209058275161]
[]
["Volume Boundary Meter"]
["VB Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1543.456944300739,22.031322603491802,17.98229881045955,8.5840344932218287,8.5741780861836823,null,null,null,null,null,null,null,105.15681796131865,157.73522694197797,157.73522694197797,1104.146588593846,2300.8311769936522,15.563209058275161]
["VB Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1543.456944300739,21.592264471792571,17.565697630412242,8.3062630221468012,8.2973026521121191,null,null,null,null,null,null,null,105.15681796131865,157.73522694197797,157.73522694197797,1104.146588593846,2300.8311769936522,15.563209058275161]
[]
["Volume Residential Distributed Generated Technology"]
["VRT3","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,545.17227600000012,455.03510877644464,272.40344115729886,197.57749591282425,166.36876833285351,126.79003575000002,9138.2917500000021,11337.779250000003,19347.386625000006,25133.196375,32191.236000000004,15425.353125000001,19824.328125,35843.542875000006,47415.162375000007,61531.241625000002,null,null,null,null,null,null,null,null,null,null,null,null,105.15681796131865,157.73522694197797,157.73522694197797,1104.146588593846,2300.8311769936522,15.563209058275161]
["VRT4","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,899.50843400000008,750.78637731482752,431.48600633552286,305.23441145259699,253.46153520555697,191.97589950000003,9138.2917500000021,11337.779250000003,19347.386625000006,25133.196375,32191.236000000004,15425.353125000001,19824.328125,35843.542875000006,47415.162375000007,61531.241625000002,null,null,null,null,null,null,null,null,null,null,null,null,105.15681796131865,157.73522694197797,157.73522694197797,1104.146588593846,2300.8311769936522,15.563209058275161]
["VRT6","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187.56718200000006,156.55538042118118,99.267920676264822,85.437190402951558,85.409412274264469,70.923053250000009,9138.2917500000021,11337.779250000003,19347.386625000006,25133.196375,32191.236000000004,15425.353125000001,19824.328125,35843.542875000006,47415.162375000007,61531.241625000002,null,null,null,null,null,null,null,null,null,null,null,null,105.15681796131865,157.73522694197797,157.73522694197797,1104.146588593846,2300.8311769936522,15.563209058275161]
["VRT10","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,292.68157600000001,244.2904722690287,147.00463482506743,115.58479346707465,101.47350409402155,94.617321750000016,9138.2917500000021,11337.779250000003,19347.386625000006,25133.196375,32191.236000000004,15425.353125000001,19824.328125,35843.542875000006,47415.162375000007,61531.241625000002,null,null,null,null,null,null,null,null,null,null,null,null,105.15681796131865,157.73522694197797,157.73522694197797,1104.146588593846,2300.8311769936522,15.563209058275161]
[]
["End"]

{"sheet":"Input|2018-19 tariffs","index":6,"n_rows":27,"n_cols":72,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,3,8,8],[8,9,8,14],[8,15,8,20],[8,21,8,23],[8,24,8,27],[8,54,8,58],[8,59,8,65],[8,66,8,71],[8,28,8,32],[8,33,8,37],[8,38,8,43],[8,44,8,48],[8,49,8,53]]}
[{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[{"$f":"Index!$C$26","v":"Input|2018-19 tariffs"}]
[]
[]
["Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
["Haulague and Reference Tariffs"]
[]
["Tariff Type",null,null,"Demand Capacity",null,null,null,null,null,"Demand Capacity Distance",null,null,null,null,null,"Pressure Reduction",null,null,null,null,null,"Demand Throughput - DT",null,null,"Demand Throughput - DMT",null,null,null,"Metering - Single Meter",null,null,null,null,"Metering Double Meter",null,null,null,null,"Volume Residential Distributed Generated Technology - VRT",null,null,null,null,null,"VRT Metering - Single Meter",null,null,null,null,"VRT Metering Double Meter",null,null,null,null,"Volume Boundary Meter - VB",null,null,null,null,"Volume Individual Meter- VI",null,null,null,null,null,null," Ancillary Charges      "]
["Tariff Block",null,null,"Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Fixed","Block 1","Block 2","Block 3","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Fixed charge","Block 1","Block 2","Block 3","Block 4","Fixed charge","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Requests For Service","Disconnections Small Meters","Temporary Disconnections Large Meters","Decommission small meter","Decommission large meter","Special Meter Reads"]
["Unit",null,null,"$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/Hr","$/Disconnection/Meter set","$/Disconnection/Meter set","$/Decommission/Meter","$/Decommission/Meter","$/Meter read"]
[]
["Volume Individual Meter"]
["VI Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.335167349636862,24.425292781036589,19.364301215581811,9.5167938626721131,9.5058664375688373,8.4370276886912094,4.9582048711898876,107.83410890655398,161.75116335983097,161.75116335983097,1132.258143518817,2359.4103028754012,15.959448118169989]
["VI Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.335167349636862,23.938525662799712,18.915682781296283,9.2088391552161273,9.1989051323949624,8.1197623462868691,4.7297223463031877,107.83410890655398,161.75116335983097,161.75116335983097,1132.258143518817,2359.4103028754012,15.959448118169989]
[]
["Volume Boundary Meter"]
["VB Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1540.0550204891058,21.982763502932929,17.427871094023629,8.5651144764049025,8.5552797938119536,null,null,null,null,null,null,null,107.83410890655398,161.75116335983097,161.75116335983097,1132.258143518817,2359.4103028754012,15.959448118169989]
["VB Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1540.0550204891058,21.544673096519741,17.024114503166654,8.2879552396945151,8.2790146191554665,null,null,null,null,null,null,null,107.83410890655398,161.75116335983097,161.75116335983097,1132.258143518817,2359.4103028754012,15.959448118169989]
[]
["Volume Residential Distributed Generated Technology"]
["VRT3","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,599.68950360000019,468.40069381112681,280.40465092398665,203.38086970009789,171.25545922193069,133.12953753750003,9595.2063375000034,11904.668212500004,20314.755956250006,26389.856193750002,33800.797800000008,16196.620781250002,20815.544531250001,37635.720018750006,49785.920493750011,64607.803706250008,null,null,null,null,null,null,null,null,null,null,null,null,107.83410890655398,161.75116335983097,161.75116335983097,1132.258143518817,2359.4103028754012,15.959448118169989]
["VRT4","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,989.45927740000013,772.83895957790799,444.15989192747213,314.1999536780105,260.90637107969451,201.57469447500003,9595.2063375000034,11904.668212500004,20314.755956250006,26389.856193750002,33800.797800000008,16196.620781250002,20815.544531250001,37635.720018750006,49785.920493750011,64607.803706250008,null,null,null,null,null,null,null,null,null,null,null,null,107.83410890655398,161.75116335983097,161.75116335983097,1132.258143518817,2359.4103028754012,15.959448118169989]
["VRT6","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,206.32390020000008,161.15382614393602,102.1836821404347,87.946706726923821,87.918112681104375,74.469205912500016,9595.2063375000034,11904.668212500004,20314.755956250006,26389.856193750002,33800.797800000008,16196.620781250002,20815.544531250001,37635.720018750006,49785.920493750011,64607.803706250008,null,null,null,null,null,null,null,null,null,null,null,null,107.83410890655398,161.75116335983097,161.75116335983097,1132.258143518817,2359.4103028754012,15.959448118169989]
["VRT10","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,321.94973360000006,251.46592976076806,151.32254988118265,118.97982465478755,104.4540493785001,99.348187837500021,9595.2063375000034,11904.668212500004,20314.755956250006,26389.856193750002,33800.797800000008,16196.620781250002,20815.544531250001,37635.720018750006,49785.920493750011,64607.803706250008,null,null,null,null,null,null,null,null,null,null,null,null,107.83410890655398,161.75116335983097,161.75116335983097,1132.258143518817,2359.4103028754012,15.959448118169989]
[]
["End"]

{"sheet":"Input|2019-20 tariffs","index":7,"n_rows":27,"n_cols":72,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,3,8,8],[8,9,8,14],[8,15,8,20],[8,21,8,23],[8,24,8,27],[8,54,8,58],[8,59,8,65],[8,66,8,71],[8,28,8,32],[8,33,8,37],[8,38,8,43],[8,44,8,48],[8,49,8,53]]}
[{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[{"$f":"Index!$C$27","v":"Input|2019-20 tariffs"}]
[]
[]
["Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
["Haulague and Reference Tariffs"]
[]
["Tariff Type",null,null,"Demand Capacity",null,null,null,null,null,"Demand Capacity Distance",null,null,null,null,null,"Pressure Reduction",null,null,null,null,null,"Demand Throughput - DT",null,null,"Demand Throughput - DMT",null,null,null,"Metering - Single Meter",null,null,null,null,"Metering Double Meter",null,null,null,null,"Volume Residential Distributed Generated Technology - VRT",null,null,null,null,null,"VRT Metering - Single Meter",null,null,null,null,"VRT Metering Double Meter",null,null,null,null,"Volume Boundary Meter - VB",null,null,null,null,"Volume Individual Meter- VI",null,null,null,null,null,null," Ancillary Charges      "]
["Tariff Block",null,null,"Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Block 1","Block 2","Block 3","Fixed","Block 1","Block 2","Block 3","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","MHQ < 10 GJ/hr","10 to < 50 GJ/hr","50 to < 100 GJ/hr","100 to < 1000 GJ/hr","1000GJ/hr and greater","Fixed charge","Block 1","Block 2","Block 3","Block 4","Fixed charge","Block 1","Block 2","Block 3","Block 4","Block 5","Block 6","Requests For Service","Disconnections Small Meters","Temporary Disconnections Large Meters","Decommission small meter","Decommission large meter","Special Meter Reads"]
["Unit",null,null,"$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD x dist","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/GJ of CD pa","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/Year","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/GJ","$/Hr","$/Disconnection/Meter set","$/Disconnection/Meter set","$/Decommission/Meter","$/Decommission/Meter","$/Meter read"]
[]
["Volume Individual Meter"]
["VI Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.222019827883337,24.371457145760374,18.724676143672326,9.495817956754312,9.484914616720463,8.4184316886540529,4.9472765227986093,110.57956363749909,165.86934545624865,165.86934545624865,1161.0854181937407,2419.4808523884803,16.365775418349866]
["VI Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.222019827883337,23.885762907888811,18.290876090649061,9.1885420103457704,9.1786298830422659,8.1018656288094988,4.7192975948180784,110.57956363749909,165.86934545624865,165.86934545624865,1161.0854181937407,2419.4808523884803,16.365775418349866]
[]
["Volume Boundary Meter"]
["VB Coastal","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1536.6605948365002,21.934311431184337,16.852208529305095,8.5462361610788804,8.5364231550484178,null,null,null,null,null,null,null,110.57956363749909,165.86934545624865,165.86934545624865,1161.0854181937407,2419.4808523884803,16.365775418349866]
["VB Country","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1536.6605948365002,21.497186617099931,16.461788481584154,8.2696878093111934,8.2607668947380404,null,null,null,null,null,null,null,110.57956363749909,165.86934545624865,165.86934545624865,1161.0854181937407,2419.4808523884803,16.365775418349866]
[]
["Volume Residential Distributed Generated Technology"]
["VRT3","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,659.65845396000032,481.59816556173746,288.30522090222274,209.11124823699214,176.08068496365564,139.78601441437505,10074.966654375005,12499.901623125004,21330.493754062507,27709.349003437503,35490.837690000008,17006.451820312501,21856.321757812504,39517.506019687506,52275.216518437512,67838.193891562507,null,null,null,null,null,null,null,null,null,null,null,null,110.57956363749909,165.86934545624865,165.86934545624865,1161.0854181937407,2419.4808523884803,16.365775418349866]
["VRT4","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1088.4052051400001,794.61416288474493,456.67436448039012,323.05272667236642,268.25756527597605,211.65342919875005,10074.966654375005,12499.901623125004,21330.493754062507,27709.349003437503,35490.837690000008,17006.451820312501,21856.321757812504,39517.506019687506,52275.216518437512,67838.193891562507,null,null,null,null,null,null,null,null,null,null,null,null,110.57956363749909,165.86934545624865,165.86934545624865,1161.0854181937407,2419.4808523884803,16.365775418349866]
["VRT6","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,226.95629022000011,165.69443228764726,105.06276894846053,90.424658175167906,90.395258474880123,78.192666208125019,10074.966654375005,12499.901623125004,21330.493754062507,27709.349003437503,35490.837690000008,17006.451820312501,21856.321757812504,39517.506019687506,52275.216518437512,67838.193891562507,null,null,null,null,null,null,null,null,null,null,null,null,110.57956363749909,165.86934545624865,165.86934545624865,1161.0854181937407,2419.4808523884803,16.365775418349866]
["VRT10","JGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,354.14470696000012,258.55113383520307,155.58615389303444,122.33215289751071,107.39710515131138,104.31559722937503,10074.966654375005,12499.901623125004,21330.493754062507,27709.349003437503,35490.837690000008,17006.451820312501,21856.321757812504,39517.506019687506,52275.216518437512,67838.193891562507,null,null,null,null,null,null,null,null,null,null,null,null,110.57956363749909,165.86934545624865,165.86934545624865,1161.0854181937407,2419.4808523884803,16.365775418349866]
[]
["End"]

{"sheet":"Input|Escalators","index":8,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,13,2,18],[9,9,9,12],[9,14,9,18],[0,2,0,4],[1,2,1,4],[2,9,2,11]]}
[null,null,{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"},{"$f":"Index!$C$27","v":"Input|2019-20 tariffs"},{"$f":"Index!$C$27","v":"Input|2019-20 tariffs"}]
[null,null,{"$f":"Index!$C$28","v":"Input|Escalators"},{"$f":"Index!$C$27","v":"Input|2019-20 tariffs"},{"$f":"Index!$C$27","v":"Input|2019-20 tariffs"}]
[null,null,null,null,null,null,null,null,null,"Historical Period",null,null,"Base Year","Forecast Period"]
[null,null,null,"Source","Unit","Basis","Jul to Jun",null,null,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Inflation"]
[]
[null,null,"Inflation",null,null,null,null,null,null,"Australian Burean of Statistics (ABS) Data",null,null,null,"RBA Fcast","JGN Forecast (estimated using AER's preferred approach)"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"RY\"&RIGHT(J$4,2)","v":"RY11"},{"$f":"\"RY\"&RIGHT(K$4,2)","v":"RY12"},{"$f":"\"RY\"&RIGHT(L$4,2)","v":"RY13"},{"$f":"\"RY\"&RIGHT(M$4,2)","v":"RY14"},"RY15","RY16","RY17","RY18","RY19","RY20"]
[null,null,"Inflation Rate","ABS / RBA / JGN",0,null,null,null,null,2.6548672566371723E-2,3.1034482758620641E-2,2.2044088176352838E-2,2.74509803921568E-2,0.03,2.5459984403675608E-2,2.5459984403675608E-2,2.5459984403675608E-2,2.5459984403675608E-2,2.5459984403675608E-2]
[]
[null,null,"Source (actuals): ABS, all groups CPI inflation series A2325846C, weighted average for the eight capital cities (Dec quarter).  CPI index was rebased between the Jun 2012 and Sep 2012 releases."]
[null,null,"Source (forecast): RBA, Statement on Monetary Policy, 9 May 2014, p. 66."]
[]
[null,null,"CPI indexes (real to nominal)"]
[]
[null,null,"Real 2010","Calculated","factor",null,null,null,1,{"$f":"I19*(1+J$12)","v":1.0265486725663717},{"$f":"J19*(1+K$12)","v":1.0584070796460177},1.0817386986362105,1.1114334864419104,1.1447764910351679,1.1739224826426178,1.203810530741823,1.2344595280794903,1.2658888484113628,1.2981183587487031]
[null,null,"Real 2011","Calculated","factor",null,null,null,{"$f":"J20/(1+I$12)","v":1},1,1.0310344827586206,1.0537626978094121,1.0826895169649644,1.1151702024739134,1.1435624184363429,1.1726774997743616,1.2025338506291581,1.2331503437110685,1.2645463322293395]
[null,null,"Real 2012","Calculated","factor",null,null,null,{"$f":"J21/(1+I$12)","v":0.96989966555183948},{"$f":"K21/(1+K$12)","v":0.96989966555183948},1,1.0220440881763528,1.0501002004008015,1.0816032064128256,1.1091408071790616,1.1373795148313206,1.1663371795399862,1.1960321059405012,1.2264830647040417]
[null,null,"Real 2013","Calculated","factor",null,null,null,{"$f":"J22/(1+I$12)","v":0.9489802610007213},{"$f":"K22/(1+K$12)","v":0.9489802610007213},0.97843137254901946,1,1.0274509803921568,1.0582745098039215,1.0852181623183368,1.112847799805547,1.1411808874322609,1.170235335028059,1.2000295084065034]
[null,null,"Real 2014","Calculated","factor",null,null,null,{"$f":"J23/(1+I$12)","v":0.9236258265465036},0.9236258265465036,0.95229007633587781,0.97328244274809173,1,1.03,1.056223783935786,1.0831152250015823,1.1106913217375061,1.1389695054662408,1.1679676513116732]
[null,null,"Real 2015","Calculated","factor",null,null,null,{"$f":"J24/(1+I$12)","v":0.8967241034432073},0.8967241034432073,0.92455347217075512,0.94493441043504045,0.970873786407767,1,1.0254599844036756,1.0515681796131866,1.0783410890655398,1.105795636374991,1.1339491760307507]
[null,null,"Nominal","Calculated","factor",null,null,null,null,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,"CPI indexes (nominal to real)"]
[]
[null,null,"Real 2010","Calculated","factor",null,null,null,null,{"$f":"1/J$19","v":0.97413793103448276},{"$f":"1/K$19","v":0.94481605351170572},0.92443766804380612,0.899738951722025,0.87353296283691739,0.85184500236242111,0.83069550769236999,0.81007110986923114,0.78995877185817531,0.77034578030614353]
[null,null,"Real 2011","Calculated","factor",null,null,null,null,{"$f":"1/J$20","v":1},{"$f":"1/K$20","v":0.96989966555183948},0.94898026100072119,0.9236258265465036,0.8967241034432073,0.87446035640744135,0.85274937072845092,0.83157742252062705,0.81093112863317141,0.79079743819037773]
[null,null,"Real 2012","Calculated","factor",null,null,null,null,{"$f":"1/J$21","v":1.0310344827586206},{"$f":"1/K$21","v":1},0.97843137254901946,0.95229007633587792,0.92455347217075523,0.90159878126146542,0.87921400637174774,0.85738499770230159,0.83609795676316634,0.81533942765145839]
[null,null,"Real 2013","Calculated","factor",null,null,null,null,{"$f":"1/J$22","v":1.0537626978094119},{"$f":"1/K$22","v":1.0220440881763528},1,0.97328244274809173,0.94493441043504045,0.9214737042952853,0.89859547745409085,0.87628526819273322,0.85452897384612192,0.83331284188826427]
[null,null,"Real 2014","Calculated","factor",null,null,null,null,{"$f":"1/J$23","v":1.0826895169649644},{"$f":"1/K$23","v":1.0501002004008018},1.0274509803921568,1,0.970873786407767,0.94676906088378321,0.9232628042861637,0.90034015790782762,0.87798663195170168,0.85618809637147142]
[null,null,"Real 2015","Calculated","factor",null,null,null,null,{"$f":"1/J$24","v":1.1151702024739134},{"$f":"1/K$24","v":1.0816032064128258},1.0582745098039215,1.03,1,0.97517213271029679,0.95096068841474868,0.92735036264506254,0.90432623091025277,0.88187373926261559]
[null,null,{"$f":"Nominal","v":"Nominal"},"Calculated","factor",null,null,null,null,{"$f":"1/J$25","v":1},{"$f":"1/K$25","v":1},1,1,1,1,1,1,1,1]
[]
[null,"End"]

{"sheet":"Input|2014-15 calcs","index":9,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$29","v":"Input|2014-15 calcs"}]
[]
[null,null,null,"Source","Unit","Basis"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Haulague and Reference Tariffs"]
[]
[null,null,null,null,15,18,69,900,4002,"rest"]
[null,null,null,null,"Block 1_GJ","Block 2_GJ","Block 3_GJ ","Block 4_GJ","Block 5_GJ ","Block 6_GJ","fixed","fixed meter","variable meter","mr q","mr monthly"]
[null,null,null,"2014/15 coastal",24.140999999999998,9.42,9.0559999999999992,8.8620000000000001,7.7220000000000004,4.218,30.97,13.9,0.504,4.6289999999999996,48.93]
[null,null,null,"2014/15 country",23.683,9.11,8.7490000000000006,8.5510000000000002,7.4139999999999997,4,{"$f":"K12","v":30.97},{"$f":"L12","v":13.9},0.504,4.6289999999999996,48.93]
[]
[null,null,null,"Avg Load",null,null,null,null,null,null,null,null,null,null,null,null,"Revenue"]
[null,null,"coastal",5,5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(E16:J16,$E$12:$J$12)+$K$12+$L$12+$N$12","v":170.20399999999998}]
[null,null,"coastal",15,15,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(E17:J17,$E$12:$J$12)+$K$12+$L$12+$N$12","v":411.61399999999992}]
[null,null,"coastal",25,15,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(E18:J18,$E$12:$J$12)+$K$12+$L$12+$N$12","v":505.81399999999996}]
[null,null,"country",50,15,18,17,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(E19:J19,$E$13:$J$13)+$K$13+$L$13+$N$13","v":717.45700000000011}]
[null,null,"coastal",90,15,18,57,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(E20:J20,$E$12:$J$12)+$K$12+$L$12+$N$12","v":1097.366}]
[]
[null,null,"coastal",200,15,18,69,{"$f":"D22-SUM(E22:G22)","v":98},null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(E22:J22,$E$12:$J$12)+$K$12+$M$12*D22+$N$12","v":2161.4139999999998}]
[null,null,"coastal",2000,15,18,69,900,{"$f":"D23-SUM(E23:H23)","v":998},null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(E23:J23,$E$12:$J$12)+$K$12+$M$12*D23+$O$12","v":17926.795000000002}]
[null,null,"coastal",8000,15,18,69,900,{"$f":"I10","v":4002},{"$f":"D24-SUM(E24:I24)","v":2996},null,null,null,null,null,null,{"$f":"SUMPRODUCT(E24:J24,$E$12:$J$12)+$K$12+$M$12*D24+$O$12","v":56784.811000000009}]
[]
[null,"End"]

{"sheet":"Calc|Customer outcomes","index":10,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"},{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"},{"$f":"Index!$C$1","v":"JGN Reference tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$30","v":"Calc|Customer outcomes"},{"$f":"Index!$C$29","v":"Input|2014-15 calcs"},{"$f":"Index!$C$29","v":"Input|2014-15 calcs"}]
[]
[null,null,null,"Source","Unit","Basis"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Revenue"]
[]
[null,null,"2014/15","Source",null,null,"Avg Load","Block 1_GJ","Block 2_GJ","Block 3_GJ ","Block 4_GJ","Block 5_GJ ","Block 6_GJ","Revenue"]
[null,null,"Archetype"]
[null,null,"Small Residential","JGN",null,null,15,7.56,7.44,0,0,0,0,{"$f":"'Input|2014-15 calcs'!Q17","v":411.61399999999992}]
[null,null,"Commercial","JGN",null,null,2000,7.56,7.44,18,969,998,0,{"$f":"'Input|2014-15 calcs'!Q23","v":17926.795000000002}]
[]
[null,null,"2015/16",null,null,null,"Avg Load","Block 1_GJ","Block 2_GJ","Block 3_GJ ","Block 4_GJ","Block 5_GJ ","Block 6_GJ","Revenue"]
[null,null,"Archetype"]
[null,null,"Small Residential","JGN",null,null,15,7.56,7.44,0,0,0,0,{"$f":"SUMPRODUCT(H17:M17,'Input|2015-16 tariffs'!$BI$14:$BN$14)+'Input|2015-16 tariffs'!$BH$14","v":394.9174959969252}]
[null,null,"Commercial","JGN",null,null,2000,7.56,7.44,18,969,998,0,{"$f":"SUMPRODUCT(H18:M18,'Input|2015-16 tariffs'!$BI$14:$BN$14)+'Input|2015-16 tariffs'!$BH$14","v":18315.794890121688}]
[]
[null,null,"2016/17",null,null,null,"Avg Load","Block 1_GJ","Block 2_GJ","Block 3_GJ ","Block 4_GJ","Block 5_GJ ","Block 6_GJ","Revenue"]
[null,null,"Archetype"]
[null,null,"Small Residential","JGN",null,null,15,7.56,7.44,0,0,0,0,{"$f":"SUMPRODUCT(H22:M22,'Input|2016-17 tariffs'!$BI$14:$BN$14)+'Input|2016-17 tariffs'!$BH$14","v":390.17243496165702}]
[null,null,"Commercial","JGN",null,null,2000,7.56,7.44,18,969,998,0,{"$f":"SUMPRODUCT(H23:M23,'Input|2016-17 tariffs'!$BI$14:$BN$14)+'Input|2016-17 tariffs'!$BH$14","v":18271.550535142687}]
[]
[null,null,"2017/18",null,null,null,"Avg Load","Block 1_GJ","Block 2_GJ","Block 3_GJ ","Block 4_GJ","Block 5_GJ ","Block 6_GJ","Revenue"]
[null,null,"Archetype"]
[null,null,"Small Residential","JGN",null,null,15,7.56,7.44,0,0,0,0,{"$f":"SUMPRODUCT(H27:M27,'Input|2017-18 tariffs'!$BI$14:$BN$14)+'Input|2017-18 tariffs'!$BH$14","v":385.16534484582144}]
[null,null,"Commercial","JGN",null,null,2000,7.56,7.44,18,969,998,0,{"$f":"SUMPRODUCT(H28:M28,'Input|2017-18 tariffs'!$BI$14:$BN$14)+'Input|2017-18 tariffs'!$BH$14","v":18227.131211230211}]
[]
[null,null,"2018/19",null,null,null,"Avg Load","Block 1_GJ","Block 2_GJ","Block 3_GJ ","Block 4_GJ","Block 5_GJ ","Block 6_GJ","Revenue"]
[null,null,"Archetype"]
[null,null,"Small Residential","JGN",null,null,15,7.56,7.44,0,0,0,0,{"$f":"SUMPRODUCT(H32:M32,'Input|2018-19 tariffs'!$BI$14:$BN$14)+'Input|2018-19 tariffs'!$BH$14","v":380.06078181820214}]
[null,null,"Medium I&C","JGN",null,null,2000,7.56,7.44,18,969,998,0,{"$f":"SUMPRODUCT(H33:M33,'Input|2018-19 tariffs'!$BI$14:$BN$14)+'Input|2018-19 tariffs'!$BH$14","v":18182.701282664329}]
[]
[null,null,"2019/20",null,null,null,"Avg Load","Block 1_GJ","Block 2_GJ","Block 3_GJ ","Block 4_GJ","Block 5_GJ ","Block 6_GJ","Revenue"]
[null,null,"Archetype"]
[null,null,"Small Residential","JGN",null,null,15,7.56,7.44,0,0,0,0,{"$f":"SUMPRODUCT(H37:M37,'Input|2019-20 tariffs'!$BI$14:$BN$14)+'Input|2019-20 tariffs'!$BH$14","v":374.7818263587539}]
[null,null,"Medium I&C","JGN",null,null,2000,7.56,7.44,18,969,998,0,{"$f":"SUMPRODUCT(H38:M38,'Input|2019-20 tariffs'!$BI$14:$BN$14)+'Input|2019-20 tariffs'!$BH$14","v":18138.183638459206}]
[]
[null,"Customer outcomes"]
[]
[null,null,"Customer Outcomes","Source","Unit","Basis",null,"RY15","RY16","RY17","RY18","RY19","RY20","Total"]
[]
[null,null,"Small Residential - 15 GJ pa","Calculated","Above","Nominal",null,{"$f":"N12","v":411.61399999999992},{"$f":"N17","v":394.9174959969252},{"$f":"N22","v":390.17243496165702},{"$f":"N27","v":385.16534484582144},{"$f":"N32","v":380.06078181820214},{"$f":"N37","v":374.7818263587539}]
[null,null,null,"Calculated","$ per annum","Nominal",null,null,{"$f":"I44-$H$44","v":-16.696504003074722},{"$f":"J44-$H$44","v":-21.441565038342901},{"$f":"K44-$H$44","v":-26.448655154178482},{"$f":"L44-$H$44","v":-31.553218181797774},{"$f":"M44-$H$44","v":-36.832173641246015},{"$f":"SUM(I45:M45)","v":-132.97211601863989}]
[null,null,null,"Calculated","per cent","Nominal",null,null,{"$f":"I44/H44-1","v":-4.0563498819463639E-2},{"$f":"J44/I44-1","v":-1.201532239864378E-2},-1.283301860196151E-2,-1.3252913575759528E-2,-1.3889766353144428E-2,{"$f":"M44/H44-1","v":-8.948231508463278E-2}]
[]
[null,null,"Medium I&C- 2000 GJ pa","Calculated","$ per annum","Nominal",null,{"$f":"N13","v":17926.795000000002},{"$f":"N18","v":18315.794890121688},{"$f":"N23","v":18271.550535142687},{"$f":"N28","v":18227.131211230211},{"$f":"N33","v":18182.701282664329},{"$f":"N38","v":18138.183638459206}]
[null,null,null,"Calculated","$ per annum","Nominal",null,null,{"$f":"I48-$H$48","v":388.99989012168589},{"$f":"J48-$H$48","v":344.7555351426854},{"$f":"K48-$H$48","v":300.3362112302093},{"$f":"L48-$H$48","v":255.90628266432759},{"$f":"M48-$H$48","v":211.38863845920423},{"$f":"SUM(I49:M49)","v":1501.3865576181124}]
[null,null,null,"Calculated","per cent","Nominal",null,null,{"$f":"I48/H48-1","v":2.1699355078344196E-2},{"$f":"J48/I48-1","v":-2.4156393563274925E-3},-2.431064830926144E-3,-2.4375711158817204E-3,-2.4483515135106382E-3,{"$f":"M48/H48-1","v":1.1791769720086887E-2}]
[]
[null,null,"Industrial -  DC1 customer with a CD of 402 and MHQ of 21","Calculated","$ per annum","Nominal",null,104975,110328.72500000001,115955.48997499999,121869.21996372499,128084.55018187495,134616.86224115055]
[null,null,null,"Calculated","$ per annum","Nominal",null,null,{"$f":"I52-$H$52","v":5353.7250000000058},{"$f":"J52-$H$52","v":10980.489974999989},{"$f":"K52-$H$52","v":16894.219963724987},{"$f":"L52-$H$52","v":23109.550181874947},{"$f":"M52-$H$52","v":29641.862241150549},{"$f":"SUM(I53:M53)","v":85979.847361750479}]
[null,null,null,"Calculated","per cent","Nominal",null,null,{"$f":"I52/H52-1","v":5.1000000000000156E-2},5.0999999999999934E-2,5.0999999999999934E-2,5.0999999999999934E-2,5.0999999999999934E-2,{"$f":"M52/H52-1","v":0.28237068103025043}]
[]
[null,null,"Small Residential - 15 GJ pa","Calculated","$ per annum","Real $2015",null,{"$f":"H44","v":411.61399999999992},{"$f":"I44/'Input|Escalators'!O24","v":385.11253681593166},{"$f":"J44/'Input|Escalators'!P24","v":371.03864735159613},{"$f":"K44/'Input|Escalators'!Q24","v":357.18322222108304},{"$f":"L44/'Input|Escalators'!R24","v":343.69893433845868},{"$f":"M44/'Input|Escalators'!S24","v":330.51025061866659}]
[null,null,null,"Calculated","$ per annum","Real $2015",null,null,{"$f":"I56-$H$56","v":-26.501463184068257},{"$f":"J56-$H$56","v":-40.575352648403793},{"$f":"K56-$H$56","v":-54.430777778916877},{"$f":"L56-$H$56","v":-67.915065661541234},{"$f":"M56-$H$56","v":-81.10374938133333},{"$f":"SUM(I57:M57)","v":-270.52640865426349}]
[null,null,null,"Calculated","per cent","Real $2015",null,null,{"$f":"I56/H56-1","v":-6.4384260943671112E-2},{"$f":"J56/I56-1","v":-3.654487485839053E-2},-3.7342269408889073E-2,-3.7751739286001729E-2,-3.8372780367146864E-2,{"$f":"M56/H56-1","v":-0.19703836453894508}]
[]
[null,null,"Medium I&C- 2000 GJ pa","Calculated","$ per annum","Real $2015",null,{"$f":"H48","v":17926.795000000002},{"$f":"I48/'Input|Escalators'!O24","v":17861.052765284323},{"$f":"J48/'Input|Escalators'!P24","v":17375.526275304161},{"$f":"K48/'Input|Escalators'!Q24","v":16902.936738713473},{"$f":"L48/'Input|Escalators'!R24","v":16443.09371871885},{"$f":"M48/'Input|Escalators'!S24","v":15995.587828680013}]
[null,null,null,"Calculated","$ per annum","Real $2015",null,null,{"$f":"I60-$H$60","v":-65.742234715678933},{"$f":"J60-$H$60","v":-551.26872469584123},{"$f":"K60-$H$60","v":-1023.8582612865284},{"$f":"L60-$H$60","v":-1483.7012812811518},{"$f":"M60-$H$60","v":-1931.2071713199894},{"$f":"SUM(I61:M61)","v":-5055.7776732991897}]
[null,null,null,"Calculated","per cent","Real $2015",null,null,{"$f":"I60/H60-1","v":-3.6672609195161909E-3},{"$f":"J60/I60-1","v":-2.7183531472672051E-2},-2.719857396563452E-2,-2.7204918713410686E-2,-2.7215431456757755E-2,{"$f":"M60/H60-1","v":-0.10772740868180786}]
[]
[null,null,"Industrial","Calculated","$ per annum","Real $2015",null,104975,{"$f":"I52/'Input|Escalators'!O24","v":107589.49805745785},{"$f":"J52/'Input|Escalators'!P24","v":110269.11257209547},{"$f":"K52/'Input|Escalators'!Q24","v":113015.46532863125},{"$f":"L52/'Input|Escalators'!R24","v":115830.2185038101},{"$f":"M52/'Input|Escalators'!S24","v":118715.07567240384}]
[null,null,null,"Calculated","$ per annum","Real $2015",null,null,{"$f":"I64-$H$64","v":2614.4980574578512},{"$f":"J64-$H$64","v":5294.1125720954733},{"$f":"K64-$H$64","v":8040.4653286312532},{"$f":"L64-$H$64","v":10855.218503810102},{"$f":"M64-$H$64","v":13740.075672403837},{"$f":"SUM(I65:M65)","v":40544.370134398516}]
[null,null,null,"Calculated","per cent","Real $2015",null,null,{"$f":"I64/H64-1","v":2.4905911478521947E-2},2.4905911478521725E-2,2.4905911478521947E-2,2.4905911478521947E-2,2.4905911478521725E-2,{"$f":"M64/H64-1","v":0.13088902760089383}]