{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["inputs¦other","Input¦Historic","Input¦Forecast","Outputs│Tables","AER DRAFT inputs¦other","AER DRAFT Input¦Historic","AER DRAFT Input¦Forecast","AER DRAFT Outputs│Tables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":60,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"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},{"$f":"E13/(1+D15)","v":0.92329020332717182},{"$f":"F13/(1+E15)","v":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,{"$f":"G14*(1+G15)","v":1.1002456899457469}]
["CPI",null,{"$f":"'[2]Actual CPI'!$I$18","v":1.5846066779853007E-2},{"$f":"'[3]input⁞inflation'!J18","v":2.5025025025025016E-2},{"$f":"'[3]input⁞inflation'!K18","v":2.9296875E-2},{"$f":"'[3]input⁞inflation'!L18","v":1.3282732447817747E-2},{"$f":"'[3]input⁞inflation'!M18","v":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,{"$f":"[4]Input!G163","v":3.9933999999999998},{"$f":"[4]Input!H163","v":4.4607999999999999},{"$f":"[4]Input!I163","v":3.330225},{"$f":"[4]Input!J163","v":3.543425},{"$f":"[4]Input!K163","v":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,1329.8999999999999,1329.8999999999999,"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},{"$f":"SUM(C17:C95)","v":25921.749572985427},{"$f":"SUM(D17:D95)","v":15909.217263848363},6864.2880556056734,8366.8113901464203,9650.0905164853775,84932.015612813368]

{"sheet":"Outputs│Tables","index":3,"n_rows":84,"n_cols":28,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Outputs│Tables"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Capex"]
["Capex by project ($m nominal)",null,null,null,null,null,null,null,null,null,null,null,null,"Capex by project ($m real 2016/17)",null,null,null,null,null,null,null,null,null,null,null,null,"Proposal ($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,null,"Current","Forecast"]
[{"$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},null,{"$f":"SUM(P15:T15)","v":2.0107488151625286},{"$f":"SUM(U15:Y15)","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},null,{"$f":"SUM(P16:T16)","v":7.8376547892672761},{"$f":"SUM(U16:Y16)","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},null,8.3677039132123046,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},null,0.98392055395131695,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},null,5.7242564864878585,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},null,1.1456598055818976,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},null,1.3469355865513317,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},null,1.0473890750956638,1.04370444585]
["Stay in business","$m nominal",{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,\"SIB\",'Input¦Historic'!B$17:B$98)/1000000","v":1.8456897165339565},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,\"SIB\",'Input¦Historic'!C$17:C$98)/1000000","v":2.1865778498427106},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,\"SIB\",'Input¦Historic'!D$17:D$98)/1000000","v":3.2043394809211554},{"$f":"SUMIF('Input¦Historic'!$G$17:$G$98,\"SIB\",'Input¦Historic'!E$17:E$98)/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},null,13.899305662183984,5.7179225064166097]
[{"$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},null,8.1839999999999993,2.9155499999999996]
[{"$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},null,18.453526492232765,37.588088999999997]
[{"$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},null,0.30689999999999995,15.498449999999998]
[{"$f":"'inputs¦other'!A52","v":"Dalby Turbine Overhaul"},"$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},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A27,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":1.4900373492954211},null,"Dalby Turbine Overhaul","$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},{"$f":"I27/'inputs¦other'!J$13","v":0},{"$f":"J27/'inputs¦other'!K$13","v":0},{"$f":"K27/'inputs¦other'!L$13","v":0},{"$f":"L27/'inputs¦other'!M$13","v":1.3298999999999999},null,0,1.3298999999999999]
[{"$f":"'inputs¦other'!A53","v":"Applications and 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.43552060026720191},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0.55659911427713848},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0.45578493827703448},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0.58249711446533936},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A28,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0.47699215567012648},null,"Applications and 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.42572883701583769},{"$f":"I28/'inputs¦other'!J$13","v":0.53185254711253926},{"$f":"J28/'inputs¦other'!K$13","v":0.42572883701583769},{"$f":"K28/'inputs¦other'!L$13","v":0.53185254711253926},{"$f":"L28/'inputs¦other'!M$13","v":0.42572883701583769},null,0,2.3408916052725917]
[{"$f":"'inputs¦other'!A54","v":"Infrastructure Renewals"},"$m nominal",0,0,0,0,{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A29,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A29,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0.1420175870436528},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A29,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":4.842799718188559E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A29,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":4.9541841117068955E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A29,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":5.0681303462761541E-2},{"$f":"SUMIF('Input¦Forecast'!$J$17:$J$95,$A29,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Infrastructure Renewals","$m real 2016/17",{"$f":"C29/'inputs¦other'!D$13","v":0},{"$f":"D29/'inputs¦other'!E$13","v":0},{"$f":"E29/'inputs¦other'!F$13","v":0},{"$f":"F29/'inputs¦other'!G$13","v":0},{"$f":"G29/'inputs¦other'!H$13","v":0},{"$f":"H29/'inputs¦other'!I$13","v":0.13882462076603402},{"$f":"I29/'inputs¦other'!J$13","v":4.6274873588678003E-2},{"$f":"J29/'inputs¦other'!K$13","v":4.6274873588678003E-2},{"$f":"K29/'inputs¦other'!L$13","v":4.6274873588678003E-2},{"$f":"L29/'inputs¦other'!M$13","v":0},null,0,0.27764924153206799]
["Total","$m nominal",{"$f":"SUM(C15:C29)","v":5.8780850665339575},10.5209547165418,22.992176370921158,9.8724315799229796,18.219858813742068,26.517949813164094,16.649457233917961,7.3489010743794818,9.1635238347458117,10.812087595792734,null,"Total",null,{"$f":"SUM(P15:P29)","v":6.3664544964862282},11.116868167283426,23.602974225177128,10.001845477038076,18.219858813742068,25.92174957298543,15.909217263848362,6.864288055605674,8.3668113901464185,9.6500905164853776,null,{"$f":"SUM(AA15:AA29)","v":69.308001179726915},{"$f":"SUM(AB15:AB29)","v":66.712156799071266}]
[]
["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":10.812087595792732},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":9.6500905164853776}]
["Difference",null,{"$f":"C30-C32","v":0},{"$f":"D30-D32","v":0},0,0,0,0,0,0,0,0,null,"Difference",null,{"$f":"P30-P32","v":0},{"$f":"Q30-Q32","v":0},{"$f":"R30-R32","v":0},{"$f":"S30-S32","v":0},{"$f":"T30-T32","v":0},{"$f":"U30-U32","v":0},{"$f":"V30-V32","v":0},{"$f":"W30-W32","v":0},{"$f":"X30-X32","v":0},{"$f":"Y30-Y32","v":0},null,"Gross Capex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposal ($2016/17)"]
["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,null,"Current","Forecast"]
["Original Pipeline",{"$f":"B30","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":"O29","v":"$m real 2016/17"},{"$f":"C36/'inputs¦other'!D$13","v":0.52274699575575578},{"$f":"D36/'inputs¦other'!E$13","v":3.645936831742389},{"$f":"E36/'inputs¦other'!F$13","v":6.7100030384345359},{"$f":"F36/'inputs¦other'!G$13","v":5.7350427082022479},{"$f":"G36/'inputs¦other'!H$13","v":14.0810835},{"$f":"H36/'inputs¦other'!I$13","v":15.817114499999999},{"$f":"I36/'inputs¦other'!J$13","v":11.589566999999999},{"$f":"J36/'inputs¦other'!K$13","v":4.9017045000000001},{"$f":"K36/'inputs¦other'!L$13","v":4.6740869999999983},{"$f":"L36/'inputs¦other'!M$13","v":6.2326274999999995},null,{"$f":"SUM(P36:T36)","v":30.694813074134927},{"$f":"SUM(U36:Y36)","v":43.215100499999998}]
["Pipelines",{"$f":"B36","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":"O36","v":"$m real 2016/17"},{"$f":"C37/'inputs¦other'!D$13","v":3.0774476971171172},{"$f":"D37/'inputs¦other'!E$13","v":3.530160950922077},{"$f":"E37/'inputs¦other'!F$13","v":10.682358651679316},{"$f":"F37/'inputs¦other'!G$13","v":0.62206649958801508},{"$f":"G37/'inputs¦other'!H$13","v":0.8928044650190825},{"$f":"H37/'inputs¦other'!I$13","v":7.0264754999999992},{"$f":"I37/'inputs¦other'!J$13","v":2.5462469999999993},{"$f":"J37/'inputs¦other'!K$13","v":0.86085449999999997},{"$f":"K37/'inputs¦other'!L$13","v":2.4439469999999996},{"$f":"L37/'inputs¦other'!M$13","v":0.45165449999999996},null,{"$f":"SUM(P37:T37)","v":18.80483826432561},{"$f":"SUM(U37:Y37)","v":13.329178499999998}]
["Compressors",{"$f":"B37","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":1.4900373492954211},null,"Compressors",{"$f":"O37","v":"$m real 2016/17"},{"$f":"C38/'inputs¦other'!D$13","v":0.15514266206206229},{"$f":"D38/'inputs¦other'!E$13","v":2.486263767578125E-2},{"$f":"E38/'inputs¦other'!F$13","v":1.0265654648956358E-8},{"$f":"F38/'inputs¦other'!G$13","v":0},{"$f":"G38/'inputs¦other'!H$13","v":0},{"$f":"H38/'inputs¦other'!I$13","v":0.10229999999999999},{"$f":"I38/'inputs¦other'!J$13","v":0.10229999999999999},{"$f":"J38/'inputs¦other'!K$13","v":0},{"$f":"K38/'inputs¦other'!L$13","v":0},{"$f":"L38/'inputs¦other'!M$13","v":1.3298999999999999},null,0.1800053100034982,1.5344999999999998]
["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":"C39/'inputs¦other'!D$13","v":0},{"$f":"D39/'inputs¦other'!E$13","v":0},{"$f":"E39/'inputs¦other'!F$13","v":0},{"$f":"F39/'inputs¦other'!G$13","v":0},{"$f":"G39/'inputs¦other'!H$13","v":0},{"$f":"H39/'inputs¦other'!I$13","v":0.26145914912547702},{"$f":"I39/'inputs¦other'!J$13","v":0},{"$f":"J39/'inputs¦other'!K$13","v":8.1839999999999996E-2},{"$f":"K39/'inputs¦other'!L$13","v":0},{"$f":"L39/'inputs¦other'!M$13","v":0},null,0,0.34329914912547699]
["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":"C40/'inputs¦other'!D$13","v":3.4887438298298303E-2},{"$f":"D40/'inputs¦other'!E$13","v":1.0297723671875E-2},{"$f":"E40/'inputs¦other'!F$13","v":6.2825806451612912E-4},{"$f":"F40/'inputs¦other'!G$13","v":7.5910344082397024E-2},{"$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},null,0.12172376411708646,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":"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},null,0,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":"C42/'inputs¦other'!D$13","v":0},{"$f":"D42/'inputs¦other'!E$13","v":0},{"$f":"E42/'inputs¦other'!F$13","v":0},{"$f":"F42/'inputs¦other'!G$13","v":0},{"$f":"G42/'inputs¦other'!H$13","v":0},{"$f":"H42/'inputs¦other'!I$13","v":0},{"$f":"I42/'inputs¦other'!J$13","v":0},{"$f":"J42/'inputs¦other'!K$13","v":0},{"$f":"K42/'inputs¦other'!L$13","v":0},{"$f":"L42/'inputs¦other'!M$13","v":0},null,0,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":"C43/'inputs¦other'!D$13","v":7.67638925925926E-2},{"$f":"D43/'inputs¦other'!E$13","v":0},{"$f":"E43/'inputs¦other'!F$13","v":0},{"$f":"F43/'inputs¦other'!G$13","v":5.8768485543071174E-2},{"$f":"G43/'inputs¦other'!H$13","v":0.91185669695999994},{"$f":"H43/'inputs¦other'!I$13","v":7.250548305E-2},{"$f":"I43/'inputs¦other'!J$13","v":0},{"$f":"J43/'inputs¦other'!K$13","v":0},{"$f":"K43/'inputs¦other'!L$13","v":5.9342265839999991E-2},{"$f":"L43/'inputs¦other'!M$13","v":0.91185669696000005},null,1.0473890750956638,1.04370444585]
["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":"C44/'inputs¦other'!D$13","v":1.399599023012754},{"$f":"D44/'inputs¦other'!E$13","v":1.2117316519041137},{"$f":"E44/'inputs¦other'!F$13","v":2.3447060836211482},{"$f":"F44/'inputs¦other'!G$13","v":1.592516351944443},{"$f":"G44/'inputs¦other'!H$13","v":1.4103896560595084},{"$f":"H44/'inputs¦other'!I$13","v":1.6142712126730265},{"$f":"I44/'inputs¦other'!J$13","v":0.59018528133882375},{"$f":"J44/'inputs¦other'!K$13","v":0.49139107309613422},{"$f":"K44/'inputs¦other'!L$13","v":0.63536214179687966},{"$f":"L44/'inputs¦other'!M$13","v":0.42572883701583769},null,7.9589427665419672,3.7569385459207023]
["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":"C45/'inputs¦other'!D$13","v":1.0998667876476476},{"$f":"D45/'inputs¦other'!E$13","v":2.6938783713671883},{"$f":"E45/'inputs¦other'!F$13","v":3.8652781831119549},{"$f":"F45/'inputs¦other'!G$13","v":1.9175410876779027},{"$f":"G45/'inputs¦other'!H$13","v":0.92372449570348159},{"$f":"H45/'inputs¦other'!I$13","v":1.0276237281369265},{"$f":"I45/'inputs¦other'!J$13","v":1.0809179825095412},{"$f":"J45/'inputs¦other'!K$13","v":0.52849798250954116},{"$f":"K45/'inputs¦other'!L$13","v":0.55407298250954129},{"$f":"L45/'inputs¦other'!M$13","v":0.29832298250954126},null,10.500288925508174,3.4894356581750916]
["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":"C46/'inputs¦other'!D$13","v":0},{"$f":"D46/'inputs¦other'!E$13","v":0},{"$f":"E46/'inputs¦other'!F$13","v":0},{"$f":"F46/'inputs¦other'!G$13","v":0},{"$f":"G46/'inputs¦other'!H$13","v":0},{"$f":"H46/'inputs¦other'!I$13","v":0},{"$f":"I46/'inputs¦other'!J$13","v":0},{"$f":"J46/'inputs¦other'!K$13","v":0},{"$f":"K46/'inputs¦other'!L$13","v":0},{"$f":"L46/'inputs¦other'!M$13","v":0},null,0,0]
["Total","$m nominal",{"$f":"SUM(C36:C46)","v":5.8780850665339575},{"$f":"SUM(D36:D46)","v":10.520954716541798},22.992176370921154,9.8724315799229796,18.219858813742071,26.517949813164091,16.649457233917961,7.3489010743794836,9.1635238347458117,10.812087595792732,null,"Total","$m real 2016/17",{"$f":"SUM(P36:P46)","v":6.3664544964862273},{"$f":"SUM(Q36:Q46)","v":11.116868167283425},{"$f":"SUM(R36:R46)","v":23.602974225177125},{"$f":"SUM(S36:S46)","v":10.001845477038076},{"$f":"SUM(T36:T46)","v":18.219858813742071},{"$f":"SUM(U36:U46)","v":25.921749572985433},{"$f":"SUM(V36:V46)","v":15.909217263848364},{"$f":"SUM(W36:W46)","v":6.8642880556056758},{"$f":"SUM(X36:X46)","v":8.3668113901464185},{"$f":"SUM(Y36:Y46)","v":9.6500905164853776},null,{"$f":"SUM(AA36:AA46)","v":69.308001179726929},{"$f":"SUM(AB36:AB46)","v":66.712156799071266}]
[]
["Check",null,{"$f":"C47=C30","v":true},true,true,true,{"$f":"G47=G30","v":true},{"$f":"H47=H30","v":true},true,true,true,true,null,"Check",null,{"$f":"P47=P32","v":true},{"$f":"Q47=Q32","v":true},true,true,true,true,true,false,true,true,null,"Gross Capex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposal ($2016/17)"]
["Driver",null,{"$f":"C35","v":2013},{"$f":"D35","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,null,"Driver",null,{"$f":"P35","v":2013},{"$f":"Q35","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,null,"Current","Forecast"]
["Expansion/Extension",{"$f":"B47","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A52,'Input¦Historic'!B$17:B$98)/1000000","v":2.9231862600000009},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A52,'Input¦Historic'!C$17:C$98)/1000000","v":2.4030216700000002},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A52,'Input¦Historic'!D$17:D$98)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A52,'Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":0},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A52,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":0},null,"Expansion/Extension",{"$f":"O47","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":3.1660535869069082},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N52,'Input¦Historic'!C$17:C$98)/1000000/'inputs¦other'!E$13","v":2.5391303192773442},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N52,'Input¦Historic'!D$17:D$98)/1000000/'inputs¦other'!F$13","v":1.9072580303605313E-2},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N52,'Input¦Historic'!E$17:E$98)/1000000/'inputs¦other'!G$13","v":0},{"$f":"T19","v":0},0,0,0,0,0,null,{"$f":"SUM(P52:T52)","v":5.7242564864878585},{"$f":"SUM(U52:Y52)","v":0}]
["Replacement",{"$f":"B52","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A53,'Input¦Historic'!B$17:B$98)/1000000","v":0.65139705000000003},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A53,'Input¦Historic'!C$17:C$98)/1000000","v":2.1298546599999999},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A53,'Input¦Historic'!D$17:D$98)/1000000","v":3.8819998099999995},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A53,'Input¦Historic'!E$17:E$98)/1000000","v":4.4306259800000003},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":6.2546219999999986},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":8.8954964999999984},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":10.725262455005996},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":5.84082398083605},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":7.4597102576200571},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A53,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":7.1453021811597344},null,"Replacement",{"$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":0.70551712522522536},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N53,'Input¦Historic'!C$17:C$98)/1000000/'inputs¦other'!E$13","v":2.2504909591015627},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N53,'Input¦Historic'!D$17:D$98)/1000000/'inputs¦other'!F$13","v":3.9851269396774192},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N53,'Input¦Historic'!E$17:E$98)/1000000/'inputs¦other'!G$13","v":4.4887053467790272},{"$f":"T25","v":6.2546219999999986},{"$f":"U25","v":8.6954999999999991},{"$f":"V25","v":10.248413999999999},5.4556589999999989,6.8111339999999982,6.377381999999999,null,{"$f":"SUM(P53:T53)","v":17.684462370783233},{"$f":"SUM(U53:Y53)","v":37.588088999999997}]
["Stay in business",{"$f":"B53","v":"$m nominal"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A54,'Input¦Historic'!B$17:B$98)/1000000","v":2.3035017565339566},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A54,'Input¦Historic'!C$17:C$98)/1000000","v":5.9880783865417966},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A54,'Input¦Historic'!D$17:D$98)/1000000","v":19.091597540921157},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$A54,'Input¦Historic'!E$17:E$98)/1000000","v":5.4418055999229802},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A54,'Input¦Forecast'!B$17:B$95)/1000*'inputs¦other'!H$13","v":11.965236813742068},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A54,'Input¦Forecast'!C$17:C$95)/1000*'inputs¦other'!I$13","v":17.62245331316409},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A54,'Input¦Forecast'!D$17:D$95)/1000*'inputs¦other'!J$13","v":5.9241947789119642},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A54,'Input¦Forecast'!E$17:E$95)/1000*'inputs¦other'!K$13","v":1.5080770935434322},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A54,'Input¦Forecast'!F$17:F$95)/1000*'inputs¦other'!L$13","v":1.7038135771257559},{"$f":"SUMIF('Input¦Forecast'!$I$17:$I$95,$A54,'Input¦Forecast'!G$17:G$95)/1000*'inputs¦other'!M$13","v":3.6667854146329981},null,"Stay in business",{"$f":"O53","v":"$m real 2016/17"},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N54,'Input¦Historic'!B$17:B$98)/1000000/'inputs¦other'!D$13","v":2.4948837843540952},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N54,'Input¦Historic'!C$17:C$98)/1000000/'inputs¦other'!E$13","v":6.3272468889045159},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N54,'Input¦Historic'!D$17:D$98)/1000000/'inputs¦other'!F$13","v":19.598774705196103},{"$f":"SUMIF('Input¦Historic'!$H$17:$H$98,$N54,'Input¦Historic'!E$17:E$98)/1000000/'inputs¦other'!G$13","v":5.5131401302590497},{"$f":"T47-SUM(T52:T53)","v":11.965236813742074},{"$f":"U47-SUM(U52:U53)","v":17.226249572985434},5.660803263848365,1.4086290556056769,1.5556773901464203,3.2727085164853786,null,{"$f":"SUM(P54:T54)","v":45.899282322455839},{"$f":"SUM(U54:Y54)","v":29.124067799071277}]
["Total",{"$f":"B54","v":"$m nominal"},{"$f":"SUM(C52:C54)","v":5.8780850665339575},{"$f":"SUM(D52:D54)","v":10.520954716541798},22.992176370921158,9.8724315799229814,{"$f":"SUM(G52:G54)","v":18.219858813742068},{"$f":"SUM(H52:H54)","v":26.517949813164087},16.649457233917961,7.3489010743794818,9.1635238347458134,10.812087595792732,null,"Total",{"$f":"O54","v":"$m real 2016/17"},{"$f":"SUM(P52:P54)","v":6.3664544964862291},{"$f":"SUM(Q52:Q54)","v":11.116868167283423},{"$f":"SUM(R52:R54)","v":23.602974225177128},{"$f":"SUM(S52:S54)","v":10.001845477038078},{"$f":"SUM(T52:T54)","v":18.219858813742071},{"$f":"SUM(U52:U54)","v":25.921749572985433},{"$f":"SUM(V52:V54)","v":15.909217263848364},{"$f":"SUM(W52:W54)","v":6.8642880556056758},{"$f":"SUM(X52:X54)","v":8.3668113901464185},{"$f":"SUM(Y52:Y54)","v":9.6500905164853776},null,{"$f":"SUM(AA52:AA54)","v":69.308001179726929},{"$f":"SUM(AB52:AB54)","v":66.712156799071266}]
[]
["Check",null,{"$f":"C55=C47","v":true},true,true,true,true,true,true,true,true,true,null,"Check",null,{"$f":"P55=P47","v":true},true,true,true,true,true,true,true,true,true]
[]
["AER Forecast by Driver",null,{"$f":"C51","v":2013},{"$f":"D51","v":2014},2015,2016,2017,null,null,null,null,null,null,{"$f":"A59","v":"AER Forecast by Driver"},null,{"$f":"P51","v":2013},{"$f":"Q51","v":2014},2015,2016,2017]
[{"$f":"A52","v":"Expansion/Extension"},{"$f":"B52","v":"$m nominal"},0,0,0,0,0,null,null,null,null,null,null,{"$f":"N52","v":"Expansion/Extension"},{"$f":"O52","v":"$m real 2016/17"},0,0,0,0,0]
[{"$f":"A53","v":"Replacement"},{"$f":"B53","v":"$m nominal"},0,0,0,0,0,null,null,null,null,null,null,{"$f":"N53","v":"Replacement"},{"$f":"O53","v":"$m real 2016/17"},0,0,0,0,0]
[{"$f":"A54","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,null,null,null,null,null,{"$f":"N54","v":"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}]
[{"$f":"A55","v":"Total"},"$m nominal",{"$f":"SUM(C60:C62)","v":4.0566796830786647},{"$f":"SUM(D60:D62)","v":4.644886688612778},{"$f":"SUM(E60:E62)","v":3.5692469969969975},{"$f":"SUM(F60:F62)","v":3.8481935985221218},{"$f":"SUM(G60:G62)","v":3.2828855835178712},null,null,null,null,null,null,{"$f":"N55","v":"Total"},"$m real 2016/17",{"$f":"SUM(P60:P62)","v":4.3937211382293455},{"$f":"SUM(Q60:Q62)","v":4.9079759737099877},3.6640657027995749,3.898638083896008,3.2828855835178707]
[]
["Difference",null,{"$f":"C59","v":2013},{"$f":"D59","v":2014},2015,2016,2017,null,null,null,null,null,null,"Difference",null,{"$f":"P59","v":2013},{"$f":"Q59","v":2014},2015,2016,2017]
[{"$f":"A60","v":"Expansion/Extension"},{"$f":"B60","v":"$m nominal"},{"$f":"C52-C60","v":2.9231862600000009},{"$f":"D52-D60","v":2.4030216700000002},1.8579019999999998E-2,0,0,null,null,null,null,null,null,{"$f":"N60","v":"Expansion/Extension"},{"$f":"O60","v":"$m real 2016/17"},{"$f":"P52-P60","v":3.1660535869069082},{"$f":"Q52-Q60","v":2.5391303192773442},1.9072580303605313E-2,0,0]
[{"$f":"A61","v":"Replacement"},"$m nominal",{"$f":"C53-C61","v":0.65139705000000003},2.1298546599999999,3.8819998099999995,4.4306259800000003,6.2546219999999986,null,null,null,null,null,null,{"$f":"N61","v":"Replacement"},"$m real 2016/17",{"$f":"P53-P61","v":0.70551712522522536},2.2504909591015627,3.9851269396774192,4.4887053467790272,6.2546219999999986]
[{"$f":"A62","v":"Stay in business"},"$m nominal",{"$f":"C54-C62","v":-1.7531779265447081},1.3431916979290186,15.522350543924158,1.5936120014008583,8.6823512302241976,null,null,null,null,null,null,{"$f":"N62","v":"Stay in business"},"$m real 2016/17",-1.8988373538752503,1.4192709151945282,15.934709002396527,1.6145020463630417,8.682351230224203]
[{"$f":"A63","v":"Total"},"$m nominal",{"$f":"SUM(C66:C68)","v":1.8214053834552928},{"$f":"SUM(D66:D68)","v":5.8760680279290192},{"$f":"SUM(E66:E68)","v":19.422929373924159},{"$f":"SUM(F66:F68)","v":6.0242379814008586},{"$f":"SUM(G66:G68)","v":14.936973230224197},null,null,null,null,null,null,{"$f":"N63","v":"Total"},"$m real 2016/17",{"$f":"SUM(P66:P68)","v":1.9727333582568831},{"$f":"SUM(Q66:Q68)","v":6.2088921935734351},19.938908522377552,6.1032073931420694,14.936973230224201]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Capex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposal ($2016/17)"]
["Asset disposals",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Asset disposals",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Current","Forecast"]
["Motor vehicle disposals",{"$f":"B73","v":0},0.10868117999999999,6.6794679999999995E-2,4.0840309999999998E-2,0,0,null,null,null,null,null,null,"Motor vehicle disposals",{"$f":"O73","v":0},{"$f":"C78/'inputs¦other'!D13","v":0.1177107475075075},{"$f":"D78/'inputs¦other'!E13","v":7.057797242187501E-2},{"$f":"E78/'inputs¦other'!F13","v":4.1925251821631877E-2},{"$f":"F78/'inputs¦other'!G13","v":0},{"$f":"G78/'inputs¦other'!H13","v":0},null,null,null,null,null,null,{"$f":"SUM(P78:T78)","v":0.23021397175101438},{"$f":"SUM(U78:Y78)","v":0}]
[]
["Contributions",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Contributions",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Current","Forecast"]
["Capital contributions","$m nominal",null,{"$f":"95218.24/1000000","v":9.521824000000001E-2},null,null,null,null,null,null,null,null,null,"Capital contributions","$m nominal",{"$f":"C81/'inputs¦other'!D13","v":0},{"$f":"D81/'inputs¦other'!E13","v":0.10061146062500002},{"$f":"E81/'inputs¦other'!F13","v":0},{"$f":"F81/'inputs¦other'!G13","v":0},{"$f":"G81/'inputs¦other'!H13","v":0},null,null,null,null,null,null,{"$f":"SUM(P81:T81)","v":0.10061146062500002},{"$f":"SUM(U81:Y81)","v":0}]
[]
["Total net capex",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Total net capex",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Current","Forecast"]
["Total net capex","$m nominal",{"$f":"C55-C78-C81","v":5.7694038865339579},{"$f":"D55-D78-D81","v":10.358941796541799},22.951336060921157,9.8724315799229814,18.219858813742068,{"$f":"H59-H78-H81","v":0},0,0,0,0,null,"Total net capex","$m nominal",{"$f":"P55-P78-P81","v":6.2487437489787219},{"$f":"Q55-Q78-Q81","v":10.945678734236548},23.561048973355497,10.001845477038078,{"$f":"T55-T78-T81","v":18.219858813742071},{"$f":"U55-U78-U81","v":25.921749572985433},15.909217263848364,6.8642880556056758,8.3668113901464185,9.6500905164853776,null,{"$f":"AA55-AA78-AA81","v":68.977175747350913},{"$f":"SUM(U84:Y84)","v":66.712156799071266}]

{"sheet":"AER DRAFT inputs¦other","index":4,"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":"AER DRAFT 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.90889957514783848},{"$f":"E13/(1+D15)","v":0.92330205851181113},{"$f":"F13/(1+E15)","v":0.94638460997460627},{"$f":"G13/(1+F15)","v":0.9741136790468623},{"$f":"H13/(1+G15)","v":0.98706939097818569},1,{"$f":"H13*(1+I15)","v":1.02},{"$f":"I13*(1+J15)","v":1.0404},{"$f":"J13*(1+K15)","v":1.0612079999999999},{"$f":"K13*(1+L15)","v":1.08243216},{"$f":"L13*(1+M15)","v":1.1040808032}]
["Inflation index","Base 2011/12",1,{"$f":"C14*(1+C15)^(10/12)","v":1.0131877248424552},{"$f":"D14*(1+D15)","v":1.0385174179635166},{"$f":"E14*(1+E15)","v":1.0689459783098478},{"$f":"F14*(1+F15)","v":1.083162959821369},{"$f":"G14*(1+G15)","v":1.097352394595029}]
["CPI",null,1.5846066779853007E-2,2.5000000000000001E-2,2.93E-2,1.3299999999999999E-2,1.3100000000000001E-2,0.02,{"$f":"H15","v":0.02},{"$f":"I15","v":0.02},{"$f":"J15","v":0.02},{"$f":"K15","v":0.02},{"$f":"L15","v":0.02}]
[]
["Asset Classes",null,"Inflation index updated to reflect RFM"]
["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,{"$f":"[4]Input!G163","v":3.9933999999999998},{"$f":"[4]Input!H163","v":4.4607999999999999},{"$f":"[4]Input!I163","v":3.330225},{"$f":"[4]Input!J163","v":3.543425},{"$f":"[4]Input!K163","v":2.9837750000000001}]
["Forecast capex","$m 2016/17",null,{"$f":"D33/$C$13","v":4.3936647229155623},{"$f":"E33/$C$13","v":4.9079129553717982},{"$f":"F33/$C$13","v":3.6640186562506831},{"$f":"G33/$C$13","v":3.8985880254412471},{"$f":"H33/$C$13","v":3.2828434313160169}]
["Forecast Capex","$m nominal",null,{"$f":"D33*D14","v":4.0460638603858605},{"$f":"E33*E14","v":4.6326184980516549},3.5598306206169128,3.8381067109050346,3.2742526411827826]
[]
["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":"AER DRAFT Input¦Historic","index":5,"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,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,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,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,null,0,0,"Flood Damage","Stay in Business",0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Flood damage",null,0,0,0,0,"Flood Damage","Stay in Business",null,0.62669315873081044,null,null,null,null,null,null,null,0.37330684126918673,null,0.99999999999999711,"$2015/16"]
["Flood Damage",0,null,null,0,0,"Flood Damage","Stay in Business",0.5,0.5,null,null,null,null,null,null,null,null,null,1,"$2015/16"]
["Toowoomba Escarpment",0,null,null,0,0,"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":5780058.2265339578},{"$f":"SUM(C17:C100)","v":8726412.4698427096},{"$f":"SUM(D17:D100)","v":17307884.880921155},{"$f":"SUM(E17:E100)","v":9872431.5799229778},{"$f":"SUM(F17:F100)","v":41591568.917220794}]

{"sheet":"AER DRAFT Input¦Forecast","index":6,"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,3034.5644348314604,4057.1504775280901,3706.7871761236001,3249.5552514044903,3739.6564213483102,22800.413761235952,"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,null,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},23541.575007816889,13859.057741376453,{"$f":"SUM(E17:E95)","v":6499.5352317292745},7851.7266415509112,7731.5339378336885,77703.287374049323]

{"sheet":"AER DRAFT Outputs│Tables","index":7,"n_rows":80,"n_cols":29,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"AER DRAFT Outputs│Tables"}]
["Proposed capex and draft decision - based on AER adjusted inflation ('AER DRAFT inputs|other' worksheet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Capex"]
["Capex by project ($m nominal)",null,null,null,null,null,null,null,null,null,null,null,null,"Capex by project ($m real 2016/17)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Draft Decision ($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,null,null,"Current","Forecast"]
[{"$f":"'inputs¦other'!A38","v":"Aquarium Passage"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A15,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0.20340742000000001},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A15,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0.60615213000000001},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A15,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":1.1201981299999999},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A15,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A15,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A15,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A15,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A15,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A15,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A15,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,{"$f":"A15","v":"Aquarium Passage"},"$m real 2016/17",{"$f":"C15/'AER DRAFT inputs¦other'!D$13","v":0.22030430683524568},{"$f":"D15/'AER DRAFT inputs¦other'!E$13","v":0.64049237869185605},{"$f":"E15/'AER DRAFT inputs¦other'!F$13","v":1.14996653275219},{"$f":"F15/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G15/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H15/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I15/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J15/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K15/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L15/'AER DRAFT inputs¦other'!M$13","v":0},null,null,{"$f":"SUM(P15:T15)","v":2.0107632182792918},{"$f":"SUM(U15:Y15)","v":0}]
[{"$f":"'inputs¦other'!A39","v":"Flood Damage"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A16,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A16,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A16,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A16,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A16,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A16,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A16,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A16,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A16,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A16,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,{"$f":"A16","v":"Flood Damage"},"$m real 2016/17",{"$f":"C16/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D16/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E16/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F16/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G16/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H16/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I16/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J16/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K16/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L16/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0,{"$f":"SUM(U16:Y16)","v":0}]
[{"$f":"'inputs¦other'!A40","v":"Bi direction"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A17,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A17,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A17,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":7.5451957800000002},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A17,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0.61401757999999995},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A17,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A17,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A17,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A17,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A17,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A17,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"Bi direction","$m real 2016/17",{"$f":"C17/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D17/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E17/'AER DRAFT inputs¦other'!F$13","v":7.7457035480527514},{"$f":"F17/'AER DRAFT inputs¦other'!G$13","v":0.62206121029799999},{"$f":"G17/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H17/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I17/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J17/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K17/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L17/'AER DRAFT inputs¦other'!M$13","v":0},null,null,8.3677647583507522,0]
[{"$f":"'inputs¦other'!A42","v":"Clear SCADA"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A18,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A18,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0.39804328000000005},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A18,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0.54875395000000038},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A18,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A18,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A18,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A18,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A18,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A18,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A18,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"Clear SCADA","$m real 2016/17",{"$f":"C18/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D18/'AER DRAFT inputs¦other'!E$13","v":0.42059356820128391},{"$f":"E18/'AER DRAFT inputs¦other'!F$13","v":0.563336663680709},{"$f":"F18/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G18/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H18/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I18/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J18/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K18/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L18/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0.98393023188199291,0]
[{"$f":"'inputs¦other'!A43","v":"RBP Looping"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A19,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":2.9231862600000009},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A19,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.4030216700000002},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A19,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A19,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A19,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A19,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A19,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A19,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A19,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A19,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"RBP Looping","$m real 2016/17",{"$f":"C19/'AER DRAFT inputs¦other'!D$13","v":3.1660129348261457},{"$f":"D19/'AER DRAFT inputs¦other'!E$13","v":2.5391597080857844},{"$f":"E19/'AER DRAFT inputs¦other'!F$13","v":1.9072743150654603E-2},{"$f":"F19/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G19/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H19/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I19/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J19/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K19/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L19/'AER DRAFT inputs¦other'!M$13","v":0},null,null,5.7242453860625844,0]
[{"$f":"'inputs¦other'!A44","v":"FC and RTU upgrade"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A20,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":2.6835999999999999E-2},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A20,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0.44239340000000005},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A20,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0.53151580999999992},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A20,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0.10216828999999999},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A20,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A20,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A20,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A20,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A20,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A20,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"FC and RTU upgrade","$m real 2016/17",{"$f":"C20/'AER DRAFT inputs¦other'!D$13","v":2.9065244415521583E-2},{"$f":"D20/'AER DRAFT inputs¦other'!E$13","v":0.46745624911617117},{"$f":"E20/'AER DRAFT inputs¦other'!F$13","v":0.54564043338357637},{"$f":"F20/'AER DRAFT inputs¦other'!G$13","v":0.103506694599},{"$f":"G20/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H20/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I20/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J20/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K20/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L20/'AER DRAFT inputs¦other'!M$13","v":0},null,null,1.1456686215142691,0]
[{"$f":"'inputs¦other'!A45","v":"Toowoomba Station Upgrade"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A21,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":5.6110010000000002E-2},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A21,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0.40998034},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A21,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0.83088894999999996},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A21,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A21,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A21,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A21,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A21,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A21,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A21,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"Toowoomba Station Upgrade","$m real 2016/17",{"$f":"C21/'AER DRAFT inputs¦other'!D$13","v":6.0771022313584742E-2},{"$f":"D21/'AER DRAFT inputs¦other'!E$13","v":0.43320689672986201},{"$f":"E21/'AER DRAFT inputs¦other'!F$13","v":0.85296918406175859},{"$f":"F21/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G21/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H21/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I21/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J21/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K21/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L21/'AER DRAFT inputs¦other'!M$13","v":0},null,null,1.3469471031052054,0]
[{"$f":"'inputs¦other'!A46","v":"Access Arrangement"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A22,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":7.0875350000000004E-2},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A22,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A22,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A22,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":5.8008080000000004E-2},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A22,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0.91185669695999994},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A22,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":7.3955592710999996E-2},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A22,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A22,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A22,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":6.4233976992485398E-2},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A22,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":1.0067634743828957},null,"Access Arrangement","$m real 2016/17",{"$f":"C22/'AER DRAFT inputs¦other'!D$13","v":7.6762906945358395E-2},{"$f":"D22/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E22/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F22/'AER DRAFT inputs¦other'!G$13","v":5.8767985848000005E-2},{"$f":"G22/'AER DRAFT inputs¦other'!H$13","v":0.91185669695999994},{"$f":"H22/'AER DRAFT inputs¦other'!I$13","v":7.250548305E-2},{"$f":"I22/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J22/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K22/'AER DRAFT inputs¦other'!L$13","v":5.9342265839999984E-2},{"$f":"L22/'AER DRAFT inputs¦other'!M$13","v":0.91185669695999994},null,null,1.0473875897533582,1.04370444585]
["Stay in business","$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,\"SIB\",'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":1.8456897165339565},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,\"SIB\",'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.1865778498427106},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,\"SIB\",'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":3.2043394809211554},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,\"SIB\",'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":3.6895343199229798},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A23,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":2.5624801167820719},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A23,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":3.0429564447966295},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A23,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":1.2435649872102925},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A23,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0.66826957391799058},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A23,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0.66169911803802028},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A23,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0.32937267814215387},null,"Stay in business","$m real 2016/17",{"$f":"C23/'AER DRAFT inputs¦other'!D$13","v":1.9990096410148379},{"$f":"D23/'AER DRAFT inputs¦other'!E$13","v":2.3104537275826811},{"$f":"E23/'AER DRAFT inputs¦other'!F$13","v":3.2894923352852357},{"$f":"F23/'AER DRAFT inputs¦other'!G$13","v":3.7378672195139711},{"$f":"G23/'AER DRAFT inputs¦other'!H$13","v":2.5624801167820719},{"$f":"H23/'AER DRAFT inputs¦other'!I$13","v":2.9832906321535582},{"$f":"I23/'AER DRAFT inputs¦other'!J$13","v":1.1952758431471477},{"$f":"J23/'AER DRAFT inputs¦other'!K$13","v":0.62972534500115962},{"$f":"K23/'AER DRAFT inputs¦other'!L$13","v":0.61130770360520359},{"$f":"L23/'AER DRAFT inputs¦other'!M$13","v":0.29832298250954126},null,null,13.899303040178797,5.7179225064166097]
[{"$f":"'inputs¦other'!A49","v":"Urban Risk Reduction"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A24,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A24,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A24,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A24,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A24,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":8.1839999999999993},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A24,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":1.7217089999999999},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A24,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0.31929875999999996},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A24,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0.32568473519999991},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A24,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0.33219842990399995},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A24,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0.33884239850207998},null,"Urban Risk Reduction","$m real 2016/17",{"$f":"C24/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D24/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E24/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F24/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G24/'AER DRAFT inputs¦other'!H$13","v":8.1839999999999993},{"$f":"H24/'AER DRAFT inputs¦other'!I$13","v":1.6879499999999998},{"$f":"I24/'AER DRAFT inputs¦other'!J$13","v":0.30689999999999995},{"$f":"J24/'AER DRAFT inputs¦other'!K$13","v":0.30689999999999995},{"$f":"K24/'AER DRAFT inputs¦other'!L$13","v":0.30689999999999995},{"$f":"L24/'AER DRAFT inputs¦other'!M$13","v":0.30689999999999995},null,null,8.1839999999999993,2.9155499999999996]
[{"$f":"'inputs¦other'!A50","v":"Pipeline Integrity Management"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A25,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0.65395346999999993},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A25,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.2802438000000005},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A25,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":3.5084137599999998},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A25,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":5.4087033099999999},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A25,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":6.2546219999999986},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A25,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":6.4416319435280895},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A25,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":8.529463958420223},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A25,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":5.4025103613517729},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A25,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":6.8150461906641437},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A25,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":6.3912206127065012},null,"Pipeline Integrity Management","$m real 2016/17",{"$f":"C25/'AER DRAFT inputs¦other'!D$13","v":0.70827684609958486},{"$f":"D25/'AER DRAFT inputs¦other'!E$13","v":2.4094261212269554},{"$f":"E25/'AER DRAFT inputs¦other'!F$13","v":3.6016471541934054},{"$f":"F25/'AER DRAFT inputs¦other'!G$13","v":5.479557323361},{"$f":"G25/'AER DRAFT inputs¦other'!H$13","v":6.2546219999999986},{"$f":"H25/'AER DRAFT inputs¦other'!I$13","v":6.3153254348314602},{"$f":"I25/'AER DRAFT inputs¦other'!J$13","v":8.1982544775280886},{"$f":"J25/'AER DRAFT inputs¦other'!K$13","v":5.0909061761235996},{"$f":"K25/'AER DRAFT inputs¦other'!L$13","v":6.2960492514044892},{"$f":"L25/'AER DRAFT inputs¦other'!M$13","v":5.7887254213483104},null,null,18.453529444880942,{"$f":"SUM(U25:Y25)","v":31.68926076123595}]
[{"$f":"'inputs¦other'!A51","v":"Toowoomba Crossing"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A26,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A26,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A26,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A26,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A26,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0.30689999999999995},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A26,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":12.156309},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A26,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":3.7251521999999992},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A26,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A26,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A26,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"Toowoomba Crossing","$m real 2016/17",{"$f":"C26/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D26/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E26/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F26/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G26/'AER DRAFT inputs¦other'!H$13","v":0.30689999999999995},{"$f":"H26/'AER DRAFT inputs¦other'!I$13","v":11.917949999999999},{"$f":"I26/'AER DRAFT inputs¦other'!J$13","v":3.5804999999999993},{"$f":"J26/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K26/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L26/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0.30689999999999995,15.498449999999998]
[{"$f":"'inputs¦other'!A52","v":"Dalby Turbine Overhaul"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A27,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A27,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A27,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A27,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A27,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A27,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A27,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A27,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A27,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A27,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"Dalby Turbine Overhaul","$m real 2016/17",{"$f":"C27/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D27/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E27/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F27/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G27/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H27/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I27/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J27/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K27/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L27/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0,0]
[{"$f":"'inputs¦other'!A53","v":"Applications and Renewals"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A28,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A28,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A28,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A28,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A28,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A28,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0.43424341375615444},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A28,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0.55333939001588583},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A28,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0.45178684767190308},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A28,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0.57569430137252764},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A28,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0.47003903631784799},null,"Applications and Renewals","$m real 2016/17",{"$f":"C28/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D28/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E28/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F28/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G28/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H28/'AER DRAFT inputs¦other'!I$13","v":0.42572883701583769},{"$f":"I28/'AER DRAFT inputs¦other'!J$13","v":0.53185254711253926},{"$f":"J28/'AER DRAFT inputs¦other'!K$13","v":0.42572883701583769},{"$f":"K28/'AER DRAFT inputs¦other'!L$13","v":0.53185254711253926},{"$f":"L28/'AER DRAFT inputs¦other'!M$13","v":0.42572883701583769},null,null,0,2.3408916052725917]
[{"$f":"'inputs¦other'!A54","v":"Infrastructure Renewals"},"$m nominal",{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A29,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A29,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A29,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$G$17:$G$98,$A29,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A29,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A29,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0.14160111318135471},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A29,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":4.8144378481660595E-2},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A29,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":4.9107266051293806E-2},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A29,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":5.0089411372319682E-2},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$J$17:$J$95,$A29,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"Infrastructure Renewals","$m real 2016/17",{"$f":"C29/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D29/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E29/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F29/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G29/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H29/'AER DRAFT inputs¦other'!I$13","v":0.13882462076603402},{"$f":"I29/'AER DRAFT inputs¦other'!J$13","v":4.6274873588678003E-2},{"$f":"J29/'AER DRAFT inputs¦other'!K$13","v":4.6274873588678003E-2},{"$f":"K29/'AER DRAFT inputs¦other'!L$13","v":4.6274873588678003E-2},{"$f":"L29/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0,0.27764924153206799]
["Total","$m nominal",{"$f":"SUM(C15:C29)","v":5.7800582265339573},8.7264124698427121,17.307884880921158,9.8724315799229796,{"$f":"SUM(G15:G29)","v":18.219858813742068},{"$f":"SUM(H15:H29)","v":24.012406507973228},14.41896367412806,6.89735878419296,8.4989614283434953,8.5362382000514785,null,"Total",null,{"$f":"SUM(P15:P29)","v":6.2602029024502786},9.2207886496345957,17.767828594560278,10.001760433619971,18.219858813742068,23.541575007816892,13.859057741376452,{"$f":"SUM(W15:W29)","v":6.4995352317292747},7.8517266415509104,7.7315339378336887,null,null,{"$f":"SUM(AB15:AB29)","v":61.470439394007187},{"$f":"SUM(AC15:AC29)","v":59.483428560307217}]
[]
["Total Inputs",null,{"$f":"'AER DRAFT Input¦Historic'!B101/1000000","v":5.7800582265339582},{"$f":"'AER DRAFT Input¦Historic'!C101/1000000","v":8.7264124698427104},{"$f":"'AER DRAFT Input¦Historic'!D101/1000000","v":17.307884880921154},{"$f":"'AER DRAFT Input¦Historic'!E101/1000000","v":9.8724315799229778},{"$f":"'AER DRAFT Input¦Forecast'!B99/1000*'AER DRAFT inputs¦other'!H$13","v":18.219858813742075},{"$f":"'AER DRAFT Input¦Forecast'!C99/1000*'AER DRAFT inputs¦other'!I$13","v":24.012406507973228},{"$f":"'AER DRAFT Input¦Forecast'!D99/1000*'AER DRAFT inputs¦other'!J$13","v":14.418963674128062},{"$f":"'AER DRAFT Input¦Forecast'!E99/1000*'AER DRAFT inputs¦other'!K$13","v":6.89735878419296},{"$f":"'AER DRAFT Input¦Forecast'!F99/1000*'AER DRAFT inputs¦other'!L$13","v":8.4989614283434989},{"$f":"'AER DRAFT Input¦Forecast'!G99/1000*'AER DRAFT inputs¦other'!M$13","v":8.5362382000514785},null,"Total Inputs",null,{"$f":"'AER DRAFT Input¦Historic'!B101/'AER DRAFT inputs¦other'!D13/1000000","v":6.2602029024502794},{"$f":"'AER DRAFT Input¦Historic'!C101/'AER DRAFT inputs¦other'!E13/1000000","v":9.2207886496345921},{"$f":"'AER DRAFT Input¦Historic'!D101/'AER DRAFT inputs¦other'!F13/1000000","v":17.767828594560282},{"$f":"'AER DRAFT Input¦Historic'!E101/'AER DRAFT inputs¦other'!G13/1000000","v":10.001760433619971},{"$f":"'AER DRAFT Input¦Forecast'!B99/1000","v":18.219858813742075},{"$f":"'AER DRAFT Input¦Forecast'!C99/1000","v":23.541575007816888},{"$f":"'AER DRAFT Input¦Forecast'!D99/1000","v":13.859057741376454},{"$f":"'AER DRAFT Input¦Forecast'!E99/1000","v":6.4995352317292747},{"$f":"'AER DRAFT Input¦Forecast'!F99/1000","v":7.8517266415509113},{"$f":"'AER DRAFT Input¦Forecast'!G99/1000","v":7.7315339378336887}]
["Difference",null,{"$f":"C30-C32","v":0},{"$f":"D30-D32","v":0},0,0,0,0,0,0,0,0,null,"Difference",null,{"$f":"P30-P32","v":0},{"$f":"Q30-Q32","v":0},0,0,0,0,0,0,0,0,null,null,"Gross Capex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Draft Decision ($2016/17)"]
["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,null,null,"Current","Forecast"]
["Original Pipeline",{"$f":"B30","v":"$m nominal"},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$I$17:$I$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0.48264717999999995},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$I$17:$I$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.55322732},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$I$17:$I$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":3.6942158099999998},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$I$17:$I$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":5.66083698},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$K$17:$K$95)/1000*'AER DRAFT inputs¦other'!H13","v":14.0810835},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$K$17:$K$95)/1000*'AER DRAFT inputs¦other'!I13","v":13.705678733528091},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$K$17:$K$95)/1000*'AER DRAFT inputs¦other'!J13","v":9.9247995396202242},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$K$17:$K$95)/1000*'AER DRAFT inputs¦other'!K13","v":4.814649414315773},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$K$17:$K$95)/1000*'AER DRAFT inputs¦other'!L13","v":4.5018377904326243},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$K$17:$K$95)/1000*'AER DRAFT inputs¦other'!M13","v":6.2313999480796864},null,"Original Pipeline",{"$f":"O29","v":"$m real 2016/17"},{"$f":"C36/'AER DRAFT inputs¦other'!D$13","v":0.52274028369213887},{"$f":"D36/'AER DRAFT inputs¦other'!E$13","v":2.6978749369862522},{"$f":"E36/'AER DRAFT inputs¦other'!F$13","v":3.7923867506045768},{"$f":"F36/'AER DRAFT inputs¦other'!G$13","v":5.734993944438},{"$f":"G36/'AER DRAFT inputs¦other'!H$13","v":14.0810835},{"$f":"H36/'AER DRAFT inputs¦other'!I$13","v":13.436939934831461},{"$f":"I36/'AER DRAFT inputs¦other'!J$13","v":9.5394074775280888},{"$f":"J36/'AER DRAFT inputs¦other'!K$13","v":4.5369516761236},{"$f":"K36/'AER DRAFT inputs¦other'!L$13","v":4.1590022514044893},{"$f":"L36/'AER DRAFT inputs¦other'!M$13","v":5.64397092134831},null,null,{"$f":"SUM(P36:T36)","v":26.829079415720969},{"$f":"SUM(U36:Y36)","v":37.316272261235952}]
["Pipelines",{"$f":"B36","v":"$m nominal"},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$J$17:$J$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":2.7799445600000006},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$J$17:$J$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.4436575400000002},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$J$17:$J$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":7.5637747900000001},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$J$17:$J$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0.61401757999999995},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$L$17:$L$95)/1000*'AER DRAFT inputs¦other'!H13","v":0.8928044650190825},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$L$17:$L$95)/1000*'AER DRAFT inputs¦other'!I13","v":7.1670050099999996},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$L$17:$L$95)/1000*'AER DRAFT inputs¦other'!J13","v":2.649115378799999},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$L$17:$L$95)/1000*'AER DRAFT inputs¦other'!K13","v":0.91354568223599986},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$L$17:$L$95)/1000*'AER DRAFT inputs¦other'!L13","v":2.6454068301355194},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$L$17:$L$95)/1000*'AER DRAFT inputs¦other'!M13","v":0.4986630631288943},null,"Pipelines",{"$f":"O36","v":"$m real 2016/17"},{"$f":"C37/'AER DRAFT inputs¦other'!D$13","v":3.0108722647935466},{"$f":"D37/'AER DRAFT inputs¦other'!E$13","v":2.5820977161342147},{"$f":"E37/'AER DRAFT inputs¦other'!F$13","v":7.7647762809376637},{"$f":"F37/'AER DRAFT inputs¦other'!G$13","v":0.62206121029799999},{"$f":"G37/'AER DRAFT inputs¦other'!H$13","v":0.8928044650190825},{"$f":"H37/'AER DRAFT inputs¦other'!I$13","v":7.0264754999999992},{"$f":"I37/'AER DRAFT inputs¦other'!J$13","v":2.5462469999999993},{"$f":"J37/'AER DRAFT inputs¦other'!K$13","v":0.86085449999999997},{"$f":"K37/'AER DRAFT inputs¦other'!L$13","v":2.4439469999999996},{"$f":"L37/'AER DRAFT inputs¦other'!M$13","v":0.4516544999999999},null,null,{"$f":"SUM(P37:T37)","v":14.872611937182509},{"$f":"SUM(U37:Y37)","v":13.329178499999998}]
["Compressors",{"$f":"B37","v":"$m nominal"},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$K$17:$K$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0.14324170000000019},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$K$17:$K$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.3529889999999998E-2},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$K$17:$K$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":1E-8},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$K$17:$K$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$M$17:$M$95)/1000*'AER DRAFT inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$M$17:$M$95)/1000*'AER DRAFT inputs¦other'!I13","v":0.10434599999999999},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$M$17:$M$95)/1000*'AER DRAFT inputs¦other'!J13","v":0.10643291999999999},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$M$17:$M$95)/1000*'AER DRAFT inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$M$17:$M$95)/1000*'AER DRAFT inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$M$17:$M$95)/1000*'AER DRAFT inputs¦other'!M13","v":0},null,"Compressors",{"$f":"O37","v":"$m real 2016/17"},{"$f":"C38/'AER DRAFT inputs¦other'!D$13","v":0.15514067003259888},{"$f":"D38/'AER DRAFT inputs¦other'!E$13","v":2.4862925444900631E-2},{"$f":"E38/'AER DRAFT inputs¦other'!F$13","v":1.0265742300000003E-8},{"$f":"F38/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G38/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H38/'AER DRAFT inputs¦other'!I$13","v":0.10229999999999999},{"$f":"I38/'AER DRAFT inputs¦other'!J$13","v":0.10229999999999999},{"$f":"J38/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K38/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L38/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0.18000360574324181,0.20459999999999998]
["Regulators and meters","$m nominal",{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$L$17:$L$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$L$17:$L$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$L$17:$L$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$L$17:$L$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$N$17:$N$95)/1000*'AER DRAFT inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$N$17:$N$95)/1000*'AER DRAFT inputs¦other'!I13","v":0.26668833210798659},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$N$17:$N$95)/1000*'AER DRAFT inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$N$17:$N$95)/1000*'AER DRAFT inputs¦other'!K13","v":8.6849262719999987E-2},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$N$17:$N$95)/1000*'AER DRAFT inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$N$17:$N$95)/1000*'AER DRAFT inputs¦other'!M13","v":0},null,"Regulators and meters","$m real 2016/17",{"$f":"C39/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D39/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E39/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F39/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G39/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H39/'AER DRAFT inputs¦other'!I$13","v":0.26145914912547702},{"$f":"I39/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J39/'AER DRAFT inputs¦other'!K$13","v":8.1839999999999996E-2},{"$f":"K39/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L39/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0,0.34329914912547699]
["Easements","$m nominal",{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$M$17:$M$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":3.221123E-2},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$M$17:$M$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":9.7457199999999994E-3},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$M$17:$M$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":6.1200000000000002E-4},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$M$17:$M$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":7.4928140000000004E-2},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$O$17:$O$95)/1000*'AER DRAFT inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$O$17:$O$95)/1000*'AER DRAFT inputs¦other'!I13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$O$17:$O$95)/1000*'AER DRAFT inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$O$17:$O$95)/1000*'AER DRAFT inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$O$17:$O$95)/1000*'AER DRAFT inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$O$17:$O$95)/1000*'AER DRAFT inputs¦other'!M13","v":0},null,"Easements","$m real 2016/17",{"$f":"C40/'AER DRAFT inputs¦other'!D$13","v":3.488699034411169E-2},{"$f":"D40/'AER DRAFT inputs¦other'!E$13","v":1.0297842861436113E-2},{"$f":"E40/'AER DRAFT inputs¦other'!F$13","v":6.2826342876000016E-4},{"$f":"F40/'AER DRAFT inputs¦other'!G$13","v":7.5909698634000017E-2},{"$f":"G40/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H40/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I40/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J40/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K40/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L40/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0.12172279526830782,0]
["Communications","$m nominal",{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$N$17:$N$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$N$17:$N$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$N$17:$N$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$N$17:$N$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$P$17:$P$95)/1000*'AER DRAFT inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$P$17:$P$95)/1000*'AER DRAFT inputs¦other'!I13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$P$17:$P$95)/1000*'AER DRAFT inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$P$17:$P$95)/1000*'AER DRAFT inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$P$17:$P$95)/1000*'AER DRAFT inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$P$17:$P$95)/1000*'AER DRAFT inputs¦other'!M13","v":0},null,"Communications","$m real 2016/17",{"$f":"C41/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D41/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E41/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F41/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G41/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H41/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I41/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J41/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K41/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L41/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0,0]
["Other","$m nominal",{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$O$17:$O$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$O$17:$O$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$O$17:$O$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$O$17:$O$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$Q$17:$Q$95)/1000*'AER DRAFT inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$Q$17:$Q$95)/1000*'AER DRAFT inputs¦other'!I13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$Q$17:$Q$95)/1000*'AER DRAFT inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$Q$17:$Q$95)/1000*'AER DRAFT inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$Q$17:$Q$95)/1000*'AER DRAFT inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$Q$17:$Q$95)/1000*'AER DRAFT inputs¦other'!M13","v":0},null,"Other","$m real 2016/17",{"$f":"C42/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D42/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E42/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F42/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G42/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H42/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I42/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J42/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K42/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L42/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0,0]
["Capitalised AA costs","$m nominal",{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$P$17:$P$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":7.0875350000000004E-2},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$P$17:$P$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$P$17:$P$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$P$17:$P$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":5.8008080000000004E-2},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$R$17:$R$95)/1000*'AER DRAFT inputs¦other'!H13","v":0.91185669695999994},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$R$17:$R$95)/1000*'AER DRAFT inputs¦other'!I13","v":7.3955592710999996E-2},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$R$17:$R$95)/1000*'AER DRAFT inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$R$17:$R$95)/1000*'AER DRAFT inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$R$17:$R$95)/1000*'AER DRAFT inputs¦other'!L13","v":6.4233976992485398E-2},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$R$17:$R$95)/1000*'AER DRAFT inputs¦other'!M13","v":1.0067634743828957},null,"Capitalised AA costs","$m real 2016/17",{"$f":"C43/'AER DRAFT inputs¦other'!D$13","v":7.6762906945358395E-2},{"$f":"D43/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E43/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F43/'AER DRAFT inputs¦other'!G$13","v":5.8767985848000005E-2},{"$f":"G43/'AER DRAFT inputs¦other'!H$13","v":0.91185669695999994},{"$f":"H43/'AER DRAFT inputs¦other'!I$13","v":7.250548305E-2},{"$f":"I43/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J43/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K43/'AER DRAFT inputs¦other'!L$13","v":5.9342265839999984E-2},{"$f":"L43/'AER DRAFT inputs¦other'!M$13","v":0.91185669695999994},null,null,1.0473875897533582,1.04370444585]
["Group IT","$m nominal",{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$Q$17:$Q$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":1.2922360665339567},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$Q$17:$Q$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":1.1467774598427101},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$Q$17:$Q$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":2.2840297709211552},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$Q$17:$Q$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":1.5719107799229803},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$S$17:$S$95)/1000*'AER DRAFT inputs¦other'!H13","v":1.4103896560595084},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$S$17:$S$95)/1000*'AER DRAFT inputs¦other'!I13","v":1.646556636926487},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$S$17:$S$95)/1000*'AER DRAFT inputs¦other'!J13","v":0.61402876670491224},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$S$17:$S$95)/1000*'AER DRAFT inputs¦other'!K13","v":0.52146813789820234},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$S$17:$S$95)/1000*'AER DRAFT inputs¦other'!L13","v":0.68773641552742271},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$S$17:$S$95)/1000*'AER DRAFT inputs¦other'!M13","v":0.47003903631784799},null,"Group IT","$m real 2016/17",{"$f":"C44/'AER DRAFT inputs¦other'!D$13","v":1.3995810521822054},{"$f":"D44/'AER DRAFT inputs¦other'!E$13","v":1.2117456769224944},{"$f":"E44/'AER DRAFT inputs¦other'!F$13","v":2.3447261033804616},{"$f":"F44/'AER DRAFT inputs¦other'!G$13","v":1.5925028111399715},{"$f":"G44/'AER DRAFT inputs¦other'!H$13","v":1.4103896560595084},{"$f":"H44/'AER DRAFT inputs¦other'!I$13","v":1.6142712126730265},{"$f":"I44/'AER DRAFT inputs¦other'!J$13","v":0.59018528133882375},{"$f":"J44/'AER DRAFT inputs¦other'!K$13","v":0.49139107309613422},{"$f":"K44/'AER DRAFT inputs¦other'!L$13","v":0.63536214179687966},{"$f":"L44/'AER DRAFT inputs¦other'!M$13","v":0.42572883701583769},null,null,7.9589452996846415,3.7569385459207023]
["SIB Capex","$m nominal",{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$R$17:$R$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0.97890213999999998},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$R$17:$R$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.5494745400000003},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$R$17:$R$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":3.7652524999999999},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$R$17:$R$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":1.8927300199999997},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$T$17:$T$95)/1000*'AER DRAFT inputs¦other'!H13","v":0.92372449570348159},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$T$17:$T$95)/1000*'AER DRAFT inputs¦other'!I13","v":1.048176202699665},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$T$17:$T$95)/1000*'AER DRAFT inputs¦other'!J13","v":1.1245870690029267},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$T$17:$T$95)/1000*'AER DRAFT inputs¦other'!K13","v":0.56084628702298511},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$T$17:$T$95)/1000*'AER DRAFT inputs¦other'!L13","v":0.59974641525544503},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$T$17:$T$95)/1000*'AER DRAFT inputs¦other'!M13","v":0.32937267814215387},null,"SIB Capex","$m real 2016/17",{"$f":"C45/'AER DRAFT inputs¦other'!D$13","v":1.0602187344603191},{"$f":"D45/'AER DRAFT inputs¦other'!E$13","v":2.6939095512852949},{"$f":"E45/'AER DRAFT inputs¦other'!F$13","v":3.8653111859430758},{"$f":"F45/'AER DRAFT inputs¦other'!G$13","v":1.9175247832619999},{"$f":"G45/'AER DRAFT inputs¦other'!H$13","v":0.92372449570348159},{"$f":"H45/'AER DRAFT inputs¦other'!I$13","v":1.0276237281369265},{"$f":"I45/'AER DRAFT inputs¦other'!J$13","v":1.0809179825095412},{"$f":"J45/'AER DRAFT inputs¦other'!K$13","v":0.52849798250954116},{"$f":"K45/'AER DRAFT inputs¦other'!L$13","v":0.55407298250954129},{"$f":"L45/'AER DRAFT inputs¦other'!M$13","v":0.29832298250954126},null,null,10.460688750654171,3.4894356581750916]
["PMA","$m nominal",{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$S$17:$S$98,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$S$17:$S$98,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$S$17:$S$98,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Historic'!$S$17:$S$98,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!B$17:B$95,'AER DRAFT Input¦Forecast'!$U$17:$U$95)/1000*'AER DRAFT inputs¦other'!H13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!C$17:C$95,'AER DRAFT Input¦Forecast'!$U$17:$U$95)/1000*'AER DRAFT inputs¦other'!I13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!D$17:D$95,'AER DRAFT Input¦Forecast'!$U$17:$U$95)/1000*'AER DRAFT inputs¦other'!J13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!E$17:E$95,'AER DRAFT Input¦Forecast'!$U$17:$U$95)/1000*'AER DRAFT inputs¦other'!K13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!F$17:F$95,'AER DRAFT Input¦Forecast'!$U$17:$U$95)/1000*'AER DRAFT inputs¦other'!L13","v":0},{"$f":"SUMPRODUCT('AER DRAFT Input¦Forecast'!G$17:G$95,'AER DRAFT Input¦Forecast'!$U$17:$U$95)/1000*'AER DRAFT inputs¦other'!M13","v":0},null,"PMA","$m real 2016/17",{"$f":"C46/'AER DRAFT inputs¦other'!D$13","v":0},{"$f":"D46/'AER DRAFT inputs¦other'!E$13","v":0},{"$f":"E46/'AER DRAFT inputs¦other'!F$13","v":0},{"$f":"F46/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"G46/'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"H46/'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"I46/'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"J46/'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"K46/'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"L46/'AER DRAFT inputs¦other'!M$13","v":0},null,null,0,0]
["Total","$m nominal",{"$f":"SUM(C36:C46)","v":5.7800582265339573},{"$f":"SUM(D36:D46)","v":8.7264124698427104},17.307884880921154,9.8724315799229796,18.219858813742071,24.012406507973225,14.418963674128062,6.8973587841929618,8.4989614283434971,8.5362382000514785,null,"Total","$m real 2016/17",{"$f":"SUM(P36:P46)","v":6.2602029024502794},{"$f":"SUM(Q36:Q46)","v":9.2207886496345939},17.767828594560278,10.001760433619971,18.219858813742071,23.541575007816895,13.859057741376454,6.4995352317292756,7.8517266415509095,7.7315339378336887,null,null,{"$f":"SUM(AB36:AB46)","v":61.470439394007201},{"$f":"SUM(AC36:AC46)","v":59.483428560307217}]
[]
["Check",null,{"$f":"C47=C30","v":true},true,true,true,{"$f":"G47=G30","v":true},{"$f":"H47=H30","v":true},true,true,true,true,null,"Check",null,{"$f":"P47=P32","v":true},{"$f":"Q47=Q32","v":true},true,true,true,true,true,{"$f":"W47=W32","v":false},true,{"$f":"Y47=Y32","v":true},null,null,"Gross Capex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Draft Decision ($2016/17)"]
["Driver",null,{"$f":"C35","v":2013},{"$f":"D35","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,null,"Driver",null,{"$f":"P35","v":2013},{"$f":"Q35","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,null,null,"Current","Forecast"]
["Expansion/Extension",{"$f":"B47","v":"$m nominal"},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A52,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":2.9231862600000009},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A52,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.4030216700000002},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A52,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":1.8579019999999998E-2},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A52,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A52,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A52,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A52,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A52,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A52,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":0},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A52,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":0},null,"Expansion/Extension",{"$f":"O47","v":"$m real 2016/17"},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N52,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000/'AER DRAFT inputs¦other'!D$13","v":3.1660129348261457},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N52,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000/'AER DRAFT inputs¦other'!E$13","v":2.5391597080857844},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N52,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000/'AER DRAFT inputs¦other'!F$13","v":1.9072743150654603E-2},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N52,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000/'AER DRAFT inputs¦other'!G$13","v":0},{"$f":"T19","v":0},0,0,0,0,0,null,null,{"$f":"SUM(P52:T52)","v":5.7242453860625844},{"$f":"SUM(U52:Y52)","v":0}]
["Replacement",{"$f":"B52","v":"$m nominal"},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A53,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":0.65139705000000003},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A53,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":2.1298546599999999},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A53,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":3.8819998099999995},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A53,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":4.4306259800000003},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A53,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":6.2546219999999986},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A53,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":6.4416319435280895},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A53,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":8.529463958420223},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A53,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":5.4025103613517729},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A53,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":6.8150461906641437},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A53,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":6.3912206127065012},null,"Replacement",{"$f":"O52","v":"$m real 2016/17"},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N53,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000/'AER DRAFT inputs¦other'!D$13","v":0.70550806639587627},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N53,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000/'AER DRAFT inputs¦other'!E$13","v":2.2505170070941336},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N53,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000/'AER DRAFT inputs¦other'!F$13","v":3.9851609658108966},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N53,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000/'AER DRAFT inputs¦other'!G$13","v":4.4886671803380009},{"$f":"T25","v":6.2546219999999986},6.3153254348314602,8.1982544775280886,5.0909061761235996,6.2960492514044892,5.7887254213483104,null,null,{"$f":"SUM(P53:T53)","v":17.684475219638905},{"$f":"SUM(U53:Y53)","v":31.68926076123595}]
["Stay in business",{"$f":"B53","v":"$m nominal"},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A54,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000","v":2.2054749165339569},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A54,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000","v":4.1935361398427098},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A54,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000","v":13.407306050921157},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$A54,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000","v":5.4418055999229802},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A54,'AER DRAFT Input¦Forecast'!B$17:B$95)/1000*'AER DRAFT inputs¦other'!H$13","v":11.965236813742068},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A54,'AER DRAFT Input¦Forecast'!C$17:C$95)/1000*'AER DRAFT inputs¦other'!I$13","v":17.570774564445138},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A54,'AER DRAFT Input¦Forecast'!D$17:D$95)/1000*'AER DRAFT inputs¦other'!J$13","v":5.8894997157078386},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A54,'AER DRAFT Input¦Forecast'!E$17:E$95)/1000*'AER DRAFT inputs¦other'!K$13","v":1.4948484228411874},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A54,'AER DRAFT Input¦Forecast'!F$17:F$95)/1000*'AER DRAFT inputs¦other'!L$13","v":1.6839152376793531},{"$f":"SUMIF('AER DRAFT Input¦Forecast'!$I$17:$I$95,$A54,'AER DRAFT Input¦Forecast'!G$17:G$95)/1000*'AER DRAFT inputs¦other'!M$13","v":2.1450175873449777},null,"Stay in business",{"$f":"O53","v":"$m real 2016/17"},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N54,'AER DRAFT Input¦Historic'!B$17:B$98)/1000000/'AER DRAFT inputs¦other'!D$13","v":2.3886819012282574},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N54,'AER DRAFT Input¦Historic'!C$17:C$98)/1000000/'AER DRAFT inputs¦other'!E$13","v":4.4311119344546741},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N54,'AER DRAFT Input¦Historic'!D$17:D$98)/1000000/'AER DRAFT inputs¦other'!F$13","v":13.76359488559873},{"$f":"SUMIF('AER DRAFT Input¦Historic'!$H$17:$H$98,$N54,'AER DRAFT Input¦Historic'!E$17:E$98)/1000000/'AER DRAFT inputs¦other'!G$13","v":5.5130932532819719},{"$f":"T47-SUM(T52:T53)","v":11.965236813742074},17.226249572985434,5.660803263848365,1.408629055605676,1.5556773901464203,1.9428085164853783,null,null,38.061718788305711,{"$f":"SUM(U54:Y54)","v":27.794167799071275}]
["Total",{"$f":"B54","v":"$m nominal"},{"$f":"SUM(C52:C54)","v":5.7800582265339582},{"$f":"SUM(D52:D54)","v":8.7264124698427104},17.307884880921158,9.8724315799229814,{"$f":"SUM(G52:G54)","v":18.219858813742068},{"$f":"SUM(H52:H54)","v":24.012406507973228},14.418963674128062,6.89735878419296,8.4989614283434971,8.5362382000514785,null,"Total",{"$f":"O54","v":"$m real 2016/17"},{"$f":"SUM(P52:P54)","v":6.2602029024502794},{"$f":"SUM(Q52:Q54)","v":9.2207886496345921},17.767828594560282,10.001760433619973,{"$f":"SUM(T52:T54)","v":18.219858813742071},{"$f":"SUM(U52:U54)","v":23.541575007816895},13.859057741376454,6.4995352317292756,7.8517266415509095,7.7315339378336887,null,null,{"$f":"SUM(AB52:AB54)","v":61.470439394007201},{"$f":"SUM(AC52:AC54)","v":59.483428560307225}]
[]
["Check",null,{"$f":"C55=C47","v":true},{"$f":"D55=D47","v":true},true,true,true,true,true,true,true,true,null,"Check",null,{"$f":"P55=P47","v":true},{"$f":"Q55=Q47","v":true},true,true,true,true,true,true,true,true]
[]
["AER Forecast by Driver",null,{"$f":"C51","v":2013},{"$f":"D51","v":2014},2015,2016,2017,null,null,null,null,null,null,{"$f":"A59","v":"AER Forecast by Driver"},null,{"$f":"P51","v":2013},{"$f":"Q51","v":2014},2015,2016,2017]
[{"$f":"A52","v":"Expansion/Extension"},{"$f":"B52","v":"$m nominal"},0,0,0,0,0,null,null,null,null,null,null,{"$f":"N52","v":"Expansion/Extension"},{"$f":"O52","v":"$m real 2016/17"},0,0,0,0,0]
[{"$f":"A53","v":"Replacement"},{"$f":"B53","v":"$m nominal"},0,0,0,0,0,null,null,null,null,null,null,{"$f":"N53","v":"Replacement"},{"$f":"O53","v":"$m real 2016/17"},0,0,0,0,0]
[{"$f":"A54","v":"Stay in business"},"$m nominal",{"$f":"'AER DRAFT inputs¦other'!D35","v":4.0460638603858605},{"$f":"'AER DRAFT inputs¦other'!E35","v":4.6326184980516549},{"$f":"'AER DRAFT inputs¦other'!F35","v":3.5598306206169128},{"$f":"'AER DRAFT inputs¦other'!G35","v":3.8381067109050346},{"$f":"'AER DRAFT inputs¦other'!H35","v":3.2742526411827826},null,null,null,null,null,null,{"$f":"N54","v":"Stay in business"},"$m real 2016/17",{"$f":"'AER DRAFT inputs¦other'!D34","v":4.3936647229155623},{"$f":"'AER DRAFT inputs¦other'!E34","v":4.9079129553717982},{"$f":"'AER DRAFT inputs¦other'!F34","v":3.6640186562506831},{"$f":"'AER DRAFT inputs¦other'!G34","v":3.8985880254412471},{"$f":"'AER DRAFT inputs¦other'!H34","v":3.2828434313160169}]
[{"$f":"A55","v":"Total"},"$m nominal",{"$f":"SUM(C60:C62)","v":4.0460638603858605},{"$f":"SUM(D60:D62)","v":4.6326184980516549},{"$f":"SUM(E60:E62)","v":3.5598306206169128},{"$f":"SUM(F60:F62)","v":3.8381067109050346},{"$f":"SUM(G60:G62)","v":3.2742526411827826},null,null,null,null,null,null,{"$f":"N55","v":"Total"},"$m real 2016/17",{"$f":"SUM(P60:P62)","v":4.3936647229155623},{"$f":"SUM(Q60:Q62)","v":4.9079129553717982},3.6640186562506831,3.8985880254412471,3.2828434313160169]
[]
["Difference",null,{"$f":"C59","v":2013},{"$f":"D59","v":2014},2015,2016,2017,null,null,null,null,null,null,"Difference",null,{"$f":"P59","v":2013},{"$f":"Q59","v":2014},2015,2016,2017]
[{"$f":"A60","v":"Expansion/Extension"},{"$f":"B60","v":"$m nominal"},{"$f":"C52-C60","v":2.9231862600000009},{"$f":"D52-D60","v":2.4030216700000002},1.8579019999999998E-2,0,0,null,null,null,null,null,null,{"$f":"N60","v":"Expansion/Extension"},{"$f":"O60","v":"$m real 2016/17"},{"$f":"P52-P60","v":3.1660129348261457},{"$f":"Q52-Q60","v":2.5391597080857844},1.9072743150654603E-2,0,0]
[{"$f":"A61","v":"Replacement"},"$m nominal",{"$f":"C53-C61","v":0.65139705000000003},2.1298546599999999,3.8819998099999995,4.4306259800000003,6.2546219999999986,null,null,null,null,null,null,{"$f":"N61","v":"Replacement"},"$m real 2016/17",{"$f":"P53-P61","v":0.70550806639587627},2.2505170070941336,3.9851609658108966,4.4886671803380009,6.2546219999999986]
["Stay in business","$m nominal",{"$f":"C54-C62","v":-1.8405889438519036},-0.43908235820894514,9.8474754303042449,1.6036988890179456,8.6909841725592862,null,null,null,null,null,null,"Stay in business","$m real 2016/17",{"$f":"P54-P62","v":-2.0049828216873049},-0.47680102091712406,10.099576229348047,1.6145052278407248,8.6823933824260564]
["Total","$m nominal",{"$f":"SUM(C66:C68)","v":1.7339943661480972},{"$f":"SUM(D66:D68)","v":4.0937939717910554},13.748054260304244,6.0343248690179454,14.945606172559284,null,null,null,null,null,null,"Total","$m real 2016/17",{"$f":"SUM(P66:P68)","v":1.8665381795347171},{"$f":"SUM(Q66:Q68)","v":4.3128756942627939},14.103809938309599,6.1031724081787253,14.937015382426054]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Capex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Draft Decision ($2016/17)"]
["Asset disposals",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Asset disposals",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,null,"Current","Forecast"]
["Motor vehicle disposals",{"$f":"B69","v":"$m nominal"},0.10868117999999999,6.6794679999999995E-2,4.0840309999999998E-2,0,0,null,null,null,null,null,null,"Motor vehicle disposals",{"$f":"O69","v":"$m real 2016/17"},{"$f":"C74/'AER DRAFT inputs¦other'!D13","v":0.11770923610326783},{"$f":"D74/'AER DRAFT inputs¦other'!E13","v":7.0578789316736945E-2},{"$f":"E74/'AER DRAFT inputs¦other'!F13","v":4.1925609791211307E-2},{"$f":"F74/'AER DRAFT inputs¦other'!G13","v":0},{"$f":"G74/'AER DRAFT inputs¦other'!H13","v":0},null,null,null,null,null,null,null,{"$f":"SUM(P74:T74)","v":0.23021363521121607},{"$f":"SUM(U74:Y74)","v":0}]
[]
["Contributions",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Contributions",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,null,"Current","Forecast"]
["Capital contributions","$m nominal",null,{"$f":"95218.24/1000000","v":9.521824000000001E-2},null,null,null,null,null,null,null,null,null,"Capital contributions","$m nominal",{"$f":"C77/'AER DRAFT inputs¦other'!D13","v":0},{"$f":"D77/'AER DRAFT inputs¦other'!E13","v":0.10061262513826692},{"$f":"E77/'AER DRAFT inputs¦other'!F13","v":0},{"$f":"F77/'AER DRAFT inputs¦other'!G13","v":0},{"$f":"G77/'AER DRAFT inputs¦other'!H13","v":0},null,null,null,null,null,null,null,{"$f":"SUM(P77:T77)","v":0.10061262513826692},{"$f":"SUM(U77:Y77)","v":0}]
[]
["Total net capex",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,"Total net capex",null,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,null,null,"Current","Forecast"]
["Total net capex","$m nominal",{"$f":"C55-C74-C77","v":5.6713770465339586},{"$f":"D55-D74-D77","v":8.5643995498427117},{"$f":"E55-E74-E77","v":17.267044570921158},9.8724315799229814,18.219858813742068,24.012406507973228,14.418963674128062,6.89735878419296,8.4989614283434971,8.5362382000514785,null,"Total net capex","$m nominal",{"$f":"P55-P74-P77","v":6.1424936663470113},{"$f":"Q55-Q74-Q77","v":9.0495972351795881},{"$f":"R55-R74-R77","v":17.725902984769071},{"$f":"S55-S74-S77","v":10.001760433619973},{"$f":"T55-T74-T77","v":18.219858813742071},23.541575007816895,13.859057741376454,6.4995352317292756,7.8517266415509095,7.7315339378336887,null,null,{"$f":"SUM(P80:T80)","v":61.139613133657711},{"$f":"SUM(U80:Y80)","v":59.483428560307225}]