DL Code Utilization HS and Non HS Formula

[Ghost78]

Dears;

I'm looking for DL code utilization formula 'E/// Vendor', I searched for it everywhere, but no result, even in this forum, please if someone has the right formula or any doc explaining how to calculate the utilization, I'll be very gratefull.

B.R

[gunpowder]

any updates for this ?

[auto_art]

select wcel_int_id,p.timeslice_id,sum(pmSumDlCode),sum(pmSamplesDlCode),
if(sum(pmSamplesDlCode)=0,0,sum(pmSumDlCode)/sum(pmSamplesDlCode))*(16-h.numHsPdschCodes)/100 DL_COD_USED_EXCLUDING_HS_RESERVED,
if(sum(pmUsedHsPdschCodes0+pmUsedHsPdschCodes1+pmUsedHsPdschCodes2+pmUsedHsPdschCodes3+pmUsedHsPdschCodes4+pmUsedHsPdschCodes5+pmUsedHsPdschCodes6+pmUsedHsPdschCodes7+pmUsedHsPdschCodes8+pmUsedHsPdschCodes9+pmUsedHsPdschCodes10+pmUsedHsPdschCodes11+pmUsedHsPdschCodes12+pmUsedHsPdschCodes13+pmUsedHsPdschCodes14+pmUsedHsPdschCodes15)=0,0,
(Sum(pmUsedHsPdschCodes0)*0+Sum(pmUsedHsPdschCodes1)*1+Sum(pmUsedHsPdschCodes2)*2+Sum(pmUsedHsPdschCodes3)*3+Sum(pmUsedHsPdschCodes4)*4+Sum(pmUsedHsPdschCodes5)*5+Sum(pmUsedHsPdschCodes6)*6+Sum(pmUsedHsPdschCodes7)*7+Sum(pmUsedHsPdschCodes8)*8+Sum(pmUsedHsPdschCodes9)*9+Sum(pmUsedHsPdschCodes10)*10+Sum(pmUsedHsPdschCodes11)*11+Sum(pmUsedHsPdschCodes12)*12+Sum(pmUsedHsPdschCodes13)*13+Sum(pmUsedHsPdschCodes14)*14+Sum(pmUsedHsPdschCodes15)*15)/sum(pmUsedHsPdschCodes0+pmUsedHsPdschCodes1+pmUsedHsPdschCodes2+pmUsedHsPdschCodes3+pmUsedHsPdschCodes4+pmUsedHsPdschCodes5+pmUsedHsPdschCodes6+pmUsedHsPdschCodes7+pmUsedHsPdschCodes8+pmUsedHsPdschCodes9+pmUsedHsPdschCodes10+pmUsedHsPdschCodes11+pmUsedHsPdschCodes12+pmUsedHsPdschCodes13+pmUsedHsPdschCodes14+pmUsedHsPdschCodes15))
as HS_USED_CODES,
h.numHsPdschCodes,
if(sum(pmSamplesDlCode)=0,0,sum(pmSumDlCode)/sum(pmSamplesDlCode))*(16-h.numHsPdschCodes)/100+if(if(sum(pmUsedHsPdschCodes0+pmUsedHsPdschCodes1+pmUsedHsPdschCodes2+pmUsedHsPdschCodes3+pmUsedHsPdschCodes4+pmUsedHsPdschCodes5+pmUsedHsPdschCodes6+pmUsedHsPdschCodes7+pmUsedHsPdschCodes8+pmUsedHsPdschCodes9+pmUsedHsPdschCodes10+pmUsedHsPdschCodes11+pmUsedHsPdschCodes12+pmUsedHsPdschCodes13+pmUsedHsPdschCodes14+pmUsedHsPdschCodes15)=0,0,
(Sum(pmUsedHsPdschCodes0)*0+Sum(pmUsedHsPdschCodes1)*1+Sum(pmUsedHsPdschCodes2)*2+Sum(pmUsedHsPdschCodes3)*3+Sum(pmUsedHsPdschCodes4)*4+Sum(pmUsedHsPdschCodes5)*5+Sum(pmUsedHsPdschCodes6)*6+Sum(pmUsedHsPdschCodes7)*7+Sum(pmUsedHsPdschCodes8)*8+Sum(pmUsedHsPdschCodes9)*9+Sum(pmUsedHsPdschCodes10)*10+Sum(pmUsedHsPdschCodes11)*11+Sum(pmUsedHsPdschCodes12)*12+Sum(pmUsedHsPdschCodes13)*13+Sum(pmUsedHsPdschCodes14)*14+Sum(pmUsedHsPdschCodes15)*15)/sum(pmUsedHsPdschCodes0+pmUsedHsPdschCodes1+pmUsedHsPdschCodes2+pmUsedHsPdschCodes3+pmUsedHsPdschCodes4+pmUsedHsPdschCodes5+pmUsedHsPdschCodes6+pmUsedHsPdschCodes7+pmUsedHsPdschCodes8+pmUsedHsPdschCodes9+pmUsedHsPdschCodes10+pmUsedHsPdschCodes11+pmUsedHsPdschCodes12+pmUsedHsPdschCodes13+pmUsedHsPdschCodes14+pmUsedHsPdschCodes15))> h.numHsPdschCodes,h.numHsPdschCodes,
if(sum(pmUsedHsPdschCodes0+pmUsedHsPdschCodes1+pmUsedHsPdschCodes2+pmUsedHsPdschCodes3+pmUsedHsPdschCodes4+pmUsedHsPdschCodes5+pmUsedHsPdschCodes6+pmUsedHsPdschCodes7+pmUsedHsPdschCodes8+pmUsedHsPdschCodes9+pmUsedHsPdschCodes10+pmUsedHsPdschCodes11+pmUsedHsPdschCodes12+pmUsedHsPdschCodes13+pmUsedHsPdschCodes14+pmUsedHsPdschCodes15)=0,0,
(Sum(pmUsedHsPdschCodes0)*0+Sum(pmUsedHsPdschCodes1)*1+Sum(pmUsedHsPdschCodes2)*2+Sum(pmUsedHsPdschCodes3)*3+Sum(pmUsedHsPdschCodes4)*4+Sum(pmUsedHsPdschCodes5)*5+Sum(pmUsedHsPdschCodes6)*6+Sum(pmUsedHsPdschCodes7)*7+Sum(pmUsedHsPdschCodes8)*8+Sum(pmUsedHsPdschCodes9)*9+Sum(pmUsedHsPdschCodes10)*10+Sum(pmUsedHsPdschCodes11)*11+Sum(pmUsedHsPdschCodes12)*12+Sum(pmUsedHsPdschCodes13)*13+Sum(pmUsedHsPdschCodes14)*14+Sum(pmUsedHsPdschCodes15)*15)/sum(pmUsedHsPdschCodes0+pmUsedHsPdschCodes1+pmUsedHsPdschCodes2+pmUsedHsPdschCodes3+pmUsedHsPdschCodes4+pmUsedHsPdschCodes5+pmUsedHsPdschCodes6+pmUsedHsPdschCodes7+pmUsedHsPdschCodes8+pmUsedHsPdschCodes9+pmUsedHsPdschCodes10+pmUsedHsPdschCodes11+pmUsedHsPdschCodes12+pmUsedHsPdschCodes13+pmUsedHsPdschCodes14+pmUsedHsPdschCodes15))
) as TOTAL_DL_USED_CODES
from p_generic_cell_3g p, c_hsdsch h, objects o
where h.int_id = o.int_id and o.parent_int_id = p.wcel_int_id
--and p.timeslice_id = 23
group by wcel_int_id,timeslice_id

[auto_art]

use can use the above given example(its ofr HS codes) for Power, RSSI, or any other Pdf counter available in E///.

[auto_art]

Another Example Since those counter are PDF, hence we will get number of sample for each array (0 - 51).

Here it is the example:

if the counter gives the value as follow

[0] 0

[1] 10

[2] 15

[3] 20

and so on..

This means that there 0 samples that uses < 0dbm , 10 samples using 1 dbm, 15 samples using 2 dbm, 20 samples using 3 dbm and so on...

from here you can use put on excel and then use the percentile 90 formula on excel.

After you get the percentile 90 for HS or Non HS you can compare it to counter maxDlPowerCapability.

Here it is the formula to find the utilization

Power HS =(10^(perc90(pmTransmittedCarrierPowerHs)/10))/(10^(maxDlPowerCapability/100))*100

Power non HS =(10^(perc90(pmTransmittedCarrierPowerNonHs)/10))/(10^(maxDlPowerCapability/100))*100

Note: The counter is cell base. I usually have the counter average per ROP and max per Hour then max from each hour to get the daily used.

Please find the excel in order to get more understanding on the array and or pdf counter

Thanks and hope it helps you

[Ghost78]

Hi auto_art;

this is exactly waht I'm looking for to calculate power utilizaiton, please can you share the excel file you mentioned in above message, I want to see the steps of calculation

B/R

[uchok]

Hi please upload the excel file if you have.