{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Output","CP","CP2","Input"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"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":"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,"AER draft decision"]
["CitiPower",null,null,null,null,null,"RRP change"]
["Output"]
["Forecast, June $2021 '000 (no escalation)"]
[null,"Check OK:",{"$f":"SUM(AH10:AH14)=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,{"$f":"CP!F$9","v":"Labour"},{"$f":"CP!G$9","v":"Materials"},{"$f":"CP!H$9","v":"Contracts"},{"$f":"CP!I$9","v":"Labour"},{"$f":"CP!J$9","v":"Materials"},{"$f":"CP!K$9","v":"Contracts"},{"$f":"CP!L$9","v":"Labour"},{"$f":"CP!M$9","v":"Materials"},{"$f":"CP!N$9","v":"Contracts"},{"$f":"CP!O$9","v":"Labour"},{"$f":"CP!P$9","v":"Materials"},{"$f":"CP!Q$9","v":"Contracts"},{"$f":"CP!R$9","v":"Labour"},{"$f":"CP!S$9","v":"Materials"},{"$f":"CP!T$9","v":"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":"CP!F19","v":13330.827669176422},{"$f":"CP!G19","v":4705.4126655999353},{"$f":"CP!H19","v":3639.7112628424047},{"$f":"CP!I19","v":12548.899864152219},{"$f":"CP!J19","v":4398.4011379651229},{"$f":"CP!K19","v":3239.7283166354264},{"$f":"CP!L19","v":9749.0204283281801},{"$f":"CP!M19","v":4940.8849376700164},{"$f":"CP!N19","v":5207.5286057685535},{"$f":"CP!O19","v":5457.4704328212638},{"$f":"CP!P19","v":4260.4318172908215},{"$f":"CP!Q19","v":3795.5881035592811},{"$f":"CP!R19","v":3694.4724914605654},{"$f":"CP!S19","v":3007.3500562558315},{"$f":"CP!T19","v":1203.331729155359},null,{"$f":"SUMIF($F$8:$T$8,V$9,$F10:$T10)","v":21675.951597618761},20187.029318752771,19897.43397176675,13513.490353671366,7905.1542768717554,{"$f":"IFERROR(SUM(V10:Z10),\"\")","v":83179.059518681403},{"$f":"SUM(V10:Z10)","v":83179.059518681403},null,{"$f":"SUMIF($F$9:$T$9,AD$9,$F10:$T10)","v":44780.690885938653},{"$f":"SUMIF($F$9:$T$9,AE$9,$F10:$T10)","v":21312.480614781729},{"$f":"SUMIF($F$9:$T$9,AF$9,$F10:$T10)","v":17085.888017961024},null,{"$f":"AB10-CP!V19","v":0}]
[null,205,"Total Metering",null,null,{"$f":"CP!F34","v":350},{"$f":"CP!G34","v":0},{"$f":"CP!H34","v":0},{"$f":"CP!I34","v":0},{"$f":"CP!J34","v":0},{"$f":"CP!K34","v":0},{"$f":"CP!L34","v":350},{"$f":"CP!M34","v":0},{"$f":"CP!N34","v":0},{"$f":"CP!O34","v":0},{"$f":"CP!P34","v":0},{"$f":"CP!Q34","v":0},{"$f":"CP!R34","v":350},{"$f":"CP!S34","v":0},{"$f":"CP!T34","v":0},null,350,0,350,0,350,null,{"$f":"SUM(V11:Z11)","v":1050},null,{"$f":"AD10/SUM($AD10:$AF10)","v":0.53836495802024831},{"$f":"AE10/SUM($AD10:$AF10)","v":0.25622411143029461},{"$f":"AF10/SUM($AD10:$AF10)","v":0.20541093054945711},null,{"$f":"AB11-CP!V34","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((CP!$F$10:$T$18)*($C17=CP!$D$10:$D$18)*(D$16=CP!$F$22:$T$22))/1000","v":17.825842360437058},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C17=CP!$D$10:$D$18)*(E$16=CP!$F$22:$T$22))/1000","v":16.978167627386327},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C17=CP!$D$10:$D$18)*(F$16=CP!$F$22:$T$22))/1000","v":16.756638577917084},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C17=CP!$D$10:$D$18)*(G$16=CP!$F$22:$T$22))/1000","v":12.638265048699173},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C17=CP!$D$10:$D$18)*(H$16=CP!$F$22:$T$22))/1000","v":6.7400128881699022},{"$f":"IFERROR(SUM(D17:H17),\"\")","v":70.938926502609533}]
[null,null,"DER",{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C18=CP!$D$10:$D$18)*(D$16=CP!$F$22:$T$22))/1000","v":3.8501092371817069},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C18=CP!$D$10:$D$18)*(E$16=CP!$F$22:$T$22))/1000","v":3.2088616913664381},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C18=CP!$D$10:$D$18)*(F$16=CP!$F$22:$T$22))/1000","v":3.1407953938496611},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C18=CP!$D$10:$D$18)*(G$16=CP!$F$22:$T$22))/1000","v":0.87522530497219331},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C18=CP!$D$10:$D$18)*(H$16=CP!$F$22:$T$22))/1000","v":1.1651413887018536},{"$f":"IFERROR(SUM(D18:H18),\"\")","v":12.240133016071853}]
[]
[]
[null,null,null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
[null,null,"Recurrent",{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C22=CP!$B$10:$B$18)*(D$16=CP!$F$22:$T$22))/1000","v":9.5637519978336858},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C22=CP!$B$10:$B$18)*(E$16=CP!$F$22:$T$22))/1000","v":8.8077899430226587},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C22=CP!$B$10:$B$18)*(F$16=CP!$F$22:$T$22))/1000","v":7.2069135460906599},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C22=CP!$B$10:$B$18)*(G$16=CP!$F$22:$T$22))/1000","v":8.0696566207107985},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C22=CP!$B$10:$B$18)*(H$16=CP!$F$22:$T$22))/1000","v":6.2544382820804314},{"$f":"IFERROR(SUM(D22:H22),\"\")","v":39.902550389738238}]
[null,null,"Non-recurrent",{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C23=CP!$B$10:$B$18)*(D$16=CP!$F$22:$T$22))/1000-D24","v":8.2620903626033666},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C23=CP!$B$10:$B$18)*(E$16=CP!$F$22:$T$22))/1000-E24","v":8.1703776843636682},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C23=CP!$B$10:$B$18)*(F$16=CP!$F$22:$T$22))/1000-F24","v":9.5497250318264246},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C23=CP!$B$10:$B$18)*(G$16=CP!$F$22:$T$22))/1000-G24","v":4.5686084279883756},{"$f":"SUMPRODUCT((CP!$F$10:$T$18)*($C23=CP!$B$10:$B$18)*(H$16=CP!$F$22:$T$22))/1000-H24","v":0.48557460608947078},{"$f":"IFERROR(SUM(D23:H23),\"\")","v":31.036376112871306}]
[null,null,"DER",{"$f":"D18","v":3.8501092371817069},{"$f":"E18","v":3.2088616913664381},3.1407953938496611,0.87522530497219331,1.1651413887018536,{"$f":"IFERROR(SUM(D24:H24),\"\")","v":12.240133016071853}]

{"sheet":"CP","index":1,"n_rows":34,"n_cols":31,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,5,29,7],[29,8,29,10],[29,11,29,13],[29,14,29,16],[29,17,29,19]]}
[{"$f":"Input!$A$1","v":"IT Capital Expenditure"},null,"AER draft decision"]
["CitiPower",null,"RRP change"]
["Summary"]
["Forecast, June $2021 '000 (no escalation)"]
[]
[]
["Standard control services"]
["IT Category",null,null,null,null,"2021/22 PAL SCS",null,null,"2022/23 PAL SCS",null,null,"2023/24 PAL SCS",null,null,"2024/25 PAL SCS",null,null,"2025/26 PAL SCS",null,null,null,"2021/22 - 2025/26",null,"CP SCS"]
["Description","Recurrent/Non-Recurrent","Category","AER category",null,"Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts",null,null,null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Recurrent programs","Recurrent",null,"ICT",null,4252.6488065841741,3375.9685463445148,1935.134644904997,4220.0921991826426,2924.6583384931246,1663.0394053468917,3615.8980424593492,2459.3838073237034,1131.6316963076079,3393.2320876493413,3206.0283895259895,1470.3961435354677,3103.1264111468163,2131.1108365798664,1020.201034353749,null,{"$f":"SUM(F10:T10)","v":39902.550389738237},null,{"$f":"SUMIF($F$22:$T$22,X$9,$F10:$T10)","v":9563.7519978336859},{"$f":"SUMIF($F$22:$T$22,Y$9,$F10:$T10)","v":8807.7899430226589},7206.91354609066,8069.6566207107981,6254.4382820804312]
["Digital network","Non-recurrent","New or expanded capabilities","DER",null,2176.8964882417636,581.11495553365808,0,2178.0450103650919,1030.8166810013461,0,1939.353470585241,1201.4419232644202,0,291.63751984051959,583.58778513167363,0,511.60785208345396,653.53353661839969,0,null,{"$f":"SUM(F11:T11)","v":11148.035222665567},null,2758.0114437754219,3208.8616913664382,3140.7953938496612,875.22530497219327,1165.1413887018537]
["5 Minute Settlements","Non-recurrent","Complying new obligations","ICT",null,5667.5488079661072,112.21789031137428,1409.5128708688728,1552.4070954970582,26.681654731902391,0,0,30.331551218573367,0,0,36.869889306412098,0,0,74.150444956780348,0,null,8909.7202048570798,null,7189.2795691463543,1579.0887502289606,30.331551218573367,36.869889306412098,74.150444956780348]
["SAP S/4HANA","Non-recurrent","Maintaining existing services","ICT",null,0,0,0,1113.6205527673114,0,649.3414301850213,2068.1524551392927,779.20971622202558,2584.3788921363848,1845.4283445858305,0,2233.7345198364733,0,0,0,null,11273.865910872339,null,0,1762.9619829523326,5431.7410634977032,4079.1628644223038,0]
["Cyber security","Non-recurrent","New or expanded capabilities","ICT",null,91.641413405546828,198.63003746060039,194.09946037566473,95.376031683706074,186.94591760997687,217.46770007691188,103.13179942131384,193.62255752461891,241.31284262920482,102.71900026182935,213.652477268545,206.02203165181123,79.738228230295334,148.5552381007852,183.13069480161002,null,2456.04543050242,null,484.370911241812,499.78964937059482,538.06719957513758,522.39350918218565,411.42416113269053]
["Customer Enablement","Non-recurrent","New or expanded capabilities","ICT",null,{"$f":"IFERROR(Input!F10*(1-Input!$E$10),\"\")","v":100.73521376124633},{"$f":"IFERROR(Input!G10*(1-Input!$E$10),\"\")","v":10.053013229137193},{"$f":"IFERROR(Input!H10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!I10*(1-Input!$E$10),\"\")","v":438.6895711480617},{"$f":"IFERROR(Input!J10*(1-Input!$E$10),\"\")","v":20.106026458274386},{"$f":"IFERROR(Input!K10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!L10*(1-Input!$E$10),\"\")","v":41.768259364419208},{"$f":"IFERROR(Input!M10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!N10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!O10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!P10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!Q10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!R10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!S10*(1-Input!$E$10),\"\")","v":0},{"$f":"IFERROR(Input!T10*(1-Input!$E$10),\"\")","v":0},null,611.35208396113887,null,110.78822699038352,458.79559760633606,41.768259364419208,0,0]
["Solar enablement DVMS","Non-recurrent","New or expanded capabilities","DER",null,624.57196367306994,467.5258297332154,0,0,0,0,0,0,0,0,0,0,0,0,0,null,1092.0977934062853,null,1092.0977934062853,0,0,0,0]
["Intelligent engineering","Non-recurrent","New or expanded capabilities","ICT",null,0,0,0,533.10693591172981,249.29012668306279,0,1416.0997904239118,345.63413699535761,1061.7109936414888,132.44892817682728,289.03203093688444,0,0,0,0,null,{"$f":"SUM(F17:T17)","v":4027.3229427692622},null,0,782.3970625947926,2823.4449210607581,421.48095911371172,0]
["Field service management solution","Non-recurrent","New or expanded capabilities","ICT",null,{"$f":"Input!F11","v":416.78497554451258},{"$f":"Input!G11","v":-40.097607012564843},{"$f":"Input!H11","v":100.96428669287029},{"$f":"Input!I11","v":2417.5624675966164},{"$f":"Input!J11","v":-40.097607012564843},{"$f":"Input!K11","v":709.87978102660145},{"$f":"Input!L11","v":564.61661093465261},{"$f":"Input!M11","v":-68.738754878682585},{"$f":"Input!N11","v":188.49418105386738},{"$f":"Input!O11","v":-307.9954476930838},{"$f":"Input!P11","v":-68.738754878682585},{"$f":"Input!Q11","v":-114.56459146447096},{"$f":"Input!R11","v":0},{"$f":"Input!S11","v":0},{"$f":"Input!T11","v":0},null,3758.069539909071,null,477.65165522481806,3087.3446416106531,684.37203710983738,-491.29879403623738,0]
["Total",null,null,null,null,{"$f":"SUM(F10:F18)","v":13330.827669176422},4705.4126655999353,3639.7112628424047,12548.899864152219,4398.4011379651229,3239.7283166354264,9749.0204283281801,4940.8849376700164,5207.5286057685535,5457.4704328212638,4260.4318172908215,3795.5881035592811,3694.4724914605654,3007.3500562558315,1203.331729155359,null,{"$f":"SUM(F19:T19)","v":83179.059518681388},null,21675.951597618761,20187.029318752771,19897.43397176675,13513.490353671366,7905.1542768717554,null,{"$f":"SUM(X19:AB19)-V19","v":0}]
[]
[]
["SCS summary by Recurrent/non-recurrent",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,"2021/22 - 2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Recurrent","Maintaining existing services",null,null,null,{"$f":"SUMIF($B$10:$B$18, $A23, F$10:F$18)","v":4252.6488065841741},3375.9685463445148,1935.134644904997,4220.0921991826426,2924.6583384931246,1663.0394053468917,3615.8980424593492,2459.3838073237034,1131.6316963076079,3393.2320876493413,3206.0283895259895,1470.3961435354677,3103.1264111468163,2131.1108365798664,1020.201034353749,null,{"$f":"SUM(F23:T23)","v":39902.550389738237},null,{"$f":"SUMIF($F$22:$T$22,X$9,$F23:$T23)","v":9563.7519978336859},{"$f":"SUMIF($F$22:$T$22,Y$9,$F23:$T23)","v":8807.7899430226589},7206.91354609066,8069.6566207107981,6254.4382820804312]
["Non-Recurrent","Maintaining existing services",null,null,null,9078.1788625922454,1329.4441192554204,1704.5766179374077,8328.8076649695759,1473.7427994719978,1576.6889112885347,6133.1223858688318,2481.5011303463134,4075.8969094609456,2064.2383451719229,1054.4034277648327,2325.1919600238134,591.34608031374933,876.23921967596527,183.13069480161002,null,{"$f":"SUM(F24:T24)","v":43276.509128943166},null,{"$f":"SUMIF($F$22:$T$22,X$9,$F24:$T24)","v":12112.199599785074},11379.239375730109,12690.520425676092,5443.8337329605693,1650.7159947913246]
["Total",null,null,null,null,{"$f":"SUM(F23:F24)","v":13330.827669176419},4705.4126655999353,3639.7112628424047,12548.899864152219,4398.401137965122,3239.7283166354264,9749.0204283281819,4940.8849376700164,5207.5286057685535,5457.4704328212647,4260.4318172908224,3795.5881035592811,3694.4724914605658,3007.3500562558315,1203.331729155359,null,{"$f":"SUM(F25:T25)","v":83179.059518681388},null,{"$f":"SUMIF($F$22:$T$22,X$9,$F25:$T25)","v":21675.951597618758},20187.029318752764,19897.433971766754,13513.490353671368,7905.1542768717572,null,{"$f":"SUM(F25:T25)-V25","v":0},{"$f":"V25-Output!AB10","v":0}]
["Check",null,null,null,null,{"$f":"SUM(F23:F24)-F19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Metering services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
["IT Category",null,null,null,null,"2021/22 PAL AMI",null,null,"2022/23 PAL AMI",null,null,"2023/24 PAL AMI",null,null,"2024/25 PAL AMI",null,null,"2025/26 PAL AMI",null,null,null,"2021/22 - 2025/26",null,"CP AMI"]
["Description","Recurrent/Non-Recurrent",null,null,null,"Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts",null,null,null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["UIQ upgrades","Recurrent",null,null,null,350,0,0,0,0,0,350,0,0,0,0,0,350,0,0,null,{"$f":"SUM(F32:T32)","v":1050},null,{"$f":"SUMIF($F$22:$T$22,X$9,$F32:$T32)","v":350},{"$f":"SUMIF($F$22:$T$22,Y$9,$F32:$T32)","v":0},350,0,350]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($F$22:$T$22,X$9,$F33:$T33)","v":0},0,0,0,0]
["Total",null,null,null,null,{"$f":"SUM(F32:F33)","v":350},{"$f":"SUM(G32:G33)","v":0},{"$f":"SUM(H32:H33)","v":0},{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0},{"$f":"SUM(K32:K33)","v":0},{"$f":"SUM(L32:L33)","v":350},{"$f":"SUM(M32:M33)","v":0},{"$f":"SUM(N32:N33)","v":0},{"$f":"SUM(O32:O33)","v":0},{"$f":"SUM(P32:P33)","v":0},{"$f":"SUM(Q32:Q33)","v":0},{"$f":"SUM(R32:R33)","v":350},{"$f":"SUM(S32:S33)","v":0},{"$f":"SUM(T32:T33)","v":0},null,{"$f":"SUM(F34:T34)","v":1050},null,{"$f":"SUMIF($F$22:$T$22,X$9,$F34:$T34)","v":350},0,350,0,350,null,{"$f":"SUM(F34:T34)-V34","v":0},{"$f":"V34-Output!AB11","v":0}]

{"sheet":"CP2","index":2,"n_rows":44,"n_cols":23,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Input!$A$1","v":"IT Capital Expenditure"}]
["CitiPower"]
["Summary"]
["Forecast, June $2021 '000 (no escalation)"]
[]
[]
["Standard control services"]
["IT Category",null,null,"2021/22 CP SCS",null,null,"2022/23 CP SCS",null,null,"2023/24 CP SCS",null,null,"2024/25 CP SCS",null,null,"2025/26 CP SCS",null,null,null,"2021/22 - 2025/26"]
["Description","Recurrent/Non-Recurrent","Category","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts"]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(D10:R10)","v":{"$error":"#REF!"}}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(D11:R11)","v":{"$error":"#REF!"}}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!A10","v":"Customer Enablement"},{"$f":"Input!B10","v":"Non-recurrent"},{"$f":"IF(ISBLANK(Input!C10), \"\", Input!C10)","v":"New or expanded capabilities"},{"$f":"(1-Input!$E10)*Input!F10","v":100.73521376124633},{"$f":"(1-Input!$E10)*Input!G10","v":10.053013229137193},{"$f":"(1-Input!$E10)*Input!H10","v":0},{"$f":"(1-Input!$E10)*Input!I10","v":438.6895711480617},{"$f":"(1-Input!$E10)*Input!J10","v":20.106026458274386},{"$f":"(1-Input!$E10)*Input!K10","v":0},{"$f":"(1-Input!$E10)*Input!L10","v":41.768259364419208},{"$f":"(1-Input!$E10)*Input!M10","v":0},{"$f":"(1-Input!$E10)*Input!N10","v":0},{"$f":"(1-Input!$E10)*Input!O10","v":0},{"$f":"(1-Input!$E10)*Input!P10","v":0},{"$f":"(1-Input!$E10)*Input!Q10","v":0},{"$f":"(1-Input!$E10)*Input!R10","v":0},{"$f":"(1-Input!$E10)*Input!S10","v":0},{"$f":"(1-Input!$E10)*Input!T10","v":0},null,611.35208396113887]
[{"$f":"Input!A11","v":"Field service management solution"},{"$f":"Input!B11","v":"Non-recurrent"},{"$f":"IF(ISBLANK(Input!C11), \"\", Input!C11)","v":"New or expanded capabilities"},{"$f":"(1-Input!$E11)*Input!F11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!G11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!H11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!I11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!J11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!K11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!L11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!M11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!N11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!O11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!P11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!Q11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!R11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!S11","v":{"$error":"#VALUE!"}},{"$f":"(1-Input!$E11)*Input!T11","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Input!#REF!), \"\", Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},{"$f":"(1-Input!#REF!)*Input!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Total",null,null,{"$f":"SUM(D10:D28)","v":{"$error":"#REF!"}},{"$f":"SUM(E10:E28)","v":{"$error":"#REF!"}},{"$f":"SUM(F10:F28)","v":{"$error":"#REF!"}},{"$f":"SUM(G10:G28)","v":{"$error":"#REF!"}},{"$f":"SUM(H10:H28)","v":{"$error":"#REF!"}},{"$f":"SUM(I10:I28)","v":{"$error":"#REF!"}},{"$f":"SUM(J10:J28)","v":{"$error":"#REF!"}},{"$f":"SUM(K10:K28)","v":{"$error":"#REF!"}},{"$f":"SUM(L10:L28)","v":{"$error":"#REF!"}},{"$f":"SUM(M10:M28)","v":{"$error":"#REF!"}},{"$f":"SUM(N10:N28)","v":{"$error":"#REF!"}},{"$f":"SUM(O10:O28)","v":{"$error":"#REF!"}},{"$f":"SUM(P10:P28)","v":{"$error":"#REF!"}},{"$f":"SUM(Q10:Q28)","v":{"$error":"#REF!"}},{"$f":"SUM(R10:R28)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D29:R29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D29:R29)-T29","v":{"$error":"#REF!"}},{"$f":"T29-#REF!","v":{"$error":"#REF!"}}]
[]
[]
["SCS summary by Recurrent/non-recurrent",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,"2021/22 - 2025/26"]
["Recurrent",null,null,{"$f":"SUMIF($B$10:$B$28, $A33, D$10:D$28)","v":0},{"$f":"SUMIF($B$10:$B$28, $A33, E$10:E$28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(D33:R33)","v":0}]
["Non-Recurrent",null,null,{"$f":"SUMIF($B$10:$B$28, $A34, D$10:D$28)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(D34:R34)","v":{"$error":"#VALUE!"}}]
["Total",null,null,{"$f":"SUM(D33:D34)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(D35:R35)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(D35:R35)-T35","v":{"$error":"#VALUE!"}},{"$f":"T35-#REF!","v":{"$error":"#VALUE!"}}]
["Check",null,null,{"$f":"SUM(D33:D34)-D29","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["Metering services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
["IT Category",null,null,"2021/22 CP SCS",null,null,"2022/23 CP SCS",null,null,"2023/24 CP SCS",null,null,"2024/25 CP SCS",null,null,"2025/26 CP SCS"]
["Description","Recurrent/Non-Recurrent",null,"Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts",null,"2021/22 - 2025/26"]
["UIQ upgrades","Recurrent",null,{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"Input!#REF!*(1-Input!#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D42:R42)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D43:R43)","v":0}]
["Total",null,null,{"$f":"SUM(D42:D43)","v":{"$error":"#REF!"}},{"$f":"SUM(E42:E43)","v":{"$error":"#REF!"}},{"$f":"SUM(F42:F43)","v":{"$error":"#REF!"}},{"$f":"SUM(G42:G43)","v":{"$error":"#REF!"}},{"$f":"SUM(H42:H43)","v":{"$error":"#REF!"}},{"$f":"SUM(I42:I43)","v":{"$error":"#REF!"}},{"$f":"SUM(J42:J43)","v":{"$error":"#REF!"}},{"$f":"SUM(K42:K43)","v":{"$error":"#REF!"}},{"$f":"SUM(L42:L43)","v":{"$error":"#REF!"}},{"$f":"SUM(M42:M43)","v":{"$error":"#REF!"}},{"$f":"SUM(N42:N43)","v":{"$error":"#REF!"}},{"$f":"SUM(O42:O43)","v":{"$error":"#REF!"}},{"$f":"SUM(P42:P43)","v":{"$error":"#REF!"}},{"$f":"SUM(Q42:Q43)","v":{"$error":"#REF!"}},{"$f":"SUM(R42:R43)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D44:R44)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D44:R44)-T44","v":{"$error":"#REF!"}},{"$f":"T44-#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Input","index":3,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["IT Capital Expenditure"]
["Input"]
["Input"]
["Forecast, June $2021 '000 (no escalation)"]
[null,"Check OK:",{"$f":"SUM(W10:W21)=0","v":true}]
[]
["Standard control services"]
[null,null,null,null,null,"2021/22 VPN SCS",null,null,"2022/23 VPN SCS",null,null,"2023/24 VPN SCS",null,null,"2024/25 VPN SCS",null,null,"2025/26 VPN SCS"]
["Project","Recurrent/Non-Recurrent","Category","Business","Powercor allocation","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts","Labour","Materials","Contracts"]
["Customer Enablement","Non-recurrent","New or expanded capabilities","VPN",0.7,{"$f":"[1]Output_VPN!F$12","v":335.78404587082105},{"$f":"[1]Output_VPN!G$12","v":33.510044097123973},{"$f":"[1]Output_VPN!H$12","v":0},{"$f":"[1]Output_VPN!I$12","v":1462.2985704935388},{"$f":"[1]Output_VPN!J$12","v":67.020088194247947},{"$f":"[1]Output_VPN!K$12","v":0},{"$f":"[1]Output_VPN!L$12","v":139.22753121473067},{"$f":"[1]Output_VPN!M$12","v":0},{"$f":"[1]Output_VPN!N$12","v":0},{"$f":"[1]Output_VPN!O$12","v":0},{"$f":"[1]Output_VPN!P$12","v":0},{"$f":"[1]Output_VPN!Q$12","v":0},{"$f":"[1]Output_VPN!R$12","v":0},{"$f":"[1]Output_VPN!S$12","v":0},{"$f":"[1]Output_VPN!T$12","v":0}]
["Field service management solution","Non-recurrent","New or expanded capabilities","CP","NA",{"$f":"[2]Output_CP!F$12","v":416.78497554451258},{"$f":"[2]Output_CP!G$12","v":-40.097607012564843},{"$f":"[2]Output_CP!H$12","v":100.96428669287029},{"$f":"[2]Output_CP!I$12","v":2417.5624675966164},{"$f":"[2]Output_CP!J$12","v":-40.097607012564843},{"$f":"[2]Output_CP!K$12","v":709.87978102660145},{"$f":"[2]Output_CP!L$12","v":564.61661093465261},{"$f":"[2]Output_CP!M$12","v":-68.738754878682585},{"$f":"[2]Output_CP!N$12","v":188.49418105386738},{"$f":"[2]Output_CP!O$12","v":-307.9954476930838},{"$f":"[2]Output_CP!P$12","v":-68.738754878682585},{"$f":"[2]Output_CP!Q$12","v":-114.56459146447096},{"$f":"[2]Output_CP!R$12","v":0},{"$f":"[2]Output_CP!S$12","v":0},{"$f":"[2]Output_CP!T$12","v":0}]
[null,null,null,null,null,{"$f":"SUM(F10:F11)","v":752.56902141533362},-6.5875629154408699,100.96428669287029,3879.8610380901555,26.922481181683104,709.87978102660145,703.84414214938329,-68.738754878682585,188.49418105386738,-307.9954476930838,-68.738754878682585,-114.56459146447096,0,0,0]
[]
["SCS summary"]
[null,null,null,null,null,"2021/22 VPN SCS",null,null,"2022/23 VPN SCS",null,null,"2023/24 VPN SCS",null,null,"2024/25 VPN SCS",null,null,"2025/26 VPN SCS"]
["Recurrent",null,null,null,null,{"$f":"SUMIF($B$10:$B$11,$A16,F$10:F$11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Non-Recurrent",null,null,null,null,752.56902141533362,-6.5875629154408699,100.96428669287029,3879.8610380901555,26.922481181683104,709.87978102660145,703.84414214938329,-68.738754878682585,188.49418105386738,-307.9954476930838,-68.738754878682585,-114.56459146447096,0,0,0]
["Total",null,null,null,null,{"$f":"SUM(F16:F17)","v":752.56902141533362},-6.5875629154408699,100.96428669287029,3879.8610380901555,26.922481181683104,709.87978102660145,703.84414214938329,-68.738754878682585,188.49418105386738,-307.9954476930838,-68.738754878682585,-114.56459146447096,0,0,0]
["Check",null,null,null,null,{"$f":"SUM(F16:F17)-F12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]