-
Member
Reputation: 192
DL Code Utilization HS and Non HS Formula
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
-
2016-02-16 03:53 PM
# ADS
Circuit advertisement
-
Member
Reputation: 95
Re: DL Code Utilization HS and Non HS Formula
-
VIP Member
Reputation: 1791
Re: DL Code Utilization HS and Non HS Formula
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 Default PAS: london
pl rate threads for their usefulnes
share & care
-
Post Thanks - 2 Thanks
-
VIP Member
Reputation: 1791
Re: DL Code Utilization HS and Non HS Formula
use can use the above given example(its ofr HS codes) for Power, RSSI, or any other Pdf counter available in E///.
Auto_art Default PAS: london
pl rate threads for their usefulnes
share & care
-
Post Thanks - 1 Thanks
-
VIP Member
Reputation: 1791
Re: DL Code Utilization HS and Non HS Formula
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 |
Auto_art Default PAS: london
pl rate threads for their usefulnes
share & care
-
Post Thanks - 1 Thanks
-
Member
Reputation: 192
Re: DL Code Utilization HS and Non HS Formula
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
-
Re: DL Code Utilization HS and Non HS Formula
Hi please upload the excel file if you have.
Bookmarks