1.
Radio Formulae Used OSS :
No. of TCHs : TNUCHCNT
TCH Traffic (Erlang) : C_TTRALACC
Ideal Traffic(Erlang) at 2% gos) =
If (<TNUCHCNT>=6) Then 2.27 Else If (<TNUCHCNT>=7) Then 2.93 Else If (<TNUCHCNT>=13)
Then 7.4 Else If (<TNUCHCNT>=14) Then 8.2 Else If (<TNUCHCNT>=20) Then 13.182 Else If
(<TNUCHCNT>=21) Then 14.03 Else If (<TNUCHCNT>=22) Then 14.89 Else If
(<TNUCHCNT>=27) Then 29.265 Else If (<TNUCHCNT>=28) Then 20.15 Else If
(<TNUCHCNT>=29) Then 21.03 Else If (<TNUCHCNT>=30) Then 21.93 Else If
(<TNUCHCNT>=33) Then 24.626 Else If (<TNUCHCNT>=34) Then 25.529 Else If
(<TNUCHCNT>=35) Then 26.435 Else If (<TNUCHCNT>=36) Then 27.343 Else If
(<TNUCHCNT>=37) Then 28.254 Else If (<TNUCHCNT>=38) Then 29.166 Else If
(<TNUCHCNT>=41) Then 31.916 Else If (<TNUCHCNT>=42) Then 32.836 Else If
(<TNUCHCNT>=43) Then 33.758 Else If (<TNUCHCNT>=44) Then 34.682 Else If
(<TNUCHCNT>=45) Then 35.607
Cell Utilization : =(<TCH Traffic>/<Ideal Traffic(Erlang)>)*100
HR Traffic : <THTRALACC>/360
Total Assignment Attempts : TASSALL
Erlang Minutes Per Drop : =(<TCH Traffic>/<TFNDROP>)*60
Total No. of Dropped TCH Connections : TNDROP
TCH Availability (%) : 100 * C_TAVA / TNUCHCNT
TCH Blocking (%) : = ((<CNRELCONG>+<TNRELCONG>)/(<TASSALL>))*100
SDCCH Blocking (%) : = (<CCONGS>/<CCALLS>)*100
TCH Assignment Success Rate (%) : =(<TCASSALL>/<TASSALL>)*100
CSSR (%) : =((<TCASSALL>/<TASSALL>)*(1-(<CCONGS>/<CCALLS>))*(1-((<CNDROP>-
<CNRELCONG>)/<CMSESTAB>)))*100
TCH Drop (%) : =(<TNDROP>/(<TCASSALL>+(<SUMIHOSUCC>-<SUMIABSUCC>-
<SUMIAWSUCC>)-(<SUMOHOSUCC>-<SUMOABSUCC>-<SUMOAWSUCC>)))*100
No. of SDCCHs : CNUCHCNT
No. of SDCCH Seizure Attempts : =<CCALLS>
SDCCH Drop (%) : =((<CNDROP>-<CNRELCONG>)/(<CMSESTAB>))*100
Outgoing HO SUCC Rate (%) : =((<SUMOHOSUCC>+<SUMEOHOSUCC>)/
(<SUMEOHOATT>+<SUMOHOATT>))*100
Incoming HO SUCC Rate (%) : =((<SUMIHOSUCC>+<SUMEIHOSUCC>)/
(<SUMEIHOATT>+<SUMIHOATT>))*100
Total HO SUCC Rate (%) :
=((<SUMOHOSUCC>+<SUMEOHOSUCC>+<SUMIHOSUCC>+<SUMEIHOSUCC>)/
(<SUMEOHOATT>+<SUMOHOATT>+<SUMEIHOATT>+<SUMIHOATT>))*100
TCH Mean Holding Time : =(<TCH Traffic>/<TMSESTB>)*3600
Total Traffic (Erlang) FR : =((<TSQIGOODAF> + <TSQIGOODSUBAF>) + (<TSQIACCPTAF> +
<TSQIACCPTSUBAF>) + (<TSQIBADAF> + <TSQIBADSUBAF>)) / 1500
Total Traffic (Erlang) HR : =((<TSQIGOODAH> + <TSQIGOODSUBAH>) +
(<TSQIACCPTAH> + <TSQIACCPTSUBAH>) +(<TSQIBADAH> + <TSQIBADSUBAH>)) / 1500
Followings are TCH Parameters (These are from Alex)
Drop Reason, Low SS CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
DL (%) 100 * (TFDISSDL +
THDISSDL + TFDISSDLSUB
+THDISSDLSUB)/
(TFNDROP + THNDROP + TFNDROPSUB
+ THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100 *
TDISSDL/ TNDROP
Drop Reason, Low SS CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
UL (%) 100
*
(TFDISSUL + THDISSUL + TFDISSULSUB
+THDISSULSUB)/
(TFNDROP +
THNDROP + TFNDROPSUB + THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100 * TDISSUL / TNDROP
Drop Reason, Low SS CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
UL/DL (%) 100 * (TFDISSBL +
THDISSBL + TFDISSBLSUB +
THDISSBLSUB)/
(TFNDROP+THNDROP
+TFNDROPSUB + THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100 * TDISSBL / TNDROP
Drop Reason, Bad CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
Quality DL (%) 100 * (TFDISQADL +
THDISQADL + TFDISQADLSUB +
THDISQADLSUB)/
(TFNDROP + THNDROP + TFNDROPSUB +
THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100
* TDISQADL/TNDROP
Drop Reason, Bad CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
Quality UL (%) 100
* (TFDISQAUL+THDISQAUL +
TFDISQAULSUB +THDISQAULSUB)
/
(TFNDROP + THNDROP
+ TFNDROPSUB + THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100 * TDISQAUL / TNDROP
Drop Reason, Bad CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
Quality UL/DL (%) 100
*(TFDISQABL + THDISQABL
+ TFDISQABLSUB +THDISQABLSUB)/
(TFNDROP+THNDROP
+TFNDROPSUB+ THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100
*TDISQABL / TNDROP
Drop Reason, Suddenly CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
Lost Connections (%) 100 * (TFSUDLOS +
THSUDLOS + TFSUDLOSSUB +
THSUDLOSSUB) / (TFNDROP + THNDROP +
TFNDROPSUB
+ THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100 * TSUDLOS / TNDROP
Drop Reason, Excessive CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
TA (%) 100 * (TFDISTA + THDISTA) /
(TFNDROP +
THNDROP +
TFNDROPSUB
+ THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100 * TDISTA / TNDROP
Drop Reason, Other (%) CLTCHDRF, CLTCHDRH, CELTCHF, CELTCHH:
100 * ((TFNDROP + THNDROP +
TFNDROPSUB + THNDROPSUB)-
((TFDISSDL + THDISSDL +
TFDISSDLSUB +THDISSDLSUB) +
(TFDISSUL+ THDISSUL + TFDISSULSUB +
THDISSULSUB) + (TFDISSBL+ THDISSBL +
TFDISSBLSUB+THDISSBLSUB) +
(TFDISQADL+THDISQADL
+TFDISQADLSUB + THDISQADLSUB) +
(TFDISQAUL+
THDISQAUL+TFDISQAULSUB
+THDISQAULSUB) +(TFDISQABL+THDISQABL+
TFDISQABLSUB+THDISQABLSUB) +
(TFDISTA+THDISTA)+(TFSUDLOS+THSUDLOS
+TFSUDLOSSUB +
THSUDLOSSUB+
(TFDISFERDL+ TFDISFERDLSUB+ THDISFERDL+
THDISFERDLSUB)+
(TFDISFERUL+TFDISFERULSUB+
THDISFERUL+THDISFERULSUB)
+(TFDISFERBL
+TFDISFERBLSUB+
THDISFERBL+THDISFERBLSUB)))/
(TFNDROP+THNDROP+
TFNDROPSUB +THNDROPSUB)
(MSC_CELL_MAIN / BSC_CELL_MAIN):
100 * (TNDROP - (TDISSDL + TDISSUL +
TDISSBL +TDISQADL +
TDISQAUL + TDISQABL + TDISTA
+TSUDLOS+TDISFERDL+
TDISFERUL+TDISFERBL))
/ TNDROP
Followings are SDCCH Parameters (These are from Alex)
SDCCH Erlang Minutes CLSDCCH:
per Drop RPL * (CTRALACC / CNSCAN) / CNDROP
(CELL_MAIN):
RPL * C_CTRALACC / CNDROP
Drop Reason, Low SS CELLCCHDR, CLSDCCH:
100 * (CDISSS + CDISSSSUB) / CNDROP
(%) (CELL_MAIN):
100 * CDISSS / CNDROP
Drop Reason, Bad CELLCCHDR, CLSDCCH:
Quality (%) 100 * (CDISQA + CDISQASUB) / CNDROP
(CELL_MAIN):
100 * CDISQA / CNDROP
Drop Reason, Excessive CELLCCHDR, CLSDCCH:
TA (%)
(CELL_MAIN):
100 * CDISTA / CNDROP
Drop Reason, Other (%) CELLCCHDR, CLSDCCH:
100 * (CNDROP - ((CDISSS +
CDISSSSUB)+(CDISQA + CDISQASUB)
+CDISTA))/CNDROP
(CELL_MAIN):
100
*(CNDROP-
(CDISSS+CDISQA+CDISTA))
/CNDROP
Handover Lost of all CELLCCHHO, CLSDCCH
SDCCH Drop (%)
(CELL_HO, CELL_MAIN):
100 * (CCHHOCNT - CCHHOSUC
- CCHHOTOCH)
/ CNDROP
Random Access Success RANDOMACC
(%)
(CELL_MAIN / CELL_GPRS):
100 *( CNROCNT + PDRAC ) / (CNROCNT
+PDRAC + RAACCFA)
No. of Handover NCELLREL, NECELLREL
Attempts
(CELLREL_DATA):
HOVERCNT
For Hand Over Report :
HO per Cell Relation (1)
No. of Handover NCELLREL, NECELLREL:
Attempts HOVERCNT + HOVERCNT
(CELL_HO):
SUMOHOATT+
SUMEOHOATT
Handover Success (%) NCELLREL, NECELLREL:
100*(HOVERSUC + HOVERSUC)
/(HOVERCNT +
HOVERCNT)
(CELL_HO):
100 * (SUMOHOSUCC+SUMEOHOSUCC)
/
(SUMOHOATT+
SUMEOHOATT)
Handover Reversion (%) NCELLREL, NECELLREL:
100
*
(HORTTOCH
+ HORTTOCH)
/(HOVERCNT+
HOVERCNT)
(CELL_HO):
100*
(SUMOHOREV + SUMEOHOREV)
/(SUMOHOATT +
SUMEOHOATT)
Handover Lost (%) NCELLREL, NECELLREL:
100*
((HOVERCNT-
HORTTOCH-
HOVERSUC) +
(HOVERCNT-
HORTTOCH-
HOVERSUC))
/(HOVERCNT + HOVERCNT)
(CELL_HO):
100 * (SUMOHOLOST + SUMEOHOLOST)
/(SUMOHOATT +
SUMEOHOATT)
Ping Pong Handover (%) NCELLREL, NECELLREL, NICELHO, NECELHO
(CELLREL_DATA):
100 * HODUPFT / HOVERSUC
HO per Cell Relation (2)
Table 56 Handover Performance Per Cell Relation BSC and Cell Set, Sheet 2: HO per
Cell Relation (2)
Column Formula
Serving Cell -
Target Cell -
Handover Decisions
No. of NICELHO, NECELHO, NICELHOEX, NECELHOEX,
NICELASS, NECELASS
(CELLREL_DATA):
HOTOLCL + HOTOKCL + HOUPLQA
+HODWNQA+HOEXCTA+
HOASWCL +
HOATTLSS+
HOATTHSS + HOTOHCS
Bad Quality UL (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX,
NICELASS, NECELASS
(CELLREL_DATA):
100 * HOUPLQA/
(HOTOLCL + HOTOKCL + HOUPLQA
+ HODWNQA + HOEXCTA
+HOASWCL+
HOATTLSS + HOATTHSS +
HOTOHCS)
Bad Quality DL (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX,
NICELASS, NECELASS
(CELLREL_DATA):
100 * HODWNQA/ (HOTOLCL
+HOTOKCL+
HOUPLQA+HODWNQA + HOEXCTA
+HOASWCL+
HOATTLSS
+HOATTHSS
+ HOTOHCS)
Better L-Cell (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX,
NICELASS, NECELASS
(CELLREL_DATA):
100 * HOTOLCL
/(HOTOLCL+HOTOKCL
+HOUPLQA + HODWNQA + HOEXCTA
+HOASWCL
+ HOATTLSS
+HOATTHSS + HOTOHCS)
Better K-Cell (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX,
NICELASS, NECELASS
(CELLREL_DATA):
100 * HOTOKCL
/
(HOTOLCL + HOTOKCL + HOUPLQA
+ HODWNQA + HOEXCTA
+HOASWCL
+HOATTLSS+
HOATTHSS
+ HOTOHCS)
Excessive TA (%) NICELHO, NECELHO, NICELHOEX, NECELHOEX,
NICELASS, NECELASS
(CELLREL_DATA):
100 * HOEXCTA
/
(HOTOLCL+HOTOKCL
+HOUPLQA+HODWNQA+HOEXCTA
+ HOASWCL
+HOATTLSS+
HOATTHSS+
HOTOHCS)
No. of Assignment Worse NICELASS, NECELASS
Cell
(CELLREL_DATA):
HOASWCL
Assignment to Worse Cell NICELASS, NECELASS:
Success (%)
(CELLREL_DATA):
100
*HOSUCWCL/
HOASWCL
No. of Assignment Better NICELASS, NECELASS:
Cell
(CELLREL_DATA):
HOASBCL
Assignment to Better Cell NICELASS, NECELASS:
Success (%)
(CELLREL_DATA):
100 * HOSUCBCL/HOASBCL
