Spreadsheet: 94744d1294476807-replace-hard-coded-array-in-formula-with-link-to-input-array-test-6
Sheet: Hayys BF CAPEX

Brownfield Fibre Overlay CAPEX Model
 |  |  | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | Example only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] in this schedule can be copied accross. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note - formulas in this schedule cannot be copied accross - some formulas are different, CHECK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note - formulas in this schedule cannot be copied accross - some formulas are different, CHECK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cumulative units numbers at each point in [NAME].  Note - a unit refers to a premises (not a customer which may have multiple premises). |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Brownfield |  |  |  |  |  | Primary Network Remediation Upgrade |  |  |  |  |  |  | Access Upgrade |  |  |  |  |  | [NAME] (Y/N) |  |  | Indicator |  |  | Summary Units |  |  | H'H Premesis Mix |  |  |  |  | Corporate Mix |  |  |  | Corporate MTU % Mix |  |  |  | Corporate MTU Mix |  |  |  | H'H Premesis % Mix |  |  |  |  | Corporate % Mix |  |  |  | MDU (Multi-Dwelling Unit) - Residential |  |  |  |  | MTU (Multi-Tenancy Unit) - Corporate |  |  |  |  | Corporate |  | Total |  | Current Service Status: |  |  |  |  | Current Network Status |  |  |  |  |  | Current Civils Status |  |  |  |  | Central Office through to 2nd Cabinet |  |  |  | C1 to [NAME] (a-c) |  |  | C1/JB1(a)/JB2 (a-c) |  |  | C1/JB1(b)/JB2 (a-c) |  |  | C1/JB1(c)/JB2 (a-c) |  |  | C1/JB1(a)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(c)/JB3 (a to c) |  |  |  | Central Office through to 2nd Cabinet |  |  |  | C1 to [NAME] (a-c) |  |  | C1/JB1(a)/JB2 (a-c) |  |  | C1/JB1(b)/JB2 (a-c) |  |  | C1/JB1(c)/JB2 (a-c) |  |  | C1/JB1(a)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(c)/JB3 (a to c) |  |  |  | Qty of derived cable types to min cost/seg |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1/JB1(a)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(c)/JB3 (a to c) |  |  |  | Cable Type (fibres per cable) - achieves min cost / segment |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1/JB1(a)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(c)/JB3 (a to c) |  |  |  | Corporate Filaments Required / segment |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1/JB1(a)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(c)/JB3 (a to c) |  |  |  | H'H & Micro Fibre Filaments Required / segment |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1/JB1(a)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(c)/JB3 (a to c) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1/JB1(a)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(a)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(b)/JB2(c)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(a)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(b)/JB3 (a to c) |  |  | C1/JB1(c)/JB2(c)/JB3 (a to c) |  |  |  | CO to PN |  |  |  |  | PN to Cabinet |  |  |  |  | Cabinet - across all JB's to Premesis
 | [NAME] | ID | Type Node | Mother PN ID for C ID | Mother CO ID for PN ID |  | CO to PN | Upgrade Decision | Date (Yr.) | PN to C | Upgrade Decision | Date (Yr.) |  | Corp Tech | H'H & Micro Tech. | Min Service | Max Service | Date (Yr.) |  | JB1 | JB2 |  | Rev/Line | Density |  | HH & SME | Corp. |  | Single Units | MDU (3-19 Flats) | MDU (20-64 Flats) | [NAME] Flats |  | KAM | Large | Medium |  | MTU (3-19 Units) | MTU (20-64 Units) | MTU > 64 Units |  | MTU (3-19 Units) | MTU (20-64 Units) | MTU > 64 Units |  | Single Units | MDU (3-19 Flats) | MDU (20-64 Flats) | [NAME] Flats |  | KAM | Large | Medium |  | Av Floors/MDU | Height / Floor (meters) | Units / Floor | Vertical Cable meters |  | Av Floors/MDU | Height / Floor (meters) | Units / Floor | Vertical Cable meters |  | % Total Premises |  | Area m2 |  | # Lines | # ADSL | Total Rev | xDSL Rev |  | ADSL | MSAN Y/N | MSAN Model | Ports op bal. |  |  | Direct Dig C-HH? | Copper Fix? | QoS: C to H'H | Other |  | CO to PN | PN to C1 | PN to C2 | PN to C3 | C1/JB1/(a) | C1/JB1/(b) | C1/JB1/(c) | C1/JB1(a)/JB2(a) | C1/JB1(a)/JB2(b) | C1/JB1(a)/JB2(c) | C1/JB1(b)/JB2(a) | C1/JB1(b)/JB2(b) | C1/JB1(b)/JB2(c) | C1/JB1(c)/JB2(a) | C1/JB1(c)/JB2(b) | C1/JB1(c)/JB2(c) | C1/JB1(a)/JB2(a)/JB3(a) | C1/JB1(a)/JB2(a)/JB3(b) | C1/JB1(a)/JB2(a)/JB3(c) | C1/JB1(a)/JB2(b)/JB3(a) | C1/JB1(a)/JB2(b)/JB3(b) | C1/JB1(a)/JB2(b)/JB3(c) | C1/JB1(a)/JB2(c)/JB3(a) | C1/JB1(a)/JB2(c)/JB3(b) | C1/JB1(a)/JB2(c)/JB3(c) | C1/JB1(b)/JB2(a)/JB3(a) | C1/JB1(b)/JB2(a)/JB3(b) | C1/JB1(b)/JB2(a)/JB3(c) | C1/JB1(b)/JB2(b)/JB3(a) | C1/JB1(b)/JB2(b)/JB3(b) | C1/JB1(b)/JB2(b)/JB3(c) | C1/JB1(b)/JB2(c)/JB3(a) | C1/JB1(b)/JB2(c)/JB3(b) | C1/JB1(b)/JB2(c)/JB3(c) | C1/JB1(c)/JB2(a)/JB3(a) | C1/JB1(c)/JB2(a)/JB3(b) | C1/JB1(c)/JB2(a)/JB3(c) | C1/JB1(c)/JB2(b)/JB3(a) | C1/JB1(c)/JB2(b)/JB3(b) | C1/JB1(c)/JB2(b)/JB3(c) | C1/JB1(c)/JB2(c)/JB3(a) | C1/JB1(c)/JB2(c)/JB3(b) | C1/JB1(c)/JB2(c)/JB3(c) |  | CO to PN | PN to C1 | PN to C2 | PN to C3 | C1/JB1/(a) | C1/JB1/(b) | C1/JB1/(c) | C1/JB1(a)/JB2(a) | C1/JB1(a)/JB2(b) | C1/JB1(a)/JB2(c) | C1/JB1(b)/JB2(a) | C1/JB1(b)/JB2(b) | C1/JB1(b)/JB2(c) | C1/JB1(c)/JB2(a) | C1/JB1(c)/JB2(b) | C1/JB1(c)/JB2(c) | C1/JB1(a)/JB2(a)/JB3(a) | C1/JB1(a)/JB2(a)/JB3(b) | C1/JB1(a)/JB2(a)/JB3(c) | C1/JB1(a)/JB2(b)/JB3(a) | C1/JB1(a)/JB2(b)/JB3(b) | C1/JB1(a)/JB2(b)/JB3(c) | C1/JB1(a)/JB2(c)/JB3(a) | C1/JB1(a)/JB2(c)/JB3(b) | C1/JB1(a)/JB2(c)/JB3(c) | C1/JB1(b)/JB2(a)/JB3(a) | C1/JB1(b)/JB2(a)/JB3(b) | C1/JB1(b)/JB2(a)/JB3(c) | C1/JB1(b)/JB2(b)/JB3(a) | C1/JB1(b)/JB2(b)/JB3(b) | C1/JB1(b)/JB2(b)/JB3(c) | C1/JB1(b)/JB2(c)/JB3(a) | C1/JB1(b)/JB2(c)/JB3(b) | C1/JB1(b)/JB2(c)/JB3(c) | C1/JB1(c)/JB2(a)/JB3(a) | C1/JB1(c)/JB2(a)/JB3(b) | C1/JB1(c)/JB2(a)/JB3(c) | C1/JB1(c)/JB2(b)/JB3(a) | C1/JB1(c)/JB2(b)/JB3(b) | C1/JB1(c)/JB2(b)/JB3(c) | C1/JB1(c)/JB2(c)/JB3(a) | C1/JB1(c)/JB2(c)/JB3(b) | C1/JB1(c)/JB2(c)/JB3(c) |  | Metro side of CO | CO to PN | PN to C | C/JB1(a) | C/JB1(b) | C/JB1(c) | C/JB1(a)/JB2(a) | C/JB1(a)/JB2(b) | C/JB1(a)/JB2(c) | C/JB1(b)/JB2(a) | C/JB1(b)/JB2(b) | C/JB1(b)/JB2(c) | C/JB1(c)/JB2(a) | C/JB1(c)/JB2(b) | C/JB1(c)/JB2(c) | C1/JB1(a)/JB2(a)/JB3(a) | C1/JB1(a)/JB2(a)/JB3(b) | C1/JB1(a)/JB2(a)/JB3(c) | C1/JB1(a)/JB2(b)/JB3(a) | C1/JB1(a)/JB2(b)/JB3(b) | C1/JB1(a)/JB2(b)/JB3(c) | C1/JB1(a)/JB2(c)/JB3(a) | C1/JB1(a)/JB2(c)/JB3(b) | C1/JB1(a)/JB2(c)/JB3(c) | C1/JB1(b)/JB2(a)/JB3(a) | C1/JB1(b)/JB2(a)/JB3(b) | C1/JB1(b)/JB2(a)/JB3(c) | C1/JB1(b)/JB2(b)/JB3(a) | C1/JB1(b)/JB2(b)/JB3(b) | C1/JB1(b)/JB2(b)/JB3(c) | C1/JB1(b)/JB2(c)/JB3(a) | C1/JB1(b)/JB2(c)/JB3(b) | C1/JB1(b)/JB2(c)/JB3(c) | C1/JB1(c)/JB2(a)/JB3(a) | C1/JB1(c)/JB2(a)/JB3(b) | C1/JB1(c)/JB2(a)/JB3(c) | C1/JB1(c)/JB2(b)/JB3(a) | C1/JB1(c)/JB2(b)/JB3(b) | C1/JB1(c)/JB2(b)/JB3(c) | C1/JB1(c)/JB2(c)/JB3(a) | C1/JB1(c)/JB2(c)/JB3(b) | C1/JB1(c)/JB2(c)/JB3(c) |  | Metro side of CO | CO to PN | PN to C | C/JB1(a) | C/JB1(b) | C/JB1(c) | C/JB1(a)/JB2(a) | C/JB1(a)/JB2(b) | C/JB1(a)/JB2(c) | C/JB1(b)/JB2(a) | C/JB1(b)/JB2(b) | C/JB1(b)/JB2(c) | C/JB1(c)/JB2(a) | C/JB1(c)/JB2(b) | C/JB1(c)/JB2(c) | C1/JB1(a)/JB2(a)/JB3(a) | C1/JB1(a)/JB2(a)/JB3(b) | C1/JB1(a)/JB2(a)/JB3(c) | C1/JB1(a)/JB2(b)/JB3(a) | C1/JB1(a)/JB2(b)/JB3(b) | C1/JB1(a)/JB2(b)/JB3(c) | C1/JB1(a)/JB2(c)/JB3(a) | C1/JB1(a)/JB2(c)/JB3(b) | C1/JB1(a)/JB2(c)/JB3(c) | C1/JB1(b)/JB2(a)/JB3(a) | C1/JB1(b)/JB2(a)/JB3(b) | C1/JB1(b)/JB2(a)/JB3(c) | C1/JB1(b)/JB2(b)/JB3(a) | C1/JB1(b)/JB2(b)/JB3(b) | C1/JB1(b)/JB2(b)/JB3(c) | C1/JB1(b)/JB2(c)/JB3(a) | C1/JB1(b)/JB2(c)/JB3(b) | C1/JB1(b)/JB2(c)/JB3(c) | C1/JB1(c)/JB2(a)/JB3(a) | C1/JB1(c)/JB2(a)/JB3(b) | C1/JB1(c)/JB2(a)/JB3(c) | C1/JB1(c)/JB2(b)/JB3(a) | C1/JB1(c)/JB2(b)/JB3(b) | C1/JB1(c)/JB2(b)/JB3(c) | C1/JB1(c)/JB2(c)/JB3(a) | C1/JB1(c)/JB2(c)/JB3(b) | C1/JB1(c)/JB2(c)/JB3(c) |  | Metro side of CO | CO to PN | PN to C | C/JB1(a) | C/JB1(b) | C/JB1(c) | C/JB1(a)/JB2(a) | C/JB1(a)/JB2(b) | C/JB1(a)/JB2(c) | C/JB1(b)/JB2(a) | C/JB1(b)/JB2(b) | C/JB1(b)/JB2(c) | C/JB1(c)/JB2(a) | C/JB1(c)/JB2(b) | C/JB1(c)/JB2(c) | C1/JB1(a)/JB2(a)/JB3(a) | C1/JB1(a)/JB2(a)/JB3(b) | C1/JB1(a)/JB2(a)/JB3(c) | C1/JB1(a)/JB2(b)/JB3(a) | C1/JB1(a)/JB2(b)/JB3(b) | C1/JB1(a)/JB2(b)/JB3(c) | C1/JB1(a)/JB2(c)/JB3(a) | C1/JB1(a)/JB2(c)/JB3(b) | C1/JB1(a)/JB2(c)/JB3(c) | C1/JB1(b)/JB2(a)/JB3(a) | C1/JB1(b)/JB2(a)/JB3(b) | C1/JB1(b)/JB2(a)/JB3(c) | C1/JB1(b)/JB2(b)/JB3(a) | C1/JB1(b)/JB2(b)/JB3(b) | C1/JB1(b)/JB2(b)/JB3(c) | C1/JB1(b)/JB2(c)/JB3(a) | C1/JB1(b)/JB2(c)/JB3(b) | C1/JB1(b)/JB2(c)/JB3(c) | C1/JB1(c)/JB2(a)/JB3(a) | C1/JB1(c)/JB2(a)/JB3(b) | C1/JB1(c)/JB2(a)/JB3(c) | C1/JB1(c)/JB2(b)/JB3(a) | C1/JB1(c)/JB2(b)/JB3(b) | C1/JB1(c)/JB2(b)/JB3(c) | C1/JB1(c)/JB2(c)/JB3(a) | C1/JB1(c)/JB2(c)/JB3(b) | C1/JB1(c)/JB2(c)/JB3(c) |  | Metro side of CO | CO to PN | PN to C | C/JB1(a) | C/JB1(b) | C/JB1(c) | C/JB1(a)/JB2(a) | C/JB1(a)/JB2(b) | C/JB1(a)/JB2(c) | C/JB1(b)/JB2(a) | C/JB1(b)/JB2(b) | C/JB1(b)/JB2(c) | C/JB1(c)/JB2(a) | C/JB1(c)/JB2(b) | C/JB1(c)/JB2(c) | C1/JB1(a)/JB2(a)/JB3(a) | C1/JB1(a)/JB2(a)/JB3(b) | C1/JB1(a)/JB2(a)/JB3(c) | C1/JB1(a)/JB2(b)/JB3(a) | C1/JB1(a)/JB2(b)/JB3(b) | C1/JB1(a)/JB2(b)/JB3(c) | C1/JB1(a)/JB2(c)/JB3(a) | C1/JB1(a)/JB2(c)/JB3(b) | C1/JB1(a)/JB2(c)/JB3(c) | C1/JB1(b)/JB2(a)/JB3(a) | C1/JB1(b)/JB2(a)/JB3(b) | C1/JB1(b)/JB2(a)/JB3(c) | C1/JB1(b)/JB2(b)/JB3(a) | C1/JB1(b)/JB2(b)/JB3(b) | C1/JB1(b)/JB2(b)/JB3(c) | C1/JB1(b)/JB2(c)/JB3(a) | C1/JB1(b)/JB2(c)/JB3(b) | C1/JB1(b)/JB2(c)/JB3(c) | C1/JB1(c)/JB2(a)/JB3(a) | C1/JB1(c)/JB2(a)/JB3(b) | C1/JB1(c)/JB2(a)/JB3(c) | C1/JB1(c)/JB2(b)/JB3(a) | C1/JB1(c)/JB2(b)/JB3(b) | C1/JB1(c)/JB2(b)/JB3(c) | C1/JB1(c)/JB2(c)/JB3(a) | C1/JB1(c)/JB2(c)/JB3(b) | C1/JB1(c)/JB2(c)/JB3(c) | Cabinet | JB1(a) | JB1(b) | [NAME]) | JB1(a)/JB2(a) | JB1(a)/JB2(b) | JB1(a)/JB2(c) | JB1(b)/JB2(a) | JB1(b)/JB2(b) | JB1(b)/JB2(c) | JB1(c)/JB2(a) | JB1(c)/JB2(b) | JB1(c)/JB2(c) | C1/JB1(a)/JB2(a)/JB3(a) | C1/JB1(a)/JB2(a)/JB3(b) | C1/JB1(a)/JB2(a)/JB3(c) | C1/JB1(a)/JB2(b)/JB3(a) | C1/JB1(a)/JB2(b)/JB3(b) | C1/JB1(a)/JB2(b)/JB3(c) | C1/JB1(a)/JB2(c)/JB3(a) | C1/JB1(a)/JB2(c)/JB3(b) | C1/JB1(a)/JB2(c)/JB3(c) | C1/JB1(b)/JB2(a)/JB3(a) | C1/JB1(b)/JB2(a)/JB3(b) | C1/JB1(b)/JB2(a)/JB3(c) | C1/JB1(b)/JB2(b)/JB3(a) | C1/JB1(b)/JB2(b)/JB3(b) | C1/JB1(b)/JB2(b)/JB3(c) | C1/JB1(b)/JB2(c)/JB3(a) | C1/JB1(b)/JB2(c)/JB3(b) | C1/JB1(b)/JB2(c)/JB3(c) | C1/JB1(c)/JB2(a)/JB3(a) | C1/JB1(c)/JB2(a)/JB3(b) | C1/JB1(c)/JB2(a)/JB3(c) | C1/JB1(c)/JB2(b)/JB3(a) | C1/JB1(c)/JB2(b)/JB3(b) | C1/JB1(c)/JB2(b)/JB3(c) | C1/JB1(c)/JB2(c)/JB3(a) | C1/JB1(c)/JB2(c)/JB3(b) | C1/JB1(c)/JB2(c)/JB3(c) |  | Desert | Road | Pavement | Grass | Aerial | Desert | Road | Pavement | Grass | Aerial | Desert | Road | Pavement | Grass | Aerial
 | [NAME] 1 | 123 | C | 456 | 999 |  | C | Y | 2011 | C | Y | 2011 |  | PTP | GPON |  |  | 2016 |  | N |  |  |  |  |  |  |  |  | 375 | 50 |  | 25.00000000000002 |  | 2.5 | 7.499999999999996 | 40 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.8 |  | 300 |  | 1500 | 200 | 200000 | 5000 |  | No | Y | Alpha | 500 |  |  | No | No | 16 |  |  | 900 | 500 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6300 | 2700 | 2700 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.3 | 0.5 |  | 0 | 0 | 0.3 | 0.5 |  | 0 | 0 | 0.3 | 0.5 |  | 0 | 0
 | [NAME] 2 | 456 | PN | 456 | 999 |  | C | Y | 2011 | C | Y | 2011 |  | PTP | PTP |  |  | 2012 |  | N |  |  |  |  |  |  |  |  | 600 | 80 |  | 40.00000000000004 |  | 4 | 11.99999999999999 | 64 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.2 |  | 900 |  | 500 | 50 | 25000 | 15000 |  | No | Y | Beta | 100 |  |  | Yes | No | 10 |  |  | 1000 | 500 | 400 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400 | 3600 | 3600 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0
 | [NAME] 3 | 789 | PN | 789 | 666 |  | C | Y | 2011 | C | Y | 2011 |  | PTP | VDSL |  |  | 2015 |  | Y |  |  |  |  |  |  |  |  | 675 | 90 |  | 45.00000000000004 |  | 4.5 | 13.49999999999999 | 72 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.02 |  | 200 |  | 500 | 50 | 10000 | 8000 |  | Y | Y | Beta | 200 |  |  | No | Yes | 15 |  |  | 2000 | 500 | 400 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400 | 3600 | 3600 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0
 | [NAME] 4 | 1011 | PN | 1011 | 999 |  | C | Y | 2012 | C | Y | 2012 |  | PTP | VDSL |  |  | 2016 |  | N |  |  |  |  |  |  |  |  | 675.75 | 90.10000000000001 |  | 45.05000000000004 |  | 4.505000000000001 | 13.51499999999999 | 72.08000000000001 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.02 |  | 200 |  | 500 | 50 | 10000 | 8000 |  | Y | Y | Beta | 201 |  |  |  |  |  |  |  | 2000 | 500 | 400 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400 | 3600 | 3600 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0
 | [NAME] 5 | 1012 | C | 456 | 666 |  | F | Y | 2013 | C | Y | 2013 |  | PTP | GPON |  |  | 2017 |  | N |  |  |  |  |  |  |  |  | 676.5 | 90.2 |  | 45.10000000000004 |  | 4.510000000000001 | 13.52999999999999 | 72.16000000000001 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.02 |  | 200 |  | 500 | 50 | 10000 | 8000 |  | Y | Y | Beta | 202 |  |  |  |  |  |  |  | 2000 | 500 | 400 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400 | 3600 | 3600 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0
 | [NAME] 6 | 1013 | C | 789 | 666 |  | F | Y | 2014 | C | Y | 2014 |  | PTP | GPON |  |  | 2018 |  | N |  |  |  |  |  |  |  |  | 677.25 | 90.30000000000001 |  | 45.15000000000004 |  | 4.515000000000001 | 13.54499999999999 | 72.24000000000001 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.02 |  | 200 |  | 500 | 50 | 10000 | 8000 |  | Y | Y | Beta | 203 |  |  |  |  |  |  |  | 2000 | 500 | 400 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400 | 3600 | 3600 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0
 | [NAME] 7 | 1014 | C | 1011 | 666 |  | F | Y | 2015 | C | Y | 2015 |  | GPON | GPON |  |  | 2019 |  | N |  |  |  |  |  |  |  |  | 678 | 90.4 |  | 45.20000000000004 |  | 4.52 | 13.55999999999999 | 72.32000000000001 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.02 |  | 200 |  | 500 | 50 | 10000 | 8000 |  | Y | Y | Beta | 204 |  |  |  |  |  |  |  | 2000 | 500 | 400 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400 | 3600 | 3600 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0
 | [NAME] 8 | 999 | CO | 999 | 999 |  | C | Y | 2016 | C | Y | 2016 |  | PTP | VDSL |  |  | 2020 |  | N |  |  |  |  |  |  |  |  | 678.75 | 90.5 |  | 45.25000000000004 |  | 4.525 | 13.57499999999999 | 72.4 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.02 |  | 200 |  | 500 | 50 | 10000 | 8000 |  | Y | Y | Beta | 205 |  |  |  |  |  |  |  | 2000 | 500 | 400 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400 | 3600 | 3600 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0
 | Node Name 9 | 666 | CO | 666 | 666 |  | C | Y | 2011 | C | Y | 2011 |  | PTP | VDSL |  |  | 2015 |  | N |  |  |  |  |  |  |  |  | 375 | 50 |  | 25.00000000000002 |  | 2.5 | 7.499999999999996 | 40 |  | 0.5 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3.5 | 2 |  |  | 15 | 3.5 | 2 |  |  | 0.02 |  | 400 |  | 500 | 50 | 50000 | 5000 |  | Y | Y | Beta | 300 |  |  | No | No | 20 |  |  | 2000 | 500 | 400 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400 | 3600 | 3600 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 400 | 400 | 400 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0 | 0.2 | 0.5 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Need rule for  this column |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note - Below JB1, a utiisation mark-up is added.  Do not copy this formula to the C/JB1 layer as this will result in double counting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | OSB [NAME] |  |  |  | Note - Below JB1, a utiisation mark-up is added.  Do not copy this formula to the C/JB1 layer as this will result in double counting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 32 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilisation | 0.85
 | UNIT PRICES
 | Passive Network
 | Fibre & Installation Cost/Meter
 | 276 fibre pairs | 276
 | 240 fibre pairs | 240
 | 192 fibre pairs | 192
 | 144 fibre pairs | 144
 | 96 fibre pairs | 96
 | 48 fibre pairs | 48
 | 24 fibre pairs | 24
 | 12 fibre pairs | 12
 | 8 fibre pairs | 8
 | 4 fibre pairs | 4
 | 2 fibre pairs | 2
 | Price change (-ve/+ve) |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Summary - WBU