{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Notes","Cost data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":39,"defined_names":1827,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"All data within this spreadsheet has been extracted directly from our SAP system, with the exception of the following information (color coding corresponds with the column headers in the next worksheet):"]
[null,"The P50 estimates (column F) have been sourced from the original approved business case (Direct cost + OH). If the business case was not available, then data has been sourced from either Business case Revisions (which shows the original approved business case budget), official (signed) project memos or business case review documents. If the information could not be obtained from these sources, the data was sourced from internal Stage Gate tracking documentations (a P50 estimate is supplied at the time of raising a Stage Gate form for approval to proceed to business case)."]
[null,"For in-flight projects, the EAC Direct + OH (column J) data was not sourced from the SAP system because estimate at completion amounts extracted from the system for these projects reflect total costs (i.e. are not split into direct, OH and CFCs). Given we are unable to account for when outstanding Asset Under Construction balances will be capitalised (which determines CFCs) for in-flight projects, we have estimated the data in this column for these projects by applying the same CFC proportion reflected in the Spend to Date data (i.e. column H as a proportion of column G) to the total EAC costs shown in column I. This is considered a reliable method of estimating Direct + OH EAC amounts for in-flight projects."]
[]
[null,"Other notes"]
[null,"All spend to date information is current as at 30 June 2021"]
[null,"Projects with “Next Stage Gate” of 7 are complete, have achieved Asset In Service (AIS) and the project is closed"]
[null,"Projects with “Next Stage Gate” of 6 are complete and have achieved AIS, but require final handover or close out activities"]
[null,"Projects with \"Next Stage Gate\" of 5 are in-flight and currently in construction/build phase"]
[null,"Fixed date – this reflects the last approved AIS date (i.e. the date from an approved business case or change request)"]
[null,"Actual date – this reflects the date the project achieved AIS.  Stage Gate 5 projects with Actual dates have either been completed (but not progressed in the system to an approved Stage Gate 5) or the date relates to completion of the first stage of a multi-staged project. Actual dates are missing for some completed projects where this data was not entered into our SAP system."]

{"sheet":"Cost data","index":1,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
["Project #","Project","Next Stg Gate","Fixed Date","Actual Date","P50 Estimate Direct + OH","Spend to Date (Direct + OH + CFCs)","Spend to Date Direct + OH","Estimate At Completion (EAC) (Direct + OH + CFCs)","EAC Direct + OH"]
["TD-0001127","TS Metro Serial Server Replacement",7,"30.01.2016","#"]
["TD-0001131","253A - BETS-KGTS tower replacement",7,"30.04.2015","30.04.2015"]
["TD-0001144","Var TS ABB ES245 Earth Switch Replacemen",5,"31.08.2021","#"]
["TD-0003273","X834 - Transformer 220kV SRBP Bushing re",7,"30.12.2015","17.09.2015"]
["TD-0003315","X939 - Insulator Replacement Project Pri",7,"31.03.2017","31.03.2017"]
["TD-0003331","XA24 - SHTS Clean up RTUs",7,"30.09.2016","28.09.2016"]
["TD-0003333","XA29 - DC Supply Upgrade at Various Stat",6,"30.12.2018","28.12.2018"]
["TD-0003334","XA36 - HWTS-SMTS Lines Prot Upgrade",7,"30.07.2017","28.07.2017"]
["TD-0003336","XA44 - YPS - YWPS Protection Upgrade",7,"31.03.2013","#"]
["TD-0003337","XA45 - LYPSB - LYPS Protection Upgrade",6,"24.12.2020","02.11.2020"]
["TD-0003338","XA47 - Replace 1990 vintage line differe",7,"31.03.2016","11.09.2015"]
["TD-0003340","XA49 - SMTS 500 kV CB Fail Upgrade",7,"30.12.2017","30.12.2017"]
["TD-0003351","XA50 - Replace CB fail with CB Managemen",7,"31.12.2017","31.12.2017"]
["TD-0003354","XA54 - HWTS LYPS SMTS Tx Bus Prot Upgrad",6,"24.12.2020","02.11.2020"]
["TD-0003374","XB10 - Var TS Hi-load Tx WTI Replacemt",6,"30.03.2019","10.01.2019"]
["TD-0003391","TSTS Diesel Generator Replacement",7,"30.12.2016","30.12.2016"]
["TD-0003393","XB30 - HYTS Synchronising Re-instatement",7,"29.06.2018","31.05.2018"]
["TD-0003396","XB43 - Sync Con refurb - Gas Control Sta",7,"31.07.2015","#"]
["TD-0003413","XB57 - JGPS Replace RTUs",7,"31.07.2015","16.02.2016"]
["TD-0003419","XC08 - KTS 500kV Protection Upgrade",7,"27.06.2016","23.05.2016"]
["TD-0003420","XC09 - LYPS 500kV CBM Relay Upgrade",5,"31.03.2023","#"]
["TD-0003433","XC12 - HWTS 500kV CBM Relay Upgrade",7,"20.11.2017","20.11.2017"]
["TD-0003453","XC23 - Replace Diesel Genset at Mt Benam",7,"21.06.2018","21.06.2018"]
["TD-0003463","XC35 - Station Bldg Asbestos Remove St 1",7,"31.03.2017","31.03.2017"]
["TD-0003482","Instrument Transformer Replacements",5,"31.12.2020","12.12.2020"]
["TD-0003487","Station Infrastructure Works, Swyd St 1",7,"28.02.2020","23.01.2020"]
["TD-0003523","XC76 - Transmission Line Insulator repla",7,"30.04.2019","31.03.2018"]
["TD-0003524","XC77 - Transmn Line Conductor Replacemen",7,"30.12.2016","30.06.2016"]
["TD-0003530","XC83 - KGTS SVC Protection Upgrade",7,"31.08.2018","13.07.2018"]
["TD-0003542","XC85 - Upgrade SCADA at Non-SCIMS and Ol",6,"29.03.2019","28.03.2019"]
["TD-0003545","XC89 ROTS SVC2 Thyristor and Control and",5,"30.06.2021","#"]
["TD-0003547","XC91 - WOTS Replace Obsolete Line Prot",7,"20.12.2017","20.12.2017"]
["TD-0003549","XC93 - MWTS Replace 66kV Feeder Prot (AP",7,"01.02.2016","18.01.2016"]
["TD-0003587","ROTS Prot Control and RTU Replace",7,"28.06.2018","19.04.2018"]
["TD-0003598","JLA-TBTS OPGW (2nd fibre link)",7,"31.03.2016","#"]
["TD-0003615","HYTS-SESS Communications Link",7,"28.10.2016","21.10.2016"]
["TD-0003619","TS DPS-MBTS PLC Replacement",6,"30.06.2021","#"]
["TD-0003654","Next Generation Network - Phase 1",7,"18.03.2016","#"]
["TD-0003655","21 TS Sites SDH_PDH Replacement",7,"01.05.2018","24.05.2018"]
["TD-0003658","TS OTN Replacement (Ph1 & Ph2) Telephony",7,"31.12.2019","#"]
["TD-0003665","Various TS Radio Site Access Control",7,"31.01.2019","31.01.2019"]
["TD-0003667","Integrate Communications Assets into GIS",7,"31.03.2016","#"]
["TD-0003683","XCCA - ERTS CT and CB Replacements",6,"31.03.2016","31.03.2016"]
["TD-0003688","TS Replace Air Cons at Comm Sites Phase1",7,"20.12.2018","30.03.2019"]
["TD-0003690","RS Battery & Charger Replacements 1",5,"31.12.2020","#"]
["TD-0003707","TS IED Comms SW migration",5,"30.04.2021","#"]
["TD-0003716","TS Serial Server Replacement Program",7,"31.08.2020","11.09.2020"]
["TD-0003733","HOTS Protection Upgrade",7,"31.07.2018","31.05.2018"]
["TD-0004196","2018-20 Transmn Line Cond & G-wire Replc",5,"30.09.2021","#"]
["TD-0004197","Transmission Line Insulator Repl Stg2",5,"31.03.2022","#"]
["TD-0005195","Var TS 22kV FusedSwitch Replacement",6,"15.10.2017","08.12.2017"]
["TD-0005577","MLTS MOPS TRTS HYTS APD – Upgrade Multip",7,"31.03.2017","21.03.2017"]
["TD-0005644","BLTS C2020 RTU Emergency Replacement",7,"15.12.2016","#"]
["TD-0005960","TS NBN Service Migration Stage 2",7,"20.12.2018","#"]
["TD-0005969","TS NBN Service Migration Final Stage",5,"30.09.2021","#"]
["TD-0006035","BLTS C2020 RTU Emergency Replacement",7,"31.03.2016","30.03.2016"]
["TD-0006064","ERTS  RTU and Transformer Prot Replace",7,"31.03.2019","18.03.2019"]
["TD-0006065","006A - Replace weather stations on 5 tra",7,"30.03.2016","27.10.2016"]
["TD-0006166","TSTS Trans Prot Replaceme& Line ARC",6,"31.10.2020","31.07.2020"]
["TD-0006242","KTS HYTS SMTS Fire Deluge Sys Upgrade",6,"30.10.2020","31.08.2020"]
["TD-0006554","WMTS-FBTS 220kVtower footings,ICCP Replc",7,"28.02.2018","28.02.2018"]
["TD-0007024","Hardened (Engineering) Servers Replaceme",6,"31.03.2019","29.03.2019"]
["TD-0007030","TS Seven Sites Radio Terminals Upgrade",7,"29.03.2018","03.05.2018"]
["TD-0007034","TS Radio Dehydrator Replacement (XCCB)",7,"30.11.2017","30.11.2017"]
["TD-0007048","Dartmouth-Benambra Microwave Rev",7,"29.03.2018","#"]
["TD-0007058","TS NBN Service Migration Stage 1",7,"30.04.2017","18.04.2017"]
["TD-0007062","Three Sites Radio Terminals Upgrade",7,"31.03.2018","15.03.2018"]
["TD-0007068","TX4 FBTS-NPSD Cathodic Protection",7,"28.04.2017","28.04.2017"]
["TD-0007103","TS Network Management Systems Refresh",7,"30.04.2019","02.07.2019"]
["TD-0007222","T2&TY42 Cathodic Protection near RWTS",7,"07.05.2019","31.05.2019"]
["TD-0007620","HWPS Assets Necessary Works, PS Closure",5,"31.12.2022","#"]
["TD-0007935","North West Network Comms. Replacement",6,"31.03.2020","24.03.2020"]
["TD-0008168","Various TS Critical Relay Replace Stg 1",7,"31.08.2018","19.04.2018"]
["TD-0008746","MLTS: EMTT Scheme System A&B Relay repla",7,"31.03.2020","13.09.2019"]
["TD-0008807","SYTS: EMTT Scheme System A&B Repl.",7,"31.10.2019","13.09.2019"]
["TD-0008893","Stations Facilities Minor Asset Rpl Wrks",7,"31.03.2019","#"]
["TD-0009598","TS WDM Replacement Ph1",5,"30.09.2021","#"]
["TD-0010808","Western Transmission Tower Rebuild",5,"15.04.2021","18.03.2021"]
["TD-0009876","Stations Facilities Urgent Replacement W",5,"30.06.2021","09.06.2021"]
[null,null,null,null,null,280.79599999999994,null,null,null,284.97815796377222]