how do i calculate energy consumed in excel?

[toffee_pie]

hi folks,

i have calculated power, current and power. i would like to plot graphs
of energy consumed vs time. i need to integrate the power to get this?

any help?

thanks

eric

 

[Bernard Liengme]

See http://www.stfx.ca/people/bliengme/ExcelTips/AreaUnderCurve.htm
How to find area under curve and notes on integration

 

[toffee_pie]

ok, thanks for that,

area under curve is the same as energy?
i have x values (time) and y values (power),so i can use the trapezoid
rule to get the area ?
or do i need to use integration ??

abit confused here!

 

[Bernard Liengme]

Hey! this is an Excel site!! (grin)
Energy is Integral of <power * d(time)>
A definite integral is the area under a curve.
I think you need to do a little reading. Is this a homework assignment?
all the best

 

[toffee_pie]

hi bud,

its a final year uni proj!

well, i have most of the work done, im working on power consumption of
wireless sensore networks, and a 25mm mote we developed.
so basically, i have alot of data, like power, time, current.
etc.
so i would like to plot energy vs time, for particular settings, like
0dBm, 20dBm, etc.

so i will have time going from say, 0 to 30 mins, and also power going
from 0 to 30 mins.
i integrate the power all the way down?!

just not much good with excel really......