Current Cost Support Forum

A support forum for Current Cost users, partners and developers. Covering hardware, software and web.
Site Announcements

The support forum is moderated Monday to Friday, UK time. To submit a support ticket, please email: helpme [at] currentcost .com

It is currently Sun Dec 08, 2024 11:53 pm

All times are UTC [ DST ]




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
PostPosted: Tue Jun 11, 2013 12:34 am 
Offline

Joined: Tue Jun 11, 2013 12:26 am
Posts: 1
Hello all,

I have been working with the CC128 xml schema and have no problems reading \ parsing the data from the unit. I have a really newbie question.

I would like to know, from the live output (6sec pulse) how can i calculate the total kwh for the day \ interval.

Some background, currently I am logging to MySQL the interval pulse and averaging into a minute span. Basically we push the live data into a temp table with the minute rounded down to the pulse minute. Then every minute a service averages the data for that minute and pushes to a live data stream.

At the end of it i will have the average watts per minute in a single row containing all 3 channels seperatly. (Lets assume we only are working with the whole home sensor).

The calculation for watts to Kwh is (as you know) E = P(watts) * T(hr) / 1000

My query is. How do i use the existing data coming from the device. Is the data coming from the device the Kwh for the hour, live watts usage etc. Here is an example of the sql calculation(for one channel)

FORMAT(((AVG(ch1_watts) * p_min) / 1000),2) ch1_watts

(assuming p_in is the total hours in a decimal format for today).

If i haven't added enough information please let me know.

Thanks in advance.

Nico


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group