{"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":141,"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,"Inputs / Calculations",null,"Outputs",null,null,"Model","Transgrid | PEC Reopener Capex Forecast Model"]
[null,null,null,null,null,null,null,null,"Author","Transgrid"]
[null,"Notes & Assumptions",null,"Calculations",null,"Outputs",null,null,"Revision","2026-01-22"]
[null,"Inputs",null,null,null,null,null,null,"Status","Final Reopener Application"]
[]
[]
[]
[null,"Model Checks",null,null,null,null,null,"Instructions"]
[]
[null,"Worksheet",null,null,null,null,null,null,"Input Sheets"]
[null,"Inputs",null,null,null,null,null,null,"Fill in any cells marked as input cells as seen on the right =>",null,"user input"]
[null,"Calculations",null,null,null,null,null,null,"Historical / Not applicable"]
[null,"Outputs",null,0,null,null,null,null,"Cells not marked as inputs should not be modified."]
[]
[null,"Total Error Check",null,0]

{"sheet":"Notes & Assumptions","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"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 Capex Forecast Model as tax years (e.g. 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 Labour escalation are treated separately. "]
[null,null,null,null,"b.    Escalation is applied to Expenditure Components (i.e. Labour)"]
[]
["Modifications"]
["Date","Version",null,"Who","Notes"]
["2026-01-22","1","Transgrid",null,"Model developed to support PEC Reopener Application"]

{"sheet":"Inputs","index":2,"n_rows":187,"n_cols":38,"rows_kept":187,"cut":false,"hidden":false,"merged":[[129,7,129,8],[122,7,122,8],[119,7,119,8],[130,7,130,8],[123,7,123,8],[5,1,5,2],[18,0,18,2],[12,0,12,2],[23,0,23,2],[33,0,33,2],[42,0,42,2],[70,0,70,2],[80,0,80,2],[58,0,58,2],[89,0,89,2],[101,0,101,2],[115,0,115,2],[51,0,51,2],[143,7,143,8],[144,7,144,8],[139,0,139,2],[119,4,119,5],[119,0,119,2],[124,7,124,8],[125,7,125,8],[126,7,126,8],[131,7,131,8],[120,7,120,8],[121,7,121,8],[127,7,127,8],[128,7,128,8],[145,7,145,8],[139,7,139,8],[140,7,140,8],[141,7,141,8],[142,7,142,8],[151,7,151,8],[146,7,146,8],[147,7,147,8],[148,7,148,8],[149,7,149,8],[150,7,150,8],[51,11,51,22],[58,26,58,31],[58,11,58,22],[70,11,70,22],[12,11,12,21],[18,11,18,21],[23,11,23,21],[33,11,33,22],[42,11,42,22],[139,17,139,22],[80,11,80,22],[89,11,89,22],[101,11,101,22],[101,26,101,31],[119,17,119,22]]}
["Inputs"]
[]
[]
["Output Reporting Format and Year"]
["Real"]
[2023]
[]
["Real $2023"]
[]
["Inflation and Labour Escalation"]
[]
[]
["Forecasts",null,null,null,null,null,null,null,null,null,null,"Rates"]
["Item","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
["Actual / Forecast Inflation ","ABS December to December / AER Forecast","%",null,null,null,null,null,null,null,null,1.9090909090909047E-2,1.7841213202497874E-2,1.8404907975460238E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,4.0519877675840865E-2,2.4246877296105973E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,"◄ Actual December year on year inflation used for 2019 to 2025 (with a lag). Forecast inflation for 2025 to 2029 as per the AER's final decision for the 2023-28 period."]
["Real labour escalation","AER","%",null,null,null,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,"◄ Labour escalation as per AER's final decision for the 2023-28 period."]
[]
[]
["Cumulative Factors",null,null,null,null,null,null,null,null,null,null,"Cumulative factors"]
["Item","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Nominal"]
["Real (end-year) inflation indexed from 2018","Calculated","Factor",null,null,null,null,null,null,null,null,1,1.0178412132024979,1.0365744870651206,1.0454950936663694,1.0820695807314897,1.1668153434433544,1.2140945584299734,1.243532560214095,1.2798350665655933,1.3171973537459696,1.3556503599883691]
["Labour based to 2023","Calculated","Factor",null,null,null,null,null,null,null,null,1,1,1,1,1,1,1.0039046564755527,1.0170321981937565,1.0287752983851002,1.0332303661805189,1.0363397834252435]
[]
["Indexation",null,null,null,null,null,null,null,null,null,null,"Indexation"]
["Item","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
["Real 2023 End Period to Nominal Mid Period","Calculated","Factor",null,null,null,null,null,null,null,null,0.84896816444082535,0.86464509974850978,0.88031508154771643,0.8921936458145866,0.91156252410486349,0.96300053508865702,1.0200587618739623,1.053059003156297,1.0811935641229082,1.1127569002867905,1.145241666454377]
["Nominal Mid Period to Real 2023 End Period","Calculated","Factor",null,null,null,null,null,null,null,null,1.177900470106146,1.1565438817508589,1.1359569101575095,1.1208329096392349,1.0970174547072131,1.0384210221730943,0.98033568003757732,0.94961440622295135,0.92490376671010388,0.89866888243269516,0.87317815033394708]
[]
[]
["Incremental contract costs"]
[]
["New contract costs"]
[]
["New contract costs (Gross)",null,null,null,"Dollar Basis",null,null,null,"Asset Class",null,null,"As Incurred Expenditure ($Nominal)"]
["Asset Class","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total"]
["Transmission Lines","Transgrid","$Millions",null,"Nominal",null,null,null,"Transmission Lines",null,null,0,0,0,8.6254811379839573,137.20217625366146,262.10341817866504,390.17361622804236,883.45238523431556,567.84693552316537,123.08953187978473,0,2372.4935444356188]
["Substations","Transgrid","$Millions",null,null,null,null,null,"Substations",null,null,0,0,0,3.7356177798500672,43.419336045823499,84.95692418448958,166.2582730536796,202.17356847961923,105.81477714182114,26.781414021331852,0,633.13991070661507]
["Secondary Systems","Transgrid","$Millions",null,null,null,null,null,"Secondary Systems",null,null,0,0,0,0.87540836159460511,10.323838081285473,20.352424139284825,38.408333814557551,47.687104704915185,28.383945616078009,6.6264382070964167,0,152.65749292481206]
["Communications (short life)","Transgrid","$Millions",null,null,null,null,null,"Communications (short life)",null,null,0,0,0,0.47846960031084829,6.1019580789484937,10.919547221882212,18.290921704634659,35.965990212241465,23.747944448788303,4.2426865381120562,0,99.747517804918033]
["Synchronous Condensers","Transgrid","$Millions",null,null,null,null,null,"Synchronous Condensers",null,null,0,0,0,1.2850231202605213,14.824864828428534,31.05045975254928,54.804501556001625,66.905945027245338,38.487500421686448,9.1752286202747353,0,216.5335233264465]
[null,null,null,null,null,null,null,null,null,null,"Sub-Total",0,0,0,15,211.87217328814745,409.38277347687097,667.93564635691575,1236.1849936583367,764.28110315153924,169.91529926659979,0,3474.5719891984104]
[]
["Dinawan upgrade costs – part of the VNI West scope",null,null,null,"Dollar Basis",null,null,null,"Asset Class",null,null,"As Incurred Expenditure ($Nominal)"]
["Asset Class","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total"]
["Transmission Lines","AER","$Millions",null,"Nominal",null,null,null,"Transmission Lines",null,null,0,0,0,0,0,-3.084336,-31.041698030000003,-131.70070701184588,-113.04257446092393,-14.327179493888538,0,-293.19649499665837]
["Substations","AER","$Millions",null,null,null,null,null,"Substations",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Secondary Systems","AER","$Millions",null,null,null,null,null,"Secondary Systems",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Communications (short life)","AER","$Millions",null,null,null,null,null,"Communications (short life)",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Synchronous Condensers","AER","$Millions",null,null,null,null,null,"Synchronous Condensers",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Sub-Total",0,0,0,0,0,-3.084336,-31.041698030000003,-131.70070701184588,-113.04257446092393,-14.327179493888538,0,-293.19649499665837]
[]
["Offsets",null,null,null,"Dollar Basis",null,null,null,null,null,null,"As Incurred Expenditure ($Nominal)"]
["Item","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total"]
["C-I-C ","Transgrid","$Millions",null,"Nominal",null,null,null,null,null,null,"C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C"]
["Elecnor SP1 Liquidated Damages Payment","Transgrid","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.9,null,null,null,-5.9]
["Share of Project Trust Account interest","Transgrid","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4,null,-4]
[null,null,null,null,null,null,null,null,null,null,"Sub-Total",0,0,0,0,0,0,0,-121.9,0,-4,0,-125.9]
[]
["New contract costs (net)",null,null,null,"Dollar Basis",null,null,null,"Asset Class",null,null,"As Incurred Expenditure ($2023)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Commissioning Profile Assumption"]
["Asset Class","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total",null,null,null,2024,2025,2026,2027,2028,"Total"]
["Transmission Lines","Calculated","$Millions",null,2023,null,null,null,"Transmission Lines",null,null,0,0,0,9.6677231209248973,150.51318217408215,268.97086007830603,352.06983324987743,635.0851733929411,420.65026666264924,95.228518921422108,0,1932.1855576002031,null,null,null,0,0.29518629456786788,0.70354387901270021,1.2698264194319628E-3,0,1]
["Substations","Calculated","$Millions",null,null,null,null,null,"Substations",null,null,0,0,0,4.1870033454894093,47.631769514066448,88.221056052339748,162.9889171759522,170.79767097686656,97.868485952060567,23.448871194179485,0,595.14377421095446,null,null,null,0,0.29169758111579103,0.40977979576825546,0.29852262311595346,0,1]
["Secondary Systems","Calculated","$Millions",null,null,null,null,null,"Secondary Systems",null,null,0,0,0,0.98118650104859673,11.325430574741189,21.134385078416507,37.653060049204555,40.286405787265693,26.252418214405289,5.8018779692001585,0,143.43476417428198,null,null,null,0,0.30075622485602521,0.36653035053474781,0.33271342460922698,0,1]
["Communications (short life)","Calculated","$Millions",null,null,null,null,null,"Communications (short life)",null,null,0,0,0,0.53628447429032988,6.6939545204981927,11.339087387814299,17.931243167827102,30.384324760270907,21.964563272306602,3.7147482231605249,0,92.564205806167962,null,null,null,0,0.15705903099844956,0.83997871150623205,2.962257495318477E-3,0,1]
["Synchronous Condensers","Calculated","$Millions",null,null,null,null,null,"Synchronous Condensers",null,null,0,0,0,1.4402962028352886,16.263135480461155,32.24345015518675,53.726808302023315,56.522619010465476,35.59723411127451,8.0335098782536924,0,203.82705314050017,null,null,null,0,0.29888085963610955,0.27681855874680689,0.42430058161708351,0,1]
[null,null,null,null,null,null,null,null,null,null,"Sub-Total",0,0,0,16.812493644588521,232.4274722638491,421.90883875206333,624.36986194488463,933.07619392780987,602.33296821269619,136.22752618621595,0,2967.1553549321075]
[]
[]
["Previous contract costs"]
[]
["Contingent project allowance (tendered works only)",null,null,null,"Dollar Basis",null,null,null,"Asset Class",null,null,"As Incurred Expenditure ($2018)"]
["Asset Class","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total"]
["Transmission Lines","AER","$Millions",null,2018,null,null,null,"Transmission Lines",null,null,null,0,0,56.342731512443294,464.27084888106879,439.23019751489397,null,null,null,null,null,959.84377790840608]
["Substations","AER","$Millions",null,null,null,null,null,"Substations",null,null,null,0,0,32.035347670600082,113.80876155256848,143.66828981864296,null,null,null,null,null,289.51239904181153]
["Secondary Systems","AER","$Millions",null,null,null,null,null,"Secondary Systems",null,null,null,0,0,2.7207513931303882,7.779629874536476,5.9427605576550109,null,null,null,null,null,16.443141825321874]
["Communications (short life)","AER","$Millions",null,null,null,null,null,"Communications (short life)",null,null,null,0,0,0.34852503493262527,1.6217802874699496,0.65285401207347538,null,null,null,null,null,2.6231593344760502,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
["Synchronous Condensers","AER","$Millions",null,null,null,null,null,"Synchronous Condensers",null,null,null,0,0,39.110405645212602,45.842041272155058,47.165093351230894,null,null,null,null,null,132.11754026859856]
[null,null,null,null,null,null,null,null,null,null,"Sub-Total",0,0,0,130.557761256319,633.32306186779874,636.65919525449624,0,0,0,0,0,1400.5400183786139]
[]
[]
["Net contract cost increases prior to the event",null,null,null,"Dollar Basis",null,null,null,null,null,null,"As Incurred Expenditure ($Nominal)"]
["Item","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total"]
["C-I-C ","Transgrid","$Millions",null,"Nominal",null,null,null,null,null,null,"C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C"]
["C-I-C ","Transgrid","$Millions",null,null,null,null,null,null,null,null,"C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C","C-I-C"]
["Variations under EPC contract","Transgrid","$Millions",null,null,null,null,null,null,null,null,0,0,0,0,0,0.71630134000000012,0.11109783000000001,-19.555402300000001,0.3654616,0.44488137000000255,0,-17.917660160000001]
["Contract cost savings prior to event","Transgrid","$Millions",null,null,null,null,null,null,null,null,0,0,0,-12.65648,0,-21.8579025337236,0,0,0,0,0,-34.514382533723598]
[null,null,null,null,null,null,null,null,null,null,"Sub-Total",0,0,0,-12.65648,0,-16.970227193723598,47.939723409999999,205.4445977,0.3654616,0.44488137000000255,0,224.56795688627639]
[]
[]
["Allowance plus net cost increases prior to the event",null,null,null,"Dollar Basis",null,null,null,"Asset Class",null,null,"As Incurred Expenditure ($2023)"]
["Asset Class","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total"]
["Transmission Lines","Calculated","$Millions",null,2023,null,null,null,"Transmission Lines",null,null,0,0,0,56.019491406577266,541.718349987902,500.42333651368898,32.208860818705134,133.70481625168185,0.23165588134587534,0.27399898543300044,0,1264.5805098453341]
["Substations","Calculated","$Millions",null,null,null,null,null,"Substations",null,null,0,0,0,34.446920029741932,132.79380919782301,163.99158635151696,9.7149815216252442,40.328648273180619,6.9873089250769266E-2,8.2644806825324948E-2,0,381.42846326996391]
["Secondary Systems","Calculated","$Millions",null,null,null,null,null,"Secondary Systems",null,null,0,0,0,3.0080650639683406,9.0773915039194577,6.7272090043733392,0.551771943167777,2.2905052957115712,3.9685109174127037E-3,4.6938931950851904E-3,0,21.663605215252986]
["Communications (short life)","Calculated","$Millions",null,null,null,null,null,"Communications (short life)",null,null,0,0,0,0.38009488414964498,1.8923181231139112,0.72875427734003739,8.8023672032896946E-2,0.36540220907539495,6.3309290691333385E-4,7.4881247638209822E-4,0,3.4559750710951809]
["Synchronous Condensers","Calculated","$Millions",null,null,null,null,null,"Synchronous Condensers",null,null,0,0,0,44.29642835085933,53.489197131114025,53.370590751309365,4.4333833944246637,18.403777626949228,3.1886236006930663E-2,3.7714545663236052E-2,0,174.06297803632677]
[null,null,null,null,null,null,null,null,null,null,"Sub-Total",0,0,0,138.15099973529652,738.97106594387242,725.2414768982286,46.997021349955723,195.09314965659865,0.33801681042790133,0.3998010435930287,0,1845.191531437973]
[]
[]
["Incremental contract costs"]
[]
["Incremental cost",null,null,null,"Dollar Basis",null,null,null,"Asset Class",null,null,"As Incurred Expenditure ($2023)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As Commissioned Expenditure ($2023)",null,null,null,null,null,"◄ Incremental cost calculated as the cumulative difference between the new contractor costs and previous contractor costs"]
["Asset Class","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Total",null,null,null,2024,2025,2026,2027,2028,"Total"]
["Transmission Lines","Calculated","$Millions",null,2023,null,null,null,"Transmission Lines",null,null,0,0,0,0,0,0,0,228.57650432523116,358.2066193787598,80.821924050878351,0,667.60504775486902,null,null,null,0,197.06786028156426,389.71526342242663,80.821924050878351,0,667.60504775486925]
["Substations","Calculated","$Millions",null,null,null,null,null,"Substations",null,null,0,0,0,0,0,0,0,73.172452574996541,114.6699523904167,25.872905975577403,0,213.71531094099055,null,null,null,0,62.34023924889609,125.50216571651714,25.872905975577396,0,213.71531094099063]
["Secondary Systems","Calculated","$Millions",null,null,null,null,null,"Secondary Systems",null,null,0,0,0,0,0,0,0,41.692353789252643,65.336886434932183,14.741918734844221,0,121.77115895902899,null,null,null,0,36.623434064860511,70.405806159324328,14.741918734844219,0,121.77115895902905]
["Communications (short life)","Calculated","$Millions",null,null,null,null,null,"Communications (short life)",null,null,0,0,0,0,0,0,0,30.509128048875674,47.811439110258171,10.787663575938968,0,89.10823073507278,null,null,null,0,13.995252373236791,64.325314785897049,10.787663575938964,0,89.108230735072809]
["Synchronous Condensers","Calculated","$Millions",null,null,null,null,null,"Synchronous Condensers",null,null,0,0,0,0,0,0,0,10.190708210887665,15.970054087901708,3.603312805384038,0,29.764075104173401,null,null,null,0,8.8959123534090736,17.135160726178071,3.7330020245862663,0,29.764075104173411]
[null,null,null,null,null,null,null,null,null,null,"Sub-Total",0,0,0,0,0,0,0,384.14114694924365,601.9949514022685,135.82772514262297,0,1121.9638234941347,null,null,null,0,318.92269832196672,667.08371081034329,135.95741436182519,0,1121.9638234941351]
[]
[]
["Incremental other project costs"]
[]
["Labour Costs"]
[]
["Labour Escalation",null,null,null,"Input"]
["Apply labour escalators?","Transgrid","Option",null,"No"]
[]
[]
["Labour Costs",null,null,null,"Conversion",null,null,"Mapping",null,null,null,null,null,null,null,null,null,"As incurred expenditure (June 2023 dollars, unescalated)"]
["Component","Source","Units",null,"Dollar Year","Escalation Year",null,"Category",null,null,null,null,null,null,null,null,null,2024,2025,2026,2027,2028,"Total"]
["Forecast (from 1 August 2023)",null,null,null,2023,2023]
["Labour - Negotiation and analysis costs","Transgrid","$Millions",null,null,null,null,"Negotiation and analysis costs",null,null,null,null,null,null,null,null,null,0.53094488796918993,0.75832622599283372,0,0,0,1.2892711139620237]
["Labour - Insurance","Transgrid","$Millions",null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
["Labour - Indirect - Proportion of labour and labour-related costs","Transgrid","$Millions",null,null,null,null,"Indirect - Proportion of labour and labour-related costs",null,null,null,null,null,null,null,null,null,0,0.22754780912965292,0.32499695399692885,0,0,0.55254476312658174]
["Labour - Spare 1","Transgrid","$Millions",null,null,null,null,"Spare 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Labour - Spare 2","Transgrid","$Millions",null,null,null,null,"Spare 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Labour - Spare 3","Transgrid","$Millions",null,null,null,null,"Spare 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Labour - Spare 4","Transgrid","$Millions",null,null,null,null,"Spare 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Labour - Spare 5","Transgrid","$Millions",null,null,null,null,"Spare 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total"]
["Labour","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.53094488796918993,0.98587403512248661,0.32499695399692885,0,0,1.8418158770886055]
[]
["Note: Direct labour costs for each year are pro-rated across escalated capex by asset class for that year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",0.53094488796918993,0.98587403512248661,0.32499695399692885,0,0,1.8418158770886055]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (Real $2023)",0.53094488796918993,0.98587403512248661,0.32499695399692885,0,0,1.8418158770886055]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including escalation (Real $2023)",0.53094488796918993,0.98587403512248661,0.32499695399692885,0,0,1.8418158770886055]
[]
["Non-Labour Costs"]
[]
["Indirect Costs",null,null,null,"Conversion",null,null,"Mapping",null,null,null,null,null,null,null,null,null,"As incurred expenditure (June 2023 dollars, unescalated)"]
["Component","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,null,null,null,null,2024,2025,2026,2027,2028,"Total"]
["Forecast (from 1 August 2023)",null,null,null,2023]
["Non Labour - Negotiation and analysis costs","Transgrid","$Millions",null,null,null,null,"Negotiation and analysis costs",null,null,null,null,null,null,null,null,null,0.94233370265268068,3.0966322876743946,0,0,0,4.0389659903270756]
["Non Labour - Insurance","Transgrid","$Millions",null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null,0,2.4821537370323852,9.4071344923801146,2.2537729124426362,0,14.143061141855137]
["Non Labour - Indirect - Proportion of labour and labour-related costs","Transgrid","$Millions",null,null,null,null,"Indirect - Proportion of labour and labour-related costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Non Labour - Spare 1","Transgrid","$Millions",null,null,null,null,"Spare 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Non Labour - Spare 2","Transgrid","$Millions",null,null,null,null,"Spare 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Non Labour - Spare 3","Transgrid","$Millions",null,null,null,null,"Spare 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Non Labour - Spare 4","Transgrid","$Millions",null,null,null,null,"Spare 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Non Labour - Spare 5","Transgrid","$Millions",null,null,null,null,"Spare 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total"]
["Non-Labour","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94233370265268068,5.5787860247067798,9.4071344923801146,2.2537729124426362,0,18.18202713218221]
[]
["Note: Indirect costs for each year are pro-rated across escalated capex (including direct labour costs) by asset class for that year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",0.94233370265268068,5.5787860247067798,9.4071344923801146,2.2537729124426362,0,18.18202713218221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (Real $2023)",0.94233370265268068,5.5787860247067798,9.4071344923801146,2.2537729124426362,0,18.18202713218221]
[]
["Lookup tables and mapping"]
[]
["PTRM and RFM models"]
["RAB Asset Classes"]
["Transmission Lines"]
["Underground Cables"]
["Substations"]
["Secondary Systems"]
["Communications (short life)"]
["Business IT"]
["Minor Plant, Motor Vehicles & Mobile Plant"]
["Transmission Line Life Extension"]
["Land and Easements"]
["Synchronous Condensers"]
["Leasehold Land and Property"]
["Buildings - capital works"]
["In-house software"]
["[Spare]"]
[]
["Cost categories"]
[]
["Negotiation and analysis costs"]
["Insurance"]
["Indirect - Proportion of labour and labour-related costs"]
["Spare 1"]
["Spare 2"]
["Spare 3"]
["Spare 4"]
["Spare 5"]
[]
["End"]

{"sheet":"Calculations","index":3,"n_rows":79,"n_cols":21,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
["Calculations",null,null,null,"Real $2023"]
[]
[null,"Incremental Capital Expenditure (Excluding Equity Raising Costs) by RAB asset class",null,null,"As incurred expenditure",null,null,null,null,"Total",null,null,"As commissioned expenditure",null,null,null,null,"Total"]
[null,"Capex category","Dollar basis","Units",2024,2025,2026,2027,2028,null,null,null,2024,2025,2026,2027,2028]
[]
[null,"Direct Non-Labour Costs"]
[null,"Transmission Lines","Real $2023","$Million",0,228.57650432523116,358.2066193787598,80.821924050878351,0,667.60504775486925,null,null,0,197.06786028156426,389.71526342242663,80.821924050878351,0,667.60504775486925]
[null,"Underground Cables","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Substations","Real $2023","$Million",0,73.172452574996541,114.6699523904167,25.872905975577403,0,213.71531094099063,null,null,0,62.34023924889609,125.50216571651714,25.872905975577396,0,213.71531094099063]
[null,"Secondary Systems","Real $2023","$Million",0,41.692353789252643,65.336886434932183,14.741918734844221,0,121.77115895902905,null,null,0,36.623434064860511,70.405806159324328,14.741918734844219,0,121.77115895902905]
[null,"Communications (short life)","Real $2023","$Million",0,30.509128048875674,47.811439110258171,10.787663575938968,0,89.108230735072809,null,null,0,13.995252373236791,64.325314785897049,10.787663575938964,0,89.108230735072809]
[null,"Business IT","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Transmission Line Life Extension","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Land and Easements","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Synchronous Condensers","Real $2023","$Million",0,10.190708210887665,15.970054087901708,3.603312805384038,0,29.764075104173411,null,null,0,8.8959123534090736,17.135160726178071,3.7330020245862663,0,29.764075104173411]
[null,"Leasehold Land and Property","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Buildings - capital works","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"In-house software","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"[Spare]","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Sub-Total","Real $2023","$Million",0,384.1411469492437,601.99495140226873,135.82772514262297,0,1121.9638234941351,null,null,0,318.92269832196672,667.08371081034329,135.95741436182519,0,1121.9638234941351]
[]
[null,"Labour Costs"]
[null,"Transmission Lines","Real $2023","$Million",0.31592951560949112,0.58662718754021737,0.19338378158896213,0,0,1.0959404847386707,null,null,0,0.32350661075692105,0.63975659881777447,0.13267727516397509,0,1.0959404847386707,null,null,"← These costs for each year are pro-rated over the expenditure categories in proportion to total labour and overhead costs provided that spend is only commissioned once incurred"]
[null,"Underground Cables","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Substations","Real $2023","$Million",0.10113610568251803,0.18779248631090353,6.1906474722169619E-2,0,0,0.35083506671559117,null,null,0,0.10233774033153507,0.20602436244852312,4.2472963935532959E-2,0,0.35083506671559117]
[null,"Secondary Systems","Real $2023","$Million",5.7625542818331398E-2,0.10700079746832163,3.5273201254485131E-2,0,0,0.19989954154113815,null,null,0,6.0121031464362866E-2,0.11557817543494447,2.4200334641830801E-2,0,0.19989954154113815]
[null,"Communications (short life)","Real $2023","$Million",4.2168525039803367E-2,7.8299753662129573E-2,2.5811797990744709E-2,0,0,0.14628007669267765,null,null,0,2.2974607099730829E-2,0.10559644044708981,1.7709029145857008E-2,0,0.14628007669267765]
[null,"Business IT","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Transmission Line Life Extension","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Land and Easements","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Synchronous Condensers","Real $2023","$Million",1.4085198819045982E-2,2.6153810140914557E-2,8.6216984405671823E-3,0,0,4.8860707400527725E-2,null,null,0,1.4603530230298142E-2,2.8129080832261667E-2,6.1280963379679171E-3,0,4.8860707400527725E-2]
[null,"Leasehold Land and Property","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Buildings - capital works","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"In-house software","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"[Spare]","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Sub-Total","Real $2023","$Million",0.53094488796918993,0.98587403512248661,0.32499695399692885,0,0,1.8418158770886057,null,null,0,0.52354351988284797,1.0950846579805935,0.22318769922516379,0,1.8418158770886057]
[]
[null,"Indirect Non-Labour Costs"]
[null,"Transmission Lines","Real $2023","$Million",0.5607192704317655,3.3195595369907536,5.597551668344618,1.3410683493822673,0,10.818898825149404,null,null,0,3.1935906555005102,6.2842398202666265,1.341068349382267,0,10.818898825149404,null,null,"← These costs for each year are pro-rated over the expenditure categories in proportion to total labour and overhead costs provided that spend is only commissioned once incurred"]
[null,"Underground Cables","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Substations","Real $2023","$Million",0.17949878245218251,1.0626652704633259,1.7919015132248983,0.42930598000299774,0,3.4633715461434043,null,null,0,1.0102571025152878,2.0238084636251186,0.42930598000299769,0,3.4633715461434043]
[null,"Secondary Systems","Real $2023","$Million",0.10227519345570933,0.60548765083826261,1.0209934096209043,0.24461086340903815,0,1.9733671173239147,null,null,0,0.59350244446135725,1.1352538094535192,0.24461086340903826,0,1.9733671173239147]
[null,"Communications (short life)","Real $2023","$Million",7.484170812558244E-2,0.44307645389403222,0.74713024907727865,0.17899838880807309,0,1.4440467999049664,null,null,0,0.22680059110948594,1.0382478199874074,0.17899838880807306,0,1.4440467999049664]
[null,"Business IT","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Transmission Line Life Extension","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Land and Easements","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Synchronous Condensers","Real $2023","$Million",2.4998748187440838E-2,0.14799711252040523,0.24955765211241279,5.9789330840260321E-2,0,0.48234284366051922,null,null,0,0.14416304375258152,0.27768449455652289,6.0495305351414841E-2,0,0.48234284366051922]
[null,"Leasehold Land and Property","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Buildings - capital works","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"In-house software","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"[Spare]","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Sub-Total","Real $2023","$Million",0.94233370265268068,5.5787860247067798,9.4071344923801128,2.2537729124426367,0,18.18202713218221,null,null,0,5.1683138373392232,10.759234407889195,2.2544788869537911,0,18.18202713218221]
[]
[null,"Total"]
[0,"Transmission Lines","Real $2023","$Million",0.87664878604125662,232.48269104976214,363.99755482869341,82.16299240026062,0,679.51988706475743,null,null,0,200.58495754782169,396.63925984151103,82.295669675424591,0,679.51988706475731,null,0]
[0,"Underground Cables","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Substations","Real $2023","$Million",0.28063488813470056,74.422910331770765,116.52376037836376,26.3022119555804,0,217.52951755384962,null,null,0,63.452834091742915,127.73199854259077,26.344684919515927,0,217.52951755384964,null,0]
[0,"Secondary Systems","Real $2023","$Million",0.15990073627404072,42.40484223755923,66.393153045807566,14.986529598253259,0,123.94442561789408,null,null,0,37.277057540786231,71.656638144212792,15.010729932895089,0,123.94442561789411,null,0]
[0,"Communications (short life)","Real $2023","$Million",0.11701023316538581,31.030504256431836,48.584381157326199,10.966661964747042,0,90.698557611670466,null,null,0,14.245027571446007,65.469159046331541,10.984370993892895,0,90.698557611670438,null,0]
[0,"Business IT","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Transmission Line Life Extension","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Land and Easements","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Synchronous Condensers","Real $2023","$Million",3.9083947006486819E-2,10.364859133548986,16.228233438454687,3.6631021362242984,0,30.295278655234458,null,null,0,9.0546789273919526,17.440974301566857,3.7996254262756488,0,30.295278655234458,null,0]
[0,"Leasehold Land and Property","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Buildings - capital works","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"In-house software","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"[Spare]","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Total","Real $2023","$Million",1.4732785906218704,390.70580700907294,611.72708284864564,138.08149805506562,0,1141.987666503406,null,null,0,324.61455567918881,678.93802987621302,138.43508094800413,0,1141.987666503406,null,0]
[]
[0,"Check Direct Non-Labour Costs",null,null,0,0,0,0,0]
[0,"Check Labour Costs",null,null,0,0,0,0,0]
[0,"Check Indirect Non-Labour Costs",null,null,0,0,0,0,0]
[]
[]
["End"]

{"sheet":"Outputs","index":4,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Outputs"]
[]
[" PTRM Input"]
[]
[null,"As Incurred",null,"Dollar basis","Units",2024,2025,2026,2027,2028,"Total"]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2023","$Million",0.87664878604125662,232.48269104976214,363.99755482869341,82.16299240026062,0,679.51988706475743]
[null,"Underground Cables",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"Substations",null,"Real $2023","$Million",0.28063488813470056,74.422910331770765,116.52376037836376,26.3022119555804,0,217.52951755384962]
[null,"Secondary Systems",null,"Real $2023","$Million",0.15990073627404072,42.40484223755923,66.393153045807566,14.986529598253259,0,123.94442561789408]
[null,"Communications (short life)",null,"Real $2023","$Million",0.11701023316538581,31.030504256431836,48.584381157326199,10.966661964747042,0,90.698557611670466]
[null,"Business IT",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"Transmission Line Life Extension",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"Land and Easements",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"Synchronous Condensers",null,"Real $2023","$Million",3.9083947006486819E-2,10.364859133548986,16.228233438454687,3.6631021362242984,0,30.295278655234458]
[null,"Leasehold Land and Property",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"Buildings - capital works",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"In-house software",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"[Spare]",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"Total",null,"Real $2023","$Million",1.4732785906218704,390.70580700907294,611.72708284864564,138.08149805506562,0,1141.987666503406]
[]
[null,"As Commissioned",null,"Dollar basis","Units",2024,2025,2026,2027,2028,"Total"]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2023","$Million",0,200.58495754782169,396.63925984151103,82.295669675424591,0,679.51988706475731,0]
[null,"Underground Cables",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Substations",null,"Real $2023","$Million",0,63.452834091742915,127.73199854259077,26.344684919515927,0,217.52951755384964,0]
[null,"Secondary Systems",null,"Real $2023","$Million",0,37.277057540786231,71.656638144212792,15.010729932895089,0,123.94442561789411,0]
[null,"Communications (short life)",null,"Real $2023","$Million",0,14.245027571446007,65.469159046331541,10.984370993892895,0,90.698557611670438,0]
[null,"Business IT",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Transmission Line Life Extension",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Land and Easements",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Synchronous Condensers",null,"Real $2023","$Million",0,9.0546789273919526,17.440974301566857,3.7996254262756488,0,30.295278655234458,0]
[null,"Leasehold Land and Property",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Buildings - capital works",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"In-house software",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"[Spare]",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Total",null,"Real $2023","$Million",0,324.61455567918881,678.93802987621302,138.43508094800413,0,1141.987666503406,0]
[]
[0,"Check - As incurred",null,null,null,0,0,0,0,0]
[0,"Check - As commissioned",null,null,null,null,null,null,null,null,null,0]
[]
["Tables and Charts"]
[]
[null,"Contract cost",null,"Dollar basis","$Million","Total",null,"Nominal"]
[]
[null,"New contract price",null,"Real $2023","$Million",3362.6359320599208,null,3474.5719891984104]
[null,"Dinawan upgrade (funded by VNI West)",null,"Real $2023","$Million",-276.1279054795047,null,-293.19649499665837]
[null,"C-I-C",null,"Real $2023","$Million","C-I-C",null,"C-I-C"]
[null,"PEC Contractor Cost",null,"Real $2023","$Million",2967.1553549321079,null,3055.4754942017521]
[]
[null,"Less original contract costs",null,"Real $2023","$Million",-1634.1715825506042,null,-1624.3679385444618,"◄ Implied nominal dollar allowance"]
[null,"Increase in total contract price for PEC ",null,"Real $2023","$Million",1332.9837723815037,null,1431.1075556572903]
[]
[null,"C-I-C",null,"Real $2023","$Million","C-I-C",null,"C-I-C"]
[null,"C-I-C",null,"Real $2023","$Million","C-I-C",null,"C-I-C"]
[null,"Plus scope changes and variations under EPC contract",null,"Real $2023","$Million",16.979538353153998,null,17.917660160000001]
[null,"Plus contract cost savings prior to event",null,"Real $2023","$Million",36.883504795819917,null,34.514382533723598]
[null,"Less pre-event claims, variations & savings",null,"Real $2023","$Million",-211.01994888736834,null,-224.56795688627639]
[null,"Reopener amount",null,"Real $2023","$Million",1121.9638234941347,null,1206.539598771014]
[]
[]
["End"]