Using mcsTemperature to track energy usage

[Mario from Spain]

When I access your site I see mcsTempeatue 4.36.0 is running. 4.36.1 is the one where the counter setup was corrected. I also connected a counter with a clean ini file with 4.36.2 and it correctly discovered wind/gust/flow/flow rate and no extra device as you were showing with 4.36.0.

Opps! I don't know when/how I rolled back to 4.36.0

[Mario from Spain]

After updating to 4.36.1 I deleted all entries rellated to 1-wire in [Database] and [Devices] then the Devices in HS, then entered into the mcsTemperature's setup, and changed the devices to que correct types.

I had some issues with the values not showing right so as it was difficult to do it in remote I decided to postpone it until sunday do to it locally.

I reverted to the old mcsTemperature.ini and restarted but it was loosing track of the historical Wattages I deleted the devices in HS and entered setup for it to create them again. No way, the historical data was lost and the counters where counting from zero.

In the ini there was an entry (the good one):
watt_history=;;232,2581;;275893;23/04/2005 12:31:14;272789

but mcsTemperature created and was using:
History_]34=;;0;;276104;23/04/2005 13:22:39;276100

I deleted the History_]34 entry I started HS again, etc. but no matter what I do it keeps creating the History_]34 entry and starting over again.

I ended copying values from watt_history into History_]34 and it's working again.

How does mcsTemperature knows what hystory to use? I can't find how it's rellated.

Uff, this configuration is getting complex!!

[Michael McSharry]

Prior to upgrade to handle multiple counters there was one history ini entry for each function. Now there is a history key for each counter device code. This will allow multiple wattage counters or multiple water flow counters. This means that if the device code is changed the history information is created for the new device code and the old history associated with the prior device is no longer used.

In your sample below then data format has not changed, but the name of the key has. You can go back and forth between the versions by copying the content of one key and replacing the other. In this case if you are running with 4.36.1 or later then your desired key value is

History_]34=;;232,2581;;275893;23/04/2005 12:31:14;272789

based upon the prior values below. The key only contains current day information so at midnight it will restart the count again. This means this ini edit technique needs to be applied at the time of the change of device codes for it to be of any value. The edit can be done when HS is runnings since this ini key is read at each computation cycle.

In the ini there was an entry (the good one):
watt_history=;;232,2581;;275893;23/04/2005 12:31:14;272789

but mcsTemperature created and was using:
History_]34=;;0;;276104;23/04/2005 13:22:39;276100

[Spawn]

I seem to have the same problem,only a water rate counter shows, have tryed most of the tricks in this thread, but nothing seems to work :/ to be shure i have conected both the counters together so the should have the same reading... when i check the Temp08 it shows the counter with an "L" so it is correctly set up ther, and works with direct comport scripting.. but i want all the Charting stuff that is in MCS Temp heres my INI file..

PS! I am using the latest MCS Temp from the updater.

Best Regards
Morten

[Michael McSharry]

I'm not understanding what problem you are having. I think the Temp08 will return one counter from the DS2423 and you indicate it is configured as "L". This will be defaulted by mcsTempeature as what I believe is water flow. If you want it to be a wattage counter then the type is changed from the GUI pulldown to be wattage.

[Spawn]

Hmm... I think i tested that, but after a min or so it recreates the water rate sensors and starts complaing about it having dubble senssors names like 2 times xxxxDC or xxxxDN,,, but i can test agian, witch of the sessors xxxxDN and xxxxDC should be Wattage Rate and witch should be Wattage Today ?


Thanks for your help

[Michael McSharry]

Replace your ini file with the attached when HS is not running. The changes were in 4 lines that contained the DS2423 serial number. I'm on the road so I cannot test.

[Spawn]

Tested, new counter shows up like wattaged today and wattage rate, but its alway zero,
and after 1 or 2 min it makes the water sensors again, but still not updating the wattaged..

but the water flow and water flow rate is counting :/



26.04.2006 10:54:29 - mcsTemperature - Sensor 14000000074FDE1D is known to Temp05 as type DS2423 N but known by mcsTemperature as type 7
26.04.2006 10:58:19 - mcsTemperature - Creating database fields s14000000074FDE1DN in C:\Program Files\HomeSeer\mcsTemperature.mdb\Temperature
26.04.2006 10:58:19 - Database Item - Saving Device Water Flow Rate 14000000074FDE1DC
26.04.2006 10:58:19 - mcsTemperature - Creating database fields s14000000074FDE1DC in C:\Program Files\HomeSeer\mcsTemperature.mdb\Temperature


and the Temp08 IO shows like it should in the IO Stream :

Voltage #01[960000004CE09226]=00.36V 05.03V
Lightning #01[14000000074FDE1D]=23372 <--------------
Temp #01[960000004CE09226]=21.56C
Temp #02[AA00080013174A10]=28.75C
Temp #03[B500080013163710]=22.06C
Temp #04[56000800132F2D10]=23.18C


this is what the ini files shows after som min's :


[Group]
Default="None","LinSel","^1"-1,"^2"-1,"^3"-1,"^4"-1,"`44"-1,"`45"-1,"^44"-1,"^45"-1,"^67"-1
[Devices]
960000004CE09226V="^67,02:01,,0,0"
960000004CE09226A="^68,00:01,,0,0"
960000004CE09226="^1,02:01,,0,0"
AA00080013174A10="^2,03:02,,0,0"
B500080013163710="^3,04:03,,0,0"
56000800132F2D10="^4,05:04,,0,0"
14000000074FDE1D7="^44,01:01,,,0"
14000000074FDE1D8="^45,01:01,,,0"
14000000074FDE1DN="`44,01:01,,0,0"
14000000074FDE1DC="`45,01:01,,0,0"
14000000074FDE1D=",01:0,,,0"
[Database]
^67="s960000004CE09226V,20,1"
^68="s960000004CE09226A,21,1"
^1="s960000004CE09226,0,1"
^2="sAA00080013174A10,0,1"
^3="sB500080013163710,0,1"
^4="s56000800132F2D10,0,1"
^44="s14000000074FDE1D7,31,1"
^45="s14000000074FDE1D8,32,1"
`44="s14000000074FDE1DN,29,1"
`45="s14000000074FDE1DC,30,1"
[LastState]
S^45=2
S`45=3

[Michael McSharry]

It is awkward to debug when I'm traveling, but it does appear something is not correct. If you dont mind then could you enabled the general debug and restore the ini file to the one that I posted and collect data until the water sensor appears. Post the hs log with the debug.

[Bestgear]

Counter question...

Guys.... sorry for resurecting an old thread....

What happens when the counter in the DS2423 hits its max count of 65535?

I assume that causes a blip in the graph, or is there some code to just track delta and copes with the sudden jump back to zero?

DJ

[Michael McSharry]

I did not look at the code but I suspect on a wraparound the delta count between two readings will show negative and be limited to 0 so the energy used during this period will be lost. On the average this will be the amount used in 1/2 of your update cycle which will typically be a few minutes of energy consumptions every 64K counts.

[aiqy65]

[quote=Spawn;709471]Hmm... I think i tested that, but after a min or so it recreates the water rate sensors and starts complaing about it having dubble senssors names like 2 times xxxxDC or xxxxDN,,, but i can test agian, witch of the sessors xxxxDN and xxxxDC should be Wattage Rate and witch should be Wattage Today ?


I have having exactly the same problem and can not figure out where to go from here. What was the final answer to this one?

Thanks
Lee

[Michael McSharry]

The 7 Suffix is Wattage Today, the 8 is Wattage Rate.
Other counter options are
N=Water Flow, C=Water Flow Rate
W=Wind Speed, G=Wind Gust
R=Rain Today, E=Rain Rate
L=Lightning Today, 9=Lightning Rate

A DS2423 contains two counters so one device will have 4 Device Codes. I do not think mcsTemperature lets the same device's counters be used for the same purpose (e.g. only 1 wind speed within a single DS2423). The Temp05/08 only makes one of the two DS2423 counters available and it will appear as the 1st two of the four. I do not recall if I show the second two devices when it comes from the Temp05/08. Even if you are only using the second counter from the DS2423 you should define the first two devices to be something else and then hide the created devices. For example if you are counting wattage in counter 2 and have nothing connected to counter 1 then set mcsTemperature to something like Water Flow and Water rate for the first counter's type.

[aiqy65]

Thanks for that.

I changed the discovered water devices to power and it recreated them again.
The following is in my "ini" (temp devices removed)

[Devices]
5500000009EB711D7="R1,01:01, 0,,0"
5500000009EB711D8="R2,01:01, 0,,0"
5500000009EB711DN="R10,01:01, 0,0,0"
5500000009EB711DC="R11,01:01, 0,0,0"

[Database]
R1="s5500000009EB711D7,31,1"
R2="s5500000009EB711D8,32,1"
R10="s5500000009EB711DN,29,1"
R11="s5500000009EB711DC,30,1"

Everything appears as I think it should but I am not getting anything being added to the database. Got the colums but no data.

The following errors are showing up in the HS log

<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime1 noWrap align=left>14/05/2007 16:32:56 </TD><TD class=LOGType1 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry1 align=left colSpan=8>Log_Temperature: on line 610 Overflow</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>14/05/2007 16:33:55 </TD><TD class=LOGType0 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry0 align=left colSpan=8>ComputeWaterCount: on line 1360 Overflow</TD></TR></TBODY></TABLE>

Please point in the direction of the plainly obvious thing I am missing.
At the bottom is my full .ini file

Many thanks
Lee

[Temperature]
License=120.70.83.80.65.65.85
WeedLastDays=180
WeedMaxInterval=60
WeedFirstDays=0
RainCalibration="1"
WaterFlowCalibration="1"
WattCalibration="1"
RainCalibrationRate="0.2"
WaterFlowCalibrationRate="0.4"
WattCalibrationRate="1.0"
WindCalibration="1"
RelayCommandDelay="250"
WDTString=""
iconPixels="16"
UseRelay05=0
StoreRelay1=0
StoreRelay2=0
StoreRelay3=0
StoreRelay4=0
StoreRelay5=0
StoreRelay6=0
StoreRelay7=0
StoreRelay8=0
ReverseColorScale=0
RetainSettingByClient=0
InMenu=1
forceHumidityScale=0
UseHTML=0
OnlyTemperatureIcon=0
alwaysShowGraph=0
UseForecast=0
UseDatabase=1
csvDelete=0
csvDelete2=0
csvDelete3=0
HumidityCal=0
NormalPriority=0
UseCSV=0
UseCSV2=0
UseCSV3=0
UseWeatherPLUG=0
AverageSites=0
UseTemp05=1
ShowRawData=0
UseQuasar=0
UseWeatherXMLFile=0
UseWeatherXMLSite=0
UseDS9097=0
MetricInTemp=1
MetricTemp=1
MetricBaro=0
MetricWind=0
ReverseWind=0
MetricRain=1
EnableTriggers=1
DisableWindow=0
AlarmingSwitches=0
UseSQL=0
SQLSource=""
SlowWeight=""
FastWeight=""
showTemperatureDataPoints=0
ConnectDots=0
LimitHumidity=0
IncludeHumidity35=0
excludeHeaderAndFooter=0
ShowOnlyDeviceName=0
CompatibilityMode=0
AllowLocalHostForTouchscreen=0
Temp05Version5=1
DebugLog=0
DebugLog2=0
VersionAfter416OrUsingV1=1
usePreviousOnBadReadings=1
NorthDirection="0"
DSPort=""
QuasarPort=""
Temp05CommPort="2"
StyleSheet="StyleNoBody.css"
Database="mcsTemperature.mdb"
TemperatureTable="Temperature"
DateFieldName="SampleDate"
TemperatureFieldPrefix="R"
DataCollectionInterval=5
LegendHeight="35"
LegendLeft="55"
TemperatureHouse="R"
decimalCharacter="."
Version_Id=""
GUIColor="gray"
TextColor="gray"
ForecastLowColor="Black"
ForecastHighColor="Red"
TextColorSize=""
TableFontColor="gray"
TableFontColorSize=""
MaxVerticalPixels=16
GraphColorBase="motion/TEMP"
bca="#000000"
DisplayOrder="RCur"
WindOnThreshold="5"
RefreshImageRate="1"
TemperatureDeviceLocation="Temperature"
DiscreteSpacing="2"
QuasarSampleInterval=1
DSSampleInterval=1
CSVSampleInterval=5
CSVSampleInterval2=5
CSVSampleInterval3=5
T05SampleInterval=1
high_wind=""
MinimumHumidity="20"
SignificantDigits="1"
UserDefinedLabel0=""
UserDefinedLabel1=""
UserDefinedLabel2=""
UserDefinedLabel3=""
LineWidthTemperature="1"
LineWidthOther="1"
SymbolSizeL="2"
SymbolSizeR="5"
SymbolDeltaL="2"
SymbolDeltaR="2"
barocalibrationslope="1"
barocalibrationoffset="0"
ClientChartLegendSize="8, 8, 8, 8, 8, 8, 8, 8, 8, 8"
ClientChartUpdateTimeSize="7, 7, 7, 7, 7, 7, 7, 7, 7, 7"
ClientChartAxisTitleSize="8, 8, 8, 8, 8, 8, 8, 8, 8, 8"
ClientChartAxisSize="8, 8, 8, 8, 8, 8, 8, 8, 8, 8"
ClientChartOverallHeight="300, 370, 440, 510, 580, 650, 720, 790, 860, 930"
ClientChartOverallWidth="600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1500"
ClientChartWidth="520, 620, 720, 820, 920, 1020, 1120, 1220, 1320, 1420"
ClientChartHeight="210, 280, 350, 420, 490, 560, 630, 700, 770, 840"
LineChartBorderColor=D0D0D0
LineChartCenterColor=FCFDCF
DefaultLineColors=""
Client0="Default,0"
Client1=",0"
Client2=",0"
Client3=",0"
History_=;;8291.069;;13385,13399;14/05/2007 16:08:58;13385,13399
History_R1=;;4968904;;13390,13404;14/05/2007 16:10:57;13388,13402
Temp05Version="TEMP08 v2.07 2007-02-12"
History_R10=;;1.671738E+07;;13468,13482;14/05/2007 16:40:54;13395,13409
DefaultGraph=LinTab
DefaultPeriod=6Hour
DefaultAggregate=None
SelectedGroup=Default
[Cals]
[Forecast]
ForecastVDCode0=""
ForecastVD0=0
ForecastChart0=0
ForecastVDCode1=""
ForecastVD1=0
ForecastChart1=0
ForecastVDCode2=""
ForecastVD2=0
ForecastChart2=0
ForecastVDCode3=""
ForecastVD3=0
ForecastChart3=0
ForecastVDCode4=""
ForecastVD4=0
ForecastChart4=0
ForecastVDCode5=""
ForecastVD5=0
ForecastChart5=0
ForecastVDCode6=""
ForecastVD6=0
ForecastChart6=0
ForecastVDCode7=""
ForecastVD7=0
ForecastChart7=0
ForecastVDCode8=""
ForecastVD8=0
ForecastChart8=0
ForecastVDCode9=""
ForecastVD9=0
ForecastChart9=0
ForecastVDCode10=""
ForecastVD10=0
ForecastChart10=0
ForecastVDCode11=""
ForecastVD11=0
ForecastChart11=0
ForecastVDCode12=""
ForecastVD12=0
ForecastChart12=0
ForecastVDCode13=""
ForecastVD13=0
ForecastChart13=0
ForecastVDCode14=""
ForecastVD14=0
ForecastChart14=0
ForecastVDCode15=""
ForecastVD15=0
ForecastChart15=0
ForecastVDCode16=""
ForecastVD16=0
ForecastChart16=0
[Group]
Default="None","LinTab","R1"-1,"R2"-1,"R3"-1,"R4"-1,"R5"-1,"R6"-1,"R7"-1,"R8"-1,"R9"-1,"R10"-1,"R11"-1
[Devices]
5500000009EB711D7="R1,01:01, 0,,0"
5500000009EB711D8="R2,01:01, 0,,0"
370000010AE0C428="R3,04:01, 0,0,0"
300008013EFC9C10="R4,05:02, 0,0,0"
3100080135B96810="R5,06:03, 0,0,0"
4000080141B06710="R6,07:04, 0,0,0"
700000010AD0A428="R7,08:05, 0,0,0"
4A000801419AC910="R8,09:06, 0,0,0"
3100080135B87110="R9,10:07, 0,0,0"
5500000009EB711DN="R10,01:01, 0,0,0"
5500000009EB711DC="R11,01:01, 0,0,0"
[Database]
R1="s5500000009EB711D7,31,1"
R2="s5500000009EB711D8,32,1"
R3="s370000010AE0C428,0,1"
R4="s300008013EFC9C10,0,1"
R5="s3100080135B96810,0,1"
R6="s4000080141B06710,0,1"
R7="s700000010AD0A428,0,1"
R8="s4A000801419AC910,0,1"
R9="s3100080135B87110,0,1"
R10="s5500000009EB711DN,29,1"
R11="s5500000009EB711DC,30,1"
[LastState]
SR11=2
[Scale]
Default=,,,
[ASP]
WattageToday=checked
WattageRate=checked
TemperatureTemperature2=checked
TemperatureTemperature3=checked
TemperatureTemperature4=checked
TemperatureTemperature5=checked
TemperatureTemperature6=checked
TemperatureTemperature7=checked
TemperatureTemperature8=checked
TemperatureWaterFlow9=checked
TemperatureWaterFlowRate10=checked

[Michael McSharry]

The overlflow is due to a very large number being store in a 32 bit integer field. I believe it is comming from your history setting that resulted likely from a big impulse of apparent energy use when first started.

History_R10=;;1.671738E+07;;13468,13482;14/05/2007 16:40:54;13395,13409

Change this to 0 as shown below. After the errors are gone values should be stored.

History_R10=;;0;;13468,13482;14/05/2007 16:40:54;13395,13409