{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Index","Notes & Assumptions","Inputs","Calculations","Outputs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":139,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Index and File Details"]
[]
[null,"Index",null,null,null,null,null,"File Details"]
[]
[null,"Inputs",null,"Calculations",null,"Outputs",null,null,"Model","Transgrid | Humelink CPA2 Opex Forecast Model"]
[null,null,null,null,null,null,null,null,"Author","Transgrid"]
[null,"Notes & Assumptions",null,"Calculations",null,"Outputs",null,null,"Revision","2023-11-29"]
[null,null,null,null,null,null,null,null,"Status","Draft CPA"]
[]
[]
[]
[null,null,null,null,null,null,null,"Instructions"]
[]
[null,null,null,null,null,null,null,null,"Input Sheets"]
[null,null,null,null,null,null,null,null,"Fill in any cells marked as input cells as seen on the right =>",null,"user input"]
[null,null,null,null,null,null,null,null,"Historical/"]
[null,null,null,null,null,null,null,null,"Cells not marked as inputs should not be modified."]
[null,null,null,null,null,null,null,null,"Output Sheets"]
[null,null,null,null,null,null,null,null,"Output costs can be toggled between real and nominal. This is controlled in the \"Inputs\" sheet."]

{"sheet":"Notes & Assumptions","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Assumptions & Notes"]
[]
[null,null,null,null,"User inputs in cells coloured like this"]
[null,null,"*",null,"1.     Inputs are in $. Outputs are $million."]
[null,null,"*",null,"2.     Financial years are recorded in the Opex Forecast Model as tax years (eg. 2017/18 is shown as 2018, 2018/19 is shown as 2019)"]
[null,null,"*",null,"3.     Escalation is treated as follows:"]
[null,null,null,null,"a.    CPI escalation and Commodity escalation are treated separately. "]
[null,null,null,null,"c.    Escalation is applied to Project Component percentages (commodities - land, labour etc)"]
[]
["Modifications"]
["Date","Version",null,"Who","Notes"]
["2023-11-29","1","Transgrid",null,"Initial model development to support draft Humelink Stage 2 CPA"]
["2024-01-01",2,"Transgrid",null,"Updated confidentiality "]

{"sheet":"Inputs","index":2,"n_rows":208,"n_cols":26,"rows_kept":208,"cut":false,"hidden":false,"merged":[[28,21,28,23],[5,2,5,5],[28,15,28,19],[12,13,12,19],[18,13,18,19],[28,5,28,6]]}
["Inputs"]
[]
[]
[null,"Output Reporting Fomat and Year"]
[null,"Real","Nominal or Real Reporting (select from drop-down box)"]
[null,2023,"If Real, this is the Financial Year that results are reported in.\nNot used for Nominal calculations."]
[]
[null,{"$f":" IF(Real_or_Nom=\"Real\", \"Real $\" & Report_Year, \"$ Nominal\")","v":"Real $2023"}]
[]
[null,"Indexation and escalation"]
[]
[]
[null,"Forecasts",null,null,null,null,null,null,null,null,null,null,null,"Rates"]
[null,"Item","Source","Units",null,null,null,null,null,null,null,null,null,2022,{"$f":"N14+1","v":2023},2024,2025,2026,2027,2028]
[null,"Actual / Forecast Inflation ","ABS / RBA / PTRM","%",null,null,null,null,null,null,null,null,null,6.1447811447811418E-2,6.0269627279936566E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2]
[null,"Real labour escalation","Transgrid AER FD","%",null,null,null,null,null,null,null,null,null,null,null,3.9046564755527329E-3,1.3076482545953276E-2,1.1546438954636147E-2,4.3304575862308627E-3,3.00941333753012E-3]
[]
[]
[null,"Cumulative factors",null,null,null,null,null,null,null,null,null,null,null,"Cumulative Factors"]
[null,"Item","Source","Units",null,null,null,null,null,null,null,null,null,{"$f":"N$14","v":2022},{"$f":"O$14","v":2023},2024,2025,2026,2027,2028]
[null,"Nominal (mid year) to Real 2023 (end year)","Calculated","Factor",null,null,null,null,null,null,null,null,null,1.0923596349717211,1.0296939483554988,0.98571548225832206,0.95775567439692477,0.93058894615101162,0.90419280182677764,0.87854538382050351,null,"Note: this index converts from nominal mid year dollars for each year over 2021-22 to 2027-28 to dollars as at the end of 2022-23 (i.e., Real 2023, end year)."]
[null,"Nominal (end year) to Real 2023 (end year)","Calculated","Factor",null,null,null,null,null,null,null,null,null,1.0602696272799366,1,0.97163501196375623,0.94407459647380876,0.91729593183950753,0.89127684370718485,0.86599578669844945]
[null,"Labour escalation from 2023","Calculated","Factor",null,null,null,null,null,null,null,null,null,null,1,1.0039046564755527,1.0170321981937565,1.0287752983851002,1.0332303661805189,1.0363397834252435]
[]
[]
[]
[null,"Operating and Maintenance"]
[]
[null,"Maintenance plan requirements",null,null,null,"Conversion",null,null,null,null,null,"Defect",null,null,null,"Quantities ",null,null,null,null,null,"Rates (Real $2023)",null,null,null,"Note: unit rates are assumed to be in mid-year dollars"]
[null,"Item","Plan Component","Maintenance Activity",null,"Dollar Year","Escalation Year",null,"Asset class","Location",null,"Allowance (%)",null,null,null,{"$f":"P$20","v":2024},{"$f":"Q$20","v":2025},{"$f":"R$20","v":2026},{"$f":"S$20","v":2027},{"$f":"T$20","v":2028},null,"Code","Labour","Materials"]
[null,null,null,null,null,2023,2023]
[null,{"$f":"J33","v":"Humelink East line"},null,null,null,"End"]
[null,"Requirement 1","Transmission Lines","Aerial Imagery",null,null,null,null,"Transmission Lines","Humelink East line",null,"c-i-c",null,null,null,0,0,0,1,1,null,"TAERIM","c-i-c","c-i-c"]
[null,"Requirement 2","Transmission Lines","TL Surge Arrestor Inspection and Replacement",null,null,null,null,"Transmission Lines","Humelink East line",null,"c-i-c",null,null,null,0,0,0,1,1,null,"TCCT01","c-i-c","c-i-c"]
[null,"Requirement 3","Transmission Lines","End Of Defects Liability Climbing Inspections (per 10 structures)",null,null,null,null,"Transmission Lines","Humelink East line",null,"c-i-c",null,null,null,0,0,0,0,47,null,"TCCT10","c-i-c","c-i-c"]
[null,"Requirement 4","Transmission Lines","End Of Defects Liability Thermographic Inspections (per circuit)",null,null,null,null,"Transmission Lines","Humelink East line",null,"c-i-c",null,null,null,0,0,0,0,2,null,"TTHERM","c-i-c","c-i-c"]
[null,"Requirement 5","Transmission Lines","Annual Compliance Inspection - Bushfire (per 50 structures)",null,null,null,null,"Transmission Lines","Humelink East line",null,"c-i-c",null,null,null,0,0,0,2,2,null,"TCI019","c-i-c","c-i-c"]
[null,"Requirement 6","Transmission Lines","Compliance Inspection - Public Areas Use  (per 10 structures)",null,null,null,null,"Transmission Lines","Humelink East line",null,"c-i-c",null,null,null,0,0,0,0,1,null,"TCI009","c-i-c","c-i-c"]
[null,"Requirement 7","Easements & Access Tracks","Easement Inspection  (per 100 spans)",null,null,null,null,"Land and Easements","Humelink East line",null,"c-i-c",null,null,null,0,0,0,0,4.5,null,"TEI100","c-i-c","c-i-c"]
[null,"Requirement 8","Easements & Access Tracks","Easement Maintenance",null,null,null,null,"Land and Easements","Humelink East line",null,"c-i-c",null,null,null,0,0,0,1,1,null,"TEM250","c-i-c","c-i-c"]
[null,"Requirement 9","Easements & Access Tracks","Lidar Scan",null,null,null,null,"Land and Easements","Humelink East line",null,"c-i-c",null,null,null,0,0,0,1,1,null,"TLIDR","c-i-c","c-i-c"]
[]
[null,{"$f":"J44","v":"Humelink West line"}]
[null,"Requirement 10","Transmission Lines","Aerial Imagery",null,null,null,null,"Transmission Lines","Humelink West line",null,"c-i-c",null,null,null,0,0,0,1,1,null,"TAERIM","c-i-c","c-i-c"]
[null,"Requirement 11","Transmission Lines","TL Surge Arrestor Inspection and Replacement",null,null,null,null,"Transmission Lines","Humelink West line",null,"c-i-c",null,null,null,0,0,0,1,1,null,"TCCT01","c-i-c","c-i-c"]
[null,"Requirement 12","Transmission Lines","End Of Defects Liability Climbing Inspections (per 10 structures)",null,null,null,null,"Transmission Lines","Humelink West line",null,"c-i-c",null,null,null,0,0,0,0,36,null,"TCCT10","c-i-c","c-i-c"]
[null,"Requirement 13","Transmission Lines","End Of Defects Liability Thermographic Inspections (per circuit)",null,null,null,null,"Transmission Lines","Humelink West line",null,"c-i-c",null,null,null,0,0,0,0,1,null,"TTHERM","c-i-c","c-i-c"]
[null,"Requirement 14","Transmission Lines","Annual Compliance Inspection - Bushfire (per 50 structures)",null,null,null,null,"Transmission Lines","Humelink West line",null,"c-i-c",null,null,null,0,0,0,2,2,null,"TCI019","c-i-c","c-i-c"]
[null,"Requirement 15","Transmission Lines","Compliance Inspection - Public Areas Use  (per 10 structures)",null,null,null,null,"Transmission Lines","Humelink West line",null,"c-i-c",null,null,null,0,0,0,0,2,null,"TCI009","c-i-c","c-i-c"]
[null,"Requirement 16","Easements & Access Tracks","Easement Inspection  (per 100 spans)",null,null,null,null,"Land and Easements","Humelink West line",null,"c-i-c",null,null,null,0,0,0,0,3.5,null,"TEI100","c-i-c","c-i-c"]
[null,"Requirement 17","Easements & Access Tracks","Easement Maintenance",null,null,null,null,"Land and Easements","Humelink West line",null,"c-i-c",null,null,null,0,0,0,1,1,null,"TEM250","c-i-c","c-i-c"]
[null,"Requirement 18","Easements & Access Tracks","Lidar Scan",null,null,null,null,"Land and Easements","Humelink West line",null,"c-i-c",null,null,null,0,0,0,1,1,null,"TLIDR","c-i-c","c-i-c"]
[]
[null,{"$f":"J55","v":"Bannaby substation"}]
[null,"Requirement 19"," Automation Systems - Protection","Auto Reclose Checks",null,null,null,null,"Secondary Systems","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,2,2,null,"PARCL1","c-i-c","c-i-c"]
[null,"Requirement 20"," Automation Systems - Protection","Warranty Maintenance",null,null,null,null,"Secondary Systems","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,4,0,null,"PRXRM1","c-i-c","c-i-c"]
[null,"Requirement 21","Telecommunications","Routine Maintenance",null,null,null,null,"Communications (short life)","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"CFOIN1","c-i-c","c-i-c"]
[null,"Requirement 22","Substations","Minor Maintenance - Reactive Bays >=80MVA",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,0,2,null,"S0041B","c-i-c","c-i-c"]
[null,"Requirement 23","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,0,6,null,"S0041B","c-i-c","c-i-c"]
[null,"Requirement 24","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,0,10,null,"S0900B","c-i-c","c-i-c"]
[null,"Requirement 25","Substations","Warranty Oil sample",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,0,6,null,"S0955C","c-i-c","c-i-c"]
[null,"Requirement 26","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,2,0,null,"S0600N","c-i-c","c-i-c"]
[null,"Requirement 27","Substations","Warranty Oil sample",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,2,2,null,"S0955E","c-i-c","c-i-c"]
[null,"Requirement 28","Substations","Annual Costs for Management of Site - Increment from large site",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,0.3,0.3,null,"Property","c-i-c","c-i-c"]
[null,"Requirement 29","Substations","Annual Sub Inspect XLARGE Site - Increment from large site",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,0.3,0.3,null,"S1SBXI","c-i-c","c-i-c"]
[null,"Requirement 30","Substations","XLARGE SUBSTATION THERMOVISON INSPECTION - Increment from large site",null,null,null,null,"Substations","Bannaby substation",null,"c-i-c",null,null,null,0,0,0,0.3,0.3,null,"S1THRX","c-i-c","c-i-c"]
[]
[null,{"$f":"J69","v":"Wagga substation"}]
[null,"Requirement 31"," Automation Systems - Protection","Auto Reclose Checks",null,null,null,null,"Secondary Systems","Wagga substation",null,"c-i-c",null,null,null,0,0,0,2,2,null,"PARCL1","c-i-c","c-i-c"]
[null,"Requirement 32","Telecommunications","Routine Maintenance",null,null,null,null,"Communications (short life)","Wagga substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"CFOIN1","c-i-c","c-i-c"]
[null,"Requirement 33","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Wagga substation",null,"c-i-c",null,null,null,0,0,0,0,5,null,"S0160B","c-i-c","c-i-c"]
[null,"Requirement 34","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Wagga substation",null,"c-i-c",null,null,null,0,0,0,0,7,null,"S0900B","c-i-c","c-i-c"]
[null,"Requirement 35","Substations","Warranty Oil sample",null,null,null,null,"Substations","Wagga substation",null,"c-i-c",null,null,null,0,0,0,0,5,null,"S0955C","c-i-c","c-i-c"]
[null,"Requirement 36","Substations","Annual Costs for Management of Site - Increment from large site",null,null,null,null,"Substations","Wagga substation",null,"c-i-c",null,null,null,0,0,0,0.3,0.3,null,"Property","c-i-c","c-i-c"]
[null,"Requirement 37","Substations","Annual Sub Inspect XLARGE Site - Increment from large site",null,null,null,null,"Substations","Wagga substation",null,"c-i-c",null,null,null,0,0,0,0.3,0.3,null,"S1SBXI","c-i-c","c-i-c"]
[null,"Requirement 38","Substations","XLARGE SUBSTATION THERMOVISON INSPECTION - Increment from large site",null,null,null,null,"Substations","Wagga substation",null,"c-i-c",null,null,null,0,0,0,0.3,0.3,null,"S1THRX","c-i-c","c-i-c"]
[]
[null,{"$f":"J79","v":"Gugaa substation"}]
[null,"Requirement 39"," Automation Systems - Protection Systems","Filter Checks",null,null,null,null,"Secondary Systems","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,2,2,null,"P3454C","c-i-c","c-i-c"]
[null,"Requirement 40"," Automation Systems - Protection Performance Checks","Auto Reclose Checks",null,null,null,null,"Secondary Systems","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,4,4,null,"PARCL1","c-i-c","c-i-c"]
[null,"Requirement 41"," Automation Systems - Protection Systems","Routine Maintenance",null,null,null,null,"Secondary Systems","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,2,0,null,"PRXRM1","c-i-c","c-i-c"]
[null,"Requirement 42"," Automation Systems - Protection Systems","Routine Maintenance",null,null,null,null,"Secondary Systems","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,4,0,null,"PTXRM1","c-i-c","c-i-c"]
[null,"Requirement 43","Telecommunications","Maintenance",null,null,null,null,"Communications (short life)","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"C12VB1","c-i-c","c-i-c"]
[null,"Requirement 44","Telecommunications","OTN Data Backup",null,null,null,null,"Communications (short life)","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"CTG307","c-i-c","c-i-c"]
[null,"Requirement 45","Telecommunications","Inspection (with BAS)",null,null,null,null,"Communications (short life)","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"CTG101","c-i-c","c-i-c"]
[null,"Requirement 46","Telecommunications","Routine Maintenance",null,null,null,null,"Communications (short life)","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,2,2,null,"CFOIN1","c-i-c","c-i-c"]
[null,"Requirement 47","Telecommunications","Equipment Maintenance",null,null,null,null,"Communications (short life)","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"CVHFR1","c-i-c","c-i-c"]
[null,"Requirement 48","Substations Assets","Warranty (Minor Mntce)",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,0,6,null,"S0160B","c-i-c","c-i-c"]
[null,"Requirement 49","Substations Assets","Minor Maintenance - Reactive Bays >=80MVA",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"S0041B","c-i-c","c-i-c"]
[null,"Requirement 50","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,0,6,null,"S0041B","c-i-c","c-i-c"]
[null,"Requirement 51","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,0,22,null,"S0900B","c-i-c","c-i-c"]
[null,"Requirement 52","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,2,0,null,"S0601A","c-i-c","c-i-c"]
[null,"Requirement 53","Substations","Warranty Oil sample",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,0,12,null,"S0955C","c-i-c","c-i-c"]
[null,"Requirement 54","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,2,0,null,"S0600N","c-i-c","c-i-c"]
[null,"Requirement 55","Substations","Oil Sample",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,2,2,null,"S0955E","c-i-c","c-i-c"]
[null,"Requirement 56","OHS & Compliance","6 MTH SAFETY INSPECTION CHECKLIST",null,null,null,null,null,"Gugaa substation",null,"c-i-c",null,null,null,0,0,0,2,2,null,"G26001","c-i-c","c-i-c"]
[null,"Requirement 57","OHS & Compliance","Defibrillator- Check Expiry Date of Pads",null,null,null,null,null,"Gugaa substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"S2093B","c-i-c","c-i-c"]
[null,"Requirement 58","Substations","Annual Sub Inspect XLARGE Site",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"S1SBXI","c-i-c","c-i-c"]
[null,"Requirement 59","Substations","XLARGE SUBSTATION THERMOVISON INSPECTION",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"S1THRX","c-i-c","c-i-c"]
[null,"Requirement 60"," Automation Systems - Protection Systems","Warranty (Minor Mntce)",null,null,null,null,"Secondary Systems","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,0,null,"P1BHZ1","c-i-c","c-i-c"]
[null,"Requirement 61","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,7,0,null,"S0600A","c-i-c","c-i-c"]
[null,"Requirement 62","Substations","Oil Sample",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,7,7,null,"S0955A","c-i-c","c-i-c"]
[null,"Requirement 63","Substations","Routine Maintenance",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,7,7,null,"S0650B","c-i-c","c-i-c"]
[null,"Requirement 64","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,7,0,null,"S0658A","c-i-c","c-i-c"]
[null,"Requirement 65","Substations","Annual Costs for Management of Site",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,1,null,"Property","c-i-c","c-i-c"]
[null,"Requirement 66","Substations","Warranty Oil sample",null,null,null,null,"Substations","Gugaa substation",null,"c-i-c",null,null,null,0,0,0,1,0,null,"S0955F","c-i-c","c-i-c"]
[]
[null,{"$f":"J109","v":"Maragle substation"}]
[null,"Requirement 67"," Automation Systems - Protection Systems","Filter Checks",null,null,null,null,"Secondary Systems","Maragle substation",null,"c-i-c",null,null,null,0,0,0,1,2,null,"P3454C","c-i-c","c-i-c"]
[null,"Requirement 68"," Automation Systems - Protection Performance Checks","Auto Reclose Checks",null,null,null,null,"Secondary Systems","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,2,null,"PARCL1","c-i-c","c-i-c"]
[null,"Requirement 69"," Automation Systems - Protection Systems","Routine Maintenance",null,null,null,null,"Secondary Systems","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,4,null,"PRXRM1","c-i-c","c-i-c"]
[null,"Requirement 70"," Automation Systems - Protection Systems","Routine Maintenance",null,null,null,null,"Secondary Systems","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,6,null,"PTXRM1","c-i-c","c-i-c"]
[null,"Requirement 71","Telecommunications","Maintenance",null,null,null,null,"Communications (short life)","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"C12VB1","c-i-c","c-i-c"]
[null,"Requirement 72","Telecommunications","OTN Data Backup",null,null,null,null,"Communications (short life)","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"CTG307","c-i-c","c-i-c"]
[null,"Requirement 73","Telecommunications","Inspection (with BAS)",null,null,null,null,"Communications (short life)","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"CTG101","c-i-c","c-i-c"]
[null,"Requirement 74","Telecommunications","Routine Maintenance",null,null,null,null,"Communications (short life)","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"CFOIN1","c-i-c","c-i-c"]
[null,"Requirement 75","Telecommunications","Equipment Maintenance",null,null,null,null,"Communications (short life)","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"CVHFR1","c-i-c","c-i-c"]
[null,"Requirement 76","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"S0160B","c-i-c","c-i-c"]
[null,"Requirement 77","Substations","Minor Maintenance - Reactive Bays >=80MVA",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,2,null,"S0041B","c-i-c","c-i-c"]
[null,"Requirement 78","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,8,null,"S0041B","c-i-c","c-i-c"]
[null,"Requirement 79","Substations","Warranty (Minor Mntce)",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,20,null,"S0900B","c-i-c","c-i-c"]
[null,"Requirement 80","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,3,null,"S0601A","c-i-c","c-i-c"]
[null,"Requirement 81","Substations","Warranty Oil sample",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,9,null,"S0955C","c-i-c","c-i-c"]
[null,"Requirement 82","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,2,null,"S0600N","c-i-c","c-i-c"]
[null,"Requirement 83","Substations","Oil Sample",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,2,null,"S0955E","c-i-c","c-i-c"]
[null,"Requirement 84","OHS & Compliance","6 MTH SAFETY INSPECTION CHECKLIST",null,null,null,null,null,"Maragle substation",null,"c-i-c",null,null,null,0,0,0,1,2,null,"G26001","c-i-c","c-i-c"]
[null,"Requirement 85","OHS & Compliance","Defibrillator- Check Expiry Date of Pads",null,null,null,null,null,"Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"S2093B","c-i-c","c-i-c"]
[null,"Requirement 86","Substations","Annual Sub Inspect XLARGE Site",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"S1SBXI","c-i-c","c-i-c"]
[null,"Requirement 87","Substations","XLARGE SUBSTATION THERMOVISON INSPECTION",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,1,null,"S1THRX","c-i-c","c-i-c"]
[null,"Requirement 88"," Automation Systems - Protection Systems","Warranty (Minor Mntce)",null,null,null,null,"Secondary Systems","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,9,null,"P1BHZ1","c-i-c","c-i-c"]
[null,"Requirement 89","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,9,null,"S0600A","c-i-c","c-i-c"]
[null,"Requirement 90","Substations","Oil Sample",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,9,null,"S0955A","c-i-c","c-i-c"]
[null,"Requirement 91","Substations","Routine Maintenance",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,9,null,"S0650B","c-i-c","c-i-c"]
[null,"Requirement 92","Substations","Warranty (Major Mntce)",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,9,null,"S0658A","c-i-c","c-i-c"]
[null,"Requirement 93","Substations","Annual Costs for Management of Site",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0.5,1,null,"Property","c-i-c","c-i-c"]
[null,"Requirement 94","Substations","Warranty Oil sample",null,null,null,null,"Substations","Maragle substation",null,"c-i-c",null,null,null,0,0,0,0,9,null,"S0955F","c-i-c","c-i-c"]
[]
[null,{"$f":"C139","v":"Asset Management"}]
[null,"Requirement 95","Asset Management","Develop and maintain asset renewal and maintenance strategies - incremental",null,null,null,null,null,null,null,"c-i-c",null,null,null,0,0,0,1,0.5,null,"Asset Manager - Senior ","c-i-c",0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total cost",{"$f":"SUMPRODUCT(P$33:P$139,(1+$L$33:$L$139),--$W$33:$W$139+$X$33:$X$139)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(Q$33:Q$139,(1+$L$33:$L$139),--$W$33:$W$139+$X$33:$X$139)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(R$33:R$139,(1+$L$33:$L$139),--$W$33:$W$139+$X$33:$X$139)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(S$33:S$139,(1+$L$33:$L$139),--$W$33:$W$139+$X$33:$X$139)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(T$33:T$139,(1+$L$33:$L$139),--$W$33:$W$139+$X$33:$X$139)","v":{"$error":"#VALUE!"}},null,"Note: this is the total cost excluding labour escalation and inflation"]
[]
[]
[null,"Property costs"]
[]
[]
[null,{"$f":"B144","v":"Property costs"},null,null,null,"Conversion",null,null,"Location",null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F149&\", \"&F150&\" year)\"","v":"Cost (As Incurred) (Real $2023, End year)"}]
[null,"Item","Description","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,null,{"$f":"P$20","v":2024},{"$f":"Q$20","v":2025},{"$f":"R$20","v":2026},{"$f":"S$20","v":2027},{"$f":"T$20","v":2028}]
[null,"Component 1","Land Tax","$Dollars",null,2023,null,null,"Gugaa",null,null,null,null,null,null,0,50000,50000,50000,50000]
[null,"Component 2","LGA Charges","$Dollars",null,"End",null,null,"Gugaa",null,null,null,null,null,null,0,15000,15000,15000,15000]
[null,"Component 3","Electricity Cost","$Dollars",null,null,null,null,"Gugaa",null,null,null,null,null,null,0,0,0,6000,6000]
[null,"Component 4","Other landholder costs (sewage, water etc)","$Dollars",null,null,null,null,"Gugaa",null,null,null,null,null,null,0,0,0,4000,4000]
[null,"Component 5","Land Tax","$Dollars",null,null,null,null,"Maragle",null,null,null,null,null,null,0,6040,6040,6040,6040]
[null,"Component 6","LGA Charges","$Dollars",null,null,null,null,"Maragle",null,null,null,null,null,null,0,5000,5000,5000,5000]
[null,"Component 7","Electricity Cost","$Dollars",null,null,null,null,"Maragle",null,null,null,null,null,null,0,0,0,4000,4000]
[null,"Component 8","Other landholder costs (sewage, water etc)","$Dollars",null,null,null,null,"Maragle",null,null,null,null,null,null,0,0,0,4000,4000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total cost",{"$f":"SUM(P149:P156)","v":0},{"$f":"SUM(Q149:Q156)","v":76040},{"$f":"SUM(R149:R156)","v":76040},{"$f":"SUM(S149:S156)","v":94040},{"$f":"SUM(T149:T156)","v":94040}]
[]
[]
[null,"Easement establishment costs"]
[]
[]
[null,{"$f":"B161","v":"Easement establishment costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F166&\", \"&F167&\" year)\"","v":"Cost (As Incurred) (Real $2023, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,null,{"$f":"P$20","v":2024},{"$f":"Q$20","v":2025},{"$f":"R$20","v":2026},{"$f":"S$20","v":2027},{"$f":"T$20","v":2028}]
[null,"Establishment Costs","TransGrid / Calculated","$Dollars",null,2023,null,null,null,null,null,null,null,null,null,0,60000,60000,60000,60000]
[null,null,null,null,null,"End"]
[]
[]
[null,"Strategic benefit payments"]
[]
[]
[null,{"$f":"B170","v":"Strategic benefit payments"},null,null,null,"Conversion",null,null,"Length and rates",null,null,"Period",null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F175&\", \"&F176&\" year)\"","v":"Cost (As Incurred) (Real $2022, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year",null,null,"Distance of line on private land (kms)","Rate/km",null,"Years",null,null,null,{"$f":"P$20","v":2024},{"$f":"Q$20","v":2025},{"$f":"R$20","v":2026},{"$f":"S$20","v":2027},{"$f":"T$20","v":2028}]
[null,"East","TransGrid / Calculated","$Dollars",null,2022,null,null,204.06824,200000,null,20,null,null,null,0,0,0,2040682.4,2040682.4]
[null,"West","TransGrid / Calculated","$Dollars",null,"End",null,null,89.733629999999991,200000,null,20,null,null,null,0,0,0,897336.3,897336.3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total payments",{"$f":"SUM(P175:P176)","v":0},{"$f":"SUM(Q175:Q176)","v":0},{"$f":"SUM(R175:R176)","v":0},{"$f":"SUM(S175:S176)","v":2938018.7},{"$f":"SUM(T175:T176)","v":2938018.7}]
[]
[]
[null,"Insurance costs"]
[]
[]
[null,{"$f":"B181","v":"Insurance costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F186&\", \"&F187&\" year)\"","v":"Cost (As Incurred) (Real $2023, Mid year)"}]
[null,"Item","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,null,{"$f":"P$20","v":2024},{"$f":"Q$20","v":2025},{"$f":"R$20","v":2026},{"$f":"S$20","v":2027},{"$f":"T$20","v":2028}]
[null,"Annual insurance premium","AON","$Dollars",null,2023,null,null,null,null,null,null,null,null,null,0,0,0,3491031.5,3491031.5,null,"Note: premium calculated as average of high and low estimates provided by AON"]
[null,null,null,null,null,"Mid"]
[]
[]
[null,"Vegetaion integrity rehabilitation costs"]
[]
[]
[null,{"$f":"B190","v":"Vegetaion integrity rehabilitation costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F195&\", \"&F196&\" year)\"","v":"Cost (As Incurred) (Real $2023, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,null,{"$f":"P$20","v":2024},{"$f":"Q$20","v":2025},{"$f":"R$20","v":2026},{"$f":"S$20","v":2027},{"$f":"T$20","v":2028}]
[null,"Vegetaion integrity rehabilitation costs","Transgrid","$Dollars",null,2023,null,null,null,null,null,null,null,null,null,0,0,0,357000,357000]
[null,null,null,null,null,"End"]
[]
[]
[null,"Debt raising costs"]
[]
[]
[null,{"$f":"B199","v":"Debt raising costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F204&\", \"&F205&\" year)\"","v":"Cost (As Incurred) (Real $2023, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,null,{"$f":"P$20","v":2024},{"$f":"Q$20","v":2025},{"$f":"R$20","v":2026},{"$f":"S$20","v":2027},{"$f":"T$20","v":2028}]
[null,"Debt raising cost allowance","PTRM","$Dollars",null,2023,null,null,null,null,null,null,null,null,null,0,38243.599563564603,1094884.0054990922,2075390.9642748924,2104318.9350654189]
[null,null,null,null,null,"End"]
[]
[]
[null,"End"]

{"sheet":"Calculations","index":3,"n_rows":99,"n_cols":12,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["Calculations",null,null,null,{"$f":"Inputs!$B$8","v":"Real $2023"}]
[]
[null,{"$f":"Inputs!$B$27","v":"Operating and Maintenance"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Activity","Dollar basis","Units",{"$f":"Inputs!N$20","v":2022},{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!P$20","v":2024},{"$f":"Inputs!Q$20","v":2025},{"$f":"Inputs!R$20","v":2026},{"$f":"Inputs!S$20","v":2027},{"$f":"Inputs!T$20","v":2028}]
[]
[null,{"$f":"Inputs!B32","v":"Humelink East line"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B6))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B6))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B6))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},14355.655821929025,104187.69145749421,118543.34727942324]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G7*(Inputs!P$23-1)","v":{"$error":"#VALUE!"}},{"$f":"H7*(Inputs!Q$23-1)","v":{"$error":"#VALUE!"}},{"$f":"I7*(Inputs!R$23-1)","v":{"$error":"#VALUE!"}},477.04369972419937,3786.1581431414284,4263.2018428656274]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B6))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B6))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B6))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},322902.27,966425.53,1289327.8]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(G7:G9)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},337734.96952165326,1074399.3796006357,1412134.3491222889]
[]
[null,{"$f":"Inputs!B43","v":"Humelink West line"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B12))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B12))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B12))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},14355.655821929025,84538.606910929579,98894.26273285861]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G13*(Inputs!P$23-1)","v":{"$error":"#VALUE!"}},{"$f":"H13*(Inputs!Q$23-1)","v":{"$error":"#VALUE!"}},{"$f":"I13*(Inputs!R$23-1)","v":{"$error":"#VALUE!"}},477.04369972419937,3072.1146662149713,3549.1583659391708]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B12))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B12))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B12))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},280981.02,772526.1399999999,1053507.1599999999]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(G13:G15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},295813.71952165326,860136.86157714447,1155950.5810987977]
[]
[null,{"$f":"Inputs!B54","v":"Bannaby substation"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B18))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B18))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B18))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},92492.826205627702,520249.11934954778,612741.94555517542]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G19*(Inputs!P$23-1)","v":{"$error":"#VALUE!"}},{"$f":"H19*(Inputs!Q$23-1)","v":{"$error":"#VALUE!"}},{"$f":"I19*(Inputs!R$23-1)","v":{"$error":"#VALUE!"}},3073.570483884102,18905.740324336206,21979.310808220307]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B18))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B18))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B18))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},73066.967999999993,90881.881199999989,163948.8492]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(G19:G21)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},168633.3646895118,630036.74087388394,798670.10556339566]
[]
[null,{"$f":"Inputs!B68","v":"Wagga substation"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B24))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B24))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B24))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},13402.33338623204,174946.08657085471,188348.41995708673]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G25*(Inputs!P$23-1)","v":{"$error":"#VALUE!"}},{"$f":"H25*(Inputs!Q$23-1)","v":{"$error":"#VALUE!"}},{"$f":"I25*(Inputs!R$23-1)","v":{"$error":"#VALUE!"}},445.36444609788435,6357.5028970787544,6802.8673431766383]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B24))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B24))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B24))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},68377.95,73686.042000000001,142063.992]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(G25:G27)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},82225.647832329923,254989.63146793348,337215.27930026338]
[]
[null,{"$f":"Inputs!B78","v":"Gugaa substation"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B30))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B30))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B30))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},805891.96219900204,640565.18431572302,1446457.1465147249]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G31*(Inputs!P$23-1)","v":{"$error":"#VALUE!"}},{"$f":"H31*(Inputs!Q$23-1)","v":{"$error":"#VALUE!"}},{"$f":"I31*(Inputs!R$23-1)","v":{"$error":"#VALUE!"}},26780.085005809724,23278.000067784538,50058.085073594266]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B30))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B30))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B30))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},525437.34840000002,257265,782702.34840000002]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(G31:G33)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1358109.3956048116,921108.18438350759,2279217.5799883194]
[]
[null,{"$f":"Inputs!B108","v":"Maragle substation"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B36))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B36))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B36))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},2090.5337660563227,1667006.5984179259,1669097.1321839823]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G37*(Inputs!P$23-1)","v":{"$error":"#VALUE!"}},{"$f":"H37*(Inputs!Q$23-1)","v":{"$error":"#VALUE!"}},{"$f":"I37*(Inputs!R$23-1)","v":{"$error":"#VALUE!"}},69.469202558790812,60578.658754959237,60648.127957518031]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B36))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B36))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B36))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},113935.5,631584.54539999994,745520.04539999994]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(G37:G39)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},116095.50296861511,2359169.8025728851,2475265.3055415004]
[]
[null,{"$f":"Inputs!B138","v":"Asset Management"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B42))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B42))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$W$33:$W$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B42))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},0,0,0]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G43*(Inputs!P$23-1)","v":{"$error":"#VALUE!"}},{"$f":"H43*(Inputs!Q$23-1)","v":{"$error":"#VALUE!"}},{"$f":"I43*(Inputs!R$23-1)","v":{"$error":"#VALUE!"}},0,0,0]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(Inputs!P$33:P$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B42))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!Q$33:Q$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B42))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(Inputs!R$33:R$139*Inputs!$X$33:$X$139*(1+Inputs!$L$33:$L$139)*(Inputs!$J$33:$J$139=$B42))*INDEX(IF(Inputs!$F$32=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$31,Inputs!$N$20:$T$20,0))","v":{"$error":"#VALUE!"}},0,0,0]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(G43:G45)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0]
[]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G7+G13+G19+G25+G31+G37+G43","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},942588.9672007761,3191493.2870224752,4134082.2542232512]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},31322.576537798897,115978.17485351514,147300.75139131403]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1384701.0564000001,2792369.1386000002,4177070.1950000003]
[null,"Total operating and maintenance costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"SUM(G48:G50)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},2358612.6001385748,6099840.6004759911,8458453.200614566]
[]
[]
[null,{"$f":"Inputs!$B$144","v":"Property costs"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!P$20","v":2024},{"$f":"Inputs!Q$20","v":2025},{"$f":"Inputs!R$20","v":2026},{"$f":"Inputs!S$20","v":2027},{"$f":"Inputs!T$20","v":2028}]
[]
[null,"Property costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"Inputs!P$158*INDEX(IF(Inputs!$F$150=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$149,Inputs!$N$20:$T$20,0))","v":0},76040,76040,94040,94040,340160]
[]
[null,"Total property costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G57","v":0},76040,76040,94040,94040,340160]
[]
[]
[null,{"$f":"Inputs!$B$161","v":"Easement establishment costs"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!P$20","v":2024},{"$f":"Inputs!Q$20","v":2025},{"$f":"Inputs!R$20","v":2026},{"$f":"Inputs!S$20","v":2027},{"$f":"Inputs!T$20","v":2028}]
[]
[null,"Easement establishment costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"Inputs!P$166*INDEX(IF(Inputs!$F$167=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$166,Inputs!$N$20:$T$20,0))","v":0},{"$f":"Inputs!Q$166*INDEX(IF(Inputs!$F$167=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$166,Inputs!$N$20:$T$20,0))","v":60000},{"$f":"Inputs!R$166*INDEX(IF(Inputs!$F$167=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$166,Inputs!$N$20:$T$20,0))","v":60000},{"$f":"Inputs!S$166*INDEX(IF(Inputs!$F$167=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$166,Inputs!$N$20:$T$20,0))","v":60000},{"$f":"Inputs!T$166*INDEX(IF(Inputs!$F$167=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$166,Inputs!$N$20:$T$20,0))","v":60000},{"$f":"SUM(E65:K65)","v":240000}]
[]
[null,"Total easement establishment costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G65","v":0},{"$f":"H65","v":60000},{"$f":"I65","v":60000},{"$f":"J65","v":60000},{"$f":"K65","v":60000},{"$f":"SUM(E67:K67)","v":240000}]
[]
[]
[null,{"$f":"Inputs!$B$170","v":"Strategic benefit payments"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!P$20","v":2024},{"$f":"Inputs!Q$20","v":2025},{"$f":"Inputs!R$20","v":2026},{"$f":"Inputs!S$20","v":2027},{"$f":"Inputs!T$20","v":2028}]
[]
[null,"Strategic benefit payments",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"Inputs!P$178*INDEX(IF(Inputs!$F$176=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$175,Inputs!$N$20:$T$20,0))","v":0},0,0,3115091.9919904838,3115091.9919904838,6230183.9839809677]
[]
[null,"Total strategic benefit payments",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G73","v":0},0,0,3115091.9919904838,3115091.9919904838,6230183.9839809677]
[]
[]
[null,{"$f":"Inputs!$B$181","v":"Insurance costs"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!P$20","v":2024},{"$f":"Inputs!Q$20","v":2025},{"$f":"Inputs!R$20","v":2026},{"$f":"Inputs!S$20","v":2027},{"$f":"Inputs!T$20","v":2028}]
[]
[null,"Insurance premium",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"Inputs!P$186*INDEX(IF(Inputs!$F$187=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$186,Inputs!$N$20:$T$20,0))","v":0},0,0,3594694.0090684192,3594694.0090684192,7189388.0181368385]
[]
[null,"Total insurance costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G81","v":0},0,0,3594694.0090684192,3594694.0090684192,7189388.0181368385]
[]
[]
[null,{"$f":"Inputs!$B$190","v":"Vegetaion integrity rehabilitation costs"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!P$20","v":2024},{"$f":"Inputs!Q$20","v":2025},{"$f":"Inputs!R$20","v":2026},{"$f":"Inputs!S$20","v":2027},{"$f":"Inputs!T$20","v":2028}]
[]
[null,"Vegetaion integrity rehabilitation costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"Inputs!P$195*INDEX(IF(Inputs!$F$196=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$195,Inputs!$N$20:$T$20,0))","v":0},{"$f":"Inputs!Q$195*INDEX(IF(Inputs!$F$196=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$195,Inputs!$N$20:$T$20,0))","v":0},{"$f":"Inputs!R$195*INDEX(IF(Inputs!$F$196=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$195,Inputs!$N$20:$T$20,0))","v":0},357000,357000,714000]
[]
[null,"Total insurance costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G89","v":0},{"$f":"H89","v":0},{"$f":"I89","v":0},357000,357000,714000]
[]
[]
[]
[null,"Total costs (excluding debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G51+G59+G67+G75+G83+G91","v":{"$error":"#VALUE!"}},{"$f":"H51+H59+H67+H75+H83+H91","v":{"$error":"#VALUE!"}},{"$f":"I51+I59+I67+I75+I83+I91","v":{"$error":"#VALUE!"}},{"$f":"J51+J59+J67+J75+J83+J91","v":9579438.6011974774},{"$f":"K51+K59+K67+K75+K83+K91","v":13320666.601534896},{"$f":"SUM(E95:K95)","v":{"$error":"#VALUE!"}}]
[]
[null,"Debt raising costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"Inputs!P$204*INDEX(IF(Inputs!$F$205=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$204,Inputs!$N$20:$T$20,0))","v":0},{"$f":"Inputs!Q$204*INDEX(IF(Inputs!$F$205=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$204,Inputs!$N$20:$T$20,0))","v":38243.599563564603},{"$f":"Inputs!R$204*INDEX(IF(Inputs!$F$205=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$204,Inputs!$N$20:$T$20,0))","v":1094884.0054990922},{"$f":"Inputs!S$204*INDEX(IF(Inputs!$F$205=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$204,Inputs!$N$20:$T$20,0))","v":2075390.9642748924},{"$f":"Inputs!T$204*INDEX(IF(Inputs!$F$205=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$204,Inputs!$N$20:$T$20,0))","v":2104318.9350654189},{"$f":"SUM(E97:K97)","v":5312837.5044029681}]
[]
[null,"Total costs (including debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2023"},"Dollars",null,null,{"$f":"G95+G97","v":{"$error":"#VALUE!"}},{"$f":"H95+H97","v":{"$error":"#VALUE!"}},{"$f":"I95+I97","v":{"$error":"#VALUE!"}},{"$f":"J95+J97","v":11654829.56547237},{"$f":"K95+K97","v":15424985.536600314},{"$f":"SUM(E99:K99)","v":{"$error":"#VALUE!"}}]

{"sheet":"Outputs","index":4,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Outputs",null,null,null,{"$f":"Inputs!B8","v":"Real $2023"}]
[]
[null,"PTRM and Proposal"]
[]
[null,"Operating Costs",null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis","Units",{"$f":"Inputs!N$20","v":2022},{"$f":"Inputs!O$20","v":2023},{"$f":"Inputs!P$20","v":2024},{"$f":"Inputs!Q$20","v":2025},{"$f":"Inputs!R$20","v":2026},{"$f":"Inputs!S$20","v":2027},{"$f":"Inputs!T$20","v":2028}]
[]
[null,"Costs"]
[null,"Operating and maintenance costs (excl labour escalation)",{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",null,null,{"$f":"(Calculations!G51-Calculations!G49)/10^6","v":{"$error":"#VALUE!"}},0,0,2.3272900236007756,5.9838624256224762,8.3111524492232522]
[null,{"$f":"Calculations!B54","v":"Property costs"},{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",null,null,{"$f":"Calculations!G59/10^6","v":0},7.6039999999999996E-2,7.6039999999999996E-2,9.4039999999999999E-2,9.4039999999999999E-2,0.34016000000000002]
[null,{"$f":"Calculations!B62","v":"Easement establishment costs"},{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",null,null,{"$f":"Calculations!G67/10^6","v":0},0.06,0.06,0.06,0.06,0.24]
[null,{"$f":"Calculations!B70","v":"Strategic benefit payments"},{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",null,null,{"$f":"Calculations!G75/10^6","v":0},0,0,3.115091991990484,3.115091991990484,6.2301839839809681]
[null,"Insurance Costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",null,null,{"$f":"Calculations!G83/10^6","v":0},0,0,3.5946940090684194,3.5946940090684194,7.1893880181368388]
[null,"Vegetaion integrity rehabilitation costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",null,null,{"$f":"Calculations!G91/10^6","v":0},0,0,0.35699999999999998,0.35699999999999998,0.71399999999999997]
[null,"Real input cost escalation",{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",null,null,{"$f":"Calculations!G49/10^6","v":{"$error":"#VALUE!"}},0,0,3.13225765377989E-2,0.11597817485351514,0.14730075139131404]
[]
[null,"Total (excluding debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",{"$f":"SUM(E9:E15)","v":0},0,{"$error":"#VALUE!"},0.13603999999999999,0.13603999999999999,9.5794386011974773,13.320666601534894,23.172185202732372]
[]
[null,"Debt Raising Costs",{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",null,null,{"$f":"Calculations!G97/10^6","v":0},3.8243599563564601E-2,1.0948840054990923,2.0753909642748924,2.104318935065419,5.3128375044029683]
[]
[null,"Total (including debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2023"},"$Million",{"$f":"E17+E19","v":0},0,{"$error":"#VALUE!"},0.1742835995635646,1.2309240054990922,11.654829565472369,15.424985536600314,28.485022707135339]