{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Summary","Result tables","Option 3","Option 2","Option 1","Unit rate buildup","Labour costs","Replacement program breakdown"],"not_rendered":{"charts":2,"images":2,"macros":0,"external_links":0,"defined_names":4,"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":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"United Energy"]
[null,null,"Regulatory proposal 2026-31"]
[]
[null,null,{"$f":"REPLACE(LEFT(_xlfn.TEXTAFTER(CELL(\"filename\"),\" - \",1),FIND(\"Jan2025\",_xlfn.TEXTAFTER(CELL(\"filename\"),\" - \"),1)-4),1,1,UPPER(LEFT(LEFT(_xlfn.TEXTAFTER(CELL(\"filename\"),\" - \",1),FIND(\"Jan2025\",_xlfn.TEXTAFTER(CELL(\"filename\"),\" - \"),1)-4),1)))","v":"Metering business case"}]
[null,null,"Model number:",{"$f":"LEFT(_xlfn.TEXTAFTER(CELL(\"filename\"),\" MOD \"),FIND(\" - \",_xlfn.TEXTAFTER(CELL(\"filename\"),\" MOD \"),1)-1)","v":"12.04"}]
[]
[null,null,"2025-01-31"]

{"sheet":"Summary","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Proactive meter replacement - Cost model"]
[]
[]
[null,"Options summary - NPV"]
[]
[null,"Description","NPV","NPV net"]
[null,{"$f":"'Option 3'!B2","v":"Option 3 - Proactive delayed"},{"$f":"'Option 3'!D50","v":284091606.10944033},{"$f":"$C$10-C8","v":6414136.2160415649}]
[null,{"$f":"'Option 2'!B2","v":"Option 2 - Proactive"},{"$f":"'Option 2'!D50","v":274662245.71917748},{"$f":"$C$10-C9","v":15843496.606304407}]
[null,{"$f":"'Option 1'!B2","v":"Option 1 - Reactive"},{"$f":"'Option 1'!D35","v":290505742.32548189},"-"]
[]
[]
[null,"WACC"]
[null,3.6400000000000002E-2,3.6400000000000002E-2]
[]
[]
[]
[null,"Waterfall - NPV"]
[]
[]
[null,"Reactive failures - Labour",{"$f":"'Option 1'!D46","v":129238247.73925896},{"$f":"C21","v":129238247.73925896}]
[null,"Reactive failures - Materials",{"$f":"'Option 1'!D47","v":120911932.47288546},{"$f":"C22","v":120911932.47288546}]
[null,"Reactive faults - Labour",{"$f":"'Option 1'!D48","v":26920902.949683525},26920902.949683525]
[null,"Reactive Faults - Materials",{"$f":"'Option 1'!D49","v":13434659.16365394},13434659.16365394]
[null,"Proactive - Labour",{"$f":"-1*'Option 2'!D66","v":-47154991.673838168},{"$f":"-1*'Option 3'!D66","v":-27662402.305222556}]
[null,"Proactive - Materials",{"$f":"-1*'Option 2'!D67","v":-123365575.89340726},{"$f":"-1*'Option 3'!D67","v":-72368115.656421542}]
[null,"Residual failures - Labour",{"$f":"-1*'Option 2'!D68","v":-48004459.241145715},{"$f":"-1*'Option 3'!D68","v":-84843440.613598019}]
[null,"Residual failures - Materials",{"$f":"-1*'Option 2'!D69","v":-41523908.508640967},{"$f":"-1*'Option 3'!D69","v":-73389942.677383825}]
[null,"Residual faults - Labour",{"$f":"-1*'Option 2'!D70","v":-9999542.7900741342},{"$f":"-1*'Option 3'!D70","v":-17673266.781549487}]
[null,"Residual Faults - Materials",{"$f":"-1*'Option 2'!D71","v":-4613767.612071217},{"$f":"-1*'Option 3'!D71","v":-8154438.0752648637}]
[null,"Total",{"$f":"SUM(C21:C30)","v":15843496.606304437},{"$f":"SUM(D21:D30)","v":6414136.2160415836}]

{"sheet":"Result tables","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NPV Results"]
[]
[]
[null,"United Energy"]
[]
[null,"option ","gross npv","net npv*","bcr*"]
[null,"Option1 - Base Case ",290505742.32548189,"N/A","N/A"]
[null,"Option 2",274664437.69732958,{"$f":"C8-C9","v":15841304.628152311},{"$f":"C8/C9","v":1.0576751208163646}]
[null,"Option 3",284091606.10944033,{"$f":"C8-C10","v":6414136.2160415649},{"$f":"C8/C10","v":1.0225777040859512}]
[]
[]
[null,null,"Reactive","Proactive","Move to 2031"]
[null,"Sensitivity analysis","Base Case","Option 2","Option 3"]
[null,"Adopting alternative failure rate profile option 1",358032836.04069787,317068863.71231252,347155477.29951739]
[null,"Adopting alternative failure rate profile option 2",193430852.74088576,243192313.17925668,236565776.62614363]
[null,"+10% change in reactive replacement installation costs",303740876.73315924,281267610.76492435,296599904.96216768]
[null,"-10% change in reactive replacement installation costs",272941915.80650109,270515812.26807529,276874119.27110994]
[null,"\"+10% change in tech capital costs\"",301776055.43348414,293237662.40837073,302592149.59181076]
[null,"\"-10% change in tech capital costs\"",274906737.10617632,258545760.62462881,270881874.6414668]
[null,"6% WACC",236739372.55566844,243156029.81014651,241293956.66608462]

{"sheet":"Option 3","index":3,"n_rows":72,"n_cols":18,"rows_kept":72,"cut":false,"hidden":false,"merged":[[7,1,12,1],[14,1,19,1],[24,1,29,1],[31,1,36,1]]}
[]
[null,"Option 3 - Proactive delayed"]
[]
[null,"Expenditure / benefits profile"]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","2031-32","2032-33","2033-34","2034-35","2035-36","2036-37","2037-38","2038-39","2039-40","2040-41"]
[null," Pro-active Labour Costs","AMI 1Ph 1e",0,0,0,0,0,3936661.3852273338,4294518.5748501299,4294518.5748501299,4294518.5748501299,4294518.5748501299,3041960.3363261991,894701.04890113452,0,0,0]
[null,null,"AMI 1Ph 1e + c",0,0,0,0,0,89319.110295335893,97449.588475665572,97449.588475665572,97449.588475665572,97449.588475665572,68992.914844511732,20326.195450824165,0,0,0]
[null,null,"AMI 1Ph 2e + C",0,0,0,0,0,374118.14598345506,408150.00465254922,408150.00465254922,408150.00465254922,408150.00465254922,289096.57415486482,85021.571828590226,0,0,0]
[null,null,"AMI 3Ph",0,0,0,0,0,1252376.1272842651,1366287.4246682525,1366287.4246682525,1366287.4246682525,1366287.4246682525,967678.90181674622,284697.2254675189,0,0,0]
[null,null,"AMI 3Ph + C",0,0,0,0,0,46990.435620706026,51365.407212978658,51365.407212978658,51365.407212978658,51365.407212978658,36296.060617372932,10694.375003333096,0,0,0]
[null,null,"AMI 3Ph CT",0,0,0,0,0,179326.24749284366,194972.16170362866,194972.16170362866,194972.16170362866,194972.16170362866,138406.16417232901,40920.083320514663,0,0,0]
[null,null,null,{"$f":"SUM(D8:D13)","v":0},{"$f":"SUM(E8:E13)","v":0},0,0,0,5878791.4519039383,6412743.1615632046,6412743.1615632046,6412743.1615632046,6412743.1615632046,4542430.9519320242,1336360.499971916,0,0,0]
[null,"Pro-active Material Costs","AMI 1Ph 1e",0,0,0,0,0,10030959.318206139,10942810.899930777,10942810.899930777,10942810.899930777,10942810.899930777,7751182.3840857642,2279776.9341203757,0,0,0]
[null,null,"AMI 1Ph 1e + c",0,0,0,0,0,262330.64986095938,286209.90277418069,286209.90277418069,286209.90277418069,286209.90277418069,202632.51757790623,59698.132283053186,0,0,0]
[null,null,"AMI 1Ph 2e + C",0,0,0,0,0,1250391.606525375,1364134.1525396362,1364134.1525396362,1364134.1525396362,1364134.1525396362,966229.34139759664,284162.26512777852,0,0,0]
[null,null,"AMI 3Ph",0,0,0,0,0,3514154.1550279548,3833788.0495789512,3833788.0495789512,3833788.0495789512,3833788.0495789512,2715296.7542795893,798857.40074836544,0,0,0]
[null,null,"AMI 3Ph + C",0,0,0,0,0,138162.75740998168,151026.18654815241,151026.18654815241,151026.18654815241,151026.18654815241,106718.81951667552,31443.937893306178,0,0,0]
[null,null,"AMI 3Ph CT",0,0,0,0,0,182917.00945698764,198876.21162437581,198876.21162437581,198876.21162437581,198876.21162437581,141177.55763458778,41739.45182239986,0,0,0]
[null,null,null,{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E15:E20)","v":0},0,0,0,15378915.496487398,16776845.402996076,16776845.402996076,16776845.402996076,16776845.402996076,11883237.37449212,3495678.1219952796,0,0,0]
[]
[null,null,null,"Year"]
[null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","2031-32","2032-33","2033-34","2034-35","2035-36","2036-37","2037-38","2038-39","2039-40","2040-41"]
[null," Pro-active failures Labour Costs","AMI 1Ph 1e",2239922.0706921774,3552344.417414011,5120289.8668985348,6863907.4495324092,8602611.1263439246,9608733.3434720188,9658691.3859993406,9211525.9561646301,8322518.4944694359,7000677.8282547472,5495794.170157169,4733319.783387729,4731681.8147802763,4696874.9818718964,4547819.8385936609]
[null,null,"AMI 1Ph 1e + c",50777.026831047529,80669.953917067454,116295.77112917339,155607.01770804889,195327.75643878768,217849.82479126845,219078.30124685832,208840.99745027613,188775.88200897511,158882.95492295519,124485.61416643912,107286.94378818107,107286.94378818107,106467.95948445451,103192.02226954821]
[null,null,"AMI 1Ph 2e + C",212935.91896890901,337831.02528721141,486886.16856544773,652320.99791821546,817755.82727098325,913167.49865512899,918081.40447748848,875494.22068370669,791138.83739986958,665424.74677784066,522511.98577755364,450031.8748977519,449622.38274588861,446346.44553098234,432423.71236763062]
[null,null,"AMI 3Ph",646662.56091065006,1025740.6138582724,1478456.2639585109,1981992.2275866114,2484491.0419590413,2774892.8335468229,2789412.9231262123,2660287.8407952162,2403593.4000167307,2021922.4739299314,1586838.3611760938,1366962.7189739163,1366444.144346081,1356591.2264172097,1313549.5323068777]
[null,null,"AMI 3Ph + C",24373.007508260267,38374.522459814034,55487.485178379757,74674.746408286766,93343.433010358465,104233.50019490029,104752.07482273561,100084.90317221769,90231.985243346513,76230.47029179275,59636.082201062352,51338.888155697154,51338.888155697154,50820.313527861828,49264.589644355859]
[null,null,"AMI 3Ph CT",32094.182996482083,50815.789744429967,73549.169366938106,98288.435426726384,123027.70148651465,137737.53535990228,138406.16417232898,131719.87604806188,119015.92861195438,100294.3218640065,78898.199866351788,67531.510055097722,67531.510055097722,67531.510055097722,64856.994805390874]
[null,null,null,{"$f":"SUM(D25:D30)","v":3206764.7679075263},{"$f":"SUM(E25:E30)","v":5085776.3226808067},7330964.7250969838,9826790.8745802995,12316556.88650961,13756614.536020041,13828422.253844965,13187953.794314109,11915274.527750313,10023432.796041274,7868164.4133446701,6776471.7192583727,6773905.6838712217,6724632.4368875027,6511106.6899874639]
[null,"Pro-active failures Material Costs","AMI 1Ph 1e",1618899.1080927502,2567449.6823957236,3700679.0580606489,4960875.1096619163,6217519.6458523758,6944692.426215061,6980799.4995582635,6657611.5971748475,6015083.2674363907,5059725.6219293708,3972074.0273697991,3420997.2194596161,3419813.3809893471,3394656.8134961328,3286927.5127016609]
[null,null,"AMI 1Ph 1e + c",50928.859030612912,80911.171201860838,116643.515844307,156072.30993252344,195911.82062582549,218501.23390553283,219733.3837207896,209465.46859364989,189340.35494445608,159358.04277320814,124857.84794601875,107607.75053242406,107607.75053242406,106786.31732225289,103500.58448156818]
[null,null,"AMI 1Ph 2e + C",226109.65678196063,358731.66700984136,517008.42675721383,692678.23702627548,868348.04729533719,969662.56658417732,974880.48174068413,929658.55038429191,840084.34019759216,706592.67744362692,554838.31164188799,477874.06308341294,477439.23682037072,473960.62671603286,459176.53377259697]
[null,null,"AMI 3Ph",599642.9604567223,951157.7993451457,1370955.9585101164,1837879.2260349579,2303840.7566544958,2573127.0901394715,2586591.4068137202,2466855.1621034364,2228825.2780408245,1874906.0968891422,1471457.4651143306,1267569.2411899921,1267088.3727373402,1257951.872136957,1218039.7905668626]
[null,null,"AMI 3Ph + C",23800.339725210906,37472.875312034193,54183.75214037377,72920.18979639087,91150.237245488577,101784.43159079558,102290.82179771496,97733.309935440528,88111.896003972288,74439.360417149001,58234.873795728818,50132.630485018723,50132.630485018723,49626.240278099336,48107.069657341191]
[null,null,"AMI 3Ph CT",31350.065853425662,49637.604267923962,71843.900914100479,96009.576676116092,120175.25243813171,134544.0326209518,135197.15899289816,128665.89527343449,116256.4942064535,97968.955791955188,77068.911889671421,65965.763566583162,65965.763566583162,65965.763566583162,63353.258078797691]
[null,null,null,{"$f":"SUM(D32:D37)","v":2550730.9899406829},{"$f":"SUM(E32:E37)","v":4045360.7995325299},5831314.6122267609,7816434.64912818,9796945.760111656,10942311.781055989,10999492.75262407,10489989.983465102,9477701.63082969,7972990.7552444525,6258531.4377574371,5390146.6683170479,5388047.1351310844,5348947.6335160583,5179104.7492588274]
[]
[]
[]
[]
[]
[]
[null,"Capital costs"]
[]
[null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","2031-32","2032-33","2033-34","2034-35","2035-36","2036-37","2037-38","2038-39","2039-40","2040-41"]
[null,null,null,{"$f":"D38+D31+D21+D14","v":5757495.7578482088},9131137.1222133376,13162279.337323744,17643225.523708478,22113502.646621265,45956633.265467361,48017503.571028315,46867532.342338488,44582564.723139286,41186012.11584501,30552364.17752625,16998657.009542618,12161952.819002306,12073580.070403561,11690211.439246291]
[]
[null,"NPV",null,284091606.10944033]
[]
[null,"NPV Breakdown"]
[]
[]
[]
[null,"Proactive - Labour",null,{"$f":"D14","v":0},{"$f":"E14","v":0},0,0,0,5878791.4519039383,6412743.1615632046,6412743.1615632046,6412743.1615632046,6412743.1615632046,4542430.9519320242,1336360.499971916,0,0,0]
[null,"Proactive - Materials",null,{"$f":"D21","v":0},{"$f":"E21","v":0},0,0,0,15378915.496487398,16776845.402996076,16776845.402996076,16776845.402996076,16776845.402996076,11883237.37449212,3495678.1219952796,0,0,0]
[null,"Proactive failures - Labour",null,2653937.7147477414,4209018.9235616848,6067150.2830921849,8132710.9421889652,10193256.195175486,11385056.524808185,11444485.021856904,10914429.491477463,9861152.5133487862,8295452.973312838,6511739.9602831174,5608248.5527606616,5606124.8865162609,5565346.0524069229,5388630.866298194]
[null,"Proactive failures - Materials",null,2295657.8909466146,3640824.7195792771,5248183.1510040853,7034791.1842153622,8817251.1841004901,9848080.6029503904,9899543.4773616642,9440990.9851185922,8529931.4677467216,7175691.6797200078,5632678.2939816937,4851132.0014853431,4849242.4216179764,4814052.8701644531,4661194.2743329452]
[null,"Proactive faults - Labour",null,{"$f":"D31-D58","v":552827.05315978499},{"$f":"E31-E58","v":876757.39911912195},1263814.4420047989,1694079.9323913343,2123300.6913341247,2371558.0112118553,2383937.2319880612,2273524.3028366454,2054122.0144015271,1727979.8227284364,1356424.4530615527,1168223.1664977111,1167780.7973549608,1159286.3844805798,1122475.8236892698]
[null,"Proactive Faults - Materials",null,{"$f":"D38-D59","v":255073.09899406834},{"$f":"E38-E59","v":404536.0799532528},583131.46122267563,781643.46491281781,979694.57601116598,1094231.1781055983,1099949.2752624061,1048998.9983465094,947770.16308296844,797299.07552444469,625853.14377574343,539014.66683170479,538804.71351310797,534894.76335160527,517910.47492588218]
[]
[null,"NPV"]
[]
[]
[null,"Proactive - Labour",null,27662402.305222556]
[null,"Proactive - Materials",null,72368115.656421542]
[null,"Proactive failures - Labour",null,84843440.613598019]
[null,"Proactive failures - Materials",null,73389942.677383825]
[null,"Proactive faults - Labour",null,17673266.781549487]
[null,"Proactive Faults - Materials",null,8154438.0752648637]
[null,"Total",null,{"$f":"SUM(D66:D71)","v":284091606.10944033}]

{"sheet":"Option 2","index":4,"n_rows":72,"n_cols":18,"rows_kept":72,"cut":false,"hidden":false,"merged":[[7,1,12,1],[14,1,19,1],[24,1,29,1],[31,1,36,1]]}
[]
[null,"Option 2 - Proactive"]
[]
[null,"Expenditure / benefits profile"]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","2031-32","2032-33","2033-34","2034-35","2035-36","2036-37","2037-38","2038-39","2039-40","2040-41"]
[null," Pro-active Labour Costs","AMI 1Ph 1e",3936661.3852273338,4294518.5748501299,4294518.5748501299,4294518.5748501299,4294518.5748501299,4294518.5748501299,4294518.5748501299,4294518.5748501299,2862973.6666706563,715714.37924559147,0,0,0,0,0]
[null,null,"AMI 1Ph 1e + c",89319.110295335893,97449.588475665572,97449.588475665572,97449.588475665572,97449.588475665572,97449.588475665572,97449.588475665572,97449.588475665572,64927.675754346899,16260.956360659331,0,0,0,0,0]
[null,null,"AMI 1Ph 2e + C",374118.14598345506,408150.00465254922,408150.00465254922,408150.00465254922,408150.00465254922,408150.00465254922,408150.00465254922,408150.00465254922,272138.71966446296,68063.717338188348,0,0,0,0,0]
[null,null,"AMI 3Ph",1252376.1272842651,1366287.4246682525,1366287.4246682525,1366287.4246682525,1366287.4246682525,1366287.4246682525,1366287.4246682525,1366287.4246682525,910804.27111720201,227660.55878307574,0,0,0,0,0]
[null,null,"AMI 3Ph + C",46990.435620706026,51365.407212978658,51365.407212978658,51365.407212978658,51365.407212978658,51365.407212978658,51365.407212978658,51365.407212978658,34189.592813686111,8587.9071996462735,0,0,0,0,0]
[null,null,"AMI 3Ph CT",178724.48156165969,194972.16170362875,194972.16170362875,194972.16170362875,194972.16170362875,194972.16170362875,194972.16170362875,194972.16170362875,129981.4411357525,32495.360283938124,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D8:D13)","v":5878189.6859727548},{"$f":"SUM(E8:E13)","v":6412743.1615632046},6412743.1615632046,6412743.1615632046,6412743.1615632046,6412743.1615632046,{"$f":"SUM(J8:J13)","v":6412743.1615632046},6412743.1615632046,4275015.367156107,1068782.8792110994,{"$f":"SUM(N8:N13)","v":0},0,0,0,0]
[null,"Pro-active Material Costs","AMI 1Ph 1e",10030959.318206139,10942810.899930777,10942810.899930777,10942810.899930777,10942810.899930777,10942810.899930777,10942810.899930777,10942810.899930777,7295108.613414662,1823703.1634492737,0,0,0,0,0]
[null,null,"AMI 1Ph 1e + c",262330.64986095944,286209.90277418069,286209.90277418069,286209.90277418069,286209.90277418069,286209.90277418069,286209.90277418069,286209.90277418069,190692.8911212956,47758.505826442546,0,0,0,0,0]
[null,null,"AMI 1Ph 2e + C",1250391.6065253753,1364134.1525396362,1364134.1525396362,1364134.1525396362,1364134.1525396362,1364134.1525396362,1364134.1525396362,1364134.1525396362,909552.16829834029,227485.09202852217,0,0,0,0,0]
[null,null,"AMI 3Ph",3514154.1550279548,3833788.0495789512,3833788.0495789512,3833788.0495789512,3833788.0495789512,3833788.0495789512,3833788.0495789512,3833788.0495789512,2555707.1426332169,638813.11784374132,0,0,0,0,0]
[null,null,"AMI 3Ph + C",138162.75740998168,151026.18654815241,151026.18654815241,151026.18654815241,151026.18654815241,151026.18654815241,151026.18654815241,151026.18654815241,100525.31659829702,25250.434974927688,0,0,0,0,0]
[null,null,"AMI 3Ph CT",182303.19398901117,198876.21162437581,198876.21162437581,198876.21162437581,198876.21162437581,198876.21162437581,198876.21162437581,198876.21162437581,132584.14108291719,33146.035270729299,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D15:D20)","v":15378301.68101942},{"$f":"SUM(E15:E20)","v":16776845.402996076},16776845.402996076,16776845.402996076,16776845.402996076,16776845.402996076,{"$f":"SUM(J15:J20)","v":16776845.402996076},16776845.402996076,11184170.273148727,2796156.349393636,{"$f":"SUM(N15:N20)","v":0},0,0,0,0]
[]
[null,null,null,"Year"]
[null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","2031-32","2032-33","2033-34","2034-35","2035-36","2036-37","2037-38","2038-39","2039-40","2040-41"]
[null," Pro-active failures Labour Costs","AMI 1Ph 1e",1966381.3132475021,2676031.2124265777,3370120.4098348483,3975759.3024406489,4394669.7737967912,4571570.383401731,4458141.0573356003,3984768.1297816415,3308696.5870553553,3092484.73087154,3341865.4513562815,3551115.9409584207,3674782.5708211334,3708770.4194257865,3655945.9318354223]
[null,null,"AMI 1Ph 1e + c",44634.644553098231,60604.83847576641,76575.032398434589,90088.273409923044,99506.592902778633,103601.5144214115,101144.56151023178,90497.765561786335,74937.06379098144,70023.157968622007,75756.048094708007,80669.953917067454,83536.398980110462,83945.891131973738,83126.906828247171]
[null,null,"AMI 1Ph 2e + C",186728.42124965866,254294.62630710096,320222.86275709007,377961.25616981351,417681.99490055226,434471.17312694702,423824.37717850157,378780.24047354003,314489.97263100406,294015.36503783974,317765.90984591038,337421.53313534812,349296.80553938344,352572.74275428971,347658.83693193027]
[null,null,"AMI 3Ph",567839.21747968066,772676.19547463395,973364.57644690468,1148124.2260274091,1268952.1143130397,1320291.0024687368,1287620.8009151116,1150717.0991665858,955733.03910050367,892985.50913242926,965067.38240153948,1025222.0392304371,1061003.6885510746,1070856.6064799458,1055817.9422727213]
[null,null,"AMI 3Ph + C",21261.559741248318,29040.179158778188,36818.798576308058,43041.694110331962,47708.865760849883,49783.164272191178,48227.440388685209,43041.694110331962,35781.649320637414,33707.350809296113,36300.22394847274,38374.522459814034,39930.24634332001,40448.820971155335,39930.24634332001]
[null,null,"AMI 3Ph CT",28082.410121921836,38111.842308322492,48141.274494723148,56833.449056270387,62851.108368110778,65525.623617817619,64188.365992964202,56833.449056270387,47472.645682296439,44129.50162016289,48141.274494723148,50815.789744429989,52821.676181710121,52821.676181710121,52153.047369283413]
[null,null,null,{"$f":"SUM(D25:D30)","v":2814927.56639311},{"$f":"SUM(E25:E30)","v":3830758.8941511801},4825242.9545083093,5691808.2012143964,6291370.450042123,6545242.8613088354,6383146.6033210941,5704638.3781501567,4737110.9575807797,4427345.61543989,4784896.2901416356,5083619.7794455178,5261371.3864167323,5309416.1569448616,5234632.9115809249]
[null,"Pro-active failures Material Costs","AMI 1Ph 1e",1421198.0835578404,1934096.1008018507,2435747.6525783064,2873471.9269602401,3176238.6157315164,3304093.1705205604,3222112.3564544371,2879983.0385467191,2391353.7099432214,2235087.0318677239,2415326.4389661672,2566561.8035430219,2655941.6080483254,2680506.2563064056,2642327.4656402329]
[null,null,"AMI 1Ph 1e + c",44768.109954329077,60786.057552667,76804.005151004923,90357.65311882933,99804.135035797852,103911.30108665372,101447.00145614019,90768.369723914919,75161.138730662569,70232.539469635522,75982.571940833746,80911.171201860809,83786.187437459914,84196.904042545502,83375.470832374325]
[null,null,"AMI 1Ph 2e + C",198280.7759472577,270027.10934922594,340034.13769902528,401344.64078797994,443522.78830307646,461350.66508780792,450045.1822487099,402214.29331406439,333946.57001643401,312205.25686432241,337425.18012077187,358296.84074679902,370906.80237502372,374385.41247936158,369167.49732285482]
[null,null,"AMI 3Ph",526550.95565365779,716493.99445109593,902590.08562732022,1064642.7541709573,1176685.1036388134,1224291.0804513358,1193996.3679342759,1067047.096434216,886240.55823716091,828055.47546630015,894896.19038489228,950676.93089249439,983856.85412546468,992993.35472584772,979048.16959894716]
[null,null,"AMI 3Ph + C",20761.99848369461,28357.851587485318,35953.704691276034,42030.387174308598,46587.899036583025,48613.459864260549,47094.289243502404,42030.387174308598,34940.924277437269,32915.363449759745,35447.314484356648,37472.875312034172,38992.045932792316,39498.436139711695,38992.045932792316]
[null,null,"AMI 3Ph CT",27431.307621747459,37228.203200942982,47025.098780138498,55515.741615441286,61393.878962958595,64006.384450744074,62700.131706851331,55515.741615441286,46371.97240819213,43106.340548460292,47025.098780138498,49637.604267923976,51596.983383763079,51596.983383763079,50943.857011816712]
[null,null,null,{"$f":"SUM(D32:D37)","v":2238991.2312185266},{"$f":"SUM(E32:E37)","v":3046989.3169432678},3838154.6845270712,4527363.1038277568,5004232.4207087457,5206266.0614613621,5077395.3290439164,4537558.9268086646,3768014.8736131084,3521602.0076662023,3806102.7946771597,4043557.2259641346,4185080.481302829,4223177.3470776351,4163854.5063390187]
[]
[]
[]
[]
[]
[]
[null,"Capital costs"]
[]
[null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","2031-32","2032-33","2033-34","2034-35","2035-36","2036-37","2037-38","2038-39","2039-40","2040-41"]
[null,null,null,{"$f":"D38+D31+D21+D14","v":26310410.164603811},30067336.775653727,31852986.203594662,33408759.869601436,34485191.435310148,34941097.487329476,34650130.496924289,33431785.869518101,23964311.471498724,11813886.851710828,8590999.0848187953,9127177.0054096524,9446451.8677195609,9532593.5040224977,9398487.4179199431]
[]
[null,"Total NPV",null,{"$f":"NPV(Summary!$B$14,D48:R48)","v":274662245.71917748}]
[]
[null,"NPV Breakdown"]
[]
[]
[]
[null,"Proactive - Labour",null,{"$f":"D14","v":5878189.6859727548},{"$f":"E14","v":6412743.1615632046},6412743.1615632046,6412743.1615632046,6412743.1615632046,6412743.1615632046,6412743.1615632046,6412743.1615632046,4275015.367156107,1068782.8792110994,0,0,0,0,0]
[null,"Proactive - Materials",null,{"$f":"D21","v":15378301.68101942},{"$f":"E21","v":16776845.402996076},16776845.402996076,16776845.402996076,16776845.402996076,16776845.402996076,16776845.402996076,16776845.402996076,11184170.273148727,2796156.349393636,0,0,0,0,0]
[null,"Proactive failures - Labour",null,{"$f":"D31*(1-'Labour costs'!$I$14)","v":2329650.9015871733},{"$f":"E31*(1-'Labour costs'!$I$14)","v":3170358.9882980594},{"$f":"F31*(1-'Labour costs'!$I$14)","v":3993399.9487422663},{"$f":"G31*(1-'Labour costs'!$I$14)","v":4710574.533401195},{"$f":"H31*(1-'Labour costs'!$I$14)","v":5206775.8389747124},{"$f":"I31*(1-'Labour costs'!$I$14)","v":5416882.1659923689},{"$f":"J31*(1-'Labour costs'!$I$14)","v":5282730.3327184068},{"$f":"K31*(1-'Labour costs'!$I$14)","v":4721192.8646232011},{"$f":"L31*(1-'Labour costs'!$I$14)","v":3920461.3806056879},{"$f":"M31*(1-'Labour costs'!$I$14)","v":3664097.729471439},{"$f":"N31*(1-'Labour costs'!$I$14)","v":3960008.8078333391},{"$f":"O31*(1-'Labour costs'!$I$14)","v":4207234.155473019},{"$f":"P31*(1-'Labour costs'!$I$14)","v":4354342.4492646288},{"$f":"Q31*(1-'Labour costs'!$I$14)","v":4394104.5889067594},{"$f":"R31*(1-'Labour costs'!$I$14)","v":4332213.527457905}]
[null,"Proactive failures - Materials",null,{"$f":"D38*(1-'Labour costs'!$D$14)","v":2015092.1080966741},{"$f":"E38*(1-'Labour costs'!$D$14)","v":2742290.3852489409},{"$f":"F38*(1-'Labour costs'!$D$14)","v":3454339.2160743643},{"$f":"G38*(1-'Labour costs'!$D$14)","v":4074626.7934449813},{"$f":"H38*(1-'Labour costs'!$D$14)","v":4503809.1786378715},{"$f":"I38*(1-'Labour costs'!$D$14)","v":4685639.4553152258},{"$f":"J38*(1-'Labour costs'!$D$14)","v":4569655.7961395252},{"$f":"K38*(1-'Labour costs'!$D$14)","v":4083803.0341277984},{"$f":"L38*(1-'Labour costs'!$D$14)","v":3391213.3862517974},{"$f":"M38*(1-'Labour costs'!$D$14)","v":3169441.806899582},{"$f":"N38*(1-'Labour costs'!$D$14)","v":3425492.5152094439},{"$f":"O38*(1-'Labour costs'!$D$14)","v":3639201.5033677211},{"$f":"P38*(1-'Labour costs'!$D$14)","v":3766572.4331725463},{"$f":"Q38*(1-'Labour costs'!$D$14)","v":3800859.6123698717},{"$f":"R38*(1-'Labour costs'!$D$14)","v":3747469.0557051171}]
[null,"Proactive faults - Labour",null,{"$f":"D31-D58","v":485276.66480593663},{"$f":"E31-E58","v":660399.90585312061},831843.00576604297,981233.66781320143,1084594.6110674106,1128360.6953164665,1100416.2706026873,983445.51352695562,816649.57697509183,763247.88596845092,824887.48230829649,876385.62397249881,907028.93715210352,915311.56803810224,902419.38412301987]
[null,"Proactive Faults - Materials",null,{"$f":"D38-D59","v":223899.12312185252},{"$f":"E38-E59","v":304698.93169432692},383815.46845270693,452736.3103827755,500423.2420708742,520626.6061461363,507739.53290439118,453755.89268086618,376801.48736131098,352160.20076662023,380610.27946771588,404355.72259641346,418508.04813028267,422317.73470776342,416385.45063390164]
[]
[null,"NPV"]
[]
[]
[null,"Proactive - Labour",null,{"$f":"NPV(Summary!$B$14,D56:R56)","v":47154991.673838168}]
[null,"Proactive - Materials",null,{"$f":"NPV(Summary!$B$14,D57:R57)","v":123365575.89340726}]
[null,"Proactive failures - Labour",null,{"$f":"NPV(Summary!$B$14,D58:R58)","v":48004459.241145715}]
[null,"Proactive failures - Materials",null,{"$f":"NPV(Summary!$B$14,D59:R59)","v":41523908.508640967}]
[null,"Proactive faults - Labour",null,{"$f":"NPV(Summary!$B$14,D60:R60)","v":9999542.7900741342}]
[null,"Proactive Faults - Materials",null,{"$f":"NPV(Summary!$B$14,D61:R61)","v":4613767.612071217}]
[null,"Total",null,{"$f":"SUM(D66:D71)","v":274662245.71917748}]

{"sheet":"Option 1","index":5,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Option 1 - Reactive"]
[]
[null,"Expenditure / benefits profile"]
[]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","2031-32","2032-33","2033-34","2034-35","2035-36","2036-37","2037-38","2038-39","2039-40","2040-41"]
[null,"Labour Costs","AMI 1Ph 1e",2239922.0706921774,3552344.417414011,5120289.8668985348,6863907.4495324092,8686966.5096277613,10480951.626940819,12131204.998949865,13525525.776044356,14562769.39671406,15170046.257927313,15310092.573864557,14982908.344525792,14227804.816489892,13119719.053547839,11719665.386327261]
[null,null,"AMI 1Ph 1e + c",50777.026831047529,80669.953917067454,116295.77112917339,155607.01770804889,196965.72504624084,237914.9402325695,275178.72605212854,306709.62174560165,330460.16655367223,343973.40756516071,347249.34478006698,339878.48604652786,322679.81566826982,297700.7944046093,265760.40655927296]
[null,null,"AMI 1Ph 2e + C",212935.91896890901,337831.02528721141,486886.16856544773,652320.99791821546,825536.17815638566,996294.40548337623,1153129.8996470149,1285395.8646988564,1384083.4732979084,1441821.8667106319,1455335.1077221204,1424213.7041805107,1352552.5776044354,1246903.6024237075,1113818.6530681395]
[null,null,"AMI 3Ph",646662.56091065006,1025740.6138582724,1478456.2639585109,1981992.2275866114,2508864.0494673015,3026920.1026747907,3503490.1856554542,3905904.0968556665,4205640.231744484,4380918.4559528241,4421367.2769239796,4326986.6946579497,4108666.7763392786,3788706.2309648832,3384736.595881165]
[null,null,"AMI 3Ph + C",24373.007508260267,38374.522459814034,55487.485178379757,74674.746408286766,94380.582266029116,113567.84349593613,131717.95547017251,146756.61967739693,158165.26148977407,164388.15702379798,165943.88090730394,162832.43314029198,154535.2390949268,142608.02265471432,127050.78381965458]
[null,null,"AMI 3Ph CT",32094.182996482101,50815.789744429989,73549.169366938149,98288.435426726428,124364.95911136814,150441.48279600983,173843.4912309447,193902.35560374602,208612.18947713365,217304.36403868088,219310.25047596102,214629.84878897405,203931.78779014669,187884.69629190562,167825.8319191043]
[null,null,"Percentage failure",0.01,1.6E-2,2.4E-2,3.2000000000000001E-2,0.04,4.8000000000000001E-2,5.6000000000000001E-2,6.3E-2,6.7000000000000004E-2,7.0000000000000007E-2,7.0999999999999994E-2,6.9000000000000006E-2,6.6000000000000003E-2,6.0999999999999999E-2,5.3999999999999999E-2]
[null,null,"Efficiency",{"$f":"VLOOKUP(D14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":1},{"$f":"VLOOKUP(E14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":1},{"$f":"VLOOKUP(F14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.99315525876460764},{"$f":"VLOOKUP(G14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.97946577629382303},{"$f":"VLOOKUP(H14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.96577629382303842},{"$f":"VLOOKUP(I14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.95208681135225381},{"$f":"VLOOKUP(J14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.93839732888146909},{"$f":"VLOOKUP(K14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.92641903171953255},{"$f":"VLOOKUP(L14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.91957429048414019},{"$f":"VLOOKUP(M14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.914440734557596},{"$f":"VLOOKUP(N14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.91272954924874794},{"$f":"VLOOKUP(O14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.91615191986644406},{"$f":"VLOOKUP(P14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.92128547579298836},{"$f":"VLOOKUP(Q14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.92984140233722878},{"$f":"VLOOKUP(R14,'Labour costs'!$B$81:$D$201,2,FALSE)","v":0.94181969949916522}]
[null,null,null,{"$f":"SUM(D8:D13)*D15","v":3206764.7679075263},{"$f":"SUM(E8:E13)*E15","v":5085776.3226808067},7280786.168547906,9625005.3524478488,12011435.100377358,14287100.761345379,16298615.243677523,17939358.165512733,19172876.332964562,19860237.665983945,20006391.380128779,19652786.653732277,18766742.693684224,17465696.809516225,15802658.676996179]
[null,"Material Costs","AMI 1Ph 1e",1654515.3131781074,2623934.2489616238,3782094.9681862989,5070015.6635267707,6416615.6953858081,7741740.2999622775,8960697.6513530947,9990610.7484959569,10756769.302112071,11205333.50859162,11308778.524516102,11067104.349885516,10509348.182152348,9690862.1789603978,8656714.4905223828]
[null,null,"AMI 1Ph 1e + c",50928.85903061289,80911.171201860809,116643.51584430695,156072.30993252338,197554.68704616776,238626.34755472653,276001.55861751502,307626.73720910528,331448.30030406942,345001.94827189378,348287.68111257849,340894.78222103789,323644.68480744323,298590.97189722233,266555.07670054649]
[null,null,"AMI 1Ph 2e + C",226109.65678196054,358731.66700984124,517008.4267572136,692678.23702627525,876609.74629313929,1057932.29798175,1224470.7567269248,1364919.6396895656,1469712.7690827434,1531023.2721716983,1545372.5388520919,1512325.7428608823,1436231.1468284917,1324045.9709635959,1182727.4354748705]
[null,null,"AMI 3Ph",599642.96045672253,951157.79934514617,1370955.9585101171,1837879.2260349588,2326441.5739291292,2806829.1581282197,3248747.2661151704,3621901.1853729226,3899843.1510056295,4062376.6880019186,4099884.4273087545,4012366.3689261372,3809920.7503597536,3513224.915073629,3138628.3904579217]
[null,null,"AMI 3Ph + C",23800.339725210895,37472.875312034172,54183.752140373734,72920.189796390827,92163.017659327292,110899.45531534437,128623.11255752271,143308.42855818474,154449.01311041112,160525.6955934437,162044.86621420184,159006.52497268555,150904.28166197546,139257.3069028297,124065.60069524827]
[null,null,"AMI 3Ph CT",31350.065853425665,49637.604267923976,71843.900914100494,96009.576676116107,121481.50518202446,146953.43368793282,169812.8567060557,189406.64786444674,203775.42804726685,212266.07088256962,214225.44999840873,209653.56539478415,199203.54344364227,183528.51051692944,163934.71935853839]
[null,null,null,{"$f":"SUM(D17:D22)","v":2586347.1950260401},{"$f":"SUM(E17:E22)","v":4101845.36609843},5912730.5223524114,7925575.2029930353,10030866.225495595,12102980.992630251,{"$f":"SUM(J17:J22)","v":14008353.202076282},15617773.38719018,16815997.963662192,17516527.183513142,17678593.488002136,17301351.334261041,16429252.589253655,15149509.854314603,13532625.713209508]
[]
[null,"EDPR total",{"$f":"SUM(D16:H16)+SUM(D23:H23)","v":67767132.223926961}]
[null,"10 year total",{"$f":"SUM(D16:M16)+SUM(D23:M23)","v":231386953.12248313}]
[]
[]
[null,"Capital costs"]
[]
[]
[null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","2031-32","2032-33","2033-34","2034-35","2035-36","2036-37","2037-38","2038-39","2039-40","2040-41"]
[null,null,null,{"$f":"D23+D16","v":5793111.9629335664},9187621.6887792367,13193516.690900318,17550580.555440884,{"$f":"H23+H16","v":22042301.325872954},26390081.75397563,30306968.445753805,33557131.552702911,35988874.296626754,37376764.849497087,37684984.868130915,36954137.987993315,35195995.282937877,32615206.663830828,29335284.390205689]
[]
[null,"Total NPV",null,{"$f":"NPV(Summary!$B$14,'Option 1'!D33:R33)","v":290505742.32548189}]
[]
[]
[null,"NPV Breakdown"]
[]
[]
[null,"Reactive failures - Labour",null,{"$f":"D16-D43","v":2653937.7147477409},4209018.9235616839,6025622.2093681814,7965712.0363643831,9940735.5787861608,11824090.099903792,13488831.524609536,14846720.186740875,15867587.204861157,16436451.557998527,16557409.246570282,16264763.85864272,15531468.574239815,14454715.213604681,13078374.901671369]
[null,"Reactive failures - Materials",null,{"$f":"D23-D44","v":2327712.475523436},3691660.8294885871,5321457.4701171704,7133017.682693732,9027779.6029460356,10892682.893367225,12607517.881868653,14055996.048471162,15134398.167295974,15764874.465161828,15910734.139201922,15571216.200834937,14786327.330328289,13634558.868883142,12179363.141888557]
[null,"Reactive faults - Labour",null,{"$f":"D16*'Labour costs'!$I$14","v":552827.05315978522},{"$f":"OFFSET(E16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":876757.39911912254},{"$f":"OFFSET(F16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":1255163.9591797248},{"$f":"OFFSET(G16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":1659293.3160834657},{"$f":"OFFSET(H16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":2070699.5215911982},{"$f":"OFFSET(I16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":2463010.661441586},{"$f":"OFFSET(J16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":2809783.7190679871},{"$f":"OFFSET(K16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":3092637.978771857},{"$f":"OFFSET(L16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":3305289.1281034057},{"$f":"OFFSET(M16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":3423786.1079854192},{"$f":"OFFSET(N16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":3448982.1335584978},{"$f":"OFFSET(O16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":3388022.7950895568},{"$f":"OFFSET(P16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":3235274.1194444099},{"$f":"OFFSET(Q16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":3010981.5959115447},{"$f":"OFFSET(R16, 0, 0, 1, 1)*'Labour costs'!$I$14","v":2724283.7753248112}]
[null,"Reactive Faults - Materials",null,{"$f":"D23*'Labour costs'!$D$14","v":258634.71950260401},{"$f":"E23*'Labour costs'!$D$14","v":410184.53660984302},{"$f":"F23*'Labour costs'!$D$14","v":591273.05223524116},{"$f":"G23*'Labour costs'!$D$14","v":792557.52029930358},{"$f":"H23*'Labour costs'!$D$14","v":1003086.6225495596},{"$f":"I23*'Labour costs'!$D$14","v":1210298.0992630252},{"$f":"J23*'Labour costs'!$D$14","v":1400835.3202076284},{"$f":"K23*'Labour costs'!$D$14","v":1561777.338719018},{"$f":"L23*'Labour costs'!$D$14","v":1681599.7963662194},{"$f":"M23*'Labour costs'!$D$14","v":1751652.7183513143},{"$f":"N23*'Labour costs'!$D$14","v":1767859.3488002138},{"$f":"O23*'Labour costs'!$D$14","v":1730135.1334261042},{"$f":"P23*'Labour costs'!$D$14","v":1642925.2589253655},{"$f":"Q23*'Labour costs'!$D$14","v":1514950.9854314604},{"$f":"R23*'Labour costs'!$D$14","v":1353262.571320951}]
[]
[null,"Reactive failures - Labour",null,{"$f":"NPV(Summary!$B$14,D41:R41)","v":129238247.73925896}]
[null,"Reactive failures - Materials",null,{"$f":"NPV(Summary!$B$14,D42:R42)","v":120911932.47288546}]
[null,"Reactive faults - Labour",null,{"$f":"NPV(Summary!$B$14,D43:R43)","v":26920902.949683525}]
[null,"Reactive Faults - Materials",null,{"$f":"NPV(Summary!$B$14,D44:R44)","v":13434659.16365394}]
[null,"Total",null,{"$f":"SUM(D46:D49)","v":290505742.32548189}]

{"sheet":"Unit rate buildup","index":6,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Information in this sheet has been deleted because it contains confidential pricing information"]

{"sheet":"Labour costs","index":7,"n_rows":201,"n_cols":11,"rows_kept":201,"cut":false,"hidden":false,"merged":[[37,7,37,8],[36,7,36,8],[52,7,52,8],[53,7,53,8],[70,7,92,11]]}
[]
[null,"Labour cost estimation"]
[]
[null,"Labour rates",2024,"2026-06-01",null,null,null,"Escallation factor to $2026"]
[null,"Specialist metering (Office hours)",175.90826169265964,{"$f":"$H$5*C5","v":199.02405199438837},null,null,null,{"$f":"1.025*1.025*1.025*1.025*1.025","v":1.1314082128906247}]
[null,"Specialist metering (After hours)",234.09907576364884,{"$f":"C6*$H$5","v":264.86161694909686}]
[null,"Faults (Linesman) rate",197.86936413283024,{"$f":"C7*$H$5","v":223.87102365932972}]
[]
[null,"Electrician charge out rates",126.74,{"$f":"C9*$H$5","v":143.39467690175778}]
[null,"Project manager",159.28,{"$f":"C10*$H$5","v":180.2107001492187}]
[]
[]
[null,"Assumptions",null,null,null,null,null,"Blended rates","Overall percentage"]
[null,"Percentage of failed meters will result in faults truck (i.e. hot water / heating complaints)",null,0.1,null,null,null,{"$f":"D14*(2*D7)","v":44.77420473186595},{"$f":"H14/H19","v":0.17239401489386924}]
[null,"Percentage of meters that have an antenna connected",null,0.05]
[null,"Percentage time increase for 3 phase tasks",null,0.8]
[null,"Percentage of jobs that require 2 person crews",null,0.15,null,null,null,{"$f":"D17*(2*D5)","v":59.707215598316509}]
[null,"Percentage refusals and double visits",null,0.03,null,null,null,{"$f":"D18*(2*D5)","v":11.941443119663301}]
[null,null,null,null,null,null,null,{"$f":"((1-(D14+D17+D18))*D5)+SUM(H14:H18)","v":259.72018088580541}]
[]
[null,"Replace on fail",null,null,null,null,null,"Proactive replacement"]
[null,"Meter replaced on remote fail, or events. Combination of fault trucks for hot water and overtime when faults get peaky.",null,null,null,null,null,"Meter replaced proactively, no triage and minimal travel time."]
[]
[null,"On site time - Single phase",null,null,null,null,null,"On site time - Single phase"]
[null,"Activity","Description","Time MOG (hour)","Time (minutes)",null,null,"Activity","Description","Time (hours)","Time (minutes)"]
[null,"Site arrival","Arrive at site. Find appropriate parking. ",0.1,{"$f":"D26*60","v":6},null,null,"Site arrival","Not significant in the context of a proactive replacement",0.05,{"$f":"J26*60","v":3}]
[null,"Customer Contact","Let the customer know that we are there to replace the meter, Locate meter. ",0.1,6,null,null,"Customer Contact","Let the customer know that we are there to replace the meter, Locate meter. ",0.1,{"$f":"J27*60","v":6}]
[null,"Complete JSEA","Job safety assessment must be carried out to ensure the site is safe to carry out work.",0.1,6,null,null,"Complete JSEA","Job safety assessment must be carried out to ensure the site is safe to carry out work.",0.1,{"$f":"J28*60","v":6}]
[null,"Triage issue","Is the meter working. If yes, why is it reported as faulty.",0.2,12]
[null,"Final meter read","Read the information out of the meter if it is not read remotely before removing",0.1,6]
[null,"Disconnect Supply","Disconnect supply from the site. Confirm that supply is isolated and safety VESI test.",0.1,6,null,null,"Disconnect Supply","Disconnect supply from the site. Confirm that supply is isolated.",0.1,{"$f":"J31*60","v":6}]
[null,"Replace meter","Remove cover, disconnect terminals, reconnect terminals with new meter. Replace terminal cover.",0.15,9,null,null,"Replace meter","Remove cover, disconnect terminals, reconnect terminals with new meter. Replace terminal cover.",0.15,9]
[null,"Antenna change","Some sites have antennas that need to be changed over",{"$f":"$D$15*0.2","v":1.0000000000000002E-2},{"$f":"D33*60","v":0.60000000000000009},null,null,"Antenna change","Some sites have antennas that need to be changed over",{"$f":"$D$15*0.2","v":1.0000000000000002E-2},0.60000000000000009]
[null,"Reconnect supply","Reconnect supply to site. Confirm that supply has returned to site.",0.1,{"$f":"D34*60","v":6},null,null,"Reconnect supply","Reconnect supply to site. Confirm that supply has returned to site.",0.1,6]
[null,"Complete NST test","Undertake NST test, need to find an indepenent earth etc.",0.1,6,null,null,"Complete NST test","Undertake NST test, need to find an indepenent earth etc.",0.1,6]
[null,"Seal Equipment / complete paperwork","Re-seal the meter. Close out job and pack up.",0.1,6,null,null,"Seal Equipment / complete paperwork","Re-seal the meter. Close out job and pack up.",0.1,6]
[null,"Time at site (hours)",null,{"$f":"SUM(D26:D36)","v":1.1600000000000001},{"$f":"SUM(E26:E36)","v":69.599999999999994},null,null,"Time at site (hours)",null,{"$f":"SUM(J26:J36)","v":0.80999999999999994},{"$f":"SUM(K26:K36)","v":48.6}]
[null,null,null,{"$f":"H19*D37","v":301.2754098275343},null,null,null,"Cost",null,{"$f":"J37*D9","v":116.1496882904238}]
[]
[null,"On site time  - Three phase",null,null,null,null,null,"On site time - Three phase"]
[null,"Activity","Description","Time MOG (hour)","Time MOG (minutes)",null,null,"Activity","Description","Time (hours)","Time (minutes)"]
[null,"Site arrival","Arrive at site. Find appropriate parking. ",{"$f":"D26","v":0.1},{"$f":"D42*60","v":6},null,null,"Site arrival","Not significant in the context of a proactive replacement",0.05,{"$f":"J42*60","v":3}]
[null,"Customer Contact","Let the customer know that we are there to replace the meter, Locate meter. ",{"$f":"D27","v":0.1},6,null,null,"Customer Contact","Let the customer know that we are there to replace the meter, Locate meter. ",{"$f":"D43","v":0.1},{"$f":"J43*60","v":6}]
[null,"Complete JSEA","Job safety assessment must be carried out to ensure the site is safe to carry out work.",0.1,6,null,null,"Complete JSEA","Job safety assessment must be carried out to ensure the site is safe to carry out work.",{"$f":"D44","v":0.1},{"$f":"J44*60","v":6}]
[null,"Triage issue","Is the meter working. If yes, why is it reported as faulty.",0.3,18]
[null,"Final meter read","Read the information out of the meter if it is not read remotely before removing",{"$f":"D30","v":0.1},6]
[null,"Disconnect Supply","Disconnect supply from the site. Confirm that supply is isolated and safety VESI test.",0.15,9,null,null,"Disconnect Supply","Disconnect supply from the site. Confirm that supply is isolated.",{"$f":"D47","v":0.15},{"$f":"J47*60","v":9}]
[null,"Replace meter","Remove cover, disconnect terminals, reconnect terminals with new meter. Replace terminal cover.",{"$f":"D32*($D$16+1)","v":0.27},16.200000000000003,null,null,"Replace meter","Remove cover, disconnect terminals, reconnect terminals with new meter. Replace terminal cover.",{"$f":"D48","v":0.27},{"$f":"J48*60","v":16.200000000000003}]
[null,"Antenna change","Some sites have antennas that need to be changed over",{"$f":"D33","v":1.0000000000000002E-2},0.60000000000000009,null,null,"Antenna change","Some sites have antennas that need to be changed over",{"$f":"J33","v":1.0000000000000002E-2},{"$f":"K33","v":0.60000000000000009}]
[null,"Reconnect supply","Reconnect supply to site. Confirm that supply has returned to site.",0.15,9,null,null,"Reconnect supply","Reconnect supply to site. Confirm that supply has returned to site.",{"$f":"D50","v":0.15},{"$f":"J50*60","v":9}]
[null,"Complete NST test","Undertake NST test, need to find an indepenent earth etc.",0.2,12,null,null,"Complete NST test","Undertake NST test, need to find an indepenent earth etc.",{"$f":"D51","v":0.2},{"$f":"J51*60","v":12}]
[null,"Seal Equipment / complete paperwork","Re-seal the meter. Close out job and pack up.",0.1,6,null,null,"Seal Equipment / complete paperwork","Re-seal the meter. Close out job and pack up.",{"$f":"D52","v":0.1},{"$f":"J52*60","v":6}]
[null,"Time at site (hours)",null,{"$f":"SUM(D42:D52)","v":1.58},{"$f":"SUM(E42:E52)","v":94.8},null,null,"Time at site (hours)",null,{"$f":"SUM(J42:J52)","v":1.1300000000000001},{"$f":"SUM(K42:K52)","v":67.800000000000011}]
[null,null,null,{"$f":"D53*H19","v":410.35788579957256},null,null,null,"Cost",null,{"$f":"J53*D9","v":162.0359848989863}]
[]
[]
[null,"Travel time",null,null,null,null,null,"Travel time"]
[null,"Average travel time per meter",null,null,null,null,null,"Average travel time per meter"]
[null,"DB","Average cost","Time MOG (hour)","Time MOG (minutes)",null,null,"DB","Average cost","Time (hours)","Time (minutes)"]
[null,"United Energy",108.21674203575226,0.41666666666666669,25,null,null,"United Energy",{"$f":"J60*D9","v":16.729378971871739},{"$f":"K60/60","v":0.11666666666666667},7]
[]
[]
[null,null,null,"United Energy"]
[null,"Base rate",null,{"$f":"($D$60+$D$37)*D5","v":313.79458864448571}]
[null,"Faults rate",null,{"$f":"($D$60+$D$37)*D7*2","v":705.93996127241985}]
[]
[]
[null,"Replacement efficiency scale"]
[]
[null,"Assumptions",null,null,null,null,null,"Notes"]
[null,null,null,null,null,null,null,"Reduction in travel time is not likely to be significant if the crew needs to go back to a depot. The assumptions:\n - Travel time reduction is likely to reduce by around 25% in rural areas\n - Minimal reduction in urban area\n\nAs the failure rate increases we would move to replace on fail for most meters resulting in the removal to triage"]
[null,"Resulting reduction in travel time",0.1]
[null,"Move from triage to replace on fail",{"$f":"D45/D53","v":0.18987341772151897}]
[null,"Percentage rural (Powercor)",0.3]
[null,"Percentage of meter >10 years old",0.8]
[]
[null,"Resultant efficiency @12%",{"$f":"((E53*(1-C73))+((1-C72)*E60))/(E60+E53)","v":0.828881469115192}]
[]
[]
[null,"Efficiency scale (Failure rate >2%)","United Energy"]
[null,0,1]
[null,{"$f":"ROUND(B81+0.001,3)","v":1E-3},1]
[null,2E-3,1]
[null,3.0000000000000001E-3,1]
[null,4.0000000000000001E-3,1]
[null,5.0000000000000001E-3,1]
[null,6.0000000000000001E-3,1]
[null,7.0000000000000001E-3,1]
[null,8.0000000000000002E-3,1]
[null,8.9999999999999993E-3,1]
[null,0.01,1]
[null,1.0999999999999999E-2,1]
[null,1.2E-2,1]
[null,1.2999999999999999E-2,1]
[null,1.4E-2,1]
[null,1.4999999999999999E-2,1]
[null,1.6E-2,1]
[null,1.7000000000000001E-2,1]
[null,1.7999999999999999E-2,1]
[null,1.9E-2,1]
[null,0.02,1]
[null,2.1000000000000001E-2,{"$f":"1-(((100/10)*(B102-0.02))*(1-$C$77))","v":0.99828881469115194}]
[null,2.1999999999999999E-2,0.99657762938230388]
[null,2.3E-2,0.99486644407345581]
[null,2.4E-2,0.99315525876460764]
[null,2.5000000000000001E-2,0.99144407345575958]
[null,2.5999999999999999E-2,0.98973288814691152]
[null,2.7E-2,0.98802170283806345]
[null,2.8000000000000001E-2,0.98631051752921539]
[null,2.9000000000000001E-2,0.98459933222036733]
[null,0.03,0.98288814691151916]
[null,3.1E-2,0.98117696160267109]
[null,3.2000000000000001E-2,0.97946577629382303]
[null,{"$f":"ROUND(B113+0.001,3)","v":3.3000000000000002E-2},0.97775459098497497]
[null,3.4000000000000002E-2,0.97604340567612691]
[null,3.5000000000000003E-2,0.97433222036727885]
[null,3.5999999999999997E-2,0.97262103505843067]
[null,3.6999999999999998E-2,0.97090984974958261]
[null,3.7999999999999999E-2,0.96919866444073455]
[null,3.9E-2,0.96748747913188649]
[null,0.04,0.96577629382303842]
[null,4.1000000000000002E-2,0.96406510851419036]
[null,4.2000000000000003E-2,0.96235392320534219]
[null,4.2999999999999997E-2,0.96064273789649413]
[null,4.3999999999999997E-2,0.95893155258764606]
[null,4.4999999999999998E-2,0.957220367278798]
[null,4.5999999999999999E-2,0.95550918196994994]
[null,4.7E-2,0.95379799666110188]
[null,4.8000000000000001E-2,0.95208681135225381]
[null,4.9000000000000002E-2,0.95037562604340564]
[null,0.05,0.94866444073455758]
[null,5.0999999999999997E-2,0.94695325542570952]
[null,5.1999999999999998E-2,0.94524207011686145]
[null,5.2999999999999999E-2,{"$f":"1-(((100/10)*(B134-0.02))*(1-$C$77))","v":0.94353088480801339}]
[null,5.3999999999999999E-2,0.94181969949916522]
[null,5.5E-2,0.94010851419031716]
[null,5.6000000000000001E-2,0.93839732888146909]
[null,5.7000000000000002E-2,0.93668614357262103]
[null,5.8000000000000003E-2,0.93497495826377297]
[null,5.8999999999999997E-2,0.93326377295492491]
[null,0.06,0.93155258764607685]
[null,6.0999999999999999E-2,0.92984140233722878]
[null,6.2E-2,0.92813021702838061]
[null,6.3E-2,0.92641903171953255]
[null,6.4000000000000001E-2,0.92470784641068449]
[null,{"$f":"ROUND(B145+0.001,3)","v":6.5000000000000002E-2},0.92299666110183642]
[null,6.6000000000000003E-2,0.92128547579298836]
[null,6.7000000000000004E-2,0.91957429048414019]
[null,6.8000000000000005E-2,0.91786310517529213]
[null,6.9000000000000006E-2,0.91615191986644406]
[null,7.0000000000000007E-2,0.914440734557596]
[null,7.0999999999999994E-2,0.91272954924874794]
[null,7.1999999999999995E-2,0.91101836393989988]
[null,7.2999999999999995E-2,0.90930717863105182]
[null,7.3999999999999996E-2,0.90759599332220375]
[null,7.4999999999999997E-2,0.90588480801335558]
[null,7.5999999999999998E-2,0.90417362270450752]
[null,7.6999999999999999E-2,0.90246243739565946]
[null,7.8E-2,0.90075125208681139]
[null,7.9000000000000001E-2,0.89904006677796333]
[null,0.08,0.89732888146911516]
[null,8.1000000000000003E-2,0.8956176961602671]
[null,8.2000000000000003E-2,0.89390651085141903]
[null,8.3000000000000004E-2,0.89219532554257097]
[null,8.4000000000000005E-2,0.89048414023372291]
[null,8.5000000000000006E-2,{"$f":"1-(((100/10)*(B166-0.02))*(1-$C$77))","v":0.88877295492487485}]
[null,8.5999999999999993E-2,0.88706176961602679]
[null,8.6999999999999994E-2,0.88535058430717861]
[null,8.7999999999999995E-2,0.88363939899833055]
[null,8.8999999999999996E-2,0.88192821368948249]
[null,0.09,0.88021702838063443]
[null,9.0999999999999998E-2,0.87850584307178636]
[null,9.1999999999999998E-2,0.87679465776293819]
[null,9.2999999999999999E-2,0.87508347245409013]
[null,9.4E-2,0.87337228714524207]
[null,9.5000000000000001E-2,0.871661101836394]
[null,9.6000000000000002E-2,0.86994991652754594]
[null,{"$f":"ROUND(B177+0.001,3)","v":9.7000000000000003E-2},0.86823873121869788]
[null,9.8000000000000004E-2,0.86652754590984982]
[null,9.9000000000000005E-2,0.86481636060100164]
[null,0.1,0.86310517529215358]
[null,0.10100000000000001,0.86139398998330552]
[null,0.10199999999999999,0.85968280467445746]
[null,0.10299999999999999,0.85797161936560939]
[null,0.104,0.85626043405676133]
[null,0.105,0.85454924874791316]
[null,0.106,0.8528380634390651]
[null,0.107,0.85112687813021703]
[null,0.108,0.84941569282136897]
[null,0.109,0.84770450751252091]
[null,0.11,0.84599332220367285]
[null,0.111,0.84428213689482479]
[null,0.112,0.84257095158597672]
[null,0.113,0.84085976627712855]
[null,0.114,0.83914858096828049]
[null,0.115,0.83743739565943243]
[null,0.11600000000000001,0.83572621035058436]
[null,0.11700000000000001,{"$f":"1-(((100/10)*(B198-0.02))*(1-$C$77))","v":0.83401502504173619}]
[null,0.11799999999999999,0.83230383973288813]
[null,0.11899999999999999,0.83059265442404007]
[null,0.12,0.828881469115192]

{"sheet":"Replacement program breakdown","index":8,"n_rows":215,"n_cols":15,"rows_kept":215,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Program level costs"]
[]
[null,"Assumptions"]
[null,"Working days per year",251]
[null,"Project duration (days)",{"$f":"C5*5","v":1255}]
[null,"Labour rate - Project management (daily)",900]
[null,"Labour rate - SME metering (daily)",1200]
[]
[]
[null,"Project element (Activity","Category","Scope","Time FTE","Duration","Cost","Notes",null,"2026-27","2027-28","2028-29","2029-30","2030-31"]
[null,null,null,null,null,null,null,null,null,0.2,0.4,0.6,0.8,1]
[null,"1.0 ProgramManagement ","High level category"]
[null,"1.1 Industry Planning & Liaison","Program management","Partially in scope",0.2,1,{"$f":"F14*E14*$C$7*$C$6","v":225900},"There will be a some industry communications etc",null,{"$f":"IF($F14>=$J$12,1,$F14*5)*$C$5*$C$7*$E14","v":45180},{"$f":"IF($F14>=K$12,1,IF((($F14-K$12)>=0),($F14-K$12)*5,0))*$C$5*$C$7*$E14","v":45180},{"$f":"IF($F14>=L$12,1,IF((($F14-L$12)>=0),($F14-L$12)*5,0))*$C$5*$C$7*$E14","v":45180},{"$f":"IF($F14>=M$12,1,IF((($F14-M$12)>=0),($F14-M$12)*5,0))*$C$5*$C$7*$E14","v":45180},{"$f":"IF($F14>=N$12,1,IF((($F14-N$12)>=0),($F14-N$12)*5,0))*$C$5*$C$7*$E14","v":45180}]
[null,"1.2 PMO: ProgramEstablishment ","Program management","In scope",2,0.2,{"$f":"F15*E15*$C$7*$C$6","v":451800},"Establish the PMO in the first year",null,451800,{"$f":"IF($F15>=K$12,1,IF((($F15-K$12)>=0),($F15-K$12)*5,0))*$C$5*$C$7*$E15","v":0},0,0,0]
[null,"1.3 PMO: ProgramOperation Mode ","Program management","In scope",1,0.8,{"$f":"F16*E16*$C$7*$C$6","v":903600},null,null,225900,225900,225900,225900,0]
[null,"1.4 PMO: ProgramClose-Down","Program management","Out of scope",null,null,null,"Will not close down until next EDPR",null,0,0,0,0,0]
[null,"1.5 ProgramManagement Tools ","Program management","In scope",0,0.2,{"$f":"F18*E18*$C$7*$C$6","v":0},"Should already have tools, no cost",null,0,0,0,0,0]
[null,"1.6 Commercial & Procurement ","Procurement","In scope",0.5,0.2,{"$f":"F19*E19*$C$7*$C$6","v":112950},"Only in the first year",null,112950,0,0,0,0]
[null,"1.7 Management of the AMI Program","Program management","In scope",1,1,{"$f":"F20*E20*$C$7*$C$6","v":1129500},"PMO manager",null,225900,225900,225900,225900,225900]
[null,"1.8 AMI ProgramFinance Reporting ","Program management","In scope",0.3,1,{"$f":"F21*E21*$C$7*$C$6","v":338850},null,null,67770,67770,67770,67770,67770]
[null,"1.9 AMI Collaboration Sites (Sharepoint) ","Program management","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"1.10 Reporting Metering ProcessPerformance ","Program management","In scope",0,1,{"$f":"F23*E23*$C$7*$C$6","v":0},"Should already have tools",null,0,0,0,0,0]
[null,"1.11 AMI Field Deployment Reporting ","Program management","In scope",0.1,1,{"$f":"F24*E24*$C$7*$C$6","v":112950},null,null,22590,22590,22590,22590,22590]
[null,"1.12 Meter SupplyContract Review ","Procurement","In scope",0,1,{"$f":"F25*E25*$C$7*$C$6","v":0},"Covered above",null,0,0,0,0,0]
[null,"1.13 Gateway Review","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"1.14 HAN Pilot ","Out of scope","Out of scope",null,null,null,"Possibly if we move to WiFi etc",null,0,0,0,0,0]
[null,"1.15 Remote Configuration of Meters ","AMI operations","In scope",0.1,1,112950,null,null,22590,22590,22590,22590,22590]
[null,"1.16 Implement Reporting ","Program management","In scope",0.1,1,112950,null,null,22590,22590,22590,22590,22590]
[null,"1.18 CIS to UIQ Automation for BAU Process ","Out of scope","Out of scope",null,null,null,"Already done",null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"2.0 Technology ",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"2.1 RFP ","Procurement","In scope",0.5,0.2,{"$f":"F33*E33*$C$7*$C$6","v":112950},"If we are doing a mass rollout there will need to be best pricing etc",null,112950,0,0,0,0]
[null,"2.2 DPI Trials ","AMI technology","Partially in scope",1,0.1,{"$f":"F34*E34*$C$7*$C$6","v":112950},"Half a year of testing",null,112950,0,0,0,0]
[null,"2.3 Establish Backhaul ","Out of scope","Out of scope",null,null,null,"Possibly augmentation not rollout",null,0,0,0,0,0]
[null,"2.4 Technology Acceptance ","AMI technology","In scope",2,1,{"$f":"F36*E36*$C$8*$C$6","v":3012000},"Needed for the DI meters",null,451800,451800,451800,451800,451800]
[null,"2.5 Pilot & Roll-out Preparation ",null,"In scope",1,0.2,225900,null,null,225900,0,0,0,0]
[null,"2.6 Establish Test Lab ",null,"In scope",null,null,200000,"DI Test lab for new meters and issues",null,{"$f":"G38","v":200000},0,0,0,0]
[null,"2.7 Establish Asset Mgmt System ",null,"Partially in scope",0,1,300000,"Would be good to update asset management systems",null,{"$f":"IF($F39>=$J$12,1,$F39*5)*$C$5*$C$7*$E39","v":0},0,0,0,0]
[null,"2.8 Establish Security Systems ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.9 NMS Implementation ","Out of scope","Out of scope",null,null,null,null,null,0,{"$f":"IF($F41>=K$12,1,IF((($F41-K$12)>=0),($F41-K$12)*5,0))*$C$5*$C$7*$E41","v":0},0,0,0]
[null,"2.11 Establish ACC ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.12 AMI Meter Solutions ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.13 NMS Integration ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.14 DCI Sentry ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.15 Develop HomeArea Network (HAN) Capability ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.19 BAU & Support (Pre-deploy) ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.20 AMI Generation 2 Scoping ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.21 UIQ Upgrade ",null,"In scope",null,null,null,"Captured separately",null,0,0,0,0,0]
[null,"2.31 AMI Operate Centre Setup ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.32 TAG Automation ","AMI technology","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"2.33 Information Security Management System (ISMS) ",null,"Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"3.0 Business Transformation",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"3.1 Transformation Strategy ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"3.2 OpportunityDevelopment ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"3.3 Scope & Structure ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"3.4 Process Architecture Management","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"3.5 OrganisationalChange Management ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"3.7 ImplementationManagement ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"3.8 Resource Management ",null,"In scope",0.1,1,{"$f":"F61*E61*$C$7*$C$6","v":112950},null,null,22590,22590,22590,22590,22590]
[null,"3.9 Performance Management ",null,"In scope",0.1,1,{"$f":"F62*E62*$C$7*$C$6","v":112950},null,null,22590,22590,22590,22590,22590]
[null,"3.10 Network Impact Assessment ",null,"In scope",0,1,0,null,null,0,0,0,0,0]
[null,"3.11 Continual Improvement ",null,"In scope",0,1,0,null,null,0,0,0,0,0]
[null,"3.12 Scope Assessment – Vic. AMI Program Ph2(Active 2012) ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"3.13 AMI Operating Model Implementation ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"3.14 Transition Planning & Implementation",null,"Partially in scope",0.1,1,112950,null,null,22590,22590,22590,22590,22590]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"4.0 Information Technology",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"4.1 IT ProgramManagement ",null,"Partially in scope",0.5,1,{"$f":"F70*E70*$C$7*$C$6","v":564750},null,null,112950,112950,112950,112950,112950]
[null,"4.2 MCR A and Faults Management Mobility ",null,"In scope",null,null,0,"Mobility solutions for field crew - will need to provide ipads etc as well as mobility",null,{"$f":"G71","v":0},0,0,0,0]
[null,"4.4 Interval Meter Billing (IMB) ","Out of scope","Out of scope",null,null,null,null,null,{"$f":"IF($F72>=$J$12,1,$F72*5)*$C$5*$C$7*$E72","v":0},0,0,0,0]
[null,"4.5 MMS & Scaling ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.6 Systems Integration(USB) Establishment ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.7 Infrastructure Development ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.8 AMI Reporting ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.9 Systems Integration ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.10 Type 6 Meter DataTime Reference ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.11 Infrastructure Production ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.12 Infrastr’ctr Disaster Recovery ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.13 Infrastructure Growth 2010 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.14 Oracle Fusion 11g Technical Upgrade ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.15 Field Systems Enhancement ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.16 AMI Oracle 11G Migration ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.17 IEE / MTS Upgrade ","Out of scope","Out of scope",null,null,null,"Assume we would not need an upgrade as the meter data should not change",null,0,0,0,0,0]
[null,"4.18 Infrastructure Growth 2011 Implementation ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.19 Infrastructure Growth 2012 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.20 NMS Hardware Entity Name Upgrade to 1.2M meters WBS # ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.26 Data Warehouse/Analytics Tool ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.27 MobilityConnections ","In scope","In scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.31 AMI IT Security ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.35 IEE License Growth ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.37 Service Suite Upgrade ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.38 Rollout Decomm Project ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.39 Infrastructure Growth 2013 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.40 Infrastructure Growth 2014 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.41 Infrastructure Growth 2015 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.42 Infrastructure Growth 2016 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.44 IDAM Technical Upgrade ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"4.45 Faults MobilityRefinements ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"5.0 Field Implementation",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"5.1 Field Implementation Project Scoping ",null,"In scope",1,0.2,{"$f":"F103*E103*$C$7*$C$6","v":225900},null,null,225900,0,0,0,0]
[null,"5.2 DeploymentPlanning ",null,"In scope",0.5,1,{"$f":"F104*E104*$C$7*$C$6","v":564750},null,null,{"$f":"IF($F104>=$J$12,1,$F104*5)*$C$5*$C$7*$E104","v":112950},112950,112950,112950,{"$f":"IF($F104>=N$12,1,IF((($F104-N$12)>=0),($F104-N$12)*5,0))*$C$5*$C$7*$E104","v":112950}]
[null,"5.3 EnablingTechnology ",null,"In scope",0.1,1,112950,null,null,22590,22590,22590,22590,22590]
[null,"5.4 Resource Mobilisation ",null,"In scope",1,1,1129500,null,null,225900,225900,225900,225900,225900]
[null,"5.5 OrganisationalChange Management ",null,"In scope",0,1,0,null,null,0,0,0,0,0]
[null,"5.6 QualityManagement ",null,"In scope",2,1,2259000,"Auditing",null,451800,451800,451800,451800,451800]
[null,"5.7 Management & Planning ",null,"In scope",0,1,0,null,null,0,0,0,0,0]
[null,"5.8 Meter Installation Contract Review ",null,"In scope",0,1,0,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"7.0 Regulation ",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"7.1 Tariff Optimisation ","Out of scope","Out of scope",null,null,null,"Should not need any changes in tariffs etc.",null,0,0,0,0,0]
[null,"7.2 Price Review Process","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"7.3 Accruals ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"7.4 Tariff Revenue ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"7.5 Price Review 2016-2020","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"7.6 Transitional Feed In Tariff (TFIT) ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"7.7 Monthly Billing ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"7.8 Flexible Pricing ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"8.0 Customer Management ",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"8.1 AMI Customer Strategy & RetailerManagement",null,"Partially in scope",0.3,1,{"$f":"F123*E123*$C$7*$C$6","v":338850},null,null,67770,67770,67770,67770,67770]
[null,"8.2 Customer Interaction & Treatment Pre-deployment  ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.3 Customer Self-Service ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.4 Customer Response Plan to support the AMI rollout Pre-deployment ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.5 Revenue Management Pre-deployment ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.6 Customer Energy Data Access (CEDA) Trial ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.7 Meter Event Analysis for Revenue Protection ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.8 Network Analysis for Revenue Protection ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.10 CEDA Implementation ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.12 Customer & Community Engagement & Education ",null,"Partially in scope",0.3,1,{"$f":"F132*E132*$C$7*$C$6","v":338850},"No doubt a rollout will cause more complaints",null,67770,67770,67770,67770,67770]
[null,"8.13 TCE to reference UIQ ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"8.14 Customer Portal Refinements ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"10.0 Meter Strategy ",null,null,null,null,null,null,null,{"$f":"IF($F136>=$J$12,1,$F136*5)*$C$5*$C$7*$E136","v":0},0,0,0,0]
[null,"10.1 Meter Strategies ",null,"Partially in scope",0,1,{"$f":"F137*E137*$C$7*$C$6","v":0},null,null,0,0,0,0,0]
[null,"10.2 Meter Provisioning Policy & Stds -Release 1 / 1A ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"10.3 Meter Provision Policy & Stds -Release 2 & 3 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"10.4 GIS ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"10.5 Asset Management ",null,"Partially in scope",1,1,{"$f":"F141*E141*$C$7*$C$6","v":1129500},null,null,225900,225900,225900,225900,225900]
[null,"10.6 BAU Transition ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"10.7 BAU & Support (Technical) ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"11.0 Meter Data Management ",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"11.1 AMI Address Cleansing ",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"11.2 AMI Control of Customer Keys & Access Devices ",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"11.4 GIS Information Mgmt & Program Report ",null,"Partially in scope",0.5,1,{"$f":"F149*E149*$C$7*$C$6","v":564750},null,null,112950,112950,112950,112950,112950]
[null,"11.5 CSG Information Mgmt & Program Reporting ",null,"Partially in scope",0.5,1,564750,null,null,112950,112950,112950,112950,112950]
[null,"11.6 AMI Meter Data Provider Accreditation ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"11.7 AMI Meter Data Transition ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"11.9 Type 5 to Market ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"11.10 AMI Remote Connect and Disconnect ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"11.11 AMI Tariff Implementation (inc. Re-assignment) Build Capability ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"12.0 AMI Deployment ",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"12.1 Program DeploymentPlanning & Management ",null,"In scope",2,1,{"$f":"F158*E158*$C$7*$C$6","v":2259000},null,null,451800,451800,451800,451800,451800]
[null,"12.2 TechnologyManagement ",null,"Partially in scope",0.5,1,564750,null,null,112950,112950,112950,112950,112950]
[null,"12.3 Field Management & Training ",null,"In scope",1,1,1129500,null,null,225900,225900,225900,225900,225900]
[null,"12.4 Customer Interaction & Treatment Deployment ",null,"In scope",0.1,1,112950,null,null,22590,22590,22590,22590,22590]
[null,"12.5 Data Management ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"12.6 BAU Metering ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"12.7 Customer Response Plan to Support AMI Rollout Deployment ",null,"In scope",1,1,{"$f":"F164*E164*$C$7*$C$6","v":1129500},null,null,225900,225900,225900,225900,225900]
[null,"12.8 Revenue Management Deployment ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"12.11 – 12.20 Region 1 to Region 10 Region ",null,"In scope",0,1,{"$f":"F166*E166*$C$7*$C$6","v":0},null,null,0,0,0,0,0]
[null,"12.21 AMI Meters in WIP 2011 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"12.22 AMI Meters in WIP 2012 ","Out of scope","Out of scope",null,null,null,null,null,{"$f":"IF($F168>=$J$12,1,$F168*5)*$C$5*$C$7*$E168","v":0},{"$f":"IF($F168>=K$12,1,IF((($F168-K$12)>=0),($F168-K$12)*5,0))*$C$5*$C$7*$E168","v":0},0,0,0]
[null,"12.23 AMI Meters in Work In Progress 2013 ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"13.0 Operate ",null,null,null,null,null,null,null,0,0,0,0,0]
[null,"13.1 Meter Strategy & Provider ",null,"In scope",0,1,{"$f":"F172*E172*$C$7*$C$6","v":0},null,null,0,0,0,0,0]
[null,"13.2 AMI Technology ",null,"In scope",1,1,1129500,null,null,225900,225900,225900,225900,225900]
[null,"13.3 IT ",null,"Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"13.4 Data Management BAU ",null,"Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"13.5 AMI Enhancements ",null,"In scope",0,1,{"$f":"F176*E176*$C$7*$C$6","v":0},null,null,0,0,0,0,0]
[null,"13.6 AMI Communications Control ",null,"In scope",1,1,1129500,null,null,225900,225900,225900,225900,225900]
[null,"13.7 TechnologyAssurance ",null,"In scope",1,1,1129500,null,null,225900,225900,225900,225900,225900]
[null,"13.8 HAN Support ","Out of scope","Out of scope",null,null,null,null,null,0,0,0,0,0]
[null,"13.9 OperationsManagement & Support ",null,"In scope",0.5,1,{"$f":"F180*E180*$C$7*$C$6","v":564750},null,null,112950,112950,112950,112950,112950]
[null,"13.10 Data Management Operations ",null,"In scope",1,1,1129500,null,null,225900,225900,225900,225900,225900]
[null,"13.11 AMI Corporate ","Out of scope","Out of scope"]
[null,"13.12 Price Review 2016 -2026 ","Out of scope","Out of scope"]
[]
[null,"14.0 Non-recoverable project (CAPEX) "]
[null,"14.1 Generation 2 Communications","Out of scope","Out of scope"]
[null,"14.2 Customer Initiated Meter Replacement (Solar) ","Out of scope","Out of scope"]
[null,"14.3 Customer Initiated Meter Replacement (Other) ","Out of scope","Out of scope"]
[null,"14.4 New Connections Installations ","Out of scope","Out of scope"]
[null,"14.5 Servicing (NewConnections & Replacements) ","Out of scope","Out of scope"]
[]
[null,"15.0 Non-recoverable project (OPEX) "]
[null,"15.2 PV Installations ","Out of scope","Out of scope"]
[null,"15.3 Meter Maintenance (ACS) ","Out of scope","Out of scope"]
[null,"15.4 Meter Maintenance (Abolishment) ","Out of scope","Out of scope"]
[null,"15.5 Special Reading ","Out of scope","Out of scope"]
[null,"15.6 Other Connections (Function Code 800) ","Out of scope","Out of scope"]
[null,"15.1 Victorian Energy Efficiency Target (VEET) ","Out of scope","Out of scope"]
[null,"15.6 Other Connections (Function Code 800) ","Out of scope","Out of scope"]
[null,null,null,null,null,null,null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","Total"]
[null,null,null,null,null,null,{"$f":"SUM(G14:G199)*0.5","v":12938050},null,null,{"$f":"SUM(J14:J200)","v":6163760},{"$f":"SUM(K14:K200)","v":4721310},4721310,4721310,4495410,{"$f":"SUM(J201:N201)","v":24823100}]
[]
[]
[null,null,null,null,null,null,null,null,null,"2026-27","2027-28","2028-29","2029-30","2030-31","Total"]
[null,"Powercor",989079.36788586481,{"$f":"C205/$C$208","v":0.48053053693441494},null,null,null,null,"Powercor",{"$f":"J$201*$D205","v":2961874.9023348694},{"$f":"K$201*$D205","v":2268733.6293338225},2268733.6293338225,2268733.6293338225,2160181.7810403383,{"$f":"SUM(J205:N205)","v":11928257.571376676}]
[null,"Citipower",343734.63211413531,{"$f":"C206/$C$208","v":0.16699871890545739},null,null,null,null,"Citipower",{"$f":"J$201*$D206","v":1029340.023640702},{"$f":"K$201*$D206","v":788452.72155552509},788452.72155552509,788452.72155552509,750727.7109547822,{"$f":"SUM(J206:N206)","v":4145425.899262059}]
[null,"UE",725493,0.35247074416012769,null,null,null,null,"UE",2172545.0740244286,1664123.6491106525,1664123.6491106525,1664123.6491106525,1584500.5080048796,8749416.5293612666]
[null,null,{"$f":"SUM(C205:C207)","v":2058307},null,null,null,null,null,"Total",{"$f":"SUM(J205:J207)","v":6163760},{"$f":"SUM(K205:K207)","v":4721310},4721310,4721310,4495410,24823100]
[]
[]
[null,null,null,null,null,null,null,null,"$'2026","2026-27","2027-28","2028-29","2029-30","2030-31","Total"]
[null,null,null,null,null,null,null,null,"Powercor",3174346.3998983162,2431482.3123416649,2431482.3123416649,2431482.3123416649,2315143.4439276741,{"$f":"SUM(J212:N212)","v":12783936.780850984}]
[null,null,null,null,null,null,null,null,"Citipower",1103180.2142481646,845012.74960061105,845012.74960061105,845012.74960061105,804581.51812637562,{"$f":"SUM(J213:N213)","v":4442799.9811763735}]
[null,null,null,null,null,null,null,null,"UE",2328393.6203960995,1783500.348837537,1783500.348837537,1783500.348837537,1698165.4051477818,9377060.0720564928]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J212:J214)","v":6605920.2345425803},{"$f":"SUM(K212:K214)","v":5059995.4107798133},{"$f":"SUM(L212:L214)","v":5059995.4107798133},5059995.4107798133,4817890.3672018312,26603796.834083848]