Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
toffee_pie
 
Posts: n/a
Default how do i calculate energy consumed in excel?


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


--
toffee_pie
------------------------------------------------------------------------
toffee_pie's Profile: http://www.excelforum.com/member.php...o&userid=31944
View this thread: http://www.excelforum.com/showthread...hreadid=516666

  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default how do i calculate energy consumed in excel?

See http://www.stfx.ca/people/bliengme/E...UnderCurve.htm
How to find area under curve and notes on integration
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"toffee_pie" wrote
in message ...

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


--
toffee_pie
------------------------------------------------------------------------
toffee_pie's Profile:
http://www.excelforum.com/member.php...o&userid=31944
View this thread: http://www.excelforum.com/showthread...hreadid=516666



  #3   Report Post  
Posted to microsoft.public.excel.misc
toffee_pie
 
Posts: n/a
Default how do i calculate energy consumed in excel?


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!


--
toffee_pie
------------------------------------------------------------------------
toffee_pie's Profile: http://www.excelforum.com/member.php...o&userid=31944
View this thread: http://www.excelforum.com/showthread...hreadid=516666

  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default how do i calculate energy consumed in excel?

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
--
Bernard V Liengme (ex-professor)
www.stfx.ca/people/bliengme
remove caps from email

"toffee_pie" wrote
in message ...

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!


--
toffee_pie
------------------------------------------------------------------------
toffee_pie's Profile:
http://www.excelforum.com/member.php...o&userid=31944
View this thread: http://www.excelforum.com/showthread...hreadid=516666



  #5   Report Post  
Posted to microsoft.public.excel.misc
toffee_pie
 
Posts: n/a
Default how do i calculate energy consumed in excel?


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......


--
toffee_pie
------------------------------------------------------------------------
toffee_pie's Profile: http://www.excelforum.com/member.php...o&userid=31944
View this thread: http://www.excelforum.com/showthread...hreadid=516666

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
how to calculate the hours and minutes in excel Mital Excel Discussion (Misc queries) 3 February 14th 06 06:49 PM
how to calculate surface area in excel chart k Charts and Charting in Excel 1 January 18th 06 03:07 PM
How do I calculate a MTD total - yesterdays sales in Excel? skcaton Excel Worksheet Functions 0 August 11th 05 02:59 PM


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"