Spreadsheet: 86687d1286641780-sumif-combined-with-match-help-sought-test-4
Sheet: CAPEX

CAPEX Model
 |  |  | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 | Example only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cumulative Customer Numbers at each point in Tree Network |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Brownfield |  |  |  |  |  | Primary Network Remediation Upgrade |  |  |  |  |  |  | Access Upgrade |  |  |  |  | Indicator |  |  | Premesis |  | 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) |  |  |  | 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] | [NAME] | Type Node | Mother PN ID | Mother CO ID |  | CO to PN | Upgrade Decision | Date (Yr.) | PN to C | Upgrade Decision | Date (Yr.) |  | Tech. | Min Service | Max Service | Date (Yr.) |  | Rev/Line | Density |  | Total -all units |  | % 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) | 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
 | A | 123 | C | 456 | 999 |  | C | Y | 2011 | F | Y | 2011 |  | PTP |  |  | 2016 |  |  |  |  | 500 |  | 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
 | B | 456 | PN | 456 | 999 | NA | C | Y | 2011 | F | Y | 2011 |  | PTP |  |  | 2012 |  |  |  |  | 800 |  | 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
 | C | 789 | PN | 789 | 666 | NA | C | Y | 2011 | C | Y | 2011 |  | VDSL |  |  | 2015 |  |  |  |  | 900 |  | 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
 | D | 1011 | PN | 1011 | 999 | NA | C | Y | 2012 | C | Y | 2012 |  | VDSL |  |  | 2016 |  |  |  |  | 901 |  | 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
 | E | 1012 | C | 456 | 666 |  | F | Y | 2013 | C | Y | 2013 |  | GPON |  |  | 2017 |  |  |  |  | 902 |  | 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
 | F | 1013 | C | 789 | 666 |  | F | Y | 2014 | C | Y | 2014 |  | VDSL |  |  | 2018 |  |  |  |  | 903 |  | 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
 | G | 1014 | C | 1011 | 666 |  | F | Y | 2015 | C | Y | 2015 |  | VDSL |  |  | 2019 |  |  |  |  | 904 |  | 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
 | H | 999 | CO | 999 | 999 |  | C | Y | 2016 | C | Y | 2016 |  | VDSL |  |  | 2020 |  |  |  |  | 905 |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 197 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | I | 666 | CO | 666 | 666 |  | C | Y | 2011 | C | Y | 2011 |  | VDSL |  |  | 2015 |  |  |  |  | 500 |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 787 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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] | [NAME]
 | Worded Explanation of Problem |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Minimum path loss xDSL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Col HL is where the results need to be generated. Rows 9 to 15 is wrong, but where I have added in the yellow and red in row 16 & 17, I have added in what the relevant colours should sum to. |  |  |  |  |  |  |  | 2 | 32
 | The number of fibre filaments (schedule starting Col HK) is added for Cabinet ("C") which is paired with a particular Mother PN ID (Col E) and which that PN is paired with the appropriate Mother CO ID (Col F), is added and returned to the relevent CO row.  Note, not that it is relevant, but in order not to confuse, the ID in Col "C" for a PN has a 1:1 relationship with itself and therefore has the same ID in Col E; likewise for "CO" in Col F. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADSL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ADSL 2+ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilisation | 0.85
 |  |  |  |  |  |  |  |  |  | Cable Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VDSL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corporates | 0.15
 |  |  |  |  |  |  |  |  |  | 276 fibre pairs | 276 |  |  |  |  |  |  | Min Loss Charactieristics
 |  |  |  |  |  |  |  |  |  | 240 fibre pairs | 240 |  |  |  |  |  |  | ADSL
 |  |  |  |  |  |  |  |  |  | 192 fibre pairs | 192 |  |  |  |  |  |  | ADSL2Plus
 |  |  |  |  |  |  |  |  |  | 144 fibre pairs | 144 |  |  |  |  |  |  | VDSL
 |  |  |  |  |  |  |  |  |  | 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