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

                        723
                        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