HS3 Third Party Current Cost Envi Plugin Released

[Plane_Guy]

I just completed the upgrade on the plugin. For some reason, I have 2 months with a negative total value? It was displaying normal before the upgrade. Can the values be changed?

Sensor Date Usage (kW) Cost ($)
House Energy House Total Wattage
House Energy House Total Wattage April 2017 708.25 kW $77.91
House Energy House Total Wattage March 2017 645.75 kW $71.03
House Energy House Total Wattage February 2017 623.00 kW $68.53
House Energy House Total Wattage January 2017 702.25 kW $77.25
House Energy House Total Wattage December 2016 827.75 kW $91.05
House Energy House Total Wattage November 2016 659.00 kW $72.49
House Energy House Total Wattage October 2016 703.75 kW $77.41
House Energy House Total Wattage September 2016 1409.50 kW $155.05
House Energy House Total Wattage August 2016 1910.25 kW $210.13
House Energy House Total Wattage July 2016 -1968.80 kW ($216.57)
House Energy House Total Wattage June 2016 1887.50 kW $207.63
House Energy House Total Wattage May 2016 1091.25 kW $120.04
House Energy House Total Wattage April 2016 800.25 kW $88.03
House Energy House Total Wattage March 2016 670.50 kW $73.76
House Energy House Total Wattage February 2016 826.50 kW $90.92
House Energy House Total Wattage January 2016 857.75 kW $94.35
House Energy House Total Wattage December 2015 804.50 kW $88.50
House Energy House Total Wattage November 2015 787.75 kW $86.65
House Energy House Total Wattage October 2015 726.50 kW $79.92
House Energy House Total Wattage September 2015 1010.00 kW $111.10
House Energy House Total Wattage August 2015 1721.75 kW $189.39
House Energy House Total Wattage July 2015 2029.00 kW $223.19
House Energy House Total Wattage June 2015 -1824.80 kW ($200.73)
House Energy House Total Wattage May 2015 1499.00 kW $164.89

[mrhappy]

I just completed the upgrade on the plugin. For some reason, I have 2 months with a negative total value? It was displaying normal before the upgrade. Can the values be changed?

Sensor Date Usage (kW) Cost ($)
House Energy House Total Wattage
House Energy House Total Wattage April 2017 708.25 kW $77.91
House Energy House Total Wattage March 2017 645.75 kW $71.03
House Energy House Total Wattage February 2017 623.00 kW $68.53
House Energy House Total Wattage January 2017 702.25 kW $77.25
House Energy House Total Wattage December 2016 827.75 kW $91.05
House Energy House Total Wattage November 2016 659.00 kW $72.49
House Energy House Total Wattage October 2016 703.75 kW $77.41
House Energy House Total Wattage September 2016 1409.50 kW $155.05
House Energy House Total Wattage August 2016 1910.25 kW $210.13
House Energy House Total Wattage July 2016 -1968.80 kW ($216.57)
House Energy House Total Wattage June 2016 1887.50 kW $207.63
House Energy House Total Wattage May 2016 1091.25 kW $120.04
House Energy House Total Wattage April 2016 800.25 kW $88.03
House Energy House Total Wattage March 2016 670.50 kW $73.76
House Energy House Total Wattage February 2016 826.50 kW $90.92
House Energy House Total Wattage January 2016 857.75 kW $94.35
House Energy House Total Wattage December 2015 804.50 kW $88.50
House Energy House Total Wattage November 2015 787.75 kW $86.65
House Energy House Total Wattage October 2015 726.50 kW $79.92
House Energy House Total Wattage September 2015 1010.00 kW $111.10
House Energy House Total Wattage August 2015 1721.75 kW $189.39
House Energy House Total Wattage July 2015 2029.00 kW $223.19
House Energy House Total Wattage June 2015 -1824.80 kW ($200.73)
House Energy House Total Wattage May 2015 1499.00 kW $164.89

How strange - the fact it appears in () also points to it coming from the database as a negative value because when I put the string into the currency format it is representing it as a negative number.

Could you zip up your cc.db3 (in the root HS path) and send it to me? Attach it to a post here if you're OK with it (no personal data in it) or send it via email and I'll have a look. I can change it in the DB but would need to check whether or not when new data arrives it gets overridden.

[Plane_Guy]

So I downloaded a SQLLite DB. This allowed me to open the DB and change the negative values. Weird how it was a negative value!

[mrhappy]

So I downloaded a SQLLite DB. This allowed me to open the DB and change the negative values. Weird how it was a negative value!

Yes I had a look and was going to change the values for you, it is odd why these two are negative values out of all of the positive ones. The data should be downloaded every couple of hours into the database so keep an eye out whether or not they re-appear. If so I'll put a line in the code that it is always a positive number.

[Plane_Guy]

It's reverted back to negative? After I made the change, I verified all the values through the plugin. Now today they are back to negative! I'm going to update them again and see if it happens again.

[mrhappy]

It's reverted back to negative? After I made the change, I verified all the values through the plugin. Now today they are back to negative! I'm going to update them again and see if it happens again.

Yeah I feared this, what it is is the data in that history table is updated from the Current Cost device every couple of hours. As such any changes would only be temporary (it was worth just seeing if changing it solved it though) - as such it must be coming from the hardware with a negative value. Not something I've seen before and I've been messing with the Current Cost hardware the best part of 10 years now.

That said I can make a change to the plugin if it finds a negative number to make it positive - although I can't easily test it, can you try this version please? Just replace your exe file and restart HS. If it works I'll put it in the updater.

[Plane_Guy]

You were correct, it came back!. I copied the new EXE in a restarted. The negative values still appeared. So I went back in and did another edit on the data. I will let you know tomorrow how it goes.

[Plane_Guy]

I wanted to report back that everything looked good this morning. I'm not seeing any negative values.

[mrhappy]

I wanted to report back that everything looked good this morning. I'm not seeing any negative values.

Excellent thanks I'll put it in the updater and hopefully you don't see anything like this again, if you do let me know.

[langenet]

Ok... so after putting a chunk of time into drivers (which I already had, having found that 3.2 was the driver to use), it turns out that driver clearly doesnt want to work correctly on Windows 10.

So I've now 'updated' with this driver:

http://www.ifamilysoftware.com/news37.html

And its now working it seems.

Thanks for your help.

I'm about to upgrade my server from Win2k3 to Win2k16. Does anyone know if this driver works with 2016 Server or can someone recommend the proper drivers please? It is Prolific drivers that CCE uses right and not FTDI right? It's been so long since I installed this thing...

Robert

[langenet]

I just wanted to confirm that these drivers also work with Windows Server 2016.

Thanks VMark for doing all the leg work.

Robert

[chocolat89]

night and day rates

Hello,
i am moving from hs2 to hs3
i cannot find any rates tables on the hs3 plugin, just need to get different rate kw price for night and day.
Thank you

[mrhappy]

Hello,
i am moving from hs2 to hs3
i cannot find any rates tables on the hs3 plugin, just need to get different rate kw price for night and day.
Thank you

I didn't include this in the HS3 plugin, it was always a bit difficult in terms of working in HS2 that I remember. I am afraid if you need this functionality you would probably need to look at the HS Current Cost plugin as this potentially has this functionality in it.

[chocolat89]

thank you mr happy for your fast reply but the hs current cost don't work (include beta)

[mrhappy]

thank you mr happy for your fast reply but the hs current cost don't work (include beta)

That's unfortunate (it has been some time since I tried it) and development of that plugin seems to have stopped, I am afraid for the limited (you are the first to ask I think) demand for this does not justify the time it would take to develop and add it to the plugin. You could however look at calling the cc.db3 file directly from a script and making your own cost calculations, I don't however have an example script you could try.