{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Presentation","Inflation","Key","UICs"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":12,"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":"Cover","index":0,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,6,33,7],[0,1,0,20],[1,1,1,2],[2,1,2,2],[4,1,7,15],[9,1,26,15],[30,1,30,3],[30,6,30,8]]}
[null,"UIC presentation model"]
[null,"Author:",null,"PricewaterhouseCoopers Advisory, spol. s r.o."]
[null,"Version",null,"DRAFT - design 2"]
[]
[null,"This model is an underlying document for the unit investment cost presentation in the UNIC tool. The sheet 'Presentation' provides the resuts for the asset selected by the users. Please, select infrastructure and asset categories, subcategories and the year for which you seek cost projections in the first table. Inflation projections are based on the baseline scenario of the EIB. If you wish to adjust inflation forecast, please, choose customary in the cell F4 of the list 'Inflation' and insert your values to the row 9. Selection of a subcategory in the same table may be necessary in order to provide the UIC indicator. UIC indicators are presented in the second table."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Structure of the document"]
[]
[null,"Cell to fill in"]
[null,"Error"]
[null,"Encoded results"]
[null,"Cell may be modified"]

{"sheet":"Presentation","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Presentation"]
[]
[null,"Select categories"]
[null,"Infrastructure category","Electricity "]
[null,"Asset category","Submarine cable"]
[null,{"$f":"IF(OR(C6=\"Overhead line\",C6=\"Underground cable\",C6=\"AC substation\",C6=\"Compression station\",C6=\"Transformer\",C6=\"Submarine cable\"),\"Subcategory\",\"\")","v":"Subcategory"}]
[null,"Year of construction for projection",2026]
[]
[null,"Results"]
[null,null,"UIC value (2023)","UIC value (current)",{"$f":"\"UIC projection\" & \" \"& C8","v":"UIC projection 2026"},"UIC unit"]
[null,"Average",{"$f":"IFERROR(_xlfn.IFS(LEN(C7)>0,INDEX(UICs!E5:E39,MATCH(1,(C6=UICs!C5:C39)*(C7=UICs!D5:D39),0)),(LEN(C7)=0),INDEX(UICs!E5:E39,MATCH(1,(Presentation!C6=UICs!C5:C39)*(UICs!D5:D39=\"\"),0))),\"Missing selection\")","v":1.6472965670556154},{"$f":"IFERROR(_xlfn.XLOOKUP((YEAR(TODAY())-1),Inflation!C$5:J$5,Inflation!C$6:J$6,1)*C12, \"Missing selection\")","v":1.6472965670556154},{"$f":"IFERROR(_xlfn.XLOOKUP(C8-1,Inflation!C$5:J$5,Inflation!C$6:J$6,1)*C12, \"Missing selection\")","v":1.8068936166526628},{"$f":"IFERROR(_xlfn.IFS(OR(C6=Key!B5,C6=Key!B6,C6=Key!B7,C6=Key!B8,C6=Key!D5),\"million EUR/km\",OR(C6=Key!B9,C6=Key!B10,C6=Key!B14,C6=Key!C6),\"million EUR/asset\",C6=Key!B12,\"million EUR/kV\",C6=Key!B13,\"million EUR/MVA\",C6=Key!C5,\"million EUR/MW\"),\"Missing selection\")","v":"million EUR/km"}]
[null,"Median",{"$f":"IFERROR(_xlfn.IFS(LEN(C7)>0,INDEX(UICs!F5:F39,MATCH(1,(C6=UICs!C5:C39)*(C7=UICs!D5:D39),0)),(LEN(C7)=0),INDEX(UICs!F5:F39,MATCH(1,(Presentation!C6=UICs!C5:C39)*(UICs!D5:D39=\"\"),0))),\"Missing selection\")","v":1.2630905700635457},{"$f":"IFERROR(_xlfn.XLOOKUP((YEAR(TODAY())-1),Inflation!C$5:J$5,Inflation!C$6:J$6,1)*C13, \"Missing selection\")","v":1.2630905700635457},{"$f":"IFERROR(_xlfn.XLOOKUP(C8-1,Inflation!C$5:J$5,Inflation!C$6:J$6,1)*C13, \"Missing selection\")","v":1.3854641197858701},{"$f":"F12","v":"million EUR/km"}]
[null,"1st Q",{"$f":"IFERROR(_xlfn.IFS(LEN(C7)>0,INDEX(UICs!G5:G39,MATCH(1,(C6=UICs!C5:C39)*(C7=UICs!D5:D39),0)),(LEN(C7)=0),INDEX(UICs!G5:G39,MATCH(1,(Presentation!C6=UICs!C5:C39)*(UICs!D5:D39=\"\"),0))),\"Missing selection\")","v":0.91210042153054594},{"$f":"IFERROR(_xlfn.XLOOKUP((YEAR(TODAY())-1),Inflation!C$5:J$5,Inflation!C$6:J$6,1)*C14, \"Missing selection\")","v":0.91210042153054594},{"$f":"IFERROR(_xlfn.XLOOKUP(C8-1,Inflation!C$5:J$5,Inflation!C$6:J$6,1)*C14, \"Missing selection\")","v":1.0004685630806058},{"$f":"F13","v":"million EUR/km"}]
[null,"3rd Q",{"$f":"IFERROR(_xlfn.IFS(LEN(C7)>0,INDEX(UICs!H5:H39,MATCH(1,(C6=UICs!C5:C39)*(C7=UICs!D5:D39),0)),(LEN(C7)=0),INDEX(UICs!H5:H39,MATCH(1,(Presentation!C6=UICs!C5:C39)*(UICs!D5:D39=\"\"),0))),\"Missing selection\")","v":2.4779866425298831},{"$f":"IFERROR(_xlfn.XLOOKUP((YEAR(TODAY())-1),Inflation!C$5:J$5,Inflation!C$6:J$6,1)*C15, \"Missing selection\")","v":2.4779866425298831},{"$f":"IFERROR(_xlfn.XLOOKUP(C8-1,Inflation!C$5:J$5,Inflation!C$6:J$6,1)*C15, \"Missing selection\")","v":2.7180644554737565},"million EUR/km"]
[]
[]
[null,"Chart"]

{"sheet":"Inflation","index":2,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[12,2,12,12]]}
[]
[null,"Inflation chart"]
[]
[null,null,"Inflation projections factor",null,null,"Baseline"]
[null,null,2023,2024,2025,2026,2027,2028,2029,2030]
[null,null,{"$f":"1+_xlfn.XLOOKUP($F4,$B7:$B9,C7:C9)","v":1.042},{"$f":"C6*(1+_xlfn.XLOOKUP($F4,$B7:$B9,D7:D9))","v":1.0711760000000001},{"$f":"D6*(1+_xlfn.XLOOKUP($F4,$B7:$B9,E7:E9))","v":1.0968842240000001},1.0968842240000001,1.0968842240000001,1.0968842240000001,1.0968842240000001,1.0968842240000001]
[null,"Baseline",4.2000000000000003E-2,2.8000000000000001E-2,2.4E-2]
[null,"Downside",4.2999999999999997E-2,0.03,2.4E-2]
[null,"Customary",0.2,0.16,0.04,-0.02,-0.02]
[null,null,"Source: ECB; ECB Economic Bulletin, Issue 8/2022 (HICP excl. food/energy)"]
[null,null,"Follow this link to update: https://www.ecb.europa.eu/pub/economic-bulletin/html/index.en.html"]
[]
[null,null,"Real inflation "]
[null,null,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022]
[null,"BE",null,null,1.2449800269946869,1.2387860965121307,1.2313977102506264,1.2096244697943288,1.183585586882905,1.156975158243309,1.143256085220661,1.1387012801002598,1.1033927132754455]
[null,"BG",null,null,1.2018521081019691,1.2213944188028139,1.234979189891622,1.2512453798294036,1.2364084780922964,1.2050764893687098,1.1756843798719123,1.1617434583714548,1.1301006404391583]
[null,"CZ",null,null,1.3295609549352154,1.3242638993378639,1.3203029903667638,1.3124284198476777,1.2816683787574976,1.2565376262328409,1.2246955421372718,1.18557167680278,1.1476976542137272]
[null,"DK",{"$f":"1/0.989*F18","v":1.1516577049982979},1.1492631552649113,1.1435454281242901,1.1389894702433165,1.1367160381669823,1.1367160381669827,1.1243482078802991,1.1165324805166825,1.1087710829361295,1.1054547187797903,1.084842707340324]
[null,"DE",null,null,1.2061416041212769,1.1965690517076164,1.1882512926590034,1.1835172237639475,1.1637337500137144,1.1420350834285715,1.1262673406593406,1.1217802197802198,1.0869963369963369]
[null,"EE",null,null,1.3801134694036434,1.3732472332374561,1.3718753578795764,1.3609874582138657,1.3124276356932163,1.2692723749450838,1.2407354593793587,1.2482248082287308,1.1944735006973501]
[null,"Ireland",null,null,1.1236585190751558,1.120297626196566,1.1202976261965658,1.1225427116198055,1.1191851561513513,1.1114053189189192,1.1014918918918919,1.107027027027027,1.0810810810810811]
[null,"GR",null,null,1.0838657983536715,1.0992553735838455,1.1114816719755767,1.1114816719755765,1.0993883995801943,1.0906630948216216,1.0852369102702701,1.0995308108108108,1.0929729729729729]
[null,"ES",null,null,1.1504050417005567,1.1527104626258082,1.1596684734666078,1.1631579473085336,1.1403509287338565,1.1212890154708517,1.1123898963004484,1.1157371076233182,1.0832399103139012]
[null,"FR",{"$f":"1/0.983*$F24","v":1.1617459261226655},{"$f":"1/0.9931*$F24","v":1.1499307676755413},1.1488482228508514,1.1419962453785801,1.1408553899885914,1.1374430608061732,1.1239555936819892,1.1008379957708021,1.0867107559435363,1.081304234769688,1.0590638930163447]
[null,"Croatia",null,null,1.17087252988507,1.1685354589671357,1.1720516138085613,1.1791263720408061,1.1639944442653565,1.1456638230958232,1.1365712530712531,1.1365712530712533,1.1066906066906068]
[null,"IT",null,null,1.1441203305151921,1.1418366572007905,1.1406959612395509,1.1418377990385893,1.1271844018149944,1.1138185788685717,1.1071755257142859,1.1082838095238097,1.0876190476190477]
[null,"Cyprus",null,null,1.0824809385072744,1.0857381529661729,1.1022722365138811,1.1156601584148591,1.1079048246423628,1.0991119292086933,1.0936437106554162,1.1058075941915229,1.0809458398744114]
[null,"LV",null,null,1.3263078333715814,1.3170882158605575,1.3144592972660254,1.3131461511149105,1.2761381449124494,1.2437993615131087,1.211099670411985,1.2098897806313538,1.1723738184412342]
[null,"LT",null,null,1.3679982312710921,1.3652676958793331,1.3748919394555219,1.3653345972745996,1.316619669502989,1.2845069946370624,1.256856159136069,1.2431811663066954,1.1885097192224621]
[null,"Luxembourg",null,null,1.1939191005666354,1.1856197622310183,1.1844353269041143,1.1844353269041141,1.1600737775750383,1.1373272329167046,1.1194165678314021,1.1194165678314021,1.0815619012863789]
[null,"Hungary",null,null,1.3729807107925549,1.3729807107925549,1.371609101690864,1.3661445235964782,1.3341255113246857,1.2965262500725807,1.2538938588709676,1.2126633064516128,1.1527217741935483]
[null,"Malta",null,null,1.1594989415426677,1.1502965689907423,1.1366566887260297,1.1265180264876409,1.1120612304912545,1.0934722030395816,1.0773125153099326,1.0687624159820761,1.0613330843913367]
[null,"NL",null,null,1.2337708722288461,1.2300806303378327,1.2276253795786751,1.2263989805980771,1.2106603954571344,1.1915948774184395,1.160267650845608,1.147643571558465,1.1163847972358609]
[null,"AT",null,null,1.2391937136951043,1.220880506103551,1.2111909782773325,1.1991989883933987,1.1733845287606639,1.149250273027095,1.1322662788444284,1.11663341108918,1.0862192714875292]
[null,"PL",null,null,1.2861640666976171,1.2848791875101071,1.2939367447231691,1.2965298043318332,1.276112012137631,1.260980249147857,1.2350443184601927,1.1909781277340334,1.1321084864391953]
[null,"PT",{"$f":"1/0.9922*F36","v":1.1451603909989116},null,1.1339556836692235,1.1362281399491201,1.1305752636309669,1.1238322700109018,1.1061341240264781,1.0930179091170733,1.08974866312769,1.0908395026303206,1.0811095169775227]
[null,"Romania",null,null,1.3029833466166933,1.2849934384780008,1.2901540546967885,1.3045035942333552,1.2903101822288379,1.2394910492111797,1.1929653986633104,1.1661440847148685,1.1202152590920929]
[null,"SI",null,null,1.1634860884744198,1.1588506857314942,1.1681962557777157,1.1705373304385929,1.1521036716915285,1.1306218564195569,1.1117225726839299,1.1150677760119658,1.0932037019725156]
[null,"SK",null,null,1.2448698325241168,1.2461159484725892,1.2498655451079128,1.2561462764903648,1.2388030340141667,1.2085883258674794,1.1756695776921007,1.1526172330314715,1.121222989330225]
[null,"FI",{"$f":"1/0.9681*F40","v":1.1727668235038229},{"$f":"1/0.9896*F40","v":1.1472873502769312},1.14897982857606,1.135355561834051,1.1376308234810131,1.1330984297619651,1.1241055850813146,1.1107762698431964,1.0986906724462873,1.0943134187712023,1.07180550320392]
[null,"Sweden",null,null,1.205004168117952,1.2025989701775968,1.1942392951118137,1.1812455935824075,1.1592204058708608,1.1364905939910399,1.1174932094307179,1.1097251334962444,1.080550276043081]
[null,null,"Source: Eurostat"]

{"sheet":"Key","index":3,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Key"]
[]
[null,"Electricity ","Gas","Hydrogen"]
[null,"Overhead line","Compression station","Hydrogen-ready pipeline 40\""]
[null,"Underground cable","Advanced metering equipment"]
[null,"Submarine cable"]
[null,"Offshore transmission cable"]
[null,"AC substation"]
[null,"Offshore AC substation"]
[null,"Transformer"]
[null,"HVDC converter"]
[null,"SSSC"]
[null,"Synchronous condensers"]
[]
[null,"Overhead line","Underground cable","AC substation","Transformer",{"$f":"C5","v":"Compression station"},"Submarine cable"]
[null,{"$f":"UICs!D5","v":"110-150 kV 2 circuits"},{"$f":"UICs!D11","v":"110 - 150 kV 1 circuit"},{"$f":"UICs!D20","v":"New/AIS/maximum 5 bays"},{"$f":"UICs!D29","v":"150/60"},"<1 MW","AC"]
[null,{"$f":"UICs!D6","v":"220 kV 1 circuit"},{"$f":"UICs!D12","v":"110 - 150 kV 2 circuits"},{"$f":"UICs!D21","v":"New/GIS/maximum 5 bays"},{"$f":"UICs!D30","v":"220/66"},"10-50 MW","DC"]
[null,{"$f":"UICs!D7","v":"220 kV 2 circuits"},{"$f":"UICs!D13","v":"220 - 225 kV 1 circuit"},{"$f":"UICs!D22","v":"Refurbishment or Upgrade/AIS/maximum 5 bays"},{"$f":"UICs!D31","v":"400/110"}]
[null,{"$f":"UICs!D8","v":"330 kV 2 circuits"},{"$f":"UICs!D14","v":"220 - 225 kV 2 circuits"},{"$f":"UICs!D23","v":"Refurbishment or Upgrade/GIS/maximum 5 bays"},{"$f":"UICs!D32","v":"400/220"}]
[null,{"$f":"UICs!D9","v":"400 kV 1 circuit"},{"$f":"UICs!D15","v":"300 - 500 kV 1 circuit"},{"$f":"UICs!D24","v":"New/AIS/from 6 to 9 bays"}]
[null,{"$f":"UICs!D10","v":"400 kV 2 circuits"},null,{"$f":"UICs!D25","v":"New/GIS/from 6 to 9 bays"}]
[null,null,null,{"$f":"UICs!D26","v":"Refurbishment or Upgrade/AIS/from 6 to 9 bays"}]
[null,null,null,{"$f":"\"New/\" & UICs!D$27","v":"New/from 10 to 60 bays"}]
[null," "," ",{"$f":"\"Refurbishment or Upgrade/\" & UICs!D$27","v":"Refurbishment or Upgrade/from 10 to 60 bays"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"UICs","index":4,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Unit investment cost indicators"]
[]
[null,"Infrastructure category","Asset category","Subcategory ","Average","Median","Q1","Q3"]
[null,"Electricity ","Overhead line","110-150 kV 2 circuits",0.32499196992799956,0.25971820253186861,0.22436975558528383,0.39297730057264985]
[null,"Electricity ","Overhead line","220 kV 1 circuit",0.41188681883328027,0.36218032486734664,0.30330054251978,0.5429061914788772]
[null,"Electricity ","Overhead line","220 kV 2 circuits",0.53049979829912397,0.50284341545835165,0.44169270006439199,0.67314164213312777]
[null,"Electricity ","Overhead line","330 kV 2 circuits",0.57360049350329412,0.53041326259368216,0.52186015991209389,0.5727021429747684]
[null,"Electricity ","Overhead line","400 kV 1 circuit",0.46528690591610772,0.39685637842340316,0.29774352951786137,0.60580572198705185]
[null,"Electricity ","Overhead line","400 kV 2 circuits",1.2609703763427484,1.0500435687846674,0.5331996078900163,1.6348921644159107]
[null,"Electricity ","Underground cable","110 - 150 kV 1 circuit",0.83065800699187997,0.55060052496683531,0.42526180270695585,0.64288048599684489]
[null,"Electricity ","Underground cable","110 - 150 kV 2 circuits",2.2320698861958395,1.679545186880127,0.84686459116852952,3.0647504819074367]
[null,"Electricity ","Underground cable","220 - 225 kV 1 circuit",1.7783550985340466,1.9100276925938136,1.2337320617679581,2.1080096214903397]
[null,"Electricity ","Underground cable","220 - 225 kV 2 circuits",4.4015424278900577,4.3867761952548694,4.2321205574816823,4.5561980656632457]
[null,"Electricity ","Underground cable","300 - 500 kV 1 circuit",1.3089521504480428,1.1310354257950164,1.04574116870865,1.3942464075344094]
[null,"Electricity ","Submarine cable",null,1.6472965670556154,1.2630905700635457,0.91210042153054594,2.4779866425298831]
[null,"Electricity ","Submarine cable","AC",2.0065332629446337,2.4675543574998051,1.2028375699968101,2.5268337456033869]
[null,"Electricity ","Submarine cable","DC",1.1084415232220892,1.0857833023545842,0.90337578661040785,1.257822155882246]
[null,"Electricity ","Offshore transmission cable",null,3.2893176537991309,3.0027057139789046,2.7613030188428143,4.3387201433027336]
[null,"Electricity ","AC substation","New/AIS/maximum 5 bays",11.712678215165647,6.6921654554494392,3.5888597074649815,16.906919755680988]
[null,"Electricity ","AC substation","New/GIS/maximum 5 bays",13.618809729108809,9.401506533176093,5.4016012278645373,15.986439058344807]
[null,"Electricity ","AC substation","Refurbishment or Upgrade/AIS/maximum 5 bays",3.4011246970928108,2.7893444671194914,2.1160750956410497,4.3004942273176141]
[null,"Electricity ","AC substation","Refurbishment or Upgrade/GIS/maximum 5 bays",4.4476005791484718,2.4051649381849769,1.9909539702005257,6.3967869048335402]
[null,"Electricity ","AC substation","New/AIS/from 6 to 9 bays",12.141284497338182,9.9434491031390131,8.1790787810387187,16.680966522164269]
[null,"Electricity ","AC substation","New/GIS/from 6 to 9 bays",9.8207739839230719,9.5535807417588092,7.8154346824562957,11.529677676678261]
[null,"Electricity ","AC substation","Refurbishment or Upgrade/AIS/from 6 to 9 bays",15.37788157173488,11.803321144994102,6.8073322861049972,23.436224649605204]
[null,"Electricity ","AC substation","from 10 to 60 bays",29.845348826726777,23.270197609286836,19.26119273908872,40.333298308182982]
[null,"Electricity ","Offshore AC substation",null,133.06959207202058,126.7306053764935,104.72789128379102,154.8251543004298]
[null,"Electricity ","Transformer","150/60",1.2122563840101683,1.0976833721067683,1.0976833721067683,1.2695428899618681]
[null,"Electricity ","Transformer","220/66",1.5360879147885871,1.5923327300787462,1.3399403734876678,1.7199342882628392]
[null,"Electricity ","Transformer","400/110",4.3556146957727107,4.3452747591500041,3.633137797868963,4.7289174932125295]
[null,"Electricity ","Transformer","400/220",4.6312163006693323,3.8474926983275015,2.9442676440932161,6.8157603984053878]
[null,"Electricity ","HVDC converter",null,0.15033128280360067,0.14738010598851287,0.1271928185295933,0.19272261500962562]
[null,"Electricity ","SSSC",null,2.9988705504096495E-2,2.4954223848058118E-2,1.831874731308001E-2,4.0007005142296492E-2]
[null,"Electricity ","Synchronous condensers",null,46.598500085743595,50.682030329670326,36.462537333333337,51.040791735428584]
[null,"Gas","Compression station",{"$f":"Key!F17","v":"<1 MW"},14.511488065149637,16.045933383294212,10.868266099686902,18.270709935388201]
[null,"Gas","Compression station","10-50 MW",4.2737015231001543,4.2839075418410042,4.2521366520015835,4.3003694035691504]
[null,"Gas","Advanced metering equipment",null,0.12564667338709676,0.12334122983870967,0.11354309475806451,0.13659753024193547]
[null,"Hydrogen","Hydrogen-ready pipeline 40\"",null,2.2713473442391061,2.2435415516708792,2.2156357524610693,2.2992531434489165]