【資料名稱】：愛立信KPI指標(biāo)的各種計算公式，COUNTER，詳細的不得了

【資料作者】：AA

【資料日期】：2012-7-22

【資料語言】：中文

【資料格式】：XLS

【資料目錄和簡介】：

CLTCH,STS_CELL,CELTCHF,CELTCHH,CELTCHFP,RANDOMACC,CLSDCCH,CLTCHDRF,CLTCHDRH,IDLEUTCHF,SUMHO,CELLCCHDR,CELEVENTI,CELLSQI,CCCHLOAD,CELLPAG,CELLQOSG,CELLQOSEG,CELLGPRS,TRAFDLGPRS
備用字段名公式著色位置大于小于格式
DateCLTCH.Date-1.00 0
PeriodCLTCH.Period-1.00 0
ExchidCLTCH.Exchid-1.00 0
CELLCLTCH.Object_ID-1.00 0
CellNameSts_Cell.Cell_Name-1.00 0
無線接通率TCASSALL*TFCONGPGSM/(TASSALL*(CNROCNT+RAACCFA))10.000.950.00%
話音接通率(Celtchf.TFMSESTB+Celtchh.THMSESTB)/(Celtchf.TFCALLS+Celtchh.THCALLS)10.000.900.00%
接入成功率RANDOMACC.CNROCNT/(RANDOMACC.CNROCNT+RANDOMACC.RAACCFA)-1.000.990.00%
無線接入性"(CELTCHFP.TFCONGPGSM*CLTCH.TCASSALL)/((RANDOMACC.CNROCNT+RANDOMACC.RAACCFA)*CLTCH.TASSALL)
"10.000.90
無線利用率（0.71）1.4085*(Celtchf.TFTRALACC+Celtchh.THTRALACC)/Celtchf.TFNSCAN/Cltch.TNUCHCNT+1.4085*CELLGPRS.ALLPDCHACTACC/CELLGPRS.ALLPDCHSCAN/Cltch.TNUCHCNT100.750.00010.00%
干擾比(IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)100.1 0.0%
定義信道Cltch.TNUCHCNT-1.00 0.00
可用信道Cltch.TAVAACC/Cltch.TAVASCAN-1.00 0.00
信道完好率Cltch.TAVAACC/(Cltch.TAVASCAN*Cltch.TNUCHCNT)4.001.000.0%
話務(wù)量(Celtchf.TFTRALACC+Celtchh.THTRALACC)/Celtchf.TFNSCAN10.00 0.00
每線話務(wù)量(Celtchf.TFTRALACC+Celtchh.ThTRALACC)/(Celtchh.ThNSCAN*Cltch.TNUCHCNT)-1.000.600.150.00
TCH掉話率(CELTCHF.TFNDROP+CELTCHH.THNDROP)/(Celtchf.TFMSESTB+CeltchH.THMSESTB)10.000.030.00%
TCH擁塞數(shù)CELTCHFP.TFESTPGSMSUB10.0020.000
TCH擁塞率TFESTPGSMSUB/TASSALL10.000.020.00%
TCH指配成功率(CELTCHF.TFCASSALL+CELTCHH.THCASSALL)/CLTCH.TASSATT10.000.900.0%
F話務(wù)量Celtchf.TFTRALACC/Celtchf.TFNSCAN-1.00 0.00
H話務(wù)量Celtchh.ThTRALACC/Celtchh.ThNSCAN-1.00 0.00
TCH接通率(CLTCH.TASSALL-CELTCHFP.TFESTPGSM)/CLTCH.TASSALL10.000.950.0%
SD擁塞率CLSDCCH.CCONGS/CLSDCCH.CCALLS 0.050.00%
SD掉話率CLSDCCH.CNDROP/CLSDCCH.CMSESTAB-1.00 0.0%
S定義信道CLSDCCH.CNUCHCNT-1.00 0
S可用信道CLSDCCH.CAVAACC/CLSDCCH.CAVASCAN-1.00 0.00
S完好率CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN*CLSDCCH.CNUCHCNT)-1.00 0.0%
S話務(wù)量CLSDCCH.CTRALACC/CLSDCCH.CNSCAN-1.00 0.00
S每線話務(wù)量CLSDCCH.CTRALACC/(CLSDCCH.CNSCAN*CLSDCCH.CNUCHCNT)-1.00 0.00
SD分配成功率CELTCHFP.TFCONGPGSM/(RANDOMACC.CNROCNT+RANDOMACC.RAACCFA)0.90
S申請次數(shù)CLSDCCH.CCALLS10.00100.000
S指配成功數(shù)CLSDCCH.CMSESTAB10.00 0
S擁塞數(shù)CLSDCCH.CCONGS10.000.000
S擁塞釋放數(shù)CLSDCCH.CNRELCONG10.001.000
S掉話數(shù)CLSDCCH.CNDROP10.0030.000
F話音接通率Celtchf.TFMSESTB/Celtchf.TFCALLS10.000.900.0%
F申請次數(shù)Celtchf.TFCALLS-1.00 0
F指配次數(shù)Celtchf.TFMSESTB-1.00 0
F TCH異常率(CELTCHF.TFCALLS-CELTCHF.TFMSESTB-CELTCHF.TFCONGSAS-CELTCHF.TFCONGSHO)/CELTCHF.TFCALLS10.000.100.0%
H申請次數(shù)Celtchh.THCALLS-1.00 0
H指配次數(shù)Celtchh.THMSESTB-1.00 0
H話音接通率Celtchh.THMSESTB/Celtchh.THCALLS10.000.900.0%
H TCH異常率(CELTCHH.THCALLS-CELTCHH.THMSESTB-CELTCHH.THCONGSAS-CELTCHH.THCONGSHO)/CELTCHH.THCALLS10.000.100.0%
指配申請數(shù)CLTCH.TASSALL-1.001.000
指配命令數(shù)CLTCH.TASSATT-1.001.000
指配成功數(shù)CELTCHF.TFCASSALL+CELTCHH.THCASSALL-1.00 0
通話時長(60*60*Celtchf.TFTRALACC+60*60*Celtchh.THTRALACC)/(Celtchf.TFNSCAN*Celtchf.TFMSESTB+CeltchH.THNSCAN*Celtchh.THMSESTB)-1.00 0.00
話務(wù)掉話比60*(Celtchf.TFTRALACC+Celtchh.ThTRALACC)/(Celtchf.TFNDROP*Celtchf.TFNSCAN+celtchh.thndrop*celtchh.thnscan)10.00100.000.00
F掉話數(shù)Celtchf.TFNDROP-1.00 0
H掉話數(shù)CeltchH.THNDROP-1.00 0
總掉話數(shù)Celtchf.TFNDROP+CeltchH.THNDROP10.0010.000
總占用數(shù)Celtchf.TFMSESTB+CeltchH.THMSESTB10.00 0
無線掉話CLTCHDRF.TFSUDLOS+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISSBL+CLTCHDRF.TFDISQABL+CLTCHDRF.TFDISTA+CLTCHDRH.THSUDLOS+CLTCHDRH.THDISSUL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISSDL+CLTCHDRH.THDISQADL+CLTCHDRH.THDISSBL+CLTCHDRH.THDISQABL+CLTCHDRH.THDISTA-1.00 0
不明掉話(Celtchf.TFNDROP+Celtchf.TFNRELCONGSUB+Celtchh.THNDROP+Celtchh.THNRELCONGSUB)-(CLTCHDRF.TFSUDLOS+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISSBL+CLTCHDRF.TFDISQABL+CLTCHDRF.TFDISTA+CLTCHDRH.THSUDLOS+CLTCHDRH.THDISSUL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISSDL+CLTCHDRH.THDISQADL+CLTCHDRH.THDISSBL+CLTCHDRH.THDISQABL+CLTCHDRH.THDISTA)-1.00 0
突然掉話CLTCHDRF.TFSUDLOS+CLTCHDRh.THSUDLOS-1.00 0
上行信號CLTCHDRF.TFDISSUL+CLTCHDRH.THDISSUL-1.00 0
上行質(zhì)差CLTCHDRF.TFDISQAUL+CLTCHDRH.THDISQAUL-1.00 0
下行信號CLTCHDRF.TFDISSDL+CLTCHDRH.THDISSDL-1.00 0
下行質(zhì)差CLTCHDRF.TFDISQADL+CLTCHDRH.THDISQADL-1.00 0
上下行信號CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSBL-1.00 0
上下行質(zhì)差CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQABL-1.00 0
TA掉話CLTCHDRF.TFDISTA+CLTCHDRH.THDISTA-1.00 0
ICM1IDLEUTCHF.ITFUSIB1/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)10.000.900.0%
ICM2IDLEUTCHF.ITFUSIB2/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)-1.00 0.0%
ICM3IDLEUTCHF.ITFUSIB3/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)-1.00 0.0%
ICM4IDLEUTCHF.ITFUSIB4/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)-1.00 0.0%
ICM5IDLEUTCHF.ITFUSIB5/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5)-1.00 0.0%
用戶感知擁塞CELTCHF.TFNRELCONG+CELTCHF.TFNRELCONGSUB+CLSDCCH.CNRELCONG+CELTCHH.THNRELCONG+CELTCHH.THNRELCONGSUB10.000.000
用戶感知擁塞率(CELTCHF.TFNRELCONG+CELTCHF.TFNRELCONGSUB+CLSDCCH.CNRELCONG+CELTCHH.THNRELCONG+CELTCHH.THNRELCONGSUB)/(CLTCH.TASSALL-sumHO.SumIHOSUCBCL-sumHO.SumIHOSUCWCL+sumHO.SumOHOSUCBCL+sumHO.SumOHOSUCWCL)10.000.000.0%
F擁塞率(CELTCHF.TFCONGSAS+CELTCHF.TFCONGSHO)/Celtchf.TFCALLS-1.00 0.0%
H擁塞率(CELTCHH.THCONGSAS+CELTCHH.THCONGSHO)/CeltchH.THCALLS-1.00 0.0%
F起呼擁塞CELTCHF.TFCONGSAS10.000.000
F切換擁塞CELTCHF.TFCONGSHO10.000.000
H起呼擁塞CELTCHH.THCONGSAS10.000.000
H切換擁塞CELTCHH.THCONGSHO10.000.000
接入申請RANDOMACC.CNROCNT+RANDOMACC.RAACCFA-1.00 0
接入失敗RANDOMACC.RAACCFA10.00100.000
尋呼應(yīng)答RANDOMACC.RAANPAG-1.00 0
其它服務(wù)RANDOMACC.RAOSREQ-1.00 0
緊急呼叫RANDOMACC.RAEMCAL-1.00 0
呼叫重建RANDOMACC.RACALRE-1.00 0
位置更新RANDOMACC.RAOTHER-1.00 0
S接通率CLSDCCH.CMSESTAB/(CLSDCCH.CCALLS-CLSDCCH.CCONGS)10.000.900.0%
S_DR_SS%CELLCCHDR.CDISSS/CLSDCCH.CNDROP-1.00 0.0%
S_DR_BQ%CELLCCHDR.CDISQA/CLSDCCH.CNDROP-1.00 0.0%
S_DR_TA%CELLCCHDR.CDISTA/CLSDCCH.CNDROP-1.00 0.0%
S通話時長3600*CLSDCCH.CTRALACC/(CLSDCCH.CNSCAN*CLSDCCH.CMSESTAB)10.005.000.00
內(nèi)切成功率CELEVENTI.HOINSUC/(CELEVENTI.HOINDQA+CELEVENTI.HOINUQA+CELEVENTI.HOINBQA)-1.00 0.0%
上行內(nèi)切CELEVENTI.HOINUQA10.0030.000
下行內(nèi)切CELEVENTI.HOINDQA10.0030.000
上下行內(nèi)切CELEVENTI.HOINBQA10.0030.000
起呼次數(shù)TCASSALL0
切換成功率sumHO.SumOHoverSuc/sumHO.SumOHoverCnt10.000.900.00%
切入成功率sumHO.SumIHoverSuc/sumHO.SumIHoverCnt10.000.900.0%
切入申請數(shù)sumHO.SumIHoverCnt-1.00 0
切入成功數(shù)sumHO.SumIHOverSuc-1.00 0
切入回切數(shù)sumHO.SumIHORTTOCH-1.00 0
切出成功率sumHO.SumOHoverSuc/sumHO.SumOHoverCnt10.000.900.0%
切出申請數(shù)sumHO.SumOHoverCnt-1.00 0
切出成功數(shù)sumHO.SumOHOverSuc-1.00 0
切出回切數(shù)sumHO.SumOHORTTOCH-1.00 0
SQL考核值(CELLSQI.TSQIGOOD+0.5*CELLSQI.TSQIACCPT)/(CELLSQI.TSQIGOOD+CELLSQI.TSQIACCPT+CELLSQI.TSQIBAD)10.000.800.0%
SQIGOOD%CELLSQI.TSQIGOOD/(CELLSQI.TSQIGOOD+CELLSQI.TSQIACCPT+CELLSQI.TSQIBAD)-1.00 0.0%
SQIACCP%CELLSQI.TSQIACCPT/(CELLSQI.TSQIGOOD+CELLSQI.TSQIACCPT+CELLSQI.TSQIBAD)-1.00 0.0%
SQIBAD%CELLSQI.TSQIBAD/(CELLSQI.TSQIGOOD+CELLSQI.TSQIACCPT+CELLSQI.TSQIBAD)-1.00 0.0%
CS立即指配下發(fā)CCCHLOAD.CSIMMASS-10
CS立即指配拒絕下發(fā)CCCHLOAD.REJCSIMMASS-10
PS立即指配下發(fā)CCCHLOAD.PSIMMASS-10
PS立即指配拒絕下發(fā)CCCHLOAD.REJPSIMMASS-10
尋呼擁塞次數(shù)CELLPAG.PAGPCHCONG100.1 0
尋呼丟棄次數(shù)CELLPAG.PAGETOOOLD100.1 0
下行EPDCH復(fù)用度TRAFDLGPRS.Dltbfpepdch/TRAFDLGPRS.Dlepdch100.00
GPRS下行數(shù)據(jù)速率 (Kbit/s)(CELLQOSG.DLBGGTHR+CELLQOSG.DLTHP1GTHR+CELLQOSG.DLTHP2GTHR+CELLQOSG.DLTHP3GTHR)/(CELLQOSG.DLBGGDATA+CELLQOSG.DLTHP1GDATA+CELLQOSG.DLTHP2GDATA+CELLQOSG.DLTHP3GDATA)-10.00
GPRS上行數(shù)據(jù)速率 (Kbit/s)(CELLQOSG.ULBGGTHR+CELLQOSG.ULTHP1GTHR+CELLQOSG.ULTHP2GTHR+CELLQOSG.ULTHP3GTHR)/(CELLQOSG.ULBGGDATA+CELLQOSG.ULTHP1GDATA+CELLQOSG.ULTHP2GDATA+CELLQOSG.ULTHP3GDATA)-10.00
GPRS上行流量 (MB)(CELLQOSG.ULBGGDATA+CELLQOSG.ULTHP1GDATA+CELLQOSG.ULTHP2GDATA+CELLQOSG.ULTHP3GDATA)/1024/8-10.00
GPRS下行流量 (MB)(CELLQOSG.DLBGGDATA+CELLQOSG.DLTHP1GDATA+CELLQOSG.DLTHP2GDATA+CELLQOSG.DLTHP3GDATA)/1024/8-10.00
EDGE上行流量 (MB)(CELLQOSEG.ULBGEGDATA+CELLQOSEG.ULTHP1EGDATA+CELLQOSEG.ULTHP2EGDATA+CELLQOSEG.ULTHP3EGDATA)/1024/8-10.00
EDGE下行流量 (MB)(CELLQOSEG.DLBGEGDATA+CELLQOSEG.DLTHP1EGDATA+CELLQOSEG.DLTHP2EGDATA+CELLQOSEG.DLTHP3EGDATA)/1024/8-10.00
EDGE下行數(shù)據(jù)速率 (Kbit/s)(CELLQOSEG.DLBGEGTHR+CELLQOSEG.DLTHP1EGTHR+CELLQOSEG.DLTHP2EGTHR+CELLQOSEG.DLTHP3EGTHR)/(CELLQOSEG.DLBGEGDATA+CELLQOSEG.DLTHP1EGDATA+CELLQOSEG.DLTHP2EGDATA+CELLQOSEG.DLTHP3EGDATA)-10.00
EDGE上行數(shù)據(jù)速率 (Kbit/s)(CELLQOSEG.ULBGEGTHR+CELLQOSEG.ULTHP1EGTHR+CELLQOSEG.ULTHP2EGTHR+CELLQOSEG.ULTHP3EGTHR)/(CELLQOSEG.ULBGEGDATA+CELLQOSEG.ULTHP1EGDATA+CELLQOSEG.ULTHP2EGDATA+CELLQOSEG.ULTHP3EGDATA)-10.00
平均分配PDCHCELLGPRS.ALLPDCHACC/CELLGPRS.ALLPDCHSCAN710 0.00
平均占用PDCHCELLGPRS.ALLPDCHACTACC/CELLGPRS.ALLPDCHSCAN-10.00
PDCH利用率(CELLGPRS.ALLPDCHACTACC+CELLGPRS.ALLPDCHSCAN)/(CELLGPRS.ALLPDCHACC+CELLGPRS.ALLPDCHSCAN)-10.00%
下行TBF建立次數(shù)CELLGPRS.DLTBFEST0
下行TBF建立成功率1-CELLGPRS.FAILDLTBFEST/CELLGPRS.DLTBFEST7 0.950.00%
PDCH配置失敗率CELLGPRS.PCHALLFAIL/CELLGPRS.PCHALLATT-10.00%
MOVECELLTBFCELLGPRS.MOVECELLTBF70 0
CELLMOVEDCELLGPRS.CELLMOVED70 0