{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["inputs¦other","Input¦Historic","Input¦Forecast","Outputs│Tables","Outputs│Revised Proposal","AER Final Decision"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":35,"comments":3,"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":"inputs¦other","index":0,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"inputs¦other"}]
[]
["inflation",null,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022]
["Inflation index","Base 2016/17",{"$f":"D13/(1+C15)","v":0.90888790489087035},0.92329020332717182,0.9463955637707947,{"$f":"G13/(1+F15)","v":0.97412199630314222},{"$f":"H13/(1+G15)","v":0.987060998151571},1,{"$f":"H13*(1+I15)","v":1.0229999999999999},{"$f":"I13*(1+J15)","v":1.0465289999999998},{"$f":"J13*(1+K15)","v":1.0705991669999997},{"$f":"K13*(1+L15)","v":1.0952229478409996},{"$f":"L13*(1+M15)","v":1.1204130756413424}]
["Inflation index","Base 2011/12",1,{"$f":"C14*(1+C15)","v":1.015846066779853},{"$f":"D14*(1+D15)","v":1.041267640022592},1.0717735279138789,1.0860096089298128,1.1002456899457469]
["CPI",null,1.5846066779853007E-2,2.5025025025025016E-2,2.9296875E-2,1.3282732447817747E-2,1.3108614232209881E-2,2.3E-2,{"$f":"H15","v":2.3E-2},{"$f":"I15","v":2.3E-2},{"$f":"J15","v":2.3E-2},{"$f":"K15","v":2.3E-2},{"$f":"L15","v":2.3E-2}]
[]
["Asset Classes"]
["Original Pipeline"]
["Pipelines"]
["Lytton lateral"]
["Peat Lateral"]
["Compressors"]
["Regulators and meters"]
["Easements"]
["Communications"]
["Other"]
["Capitalised AA costs"]
["Group IT"]
["SIB Capex"]
["PMA"]
[]
["AER's Forecast Capex"]
["Forecast Capex","$m 2011/12",null,3.9933999999999998,4.4607999999999999,3.330225,3.543425,2.9837750000000001]
["Forecast capex","$m 2016/17",null,{"$f":"D33/$C$13","v":4.3937211382293455},{"$f":"E33/$C$13","v":4.9079759737099877},{"$f":"F33/$C$13","v":3.6640657027995749},{"$f":"G33/$C$13","v":3.898638083896008},{"$f":"H33/$C$13","v":3.2828855835178707}]
["Forecast Capex","$m nominal",null,{"$f":"D33*D14","v":4.0566796830786647},{"$f":"E33*E14","v":4.644886688612778},3.5692469969969975,3.8481935985221218,3.2828855835178712]
[]
["Historic Projects"]
["Aquarium Passage"]
["Flood Damage"]
["Bi direction"]
["Integrity Upgrade"]
["Clear SCADA"]
["RBP Looping"]
["FC and RTU upgrade"]
["Toowoomba Station Upgrade"]
["Access Arrangement"]
[]
["Forecast Projects"]
["Urban Risk Reduction"]
["Pipeline Integrity Management"]
["Toowoomba Crossing"]
["Dalby Turbine Overhaul"]
["Applications and Renewals"]
["Infrastructure Renewals"]

{"sheet":"Input¦Historic","index":1,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[12,0,12,6],[14,9,14,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"aa asset class"]
[null,13,14,15,16,"Total","Project","Asset Type","Original Pipeline","Pipelines","Compressors","Regulators and meters","Easements","Communications","Other","Capitalised AA costs","Group IT","SIB Capex","PMA","Total","Dollars"]
["RBP11-SIB-18 REDBANK STN UPG",257390.47999999998,105462.91,0,0,{"$f":"SUM(B17:E17)","v":362853.39},"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(I17:S17)","v":1},"$2015/16"]
["RBP11-SIB-49 MV IMPACT MITIG",-32218.949999999997,0,0,0,-32218.949999999997,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(I18:S18)","v":1},"$2015/16"]
["RBP11-SIB-60 ALIGNMNT SHT/PI&D",-2723,0,0,0,-2723,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP Access Arrangement Capex",70875.350000000006,0,0,0,70875.350000000006,"Access Arrangement","Stay in Business",null,null,null,null,null,null,null,1,null,null,null,1,"$2015/16"]
["RBP12-SIB-06 Upgrade Flow Comp",2166.3000000000002,-22172.799999999999,0,0,-20006.5,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP12-SIB-05 Upgrade Flow Comp",6498.9,-33013.4,0,0,-26514.5,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP EXP - LOOPING STAGE 1",1345832.2800000003,2363015.2200000002,18579.009999999998,0,3727426.5100000002,"RBP Looping","Expansion/Extension",null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP EXP - ELLENGROVE STATION",2611.4199999999996,0,0,0,2611.4199999999996,"RBP Looping","Expansion/Extension",null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP EXP - MAOP UPGRADE",588644.6100000001,-615,0,0,588029.6100000001,"RBP Looping","Expansion/Extension",null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP Exp - Dalby Compressor St",143241.70000000019,23529.89,0.01,0,166771.60000000021,"RBP Looping","Expansion/Extension",null,null,1,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP Coating Refurbishment",27525,0,0,0,27525,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["UMG SCADA Server Relocation",-6286.35,0,0,0,-6286.35,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP11-SIB-47 ACQUIRE EASEMENTS",-39743.07,0,0,0,-39743.07,"SIB","Stay in Business",null,null,null,null,1,null,null,null,null,null,null,1,"$2015/16"]
["NAT13-SIB-01 IDMT PHASE 2 QLD",99351.99,-80329.539999999979,0,0,19022.450000000026,"Pipeline Integrity Management","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP BLACKSTONE POWER STATION",-63081.5,0,0,0,-63081.5,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["ELLENGROVE FILTER DOOR UPGRADE",161,0,0,0,161,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP13-SIB-08 RBP Coating Rfb",20344.400000000001,-20344.400000000001,0,0,{"$f":"SUM(B33:E33)","v":0},"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP13-SIB-06 RTU Upgrades",26836,442393.4,-2476.7600000000002,0,466752.64,"FC and RTU upgrade","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP13-SIB-04 UPDATE P&ID's",49208.9,0,0,0,49208.9,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP13-SIB-17 TWMBA VEHC ENTRY",52271.32,0,0,0,52271.32,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP13-SIB-03 VEHC MITIGATION",86009.38,149504.91,0,0,235514.29,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP13-SIB-02 Haz Area Rect",98788.45,335297.90000000002,74211.149999999994,93930.29,602227.79,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP14-SIB-62 TELEMETRY UPGRADE",0,197333.05,-197333.05,0,{"$f":"SUM(B39:E39)","v":0},"SIB","Stay in Business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["CONDAMINE BDF UPGRADE",0,43537.43,0,0,43537.43,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["QLD14-SIB-01 QLD Clear SCADA",0,398043.28,548753.95000000042,0,{"$f":"SUM(B41:E41)","v":946797.23000000045},"Clear SCADA","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP14-SIB-82 MG MAOP SEP",0,13929.34,4403,-18332.34,{"$f":"SUM(B42:E42)","v":0},"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP14-SIB-90 Murarrie Erosion",0,7364,-6591,-773,{"$f":"SUM(B43:E43)","v":0},"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-04 FIRE SUP FEED",0,0,4949.3,48634.47,53583.770000000004,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-03 AS4853 UPGRADE",0,0,3979.9,-3979.9,{"$f":"SUM(B45:E45)","v":0},"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-07 CP Telemetry",0,0,287636.65000000002,243228.77,530865.42000000004,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP15-SIB-61 WEST MINOR ASSETS",0,0,14696.49,4422.95,19119.439999999999,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-24 SANDY CK MODS",0,0,28018.2,1380.6,29398.799999999999,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-25 PV Upgrade Prog",0,0,76698.179999999993,74763.649999999994,151461.82999999999,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-82 3P Risk Reduct",0,0,89229.4,-60247.6,28981.799999999996,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-61 EAST MINOR ASSETS",0,0,12816.4,4400.95,17217.349999999999,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-27 RBP Type B Gas Co",0,0,31198.880000000001,0,31198.880000000001,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-61 CNTRL MINOR ASSET",0,0,39948.160000000003,0,39948.160000000003,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-41 DN250 INTEG PROG",0,0,23686.400000000001,-5.5,23680.9,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["East Coast Clear SCADA License",0,0,20260.240000000002,0,20260.240000000002,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP16-SIB-28 SWNBANK MLV STUDY",0,0,0,594657.31999999995,594657.31999999995,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP METRO ISOLATION FEED",0,0,0,14263.26,14263.26,"SIB","Stay in Business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP16-SIB-47 DN300 EMAT ILI",0,0,0,823889.76,823889.76,"Pipeline Integrity Management","Stay in Business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["QLD 3D LASER PL SCANNER",0,0,0,141023.41,141023.41,"Pipeline Integrity Management","Stay in Business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP16-SIB-22 SCOTIA/WR VENT EX",0,0,0,12768.91,12768.91,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP16-SIB RISK MITIGATION FEED",0,0,0,240096.01,240096.01,"SIB","Stay in Business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP Emergency Pipe Storage",0,0,0,138117,138117,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP13-SIB-05 RBP 10' ILI",106611.85,836870.81,746612.08,13164.16,1703258.9,"Pipeline Integrity Management","Stay in Business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP16-SIB-49 VEHICLE MITIGATE",0,47701.04,35668.92,419628.54,502998.5,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP11-SIB-17 TWMBA STN UPGRADE",56110.01,409980.34,830888.95,0,1296979.3,"Toowoomba station upgrade","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP13-SIB-01 RBP CP UPGRADES",90490.44,550,0,0,91040.44,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP14-SIB-08 COATING REFURB",0,399638.97,-1840,0,397798.97,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP14-SIB-61 RBP CP UPGRADES",0,931641.84,-1789.97,-466160.99,463690.88,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP15-SIB-01 FC & RTU UPGRADE",0,0,533992.56999999995,102168.29,636160.86,"FC and RTU upgrade","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP15-SIB-29 TWMBA DN250 MLV",0,0,383747.1,-2225.6,381521.5,"SIB","Stay in Business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP15-SIB-42 RBP CP UPGRADES",0,0,147597.06,937211.03,1084808.0900000001,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["TWMBA Escarpment Geo Testing",0,0,10829.22,186018.18,196847.4,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP Murarrie MS Sea Wall",0,0,293579.21999999997,168083.28,461662.5,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP METRO LOOPING STAGE 2",842856.25,17091.560000000001,0,0,859947.81,"RBP Looping","Expansion/Extension",null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP MINOR TOOLS & EQUIP FY13",147011.79,-6139,0,0,140872.79,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP13-SIB-14 EASEMENT ACQ",71954.3,4679.07,612,0,77245.37,"Pipeline Integrity Management","Replacement",null,null,null,null,1,null,null,null,null,null,null,1,"$2015/16"]
["RBP AQUARIUM PASSAGE",203407.42,606152.13,1120198.1299999999,0,1929757.68,{"$f":"'inputs¦other'!A38","v":"Aquarium Passage"},"Replacement",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP EAST MINOR TOOLS FY14",0,58187.670000000006,0,0,58187.670000000006,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP CENTRAL MINOR TOOLS FY14",0,55531.93,0,0,55531.93,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP14-SIB-63 LOOP CNTRL UPG",0,64165.760000000002,0,0,64165.760000000002,"SIB","Stay in Business",null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP14-SIB-14 YULEBA LAND",0,5066.6499999999996,0,0,5066.6499999999996,"SIB","Stay in Business",null,null,null,null,1,null,null,null,null,null,null,1,"$2015/16"]
["RBP WEST MINOR TOOLS FY14",0,18043,0,0,18043,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,{"$f":"SUM(I82:S82)","v":1},"$2015/16"]
["RBP Integrity Upgrade Project",0,0,1080254.6599999999,0,1080254.6599999999,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP Bi-Directional Flow",0,0,7545195.7800000003,614017.57999999996,8159213.3600000003,"Bi direction","Stay in Business",null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Roma to Brisbane Digups Stag1",0,0,0,3701897.67,3701897.67,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP16-SIB-84 AB EASEMENT ACQ",0,0,0,74928.14,74928.14,"SIB","Stay in Business",null,null,null,null,1,null,null,null,null,null,null,1,"$2015/16"]
["RBP Access Arrangement FY17",0,0,0,58008.08,58008.08,"Access Arrangement","Stay in Business",null,null,null,null,null,null,null,1,null,null,null,1,"$2015/16"]
["RBP16-SIB CP DATA COLLECTION",0,0,0,50946.05,50946.05,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["Marburg Range",0,0,2848142.64,0,2848142.64,"Flood Damage","Stay in Business",0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Flood damage",98026.84,0,0,0,98026.84,"Flood Damage","Stay in Business",null,0.62669315873081044,null,null,null,null,null,null,null,0.37330684126918673,null,{"$f":"SUM(I90:S90)","v":0.99999999999999711},"$2015/16"]
["Flood Damage",0,1763964.7366990875,32709.61,0,1796674.3466990876,"Flood Damage","Stay in Business",0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Toowoomba Escarpment",0,30577.510000000002,2803439.2399999993,0,2834016.7499999991,"Flood Damage","Stay in Business",0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Corporate Assets",1292236.0665339567,1146777.4598427101,2284029.7709211553,1571910.7799229803,6294954.0772208031,"SIB","Stay in Business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Major Excavations",237675.48999999993,207537.05,1225644.8799999997,14455,1685312.4199999995,"Pipeline Integrity Management","Replacement",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Capitalised to other entitites",-2000,0,0,0,-2000,"SIB","Stay in Business",null,null,null,null,null,null,0,null,null,1,null,1,"$2015/16"]
["Other",0,0,0,96402.62,96402.62,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["Clear SCADA licence",0,0,0,-20260.240000000002,-20260.240000000002,"SIB","Stay in Business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["Capital Contribution",0,null,0,0,-95218.240000000005,"SIB","Stay in Business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
[]
[]
["Total",{"$f":"SUM(B17:B100)","v":5878085.0665339576},{"$f":"SUM(C17:C100)","v":10520954.716541797},{"$f":"SUM(D17:D100)","v":22992176.370921154},{"$f":"SUM(E17:E100)","v":9872431.5799229778},{"$f":"SUM(F17:F100)","v":49168429.493919887}]

{"sheet":"Input¦Forecast","index":2,"n_rows":99,"n_cols":23,"rows_kept":99,"cut":false,"hidden":false,"merged":[[12,0,12,7],[14,11,14,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"aa asset class"]
[null,17,18,19,20,21,22,"Total","Driver","Project","Original Pipeline","Pipelines","Compressors","Regulators and meters","Easements","Communications","Other","Capitalised AA costs","Group IT","SIB Capex","PMA","Total","Dollars"]
["ALARM RATIONALISATION",28.545745627385323,0,0,0,0,0,{"$f":"SUM(B17:G17)","v":28.545745627385323},"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2016/17"]
["ANODE BED EASEMENTS PROGRAM",214.82999999999998,219.94499999999996,225.05999999999997,230.17499999999998,235.28999999999996,240.40499999999997,{"$f":"SUM(B18:G18)","v":1365.7049999999997},"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Condamine River Strain Excavation",0,204.59999999999997,0,0,0,0,204.59999999999997,"Stay in Business","Stay in business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["DN250 INTEGRITY UPGRADE PROGRAM",5012.6999999999989,5414.7389999999996,6107.3099999999995,4071.5399999999995,3764.6399999999994,4328.3129999999992,28699.241999999995,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Gas Measurement Upgrade - including shades",0,0,0,51.149999999999991,51.149999999999991,0,102.29999999999998,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["GIBSON ISLAND E/I REVIEW FEED",10.229999999999999,0,0,0,0,0,10.229999999999999,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["Gibson Island Pressure Vessel platforms",0,0,0,81.839999999999989,0,0,81.839999999999989,"Stay in Business","Stay in business",null,null,null,1,null,null,null,null,null,null,null,1,"$2015/16"]
["Laser Scanner for Feature Assessment",0,0,0,0,153.44999999999999,0,153.44999999999999,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["LOSS OF SUPPLY DESIGN REVIEW",8.5637236882155978,0,0,0,0,0,8.5637236882155978,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["METER PERFORMANCE PROGRAM FEED",0,5.7091491254770652,0,0,0,0,5.7091491254770652,"Stay in Business","Stay in business",null,null,null,1,null,null,null,null,null,null,null,1,"$2015/16"]
["PEAT lateral cleaning pigging",15.344999999999997,0,0,0,0,0,15.344999999999997,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["PEAT LATERAL ILI - DN250 ",0,0,0,143.21999999999997,0,0,143.21999999999997,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["PEAT LATERAL LIQUIDS REMOVAL ",0,306.89999999999998,0,0,0,0,306.89999999999998,"Stay in Business","Stay in business",null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["PIPELINE REPAIR & EXCAVATION PROGRAM (unplanned)",102.29999999999998,102.29999999999998,102.29999999999998,102.29999999999998,102.29999999999998,0,511.49999999999989,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["Portable Slug Catcher - DN400",228.36596501908258,0,0,0,0,0,228.36596501908258,"Stay in Business","Stay in business",null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["QLD OPERATIONS SIB FUNDING",119.89213163501837,114.18298250954129,114.18298250954129,114.18298250954129,114.18298250954129,114.18298250954129,690.80704418272478,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP - Station painting program",81.839999999999989,81.839999999999989,81.839999999999989,81.839999999999989,81.839999999999989,81.839999999999989,491.03999999999991,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP - TYPE B GAS COMPLIANCE UPGRADES ",25.574999999999996,112.52999999999999,112.52999999999999,0,0,0,250.63499999999999,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP & PEAT ISOLATION PLAN UPGRADES",102.29999999999998,102.29999999999998,102.29999999999998,0,0,0,306.89999999999998,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP- AS4853 ELECTRICAL HAZARD UPGRADES",0,122.75999999999998,0,0,0,0,122.75999999999998,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP CE Lateral ILI - DN400",0,0,10.229999999999999,194.36999999999998,0,0,204.59999999999997,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP Cleaning Program (DN400)",16.367999999999999,0,0,0,0,0,16.367999999999999,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP CP TELEMETRY UPGRADE",153.44999999999999,153.44999999999999,153.44999999999999,153.44999999999999,153.44999999999999,0,767.25,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP CP UPGRADE PROGRAM",643.46699999999987,656.76599999999996,662.90399999999988,662.90399999999988,662.90399999999988,662.90399999999988,3951.8489999999997,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP DN400 Supply Offtakes",0,0,255.74999999999997,0,102.29999999999998,0,358.04999999999995,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP HA RECTIFICATION",153.44999999999999,51.149999999999991,0,0,0,102.29999999999998,306.89999999999998,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP LOOPING ILI - DN400",0,0,0,0,1841.3999999999999,0,1841.3999999999999,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP LYTTON LATERAL ILI - DN200 ",5.1149999999999993,143.21999999999997,0,0,0,0,148.33499999999998,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP MAINLINE ILI PROGRAM - DN250",0,0,1534.4999999999998,0,0,0,1534.4999999999998,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP METRO (ORIGINAL) ILI - DN200",0,61.379999999999988,0,0,0,0,61.379999999999988,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP METRO ILI - DN300",225.05999999999997,0,0,0,0,225.05999999999997,450.11999999999995,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP METRO LOOP ILI - DN400 ",0,0,122.75999999999998,0,0,0,122.75999999999998,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},null,1,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP REPLACEMENT SPOOLS FOR DN250 CHECK VALVES",10.229999999999999,0,0,0,0,0,10.229999999999999,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP RISK MITIGATION - FEED and IMPLEMENTATION",8183.9999999999991,1687.9499999999998,306.89999999999998,306.89999999999998,306.89999999999998,306.89999999999998,11099.549999999997,"Stay in Business",{"$f":"'inputs¦other'!A49","v":"Urban Risk Reduction"},1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP S20 Decommissioned Compressor Removal",0,102.29999999999998,102.29999999999998,0,0,0,204.59999999999997,"Stay in Business","Stay in business",null,null,1,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP SCC EMAT ILI - DN300",0,0,0,0,0,920.69999999999993,920.69999999999993,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP SCCMP EMAT ILI - DN250 ",0,1841.3999999999999,1227.5999999999999,0,0,0,3069,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP SCRAPER TRAP MODIFICATIONS",0,204.59999999999997,204.59999999999997,0,0,0,409.19999999999993,"Replacement",{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["RBP STATION FIRE SUPRESSION UPGRADES - BELLBIRD PARK",0,0,0,76.724999999999994,0,0,76.724999999999994,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["RBP STATION UPGRADES - HAZOP & Other",163.67999999999998,312.01499999999999,312.01499999999999,102.29999999999998,102.29999999999998,0,992.30999999999983,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["SCOTIA / WOODROYD VENT EXTENSION",0,30.689999999999994,0,0,0,0,30.689999999999994,"Stay in Business","Stay in business",1,null,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["SIS demand/test tracking system",0,28.545745627385323,0,0,0,0,28.545745627385323,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["SIS improvement program FEED and Implementation",28.545745627385323,0,0,0,0,0,28.545745627385323,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["SMS Reviews - QLD ",5.7091491254770652,0,0,0,0,0,5.7091491254770652,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["SWANBANK ISOLATION VALVE",51.149999999999991,0,0,0,0,0,51.149999999999991,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,null,1,null,1,"$2015/16"]
["TOOWOOMBA DN250 RAIL CROSSING",0,11252.999999999998,3580.4999999999995,0,0,0,14833.499999999998,"Stay in Business",{"$f":"'inputs¦other'!A51","v":"Toowoomba Crossing"},0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["TOOWOOMBA RANGE SLOPE MONITORING WORKS",306.89999999999998,664.94999999999993,0,0,0,0,971.84999999999991,"Stay in Business",{"$f":"'inputs¦other'!A51","v":"Toowoomba Crossing"},0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Toowoomba Slope Management",0,0,0,0,0,0,0,"Stay in Business","Stay in business",0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["TOOWOOMBA STATION HEATER INSTALLATION",0,255.74999999999997,0,0,0,0,255.74999999999997,"Stay in Business","Stay in business",null,null,null,1,null,null,null,null,null,null,null,1,"$2015/16"]
["Turbine overhauls - Dalby",0,0,0,0,0,0,0,"Stay in Business",{"$f":"'inputs¦other'!A52","v":"Dalby Turbine Overhaul"},null,null,1,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Applications and Renewals",0,425.72883701583771,531.85254711253924,425.72883701583771,531.85254711253924,425.72883701583771,2340.8916052725917,"Stay in Business","Applications and Renewals",null,null,null,null,null,null,null,null,1,null,null,1,"$2014/15"]
["Infrastructure Renewals",0,138.82462076603403,46.274873588678005,46.274873588678005,46.274873588678005,0,277.64924153206806,"Stay in Business","Infrastructure Renewals",null,null,null,null,null,null,null,null,1,null,null,1,"$2014/15"]
["AA Costs",911.85669695999991,72.505483049999995,0,0,59.342265839999989,911.85669695999991,1955.5611428099999,"Stay in Business","Access Arrangement",null,null,null,null,null,null,null,1,null,null,null,1,"$2015/16"]
["Remote Vehicle Comms - Journey Management",1.810130338136076,0,0,0,0,0,1.810130338136076,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Satellite Strategy",97.005975420326834,0,0,0,0,0,97.005975420326834,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Enterprise Content Management",290.26432700406156,0,0,0,0,0,290.26432700406156,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["APA Grid - Energy Components Upgrade",155.18097350972863,0,0,0,0,0,155.18097350972863,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Hyperion Upgrade to v 11-1-2-4",42.655225947255424,0,0,0,0,0,42.655225947255424,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["APA Grid Services Initiatives Program",50.800774256547257,0,0,0,0,0,50.800774256547257,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["APA Grid Extend",487.05107877275856,108.10478083679503,0,0,0,0,595.15585960955354,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["BI - Transmission Dashboard",59.532824131953134,0,0,0,0,0,59.532824131953134,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["HR Systems Refresh",53.628640424207227,283.79664084857114,3.5667327254922312,0,0,0,340.99201399827058,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["SharePoint Upgrade",63.728997596057646,42.467866375055976,0,0,0,0,106.19686397111363,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["SQL Server Upgrade",56.643540620482234,3.7107566465997621,0,0,0,0,60.354297267081996,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Upgrade Enterprise OSI PI Historian",14.762474204535401,0.2004146470462155,0,0,0,0,14.962888851581617,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Hazardous Area Platform",16.401430937077283,94.841122077665034,0,0,0,0,{"$f":"SUM(B82:G82)","v":111.24255301474231},"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Form Digitisation Project",10.276031428650194,77.75513395503026,0,0,0,0,88.03116538368046,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Enterprise Asset Management Upgrade FY18",8.1098802088218065,166.19060601755066,0,0,0,0,174.30048622637247,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["PPM Refresh",1.4579818434078029,51.107897001154178,0,0,0,0,52.565878844561979,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["BizTalk System Upgrade FY18",0,48.192036845665967,0,0,0,0,48.192036845665967,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Automated Testing Tool",0,25.668154030190774,0,0,0,0,25.668154030190774,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Oracle eBS Upgrade to v12 2",0,55.846598429504304,0,0,0,0,55.846598429504304,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["CRM Upgrade",0,40.91905045321753,0,0,0,0,40.91905045321753,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["X-Info Aware Version 2",0,18.625529233799867,0,0,0,0,18.625529233799867,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["ID Procurement Data",0,17.646939635771592,0.95740807717112353,0,0,0,18.604347712942715,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Upgrade Enterprise OSI PI Historian 2017",1.0793694155006337,7.8189483430755624,0,0,0,0,8.8983177585761961,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Supplier Qualification and Compliance",0,6.825279514460628,7.5337198349431596,0,0,0,14.358999349403788,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["BizTalk System Upgrade FY20",0,0,0,12.244205582336065,0,0,12.244205582336065,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
["Enterprise Asset Management Upgrade FY21",0,0,0,7.1431569092824141,57.234721095662415,0,64.377878004944833,"Stay in Business","Stay in business",null,null,null,null,null,null,null,null,1,null,null,1,"$2015/16"]
[]
[]
[]
["Total",{"$f":"SUM(B17:B95)","v":18219.858813742074},25921.749572985427,15909.217263848363,6864.2880556056734,8366.8113901464203,8320.1905164853779,83602.115612813373]

{"sheet":"Outputs│Tables","index":3,"n_rows":81,"n_cols":25,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Outputs│Tables"}]
[]
[]
["Capex by project ($m nominal)",null,null,null,null,null,null,null,null,null,null,null,null,"Capex by project ($m real 2016/17)"]
["Project name",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Project name",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022]
[{"$f":"'inputs¦other'!A38","v":"Aquarium Passage"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A15,'Input¦Historic'!B$17:B$98)/1000000","v":0.20340742000000001},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A15,'Input¦Historic'!C$17:C$98)/1000000","v":0.60615213000000001},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A15,'Input¦Historic'!D$17:D$98)/1000000","v":1.1201981299999999},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A15,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A15,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A15,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A15,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A15,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A15,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A15,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,{"$f":"A15","v":"Aquarium Passage"},"$m real 2016/17",{"$f":"C15/'inputs¦other'!D$13","v":0.2203071355755756},{"$f":"D15/'inputs¦other'!E$13","v":0.64048496548828138},{"$f":"E15/'inputs¦other'!F$13","v":1.1499567140986717},{"$f":"F15/'inputs¦other'!G$13","v":0},{"$f":"G15/'inputs¦other'!H$13","v":0},{"$f":"H15/'inputs¦other'!I$13","v":0},{"$f":"I15/'inputs¦other'!J$13","v":0},{"$f":"J15/'inputs¦other'!K$13","v":0},{"$f":"K15/'inputs¦other'!L$13","v":0},{"$f":"L15/'inputs¦other'!M$13","v":0}]
[{"$f":"'inputs¦other'!A39","v":"Flood Damage"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A16,'Input¦Historic'!B$17:B$98)/1000000","v":9.802683999999999E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A16,'Input¦Historic'!C$17:C$98)/1000000","v":1.7945422466990875},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A16,'Input¦Historic'!D$17:D$98)/1000000","v":5.6842914899999997},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A16,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A16,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A16,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A16,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A16,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A16,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A16,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,{"$f":"A16","v":"Flood Damage"},"$m real 2016/17",{"$f":"C16/'inputs¦other'!D$13","v":0.10617121209209208},{"$f":"D16/'inputs¦other'!E$13","v":1.8961862411410282},{"$f":"E16/'inputs¦other'!F$13","v":5.8352973360341558},{"$f":"F16/'inputs¦other'!G$13","v":0},{"$f":"G16/'inputs¦other'!H$13","v":0},{"$f":"H16/'inputs¦other'!I$13","v":0},{"$f":"I16/'inputs¦other'!J$13","v":0},{"$f":"J16/'inputs¦other'!K$13","v":0},{"$f":"K16/'inputs¦other'!L$13","v":0},{"$f":"L16/'inputs¦other'!M$13","v":0}]
[{"$f":"'inputs¦other'!A40","v":"Bi direction"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A17,'Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A17,'Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A17,'Input¦Historic'!D$17:D$98)/1000000","v":7.5451957800000002},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A17,'Input¦Historic'!E$17:E$98)/1000000","v":0.61401757999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A17,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A17,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A17,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A17,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A17,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A17,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Bi direction","$m real 2016/17",{"$f":"C17/'inputs¦other'!D$13","v":0},{"$f":"D17/'inputs¦other'!E$13","v":0},{"$f":"E17/'inputs¦other'!F$13","v":7.7456374136242898},{"$f":"F17/'inputs¦other'!G$13","v":0.62206649958801508},{"$f":"G17/'inputs¦other'!H$13","v":0},{"$f":"H17/'inputs¦other'!I$13","v":0},{"$f":"I17/'inputs¦other'!J$13","v":0},{"$f":"J17/'inputs¦other'!K$13","v":0},{"$f":"K17/'inputs¦other'!L$13","v":0},{"$f":"L17/'inputs¦other'!M$13","v":0}]
[{"$f":"'inputs¦other'!A42","v":"Clear SCADA"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A18,'Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A18,'Input¦Historic'!C$17:C$98)/1000000","v":0.39804328000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A18,'Input¦Historic'!D$17:D$98)/1000000","v":0.54875395000000038},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A18,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A18,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A18,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A18,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A18,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A18,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A18,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Clear SCADA","$m real 2016/17",{"$f":"C18/'inputs¦other'!D$13","v":0},{"$f":"D18/'inputs¦other'!E$13","v":0.42058870015625011},{"$f":"E18/'inputs¦other'!F$13","v":0.56333185379506689},{"$f":"F18/'inputs¦other'!G$13","v":0},{"$f":"G18/'inputs¦other'!H$13","v":0},{"$f":"H18/'inputs¦other'!I$13","v":0},{"$f":"I18/'inputs¦other'!J$13","v":0},{"$f":"J18/'inputs¦other'!K$13","v":0},{"$f":"K18/'inputs¦other'!L$13","v":0},{"$f":"L18/'inputs¦other'!M$13","v":0}]
[{"$f":"'inputs¦other'!A43","v":"RBP Looping"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A19,'Input¦Historic'!B$17:B$98)/1000000","v":2.9231862600000009},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A19,'Input¦Historic'!C$17:C$98)/1000000","v":2.4030216700000002},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A19,'Input¦Historic'!D$17:D$98)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A19,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A19,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A19,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A19,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A19,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A19,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A19,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"RBP Looping","$m real 2016/17",{"$f":"C19/'inputs¦other'!D$13","v":3.1660535869069082},{"$f":"D19/'inputs¦other'!E$13","v":2.5391303192773442},{"$f":"E19/'inputs¦other'!F$13","v":1.9072580303605313E-2},{"$f":"F19/'inputs¦other'!G$13","v":0},{"$f":"G19/'inputs¦other'!H$13","v":0},{"$f":"H19/'inputs¦other'!I$13","v":0},{"$f":"I19/'inputs¦other'!J$13","v":0},{"$f":"J19/'inputs¦other'!K$13","v":0},{"$f":"K19/'inputs¦other'!L$13","v":0},{"$f":"L19/'inputs¦other'!M$13","v":0}]
[{"$f":"'inputs¦other'!A44","v":"FC and RTU upgrade"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A20,'Input¦Historic'!B$17:B$98)/1000000","v":2.6835999999999999E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A20,'Input¦Historic'!C$17:C$98)/1000000","v":0.44239340000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A20,'Input¦Historic'!D$17:D$98)/1000000","v":0.53151580999999992},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A20,'Input¦Historic'!E$17:E$98)/1000000","v":0.10216828999999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A20,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A20,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A20,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A20,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A20,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A20,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"FC and RTU upgrade","$m real 2016/17",{"$f":"C20/'inputs¦other'!D$13","v":2.9065617617617619E-2},{"$f":"D20/'inputs¦other'!E$13","v":0.46745083867187509},{"$f":"E20/'inputs¦other'!F$13","v":0.54563577459203039},{"$f":"F20/'inputs¦other'!G$13","v":0.10350757470037454},{"$f":"G20/'inputs¦other'!H$13","v":0},{"$f":"H20/'inputs¦other'!I$13","v":0},{"$f":"I20/'inputs¦other'!J$13","v":0},{"$f":"J20/'inputs¦other'!K$13","v":0},{"$f":"K20/'inputs¦other'!L$13","v":0},{"$f":"L20/'inputs¦other'!M$13","v":0}]
[{"$f":"'inputs¦other'!A45","v":"Toowoomba Station Upgrade"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A21,'Input¦Historic'!B$17:B$98)/1000000","v":5.6110010000000002E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A21,'Input¦Historic'!C$17:C$98)/1000000","v":0.40998034},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A21,'Input¦Historic'!D$17:D$98)/1000000","v":0.83088894999999996},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A21,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A21,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A21,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A21,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A21,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A21,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A21,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Toowoomba Station Upgrade","$m real 2016/17",{"$f":"C21/'inputs¦other'!D$13","v":6.0771802622622627E-2},{"$f":"D21/'inputs¦other'!E$13","v":0.43320188269531257},{"$f":"E21/'inputs¦other'!F$13","v":0.85296190123339666},{"$f":"F21/'inputs¦other'!G$13","v":0},{"$f":"G21/'inputs¦other'!H$13","v":0},{"$f":"H21/'inputs¦other'!I$13","v":0},{"$f":"I21/'inputs¦other'!J$13","v":0},{"$f":"J21/'inputs¦other'!K$13","v":0},{"$f":"K21/'inputs¦other'!L$13","v":0},{"$f":"L21/'inputs¦other'!M$13","v":0}]
[{"$f":"'inputs¦other'!A46","v":"Access Arrangement"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A22,'Input¦Historic'!B$17:B$98)/1000000","v":7.0875350000000004E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A22,'Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A22,'Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A22,'Input¦Historic'!E$17:E$98)/1000000","v":5.8008080000000004E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A22,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0.91185669695999994},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A22,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":7.4173109160149991E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A22,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A22,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A22,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":6.499301132484904E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A22,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":1.0216561663851091},null,"Access Arrangement","$m real 2016/17",{"$f":"C22/'inputs¦other'!D$13","v":7.67638925925926E-2},{"$f":"D22/'inputs¦other'!E$13","v":0},{"$f":"E22/'inputs¦other'!F$13","v":0},{"$f":"F22/'inputs¦other'!G$13","v":5.8768485543071174E-2},{"$f":"G22/'inputs¦other'!H$13","v":0.91185669695999994},{"$f":"H22/'inputs¦other'!I$13","v":7.250548305E-2},{"$f":"I22/'inputs¦other'!J$13","v":0},{"$f":"J22/'inputs¦other'!K$13","v":0},{"$f":"K22/'inputs¦other'!L$13","v":5.9342265839999991E-2},{"$f":"L22/'inputs¦other'!M$13","v":0.91185669696000005}]
["Stay in business","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!B$17:B$100)/1000000","v":1.8456897165339565},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!C$17:C$100)/1000000","v":2.1865778498427106},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!D$17:D$100)/1000000","v":3.2043394809211554},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!E$17:E$100)/1000000","v":3.6895343199229798},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A23,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":2.5624801167820719},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A23,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":3.0519063166930898},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A23,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":1.2508908328529411},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A23,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0.67418342979702894},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A23,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0.66951822518040316},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A23,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0.33424497036801354},null,"Stay in business","$m real 2016/17",{"$f":"C23/'inputs¦other'!D$13","v":1.9990353085983394},{"$f":"D23/'inputs¦other'!E$13","v":2.3104269858689581},{"$f":"E23/'inputs¦other'!F$13","v":3.2894642489152663},{"$f":"F23/'inputs¦other'!G$13","v":3.7378990020193492},{"$f":"G23/'inputs¦other'!H$13","v":2.5624801167820719},{"$f":"H23/'inputs¦other'!I$13","v":2.9832906321535582},{"$f":"I23/'inputs¦other'!J$13","v":1.1952758431471477},{"$f":"J23/'inputs¦other'!K$13","v":0.62972534500115962},{"$f":"K23/'inputs¦other'!L$13","v":0.61130770360520359},{"$f":"L23/'inputs¦other'!M$13","v":0.29832298250954126}]
[{"$f":"'inputs¦other'!A49","v":"Urban Risk Reduction"},"$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A24,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":8.1839999999999993},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A24,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":1.7267728499999997},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A24,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0.32117975009999988},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A24,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0.32856688435229986},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A24,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0.33612392269240271},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A24,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0.34385477291432792},null,"Urban Risk Reduction","$m real 2016/17",{"$f":"C24/'inputs¦other'!D$13","v":0},{"$f":"D24/'inputs¦other'!E$13","v":0},{"$f":"E24/'inputs¦other'!F$13","v":0},{"$f":"F24/'inputs¦other'!G$13","v":0},{"$f":"G24/'inputs¦other'!H$13","v":8.1839999999999993},{"$f":"H24/'inputs¦other'!I$13","v":1.6879499999999998},{"$f":"I24/'inputs¦other'!J$13","v":0.30689999999999995},{"$f":"J24/'inputs¦other'!K$13","v":0.30689999999999995},{"$f":"K24/'inputs¦other'!L$13","v":0.30689999999999995},{"$f":"L24/'inputs¦other'!M$13","v":0.30689999999999995}]
[{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},"$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A25,'Input¦Historic'!B$17:B$98)/1000000","v":0.65395346999999993},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A25,'Input¦Historic'!C$17:C$98)/1000000","v":2.2802438000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A25,'Input¦Historic'!D$17:D$98)/1000000","v":3.5084137599999998},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,$A25,'Input¦Historic'!E$17:E$98)/1000000","v":5.4087033099999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A25,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":6.2546219999999986},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A25,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":8.8954964999999984},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A25,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":10.725262455005996},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A25,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":5.84082398083605},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A25,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":7.4597102576200571},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A25,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":7.1453021811597344},null,"Pipeline Integrity Management","$m real 2016/17",{"$f":"C25/'inputs¦other'!D$13","v":0.70828594048048044},{"$f":"D25/'inputs¦other'!E$13","v":2.4093982339843758},{"$f":"E25/'inputs¦other'!F$13","v":3.6016164025806452},{"$f":"F25/'inputs¦other'!G$13","v":5.4796039151872664},{"$f":"G25/'inputs¦other'!H$13","v":6.2546219999999986},{"$f":"H25/'inputs¦other'!I$13","v":8.6954999999999991},{"$f":"I25/'inputs¦other'!J$13","v":10.248413999999999},{"$f":"J25/'inputs¦other'!K$13","v":5.4556589999999989},{"$f":"K25/'inputs¦other'!L$13","v":6.8111339999999982},{"$f":"L25/'inputs¦other'!M$13","v":6.377381999999999}]
[{"$f":"'inputs¦other'!A51","v":"Toowoomba Crossing"},"$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A26,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0.30689999999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A26,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":12.192062849999997},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A26,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":3.7470970844999987},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A26,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A26,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A26,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Toowoomba Crossing","$m real 2016/17",{"$f":"C26/'inputs¦other'!D$13","v":0},{"$f":"D26/'inputs¦other'!E$13","v":0},{"$f":"E26/'inputs¦other'!F$13","v":0},{"$f":"F26/'inputs¦other'!G$13","v":0},{"$f":"G26/'inputs¦other'!H$13","v":0.30689999999999995},{"$f":"H26/'inputs¦other'!I$13","v":11.917949999999999},{"$f":"I26/'inputs¦other'!J$13","v":3.5804999999999993},{"$f":"J26/'inputs¦other'!K$13","v":0},{"$f":"K26/'inputs¦other'!L$13","v":0},{"$f":"L26/'inputs¦other'!M$13","v":0}]
[{"$f":"'inputs¦other'!A53","v":"Applications and Renewals"},"$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0.43552060026720191},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0.55659911427713848},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0.45578493827703448},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0.58249711446533936},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0.47699215567012648},null,"Applications and Renewals","$m real 2016/17",{"$f":"C27/'inputs¦other'!D$13","v":0},{"$f":"D27/'inputs¦other'!E$13","v":0},{"$f":"E27/'inputs¦other'!F$13","v":0},{"$f":"F27/'inputs¦other'!G$13","v":0},{"$f":"G27/'inputs¦other'!H$13","v":0},{"$f":"H27/'inputs¦other'!I$13","v":0.42572883701583769},{"$f":"I27/'inputs¦other'!J$13","v":0.53185254711253926},{"$f":"J27/'inputs¦other'!K$13","v":0.42572883701583769},{"$f":"K27/'inputs¦other'!L$13","v":0.53185254711253926},{"$f":"L27/'inputs¦other'!M$13","v":0.42572883701583769}]
[{"$f":"'inputs¦other'!A54","v":"Infrastructure Renewals"},"$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0.1420175870436528},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":4.842799718188559E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":4.9541841117068955E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":5.0681303462761541E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Infrastructure Renewals","$m real 2016/17",{"$f":"C28/'inputs¦other'!D$13","v":0},{"$f":"D28/'inputs¦other'!E$13","v":0},{"$f":"E28/'inputs¦other'!F$13","v":0},{"$f":"F28/'inputs¦other'!G$13","v":0},{"$f":"G28/'inputs¦other'!H$13","v":0},{"$f":"H28/'inputs¦other'!I$13","v":0.13882462076603402},{"$f":"I28/'inputs¦other'!J$13","v":4.6274873588678003E-2},{"$f":"J28/'inputs¦other'!K$13","v":4.6274873588678003E-2},{"$f":"K28/'inputs¦other'!L$13","v":4.6274873588678003E-2},{"$f":"L28/'inputs¦other'!M$13","v":0}]
["Total","$m nominal",{"$f":"SUM(C15:C28)","v":5.8780850665339575},10.5209547165418,22.992176370921158,9.8724315799229796,18.219858813742068,26.517949813164094,16.649457233917961,7.3489010743794818,9.1635238347458117,9.3220502464973123,null,"Total",null,{"$f":"SUM(P15:P28)","v":6.3664544964862282},11.116868167283426,23.602974225177128,10.001845477038076,18.219858813742068,25.92174957298543,15.909217263848362,6.864288055605674,8.3668113901464185,8.3201905164853773]
[]
["Total Inputs",null,{"$f":"'Input¦Historic'!B101/1000000","v":5.8780850665339575},{"$f":"'Input¦Historic'!C101/1000000","v":10.520954716541796},{"$f":"'Input¦Historic'!D101/1000000","v":22.992176370921154},{"$f":"'Input¦Historic'!E101/1000000","v":9.8724315799229778},{"$f":"'Input¦Forecast'!B99/1000*'inputs¦other'!H$13","v":18.219858813742075},{"$f":"'Input¦Forecast'!C99/1000*'inputs¦other'!I$13","v":26.517949813164091},{"$f":"'Input¦Forecast'!D99/1000*'inputs¦other'!J$13","v":16.649457233917961},{"$f":"'Input¦Forecast'!E99/1000*'inputs¦other'!K$13","v":7.3489010743794809},{"$f":"'Input¦Forecast'!F99/1000*'inputs¦other'!L$13","v":9.1635238347458134},{"$f":"'Input¦Forecast'!G99/1000*'inputs¦other'!M$13","v":9.3220502464973105},null,"Total Inputs",null,{"$f":"'Input¦Historic'!B101/'inputs¦other'!D13/1000000","v":6.3664544964862291},{"$f":"'Input¦Historic'!C101/'inputs¦other'!E13/1000000","v":11.116868167283423},{"$f":"'Input¦Historic'!D101/'inputs¦other'!F13/1000000","v":23.602974225177128},{"$f":"'Input¦Historic'!E101/'inputs¦other'!G13/1000000","v":10.001845477038074},{"$f":"'Input¦Forecast'!B99/1000","v":18.219858813742075},{"$f":"'Input¦Forecast'!C99/1000","v":25.921749572985426},{"$f":"'Input¦Forecast'!D99/1000","v":15.909217263848362},{"$f":"'Input¦Forecast'!E99/1000","v":6.8642880556056731},{"$f":"'Input¦Forecast'!F99/1000","v":8.3668113901464203},{"$f":"'Input¦Forecast'!G99/1000","v":8.3201905164853773}]
["Difference",null,{"$f":"C29-C31","v":0},{"$f":"D29-D31","v":0},0,0,0,0,0,0,0,0,null,"Difference",null,{"$f":"P29-P31","v":0},{"$f":"Q29-Q31","v":0},{"$f":"R29-R31","v":0},{"$f":"S29-S31","v":0},{"$f":"T29-T31","v":0},{"$f":"U29-U31","v":0},{"$f":"V29-V31","v":0},{"$f":"W29-W31","v":0},{"$f":"X29-X31","v":0},{"$f":"Y29-Y31","v":0}]
[]
["Asset Class",null,{"$f":"C14","v":2013},2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Asset Class",null,{"$f":"P14","v":2013},2014,2015,2016,2017,2018,2019,2020,2021,2022]
["Original Pipeline",{"$f":"B29","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$98,'Input¦Historic'!B$17:B$98)/1000000","v":0.48264717999999995},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$98,'Input¦Historic'!C$17:C$98)/1000000","v":3.4504984433495434},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$98,'Input¦Historic'!D$17:D$98)/1000000","v":6.536361555},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$98,'Input¦Historic'!E$17:E$98)/1000000","v":5.66083698},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$K$17:$K$95)/1000*'inputs¦other'!H13","v":14.0810835},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$K$17:$K$95)/1000*'inputs¦other'!I13","v":16.180908133499997},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$K$17:$K$95)/1000*'inputs¦other'!J13","v":12.128817962942996},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$K$17:$K$95)/1000*'inputs¦other'!K13","v":5.2477607545801499},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$K$17:$K$95)/1000*'inputs¦other'!L13","v":5.1191673426052926},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$K$17:$K$95)/1000*'inputs¦other'!M13","v":6.9831173466018104},null,"Original Pipeline",{"$f":"O28","v":"$m real 2016/17"},{"$f":"C35/'inputs¦other'!D$13","v":0.52274699575575578},{"$f":"D35/'inputs¦other'!E$13","v":3.645936831742389},{"$f":"E35/'inputs¦other'!F$13","v":6.7100030384345359},{"$f":"F35/'inputs¦other'!G$13","v":5.7350427082022479},{"$f":"G35/'inputs¦other'!H$13","v":14.0810835},{"$f":"H35/'inputs¦other'!I$13","v":15.817114499999999},{"$f":"I35/'inputs¦other'!J$13","v":11.589566999999999},{"$f":"J35/'inputs¦other'!K$13","v":4.9017045000000001},{"$f":"K35/'inputs¦other'!L$13","v":4.6740869999999983},{"$f":"L35/'inputs¦other'!M$13","v":6.2326274999999995}]
["Pipelines",{"$f":"B35","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$98,'Input¦Historic'!B$17:B$98)/1000000","v":2.8413773099999999},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$98,'Input¦Historic'!C$17:C$98)/1000000","v":3.3409286633495436},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$98,'Input¦Historic'!D$17:D$98)/1000000","v":10.405920534999998},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$98,'Input¦Historic'!E$17:E$98)/1000000","v":0.61401757999999995},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$L$17:$L$95)/1000*'inputs¦other'!H13","v":0.8928044650190825},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$L$17:$L$95)/1000*'inputs¦other'!I13","v":7.1880844364999987},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$L$17:$L$95)/1000*'inputs¦other'!J13","v":2.664721326662999},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$L$17:$L$95)/1000*'inputs¦other'!K13","v":0.92163011060820121},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$L$17:$L$95)/1000*'inputs¦other'!L13","v":2.6766668377071672},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$L$17:$L$95)/1000*'inputs¦other'!M13","v":0.50603960747225263},null,"Pipelines",{"$f":"O35","v":"$m real 2016/17"},{"$f":"C36/'inputs¦other'!D$13","v":3.0774476971171172},{"$f":"D36/'inputs¦other'!E$13","v":3.530160950922077},{"$f":"E36/'inputs¦other'!F$13","v":10.682358651679316},{"$f":"F36/'inputs¦other'!G$13","v":0.62206649958801508},{"$f":"G36/'inputs¦other'!H$13","v":0.8928044650190825},{"$f":"H36/'inputs¦other'!I$13","v":7.0264754999999992},{"$f":"I36/'inputs¦other'!J$13","v":2.5462469999999993},{"$f":"J36/'inputs¦other'!K$13","v":0.86085449999999997},{"$f":"K36/'inputs¦other'!L$13","v":2.4439469999999996},{"$f":"L36/'inputs¦other'!M$13","v":0.45165449999999996}]
["Compressors",{"$f":"B36","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$98,'Input¦Historic'!B$17:B$98)/1000000","v":0.14324170000000019},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$98,'Input¦Historic'!C$17:C$98)/1000000","v":2.3529889999999998E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$98,'Input¦Historic'!D$17:D$98)/1000000","v":1E-8},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$98,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$M$17:$M$95)/1000*'inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$M$17:$M$95)/1000*'inputs¦other'!I13","v":0.10465289999999998},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$M$17:$M$95)/1000*'inputs¦other'!J13","v":0.10705991669999997},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$M$17:$M$95)/1000*'inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$M$17:$M$95)/1000*'inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$M$17:$M$95)/1000*'inputs¦other'!M13","v":0},null,"Compressors",{"$f":"O36","v":"$m real 2016/17"},{"$f":"C37/'inputs¦other'!D$13","v":0.15514266206206229},{"$f":"D37/'inputs¦other'!E$13","v":2.486263767578125E-2},{"$f":"E37/'inputs¦other'!F$13","v":1.0265654648956358E-8},{"$f":"F37/'inputs¦other'!G$13","v":0},{"$f":"G37/'inputs¦other'!H$13","v":0},{"$f":"H37/'inputs¦other'!I$13","v":0.10229999999999999},{"$f":"I37/'inputs¦other'!J$13","v":0.10229999999999999},{"$f":"J37/'inputs¦other'!K$13","v":0},{"$f":"K37/'inputs¦other'!L$13","v":0},{"$f":"L37/'inputs¦other'!M$13","v":0}]
["Regulators and meters","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$98,'Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$98,'Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$98,'Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$98,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$N$17:$N$95)/1000*'inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$N$17:$N$95)/1000*'inputs¦other'!I13","v":0.26747270955536295},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$N$17:$N$95)/1000*'inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$N$17:$N$95)/1000*'inputs¦other'!K13","v":8.7617835827279972E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$N$17:$N$95)/1000*'inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$N$17:$N$95)/1000*'inputs¦other'!M13","v":0},null,"Regulators and meters","$m real 2016/17",{"$f":"C38/'inputs¦other'!D$13","v":0},{"$f":"D38/'inputs¦other'!E$13","v":0},{"$f":"E38/'inputs¦other'!F$13","v":0},{"$f":"F38/'inputs¦other'!G$13","v":0},{"$f":"G38/'inputs¦other'!H$13","v":0},{"$f":"H38/'inputs¦other'!I$13","v":0.26145914912547702},{"$f":"I38/'inputs¦other'!J$13","v":0},{"$f":"J38/'inputs¦other'!K$13","v":8.1839999999999996E-2},{"$f":"K38/'inputs¦other'!L$13","v":0},{"$f":"L38/'inputs¦other'!M$13","v":0}]
["Easements","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$98,'Input¦Historic'!B$17:B$98)/1000000","v":3.221123E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$98,'Input¦Historic'!C$17:C$98)/1000000","v":9.7457199999999994E-3},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$98,'Input¦Historic'!D$17:D$98)/1000000","v":6.1200000000000002E-4},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$98,'Input¦Historic'!E$17:E$98)/1000000","v":7.4928140000000004E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$O$17:$O$95)/1000*'inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$O$17:$O$95)/1000*'inputs¦other'!I13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$O$17:$O$95)/1000*'inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$O$17:$O$95)/1000*'inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$O$17:$O$95)/1000*'inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$O$17:$O$95)/1000*'inputs¦other'!M13","v":0},null,"Easements","$m real 2016/17",{"$f":"C39/'inputs¦other'!D$13","v":3.4887438298298303E-2},{"$f":"D39/'inputs¦other'!E$13","v":1.0297723671875E-2},{"$f":"E39/'inputs¦other'!F$13","v":6.2825806451612912E-4},{"$f":"F39/'inputs¦other'!G$13","v":7.5910344082397024E-2},{"$f":"G39/'inputs¦other'!H$13","v":0},{"$f":"H39/'inputs¦other'!I$13","v":0},{"$f":"I39/'inputs¦other'!J$13","v":0},{"$f":"J39/'inputs¦other'!K$13","v":0},{"$f":"K39/'inputs¦other'!L$13","v":0},{"$f":"L39/'inputs¦other'!M$13","v":0}]
["Communications","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$98,'Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$98,'Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$98,'Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$98,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$P$17:$P$95)/1000*'inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$P$17:$P$95)/1000*'inputs¦other'!I13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$P$17:$P$95)/1000*'inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$P$17:$P$95)/1000*'inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$P$17:$P$95)/1000*'inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$P$17:$P$95)/1000*'inputs¦other'!M13","v":0},null,"Communications","$m real 2016/17",{"$f":"C40/'inputs¦other'!D$13","v":0},{"$f":"D40/'inputs¦other'!E$13","v":0},{"$f":"E40/'inputs¦other'!F$13","v":0},{"$f":"F40/'inputs¦other'!G$13","v":0},{"$f":"G40/'inputs¦other'!H$13","v":0},{"$f":"H40/'inputs¦other'!I$13","v":0},{"$f":"I40/'inputs¦other'!J$13","v":0},{"$f":"J40/'inputs¦other'!K$13","v":0},{"$f":"K40/'inputs¦other'!L$13","v":0},{"$f":"L40/'inputs¦other'!M$13","v":0}]
["Other","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$98,'Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$98,'Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$98,'Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$98,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$Q$17:$Q$95)/1000*'inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$Q$17:$Q$95)/1000*'inputs¦other'!I13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$Q$17:$Q$95)/1000*'inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$Q$17:$Q$95)/1000*'inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$Q$17:$Q$95)/1000*'inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$Q$17:$Q$95)/1000*'inputs¦other'!M13","v":0},null,"Other","$m real 2016/17",{"$f":"C41/'inputs¦other'!D$13","v":0},{"$f":"D41/'inputs¦other'!E$13","v":0},{"$f":"E41/'inputs¦other'!F$13","v":0},{"$f":"F41/'inputs¦other'!G$13","v":0},{"$f":"G41/'inputs¦other'!H$13","v":0},{"$f":"H41/'inputs¦other'!I$13","v":0},{"$f":"I41/'inputs¦other'!J$13","v":0},{"$f":"J41/'inputs¦other'!K$13","v":0},{"$f":"K41/'inputs¦other'!L$13","v":0},{"$f":"L41/'inputs¦other'!M$13","v":0}]
["Capitalised AA costs","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$98,'Input¦Historic'!B$17:B$98)/1000000","v":7.0875350000000004E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$98,'Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$98,'Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$98,'Input¦Historic'!E$17:E$98)/1000000","v":5.8008080000000004E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$R$17:$R$95)/1000*'inputs¦other'!H13","v":0.91185669695999994},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$R$17:$R$95)/1000*'inputs¦other'!I13","v":7.4173109160149991E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$R$17:$R$95)/1000*'inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$R$17:$R$95)/1000*'inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$R$17:$R$95)/1000*'inputs¦other'!L13","v":6.499301132484904E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$R$17:$R$95)/1000*'inputs¦other'!M13","v":1.0216561663851091},null,"Capitalised AA costs","$m real 2016/17",{"$f":"C42/'inputs¦other'!D$13","v":7.67638925925926E-2},{"$f":"D42/'inputs¦other'!E$13","v":0},{"$f":"E42/'inputs¦other'!F$13","v":0},{"$f":"F42/'inputs¦other'!G$13","v":5.8768485543071174E-2},{"$f":"G42/'inputs¦other'!H$13","v":0.91185669695999994},{"$f":"H42/'inputs¦other'!I$13","v":7.250548305E-2},{"$f":"I42/'inputs¦other'!J$13","v":0},{"$f":"J42/'inputs¦other'!K$13","v":0},{"$f":"K42/'inputs¦other'!L$13","v":5.9342265839999991E-2},{"$f":"L42/'inputs¦other'!M$13","v":0.91185669696000005}]
["Group IT","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$98,'Input¦Historic'!B$17:B$98)/1000000","v":1.2922360665339567},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$98,'Input¦Historic'!C$17:C$98)/1000000","v":1.1467774598427101},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$98,'Input¦Historic'!D$17:D$98)/1000000","v":2.2840297709211552},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$98,'Input¦Historic'!E$17:E$98)/1000000","v":1.5719107799229803},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$S$17:$S$95)/1000*'inputs¦other'!H13","v":1.4103896560595084},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$S$17:$S$95)/1000*'inputs¦other'!I13","v":1.651399450564506},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$S$17:$S$95)/1000*'inputs¦other'!J13","v":0.61764601229423777},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$S$17:$S$95)/1000*'inputs¦other'!K13","v":0.52608287352795724},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$S$17:$S$95)/1000*'inputs¦other'!L13","v":0.69586319788534978},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$S$17:$S$95)/1000*'inputs¦other'!M13","v":0.47699215567012648},null,"Group IT","$m real 2016/17",{"$f":"C43/'inputs¦other'!D$13","v":1.399599023012754},{"$f":"D43/'inputs¦other'!E$13","v":1.2117316519041137},{"$f":"E43/'inputs¦other'!F$13","v":2.3447060836211482},{"$f":"F43/'inputs¦other'!G$13","v":1.592516351944443},{"$f":"G43/'inputs¦other'!H$13","v":1.4103896560595084},{"$f":"H43/'inputs¦other'!I$13","v":1.6142712126730265},{"$f":"I43/'inputs¦other'!J$13","v":0.59018528133882375},{"$f":"J43/'inputs¦other'!K$13","v":0.49139107309613422},{"$f":"K43/'inputs¦other'!L$13","v":0.63536214179687966},{"$f":"L43/'inputs¦other'!M$13","v":0.42572883701583769}]
["SIB Capex","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$98,'Input¦Historic'!B$17:B$98)/1000000","v":1.0154962299999999},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$98,'Input¦Historic'!C$17:C$98)/1000000","v":2.5494745400000003},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$98,'Input¦Historic'!D$17:D$98)/1000000","v":3.7652524999999999},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$98,'Input¦Historic'!E$17:E$98)/1000000","v":1.8927300199999997},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$T$17:$T$95)/1000*'inputs¦other'!H13","v":0.92372449570348159},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$T$17:$T$95)/1000*'inputs¦other'!I13","v":1.0512590738840757},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$T$17:$T$95)/1000*'inputs¦other'!J13","v":1.1312120153177274},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$T$17:$T$95)/1000*'inputs¦other'!K13","v":0.56580949983589512},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$T$17:$T$95)/1000*'inputs¦other'!L13","v":0.60683344522315441},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$T$17:$T$95)/1000*'inputs¦other'!M13","v":0.33424497036801354},null,"SIB Capex","$m real 2016/17",{"$f":"C44/'inputs¦other'!D$13","v":1.0998667876476476},{"$f":"D44/'inputs¦other'!E$13","v":2.6938783713671883},{"$f":"E44/'inputs¦other'!F$13","v":3.8652781831119549},{"$f":"F44/'inputs¦other'!G$13","v":1.9175410876779027},{"$f":"G44/'inputs¦other'!H$13","v":0.92372449570348159},{"$f":"H44/'inputs¦other'!I$13","v":1.0276237281369265},{"$f":"I44/'inputs¦other'!J$13","v":1.0809179825095412},{"$f":"J44/'inputs¦other'!K$13","v":0.52849798250954116},{"$f":"K44/'inputs¦other'!L$13","v":0.55407298250954129},{"$f":"L44/'inputs¦other'!M$13","v":0.29832298250954126}]
["PMA","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$98,'Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$98,'Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$98,'Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$98,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$U$17:$U$95)/1000*'inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$U$17:$U$95)/1000*'inputs¦other'!I13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$U$17:$U$95)/1000*'inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$U$17:$U$95)/1000*'inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$U$17:$U$95)/1000*'inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$U$17:$U$95)/1000*'inputs¦other'!M13","v":0},null,"PMA","$m real 2016/17",{"$f":"C45/'inputs¦other'!D$13","v":0},{"$f":"D45/'inputs¦other'!E$13","v":0},{"$f":"E45/'inputs¦other'!F$13","v":0},{"$f":"F45/'inputs¦other'!G$13","v":0},{"$f":"G45/'inputs¦other'!H$13","v":0},{"$f":"H45/'inputs¦other'!I$13","v":0},{"$f":"I45/'inputs¦other'!J$13","v":0},{"$f":"J45/'inputs¦other'!K$13","v":0},{"$f":"K45/'inputs¦other'!L$13","v":0},{"$f":"L45/'inputs¦other'!M$13","v":0}]
["Total","$m nominal",{"$f":"SUM(C35:C45)","v":5.8780850665339575},{"$f":"SUM(D35:D45)","v":10.520954716541798},22.992176370921154,9.8724315799229796,18.219858813742071,26.517949813164091,16.649457233917961,7.3489010743794836,9.1635238347458117,9.3220502464973123,null,"Total","$m real 2016/17",{"$f":"SUM(P35:P45)","v":6.3664544964862273},{"$f":"SUM(Q35:Q45)","v":11.116868167283425},{"$f":"SUM(R35:R45)","v":23.602974225177125},{"$f":"SUM(S35:S45)","v":10.001845477038076},{"$f":"SUM(T35:T45)","v":18.219858813742071},{"$f":"SUM(U35:U45)","v":25.921749572985433},{"$f":"SUM(V35:V45)","v":15.909217263848364},{"$f":"SUM(W35:W45)","v":6.8642880556056758},{"$f":"SUM(X35:X45)","v":8.3668113901464185},{"$f":"SUM(Y35:Y45)","v":8.3201905164853791}]
[]
["Check",null,{"$f":"C46=C29","v":true},true,true,true,{"$f":"G46=G29","v":true},{"$f":"H46=H29","v":true},true,true,true,true,null,"Check",null,{"$f":"P46=P31","v":true},{"$f":"Q46=Q31","v":true},true,true,true,true,true,false,true,true]
[]
["Driver",null,{"$f":"C34","v":2013},{"$f":"D34","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,null,"Driver",null,{"$f":"P34","v":2013},{"$f":"Q34","v":2014},2015,2016,2017,2018,2019,2020,2021,2022]
["Expansion/Extension",{"$f":"B46","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A51,'Input¦Historic'!B$17:B$98)/1000000","v":2.9231862600000009},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A51,'Input¦Historic'!C$17:C$98)/1000000","v":2.4030216700000002},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A51,'Input¦Historic'!D$17:D$98)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A51,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A51,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A51,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A51,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A51,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A51,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A51,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Expansion/Extension",{"$f":"O46","v":"$m real 2016/17"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N51,'Input¦Historic'!B$17:B$98)/1000000/'inputs¦other'!D$13","v":3.1660535869069082},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N51,'Input¦Historic'!C$17:C$98)/1000000/'inputs¦other'!E$13","v":2.5391303192773442},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N51,'Input¦Historic'!D$17:D$98)/1000000/'inputs¦other'!F$13","v":1.9072580303605313E-2},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N51,'Input¦Historic'!E$17:E$98)/1000000/'inputs¦other'!G$13","v":0},{"$f":"T19","v":0},0,0,0,0,0]
["Replacement",{"$f":"B51","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A52,'Input¦Historic'!B$17:B$98)/1000000","v":0.65139705000000003},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A52,'Input¦Historic'!C$17:C$98)/1000000","v":2.1298546599999999},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A52,'Input¦Historic'!D$17:D$98)/1000000","v":3.8819998099999995},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A52,'Input¦Historic'!E$17:E$98)/1000000","v":4.4306259800000003},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":6.2546219999999986},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":8.8954964999999984},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":10.725262455005996},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":5.84082398083605},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":7.4597102576200571},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":7.1453021811597344},null,"Replacement",{"$f":"O51","v":"$m real 2016/17"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N52,'Input¦Historic'!B$17:B$98)/1000000/'inputs¦other'!D$13","v":0.70551712522522536},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N52,'Input¦Historic'!C$17:C$98)/1000000/'inputs¦other'!E$13","v":2.2504909591015627},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N52,'Input¦Historic'!D$17:D$98)/1000000/'inputs¦other'!F$13","v":3.9851269396774192},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N52,'Input¦Historic'!E$17:E$98)/1000000/'inputs¦other'!G$13","v":4.4887053467790272},{"$f":"T25","v":6.2546219999999986},8.6954999999999991,10.248413999999999,5.4556589999999989,6.8111339999999982,6.377381999999999]
["Stay in business",{"$f":"B52","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A53,'Input¦Historic'!B$17:B$98)/1000000","v":2.3035017565339566},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A53,'Input¦Historic'!C$17:C$98)/1000000","v":5.9880783865417966},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A53,'Input¦Historic'!D$17:D$98)/1000000","v":19.091597540921157},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A53,'Input¦Historic'!E$17:E$98)/1000000","v":5.4418055999229802},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":11.965236813742068},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":17.62245331316409},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":5.9241947789119642},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":1.5080770935434322},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":1.7038135771257559},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":2.176748065337577},null,"Stay in business",{"$f":"O52","v":"$m real 2016/17"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N53,'Input¦Historic'!B$17:B$98)/1000000/'inputs¦other'!D$13","v":2.4948837843540952},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N53,'Input¦Historic'!C$17:C$98)/1000000/'inputs¦other'!E$13","v":6.3272468889045159},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N53,'Input¦Historic'!D$17:D$98)/1000000/'inputs¦other'!F$13","v":19.598774705196103},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N53,'Input¦Historic'!E$17:E$98)/1000000/'inputs¦other'!G$13","v":5.5131401302590497},{"$f":"T46-SUM(T51:T52)","v":11.965236813742074},17.226249572985434,5.660803263848365,1.4086290556056769,1.5556773901464203,1.9428085164853801]
["Total",{"$f":"B53","v":"$m nominal"},{"$f":"SUM(C51:C53)","v":5.8780850665339575},{"$f":"SUM(D51:D53)","v":10.520954716541798},22.992176370921158,9.8724315799229814,{"$f":"SUM(G51:G53)","v":18.219858813742068},{"$f":"SUM(H51:H53)","v":26.517949813164087},16.649457233917961,7.3489010743794818,9.1635238347458134,9.3220502464973123,null,"Total",{"$f":"O53","v":"$m real 2016/17"},{"$f":"SUM(P51:P53)","v":6.3664544964862291},{"$f":"SUM(Q51:Q53)","v":11.116868167283423},{"$f":"SUM(R51:R53)","v":23.602974225177128},{"$f":"SUM(S51:S53)","v":10.001845477038078},{"$f":"SUM(T51:T53)","v":18.219858813742071},{"$f":"SUM(U51:U53)","v":25.921749572985433},{"$f":"SUM(V51:V53)","v":15.909217263848364},{"$f":"SUM(W51:W53)","v":6.8642880556056758},{"$f":"SUM(X51:X53)","v":8.3668113901464185},{"$f":"SUM(Y51:Y53)","v":8.3201905164853791}]
[]
["Check",null,{"$f":"C54=C46","v":true},true,true,true,true,true,true,true,true,true,null,"Check",null,{"$f":"P54=P46","v":true},true,true,true,true,true,true,true,true,true]
[]
[]
["AER Final Decision - Capex by project ($m nominal)",null,null,null,null,null,null,null,null,null,null,null,null,"AER Final Decision - Capex by project ($m real 2016/17)"]
["Driver",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Driver",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022]
["Expansion/Extension","$m nominal",{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A61,'Input¦Historic'!B$17:B$98)/1000000","v":2.9231862600000009},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A61,'Input¦Historic'!C$17:C$98)/1000000","v":2.4030216700000002},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A61,'Input¦Historic'!D$17:D$98)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A61,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A61,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A61,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A61,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A61,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A61,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A61,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Expansion/Extension","$m real 2016/17",{"$f":"C61/'inputs¦other'!D$13","v":3.1660535869069082},{"$f":"D61/'inputs¦other'!E$13","v":2.5391303192773442},{"$f":"E61/'inputs¦other'!F$13","v":1.9072580303605313E-2},{"$f":"F61/'inputs¦other'!G$13","v":0},{"$f":"G61/'inputs¦other'!H$13","v":0},{"$f":"H61/'inputs¦other'!I$13","v":0},{"$f":"I61/'inputs¦other'!J$13","v":0},{"$f":"J61/'inputs¦other'!K$13","v":0},{"$f":"K61/'inputs¦other'!L$13","v":0},{"$f":"L61/'inputs¦other'!M$13","v":0}]
["Replacement","$m nominal",{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A62,'Input¦Historic'!B$17:B$98)/1000000","v":0.65139705000000003},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A62,'Input¦Historic'!C$17:C$98)/1000000","v":2.1298546599999999},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A62,'Input¦Historic'!D$17:D$98)/1000000","v":3.8819998099999995},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A62,'Input¦Historic'!E$17:E$98)/1000000","v":4.4306259800000003},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A62,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":6.2546219999999986},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A62,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":8.8954964999999984},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A62,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":10.725262455005996},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A62,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":5.84082398083605},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A62,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":7.4597102576200571},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A62,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":7.1453021811597344},null,"Replacement","$m real 2016/17",{"$f":"C62/'inputs¦other'!D$13","v":0.70551712522522536},{"$f":"D62/'inputs¦other'!E$13","v":2.2504909591015627},{"$f":"E62/'inputs¦other'!F$13","v":3.9851269396774192},{"$f":"F62/'inputs¦other'!G$13","v":4.4887053467790272},{"$f":"G62/'inputs¦other'!H$13","v":6.2546219999999986},{"$f":"H62/'inputs¦other'!I$13","v":8.6954999999999991},{"$f":"I62/'inputs¦other'!J$13","v":10.248413999999999},{"$f":"J62/'inputs¦other'!K$13","v":5.4556589999999989},{"$f":"K62/'inputs¦other'!L$13","v":6.8111339999999982},{"$f":"L62/'inputs¦other'!M$13","v":6.377381999999999}]
["Stay in business","$m nominal",{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A63,'Input¦Historic'!B$17:B$98)/1000000","v":2.3035017565339566},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A63,'Input¦Historic'!C$17:C$98)/1000000","v":5.9880783865417966},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A63,'Input¦Historic'!D$17:D$98)/1000000","v":19.091597540921157},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A63,'Input¦Historic'!E$17:E$98)/1000000","v":5.4418055999229802},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A63,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":11.965236813742068},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A63,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":17.62245331316409},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A63,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":5.9241947789119642},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A63,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":1.5080770935434322},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A63,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":1.7038135771257559},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A63,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":2.176748065337577},null,"Stay in business","$m real 2016/17",{"$f":"C63/'inputs¦other'!D$13","v":2.4948837843540952},{"$f":"D63/'inputs¦other'!E$13","v":6.3272468889045159},{"$f":"E63/'inputs¦other'!F$13","v":19.598774705196103},{"$f":"F63/'inputs¦other'!G$13","v":5.5131401302590497},{"$f":"G63/'inputs¦other'!H$13","v":11.965236813742068},{"$f":"H63/'inputs¦other'!I$13","v":17.226249572985427},{"$f":"I63/'inputs¦other'!J$13","v":5.660803263848365},{"$f":"J63/'inputs¦other'!K$13","v":1.4086290556056753},{"$f":"K63/'inputs¦other'!L$13","v":1.5556773901464209},{"$f":"L63/'inputs¦other'!M$13","v":1.9428085164853788}]
["Total gross capex","$m nominal",{"$f":"SUM(C61:C63)","v":5.8780850665339575},{"$f":"SUM(D61:D63)","v":10.520954716541798},22.992176370921158,9.8724315799229814,{"$f":"SUM(G61:G63)","v":18.219858813742068},{"$f":"SUM(H61:H63)","v":26.517949813164087},16.649457233917961,7.3489010743794818,9.1635238347458134,9.3220502464973123,null,"Total gross capex","$m real 2016/17",{"$f":"SUM(P61:P63)","v":6.3664544964862291},{"$f":"SUM(Q61:Q63)","v":11.116868167283423},23.602974225177128,10.001845477038078,{"$f":"SUM(T61:T63)","v":18.219858813742068},{"$f":"SUM(U61:U63)","v":25.921749572985426},15.909217263848364,6.864288055605674,8.3668113901464185,8.3201905164853773]
["Capital contributions","$m nominal",null,{"$f":"'AER Final Decision'!E59","v":9.521824000000001E-2},null,null,null,null,null,null,null,null,null,"Capital contributions","$m real 2016/17",{"$f":"C65/'inputs¦other'!D$13","v":0},{"$f":"D65/'inputs¦other'!E$13","v":0.10061146062500002},{"$f":"E65/'inputs¦other'!F$13","v":0},{"$f":"F65/'inputs¦other'!G$13","v":0},{"$f":"G65/'inputs¦other'!H$13","v":0},{"$f":"H65/'inputs¦other'!I$13","v":0},{"$f":"I65/'inputs¦other'!J$13","v":0},{"$f":"J65/'inputs¦other'!K$13","v":0},{"$f":"K65/'inputs¦other'!L$13","v":0},{"$f":"L65/'inputs¦other'!M$13","v":0}]
["Asset disposals","$m nominal",0.10868117999999999,6.6794679999999995E-2,4.0840309999999998E-2,0,0,null,null,null,null,null,null,"Asset disposals","$m real 2016/17",{"$f":"C66/'inputs¦other'!D$13","v":0.1177107475075075},{"$f":"D66/'inputs¦other'!E$13","v":7.057797242187501E-2},{"$f":"E66/'inputs¦other'!F$13","v":4.1925251821631877E-2},{"$f":"F66/'inputs¦other'!G$13","v":0},{"$f":"G66/'inputs¦other'!H$13","v":0},{"$f":"H66/'inputs¦other'!I$13","v":0},{"$f":"I66/'inputs¦other'!J$13","v":0},{"$f":"J66/'inputs¦other'!K$13","v":0},{"$f":"K66/'inputs¦other'!L$13","v":0},{"$f":"L66/'inputs¦other'!M$13","v":0}]
["Total net capex","$m nominal",{"$f":"C64-C65","v":5.8780850665339575},10.425736476541799,22.992176370921158,9.8724315799229814,18.219858813742068,26.517949813164087,16.649457233917961,7.3489010743794818,9.1635238347458134,9.3220502464973123,null,"Total net capex","$m real 2016/17",{"$f":"P64-P65-P66","v":6.2487437489787219},{"$f":"Q64-Q65-Q66","v":10.945678734236548},23.561048973355497,10.001845477038078,18.219858813742068,25.921749572985426,15.909217263848364,6.864288055605674,8.3668113901464185,8.3201905164853773]
[]
[]
[]
["AER Forecast by Driver",null,{"$f":"C50","v":2013},{"$f":"D50","v":2014},{"$f":"E50","v":2015},{"$f":"F50","v":2016},{"$f":"G50","v":2017},null,null,null,null,null,null,{"$f":"A71","v":"AER Forecast by Driver"},null,{"$f":"P50","v":2013},{"$f":"Q50","v":2014},{"$f":"R50","v":2015},{"$f":"S50","v":2016},{"$f":"T50","v":2017}]
[{"$f":"A51","v":"Expansion/Extension"},"$m nominal",0,0,0,0,0,null,null,null,null,null,null,{"$f":"N51","v":"Expansion/Extension"},"$m real 2016/17",0,0,0,0,0]
["Replacement","$m nominal",0,0,0,0,0,null,null,null,null,null,null,"Replacement","$m real 2016/17",0,0,0,0,0]
["Stay in business","$m nominal",{"$f":"'inputs¦other'!D35","v":4.0566796830786647},{"$f":"'inputs¦other'!E35","v":4.644886688612778},{"$f":"'inputs¦other'!F35","v":3.5692469969969975},{"$f":"'inputs¦other'!G35","v":3.8481935985221218},{"$f":"'inputs¦other'!H35","v":3.2828855835178712},null,null,null,null,null,null,"Stay in business","$m real 2016/17",{"$f":"'inputs¦other'!D34","v":4.3937211382293455},{"$f":"'inputs¦other'!E34","v":4.9079759737099877},{"$f":"'inputs¦other'!F34","v":3.6640657027995749},{"$f":"'inputs¦other'!G34","v":3.898638083896008},{"$f":"'inputs¦other'!H34","v":3.2828855835178707}]
["Total","$m nominal",{"$f":"SUM(C72:C74)","v":4.0566796830786647},{"$f":"SUM(D72:D74)","v":4.644886688612778},{"$f":"SUM(E72:E74)","v":3.5692469969969975},{"$f":"SUM(F72:F74)","v":3.8481935985221218},{"$f":"SUM(G72:G74)","v":3.2828855835178712},null,null,null,null,null,null,"Total","$m real 2016/17",{"$f":"SUM(P72:P74)","v":4.3937211382293455},{"$f":"SUM(Q72:Q74)","v":4.9079759737099877},3.6640657027995749,3.898638083896008,3.2828855835178707]
[]
["Difference",null,{"$f":"C71","v":2013},{"$f":"D71","v":2014},2015,2016,2017,null,null,null,null,null,null,"Difference",null,{"$f":"P71","v":2013},{"$f":"Q71","v":2014},2015,2016,2017]
[{"$f":"A72","v":"Expansion/Extension"},{"$f":"B72","v":"$m nominal"},{"$f":"C51-C72","v":2.9231862600000009},2.4030216700000002,1.8579019999999998E-2,0,0,null,null,null,null,null,null,{"$f":"N72","v":"Expansion/Extension"},{"$f":"O72","v":"$m real 2016/17"},{"$f":"P51-P72","v":3.1660535869069082},2.5391303192773442,1.9072580303605313E-2,0,0]
[{"$f":"A73","v":"Replacement"},"$m nominal",0.65139705000000003,2.1298546599999999,3.8819998099999995,4.4306259800000003,6.2546219999999986,null,null,null,null,null,null,{"$f":"N73","v":"Replacement"},"$m real 2016/17",0.70551712522522536,2.2504909591015627,3.9851269396774192,4.4887053467790272,6.2546219999999986]
[{"$f":"A74","v":"Stay in business"},"$m nominal",-1.7531779265447081,1.3431916979290186,15.522350543924158,1.5936120014008583,8.6823512302241976,null,null,null,null,null,null,{"$f":"N74","v":"Stay in business"},"$m real 2016/17",-1.8988373538752503,1.4192709151945282,15.934709002396527,1.6145020463630417,8.682351230224203]
[{"$f":"A75","v":"Total"},"$m nominal",{"$f":"SUM(C78:C80)","v":1.8214053834552928},{"$f":"SUM(D78:D80)","v":5.8760680279290192},{"$f":"SUM(E78:E80)","v":19.422929373924159},{"$f":"SUM(F78:F80)","v":6.0242379814008586},{"$f":"SUM(G78:G80)","v":14.936973230224197},null,null,null,null,null,null,{"$f":"N75","v":"Total"},"$m real 2016/17",{"$f":"SUM(P78:P80)","v":1.9727333582568831},{"$f":"SUM(Q78:Q80)","v":6.2088921935734351},19.938908522377552,6.1032073931420694,14.936973230224201]

{"sheet":"Outputs│Revised Proposal","index":4,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",B1),LEN(CELL(\"filename\",B1))-FIND(\"]\",CELL(\"filename\",B1)))","v":"Outputs│Revised Proposal"}]
[]
[]
[null,"Capex by project ($m nominal)",null,null,null,null,null,null,null,"Capex by project ($m real 2016/17)"]
[null,"Project name",null,2013,2014,2015,2016,2017,null,"Project name",null,2018,2019,2020,2021,2022]
[null,"Aquarium Passage","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B15,'Input¦Historic'!B$17:B$97)/1000000","v":0.20340742000000001},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B15,'Input¦Historic'!C$17:C$97)/1000000","v":0.60615213000000001},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B15,'Input¦Historic'!D$17:D$97)/1000000","v":1.1201981299999999},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B15,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,{"$f":"B15","v":"Aquarium Passage"},"$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Flood Damage","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B16,'Input¦Historic'!B$17:B$97)/1000000","v":9.802683999999999E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B16,'Input¦Historic'!C$17:C$97)/1000000","v":1.7945422466990875},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B16,'Input¦Historic'!D$17:D$97)/1000000","v":5.6842914899999997},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B16,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,{"$f":"B16","v":"Flood Damage"},"$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Bi direction","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B17,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B17,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B17,'Input¦Historic'!D$17:D$97)/1000000","v":7.5451957800000002},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B17,'Input¦Historic'!E$17:E$97)/1000000","v":0.61401757999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Bi direction","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Clear SCADA","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B18,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B18,'Input¦Historic'!C$17:C$97)/1000000","v":0.39804328000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B18,'Input¦Historic'!D$17:D$97)/1000000","v":0.54875395000000038},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B18,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Clear SCADA","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"RBP Looping","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B19,'Input¦Historic'!B$17:B$97)/1000000","v":2.9231862600000009},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B19,'Input¦Historic'!C$17:C$97)/1000000","v":2.4030216700000002},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B19,'Input¦Historic'!D$17:D$97)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B19,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"RBP Looping","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"FC and RTU upgrade","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B20,'Input¦Historic'!B$17:B$97)/1000000","v":2.6835999999999999E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B20,'Input¦Historic'!C$17:C$97)/1000000","v":0.44239340000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B20,'Input¦Historic'!D$17:D$97)/1000000","v":0.53151580999999992},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B20,'Input¦Historic'!E$17:E$97)/1000000","v":0.10216828999999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"FC and RTU upgrade","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Toowoomba Station Upgrade","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B21,'Input¦Historic'!B$17:B$97)/1000000","v":5.6110010000000002E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B21,'Input¦Historic'!C$17:C$97)/1000000","v":0.40998034},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B21,'Input¦Historic'!D$17:D$97)/1000000","v":0.83088894999999996},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B21,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Toowoomba Station Upgrade","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Access Arrangement","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B22,'Input¦Historic'!B$17:B$97)/1000000","v":7.0875350000000004E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B22,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B22,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B22,'Input¦Historic'!E$17:E$97)/1000000","v":5.8008080000000004E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0.91185669695999994},null,"Access Arrangement","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!C$17:C$95)/1000","v":7.250548305E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!F$17:F$95)/1000","v":5.9342265839999991E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!G$17:G$95)/1000","v":0.91185669695999994}]
[null,"Stay in business","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!B$17:B$100)/1000000","v":1.8456897165339565},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!C$17:C$100)/1000000","v":2.1865778498427106},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!D$17:D$100)/1000000","v":3.2043394809211554},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!E$17:E$100)/1000000","v":3.6895343199229798},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":2.5624801167820719},null,"Stay in business","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!C$17:C$95)/1000","v":2.9832906321535582},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!D$17:D$95)/1000","v":1.1952758431471477},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!E$17:E$95)/1000","v":0.62972534500115962},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!F$17:F$95)/1000","v":0.61130770360520359},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!G$17:G$95)/1000","v":0.29832298250954126}]
[null,"Urban Risk Reduction","$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":8.1839999999999993},null,"Urban Risk Reduction","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!C$17:C$95)/1000","v":1.6879499999999998},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!D$17:D$95)/1000","v":0.30689999999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!E$17:E$95)/1000","v":0.30689999999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!F$17:F$95)/1000","v":0.30689999999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!G$17:G$95)/1000","v":0.30689999999999995}]
[null,"Pipeline Integrity Management","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B25,'Input¦Historic'!B$17:B$97)/1000000","v":0.65395346999999993},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B25,'Input¦Historic'!C$17:C$97)/1000000","v":2.2802438000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B25,'Input¦Historic'!D$17:D$97)/1000000","v":3.5084137599999998},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B25,'Input¦Historic'!E$17:E$97)/1000000","v":5.4087033099999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":6.2546219999999986},null,"Pipeline Integrity Management","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!C$17:C$95)/1000","v":8.6954999999999991},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!D$17:D$95)/1000","v":10.248413999999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!E$17:E$95)/1000","v":5.4556589999999989},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!F$17:F$95)/1000","v":6.8111339999999982},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!G$17:G$95)/1000","v":6.377381999999999}]
[null,"Toowoomba Crossing","$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0.30689999999999995},null,"Toowoomba Crossing","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!C$17:C$95)/1000","v":11.917949999999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!D$17:D$95)/1000","v":3.5804999999999993},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Applications and Renewals","$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Applications and Renewals","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!C$17:C$95)/1000","v":0.42572883701583769},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!D$17:D$95)/1000","v":0.53185254711253926},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!E$17:E$95)/1000","v":0.42572883701583769},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!F$17:F$95)/1000","v":0.53185254711253926},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!G$17:G$95)/1000","v":0.42572883701583769}]
[null,"Infrastructure Renewals","$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Infrastructure Renewals","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!C$17:C$95)/1000","v":0.13882462076603402},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!D$17:D$95)/1000","v":4.6274873588678003E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!E$17:E$95)/1000","v":4.6274873588678003E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!F$17:F$95)/1000","v":4.6274873588678003E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Total","$m nominal",{"$f":"SUM(D15:D28)","v":5.8780850665339575},{"$f":"SUM(E15:E28)","v":10.5209547165418},{"$f":"SUM(F15:F28)","v":22.992176370921158},{"$f":"SUM(G15:G28)","v":9.8724315799229796},{"$f":"SUM(H15:H28)","v":18.219858813742068},null,"Total",null,{"$f":"SUM(L15:L28)","v":25.92174957298543},{"$f":"SUM(M15:M28)","v":15.909217263848362},{"$f":"SUM(N15:N28)","v":6.864288055605674},{"$f":"SUM(O15:O28)","v":8.3668113901464185},{"$f":"SUM(P15:P28)","v":8.3201905164853773}]
[]
[null,"Total Inputs",null,{"$f":"'Input¦Historic'!B101/1000000","v":5.8780850665339575},{"$f":"'Input¦Historic'!C101/1000000","v":10.520954716541796},{"$f":"'Input¦Historic'!D101/1000000","v":22.992176370921154},{"$f":"'Input¦Historic'!E101/1000000","v":9.8724315799229778},{"$f":"'Input¦Forecast'!B99/1000*'inputs¦other'!H$13","v":18.219858813742075},null,"Total Inputs",null,{"$f":"'Input¦Forecast'!C99/1000","v":25.921749572985426},{"$f":"'Input¦Forecast'!D99/1000","v":15.909217263848362},{"$f":"'Input¦Forecast'!E99/1000","v":6.8642880556056731},{"$f":"'Input¦Forecast'!F99/1000","v":8.3668113901464203},{"$f":"'Input¦Forecast'!G99/1000","v":8.3201905164853773}]
[null,"Difference",null,{"$f":"D29-D31","v":0},{"$f":"E29-E31","v":0},0,0,0,null,"Difference",null,{"$f":"L29-L31","v":0},0,0,0,0]
[]
[null,"Asset Class",null,{"$f":"D14","v":2013},{"$f":"E14","v":2014},{"$f":"F14","v":2015},{"$f":"G14","v":2016},{"$f":"H14","v":2017},null,"Asset Class",null,{"$f":"L14","v":2018},{"$f":"M14","v":2019},{"$f":"N14","v":2020},{"$f":"O14","v":2021},{"$f":"P14","v":2022}]
[null,"Original Pipeline",{"$f":"C29","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$97,'Input¦Historic'!B$17:B$97)/1000000","v":0.48264717999999995},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$97,'Input¦Historic'!C$17:C$97)/1000000","v":3.4504984433495434},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$97,'Input¦Historic'!D$17:D$97)/1000000","v":6.536361555},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$97,'Input¦Historic'!E$17:E$97)/1000000","v":5.66083698},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$K$17:$K$95)/1000*'inputs¦other'!H13","v":14.0810835},null,"Original Pipeline",{"$f":"K28","v":"$m real 2016/17"},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":15.817114499999997},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":11.589566999999999},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":4.9017045000000001},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":4.6740869999999983},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":6.2326274999999995}]
[null,"Pipelines",{"$f":"C35","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$97,'Input¦Historic'!B$17:B$97)/1000000","v":2.8413773099999999},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$97,'Input¦Historic'!C$17:C$97)/1000000","v":3.3409286633495436},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$97,'Input¦Historic'!D$17:D$97)/1000000","v":10.405920534999998},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$97,'Input¦Historic'!E$17:E$97)/1000000","v":0.61401757999999995},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$L$17:$L$95)/1000*'inputs¦other'!H13","v":0.8928044650190825},null,"Pipelines",{"$f":"K35","v":"$m real 2016/17"},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":7.0264754999999992},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":2.5462469999999993},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":0.86085449999999997},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":2.4439469999999996},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":0.4516544999999999}]
[null,"Compressors",{"$f":"C36","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$97,'Input¦Historic'!B$17:B$97)/1000000","v":0.14324170000000019},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$97,'Input¦Historic'!C$17:C$97)/1000000","v":2.3529889999999998E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$97,'Input¦Historic'!D$17:D$97)/1000000","v":1E-8},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$M$17:$M$95)/1000*'inputs¦other'!H13","v":0},null,"Compressors",{"$f":"K36","v":"$m real 2016/17"},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0.10229999999999999},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0.10229999999999999},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0}]
[null,"Regulators and meters","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$97,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$N$17:$N$95)/1000*'inputs¦other'!H13","v":0},null,"Regulators and meters","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":0.26145914912547702},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":8.1839999999999996E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":0}]
[null,"Easements","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$97,'Input¦Historic'!B$17:B$97)/1000000","v":3.221123E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$97,'Input¦Historic'!C$17:C$97)/1000000","v":9.7457199999999994E-3},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$97,'Input¦Historic'!D$17:D$97)/1000000","v":6.1200000000000002E-4},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$97,'Input¦Historic'!E$17:E$97)/1000000","v":7.4928140000000004E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$O$17:$O$95)/1000*'inputs¦other'!H13","v":0},null,"Easements","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0}]
[null,"Communications","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$97,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$P$17:$P$95)/1000*'inputs¦other'!H13","v":0},null,"Communications","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0}]
[null,"Other","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$97,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$Q$17:$Q$95)/1000*'inputs¦other'!H13","v":0},null,"Other","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0}]
[null,"Capitalised AA costs","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$97,'Input¦Historic'!B$17:B$97)/1000000","v":7.0875350000000004E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$97,'Input¦Historic'!E$17:E$97)/1000000","v":5.8008080000000004E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$R$17:$R$95)/1000*'inputs¦other'!H13","v":0.91185669695999994},null,"Capitalised AA costs","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":7.250548305E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":5.9342265839999991E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":0.91185669695999994}]
[null,"Group IT","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$97,'Input¦Historic'!B$17:B$97)/1000000","v":1.2922360665339567},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$97,'Input¦Historic'!C$17:C$97)/1000000","v":1.1467774598427101},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$97,'Input¦Historic'!D$17:D$97)/1000000","v":2.2840297709211552},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$97,'Input¦Historic'!E$17:E$97)/1000000","v":1.5719107799229803},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$S$17:$S$95)/1000*'inputs¦other'!H13","v":1.4103896560595084},null,"Group IT","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":1.6142712126730265},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":0.59018528133882375},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":0.49139107309613422},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":0.63536214179687966},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":0.42572883701583769}]
[null,"SIB Capex","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$97,'Input¦Historic'!B$17:B$97)/1000000","v":1.0154962299999999},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$97,'Input¦Historic'!C$17:C$97)/1000000","v":2.5494745400000003},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$97,'Input¦Historic'!D$17:D$97)/1000000","v":3.7652524999999999},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$97,'Input¦Historic'!E$17:E$97)/1000000","v":1.8927300199999997},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$T$17:$T$95)/1000*'inputs¦other'!H13","v":0.92372449570348159},null,"SIB Capex","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":1.0276237281369265},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":1.0809179825095412},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":0.52849798250954116},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":0.55407298250954129},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":0.29832298250954126}]
[null,"PMA","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$97,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$U$17:$U$95)/1000*'inputs¦other'!H13","v":0},null,"PMA","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0}]
[null,"Total","$m nominal",{"$f":"SUM(D35:D45)","v":5.8780850665339575},{"$f":"SUM(E35:E45)","v":10.520954716541798},22.992176370921154,9.8724315799229796,18.219858813742071,null,"Total","$m real 2016/17",{"$f":"SUM(L35:L45)","v":25.92174957298543},15.909217263848364,6.8642880556056758,8.3668113901464185,8.3201905164853791]
[]
[null,"Check",null,{"$f":"D46=D29","v":true},true,true,true,{"$f":"H46=H29","v":true},null,"Check",null,{"$f":"L46-L31","v":0},{"$f":"M46-M31","v":0},{"$f":"N46-N31","v":0},{"$f":"O46-O31","v":0},{"$f":"P46-P31","v":0}]
[]
[null,"Driver",null,{"$f":"D34","v":2013},{"$f":"E34","v":2014},2015,2016,2017,null,"Driver",null,{"$f":"L34","v":2018},2019,2020,2021,2022]
[null,"Expansion/Extension",{"$f":"C46","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B51,'Input¦Historic'!B$17:B$97)/1000000","v":2.9231862600000009},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B51,'Input¦Historic'!C$17:C$97)/1000000","v":2.4030216700000002},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B51,'Input¦Historic'!D$17:D$97)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B51,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$B51,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Expansion/Extension",{"$f":"K46","v":"$m real 2016/17"},{"$f":"L19","v":0},{"$f":"M19","v":0},{"$f":"N19","v":0},{"$f":"O19","v":0},{"$f":"P19","v":0}]
[null,"Replacement",{"$f":"C51","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B52,'Input¦Historic'!B$17:B$97)/1000000","v":0.65139705000000003},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B52,'Input¦Historic'!C$17:C$97)/1000000","v":2.1298546599999999},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B52,'Input¦Historic'!D$17:D$97)/1000000","v":3.8819998099999995},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B52,'Input¦Historic'!E$17:E$97)/1000000","v":4.4306259800000003},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$B52,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":6.2546219999999986},null,"Replacement",{"$f":"K51","v":"$m real 2016/17"},{"$f":"L25","v":8.6954999999999991},{"$f":"M25","v":10.248413999999999},{"$f":"N25","v":5.4556589999999989},{"$f":"O25","v":6.8111339999999982},{"$f":"P25","v":6.377381999999999}]
[null,"Stay in business",{"$f":"C52","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B53,'Input¦Historic'!B$17:B$97)/1000000","v":2.3035017565339566},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B53,'Input¦Historic'!C$17:C$97)/1000000","v":5.9880783865417966},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B53,'Input¦Historic'!D$17:D$97)/1000000","v":19.091597540921157},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B53,'Input¦Historic'!E$17:E$97)/1000000","v":5.4418055999229802},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$B53,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":11.965236813742068},null,"Stay in business",{"$f":"K52","v":"$m real 2016/17"},{"$f":"L46-SUM(L51:L52)","v":17.226249572985431},5.660803263848365,1.4086290556056769,1.5556773901464203,1.9428085164853801]
[null,"Total",{"$f":"C53","v":"$m nominal"},{"$f":"SUM(D51:D53)","v":5.8780850665339575},{"$f":"SUM(E51:E53)","v":10.520954716541798},22.992176370921158,9.8724315799229814,{"$f":"SUM(H51:H53)","v":18.219858813742068},null,"Total",{"$f":"K53","v":"$m real 2016/17"},{"$f":"SUM(L51:L53)","v":25.92174957298543},15.909217263848364,6.8642880556056758,8.3668113901464185,8.3201905164853791]
[]
[null,"Check",null,{"$f":"D54=D46","v":true},true,true,true,true,null,"Check",null,{"$f":"L54-L46","v":0},0,0,0,0]
[]
[null,"AER Forecast by Driver",null,{"$f":"D50","v":2013},{"$f":"E50","v":2014},2015,2016,2017]
[null,{"$f":"B51","v":"Expansion/Extension"},{"$f":"C51","v":"$m nominal"},0,0,0,0,0]
[null,{"$f":"B52","v":"Replacement"},{"$f":"C52","v":"$m nominal"},0,0,0,0,0]
[null,{"$f":"B53","v":"Stay in business"},"$m nominal",{"$f":"'inputs¦other'!D35","v":4.0566796830786647},{"$f":"'inputs¦other'!E35","v":4.644886688612778},{"$f":"'inputs¦other'!F35","v":3.5692469969969975},{"$f":"'inputs¦other'!G35","v":3.8481935985221218},{"$f":"'inputs¦other'!H35","v":3.2828855835178712}]
[null,{"$f":"B54","v":"Total"},"$m nominal",{"$f":"SUM(D59:D61)","v":4.0566796830786647},{"$f":"SUM(E59:E61)","v":4.644886688612778},{"$f":"SUM(F59:F61)","v":3.5692469969969975},{"$f":"SUM(G59:G61)","v":3.8481935985221218},{"$f":"SUM(H59:H61)","v":3.2828855835178712}]
[]
[null,"Difference",null,{"$f":"D58","v":2013},{"$f":"E58","v":2014},2015,2016,2017]
[null,{"$f":"B59","v":"Expansion/Extension"},{"$f":"C59","v":"$m nominal"},{"$f":"D51-D59","v":2.9231862600000009},{"$f":"E51-E59","v":2.4030216700000002},1.8579019999999998E-2,0,0]
[null,{"$f":"B60","v":"Replacement"},"$m nominal",{"$f":"D52-D60","v":0.65139705000000003},2.1298546599999999,3.8819998099999995,4.4306259800000003,6.2546219999999986]
[null,"Stay in business","$m nominal",-1.7531779265447081,1.3431916979290186,15.522350543924158,1.5936120014008583,8.6823512302241976]
[null,"Total","$m nominal",{"$f":"SUM(D65:D67)","v":1.8214053834552928},{"$f":"SUM(E65:E67)","v":5.8760680279290192},19.422929373924159,6.0242379814008586,14.936973230224197]

{"sheet":"AER Final Decision","index":5,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"RIGHT(CELL(\"filename\",B1),LEN(CELL(\"filename\",B1))-FIND(\"]\",CELL(\"filename\",B1)))","v":"AER Final Decision"}]
[]
[]
[null,"Capex by project ($m nominal)",null,null,null,null,null,null,null,"Capex by project ($m real 2016/17)"]
[null,"Project name",null,2013,2014,2015,2016,2017,null,"Project name",null,2018,2019,2020,2021,2022]
[null,"Aquarium Passage","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B15,'Input¦Historic'!B$17:B$97)/1000000","v":0.20340742000000001},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B15,'Input¦Historic'!C$17:C$97)/1000000","v":0.60615213000000001},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B15,'Input¦Historic'!D$17:D$97)/1000000","v":1.1201981299999999},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B15,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,{"$f":"B15","v":"Aquarium Passage"},"$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B15,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Flood Damage","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B16,'Input¦Historic'!B$17:B$97)/1000000","v":9.802683999999999E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B16,'Input¦Historic'!C$17:C$97)/1000000","v":1.7945422466990875},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B16,'Input¦Historic'!D$17:D$97)/1000000","v":5.6842914899999997},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B16,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,{"$f":"B16","v":"Flood Damage"},"$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B16,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Bi direction","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B17,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B17,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B17,'Input¦Historic'!D$17:D$97)/1000000","v":7.5451957800000002},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B17,'Input¦Historic'!E$17:E$97)/1000000","v":0.61401757999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Bi direction","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B17,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Clear SCADA","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B18,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B18,'Input¦Historic'!C$17:C$97)/1000000","v":0.39804328000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B18,'Input¦Historic'!D$17:D$97)/1000000","v":0.54875395000000038},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B18,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Clear SCADA","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B18,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"RBP Looping","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B19,'Input¦Historic'!B$17:B$97)/1000000","v":2.9231862600000009},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B19,'Input¦Historic'!C$17:C$97)/1000000","v":2.4030216700000002},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B19,'Input¦Historic'!D$17:D$97)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B19,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"RBP Looping","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B19,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"FC and RTU upgrade","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B20,'Input¦Historic'!B$17:B$97)/1000000","v":2.6835999999999999E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B20,'Input¦Historic'!C$17:C$97)/1000000","v":0.44239340000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B20,'Input¦Historic'!D$17:D$97)/1000000","v":0.53151580999999992},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B20,'Input¦Historic'!E$17:E$97)/1000000","v":0.10216828999999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"FC and RTU upgrade","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B20,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Toowoomba Station Upgrade","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B21,'Input¦Historic'!B$17:B$97)/1000000","v":5.6110010000000002E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B21,'Input¦Historic'!C$17:C$97)/1000000","v":0.40998034},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B21,'Input¦Historic'!D$17:D$97)/1000000","v":0.83088894999999996},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B21,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Toowoomba Station Upgrade","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!C$17:C$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B21,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Access Arrangement","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B22,'Input¦Historic'!B$17:B$97)/1000000","v":7.0875350000000004E-2},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B22,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B22,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B22,'Input¦Historic'!E$17:E$97)/1000000","v":5.8008080000000004E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0.91185669695999994},null,"Access Arrangement","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!C$17:C$95)/1000","v":7.250548305E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!D$17:D$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!F$17:F$95)/1000","v":5.9342265839999991E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B22,'Input¦Forecast'!G$17:G$95)/1000","v":0.91185669695999994}]
[null,"Stay in business","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!B$17:B$100)/1000000","v":1.8456897165339565},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!C$17:C$100)/1000000","v":2.1865778498427106},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!D$17:D$100)/1000000","v":3.2043394809211554},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$100,\"SIB\",'Input¦Historic'!E$17:E$100)/1000000","v":3.6895343199229798},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":2.5624801167820719},null,"Stay in business","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!C$17:C$95)/1000","v":2.9832906321535582},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!D$17:D$95)/1000","v":1.1952758431471477},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!E$17:E$95)/1000","v":0.62972534500115962},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!F$17:F$95)/1000","v":0.61130770360520359},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B23,'Input¦Forecast'!G$17:G$95)/1000","v":0.29832298250954126}]
[null,"Urban Risk Reduction","$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":8.1839999999999993},null,"Urban Risk Reduction","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!C$17:C$95)/1000","v":1.6879499999999998},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!D$17:D$95)/1000","v":0.30689999999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!E$17:E$95)/1000","v":0.30689999999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!F$17:F$95)/1000","v":0.30689999999999995},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B24,'Input¦Forecast'!G$17:G$95)/1000","v":0.30689999999999995}]
[null,"Pipeline Integrity Management","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B25,'Input¦Historic'!B$17:B$97)/1000000","v":0.65395346999999993},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B25,'Input¦Historic'!C$17:C$97)/1000000","v":2.2802438000000005},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B25,'Input¦Historic'!D$17:D$97)/1000000","v":3.5084137599999998},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$97,$B25,'Input¦Historic'!E$17:E$97)/1000000","v":5.4087033099999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":6.2546219999999986},null,"Pipeline Integrity Management","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!C$17:C$95)/1000","v":8.6954999999999991},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!D$17:D$95)/1000","v":10.248413999999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!E$17:E$95)/1000","v":5.4556589999999989},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!F$17:F$95)/1000","v":6.8111339999999982},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B25,'Input¦Forecast'!G$17:G$95)/1000","v":6.377381999999999}]
[null,"Toowoomba Crossing","$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0.30689999999999995},null,"Toowoomba Crossing","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!C$17:C$95)/1000","v":11.917949999999999},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!D$17:D$95)/1000","v":3.5804999999999993},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!E$17:E$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!F$17:F$95)/1000","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B26,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Applications and Renewals","$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Applications and Renewals","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!C$17:C$95)/1000","v":0.42572883701583769},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!D$17:D$95)/1000","v":0.53185254711253926},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!E$17:E$95)/1000","v":0.42572883701583769},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!F$17:F$95)/1000","v":0.53185254711253926},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B27,'Input¦Forecast'!G$17:G$95)/1000","v":0.42572883701583769}]
[null,"Infrastructure Renewals","$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Infrastructure Renewals","$m real 2016/17",{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!C$17:C$95)/1000","v":0.13882462076603402},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!D$17:D$95)/1000","v":4.6274873588678003E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!E$17:E$95)/1000","v":4.6274873588678003E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!F$17:F$95)/1000","v":4.6274873588678003E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$B28,'Input¦Forecast'!G$17:G$95)/1000","v":0}]
[null,"Total","$m nominal",{"$f":"SUM(D15:D28)","v":5.8780850665339575},{"$f":"SUM(E15:E28)","v":10.5209547165418},{"$f":"SUM(F15:F28)","v":22.992176370921158},{"$f":"SUM(G15:G28)","v":9.8724315799229796},{"$f":"SUM(H15:H28)","v":18.219858813742068},null,"Total",null,{"$f":"SUM(L15:L28)","v":25.92174957298543},{"$f":"SUM(M15:M28)","v":15.909217263848362},{"$f":"SUM(N15:N28)","v":6.864288055605674},{"$f":"SUM(O15:O28)","v":8.3668113901464185},{"$f":"SUM(P15:P28)","v":8.3201905164853773}]
[]
[null,"Total Inputs",null,{"$f":"'Input¦Historic'!B101/1000000","v":5.8780850665339575},{"$f":"'Input¦Historic'!C101/1000000","v":10.520954716541796},{"$f":"'Input¦Historic'!D101/1000000","v":22.992176370921154},{"$f":"'Input¦Historic'!E101/1000000","v":9.8724315799229778},{"$f":"'Input¦Forecast'!B99/1000*'inputs¦other'!H$13","v":18.219858813742075},null,"Total Inputs",null,{"$f":"'Input¦Forecast'!C99/1000","v":25.921749572985426},{"$f":"'Input¦Forecast'!D99/1000","v":15.909217263848362},{"$f":"'Input¦Forecast'!E99/1000","v":6.8642880556056731},{"$f":"'Input¦Forecast'!F99/1000","v":8.3668113901464203},{"$f":"'Input¦Forecast'!G99/1000","v":8.3201905164853773}]
[null,"Difference",null,{"$f":"D29-D31","v":0},{"$f":"E29-E31","v":0},0,0,0,null,"Difference",null,{"$f":"L29-L31","v":0},0,0,0,0]
[]
[null,"Asset Class",null,{"$f":"D14","v":2013},{"$f":"E14","v":2014},{"$f":"F14","v":2015},{"$f":"G14","v":2016},{"$f":"H14","v":2017},null,"Asset Class",null,{"$f":"L14","v":2018},{"$f":"M14","v":2019},{"$f":"N14","v":2020},{"$f":"O14","v":2021},{"$f":"P14","v":2022}]
[null,"Original Pipeline",{"$f":"C29","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$97,'Input¦Historic'!B$17:B$97)/1000000","v":0.48264717999999995},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$97,'Input¦Historic'!C$17:C$97)/1000000","v":3.4504984433495434},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$97,'Input¦Historic'!D$17:D$97)/1000000","v":6.536361555},{"$f":"SUMPRODUCT('Input¦Historic'!$I$17:$I$97,'Input¦Historic'!E$17:E$97)/1000000","v":5.66083698},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$K$17:$K$95)/1000*'inputs¦other'!H13","v":14.0810835},null,"Original Pipeline",{"$f":"K28","v":"$m real 2016/17"},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":15.817114499999997},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":11.589566999999999},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":4.9017045000000001},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":4.6740869999999983},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$K$17:$K$95)/1000","v":6.2326274999999995}]
[null,"Pipelines",{"$f":"C35","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$97,'Input¦Historic'!B$17:B$97)/1000000","v":2.8413773099999999},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$97,'Input¦Historic'!C$17:C$97)/1000000","v":3.3409286633495436},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$97,'Input¦Historic'!D$17:D$97)/1000000","v":10.405920534999998},{"$f":"SUMPRODUCT('Input¦Historic'!$J$17:$J$97,'Input¦Historic'!E$17:E$97)/1000000","v":0.61401757999999995},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$L$17:$L$95)/1000*'inputs¦other'!H13","v":0.8928044650190825},null,"Pipelines",{"$f":"K35","v":"$m real 2016/17"},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":7.0264754999999992},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":2.5462469999999993},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":0.86085449999999997},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":2.4439469999999996},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$L$17:$L$95)/1000","v":0.4516544999999999}]
[null,"Compressors",{"$f":"C36","v":"$m nominal"},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$97,'Input¦Historic'!B$17:B$97)/1000000","v":0.14324170000000019},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$97,'Input¦Historic'!C$17:C$97)/1000000","v":2.3529889999999998E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$97,'Input¦Historic'!D$17:D$97)/1000000","v":1E-8},{"$f":"SUMPRODUCT('Input¦Historic'!$K$17:$K$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$M$17:$M$95)/1000*'inputs¦other'!H13","v":0},null,"Compressors",{"$f":"K36","v":"$m real 2016/17"},{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0.10229999999999999},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0.10229999999999999},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$M$17:$M$95)/1000","v":0}]
[null,"Regulators and meters","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$97,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$L$17:$L$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$N$17:$N$95)/1000*'inputs¦other'!H13","v":0},null,"Regulators and meters","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":0.26145914912547702},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":8.1839999999999996E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$N$17:$N$95)/1000","v":0}]
[null,"Easements","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$97,'Input¦Historic'!B$17:B$97)/1000000","v":3.221123E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$97,'Input¦Historic'!C$17:C$97)/1000000","v":9.7457199999999994E-3},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$97,'Input¦Historic'!D$17:D$97)/1000000","v":6.1200000000000002E-4},{"$f":"SUMPRODUCT('Input¦Historic'!$M$17:$M$97,'Input¦Historic'!E$17:E$97)/1000000","v":7.4928140000000004E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$O$17:$O$95)/1000*'inputs¦other'!H13","v":0},null,"Easements","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$O$17:$O$95)/1000","v":0}]
[null,"Communications","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$97,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$N$17:$N$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$P$17:$P$95)/1000*'inputs¦other'!H13","v":0},null,"Communications","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$P$17:$P$95)/1000","v":0}]
[null,"Other","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$97,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$O$17:$O$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$Q$17:$Q$95)/1000*'inputs¦other'!H13","v":0},null,"Other","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$Q$17:$Q$95)/1000","v":0}]
[null,"Capitalised AA costs","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$97,'Input¦Historic'!B$17:B$97)/1000000","v":7.0875350000000004E-2},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$P$17:$P$97,'Input¦Historic'!E$17:E$97)/1000000","v":5.8008080000000004E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$R$17:$R$95)/1000*'inputs¦other'!H13","v":0.91185669695999994},null,"Capitalised AA costs","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":7.250548305E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":5.9342265839999991E-2},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$R$17:$R$95)/1000","v":0.91185669695999994}]
[null,"Group IT","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$97,'Input¦Historic'!B$17:B$97)/1000000","v":1.2922360665339567},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$97,'Input¦Historic'!C$17:C$97)/1000000","v":1.1467774598427101},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$97,'Input¦Historic'!D$17:D$97)/1000000","v":2.2840297709211552},{"$f":"SUMPRODUCT('Input¦Historic'!$Q$17:$Q$97,'Input¦Historic'!E$17:E$97)/1000000","v":1.5719107799229803},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$S$17:$S$95)/1000*'inputs¦other'!H13","v":1.4103896560595084},null,"Group IT","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":1.6142712126730265},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":0.59018528133882375},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":0.49139107309613422},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":0.63536214179687966},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$S$17:$S$95)/1000","v":0.42572883701583769}]
[null,"SIB Capex","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$97,'Input¦Historic'!B$17:B$97)/1000000","v":1.0154962299999999},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$97,'Input¦Historic'!C$17:C$97)/1000000","v":2.5494745400000003},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$97,'Input¦Historic'!D$17:D$97)/1000000","v":3.7652524999999999},{"$f":"SUMPRODUCT('Input¦Historic'!$R$17:$R$97,'Input¦Historic'!E$17:E$97)/1000000","v":1.8927300199999997},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$T$17:$T$95)/1000*'inputs¦other'!H13","v":0.92372449570348159},null,"SIB Capex","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":1.0276237281369265},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":1.0809179825095412},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":0.52849798250954116},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":0.55407298250954129},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$T$17:$T$95)/1000","v":0.29832298250954126}]
[null,"PMA","$m nominal",{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$97,'Input¦Historic'!B$17:B$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$97,'Input¦Historic'!C$17:C$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$97,'Input¦Historic'!D$17:D$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Historic'!$S$17:$S$97,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!B$17:B$95,'Input¦Forecast'!$U$17:$U$95)/1000*'inputs¦other'!H13","v":0},null,"PMA","$m real 2016/17",{"$f":"SUMPRODUCT('Input¦Forecast'!C$17:C$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!D$17:D$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!E$17:E$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!F$17:F$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0},{"$f":"SUMPRODUCT('Input¦Forecast'!G$17:G$95,'Input¦Forecast'!$U$17:$U$95)/1000","v":0}]
[null,"Total","$m nominal",{"$f":"SUM(D35:D45)","v":5.8780850665339575},{"$f":"SUM(E35:E45)","v":10.520954716541798},22.992176370921154,9.8724315799229796,18.219858813742071,null,"Total","$m real 2016/17",{"$f":"SUM(L35:L45)","v":25.92174957298543},15.909217263848364,6.8642880556056758,8.3668113901464185,8.3201905164853791]
[]
[null,"Check",null,{"$f":"D46=D29","v":true},true,true,true,{"$f":"H46=H29","v":true},null,"Check",null,{"$f":"L46-L31","v":0},{"$f":"M46-M31","v":0},{"$f":"N46-N31","v":0},{"$f":"O46-O31","v":0},{"$f":"P46-P31","v":0}]
[]
[null,"Driver",null,{"$f":"D34","v":2013},{"$f":"E34","v":2014},2015,2016,2017,null,"Driver",null,{"$f":"L34","v":2018},2019,2020,2021,2022]
[null,"Expansion/Extension",{"$f":"C46","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B51,'Input¦Historic'!B$17:B$97)/1000000","v":2.9231862600000009},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B51,'Input¦Historic'!C$17:C$97)/1000000","v":2.4030216700000002},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B51,'Input¦Historic'!D$17:D$97)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B51,'Input¦Historic'!E$17:E$97)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$B51,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},null,"Expansion/Extension",{"$f":"K46","v":"$m real 2016/17"},{"$f":"L19","v":0},{"$f":"M19","v":0},{"$f":"N19","v":0},{"$f":"O19","v":0},{"$f":"P19","v":0}]
[null,"Replacement",{"$f":"C51","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B52,'Input¦Historic'!B$17:B$97)/1000000","v":0.65139705000000003},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B52,'Input¦Historic'!C$17:C$97)/1000000","v":2.1298546599999999},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B52,'Input¦Historic'!D$17:D$97)/1000000","v":3.8819998099999995},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B52,'Input¦Historic'!E$17:E$97)/1000000","v":4.4306259800000003},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$B52,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":6.2546219999999986},null,"Replacement",{"$f":"K51","v":"$m real 2016/17"},{"$f":"L25","v":8.6954999999999991},{"$f":"M25","v":10.248413999999999},{"$f":"N25","v":5.4556589999999989},{"$f":"O25","v":6.8111339999999982},{"$f":"P25","v":6.377381999999999}]
[null,"Stay in business",{"$f":"C52","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B53,'Input¦Historic'!B$17:B$97)/1000000","v":2.3035017565339566},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B53,'Input¦Historic'!C$17:C$97)/1000000","v":5.9880783865417966},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B53,'Input¦Historic'!D$17:D$97)/1000000","v":19.091597540921157},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$97,$B53,'Input¦Historic'!E$17:E$97)/1000000","v":5.4418055999229802},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$B53,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":11.965236813742068},null,"Stay in business",{"$f":"K52","v":"$m real 2016/17"},{"$f":"L46-SUM(L51:L52)","v":17.226249572985431},{"$f":"M46-SUM(M51:M52)","v":5.660803263848365},1.4086290556056769,1.5556773901464203,1.9428085164853801]
[null,"Total",{"$f":"C53","v":"$m nominal"},{"$f":"SUM(D51:D53)","v":5.8780850665339575},{"$f":"SUM(E51:E53)","v":10.520954716541798},22.992176370921158,9.8724315799229814,{"$f":"SUM(H51:H53)","v":18.219858813742068},null,"Total",{"$f":"K53","v":"$m real 2016/17"},{"$f":"SUM(L51:L53)","v":25.92174957298543},15.909217263848364,6.8642880556056758,8.3668113901464185,8.3201905164853791]
[]
[null,"Check",null,{"$f":"D54=D46","v":true},true,true,true,true,null,"Check",null,{"$f":"L54-L46","v":0},0,0,0,0]
[]
[null,"Motor vehicle disposals","$m nominal",0.10868117999999999,6.6794679999999995E-2,4.0840309999999998E-2,null,null,null,"Motor vehicle disposals","$m real 2016/17"]
[null,"Capital contributions","$m nominal",null,{"$f":"95218.24/1000000","v":9.521824000000001E-2},null,null,null,null,"Capital contributions","$m real 2016/17"]
[null,"Total net capex","$m nominal",{"$f":"D54-D58-D59","v":5.7694038865339579},{"$f":"E54-E58-E59","v":10.358941796541799},22.951336060921157,9.8724315799229814,18.219858813742068,null,"Total net capex","$m real 2016/17",{"$f":"L54-L58-L59","v":25.92174957298543},{"$f":"M54-M59","v":15.909217263848364},{"$f":"N54-N59","v":6.8642880556056758},{"$f":"O54-O59","v":8.3668113901464185},{"$f":"P54-P59","v":8.3201905164853791}]
[]
[null,"Total net capex","$m real 2016/17",{"$f":"D60/'inputs¦other'!D13","v":6.2487437489787219},{"$f":"E60/'inputs¦other'!E13","v":10.945678734236552},{"$f":"F60/'inputs¦other'!F13","v":23.561048973355497},{"$f":"G60/'inputs¦other'!G13","v":10.001845477038078},{"$f":"H60/'inputs¦other'!H13","v":18.219858813742068}]