Strom Tagesverbrauch aus Datenbank
-
@paul53 sagte:
Weil der kWh-Preis ein Komma anstelle eines Punktes enthält?
Das hatte ich schon bei seinem ersten Screenshot gedacht.
Allerdings enthält inzwischen alles ein Komma als Dezimaltrenner@aphofis sagte in Strom Tagesverbrauch aus Datenbank:
Kann man auch Kosten gestern, letzten Monat und letztes Jahr in der Steuerung aufnehmen!?
Das macht auch alles der Source-Analytics Adapter.
Es wäre doch jetzt etwas übertrieben diesen Adapter hier nochmal durch Paul neu erfinden wollen zu lassen.@homoran sagte: Das macht auch alles der Source-Analytics Adapter.
Bitte verzichtet auf Chat-Nachrichten, denn die Handhabung ist grauenhaft !
Produktiv: RPi 2 mit S.USV, HM-MOD-RPI und SLC-USB-Stick mit root fs -
@homoran sagte: Das macht auch alles der Source-Analytics Adapter.
-
@homoran sagte: Das macht auch alles der Source-Analytics Adapter.
@paul53
Ich habe nur nicht verstanden, wie man in den sourceanalytics Adapter dann das Gerät implementiert woraus die Watt genommen wird.Hatte die drei Datenpunkte die Konvertierung Standard wert 0,00 raus genommen Datenpunkte liegen als Zahl vor oder müssen die als zeichenkette eingestellt werden!?
-
@paul53
Ich habe nur nicht verstanden, wie man in den sourceanalytics Adapter dann das Gerät implementiert woraus die Watt genommen wird.Hatte die drei Datenpunkte die Konvertierung Standard wert 0,00 raus genommen Datenpunkte liegen als Zahl vor oder müssen die als zeichenkette eingestellt werden!?
@aphofis sagte: Datenpunkte liegen als Zahl vor oder müssen die als zeichenkette eingestellt werden!?
Wiederhole mich: Alle Datenpunkte müssen vom Typ "number" sein!
Bitte verzichtet auf Chat-Nachrichten, denn die Handhabung ist grauenhaft !
Produktiv: RPi 2 mit S.USV, HM-MOD-RPI und SLC-USB-Stick mit root fs -
@aphofis sagte: Datenpunkte liegen als Zahl vor oder müssen die als zeichenkette eingestellt werden!?
Wiederhole mich: Alle Datenpunkte müssen vom Typ "number" sein!
-
@aphofis sagte: kommen diese Meldungen
0,3029 enthält immer noch ein Komma. Damit kann Javascript nicht rechnen (es nicht in eine Zahl wandeln).
Bitte verzichtet auf Chat-Nachrichten, denn die Handhabung ist grauenhaft !
Produktiv: RPi 2 mit S.USV, HM-MOD-RPI und SLC-USB-Stick mit root fs -
@aphofis sagte: kommen diese Meldungen
0,3029 enthält immer noch ein Komma. Damit kann Javascript nicht rechnen (es nicht in eine Zahl wandeln).
-
ist die berechnung so denn Korrekt !? irgenwie ist der Tageswert fast immer gleich, auch wenn mal mehr mal weniger verbrauch ist.
<xml xmlns="https://developers.google.com/blockly/xml"> <variables> <variable id="=}(t[?(kyO6G;_5{47zw">energie</variable> <variable id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</variable> <variable id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</variable> <variable id="_6-y]Y9]t#{T,8m8Nld|">morgen</variable> <variable id="CXvj%f2,^`q.7fX9iSyn">Stromverbrauch_Monat</variable> <variable id="X#X}3JX?[j_abA[mPhUl">Stromverbrauch_Jahr</variable> </variables> <block type="comment" id="Oi1v+pWY~14%Xh1Jy~3f" x="-2562" y="-938"> <field name="COMMENT">kWh</field> <next> <block type="variables_set" id="Pro])9p0x+.GZsU@LMgb"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> <value name="VALUE"> <block type="get_value" id="/ydnFDJrL9opol3_b`8I"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stomzähler_Total</field> </block> </value> <next> <block type="variables_set" id="nyj|FI9G`|V;bGixF*i+"> <field name="VAR" id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</field> <value name="VALUE"> <block type="get_value" id="IgorrDya]nX`9T0%wytA"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.kW_Preis</field> </block> </value> <next> <block type="on_ext" id=";i+~!4`24`w?e}0%T$a,"> <mutation xmlns="http://www.w3.org/1999/xhtml" items="1"></mutation> <field name="CONDITION">ne</field> <field name="ACK_CONDITION"></field> <value name="OID0"> <shadow type="field_oid" id="3`#38E!0A#SiXLIsHk)("> <field name="oid">hs100.0.192_168_0_28.power</field> </shadow> </value> <statement name="STATEMENT"> <block type="math_change" id="W(R?Uq1}SLFI)JmdlMR{"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> <value name="DELTA"> <shadow type="math_number" id="Xf[d~|kq/aP_DDr]DK1l"> <field name="NUM">1</field> </shadow> <block type="math_arithmetic" id="Kn(CxoS|t]3p.HKTSh}3" inline="false"> <field name="OP">DIVIDE</field> <value name="A"> <shadow type="math_number" id="=$N|b~CMlpLQkVj]ChTX"> <field name="NUM">1</field> </shadow> <block type="math_arithmetic" id="SVG6,q39`,yZ;%3FH?Rr"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number" id="?MAStt72g7n3yIy5#),L"> <field name="NUM">1</field> </shadow> <block type="on_source" id="M)GOgU+Y!,KfdZ_z-F@@"> <field name="ATTR">oldState.val</field> </block> </value> <value name="B"> <shadow type="math_number" id="%rMg4hLIG8=;w:Aw(6s%"> <field name="NUM">1</field> </shadow> <block type="math_arithmetic" id="RiObozqnos#{wK,kA@}5"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="9MU=I%OuetykN3Zbxcj`"> <field name="NUM">1</field> </shadow> <block type="on_source" id="+Tr)U=ieimp}oh(9$lty"> <field name="ATTR">state.lc</field> </block> </value> <value name="B"> <shadow type="math_number" id="8z13T?Bu?$~.iKDR9m#0"> <field name="NUM">1</field> </shadow> <block type="on_source" id="cR=n9?~_.E}2w6VNB($6"> <field name="ATTR">oldState.lc</field> </block> </value> </block> </value> </block> </value> <value name="B"> <shadow type="math_number" id="`?`i`kz0;!}~`YrnM@UU"> <field name="NUM">3600000000</field> </shadow> </value> </block> </value> <next> <block type="update" id="|gu:*T1lgIMgJxx3Mmn/"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stomzähler_Total</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="8dfiQZ|qKcI6Cr1Ii09o"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="]Ci$6#5q*i||oO%yTX$L"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="IxivuTl1J+bu|J6_LAfw"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> </block> </value> <next> <block type="variables_set" id="-u+$?7,c,Yw2k[8jYj}:"> <field name="VAR" id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</field> <value name="VALUE"> <block type="math_arithmetic" id="p2;GJ#T8wTg;#|yBx+RY"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="p~D[c1OhSg6yE%D?0U`S"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="oDDq6^ThGVqLdcZakWBE"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> <value name="B"> <shadow type="math_number" id="sgz+%W6FFv$cBl#_eP]("> <field name="NUM">1</field> </shadow> <block type="get_value" id="2Sw/cyDXvicx28Nu@G]="> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Mitternacht</field> </block> </value> </block> </value> <next> <block type="update" id="Ee|]qnT[;msi-sf{)9|5"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Aktuell</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="Z0AcZJ6|P*=Rft5Ipiu["> <field name="n">2</field> <value name="x"> <shadow type="math_number"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="7pwFPy6eZYKkp%Lip1Aw"> <field name="VAR" id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</field> </block> </value> </block> </value> </block> </next> </block> </next> </block> </next> </block> </statement> <next> <block type="schedule" id="R-R5c,0BVJnCg)==!a]c"> <field name="SCHEDULE">59 59 23 * * *</field> <statement name="STATEMENT"> <block type="variables_set" id="HO5jYp;e{iki9x@m}l~L"> <field name="VAR" id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</field> <value name="VALUE"> <block type="get_value" id="JpbPUSPJVpl|EQ;tj#zt"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.kW_Preis</field> </block> </value> <next> <block type="update" id="esbT12;]KNI5^+G}+N(C"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Gestern</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="z8T:5(IoZGv*|6v=pEW@"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="SVB2,QD?*.K@X$0qN/Re"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="H=`CUi01{RL(9r(Tz=9t"> <field name="VAR" id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</field> </block> </value> </block> </value> <next> <block type="update" id="p0=$?2:rCkXR1PtEO5~{"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Tag</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="A0_l%2Nv%M-PVX[A6T]Z"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="dXHs:=qFgRcV+t{?Ncs`"> <field name="NUM">3.1234</field> </shadow> <block type="math_arithmetic" id="%do_oaU-AFvO$)M]uFD~"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number" id="1tiN}LCuPM`.wB4EEjQF"> <field name="NUM">1</field> </shadow> <block type="convert_tonumber" id="|5A;dju,!7QcdC7aLI?u"> <value name="VALUE"> <block type="variables_get" id="yk7HzLIJ:W2iRx,:O{)O"> <field name="VAR" id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</field> </block> </value> </block> </value> <value name="B"> <shadow type="math_number" id="X29_UN}T4D|q50Z_H[JE"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="#9;^+ouOn2EyRo%E9drC"> <field name="VAR" id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id=")w{B_[rMI_r4;E#yZJlO"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Mitternacht</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="%sWPNaNm:;vI57!VV2Ce"> <field name="n">2</field> <value name="x"> <shadow type="math_number"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="rS-CHcKK}b#xix1^kv0W"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> </block> </value> <next> <block type="variables_set" id="*h:G`ZL]S1EI#wbZ7;ox"> <field name="VAR" id="_6-y]Y9]t#{T,8m8Nld|">morgen</field> <value name="VALUE"> <block type="math_arithmetic" id="w,sE`1J!{M+64c4{qv@1"> <field name="OP">ADD</field> <value name="A"> <shadow type="math_number" id=")jmzPSW};.V6b+2@i5eD"> <field name="NUM">1</field> </shadow> <block type="time_get" id="{[q+DX5xQx5etd@7I5(|"> <mutation xmlns="http://www.w3.org/1999/xhtml" format="false" language="false"></mutation> <field name="OPTION">object</field> </block> </value> <value name="B"> <shadow type="math_number" id=")QYm3At@RLs+6[zolqY/"> <field name="NUM">2000</field> </shadow> </value> </block> </value> <next> <block type="controls_if" id="_^7MyZiR~p=~ejiQK1Qy"> <value name="IF0"> <block type="logic_compare" id="0,r}BJ`.(4UbiOPEq#4z"> <field name="OP">EQ</field> <value name="A"> <block type="convert_from_date" id="u$,-;M?_tu6FbPaV.T9O"> <mutation xmlns="http://www.w3.org/1999/xhtml" format="false" language="false"></mutation> <field name="OPTION">d</field> <value name="VALUE"> <block type="variables_get" id="^VvyU)7(J=es=}GjtoqK"> <field name="VAR" id="_6-y]Y9]t#{T,8m8Nld|">morgen</field> </block> </value> </block> </value> <value name="B"> <block type="math_number" id="}PY|px_PY$7{7_oMN]OQ"> <field name="NUM">1</field> </block> </value> </block> </value> <statement name="DO0"> <block type="variables_set" id="FF(TK?{2QWDaf0X!:Vi_"> <field name="VAR" id="CXvj%f2,^`q.7fX9iSyn">Stromverbrauch_Monat</field> <value name="VALUE"> <block type="math_arithmetic" id="J764/-pDKScIRJ[w^-|C"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="QV@Rpbbz-*PS;AIi8g1B"> <field name="NUM">1</field> </shadow> <block type="variables_get" id=";%tj3VR~-[;hB@J66!`M"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> <value name="B"> <shadow type="math_number" id="0W/uAFcI7r2Zo(;@(Br:"> <field name="NUM">1</field> </shadow> <block type="get_value" id="rPrVo$-#}7.zwmJ$6Q[8"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Monatsende</field> </block> </value> </block> </value> <next> <block type="update" id="{d;Ziw2e%TB~lYY_0qF{"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="w:GHswlXb0v`j(:UtcNq"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="C6nfJzqfl40`vUOA7bK0"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="5fQ9Je8P{w00}PB$T2Y("> <field name="VAR" id="CXvj%f2,^`q.7fX9iSyn">Stromverbrauch_Monat</field> </block> </value> </block> </value> <next> <block type="update" id="]iw?SuC4`)4W50[dgv!7"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Monat</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="}MYIjEH$x1uSB7=JysJT"> <field name="n">2</field> <value name="x"> <shadow type="math_number"> <field name="NUM">3.1234</field> </shadow> <block type="math_arithmetic" id="_rCKNwIaU:+TD!?_9,A3"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number"> <field name="NUM">1</field> </shadow> <block type="get_value" id="~rZ.t|(=P(k~SyH),(zH"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat</field> </block> </value> <value name="B"> <shadow type="math_number"> <field name="NUM">1</field> </shadow> <block type="get_value" id="bc1slXB5vxVq$B{WgXlk"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.kW_Preis</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id="(0W=aE-:aK584x:TV%]g"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Monatsende</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="Dds;8%1a/,+8wi::zY!*"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="r;_Vule$5+w?pZqfy6,L"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="~Ag{jCxHSIvg2[;{HAv="> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> </block> </value> <next> <block type="controls_if" id="@BJ:Lrq^ygGDH22SV`HR"> <value name="IF0"> <block type="logic_compare" id="P/N,7ly%/Z%*f[%aKgCP"> <field name="OP">EQ</field> <value name="A"> <block type="convert_from_date" id="zuCKp3lEzm8G!vrFr6:z"> <mutation xmlns="http://www.w3.org/1999/xhtml" format="false" language="false"></mutation> <field name="OPTION">M</field> <value name="VALUE"> <block type="variables_get" id="#aLsxsLu?98+y8ViKexy"> <field name="VAR" id="_6-y]Y9]t#{T,8m8Nld|">morgen</field> </block> </value> </block> </value> <value name="B"> <block type="math_number" id="GOAG2EvCM!wK,YZKC-Ri"> <field name="NUM">1</field> </block> </value> </block> </value> <statement name="DO0"> <block type="variables_set" id="VN~@8}Wk+#~sY?X6J$yK"> <field name="VAR" id="X#X}3JX?[j_abA[mPhUl">Stromverbrauch_Jahr</field> <value name="VALUE"> <block type="math_arithmetic" id="P2B6Hj/OB]=e}O+@(su#"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="7Q!oOQ=[-ku6%_4MwYs1"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> <value name="B"> <shadow type="math_number" id="yg8fL_$?XWU{AjA(b2D-"> <field name="NUM">1</field> </shadow> <block type="get_value" id="Nm8#LUmLvr#4JK9%*nTE"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Zählwert_Jahresende</field> </block> </value> </block> </value> <next> <block type="update" id="rtA|%tI%9A)/A,Akz0ZC"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letztes_Jahr</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="DYkx!1i/gK!I:GnX3;M]"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="kd@_3s.FD__2K560^zTW"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="}Gg8g=dZ_L+D1e6KF5.Z"> <field name="VAR" id="X#X}3JX?[j_abA[mPhUl">Stromverbrauch_Jahr</field> </block> </value> </block> </value> <next> <block type="update" id="S2)Qgv/)$grhJLzSd@Da"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Jahr</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="qoCW5Q,Oy.pHW;,}A#4o"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="_ppI[(x5sVL[V,q.FB/s"> <field name="NUM">3.1234</field> </shadow> <block type="math_arithmetic" id="_E!pt_eX~kE(kUk=tmjG"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number" id="SFKv9/*dcvdPBJ~zD;nV"> <field name="NUM">1</field> </shadow> <block type="convert_tonumber" id="R(}lz3e%aPxkc6ZNW5tJ"> <value name="VALUE"> <block type="variables_get" id="D$7olGnz_lsHlJ(+hvW#"> <field name="VAR" id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</field> </block> </value> </block> </value> <value name="B"> <shadow type="math_number"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="{v)HHA!KqH$e%*_@(wZ8"> <field name="VAR" id="X#X}3JX?[j_abA[mPhUl">Stromverbrauch_Jahr</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id="7J.L9/2D@(+uL)_+sq=1"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Zählwert_Jahresende</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="_ExETwZ)XGD8)X7@wg~i"> <field name="n">2</field> <value name="x"> <shadow type="math_number"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="T6BlWR0Fg3N9HjEz5_U3"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> </block> </value> </block> </next> </block> </next> </block> </next> </block> </statement> </block> </next> </block> </next> </block> </next> </block> </next> </block> </statement> </block> </next> </block> </next> </block> </next> </block> </next> </block> </next> </block> </statement> <next> <block type="schedule" id="aet.;[c+_hK7wDr{G6C2"> <field name="SCHEDULE">*/60 * * * *</field> <statement name="STATEMENT"> <block type="telegram" id="v0$UV^ZB3-oU^7]v!RAz"> <field name="INSTANCE">.4</field> <field name="LOG"></field> <field name="SILENT">FALSE</field> <field name="PARSEMODE">default</field> <value name="MESSAGE"> <shadow type="text" id="Rxo{9t8UX(VxG=0:4SEp"> <field name="TEXT">text</field> </shadow> <block type="text_join" id="T74Mexxi6)W)GtL(_l+i"> <mutation items="8"></mutation> <value name="ADD0"> <block type="text" id="@~UO`IN9.n[P7axT*gtU"> <field name="TEXT">*** Aquarium Stromverbrauch ***</field> </block> </value> <value name="ADD1"> <block type="text_join" id="*b=9BOm)-|S1$d]a)8GT"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="zn@~H,2etpB|YZ4!YiE1"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="(@Ln*k6wFsCAw,tB6ydj"> <field name="TEXT">Aktuell </field> </block> </value> <value name="ADD2"> <block type="get_value" id="g4G/]%kK5M*VmH,tUcda"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Aktuell</field> </block> </value> <value name="ADD3"> <block type="text" id="a}?8/hAA+1]X4xIxDe]r"> <field name="TEXT"> kWh</field> </block> </value> </block> </value> <value name="ADD2"> <block type="text_join" id="XQor9*tmFToxv350~3a["> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="Vj#;a3p_e-np~YXNy6@r"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="nIWZE7{YZAROw`Jk0;wC"> <field name="TEXT">Verbrauch gestern </field> </block> </value> <value name="ADD2"> <block type="get_value" id="bv[E`]ToqDSpF,vlMNh~"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Gestern</field> </block> </value> <value name="ADD3"> <block type="text" id="r3ZT#_xm}R0uV;GYS/4o"> <field name="TEXT"> kWh</field> </block> </value> </block> </value> <value name="ADD3"> <block type="text_join" id="lxS:_dtgB(`PhaIZQWX`"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="bEge*!(ftsg%l0VVLfAj"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="sl;`FZ%+Ne[AuLV:HV.@"> <field name="TEXT">Verbrauch letzter Monat </field> </block> </value> <value name="ADD2"> <block type="get_value" id="xc^PZ^IOdUk|fc|9eoh;"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat</field> </block> </value> <value name="ADD3"> <block type="text" id="F:fOjp,n1._b*AfXe3th"> <field name="TEXT"> kWh</field> </block> </value> </block> </value> <value name="ADD4"> <block type="text_join" id="aw6y1|A}5o*MbWrdHY9p"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="#mt{)k$cy8`uL_gO}s(}"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="6HPgG=f|C)szqcpw[,@C"> <field name="TEXT">Verbrauch letztes Jahr </field> </block> </value> <value name="ADD2"> <block type="get_value" id="xbnX~3^bUmK-F@|H_hTp"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letztes_Jahr</field> </block> </value> <value name="ADD3"> <block type="text" id="UKfqr%$A(e+plg=|m1^:"> <field name="TEXT"> kWh</field> </block> </value> </block> </value> <value name="ADD5"> <block type="text_join" id="R:gZNVoGL(KF9Ln*j_d^"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="m9clcKkwp7cKTW^I34?e"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="?{%o]g(9,%4L%M6!DYAv"> <field name="TEXT">Kosten Tag </field> </block> </value> <value name="ADD2"> <block type="get_value" id="#VWuZRdM(}XDg3OL^_wt"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Tag</field> </block> </value> <value name="ADD3"> <block type="text" id="`rcUdx%%|ACCi+o=)X~R"> <field name="TEXT"> €</field> </block> </value> </block> </value> <value name="ADD6"> <block type="text_join" id="L=$=$F)=!;OgqNrVyabW"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="F+3QgsRX,n$UCu1;DT{!"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="|-WwMSy4tStB#F=]P(LC"> <field name="TEXT">Kosten Monat </field> </block> </value> <value name="ADD2"> <block type="math_rndfixed" id="JW[35xdn%,vmkv/k,:?|"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="NmJ(Yr(%(_)z]xNU|%{E"> <field name="NUM">3.1234</field> </shadow> <block type="math_arithmetic" id="RwW5ffAClCW|C0N,@opm"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number" id="pg}Y*W1KV3gV?Fo+7m}M"> <field name="NUM">1</field> </shadow> <block type="get_value" id="N#H|hnEdbxs/YwNmOE=K"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat</field> </block> </value> <value name="B"> <shadow type="math_number" id="J|RT4Dmp4sH6gj{Msj-."> <field name="NUM">1</field> </shadow> <block type="get_value" id="Off:*?MHo]qRW/nKwLUt"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.kW_Preis</field> </block> </value> </block> </value> </block> </value> <value name="ADD3"> <block type="text" id="3et?)Rne~PLpE}iGCbrM"> <field name="TEXT"> €</field> </block> </value> </block> </value> <value name="ADD7"> <block type="text_join" id="H3?].mnCpOk#%@ko-On/"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="U:?6XJ2RC|jO#6L/.:QA"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="2zM)w6?mBEx!N`We-nn0"> <field name="TEXT">Kosten Jahr </field> </block> </value> <value name="ADD2"> <block type="get_value" id="$$q9MX%}{2KBRJ-jb|vI"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Jahr</field> </block> </value> <value name="ADD3"> <block type="text" id="YTfJv6^/WgC2Kj8$!pZ("> <field name="TEXT"> €</field> </block> </value> </block> </value> </block> </value> </block> </statement> </block> </next> </block> </next> </block> </next> </block> </next> </block> </next> </block> </xml>var energie, kWh_Preis, verbrauch_heute, morgen, Stromverbrauch_Monat, Stromverbrauch_Jahr; // kWh energie = getState("0_userdata.0.Aqua_Control.0.Strom.Stomzähler_Total").val; kWh_Preis = getState("0_userdata.0.Aqua_Control.0.Strom.kW_Preis").val; on({id: 'hs100.0.192_168_0_28.power', change: "ne"}, async function (obj) { var value = obj.state.val; var oldValue = obj.oldState.val; energie = (typeof energie == 'number' ? energie : 0) + ((obj.oldState ? obj.oldState.val : "") * ((obj.state ? obj.state.lc : "") - (obj.oldState ? obj.oldState.lc : ""))) / 3600000000; setState("0_userdata.0.Aqua_Control.0.Strom.Stomzähler_Total"/*Stomzähler_Total*/, Math.round(energie*100)/100, true); verbrauch_heute = energie - getState("0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Mitternacht").val; setState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Aktuell"/*Stromverbrauch_Aktuell*/, Math.round(verbrauch_heute*100)/100, true); }); schedule("59 59 23 * * *", async function () { kWh_Preis = getState("0_userdata.0.Aqua_Control.0.Strom.kW_Preis").val; setState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Gestern"/*Stromverbrauch_Gestern*/, Math.round(verbrauch_heute*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Tag"/*Stomkosten_Tag*/, Math.round((parseFloat(kWh_Preis) * verbrauch_heute)*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Mitternacht"/*Stromzähler_Mitternacht*/, Math.round(energie*100)/100, true); morgen = (new Date().getTime()) + 2000; if (getDateObject(morgen).getDate() == 1) { Stromverbrauch_Monat = energie - getState("0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Monatsende").val; setState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat"/*Stromverbrauch_letzter_Monat*/, Math.round(Stromverbrauch_Monat*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Monat"/*Stromkosten_Monat*/, Math.round((getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat").val * getState("0_userdata.0.Aqua_Control.0.Strom.kW_Preis").val)*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Monatsende"/*Stromzähler_Monatsende*/, Math.round(energie*100)/100, true); if ((getDateObject(morgen).getMonth() + 1) == 1) { Stromverbrauch_Jahr = energie - getState("0_userdata.0.Aqua_Control.0.Strom.Zählwert_Jahresende").val; setState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letztes_Jahr"/*Stromverbrauch_letztes_Jahr*/, Math.round(Stromverbrauch_Jahr*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Jahr"/*Stromkosten_Jahr*/, Math.round((parseFloat(kWh_Preis) * Stromverbrauch_Jahr)*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Zählwert_Jahresende"/*Zählwert_Jahresende*/, Math.round(energie*100)/100, true); } } }); schedule("*/60 * * * *", async function () { sendTo("telegram.4", "send", { text: (['*** Aquarium Stromverbrauch ***',['\n','Aktuell ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Aktuell").val,' kWh'].join(''),['\n','Verbrauch gestern ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Gestern").val,' kWh'].join(''),['\n','Verbrauch letzter Monat ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat").val,' kWh'].join(''),['\n','Verbrauch letztes Jahr ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letztes_Jahr").val,' kWh'].join(''),['\n','Kosten Tag ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Tag").val,' €'].join(''),['\n','Kosten Monat ',Math.round((getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat").val * getState("0_userdata.0.Aqua_Control.0.Strom.kW_Preis").val)*100)/100,' €'].join(''),['\n','Kosten Jahr ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Jahr").val,' €'].join('')].join('')) }); }); -
ist die berechnung so denn Korrekt !? irgenwie ist der Tageswert fast immer gleich, auch wenn mal mehr mal weniger verbrauch ist.
<xml xmlns="https://developers.google.com/blockly/xml"> <variables> <variable id="=}(t[?(kyO6G;_5{47zw">energie</variable> <variable id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</variable> <variable id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</variable> <variable id="_6-y]Y9]t#{T,8m8Nld|">morgen</variable> <variable id="CXvj%f2,^`q.7fX9iSyn">Stromverbrauch_Monat</variable> <variable id="X#X}3JX?[j_abA[mPhUl">Stromverbrauch_Jahr</variable> </variables> <block type="comment" id="Oi1v+pWY~14%Xh1Jy~3f" x="-2562" y="-938"> <field name="COMMENT">kWh</field> <next> <block type="variables_set" id="Pro])9p0x+.GZsU@LMgb"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> <value name="VALUE"> <block type="get_value" id="/ydnFDJrL9opol3_b`8I"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stomzähler_Total</field> </block> </value> <next> <block type="variables_set" id="nyj|FI9G`|V;bGixF*i+"> <field name="VAR" id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</field> <value name="VALUE"> <block type="get_value" id="IgorrDya]nX`9T0%wytA"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.kW_Preis</field> </block> </value> <next> <block type="on_ext" id=";i+~!4`24`w?e}0%T$a,"> <mutation xmlns="http://www.w3.org/1999/xhtml" items="1"></mutation> <field name="CONDITION">ne</field> <field name="ACK_CONDITION"></field> <value name="OID0"> <shadow type="field_oid" id="3`#38E!0A#SiXLIsHk)("> <field name="oid">hs100.0.192_168_0_28.power</field> </shadow> </value> <statement name="STATEMENT"> <block type="math_change" id="W(R?Uq1}SLFI)JmdlMR{"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> <value name="DELTA"> <shadow type="math_number" id="Xf[d~|kq/aP_DDr]DK1l"> <field name="NUM">1</field> </shadow> <block type="math_arithmetic" id="Kn(CxoS|t]3p.HKTSh}3" inline="false"> <field name="OP">DIVIDE</field> <value name="A"> <shadow type="math_number" id="=$N|b~CMlpLQkVj]ChTX"> <field name="NUM">1</field> </shadow> <block type="math_arithmetic" id="SVG6,q39`,yZ;%3FH?Rr"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number" id="?MAStt72g7n3yIy5#),L"> <field name="NUM">1</field> </shadow> <block type="on_source" id="M)GOgU+Y!,KfdZ_z-F@@"> <field name="ATTR">oldState.val</field> </block> </value> <value name="B"> <shadow type="math_number" id="%rMg4hLIG8=;w:Aw(6s%"> <field name="NUM">1</field> </shadow> <block type="math_arithmetic" id="RiObozqnos#{wK,kA@}5"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="9MU=I%OuetykN3Zbxcj`"> <field name="NUM">1</field> </shadow> <block type="on_source" id="+Tr)U=ieimp}oh(9$lty"> <field name="ATTR">state.lc</field> </block> </value> <value name="B"> <shadow type="math_number" id="8z13T?Bu?$~.iKDR9m#0"> <field name="NUM">1</field> </shadow> <block type="on_source" id="cR=n9?~_.E}2w6VNB($6"> <field name="ATTR">oldState.lc</field> </block> </value> </block> </value> </block> </value> <value name="B"> <shadow type="math_number" id="`?`i`kz0;!}~`YrnM@UU"> <field name="NUM">3600000000</field> </shadow> </value> </block> </value> <next> <block type="update" id="|gu:*T1lgIMgJxx3Mmn/"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stomzähler_Total</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="8dfiQZ|qKcI6Cr1Ii09o"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="]Ci$6#5q*i||oO%yTX$L"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="IxivuTl1J+bu|J6_LAfw"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> </block> </value> <next> <block type="variables_set" id="-u+$?7,c,Yw2k[8jYj}:"> <field name="VAR" id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</field> <value name="VALUE"> <block type="math_arithmetic" id="p2;GJ#T8wTg;#|yBx+RY"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="p~D[c1OhSg6yE%D?0U`S"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="oDDq6^ThGVqLdcZakWBE"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> <value name="B"> <shadow type="math_number" id="sgz+%W6FFv$cBl#_eP]("> <field name="NUM">1</field> </shadow> <block type="get_value" id="2Sw/cyDXvicx28Nu@G]="> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Mitternacht</field> </block> </value> </block> </value> <next> <block type="update" id="Ee|]qnT[;msi-sf{)9|5"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Aktuell</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="Z0AcZJ6|P*=Rft5Ipiu["> <field name="n">2</field> <value name="x"> <shadow type="math_number"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="7pwFPy6eZYKkp%Lip1Aw"> <field name="VAR" id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</field> </block> </value> </block> </value> </block> </next> </block> </next> </block> </next> </block> </statement> <next> <block type="schedule" id="R-R5c,0BVJnCg)==!a]c"> <field name="SCHEDULE">59 59 23 * * *</field> <statement name="STATEMENT"> <block type="variables_set" id="HO5jYp;e{iki9x@m}l~L"> <field name="VAR" id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</field> <value name="VALUE"> <block type="get_value" id="JpbPUSPJVpl|EQ;tj#zt"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.kW_Preis</field> </block> </value> <next> <block type="update" id="esbT12;]KNI5^+G}+N(C"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Gestern</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="z8T:5(IoZGv*|6v=pEW@"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="SVB2,QD?*.K@X$0qN/Re"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="H=`CUi01{RL(9r(Tz=9t"> <field name="VAR" id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</field> </block> </value> </block> </value> <next> <block type="update" id="p0=$?2:rCkXR1PtEO5~{"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Tag</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="A0_l%2Nv%M-PVX[A6T]Z"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="dXHs:=qFgRcV+t{?Ncs`"> <field name="NUM">3.1234</field> </shadow> <block type="math_arithmetic" id="%do_oaU-AFvO$)M]uFD~"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number" id="1tiN}LCuPM`.wB4EEjQF"> <field name="NUM">1</field> </shadow> <block type="convert_tonumber" id="|5A;dju,!7QcdC7aLI?u"> <value name="VALUE"> <block type="variables_get" id="yk7HzLIJ:W2iRx,:O{)O"> <field name="VAR" id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</field> </block> </value> </block> </value> <value name="B"> <shadow type="math_number" id="X29_UN}T4D|q50Z_H[JE"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="#9;^+ouOn2EyRo%E9drC"> <field name="VAR" id="77Wt!M~fc;QCn4*b~)yF">verbrauch_heute</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id=")w{B_[rMI_r4;E#yZJlO"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Mitternacht</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="%sWPNaNm:;vI57!VV2Ce"> <field name="n">2</field> <value name="x"> <shadow type="math_number"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="rS-CHcKK}b#xix1^kv0W"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> </block> </value> <next> <block type="variables_set" id="*h:G`ZL]S1EI#wbZ7;ox"> <field name="VAR" id="_6-y]Y9]t#{T,8m8Nld|">morgen</field> <value name="VALUE"> <block type="math_arithmetic" id="w,sE`1J!{M+64c4{qv@1"> <field name="OP">ADD</field> <value name="A"> <shadow type="math_number" id=")jmzPSW};.V6b+2@i5eD"> <field name="NUM">1</field> </shadow> <block type="time_get" id="{[q+DX5xQx5etd@7I5(|"> <mutation xmlns="http://www.w3.org/1999/xhtml" format="false" language="false"></mutation> <field name="OPTION">object</field> </block> </value> <value name="B"> <shadow type="math_number" id=")QYm3At@RLs+6[zolqY/"> <field name="NUM">2000</field> </shadow> </value> </block> </value> <next> <block type="controls_if" id="_^7MyZiR~p=~ejiQK1Qy"> <value name="IF0"> <block type="logic_compare" id="0,r}BJ`.(4UbiOPEq#4z"> <field name="OP">EQ</field> <value name="A"> <block type="convert_from_date" id="u$,-;M?_tu6FbPaV.T9O"> <mutation xmlns="http://www.w3.org/1999/xhtml" format="false" language="false"></mutation> <field name="OPTION">d</field> <value name="VALUE"> <block type="variables_get" id="^VvyU)7(J=es=}GjtoqK"> <field name="VAR" id="_6-y]Y9]t#{T,8m8Nld|">morgen</field> </block> </value> </block> </value> <value name="B"> <block type="math_number" id="}PY|px_PY$7{7_oMN]OQ"> <field name="NUM">1</field> </block> </value> </block> </value> <statement name="DO0"> <block type="variables_set" id="FF(TK?{2QWDaf0X!:Vi_"> <field name="VAR" id="CXvj%f2,^`q.7fX9iSyn">Stromverbrauch_Monat</field> <value name="VALUE"> <block type="math_arithmetic" id="J764/-pDKScIRJ[w^-|C"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number" id="QV@Rpbbz-*PS;AIi8g1B"> <field name="NUM">1</field> </shadow> <block type="variables_get" id=";%tj3VR~-[;hB@J66!`M"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> <value name="B"> <shadow type="math_number" id="0W/uAFcI7r2Zo(;@(Br:"> <field name="NUM">1</field> </shadow> <block type="get_value" id="rPrVo$-#}7.zwmJ$6Q[8"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Monatsende</field> </block> </value> </block> </value> <next> <block type="update" id="{d;Ziw2e%TB~lYY_0qF{"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="w:GHswlXb0v`j(:UtcNq"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="C6nfJzqfl40`vUOA7bK0"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="5fQ9Je8P{w00}PB$T2Y("> <field name="VAR" id="CXvj%f2,^`q.7fX9iSyn">Stromverbrauch_Monat</field> </block> </value> </block> </value> <next> <block type="update" id="]iw?SuC4`)4W50[dgv!7"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Monat</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="}MYIjEH$x1uSB7=JysJT"> <field name="n">2</field> <value name="x"> <shadow type="math_number"> <field name="NUM">3.1234</field> </shadow> <block type="math_arithmetic" id="_rCKNwIaU:+TD!?_9,A3"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number"> <field name="NUM">1</field> </shadow> <block type="get_value" id="~rZ.t|(=P(k~SyH),(zH"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat</field> </block> </value> <value name="B"> <shadow type="math_number"> <field name="NUM">1</field> </shadow> <block type="get_value" id="bc1slXB5vxVq$B{WgXlk"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.kW_Preis</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id="(0W=aE-:aK584x:TV%]g"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Monatsende</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="Dds;8%1a/,+8wi::zY!*"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="r;_Vule$5+w?pZqfy6,L"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="~Ag{jCxHSIvg2[;{HAv="> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> </block> </value> <next> <block type="controls_if" id="@BJ:Lrq^ygGDH22SV`HR"> <value name="IF0"> <block type="logic_compare" id="P/N,7ly%/Z%*f[%aKgCP"> <field name="OP">EQ</field> <value name="A"> <block type="convert_from_date" id="zuCKp3lEzm8G!vrFr6:z"> <mutation xmlns="http://www.w3.org/1999/xhtml" format="false" language="false"></mutation> <field name="OPTION">M</field> <value name="VALUE"> <block type="variables_get" id="#aLsxsLu?98+y8ViKexy"> <field name="VAR" id="_6-y]Y9]t#{T,8m8Nld|">morgen</field> </block> </value> </block> </value> <value name="B"> <block type="math_number" id="GOAG2EvCM!wK,YZKC-Ri"> <field name="NUM">1</field> </block> </value> </block> </value> <statement name="DO0"> <block type="variables_set" id="VN~@8}Wk+#~sY?X6J$yK"> <field name="VAR" id="X#X}3JX?[j_abA[mPhUl">Stromverbrauch_Jahr</field> <value name="VALUE"> <block type="math_arithmetic" id="P2B6Hj/OB]=e}O+@(su#"> <field name="OP">MINUS</field> <value name="A"> <shadow type="math_number"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="7Q!oOQ=[-ku6%_4MwYs1"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> <value name="B"> <shadow type="math_number" id="yg8fL_$?XWU{AjA(b2D-"> <field name="NUM">1</field> </shadow> <block type="get_value" id="Nm8#LUmLvr#4JK9%*nTE"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Zählwert_Jahresende</field> </block> </value> </block> </value> <next> <block type="update" id="rtA|%tI%9A)/A,Akz0ZC"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letztes_Jahr</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="DYkx!1i/gK!I:GnX3;M]"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="kd@_3s.FD__2K560^zTW"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="}Gg8g=dZ_L+D1e6KF5.Z"> <field name="VAR" id="X#X}3JX?[j_abA[mPhUl">Stromverbrauch_Jahr</field> </block> </value> </block> </value> <next> <block type="update" id="S2)Qgv/)$grhJLzSd@Da"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Jahr</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="qoCW5Q,Oy.pHW;,}A#4o"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="_ppI[(x5sVL[V,q.FB/s"> <field name="NUM">3.1234</field> </shadow> <block type="math_arithmetic" id="_E!pt_eX~kE(kUk=tmjG"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number" id="SFKv9/*dcvdPBJ~zD;nV"> <field name="NUM">1</field> </shadow> <block type="convert_tonumber" id="R(}lz3e%aPxkc6ZNW5tJ"> <value name="VALUE"> <block type="variables_get" id="D$7olGnz_lsHlJ(+hvW#"> <field name="VAR" id="EM/_h4I|j;OmlODcL6%~">kWh_Preis</field> </block> </value> </block> </value> <value name="B"> <shadow type="math_number"> <field name="NUM">1</field> </shadow> <block type="variables_get" id="{v)HHA!KqH$e%*_@(wZ8"> <field name="VAR" id="X#X}3JX?[j_abA[mPhUl">Stromverbrauch_Jahr</field> </block> </value> </block> </value> </block> </value> <next> <block type="update" id="7J.L9/2D@(+uL)_+sq=1"> <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Zählwert_Jahresende</field> <field name="WITH_DELAY">FALSE</field> <value name="VALUE"> <block type="math_rndfixed" id="_ExETwZ)XGD8)X7@wg~i"> <field name="n">2</field> <value name="x"> <shadow type="math_number"> <field name="NUM">3.1234</field> </shadow> <block type="variables_get" id="T6BlWR0Fg3N9HjEz5_U3"> <field name="VAR" id="=}(t[?(kyO6G;_5{47zw">energie</field> </block> </value> </block> </value> </block> </next> </block> </next> </block> </next> </block> </statement> </block> </next> </block> </next> </block> </next> </block> </next> </block> </statement> </block> </next> </block> </next> </block> </next> </block> </next> </block> </next> </block> </statement> <next> <block type="schedule" id="aet.;[c+_hK7wDr{G6C2"> <field name="SCHEDULE">*/60 * * * *</field> <statement name="STATEMENT"> <block type="telegram" id="v0$UV^ZB3-oU^7]v!RAz"> <field name="INSTANCE">.4</field> <field name="LOG"></field> <field name="SILENT">FALSE</field> <field name="PARSEMODE">default</field> <value name="MESSAGE"> <shadow type="text" id="Rxo{9t8UX(VxG=0:4SEp"> <field name="TEXT">text</field> </shadow> <block type="text_join" id="T74Mexxi6)W)GtL(_l+i"> <mutation items="8"></mutation> <value name="ADD0"> <block type="text" id="@~UO`IN9.n[P7axT*gtU"> <field name="TEXT">*** Aquarium Stromverbrauch ***</field> </block> </value> <value name="ADD1"> <block type="text_join" id="*b=9BOm)-|S1$d]a)8GT"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="zn@~H,2etpB|YZ4!YiE1"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="(@Ln*k6wFsCAw,tB6ydj"> <field name="TEXT">Aktuell </field> </block> </value> <value name="ADD2"> <block type="get_value" id="g4G/]%kK5M*VmH,tUcda"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Aktuell</field> </block> </value> <value name="ADD3"> <block type="text" id="a}?8/hAA+1]X4xIxDe]r"> <field name="TEXT"> kWh</field> </block> </value> </block> </value> <value name="ADD2"> <block type="text_join" id="XQor9*tmFToxv350~3a["> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="Vj#;a3p_e-np~YXNy6@r"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="nIWZE7{YZAROw`Jk0;wC"> <field name="TEXT">Verbrauch gestern </field> </block> </value> <value name="ADD2"> <block type="get_value" id="bv[E`]ToqDSpF,vlMNh~"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Gestern</field> </block> </value> <value name="ADD3"> <block type="text" id="r3ZT#_xm}R0uV;GYS/4o"> <field name="TEXT"> kWh</field> </block> </value> </block> </value> <value name="ADD3"> <block type="text_join" id="lxS:_dtgB(`PhaIZQWX`"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="bEge*!(ftsg%l0VVLfAj"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="sl;`FZ%+Ne[AuLV:HV.@"> <field name="TEXT">Verbrauch letzter Monat </field> </block> </value> <value name="ADD2"> <block type="get_value" id="xc^PZ^IOdUk|fc|9eoh;"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat</field> </block> </value> <value name="ADD3"> <block type="text" id="F:fOjp,n1._b*AfXe3th"> <field name="TEXT"> kWh</field> </block> </value> </block> </value> <value name="ADD4"> <block type="text_join" id="aw6y1|A}5o*MbWrdHY9p"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="#mt{)k$cy8`uL_gO}s(}"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="6HPgG=f|C)szqcpw[,@C"> <field name="TEXT">Verbrauch letztes Jahr </field> </block> </value> <value name="ADD2"> <block type="get_value" id="xbnX~3^bUmK-F@|H_hTp"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letztes_Jahr</field> </block> </value> <value name="ADD3"> <block type="text" id="UKfqr%$A(e+plg=|m1^:"> <field name="TEXT"> kWh</field> </block> </value> </block> </value> <value name="ADD5"> <block type="text_join" id="R:gZNVoGL(KF9Ln*j_d^"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="m9clcKkwp7cKTW^I34?e"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="?{%o]g(9,%4L%M6!DYAv"> <field name="TEXT">Kosten Tag </field> </block> </value> <value name="ADD2"> <block type="get_value" id="#VWuZRdM(}XDg3OL^_wt"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Tag</field> </block> </value> <value name="ADD3"> <block type="text" id="`rcUdx%%|ACCi+o=)X~R"> <field name="TEXT"> €</field> </block> </value> </block> </value> <value name="ADD6"> <block type="text_join" id="L=$=$F)=!;OgqNrVyabW"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="F+3QgsRX,n$UCu1;DT{!"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="|-WwMSy4tStB#F=]P(LC"> <field name="TEXT">Kosten Monat </field> </block> </value> <value name="ADD2"> <block type="math_rndfixed" id="JW[35xdn%,vmkv/k,:?|"> <field name="n">2</field> <value name="x"> <shadow type="math_number" id="NmJ(Yr(%(_)z]xNU|%{E"> <field name="NUM">3.1234</field> </shadow> <block type="math_arithmetic" id="RwW5ffAClCW|C0N,@opm"> <field name="OP">MULTIPLY</field> <value name="A"> <shadow type="math_number" id="pg}Y*W1KV3gV?Fo+7m}M"> <field name="NUM">1</field> </shadow> <block type="get_value" id="N#H|hnEdbxs/YwNmOE=K"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat</field> </block> </value> <value name="B"> <shadow type="math_number" id="J|RT4Dmp4sH6gj{Msj-."> <field name="NUM">1</field> </shadow> <block type="get_value" id="Off:*?MHo]qRW/nKwLUt"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.kW_Preis</field> </block> </value> </block> </value> </block> </value> <value name="ADD3"> <block type="text" id="3et?)Rne~PLpE}iGCbrM"> <field name="TEXT"> €</field> </block> </value> </block> </value> <value name="ADD7"> <block type="text_join" id="H3?].mnCpOk#%@ko-On/"> <mutation items="4"></mutation> <value name="ADD0"> <block type="text_newline" id="U:?6XJ2RC|jO#6L/.:QA"> <field name="Type">\n</field> </block> </value> <value name="ADD1"> <block type="text" id="2zM)w6?mBEx!N`We-nn0"> <field name="TEXT">Kosten Jahr </field> </block> </value> <value name="ADD2"> <block type="get_value" id="$$q9MX%}{2KBRJ-jb|vI"> <field name="ATTR">val</field> <field name="OID">0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Jahr</field> </block> </value> <value name="ADD3"> <block type="text" id="YTfJv6^/WgC2Kj8$!pZ("> <field name="TEXT"> €</field> </block> </value> </block> </value> </block> </value> </block> </statement> </block> </next> </block> </next> </block> </next> </block> </next> </block> </next> </block> </xml>var energie, kWh_Preis, verbrauch_heute, morgen, Stromverbrauch_Monat, Stromverbrauch_Jahr; // kWh energie = getState("0_userdata.0.Aqua_Control.0.Strom.Stomzähler_Total").val; kWh_Preis = getState("0_userdata.0.Aqua_Control.0.Strom.kW_Preis").val; on({id: 'hs100.0.192_168_0_28.power', change: "ne"}, async function (obj) { var value = obj.state.val; var oldValue = obj.oldState.val; energie = (typeof energie == 'number' ? energie : 0) + ((obj.oldState ? obj.oldState.val : "") * ((obj.state ? obj.state.lc : "") - (obj.oldState ? obj.oldState.lc : ""))) / 3600000000; setState("0_userdata.0.Aqua_Control.0.Strom.Stomzähler_Total"/*Stomzähler_Total*/, Math.round(energie*100)/100, true); verbrauch_heute = energie - getState("0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Mitternacht").val; setState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Aktuell"/*Stromverbrauch_Aktuell*/, Math.round(verbrauch_heute*100)/100, true); }); schedule("59 59 23 * * *", async function () { kWh_Preis = getState("0_userdata.0.Aqua_Control.0.Strom.kW_Preis").val; setState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Gestern"/*Stromverbrauch_Gestern*/, Math.round(verbrauch_heute*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Tag"/*Stomkosten_Tag*/, Math.round((parseFloat(kWh_Preis) * verbrauch_heute)*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Mitternacht"/*Stromzähler_Mitternacht*/, Math.round(energie*100)/100, true); morgen = (new Date().getTime()) + 2000; if (getDateObject(morgen).getDate() == 1) { Stromverbrauch_Monat = energie - getState("0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Monatsende").val; setState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat"/*Stromverbrauch_letzter_Monat*/, Math.round(Stromverbrauch_Monat*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Monat"/*Stromkosten_Monat*/, Math.round((getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat").val * getState("0_userdata.0.Aqua_Control.0.Strom.kW_Preis").val)*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromzähler_Monatsende"/*Stromzähler_Monatsende*/, Math.round(energie*100)/100, true); if ((getDateObject(morgen).getMonth() + 1) == 1) { Stromverbrauch_Jahr = energie - getState("0_userdata.0.Aqua_Control.0.Strom.Zählwert_Jahresende").val; setState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letztes_Jahr"/*Stromverbrauch_letztes_Jahr*/, Math.round(Stromverbrauch_Jahr*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Jahr"/*Stromkosten_Jahr*/, Math.round((parseFloat(kWh_Preis) * Stromverbrauch_Jahr)*100)/100, true); setState("0_userdata.0.Aqua_Control.0.Strom.Zählwert_Jahresende"/*Zählwert_Jahresende*/, Math.round(energie*100)/100, true); } } }); schedule("*/60 * * * *", async function () { sendTo("telegram.4", "send", { text: (['*** Aquarium Stromverbrauch ***',['\n','Aktuell ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Aktuell").val,' kWh'].join(''),['\n','Verbrauch gestern ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_Gestern").val,' kWh'].join(''),['\n','Verbrauch letzter Monat ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat").val,' kWh'].join(''),['\n','Verbrauch letztes Jahr ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letztes_Jahr").val,' kWh'].join(''),['\n','Kosten Tag ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Tag").val,' €'].join(''),['\n','Kosten Monat ',Math.round((getState("0_userdata.0.Aqua_Control.0.Strom.Stromverbrauch_letzter_Monat").val * getState("0_userdata.0.Aqua_Control.0.Strom.kW_Preis").val)*100)/100,' €'].join(''),['\n','Kosten Jahr ',getState("0_userdata.0.Aqua_Control.0.Strom.Stromkosten_Jahr").val,' €'].join('')].join('')) }); });
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren AnmeldenSupport us
570
Online32.8k
Benutzer82.7k
Themen1.3m
Beiträge