RFXPower usage power graphs and scripts

[connoleg]

I have installed an RFXPower monitor into my system which uses a CT to measure power usage and sends data wirelessly back to HS via ACRF. To make use of the data I have set about creating a database and some graphs. On the list are:

• Hourly usage
• Hourly cost
• Daily usage & cost - last seven days
• Daily usage & cost - last 31 days
• CO2 output caused by my usage

I have created access database (temperature.mdb) with fields id, ctime, cdate, reading, lusage, lcost and sensor.

I have created a script (tempdb.txt) with the help of Rupp and Jon00 that reads the value from the RFXPower sensor, calculates usage and cost and inserts id (auto), ctime, cdate, reading and sensor into the database on a half-hourly basis scheduled in HS2

For the graphing side of things I have installed Kavachart, a java graphing applet as recommended by Jon00 and amended the example asp script (tempchart2.asp) to create the daily usage (kwh) and cost (pence) graph page. I am really pleased with the output (see below)

I now want to be able to create the daily usage 7 & 31 days but dont know how to go about the sql side of things to extract 7 and 31 days from the database.

Please help yourself to the attached files if they are any use.

Any help would be appreciated

regards
Gary

[stipus]

WHERE dateField BETWEEN 'date1' AND 'date2'

[ea_automation]

Really neat.
I'm Java illiterate. How do I install Kavachart? I've been looking for something like that.

[darren-mc]

This looks awesome...well done...looking forward to getting my power monitor now!

[connoleg]

Really neat.
I'm Java illiterate. How do I install Kavachart? I've been looking for something like that.

Hi,
To install, just download from the link below and extract to your html directory. It should be like this: c:\ program files\ Homeseer2\ html\ javachart\ (depending where your Homeseer is installed).

I used the online chartwizard to play with the settings and get the parameters for the asp page. The chartwizard is accessed from the index web page in the javachart directory you just extracted.

http://homepage.ntlworld.com/g.connoley/javachart.zip

Gary

[darren-mc]

Gary,
Have you got any further with this one?

Cheers,

Darren

[connoleg]

Gary,
Have you got any further with this one?

Cheers,

Darren

Sure have. I've restructured the scripts and database. The Historical graphs (31 days) are now complete. I'll upload them a bit later.

regards
Gary

[darren-mc]

Sounds excellent..looking forward to giving it a try.

Thanks

Darren

[connoleg]

Power Usage update

Here is the latest update. Ive added two extra graphs to show usage and cost for previous 31 days.

To install:
copy scripts to the scripts directory
copy powercharts.asp to the html directory
copy powermonitor.mdb to the data directory in root of HS (you might need to create this directory)

Here is the link to Kava Charts again http//homepage.ntlworld.com/g.connoley/javachart.zip

setup one event that runs the PowerMonUpdate.txt script every 60 mins with reference to the hour and the other to run the PowerMonDayTotals.txt at 00:30 everyday.

Have fun. Feedback would be welcomed.

Gary

[rmasonjr]

Hi,
To install, just download from the link below and extract to your html directory. It should be like this: c:\ program files\ Homeseer2\ html\ javachart\ (depending where your Homeseer is installed).

I used the online chartwizard to play with the settings and get the parameters for the asp page. The chartwizard is accessed from the index web page in the javachart directory you just extracted.

http://homepage.ntlworld.com/g.connoley/javachart.zip

Gary

kavachart is awesome - it will generate the applet code for you with that chart wizard. We actually use it where I work to create some slick graphs.

[simonog]

Installed my RFXPower this week.

wow it is just phenomenal!

I think it will encourage me to manage my electricity bill in a quite different way....

Simon

[simonog]

I just set this software up - it's cool too!

the installed database seems to have some readings data from December.

how do i simply clear it so i am starting with my own readings only?

[connoleg]

I just set this software up - it's cool too!

the installed database seems to have some readings data from December.

how do i simply clear it so i am starting with my own readings only?

Simon,

If you have MS access then just open then the database then the sensor_data table and delete all rows. The other tables are emptied by the PowerMonDayTotals.txt script each time it runs. I've attached an empty version of the database if you prefer to use that. Just unzip and rename to PowerMonitor.mdb

Gary

[simonog]

Thank you - I used Access as i have it and it worked fine.

Just wanted to make sure I was doing the right thing, and also avoid others falling into same trap.

now I have an interesting issue. may be 2 though they feel as if connected.

1. In the log, i often get this message when i display the charts:

<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime1 noWrap align=left>14/01/2007 12:03:14 </TD><TD class=LOGType1 align=left colSpan=3>Error </TD><TD class=LOGEntry1 align=left colSpan=8>Web Server Error 404, cannot serve file: C:\Program Files\HomeSeer 2\html/applet.columnApp.jar</TD></TR></TBODY></TABLE>

2. When i display the charts (with my first day's data!) they all appear to be overflowing the scales. i printed the readings from the middle of your .asp to see if there were any silly values: they all look reasonable viz:

<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime0 noWrap align=left>14/01/2007 12:07:56 </TD><TD class=LOGType0 align=left colSpan=3>sjog dbg </TD><TD class=LOGEntry0 align=left colSpan=8>0,5.75,3.49,3.58,3.57,4.18,4.53,4.84,4.07,4.06,4.5 2,4.27,4.28,</TD></TR></TBODY></TABLE>

I think I have attached a screen print of the charts I am getting

Simon

[connoleg]

Thank you - I used Access as i have it and it worked fine.

Just wanted to make sure I was doing the right thing, and also avoid others falling into same trap.

now I have an interesting issue. may be 2 though they feel as if connected.

1. In the log, i often get this message when i display the charts:

<table border="0" cellpadding="0" cellspacing="2" width="100&#37;"><tbody><tr><td class="LOGDateTime1" align="left" nowrap="nowrap">14/01/2007 12:03:14 </td><td class="LOGType1" colspan="3" align="left">Error </td><td class="LOGEntry1" colspan="8" align="left">Web Server Error 404, cannot serve file: C:\Program Files\HomeSeer 2\html/applet.columnApp.jar</td></tr></tbody></table>

2. When i display the charts (with my first day's data!) they all appear to be overflowing the scales. i printed the readings from the middle of your .asp to see if there were any silly values: they all look reasonable viz:

<table border="0" cellpadding="0" cellspacing="2" width="100%"><tbody><tr><td class="LOGDateTime0" align="left" nowrap="nowrap">14/01/2007 12:07:56 </td><td class="LOGType0" colspan="3" align="left">sjog dbg </td><td class="LOGEntry0" colspan="8" align="left">0,5.75,3.49,3.58,3.57,4.18,4.53,4.84,4.07,4.06, 4.52,4.27,4.28,</td></tr></tbody></table>

I think I have attached a screen print of the charts I am getting

Simon

For your installation you need to ammend the Powercharts.asp file and adjust the min and max yaxis values. Mine are:

param name=yAxisStart value="0.0"
param name=yAxisEnd value="1.0"

I would suggest you need something like 0.0 and 6.0 looking at your data.
You can delete those two lines and the graphs will auto scale but in my experience setting them to your max and min values looks much better.

I'll look at the log error and get back to you

Gary