Power Utilization in E/// 3G

[icebreaker05]

Hi Guys,

Just wanted to ask how to calculate the average transmit power using BO data. In Business Object, pmtransmittedcarrier power is a vector file which generates samples per dBm vector. Now I'm looking for the average power transmitted but i dont know the approach. I have tried weighted average but the value is more than the power. Please help

BR,
Ice



Vector
pmTransmittedCarrierPower


1
0


0
0


11
0


12
0


13
0


2
0


14
0


15
0


16
0


17
0


18
0


19
0


20
0


21
0


22
0


23
0


24
0


3
0


25
0


26
0


27
0


28
0


29
0


30
0


31
0


32
0


33
977


34
7954


35
5719


4
0


36
1946


37
558


38
252


39
194


40
164


41
103


42
69


43
33


44
19


45
10


46
1


5
0


47
1


48
0


49
0


50
0


0
0

[electron]

U have to use weighted average calculation for PDF counters
Hi Guys,

Just wanted to ask how to calculate the average transmit power using BO data. In Business Object, pmtransmittedcarrier power is a vector file which generates samples per dBm vector. Now I'm looking for the average power transmitted but i dont know the approach. I have tried weighted average but the value is more than the power. Please help

BR,
Ice



Vector
pmTransmittedCarrierPower


1
0


0
0


11
0


12
0


13
0


2
0


14
0


15
0


16
0


17
0


18
0


19
0


20
0


21
0


22
0


23
0


24
0


3
0


25
0


26
0


27
0


28
0


29
0


30
0


31
0


32
0


33
977


34
7954


35
5719


4
0


36
1946


37
558


38
252


39
194


40
164


41
103


42
69


43
33


44
19


45
10


46
1


5
0


47
1


48
0


49
0


50
0


0
0

[icebreaker05]

Hi Electron,

Thanks for the info. Please correct me if the formula is wrong. =sumproduct(vector,pmtransmitted)/sum(pmtransmitted)
im getting 34.8 in my calculation. Is it the same as yours?

Thanks

[GrayDog]

in universe create new object :
sum(dc.DC_E_RBS_CARRIER_V_RAW.pmTransmittedCarrierPower*dc.DC_E_RBS_CARRIER_V_RAW.DCVECTOR_INDEX) / sum(dc.DC_E_RBS_CARRIER_V_RAW.pmTransmittedCarrierPower)