{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Contents","Styles","Inputs --->","Spectrum cost inputs","MCT Cost Trends","Calculations --->","Cost Trend calc","Cost calculations","Discounted cost_7years","Discounted cost_15years","Cost_SiteRural","Cost_SiteUrban","Composite cost scenarios","Costs By HDA grouping","Final OutputCosts --->","FinalOutputTables"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":45,"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":"Contents","index":0,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,0,34,2],[35,0,35,2],[36,0,36,2],[17,0,18,0],[19,0,26,0],[33,0,33,2]]}
[]
[null,null,null,null,null,{"$f":"Workbook.Title","v":"mmWave fixed links clearance cost model"}]
[]
["Information"]
[]
["Title ","mmWave fixed links clearance cost model"]
["Project","Enabling mmWave spectrum for new uses"]
["Objective","Estimate the cost of moving fixed links out of the 26GHz and 40 GHz bands"]
["Status","Consultation model"]
["Confidentiality","Approved for release"]
[]
[]
[]
[]
["Contents"]
[]
["Section","Worksheet","Description"]
["Inputs","Spectrum cost inputs","Input data assumptions for spectrum equipement and site costs"]
[null,"MCT CostTrends","Input data for cost trends"]
["Calculations","Cost Trend Calc","Estimates the increase in cost input assumptions since 2015 publication of plum report"]
[null,"Cost calculations","Estimates opex and capex for different equipment & site assumptions"]
[null,"Discounted cost_7years","Estimates the overall present costs for replacing equipment and adding  hop assuming a 7 year economic lifetime"]
[null,"Discounted cost_15years","Estimates the overall present costs for replacing equipment and adding  hop assuming a 15 year economic lifetime"]
[null,"Cost_SiteRural","Estimates the annualised capex cost for a new rural site"]
[null,"Cost_SiteUrban","Estimates the annualised capex cost for a new urban site"]
[null,"Composite cost scenarios","Estimates overall costs for 4 different cost scenarios"]
[null,"Costs By HDA grouping","Determines final costs for different high density area options, dependent on existing fixed links"]
["Outputs","FinalOutputTables","Outputs rearranged into tables for consultation annex"]
[]
[]
[]
["Terms and conditions"]
[null,"mmWave fixed links clearance cost model"]
["The terms and conditions on which OFCOM is making the model available are set out below.  "]
["The mmWave fixed links clearance cost model provided has been developed to help understand the potential cost of revoking fixed link licences in the 26 GHz And 40 GHz spectrum band as part of Ofcom's consultation on Enabling mmWave spectrum for new uses."]
["All right, title and interest in the provided model (the ‘Model’) constructed in Excel to understand the cost to licensees of clearance of fixed links are owned by OFCOM. Such title and interest is protected by United Kingdom intellectual property laws and international treaty provisions. While you may freely use the Model for the purposes for which it is provided, as set out in the accompanying model documentation, OFCOM notes that any other use of the Model may not result in the correct functioning of the Model. \n\nNo representation or warranty is given as to the accuracy, completeness or correctness of the provided Model and it is provided 'as is'. It is provided without any representation or endorsement made and without warranty of any kind, whether express or implied, including but not limited to the implied warranties of satisfactory quality, fitness for a particular purpose, non-infringement, compatibility, security and accuracy. "]
["OFCOM does not accept any responsibility for any loss, disruption or damage to your data or your computer system which may occur whilst using the Model or material derived from the Model. OFCOM does not warrant that the functions contained in the Model will be uninterrupted or error free. Also, OFCOM does not warrant that defects will be corrected, or that the Model provided is free of viruses.\n\nIn no event will OFCOM be liable for any loss or damage including, without limitation, indirect or consequential loss or damage, or any loss or damages whatsoever arising from use or loss of use of, data or profits arising out of or in connection with the use or otherwise of the provided Model. By using this Model, you agree to the above. "]

{"sheet":"Styles","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Style Guidelines"]
[]
[]
["Styles"]
[]
[]
[null,"Input data",100,null,"Input data (e.g. RFS data, inflation, etc)"]
[]
[null,"Input assumption or parameter",100,null,"Input assumptions or parameters (e.g. for a scenario or control sheet)"]
[]
[null,"Feed internal",100,null,"Feed cell from within this workbook"]
[]
[null,"Feed external",100,null,"Feed cell from a different workbook"]
[]
[null,"Confidential",100,null,"Confidential data, to be removed or randomized before publication"]
[]
[null,"Randomized",100,null,"Randomized data"]
[]
[null,"Calculation",100,null,"Intermediate calculation (not final output)"]
[]
[null,"Model logic",100,null,"Cells required for model logic (e.g. year counters)"]
[]
[null,"Intentionally blank",null,null,"Cells left intentionally blank"]
[]
[null,"Output",100,null,"A key result from this part of the model (in particular one that will be used elsewhere in the model)"]
[]
[null,"Highlight",100,null,"A cell that is highlighted for uncertainty"]
[]
[null,"QA highlight",100,null,"A cell that is highlighted for quality assurance"]
[]
[null,"Check pass",true,null,"A side calculation intended solely to cross check a result (and which therefore should not be referenced anywhere else in the model)"]
[null,"Check fail",false]
[]
[null,"Note or source","Text",null,"Note/source"]
[]
[null,"Named range",null,null,"Cells which are part of a named range"]
[]
[null,"Name","named_range_1",null,"An Excel Name applying to one or more adjacent cells (use Insert Name Create to actually create the Excel Names)"]
[]
[null,"Un-format",null,null,"Going back to default Excel formatting"]

{"sheet":"Inputs --->","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Spectrum cost inputs","index":3,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Cost inputs",null,null,null,null,null," "]
[]
[null,"Input parameters based on Plum model","Link to Plum report."]
[null,null,null,null,null,"Plum report page numder"]
[null,"Site sharing - Rural sites","Site occupants",3,null,113]
[null,"Site sharing - Urban sites","Site occupants",1,null,113]
[]
[null,"Equipment costs","£ / link",7000,null,113]
[]
[null,"Site construction - Rural","£ / site",100000,null,114]
[null,"Site construction - Urban","£ / site",10000,null,114]
[]
[null,"Site rental - Rural","£ / site / pa",1000,null,114]
[null,"Site rental - Urban","£ / site / pa",5000,null,114]
[]
[null,"Installation and commissioning","% of annual capital costs",0.5,null,114]
[null,"Accommodation and power","% of annual capital costs",0.5,null,115]
[null,"Maintenance","% of total capital costs",0.12,null,115]
[]
[null,"Lifetime of new equipment","Years",7,null,117]
[null,"Lifetime of structures","Years",20,null,117]

{"sheet":"MCT Cost Trends","index":4,"n_rows":162,"n_cols":57,"rows_kept":162,"cut":false,"hidden":false,"merged":[]}
["Source: 2021 MCT model"]
["https://www.ofcom.org.uk/consultations-and-statements/category-2/2021-26-wholesale-voice-markets-review"]
["https://www.ofcom.org.uk/__data/assets/file/0028/216793/mct-model-2021-26-wholesale-voice-markets-review.zip"]
["Cost model, \"Unit investment Worksheet\""]
[]
[]
[null,null,null,null,null,null,null,"1990/91","1991/92","1992/93","1993/94","1994/95","1995/96","1996/97","1997/98","1998/99","1999/00","2000/01","2001/02","2002/03","2003/04","2004/05","2005/06","2006/07","2007/08","2008/09","2009/10","2010/11","2011/12","2012/13","2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","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"]
[null,null,null,null,null,null,null,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039]
["Base MEA investment price trend (excluding capacity changes or RAN/Site sharing adjustments)",null,null,null,null,null,null,"Source: Retained from 2011 MCT model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: Orange and blue cells below indicate amendments based on s135 responses",null,null,null,null,"Source: Long-term values out to 2020/21 extended to 2026/27"]
[1,"spare","spare",null,"%"]
[2,"Cell sites","Macrocell: site acquisition and preparation and lease",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.15,-0.15,-0.15,7.0000000000000001E-3,7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,"2G cell site equipment","Macrocell: equipment (omni sector)",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-7.7200000000000005E-2,-6.6900000000000001E-2,-7.0000000000000007E-2,-0.06,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-0.42080000000000001,-0.42080000000000001,-0.42080000000000001,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.02,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,"spare","spare",null,"%"]
[5,"2G cell site equipment","Macrocell: equipment (2 sector)",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-7.7200000000000005E-2,-6.6900000000000001E-2,-7.0000000000000007E-2,-0.06,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-0.4,-0.4,-0.4,-5.7000000000000002E-2,-5.7000000000000002E-2,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.02,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,"spare","spare",null,"%"]
[7,"2G cell site equipment","Macrocell: equipment (3 sector)",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-7.7200000000000005E-2,-6.6900000000000001E-2,-7.0000000000000007E-2,-0.06,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-0.3201,-0.3201,-0.3201,-3.4000000000000002E-2,-3.4000000000000002E-2,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.02,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,"Cell sites","Microcell: site acquisition and preparation and lease",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.15,-0.15,-0.15,7.0000000000000001E-3,7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,"2G cell site equipment","Microcell: equipment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-7.7200000000000005E-2,-6.6900000000000001E-2,-7.0000000000000007E-2,-0.06,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-0.24560000000000001,-0.24560000000000001,-0.24560000000000001,4.1000000000000002E-2,4.1000000000000002E-2,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.02,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,"Cell sites","Picocell: site acquisition and preparation and lease",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.15,-0.15,-0.15,7.0000000000000001E-3,7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,"2G cell site equipment","Picocell: equipment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-7.7200000000000005E-2,-6.6900000000000001E-2,-7.0000000000000007E-2,-0.06,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-0.42080000000000001,-0.42080000000000001,-0.42080000000000001,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.04,-0.02,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,"2G TRXs","Macrocell: additional TRXs",null,"%",null,null,0,0,0,-0.05,-0.05,-0.05,-0.1,-0.1,-0.3,-0.3,-0.15,-0.1,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-5.62E-2,-5.62E-2,-5.62E-2,-8.0000000000000002E-3,-8.0000000000000002E-3,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"2G TRXs","Microcell: additional TRXs",null,"%",null,null,0,0,0,-0.05,-0.05,-0.05,-0.1,-0.1,-0.3,-0.3,-0.15,-0.1,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-5.62E-2,-5.62E-2,-5.62E-2,-8.0000000000000002E-3,-8.0000000000000002E-3,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,"2G TRXs","Picocell: additional TRXs",null,"%",null,null,0,0,0,-0.05,-0.05,-0.05,-0.1,-0.1,-0.3,-0.3,-0.15,-0.1,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-5.62E-2,-5.62E-2,-5.62E-2,-8.0000000000000002E-3,-8.0000000000000002E-3,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,-1.4999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,"2G BSCs","BSC: base unit",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.4,-0.4,-0.4,-0.4,5.5E-2,5.5E-2,5.5E-2,-0.26600000000000001,-0.26600000000000001,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,-1.5625E-4,-7.8125000000000002E-5,0,0,0,0,0,0,0,0,0,0,0,0,0]
[16,"2G BSCs","BSC: BS-facing port increment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.4,-0.4,-0.4,-0.4,5.5E-2,5.5E-2,5.5E-2,-0.26600000000000001,-0.26600000000000001,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,-1.5625E-4,-7.8125000000000002E-5,0,0,0,0,0,0,0,0,0,0,0,0,0]
[17,"2G BSCs","BSC: Core-facing port increment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.4,-0.4,-0.4,-0.4,5.5E-2,5.5E-2,5.5E-2,-0.26600000000000001,-0.26600000000000001,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,-1.5625E-4,-7.8125000000000002E-5,0,0,0,0,0,0,0,0,0,0,0,0,0]
[18,"2G BSCs","Packet control units",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.4,-0.4,-0.4,-0.4,5.5E-2,5.5E-2,5.5E-2,-0.26600000000000001,-0.26600000000000001,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-5.0000000000000001E-3,-2.5000000000000001E-3,-1.25E-3,-6.2500000000000001E-4,-3.1250000000000001E-4,-1.5625E-4,-7.8125000000000002E-5,0,0,0,0,0,0,0,0,0,0,0,0,0]
[19,"2G MSCs","MSC: processor",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[20,"2G MSCs","Software",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-4.1666666666666671E-2,-3.333333333333334E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[21,"2G MSCs","Interconnect interface",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-4.1666666666666671E-2,-3.333333333333334E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[22,"2G MSCs","Switching Support Plant",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-4.1666666666666671E-2,-3.333333333333334E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[23,"Main switch sites","Buildings (switch building preparation)",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.15,-0.15,-0.15,7.0000000000000001E-3,7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[24,"Main switch sites","Site lease",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.15,-0.15,-0.15,7.0000000000000001E-3,7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[25,"2G MSC ports - BSC-facing","MSC: BSC-facing port increment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[26,"2G MSC ports - Interconnect facing","MSC: interconnect-facing port increment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[27,"2G MSC ports - Interswitch facing","MSC: switch-facing port increment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[28,"Core transmission","Core transmission in 2Mbit/s circuits",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[29,"HLRs","HLR",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[30,"Transit switches","Transit switches",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[31,"spare","spare",null,"%"]
[32,"2G Licence fees","Annual GSM licence fee",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[33,"2G NMS","Network management",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-4.1666666666666671E-2,-3.333333333333334E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,-1.2500000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[34,"2G GSN","2G SGSN",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[35,"2G GSN","2G GGSN",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[36,"SMSC","SMSC",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-0.2,-0.2,-0.2,-0.2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[37,"Backhaul","2 Mbit/s microwave link",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[38,"Backhaul","8 Mbit/s microwave link",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[39,"Backhaul","16 Mbit/s microwave link",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[40,"Backhaul","32 Mbit/s microwave link",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[41,"spare","spare",null,"%"]
[42,"3G cell site equipment","Macrocell equipment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-0.38819999999999999,-0.38819999999999999,-0.38819999999999999,-6.9000000000000006E-2,-6.9000000000000006E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[43,"3G cell site equipment","Microcell equipment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-0.38819999999999999,-0.38819999999999999,-0.38819999999999999,-6.9000000000000006E-2,-6.9000000000000006E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[44,"3G cell site equipment","Picocell equipment",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.25,-0.2,-0.2,-0.15,-0.38819999999999999,-0.38819999999999999,-0.38819999999999999,-6.9000000000000006E-2,-6.9000000000000006E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[45,"3G site upgrade","Macro site upgrade",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-9.8199999999999996E-2,-9.8199999999999996E-2,-9.8199999999999996E-2,-3.3000000000000002E-2,-3.3000000000000002E-2,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[46,"3G site upgrade","Micro site upgrade",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.26800000000000002,-0.26800000000000002,-0.26800000000000002,-7.0000000000000001E-3,-7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[47,"3G site upgrade","Pico site upgrade",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.15,-0.15,-0.15,7.0000000000000001E-3,7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[48,"3G cell site equipment","Macrocell: additional carriers",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,0.1158,0.1158,0.1158,-5.8999999999999997E-2,-5.8999999999999997E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[49,"3G cell site equipment","Microcell: additional carriers",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,0.1158,0.1158,0.1158,-5.8999999999999997E-2,-5.8999999999999997E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[50,"3G cell site equipment","Picocell: additional carriers",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,0.1158,0.1158,0.1158,-5.8999999999999997E-2,-5.8999999999999997E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[51,"3G cell site equipment","Macrocell: additional sectors",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.13139999999999999,-0.13139999999999999,-0.13139999999999999,-5.8999999999999997E-2,-5.8999999999999997E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[52,"3G cell site equipment","Microcell: additional sectors",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.13139999999999999,-0.13139999999999999,-0.13139999999999999,-5.8999999999999997E-2,-5.8999999999999997E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[53,"3G cell site equipment","Picocell: additional sectors",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.13139999999999999,-0.13139999999999999,-0.13139999999999999,-5.8999999999999997E-2,-5.8999999999999997E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[54,"3G RNCs","RNC: base unit",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.35,-0.35,-0.4,-0.4,-5.5E-2,-5.5E-2,-5.5E-2,-5.5E-2,-5.5E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[55,"3G RNCs","RNC: NodeB-facing port increment",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.35,-0.35,-0.4,-0.4,-5.5E-2,-5.5E-2,-5.5E-2,-5.5E-2,-5.5E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[56,"3G RNCs","RNC: Core-facing port increment",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.35,-0.35,-0.4,-0.4,-5.5E-2,-5.5E-2,-5.5E-2,-5.5E-2,-5.5E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[57,"2G/3G layered core nodes","MSC server",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[58,"2G/3G layered core nodes","Media gateway",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[59,"3G MSCs","Interconnect interface",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[60,"3G MSCs","Switching Support Plant",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[61,"3G MSC ports - RNC-facing","MSC: BSC-facing port increment",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[62,"3G MSC ports - Interconnect facing","MSC: interconnect-facing port increment",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[63,"3G MSC ports - Interswitch facing","MSC: switch-facing port increment",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[64,"3G NMS","Network management",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[65,"3G GSN","3G SGSN",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[66,"3G GSN","3G GGSN",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.16,-0.12,-0.1,-0.09,-7.0000000000000007E-2,-0.06,-0.04,-0.04,-0.04,-0.04,-0.04,-3.3333333333333333E-2,-2.6666666666666665E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[67,"spare","spare",null,"%"]
[68,"Backhaul","Base unit",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.1,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-2.5000000000000001E-2,-0.05,-0.05,-0.05,-0.05,-0.03,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[69,"Remote switching sites","Remote switching sites (BSC and RNC)",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[70,"3G Licence fees","UMTS licence fee in 2004/05",null,"%"]
[71,"3G Licence fees","UMTS licence fee in 2012/13",null,"%"]
[72,"spare","spare",null,"%"]
[73,"spare","spare",null,"%"]
[74,"Cell sites","Transformation sites",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.15,-0.15,-0.15,7.0000000000000001E-3,7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[75,"spare","spare",null,"%"]
[76,"HSPA 3.6 upgrade","HSPA 3.6 site upgrade",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.03,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[77,"HSPA 7.2 upgrade","HSPA 7.2 site upgrade",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.03,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[78,"HSPA 14.4 upgrade","HSPA 14.4 site upgrade",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.03,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[79,"HSPA 21 upgrade","HSPA 21 site upgrade",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,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.03,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[80,"HSPA 42 upgrade","HSPA 42 site upgrade",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,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.03,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[81,"HSPA 84 upgrade","HSPA 84 site upgrade",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.03,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[82,"3G cell site equipment","HSPA site upgrade spare",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.03,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[83,"Backhaul","Leased Ethernet (100Mbit/s)",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,0,0,0,0,0,0,0,0,0,0,0,0,0]
[84,"Backhaul","Leased Ethernet (300Mbit/s)",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,0,0,0,0,0,0,0,0,0,0,0,0,0]
[85,"Backhaul","Owned microwave (100Mbit/s)",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.05,-7.8E-2,-7.8E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[86,"Backhaul","Owned microwave (300Mbit/s)",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.05,-7.8E-2,-7.8E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[87,"Cell sites","Shared sites",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.01,-0.15,-0.15,-0.15,7.0000000000000001E-3,7.0000000000000001E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[88,"spare","spare",null,"%"]
[89,"Backhaul","Ethernet microwave link (defunct)",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,0,0,0,0,0,0,0,0,0,0,0,0,0]
[90,"spare","spare",null,"%"]
[91,"VMS","VMS Platform",null,"%",null,null,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,-0.05,0,0,0,0,0,0,0,0,0,0,0,0,0]
[92,"Backhaul","High-speed backhaul hub",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.02,-4.1000000000000002E-2,-4.1000000000000002E-2,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,0,0,0,0,0,0,0,0,0,0,0,0,0]
[93,"Backhaul","High-speed leased backhaul link (1000Mbit/s)",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.02,-0.12,-0.12,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,0,0,0,0,0,0,0,0,0,0,0,0,0]
[94,"spare","spare",null,"%"]
[95,"spare","spare",null,"%"]
[96,"spare","spare",null,"%"]
[97,"Main switch sites (allocated to voice)","Buildings (switch building preparation) - allocated to voice services",null,"%",true,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[98,"Main switch sites (allocated to voice)","Site lease - allocated to voice services",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[99,"Main switch sites (allocated to data)","Buildings (switch building preparation) - allocated to data services",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[100,"Main switch sites (allocated to data)","Site lease - allocated to data services",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[101,"4G cell site equipment","Macro eNodeB",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,3.2000000000000001E-2,3.2000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[102,"4G cell site equipment","Micro eNodeB",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,3.2000000000000001E-2,3.2000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[103,"4G cell site equipment","Pico eNodeB",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,3.2000000000000001E-2,3.2000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[104,"4G cell site equipment","4G Macrocell: additional carriers",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,-0.02,-0.02,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[105,"4G cell site equipment","4G Microcell: additional carriers",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,-0.02,-0.02,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[106,"4G cell site equipment","4G Picocell: additional carriers",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,-0.02,-0.02,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[107,"4G site upgrade","Macro site upgrade",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,-8.9999999999999993E-3,-8.9999999999999993E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[108,"4G site upgrade","Micro site upgrade",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,-8.9999999999999993E-3,-8.9999999999999993E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[109,"4G site upgrade","Pico site upgrade",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,-8.9999999999999993E-3,-8.9999999999999993E-3,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[110,"Backhaul","Leased Ethernet (500Mbit/s)",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,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,-0.02,0,0,0,0,0,0,0,0,0,0,0,0,0]
[111,"Backhaul","Owned microwave (500Mbit/s)",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,-7.8E-2,-7.8E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[112,"Cell sites","Infrastructure sharing macro site upgrade",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,-0.17799999999999999,-0.17799999999999999,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[113,"Cell sites","Infrastructure sharing micro site upgrade",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,-0.17799999999999999,-0.17799999999999999,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[114,"Cell sites","Infrastructure sharing pico site upgrade",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,-0.17799999999999999,-0.17799999999999999,0.02,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[115,"spare","spare",null,"%"]
[116,"spare","spare",null,"%"]
[117,"spare","spare",null,"%"]
[118,"spare","spare",null,"%"]
[119,"spare","spare",null,"%"]
[120,"spare","spare",null,"%"]
[121,"spare","spare",null,"%"]
[122,"spare","spare",null,"%"]
[123,"spare","spare",null,"%"]
[124,"spare","spare",null,"%"]
[125,"spare","spare",null,"%"]
[126,"spare","spare",null,"%"]
[127,"spare","spare",null,"%"]
[128,"spare","spare",null,"%"]
[129,"Core transmission","Next-generation backbone links",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[130,"Core transmission","Next-generation backbone km",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[131,"4G core network","MME",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[132,"4G core network","Serving Gateway (SGW)",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[133,"4G core network","MME software",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[134,"4G core network","Data traffic manager",null,"%",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[135,"VoLTE network","Call server hardware",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[136,"VoLTE network","Call server software",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[137,"VoLTE network","TAS",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[138,"VoLTE network","SBC hardware",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[139,"VoLTE network","SBC software",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[140,"VoLTE network","VoLTE upgrades to HLR",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[141,"VoLTE network","VoLTE upgrades to MSC-S",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[142,"VoLTE network","VoLTE upgrades to NMS",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[143,"4G core network","NMS",null,"%",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,-0.05,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-2.5000000000000001E-2,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,0,0,0,0,0,0,0,0,0,0,0,0,0]
[144,"HLRs","HSS",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[145,"4G core network","spare",null,"%"]
[146,"4G core network","spare",null,"%"]
[147,"4G core network","spare",null,"%"]
[148,"4G core network","spare",null,"%"]
[149,"4G Licence fee","4G spectrum annual payments",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[150,"4G Licence fee","4G auction payments",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[148,"4G core network","spare",null,"%"]
[149,"4G Licence fee","4G spectrum annual payments",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-0.75616885346185247,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[150,"4G Licence fee","4G auction payments",null,"%"]

{"sheet":"Calculations --->","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cost Trend calc","index":6,"n_rows":172,"n_cols":31,"rows_kept":172,"cut":false,"hidden":false,"merged":[]}
["Cost trend calculation"]
[]
[null,null,null,null,null,2015,2016,2017,2018,2019,2020,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021]
[null,null,"CPI input - Annual change","CPI data Link",null,0,0.7,2.7,2.5,1.8,0.9,2.6]
[]
[null,"Annual change","Equipment (MCT model)","E",null,{"$f":"AVERAGEIF($D$24:$D$172,$D$6,F$24:F$172)","v":-2.6500000000000003E-2},{"$f":"AVERAGEIF($D$24:$D$172,$D$6,G$24:G$172)","v":-2.6500000000000003E-2},-2.6500000000000003E-2,-2.6500000000000003E-2,-2.4499999999999997E-2,-1.2E-2,-1.2E-2,-1.2E-2,-1.2E-2,-1.2E-2,-1.2E-2,-1.2E-2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Site (MCT model)","S",null,{"$f":"AVERAGEIF($D$24:$D$172,$D$7,F$24:F$172)","v":5.0000000000000001E-3},5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"CPI ","CPI",null,{"$f":"F4/100","v":0},6.9999999999999993E-3,2.7000000000000003E-2,2.5000000000000001E-2,1.8000000000000002E-2,9.0000000000000011E-3,2.6000000000000002E-2]
[]
[]
[null,"Index","Equipment",null,1,{"$f":"E11*(1+F6)","v":0.97350000000000003},{"$f":"F11*(1+G6)","v":0.94770225000000008},0.92258814037500014,0.89813955465506268,0.87613513556601363,0.86562151393922149,0.85523405577195077]
[null,null,"Site",null,1,1.0049999999999999,1.0100249999999997,1.0150751249999996,1.0150751249999996,1.0150751249999996,1.0150751249999996,1.0150751249999996]
[null,null,"CPI ",null,1,1,1.0069999999999999,1.0341889999999998,1.0600437249999997,1.0791245120499997,1.0888366326584495,1.1171463851075694]
[]
[null,null,"Combined increase over the period 2015-2022 for site costs"]
[null,null,"Cost trend adjustment factor for site costs",null,null,null,null,null,null,null,null,{"$f":"L12*L13","v":1.1339875065063636}]
[]
[]
[]
[null,null,null,"Identification of fixed link costs, Equipment (E ) or Site (S)"]
[null,null,null,null,{"$f":"'MCT Cost Trends'!AF8","v":2014},{"$f":"'MCT Cost Trends'!AG8","v":2015},{"$f":"'MCT Cost Trends'!AH8","v":2016},{"$f":"'MCT Cost Trends'!AI8","v":2017},{"$f":"'MCT Cost Trends'!AJ8","v":2018},{"$f":"'MCT Cost Trends'!AK8","v":2019},{"$f":"'MCT Cost Trends'!AL8","v":2020},{"$f":"'MCT Cost Trends'!AM8","v":2021},{"$f":"'MCT Cost Trends'!AN8","v":2022},{"$f":"'MCT Cost Trends'!AO8","v":2023},{"$f":"'MCT Cost Trends'!AP8","v":2024},{"$f":"'MCT Cost Trends'!AQ8","v":2025},{"$f":"'MCT Cost Trends'!AR8","v":2026},{"$f":"'MCT Cost Trends'!AS8","v":2027},{"$f":"'MCT Cost Trends'!AT8","v":2028},{"$f":"'MCT Cost Trends'!AU8","v":2029},{"$f":"'MCT Cost Trends'!AV8","v":2030},{"$f":"'MCT Cost Trends'!AW8","v":2031},{"$f":"'MCT Cost Trends'!AX8","v":2032},{"$f":"'MCT Cost Trends'!AY8","v":2033},{"$f":"'MCT Cost Trends'!AZ8","v":2034},{"$f":"'MCT Cost Trends'!BA8","v":2035},{"$f":"'MCT Cost Trends'!BB8","v":2036},{"$f":"'MCT Cost Trends'!BC8","v":2037},{"$f":"'MCT Cost Trends'!BD8","v":2038},{"$f":"'MCT Cost Trends'!BE8","v":2039}]
[null,null,null,null,{"$f":"'MCT Cost Trends'!AF9","v":"Source: Long-term values out to 2020/21 extended to 2026/27"},{"$f":"'MCT Cost Trends'!AG9","v":0},{"$f":"'MCT Cost Trends'!AH9","v":0},{"$f":"'MCT Cost Trends'!AI9","v":0},{"$f":"'MCT Cost Trends'!AJ9","v":0},{"$f":"'MCT Cost Trends'!AK9","v":0},{"$f":"'MCT Cost Trends'!AL9","v":0},{"$f":"'MCT Cost Trends'!AM9","v":0},{"$f":"'MCT Cost Trends'!AN9","v":0},{"$f":"'MCT Cost Trends'!AO9","v":0},{"$f":"'MCT Cost Trends'!AP9","v":0},{"$f":"'MCT Cost Trends'!AQ9","v":0},{"$f":"'MCT Cost Trends'!AR9","v":0},{"$f":"'MCT Cost Trends'!AS9","v":0},{"$f":"'MCT Cost Trends'!AT9","v":0},{"$f":"'MCT Cost Trends'!AU9","v":0},{"$f":"'MCT Cost Trends'!AV9","v":0},{"$f":"'MCT Cost Trends'!AW9","v":0},{"$f":"'MCT Cost Trends'!AX9","v":0},{"$f":"'MCT Cost Trends'!AY9","v":0},{"$f":"'MCT Cost Trends'!AZ9","v":0},{"$f":"'MCT Cost Trends'!BA9","v":0},{"$f":"'MCT Cost Trends'!BB9","v":0},{"$f":"'MCT Cost Trends'!BC9","v":0},{"$f":"'MCT Cost Trends'!BD9","v":0},{"$f":"'MCT Cost Trends'!BE9","v":0}]
[1,"spare","spare"]
[2,"Cell sites","Macrocell: site acquisition and preparation and lease","S",{"$f":"'MCT Cost Trends'!AF11","v":0.02},{"$f":"'MCT Cost Trends'!AG11","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AH11","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AI11","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AJ11","v":0},{"$f":"'MCT Cost Trends'!AK11","v":0},{"$f":"'MCT Cost Trends'!AL11","v":0},{"$f":"'MCT Cost Trends'!AM11","v":0},{"$f":"'MCT Cost Trends'!AN11","v":0},{"$f":"'MCT Cost Trends'!AO11","v":0},{"$f":"'MCT Cost Trends'!AP11","v":0},{"$f":"'MCT Cost Trends'!AQ11","v":0},{"$f":"'MCT Cost Trends'!AR11","v":0},{"$f":"'MCT Cost Trends'!AS11","v":0},{"$f":"'MCT Cost Trends'!AT11","v":0},{"$f":"'MCT Cost Trends'!AU11","v":0},{"$f":"'MCT Cost Trends'!AV11","v":0},{"$f":"'MCT Cost Trends'!AW11","v":0},{"$f":"'MCT Cost Trends'!AX11","v":0},{"$f":"'MCT Cost Trends'!AY11","v":0},{"$f":"'MCT Cost Trends'!AZ11","v":0},{"$f":"'MCT Cost Trends'!BA11","v":0},{"$f":"'MCT Cost Trends'!BB11","v":0},{"$f":"'MCT Cost Trends'!BC11","v":0},{"$f":"'MCT Cost Trends'!BD11","v":0},{"$f":"'MCT Cost Trends'!BE11","v":0}]
[3,"2G cell site equipment","Macrocell: equipment (omni sector)"]
[4,"spare","spare"]
[5,"2G cell site equipment","Macrocell: equipment (2 sector)"]
[6,"spare","spare"]
[7,"2G cell site equipment","Macrocell: equipment (3 sector)"]
[8,"Cell sites","Microcell: site acquisition and preparation and lease","S",{"$f":"'MCT Cost Trends'!AF17","v":0.02},{"$f":"'MCT Cost Trends'!AG17","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AH17","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AI17","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AJ17","v":0},{"$f":"'MCT Cost Trends'!AK17","v":0},{"$f":"'MCT Cost Trends'!AL17","v":0},{"$f":"'MCT Cost Trends'!AM17","v":0},{"$f":"'MCT Cost Trends'!AN17","v":0},{"$f":"'MCT Cost Trends'!AO17","v":0},{"$f":"'MCT Cost Trends'!AP17","v":0},{"$f":"'MCT Cost Trends'!AQ17","v":0},{"$f":"'MCT Cost Trends'!AR17","v":0},{"$f":"'MCT Cost Trends'!AS17","v":0},{"$f":"'MCT Cost Trends'!AT17","v":0},{"$f":"'MCT Cost Trends'!AU17","v":0},{"$f":"'MCT Cost Trends'!AV17","v":0},{"$f":"'MCT Cost Trends'!AW17","v":0},{"$f":"'MCT Cost Trends'!AX17","v":0},{"$f":"'MCT Cost Trends'!AY17","v":0},{"$f":"'MCT Cost Trends'!AZ17","v":0},{"$f":"'MCT Cost Trends'!BA17","v":0},{"$f":"'MCT Cost Trends'!BB17","v":0},{"$f":"'MCT Cost Trends'!BC17","v":0},{"$f":"'MCT Cost Trends'!BD17","v":0},{"$f":"'MCT Cost Trends'!BE17","v":0}]
[9,"2G cell site equipment","Microcell: equipment"]
[10,"Cell sites","Picocell: site acquisition and preparation and lease","S",{"$f":"'MCT Cost Trends'!AF19","v":0.02},{"$f":"'MCT Cost Trends'!AG19","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AH19","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AI19","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AJ19","v":0},{"$f":"'MCT Cost Trends'!AK19","v":0},{"$f":"'MCT Cost Trends'!AL19","v":0},{"$f":"'MCT Cost Trends'!AM19","v":0},{"$f":"'MCT Cost Trends'!AN19","v":0},{"$f":"'MCT Cost Trends'!AO19","v":0},{"$f":"'MCT Cost Trends'!AP19","v":0},{"$f":"'MCT Cost Trends'!AQ19","v":0},{"$f":"'MCT Cost Trends'!AR19","v":0},{"$f":"'MCT Cost Trends'!AS19","v":0},{"$f":"'MCT Cost Trends'!AT19","v":0},{"$f":"'MCT Cost Trends'!AU19","v":0},{"$f":"'MCT Cost Trends'!AV19","v":0},{"$f":"'MCT Cost Trends'!AW19","v":0},{"$f":"'MCT Cost Trends'!AX19","v":0},{"$f":"'MCT Cost Trends'!AY19","v":0},{"$f":"'MCT Cost Trends'!AZ19","v":0},{"$f":"'MCT Cost Trends'!BA19","v":0},{"$f":"'MCT Cost Trends'!BB19","v":0},{"$f":"'MCT Cost Trends'!BC19","v":0},{"$f":"'MCT Cost Trends'!BD19","v":0},{"$f":"'MCT Cost Trends'!BE19","v":0}]
[11,"2G cell site equipment","Picocell: equipment"]
[12,"2G TRXs","Macrocell: additional TRXs"]
[13,"2G TRXs","Microcell: additional TRXs"]
[14,"2G TRXs","Picocell: additional TRXs"]
[15,"2G BSCs","BSC: base unit"]
[16,"2G BSCs","BSC: BS-facing port increment"]
[17,"2G BSCs","BSC: Core-facing port increment"]
[18,"2G BSCs","Packet control units"]
[19,"2G MSCs","MSC: processor"]
[20,"2G MSCs","Software"]
[21,"2G MSCs","Interconnect interface"]
[22,"2G MSCs","Switching Support Plant"]
[23,"Main switch sites","Buildings (switch building preparation)"]
[24,"Main switch sites","Site lease"]
[25,"2G MSC ports - BSC-facing","MSC: BSC-facing port increment"]
[26,"2G MSC ports - Interconnect facing","MSC: interconnect-facing port increment"]
[27,"2G MSC ports - Interswitch facing","MSC: switch-facing port increment"]
[28,"Core transmission","Core transmission in 2Mbit/s circuits"]
[29,"HLRs","HLR"]
[30,"Transit switches","Transit switches"]
[31,"spare","spare"]
[32,"2G Licence fees","Annual GSM licence fee"]
[33,"2G NMS","Network management"]
[34,"2G GSN","2G SGSN"]
[35,"2G GSN","2G GGSN"]
[36,"SMSC","SMSC"]
[37,"Backhaul","2 Mbit/s microwave link","E",{"$f":"'MCT Cost Trends'!AF46","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AG46","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AH46","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AI46","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AJ46","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AK46","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AL46","v":-0.01},{"$f":"'MCT Cost Trends'!AM46","v":-0.01},{"$f":"'MCT Cost Trends'!AN46","v":-0.01},{"$f":"'MCT Cost Trends'!AO46","v":-0.01},{"$f":"'MCT Cost Trends'!AP46","v":-0.01},{"$f":"'MCT Cost Trends'!AQ46","v":-0.01},{"$f":"'MCT Cost Trends'!AR46","v":-0.01},{"$f":"'MCT Cost Trends'!AS46","v":0},{"$f":"'MCT Cost Trends'!AT46","v":0},{"$f":"'MCT Cost Trends'!AU46","v":0},{"$f":"'MCT Cost Trends'!AV46","v":0},{"$f":"'MCT Cost Trends'!AW46","v":0},{"$f":"'MCT Cost Trends'!AX46","v":0},{"$f":"'MCT Cost Trends'!AY46","v":0},{"$f":"'MCT Cost Trends'!AZ46","v":0},{"$f":"'MCT Cost Trends'!BA46","v":0},{"$f":"'MCT Cost Trends'!BB46","v":0},{"$f":"'MCT Cost Trends'!BC46","v":0},{"$f":"'MCT Cost Trends'!BD46","v":0},{"$f":"'MCT Cost Trends'!BE46","v":0}]
[38,"Backhaul","8 Mbit/s microwave link","E",{"$f":"'MCT Cost Trends'!AF47","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AG47","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AH47","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AI47","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AJ47","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AK47","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AL47","v":-0.01},{"$f":"'MCT Cost Trends'!AM47","v":-0.01},{"$f":"'MCT Cost Trends'!AN47","v":-0.01},{"$f":"'MCT Cost Trends'!AO47","v":-0.01},{"$f":"'MCT Cost Trends'!AP47","v":-0.01},{"$f":"'MCT Cost Trends'!AQ47","v":-0.01},{"$f":"'MCT Cost Trends'!AR47","v":-0.01},{"$f":"'MCT Cost Trends'!AS47","v":0},{"$f":"'MCT Cost Trends'!AT47","v":0},{"$f":"'MCT Cost Trends'!AU47","v":0},{"$f":"'MCT Cost Trends'!AV47","v":0},{"$f":"'MCT Cost Trends'!AW47","v":0},{"$f":"'MCT Cost Trends'!AX47","v":0},{"$f":"'MCT Cost Trends'!AY47","v":0},{"$f":"'MCT Cost Trends'!AZ47","v":0},{"$f":"'MCT Cost Trends'!BA47","v":0},{"$f":"'MCT Cost Trends'!BB47","v":0},{"$f":"'MCT Cost Trends'!BC47","v":0},{"$f":"'MCT Cost Trends'!BD47","v":0},{"$f":"'MCT Cost Trends'!BE47","v":0}]
[39,"Backhaul","16 Mbit/s microwave link","E",{"$f":"'MCT Cost Trends'!AF48","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AG48","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AH48","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AI48","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AJ48","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AK48","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AL48","v":-0.01},{"$f":"'MCT Cost Trends'!AM48","v":-0.01},{"$f":"'MCT Cost Trends'!AN48","v":-0.01},{"$f":"'MCT Cost Trends'!AO48","v":-0.01},{"$f":"'MCT Cost Trends'!AP48","v":-0.01},{"$f":"'MCT Cost Trends'!AQ48","v":-0.01},{"$f":"'MCT Cost Trends'!AR48","v":-0.01},{"$f":"'MCT Cost Trends'!AS48","v":0},{"$f":"'MCT Cost Trends'!AT48","v":0},{"$f":"'MCT Cost Trends'!AU48","v":0},{"$f":"'MCT Cost Trends'!AV48","v":0},{"$f":"'MCT Cost Trends'!AW48","v":0},{"$f":"'MCT Cost Trends'!AX48","v":0},{"$f":"'MCT Cost Trends'!AY48","v":0},{"$f":"'MCT Cost Trends'!AZ48","v":0},{"$f":"'MCT Cost Trends'!BA48","v":0},{"$f":"'MCT Cost Trends'!BB48","v":0},{"$f":"'MCT Cost Trends'!BC48","v":0},{"$f":"'MCT Cost Trends'!BD48","v":0},{"$f":"'MCT Cost Trends'!BE48","v":0}]
[40,"Backhaul","32 Mbit/s microwave link","E",{"$f":"'MCT Cost Trends'!AF49","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AG49","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AH49","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AI49","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AJ49","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AK49","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AL49","v":-0.01},{"$f":"'MCT Cost Trends'!AM49","v":-0.01},{"$f":"'MCT Cost Trends'!AN49","v":-0.01},{"$f":"'MCT Cost Trends'!AO49","v":-0.01},{"$f":"'MCT Cost Trends'!AP49","v":-0.01},{"$f":"'MCT Cost Trends'!AQ49","v":-0.01},{"$f":"'MCT Cost Trends'!AR49","v":-0.01},{"$f":"'MCT Cost Trends'!AS49","v":0},{"$f":"'MCT Cost Trends'!AT49","v":0},{"$f":"'MCT Cost Trends'!AU49","v":0},{"$f":"'MCT Cost Trends'!AV49","v":0},{"$f":"'MCT Cost Trends'!AW49","v":0},{"$f":"'MCT Cost Trends'!AX49","v":0},{"$f":"'MCT Cost Trends'!AY49","v":0},{"$f":"'MCT Cost Trends'!AZ49","v":0},{"$f":"'MCT Cost Trends'!BA49","v":0},{"$f":"'MCT Cost Trends'!BB49","v":0},{"$f":"'MCT Cost Trends'!BC49","v":0},{"$f":"'MCT Cost Trends'!BD49","v":0},{"$f":"'MCT Cost Trends'!BE49","v":0}]
[41,"spare","spare"]
[42,"3G cell site equipment","Macrocell equipment"]
[43,"3G cell site equipment","Microcell equipment"]
[44,"3G cell site equipment","Picocell equipment"]
[45,"3G site upgrade","Macro site upgrade"]
[46,"3G site upgrade","Micro site upgrade"]
[47,"3G site upgrade","Pico site upgrade"]
[48,"3G cell site equipment","Macrocell: additional carriers"]
[49,"3G cell site equipment","Microcell: additional carriers"]
[50,"3G cell site equipment","Picocell: additional carriers"]
[51,"3G cell site equipment","Macrocell: additional sectors"]
[52,"3G cell site equipment","Microcell: additional sectors"]
[53,"3G cell site equipment","Picocell: additional sectors"]
[54,"3G RNCs","RNC: base unit"]
[55,"3G RNCs","RNC: NodeB-facing port increment"]
[56,"3G RNCs","RNC: Core-facing port increment"]
[57,"2G/3G layered core nodes","MSC server"]
[58,"2G/3G layered core nodes","Media gateway"]
[59,"3G MSCs","Interconnect interface"]
[60,"3G MSCs","Switching Support Plant"]
[61,"3G MSC ports - RNC-facing","MSC: BSC-facing port increment"]
[62,"3G MSC ports - Interconnect facing","MSC: interconnect-facing port increment"]
[63,"3G MSC ports - Interswitch facing","MSC: switch-facing port increment"]
[64,"3G NMS","Network management"]
[65,"3G GSN","3G SGSN"]
[66,"3G GSN","3G GGSN"]
[67,"spare","spare"]
[68,"Backhaul","Base unit","E",{"$f":"'MCT Cost Trends'!AF77","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AG77","v":-0.05},{"$f":"'MCT Cost Trends'!AH77","v":-0.05},{"$f":"'MCT Cost Trends'!AI77","v":-0.05},{"$f":"'MCT Cost Trends'!AJ77","v":-0.05},{"$f":"'MCT Cost Trends'!AK77","v":-0.03},{"$f":"'MCT Cost Trends'!AL77","v":-0.01},{"$f":"'MCT Cost Trends'!AM77","v":-0.01},{"$f":"'MCT Cost Trends'!AN77","v":-0.01},{"$f":"'MCT Cost Trends'!AO77","v":-0.01},{"$f":"'MCT Cost Trends'!AP77","v":-0.01},{"$f":"'MCT Cost Trends'!AQ77","v":-0.01},{"$f":"'MCT Cost Trends'!AR77","v":-0.01},{"$f":"'MCT Cost Trends'!AS77","v":0},{"$f":"'MCT Cost Trends'!AT77","v":0},{"$f":"'MCT Cost Trends'!AU77","v":0},{"$f":"'MCT Cost Trends'!AV77","v":0},{"$f":"'MCT Cost Trends'!AW77","v":0},{"$f":"'MCT Cost Trends'!AX77","v":0},{"$f":"'MCT Cost Trends'!AY77","v":0},{"$f":"'MCT Cost Trends'!AZ77","v":0},{"$f":"'MCT Cost Trends'!BA77","v":0},{"$f":"'MCT Cost Trends'!BB77","v":0},{"$f":"'MCT Cost Trends'!BC77","v":0},{"$f":"'MCT Cost Trends'!BD77","v":0},{"$f":"'MCT Cost Trends'!BE77","v":0},{"$f":"'MCT Cost Trends'!BF80","v":0}]
[69,"Remote switching sites","Remote switching sites (BSC and RNC)"]
[70,"3G Licence fees","UMTS licence fee in 2004/05"]
[71,"3G Licence fees","UMTS licence fee in 2012/13"]
[72,"spare","spare"]
[73,"spare","spare"]
[74,"Cell sites","Transformation sites"]
[75,"spare","spare"]
[76,"HSPA 3.6 upgrade","HSPA 3.6 site upgrade"]
[77,"HSPA 7.2 upgrade","HSPA 7.2 site upgrade"]
[78,"HSPA 14.4 upgrade","HSPA 14.4 site upgrade"]
[79,"HSPA 21 upgrade","HSPA 21 site upgrade"]
[80,"HSPA 42 upgrade","HSPA 42 site upgrade"]
[81,"HSPA 84 upgrade","HSPA 84 site upgrade"]
[82,"3G cell site equipment","HSPA site upgrade spare"]
[83,"Backhaul","Leased Ethernet (100Mbit/s)"]
[84,"Backhaul","Leased Ethernet (300Mbit/s)"]
[85,"Backhaul","Owned microwave (100Mbit/s)","E",{"$f":"'MCT Cost Trends'!AF94","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AG94","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AH94","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AI94","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AJ94","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AK94","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AL94","v":-0.01},{"$f":"'MCT Cost Trends'!AM94","v":-0.01},{"$f":"'MCT Cost Trends'!AN94","v":-0.01},{"$f":"'MCT Cost Trends'!AO94","v":-0.01},{"$f":"'MCT Cost Trends'!AP94","v":-0.01},{"$f":"'MCT Cost Trends'!AQ94","v":-0.01},{"$f":"'MCT Cost Trends'!AR94","v":-0.01},{"$f":"'MCT Cost Trends'!AS94","v":0},{"$f":"'MCT Cost Trends'!AT94","v":0},{"$f":"'MCT Cost Trends'!AU94","v":0},{"$f":"'MCT Cost Trends'!AV94","v":0},{"$f":"'MCT Cost Trends'!AW94","v":0},{"$f":"'MCT Cost Trends'!AX94","v":0},{"$f":"'MCT Cost Trends'!AY94","v":0},{"$f":"'MCT Cost Trends'!AZ94","v":0},{"$f":"'MCT Cost Trends'!BA94","v":0},{"$f":"'MCT Cost Trends'!BB94","v":0},{"$f":"'MCT Cost Trends'!BC94","v":0},{"$f":"'MCT Cost Trends'!BD94","v":0},{"$f":"'MCT Cost Trends'!BE94","v":0}]
[86,"Backhaul","Owned microwave (300Mbit/s)","E",{"$f":"'MCT Cost Trends'!AF95","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AG95","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AH95","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AI95","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AJ95","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AK95","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AL95","v":-0.01},{"$f":"'MCT Cost Trends'!AM95","v":-0.01},{"$f":"'MCT Cost Trends'!AN95","v":-0.01},{"$f":"'MCT Cost Trends'!AO95","v":-0.01},{"$f":"'MCT Cost Trends'!AP95","v":-0.01},{"$f":"'MCT Cost Trends'!AQ95","v":-0.01},{"$f":"'MCT Cost Trends'!AR95","v":-0.01},{"$f":"'MCT Cost Trends'!AS95","v":0},{"$f":"'MCT Cost Trends'!AT95","v":0},{"$f":"'MCT Cost Trends'!AU95","v":0},{"$f":"'MCT Cost Trends'!AV95","v":0},{"$f":"'MCT Cost Trends'!AW95","v":0},{"$f":"'MCT Cost Trends'!AX95","v":0},{"$f":"'MCT Cost Trends'!AY95","v":0},{"$f":"'MCT Cost Trends'!AZ95","v":0},{"$f":"'MCT Cost Trends'!BA95","v":0},{"$f":"'MCT Cost Trends'!BB95","v":0},{"$f":"'MCT Cost Trends'!BC95","v":0},{"$f":"'MCT Cost Trends'!BD95","v":0},{"$f":"'MCT Cost Trends'!BE95","v":0}]
[87,"Cell sites","Shared sites","S",{"$f":"'MCT Cost Trends'!AF96","v":0.02},{"$f":"'MCT Cost Trends'!AG96","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AH96","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AI96","v":5.0000000000000001E-3},{"$f":"'MCT Cost Trends'!AJ96","v":0},{"$f":"'MCT Cost Trends'!AK96","v":0},{"$f":"'MCT Cost Trends'!AL96","v":0},{"$f":"'MCT Cost Trends'!AM96","v":0},{"$f":"'MCT Cost Trends'!AN96","v":0},{"$f":"'MCT Cost Trends'!AO96","v":0},{"$f":"'MCT Cost Trends'!AP96","v":0},{"$f":"'MCT Cost Trends'!AQ96","v":0},{"$f":"'MCT Cost Trends'!AR96","v":0},{"$f":"'MCT Cost Trends'!AS96","v":0},{"$f":"'MCT Cost Trends'!AT96","v":0},{"$f":"'MCT Cost Trends'!AU96","v":0},{"$f":"'MCT Cost Trends'!AV96","v":0},{"$f":"'MCT Cost Trends'!AW96","v":0},{"$f":"'MCT Cost Trends'!AX96","v":0},{"$f":"'MCT Cost Trends'!AY96","v":0},{"$f":"'MCT Cost Trends'!AZ96","v":0},{"$f":"'MCT Cost Trends'!BA96","v":0},{"$f":"'MCT Cost Trends'!BB96","v":0},{"$f":"'MCT Cost Trends'!BC96","v":0},{"$f":"'MCT Cost Trends'!BD96","v":0},{"$f":"'MCT Cost Trends'!BE96","v":0}]
[88,"spare","spare"]
[89,"Backhaul","Ethernet microwave link (defunct)"]
[90,"spare","spare"]
[91,"VMS","VMS Platform"]
[92,"Backhaul","High-speed backhaul hub","E",{"$f":"'MCT Cost Trends'!AF101","v":-0.02},{"$f":"'MCT Cost Trends'!AG101","v":-0.02},{"$f":"'MCT Cost Trends'!AH101","v":-0.02},{"$f":"'MCT Cost Trends'!AI101","v":-0.02},{"$f":"'MCT Cost Trends'!AJ101","v":-0.02},{"$f":"'MCT Cost Trends'!AK101","v":-0.02},{"$f":"'MCT Cost Trends'!AL101","v":-0.02},{"$f":"'MCT Cost Trends'!AM101","v":-0.02},{"$f":"'MCT Cost Trends'!AN101","v":-0.02},{"$f":"'MCT Cost Trends'!AO101","v":-0.02},{"$f":"'MCT Cost Trends'!AP101","v":-0.02},{"$f":"'MCT Cost Trends'!AQ101","v":-0.02},{"$f":"'MCT Cost Trends'!AR101","v":-0.02},{"$f":"'MCT Cost Trends'!AS101","v":0},{"$f":"'MCT Cost Trends'!AT101","v":0},{"$f":"'MCT Cost Trends'!AU101","v":0},{"$f":"'MCT Cost Trends'!AV101","v":0},{"$f":"'MCT Cost Trends'!AW101","v":0},{"$f":"'MCT Cost Trends'!AX101","v":0},{"$f":"'MCT Cost Trends'!AY101","v":0},{"$f":"'MCT Cost Trends'!AZ101","v":0},{"$f":"'MCT Cost Trends'!BA101","v":0},{"$f":"'MCT Cost Trends'!BB101","v":0},{"$f":"'MCT Cost Trends'!BC101","v":0},{"$f":"'MCT Cost Trends'!BD101","v":0},{"$f":"'MCT Cost Trends'!BE101","v":0}]
[93,"Backhaul","High-speed leased backhaul link (1000Mbit/s)","E",{"$f":"'MCT Cost Trends'!AF102","v":-0.02},{"$f":"'MCT Cost Trends'!AG102","v":-0.02},{"$f":"'MCT Cost Trends'!AH102","v":-0.02},{"$f":"'MCT Cost Trends'!AI102","v":-0.02},{"$f":"'MCT Cost Trends'!AJ102","v":-0.02},{"$f":"'MCT Cost Trends'!AK102","v":-0.02},{"$f":"'MCT Cost Trends'!AL102","v":-0.02},{"$f":"'MCT Cost Trends'!AM102","v":-0.02},{"$f":"'MCT Cost Trends'!AN102","v":-0.02},{"$f":"'MCT Cost Trends'!AO102","v":-0.02},{"$f":"'MCT Cost Trends'!AP102","v":-0.02},{"$f":"'MCT Cost Trends'!AQ102","v":-0.02},{"$f":"'MCT Cost Trends'!AR102","v":-0.02},{"$f":"'MCT Cost Trends'!AS102","v":0},{"$f":"'MCT Cost Trends'!AT102","v":0},{"$f":"'MCT Cost Trends'!AU102","v":0},{"$f":"'MCT Cost Trends'!AV102","v":0},{"$f":"'MCT Cost Trends'!AW102","v":0},{"$f":"'MCT Cost Trends'!AX102","v":0},{"$f":"'MCT Cost Trends'!AY102","v":0},{"$f":"'MCT Cost Trends'!AZ102","v":0},{"$f":"'MCT Cost Trends'!BA102","v":0},{"$f":"'MCT Cost Trends'!BB102","v":0},{"$f":"'MCT Cost Trends'!BC102","v":0},{"$f":"'MCT Cost Trends'!BD102","v":0},{"$f":"'MCT Cost Trends'!BE102","v":0}]
[94,"spare","spare"]
[95,"spare","spare"]
[96,"spare","spare"]
[97,"Main switch sites (allocated to voice)","Buildings (switch building preparation) - allocated to voice services"]
[98,"Main switch sites (allocated to voice)","Site lease - allocated to voice services"]
[99,"Main switch sites (allocated to data)","Buildings (switch building preparation) - allocated to data services"]
[100,"Main switch sites (allocated to data)","Site lease - allocated to data services"]
[101,"4G cell site equipment","Macro eNodeB"]
[102,"4G cell site equipment","Micro eNodeB"]
[103,"4G cell site equipment","Pico eNodeB"]
[104,"4G cell site equipment","4G Macrocell: additional carriers"]
[105,"4G cell site equipment","4G Microcell: additional carriers"]
[106,"4G cell site equipment","4G Picocell: additional carriers"]
[107,"4G site upgrade","Macro site upgrade"]
[108,"4G site upgrade","Micro site upgrade"]
[109,"4G site upgrade","Pico site upgrade"]
[110,"Backhaul","Leased Ethernet (500Mbit/s)"]
[111,"Backhaul","Owned microwave (500Mbit/s)","E",{"$f":"'MCT Cost Trends'!AF120","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AG120","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AH120","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AI120","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AJ120","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AK120","v":-2.5000000000000001E-2},{"$f":"'MCT Cost Trends'!AL120","v":-0.01},{"$f":"'MCT Cost Trends'!AM120","v":-0.01},{"$f":"'MCT Cost Trends'!AN120","v":-0.01},{"$f":"'MCT Cost Trends'!AO120","v":-0.01},{"$f":"'MCT Cost Trends'!AP120","v":-0.01},{"$f":"'MCT Cost Trends'!AQ120","v":-0.01},{"$f":"'MCT Cost Trends'!AR120","v":-0.01},{"$f":"'MCT Cost Trends'!AS120","v":0},{"$f":"'MCT Cost Trends'!AT120","v":0},{"$f":"'MCT Cost Trends'!AU120","v":0},{"$f":"'MCT Cost Trends'!AV120","v":0},{"$f":"'MCT Cost Trends'!AW120","v":0},{"$f":"'MCT Cost Trends'!AX120","v":0},{"$f":"'MCT Cost Trends'!AY120","v":0},{"$f":"'MCT Cost Trends'!AZ120","v":0},{"$f":"'MCT Cost Trends'!BA120","v":0},{"$f":"'MCT Cost Trends'!BB120","v":0},{"$f":"'MCT Cost Trends'!BC120","v":0},{"$f":"'MCT Cost Trends'!BD120","v":0},{"$f":"'MCT Cost Trends'!BE120","v":0}]
[112,"Cell sites","Infrastructure sharing macro site upgrade"]
[113,"Cell sites","Infrastructure sharing micro site upgrade"]
[114,"Cell sites","Infrastructure sharing pico site upgrade"]
[115,"spare","spare"]
[116,"spare","spare"]
[117,"spare","spare"]
[118,"spare","spare"]
[119,"spare","spare"]
[120,"spare","spare"]
[121,"spare","spare"]
[122,"spare","spare"]
[123,"spare","spare"]
[124,"spare","spare"]
[125,"spare","spare"]
[126,"spare","spare"]
[127,"spare","spare"]
[128,"spare","spare"]
[129,"Core transmission","Next-generation backbone links"]
[130,"Core transmission","Next-generation backbone km"]
[131,"4G core network","MME"]
[132,"4G core network","Serving Gateway (SGW)"]
[133,"4G core network","MME software"]
[134,"4G core network","Data traffic manager"]
[135,"VoLTE network","Call server hardware"]
[136,"VoLTE network","Call server software"]
[137,"VoLTE network","TAS"]
[138,"VoLTE network","SBC hardware"]
[139,"VoLTE network","SBC software"]
[140,"VoLTE network","VoLTE upgrades to HLR"]
[141,"VoLTE network","VoLTE upgrades to MSC-S"]
[142,"VoLTE network","VoLTE upgrades to NMS"]
[143,"4G core network","NMS"]
[144,"HLRs","HSS"]
[145,"4G core network","spare"]
[146,"4G core network","spare"]
[147,"4G core network","spare"]
[148,"4G core network","spare"]
[149,"4G Licence fee","4G spectrum annual payments"]
[150,"4G Licence fee","4G auction payments"]

{"sheet":"Cost calculations","index":7,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,7,24,8]]}
["Cost calculations",null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,"OPEX percentages"]
[]
[null,"Installation cost",{"$f":"'Spectrum cost inputs'!D16","v":0.5},"per_installation_cost","Of annualised capex"]
[null,"Infrastructure cost",{"$f":"'Spectrum cost inputs'!D17","v":0.5},"per_infrastructure_cost","Of annualised capex"]
[null,"Maintenance cost",{"$f":"'Spectrum cost inputs'!D18","v":0.12},"per_maintenance_cost","Of capex"]
[]
[null,"Annualised equipment cost (exc, installation)",{"$f":"-PMT('Discounted cost_7years'!finance_rate,'Discounted cost_7years'!equipment_lifetime,'Discounted cost_7years'!equipment_capital,,1)","v":1173.7056405768335}]
[]
[null,"Cost for additional hop above 20 GHz"]
[]
[null,null,"Site cost - construction","Site cost - rental","Equipment cost - capital","Equipment cost - Install, infrastructure and maintenance","Total","Equipment lifetime","New equipment purchases required in model","Structures lifetime","New structure purchases required in model"]
[null,null,"CAPEX","OPEX","CAPEX","OPEX","OPEX",null,{"$f":"'Discounted cost_7years'!time_horizon","v":20},null,{"$f":"'Discounted cost_7years'!time_horizon","v":20}]
[null,"Rural",{"$f":"sitecost_rural","v":100000},{"$f":"'Spectrum cost inputs'!D13/'Spectrum cost inputs'!D5","v":333.33333333333331},{"$f":"Equipment","v":7000},{"$f":"per_installation_cost*$C$10+per_infrastructure_cost*+$C$10+per_maintenance_cost*'Cost calculations'!E16","v":2013.7056405768335},{"$f":"SUMIF($C$15:$F$15, $G$15,C16:F16)","v":2347.038973910167},{"$f":"'Discounted cost_7years'!equipment_lifetime","v":7},{"$f":"ROUNDUP(I$15/H16, 0)","v":3},{"$f":"'Discounted cost_7years'!structure_lifetime","v":20},{"$f":"ROUNDUP(K$15/J16, 0)","v":1}]
[null,"Urban",{"$f":"sitecost_urban","v":10000},{"$f":"'Spectrum cost inputs'!D14/'Spectrum cost inputs'!D6","v":5000},{"$f":"Equipment","v":7000},{"$f":"per_installation_cost*$C$10+per_infrastructure_cost*+$C$10+per_maintenance_cost*'Cost calculations'!E17","v":2013.7056405768335},{"$f":"SUMIF($C$15:$F$15, $G$15,C17:F17)","v":7013.7056405768335},{"$f":"'Discounted cost_7years'!equipment_lifetime","v":7},{"$f":"ROUNDUP(I$15/H17, 0)","v":3},{"$f":"'Discounted cost_7years'!structure_lifetime","v":20},{"$f":"ROUNDUP(K$15/J17, 0)","v":1}]
[]
[]
[]
[null,"Apply cost trend to site costs"]
[null,null,"CAPEX","OPEX","CAPEX","OPEX","OPEX",null,{"$f":"'Discounted cost_7years'!time_horizon","v":20},null,{"$f":"'Discounted cost_7years'!time_horizon","v":20}]
[null,"Rural",{"$f":"C16*'Cost Trend calc'!$L$16","v":113398.75065063636},{"$f":"D16*'Cost Trend calc'!$L$16","v":377.99583550212117},{"$f":"Equipment","v":7000},{"$f":"per_installation_cost*$C$10+per_infrastructure_cost*+$C$10+per_maintenance_cost*'Cost calculations'!E23","v":2013.7056405768335},{"$f":"SUMIF($C$22:$F$22, $G$22,C23:F23)","v":2391.7014760789548},{"$f":"'Discounted cost_7years'!equipment_lifetime","v":7},{"$f":"ROUNDUP(I$15/H23, 0)","v":3},{"$f":"'Discounted cost_7years'!structure_lifetime","v":20},{"$f":"ROUNDUP(K$15/J23, 0)","v":1}]
[null,"Urban",{"$f":"C17*'Cost Trend calc'!$L$16","v":11339.875065063636},{"$f":"D17*'Cost Trend calc'!$L$16","v":5669.9375325318179},{"$f":"Equipment","v":7000},{"$f":"per_installation_cost*$C$10+per_infrastructure_cost*+$C$10+per_maintenance_cost*'Cost calculations'!E24","v":2013.7056405768335},{"$f":"SUMIF($C$22:$F$22, $G$22,C24:F24)","v":7683.6431731086514},{"$f":"'Discounted cost_7years'!equipment_lifetime","v":7},{"$f":"ROUNDUP(I$15/H24, 0)","v":3},{"$f":"'Discounted cost_7years'!structure_lifetime","v":20},{"$f":"ROUNDUP(K$15/J24, 0)","v":1}]
[null,"Note that opex costs do not change for the 15 year equipment lifetime scenario - They are always calculated from the annualised cost assuming a 7 year lifetime"]
[]
[null,"Exclude equipment installation cost from opex as included in capex"]
[null,"Rural",{"$f":"C16*'Cost Trend calc'!$L$16","v":113398.75065063636},{"$f":"D16*'Cost Trend calc'!$L$16","v":377.99583550212117},{"$f":"Equipment","v":7000},{"$f":"+per_infrastructure_cost*+$C$10+per_maintenance_cost*'Cost calculations'!E28","v":1426.8528202884168},{"$f":"SUMIF($C$22:$F$22, $G$22,C28:F28)","v":1804.848655790538},{"$f":"'Discounted cost_7years'!equipment_lifetime","v":7},{"$f":"ROUNDUP(I$15/H28, 0)","v":3},{"$f":"'Discounted cost_7years'!structure_lifetime","v":20},{"$f":"ROUNDUP(K$15/J28, 0)","v":1}]
[null,"Urban",{"$f":"C17*'Cost Trend calc'!$L$16","v":11339.875065063636},{"$f":"D17*'Cost Trend calc'!$L$16","v":5669.9375325318179},{"$f":"Equipment","v":7000},{"$f":"+per_infrastructure_cost*+$C$10+per_maintenance_cost*'Cost calculations'!E29","v":1426.8528202884168},{"$f":"SUMIF($C$22:$F$22, $G$22,C29:F29)","v":7096.7903528202351},{"$f":"'Discounted cost_7years'!equipment_lifetime","v":7},{"$f":"ROUNDUP(I$15/H29, 0)","v":3},{"$f":"'Discounted cost_7years'!structure_lifetime","v":20},{"$f":"ROUNDUP(K$15/J29, 0)","v":1}]
[]
[]
[]
[]
[null,"Cost of replacing equipment"]
[null,null,"Site cost - construction","Site cost - rental","Equipment cost - capital","Installation cost (% of equipment cost","Total capex"]
[null,null,"CAPEX","OPEX","CAPEX","CAPEX","CAPEX"]
[null,null,null,null,{"$f":"Equipment","v":7000},{"$f":"per_installation_cost","v":0.5},{"$f":"E37+F37*E37","v":10500}]

{"sheet":"Discounted cost_7years","index":8,"n_rows":104,"n_cols":24,"rows_kept":104,"cut":false,"hidden":false,"merged":[[19,2,19,21],[86,0,91,0],[96,0,101,0]]}
["Discounted Cost (7 year lifetime)",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Time horizon (years)",20]
[]
[null,"Finance rate",5.7000000000000002E-2,"finance_rate",null,"Real pre-tax WACC MCT 2021-2026 Statement",null,null,"https://www.ofcom.org.uk/__data/assets/pdf_file/0029/216794/statement-2021-26-wholesale-voice-markets-review.pdf"]
[null,"Discount rate",3.5000000000000003E-2,"discount_rate",null,"STPR - HMT Green Book 2020",null,null,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/938046/The_Green_Book_2020.pdf"]
[]
[null,"Capital cost for equipment",{"$f":"Equipment","v":7000},"equipment_capital"]
[null,"Capital cost (including installation)",{"$f":"'Cost calculations'!G37","v":10500},"equipment_capital_ins"]
[null,"Capital cost - rural site",{"$f":"'Cost calculations'!C23","v":113398.75065063636},"rural_site_capital"]
[null,"Capital cost - urban site",{"$f":"'Cost calculations'!C24","v":11339.875065063636},"urban_site_capital"]
[]
[]
[null,"Installation (% of capex)",{"$f":"per_installation_cost","v":0.5}]
[]
[]
[null,"Lifetime of new equipment",{"$f":"'Spectrum cost inputs'!D20","v":7},"equipment_lifetime"]
[null,"Lifetime of structures",{"$f":"'Spectrum cost inputs'!D21","v":20},"structure_lifetime"]
[]
[null,null,"Years"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Discount factor (WACC)",{"$f":"1/(1+$C5)^(C$21)","v":0.94607379375591305},0.89505562323170573,0.84678866909338302,0.80112456867869719,0.75792295996092451,0.71705105010494274,0.67838320728944457,0.64180057454062855,0.60719070439037715,0.57444721323592918,0.54346945433862748,0.51416220845660121,0.4864353911604552,0.46020377593231337,0.43538673219707991,0.41190797748068098,0.38969534293347302,0.36868055149808232,0.34879900803981301,0.32998960079452505]
[null,"Discount factor (STPR)",{"$f":"1/(1+$C6)^(C$21)","v":0.96618357487922713},0.93351070036640305,0.90194270566802237,0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217,0.68494571372924851,0.66178329828912896,0.63940415293635666,0.61778179027667302,0.59689061862480497,0.57670591171478747,0.55720377943457733,0.53836113955031628,0.52015569038677911,0.50256588443167061]
[null,"New equipment required","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No"]
[null,"New structures required","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[null,"Cost of retiring equipment early"]
[null,"Estimating the capital cost that firms need to write off "]
[null,"Including the installation cost as part of capex for this calculation"]
[]
[null,null,"Year"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Annualised capital cost"]
[null,"New",{"$f":"-PMT(finance_rate,equipment_lifetime,equipment_capital_ins,,1)","v":1760.55846086525},1760.55846086525,1760.55846086525,1760.55846086525,1760.55846086525,1760.55846086525,1760.55846086525]
[]
[null,"Cost (Straight line depreciation)"]
[]
["Remaining lifetime","Depreciation"]
[{"$f":"equipment_lifetime-LEFT(B41,2)","v":7},"0 year old",{"$f":"IF(C$34<=$A41,equipment_capital_ins/equipment_lifetime,0)","v":1500},1500,1500,1500,1500,1500,1500]
[6,"1 year old",1500,1500,1500,1500,1500,1500,0]
[5,"2 year old",1500,1500,1500,1500,1500,0,0]
[4,"3 year old",1500,1500,1500,1500,0,0,0]
[3,"4 year old",1500,1500,1500,0,0,0,0]
[2,"5 year old",1500,1500,0,0,0,0,0]
[1,"6 year old",1500,0,0,0,0,0,0]
[0,"7 year old",0,0,0,0,0,0,0]
[]
[null,"Financing cost"]
[null,"0 year old",{"$f":"SUM(C41:$I41)*finance_rate","v":598.5},{"$f":"SUM(D41:$I41)*finance_rate","v":513},{"$f":"SUM(E41:$I41)*finance_rate","v":427.5},{"$f":"SUM(F41:$I41)*finance_rate","v":342},{"$f":"SUM(G41:$I41)*finance_rate","v":256.5},{"$f":"SUM(H41:$I41)*finance_rate","v":171},{"$f":"SUM(I41:$I41)*finance_rate","v":85.5}]
[null,"1 year old",{"$f":"SUM(C42:$I42)*finance_rate","v":513},{"$f":"SUM(D42:$I42)*finance_rate","v":427.5},{"$f":"SUM(E42:$I42)*finance_rate","v":342},{"$f":"SUM(F42:$I42)*finance_rate","v":256.5},{"$f":"SUM(G42:$I42)*finance_rate","v":171},{"$f":"SUM(H42:$I42)*finance_rate","v":85.5},{"$f":"SUM(I42:$I42)*finance_rate","v":0}]
[null,"2 year old",{"$f":"SUM(C43:$I43)*finance_rate","v":427.5},{"$f":"SUM(D43:$I43)*finance_rate","v":342},{"$f":"SUM(E43:$I43)*finance_rate","v":256.5},{"$f":"SUM(F43:$I43)*finance_rate","v":171},{"$f":"SUM(G43:$I43)*finance_rate","v":85.5},{"$f":"SUM(H43:$I43)*finance_rate","v":0},{"$f":"SUM(I43:$I43)*finance_rate","v":0}]
[null,"3 year old",{"$f":"SUM(C44:$I44)*finance_rate","v":342},{"$f":"SUM(D44:$I44)*finance_rate","v":256.5},{"$f":"SUM(E44:$I44)*finance_rate","v":171},{"$f":"SUM(F44:$I44)*finance_rate","v":85.5},{"$f":"SUM(G44:$I44)*finance_rate","v":0},{"$f":"SUM(H44:$I44)*finance_rate","v":0},{"$f":"SUM(I44:$I44)*finance_rate","v":0}]
[null,"4 year old",{"$f":"SUM(C45:$I45)*finance_rate","v":256.5},{"$f":"SUM(D45:$I45)*finance_rate","v":171},{"$f":"SUM(E45:$I45)*finance_rate","v":85.5},{"$f":"SUM(F45:$I45)*finance_rate","v":0},{"$f":"SUM(G45:$I45)*finance_rate","v":0},{"$f":"SUM(H45:$I45)*finance_rate","v":0},{"$f":"SUM(I45:$I45)*finance_rate","v":0}]
[null,"5 year old",{"$f":"SUM(C46:$I46)*finance_rate","v":171},{"$f":"SUM(D46:$I46)*finance_rate","v":85.5},{"$f":"SUM(E46:$I46)*finance_rate","v":0},{"$f":"SUM(F46:$I46)*finance_rate","v":0},{"$f":"SUM(G46:$I46)*finance_rate","v":0},{"$f":"SUM(H46:$I46)*finance_rate","v":0},{"$f":"SUM(I46:$I46)*finance_rate","v":0}]
[null,"6 year old",{"$f":"SUM(C47:$I47)*finance_rate","v":85.5},{"$f":"SUM(D47:$I47)*finance_rate","v":0},{"$f":"SUM(E47:$I47)*finance_rate","v":0},{"$f":"SUM(F47:$I47)*finance_rate","v":0},{"$f":"SUM(G47:$I47)*finance_rate","v":0},{"$f":"SUM(H47:$I47)*finance_rate","v":0},{"$f":"SUM(I47:$I47)*finance_rate","v":0}]
[null,"7 year old",{"$f":"SUM(C48:$I48)*finance_rate","v":0},{"$f":"SUM(D48:$I48)*finance_rate","v":0},{"$f":"SUM(E48:$I48)*finance_rate","v":0},{"$f":"SUM(F48:$I48)*finance_rate","v":0},{"$f":"SUM(G48:$I48)*finance_rate","v":0},{"$f":"SUM(H48:$I48)*finance_rate","v":0},{"$f":"SUM(I48:$I48)*finance_rate","v":0}]
[]
[null,"Depreciaton + financing cost"]
[null,"0 year old",{"$f":"C41+C51","v":2098.5},2013,1927.5,1842,1756.5,1671,1585.5]
[null,"1 year old",2013,1927.5,1842,1756.5,1671,1585.5,0]
[null,"2 year old",1927.5,1842,1756.5,1671,1585.5,0,0]
[null,"3 year old",1842,1756.5,1671,1585.5,0,0,0]
[null,"4 year old",1756.5,1671,1585.5,0,0,0,0]
[null,"5 year old",1671,1585.5,0,0,0,0,0]
[null,"6 year old",1585.5,0,0,0,0,0,0]
[null,"7 year old",0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"No revocation period ","5 year revocation"]
[]
[null,"Discounted cost"]
[null,"0 year old",{"$f":"C61*INDEX($C$23:$V$23, 1, MATCH(C$34,$C$21:$V$21,0))","v":2027.5362318840582},{"$f":"D61*INDEX($C$23:$V$23, 1, MATCH(D$34,$C$21:$V$21,0))","v":1879.1570398375693},1738.4945651751132,1605.1965834207704,1478.9258675869978,1359.359576638255,1246.1886681641952,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C71:V71)","v":11334.85853270696},{"$f":"SUM(H71:V71)","v":2605.5482448024504}]
[null,"1 year old",1944.9275362318842,1799.3418749562418,1661.3784638404973,1530.6882729525423,1406.9371618205939,1289.8052715499421,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C72:V72)","v":9633.0785813517014},{"$f":"SUM(H72:V72)","v":1289.8052715499421}]
[null,"2 year old",1862.3188405797102,1719.5267100749145,1584.2623625058814,1456.1799624843145,1334.94845605419,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C73:V73)","v":7957.2363316990104},0]
[null,"3 year old",1779.7101449275365,1639.711545193587,1507.1462611712655,1381.6716520160865,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,6308.2396033084751,0]
[null,"4 year old",1697.1014492753625,1559.8963803122595,1430.0301598366495,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,4687.0279894242713,0]
[null,"5 year old",1614.4927536231885,1480.0812154309319,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,3094.5739690541204,0]
[null,"6 year old",1531.8840579710145,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,1531.8840579710145,0]
[null,"7 year old",0,0,0,0,0,0,0]
[]
[null,"Final outputs in Columns W & X  ---->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average cost per link"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(W71:W77)","v":6363.8427236450789},{"$f":"AVERAGE(X71:X77)","v":556.47907376462751}]
[]
[]
[null,"Cost additional hop"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Rural","Annualised equipment cost",{"$f":"C61","v":2098.5},{"$f":"D61","v":2013},1927.5,1842,1756.5,1671,1585.5,{"$f":"C87","v":2098.5},{"$f":"D87","v":2013},1927.5,1842,1756.5,1671,1585.5,2098.5,2013,1927.5,1842,1756.5,1671,{"$f":"SUM(C87:V87)","v":37096.5}]
[null,"Annualised site cost",{"$f":"Cost_SiteRural!C41","v":12133.666319618093},{"$f":"Cost_SiteRural!D41","v":11810.47988026378},{"$f":"Cost_SiteRural!E41","v":11487.293440909467},{"$f":"Cost_SiteRural!F41","v":11164.107001555152},{"$f":"Cost_SiteRural!G41","v":10840.920562200838},{"$f":"Cost_SiteRural!H41","v":10517.734122846523},{"$f":"Cost_SiteRural!I41","v":10194.547683492208},{"$f":"Cost_SiteRural!J41","v":9871.3612441378955},{"$f":"Cost_SiteRural!K41","v":9548.1748047835808},{"$f":"Cost_SiteRural!L41","v":9224.988365429268},{"$f":"Cost_SiteRural!M41","v":8901.8019260749534},{"$f":"Cost_SiteRural!N41","v":8578.6154867206405},{"$f":"Cost_SiteRural!O41","v":8255.4290473663277},{"$f":"Cost_SiteRural!P41","v":7932.2426080120131},{"$f":"Cost_SiteRural!Q41","v":7609.0561686576993},{"$f":"Cost_SiteRural!R41","v":7285.8697293033856},{"$f":"Cost_SiteRural!S41","v":6962.6832899490728},{"$f":"Cost_SiteRural!T41","v":6639.4968505947591},{"$f":"Cost_SiteRural!U41","v":6316.3104112404453},{"$f":"Cost_SiteRural!V41","v":5993.1239718861316},{"$f":"SUM(C88:V88)","v":181267.90291504221}]
[null,"Opex",{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"SUM(C89:V89)","v":36096.973115810761}]
[]
[null,"Total",{"$f":"SUM(C87,C88:C89)","v":16037.014975408631},{"$f":"SUM(D87,D88:D89)","v":15628.328536054318},15219.642096700005,14810.95565734569,14402.269217991376,13993.582778637061,13584.896339282746,13774.709899928434,13366.023460574119,12957.337021219806,12548.650581865491,12139.964142511179,11731.277703156866,11322.591263802551,11512.404824448236,11103.718385093924,10695.031945739611,10286.345506385296,9877.6590670309834,9468.9726276766705,{"$f":"SUM(C91:V91)","v":254461.37603085302}]
[null,"Discounted cash flow",{"$f":"C91*INDEX($C$23:$V$23, 1, MATCH(C21,$C$21:$V$21,0))","v":15494.700459332011},14589.211917248309,13727.245171996536,12906.892192382102,12126.324223421239,11383.788606595122,10677.605724502944,10460.673881532044,9807.0653880362388,9185.6999899208586,8595.1444291348089,8034.0255113428047,7501.0276826481831,6994.8907015229579,6871.6464375240976,6403.5800346998385,5959.3122213396528,5537.7686886258634,5137.9205714167292,4758.7826032876055]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost rural hop",{"$f":"SUM(C92:V92)","v":186153.30643650991}]
[]
[]
["Urban","Annualised equipment cost",{"$f":"C61","v":2098.5},{"$f":"D61","v":2013},1927.5,1842,1756.5,1671,1585.5,{"$f":"C97","v":2098.5},{"$f":"D97","v":2013},{"$f":"E97","v":1927.5},{"$f":"F97","v":1842},{"$f":"G97","v":1756.5},{"$f":"H97","v":1671},{"$f":"I97","v":1585.5},{"$f":"J97","v":2098.5},{"$f":"K97","v":2013},{"$f":"L97","v":1927.5},{"$f":"M97","v":1842},{"$f":"N97","v":1756.5},{"$f":"O97","v":1671},{"$f":"SUM(C97:V97)","v":37096.5}]
[null,"Annualised site cost",{"$f":"Cost_SiteUrban!C41","v":1213.3666319618092},{"$f":"Cost_SiteUrban!D41","v":1181.0479880263779},{"$f":"Cost_SiteUrban!E41","v":1148.7293440909466},{"$f":"Cost_SiteUrban!F41","v":1116.4107001555151},{"$f":"Cost_SiteUrban!G41","v":1084.0920562200836},{"$f":"Cost_SiteUrban!H41","v":1051.7734122846523},{"$f":"Cost_SiteUrban!I41","v":1019.454768349221},{"$f":"Cost_SiteUrban!J41","v":987.13612441378962},{"$f":"Cost_SiteUrban!K41","v":954.81748047835822},{"$f":"Cost_SiteUrban!L41","v":922.49883654292694},{"$f":"Cost_SiteUrban!M41","v":890.18019260749543},{"$f":"Cost_SiteUrban!N41","v":857.86154867206415},{"$f":"Cost_SiteUrban!O41","v":825.54290473663275},{"$f":"Cost_SiteUrban!P41","v":793.22426080120135},{"$f":"Cost_SiteUrban!Q41","v":760.90561686576996},{"$f":"Cost_SiteUrban!R41","v":728.58697293033856},{"$f":"Cost_SiteUrban!S41","v":696.26832899490728},{"$f":"Cost_SiteUrban!T41","v":663.94968505947588},{"$f":"Cost_SiteUrban!U41","v":631.63104112404449},{"$f":"Cost_SiteUrban!V41","v":599.3123971886132},18126.790291504221]
[null,"Ongoing cost",{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},141935.80705640468]
[]
[null,"Total",{"$f":"SUM(C97,C98:C99)","v":10408.656984782045},{"$f":"SUM(D97,D98:D99)","v":10290.838340846612},10173.019696911182,10055.20105297575,9937.3824090403177,9819.5637651048874,9701.745121169457,10182.426477234025,10064.607833298593,9946.7891893631622,9828.97054542773,9711.1519014922997,9593.3332575568675,9475.5146136214353,9956.1959696860049,9838.3773257505745,9720.5586818151423,9602.7400378797101,9484.9213939442798,9367.1027500088494,197159.09734790889]
[null,"Discounted cash flow",{"$f":"C101*INDEX($C$23:$V$23, 1, MATCH(C86,$C$21:$V$21,0))","v":10056.673415248353},9606.6077069211551,9175.4809102461568,8762.5268055622182,8367.0093372238662,7988.2214497338891,7625.4839680975365,7732.6523371338444,7384.7144902333821,7051.4659923445197,6732.3112454617576,6426.6781355563207,6134.0171253843282,5853.8003817958279,5942.7599714956696,5673.8503654410779,5416.3320357229904,5169.7420695983683,4933.6358359314181,4707.5862781205315]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost urban hop",{"$f":"SUM(C102:V102)","v":140741.54985725321}]

{"sheet":"Discounted cost_15years","index":9,"n_rows":135,"n_cols":24,"rows_kept":135,"cut":false,"hidden":false,"merged":[[19,2,19,21],[117,0,122,0],[127,0,132,0]]}
["Discounted Cost (15 year lifetime)",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Time horizon (years)",20]
[]
[null,"Finance rate",5.7000000000000002E-2,"finance_rate",null,"Real pre-tax WACC MCT 2021-2026 Statement",null,null,"https://www.ofcom.org.uk/__data/assets/pdf_file/0029/216794/statement-2021-26-wholesale-voice-markets-review.pdf"]
[null,"Discount rate",3.5000000000000003E-2,"discount_rate",null,"STPR - HMT Green Book 2020",null,null,"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/938046/The_Green_Book_2020.pdf"]
[]
[null,"Capital cost for equipment",{"$f":"Equipment","v":7000},"equipment_capital"]
[null,"Capital cost (including installation)",{"$f":"'Cost calculations'!G37","v":10500},"equipment_capital_ins"]
[null,"Capital cost - rural site",{"$f":"'Cost calculations'!C23","v":113398.75065063636},"rural_site_capital"]
[null,"Capital cost - urban site",{"$f":"'Cost calculations'!C24","v":11339.875065063636},"urban_site_capital"]
[]
[]
[null,"Installation (% of capex)",0.5]
[]
[]
[null,"Lifetime of new equipment",15,"equipment_lifetime"]
[null,"Lifetime of structures",{"$f":"'Spectrum cost inputs'!D21","v":20},"structure_lifetime"]
[]
[null,null,"Years"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Discount factor (WACC)",{"$f":"1/(1+$C5)^(C$21)","v":0.94607379375591305},0.89505562323170573,0.84678866909338302,0.80112456867869719,0.75792295996092451,0.71705105010494274,0.67838320728944457,0.64180057454062855,0.60719070439037715,0.57444721323592918,0.54346945433862748,0.51416220845660121,0.4864353911604552,0.46020377593231337,0.43538673219707991,0.41190797748068098,0.38969534293347302,0.36868055149808232,0.34879900803981301,0.32998960079452505]
[null,"Discount factor (STPR)",{"$f":"1/(1+$C6)^(C$21)","v":0.96618357487922713},0.93351070036640305,0.90194270566802237,0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217,0.68494571372924851,0.66178329828912896,0.63940415293635666,0.61778179027667302,0.59689061862480497,0.57670591171478747,0.55720377943457733,0.53836113955031628,0.52015569038677911,0.50256588443167061]
[null,"New equipment required","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No"]
[null,"New structures required","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[null,"Cost of retiring equipment early"]
[null,"Estimating the capital cost that firms need to write off "]
[null,"Including the installation cost as part of capex for this calculation"]
[]
[null,null,"Year"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Annualised capital cost"]
[null,"New",{"$f":"-PMT(finance_rate,equipment_lifetime_15,equipment_capital_ins,,1)","v":1002.8548704961647},1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647,1002.8548704961647]
[]
[null,"Cost (Straight line depreciation)"]
[]
["Remaining lifetime","Depreciation"]
[{"$f":"equipment_lifetime_15-LEFT(B41,2)","v":15},"0 year old",{"$f":"IF(C$34<=$A41,equipment_capital_ins/equipment_lifetime,0)","v":700},700,700,700,700,700,700,700,700,700,700,700,700,700,700]
[14,"1 year old",700,700,700,700,700,700,700,700,700,700,700,700,700,700,0]
[13,"2 year old",700,700,700,700,700,700,700,700,700,700,700,700,700,0,0]
[12,"3 year old",700,700,700,700,700,700,700,700,700,700,700,700,0,0,0]
[11,"4 year old",700,700,700,700,700,700,700,700,700,700,700,0,0,0,0]
[10,"5 year old",700,700,700,700,700,700,700,700,700,700,0,0,0,0,0]
[9,"6 year old",700,700,700,700,700,700,700,700,700,0,0,0,0,0,0]
[8,"7 year old",700,700,700,700,700,700,700,700,0,0,0,0,0,0,0]
[7,"8 year old",700,700,700,700,700,700,700,0,0,0,0,0,0,0,0]
[6,"9 year old",700,700,700,700,700,700,0,0,0,0,0,0,0,0,0]
[5,"10 year old",{"$f":"IF(C$34<=$A51,equipment_capital_ins/equipment_lifetime,0)","v":700},700,700,700,700,0,0,0,0,0,0,0,0,0,0]
[4,"11 year old",700,700,700,700,0,0,0,0,0,0,0,0,0,0,0]
[3,"12 year old",700,700,700,0,0,0,0,0,0,0,0,0,0,0,0]
[2,"13 year old",700,700,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"14 year old",700,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,"15 year old",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Financing cost"]
[null,"0 year old",{"$f":"SUM(C41:$Q41)*finance_rate","v":598.5},{"$f":"SUM(D41:$Q41)*finance_rate","v":558.6},{"$f":"SUM(E41:$Q41)*finance_rate","v":518.70000000000005},{"$f":"SUM(F41:$Q41)*finance_rate","v":478.8},{"$f":"SUM(G41:$Q41)*finance_rate","v":438.90000000000003},{"$f":"SUM(H41:$Q41)*finance_rate","v":399},{"$f":"SUM(I41:$Q41)*finance_rate","v":359.1},{"$f":"SUM(J41:$Q41)*finance_rate","v":319.2},{"$f":"SUM(K41:$Q41)*finance_rate","v":279.3},{"$f":"SUM(L41:$Q41)*finance_rate","v":239.4},{"$f":"SUM(M41:$Q41)*finance_rate","v":199.5},{"$f":"SUM(N41:$Q41)*finance_rate","v":159.6},{"$f":"SUM(O41:$Q41)*finance_rate","v":119.7},{"$f":"SUM(P41:$Q41)*finance_rate","v":79.8},{"$f":"SUM(Q41:$Q41)*finance_rate","v":39.9}]
[null,"1 year old",{"$f":"SUM(C42:$Q42)*finance_rate","v":558.6},{"$f":"SUM(D42:$Q42)*finance_rate","v":518.70000000000005},{"$f":"SUM(E42:$Q42)*finance_rate","v":478.8},{"$f":"SUM(F42:$Q42)*finance_rate","v":438.90000000000003},{"$f":"SUM(G42:$Q42)*finance_rate","v":399},{"$f":"SUM(H42:$Q42)*finance_rate","v":359.1},{"$f":"SUM(I42:$Q42)*finance_rate","v":319.2},{"$f":"SUM(J42:$Q42)*finance_rate","v":279.3},{"$f":"SUM(K42:$Q42)*finance_rate","v":239.4},{"$f":"SUM(L42:$Q42)*finance_rate","v":199.5},{"$f":"SUM(M42:$Q42)*finance_rate","v":159.6},{"$f":"SUM(N42:$Q42)*finance_rate","v":119.7},{"$f":"SUM(O42:$Q42)*finance_rate","v":79.8},{"$f":"SUM(P42:$Q42)*finance_rate","v":39.9},{"$f":"SUM(Q42:$Q42)*finance_rate","v":0}]
[null,"2 year old",{"$f":"SUM(C43:$Q43)*finance_rate","v":518.70000000000005},{"$f":"SUM(D43:$Q43)*finance_rate","v":478.8},{"$f":"SUM(E43:$Q43)*finance_rate","v":438.90000000000003},{"$f":"SUM(F43:$Q43)*finance_rate","v":399},{"$f":"SUM(G43:$Q43)*finance_rate","v":359.1},{"$f":"SUM(H43:$Q43)*finance_rate","v":319.2},{"$f":"SUM(I43:$Q43)*finance_rate","v":279.3},{"$f":"SUM(J43:$Q43)*finance_rate","v":239.4},{"$f":"SUM(K43:$Q43)*finance_rate","v":199.5},{"$f":"SUM(L43:$Q43)*finance_rate","v":159.6},{"$f":"SUM(M43:$Q43)*finance_rate","v":119.7},{"$f":"SUM(N43:$Q43)*finance_rate","v":79.8},{"$f":"SUM(O43:$Q43)*finance_rate","v":39.9},{"$f":"SUM(P43:$Q43)*finance_rate","v":0},{"$f":"SUM(Q43:$Q43)*finance_rate","v":0}]
[null,"3 year old",{"$f":"SUM(C44:$Q44)*finance_rate","v":478.8},{"$f":"SUM(D44:$Q44)*finance_rate","v":438.90000000000003},{"$f":"SUM(E44:$Q44)*finance_rate","v":399},{"$f":"SUM(F44:$Q44)*finance_rate","v":359.1},{"$f":"SUM(G44:$Q44)*finance_rate","v":319.2},{"$f":"SUM(H44:$Q44)*finance_rate","v":279.3},{"$f":"SUM(I44:$Q44)*finance_rate","v":239.4},{"$f":"SUM(J44:$Q44)*finance_rate","v":199.5},{"$f":"SUM(K44:$Q44)*finance_rate","v":159.6},{"$f":"SUM(L44:$Q44)*finance_rate","v":119.7},{"$f":"SUM(M44:$Q44)*finance_rate","v":79.8},{"$f":"SUM(N44:$Q44)*finance_rate","v":39.9},{"$f":"SUM(O44:$Q44)*finance_rate","v":0},{"$f":"SUM(P44:$Q44)*finance_rate","v":0},{"$f":"SUM(Q44:$Q44)*finance_rate","v":0}]
[null,"4 year old",{"$f":"SUM(C45:$Q45)*finance_rate","v":438.90000000000003},{"$f":"SUM(D45:$Q45)*finance_rate","v":399},{"$f":"SUM(E45:$Q45)*finance_rate","v":359.1},{"$f":"SUM(F45:$Q45)*finance_rate","v":319.2},{"$f":"SUM(G45:$Q45)*finance_rate","v":279.3},{"$f":"SUM(H45:$Q45)*finance_rate","v":239.4},{"$f":"SUM(I45:$Q45)*finance_rate","v":199.5},{"$f":"SUM(J45:$Q45)*finance_rate","v":159.6},{"$f":"SUM(K45:$Q45)*finance_rate","v":119.7},{"$f":"SUM(L45:$Q45)*finance_rate","v":79.8},{"$f":"SUM(M45:$Q45)*finance_rate","v":39.9},{"$f":"SUM(N45:$Q45)*finance_rate","v":0},{"$f":"SUM(O45:$Q45)*finance_rate","v":0},{"$f":"SUM(P45:$Q45)*finance_rate","v":0},{"$f":"SUM(Q45:$Q45)*finance_rate","v":0}]
[null,"5 year old",{"$f":"SUM(C46:$Q46)*finance_rate","v":399},{"$f":"SUM(D46:$Q46)*finance_rate","v":359.1},{"$f":"SUM(E46:$Q46)*finance_rate","v":319.2},{"$f":"SUM(F46:$Q46)*finance_rate","v":279.3},{"$f":"SUM(G46:$Q46)*finance_rate","v":239.4},{"$f":"SUM(H46:$Q46)*finance_rate","v":199.5},{"$f":"SUM(I46:$Q46)*finance_rate","v":159.6},{"$f":"SUM(J46:$Q46)*finance_rate","v":119.7},{"$f":"SUM(K46:$Q46)*finance_rate","v":79.8},{"$f":"SUM(L46:$Q46)*finance_rate","v":39.9},{"$f":"SUM(M46:$Q46)*finance_rate","v":0},{"$f":"SUM(N46:$Q46)*finance_rate","v":0},{"$f":"SUM(O46:$Q46)*finance_rate","v":0},{"$f":"SUM(P46:$Q46)*finance_rate","v":0},{"$f":"SUM(Q46:$Q46)*finance_rate","v":0}]
[null,"6 year old",{"$f":"SUM(C47:$Q47)*finance_rate","v":359.1},{"$f":"SUM(D47:$Q47)*finance_rate","v":319.2},{"$f":"SUM(E47:$Q47)*finance_rate","v":279.3},{"$f":"SUM(F47:$Q47)*finance_rate","v":239.4},{"$f":"SUM(G47:$Q47)*finance_rate","v":199.5},{"$f":"SUM(H47:$Q47)*finance_rate","v":159.6},{"$f":"SUM(I47:$Q47)*finance_rate","v":119.7},{"$f":"SUM(J47:$Q47)*finance_rate","v":79.8},{"$f":"SUM(K47:$Q47)*finance_rate","v":39.9},{"$f":"SUM(L47:$Q47)*finance_rate","v":0},{"$f":"SUM(M47:$Q47)*finance_rate","v":0},{"$f":"SUM(N47:$Q47)*finance_rate","v":0},{"$f":"SUM(O47:$Q47)*finance_rate","v":0},{"$f":"SUM(P47:$Q47)*finance_rate","v":0},{"$f":"SUM(Q47:$Q47)*finance_rate","v":0}]
[null,"7 year old",{"$f":"SUM(C48:$Q48)*finance_rate","v":319.2},{"$f":"SUM(D48:$Q48)*finance_rate","v":279.3},{"$f":"SUM(E48:$Q48)*finance_rate","v":239.4},{"$f":"SUM(F48:$Q48)*finance_rate","v":199.5},{"$f":"SUM(G48:$Q48)*finance_rate","v":159.6},{"$f":"SUM(H48:$Q48)*finance_rate","v":119.7},{"$f":"SUM(I48:$Q48)*finance_rate","v":79.8},{"$f":"SUM(J48:$Q48)*finance_rate","v":39.9},{"$f":"SUM(K48:$Q48)*finance_rate","v":0},{"$f":"SUM(L48:$Q48)*finance_rate","v":0},{"$f":"SUM(M48:$Q48)*finance_rate","v":0},{"$f":"SUM(N48:$Q48)*finance_rate","v":0},{"$f":"SUM(O48:$Q48)*finance_rate","v":0},{"$f":"SUM(P48:$Q48)*finance_rate","v":0},{"$f":"SUM(Q48:$Q48)*finance_rate","v":0}]
[null,"8 year old",{"$f":"SUM(C49:$Q49)*finance_rate","v":279.3},{"$f":"SUM(D49:$Q49)*finance_rate","v":239.4},{"$f":"SUM(E49:$Q49)*finance_rate","v":199.5},{"$f":"SUM(F49:$Q49)*finance_rate","v":159.6},{"$f":"SUM(G49:$Q49)*finance_rate","v":119.7},{"$f":"SUM(H49:$Q49)*finance_rate","v":79.8},{"$f":"SUM(I49:$Q49)*finance_rate","v":39.9},{"$f":"SUM(J49:$Q49)*finance_rate","v":0},{"$f":"SUM(K49:$Q49)*finance_rate","v":0},{"$f":"SUM(L49:$Q49)*finance_rate","v":0},{"$f":"SUM(M49:$Q49)*finance_rate","v":0},{"$f":"SUM(N49:$Q49)*finance_rate","v":0},{"$f":"SUM(O49:$Q49)*finance_rate","v":0},{"$f":"SUM(P49:$Q49)*finance_rate","v":0},{"$f":"SUM(Q49:$Q49)*finance_rate","v":0}]
[null,"9 year old",{"$f":"SUM(C50:$Q50)*finance_rate","v":239.4},{"$f":"SUM(D50:$Q50)*finance_rate","v":199.5},{"$f":"SUM(E50:$Q50)*finance_rate","v":159.6},{"$f":"SUM(F50:$Q50)*finance_rate","v":119.7},{"$f":"SUM(G50:$Q50)*finance_rate","v":79.8},{"$f":"SUM(H50:$Q50)*finance_rate","v":39.9},{"$f":"SUM(I50:$Q50)*finance_rate","v":0},{"$f":"SUM(J50:$Q50)*finance_rate","v":0},{"$f":"SUM(K50:$Q50)*finance_rate","v":0},{"$f":"SUM(L50:$Q50)*finance_rate","v":0},{"$f":"SUM(M50:$Q50)*finance_rate","v":0},{"$f":"SUM(N50:$Q50)*finance_rate","v":0},{"$f":"SUM(O50:$Q50)*finance_rate","v":0},{"$f":"SUM(P50:$Q50)*finance_rate","v":0},{"$f":"SUM(Q50:$Q50)*finance_rate","v":0}]
[null,"10 year old",{"$f":"SUM(C51:$Q51)*finance_rate","v":199.5},{"$f":"SUM(D51:$Q51)*finance_rate","v":159.6},{"$f":"SUM(E51:$Q51)*finance_rate","v":119.7},{"$f":"SUM(F51:$Q51)*finance_rate","v":79.8},{"$f":"SUM(G51:$Q51)*finance_rate","v":39.9},{"$f":"SUM(H51:$Q51)*finance_rate","v":0},{"$f":"SUM(I51:$Q51)*finance_rate","v":0},{"$f":"SUM(J51:$Q51)*finance_rate","v":0},{"$f":"SUM(K51:$Q51)*finance_rate","v":0},{"$f":"SUM(L51:$Q51)*finance_rate","v":0},{"$f":"SUM(M51:$Q51)*finance_rate","v":0},{"$f":"SUM(N51:$Q51)*finance_rate","v":0},{"$f":"SUM(O51:$Q51)*finance_rate","v":0},{"$f":"SUM(P51:$Q51)*finance_rate","v":0},{"$f":"SUM(Q51:$Q51)*finance_rate","v":0}]
[null,"11 year old",{"$f":"SUM(C52:$Q52)*finance_rate","v":159.6},{"$f":"SUM(D52:$Q52)*finance_rate","v":119.7},{"$f":"SUM(E52:$Q52)*finance_rate","v":79.8},{"$f":"SUM(F52:$Q52)*finance_rate","v":39.9},{"$f":"SUM(G52:$Q52)*finance_rate","v":0},{"$f":"SUM(H52:$Q52)*finance_rate","v":0},{"$f":"SUM(I52:$Q52)*finance_rate","v":0},{"$f":"SUM(J52:$Q52)*finance_rate","v":0},{"$f":"SUM(K52:$Q52)*finance_rate","v":0},{"$f":"SUM(L52:$Q52)*finance_rate","v":0},{"$f":"SUM(M52:$Q52)*finance_rate","v":0},{"$f":"SUM(N52:$Q52)*finance_rate","v":0},{"$f":"SUM(O52:$Q52)*finance_rate","v":0},{"$f":"SUM(P52:$Q52)*finance_rate","v":0},{"$f":"SUM(Q52:$Q52)*finance_rate","v":0}]
[null,"12 year old",{"$f":"SUM(C53:$Q53)*finance_rate","v":119.7},{"$f":"SUM(D53:$Q53)*finance_rate","v":79.8},{"$f":"SUM(E53:$Q53)*finance_rate","v":39.9},{"$f":"SUM(F53:$Q53)*finance_rate","v":0},{"$f":"SUM(G53:$Q53)*finance_rate","v":0},{"$f":"SUM(H53:$Q53)*finance_rate","v":0},{"$f":"SUM(I53:$Q53)*finance_rate","v":0},{"$f":"SUM(J53:$Q53)*finance_rate","v":0},{"$f":"SUM(K53:$Q53)*finance_rate","v":0},{"$f":"SUM(L53:$Q53)*finance_rate","v":0},{"$f":"SUM(M53:$Q53)*finance_rate","v":0},{"$f":"SUM(N53:$Q53)*finance_rate","v":0},{"$f":"SUM(O53:$Q53)*finance_rate","v":0},{"$f":"SUM(P53:$Q53)*finance_rate","v":0},{"$f":"SUM(Q53:$Q53)*finance_rate","v":0}]
[null,"13 year old",{"$f":"SUM(C54:$Q54)*finance_rate","v":79.8},{"$f":"SUM(D54:$Q54)*finance_rate","v":39.9},{"$f":"SUM(E54:$Q54)*finance_rate","v":0},{"$f":"SUM(F54:$Q54)*finance_rate","v":0},{"$f":"SUM(G54:$Q54)*finance_rate","v":0},{"$f":"SUM(H54:$Q54)*finance_rate","v":0},{"$f":"SUM(I54:$Q54)*finance_rate","v":0},{"$f":"SUM(J54:$Q54)*finance_rate","v":0},{"$f":"SUM(K54:$Q54)*finance_rate","v":0},{"$f":"SUM(L54:$Q54)*finance_rate","v":0},{"$f":"SUM(M54:$Q54)*finance_rate","v":0},{"$f":"SUM(N54:$Q54)*finance_rate","v":0},{"$f":"SUM(O54:$Q54)*finance_rate","v":0},{"$f":"SUM(P54:$Q54)*finance_rate","v":0},{"$f":"SUM(Q54:$Q54)*finance_rate","v":0}]
[null,"14 year old",{"$f":"SUM(C55:$Q55)*finance_rate","v":39.9},{"$f":"SUM(D55:$Q55)*finance_rate","v":0},{"$f":"SUM(E55:$Q55)*finance_rate","v":0},{"$f":"SUM(F55:$Q55)*finance_rate","v":0},{"$f":"SUM(G55:$Q55)*finance_rate","v":0},{"$f":"SUM(H55:$Q55)*finance_rate","v":0},{"$f":"SUM(I55:$Q55)*finance_rate","v":0},{"$f":"SUM(J55:$Q55)*finance_rate","v":0},{"$f":"SUM(K55:$Q55)*finance_rate","v":0},{"$f":"SUM(L55:$Q55)*finance_rate","v":0},{"$f":"SUM(M55:$Q55)*finance_rate","v":0},{"$f":"SUM(N55:$Q55)*finance_rate","v":0},{"$f":"SUM(O55:$Q55)*finance_rate","v":0},{"$f":"SUM(P55:$Q55)*finance_rate","v":0},{"$f":"SUM(Q55:$Q55)*finance_rate","v":0}]
[null,"15 year old",{"$f":"SUM(C56:$Q56)*finance_rate","v":0},{"$f":"SUM(D56:$Q56)*finance_rate","v":0},{"$f":"SUM(E56:$Q56)*finance_rate","v":0},{"$f":"SUM(F56:$Q56)*finance_rate","v":0},{"$f":"SUM(G56:$Q56)*finance_rate","v":0},{"$f":"SUM(H56:$Q56)*finance_rate","v":0},{"$f":"SUM(I56:$Q56)*finance_rate","v":0},{"$f":"SUM(J56:$Q56)*finance_rate","v":0},{"$f":"SUM(K56:$Q56)*finance_rate","v":0},{"$f":"SUM(L56:$Q56)*finance_rate","v":0},{"$f":"SUM(M56:$Q56)*finance_rate","v":0},{"$f":"SUM(N56:$Q56)*finance_rate","v":0},{"$f":"SUM(O56:$Q56)*finance_rate","v":0},{"$f":"SUM(P56:$Q56)*finance_rate","v":0},{"$f":"SUM(Q56:$Q56)*finance_rate","v":0}]
[]
[null,"Depreciaton + financing cost"]
[null,"0 year old",{"$f":"C41+C59","v":1298.5},{"$f":"D41+D59","v":1258.5999999999999},1218.7,1178.8,1138.9000000000001,1099,1059.0999999999999,1019.2,979.3,939.4,899.5,859.6,819.7,779.8,739.9]
[null,"1 year old",1258.5999999999999,{"$f":"D42+D60","v":1218.7},1178.8,1138.9000000000001,1099,1059.0999999999999,1019.2,979.3,939.4,899.5,859.6,819.7,779.8,739.9,0]
[null,"2 year old",1218.7,{"$f":"D43+D61","v":1178.8},1138.9000000000001,1099,1059.0999999999999,1019.2,979.3,939.4,899.5,859.6,819.7,779.8,739.9,0,0]
[null,"3 year old",1178.8,{"$f":"D44+D62","v":1138.9000000000001},1099,1059.0999999999999,1019.2,979.3,939.4,899.5,859.6,819.7,779.8,739.9,0,0,0]
[null,"4 year old",1138.9000000000001,{"$f":"D45+D63","v":1099},1059.0999999999999,1019.2,979.3,939.4,899.5,859.6,819.7,779.8,739.9,0,0,0,0]
[null,"5 year old",1099,{"$f":"D46+D64","v":1059.0999999999999},1019.2,979.3,939.4,899.5,859.6,819.7,779.8,739.9,0,0,0,0,0]
[null,"6 year old",1059.0999999999999,{"$f":"D47+D65","v":1019.2},979.3,939.4,899.5,859.6,819.7,779.8,739.9,0,0,0,0,0,0]
[null,"7 year old",1019.2,{"$f":"D48+D66","v":979.3},939.4,899.5,859.6,819.7,779.8,739.9,0,0,0,0,0,0,0]
[null,"8 year old",979.3,{"$f":"D49+D67","v":939.4},899.5,859.6,819.7,779.8,739.9,0,0,0,0,0,0,0,0]
[null,"9 year old",939.4,{"$f":"D50+D68","v":899.5},859.6,819.7,779.8,739.9,0,0,0,0,0,0,0,0,0]
[null,"10 year old",899.5,{"$f":"D51+D69","v":859.6},819.7,779.8,739.9,0,0,0,0,0,0,0,0,0,0]
[null,"11 year old",859.6,{"$f":"D52+D70","v":819.7},779.8,739.9,0,0,0,0,0,0,0,0,0,0,0]
[null,"12 year old",819.7,{"$f":"D53+D71","v":779.8},739.9,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"13 year old",779.8,{"$f":"D54+D72","v":739.9},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"14 year old",739.9,{"$f":"D55+D73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"15 year old",0,{"$f":"D56+D74","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Discounted cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No revocation period ","5 year revocation"]
[null,"0 year old",{"$f":"C77*INDEX($C$23:$V$23, 1, MATCH(C$34,$C$21:$V$21,0))","v":1254.5893719806763},{"$f":"D77*INDEX($C$23:$V$23, 1, MATCH(D$34,$C$21:$V$21,0))","v":1174.9165674811547},1099.1975753976189,1027.256098011077,958.9232397351733,894.03720809422032,832.44302646023277,773.99225809560255,718.54274106528908,665.95833359895994,616.10866949945898,568.86892320933532,524.11958416193158,481.74624005774962,441.63936872049317,null,null,null,null,null,{"$f":"SUM(C95:V95)","v":12032.339205568973},{"$f":"SUM(H95:V95)","v":6517.4563529632742}]
[null,"1 year old",{"$f":"C78*INDEX($C$23:$V$23, 1, MATCH(C$34,$C$21:$V$21,0))","v":1216.0386473429951},1137.6694905365355,1063.2100614414646,992.48555312590418,925.32851037751811,861.57853238634095,801.08198712894853,743.69173700257409,689.26687527492345,637.67247293194009,588.77933552166201,542.46376960759903,498.60735845977092,457.09674662571035,0,null,null,null,null,null,{"$f":"SUM(C96:V96)","v":11154.971077763885},{"$f":"SUM(H96:V96)","v":5820.2388149394692}]
[null,"2 year old",1177.4879227053141,1100.4224135919158,1027.2225474853108,957.71500824073109,891.73378101986293,829.1198566784617,769.72094779766405,713.39121590954574,659.99100948455794,609.38661226492013,561.45000154386503,516.05861600586275,473.09513275761026,0,0,null,null,null,null,null,10286.795065485621,5132.2133924424879]
[null,"3 year old",1138.9371980676328,1063.1753366472965,991.23503352915657,922.9444633555579,858.13905166220786,796.66118097058234,738.35990846637969,683.09069481651738,630.71514369419231,581.10075159790028,534.12066756606794,489.65346240412651,0,0,0,null,null,null,null,null,9428.1328927776194,4453.7018095157664]
[null,"4 year old",1100.3864734299518,1025.928259702677,955.24751957300236,888.17391847038505,824.54432230455268,764.20250526270297,706.99886913509533,652.79017372348903,601.43927790382679,552.81489093088032,506.79133358827096,0,0,0,0,null,null,null,null,null,8579.3175440248342,3785.0370505442652]
[null,"5 year old",1061.8357487922706,988.68118275805739,919.26000561684839,853.40337358521185,790.94959294689761,731.74382955482361,675.63782980381097,622.48965263046057,572.16341211346105,524.52903026386036,0,0,0,0,0,null,null,null,null,null,7740.693658065702,3126.5637543664166]
[null,"6 year old",1023.2850241545893,951.43410581343801,883.2724916606943,818.63282870003889,757.35486358924254,699.28515384694435,644.27679047252661,592.1891315374321,542.88754632309553,0,0,0,0,0,0,null,null,null,null,null,6912.6179360980013,2478.6386221799985]
[null,"7 year old",984.73429951690832,914.18702886881852,847.28497770454021,783.8622838148658,723.76013423158736,666.82647813906499,612.91575114124214,561.88861044440375,0,0,0,0,0,0,0,null,null,null,null,null,6095.459563861431,1841.6308397247108]
[null,"8 year old",946.18357487922708,876.93995192419902,811.29746374838612,749.09173892969284,690.16540487393229,634.36780243118562,581.55471180995778,0,0,0,0,0,0,0,0,null,null,null,null,null,5289.6006485965809,1215.9225142411433]
[null,"9 year old",907.63285024154595,839.69287497957953,775.30994979223203,714.32119404451987,656.57067551627711,601.90912672330626,0,0,0,0,0,0,0,0,0,null,null,null,null,null,4495.4366712974606,601.90912672330626]
[null,"10 year old",869.08212560386482,802.44579803496003,739.32243583607794,679.55064915934668,622.97594615862204,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,3713.3769547928714,0]
[null,"11 year old",830.5314009661837,765.19872109034065,703.33492187992385,644.78010427417371,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,2943.845148210622,0]
[null,"12 year old",791.98067632850257,727.95164414572105,667.34740792376977,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,2187.2797283979935,0]
[null,"13 year old",753.42995169082121,690.70456720110155,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,1444.1345188919227,0]
[null,"14 year old",714.87922705314008,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,714.87922705314008,0]
[null,"15 year old",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Final outputs in Columns W & X  ---->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average cost per link","Average cost per link"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(W95:W109)","v":6201.2586560591099},{"$f":"AVERAGE(X95:X109)","v":2331.5541518427226}]
[]
[null,"Cost additional hop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total 20 yr NPC"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Rural","Annualised equipment cost",{"$f":"C77","v":1298.5},{"$f":"D77","v":1258.5999999999999},1218.7,1178.8,1138.9000000000001,1099,1059.0999999999999,1019.2,979.3,939.4,899.5,859.6,819.7,779.8,739.9,{"$f":"C118","v":1298.5},{"$f":"D118","v":1258.5999999999999},1218.7,1178.8,1138.9000000000001,{"$f":"SUM(C118:V118)","v":21381.5}]
[null,"Annualised site cost",{"$f":"Cost_SiteRural!C41","v":12133.666319618093},{"$f":"Cost_SiteRural!D41","v":11810.47988026378},{"$f":"Cost_SiteRural!E41","v":11487.293440909467},{"$f":"Cost_SiteRural!F41","v":11164.107001555152},{"$f":"Cost_SiteRural!G41","v":10840.920562200838},{"$f":"Cost_SiteRural!H41","v":10517.734122846523},{"$f":"Cost_SiteRural!I41","v":10194.547683492208},{"$f":"Cost_SiteRural!J41","v":9871.3612441378955},{"$f":"Cost_SiteRural!K41","v":9548.1748047835808},{"$f":"Cost_SiteRural!L41","v":9224.988365429268},{"$f":"Cost_SiteRural!M41","v":8901.8019260749534},{"$f":"Cost_SiteRural!N41","v":8578.6154867206405},{"$f":"Cost_SiteRural!O41","v":8255.4290473663277},{"$f":"Cost_SiteRural!P41","v":7932.2426080120131},{"$f":"Cost_SiteRural!Q41","v":7609.0561686576993},{"$f":"Cost_SiteRural!R41","v":7285.8697293033856},{"$f":"Cost_SiteRural!S41","v":6962.6832899490728},{"$f":"Cost_SiteRural!T41","v":6639.4968505947591},{"$f":"Cost_SiteRural!U41","v":6316.3104112404453},{"$f":"Cost_SiteRural!V41","v":5993.1239718861316},{"$f":"SUM(C119:V119)","v":181267.90291504221}]
[null,"Opex",{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"'Cost calculations'!$G$28","v":1804.848655790538},{"$f":"SUM(C120:V120)","v":36096.973115810761}]
[]
[null,"Total",{"$f":"SUM(C118,C119:C120)","v":15237.014975408631},{"$f":"SUM(D118,D119:D120)","v":14873.928536054318},14510.842096700006,14147.75565734569,13784.669217991375,13421.582778637061,13058.496339282747,12695.409899928434,12332.323460574118,11969.237021219806,11606.150581865491,11243.064142511179,10879.977703156866,10516.89126380255,10153.804824448238,10389.218385093924,10026.131945739611,9663.0455063852969,9299.9590670309844,8936.8726276766702,{"$f":"SUM(C122:V122)","v":238746.37603085299}]
[null,"Discounted cash flow",{"$f":"C122*INDEX($C$23:$V$23, 1, MATCH(C21,$C$21:$V$21,0))","v":14721.75359942863},13884.971444891895,13087.948182219041,12328.951706972408,11606.321595569414,10918.466238051089,10263.860082798981,9641.0409889078455,9048.6076820838334,8485.2173100942309,7949.5830939449916,7440.472071107285,6956.7029272534637,6497.1439130970421,6060.7108430604376,5991.5236607796232,5586.5986132758635,5202.2081903441513,4837.426629080288,4491.3672961815137]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPC rural hop",{"$f":"SUM(C123:V123)","v":175000.87606914202}]
[]
[]
["Urban","Annualised equipment cost",{"$f":"C77","v":1298.5},{"$f":"D77","v":1258.5999999999999},1218.7,1178.8,1138.9000000000001,1099,1059.0999999999999,1019.2,979.3,939.4,899.5,859.6,819.7,779.8,739.9,{"$f":"C128","v":1298.5},{"$f":"D128","v":1258.5999999999999},1218.7,1178.8,1138.9000000000001,{"$f":"SUM(C128:V128)","v":21381.5}]
[null,"Annualised site cost",{"$f":"Cost_SiteUrban!C41","v":1213.3666319618092},{"$f":"Cost_SiteUrban!D41","v":1181.0479880263779},{"$f":"Cost_SiteUrban!E41","v":1148.7293440909466},{"$f":"Cost_SiteUrban!F41","v":1116.4107001555151},{"$f":"Cost_SiteUrban!G41","v":1084.0920562200836},{"$f":"Cost_SiteUrban!H41","v":1051.7734122846523},{"$f":"Cost_SiteUrban!I41","v":1019.454768349221},{"$f":"Cost_SiteUrban!J41","v":987.13612441378962},{"$f":"Cost_SiteUrban!K41","v":954.81748047835822},{"$f":"Cost_SiteUrban!L41","v":922.49883654292694},{"$f":"Cost_SiteUrban!M41","v":890.18019260749543},{"$f":"Cost_SiteUrban!N41","v":857.86154867206415},{"$f":"Cost_SiteUrban!O41","v":825.54290473663275},{"$f":"Cost_SiteUrban!P41","v":793.22426080120135},{"$f":"Cost_SiteUrban!Q41","v":760.90561686576996},{"$f":"Cost_SiteUrban!R41","v":728.58697293033856},{"$f":"Cost_SiteUrban!S41","v":696.26832899490728},{"$f":"Cost_SiteUrban!T41","v":663.94968505947588},{"$f":"Cost_SiteUrban!U41","v":631.63104112404449},{"$f":"Cost_SiteUrban!V41","v":599.3123971886132},18126.790291504221]
[null,"Ongoing cost",{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},{"$f":"'Cost calculations'!$G$29","v":7096.7903528202351},141935.80705640468]
[]
[null,"Total",{"$f":"SUM(C128,C129:C130)","v":9608.6569847820447},{"$f":"SUM(D128,D129:D130)","v":9536.4383408466128},9464.2196969111828,9392.0010529757492,9319.7824090403192,9247.5637651048874,9175.3451211694555,9103.1264772340255,9030.9078332985937,8958.6891893631619,8886.47054542773,8814.2519014922982,8742.0332575568682,8669.8146136214364,8597.5959696860045,9123.8773257505745,9051.6586818151427,8979.4400378797109,8907.221393944279,8835.002750008849,181444.09734790894]
[null,"Discounted cash flow",{"$f":"C132*INDEX($C$23:$V$23, 1, MATCH(C117,$C$21:$V$21,0))","v":9283.7265553449706},8902.367234564741,8536.1839204686621,8184.5863201525244,7847.0067093720436,7522.8990811898548,7211.7383263935735,6913.0194445096458,6626.2567842809785,6350.983312517893,6086.7499102719412,5833.1246953208001,5589.6923699896079,5356.053593369913,5131.8243770320096,5261.7939915208617,5043.6184276592021,4834.1815713166561,4633.141893594975,4440.1709710144396]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPC urban hop",{"$f":"SUM(C133:V133)","v":129589.1194898853}]

{"sheet":"Cost_SiteRural","index":10,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[[18,2,18,21]]}
["Cost of a rural site",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Time horizon (years)",20]
[]
[null,"Finance rate",5.7000000000000002E-2,"finance_rate","Real pre-tax WACC MCT 2021-2026 Statement"]
[null,"Discount rate",3.5000000000000003E-2,"discount_rate","STPR - HMT Green Book 2020"]
[]
[null,"Capital cost for equipment",{"$f":"Equipment","v":7000},"equipment_capital"]
[null,"Capital cost (including installation)",{"$f":"'Cost calculations'!G37","v":10500},"equipment_capital_ins"]
[null,"Capital cost - rural site",{"$f":"'Cost calculations'!C23","v":113398.75065063636},"rural_site_capital"]
[null,"Capital cost - urban site",{"$f":"'Cost calculations'!C24","v":11339.875065063636},"urban_site_capital"]
[]
[]
[null,"Installation (% of capex)",0.5]
[]
[]
[null,"Lifetime of structures",{"$f":"'Spectrum cost inputs'!D21","v":20},"structure_lifetime"]
[]
[null,null,"Years"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Discount factor (WACC)",{"$f":"1/(1+$C5)^(C$20)","v":0.94607379375591305},0.89505562323170573,0.84678866909338302,0.80112456867869719,0.75792295996092451,0.71705105010494274,0.67838320728944457,0.64180057454062855,0.60719070439037715,0.57444721323592918,0.54346945433862748,0.51416220845660121,0.4864353911604552,0.46020377593231337,0.43538673219707991,0.41190797748068098,0.38969534293347302,0.36868055149808232,0.34879900803981301,0.32998960079452505]
[null,"Discount factor (STPR)",{"$f":"1/(1+$C6)^(C$20)","v":0.96618357487922713},0.93351070036640305,0.90194270566802237,0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217,0.68494571372924851,0.66178329828912896,0.63940415293635666,0.61778179027667302,0.59689061862480497,0.57670591171478747,0.55720377943457733,0.53836113955031628,0.52015569038677911,0.50256588443167061]
[null,"New equipment required","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No"]
[null,"New structures required","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[null,"Estimating costs for a new site"]
[]
[null,null,"Year"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Annualised capital cost"]
[]
["Remaining lifetime","Depreciation"]
[{"$f":"structure_lifetime-LEFT(B35,2)","v":20},"0 year old",{"$f":"IF(C$31<=$A35,rural_site_capital/structure_lifetime,0)","v":5669.9375325318179},5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179,5669.9375325318179]
[]
[null,"Financing cost"]
[{"$f":"structure_lifetime-LEFT(B38,2)","v":20},"0 year old",{"$f":"SUM(C35:$V35)*finance_rate","v":6463.7287870862756},{"$f":"SUM(D35:$V35)*finance_rate","v":6140.5423477319619},{"$f":"SUM(E35:$V35)*finance_rate","v":5817.3559083776481},{"$f":"SUM(F35:$V35)*finance_rate","v":5494.1694690233335},{"$f":"SUM(G35:$V35)*finance_rate","v":5170.9830296690197},{"$f":"SUM(H35:$V35)*finance_rate","v":4847.796590314706},{"$f":"SUM(I35:$V35)*finance_rate","v":4524.6101509603914},{"$f":"SUM(J35:$V35)*finance_rate","v":4201.4237116060776},{"$f":"SUM(K35:$V35)*finance_rate","v":3878.2372722517634},{"$f":"SUM(L35:$V35)*finance_rate","v":3555.0508328974497},{"$f":"SUM(M35:$V35)*finance_rate","v":3231.8643935431364},{"$f":"SUM(N35:$V35)*finance_rate","v":2908.6779541888227},{"$f":"SUM(O35:$V35)*finance_rate","v":2585.491514834509},{"$f":"SUM(P35:$V35)*finance_rate","v":2262.3050754801952},{"$f":"SUM(Q35:$V35)*finance_rate","v":1939.1186361258817},{"$f":"SUM(R35:$V35)*finance_rate","v":1615.9321967715682},{"$f":"SUM(S35:$V35)*finance_rate","v":1292.7457574172545},{"$f":"SUM(T35:$V35)*finance_rate","v":969.55931806294086},{"$f":"SUM(U35:$V35)*finance_rate","v":646.37287870862724},{"$f":"SUM(V35:$V35)*finance_rate","v":323.18643935431362}]
[]
[null,"Depreciaton + financing cost"]
[{"$f":"structure_lifetime-LEFT(B41,2)","v":20},"0 year old",{"$f":"C35+C38","v":12133.666319618093},11810.47988026378,11487.293440909467,11164.107001555152,10840.920562200838,10517.734122846523,10194.547683492208,9871.3612441378955,9548.1748047835808,9224.988365429268,8901.8019260749534,8578.6154867206405,8255.4290473663277,7932.2426080120131,7609.0561686576993,7285.8697293033856,6962.6832899490728,6639.4968505947591,6316.3104112404453,5993.1239718861316]

{"sheet":"Cost_SiteUrban","index":11,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[[18,2,18,21]]}
["Cost of a rural site",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Time horizon (years)",20]
[]
[null,"Finance rate",5.7000000000000002E-2,"finance_rate","Real pre-tax WACC MCT 2021-2026 Statement"]
[null,"Discount rate",3.5000000000000003E-2,"discount_rate","STPR - HMT Green Book 2020"]
[]
[null,"Capital cost for equipment",{"$f":"Equipment","v":7000},"equipment_capital"]
[null,"Capital cost (including installation)",{"$f":"'Cost calculations'!G37","v":10500},"equipment_capital_ins"]
[null,"Capital cost - rural site",{"$f":"'Cost calculations'!C23","v":113398.75065063636},"rural_site_capital"]
[null,"Capital cost - urban site",{"$f":"'Cost calculations'!C24","v":11339.875065063636},"urban_site_capital"]
[]
[]
[null,"Installation (% of capex)",0.5]
[]
[]
[null,"Lifetime of structures",{"$f":"'Spectrum cost inputs'!D21","v":20},"structure_lifetime"]
[]
[null,null,"Years"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Discount factor (WACC)",{"$f":"1/(1+$C5)^(C$20)","v":0.94607379375591305},0.89505562323170573,0.84678866909338302,0.80112456867869719,0.75792295996092451,0.71705105010494274,0.67838320728944457,0.64180057454062855,0.60719070439037715,0.57444721323592918,0.54346945433862748,0.51416220845660121,0.4864353911604552,0.46020377593231337,0.43538673219707991,0.41190797748068098,0.38969534293347302,0.36868055149808232,0.34879900803981301,0.32998960079452505]
[null,"Discount factor (STPR)",{"$f":"1/(1+$C6)^(C$20)","v":0.96618357487922713},0.93351070036640305,0.90194270566802237,0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217,0.68494571372924851,0.66178329828912896,0.63940415293635666,0.61778179027667302,0.59689061862480497,0.57670591171478747,0.55720377943457733,0.53836113955031628,0.52015569038677911,0.50256588443167061]
[null,"New equipment required","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No","No","Yes","No","No","No","No","No"]
[null,"New structures required","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[null,"Estimating costs for a new site"]
[]
[null,null,"Year"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Annualised capital cost"]
[]
["Remaining lifetime","Depreciation"]
[{"$f":"structure_lifetime-LEFT(B35,2)","v":20},"0 year old",{"$f":"IF(C$31<=$A35,urban_site_capital/structure_lifetime,0)","v":566.99375325318181},566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181,566.99375325318181]
[]
[null,"Financing cost"]
[{"$f":"structure_lifetime-LEFT(B38,2)","v":20},"0 year old",{"$f":"SUM(C35:$V35)*finance_rate","v":646.37287870862747},{"$f":"SUM(D35:$V35)*finance_rate","v":614.05423477319607},{"$f":"SUM(E35:$V35)*finance_rate","v":581.73559083776468},{"$f":"SUM(F35:$V35)*finance_rate","v":549.41694690233328},{"$f":"SUM(G35:$V35)*finance_rate","v":517.09830296690188},{"$f":"SUM(H35:$V35)*finance_rate","v":484.77965903147054},{"$f":"SUM(I35:$V35)*finance_rate","v":452.4610150960392},{"$f":"SUM(J35:$V35)*finance_rate","v":420.14237116060781},{"$f":"SUM(K35:$V35)*finance_rate","v":387.82372722517647},{"$f":"SUM(L35:$V35)*finance_rate","v":355.50508328974507},{"$f":"SUM(M35:$V35)*finance_rate","v":323.18643935431368},{"$f":"SUM(N35:$V35)*finance_rate","v":290.86779541888228},{"$f":"SUM(O35:$V35)*finance_rate","v":258.54915148345094},{"$f":"SUM(P35:$V35)*finance_rate","v":226.23050754801952},{"$f":"SUM(Q35:$V35)*finance_rate","v":193.91186361258818},{"$f":"SUM(R35:$V35)*finance_rate","v":161.59321967715681},{"$f":"SUM(S35:$V35)*finance_rate","v":129.27457574172547},{"$f":"SUM(T35:$V35)*finance_rate","v":96.955931806294103},{"$f":"SUM(U35:$V35)*finance_rate","v":64.637287870862735},{"$f":"SUM(V35:$V35)*finance_rate","v":32.318643935431368}]
[]
[null,"Depreciaton + financing cost"]
[{"$f":"structure_lifetime-LEFT(B41,2)","v":20},"0 year old",{"$f":"C35+C38","v":1213.3666319618092},1181.0479880263779,1148.7293440909466,1116.4107001555151,1084.0920562200836,1051.7734122846523,1019.454768349221,987.13612441378962,954.81748047835822,922.49883654292694,890.18019260749543,857.86154867206415,825.54290473663275,793.22426080120135,760.90561686576996,728.58697293033856,696.26832899490728,663.94968505947588,631.63104112404449,599.3123971886132]

{"sheet":"Composite cost scenarios","index":12,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Composite cost scenarios",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Summary costs"]
[]
[null,null,null,"20 year NPC per link","Inc. equipment change"]
[]
[null,"No additional hop (7 years)",null,{"$f":"'Discounted cost_7years'!X81","v":556.47907376462751},1000,"Manual adjustment to £1000 due to unquantified factors (efficient use of revocation period, etc)"]
[null,"No additional hop (15 years)",null,{"$f":"'Discounted cost_15years'!X113","v":2331.5541518427226},3000,"Manual adjustment to £3000 due to unquantified factors (efficient use of revocation period, etc)"]
[null,"Additional hop, 7 years","Average",{"$f":"AVERAGE(D12:D13)","v":163447.42814688158},{"$f":"D9+$E$7","v":164447.42814688158}]
[null,"Additional hop, 15 years","Average",{"$f":"AVERAGE(D14:D15)","v":152294.99777951365},{"$f":"D10+$E$8","v":155294.99777951365}]
[]
[null,"Additional hop, 7 years","Rural",{"$f":"'Discounted cost_7years'!npc_rural_hop","v":186153.30643650991}]
[null,"Additional hop, 7 years","Urban",{"$f":"'Discounted cost_7years'!npc_urban_hop","v":140741.54985725321}]
[null,"Additional hop, 15 years","Rural",{"$f":"'Discounted cost_15years'!npc_rural_hop","v":175000.87606914202}]
[null,"Additional hop, 15 years","Urban",{"$f":"'Discounted cost_15years'!npc_urban_hop","v":129589.1194898853}]
[]
[null,"Calcuate average cost based on different % without additional hops (different mixes of no hop and additional hop costs)"]
[null,"Assume that only 2% of links in the Higher Ongoing Costs scenario will need an additonal hop"]
[]
[null,null,null,"Baseline Scenario ","Higher ongoing Costs","Baseline Scenario (15 equipment lifetime)","Higher Ongoing Costs Scenario (15 equipment lifetime)"]
[null,"Spectrum scenario",null,1,2,3,4,5,6,7]
[]
[null,"No additional hop (7 years)",null,1,0.98,0,0]
[null,"No additional hop (15 years)",null,0,0,1,0.98]
[null,"Additional hop, 7 years equipment",null,0,0.02,0,0]
[null,"Additional hop, 15 years equipment",null,0,0,0,0.02]
[]
[null,"Composite average cost",null,{"$f":"SUMPRODUCT($E7:$E10,D23:D26)","v":1000},{"$f":"SUMPRODUCT($E7:$E10,E23:E26)","v":4268.9485629376322},3000,6045.8999555902737,{"$f":"SUMPRODUCT($D9:$D10,H25:H26)","v":0},{"$f":"SUMPRODUCT($D9:$D10,I25:I26)","v":0},{"$f":"SUMPRODUCT($D9:$D10,J25:J26)","v":0}]
[null,null,null,{"$f":"SUM(D23:D26)=1","v":true},{"$f":"SUM(E23:E26)=1","v":true},true,true]

{"sheet":"Costs By HDA grouping","index":13,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Costs by HDA grouping",null,null,null,null,null,null,null,null,null,null," "]
[null,"Source:","Fixed link area data"]
[null,"Use 25km buffer zone number to estimate costs"]
[]
[null,"26 GHz areas",null,null,null,"Total Costs"]
[null,null,null,null,null,"Scenario 1","Scenario 2","Scenario 3","Scenario 4"]
[null,"Which areas?","FLs revoked (likely maximum, based on 25km buffer zone)",null,"Which areas?",{"$f":"'Composite cost scenarios'!D20","v":"Baseline Scenario "},{"$f":"'Composite cost scenarios'!E20","v":"Higher ongoing Costs"},{"$f":"'Composite cost scenarios'!F20","v":"Baseline Scenario (15 equipment lifetime)"},{"$f":"'Composite cost scenarios'!G20","v":"Higher Ongoing Costs Scenario (15 equipment lifetime)"}]
[null,"Top 20",698,null,"Top 20",{"$f":"($C8*'Composite cost scenarios'!D$28)/1000000","v":0.69799999999999995},{"$f":"($C8*'Composite cost scenarios'!E$28)/1000000","v":2.9797260969304675},{"$f":"($C8*'Composite cost scenarios'!F$28)/1000000","v":2.0939999999999999},{"$f":"($C8*'Composite cost scenarios'!G$28)/1000000","v":4.2200381690020112}]
[null,"Top 40",815,null,"Top 40",{"$f":"($C9*'Composite cost scenarios'!D$28)/1000000","v":0.81499999999999995},{"$f":"($C9*'Composite cost scenarios'!E$28)/1000000","v":3.4791930787941703},{"$f":"($C9*'Composite cost scenarios'!F$28)/1000000","v":2.4449999999999998},{"$f":"($C9*'Composite cost scenarios'!G$28)/1000000","v":4.9274084638060733}]
[null,"Top 80",969,null,"Top 80",{"$f":"($C10*'Composite cost scenarios'!D$28)/1000000","v":0.96899999999999997},{"$f":"($C10*'Composite cost scenarios'!E$28)/1000000","v":4.1366111574865654},{"$f":"($C10*'Composite cost scenarios'!F$28)/1000000","v":2.907},{"$f":"($C10*'Composite cost scenarios'!G$28)/1000000","v":5.8584770569669757}]
[null,"Total UK",1334,null,"Total UK",{"$f":"($C11*'Composite cost scenarios'!D$28)/1000000","v":1.3340000000000001},{"$f":"($C11*'Composite cost scenarios'!E$28)/1000000","v":5.6947773829588018},{"$f":"($C11*'Composite cost scenarios'!F$28)/1000000","v":4.0019999999999998},{"$f":"($C11*'Composite cost scenarios'!G$28)/1000000","v":8.0652305407574243}]
[]
[null,"40 GHz areas (MBNL)"]
[]
[null,"Which areas?","FLs revoked (likely maximum, based on 25km buffer zone)",null,"Which areas?",{"$f":"'Composite cost scenarios'!D20","v":"Baseline Scenario "},{"$f":"'Composite cost scenarios'!E20","v":"Higher ongoing Costs"},{"$f":"'Composite cost scenarios'!F20","v":"Baseline Scenario (15 equipment lifetime)"},{"$f":"'Composite cost scenarios'!G20","v":"Higher Ongoing Costs Scenario (15 equipment lifetime)"}]
[null,"Top 20",2936,null,"Top 20",{"$f":"($C16*'Composite cost scenarios'!D$28)/1000000","v":2.9359999999999999},{"$f":"($C16*'Composite cost scenarios'!E$28)/1000000","v":12.533632980784887},{"$f":"($C16*'Composite cost scenarios'!F$28)/1000000","v":8.8079999999999998},{"$f":"($C16*'Composite cost scenarios'!G$28)/1000000","v":17.750762269613041}]
[null,"Top 40",3426,null,"Top 40",{"$f":"($C17*'Composite cost scenarios'!D$28)/1000000","v":3.4260000000000002},{"$f":"($C17*'Composite cost scenarios'!E$28)/1000000","v":14.625417776624328},{"$f":"($C17*'Composite cost scenarios'!F$28)/1000000","v":10.278},{"$f":"($C17*'Composite cost scenarios'!G$28)/1000000","v":20.713253247852276}]
[null,"Top 80",3956,null,"Top 80",{"$f":"($C18*'Composite cost scenarios'!D$28)/1000000","v":3.956},{"$f":"($C18*'Composite cost scenarios'!E$28)/1000000","v":16.887960514981273},{"$f":"($C18*'Composite cost scenarios'!F$28)/1000000","v":11.868},{"$f":"($C18*'Composite cost scenarios'!G$28)/1000000","v":23.91758022431512}]
[null,"Total UK",4417,null,"Total UK",{"$f":"($C19*'Composite cost scenarios'!D$28)/1000000","v":4.4169999999999998},{"$f":"($C19*'Composite cost scenarios'!E$28)/1000000","v":18.855945802495519},{"$f":"($C19*'Composite cost scenarios'!F$28)/1000000","v":13.250999999999999},{"$f":"($C19*'Composite cost scenarios'!G$28)/1000000","v":26.704740103842241}]
[]
[]
[null,"40 GHz areas (H3G)"]
[]
[null,"Which areas?","FLs revoked (likely maximum, based on 25km buffer zone)",null,"Which areas?",{"$f":"'Composite cost scenarios'!D20","v":"Baseline Scenario "},{"$f":"'Composite cost scenarios'!E20","v":"Higher ongoing Costs"},{"$f":"'Composite cost scenarios'!F20","v":"Baseline Scenario (15 equipment lifetime)"},{"$f":"'Composite cost scenarios'!G20","v":"Higher Ongoing Costs Scenario (15 equipment lifetime)"}]
[null,"Top 20",45,null,"Top 20",{"$f":"($C25*'Composite cost scenarios'!D$28)/1000000","v":4.4999999999999998E-2},{"$f":"($C25*'Composite cost scenarios'!E$28)/1000000","v":0.19210268533219343},{"$f":"($C25*'Composite cost scenarios'!F$28)/1000000","v":0.13500000000000001},{"$f":"($C25*'Composite cost scenarios'!G$28)/1000000","v":0.27206549800156232}]
[null,"Top 40",48,null,"Top 40",{"$f":"($C26*'Composite cost scenarios'!D$28)/1000000","v":4.8000000000000001E-2},{"$f":"($C26*'Composite cost scenarios'!E$28)/1000000","v":0.20490953102100634},{"$f":"($C26*'Composite cost scenarios'!F$28)/1000000","v":0.14399999999999999},{"$f":"($C26*'Composite cost scenarios'!G$28)/1000000","v":0.29020319786833315}]
[null,"Top 80",63,null,"Top 80",{"$f":"($C27*'Composite cost scenarios'!D$28)/1000000","v":6.3E-2},{"$f":"($C27*'Composite cost scenarios'!E$28)/1000000","v":0.26894375946507088},{"$f":"($C27*'Composite cost scenarios'!F$28)/1000000","v":0.189},{"$f":"($C27*'Composite cost scenarios'!G$28)/1000000","v":0.38089169720218724}]
[null,"Total UK",63,null,"Total UK",{"$f":"($C28*'Composite cost scenarios'!D$28)/1000000","v":6.3E-2},{"$f":"($C28*'Composite cost scenarios'!E$28)/1000000","v":0.26894375946507088},{"$f":"($C28*'Composite cost scenarios'!F$28)/1000000","v":0.189},{"$f":"($C28*'Composite cost scenarios'!G$28)/1000000","v":0.38089169720218724}]

{"sheet":"Final OutputCosts --->","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FinalOutputTables","index":15,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Costs by HDA grouping",null,null,null,null,null,null,null,null,null,null," "]
[null,"26 GHz",null,null,null,null,null,"40 GHz (MBNL)",null,null,null,null,null,"40 GHz (H3G)"]
[]
[null,"Number of High Density Areas","Baseline Scenario (£m)","Higher Ongoing Costs Scenario (£m)","Baseline  – 15 year equipment lifetime (£m)","Higher Ongoing Costs– 15 year equipment lifetime (£m)",null,"Number of High Density Areas","Baseline Scenario (£m)","Higher Ongoing Costs Scenario (£m)","Baseline  – 15 year equipment lifetime (£m)","Higher Ongoing Costs– 15 year equipment lifetime (£m)",null,"Number of High Density Areas","Baseline Scenario (£m)","Higher Ongoing Costs Scenario (£m)","Baseline  – 15 year equipment lifetime (£m)","Higher Ongoing Costs– 15 year equipment lifetime (£m)"]
[null,20,{"$f":"'Costs By HDA grouping'!F8","v":0.69799999999999995},{"$f":"'Costs By HDA grouping'!G8","v":2.9797260969304675},{"$f":"'Costs By HDA grouping'!H8","v":2.0939999999999999},{"$f":"'Costs By HDA grouping'!I8","v":4.2200381690020112},null,20,{"$f":"'Costs By HDA grouping'!F16","v":2.9359999999999999},{"$f":"'Costs By HDA grouping'!G16","v":12.533632980784887},{"$f":"'Costs By HDA grouping'!H16","v":8.8079999999999998},{"$f":"'Costs By HDA grouping'!I16","v":17.750762269613041},null,20,{"$f":"'Costs By HDA grouping'!F25","v":4.4999999999999998E-2},{"$f":"'Costs By HDA grouping'!G25","v":0.19210268533219343},{"$f":"'Costs By HDA grouping'!H25","v":0.13500000000000001},{"$f":"'Costs By HDA grouping'!I25","v":0.27206549800156232}]
[null,40,{"$f":"'Costs By HDA grouping'!F9","v":0.81499999999999995},{"$f":"'Costs By HDA grouping'!G9","v":3.4791930787941703},{"$f":"'Costs By HDA grouping'!H9","v":2.4449999999999998},{"$f":"'Costs By HDA grouping'!I9","v":4.9274084638060733},null,40,{"$f":"'Costs By HDA grouping'!F17","v":3.4260000000000002},{"$f":"'Costs By HDA grouping'!G17","v":14.625417776624328},{"$f":"'Costs By HDA grouping'!H17","v":10.278},{"$f":"'Costs By HDA grouping'!I17","v":20.713253247852276},null,40,{"$f":"'Costs By HDA grouping'!F26","v":4.8000000000000001E-2},{"$f":"'Costs By HDA grouping'!G26","v":0.20490953102100634},{"$f":"'Costs By HDA grouping'!H26","v":0.14399999999999999},{"$f":"'Costs By HDA grouping'!I26","v":0.29020319786833315}]
[null,80,{"$f":"'Costs By HDA grouping'!F10","v":0.96899999999999997},{"$f":"'Costs By HDA grouping'!G10","v":4.1366111574865654},{"$f":"'Costs By HDA grouping'!H10","v":2.907},{"$f":"'Costs By HDA grouping'!I10","v":5.8584770569669757},null,80,{"$f":"'Costs By HDA grouping'!F18","v":3.956},{"$f":"'Costs By HDA grouping'!G18","v":16.887960514981273},{"$f":"'Costs By HDA grouping'!H18","v":11.868},{"$f":"'Costs By HDA grouping'!I18","v":23.91758022431512},null,80,{"$f":"'Costs By HDA grouping'!F27","v":6.3E-2},{"$f":"'Costs By HDA grouping'!G27","v":0.26894375946507088},{"$f":"'Costs By HDA grouping'!H27","v":0.189},{"$f":"'Costs By HDA grouping'!I27","v":0.38089169720218724}]
[null,"All UK",{"$f":"'Costs By HDA grouping'!F11","v":1.3340000000000001},{"$f":"'Costs By HDA grouping'!G11","v":5.6947773829588018},{"$f":"'Costs By HDA grouping'!H11","v":4.0019999999999998},{"$f":"'Costs By HDA grouping'!I11","v":8.0652305407574243},null,"All UK",{"$f":"'Costs By HDA grouping'!F19","v":4.4169999999999998},{"$f":"'Costs By HDA grouping'!G19","v":18.855945802495519},{"$f":"'Costs By HDA grouping'!H19","v":13.250999999999999},{"$f":"'Costs By HDA grouping'!I19","v":26.704740103842241},null,"All UK",{"$f":"'Costs By HDA grouping'!F28","v":6.3E-2},{"$f":"'Costs By HDA grouping'!G28","v":0.26894375946507088},{"$f":"'Costs By HDA grouping'!H28","v":0.189},{"$f":"'Costs By HDA grouping'!I28","v":0.38089169720218724}]
[]
[]
[null,"Remaining life of equipment at the start of the revocation period.","Value to be written off if revocation period = 5 years"]
[null,"7 years",{"$f":"'Discounted cost_7years'!X71","v":2605.5482448024504}]
[null,"6 years",{"$f":"'Discounted cost_7years'!X72","v":1289.8052715499421}]
[null,"5 years",{"$f":"'Discounted cost_7years'!X73","v":0}]
[null,"4 years",{"$f":"'Discounted cost_7years'!X74","v":0}]
[null,"3 years",{"$f":"'Discounted cost_7years'!X75","v":0}]
[null,"2 years",{"$f":"'Discounted cost_7years'!X76","v":0}]
[null,"1 year",{"$f":"'Discounted cost_7years'!X77","v":0}]
[null,"Average",{"$f":"'Discounted cost_7years'!X81","v":556.47907376462751}]
[]
[]
[null,"26 GHz - Baseline",null,null,null,null,null,"40 GHz - Baseline (MBNL)",null,null,null,null,null,"40 GHz - Baseline (H3G)"]
[]
[null,"Number of high density areas","Number of fixed links revoked","Estimated cost of revocation (£m)",null,null,null,"Number of high density areas","Number of fixed links revoked","Estimated cost of revocation (£m)",null,null,null,"Number of high density areas","Number of fixed links revoked","Estimated cost of revocation (£m)"]
[null,20,{"$f":"'Costs By HDA grouping'!C8","v":698},{"$f":"'Costs By HDA grouping'!F8","v":0.69799999999999995},null,null,null,20,{"$f":"'Costs By HDA grouping'!C16","v":2936},{"$f":"'Costs By HDA grouping'!F16","v":2.9359999999999999},null,null,null,20,{"$f":"'Costs By HDA grouping'!C25","v":45},{"$f":"'Costs By HDA grouping'!F25","v":4.4999999999999998E-2}]
[null,40,{"$f":"'Costs By HDA grouping'!C9","v":815},{"$f":"'Costs By HDA grouping'!F9","v":0.81499999999999995},null,null,null,40,{"$f":"'Costs By HDA grouping'!C17","v":3426},{"$f":"'Costs By HDA grouping'!F17","v":3.4260000000000002},null,null,null,40,{"$f":"'Costs By HDA grouping'!C26","v":48},{"$f":"'Costs By HDA grouping'!F26","v":4.8000000000000001E-2}]
[null,80,{"$f":"'Costs By HDA grouping'!C10","v":969},{"$f":"'Costs By HDA grouping'!F10","v":0.96899999999999997},null,null,null,80,{"$f":"'Costs By HDA grouping'!C18","v":3956},{"$f":"'Costs By HDA grouping'!F18","v":3.956},null,null,null,80,{"$f":"'Costs By HDA grouping'!C27","v":63},{"$f":"'Costs By HDA grouping'!F27","v":6.3E-2}]
[null,"All UK",{"$f":"'Costs By HDA grouping'!C11","v":1334},{"$f":"'Costs By HDA grouping'!F11","v":1.3340000000000001},null,null,null,"All UK",{"$f":"'Costs By HDA grouping'!C19","v":4417},{"$f":"'Costs By HDA grouping'!F19","v":4.4169999999999998},null,null,null,"All UK",{"$f":"'Costs By HDA grouping'!C28","v":63},{"$f":"'Costs By HDA grouping'!F28","v":6.3E-2}]
[]
[null,"26 GHz - Higher Costs",null,null,null,null,null,"40 GHz - Higher Costs (MBNL)",null,null,null,null,null,"40 GHz - Higher Costs (H3G)"]
[]
[null,"Number of high density areas","Number of fixed links revoked","Estimated cost of revocation (£m)",null,null,null,"Number of high density areas","Number of fixed links revoked","Estimated cost of revocation (£m)",null,null,null,"Number of high density areas","Number of fixed links revoked","Estimated cost of revocation (£m)"]
[null,20,{"$f":"'Costs By HDA grouping'!C8","v":698},{"$f":"'Costs By HDA grouping'!G8","v":2.9797260969304675},null,null,null,20,{"$f":"'Costs By HDA grouping'!C16","v":2936},{"$f":"'Costs By HDA grouping'!G16","v":12.533632980784887},null,null,null,20,{"$f":"'Costs By HDA grouping'!C25","v":45},{"$f":"'Costs By HDA grouping'!G25","v":0.19210268533219343}]
[null,40,{"$f":"'Costs By HDA grouping'!C9","v":815},{"$f":"'Costs By HDA grouping'!G9","v":3.4791930787941703},null,null,null,40,{"$f":"'Costs By HDA grouping'!C17","v":3426},{"$f":"'Costs By HDA grouping'!G17","v":14.625417776624328},null,null,null,40,{"$f":"'Costs By HDA grouping'!C26","v":48},{"$f":"'Costs By HDA grouping'!G26","v":0.20490953102100634}]
[null,80,{"$f":"'Costs By HDA grouping'!C10","v":969},{"$f":"'Costs By HDA grouping'!G10","v":4.1366111574865654},null,null,null,80,{"$f":"'Costs By HDA grouping'!C18","v":3956},{"$f":"'Costs By HDA grouping'!G18","v":16.887960514981273},null,null,null,80,{"$f":"'Costs By HDA grouping'!C27","v":63},{"$f":"'Costs By HDA grouping'!G27","v":0.26894375946507088}]
[null,"All UK",{"$f":"'Costs By HDA grouping'!C11","v":1334},{"$f":"'Costs By HDA grouping'!G11","v":5.6947773829588018},null,null,null,"All UK",{"$f":"'Costs By HDA grouping'!C19","v":4417},{"$f":"'Costs By HDA grouping'!G19","v":18.855945802495519},null,null,null,"All UK",{"$f":"'Costs By HDA grouping'!C28","v":63},{"$f":"'Costs By HDA grouping'!G28","v":0.26894375946507088}]
[]
[]
[null,"Number of High density areas","Number of fixed links revoked","Estimated cost of revocation – modified baseline Scenario (£m)","Estimated cost of revocation – modified Higher Ongoing Costs Scenario (£m)",null,null,"Number of High density areas","Number of fixed links revoked","Estimated cost of revocation – modified baseline Scenario (£m)","Estimated cost of revocation – modified Higher Ongoing Costs Scenario (£m)",null,null,"Number of High density areas","Number of fixed links revoked","Estimated cost of revocation – modified baseline Scenario (£m)","Estimated cost of revocation – modified Higher Ongoing Costs Scenario (£m)"]
[null,20,{"$f":"'Costs By HDA grouping'!C8","v":698},{"$f":"'Costs By HDA grouping'!H8","v":2.0939999999999999},{"$f":"'Costs By HDA grouping'!I8","v":4.2200381690020112},null,null,20,{"$f":"'Costs By HDA grouping'!C16","v":2936},{"$f":"'Costs By HDA grouping'!H16","v":8.8079999999999998},{"$f":"'Costs By HDA grouping'!I16","v":17.750762269613041},null,null,20,{"$f":"'Costs By HDA grouping'!C25","v":45},{"$f":"'Costs By HDA grouping'!H25","v":0.13500000000000001},{"$f":"'Costs By HDA grouping'!I25","v":0.27206549800156232}]
[null,40,{"$f":"'Costs By HDA grouping'!C9","v":815},{"$f":"'Costs By HDA grouping'!H9","v":2.4449999999999998},{"$f":"'Costs By HDA grouping'!I9","v":4.9274084638060733},null,null,40,{"$f":"'Costs By HDA grouping'!C17","v":3426},{"$f":"'Costs By HDA grouping'!H17","v":10.278},{"$f":"'Costs By HDA grouping'!I17","v":20.713253247852276},null,null,40,{"$f":"'Costs By HDA grouping'!C26","v":48},{"$f":"'Costs By HDA grouping'!H26","v":0.14399999999999999},{"$f":"'Costs By HDA grouping'!I26","v":0.29020319786833315}]
[null,80,{"$f":"'Costs By HDA grouping'!C10","v":969},{"$f":"'Costs By HDA grouping'!H10","v":2.907},{"$f":"'Costs By HDA grouping'!I10","v":5.8584770569669757},null,null,80,{"$f":"'Costs By HDA grouping'!C18","v":3956},{"$f":"'Costs By HDA grouping'!H18","v":11.868},{"$f":"'Costs By HDA grouping'!I18","v":23.91758022431512},null,null,80,{"$f":"'Costs By HDA grouping'!C27","v":63},{"$f":"'Costs By HDA grouping'!H27","v":0.189},{"$f":"'Costs By HDA grouping'!I27","v":0.38089169720218724}]
[null,"All UK",{"$f":"'Costs By HDA grouping'!C11","v":1334},{"$f":"'Costs By HDA grouping'!H11","v":4.0019999999999998},{"$f":"'Costs By HDA grouping'!I11","v":8.0652305407574243},null,null,"All UK",{"$f":"'Costs By HDA grouping'!C19","v":4417},{"$f":"'Costs By HDA grouping'!H19","v":13.250999999999999},{"$f":"'Costs By HDA grouping'!I19","v":26.704740103842241},null,null,"All UK",{"$f":"'Costs By HDA grouping'!C28","v":63},{"$f":"'Costs By HDA grouping'!H28","v":0.189},{"$f":"'Costs By HDA grouping'!I28","v":0.38089169720218724}]