Announcement

Collapse
No announcement yet.

Using mcsTemperature to track energy usage

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • aiqy65
    replied
    Still Having Problems

    Still not got things going.

    The story so far...

    With no ini file mcs descovers all the 1 wire devices and created the counter as a water meter. Only one pair of enrties rather than 2 (one pair for each channel on the counter. Thats not a problem as both channels are connected together.
    MCS then puts all the devices into Homeseer.

    I then stop everything and change the DN & DC device codes to a D7 & D8 and rename the database fields the same.

    Restart and MCS quickly create's a Water meter again.

    Very quickly the history value of the water meter fills up to a huge number and hits overflow, stopping any data going into the database. The 'power' consumption stays as a flat line. You can watch the couner value slowly increasing on the raw data from the temp08. Clearing out the history value to zero only last a few mins as it fills up again very quickly.

    When midnight came along things reset and I got a couple of mins worth of data before the water meter went off scale again. I have tried to remove the water meter device but it keeps coming back.

    With the small amounts of data that have gone into the database I have never had any meaningful graphs out and the numbers do not tie up to the counter value.

    Attached is the latest ini file with all the devices and the 'overflowed' water meter.

    Who knows what trauma I am going to suffer when I put the main house power (this is only the garage) and rain gauge on !!! Wires and electrons I am OK with. Software is another thing (cant you tell.....)

    Any pointer in the right direction would be appreciated.

    Cheers
    Lee
    Attached Files

    Leave a comment:


  • Michael McSharry
    replied
    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

    Leave a comment:


  • aiqy65
    replied
    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

    Leave a comment:


  • Michael McSharry
    replied
    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.

    Leave a comment:


  • aiqy65
    replied
    [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

    Leave a comment:


  • Michael McSharry
    replied
    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.

    Leave a comment:


  • Bestgear
    replied
    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

    Leave a comment:


  • Michael McSharry
    replied
    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.

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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
    Last edited by Spawn; April 26, 2006, 04:24 AM.

    Leave a comment:


  • Michael McSharry
    replied
    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.
    Attached Files

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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

    Leave a comment:


  • Michael McSharry
    replied
    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.

    Leave a comment:


  • Guest's Avatar
    Guest replied
    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
    Attached Files

    Leave a comment:


  • Michael McSharry
    replied
    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

    Leave a comment:


  • Mario from Spain
    replied
    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!!

    Leave a comment:

Working...
X