Workflow (Detailed) Neighbour Neighbour Optimisatio Optimisation n 2G – 2G 900MHz Access Layer Layer Prioritised BSC List
On Site
Off Site
O2
•
Usage Data Collection & Channel Finder Preparation
Neighbour Usage Audit
Channel Finder Collection
• •
Export usage data from IPD for BSC (from Nokia 2G neighbour tool) into excel Create BCCH list for recording Create CF Request with AMDOCs
• • • •
Calculate % contribution per relationship Calculate Distance Apply filtering Criteria Manual Checks
•
Send email with channel finder result in zipped file
A
On Site
Implementation
On Site
• • • • • • • •
Create IPD Plan Import text file (neighbour changes) Clear pre-plan discrepancies Prepare, Integrity Check and Build Create Request within AMDOCs Monitor implementation (BSC, Cell Level) Monitor & Clear Discrepancies Record Implementation Dates
•
Export Counters and KPIs from Proptima to excel
• • •
Cell Level Analysis Report improved and degraded cells Degraded cells back for review (B)
• •
Final Report Validation from O2
Data Collection
n
e
Channel Finder Processing
• • •
Setu Setu Tool Tool Run Run Generate Result Apply Filtering
• • • •
Apply filtering Criteria Cross check usage audit (deletions) with Channel Finder (proposed additions) Prepare text file (neighbour changes) Create Summary
•
Approvals (TTL, O2)
B
On Site
MSI/ O2
Proposal (Neighbour Additions & Deletions)
Off Site
MSI/O2
Monitoring, Analysis & Reporting
Validation
B Acceptance
A
Neighbour Usage Audit: Filtering Criteria Neighbour Optimisation 2G – 2G
cull approx 5-10% of neighbours AND remove at least one • Aim toCriteria Filtering
neighbor for every cell. • The exact criteria depends on the exchange. • For example a suburban or rural BSC may have high number of relationships each with low utilisation therefore a low utilisation threshold would be appropriate. • It is suggested that criteria are used as a guideline and that cells with no removals or a high number of removals are audited manually. • The remove column should be overwritten with a 0 or 1 in this case. Criteria (Suggested Range): • Handovers Attempted (50-500) • Handins Attempted (50-500) • Distance (Average Handover Distance for the BSC) • Utilisation (0.1 – 2%)
• NOTE: Pivot table must be updated if source data is changed!
Neighbour Usage Audit: Input Files Neighbour Optimisation 2G – 2G
Name: “All_Cellsites.csv” Description: This file contains detailed information about cells in the network including lat & long, antenna information, frequencies etc. MSI to upload this as required. Tip: Apply filter to reduce file size: •Region = “South” & “UK – Central Eng and Wales”. • =“ ” Name: Neighbour Usage XXX ddmmyy Where XXX = BSC Id, and the other part of the name is the date. Description: Raw file from O2’s IPD tool containing neighbour usage data from OMC. MSI upload this as required.
Input data can be found at: C:\Users\cko\Dropbox\O2 2G Optimisation Services\Implementation\2G2G Neighbour\Input Data
Neighbour Usage Audit : Creating Neighbour Audit Worksheet Neighbour Optimisation 2G – 2G
1. 2. 3.
4.
5. 6. 7.
8.
9.
Open Neighbour Usage File Open All_Cellsites and copy tab into the open Neighbour Usage file. Select Column A and insert a new field call “Key”. In the row 2 of new column enter formula ‘=RIGHT((1000000+B2),6)&"_"&C2’ and fill down. Select the Usage Tab a. Hide rows K :0 b. in row 5 P:AA add the following field headers : Source_Key, Dest_Key, S_Long, S_Lat, D_Long D_Lat, Distance, Intracell, S_Layer, D_Layer, S_Type, D_Type. Add formulas: a. P6 =A6&"_"&B6 b. Q6 =C6&"_"&D6 c. R6 = VLOOKUP(P:P,All_Cellsites!$A:$BJ,33,FALSE) d. S6 = VLOOKUP(P:P,All_Cellsites!$A:$BJ,34,FALSE) e. T6 =VLOOKUP(Q:Q,All_Cellsites!$A:$BJ,33,FALSE) f. U6 =VLOOKUP(Q:Q,All_Cellsites!$A:$BJ,34,FALSE) g. V6 =ROUND(SQRT(((R6-T6)^2+(S6-U6)^2))/1000,2) h. W6 =P6=Q6 i. X6 =VLOOKUP(P:P,All_Cellsites!$A:$BJ,14,FALSE) j. Y6 =VLOOKUP(Q:Q,All_Cellsites!$A:$BJ,14,FALSE) k. Z6 =VLOOKUP(Q:Q,All_Cellsites!$A:$BJ,13,FALSE) l. AA6 =VLOOKUP Q:Q All _Cellsites!$A:$BJ 13 FALSE Fill down Select the data within the sheet and create a pivot table. Name the tab “HO by Cell”. Row label = “Source_Key”, Values = Sum of Handovers Attempted. Filters: Intracell = false; S_Type = Sectored, T_type = Sectored, S_Layer = 900. T_Layer = 900 On the usage tab: a. Add field Utilisation in AB5 b. Add formula AB6 “=E6/VLOOKUP(P6,'HO by Cell'!A:B,2,FALSE)” and format as percentage c. Add Field Delete to AC5 d. Add Formula AC6 =IF(ISERROR(V6),0,IF(OR(W6,X6=1800,Y6=1800),0,IF(AND(E6<$E$4,H6<$H$4,V6>$V$4,AB6<$AB$4),1,0))) e. Add field Output_Out to AD5 f. Add formula AD6 =P7&","&Q7&",0,0“ g. Add Field Output_Back to AE5 h. Add Formula AE6 =Q7&","&P7&",0,0“ i. Fill Down (all new fields) j. Apply distance, utilisation and handover count criteria (Row 4 column E, H, V, AB should have threshold values)
Select the data within the usage tab and create a pivot table. Name the tab “Summary”. Row label = “Source_Key”, Values = Count of Dest_Key, Sum of Delete. At the same line as grand total add a formula to calculate Sum of Delete / Count of Dest_key. Format as percentage. Add a column to calcluate the remaining number of neighbours i.e. Count of Dest_Key – Sum of Delete Save As “Neighbour Audit XXX ddmmyy.xls” where XXX is BSC & ddmmyy is date. Copy file to : Dropbox\O2 2G Optimisation Services\Implementation\2G2G Neighbour\Output
