{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Index","Output | Difference","Output | Proposed Revenue","Input | Proposed Tariffs","Calc | Existing Revenue"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":3,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
[null,null,null,null,null,"Section Check",{"$f":"IF(COUNTA($A$19:$A$163)=COUNTIF($A$19:$A$163,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[]
[]
[]
[null,null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,null,"Model Index"]
[]
[null,null,"Description of model","1. Calculates ActewAGL Distribution's revenue for 2015/16 under the current tariff structure and the proposed tariff structure beginning 1 July 2016"]
[null,null,null,"2. Presents the calculated prices for 2016/17 as displayed in the proposed Initial Reference Tariff Schedule & the reconciliation with the proposed smoothed revenue requirement "]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Output | Difference","shows difference between:"]
[null,null,null," (i) 2015/16 revenues calculated from 'Calc | Existing Revenue' & 'Output | Proposed Revenue' tabs "]
[null,null,null,"(ii) proposed smoothed revenue requirement for 2016/17 and equivalent revenues calculated in 'Output | Proposed Revenue' tab"]
[]
[null,null,"Output | Proposed Revenue","outputs 2015/16 & 2016/17 revenues under proposed tariff structures calculated from 'Inputs | Proposed Tariffs' tab"]
[]
[null,null,"Input | Proposed Tariffs","inputs under proposed tariff structure submitted in the access arrangement proposal:"]
[null,null,null," (i) hypothetical prices for 2015/16  to solve for the same revenues in the 'Calc | Existing Revenue' tab"]
[null,null,null," (ii) proposed prices for 2016/17 (as displayed in the proposed Initial Reference Tariff Schedule) to recover the proposed smoothed revenue requirement found in the 'Output | Difference' tab  "]
[]
[null,null,"Calc | Existing Revenue","calculates revenue for 2015/16 under existing tariff structure and prices. Quantities used are from Core Energy's Demand Forecast model (submission) and translate to the same quantities in the 'Inputs | Proposed Tariffs' tab"]
[]
[]
[]
[null,null,"Version Control","Developer","Comments","Sheet","Cell reference","Date","Legend"]
[null,null,"Version 1 ","Jemena Limited",null,null,null,"2015-06-23"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"END"]

{"sheet":"Output | Difference","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
[null,null,null,null,null,"Section Check",{"$f":"IF(COUNTA($A$6:$A$55)=COUNTIF($A$6:$A$55,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[]
[]
[]
[]
[null,null,"ALLOWABLE REVENUE"]
[]
[null,null,"A.  2015-16",null,null,null,null,null,"2015-16"]
[null,null,null,null,"Source","Unit","Basis"]
[null,null,"Total Revenue from Existing Tariffs ",null,"Calc | Existing Revenue","$M","$real2016",null,{"$f":"'Calc | Existing Revenue'!H16/10^6","v":70.453867774943873}]
[null,null,"Total Revenue from Proposed Tariffs ",null,"Output | Proposed Tariffs","$M","$real2016",null,{"$f":"'Output | Proposed Revenue'!H13/10^6","v":70.453867774943873}]
[]
[null,null,"Difference",null,"Calculated","$M","$real2016",null,{"$f":"I10-I11","v":0}]
[]
[]
[]
[null,null,"B.  2016-17 ",null,null,null,null,null,"2016-17"]
[null,null,null,null,"Source","Unit","Basis"]
[null,null,"Proposed Smoothed Building Block ",null,"AAD","$M","nominal",null,69.293069853893158]
[null,null,"Total Revenue from Proposed Tariffs ",null,"Output | Proposed Tariffs","$M","nominal",null,{"$f":"'Output | Proposed Revenue'!I13/10^6","v":69.293069853893144}]
[]
[null,null,"Difference",null,"Calculated","$M","nominal",null,{"$f":"I19-I20","v":0}]
[]
[]
[]
[]
[]
[null,null,"END"]

{"sheet":"Output | Proposed Revenue","index":2,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
[null,null,null,null,null,"Section Check",{"$f":"IF(COUNTA($A$13:$A$17)=COUNTIF($A$13:$A$17,\"OK\"),\"OK\",\"Check\")","v":"Check"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-16","2016-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CPI",1,1.0254811219122864]
[null,null,"TOTAL"]
[]
[null,null,null,null,null,null,null,"2015-16","2016-17"]
[null,null,null,null,"Source","Basis"]
[null,null,"Volume Market",null,"calculated","$nominal",null,67692226.094278783,66380308.652077749]
[null,null,"Demand Market",null,"calculated","$nominal",null,2761641.6806650884,2912761.2018153942]
[]
[{"$f":"IF(ROUND(SUM(H13:I13)-SUM('Input | Proposed Tariffs'!G156:AI156),6)=0,\"Ok\",\"Check\")","v":"Check"},null,"Total ",null,"calculated","$nominal",null,70453867.774943873,69293069.853893146]
[null,null,"Total ",null,"calculated","$real2016",null,70453867.774943873,67571277.884352967]
[]
[{"$f":"IF(COUNTA($H16:$H16)=COUNTIF($H16:$H16,\"OK\"),\"OK\",\"Check\")","v":"Check"},null,null,null,null,"Ok/Check",null,{"$f":"IF(ROUND(SUM('Input | Proposed Tariffs'!G156,'Input | Proposed Tariffs'!J156,'Input | Proposed Tariffs'!M156,'Input | Proposed Tariffs'!P156,'Input | Proposed Tariffs'!S156,'Input | Proposed Tariffs'!V156,'Input | Proposed Tariffs'!Y156,'Input | Proposed Tariffs'!AB156,'Input | Proposed Tariffs'!AE156,'Input | Proposed Tariffs'!AH156)-H13,6)=0,\"Ok\",\"Check\")","v":"Check"},{"$f":"IF(ROUND(SUM('Input | Proposed Tariffs'!H156,'Input | Proposed Tariffs'!K156,'Input | Proposed Tariffs'!N156,'Input | Proposed Tariffs'!Q156,'Input | Proposed Tariffs'!T156,'Input | Proposed Tariffs'!W156,'Input | Proposed Tariffs'!Z156,'Input | Proposed Tariffs'!AC156,'Input | Proposed Tariffs'!AF156,'Input | Proposed Tariffs'!AI156)-I13,6)=0,\"Ok\",\"Check\")","v":"Check"}]
[]
[]
[null,null,"END"]

{"sheet":"Input | Proposed Tariffs","index":3,"n_rows":159,"n_cols":35,"rows_kept":159,"cut":false,"hidden":false,"merged":[[1,2,1,6],[7,6,7,7],[7,9,7,10],[7,12,7,13],[7,15,7,16],[7,33,7,34],[60,6,60,7],[60,9,60,10],[60,12,60,13],[60,15,60,16],[60,18,60,19],[60,21,60,22],[60,24,60,25],[60,27,60,28],[60,30,60,31],[60,33,60,34],[7,18,7,19],[7,21,7,22],[7,24,7,25],[7,27,7,28],[7,30,7,31],[109,6,109,7],[109,9,109,10],[109,12,109,13],[109,15,109,16],[109,18,109,19],[109,21,109,22],[109,24,109,25],[109,27,109,28],[109,30,109,31],[109,33,109,34]]}
[null,null,null,null,null,"Section check",{"$f":"IF(COUNTA($A$13:$A$156)=COUNTIF($A$13:$A$156,\"OK\"),\"OK\",\"Check\")","v":"Check"}]
[]
[]
[]
[]
[null,null," Forecast Quantities"]
[]
[null,null,"Basis",null,null,null,"Customer Number or Delivery Station",null,null,"Throughput Block 1 (GJ)",null,null,"Throughput Block 2 (GJ)",null,null,"Throughput Block 3 (GJ)",null,null,"Throughput Block 4 (GJ)",null,null,"Capacity  Block 1 (GJ)",null,null,"Capacity  Block 2 (GJ)",null,null,"Capacity  Block 3 (GJ)",null,null,"Ancillary services (Hour)",null,null,"Ancillary services (Request)"]
[null,null,"Year",null,null,null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17"]
[]
[null,null,"TARIFF CLASS - RESIDENTIAL",null,"Source"]
[null,null,"Individually metered (VRI)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I16/365","v":94742.116196521383},{"$f":"'[2]Pricing Block Summary'!J16/365","v":96383.522159272965},null,{"$f":"'[2]Pricing Block Summary'!I9","v":892530.06484727887},{"$f":"'[2]Pricing Block Summary'!J9","v":873114.38004150102},null,{"$f":"'[2]Pricing Block Summary'!I10","v":1352277.0822565525},{"$f":"'[2]Pricing Block Summary'!J10","v":1322860.2742035233},null,{"$f":"'[2]Pricing Block Summary'!I11","v":20166.330482713332},{"$f":"'[2]Pricing Block Summary'!J11","v":19727.641488624929},null,{"$f":"'[2]Pricing Block Summary'!I12","v":906.35193180734086},{"$f":"'[2]Pricing Block Summary'!J12","v":886.63557252246869}]
[null,null,"Individually metered with gas heating & hot water (VRH)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I27/365","v":37866.271097681281},{"$f":"'[2]Pricing Block Summary'!J27/365","v":38724.191226510418},null,{"$f":"'[2]Pricing Block Summary'!I21","v":607079.40731681802},{"$f":"'[2]Pricing Block Summary'!J21","v":593746.93008382886},null,{"$f":"'[2]Pricing Block Summary'!I22","v":1216688.3121641229},{"$f":"'[2]Pricing Block Summary'!J22","v":1189967.8057096736},null,{"$f":"'[2]Pricing Block Summary'!I23","v":705729.81100580108},{"$f":"'[2]Pricing Block Summary'!J23","v":690230.80622245104}]
[null,null,"Boundary metered with gas heating and cooking (VRB)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I38/365","v":50.236998966007583},{"$f":"'[2]Pricing Block Summary'!J38/365","v":78.489284372994589},null,{"$f":"'[2]Pricing Block Summary'!I32","v":10011.970087391062},{"$f":"'[2]Pricing Block Summary'!J32","v":13970.009306305588},null,{"$f":"'[2]Pricing Block Summary'!I33","v":10631.267206198758},{"$f":"'[2]Pricing Block Summary'!J33","v":14834.133593293564}]
[null,null,"Large scale generation (VRG)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I49/365","v":0},{"$f":"'[2]Pricing Block Summary'!J49/365","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I43","v":0},{"$f":"'[2]Pricing Block Summary'!J43","v":0},null,{"$f":"'[2]Pricing Block Summary'!I44","v":0},{"$f":"'[2]Pricing Block Summary'!J44","v":0},null,{"$f":"'[2]Pricing Block Summary'!I45","v":0},{"$f":"'[2]Pricing Block Summary'!J45","v":0}]
[]
[null,null,"Ancillary services",null,"Source"]
[null,null,"Reconnection fee",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I57","v":104},{"$f":"'[2]Pricing Block Summary'!J57","v":104}]
[null,null,"Disconnection fee",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I60","v":115.69818735464798},{"$f":"'[2]Pricing Block Summary'!J60","v":102.79952039667047}]
[null,null,"Decommissioning & meter removal",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I63","v":615.93507740801692},{"$f":"'[2]Pricing Block Summary'!J63","v":801.71165361476096}]
[null,null,"Special meter read",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I66","v":25066.449468838},{"$f":"'[2]Pricing Block Summary'!J66","v":25066.449468838}]
[]
[null,null,"TARIFF CLASS - BUSINESS",null,"Source"]
[null,null,"Small (VBS)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I79/365","v":5649.2175001717496},{"$f":"'[2]Pricing Block Summary'!J79/365","v":5792.6030207033855},null,{"$f":"'[2]Pricing Block Summary'!I73","v":59856.659594097771},{"$f":"'[2]Pricing Block Summary'!J73","v":60402.570739141789},null,{"$f":"'[2]Pricing Block Summary'!I74","v":816506.22830923123},{"$f":"'[2]Pricing Block Summary'!J74","v":823953.01623649825},null,{"$f":"'[2]Pricing Block Summary'!I75","v":658423.25553507544},{"$f":"'[2]Pricing Block Summary'!J75","v":664428.2781305596}]
[null,null,"Medium (VBM)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I90/365","v":7.7553813830186726},{"$f":"'[2]Pricing Block Summary'!J90/365","v":8.0211356703785537},null,{"$f":"'[2]Pricing Block Summary'!I84","v":11733.288455240878},{"$f":"'[2]Pricing Block Summary'!J84","v":11963.329138254063},null,{"$f":"'[2]Pricing Block Summary'!I85","v":8864.7226304626347},{"$f":"'[2]Pricing Block Summary'!J85","v":9038.5227425465746},null,{"$f":"'[2]Pricing Block Summary'!I86","v":6957.8565874784445},{"$f":"'[2]Pricing Block Summary'!J86","v":7094.2710366584097}]
[null,null,"Large capacity (DBC)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I98","v":1794.5843913894325},{"$f":"'[2]Pricing Block Summary'!J98","v":1794.5843913894325},null,{"$f":"'[2]Pricing Block Summary'!I99","v":1944.4118943248534},{"$f":"'[2]Pricing Block Summary'!J99","v":1944.4118943248534},null,{"$f":"'[2]Pricing Block Summary'!I100","v":2527.6130000000003},{"$f":"'[2]Pricing Block Summary'!J100","v":2569.4630000000002}]
[null,null,"Large throughput (DBT)",null,"JGN / AAD"]
[null,null,"Large scale generation (DBG)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I111","v":130},{"$f":"'[2]Pricing Block Summary'!J111","v":130},null,{"$f":"'[2]Pricing Block Summary'!I112","v":137.08430332681019},{"$f":"'[2]Pricing Block Summary'!J112","v":137.08430332681019},null,{"$f":"'[2]Pricing Block Summary'!I113","v":1.2419999999999902},{"$f":"'[2]Pricing Block Summary'!J113","v":1.2419999999999902}]
[]
[null,null,"Fixed charges (Large business only)",null,"Source"]
[null,null,"Existing installations with no more than 15 meters and new entrants"]
[null,null,"Single Run & Bypass metering installation",null,"JGN / AAD"]
[null,null," MHQ/DS < 16 GJ                             ($/DS pa)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I119/365","v":32},{"$f":"'[2]Pricing Block Summary'!J119/365","v":32}]
[null,null," 16 GJ <= \"MHQ/DS\" < 50 GJ           ($/DS pa)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I120/365","v":12},{"$f":"'[2]Pricing Block Summary'!J120/365","v":12}]
[null,null," 50 GJ <= \"MHQ/DS\" < 100 GJ         ($/DS pa)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I121/365","v":3},{"$f":"'[2]Pricing Block Summary'!J121/365","v":3}]
[null,null,"\"MHQ/DS\" >= 100 GJ                       ($/DS pa)",null,"JGN / AAD",null,{"$f":"'[2]Pricing Block Summary'!I122/365","v":0},{"$f":"'[2]Pricing Block Summary'!J122/365","v":0}]
[]
[null,null,"Double Run metering installation"]
[null,null," MHQ/DS < 16 GJ                             ($/DS pa)",null,"JGN / AAD"]
[null,null," 16 GJ <= \"MHQ/DS\" < 50 GJ           ($/DS pa)",null,"JGN / AAD"]
[null,null," 50 GJ <= \"MHQ/DS\" < 100 GJ         ($/DS pa)",null,"JGN / AAD"]
[null,null,"\"MHQ/DS\" >= 100 GJ                       ($/DS pa)",null,"JGN / AAD"]
[]
[null,null,"Existing installations with more than 15 meters (closed to new entrants)"]
[null,null,"Number of meters                  ",null,"JGN / AAD",null,106,106]
[]
[null,null,"Ancillary services",null,"Source"]
[null,null,"Request for service ($/hr)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I147","v":5.5},{"$f":"'[2]Pricing Block Summary'!J147","v":5.5}]
[null,null,"Reconnection fee ($/request)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I135","v":15},{"$f":"'[2]Pricing Block Summary'!J135","v":15}]
[null,null,"Disconnection fee ($/request)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I138","v":10.70276674650658},{"$f":"'[2]Pricing Block Summary'!J138","v":10.70276674650658}]
[null,null,"Decommissioning & meter removal  ($/request)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I141","v":6.4981083818075653},{"$f":"'[2]Pricing Block Summary'!J141","v":6.4981083818075653}]
[null,null,"Special meter read",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[2]Pricing Block Summary'!I144","v":654.55053116200065},{"$f":"'[2]Pricing Block Summary'!J144","v":654.55053116200065}]
[]
[null,null,"Total",null,"Calculated"]
[]
[{"$f":"IF(COUNTA($G56:$AH56)=COUNTIF($G56:$AH56,\"OK\"),\"OK\",\"Check\")","v":"Check"},null,"Ok/Check",null,null,null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!I16,'[2]Pricing Block Summary'!I27,'[2]Pricing Block Summary'!I38,'[2]Pricing Block Summary'!I49,'[2]Pricing Block Summary'!I79,'[2]Pricing Block Summary'!I90,'[2]Pricing Block Summary'!I119:I122)/365-SUM(G12:G15,G24:G25,G33:G36),6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!J16,'[2]Pricing Block Summary'!J27,'[2]Pricing Block Summary'!J38,'[2]Pricing Block Summary'!J49,'[2]Pricing Block Summary'!J79,'[2]Pricing Block Summary'!J90,'[2]Pricing Block Summary'!J119:J122)/365-SUM(H12:H15,H24:H25,H33:H36),6)=0,\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$I$9,'[2]Pricing Block Summary'!$I$21,'[2]Pricing Block Summary'!$I$32,'[2]Pricing Block Summary'!$I$43,'[2]Pricing Block Summary'!$I$73,'[2]Pricing Block Summary'!$I$84,'[2]Pricing Block Summary'!$I$106)-SUM(J12:J14,J24:J25,J27),6)=0,\"Ok\",\"Check\")","v":"Check"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$J$9,'[2]Pricing Block Summary'!$J$21,'[2]Pricing Block Summary'!$J$32,'[2]Pricing Block Summary'!$J$43,'[2]Pricing Block Summary'!$J$73,'[2]Pricing Block Summary'!$J$84,'[2]Pricing Block Summary'!$J$106)-SUM(K12:K14,K24:K25,K27),6)=0,\"Ok\",\"Check\")","v":"Check"},null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$I$10,'[2]Pricing Block Summary'!$I$22,'[2]Pricing Block Summary'!$I$33,'[2]Pricing Block Summary'!$I$44,'[2]Pricing Block Summary'!$I$74,'[2]Pricing Block Summary'!$I$85)-SUM(M12:M14,M24:M25),6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$J$10,'[2]Pricing Block Summary'!$J$22,'[2]Pricing Block Summary'!$J$33,'[2]Pricing Block Summary'!$J$44,'[2]Pricing Block Summary'!$J$74,'[2]Pricing Block Summary'!$J$85)-SUM(N12:N14,N24:N25),6)=0,\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$I$11,'[2]Pricing Block Summary'!$I$23,'[2]Pricing Block Summary'!$I$34,'[2]Pricing Block Summary'!$I$45,'[2]Pricing Block Summary'!$I$75,'[2]Pricing Block Summary'!$I$86)-SUM(P12:P14,P24:P25),6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$J$11,'[2]Pricing Block Summary'!$J$23,'[2]Pricing Block Summary'!$J$34,'[2]Pricing Block Summary'!$J$45,'[2]Pricing Block Summary'!$J$75,'[2]Pricing Block Summary'!$J$86)-SUM(Q12:Q14,Q24:Q25),6)=0,\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$I$12)-SUM(S12),6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$J$12)-SUM(T12),6)=0,\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$I$98,'[2]Pricing Block Summary'!$I$111,'[2]Pricing Block Summary'!$I$43)-SUM(V15,V26,V28),6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$J$98,'[2]Pricing Block Summary'!$J$111,'[2]Pricing Block Summary'!$J$43)-SUM(W15,W26,W28),6)=0,\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$I$99,'[2]Pricing Block Summary'!$I$112,'[2]Pricing Block Summary'!$I$44)-SUM(Y15,Y26,Y28),6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$J$99,'[2]Pricing Block Summary'!$J$112,'[2]Pricing Block Summary'!$J$44)-SUM(Z15,Z26,Z28),6)=0,\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$I$100,'[2]Pricing Block Summary'!$I$113,'[2]Pricing Block Summary'!$I$45)-SUM(AB15,AB26,AB28),6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$J$100,'[2]Pricing Block Summary'!$J$113,'[2]Pricing Block Summary'!$J$45)-SUM(AC15,AC26,AC28),6)=0,\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"IF(ROUND('[2]Pricing Block Summary'!$I$147-AE48,6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND('[2]Pricing Block Summary'!$J$147-AF48,6)=0,\"Ok\",\"Check\")","v":"Ok"},null,{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$I$57,'[2]Pricing Block Summary'!$I$60,'[2]Pricing Block Summary'!$I$63,'[2]Pricing Block Summary'!$I$66,'[2]Pricing Block Summary'!$I$135,'[2]Pricing Block Summary'!$I$138,'[2]Pricing Block Summary'!$I$141,'[2]Pricing Block Summary'!$I$144)-SUM(AH49:AH52,AH18:AH21),6)=0,\"Ok\",\"Check\")","v":"Ok"},{"$f":"IF(ROUND(SUM('[2]Pricing Block Summary'!$J$57,'[2]Pricing Block Summary'!$J$60,'[2]Pricing Block Summary'!$J$63,'[2]Pricing Block Summary'!$J$66,'[2]Pricing Block Summary'!$J$135,'[2]Pricing Block Summary'!$J$138,'[2]Pricing Block Summary'!$J$141,'[2]Pricing Block Summary'!$J$144)-SUM(AI49:AI52,AI18:AI21),6)=0,\"Ok\",\"Check\")","v":"Ok"}]
[]
[]
[null,null,"Proposed tariffs"]
[]
[null,null,"Basis",null,null,null,"Customer Number or Delivery Station",null,null,"Throughput Block 1 (GJ)",null,null,"Throughput Block 2 (GJ)",null,null,"Throughput Block 3 (GJ)",null,null,"Throughput Block 4 (GJ)",null,null,"Capacity  Block 1 (GJ)",null,null,"Capacity  Block 2 (GJ)",null,null,"Capacity  Block 3 (GJ)",null,null,"Ancillary services (Hour)",null,null,"Ancillary services (Request)"]
[null,null,"Year",null,null,null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17"]
[]
[]
[null,null,"Individually metered (VRI)",null,"JGN / AAD",null,80,82.038489752982912,null,12.094537908135109,12.402720303045069,null,7.55,7.7423824704377617,null,7.15,7.3321900216728482,null,7,7.1783678533860042]
[null,null,"Individually metered with gas heating & hot water (VRH)",null,"JGN / AAD",null,179.9999999999998,184.58660194421134,null,7.45,6.9322949712756143,null,7.1,6.6066166840344778,null,7.05,6.560091214428601]
[null,null,"Boundary metered with gas heating and cooking (VRB)",null,"JGN / AAD",null,800,820.38489752982912,null,12.094537908135109,12.402720303045069,null,7.55,7.7423824704377617,null,7.15,7.3321900216728482]
[null,null,"Large scale generation (VRG)",null,"JGN / AAD",null,16000,16800,null,null,null,null,null,null,null,null,null,null,null,null,null,290.7,305.23500000000001,null,285.95,300.2475,null,282.14999999999998,296.25749999999999]
[]
[null,null,"Ancillary services",null,"Source"]
[null,null,"Reconnection fee",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48.76,50.002459504443081]
[null,null,"Disconnection fee",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146.27000000000001,149.99712370211014]
[null,null,"Decommissioning & meter removal",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,780.11,799.98807801499368]
[null,null,"Special meter read",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.5,19.996881877289585]
[]
[null,null,"TARIFF CLASS - BUSINESS",null,"Source"]
[null,null,"Small (VBS)",null,"JGN / AAD",null,130,133.31254584859724,null,9.9499999999999993,9.2585684515694435,null,7.717130988903584,7.1808628653760431,null,7.48,6.9602102530391399]
[null,null,"Medium (VBM)",null,"JGN / AAD",null,2000,2050.9622438245729,null,7.25,6.7461930928521072,null,6,5.5830563527051922,null,5.5,5.1178016566464271]
[null,null,"Large capacity (DBC)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,306,321.3,null,301,316.05,null,297,311.85000000000002]
[null,null,"Large throughput (DBT)",null,"JGN / AAD",null,null,null,null,4.38,4.5990000000000002]
[null,null,"Large scale generation (DBG)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,315,null,285,299.25,null,250,262.5]
[]
[null,null,"Fixed charges (Large business only)",null,"Source"]
[null,null,"Existing installations with no more than 15 meters and new entrants"]
[null,null,"Single Run & Bypass metering installation"]
[null,null," MHQ/DS < 16 GJ                             ($/DS pa)",null,"JGN / AAD",null,8000,8400]
[null,null," 16 GJ <= \"MHQ/DS\" < 50 GJ           ($/DS pa)",null,"JGN / AAD",null,11000,11550]
[null,null," 50 GJ <= \"MHQ/DS\" < 100 GJ         ($/DS pa)",null,"JGN / AAD",null,17000,17850]
[null,null,"\"MHQ/DS\" >= 100 GJ                       ($/DS pa)",null,"JGN / AAD",null,22000,23100]
[]
[null,null,"Double Run metering installation"]
[null,null," MHQ/DS < 16 GJ                             ($/DS pa)",null,"JGN / AAD",null,16000,16800]
[null,null," 16 GJ <= \"MHQ/DS\" < 50 GJ           ($/DS pa)",null,"JGN / AAD",null,22000,23100]
[null,null," 50 GJ <= \"MHQ/DS\" < 100 GJ         ($/DS pa)",null,"JGN / AAD",null,34000,35700]
[null,null,"\"MHQ/DS\" >= 100 GJ                       ($/DS pa)",null,"JGN / AAD",null,44000,46200]
[]
[null,null,"Existing installations with more than 15 meters (closed to new entrants)"]
[null,null,"Number of meters                  ",null,"JGN / AAD",null,1900,1995]
[]
[null,null,"Ancillary services",null,"Source"]
[null,null,"Request for service ($/hr)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,102.54811219122864]
[null,null,"Reconnection fee ($/request)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58.51,60.000900443087872]
[null,null,"Disconnection fee ($/request)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,195.03,199.99958320655321]
[null,null,"Decommissioning & meter removal  ($/request)",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1335.93,1369.9709951962807]
[null,null,"Special meter read",null,"JGN / AAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.5,19.996881877289585]
[]
[]
[null,null,"Forecast Revenues ($nominal)"]
[]
[null,null,"Revenue $nominal",null,null,null,"Customer Number or Delivery Station",null,null,"Throughput Block 1 (GJ)",null,null,"Throughput Block 2 (GJ)",null,null,"Throughput Block 3 (GJ)",null,null,"Throughput Block 4 (GJ)",null,null,"Capacity  Block 1 (GJ)",null,null,"Capacity  Block 2 (GJ)",null,null,"Capacity  Block 3 (GJ)",null,null,"Ancillary services (Hour)",null,null,"Ancillary services (Request)"]
[null,null,"Year",null,null,null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17"]
[]
[null,null,"TARIFF CLASS - RESIDENTIAL",null,"Source"]
[null,null,"Individually metered (VRI)",null,"calculated",null,{"$f":"IF(G12=\"\",\"\",G12*G65)","v":7579369.2957217107},7907158.595019917,null,{"$f":"IF(J12=\"\",\"\",J12*J65)","v":10794738.703445701},{"$f":"IF(K12=\"\",\"\",K12*K65)","v":10828993.448221333},null,{"$f":"IF(M12=\"\",\"\",M12*M65)","v":10209691.971036971},10242090.19783185,null,{"$f":"IF(P12=\"\",\"\",P12*P65)","v":144189.26295140033},144646.81607403501,null,{"$f":"IF(S12=\"\",\"\",S12*S65)","v":6344.4635226513856},6364.5962914637848,null,{"$f":"IF(V12=\"\",\"\",V12*V65)","v":""},"",null,{"$f":"IF(Y12=\"\",\"\",Y12*Y65)","v":""},"",null,{"$f":"IF(AB12=\"\",\"\",AB12*AB65)","v":""},"",null,{"$f":"IF(AE12=\"\",\"\",AE12*AE65)","v":""},"",null,{"$f":"IF(AH12=\"\",\"\",AH12*AH65)","v":""},""]
[null,null,"Individually metered with gas heating & hot water (VRH)",null,"calculated",null,6815928.7975826235,7147966.8715394,null,4522741.5845102947,{"$f":"IF(K13=\"\",\"\",K13*K66)","v":4116028.8576304605},null,8638487.0163652729,7861661.158665427,null,4975395.1675908975,4527977.0478278715,null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[null,null,"Boundary metered with gas heating and cooking (VRB)",null,"calculated",null,40189.599172806069,64391.423517528783,null,121090.15175706599,{"$f":"IF(K14=\"\",\"\",K14*K67)","v":173266.11805704486},null,80266.067406800619,114851.53589684801,null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[null,null,"Large scale generation (VRG)",null,"calculated",null,0,0,null,"",{"$f":"IF(K15=\"\",\"\",K15*K68)","v":""},null,"","",null,"","",null,"","",null,0,0,null,0,0,null,0,0,null,"","",null,"",""]
[]
[null,null,"Ancillary services",null,"Source"]
[null,null,"Reconnection fee",null,"calculated",null,{"$f":"IF(G18=\"\",\"\",G18*G71)","v":""},"",null,{"$f":"IF(J18=\"\",\"\",J18*J71)","v":""},{"$f":"IF(K18=\"\",\"\",K18*K71)","v":""},null,{"$f":"IF(M18=\"\",\"\",M18*M71)","v":""},"",null,{"$f":"IF(P18=\"\",\"\",P18*P71)","v":""},"",null,{"$f":"IF(S18=\"\",\"\",S18*S71)","v":""},"",null,{"$f":"IF(V18=\"\",\"\",V18*V71)","v":""},"",null,{"$f":"IF(Y18=\"\",\"\",Y18*Y71)","v":""},"",null,{"$f":"IF(AB18=\"\",\"\",AB18*AB71)","v":""},"",null,{"$f":"IF(AE18=\"\",\"\",AE18*AE71)","v":""},"",null,{"$f":"IF(AH18=\"\",\"\",AH18*AH71)","v":5071.04},5200.2557884620801]
[null,null,"Disconnection fee",null,"calculated",null,"","",null,"",{"$f":"IF(K19=\"\",\"\",K19*K72)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,16923.173864364362,15419.632377456976]
[null,null,"Decommissioning & meter removal",null,"calculated",null,"","",null,"",{"$f":"IF(K20=\"\",\"\",K20*K73)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,480497.11323676811,641359.76489749493]
[null,null,"Special meter read",null,"calculated",null,"","",null,"",{"$f":"IF(K21=\"\",\"\",K21*K74)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,488795.764642341,501250.82911140175]
[]
[null,null,"TARIFF CLASS - BUSINESS",null,"Source"]
[null,null,"Small (VBS)",null,"calculated",null,{"$f":"IF(G24=\"\",\"\",G24*G77)","v":734398.27502232743},772226.65578024299,null,{"$f":"IF(J24=\"\",\"\",J24*J77)","v":595573.76296127273},{"$f":"IF(K24=\"\",\"\",K24*K77)","v":559241.33583910973},null,{"$f":"IF(M24=\"\",\"\",M24*M77)","v":6301085.5171179529},5916693.6171072545,null,{"$f":"IF(P24=\"\",\"\",P24*P77)","v":4925005.9514023643},4624560.5138534624,null,{"$f":"IF(S24=\"\",\"\",S24*S77)","v":""},"",null,{"$f":"IF(V24=\"\",\"\",V24*V77)","v":""},"",null,{"$f":"IF(Y24=\"\",\"\",Y24*Y77)","v":""},"",null,{"$f":"IF(AB24=\"\",\"\",AB24*AB77)","v":""},"",null,{"$f":"IF(AE24=\"\",\"\",AE24*AE77)","v":""},"",null,{"$f":"IF(AH24=\"\",\"\",AH24*AH77)","v":""},""]
[null,null,"Medium (VBM)",null,"calculated",null,15510.762766037346,16451.046412540916,null,85066.341300496366,{"$f":"IF(K25=\"\",\"\",K25*K78)","v":80706.928400005912},null,53188.335782775808,50462.581816845006,null,38268.211231131441,36307.072064109176,null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[null,null,"Large capacity (DBC)",null,"calculated",null,"","",null,"",{"$f":"IF(K26=\"\",\"\",K26*K79)","v":""},null,"","",null,"","",null,"","",null,549142.82376516634,576599.96495342464,null,585267.98019178084,614531.37920136994,null,750701.0610000001,801287.03655000008,null,"","",null,"",""]
[null,null,"Large throughput (DBT)",null,"calculated",null,"","",null,null,null,null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[null,null,"Large scale generation (DBG)",null,"calculated",null,"","",null,"",{"$f":"IF(K28=\"\",\"\",K28*K81)","v":""},null,"","",null,"","",null,"","",null,39000,40950,null,39069.026448140903,41022.47777054795,null,310.49999999999756,326.02499999999742,null,"","",null,"",""]
[]
[null,null,"Fixed charges (Large business only)",null,"Source"]
[null,null,"Existing installations with no more than 15 meters and new entrants"]
[null,null,"Single Run & Bypass metering installation"]
[null,null," MHQ/DS < 16 GJ                             ($/DS pa)",null,"calculated",null,{"$f":"IF(G33=\"\",\"\",G33*G86)","v":256000},268800,null,{"$f":"IF(J33=\"\",\"\",J33*J86)","v":""},{"$f":"IF(K33=\"\",\"\",K33*K86)","v":""},null,{"$f":"IF(M33=\"\",\"\",M33*M86)","v":""},"",null,{"$f":"IF(P33=\"\",\"\",P33*P86)","v":""},"",null,{"$f":"IF(S33=\"\",\"\",S33*S86)","v":""},"",null,{"$f":"IF(V33=\"\",\"\",V33*V86)","v":""},"",null,{"$f":"IF(Y33=\"\",\"\",Y33*Y86)","v":""},"",null,{"$f":"IF(AB33=\"\",\"\",AB33*AB86)","v":""},"",null,{"$f":"IF(AE33=\"\",\"\",AE33*AE86)","v":""},"",null,{"$f":"IF(AH33=\"\",\"\",AH33*AH86)","v":""},""]
[null,null," 16 GJ <= \"MHQ/DS\" < 50 GJ           ($/DS pa)",null,"calculated",null,132000,138600,null,"",{"$f":"IF(K34=\"\",\"\",K34*K87)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[null,null," 50 GJ <= \"MHQ/DS\" < 100 GJ         ($/DS pa)",null,"calculated",null,51000,53550,null,"",{"$f":"IF(K35=\"\",\"\",K35*K88)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[null,null,"\"MHQ/DS\" >= 100 GJ                       ($/DS pa)",null,"calculated",null,0,0,null,"",{"$f":"IF(K36=\"\",\"\",K36*K89)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[]
[null,null,"Double Run metering installation"]
[null,null," MHQ/DS < 16 GJ                             ($/DS pa)",null,"calculated",null,{"$f":"IF(G39=\"\",\"\",G39*G92)","v":""},"",null,{"$f":"IF(J39=\"\",\"\",J39*J92)","v":""},{"$f":"IF(K39=\"\",\"\",K39*K92)","v":""},null,{"$f":"IF(M39=\"\",\"\",M39*M92)","v":""},"",null,{"$f":"IF(P39=\"\",\"\",P39*P92)","v":""},"",null,{"$f":"IF(S39=\"\",\"\",S39*S92)","v":""},"",null,{"$f":"IF(V39=\"\",\"\",V39*V92)","v":""},"",null,{"$f":"IF(Y39=\"\",\"\",Y39*Y92)","v":""},"",null,{"$f":"IF(AB39=\"\",\"\",AB39*AB92)","v":""},"",null,{"$f":"IF(AE39=\"\",\"\",AE39*AE92)","v":""},"",null,{"$f":"IF(AH39=\"\",\"\",AH39*AH92)","v":""},""]
[null,null," 16 GJ <= \"MHQ/DS\" < 50 GJ           ($/DS pa)",null,"calculated",null,"","",null,"",{"$f":"IF(K40=\"\",\"\",K40*K93)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[null,null," 50 GJ <= \"MHQ/DS\" < 100 GJ         ($/DS pa)",null,"calculated",null,"","",null,"",{"$f":"IF(K41=\"\",\"\",K41*K94)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[null,null,"\"MHQ/DS\" >= 100 GJ                       ($/DS pa)",null,"calculated",null,"","",null,"",{"$f":"IF(K42=\"\",\"\",K42*K95)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[]
[null,null,"Existing installations with more than 15 meters (closed to new entrants)"]
[null,null,"Number of meters                  ",null,"calculated",null,{"$f":"IF(G45=\"\",\"\",G45*G98)","v":201400},211470,null,{"$f":"IF(J45=\"\",\"\",J45*J98)","v":""},{"$f":"IF(K45=\"\",\"\",K45*K98)","v":""},null,{"$f":"IF(M45=\"\",\"\",M45*M98)","v":""},"",null,{"$f":"IF(P45=\"\",\"\",P45*P98)","v":""},"",null,{"$f":"IF(S45=\"\",\"\",S45*S98)","v":""},"",null,{"$f":"IF(V45=\"\",\"\",V45*V98)","v":""},"",null,{"$f":"IF(Y45=\"\",\"\",Y45*Y98)","v":""},"",null,{"$f":"IF(AB45=\"\",\"\",AB45*AB98)","v":""},"",null,{"$f":"IF(AE45=\"\",\"\",AE45*AE98)","v":""},"",null,{"$f":"IF(AH45=\"\",\"\",AH45*AH98)","v":""},""]
[]
[null,null,"Ancillary services",null,"Source"]
[null,null,"Request for service ($/hr)",null,"calculated",null,{"$f":"IF(G48=\"\",\"\",G48*G101)","v":""},"",null,{"$f":"IF(J48=\"\",\"\",J48*J101)","v":""},{"$f":"IF(K48=\"\",\"\",K48*K101)","v":""},null,{"$f":"IF(M48=\"\",\"\",M48*M101)","v":""},"",null,{"$f":"IF(P48=\"\",\"\",P48*P101)","v":""},"",null,{"$f":"IF(S48=\"\",\"\",S48*S101)","v":""},"",null,{"$f":"IF(V48=\"\",\"\",V48*V101)","v":""},"",null,{"$f":"IF(Y48=\"\",\"\",Y48*Y101)","v":""},"",null,{"$f":"IF(AB48=\"\",\"\",AB48*AB101)","v":""},"",null,{"$f":"IF(AE48=\"\",\"\",AE48*AE101)","v":550},564.01461705175757,null,{"$f":"IF(AH48=\"\",\"\",AH48*AH101)","v":""},""]
[null,null,"Reconnection fee ($/request)",null,"calculated",null,"","",null,"",{"$f":"IF(K49=\"\",\"\",K49*K102)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,877.65,900.01350664631809]
[null,null,"Disconnection fee ($/request)",null,"calculated",null,"","",null,"",{"$f":"IF(K50=\"\",\"\",K50*K103)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,2087.3605985711783,2140.5488884582733]
[null,null,"Decommissioning & meter removal  ($/request)",null,"calculated",null,"","",null,"",{"$f":"IF(K51=\"\",\"\",K51*K104)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,8681.017930508182,8902.2200067182039]
[null,null,"Special meter read",null,"calculated",null,"","",null,"",{"$f":"IF(K52=\"\",\"\",K52*K105)","v":""},null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,12763.735357659012,13088.969654363682]
[]
[null,null,"Total",null,"calculated",null,{"$f":"SUM(G150:G154,G147,G141:G144,G135:G138,G126:G130,G120:G123,G114:G117)","v":15825796.730265504},16580614.592269629,null,{"$f":"SUM(J150:J154,J147,J141:J144,J135:J138,J126:J130,J120:J123,J114:J117)","v":16119210.54397483},{"$f":"SUM(K150:K154,K147,K141:K144,K135:K138,K126:K130,K120:K123,K114:K117)","v":15758236.688147953},null,{"$f":"SUM(M150:M154,M147,M141:M144,M135:M138,M126:M130,M120:M123,M114:M117)","v":25282718.907709774},24185759.091318224,null,{"$f":"SUM(P150:P154,P147,P141:P144,P135:P138,P126:P130,P120:P123,P114:P117)","v":10082858.593175793},9333491.4498194791,null,{"$f":"SUM(S150:S154,S147,S141:S144,S135:S138,S126:S130,S120:S123,S114:S117)","v":6344.4635226513856},6364.5962914637848,null,{"$f":"SUM(V150:V154,V147,V141:V144,V135:V138,V126:V130,V120:V123,V114:V117)","v":588142.82376516634},617549.96495342464,null,{"$f":"SUM(Y150:Y154,Y147,Y141:Y144,Y135:Y138,Y126:Y130,Y120:Y123,Y114:Y117)","v":624337.00663992169},655553.85697191791,null,{"$f":"SUM(AB150:AB154,AB147,AB141:AB144,AB135:AB138,AB126:AB130,AB120:AB123,AB114:AB117)","v":751011.5610000001},801613.0615500001,null,{"$f":"SUM(AE150:AE154,AE147,AE141:AE144,AE135:AE138,AE126:AE130,AE120:AE123,AE114:AE117)","v":550},564.01461705175757,null,{"$f":"SUM(AH150:AH154,AH147,AH141:AH144,AH135:AH138,AH126:AH130,AH120:AH123,AH114:AH117)","v":1015696.8556302118},1188262.2342310022]
[]
[]
[null,null,"END"]

{"sheet":"Calc | Existing Revenue","index":4,"n_rows":142,"n_cols":8,"rows_kept":142,"cut":false,"hidden":false,"merged":[[1,2,1,6]]}
[null,null,null,null,null,"Section Check",{"$f":"IF(COUNTA($A$18:$A$141)=COUNTIF($A$18:$A$141,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[]
[]
[]
[]
[null,null,"Calc | Total Revenue 2015-16"]
[]
[null,null,"Summary"]
[]
[null,null,"Total Revenue","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Volume market ","Calculated","$","$real2016",null,{"$f":"H48+H76","v":66008369.461618997}]
[null,null,"Demand market","Calculated","$","$real2016",null,{"$f":"H88+H112","v":2950992.9827700201}]
[null,null,"Ancillary Services","Calculated","$","$real2016",null,{"$f":"H139","v":1494505.3305548565}]
[]
[null,null,"Total","Calculated","$","$real2016",null,{"$f":"SUM(H12:H14)","v":70453867.774943873}]
[]
[{"$f":"IF(COUNTA($H18:$H18)=COUNTIF($H18:$H18,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,null,null,null,"Ok/Check",null,{"$f":"IF(ROUND(H16-SUM(H48,H76,H88,H112,H139),6)=0,\"Ok\",\"Check\")","v":"Ok"}]
[]
[null,null,"Calc | Volume market Revenue"]
[]
[null,null,"Customer Numbers Fixed Charges"]
[]
[null,null,"A.  Charge components per year","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Fixed Charge","Core Energy",{"$f":"number","v":"number"},null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!$I$86","v":139772.47014473766}]
[null,null,"Provision of basic metering <6m3/hr","Core Energy",{"$f":"number","v":"number"},null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!$I$53","v":134880.43368967183}]
[null,null,"Provision of basic metering >6m3/hr (variable charge)","Core Energy","GJ",null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!$I$66","v":2057021.9412123123}]
[null,null,"Quarterly meter reading charge","Core Energy",{"$f":"number","v":"number"},null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!$I$85","v":133902.02639865867}]
[null,null,"Monthly meter reading charge","Core Energy",{"$f":"number","v":"number"},null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!$I$84","v":5870.4437460789823}]
[]
[null,null,"B.  2015-16 prices","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Fixed Charge","AAD","$/pa","$real2016",null,52.58]
[null,null,"Provision of basic metering <6m3/hr","AAD","$/pa","$real2016",null,31.58]
[null,null,"Provision of basic metering >6m3/hr (variable charge)","AAD","$/GJ","$real2016",null,0.2606]
[null,null,"Quarterly meter reading charge","AAD","$/pa","$real2016",null,5.39]
[null,null,"Monthly meter reading charge","AAD","$/pa","$real2016",null,51.19]
[]
[null,null,"C. Revenue","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Fixed Charge","calculated","$","$real2016",null,{"$f":"H26*H34","v":7349236.4802103061}]
[null,null,"Provision of basic metering <6m3/hr","calculated","$","$real2016",null,{"$f":"H27*H35","v":4259524.0959198363}]
[null,null,"Provision of basic metering >6m3/hr (variable charge)","calculated","$","$real2016",null,536059.9178799286]
[null,null,"Quarterly meter reading charge","calculated","$","$real2016",null,721731.92228877021]
[null,null,"Monthly meter reading charge","calculated","$","$real2016",null,300508.01536178309]
[]
[null,null,"Total ","calculated","$","$real2016",null,{"$f":"SUM(H42:H46)","v":13167060.431660622}]
[]
[]
[null,null,"Consumption"]
[]
[null,null,"A.  Consumption by block","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Block 1 ","Core Energy","GJ",null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!I35","v":1452991.0021958598}]
[null,null,"Block 2","Core Energy","GJ",null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!I36","v":4185481.5436388198}]
[null,null,"Block 3","Core Energy","GJ",null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!I37","v":559382.40075758076}]
[null,null,"Block 4","Core Energy","GJ",null,null,{"$f":"'[2]Tariff_Pricing Block_Org'!I38","v":180507.66181801065}]
[]
[null,null,"Total","Calculated","GJ",null,null,{"$f":"SUM(H55:H58)","v":6378362.6084102709}]
[]
[null,null,"B.  2015-16 prices","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Block 1 ","AAD","$/GJ","$real2016",null,9.9700000000000006]
[null,null,"Block 2","AAD","$/GJ","$real2016",null,7.96]
[null,null,"Block 3","AAD","$/GJ","$real2016",null,7.31]
[null,null,"Block 4","AAD","$/GJ","$real2016",null,5.26]
[]
[null,null,"C. Revenue","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Block 1 ","calculated","$","$real2016",null,{"$f":"H55*H64","v":14486320.291892722}]
[null,null,"Block 2","calculated","$","$real2016",null,{"$f":"H56*H65","v":33316433.087365005}]
[null,null,"Block 3","calculated","$","$real2016",null,4089085.3495379151]
[null,null,"Block 4","calculated","$","$real2016",null,949470.30116273591]
[]
[null,null,"Total","Calculated","$","$real2016",null,{"$f":"SUM(H71:H74)","v":52841309.029958375}]
[]
[null,null,"Calc | Demand market Revenue"]
[]
[null,null,"Meterin Charge components"]
[]
[null,null,"A.  Revenue from Metering charge components ","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Basic Metering Equipment Charge ","AAD","$","$real2016",null,{"$f":"'[3]Calc | 2015-2016 Demand Market'!$O$60","v":468846}]
[null,null,"Meter Communications charge","AAD","$","$real2016",null,{"$f":"'[3]Calc | 2015-2016 Demand Market'!$P$60","v":82485}]
[null,null,"Meter Reading Charge","AAD","$","$real2016",null,{"$f":"'[3]Calc | 2015-2016 Demand Market'!$Q$60","v":41474.139999999992}]
[]
[null,null,"Total","Calculated","$","$real2016",null,{"$f":"SUM(H84:H86)","v":592805.14}]
[]
[null,null,"Consumption"]
[]
[null,null,"Consumption","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Demand market ","Core Energy","GJ",null,null,{"$f":"[2]Summary!$P$88","v":1201835.7760209541}]
[null,null,"MDQ","Core Energy","GJ",null,null,{"$f":"[2]Summary!$P$93","v":8024.8223691931626}]
[]
[null,null,"A.  Assumptions","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Chargeable Throughput ","AAD","GJ"]
[null,null,"Chargeable Capacity ","AAD","GJ",null,null,{"$f":"H95-'[3]Calc | 2015-2016 Demand Market'!$J$27","v":7224.8223691931626}]
[]
[null,null,"B.  2015-16 prices","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Throughput","AAD","$/GJ","$real2016",null,4.4589999999999996]
[null,null,"Capacity ","AAD","$/GJ of MDQ","$real2016",null,304.25]
[]
[null,null,"C. Revenue","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Throughput","calculated","$","$real2016"]
[null,null,"Capacity ","calculated","$","$real2016",null,{"$f":"H100*H105","v":2198152.2058270196}]
[]
[null,null,"Total","Calculated","$","$real2016",null,2358187.84277002]
[]
[null,null,"Calc | Ancillary Service Revenue"]
[]
[null,null,"Ancillary Services"]
[]
[null,null,"A. Ancillary Services number ","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Volume market reconnections","Core Energy",{"$f":"number","v":"number"},null,null,{"$f":"'[2]Pricing Block Summary'!I57+'[2]Pricing Block Summary'!$I$135","v":119}]
[null,null,"Volume market disconnections","Core Energy",{"$f":"number","v":"number"},null,null,{"$f":"'[2]Pricing Block Summary'!I60+'[2]Pricing Block Summary'!I63+'[2]Pricing Block Summary'!I138+'[2]Pricing Block Summary'!I141","v":748.83413989097903}]
[null,null,"Volume market special meter reads","Core Energy",{"$f":"number","v":"number"},null,null,{"$f":"'[2]Pricing Block Summary'!I66+'[2]Pricing Block Summary'!I144","v":25721}]
[null,null,"Demand Market RFS hours","Core Energy",{"$f":"number","v":"number"},null,null,{"$f":"'[2]Pricing Block Summary'!$I$147","v":5.5}]
[]
[null,null,"B.  2015-16 prices","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Volume market reconnections","AAD","$","$real2016",null,101.28]
[null,null,"Volume market disconnections","AAD","$","$real2016",null,137.07]
[null,null,"Volume market special meter reads","AAD","$","$real2016",null,53.63]
[null,null,"Demand Market RFS hours","AAD","$","$real2016",null,71.47]
[]
[null,null,"C. Revenue","Source","Unit","Basis",null,"2015-2016"]
[]
[null,null,"Volume market reconnections","calculated","$","$real2016",null,{"$f":"H120*H127","v":12052.32}]
[null,null,"Volume market disconnections","calculated","$","$real2016",null,{"$f":"H121*H128","v":102642.69555485649}]
[null,null,"Volume market special meter reads","calculated","$","$real2016",null,1379417.23]
[null,null,"Demand Market RFS hours","calculated","$","$real2016",null,393.08499999999998]
[]
[null,null,"Total","Calculated","$","$real2016",null,{"$f":"SUM(H134:H137)","v":1494505.3305548565}]
[]
[]
[null,null,"END"]