【资料名称】：爱立信KPI指标的各种计算公式，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%
话务量(Celtchf.TFTRALACC+Celtchh.THTRALACC)/Celtchf.TFNSCAN10.00 0.00
每线话务量(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拥塞数CELTCHFP.TFESTPGSMSUB10.0020.000
TCH拥塞率TFESTPGSMSUB/TASSALL10.000.020.00%
TCH指配成功率(CELTCHF.TFCASSALL+CELTCHH.THCASSALL)/CLTCH.TASSATT10.000.900.0%
F话务量Celtchf.TFTRALACC/Celtchf.TFNSCAN-1.00 0.00
H话务量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话务量CLSDCCH.CTRALACC/CLSDCCH.CNSCAN-1.00 0.00
S每线话务量CLSDCCH.CTRALACC/(CLSDCCH.CNSCAN*CLSDCCH.CNUCHCNT)-1.00 0.00
SD分配成功率CELTCHFP.TFCONGPGSM/(RANDOMACC.CNROCNT+RANDOMACC.RAACCFA)0.90
S申请次数CLSDCCH.CCALLS10.00100.000
S指配成功数CLSDCCH.CMSESTAB10.00 0
S拥塞数CLSDCCH.CCONGS10.000.000
S拥塞释放数CLSDCCH.CNRELCONG10.001.000
S掉话数CLSDCCH.CNDROP10.0030.000
F话音接通率Celtchf.TFMSESTB/Celtchf.TFCALLS10.000.900.0%
F申请次数Celtchf.TFCALLS-1.00 0
F指配次数Celtchf.TFMSESTB-1.00 0
F TCH异常率(CELTCHF.TFCALLS-CELTCHF.TFMSESTB-CELTCHF.TFCONGSAS-CELTCHF.TFCONGSHO)/CELTCHF.TFCALLS10.000.100.0%
H申请次数Celtchh.THCALLS-1.00 0
H指配次数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%
指配申请数CLTCH.TASSALL-1.001.000
指配命令数CLTCH.TASSATT-1.001.000
指配成功数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
话务掉话比60*(Celtchf.TFTRALACC+Celtchh.ThTRALACC)/(Celtchf.TFNDROP*Celtchf.TFNSCAN+celtchh.thndrop*celtchh.thnscan)10.00100.000.00
F掉话数Celtchf.TFNDROP-1.00 0
H掉话数CeltchH.THNDROP-1.00 0
总掉话数Celtchf.TFNDROP+CeltchH.THNDROP10.0010.000
总占用数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
上行质差CLTCHDRF.TFDISQAUL+CLTCHDRH.THDISQAUL-1.00 0
下行信号CLTCHDRF.TFDISSDL+CLTCHDRH.THDISSDL-1.00 0
下行质差CLTCHDRF.TFDISQADL+CLTCHDRH.THDISQADL-1.00 0
上下行信号CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSBL-1.00 0
上下行质差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
寻呼应答RANDOMACC.RAANPAG-1.00 0
其它服务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
内切成功率CELEVENTI.HOINSUC/(CELEVENTI.HOINDQA+CELEVENTI.HOINUQA+CELEVENTI.HOINBQA)-1.00 0.0%
上行内切CELEVENTI.HOINUQA10.0030.000
下行内切CELEVENTI.HOINDQA10.0030.000
上下行内切CELEVENTI.HOINBQA10.0030.000
起呼次数TCASSALL0
切换成功率sumHO.SumOHoverSuc/sumHO.SumOHoverCnt10.000.900.00%
切入成功率sumHO.SumIHoverSuc/sumHO.SumIHoverCnt10.000.900.0%
切入申请数sumHO.SumIHoverCnt-1.00 0
切入成功数sumHO.SumIHOverSuc-1.00 0
切入回切数sumHO.SumIHORTTOCH-1.00 0
切出成功率sumHO.SumOHoverSuc/sumHO.SumOHoverCnt10.000.900.0%
切出申请数sumHO.SumOHoverCnt-1.00 0
切出成功数sumHO.SumOHOverSuc-1.00 0
切出回切数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立即指配下发CCCHLOAD.CSIMMASS-10
CS立即指配拒绝下发CCCHLOAD.REJCSIMMASS-10
PS立即指配下发CCCHLOAD.PSIMMASS-10
PS立即指配拒绝下发CCCHLOAD.REJPSIMMASS-10
寻呼拥塞次数CELLPAG.PAGPCHCONG100.1 0
寻呼丢弃次数CELLPAG.PAGETOOOLD100.1 0
下行EPDCH复用度TRAFDLGPRS.Dltbfpepdch/TRAFDLGPRS.Dlepdch100.00
GPRS下行数据速率 (Kbit/s)(CELLQOSG.DLBGGTHR+CELLQOSG.DLTHP1GTHR+CELLQOSG.DLTHP2GTHR+CELLQOSG.DLTHP3GTHR)/(CELLQOSG.DLBGGDATA+CELLQOSG.DLTHP1GDATA+CELLQOSG.DLTHP2GDATA+CELLQOSG.DLTHP3GDATA)-10.00
GPRS上行数据速率 (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下行数据速率 (Kbit/s)(CELLQOSEG.DLBGEGTHR+CELLQOSEG.DLTHP1EGTHR+CELLQOSEG.DLTHP2EGTHR+CELLQOSEG.DLTHP3EGTHR)/(CELLQOSEG.DLBGEGDATA+CELLQOSEG.DLTHP1EGDATA+CELLQOSEG.DLTHP2EGDATA+CELLQOSEG.DLTHP3EGDATA)-10.00
EDGE上行数据速率 (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建立次数CELLGPRS.DLTBFEST0
下行TBF建立成功率1-CELLGPRS.FAILDLTBFEST/CELLGPRS.DLTBFEST7 0.950.00%
PDCH配置失败率CELLGPRS.PCHALLFAIL/CELLGPRS.PCHALLATT-10.00%
MOVECELLTBFCELLGPRS.MOVECELLTBF70 0
CELLMOVEDCELLGPRS.CELLMOVED70 0