{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Index","Inputs","Calc|Expenditure","Calc|Contributions","Outputs","Lookup|Tables","Check|List"],"not_rendered":{"charts":2,"images":2,"macros":0,"external_links":0,"defined_names":41,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4]]}
[null,null,"JEN Reopener - Unforeseen Major Connections Model",null,null,null,null,null,null,null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,"Index"]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Model Index"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Index","Model index with hyperlinks"]
[null,null,"Inputs","Data for inflation, cost escalators, project expenditure, and volumes"]
[null,null,"Calc|Expenditure","Calculates the expenditure for each project in the terms needed to input to the Capex Forecast Model"]
[null,null,"Calc|Contributions","Estimates the contribution rates to apply to data centre and non-data centre connections"]
[null,null,"Outputs","Outputs the expenditure and other inputs needed to the Capex Forecast Model and to estimate bill impacts"]
[null,null,"Lookup|Tables","Source for named ranges used for units, basis, etc"]
[null,null,"Check|List","Check for errors"]
[]
[]
[]
[null,"End"]

{"sheet":"Inputs","index":1,"n_rows":115,"n_cols":36,"rows_kept":115,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JEN Reopener - Unforeseen Major Connections Model"},null,null,"Back to Index",null,"Key:","Input (hard code)","External Link","Internal Link","Drop down Selection","Calculation","Unique calculation","Empty cell",null,null,"Section Check:",{"$f":"IF(COUNTA($A$115:$A$115)=COUNTIF($A$115:$A$115,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Inputs"}]
[null,null,null,"Source","Unit","Basis",null,null,{"$f":"+J3-1","v":2022},{"$f":"+K3-1","v":2023},{"$f":"+L3-1","v":2024},{"$f":"+M3-1","v":2025},2026,null,{"$f":"I3","v":2022},{"$f":"J3","v":2023},{"$f":"K3","v":2024},{"$f":"L3","v":2025},{"$f":"M3","v":2026},{"$f":"S3+1","v":2027},{"$f":"T3+1","v":2028},{"$f":"U3+1","v":2029},{"$f":"V3+1","v":2030},{"$f":"W3+1","v":2031}]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Input | Inflation and Escalation"]
[]
[null,null,"Inflation","Source","Unit","Basis",null,null,{"$f":"\"RY\"&RIGHT(I$3,2)","v":"RY22"},{"$f":"\"RY\"&RIGHT(J$3,2)","v":"RY23"},{"$f":"\"RY\"&RIGHT(K$3,2)","v":"RY24"},{"$f":"\"RY\"&RIGHT(L$3,2)","v":"RY25"},{"$f":"\"RY\"&RIGHT(M$3,2)","v":"RY26"}]
[]
[null,null,"Actual inflation (year to Dec, lagged as per RFM)","ABS","Per cent","n/a",null,null,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2]
[]
[null,null,"Conversion indexes"]
[null,null,"From Real CY18 (Mid Period) to Real Jan21-Jun21 (End Period)","AER","Index","n/a",null,null,1.0597841134352428,{"$f":"I14","v":1.0597841134352428},{"$f":"J14","v":1.0597841134352428},{"$f":"K14","v":1.0597841134352428},{"$f":"L14","v":1.0597841134352428}]
[null,null,"From Real FY24 (Mid Period) to Real CY18 (Mid Period)","Calculated","Index","n/a",null,null,null,null,null,{"$f":"1/(I14*(1+I11)*(1+J11)*(1+K11)^0.5)","v":0.87047128780973582},{"$f":"L15","v":0.87047128780973582}]
[null,null,"Nominal to Real CY18 (Mid Period)","Calculated","Index","n/a",null,null,{"$f":"1/I14/(1+I11)^0.5","v":0.93955423228187163},{"$f":"I16/(1+I11)^0.5/(1+J11)^0.5","v":0.91959058624447843},{"$f":"J16/(1+J11)^0.5/(1+K11)^0.5","v":0.87047128780973593}]
[null,null,"To Real CY18 (Mid Period)","Calculated","Index","n/a",null,null,{"$f":"SUM(I15:I16)","v":0.93955423228187163},{"$f":"SUM(J15:J16)","v":0.91959058624447843},{"$f":"SUM(K15:K16)","v":0.87047128780973593},{"$f":"SUM(L15:L16)","v":0.87047128780973582},{"$f":"SUM(M15:M16)","v":0.87047128780973582}]
[]
[{"$f":"IF(SUM(I19:M19)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,null,{"$f":"+IF(COUNT(ISERROR(I11:I17))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(J11:J17))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(K11:K17))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(L11:L17))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(M11:M17))=0,0,1)","v":0}]
[]
[]
[null,null,"Real Escalation","Source","Unit","Basis","Activity Code",null,{"$f":"\"RY\"&RIGHT(I$3,2)","v":"RY22"},{"$f":"\"RY\"&RIGHT(J$3,2)","v":"RY23"},{"$f":"\"RY\"&RIGHT(K$3,2)","v":"RY24"},{"$f":"\"RY\"&RIGHT(L$3,2)","v":"RY25"},{"$f":"\"RY\"&RIGHT(M$3,2)","v":"RY26"},"◄ Escalator series held constant from RY24 to RY26 as forecasts for FY25 and FY26 are in 2024 dollars."]
[]
[null,null,"BUS. SUPPLY PROJECT>10KVA - HV CUSTOMERS","AER","Index","n/a","CBH",null,1.0076100319662387,1.0087777013545733,1.0098522417748492,{"$f":"K24","v":1.0098522417748492},{"$f":"L24","v":1.0098522417748492}]
[null,null,"BUS. SUPPLY PROJECT>10KVA - INDOOR SUBS.","AER","Index","n/a","CBI",null,1.0120229679372468,1.0138729168556533,1.0155764585232299,1.0155764585232299,1.0155764585232299]
[null,null,{"$f":"\"PROJECTS SIMILAR TO: \"&C27","v":"PROJECTS SIMILAR TO: SUBTRANS SYSTEM AUG - CAPACITY RELATED"},"AER","Index","n/a","CBT",null,{"$f":"I27","v":1.0114994315217898},{"$f":"J27","v":1.0132682392653318},1.0148969324858901,1.0148969324858901,1.0148969324858901,"◄ The CBT activity code was not allowed for in the 2021-26 determination capex model. However, the activities are similar in nature to those covered by the DOA activity code."]
[null,null,"SUBTRANS SYSTEM AUG - CAPACITY RELATED","AER","Index","n/a","DOA",null,1.0114994315217898,1.0132682392653318,1.0148969324858901,1.0148969324858901,1.0148969324858901]
[]
[{"$f":"IF(SUM(I29:M29)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,null,{"$f":"+IF(COUNT(ISERROR(I24:I27))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(J24:J27))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(K24:K27))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(L24:L27))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(M24:M27))=0,0,1)","v":0}]
[]
[]
[null,"Input | Connection Projects"]
[]
[null,null,null,null,null,null,null,null,"Gross capital expenditure ($Million)",null,null,null,null,null,"Energy consumption (MWh)",null,null,null,null,null,null,null,null,null,null,"Contribution Data"]
[null,null,null,null,null,null,null,null,"Actual ($nominal)",null,null,"Forecast ($2024)",null,null,"Actual",null,null,"Forecast",null,null,null,null,null,null,null,"Offered or Contracted ($Million)",null,null,null,"Project Details"]
[null,null,"Project","Source","Unit","Basis",null,null,{"$f":"\"RY\"&RIGHT(I$3,2)","v":"RY22"},"RY23","RY24","RY25","RY26",null,"RY22","RY23","RY24","RY25","RY26","RY27","RY28","RY29","RY30","RY31",null,"Contribution","ICCS","Ratio",null,"Type","Capacity (MW)","Data notified","Activity Code","Asset Class","WSB 1","WSB 2"]
[]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0.27751566,5.8300300000000008E-3,3.1797829999999999E-2,0,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,0,0.28854800000000003,{"$f":"IF(ISBLANK(AA38),NA(),IF(AA38=0,0,Z38/AA38))","v":0},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,7.4551329999999999E-2,0.27537009000000001,2.6738141400000002,3.7377987404083748,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,20.364494000000001,12.017258999999999,1.6946039026037469,null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,2.4870000000000001E-3,1.0553530955337171,2.4509168008286468,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$f":"IF(ISBLANK(AA40),NA(),IF(AA40=0,0,Z40/AA40))","v":{"$error":"#N/A"}},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,2.8623099999999999E-3,5.6163806677724804,15.610452995220356,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,1.4514119600000002,2.3420873982835957,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,3.9935288300000003,3.77360987,1.0582781388580584,null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0.26662565000000005,0.13119779000000001,5.5649300899999998,16.091490936422222,5.3172122716947641,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,17.425643999999998,45.490096999999999,0.38306456018328561,null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,3.0946089999999999E-2,2.5072111100220784,4.0376274575380169,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$f":"AB43","v":0.38306456018328561},"◄ Covered by DC04 contribution above","Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,2.5323527484832211,6.2862785592777586,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$f":"AB44","v":0.38306456018328561},"◄ Covered by DC04 contribution above","Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,3.5871720000000003E-2,1.0117021500000001,4.0211411899999998,9.0205733455634429E-3,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,6.0471527400000005,6.4637820000000001,0.93554404217221443,null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0.94583571999999994,8.42625344,10.349664700000002,1.5531486201054505,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,15.695275000000001,22.221361000000002,{"$f":"IF(ISBLANK(AA47),NA(),IF(AA47=0,0,Z47/AA47))","v":0.7063147482280675},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,4.4581937174830024,9.3160072029048564,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,2.9055940000000002E-2,0.10175789,3.6847308033021409,9.8526025098245906,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,2.8110000000000001E-3,0.57411487616393897,1.3826602999785231,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,1.2569139999999999E-2,6.623387E-2,0.63372222726308203,6.023478299376726,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$f":"IF(ISBLANK(AA51),NA(),IF(AA51=0,0,Z51/AA51))","v":{"$error":"#N/A"}},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,0,0.8324004945429887,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,3.4083820000000001E-2,1.6814517000000002,7.7072661984090312,9.3075463534226248,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$f":"IF(ISBLANK(AA53),NA(),IF(AA53=0,0,Z53/AA53))","v":{"$error":"#N/A"}},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,0.80189853599999983,0.87571346399999983,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,7.0430809999999996E-2,0.19080231,5.1083810000000007E-2,4.6387135787455049,10.910383341246163,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,4.0920000000000002E-3,0,0.99685359708458809,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,2.6915200000000002E-3,5.8500000000000002E-4,4.6100766319833397,11.194012028872804,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,0.57411487616393897,1.3826602999785231,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,1.6892228023768425,4.1200556155532739,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,3.6288880000000003E-2,2.7804783470952312,10.363482969179858,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,30.146262,25.391283999999999,1.1872681192491092,null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,0,1.3498914950136525,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$f":"AB60","v":1.1872681192491092},"◄ Covered by DC18 contribution above","Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,1.4940879999999998E-2,2.6545371410165011,7.0539238514070579,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$f":"IF(ISBLANK(AA62),NA(),IF(AA62=0,0,Z62/AA62))","v":{"$error":"#N/A"}},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,0.57411487616393897,1.3826602999785231,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,1.6892228023768425,4.1200556155532739,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,4.6406249999999991,11.137499999999998,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,0.57411487616393897,1.3826602999785231,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Data centre","[c-i-c]","[c-i-c]","CBT","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,1.1131516299999999,7.5948390000000005E-2,0,0,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,0.52568039,1.08825967,{"$f":"IF(ISBLANK(AA67),NA(),IF(AA67=0,0,Z67/AA67))","v":0.48304683568766266},null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0.10010471999999999,2.116709E-2,0,0,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,0,0.39971299999999998,0,null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,5.5200467599999996,5.7025257199999997,1.6143209999999998E-2,0,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,13.175968560000001,15.17056,0.86852222726122186,null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,2.7510975899999996,1.3511979200341644,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,2.94293761,2.9807759200000001,{"$f":"IF(ISBLANK(AA70),NA(),IF(AA70=0,0,Z70/AA70))","v":0.98730588577755285},null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,8.9502850000000009E-2,4.4729499999999978E-2,1.7679618925553434E-2,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBI","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,2.6411999999999998E-3,2.365167E-2,0.9647191588897881,0.65,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,9.8974720000000002E-2,0.24552768999999999,0.40311021538955549,null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,9.8699400000000007E-3,2.8119507422836776,4.7264104272662442,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$f":"IF(ISBLANK(AA73),NA(),IF(AA73=0,0,Z73/AA73))","v":{"$error":"#N/A"}},null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,0,1.2514118945185463E-3,5.7979913311289391,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,6.7719420000000002E-2,1.8565346001116647,2.5727154664093725,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBI","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,9.8209660000000004E-2,1.9960763129750893E-2,0,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,4.1274392899999999,4.3763550000000002,0.9431225963158838,null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,7.5449000000000002E-4,3.4563400000000001E-2,0.22596035207460236,2.4991654599999999,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Subtransmission","[c-i-c]","[c-i-c]"]
[null,null,"[c-i-c]","JEN","Various","Various",null,null,0,0,7.0641079999999981E-2,2.0105630629445508,2.782053652485911,null,"[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]","[c-i-c]",null,null,null,{"$error":"#N/A"},null,"Major infrastructure project","[c-i-c]","[c-i-c]","CBH","SCS - Distribution system assets","[c-i-c]","[c-i-c]"]
[]
[null,null,"Total Connection Projects","Calculated","Various","Various",null,null,{"$f":"SUM(I38:I79)","v":8.4041339999999991},{"$f":"SUM(J38:J79)","v":16.012095969999997},{"$f":"SUM(K38:K79)","v":29.204925810000006},{"$f":"SUM(L38:L79)","v":86.989808811372257},{"$f":"SUM(M38:M79)","v":155.71537245974653},null,10673.294000000002,24105.298649999997,33755.062920000004,411791.88978159998,622446.73669280007,868691.76593360002,1046021.5025039999,1142480.6325039999,1206324.4575039998,1364305.397504]
[]
[{"$f":"IF(SUM(I82:AB82)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,null,{"$f":"+IF(COUNT(ISERROR(I38:I79))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(J38:J79))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(K38:K79))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(L38:L79))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(M38:M79))=0,0,1)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"+IF(COUNT(ISERROR(Z38:Z79))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(AA38:AA79))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(AB38:AB79))=0,0,1)","v":0}]
[]
[]
[null,"Input | Augmentation Projects"]
[]
[null,null,null,null,null,null,null,null,"Gross capital expenditure ($Million)"]
[null,null,null,null,null,null,null,null,"Actual ($nominal)",null,null,"Forecast ($2024)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Details"]
[null,null,"Project","Source","Unit","Basis",null,null,{"$f":"\"RY\"&RIGHT(I$3,2)","v":"RY22"},{"$f":"\"RY\"&RIGHT(J$3,2)","v":"RY23"},{"$f":"\"RY\"&RIGHT(K$3,2)","v":"RY24"},{"$f":"\"RY\"&RIGHT(L$3,2)","v":"RY25"},{"$f":"\"RY\"&RIGHT(M$3,2)","v":"RY26"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type","Capacity (MW)","Data notified","Activity Code","Asset Class","WSB 1","WSB 2"]
[]
[null,null,"Augex - DC11&DC20 - ST-SSS 66kV line extension","JEN","Various","Various",null,null,0,0,0.10132389,3.9513885837055946,5.2766634672984409,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data centre",null,null,"DOA","SCS - Subtransmission","BAA-DOA-000030",0]
[null,null,"Augex - DC12&DC18&DC01 - augment KTS-AW","JEN","Various","Various",null,null,0,0,4.4159999999999998E-3,0,2.008435906584495,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data centre",null,null,"DOA","SCS - Subtransmission","BAA-DOA-000038","BAA-DOA-000032"]
[null,null,"Augex - DC02&DC09 - New 66kV line incomer at FW","JEN","Various","Various",null,null,0,0,2.343E-3,0,0.95466293821485704,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data centre",null,null,"DOA","SCS - Subtransmission","BAA-DOA-999999","BAA-CBT-000006"]
[null,null,"Augex - DC02&DC09 - Tie TH-FW 66kV loops","JEN","Various","Various",null,null,0,0,0,0.81296090226278661,1.9828314689336251,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data centre",null,null,"DOA","SCS - Subtransmission","BAA-DOA-000035",0]
[]
[null,null,"Total Augmentation Projects","Calculated","Various","Various",null,null,{"$f":"SUM(I91:I95)","v":0},{"$f":"SUM(J91:J95)","v":0},{"$f":"SUM(K91:K95)","v":0.10808289},{"$f":"SUM(L91:L95)","v":4.7643494859683813},{"$f":"SUM(M91:M95)","v":10.222593781031419}]
[]
[{"$f":"IF(SUM(I98:M98)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,null,{"$f":"+IF(COUNT(ISERROR(I91:I95))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(J91:J95))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(K91:K95))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(L91:L95))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(M91:M95))=0,0,1)","v":0}]
[]
[]
[null,"Input | Contributions"]
[]
[null,null,"Input","Source","Unit","Basis",null,null,"Rate",null,"Type"]
[]
[null,null,"Contribution Rates Adopted for 2021-26"]
[null,null,"Residential Developments","AER","Per cent","n/a",null,null,0.31900000000000001,null,"Other"]
[null,null,"Medium Density Housing","AER","Per cent","n/a",null,null,0.45900000000000002,null,"Other"]
[null,null,"Pole to Pit","AER","Per cent","n/a",null,null,0.70699999999999996,null,"Ignore"]
[null,null,"Data Centre","AER","Per cent","n/a",null,null,0.58344820295983091,null,"Data Centre"]
[null,null,"Infrastructure Projects","AER","Per cent","n/a",null,null,0.62,null,"Other"]
[null,null,"Capital Recoverable Works","AER","Per cent","n/a",null,null,0.99,null,"Ignore"]
[null,null,"Capital Recoverable Works (Emergency)","AER","Per cent","n/a",null,null,1,null,"Ignore"]
[]
[]
[null,"End"]

{"sheet":"Calc|Expenditure","index":2,"n_rows":89,"n_cols":22,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JEN Reopener - Unforeseen Major Connections Model"},null,null,"Back to Index",null,"Key:","Input (hard code)","External Link","Internal Link","Drop down Selection","Calculation","Unique calculation","Empty cell",null,null,"Section Check:",{"$f":"IF(COUNTA($A$7:$A$89)=COUNTIF($A$7:$A$89,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Calc|Expenditure"}]
[null,null,null,"Source","Unit","Basis",null,null,{"$f":"+J3-1","v":2022},{"$f":"+K3-1","v":2023},{"$f":"+L3-1","v":2024},{"$f":"+M3-1","v":2025},{"$f":"+Inputs!$M$3","v":2026}]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Calc | Connection Projects"]
[]
[null,null,"Project","Source","Unit","Basis",null,null,{"$f":"\"RY\"&RIGHT(I$3,2)","v":"RY22"},{"$f":"\"RY\"&RIGHT(J$3,2)","v":"RY23"},{"$f":"\"RY\"&RIGHT(K$3,2)","v":"RY24"},{"$f":"\"RY\"&RIGHT(L$3,2)","v":"RY25"},{"$f":"\"RY\"&RIGHT(M$3,2)","v":"RY26"},"Total",null,"Type","Asset Class"]
[]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I38*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG38)","v":0.25877175157604365},{"$f":"Inputs!J38*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG38)","v":5.3145908145311839E-3},{"$f":"Inputs!K38*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG38)","v":2.7409057369628759E-2},{"$f":"Inputs!L38*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG38)","v":0},{"$f":"Inputs!M38*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG38)","v":0},{"$f":"SUM(I11:M11)","v":0.29149539976020356},null,{"$f":"Inputs!AD38","v":"Data centre"},{"$f":"Inputs!AH38","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I39*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG39)","v":6.9515998651836983E-2},{"$f":"Inputs!J39*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG39)","v":0.25102432593153468},{"$f":"Inputs!K39*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG39)","v":2.3047712739826771},{"$f":"Inputs!L39*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG39)","v":3.2219035107735103},{"$f":"Inputs!M39*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG39)","v":0},5.847215109339559,null,{"$f":"Inputs!AD39","v":"Data centre"},{"$f":"Inputs!AH39","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I40*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG40)","v":0},{"$f":"Inputs!J40*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG40)","v":0},{"$f":"Inputs!K40*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG40)","v":2.1330856597232949E-3},{"$f":"Inputs!L40*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG40)","v":0.90517030720850833},{"$f":"Inputs!M40*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG40)","v":2.1021373064022844},3.0094406992705158,null,{"$f":"Inputs!AD40","v":"Data centre"},{"$f":"Inputs!AH40","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I41*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG41)","v":0},{"$f":"Inputs!J41*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG41)","v":0},{"$f":"Inputs!K41*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG41)","v":2.467250721186386E-3},{"$f":"Inputs!L41*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG41)","v":4.8412014257781042},{"$f":"Inputs!M41*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG41)","v":13.455880533731005},18.299549210230296,null,{"$f":"Inputs!AD41","v":"Data centre"},{"$f":"Inputs!AH41","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I42*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG42)","v":0},{"$f":"Inputs!J42*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG42)","v":0},{"$f":"Inputs!K42*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG42)","v":1.251086431954801},{"$f":"Inputs!L42*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG42)","v":2.0188298341188573},{"$f":"Inputs!M42*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG42)","v":0},3.2699162660736585,null,{"$f":"Inputs!AD42","v":"Data centre"},{"$f":"Inputs!AH42","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I43*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG43)","v":0.24861727250131099},{"$f":"Inputs!J43*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG43)","v":0.1195984531161574},{"$f":"Inputs!K43*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG43)","v":4.7968521152161436},{"$f":"Inputs!L43*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG43)","v":13.870525071656079},{"$f":"Inputs!M43*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG43)","v":4.583324591689931},23.61891750417962,null,{"$f":"Inputs!AD43","v":"Data centre"},{"$f":"Inputs!AH43","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I44*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG44)","v":0},{"$f":"Inputs!J44*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG44)","v":0},{"$f":"Inputs!K44*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG44)","v":2.6542284199238625E-2},{"$f":"Inputs!L44*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG44)","v":2.1504206130627339},{"$f":"Inputs!M44*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG44)","v":3.4630499513387094},5.6400128486006817,null,{"$f":"Inputs!AD44","v":"Data centre"},{"$f":"Inputs!AH44","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I45*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG45)","v":0},{"$f":"Inputs!J45*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG45)","v":0},{"$f":"Inputs!K45*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG45)","v":0},{"$f":"Inputs!L45*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG45)","v":2.1719844524127185},{"$f":"Inputs!M45*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG45)","v":5.3917051257826296},7.5636895781953477,null,{"$f":"Inputs!AD45","v":"Data centre"},{"$f":"Inputs!AH45","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I46*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG46)","v":3.3448879304488248E-2},{"$f":"Inputs!J46*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG46)","v":0.92225648125849258},{"$f":"Inputs!K46*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG46)","v":3.4661387134935704},{"$f":"Inputs!L46*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG46)","v":7.7755435617931296E-3},{"$f":"Inputs!M46*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG46)","v":0},4.4296196176183447,null,{"$f":"Inputs!AD46","v":"Data centre"},{"$f":"Inputs!AH46","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I47*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG47)","v":0.88195226881102262},{"$f":"Inputs!J47*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG47)","v":7.6812793644519468},{"$f":"Inputs!K47*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG47)","v":8.9211922171645561},{"$f":"Inputs!L47*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG47)","v":1.3387812826230605},{"$f":"Inputs!M47*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG47)","v":0},18.823205133050585,null,{"$f":"Inputs!AD47","v":"Data centre"},{"$f":"Inputs!AH47","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I48*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG48)","v":0},{"$f":"Inputs!J48*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG48)","v":0},{"$f":"Inputs!K48*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG48)","v":0},{"$f":"Inputs!L48*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG48)","v":3.8428687544845075},{"$f":"Inputs!M48*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG48)","v":8.0302013024251622},11.87307005690967,null,{"$f":"Inputs!AD48","v":"Data centre"},{"$f":"Inputs!AH48","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I49*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG49)","v":0},{"$f":"Inputs!J49*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG49)","v":2.6487073279480414E-2},{"$f":"Inputs!K49*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG49)","v":8.7713150388638875E-2},{"$f":"Inputs!L49*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG49)","v":3.1761600706509414},{"$f":"Inputs!M49*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG49)","v":8.4927351153185757},11.783095409637637,null,{"$f":"Inputs!AD49","v":"Data centre"},{"$f":"Inputs!AH49","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I50*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG50)","v":0},{"$f":"Inputs!J50*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG50)","v":0},{"$f":"Inputs!K50*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG50)","v":2.4109786045364624E-3},{"$f":"Inputs!L50*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG50)","v":0.49241504196988878},{"$f":"Inputs!M50*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG50)","v":1.1858998223373127},1.680725842911738,null,{"$f":"Inputs!AD50","v":"Data centre"},{"$f":"Inputs!AH50","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I51*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG51)","v":0},{"$f":"Inputs!J51*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG51)","v":1.1457888894320693E-2},{"$f":"Inputs!K51*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG51)","v":5.7092195997102101E-2},{"$f":"Inputs!L51*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG51)","v":0.54625516531985763},{"$f":"Inputs!M51*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG51)","v":5.1921109796590059},5.8069162298702865,null,{"$f":"Inputs!AD51","v":"Data centre"},{"$f":"Inputs!AH51","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I52*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG52)","v":0},{"$f":"Inputs!J52*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG52)","v":0},{"$f":"Inputs!K52*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG52)","v":0},{"$f":"Inputs!L52*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG52)","v":0},{"$f":"Inputs!M52*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG52)","v":0.71394513793977799},0.71394513793977799,null,{"$f":"Inputs!AD52","v":"Data centre"},{"$f":"Inputs!AH52","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I53*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG53)","v":0},{"$f":"Inputs!J53*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG53)","v":3.1070433033129202E-2},{"$f":"Inputs!K53*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG53)","v":1.4493758256321205},{"$f":"Inputs!L53*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG53)","v":6.6435005594782304},{"$f":"Inputs!M53*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG53)","v":8.022908229003038},16.146855047146516,null,{"$f":"Inputs!AD53","v":"Data centre"},{"$f":"Inputs!AH53","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I54*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG54)","v":0},{"$f":"Inputs!J54*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG54)","v":0},{"$f":"Inputs!K54*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG54)","v":0},{"$f":"Inputs!L54*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG54)","v":0.69121958881613321},{"$f":"Inputs!M54*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG54)","v":0.75484649657326686},1.4460660853894001,null,{"$f":"Inputs!AD54","v":"Data centre"},{"$f":"Inputs!AH54","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I55*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG55)","v":6.5673786007678009E-2},{"$f":"Inputs!J55*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG55)","v":0.17393327377686416},{"$f":"Inputs!K55*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG55)","v":4.4033164494219124E-2},{"$f":"Inputs!L55*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG55)","v":3.9984730593600717},{"$f":"Inputs!M55*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG55)","v":9.4045198343678784},13.686633118006711,null,{"$f":"Inputs!AD55","v":"Data centre"},{"$f":"Inputs!AH55","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I56*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG56)","v":0},{"$f":"Inputs!J56*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG56)","v":0},{"$f":"Inputs!K56*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG56)","v":3.509684969677412E-3},{"$f":"Inputs!L56*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG56)","v":0},{"$f":"Inputs!M56*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG56)","v":0.85499562235010773},0.85850530731978514,null,{"$f":"Inputs!AD56","v":"Data centre"},{"$f":"Inputs!AH56","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I57*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG57)","v":0},{"$f":"Inputs!J57*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG57)","v":2.4535598391649737E-3},{"$f":"Inputs!K57*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG57)","v":5.0425763522959975E-4},{"$f":"Inputs!L57*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG57)","v":3.9737886165318912},{"$f":"Inputs!M57*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG57)","v":9.6490017682240925},13.625748202230378,null,{"$f":"Inputs!AD57","v":"Data centre"},{"$f":"Inputs!AH57","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I58*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG58)","v":0},{"$f":"Inputs!J58*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG58)","v":0},{"$f":"Inputs!K58*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG58)","v":0},{"$f":"Inputs!L58*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG58)","v":0.49241504196988878},{"$f":"Inputs!M58*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG58)","v":1.1858998223373127},1.6783148643072014,null,{"$f":"Inputs!AD58","v":"Data centre"},{"$f":"Inputs!AH58","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I59*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG59)","v":0},{"$f":"Inputs!J59*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG59)","v":0},{"$f":"Inputs!K59*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG59)","v":0},{"$f":"Inputs!L59*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG59)","v":1.4488367253026297},{"$f":"Inputs!M59*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG59)","v":3.5337481104942179},4.9825848357968479,null,{"$f":"Inputs!AD59","v":"Data centre"},{"$f":"Inputs!AH59","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I60*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG60)","v":0},{"$f":"Inputs!J60*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG60)","v":0},{"$f":"Inputs!K60*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG60)","v":3.1280247545180717E-2},{"$f":"Inputs!L60*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG60)","v":2.3967135660057219},{"$f":"Inputs!M60*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG60)","v":8.9331032731296833},11.361097086680585,null,{"$f":"Inputs!AD60","v":"Data centre"},{"$f":"Inputs!AH60","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I61*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG61)","v":0},{"$f":"Inputs!J61*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG61)","v":0},{"$f":"Inputs!K61*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG61)","v":0},{"$f":"Inputs!L61*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG61)","v":0},{"$f":"Inputs!M61*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG61)","v":1.1577942059493613},1.1577942059493613,null,{"$f":"Inputs!AD61","v":"Data centre"},{"$f":"Inputs!AH61","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I62*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG62)","v":0},{"$f":"Inputs!J62*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG62)","v":0},{"$f":"Inputs!K62*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG62)","v":1.2878722764186704E-2},{"$f":"Inputs!L62*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG62)","v":2.2881549083044841},{"$f":"Inputs!M62*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG62)","v":6.0803332656413556},8.381366896710027,null,{"$f":"Inputs!AD62","v":"Data centre"},{"$f":"Inputs!AH62","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I63*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG63)","v":0},{"$f":"Inputs!J63*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG63)","v":0},{"$f":"Inputs!K63*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG63)","v":0},{"$f":"Inputs!L63*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG63)","v":0.49241504196988878},{"$f":"Inputs!M63*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG63)","v":1.1858998223373127},1.6783148643072014,null,{"$f":"Inputs!AD63","v":"Data centre"},{"$f":"Inputs!AH63","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I64*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG64)","v":0},{"$f":"Inputs!J64*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG64)","v":0},{"$f":"Inputs!K64*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG64)","v":0},{"$f":"Inputs!L64*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG64)","v":1.4488367253026297},{"$f":"Inputs!M64*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG64)","v":3.5337481104942179},{"$f":"SUM(I37:M37)","v":4.9825848357968479},null,{"$f":"Inputs!AD64","v":"Data centre"},{"$f":"Inputs!AH64","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I65*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG65)","v":0},{"$f":"Inputs!J65*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG65)","v":0},{"$f":"Inputs!K65*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG65)","v":0},{"$f":"Inputs!L65*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG65)","v":4.000120664080959},{"$f":"Inputs!M65*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG65)","v":9.6002895937942991},13.600410257875257,null,{"$f":"Inputs!AD65","v":"Data centre"},{"$f":"Inputs!AH65","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I66*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG66)","v":0},{"$f":"Inputs!J66*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG66)","v":0},{"$f":"Inputs!K66*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG66)","v":0},{"$f":"Inputs!L66*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG66)","v":0.49241504196988878},{"$f":"Inputs!M66*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG66)","v":1.1858998223373127},{"$f":"SUM(I39:M39)","v":1.6783148643072014},null,{"$f":"Inputs!AD66","v":"Data centre"},{"$f":"Inputs!AH66","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I67*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG67)","v":1.0379673603458199},{"$f":"Inputs!J67*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG67)","v":6.9233711639979906E-2},{"$f":"Inputs!K67*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG67)","v":0},{"$f":"Inputs!L67*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG67)","v":0},{"$f":"Inputs!M67*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG67)","v":0},1.1072010719857999,null,{"$f":"Inputs!AD67","v":"Major infrastructure project"},{"$f":"Inputs!AH67","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I68*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG68)","v":9.3343466582856638E-2},{"$f":"Inputs!J68*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG68)","v":1.9295684942333892E-2},{"$f":"Inputs!K68*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG68)","v":0},{"$f":"Inputs!L68*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG68)","v":0},{"$f":"Inputs!M68*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG68)","v":0},0.11263915152519052,null,{"$f":"Inputs!AD68","v":"Major infrastructure project"},{"$f":"Inputs!AH68","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I69*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG69)","v":5.1472128414910507},{"$f":"Inputs!J69*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG69)","v":5.1983593242470141},{"$f":"Inputs!K69*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG69)","v":1.3915105811307395E-2},{"$f":"Inputs!L69*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG69)","v":0},{"$f":"Inputs!M69*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG69)","v":0},10.359487271549373,null,{"$f":"Inputs!AD69","v":"Major infrastructure project"},{"$f":"Inputs!AH69","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I70*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG70)","v":0},{"$f":"Inputs!J70*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG70)","v":0},{"$f":"Inputs!K70*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG70)","v":2.3713879743918818},{"$f":"Inputs!L70*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG70)","v":1.1647040476642421},{"$f":"Inputs!M70*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG70)","v":0},3.5360920220561241,null,{"$f":"Inputs!AD70","v":"Major infrastructure project"},{"$f":"Inputs!AH70","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I71*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG71)","v":0},{"$f":"Inputs!J71*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG71)","v":8.1179777991613578E-2},{"$f":"Inputs!K71*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG71)","v":3.8338566379042316E-2},{"$f":"Inputs!L71*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG71)","v":1.5153561826836951E-2},{"$f":"Inputs!M71*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG71)","v":0},{"$f":"SUM(I44:M44)","v":0.13467190619749284},null,{"$f":"Inputs!AD71","v":"Major infrastructure project"},{"$f":"Inputs!AH71","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I72*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG72)","v":0},{"$f":"Inputs!J72*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG72)","v":2.4076886841645343E-3},{"$f":"Inputs!K72*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG72)","v":2.0387239629796355E-2},{"$f":"Inputs!L72*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG72)","v":0.83156752431188552},{"$f":"Inputs!M72*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG72)","v":0.56028626136622195},1.4146487139920683,null,{"$f":"Inputs!AD72","v":"Major infrastructure project"},{"$f":"Inputs!AH72","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I73*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG73)","v":0},{"$f":"Inputs!J73*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG73)","v":0},{"$f":"Inputs!K73*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG73)","v":8.5076796653983534E-3},{"$f":"Inputs!L73*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG73)","v":2.4238421054462989},{"$f":"Inputs!M73*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG73)","v":4.0740658891928172},6.506415674304515,null,{"$f":"Inputs!AD73","v":"Major infrastructure project"},{"$f":"Inputs!AH73","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I74*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG74)","v":0},{"$f":"Inputs!J74*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG74)","v":0},{"$f":"Inputs!K74*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG74)","v":0},{"$f":"Inputs!L74*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG74)","v":1.0786906027831032E-3},{"$f":"Inputs!M74*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG74)","v":4.9977459790030734},4.9988246696058569,null,{"$f":"Inputs!AD74","v":"Major infrastructure project"},{"$f":"Inputs!AH74","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I75*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG75)","v":0},{"$f":"Inputs!J75*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG75)","v":0},{"$f":"Inputs!K75*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG75)","v":5.804369552130579E-2},{"$f":"Inputs!L75*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG75)","v":1.5912736561188896},{"$f":"Inputs!M75*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG75)","v":2.205126877861916},3.8544442295021115,null,{"$f":"Inputs!AD75","v":"Major infrastructure project"},{"$f":"Inputs!AH75","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I76*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG76)","v":0},{"$f":"Inputs!J76*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG76)","v":0},{"$f":"Inputs!K76*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG76)","v":8.4654651125304306E-2},{"$f":"Inputs!L76*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG76)","v":1.7205755919976699E-2},{"$f":"Inputs!M76*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG76)","v":0},0.101860407045281,null,{"$f":"Inputs!AD76","v":"Major infrastructure project"},{"$f":"Inputs!AH76","v":"SCS - Distribution system assets"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I77*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG77)","v":0},{"$f":"Inputs!J77*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG77)","v":6.8778473243802049E-4},{"$f":"Inputs!K77*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG77)","v":2.9792920255546581E-2},{"$f":"Inputs!L77*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG77)","v":0.19477304750903718},{"$f":"Inputs!M77*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG77)","v":2.1542278032599906},2.3794815557570126,null,{"$f":"Inputs!AD77","v":"Major infrastructure project"},{"$f":"Inputs!AH77","v":"SCS - Subtransmission"}]
[null,null,"[c-i-c]","Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I78*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG78)","v":0},{"$f":"Inputs!J78*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG78)","v":0},{"$f":"Inputs!K78*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG78)","v":6.0891117864726438E-2},{"$f":"Inputs!L78*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG78)","v":1.7330628642741881},{"$f":"Inputs!M78*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG78)","v":2.3980714459562664},4.1920254280951808,null,{"$f":"Inputs!AD78","v":"Major infrastructure project"},{"$f":"Inputs!AH78","v":"SCS - Distribution system assets"}]
[]
[null,null,"Total Connection Projects","Calculated","$Million","CY18 (Mid Period)",null,null,{"$f":"SUM(I11:I52)","v":7.8365036252721083},14.596039416633161,25.173309608436728,74.923841866387093,134.08350210029818,256.61319661702726]
[]
[{"$f":"IF(SUM(I55:N55)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,null,{"$f":"+IF(COUNT(ISERROR(I11:I52))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(J11:J52))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(K11:K52))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(L11:L52))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(M11:M52))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(N11:N52))=0,0,1)","v":0}]
[]
[]
[null,null,"Data Centres"]
[]
[null,null,"Distribution connected","Calculated","$Million","CY18 (Mid Period)",null,null,{"$f":"SUMIFS(I$11:I$52,$P$11:$P$52,$P60,$Q$11:$Q$52,$Q60)","v":1.5579799568523804},9.2224218845564554,22.418542868457646,45.644568013228479,60.161269408472506,{"$f":"SUM(I60:M60)","v":139.00478213156748},null,"Data centre","SCS - Distribution system assets"]
[null,null,"Subtransmission connected","Calculated","$Million","CY18 (Mid Period)",null,null,0,2.4535598391649737E-3,6.8847789334772508E-2,21.306612599484492,57.532708435185327,{"$f":"SUM(I61:M61)","v":78.910622383843759},null,"Data centre","SCS - Subtransmission"]
[]
[null,null,"Total Data Centre Connections","Calculated","$Million","CY18 (Mid Period)",null,null,{"$f":"SUM(I60:I61)","v":1.5579799568523804},9.2248754443956198,22.487390657792417,66.951180612712974,117.69397784365783,217.91540451541124]
[]
[null,null,"Major Infrastructure Projects"]
[]
[null,null,"Distribution connected","Calculated","$Million","CY18 (Mid Period)",null,null,{"$f":"SUMIFS(I$11:I$52,$P$11:$P$52,\"<>\"&$P60,$Q$11:$Q$52,$Q67)","v":6.2785236684197274},5.3704761875051066,2.656126030388763,7.7778882061651018,14.235296453380297,{"$f":"SUM(I67:M67)","v":36.318310545858992},null,null,"SCS - Distribution system assets"]
[null,null,"Subtransmission connected","Calculated","$Million","CY18 (Mid Period)",null,null,0,6.8778473243802049E-4,2.9792920255546581E-2,0.19477304750903718,2.1542278032599906,{"$f":"SUM(I68:M68)","v":2.3794815557570126},null,null,"SCS - Subtransmission"]
[]
[null,null,"Total Major Infrastructure Projects","Calculated","$Million","CY18 (Mid Period)",null,null,{"$f":"SUM(I67:I68)","v":6.2785236684197274},5.3711639722375448,2.6859189506443095,7.972661253674139,16.389524256640286,38.697792101616002]
[]
[{"$f":"IF(SUM(I72:N72)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: Totals balance",null,null,null,null,null,{"$f":"+IF(ROUND(I53-I63-I70,10)=0,0,1)","v":0},0,0,0,0,0]
[]
[]
[null,"Calc | Augmentation Projects"]
[]
[null,null,"Projects",{"$f":"+D$3","v":"Source"},{"$f":"+E$3","v":"Unit"},{"$f":"+F$3","v":"Basis"},null,null,{"$f":"\"RY\"&RIGHT(I$3,2)","v":"RY22"},{"$f":"\"RY\"&RIGHT(J$3,2)","v":"RY23"},{"$f":"\"RY\"&RIGHT(K$3,2)","v":"RY24"},{"$f":"\"RY\"&RIGHT(L$3,2)","v":"RY25"},{"$f":"\"RY\"&RIGHT(M$3,2)","v":"RY26"},"Total",null,null,"Asset Class"]
[]
[null,null,{"$f":"Inputs!C91","v":"Augex - DC11&DC20 - ST-SSS 66kV line extension"},"Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I91*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG91)","v":0},{"$f":"Inputs!J91*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG91)","v":0},{"$f":"Inputs!K91*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG91)","v":8.6904920284029172E-2},{"$f":"Inputs!L91*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG91)","v":3.3890833630465393},{"$f":"Inputs!M91*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG91)","v":4.5257640423321686},{"$f":"SUM(I79:M79)","v":8.0017523256627374},null,null,{"$f":"Inputs!AH91","v":"SCS - Subtransmission"}]
[null,null,{"$f":"Inputs!C92","v":"Augex - DC12&DC18&DC01 - augment KTS-AW"},"Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I92*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG92)","v":0},{"$f":"Inputs!J92*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG92)","v":0},{"$f":"Inputs!K92*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG92)","v":3.7875779144905791E-3},{"$f":"Inputs!L92*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG92)","v":0},{"$f":"Inputs!M92*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG92)","v":1.7226239770039169},{"$f":"SUM(I80:M80)","v":1.7264115549184074},null,null,{"$f":"Inputs!AH92","v":"SCS - Subtransmission"}]
[null,null,{"$f":"Inputs!C93","v":"Augex - DC02&DC09 - New 66kV line incomer at FW"},"Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I93*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG93)","v":0},{"$f":"Inputs!J93*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG93)","v":0},{"$f":"Inputs!K93*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG93)","v":2.0095776842507761E-3},{"$f":"Inputs!L93*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG93)","v":0},{"$f":"Inputs!M93*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG93)","v":0.81880893581641223},0.82081851350066304,null,null,{"$f":"Inputs!AH93","v":"SCS - Subtransmission"}]
[null,null,{"$f":"Inputs!C94","v":"Augex - DC02&DC09 - Tie TH-FW 66kV loops"},"Inputs","$Million","CY18 (Mid Period)",null,null,{"$f":"Inputs!I94*Inputs!I$17/_xlfn._xlws.FILTER(Inputs!I$24:I$27,Inputs!$G$24:$G$27=Inputs!$AG94)","v":0},{"$f":"Inputs!J94*Inputs!J$17/_xlfn._xlws.FILTER(Inputs!J$24:J$27,Inputs!$G$24:$G$27=Inputs!$AG94)","v":0},{"$f":"Inputs!K94*Inputs!K$17/_xlfn._xlws.FILTER(Inputs!K$24:K$27,Inputs!$G$24:$G$27=Inputs!$AG94)","v":0},{"$f":"Inputs!L94*Inputs!L$17/_xlfn._xlws.FILTER(Inputs!L$24:L$27,Inputs!$G$24:$G$27=Inputs!$AG94)","v":0.69727191094992402},{"$f":"Inputs!M94*Inputs!M$17/_xlfn._xlws.FILTER(Inputs!M$24:M$27,Inputs!$G$24:$G$27=Inputs!$AG94)","v":1.7006631974388386},2.3979351083887628,null,null,{"$f":"Inputs!AH94","v":"SCS - Subtransmission"}]
[]
[null,null,"Total Augmentation Projects","Calculated","$Million","CY18 (Mid Period)",null,null,{"$f":"SUM(I79:I83)","v":0},0,9.2702075882770532E-2,4.086355273996463,8.7678601525913358,12.946917502470571]
[]
[{"$f":"IF(SUM(I86:N86)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,null,{"$f":"+IF(COUNT(ISERROR(I79:I83))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(J79:J83))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(K79:K83))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(L79:L83))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(M79:M83))=0,0,1)","v":0},{"$f":"+IF(COUNT(ISERROR(N79:N83))=0,0,1)","v":0}]
[]
[]
[null,"End"]

{"sheet":"Calc|Contributions","index":3,"n_rows":109,"n_cols":23,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JEN Reopener - Unforeseen Major Connections Model"},null,null,"Back to Index",null,"Key:","Input (hard code)","External Link","Internal Link","Drop down Selection","Calculation","Unique calculation","Empty cell",null,null,"Section Check:",{"$f":"IF(COUNTA($A$109:$A$109)=COUNTIF($A$109:$A$109,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Calc|Contributions"}]
[null,null,null,"Source","Unit","Basis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V3+1","v":1}]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Calc | Raw Contribution Rate"]
[]
[null,null,"Project","Source","Unit","Basis",null,"Ratio",null,"Value ($Million)",null,"Include?",null,"Type"]
[]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB38","v":0},null,{"$f":"'Calc|Expenditure'!N11","v":0.29149539976020356},null,{"$f":"NOT(ISNA(H11))","v":true},null,{"$f":"Inputs!AD38","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB39","v":1.6946039026037469},null,{"$f":"'Calc|Expenditure'!N12","v":5.847215109339559},null,true,null,{"$f":"Inputs!AD39","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB40","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N13","v":3.0094406992705158},null,false,null,{"$f":"Inputs!AD40","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB41","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N14","v":18.299549210230296},null,false,null,{"$f":"Inputs!AD41","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB42","v":1.0582781388580584},null,{"$f":"'Calc|Expenditure'!N15","v":3.2699162660736585},null,true,null,{"$f":"Inputs!AD42","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB43","v":0.38306456018328561},null,{"$f":"'Calc|Expenditure'!N16","v":23.61891750417962},null,true,null,{"$f":"Inputs!AD43","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB44","v":0.38306456018328561},null,{"$f":"'Calc|Expenditure'!N17","v":5.6400128486006817},null,true,null,{"$f":"Inputs!AD44","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB45","v":0.38306456018328561},null,{"$f":"'Calc|Expenditure'!N18","v":7.5636895781953477},null,true,null,{"$f":"Inputs!AD45","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB46","v":0.93554404217221443},null,{"$f":"'Calc|Expenditure'!N19","v":4.4296196176183447},null,true,null,{"$f":"Inputs!AD46","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB47","v":0.7063147482280675},null,{"$f":"'Calc|Expenditure'!N20","v":18.823205133050585},null,true,null,{"$f":"Inputs!AD47","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB48","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N21","v":11.87307005690967},null,false,null,{"$f":"Inputs!AD48","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB49","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N22","v":11.783095409637637},null,false,null,{"$f":"Inputs!AD49","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB50","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N23","v":1.680725842911738},null,false,null,{"$f":"Inputs!AD50","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB51","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N24","v":5.8069162298702865},null,false,null,{"$f":"Inputs!AD51","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB52","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N25","v":0.71394513793977799},null,false,null,{"$f":"Inputs!AD52","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB53","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N26","v":16.146855047146516},null,false,null,{"$f":"Inputs!AD53","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB54","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N27","v":1.4460660853894001},null,false,null,{"$f":"Inputs!AD54","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB55","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N28","v":13.686633118006711},null,false,null,{"$f":"Inputs!AD55","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB56","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N29","v":0.85850530731978514},null,false,null,{"$f":"Inputs!AD56","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB57","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N30","v":13.625748202230378},null,false,null,{"$f":"Inputs!AD57","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB58","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N31","v":1.6783148643072014},null,false,null,{"$f":"Inputs!AD58","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB59","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N32","v":4.9825848357968479},null,false,null,{"$f":"Inputs!AD59","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB60","v":1.1872681192491092},null,{"$f":"'Calc|Expenditure'!N33","v":11.361097086680585},null,true,null,{"$f":"Inputs!AD60","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB61","v":1.1872681192491092},null,{"$f":"'Calc|Expenditure'!N34","v":1.1577942059493613},null,true,null,{"$f":"Inputs!AD61","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB62","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N35","v":8.381366896710027},null,false,null,{"$f":"Inputs!AD62","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB63","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N36","v":1.6783148643072014},null,false,null,{"$f":"Inputs!AD63","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB64","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N37","v":4.9825848357968479},null,false,null,{"$f":"Inputs!AD64","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB65","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N38","v":13.600410257875257},null,false,null,{"$f":"Inputs!AD65","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB66","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N39","v":1.6783148643072014},null,false,null,{"$f":"Inputs!AD66","v":"Data centre"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB67","v":0.48304683568766266},null,{"$f":"'Calc|Expenditure'!N40","v":1.1072010719857999},null,true,null,{"$f":"Inputs!AD67","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB68","v":0},null,{"$f":"'Calc|Expenditure'!N41","v":0.11263915152519052},null,true,null,{"$f":"Inputs!AD68","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB69","v":0.86852222726122186},null,{"$f":"'Calc|Expenditure'!N42","v":10.359487271549373},null,true,null,{"$f":"Inputs!AD69","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB70","v":0.98730588577755285},null,{"$f":"'Calc|Expenditure'!N43","v":3.5360920220561241},null,true,null,{"$f":"Inputs!AD70","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB71","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N44","v":0.13467190619749284},null,false,null,{"$f":"Inputs!AD71","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB72","v":0.40311021538955549},null,{"$f":"'Calc|Expenditure'!N45","v":1.4146487139920683},null,true,null,{"$f":"Inputs!AD72","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB73","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N46","v":6.506415674304515},null,false,null,{"$f":"Inputs!AD73","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB74","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N47","v":4.9988246696058569},null,false,null,{"$f":"Inputs!AD74","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB75","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N48","v":3.8544442295021115},null,false,null,{"$f":"Inputs!AD75","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB76","v":0.9431225963158838},null,{"$f":"'Calc|Expenditure'!N49","v":0.101860407045281},null,true,null,{"$f":"Inputs!AD76","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB77","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N50","v":2.3794815557570126},null,false,null,{"$f":"Inputs!AD77","v":"Major infrastructure project"}]
[null,null,"[c-i-c]","Inputs","Per cent","n/a",null,{"$f":"Inputs!AB78","v":{"$error":"#N/A"}},null,{"$f":"'Calc|Expenditure'!N51","v":4.1920254280951808},null,false,null,{"$f":"Inputs!AD78","v":"Major infrastructure project"}]
[]
[]
[null,null,"Weighted Average Contribution Rate","Source","Unit","Basis",null,"Ratio"]
[]
[null,null,"All","Calculated","Per cent","n/a",null,{"$f":"SUM(_xlfn._xlws.FILTER($H$11:$H$52*$J$11:$J$52,$L$11:$L$52))/SUM(_xlfn._xlws.FILTER($J$11:$J$52,$L$11:$L$52))","v":0.74483716536740419}]
[null,null,"Data Centres","Calculated","Per cent","n/a",null,{"$f":"SUM(_xlfn._xlws.FILTER($H$11:$H$52*$J$11:$J$52,($L$11:$L$52*($N$11:$N$52=$N$57))))/SUM(_xlfn._xlws.FILTER($J$11:$J$52,($L$11:$L$52*($N$11:$N$52=$N$57))))","v":0.72896301920290241},null,null,null,null,null,"Data centre"]
[null,null,"Major Infrastructure Projects","Calculated","Per cent","n/a",null,{"$f":"SUM(_xlfn._xlws.FILTER($H$11:$H$52*$J$11:$J$52,($L$11:$L$52*($N$11:$N$52<>$N$57))))/SUM(_xlfn._xlws.FILTER($J$11:$J$52,($L$11:$L$52*($N$11:$N$52<>$N$57))))","v":0.8231039163213939}]
[]
[{"$f":"IF(SUM(I60:N60)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,{"$f":"+IF(COUNT(ISERROR(H56:H58))=0,0,1)","v":0}]
[]
[]
[null,"Calc | Contribution Rate Comparison"]
[]
[null,null,"Data Centres","Source","Unit","Basis",null,"Ratio",null,"Type"]
[]
[null,null,"Weighted Average","Above","Per cent","n/a",null,{"$f":"H57","v":0.72896301920290241}]
[null,null,"2021-26 Determination","Inputs","Per cent","n/a",null,{"$f":"_xlfn._xlws.FILTER(Inputs!$I$106:$I$112,Inputs!$K$106:$K$112=$J68)","v":0.58344820295983091},null,"Data centre"]
[null,null,"Proposed","JEN","Per cent","n/a",null,{"$f":"H67","v":0.72896301920290241}]
[]
[{"$f":"IF(SUM(I71:N71)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,{"$f":"+IF(COUNT(ISERROR(H67:H69))=0,0,1)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Major Infrastructure Projects"]
[]
[null,null,"Weighted Average","Above","Per cent","n/a",null,{"$f":"H58","v":0.8231039163213939}]
[null,null,{"$f":"_xlfn._xlws.FILTER(Inputs!$C$106:$C$112,Inputs!$K$106:$K$112=$J88)","v":"Residential Developments"},"Inputs","Per cent","n/a",null,{"$f":"_xlfn._xlws.FILTER(Inputs!$I$106:$I$112,Inputs!$K$106:$K$112=$J88)","v":0.31900000000000001},null,"Other"]
[null,null,"Medium Density Housing","Inputs","Per cent","n/a",null,0.45900000000000002]
[null,null,"Infrastructure Projects","Inputs","Per cent","n/a",null,0.62]
[null,null,"Proposed","JEN","Per cent","n/a",null,{"$f":"H87","v":0.8231039163213939}]
[]
[{"$f":"IF(SUM(I93:N93)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: No errors",null,null,null,null,{"$f":"+IF(COUNT(ISERROR(H87:H91))=0,0,1)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"End"]

{"sheet":"Outputs","index":4,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,2,0,4],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JEN Reopener - Unforeseen Major Connections Model"},null,null,"Back to Index",null,"Key:","Input (hard code)","External Link","Internal Link","Drop down Selection","Calculation","Unique calculation","Empty cell",null,"Section Check:",{"$f":"IF(COUNTA($A$7:$A$32)=COUNTIF($A$7:$A$32,\"OK\"),\"OK\",\"Check\")","v":"OK"},null,"Overall Check:",{"$f":"'Check|List'!$V$1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Outputs"}]
[null,null,null,"Source","Unit","Basis",null,null,{"$f":"+J3-1","v":2022},{"$f":"+K3-1","v":2023},{"$f":"+L3-1","v":2024},{"$f":"+M3-1","v":2025},{"$f":"+Inputs!$M$3","v":2026},{"$f":"M3+1","v":2027},{"$f":"N3+1","v":2028},{"$f":"O3+1","v":2029},{"$f":"P3+1","v":2030},{"$f":"Q3+1","v":2031}]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Outputs | Capex Forecast Model"]
[]
[null,null,"Projects","Source","Unit","Basis",null,null,{"$f":"\"RY\"&RIGHT(I$3,2)","v":"RY22"},"RY23","RY24","RY25","RY26",null,"Actvity Code",null,"Contribution Rate",null,"Asset Class"]
[]
[null,null,"Unforseen Distribution Connections | Data Centres","Calc|Expenditure","$Million","CY18 (Mid Period)",null,null,{"$f":"'Calc|Expenditure'!I60","v":1.5579799568523804},{"$f":"'Calc|Expenditure'!J60","v":9.2224218845564554},{"$f":"'Calc|Expenditure'!K60","v":22.418542868457646},{"$f":"'Calc|Expenditure'!L60","v":45.644568013228479},{"$f":"'Calc|Expenditure'!M60","v":60.161269408472506},null,{"$f":"Inputs!$G$24","v":"CBH"},null,{"$f":"'Calc|Contributions'!$H$69","v":0.72896301920290241},null,{"$f":"'Calc|Expenditure'!Q60","v":"SCS - Distribution system assets"}]
[null,null,"Unforseen Subtransmission Connections | Data Centres","Calc|Expenditure","$Million","CY18 (Mid Period)",null,null,{"$f":"'Calc|Expenditure'!I61","v":0},{"$f":"'Calc|Expenditure'!J61","v":2.4535598391649737E-3},{"$f":"'Calc|Expenditure'!K61","v":6.8847789334772508E-2},{"$f":"'Calc|Expenditure'!L61","v":21.306612599484492},{"$f":"'Calc|Expenditure'!M61","v":57.532708435185327},null,{"$f":"Inputs!$G$24","v":"CBH"},null,{"$f":"'Calc|Contributions'!$H$69","v":0.72896301920290241},null,{"$f":"'Calc|Expenditure'!Q61","v":"SCS - Subtransmission"}]
[null,null,"Unforseen Distribution Connections | Major Infrastructure Projects","Calc|Expenditure","$Million","CY18 (Mid Period)",null,null,{"$f":"'Calc|Expenditure'!I67","v":6.2785236684197274},{"$f":"'Calc|Expenditure'!J67","v":5.3704761875051066},{"$f":"'Calc|Expenditure'!K67","v":2.656126030388763},{"$f":"'Calc|Expenditure'!L67","v":7.7778882061651018},{"$f":"'Calc|Expenditure'!M67","v":14.235296453380297},null,{"$f":"Inputs!$G$24","v":"CBH"},null,{"$f":"'Calc|Contributions'!$H$91","v":0.8231039163213939},null,{"$f":"'Calc|Expenditure'!Q67","v":"SCS - Distribution system assets"}]
[null,null,"Unforseen Subtransmission Connections | Major Infrastructure Projects","Calc|Expenditure","$Million","CY18 (Mid Period)",null,null,{"$f":"'Calc|Expenditure'!I68","v":0},{"$f":"'Calc|Expenditure'!J68","v":6.8778473243802049E-4},{"$f":"'Calc|Expenditure'!K68","v":2.9792920255546581E-2},{"$f":"'Calc|Expenditure'!L68","v":0.19477304750903718},{"$f":"'Calc|Expenditure'!M68","v":2.1542278032599906},null,{"$f":"Inputs!$G$24","v":"CBH"},null,{"$f":"'Calc|Contributions'!$H$91","v":0.8231039163213939},null,{"$f":"'Calc|Expenditure'!Q68","v":"SCS - Subtransmission"}]
[null,null,{"$f":"'Calc|Expenditure'!C79","v":"Augex - DC11&DC20 - ST-SSS 66kV line extension"},"Calc|Expenditure","$Million","CY18 (Mid Period)",null,null,{"$f":"'Calc|Expenditure'!I79","v":0},{"$f":"'Calc|Expenditure'!J79","v":0},{"$f":"'Calc|Expenditure'!K79","v":8.6904920284029172E-2},{"$f":"'Calc|Expenditure'!L79","v":3.3890833630465393},{"$f":"'Calc|Expenditure'!M79","v":4.5257640423321686},null,{"$f":"Inputs!$AG91","v":"DOA"},null,0,null,{"$f":"'Calc|Expenditure'!Q79","v":"SCS - Subtransmission"}]
[null,null,{"$f":"'Calc|Expenditure'!C80","v":"Augex - DC12&DC18&DC01 - augment KTS-AW"},"Calc|Expenditure","$Million","CY18 (Mid Period)",null,null,{"$f":"'Calc|Expenditure'!I80","v":0},{"$f":"'Calc|Expenditure'!J80","v":0},{"$f":"'Calc|Expenditure'!K80","v":3.7875779144905791E-3},{"$f":"'Calc|Expenditure'!L80","v":0},{"$f":"'Calc|Expenditure'!M80","v":1.7226239770039169},null,{"$f":"Inputs!$AG92","v":"DOA"},null,0,null,{"$f":"'Calc|Expenditure'!Q80","v":"SCS - Subtransmission"}]
[null,null,{"$f":"'Calc|Expenditure'!C81","v":"Augex - DC02&DC09 - New 66kV line incomer at FW"},"Calc|Expenditure","$Million","CY18 (Mid Period)",null,null,{"$f":"'Calc|Expenditure'!I81","v":0},{"$f":"'Calc|Expenditure'!J81","v":0},{"$f":"'Calc|Expenditure'!K81","v":2.0095776842507761E-3},{"$f":"'Calc|Expenditure'!L81","v":0},{"$f":"'Calc|Expenditure'!M81","v":0.81880893581641223},null,{"$f":"Inputs!$AG93","v":"DOA"},null,0,null,{"$f":"'Calc|Expenditure'!Q81","v":"SCS - Subtransmission"}]
[null,null,{"$f":"'Calc|Expenditure'!C82","v":"Augex - DC02&DC09 - Tie TH-FW 66kV loops"},"Calc|Expenditure","$Million","CY18 (Mid Period)",null,null,{"$f":"'Calc|Expenditure'!I82","v":0},{"$f":"'Calc|Expenditure'!J82","v":0},{"$f":"'Calc|Expenditure'!K82","v":0},{"$f":"'Calc|Expenditure'!L82","v":0.69727191094992402},{"$f":"'Calc|Expenditure'!M82","v":1.7006631974388386},null,{"$f":"Inputs!$AG94","v":"DOA"},null,0,null,{"$f":"'Calc|Expenditure'!Q82","v":"SCS - Subtransmission"}]
[]
[null,null,"Total Gross Capex","Calculated","$Million","CY18 (Mid Period)",null,null,{"$f":"SUM(I11:I18)","v":7.8365036252721083},{"$f":"SUM(J11:J18)","v":14.596039416633165},{"$f":"SUM(K11:K18)","v":25.266011684319498},{"$f":"SUM(L11:L18)","v":79.010197140383568},{"$f":"SUM(M11:M18)","v":142.85136225288943}]
[]
[{"$f":"IF(SUM(I22:M22)=0,\"Ok\",\"Check\")","v":"Ok"},null,"Check: Totals balance",null,null,null,null,null,{"$f":"+IF(ROUND(I20-'Calc|Expenditure'!I53-'Calc|Expenditure'!I84,10)=0,0,1)","v":0},{"$f":"+IF(ROUND(J20-'Calc|Expenditure'!J53-'Calc|Expenditure'!J84,10)=0,0,1)","v":0},{"$f":"+IF(ROUND(K20-'Calc|Expenditure'!K53-'Calc|Expenditure'!K84,10)=0,0,1)","v":0},{"$f":"+IF(ROUND(L20-'Calc|Expenditure'!L53-'Calc|Expenditure'!L84,10)=0,0,1)","v":0},{"$f":"+IF(ROUND(M20-'Calc|Expenditure'!M53-'Calc|Expenditure'!M84,10)=0,0,1)","v":0}]
[]
[]
[null,"Outputs | Bill Impacts"]
[]
[null,null,"Energy Delivered","Source","Unit","Basis",null,null,{"$f":"\"RY\"&RIGHT(I$3,2)","v":"RY22"},"RY23","RY24","RY25","RY26","RY27","RY28","RY29","RY30","RY31"]
[]
[{"$f":"+IF(ISNUMBER(SUM(I29:R29)),\"Ok\",\"Check\")","v":"Ok"},null,"Energy Delivered","Inputs","MWh","n/a",null,null,{"$f":"Inputs!O80","v":10673.294000000002},{"$f":"Inputs!P80","v":24105.298649999997},{"$f":"Inputs!Q80","v":33755.062920000004},{"$f":"Inputs!R80","v":411791.88978159998},{"$f":"Inputs!S80","v":622446.73669280007},{"$f":"Inputs!T80","v":868691.76593360002},{"$f":"Inputs!U80","v":1046021.5025039999},{"$f":"Inputs!V80","v":1142480.6325039999},{"$f":"Inputs!W80","v":1206324.4575039998},{"$f":"Inputs!X80","v":1364305.397504}]
[]
[]
[null,"End"]

{"sheet":"Lookup|Tables","index":5,"n_rows":84,"n_cols":22,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,2,0,6],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JEN Reopener - Unforeseen Major Connections Model"},null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,null,null,null,"Overall Check:",{"$f":"+'Check|List'!V1","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Lookup|Tables"}]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Lookup table"]
[]
[null,null,"Financial Unit Denomination","Source",null,null,"Ref"]
[null,null,"Dollars","JEN",null,null,"$dollars"]
[null,null,"Thousands","JEN",null,null,"$000"]
[null,null,"Millions","JEN",null,null,"$millions"]
[]
[null,null,"Non-financial Unit Denomination"]
[null,null,"Percent","JEN",null,null,"Per cent"]
[null,null,"Unit","JEN",null,null,"unit"]
[null,null,"Number","JEN",null,null,"number"]
[null,null,"Factor","JEN",null,null,"factor"]
[null,null,"Mains","JEN",null,null,"mains"]
[null,null,"Kilometres","JEN",null,null,"kms"]
[null,null,"Metres","JEN",null,null,"metres"]
[]
[null,null,"Periodicity"]
[null,null,"Actuals","JEN",null,null,"Actual"]
[null,null,"Forecast","JEN",null,null,"Fcast"]
[null,null,"Date","JEN",null,null,"date"]
[null,null,"Month","JEN",null,null,"month"]
[null,null,"Quarter","JEN",null,null,"quarter"]
[null,null,"Year","JEN",null,null,"year"]
[null,null,"Option","JEN",null,null,"option"]
[null,null,"Yes/No","JEN",null,null,"yes/no"]
[null,null,"Actuals/Forecast","JEN",null,null,"(A)/(F)"]
[]
[null,null,"Time Intervals"]
[null,null,"Number of months in a year","JEN",null,null,12]
[null,null,"Number of days in a year","JEN",null,null,365]
[null,null,"Number of weeks in a year","JEN",null,null,52]
[null,null,"Number of periods (years) in reg period","JEN",null,null,5]
[]
[null,null,"Cash flow timing"]
[null,null,"Start-year","JEN",null,null,-0.5]
[null,null,"Mid-year","JEN",null,null,0]
[null,null,"End-year","JEN",null,null,0.5]
[null,null,"Adjustment to mid-year","JEN",null,null,0.5]
[null,null,"Adjustment to end-year","JEN",null,null,1]
[]
[null,null,"Timing"]
[null,null,"Mid-year","JEN",null,null,"Mid-year"]
[null,null,"End-year","JEN",null,null,"End-year"]
[]
[null,null,"Yes/No",null,null,null,"[Select]"]
[null,null,"Yes","JEN",null,null,"Yes"]
[null,null,"No","JEN",null,null,"No"]
[]
[null,null,"Dollar base"]
[null,null,2015,"JEN",null,null,2015]
[null,null,2016,"JEN",null,null,2016]
[null,null,2017,"JEN",null,null,2017]
[null,null,2018,"JEN",null,null,2018]
[null,null,2019,"JEN",null,null,2019]
[null,null,2020,"JEN",null,null,2020]
[null,null,2021,"JEN",null,null,2021]
[null,null,2022,"JEN",null,null,2022]
[null,null,2023,"JEN",null,null,2023]
[null,null,2024,"JEN",null,null,2024]
[null,null,2025,"JEN",null,null,2025]
[null,null,2026,"JEN",null,null,2026]
[null,null,2027,"JEN",null,null,2027]
[null,null,2028,"JEN",null,null,2028]
[null,null,2029,"JEN",null,null,2029]
[null,null,2030,"JEN",null,null,2030]
[null,null,"Nominal","JEN",null,null,"Nominal"]
[null,null,"Real","JEN",null,null,"Real"]
[null,null,"Not Applicable","JEN",null,null,"n/a"]
[]
[null,null,"Numeric Converters"]
[null,null,"Thousands","JEN",null,null,1000]
[null,null,"Millions","JEN",null,null,1000000]
[]
[null,null,"Rounding and Error Handling"]
[null,null,"Rounding units","JEN",null,null,5]
[null,null,"Very Small Number","JEN",null,null,9.9999999999999995E-8]
[]
[null,"End"]

{"sheet":"Check|List","index":6,"n_rows":15,"n_cols":22,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,6],[1,2,1,4]]}
[null,null,{"$f":"Index!$C$1","v":"JEN Reopener - Unforeseen Major Connections Model"},null,null,null,null,null,null,"Back to Index",null,"Key:","Input","External Link","Internal Link",null,null,null,null,null,"Overall Check:",{"$f":"IF(COUNTA($G$10:$G$13)=COUNTIF($G$10:$G$13,\"OK\"),\"OK\",\"Check\")","v":"OK"}]
[null,null,{"$f":"RIGHT(CELL(\"filename\",C1),LEN(CELL(\"filename\",C1))-FIND(\"]\",CELL(\"filename\",C1)))","v":"Check|List"}]
[]
[]
[null,"Copyright Jemena Limited. All rights reserved. Jemena is not liable for any loss caused by reliance on this document."]
[]
[null,"Check List"]
[]
[null,null,"Sheet",null,null,null,"Status"]
[null,null,{"$f":"Index!C11","v":"Inputs"},null,null,null,{"$f":"Inputs!$S$1","v":"OK"}]
[null,null,{"$f":"Index!C12","v":"Calc|Expenditure"},null,null,null,{"$f":"'Calc|Expenditure'!$S$1","v":"OK"}]
[null,null,{"$f":"Index!C13","v":"Calc|Contributions"},null,null,null,{"$f":"'Calc|Contributions'!S1","v":"OK"}]
[null,null,{"$f":"Index!C14","v":"Outputs"},null,null,null,{"$f":"Outputs!$R$1","v":"OK"}]
[]
[null,"End"]