- This topic has 8 replies, 1 voice, and was last updated 11 years, 4 months ago by
jon.
-
AuthorPosts
-
hongkyvn
GuestHi 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
nitin
Guestwht 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?????????hongkyvn
GuestHi 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 gupta
Guestno 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………hongkyvn
GuestHi 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
bill
Guestdear 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!
anshu
Guestbill
can u send these sheet
Thanks in advance
@ anshu
Guestthe 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
jon
Guestwhat do i hav to concider to calculat gprs kpi
-
AuthorPosts