{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Escalators","Assumptions","Export CP","CP"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":5,"defined_names":3549,"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":"Escalators","index":0,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["IT Capex Expenditure Template",null,null,null,null,null,null,"Menu"]
["Escalators"]
[]
[null,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[]
["INFLATION ESCALATION"]
["CPI",149.80000000000001,155.69999999999999,158.6,166.5,168.6,173.3,179.4,182.99519038076153,186.94989979959919,193.73460685542145,198.7717066336624,203.93977100613762,209.24220505229721,214.68250238365695,220.26424744563204]
[null,null,null,null,null,null,null,99.8,101.8,104,107.77432421500033,{"$f":"K8*(1+L9)","v":110.46868232037534},113.2303993783847,116.06115936284431,118.9626883469154,121.93675555558828]
["Inflation",null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["Real cost year",2015]
[{"$f":"\"Conversion from nominal to real $\"&B10","v":"Conversion from nominal to real $2015"},{"$f":"HLOOKUP($B$10,$B$4:$P$7,4)/B7","v":1.2932884302765115},{"$f":"HLOOKUP($B$10,$B$4:$P$7,4)/C7","v":1.2442813542416278},{"$f":"HLOOKUP($B$10,$B$4:$P$7,4)/D7","v":1.2215296775247255},{"$f":"HLOOKUP($B$10,$B$4:$P$7,4)/E7","v":1.1635712123448736},1.1424759481560132,1.1111019528790982,1.0829682230828193,1.0568183435763274,1.0337650051524583,1.0124228365658292,{"$f":"HLOOKUP($B$10,$B$4:$P$8,5)/L8","v":0.97560975609756106},{"$f":"HLOOKUP($B$10,$B$4:$P$8,5)/M8","v":0.95181439619274255},{"$f":"HLOOKUP($B$10,$B$4:$P$8,5)/N8","v":0.92859941091974896},{"$f":"HLOOKUP($B$10,$B$4:$P$8,5)/O8","v":0.90595064479975518},{"$f":"HLOOKUP($B$10,$B$4:$P$8,5)/P8","v":0.88385428760951734}]

{"sheet":"Assumptions","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Escalators!A1","v":"IT Capex Expenditure Template"},null,null,null,"Menu"]
["Assumptions"]
[]
["LABOUR RATES"]
[]
["Labour Rate Assumption 2016 - 2020"]
[]
[null,null,"PCN Mhr Rate ($/Mhr)",83]
[null,null,"CPN Mhr Rate ($/Mhr)",75]
[null,null,"NS Mhr Rate ($/Mhr)",90]
[null,null,"IT Internal Mhr Rate ($/Mhr)",90]
[null,null,"Corporate Mhr Rate ($/Mhr)",98]
[null,null,"CSG Mhr Rate ($/Mhr)",57]

{"sheet":"Export CP","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Escalators!A1","v":"IT Capex Expenditure Template"}]
["Export"]
[]
["EXPORT"]
[]
["CITIPOWER",null,null,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020]
[null,null,null,"$'000 nom","$'000 nom","$'000 nom","$'000 nom","$'000, $2015","$'000, $2015","$'000, $2015","$'000, $2015","$'000, $2015","$'000, $2015"]
[null,null,"Description","Actual","Actual","F'cast","F'cast","F'cast","F'cast","F'cast","F'cast","F'cast","F'cast"]
[null,200,"Computers",null,null,null,null,null,{"$f":"SUM(CP!B37:D37)","v":21621.533774612995},{"$f":"SUM(CP!E37:G37)","v":21153.404040069272},{"$f":"SUM(CP!H37:J37)","v":16113.512695100657},{"$f":"SUM(CP!K37:M37)","v":11797.948332810111},{"$f":"SUM(CP!N37:P37)","v":9056.3839573591358}]
[null,205,"IT Metering Data Services",null,null,null,null,null,{"$f":"SUM(CP!B86:D86)","v":388.08228609118038},{"$f":"SUM(CP!E86:G86)","v":551.027423575174},{"$f":"SUM(CP!H86:J86)","v":234.02485709831069},{"$f":"SUM(CP!K86:M86)","v":141.5990735853988},{"$f":"SUM(CP!N86:P86)","v":917.54072484582457}]

{"sheet":"CP","index":3,"n_rows":102,"n_cols":16,"rows_kept":102,"cut":false,"hidden":false,"merged":[[54,1,54,3],[54,4,54,6],[54,7,54,9],[54,10,54,12],[54,13,54,15],[5,1,5,3],[5,4,5,6],[5,7,5,9],[5,10,5,12],[5,13,5,15]]}
[{"$f":"Escalators!A1","v":"IT Capex Expenditure Template"}]
["CitiPower Summary"]
[]
[]
[]
["IT Category","2016 CP SCS",null,null,"2017 CP SCS",null,null,"2018 CP SCS",null,null,"2019 CP SCS",null,null,"2020 CP SCS"]
[null,"Material","Contract","Labour","Material","Contract","Labour","Material","Contract","Labour","Material","Contract","Labour","Material","Contract","Labour"]
["AMI",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Compliance",241.06893615884644,562.1257758494894,232.48439303677506,13.983116946568819,313.83959370984104,123.92961362002437,0,304.21920925060169,115.79448787661565,13.983116946568819,324.80235739595105,126.72646073920927,0,316.3006222924372,118.92684590381654]
["Compliance - metering contestability",0,1397,987,0,3244,1359,0,730,452,0,0,0,0,0,0]
["Compliance - RIN Reporting",689.11400000000003,1450.9344257703081,1878.9858783613445,0,700.41557422969186,574.48124663865553,0,0,0,0,0,0,0,0,0]
["Currency",1241.5055514088476,1082.0886377239069,395.90347925890848,543.83525760934867,1130.3235244693892,445.01079512064797,1027.1087218791042,1361.5017549096483,499.43460267738806,925.85785235352228,1194.2528333623418,435.37981145876307,772.998282827156,1696.6265607430287,640.35602954733622]
["Currency - IEE / MTS Upgrade",0,0,0,0,0,0,0,805.42753612236413,313.21454838232938,0,0,0,0,0,0]
["Currency - Refresh Telephony Solution",0,0,0,55.932467786275275,39.432389789324077,20.043959155889606,251.69610503823876,55.932467786275275,47.810010746820168,251.69610503823876,219.53493606113051,104.97383181141029,55.932467786275275,39.712052128255436,20.071366065104883]
["Currency - USB Upgrade",0,379.78145626880911,119.96851540412779,0,0,0,0,0,0,0,212.54337758784607,67.115857091568202,0,0,0]
["Customer Engagement",41.949350839706462,95.364857575599345,39.230420444771212,0,13.983116946568819,1.3977523699790191,83.898701679412923,70.294075116360233,57.20297379204051,27.966233893137638,293.64545587794521,89.005115055052102,27.966233893137638,69.915584732844096,29.218503117781168]
["Customer Engagement - Billing / CRM Implementation ",2490.5484961499797,3152.1870683022439,999.80752220094917,1132.6324726720745,3072.8676329915302,813.03398507289751,0,0,0,0,0,0,0,0,0]
["Device Replacement",319.68257895713424,0,0,229.57593267812263,0,0,313.99368765859214,0,0,158.93070890300655,0,0,171.586828051346,0,0]
["Device Replacement - mobile devices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Infrastructure",60.310413904842619,30.25946507237493,7.7688519781102778,60.310413904842619,29.420478055580801,7.4947549197236354,335.59480671765169,40.617710646650821,26.274304708836706,55.932467786275275,15.01388520890853,3.9123642567143833,60.310413904842619,29.420478055580801,7.3827501529816182]
["Infrastructure - Data Warehouse Hardware Refresh ",0,0,0,880.93636763383552,74.390182155746132,23.491552571533941,0,0,0,0,0,0,0,0,0]
["Infrastructure - Network Infrastructure Refresh",100.50969375998432,172.8000312438642,36.915512637643367,100.50969375998432,172.8000312438642,36.915512637643367,139.83116946568819,4.5282170831453348,8.3897862692396128,223.7298711451011,4.5282170831453348,12.864691320714456,27.966233893137638,4.5282170831453348,20.415322775756586]
["Infrastructure - SAN Storage Growth",33.000155993902418,8.3898701679412913,2.240095334840325,205.83148145349301,19.017039047333597,4.4801906696806499,208.62810484280675,19.017039047333597,4.4801906696806499,76.068156189334388,19.017039047333597,4.4801906696806499,78.305454900785392,19.017039047333597,4.4801906696806499]
["Infrastructure - Server Refresh",171.99233844279649,25.169610503823879,7.5506314550421259,103.47506540460928,14.822103963362949,6.4434202889789134,626.44363920628314,79.703766595442275,30.48039832013071,265.67922198480755,20.41535074199048,6.7202860045209745,107.6700004885799,18.73737670840222,6.4434202889789134]
["Infrastructure - Storage Infrastructure Refresh",0,0,0,323.01000146573978,4.1949350839706456,8.9603813393612999,1129.276524604898,27.966233893137638,22.375783737899425,0,0,0,0,0,0]
["Security",730.85091240733038,685.63883428009115,161.31385152421029,582.62987277370087,727.58818511979757,147.78075789137188,1113.9883167433159,804.02922442770716,185.6215893098375,1060.176096012849,943.86039389339555,211.96988335147745,838.98701679412932,809.15636730811559,181.33804787481543]
["Smarter Networks - Asset Management Data Analytics",151.86342548487437,194.29406656534829,126.77312740728026,0,213.07046049229814,119.31830371365326,242.98148077579901,283.00053065957309,201.19710968881853,242.98148077579901,283.00053065957309,201.19710968881853,0,241.1591196699805,160.22381078466768]
["Smarter Networks - DMS / OMS Integration",0,0,0,0,122.46266631100269,51.311857184310135,531.52198919706029,721.16903494257144,301.90874203984384,334.0995360667236,450.97362831988295,188.71994990561103,0,0,0]
["Smarter Networks - DMS Low Voltage Modelling",0,0,0,0,0,0,0,0,0,0,403.3492580878264,325.53055116568436,0,403.3492580878264,326.79218577740488]
["Smarter Networks - DMS Mobility Switching Integration",0,0,0,303.72685096974874,309.07244354681637,285.72860523498343,0,0,0,0,0,0,0,0,0]
["Smarter Networks - Lidar Data Management and Application",0,0,0,356.87904988945485,227.43066600614785,95.159141043077128,19.742245313033671,374.67744335628203,156.80548656774354,10.630439783941208,186.123814274262,77.905876528370371,0,0,0]
["Smarter Networks - Outage Notification System Extension",47.077661900311057,131.20999961893148,54.796272364005276,0,415.25535064584051,173.70967781263079,0,108.85570338755794,45.556445967229067,0,0,0,0,0,0]
["Smarter Networks - Remote Diagnostics / Asset Condition Alerts",0,0,0,0,0,0,0,0,0,303.72685096974874,250.99986964140035,225.71142016623364,303.72685096974874,250.99986964140035,226.34223747209387]
["Smarter Networks - Smart Network Advanced Analytics",0,0,0,80.487615506983417,153.56429585030497,66.266091673286482,68.338541468193469,161.27895786493659,69.69538042953063,68.338541468193469,161.27895786493659,69.672600915707903,68.338541468193469,161.27895786493659,69.642835684312857]
["Smarter Networks - Smart Network Demand Management",197.42245313033666,224.27190675606246,172.80949217172665,151.86342548487437,222.32805490985609,167.64801881171692,151.86342548487437,222.32805490985609,167.64801881171692,0,215.7675549289095,150.82762580501222,0,236.17799931407666,158.34131176235715]
["Smarter Networks - Storage Integration to Network Management",60.745370193949753,147.7327403116858,81.095646289939751,60.745370193949753,137.77049959987804,77.384741997476468,364.47222116369852,380.26601741412543,243.43017645273665,0,190.74046240900222,85.590105112534815,0,190.74046240900222,85.500809418349704]
[null,{"$f":"SUM(B8:B36)","v":6577.641338732843},9739.2487460104785,5304.6436898696738,5186.364456133605,11358.049224168146,4608.990359767522,6609.3796812386499,6554.8129774135687,2949.3200364484383,4019.7966793172468,5389.8479224457815,2388.3037310470831,2513.7883249773317,4487.1199650863655,2055.4756672954381]
[]
["AMI",{"$f":"SUM(B8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Compliance",{"$f":"SUM(B9:B11)","v":930.18293615884647},3410.0602016197972,3098.4702713981196,13.983116946568819,4258.2551679395328,2057.4108602586798,0,1034.2192092506016,567.79448787661568,13.983116946568819,324.80235739595105,126.72646073920927,0,316.3006222924372,118.92684590381654]
["Currency",{"$f":"SUM(B12:B15)","v":1241.5055514088476},1461.870093992716,515.87199466303628,599.76772539562398,1169.7559142587133,465.05475427653755,1278.804826917343,2222.8617588182874,860.45916180653762,1177.5539573917611,1626.3311470113185,607.46950036174155,828.93075061343131,1736.3386128712841,660.42739561244116]
["Customer Engagement",{"$f":"SUM(B16:B17)","v":2532.497846989686},3247.5519258778431,1039.0379426457205,1132.6324726720745,3086.8507499380989,814.43173744287651,83.898701679412923,70.294075116360233,57.20297379204051,27.966233893137638,293.64545587794521,89.005115055052102,27.966233893137638,69.915584732844096,29.218503117781168]
["Device Replacement",{"$f":"SUM(B18:B19)","v":319.68257895713424},{"$f":"SUM(C18:C19)","v":0},0,229.57593267812263,0,0,313.99368765859214,0,0,158.93070890300655,0,0,171.586828051346,0,0]
["Infrastructure",{"$f":"SUM(B20:B25)","v":365.81260210152584},236.61897698800431,54.475091405636093,1674.0730236225045,314.64476954985832,87.785812426921808,2439.7742448373278,171.83296726570964,92.000463705787112,621.40971710551833,58.974492081377946,27.977532251630464,274.25210318734554,71.703110894461958,38.721683887397766]
["Security",{"$f":"SUM(B26)","v":730.85091240733038},685.63883428009115,161.31385152421029,582.62987277370087,727.58818511979757,147.78075789137188,1113.9883167433159,804.02922442770716,185.6215893098375,1060.176096012849,943.86039389339555,211.96988335147745,838.98701679412932,809.15636730811559,181.33804787481543]
["Smarter Networks",{"$f":"SUM(B27:B36)","v":457.10891070947184},697.50871325202797,435.47453823295189,953.70231204501101,1800.9544373621447,1036.5264374711348,1378.9199034026594,2251.5757425349025,1186.2413599576191,959.77684906440606,2142.2340761857931,1325.155239287973,372.06539243794219,1483.7056669872227,1026.8431908991861]
[null,{"$f":"SUM(B39:B46)","v":6577.641338732843},{"$f":"SUM(C39:C46)","v":9739.2487460104785},5304.6436898696738,5186.3644561336068,11358.049224168146,4608.9903597675229,6609.3796812386508,6554.8129774135687,2949.3200364484373,4019.7966793172473,5389.8479224457815,2388.3037310470836,2513.7883249773317,4487.1199650863655,2055.4756672954381]
[]
[]
["Recurrent",4799.9074196483916,4264.1904327190714,1664.7415167001029,3789.3929765446455,5696.4820704520589,1914.4090695534114,6508.5923600395454,5484.1179673109064,2309.095367082512,3613.4877245122893,4931.704575951996,2262.0141321239507,2325.4640933250721,4551.5281903486493,2094.6695698463059]
["Non-Recurrent",1893.4303793402341,3992.891102930645,1487.7072843720523,2319.5848512151047,2835.9307661069279,1517.2768583071031,513.06764356022393,1005.2502695336254,688.59724186490507,809.72148160748657,1739.058429411562,1075.79541911859,415.64141521069672,556.01447452651053,388.8713488264932]
["Device Replacement",355.2028655079269,0,0,255.08436964235847,0,0,348.8818751762135,0,0,176.58967655889617,0,0,190.65203116816221,0,0]
[null,{"$f":"SUM(B50:B52)-B37","v":470.89932576370938},{"$f":"SUM(C50:C52)-C37","v":-1482.1672103607616},-2152.1948887975186,1177.6977412685037,-2825.63638760916,-1177.3044319070077,761.16219753733276,-65.444740569037094,48.372572498979025,580.00220336142547,1280.915082917777,949.50582019545755,417.96921472659915,620.42269978879449,428.06525137736116]
[]
["IT Category","2016 CP AMI (Excl margins)",null,null,"2017 CP AMI (Excl margins)",null,null,"2018 CP AMI (Excl margins)",null,null,"2019 CP AMI (Excl margins)",null,null,"2020 CP AMI (Excl margins)"]
[null,"Material","Contract","Labour","Material","Contract","Labour","Material","Contract","Labour","Material","Contract","Labour","Material","Contract","Labour"]
["AMI",64.904491365227642,225.40488282946956,97.772911896483208,207.18941819269975,278.50595587562395,65.332049506850339,22.621575860226887,151.58673237963808,59.816548858445728,13.650946449823415,91.825130956073735,36.122996179501662,413.82881306977225,399.54278037868318,104.16913139736914]
["Compliance",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Compliance - metering contestability",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Compliance - RIN Reporting",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Currency",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Currency - IEE / MTS Upgrade",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Currency - Refresh Telephony Solution",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Currency - USB Upgrade",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Customer Engagement",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Customer Engagement - Billing / CRM Implementation ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Device Replacement",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Device Replacement - mobile devices",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Infrastructure",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Infrastructure - Data Warehouse Hardware Refresh ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Infrastructure - Network Infrastructure Refresh",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Infrastructure - SAN Storage Growth",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Infrastructure - Server Refresh",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Infrastructure - Storage Infrastructure Refresh",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Security",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - Asset Management Data Analytics",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - DMS / OMS Integration",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - DMS Low Voltage Modelling",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - DMS Mobility Switching Integration",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - Lidar Data Management and Application",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - Outage Notification System Extension",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - Remote Diagnostics / Asset Condition Alerts",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - Smart Network Advanced Analytics",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - Smart Network Demand Management",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks - Storage Integration to Network Management",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"SUM(B57:B85)","v":64.904491365227642},225.40488282946956,97.772911896483208,207.18941819269975,278.50595587562395,65.332049506850339,22.621575860226887,151.58673237963808,59.816548858445728,13.650946449823415,91.825130956073735,36.122996179501662,413.82881306977225,399.54278037868318,104.16913139736914]
[]
["AMI",{"$f":"SUM(B57)","v":64.904491365227642},225.40488282946956,97.772911896483208,207.18941819269975,278.50595587562395,65.332049506850339,22.621575860226887,151.58673237963808,59.816548858445728,13.650946449823415,91.825130956073735,36.122996179501662,413.82881306977225,399.54278037868318,104.16913139736914]
["Compliance",{"$f":"SUM(B58:B60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Currency",{"$f":"SUM(B61:B64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Customer Engagement",{"$f":"SUM(B65:B66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Device Replacement",{"$f":"SUM(B67:B68)","v":0},{"$f":"SUM(C67:C68)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Infratructure",{"$f":"SUM(B69:B74)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Security",{"$f":"SUM(B75)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Smarter Networks",{"$f":"SUM(B76:B85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"SUM(B88:B95)","v":64.904491365227642},{"$f":"SUM(C88:C95)","v":225.40488282946956},97.772911896483208,207.18941819269975,278.50595587562395,65.332049506850339,22.621575860226887,151.58673237963808,59.816548858445728,13.650946449823415,91.825130956073735,36.122996179501662,413.82881306977225,399.54278037868318,104.16913139736914]
[]
[]
["Recurrent",54.960941536556483,225.40488282946956,97.772911896483208,207.18941819269975,278.50595587562395,65.332049506850339,22.621575860226887,151.58673237963808,59.816548858445728,13.650946449823415,91.825130956073735,36.122996179501662,413.82881306977225,399.54278037868318,104.16913139736914]
["Non-Recurrent",9.943549828671161,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Device Replacement",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"SUM(B99:B101)-B86","v":0},{"$f":"SUM(C99:C101)-C86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]