{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Contents","Version History","Quality Assurance","Style Guidelines","Instructions","Assumptions","Projections","Spectrum Opt","Capacity Model"],"not_rendered":{"charts":5,"images":1,"macros":1,"external_links":0,"defined_names":162,"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":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[25,0,25,3],[41,0,41,3],[29,0,29,3],[31,0,31,3],[33,0,33,3],[35,0,35,3],[37,0,37,3],[39,0,39,3]]}
[]
[null,null,null,null,null,{"$f":"Workbook.Title","v":"MDS Capacity Model"}]
[]
["Information"]
[]
["Title ","MDS Capacity Model"]
["Project case code","1213-PR-001639"]
["Status","Approved for release"]
["Author","Ofcom"]
[]
["Confidentiality status","Approved for release"]
[]
[]
["Contents"]
[]
["Sheet","Description",null,"Status","Notes"]
["Contents","This contents sheet",null,"Approved for release"]
["Instructions","Instructions for running the model",null,"Approved for release"]
["Assumptions","Sets out all assumptions used",null,"Approved for release"]
["Projections","Projects key values to 2030",null,"Approved for release"]
["Spectrum Opt","Optimises spectrum mix between indoors/outdoors",null,"Approved for release"]
["Capacity Model","Calculation sheet",null,"Approved for release"]
[]
["Note"]
[]
["As explained in the accompanying consultation document (see, in particular, paragraphs A7.2 and A7.3), the purpose of our modelling was to give a high level illustration of how mobile network capacity may develop in the next 10 – 20 years. The modelling approach that we have adopted for this consultation is highly simplified and depends on forecasts of the future that are highly uncertain. Therefore, the assumptions and results of this broad brush analysis should not be treated as determinative as to our prioritisation of bands, being for illustrative purposive only. In addition, any inconsistency between this modelling and prior analysis does not mean necessarily that Ofcom has changed its view, nor should the assumptions used in this analysis be taken to be Ofcom’s considered view on these matters."]
[]
["Terms and conditions"]
[]
["The terms and conditions on which OFCOM is making available the MDS Capacity Model are set out below. "]
[]
["The MDS Capacity model was developed to illustrate how mobile network capacity may develop over the next 10 - 20 years. "]
[]
["All right, title and interest in the provided model (the ‘MDS Capacity Model’) constructed in Excel are owned by OFCOM. Such title and interest is protected by  intellectual property laws. While you may freely use the MDS Capacity Model for the purposes for which it is provided, as set out in the accompanying model documentation, it is not to be modified in any way or used for commercial gain or otherwise without the prior written permission of OFCOM."]
[]
["No representation or warranty is given as to the accuracy, completeness or correctness of the MDS Capacity 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 MDS Capacity Model or material derived from the MDS Capacity Model. OFCOM does not warrant that the functions contained in the MDS Capacity Model will be uninterrupted or error free. Also, OFCOM does not warrant that defects will be corrected, or that the MDS Capacity Modell provided is free of viruses."]
[]
["In 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 MDS Capacity Model. By using this MDS Capacity Model, you agree to the above."]
[]
["These Terms and Conditions shall be covered by and construed in accordance with the laws of England and Wales.  Any dispute arising under these Terms and Conditions shall be subject to the exclusive jurisdiction of the Courts of England and Wales"]

{"sheet":"Version History","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Version Histrory"]
[]
["History"]
[]
["Version","Date ","Author","Details of modifications introduced"]

{"sheet":"Quality Assurance","index":2,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Quality Assurance"]
[]
["Workbook QA"]
[]
["Verified by","Enter name of reviewer"]
["Date","Enter date review completed"]
["Version","Enter version of workbook checked"]
["Status","QA completed but issues to resolve"]
[]
["Type of QA","Self-check by author","Yes"]
[null,"Internal QA - informal","Yes"]
[null,"Internal QA - formal","Yes"]
[null,"External QA","Yes"]
[]
["Objective of QA","Check input data","Yes"]
[null,"Check calculations","Yes"]
[null,"Check methodology","Yes"]
[null,"Check implementation","Yes"]
[]
["QA results delivery format","Report","Yes"]
[null,"Presentation","Yes"]
[null,"Notes to spreadsheet","Yes"]
[]
["QA notes"]
[]
["Sheet","Issue","Details","Status (issue resolved?)"]

{"sheet":"Style Guidelines","index":3,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,"Style Guidelines"]
["NB Use Window Unfreeze Panes (on each worksheet) to have row 1 scroll with the rest of the worksheet"]
[]
["Styles"]
[]
[]
[null,"Input",100,null,"An input to the model that it is expected the user will change (change at will)"]
[]
[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,"Note or Source","Note",null,"A note (NB smaller than standard font size)"]
[]
[null,"Un-format",null,null,"Going back to default Excel formatting"]
[]
[null,"Advanced user styles"]
[]
[null,"Input assumption",100,null,"An input to the model that it is expected the user will change (change at will)"]
[]
[null,"Input Data",100,null,"A piece of real data (only change if you have better data)"]
[]
[null,"Checksum",0,null,"A side calculation intended solely to cross check a result (and which therefore should not be referenced anywhere else in the model)"]
[]
[null,"Note ","Note",null,"A note (NB smaller than standard font size)"]
[]
[null,"Source","Source",null,"A source"]
[]
[null,"Named range","Name",null,"An Excel Name applying to one or more adjacent cells (use Insert Name Create to actually create the Excel Names)"]
[]
[null,"H1","Title",null,"Heading level 1"]
[]
[null,"H2","Title",null,"Heading level 2"]
[]
[null,"H3","Title",null,"Heading level 3"]
[]
[null,"H4","Title",null,"Heading level 4"]

{"sheet":"Instructions","index":4,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[75,1,75,2],[3,1,15,8],[43,3,43,11],[58,1,58,2],[58,4,58,5],[58,7,58,8],[58,10,58,11]]}
["Information",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,"To run the model: \n1. Select the modelling year on the Assumptions! sheet cell B4\n2. On the Capacity Model! sheet add any additional spectrum bands to cells E5:E9 and J5:J9 to model the capacity impact of a spectrum increase in the modelling year\n3. On the Spectrum Opt! sheet click spectrum optimisation button in top right corner\n4. On the Capacity Model! sheet Cells B13:H17 give the capacity in 2012. Cells B20:H24 give the capacity in the modelling year with the only the spectrum outlined in the Assumptions! sheet, cells B27:H31 give this capacity relative to the capacity in 2012. Cells B34:H38 give the capacity in the modelling year with the base spectrum plus the spectrum increase, cells B41:H45 give this capacity relative to 2012. Cells B48:H52 give the increase in capacity as a result of the spectrum increase.\n5. Cells B56:L148 are used for plotting graphs; change the modelling year accordingly and paste values from the cells indicated to update the results.\n6. After changing any of the assumptions you will need to re-run the spectrum optimisation macro (see step 3)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Key:"]
[null,null,null,"Input"]
[null,null,null,"Output"]
[null,null,null,"Paste Values"]
[null,null,null,"Note or source"]

{"sheet":"Assumptions","index":5,"n_rows":101,"n_cols":14,"rows_kept":101,"cut":false,"hidden":false,"merged":[[5,4,5,5],[5,1,5,2],[5,7,5,8],[5,10,5,11],[51,3,51,11],[83,1,83,2],[66,1,66,2],[66,4,66,5],[66,7,66,8],[66,10,66,11]]}
["Assumptions",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Number of Starting Sites",18000]
["Modelling year",2030]
[]
["Single User Throughput","0 - 50%",null,null,"50 - 80%",null,null,"80 - 90%",null,null,"90 - 100%"]
[null,"Out-to-Out","Out-to-In",null,"Out-to-Out","Out-to-In",null,"Out-to-Out","Out-to-In",null,"Out-to-Out","Out-to-In",null,"Average frequency (GHz)"]
["Sub 1 GHz",{"$f":"IF($B$3=12000,B74,B69)","v":8.1628224556765101},{"$f":"IF($B$3=12000,C74,C69)","v":8.0332895035263707},null,{"$f":"IF($B$3=12000,E74,E69)","v":8.1077275331181102},7.6667574544564099,null,8.5014799628359903,7.6802428417229498,null,9.0646418069457102,7.7547839135708099,null,0.5]
["1 - 2 GHz ",{"$f":"IF($B$3=12000,B75,B70)","v":8.1119873203378994},7.2193782425548498,null,{"$f":"IF($B$3=12000,E75,E70)","v":7.9714450788514197},6.2476909526995703,null,8.2324925002835005,5.8923928155524203,null,8.6140255826621299,5.6116843053644798,null,1.5]
["2 - 3 GHz",{"$f":"IF($B$3=12000,B76,B71)","v":8.0728518570003303},6.5525837967492002,null,{"$f":"IF($B$3=12000,E76,E71)","v":7.8683505708214403},5.3726770383316804,null,8.0471930398981701,4.9931495295751702,null,8.3407108913699108,4.61020194958747,null,2.5]
["3 - 4 GHz",{"$f":"GROWTH(B$8:B$10,$N$8:$N$10,$N11)","v":8.026351307889108},{"$f":"GROWTH(C$8:C$10,$N$8:$N$10,$N11)","v":5.9081897013531659},null,{"$f":"GROWTH(E$8:E$10,$N$8:$N$10,$N11)","v":7.74624432688932},{"$f":"GROWTH(F$8:F$10,$N$8:$N$10,$N11)","v":4.4574485967466151},null,{"$f":"GROWTH(H$8:H$10,$N$8:$N$10,$N11)","v":7.816997688892811},{"$f":"GROWTH(I$8:I$10,$N$8:$N$10,$N11)","v":3.959861761693181},null,{"$f":"GROWTH(K$8:K$10,$N$8:$N$10,$N11)","v":7.9757655235007716},{"$f":"GROWTH(L$8:L$10,$N$8:$N$10,$N11)","v":3.4802561527498361},null,3.5]
["4 - 6 GHz",{"$f":"GROWTH(B$8:B$10,$N$8:$N$10,$N12)","v":7.9599096613853035},{"$f":"GROWTH(C$8:C$10,$N$8:$N$10,$N12)","v":5.0710022728012927},null,{"$f":"GROWTH(E$8:E$10,$N$8:$N$10,$N12)","v":7.5740751193176719},{"$f":"GROWTH(F$8:F$10,$N$8:$N$10,$N12)","v":3.4140556961556072},null,{"$f":"GROWTH(H$8:H$10,$N$8:$N$10,$N12)","v":7.5015739784799473},{"$f":"GROWTH(I$8:I$10,$N$8:$N$10,$N12)","v":2.8670135129762877},null,{"$f":"GROWTH(K$8:K$10,$N$8:$N$10,$N12)","v":7.4931028386941891},{"$f":"GROWTH(L$8:L$10,$N$8:$N$10,$N12)","v":2.3562637230241332},null,5]
[]
["Sub 1 GHz",{"$f":"B79","v":8.0475245330477492},{"$f":"C79","v":4.4047334418938702},null,{"$f":"E79","v":7.10959221889566},{"$f":"F79","v":2.9992202697658099},null,6.5783222968748998,2.4951686475303001,null,8.4850626063766406,4.1084123868712998,null,0.5]
["1 - 2 GHz ",{"$f":"B80","v":6.4472127629031402},1.89343748304121,null,{"$f":"E80","v":5.06216795880104},1.1869199529513199,null,4.50188385927708,0.99756748683297403,null,6.4315456804652804,1.7181403196584499,null,1.5]
["2 - 3 GHz",{"$f":"B81","v":5.68736245416566},1.2764610923346,null,{"$f":"E81","v":4.2790105659124897},0.76545008045270801,null,3.7611114622676101,0.66192604817634504,null,5.6150701717248301,1.0938940613941299,null,2.5]
["3 - 4 GHz",{"$f":"GROWTH(B$14:B$16,$N$14:$N$16,$N17)","v":4.7050437935469525},{"$f":"GROWTH(C$14:C$16,$N$14:$N$16,$N17)","v":0.6375007174625158},null,{"$f":"GROWTH(E$14:E$16,$N$14:$N$16,$N17)","v":3.2260681247248759},{"$f":"GROWTH(F$14:F$16,$N$14:$N$16,$N17)","v":0.35647088629620893},null,{"$f":"GROWTH(H$14:H$16,$N$14:$N$16,$N17)","v":2.7509092870827385},{"$f":"GROWTH(I$14:I$16,$N$14:$N$16,$N17)","v":0.31332385017523967},null,{"$f":"GROWTH(K$14:K$16,$N$14:$N$16,$N17)","v":4.461442870845393},{"$f":"GROWTH(L$14:L$16,$N$14:$N$16,$N17)","v":0.52626425891657613},null,3.5]
["4 - 6 GHz",{"$f":"GROWTH(B$14:B$16,$N$14:$N$16,$N18)","v":3.6266038484377949},{"$f":"GROWTH(C$14:C$16,$N$14:$N$16,$N18)","v":0.2517947324270513},null,{"$f":"GROWTH(E$14:E$16,$N$14:$N$16,$N18)","v":2.2044362012123551},{"$f":"GROWTH(F$14:F$16,$N$14:$N$16,$N18)","v":0.12799866757196246},null,{"$f":"GROWTH(H$14:H$16,$N$14:$N$16,$N18)","v":1.8087438274534158},{"$f":"GROWTH(I$14:I$16,$N$14:$N$16,$N18)","v":0.11581788501419309},null,{"$f":"GROWTH(K$14:K$16,$N$14:$N$16,$N18)","v":3.2734102568573751},{"$f":"GROWTH(L$14:L$16,$N$14:$N$16,$N18)","v":0.19506520210407097},null,5]
[]
[null,"Unit",2012,2030,"Annual Growth"]
["Spectral efficiency (Source: Real Wireless)","bps/Hz",1.64,10.199999999999999,{"$f":"((D21/C21)^(1/18))-1","v":0.10687243859981077}]
[]
["Number of Macro Sites",null,2012,2020,"Annual Growth"]
["0 - 50%","#",{"$f":"IF($B$3=12000,$B86,$C86)","v":7181},{"$f":"C24*((1+E24)^8)","v":7775.9940031152437},0.01]
["50 - 80%","#",{"$f":"IF($B$3=12000,$B87,$C87)","v":5473},{"$f":"C25*((1+E25)^8)","v":5926.4747499024834},0.01]
["80 - 90%","#",{"$f":"IF($B$3=12000,$B88,$C88)","v":2094},{"$f":"C26*((1+E26)^8)","v":2267.5019415851998},0.01]
["90 - 100%",null,{"$f":"IF($B$3=12000,$B89,$C89)","v":3252},{"$f":"C27*((1+E27)^8)","v":3521.4500067025169},0.01]
["Number of Small Cells"]
["0 - 50%","#",{"$f":"C24*($C$34*(B99/B94)+(1-$C$34)*(B100/B95))","v":5695.5169951309999},{"$f":"C29*((1+E29)^8)","v":12208.846497927643},0.1]
["50 - 80%","#",{"$f":"C25*(B100/B95)","v":241.10132158590309},{"$f":"C30*((1+E30)^8)","v":516.82209502775356},0.1]
["80 - 90%","#",{"$f":"C26*(B100/B95)","v":92.246696035242294},{"$f":"C31*((1+E31)^8)","v":197.73898538061684},0.1]
["90 - 100%","#",{"$f":"C31","v":92.246696035242294},{"$f":"C32*((1+E32)^8)","v":197.73898538061684},0.1]
[]
["Proportion of the 0 - 50% population that is urban","%",0.2]
[]
["Proportion of indoor users who offload",null,2012,2020,2030]
["0 - 50%","%",0.5,0.8,0.9]
["50 - 80%","%",0.5,0.7,0.8]
["80 - 90%","%",0.5,0.6,0.7]
["90 - 100%","%",0.5,0.6,0.7]
[]
["Share of mobile traffic that is indoors","%",0.75]
[]
["Population - Inputs from 4G Technical Model"]
["0 - 50%","#",28588215]
["50 - 80%","#",17162838]
["80 - 90%","#",5648553]
["90 - 100%","#",{"$f":"58791867-SUM(C45:C47)","v":7392261}]
[]
["Ratio of macro to small cell sectors","#",3]
[]
["Spectrum Portfolio",null,null,"MHz available for downlink in:"]
["Frequency band","Frequency Group","Use",2012,2013,2014,2015,2016,2017,2018,2019,2020]
["800 MHz","Sub 1 GHz","Macro",0,30,30,30,30,30,30,30,30]
["900 MHz","Sub 1 GHz","Macro",10,10,10,10,15,20,25,30,30]
["1800 MHz","1 - 2 GHz","Macro",22,22,22,22,36,46,56,66,72]
["2100 MHz","2 - 3 GHz","Both",60,60,60,60,60,60,60,60,60]
["2600 MHz (paired)","2 - 3 GHz","Both",0,70,70,70,70,70,70,70,70]
["2600 MHz (unpaired)","2 - 3 GHz","Both",0,28,28,28,28,28,28,28,28]
["2300 MHz (unpaired)","2 - 3 GHz","Small Cell",0,0,0,28,28,28,28,28,28]
["3400 - 3600 MHz","3 - 4 GHz","Small Cell",0,0,0,133,133,133,133,133,133]
["700 MHz","Sub 1 GHz","Macro",0,0,0,0,0,0,0,0,30]
[]
[]
["Average maximum single user throughput to a user (Mbps) - Inputs from 4G Technical Model"]
[]
[null,"0 to 50%",null,null,"50 to 80%",null,null,"80 to 90%",null,null,"90 to 100%"]
["18000 Macro Sites","Outdoor","Deep",null,"Outdoor","Deep",null,"Outdoor","Deep",null,"Outdoor","Deep"]
["800 MHz",8.1628224556765101,8.0332895035263707,null,8.1077275331181102,7.6667574544564099,null,8.5014799628359903,7.6802428417229498,null,9.0646418069457102,7.7547839135708099]
["1800 MHz",8.1119873203378994,7.2193782425548498,null,7.9714450788514197,6.2476909526995703,null,8.2324925002835005,5.8923928155524203,null,8.6140255826621299,5.6116843053644798]
["2600 MHz",8.0728518570003303,6.5525837967492002,null,7.8683505708214403,5.3726770383316804,null,8.0471930398981701,4.9931495295751702,null,8.3407108913699108,4.61020194958747]
[]
["12000 Macro Sites"]
["800 MHz",7.7079840424513701,7.4961096110429697,null,7.6939639742714796,7.0561358166170098,null,8.3820955672134598,7.2051546760685801,null,8.8816980258555294,7.08466193388979]
["1800 MHz",7.6568762214562502,6.47147884439861,null,7.5093871391129303,5.4509379532573004,null,8.0014425183551392,5.1961741194111699,null,8.2243812234101004,4.7971974292605104]
["2600 MHz",7.6113109618205899,5.7202219055057597,null,7.37175432799493,4.5464821850265498,null,7.7522906547565302,4.28080334165778,null,7.8537954889324304,3.8393265500499898]
[]
["18000 Small Cell Sites"]
["800 MHz",8.0475245330477492,4.4047334418938702,null,7.10959221889566,2.9992202697658099,null,6.5783222968748998,2.4951686475303001,null,8.4850626063766406,4.1084123868712998]
["1800 MHz",6.4472127629031402,1.89343748304121,null,5.06216795880104,1.1869199529513199,null,4.50188385927708,0.99756748683297403,null,6.4315456804652804,1.7181403196584499]
["2600 MHz",5.68736245416566,1.2764610923346,null,4.2790105659124897,0.76545008045270801,null,3.7611114622676101,0.66192604817634504,null,5.6150701717248301,1.0938940613941299]
[]
["Site Numbers - Inputs from 4G Technical Model"]
[null,"Total Network Size:"]
["Number of Macro Sites",12000,18000]
["0 - 50%",4820,7181]
["50 - 80%",3655,5473]
["80 - 90%",1359,2094]
["90 - 100%",2166,3252]
[]
[]
["Real Wireless Site Number Estimates"]
["Macro Sites",2012,2030]
["Urban",95,108]
["Suburban",227,240]
["Rural",157,192]
[]
["Small Cell Sites"]
["Urban",360,426]
["Suburban",10,80]
["Rural",7,27]

{"sheet":"Projections","index":6,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Projections",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Unit",2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,null,"Modelling year"]
[]
["Spectral Efficiency"]
["Macro cells","bps/Hz",{"$f":"Assumptions!C21","v":1.64},{"$f":"C6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":1.8152707993036896},{"$f":"D6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":2.0092732163443028},{"$f":"E6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":2.2240091447883037},{"$f":"F6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":2.4616944255601094},{"$f":"G6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":2.7247817119072786},{"$f":"H6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":3.0159857781109767},{"$f":"I6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":3.3383115330000446},{"$f":"J6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":3.6950850273376319},{"$f":"K6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":4.0899877750428528},{"$f":"L6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":4.5270947424050965},{"$f":"M6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":5.0109163972983115},{"$f":"N6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":5.5464452522973602},{"$f":"O6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":6.1392073819707216},{"$f":"P6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":6.7953194459518924},{"$f":"Q6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":7.521551806205486},{"$f":"R6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":8.325398389789477},{"$f":"S6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":9.2151540180212166},{"$f":"T6*((Assumptions!$D$21/Assumptions!$C$21)^(1/18))","v":10.199999999999989},null,{"$f":"INDEX(C6:U6,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":10.199999999999989}]
["Small cells","bps/Hz",{"$f":"C6/Assumptions!$C$50","v":0.54666666666666663},{"$f":"D6/Assumptions!$C$50","v":0.60509026643456321},{"$f":"E6/Assumptions!$C$50","v":0.6697577387814343},{"$f":"F6/Assumptions!$C$50","v":0.74133638159610127},{"$f":"G6/Assumptions!$C$50","v":0.82056480852003644},{"$f":"H6/Assumptions!$C$50","v":0.90826057063575949},{"$f":"I6/Assumptions!$C$50","v":1.0053285927036588},{"$f":"J6/Assumptions!$C$50","v":1.1127705110000148},{"$f":"K6/Assumptions!$C$50","v":1.231695009112544},{"$f":"L6/Assumptions!$C$50","v":1.3633292583476175},{"$f":"M6/Assumptions!$C$50","v":1.5090315808016987},{"$f":"N6/Assumptions!$C$50","v":1.6703054657661038},{"$f":"O6/Assumptions!$C$50","v":1.84881508409912},{"$f":"P6/Assumptions!$C$50","v":2.0464024606569073},{"$f":"Q6/Assumptions!$C$50","v":2.2651064819839641},{"$f":"R6/Assumptions!$C$50","v":2.5071839354018288},{"$f":"S6/Assumptions!$C$50","v":2.7751327965964925},{"$f":"T6/Assumptions!$C$50","v":3.0717180060070723},{"$f":"U6/Assumptions!$C$50","v":3.3999999999999964},null,{"$f":"INDEX(C7:U7,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":3.3999999999999964}]
[]
["Number of Macro Sites"]
["0 - 50%","#",{"$f":"Assumptions!C24","v":7181},{"$f":"C10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7252.81},{"$f":"D10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7325.3381000000008},{"$f":"E10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7398.5914810000013},{"$f":"F10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7472.5773958100017},{"$f":"G10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7547.3031697681017},{"$f":"H10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7622.7762014657828},{"$f":"I10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7699.0039634804407},{"$f":"J10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7775.9940031152455},{"$f":"K10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7853.7539431463983},{"$f":"L10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":7932.2914825778626},{"$f":"M10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":8011.6143974036413},{"$f":"N10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":8091.7305413776776},{"$f":"O10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":8172.6478467914549},{"$f":"P10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":8254.3743252593704},{"$f":"Q10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":8336.9180685119645},{"$f":"R10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":8420.2872491970847},{"$f":"S10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":8504.4901216890557},{"$f":"T10*((Assumptions!$D24/Assumptions!$C24)^(1/8))","v":8589.5350229059459},null,{"$f":"INDEX(C10:U10,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":8589.5350229059459}]
["50 - 80%","#",{"$f":"Assumptions!C25","v":5473},{"$f":"C11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5527.7300000000005},{"$f":"D11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5583.0073000000002},{"$f":"E11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5638.8373730000003},{"$f":"F11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5695.2257467300005},{"$f":"G11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5752.1780041973007},{"$f":"H11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5809.6997842392739},{"$f":"I11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5867.7967820816666},{"$f":"J11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5926.4747499024834},{"$f":"K11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":5985.7394974015078},{"$f":"L11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6045.5968923755227},{"$f":"M11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6106.0528612992775},{"$f":"N11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6167.1133899122706},{"$f":"O11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6228.7845238113932},{"$f":"P11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6291.072369049507},{"$f":"Q11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6353.9830927400017},{"$f":"R11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6417.5229236674013},{"$f":"S11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6481.698152904075},{"$f":"T11*((Assumptions!$D25/Assumptions!$C25)^(1/8))","v":6546.5151344331161},null,{"$f":"INDEX(C11:U11,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":6546.5151344331161}]
["80 - 90%","#",{"$f":"Assumptions!C26","v":2094},{"$f":"C12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2114.94},{"$f":"D12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2136.0894000000003},{"$f":"E12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2157.4502940000002},{"$f":"F12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2179.0247969400002},{"$f":"G12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2200.8150449094001},{"$f":"H12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2222.8231953584941},{"$f":"I12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2245.0514273120789},{"$f":"J12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2267.5019415851998},{"$f":"K12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2290.176961001052},{"$f":"L12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2313.0787306110624},{"$f":"M12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2336.2095179171729},{"$f":"N12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2359.5716130963447},{"$f":"O12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2383.1673292273081},{"$f":"P12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2406.9990025195812},{"$f":"Q12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2431.0689925447768},{"$f":"R12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2455.3796824702245},{"$f":"S12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2479.9334792949267},{"$f":"T12*((Assumptions!$D26/Assumptions!$C26)^(1/8))","v":2504.7328140878758},null,{"$f":"INDEX(C12:U12,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":2504.7328140878758}]
["90 - 100%","#",{"$f":"Assumptions!C27","v":3252},{"$f":"C13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3284.52},{"$f":"D13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3317.3652000000002},{"$f":"E13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3350.5388520000001},{"$f":"F13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3384.0442405200001},{"$f":"G13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3417.8846829252002},{"$f":"H13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3452.0635297544522},{"$f":"I13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3486.5841650519969},{"$f":"J13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3521.4500067025169},{"$f":"K13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3556.6645067695422},{"$f":"L13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3592.2311518372376},{"$f":"M13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3628.1534633556098},{"$f":"N13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3664.4349979891658},{"$f":"O13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3701.0793479690574},{"$f":"P13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3738.090141448748},{"$f":"Q13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3775.4710428632357},{"$f":"R13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3813.2257532918679},{"$f":"S13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3851.3580108247866},{"$f":"T13*((Assumptions!$D27/Assumptions!$C27)^(1/8))","v":3889.8715909330344},null,{"$f":"INDEX(C13:U13,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":3889.8715909330344}]
[]
["Number of Small Cells"]
["0 - 50%","#",{"$f":"Assumptions!C29","v":5695.5169951309999},{"$f":"C16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":6265.0686946441001},{"$f":"D16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":6891.5755641085107},{"$f":"E16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":7580.7331205193623},{"$f":"F16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":8338.8064325712985},{"$f":"G16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":9172.6870758284294},{"$f":"H16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":10089.955783411273},{"$f":"I16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":11098.951361752401},{"$f":"J16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":12208.846497927641},{"$f":"K16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":13429.731147720406},{"$f":"L16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":14772.704262492447},{"$f":"M16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":16249.974688741693},{"$f":"N16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":17874.972157615863},{"$f":"O16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":19662.469373377451},{"$f":"P16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":21628.716310715197},{"$f":"Q16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":23791.587941786718},{"$f":"R16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":26170.746735965393},{"$f":"S16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":28787.821409561933},{"$f":"T16*((Assumptions!$D29/Assumptions!$C29)^(1/8))","v":31666.603550518128},null,{"$f":"INDEX(C16:U16,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":31666.603550518128}]
["50 - 80%","#",{"$f":"Assumptions!C30","v":241.10132158590309},{"$f":"C17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":265.21145374449344},{"$f":"D17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":291.7325991189428},{"$f":"E17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":320.90585903083712},{"$f":"F17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":352.99644493392088},{"$f":"G17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":388.29608942731301},{"$f":"H17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":427.12569837004435},{"$f":"I17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":469.83826820704883},{"$f":"J17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":516.82209502775379},{"$f":"K17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":568.50430453052923},{"$f":"L17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":625.35473498358215},{"$f":"M17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":687.89020848194036},{"$f":"N17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":756.67922933013449},{"$f":"O17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":832.34715226314802},{"$f":"P17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":915.58186748946287},{"$f":"Q17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":1007.1400542384092},{"$f":"R17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":1107.8540596622502},{"$f":"S17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":1218.6394656284754},{"$f":"T17*((Assumptions!$D30/Assumptions!$C30)^(1/8))","v":1340.5034121913229},null,{"$f":"INDEX(C17:U17,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":1340.5034121913229}]
["80 - 90%","#",{"$f":"Assumptions!C31","v":92.246696035242294},{"$f":"C18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":101.47136563876653},{"$f":"D18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":111.61850220264319},{"$f":"E18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":122.78035242290751},{"$f":"F18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":135.05838766519827},{"$f":"G18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":148.56422643171811},{"$f":"H18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":163.42064907488992},{"$f":"I18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":179.76271398237893},{"$f":"J18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":197.73898538061684},{"$f":"K18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":217.51288391867854},{"$f":"L18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":239.2641723105464},{"$f":"M18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":263.19058954160107},{"$f":"N18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":289.50964849576121},{"$f":"O18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":318.46061334533738},{"$f":"P18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":350.30667467987115},{"$f":"Q18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":385.33734214785829},{"$f":"R18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":423.87107636264415},{"$f":"S18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":466.25818399890858},{"$f":"T18*((Assumptions!$D31/Assumptions!$C31)^(1/8))","v":512.88400239879945},null,{"$f":"INDEX(C18:U18,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":512.88400239879945}]
["90 - 100%","#",{"$f":"Assumptions!C32","v":92.246696035242294},{"$f":"C19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":101.47136563876653},{"$f":"D19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":111.61850220264319},{"$f":"E19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":122.78035242290751},{"$f":"F19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":135.05838766519827},{"$f":"G19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":148.56422643171811},{"$f":"H19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":163.42064907488992},{"$f":"I19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":179.76271398237893},{"$f":"J19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":197.73898538061684},{"$f":"K19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":217.51288391867854},{"$f":"L19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":239.2641723105464},{"$f":"M19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":263.19058954160107},{"$f":"N19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":289.50964849576121},{"$f":"O19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":318.46061334533738},{"$f":"P19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":350.30667467987115},{"$f":"Q19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":385.33734214785829},{"$f":"R19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":423.87107636264415},{"$f":"S19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":466.25818399890858},{"$f":"T19*((Assumptions!$D32/Assumptions!$C32)^(1/8))","v":512.88400239879945},null,{"$f":"INDEX(C19:U19,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":512.88400239879945}]
[]
["Proportion of Indoor users who offload "]
["0 - 50%","%",{"$f":"Assumptions!C37","v":0.5},{"$f":"C22+(Assumptions!$D37-Assumptions!$C37)/8","v":0.53749999999999998},{"$f":"D22+(Assumptions!$D37-Assumptions!$C37)/8","v":0.57499999999999996},{"$f":"E22+(Assumptions!$D37-Assumptions!$C37)/8","v":0.61249999999999993},{"$f":"F22+(Assumptions!$D37-Assumptions!$C37)/8","v":0.64999999999999991},{"$f":"G22+(Assumptions!$D37-Assumptions!$C37)/8","v":0.68749999999999989},{"$f":"H22+(Assumptions!$D37-Assumptions!$C37)/8","v":0.72499999999999987},{"$f":"I22+(Assumptions!$D37-Assumptions!$C37)/8","v":0.76249999999999984},{"$f":"J22+(Assumptions!$D37-Assumptions!$C37)/8","v":0.79999999999999982},{"$f":"K22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.80999999999999983},{"$f":"L22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.81999999999999984},{"$f":"M22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.82999999999999985},{"$f":"N22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.83999999999999986},{"$f":"O22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.84999999999999987},{"$f":"P22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.85999999999999988},{"$f":"Q22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.86999999999999988},{"$f":"R22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.87999999999999989},{"$f":"S22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.8899999999999999},{"$f":"T22+(Assumptions!$E37-Assumptions!$D37)/10","v":0.89999999999999991},null,{"$f":"INDEX(C22:U22,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0.89999999999999991}]
["50 - 80%","%",{"$f":"Assumptions!C38","v":0.5},{"$f":"C23+(Assumptions!$D38-Assumptions!$C38)/8","v":0.52500000000000002},{"$f":"D23+(Assumptions!$D38-Assumptions!$C38)/8","v":0.55000000000000004},{"$f":"E23+(Assumptions!$D38-Assumptions!$C38)/8","v":0.57500000000000007},{"$f":"F23+(Assumptions!$D38-Assumptions!$C38)/8","v":0.60000000000000009},{"$f":"G23+(Assumptions!$D38-Assumptions!$C38)/8","v":0.62500000000000011},{"$f":"H23+(Assumptions!$D38-Assumptions!$C38)/8","v":0.65000000000000013},{"$f":"I23+(Assumptions!$D38-Assumptions!$C38)/8","v":0.67500000000000016},{"$f":"J23+(Assumptions!$D38-Assumptions!$C38)/8","v":0.70000000000000018},{"$f":"K23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.71000000000000019},{"$f":"L23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.7200000000000002},{"$f":"M23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.7300000000000002},{"$f":"N23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.74000000000000021},{"$f":"O23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.75000000000000022},{"$f":"P23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.76000000000000023},{"$f":"Q23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.77000000000000024},{"$f":"R23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.78000000000000025},{"$f":"S23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.79000000000000026},{"$f":"T23+(Assumptions!$E38-Assumptions!$D38)/10","v":0.80000000000000027},null,{"$f":"INDEX(C23:U23,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0.80000000000000027}]
["80 - 90%","%",{"$f":"Assumptions!C39","v":0.5},{"$f":"C24+(Assumptions!$D39-Assumptions!$C39)/8","v":0.51249999999999996},{"$f":"D24+(Assumptions!$D39-Assumptions!$C39)/8","v":0.52499999999999991},{"$f":"E24+(Assumptions!$D39-Assumptions!$C39)/8","v":0.53749999999999987},{"$f":"F24+(Assumptions!$D39-Assumptions!$C39)/8","v":0.54999999999999982},{"$f":"G24+(Assumptions!$D39-Assumptions!$C39)/8","v":0.56249999999999978},{"$f":"H24+(Assumptions!$D39-Assumptions!$C39)/8","v":0.57499999999999973},{"$f":"I24+(Assumptions!$D39-Assumptions!$C39)/8","v":0.58749999999999969},{"$f":"J24+(Assumptions!$D39-Assumptions!$C39)/8","v":0.59999999999999964},{"$f":"K24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.60999999999999965},{"$f":"L24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.61999999999999966},{"$f":"M24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.62999999999999967},{"$f":"N24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.63999999999999968},{"$f":"O24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.64999999999999969},{"$f":"P24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.6599999999999997},{"$f":"Q24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.66999999999999971},{"$f":"R24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.67999999999999972},{"$f":"S24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.68999999999999972},{"$f":"T24+(Assumptions!$E39-Assumptions!$D39)/10","v":0.69999999999999973},null,{"$f":"INDEX(C24:U24,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0.69999999999999973}]
["90 - 100%","%",{"$f":"Assumptions!C40","v":0.5},{"$f":"C25+(Assumptions!$D40-Assumptions!$C40)/8","v":0.51249999999999996},{"$f":"D25+(Assumptions!$D40-Assumptions!$C40)/8","v":0.52499999999999991},{"$f":"E25+(Assumptions!$D40-Assumptions!$C40)/8","v":0.53749999999999987},{"$f":"F25+(Assumptions!$D40-Assumptions!$C40)/8","v":0.54999999999999982},{"$f":"G25+(Assumptions!$D40-Assumptions!$C40)/8","v":0.56249999999999978},{"$f":"H25+(Assumptions!$D40-Assumptions!$C40)/8","v":0.57499999999999973},{"$f":"I25+(Assumptions!$D40-Assumptions!$C40)/8","v":0.58749999999999969},{"$f":"J25+(Assumptions!$D40-Assumptions!$C40)/8","v":0.59999999999999964},{"$f":"K25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.60999999999999965},{"$f":"L25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.61999999999999966},{"$f":"M25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.62999999999999967},{"$f":"N25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.63999999999999968},{"$f":"O25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.64999999999999969},{"$f":"P25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.6599999999999997},{"$f":"Q25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.66999999999999971},{"$f":"R25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.67999999999999972},{"$f":"S25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.68999999999999972},{"$f":"T25+(Assumptions!$E40-Assumptions!$D40)/10","v":0.69999999999999973},null,{"$f":"INDEX(C25:U25,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0.69999999999999973}]
[]
["Population of Indoor users served by mobile"]
["0 - 50%","#",{"$f":"(1-C22)*Assumptions!$C45*Assumptions!$C$42","v":10720580.625},{"$f":"(1-D22)*Assumptions!$C45*Assumptions!$C$42","v":9916537.078125},{"$f":"(1-E22)*Assumptions!$C45*Assumptions!$C$42","v":9112493.5312500019},{"$f":"(1-F22)*Assumptions!$C45*Assumptions!$C$42","v":8308449.9843750019},{"$f":"(1-G22)*Assumptions!$C45*Assumptions!$C$42","v":7504406.4375000019},{"$f":"(1-H22)*Assumptions!$C45*Assumptions!$C$42","v":6700362.8906250028},{"$f":"(1-I22)*Assumptions!$C45*Assumptions!$C$42","v":5896319.3437500028},{"$f":"(1-J22)*Assumptions!$C45*Assumptions!$C$42","v":5092275.7968750037},{"$f":"(1-K22)*Assumptions!$C45*Assumptions!$C$42","v":4288232.2500000037},{"$f":"(1-L22)*Assumptions!$C45*Assumptions!$C$42","v":4073820.6375000039},{"$f":"(1-M22)*Assumptions!$C45*Assumptions!$C$42","v":3859409.0250000036},{"$f":"(1-N22)*Assumptions!$C45*Assumptions!$C$42","v":3644997.4125000034},{"$f":"(1-O22)*Assumptions!$C45*Assumptions!$C$42","v":3430585.8000000031},{"$f":"(1-P22)*Assumptions!$C45*Assumptions!$C$42","v":3216174.1875000028},{"$f":"(1-Q22)*Assumptions!$C45*Assumptions!$C$42","v":3001762.5750000025},{"$f":"(1-R22)*Assumptions!$C45*Assumptions!$C$42","v":2787350.9625000027},{"$f":"(1-S22)*Assumptions!$C45*Assumptions!$C$42","v":2572939.3500000024},{"$f":"(1-T22)*Assumptions!$C45*Assumptions!$C$42","v":2358527.7375000021},{"$f":"(1-U22)*Assumptions!$C45*Assumptions!$C$42","v":2144116.1250000019},null,{"$f":"INDEX(C28:U28,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":2144116.1250000019}]
["50 - 80%","#",{"$f":"(1-C23)*Assumptions!$C46*Assumptions!$C$42","v":6436064.25},{"$f":"(1-D23)*Assumptions!$C46*Assumptions!$C$42","v":6114261.0374999996},{"$f":"(1-E23)*Assumptions!$C46*Assumptions!$C$42","v":5792457.8249999993},{"$f":"(1-F23)*Assumptions!$C46*Assumptions!$C$42","v":5470654.6124999989},{"$f":"(1-G23)*Assumptions!$C46*Assumptions!$C$42","v":5148851.3999999985},{"$f":"(1-H23)*Assumptions!$C46*Assumptions!$C$42","v":4827048.1874999981},{"$f":"(1-I23)*Assumptions!$C46*Assumptions!$C$42","v":4505244.9749999987},{"$f":"(1-J23)*Assumptions!$C46*Assumptions!$C$42","v":4183441.7624999983},{"$f":"(1-K23)*Assumptions!$C46*Assumptions!$C$42","v":3861638.5499999975},{"$f":"(1-L23)*Assumptions!$C46*Assumptions!$C$42","v":3732917.2649999978},{"$f":"(1-M23)*Assumptions!$C46*Assumptions!$C$42","v":3604195.9799999977},{"$f":"(1-N23)*Assumptions!$C46*Assumptions!$C$42","v":3475474.694999997},{"$f":"(1-O23)*Assumptions!$C46*Assumptions!$C$42","v":3346753.4099999974},{"$f":"(1-P23)*Assumptions!$C46*Assumptions!$C$42","v":3218032.1249999972},{"$f":"(1-Q23)*Assumptions!$C46*Assumptions!$C$42","v":3089310.8399999971},{"$f":"(1-R23)*Assumptions!$C46*Assumptions!$C$42","v":2960589.5549999969},{"$f":"(1-S23)*Assumptions!$C46*Assumptions!$C$42","v":2831868.2699999968},{"$f":"(1-T23)*Assumptions!$C46*Assumptions!$C$42","v":2703146.9849999966},{"$f":"(1-U23)*Assumptions!$C46*Assumptions!$C$42","v":2574425.6999999965},null,{"$f":"INDEX(C29:U29,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":2574425.6999999965}]
["80 - 90%","#",{"$f":"(1-C24)*Assumptions!$C47*Assumptions!$C$42","v":2118207.375},{"$f":"(1-D24)*Assumptions!$C47*Assumptions!$C$42","v":2065252.1906250003},{"$f":"(1-E24)*Assumptions!$C47*Assumptions!$C$42","v":2012297.0062500001},{"$f":"(1-F24)*Assumptions!$C47*Assumptions!$C$42","v":1959341.8218750004},{"$f":"(1-G24)*Assumptions!$C47*Assumptions!$C$42","v":1906386.6375000007},{"$f":"(1-H24)*Assumptions!$C47*Assumptions!$C$42","v":1853431.4531250009},{"$f":"(1-I24)*Assumptions!$C47*Assumptions!$C$42","v":1800476.268750001},{"$f":"(1-J24)*Assumptions!$C47*Assumptions!$C$42","v":1747521.0843750013},{"$f":"(1-K24)*Assumptions!$C47*Assumptions!$C$42","v":1694565.9000000015},{"$f":"(1-L24)*Assumptions!$C47*Assumptions!$C$42","v":1652201.7525000013},{"$f":"(1-M24)*Assumptions!$C47*Assumptions!$C$42","v":1609837.6050000014},{"$f":"(1-N24)*Assumptions!$C47*Assumptions!$C$42","v":1567473.4575000014},{"$f":"(1-O24)*Assumptions!$C47*Assumptions!$C$42","v":1525109.3100000012},{"$f":"(1-P24)*Assumptions!$C47*Assumptions!$C$42","v":1482745.1625000013},{"$f":"(1-Q24)*Assumptions!$C47*Assumptions!$C$42","v":1440381.0150000013},{"$f":"(1-R24)*Assumptions!$C47*Assumptions!$C$42","v":1398016.8675000011},{"$f":"(1-S24)*Assumptions!$C47*Assumptions!$C$42","v":1355652.7200000011},{"$f":"(1-T24)*Assumptions!$C47*Assumptions!$C$42","v":1313288.5725000012},{"$f":"(1-U24)*Assumptions!$C47*Assumptions!$C$42","v":1270924.4250000012},null,{"$f":"INDEX(C30:U30,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":1270924.4250000012}]
["90 - 100%","#",{"$f":"(1-C25)*Assumptions!$C48*Assumptions!$C$42","v":2772097.875},{"$f":"(1-D25)*Assumptions!$C48*Assumptions!$C$42","v":2702795.4281250001},{"$f":"(1-E25)*Assumptions!$C48*Assumptions!$C$42","v":2633492.9812500002},{"$f":"(1-F25)*Assumptions!$C48*Assumptions!$C$42","v":2564190.5343750007},{"$f":"(1-G25)*Assumptions!$C48*Assumptions!$C$42","v":2494888.0875000008},{"$f":"(1-H25)*Assumptions!$C48*Assumptions!$C$42","v":2425585.6406250014},{"$f":"(1-I25)*Assumptions!$C48*Assumptions!$C$42","v":2356283.1937500015},{"$f":"(1-J25)*Assumptions!$C48*Assumptions!$C$42","v":2286980.746875002},{"$f":"(1-K25)*Assumptions!$C48*Assumptions!$C$42","v":2217678.3000000021},{"$f":"(1-L25)*Assumptions!$C48*Assumptions!$C$42","v":2162236.3425000017},{"$f":"(1-M25)*Assumptions!$C48*Assumptions!$C$42","v":2106794.3850000016},{"$f":"(1-N25)*Assumptions!$C48*Assumptions!$C$42","v":2051352.4275000021},{"$f":"(1-O25)*Assumptions!$C48*Assumptions!$C$42","v":1995910.4700000016},{"$f":"(1-P25)*Assumptions!$C48*Assumptions!$C$42","v":1940468.5125000018},{"$f":"(1-Q25)*Assumptions!$C48*Assumptions!$C$42","v":1885026.5550000016},{"$f":"(1-R25)*Assumptions!$C48*Assumptions!$C$42","v":1829584.5975000015},{"$f":"(1-S25)*Assumptions!$C48*Assumptions!$C$42","v":1774142.6400000015},{"$f":"(1-T25)*Assumptions!$C48*Assumptions!$C$42","v":1718700.6825000015},{"$f":"(1-U25)*Assumptions!$C48*Assumptions!$C$42","v":1663258.7250000015},null,{"$f":"INDEX(C31:U31,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":1663258.7250000015}]
[]
["Population of Outdoor users"]
["0 - 50%","#",{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},{"$f":"Assumptions!$C45*(1-Assumptions!$C$42)","v":7147053.75},null,{"$f":"INDEX(C34:U34,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":7147053.75}]
["50 - 80%","#",{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},{"$f":"Assumptions!$C46*(1-Assumptions!$C$42)","v":4290709.5},null,{"$f":"INDEX(C35:U35,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":4290709.5}]
["80 - 90%","#",{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},{"$f":"Assumptions!$C47*(1-Assumptions!$C$42)","v":1412138.25},null,{"$f":"INDEX(C36:U36,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":1412138.25}]
["90 - 100%","#",{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},{"$f":"Assumptions!$C48*(1-Assumptions!$C$42)","v":1848065.25},null,{"$f":"INDEX(C37:U37,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":1848065.25}]
[]
["Spectrum for macro cells"]
["Sub 1 GHz","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":10},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":40},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":40},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":40},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":45},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":50},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":55},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":60},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":90},{"$f":"K40","v":90},{"$f":"L40","v":90},{"$f":"M40","v":90},90,90,90,90,90,90,90,null,{"$f":"INDEX(C40:U40,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":90}]
["1 - 2 GHz ","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":22},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":22},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":22},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":22},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":36},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":46},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":56},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":66},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":72},{"$f":"K41","v":72},{"$f":"L41","v":72},{"$f":"M41","v":72},72,72,72,72,72,72,72,null,{"$f":"INDEX(C41:U41,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":72}]
["2 - 3 GHz","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":60},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":158},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":158},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":158},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":158},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":158},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":158},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":158},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":158},158,158,{"$f":"M42","v":158},158,158,158,158,158,158,158,null,{"$f":"INDEX(C42:U42,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":158}]
["3 - 4 GHz","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},0,0,{"$f":"M43","v":0},0,0,0,0,0,0,0,null,{"$f":"INDEX(C43:U43,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0}]
["4 - 6 GHz","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Small Cell\")","v":0},0,0,{"$f":"M44","v":0},0,0,0,0,0,0,0,null,{"$f":"INDEX(C44:U44,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0}]
[]
["Spectrum for small cells"]
["Sub 1 GHz","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=Sub 1 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"K47","v":0},{"$f":"L47","v":0},0,0,0,0,0,0,0,0,null,{"$f":"INDEX(C47:U47,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0}]
["1 - 2 GHz ","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=1 - 2 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"K48","v":0},{"$f":"L48","v":0},0,0,0,0,0,0,0,0,null,{"$f":"INDEX(C48:U48,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0}]
["2 - 3 GHz","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":60},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":158},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":158},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":186},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":186},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":186},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":186},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":186},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=2 - 3 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":186},186,186,186,186,186,186,186,186,186,186,null,{"$f":"INDEX(C49:U49,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":186}]
["3 - 4 GHz","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":133},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":133},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":133},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":133},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":133},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=3 - 4 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":133},133,133,133,133,133,133,133,133,133,133,null,{"$f":"INDEX(C50:U50,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":133}]
["4 - 6 GHz","MHz",{"$f":"SUMIFS(Assumptions!D$54:D$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!E$54:E$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!F$54:F$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!G$54:G$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!H$54:H$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!I$54:I$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!J$54:J$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!K$54:K$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},{"$f":"SUMIFS(Assumptions!L$54:L$62,Assumptions!$B$54:$B$62,\"=4 - 6 GHz\",Assumptions!$C$54:$C$62,\"<>Macro\")","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"INDEX(C51:U51,MATCH(Assumptions!$B$4,Projections!$C$3:$U$3,0))","v":0}]

{"sheet":"Spectrum Opt","index":7,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,16,16,17],[29,16,29,17],[38,7,38,8],[25,7,25,8],[12,7,12,8],[15,10,15,17],[28,10,28,17],[12,1,12,2],[12,3,12,4],[12,5,12,6],[38,1,38,2],[38,3,38,4],[38,5,38,6],[25,1,25,2],[25,3,25,4],[25,5,25,6],[29,1,29,2],[29,3,29,4],[29,5,29,6],[16,1,16,2],[16,3,16,4],[15,1,15,8],[28,1,28,8],[3,12,3,13],[3,14,3,15],[3,5,3,6],[3,1,3,2],[3,3,3,4],[3,7,3,8],[2,1,2,8],[2,10,2,17],[3,16,3,17],[16,5,16,6],[29,10,29,11],[29,12,29,13],[29,14,29,15],[12,10,12,11],[12,12,12,13],[12,14,12,15],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,7,16,8],[29,7,29,8],[3,10,3,11]]}
["Spectrum Optimisation",null,null,null," Use Spectrum optimisation button to run model"]
[2012]
[null,"Macro Cells",null,null,null,null,null,null,null,null,"Small Cells"]
[null,"0-50%",null,"50-80%",null,"80-90%",null,"90-100%",null,null,"0-50%",null,"50-80%",null,"80-90%",null,"90-100%"]
[null,"Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In",null,"Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In"]
["Sub 1 GHz",0.38203085554763039,{"$f":"1-B6","v":0.61796914445236961},0.36973656007800554,{"$f":"1-D6","v":0.63026343992199441},0,{"$f":"1-F6","v":1},0,{"$f":"1-H6","v":1},null,1,{"$f":"1-K6","v":0},1,{"$f":"1-M6","v":0},1,{"$f":"1-O6","v":0},1,{"$f":"1-Q6","v":0}]
["1 - 2 GHz ",0,{"$f":"1-B7","v":1},0,{"$f":"1-D7","v":1},0,{"$f":"1-F7","v":1},0,{"$f":"1-H7","v":1},null,1,{"$f":"1-K7","v":0},1,{"$f":"1-M7","v":0},1,{"$f":"1-O7","v":0},1,{"$f":"1-Q7","v":0}]
["2 - 3 GHz",0.37466975948104414,{"$f":"1-B8","v":0.6253302405189558},0.44396337293744764,{"$f":"1-D8","v":0.5560366270625523},0.48938818025073788,{"$f":"1-F8","v":0.51061181974926217},0.46028392582372063,{"$f":"1-H8","v":0.53971607417627943},null,1,{"$f":"1-K8","v":0},1,{"$f":"1-M8","v":0},1,{"$f":"1-O8","v":0},1,{"$f":"1-Q8","v":0}]
["3 - 4 GHz",0.5,{"$f":"1-B9","v":0.5},0.5,{"$f":"1-D9","v":0.5},0.5,{"$f":"1-F9","v":0.5},0.5,{"$f":"1-H9","v":0.5},null,1,{"$f":"1-K9","v":0},1,{"$f":"1-M9","v":0},1,{"$f":"1-O9","v":0},1,{"$f":"1-Q9","v":0}]
["4 - 6 GHz",0.5,{"$f":"1-B10","v":0.5},0.5,{"$f":"1-D10","v":0.5},0.5,{"$f":"1-F10","v":0.5},0.5,{"$f":"1-H10","v":0.5},null,1,{"$f":"1-K10","v":0},1,{"$f":"1-M10","v":0},1,{"$f":"1-O10","v":0},1,{"$f":"1-Q10","v":0}]
[]
["2012 Capacity per person",{"$f":"'Capacity Model'!F13","v":0.4990839010148263},{"$f":"'Capacity Model'!G13","v":0.49908390637542521},{"$f":"'Capacity Model'!F14","v":0.50904805358993077},{"$f":"'Capacity Model'!G14","v":0.50904805732697977},{"$f":"'Capacity Model'!F15","v":0.58269417798159218},{"$f":"'Capacity Model'!G15","v":0.58269418497330028},{"$f":"'Capacity Model'!F16","v":0.67394137450105873},{"$f":"'Capacity Model'!G16","v":0.67394137345062866}]
["2012 Capacity per person",{"$f":"MIN(B12:C12)","v":0.4990839010148263},null,{"$f":"MIN(D12:E12)","v":0.50904805358993077},null,{"$f":"MIN(F12:G12)","v":0.58269417798159218},null,0.67394137345062866]
[]
[{"$f":"Assumptions!B4","v":2030}]
[null,"Macro Cells",null,null,null,null,null,null,null,null,"Small Cells"]
[null,"0-50%",null,"50-80%",null,"80-90%",null,"90-100%",null,null,"0-50%",null,"50-80%",null,"80-90%",null,"90-100%"]
[null,"Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In",null,"Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In"]
["Sub 1 GHz",0,{"$f":"1-B19","v":1},0,{"$f":"1-D19","v":1},8.2647673885923059E-7,{"$f":"1-F19","v":0.99999917352326118},9.7257180633568955E-7,{"$f":"1-H19","v":0.99999902742819369},null,1,{"$f":"1-K19","v":0},1,{"$f":"1-M19","v":0},1,{"$f":"1-O19","v":0},1,{"$f":"1-Q19","v":0}]
["1 - 2 GHz ",1,{"$f":"1-B20","v":0},0.43287015559549019,{"$f":"1-D20","v":0.56712984440450986},8.1687292263001749E-7,{"$f":"1-F20","v":0.99999918312707736},9.0604577931537729E-7,{"$f":"1-H20","v":0.99999909395422071},null,1,{"$f":"1-K20","v":0},1,{"$f":"1-M20","v":0},1,{"$f":"1-O20","v":0},1,{"$f":"1-Q20","v":0}]
["2 - 3 GHz",0.67871620560443302,{"$f":"1-B21","v":0.32128379439556698},0.99998152737103929,{"$f":"1-D21","v":1.8472628960708448E-5},0.95122757417529458,{"$f":"1-F21","v":4.8772425824705423E-2},0.92224322845543749,{"$f":"1-H21","v":7.7756771544562509E-2},null,1,{"$f":"1-K21","v":0},1,{"$f":"1-M21","v":0},1,{"$f":"1-O21","v":0},1,{"$f":"1-Q21","v":0}]
["3 - 4 GHz",1,{"$f":"1-B22","v":0},1,{"$f":"1-D22","v":0},1,{"$f":"1-F22","v":0},1,{"$f":"1-H22","v":0},null,1,{"$f":"1-K22","v":0},1,{"$f":"1-M22","v":0},1,{"$f":"1-O22","v":0},1,{"$f":"1-Q22","v":0}]
["4 - 6 GHz",1,{"$f":"1-B23","v":0},1,{"$f":"1-D23","v":0},1,{"$f":"1-F23","v":0},1,{"$f":"1-H23","v":0},null,1,{"$f":"1-K23","v":0},1,{"$f":"1-M23","v":0},1,{"$f":"1-O23","v":0},1,{"$f":"1-Q23","v":0}]
[]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" Capacity per person\")","v":"2030 Capacity per person"},{"$f":"'Capacity Model'!F20","v":43.135079962205161},{"$f":"'Capacity Model'!G20","v":43.135089451041097},{"$f":"'Capacity Model'!F21","v":24.514621186509526},{"$f":"'Capacity Model'!G21","v":24.514622417867745},{"$f":"'Capacity Model'!F22","v":23.19685383626776},{"$f":"'Capacity Model'!G22","v":23.196853836896988},{"$f":"'Capacity Model'!F23","v":27.638393125509598},{"$f":"'Capacity Model'!G23","v":27.638393766133998}]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" Capacity per person\")","v":"2030 Capacity per person"},{"$f":"MIN(B25:C25)","v":43.135079962205161},null,{"$f":"MIN(D25:E25)","v":24.514621186509526},null,{"$f":"MIN(F25:G25)","v":23.19685383626776},null,27.638393125509598]
[]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" with shock\")","v":"2030 with shock"}]
[null,"Macro Cells",null,null,null,null,null,null,null,null,"Small Cells"]
[null,"0-50%",null,"50-80%",null,"80-90%",null,"90-100%",null,null,"0-50%",null,"50-80%",null,"80-90%",null,"90-100%"]
[null,"Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In",null,"Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In","Out/Out","Out/In"]
["Sub 1 GHz",0,{"$f":"1-B32","v":1},5.0801186174398442E-13,{"$f":"1-D32","v":0.99999999999949196},2.609399335073789E-7,{"$f":"1-F32","v":0.99999973906006645},6.6870591305539152E-7,{"$f":"1-H32","v":0.99999933129408691},null,1,{"$f":"1-K32","v":0},1,{"$f":"1-M32","v":0},1,{"$f":"1-O32","v":0},1,{"$f":"1-Q32","v":0}]
["1 - 2 GHz ",1,{"$f":"1-B33","v":0},0.43287015247000332,{"$f":"1-D33","v":0.56712984752999662},0,{"$f":"1-F33","v":1},6.7503754350689196E-7,{"$f":"1-H33","v":0.99999932496245647},null,1,{"$f":"1-K33","v":0},1,{"$f":"1-M33","v":0},1,{"$f":"1-O33","v":0},1,{"$f":"1-Q33","v":0}]
["2 - 3 GHz",0.67871620550234824,{"$f":"1-B34","v":0.32128379449765176},0.99998152957399156,{"$f":"1-D34","v":1.8470426008443397E-5},0.95122837893121237,{"$f":"1-F34","v":4.8771621068787629E-2},0.92224357181207384,{"$f":"1-H34","v":7.7756428187926163E-2},null,1,{"$f":"1-K34","v":0},1,{"$f":"1-M34","v":0},1,{"$f":"1-O34","v":0},1,{"$f":"1-Q34","v":0}]
["3 - 4 GHz",1,{"$f":"1-B35","v":0},1,{"$f":"1-D35","v":0},1,{"$f":"1-F35","v":0},1,{"$f":"1-H35","v":0},null,1,{"$f":"1-K35","v":0},1,{"$f":"1-M35","v":0},1,{"$f":"1-O35","v":0},1,{"$f":"1-Q35","v":0}]
["4 - 6 GHz",1,{"$f":"1-B36","v":0},1,{"$f":"1-D36","v":0},1,{"$f":"1-F36","v":0},1,{"$f":"1-H36","v":0},null,1,{"$f":"1-K36","v":0},1,{"$f":"1-M36","v":0},1,{"$f":"1-O36","v":0},1,{"$f":"1-Q36","v":0}]
[]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" Capacity per person\")","v":"2030 Capacity per person"},{"$f":"'Capacity Model'!F34","v":43.135079960608969},{"$f":"'Capacity Model'!G34","v":43.13508945535979},{"$f":"'Capacity Model'!F35","v":24.514621201219651},{"$f":"'Capacity Model'!G35","v":24.514622405821029},{"$f":"'Capacity Model'!F36","v":23.196855759588498},{"$f":"'Capacity Model'!G36","v":23.196855899082454},{"$f":"'Capacity Model'!F37","v":27.638394441872542},{"$f":"'Capacity Model'!G37","v":27.638395085520788}]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" Capacity per person\")","v":"2030 Capacity per person"},{"$f":"MIN(B38:C38)","v":43.135079960608969},null,{"$f":"MIN(D38:E38)","v":24.514621201219651},null,{"$f":"MIN(F38:G38)","v":23.196855759588498},null,27.638394441872542]

{"sheet":"Capacity Model","index":8,"n_rows":148,"n_cols":13,"rows_kept":148,"cut":false,"hidden":false,"merged":[[53,1,53,5],[53,7,53,11],[2,2,2,5],[2,7,2,10],[10,9,10,11],[10,5,10,7],[10,1,10,3]]}
["Capacity model",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Macro Cell Spectrum Availability",null,null,null,null,"Small Cell Spectrum Availability"]
["Spectrum Availability","Unit","2012 Base Case",{"$f":"CONCATENATE(Assumptions!$B$4,\" Base Case\")","v":"2030 Base Case"},{"$f":"CONCATENATE(Assumptions!$B$4,\" Increase\")","v":"2030 Increase"},{"$f":"CONCATENATE(Assumptions!$B$4,\" Total\")","v":"2030 Total"},null,"2012 Base Case",{"$f":"CONCATENATE(Assumptions!$B$4,\" Base Case\")","v":"2030 Base Case"},{"$f":"CONCATENATE(Assumptions!$B$4,\" Shock\")","v":"2030 Shock"},{"$f":"CONCATENATE(Assumptions!$B$4,\" Total\")","v":"2030 Total"}]
["Sub 1 GHz","MHz",{"$f":"Projections!C40","v":10},{"$f":"Projections!W40","v":90},0,{"$f":"D5+E5","v":90},null,{"$f":"Projections!C47","v":0},{"$f":"Projections!W47","v":0},0,{"$f":"I5+J5","v":0}]
["1 - 2 GHz ","MHz",{"$f":"Projections!C41","v":22},{"$f":"Projections!W41","v":72},0,{"$f":"D6+E6","v":72},null,{"$f":"Projections!C48","v":0},{"$f":"Projections!W48","v":0},0,{"$f":"I6+J6","v":0}]
["2 - 3 GHz","MHz",{"$f":"Projections!C42","v":60},{"$f":"Projections!W42","v":158},0,158,null,{"$f":"Projections!C49","v":60},{"$f":"Projections!W49","v":186},0,186]
["3 - 4 GHz","MHz",{"$f":"Projections!C43","v":0},{"$f":"Projections!W43","v":0},0,0,null,{"$f":"Projections!C50","v":0},{"$f":"Projections!W50","v":133},0,133]
["4 - 6 GHz","MHz",{"$f":"Projections!C44","v":0},{"$f":"Projections!W44","v":0},0,0,null,{"$f":"Projections!C51","v":0},{"$f":"Projections!W51","v":0},0,0]
[null,null,null,null," Add additional downlink spectrum to test sensitivity",null,null,null,null," Add additional downlink spectrum to test sensitivity"]
[null,"Total",null,null,null,"Per Person"]
["2012 Base Capacity","Out/Out","Out/In","Total",null,"Out/Out","Out/In","Average"]
["0 - 50%",{"$f":"SUMPRODUCT($C$5:$C$9,Assumptions!B$8:B$12,'Spectrum Opt'!B$6:B$10)*Projections!$C$6*Projections!$C10+SUMPRODUCT($H$5:$H$9,Assumptions!B$14:B$18,'Spectrum Opt'!K$6:K$10)*Projections!$C$7*Projections!$C16","v":3566979.4663126431},{"$f":"SUMPRODUCT($C$5:$C$9,Assumptions!C$8:C$12,'Spectrum Opt'!C$6:C$10)*Projections!$C$6*Projections!$C10+SUMPRODUCT($H$5:$H$9,Assumptions!C$14:C$18,'Spectrum Opt'!L$6:L$10)*Projections!$C$7*Projections!$C16","v":5350469.2569376975},null,null,{"$f":"B13/Projections!C34","v":0.4990839010148263},{"$f":"C13/Projections!C28","v":0.49908390637542521}]
["50 - 80%",{"$f":"SUMPRODUCT($C$5:$C$9,Assumptions!E$8:E$12,'Spectrum Opt'!D$6:D$10)*Projections!$C$6*Projections!$C11+SUMPRODUCT($H$5:$H$9,Assumptions!E$14:E$18,'Spectrum Opt'!M$6:M$10)*Projections!$C$7*Projections!$C17","v":2184177.3194948249},{"$f":"SUMPRODUCT($C$5:$C$9,Assumptions!F$8:F$12,'Spectrum Opt'!E$6:E$10)*Projections!$C$6*Projections!$C11+SUMPRODUCT($H$5:$H$9,Assumptions!F$14:F$18,'Spectrum Opt'!N$6:N$10)*Projections!$C$7*Projections!$C17","v":3276266.0032941247},null,null,{"$f":"B14/Projections!C35","v":0.50904805358993077},{"$f":"C14/Projections!C29","v":0.50904805732697977}]
["80 - 90%",{"$f":"SUMPRODUCT($C$5:$C$9,Assumptions!H$8:H$12,'Spectrum Opt'!F$6:F$10)*Projections!$C$6*Projections!$C12+SUMPRODUCT($H$5:$H$9,Assumptions!H$14:H$18,'Spectrum Opt'!O$6:O$10)*Projections!$C$7*Projections!$C18","v":822844.73678011412},{"$f":"SUMPRODUCT($C$5:$C$9,Assumptions!I$8:I$12,'Spectrum Opt'!G$6:G$10)*Projections!$C$6*Projections!$C12+SUMPRODUCT($H$5:$H$9,Assumptions!I$14:I$18,'Spectrum Opt'!P$6:P$10)*Projections!$C$7*Projections!$C18","v":1234267.1199800589},null,null,{"$f":"B15/Projections!C36","v":0.58269417798159218},{"$f":"C15/Projections!C30","v":0.58269418497330028}]
["90 - 100%",{"$f":"SUMPRODUCT($C$5:$C$9,Assumptions!K$8:K$12,'Spectrum Opt'!H$6:H$10)*Projections!$C$6*Projections!$C13+SUMPRODUCT($H$5:$H$9,Assumptions!K$14:K$18,'Spectrum Opt'!Q$6:Q$10)*Projections!$C$7*Projections!$C19","v":1245487.6347526428},{"$f":"SUMPRODUCT($C$5:$C$9,Assumptions!L$8:L$12,'Spectrum Opt'!I$6:I$10)*Projections!$C$6*Projections!$C13+SUMPRODUCT($H$5:$H$9,Assumptions!L$14:L$18,'Spectrum Opt'!R$6:R$10)*Projections!$C$7*Projections!$C19","v":1868231.4492170692},null,null,{"$f":"B16/Projections!C37","v":0.67394137450105873},{"$f":"C16/Projections!C31","v":0.67394137345062866}]
["Total / Average",{"$f":"SUM(B13:B16)","v":7819489.1573402248},{"$f":"SUM(C13:C16)","v":11729233.829428952},{"$f":"SUM(B13:C16)","v":19548722.986769177},null,{"$f":"SUM(B13:B16)/SUM(Projections!$C$34:$C$37)","v":0.53201162380777767},{"$f":"SUM(C13:C16)/SUM(Projections!$C$28:$C$31)","v":0.53201162804503566},{"$f":"SUM(B13:C16)/(SUM(Projections!C28:C31)+SUM(Projections!C34:C37))","v":0.53201162635013244}]
[]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" Base Capacity\")","v":"2030 Base Capacity"},"Out/Out","Out/In","Total",null,"Out/Out","Out/In","Average"]
["0 - 50%",{"$f":"SUMPRODUCT($D$5:$D$9,Assumptions!B$8:B$12,'Spectrum Opt'!B$19:B$23)*Projections!$W$6*Projections!$W10+SUMPRODUCT($I$5:$I$9,Assumptions!B$14:B$18,'Spectrum Opt'!K$19:K$23)*Projections!$W$7*Projections!$W16","v":308288735.00042826},{"$f":"SUMPRODUCT($D$5:$D$9,Assumptions!C$8:C$12,'Spectrum Opt'!C$19:C$23)*Projections!$W$6*Projections!$W10+SUMPRODUCT($I$5:$I$9,Assumptions!C$14:C$18,'Spectrum Opt'!L$19:L$23)*Projections!$W$7*Projections!$W16","v":92486640.845294699},null,null,{"$f":"B20/Projections!W34","v":43.135079962205161},{"$f":"C20/Projections!W28","v":43.135089451041097}]
["50 - 80%",{"$f":"SUMPRODUCT($D$5:$D$9,Assumptions!E$8:E$12,'Spectrum Opt'!D$19:D$23)*Projections!$W$6*Projections!$W11+SUMPRODUCT($I$5:$I$9,Assumptions!E$14:E$18,'Spectrum Opt'!M$19:M$23)*Projections!$W$7*Projections!$W17","v":105185118.01385769},{"$f":"SUMPRODUCT($D$5:$D$9,Assumptions!F$8:F$12,'Spectrum Opt'!E$19:E$23)*Projections!$W$6*Projections!$W11+SUMPRODUCT($I$5:$I$9,Assumptions!F$14:F$18,'Spectrum Opt'!N$19:N$23)*Projections!$W$7*Projections!$W17","v":63111073.978354774},null,null,{"$f":"B21/Projections!W35","v":24.514621186509526},{"$f":"C21/Projections!W29","v":24.514622417867745}]
["80 - 90%",{"$f":"SUMPRODUCT($D$5:$D$9,Assumptions!H$8:H$12,'Spectrum Opt'!F$19:F$23)*Projections!$W$6*Projections!$W12+SUMPRODUCT($I$5:$I$9,Assumptions!H$14:H$18,'Spectrum Opt'!O$19:O$23)*Projections!$W$7*Projections!$W18","v":32757164.581852939},{"$f":"SUMPRODUCT($D$5:$D$9,Assumptions!I$8:I$12,'Spectrum Opt'!G$19:G$23)*Projections!$W$6*Projections!$W12+SUMPRODUCT($I$5:$I$9,Assumptions!I$14:I$18,'Spectrum Opt'!P$19:P$23)*Projections!$W$7*Projections!$W18","v":29481448.124467377},null,null,{"$f":"B22/Projections!W36","v":23.19685383626776},{"$f":"C22/Projections!W30","v":23.196853836896988}]
["90 - 100%",{"$f":"SUMPRODUCT($D$5:$D$9,Assumptions!K$8:K$12,'Spectrum Opt'!H$19:H$23)*Projections!$W$6*Projections!$W13+SUMPRODUCT($I$5:$I$9,Assumptions!K$14:K$18,'Spectrum Opt'!Q$19:Q$23)*Projections!$W$7*Projections!$W19","v":51077553.901093177},{"$f":"SUMPRODUCT($D$5:$D$9,Assumptions!L$8:L$12,'Spectrum Opt'!I$19:I$23)*Projections!$W$6*Projections!$W13+SUMPRODUCT($I$5:$I$9,Assumptions!L$14:L$18,'Spectrum Opt'!R$19:R$23)*Projections!$W$7*Projections!$W19","v":45969799.576508023},null,null,{"$f":"B23/Projections!W37","v":27.638393125509598},{"$f":"C23/Projections!W31","v":27.638393766133998}]
["Total / Average",{"$f":"SUM(B20:B23)","v":497308571.49723202},{"$f":"SUM(C20:C23)","v":231048962.52462485},{"$f":"SUM(B20:C23)","v":728357534.0218569},null,{"$f":"SUM(B20:B23)/SUM(Projections!W34:W37)","v":33.835195027722591},{"$f":"SUM(C20:C23)/SUM(Projections!W28:W31)","v":30.191724291597819},{"$f":"SUM(B20:C23)/(SUM(Projections!W28:W31)+SUM(Projections!W34:W37))","v":32.587695404843529}]
[]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" Relative Base Capacity\")","v":"2030 Relative Base Capacity"},"Out/Out","Out/In","Total",null,"Out/Out","Out/In","Average"]
["0 - 50%",{"$f":"B20/B13","v":86.428514072474044},{"$f":"C20/C13","v":17.285706431332486},null,null,{"$f":"F20/F13","v":86.428514072474044},86.428532156662342]
["50 - 80%",{"$f":"B21/B14","v":48.157774130804455},19.263110478483643,null,null,48.157774130804448,48.157776196209163]
["80 - 90%",{"$f":"B22/B15","v":39.809654382715607},23.885792343673295,null,null,39.809654382715607,39.809653906122122]
["90 - 100%",41.010085107137428,24.606051672972779,null,null,41.010085107137428,41.010086121621264]
["Total / Average",null,null,37.258573591472882,null,{"$f":"F24/F17","v":63.598601071069197},56.750121050064791,{"$f":"H24/H17","v":61.253727908939744}]
[]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" Capacity With Increase\")","v":"2030 Capacity With Increase"},"Out/Out","Out/In","Total",null,"Out/Out","Out/In","Average"]
["0 - 50%",{"$f":"SUMPRODUCT($F$5:$F$9,Assumptions!B$8:B$12,'Spectrum Opt'!B$32:B$36)*Projections!$W$6*Projections!$W10+SUMPRODUCT($K$5:$K$9,Assumptions!B$14:B$18,'Spectrum Opt'!K$32:K$36)*Projections!$W$7*Projections!$W16","v":308288734.98902017},{"$f":"SUMPRODUCT($F$5:$F$9,Assumptions!C$8:C$12,'Spectrum Opt'!C$32:C$36)*Projections!$W$6*Projections!$W10+SUMPRODUCT($K$5:$K$9,Assumptions!C$14:C$18,'Spectrum Opt'!L$32:L$36)*Projections!$W$7*Projections!$W16","v":92486640.854554474},null,null,{"$f":"B34/Projections!W34","v":43.135079960608969},{"$f":"C34/Projections!W28","v":43.13508945535979}]
["50 - 80%",{"$f":"SUMPRODUCT($F$5:$F$9,Assumptions!E$8:E$12,'Spectrum Opt'!D$32:D$36)*Projections!$W$6*Projections!$W11+SUMPRODUCT($K$5:$K$9,Assumptions!E$14:E$18,'Spectrum Opt'!M$32:M$36)*Projections!$W$7*Projections!$W17","v":105185118.07697457},{"$f":"SUMPRODUCT($F$5:$F$9,Assumptions!F$8:F$12,'Spectrum Opt'!E$32:E$36)*Projections!$W$6*Projections!$W11+SUMPRODUCT($K$5:$K$9,Assumptions!F$14:F$18,'Spectrum Opt'!N$32:N$36)*Projections!$W$7*Projections!$W17","v":63111073.947341397},null,null,{"$f":"B35/Projections!W35","v":24.514621201219651},{"$f":"C35/Projections!W29","v":24.514622405821029}]
["80 - 90%",{"$f":"SUMPRODUCT($F$5:$F$9,Assumptions!H$8:H$12,'Spectrum Opt'!F$32:F$36)*Projections!$W$6*Projections!$W12+SUMPRODUCT($K$5:$K$9,Assumptions!H$14:H$18,'Spectrum Opt'!O$32:O$36)*Projections!$W$7*Projections!$W18","v":32757167.297847722},{"$f":"SUMPRODUCT($F$5:$F$9,Assumptions!I$8:I$12,'Spectrum Opt'!G$32:G$36)*Projections!$W$6*Projections!$W12+SUMPRODUCT($K$5:$K$9,Assumptions!I$14:I$18,'Spectrum Opt'!P32:P36)*Projections!$W$7*Projections!$W18","v":29481450.745349254},null,null,{"$f":"B36/Projections!W36","v":23.196855759588498},{"$f":"C36/Projections!W30","v":23.196855899082454}]
["90 - 100%",{"$f":"SUMPRODUCT($F$5:$F$9,Assumptions!K$8:K$12,'Spectrum Opt'!H$32:H$36)*Projections!$W$6*Projections!$W13+SUMPRODUCT($K$5:$K$9,Assumptions!K$14:K$18,'Spectrum Opt'!Q$32:Q$36)*Projections!$W$7*Projections!$W19","v":51077556.333817787},{"$f":"SUMPRODUCT($F$5:$F$9,Assumptions!L$8:L$12,'Spectrum Opt'!I$32:I$36)*Projections!$W$6*Projections!$W13+SUMPRODUCT($K$5:$K$9,Assumptions!L$14:L$18,'Spectrum Opt'!R$32:R$36)*Projections!$W$7*Projections!$W19","v":45969801.770989612},null,null,{"$f":"B37/Projections!W37","v":27.638394441872542},{"$f":"C37/Projections!W31","v":27.638395085520788}]
["Total / Average",{"$f":"SUM(B34:B37)","v":497308576.69766027},{"$f":"SUM(C34:C37)","v":231048967.31823474},{"$f":"SUM(B34:C37)","v":728357544.01589513},null,{"$f":"SUM(B34:B37)/SUM(Projections!W34:W37)","v":33.835195381542164},{"$f":"SUM(C34:C37)/SUM(Projections!W28:W31)","v":30.191724917990367},{"$f":"SUM(B34:C37)/(SUM(Projections!W28:W31)+SUM(Projections!W34:W37))","v":32.58769585199024}]
[]
[{"$f":"CONCATENATE(Assumptions!$B$4,\" Relative Capacity with Increase\")","v":"2030 Relative Capacity with Increase"},"Out/Out","Out/In","Total",null,"Out/Out","Out/In","Average"]
["0 - 50%",{"$f":"B34/B13","v":86.428514069275806},{"$f":"C34/C13","v":17.285706433063133},null,null,86.428514069275806,{"$f":"G34/G13","v":86.428532165315588}]
["50 - 80%",{"$f":"B35/B14","v":48.157774159701781},19.263110469017565,null,null,48.157774159701773,{"$f":"G35/G14","v":48.157776172543983}]
["80 - 90%",{"$f":"B36/B15","v":39.809657683453473},{"$f":"C36/C15","v":23.885794467104951},null,null,{"$f":"F36/F15","v":39.809657683453473},{"$f":"G36/G15","v":39.809657445174885}]
["90 - 100%",{"$f":"B37/B16","v":41.010087060368065},{"$f":"C37/C16","v":24.606052847603252},null,null,{"$f":"F37/F16","v":41.010087060368072},41.010088079338715]
["Total / Average",null,null,{"$f":"D38/D17","v":37.258574102710277},null,{"$f":"F38/F17","v":63.598601736129048},{"$f":"G38/G17","v":56.750122227468658},61.253728749422713]
[]
[{"$f":"CONCATENATE(\"% Increase in Capacity in \",Assumptions!$B$4)","v":"% Increase in Capacity in 2030"},"Out/Out","Out/In","Total",null,"Out/Out","Out/In","Average"]
["0 - 50%",{"$f":"(B34-B20)/B20","v":-3.7004565189236694E-11},{"$f":"(C34-C20)/C20","v":1.0012013839319313E-10},null,null,-3.7004489726679494E-11,1.0012018089602847E-10]
["50 - 80%",{"$f":"(B35-B21)/B21","v":6.0005521182937233E-10},{"$f":"(C35-C21)/C21","v":-4.9140943190824106E-10},null,null,{"$f":"(F35-F21)/F21","v":6.0005514921055454E-10},-4.9140938904556089E-10]
["80 - 90%",{"$f":"(B36-B22)/B22","v":8.2912999870888259E-8},{"$f":"(C36-C22)/C22","v":8.8899360261222423E-8},null,null,8.2912999831963046E-8,8.8899360251395729E-8]
["90 - 100%",{"$f":"(B37-B23)/B23","v":4.7628056243292035E-8},{"$f":"(C37-C23)/C23","v":4.7737462619296183E-8},null,null,4.7628056305728495E-8,4.7737462647367761E-8]
["Total / Average",null,null,{"$f":"(D38-D24)/D24","v":1.3721335686657934E-8},null,{"$f":"(F38-F24)/F24","v":1.0457145952951983E-8},2.0747160461835568E-8,1.372133577456709E-8]
[]
[null,"Capacity",null,null,null,null,null,"Capacity relative to 2012"]
["Total Outdoor capacity","No additional spectrum","Current priorities","High priorities","Medium - High Priorities","Medium Priorities",null,"No additional spectrum","Current priorities","High priorities","Medium - High Priorities","Medium Priorities"]
[2012,7819489.1573402248,0,0,0,0," Paste value from B17",{"$f":"B56/$B$56","v":1},0,0,0,0]
[null,22159912.01673691,{"$f":"B57","v":22159912.01673691},{"$f":"C57","v":22159912.01673691},0,0," Paste value from B24/B38",2.8339334668601976,0,0,0,0]
[null,{"$f":"(B$64-B$57)/7+B57","v":32208901.828209043},{"$f":"(C$64-C$57)/7+C57","v":34767452.62564218},{"$f":"(D$64-D$57)/7+D57","v":38581552.09985441},0,0,null,4.1190544778713907,{"$f":"(C58/$B$56)-SUM($H58:H58)","v":0.3272017833839449},{"$f":"(D58/$B$56)-SUM($H58:I58)","v":0.4877683691947956},0,0]
[null,{"$f":"(B$64-B$57)/7+B58","v":42257891.639681175},47374993.234547451,55003192.18297191,0,0,null,5.4041754888825837,{"$f":"(C59/$B$56)-SUM($H59:H59)","v":0.65440356676788891},{"$f":"(D59/$B$56)-SUM($H59:I59)","v":0.9755367383895921},0,0]
[null,52306881.451153308,59982533.843452722,71424832.26608941,0,0,null,6.6892964998937776,{"$f":"(C60/$B$56)-SUM($H60:H60)","v":0.98160535015183292},{"$f":"(D60/$B$56)-SUM($H60:I60)","v":1.4633051075843868},0,0]
[null,62355871.262625441,72590074.452357993,87846472.34920691,0,0,null,7.9744175109049706,{"$f":"(C61/$B$56)-SUM($H61:H61)","v":1.3088071335357778},{"$f":"(D61/$B$56)-SUM($H61:I61)","v":1.9510734767791824},0,0]
[null,72404861.074097574,85197615.061263263,104268112.43232441,0,0,null,9.2595385219161646,{"$f":"(C62/$B$56)-SUM($H62:H62)","v":1.6360089169197209},{"$f":"(D62/$B$56)-SUM($H62:I62)","v":2.4388418459739789},0,0]
[null,82453850.885569707,97805155.670168534,120689752.51544191,0,0,null,10.544659532927357,{"$f":"(C63/$B$56)-SUM($H63:H63)","v":1.9632107003036658},{"$f":"(D63/$B$56)-SUM($H63:I63)","v":2.9266102151687754},0,0]
[2020,92502840.697041854,110412696.27907383,137111392.59855941,{"$f":"D64","v":137111392.59855941},0," Paste value from B24/B38 with modelling year set to 2020",11.829780543938552,{"$f":"(C64/$B$56)-SUM($H64:H64)","v":2.2904124836876125},{"$f":"(D64/$B$56)-SUM($H64:I64)","v":3.4143785843635648},{"$f":"(E64/$B$56)-SUM($H64:J64)","v":0},0]
[null,{"$f":"(B$69-B$64)/5+B64","v":111502082.99422872},{"$f":"(C$69-C$64)/5+C64","v":134208146.82463995},{"$f":"(D$69-D$64)/5+D64","v":167101143.65529019},{"$f":"(E$69-E$64)/5+E64","v":178888986.85803539},0,null,14.259509892607333,{"$f":"(C65/$B$56)-SUM($H65:H65)","v":2.9037784148721322},{"$f":"(D65/$B$56)-SUM($H65:I65)","v":4.206540372240724},{"$f":"(E65/$B$56)-SUM($H65:J65)","v":1.5074953063500125},0]
[null,{"$f":"(B$69-B$64)/5+B65","v":130501325.2914156},{"$f":"(C$69-C$64)/5+C65","v":158003597.37020606},197090894.71202096,220666581.11751136,0,null,16.689239241276116,{"$f":"(C66/$B$56)-SUM($H66:H66)","v":3.5171443460566536},{"$f":"(D66/$B$56)-SUM($H66:I66)","v":4.998702160117876},{"$f":"(E66/$B$56)-SUM($H66:J66)","v":3.014990612700025},0]
[null,149500567.58860248,181799047.91577217,227080645.76875174,262444175.37698734,0,null,19.118968589944902,{"$f":"(C67/$B$56)-SUM($H67:H67)","v":4.1305102772411679},{"$f":"(D67/$B$56)-SUM($H67:I67)","v":5.7908639479950317},{"$f":"(E67/$B$56)-SUM($H67:J67)","v":4.5224859190500375},0]
[null,168499809.88578936,205594498.46133828,257070396.82548252,304221769.63646328,0,null,21.548697938613685,{"$f":"(C68/$B$56)-SUM($H68:H68)","v":4.7438762084256858},{"$f":"(D68/$B$56)-SUM($H68:I68)","v":6.5830257358721873},{"$f":"(E68/$B$56)-SUM($H68:J68)","v":6.02998122540005},0]
[2025,187499052.18297622,229389949.00690436,287060147.88221323,345999363.89593929,{"$f":"E69","v":345999363.89593929}," Paste value from B24/B38 with modelling year set to 2025",23.978427287282464,{"$f":"(C69/$B$56)-SUM($H69:H69)","v":5.3572421396102072},{"$f":"(D69/$B$56)-SUM($H69:I69)","v":7.3751875237493394},{"$f":"(E69/$B$56)-SUM($H69:J69)","v":7.537476531750066},{"$f":"(F69/$B$56)-SUM($H69:K69)","v":0}]
[null,{"$f":"(B$74-B$69)/5+B69","v":228508347.49015763},{"$f":"(C$74-C$69)/5+C69","v":282973671.72464299},355177552.90068412,432764440.76135343,468767058.40374058,null,29.222925295018126,{"$f":"(C70/$B$56)-SUM($H70:H70)","v":6.9653302330316897},{"$f":"(D70/$B$56)-SUM($H70:I70)","v":9.2338360886737334},{"$f":"(E70/$B$56)-SUM($H70:J70)","v":9.9222450852608191},{"$f":"(F70/$B$56)-SUM($H70:K70)","v":4.6042160706356583}]
[null,{"$f":"(B$74-B$69)/5+B70","v":269517642.79733908},336557394.44238162,423294957.919155,519529517.62676758,591534752.91154194,null,34.467423302753794,{"$f":"(C71/$B$56)-SUM($H71:H71)","v":8.5734183264531723},{"$f":"(D71/$B$56)-SUM($H71:I71)","v":11.09248465359812},{"$f":"(E71/$B$56)-SUM($H71:J71)","v":12.307013638771579},{"$f":"(F71/$B$56)-SUM($H71:K71)","v":9.2084321412713166}]
[null,310526938.1045205,390141117.16012025,491412362.93762589,606294594.49218178,714302447.41934323,null,39.711921310489451,{"$f":"(C72/$B$56)-SUM($H72:H72)","v":10.181506419874658},{"$f":"(D72/$B$56)-SUM($H72:I72)","v":12.951133218522514},{"$f":"(E72/$B$56)-SUM($H72:J72)","v":14.691782192282332},{"$f":"(F72/$B$56)-SUM($H72:K72)","v":13.812648211906975}]
[null,351536233.41170192,443724839.87785888,559529767.95609677,693059671.35759592,837070141.92714453,null,44.956419318225116,{"$f":"(C73/$B$56)-SUM($H73:H73)","v":11.789594513296137},{"$f":"(D73/$B$56)-SUM($H73:I73)","v":14.809781783446908},{"$f":"(E73/$B$56)-SUM($H73:J73)","v":17.076550745793085},{"$f":"(F73/$B$56)-SUM($H73:K73)","v":18.416864282542633}]
[2030,392545528.71888334,497308562.59559751,627647172.97456765,779824748.22301006,959837836.43494582," Paste value from B24/B38 with modelling year set to 2030",50.200917325960781,{"$f":"(C74/$B$56)-SUM($H74:H74)","v":13.397682606717623},{"$f":"(D74/$B$56)-SUM($H74:I74)","v":16.668430348371295},{"$f":"(E74/$B$56)-SUM($H74:J74)","v":19.461319299303838},{"$f":"(F74/$B$56)-SUM($H74:K74)","v":23.021080353178291}]
[null,{"$f":"B74/$B$56","v":50.200917325960781},{"$f":"C74/$B$56","v":63.598599932678404},80.267030281049699,99.728349580353537,122.74942993353183]
[]
["Total Indoor capacity","No additional spectrum","Current priorities","High priorities","Medium - High Priorities","Medium Priorities",null,"No additional spectrum","Current priorities","High priorities","Medium - High Priorities","Medium Priorities"]
[2012,11729233.829428952,0,0,0,0," Paste value from C17",{"$f":"B78/$B$78","v":1},0,0,0,0]
[null,31408255.599365063,{"$f":"B79","v":31408255.599365063},{"$f":"C79","v":31408255.599365063},0,0," Paste value from C24/C38 with modelling year set to 2013",{"$f":"B79/$B$78","v":2.6777755526163127},0,0,0,0]
[null,{"$f":"(B$86-B$79)/7+B79","v":37588088.777730353},{"$f":"(C$86-C$79)/7+C79","v":39513283.251380697},42440007.266825959,0,0,null,3.2046499647249647,{"$f":"(C80/$B$78)-SUM($H80:H80)","v":0.16413642200737621},{"$f":"(D80/$B$78)-SUM($H80:I80)","v":0.24952388689720184},0,0]
[null,{"$f":"(B$86-B$79)/7+B80","v":43767921.956095643},47618310.903396331,53471758.934286848,0,0,null,3.7315243768336166,{"$f":"(C81/$B$78)-SUM($H81:H81)","v":0.32827284401475199},{"$f":"(D81/$B$78)-SUM($H81:I81)","v":0.49904777379440279},0,0]
[null,49947755.134460934,55723338.555411965,64503510.601747736,0,0,null,4.2583987889422685,{"$f":"(C82/$B$78)-SUM($H82:H82)","v":0.4924092660221282},{"$f":"(D82/$B$78)-SUM($H82:I82)","v":0.74857166069160375},0,0]
[null,56127588.312826224,63828366.207427599,75535262.269208625,0,0,null,4.78527320105092,{"$f":"(C83/$B$78)-SUM($H83:H83)","v":0.65654568802950486},{"$f":"(D83/$B$78)-SUM($H83:I83)","v":0.9980955475888047},0,0]
[null,62307421.491191514,71933393.859443232,86567013.936669514,0,0,null,5.3121476131595715,{"$f":"(C84/$B$78)-SUM($H84:H84)","v":0.82068211003688152},{"$f":"(D84/$B$78)-SUM($H84:I84)","v":1.2476194344860057},0,0]
[null,68487254.669556797,80038421.511458874,97598765.604130402,0,0,null,5.839022025268223,{"$f":"(C85/$B$78)-SUM($H85:H85)","v":0.98481853204425818},{"$f":"(D85/$B$78)-SUM($H85:I85)","v":1.4971433213832075},0,0]
[2020,74667087.847922087,88143449.1634745,108630517.27159131,{"$f":"D86","v":108630517.27159131},0," Paste value from C24/C38 with modelling year set to 2020",6.3658964373768745,{"$f":"(C86/$B$78)-SUM($H86:H86)","v":1.1489549540516348},{"$f":"(D86/$B$78)-SUM($H86:I86)","v":1.7466672082804084},0,0]
[null,{"$f":"(B$91-B$86)/5+B86","v":83976434.656269625},{"$f":"(C$91-C$86)/5+C86","v":99577058.824738055},122880731.28313629,129389143.34163335,0,null,7.1595839828489538,{"$f":"(C87/$B$78)-SUM($H87:H87)","v":1.330063360944008},{"$f":"(D87/$B$78)-SUM($H87:I87)","v":1.9868026162057344},{"$f":"(E87/$B$78)-SUM($H87:J87)","v":0.55488808162109216}]
[null,{"$f":"(B$91-B$86)/5+B87","v":93285781.464617163},111010668.48600161,137130945.29468128,150147769.41167539,0,null,7.9532715283210331,{"$f":"(C88/$B$78)-SUM($H88:H88)","v":1.5111717678363812},{"$f":"(D88/$B$78)-SUM($H88:I88)","v":2.2269380241310586},{"$f":"(E88/$B$78)-SUM($H88:J88)","v":1.1097761632421861}]
[null,102595128.2729647,122444278.14726517,151381159.30622628,170906395.48171744,0,null,8.7469590737931124,{"$f":"(C89/$B$78)-SUM($H89:H89)","v":1.6922801747287561},{"$f":"(D89/$B$78)-SUM($H89:I89)","v":2.4670734320563827},{"$f":"(E89/$B$78)-SUM($H89:J89)","v":1.6646642448632765}]
[null,111904475.08131224,133877887.80852872,165631373.31777129,191665021.55175948,0,null,9.5406466192651909,{"$f":"(C90/$B$78)-SUM($H90:H90)","v":1.8733885816211302},{"$f":"(D90/$B$78)-SUM($H90:I90)","v":2.7072088399817087},{"$f":"(E90/$B$78)-SUM($H90:J90)","v":2.2195523264843668}]
[2025,121213821.88965978,145311497.46979231,179881587.32931626,212423647.6218015,{"$f":"E91","v":212423647.6218015}," Paste value from C24/C38 with modelling year set to 2025",10.334334164737269,{"$f":"(C91/$B$78)-SUM($H91:H91)","v":2.0544969885135078},{"$f":"(D91/$B$78)-SUM($H91:I91)","v":2.9473442479070275},{"$f":"(E91/$B$78)-SUM($H91:J91)","v":2.7744404081054608},0]
[null,{"$f":"(B$96-B$91)/5+B91","v":134817076.65954319},{"$f":"(C$96-C$91)/5+C91","v":162458991.45967978},201312754.6237202,238918204.62901539,258152361.93296561,null,11.494107681721175,{"$f":"(C92/$B$78)-SUM($H92:H92)","v":2.3566684066594625},{"$f":"(D92/$B$78)-SUM($H92:I92)","v":3.3125576426445953},{"$f":"(E92/$B$78)-SUM($H92:J92)","v":3.2061301319564564},{"$f":"(F92/$B$78)-SUM($H92:K92)","v":1.6398477158577265}]
[null,{"$f":"(B$96-B$91)/5+B92","v":148420331.42942658},179606485.44956726,222743921.91812414,265412761.63622928,303881076.24412972,null,12.653881198705077,{"$f":"(C93/$B$78)-SUM($H93:H93)","v":2.6588398248054208},{"$f":"(D93/$B$78)-SUM($H93:I93)","v":3.6777710373821613},{"$f":"(E93/$B$78)-SUM($H93:J93)","v":3.6378198558074537},{"$f":"(F93/$B$78)-SUM($H93:K93)","v":3.2796954317154494}]
[null,162023586.19930997,196753979.43945473,244175089.21252808,291907318.64344317,349609790.55529386,null,13.813654715688982,{"$f":"(C94/$B$78)-SUM($H94:H94)","v":2.9610112429513773},{"$f":"(D94/$B$78)-SUM($H94:I94)","v":4.0429844321197308},{"$f":"(E94/$B$78)-SUM($H94:J94)","v":4.0695095796584475},{"$f":"(F94/$B$78)-SUM($H94:K94)","v":4.9195431475731795}]
[null,175626840.96919337,213901473.42934221,265606256.50693202,318401875.65065706,395338504.866458,null,14.973428232672886,{"$f":"(C95/$B$78)-SUM($H95:H95)","v":3.2631826610973338},{"$f":"(D95/$B$78)-SUM($H95:I95)","v":4.4081978268572968},{"$f":"(E95/$B$78)-SUM($H95:J95)","v":4.5011993035094484},{"$f":"(F95/$B$78)-SUM($H95:K95)","v":6.5593908634309024}]
[2030,189230095.73907679,231048967.41922975,287037423.80133599,344896432.65787101,441067219.17762208," Paste value from C24/C38 with modelling year set to 2030",16.133201749656791,{"$f":"(C96/$B$78)-SUM($H96:H96)","v":3.5653540792432921},{"$f":"(D96/$B$78)-SUM($H96:I96)","v":4.7734112215948628},{"$f":"(E96/$B$78)-SUM($H96:J96)","v":4.9328890273604458},{"$f":"(F96/$B$78)-SUM($H96:K96)","v":8.1992385792886182}]
[null,{"$f":"B96/$B$78","v":16.133201749656791},{"$f":"C96/$B$78","v":19.698555828900083},24.471967050494946,29.404856077855392,37.60409465714401]
[]
["Total capacity","No additional spectrum","Current priorities","High priorities","Medium - High Priorities","Medium Priorities",null,"No additional spectrum","Current priorities","High priorities","Medium - High Priorities","Medium Priorities"]
[2012,19548722.986769177,0,0,0,0," Paste value from D17",{"$f":"B100/$B$100","v":1},0,0,0,0]
[null,53568167.61610198,{"$f":"B101","v":53568167.61610198},{"$f":"C101","v":53568167.61610198},0,0," Paste value from D24/D38 with modelling year set to 2013",{"$f":"B101/$B$100","v":2.7402387180153709},0,0,0,0]
[null,{"$f":"(B$108-B$101)/7+B101","v":69796990.605939403},{"$f":"(C$108-C$101)/7+C101","v":74280735.877022892},81021559.366680369,0,0,null,3.5704117682356484,{"$f":"(C102/$B$100)-SUM($H102:H102)","v":0.22936256624630369},{"$f":"(D102/$B$100)-SUM($H102:I102)","v":0.34482167936083341},0,0]
[null,{"$f":"(B$108-B$101)/7+B102","v":86025813.595776826},94993304.137943804,108474951.11725876,0,0,null,4.4005848184559264,{"$f":"(C103/$B$100)-SUM($H103:H103)","v":0.45872513249260738},{"$f":"(D103/$B$100)-SUM($H103:I103)","v":0.68964335872166682},0,0]
[null,102254636.58561425,115705872.39886472,135928342.86783716,0,0,null,5.2307578686762035,{"$f":"(C104/$B$100)-SUM($H104:H104)","v":0.68808769873891151},{"$f":"(D104/$B$100)-SUM($H104:I104)","v":1.0344650380825016},0,0]
[null,118483459.57545167,136418440.65978563,163381734.61841556,0,0,null,6.0609309188964815,{"$f":"(C105/$B$100)-SUM($H105:H105)","v":0.91745026498521565},{"$f":"(D105/$B$100)-SUM($H105:I105)","v":1.3792867174433345},0,0]
[null,134712282.56528908,157131008.92070654,190835126.36899397,0,0,null,6.8911039691167577,{"$f":"(C106/$B$100)-SUM($H106:H106)","v":1.1468128312315198},{"$f":"(D106/$B$100)-SUM($H106:I106)","v":1.7241083968041711},0,0]
[null,150941105.55512649,177843577.18162745,218288518.11957237,0,0,null,7.7212770193370348,{"$f":"(C107/$B$100)-SUM($H107:H107)","v":1.3761753974778257},{"$f":"(D107/$B$100)-SUM($H107:I107)","v":2.0689300761650031},0,0]
[2020,167169928.54496393,198556145.44254836,245741909.87015072,{"$f":"D108","v":245741909.87015072},0," Paste value from D24/D38 with modelling year set to 2020",8.5514500695573137,{"$f":"(C108/$B$100)-SUM($H108:H108)","v":1.605537963724128},{"$f":"(D108/$B$100)-SUM($H108:I108)","v":2.4137517555258352},0,0]
[null,{"$f":"(B$113-B$108)/5+B108","v":195478517.65049833},{"$f":"(C$113-C$108)/5+C108","v":233785205.649378},289981874.93842643,308278130.19966877,0,null,9.9995543331807735,{"$f":"(C109/$B$100)-SUM($H109:H109)","v":1.9595493795070986},{"$f":"(D109/$B$100)-SUM($H109:I109)","v":2.8746977143766905},{"$f":"(E109/$B$100)-SUM($H109:J109)","v":0.93593096969175171},0]
[null,{"$f":"(B$113-B$108)/5+B109","v":223787106.75603274},269014265.85620767,334221840.00670218,370814350.52918679,0,null,11.447658596804235,{"$f":"(C110/$B$100)-SUM($H110:H110)","v":2.3135607952900692},{"$f":"(D110/$B$100)-SUM($H110:I110)","v":3.3356436732275476},{"$f":"(E110/$B$100)-SUM($H110:J110)","v":1.8718619393834999},0]
[null,252095695.86156714,304243326.06303734,378461805.07497793,433350570.85870481,0,null,12.895762860427697,{"$f":"(C111/$B$100)-SUM($H111:H111)","v":2.667572211073038},{"$f":"(D111/$B$100)-SUM($H111:I111)","v":3.7965896320784047},{"$f":"(E111/$B$100)-SUM($H111:J111)","v":2.8077929090752498},0]
[null,280404284.96710157,339472386.269867,422701770.14325368,495886791.18822283,0,null,14.343867124051158,{"$f":"(C112/$B$100)-SUM($H112:H112)","v":3.0215836268560103},{"$f":"(D112/$B$100)-SUM($H112:I112)","v":4.2575355909292583},{"$f":"(E112/$B$100)-SUM($H112:J112)","v":3.7437238787669997},0]
[2025,308712874.07263595,374701446.47669661,466941735.21152937,558423011.51774085,{"$f":"E113","v":558423011.51774085}," Paste value from D24/D38 with modelling year set to 2025",15.791971387674618,{"$f":"(C113/$B$100)-SUM($H113:H113)","v":3.3755950426389774},{"$f":"(D113/$B$100)-SUM($H113:I113)","v":4.7184815497801154},{"$f":"(E113/$B$100)-SUM($H113:J113)","v":4.6796548484587532},0]
[null,{"$f":"(B$118-B$113)/5+B113","v":363325424.14970076},{"$f":"(C$118-C$113)/5+C113","v":445432663.18432271},556490307.52440417,671682645.39036894,726919420.33670616,null,18.58563469315126,{"$f":"(C114/$B$100)-SUM($H114:H114)","v":4.2001331283988819},{"$f":"(D114/$B$100)-SUM($H114:I114)","v":5.6810690097377048},{"$f":"(E114/$B$100)-SUM($H114:J114)","v":5.8925761004403405},{"$f":"(F114/$B$100)-SUM($H114:K114)","v":2.8255950521024928}]
[null,{"$f":"(B$118-B$113)/5+B114","v":417937974.22676557},516163879.89194882,646038879.83727896,784942279.26299703,895415829.1556716,null,21.379297998627905,{"$f":"(C115/$B$100)-SUM($H115:H115)","v":5.0246712141587864},{"$f":"(D115/$B$100)-SUM($H115:I115)","v":6.6436564696952942},{"$f":"(E115/$B$100)-SUM($H115:J115)","v":7.1054973524219278},{"$f":"(F115/$B$100)-SUM($H115:K115)","v":5.6511901042049857}]
[null,472550524.30383039,586895096.59957492,735587452.15015376,898201913.13562512,1063912237.974637,null,24.172961304104547,{"$f":"(C116/$B$100)-SUM($H116:H116)","v":5.8492092999186909},{"$f":"(D116/$B$100)-SUM($H116:I116)","v":7.6062439296528837},{"$f":"(E116/$B$100)-SUM($H116:J116)","v":8.3184186044035116},{"$f":"(F116/$B$100)-SUM($H116:K116)","v":8.4767851563074856}]
[null,527163074.3808952,657626313.30720103,825136024.46302855,1011461547.0082532,1232408646.7936025,null,26.966624609581189,{"$f":"(C117/$B$100)-SUM($H117:H117)","v":6.6737473856785954},{"$f":"(D117/$B$100)-SUM($H117:I117)","v":8.5688313896104731},{"$f":"(E117/$B$100)-SUM($H117:J117)","v":9.5313398563851024},{"$f":"(F117/$B$100)-SUM($H117:K117)","v":11.302380208409986}]
[2030,581775624.45796001,728357530.01482725,914684596.77590358,1124721180.8808811,1400905055.6125677," Paste value from D24/D38 with modelling year set to 2030",29.760287915057834,{"$f":"(C118/$B$100)-SUM($H118:H118)","v":7.4982854714385034},{"$f":"(D118/$B$100)-SUM($H118:I118)","v":9.5314188495680696},{"$f":"(E118/$B$100)-SUM($H118:J118)","v":10.744261108366665},{"$f":"(F118/$B$100)-SUM($H118:K118)","v":14.127975260512478}]
[null,{"$f":"B118/$B$100","v":29.760287915057834},{"$f":"C118/$B$100","v":37.258573386496337},46.789992236064407,57.534253344431072,71.66222860494355]
[]
["Frequency Analysis","Base"]
["Sub 1 GHz",0.20042517663182186,{"$f":"B122/$B$122","v":1}]
["1 - 2 GHz ",0.16563319877744129,{"$f":"B123/$B$122","v":0.8264091446041586}]
["2 - 3 GHz",0.14927841250421578,0.74480868627816188]
["3 - 4 GHz",0.14356725050351218,0.71631345380946398]
["4 - 6 GHz",0.13676551875992993,0.68237694015441086]
[null," Paste value from D52"]
[]
["Total capacity - Current priorities","Zero growth","Base Case","High Growth ",null,"Zero growth","Base Case","High Growth "]
[2012,19548722.986769177,19548722.986769177,19548722.986769177," Paste value from D17",{"$f":"B130/$B$130","v":1},{"$f":"C130/$B$130","v":1},1]
[null,52782565.86767146,53568167.61610198,54210559.545000002," Paste value from D24/D38 with modelling year set to 2013",{"$f":"B131/$B$130","v":2.7000518603386712},{"$f":"C131/$B$130","v":2.7402387180153709},{"$f":"D131/$B$130","v":2.7730997867068039}]
[null,{"$f":"(B$138-B$131)/7+B131","v":69842967.300299197},{"$f":"(C$138-C$131)/7+C131","v":74280735.877022892},78360342.234028295,null,{"$f":"B132/$B$130","v":3.5727636709349149},{"$f":"C132/$B$130","v":3.7997743344819521},{"$f":"D132/$B$130","v":4.0084634831167012}]
[null,{"$f":"(B$138-B$131)/7+B132","v":86903368.732926935},94993304.137943804,102510124.92305659,null,4.4454754815311581,4.8593099509485338,5.2438271795265985]
[null,103963770.16555467,115705872.39886472,126659907.61208488,null,5.3181872921274023,5.918845567415115,6.4791908759364949]
[null,121024171.59818241,136418440.65978563,150809690.30111316,null,6.1908991027236455,6.9783811838816971,7.7145545723463913]
[null,138084573.03081015,157131008.92070654,174959472.99014145,null,7.0636109133198897,8.0379168003482775,8.9499182687562886]
[null,155144974.46343789,177843577.18162745,199109255.67916974,null,7.9363227239161329,9.0974524168148605,10.185281965166185]
[2020,172205375.89606565,198556145.44254836,223259038.36819804," Paste value from D24/D38 with modelling year set to 2020",8.8090345345123779,10.156988033281442,11.420645661576083]
[null,{"$f":"(B$143-B$138)/5+B138","v":195796306.28154728},{"$f":"(C$143-C$138)/5+C138","v":233785205.649378},272353913.3201161,null,10.015810567987725,11.959103712687872,13.932056508471099]
[null,{"$f":"(B$143-B$138)/5+B139","v":219387236.6670289},269014265.85620767,321448788.27203417,null,11.222586601463071,13.761219392094304,16.443467355366117]
[null,242978167.05251053,304243326.06303734,370543663.22395223,null,12.429362634938416,15.563335071500735,18.954878202261135]
[null,266569097.43799216,339472386.269867,419638538.1758703,null,13.636138668413762,17.365450750907168,21.466289049156149]
[2025,290160027.82347375,374701446.47669661,468733413.12778831," Paste value from D24/D38 with modelling year set to 2025",14.842914701889107,19.167566430313595,23.977699896051163]
[null,{"$f":"(B$148-B$143)/5+B143","v":330135884.34224761},{"$f":"(C$148-C$143)/5+C143","v":445432663.18432271},586197160.95016408,null,16.887849122711891,22.785767821550142,29.986468238713584]
[null,{"$f":"(B$148-B$143)/5+B144","v":370111740.86102146},516163879.89194882,703660908.77253985,null,18.932783543534672,26.403969212786691,35.995236581376005]
[null,410087597.37979531,586895096.59957492,821124656.59491563,null,20.977717964357456,30.022170604023238,42.004004924038426]
[null,450063453.89856917,657626313.30720103,938588404.4172914,null,23.02265238518024,33.640371995259784,48.01277326670084]
[2030,490039310.41734314,728357530.01482725,1056052152.2396674," Paste value from D24/D38 with modelling year set to 2030",25.067586806003028,37.258573386496337,54.021541609363275]