{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Index","Input|2015 tariffs","Input|2016 proposed tariffs","Input|2017 indicative tariffs","Input|2018 indicative tariffs","Input|2019 indicative tariffs","Input|2020 indicative tariffs","Input|archetype demand","Calc|Customer tariff","Calc|Customer outcomes"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":8,"defined_names":245,"comments":1,"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":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4],[6,2,13,12]]}
[null,null,"JEN 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,"\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Model Index"]
[]
[null,null,"Description of model","This model estimates the customer outcomes from JEN's proposed tariffs"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Input|2015 tariffs","Inputs the JEN distribution services tariffs for the 2015 year"]
[null,null,"Input|2016 proposed tariffs","Inputs the JEN proposed distribution services tariffs for the 2016 year"]
[null,null,"Input|2017 indicative tariffs","Inputs the JEN indicative distribution services tariffs for the 2017 year"]
[null,null,"Input|2018 indicative tariffs","Inputs the JEN indicative distribution services tariffs for the 2018 year"]
[null,null,"Input|2019 indicative tariffs","Inputs the JEN indicative distribution services tariffs for the 2019 year"]
[null,null,"Input|2020 indicative tariffs","Inputs the JEN indicative distribution services tariffs for the 2020 year"]
[null,null,"Input|archetype demand","Inputs the demand levels for customer archetypes"]
[null,null,"Calc|Customer tariff","Calculates the customer outcomes on distribution services tariffs"]
[null,null,"Calc|Customer Outcomes","Calculates the overall impact to the customer of distribution services and advanced metering charges"]
[]
[null,null,"Version Control","Developer","Comments","Date"]
[null,null,"Version 1","Jemena Electricity Networks","Submission model","2015-04-30"]
[]
[]
[null,"End"]

{"sheet":"Input|2015 tariffs","index":1,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!C21","v":"Input|2015 tariffs"}]
[]
[null,null,null,"Source","Basis","Tariff code"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Distribution services tariffs"]
[]
[]
[null,null,"Tariff component",null,null,null,"Fixed (Standing charge)","Unit rate ","Peak","Off peak","Summer peak","Summer shoulder ","Summer off peak","Non-summer peak","Non-summer shoulder","Non-summer off peak","Demand","Demand"]
[null,null,"Unit",null,null,null,"$ per customer pa","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","$/kW","$/kVA"]
[]
[null,null,"Residential"]
[null,null,"Residential - General Purpose","JEN","$nominal","A100",26.033000000000001,8.2530000000000001,0,0,0,0,0,0,0,0,0,0]
[null,null,"Residential - Flexible","JEN","$nominal","A10X",26.033000000000001,0,13.98,4.1959999999999997,13.98,8.8689999999999998,4.1959999999999997,13.98,8.8689999999999998,4.1959999999999997,0,0]
[null,null,"Residential - Time of Use Interval Meter","JEN","$nominal","A10I",26.033000000000001,0,13.388,2.093,0,0,0,0,0,0,0,0]
[null,null,"Residential - TOU","JEN","$nominal","A140",45.834000000000003,0,9.4719999999999995,1.7190000000000001,0,0,0,0,0,0,0,0]
[null,null,"Residential - Off Peak Only","JEN","$nominal","A180",0,0,0,1.7270000000000001,0,0,0,0,0,0,0,0]
[]
[null,null,"Small business"]
[null,null,"Small Business - General Purpose","JEN","$nominal","A200",68.075999999999993,0,9.3970000000000002,0,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Weekdays","JEN","$nominal","A210",98.132000000000005,0,11.093999999999999,1.859,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Weekdays Demand","JEN","$nominal","A230",129.07599999999999,0,6.8339999999999996,2.1720000000000002,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - TOU Extended","JEN","$nominal","A250",98.132000000000005,0,9.7710000000000008,2.0369999999999999,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Extended Demand","JEN","$nominal","A270",129.07599999999999,0,5.1120000000000001,2.3359999999999999,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - Unmetered Supply","JEN","$nominal","A290",0,0,10.446999999999999,1.837,0,0,0,0,0,0,0,0]
[]
[null,null,"Large business - low voltage"]
[null,null,"Large Business - LV 0.4 - 0.8  GWh","JEN","$nominal","A300",1957.64,0,1.992,0.64800000000000002,0,0,0,0,0,0,108.73399999999999,0]
[null,null,"Large Business – LVEN Annual Consumption <= 0.8 GWh","JEN","$nominal","A30E",1957.64,0,2.0110000000000001,0.64800000000000002,0,0,0,0,0,0,112.905,0]
[null,null,"Large Business - LV  0.8+ - 2.2  GWh","JEN","$nominal","A320",3223.2020000000002,0,1.327,0.626,0,0,0,0,0,0,100.50700000000001,0]
[null,null,"Large Business - LVEN 0.8+ - 2.2 GWh","JEN","$nominal","A32E",3223.2020000000002,0,1.3260000000000001,0.626,0,0,0,0,0,0,101.759,0]
[null,null,"Large Business - LV  2.2+ - 6.0  GWh","JEN","$nominal","A340",4923.7910000000002,0,1.2150000000000001,0.46600000000000003,0,0,0,0,0,0,99.421999999999997,0]
[null,null,"Large Business - LVEN 2.2+  GWh","JEN","$nominal","A34E",4923.7910000000002,0,1.2150000000000001,0.46600000000000003,0,0,0,0,0,0,99.555000000000007,0]
[null,null,"Large Business - LVMS 2.2+ - 6.0  GWh","JEN","$nominal","A34M",2461.884,0,1.202,0.46600000000000003,0,0,0,0,0,0,68.879000000000005,0]
[null,null,"Large Business - LV 6.0+ GWh","JEN","$nominal","A370",6406.8609999999999,0,1.179,0.40400000000000003,0,0,0,0,0,0,95.646000000000001,0]
[null,null,"Large Business - LVMS 6.0+ GWh","JEN","$nominal","A37M",3203.424,0,1.179,0.40400000000000003,0,0,0,0,0,0,68.034999999999997,0]
[]
[null,null,"Large business - high voltage"]
[null,null,"Large Business - HV","JEN","$nominal","A400",3425.701,0,0.78900000000000003,0.184,0,0,0,0,0,0,79.183000000000007,0]
[]
[]
[null,"Input | Advanced Metering Infrastructure"]
[]
[null,null,"Meter provision charge ",null,null,2015]
[]
[null,null," Single phase single element meter ",null,null,226.32]
[null,null," Single phase single element meter with contactor ",null,null,226.32]
[null,null," Three phase direct connected meter ",null,null,278.12]
[null,null," Three phase Current transformer connected meter ",null,null,308.65999999999997]
[]
[]
[null,"End"]

{"sheet":"Input|2016 proposed tariffs","index":2,"n_rows":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$22","v":"Input|2016 proposed tariffs"}]
[]
[null,null,null,"Source","Basis","Tariff code"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Distribution services tariffs"]
[]
[]
[null,null,"Tariff component",null,null,null,"Fixed (Standing charge)","Unit rate ","Peak","Off peak","Summer peak","Summer shoulder ","Summer off peak","Non-summer peak","Non-summer shoulder","Non-summer off peak","Demand","Demand"]
[null,null,"Unit",null,null,null,"$ per customer pa","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","$/kW","$/kVA"]
[]
[null,null,"Residential"]
[null,null,"Residential - General Purpose","JEN","$nominal","A100",26.701000000000001,8.4610000000000003,0,0,0,0,0,0,0,0,0,0]
[null,null,"Residential - Flexible","JEN","$nominal","A10X",26.701000000000001,0,14.333,4.3019999999999996,14.333,9.093,4.3019999999999996,14.333,9.093,4.3019999999999996,0,0]
[null,null,"Residential - Time of Use Interval Meter","JEN","$nominal","A10I",26.701000000000001,0,13.726000000000001,2.1459999999999999,0,0,0,0,0,0,0,0]
[null,null,"Residential - TOU","JEN","$nominal","A140",47.018000000000001,0,9.7110000000000003,1.762,0,0,0,0,0,0,0,0]
[null,null,"Residential - Off Peak Only","JEN","$nominal","A180",0,0,0,1.7709999999999999,0,0,0,0,0,0,0,0]
[]
[null,null,"Small business"]
[null,null,"Small Business - General Purpose","JEN","$nominal","A200",70.503,0,9.6460000000000008,0,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Weekdays","JEN","$nominal","A210",101.63,0,11.388,1.907,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Weekdays Demand","JEN","$nominal","A230",133.678,0,7.0149999999999997,2.2280000000000002,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - TOU Extended","JEN","$nominal","A250",101.63,0,10.029999999999999,2.09,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Extended Demand","JEN","$nominal","A270",133.678,0,5.2469999999999999,2.3969999999999998,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - Unmetered Supply","JEN","$nominal","A290",0,0,10.724,1.885,0,0,0,0,0,0,0,0]
[]
[null,null,"Large business - low voltage"]
[null,null,"Large Business - LV 0.4 - 0.8  GWh","JEN","$nominal","A300",2009.713,0,2.11,0.68400000000000005,0,0,0,0,0,0,110.36499999999999,0]
[null,null,"Large Business – LVEN Annual Consumption <= 0.8 GWh","JEN","$nominal","A30E",2009.713,0,2.13,0.68400000000000005,0,0,0,0,0,0,114.599,0]
[null,null,"Large Business - LV  0.8+ - 2.2  GWh","JEN","$nominal","A320",3308.9389999999999,0,1.405,0.66100000000000003,0,0,0,0,0,0,102.015,0]
[null,null,"Large Business - LVEN 0.8+ - 2.2 GWh","JEN","$nominal","A32E",3308.9389999999999,0,1.4039999999999999,0.66100000000000003,0,0,0,0,0,0,103.285,0]
[null,null,"Large Business - LV  2.2+ - 6.0  GWh","JEN","$nominal","A340",5054.7640000000001,0,1.2869999999999999,0.49199999999999999,0,0,0,0,0,0,100.913,0]
[null,null,"Large Business - LVEN 2.2+  GWh","JEN","$nominal","A34E",5054.7640000000001,0,1.2869999999999999,0.49199999999999999,0,0,0,0,0,0,101.048,0]
[null,null,"Large Business - LVMS 2.2+ - 6.0  GWh","JEN","$nominal","A34M",2527.37,0,1.2729999999999999,0.49199999999999999,0,0,0,0,0,0,69.912000000000006,0]
[null,null,"Large Business - LV 6.0+ GWh","JEN","$nominal","A370",6577.2839999999997,0,1.2490000000000001,0.42599999999999999,0,0,0,0,0,0,97.081000000000003,0]
[null,null,"Large Business - LVMS 6.0+ GWh","JEN","$nominal","A37M",3288.6350000000002,0,1.2490000000000001,0.42599999999999999,0,0,0,0,0,0,69.055999999999997,0]
[]
[null,null,"Large business - high voltage"]
[null,null,"Large Business - HV","JEN","$nominal","A400",3529.8420000000001,0,0.83799999999999997,0.19500000000000001,0,0,0,0,0,0,80.569000000000003,0]
[]
[]
[null,"Input | Advanced Metering Infrastructure"]
[]
[null,null,"Meter provision charge ",null,null,2016]
[]
[null,null," Single phase single element meter ",null,null,94.218705600087873]
[null,null," Single phase single element meter with contactor ",null,null,94.218705600087873]
[null,null," Three phase direct connected meter ",null,null,115.7834323148482]
[null,null," Three phase Current transformer connected meter ",null,null,128.49746231231498]
[]
[]
[]
[null,"End"]

{"sheet":"Input|2017 indicative tariffs","index":3,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$23","v":"Input|2017 indicative tariffs"}]
[]
[null,null,null,"Source","Basis","Tariff code"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Distribution services tariffs"]
[]
[]
[null,null,"Tariff component",null,null,null,"Fixed (Standing charge)","Unit rate ","Peak","Off peak","Summer peak","Summer shoulder ","Summer off peak","Non-summer peak","Non-summer shoulder","Non-summer off peak","Demand","Demand"]
[null,null,"Unit",null,null,null,"$ per customer pa","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","$/kW","$/kVA"]
[]
[null,null,"Residential"]
[null,null,"Residential - General Purpose","JEN","$nominal","A100",27.356999999999999,8.6750000000000007,0,0,0,0,0,0,0,0,0,0]
[null,null,"Residential - Flexible","JEN","$nominal","A10X",27.356999999999999,0,14.695,4.4109999999999996,14.695,9.3230000000000004,4.4109999999999996,14.695,9.3230000000000004,4.4109999999999996,0,0]
[null,null,"Residential - Time of Use Interval Meter","JEN","$nominal","A10I",27.356999999999999,0,14.071999999999999,2.2000000000000002,0,0,0,0,0,0,0,0]
[null,null,"Residential - TOU","JEN","$nominal","A140",48.198999999999998,0,9.9559999999999995,1.806,0,0,0,0,0,0,0,0]
[null,null,"Residential - Off Peak Only","JEN","$nominal","A180",0,0,0,1.8160000000000001,0,0,0,0,0,0,0,0]
[]
[null,null,"Small business"]
[null,null,"Small Business - General Purpose","JEN","$nominal","A200",72.396000000000001,0,9.9049999999999994,0,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Weekdays","JEN","$nominal","A210",104.35899999999999,0,11.694000000000001,1.9550000000000001,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Weekdays Demand","JEN","$nominal","A230",137.267,0,7.2039999999999997,2.2839999999999998,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - TOU Extended","JEN","$nominal","A250",104.35899999999999,0,10.3,2.1429999999999998,0,0,0,0,0,0,0,0]
[null,null,"Small Business - TOU Extended Demand","JEN","$nominal","A270",137.267,0,5.3879999999999999,2.4569999999999999,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - Unmetered Supply","JEN","$nominal","A290",0,0,11.012,1.9330000000000001,0,0,0,0,0,0,0,0]
[]
[null,null,"Large business - low voltage"]
[null,null,"Large Business - LV 0.4 - 0.8  GWh","JEN","$nominal","A300",2060.2570000000001,0,2.2320000000000002,0.72199999999999998,0,0,0,0,0,0,null,97.084999999999994]
[null,null,"Large Business – LVEN Annual Consumption <= 0.8 GWh","JEN","$nominal","A30E",2060.2570000000001,0,2.254,0.72199999999999998,0,0,0,0,0,0,null,96.581999999999994]
[null,null,"Large Business - LV  0.8+ - 2.2  GWh","JEN","$nominal","A320",3392.1590000000001,0,1.486,0.69799999999999995,0,0,0,0,0,0,null,90.885000000000005]
[null,null,"Large Business - LVEN 0.8+ - 2.2 GWh","JEN","$nominal","A32E",3392.1590000000001,0,1.4850000000000001,0.69799999999999995,0,0,0,0,0,0,null,100.495]
[null,null,"Large Business - LV  2.2+ - 6.0  GWh","JEN","$nominal","A340",5181.8909999999996,0,1.3620000000000001,0.51900000000000002,0,0,0,0,0,0,null,90.228999999999999]
[null,null,"Large Business - LVEN 2.2+  GWh","JEN","$nominal","A34E",5181.8909999999996,0,1.3620000000000001,0.51900000000000002,0,0,0,0,0,0,null,87.811999999999998]
[null,null,"Large Business - LVMS 2.2+ - 6.0  GWh","JEN","$nominal","A34M",2590.933,0,1.347,0.51900000000000002,0,0,0,0,0,0,null,68.227000000000004]
[null,null,"Large Business - LV 6.0+ GWh","JEN","$nominal","A370",6742.7030000000004,0,1.321,0.45,0,0,0,0,0,0,null,85.126999999999995]
[null,null,"Large Business - LVMS 6.0+ GWh","JEN","$nominal","A37M",3371.3440000000001,0,1.321,0.45,0,0,0,0,0,0,null,61.326000000000001]
[]
[null,null,"Large business - high voltage"]
[null,null,"Large Business - HV","JEN","$nominal","A400",3618.0880000000002,0,0.89,0.20599999999999999,0,0,0,0,0,0,null,74.180000000000007]
[]
[]
[null,"Input | Advanced Metering Infrastructure"]
[]
[null,null,"Meter provision charge ",null,null,2017]
[]
[null,null," Single phase single element meter ",null,null,96.59673057092283]
[null,null," Single phase single element meter with contactor ",null,null,96.59673057092283]
[null,null," Three phase direct connected meter ",null,null,118.70573836331327]
[null,null," Three phase Current transformer connected meter ",null,null,131.74066303473418]
[]
[]
[null,"End"]

{"sheet":"Input|2018 indicative tariffs","index":4,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$24","v":"Input|2018 indicative tariffs"}]
[]
[null,null,null,"Source","Basis","Tariff code"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Distribution services tariffs"]
[]
[]
[null,null,"Tariff component",null,null,null,"Fixed (Standing charge)","Unit rate ","Peak","Off peak","Summer peak","Summer shoulder ","Summer off peak","Non-summer peak","Non-summer shoulder","Non-summer off peak","Demand","Demand"]
[null,null,"Unit",null,null,null,"$ per customer pa","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","$/kW","$/kVA"]
[]
[null,null,"Residential"]
[null,null,"Residential - General Purpose","JEN","$nominal","A100",21.885000000000002,6.83,0,0,0,0,0,0,0,0,29.042999999999999,0]
[null,null,"Residential - Flexible","JEN","$nominal","A10X",21.885000000000002,0,10.102,2.714,10.102,6.83,2.714,10.102,6.83,2.714,29.042999999999999,0]
[null,null,"Residential - Time of Use Interval Meter","JEN","$nominal","A10I",21.885000000000002,0,10.102,1.9119999999999999,0,0,0,0,0,0,29.042999999999999,0]
[null,null,"Residential - TOU","JEN","$nominal","A140",33.706000000000003,0,8.1020000000000003,1.726,0,0,0,0,0,0,29.042999999999999,0]
[null,null,"Residential - Off Peak Only","JEN","$nominal","A180",0,0,0,1.8260000000000001,0,0,0,0,0,0,0,0]
[]
[null,null,"Small business"]
[null,null,"Small Business - General Purpose","JEN","$nominal","A200",71.849999999999994,0,3.9809999999999999,0,0,0,0,0,0,0,18.724,0]
[null,null,"Small Business - TOU Weekdays","JEN","$nominal","A210",71.849999999999994,0,7.9379999999999997,1.839,0,0,0,0,0,0,18.724,0]
[null,null,"Small Business - TOU Weekdays Demand","JEN","$nominal","A230",71.849999999999994,0,5.585,1.948,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - TOU Extended","JEN","$nominal","A250",71.849999999999994,0,7.13,1.9630000000000001,0,0,0,0,0,0,18.724,0]
[null,null,"Small Business - TOU Extended Demand","JEN","$nominal","A270",71.849999999999994,0,3.9180000000000001,2.02,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - Unmetered Supply","JEN","$nominal","A290",0,0,11.05,1.944,0,0,0,0,0,0,0,0]
[]
[null,null,"Large business - low voltage"]
[null,null,"Large Business - LV 0.4 - 0.8  GWh","JEN","$nominal","A300",2060.2570000000001,0,2.2989999999999999,0.73199999999999998,0,0,0,0,0,0,null,97.084999999999994]
[null,null,"Large Business – LVEN Annual Consumption <= 0.8 GWh","JEN","$nominal","A30E",2060.2570000000001,0,2.3220000000000001,0.73199999999999998,0,0,0,0,0,0,null,96.581999999999994]
[null,null,"Large Business - LV  0.8+ - 2.2  GWh","JEN","$nominal","A320",3392.1590000000001,0,1.5309999999999999,0.70699999999999996,0,0,0,0,0,0,null,90.885000000000005]
[null,null,"Large Business - LVEN 0.8+ - 2.2 GWh","JEN","$nominal","A32E",3392.1590000000001,0,1.53,0.70699999999999996,0,0,0,0,0,0,null,100.495]
[null,null,"Large Business - LV  2.2+ - 6.0  GWh","JEN","$nominal","A340",5181.8909999999996,0,1.403,0.52600000000000002,0,0,0,0,0,0,null,90.228999999999999]
[null,null,"Large Business - LVEN 2.2+  GWh","JEN","$nominal","A34E",5181.8909999999996,0,1.403,0.52600000000000002,0,0,0,0,0,0,null,87.811999999999998]
[null,null,"Large Business - LVMS 2.2+ - 6.0  GWh","JEN","$nominal","A34M",2590.933,0,1.387,0.52600000000000002,0,0,0,0,0,0,null,68.227000000000004]
[null,null,"Large Business - LV 6.0+ GWh","JEN","$nominal","A370",6742.7030000000004,0,1.361,0.45600000000000002,0,0,0,0,0,0,null,85.126999999999995]
[null,null,"Large Business - LVMS 6.0+ GWh","JEN","$nominal","A37M",3371.3440000000001,0,1.361,0.45600000000000002,0,0,0,0,0,0,null,61.326000000000001]
[]
[null,null,"Large business - high voltage"]
[null,null,"Large Business - HV","JEN","$nominal","A400",3618.0880000000002,0,0.92400000000000004,0.20899999999999999,0,0,0,0,0,0,null,74.180000000000007]
[]
[]
[null,"Input | Advanced Metering Infrastructure"]
[]
[null,null,"Meter provision charge ",null,null,2018]
[]
[null,null," Single phase single element meter ",null,null,99.034775499853126]
[null,null," Single phase single element meter with contactor ",null,null,99.034775499853126]
[null,null," Three phase direct connected meter ",null,null,121.7018017056343]
[null,null," Three phase Current transformer connected meter ",null,null,135.06572024471839]
[]
[]
[null,"End"]

{"sheet":"Input|2019 indicative tariffs","index":5,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$25","v":"Input|2019 indicative tariffs"}]
[]
[null,null,null,"Source","Basis","Tariff code"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Distribution services tariffs"]
[]
[]
[null,null,"Tariff component",null,null,null,"Fixed (Standing charge)","Unit rate ","Peak","Off peak","Summer peak","Summer shoulder ","Summer off peak","Non-summer peak","Non-summer shoulder","Non-summer off peak","Demand","Demand"]
[null,null,"Unit",null,null,null,"$ per customer pa","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","$/kW","$/kVA"]
[]
[null,null,"Residential"]
[null,null,"Residential - General Purpose","JEN","$nominal","A100",21.030999999999999,6.609,0,0,0,0,0,0,0,0,35.731000000000002,0]
[null,null,"Residential - Flexible","JEN","$nominal","A10X",21.030999999999999,0,9.7759999999999998,2.714,9.7759999999999998,6.83,2.714,9.7759999999999998,6.83,2.714,35.731000000000002,0]
[null,null,"Residential - Time of Use Interval Meter","JEN","$nominal","A10I",21.030999999999999,0,9.7759999999999998,1.9119999999999999,0,0,0,0,0,0,35.731000000000002,0]
[null,null,"Residential - TOU","JEN","$nominal","A140",32.307000000000002,0,7.84,1.726,0,0,0,0,0,0,35.731000000000002,0]
[null,null,"Residential - Off Peak Only","JEN","$nominal","A180",0,0,0,1.8260000000000001,0,0,0,0,0,0,0,0]
[]
[null,null,"Small business"]
[null,null,"Small Business - General Purpose","JEN","$nominal","A200",67.897999999999996,0,3.6230000000000002,0,0,0,0,0,0,0,23.036000000000001,0]
[null,null,"Small Business - TOU Weekdays","JEN","$nominal","A210",67.897999999999996,0,7.1440000000000001,1.679,0,0,0,0,0,0,23.036000000000001,0]
[null,null,"Small Business - TOU Weekdays Demand","JEN","$nominal","A230",67.897999999999996,0,4.9429999999999996,1.7789999999999999,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - TOU Extended","JEN","$nominal","A250",67.897999999999996,0,6.4169999999999998,1.792,0,0,0,0,0,0,23.036000000000001,0]
[null,null,"Small Business - TOU Extended Demand","JEN","$nominal","A270",67.897999999999996,0,3.4670000000000001,1.8440000000000001,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - Unmetered Supply","JEN","$nominal","A290",0,0,11.271000000000001,1.9830000000000001,0,0,0,0,0,0,0,0]
[]
[null,null,"Large business - low voltage"]
[null,null,"Large Business - LV 0.4 - 0.8  GWh","JEN","$nominal","A300",2112.7939999999999,0,2.448,0.76700000000000002,0,0,0,0,0,0,null,98.346999999999994]
[null,null,"Large Business – LVEN Annual Consumption <= 0.8 GWh","JEN","$nominal","A30E",2112.7939999999999,0,2.4729999999999999,0.76700000000000002,0,0,0,0,0,0,null,97.837999999999994]
[null,null,"Large Business - LV  0.8+ - 2.2  GWh","JEN","$nominal","A320",3478.998,0,1.631,0.74099999999999999,0,0,0,0,0,0,null,92.066999999999993]
[null,null,"Large Business - LVEN 0.8+ - 2.2 GWh","JEN","$nominal","A32E",3478.998,0,1.629,0.74099999999999999,0,0,0,0,0,0,null,101.801]
[null,null,"Large Business - LV  2.2+ - 6.0  GWh","JEN","$nominal","A340",5314.5469999999996,0,1.494,0.55100000000000005,0,0,0,0,0,0,null,91.402000000000001]
[null,null,"Large Business - LVEN 2.2+  GWh","JEN","$nominal","A34E",5314.5469999999996,0,1.494,0.55100000000000005,0,0,0,0,0,0,null,88.953999999999994]
[null,null,"Large Business - LVMS 2.2+ - 6.0  GWh","JEN","$nominal","A34M",2657.261,0,1.4770000000000001,0.55100000000000005,0,0,0,0,0,0,null,69.114000000000004]
[null,null,"Large Business - LV 6.0+ GWh","JEN","$nominal","A370",6915.3159999999998,0,1.4490000000000001,0.47799999999999998,0,0,0,0,0,0,null,86.233999999999995]
[null,null,"Large Business - LVMS 6.0+ GWh","JEN","$nominal","A37M",3457.65,0,1.4490000000000001,0.47799999999999998,0,0,0,0,0,0,null,62.122999999999998]
[]
[null,null,"Large business - high voltage"]
[null,null,"Large Business - HV","JEN","$nominal","A400",3711.7959999999998,0,0.98299999999999998,0.219,0,0,0,0,0,0,null,75.441000000000003]
[]
[]
[null,"Input | Advanced Metering Infrastructure"]
[]
[null,null,"Meter provision charge ",null,null,2019]
[]
[null,null," Single phase single element meter ",null,null,101.53435525548358]
[null,null," Single phase single element meter with contactor ",null,null,101.53435525548358]
[null,null," Three phase direct connected meter ",null,null,124.77348393272841]
[null,null," Three phase Current transformer connected meter ",null,null,138.47469995209244]
[]
[]
[null,"End"]

{"sheet":"Input|2020 indicative tariffs","index":6,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$26","v":"Input|2020 indicative tariffs"}]
[]
[null,null,null,"Source","Basis","Tariff code"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Distribution services tariffs"]
[]
[]
[null,null,"Tariff component",null,null,null,"Fixed (Standing charge)","Unit rate ","Peak","Off peak","Summer peak","Summer shoulder ","Summer off peak","Non-summer peak","Non-summer shoulder","Non-summer off peak","Demand","Demand"]
[null,null,"Unit",null,null,null,"$ per customer pa","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","c/kWh","$/kW","$/kVA"]
[]
[null,null,"Residential"]
[null,null,"Residential - General Purpose","JEN","$nominal","A100",20.190000000000001,6.3710000000000004,0,0,0,0,0,0,0,0,42.738,0]
[null,null,"Residential - Flexible","JEN","$nominal","A10X",20.190000000000001,0,9.4239999999999995,2.694,9.4239999999999995,6.68,2.694,9.4239999999999995,6.68,2.694,42.738,0]
[null,null,"Residential - Time of Use Interval Meter","JEN","$nominal","A10I",20.190000000000001,0,9.4239999999999995,1.8979999999999999,0,0,0,0,0,0,42.738,0]
[null,null,"Residential - TOU","JEN","$nominal","A140",31.015000000000001,0,7.5579999999999998,1.7130000000000001,0,0,0,0,0,0,42.738,0]
[null,null,"Residential - Off Peak Only","JEN","$nominal","A180",0,0,0,1.8120000000000001,0,0,0,0,0,0,0,0]
[]
[null,null,"Small business"]
[null,null,"Small Business - General Purpose","JEN","$nominal","A200",62.988999999999997,0,3.2749999999999999,0,0,0,0,0,0,0,27.553999999999998,0]
[null,null,"Small Business - TOU Weekdays","JEN","$nominal","A210",62.988999999999997,0,6.2480000000000002,1.595,0,0,0,0,0,0,27.553999999999998,0]
[null,null,"Small Business - TOU Weekdays Demand","JEN","$nominal","A230",62.988999999999997,0,4.226,1.69,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - TOU Extended","JEN","$nominal","A250",62.988999999999997,0,5.6120000000000001,1.702,0,0,0,0,0,0,27.553999999999998,0]
[null,null,"Small Business - TOU Extended Demand","JEN","$nominal","A270",62.988999999999997,0,2.964,1.752,0,0,0,0,0,0,67.596999999999994,0]
[null,null,"Small Business - Unmetered Supply","JEN","$nominal","A290",0,0,11.555,2.0329999999999999,0,0,0,0,0,0,0,0]
[]
[null,null,"Large business - low voltage"]
[null,null,"Large Business - LV 0.4 - 0.8  GWh","JEN","$nominal","A300",2165.614,0,2.5920000000000001,0.79700000000000004,0,0,0,0,0,0,null,99.811999999999998]
[null,null,"Large Business – LVEN Annual Consumption <= 0.8 GWh","JEN","$nominal","A30E",2165.614,0,2.6190000000000002,0.79700000000000004,0,0,0,0,0,0,null,99.296000000000006]
[null,null,"Large Business - LV  0.8+ - 2.2  GWh","JEN","$nominal","A320",3565.973,0,1.7270000000000001,0.77,0,0,0,0,0,0,null,93.438999999999993]
[null,null,"Large Business - LVEN 0.8+ - 2.2 GWh","JEN","$nominal","A32E",3565.973,0,1.7250000000000001,0.77,0,0,0,0,0,0,null,103.318]
[null,null,"Large Business - LV  2.2+ - 6.0  GWh","JEN","$nominal","A340",5447.4110000000001,0,1.5820000000000001,0.57299999999999995,0,0,0,0,0,0,null,92.763999999999996]
[null,null,"Large Business - LVEN 2.2+  GWh","JEN","$nominal","A34E",5447.4110000000001,0,1.5820000000000001,0.57299999999999995,0,0,0,0,0,0,null,90.278999999999996]
[null,null,"Large Business - LVMS 2.2+ - 6.0  GWh","JEN","$nominal","A34M",2723.6930000000002,0,1.5640000000000001,0.57299999999999995,0,0,0,0,0,0,null,70.144000000000005]
[null,null,"Large Business - LV 6.0+ GWh","JEN","$nominal","A370",7088.1989999999996,0,1.534,0.497,0,0,0,0,0,0,null,87.519000000000005]
[null,null,"Large Business - LVMS 6.0+ GWh","JEN","$nominal","A37M",3544.0909999999999,0,1.534,0.497,0,0,0,0,0,0,null,63.048999999999999]
[]
[null,null,"Large business - high voltage"]
[null,null,"Large Business - HV","JEN","$nominal","A400",3789.373,0,1.044,0.22800000000000001,0,0,0,0,0,0,null,76.75]
[]
[]
[null,"Input | Advanced Metering Infrastructure"]
[]
[null,null,"Meter provision charge ",null,null,2020]
[]
[null,null," Single phase single element meter ",null,null,104.09702294081571]
[null,null," Single phase single element meter with contactor ",null,null,104.09702294081571]
[null,null," Three phase direct connected meter ",null,null,127.92269362097767]
[null,null," Three phase Current transformer connected meter ",null,null,141.96972031155963]
[]
[]
[null,"End"]

{"sheet":"Input|archetype demand","index":7,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$27","v":"Input|archetype demand"}]
[]
[null,null,null,null,"Source"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Customer achetype demand and consumption levels"]
[]
[null,null,"Tariff component",null,null,null,"Annual consumption","Average monthly maximum demand","Peak","Off peak","Shoulder","Demand"]
[null,null,"Unit",null,null,null,"kWh","kW","kWh","kWh","kWh","kVA"]
[]
[null,null,"Residential - General purpose"]
[null,null,"Low consumption, Low demand (13.2%)",null,"JEN",null,2233,2.08]
[null,null,"Low consumption, Medium demand (6.8%)",null,"JEN",null,2233,3.1]
[null,null,"Low consumption, High demand (0.03%)",null,"JEN",null,2233,4.2699999999999996]
[null,null,"Medium consumption, Low demand (6.8%)",null,"JEN",null,3775.1270000000004,2.08]
[null,null,"Medium consumption, Medium demand (46.6%)",null,"JEN",null,3775.1270000000004,3.1]
[null,null,"Medium consumption, High demand (6.6%)",null,"JEN",null,3775.1270000000004,4.2699999999999996]
[null,null,"High consumption, Low demand (0.1%)",null,"JEN",null,5958.0654000000013,2.08]
[null,null,"High consumption, Medium demand (6.6%)",null,"JEN",null,5958.0654000000013,3.1]
[null,null,"High consumption, High demand (13.4%)",null,"JEN",null,5958.0654000000013,4.2699999999999996]
[]
[null,null,"Small business - General purpose"]
[null,null,"Small ",null,"JEN",null,6000,8]
[null,null,"Medium",null,"JEN",null,11000,20]
[null,null,"Large",null,"JEN",null,21000,50]
[]
[null,null,"Large business -LV"]
[null,null,"A300 Large business LV 0.4 - 0.8 GWh",null,"JEN",null,368000,169.65,228160,139840,null,195]
[]
[null,null,"Large business - HV"]
[null,null,"A400 Large Business HV",null,"JEN",null,6745000,2297.6999999999998,3642300.0000000005,3102700,null,2553]
[]
[]
[null,"End"]

{"sheet":"Calc|Customer tariff","index":8,"n_rows":143,"n_cols":11,"rows_kept":143,"cut":false,"hidden":false,"merged":[[0,2,0,6],[1,2,1,6]]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"},{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"},null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$28","v":"Calc|Customer tariff"},{"$f":"Index!$C$27","v":"Input|archetype demand"},null,null,{"$f":"Index!$C$27","v":"Input|archetype demand"}]
[]
[null,null,null,"Source","Unit","Basis","Tariff"]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Revenue"]
[]
[null,null,"Residential - General purpose"]
[null,null,2015,"Source","Unit","Basis","Tariff","Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Low Consumption, Low Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G14*'Input|2015 tariffs'!$H$15/100","v":184.28949},{"$f":"'Input|archetype demand'!H14*'Input|2015 tariffs'!$Q$15","v":0},{"$f":"SUM(H13:J13)","v":210.32249000000002}]
[null,null,"Low Consumption, Medium Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G15*'Input|2015 tariffs'!$H$15/100","v":184.28949},{"$f":"'Input|archetype demand'!H15*'Input|2015 tariffs'!$Q$15","v":0},{"$f":"SUM(H14:J14)","v":210.32249000000002}]
[null,null,"Low consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G16*'Input|2015 tariffs'!$H$15/100","v":184.28949},{"$f":"'Input|archetype demand'!H16*'Input|2015 tariffs'!$Q$15","v":0},{"$f":"SUM(H15:J15)","v":210.32249000000002}]
[null,null,"Medium consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G17*'Input|2015 tariffs'!$H$15/100","v":311.56123131000004},{"$f":"'Input|archetype demand'!H17*'Input|2015 tariffs'!$Q$15","v":0},337.59423131000005]
[null,null,"Medium consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G18*'Input|2015 tariffs'!$H$15/100","v":311.56123131000004},{"$f":"'Input|archetype demand'!H18*'Input|2015 tariffs'!$Q$15","v":0},337.59423131000005]
[null,null,"Medium consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G19*'Input|2015 tariffs'!$H$15/100","v":311.56123131000004},{"$f":"'Input|archetype demand'!H19*'Input|2015 tariffs'!$Q$15","v":0},337.59423131000005]
[null,null,"High consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G20*'Input|2015 tariffs'!$H$15/100","v":491.71913746200016},{"$f":"'Input|archetype demand'!H20*'Input|2015 tariffs'!$Q$15","v":0},517.75213746200018]
[null,null,"High consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G21*'Input|2015 tariffs'!$H$15/100","v":491.71913746200016},{"$f":"'Input|archetype demand'!H21*'Input|2015 tariffs'!$Q$15","v":0},517.75213746200018]
[null,null,"High consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2015 tariffs'!$G$15","v":26.033000000000001},{"$f":"'Input|archetype demand'!G22*'Input|2015 tariffs'!$H$15/100","v":491.71913746200016},{"$f":"'Input|archetype demand'!H22*'Input|2015 tariffs'!$Q$15","v":0},517.75213746200018]
[]
[null,null,2016,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Low Consumption, Low Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G14*'Input|2016 proposed tariffs'!$H$15/100","v":188.93413000000001},{"$f":"'Input|archetype demand'!H14*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H25:J25)","v":215.63513}]
[null,null,"Low Consumption, Medium Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G15*('Input|2016 proposed tariffs'!$H$15)/100","v":188.93413000000001},{"$f":"'Input|archetype demand'!H15*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H26:J26)","v":215.63513}]
[null,null,"Low consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G16*('Input|2016 proposed tariffs'!$H$15)/100","v":188.93413000000001},{"$f":"'Input|archetype demand'!H16*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H27:J27)","v":215.63513}]
[null,null,"Medium consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G17*('Input|2016 proposed tariffs'!$H$15)/100","v":319.41349547000004},{"$f":"'Input|archetype demand'!H17*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H28:J28)","v":346.11449547000007}]
[null,null,"Medium consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G18*('Input|2016 proposed tariffs'!$H$15)/100","v":319.41349547000004},{"$f":"'Input|archetype demand'!H18*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H29:J29)","v":346.11449547000007}]
[null,null,"Medium consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G19*('Input|2016 proposed tariffs'!$H$15)/100","v":319.41349547000004},{"$f":"'Input|archetype demand'!H19*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H30:J30)","v":346.11449547000007}]
[null,null,"High consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G20*('Input|2016 proposed tariffs'!$H$15)/100","v":504.11191349400013},{"$f":"'Input|archetype demand'!H20*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H31:J31)","v":530.8129134940001}]
[null,null,"High consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G21*('Input|2016 proposed tariffs'!$H$15)/100","v":504.11191349400013},{"$f":"'Input|archetype demand'!H21*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H32:J32)","v":530.8129134940001}]
[null,null,"High consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$15","v":26.701000000000001},{"$f":"'Input|archetype demand'!G22*('Input|2016 proposed tariffs'!$H$15)/100","v":504.11191349400013},{"$f":"'Input|archetype demand'!H22*'Input|2016 proposed tariffs'!$Q$15","v":0},{"$f":"SUM(H33:J33)","v":530.8129134940001}]
[]
[null,null,2017,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Low Consumption, Low Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G14*'Input|2017 indicative tariffs'!$H$15/100","v":193.71275000000003},{"$f":"'Input|archetype demand'!H14*'Input|2017 indicative tariffs'!$Q$15","v":0},{"$f":"SUM(H37:J37)","v":221.06975000000003}]
[null,null,"Low Consumption, Medium Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G15*'Input|2017 indicative tariffs'!$H$15/100","v":193.71275000000003},{"$f":"'Input|archetype demand'!H15*'Input|2017 indicative tariffs'!$Q$15","v":0},221.06975000000003]
[null,null,"Low consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G16*'Input|2017 indicative tariffs'!$H$15/100","v":193.71275000000003},{"$f":"'Input|archetype demand'!H16*'Input|2017 indicative tariffs'!$Q$15","v":0},221.06975000000003]
[null,null,"Medium consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G17*'Input|2017 indicative tariffs'!$H$15/100","v":327.49226725000005},{"$f":"'Input|archetype demand'!H17*'Input|2017 indicative tariffs'!$Q$15","v":0},354.84926725000003]
[null,null,"Medium consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G18*'Input|2017 indicative tariffs'!$H$15/100","v":327.49226725000005},{"$f":"'Input|archetype demand'!H18*'Input|2017 indicative tariffs'!$Q$15","v":0},354.84926725000003]
[null,null,"Medium consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G19*'Input|2017 indicative tariffs'!$H$15/100","v":327.49226725000005},{"$f":"'Input|archetype demand'!H19*'Input|2017 indicative tariffs'!$Q$15","v":0},354.84926725000003]
[null,null,"High consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G20*'Input|2017 indicative tariffs'!$H$15/100","v":516.86217345000023},{"$f":"'Input|archetype demand'!H20*'Input|2017 indicative tariffs'!$Q$15","v":0},544.2191734500002]
[null,null,"High consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G21*'Input|2017 indicative tariffs'!$H$15/100","v":516.86217345000023},{"$f":"'Input|archetype demand'!H21*'Input|2017 indicative tariffs'!$Q$15","v":0},544.2191734500002]
[null,null,"High consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$15","v":27.356999999999999},{"$f":"'Input|archetype demand'!G22*'Input|2017 indicative tariffs'!$H$15/100","v":516.86217345000023},{"$f":"'Input|archetype demand'!H22*'Input|2017 indicative tariffs'!$Q$15","v":0},544.2191734500002]
[]
[null,null,2018,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Low Consumption, Low Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G14*('Input|2018 indicative tariffs'!$H$15)/100","v":152.51390000000001},{"$f":"'Input|archetype demand'!H14*'Input|2018 indicative tariffs'!$Q$15","v":60.409440000000004},{"$f":"SUM(H49:J49)","v":234.80833999999999}]
[null,null,"Low Consumption, Medium Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G15*('Input|2018 indicative tariffs'!$H$15)/100","v":152.51390000000001},{"$f":"'Input|archetype demand'!H15*'Input|2018 indicative tariffs'!$Q$15","v":90.033299999999997},264.43219999999997]
[null,null,"Low consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G16*('Input|2018 indicative tariffs'!$H$15)/100","v":152.51390000000001},{"$f":"'Input|archetype demand'!H16*'Input|2018 indicative tariffs'!$Q$15","v":124.01360999999999},298.41251]
[null,null,"Medium consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G17*('Input|2018 indicative tariffs'!$H$15)/100","v":257.84117410000005},{"$f":"'Input|archetype demand'!H17*'Input|2018 indicative tariffs'!$Q$15","v":60.409440000000004},340.13561410000005]
[null,null,"Medium consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G18*('Input|2018 indicative tariffs'!$H$15)/100","v":257.84117410000005},{"$f":"'Input|archetype demand'!H18*'Input|2018 indicative tariffs'!$Q$15","v":90.033299999999997},369.75947410000003]
[null,null,"Medium consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G19*('Input|2018 indicative tariffs'!$H$15)/100","v":257.84117410000005},{"$f":"'Input|archetype demand'!H19*'Input|2018 indicative tariffs'!$Q$15","v":124.01360999999999},403.73978410000001]
[null,null,"High consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G20*('Input|2018 indicative tariffs'!$H$15)/100","v":406.93586682000006},{"$f":"'Input|archetype demand'!H20*'Input|2018 indicative tariffs'!$Q$15","v":60.409440000000004},489.23030682000007]
[null,null,"High consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G21*('Input|2018 indicative tariffs'!$H$15)/100","v":406.93586682000006},{"$f":"'Input|archetype demand'!H21*'Input|2018 indicative tariffs'!$Q$15","v":90.033299999999997},518.85416682000005]
[null,null,"High consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$15","v":21.885000000000002},{"$f":"'Input|archetype demand'!G22*('Input|2018 indicative tariffs'!$H$15)/100","v":406.93586682000006},{"$f":"'Input|archetype demand'!H22*'Input|2018 indicative tariffs'!$Q$15","v":124.01360999999999},552.83447682000008]
[]
[null,null,2019,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Low Consumption, Low Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G14*('Input|2019 indicative tariffs'!$H$15)/100","v":147.57897},{"$f":"'Input|archetype demand'!H14*'Input|2019 indicative tariffs'!$Q$15","v":74.320480000000003},{"$f":"SUM(H61:J61)","v":242.93045000000001}]
[null,null,"Low Consumption, Medium Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G15*('Input|2019 indicative tariffs'!$H$15)/100","v":147.57897},{"$f":"'Input|archetype demand'!H15*'Input|2019 indicative tariffs'!$Q$15","v":110.76610000000001},279.37607000000003]
[null,null,"Low consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G16*('Input|2019 indicative tariffs'!$H$15)/100","v":147.57897},{"$f":"'Input|archetype demand'!H16*'Input|2019 indicative tariffs'!$Q$15","v":152.57137},321.18133999999998]
[null,null,"Medium consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G17*('Input|2019 indicative tariffs'!$H$15)/100","v":249.49814343000003},{"$f":"'Input|archetype demand'!H17*'Input|2019 indicative tariffs'!$Q$15","v":74.320480000000003},344.84962343000007]
[null,null,"Medium consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G18*('Input|2019 indicative tariffs'!$H$15)/100","v":249.49814343000003},{"$f":"'Input|archetype demand'!H18*'Input|2019 indicative tariffs'!$Q$15","v":110.76610000000001},381.29524343000003]
[null,null,"Medium consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G19*('Input|2019 indicative tariffs'!$H$15)/100","v":249.49814343000003},{"$f":"'Input|archetype demand'!H19*'Input|2019 indicative tariffs'!$Q$15","v":152.57137},423.10051343000003]
[null,null,"High consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G20*('Input|2019 indicative tariffs'!$H$15)/100","v":393.76854228600007},{"$f":"'Input|archetype demand'!H20*'Input|2019 indicative tariffs'!$Q$15","v":74.320480000000003},489.12002228600011]
[null,null,"High consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G21*('Input|2019 indicative tariffs'!$H$15)/100","v":393.76854228600007},{"$f":"'Input|archetype demand'!H21*'Input|2019 indicative tariffs'!$Q$15","v":110.76610000000001},525.56564228600007]
[null,null,"High consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$15","v":21.030999999999999},{"$f":"'Input|archetype demand'!G22*('Input|2019 indicative tariffs'!$H$15)/100","v":393.76854228600007},{"$f":"'Input|archetype demand'!H22*'Input|2019 indicative tariffs'!$Q$15","v":152.57137},567.37091228600002]
[]
[null,null,2020,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Low Consumption, Low Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G14*'Input|2020 indicative tariffs'!$H$15/100","v":142.26443},{"$f":"'Input|archetype demand'!H14*'Input|2020 indicative tariffs'!$Q$15","v":88.895040000000009},{"$f":"SUM(H73:J73)","v":251.34947}]
[null,null,"Low Consumption, Medium Demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G15*'Input|2020 indicative tariffs'!$H$15/100","v":142.26443},{"$f":"'Input|archetype demand'!H15*'Input|2020 indicative tariffs'!$Q$15","v":132.48779999999999},294.94223]
[null,null,"Low consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G16*'Input|2020 indicative tariffs'!$H$15/100","v":142.26443},{"$f":"'Input|archetype demand'!H16*'Input|2020 indicative tariffs'!$Q$15","v":182.49125999999998},344.94569000000001]
[null,null,"Medium consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G17*'Input|2020 indicative tariffs'!$H$15/100","v":240.51334117000005},{"$f":"'Input|archetype demand'!H17*'Input|2020 indicative tariffs'!$Q$15","v":88.895040000000009},349.59838117000004]
[null,null,"Medium consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G18*'Input|2020 indicative tariffs'!$H$15/100","v":240.51334117000005},{"$f":"'Input|archetype demand'!H18*'Input|2020 indicative tariffs'!$Q$15","v":132.48779999999999},393.19114117000004]
[null,null,"Medium consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G19*'Input|2020 indicative tariffs'!$H$15/100","v":240.51334117000005},{"$f":"'Input|archetype demand'!H19*'Input|2020 indicative tariffs'!$Q$15","v":182.49125999999998},443.19460117000006]
[null,null,"High consumption, Low demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G20*'Input|2020 indicative tariffs'!$H$15/100","v":379.58834663400012},{"$f":"'Input|archetype demand'!H20*'Input|2020 indicative tariffs'!$Q$15","v":88.895040000000009},488.67338663400011]
[null,null,"High consumption, Medium demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G21*'Input|2020 indicative tariffs'!$H$15/100","v":379.58834663400012},{"$f":"'Input|archetype demand'!H21*'Input|2020 indicative tariffs'!$Q$15","v":132.48779999999999},532.26614663400005]
[null,null,"High consumption, High demand","JEN","$ per annum","$Nominal","Residential - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$15","v":20.190000000000001},{"$f":"'Input|archetype demand'!G22*'Input|2020 indicative tariffs'!$H$15/100","v":379.58834663400012},{"$f":"'Input|archetype demand'!H22*'Input|2020 indicative tariffs'!$Q$15","v":182.49125999999998},582.26960663400007]
[]
[null,null,"Small Business - General purpose"]
[null,null,2015,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Small","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2015 tariffs'!$G$22","v":68.075999999999993},{"$f":"'Input|archetype demand'!G25*'Input|2015 tariffs'!$I$22/100","v":563.82000000000005},{"$f":"'Input|archetype demand'!$H$25*'Input|2015 tariffs'!$Q$22","v":0},{"$f":"SUM(H86:J86)","v":631.89600000000007}]
[null,null,"Medium ","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2015 tariffs'!$G$22","v":68.075999999999993},{"$f":"'Input|archetype demand'!G26*'Input|2015 tariffs'!$I$22/100","v":1033.67},{"$f":"'Input|archetype demand'!$H$26*'Input|2015 tariffs'!$Q$22","v":0},{"$f":"SUM(H87:J87)","v":1101.7460000000001}]
[null,null,"Large","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2015 tariffs'!$G$22","v":68.075999999999993},{"$f":"'Input|archetype demand'!G27*'Input|2015 tariffs'!$I$22/100","v":1973.37},{"$f":"'Input|archetype demand'!$H$26*'Input|2015 tariffs'!$Q$22","v":0},2041.4459999999999]
[]
[null,null,2016,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Small","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$22","v":70.503},{"$f":"'Input|archetype demand'!G25*'Input|2016 proposed tariffs'!I22/100","v":578.7600000000001},{"$f":"'Input|archetype demand'!H25*'Input|2016 proposed tariffs'!$Q$22","v":0},{"$f":"SUM(H92:J92)","v":649.26300000000015}]
[null,null,"Medium ","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$22","v":70.503},{"$f":"'Input|archetype demand'!G26*'Input|2016 proposed tariffs'!I23/100","v":1252.68},{"$f":"'Input|archetype demand'!H26*'Input|2016 proposed tariffs'!$Q$22","v":0},{"$f":"SUM(H93:J93)","v":1323.183}]
[null,null,"Large","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2016 proposed tariffs'!$G$22","v":70.503},{"$f":"'Input|archetype demand'!G27*'Input|2016 proposed tariffs'!I24/100","v":1473.15},{"$f":"'Input|archetype demand'!H27*'Input|2016 proposed tariffs'!$Q$22","v":0},{"$f":"SUM(H94:J94)","v":1543.653}]
[]
[null,null,2017,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Small","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$22","v":72.396000000000001},{"$f":"'Input|archetype demand'!G25*'Input|2017 indicative tariffs'!$I$22/100","v":594.29999999999995},{"$f":"'Input|archetype demand'!H25*'Input|2017 indicative tariffs'!$Q$22","v":0},{"$f":"SUM(H98:J98)","v":666.69599999999991}]
[null,null,"Medium ","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$22","v":72.396000000000001},{"$f":"'Input|archetype demand'!G26*'Input|2017 indicative tariffs'!$I$22/100","v":1089.55},{"$f":"'Input|archetype demand'!H26*'Input|2017 indicative tariffs'!$Q$22","v":0},{"$f":"SUM(H99:J99)","v":1161.9459999999999}]
[null,null,"Large","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2017 indicative tariffs'!$G$22","v":72.396000000000001},{"$f":"'Input|archetype demand'!G27*'Input|2017 indicative tariffs'!$I$22/100","v":2080.0500000000002},{"$f":"'Input|archetype demand'!H27*'Input|2017 indicative tariffs'!$Q$22","v":0},{"$f":"SUM(H100:J100)","v":2152.4460000000004}]
[]
[null,null,2018,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Small","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$22","v":71.849999999999994},{"$f":"'Input|archetype demand'!G25*'Input|2018 indicative tariffs'!$I$22/100","v":238.86},{"$f":"'Input|archetype demand'!H25*'Input|2018 indicative tariffs'!$Q$22","v":149.792},{"$f":"SUM(H104:J104)","v":460.50200000000007}]
[null,null,"Medium ","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$22","v":71.849999999999994},{"$f":"'Input|archetype demand'!G26*'Input|2018 indicative tariffs'!$I$22/100","v":437.91},{"$f":"'Input|archetype demand'!H26*'Input|2018 indicative tariffs'!$Q$22","v":374.48},{"$f":"SUM(H105:J105)","v":884.24}]
[null,null,"Large","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2018 indicative tariffs'!$G$22","v":71.849999999999994},{"$f":"'Input|archetype demand'!G27*'Input|2018 indicative tariffs'!$I$22/100","v":836.01},{"$f":"'Input|archetype demand'!H27*'Input|2018 indicative tariffs'!$Q$22","v":936.2},{"$f":"SUM(H106:J106)","v":1844.06}]
[]
[null,null,2019,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Small","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$22","v":67.897999999999996},{"$f":"'Input|archetype demand'!G25*'Input|2019 indicative tariffs'!$I$22/100","v":217.38},{"$f":"'Input|archetype demand'!H25*'Input|2019 indicative tariffs'!$Q$22","v":184.28800000000001},{"$f":"SUM(H110:J110)","v":469.56600000000003}]
[null,null,"Medium ","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$22","v":67.897999999999996},{"$f":"'Input|archetype demand'!G26*'Input|2019 indicative tariffs'!$I$22/100","v":398.53},{"$f":"'Input|archetype demand'!H26*'Input|2019 indicative tariffs'!$Q$22","v":460.72},{"$f":"SUM(H111:J111)","v":927.14800000000002}]
[null,null,"Large","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2019 indicative tariffs'!$G$22","v":67.897999999999996},{"$f":"'Input|archetype demand'!G27*'Input|2019 indicative tariffs'!$I$22/100","v":760.83},{"$f":"'Input|archetype demand'!H27*'Input|2019 indicative tariffs'!$Q$22","v":1151.8000000000002},{"$f":"SUM(H112:J112)","v":1980.5280000000002}]
[]
[null,null,2020,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Archetype"]
[null,null,"Small","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$22","v":62.988999999999997},{"$f":"'Input|archetype demand'!G25*'Input|2020 indicative tariffs'!$I$22/100","v":196.5},{"$f":"'Input|archetype demand'!H25*'Input|2020 indicative tariffs'!$Q$22","v":220.43199999999999},{"$f":"SUM(H116:J116)","v":479.92099999999994}]
[null,null,"Medium ","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$22","v":62.988999999999997},{"$f":"'Input|archetype demand'!G26*'Input|2020 indicative tariffs'!$I$22/100","v":360.25},{"$f":"'Input|archetype demand'!H26*'Input|2020 indicative tariffs'!$Q$22","v":551.07999999999993},{"$f":"SUM(H117:J117)","v":974.31899999999996}]
[null,null,"Large","JEN","$ per annum","$Nominal","Small business - General purpose",{"$f":"'Input|2020 indicative tariffs'!$G$22","v":62.988999999999997},{"$f":"'Input|archetype demand'!G27*'Input|2020 indicative tariffs'!$I$22/100","v":687.75},{"$f":"'Input|archetype demand'!H27*'Input|2020 indicative tariffs'!$Q$22","v":1377.6999999999998},{"$f":"SUM(H118:J118)","v":2128.4389999999999}]
[]
[null,null,"Large Business"]
[null,null,2015,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Low Voltage ","JEN","$ per annum","$Nominal","A300 Large business LV 0.4 - 0.8 GWh",{"$f":"'Input|2015 tariffs'!G30","v":1957.64},{"$f":"'Input|archetype demand'!$I$30*'Input|2015 tariffs'!$I$30/100 +'Input|archetype demand'!$J$30*'Input|2015 tariffs'!$J$30/100","v":5451.1103999999996},{"$f":"'Input|archetype demand'!$H$30*'Input|2015 tariffs'!Q30","v":18446.723099999999},{"$f":"SUM(H122:J122)","v":25855.4735}]
[null,null,"High Voltage ","JEN","$ per annum","$Nominal","A400 Large Business HV",{"$f":"'Input|2015 tariffs'!G41","v":3425.701},{"$f":"'Input|archetype demand'!$I$33*'Input|2015 tariffs'!I41/100 + 'Input|archetype demand'!$J$33*'Input|2015 tariffs'!J41/100","v":34446.715000000011},{"$f":"'Input|archetype demand'!$H$33*'Input|2015 tariffs'!Q41","v":181938.77910000001},{"$f":"SUM(H123:J123)","v":219811.19510000001}]
[]
[null,null,2016,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Low Voltage ","JEN","$ per annum","$Nominal","A300 Large business LV 0.4 - 0.8 GWh",{"$f":"'Input|2016 proposed tariffs'!G30","v":2009.713},{"$f":"'Input|archetype demand'!$I$30*'Input|2016 proposed tariffs'!$I$30/100 +'Input|archetype demand'!$J$30*'Input|2016 proposed tariffs'!$J$30/100","v":5770.6815999999999},{"$f":"'Input|archetype demand'!$H$30*'Input|2016 proposed tariffs'!Q30","v":18723.42225},{"$f":"SUM(H126:J126)","v":26503.816849999999}]
[null,null,"High Voltage ","JEN","$ per annum","$Nominal","A400 Large Business HV",{"$f":"'Input|2016 proposed tariffs'!G41","v":3529.8420000000001},{"$f":"'Input|archetype demand'!$I$33*'Input|2016 proposed tariffs'!I41/100 + 'Input|archetype demand'!$J$33*'Input|2016 proposed tariffs'!J41/100","v":36572.739000000001},{"$f":"'Input|archetype demand'!$H$33*'Input|2016 proposed tariffs'!Q41","v":185123.39129999999},{"$f":"SUM(H127:J127)","v":225225.97229999999}]
[]
[null,null,2017,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Low Voltage ","JEN","$ per annum","$Nominal","A300 Large business LV 0.4 - 0.8 GWh",{"$f":"'Input|2017 indicative tariffs'!G30","v":2060.2570000000001},{"$f":"'Input|archetype demand'!$I$30*'Input|2017 indicative tariffs'!$I$30/100 +'Input|archetype demand'!$J$30*'Input|2017 indicative tariffs'!$J$30/100","v":6102.1760000000004},{"$f":"'Input|archetype demand'!L$30*'Input|2017 indicative tariffs'!R$30","v":18931.574999999997},{"$f":"SUM(H130:J130)","v":27094.007999999998}]
[null,null,"High Voltage ","JEN","$ per annum","$Nominal","A400 Large Business HV",{"$f":"'Input|2017 indicative tariffs'!G41","v":3618.0880000000002},{"$f":"'Input|archetype demand'!$I$33*'Input|2017 indicative tariffs'!$I$41/100 + 'Input|archetype demand'!$J$33*'Input|2017 indicative tariffs'!$J$41/100","v":38808.032000000007},{"$f":"'Input|archetype demand'!L$33*'Input|2017 indicative tariffs'!R$41","v":189381.54},{"$f":"SUM(H131:J131)","v":231807.66000000003}]
[]
[null,null,2018,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Low Voltage ","JEN","$ per annum","$Nominal","A300 Large business LV 0.4 - 0.8 GWh",{"$f":"'Input|2018 indicative tariffs'!G30","v":2060.2570000000001},{"$f":"'Input|archetype demand'!$I$30*'Input|2018 indicative tariffs'!$I$30/100 +'Input|archetype demand'!$J$30*'Input|2018 indicative tariffs'!$J$30/100","v":6269.0272000000004},{"$f":"'Input|archetype demand'!L$30*'Input|2018 indicative tariffs'!R$30","v":18931.574999999997},{"$f":"SUM(H134:J134)","v":27260.859199999999}]
[null,null,"High Voltage ","JEN","$ per annum","$Nominal","A400 Large Business HV",{"$f":"'Input|2018 indicative tariffs'!G41","v":3618.0880000000002},{"$f":"'Input|archetype demand'!$I$33*'Input|2018 indicative tariffs'!$I$41/100 + 'Input|archetype demand'!$J$33*'Input|2018 indicative tariffs'!$J$41/100","v":40139.495000000003},{"$f":"'Input|archetype demand'!L$33*'Input|2018 indicative tariffs'!R$41","v":189381.54},{"$f":"SUM(H135:J135)","v":233139.12300000002}]
[]
[null,null,2019,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Low Voltage ","JEN","$ per annum","$Nominal","A300 Large business LV 0.4 - 0.8 GWh",{"$f":"'Input|2019 indicative tariffs'!G30","v":2112.7939999999999},{"$f":"'Input|archetype demand'!$I$30*'Input|2019 indicative tariffs'!$I$30/100 +'Input|archetype demand'!$J$30*'Input|2019 indicative tariffs'!$J$30/100","v":6657.9295999999995},{"$f":"'Input|archetype demand'!L$30*'Input|2019 indicative tariffs'!R$30","v":19177.664999999997},{"$f":"SUM(H138:J138)","v":27948.388599999998}]
[null,null,"High Voltage ","JEN","$ per annum","$Nominal","A400 Large Business HV",{"$f":"'Input|2019 indicative tariffs'!G41","v":3711.7959999999998},{"$f":"'Input|archetype demand'!$I$33*'Input|2019 indicative tariffs'!$I$41/100 + 'Input|archetype demand'!$J$33*'Input|2019 indicative tariffs'!$J$41/100","v":42598.722000000002},{"$f":"'Input|archetype demand'!L$33*'Input|2019 indicative tariffs'!R$41","v":192600.87299999999},{"$f":"SUM(H139:J139)","v":238911.391}]
[]
[null,null,2020,null,null,null,null,"Fixed","Consumption","Demand","Total"]
[null,null,"Low Voltage ","JEN","$ per annum","$Nominal","A300 Large business LV 0.4 - 0.8 GWh",{"$f":"'Input|2020 indicative tariffs'!G30","v":2165.614},{"$f":"'Input|archetype demand'!$I$30*'Input|2020 indicative tariffs'!$I$30/100 +'Input|archetype demand'!$J$30*'Input|2020 indicative tariffs'!$J$30/100","v":7028.4319999999998},{"$f":"'Input|archetype demand'!L$30*'Input|2020 indicative tariffs'!R$30","v":19463.34},{"$f":"SUM(H142:J142)","v":28657.385999999999}]
[null,null,"High Voltage ","JEN","$ per annum","$Nominal","A400 Large Business HV",{"$f":"'Input|2020 indicative tariffs'!G41","v":3789.373},{"$f":"'Input|archetype demand'!$I$33*'Input|2020 indicative tariffs'!$I$41/100 + 'Input|archetype demand'!$J$33*'Input|2020 indicative tariffs'!$J$41/100","v":45099.768000000011},{"$f":"'Input|archetype demand'!L$33*'Input|2020 indicative tariffs'!R$41","v":195942.75},{"$f":"SUM(H143:J143)","v":244831.891}]

{"sheet":"Calc|Customer outcomes","index":9,"n_rows":158,"n_cols":15,"rows_kept":158,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"},{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"},{"$f":"Index!$C$1","v":"JEN tariffs and customer outcomes"}]
[null,null,{"$f":"Index!$C$28","v":"Calc|Customer tariff"},{"$f":"Index!$C$27","v":"Input|archetype demand"},{"$f":"Index!$C$27","v":"Input|archetype demand"}]
[]
[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,"Customer outcomes"]
[]
[null,null,"Customer Outcomes","Source","Unit","Basis",null,2015,2016,2017,2018,2019,2020,"Total"]
[]
[null,null,"Residential - General purpose"]
[]
[null,null,"Low Consumption, Low Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K13","v":210.32249000000002},{"$f":"'Calc|Customer tariff'!K25","v":215.63513},{"$f":"'Calc|Customer tariff'!K37","v":221.06975000000003},{"$f":"'Calc|Customer tariff'!K49","v":234.80833999999999},{"$f":"'Calc|Customer tariff'!K61","v":242.93045000000001},{"$f":"'Calc|Customer tariff'!K73","v":251.34947}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H16:H17)","v":436.64249000000001},309.8538356000879,317.66648057092289,333.84311549985313,344.46480525548361,355.44649294081569]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I19-H19","v":-126.7886543999121},{"$f":"J19-I19","v":7.812644970834981},{"$f":"K19-J19","v":16.176634928930241},{"$f":"L19-K19","v":10.621689755630484},{"$f":"M19-L19","v":10.981687685332076},{"$f":"SUM(I21:M21)","v":-81.195997059184322}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I19/H19-1","v":-0.29037177394236668},{"$f":"J19/I19-1","v":2.5213968888603278E-2},{"$f":"K19/J19-1","v":5.092332971315372E-2},{"$f":"L19/K19-1","v":3.1816410950176177E-2},{"$f":"M19/L19-1","v":3.1880434569177885E-2},{"$f":"M19/H19-1","v":-0.18595532711254081}]
[]
[null,null,"Low Consumption, Medium Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K14","v":210.32249000000002},{"$f":"'Calc|Customer tariff'!K26","v":215.63513},{"$f":"'Calc|Customer tariff'!K38","v":221.06975000000003},{"$f":"'Calc|Customer tariff'!K50","v":264.43219999999997},{"$f":"'Calc|Customer tariff'!K62","v":279.37607000000003},{"$f":"'Calc|Customer tariff'!K74","v":294.94223}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H26:H27)","v":436.64249000000001},309.8538356000879,317.66648057092289,363.46697549985311,380.91042525548357,{"$f":"SUM(M26:M27)","v":399.03925294081569}]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I29-H29","v":-126.7886543999121},{"$f":"J29-I29","v":7.812644970834981},{"$f":"K29-J29","v":45.80049492893022},{"$f":"L29-K29","v":17.443449755630468},{"$f":"M29-L29","v":18.128827685332112},{"$f":"SUM(I31:M31)","v":-37.603237059184323}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I29/H29-1","v":-0.29037177394236668},{"$f":"J29/I29-1","v":2.5213968888603278E-2},{"$f":"K29/J29-1","v":0.14417792789033257},{"$f":"L29/K29-1","v":4.7991842261987161E-2},{"$f":"M29/L29-1","v":4.7593414313018112E-2},{"$f":"M29/H29-1","v":-8.6119051444545236E-2}]
[]
[null,null,"Low Consumption, High Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K15","v":210.32249000000002},{"$f":"'Calc|Customer tariff'!K27","v":215.63513},{"$f":"'Calc|Customer tariff'!K39","v":221.06975000000003},{"$f":"'Calc|Customer tariff'!K51","v":298.41251},{"$f":"'Calc|Customer tariff'!K63","v":321.18133999999998},{"$f":"'Calc|Customer tariff'!K75","v":344.94569000000001}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H36:H37)","v":436.64249000000001},309.8538356000879,317.66648057092289,397.44728549985314,422.71569525548352,449.0427129408157]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I39-H39","v":-126.7886543999121},{"$f":"J39-I39","v":7.812644970834981},{"$f":"K39-J39","v":79.780804928930252},{"$f":"L39-K39","v":25.268409755630387},{"$f":"M39-L39","v":26.32701768533218},{"$f":"SUM(I41:M41)","v":12.400222940815695}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I39/H39-1","v":-0.29037177394236668},{"$f":"J39/I39-1","v":2.5213968888603278E-2},{"$f":"K39/J39-1","v":0.25114643756415544},{"$f":"L39/K39-1","v":6.3576757666998107E-2},{"$f":"M39/L39-1","v":6.2280672283579364E-2},{"$f":"M39/H39-1","v":2.8399029468743953E-2}]
[]
[null,null,"Medium Consumption, Low Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K16","v":337.59423131000005},{"$f":"'Calc|Customer tariff'!K28","v":346.11449547000007},{"$f":"'Calc|Customer tariff'!K40","v":354.84926725000003},{"$f":"'Calc|Customer tariff'!K52","v":340.13561410000005},{"$f":"'Calc|Customer tariff'!K64","v":344.84962343000007},{"$f":"'Calc|Customer tariff'!K76","v":349.59838117000004}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H46:H47)","v":563.9142313100001},440.33320107008797,451.44599782092286,439.17038959985319,446.38397868548361,453.69540411081573]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I49-H49","v":-123.58103023991214},{"$f":"J49-I49","v":11.112796750834889},{"$f":"K49-J49","v":-12.27560822106966},{"$f":"L49-K49","v":7.2135890856304172},{"$f":"M49-L49","v":7.3114254253321178},{"$f":"SUM(I51:M51)","v":-110.21882719918437}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I49/H49-1","v":-0.21914862824587245},{"$f":"J49/I49-1","v":2.5237244713387064E-2},{"$f":"K49/J49-1","v":-2.7191753344414593E-2},{"$f":"L49/K49-1","v":1.6425490553229283E-2},{"$f":"M49/L49-1","v":1.6379229036989296E-2},{"$f":"M49/H49-1","v":-0.19545317546453955}]
[]
[null,null,"Medium Consumption, Medium Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K17","v":337.59423131000005},{"$f":"'Calc|Customer tariff'!K29","v":346.11449547000007},{"$f":"'Calc|Customer tariff'!K41","v":354.84926725000003},{"$f":"'Calc|Customer tariff'!K53","v":369.75947410000003},{"$f":"'Calc|Customer tariff'!K65","v":381.29524343000003},{"$f":"'Calc|Customer tariff'!K77","v":393.19114117000004}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H56:H57)","v":563.9142313100001},440.33320107008797,451.44599782092286,468.79424959985317,482.82959868548357,497.28816411081573]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I59-H59","v":-123.58103023991214},{"$f":"J56-I56","v":8.73477177999996},{"$f":"K56-J56","v":14.910206850000009},{"$f":"L56-K56","v":11.535769329999994},{"$f":"M56-L56","v":11.895897740000009},{"$f":"SUM(I61:M61)","v":-76.504384539912166}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I59/H59-1","v":-0.21914862824587245},{"$f":"J59/I59-1","v":2.5237244713387064E-2},{"$f":"K59/J59-1","v":3.8428188227757731E-2},{"$f":"L59/K59-1","v":2.9939251809531608E-2},{"$f":"M59/L59-1","v":2.9945482763890086E-2},{"$f":"M59/H59-1","v":-0.1181492920375653}]
[]
[null,null,"Medium Consumption, High Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K18","v":337.59423131000005},{"$f":"'Calc|Customer tariff'!K30","v":346.11449547000007},{"$f":"'Calc|Customer tariff'!K42","v":354.84926725000003},{"$f":"'Calc|Customer tariff'!K54","v":403.73978410000001},{"$f":"'Calc|Customer tariff'!K66","v":423.10051343000003},{"$f":"'Calc|Customer tariff'!K78","v":443.19460117000006}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H66:H67)","v":563.9142313100001},440.33320107008797,451.44599782092286,502.77455959985315,524.63486868548364,547.29162411081575]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I69-H69","v":-123.58103023991214},{"$f":"J69-I69","v":11.112796750834889},{"$f":"K69-J69","v":51.328561778930293},{"$f":"L69-K69","v":21.86030908563049},{"$f":"M69-L69","v":22.656755425332108},{"$f":"SUM(I71:M71)","v":-16.622607199184358}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I69/H69-1","v":-0.21914862824587245},{"$f":"J69/I69-1","v":2.5237244713387064E-2},{"$f":"K69/J69-1","v":0.11369812120760248},{"$f":"L69/K69-1","v":4.3479346097043292E-2},{"$f":"M69/L69-1","v":4.3185759806816604E-2},{"$f":"M69/H69-1","v":-2.9477190459565539E-2}]
[]
[null,null,"High Consumption, Low Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K19","v":517.75213746200018},{"$f":"'Calc|Customer tariff'!K31","v":530.8129134940001},{"$f":"'Calc|Customer tariff'!K43","v":544.2191734500002},{"$f":"'Calc|Customer tariff'!K55","v":489.23030682000007},{"$f":"'Calc|Customer tariff'!K67","v":489.12002228600011},{"$f":"'Calc|Customer tariff'!K79","v":488.67338663400011}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H76:H77)","v":744.07213746200023},625.031619094088,640.81590402092297,588.26508231985315,590.65437754148365,592.77040957481586]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I79-H79","v":-119.04051836791223},{"$f":"J79-I79","v":15.784284926834971},{"$f":"K79-J79","v":-52.550821701069822},{"$f":"L79-K79","v":2.3892952216305048},{"$f":"M79-L79","v":2.1160320333322034},{"$f":"SUM(I81:M81)","v":-151.30172788718437}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I79/H79-1","v":-0.15998518473484924},{"$f":"J79/I79-1","v":2.5253578290507006E-2},{"$f":"K79/J79-1","v":-8.2006113411557946E-2},{"$f":"L79/K79-1","v":4.061596197768802E-3},{"$f":"M79/L79-1","v":3.5825215452391923E-3},{"$f":"M79/H79-1","v":-0.20334282157543004}]
[]
[null,null,"High Consumption, Medium Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K20","v":517.75213746200018},{"$f":"'Calc|Customer tariff'!K32","v":530.8129134940001},{"$f":"'Calc|Customer tariff'!K44","v":544.2191734500002},{"$f":"'Calc|Customer tariff'!K56","v":518.85416682000005},{"$f":"'Calc|Customer tariff'!K68","v":525.56564228600007},{"$f":"'Calc|Customer tariff'!K80","v":532.26614663400005}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H86:H87)","v":744.07213746200023},625.031619094088,{"$f":"SUM(J86:J87)","v":640.81590402092297},{"$f":"SUM(K86:K87)","v":617.88894231985319},{"$f":"SUM(L86:L87)","v":627.09999754148362},636.36316957481574]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I89-H89","v":-119.04051836791223},{"$f":"J89-I89","v":15.784284926834971},{"$f":"K89-J89","v":-22.926961701069786},{"$f":"L89-K89","v":9.2110552216304313},{"$f":"M89-L89","v":9.2631720333321255},{"$f":"SUM(I91:M91)","v":-107.70896788718449}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I89/H89-1","v":-0.15998518473484924},{"$f":"J89/I89-1","v":2.5253578290507006E-2},{"$f":"K89/J89-1","v":-3.5777766371293485E-2},{"$f":"L89/K89-1","v":1.4907299015657571E-2},{"$f":"M89/L89-1","v":1.4771443262076245E-2},{"$f":"M89/H89-1","v":-0.14475608272952589}]
[]
[null,null,"High Consumption, High Demand"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K21","v":517.75213746200018},{"$f":"'Calc|Customer tariff'!K33","v":530.8129134940001},{"$f":"'Calc|Customer tariff'!K45","v":544.2191734500002},{"$f":"'Calc|Customer tariff'!K57","v":552.83447682000008},{"$f":"'Calc|Customer tariff'!K69","v":567.37091228600002},{"$f":"'Calc|Customer tariff'!K81","v":582.26960663400007}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H96:H97)","v":744.07213746200023},625.031619094088,640.81590402092297,651.86925231985322,668.90526754148357,686.36662957481576]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I99-H99","v":-119.04051836791223},{"$f":"J99-I99","v":15.784284926834971},{"$f":"K99-J99","v":11.053348298930246},{"$f":"L99-K99","v":17.03601522163035},{"$f":"M99-L99","v":17.461362033332193},{"$f":"SUM(I101:M101)","v":-57.705507887184467}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I99/H99-1","v":-0.15998518473484924},{"$f":"J99/I99-1","v":2.5253578290507006E-2},{"$f":"K99/J99-1","v":1.7248866998421652E-2},{"$f":"L99/K99-1","v":2.6134098457632593E-2},{"$f":"M99/L99-1","v":2.6104387094319392E-2},{"$f":"M99/H99-1","v":-7.7553646994518055E-2}]
[]
[null,null,"Small business - General purpose"]
[]
[null,null,"Small Business (small)"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K86","v":631.89600000000007},{"$f":"'Calc|Customer tariff'!K92","v":649.26300000000015},{"$f":"'Calc|Customer tariff'!K98","v":666.69599999999991},{"$f":"'Calc|Customer tariff'!K104","v":460.50200000000007},{"$f":"'Calc|Customer tariff'!K110","v":469.56600000000003},{"$f":"'Calc|Customer tariff'!K116","v":479.92099999999994}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H108:H109)","v":858.21600000000012},{"$f":"SUM(I108:I109)","v":743.48170560008805},{"$f":"SUM(J108:J109)","v":763.29273057092269},{"$f":"SUM(K108:K109)","v":559.53677549985321},{"$f":"SUM(L108:L109)","v":571.10035525548358},{"$f":"SUM(M108:M109)","v":584.01802294081563}]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I111-H111","v":-114.73429439991207},{"$f":"J111-I111","v":19.811024970834637},{"$f":"K111-J111","v":-203.75595507106948},{"$f":"L111-K111","v":11.563579755630371},12.917667685332049,{"$f":"SUM(I113:M113)","v":-274.1979770591845}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I111/H111-1","v":-0.13368929779905303},{"$f":"J111/I111-1","v":2.6646284396257602E-2},{"$f":"K111/J111-1","v":-0.2669433978739264},{"$f":"L111/K111-1","v":2.0666344487009436E-2},2.2618910260620018E-2,{"$f":"M111/H111-1","v":-0.31949762887103528}]
[]
[null,null,"Small Business (medium)"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K87","v":1101.7460000000001},{"$f":"'Calc|Customer tariff'!K93","v":1323.183},{"$f":"'Calc|Customer tariff'!K99","v":1161.9459999999999},{"$f":"'Calc|Customer tariff'!K105","v":884.24},{"$f":"'Calc|Customer tariff'!K111","v":927.14800000000002},{"$f":"'Calc|Customer tariff'!K117","v":974.31899999999996}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H118:H119)","v":1328.066},{"$f":"SUM(I118:I119)","v":1417.4017056000878},{"$f":"SUM(J118:J119)","v":1258.5427305709227},{"$f":"SUM(K118:K119)","v":983.27477549985315},{"$f":"SUM(L118:L119)","v":1028.6823552554836},{"$f":"SUM(M118:M119)","v":1078.4160229408158}]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I121-H121","v":89.335705600087749},{"$f":"J121-I121","v":-158.85897502916509},{"$f":"K121-J121","v":-275.26795507106954},{"$f":"L121-K121","v":45.407579755630422},{"$f":"M121-L121","v":49.733667685332193},{"$f":"SUM(I123:M123)","v":-249.64997705918427}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I121/H121-1","v":6.7267519535992859E-2},{"$f":"J121/I121-1","v":-0.1120775955055795},{"$f":"K121/J121-1","v":-0.21871959400710816},4.6179949783159202E-2,4.8346962919355585E-2,{"$f":"M121/H121-1","v":-0.1879800981722175}]
[]
[null,null,"Small Business (large)"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K88","v":2041.4459999999999},{"$f":"'Calc|Customer tariff'!K94","v":1543.653},{"$f":"'Calc|Customer tariff'!K100","v":2152.4460000000004},{"$f":"'Calc|Customer tariff'!K106","v":1844.06},{"$f":"'Calc|Customer tariff'!K112","v":1980.5280000000002},{"$f":"'Calc|Customer tariff'!K118","v":2128.4389999999999}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Input|2015 tariffs'!F48","v":226.32},{"$f":"'Input|2016 proposed tariffs'!F48","v":94.218705600087873},{"$f":"'Input|2017 indicative tariffs'!F48","v":96.59673057092283},{"$f":"'Input|2018 indicative tariffs'!F48","v":99.034775499853126},{"$f":"'Input|2019 indicative tariffs'!F48","v":101.53435525548358},{"$f":"'Input|2020 indicative tariffs'!F48","v":104.09702294081571}]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H128:H129)","v":2267.7660000000001},{"$f":"SUM(I128:I129)","v":1637.8717056000878},{"$f":"SUM(J128:J129)","v":2249.0427305709231},{"$f":"SUM(K128:K129)","v":1943.0947754998531},{"$f":"SUM(L128:L129)","v":2082.0623552554839},{"$f":"SUM(M128:M129)","v":2232.5360229408157}]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I131-H131","v":-629.89429439991227},{"$f":"J131-I131","v":611.17102497083533},{"$f":"K131-J131","v":-305.94795507107006},{"$f":"L131-K131","v":138.96757975563082},{"$f":"M131-L131","v":150.47366768533175},{"$f":"SUM(I133:M133)","v":-35.229977059184421}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I131/H131-1","v":-0.27775982813037692},{"$f":"J131/I131-1","v":0.37314951035613197},-0.13603474532180393,7.1518683240698877E-2,7.2271451095357486E-2,{"$f":"M131/H131-1","v":-1.5535102413205104E-2}]
[]
[null,null,"Large business - LV"]
[]
[null,null,"Large Business LV (A300 tariff LV 0.4 - 0.8 GWh)"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K122","v":25855.4735},{"$f":"'Calc|Customer tariff'!K126","v":26503.816849999999},{"$f":"'Calc|Customer tariff'!K130","v":27094.007999999998},{"$f":"'Calc|Customer tariff'!K134","v":27260.859199999999},{"$f":"'Calc|Customer tariff'!K138","v":27948.388599999998},{"$f":"'Calc|Customer tariff'!K142","v":28657.385999999999}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,null,null,null,null,null,null,null,"Note that large business customers' metering services are contestable and are therefore excluded from this analysis"]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H140:H141)","v":25855.4735},{"$f":"SUM(I140:I141)","v":26503.816849999999},{"$f":"SUM(J140:J141)","v":27094.007999999998},{"$f":"SUM(K140:K141)","v":27260.859199999999},{"$f":"SUM(L140:L141)","v":27948.388599999998},{"$f":"SUM(M140:M141)","v":28657.385999999999}]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I143-H143","v":648.34334999999919},{"$f":"J143-I143","v":590.19114999999874},{"$f":"K143-J143","v":166.85120000000097},{"$f":"L143-K143","v":687.52939999999944},{"$f":"M143-L143","v":708.9974000000002},{"$f":"SUM(I145:M145)","v":2801.9124999999985}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I143/H143-1","v":2.5075671114667353E-2},{"$f":"J143/I143-1","v":2.2268156822099261E-2},{"$f":"K143/J143-1","v":6.1582324770850239E-3},{"$f":"L143/K143-1","v":2.5220386303891784E-2},{"$f":"M143/L143-1","v":2.5368095819306102E-2},{"$f":"M143/H143-1","v":0.10836825324432753}]
[]
[null,null,"Large business - HV"]
[]
[null,null,"Large Business HV (A400 tariff)"]
[]
[null,null,"Tariff charges","Calc|Customer tariff","$ per annum","Nominal",null,{"$f":"'Calc|Customer tariff'!K123","v":219811.19510000001},{"$f":"'Calc|Customer tariff'!K127","v":225225.97229999999},{"$f":"'Calc|Customer tariff'!K131","v":231807.66000000003},{"$f":"'Calc|Customer tariff'!K135","v":233139.12300000002},{"$f":"'Calc|Customer tariff'!K139","v":238911.391},{"$f":"'Calc|Customer tariff'!K143","v":244831.891}]
[null,null,"Metering charges","Calc|Customer tariff","$ per annum","Nominal",null,null,null,null,null,null,null,null,"Note that large business customers' metering services are contestable and are therefore excluded from this analysis"]
[]
[null,null,"Total charges","Calculated","$ per annum","Nominal",null,{"$f":"SUM(H152:H153)","v":219811.19510000001},{"$f":"SUM(I152:I153)","v":225225.97229999999},{"$f":"SUM(J152:J153)","v":231807.66000000003},233139.12300000002,238911.391,244831.891]
[]
[null,null,"Year-on-year  change","Calculated","$ per annum","Nominal",null,null,{"$f":"I155-H155","v":5414.7771999999823},{"$f":"J155-I155","v":6581.6877000000386},1331.4629999999888,5772.2679999999818,5920.5,{"$f":"SUM(I157:M157)","v":25020.695899999992}]
[null,null,"Year-on-year  change","Calculated","per cent","Nominal",null,null,{"$f":"I155/H155-1","v":2.4633764433775074E-2},{"$f":"J155/I155-1","v":2.9222596456297101E-2},5.7438265845053404E-3,2.4758899002978563E-2,2.4781154114162707E-2,{"$f":"M155/H155-1","v":0.11382812367048545}]