{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Version History","Quality Assurance","Style Guidelines","Contents","Style Guideline","Control","Inputs >","WLA inputs","UBC inputs","Calculations >","Non-SFBB areas","SFBB areas ","All areas","Ancillary services ","Indirect benefits"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":2,"defined_names":72,"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":"Version History","index":0,"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":1,"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":2,"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":"Contents","index":3,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,2]]}
[]
[null,null,null,null,null,{"$f":"Workbook.Title","v":"Volumes "}]
[]
["Information"]
[]
["Title ","Volumes "]
["Objective","Forecast incremental GEA volumes resulting from the deployment of BT's proposed network expansion"]
["Version","Version 1.0"]
["Spreadsheet Location","http://projects/sites/wla17cc/eco/Modelling/Universal broadband/UBC volumes impact.xlsm"]
[]
["Confidentiality status","Non-confidential"]
[]
["Do you want?",false]
[null,false]
[null,false]
[]
["Contents"]
[]
["Sheet","Description"]
["Contents","Presents the workbook structure and the terms and conditions of this model"]
["Style Guideline","Sets out style guidelines of this model"]
["Control","Sets out the key parameters of the model"]
[]
["Actual model sheets"]
["WLA inputs","Pulls inputs from March 2017 WLA model"]
["UBC inputs","Pulls inputs from Cartesian's geospatial analysis included in Network Cost module"]
["Non-SFBB areas","Estimates incremental GEA take-up in UBC areas currently not served by a SFBB network"]
["SFBB areas","Estimates incremental GEA take-up in UBC areas currently served by a SFBB network"]
["All areas","Aggregates outputs from Non-SFBB areas and SFBB areas worksheets"]
["Ancillary services","Estimates incremental ancillary services in UBC areas"]
["Indirect benefits","Estimates incremental GEA revenue in UBC areas"]
[]
[]
["Terms and conditions"]
[]
["The terms and conditions on which OFCOM is making available the model are set out below.  "]
["The bottom-up model provided has been developed to help understand the cost of providing fibre access services in the UK. "]
["All right, title and interest in the provided model (the ‘Model’) constructed in Excel to understand the cost of fibre based access services on a hypothetical FTTC network are owned by OFCOM. Such title and interest is protected by United Kingdom intellectual property laws and international treaty provisions. While you may freely use the Model for the purposes for which it is provided, as set out in the accompanying model documentation, 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 provided Model and it is provided 'as is'. It is provided without any representation or endorsement made and without warranty of any kind, whether express or implied, including but not limited to the implied warranties of satisfactory quality, fitness for a particular purpose, non-infringement, compatibility, security and accuracy. "]
["OFCOM does not accept any responsibility for any loss, disruption or damage to your data or your computer system which may occur whilst using the Model or material derived from the Model. OFCOM does not warrant that the functions contained in the Model will be uninterrupted or error free. Also, OFCOM does not warrant that defects will be corrected, or that the Model provided is free of viruses. "]
["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 Model. By using this Model, you agree to the above. "]

{"sheet":"Style Guideline","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Style Guidelines"]
[]
[]
["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"]

{"sheet":"Control","index":5,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Control",null,"Units",null,"Selected ",null,null,null,null,null," "]
[]
["Scenario",null,null,null,{"$f":"[2]Control!$H$20","v":"B1"},"UBC_scenario"]
["Techset",null,null,null,{"$f":"[2]Control!H$24","v":"LR-VDSL OFF"}]
[]
["Rollout"]
["Network deployment"]
["2017/18",null,"%",null,0]
["2018/19",null,"%",null,0.25]
["2019/20",null,"%",null,0.25]
["2020/21",null,"%",null,0.25]
["2021/22",null,"%",null,0.25]
["2022/23",null,"%",null,0]
["2023/24",null,"%",null,0]
["2024/25",null,"%",null,0]
["2025/26",null,"%",null,0]
["2026/27",null,"%",null,0]
["2027/28",null,"%",null,0]
["2028/29",null,null,null,0]
["Total",null,null,null,{"$f":"SUM(E8:E18)","v":1},"Network_rollout"]
["Take up"]
["Take-up uplift",null,null,null,0,"Takeup_uplift"]
["Catch-up period",null,null,null,8,"Catchup_period"]
["Take-up gap between UBC & Non-UBC areas",null,null,null,0,"Takeup_gap"]
["% take up gap to be closed",null,null,null,0.5,"Takeup_gap_closed"]
[]
["Ancillary services",null,null,null,"2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29"]
["GEA ceases as % of rentals",null,"%",null,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,"Cease_ratio"]
["GEA bandwidth changes as % of rentals",null,"%",null,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,0.15,"Bandwidth_change_ratio"]
["GEA migrations as % of rentals",null,"%",null,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,"Migration_ratio"]
[]
["Indirect benefits"]
["Incremental revenue uplift",null,null,null,0,"Revenue_uplift"]

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

{"sheet":"WLA inputs","index":7,"n_rows":68,"n_cols":23,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["WLA forecasts",null,"Units ","2011/12","2012/13","2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29",null,"Source"]
[]
["Demographic inputs"]
["UK households",null,"millions",26.55035625,26.785410249999998,27.019397249999997,27.274531750000001,27.5344795,27.800326250000001,28.061114500000006,28.320592500000007,28.579025250000004,28.834594000000013,29.088779250000009,29.337651500000014,29.584850000000021,29.831990250000022,30.076997500000026,30.323541000000027,30.566214750000036,30.804670500000036,null,"WLA Volumes module"]
[]
["Total no. of lines and BB penetration"]
[]
["Total UK unadjusted OR lines",null,"millions",24.363647085594017,24.467365761318998,24.758557808652156,24.925571303332987,25.094279193518332,25.318483730822798,25.511023094454956,25.704985142883981,25.910553389956164,26.10937057009204,26.309960238484255,26.510165978483432,26.709430894088126,26.910706676032532,27.112155430155067,27.315987688878536,27.518146138911693,27.718160702772337,null,"WLA Volumes module"]
[]
["Total UK OR broadband lines",null,"millions",16.133040092343279,16.658983931763895,18.196122066733057,18.990872681666332,19.951321277685668,20.635945793621961,21.3030963431614,21.979164940379047,22.673148076661736,23.369311369534039,23.942431393199936,24.486180188491371,24.990589166796862,25.446783930815077,25.872934110991118,26.271103486817733,26.639706305856979,26.984013147630051,null,"WLA Volumes module"]
["Broadband penetration of Openreach lines",null,"%",null,null,null,null,null,null,{"$f":"J10/J8","v":0.83505456697233815},{"$f":"K10/K8","v":0.85505456697233806},0.87505456697233808,0.89505456697233809,0.91001397098953907,0.92365246631670295,0.9356466360475052,0.94560073197478423,0.95429277755668052,0.96174825475974945,0.96807779751512524,0.97351384303544863,null,"WLA Volumes module"]
[]
["Total UK GEA broadband lines",null,"millions",0.32704009234327897,0.92491858333333321,2.0345887378122156,3.4098883333330003,5.0578365833333336,6.8822706229504051,8.8090189453060574,10.846912491073338,13.003251159155989,15.272051880677244,16.935957946877192,18.424749169168969,19.695112558308566,20.700529842456863,21.54913940220526,22.257448849546662,22.845144620881083,23.345712492521386,null,"WLA Volumes module"]
["Proportion of Openreach broadband lines that are GEA",null,"%",{"$f":"D13/D4","v":1.2317728969956062E-2},3.4530685724081203E-2,7.5301040914679027E-2,0.12502096698078052,0.18369101850402997,0.24756078619582406,{"$f":"J13/J4","v":0.31392263287711025},0.3830044336492372,0.45499281537448472,0.52964338185851467,0.58221618038086587,0.62802399739355275,0.66571615398788742,0.69390374792231124,0.71646577761644059,0.73399900260812689,0.7473985512347765,0.75786275631551903,null,"WLA Volumes module"]
[]
[]
["Lines adjusted for competitive network build"]
[]
["Total UK adjusted OR lines",null,"millions",24.363647085594017,24.467365761318998,24.758557808652156,24.925571303332987,25.094279193518332,24.998483730822798,24.871023094454955,24.69488514288398,24.530353389956161,24.359070570092037,24.509560238484255,24.659665978483432,24.808830894088125,24.960006676032531,25.111355430155065,25.265087688878534,25.41714613891169,25.567060702772334,null,"WLA Volumes module"]
[]
["Total UK broadband lines",null,null,16.133040092343279,16.658983931763895,18.196122066733057,18.990872681666332,19.951321277685668,20.31594579362196,20.663096343161399,20.969064940379045,21.292948076661734,21.619011369534036,22.142031393199936,22.635680188491371,23.089989166796862,23.496083930815075,23.872134110991116,24.220203486817731,24.538706305856977,24.832913147630048,null,"WLA Volumes module"]
["Broadband penetration of Openreach lines",null,"%",0.66217672730461552,0.68086544723586273,0.73494272999916888,0.76190320577032944,0.79505456697233801,0.81268712184222069,0.83081006618373809,0.84912583391469798,0.86802451388164803,0.88751380342391906,0.90340386272753725,0.91792322768045309,0.93071653659822973,0.94134926467695357,0.950650958582832,0.95864315948838952,0.96543908477160267,0.97128541431973525,null,"WLA Volumes module"]
[]
["Total UK GEA broadband lines",null,"millions",0.32704009234327897,0.92491858333333321,2.0345887378122156,3.4098883333330003,5.0578365833333336,6.7755477898237153,8.5443732790526781,10.348419198131872,12.211694239526434,14.128215334359604,15.662424019315523,17.032331157250066,18.197247474837262,19.11366826995059,19.882706135264101,20.519881873403452,21.04341121220914,21.484648985476905,null,"WLA Volumes module"]
["Proportion of Openreach broadband lines that are GEA",null,"%",{"$f":"D24/D4","v":1.2317728969956062E-2},{"$f":"E24/E4","v":3.4530685724081203E-2},7.5301040914679027E-2,0.12502096698078052,0.18369101850402997,0.24372188041583559,0.30449158671344562,0.36540263760837166,0.42729568740369939,0.48997448461939841,0.53843524627509143,0.58056218839637042,0.61508669047966269,0.64071046248584018,0.66106020507080487,0.67669807669900539,0.68845329342617134,0.69744777778021938,null,"WLA Volumes module"]
[]
[]
[]
["GEA bandwidth"]
["Total GEA-FTTC lines (commercial)",null,"One",null,null,null,null,null,4802856.883807919,5971247.6660594987,7128523.5827423632,8289926.3566834992,9449677.3299123179,10517239.727606293,11482151.684106469,12315572.398014311,12986317.933635192,13561383.340813801,14050227.062095482,14464324.035429666,14824407.799979063,null,"WLA Volumes module"]
["Internal",null,"One",null,null,null,null,null,3926117.5688976445,5120073.9233297035,6397526.4528402127,7771429.7971054111,9236630.8030414339,10566865.409900704,11812845.18363229,12919547.362091724,13826171.547705701,14614465.351714296,15288746.369099144,15860098.354817899,16355165.84293508,null,"WLA Volumes module"]
["External",null,"One",null,null,null,null,null,876739.31491027446,851173.7427297947,730997.12990215048,518496.55957808933,213046.52687088292,-49625.682294410923,-330693.49952581926,-603974.96407741436,-839853.61407050956,-1053082.0109004953,-1238519.3070036641,-1395774.3193882322,-1530758.042956016,null,"WLA Volumes module"]
["40/2 mgbit/s ",null,"One",null,null,null,null,null,387613.29479310068,362630.45521935925,299136.28637102887,225377.59273885834,135055.0305954825,61333.687547978661,-11414.473370614061,-78679.407266870447,-134517.52508421164,-183106.99210804724,-224042.61953098996,-257776.19920014293,-286020.59375602775,null,"WLA Volumes module"]
["40/10 mgbit/s",null,"One",null,null,null,null,null,1447065.5681113077,1742660.2312810987,2449993.5832107775,3223560.1608624258,4049475.7583752731,4873479.0568518965,5623330.5134318173,6308026.8824325744,6893697.0324144876,7404480.1441237405,7849818.473839093,8233568.6430025063,8567961.3395744897,null,"WLA Volumes module"]
["55/10 mgbit/s",null,"One",null,null,null,null,null,1494536.3950299048,1923944.4543881838,2113880.403830071,2301209.70001435,2455162.7585029053,2542127.6621651612,2625564.2694271775,2674444.2399462671,2691646.3888015989,2702572.1492509414,2704716.319601485,2702338.3161752466,2699912.3541500578,null,"WLA Volumes module"]
["80/20 mgbit/s",null,"One",null,null,null,null,null,1337626.8821626466,1623707.9472854482,1876841.9304591112,2141318.6024341611,2400774.0618468584,2615861.5608879365,2805891.9789329031,2960124.9233748433,3073064.837169027,3165484.294671284,3239454.0717214174,3298668.2535687988,3348588.0247232029,null,"WLA Volumes module"]
[]
["Bandwidth mix"]
["40/2 mgbit/s ",null,"%",null,null,null,null,null,null,{"$f":"J33/SUM(J$33:J$36)","v":6.4148966222210724E-2},{"$f":"K33/SUM(K$33:K$36)","v":4.4383211578322437E-2},2.8559660668638149E-2,1.4938943031690506E-2,6.0769732474456623E-3,-1.0336039637622166E-3,-6.6318240143084508E-3,-1.0740873419354487E-2,-1.3988920660444316E-2,-1.6510206855323614E-2,-1.8443149890780035E-2,-1.9958952503088469E-2]
["40/10 mgbit/s",null,"%",null,null,null,null,null,null,{"$f":"J34/SUM(J$33:J$36)","v":0.30827485861775777},0.36350850272408647,0.40848685630360965,0.44792768840854585,0.48286680671708165,0.50920410600734223,0.53169851699473281,0.55044372225990568,0.56568394289859614,0.57847085992447678,0.58908829088995818,0.5978853871296167]
["55/10 mgbit/s",null,"%",null,null,null,null,null,null,0.34034385706324544,0.31363898493441417,0.2916073748109434,0.27157475305499545,0.25187531374963601,0.237750227091413,0.22542675588854943,0.21492094159241887,0.20646981821802521,0.19931665687123104,0.19334457865181592,0.18840399473105116]
["80/20 mgbit/s",null,"%",null,null,null,null,null,null,0.28723231809678607,0.27846930076317694,0.27134610821680882,0.26555861550476817,0.25918090628583662,0.25407927086500692,0.24950655113102627,0.24537620956702999,0.2418351595438229,0.23872269005961577,0.23601028034900606,0.23366957064242069]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEA_bandwidth_mix"]
["GEA prices"]
["Rental prices"]
["40/2 mgbit/s ",null,null,null,null,null,null,null,null,82.8,60.614140136673392,51.617739631570203,47.433867837837042,{"$f":"M46","v":47.433867837837042},{"$f":"N46","v":47.433867837837042},47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,null,"WLA Control module - assumed constant from 2020/21 onwards"]
["40/10 mgbit/s",null,null,null,null,null,null,null,null,88.8,65.006469132084504,55.358155546901372,50.871104637680304,{"$f":"M47","v":50.871104637680304},{"$f":"N47","v":50.871104637680304},50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,null,"WLA Control module - assumed constant from 2020/21 onwards"]
["55/10 mgbit/s",null,null,null,null,null,null,null,null,100.8,73.79112712290673,62.838987377563718,57.745578237366828,{"$f":"M48","v":57.745578237366828},{"$f":"N48","v":57.745578237366828},57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,null,"WLA Control module - assumed constant from 2020/21 onwards"]
["80/20 mgbit/s",null,null,null,null,null,null,null,null,119.4,87.407347008681199,74.434276715090363,68.401012316880951,{"$f":"M49","v":68.401012316880951},{"$f":"N49","v":68.401012316880951},68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,null,"WLA Control module - assumed constant from 2020/21 onwards"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEA_rental_prices"]
["Ancillary prices"]
["Engineer install",null,null,null,null,null,null,null,null,99,90,81.239021822666729,83.757478076317142,86.353695997845563,89.030773026199427,91.790930289370564,94.636542883787996,97.569886190331914,100.59473032037326,103.71359548816748,106.92848633306981,null,"WLA Cost Recovery - assumed to follow bottom-up LRIC from 2019/20 onwards"]
["FTTP Engineer install",null,null,null,null,null,null,null,null,117,117,117,117,117,117,117,117,117,117,117,117,null,"BT price for FTTP connection - assumed to remain constant over time"]
["PCP only",null,null,null,null,null,null,null,null,49,47.482736119788846,46.5507981923557,47.479447352442676,49.759732628550481,50.0582646029195,52.532164481871007,54.330471977941954,55.386939786987867,56.616899868078569,58.502889171737124,60.315468163962692,null,"WLA Control module - assumed to follow bottom-up LRIC from 2020/21 onwards"]
["Start of Stopped line",null,null,null,null,null,null,null,null,32.520000000000003,7.0823060625811793,3.2766254281139315,3.3782004540021062,3.4829721641818874,3.5909443298225461,3.7022638505850671,3.8170340094786921,3.9353618473533016,4.0573581193108188,4.1831363555708334,4.3128133724289022,null,"WLA Control module - assumed to follow bottom-up LRIC from 2020/21 onwards"]
["GEA Ceases",null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"M56","v":0},0,0,0,0,0,0,0,null,"WLA Control module - assumed to follow bottom-up LRIC from 2020/21 onwards"]
["Bandwidth Change",null,null,null,null,null,null,null,null,11.25,9.1129874710207002,8.1652478989028516,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,null,"WLA Control module - assumed to follow bottom-up LRIC from 2020/21 onwards"]
["Migrations",null,null,null,null,null,null,null,null,11,4.9260321672985148,3.2766563084048643,3.3782322915786422,3.4829721641818874,3.5909443298225461,3.7022638505850671,3.8170340094786921,3.9353618473533016,4.0573581193108188,4.1831363555708334,4.3128133724289022,null,"WLA Control module - assumed to follow bottom-up LRIC from 2020/21 onwards"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEA_ancillary_prices"]
[]
["GEA Connections"]
["PCP only",null,"One",0,2418.4224317656526,83599.222244897799,1045342.0838813619,2048246.15670643,2519468.1296136011,2891331.4959520665,3187149.0687594214,3390236.0979638025,3330111.4157748176,3122582.9930576659,2984089.0904214745,2790306.6109914165,2614392.6141731725,2489166.3713945402,2376606.0426967102,2285757.262508112,2034330.9345936105,null,"WLA Volumes module"]
["Engineer install",null,"One",431322.50500000006,979438.65989501018,1391649.6311241374,938914.39279806009,388766.52051207446,275118.06364092772,176793.01150022153,115615.94446919482,83071.351309239006,62576.281334225539,49625.427350385427,39814.186682116881,33051.912090844366,28393.76092797039,25075.854241749123,22660.183437670385,20852.943014521741,18765.431849655666,null,"WLA Volumes module"]
["Start of Stopped line",null,"One",0,0,0,601,56006.169391911477,64766.761078725103,71550.501057886519,77430.16018393077,81813.960935149342,79963.229834298603,74666.565200043842,71206.176679834258,66435.99882398406,62122.400221087504,59055.514145549387,56299.932415306102,54076.308816487901,48002.874942827504,null,"WLA Volumes module"]
[]
["PCP only",null,"%",{"$f":"D62/SUM(D$62:D$64)","v":0},{"$f":"E62/SUM(E$62:E$64)","v":2.463110441730019E-3},5.666787813729305E-2,0.52665851133562125,0.82159272862749821,0.88113225958881047,0.92090152264646297,0.94288906564580655,0.95362034281840957,0.95895368864673403,0.96171950164346987,0.96413039182629201,0.9655726695581105,0.96653633498664848,0.96730601084877521,0.96784443555794386,0.96825955018767662,0.9682222022276129]
["Engineer install",null,"%",{"$f":"D63/SUM(D$62:D$64)","v":1},0.99753688955826991,0.94333212186270687,0.47303869614297045,0.15594207041019897,9.6216895232886679E-2,5.6309334890082337E-2,3.4203925672277764E-2,2.3366670705171299E-2,1.8019744181228644E-2,1.528405853947323E-2,1.2863579552396276E-2,1.1437460982188367E-2,1.0497123299320102E-2,9.7446377285028141E-3,9.2280891552333506E-3,8.8334231961161355E-3,8.9312448836429657E-3]
["Start of Stopped line",null,"%",0,0,0,3.0279252140836139E-4,2.246520096230286E-2,2.2650845178302747E-2,2.2789142463454638E-2,2.2907008681915704E-2,2.3012986476419171E-2,2.3026567172037344E-2,2.2996439817056836E-2,2.3006028621311812E-2,2.2989869459701148E-2,2.2966541714031365E-2,2.2949351422721899E-2,2.29274752868227E-2,2.2907026616207304E-2,2.2846552888744105E-2]

{"sheet":"UBC inputs","index":8,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["UBC inputs ",null,null,"Units"]
[]
[null,"Lines affected by LR-VDSL "]
[null,"Migration adsl",null,"One",null,{"$f":"INDEX([2]Calc_GeoVolumes!$F$11:$F$50,MATCH(B4,[2]Calc_GeoVolumes!$D$11:$D$50,0))","v":0}]
[]
[null,"UBC Premises",null,null,null,null,null,null,"Split by technology","%"]
[null,"VDSL Premises",null,"One",null,{"$f":"INDEX([2]Calc_GeoVolumes!$F$11:$F$50,MATCH(B7,[2]Calc_GeoVolumes!$D$11:$D$50,0))","v":1287955},null,null,"VDSL",{"$f":"F7/$F$12","v":0.68159471216435052}]
[null,"LR-VDSL Premises",null,"One",null,{"$f":"INDEX([2]Calc_GeoVolumes!$F$11:$F$50,MATCH(B8,[2]Calc_GeoVolumes!$D$11:$D$50,0))","v":0},null,null,"LR-VDSL",{"$f":"F8/$F$12","v":0}]
[null,"FTTP Premises",null,"One",null,{"$f":"INDEX([2]Calc_GeoVolumes!$F$11:$F$50,MATCH(B9,[2]Calc_GeoVolumes!$D$11:$D$50,0))","v":155258},null,null,"FTTC",{"$f":"SUM(F7:F8)/$F$12","v":0.68159471216435052},"FTTC_ratio"]
[null,"Gfast Premises",null,"One",null,{"$f":"INDEX([2]Calc_GeoVolumes!$F$11:$F$50,MATCH(B10,[2]Calc_GeoVolumes!$D$11:$D$50,0))","v":446407},null,null,"FTTP",{"$f":"F9/$F$12","v":8.2163609614631511E-2},"FTTP_ratio"]
[null,null,null,null,null,null,null,null,"Gfast",{"$f":"F10/$F$12","v":0.23624167822101799},"Gfast_ratio"]
[null,"Total fixed UBC premises",null,"One",null,{"$f":"SUM(F7:F10)","v":1889620},"Fixed_premises"]
[]
[null,"FWA Premises",null,"One",null,{"$f":"INDEX([2]Calc_GeoVolumes!$F$11:$F$50,MATCH(B14,[2]Calc_GeoVolumes!$D$11:$D$50,0))","v":469819}]
[null,"Satellite Premises",null,"One",null,{"$f":"INDEX([2]Calc_GeoVolumes!$F$11:$F$50,MATCH(B15,[2]Calc_GeoVolumes!$D$11:$D$50,0))","v":10210}]
[null,"Total wireless UBC premises",null,"One",null,{"$f":"SUM(F14:F15)","v":480029},"Wireless_premises"]
[null,"Total UBC premises",null,"One",null,{"$f":"F12+SUM(F14:F15)","v":2369649}]
[]
[null,"Premises from ADSL cabinets",null,"One",null,{"$f":"INDEX([2]Calc_GeoVolumes!$F$11:$F$50,MATCH(B19,[2]Calc_GeoVolumes!$D$11:$D$50,0))","v":1287955}]
[null,"Proportion of total UBC premises",null,null,null,{"$f":"F19/F17","v":0.5435214244810096}]
[]
[null,"Fixed premises from ADSL cabinets",null,"One",null,{"$f":"F12*$F$20","v":1027048.9541278053},"Non_SFBB_premises"]
[null,"Fixed premises from GEA cabinets",null,"One",null,{"$f":"F12-Non_SFBB_premises","v":862571.04587219469},"SFBB_premises"]

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

{"sheet":"Non-SFBB areas","index":10,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Non-SFBB areas"]
[]
[null,null,null,"Units",null,null,"2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29"]
[]
[null,"UBC Scenario"]
[null,{"$f":"UBC_scenario","v":"B1"}]
[]
[null,"Non-SFBB UBC premises",null,"millions",null,{"$f":"Non_SFBB_premises/million","v":1.0270489541278054}]
[]
[null,"Take up"]
[null,"2017/18",null,"%",null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"2018/19",null,"%",null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"2019/20",null,"%",null,null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"2020/21",null,"%",null,null,null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"2021/22",null,"%",null,null,null,null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"2022/23",null,"%",null,null,null,null,null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"2023/24",null,"%",null,null,null,null,null,null,null,null,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"2024/25",null,"%",null,null,null,null,null,null,null,null,null,0.1,0.1,0.1,0.1,0.1]
[null,"2025/26",null,"%",null,null,null,null,null,null,null,null,null,null,0.1,0.1,0.1,0.1]
[null,"2026/27",null,"%",null,null,null,null,null,null,null,null,null,null,null,0.1,0.1,0.1]
[null,"2027/28",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.1]
[null,"2028/29",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[]
[null,"Subscriber take-up",null,"%",null,null,{"$f":"SUMPRODUCT(Network_rollout,G$11:G$22)","v":0},2.5000000000000001E-2,0.05,7.5000000000000011E-2,0.1,0.1,0.1,0.1,0.1,7.5000000000000011E-2,0.05,2.5000000000000001E-2]
[null,"Cumulative take-up",null,"%",null,null,{"$f":"G25","v":0},{"$f":"G26+H25","v":2.5000000000000001E-2},{"$f":"H26+I25","v":7.5000000000000011E-2},0.15000000000000002,0.25,0.35,0.44999999999999996,0.54999999999999993,0.64999999999999991,0.72499999999999987,0.77499999999999991,0.79999999999999993]
[]
[null,"Unadjusted UBC subscribers",null,"millions ",null,null,{"$f":"$F$8*G26*(1+Takeup_uplift)","v":0},2.5676223853195138E-2,7.7028671559585413E-2,0.15405734311917083,0.25676223853195135,0.35946713394473184,0.46217202935751239,0.56487692477029294,0.66758182018307344,0.74461049174265881,0.79596293944904906,0.82163916330224429]
[]
[null,"GEA bandwidth split"]
[null,"40/2 mgbit/s ",null,"%",null,null,{"$f":"G28:R28*GEA_bandwidth_mix","v":0},1.1395932758087291E-3,2.1999127214977375E-3,2.3014538724708904E-3,1.5603372545129302E-3,-3.7154665448751849E-4,-3.065043563034821E-3,-6.0672715464719432E-3,-9.3387491168960175E-3,-1.2293673245315532E-2,-1.4680063799764685E-2,-1.6399057035026844E-2]
[null,"40/10 mgbit/s",null,"%",null,null,0,9.3335256884834392E-3,3.1465199890618308E-2,6.900654958573238E-2,0.12398196220545296,0.18304214057934873,0.24573618260583546,0.31093295708928875,0.37764031624858257,0.43073547146716334,0.46889244761178756,0.49124604923181669]
[null,"55/10 mgbit/s",null,"%",null,null,0,8.0530647862649147E-3,2.2462128698665079E-2,4.1838084913897518E-2,6.4672069389294123E-2,8.5463392727259363E-2,0.10418594124049145,0.12140388055546132,0.13783549705885756,0.14841327388539013,0.15389511915023726,0.15480010059362131]
[null,"80/20 mgbit/s",null,"%",null,null,0,7.150040102638055E-3,2.0901430248804288E-2,4.0911254747070025E-2,6.6547869682691316E-2,9.1333147292611244E-2,0.11531494907422034,0.13860735867201485,0.16144475599252925,0.17775541963542082,0.18785543648678901,0.1919920705118332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subs_non_SFBB_split"]

{"sheet":"SFBB areas ","index":11,"n_rows":40,"n_cols":19,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["SFBB areas"]
[]
[null,null,null,"Units",null,null,"2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29"]
[]
[null,"UBC Scenario"]
[null,{"$f":"UBC_scenario","v":"B1"}]
[]
[null,"UBC premises",null,"millions",null,{"$f":"SFBB_premises/million","v":0.86257104587219469}]
[]
[null,"Take up gap",null,"%",null,{"$f":"Takeup_gap","v":0}]
[null,"% of take up gap to be closed",null,null,null,{"$f":"Takeup_gap_closed","v":0.5}]
[null,"UBC take up impact",null,null,null,{"$f":"F10*F11","v":0}]
[null,"Annual take-up",null,"%",null,{"$f":"F12/Catchup_period","v":0}]
[]
[null,"Take up"]
[null,"2017/18",null,"%",null,null,{"$f":"$F$13","v":0},0,0,0,0,0,0,0]
[null,"2018/19",null,"%",null,null,null,{"$f":"$F$13","v":0},0,0,0,0,0,0,0]
[null,"2019/20",null,"%",null,null,null,null,{"$f":"$F$13","v":0},0,0,0,0,0,0,0]
[null,"2020/21",null,"%",null,null,null,null,null,{"$f":"$F$13","v":0},0,0,0,0,0,0,0]
[null,"2021/22",null,"%",null,null,null,null,null,null,{"$f":"$F$13","v":0},0,0,0,0,0,0,0]
[null,"2022/23",null,"%",null,null,null,null,null,null,null,{"$f":"$F$13","v":0},0,0,0,0,0,0]
[null,"2023/24",null,"%",null,null,null,null,null,null,null,null,{"$f":"$F$13","v":0},0,0,0,0,0]
[null,"2024/25",null,"%",null,null,null,null,null,null,null,null,null,{"$f":"$F$13","v":0},{"$f":"$F$13","v":0},{"$f":"$F$13","v":0},{"$f":"$F$13","v":0},{"$f":"$F$13","v":0}]
[null,"2025/26",null,"%",null,null,null,null,null,null,null,null,null,null,{"$f":"$F$13","v":0},{"$f":"$F$13","v":0},{"$f":"$F$13","v":0},{"$f":"$F$13","v":0}]
[null,"2026/27",null,"%",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$13","v":0},{"$f":"$F$13","v":0},{"$f":"$F$13","v":0}]
[null,"2027/28",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$13","v":0},{"$f":"$F$13","v":0}]
[null,"2028/29",null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$13","v":0}]
[]
[]
[null,"Subscriber take-up",null,"%",null,null,{"$f":"SUMPRODUCT(Network_rollout,G$16:G$27)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Cumulative take-up",null,"%",null,null,{"$f":"G30","v":0},{"$f":"G31+H30","v":0},{"$f":"H31+I30","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Unadjusted UBC subscribers",null,"millions ",null,null,{"$f":"$F$8*G31*(1+Takeup_uplift)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"GEA bandwidth split"]
[null,"40/2 mgbit/s ",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"40/10 mgbit/s",null,"%",null,null,{"$f":"G33","v":0},{"$f":"H33","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"55/10 mgbit/s",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"80/20 mgbit/s",null,"%",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subs_SFBB_split"]

{"sheet":"All areas","index":12,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["All areas"]
[]
[null,null,null,"Units",null,"2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29"]
[]
[null,"UBC Scenario"]
[null,{"$f":"UBC_scenario","v":"B1"}]
[]
[null,"Total UBC subs",null,"millions"]
[null,"40/2 mgbit/s ",null,"millions",null,{"$f":"Subs_non_SFBB_split+Subs_SFBB_split","v":0},1.1395932758087291E-3,2.1999127214977375E-3,2.3014538724708904E-3,1.5603372545129302E-3,-3.7154665448751849E-4,-3.065043563034821E-3,-6.0672715464719432E-3,-9.3387491168960175E-3,-1.2293673245315532E-2,-1.4680063799764685E-2,-1.6399057035026844E-2]
[null,"40/10 mgbit/s",null,"millions",null,0,9.3335256884834392E-3,3.1465199890618308E-2,6.900654958573238E-2,0.12398196220545296,0.18304214057934873,0.24573618260583546,0.31093295708928875,0.37764031624858257,0.43073547146716334,0.46889244761178756,0.49124604923181669]
[null,"55/10 mgbit/s",null,"millions",null,0,8.0530647862649147E-3,2.2462128698665079E-2,4.1838084913897518E-2,6.4672069389294123E-2,8.5463392727259363E-2,0.10418594124049145,0.12140388055546132,0.13783549705885756,0.14841327388539013,0.15389511915023726,0.15480010059362131]
[null,"80/20 mgbit/s",null,"millions",null,0,7.150040102638055E-3,2.0901430248804288E-2,4.0911254747070025E-2,6.6547869682691316E-2,9.1333147292611244E-2,0.11531494907422034,0.13860735867201485,0.16144475599252925,0.17775541963542082,0.18785543648678901,0.1919920705118332]
[null,"Total",null,"millions",null,{"$f":"SUM(F9:F12)","v":0},{"$f":"SUM(G9:G12)","v":2.5676223853195138E-2},7.7028671559585399E-2,0.15405734311917083,0.25676223853195135,0.35946713394473184,0.46217202935751245,0.56487692477029294,0.66758182018307333,0.74461049174265881,0.79596293944904917,0.8216391633022444,"Total_UBC_subs"]
[]
[null,"Total UBC premises",null,"millions",null,{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001},{"$f":"'UBC inputs'!$F$12/million","v":1.8896200000000001}]
[]
[null,"UBC Take up",null,"%",null,{"$f":"F13/F15","v":0},{"$f":"G13/G15","v":1.3588035612025241E-2},4.0764106836075717E-2,8.1528213672151448E-2,0.1358803561202524,0.19023249856835334,0.24458464101645433,0.29893678346455527,0.35328892591265615,0.39405303274873188,0.4212291039727824,0.43481713958480772,"UBC_takeup"]

{"sheet":"Ancillary services ","index":13,"n_rows":72,"n_cols":17,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Ancillary services"]
[]
[null,null,"Units ",null,"2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29"]
[]
["Total GEA rentals",null,"One",null,{"$f":"Total_UBC_subs*million","v":0},25676.223853195137,77028.671559585404,154057.34311917084,256762.23853195136,359467.13394473185,462172.02935751242,564876.92477029294,667581.82018307329,744610.49174265878,795962.93944904918,821639.16330224439]
["FTTC rentals",null,"One",null,{"$f":"E5*FTTC_ratio","v":0},17500.778406685971,52502.33522005791,105004.67044011583,175007.78406685969,245010.89769360353,315014.01132034743,385017.12494709133,455020.23857383506,507522.57379389304,542524.13060726505,560024.90901395108]
["FTTP rentals",null,"One",null,{"$f":"E5*FTTP_ratio","v":0},2109.6512330518149,6328.9536991554442,12657.90739831089,21096.512330518148,29535.117262725402,37973.722194932663,46412.327127139921,54850.932059347164,61179.885758502613,65399.18822460626,67508.839457658076]
["Gfast rentals",null,"One",null,{"$f":"E5*Gfast_ratio","v":0},6065.7942134573523,18197.382640372056,36394.765280744119,60657.942134573517,84921.118988402915,109184.29584223233,133447.47269606174,157710.6495498911,175908.03219026318,188039.62061717792,194105.41483063527]
[]
["Change in GEA rentals"]
["FTTC rentals",null,"One",null,{"$f":"E6-D6","v":0},{"$f":"F6-E6","v":17500.778406685971},35001.556813371935,52502.335220057925,70003.113626743856,70003.113626743841,70003.1136267439,70003.1136267439,70003.113626743725,52502.335220057983,35001.556813372008,17500.778406686033]
["FTTP rentals",null,"One",null,{"$f":"E7-D7","v":0},{"$f":"F7-E7","v":2109.6512330518149},4219.3024661036288,6328.953699155446,8438.6049322072577,8438.604932207254,8438.6049322072613,8438.6049322072577,8438.6049322072431,6328.9536991554487,4219.302466103647,2109.6512330518162]
["Gfast rentals",null,"One",null,{"$f":"E8-D8","v":0},6065.7942134573523,12131.588426914703,18197.382640372063,24263.176853829398,24263.176853829398,24263.176853829413,24263.176853829413,24263.176853829355,18197.382640372089,12131.588426914735,6065.7942134573532]
[]
["GEA Connections"]
["FTTC connections",null,"One",null,{"$f":"E11+E49","v":0},18900.840679220848,39201.743630976569,60902.708855267192,84003.73635209263,89603.985442232122,95204.234532371687,100804.48362251121,106404.73271265053,93104.141123569425,78403.487261953211,62302.771127802123]
["FTTP connections",null,"One",null,{"$f":"E12+E50","v":0},2278.4233316959599,4725.6187620360643,7341.5862910203168,10126.32591864871,10801.414313225287,11476.502707801874,12151.591102378452,12826.679496955017,11223.344559835657,9451.2375240721485,7510.3583896644623]
["Gfast connections",null,"One",null,{"$f":"E13+E51","v":0},6551.0577505339406,13587.379038144467,21108.963862831592,29115.81222459528,31056.866372901633,32997.920521207998,34938.974669514355,36880.028817820639,32270.025215593145,27174.75807628897,21594.227399908174]
[]
[]
["FTTC Engineer install (%)",null,"%",null,{"$f":"'WLA inputs'!J67","v":5.6309334890082337E-2},{"$f":"'WLA inputs'!K67","v":3.4203925672277764E-2},{"$f":"'WLA inputs'!L67","v":2.3366670705171299E-2},{"$f":"'WLA inputs'!M67","v":1.8019744181228644E-2},{"$f":"'WLA inputs'!N67","v":1.528405853947323E-2},{"$f":"'WLA inputs'!O67","v":1.2863579552396276E-2},{"$f":"'WLA inputs'!P67","v":1.1437460982188367E-2},{"$f":"'WLA inputs'!Q67","v":1.0497123299320102E-2},{"$f":"'WLA inputs'!R67","v":9.7446377285028141E-3},{"$f":"'WLA inputs'!S67","v":9.2280891552333506E-3},{"$f":"'WLA inputs'!T67","v":8.8334231961161355E-3},{"$f":"'WLA inputs'!U67","v":8.9312448836429657E-3}]
["FTTP Engineer install (%)",null,"%",null,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98]
["Gfast Engineer install (%)",null,"%",null,{"$f":"'WLA inputs'!J67","v":5.6309334890082337E-2},{"$f":"'WLA inputs'!K67","v":3.4203925672277764E-2},{"$f":"'WLA inputs'!L67","v":2.3366670705171299E-2},{"$f":"'WLA inputs'!M67","v":1.8019744181228644E-2},{"$f":"'WLA inputs'!N67","v":1.528405853947323E-2},{"$f":"'WLA inputs'!O67","v":1.2863579552396276E-2},{"$f":"'WLA inputs'!P67","v":1.1437460982188367E-2},{"$f":"'WLA inputs'!Q67","v":1.0497123299320102E-2},{"$f":"'WLA inputs'!R67","v":9.7446377285028141E-3},{"$f":"'WLA inputs'!S67","v":9.2280891552333506E-3},{"$f":"'WLA inputs'!T67","v":8.8334231961161355E-3},{"$f":"'WLA inputs'!U67","v":8.9312448836429657E-3}]
[]
["FTTC Engineer install",null,"One",null,{"$f":"E21*E16","v":0},{"$f":"F21*F16","v":646.48294973563384},916.01423449357571,1097.4512335157631,1283.918023939859,1152.6279949479108,1088.8947178031115,1058.157093709794,1036.8755728829519,859.17331500972648,692.57118303613345,556.44130587196139]
["FTTP Engineer install",null,"One",null,{"$f":"E22*E17","v":0},{"$f":"F22*F17","v":2232.8548650620405},4631.1063867953426,7194.7545651999108,9923.799400275735,10585.386026960781,11246.972653645837,11908.559280330883,12570.145907015916,10998.877668638945,9262.2127735907052,7360.1512218711732]
["Gfast Engineer install",null,"One",null,{"$f":"E23*E18","v":0},{"$f":"F23*F18","v":224.07189237406209},317.49181173066887,380.37812873902527,445.00777846502456,399.50247123596097,377.41242845466928,366.758725057714,359.38252024640605,297.79066973112185,240.04613833993528,192.8633329816526]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer_install_vols"]
[]
["FTTC PCP only (%)",null,"%",null,{"$f":"'WLA inputs'!J66","v":0.92090152264646297},{"$f":"'WLA inputs'!K66","v":0.94288906564580655},{"$f":"'WLA inputs'!L66","v":0.95362034281840957},{"$f":"'WLA inputs'!M66","v":0.95895368864673403},{"$f":"'WLA inputs'!N66","v":0.96171950164346987},{"$f":"'WLA inputs'!O66","v":0.96413039182629201},{"$f":"'WLA inputs'!P66","v":0.9655726695581105},{"$f":"'WLA inputs'!Q66","v":0.96653633498664848},{"$f":"'WLA inputs'!R66","v":0.96730601084877521},{"$f":"'WLA inputs'!S66","v":0.96784443555794386},{"$f":"'WLA inputs'!T66","v":0.96825955018767662},{"$f":"'WLA inputs'!U66","v":0.9682222022276129}]
["FTTP PCP only (%)",null,"%",null,0,0,0,0,0,0,0,0,0,0,0,0]
["Gfast PCP only (%)",null,"%",null,{"$f":"'WLA inputs'!J66","v":0.92090152264646297},{"$f":"'WLA inputs'!K66","v":0.94288906564580655},{"$f":"'WLA inputs'!L66","v":0.95362034281840957},{"$f":"'WLA inputs'!M66","v":0.95895368864673403},{"$f":"'WLA inputs'!N66","v":0.96171950164346987},{"$f":"'WLA inputs'!O66","v":0.96413039182629201},{"$f":"'WLA inputs'!P66","v":0.9655726695581105},{"$f":"'WLA inputs'!Q66","v":0.96653633498664848},{"$f":"'WLA inputs'!R66","v":0.96730601084877521},{"$f":"'WLA inputs'!S66","v":0.96784443555794386},{"$f":"'WLA inputs'!T66","v":0.96825955018767662},{"$f":"'WLA inputs'!U66","v":0.9682222022276129}]
[]
["FTTC PCP only",null,"One",null,{"$f":"E16*E30","v":0},{"$f":"F16*F30","v":17821.396007950796},37383.580200451281,58402.877305336588,80788.031460723956,86389.925593616616,91926.606890658586,97431.196150723612,102925.93753570416,90110.324913848206,75914.925309404047,60322.926266243507]
["FTTP PCP only",null,"One",null,{"$f":"E17*E31","v":0},{"$f":"F17*F31","v":0},0,0,0,0,0,0,0,0,0,0]
["Gfast PCP only",null,"One",null,{"$f":"E18*E32","v":0},{"$f":"F18*F32","v":6176.9207213926666},12957.201056358999,20242.518759772967,28001.244422582622,29942.868745002444,31861.890207529163,33769.78852526375,35674.273555753956,31232.364340226362,26312.21903140649,20908.010408542952]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCP_only_vols"]
[]
["FTTC Start of Stopped line (%)",null,"%",null,{"$f":"1-E21-E30","v":2.2789142463454648E-2},2.2907008681915642E-2,2.3012986476419139E-2,2.3026567172037327E-2,2.2996439817056902E-2,2.3006028621311736E-2,2.2989869459701162E-2,2.2966541714031452E-2,2.294935142272192E-2,2.2927475286822818E-2,2.2907026616207249E-2,2.2846552888744154E-2]
["FTTP Start of Stopped line (%)",null,"%",null,{"$f":"1-E22-E31","v":2.0000000000000018E-2},2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
["Gfast Start of Stopped line (%)",null,"%",null,{"$f":"1-E23-E32","v":2.2789142463454648E-2},2.2907008681915642E-2,2.3012986476419139E-2,2.3026567172037327E-2,2.2996439817056902E-2,2.3006028621311736E-2,2.2989869459701162E-2,2.2966541714031452E-2,2.294935142272192E-2,2.2927475286822818E-2,2.2907026616207249E-2,2.2846552888744154E-2]
[]
["FTTC Start of Stopped line",null,"One",null,{"$f":"E16*E39","v":0},432.96172153441631,902.14919603171393,1402.3803164148426,1931.7868674288131,2061.4318536675923,2188.7329239099986,2315.1303780778039,2441.919604063412,2134.6428947115019,1795.9907695130282,1423.4035556866534]
["FTTP Start of Stopped line",null,"One",null,{"$f":"E17*E40","v":0},45.568466633919236,94.512375240721369,146.83172582040646,202.52651837297438,216.02828626450594,229.53005415603769,243.03182204756925,256.53358993910058,224.46689119671336,189.02475048144314,150.20716779328939]
["Gfast Start of Stopped line",null,"One",null,{"$f":"E18*E41","v":0},150.06513676721173,312.6861700547995,486.06697431960015,669.56002354763496,714.49515666322895,758.617885224166,802.42741919288972,846.3727418202775,739.87020563566102,622.49290654254435,493.35365838357023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start_stopped_lines_vols"]
["GEA Ceases"]
[]
["FTTC Ceases",null,"One",null,{"$f":"E6:P6*Cease_ratio","v":0},1400.0622725348778,4200.1868176046328,8400.3736352092674,14000.622725348776,19600.871815488284,25201.120905627795,30801.369995767309,36401.619085906808,40601.805903511442,43401.930448581203,44801.99272111609]
["FTTP Ceases",null,"One",null,{"$f":"E7:P7*Cease_ratio","v":0},168.77209864414519,506.31629593243554,1012.6325918648712,1687.7209864414519,2362.8093810180321,3037.897775594613,3712.9861701711939,4388.0745647477734,4894.3908606802088,5231.9350579685006,5400.707156612646]
["Gfast Ceases",null,"One",null,{"$f":"E8:P8*Cease_ratio","v":0},485.26353707658819,1455.7906112297644,2911.5812224595297,4852.6353707658818,6793.6895190722335,8734.7436673785869,10675.79781568494,12616.851963991288,14072.642575221054,15043.169649374235,15528.433186450822]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ceases_vols"]
["Bandwidth Change"]
[]
["FTTC Bandwidth Change",null,"One",null,{"$f":"E6:P6*Bandwidth_change_ratio","v":0},2625.1167610028956,7875.3502830086863,15750.700566017375,26251.167610028951,36751.634654040528,47252.101698052116,57752.568742063697,68253.035786075256,76128.38606908395,81378.619591089751,84003.736352092659]
["FTTP Bandwidth Change",null,"One",null,{"$f":"E7:P7*Bandwidth_change_ratio","v":0},316.4476849577722,949.34305487331653,1898.6861097466335,3164.4768495777221,4430.2675894088097,5696.0583292398996,6961.8490690709878,8227.6398089020749,9176.9828637753908,9809.8782336909389,10126.32591864871]
["Gfast Bandwidth Change",null,"One",null,{"$f":"E8:P8*Bandwidth_change_ratio","v":0},909.86913201860284,2729.6073960558083,5459.2147921116175,9098.691320186028,12738.167848260437,16377.644376334849,20017.120904409261,23656.597432483664,26386.204828539478,28205.943092576686,29115.812224595291]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bandwidth_change_vols"]
["Migrations"]
["FTTC Migrations",null,"One",null,{"$f":"E6:P6*Migration_ratio","v":0},1225.054488468018,3675.163465404054,7350.326930808109,12250.544884680179,17150.762838552248,22050.980792424321,26951.198746296395,31851.416700168458,35526.580165572515,37976.689142508556,39201.743630976576]
["FTTP Migrations",null,"One",null,{"$f":"E7:P7*Migration_ratio","v":0},147.67558631362706,443.02675894088111,886.05351788176245,1476.7558631362706,2067.4582083907785,2658.1605536452867,3248.8628988997948,3839.565244154302,4282.5920030951829,4577.9431757224384,4725.6187620360661]
["Gfast Migrations",null,"One",null,{"$f":"E8:P8*Migration_ratio","v":0},424.6055949420147,1273.8167848260441,2547.6335696520887,4246.055949420147,5944.478329188205,7642.9007089562638,9341.3230887243226,11039.745468492378,12313.562253318423,13162.773443202455,13587.379038144471]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Migrations_vols"]
["Totals"]
["Engineer install",null,"One",null,{"$f":"E25+E27","v":0},870.55484210969598,1233.5060462242445,1477.8293622547883,1728.9258024048836,1552.1304661838717,1466.3071462577807,1424.915818767508,1396.258093129358,1156.9639847408484,932.61732137606873,749.30463885361405]
["FTTP Engineer install",null,"One",null,{"$f":"E17","v":0},2278.4233316959599,4725.6187620360643,7341.5862910203168,10126.32591864871,10801.414313225287,11476.502707801874,12151.591102378452,12826.679496955017,11223.344559835657,9451.2375240721485,7510.3583896644623]
["PCP only",null,"One",null,{"$f":"SUM(E34:E36)","v":0},23998.316729343464,50340.781256810282,78645.396065109555,108789.27588330657,116332.79433861906,123788.49709818774,131200.98467598736,138600.2110914581,121342.68925407456,102227.14434081054,81230.936674786455]
["Start of Stopped line",null,"One",null,{"$f":"SUM(E43:E45)","v":0},{"$f":"SUM(F43:F45)","v":628.5953249355473},1309.3477413272349,2035.2790165548492,2803.8734093494227,2991.9552965953271,3176.8808632902023,3360.589619318263,3544.8259358227901,3098.9799915438762,2607.5084265370156,2066.9643818635132]
["GEA Ceases",null,"One",null,{"$f":"SUM(E49:E51)","v":0},{"$f":"SUM(F49:F51)","v":2054.0979082556114},6162.2937247668324,12324.587449533668,20540.97908255611,28757.370715578552,36973.762348600998,45190.153981623444,53406.545614645875,59568.839339412705,63677.035155923935,65731.133064179565]
["Bandwidth Change",null,"One",null,{"$f":"SUM(E55:E57)","v":0},{"$f":"SUM(F55:F57)","v":3851.4335779792709},11554.300733937811,23108.601467875626,38514.335779792702,53920.070091709771,69325.804403626869,84731.538715543953,100137.27302746099,111691.57376139882,119394.44091735737,123245.87449533667]
["Migrations",null,"One",null,{"$f":"SUM(E60:E62)","v":0},{"$f":"SUM(F60:F62)","v":1797.3356697236597},5392.0070091709786,10784.014018341961,17973.356697236595,25162.69937613123,32352.042055025871,39541.384733920509,46730.72741281514,52122.734421986119,55717.405761433445,57514.741431157112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ancillary_vols"]

{"sheet":"Indirect benefits","index":14,"n_rows":88,"n_cols":19,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
["Indirect benefits",null,null,null,"Units",null,"2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27","2027/28","2028/29"]
[]
[]
[null,"GEA rentals"]
[]
[null,null,"Non-SFBB areas"]
[]
[null,null,null,"UBC volumes"]
[null,null,null,"40/2 mgbit/s ","One",null,{"$f":"'Non-SFBB areas'!G31:R34*million","v":0},1139.593275808729,2199.9127214977375,2301.4538724708905,1560.3372545129303,-371.54665448751848,-3065.0435630348211,-6067.2715464719431,-9338.7491168960169,-12293.673245315531,-14680.063799764685,-16399.057035026843]
[null,null,null,"40/10 mgbit/s","One",null,0,9333.5256884834398,31465.199890618307,69006.549585732384,123981.96220545296,183042.14057934872,245736.18260583546,310932.95708928874,377640.31624858256,430735.47146716336,468892.44761178753,491246.04923181672]
[null,null,null,"55/10 mgbit/s","One",null,0,8053.0647862649148,22462.128698665078,41838.084913897517,64672.06938929412,85463.392727259357,104185.94124049145,121403.88055546132,137835.49705885755,148413.27388539014,153895.11915023727,154800.10059362132]
[null,null,null,"80/20 mgbit/s","One",null,0,7150.040102638055,20901.430248804289,40911.254747070023,66547.869682691322,91333.147292611247,115314.94907422033,138607.35867201485,161444.75599252924,177755.41963542081,187855.43648678903,191992.07051183321]
[]
[null,null,null,"Expected unit prices"]
[null,null,null,"40/2 mgbit/s ","One",null,{"$f":"GEA_rental_prices","v":82.8},60.614140136673392,51.617739631570203,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042]
[null,null,null,"40/10 mgbit/s","One",null,88.8,65.006469132084504,55.358155546901372,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304]
[null,null,null,"55/10 mgbit/s","One",null,100.8,73.79112712290673,62.838987377563718,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828]
[null,null,null,"80/20 mgbit/s","One",null,119.4,87.407347008681199,74.434276715090363,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951]
[]
[null,null,null,"Incremental revenue"]
[null,null,null,"40/2 mgbit/s ","One",null,{"$f":"G10:R13*G16:R19","v":0},69075.466518680987,113554.52207044922,109166.85882166248,74012.831113019827,-17623.894904551456,-145386.87128620685,-287794.15667161933,-442972.99138156307,-583136.47195985005,-696332.20612905396,-777870.70406461507]
[null,null,null,"40/10 mgbit/s","One",null,0,606739.5495619165,1741855.4298591923,3510439.4046610664,6307099.3725385219,9311555.8865170367,12500871.05860557,15817502.995392568,19210980.043288324,21911989.240166627,23853076.766277272,24990229.1733188]
[null,null,null,"55/10 mgbit/s","One",null,0,594244.72737227799,1411497.4217686267,2415964.4056970659,3734526.0426918999,4935133.0311627621,6016277.4211365022,7010537.2829353288,7959390.4792986037,8570210.3186125476,8886762.643238917,8939021.3199812155]
[null,null,null,"80/20 mgbit/s","One",null,0,624966.03637727106,1555782.8428806583,2798371.239853391,4551941.6538279578,6247279.7329014037,7887659.2519462444,9480883.6477348227,11042984.743140833,12158650.647874761,12849502.024925902,13132451.979823379]
[]
[null,null,"SFBB areas"]
[]
[null,null,null,"UBC volumes"]
[null,null,null,"40/2 mgbit/s ","One",null,{"$f":"'SFBB areas '!G36:R39*million","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"40/10 mgbit/s","One",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"55/10 mgbit/s","One",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"80/20 mgbit/s","One",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Expected unit prices"]
[null,null,null,"40/2 mgbit/s ","One",null,{"$f":"GEA_rental_prices","v":82.8},60.614140136673392,51.617739631570203,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042,47.433867837837042]
[null,null,null,"40/10 mgbit/s","One",null,88.8,65.006469132084504,55.358155546901372,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304,50.871104637680304]
[null,null,null,"55/10 mgbit/s","One",null,100.8,73.79112712290673,62.838987377563718,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828,57.745578237366828]
[null,null,null,"80/20 mgbit/s","One",null,119.4,87.407347008681199,74.434276715090363,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951,68.401012316880951]
[]
[null,null,null,"Incremental revenue"]
[null,null,null,"40/2 mgbit/s ","One",null,{"$f":"G30:R33*G36:R39","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"40/10 mgbit/s","One",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"55/10 mgbit/s","One",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"80/20 mgbit/s","One",null,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"GEA ancillary services"]
[]
[null,null,null,"UBC volumes"]
[null,null,null,"Engineer install","One",null,{"$f":"Ancillary_vols","v":0},870.55484210969598,1233.5060462242445,1477.8293622547883,1728.9258024048836,1552.1304661838717,1466.3071462577807,1424.915818767508,1396.258093129358,1156.9639847408484,932.61732137606873,749.30463885361405]
[null,null,null,"FTTP Engineer install","One",null,0,2278.4233316959599,4725.6187620360643,7341.5862910203168,10126.32591864871,10801.414313225287,11476.502707801874,12151.591102378452,12826.679496955017,11223.344559835657,9451.2375240721485,7510.3583896644623]
[null,null,null,"PCP only","One",null,0,23998.316729343464,50340.781256810282,78645.396065109555,108789.27588330657,116332.79433861906,123788.49709818774,131200.98467598736,138600.2110914581,121342.68925407456,102227.14434081054,81230.936674786455]
[null,null,null,"Start of Stopped line","One",null,0,628.5953249355473,1309.3477413272349,2035.2790165548492,2803.8734093494227,2991.9552965953271,3176.8808632902023,3360.589619318263,3544.8259358227901,3098.9799915438762,2607.5084265370156,2066.9643818635132]
[null,null,null,"GEA Ceases","One",null,0,2054.0979082556114,6162.2937247668324,12324.587449533668,20540.97908255611,28757.370715578552,36973.762348600998,45190.153981623444,53406.545614645875,59568.839339412705,63677.035155923935,65731.133064179565]
[null,null,null,"Bandwidth Change","One",null,0,3851.4335779792709,11554.300733937811,23108.601467875626,38514.335779792702,53920.070091709771,69325.804403626869,84731.538715543953,100137.27302746099,111691.57376139882,119394.44091735737,123245.87449533667]
[null,null,null,"Migrations","One",null,0,1797.3356697236597,5392.0070091709786,10784.014018341961,17973.356697236595,25162.69937613123,32352.042055025871,39541.384733920509,46730.72741281514,52122.734421986119,55717.405761433445,57514.741431157112]
[]
[null,null,null,"Expected unit prices"]
[null,null,null,"Engineer install","One",null,{"$f":"GEA_ancillary_prices","v":99},90,81.239021822666729,83.757478076317142,86.353695997845563,89.030773026199427,91.790930289370564,94.636542883787996,97.569886190331914,100.59473032037326,103.71359548816748,106.92848633306981]
[null,null,null,"FTTP Engineer install","One",null,117,117,117,117,117,117,117,117,117,117,117,117]
[null,null,null,"PCP only","One",null,49,47.482736119788846,46.5507981923557,47.479447352442676,49.759732628550481,50.0582646029195,52.532164481871007,54.330471977941954,55.386939786987867,56.616899868078569,58.502889171737124,60.315468163962692]
[null,null,null,"Start of Stopped line","One",null,32.520000000000003,7.0823060625811793,3.2766254281139315,3.3782004540021062,3.4829721641818874,3.5909443298225461,3.7022638505850671,3.8170340094786921,3.9353618473533016,4.0573581193108188,4.1831363555708334,4.3128133724289022]
[null,null,null,"GEA Ceases","One",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Bandwidth Change","One",null,11.25,9.1129874710207002,8.1652478989028516,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731,8.2070871351993731]
[null,null,null,"Migrations","One",null,11,4.9260321672985148,3.2766563084048643,3.3782322915786422,3.4829721641818874,3.5909443298225461,3.7022638505850671,3.8170340094786921,3.9353618473533016,4.0573581193108188,4.1831363555708334,4.3128133724289022]
[]
[null,null,null,"Incremental revenue"]
[null,null,null,"Engineer install","One",null,{"$f":"G51:R57*G60:R66","v":0},78349.935789872645,100208.82460760276,123779.26040959317,149299.13314370252,138187.37524186537,134593.69704495385,134849.10698857915,136232.74323896132,116384.48003539009,96725.095614455888,80122.010834964487]
[null,null,null,"FTTP Engineer install","One",null,0,266575.52980842732,552897.3951582195,858965.59604937711,1184780.1324818991,1263765.4746473585,1342750.8168128193,1421736.158978279,1500721.501143737,1313131.313500772,1105794.7903164413,878711.93159074208]
[null,null,null,"PCP only","One",null,0,1139505.7405785299,2343403.549131298,3734039.9419853715,5413325.2808069503,5823417.8009996088,6502877.69052561,7128211.4214171227,7676641.5461863978,6870046.8872213131,5980583.2957136128,4899481.9749369519]
[null,null,null,"Start of Stopped line","One",null,0,4451.9044807012133,4290.2421034763602,6875.5804977465523,9765.8130366538062,10743.944907391524,11761.651177774796,12827.484868838861,13950.172743345473,12573.671630272318,10907.56329650429,8914.4316264352001]
[null,null,null,"GEA Ceases","One",null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Bandwidth Change","One",null,0,35098.065941593522,94343.729791077392,189654.3058194514,316090.50969908561,442526.71357871976,568962.91745835415,695399.12133798841,821835.32521762233,916662.47812734812,979880.58006716531,1011489.6310370741]
[null,null,null,"Migrations","One",null,0,8853.7333244917663,17667.753781563333,36430.904389599564,62600.701073387165,90357.852647747757,119775.7957929301,150930.81031125615,183902.32175945977,211480.59970772688,233073.50567874406,248050.34595608502]
[]
[]
[null,"All Services"]
[]
[null,null,null,"Incremental revenue"]
[null,null,null,"GEA rental","One",null,{"$f":"SUM(G22:G25,G42:G45)","v":0},{"$f":"SUM(H22:H25,H42:H45)","v":1895025.7798301466},4822690.2165789269,8833941.9090331867,14667579.900171399,20476344.75567665,26259420.860402111,32021129.769391097,37770382.274346195,42057713.734694079,44893009.228313036,46283831.769058779]
[null,null,null,"GEA ancillary services","One",null,{"$f":"SUM(G69:G75)","v":0},{"$f":"SUM(H69:H75)","v":1532834.9099236166},3112811.4945732374,4949745.5891511394,7135861.5702416785,7768999.1620226912,8680722.5688124429,9543954.1039020661,10333283.610289523,9440279.4302228224,8406964.8306869231,7126770.3259822531]
[]
[null,null,null,"Total","One",null,{"$f":"SUM(G81:G82)*(1+Revenue_uplift)","v":0},3427860.6897537634,7935501.7111521643,13783687.498184327,21803441.470413078,28245343.917699341,34940143.429214552,41565083.873293161,48103665.884635717,51497993.164916903,53299974.058999956,53410602.095041029,"Incremental_revenue"]
[]
[null,null,null,"Incremental rental revenue"]
[null,null,null,"Non-SFBB areas","%",{"$f":"J87","v":1},{"$f":"IF(G81=0,\"\",SUM(G22:G25)/G81)","v":""},{"$f":"IF(H81=0,\"\",SUM(H22:H25)/H81)","v":1},1,1,1,1,1,1,1,1,1,1]
[null,null,null,"SFBB areas","%",{"$f":"J88","v":0},{"$f":"IF(G81=0,\"\",1-G87)","v":""},{"$f":"IF(H81=0,\"\",1-H87)","v":0},0,0,0,0,0,0,0,0,0,0]