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)