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.
    • 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

                          808
                          Online

                          32.0k
                          Users

                          80.4k
                          Topics

                          1.3m
                          Posts

                          blockly monitoring
                          3
                          54
                          2255
                          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