-
Member
Reputation: 116
Power Utilization in E/// 3G
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 |
-
2013-06-27 07:43 PM
# ADS
Circuit advertisement
-
Re: Power Utilization in E/// 3G
U have to use weighted average calculation for PDF counters
Originally Posted by
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 |
-
Member
Reputation: 116
Re: Power Utilization in E/// 3G
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
-
Member
Reputation: 42
Re: Power Utilization in E/// 3G
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)
Bookmarks