{"text_format":"1","workbook":"xlsx","n_sheets":37,"sheets":["Contents","Quality Assurance","Ctrl_sheet","Volumes-->","Vol_Consumer","Vol_Consumer_BB_tiers","Vol_acquisition","TV_BB_tiers","Vol_weights","Costs-->","Marketing","Customer_services","Affiliates","Development","Bandwidth_costs","Platform","Telesales","Calls","Line_acquisition","TV","CPE","TSO","MA_data","SG&A_&_MA_calc","BT_Sport","Wholesale_charges","Revenues and WACC-->","Prices","Line_rental","Usage_charges","WACC","Results-->","Ongoing_revenues","Ongoing_costs","Monthly_margin","Upfront_costs","DCF_analysis"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":2,"defined_names":23,"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":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"BT VULA margin model - Final statement"]
[]
["Information"]
[]
["Title ",{"$f":"G2","v":"BT VULA margin model - Final statement"}]
["Project case code","-"]
["Objective"]
["Version"]
["Status","Approved for release"]
["Author","Ofcom"]
["Spreadsheet Location","\\\\GDRIVE\\Projects\\CW-01103 CA98 Superfast Broadband\\Ofcom work\\Main model\\Confidential versions\\BT VULA margin model - final statement NON CONF.xlsm"]
[]
["Confidentiality status","Non confidential version"]
[]
["Do you want?",false]
[null,false]
[null,false]
[]
["Contents"]
[]
["Sheet","Description"]
[]
["Sheet key:"]
[]
[null,"Volume input sheets"]
[null,"Cost input sheets"]
[null,"Other input sheets"]
[null,"Calculation sheets"]
[null,"Cost and revenue stack sheets"]
[null,"Control sheet and results"]
[]
["Sheet summary:"]
["Ctrl_sheet","Selects options for carrying out the test, e.g. output increment and time period for costs"]
[]
["Volumes"]
["Vol_Consumer","contains acquisition and base volumes of the main products sold by BT Consumer - Voice, BB and TV."]
["Vol_Consumer_BB_tiers","contains acquisition and base volumes for SFBB and SBB products sold by BT Consumer (does not include Plusnet)."]
["Vol_acquisition","contains acquisition volumes of the main products sold by BT Consumer - Voice, BB and TV."]
["TV_BB_tiers","contains base volumes for SFBB customers taking BT TV split out by product tier."]
["Vol_weights","collects Q3 2013/14 SFBB product tier volume data and calculates the weightings to apply to the portfolio."]
[]
["Costs"]
["Marketing","contains the totals for each category of marketing spend in 2012/13. Upfront customer acquisition costs are allocated to SFBB customers in this worksheet. Ongoing costs are linked to \"MA_data\" sheet."]
["Customer_services","This worksheet contains the totals of each category of customer services costs in 2012/13. Costs per SFBB subscriber are calculated for [Customer service ongoing - type 1]. All other customer service costs linked to MA_data sheet."]
["Affiliates","collects the total online advertising spend on broadband, calls and TV as calculated in the \"Pay per click\" file and allocates to SFBB on the basis of acquisition volumes"]
["Development","contains the break-down of development spend into different activities. These activities are categorised into broadband (BB), voice, TV and other and a proportion of these costs are allocated to SFBB."]
["Bandwidth_costs","Calculates 2013/14 network costs on the basis of RFS cost data and actual peak throughput per user data"]
["Platform","allocates 2012/13 platform costs to individual products based on share of total throughput"]
["Telesales","collects 2012/13 data from BT's Total Labour Cost system on telesales spend broken down by activities. This sheet allocates telesales costs to different product lines on the basis of call handling times."]
["Calls","collects cost and revenue information on BT calls packages bundled with Infinity as recorded in BT's calls database."]
["Line_acquisition","collects data on customer acquisitions and costs of different kinds of acquisitions (e.g. new lines, takeovers from other CPs) and calculates the average SFBB line acquisition cost."]
["TV","summarises TV costs and revenues provided by BT and selects the relevant data for inclusion in the SFBB portfolio cost stack."]
["CPE","calculates cost of Home Hub per SFBB subscriber"]
["TSO","collects TSO spend in 2012/13 broken down into different activities and cost types (e.g. direct, indirect and fixed)."]
["MA_data","consolidates all relevant data from the BT Consumer management accounts. It also assigns different characteristics to each line item for the purpose of allocating to the SFBB portfolio."]
["SG&A_&_MA_calc","allocates a proportion of BT Consumer SG&A costs and other costs captured in the management accounts to the SFBB portfolio and calculates unit cost"]
["BT_Sport","calculates monthly net costs of BT Sport per BT Infinity subscriber."]
["Wholesale_charges","collects Openreach charges for wholesale inputs (e.g. GEA, WLR/MPF) and calculates per SFBB customer cost."]
[]
["Revenues and WACC"]
["Prices","collects pricing information on Infinity and Plusnet products and selects the relevant data for inclusion in the test."]
["Line_rental","collects data on line rental volumes and prices and calculates the average discount per customer resulting from Line Rental Saver."]
["Usage_charges","collects monthly usage revenues and customer bases for Infinity 1, as provided by BT, and calculates an average usage revenue per SFBB customer. "]
["WACC","selects the WACC rate to use to discount ongoing margins. "]
[]
["Results"]
["Ongoing_revenues","Ongoing revenues stack"]
["Ongoing_costs","Ongoing costs stack"]
["Monthly_margin","Summarises monthly margins for different output increments"]
["Upfront_costs","Upfront cost stack"]
["DCF_analysis","Calculates the margin squeeze test on the basis of customer lifetime approach"]
[]
[]
["Cell key:"]
[]
["Input cells"]
["Confidential data - will be redacted"]
["External link"]
["Manual input"]
["Option selection"]
["Link to BT model"]
["Direct link to input"]
[]
["Calculation cells"]
["Calculation (linked to in-model cells)"]
["Calculation total"]
["Summary calculation (linked to in-model cells)"]
["Summary calculation (linked to triple-play specific workings)"]
["Summary total"]
[]
["Output cells"]
["Calculation total, linked to another input or calculation sheet"]
["Calculation total, linked to output sheet"]
["Model result"]
[]
[]
["Terms and conditions"]
["The terms and conditions on which OFCOM is making available the model are set out below.  "]
[]
["The BT VULA margin model does not form part of our draft decision but has been developed to help understand the profitability of BT's SFBB offers in January 2015, for the purpose of the VULA margin regulation."]
["Although the scope and flexibility of the model are wider than this (for example, it contains copper broadband volumes), the aim has been to extend the scope only to the extent necessary to better understand the costs and revenues of providing SFBB services."]
[]
["All right, title and interest in the provided model (the ‘Model’) constructed in Excel to understand the profitability of its SFBB offers in January 2015 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, 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":"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":"Ctrl_sheet","index":2,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Control sheet"]
[]
["Test options"]
[null,null,null,null,null,"Summary"]
[null,"Select bundles to include in test","Total mix (dual-play and triple-play)",null,null,null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
[null,null,null,null,null,"Upfront costs",{"$f":"DCF_analysis!C7","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!D7","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!E7","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!F7","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!G7","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!H7","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Monthly margin up to \"months",{"$f":"DCF_analysis!C8","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!D8","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!E8","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!F8","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!G8","v":0},{"$f":"DCF_analysis!H8","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Monthly margin after \"months",{"$f":"DCF_analysis!C9","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!D9","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!E9","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!F9","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!G9","v":0},{"$f":"DCF_analysis!H9","v":{"$error":"#VALUE!"}}]
["Inputs/assumptions"]
["Volumes",null,null,null,null,"Payback period (years)",{"$f":"DCF_analysis!C11","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!D11","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!E11","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!F11","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!G11","v":{"$error":"#VALUE!"}},{"$f":"DCF_analysis!H11","v":{"$error":"#VALUE!"}}]
[null,"Select type of volumes to weight the portfolio","Quarterly acquisitions"]
[]
[]
["SG&A and management account calculations"]
[null,"Approach for allocating long-run variable & fixed costs","Revenues"]
[null,"Short-run variable CVE",1]
[null,"Long-run variable CVE",1]
[null,"Fixed CVE",1]
[]
[]
["TV"]
[null,"Select year","Mix"]
[null,"Assumed point in ACL when TV take-up reduces (months)","Removed"]
[null,"Reduction in customer take-up","Removed"]
[]
[]
["Usage charges"]
[null,"Select time period","From beginning of 2013/14"]
[]
[]
["WACC"]
[null,"Discount rate","2014 WBA - Nominal"]

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

{"sheet":"Vol_Consumer","index":4,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[5,3,5,7],[5,9,5,11]]}
["BT Consumer volumes"]
[{"$f":"\"This worksheet \"&Contents!B37","v":"This worksheet contains acquisition and base volumes of the main products sold by BT Consumer - Voice, BB and TV."}]
["Source: S26 volumes received 3rd Oct 2013 and 21st Feb 2014"]
[]
["Units - customers 000s"]
[null,null,null,"12/13",null,null,null,null,null,"13/14"]
[null,null,null,"Q1","Q2","Q3","Q4","FY",null,"Q1 Actual","Q2","Q3"]
[]
[null,"Voice Active (k)"]
[]
[null,"Opening Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Acquisitions",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Churn",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Net Active",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Closing Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[]
[]
[null,"Voice Lines (k)"]
[]
[null,"Opening Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Acquisitions",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Churn",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Net Lines",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Closing Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[]
[]
[null,"Broadband (k)"]
[]
[null,"Opening Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Installs",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Churn",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Net Adds",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Closing Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[]
[]
[null,"TV (k)"]
[]
[null,"Opening Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Installs",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Churn",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Net Adds",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Closing Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[]
[]
[null,"Fibre Total (k)"]
[]
[null,"Opening Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Installs",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Regrades",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Churn",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Net Adds",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,"Closing Base",null,"Removed","Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[]
[]
[]
[null,"Number of copper acquisitions",null,{"$f":"D30-(D48+D49)","v":{"$error":"#VALUE!"}},{"$f":"E30-(E48+E49)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Vol_Consumer_BB_tiers","index":5,"n_rows":124,"n_cols":11,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
["BT Infinity fibre volumes"]
[{"$f":"\"This worksheet \"&Contents!B38","v":"This worksheet contains acquisition and base volumes for SFBB and SBB products sold by BT Consumer (does not include Plusnet)."}]
["Units - customers"]
["Product tier","BB type",null,"Q1 2012/13","Q2 2012/13","Q3 2012/13","Q4 2012/13",null,"Q1 2013/14","Q2 2013/14","Q3 2013/14"]
["Customer Base"]
["Infinity Trial","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 3","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 4","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["20GB BT Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Legacy","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband Option 1","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband Option 2","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband Option 3","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband Option 4","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Broadband","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Broadband Extra","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Others","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,null,null,{"$f":"SUM(D6:D22)","v":0},{"$f":"SUM(E6:E22)","v":0},{"$f":"SUM(F6:F22)","v":0},{"$f":"SUM(G6:G22)","v":0},null,{"$f":"SUM(I6:I22)","v":0},{"$f":"SUM(J6:J22)","v":0},{"$f":"SUM(K6:K22)","v":0}]
[]
["New subscribers"]
["Infinity Trial","Fibre",null,{"$f":"D37+D71+D93","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"I37+I71+I93","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Infinity 1","Fibre",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Infinity 2","Fibre",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Infinity 3","Fibre",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Infinity 4","Fibre",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unlimited Infinity 1","Fibre",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unlimited Infinity 2","Fibre",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["20GB BT Infinity 1","Fibre",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$f":"SUM(D26:D33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E26:E33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(F26:F33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(G26:G33)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(I26:I33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J26:J33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(K26:K33)","v":{"$error":"#VALUE!"}}]
[]
["Closed Copper to Infinity Regrades"]
["Infinity Trial","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 3","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 4","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["20GB BT Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,null,null,{"$f":"SUM(D37:D44)","v":0},{"$f":"SUM(E37:E44)","v":0},{"$f":"SUM(F37:F44)","v":0},{"$f":"SUM(G37:G44)","v":0},null,{"$f":"SUM(I37:I44)","v":0},{"$f":"SUM(J37:J44)","v":0},{"$f":"SUM(K37:K44)","v":0}]
[]
["Infinity to Copper Regrades"]
["Legacy","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband Option 1","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband Option 2","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband Option 3","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Broadband Option 4","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Broadband","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Broadband Extra","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Others","Copper",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,null,null,{"$f":"SUM(D48:D56)","v":0},{"$f":"SUM(E48:E56)","v":0},0,0,null,{"$f":"SUM(I48:I56)","v":0},0,0]
[]
["Closed Infinity to Infinity Regrades"]
["Infinity Trial","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 3","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 4","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["20GB BT Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,null,null,{"$f":"SUM(D60:D67)","v":0},{"$f":"SUM(E60:E67)","v":0},{"$f":"SUM(F60:F67)","v":0},{"$f":"SUM(G60:G67)","v":0},null,{"$f":"SUM(I60:I67)","v":0},{"$f":"SUM(J60:J67)","v":0},{"$f":"SUM(K60:K67)","v":0}]
[]
["Infinity dual-play to triple-play Regrade"]
["Infinity Trial","Fibre",null,{"$f":"Vol_acquisition!G$23*D60/SUM(D$60:D$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!H$23*E60/SUM(E$60:E$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!I$23*F60/SUM(F$60:F$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!J$23*G60/SUM(G$60:G$67)","v":{"$error":"#VALUE!"}},null,{"$f":"Vol_acquisition!L$23*I60/SUM(I$60:I$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!M$23*J60/SUM(J$60:J$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!N$23*K60/SUM(K$60:K$67)","v":{"$error":"#VALUE!"}}]
["Infinity 1","Fibre",null,{"$f":"Vol_acquisition!G$23*D61/SUM(D$60:D$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!H$23*E61/SUM(E$60:E$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!I$23*F61/SUM(F$60:F$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!J$23*G61/SUM(G$60:G$67)","v":{"$error":"#VALUE!"}},null,{"$f":"Vol_acquisition!L$23*I61/SUM(I$60:I$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!M$23*J61/SUM(J$60:J$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!N$23*K61/SUM(K$60:K$67)","v":{"$error":"#VALUE!"}}]
["Infinity 2","Fibre",null,{"$f":"Vol_acquisition!G$23*D62/SUM(D$60:D$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!H$23*E62/SUM(E$60:E$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!I$23*F62/SUM(F$60:F$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!J$23*G62/SUM(G$60:G$67)","v":{"$error":"#VALUE!"}},null,{"$f":"Vol_acquisition!L$23*I62/SUM(I$60:I$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!M$23*J62/SUM(J$60:J$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!N$23*K62/SUM(K$60:K$67)","v":{"$error":"#VALUE!"}}]
["Infinity 3","Fibre",null,{"$f":"Vol_acquisition!G$23*D63/SUM(D$60:D$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!H$23*E63/SUM(E$60:E$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!I$23*F63/SUM(F$60:F$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!J$23*G63/SUM(G$60:G$67)","v":{"$error":"#VALUE!"}},null,{"$f":"Vol_acquisition!L$23*I63/SUM(I$60:I$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!M$23*J63/SUM(J$60:J$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!N$23*K63/SUM(K$60:K$67)","v":{"$error":"#VALUE!"}}]
["Infinity 4","Fibre",null,{"$f":"Vol_acquisition!G$23*D64/SUM(D$60:D$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!H$23*E64/SUM(E$60:E$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!I$23*F64/SUM(F$60:F$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!J$23*G64/SUM(G$60:G$67)","v":{"$error":"#VALUE!"}},null,{"$f":"Vol_acquisition!L$23*I64/SUM(I$60:I$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!M$23*J64/SUM(J$60:J$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!N$23*K64/SUM(K$60:K$67)","v":{"$error":"#VALUE!"}}]
["Unlimited Infinity 1","Fibre",null,{"$f":"Vol_acquisition!G$23*D65/SUM(D$60:D$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!H$23*E65/SUM(E$60:E$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!I$23*F65/SUM(F$60:F$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!J$23*G65/SUM(G$60:G$67)","v":{"$error":"#VALUE!"}},null,{"$f":"Vol_acquisition!L$23*I65/SUM(I$60:I$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!M$23*J65/SUM(J$60:J$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!N$23*K65/SUM(K$60:K$67)","v":{"$error":"#VALUE!"}}]
["Unlimited Infinity 2","Fibre",null,{"$f":"Vol_acquisition!G$23*D66/SUM(D$60:D$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!H$23*E66/SUM(E$60:E$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!I$23*F66/SUM(F$60:F$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!J$23*G66/SUM(G$60:G$67)","v":{"$error":"#VALUE!"}},null,{"$f":"Vol_acquisition!L$23*I66/SUM(I$60:I$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!M$23*J66/SUM(J$60:J$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!N$23*K66/SUM(K$60:K$67)","v":{"$error":"#VALUE!"}}]
["20GB BT Infinity 1","Fibre",null,{"$f":"Vol_acquisition!G$23*D67/SUM(D$60:D$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!H$23*E67/SUM(E$60:E$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!I$23*F67/SUM(F$60:F$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!J$23*G67/SUM(G$60:G$67)","v":{"$error":"#VALUE!"}},null,{"$f":"Vol_acquisition!L$23*I67/SUM(I$60:I$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!M$23*J67/SUM(J$60:J$67)","v":{"$error":"#VALUE!"}},{"$f":"Vol_acquisition!N$23*K67/SUM(K$60:K$67)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"SUM(D71:D78)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E71:E78)","v":{"$error":"#VALUE!"}},{"$f":"SUM(F71:F78)","v":{"$error":"#VALUE!"}},{"$f":"SUM(G71:G78)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(I71:I78)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Closed Regrades to Infinity from Copper & Infinity"]
["Infinity Trial","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 3","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 4","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["20GB BT Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,null,null,{"$f":"SUM(D82:D89)","v":0},{"$f":"SUM(E82:E89)","v":0},{"$f":"SUM(F82:F89)","v":0},{"$f":"SUM(G82:G89)","v":0},null,{"$f":"SUM(I82:I89)","v":0},{"$f":"SUM(J82:J89)","v":0},{"$f":"SUM(K82:K89)","v":0}]
[]
["New Closed Provides"]
["Infinity Trial","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 3","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 4","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["20GB BT Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,null,null,{"$f":"SUM(D93:D100)","v":0},{"$f":"SUM(E93:E100)","v":0},{"$f":"SUM(F93:F100)","v":0},{"$f":"SUM(G93:G100)","v":0},null,{"$f":"SUM(I93:I100)","v":0},{"$f":"SUM(J93:J100)","v":0},{"$f":"SUM(K93:K100)","v":0}]
[]
["...of which new to BT"]
["Infinity Trial","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 3","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 4","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["20GB BT Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Balance (see note below)","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,null,null,{"$f":"SUM(D104:D112)","v":0},{"$f":"SUM(E104:E112)","v":0},{"$f":"SUM(F104:F112)","v":0},{"$f":"SUM(G104:G112)","v":0},null,{"$f":"SUM(I104:I112)","v":0},{"$f":"SUM(J104:J112)","v":0},{"$f":"SUM(K104:K112)","v":0}]
[]
["Closed Losses"]
["Infinity Trial","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 3","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Infinity 4","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["Unlimited Infinity 2","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
["20GB BT Infinity 1","Fibre",null,"Removed","Removed","Removed","Removed",null,"Removed","Removed","Removed"]
[null,null,null,{"$f":"SUM(D116:D123)","v":0},{"$f":"SUM(E116:E123)","v":0},{"$f":"SUM(F116:F123)","v":0},{"$f":"SUM(G116:G123)","v":0},null,{"$f":"SUM(I116:I123)","v":0},{"$f":"SUM(J116:J123)","v":0},{"$f":"SUM(K116:K123)","v":0}]

{"sheet":"Vol_acquisition","index":6,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["BT Retail acquisition volumes"]
[{"$f":"\"This worksheet \"&Contents!B39","v":"This worksheet contains acquisition volumes of the main products sold by BT Consumer - Voice, BB and TV."}]
["Source: S26 volumes received 18th Sep 2013"]
[]
["Units - customers",null,null,null,null,null,"2012/13",null,null,null,null,"2013/14"]
["Q.15 response - New to BT",null,null,null,null,null,"Q1","Q2","Q3","Q4","Total","Q1","Q2","Q3"]
["Customer Type","Previous holding","New holding","BB type","Acq type","Bundle type"]
["New to BT","None","Voice only","Voice",0,"Single-play","Removed","Removed","Removed","Removed",{"$f":"SUM(G8:J8)","v":0},"Removed","Removed","Removed"]
["New to BT","None","Voice + Copper BB","BB","Copper","Dual-play","Removed","Removed","Removed","Removed",{"$f":"SUM(G9:J9)","v":0},"Removed","Removed","Removed"]
["New to BT","None","Voice + Copper BB + TV","BB","Copper","Triple-play","Removed","Removed","Removed","Removed",{"$f":"SUM(G10:J10)","v":0},"Removed","Removed","Removed"]
["New to BT","None","Voice + Fibre BB","BB","Fibre","Dual-play","Removed","Removed","Removed","Removed",{"$f":"SUM(G11:J11)","v":0},"Removed","Removed","Removed"]
["New to BT","None","Voice + Fibre BB + TV","BB","Fibre","Triple-play","Removed","Removed","Removed","Removed",{"$f":"SUM(G12:J12)","v":0},"Removed","Removed","Removed"]
[]
[null,null,null,null,null,null,"2012/13",null,null,null,null,"2013/14"]
["Q.16 response - regrades",null,null,null,null,null,"Q1","Q2","Q3","Q4","Total","Q1","Q2","Q3"]
["Customer Type","Previous holding","New holding","BB type","Acq type","Bundle type"]
["Existing Customer","Voice","Voice + Copper BB","BB","Copper","Dual-play","Removed","Removed","Removed","Removed",{"$f":"SUM(G17:J17)","v":0},"Removed","Removed","Removed"]
["Existing Customer","Voice","Voice + Copper BB + TV","BB","Copper","Triple-play","Removed","Removed","Removed","Removed",0,"Removed","Removed","Removed"]
["Existing Customer","Voice","Voice + Fibre BB","BB","Fibre","Dual-play","Removed","Removed","Removed","Removed",0,"Removed","Removed","Removed"]
["Existing Customer","Voice","Voice + Fibre BB + TV","BB","Fibre","Triple-play","Removed","Removed","Removed","Removed",0,"Removed","Removed","Removed"]
["Existing Customer","Voice + Copper BB","Voice + Copper BB + TV","BB","Copper","Triple-play","Removed","Removed","Removed","Removed",0,"Removed","Removed","Removed"]
["Existing Customer","Voice + Copper BB","Voice + Fibre BB + TV","BB","Fibre","Triple-play","Removed","Removed","Removed","Removed",0,"Removed","Removed","Removed"]
["Existing Customer","Voice + Fibre BB","Voice + Fibre BB + TV","BB","Fibre","Triple-play","Removed","Removed","Removed","Removed",0,"Removed","Removed","Removed"]
["Existing Customer","Voice + Copper BB","Voice + Fibre BB","BB","Fibre","Dual-play",{"$f":"Vol_Consumer_BB_tiers!D45-Vol_acquisition!G22","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!E45-Vol_acquisition!H22","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!F45-Vol_acquisition!I22","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!G45-Vol_acquisition!J22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"Vol_Consumer_BB_tiers!I45-Vol_acquisition!L22","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!J45-Vol_acquisition!M22","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!K45-Vol_acquisition!N22","v":{"$error":"#VALUE!"}}]
["Existing Customer","Voice + Fibre BB","Voice + Copper BB","BB","Copper","Dual-play",null,null,null,null,{"$f":"SUM(K17:K24)*Fibre_Copper_regrades","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!I57","v":0},{"$f":"Vol_Consumer_BB_tiers!J57","v":0},{"$f":"Vol_Consumer_BB_tiers!K57","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Fibre to copper regrades as % of all regrades:",{"$f":"L25/SUM(L17:L24)","v":{"$error":"#VALUE!"}},{"$f":"M25/SUM(M17:M24)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"AVERAGE(L26:N26)","v":{"$error":"#VALUE!"}},"Fibre_Copper_regrades"]
[]
[null,"Triple-play broadband acquisitions"]
[null,null,null,"BB","Fibre","Triple-play",{"$f":"SUMIFS(G$8:G$25,$E$8:$E$25,$E29,$F$8:$F$25,$F29)","v":0},0,0,{"$f":"SUMIFS(J$8:J$25,$E$8:$E$25,$E29,$F$8:$F$25,$F29)","v":0},0,0,0,0,"(links to Vol_weights)"]
[null,null,null,"BB","Copper","Triple-play",0,0,0,0,0,0,0,0,"(links to Vol_weights)"]
[null,null,null,null,null,"Total triple-play",{"$f":"SUM(G29:G30)","v":0},{"$f":"SUM(H29:H30)","v":0},{"$f":"SUM(I29:I30)","v":0},{"$f":"SUM(J29:J30)","v":0},{"$f":"SUM(K29:K30)","v":0},{"$f":"SUM(L29:L30)","v":0},{"$f":"SUM(M29:M30)","v":0},{"$f":"SUM(N29:N30)","v":0}]

{"sheet":"TV_BB_tiers","index":7,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["TV customer base volumes"]
[{"$f":"\"This worksheet \"&Contents!B40","v":"This worksheet contains base volumes for SFBB customers taking BT TV split out by product tier."}]
["Units - customers"]
[null,null,"2012-2013 Year",null,null,null,"2013-2014 Year"]
[null,null,"June '12","Sep '12","Dec '12","Mar '13","June '13","Sep '13","Dec '13"]
[]
["Total Fibre + TV Customers:","Model labels"]
["BT Infinity 1","Infinity 1","Removed","Removed","Removed","Removed","Removed","Removed","Removed"]
["BT Infinity Option 1","Infinity 1","Removed","Removed","Removed","Removed","Removed","Removed","Removed"]
["BT Infinity Option 2","Infinity 2","Removed","Removed","Removed","Removed","Removed","Removed","Removed"]
["BT Infinity Option 3","Infinity 3","Removed","Removed","Removed","Removed","Removed","Removed","Removed"]
["BT Infinity Option 4","Infinity 4","Removed","Removed","Removed","Removed","Removed","Removed","Removed"]
["Unlimited BT Infinity 1","Unlimited Infinity 1","Removed","Removed","Removed","Removed","Removed","Removed","Removed"]
["Unlimited BT Infinity 2","Infinity 2","Removed","Removed","Removed","Removed","Removed","Removed","Removed"]
["20GB BT Infinity 1","Infinity 1","Removed","Removed","Removed","Removed","Removed","Removed","Removed"]
["Grand Total",null,{"$f":"SUM(C8:C15)","v":0},0,0,0,0,0,0]
[]
[null,"Summary"]
[null,"Infinity 1",{"$f":"SUMIF($B$8:$B$15,$B19,C$8:C$15)","v":0},0,0,0,0,0,0]
[null,"Infinity 2",0,0,0,0,0,0,0]
[null,"Infinity 3",0,0,0,0,0,0,0]
[null,"Unlimited Infinity 1",0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C19:C22)","v":0},0,0,0,0,0,0]

{"sheet":"Vol_weights","index":8,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["SFBB portfolio volume weights"]
[{"$f":"\"This worksheet \"&Contents!B41","v":"This worksheet collects Q3 2013/14 SFBB product tier volume data and calculates the weightings to apply to the portfolio."}]
[" S26 volumes submitted on 20 May 2013 and 24 February 2014"]
[]
[null,null,null,null,"Scenario description","Q3 2013/14 volumes","Q3 2013/14 volumes"]
["Units - customers",null,null,null,null,"Customer base","Quarterly acquisitions"]
["Aggregate volumes"]
[null,"Product tier","Type of broadband","Brand"]
[null,"Infinity 1","Fibre","BT",null,{"$f":"Vol_Consumer_BB_tiers!K7+Vol_Consumer_BB_tiers!K13","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!K27+Vol_Consumer_BB_tiers!K33","v":{"$error":"#VALUE!"}}]
[null,"Unlimited Infinity 1","Fibre","BT",null,{"$f":"Vol_Consumer_BB_tiers!K11","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!K31","v":{"$error":"#VALUE!"}}]
[null,"Infinity 2","Fibre","BT",null,{"$f":"Vol_Consumer_BB_tiers!K8+Vol_Consumer_BB_tiers!K12","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!K28+Vol_Consumer_BB_tiers!K32","v":{"$error":"#VALUE!"}}]
[null,"Infinity 3","Fibre","BT",null,{"$f":"Vol_Consumer_BB_tiers!K9","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!K29","v":{"$error":"#VALUE!"}}]
[null,"Plusnet Fibre","Fibre","Plusnet",null,"Removed","Removed"]
[null,null,null,null,null,{"$f":"SUM(F9:F13)","v":{"$error":"#VALUE!"}},{"$f":"SUM(G9:G13)","v":{"$error":"#VALUE!"}}]
["Triple play volumes"]
[null,"Infinity 1",{"$f":"C9","v":"Fibre"},"BT",null,{"$f":"TV_BB_tiers!I19","v":0},{"$f":"IF($D16=\"Plusnet\",0,Vol_acquisition!$N$29*(G9/SUMIFS(G$9:G$13,$C$9:$C$13,\"Fibre\",$D$9:$D$13,\"BT\")))","v":{"$error":"#VALUE!"}}]
[null,"Unlimited Infinity 1","Fibre","BT",null,{"$f":"TV_BB_tiers!I22","v":0},{"$f":"IF($D17=\"Plusnet\",0,Vol_acquisition!$N$29*(G10/SUMIFS(G$9:G$13,$C$9:$C$13,\"Fibre\",$D$9:$D$13,\"BT\")))","v":{"$error":"#VALUE!"}}]
[null,"Infinity 2","Fibre","BT",null,{"$f":"TV_BB_tiers!I20","v":0},{"$f":"IF($D18=\"Plusnet\",0,Vol_acquisition!$N$29*(G11/SUMIFS(G$9:G$13,$C$9:$C$13,\"Fibre\",$D$9:$D$13,\"BT\")))","v":{"$error":"#VALUE!"}}]
[null,"Infinity 3","Fibre","BT",null,{"$f":"TV_BB_tiers!I21","v":0},{"$f":"IF($D19=\"Plusnet\",0,Vol_acquisition!$N$29*(G12/SUMIFS(G$9:G$13,$C$9:$C$13,\"Fibre\",$D$9:$D$13,\"BT\")))","v":{"$error":"#VALUE!"}}]
[null,"Plusnet Fibre","Fibre","Plusnet",null,0,{"$f":"IF($D20=\"Plusnet\",0,Vol_acquisition!$N$29*(G13/SUMIFS(G$9:G$13,$C$9:$C$13,\"Fibre\",$D$9:$D$13,\"BT\")))","v":0}]
[null,null,null,null,null,{"$f":"SUM(F16:F20)","v":0},{"$f":"SUM(G16:G20)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"Bundles included",{"$f":"Ctrl_sheet!C5","v":"Total mix (dual-play and triple-play)"}]
[null,"Type of volume weights",{"$f":"Ctrl_sheet!C11","v":"Quarterly acquisitions"}]
[]
[]
["Selected aggregate volumes"]
[null,null,null,"Volume","Volume weights"]
[null,{"$f":"B9","v":"Infinity 1"},"Fibre",{"$f":"SUMIFS(F9:G9,$F$6:$G$6,$C$25)","v":{"$error":"#VALUE!"}},{"$f":"D30/$D$35","v":{"$error":"#VALUE!"}}]
[null,"Unlimited Infinity 1","Fibre",{"$f":"SUMIFS(F10:G10,$F$6:$G$6,$C$25)","v":{"$error":"#VALUE!"}},{"$f":"D31/$D$35","v":{"$error":"#VALUE!"}}]
[null,"Infinity 2","Fibre",{"$f":"SUMIFS(F11:G11,$F$6:$G$6,$C$25)","v":{"$error":"#VALUE!"}},{"$f":"D32/$D$35","v":{"$error":"#VALUE!"}}]
[null,"Infinity 3","Fibre",{"$f":"SUMIFS(F12:G12,$F$6:$G$6,$C$25)","v":{"$error":"#VALUE!"}},{"$f":"D33/$D$35","v":{"$error":"#VALUE!"}}]
[null,"Plusnet Fibre","Fibre",{"$f":"SUMIFS(F13:G13,$F$6:$G$6,$C$25)","v":0},{"$f":"D34/$D$35","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"SUM(D30:D34)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E30:E34)","v":{"$error":"#VALUE!"}}]
[]
["Selected triple-play"]
[null,null,null,"Volume","Volume weights"]
[null,{"$f":"B9","v":"Infinity 1"},"Fibre",{"$f":"SUMIFS(F16:G16,$F$6:$G$6,$C$25)","v":{"$error":"#VALUE!"}},{"$f":"D39/$D$44","v":{"$error":"#VALUE!"}}]
[null,"Unlimited Infinity 1","Fibre",{"$f":"SUMIFS(F17:G17,$F$6:$G$6,$C$25)","v":{"$error":"#VALUE!"}},{"$f":"D40/$D$44","v":{"$error":"#VALUE!"}}]
[null,"Infinity 2","Fibre",{"$f":"SUMIFS(F18:G18,$F$6:$G$6,$C$25)","v":{"$error":"#VALUE!"}},{"$f":"D41/$D$44","v":{"$error":"#VALUE!"}}]
[null,"Infinity 3","Fibre",{"$f":"SUMIFS(F19:G19,$F$6:$G$6,$C$25)","v":{"$error":"#VALUE!"}},{"$f":"D42/$D$44","v":{"$error":"#VALUE!"}}]
[null,"Plusnet Fibre","Fibre",{"$f":"SUMIFS(F20:G20,$F$6:$G$6,$C$25)","v":0},{"$f":"D43/$D$44","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"SUM(D39:D43)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E39:E43)","v":{"$error":"#VALUE!"}}]
[]
["Selected dual-play"]
[null,null,null,"Volume","Volume weights"]
[null,{"$f":"B9","v":"Infinity 1"},"Fibre",{"$f":"D30-D39","v":{"$error":"#VALUE!"}},{"$f":"IF($C$24=\"Dual-play\",D30/$D$35,D48/$D$53)","v":{"$error":"#VALUE!"}}]
[null,"Unlimited Infinity 1","Fibre",{"$f":"D31-D40","v":{"$error":"#VALUE!"}},{"$f":"IF($C$24=\"Dual-play\",D31/$D$35,D49/$D$53)","v":{"$error":"#VALUE!"}}]
[null,"Infinity 2","Fibre",{"$f":"D32-D41","v":{"$error":"#VALUE!"}},{"$f":"IF($C$24=\"Dual-play\",D32/$D$35,D50/$D$53)","v":{"$error":"#VALUE!"}}]
[null,"Infinity 3","Fibre",{"$f":"D33-D42","v":{"$error":"#VALUE!"}},{"$f":"IF($C$24=\"Dual-play\",D33/$D$35,D51/$D$53)","v":{"$error":"#VALUE!"}}]
[null,"Plusnet Fibre","Fibre",{"$f":"D34-D43","v":0},{"$f":"IF($C$24=\"Dual-play\",D34/$D$35,D52/$D$53)","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"SUM(D48:D52)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E48:E52)","v":{"$error":"#VALUE!"}}]
[]
["Total mix (dual-play and triple-play) weights "]
[null,null,null,"Dual-play %","Triple-play %"]
[null,{"$f":"B9","v":"Infinity 1"},"Fibre",{"$f":"IF(D30=0,0,D48/D30)","v":{"$error":"#VALUE!"}},{"$f":"IF(D30=0,0,D39/D30)","v":{"$error":"#VALUE!"}}]
[null,"Unlimited Infinity 1","Fibre",{"$f":"IF(D31=0,0,D49/D31)","v":{"$error":"#VALUE!"}},{"$f":"IF(D31=0,0,D40/D31)","v":{"$error":"#VALUE!"}}]
[null,"Infinity 2","Fibre",{"$f":"IF(D32=0,0,D50/D32)","v":{"$error":"#VALUE!"}},{"$f":"IF(D32=0,0,D41/D32)","v":{"$error":"#VALUE!"}}]
[null,"Infinity 3","Fibre",{"$f":"IF(D33=0,0,D51/D33)","v":{"$error":"#VALUE!"}},{"$f":"IF(D33=0,0,D42/D33)","v":{"$error":"#VALUE!"}}]
[null,"Plusnet Fibre","Fibre",{"$f":"IF(D34=0,0,D52/D34)","v":0},{"$f":"IF(D34=0,0,D43/D34)","v":0}]
[]
[null,null,"SFBB dual/triple split",{"$f":"SUMPRODUCT(D57:D61,$D$30:$D$34)/SUM($D$30:$D$34)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(E57:E61,$D$30:$D$34)/SUM($D$30:$D$34)","v":{"$error":"#VALUE!"}}]

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

{"sheet":"Marketing","index":10,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Marketing costs - 2012/13"]
[{"$f":"\"This worksheet \"&Contents!B44","v":"This worksheet contains the totals for each category of marketing spend in 2012/13. Upfront customer acquisition costs are allocated to SFBB customers in this worksheet. Ongoing costs are linked to \"MA_data\" sheet."}]
["Source: S26 data received 10th Sep 2013"]
["Units - £000"]
[]
[null,"Type of cost","Q1","Q2","Q3","Q4","Total"]
["[Customer acquisition - new customers]","Upfront","Removed","Removed","Removed","Removed",{"$f":"SUM(C7:F7)","v":0}]
["[Customer acquisition - existing customers]","Upfront","Removed","Removed","Removed","Removed",{"$f":"SUM(C8:F8)","v":0}]
["Retention","Ongoing","Removed","Removed","Removed","Removed",0,"(links to management acc data)"]
["Non campaign","Ongoing","Removed","Removed","Removed","Removed",0]
["[Other type 1]","Ongoing","Removed","Removed","Removed","Removed",0]
["[Other type 2]","Ongoing",{"$f":"$G$12/4","v":{"$error":"#VALUE!"}},{"$f":"$G$12/4","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Removed"]
["Non campaign less [Other]","Ongoing",{"$f":"C10+C11+C12","v":{"$error":"#VALUE!"}},{"$f":"D10+D11+D12","v":{"$error":"#VALUE!"}},{"$f":"E10+E11+E12","v":{"$error":"#VALUE!"}},{"$f":"F10+F11+F12","v":{"$error":"#VALUE!"}},{"$f":"SUM(C13:F13)","v":{"$error":"#VALUE!"}},"(links to management acc data)"]
["Total marketing spend",null,{"$f":"SUM(C7:C9,C13)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D7:D9,D13)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(G7:G9,G13)","v":{"$error":"#VALUE!"}}]
[]
["Calculation inputs"]
[]
["Broadband new to BT acquisitions",{"$f":"SUMIF(Vol_acquisition!$D$8:$D$12,\"BB\",Vol_acquisition!$K$8:$K$12)","v":0}]
["Share of total new to BT acquisitions",{"$f":"B18/SUM(Vol_acquisition!$K$8:$K$12)","v":{"$error":"#DIV/0!"}}]
[]
["Broadband regrade acquisitions",{"$f":"SUMIF(Vol_acquisition!$D$17:$D$25,\"BB\",Vol_acquisition!$K$17:$K$25)","v":{"$error":"#VALUE!"}}]
["Share of total regrade acquisitions",{"$f":"B21/SUM(Vol_acquisition!$K$17:$K$25)","v":{"$error":"#VALUE!"}}]
[]
["Share of broadband acquisitions that are new to BT",{"$f":"B18/(B18+B21)","v":{"$error":"#VALUE!"}}]
[]
["Upfront acquisition costs per customer (£)"]
[null,null,"Q1","Q2","Q3","Q4","Total"]
[]
["[Customer acquisition - new customers]",null,{"$f":"C7*$B$19","v":{"$error":"#VALUE!"}},{"$f":"D7*$B$19","v":{"$error":"#VALUE!"}},{"$f":"E7*$B$19","v":{"$error":"#VALUE!"}},{"$f":"F7*$B$19","v":{"$error":"#VALUE!"}},{"$f":"G7*$B$19","v":{"$error":"#DIV/0!"}}]
["Cost per acquired customer",null,null,null,null,null,{"$f":"G29/B18*1000","v":{"$error":"#DIV/0!"}}]
[]
["[Customer acquisition - existing customers]",null,{"$f":"C8*$B$22","v":{"$error":"#VALUE!"}},{"$f":"D8*$B$22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Cost per acquired customer",null,null,null,null,null,{"$f":"G32/B21*1000","v":{"$error":"#VALUE!"}}]
[]
["Upfront marketing cost per customer",null,null,null,null,null,{"$f":"G30*B24+G33*(1-B24)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Customer_services","index":11,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Customer services costs - 2012/13"]
[{"$f":"\"This worksheet \"&Contents!B45","v":"This worksheet This worksheet contains the totals of each category of customer services costs in 2012/13. Costs per SFBB subscriber are calculated for [Customer service ongoing - type 1]. All other customer service costs linked to MA_data sheet."}]
["Source: S26 data received 10th Sep 2013"]
["Units - £000"]
[null,"Type of cost","BT allocation method","Total Consumer BRF2 12/13","Dual-play allocation","Triple-play allocation","Total mix (dual-play and triple-play)"]
[]
["[Customer service ongoing - type 1]","Ongoing","using TLC data in file provided","Removed","Removed","Removed","Removed"]
[]
["[Customer service upfront]","Upfront","Acquistion cost","Removed","(links to management acc data)"]
[]
["[Customer service ongoing - type 2]","Ongoing","using closing base","Removed","(links to management acc data)"]
["[Customer service ongoing - type 3]","Ongoing","using closing base","Removed","(links to management acc data)"]
["[Customer service overheads]","Ongoing","using closing base","Removed","(links to management acc data)"]
[]
[]
["Calculation inputs"]
[]
["Broadband acquisitions (000s)",{"$f":"SUMIF(Vol_acquisition!$D$8:$D$25,\"BB\",Vol_acquisition!$K$8:$K$25)/1000","v":{"$error":"#VALUE!"}}]
["Share of total acquisitions",{"$f":"SUMIF(Vol_acquisition!$D$8:$D$25,\"BB\",Vol_acquisition!$K$8:$K$25)/SUM(Vol_acquisition!$K$8:$K$12,Vol_acquisition!$K$17:$K$25)","v":{"$error":"#VALUE!"}}]
[]
[null,"Customer base"]
["Dual-play (000s)",{"$f":"AVERAGE(Vol_Consumer!D33:G33)-AVERAGE(Vol_Consumer!D42:G42)","v":{"$error":"#DIV/0!"}}]
["Triple-play (000s)",{"$f":"AVERAGE(Vol_Consumer!D42:G42)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"`"]
[]
["Upfront acquisition costs per customer (£)"]
[]
["[Customer service upfront]",{"$f":"D9*B19/B18","v":{"$error":"#VALUE!"}}]
[]
["Monthly ongoing costs per customer (£)"]
[null,"Dual-play","Triple-play"]
["[Customer service ongoing - type 1]",{"$f":"E7/B22/12","v":{"$error":"#VALUE!"}},{"$f":"F7/B23/12","v":{"$error":"#VALUE!"}}]

{"sheet":"Affiliates","index":12,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Affiliates / pay-per click costs - 2012/13"]
[{"$f":"\"This worksheet \"&Contents!B46","v":"This worksheet collects the total online advertising spend on broadband, calls and TV as calculated in the \"Pay per click\" file and allocates to SFBB on the basis of acquisition volumes"}]
["Source: BT s26 data received 18 October 2013"]
["Units - £"]
[]
["Calculation inputs"]
[]
["% of voice acquisitions bundled with broadband",{"$f":"SUMIF(Vol_acquisition!$D$8:$D$25,\"BB\",Vol_acquisition!$K$8:$K$25)/SUM(Vol_acquisition!$K$8:$K$12,Vol_acquisition!$K$17:$K$25)","v":{"$error":"#VALUE!"}}]
[]
["Dual-play BB share of total acquisitions",{"$f":"SUMIF(Vol_acquisition!$F$8:$F$25,\"dual-play\",Vol_acquisition!$K$8:$K$25)/SUM(Vol_acquisition!$K$8:$K$12,Vol_acquisition!$K$17:$K$25)","v":{"$error":"#VALUE!"}}]
["Triple-play BB share of total acquisitions",{"$f":"SUMIF(Vol_acquisition!$F$8:$F$25,\"triple-play\",Vol_acquisition!$K$8:$K$25)/SUM(Vol_acquisition!$K$8:$K$12,Vol_acquisition!$K$17:$K$25)","v":{"$error":"#VALUE!"}}]
[]
["Dual-play acquisitions",{"$f":"SUMIF(Vol_acquisition!$F$8:$F$25,\"dual-play\",Vol_acquisition!$K$8:$K$25)","v":{"$error":"#VALUE!"}}]
["Triple-play acquisitions",{"$f":"SUMIF(Vol_acquisition!$F$8:$F$25,\"triple-play\",Vol_acquisition!$K$8:$K$25)","v":0}]
[]
[]
[null,"Online comparison site cost","Search term payments"]
["Broadband","Removed","Removed"]
["Calls","Removed","Removed"]
["TV","Removed","Removed"]
[null,{"$f":"SUM(B18:B20)","v":0},{"$f":"SUM(C18:C20)","v":0}]
[]
["Allocation to BB packages"]
[]
["Dual-play",{"$f":"($B$18+$C$18+$B$8*($B$19+$C$19))*B10","v":{"$error":"#VALUE!"}}]
["Triple-play",{"$f":"($B$18+$C$18+$B$8*($B$19+$C$19))*B11+B20+C20","v":{"$error":"#VALUE!"}}]
["Total mix",{"$f":"B25+B26","v":{"$error":"#VALUE!"}}]
[]
["Upfront acquisition costs per customer (£)"]
[]
["Dual-play",{"$f":"B25/B13","v":{"$error":"#VALUE!"}}]
["Triple-play",{"$f":"B26/B14","v":{"$error":"#VALUE!"}}]

{"sheet":"Development","index":13,"n_rows":71,"n_cols":8,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
["Development spend - 2012/13"]
[{"$f":"\"This worksheet \"&Contents!B47","v":"This worksheet contains the break-down of development spend into different activities. These activities are categorised into broadband (BB), voice, TV and other and a proportion of these costs are allocated to SFBB."}]
["Source: ","S26 data received 10th Sep 2013"]
["Units - £m"]
[]
["Calculation inputs"]
["Volumes - 000s","FY12/13 "]
["Voice (lines)",{"$f":"AVERAGE(Vol_Consumer!$D$24:$G$24)","v":{"$error":"#DIV/0!"}}]
["BB (base)",{"$f":"AVERAGE(Vol_Consumer!$D$33:$G$33)","v":{"$error":"#DIV/0!"}}]
["TV (base)",{"$f":"AVERAGE(Vol_Consumer!$D$42:$G$42)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"SUM(B7:B10)","v":{"$error":"#DIV/0!"}}]
[]
["% of base taking BB",{"$f":"B9/B8","v":{"$error":"#DIV/0!"}},null," "]
["% of BB dual-play",{"$f":"(B9-B10)/B9","v":{"$error":"#DIV/0!"}}]
["% of BB triple-play",{"$f":"B10/B9","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["OUC code for spend","Relating to…","PL Code","Relating to…","2012/13"]
[null,null,null,null,"YearTotal (£m)",null,"Cost type"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Voice"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"TV"]
["Removed","Removed","Removed","Removed","Removed",null,"TV"]
["Removed","Removed","Removed","Removed","Removed",null,"TV"]
["Removed","Removed","Removed","Removed","Removed",null,"TV"]
["Removed","Removed","Removed","Removed","Removed",null,"Voice"]
["Removed","Removed","Removed","Removed","Removed",null,"Voice"]
["Removed","Removed","Removed","Removed","Removed",null,"Voice"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Voice"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other","(links to MA data)"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"Other"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
["Removed","Removed","Removed","Removed","Removed",null,"BB"]
[]
[null,null,null,"CONSUMER NET DEVELOPMENT",{"$f":"SUM(E21:E59)","v":0}]
[null,null,null,"less Plusnet",{"$f":"E61-E27","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Less fixed costs","Removed"]
[]
[null,null,null,"Dual-play allocation",{"$f":"(SUMIF($G:$G,\"BB\",$E:$E)+$B$13*SUMIF($G:$G,\"Voice\",$E:$E))*B14+$E$64","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Triple-play allocation",{"$f":"(SUMIF($G:$G,\"BB\",$E:$E)+$B$13*SUMIF($G:$G,\"Voice\",$E:$E))*B15+SUMIF($G:$G,\"TV\",$E:$E)+$E$64","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Monthly cost per customer (£)"]
[null,null,null,"Dual-play",{"$f":"E66*1000/(B9-B10)/12","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Triple-play",{"$f":"E67*1000/B10/12","v":{"$error":"#DIV/0!"}}]

{"sheet":"Bandwidth_costs","index":14,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Infinity bandwidth costs"]
[{"$f":"\"This worksheet \"&Contents!B48","v":"This worksheet Calculates 2013/14 network costs on the basis of RFS cost data and actual peak throughput per user data"}]
[]
["2013/14 cost per Mbit/s (£ per month)"]
[]
["RFS Total FAC - Internal WBC Bandwidth Market 3"]
["Core (Market 3 WBC Bandwidth costs) ",null,"Removed","Source: BT s135 response on 26 September 2014 and 10 October 2014"]
["EOI (Market 3 WBC Bandwidth costs)",null,"Removed","Source: BT s135 response on 26 September 2014 and 10 October 2015"]
["Exclusion of EAD",null,"Removed","Source: BT s135 response on 26 September 2014 and 10 October 2016"]
["Inclusion of core transmission (CN906)",null,"Removed","Source: BT s135 response on 7 November 2014"]
["Inclusion of MSIL & Cablelink",null,"Removed","Source: 2012/13 MSIL & Cablelink cost data from BT's CA98 s26 response received on 18 September"]
[null,null,{"$f":"SUM(C7:C11)","v":0}]
[]
["Peak throughput volumes (Kbit/s) and calculation"]
["Source: 13/14 figures obtained from BT's s135 response 20 Nov 2014"]
["12/13 figures from BT's CA98 s26 response received on 16 December 2013 "]
["FTTP volumes from BT model submitted on 13 May 2013 "]
["Fibre","12/13","13/14",null,"13/14 throughput (Kbit/s)","x","Cost per Mbit/s - 13/14 (£ per month)","=","Bandwidth cost (£ per month) "]
["Infinity 1 40/2 & 40/10 & sub-15","Removed","Removed",null,{"$f":"C19","v":"Removed"},null,{"$f":"$C$12","v":0},null,{"$f":"E19*G19/1000","v":{"$error":"#VALUE!"}}]
["Infinity 2 40/10","Removed","Removed",null,{"$f":"C20","v":"Removed"},null,{"$f":"$C$12","v":0},null,{"$f":"E20*G20/1000","v":{"$error":"#VALUE!"}}]
["Unlimited Infinity 1","Removed","Removed",null,"Removed",null,0,null,{"$error":"#VALUE!"}]
["Infinity 2 80/20","Removed","Removed",null,"Removed",null,0,null,{"$error":"#VALUE!"}]
["FTTP","Removed","Removed",null,"Removed",null,0,null,{"$error":"#VALUE!"}]
[]
["Copper (2012/13 data used for allocation of platform costs)","12/13","13/14"]
["Broadband","Removed"]
["Unlimited Broadband","Removed"]
["Unlimited broadband extra","Removed"]
["Broadband Option 2","Removed"]
["Broadband Option 3","Removed"]

{"sheet":"Platform","index":15,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["2012/13 Platform costs"]
[{"$f":"\"This worksheet \"&Contents!B49","v":"This worksheet allocates 2012/13 platform costs to individual products based on share of total throughput"}]
["BT response to srd 3135 received 24 June 2013"]
["2012/13 Platform Costs (£)","Removed"]
["Average volumes (2012/13)",{"$f":"AVERAGE(Vol_Consumer!D33:G33)*1000","v":{"$error":"#DIV/0!"}}]
[]
[]
["2012/13 Volumes","Q1","Q2","Q3","Q4","%","Average Volume Estimate",null,"12/13 Throughput (Mbit/s)","Total throughput","%"]
["Infinity 1",{"$f":"Vol_Consumer_BB_tiers!D7+Vol_Consumer_BB_tiers!D13","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!E7+Vol_Consumer_BB_tiers!E13","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!F7+Vol_Consumer_BB_tiers!F13","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!G7+Vol_Consumer_BB_tiers!G13","v":{"$error":"#VALUE!"}},{"$f":"E9/SUM($E$9:$E$17)","v":{"$error":"#VALUE!"}},{"$f":"$B$5*F9","v":{"$error":"#DIV/0!"}},null,{"$f":"Bandwidth_costs!B19","v":"Removed"},{"$f":"E9*I9","v":{"$error":"#VALUE!"}},{"$f":"J9/$J$18","v":{"$error":"#VALUE!"}}]
["Unlimited Infinity 1",{"$f":"Vol_Consumer_BB_tiers!D11","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!E11","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!F11","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!G11","v":"Removed"},{"$f":"E10/SUM($E$9:$E$17)","v":{"$error":"#VALUE!"}},{"$f":"$B$5*F10","v":{"$error":"#DIV/0!"}},null,{"$f":"Bandwidth_costs!B21","v":"Removed"},{"$f":"E10*I10","v":{"$error":"#VALUE!"}},{"$f":"J10/$J$18","v":{"$error":"#VALUE!"}}]
["Infinity 2",{"$f":"Vol_Consumer_BB_tiers!D8","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!E8","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!F8","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!G8","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$f":"Bandwidth_costs!B22","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Infinity 3",{"$f":"Vol_Consumer_BB_tiers!D9","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!E9","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!F9","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!G9","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$f":"Bandwidth_costs!B23","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Broadband",{"$f":"Vol_Consumer_BB_tiers!D15+Vol_Consumer_BB_tiers!D16","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!E15+Vol_Consumer_BB_tiers!E16","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!F15+Vol_Consumer_BB_tiers!F16","v":{"$error":"#VALUE!"}},{"$f":"Vol_Consumer_BB_tiers!G15+Vol_Consumer_BB_tiers!G16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$f":"Bandwidth_costs!B26","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unlimited broadband",{"$f":"Vol_Consumer_BB_tiers!D20","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!E20","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!F20","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!G20","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$f":"Bandwidth_costs!B27","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unlimited broadband extra",{"$f":"Vol_Consumer_BB_tiers!D21","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!E21","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!F21","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!G21","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$f":"Bandwidth_costs!B28","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Broadband Option 2",{"$f":"Vol_Consumer_BB_tiers!D17","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!E17","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!F17","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!G17","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$f":"Bandwidth_costs!B29","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Broadband Option 3",{"$f":"Vol_Consumer_BB_tiers!D18","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!E18","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!F18","v":"Removed"},{"$f":"Vol_Consumer_BB_tiers!G18","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},null,{"$f":"Bandwidth_costs!B30","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J17)","v":{"$error":"#VALUE!"}}]
[]
[]
["Calculations","Total Platform costs (£)","Average platform costs (£)"]
["Infinity 1",{"$f":"$B$4*K9","v":{"$error":"#VALUE!"}},{"$f":"B22/G9/12","v":{"$error":"#VALUE!"}}]
["Unlimited Infinity 1",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Infinity 2",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Infinity 3",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Broadband",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unlimited broadband",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unlimited broadband extra",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Broadband Option 2",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Broadband Option 3",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Telesales","index":16,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Telesales - total labour cost (TLC) for 2012/13"]
[{"$f":"\"This worksheet \"&Contents!B50","v":"This worksheet collects 2012/13 data from BT's Total Labour Cost system on telesales spend broken down by activities. This sheet allocates telesales costs to different product lines on the basis of call handling times."}]
["Source: S26 data received on 11th October 2013 ",null,null,null,null,null,null,"Inbound Telesales TLC (£)"]
[null,null,null,null,null,null,null,null,"Q4 12/13 TLR","% split of TLR","2012/13 TLC"]
[null,"Line","CPS","BB","Vision","Total",null,"Removed","Removed",{"$f":"I5/I$10","v":{"$error":"#VALUE!"}},"Removed"]
["Raised Provides (customers)","Removed","Removed","Removed","Removed",{"$f":"SUM(B6:E6)","v":0},null,"Removed","Removed",{"$f":"I6/I$10","v":{"$error":"#VALUE!"}},"Removed"]
["Orders placed",null,null,null,null,null,null,"Removed","Removed",{"$f":"I7/I$10","v":{"$error":"#VALUE!"}},"Removed"]
["Breakage ","Removed","Removed","Removed","Removed",null,null,"Removed","Removed",{"$f":"I8/I$10","v":{"$error":"#VALUE!"}},"Removed"]
["% of customers not cancelling order",null,null,null,null,null,null,"Removed","Removed",{"$f":"I9/I$10","v":{"$error":"#VALUE!"}},"Removed"]
["Installs (customers)",{"$f":"B6*B8","v":{"$error":"#VALUE!"}},{"$f":"C6*C8","v":{"$error":"#VALUE!"}},{"$f":"D6*D8","v":{"$error":"#VALUE!"}},{"$f":"E6*E8","v":{"$error":"#VALUE!"}},{"$f":"SUM(B10:E10)","v":{"$error":"#VALUE!"}},null,"Total",{"$f":"SUM(I5:I9)","v":0},{"$f":"SUM(J5:J9)","v":{"$error":"#VALUE!"}},{"$f":"SUM(K5:K9)","v":0}]
["Actual installs following order"]
["Call handling time per sale (seconds)","Removed","Removed","Removed","Removed",{"$f":"SUM(B12:E12)","v":0},null,"Inbound"]
[null,null,null,null,null,null,null,null,"2012/13 TLC","Assumed % Inbound Acq","12/13 Acq TLC"]
["Total time for installs (seconds)",{"$f":"B12*(B10)","v":{"$error":"#VALUE!"}},{"$f":"C12*C10","v":{"$error":"#VALUE!"}},{"$f":"D12*D10","v":{"$error":"#VALUE!"}},{"$f":"E12*E10","v":{"$error":"#VALUE!"}},{"$f":"SUM(B14:E14)","v":{"$error":"#VALUE!"}},null,"Sales",{"$f":"$K$10*J5","v":{"$error":"#VALUE!"}},"Removed",{"$f":"J14*I14","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"COT (retention)",{"$f":"$K$10*J6","v":{"$error":"#VALUE!"}},"Removed",{"$f":"J15*I15","v":{"$error":"#VALUE!"}}]
["Allocation of TLC (£)",{"$f":"($K$19/$F$14)*B14","v":{"$error":"#VALUE!"}},{"$f":"($K$19/$F$14)*C14","v":{"$error":"#VALUE!"}},{"$f":"($K$19/$F$14)*D14","v":{"$error":"#VALUE!"}},{"$f":"($K$19/$F$14)*E14","v":{"$error":"#VALUE!"}},{"$f":"($K$19/$F$14)*F14","v":{"$error":"#VALUE!"}},null,"Home movers",{"$f":"$K$10*J7","v":{"$error":"#VALUE!"}},"Removed",{"$f":"J16*I16","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"Support ",{"$f":"$K$10*J8","v":{"$error":"#VALUE!"}},"Removed",{"$f":"J17*I17","v":{"$error":"#VALUE!"}}]
["Cost per acquisition by product",{"$f":"B16/B10","v":{"$error":"#VALUE!"}},{"$f":"C16/C10","v":{"$error":"#VALUE!"}},{"$f":"D16/D10","v":{"$error":"#VALUE!"}},{"$f":"E16/E10","v":{"$error":"#VALUE!"}},{"$f":"F16/F10","v":{"$error":"#VALUE!"}},null,"Offline (complaints, manual processing)",{"$f":"$K$10*J9","v":{"$error":"#VALUE!"}},"Removed",{"$f":"J18*I18","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I14:I18)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(K14:K18)","v":{"$error":"#VALUE!"}}]
[]
[]
["Upfront acquisition costs per customer (£)"]
[null,"Dual-play","Triple-play"]
["Bundle costs",{"$f":"B18+D18","v":{"$error":"#VALUE!"}},{"$f":"B18+D18+E18","v":{"$error":"#VALUE!"}}]
[]
["Ongoing costs - customer retention (£)"]
["Removed",{"$f":"(1-J15)*I15","v":{"$error":"#VALUE!"}}]
["Removed",{"$f":"(1-J16)*I16","v":{"$error":"#VALUE!"}}]
["Removed",{"$f":"(1-J17)*I17","v":{"$error":"#VALUE!"}}]
[]
["Total ongoing costs",{"$f":"SUM(B27:B29)","v":{"$error":"#VALUE!"}},"(links to management acc data)"]

{"sheet":"Calls","index":17,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Calls costs and revenues -  Infinity Customers"]
[{"$f":"\"This worksheet \"&Contents!B51","v":"This worksheet collects cost and revenue information on BT calls packages bundled with Infinity as recorded in BT's calls database."}]
["Source: s26 data received on 28th Feb 2014 and 4th Mar 2014"]
[]
["Call revenues and costs"]
[null,"Q1 13/14","Q2 13/14","Q3 13/14","Q4 13/14","Q1 14/15"]
["Volume","Removed","Removed","Removed","Removed","Removed"]
[]
["Out of package calls revenue","Removed","Removed","Removed","Removed","Removed"]
["Package revenues","Removed","Removed","Removed","Removed","Removed"]
["Total revenues",{"$f":"SUM(B9:B10)","v":0},{"$f":"SUM(C9:C10)","v":0},{"$f":"SUM(D9:D10)","v":0},0,0]
[]
["Call costs","Removed","Removed","Removed","Removed","Removed"]
["Calls contribution",{"$f":"B11-B13","v":{"$error":"#VALUE!"}},{"$f":"C11-C13","v":{"$error":"#VALUE!"}},{"$f":"D11-D13","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["Averages across quarters"]
[null,"2013/14 Average"]
["Revenues",{"$f":"AVERAGE(B11:E11)","v":0}]
["Costs",{"$f":"AVERAGE(B13:E13)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Additional features"]
["1571 price (excl. VAT)",1.46,"In Jan 2014, BT charged £1.75 (inc. 20% VAT) for this."]
["Take-up","Removed","Take up based on BT response to CA98 s26 on 7th March 2014"]
["Caller display price",1.46,"In Jan 2014, BT charged £1.75 (inc. 20% VAT) for this. Free for first 12 months."]
["Caller display take-up","Removed","Take-up assumption. BT s26 response showed 62% took-up caller display as part of initial offer."]
["1571 revenue",{"$f":"B24*B25","v":{"$error":"#VALUE!"}}]
["Caller display revenue",{"$f":"B26*B27","v":{"$error":"#VALUE!"}}]
["Caller display discount",{"$f":"-B29*12","v":{"$error":"#VALUE!"}},"Caller display is free for first 12 months"]
[]
["Total calls revenues and costs"]
["Call revenues",{"$f":"B19+SUM(B28:B29)","v":{"$error":"#VALUE!"}}]
["Call costs",{"$f":"B20","v":{"$error":"#DIV/0!"}}]
["Calls contribution",{"$f":"B33-B34","v":{"$error":"#VALUE!"}}]

{"sheet":"Line_acquisition","index":18,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Line acquisition costs"]
[{"$f":"\"This worksheet \"&Contents!B52","v":"This worksheet collects data on customer acquisitions and costs of different kinds of acquisitions (e.g. new lines, takeovers from other CPs) and calculates the average SFBB line acquisition cost."}]
[]
["Openreach charges"]
["Source: BT Model and Openreach price list","January 2015 charges"]
["WLR new connection",-47.11]
["WLR to WLR takeover",-3.39]
["MPF to WLR transfer",-40.86]
[]
["BT Retail costs for WLR (2011/12)"]
["New conections","Removed"]
["Takeover from other CP","Removed"]
[]
["Volumes","Q3 2013/14 volumes"]
["Existing BT customer (no cost)",{"$f":"1-B16","v":{"$error":"#VALUE!"}}]
["New line",{"$f":"SUM(Vol_Consumer_BB_tiers!K104:K112)/SUM(Vol_Consumer_BB_tiers!K26:K33)","v":{"$error":"#VALUE!"}}]
[]
["New line: new connection","Removed"]
["New line: takeover from other CP","Removed"]
["Source: s26 data submitted 28 February 2014"]
[]
[]
["Average line acquisition costs",{"$f":"(B$16*$B$18*(B6+$B$11))+(B$16*$B$19*(B8+$B$12))","v":{"$error":"#VALUE!"}}]

{"sheet":"TV","index":19,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,3,4,7],[4,9,4,13]]}
["TV costs and revenues"]
[{"$f":"\"This worksheet \"&Contents!B53","v":"This worksheet summarises TV costs and revenues provided by BT and selects the relevant data for inclusion in the SFBB portfolio cost stack."}]
["Source: S26 data received on 18 October 2013 and 28 February 2014 and 4 March 2014"]
[]
[null,null,null,"2012/13",null,null,null,null,null,"2013/14"]
["TV costs per customer",null,null,"Essentials","Unlimited","Essentials extra","Unlimited extra","Weighted",null,"Essentials","Unlimited","Essentials extra","Unlimited extra","Weighted"]
[null,null,"Volume weights","Removed","Removed","Removed","Removed",null,null,"Removed","Removed","Removed","Removed"]
["Monthly TV revenues",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mix"]
["TV on demand revenues (2011/12)",null,null,"Removed","Removed","Removed","Removed",{"$f":"SUMPRODUCT(D9:G9,D$7:G$7)","v":0},null,"Removed","Removed","Removed","Removed",{"$f":"SUMPRODUCT(J9:M9,J$7:M$7)","v":0},null,"2012/13",{"$f":"IF(P9=\"2012/13\",H9,N9)","v":0}]
["TV (first \" months)",null,null,"Removed","Removed","Removed","Removed",{"$f":"SUMPRODUCT(D10:G10,D$7:G$7)","v":0},null,"Removed","Removed","Removed","Removed",{"$f":"SUMPRODUCT(J10:M10,J$7:M$7)","v":0},null,"2012/13",{"$f":"IF(P10=\"2012/13\",H10,N10)","v":0}]
["TV (after first \" months)",null,null,"Removed","Removed","Removed","Removed",0,null,"Removed","Removed","Removed","Removed",0,null,"2012/13",0]
[]
["Monthly TV ongoing costs"]
["TV costs: content (2013/14)",null,null,"Removed","Removed","Removed","Removed",{"$f":"SUMPRODUCT(D14:G14,D$7:G$7)","v":0},null,"Removed","Removed","Removed","Removed",{"$f":"SUMPRODUCT(J14:M14,J$7:M$7)","v":0},null,"2013/14",{"$f":"IF(P14=\"2012/13\",H14,N14)","v":0}]
["TV costs: bandwidth/network (2013/14)",null,null,"Removed","Removed","Removed","Removed",0,null,"Removed","Removed","Removed","Removed",0,null,"2013/14",0]
["TV costs: licenses (2013/14)",null,null,"Removed","Removed","Removed","Removed",0,null,"Removed","Removed","Removed","Removed",0,null,"2012/13",0]
["TV costs: CPE (2013/14)",null,null,"Removed","Removed","Removed","Removed",0,null,"Removed","Removed","Removed","Removed",0,null,"2012/13",0]
["TV costs: fixed costs (2013/14)",null,null,"Removed","Removed","Removed","Removed",0,null,"Removed","Removed","Removed","Removed",0,null,"2013/14",0]
[]
["Upfront TV costs"]
["TV activation fee",null,null,"Removed","Removed","Removed","Removed",{"$f":"SUMPRODUCT(D21:G21,D$7:G$7)","v":0},null,"Removed","Removed","Removed","Removed",{"$f":"SUMPRODUCT(J21:M21,J$7:M$7)","v":0},null,"2012/13",{"$f":"IF(P21=\"2012/13\",H21,N21)","v":0}]
["TV delivery charge",null,null,"Removed","Removed","Removed","Removed",0,null,"Removed","Removed","Removed","Removed",0,null,"2012/13",0]
["TV box costs (2012/13)",null,null,"Removed","Removed","Removed","Removed",0,null,"Removed","Removed","Removed","Removed",0,null,"2012/13",0]
["Other TV acquisition costs",null,null,"Removed","Removed","Removed","Removed",0,null,"Removed","Removed","Removed","Removed",0,null,"2013/14",0]
[]
[]
["Selected options"]
[]
["Select data",{"$f":"Ctrl_sheet!$C$22","v":"Mix"},"The 'mix' scenario uses 2013/14 forecasts where there are material differences between the costs of the 'Extra' offers and the 'Basic' offers."]
["Reduction in customer take-up after \"months",{"$f":"Ctrl_sheet!C24","v":"Removed"},"Removed"]
[]
[]
["Monthly TV revenues","First \" months","After first \" months"]
[]
["TV on demand revenues (2011/12)",{"$f":"IF($B$29=\"2012/13\",$H9,IF($B$29=\"2013/14\",$N9,$Q9))","v":0},{"$f":"IF($B$29=\"2012/13\",$H9,IF($B$29=\"2013/14\",$N9,$Q9))*(1-$B$30)","v":{"$error":"#VALUE!"}}]
["TV monthly subscription fee",{"$f":"IF($B$29=\"2012/13\",$H10,IF($B$29=\"2013/14\",$N10,$Q10))","v":0},{"$f":"IF($B$29=\"2012/13\",$H11,IF($B$29=\"2013/14\",$N11,$Q11))*(1-$B$30)","v":{"$error":"#VALUE!"}}]
[]
["Monthly TV ongoing costs"]
[]
["TV costs: content (2013/14)",{"$f":"IF($B$29=\"2012/13\",$H14,IF($B$29=\"2013/14\",$N14,$Q14))","v":0},{"$f":"IF($B$29=\"2012/13\",$H14,IF($B$29=\"2013/14\",$N14,$Q14))*(1-$B$30)","v":{"$error":"#VALUE!"}}]
["TV costs: bandwidth/network (2013/14)",{"$f":"IF($B$29=\"2012/13\",$H15,IF($B$29=\"2013/14\",$N15,$Q15))","v":0},{"$f":"IF($B$29=\"2012/13\",$H15,IF($B$29=\"2013/14\",$N15,$Q15))*(1-$B$30)","v":{"$error":"#VALUE!"}}]
["TV costs: licenses (2013/14)",{"$f":"IF($B$29=\"2012/13\",$H16,IF($B$29=\"2013/14\",$N16,$Q16))","v":0},{"$f":"IF($B$29=\"2012/13\",$H16,IF($B$29=\"2013/14\",$N16,$Q16))*(1-$B$30)","v":{"$error":"#VALUE!"}}]
["TV costs: CPE (2013/14)",{"$f":"IF($B$29=\"2012/13\",$H17,IF($B$29=\"2013/14\",$N17,$Q17))","v":0},{"$f":"IF($B$29=\"2012/13\",$H17,IF($B$29=\"2013/14\",$N17,$Q17))*(1-$B$30)","v":{"$error":"#VALUE!"}}]
["TV costs: fixed costs (2013/14)",{"$f":"IF($B$29=\"2012/13\",$H18,IF($B$29=\"2013/14\",$N18,$Q18))","v":0},{"$f":"IF($B$29=\"2012/13\",$H18,IF($B$29=\"2013/14\",$N18,$Q18))*(1-$B$30)","v":{"$error":"#VALUE!"}}]
[]
["Upfront TV costs"]
[]
["TV activation fee",{"$f":"IF($B$29=\"2012/13\",H21,IF($B$29=\"2013/14\",N21,Q21))","v":0}]
["TV delivery charge",{"$f":"IF($B$29=\"2012/13\",H22,IF($B$29=\"2013/14\",N22,Q22))","v":0}]
["TV box costs (2012/13)",{"$f":"IF($B$29=\"2012/13\",H23,IF($B$29=\"2013/14\",N23,Q23))","v":0}]
["Other TV acquisition costs",{"$f":"IF($B$29=\"2012/13\",H24,IF($B$29=\"2013/14\",N24,Q24))","v":0}]

{"sheet":"CPE","index":20,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["CPE costs"]
[{"$f":"\"This worksheet \"&Contents!B54","v":"This worksheet calculates cost of Home Hub per SFBB subscriber"}]
["Source: s26 data in 3rd s26 (Q9) received on 4th July 2013 and 6th s26 (Q8) received on 18th October 2013"]
[]
[]
["Hub Variant (forecasts)","FY 13/14 Vol(k)","Total Cost (£k)","Unit Cost (£)"]
["Hub 3 & Hub 4","Removed","Removed",{"$f":"C7/B7","v":{"$error":"#VALUE!"}}]
["Hub 4","Removed","Removed",{"$f":"C8/B8","v":{"$error":"#VALUE!"}}]
["Hub 5","Removed","Removed",{"$error":"#VALUE!"}]
["Removed","Removed","Removed","Removed"]
[]
[]
["Model prices"]
["Hub cost",{"$f":"D9-D10","v":{"$error":"#VALUE!"}}]

{"sheet":"TSO","index":21,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["TSO costs"]
[{"$f":"\"This worksheet \"&Contents!B55","v":"This worksheet collects TSO spend in 2012/13 broken down into different activities and cost types (e.g. direct, indirect and fixed)."}]
["Source: s26 data in 7th s26 (Q2,3,5,6) received on 6th December 2013"]
[null,"Cost type","Costs (£m)"]
["Removed","Direct","Removed","These are projects and activities allocated in individual management accounts. They are already in our non-SG&A cost stack.",null,null,null,null,null,null,null,null,null,null,"Indirect"]
["Removed","Direct","Removed",null,null,null,null,null,null,null,null,null,null,null,"Fixed"]
["Removed","Indirect","Removed"]
["Removed","Indirect","Removed"]
["Removed","Indirect","Removed"]
["Removed","Fixed","Removed"]
["Removed","Fixed","Removed"]
[]
["Total",null,{"$f":"SUM(C5:C11)","v":0}]
[]
["TSO Direct (not already included)",null,{"$f":"C6","v":"Removed"}]
["TSO Indirect",null,{"$f":"SUMIF(B6:B11,\"Indirect\",C6:C11)","v":0}]
["TSO Fixed",null,{"$f":"SUMIF(B6:B11,\"Fixed\",C6:C11)","v":0}]

{"sheet":"MA_data","index":22,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["SG&A and management accounts data",null,null,null,null,null,null,null,null,"Short-run variable","Long-run variable","Fixed"]
[{"$f":"\"This worksheet \"&Contents!B56","v":"This worksheet consolidates all relevant data from the BT Consumer management accounts. It also assigns different characteristics to each line item for the purpose of allocating to the SFBB portfolio."}]
["Source: Summary management accounts. Received 25th June 2013.",null,null,null,null,null,null,null,null,"Customers","Products","Revenues"]
["Summary management accounts - TV. Received 2 October 2013"]
["TSO cost breakdown received 29 November 2013"]
["Units - £000s"]
[]
["Selected options"]
[]
["Approach to allocating long-run variable/fixed",{"$f":"Ctrl_sheet!$C$15","v":"Revenues"}]
[]
["CVEs"]
["Short-run variable",{"$f":"Ctrl_sheet!C16","v":1}]
["Long-run variable",{"$f":"Ctrl_sheet!C17","v":1}]
["Fixed",{"$f":"Ctrl_sheet!C18","v":1}]
[null,null,null,null,null,"Year","FY 12/13"]
["Broadband revenues",null,null,null,null,null,"Removed"]
["Voice revenues",null,null,null,null,null,"Removed"]
["TV revenues",null,null,null,null,null,"Removed"]
[]
["BB accounts","Cost relates to","Type of cost","Cost driver","Cost-voume elasticity (CVE)"]
["Advertising revenues","Broadband","Short-run variable","Customers",{"$f":"INDEX($B$13:$B$14,MATCH(C22,$A$13:$A$14,0))","v":1},null,"Removed"]
[]
["Platforms","Broadband","Short-run variable","Customers",{"$f":"INDEX($B$13:$B$14,MATCH(C24,$A$13:$A$14,0))","v":1},null,"Removed"]
["Portal fees","Broadband","Short-run variable","Customers",1,null,"Removed"]
[]
["SG&A accounts"]
["Marketing - customer retention","BT Consumer","Short-run variable","Customers",{"$f":"INDEX($B$13:$B$14,MATCH(C28,$A$13:$A$14,0))","v":1},null,{"$f":"Marketing!G9","v":0}]
["Marketing - non-campaign","BT Consumer","Long-run variable",{"$f":"$B$10","v":"Revenues"},1,null,{"$f":"Marketing!G13","v":{"$error":"#VALUE!"}}]
["Customer services - other ongoing","BT Consumer","Short-run variable","Products",1,null,{"$f":"SUM(Customer_services!D11:D12)","v":0}]
["Customer services - overheads","BT Consumer","Long-run variable",{"$f":"$B$10","v":"Revenues"},1,null,{"$f":"Customer_services!D13","v":"Removed"}]
["Billing & Bad Debt","BT Consumer","Short-run variable","Customers",1,null,"Removed"]
["TLC (Total Labour cost) - management","BT Consumer","Short-run variable","Products",1,null,"Removed"]
["TLC (Total Labour cost) - retention","BT Consumer","Short-run variable","Customers",1,null,{"$f":"Telesales!B31/1000","v":{"$error":"#VALUE!"}}]
["Other internal/External spend/recoveries","BT Consumer","Long-run variable",{"$f":"$B$10","v":"Revenues"},1,null,"Removed"]
["TSO Fixed costs","BT Consumer","Fixed","Revenues",{"$f":"INDEX($B$13:$B$15,MATCH(C36,$A$13:$A$15,0))","v":1},null,{"$f":"TSO!C17*1000","v":0}]
["People related costs","BT Consumer","Short-run variable","Products",1,null,"Removed"]
["IT spend","BT Consumer","Long-run variable","Revenues",1,null,"Removed"]
["Accommodation","BT Consumer","Long-run variable","Revenues",1,null,"Removed"]
[]
["Centre accounts"]
["Internal charges (driven by TSO)","BT Consumer","Long-run variable",{"$f":"$B$10","v":"Revenues"},{"$f":"INDEX($B$13:$B$14,MATCH(C42,$A$13:$A$14,0))","v":1},null,{"$f":"SUM(TSO!C15:C16)*1000","v":0}]
[]
["Other "]
["Marketing platform spend","BT Consumer","Long-run variable",{"$f":"$B$10","v":"Revenues"},{"$f":"INDEX($B$13:$B$14,MATCH(C45,$A$13:$A$14,0))","v":1},null,"Removed"]
["Miscellaneous costs","BT Consumer","Long-run variable",{"$f":"$B$10","v":"Revenues"},1,null,"Removed"]

{"sheet":"SG&A_&_MA_calc","index":23,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["2012/13 SG&A and management accounts data - allocations"]
[{"$f":"\"This worksheet \"&Contents!B57","v":"This worksheet allocates a proportion of BT Consumer SG&A costs and other costs captured in the management accounts to the SFBB portfolio and calculates unit cost"}]
[]
["Calculation inputs"]
["Ongoing costs"]
["Volumes - average of quarterly customer bases in 2012/13"]
["Voice lines (000s) (BT Consumer base)",{"$f":"AVERAGE(Vol_Consumer!$D$24:$G$24)","v":{"$error":"#DIV/0!"}},"% of base taking BB",{"$f":"B8/B7","v":{"$error":"#DIV/0!"}}]
["BB base (000s)",{"$f":"AVERAGE(Vol_Consumer!$D$33:$G$33)","v":{"$error":"#DIV/0!"}},"% of BB dual-play",{"$f":"(B8-B9)/B8","v":{"$error":"#DIV/0!"}}]
["TV base (000s)",{"$f":"AVERAGE(Vol_Consumer!$D$42:$G$42)","v":{"$error":"#DIV/0!"}},"% of BB triple-play",{"$f":"B9/B8","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"SUM(B7:B9)","v":{"$error":"#DIV/0!"}}]
[null,"No. of products","Customer base","Share of customers","Share of products","Share of revenues"]
["Dual-play",2,{"$f":"B8-B9","v":{"$error":"#DIV/0!"}},{"$f":"$C12/$B$7","v":{"$error":"#DIV/0!"}},{"$f":"($C12*$B12)/$B$10","v":{"$error":"#DIV/0!"}},{"$f":"$D$8*(MA_data!$G$17+MA_data!$G$18*$D$7)/SUM(MA_data!$G$17:$G$19)","v":{"$error":"#DIV/0!"}}]
["Triple-play",3,{"$f":"B9","v":{"$error":"#DIV/0!"}},{"$f":"$C13/$B$7","v":{"$error":"#DIV/0!"}},{"$f":"($C13*$B13)/$B$10","v":{"$error":"#DIV/0!"}},{"$f":"$D$9*(MA_data!$G$17+MA_data!$G$18*$D$7+MA_data!G19)/SUM(MA_data!$G$17:$G$19)","v":{"$error":"#DIV/0!"}}]
[]
["Total mix (dual-play and triple-play)",null,{"$f":"AVERAGE(Vol_Consumer!$D$33:$G$33)","v":{"$error":"#DIV/0!"}},{"$f":"D12+D13","v":{"$error":"#DIV/0!"}},{"$f":"E12+E13","v":{"$error":"#DIV/0!"}},{"$f":"F12+F13","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,"Dual-play","Triple-play","Total mix"]
["Ongoing costs per customer (monthly)","Cost relates to","Type of cost","Cost driver","CVE","Total cost (£000s)","Monthly cost per customer (£)","Monthly cost per customer (£)","Monthly cost per customer (£)"]
["Broadband specific line items","From BB management accounts or have separately been allocated to broadband (e.g. Development)"]
["Advertising revenues",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A21,MA_data!$A$22:$A$47,0))","v":"Broadband"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A21,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A21,MA_data!$A$22:$A$46,0))","v":"Customers"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A21,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A21,MA_data!$A:$A,0))","v":"Removed"},{"$f":"$F21*$E21/$C$15/12","v":{"$error":"#VALUE!"}},{"$f":"$F21*$E21/$C$15/12","v":{"$error":"#VALUE!"}},{"$f":"G21*$D$8+H21*$D$9","v":{"$error":"#VALUE!"}}]
["Platforms",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A22,MA_data!$A$22:$A$47,0))","v":"Broadband"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A22,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A22,MA_data!$A$22:$A$46,0))","v":"Customers"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A22,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A22,MA_data!$A:$A,0))","v":"Removed"},{"$f":"$F22*$E22/$C$15/12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"G22*$D$8+H22*$D$9","v":{"$error":"#VALUE!"}}]
["Portal fees",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A23,MA_data!$A$22:$A$47,0))","v":"Broadband"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A23,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A23,MA_data!$A$22:$A$46,0))","v":"Customers"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A23,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A23,MA_data!$A:$A,0))","v":"Removed"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"G23*$D$8+H23*$D$9","v":{"$error":"#VALUE!"}}]
[]
["SG&A costs (previously allocated)"]
["Customer services - overheads",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A26,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A26,MA_data!$A$22:$A$47,0))","v":"Long-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A26,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A26,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A26,MA_data!$A:$A,0))","v":"Removed"},{"$f":"$E26/$C$12/12*IF($D26=\"Products\",$F26*$E$12,IF($D26=\"Customers\",$F26*$D$12,$F26*$F$12))","v":{"$error":"#DIV/0!"}},{"$f":"$E26/$C$13/12*IF($D26=\"Products\",$F26*$E$13,IF($D26=\"Customers\",$F26*$D$13,$F26*$F$13))","v":{"$error":"#DIV/0!"}},{"$f":"G26*$D$8+H26*$D$9","v":{"$error":"#DIV/0!"}}]
["Customer services - other ongoing",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A27,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A27,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A27,MA_data!$A$22:$A$46,0))","v":"Products"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A27,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A27,MA_data!$A:$A,0))","v":0},{"$f":"$E27/$C$12/12*IF($D27=\"Products\",$F27*$E$12,IF($D27=\"Customers\",$F27*$D$12,$F27*$F$12))","v":{"$error":"#DIV/0!"}},{"$f":"$E27/$C$13/12*IF($D27=\"Products\",$F27*$E$13,IF($D27=\"Customers\",$F27*$D$13,$F27*$F$13))","v":{"$error":"#DIV/0!"}},{"$f":"G27*$D$8+H27*$D$9","v":{"$error":"#DIV/0!"}}]
["Marketing - customer retention",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A28,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A28,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A28,MA_data!$A$22:$A$46,0))","v":"Customers"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A28,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A28,MA_data!$A:$A,0))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G28*$D$8+H28*$D$9","v":{"$error":"#DIV/0!"}}]
["Marketing - non-campaign",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A29,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A29,MA_data!$A$22:$A$47,0))","v":"Long-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A29,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A29,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A29,MA_data!$A:$A,0))","v":{"$error":"#VALUE!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G29*$D$8+H29*$D$9","v":{"$error":"#DIV/0!"}}]
[]
["SG&A costs (previously unallocated)"]
["Billing & Bad Debt",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A32,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A32,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A32,MA_data!$A$22:$A$46,0))","v":"Customers"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A32,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A32,MA_data!$A:$A,0))","v":"Removed"},{"$f":"$E32/$C$12/12*IF($D32=\"Products\",$F32*$E$12,IF($D32=\"Customers\",$F32*$D$12,$F32*$F$12))","v":{"$error":"#DIV/0!"}},{"$f":"$E32/$C$13/12*IF($D32=\"Products\",$F32*$E$13,IF($D32=\"Customers\",$F32*$D$13,$F32*$F$13))","v":{"$error":"#DIV/0!"}},{"$f":"G32*$D$8+H32*$D$9","v":{"$error":"#DIV/0!"}}]
["TLC (Total Labour cost) - management",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A33,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A33,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A33,MA_data!$A$22:$A$46,0))","v":"Products"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A33,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A33,MA_data!$A:$A,0))","v":"Removed"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["TLC (Total Labour cost) - retention",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A34,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A34,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A34,MA_data!$A$22:$A$46,0))","v":"Customers"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A34,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A34,MA_data!$A:$A,0))","v":{"$error":"#VALUE!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Other internal/External spend/recoveries",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A35,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A35,MA_data!$A$22:$A$47,0))","v":"Long-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A35,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A35,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A35,MA_data!$A:$A,0))","v":"Removed"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["TSO Fixed costs",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A36,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A36,MA_data!$A$22:$A$47,0))","v":"Fixed"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A36,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A36,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A36,MA_data!$A:$A,0))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["People related costs",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A37,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A37,MA_data!$A$22:$A$47,0))","v":"Short-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A37,MA_data!$A$22:$A$46,0))","v":"Products"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A37,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A37,MA_data!$A:$A,0))","v":"Removed"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["IT spend",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A38,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A38,MA_data!$A$22:$A$47,0))","v":"Long-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A38,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A38,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A38,MA_data!$A:$A,0))","v":"Removed"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Accommodation",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A39,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A39,MA_data!$A$22:$A$47,0))","v":"Long-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A39,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A39,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A39,MA_data!$A:$A,0))","v":"Removed"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Internal charges (driven by TSO)",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A40,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A40,MA_data!$A$22:$A$47,0))","v":"Long-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A40,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A40,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A40,MA_data!$A:$A,0))","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Marketing platform spend",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A41,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A41,MA_data!$A$22:$A$47,0))","v":"Long-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A41,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A41,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A41,MA_data!$A:$A,0))","v":"Removed"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Miscellaneous costs",{"$f":"INDEX(MA_data!B$22:B$47,MATCH($A42,MA_data!$A$22:$A$47,0))","v":"BT Consumer"},{"$f":"INDEX(MA_data!C$22:C$47,MATCH($A42,MA_data!$A$22:$A$47,0))","v":"Long-run variable"},{"$f":"INDEX(MA_data!D$22:D$46,MATCH($A42,MA_data!$A$22:$A$46,0))","v":"Revenues"},{"$f":"INDEX(MA_data!E$22:E$46,MATCH($A42,MA_data!$A$22:$A$46,0))","v":1},{"$f":"INDEX(MA_data!$G:$G,MATCH($A42,MA_data!$A:$A,0))","v":"Removed"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,"Check"]
["TOTAL - SG&A costs (previously unallocated)",null,null,null,null,null,{"$f":"SUM(G32:G43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H32:H43)","v":{"$error":"#DIV/0!"}},{"$f":"G44*$D$8+H44*$D$9","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I32:I42)","v":{"$error":"#DIV/0!"}}]

{"sheet":"BT_Sport","index":24,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["BT Sport"]
[{"$f":"Contents!B58","v":"calculates monthly net costs of BT Sport per BT Infinity subscriber."}]
["Source: BT's response 130710 to Q2 of the 4th s26 notice; BT's response 130823 to Q31 of the 5th s26 Notice; BT's response 131028 to Q21, Q24 and Q25 of the 6th s26 Notice; BT's response 131129 to Q11 and Q11A of the 7th s26 Notice; "]
["BT's response 131217 to Q21 of the 7th s26 Notice; BT's response 131217 to Q22 of the 7th s26 Notice; BT's response 131216 to Question 23 of the 7th s26 Notice; BT's response 140110 to Q1 of the 8th s26 notice; "]
["BT's response 140120 to Q1 of the 8th s26 notice; BT's response 140218 to Q19 of the 9th s26 notice; BT’s response 140221 to Q25 of the 9th s26 Notice; BT’s response 140221 to Q26 of the 9th s26 Notice; "]
["BT's response 140228 to Q29 of the 9th s26 Notice; BT's response 28022014 to Q32 of the 9th s26 Notice; BT's response 141021 to Q1 of the 21st s135 notice; BT's follow-up response 141023 to Q1 of the 21st s135 notice; "]
["BT's response 141021 to Q3 of the 21st s135 Notice; BT's response 141119 to Q7 of the 25th s135 Notice; BT's response 141119 to Q8 of the 25th s135 Notice"]
[]
["Monthly costs (£m)"]
["Content and programming","Removed"]
["Transmission and distribution","Removed"]
["SG&A","Removed"]
[]
["Less costs incremental to SBB only"]
["DTT multiplex capacity","Removed"]
["Annualised TUTV CA fees","Removed"]
[]
["Less costs incremental to 'free' Sky TV subscribers"]
["CA fees","Removed"]
[]
["Total costs shared to all 'free' SBB and SFBB customers",{"$f":"SUM(B10:B12)-SUM(B15:B19)","v":0}]
[]
["Monthly revenues (£m)"]
["Retail subscription","Removed"]
["Wholesale to Virgin ","Removed"]
["Wholesale to Setanta","Removed"]
["Commercial","Removed"]
["Advertising","Removed"]
[]
["Total revenue",{"$f":"SUM(B24:B28)","v":0}]
[]
["Net costs shared to all 'free' SBB and SFBB customers, per month (£m)",{"$f":"B21-B30","v":0}]
[]
[]
["Net costs per customer, per month (£)"]
["Calculation inputs"]
[]
["SFBB share across all 'free' BT Sport subs","Removed"]
["SFBB share on 'free' Sky TV","Removed"]
["Total BT SFBB base ('000)","Removed"]
["Share of SFBB portfolio customers who incur BT Sport cost","Removed"]
[]
["Net cost per BT Infinity customer",{"$f":"(B32*B38+B19*B39)/B40*1000","v":{"$error":"#VALUE!"}}]
[]
["Net costs per BT SFBB portfolio customer",{"$f":"B43*B41","v":{"$error":"#VALUE!"}}]

{"sheet":"Wholesale_charges","index":25,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Wholesale charges"]
[{"$f":"\"This worksheet \"&Contents!B59","v":"This worksheet collects Openreach charges for wholesale inputs (e.g. GEA, WLR/MPF) and calculates per SFBB customer cost."}]
["Source: ","Openreach price list"]
[]
[]
[null,null,"Jan 2015 charges"]
[null,"Monthly charge (£)"]
[null,"Product"]
[null,"Infinity 1 GEA",-6.9]
[null,"Unlimited Infinity 1 GEA",-7.4]
[null,"Infinity 2 GEA - 80/20 special offer volume discount",-8.4,"See Openreach website for details"]
[null,"Infinity 3 GEA ",-13.15]
[]
[null,"Openreach WLR3 price",-7.58]

{"sheet":"Revenues and WACC-->","index":26,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Prices","index":27,"n_rows":69,"n_cols":6,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Upfront and ongoing revenues"]
[{"$f":"\"This worksheet \"&Contents!B62","v":"This worksheet collects pricing information on Infinity and Plusnet products and selects the relevant data for inclusion in the test."}]
["Source: ","Openreach price list"]
[null,"http://www.productsandservices.bt.com/products/broadband-packages",null,null,"Removed","Removed"]
[]
[null,null,null,"Scenario description","Jan 2015 prices","BT website accessed 05/01/2015"]
[null,"Headline price"]
[null,"Infinity 1",null,null,{"$f":"18/(1+$F$4)","v":{"$error":"#VALUE!"}}]
[null,"Unlimited Infinity 1",null,null,{"$f":"23/(1+$F$4)","v":{"$error":"#VALUE!"}}]
[null,"Infinity 2",null,null,{"$f":"28/(1+$F$4)","v":{"$error":"#VALUE!"}}]
[null,"Infinity 3",null,null,{"$f":"35/(1+$F$4)","v":{"$error":"#VALUE!"}}]
[null,"Plusnet Fibre",null,null,"Removed"]
[]
[null,"Average SAVE discount per SFBB subscriber"]
[null,"Infinity 1",null,null,"Removed"]
[null,"Unlimited Infinity 1",null,null,"Removed"]
[null,"Infinity 2",null,null,"Removed"]
[null,"Infinity 3",null,null,{"$f":"H18","v":0}]
[null,"Plusnet Fibre",null,null,{"$f":"H19","v":0}]
[]
[null,"ARPU (£ excl VAT)"]
[null,"Infinity 1",null,null,{"$f":"IF(E15=0,E8,E8*(1-E15))","v":{"$error":"#VALUE!"}}]
[null,"Unlimited Infinity 1",null,null,{"$f":"IF(E16=0,E9,E9*(1-E16))","v":{"$error":"#VALUE!"}}]
[null,"Infinity 2",null,null,{"$f":"IF(E17=0,E10,E10*(1-E17))","v":{"$error":"#VALUE!"}}]
[null,"Infinity 3",null,null,{"$f":"IF(E18=0,E11,E11*(1-E18))","v":{"$error":"#VALUE!"}}]
[null,"Plusnet Fibre",null,null,{"$f":"IF(E19=0,E12,E12*(1-E19))","v":"Removed"}]
[]
[null,"Plusnet line rental",null,null,"Removed"]
[null,"Plunet average LRS discount",null,null,"Removed"]
[]
[null,"Upfront prices (£ excl VAT)"]
[null,"Connection (standard) - Engineer Managed Install with CP Device",null,null,-99]
[null,"Connection - 80/20 GEA Engineer Managed Install special offer volume discount",null,null,-79,"See Openreach website for details"]
[null,"Activation revenue (excl 18% VAT)",null,null,25.42]
[]
[null,"Discount - Infinity 1",null,null,{"$f":"-(10.5*12/(1+$F$4))+Calls!$B$30","v":{"$error":"#VALUE!"}}]
[null,"Discount - Unlimited Infinity 1",null,null,{"$f":"-(5*12/(1+$F$4))+Calls!$B$30","v":{"$error":"#VALUE!"}}]
[null,"Discount - Infinity 2",null,null,{"$f":"-(3*12/(1+$F$4))+Calls!$B$30","v":{"$error":"#VALUE!"}}]
[null,"Discount - Infinity 3",null,null,{"$f":"Calls!B30","v":{"$error":"#VALUE!"}}]
[null,"Discount - Plusnet",null,null,0]
[]
[]
["Calculation input"]
[]
[null,"% of new to BT customers",{"$f":"SUM(Vol_Consumer_BB_tiers!$K$93:$K$100)/SUM(Vol_Consumer_BB_tiers!$K$26:$K$33)","v":{"$error":"#VALUE!"}},"Acquisition discount only applies to new BT customers only"]
[]
[]
[null,"Model prices"]
[]
[null,"Ongoing (£)"]
[null,{"$f":"B22","v":"Infinity 1"},{"$f":"E22","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B23","v":"Unlimited Infinity 1"},{"$f":"E23","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B24","v":"Infinity 2"},{"$f":"E24","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B25","v":"Infinity 3"},{"$f":"E25","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B26","v":"Plusnet Fibre"},{"$f":"E26","v":"Removed"}]
[]
[null,{"$f":"B28","v":"Plusnet line rental"},{"$f":"E28","v":"Removed"}]
[null,{"$f":"B29","v":"Plunet average LRS discount"},{"$f":"E29","v":"Removed"}]
[]
[null,"Upfront (£)"]
[null,{"$f":"B32","v":"Connection (standard) - Engineer Managed Install with CP Device"},{"$f":"E32","v":-99}]
[null,{"$f":"B33","v":"Connection - 80/20 GEA Engineer Managed Install special offer volume discount"},{"$f":"E33","v":-79}]
[null,{"$f":"B34","v":"Activation revenue (excl 18% VAT)"},{"$f":"E34","v":25.42}]
[]
[null,{"$f":"B36","v":"Discount - Infinity 1"},{"$f":"E36","v":{"$error":"#VALUE!"}},{"$f":"C65*$C$45","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B37","v":"Discount - Unlimited Infinity 1"},{"$f":"E37","v":{"$error":"#VALUE!"}},{"$f":"C66*$C$45","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B38","v":"Discount - Infinity 2"},{"$error":"#VALUE!"},{"$f":"C67*$C$45","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B39","v":"Discount - Infinity 3"},{"$error":"#VALUE!"},{"$f":"C68*$C$45","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B40","v":"Discount - Plusnet"},0,{"$f":"C69*$C$45","v":{"$error":"#VALUE!"}}]

{"sheet":"Line_rental","index":28,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Infinity line rental revenues - 2012/13"]
[{"$f":"\"This worksheet \"&Contents!B63","v":"This worksheet collects data on line rental volumes and prices and calculates the average discount per customer resulting from Line Rental Saver."}]
["Source: S26 data received on 26th June 2013"]
[]
["Inputs"]
[]
["Volumes"]
["Line Rental Saver (LRS) customer base (k)","Removed"]
["BT Consumer customer base (k)","Removed"]
[]
["% of base on LRS",{"$f":"B8/B9","v":{"$error":"#VALUE!"}}]
[]
["Removed","Removed"]
[]
["Prices (incl. VAT)"]
[null,"Jan 2015 prices"]
["Standard line rental",16.989999999999998]
["LRS",159.84]
[]
[]
["Calculations"]
["Discount to Headline Rate"]
["LRS customers - Annual Fee (inc VAT)",{"$f":"B18","v":159.84}]
["LRS customers - Monthly Fee (excl VAT)",{"$f":"B23/12/(1+$B$13)","v":{"$error":"#VALUE!"}}]
["Standard line rental",{"$f":"B17/(1+$B$13)","v":{"$error":"#VALUE!"}}]
["Monthly discount for LRS customers",{"$f":"B25-B24","v":{"$error":"#VALUE!"}}]
[]
["Total discount given (£k)",{"$f":"B8*B26","v":{"$error":"#VALUE!"}}]
["Customer population (k)",{"$f":"B9","v":"Removed"}]
[]
["Monthly average customer discount per customer (£)",{"$f":"B28/B29","v":{"$error":"#VALUE!"}}]

{"sheet":"Usage_charges","index":29,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Out-of-package data usage revenue - 2012/13"]
[{"$f":"\"This worksheet \"&Contents!B64","v":"This worksheet collects monthly usage revenues and customer bases for Infinity 1, as provided by BT, and calculates an average usage revenue per SFBB customer. "}]
["Source: s26 data received on 21 Feb 2014"]
[]
[null,"Average Infinity 1 revenue per customer (£)"]
["2012-04-01","Removed"]
["2012-05-01","Removed"]
["2012-06-01","Removed"]
["2012-07-01","Removed"]
["2012-08-01","Removed"]
["2012-09-01","Removed"]
["2012-10-01","Removed"]
["2012-11-01","Removed"]
["2012-12-01","Removed"]
["2013-01-01","Removed"]
["2013-02-01","Removed"]
["2013-03-01","Removed"]
["2013-04-01","Removed"]
["2013-05-01","Removed"]
["2013-06-01","Removed"]
["2013-07-01","Removed"]
["2013-08-01","Removed"]
["2013-09-01","Removed"]
["2013-10-01","Removed"]
["2013-11-01","Removed"]
["2013-12-01","Removed"]
[]
["Selected options"]
[]
[null,"Selected time period",{"$f":"Ctrl_sheet!$C$28","v":"From beginning of 2013/14"}]
[]
[]
[]
["5 month average (BT estimate)",null,{"$f":"AVERAGE(B6:B10)","v":{"$error":"#DIV/0!"}}]
["2012/13 average",null,{"$f":"AVERAGE(B6:B17)","v":{"$error":"#DIV/0!"}}]
["Average-to-date",null,{"$f":"AVERAGE(B6:B26)","v":{"$error":"#DIV/0!"}}]
["From beginning of 2013/14",null,{"$f":"AVERAGE(B18:B26)","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"C30","v":"From beginning of 2013/14"},null,{"$f":"INDEX($C$34:$C$37,MATCH($A$39,$A$34:$A$37,0))","v":{"$error":"#DIV/0!"}},"From Jan 2014, BT reduced the data cap on Infinity 1 to 20GB. We estimate revenues by taking the revenue mid-point between Infinity 1 40GB and Broadband 10GB."]
[]
["Model usage charges",null,{"$f":"C39","v":{"$error":"#DIV/0!"}}]

{"sheet":"WACC","index":30,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Discount rate - Rest of BT cost of capital"]
[{"$f":"\"This worksheet \"&Contents!B65","v":"This worksheet selects the WACC rate to use to discount ongoing margins. "}]
["Source: 2013 WLR Consultation",null,"http://stakeholders.ofcom.org.uk/binaries/consultations/llu-wlr-cc-13/annexes/annexes.pdf"]
[]
[null,null,"Scenario description","2014 WBA - Nominal","<Add scenario>"]
[]
[null,"WACC - Rest of BT",null,0.108]
[]
["Selected options"]
[]
[null,"Selected WACC",{"$f":"Ctrl_sheet!C32","v":"2014 WBA - Nominal"}]
[]
[]
[]
[null,{"$f":"B7","v":"WACC - Rest of BT"},{"$f":"INDEX($7:$7,,MATCH($C$11,$5:$5,0))","v":0.108}]

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

{"sheet":"Ongoing_revenues","index":32,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Ongoing revenues (£ per month)"]
[]
[null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
["Volume weights - dual-play",{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(B$3,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(C$3,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(D$3,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(E$3,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(F$3,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(B4:F4)","v":{"$error":"#VALUE!"}}]
["Volume weights - triple-play",{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(B3,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(C3,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(D3,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(E3,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(F3,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(B5:F5)","v":{"$error":"#VALUE!"}}]
["Monthly revenue - Dual play"]
[]
["BT Item"]
["Monthly subscription",{"$f":"Prices!C51","v":{"$error":"#VALUE!"}},{"$f":"Prices!C52","v":{"$error":"#VALUE!"}},{"$f":"Prices!C53","v":{"$error":"#VALUE!"}},{"$f":"Prices!C54","v":{"$error":"#VALUE!"}},{"$f":"Prices!C55","v":"Removed"},{"$f":"SUMPRODUCT(B9:F9,$B$4:$F$4)","v":{"$error":"#VALUE!"}}]
["Out of package data usage (Infinity 1 only)",{"$f":"Usage_charges!C41","v":{"$error":"#DIV/0!"}},0,0,0,"Removed",{"$error":"#DIV/0!"}]
["Broadband advertising revenues",{"$f":"'SG&A_&_MA_calc'!$G$21","v":{"$error":"#VALUE!"}},{"$f":"'SG&A_&_MA_calc'!$G$21","v":{"$error":"#VALUE!"}},{"$f":"'SG&A_&_MA_calc'!$G$21","v":{"$error":"#VALUE!"}},{"$f":"'SG&A_&_MA_calc'!$G$21","v":{"$error":"#VALUE!"}},"Removed",{"$error":"#VALUE!"}]
["Line rental",{"$f":"Line_rental!$B$25","v":{"$error":"#VALUE!"}},{"$f":"Line_rental!$B$25","v":{"$error":"#VALUE!"}},{"$f":"Line_rental!$B$25","v":{"$error":"#VALUE!"}},{"$f":"Line_rental!$B$25","v":{"$error":"#VALUE!"}},{"$f":"Prices!C57","v":"Removed"},{"$error":"#VALUE!"}]
["Payment Processing Fees","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["Line rental saver",{"$f":"-Line_rental!$B$31","v":{"$error":"#VALUE!"}},{"$f":"-Line_rental!$B$31","v":{"$error":"#VALUE!"}},{"$f":"-Line_rental!$B$31","v":{"$error":"#VALUE!"}},{"$f":"-Line_rental!$B$31","v":{"$error":"#VALUE!"}},{"$f":"Prices!C58","v":"Removed"},{"$error":"#VALUE!"}]
["Out of package calls calls",{"$f":"Calls!$B$33","v":{"$error":"#VALUE!"}},{"$f":"Calls!$B$33","v":{"$error":"#VALUE!"}},{"$f":"Calls!$B$33","v":{"$error":"#VALUE!"}},{"$f":"Calls!$B$33","v":{"$error":"#VALUE!"}},"Removed",{"$error":"#VALUE!"}]
["Total monthly revenues",{"$f":"SUM(B9:B15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[]
["Monthly revenue - Triple Play"]
["BT Item","Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3",null,"SFBB portfolio"]
[{"$f":"A9","v":"Monthly subscription"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUMPRODUCT(B20:F20,$B$5:$F$5)","v":{"$error":"#VALUE!"}}]
["Out of package data usage (Infinity 1 only)",{"$error":"#DIV/0!"},0,0,0,null,{"$error":"#DIV/0!"}]
[{"$f":"A11","v":"Broadband advertising revenues"},{"$f":"'SG&A_&_MA_calc'!$H$21","v":{"$error":"#VALUE!"}},{"$f":"'SG&A_&_MA_calc'!$H$21","v":{"$error":"#VALUE!"}},{"$f":"'SG&A_&_MA_calc'!$H$21","v":{"$error":"#VALUE!"}},{"$f":"'SG&A_&_MA_calc'!$H$21","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
[{"$f":"A12","v":"Line rental"},{"$f":"B12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[{"$f":"A13","v":"Payment Processing Fees"},"Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
[{"$f":"A14","v":"Line rental saver"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[{"$f":"A15","v":"Out of package calls calls"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[]
["TV First \" months"]
["TV on demand revenues",{"$f":"TV!$B$35","v":0},{"$f":"TV!$B$35","v":0},{"$f":"TV!$B$35","v":0},{"$f":"TV!$B$35","v":0},null,{"$f":"SUMPRODUCT(B29:F29,$B$5:$F$5)","v":{"$error":"#VALUE!"}}]
["TV monthly subscription fee",{"$f":"TV!$B$36","v":0},{"$f":"TV!$B$36","v":0},{"$f":"TV!$B$36","v":0},{"$f":"TV!$B$36","v":0},null,{"$f":"SUMPRODUCT(B30:F30,$B$5:$F$5)","v":{"$error":"#VALUE!"}}]
["TV After first \" months"]
["TV on demand revenues",{"$f":"TV!$C$35","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$35","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$35","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$35","v":{"$error":"#VALUE!"}},null,{"$f":"SUMPRODUCT(B32:F32,$B$5:$F$5)","v":{"$error":"#VALUE!"}}]
["TV monthly subscription fee",{"$f":"TV!$C$36","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$36","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$36","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$36","v":{"$error":"#VALUE!"}},null,{"$f":"SUMPRODUCT(B33:F33,$B$5:$F$5)","v":{"$error":"#VALUE!"}}]
[]
["Total monthly revenues (first \" months)",{"$f":"SUM(B20:B26,B29:B30)","v":{"$error":"#VALUE!"}},{"$f":"SUM(C20:C26,C29:C30)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D20:D26,D29:D30)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E20:E26,E29:E30)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(G20:G27,G29:G30)","v":{"$error":"#VALUE!"}}]
["Total monthly revenues (after first \" months)",{"$f":"SUM(B20:B26,B32:B33)","v":{"$error":"#VALUE!"}},{"$f":"SUM(C20:C26,C32:C33)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(G20:G26,G32:G33)","v":{"$error":"#VALUE!"}}]

{"sheet":"Ongoing_costs","index":33,"n_rows":91,"n_cols":8,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Ongoing costs (£ per month)"]
[null,null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
[null,"Volume weights - dual-play",{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(C$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(D$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(E$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(F$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(G$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(C3:G3)","v":{"$error":"#VALUE!"}}]
[null,"Volume weights - triple-play",{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(C2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(D2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(E2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(F2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(G2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(C4:G4)","v":{"$error":"#VALUE!"}}]
["Monthly wholesale costs - Dual play"]
[]
["BT Item","Type of cost"]
["GEA rental","Direct",{"$f":"Wholesale_charges!C9","v":-6.9},{"$f":"Wholesale_charges!C10","v":-7.4},{"$f":"Wholesale_charges!C11","v":-8.4},{"$f":"Wholesale_charges!C12","v":-13.15},"Removed",{"$f":"SUMPRODUCT(C8:G8,$C$3:$G$3)","v":{"$error":"#VALUE!"}}]
["WLR rental","Direct",{"$f":"Wholesale_charges!$C$14","v":-7.58},{"$f":"Wholesale_charges!$C$14","v":-7.58},{"$f":"Wholesale_charges!$C$14","v":-7.58},{"$f":"Wholesale_charges!$C$14","v":-7.58},{"$f":"Wholesale_charges!$C$14","v":-7.58},{"$f":"SUMPRODUCT(C9:G9,$C$3:$G$3)","v":{"$error":"#VALUE!"}}]
[]
["Total wholesale costs",null,{"$f":"SUM(C8:C9)","v":-14.48},-14.98,-15.98,-20.73,-7.58,{"$error":"#VALUE!"}]
[]
[]
["Monthly downstream costs - Dual play"]
[]
["BT Item - Cost of Sales","Type of cost"]
["Network costs","Direct",{"$f":"-Bandwidth_costs!$I$19","v":{"$error":"#VALUE!"}},{"$f":"-Bandwidth_costs!$I$21","v":{"$error":"#VALUE!"}},{"$f":"-Bandwidth_costs!$I$22","v":{"$error":"#VALUE!"}},{"$f":"-Bandwidth_costs!$I$23","v":{"$error":"#VALUE!"}},"Removed",{"$f":"SUMPRODUCT(C17:G17,$C$3:$G$3)","v":{"$error":"#VALUE!"}}]
["Router replacement","Direct","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["Portal fees","Direct",{"$f":"-'SG&A_&_MA_calc'!$G$23","v":{"$error":"#VALUE!"}},{"$f":"-'SG&A_&_MA_calc'!$G$23","v":{"$error":"#VALUE!"}},{"$f":"-'SG&A_&_MA_calc'!$G$23","v":{"$error":"#VALUE!"}},{"$f":"-'SG&A_&_MA_calc'!$G$23","v":{"$error":"#VALUE!"}},"Removed",{"$error":"#VALUE!"}]
["Platforms","Direct",{"$f":"-Platform!C22","v":{"$error":"#VALUE!"}},{"$f":"-Platform!C23","v":{"$error":"#VALUE!"}},{"$f":"-Platform!C24","v":{"$error":"#VALUE!"}},{"$f":"-Platform!C25","v":{"$error":"#VALUE!"}},"Removed",{"$error":"#VALUE!"}]
["Storage","Direct","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["Anti Virus","Direct","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
[]
["BT Item - Other recurring","Type of cost"]
["[Customer service ongoing - type 1]","Overhead",{"$f":"-Customer_services!$B$33","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$B$33","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$B$33","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$B$33","v":{"$error":"#VALUE!"}},"Removed",{"$f":"SUMPRODUCT(C25:G25,$C$3:$G$3)","v":{"$error":"#VALUE!"}}]
["Customer services - other ongoing","Overhead",{"$f":"-'SG&A_&_MA_calc'!$G$27","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$27","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$27","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$27","v":{"$error":"#DIV/0!"}},"Removed",{"$error":"#DIV/0!"}]
["Customer services - overheads","Overhead",{"$f":"-'SG&A_&_MA_calc'!$G$26","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$26","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$26","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$26","v":{"$error":"#DIV/0!"}},"Removed",{"$error":"#DIV/0!"}]
["Development","Overhead",{"$f":"-Development!$E$70","v":{"$error":"#DIV/0!"}},{"$f":"-Development!$E$70","v":{"$error":"#DIV/0!"}},{"$f":"-Development!$E$70","v":{"$error":"#DIV/0!"}},{"$f":"-Development!$E$70","v":{"$error":"#DIV/0!"}},"Removed",{"$error":"#DIV/0!"}]
["Voice costs","Direct",{"$f":"-Calls!$B$34","v":{"$error":"#DIV/0!"}},{"$f":"-Calls!$B$34","v":{"$error":"#DIV/0!"}},{"$f":"-Calls!$B$34","v":{"$error":"#DIV/0!"}},{"$f":"-Calls!$B$34","v":{"$error":"#DIV/0!"}},"Removed",{"$error":"#DIV/0!"}]
["SG&A costs (other)","Overhead",{"$f":"-'SG&A_&_MA_calc'!$G$44","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$44","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$44","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$44","v":{"$error":"#DIV/0!"}},"Removed",{"$error":"#DIV/0!"}]
["Marketing - customer retention","Overhead",{"$f":"-'SG&A_&_MA_calc'!$G$28","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$28","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$28","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$28","v":{"$error":"#DIV/0!"}},"Removed",{"$error":"#DIV/0!"}]
["Marketing - non-campaign","Overhead",{"$f":"-'SG&A_&_MA_calc'!$G$29","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$29","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$29","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$G$29","v":{"$error":"#DIV/0!"}},"Removed",{"$error":"#DIV/0!"}]
["BT Sport",null,{"$f":"-BT_Sport!$B$43","v":{"$error":"#VALUE!"}},{"$f":"-BT_Sport!$B$43","v":{"$error":"#VALUE!"}},{"$f":"-BT_Sport!$B$43","v":{"$error":"#VALUE!"}},{"$f":"-BT_Sport!$B$43","v":{"$error":"#VALUE!"}},0,{"$error":"#VALUE!"}]
["Plusnet overheads",null,null,null,null,null,{"$f":"SUMIF($B$8:$B$32,\"Direct\",G8:G32)*$G$42","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
["Total downstream costs",null,{"$f":"SUM(C17:C22,C25:C34)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Total monthly costs",null,{"$f":"C11+C36","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Total direct costs",null,{"$f":"SUMIF($B$8:$B$32,\"Direct\",C$8:C$32)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},-7.58,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,"Weighted average"]
["Infinity Overhead costs as a proportion of Direct costs",null,{"$f":"SUMIF($B$8:$B$32,\"Overhead\",C$8:C$32)/SUMIF($B$8:$B$32,\"Direct\",C$8:C$32)","v":{"$error":"#VALUE!"}},{"$f":"SUMIF($B$8:$B$32,\"Overhead\",D$8:D$32)/SUMIF($B$8:$B$32,\"Direct\",D$8:D$32)","v":{"$error":"#VALUE!"}},{"$f":"SUMIF($B$8:$B$32,\"Overhead\",E$8:E$32)/SUMIF($B$8:$B$32,\"Direct\",E$8:E$32)","v":{"$error":"#VALUE!"}},{"$f":"SUMIF($B$8:$B$32,\"Overhead\",F$8:F$32)/SUMIF($B$8:$B$32,\"Direct\",F$8:F$32)","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT($C$42:$F$42,TRANSPOSE(Vol_weights!$D$48:$D$51))/SUM(Vol_weights!$D$48:$D$51)","v":{"$error":"#VALUE!"}}]
[]
["Monthly wholesale costs - Triple play"]
["BT Item",null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3",null,"SFBB portfolio"]
["BT Item","Type of cost"]
[{"$f":"A8","v":"GEA rental"},"Direct",-6.9,-7.4,-8.4,-13.15,null,{"$f":"SUMPRODUCT(C47:G47,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["WLR rental","Direct",-7.58,-7.58,-7.58,-7.58,null,{"$f":"SUMPRODUCT(C48:G48,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
[]
["Total wholesale costs",null,{"$f":"SUM(C47:C48)","v":-14.48},{"$f":"SUM(D47:D48)","v":-14.98},{"$f":"SUM(E47:E48)","v":-15.98},{"$f":"SUM(F47:F48)","v":-20.73},null,{"$f":"SUM(H47:H48)","v":{"$error":"#VALUE!"}}]
[]
["Monthly downstream costs - Triple play"]
["Reduction in TV take-up after \" months",{"$f":"Ctrl_sheet!C24","v":"Removed"}]
[]
["BT Item - Cost of Sales"]
[{"$f":"A17","v":"Network costs"},"Direct",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUMPRODUCT(C56:G56,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["Router replacement","Direct","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
[{"$f":"A19","v":"Portal fees"},"Direct",{"$f":"-'SG&A_&_MA_calc'!$H$23","v":{"$error":"#VALUE!"}},{"$f":"-'SG&A_&_MA_calc'!$H$23","v":{"$error":"#VALUE!"}},{"$f":"-'SG&A_&_MA_calc'!$H$23","v":{"$error":"#VALUE!"}},{"$f":"-'SG&A_&_MA_calc'!$H$23","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
["Platforms","Direct",{"$f":"C20","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
["Storage","Direct","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
["Anti Virus","Direct","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
[]
["BT Item - Other recurring"]
[{"$f":"A25","v":"[Customer service ongoing - type 1]"},"Overhead",{"$f":"-Customer_services!$C$33","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$C$33","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$C$33","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$C$33","v":{"$error":"#VALUE!"}},null,{"$f":"SUMPRODUCT(C64:G64,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["Customer services - other ongoing","Overhead",{"$f":"-'SG&A_&_MA_calc'!$H$27","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$27","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$27","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$27","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["Customer services - overheads","Overhead",{"$f":"-'SG&A_&_MA_calc'!$H$26","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$26","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$26","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$26","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["Development","Overhead",{"$f":"-Development!$E$71","v":{"$error":"#DIV/0!"}},{"$f":"-Development!$E$71","v":{"$error":"#DIV/0!"}},{"$f":"-Development!$E$71","v":{"$error":"#DIV/0!"}},{"$f":"-Development!$E$71","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["Voice costs","Direct",{"$f":"C29","v":{"$error":"#DIV/0!"}},{"$f":"D29","v":{"$error":"#DIV/0!"}},{"$f":"E29","v":{"$error":"#DIV/0!"}},{"$f":"F29","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["SG&A costs (other)","Overhead",{"$f":"-'SG&A_&_MA_calc'!$H$44","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$44","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$44","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$44","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["Marketing - customer retention","Overhead",{"$f":"-'SG&A_&_MA_calc'!$H$28","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$28","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$28","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["Marketing - non-campaign","Overhead",{"$f":"-'SG&A_&_MA_calc'!$H$29","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$29","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$29","v":{"$error":"#DIV/0!"}},{"$f":"-'SG&A_&_MA_calc'!$H$29","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
["BT Sport",0,{"$f":"C33","v":{"$error":"#VALUE!"}},{"$f":"D33","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUMPRODUCT(C72:G72,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
[]
["TV - First \" months"]
["TV costs: content","Direct",{"$f":"TV!$B$40","v":0},{"$f":"TV!$B$40","v":0},{"$f":"TV!$B$40","v":0},{"$f":"TV!$B$40","v":0},null,{"$f":"SUMPRODUCT(C75:G75,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["TV costs: bandwidth/network","Direct",{"$f":"TV!$B$41","v":0},{"$f":"TV!$B$41","v":0},{"$f":"TV!$B$41","v":0},{"$f":"TV!$B$41","v":0},null,{"$f":"SUMPRODUCT(C76:G76,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["TV costs: licenses","Direct",{"$f":"TV!$B$42","v":0},{"$f":"TV!$B$42","v":0},{"$f":"TV!$B$42","v":0},{"$f":"TV!$B$42","v":0},null,{"$f":"SUMPRODUCT(C77:G77,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["TV costs: CPE","Direct",{"$f":"TV!$B$43","v":0},{"$f":"TV!$B$43","v":0},{"$f":"TV!$B$43","v":0},{"$f":"TV!$B$43","v":0},null,{"$f":"SUMPRODUCT(C78:G78,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["TV costs: fixed costs","Direct",{"$f":"TV!$B$44","v":0},{"$f":"TV!$B$44","v":0},{"$f":"TV!$B$44","v":0},{"$f":"TV!$B$44","v":0},null,{"$f":"SUMPRODUCT(C79:G79,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
[]
["TV - After first \" months"]
["TV costs: content","Direct",{"$f":"TV!$C$40","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$40","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$40","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$40","v":{"$error":"#VALUE!"}},null,{"$f":"SUMPRODUCT(C82:G82,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["TV costs: bandwidth/network","Direct",{"$f":"TV!$C$41","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$41","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$41","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$41","v":{"$error":"#VALUE!"}},null,{"$f":"SUMPRODUCT(C83:G83,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["TV costs: licenses","Direct",{"$f":"TV!$C$42","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$42","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$42","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$42","v":{"$error":"#VALUE!"}},null,{"$f":"SUMPRODUCT(C84:G84,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["TV costs: CPE","Direct",{"$f":"TV!$C$43","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$43","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$43","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$43","v":{"$error":"#VALUE!"}},null,{"$f":"SUMPRODUCT(C85:G85,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
["TV costs: fixed costs","Direct",{"$f":"TV!$C$44","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$44","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$44","v":{"$error":"#VALUE!"}},{"$f":"TV!$C$44","v":{"$error":"#VALUE!"}},null,{"$f":"SUMPRODUCT(C86:G86,$C$4:$G$4)","v":{"$error":"#VALUE!"}}]
[]
["TV-only costs downstream costs (first \" months)",null,{"$f":"SUM(C75:C79)","v":0},{"$f":"SUM(D75:D79)","v":0},{"$f":"SUM(E75:E79)","v":0},{"$f":"SUM(F75:F79)","v":0},null,{"$f":"SUM(H75:H79)","v":{"$error":"#VALUE!"}}]
["TV-only costs downstream costs (after first \" months)",null,{"$f":"SUM(C82:C86)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D82:D86)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(H82:H86)","v":{"$error":"#VALUE!"}}]
["Total monthly costs (first \" months)",null,{"$f":"SUM(C56:C72)+C88+C50","v":{"$error":"#VALUE!"}},{"$f":"SUM(D56:D72)+D88+D50","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(H56:H72)+H88+H50","v":{"$error":"#VALUE!"}}]
["Total monthly costs (after first \" months)",null,{"$f":"SUM(C56:C72)*(1-$B$53)+SUM(C17:C32)*$B$53+C89+C50","v":{"$error":"#VALUE!"}},{"$f":"SUM(D56:D72)*(1-$B$53)+SUM(D17:D32)*$B$53+D89+D50","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(H56:H71)*(1-$B$53)+SUM(H17:H32)*$B$53+H89+H50","v":{"$error":"#VALUE!"}}]

{"sheet":"Monthly_margin","index":34,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Net margin (£ per month, per customer), excl. upfront costs"]
[null,"Dual play"]
[null,null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
[null,"Revenue",{"$f":"IF(Ongoing_revenues!B4=0,0,Ongoing_revenues!B16)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!C4=0,0,Ongoing_revenues!C16)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!D4=0,0,Ongoing_revenues!D16)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!E4=0,0,Ongoing_revenues!E16)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!F4=0,0,Ongoing_revenues!F16)","v":{"$error":"#VALUE!"}},{"$f":"Ongoing_revenues!G16","v":{"$error":"#VALUE!"}}]
[null,"Wholesale costs",{"$f":"IF(Ongoing_costs!C3=0,0,Ongoing_costs!C11)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!D3=0,0,Ongoing_costs!D11)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!E3=0,0,Ongoing_costs!E11)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!F3=0,0,Ongoing_costs!F11)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!G3=0,0,Ongoing_costs!G11)","v":{"$error":"#VALUE!"}},{"$f":"Ongoing_costs!H11","v":{"$error":"#VALUE!"}}]
[null,"Operating costs",{"$f":"IF(Ongoing_costs!C3=0,0,Ongoing_costs!C36)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!D3=0,0,Ongoing_costs!D36)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!E3=0,0,Ongoing_costs!E36)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!F3=0,0,Ongoing_costs!F36)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!G3=0,0,Ongoing_costs!G36)","v":{"$error":"#VALUE!"}},{"$f":"Ongoing_costs!H36","v":{"$error":"#VALUE!"}}]
[]
[null,"Ongoing margin per customer per month",{"$f":"SUM(C4:C6)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D4:D6)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(H4:H6)","v":{"$error":"#VALUE!"}}]
[]
[null,"Triple play"]
[null,null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
[null,"Revenue before \" months",{"$f":"IF(Ongoing_revenues!B5=0,0,Ongoing_revenues!B35)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!C5=0,0,Ongoing_revenues!C35)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!D5=0,0,Ongoing_revenues!D35)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!E5=0,0,Ongoing_revenues!E35)","v":{"$error":"#VALUE!"}},null,{"$f":"Ongoing_revenues!G35","v":{"$error":"#VALUE!"}}]
[null,"Revenue after \" months",{"$f":"IF(Ongoing_revenues!B5=0,0,Ongoing_revenues!B36)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!C5=0,0,Ongoing_revenues!C36)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!D5=0,0,Ongoing_revenues!D36)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!E5=0,0,Ongoing_revenues!E36)","v":{"$error":"#VALUE!"}},null,{"$f":"Ongoing_revenues!G36","v":{"$error":"#VALUE!"}}]
[null,"Wholesale costs",{"$f":"IF(Ongoing_costs!C4=0,0,Ongoing_costs!C50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!D4=0,0,Ongoing_costs!D50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!E4=0,0,Ongoing_costs!E50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_costs!F4=0,0,Ongoing_costs!F50)","v":{"$error":"#VALUE!"}},null,{"$f":"Ongoing_costs!H50","v":{"$error":"#VALUE!"}}]
[null,"Operating costs before \" months",{"$f":"IF(Ongoing_revenues!B5=0,0,Ongoing_costs!C90-Ongoing_costs!C50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!C5=0,0,Ongoing_costs!D90-Ongoing_costs!D50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!D5=0,0,Ongoing_costs!E90-Ongoing_costs!E50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!E5=0,0,Ongoing_costs!F90-Ongoing_costs!F50)","v":{"$error":"#VALUE!"}},null,{"$f":"Ongoing_costs!H90-Ongoing_costs!H50","v":{"$error":"#VALUE!"}}]
[null,"Operating costs after \" months",{"$f":"IF(Ongoing_revenues!B5=0,0,Ongoing_costs!C91-Ongoing_costs!C50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!C5=0,0,Ongoing_costs!D91-Ongoing_costs!D50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!D5=0,0,Ongoing_costs!E91-Ongoing_costs!E50)","v":{"$error":"#VALUE!"}},{"$f":"IF(Ongoing_revenues!E5=0,0,Ongoing_costs!F91-Ongoing_costs!F50)","v":{"$error":"#VALUE!"}},null,{"$f":"Ongoing_costs!H91-Ongoing_costs!H50","v":{"$error":"#VALUE!"}}]
[]
[null,"Ongoing margin per customer up to \" months",{"$f":"C12+SUM(C14:C15)","v":{"$error":"#VALUE!"}},{"$f":"D12+SUM(D14:D15)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"H12+SUM(H14:H15)","v":{"$error":"#VALUE!"}}]
[null,"Ongoing margin per customer after \" months",{"$f":"SUM(C13:C14)+C16","v":{"$error":"#VALUE!"}},{"$f":"SUM(D13:D14)+D16","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(H13:H14)+H16","v":{"$error":"#VALUE!"}}]
[]
[null,"Total mix (dual-play and triple-play)"]
[null,null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
[null,"Dual-play %",{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(C$22,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(D$22,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(E$22,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(F$22,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(G$22,Vol_weights!$B$57:$B$61,0))","v":0},{"$f":"Vol_weights!$D$63","v":{"$error":"#VALUE!"}}]
[null,"Triple-play %",{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(C$22,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(D$22,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(E$22,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(F$22,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(G$22,Vol_weights!$B$57:$B$61,0))","v":0},{"$f":"Vol_weights!$E$63","v":{"$error":"#VALUE!"}}]
[]
[null,"Revenue before \" months",{"$f":"C$4*C$23+C12*C$24","v":{"$error":"#VALUE!"}},{"$f":"D$4*D$23+D12*D$24","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"H$4*H$23+H12*H$24","v":{"$error":"#VALUE!"}}]
[null,"Revenue after \"months",{"$f":"C$4*C$23+C13*C$24","v":{"$error":"#VALUE!"}},{"$f":"D$4*D$23+D13*D$24","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"H$4*H$23+H13*H$24","v":{"$error":"#VALUE!"}}]
[null,"Wholesale costs",{"$f":"C5*C$23+C14*C$24","v":{"$error":"#VALUE!"}},{"$f":"D5*D$23+D14*D$24","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"H5*H$23+H14*H$24","v":{"$error":"#VALUE!"}}]
[null,"Operating costs before \" months",{"$f":"(C6*C$23+C15*C$24)","v":{"$error":"#VALUE!"}},{"$f":"(D6*D$23+D15*D$24)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(H6*H$23+H15*H$24)","v":{"$error":"#VALUE!"}}]
[null,"Operating costs after \" months",{"$f":"C6*C$23+C16*C$24","v":{"$error":"#VALUE!"}},{"$f":"D6*D$23+D16*D$24","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(H6*H$23+H16*H$24)","v":{"$error":"#VALUE!"}}]
[]
[null,"Ongoing margin per customer up to \" months",{"$f":"C26+SUM(C28:C29)","v":{"$error":"#VALUE!"}},{"$f":"D26+SUM(D28:D29)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"H26+SUM(H28:H29)","v":{"$error":"#VALUE!"}}]
[null,"Ongoing margin per customer after \" months",{"$f":"C27+SUM(C28,C30)","v":{"$error":"#VALUE!"}},{"$f":"D27+SUM(D28,D30)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Upfront_costs","index":35,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["One-off net costs costs (£ per customer)"]
[null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
["Volume weights - dual-play",{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(B$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(C$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(D$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(E$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$48:$E$52,MATCH(F$2,Vol_weights!$B$48:$B$52,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(B3:F3)","v":{"$error":"#VALUE!"}}]
["Volume weights - triple-play",{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(B2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(C2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(D2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(E2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$39:$E$43,MATCH(F2,Vol_weights!$B$39:$B$43,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(B4:F4)","v":{"$error":"#VALUE!"}}]
["Upfront costs - Dual play"]
[]
["BT Item"]
["Connection charge",-99,-99,{"$f":"Prices!C62","v":-79},-99,-99,{"$f":"SUMPRODUCT(B8:F8,$B$3:$F$3)","v":{"$error":"#VALUE!"}}]
["Activation revenue",{"$f":"Prices!$C$63","v":25.42},{"$f":"Prices!$C$63","v":25.42},0,0,"Removed",{"$error":"#VALUE!"}]
["Discounts",{"$f":"Prices!$D$65","v":{"$error":"#VALUE!"}},{"$f":"Prices!$D$66","v":{"$error":"#VALUE!"}},{"$f":"Prices!$D$67","v":{"$error":"#VALUE!"}},{"$f":"Prices!$D$68","v":{"$error":"#VALUE!"}},"Removed",{"$error":"#VALUE!"}]
["CPE P&P revenue","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["CPE P&P COS","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["CPE other COS",{"$f":"-CPE!$B$14","v":{"$error":"#VALUE!"}},{"$f":"-CPE!$B$14","v":{"$error":"#VALUE!"}},{"$f":"-CPE!$B$14","v":{"$error":"#VALUE!"}},{"$f":"-CPE!$B$14","v":{"$error":"#VALUE!"}},"Removed",{"$error":"#VALUE!"}]
["Vouchers","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["Sales",{"$f":"-Telesales!$B$24","v":{"$error":"#VALUE!"}},{"$f":"-Telesales!$B$24","v":{"$error":"#VALUE!"}},{"$f":"-Telesales!$B$24","v":{"$error":"#VALUE!"}},{"$f":"-Telesales!$B$24","v":{"$error":"#VALUE!"}},{"$f":"-Telesales!$B$24","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
["Marketing",{"$f":"-Marketing!$G$35","v":{"$error":"#DIV/0!"}},{"$f":"-Marketing!$G$35","v":{"$error":"#DIV/0!"}},{"$f":"-Marketing!$G$35","v":{"$error":"#DIV/0!"}},{"$f":"-Marketing!$G$35","v":{"$error":"#DIV/0!"}},{"$f":"-Marketing!$G$35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Fibre development cost","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["WLR connection",{"$f":"Line_acquisition!$B$23","v":{"$error":"#VALUE!"}},{"$f":"Line_acquisition!$B$23","v":{"$error":"#VALUE!"}},{"$f":"Line_acquisition!$B$23","v":{"$error":"#VALUE!"}},{"$f":"Line_acquisition!$B$23","v":{"$error":"#VALUE!"}},"Removed",{"$error":"#VALUE!"}]
["BT Openreach amendments","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["BT Expedites","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["BT Abortive Visits","Removed","Removed","Removed","Removed","Removed",{"$error":"#VALUE!"}]
["[Customer service upfront]",{"$f":"-Customer_services!$B$29","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$B$29","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$B$29","v":{"$error":"#VALUE!"}},{"$f":"-Customer_services!$B$29","v":{"$error":"#VALUE!"}},"Removed",{"$error":"#VALUE!"}]
["Affiliates/Pay per click",{"$f":"-Affiliates!$B$31","v":{"$error":"#VALUE!"}},{"$f":"-Affiliates!$B$31","v":{"$error":"#VALUE!"}},{"$f":"-Affiliates!$B$31","v":{"$error":"#VALUE!"}},{"$f":"-Affiliates!$B$31","v":{"$error":"#VALUE!"}},{"$f":"-Affiliates!$B$31","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
["Total upfront costs",{"$f":"SUM(B8:B23)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["Upfront costs - Triple play"]
[]
["BT Item","Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3",null,"SFBB portfolio"]
[{"$f":"A8","v":"Connection charge"},-99,-99,-79,-99,null,{"$f":"SUMPRODUCT(B31:F31,$B$4:$F$4)","v":{"$error":"#VALUE!"}}]
["Activation revenue",25.42,25.42,0,0,null,{"$f":"SUMPRODUCT(B32:F32,$B$4:$F$4)","v":{"$error":"#VALUE!"}}]
["Discounts",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUMPRODUCT(B33:F33,$B$3:$F$3)","v":{"$error":"#VALUE!"}}]
["CPE P&P revenue","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
["CPE P&P COS","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
["CPE other COS",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
["Vouchers","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
[{"$f":"A15","v":"Sales"},{"$f":"-Telesales!$C$24","v":{"$error":"#VALUE!"}},{"$f":"-Telesales!$C$24","v":{"$error":"#VALUE!"}},{"$f":"-Telesales!$C$24","v":{"$error":"#VALUE!"}},{"$f":"-Telesales!$C$24","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
["Marketing",{"$f":"B16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
["Fibre development cost","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
["WLR connection",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
["BT Openreach amendments","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
["BT Expedites","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
["BT Abortive Visits","Removed","Removed","Removed","Removed",null,{"$error":"#VALUE!"}]
["[Customer service upfront]",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
["Affiliates/Pay per click",{"$f":"-Affiliates!$B$32","v":{"$error":"#VALUE!"}},{"$f":"-Affiliates!$B$32","v":{"$error":"#VALUE!"}},{"$f":"-Affiliates!$B$32","v":{"$error":"#VALUE!"}},{"$f":"-Affiliates!$B$32","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"}]
[]
["TV activation fee",{"$f":"TV!$B$48","v":0},{"$f":"TV!$B$48","v":0},{"$f":"TV!$B$48","v":0},{"$f":"TV!$B$48","v":0},null,{"$f":"SUMPRODUCT(B48:F48,$B$3:$F$3)","v":{"$error":"#VALUE!"}}]
["TV delivery charge",{"$f":"TV!$B$49","v":0},{"$f":"TV!$B$49","v":0},{"$f":"TV!$B$49","v":0},{"$f":"TV!$B$49","v":0},null,{"$f":"SUMPRODUCT(B49:F49,$B$3:$F$3)","v":{"$error":"#VALUE!"}}]
["TV box costs (2012/13)",{"$f":"TV!$B$50","v":0},{"$f":"TV!$B$50","v":0},{"$f":"TV!$B$50","v":0},{"$f":"TV!$B$50","v":0},null,{"$f":"SUMPRODUCT(B50:F50,$B$3:$F$3)","v":{"$error":"#VALUE!"}}]
["Other TV acquisition costs",{"$f":"TV!$B$51","v":0},{"$f":"TV!$B$51","v":0},{"$f":"TV!$B$51","v":0},{"$f":"TV!$B$51","v":0},null,{"$f":"SUMPRODUCT(B51:F51,$B$3:$F$3)","v":{"$error":"#VALUE!"}}]
[]
["Total upfront costs",{"$f":"SUM(B31:B51)","v":{"$error":"#VALUE!"}},{"$f":"SUM(C31:C51)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D31:D51)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E31:E51)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(G31:G51)","v":{"$error":"#VALUE!"}}]
[]
[]
["Upfront costs - Total mix (dual-play and triple-play)","Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
["Dual-play %",{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(B$56,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(C$56,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(D$56,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(E$56,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$D$57:$D$61,MATCH(F$56,Vol_weights!$B$57:$B$61,0))","v":0},{"$f":"Vol_weights!$D$63","v":{"$error":"#VALUE!"}}]
["Triple-play %",{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(B$56,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(C$56,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(D$56,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(E$56,Vol_weights!$B$57:$B$61,0))","v":{"$error":"#VALUE!"}},{"$f":"INDEX(Vol_weights!$E$57:$E$61,MATCH(F$56,Vol_weights!$B$57:$B$61,0))","v":0},{"$f":"Vol_weights!$E$63","v":{"$error":"#VALUE!"}}]
[]
["Total upfront costs",{"$f":"B25*B57+B53*B58","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"DCF_analysis","index":36,"n_rows":317,"n_cols":9,"rows_kept":317,"cut":false,"hidden":false,"merged":[]}
["DCF analysis"]
[null,"Selected bundles",{"$f":"Ctrl_sheet!C5","v":"Total mix (dual-play and triple-play)"}]
[null,"Discount rate",{"$f":"WACC!$C$15","v":0.108}]
[]
[null,"Volume weights",{"$f":"IF(Ctrl_sheet!$C$5=\"Dual-play\",INDEX(Vol_weights!$E$48:$E$52,MATCH(C6,Vol_weights!$B$48:$B$52,0)),IF(Ctrl_sheet!$C$5=\"Triple-play\",INDEX(Vol_weights!$E$39:$E$43,MATCH(C6,Vol_weights!$B$39:$B$43,0)),INDEX(Vol_weights!$E$30:$E$34,MATCH(C6,Vol_weights!$B$30:$B$34,0))))","v":{"$error":"#VALUE!"}},{"$f":"IF(Ctrl_sheet!$C$5=\"Dual-play\",INDEX(Vol_weights!$E$48:$E$52,MATCH(D6,Vol_weights!$B$48:$B$52,0)),IF(Ctrl_sheet!$C$5=\"Triple-play\",INDEX(Vol_weights!$E$39:$E$43,MATCH(D6,Vol_weights!$B$39:$B$43,0)),INDEX(Vol_weights!$E$30:$E$34,MATCH(D6,Vol_weights!$B$30:$B$34,0))))","v":{"$error":"#VALUE!"}},{"$f":"IF(Ctrl_sheet!$C$5=\"Dual-play\",INDEX(Vol_weights!$E$48:$E$52,MATCH(E6,Vol_weights!$B$48:$B$52,0)),IF(Ctrl_sheet!$C$5=\"Triple-play\",INDEX(Vol_weights!$E$39:$E$43,MATCH(E6,Vol_weights!$B$39:$B$43,0)),INDEX(Vol_weights!$E$30:$E$34,MATCH(E6,Vol_weights!$B$30:$B$34,0))))","v":{"$error":"#VALUE!"}},{"$f":"IF(Ctrl_sheet!$C$5=\"Dual-play\",INDEX(Vol_weights!$E$48:$E$52,MATCH(F6,Vol_weights!$B$48:$B$52,0)),IF(Ctrl_sheet!$C$5=\"Triple-play\",INDEX(Vol_weights!$E$39:$E$43,MATCH(F6,Vol_weights!$B$39:$B$43,0)),INDEX(Vol_weights!$E$30:$E$34,MATCH(F6,Vol_weights!$B$30:$B$34,0))))","v":{"$error":"#VALUE!"}},{"$f":"IF(Ctrl_sheet!$C$5=\"Dual-play\",INDEX(Vol_weights!$E$48:$E$52,MATCH(G6,Vol_weights!$B$48:$B$52,0)),IF(Ctrl_sheet!$C$5=\"Triple-play\",INDEX(Vol_weights!$E$39:$E$43,MATCH(G6,Vol_weights!$B$39:$B$43,0)),INDEX(Vol_weights!$E$30:$E$34,MATCH(G6,Vol_weights!$B$30:$B$34,0))))","v":{"$error":"#VALUE!"}},{"$f":"SUM(C5:G5)","v":{"$error":"#VALUE!"}}]
[null,null,"Infinity 1","Unlimited Infinity 1","Infinity 2","Infinity 3","Plusnet Fibre","SFBB portfolio"]
[null,"Upfront costs (£)",{"$f":"IF(Upfront_costs!B3=0,0,IF($C$2=\"Dual-play\",Upfront_costs!B25,IF($C$2=\"Triple-play\",Upfront_costs!B53,Upfront_costs!B60)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Upfront_costs!C3=0,0,IF($C$2=\"Dual-play\",Upfront_costs!C25,IF($C$2=\"Triple-play\",Upfront_costs!C53,Upfront_costs!C60)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Upfront_costs!D3=0,0,IF($C$2=\"Dual-play\",Upfront_costs!D25,IF($C$2=\"Triple-play\",Upfront_costs!D53,Upfront_costs!D60)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Upfront_costs!E3=0,0,IF($C$2=\"Dual-play\",Upfront_costs!E25,IF($C$2=\"Triple-play\",Upfront_costs!E53,Upfront_costs!E60)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Upfront_costs!F3=0,0,IF($C$2=\"Dual-play\",Upfront_costs!F25,IF($C$2=\"Triple-play\",Upfront_costs!F53,Upfront_costs!F60)))","v":{"$error":"#VALUE!"}},{"$f":"SUMPRODUCT(C7:G7,$C$5:$G$5)","v":{"$error":"#VALUE!"}}]
[null,"Monthly margin up to \" months (£)",{"$f":"IF(Monthly_margin!C$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!C8,IF($C$2=\"Triple-play\",Monthly_margin!C18,Monthly_margin!C32)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Monthly_margin!D$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!D8,IF($C$2=\"Triple-play\",Monthly_margin!D18,Monthly_margin!D32)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Monthly_margin!E$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!E8,IF($C$2=\"Triple-play\",Monthly_margin!E18,Monthly_margin!E32)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Monthly_margin!F$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!F8,IF($C$2=\"Triple-play\",Monthly_margin!F18,Monthly_margin!F32)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Monthly_margin!G$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!G8,IF($C$2=\"Triple-play\",Monthly_margin!G18,Monthly_margin!G32)))","v":0},{"$f":"SUMPRODUCT(C8:G8,$C$5:$G$5)-H13","v":{"$error":"#VALUE!"}}]
[null,"Monthly margin after \" months (£)",{"$f":"IF(Monthly_margin!C$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!C8,IF($C$2=\"Triple-play\",Monthly_margin!C19,Monthly_margin!C33)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Monthly_margin!D$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!D8,IF($C$2=\"Triple-play\",Monthly_margin!D19,Monthly_margin!D33)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Monthly_margin!E$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!E8,IF($C$2=\"Triple-play\",Monthly_margin!E19,Monthly_margin!E33)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Monthly_margin!F$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!F8,IF($C$2=\"Triple-play\",Monthly_margin!F19,Monthly_margin!F33)))","v":{"$error":"#VALUE!"}},{"$f":"IF(Monthly_margin!G$23=0,0,IF($C$2=\"Dual-play\",Monthly_margin!G8,IF($C$2=\"Triple-play\",Monthly_margin!G19,Monthly_margin!G33)))","v":0},{"$f":"SUMPRODUCT(C9:G9,$C$5:$G$5)-H13","v":{"$error":"#VALUE!"}}]
[]
[null,"Payback period (years)",{"$f":"IF(C17=0,0,IF(MATCH(0,C17:C317)/12>25,\"> 25\",MATCH(0,C17:C317)/12))","v":{"$error":"#VALUE!"}},{"$f":"IF(D17=0,0,IF(MATCH(0,D17:D317)/12>25,\"> 25\",MATCH(0,D17:D317)/12))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(H17=0,0,IF(MATCH(0,H17:H317)/12>25,\"> 25\",MATCH(0,H17:H317)/12))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,"VULA margin headroom"]
["Discounted payback calculations"]
[null,"Assumed point in ACL when TV take-up reduces (months)",{"$f":"Ctrl_sheet!C23","v":"Removed"}]
["Years","Months"]
[null,0,{"$f":"IF($B17=0,C$7,IF($B17<=$C$15,C16+(C$8/(1+$C$3)^($B17/12)),C16+(C$9/(1+$C$3)^($B17/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B17=0,D$7,IF($B17<=$C$15,D16+(D$8/(1+$C$3)^($B17/12)),D16+(D$9/(1+$C$3)^($B17/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B17=0,E$7,IF($B17<=$C$15,E16+(E$8/(1+$C$3)^($B17/12)),E16+(E$9/(1+$C$3)^($B17/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B17=0,F$7,IF($B17<=$C$15,F16+(F$8/(1+$C$3)^($B17/12)),F16+(F$9/(1+$C$3)^($B17/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B17=0,G$7,IF($B17<=$C$15,G16+(G$8/(1+$C$3)^($B17/12)),G16+(G$9/(1+$C$3)^($B17/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B17=0,H$7,IF($B17<=$C$15,H16+(H$8/(1+$C$3)^($B17/12)),H16+(H$9/(1+$C$3)^($B17/12))))","v":{"$error":"#VALUE!"}}]
[null,1,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,5,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,6,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,7,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,8,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,9,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,10,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,11,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[1,12,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,13,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,14,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,16,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,17,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,18,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,19,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,20,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,21,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,22,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,23,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[2,24,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,25,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,26,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,27,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,29,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,32,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,33,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,34,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,35,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[3,36,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,37,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,38,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,39,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,40,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,41,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,42,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,43,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,44,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,45,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,46,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,47,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,48,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,49,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,50,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,51,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,52,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,53,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,54,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,55,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,56,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,57,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,58,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,59,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,60,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,61,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,62,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,63,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,64,{"$f":"IF($B81=0,C$7,IF($B81<=$C$15,C80+(C$8/(1+$C$3)^($B81/12)),C80+(C$9/(1+$C$3)^($B81/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B81=0,D$7,IF($B81<=$C$15,D80+(D$8/(1+$C$3)^($B81/12)),D80+(D$9/(1+$C$3)^($B81/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B81=0,E$7,IF($B81<=$C$15,E80+(E$8/(1+$C$3)^($B81/12)),E80+(E$9/(1+$C$3)^($B81/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B81=0,F$7,IF($B81<=$C$15,F80+(F$8/(1+$C$3)^($B81/12)),F80+(F$9/(1+$C$3)^($B81/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B81=0,G$7,IF($B81<=$C$15,G80+(G$8/(1+$C$3)^($B81/12)),G80+(G$9/(1+$C$3)^($B81/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B81=0,H$7,IF($B81<=$C$15,H80+(H$8/(1+$C$3)^($B81/12)),H80+(H$9/(1+$C$3)^($B81/12))))","v":{"$error":"#VALUE!"}}]
[null,65,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,66,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,67,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,68,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,69,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,70,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,71,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,72,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,73,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,74,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,75,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,76,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,77,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,78,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,79,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,80,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,81,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,82,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,83,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[7,84,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,85,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,86,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,87,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,88,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,89,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,90,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,91,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,92,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,93,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,94,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,95,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[8,96,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,97,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,98,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,99,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,100,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,101,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,102,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,103,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,104,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,105,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,106,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,107,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[9,108,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,109,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,110,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,111,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,112,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,113,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,114,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,115,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,116,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,117,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,118,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,119,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[10,120,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,121,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,122,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,123,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,124,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,125,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,126,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,127,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,128,{"$f":"IF($B145=0,C$7,IF($B145<=$C$15,C144+(C$8/(1+$C$3)^($B145/12)),C144+(C$9/(1+$C$3)^($B145/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B145=0,D$7,IF($B145<=$C$15,D144+(D$8/(1+$C$3)^($B145/12)),D144+(D$9/(1+$C$3)^($B145/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B145=0,E$7,IF($B145<=$C$15,E144+(E$8/(1+$C$3)^($B145/12)),E144+(E$9/(1+$C$3)^($B145/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B145=0,F$7,IF($B145<=$C$15,F144+(F$8/(1+$C$3)^($B145/12)),F144+(F$9/(1+$C$3)^($B145/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B145=0,G$7,IF($B145<=$C$15,G144+(G$8/(1+$C$3)^($B145/12)),G144+(G$9/(1+$C$3)^($B145/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B145=0,H$7,IF($B145<=$C$15,H144+(H$8/(1+$C$3)^($B145/12)),H144+(H$9/(1+$C$3)^($B145/12))))","v":{"$error":"#VALUE!"}}]
[null,129,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,130,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,131,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[11,132,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,133,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,134,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,135,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,136,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,137,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,138,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,139,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,140,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,141,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,142,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,143,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[12,144,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,145,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,146,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,147,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,148,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,149,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,150,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,151,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,152,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,153,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,154,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,155,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[13,156,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,157,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,158,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,159,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,160,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,161,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,162,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,163,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,164,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,165,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,166,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,167,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[14,168,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,169,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,170,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,171,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,172,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,173,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,174,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,175,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,176,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,177,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,178,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,179,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[15,180,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,181,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,182,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,183,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,184,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,185,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,186,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,187,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,188,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,189,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,190,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,191,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[16,192,{"$f":"IF($B209=0,C$7,IF($B209<=$C$15,C208+(C$8/(1+$C$3)^($B209/12)),C208+(C$9/(1+$C$3)^($B209/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B209=0,D$7,IF($B209<=$C$15,D208+(D$8/(1+$C$3)^($B209/12)),D208+(D$9/(1+$C$3)^($B209/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B209=0,E$7,IF($B209<=$C$15,E208+(E$8/(1+$C$3)^($B209/12)),E208+(E$9/(1+$C$3)^($B209/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B209=0,F$7,IF($B209<=$C$15,F208+(F$8/(1+$C$3)^($B209/12)),F208+(F$9/(1+$C$3)^($B209/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B209=0,G$7,IF($B209<=$C$15,G208+(G$8/(1+$C$3)^($B209/12)),G208+(G$9/(1+$C$3)^($B209/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B209=0,H$7,IF($B209<=$C$15,H208+(H$8/(1+$C$3)^($B209/12)),H208+(H$9/(1+$C$3)^($B209/12))))","v":{"$error":"#VALUE!"}}]
[null,193,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,194,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,195,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,196,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,197,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,198,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,199,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,200,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,201,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,202,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,203,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[17,204,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,205,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,206,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,207,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,208,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,209,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,210,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,211,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,212,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,213,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,214,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,215,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[18,216,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,217,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,218,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,219,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,220,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,221,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,222,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,223,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,224,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,225,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,226,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,227,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[19,228,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,229,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,230,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,231,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,232,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,233,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,234,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,235,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,236,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,237,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,238,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,239,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[20,240,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,241,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,242,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,243,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,244,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,245,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,246,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,247,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,248,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,249,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,250,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,251,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[21,252,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,253,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,254,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,255,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,256,{"$f":"IF($B273=0,C$7,IF($B273<=$C$15,C272+(C$8/(1+$C$3)^($B273/12)),C272+(C$9/(1+$C$3)^($B273/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B273=0,D$7,IF($B273<=$C$15,D272+(D$8/(1+$C$3)^($B273/12)),D272+(D$9/(1+$C$3)^($B273/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B273=0,E$7,IF($B273<=$C$15,E272+(E$8/(1+$C$3)^($B273/12)),E272+(E$9/(1+$C$3)^($B273/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B273=0,F$7,IF($B273<=$C$15,F272+(F$8/(1+$C$3)^($B273/12)),F272+(F$9/(1+$C$3)^($B273/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B273=0,G$7,IF($B273<=$C$15,G272+(G$8/(1+$C$3)^($B273/12)),G272+(G$9/(1+$C$3)^($B273/12))))","v":{"$error":"#VALUE!"}},{"$f":"IF($B273=0,H$7,IF($B273<=$C$15,H272+(H$8/(1+$C$3)^($B273/12)),H272+(H$9/(1+$C$3)^($B273/12))))","v":{"$error":"#VALUE!"}}]
[null,257,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,258,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,259,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,260,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,261,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,262,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,263,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[22,264,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,265,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,266,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,267,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,268,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,269,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,270,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,271,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,272,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,273,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,274,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,275,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[23,276,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,277,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,278,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,279,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,280,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,281,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,282,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,283,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,284,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,285,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,286,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,287,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[24,288,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,289,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,290,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,291,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,292,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,293,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,294,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,295,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,296,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,297,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,298,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,299,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[25,300,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]