 This topic has 8 replies, 1 voice, and was last updated 10 years, 3 months ago by jon.

AuthorPosts

hongkyvnGuest
Hi all,
Could you please show me hơ to calculate GPRS KPIs at Network level?
Can I calculate these by average them using data volume as weighted factors??
Many Thanks
BRs
Ky
nitinGuestwht do u want to know……
there is diff KPI for data
TBF Success Rate
TBF Drop Rate
TBF Congestion rate
LLC throughput EGPRS
LLC Throughput GPRS?????????hongkyvnGuestHi Nitin,
For eaxample, in a region there are 3 BSCs. The KPIs data in a day as follow:
Data,MB TBF_DR,% TBF_SR,%
BSC01 17.04 4.01 98.02
BSC02 23.61 3.34 98.72
BSC03 98.94 2.93 97.34So, the KPIs for that region are calculated:
TBF_DR=(17.04*4.01+23.61*3.34+98.94*2.93)/(17.04+23.61+98.94)= 3.131184182
TBF_SR=(17.04*98.02+23.61*98.72+98.94*97.34)/(17.04+23.61+98.94)=97.65641951
Can I apply that rule?
BRs
Ky
nitin guptaGuestno this is not the way to calculate any KPIs. This can be your own way to calculate KPI but there is no standard way to check KPI in our industry……..
If u belongs from Customer side than u can make ur own rule , its good to think , u can apply according to u but it is not standardized………hongkyvnGuestHi Nitin,
Thank your for your answer.
OK, I have to calculate these KPIs from counters of all cells in Network. It will wastes of time.
If you have any excel file or tool to calculate these KPI, please send it to me.
BRs
Ky
billGuestdear the best way is to accumulate the counters over all network, extract the data into excel file and apply formulae. For the said case, you’ll have to use two formulae with 08 columns only and this is really simple, i have made formula sheets, that use >150 columns!
anshuGuestbill
can u send these sheet
Thanks in advance
@ anshuGuestthe thing is that, it is not a standard sheet, i use OPTIMA for counter extraction, the applied formula totally depends upon the way the counters are extracted and is custom
jonGuestwhat do i hav to concider to calculat gprs kpi

AuthorPosts