Home

Fixed LRIC model user guide – Version 2.0

1. The Results Pasted worksheet contains the pasted unit costs split by core and access from running the LRIC model for each year in the period 2007 12 This calculation of the LRIC model can be automated by pressing the Paste results button at the top of the worksheet 6 18 1 Key parameters The Results worksheet contains an output of all relevant data and only contains a manually adjustable set of parameters for converting volume to demand by geotype rows 41 70 The Results Pasted worksheet contains no parameters 6 18 2 Calculation description The following table outlines the calculations that are contained on the Results worksheet ii WM Analysys Fixed LRIC model user guide Version 2 0 171 Cell reference Description and details of spreadsheet calculations Rows 8 37 LRIC results by service for core and access by geotype Rows 41 70 Conversion parameters for core and access and geotype demand numbers for access network calculations Rows 75 104 LRIC unit cost outputs Rows 109 111 Core platform costs Table 6 22 Calculations performed on the Results worksheet Source Analysys The final LRIC costs are generated for each service using a multiplication factor to convert the LRIC cost in minutes lines per annum into an appropriate cost either e AUD line month access line services e AUD cents minute voice traffic services e AUD cents call LCS service e AUD M
2. Methodology to connect fibre demand Connect fibre demand Nature of distribution network Primarily non tapered Primarily non tapered Primarily non tapered Primarily non tapered Primarily non tapered Primarily non tapered Primarily non tapered Primarily non tapered Primarily non tapered Primarily non tapered RURAL Connect fibre demand Primarily non tapered RURAL Connect fibre demand Primarily non tapered RURAL Connect fibre demand Primarily non tapered RURAL Connect fibre demand Primarily non tapered Calculation branch indez NNNSNN ro Fibre Distribution methodology network indez indez OW OW OW WWW WO Ww Po N PM FR RE N EP N BE NNN ESA catouistionmethodaiagy Siremethadoiagna ARDA DIR MAAC ESA catoustionmethos Sremethodaing distr network method type of distribution network Source Analysys Excel inputs used to determine urban rural deployment how fibre is deployed and the There are three fibre deployment choices available two implement ring structures and the third implements point to point links The two ring deployments either join all pillars into a fibre ring or rings going through the RAU or alternatively only those pillars with fibre fed locations Point to point links use fibre to connect fibre fed locations directly back to the RAU via their parent pillar Function coefficients Cell
3. Es WM Analysys Fixed LRIC model user guide Version 2 0 18 It is likely that only fairly significant changes to these inputs will change the mix of pits deployed The mix of pits may be more sensitive to changes in the amount of duct deployed which are driven by the duct capacity definitions as shown below Cell reference Rows 55 59 Duct capacity definitions Maximum number of copper intra Source Data available fromthe Description and details of spreadsheet calculations Duct capacity definitions ma neminirspitar cables perdiet Maximum number of cables betwe Source Analysys assumption imax num pillar FAL cables per duct Maximum number of cables betwe Source Analysys assumption 100 mak RTL RSA CARVES per Ge Maximum number of point to poin Source Analysys assumption Man UR iire FT CONES per due Maximum number of fibre ring cabl Source Analysys assumption 100 Mak NT ISLS CLG COVES per Ut Figure 2 12 Maximum number of copper intra pillar cables ina duct Maximum number of cables between pillar and RAU ina duct Maximum number of cables between LPGS and RAU in a duct Maximum number of point to point fibre cables between DP and pillar in a duct Maximum number of fibre ring cables in a duct 9995 207 Excel parameters for duct capacity Source Analysys Deploys a duct for every n intra pillar copper sheaths within a single trench link Deploys a duct for ever
4. List of edges in fibre ring This table lists the co ordinates of the endpoints of pillar pillar links formed by the fibre rings These co ordinate pairs can be linked through to the chart FR by selecting the ESA in the FR data worksheet Cell reference Cells BF37 BV Description and details of spreadsheet calculations Data on spanning trees connecting address locations This table lists the co ordinates of the endpoints of every edge within the trench network formed by the minimum spanning tree These co ordinate pairs can be plotted using MapInfo to inspect the resulting trees The number of ducts by use is also printed for each link Data on spanning trees connecting address locations Data on spanning trees connecting address locations Ducts needed in link Connection Edge vi va vlr vis var v2 3 Link length Intra pillar Inter pillar Intra type inder m copper copper pillar Inter pillar Fibre for LPGS fibre DP FDP copper Total needed Total amp fibre provisioned Aistedge PE Aestedgek HAMES GI MStvZESA WARES HAVRE Met ULKESAG AERES Het edge eng Mstinvapiter Aistinter pillar Kistintrags Brstinter pia Mt WUNLPGSESA GL Mist MADE FOF ES Mstioralduet ES Met total duct reis 32 0 0 2 Within DP 1 279588 6 130 523 279 587 6 130 555 1 0 o 1 2 Within DP 2 825 71 280 129 6 133 243 280 131 6 133 223 20 0 0 0 0 0 1 1 1 Within DP 3 2 985 2955 281018 6 131 556 281017 6 131579 23 1 o 0 o o 1 2 2 Within D
5. Figure 5 22 Excel screenshot displaying sample of the matrix of the straight line distances between each LAS Source Analysys pibadi WM Analysys Fixed LRIC model user guide Version 2 0 78 5 7 1 Key parameters Whilst there are no key parameters on this worksheet it should be highlighted that this matrix contains straight line distances as opposed to road length distances The straight line distances have been calculated using a formula that takes into account the curvature of the Earth An uplift parameter is implemented later in the model to account for the fact that road length is greater than straight line length As an alternative a matrix of actual road length distances may be entered in place of the existing straight line distance matrix 5 7 2 Calculation description 5 8 The table below lists specific data inputs and calculations that take place on the In LAS distances worksheet by row number Cell reference Description and details of spreadsheet calculations Rows 4 136 Matrix of the distance straight line distance between each LAS This matrix may be updated with the road railway distances between each LAS Table 5 10 Calculations performed on the In LAS distances worksheet Source Analysys In TNS Gravity worksheet This worksheet estimates the proportion of the national calls that goes to each individual TNS node by using a gravity model In the base case the gravi
6. RF Access worksheet Source Analysys 6 14 2 Calculation description The following table outlines the calculations that are contained on the RF Access worksheet Cell reference Description and details of spreadsheet calculations Rows 6 86 Access service routeing factors Table 6 18 Calculations performed on the RF Access worksheet Source Analysys The figure below shows a screenshot sample of the parameters for access service routeing factors sain WM Analysys Figure 6 33 This sheet contains the access routing Factors used in the workbook Fixed LRIC model user guide Version 2 0 164 note cost from core network is LE costs supporting MOF note business overheads all Access service volumes 7 824 961 PSTN End PSTN local PSTN User Access traffic national onnet long traffic distance i traffic 4 onnet calls Other CAN NTP 2 pair wall socket Other CAN NTP 10 pair building termination Other CAN NTP 30 pair building termination Other CAN NTP 50 pair building termination Other CAN NTP 100 pair building termination Other CAN Fibre termination point E1 Radio CPE radio link Outdoor unit Radio CPE satellite link LPGS LPGS equipment LPGS LPGS MDF Cable Copper pillars Sample of the parameters for access service routeing factors Source Analysys Costs that are linked in from the core network due to asset sharing between the access and core networks
7. 56 TNS are logically fully meshed on distinct physical rings LAS parented by two TNS on LAS rings PoC parented by a LAS on a fully resilient ring 14 TNS nodes LE parented by a PoC at which backhaul is aggregated 5000 LE nodes Note LE Local exchange PoC Point of confluence LAS Local access switch TNS Transit network switch Note A PoC is a local exchange on an SDH ring Note Although the Large Pair Gain Systems LPGS such as CMUX equipment are costed as part of the core network the deployment of these assets is actually calculated in the CAN module as it is modelled as an access decision Figure 5 1 Modern core network structure Source Analysys Core nodes are logically fully meshed on distinct physical rings Regional nodes De Se ages Node rings 133 Regional node 5000 AT1 LE nodes Conversion from local exchange to NGN Access Tier 1 is dependent on geotype PoC parented by a Regional Node on a fully resilient ring Note AT2 Access Tier 2 AT1 Access Tier 1 LE Local Exchange PoC Point of confluence Regional Regional nodes Core Core nodes Note A PoC is a AT1 on a resilient ring Figure 5 2 NGN core network structure Source Analysys 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 57 As indicated in Table 5 1 the network design algorithms for each network level are modelled in se
8. AARE AASS ABAY ABCH ABCK ABDN ABEE Figure 5 33 Excel screenshot showing sample of the calculation of PSTN and ISDN subscriber and equipment requirements Source Analysys Cell reference Description and details of spreadsheet calculations Rows 13 5268 Calculation of TDM based equipment requirements e Columns N O link in the ADSL and SDSL SIO numbers from the In Subs worksheet e Columns P Q calculate the xDSL line card requirement taking into account utilisation e Columns R T calculate the shelf rack and backhaul requirement for xDSL services 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 90 In the modern network xDSL lines are modelled to be handled by separate equipment to the PSTN lines however a similar methodology is used to dimension the xDSL equipment The methodology for the calculation of equipment requirements for xDSL is shown in the figure below Number of line Number of Number of racks cards required shelves required required Figure 5 34 Calculation of the number of xDSL line cards shelves and racks required Source Analysys The Excel output of these calculations are shown below TDM based equipment required in areas not served using MSAN equipment zDSL requirements Available ports per line car Available Available Backhaul ADSL SDSL line cards shelves per provisioned 46 46 5 4 30 720 zDSL SIOs Line cards required Shelves Racks Backhaul requ
9. Care need capacities of the individual rings to be taken when changing the current resulting in different network set up Ideally the user should refer to equipment requirements the street and rail network to make sure that the entered ring combinations are sensible and efficient To specify special Core xls NwDes 5 Islands A16 A33 F16 F33 Certain exchanges primarily those that The asset distance to be removed 9995 207 DAnalysys Annexes to Fixed LRIC model user guide A 7 Objective Workbook Worksheet Cell reference Description Impact backhaul for are located on islands require special from the modelled calculations is certain exchange backhaul methodologies i e a satellite or automatically calculated in columns sites microwave solution In order to ascribe a G I using data calculated on the certain exchange as requiring special NwDes 1 Access worksheet backhaul the user should enter the exchange code in column A and enter the backhaul methodology in column F Checks should be made that the resulting calculations are reasonable and flow through to the Out Assets worksheet To change the Core xls NwDes 4 Core Node E262 R275 The TNS rings have been set up with a Changing TNS ring structures impacts structure of TNS s E285 R298 physical link dimensioning for the upon the TNS capacities of the rings E307 R320 routeing of traffic using a binary matrix individual rings resulting in different E329 R3
10. DYDM dimensioning Number of Fibres Dark fibres Total fibres Bundle Deploy Scenari Wavelen SDH fibre Dark fibre Nodes Nodes fibres required for required required size D DM o gths metres metres requirin requirin dimensione spares impleme deploge g ADM g 4 1 1 6 6 4 1 1 6 6 4 1 1 6 6 4 1 1 6 6 4 1 1 6 6 95836498 15 167 286 Figure 5 62 Excel calculations to determine the fibres required DWDM equipment requirement and the total fibre metres split between SDH and other fibre Source Analysys Columns W Z calculate the Dense Wave Division Multiplexer DWDM equipment required to serve the nodes on the ring The type of DWDM equipment metro long haul extended long haul or ultra long haul is then calculated in calculations next to the determination of fibre distance between active nodes on the ring 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 111 The distance of the fibre links between each of the nodes is calculated automatically by looking up the appropriate value in the LAS LAS distance matrix on the In LAS distance worksheet Fibre Distance km LAS LAS LAS LAS LAS LAS Ring 1 E Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 Figure 5 63 Excel calculations to determine the distance of the fibre links between each node Source Analysys These distances are used in the calculation of the total distance between active nodes on the LAS ring It is these distances that are used in the d
11. Ed 26 P 32 49 56 40 50 PS 34 24 18 38 21 Figure 2 36 Excel data for calculation of assets by geotype Source Analysys 9995 207 WM Analysys 3 1 Fixed LRIC model user guide Version 2 0 36 Geoanalysis and access network module Part II DATA Section 2 described the code sub module of the geoanalysis and access network module The workbooks that form the accompanying data sub module are described here They store the results of all calculations for each ESA in a stratified sample Each workbook s name takes the form Access DATA Gy xls with y being based on the index of the geotype Due to file size certain geotypes have been split across several workbooks with the geotype index number suffixed with a letter The 15 and 16 geotypes are not included within the sample and hence have no associated workbooks The remainder of this section is set out as follows e Section 3 1 outlines the information displayed in the FR data worksheet e Section 3 2 outlines the information displayed in the Links worksheet e Section 3 3 outlines the information displayed in the ESA Gy z worksheet FR data worksheet The FR data worksheet is intended to allow the user to select a particular ESA and view its fibre ring deployment if it has been used without having to construct the chart from scratch Ee WM Analysys Fixed LRIC model user guide Version 2 0 37 For each ESA Gy z in
12. For the non MSAN traffic the total number of E1 Virtual Containers E1 VCs required to carry PSTN ISDN and xDSL traffic are calculated An uplift is further applied for transmission traffic The Excel calculations for the non MSAN traffic are shown below er WM Analysys Fixed LRIC model user guide Version 2 0 93 Transmission requirements LE gt gt POC TDM transmission dimensioning grade af service ME NBED fix 5 links EES EK EHR Covers fate AE Traffic per subscriber 30 wows per Et 1 920 Transmission requirements TDM Transmission requirements Access Tier ParentPoC LE remote to PSTN BHE ISDN BHE xDSL kbps PSTN traffico ISDN traffic xDSL traffic Loadinterms LE LAS Total Eis 1 LE site POC ET EN EN of kbitis transmission AARE AARE ol AASS YOWN N ABAY YEOD ie ABCH ABCH ol ABCK ABCK 0 ABDN CARK 1 ABEE HALS 1 ABER BIR 1 ABES HALS ae Figure 5 37 Excel screenshot showing sample of the calculation table for non MSAN transmission dimensioning Source Analysys For the MSAN traffic the total number of kbit s required to carry PSTN ISDN and xDSL traffic are calculated An uplift is further applied for transmission traffic The Excel calculations for the MSAN traffic are shown below Transmission requirements LE gt gt POC MSAN transmission dimensioning PSTNkbps ISON kbps SIO channel 50 00 Mar elements NGA Transmission requirements Pawicad Access Tier 1 LE Parent PoC LE remote to PSTN kbps ISD
13. In Subs worksheet 9995 207 Analysys Fixed LRIC model user guide Version 2 0 65 Cell reference Description of spreadsheet calculations Details of spreadsheet calculations Rows 33 5286 Rows 5292 5424 Rows 5429 5442 Rows 5447 5460 Rows 5465 5480 AK33 AL5286 AM33 AM5286 Line data by ESA Line data by LAS Line data by TNS parent 1 Line data by TNS parent 2 each LAS has 2 parents defined for redundancy Summary Subscribers by geotype Derives MSAN equivalent assets using pillars fibre fed LPGS by ESA NGA copper SIOs Calculated based on availability of service in geotype scaled for current year demand Calculated using a SUMIF formula according to the parent LAS of each LE Calculated using a SUMIF formula according to the TNS parent 1 of each LAS Calculated using a SUMIF formula according to the TNS parent 2 of each LAS Calculated using a SUMIF formula using the LE geotypes Based on data linked from CAN module Maximum of PSTN amp WLR SIOs or xDSL SIOs Table 5 5 5 5 Dem Calc worksheet Calculations performed on the In Subs worksheet Source Analysys The Dem Calc worksheet is used to calculate service routed busy hour Erlang or busy hour kbit s load on each of the different parts of the network Input parameters defining the busy hour demand on the network are linked from the In Network worksheet
14. L10 Calculation of percentage duct cost allocated to the incumbent and to other Rows 15 19 Calculation of the volume of duct used by the core network in the CAN Table 6 8 Calculations performed on the Ducts Core worksheet Source Analysys 6 7 Dem In Core worksheet This worksheet calculates the network element output for the TDM and NGN networks The network element output is calculated by multiplying the service routeing factors from the RF Core worksheet by the total service demand from the Inputs Core worksheet The network element output is calculated for the PSTN ISDN xDSL and transmission platforms These linkages are shown in the diagram below Figure 6 17 Location of the Dem In Core worksheet in the overall Cost module CostAlloc Core RF Core Demln Core structure Source Analysys TA Core Results TA Access Demln Access gt RF Access 6 7 1 Key parameters This worksheet only contains autonomous calculations 9995 207 WM Analysys 6 7 2 Calculation description Fixed LRIC model user guide Version 2 0 145 The following table outlines the calculations that are contained on the Dem In Core worksheet Cell reference Description and details of spreadsheet calculations Rows 3 Year modelled Rows 9 11 Transposed service demand for NGN and TDM Rows 20 219 Network element output for PSTN platform cells C20 AG219 allocation of PSTN platform c
15. Required assets TNS processor Tandem Switch switchblock unit Required assets TNS switchblock Figure 5 83 Output summary for the TNS level assets Source Analysys cost of interconnection links attributed to PSTN ISDN ATM Transmission cost of transit links attributed to PSTN ISDN ATM Transmission PSTN ISDN ATM Transmission Allocation of fibre costs 2 O 8 20 Costallocation T SDH Dark fibre Total fibre metres metres 86 131 080 86 131 080 Cost allocation TNS CoreNode trench trench cost allocated to SDH vs dz Figure 5 84 Excel calculations for the other core network assets that are located at the TNS MTH location Source Analysys NwDes 5 Islands worksheet The NwDes 5 Islands worksheet is a part of the network design algorithm It defines the specific calculations required for special island solutions These backhaul solutions cannot be modelled to a satisfactory degree using the network design algorithms on the proceeding worksheets Consequently this worksheet ascribes either a microwave satellite or submarine cable solution to a particular island For the majority of the islands trench duct and fibre distances from the LE POC calculations are derived in the NwDes 1 Access worksheet Rather than deploy these lengths an appropriate alternative wireless or satellite solution is implemented These distances are subsequently subtracted from the LE PoC dista
16. aa WM Analysys Fixed LRIC model user guide Version 2 0 4 Running the geoanalysis and access network module The workbooks that make up the geoanalysis and access network module can be re run to feed the active module with new parameters to dimension the access network All of these workbooks should be kept in one directory in order to preserve the workbook interlinks All of the inputs that feed into the offline calculation lie within the Inputs worksheet of Access Code xls The Summary worksheet contains a numerical index of the ESAs within the sample The calculation can be re run for all or a contiguous selection of ESAs In order to do this all of the data workbooks must be closed with Access Code xls open Enter the indices of the first and last ESAs to be re run in the cells called first ESA and last ESA respectively on the Inputs worksheet as shown below A B C D E F G H 1 wu An a ys y S n p uts Derive access network volumes 1 Sa 2 3 ESAs to process 4 ER SOAS IQJVOCESS 5 6 First ESA 1 yess 7 Last ESA ie aar Figure 1 3 Running the algorithms in Access CODE xls Source Analysys Clicking on the button Derive access network volumes will then re run the calculations for these ESAs using the inputs specified on the Inputs worksheet More details on the underlying Visual Basic in the offline modules of the model can be found in the accompanyin
17. cells U10 AJ90 multiplied by unit capex cells H10 H90 Totalled in row 91 Calculation of annualised capex cost per geotype using the tilted annuity algorithm Opex cost per geotype equipment deployed by geotype cells V10 AK90 multiplied by unit capex cells H10 H90 multiplied by opex as percentage of capex cells 110 190 Percentage of trench and duct cost allocated to the core network This is linked from the Inputs Access worksheet and defines the proportion of access assets that are actually attributed to the core network costing e g transmission from the LPGS to the LE Percentage of fibre cost allocated to the core network This is linked from the Inputs Access worksheet and defines the proportion of access assets that are actually attributed to the core network costing e g transmission from the LPGS to the LE Total trench and duct costs allocated to the core network Percentage of trench and duct cost allocated to the core network cells CL10 DA91 multiplied by the sum of the annualised capex cells BD10 BS91 and opex cells BU10 CJ91 Total fibre costs allocated to the core network Percentage of fibre cost allocated to the core network cells DB10 DQJ91 multiplied by the sum of the annualised capex cells BC10 BR91 and opex cells BT 10 ClJ91 Cost savings and costs from core allocated to geotypes total cost coming from core cells N10 N91 plus cost savings from duct and tre
18. display or commercialise the material without written permission from the Director ACCC Publishing Ee WM Analysys Fixed LRIC model user guide Version 2 0 1 1 Introduction This document is to be used in conjunction with the LRIC model in order to gain a full understanding of the calculations that take place 1 1 LRIC model workbooks The LRIC model is a series of workbooks and databases containing multiple interlinks The structure is summarised below in Figure 1 1 Figure 1 1 Structure of Key Service the model Source Costing Module Analysys COST xls Includes scenario A controls Customer Access Core Network Network Design Design module module CAN xls CORE xls As shown above the LRIC model splits into two parts offline modules and active modules Active modules The active modules comprise two network design modules which calculate the number of assets for the customer access network CAN and the core network respectively The serving costing Cost module ties the active modules together performing several key functions Specifically it e defines the calculation scenarios e presents demand drivers over time to the network design modules e costs the dimensioned network e calculates unit costs of services e passes costs of network elements between the access and traffic increments The offline modules which perform analysis of issues believed to be relatively stable co
19. locations fed by fibre then linked by spurs to their parent pillar The third option simply connects all locations fed by fibre directly to the remote access unit RAU via their parent pillar Analysys 9995 207 Fixed LRIC model user guide Version 2 0 10 Nature of fibre connections Include all pillars in a fibre ring Include all pillars with existing fibre demand into a ring Connect fibre demand locations directly to pillar nature of fibre connections Figure 2 4 Excel parameters for the nature of fibre connections Source Analysys Cell reference Description and details of spreadsheet calculations Rows 37 38 Nature of distribution network These are the labels used to denote the two different means encoded within the geoanalysis and access network module for deploying copper cable within the distribution network of an ESA This part of the network can either be tapered or partially non tapered The default assumption used in the model is to use a non tapered deployment in all geotypes Nature of distribution network Fully tapered Primarily non tapered distribution network assumptions Figure 2 5 Excel parameters for the nature of the distribution network Source Analysys Cell reference Description and details of spreadsheet calculations Rows 43 44 Options for calculating for ESAs These are the two options with which the code sub module can recalculate the asset volumes for the ESAs
20. worksheet The utilisation parameters set out below are the key parameters that can be changed 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 114 Parameter Equipment capacity parameters Equipment utilisation parameters Link utilisation parameters Fibre uplift parameter for spares Fibre uplift parameter for other fibre services Transmission carried kbit s Percentage of trench that is ducted DWDM equipment parameters CAN IEN and inter IEN overlap parameters Location Rows 17 18 Rows 20 21 Rows 23 24 Row 26 Row 27 Row 30 Row 32 Rows 35 38 1472 1474 Impact Defines the physical equipment capacity Affects the level of effective equipment capacity Affects the maximum effective loading of the transmission links reflects the fact that links are not dimensioned to be fully loaded Uplift for a number of spare fibres in the bundle Uplift for a number of fibres that are available for alternative operators to utilise Allowance for other transmission requirements on the LAS TNS links Affects the link and trench distances deployed in the network Parameters affecting the thresholds for the deployment of DWDM equipment and the distance parameters for the four types of DWDM equipment modelled Affects the volume of duct and trench assets calculated for the TNS level The distance of duct within CAN areas is retained for cost allocations between and CAN an
21. worksheet Cost module Scenario worksheet 6 6 11 31 36 36 38 39 48 49 50 50 53 53 55 57 58 60 62 65 73 76 78 83 84 94 99 112 125 128 130 131 Analysys 6 2 6 3 6 4 6 5 6 6 6 7 6 8 6 9 6 10 6 11 6 12 6 13 6 14 6 15 6 16 6 17 6 18 6 19 Fixed LRIC model user guide Version 2 0 WACC worksheet Inputs Demand worksheet Inputs Core worksheet Building Core worksheet I Ducts Core worksheet Dem In Core worksheet CostAlloc Core worksheet RF Core worksheet UnitCost Core worksheet OutputCost Core worksheet TA Core worksheet Inputs Access worksheet RF Access worksheet Dem In Access worksheet UnitCost Access worksheet TA Access worksheet Results and Results Pasted worksheet Recon worksheet Annex A Quick start guide to active modules Annex B LE PoC minimum spanning tree and travelling salesman algorithm 9995 207 132 133 134 140 142 144 145 151 152 154 155 158 162 164 166 168 170 171 Analysys Fixed LRIC model user guide Version 2 0 Commonwealth of Australia 2009 This report has been produced by Analysys Consulting Limited for the Australian Competition and Consumer Commission ACCC You may download material in the report for your personal non commercial use only You must not alter reproduce re transmit distribute
22. Affects the amount of traffic dimensioned in the busy hour on the Dem Calc worksheet Rows 31 77 These determine the physical capacity of the exchange based equipment These physical capacities have been where possible based on industry data It is recommended that only the provisioning and utilisation parameters be manipulated by users Cell H179 Affects the provisioning of transmission links Cells L82 L88 L99 L102 Affects the provisioning of transmission links Equipment capacities Row 176 219 Affects the actual capacity of equipment and utilisations Percentage of trench that Rows 128 141 Affects the amount of duct that is deployed is ducted Table 5 12 Key parameters in the In Network worksheet Source Analysys 5 9 2 Calculation description The table below lists specific sets of network inputs and calculations by row number Cell reference Description and details of spreadsheet calculations Rows 3 7 Industry standard conversion factors Rows 11 26 Network loading parameters including busy hour data Rows 31 77 Exchange equipment parameters backhaul provisioned ports per line card Rows 128 161 Rows 164 169 Rows 176 242 Rows 247 252 line cards per shelf shelves per rack by service Transmission planning and engineering factors Link utilisation parameters Element provisioning parameters Island solution parameters Table 5 13 Inputs and calculations on the In Network worksheet Source Ana
23. BHE load Sheet Dem Calc Cells M59 MS88 using the following inputs Demand parameters Voice busy hour ISDN busy hour calls occuring in weekdays PSTN Local calls PSTN National calls PSTN International calls PSTN Fixed to mobile calls PSTN Terminating traffic ISDN Annual busy days Minutes per hour Assumed call attempts per call Average answered call set up time minutes Average unanswered call duration minutes Bandwidth occupied per voice call Extreme busy hour factor e proportion of annual traffic during 250 normalt weekdays 9 9 85 85 75 85 85 95 250 1 10 0 17 0 47 e proportion of weekday traffic occurring in the normal busy hour e the average proportion of daily calls that occur in the busy hour P xP BHE annualtraffic x La w B x60 Where P Proportion of daily traffic in the busy hour P Proportion of annual traffic in the busy week days B Number of busy week days Figure 5 12 Excel key demand parameters Source Analysys Figure 5 13 Calculation of the busy hour Erlang voice demand Source Analysys The number of voice busy hour erlangs BHE is converted into a further measure of demand namely the number of busy hour call attempts BHCA Sheet Dem Calc Cells N59 N88 using the following inputs e average call duration Normal being defined as a day which is not a public holiday 9995 207 Analysys Fixed LRIC model user
24. Cable Distance distance from pillar capacity from capacity constraint for centre m DP to pillar between pillar LPGS rather and RAU than a pillar 4 400 10000 4 400 10000 4 400 10000 4 400 10000 4 400 10000 4 400 10000 4 400 10000 4 400 10000 4 400 10000 4 400 10000 4 400 10000 4 400 10000 t 4 400 DE pile cable caps pillar FAL cable capacity 10000 cable dist Mreshoi L PGS Excel parameters to dimension copper distances and cable capacities constraints by geotype Source Analysys Maximum permitted distance from DP pillar centre Required capacity from DP to pillar Cable capacity between pillar and RAU Distance constraint These distances are the constraints used in the clustering algorithms and are varied by geotype in order to control the effectiveness of these algorithms It should be emphasised that these distance constraints are controls rather than technical constraints This is only used in the tapered deployment for the purpose of the spanning tree algorithm in order to estimate the cable size for linking DPs back to their pillars when calculating the proxy cost of linking any two DPs Defines the cable size used to link pillars to the RAU and therefore impacts the cluster size of a pillar This is always modelled as a single sheath non tapered deployment Determines the maximum acceptable length for a copper loop which is used for LPGS as a test to deploy a LPGS rather than a p
25. DAnalysys Model documentation for the Australian Competition and Consumer Commission Fixed LRIC model user guide Version 2 0 August 2009 9995 207 Analysys Consulting Limited St Giles Court 24 Castle Street Cambridge CB3 0AJ UK Tel 44 0 1223 460600 Fax 44 0 1223 460866 consulting analysys com www analysys com Contents 1 1 1 2 2 1 2 2 2 3 3 1 3 2 3 3 4 1 4 2 4 3 4 4 4 5 5 1 52 5 3 5 4 5 5 5 6 5 7 5 8 5 9 5 10 5 11 5 12 5 13 5 14 5 15 9995 207 Introduction LRIC model workbooks Document roadmap Geoanalysis and access network module Part I CODE Names worksheet Inputs worksheet Summary worksheet Geoanalysis and access network module Part II DATA FR data worksheet Links worksheet ESA Gy z worksheets CAN module Contents version history and style guidelines List worksheet In Demand worksheet In Access worksheet Access worksheet Core module C V and S worksheets In Control worksheet In Demand worksheet In Subs worksheet Dem Calc worksheet In Nodes worksheet In LAS distances worksheet In TNS Gravity worksheet In Network worksheet NwDes 1 Access worksheet NwDes 2 PoC worksheet NwDes 3 Reg Nodes worksheet NwDes 4 Core Nodes worksheet NwDes 5 Islands worksheet Out Assets
26. IEN and with the CAN as calculated in rows 1943 1948 5 13 NwDes 4 Core Nodes worksheet The NwDes 4 Core Nodes worksheet is a part of the network design algorithm It contains the calculations for the dimensioning of equipment and transmission at the TNS level for the modern network design and at the Core Node level for the NGN design As per the scorched node principle the TNS calculations are performed for each of the 14 TNS locations in the existing network It is assumed that the Core Nodes are deployed in the same locations as the existing TNS nodes It uses subscriber inputs from the In Subs worksheet based on two parent TNS nodes for each LAS Per subscriber demand is from the Dem Calc worksheet is linked to this worksheet The required numbers for equipment deployed derived from this worksheet is then linked to the Out Assets worksheet These linkages are shown in the diagram below 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 113 Figure 5 67 Location of the NwDes 4 Core Nodes worksheet in the overall 7 Network design Core module structure I I I I algorithms Source Analysys NwDes 4 Core Nodes 5 13 1 Key parameters No parameter values are inserted manually into this worksheet but numerous key parameter values are linked from the In Network worksheet If required the parameters should be changed directly on the In Network
27. PoC hode data Note The data regarding the specific PoC rings is linked to the NwDez 2 PoC worksheet in cells B13 J1512 Note this is built for 1500 rows POC Name LAS Ring Number Of Is aLAS Bridging Dist To Ring Joined Is in LAS POCs in Node Next Node To Ring a Jaos N an NE ETE 7 YE wynNa way TT ae dy DT rd avo POR Name PEORLAS PERF ING PEERING Co PaRRngILe POCERidge POC Mes POOR ag dain PORNSLAR RIG LASTTNS nodes Note LAS nodes are co parented by a pair of TNS nodes Regional Node Regional Regional Co sited TNS parent TNS parent Geotgpe Core Node Core LAS site Node LAS Node LAS Regional 1 2 TNS site Node name node code ESA code Node name TNS Core Node_ ALSS ADLET BALG BRAT BANK 1 BRPT BATH BEND 2 BLAC 2 BLAK BOXL mere eoa Pera Jawa ser fse ser sere Me mere s e ser sce jeve Ser see MWe coa cme mere sae fer BNHLA CT jawa ara BRMK1 ipw Perra T wYNG sete sP LAR RATE LASA LASTER code LASparen Ti LAS parent TNS Rterame TNS TVR Figure 5 19 In Nodes worksheet output node data Source Analysys 9995 207 C Analysys Fixed LRIC model user guide Version 2 0 74 The data in the In Nodes worksheet is used in each of the network design algorithm worksheets The PoC data is used to define the parent PoC for each LE in the NwDes 1 Access worksheet as well as the trench and fibre dis
28. Selects the relevant year s demand which dimensions the access and core modules MSANs deployed in geotype Cells C8 R8 Identifies the geotypes in which next generation access network equipment is deployed This affects the dimensioned core network it is assumed that an IP core is dimensioned when any geotype is selected as being served with MSAN equipment Include business overheads Cell C17 Selects whether business overheads are included in results Distance uplift for slope effect Cells C20 C21 If required can uplift access and core trench distances to reflect slopes non flat ground Open trench parameter Cell C22 Accommodates trench that is openly available for cables to be laid in i e without incurring the trenching cost Select overlap level between Cell C25 Selects extent of overlap between access and core core and access network further discussed in section 7 11 of the main model document Table 6 1 Key parameters on the Scenario worksheet Source Analysys The figure below shows the Excel parameters defined in this worksheet DAnalysys This sheet contains scenarios implemented in the model General scenario parameters Year modelled Geotgpe MSANs deployed in geotype O no Is yes Costing scenario parameters Include business overheads Trench scenarios CORE Distance uplift for slope effect ACCESS Distance uplift for slope effect Open trench parameter SCENARIO SETUP SHEET Note To change this p
29. Where possible asset lifetimes have been based on Australian benchmark data The user may change these asset lifetimes if more accurate data becomes available To include exclude Cost xls Scenario C17 The user may include or exclude Setting this parameter to yes results business business overhead costs from the in a non zero business overheads overheads from modelled costs using this parameter figure being fed into the model on the the calculation of UnitCost Access worksheet cell costs E89 and on the UnitCost Core worksheet cell E430 To change the Cost xls RF Core D8 AG207 The majority of the routeing factors Refer to the To change the routeing routeing factors used in the model should not be changed in this table Instead changes should be made to the way in which traffic is routed through the core network refer to To change the routeing of traffic across the core network in the Core network traffic loading section of traffic across the core network in the Core network traffic loading section 9995 207 Analysys Annexes to Fixed LRIC model user guide A 15 AI Outputting results Objective Workbook Worksheet Cell reference Description Impact To inspect a single Cost xls Results Rows 75 104 The model produces a number of detailed results Some of the most interesting are year s detailed output in the stated cells results To generate Cos
30. a bridging node and the distance to the next node on the ring These distances and ring structures have been calculated according to a multi ring Travelling Salesman Algorithm e Column K identifies whether the PoC has already been accounted for in the demand calculations this is the case for bridging nodes which are listed multiple times e Columns L O calculate the TDM E1 transmission at the PoC taking into account whether the demand at the node has already been modelled column K the E1 transmission at the PoC excluding whether it is a LAS node LAS node transmission does not dimension the PoC rings the E1 transmission at the PoC excluding nodes which are bridging nodes Column O calculates the total transmission requirement on a particular ring e Columns P S calculate the NGN transmission at the PoC a similar process is followed as for the TDM transmission calculations NGN transmission is calculated in terms of kbit s e Column T calculates the number of regenerators required Rows 1521 2021 Calculation of the transmission rings deployed e Columns C D calculate the TDM and Ethernet transmission required on each ring e Column E identifies the type of traffic carried on the ring either TDM Ethernet or TDM amp Ethernet The latter of which requires a dimensioning in terms of VC 3s in order to dimension Ethernet over SDH traffic e Column F calculates the VC 3 requirement for the Ethernet over SDH traffic e Column
31. across Australia before competition H31 Defines a threshold where small ESAs will be served by satellite K12 S27 Defines the geotype in which a service is available for PSTN WLR ISDN BR ISDN PR ULLS Lines in the CAN LSS K31 Y31 Defines the minimum threshold for a service to be recognised in an ESA Without this there is the potential for small values of a service less than 1 to be extrapolated in an ESA which would not be reasonable AA33 AB5286 ESAs need to be ranked in an order that reflects the likely order in which they may be enabled with xDSL services This allows a subset of exchanges to be enabled in a logical manner ESAs are currently ordered by descending number of locations in a geotype then subsequent ESAs are ordered AD12 AH27 Defines the geotype in which a service is available for ADSL retail ADSL wholesale SDSL retail and SDSL wholesale services AK12 AL27 Average number of copper SIOs per pillar and per LPGS Linked in from the CAN module AD31 AH31 Defines the minimum threshold for an xDSL service to be recognised in an ESA Without this there is the potential for small values of a service less than 1 to be extrapolated in an ESA which would not be reasonable xDSL service availability is also limited by whether an exchange is enabled Table 5 4 Key parameters on the In Subs worksheet Source Analysys 5 4 2 Calculation Description The table below outlines the calculations that take place on the
32. and the core access demand by is informed from the Location and Demand model 9995 207 DAnalysys Annexes to Fixed LRIC model user guide A 3 geotype Database This can be modified by adjusting locations and therefore connected SIOs in each geotype Current default input is 100 for all geotypes so reflecting the Location and Demand Database For access it will likely skew the cost of an aggregate geotype e g Band 2 comprises geotypes 3 6 For core it will skew traffic loading between different geotypes Review availability Core xls In Subs K12 N27 P12 027 Toggle availability of a service in a Can remove for example WLR from of service by 12 827 geotype CBD ESAs geotype 1 2 geotype AD12 AE27 AG12 AH27 9905207 Analysys A3 Access network Annexes to Fixed LRIC model user guide A 4 Objective Workbook Worksheet Cell reference Description Impact Updating access CAN xls network parameters In Access Rows 7 273 The inputs that are contained on the In Access worksheet are an output of the analysis within the offline geoanalysis and access network module Changes to these parameters should only be made on the basis of informed adjustments in the files within this offline module Parameters are found in the Access CODE xIs workbook Summary worksheet Values can be copied in one block and paste values skip blanks onto
33. be used by the incumbents products or to other fibre services i e available for the use of third parties This allocation is based on the distances of SDH fibre metres and other fibre metres explicitly calculated in the Core module The figure below shows an Excel output of the calculation of fibre assets between SDH and other fibre Es WM Analysys Fixed LRIC model user guide Version 2 0 149 Calculation Cost allocation Fibre Ad Fibre Asset group Asset Fibre Core cost SDH Other fibre SDH Other fibre type type services services indez or metres or metres metres metres Incremental 2 401 269 947 1 200 634 974 67x ATI AT2Z ATI Fibre PO eee EER TEELS ELE ED ATI AT2 ATt Trench Incremental 2 401 269 947 1200834974 BH ATI AT2 AT1 Duct Incremental 2 401 269 947 1200 634 374 1 AT2 Potts AT2 ATIrings 10Mbitls ports __ Incremental EE E AT2 Ports AT2 ATI rings 100Mbit s ports ___9 Incremental EE Ee ena ee AT2 Ports AT2 AT1 rings 1GE ports to Incremental 3 LEIATI LE PoC Fibre Incremental 2 401 269 947 1 200 634 974 3 ORR T ENSS LEVATI LE PoC Trench Incremental 2 401 269 947 1200634974 BH 8 LE AT1 LE PoC Duct Incremental 2 401 269 947 1 200 634 974 Figure 6 21 Calculation of fibre assets between SDH and other fibre Source Analysys Cell reference Description and details of soreadsheet calculations Columns P S Calculation of cost allocation of SDH assets between platforms and transmissi
34. calculate the shelf and rack requirement e Columns R S calculate the AT1 and AT2 MSAN requirement e Columns T W calculate the AT2 Ethernet backhaul link requirement Calculation of the transmission requirements for the LE PoC links e Column D identifies whether the LE is remote from the PoC i e not co located e Columns E G calculate the transmission requirements in terms of PSTN and ISDN BHE and xDSL kbit s this is based on the average traffic per subscriber linked in from the Dem Calc worksheet and the number of subscribers at a particular LE e Columns H M calculate the total TDM transmission E1 requirements an Erlang formula is used to calculate the E1 requirement for the BHE traffic e Columns N R calculate the total MSAN transmission kbit s requirements e Columns S X calculate the SDH transmission link requirement A payload in terms of E1 Virtual Containers for each STM x is used to determine the appropriate transmission speed link required e Columns Y AA calculate the Ethernet transmission link requirement A DAnalysys Fixed LRIC model user guide Version 2 0 88 payload in terms of kbit s is used to determine the appropriate Ethernet link speed required Rows 15796 15799 Calculation of the platform use of links for the allocation of costs this information is used in the Cost module Rows 15806 21071 Calculation of the LE PoC fibre assets deployed e Columns C D link in the LE PoC trench and fib
35. defined for 2007 A unit Adjusting any of the unit price trends asset unit cost trend for the core network assets cost price trend is applied in order to calculate the asset unit costs for the years 2008 2012 These trends are where possible based on Australian network data These price trends may be changed by a user will result in a different total unit cost flowing through to the TA Core worksheet for future years column G It will also affect the tilted annuity formula input in column J 9995 207 Analysys Annexes to Fixed LRIC model user guide A 12 Objective Workbook Worksheet Cell reference Description Impact To change the Cost xls UnitCost Core D9 D21 The lifetime of assets controls their Adjusting the asset lifetimes will affect lifetime of core replacement cycle and more importantly the tilted annuity calculation on the network assets affects the tilted annuity calculation TA Core worksheet column L Where possible asset lifetimes have been based on Australian benchmark data The user may change these asset lifetimes if more accurate data becomes available To change the unit Cost xls UnitCost Access E118 H198 The equipment costs used in the model Adjusting any of the unit cost capital costs for have where possible been based on components will result in a different the access network Australia network data Where this total unit cost flowing through to the assets information was un
36. deployment of MSAN equipment for its traffic then a NGN core is required this assumes IP transport and SIP signalling Note this parameter is controlled from the Cost module To change this parameter the user should go to the Scenario worksheet in the Cost module As soon as a single geotype is selected as having MSAN equipment deployed then an IP core network is modelled Deploying MSN equipment in a geotype results in the NGN core network algorithms being implemented Furthermore costs from the access network are transferred to the core network as the core network boundary is pushed out further into the access network The transfer of costs from the access to the core networks is calculated on the TA Access worksheet cells M94 N96 in the Cost module This should only be set to TRUE in order to deploy an IP core when the access network is using TDM equipment If set to TRUE for the core then DWDM equipment is deployed instead of SDH ADMs at the TNS core node locations for the transport of transit traffic If set to TRUE for the LAS regional network DWDM is deployed if demand is sufficient and SDH if demand is lower If FALSE only SDH is deployed This affects the calculation on the NwDes 3 Reg Nodes worksheet and on the NwDes 4 Core Nodes worksheet Rather than carrying traffic on multiple fibres traffic is carried on individual wavelengths within a single strand of fibre This effectively r
37. drop cable size Other outputs Location data and DP cluster uses co ordinates in Map Grid of Australia AMG Assets volume by pillar List of edges in fibre ring Data on spanning trees connecting address locations Data on DP clusters Location Cells B6 C28 Cells G5 129 Cells K5 N28 Cells R5 U27 Cells Y27 DZ27 Cells Z7 AB16 Cells AF7 AM22 Cells AS7 AU15 Cells AX7 BB11 Cells AU18 AU20 Cells B37 K Cells M37 AY286 Cells BA37 BD286 Cells BF37 BV Cells BX37 CJ Impact Derived from several sources and specific to the ESA A key to the acronyms used on the worksheet is also included An approximate breakdown for the time spent at each stage of the last calculation and the total time taken to process the ESA These are the assumptions used within the latest calculation of the ESA The code reads in data from the Inputs worksheet even if it does not use it As far as possible only the values actually used in the calculation are printed These values are for archiving only changing them will not affect the printed output volumes Approximately 100 quantities are calculated for the whole ESA based on the outputs for the last calculation These are linked into the Summary worksheet in Access CODE xls to be extrapolated for the purposes of the CAN module Length of trench by ducts provisioned for the last calculation up to a maximum of 28 duct Coeffici
38. for the selected year is subsequently used in the calculation of the total cost of the core network on the TA Access worksheet Figure 6 35 Location of the UnitCost Access worksheet in the overall Cost module structure Source Analysys TA Access 6 16 1 Key parameters This worksheet contains unit cost data for 2007 cells D118 D198 based on benchmark data sources An allowance percentage uplift on the asset unit cost is made for spares cells E118 E198 installation cells F118 F198 and for indirect assets costs cells G118 G198 At present the model is populated with a 0 uplift for spares a 15 installation uplift for equipment assets the duct including trench and fibre asset unit costs already contain installation costs and a 0 uplift for indirect costs Duct costs are derived by a set of calculations in rows 10 48 with separate calculations for trenched duct open duct and ploughed cable e trenched duct costs are built up from the costs of the trench the actual duct and the guard wire e open trench omits the cost of the trench i e assuming access to trench at minimal cost e ploughed cable costs use a second set of costs in rows 37 48 ii WM Analysys Fixed LRIC model user guide Version 2 0 167 In cells AG10 AW35 calculations are made to determine the relative proportion of the trenching element of the duct deployment costs This is used to inform the allocation o
39. hub LTH site The voice and data traffic is backhauled in the same trenches In the NGN structure the regional node handles both voice and data traffic using IP Both sets of traffic may be carried on the same fibres Time Division Multiplexer TDM based traffic from NGN parts of the network are modelled to be connected to the IP core at the regional node location by means of a transit gateway switch This worksheet uses subscriber inputs from the In Subs worksheet based on the parent LAS in each PoC ring Per subscriber demand from the Dem Calc worksheet is linked to this worksheet The required numbers for equipment deployed from this worksheet is linked to the Out Assets worksheet state WM Analysys Fixed LRIC model user guide Version 2 0 100 Figure 5 43 Location of the NwDes 3 Reg Nodes worksheet in the overall Network design algorithms Core module structure Source Analysys NwDes 3 Reg Nodes NwDes 5 Islands 5 12 1 Key parameters No eguipment parameter values are inserted manually into this worksheet but numerous key parameters set out below are linked from the In Network worksheet If required these parameter values should be changed directly on the In Network worksheet LAS routes are defined on this sheet and are only expected to be changed occasionally if an alternative set of routes are required for LAS TNS rings 9995 207 jw A
40. labels currently used for the deployment algorithms within the geoanalysis and access network module These are the labels used to denote the three different means of deploying fibre within an ESA These allow the ESAs having their access network calculated to have either tapered or non tapered copper cabling back to the pillar These are the two options with which the code sub module can recalculate the asset volumes for the ESAs in the data sub module Labels Rows 49 56 These are the labels for the possible clusters derived by the access network deployment algorithms Table 2 1 Key parameters on the Names worksheet Source Analysys 2 1 2 Calculation description The main named parameters stored on this worksheet are summarised below Cell reference Description and details of spreadsheet calculations Rows 5 18 Geotype names Rows 23 26 Methodology to use when calculating for an ESA Rows 30 32 Nature of fibre connections Rows 37 38 Nature of distribution network Rows 43 44 Options for calculating for ESAs Rows 49 56 Labels Table 2 2 Calculations performed on the Inputs worksheet Source Analysys Cell reference Description and details of spreadsheet calculations Rows 5 18 Geotype names These are the labelling used for the geotypes that are included within the geoanalysis and access network module It should be noted that the CAN module also contains a 15th and a 16th geotype However the
41. per ring Controls the number of PoCs that dimension a PoC ring Number of PoCs before using Generic Algorithm Defines whether a Genetic Algorithm is required otherwise an exact solution is determined an exact solution may take an extremely long time if many gt 12 PoCs are modelled Number of generations to use in Generic The more generations that are used the more likely the Algorithm optimum solution is determined Table 5 8 Parameters in LE_LAS_ring xls Source Analysys The structure of the external LE_LAS_ring xls workbook is outlined in Annex B This external data is pasted into this worksheet in the blue bordered cells cells F41 H5294 for the LE AT1 node data and cells B5300 J6799 for the PoC node data The inputs related to the overlap analysis in cells C11 D15 D21 D24 and O20 U24 are the result of the MapInfo calculations as described in section 7 11 of the Fixed LRIC model documentation The can be changed by users should alternative data be available 5 6 2 Calculation description The table below outlines the calculations that take place on the In Nodes worksheet 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 76 Cell reference Description and details of worksheet calculations Rows 11 34 Derives the proportional overlap of the inter exchange IEN network trench within the IEN and with the access network Rows 41 5294 Input data defining the parent PoC for each LE and trench d
42. reference Row 5 Rows 14 5268 Rows 5276 10529 Rows 10538 15791 9995 207 Description and details of spreadsheet calculations Check that the traffic totals reconcile Calculation of TDM based equipment requirements e Column D identifies whether the LE is served by TDM equipment e Columns E G link in the PSTN amp WLR ISDN BR and ISDN PR SIO data from the In Subs worksheet e Columns H K calculate the PSTN and ISDN line card requirement taking into account utilisation e Columns L M calculate the shelf and rack requirement for PSTN and ISDN services assuming that PSTN and ISDN services are connected on the same equipment e Columns N O link in the ADSL and SDSL SIO numbers from the In Subs worksheet e Columns P Q calculate the xDSL line card requirement taking into account utilisation e Columns R T calculate the shelf rack and backhaul requirement for xDSL services e Column U calculates the total number of LE sites e Column V calculates the total number of network units for LPGS backhaul Calculation of NGN MSAN equipment requirements e Column D identifies whether the LE is served by NGN equipment e Column E links in the number of pillars and LPGS from the CAN module accounting for whether NGN equipment is used e Columns J L link in the copper SIO numbers PSTN ISDN and VDSL e Columns M O calculate the required number of line cards based on the available ports per line card e Columns P Q
43. required in order to approximate the effect of economic depreciation This tilt adjustment parameter is contained in Column K All other calculations on the worksheet are autonomous me WM Analysys Fixed LRIC model user guide Version 2 0 156 6 12 2 Calculation description This worksheet calculates the annualised capex cost and subsequently adds the opex cost in year to generate the total cost by asset For certain assets there are identified savings within the core network and with the access network These cost savings are calculated and allocated to the access network where applicable These costs are allocated to the various platforms Shared network costs are marked up on the incremental network costs by platform using an EPMU Finally the service cost calculation is performed The following table outlines the calculations that are contained on the TA Core worksheet Cell reference Description and details of spreadsheet calculations Cells B11 0210 Cells P11 P210 Cells T11 T210 Cells Y11 AA210 Cells AC11 AC210 Cells AE11 AK210 Cells AM11 FE210 Cells AE213 FE213 Rows 217 228 Rows 234 330 Asset cost annualisation calculation Calculation of the proportion of costs allocated to access Calculations of the core costs transferred to the access network Calculation of the distribution of core costs between shared business overheads and incremental costs Calculation of the incre
44. ring structure Physical ri ng Structures Note different LAS ring structures may be entered however care should be taken that the routes are realistic when comp Perth rings Links to TNS LAS LAS LAS LAS LAS LAS in another metro area Nodes ol Ring 1 PWTA PPTA CANC MIDN GNGJ HMSX of Ring 2 PWTA 0 Ring3 PWTA 1 Ring4 PPTA 1 Ring5 PPTA of Ring 6 Figure 5 56 Excel layout for composition of LAS ring structures Source Analysys 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 109 The model calculates whether a particular LAS is co located with a TNS unit This calculation is used to take into account the assumption that when co located the LAS traffic is carried on the transit rings rather than on the LAS rings LAS not colocated with TNS LAS LAS LAS LAS LAS LAS Ring 1 Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 Figure 5 57 Excel calculations for co location of LAS units with TNS units Source Analysys Due to the physical nature of the LAS ring structures certain rings may pass through the same node to node paths to model the usage of the same trench the deployment of incremental trench is defined by the user Incremental trench deployed LAS LAS LAS LAS LAS LAS Ring 1 Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 ala alslalsl a a 1 Figure 5 58 Excel layout for parameters determining the deployment of incremental trench Source An
45. row 230 specifies the proportion of trench and duct cost by geotype within the CAN that should be allocated to the core for IEN usage The calculation for this is explained below To capture the cost saving arising from the use of CAN trenches by duct used for the IEN we calculate the distance of overlap between the two networks in the Core module This is informed by the overlap analysis discussed in section 7 11 of the FLRIC report The modelling approach adopted is based on deploying IEN duct in existing CAN trench and allocating a proportion of the jasan WM Analysys Fixed LRIC model user guide Version 2 0 162 CAN trench cost to the IEN The relative use and resulting cost allocation of the CAN by the IEN is calculated based on the following steps 1 Lines 215 225 The volume of meters of duct deployed in the CAN for the use by the CAN is calculated informed by the CAN module 2 Line 227 the volume of meters of duct deployed in the CAN for the use by the IEN is known from calculations on the I Ducts Core worksheet This volume is distributed by geotype in the same ratio of CAN duct by geotype 3 Line 228 the volume of IEN duct deployed in the CAN as a proportion of total duct deployed CAN amp IEN is calculated 4 Line 229 the proportion of cost attributable to just trenching in the trench and duct CAN asset type is provided from the UnitCost Access worksheet 5 Cell C230 the proportion of cost s
46. the NGN according to the routed service demand Calculation of the busy hour load for each part of the NGN on a per PSTN SIO and per ISDN SIO basis Table 5 7 Calculations performed on the Dem Calc worksheet Source Analysys The remainder of this section details the calculations that take place on the Dem Calc worksheet Calculation of busy hour demand Cell reference Rows 25 88 Description and details of spreadsheet calculations Demand calculation of service busy hour Erlang load and busy hour call attempts The calculation of the busy hour Erlangs kbit s is shown below and explained in detail below 9995 207 Analysys Fixed LRIC model user guide Version 2 0 68 Figure 5 9 Calculation of demand loading on each part of the core network Source Analysys Demand is calculated separately for the MSAN and non MSAN equipment e Columns E F link in the level of demand and number of calls by service for the selected year from the In Demand worksheet e Column G calculates the average duration of calls for those services that are measured in terms of minutes e Columns H I calculate the average number of call attempts per successful call e Columns J K link in the average ringing time for successful and unsuccessful calls e Column L calculates the number of occupancy minutes by service This calculation is based upon the average duration of successful calls plus ringing time for succ
47. the capacity of an earth station and the number of services in operation on the island modelled The Excel output for the islands containing an LE is shown below UIE vave PLUIS PSE min Note identifies ub tended links to agregate Note assume backhauled by microwave to next closest LE in chain back to PoC Satellite Note assume satellite goes to Earthstation in core Riometes e to be deducted Note additional LE s may be identified az being served by special backhaul solutions The user should enter the LE cod note this allows Eas remove road uplift LE code Indexed LE name geotype PSTN amp Backhaul Identify nezt sd iek Microwave Number of position WLR SIOs oen to LE intree distance hopes earthstatio required ns required Microwave j Microwave ines mes EE EEEE SIS elele o lele s 7 2 2 2 le Ja o Jo fa cfc cfc fc 8 z a S 5 o Figure 5 86 Subscriber traffic and transmission calculations for each of the islands that require a special network solution Source Analysys a WM Analysys Fixed LRIC model user guide Version 2 0 128 Linking Tasmania to the mainland is modelled using a submarine cable as per reality This length replaces that deployed on the NwDes 3 RegNodes worksheet Note Submarine cable link from Tasmania Data to be deducted Note only build fc Kilometres Sheath LAS ring in Me metres LAS code LAS n
48. the same directory for the Visual Basic to work ESA index and corresponding Rows 21 239 These volumes are linked in and their values are demand input from the data sub post processed to be fed into the CAN module module These should only be changed by re calculating the ESAs under different assumptions selected in the Inputs worksheet Table 2 5 Key parameters on the Summary worksheet Source Analysys 2 32 Flow diagram The Summary worksheet plays a role in both the input and output of the geoanalysis and access network module The ESA indices are used to identify which ESAs are to be processed by the 9995 207 Analysys Fixed LRIC model user guide Version 2 0 32 Visual Basic whilst the main table on the worksheet linked to all the workbooks in the data sub module display the total volumes derived by the calculations Figure 2 32 Location of the Inputs sa I i a a li a worksheet within the Access network deployment algorithms driven by the macro FullAccessNetworkBuild overall structure of the geoanalysis and access network module Source Analysys For each ESA Gy z in the list to run 2 3 3 Calculation description Below the main table linking in volumes from the DATA workbooks a summary of volumes and ratios for each geotype is calculated Then a series of calculations that derive average volumes on a geotype basis to be fed into the CAN module are pe
49. worksheet in the overall Cost module structure Source Analysys Demin Access 6 13 1 Key parameters This worksheet contains key data inputs from the CAN module The key parameters that can be adjusted manually are the proportion of access network assets that are allocated to the core network This parameter represents core network assets such as transmission back from LPGS i e equipment that is core side of the main distribution frame MDF that has been inherently calculated within the CAN module Parameter Location Impact Proportion of trench and duct cost C230 Allocated asset cost away from the allocated to core for IEN usage access network and onto the core network Table 6 15 Key parameters on the Inputs Access worksheet Source Analysys 6 13 2 Calculation description The following table outlines the calculations that are contained on the Inputs Access worksheet ii WM Analysys Fixed LRIC model user guide Version 2 0 160 Cell reference Description and details of spreadsheet calculations Row 3 Year modelled Rows 8 37 Service demand by geotype Rows 42 126 Network assets required by geotype Rows 130 230 Allocation of duct and trench and fibre asset costs to the core network Table 6 16 Calculations performed on the Inputs Access worksheet Source Analysys The remainder of this section provides an overview of the calculations that are performed on the Inp
50. 1 TDM traffic NGN traffic Total LAS ID LAS Name BH Erlangs E1 links kb ALBG ALBURY ALSG ALICE SPRINGS AXE ADLJ ARMIDALE BALJ BALGOWLAH S12 BRAJ BALLARAT S12 BAKN BANKSTOWN 1 S12 BRPT BANORA POINT BATJ BATHURST AXE BEGX BEGA AXE BENV BENDIGO LAS BLAP BLACKTOWN AXE 2 BLHJ BLAKEHURST AXE BHLX BOX HILL Figure 5 53 Transmission requirement calculation for LAS LAS traffic Source Analysys Cell reference Description and details of soreadsheet calculations Rows 888 1021 Transmission requirement for LAS TNS LTH MTH links A screenshot of the Excel LAS TNS transmission calculations is shown below LAS TNS LTH MTH traffic LT Note TDM traffic is transmitted in terms of E 1 carriers NGN traffic is tansmit gplifttere TDM based traffic PSTN ISDN XDSL PSTN ISDN LAS ID LAS Name ALBG ALBURY ALSG ALICE SPRINGS AXE ADLJ ARMIDALE BALJ BALGOWLAH S12 BRAJ BALLARAT S12 BAKN BANKSTOWN 1 S12 BRPT BANORA POINT BATJ BATHURST AXE BEGX BEGA AXE BENV BENDIGO LAS BLAP BLACKTOWN AXE 2 BLHJ BLAKEHURST AXE BHLX BOX HILL Figure 5 54 Transmission requirement calculation for LAS TNS MTH links Source Analysys Cell reference Description and details of spreadsheet calculations Rows 1023 1162 9995 207 Transmission requirement for LAS Interconnection links Analysys Fixed LRIC model user guide Version 2 0 108 Interconnection to other networks may also take place at the LAS level Interconnect
51. 16 Determines whether routes including an LTH LTH link are included in the calculation of network routeing asset utilisation for ISDN Table 5 6 Key parameters in the Dem Calc worksheet Source Analysys n l 9005 207 W Analysys 5 5 2 Calculation description Fixed LRIC model user guide Version 2 0 67 The table below lists specific data inputs and calculations by row number Cell reference Description and details of spreadsheet calculations Rows 5 21 Demand parameters used to calculate the busy hour load on the network Rows 25 88 Demand calculation of service busy hour Erlang load and busy hour call attempts modern and NGN Rows 98 127 Input amp calculation of modern network service routeing factors Rows 134 230 Rows 234 264 Rows 267 271 Rows 280 309 Rows 316 334 Rows 338 370 Rows 372 377 Input and calculation of the modern and NGN service routeing factors according to weighted network call paths through the network by traffic type Calculation of the busy hour load for each part of the modern network according to the routed service demand Calculation of the busy hour load for each part of the network on a per PSTN SIO and per ISDN SIO basis modern network Calculation of NGN service routeing factors Calculation of the NGN service routeing factors according to the weighted network call paths through the network by traffic type Calculation of the busy hour load for each part of
52. 2 port cards dimensioned It is assumed that they require 48 port cards to link to the MSANS and 12 port cards to link TGWs and edge routers The capacity of a chassis is five slots for connectivity cards Links to Edge Links to Links from PoC nodes 48 port cards required 12 port cards Chassis Router Trunk reguired reguired LAS ID LAS Name 12 port card ALBG ALBURY ALSG ALICE SPRINGS AXE ADLJ ARMIDALE BALJ BALGOWLAH S12 BRAJ BALLARAT S12 BAKN BANKSTOWN 1 S12 BRPT BANORA POINT BATJ BATHURST AXE BEGX BEGA AXE BENV BENDIGO LAS BLAP BLACKTOWN AXE 2 BLHJ BLAKEHURST AXE BHLX BOX HILL Figure 5 49 Excel calculations for the NGN edge switch dimensioning Source Analysys 9995 207 jw Analysys Fixed LRIC model user guide Version 2 0 105 Figure 5 50 Calculation of the number of Edge Switch chassis units required Source Analysys Cell reference Description and details of spreadsheet calculations Rows 583 716 NGN edge router dimensioning The Edge Routers are responsible for the routeing of traffic from the regional nodes to the core nodes using 1Gbit s two port cards The chassis unit has a capacity of 12 card slots and we assume that each edge router has a minimum of two of these cards 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 106 NGN EDGE ROUTER dimensioning Edge router traffic per PSTN sub Edge router traffic per ADSL sub 25 07 Capacity 1GigE 1 000 000 Redunda
53. 4 8 4 2 P9 PS P9 3 18 279844 6131374 228 2 4 6 2 5 Pa Pg Pg 3 19 279834 6131373 209 1 5 1 1 1 PS PS PS 3 20 279837 6131374 213 2 4 2 2 1 P6 PS PE 3 21 279840 6131374 223 2 4 3 2 2 PS PS P6 Figure 3 8 Excel outputs on location of distribution points Source Analysys aa WM Analysys Fixed LRIC model user guide Version 2 0 48 4 CAN module The CAN module contains the calculations for the dimensioning of the network assets required from the customer location back to the local exchange LE extrapolating for all customer locations in Australia This module is structured as follows Figure 4 1 Structure of the CAN module Source Analysys Access e The List worksheet links in defined names from the Cost module and defines names used within the workbook e The In Demand worksheet contains the demand mapped to geotypes from the Core module and location data derived via geoanalysis using MapInfo e The In Access worksheet contains the output data pasted in from the CODE workbook e The Access worksheet contains the main calculations extrapolating the data derived from the geoanalysis of the sampled ESAs up to all ESAs In terms of the CAN architecture it is important to establish the terminology used regarding the component elements of the path forming the access network 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 49 Element NTP gt gt Property boundary P
54. 4 CoreNodes worksheet 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 83 5 9 In Network worksheet This worksheet contains the network parameters used within each of the demand and network design algorithm worksheet in the Core module These linkages are shown in the diagram below ES Figure 5 30 TE Location of the In Network she s MAREE RE LEEETEETEEETETTI i Preeti terry EES worksheet in the overall EEUE Er Core module structure Network design l algorithm a i Source Analysys NwDes 1 i Access NwDes 2 PoC NwDes 3 4 WDes J Reg Nodes v NwDes 4 Core l Nodes l EA EE y i l NwDes 5 l Islands i E ee EE iaj I gt 5 9 1 Key parameters This worksheet contains the network design parameters including equipment and transmission link capacities and asset utilisation parameters used within the demand and network design algorithms in the Core module Many of the parameters are based on either industry standards or are based on operator industry submissions Analysys recommends that users do not readily change these parameters The table below identifies the parameters that may be readily altered by users 9995 207 jw Analysys Fixed LRIC model user guide Version 2 0 84 Parameter Busy hour data Exchange equipment parameters Grade of service Cost threshold for transmission equipment Location Impact Rows 11 26
55. 42 for each ring structure This binary network equipment requirements E351 R364 structure representing whether traffic E373 R386 from a particular TNS location is carried E395 R408 on the TNS ring may be altered by the E416 R429 user in order to reflect other ring traffic routeing set ups It is however recommended that the current structure is not readily changed without due consideration A 6 Core network technology deployed and equipment parameters Objective Workbook Worksheet Cell reference Description Impact To implement only Core xls In Control C11 This switch set to TRUE forces TNS This affects the calculation on the DWDM equipment on TNS links traffic to be carried using DWDM transmission equipment With FALSE set the alternative is a mix of DWDM and SDH dependent on demand NwDes 4 Core Nodes worksheet Rather than carrying traffic on multiple fibres traffic is carried on individual wavelengths within a single strand of fibre or several fibres if demand 9995 207 Analysys Annexes to Fixed LRIC model user guide A 8 9995 207 Objective Worksheet Cell reference Description Impact requires This effectively reduces the number of fibre metres and SDH systems deployed in the core network To implement In Control C12 This switch set to TRUE allows LAS This affects the calculation on the DWDM equipment traffic to be carried using DWDM NwDes 3 Reg Nodes worksheet on LAS links tran
56. 6 23 Calculations performed on the Recon worksheet Source Analysys 9995 207 ID Ana lysys Annex A Quick start guide to active modules Annexes to Fixed LRIC model user guide A 1 To further aid the model user a quick start guide or crib sheet has been developed for the active modules in the LRIC model This annex identifies the common tasks and considerations that users may wish to undertake or review when using the LRIC model following a logical flow It is intended that this document is supplementary to the main body of the model user guide document above and which provides a more detailed description of the calculations that take place on each worksheet in the active modules in the LRIC model This crib sheet document specifically outlines for each of the identified tasks e g changing the modelled year of interest the location within the model of the appropriate parameter to be adjusted the description of how to change this parameter and the effect of changing this parameter To produce a LRIC model result all three active modules needs to be open To run the model press F9 to calculate the modules are provided with manual calculation enabled Al Scenario setup Objective Workbook Worksheet Cell reference Description Impact To change the Cost xls Scenario C5 To change the year modelled select the The appropriate year s input data modelled year appropriate year from the pull down such as traf
57. 9 Affects maximum utilised capacity of the H1517 R1519 backhaul links from the PoC to the LAS Fibre uplift parameter for spares and U1519 V1519 Deployment of spare other fibre above other fibre services those required just for the PoC ring CAN IEN and inter IEN overlap 2025 S2027 Affects the volume of duct and trench parameters assets calculated for the PoC level The distance of duct within CAN areas is retained for cost allocations between and CAN and IEN Percentage of trench that is ducted K2065 Affects the amount of trench that is ploughed versus that which is deployed with ducts Table 5 17 Key parameters in the NwDes 2 PoC worksheet Source Analysys 5 11 2 Calculation description This worksheet contains network design algorithms for the PoC level This includes calculations for the equipment required and link transmission dimensioned for the links from the PoC to the LAS The table below lists specific data inputs and calculations by row number 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 97 Cell reference Description and details of spreadsheet calculations Row 7 Check that the traffic totals reconcile Rows 13 1513 Calculation of the transmission required at each individual PoC location e Columns B J link in the PoC ring data from the In Node worksheet This identifies the number of PoC nodes on the LAS rings whether the PoC node is the LAS node whether the PoC node is
58. ADSL SDSL Bhkbit s per sub 0 00 22 72 22512 Voice Data Core router ports used 1 4 Core port capacity kbps 1 000 000 Core router port utilisation 80 Ports per 1GE card 4 Cards per chassis 15 Note core routers are driven by the port reguirement for voice and data traffic Core router capacity required Type Site_ID Site_Name BH voice BH data Capacity for Capacity for bandwidth bandwidth voice traffic data traffic Core node ADELAIDE TN Core node ADELAIDE TN Core node BRISBANE TN Core node BRISBANE TN Core node CANBERRA T Core node CANBERRA T Core node MELBOURNE Core node MELBOURNE Core node MELBOURNE Core node PERTH TNS1 Core node PERTH TNS2 Core node SYDNEY TNS Core node SYDNEY TNS Core node SYDNEY TNS Figure 5 73 Calculations for NGN Core router dimensioning Source Analysys Cell reference Description and details of spreadsheet calculations Rows 147 165 NGN Core switch dimensioning Core switches aggregate traffic for delivery to and from the core routers DSL data related elements and softswitch elements It is assumed that lower capacity 48 port electrical Gigabit Ethernet GE cards link to the softswitch call server and access gateway plus the DNS and RADIUS servers as only signalling traffic is carried across these links The BRAS Web server and core router are connected via the higher capacity 12 port optical GE cards It is further assumed that the capacity
59. AF gt gt Road centre e Average distance Property boundary gt gt road centre Captures assumption for NTP gt gt PB as of GNAF gt gt PB Calculates Average distance NTP gt gt PB Cells K58 K73 Input the assumption for the distance of the serving pit from the property boundary If required change input by geotype N55 Define the Serving pit architecture Option 1 Serving pits placed at DP moved towards pillar by geo analysis Option 2 Serving pits placed at location closest to demand weighted centre of cluster N76 Q76 Input proportion of property boundary width built to A N81 R81 Input proportion of DPs where road crossing deployed N82 Q82 Defines additional serving pits required per road crossing R83 Defines proportion of isolated FDPs requiring an additional serving pit L58 V73 Calculation of distances for serving pit to property boundary Table 4 2 Key parameters on the In Demand worksheet Source Analysys 9995 207 C Ana lysys Fixed LRIC model user guide Version 2 0 52 4 3 2 Calculation description One significant calculation is performed on this worksheet to derive the distances between the NTP property boundary PB and serving pit SP within DP clusters A number of calculations were performed in the geoanalysis to understand the magnitude of the distance for the path from the NTP to the serving pits Using the G NAF locations for the sampled ESAs the land parcel boundaries from Cad
60. Access worksheet the calculated LAS subscribers are linked into the NwDes 3 Reg Nodes worksheet and the calculated TNS subscribers are linked into the NwDes 4 Core worksheet Due to rounding effects subscribers by geotype do not quite total the input value therefore the resultant values replace the projections in the Core module The calculated subscriber numbers are used on the In Demand worksheet specifically in cells C10 R15 K29 K36 K37 K40 K42 and K50 and subsequently into the Dem Calc worksheet where they are used to calculate the demand per subscriber These values of demand per subscriber are then used at each level in the network deployment algorithm These linkages are shown in the diagram below Analysys Fixed LRIC model user guide Version 2 0 63 Figure 5 7 Location of the In Subs worksheet in the overall Core module structure Network design algorithms Source Analysys 5 4 1 Key parameters The key parameters on the In Subs worksheet impact the distribution of subscribers by geotype 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 64 Location Description E12 E27 Adjust locations is a set of parameters can modify the identified locations from the location and demand database to reflect the known number of total SIOs by geotype However these inputs have been set to a default of 100 replicating the potential demand
61. B PB gt gt serving pit S P Road crossing gt gt DP FDP gt gt DP DP gt gt pillar LE Pillar gt gt LE LPGS gt gt LE non ring deployment Link on fibre rings pillar to pillar Description The distance from the network termination point NTP of a customer to the property boundary It is normally assumed that the trench is provided by the customer The distance from the property boundary to the S P on the same side of the road as the property at the terminus of the road crossing passing underneath the road towards the customer s property The distance from the NTP to this S P is the customer lead in The trench that passes underneath the road between the serving pits either side of the road with one S P located at the actual DP location The trench between FDPs and their parent DP in a DP cluster This aggregation of demand corresponds to the first level of clustering within the URBAN deployment algorithm DPs are linked back to a local pillar or for those DPs near the exchange to the pillar at exchange The pillar is a point in the access network at which sets of cables from DPs are aggregated for backhaul to the LE Represents the link from pillars remote from the LE back to the LE Represents the links from a LPGS large pair gain system back to the LE An LPGS is a multiplexer unit deployed remotely from the LE in order to provide a telephony service to households that would otherwis
62. B result in different core network route distance data here This workbook can be re run with configuration for LE POC and POC new parameters or locations and the rings values updated in the Core module It should be noted that the access and core overlap analysis which provides real route distances is only applicable to the specific TSP solution However results from the overlap analysis including trench sharing and crow fly versus actual distance are likely to be broadly applicable To change the Cost xls Scenario C20 Core network distances may be affected Increasing the uplift factor directly distance uplift by slope a parameter in the model is increases the trench and fibre factor in the model used to accommodate this The user may distances deployed on core network for slope effects change this percentage uplift routes in the Core x s workbook To change the Core xls NwDes 3 Reg Nodes C1176 T1185 LAS rings are identified separately for Changing LAS ring structures impacts structure of LAS C1300 T 1309 each of the main city regions in Australia upon the LAS trench and fibre rings C1424 T1433 A particular ring is described by entering distances deployed in the network C1548 T1557 a series of LAS nodes on a particular the distances of which are calculates C1672 T1681 row Different ring set ups may be from the In LAS distances C1796 T1805 envisaged by selecting different worksheet It also affects the combinations of LAS nodes
63. Figure 3 1 the list to run Location of the FR data worksheet within the overall structure of the geoanalysis and access network module Source Analysys FR The chart FR is currently limited to displaying the edges corresponding to the first thirty rows in the table in FR data If there are more pillars then the rings will appear incomplete as not all edges can be displayed The chart will then require additional series as appropriate 3 1 1 Key parameters The only parameter is in cell D3 and is the index of the ESA in the workbook for which the user would like to plot the fibre ring s The relevant co ordinates are then linked into this worksheet in cells BA37 BD286 from the worksheet of the corresponding ESA 3 1 2 Calculation description The FR data worksheet is used to generate the co ordinates for plotting the fibre rings This is used to plot the chart FR an example of which is shown in the figure below 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 38 6 133 200 6 133 000 6 132 800 6 132 600 6 132 400 6 132 200 6 132 000 y 6 131 800 6 131 600 6 131 400 1 r 1 r 1 r 1 1 280 800 281 000 281 200 281 400 281 600 281 800 282 000 282 200 282 400 Figure 3 2 Excel plot of fibre ring for a selected ESA Source Analysys 32 Links worksheet This worksheet contains linked labels and inputs from the Access CODE x
64. J File directory PaprojectsKACIWPYKACIOD4A Resi sie airecrery Root for ESA workbook Access DATA G FOR data fllerame Number of geotgpes Number of ESAs sampled Copper centre Workbook Indez Geotgpe ESA in Band ESA Number AMG AMG AMGy Number of geotgpe of SIOs locations 7 54 280475 6 192 510 321266 56 502 671 56 502 485 56 501 303 54 278 333 6 128 479 55 317 710 5 915 572 55 328 434 5 911626 Figure 2 33 Excel sample of summary of volumes for each ESA Source Analysys Data in Columns F H and M DO is linked in from the relevant workbook from the data sub module We also note that we have split certain ESAs due to them having multiple copper centres Hence one ESA can be in the table several times A dash and a numerical identifier are used on the end of the four letter ESA code to differentiate these For example ESAs 25 and 26 are the two parts to the Tuart Hill ESA and are labelled as TUTT 1 and TUTT 2 respectively 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 34 Cell reference Description and details of spreadsheet calculations Rows 243 258 Summary of volumes by geotype and by band The volumes in the main table are also aggregated by geotype and then further by band as shown below Summary of volumes by geotype Geotgpe summar Count ESAs 862 386 1 334 615 196 217 Geotype 1 3 12 524 51 942 3 3 Geot
65. L deployments and are excluded from urban deployments due to the comments in column H to the right Units of demand 2 10 30 50 100 Total sheath Total copper lenaths pairs T 2 3 4 5 6 7 8 g 10 n 12 13 14 15 16 17 18 19 20 21 22 HABA NNNNNNOONN a ss aas aNND oo Figure 2 14 Excel parameters to determine combinations of copper cable deployed for varying levels of demand in urban areas Source Analysys ee WM Analysys Fixed LRIC model user guide Version 2 0 20 The parameters in G84 K133 are used when determining the copper pairs need to link a location to its parent DP in an urban deployment For example we assume that 4 units of demand are served by two 2 pair cables whereas 6 units of demand are assumed to use one 10 pair cable This table must be kept updated given changes in the minimum demand threshold for locations to be fed by fibre If this threshold exceeds the largest capacity in the table then the subroutines will not work This table should also only use one cable size to supply each level of demand This is because it also defines a summary table of boundaries of demand in Rows 66 73 These boundaries are used in the data sub module to define how much demand how many locations are served by each cable size in the final drop Cell reference Description and details of spreadsheet calculations Row 137 Pillars basic inputs Pillars
66. N kbps DSL kbps LE Regional Total site POC node Kbps transmission EE EA RE N oI SARE SARE mm CSIM PIER 1 KEEL PIER 1 LORI KNST 1 Check Note this calculations determine the average use of the links by platform Platform TOM only NGA only TOM amp NGA Platform use of links use of links PSTN ers PSTN ISDN Bi ISDN DSL ie DSL Transmission MS Transmissio Figure 5 38 Excel screenshot showing sample of the calculation table for MSAN transmission dimensioning Source Analysys The appropriate SDH transmission or Ethernet transmission link speed is subsequently calculated on the basis of the E1 VC or kbit s requirement respectively 9995 207 qu Analysys Fixed LRIC model user guide Version 2 0 94 Transmission requirements LE gt gt POC Note traffic from modern equipment is carried using SDH links whereas traffic from NGN equipment is carried using Ethernet links SDH transmission links Ethernet transmissioi 25 25 25 25 25 100 25 25 1 4 2 63 252 1008 10 000 100 000 1 000 000 Access Tier 1 LE Parent PoC LE remote to El E3 STM O STM 1 STM 4 STM IE 10Mbit s 100Mbit s Gigabit site POC Ethernet AARE AARE CSIM PIER KEEL PIER LORI KNST 2125 4516 36 2 Check SDH E1 equivalents by platform Ethernet kbps by plat E1 E3 STM O STM 1 STM 4 STM 16 10Mbitts 100Mbit s Gigabit 3 663 81 854 1152 Figure 5 39 Excel screenshot showing sample of the calculation table for MSAN transmission dimen
67. NBERRA TNS2 1 1 MELBOURNE TNS1 1 1 MELBOURNE TNS2 1 1 MELBOURNE TNS3 1 1 PERTH TNS1 1 1 1 1 1 1 1 1 1 1 1 1 1 PERTH TNS2 1 1 1 1 1 1 1 1 1 1 1 1 1 SYDNEY TNS2 1 1 SYDNEY TNS4 1 1 SYDNEY TNS5 1 1 Figure 5 80 Excel parameters determining the structure of physical ring 1 Source Analysys Nodes SDH DWDM Ring 2 Fibre distance transitring 2 regenerators regenerators equired Note this is the distance to ADELAIDE TNS2 Figure 5 81 Excel parameters determining the fibre distances in physical ring 2 Source Analysys Site Name ADELAIDE TNS ADELAIDE TNS BRISBANE TNS4 BRISBANE TNS CANBERRA TN CANBERRA TN MELBOURNE 1MELBOURNE 7MELBOURNE 1PERTHTNS1 PERTH TNS2_ SYDNEY TNS2 SYDNEY TNS4 ADELAIDE TN 1 1 1 1 1 bi ADELAIDE TN BRISBANE TN BRISBANE TN CANBERRA TI CANBERRA TI MELBOURNE MELBOURNE MELBOURNE PERTH TNS1 1 1 1 1 1 1 1 PERTH TNS2 1 1 1 1 1 1 1 SYDNEY TNS 1 1 1 i SYDNEY TNS 1 1 1 1 SYDNEY TNS 1 1 1 i 1 1 1 1 1 1 1 i 1 1 Figure 5 82 Excel parameters determining the structure of physical ring 2 Source Analysys The trench requirements summarised in rows 472 492 take into account the trench sharing within the IEN and with the CAN Cell reference Description and details of spreadsheet calculations Rows 559 633 Summary for the TNS level assets The equipment outputs for the TNS Core Nodes are colla
68. P 4 2 900 2901 260 358 6 131 530 280 957 6 131 534 4 1 1 1 1 0 1 5 6 within DP 5 2 908 2 885 260 360 6 131 498 280 960 6 131 498 0 1 1 1 fi 0 5 6 Within DP 6 208 228 279833 8131 373 279844 6 131 374 1 o 0 0 o 1 2 2 Within DP 7 210 213 279 836 6 131 373 279 837 6 131 374 2 1 0 0 0 0 1 2 2 Within DP 8 224 223 279840 6 131 374 279 840 6 131 374 0 1 0 0 0 0 1 2 2 Within DP 3 ar 216 279839 6 131 374 279 840 6 131 374 0 0 0 0 0 0 1 1 1 Within DP 10 2953 2 948 281 015 6 131 605 281 016 6 131 588 TT 0 0 0 0 0 i d 1 Within DP 1 2 894 2895 280957 6 131 538 280 956 6 131 542 4 1 1 1 1 o 1 5 6 Within DP 12 2 767 2 893 280 668 6 132 954 280 871 6 132 923 A 1 0 0 0 0 1 2 2 Within DP B 2 884 2767 280 866 6 132 977 280 868 6 132 954 24 1 0 0 o 0 1 2 2 Within DP 4 2 898 2 935 280 956 6 131 519 280 958 6 131 526 6 1 1 1 i 0 1 5 6 Within DP 15 2 936 2896 280 956 6 131 543 280 956 6 131 546 3 1 1 1 1 0 1 5 6 Within DP 6 595 540 279917 6 431380 279 906 6 131 379 1 1 o 1 o 1 4 4 Within DP TT 287 265 279 869 6 131 406 279 869 6 131 407 1 1 1 0 1 0 1 4 4 Within DP 18 2 931 2 888 260 954 6 131 565 280 954 6 131 567 2 1 1 1 1 0 1 5 6 Within NP 19 DER IR ITAIT RMA ITAIT RINAY 1 n a 1 n 1 2 n Figure 3 7 9995 207 Excel outputs for edges in spanning tree Source Analysys DAnalysys Fixed LRIC model user guide Version 2 0 47 Cell reference Description and details of spreadsheet calculations Cells BX37 CJ Data on DP clusters This
69. Pillar capacity stapia capacity Figure 2 15 Excel parameters for the pillar capacity Source Analysys The pillar capacity feeds into the pillar capacity calculations in the Inputs by geotype section as described below Cell reference Description and details of spreadsheet calculations Rows 141 152 Fibre basic inputs Fibre Minimum demand at a location for it to be served by fibre 40 MAER MOES denand ICE SLE Maximum number of nodes in a fibre ring 20 ITBNTRETRIDODES IR re HOG Main fibre cable sizes employed fibres in cable Must be written in ascending order of size fibres in cable fibres in cable fibres in cable fibres in cable fibres in cable nln Are cable sies Figure 2 16 Excel parameters for the fibre ring demand and capacity and cable sizes deployed in the fibre ring Source Analysys Minimum demand The parameter used to determine the minimum demand at a location before ata location for it fibre is deployed is important particularly for the concentrated demand to be served by within ULLS Band 1 A higher threshold leads to fewer fibre fed locations fibre and a larger volume of copper deployed in an ESA Maximum number A fibre node is a pillar with fibre demand in its cluster or a LPGS with fibre of nodes in a fibre backhaul This parameters defines the upper limit for clustering of fibre ska WM Analysys Fixed LRIC model user guide Version 2 0 21 ring nodes The default assumption is tha
70. Road centre boundary gt gt boundary locations in road centre DP cluster Groupe Bandi esi R Geotype 2 Band1 1 13 100 Geotype 3 Band2 1 i 1 00 Geotype 4 Band2 1 i 1 00 Geotype 5 Band2 1 i 1 00 Geotype 6 Band2 1 1 00 Geotype 7 Band 3 4 olust 1 19 1 00 Geotype 8 Band 3 4 olust 2 19 1 00 Geotype 3 Band 34 clust 2 19 1 00 Geotype 10 Band 3 4 spree 1 19 1 00 Geotype 11 Band 3 4 sprez 2 19 1 00 Geotype 12 Band 3 4 spree 2 19 1 00 Geotype 13 Band 3 4 spree 2 19 1 00 Geotype 14 Band 3 4 sprez 2 19 1 00 Geotype 15 Band 3 4 satell 19 1 00 Geotype 16 No demand Ba 19 1 00 33 93 9 43 19 BVOC OVALFL sve distAR FRE ave dist VIR PRG Proportion of property boundary width built to 4 100 build to cent Figure 4 4 Inputs for NTP gt gt serving pit Source Analysys 4 4 In Access worksheet This worksheet holds the outputs of the CODE workbook of the geoanalysis and access network module 4 4 1 Key parameters The parameters in this worksheet should be updated if the CODE workbook is re run using the following procedure e On the Summary worksheet of the CODE workbook select the highlighted outputs H282 W458 and copy e On the In Access worksheet go to the first parameter cell E7 e Using the Paste Special function paste values and skip blanks AI E S V B OK Note that it is vital that blanks are skipped so as to ensu
71. The appropriate level of demand data is linked from the In Demand worksheet The calculated busy hour demand is converted into a per subscriber demand measure for the modern and NGN deployments and are subsequently used to dimension the network elements at each network level the calculations for which take place on the separate network deployment algorithm worksheets These linkages are shown in the diagram below 9995 207 Analysys 5 5 1 Key parameters Network design algorithms NwDes 1 Access NwDes 3 Reg Nodes v NwDes 4 Core Nodes v NwDes 5 Islands Fixed LRIC model user guide Version 2 0 66 Ee Figure 5 8 Location of the Dem Calc worksheet in the overall Core module structure Source I E Analysys 1 oi 1 i i T I I I I I I I I eeeeeE EES OOPS SS SOOS ESE EPOS rer I Vo I Mosoosoooooooooooooooocococcococsoss I piei I AE EE N EE I I I I I I I fore eal I gt There are two main sets of parameters on the Dem Calc worksheet that can be directly manipulated by the user Parameter Location Impact Weighting of traffic Rows 134 227 for PSTN amp The weighting of the different traffic routes routes through the NGN through the network determines the intensity to network Rows 316 331 for NGN which the traffic interacts with certain network ISDN only elements Non inclusion of LTH LTH links for ISDN C213 and C2
72. The following table outlines the calculations contained in the Inputs Core worksheet 9995 207 qu Analysys Fixed LRIC model user guide Version 2 0 136 Cell reference Row 3 Cells E8 G37 Cells 18 137 Cells L8 L23 Rows 42 241 Cells J42 K45 Rows 246 321 Rows 326 329 Rows 334 337 Rows 345 409 Description and details of spreadsheet calculations Year modelled Service demand total MSAN non MSAN Average call duration minutes for each traffic service Flag for geotypes served by MSAN equipment Assets deployed LPGS are linked into cell F51 from the Inputs Access worksheet Trench requirements for the IEN split by network layer as well as that shared with the CAN and incremental to the CAN Link cost allocations Trench cost allocations Fibre cost allocations Routeing factors for the modern and NGN networks Rows 415 422 Allocation drivers for cost allocation Rows 429 432 Building cost allocation between access and core Rows 438 452 Exchanges by geotype Table 6 4 Calculations performed on the Inputs Core worksheet Source Analysys The remainder of this section provides an overview of the calculations performed on the Inputs Core worksheet Cell reference Description and details of spreadsheet calculations Cells E8 G37 Service demand total MSAN non MSAN The service demand for non MSAN and MSAN traffic is linked in from the Core module Service d
73. Where Xx Vis road coordinates used to measure dis tan ce p coefficient det er min ed in excel k coefficient det er min ed in excel 2 3 Summary worksheet Fixed LRIC model user guide Version 2 0 31 Figure 2 31 Form of distance function Source Analysys This worksheet gives a summary of the volumes calculated for each ESA within our sample summarised by geotype These volumes are then analysed within each geotype to derive average measures to be applied on a geotype basis within the CAN module 2 3 1 Key parameters The only parameters contained on this worksheet are indices related to the ESAs contained within the sample These should not be changed No other parameters are manually inputted into this worksheet but numerous data and outputs are linked in from the DATA workbooks It is crucial that the code workbook links to the correct data workbooks linking to old versions will lead to incorrect outputs being extrapolated for the active part of the model Keeping the links valid is best achieved by always keeping the code and data workbooks in the same directory and by taking copies of the whole directory to create new versions Parameter Location Impact Directory locations number of Rows 9 17 The formulae in these cells determine where the geotypes and ESAs sampled Visual Basic will look for the DATA workbooks The whole geoanalysis and access network module must lie in
74. YDNEY TNS SYDNEY TNS SYDNEY TNS 17 957 174 162 641 16 604 8 978 587 81 321 8 302 8 642 780 117 619 4 321 390 58 809 Total divide by 2 accounting for t Calculations for the subscriber numbers Source Analysys Description and details of spreadsheet calculations Rows 95 109 TNS unit switchblock and processor requirement The modern network design requires TNS equipment to handle the voice traffic The TNS equipment consists of e aswitchblock dimensioned by the busy hour Erlang load on each TNS 9995 207 Analysys TNS switchblock actual capacity Modern TNS unit requirement Fixed LRIC model user guide Version 2 0 117 Figure 5 69 Calculation of the number of TNS switchblock units required Source Analysys Note the total number of TNS units is based on the maximum of switchblocks and processor units required at each TNS site Figure 5 70 Site_ID Site Name ADELAIDE TNS ADELAIDE TNS BRISBANE TNS BRISBANE TN CANBERRA TN CANBERRA TN MELBOURNE 1 MELBOURNE 1 MELBOURNE 1 PERTH TNS1 PERTH TNS2 SYDNEY TNS2 SYDNEY TNS4 SYDNEY TNS5 Switchblock Switchblock capacity of TNS calculation TNS unit requirement based on BHE switchblock capacitv capacity BHE TNS BHE 40 000 40 000 40 000 40 000 40 000 40 000 40 000 40 000 40 000 40 000 40 000 40 000 40 000 40 000 502 431 ig Calculations for TNS unit switchblock requiremen
75. a lysys Rows 12 14 Rows 17 18 Rows 21 52 Rows 55 59 Rows 62 133 Rows 137 Rows 141 152 Rows 155 166 Rows 169 172 Rows 180 193 Rows 198 211 Rows 218 231 Rows 236 249 Rows 258 303 Rows 309 317 Rows 324 355 Rows 361 374 Fixed LRIC model user guide Version 2 0 15 Utilisation basic inputs DP basic inputs Pit and duct basic inputs Duct capacity definitions Copper basic inputs Pillars basic inputs Fibre basic inputs Backhaul basic inputs Satellite basic inputs Copper inputs by geotype Fibre inputs by geotype Copper versus wireless decision data by geotype Other data by geotype Proxy cost function coefficients Cost function coefficients Distance function Trench sharing coefficient Table 2 4 ESAS to process Calculations performed on the Inputs worksheet Source Analysys Cell reference Description and details of spreadsheet calculations Rows 3 7 Specifies which ESAs are processed by the access algorithms See Section 1 1 1 for further details Basic inputs ESAs to process Cell reference Description and details of spreadsheet calculations Rows 12 14 Utilisations Utilisation basic inputs DP utilisation Source Analysys assumption 100 Ta ad Pillar utilisation Source Analysys assumption wtiisation pilar Distribution network utilisation Source Analysys assumption utilisation distr cate Figure 2 9 Excel parameters for asset utilisation Source Analy
76. ake the model non traffic driven and could be used to calculate common costs Rows 94 123 Call data for modelled services Linked in from the Cost module Inputs Demand worksheet Table 5 3 Calculations performed on the In Demand worksheet Source Analysys The demand inputs are listed by year and selected on the basis of the year chosen in the Scenario worksheet of the Cost module Traffic is split into MSAN and non MSAN traffic on a geotype basis determined also in the Scenario worksheet Access line data distributed by ESA in the access module can change slightly due to rounding errors The volumes that flow through the model are adjusted in this worksheet Traffic data is linked from the Cost module so cannot be adjusted directly in this worksheet Under the NGN scenarios dial up traffic is removed in proportion to the number of subscribers in geotypes with MSAN deployment enabled 9995 207 ID Ana lysys 5 4 9995 207 Fixed LRIC model user guide Version 2 0 62 In Subs worksheet This worksheet calculates the subscribers that are controlled by each node at each level in the network i e at the LE LAS and TNS levels The layout of this worksheet is shown below Analysys INPUT Subscribers hy ESA This sheet calculates the subscribers that are controlled by each of the nodes for cach level in the network i e af the LE LAS and TNS levels 1 14 8 3 PSTN End Wholes
77. al Basic It is recommended that these are not changed without extreme care and should also be changed within the Visual Basic ESA Gy z worksheets Each data workbook contains one worksheet for every ESA sampled For example the first geotype used in the figures below has three ESAs Therefore there are three worksheets in this module storing the outputs of the calculations These are labelled ESA G1 1 ESA G1 2 and ESA G1 3 respectively The worksheet summarises the following data and outputs basic information for the ESA including ULLS Band geotype ESA code and number of locations assumptions used the last time that the ESA was calculated and the total time required DAnalysys Fixed LRIC model user guide Version 2 0 40 e co ordinates of locations within the ESA and the assumed demand at each location derived using the geocoded national address file G NAF e edges if any contained within the minimum spanning trees for any copper fibre deployment e locations of any DPs from the urban copper deployment e edges if any contained within the minimum spanning trees for any wireless backhaul deployment e volumes of trench and cable for each pillar cluster or pillar equivalent e edges if any contained within the fibre ring deployment in the ESA 331 Key data and inputs This workbook contains outputs for the ESA and assumptions used in the last calculation of its access network The only input
78. ale line ISDN BRI ISDN PRI 2008 2 User Access rental WLR access access Modelled year Subscriber distribution parameters Services current gear before adjustments ton 425 7 825 000 1 740 000 249 984 26 940 note control service availability by geotype Adjust service availability Adjust SIO location SIOs using Service availability by geotgpe locations satellite Scale factor 0 93 0 75 OA 0 02 0 00 Minimum deplogment Subscribers by ESA note if updating locations DSL ID amp RANH need to be updated 1 1 1 1 rea neve cerry inne ar whe an Minimum deployment gt z Oe N ae oer a eBees Tasses RETEREESEE Figure 5 6 In Subs worksheet output node data Source Analysys This worksheet links distributes access subscriber demand across ESAs for Public Switched Telephony Network PSTN Wholesale Line Rental WLR Integrated Services Digital Network ISDN BR ISDN PR Asynchronous Digital Subscriber Line ADSL retail ADSL wholesale Symmetric Digital Subscriber Line SDSL retail and SDSL wholesale subscribers Subscriber demand by geotype feeds into the Access module for PSTN WLR ISDN BR ISDN PR Unconditioned Local Loop Service ULLS and Line Sharing Service LSS The calculated subscribers numbers feed into the appropriate network design algorithm worksheet i e the calculated LE subscribers are linked into the NwDes 1
79. also have routeing factors defined see row 85 6 15 Dem In Access worksheet This worksheet calculates the Network Element Output through the multiplication of the service routeing factors from the RF Access worksheet by the total service demand from the Inputs Access worksheet It is calculated for each asset by geotype It is then used in the annualisation calculation on the TA Access worksheet These linkages are shown below 9995 207 DAnalysys Fixed LRIC model user guide Version 2 0 165 Figure 6 34 Location of the Dem In Access worksheet in the overall Cost module structure Source Analysys Dem In Access RF Access 6 15 1 Key parameters This worksheet doesn t contain any manually adjustable parameters All service demand data is linked in from the Inputs Access worksheet 6 15 2 Calculation description The following table outlines the calculations that are contained on the Dem In Access worksheet Cell reference Description and details of spreadsheet calculations Rows 8 37 Service demand Rows 42 122 Network element output Table 6 19 Calculations performed on the Dem In Access worksheet Source Analysys 9995 207 qu Analysys Fixed LRIC model user guide Version 2 0 166 6 16 UnitCost Access worksheet This worksheet captures the unit capex and opex inputs for the access network assets The unit cost data
80. alysys For a similar reason whether a particular node dimensions a particular LAS ring is defined by the user It is important to ensure that the individual capacity from each LAS node is only counted once Node capacity to dimension LAS r LAS LAS LAS LAS LAS LAS Ring 1 1 Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 Figure 5 59 Excel layout for parameters determining whether a particular node dimensions a particular LAS ring Source Analysys The cumulative number of nodes is calculated as an internal check 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 110 Cumulative number of nodes Ring 1 Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 Figure 5 60 Excel calculations for the cumulative number of nodes Source Analysys The node capacity that dimensions each of the LAS rings is calculated automatically on an individual node basis by looking up the value from the LAS TNS transmission calculation LAS LAS LAS LAS LAS LAS Node capacity E1 VCs to be carried on ring Ring 1 Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 Figure 5 61 Excel calculations to determine the node capacity that dimensions each of the LAS rings Source Analysys The sum of these node capacities dimension the total required capacity of the ring Furthermore Columns AI AM calculate the total numbers of fibres physically required including an allowance for spares and other fibre services
81. ame Links Backhaul Trench Duct distance Fibre distance Ring ID installed for solution to distance sheath sua 2 Submarine cab 6 Figure 5 87 Trench duct and fibre distance calculations for the submarine cable link from Tasmania Source Analysys The output of the NwDes 5 Islands worksheet is e length of trench duct and fibre to be removed on LE POC links e length of trench duct and fibre to be removed on LAS TNS links e special solution microwave satellite and submarine cable equipment and lengths 5 15 Out Assets worksheet The Out Assets worksheet collates the outputs from each of the network design worksheets This output is then used in the core part of the Cost module 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 129 Figure 5 88 dT i i Location of the y v the overall Core module i Network design l structure Source I I I I I oe ees algorithms i i Analysys l 5 15 1 Key parameters This worksheet contains no input parameters 5 15 2 Calculation description This worksheet collates the network assets deployed at each level in the network and the cost allocations at each level of the network This data is linked to the core part of the Cost module 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 130 6 Cost module The Cost module determines the network costs of building the access and core networks The mod
82. and on the In Subs worksheet of the Core module 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 61 5 3 2 Calculation description The table below details the specific calculations that are performed in the In Demand worksheet Cell reference Description of spreadsheet Details of spreadsheet calculations calculations Row 4 Modelled year Linked from the In Control worksheet in turn linked from the Cost module Scenario worksheet Rows 6 7 Flag of whether any traffic in each of Linked from the In Control worksheet the 16 geotypes requires an MSAN in turn linked from the Cost module Scenario worksheet Rows 10 15 Calculation of subscribers by geotype Calculated using the subscriber data from the In Subs worksheet Rows 19 22 Percentage of traffic carried using These determine the split of demand MSAN equipment for the year modelled between modern non MSAN and NGN MSAN traffic Row 26 Local exchanges enabled for xDSL Linked in from the Cost module and used to distribute xDSL subscribers Rows 29 58 Demand array for modelled services Linked in from the Cost module Inputs Demand worksheet Rows 61 90 Demand sensitivity array adjusts the Linked in from the Cost module volume of demand used to calculate Inputs Demand worksheet network equipment requirements and thus can be used to set up demand scenarios e g setting all of these demand multipliers to zero would m
83. and run the geoanalysis and access network module as described in Sections 4 and 5 of the Fixed LRIC model documentation the following minimum specifications are recommended e MS Excel 2003 edition e MS Access 2000 edition e MapInfo v8 0 e MapBasic v4 5 is required for the geocoding algorithms 1 2 Document roadmap The calculations performed in each of the modules are explained in the following sections on a worksheet by worksheet basis The remainder of this document is set out as follows e Section 2 outlines the key parameters and calculations for each worksheet in the geoanalysis and access network module Part I CODE e Section 3 outlines the key parameters and calculations for each worksheet in the geoanalysis and access network module Part IT DATA e Section 4 outlines the key parameters and calculations for each worksheet in the CAN module e Section 5 outlines the key parameters and calculations for each worksheet in the Core module e Section 6 outlines the key parameters and calculations for each worksheet in the Cost module Ee WM Analysys 2 1 Fixed LRIC model user guide Version 2 0 6 Geoanalysis and access network module Part I CODE The geoanalysis and access network module is used to derive store and post process the modelled asset volumes of an actual deployment in a sample of ESAs in Australia It has two main components a code sub module and a data sub module The data sub modul
84. arameter all active work 4 5 6 Yes Scenaricbusiness overheads Mote Setting this parameter to yes results ir Distance uri signe care Note this parameter affects the core network c Distance up ske a00ess Note this parameter affects the access networ Duet 1 PB gt gt D Follow link to define open trench Select overlap level between core and access Scenarinoverisn sccesscore Mote this parameter directly affects the level ol Figure 6 1 Excel scenario parameters Source Analysys 9995 207 DAnalysys 6 2 WACC worksheet Fixed LRIC model user guide Version 2 0 132 This worksheet provides the calculations for the determination of the weighted average cost of capital WACC The WACC is subsequently used in the tilted annuity calculation for the core and access networks on the TA Core and TA Access worksheets respectively TA Core Asset sharing between core and access TA Access 6 2 1 Key parameters Figure 6 2 Location of the WACC worksheet in the overall Cost module structure Source Analysys This worksheet contains user defined the weighted average cost of capital WACC parameter values The default parameter values are based on the ACCC s Assessment of Telstra s Unconditioned Local Loop Service Band 2 monthly charge undertaking final decision WACC parameters April 2008 with an adjustment to the risk free rate to take account of changing
85. are linked into cell F51 from the Inputs Access worksheet The total number of assets deployed in the core network according to the specific level of demand modelled is linked in from the Core module Level Asset Unit Number Number Number deploged from deploged from deploged in Core model Access model LE LE Site acguistion preparation and maintenance i LE LE Concentrator Processor LE LE Concentrator PSTN line card LE LE Concentrator ISDN 2 line card LE LE Concentrator ISDN 30 line card LE LE DSLAM 2nd Gen ATM backhaul LE LE SDSL line card LE LE ADSL line card LE LE Splitter LE LE LPGS equipment Mux LE LE UPS 40k A4 and Generator 50kVA LE LE Air conditioning unit 10k V A LE LE Network unit of LPGS Figure 6 5 Excel sample of inputs for assets deployed Source Analysys Cell reference Description and details of soreadsheet calculations Cells J42 K45 Trench requirements for the IEN split by network layer as well as that shared with the CAN and incremental to the CAN The trench requirements for the IEN as calculated from the core overlap analysis is linked in from the Core module This includes the split by core network layer and distinguishes the length of trench that is shared with the CAN Distance summary Distance Distance used in used in IEN CAN onli LE POC LAS TNS 113 885 336 56 667 832 Cupu distance deployed ENCAN Figure 6 6 Excel sample of inputs for s
86. ase pillar LPGS set up cost for wireless radio capacity per capacity per unit station in terms for copper unit of demand of high demand of units of per unit j 25 000 250 2 000 80 000 I n 20000 825 1 00 I 1 00 2 25 000 250 2 000 80 000 n 200 000 825 100 100 3 25 000 250 2000 80 000 1 200 000 825 100 100 4 25 000 250 2 000 80 000 n 200 000 825 100 100 5 25 000 250 2 000 80 000 200 000 825 100 100 e 25 000 250 2 000 80 000 1 200 000 825 100 100 7 25 000 250 2000 80 000 1 200 000 825 100 100 8 25 000 250 2000 80 000 1 200 000 825 100 100 5 25 000 250 2 000 80 000 n 200 000 825 100 100 10 25 000 250 2 000 80 000 n 200 000 325 100 100 1 25 000 250 2000 80 000 1 200 000 825 100 100 2 25 000 250 2000 80 000 n 200 000 825 100 100 B 25 000 250 2 000 80 000 1 200 000 825 100 100 4 25 000 250 2 000 80 000 1 200 000 825 100 100 mieless BTA coverageradus wireless B7Scapacit COMPSON COPPE pis comparisenconpertPt comparisan cap comparison vier comparison witelessincver incrementatresidem invemeptaldusiesswieless demand Figure 2 21 Parameters used to determine whether a copper or wireless solution is used for a location Source Analysys Coverage radius This is the distance constraint used when clustering locations to be fed by wireless BTS aa WM Analysys Maximum capacity of base station Costs for copper deployment Costs for wireless deployment Incremental capacity per unit of high demand Maximum number of relay stations i
87. astralPlus and the road network from StreetPro we calculate the average distance of the G NAF gt gt FDP represented as being situated in the middle of the road and the PB gt gt FDP The difference in the two distances is the G NAF gt gt PB as illustrated in Figure 4 3 KEY Figure 4 3 lt gt Estimated from MapInfo Farar distances Estimated from TEA estimated from the Desired quantity MapInfo data sets Source Analysys Average distance from G NAF to FDP Roadway It is believed that the distance from the NTP to the property boundary can be defined as a portion of the G NAF gt gt PB distance We also calculate the average lengths of road crossings and the PB gt gt SP link as described in the Fixed LRIC model documentation The results of this analysis is captured on rows 58 73 This data feeds into the In Access worksheet as shown in Figure 4 4 The assumed proportion of G NAF gt gt PB distance for the NTP PB column H can be adjusted as a scenario 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 53 Note theze parameters are taken from the geo analyzis zee Geo analysis user guide Deplogment Average Average Average NTP gt gt PB as Average road Distance of Average Road algorithm distance distance distance NTP x of GNAF gt gt width PB pits from distance crossing GNAF gt gt Property gt gt PB PB gt gt PB property between distance
88. aul and satellite dimensioning Source Analysys There are inputs for both copper and wireless backhaul deployments For copper deployments the maximum distances for DP pillar and pillar RAU cables without jointing lead to additional full joints of the entire cable being included in the distribution and feeder networks respectively The maximum distance between manholes is only employed on the incremental trench joining the pillar clusters back to the RAU to ensure that there are sufficient access points along this trench The wireless backhaul options are used in determining the capacity of wireless links between base stations and wireless fed LPGS required deployed to serve rural ESAs The satellite inputs are used for a cost based decision for installing satellite compared with wireless within rural ESAs Clusters served by a wireless BTS are checked individually to see if they can be served by satellite more cheaply Decreasing this satellite cost will mean that wireless clusters are more inclined to be served by satellite rather than a BTS Inputs by geotype All parameters driving the clustering algorithms which deploy copper and fibre in an ESA can be varied by geotype However most quantities are currently set to be equal across all geotypes aa WM Analysys Fixed LRIC model user guide Version 2 0 22 Cell reference Description and details of spreadsheet calculations Rows 180 193 Copper inputs by geotype gt Copper no
89. available benchmark TA Access worksheet column H data has been used The total unit asset cost is composed of e a direct unit cost column E e a spares uplift percentage column F e an installation uplift percentage column G and e an indirect cost percentage uplift column H To change the Cost xls UnitCost Access E11 G22 The unit cost for ducted trench should be The relative cost saving is passed asset unit costs for E37 G48 first defined in E11 G22 The cost of open through to the TA Access worksheet ducted trenched E24 G35 trench is then set The cost of ploughed ploughed trench and open trench trench is set separately in E37 G48 9995 207 Analysys Annexes to Fixed LRIC model user guide A 13 Objective Workbook Worksheet Cell reference Description Impact To change the Cost xls UnitCost Access AG130 AV141 The proportion of trench where cable is A second set of inputs for lower unit proportion of cable ploughed rather than deployed in duct costs is provided for ploughed trench that is ploughed Where feasible this is believed to be a This relative price and the proportion cheaper solution of trench is used to adjust the unit By geotype the proportion of trench cost by geotype on the TA Access distance which may be ploughed is an worksheet input Note inputs can also vary by the size of the trench amp duct but assumptions are likely to be consistent for a geotype To change the C
90. aved to be allocated to the IEN is defined This is assumed at 50 therefore both the CAN and IEN share the benefit of using trench deployed for the CAN 6 Line 230 the proportion of cost saved is the product of 3 IEN duct as proportion of total duct deployed 4 proportion of cost attributable to just trenching and 5 proportion of cost saved allocated to the IEN The resultant allocation of costs is applied to the remaining CAN duct and pit assets after the allocation of cost for supporting LPGS deployments It is important to note that the modelled cost saving is dependent on the scenario input Select overlap level between core and access described in section 6 1 1 6 14 RF Access worksheet This worksheet calculates the access network service routeing factors The access network service routeing factors are used in the cost annualisation calculation on the TA Access worksheet and in the calculation of the Network Element Output on the Dem In Access worksheet gies WM Analysys Fixed LRIC model user guide Version 2 0 163 Figure 6 32 Location of the RF Access worksheet in the overall Cost module structure Source Analysys TA Access 6 14 1 Key parameters This worksheet contains the manually inputted access service routeing factors Parameter Location Impact Access service routeing factors Rows 6 86 Allocation of service costs Table 6 17 Key parameters on the
91. aying the distance parameter Source Analysys 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 80 5 8 2 Calculation description The table below lists specific data inputs and calculations that take place on the In TNS Gravity worksheet by row number Cell reference Description and details of spreadsheet calculations Row 6 Distance power for the gravity model formula When set to 0 distances are not taken into account When set to 2 a basic relationship to distance is included Rows 10 24 PSTN SIOs parented by each transit network switch Note each SIO is parented by two transit network switches for resilience purposes in the network Rows 28 41 Road length distance matrix to and from each TNS Rows 46 59 Calculation of the traffic flowing to each TNS on the basis of the gravity model formula Rows 65 78 Destination of the national traffic to each TNS on a percentage basis of traffic from a particular TNS Table 5 11 Calculations performed on the In TNS Gravity worksheet Source Analysys The TNS gravity model is based on the following formula BFR Figure 5 25 d Formula for TNS Where gravity model P Subscribers at TNS1 Source Analysys P Subscribers at TNS2 D Distance between TNSI and TNS2 k Distance power when set equal to 0 the routeing of traffic is not affected by distance The calculations that take place on the specified sets of rows in the In Sub
92. ber of DPs including the distribution of DPs by the size of the main DP cluster Rows 105 109 Rows 114 172 Rows 175 198 Rows 202 273 Rows 278 297 Rows 301 306 Rows 310 311 Rows 315 394 Rows 397 398 Number of isolated FDPs Number of fibre rings which are used to connect pillars in dense urban exchange areas Length of trench segmented by the number of ducts deployed is calculated by geotype Number of pits and manholes calculated by size Pits deployed for DPs as well as additional pits due to parameters related to maximum cable haulage isolated FDPs and road crossings are also calculated Length of copper sheath deployed is calculated by geotype and by cable size in terms of number of pairs We make the distinction between the main network from LE to pillar and the distribution network this is relevant for the next generation access scenario where pillars and main cable are replaced respectively with MSANs and fibre The lead in cable volumes are separately identified for cases where cost is not recovered through an annual rental due to be recovery through connection costs The jointing required for the copper network is also calculated Distance of fibre sheath and number of fibre NTPs Number of wireless BTS and relay stations Number of satellite access nodes Summary table of assets This feeds into the Cost module Calculation to inform the Core module of the number of pillars and fibre fed LPGS by ESA Th
93. between Canberra and Sydney e Physical ring between Sydney and Brisbane e Physical link between Adelaide and Sydney An example of the Excel calculation for the Perth Adelaide ring is shown below Physical link dimensioning Note This is based on a series of physical rings and takes into account network resilience i e each link in a ring must be able to carry the whole traffic of the ring Note Changes may be made to the ring set up i e to the traffic that is carried on the individual rings Nodes SDH DWDM Ring 1 Fibre distance transit ring 1 regenerators regenerators PWTA 1 Note this is based on TNS TNS main road railway leng PPTA 2696 0 9 2706 Note this is the distance to PERTH TNS2 Figure 5 79 Excel parameters determining the fibre distances in physical ring 1 Source Analysys 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 124 For each ring the logical link traffic which dimensions the physical ring is explicitly entered The examples below are for the Perth Adelaide ring Figure 5 80 and for the Adelaide Melbourne ring Figure 5 82 Site Name ADELAIDE TNSADELAIDE TNS BRISBANE TNS4 BRISBANE TNS CANBERRA TN CANBERRA Th MELBOURNE 1MELBOURNE MELBOURNE 1PERTHTNS1 PERTH TNS2 SYDNEY TNS2 SYDNEY TNS4 ADELAIDE TN 1 1 1 1 ADELAIDE N 7 T T T BRISBANE TNS4 1 1 BRISBANE TNS1 1 i CANBERRA TNS1 1 1 CA
94. bit s other data transmission services The core network results are presented as a marked up LRIC cost for each of the modelled services in cells G75 G104 The access network results are presented as a Band 1 Band 2 Band 3 4 clustered Band 3 4 spread and average access cost in cells I75 M104 Access network results can also be examined by geotype 141 X70 as annualised costs before the application of monthly conversion factors The costs that are attributed to the other core platform costs Other platforms other fibre services and other duct services are summarized in cells E109 G111 6 19 Recon worksheet This worksheet provides assumptions of opex as a proportion of capex for particular cost categories and also aggregates cost information from the model 6 19 1 Key parameters This worksheet contains assumptions of opex as a proportion of capex for particular cost categories stated for capex and opex separately 6 19 2 Calculation description The following table outlines the calculations that are contained on the Recon worksheet 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 172 Cell reference Description and details of spreadsheet calculations Rows 6 Assumptions of overheads mark up Rows 10 29 Assumptions of opex as a proportion of capex Rows 36 60 Calculation of capex and opex by category from model Rows 66 86 Summary of access and core costs from model Table
95. by major asset type Network equipment investment costs in 2007 Detailed cost inputs for site acquisition preparation and maintenance Unit capex cost per network element Opex as percentage of capex Unit capex trends per network element Unit opex trends per network element Table 6 12 Calculations performed on the UnitCost Core worksheet Source Analysys The unit capex cost is defined for 2007 based on benchmark data The asset unit capex for the selected year is calculated using the capex price trends defined in rows 636 838 Unit operating costs are defined for 2007 as a percentage of the unit capex cost in rows 432 634 These percentages are informed by analysis of Telstra s RKR submission data The asset unit opex for the selected year is calculated using the opex price trends defined in rows 840 1042 OutputCost Core worksheet This worksheet links in data from the Dem In Core worksheet and TA Core worksheet and derives the cost per unit network element output for each of the core platforms These outputs do not link to other parts of the Cost module There are no parameters on this sheet all calculations on the worksheet are autonomous 6 11 2 Calculation description The following table outlines the calculations that are contained on the OutputCost Core worksheet Cell reference Description and details of spreadsheet calculations Rows 8 209 Cost per unit network element
96. c lifetime of the assets in terms of years this is calculated on the basis of the lifetimes linked from the UnitCost Core worksheet of the asset cost types defined in column C e Column M annualises the capex according to the tilted annuity charge formula WACC MEApriceChange TiltAdjustment lifetime s GRC I i MEApriceChange TiltAdjustment AnnuityCharge 1 WACC e Columns N O calculate the total cost by adding the annualised capex and opex number by asset Cell reference Description and details of spreadsheet calculations Cells P11 P210 Calculation of the proportion of costs allocated to access Cells T11 T210 Calculations of the costs transferred to the access network cost calculations e Columns P T calculate the cost to be transferred from the core network to the access network Cell reference Description and details of spreadsheet calculations Cells Y11 AA210 Calculation of the distribution of core costs between shared business overheads and incremental costs Cells AC11 Calculation of the incremental costs that are allocated from the access network AC210 e Columns Y AA calculate the total shared cost business overheads cost and incremental costs on the basis of the asset cost type identified in column D e Column AC links in the total costs allocated from the access network Cell reference Description and details of spreadsheet calculations Cells AE11 Incr
97. ce costing calculation is performed by geotype The results of which are linked onto the Results worksheet Figure 6 36 Location of the TA Access worksheet in the overall Cost module structure Source Analysys Asset sharing between core and Results 6 17 1 Key parameters This worksheet contains the tilt adjustment parameter previously discussed in section 6 12 1 This parameter allows for the manipulation of the cost tilt in order to approximate an economic depreciation cost annualisation methodology All other calculations on the worksheet are autonomous ii WM Analysys Fixed LRIC model user guide Version 2 0 169 6 17 2 Calculation description The following table outlines the calculations that are contained on the TA Access worksheet Cell reference Description and details of spreadsheet calculations Rows 4 5 Year modelled and WACC parameters Cells E10 Q91 Calculation of the total geotype costs i e total capex total annualised capex Cells V10 AK91 Cells AM10 BB91 Cells BD10 BS91 Cells BU10 CJ91 Cells CL10 DA91 Cells DC10 DR91 Cells DT10 EI91 Cells EK10 EZ91 Cells FB10 FQ91 Cells F 10 GH91 Cells GJ10 GY91 Rows 93 95 Rows 111 140 total opex total cost savings Equipment deployed by geotype including adjustments for NGN scenario and allocation of costs to the core network Capex cost per geotype equipment deployed by geotype
98. ce type and network level Estimate for building space allocations Note This array defines the total building space taken up by platform equipment Exchange building costs building power supply air conditioning are Average equipment dimensions m PSTN SDN ATM Width Length Width Length Width Length LE LAS TNS Figure 6 13 Sample of the average equipment dimensions by service type and network level Source Analysys Equipment area m2 PSTN ISDN ATM Other SDH Common LE LAS TNS Figure 6 14 Calculation of equipment area by service type and network level Source Analysys 9995 207 WM Analysys 6 6 Fixed LRIC model user guide Version 2 0 142 Cell reference Description and details of spreadsheet calculations Rows 21 23 Cost allocation percentage SDH and common costs are allocated to the other platforms using an equi proportionate mark up EPMU method The figure below shows an Excel screenshot of the cost allocation percentage applied by service type and network level Cost allocation LE LAS TNS Figure 6 15 Calculation of cost allocation percentages by service type and network level Source Analysys I Ducts Core worksheet This worksheet allocates duct costs between the modelled services and other duct services The model has been populated with best estimate values The duct cost allocation calculations feed into the cost allocation calculations on the CostAll
99. cess algorithms see section 1 1 2 for further details Utilisation basic inputs Rows 12 14 Determines how much spare capacity is employed within the cabling deployed in the distribution network distribution points DPs and pillars A lower utilisation implies more spare capacity is provisioned in the network so more assets will be deployed 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 13 Location Rows 17 18 Parameter DP definitions Pit and manhole definitions Rows 21 52 Duct capacity definitions Rows 55 59 Copper basic inputs Rows 62 133 Pillars basic inputs Row 137 Fibre basic inputs Rows 141 152 Backhaul basic inputs Rows 155 166 Satellite basic inputs Rows 169 172 Copper inputs by geotype Rows 180 193 9995 207 Impact The DP capacity determines how much demand can be accommodated by a single DP during clustering The maximum distance between pits in the distribution network is used to determine whether and how many additional pits are required along the trench network within a pillar cluster States the labels for the pits that can be deployed in the network The other inputs are driven off of this list and specify the e number of ducts that can be provisioned in the trench network and the corresponding pit required e minimum pits requirements given the number of links at the pit based on engineering rules e minimum pit size at a pillar location These specify th
100. columns H N This minimum spanning tree distance data is input into the Core module on the In Nodes worksheet The macro also outputs the PoCs and associated characteristics PoC latitude PoC longitude ClusterCentre Latitude ClusterCentre Longitude LAS parent LAS Number of LEs in the PoC Number of PoCs in LAS Is a LAS flag identifying whether the PoC is the parent LAS and SIOs into the Input PoCs worksheet B 3 Input PoCs worksheet This worksheet contains the pasted output from the Find PoCs macro It is used in the calculation of the PoC rings which is determined using the macro contained on the Output PoCs worksheet B 4 Output PoCs worksheet This worksheet contains the Run TSP button which runs a macro that calculates the required ring structures for transmission from the PoCs to the parent LAS This macro takes the data from the Input PoCs worksheet and outputs the appropriate ring structure data in rows 6 and below It is this output that is input into the Core module on the In Nodes worksheet The individual ring structures are generated in separate worksheets titled according to the parent LAS code and graphed appropriately sier WM Analysys
101. cost function for identifying a wireless backhaul link for copper fed areas Source Analysys The distance function or p function has been calibrated separately for each geotype using the street network of Australia For any two points it estimates the road distance between them This has been used in calculating the trench cable distances of individual links at certain points in the network However there are occasions when straight line distance is used e g to measure distances between locations within a DP cluster The trench sharing coefficient varies by geotype and is used to scale aggregated totals of trench for the outputs of an ESA in order to capture trench sharing that occurs in the network 9995 207 Analysys Fixed LRIC model user guide Version 2 0 30 The function to estimate the road distance between two points given by 4 44 and x2 uz takes the Form kis ef gaas Value of k Geotgpe Default Euclidean Non Euclidean 1 2 3 4 5 6 7 8 3 10 1 12 13 14 Value of p Geotgpe De ping Aon deraut RA Trench sharing coefficient The distance function is scaled by j when aggregating trenchiduct within an ESA this accounts for overlap of trench duct within the ESA Geotgpe Trench sharing coefficient 1 2 3 4 5 6 D T 8 3 10 1i 12 13 14 Man derat nAi Figure 2 30 Excel distance function coefficients Source Analysys 9995 207 WM Analysys klix np y ar Yr
102. d IEN Table 5 21 5 13 2 Calculation description Key parameters on the NwDes 4 Core Nodes worksheet Source Analysys This worksheet contains network design algorithms at the TNS level This includes calculations for the equipment and transmission for the core network links from the TNS to the TNS and for the TNS to interconnection with other networks The table below lists specific data inputs and calculations by row number 9995 207 Analysys Fixed LRIC model user guide Version 2 0 115 Cell reference Rows 5 10 Rows 16 69 Rows 74 89 Rows 95 109 Rows 112 142 Rows 147 165 Rows 176 190 Rows 198 212 Rows 218 249 Rows 255 429 Rows 434 467 Rows 472 493 Rows 497 515 Rows 520 552 Rows 559 633 Description and details of spreadsheet calculations Check that the traffic totals reconcile Network parameters that are specific to the calculations at the TNS level including traffic and switch dimensioning parameters Subscriber numbers at each TNS Note due to resilience each subscriber is parented by 2 TNS units TNS unit switchblock and processor requirement NGN Core router dimensioning NGN Core switch dimensioning Transmission requirement for TNS Interconnection links Transmission requirement for TNS TNS links Logical link dimensioning for the TNS TNS transmission links Physical ring dimensioning for the TNS TNS transmission links Dimensioning of DWDM and SDH equipme
103. d the NGN AT1 level e Section 5 11 outlines the key parameters and calculations in the NwDes 2 PoC worksheet e Section 5 12 outlines the key parameters and calculations in the NwDes 3 Reg Nodes worksheet this worksheet contains the asset and transmission calculations for both the modern LAS level and the NGN Regional Nodes level e Section 5 13 outlines the key parameters and calculations in the NwDes 4 Core Nodes worksheet this worksheet contains the asset and transmission calculations for both the modern TNS level and the NGN Core Nodes level e Section 5 14 outlines the key parameters and calculations in the NwDes 5 Islands worksheet e Section 5 15 outlines the calculations that take place on the Out Assets worksheet 5 1 C V and S worksheets The Contents C Version V and Style Guidelines S worksheets are standard across all modules The first two of these worksheets contain the reference details of what the file contains and its history of generation The latter worksheet identifies the Excel cell formatting styles implemented by Analysys in the model The model uses a number of input parameters and is designed so that these can easily be changed The type of changes that can be undertaken for input parameters are detailed in the S worksheet Specifically the inputs themselves are separated into three types kid WM Analysys Fixed LRIC model us
104. de Table 3 2 Data and outputs displayed on the ESA Gy z worksheet Source Analysys 3 32 Description of information displayed The following table summarises the information that is displayed on the ESA Gy z worksheets Cell reference Description Cells B6 C28 ESA data and acronyms Cells G5 129 Cells K5 N28 Cells R5 U27 Cells Y25 DZ27 Cells Z7 AB16 See Table 3 2 above Cells AF7 AM22 Cells AS7 AU15 Cells AX7 BB11 Cells AU18 AU20 Cells B37 K Location data and DP cluster uses co ordinates in AMG Cells M37 AY286 Assets volume by pillar Cells BA37 BD286 List of edges in fibre ring Cells BF37 BV Data on spanning trees connecting address locations Cells BX37 CJ Data on DP clusters Table 3 3 Information displayed on the ESA Gy z worksheets Source Analysys Parameters used for previous calculation Cell reference Description and details of spreadsheet calculations Cells B6 C28 ESA data and acronyms The ESA data provided in C6 C13 is fixed within the model It has been written along with the co ordinates when the workbook was created The ESA code ULLS Band and state for each ESA have been identified for each ESA The geotype is a direct result of our geoanalysis as is the AMG zone This zone identifies the variant of the Map Grid of Australia co ordinate system required to plot the co ordinates accurately The number of locations is calculated directly from the data curr
105. de capacities Copper Geotgpe Mazimum practical Mazimum practical pillar Absolute Absolute mazimum DP capacity capacity mazimum DP pillar capacity capacity 1 4 2 4 3 OES 4 EE 400 5 EK 400 6 4 7 4 8 4 3 4 10 4 1 0 00 12 EE 13 4 400 14 4 x man aksate IF cap mar absoiite pillar capacity Figure 2 18 Excel parameters to dimension copper node capacities by geotype Source Analysys Absolute maximum Linked in directly from DP definitions DP capacity Maximum practical Defined as the absolute maximum DP capacity multiplied by its utilisation DP capacity It is used in the DP clustering algorithm which only occurs in the URBAN deployment Absolute maximum Defined as the minimum of the cable capacity from pillar to RAU and the pillar capacity pillar capacity in pairs excluding that reserved for the cable from pillar to RAU Maximum practical Defined as the absolute pillar capacity multiplied by its corresponding pillar capacity utilisation parameter This is the effective capacity limit on pillar clusters though the absolute limit is used for certain optimisation algorithms which may merge small pillar clusters into other clusters gt Copper cable capacities and distance constraints aa WM Analysys Fixed LRIC model user guide Version 2 0 23 C Jurean goe Juna Mazimum permitted Mazimum permitted distance from DP centre m 100 100 100 100 100 100 Figure 2 19 Required
106. ds x Cell D8 Trench cost per metre Cell D9 Fibre cost per metre Cell D12 Maximum number of PoCs per ring Cell D13 Number of bridging nodes required the number of points at which a child ring is joined to the parent ring 2 bridging nodes are deployed for resilience purposes Cell D14 Number of PoCs before using Genetic Algorithm if set too high the basic Branch and Bound solution method will take a very long time to calculate the answer Cell D15 Number of generations to use in Genetic Algorithm the more generations the more likely the result produced will be optimal Figure B 1 Key parameters on the Inout Parameters worksheet Source Analysys Input Table worksheet This worksheet contains the local exchange LE data namely LE ID Parent LAS distance to parent LAS straight line distance SIOs at LE latitude and longitude 9995 207 CONFIDENTIAL ID Ana lysys Annexes to Fixed LRIC model user guide B 2 The LEs are split into two tables most sit in the first table starting on row 6 whilst the remainder are in the second table starting on row 5213 These exchanges are on islands and are handled separately in the Core module The Find PoCs button runs a macro which clusters the LEs in the first table into clusters served by a PoC location and then calculates the minimum spanning tree links required to route each of these LEs back to their parent PoC The outputs of this macro are pasted into
107. e which comprises several workbooks is explained in Section 3 The code sub module is a single workbook called Access CODE xls which contains the following elements e Main inputs and calculations used to generate asset volumes to construct an access network within a sample of ESAs in Australia e Subroutines of Visual Basic code used for the access network deployment algorithms a description of these appears in Description of the Visual Basic used in the fixed LRIC model e A summary of the derived access network for each sampled ESA The complexity of this sub module is contained within the Visual Basic subroutines rather than the Excel worksheets which contain very few calculations Access CODE xls must be placed within the same directory as the workbooks within the data sub module in order for the access network volumes to be re calculated The worksheets contained in Access CODE xls are explained in the rest of this section The remainder of this section is set out as follows e Section 2 1 outlines the key labels in the Names worksheet e Section 2 2 outlines the key parameters and calculations in the Inputs worksheet e Section 2 3 outlines the key labels and links in the Summary worksheet Names worksheet Note it is highly unlikely that any cell will need to be modified in this worksheet It is in fact recommended that no changes are made to this worksheet The Names
108. e be too distant from the LE to receive a telephony service using only copper Under the URBAN deployment algorithm a parameter can be set that will link pillars and LPGS together on a fibre ring structure The fibre serves LPGS and locations requiring fibre within each pillar cluster LE The local network exchange building which contains the MDF at which the individual lines are terminated Table 4 1 Elements in the CAN Source Analysys The remainder of this section is set out as follows e Section 4 1 outlines the C V and S worksheets e Section 4 2 outlines the labels defined in the List worksheet e Section 4 3 outlines the key parameters and calculations in the In Demand worksheet e Section 4 4 outlines the key parameters and calculations in the In Access worksheet e Section 4 5 outlines the key calculations in the Access worksheet 4 1 Contents version history and style guidelines The Contents C Version History V and Style Guidelines S worksheets are standard across all modules The first two of these worksheets simply contain the reference details of the 9995 207 DAnalysys 4 2 Fixed LRIC model user guide Version 2 0 50 worksheets that the workbook contains and its history of generation The third worksheet identifies the Excel cell formatting styles implemented by Analysys in the LRIC model in order to provide clarity as to the co
109. e manipulated on this worksheet are those associated with the allocation of costs to Other platforms in Column X this affects the cost allocation to different platforms 6 8 2 Calculation description The following table outlines the calculations that are contained on the CostAlloc Core worksheet 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 147 Cell reference Description and details of spreadsheet calculations Columns B C Asset and asset group Column D Fibre type index Column E Core cost type incremental shared business overheads Columns F I Calculation of cost allocation of duct trench assets between fibre and other duct services Columns K N Calculation of cost allocation of fibre assets between SDH and other fibre Columns P S Calculation of cost allocation of SDH assets between platforms and transmission Columns U AB Calculation of cost allocation between platforms PSTN ISDN xDSL other service platforms Columns AD AJ Calculation of cost allocation across all platforms transmission and other Table 6 10 Calculations performed on the CostAlloc Core worksheet Source Analysys The remainder of this sub sections outlines the specific calculations that take place on this worksheet The overall flow for the cost allocation calculation is shown below Figure 6 19 Cost allocation calculation flow Source Analysys 9995 207 jw An a lysys Fixed LRIC model user gu
110. e maximum number of cables a single length of each type of duct can accommodate Reducing these can increase the amount of duct deployed There are a fixed number of different copper cable sizes that can be used within the network which are listed here In addition two of these cable sizes can be specified for a non tapered network as the main and minor cable sizes the latter will be used at the extremities The final table describes which cables to use between the location and the DP in the URBAN deployment This is the pillar capacity and changes will clearly affect the number of pillars deployed in an ESA The demand threshold determines which locations are served by fibre Reducing this threshold means more locations are served by fibre The second input limits the number of pillars on any one ring in a fibre ring deployment The main fibre cable sizes are those most commonly used in fibre deployments These are used here to connect the pillars within the fibre ring The wireline inputs are limits for pulling cable through duct without jointing and for determining how many additional manholes are required in the network for access purposes The wireless inputs are e the maximum distance a wireless link can be used without a relay station en route e a set of coefficients which capture the cost of different backhaul links relative to the smallest link of 2 x 2Mbit s which are used for wireless backhaul links deployed in
111. eans that the links in the Cost module are automatically maintained All active modules should be kept in the same directory 1 1 2 Offline modules geoanalysis and access network module The geoanalysis and access network module is the key input to the CAN module The structure of the workbooks and database supporting this module are presented in Figure 1 2 Access CODE xIs pasted l values l VBA subroutines l Access DATA workbooks l pasted values l Location and Demand l EES SE Geotyping ESAs xls i GNAF mdb Offline l Active Figure 1 2 Structure of offline and active modules of the access network Source Analysys The geoanalysis and access network module calculates access network asset volumes for a sample set of exchange service areas ESAs and then determines parameters to drive the access network element volumes by geotype Along with the Location and Demand database and associated analysis two sets of workbooks are important e Access CODE xls e Access DATA Gy xls with y including the index of the geotype Access CODE xls contains Visual Basic subroutines which are the basis of the access network deployment algorithms The active component is the CAN module involving Excel based calculations dimensioning the access network nationally and the subsequent allocation of costs to services These dimensioning calculations are dependent on the parameters determined in the offline component
112. economic conditions These parameters however do not necessarily reflect the ACCC s current views on these parameter values 6 2 2 Calculation description The WACC is calculated according to the following formula 9995 207 DAnalysys Fixed LRIC model user guide Version 2 0 133 WACC R M T 1 G 5 x R where Return on equity R R b R where Ri risk free rate b Equity beta R Risk premium p Return on debt Rd R pt D pt I where Re risk free rate D Debt premium I Issuance cost T Corporate tax rate G Gamma D E and V D and E are the market values of the business debt and equity respectively and V is the sum of D and E Therefore D V and E V represent the relative weightings of debt and equity employed in the business operations 6 3 Inputs Demand worksheet This worksheet presents the demand forecast for the period 2007 2012 that dimensions the Core and CAN modules 6 3 1 Key parameters The inputs at the top of the worksheet are used to set the size of the CAN for each year in the CAN module It allows the size of the CAN to be separately defined as a fixed size with the cost recovered over the demand input To accommodate possible access line inputs growing the demand used is the maximum of the inputted CAN SIOs and the sum of the access lines calculated below in the service demand calculations The worksheet also contains the projection of number of exc
113. educes the number of fibre metres deployed in the core network This parameter is linked from the Cost module and uplifts core transmission distances to account for them possibly being longer due to slope This parameter is linked from the Cost module It selects the level of IEN CAN overlap to calculate trench sharing Table 5 2 9995 207 Description of main scenario parameters Source Analysys Analysys Fixed LRIC model user guide Version 2 0 60 5 3 In Demand worksheet The In Demand worksheet presents the appropriate year s service demand for the traditional non multi service access node MSAN and NGN MSAN parts of the network for use in the Core module algorithms The In Demand worksheet links in the forecast service demand data from the Cost module from the Inputs Demand worksheet The outputs of this worksheet feed into the Dem Calc worksheet which are used to calculate the service demand per subscriber These per subscriber demands are then used at each level in the network deployment algorithm These linkages are shown in the diagram below Figure 5 5 Location of the In Demand worksheet in the overall Core module structure Source Analysys I I Dem Calc P i i I 5 3 1 Key parameters There are no key parameters that can be manipulated directly on this worksheet Manipulation of the subscriber numbers should be done in the Cost modules
114. emand Figure 6 4 9995 207 PSTN End User Access PSTN local traffic onnet traffic PSTN national long distance traffic onnet calls PSTN outgoing traffic to international destinations PSTN outgoing to mobile traffic mobile terminating PSTN terminating traffic from international mobile other domestic fixed networks Minutes Local carriage service LCS ISDN BRI access ISDN PRI access Service 10 ISDN voice traffic Unconditioned local loop service ULLS Line sharing service LSS Wholesale line rental WLR Service 15 Dial up Internet Traffic ADSL retail lines ADSL wholesale lines SDSL retail lines SDSL wholesale lines Other services on ATM Lines in CAN Lines in IEN Mbit s in LE LTH Mbit s in LTH MTH Mbit s in MTH MTH Service 27 Service 28 Service 29 Service 30 note access line volumes overwritten in CORE module where Services Units Demand MSAN traffic Non MSAN traffic Lines Minutes Minutes Minutes Minutes Minutes Lines Lines none Minutes Lines Lines Lines none Minutes Lines Lines Lines Lines Mbit s Lines Lines Mbit s Mbit s Mbit s none none none none Excel sample of inputs for service demand Source Analysys DAnalysys Fixed LRIC model user guide Version 2 0 137 Similarly the average call duration is linked in from the Core module Cell reference Description and details of soreadsheet calculations Rows 42 241 Assets deployed LPGS
115. emental cost allocation to platforms based on the core cost allocation AK210 percentages output from the CostAlloc Core worksheet Cells AM11 Core platform incremental cost allocation to services PSTN columns AM BP FE210 ISDN columns BR CU xDSL columns CW DZ and transmission columns EB FE Cells AE213 Calculation of the incremental cost by service for each platform FE213 e Columns AE AK calculate the total incremental costs by platform on the basis of the percentages output from the CostAlloc Core worksheet These costs are distributed between the modelled services by platform on the basis of the percentage distributions calculated on the Dem In Core worksheet The total incremental costs by service for each platform is subsequently total in row 213 9995 207 ID Ana lysys 6 13 Fixed LRIC model user guide Version 2 0 158 Cell reference Description and details of spreadsheet calculations Rows 217 228 Calculation of the shared cost EPMU and business overheads EPMU The shared costs mark up is performed in two separate stages One mark up is performed for shared costs that are to be marked up for core network elements only identified with a Core network equipment flag in column E and a second mark up is performed for shared costs that are to be marked up equally for all network elements identified with an All network elements flag in column E The mark ups are distributed acr
116. ently included for the ESA 9995 207 ID Ana lysys ESA data ESA ESA Code Geotype Band AMG co ordinate zon RAU location State Deployment method Fixed LRIC model user guide Version 2 0 44 Code ESA Gl Genre LS Gt Bamna ESA Git PSA AAR Zane ERA GH Ano ESA GL Sete ESA GE Gawe Lak used ESA Git 9995 207 Number of locations R A Buber GEMORS ESA GE Acronyms AMG Map Grid of Australia 1994 co ordinate system BTS Base Tranceiver Station DP Distribution pit ESA Exchange Service Area FO Final drop FOP Final drop point where the cable leaves the street ne GNAF Geocoded National Address File LE Local exchange LPGS Large pair gain system RAU Remote access unit Figure 3 4 Excel sample of ESA data and acronyms Source Analysys Input data from the location and demand database Cell reference Cells B37 K Description and details of spreadsheet calculations Location data and DP cluster uses co ordinates in AMG The Location and Demand Database which has been constructed using the G NAF contains a list of co ordinates of addresses for the whole of Australia and associates a demand to each address entry The addresses and demand for the sampled ESAs have been aggregated into locations and pasted into the relevant worksheets in the data sub module There are two pairs of co ordinates required for each location used The first is derived directly from G NAF The second is derived from
117. ents for the relevant proxy cost and distance functions used in the last calculation Some of their column headings vary with the deployment used URBAN RURAL so as to make their description more explicit Approximate breakdown of the copper cable length by cable size The left hand column is the intra DP linkages in URBAN deployments The right hand column is for DP pillar distribution network cabling in URBAN deployments or for that within pillar clusters for RURAL deployments This table separately aggregates both the demand and number of locations whose final drop is served by each cable size up to 100 pair Number of fibre rings wireless relay stations and additional manholes for the last calculation Co ordinates of every location in the ESA including the copper centre as well as their associated demand and node classification data from the last calculation Printed values of asset volumes including trench and sheath on a pillar cluster basis List of edges in terms of the endpoints that link pillars into a fibre ring s Co ordinates of the endpoints of every edge in the trench network printed from deployment algorithms Also indicates duct requirements for each link Location and capacity data on the DP clusters for an URBAN deployment printed from deployment 9995 207 DAnalysys Fixed LRIC model user guide Version 2 0 43 algorithms Also shows the derivation for the pit deployed at the no
118. er guide Version 2 0 58 e inputs based on data identified in the model using a dark green box outline e inputs based on estimates a yellow cell within a dark green box e inputs which are parameters in the model a dark blue box outline Input Parameter Input Data Input Estimate eo Input Calculation teat onan Input Link 100 Input Link different Workbook ii Figure 5 3 Cell formatting used in the LRIC model Source Analysys The inputs into the various modules are contained within the worksheets preceded with the naming convention Jn 5 2 In Control worksheet The In Control worksheet provides the primary interface for a user of the Core module wishing to run different pre defined scenarios It contains several input parameters which can easily be adjusted by a user of the model set contains major scenario parameters which are linked directly from the Cost xls module CADocuments and SettingstditMy Documentstxact0 2009 post consultation wIPsCost sls Geotype served byMSANs 2 3 6 7 Year modelled eter Ee Scenario year modeled Geotgpe 1 MSANs deployed in geo type O no l yes Full TOM core deployed 1 Force deployment of IP core FALSE SORGBICSA CE vel denke Deploy TOM core er N 1 Legann ccveseguired Implement DWDM on transit links TRUE Sena LN Hans Implement DWDM on LAS links TRUE Soen as STM 64 links before DWDM equipment req 2 Distance uplift for slope effect HEES A
119. erence Description and details of soreadsheet calculations Rows 46 59 Calculation of the traffic flowing to each TNS on the basis of the gravity model formula The gravity model calculates the absolute weighting for traffic by destination pibadi WM Analysys Fixed LRIC model user guide Version 2 0 82 Gravity model absolute calcu From AFTA AWTA BWTB BCTB CCTA CDTA MLTB To AFTA AWTA BWTB BCTB CCTA CDTA MLTB MWTB METC PPTA PWTA SKTB SCTC SPTF Figure 5 28 Excel screenshot showing sample of the gravity model calculation of distances Source Analysys Cell reference Description and details of soreadsheet calculations Rows 65 78 Destination of the national traffic to each TNS on a percentage basis of traffic from a particular TNS These absolute numbers are converted into a normalised percentage number resulting in a matrix of the percentage of national traffic that flows from each TNS to every other TNS RESULT Destination of transit traffic From AFTA AWTA BWTB BCTB CCTA CDTA MLTB To AFTA AWTA BWTB BCTB CCTA CDTA MLTB MWTB METC PPTA PWTA SKTB SCTC SPTF Figure 5 29 Excel screenshot showing sample of the output of destination of transit traffic Source Analysys The output of the gravity model is the percentage of the traffic at each particular TNS that flows to each of the other TNS units This is used in the dimensioning of the TNS TNS links cells E218 R231 on the NwDes
120. ervice demand Source Analysys The number of LPGS required are calculated in the CAN module as they are inherently part of the access network calculations however they are identified as part of the core network The number of LPGS is therefore linked to the total number of core network assets deployed 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 138 Cell reference Description and details of spreadsheet calculations Rows 246 321 Link cost allocations The calculation of the link allocations is an important input to the allocation of costs between the various platforms that use the core network This allocation is calculated for each link type in the core network and is performed for each link speed These allocations are linked to the CostAlloc Core worksheet The figure below shows an example screenshot for the Interswitch link allocation calculation Link cost allocations cost of interswitch links attributed to Units E1 E2 LE PSTN ISDN ATM Transmission SDH platforms s Transmission PSTN ISDN ATM Figure 6 7 Excel sample of inputs for link allocations Source Analysys Cell reference Description and details of spreadsheet calculations Rows 326 329 Trench cost allocations As per the link allocation costs the trench allocation costs are linked from the Core module for the LE PoC ring LAS ring and TNS ring levels Trench allocation costs Unit
121. essful and unsuccessful calls e Columns M N calculate the busy hour volume in terms of Erlangs kbit s and call attempts e Column Q calculates the average call duration blended across both MSAN and non MSAN 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 69 The calculated Excel output of the service demand for the non MSAN equipment is shown below in Figure 5 10 and Figure 5 11 Demand calculation MSAN traffic Services Units ESTN End User Access 1 Lines PSTN local traffic onnet traffic Minutes PSTN national long distance traffic onnet calls Minutes PSTN outgoing traffic to international destinations Minutes PSTN outgoing to mobile traffic mobile terminating Minutes PSTN terminating traffic from international mobile other Minutes Local carriage service LCS Minutes ISDN BRI access Lines ISDN PRI access Lines Service 10 none ISDN voice traffic Minutes Unconditioned local loop service ULLS Lines Line sharing service LSS Lines Wholesale line rental WLR Lines Service 15 none Dial up Internet Traffic Minutes ADSL retail lines Lines ADSL wholesale lines Lines SDSL retail lines Lines SDSL wholesale lines Lines Other services on ATM Mbit s Lines in CAN Lines Service 23 none Mbit s in LE LTH Mbit s Mbit s in LTH MITH Mbit s Mbit s in MTH MTH Mbit s Service 27 none Service 28 none Service 29 none Service 30 none Figure 5 10 Average Average Average call attempts set up
122. etermination of the number of Synchronous Digital Hierarchy SDH regenerators required Fibre distance km between LAS LAS LAS LAS LAS LAS active nodes on the ring Ring 1 Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 Figure 5 64 Excel calculations to determine the total distance between active nodes on the LAS ring Source Analysys The trench distance required as shown below is based on the distances calculated in the LAS LAS distance matrix but is only required when the flag for incremental trench is set to 1 as shown in Figure 5 58 Trench Distance km Ring 1 Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 Figure 5 65 Excel calculations to determine the trench distance required Source Analysys The number of fibre regenerators required is calculated according to the fibre distances calculated between active nodes on the LAS rings A fibre regenerator is deployed every x km where x is a user defined parameter in the model 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 112 SDH regenerators required LAS LAS LAS LAS LAS LAS Ring 1 E Ring 2 Ring 3 Ring 4 Ring 5 Ring 6 Figure 5 66 Excel calculations to determine the number of fibre regenerators required Source Analysys The equipment requirements for each node and ring structure are summarised in the table at the bottom of the NwDes 3 RegNodes worksheet The trench requirements take into account the trench sharing within the
123. eters and calculations in the UnitCost Core worksheet e Section 6 11 outlines the key parameters and calculations in the OutputCost Core worksheet e Section 6 12 outlines the key parameters and calculations in the TA Core worksheet The access network costing worksheet calculations are outlined in sections 6 13 to 6 17 e Section 6 13 outlines the key parameters and calculations in the Inputs Access worksheet e Section 6 14 outlines the key parameters and calculations in the RF Access worksheet e Section 6 15 outlines the key parameters and calculations in the Dem In Access worksheet e Section 6 16 outlines the key parameters and calculations in the UnitCost Access worksheet e Section 6 17 outlines the key parameters and calculations in the TA Access worksheet The resultant calculation of the service costs takes place in Section 6 18 e Section 6 18 outlines the key parameters and calculations in the Results and Results Pasted worksheet e Section 6 19 outlines the key parameters and calculations in the Recon worksheet et WM Analysys 6 1 Scenario worksheet Fixed LRIC model user guide Version 2 0 131 This worksheet controls the general and costing scenario parameters that set up the model 6 1 1 Key parameters This worksheet contains several scenario parameters These are outlined in the table below Parameter Location Impact Modelled year Cell C5
124. f CAN costs to the IEN for trench sharing and is described in section 6 13 The proportion of duct which is deployed in open trench is defined in cells AG144 AV155 The cost savings for open trench are assumed to only apply to trenched duct and not to ploughed routes The proportion deployed via ploughing is defined in cells AG130 AV141 The total capex is adjusted on the TA Access worksheet to reflect the amount of trench deployed via both ploughed cable and open trench Cable costs inputs are specified by gauge in rows 54 82 and are composed of the cost of the cable hauling delivery and handling Two distributions in rows 87 102 are then used to calculate separate blended costs for each cable size for the main and distribution networks Each cost is blended across the mix of gauges deployed These distributions are calculated using outputs from the geoanalysis and access network module Jointing costs are specified in rows 106 112 and are composed of a jointing rate per pair anda joint enclosure cost Opex is defined as a percentage of capex for 2007 in cells D288 D368 The unit cost trends over time can also be defined by the user The capex price trends are defined by asset in cells D373 1453 and the opex price trends are similarly defined in cells D458 I538 6 16 2 Calculation description The following table outlines the calculations that are contained on the UnitCost Access worksheet Cell reference Descr
125. ffic flowing to each TNS Note the logical link dimensioning is calculated using the Type Site_ID Site Name ADELAIDE TNSADELAIDE TNS BRISBANE TNS4 ADELAIDE TNS 0 6 7 ADELAIDE TNS 5 0 5 BRISBANE TNS 9 9 0 BRISBANE TNS 10 10 10 CANBERRA TN 2 2 2 CANBERRA TN 3 3 4 MELBOURNE 1 14 13 14 MELBOURNE 1 8 7 8 MELBOURNE 1 8 8 9 PERTH TNS1 6 6 6 PERTH TNS2 6 5 6 SYDNEY TNS2 7 7 7 SYDNEY TNS4 9 9 9 SYDNEY TNS5 13 13 13 Figure 5 77 Calculations for the percentage of traffic flowing to each TNS Source Analysys skate WM Analysys Fixed LRIC model user guide Version 2 0 123 This is multiplied by the transit traffic at each TNS Core node to generate the traffic which needs to be carried on the logical transit links E1s VC required eet TYPe EG Site ID Site Name ADELAIDE TNS ADELAIDE TNS E PERTH TNS1 PERTH TNS2 TNS name Figure 5 78 Calculations for the number of E1 VCs required Source Analysys Cell reference Description and details of soreadsheet calculations Rows 255 429 Physical ring dimensioning for the TNS TNS transmission links The transit links are dimensioned in terms of fully meshed logical links but are transported on discrete physical rings These physical rings are stated explicitly in the model e Physical ring between Perth and Adelaide e Physical ring between Adelaide and Melbourne e Physical ring between Melbourne and Canberra e Physical ring
126. fic will be subsequently selection box in the identified cell used in the model To change the Cost xls Scenario C8 R8 The MSANs deployed in geotype Deploying MSAN equipment in any extent to which parameter deploys NGN equipment in geotype results in the NGN core NGN equipment is those geotypes that are set to 1 The user network algorithms being deployed in the may set as many of these geotypes to 1 implemented deploying a full IP access network as desired It is logical that they are set in MPLS core Furthermore some costs order e g all geotypes from 1 6 are set from the access network are to 1 it would be illogical to have geotypes transferred to the core network as the 1 2 4 6 set to 1 but 3 set to 0 core network boundary is pushed out further into the access network as MSANSs replace pillars for the geotypes selected The transfer of costs from the access to the core 9995 207 CONFIDENTIAL ul An a lysys Annexes to Fixed LRIC model user guide A 2 Objective Workbook Worksheet Cell reference Description Impact networks is calculated on the TA Access worksheet cells M94 N96 Service demand forecast Objective Workbook Worksheet Cell reference Description Impact To change the Cost xls Inputs Demand D85 1114 The demand sensitivity array allows the Adjusting the demand levels affects traffic modelled user to simply adjust the demand the loading on the core network and Option 1 forecast allow
127. for TNS Interconnection links Transmission requirement Core unit Interconnect traffic Note TDM traffic is transmitted in terms of E1 carriers NC TDM based traffic calculations PSTN ISDN PSTN MELBOURNE MELBOURNE MELBOURNE PERTH TNS1 PERTH TNS2 SYDNEY TNS SYDNEY TNS4 SYDNEY TNS 244 419 13 419 8 298 i Figure 5 75 Calculations for the transmission requirement for TNS Interconnection links Source Analysys 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 122 Cell reference Description and details of spreadsheet calculations Rows 198 212 Transmission requirement for TNS TNS links Core node Core node traffic Note TDM traffic is transmitted in terms of E1 carriers NGN traffic is transmit TDM based traffic calculations PSTN ISDN xDSL PSTN Type Site_ID Site_Name BHE BHE kbit s Eis ADELAIDE TN 4 682 2 gig ig ges aar nnn tg ADELAIDE T BRISBANE T CANBERRA CANBERRA MELBOURNE PERTH TNS1 TNS PWTA PERTH TNS2 SYDNEY TNS Figure 5 76 Calculations for the transmission requirement for TNS TNS links Source Analysys Cell reference Description and details of spreadsheet calculations Rows 218 249 Logical link dimensioning for the TNS TNS transmission links The transit links are assumed to be logically fully meshed The output of the gravity model is used to define the destination of the traffic from each TNS Core Node Logical link dimensioning tra
128. g Description of the Visual Basic used in the fixed LRIC model There are 200 ESAs in the sample A number of these ESAs contain more than one copper centre so we have split these ESAs into sub areas each containing one copper centre As a result there are 219 areas to run in all The calculation time varies depending on the number of locations and whether the urban or rural deployment is used Indicative times are given below Approximate running time minutes Table 1 1 Number of locations Urban deployment Rural deployment Approximate run 100 0 1 5 times for ESAs using 1000 0 5 150 Excel 2003 Source 5 000 5 225 Analysys Several of the sampled ESAs using the urban deployment algorithm contain over 10 000 locations whilst a number of those using the rural deployment algorithm contain several thousand locations Our experience is that a desktop computer can run all 219 ESAs in 3 4 days The load can be split by using a central directory with several computers accessing the directory Copies of Access CODE xIs can be taken and left in this directory Provided each computer is aa WM Analysys Fixed LRIC model user guide Version 2 0 5 working on a separate data workbook each copy of the code workbook can be run on a separate computer It is recommended that one set of results and the associated code workbook are saved in a separate folder to allow checking of input parameters at a later date To set up
129. gt gt LTH gt gt LE gt gt CPE CPE gt gt LE gt gt LTH gt gt LTH gt gt LE gt gt CPE CPE gt gt LE gt gt LTH gt gt MTH gt gt LTH gt gt LE gt gt CPE CPE gt gt LE gt gt LTH gt gt MTH gt gt MTH gt gt LTH gt gt LE gt gt CPE CPE gt gt LE gt gt LTH gt gt MTH gt gt TNS gt gt Int Distribution of ISDN voice traffic between traffic types D a E A teel ord Note Select net PSTN on net PSTN off net PSTN off Total _ Normalised CPE gt gt LE gt gt LAS gt gt LAS gt gt LE gt gt CPE CPE gt gt LE gt gt LAS gt gt TNS gt gt TNS gt gt LAS gt gt LE gt gt CPE di CPE LELAS od CPE gt gt LE gt gt LAS gt gt TNS gt gt Int CPE gt gt LE gt gt LAS gt gt TNS gt gt TNS gt gt Int Figure 5 18 Excel screenshot displaying sample of calculations to determine the proportion of ISDN traffic utilising a specific network route Source Analysys pibadi WM Analysys Fixed LRIC model user guide Version 2 0 73 The calculated routeing factors for each of the traffic types are multiplied by the calculated busy hour traffic to generate the traffic loading with which to dimension the core network This traffic is divided by subscribers to calculate the per subscriber demand loading on the network for each part of the network 5 6 In Nodes worksheet The In Nodes worksheet contains node data for each level in the network for use in the core network design algorithms The to
130. guide Version 2 0 71 e number of call attempts per successful call e g due to unanswered calls BHExC Figure 5 14 Calculation of the BHCA ave number of busy hour Where call attempts C Call attempts per successful call Source Analysys Dye Average duration of a successful call i di Ringing time Voice services explicitly include the additional Erlang load presented by the ringing time associated with calling Ringing time occurs for calls to a land line where there is network occupancy until the call is answered diverted or not answered A ringing time of 10 seconds for answered calls and 28 seconds for unanswered calls to an end user is applied to the various call types and is based on submitted industry average data For each service the model calculates the occupancy minutes in the network Occupancy minutes C x Dye FR CA C X Rinse RIGUIENS ie Calculation of the Where total occupancy C Successful calls minutes Source Dye Average duration of a successful call Analysys R c Average ringing and call set up time for successful calls CA Total call attempts successful calls unsuccessful calls R nsu Average ringing and call set up time for unsuccessful calls Routeing factors Cell reference Description and details of spreadsheet calculations Rows 134 230 Input and calculation of the modern and NGN service routeing factors according to the weighted network call paths t
131. gure 6 10 Excel sample of inputs for routeing factors Source Analysys These routeing factors are used in the routeing factor calculations contained on the RF Core worksheet Cell reference Description and details of spreadsheet calculations Rows 415 432 Allocation drivers for cost allocation A series of allocation drivers are linked from the Core module Allocation drivers for cost allocation PSTN ISDN ATM Other Cost allocation of MuX to platforms Total line cards Distribution of line cards between platforms Ports per ISDN Ports per ISDN Ratio of Ports BR line card PR line card per ISDN BR line card to ports per ISDN ine card ISDN distribution of line cards ot Figure 6 11 Excel sample of allocation driver inputs for cost allocation Source Analysys er WM Analysys Fixed LRIC model user guide Version 2 0 140 These allocation drivers are used in the RF Core worksheet and the CostAlloc Core worksheets to distribute costs between the platforms 6 5 I Building Core worksheet This worksheet allocates building costs between the platforms The current model has been populated with estimated numbers The building space allocation calculations feed into the cost allocation calculations on the CostAlloc Core worksheet This linkage is shown in the diagram below silos ng Figure 6 12 Location of the Building Core CostAlloc Core worksheet in the o
132. hanges which are xDSL enabled This feeds into the In Subs worksheet of the Core module and impacts the distribution of xDSL subscribers across ESAs Service demand projections are based on 2007 values D17 D80 At the bottom of the worksheet rows 120 245 there are the calculations for forecasting the modelled services including the interpolation curves used for the forecasts Changes to forecasts are controlled through changing CAGR values column K and curve shapes column L The service demand projections can also be controlled through a demand sensitivity array which can be manipulated to investigate the effect of different forecast loadings on the network er WM Analysys Fixed LRIC model user guide Version 2 0 134 6 3 2 Calculation description The following table outlines the calculations contained in the Inputs Demand worksheet Cell reference Description and details of worksheet calculations Rows 7 10 Projections of exchanges enabled for xDSL Row 13 Projections of exchanges enabled for xDSL Rows 17 46 Service demand forecast for 2007 2012 Rows 51 80 Call forecast for 2007 2012 Rows 85 114 Demand sensitivity array for 2007 2012 Rows 120 245 Demand input for modelled services Table 6 2 Calculations performed on the Inputs Demand worksheet Source Analysys 6 4 Inputs Core worksheet The Inputs Core worksheet provides the link between the outputs from the Core mod
133. he UnitCost Core worksheet in the overall Cost module structure Source Analysys TA Core f 6 10 1 Key parameters This worksheet contains unit cost data for 2007 cells F27 F226 based on benchmark data sources An allowance percentage uplift on the asset unit cost is made for spares cells G27 G226 installation cells H27 H226 and for indirect assets costs cells 127 1226 At present the model is populated with a 0 uplift for spares a 15 installation uplift for equipment assets the trench duct and fibre asset unit costs already contain installation costs and a 0 uplift for indirect costs This worksheet also contains inputs for detailed unit cost data on the site acquisition preparation and maintenance of sites for LEs AT1s LAS and TNS These inputs are in cells Q27 T43 and can be varied by geotype The lifetimes for the major asset types is also listed on this worksheet cells D9 D21 These are based on benchmark data 6 10 2 Calculation description The following table outlines the calculations that are contained on the UnitCost Core worksheet me WM Analysys 6 11 6 11 1 Key parameters Fixed LRIC model user guide Version 2 0 154 Cell reference Row 5 Rows 9 21 Rows 27 226 Rows 29 43 Rows 231 430 Rows 435 634 Rows 639 838 Rows 843 1042 Description and details of spreadsheet calculations Unit capex cost per network element Lifetime inputs
134. her fibre services CAN IEN and inter IEN overlap parameters Percentage of trench that is ducted Location Modern TDM H11 J11 Modern xDSL P11 Q11 NGN M5273 05273 Modern TDM L11 M11 Modern xDSL R11 S11 NGN P5273 Q5273 T11 H10533 H10535 E15804 G15804 C21063 C21065 K21122 Impact Affects the maximum capacity of a line card reflecting a deployment strategy of an operator Affects the maximum capacity of a shelf Drives backhaul provisioning on each LE link Impacts the number of E1s provisioned for voice and ISDN Deployment of spare and fibre for other services above those required just for the LE Affects the volume of duct and trench assets calculated for the LE level The distance of duct within CAN areas is retained for cost allocations between and CAN and IEN Affects the amount of trench that is ploughed versus that which is deployed with ducts Table 5 14 worksheet Source Analysys 5 10 2 Calculation description Key parameters in the NwDes 1 Access worksheet linked from the In Network This worksheet contains network design algorithms for the LE level This includes calculations for the equipment required and link transmission dimensioned for the links from the LE to the point of confluence PoC The table below lists specific data inputs and calculations by row number 9995 207 Analysys Fixed LRIC model user guide Version 2 0 87 Cell
135. hrough the network by traffic type Rows 234 264 Calculation of the busy hour load for each part of the network according to the routed service demand Rows 267 271 Calculation of the busy hour load for each part of the network on a per PSTN SIO and per ISDN SIO basis An input table of routeing factors determines the factor applied to each service volume when calculating the load on the various parts of the network Sheet Dem Calc Rows 134 230 An example of these routeing tables is shown in the figure below for PSTN local traffic pibadi WM Analysys Fixed LRIC model user guide Version 2 0 72 PSTN local traffic onnet traffic Note the samen of es routes determine the routeing of traffic across the core network for the different types of traffic These routeing factors d LASI LAS2 TNS1 TNS2 LE2 EES EE ML TS NE SET EEE CPE gt gt LE gt gt LAS gt gt LAS gt gt LEs gt CPE TB MR TT CPE gt gt LE gt gt LAS gt gt TNS LAS gt gt LE gt gt CPE Els NE IE SEE NES EE NEE EES EEUE PRES TNS gt LAS gt gt LE gt gt CPE Figure 5 16 Excel screenshot displaying sample of routeing factor input tables for PSTN local traffic Source Analysys The routeing factors for a particular traffic service are calculated on the basis of the number of times loading a particular network element is used to deliver the service being modelled Different combinations of network elements may be used depending on the path taken in the network Fo
136. iated pits manholes iE BUT GUNS OJI CASIO Number of ducts Mote select a Pit type listed above to corre Note duct combinations should be sorted z ducts ducts ducts ducts ducts ducts ducts ducts ducts ducts H Buks vaks Define capacity of pits in terms of number of links entering exiting A links links links links Minimum pit for a pillar ducts Figure 2 11 Excel parameters for pit and duct Source Analysys The above parameters drive the pit and duct calculations The first three sets of inputs define the labels of the pits and manholes which can be used Six types have been defined and it is not expected that they will change The next three sets of inputs relate to determining the minimum pit size that should be deployed at a cluster node Number of ducts Combinations of the number of ducts which can be deployed are listed in entering the node decreasing order A pit name is associated with each duct combination Each listed pit should tie in with at least one duct combination Number of links Pits are limited by the number of diverse routes they can accommodate The intersecting at a pit type associated with 1 2 3 or 4 and above routes entering from one node side of the pit is defined Is the cluster node The minimum pit requirement for a pillar location is defined separately a pillar Each node is allocated the smallest pit that satisfies the pit requirements of these three criteria
137. ide Version 2 0 148 Cell reference Description and details of spreadsheet calculations Columns F I Calculation of cost allocation of duct trench assets between fibre and other duct services Duct and trench asset costs are allocated to either the incumbent or to other services that are located in the trench These allocation figures are sourced from the calculations that take place on the I Ducts Core worksheet The figure below shows an Excel output of the calculation of cost allocation of duct trench assets between fibre and other duct services Calculation Cost allocation Duct Trench assets Duct Trench assets Asset group Asset Fibre Core cost Fibre Other duct Fibre Other duct type type services services indez ATI AT2 ATLFibre Incremental ATI AT2 AT1 Trench Incremental ATI AT2 AT1 Duct Incremental AT2 Ports AT2 AT1 rings 10Mbit s ports g incremental AT2 Ports AT2 AT1 rings 100Mbit s ports glineremental AT2 Ports AT2 AT1 rings IGE ports 10 Incremental LE AT1 LE PoC Fibre Incremental LE ATI LE PoC Trench Incremental LE ATI LE PoC Duct Incremental Figure 6 20 Cost allocation calculation of duct trench assets between fibre and other duct services Source Analysys Cell reference Description and details of soreadsheet calculations Calculation of cost allocation of fibre assets between SDH and other fibre services Columns K N The cost of the fibre is either allocated to SDH i e to
138. illar If a cluster in an ESA has any loops exceeding this length then an LPGS is deployed Decreasing this distance increases the propensity to deploy LPGS Cell reference Description and details of soreadsheet calculations Rows 198 211 9995 207 Fibre inputs by geotype Analysys Fixed LRIC model user guide Version 2 0 24 Fibre Geotgpe Fibres linking location Fibres linking DP to DP to pillar EE 2 6 6 3 6 6 4 6 6 5 6 6 6 6 6 7 6 6 8 6 6 3 6 6 10 6 6 1 6 6 12 6 6 13 6 6 14 6 6 Ao ation LEP Are pars LEE pillar Sle pars Figure 2 20 Excel parameters to determine fibre dimensioning Source Analysys These parameters are used to dimension the fibre cables for point to point links up to the DP and between the DP and pillar respectively Cell reference Description and details of soreadsheet calculations Rows 218 231 Copper versus wireless decision data by geotype The rural deployment uses a cost based decision to determine whether each location should be served by a wireless or copper solution These coefficients comprise the terms in the cost based decision Increasing the coefficients for copper will decrease the propensity of the algorithm to deploy it so fewer locations are likely to be served by copper Copper versus wireless decision Geotspe Coverage radius Mazimum Set up cost fora Set up cost fora Incremental Set up cost Incremental cost for Incremental Incremental capacity of b
139. in the data sub module The option This range of ESAs means that all ESAs within the range specified on the Inputs worksheet are re calculated The option All means that all ESAs are re calculated regardless of this range It is recommended that ranges of ESAs are calculated in batches when re running the whole of the sample See section 1 1 2 for further details Options for calculating for ESAs This range of ESAs ESAs to calculate options Figure 2 6 Excel parameters for the options available for the calculation of ESAs Source Analysys 9995 207 WM Analysys 2 2 Fixed LRIC model user guide Version 2 0 11 Cell reference Description and details of spreadsheet calculations Rows 49 56 Labels These are the labels for the possible clusters derived by the access network deployment algorithms and are used in the summary tables for each ESA in the data sub module Copper clusters are denoted by either e RAU if served by the RAU e Pillars if served by a pillar e LPGS fibre wireless satellite backhaul if served by an large pair gains system LPGS with its means of backhaul to the RAU also specified Other clusters are labelled as either base transceiver system BTS or satellite if they are either served by wireless technology or satellite respectively LPGS fibre backhaul abe LPGS fibre backhaul LPGS wireless backh label LPGS wireless backhaul LPGS satellite backhi
140. ing sensitivity testing the number of access services in operation To change the Cost xls Inputs Demand D120 N241 Alternatively the traffic demand may be Adjusting the demand levels affects traffic modelled directly manipulated at the bottom of this the loading on the core network and Option 2 worksheet Forecasts are calculated by the number of access services in selecting a CAGR for the period 2007 2012 operation and an interpolation curve that outputs a demand line between 2007 and 2012 Define size of the Cost xls Inputs Demand D8 18 This is used to define the number of SIOs Adjusting the input value of SIOs will CAN used to dimension the CAN It can be used change the number of all assets to reflect that the number of locations calculated in the CAN module Note reachd by the CAN may be fixed though that higher value of input CAN SIOs actual demand is changing over time It and sum of access SIOs in the may be appropriate to set to a value demand forecast consistent with the geoanalysis Defined xDSL Cost xls Inputs Demand D13 113 This is used to define the number of Enabled exchanges impacts the enabled exchanges which are xDSL enabled The distribution of xDSL subscribers and exchanges order in which exchanges are enabled is therefore the dimensioning of LE defined on the In Subs worksheet of the POC backhaul links Core module Review total Core xls In Subs E12 E27 The distribution of access SIOs by geotype Impacts both the access
141. ion ports are presented as STM 1 ports A screenshot of the Excel LAS Interconnection transmission calculations is shown below LAS LTH Interconnection traffic Note TDM traffic is transmitted in terms of E1 carriers NGN traffic is transmitted in terms TDM based traffic calculations PSTN ISDN PSTN ISDN Total LAS ID LAS Name ALBG ALBURY ALSG ALICE SPRINGS AXE ADLJ ARMIDALE BALJ BALGOWLAH S12 BRAJ BALLARAT S12 BAKN BANKSTOWN 1 S12 BRPT BANORA POINT BATJ BATHURST AXE BEGX BEGA AXE BENV BENDIGO LAS BLAP BLACKTOWN AXE 2 BLHJ BLAKEHURST AXE BHLX BOX HILL BNHJ BROKEN HILL Figure 5 55 Transmission requirement calculation for LAS Interconnection links Source Analysys Cell reference Description and details of soreadsheet calculations Rows 1173 1966 LAS ring structure calculations including the capacity calculations for the physical ring dimensioning and the fibre trench and duct distance calculations LAS rings are grouped by major urban area Perth Adelaide Melbourne Canberra Sydney and Brisbane The model has been set up with a series of physical LAS ring structures A set of these rings are defined for each of the main metropolitan areas in Australia namely Perth Adelaide Melbourne Canberra Sydney and Brisbane The composition of each of the LAS rings is user defined and is flexible enough to accommodate changes to the structure The current composition is based upon Analysys s estimate as to an appropriate
142. iption and details of spreadsheet calculations Row 4 Modelled year Rows 10 112 Capital cost inputs for duct copper cable and jointing Cells AG10 AW35 Calculation of relative cost contribution of trenching component as part of the duct deployment costs Rows 118 198 Access network equipment investment costs in AUD Rows 203 283 Unit capex cost per network element Rows 288 368 Opex as a percentage of opex Rows 373 453 Unit capex trends per network element Rows 458 538 Unit opex trends per network element Table 6 20 Calculations performed on the UnitCost Access worksheet Source Analysys 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 168 6 17 TA Access worksheet This worksheet performs the annualisation calculation on the access network costs The calculation is presented differently to the core network annualisation as the access network is modelled according to the geotype dimension and does not require a multi platform approach This worksheet contains data on volumes of equipment deployed their asset lifetimes and service demand data linked in from the Inputs Access worksheet and capex and opex parameters by asset linked in from the UnitCost Access worksheet It calculates the annualised capex cost and subsequently adds the opex cost in year to generate the total cost by asset A defined amount of the access network costs are allocated to the core network costing Subsequently a servi
143. ired required required Access Tier Geotgpe Served by TOM ADSL SDSL ADSL SDSL 1 LE site _ equipment AARE 6 AASS 6 ABAY TS ee ees EE e ABCH EE scot DOE T NARE EEN PRE cull fo ecg EE ABCK eee ie ABDN sil EL ADA EE EE KIE EER NE EE ABEE EE S EEN ER N EE N HA Ok N EER ABER 13 ABES 8 ABFL Bi Figure 5 35 Excel screenshot showing sample of the calculation of xDSL subscriber and equipment requirements Source Analysys Cell reference Description and details of spreadsheet calculations Rows 5276 10529 Calculation of NGN MSAN equipment requirements 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 91 The NGN equipment is calculated using a similar methodology based on line card shelf and rack requirements PSTN VDSL and ISDN lines are modelled to be handled by the same MSAN equipment Transmission requirements Cell reference Description and details of spreadsheet calculations Rows 10538 15791 Calculation of the transmission requirements for the LE PoC links The calculation of the transmission equipments takes into account the quality of service to which the network is dimensioned this reflects the fact that a small percentage of calls will not be connected as there are no available channels in the network The calculation also explicitly takes into account a quality of service QoS parameter in the network by means of a network blocking probability This parameter represents
144. is is relevant to the next generation access scenario Table 4 3 9995 207 Calculations performed on the Access worksheet Source Analysys Analysys Fixed LRIC model user guide Version 2 0 55 5 Core module The Core module generates calculations for the dimensioning of the network from the MDF in the local exchange or the large pair gain system into the core network The Core module contains the calculations for both the modern and next generation network NGN architectures A similar structure is used for the modern and NGN architectures with the calculations at the corresponding levels of the two architectures taking place on the same set of worksheets Network Design worksheet Modern network level calculations NGN level calculations NwDes 1 Access Local exchange LE Access Tier 1 and 2 AT1 amp AT2 NwDes 2 PoC Point of confluence PoC Point of confluence PoC NwDes 3 RegNodes Local access switch LAS Regional node NwDes 4 CoreNodes Transit network switch TNS Core node NwDes 5 Islands Special island solutions Special island solutions Table 5 1 Network design worksheet content summary Source Analysys The levels of the core modern network and core NGN networks as modelled are shown below in Figure 5 1 and Figure 5 2 respectively The designated network physical boundary between the access and core network 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0
145. it 10k A Incremental LE LE Network unit of LPGS Incremental Figure 6 24 Calculation of cost allocation across all platforms transmission and other Source Analysys 9995 207 D Ana lysys 6 9 Fixed LRIC model user guide Version 2 0 151 RF Core worksheet The RF Core worksheet calculates the core network service routeing factors which are subsequently used in the calculation of the network element output on the Dem In Core worksheet The sets of routeing factors are also subsequently used in the service costing calculation on the TA Core worksheet Figure 6 25 Location of the RF Core worksheet in the overall Cost module structure Demln Core Source Analysys TA Core l 6 9 1 Key parameters This worksheet contains the core service routeing factors linked from the Inputs Core worksheet The only parameters which should be changed on this worksheet are those routeing factors associated with the core network operations These are located on rows 150 156 6 9 2 Calculation description The following table outlines the calculations that are contained on the RF Core worksheet Location Parameter Rows 8 207 Core routeing factors Table 6 11 Calculations performed on the RF Core worksheet by row Source Analysys waht WM Analysys Fixed LRIC model user guide Version 2 0 152 The routeing factors are calculated from the I
146. k in the cost module on the TA Core and TA Access worksheets 9995 207 Analysys A8 Cost modelling changes unit costs Annexes to Fixed LRIC model user guide A 11 Objective Workbook Worksheet Cell reference Description Impact To adjust the Cost xls WACC C8 C17 The WACC is calculated using a number Adjusting the modelled WACC will WACC used in the of parameters At present these result in different annualised costs in model parameters have been populated using the tilted annuity calculations on the data from the ACCC A model user may TA Core and TA Access wish to populate the model with different worksheets values To change the unit Cost xls UnitCost Core F27 1226 Q29 T43 The equipment costs used in the model Adjusting any of the unit cost capital costs for have where possible been based on components will result in a different the core network Australia network data Where this total unit cost flowing through to the assets information was unavailable benchmark TA Core worksheet column G data has been used The total unit asset cost is composed of e a direct unit cost column F e a spares uplift percentage column G e an installation uplift percentage column H and e an indirect cost percentage uplift column 1 Costs for site acquisition and preparation are specified for LEs AT1 LAS and TNS in cells Q29 T43 To change the Cost xls UnitCost Core E639 J838 The unit cost is
147. label LPGS satellite backhaul Figure 2 7 Excel labels Source Analysys Inputs worksheet This worksheet contains the key inputs dimensioning the equipment and network topology used in the access network Whenever a particular ESA is calculated within the geoanalysis and access network module the assumptions for the ESA which are determined by its geotype are read into the design algorithms from this worksheet using subroutines such as SetUpPermanentConstants and ReadInGeotypeData aid the summation of asset volumes in LPGS clusters of all types within an ESA 9995 207 A copper cluster served by LPGS is not labelled as LPGS its means of backhaul is always specified as well LPGS label is used to DAnalysys Fixed LRIC model user guide Version 2 0 12 Figure 2 8 Location of the Inputs worksheet within the overall structure of the Access network deployment algorithms driven by the macro FullAccessNetworkBuild geoanalysis and access network module Source Analysys Code sub module The worksheet also specifies which ESAs will be re calculated if the Derive access network volumes button is pressed and the option This range of ESAs is selected 2 2 1 Key parameters This worksheet contains all the important assumptions used to derive the access network volumes Parameter Location Impact ESAs to process Rows 3 7 Controls which ESAs are processed by the ac
148. ls workbook which are used for the consistent display of asset volumes in the output worksheets 32 1 Key parameters This worksheet does not require any inputs or user interactions ska WM Analysys Fixed LRIC model user guide Version 2 0 39 Parameter Location Impact Sizes of copper cable employed in Rows 5 13 List of copper cable sizes used in the network the network linked to a table breaking down the cable lengths by size for the processed ESA There is also a separate table with the boundaries of demand to be served by each cable size in the final drop Labels Rows 16 23 Labels used to identify the pillar clusters and pillar equivalents in the ESA Duct combinations Rows 27 36 Tables linked into the final output tables for each ESA to display the trench deployed with each number of ducts Pit types Rows 40 45 Labels used to identify the pit types deployed in the ESA Distribution network options Rows 49 50 Labels used to identify the options for the deployment of the cable in the distribution network Table 3 1 Labels on the Links worksheet Source Analysys 3 2 2 Calculation description 3 3 9995 207 These ranges are linked in from Access CODE xls and themselves link into the output tables of each ESA worksheet The cluster labels LPGS satellite RAU etc are used for the summing of output volumes by cluster into totals for the whole ESA but are also written within the Visu
149. lysys 5 10 NwDes 1 Access worksheet The NwDes 1 Access worksheet calculates the dimensioning of the LE modern network and Access Tier 1 NGN on the basis of the services in operation hosted at each individual node and the busy hour demand carried on the transmission links Allowance is made for other transmission traffic spares and other fibre services 9995 207 Analysys Fixed LRIC model user guide Version 2 0 85 Subscriber numbers and demand data at each LE AT1 are linked from the In Subs worksheet and from the In Demand worksheet respectively The number of assets calculated on this worksheet are output to the Out Assets worksheet These linkages are shown in the diagram below Figure 5 31 Location of the NwDes 1 Access worksheet in the overall Network design algorithms Core module structure Source Analysys NwDes 1 Access NwDes 2 POC NwDes 5 Islands 5 10 1 Key parameters No parameter values are inserted manually into this worksheet but numerous key parameters are linked from the In Network worksheet The utilisation parameters set out below are the key parameters that can be changed 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 86 Parameter Line card utilisation Shelf and rack capacity factor xDSL backhaul Quality of service Fibre uplift parameter for spares and ot
150. mapping the first co ordinates directly onto their nearest street using MapInfo this second point is referred to as the FDP Both sets of co ordinates are derived in the relevant zone Changing the location data is an intrusive adjustment for an ESAs and will certainly change the network deployments The DP cluster index for URBAN deployments is printed during the calculation The pillar cluster index is identified using the INDEX function on the table of DP clusters Whether the location is Analysys Fixed LRIC model user guide Version 2 0 45 served by copper fibre wireless satellite as well as the exact nature of the location is also printed Location data and DP cluster Point indez FDP z FDP GNAF z GNAF Point Cluster Pillar indez Served by Location AMG AMG AMG AMG capacity indez copper or fibre type BESMEER SEE RESA Mt QVALRES Mt QWAFL RES sist point can sist cluster MRESA GL BERG SE SIS IOCHIOR LYRE 1 28047504 6125097 26047504 6 132 509 97 1802 1 Copper RAU 2 3 2 Copper DP s 2zsseeisl 613052302 2rsseusil eiaoeras 2 2 3 Copper FOP 2rssessol 6130864 83 arsrostrl Eiossogs 2 2 3 Copper DP s 27365398 613250918 27967907 srana 2 1186 8 Copper FOP s 27985315 613252070 __279678 6 _619262262 Ts ves 10 Fibre FOP z 27365236 613253089 2rserriel emesan 2 nes 10 Copper DP s 2738280 613246637 27966101 613248763 2 1213 8 Copper FOP s 27365490 6t32497 66 27967939 e1
151. mber of copper SIOs per location 132 269 315 135 127 134 138 116 Average number of fibre SIOs per location 140 62 104 90 n 108 83 103 87 118 42 84 12 64 86 Average number of wireless SIOs per location 12 z y 3 Average number of satellite SIOs per location 1 Access technoloav Average proportion of SIOs addressed directly by copper 64 05 1 88 86 01 93 44 Average proportion of SIOs addressed directly by fibre 36 95 88 12 3 99 6 56 Average proportion of SIOs addressed directly by wireless x x x Average proportion of SIOs addressed directly by satellite x n x x Wired connections Copper parameters Average proportion of copper SIOs directly connected to LE 3 18 13 99 251 374 Average proportion of copper SIOs served by LPGS 084 3 12 36 94 29 56 Average proportion of copper SIOs served by pillars 95 92 82 89 60 55 86 69 Fibre parameters Average proportion of fibre SIOs directly connected to LE 131 12 65 2 09 9 03 14 26 Average proportion of fibre SIOs served by pillars 98 69 87 35 97 91 90 97 85 74 100 00 Figure 2 35 Excel data for calculation of geographical and technological factors by geotype Source Analysys Cell reference Description and details of spreadsheet calculations Rows 305 458 Assets by geotype Figure 2 36 below shows examples of the parameters that are the ultimate outputs from the geoanalysis and access network module These are a combination of average proportio
152. mental costs that are allocated from the access network Incremental cost allocation to platforms based on the core cost allocation percentages output from the CostAlloc Core worksheet Core platform incremental cost allocation to services PSTN columns AM BP ISDN columns BR CU xDSL columns CW DZ and transmission columns EB FE Calculation of the incremental cost by service for each platform Calculation of the shared cost EPMU and business overheads EPMU Service cost calculation for incremental cost incremental shared cost incremental shared business overheads cost Table 6 14 Calculations performed on the TA Core worksheet Source Analysys The remainder of this section provides an overview of the calculations in this worksheet Cell reference Description and details of spreadsheet calculations Cells B11 0210 Asset cost annualisation calculation e Columns F L provide the inputs required for the tilted annuity cost annualisation calculation o Column I total capex cost is the gross replacement cost GRC of the network It is calculated by multiplying the unit capex column G by the total number of network equipment assets deployed column F o Column J is the annual capex price trend linked from the UnitCost Core worksheet o Columns K is the tilt adjustment parameter 9995 207 DAnalysys Fixed LRIC model user guide Version 2 0 157 o Column L is the economi
153. mprise the following e Core route analysis defining the routes between core nodes from the local exchanges LE and points of confluence PoCs to the local access switch LAS and calculating the total and incremental distances 9995 207 jw An d lysys Fixed LRIC model user guide Version 2 0 2 e Overlap analysis an analysis of actual routes based on road distances to inform the core module e Geoanalysis and access network module estimating the access network A demand module discussed in previous versions of the LRIC model has been removed Demand forecasts are now controlled in the cost module Inputs Demand worksheet The active modules and Geoanalysis and access network module as well as their system requirements are described below The core route analysis is described in Annex B The overlap analysis is described in the main report 1 1 1 Active modules access and core network design and service costing calculations The active modules whilst being large files are logically structured and an experienced MS Excel modeller following the provided documentation should be able to navigate and operate the models In Annex A a structure is proposed for working through the model in a logical manner The following section explains how to calculate results and maintain links between files Single year result To produce a fixed long run incremental cost FLRIC model result all three active mod
154. multiple ring structures The following explanation involves the concept of parent and child rings The parent ring is the ring which contains the LAS node A child node is one which links on to the parent node this link is by means of a bridging node the capacity of which is included in the dimensioning of the parent ring in the base case two bridging nodes are required for resilience purposes traffic would still be routed in the case of a single point of failure at one of the bridging nodes between a child and a WM Analysys Fixed LRIC model user guide Version 2 0 99 parent ring unless the bridging point is at the LAS node in which case only a single bridging node is implemented This calculation has been broken up into a number of steps and calculated explicitly in columns L O and P S for the TDM and NGN transmission dimensioning respectively 5 12 NwDes 3 Reg Nodes worksheet The NwDes 3 Reg Nodes worksheet is a part of the network design algorithm It contains the calculations for the dimensioning of equipment and transmission at the LAS level modern network design and regional node level NGN design As per the scorched node principle the LAS calculations are performed on a node by node basis for each of the 133 LAS locations In the modern network structure the LAS node specifically only handles voice traffic with data traffic being handled by alternative equipment at the co sited local transmission
155. n backhaul link Backhaul capacity per subscriber Critical capacity 9995 207 Fixed LRIC model user guide Version 2 0 25 This is the capacity constraint used when clustering locations to be fed by wireless BTS having scaled the copper demand of the locations in order to derive a measure of the wireless demand see Incremental capacity per unit of high demand below The trench cost of a copper cluster is calculated incrementally with each location that is attempted to be added to the cluster using the formula New cost Old cost Incremental set up cost for copper per unit distance x distance between location and nearest other location in cluster The total cost of a copper cluster is calculated by Total cost Set up cost for a pillar LPGS total trench cost The total cost of a wireless cluster is calculated by Total cost Set up cost for wireless number of wireless locations in cluster x incremental cost for wireless CPE The demand by location stored in the workbooks reflect copper demand i e lines required This mapping of demand may not be suitable dimensioning for a wireless solution as these will be driven more heavily by the Erlangs of traffic passing onto the network When calculating the demand served by a BTS different scaling factors can be applied to demand at locations depending on whether it is one or several units of demand However the model currently has identical scaling facto
156. n a lysys Fixed LRIC model user guide Version 2 0 101 Parameter Location Impact Equipment capacity parameters Cells D153 G153 F295 Defines the physical equipment capacity Rows 437 438 579 580 Link utilisation parameters Rows 1172 1916 Affects the maximum effective loading of the transmission links reflects the fact that links are not dimensioned to be fully loaded Fibre uplift parameter for spares Rows 1172 1916 Deployment of spare and other fibre above and other fibre services those required just for the LAS ring Transmission carried kbit s Rows 1172 1916 Allowance for other transmission requirements on the LAS TNS links CAN IEN and inter IEN overlap H1943 H1945 Affects the volume of duct and trench parameters assets calculated for the LAS level The distance of duct within CAN areas is retained for cost allocations between and CAN and IEN Percentage of trench that is ducted H2011 Affects the amount of trench that is ploughed versus that which is ducted Table 5 19 Key parameters on the NwDes 3 Reg Nodes worksheet Source Analysys 5 12 2 Calculation description This worksheet contains network design algorithms for the LAS level This includes calculations for the equipment required and link transmission dimensioned for the links from the LAS to the TNS and the LAS to interconnection with other networks The table below lists specific data inputs and calculations by row number Cell refe
157. n building equipment results in a building costs to the exchanges Building costs such as different allocation of costs on the platforms air conditioning and power are assumed CostAlloc Core worksheet to be related to the equipment size To change the Cost xls Ducts Core C7 F10 The inputs in the yellow boxes may be Adjusting the number of sub ducts allocation of duct manipulated by the user and the number of these ducts used costs between the by the incumbent results in a different incumbent and allocation of costs on the other duct services CostAlloc Core worksheet To change the Cost xls Scenario C25 The trench sharing between the various Adjusting the size of the proxy access level of trench sharing between the access and core network levels levels in the core network and between the access and core networks has been externally calculated using MapInfo However the user is able to select the level of sharing based on different proxy sizes for the access network To change the size of the proxy access network select the appropriate size from the pull down selection box in the identified cell For more detail on this parameter please refer to the overlap analysis in section 7 11 of the main report network results in a different set of overlap numbers being used in the Core module on the In Nodes worksheet cells W20 W33 This results in a different level of core network costs transferred to the access networ
158. n edge router Cell reference Description and details of spreadsheet calculations Rows 299 432 NGN trunk gateway dimensioning The trunk gateway switch acts as a switch between legacy network and NGN all non NGN traffic is aggregated at switches and converted to IP The trunk gateway is dimensioned in terms of STM 1 gateways Traffic from PoCs NGN trunk gateway LAS ID LAS Name aa SDH E1s NGN kbit s STM 1 ports ALBG ALBURY ALSG ALICE SPRINGS AXE ADLJ ARMIDALE BALJ BALGOWLAH 12 BRAJ BALLARAT S12 BAKN BANKSTOWN 1 S12 BRPT BANORA POINT BATJ BATHURST AXE BEGX BEGA AXE BENV BENDIGO LAS BLAP BLACKTOWN AXE 2 BLHJ BLAKEHURST AXE BHLX BOX HILL Figure 5 47 Excel calculations for the NGN trunk gateway dimensioning Source Analysys The specific calculation methodology for the trunk gateway switch is outlined below kig WM Analysys Fixed LRIC model user guide Version 2 0 104 Figure 5 48 Calculation of trunk Nimberor Gites gateways Source gateways required Analysys Cell reference Description and details of soreadsheet calculations Rows 441 574 NGN edge switch dimensioning The Edge Switches aggregate traffic from the TGW and MSANS for delivery to and from the core and access nodes The Edge Switches are dimensioned according to the links to the Edge Router the links to the Trunk Gateway and the links from the PoC nodes The chassis required are driven by the number of 48 port cards and 1
159. nces calculated DAnalysys Fixed LRIC model user guide Version 2 0 126 Where several ESAs are on an island it is possible to define a local network so that certain ESAs subtend to a principle ESA where the off island solution is provided from Within the island these links can be defined as fibre based or microwave based A submarine solution is modelled for the LAS TNS link from Tasmania to the mainland The required numbers for equipment deployed derived from this worksheet is then linked to the Out Assets worksheet These linkages are shown in the diagram below Figure 5 85 Location of the NwDes 5 Islands worksheet in the overall Network design algorithms Core module structure Source Analysys NwDes 1 Access NwDes 3 Reg Nodes v NwDes 4 Core Nodes NwDes 5 Islands 5 14 1 Key parameters The island backhaul solution implemented for each particular island can be selected as either microwave satellite or submarine cable For subtended ESAs trench can also be selected For example Kangaroo Island in South Australia has 11 ESAs 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 127 If addition island solutions are to be implemented additional lines will need to be inserted above line 69 and links to the output summary should be reviewed 5 14 2 Calculation description This worksheet contains network design algorithms for
160. nch sharing P10 P91 multiplied by the proportion of equipment purchased by geotype cells V10 AK91 Total cost per geotype annualized capex cost per geotype cells BD10 BS91 Opex cost per geotype cells BU10 CJ91 Trench and duct cost allocated to core cells DT10 ElJ91 Fibre cost allocated to the core network cells EK10 EZ91 Cost savings and costs from core allocated to geotypes cells FB10 FO91 Cost per unit output by geotype total cost per geotype FS10 GH91 divided by the demand by geotype linked from the Dem In Access worksheet Calculation of the total trench duct and fibre costs allocated to the core network These figures are linked in to the TA Core worksheet Service costing calculation by geotype This matrix is linked into the Results worksheet Table 6 21 9995 207 Calculations performed on the TA Access worksheet Source Analysys DAnalysys Fixed LRIC model user guide Version 2 0 170 6 18 Results and Results Pasted worksheet The Results worksheet presents the core and access network results and calculates the resultant LRIC cost It takes its inputs from the core and access cost annualisation worksheets TA Core and TA Access Figure 6 37 Location of the Results worksheet in the overall Cost module structure Source Analysys TA Core Asset sharing between core and access TA Access
161. ncremental ATI ATI Ports PoC facing 10GE ports n imeremental ATI AT2 ATt Fibre Incremental ATI AT2 AT1 Trench Incremental ATI AT2 AT1 Duct Incremental Figure 6 23 Calculation of cost allocation between platforms PSTN ISDN xDSL Other service platforms Source Analysys Cell reference Description and details of spreadsheet calculations Columns AD AJ Calculation of cost allocation across all platforms transmission and other services This final matrix calculates the total cost allocation percentage to each of the cost buckets individual platforms transmission other fibre services other duct services The figure below shows an Excel output of the calculation of cost allocation across all platforms transmission and other Asset group Asset Fibre Core cost PSTN ISDN DSL Other Cost allocation Transmissio Other fibre Other duct type type platforms n services services indez LE LE Site acquistion preparation and maintenance Incremental LE LE Concentrator Processor Incremental x LE LE Concentrator PSTN line card Incremental x LE LE Concentrator ISDN 2 line card Incremental LE LE Concentrator ISDN 30 line card Incremental x LE LE DSLAM 2nd Gen Incremental LE LE SDSL line card Incremental LE LE ADSL line card Incremental LE LE Splitter Incremental LE LE LPGS equipment Mux Incremental LE LE UPS 40k VA and Generator 50k A Incremental LE LE Air conditioning un
162. ncy factor Edge router traffic per SDSL sub 25 07 Utilisation 80 2 2 12 Bandwidth required Kbit s IGE ports to meet traffic requirements 1GE cards required Connectivity Connectivity to two Core Connectivity totwoCore Chassis tem ELE JES Das eed oorsese is Edge volk Routers x2 for resilience to Edge Switch Routers x2 for required Figure 5 51 Excel calculations for the NGN edge router dimensioning Source Analysys Figure 5 52 Calculation of the number of Edge Router chassis units GE ports required for connectivity to Edge Switch required Source Analysys 1GE Edge Router cards required GE ports required for connectivity to Edge Routers x2 Transmission dimensioning At the LAS regional node level transmission links for LAS LAS traffic and LAS TNS traffic are calculated As per the previously documented transmission calculations the links are dimensioned by the per subscriber busy hour traffic as calculated on the Dem Calc worksheet Cell reference Description and details of soreadsheet calculations Rows 743 881 Transmission requirement for LAS LAS links A screenshot of the Excel LAS LAS transmission calculations is shown below 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 107 LAS LAS traffic grade of service 0 50 grade of service Erlang conversi 92 61 Erlang conversion factor l circuits per E1 30 circuits per E
163. ng whether a LPGS is served by fibre or wireless Fibre backhaul Fixed LRIC model user guide Version 2 0 29 Cost function for identifying a fibre backhaul link for copper fed areas is of the form kI Dy k2 D d where Dy is the additional trench required for the link and De is the capacity needed in the link 0 0004000 wadefivetacthautht 0 0000062 FT EE Wireless backhaul Cost function for identifying a wireless backhaul link for copper fed areas is of the form klek2 Mek3 n where nis the number of relay stations required for the link and Mis the cost multiplier for the relevant capacity needed 1 60 PUBS NCCES hark hout k 100 MEE INCOSE hark hout 5 40 PUBS INCOSE bak hout 7 Figure 2 27 Cost function coefficients Source Analysys k D k D Where D thelengthof newtrench required D thelength of cabling required for the link k _ cost coefficients det er min ed in excel k d k M k n Where d the crow flies dis tan ce between the nodes n the number of relay stations required for the link M cost multiplier for the relevant capacity needed k _ cost coefficients determined in Excel Cell reference Description and details of soreadsheet calculations Rows 324 355 Distance function Rows 361 374 Trench sharing coefficient Figure 2 28 Form of cost function for identifying a fibre backhaul link for copper fed areas Source Analysys Figure 2 29 Form of proxy
164. nge these parameters which subsequently controls the voice data daily and of traffic dimensioning of the core network occurring during weekdays for different assets traffic types To change the Core xls Dem Calc C134 C136 The percentage of traffic that takes a Different routes result in different routeing of traffic C150 C162 particular route through the core network network loadings on particular across the core C174 C175 may be altered by the user The routes network elements network C188 C189 are described in column B with the associated percentage of traffic that takes that route through the network is entered in column C in the identified cells To change the Core xls In TNS Gravity C6 This parameter controls the degree to When set to 0 distances not taken routeing of traffic between core TNS nodes which distance between nodes affects the routeing of traffic across the core network This parameter may be set to any integer however as a base case it is set to 0 into account when set to 2 basic relationship to distance taken into account 9995 207 Analysys Core network route configuration and distances Annexes to Fixed LRIC model user guide A 6 Objective Workbook Worksheet Cell reference Description Impact To change node Core xls In Nodes G41 H5294 Core node routes are calculated in Different parameters and nodes will trench and fibre B5300 J6799 LE LAS ring xls described in Annex
165. nputs Core worksheet for each asset The service routeing factors for certain assets such as line cards are directly input into the service routeing factor matrix The figure below shows the Excel output of the calculation of core routeing factors Asset group LE IE IE LE LE IE LE IE IE Figure 6 26 PSTN PSTN PSTN Asset PSTNEnd PSTN local Local carriage LE E Concentrator PSTN line card IE HE LE LE DSLAM 2nd Gen ATM backhaul SDSL line card E LE LPGS equipment MuX IE User Access traffic onnet service LCS traffic Lines Minutes Minutes Site acquistion preparation and maint 2 00 2 00 Concentrator Processor Concentrator ISDN 2 line card Concentrator ISDN 30 line card ADSL line card Splitter UPS 40kVA and Generator 50kVA 2 00 2 00 Sample of the calculation of PSTN routeing factors Source Analysys These allocations are used in the annualisation calculations on the TA Core worksheet 6 10 UnitCost Core worksheet This worksheet calculates the unit cost in real 2007 AUD for the core network assets for the modelled year It further contains the core asset lifetime data The unit cost data for the selected year is subsequently used in the calculation of the total cost of the core network on the TA Core worksheet 9995 207 Analysys Fixed LRIC model user guide Version 2 0 153 Figure 6 27 Location of t
166. ns and average lengths for various elements of the access network Assets Average number of LE per ESA 1 00 1 00 1 00 0 96 1 00 1 00 Average number of LE serving copper per ESA 1 00 1 00 1 00 0 96 1 00 1 00 Copper parameters Copper deployment type 1S URBAN 2s RURAL 100 100 100 100 100 100 Average number of SIO per DP 5 12 5 19 4 23 3 84 4 4 3 92 Average number of SIO per LE cluster 347 33 323 00 351 50 295 22 297 13 254 00 Average number of SIO per pillar 329 00 294 42 343 71 30151 266 67 218 05 Average number of SIOs per LPGS 314 00 288 00 320 36 276 55 197 18 117 82 LPGS backhaul parameters fibre 100 100 100 100 100 100 wireless Ed Ed Ed Ed satellite KA Ka parameters Fibre demand connected directly Percentage of copper pillars on fibre ring Average number of pillars on a ring 14 00 Wireless parameters Average number of locations per BTS Relay stations per BTS Fil Trench network parameters GNAF gt gt FOP Property boundary gt gt FOP FDP gt gt DP 3 57 4 40 6 82 9 16 DP gt gt next node 17 14 31 39 26 62 35 30 Pillar LPGS gt gt LE 63 02 69 44 145 25 193 68 Link on fibre rings pillar to pillar 22 56 65 68 DISTRIBUTION trench by duct size 28 EI x EI 0 24 EA EA 20 ka Ox 16 n 0 12 0x 0x 0 0x 8 Ox Ox m ox 6 5 3 2 2 4 23 15 nz nz 2 26 34 26 34 1 46 48 59 50 DISTRIBUTION pits by size PF28 0 PF20 x 0 PFE 9 6 5 4 Pg 26 21 21
167. nt Trench distances including accounting for sharing within the IEN and with the CAN Dimensioning of softswitch equipment Calculation of the other core network assets that are located at the TNS MTH location Summary for the TNS level assets Table 5 22 Calculations performed on the NwDes 4 Core Nodes worksheet Source Analysys The remainder of this section provides an explanation of the calculations in the NwDes 4 Core Nodes worksheet Cell reference Rows 74 89 Description and details of spreadsheet calculations Subscriber numbers at each TNS Note due to resilience each subscriber is parented by 2 TNSs For resilience purposes each LAS node is parented by two TNS nodes The same network architecture is assumed for the NGN architecture The Excel output for this calculation is shown below 9995 207 Analysys Subscriber calculations Type Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Core node TNS Figure 5 68 Equipment requirement Cell reference Fixed LRIC model user guide Version 2 0 116 ISDN PR ADSL SDSL ISDN BR Site_ID Site_Name PSTN ADELAIDE TN AWTA ADELAIDE TN CANBERRA T MELBOURNE MWTB MELBOURNE METC MELBOURNE PERTH TNS1 PWTA PERTH TNS2 S
168. ntents of the individual cells The model uses a number of input parameters and is designed so that these can easily be changed These are detailed in the S worksheet The inputs themselves are separated into three types e inputs based on data identified in the model using a dark green box outline e inputs based on estimates a yellow cell within a dark green box outline e inputs which are parameters in the model a dark blue box outline Input Parameter Figure 4 2 Input Data Cell formatting used Input Estimate eo in the LRIC model Input Calculation ER Source Analysys Input Link 100 Input Link different Workbook The inputs into the various modules are located on the worksheets whose names begin with In List worksheet This worksheet defines the list of assets for the CAN as well as the category or level for each asset It also contains named ranges linked in from the Cost module 4 2 1 Key labels 4 3 The names of each asset are defined in column L As this list feeds into the Access worksheet and summarises the calculated volumes of assets it is critical that consistency is maintained The units of volume for each asset is defined in column M The category type for each asset is defined in column O This list should be only changed in conjunction with the Recon worksheet within the Cost module as these two worksheets interact to determine opex mark ups by category type As
169. oc Core worksheet The worksheet also contains calculations for the volume of duct used by the core network in the CAN which feeds into the Inputs Access worksheet 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 143 Figure 6 16 Location of the 1 Ducts Core worksheet CostAlloc in the overall Cost module Core structure Source Analysys Inputs Access 6 6 1 Key parameters This worksheet contains estimated parameters for the average number of sub ducts that are available for use and the percentage of these ducts used by the incumbent Parameter Location Impact Average number of sub ducts Cells C7 C10 Calculates the number of available ducts Number of sub ducts spare Cells D7 D10 Calculates the number of available ducts Percentage of ducts used by the Cells F7 F10 Affects allocation calculation incumbents fibre Table 6 7 Key parameters on the Ducts Core worksheet Source Analysys The cost allocations to fibre and other duct services are subsequently linked into the CostAlloc Core worksheet 6 6 2 Calculation description The following table outlines the calculations that are contained on the I Ducts Core worksheet er WM Analysys Fixed LRIC model user guide Version 2 0 144 Cell reference Description and details of spreadsheet calculations Cells C7 110 Calculation of number of ducts used by the incumbent and other services Cells K7
170. of a chassis is five slots for connectivity cards The Excel output for the calculation of the core switches is shown below 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 120 NGN Core switch Note core switches are driven by the port requirement for the services in the core network call server access gatewat domain name server core router BRAS an Call Server Access DNS Core Router Gateway Redundancy 100 100 100 100 Port cards 48 48 48 12 Type Site_ID TNS_name Core node ADELAIDE TN Core node ADELAIDE TN Core node BRISBANE TN Core node BRISBANE TN Core node Core node Core node MELBOURNE Core node MELBOURNE Core node MELBOURNE Core node PERTH TNS1 Core node PERTH TNS2 Core node SYDNEY TNS Core node SYDNEY TNS4 Core node SYDNEY TNS Figure 5 74 Calculations for NGN core switch dimensioning Source Analysys Cell reference Description and details of spreadsheet calculations Rows 497 515 Dimensioning of softswitch equipment The model further calculates the softswitch equipment which includes the following elements Equipment Dimensioning Call server signal processing the number required is calculated from BHCA with each processor being capable of processing one million BHCA There is a minimum of one call processor per main core node Access gateway gateway to IP network the number required is calculated as the total number
171. of subscribers divided by the single access gateway capacity 100 000 subscribers Table 5 23 Elements dimensioning the softswitch Source Analysys Cell reference Description and details of spreadsheet calculations Rows 520 552 Calculation of the other core network assets that are located at the TNS MTH location The core model also dimensions other core equipment at the TNS MTH Core Node location the drivers for which are shown below 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 121 Equipment Driver BRAS units Concurrent DSL subscribers RAS units Assumption of one per Core Node Radius server DSL subscribers Domain Name Server Assumption of one per Core Node Billing system PSTN Subscribers Primary Reference Clock Assumption of one per Core Node SSU equipment Assumption of one per Core Node Network Management System Assumption of one per Core Node Intelligent Network units Assumption of one per Core Node Table 5 24 Dimensioning of other core equipment Source Analysys Transmission dimensioning At the TNS Core Node level transmission links for TNS interconnect and TNS TNS traffic are calculated As per the previously documented transmission calculations the links are dimensioned by the per subscriber busy hour traffic as calculated on the Dem Calc worksheet Cell reference Description and details of spreadsheet calculations Rows 176 190 Transmission requirement
172. on NTP 100 pair building termination Fibre termination point E1 CPE radio link Outdoor unit CPE satellite link LPGS eguipment LPGS MDF Copper pillars Fibre splicing chamber Duet 28 metres Duet 24 metres Duet 20 metres Figure 6 31 Excel sample of access network assets required by geotype linked in from the CAN module Source Analysys Cell reference Description and details of spreadsheet calculations Rows 130 230 Allocation of duct and trench and fibre asset costs to the core network The dimensioning of certain core network assets has been performed in the CAN module for example transmission from the LPGS to the LE is defined as sitting within the core network as an MDF is located within the LPGS Consequently these assets need to be recovered from the core increment rather than the access increment Three sets of matrices are used to allocate a proportion of the access network costs away from the access network and into the core e The matrix in cells B139 160 calculates the overall proportion of access costs allocated to the core i e it takes the percentages derived from the following three arrays The matrix in cells B164 S185 calculates the overall proportion of access costs allocated to the core for the modern network deployment The matrix in cells B190 S211 calculates the overall proportion of access costs allocated to the core for the MSAN NGN deployment The array in
173. on The costs of the SDH assets is allocated either directly to the modelled PSTN ISDN xDSL or to other transmission the level of which is defined in the service demand matrix for the levels in the core network The split between platform and transmission costs is linked from the Inputs Core worksheet having been calculated explicitly in the Core module The figure below shows an Excel screenshot of the calculation of cost allocation of SDH assets between platforms and transmission Calculation Cost allocation SDH SDH Asset Asset Fibre Core cost Platforms Transmissi Platforms Transmissi group type type on on indez Mbitis Mbitis ATI ATI UPS 40k YA and Generator 50k va Incremental ATI ATI Air conditioning unit 10k Ya Incremental ATI ATI Ports PoC facing 10Mbit s ports Incremental ATI ATI Ports PoC facing 100Mbit s ports 9l Incremental ATI AT Ports PoC facing IGE ports NT Incremental ATI ATI Ports PoC facing 10GE ports nl Incremental ATI AT2 AT1 Fibre Incremental ATI AT2 ATL Trench Incremental ATI AT2 AT1 Duct Incremental AT2 Ports AT2 AT1 rings 1OMbit s ports 8 Incremental AT2 Ports AT2 AT1 rings 100Mbitis ports 3 Incremental AT2 Ports AT2 AT1 rings 1GE ports wl Incremental LEIATI LE PoC Fibre Incremental LEIATI LE PoC Trench Incremental LEIATI LE PoC Duct Incremental Figure 6 22 Cost allocation calculation of SDH assets between platforms and transmission Source Anal
174. oss the platforms using an EPMU mechanism cells AE219 AK219 and AE224 AK224 based on the level of incremental cost incurred by each platform The business overheads is marked up on top of the incremental shared costs Cell reference Description and details of spreadsheet calculations Rows 234 330 Service cost calculation for incremental cost incremental shared cost incremental shared business overheads cost e Column D links in the service demand for the selected year e Columns E H transposes the PSTN ISDN xDSL and Transmission platform costs by service e Column I calculates the unit cost by dividing the sum of the platform costs by the service demand The unit costs are linked in to the Results worksheet Inputs Access worksheet This worksheet links to the outputs from the CAN module It links in the required access asset deployment numbers from the CAN module The service demand data is used in the calculations of network element output on the Dem In Access worksheet The deployment numbers and calculated lifetimes are used in the annualisation calculations on the TA Access worksheet The calculations for IEN use of CAN trench uses data from the I Ducts Core worksheet and the UnitCost Access worksheets These linkages are shown in the diagram below 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 159 Figure 6 29 Location of the Inputs Access
175. ost to services cells Al20 BL219 Rows 226 425 Network element output for ISDN platform cells C226 AG425 allocation of Rows 432 631 Rows 638 837 ISDN platform cost to services cells Al226 BL425 Network element output for xDSL platform cells C432 AG631 allocation of xDSL platform cost to services cells Al432 BL631 Network element output for Transmission platform cells C638 AG837 allocation of Transmission platform cost to services cells Al638 BL837 Table 6 9 Calculations performed on the Dem In Core worksheet Source Analysys 6 8 CostAlloc Core worksheet The CostAlloc Core worksheet allocates the core network asset costs between the various platforms that use the core network It takes inputs from the Inputs Core I Building Core and I Ducts Core worksheets The cost allocations are used in the platform costing calculations performed on the TA Core worksheet These linkages are shown in the diagram below 9995 207 Analysys Fixed LRIC model user guide Version 2 0 146 Figure 6 18 Location of the CostAlloc Core worksheet in the overall CostAlloc Core Cost module structure Source Analysys TA Core f 6 8 1 Key parameters This worksheet contains key cost allocation parameters sourced from the Inputs Core LBuilding Core and I Ducts Core worksheets The only parameters which can b
176. ost xls UnitCost Access AG144 AV155 This parameter defines the distance of Increasing the parameter reduces the proportion of duct access duct and copper laid without cost of the access network It can be and cable that is incurring the cost of trench used to scenario test the impact of laid in open trench proposed trench sharing values The value can be defined by geotype and assumed to not apply to ploughed cable To change the Cost xls UnitCost Access D373 1451 The unit cost is defined for 2007 A unit Adjusting any of the unit price trends asset unit cost trend for the access network cost price trend is applied in order to calculate the asset unit costs for the years 2008 2012 These trends are will result in a different total unit cost flowing through to the TA Access worksheet for future years column assets where possible based on Australian H It will also affect the tilted annuity network data These price trends may be formula input in column E changed by a user 9905207 Analysys Annexes to Fixed LRIC model user guide A 14 Objective Workbook Worksheet Cell reference Description Impact To change the Cost xls UnitCost Access 1118 1198 The lifetime of assets controls their Adjusting the asset lifetimes will affect lifetime of access replacement cycle and more importantly the tilted annuity calculation on the network assets affects the tilted annuity calculation TA Access worksheet column G
177. output for the PSTN platform Rows 214 415 Cost per unit network element output for the ISDN platform Rows 420 621 Rows 626 827 Cost per unit network element output for the xDSL platform Cost per unit network element output for the transmission platform Table 6 13 9995 207 Calculations performed on the TA Core worksheet Source Analysys Analysys Fixed LRIC model user guide Version 2 0 155 6 12 TA Core worksheet This worksheet performs the annualisation calculation on the core network costs It subsequently calculates the service costs This worksheet contains data on volumes of equipment deployed their asset lifetimes and service demand data linked in from the Inputs Core worksheet and capex and opex parameters by asset linked in from the UnitCost Core worksheet The results of this worksheet are linked onto the Results worksheet Figure 6 28 Location of the TA Core worksheet in the overall Cost module structure CostAlloc Core RF Core Demln Core Source Analysys Asset sharing between core and Results TA Access 6 12 1 Key parameters Under a slowly evolving market scenario the tiled annuity cost annualisation methodology under which the angle of the tilt is controlled by the asset price trend is a good approximation for economic depreciation However under a rapidly changing service demand scenario an additional tilt parameter is
178. p of the worksheet rows 9 34 contains the outputs from the overlap analysis of the core and access network routes These specify the fibre sheath requirements for the core network and the trench distance required split by that within the CAN and incremental to the CAN The parent nodes parent LAS and parent TNSs have been pre calculated on the basis of the nearest LAS TNS to each LE The data relating to the PoC transmission is pasted in from an external workbook LE_LAS_ring xls The calculations for the LE PoC links are based on a minimum spanning tree calculation whilst the PoC rings are based on a multi ring travelling salesman algorithm Both of these outputs come from LE LAS ring xls The layout of the nodes data on the In Nodes worksheet is shown below LE AT1 node data Note This shect collates the outputs from the TS Note The PoC data brought in From the external workbook is used to define the parent PoC for cach LE in the NwDez 1 Access worksheet az well Note Parent LAS Note check LE list in output of TSP matches LE list here Access Tier1 Access Tier Geotgpe ParentLAS Parent PoC Distance km to parent LE site name 1 LE site PoC Note Do not change the order of LE zite names in this Trench Fibre LE remote distance distance to POC ACACIA RIDGE AARE asseu lJAARE J o oo LORDHOWEIS Lon njske kust l LErame LEM LEGeowe lf ParentiAs LE Parent Pot 91 979 257 082 LEP OR tens LEP ORE LEremoie Fol
179. parameters on each worksheet are the co ordinates and associated demand for each location The remaining items are either recorded assumptions information on the ESA or outputs from the network design algorithms The recorded assumptions are read in from the Inputs worksheet within Access CODE xls Output volumes are on a cluster basis which are then re calculated to arrive at single volumes on an ESA basis In order to modify assumptions for an ESA s and view the changes the necessary inputs must be modified in Access CODE xIs and the relevant ESA s re calculated The outputs stored are explained below The worksheet is assumed to be for ESA z in geotype y i e the worksheet ESA Gy z in Access DATA Gy xls Ee WM Analysys Fixed LRIC model user guide Version 2 0 41 For each ESA Gy z in as the list to run Location of the ESA Gy z worksheet within the overall structure of the geoanalysis and access network module Source Analysys FR 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 42 Parameter ESA data and acronyms Timings for calculation stages during last run Capacity inputs and distance constraints Other inputs used in the last calculation Final total volumes for ESA Duct combinations Proxy cost functions Sheath by cable size within DP pillar clusters and in the urban distribution network Total demand served by each final
180. parate worksheets The modelling follows the scorched node principle the current locations of each of the main network nodes LE LAS TNS is retained although the equipment modelled at each node location is efficiently determined by the busy hour traffic carried on the network The calculations are performed on a node by node basis in order to take into account equipment and transmission thresholds at each point in the network The remainder of this section is set out as follows e Section 5 1 outlines the C V and S worksheets e Section 5 2 outlines the In Control worksheet e Section 5 3 outlines the key parameters and calculations in the In Demand worksheet e Section 5 4 outlines the key parameters and calculations in the In Subs worksheet e Section 5 5 outlines the key parameters and calculations in the Dem Calc worksheet e Section 5 6 outlines the key parameters and calculations in the In Nodes worksheet e Section 5 7 outlines the key parameters and calculations in the Input LAS distances worksheet e Section 5 8 outlines the key parameters and calculations in the Input TNS Gravity worksheet e Section 5 9 outlines the key parameters and calculations in the In Network worksheet e Section 5 10 outlines the key parameters and calculations in the NwDes 1 Access worksheet this worksheet contains the asset and transmission calculations for both the modern LE level an
181. r example PSTN local traffic may be switched by only one LAS or may be switched by two LAS or may indeed involve switching at the transit layer The proportion of traffic utilising a specific route is inserted into the cells outlined in blue in the screenshot above The proportion of calls that utilise a particular combination of network assets is used to ascertain the average routeing factors for that particular type of traffic An example of this calculation is shown in the figure below x LE LAS LAS LAS LAS TNS TNS TNS LAS Interconnect TNS Interconnect CPE gt gt LE gt gt LAS gt gt LE gt gt CPE __ CPE gt gt LE gt gt LAS gt gt LAS gt gt LE gt gt CPE CPE gt gt LE gt gt LAS gt gt TNS gt gt LAS gt gt LE gt gt CPE Se EE CPE gt gt LE gt gt LAS gt gt TNS gt gt TNS gt gt LAS gt gt LE gt gt CPE SEE ee Figure 5 17 Excel screenshot displaying sample of calculations to determine the proportion of traffic utilising a specific network route Source Analysys For ISDN voice traffic the model currently assumes all traffic routes via TNS locations Several call routing options are set up to accommodate the different call types on net local on net national off net domestic off net international as unlike PSTN only one service is defined to capture all ISDN call types The figure below shows this calculation with the adjustable parameters outlined in green and blue input boxes ISDN voice traffic CPE gt gt LE
182. r to affecting the H186 H187 demand The user may change these carry the busy hour demand actual capacity of H191 H192 H196 equipment utilisation levels in order to modelled These asset requirements this equipment H204 H211 H227 change the actual capacity of eguipment are calculated on the NwDes deployed in the core network worksheets To change the Core xls In Network G45 xDSL backhaul is provisioned on a per Increasing payload per rack increases xDSL backhaul rack basis defining the number of E1 the size of the LE backhaul provisioned payload equivalents available per rack increasing cost but leading to relative modern network Default assumption is an E3 per rack 14 economies of scale across the network E1 s To change the Core xls In Network H77 xDSL backhaul for MSANs are Increasing backhaul provisioned per xDSL backhaul provisioned next generation network provisioned on a per subscriber basis subscriber increases the size of the AT2 AT1 and upstream backhaul increasing cost but leading to relative economies of scale across the network 9995 207 Analysys Annexes to Fixed LRIC model user guide A 10 AT Cost modelling changes allocation Objective Workbook Worksheet Cell reference Description Impact To change the Cost xls Building Core D8 010 This set of inputs defines the building Adjusting the sizes of the platform allocation of space taken up by platform equipment i
183. re distances from the In Node worksheet these distances are based on minimum spanning tree distances e Columns E I calculate the number of fibres dimensioned including an allowance for spares and other fibre services A fibre bundle size is calculated e Columns J K calculate the resultant distance of fibre for SDH and fibre for other services in metres this is used in the cost allocation ion the Cost module e Column L calculates the regenerator requirement based on the maximum distance of a fibre link before signal regeneration is required cell L15804 Rows 21063 21067 Calculation of the incremental trench outside of the CAN area and the distance in the CAN area that may be utilised by core network ducts Rows 21063 21071 Calculation of the fibre sheath length by bundle size and the trench requirements according to the route sharing inputs from the In Nodes worksheet Rows 21077 21138 Summary table for the Access Tier 1 node equipment requirements Table 5 15 Calculations performed on the NwDes 1 Access worksheet Source Analysys Equipment requirements Cell reference Description and details of spreadsheet calculations Rows 13 5268 Calculation of TDM based equipment requirements e Column D identifies whether the LE is served by TDM equipment e Columns E G link in the PSTN amp WLR ISDN BR and ISDN PR SIO data from the In Subs worksheet e Columns H K calculate the PSTN and ISDN line card
184. re that data on this worksheet linked in from elsewhere in the CAN module is not over written 4 5 Access worksheet The Access worksheet use the parameters from the offline modules to extrapolate volumes for all access network assets The extrapolation needs to reflect the choice of access technologies in the offline module fibre copper wireless satellite and changes in demand over time Extrapolations are performed by geotype Es WM Analysys 4 5 1 Key parameters Fixed LRIC model user guide Version 2 0 54 No parameters are stored on this worksheet All parameters are taken from the List In Demand and In Access worksheets 4 5 2 Calculation description Calculations on the Access worksheet are summarised in the table below Assets are calculate for the current modelled year Cell reference Description and details of soreadsheet calculations Rows 7 29 Number of SIOs and locations by both technology and by geotype This is driven by the number of SIOs in the year and parameters from the geoanalysis Rows 34 40 Number of exchange areas and those that are wireless and satellite only Exchange areas account for ESAs with multiple copper centres Rows 43 64 Number of copper clusters and whether they are served by the pillar at the LE by other pillars or by LPGS The number of LPGS by backhaul technology fibre wireless satellite is also calculated Rows 66 102 Num
185. reference Description and details of spreadsheet calculations Rows 258 303 9995 207 Proxy cost function coefficients Analysys Fixed LRIC model user guide Version 2 0 27 Proxy cost function coefficients URBAN deployment Within DP clusters Proxy cost function is of the form kdeks eeks doek dle where dis the length of the link and c is the total number of pairs in the lir URBAN ks Po ene within Rave ks ke P esha within PR areak ks Pd een within IR aveak ke 0 eee hn within areas RURAL deployment Within pillar clusters Proxy cost function is of the form k dek eeks doek dle where dis the length of the link and cis the total number of pairs in the lir Fully tapered Primarily non tapered k ee REK E Biase within pilar area kz pT ede within priter avert ks po 00 SoA withing creak ke Po ee A within pian arent URBAN deplogment DP pillar connections Proxy cost function is of the Form ky dekz c ks d c ky d e where dis the length of the link and c is the total number of pairs in the lir Fully tapered Primarily non tapered ks Pt O AA k P ee tank ks Poot etn pita 2 ke NE a Pillar RAU connections Proxy cost function is of the form kdeks eeks doek dle where dis the length of the link and c is the total number of pairs in the lir ka EEN ae ks P px heptane ks HG ke EEN EEN Node node connections for constructing a fibre ring Proxy cost function for determining the full me
186. rence Description and details of spreadsheet calculations Rows 3 10 Check that the traffic totals reconcile Rows 15 148 Subscriber numbers at each LAS Rows 157 290 LAS unit switchblock and processor requirement Rows 299 432 NGN trunk gateway dimensioning Rows 441 574 NGN edge switch dimensioning Rows 583 716 NGN edge router dimensioning Rows 721 738 Transmission demand requirements Rows 743 881 Transmission requirement for LAS LAS links Rows 888 1021 Transmission requirement for LAS TNS LTH MTH links Rows 1023 1162 Transmission requirement for LAS Interconnection links Rows 1173 1966 LAS ring structure calculations including the capacity calculations for the physical ring dimensioning and the fibre trench and duct distance calculations LAS rings are grouped by major urban area Perth Adelaide Melbourne Canberra Sydney and Brisbane Rows 1973 2036 Summary of the equipment units deployed at the LAS level according to demand Table 5 20 Calculations performed on the NwDes 3 Reg Nodes worksheet Source Analysys 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 102 Equipment dimensioning Cell reference Description and details of spreadsheet calculations Rows 157 290 LAS unit switchblock and processor requirement The Excel output of the modern network LAS unit equipment dimensioning is shown below LAS traffic LAS units BH Erlangs BH Call based on based on processor capacit
187. requirement taking into account utilisation e Columns L M calculate the shelf and rack requirement for PSTN and ISDN services assumption that PSTN and ISDN services are connected on the same equipment The methodology for the calculation of equipment requirements for PSTN and ISDN is shown in the figure below 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 89 Number of line Number of Number of racks shelves required cards required required Figure 5 32 Calculation of the number of PSTN and ISDN line cards shelves and racks required Source Analysys Line cards are dimensioned on the basis of the number of services in operation at the node and the capacity of a line card Shelves are calculated on the basis of the dimensioned number of line cards and the maximum capacity of a shelf in terms of line cards The number of required shelves dimensions the number of racks required on the basis of a maximum capacity of shelves per rack The Excel output of these calculations are shown below TDM based equipment required in areas not served using MSAN equipment PSTN and ISDN requirements Available ports per line card Available Available PSTN amp WLR ISDN ER ISDN PR line cards shelves per 46 23 15 4 3 Copper PSTN SIOs Line cards required taking into account utilisation Shelves Racks Access Tier Geotspe ServedbyTDM PSTN amp WLR ISON BR ISDMPR PSTN amp WLR ISDN BR ISDN PR Total 1 LE site i
188. rformed These measures are used to derive geo demographic and technical inputs for the CAN module The following table outlines the calculations that take place on the Summary worksheet 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 33 Cell reference Description and details of spreadsheet calculations Rows 21 239 Summary of volumes for each calculated ESA Rows 243 264 Summary of volumes by geotype and then by band Rows 282 286 Demand density by geotype Rows 289 292 Access technology by geotype Rows 296 301 Wired connections by geotype Rows 305 458 Assets by geotype Table 2 6 Calculations performed on the Summary worksheet Source Analysys Summary of volumes for each calculated ESA Cell reference Description and details of spreadsheet calculations Rows 21 239 Summary of volumes for each calculated ESA Analysys Summary of ESAs sampled Indez of ESAs sampled for the model Index must be consecutive numbers starting from 1 Geotypes must be in ascending numerical order The index in ESA in geotype must be in ascending order for each geotype starting from 1 and increasing consecutively The data for the ESA which is in the j th ESA in geotype k must ligjin the workbook Access DATA Gk xls in worksheet ESA Gkj This worksheet This workbook Full path for this workbook O WPIXACIOO Results non tapered 080530 4ccess CODE xls Summary Extra characters 2 and
189. rings Note this iz built for 1500 rows POC Name LAS Ring Number Of Is aLAS Bridging Dist To Ring Joined Isin LAS POCs in Node Next Node To Ring ADLE 1 ADLJ 1 3 Y 5 1 ADLE 2 ADLJ 1 3 28 iy MPLE ADLJ 1 3 24 iY GYRA ADLJ 2 3 54 1N GNIS ADLJ 2 3 77 1N ASHD ADLJ 2 3 85 1N CRBL ADLJ 2 3 105 1N INLL ADLJ 2 3 34 1N DISP ADLJ 2 3 86 1N ADLE 2 ADLJ 2 3 Y 28 1 N NRWD AFTA 3 4 4 3 Figure 5 41 Excel screenshot showing sample of the calculation of transmission at each point on the PoC LAS rings Source Analysys Transmission at a PoC is calculated on the basis of TDM Els and Ethernet kbit s required on a particular ring Each point on the ring is required to be able to handle the whole capacity of the ring i e each node on the ring is set at the same speed The calculation of the required capacity takes place in columns L S as shown below Transmission required at each point on the PoC Regional Node LAS rings Note this is built for 1500 rows TDM transmission E1s NGA transmission kbps POC Name LAS PoC demand EwcludingLAS Excluding Ring demand PoC demand EwcludingLAS Excluding Ring demand ADLE 1 ADLJ ADLE 2 ADLY MPLE ADLY GYRA ADLJ GNIS ADLJ ASHD ADLJ CRBL ADLJ INLL ADLJ DISP ADLJ ADLE 2 ADLJ NAWD AFTA FLNF AFTA Figure 5 42 Excel screenshot showing sample of the calculation of transmission at each point on the PoC LAS rings Source Analysys It should be noted that the PoC ring algorithm enables the deployment of
190. rs i e it is assumed that this difference is not material If an LPGS served by wireless require more than this number of relay stations in the link then the LPGS is served by satellite The backhaul requirements at each wireless node is derived from the demand at each location A location with one unit of demand uses the residential value of backhaul capacity otherwise the demand is multiplied by the business value of backhaul capacity This is the minimum demand 20 units that we assume a pillar is ever deployed to serve At certain points in the copper wireless decision copper clusters which are smaller than this level of demand are converted to wireless This input is also used in the URBAN deployment clusters that serve less than this demand can be merged with the nearest pillar cluster regardless of the distance constraint DAnalysys Fixed LRIC model user guide Version 2 0 26 Cell reference Rows 236 249 Description and details of spreadsheet calculations Other data by geotype These selections determine whether the deployment for a geotype e is URBAN or RURAL e uses rings or a point to point topology to deploy fibre to high demand location e uses a fully tapered or partially non tapered distribution network to connect DPs resp locations to the pillar in URBAN resp RURAL deployments Other Geotgpe 1 2 3 4 5 6 tf 8 3 10 1 12 13 4 Figure 2 22 Calculation branch URBAN
191. s worksheet are set out in the remainder of this sub section This worksheet uses as its inputs e the number of PSTN and WLR lines parented by each TNS this is linked in from the In Subs worksheet Cell reference Description and details of spreadsheet calculations Rows 10 24 PSTN SIOs parented by each TNS Note each SIO is parented by two TNSs for resilience purposes in the network 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 81 SIOs at each PSTN amp WLR Figure 5 26 TNS subs The number of SIOs AFTA 1 100 898 AWTA 875 186 at each TNS BWTB 1 565 144 Source Analysys BCTB 1 684 732 CCTA 306 651 CDTA 586 736 MLTB 2 305 912 MWTB 1 275 060 METC 1 427 177 PPTA 1 059 080 PWTA 930 573 SKTB 1 167 897 SCTC 1 528 349 SPTF 2 143 780 e the road length distance between each TNS location Cell reference Description and details of spreadsheet calculations Rows 28 41 Road length distance matrix to and from each TNS Road length distances km Note road length distances have been calculated using MapInfo and StreetPro Australia AFTA AWTA BWTB BCTB CCTA CDTA AFTA TT 599F 1599 ST 954 AWTA BWTB BCTB gesl ao S aal w CCTA CDTA MLTB MWTB METC PPTA PWTA SKTB SCTC SPTF 1 143 1 144 730 236 242 Figure 5 27 Excel screenshot showing sample of parameters used to determine the road length distance in km between TNSs Source Analysys Cell ref
192. s H N calculate the SDH transmission links required in order to carry the calculated PoC LAS TDM based traffic Ethernet over SDH traffic e Columns O R calculate the Ethernet transmission link speeds required in order to carry the calculated PoC LAS Ethernet traffic e Columns S Z calculate the fibre bundle size and distance of fibre for SDH and other fibre services deployed in the network this data is used in the cost allocation in the Costing module 2025 S2029 Calculation of the incremental trench outside of the CAN area and the distance in the CAN area that may be utilised by core network ducts X2025 Y 2033 Calculation of the fibre sheath length by bundle size and the trench requirements according to the route sharing inputs from the In Nodes worksheet Rows 2039 2079 Summary of the equipment units deployed at the PoC level according to demand Table 5 18 Calculations performed on the NwDes 2 PoCs worksheet Source Analysys 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 98 The remainder of this section details the specific calculations that take place on the NwDes 2 PoC worksheet The calculation of the transmission at each point on the PoC rings is informed by a number of parameter values derived from the In Node worksheet This information is linked from columns B J of that worksheet This is shown below Transmission required at each point onthe PoC Regional Node LAS
193. s SDH AUD Dark fibre AUD LE AUD PoC ring AUD LAS ring AUD TNS ring AUD Figure 6 8 Excel sample of inputs for trench allocation costs Source Analysys Cell reference Description and details of spreadsheet calculations Rows 334 337 Fibre cost allocations Similarly the fibre allocation costs are linked from the Core module for the LE PoC ring LAS ring and TNS ring levels er WM Analysys Fixed LRIC model user guide Version 2 0 139 Fibre allocation costs Units LE PoC ring LAS ring TNS ring Figure 6 9 Excel sample of inputs for fibre allocation costs Source Analysys Cell reference Description and details of spreadsheet calculations Rows 345 409 Routeing factors for the modern and NGN networks The routeing factor matrices for the modern and NGN architectures are linked from the Core module Routeing factors Transmission Platform PSTN Units BHE Services LAS LAS Link element PSTN End User Access PSTN local traffic onnet traffic PSTN national long distance traffic onnet calls PSTN outgoing traffic to international destinations PSTN outgoing to mobile traffic mobile terminating PSTN terminating traffic from international mobile other domestic fixed networks Local carriage service LCS ISDN BRI access ISDN PRI access Service 10 ISDN voice traffic Unconditioned local loop service ULLS Line sharing service LSS Wholesale line rental WLR Fi
194. s24aa48 2 1186 8 Copper DP 10 27967033 6ls2g28io 2zss7234 63280520 8 77 2 Copper oP uy 27965262 6132527 45 __ 279684 29 613252977 3 nes 10 Copper DP 12 __279705 89 613243028 27966746 613242873 Tt 1230 8 Copper DP 83 1234 2 Copper DP u zanos eizsre7e 2rsestril 61237722 2 1210 8 Copper FOP 527970895 __6192893 85 27983083 613238229 2 1216 8 Copper FOP 16 27368973 613246638 27968732 613249600 6 1220 8 Copper DP w arsmitas 613236505 27969287 613236350 2 1198 8 Copper OP te 2rsee2sol eisargaaal 2resseiel Eiwasrtrel al 1235 2 Copper DP sO zame etsasaa7sl 27969466 erzas2z2e 2 1192 2 Copper FDP 20 100 2 Copper DP 21 279707 48 __6132576 28 27969325 613257505 2 1518 10 Copper DP 22 68 2 Copper FOP 23 s1 27 Copper FOP 24 842 27 Copper oP 25 27363410 613203220 27972320 613203468 2 eet 27 Copper oP Figure 3 5 Excel co ordinates in AMG Source Analysys Outputs from the last calculation Cell reference Description and details of spreadsheet calculations Cells M37 AY286 Assets volume by pillar The asset volumes are listed individually for each pillar or equivalent cluster e g BTS LPGS within the ESA with the type of each such cluster clearly labelled Certain measures cannot be split by cluster and their totals are printed directly into Row 35 For example the incremental trench between the pillars and the RAU may be used by the links for several pillars so it cannot be at
195. se ESAs are not included within the sample of ESAs processed by the network design algorithms The 15th geotype contains ESAs we assume are served by satellite whilst the 16th geotype contains ESAs with neither location data nor demand at all The labels here are those relevant to the sampled ESAs 9995 207 DAnalysys Fixed LRIC model user guide Version 2 0 9 It is not expected that the number of geotypes to be analysed will be increased Geotype geotypes Figure 2 2 Excel parameters for geotype names Source Analysys Cell reference Description and details of spreadsheet calculations Rows 23 26 Methodology to use when calculating for an ESA These are the two labels currently used for the deployment algorithms within the model URBAN denotes a copper and fibre CAN and is intended for at least all of Bands 1 and 2 whereas RURAL can also deploy wireless and satellite within an ESA Methodology to use when calculating for an ESA URBAN RURAL num ESA methodologies Figure 2 3 Excel parameters for methodology to use when performing calculation for an ESA Source Analysys Cell reference Description and details of spreadsheet calculations Rows 30 32 Nature of fibre connections These are the labels used to denote the three different means of deploying fibre within an ESA The first two options cause all respectively some pillars to be joined together in a fibre ring with
196. sets are given a category type in column K It should be noted that a data validation check has been implemented on these inputs In Demand worksheet This worksheet performs five main functions ani WM Analysys Fixed LRIC model user guide Version 2 0 51 e stores data from the geoanalysis e scales the number of locations based on known data regarding the services in operation SIO distribution e links in demand by geotype from the Core module e captures the geoanalysis of the various distances from the NTP to the serving pits e Calculates the length of trench for distribution points to the property boundary 4 3 1 Key parameters The specific locations for each of the line types is outlined below Location Description Rows 10 25 Captures the location data by geotype specifically e Identified locations from the Location and Demand Database e Locations in the sampled ESAs e Count of ESAs e Count of copper centres e Count of subdivided ESAs where multiple or no copper centres exist e Measured road distance based on the processed StreetPro data Rows 29 30 The total number of SIOs used to dimension the CAN is linked in from the Cost module Rows 30 50 The total number of SIOs used to dimension the CAN is distributed by geotype The forecast ULLS and LSS SIOs by geotype are linked in from the core module Cells E58 H73 Captures distances from the geoanalysis specifically e Average distance GN
197. sh of pillar pillar linkages is of the form kI dek2 c k3 d c k4 d c where dis the lengtl Proxy cost function for determining the manner in which the pillars link together in the actual fibre ring is of the form ky Dryeks De whe ky EE EF kz PO Feat pita ks onfa pilar poise RE ke a BTS BTS connections Cost function for identifying a wireless backhaul link for copper fed areas is of the form kI dek2 Mek3 n where nis the number of relay stations required for the link and Mis the cost multiplier for the relevant capacity needed PURRETRETER PURIRETEETERE PUSRETEETERG Figure 2 23 Excel proxy cost function coefficients Source Analysys These proxy cost functions are used in the minimum spanning tree algorithms to determine the linkages between locations in copper fibre and wireless networks For the wireline cases separately calibrated functions are used to build the trench and cable networks e within urban DP clusters e within rural pillar clusters e between urban DPs and their parent pillar e between pillars and their parent RAU e between pillars on a fibre ring 9995 207 ID Analysys Fixed LRIC model user guide Version 2 0 28 There is also a function to construct the wireless backhaul network wireless LPGS and BTS back to the RAU in the RURAL deployment Currently the copper functions have a fourth term using the square root of the capacity although it is always set to be zero Figure 2 24 Form of pro
198. sioning Source Analysys 5 11 NwDes 2 PoC worksheet The NwDes 2 PoC worksheet calculates the dimensioning of the PoC nodes aggregator LEs AT 1s on the basis of the services in operation that are hosted at each individual node and the busy hour demand that needs to be carried on the transmission links Allowance is made for other transmission traffic spares and fibre for other services This worksheet aggregates data from an external file detailing the mapping from local exchanges to PoCs and the distance between each local exchange and its parent PoC This is used to calculate the most efficient way to link PoC rings to the parent LAS The number of assets calculated on this worksheet are output to the Out Assets worksheet These linkages are shown in the diagram below er WM Analysys Fixed LRIC model user guide Version 2 0 95 Figure 5 40 Location of the NwDes 2 PoC worksheet in the overall Core Network design module structure Source algorithms Analysys 5 11 1 Key parameters No parameter values are inserted manually into this worksheet but numerous key parameter values linked in from the network parameters worksheet The utilisation parameters linked from the In Network worksheet are the key parameters that can be changed 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 96 Parameter Location Impact Link utilisation parameter F1518 F151
199. smission equipment and SDH where demand is lower Alternative is just SDH To force the In Control C8 This parameter is use to force the Forcing IP core equipment results in deployment of an deployment of IP equipment in the core the NGN IP core equipment being IP core structure network In the base case it should not deployed as opposed to the TDM be implemented based equipment To change the In Network H31 H33 Each network equipment asset in the Changing the network equipment core network H36 H41 core network has an associated capacity capacities will result in a different equipment H46 H48 These capacities are based where number of assets required in order to capacities H51 H66 H71 possible on Australian specific data carry the busy hour demand H184 H185 sourced from operators The user may modelled These asset requirements H189 H190 H195 wish to changes these capacities are calculated on the five NwDes H199 H201 worksheets H205 H206 H212 H214 H217 H219 H226 H233 H248 DAnalysys Annexes to Fixed LRIC model user guide A 9 Objective Workbook Worksheet Cell reference Description Impact To change the Core xls In Network H58 H60 H73 H75 The network equipment may not be fully Changing the network equipment utilisation on H128 H141 H155 utilised for example to allow for spare capacities will result in a different equipment H164 H169 capacity when there are spikes in number of assets required in orde
200. ss Distance function Rows 324 355 These coefficients determine a street distance function for each geotype in the geoanalysis and access network module The coefficients for straight line Euclidean distance are also included within the model as the default distance measure Wherever a distance measure is used in the subroutines it will always use exactly one of these two options Trench sharing coefficient Rows 361 374 In order to capture trench sharing within the model all aggregated totals of trench within the model are scaled by this coefficient which can vary by geotype Table 2 3 Key parameters on the Inputs worksheet Source Analysys 2 2 2 Description of parameters and associated calculations There are few calculations within this worksheet The most important are those in rows 180 193 which determine the capacity constraints for DP clusters and pillar clusters The DP cluster capacity uses the utilisation assumption for a DP The pillar cluster capacity is driven by the e number of pairs 900 that a pillar can accommodate e utilisation factor for the pillar e number of pairs back from the pillar to the RAU the capacity cannot exceed this value The following table outlines the parameters and calculations that lie on the Inputs worksheet which are discussed in more detail below Cell reference Description and details of spreadsheet calculations Rows 3 7 ESAs to process 9995 207 ID An
201. sys The above parameters determine the assumed utilisation level of sky WM Analysys Fixed LRIC model user guide Version 2 0 16 e DPs e pillars e distribution network cabling The first two are used in the capacity calculations for DPs and pillars see Inputs by geotype section below These inputs are not read into the Visual Basic directly it is the outputs of the calculations that are read in and used by the clustering subroutines in the deployment algorithm The utilisation of the distribution network cabling is read into the algorithms This is used both when this part of the network is assumed to be tapered and non tapered Specifically this cabling joins demand back to its parent pillar LPGS RAU and is dimensioned on the basis of downstream demand i e how much demand passes through the link en route back to the node The utilisation factor defines the minimum level of spare capacity in this cabling Suppose for example that the network was fully non tapered only used 100 pair cable and assumed 100 utilisation of that cable Then wherever the downstream demand was 100 or less one 100 pair cable would be deployed If the downstream capacity was exactly 100 then there would be no spare capacity dimensioned in that part of the network A utilisation factor of 80 would increase the cabling to two 100 pair sheaths as soon as the downstream demand exceeded 80 Cell reference Description and de
202. t fibre rings are deployed in Band 1 geotypes 1 and 2 Main fibre cable This defines the different fibre bundle sizes that can be used on a the fibre sizes employed ring The cables deployed for the fibre ring are chosen from this list of options and dimensioned on the number of fibres per location see Inputs by geotype Cell reference Description and details of soreadsheet calculations Rows 155 166 Backhaul basic inputs Rows 169 172 Satellite basic inputs Backhaul Maximum distance of a microwave Source Analysys assumption metres PWVESS man RAICES Maximum distance in which cable c Source Data available from the metres 800 ax cate pull through distance RE pillar without jointing Maximum distance in which cable c Source Data available from the metres 50 S mancatve pull through distance pila FALL without jointing Maximum distance between manhe Source Data available From the metres 250 man distance RNAS YH SORIA TIBIAE Cost multiplier Wireless backhaul options Source OPTA BULRIC model kbit s 1 Source OPTA BULRIC model kbit s Source OPTA BULRIC model kbi s Satellite Capital expenditures Source Forward Looking Technologies For The USO 2000 2003 byQ_ 1 200 Cost of CPE Source Forward Looking Technologies For The USO 2000 2003 by 4 00 Cost of CPE installation Source Forward Looking Technologies For The USO 2000 2003 by 3 000 Total cost 8 300 satelite OCS perdocation Figure 2 17 Excel inputs to determine backh
203. t xls Results Pasted The model has a macro to generate Results for each of the modelled results over time results for each of the modelled years years 2007 2012 are output for These results are generated by simply each of the modelled services The clicking the Paste results button at the check box in cell L1 should read top of the stated worksheet Results up to date when this process has been completed Further adjustments in the model will require that this macro be re run 9995 207 WM Analysys Annexes to Fixed LRIC model user guide B 1 Annex B LE PoC minimum spanning tree and travelling B 1 B 2 salesman algorithm This section outlines the calculations that take place in the LE_LAS_ring xls Excel workbook This workbook e clusters the LEs into PoC clusters parented by a single PoC location e identifies the parent LAS to each PoC e determines the minimum spanning tree for the LE PoC transmission e determines the appropriate multi ring structure for the PoC LAS transmission This workbook contains macros which are controlled by clickable buttons on the appropriate worksheets Input Parameters worksheet This worksheet contains a number of key parameters which set up the clustering and ring generation algorithms Cell reference Description and details of spreadsheet calculations Cell D6 Maximum local exchanges per PoC Cell D7 Automatically assign as a PoC if number of SIOs excee
204. table lists the locations of every DP for ESAs processed with an urban deployment For the rural deployment every point that is served by copper is printed In both cases the derivation of the pit type deployed at the point is printed in stages Data on DP clusters Pit manhole calculations Node indez Cluster DPz DPy Point Number of vertices Capacities in Ducts out Mazin Count of links Pit basedon Pit based Final pit RAU pillar LPGS indez coord coord representing DP in cluster cluster of node one link in to node most ducts on links size A pillar will bs RE AistnodesarESA Mt ste KRP AE sist oluster cente pa MUN veroes ERA Gi Met cluster capacnee Sistduetsint Sistmesdy Ststaumsdnksintan Sist pithy Vers ER Bist pitindink sist Spal pit 3 1 279413 6129965 45 1 2 1 1 1P5 PS PS 3 2 279587 6130555 4 2 4 3 2 2 P5 P5 PE 2 3 279524 6133710 2 1 2 1 1 1P5 PS PS 23 4 280379 6133413 1831 1 2 1 1 1P5 P5 P5 16 5 280684 6133245 2206 1 3 1 1 1P5 P5 P5 25 6 28154 6131487 2997 1 2 1 1 1P5 P5 P5 22 7 28011 6133223 971 2 4 2 1 2 PS PS PS 7 8 280934 6133014 2906 1 2 1 1 1P5 PS PS 22 9 280146 6133190 1465 1 2 1 1 1P5 P5 PS 22 10 280146 6133190 1467 1 20 3 1 3 P6 P P6 7 1 280863 6133007 2848 1 3 2 1 2 P5 P5 P5 3 12 279795 6131370 m 1 3 2 1 2 P5 P5 PS 25 13 281017 6131579 2955 2 4 4 2 3 P6 P6 PE 25 14 280957 6131534 2301 2 4 3 5 2 P9 P5 PF12 25 15 280960 6131498 2885 2 4 3 5 2 P9 PS PF12 25 16 281018 6131562 2954 1 3 1 1 1P5 PS PS 25 17 280918 6131467 2843 1
205. tails of spreadsheet calculations Rows 17 18 DP basic inputs DP definitions OP capacity Source Analysys assumption N N Maximum distance between pits Source Data available from the metres man distance between Note only implemented in the urban deployment Figure 2 10 Excel parameters for distribution points Source Analysys There are two parameters associated with DPs as shown above DP capacity This defines the maximum demand accommodated by a DP cluster which can serve one or more locations by connecting to final distribution points FDPs The maximum capacity is multiplied by the utilisation defined above in rows 180 193 to determine the practical capacity see below for further details It is only used in the URBAN deployment A DP can serve individual locations with copper demand higher than this capacity Maximum distance If a single DP DP trench link exceeds this defined distance then an between pits additional pit will be deployed It is only used in the URBAN deployment These additional DPs for an ESA are recorded in the DATA workbooks a WM Analysys Fixed LRIC model user guide Version 2 0 17 files under the column Extra DPs required along trench within pillars Cell reference Description and details of soreadsheet calculations Rows 21 52 Pit and manhole definitions Pit amp manhole definitions Source Data available from the Types of pit Define possible duct combinations and assoc
206. tances used in the minimum spanning tree calculations This information is linked to the NwDes 1 Access worksheet in cells C10538 D15791 and C15806 D21059 The data regarding the specific PoC rings is linked to the NwDes 2 PoC worksheet in cells B13 J1512 The parent PoC LAS TNS data is used in the calculation of the appropriate number of lines at the PoC LAS TNS level on the In Subs worksheet These linkages are shown in the dia gram below 9995 207 Network design algorithms NwDes 1 Access l NwDes 3 4 i Reg Nodes NwDes 5 slands Figure 5 20 Location of the In Nodes worksheet in the overall Core module structure Source Analysys DAnalysys Fixed LRIC model user guide Version 2 0 75 5 6 1 Key parameters This worksheet contains contains data pasted in from an external workbook LE LAS ring xls In this external workbook there are several important parameters which control PoC ring generation Parameter Impact Clustering To PoCs Maximum Local Exchanges per PoC Controls the cluster number of LEs into PoCs Automatically assign as a PoC if number of SIOs Designates an LE as a PoC if it has more SIOs than the exceeds 3000 defined threshold number Trench cost per metre Controls the minimum spanning tree shape based ona Fibre cost per metre least cost function between trench and fibre costs Generating Rings algorithm parameters Maximum number of PoCs
207. ted before export to the Out Assets worksheet The Excel output of which is shown below 9995 207 WM Analysys 5 14 9995 207 Fixed LRIC model user guide Version 2 0 125 TNS Core node summary Note These asset numbers are output to the Out Assets worksheet Asset Units Number deployed Modern network assets TNS MTH building Site acquistic STP Signalling Transfer Point UPS 100kVA and Generator 10 Air conditioning unit 100kVA ADM TNS ring SDH add drop mt ADM TNS ring SDH add drop m ADM TNS ring SDH add drop mt ADM TNS ring SDH add drop mt Ports Interconnection facing SD Ports Interconnection facing SD Ports Interconnection facing SD Ports Interconnection facing SD Required assets TNS site Required assets TNS STP Required assets TNS UPS Generator Required assets TNS Acunit __ Required assets TNS ring ADM STM1 s _ Required assets TNS ring ADM STM4 Required assets TNS ring ADM STM16 70 Reguired asset Note at the TNS level only STM 64 ADMs are considered Required assets TNS Interconnection ports STM1 Required assets TNS Interconnection ports STM4 Required assets TNS Interconnection ports STM16 Required assets TNS Interconnection ports STM64 ISDN platform Required assets MTH ISDN platform ATM platform Required assets MTH ATM platform Other platforms Required assets MTH Other platform Tandem Switch Processor
208. the In Access worksheet Changes to these parameters will affect the dimensioning of the access network and the corresponding number of assets required Defining final drop CAN xls distances In Access E58 V76 Current values can be reviewed and updated to define the e lengths of the NTP gt gt PB links PB gt gt S P links and road crossings for the copper lead in and associated trench Defines the distances for the final drop of the CAN To change the Cost xls distance uplift factor in the access model for slope effects Scenario C21 Access network distances may be affected by slope a parameter in the model is used to accommodate this The user may change this percentage uplift Increasing the uplift factor directly increases the trench cable and fibre distances deployed in the access network in the CAN xIs workbook 9995 207 Analysys Annexes to Fixed LRIC model user guide A 5 AA Core network traffic loading Objective Workbook Worksheet Cell reference Description Impact To change the Core xls In Network H12 H13 The model uses several parameters in Changing these percentages affects volume of busy H18 H23 order to convert the annual traffic load the busy hour load calculation that hour traffic loading into a busy hour traffic load which takes place on the Dem Calc on the core dimensions the core network The user worksheet cells M25 N54 M59 N88 network may cha
209. the RURAL deployment These are the component costs assumed for serving a single location with satellite in the RURAL deployment Decreasing the these costs makes it more likely for a wireless cluster to be served by satellite These allow the copper clustering constraints to be varied on a geotype basis and affect the number of DPs and pillars DAnalysys Fixed LRIC model user guide Version 2 0 14 Parameter Location Impact deployed in an ESA The cable size to link pillars back to the RAU is also included here Fibre inputs by geotype Rows 198 211 These determine the fibre lengths deployed in an ESA given the number of fibres included within each cable Copper versus wireless Rows 218 231 These are used for a cost based decision in the RURAL decision data by geotype deployment as to whether locations are served by copper of wireless Changing these inputs will affect the balance of locations served by copper and wireless within the ESA Other data by geotype Rows 236 249 These drop down boxes allow the user to specify the deployment methodologies on a geotype basis Proxy cost function Rows 258 303 These are used in the minimum spanning tree algorithms to coefficients determine the copper and wireless backhaul networks Changing these may give rise to sub optimal trench and cable networks Cost function coefficients Rows 309 317 These allow a cost comparison for linking an LPGS to its RAU by either fibre or wirele
210. the islands that reguire a special network solution The table below lists specific data inputs and calculations by row number Cell reference Description and details of spreadsheet calculations Rows 4 9 Network parameters specific to the calculations for the island solutions Rows 16 77 Calculations of subscriber traffic and transmission for each of the islands that require a special network solution Rows 85 120 Summary of the equipment units deployed for the special island solutions Table 5 25 Calculations performed on the NwDes 5 Islands worksheet Source Analysys For each of the islands not connected to the mainland by means of a bridge an alternative backhaul solution is defined column F The upstream ESA which is connected to needs to be defined so that the transmission capacity required for the off island link is calculated correctly considering subtended ESAs The distances derived from the minimum spanning tree calculation of the LE PoC links which was calculated on the NwDes 1 Access sheet is calculated for each of the island s LEs These distances are subsequently subtracted from the total LE PoC distances calculated For the microwave solutions microwave hop towers are required according to the distance constraint of microwave links The number of microwave hops is calculated according to the trench distance which it replaces For the satellite solutions an earth station is required according to
211. the probability that a call is blocked due to all of the available network resources being already busy The model assumes a network blocking probability of 0 5 grade of service GoS This factor is taken into account in terms of the Erlangs to channel conversion i e the number of channels required to provide capacity for a defined number of conveyed Erlangs The model converts the BHE load into an Erlang channel requirement using the Excel NORMINV function which approximates the Erlang B formula e NORMINV p mu sigma returns the value x such that with probability p a normal random variable with mean mu and standard deviation sigma takes on a value less than or equal to x Figure 5 36 PEER Parameters used in mu Traffic in BHE the calculation of the Erlang B formula sigma ErlangConversionFactor x N BHE Source Analysys e The result of the NORMINV formula is divided by the number of circuits in an E1 to calculate the number of Els required A rounded up number is calculated for each traffic type PSTN ISDN xDSL The Erlang formula is non linear at low numbers of channels however it becomes broadly linear in nature at higher channel usage consequently the model employs an Erlang conversion factor which maps the channel circuit relationship at a high channel number 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 92 Transmission modelling In the TDM modern network design
212. the transmission network is dimensioned in terms of E1 virtual containers VC Unlike the NGN IP network only transmission of the same type may be aggregated i e PSTN ISDN and xDSL traffic is maintained separately Thus the model calculates the number of E1 VCs required to handle the PSTN ISDN and xDSL traffic separately The capacity of synchronous digital hierarchy SDH equipment STM x in terms of E1 VCs is known from industry standards PDH SDH transmission level Number of E1 VCs Table 5 16 PDH SDH E1 1 transmission E2 4 capacity of E1 VCs E3 16 Source Analysys STM 1 63 STM 4 252 STM 16 1008 STM 64 4032 The model calculates the specific STM x speed reguired to carry all of the traffic The model does apply a cost threshold as it may be cheaper to deploy a larger link speed rather than multiple smaller links These cost thresholds are directly applied on the In Network worksheet It is known from industry data that such cost increases approximately 2 5 times with respect to a quadrupling of speed i e an STM 4 is approximately 2 5 times more expensive than an STM 1 Consequently instead of deploying three STM 1 links the model will deploy a cheaper solution of one STM 4 link The trench and fibre backhaul distances deployed from the LE AT1 to the parent PoC are calculated in LE_LAS_ring xls using a minimum spanning tree algorithm and this data is linked in from the In Node worksheet
213. time call duration rd pe _ minutes ii Figure 5 11 9995 207 Occupancy number of answered call unanswered minutes Note These calculations determine the busy hour load on the NGN network including call set up times Type Demand Calls Average duration of Lines Voice Voice Voice Voice Voice Voice Lines Lines Data Voice Lines Lines Lines Voice Voice Lines Lines Lines Lines Lines Lines Lines Transmission Transmission Transmission None None None Overheads See esse esse se ese Ee TE EE Er EED Ja Service demand AITAN u e Calculation to determine demand for non MSAN traffic Source Analysys Bus hour Busy hour Average kbit s call duration of calculation attempts in calls MSAN aa Shins Lema BH Cal Attempts AISAN Hasie Calculation to determine demand for non MSAN traffic Source Analysys DAnalysys Fixed LRIC model user guide Version 2 0 70 The following subsections discuss the calculation of the busy hour voice traffic the calculation for the inclusion of ringing time in addition to the previously calculated conveyed minutes and the calculation of the average bandwidth provisioning for broadband services in the core network Voice services In the modern network the number of Els required to carry the network traffic needs to be dimensioned To do this the number of voice minutes is converted into a year average busy hour Erlang
214. tributed to an individual pillar This table can store the asset volumes for up to 250 clusters which is highly unlikely to be exceeded based on current settings However if alternative settings lead to the creation of more than 250 clusters in any one ESA then the volumes from the algorithms will be printed but calculations within the worksheet would need to be extended as SUMIF function on the columns in this table For example a maximum pillar cluster size of only 100 SIOs would create more than 250 clusters in ESA with more than 25 000 SIOs 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 46 Description of asset volumes for access network in ESA Table Node NodeX NodeY Node Type Crow flies indez distance to RAU Units of demand served Locations served directly l Copper Fibre Wireless Copper Fibre Wireless Trench in 1 Incremer pillar Ra mr raad Extra DPs Total required along FDP Incremental DP pillar Total POCENESA NOTV ESA nodeipe EDS cow Mes distic cognetocetk Stresocatio wrelessioc coppe dem Blye demand wheless den sdditiondk Desk FORDE LE pillar UnA ESA Gt ODN a oN a n 12 13 14 15 16 17 18 13 20 21 aa if h f Figure 3 6 Excel outputs on asset volumes by pillar Source Analysys Cell reference Cells BA37 BD286 Description and details of spreadsheet calculations
215. ts Source Analysys e anda processor unit dimensioned by the busy hour call attempt load on each TNS TNS processor actual capacity 9995 207 Figure 5 71 Calculation of the number of TNS processor units required Source Analysys DAnalysys Fixed LRIC model user guide Version 2 0 118 Processor Call attempt TNS unit Figure 5 72 capacity of capacity requirement Excel calculations TNS calculation based on for TNS unit processor canacitv switchblock and BHCA Total BHCA TNS units d processor 640 000 640 000 640 000 640 000 640 000 640 000 640 000 640 000 640 000 640 000 640 000 640 000 640 000 640 000 requirements Source Analysys 160 263 14 19 Similar to the Regional Nodes in the NGN architecture Core Routers and Core Switches are deployed at the Core Node location Cell reference Description and details of spreadsheet calculations Rows 112 142 NGN Core router dimensioning Core routers are responsible for the routeing of traffic around the core network ring and are assumed to link to the regional nodes using 1Gbit s four port cards The chassis unit has a capacity of 15 card slots it is assumed that each core router has a minimum of two of these cards The Excel output for the calculation of the core routers is shown below 9995 207 WM Analysys Fixed LRIC model user guide Version 2 0 119 NGN Core router dimensioning PSTN
216. twork capperieadin cable sies emploved Minimum Mazimum Source Data available from the copper pairs 2 E Source Data available from the copper pairs 0 Source Data available from the copper pairs 30 Source Data available from the copper pairs 50 Source Data available from the copper pairs 100 Source Data available from the copper pairs 200 Only used for rural areas served by copper Source Data available from the copper pairs 400 Only used for rural areas served by copper Source Data available from the copper pairs 300 Only used for rural areas served by copper Source Data available from the copper pairs 1200 Only used for rural areas served by copper num copper uibansead in cable sies Ti aun coger suratiead in cable sies Figure 2 13 Excel parameters for copper cabling Source Analysys The above parameters determine the number of copper pairs employed for either a primarily non tapered or a fully tapered network The primarily non tapered case has two sizes a main size and a smaller size For the assumptions above DPs in the main chain would have 100 copper pairs whereas those at the end of a chain e g ina cul de sac might have only 10 copper pairs To deploy a fully non tapered network the parameter for the minor non tapered cable size should be set to zero This is the default assumption The tapered network can use the full range of sizes specified above The larger cable sizes can be deployed in RURA
217. ty model ignores the effect of distance The gravity model is required as Analysys has not been provided with national level call distribution data The inputs in the In TNS Gravity worksheet inform the network design traffic destination percentages on the NwDes 4 Core Nodes worksheet Located on In Nodes worksheet and informed by the IEN route and overlap analysis 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 79 Figure 5 23 Location of the ae ae _ je In TNS Gravity worksheet in the overall Network design algorithms Source Analysys Core module structure I I I I Y NwDes 4 Core Nodes 5 8 1 Key parameters The gravity model output may be directly adjusted by means of a single parameter e The distance parameter cell C6 controls the degree to which distance affects the call destination distribution using the gravity model formula Note when it is set to 0 distance is not taken into account This sheet estimates the destination of national calls from each TNS based on a gravity model if no real data is provided Basic formula P1 XxP2 dAk where P1 is population at city 1 P2 is population at city 2 dis distance between cities k is the power function Distance powel distance poweiNote when set to 0 distances not taken into account when set to 2 basic relationship to distance taken into account Figure 5 24 Excel screenshot displ
218. uct and fibre cable distances for the LE PoC links Also contains the number of locations by ESA from the Location and Demand database Rows 5300 6799 PoC node data describing the PoC LAS transmission rings Rows 6805 6937 Input data describing the parent LAS and TNS nodes Rows 6943 6957 Calculation deriving LAS and TNS by geotype Table 5 9 Calculations performed on the In Nodes worksheet Source Analysys 5 7 In LAS distances worksheet The In LAS distances worksheet contains a pre calculated matrix of the straight line distance between each LAS or regional node This data is used to inform the network design distance calculations in the NwDes 3 RegNodes worksheet 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 77 Figure 5 21 E Location of the ET iN EEN n LAS distances Y aeee aane v worksheet in the overall Network design Core module structure Source Analysys I I algorithms i I I I y NwDes 3 Reg Nodes The layout of the matrix is shown in the figure below the full matrix is 133 x 133 cells This data feeds directly into the NwDes 3 Reg Nodes worksheet and informs the LAS ring distances ALBG ALSG ADLJ BALJ BRAJ BAKN BRPT BATJ ALBG 1869 760 471 445 1 073 ALSG 1859 41 913 2 027 1 810 2 015 2 025 1 871 ADLJ BALJ BRAJ 318 1810 1 063 789 763 1 376 693 BAKN BRPT BATJ 383 1871 378 161 693 145 6a
219. ule and the Cost module It links together the required core asset deployment numbers routeing factors and allocation parameters from the Core module The allocation calculations are subsequently used in the CostAlloc Core worksheet calculations The routeing factor data is used in the setting up of the Core service routeing factors in the RF Core worksheet The service demand data is used in the calculations of network element output on the Dem In Core worksheet The deployment numbers are used in the annualisation calculations in the TA Core worksheet These linkages are shown in the diagram below 9995 207 ID Ana lysys Fixed LRIC model user guide Version 2 0 135 Figure 6 3 Location of the Inputs Core worksheet in the overall Cost module CostAlloc Core RF Core Demln Core structure Source Analysys 6 4 1 Key parameters This worksheet contains key data inputs from the Core module The key parameters that can be adjusted manually on this worksheet are identified in the table below Parameter Location Impact Sharing of building costs Cells D429 D432 Allocates the cost of LE and AT1 building costs between core and access site acquisition preparation and maintenance uninterruptible power supply UPS and generator costs between core and access Table 6 3 Key parameters on the Inputs Core worksheet Source Analysys 6 4 2 Calculation description
220. ule annualises the capital cost using a tilted annuity calculation the results of which are used to determine the service cost for each of the services modelled The remainder of this section outlines the calculations that take place in each of the worksheets in the Cost module The description of the Cost module scenarios general inputs are outlined in sections 6 1 and 6 3 e Section 6 1 outlines the key parameters and calculations in the Scenario worksheet e Section 6 2 outlines the parameters underlying the calculation of the WACC Weighted Average Cost of Capital on the WACC worksheet e Section 6 3 describes the service demand on the Inputs Demand worksheet for the period 2007 2012 that is used to dimension the access and core networks The core network costing worksheet calculations are outlined in sections 6 4 to 6 12 e Section 6 4 outlines the key parameters and calculations in the Inputs Core worksheet e Section 6 5 outlines the key parameters and calculations in the I Building Core worksheet e Section 6 6 outlines the key parameters and calculations in the I Ducts Core worksheet e Section 6 7 outlines the key parameters and calculations in the Dem In Core worksheet e Section 6 8 outlines the key parameters and calculations in the CostAlloc Core worksheet e Section 6 9 outlines the key parameters and calculations in the RF Core worksheet e Section 6 10 outlines the key param
221. ules needs to be open To run the model press F9 to calculate the modules are provided with Manual calculation enabled When the model has completed a calculation calculate is no longer displayed in the Excel status bar if calculate does not disappear perform a full calculation Ctrl Alt F9 The main model scenarios are controlled in the Cost module on the Scenario worksheet Importantly the model can be run for each of the years 2007 2012 To run the model for a particular year select the appropriate year from the year modelled scenario Once selected re calculating feeds the appropriate year s service demand into the CAN and Core modules Multi year result To produce a set of results for all years a macro in the Cost module Paste_results has been developed to cycle through each year and paste results To run the macro e ensure all three active modules are open Cost xls Core xls CAN xls with macros enabled on opening the Cost module e go to the Results Pasted worksheet of the Cost module e click the grey button in cell C1 labelled paste results The files will take several minutes to calculate Macros must have been enabled when opening the workbooks originally ani WM Analysys Fixed LRIC model user guide Version 2 0 3 Saving files If changes are to be made in any of the active modules the modules should be recalculated and saved using the same filenames this m
222. uts Core worksheet Cell reference Description and details of spreadsheet calculations Rows 8 37 Service demand by geotype The line service demand by geotype is linked in from the CAN module Service demand by geotype Services Unit Geotype 1 Geotype 2 Geotype 3 PSTN End User Access Lines PSTN local traffic onnet traffic Minutes PSTN national long distance traffic onnet calls Minutes PSTN outgoing traffic to international destinations Minutes PSTN outgoing to mobile traffic mobile terminating Minutes PSTN terminating traffic from international mobile other domestic fixed networks Minutes Local carriage service LCS Minutes ISDN PRI access Lines Service 10 none ISDN voice traffic Minutes Unconditioned local loop service ULLS Lines Line sharing service LSS Lines Wholesale line rental WLR Lines Figure 6 30 Excel sample of service demand data by geotype linked in from the Access module Source Analysys Cell reference Description and details of spreadsheet calculations Rows 42 127 Network assets required by geotype The number of assets required in the access network is linked in from the CAN module gis WM Analysys Fixed LRIC model user guide Version 2 0 161 Network asset demand by geotype Assets Unit Geotgpe 1 Geotgpe 2 Geotgpe 3 Geotype 4 NTP 2 pair wall socket NTP 10 pair building termination NTP 30 pair building termination NTP 50 pair building terminati
223. verall Cost module structure 6 5 1 Key parameters This worksheet contains estimated parameters for the average building space required by service and network level Parameter Location Impact Average equipment dimensions Rows 8 10 Affects the cost allocation between the different platforms Table 6 5 Key parameters on the Building Core worksheet Source Analysys er WM Analysys Fixed LRIC model user guide Version 2 0 141 6 5 2 Calculation description The following table outlines the calculations that are contained on the I Building Core worksheet Cell reference Description and details of spreadsheet calculations Rows 8 10 Average equipment dimensions Rows 15 17 Calculated equipment area Rows 21 23 Cost allocation percentage Table 6 6 Calculations performed on the I Buildings Core worksheet Source Analysys The remainder of this sub section outlines the specific calculations that take place on this worksheet Cell reference Description and details of spreadsheet calculations Rows 8 23 Calculation of equipment areas These calculations allocate the costs for buildings and associated building equipment between the various platforms housed in the building These costs are allocated to the platforms on the basis of the floor space of the platform equipment in the local exchange The figure below shows an Excel screenshot of the average equipment dimensions by servi
224. worksheet contains the named ranges for labels that are used to describe particular assumptions within the geoanalysis and access network module These assumptions are stored on the Inputs worksheet ska WM Analysys Fixed LRIC model user guide Version 2 0 7 Figure 2 1 Location of the Names worksheet within the overall structure of the Access network deployment algorithms driven by the macro FullAccessNetworkBuild geoanalysis and access network module Source Analysys Code sub module 2 1 1 Key parameters This worksheet outlines the main labels used throughout the geoanalysis and access network module such as the labels for assumptions stored in the data sub module whenever the network volumes for an ESA are calculated using the Visual Basic Other named ranges are used for drop down boxes in the Inputs worksheet to list the options available For instance the named range ESA methodology is used for the list of options stored in the range ESA calculation methodology for each geotype 9995 207 jw An a lysys Fixed LRIC model user guide Version 2 0 8 Parameter Location Geotype names Rows 5 18 Methodology to use when Rows 23 26 calculating for an ESA Nature of fibre connections Rows 30 32 Nature of distribution network Rows 37 38 Options for calculating for ESAs Rows 43 44 Impact Lists the labels given to each of the geotypes used within the model These are the two
225. xy cost k d k c k d c k d Vc Where d the lengthof the link c the total number of pairs inthe link function for DP area DP pillar connections and k cost coefficients determined in Excel pllar RAU connections Source Analysys k D k D Figure 2 25 Form of proxy cost Where i function for D thelengthof newtrenchrequired determining the D the length of cabling required for the link igaroa in k _ cost coefficients determined in Excel the fibre ring Source Analysys k d k M k n Figure 2 26 Where Form of proxy cost function for d the crow flies dis tan ce between the nodes identifying a wireless n the number of relay stations required for the link backhaul link for M cost multiplier for the relevant capacity needed copper fed areas k _ cost coefficients determined in Excel Source Analysys Cell reference Description and details of spreadsheet calculations Rows 309 317 Cost function coefficients These two cost functions are not proxy cost functions but are rather a normalised comparison of cost between fibre and wireless backhaul These will choose the lowest cost solution for linking an LPGS back to the RAU Changing these inputs will not change the number of LPGS but they may change how they are connected to the RAU 9995 207 ID Ana lysys Cost function coefficients Comparison is only used in rural deployments for determini
226. y Total LAS ID LAS Name attempts switchblock ALBG ALBURY ALSG ALICE SPRINGS AXE ADLJ ARMIDALE BALJ BALGOWLAH S12 BRAJ BALLARAT S12 BAKN BANKSTOWN 1 S12 BRPT BANORA POINT BATJ BATHURST AXE BEGX BEGA AXE BENV BENDIGO LAS BLAP BLACKTOWN AXE 2 BLHJ BLAKEHURST AXE BHLX BOX HILL Figure 5 44 Excel calculations for the LAS equipment Source Analysys The modern network design requires LAS equipment to handle the voice traffic The LAS equipment consists of e aswitchblock which is dimensioned by the busy hour Erlang load on each LAS Figure 5 45 Calculation of the number of LAS ues es LAS processor units processor units required required Source T Analysys LAS processor ysys actual capacity e anda processor unit which is dimensioned by the busy hour call attempt load on each LAS 9995 207 qu Analysys Fixed LRIC model user guide Version 2 0 103 Figure 5 46 Calculation of the number of LAS Numse gi LAS switchblock units switchblock units required required Source Analysys LAS switchblock T lysys actual capacity The dimensioning of these equipment parts is controlled by the physical capacity of the equipment and the maximum utilisation of the equipment The busy hour load is determined from the routed service demand on a per subscriber basis as calculated on the Dem Calc worksheet The NGN equipment at the regional node consists of a trunk gateway switch an edge switch and a
227. y n pillar RAU copper sheaths within a single trench link Note this assumes that separate ducts are used to backhaul copper to the RAU even if the trench is shared with other copper links Deploys a duct for every n LPGS RAU fibre sheaths within a single trench link Note this allows the calculation of the LPGS RAU ducts relative to the total number of ducts and is important in the allocation of CAN cost to the core network Deploys a duct for every n intra pillar fibre sheaths within a single trench link Deploys a duct for every n pillar RAU fibre sheaths within a single trench link Note this assumes that separate ducts are used to backhaul fibre to the RAU even if the trench is shared with other fibre links DAnalysys Fixed LRIC model user guide Version 2 0 19 Decreasing these capacities may increase the amount of duct deployed in the network and subsequently the size of pits deployed Cell reference Description and details of spreadsheet calculations Rows 62 133 Copper basic inputs Copper cable employed for distribution network in a primarily non tapered network Minor non tapered cable size used Source Analysys assumption copper pairs 7 smaler man tapered cable sie Main non tapered cable size usedi Source Data available fromthe copper pairs 100 mainnontapered cable sie Lead in demand served by these cables Copper cable employed for lead in cable and a tapered distribution ne
228. ype 2 4 3154 777 4 4 Geotype 3 16 169 264 262 603 16 16 Geotype 4 28 256 381 345 420 27 27 Geotype 5 40 236 840 369 112 40 40 Geotype 6 9 35 347 52 556 3 3 Geotype 7 8 15 023 17 947 8 8 Geotype 8 6 8178 10 203 6 6 Geotype 9 3 1158 1382 3 3 Geotype 10 2 75 202 86 695 2 21 Geotype 11 8 15 640 20 309 8 8 Geotype 12 24 23 630 27 781 19 23 Geotype 13 37 8 890 9 710 26 37 Geotype 14 12 1 095 1244 6 12 Geotype 15 Geotype 16 Band summary 862 386 1 334 615 196 217 Band1 15 678 129 653 7 r Band2 697 832 1 023 691 92 92 Band 3 4 148 876 175 271 97 ns Figure 2 34 Excel data for summary of volumes and calculation of their standard deviation by geotype and by band Source Analysys Output by geotype This data is outputted into the CAN module by the user copying and pasting the range H282 W458 into the CAN module using the paste values and skip blanks options of the advanced paste function Alt E S V B OK Cell reference Description and details of soreadsheet calculations Rows 282 286 Demand density by geotype Rows 289 292 Access technology by geotype Rows 295 301 Wired connections by geotype ska WM Analysys Fixed LRIC model user guide Version 2 0 35 Note copy outlined area to CAN module Total Geotgpe 1 Geotgpe 2 a Geotgpe 4 Do a Geotgpe 6 Geotgpe 7 1 Bl 3 4 5 el 71 Demand density Average number of SIOs per location 155 415 24 64 155 135 156 143 118 Average nu
229. ysys Cell reference Description and details of soreadsheet calculations Columns U AB Calculation of cost allocation between platforms PSTN ISDN xDSL other service platforms 0095 207 W Analysys Fixed LRIC model user guide Version 2 0 150 The platform costs are allocated directly to the PSTN ISDN xDSL and Other service platforms the latter of which is user defined The allocation split between these platforms is linked from the Inputs Core worksheet having been calculated explicitly in the Core module The figure below shows an Excel output of the calculation of cost allocation between platforms PSTN ISDN xDSL Other service platforms Calculation Cost allocation Platforms Platforms Asset group Asset Fibre Core cost PSTN ISDN 2DSL Other PSTN ISDN 2DSL Other type type platforms platforms indes x ATI ATI Site acquistion preparation and maintenance Incremental ATI ATI MSAN located at Access Tier 2 sites Incremental ATI ATI Concentrator PSTN xDSL line card Incremental ATI ATI Concentrator ISDN line card Incremental None Asset 25 Incremental None Asset 26 Incremental None Asset 27 Incremental ATI ATI UPS 40k A and Generator 50k YA Incremental ATI ATI Air conditioning unit 10k YA Incremental ATI ATI Ports PoC facing 10Mbitis ports _8 Incremental ATI ATI Ports PoC facing 100Mbitis ports gl Incremental ATI ATI Ports PoC facing 1GE ports __ 10 I
230. zru distance gt slope Select overlap level between core and accesdikimbuer SORA veran BOOESS ONE 5 Note this parameter should only be set to TRUE in order to ge DEFAULT is FALSE Note This switch set to TRUE forces TNS traffic to be carried Note This switch set to TRUE allows LAS traffic to be carried note DWDM only deployed if number of STM 64 exceceds thi Note this parameter is controlled in the Cost xls module It upli Note this parameter is controlled in the Cost xls module It sele Note This screenshot graphic shows only the inputs for geotypes 1 7 rather than for all of geotypes 1 16 Figure 5 4 Excel parameters used to set up user defined scenarios Source Analysys 9995 207 DAnalysys Fixed LRIC model user guide Version 2 0 59 Cell reference Description and details of spreadsheet calculations Impact Row 3 Year modelled Row 6 Determines if any traffic in each of the 16 geotypes requires an MSAN Row 8 Force deployment of IP core Row 11 12 Parameters determine whether DWDM is implemented on transit links and LAS links Row 20 Distance uplift for slope effect Row 22 Overlap level between core and access Changes which year s service demand levels are used to dimension the core model Note this parameter is controlled from the Cost module To change this parameter the user should go to the Scenario worksheet in the Cost module If any of the geotypes requires the

Fixed LRIC model user guide – Version 2.0

Contents

Download Pdf Manuals

Related Search

Related Contents

Fixed LRIC model user guide &ndash; Version 2.0

Contents

Download Pdf Manuals

Related Search

Related Contents

Fixed LRIC model user guide – Version 2.0