Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Skripten / Logik
    4. Blockly
    5. Strom Tagesverbrauch aus Datenbank

    NEWS

    • Wir empfehlen: Node.js 22.x

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker goes Matter ... Matter Adapter in Stable

    Strom Tagesverbrauch aus Datenbank

    This topic has been deleted. Only users with topic management privileges can see it.
    • paul53
      paul53 @Homoran last edited by

      @homoran sagte: Das macht auch alles der Source-Analytics Adapter.

      Mein Reden

      Aphofis 2 Replies Last reply Reply Quote 1
      • Aphofis
        Aphofis @paul53 last edited by

        @paul53
        Dann werde ich Dussel das mal ganz schnell ändern

        1 Reply Last reply Reply Quote 0
        • Aphofis
          Aphofis @paul53 last edited by Aphofis

          @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 1 Reply Last reply Reply Quote 0
          • paul53
            paul53 @Aphofis last edited by

            @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 1 Reply Last reply Reply Quote 0
            • Aphofis
              Aphofis @paul53 last edited by

              @paul53
              Ja habe alle Datenpunkte
              Als Zahl eingestellt aber kosten werden nicht angezeigt
              0FCA6800-464B-40DA-A464-6CFD52ED812A.jpeg

              paul53 1 Reply Last reply Reply Quote 0
              • paul53
                paul53 @Aphofis last edited by

                @aphofis sagte: kosten werden nicht angezeigt

                Dann prüfe mal:

                Bild_2021-09-30_110829.png

                Aphofis 1 Reply Last reply Reply Quote 0
                • Aphofis
                  Aphofis @paul53 last edited by

                  @paul53
                  Mahlzeit Paul wenn ich den trigger Manuel Aufrufe kommen diese Meldungen

                  67820AF6-E78A-4EB6-94F3-B41B119BFC84.jpeg C1FBAD59-3F2C-406C-A8EE-11D248CE6071.jpeg

                  paul53 1 Reply Last reply Reply Quote 0
                  • paul53
                    paul53 @Aphofis last edited by

                    @aphofis sagte: kommen diese Meldungen

                    0,3029 enthält immer noch ein Komma. Damit kann Javascript nicht rechnen (es nicht in eine Zahl wandeln).

                    Aphofis 1 Reply Last reply Reply Quote 0
                    • Aphofis
                      Aphofis @paul53 last edited by

                      @paul53
                      Muss es dann 0.3029 sein !?

                      paul53 1 Reply Last reply Reply Quote 0
                      • paul53
                        paul53 @Aphofis last edited by

                        @aphofis sagte: Muss es dann 0.3029 sein !?

                        Ja.

                        Aphofis 1 Reply Last reply Reply Quote 0
                        • Aphofis
                          Aphofis @paul53 last edited by

                          @paul53

                          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(''))
                            });
                          });
                          
                          paul53 1 Reply Last reply Reply Quote 0
                          • paul53
                            paul53 @Aphofis last edited by

                            @aphofis sagte: ist die berechnung so denn Korrekt !?

                            Ja, sieht richtig aus.

                            1 Reply Last reply Reply Quote 0
                            • First post
                              Last post

                            Support us

                            ioBroker
                            Community Adapters
                            Donate

                            853
                            Online

                            32.0k
                            Users

                            80.4k
                            Topics

                            1.3m
                            Posts

                            blockly monitoring
                            3
                            54
                            2250
                            Loading More Posts
                            • Oldest to Newest
                            • Newest to Oldest
                            • Most Votes
                            Reply
                            • Reply as topic
                            Log in to reply
                            Community
                            Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                            The ioBroker Community 2014-2023
                            logo