{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["UE_Output","Input"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"UE_Output","index":0,"n_rows":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Input!$A$1","v":"IT Capital Expenditure"},null,null,null,null,null,null,null,"AER draft decision"]
["Output",null,null,null,null,null,null,null,"RRP change"]
["United Energy"]
["Forecast, June $2021 '000 (no escalation)"]
[null,"Check OK:",{"$f":"SUM(AH10:AH13)=0","v":true}]
[]
[]
[null,"Function Code","Service",null,null,"2021/22","2021/22","2021/22","2022/23","2022/23","2022/23","2023/24","2023/24","2023/24","2024/25","2024/25","2024/25","2025/26","2025/26","2025/26",null,"Total",null,null,null,null,null,"Total",null,"Total"]
[null,null,null,null,null,"Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,null,null,"Labour","Materials","Contracts"]
[null,200,"Total SCS",null,null,{"$f":"Input!F18","v":33713.919437383222},{"$f":"Input!G18","v":9359.7475416616289},{"$f":"Input!H18","v":11114.495125102079},{"$f":"Input!I18","v":23849.190890891899},{"$f":"Input!J18","v":7707.7827512893364},{"$f":"Input!K18","v":5352.996933872545},{"$f":"Input!L18","v":18409.256150369372},{"$f":"Input!M18","v":8142.8599758133278},{"$f":"Input!N18","v":9223.8300664983635},{"$f":"Input!O18","v":13454.59374051013},{"$f":"Input!P18","v":9938.3452262887786},{"$f":"Input!Q18","v":9138.8941855024659},{"$f":"Input!R18","v":12509.318892554293},{"$f":"Input!S18","v":6377.0107751507321},{"$f":"Input!T18","v":3551.9439044182486},null,{"$f":"SUMIF($F$8:$T$8,V$9,$F10:$T10)","v":54188.162104146933},36909.970576053776,35775.946192681062,32531.833152301377,22438.273572123271,null,{"$f":"SUM(V10:Z10)","v":181844.18559730641},null,{"$f":"SUMIF($F$9:$T$9,AD$9,$F10:$T10)","v":101936.27911170891},{"$f":"SUMIF($F$9:$T$9,AE$9,$F10:$T10)","v":41525.746270203803},{"$f":"SUMIF($F$9:$T$9,AF$9,$F10:$T10)","v":38382.160215393706},null,{"$f":"AB10-SUM(Input!F18:T18)","v":0}]
[null,205,"Total Metering",null,null,{"$f":"Input!F35","v":543},{"$f":"Input!G35","v":459.5},{"$f":"Input!H35","v":547.5},{"$f":"Input!I35","v":0},{"$f":"Input!J35","v":0},{"$f":"Input!K35","v":0},{"$f":"Input!L35","v":50},{"$f":"Input!M35","v":25},{"$f":"Input!N35","v":25},{"$f":"Input!O35","v":0},{"$f":"Input!P35","v":0},{"$f":"Input!Q35","v":0},{"$f":"Input!R35","v":375},{"$f":"Input!S35","v":187.5},{"$f":"Input!T35","v":187.5},null,1550,0,100,0,750,null,{"$f":"SUM(V11:Z11)","v":2400},null,{"$f":"AD10/SUM($AD10:$AF10)","v":0.56056936204408869},{"$f":"AE10/SUM($AD10:$AF10)","v":0.22835894441058724},{"$f":"AF10/SUM($AD10:$AF10)","v":0.21107169354532415},null,{"$f":"AB11-SUM(Input!F35:T35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD10:AF10)-SUM(V10:Z10)","v":0}]
[]
[]
[null,null,"Revised proposal (before real escalation)"]
[null,null,null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
[null,null,"ICT",{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C17=Input!$D$10:$D$18)*(D$16=Input!$F$22:$T$22))/1000","v":50.077750102197726},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C17=Input!$D$10:$D$18)*(E$16=Input!$F$22:$T$22))/1000","v":30.359559166887898},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C17=Input!$D$10:$D$18)*(F$16=Input!$F$22:$T$22))/1000","v":30.142268115643429},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C17=Input!$D$10:$D$18)*(G$16=Input!$F$22:$T$22))/1000","v":31.259256576829557},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C17=Input!$D$10:$D$18)*(H$16=Input!$F$22:$T$22))/1000","v":20.604501301313295},{"$f":"IFERROR(SUM(D17:H17),\"\")","v":162.44333526287193}]
[null,null,"DER",{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C18=Input!$D$10:$D$18)*(D$16=Input!$F$22:$T$22))/1000","v":4.1104120019491974},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C18=Input!$D$10:$D$18)*(E$16=Input!$F$22:$T$22))/1000","v":6.5504114091658776},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C18=Input!$D$10:$D$18)*(F$16=Input!$F$22:$T$22))/1000","v":5.6336780770376294},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C18=Input!$D$10:$D$18)*(G$16=Input!$F$22:$T$22))/1000","v":1.2725765754718212},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C18=Input!$D$10:$D$18)*(H$16=Input!$F$22:$T$22))/1000","v":1.8337722708099784},{"$f":"IFERROR(SUM(D18:H18),\"\")","v":19.400850334434502}]
[]
[]
[null,null,null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
[null,null,"Recurrent",{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C22=Input!$B$10:$B$18)*(D$16=Input!$F$22:$T$22))/1000","v":26.262094228047687},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C22=Input!$B$10:$B$18)*(E$16=Input!$F$22:$T$22))/1000","v":20.641336021472071},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C22=Input!$B$10:$B$18)*(F$16=Input!$F$22:$T$22))/1000","v":15.627943146816179},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C22=Input!$B$10:$B$18)*(G$16=Input!$F$22:$T$22))/1000","v":21.444118175578648},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C22=Input!$B$10:$B$18)*(H$16=Input!$F$22:$T$22))/1000","v":19.290933600640027},{"$f":"IFERROR(SUM(D22:H22),\"\")","v":103.26642517255462}]
[null,null,"Non-recurrent",{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C23=Input!$B$10:$B$18)*(D$16=Input!$F$22:$T$22))/1000-D24","v":23.815655874150043},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C23=Input!$B$10:$B$18)*(E$16=Input!$F$22:$T$22))/1000-E24","v":9.7182231454158341},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C23=Input!$B$10:$B$18)*(F$16=Input!$F$22:$T$22))/1000-F24","v":14.51432496882725},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C23=Input!$B$10:$B$18)*(G$16=Input!$F$22:$T$22))/1000-G24","v":9.8151384012509091},{"$f":"SUMPRODUCT((Input!$F$10:$T$18)*($C23=Input!$B$10:$B$18)*(H$16=Input!$F$22:$T$22))/1000-H24","v":1.3135677006732689},{"$f":"IFERROR(SUM(D23:H23),\"\")","v":59.1769100903173}]
[null,null,"DER",{"$f":"D18","v":4.1104120019491974},{"$f":"E18","v":6.5504114091658776},5.6336780770376294,1.2725765754718212,1.8337722708099784,{"$f":"IFERROR(SUM(D24:H24),\"\")","v":19.400850334434502}]

{"sheet":"Input","index":1,"n_rows":35,"n_cols":31,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["IT Capital Expenditure",null,"AER draft decision"]
["Summary",null,"RRP change"]
["Linked data"]
["Forecast, June $2021 '000 (no escalation)"]
[]
[]
["Standard control services"]
[null,null,null,null,null,"2021/22 UE SCS",null,null,"2022/23 UE SCS",null,null,"2023/24 UE SCS",null,null,"2024/25 UE SCS",null,null,"2025/26 UE SCS",null,null,null,"Total",null,"UE SCS"]
["Project","Recurrent/Non-Recurrent","Category","AER category",null,"Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts",null,"2021/22 - 25/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Recurrent programs","Recurrent",null,"ICT",null,12837.39168278549,7184.154557848804,6240.547987413398,11673.848446342672,5348.2148801920648,3619.272694937335,8595.3925198786874,4182.0505562372973,2850.5000707001927,8759.5462072524533,8336.3809770944245,4348.1909912317706,11237.616285290769,4969.797989069385,3083.5193262798712,null,{"$f":"SUM(F10:T10)","v":103266.42517255461},null,{"$f":"SUMIF($F$22:$T$22,X$9,$E10:$S10)","v":20021.546240634292},{"$f":"SUMIF($F$22:$T$22,Y$9,$E10:$S10)","v":23262.611313948131},16396.715771053321,19946.427255047071,20555.605265591927]
["Digital network","Non-recurrent","New or expanded capabilities","DER",null,3453.3458516193473,657.06615032985053,0,4983.3439667662988,1567.0674423995788,0,4068.7302028649206,1564.9478741727085,0,650.83656225647894,621.7400132153424,0,1021.2711171762923,812.50115363368616,0,null,{"$f":"SUM(F11:T11)","v":19400.850334434504},null,4110.4120019491975,{"$f":"SUMIF($F$22:$T$22,Y$9,$E11:$S11)","v":6550.4114091658776},5633.678077037629,1272.5765754718213,1833.7722708099784]
["5 Minute Settlements","Non-recurrent","Complying new obligations","ICT",null,9916.753210784711,238.43446897711468,4097.6552745973668,2906.6345617817265,111.21480464800781,0,0,118.09598289654285,0,0,137.4603582172316,0,0,229.08611331250239,0,null,17755.334775215204,null,10155.187679761826,7115.5046410271016,118.09598289654285,137.4603582172316,229.08611331250239]
["SAP S/4HANA","Non-recurrent","Maintaining existing services","ICT",null,0,0,0,2227.2411055346229,0,1298.6828603700426,4136.3049102785853,1558.4194324440512,5168.7577842727696,3690.8566891716609,0,4467.4690396729466,0,0,0,null,22547.731821744677,null,0,2227.2411055346229,6993.4072030926791,8859.6144734444315,4467.4690396729466]
["Cyber security","Non-recurrent","New or expanded capabilities","ICT",null,383.33663123888851,783.71035188536212,776.29186309131535,187.29750098960895,411.72612806959182,435.04137856516718,145.69382099450999,304.26401896725821,282.1675202021334,167.36982391802653,289.32106296782132,323.23415459774907,250.43149008722997,365.62551913515875,468.42457813837734,null,5573.9358428481974,null,1167.0469831242506,1375.3154921505161,884.99921852693546,738.85840708798128,939.29116382013785]
["Customer Enablement","Non-recurrent","New or expanded capabilities","ICT",null,{"$f":"[1]Output_UE!F$12","v":7123.0920609547829},{"$f":"[1]Output_UE!G$12","v":496.38201262049745},{"$f":"[1]Output_UE!H$12","v":0},{"$f":"[1]Output_UE!I$12","v":850.02425071266202},{"$f":"[1]Output_UE!J$12","v":38.958323149276339},{"$f":"[1]Output_UE!K$12","v":0},{"$f":"[1]Output_UE!L$12","v":80.932020510306671},{"$f":"[1]Output_UE!M$12","v":0},{"$f":"[1]Output_UE!N$12","v":0},{"$f":"[1]Output_UE!O$12","v":0},{"$f":"[1]Output_UE!P$12","v":0},{"$f":"[1]Output_UE!Q$12","v":0},{"$f":"[1]Output_UE!R$12","v":0},{"$f":"[1]Output_UE!S$12","v":0},{"$f":"[1]Output_UE!T$12","v":0},null,8589.3886679475254,null,7619.4740735752803,888.98257386193836,80.932020510306671,0,0]
["Intelligent engineering","Non-recurrent","New or expanded capabilities","ICT",null,0,0,0,1020.8010587643122,230.60117283081669,0,1382.2026758423608,415.08211109547011,922.40469132326677,185.9844579115103,553.44281479396022,0,0,0,0,null,4710.5189825616981,null,0,1251.4022315951288,1797.2847869378309,1661.8319640287373,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F10:F17)","v":33713.919437383222},9359.7475416616289,11114.495125102079,23849.190890891899,7707.7827512893364,5352.996933872545,18409.256150369372,8142.8599758133278,9223.8300664983635,13454.59374051013,9938.3452262887786,9138.8941855024659,12509.318892554293,6377.0107751507321,3551.9439044182486,null,{"$f":"SUM(V10:V17)","v":181844.18559730641},null,43073.66697904485,42671.468767283317,31905.113060055246,32616.769033297271,28025.223853207492,null,{"$f":"SUM(F18:T18)-V18","v":0},{"$f":"SUM(F18:T18)-UE_Output!AB10","v":0}]
[]
[]
["SCS summary"]
[null,null,null,null,null,"2021/22","2021/22","2021/22","2022/23","2022/23","2022/23","2023/24","2023/24","2023/24","2024/25","2024/25","2024/25","2025/26","2025/26","2025/26",null,"Total",null,"UE SCS"]
[null,null,null,null,null,"Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts",null,"2021/22 - 25/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Recurrent","Maintaining existing services",null,null,null,{"$f":"SUMIF($B$10:$B$17, $A24,F$10:F$17)","v":12837.39168278549},7184.154557848804,6240.547987413398,11673.848446342672,5348.2148801920648,3619.272694937335,8595.3925198786874,4182.0505562372973,2850.5000707001927,8759.5462072524533,8336.3809770944245,4348.1909912317706,11237.616285290769,4969.797989069385,3083.5193262798712,null,{"$f":"SUM(F24:T24)","v":103266.42517255461},null,{"$f":"SUMIF($F$22:$T$22,X$9,$E24:$S24)","v":20021.546240634292},23262.611313948131,16396.715771053321,19946.427255047071,20555.605265591927]
["Non-Recurrent","Maintaining existing services",null,null,null,20876.52775459773,2175.5929838128245,4873.9471376886822,12175.342444549233,2359.5678710972716,1733.7242389352098,9813.8636304906831,3960.8094195760314,6373.3299957981699,4695.0475332576771,1601.9642491943555,4790.7031942706953,1271.7026072635222,1407.2127860813473,468.42457813837734,null,78577.760424751817,null,23052.120738410555,19408.857453335186,15508.397289001925,12670.341778250204,7469.618587615565]
["Total",null,null,null,null,{"$f":"SUM(F24:F25)","v":33713.919437383222},9359.7475416616289,11114.495125102079,23849.190890891907,7707.7827512893364,5352.996933872545,18409.256150369372,8142.8599758133287,9223.8300664983617,13454.59374051013,9938.3452262887804,9138.8941855024659,12509.318892554291,6377.0107751507321,3551.9439044182486,null,{"$f":"SUM(V24:V25)","v":181844.18559730641},null,43073.66697904485,42671.468767283317,31905.113060055246,32616.769033297271,28025.223853207488,null,{"$f":"SUM(F26:T26)-V26","v":0},{"$f":"SUM(F26:T26)-UE_Output!AB10","v":0}]
["Check",null,null,null,null,{"$f":"SUM(F24:F25)-F18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Metering services"]
["Project",null,null,null,null,"2021/22 UE AMI",null,null,"2022/23 UE AMI",null,null,"2023/24 UE AMI",null,null,"2024/25 UE AMI",null,null,"2025/26 UE AMI",null,null,null,"Total",null,"UE AMI"]
["Description","Recurrent/Non-Recurrent",null,null,null,"Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts",null,"2021/22 - 25/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["UIQ software upgrades","Recurrent",null,null,null,543,459.5,547.5,0,0,0,50,25,25,0,0,0,375,187.5,187.5,null,{"$f":"SUM(F33:T33)","v":2400},null,{"$f":"SUMIF($F$22:$T$22,X$9,$E33:$S33)","v":1002.5},547.5,75,25,562.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
["Total",null,null,null,null,{"$f":"SUM(F33:F34)","v":543},459.5,547.5,0,0,0,50,25,25,0,0,0,375,187.5,187.5,null,{"$f":"SUM(V33:V34)","v":2400},null,1002.5,547.5,75,25,562.5,null,{"$f":"SUM(F35:T35)-V35","v":0},{"$f":"SUM(F35:T35)-UE_Output!AB11","v":0}]