NEWS
Stromzählerscript PV Anlage Finanzamt in Json oder html
JavaScript
84
Beiträge
9
Kommentatoren
10.1k
Aufrufe
12
Watching
-
@wendy2702 habe ich auch...
komisch...
habe es eben probiert...Bei mir funktionierts.. ich kopier auch nochmal vom spoiler..warte.. -
@wendy2702
krass..geht tatsächlich nicht....probier es mal so..[{"tpl":"tplVis-materialdesign-Table","data":{"oid":"javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.JsonTable","g_fixed":false,"g_visibility":true,"g_css_font_text":false,"g_css_background":true,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":false,"g_last_change":false,"countCols":"15","tableLayout":"card","showHeader":true,"headerTextSize":"small","showColumn0":true,"colType0":"text","textAlign0":"center","showColumn1":true,"colType1":"text","textAlign1":"center","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"showColumn2":true,"colType2":"text","textAlign2":"center","showColumn3":true,"colType3":"text","textAlign3":"center","showColumn4":true,"colType4":"text","textAlign4":"center","showColumn5":true,"colType5":"text","textAlign5":"center","showColumn6":true,"colType6":"text","textAlign6":"center","showColumn7":"true","colType7":"text","textAlign7":"center","showColumn8":true,"colType8":"text","textAlign8":"center","showColumn9":"true","colType9":"text","textAlign9":"center","showColumn10":"true","colType10":"text","textAlign10":"center","showColumn11":"true","colType11":"text","textAlign11":"center","showColumn12":"true","colType12":"text","textAlign12":"center","showColumn13":"true","colType13":"text","textAlign13":"center","showColumn14":"true","colType14":"text","textAlign14":"center","showColumn15":"true","colType15":"text","textAlign15":"center","showColumn16":"true","colType16":"text","textAlign16":"center","showColumn17":"true","colType17":"text","textAlign17":"center","headerRowHeight":"50","label0":"Ablese-<br>Datum","colTextColor0":"#9c9c9c","prefix0":"","colorHeaderRowText":"#9c9c9c","dividers":"#9c9c9c","colorBackground":"rgb(50,50,50)","colorHeaderRowBackground":"rgb(50,50,50)","columnWidth0":"78","label1":"Ein-<br>Spei-<br>sung","label2":"Netz-<br>Be-<br>zug","label3":"Solar<br>Prod.","suffix3":"","suffix2":"","suffix1":"","label4":"Eigen-<br>Ver-<br>brauch","suffix4":"","label5":"Autark","suffix5":"","label6":"Ein- <br>Speis-<br>Zähler","suffix6":"","label7":"Bezug-<br>Zähler","suffix7":"","label8":"PV Zähler","suffix8":"","label9":"Privat-<br>Ent-<br>nahme","suffix9":"","label10":"Ust.","rowHeight":"30","colorRowText":"#9c9c9c","borderColor":"transparent","colorRowBackground":"rgb(50,50,50)","dataJson":"","colNoWrap1":false,"colNoWrap0":false,"colNoWrap3":false,"showColumn18":"true","colType18":"text","textAlign18":"center","showColumn19":"true","colType19":"text","textAlign19":"center","showColumn20":"true","colType20":"text","textAlign20":"center","colNoWrap5":false,"colNoWrap4":false,"colNoWrap6":false,"colNoWrap7":false,"colNoWrap8":false,"colNoWrap9":false,"colNoWrap10":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","colTextColor2":"red","colTextColor10":"lightgreen","fixedHeader":true,"colTextColor3":"green","colTextColor1":"lightgreen","colTextColor4":"orange","colTextColor5":"yellow","colNoWrap2":false,"columnWidth6":"60","colTextColor6":"lightgreen","colTextColor7":"red","colTextColor8":"green","columnWidth7":"60","columnWidth3":"55","columnWidth4":"55","columnWidth9":"55","colTextColor9":"orange","columnWidth1":"55","columnWidth2":"50","columnWidth5":"55","columnWidth8":"60","columnWidth10":"50","label11":"Mwst<br>Satz","label12":"Netto<br>Strom-<br>preis <br> FA","visibility-oid":"javascript.0.Vis.Zählertabelle","columnWidth12":"60","colNoWrap12":false,"columnWidth13":"60","label13":"Netto<br>Strom-<br>preis","columnWidth14":"64","label14":"Strom <br> Grund- <br> Gebühr","columnWidth11":"50","headerFontFamily":"{vis-materialdesign.0.fonts.table.header}","colorRowBackgroundHover":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.table.row_hover;dark:vis-materialdesign.0.colors.dark.table.row_hover; mode === \"true\" ? dark : light}","colTextSize0":"smaller","fontFamily0":"{vis-materialdesign.0.fonts.table.row}","colTextSize1":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily1":"{vis-materialdesign.0.fonts.table.row}","colTextSize2":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily2":"{vis-materialdesign.0.fonts.table.row}","colTextSize3":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily3":"{vis-materialdesign.0.fonts.table.row}","colTextSize4":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily4":"{vis-materialdesign.0.fonts.table.row}","colTextSize5":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily5":"{vis-materialdesign.0.fonts.table.row}","colTextSize6":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily6":"{vis-materialdesign.0.fonts.table.row}","colTextSize7":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily7":"{vis-materialdesign.0.fonts.table.row}","colTextSize8":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily8":"{vis-materialdesign.0.fonts.table.row}","colTextSize9":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily9":"{vis-materialdesign.0.fonts.table.row}","colTextSize10":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily10":"{vis-materialdesign.0.fonts.table.row}","colTextSize11":"small","fontFamily11":"{vis-materialdesign.0.fonts.table.row}","colTextSize12":"small","fontFamily12":"{vis-materialdesign.0.fonts.table.row}","colTextSize13":"small","fontFamily13":"{vis-materialdesign.0.fonts.table.row}","colTextSize14":"xx-small","fontFamily14":"{vis-materialdesign.0.fonts.table.row}","colTextSize15":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily15":"{vis-materialdesign.0.fonts.table.row}","columnWidth15":"67","label15":"Ein- <br>speise- <br>vergütung","padding_right14":"","padding_left14":"","padding_left15":"","imageSize15":"","colTextColor15":"lightgreen"},"style":{"left":"10px","top":"5px","width":"940px","height":"357px","z-index":"10","background-color":"rgb(50,50,50)","overflow-x":"auto","overflow-y":"auto"},"widgetSet":"materialdesign"},{"tpl":"tplVis-materialdesign-Input","data":{"oid":"javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.Nettostrompreis","g_fixed":false,"g_visibility":true,"g_css_font_text":false,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":false,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","inputType":"number","inputLayout":"filled","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"inputPrefix":"","inputSuffix":"€ / kWh Nettostrompreis","inputAppendixColor":"#9c9c9c","inputTextColor":"#9c9c9c","inputMaxLength":"","g_icons":true,"inputLayoutBackgroundColor":"rgb(50,50,50)","inputLayoutBackgroundColorSelected":"rgb(50,50,50)","inputTextFontSize":"16","inputAppendixFontSize":"16","inputMask":"","g_inputLabel":false,"g_inputSubText":false,"g_counter":true,"clearIconShow":"true","showInputMessageAlways":"true","inputLayoutBorderColor":"rgb(50,50,50)","inputLayoutBorderColorSelected":"rgb(50,50,50)","inputLayoutBorderColorHover":"rgb(50,50,50)","clearIconColor":"red","showInputCounter":false,"inputAppendixFontFamily":"","inputLayoutBackgroundColorHover":"rgb(50,50,50)","exportData":"true","visibility-oid":"javascript.0.Vis.Zählertabelle","inputAlignment":"left","inputTextFontFamily":"{vis-materialdesign.0.fonts.input.text}","inputLabelColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.label;dark:vis-materialdesign.0.colors.dark.input.label; mode === \"true\" ? dark : light}","inputLabelColorSelected":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.label_selected;dark:vis-materialdesign.0.colors.dark.input.label_selected; mode === \"true\" ? dark : light}","inputLabelFontFamily":"{vis-materialdesign.0.fonts.input.label}","inputLabelFontSize":"{vis-materialdesign.0.fontSizes.input.label}","inputMessageFontFamily":"{vis-materialdesign.0.fonts.input.message}","inputMessageFontSize":"{vis-materialdesign.0.fontSizes.input.message}","inputMessageColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.message;dark:vis-materialdesign.0.colors.dark.input.message; mode === \"true\" ? dark : light}","inputCounterColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.counter;dark:vis-materialdesign.0.colors.dark.input.counter; mode === \"true\" ? dark : light}","inputCounterFontSize":"{vis-materialdesign.0.fontSizes.input.counter}","inputCounterFontFamily":"{vis-materialdesign.0.fonts.input.counter}"},"style":{"left":"188px","top":"369px","z-index":"10","width":"380px","height":"41px","font-size":"small","font-weight":"normal"},"widgetSet":"materialdesign"},{"tpl":"tplVis-materialdesign-Input","data":{"oid":"javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NettoGrundpreis","g_fixed":false,"g_visibility":true,"g_css_font_text":false,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":false,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","inputType":"number","inputLayout":"filled","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"inputPrefix":"","inputSuffix":"€ / Monat Nettogrundpreis Strom","inputAppendixColor":"#9c9c9c","inputTextColor":"#9c9c9c","inputMaxLength":"","g_icons":true,"inputLayoutBackgroundColor":"rgb(50,50,50)","inputLayoutBackgroundColorSelected":"rgb(50,50,50)","inputTextFontSize":"16","inputAppendixFontSize":"16","inputMask":"","g_inputLabel":false,"g_inputSubText":false,"g_counter":true,"clearIconShow":"true","showInputMessageAlways":"true","inputLayoutBorderColor":"rgb(50,50,50)","inputLayoutBorderColorSelected":"rgb(50,50,50)","inputLayoutBorderColorHover":"rgb(50,50,50)","clearIconColor":"red","showInputCounter":false,"inputAppendixFontFamily":"","inputLayoutBackgroundColorHover":"rgb(50,50,50)","exportData":"true","visibility-oid":"javascript.0.Vis.Zählertabelle","inputAlignment":"left","inputTextFontFamily":"{vis-materialdesign.0.fonts.input.text}","inputLabelColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.label;dark:vis-materialdesign.0.colors.dark.input.label; mode === \"true\" ? dark : light}","inputLabelColorSelected":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.label_selected;dark:vis-materialdesign.0.colors.dark.input.label_selected; mode === \"true\" ? dark : light}","inputLabelFontFamily":"{vis-materialdesign.0.fonts.input.label}","inputLabelFontSize":"{vis-materialdesign.0.fontSizes.input.label}","inputMessageFontFamily":"{vis-materialdesign.0.fonts.input.message}","inputMessageFontSize":"{vis-materialdesign.0.fontSizes.input.message}","inputMessageColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.message;dark:vis-materialdesign.0.colors.dark.input.message; mode === \"true\" ? dark : light}","inputCounterColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.counter;dark:vis-materialdesign.0.colors.dark.input.counter; mode === \"true\" ? dark : light}","inputCounterFontSize":"{vis-materialdesign.0.fontSizes.input.counter}","inputCounterFontFamily":"{vis-materialdesign.0.fonts.input.counter}"},"style":{"left":"573px","top":"369px","z-index":"10","width":"380px","height":"41px","font-size":"small","font-weight":"normal"},"widgetSet":"materialdesign"},{"tpl":"tplVis-materialdesign-Select","data":{"oid":"javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.Mehrwertsteuersatz","g_fixed":false,"g_visibility":true,"g_css_font_text":true,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":true,"g_gestures":false,"g_signals":false,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","inputType":"text","inputLayout":"regular","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"inputLayoutBackgroundColor":"rgb(50,50,50)","inputLayoutBackgroundColorSelected":"rgb(50,50,50)","inputTextColor":"#9c9c9c","g_inputAppendix":false,"g_inputSubText":false,"g_counter":true,"g_icons":true,"g_selectListLayout":true,"g_listData":true,"listDataMethod":"valueList","countSelectItems":"","g_menuItems_§0":true,"g_menuItems_§1":false,"valueList":"14;15;16;17;18;19;20;21;22","valueListLabels":"Ust 14 %;Ust 15 %;Ust 16 %;Ust 17 %;Ust 18 %;Ust 19 %;Ust 20 %;Ust 21 %;Ust 22 %","inputLayoutBackgroundColorHover":"rgb(50,50,50)","inputLayoutBorderColor":"rgb(50,50,50)","inputLayoutBorderColorHover":"rgb(50,50,50)","inputLayoutBorderColorSelected":"rgb(50,50,50)","jsonStringObject":"","g_inputLabel":true,"clearIconShow":false,"inputLabelText":"","clearIconColor":"#9c9c9c","prepandIcon":"","prepandIconColor":"#9c9c9c","prepandInnerIconColor":"#9c9c9c","appendOuterIconColor":"#9c9c9c","inputLabelColor":"#9c9c9c","inputLabelFontSize":"","collapseIconSize":"30","collapseIconColor":"#9c9c9c","clearIconSize":"30","collapseIcon":"","prepandIconSize":"","prepandInnerIcon":"percent","appendOuterIconSize":"","prepandInnerIconSize":"15","showInputMessageAlways":"true","showInputCounter":false,"listPosition":"bottom","showSelectedIcon":"no","showValue":"true","listPositionOffset":true,"listItemHeight":"","listItemBackgroundColor":"rgb(50,50,50)","listItemBackgroundHoverColor":"rgb(50,50,50)","listItemBackgroundSelectedColor":"rgb(50,50,50)","listItemRippleEffectColor":"rgb(50,50,50)","listIconSize":"30","listIconColor":"#9c9c9c","listIconHoverColor":"#9c9c9c","listIconSelectedColor":"#9c9c9c","listItemFontColor":"#9c9c9c","listItemFontHoverColor":"#9c9c9c","listItemFontSelectedColor":"#9c9c9c","listItemSubFontHoverColor":"#9c9c9c","listItemSubFontSelectedColor":"#9c9c9c","listItemValueFontColor":"#9c9c9c","listItemValueFontHoverColor":"#9c9c9c","listItemValueFontSelectedColor":"#9c9c9c","inputCounterColor":"transparent","valueListIcons":"","g_menuItems_§2":false,"g_menuItems_§3":false,"g_menuItems_§4":false,"g_menuItems_§5":false,"inputLabelColorSelected":"#9c9c9c","vibrateOnMobilDevices":"50","visibility-oid":"javascript.0.Vis.Zählertabelle","inputAlignment":"left","inputTextFontFamily":"{vis-materialdesign.0.fonts.input.text}","inputTextFontSize":"{vis-materialdesign.0.fontSizes.input.text}","inputLabelFontFamily":"{vis-materialdesign.0.fonts.input.label}","inputAppendixColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.appendix;dark:vis-materialdesign.0.colors.dark.input.appendix; mode === \"true\" ? dark : light}","inputAppendixFontSize":"{vis-materialdesign.0.fontSizes.input.appendix}","inputAppendixFontFamily":"{vis-materialdesign.0.fonts.input.appendix}","inputMessageFontFamily":"{vis-materialdesign.0.fonts.input.message}","inputMessageFontSize":"{vis-materialdesign.0.fontSizes.input.message}","inputMessageColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.message;dark:vis-materialdesign.0.colors.dark.input.message; mode === \"true\" ? dark : light}","inputCounterFontSize":"{vis-materialdesign.0.fontSizes.input.counter}","inputCounterFontFamily":"{vis-materialdesign.0.fonts.input.counter}","listItemFontSize":"{vis-materialdesign.0.fontSizes.input.dropdown.text}","listItemFont":"{vis-materialdesign.0.fonts.input.dropdown.text}","listItemSubFontSize":"{vis-materialdesign.0.fontSizes.input.dropdown.subText}","listItemSubFont":"{vis-materialdesign.0.fonts.input.dropdown.subText}","listItemSubFontColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.menu.subText;dark:vis-materialdesign.0.colors.dark.input.menu.subText; mode === \"true\" ? dark : light}","listItemValueFontSize":"{vis-materialdesign.0.fontSizes.input.dropdown.value}","listItemValueFont":"{vis-materialdesign.0.fonts.input.dropdown.value}"},"style":{"left":"10px","top":"366px","z-index":"30","color":"#9c9c9c","width":"172px","height":"40px","text-align":"center","font-weight":"normal","line-height":"","font-size":"small","border-width":"0px","border-style":"solid","border-color":"transparent","border-radius":"0px"},"widgetSet":"materialdesign"}] -
@wendy2702
ich habe oben im Beitrag den Spoiler gegen eine Textdatei ersetzt... -
Hab hier nochmal editiert..
Das Script startet 1 mal im monat... Wenn du es tesen willst kannst den schedule ja mal auf jede sekunde ändern...
https://forum.iobroker.net/topic/35659/stromzählerscript-pv-anlage-finanzamt-in-json-oder-html/58
Wenn du 0 lässt machst nix falsch.
Da aber erst Februar ist, würde ich versuchen die Werte vom 01.01.2021 einzutragen, dann beinhaltet die 1. Spalte halt den Monat Januar und Februar -
@wendy2702
krass..geht tatsächlich nicht....probier es mal so..[{"tpl":"tplVis-materialdesign-Table","data":{"oid":"javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.JsonTable","g_fixed":false,"g_visibility":true,"g_css_font_text":false,"g_css_background":true,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":false,"g_last_change":false,"countCols":"15","tableLayout":"card","showHeader":true,"headerTextSize":"small","showColumn0":true,"colType0":"text","textAlign0":"center","showColumn1":true,"colType1":"text","textAlign1":"center","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"showColumn2":true,"colType2":"text","textAlign2":"center","showColumn3":true,"colType3":"text","textAlign3":"center","showColumn4":true,"colType4":"text","textAlign4":"center","showColumn5":true,"colType5":"text","textAlign5":"center","showColumn6":true,"colType6":"text","textAlign6":"center","showColumn7":"true","colType7":"text","textAlign7":"center","showColumn8":true,"colType8":"text","textAlign8":"center","showColumn9":"true","colType9":"text","textAlign9":"center","showColumn10":"true","colType10":"text","textAlign10":"center","showColumn11":"true","colType11":"text","textAlign11":"center","showColumn12":"true","colType12":"text","textAlign12":"center","showColumn13":"true","colType13":"text","textAlign13":"center","showColumn14":"true","colType14":"text","textAlign14":"center","showColumn15":"true","colType15":"text","textAlign15":"center","showColumn16":"true","colType16":"text","textAlign16":"center","showColumn17":"true","colType17":"text","textAlign17":"center","headerRowHeight":"50","label0":"Ablese-<br>Datum","colTextColor0":"#9c9c9c","prefix0":"","colorHeaderRowText":"#9c9c9c","dividers":"#9c9c9c","colorBackground":"rgb(50,50,50)","colorHeaderRowBackground":"rgb(50,50,50)","columnWidth0":"78","label1":"Ein-<br>Spei-<br>sung","label2":"Netz-<br>Be-<br>zug","label3":"Solar<br>Prod.","suffix3":"","suffix2":"","suffix1":"","label4":"Eigen-<br>Ver-<br>brauch","suffix4":"","label5":"Autark","suffix5":"","label6":"Ein- <br>Speis-<br>Zähler","suffix6":"","label7":"Bezug-<br>Zähler","suffix7":"","label8":"PV Zähler","suffix8":"","label9":"Privat-<br>Ent-<br>nahme","suffix9":"","label10":"Ust.","rowHeight":"30","colorRowText":"#9c9c9c","borderColor":"transparent","colorRowBackground":"rgb(50,50,50)","dataJson":"","colNoWrap1":false,"colNoWrap0":false,"colNoWrap3":false,"showColumn18":"true","colType18":"text","textAlign18":"center","showColumn19":"true","colType19":"text","textAlign19":"center","showColumn20":"true","colType20":"text","textAlign20":"center","colNoWrap5":false,"colNoWrap4":false,"colNoWrap6":false,"colNoWrap7":false,"colNoWrap8":false,"colNoWrap9":false,"colNoWrap10":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","colTextColor2":"red","colTextColor10":"lightgreen","fixedHeader":true,"colTextColor3":"green","colTextColor1":"lightgreen","colTextColor4":"orange","colTextColor5":"yellow","colNoWrap2":false,"columnWidth6":"60","colTextColor6":"lightgreen","colTextColor7":"red","colTextColor8":"green","columnWidth7":"60","columnWidth3":"55","columnWidth4":"55","columnWidth9":"55","colTextColor9":"orange","columnWidth1":"55","columnWidth2":"50","columnWidth5":"55","columnWidth8":"60","columnWidth10":"50","label11":"Mwst<br>Satz","label12":"Netto<br>Strom-<br>preis <br> FA","visibility-oid":"javascript.0.Vis.Zählertabelle","columnWidth12":"60","colNoWrap12":false,"columnWidth13":"60","label13":"Netto<br>Strom-<br>preis","columnWidth14":"64","label14":"Strom <br> Grund- <br> Gebühr","columnWidth11":"50","headerFontFamily":"{vis-materialdesign.0.fonts.table.header}","colorRowBackgroundHover":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.table.row_hover;dark:vis-materialdesign.0.colors.dark.table.row_hover; mode === \"true\" ? dark : light}","colTextSize0":"smaller","fontFamily0":"{vis-materialdesign.0.fonts.table.row}","colTextSize1":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily1":"{vis-materialdesign.0.fonts.table.row}","colTextSize2":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily2":"{vis-materialdesign.0.fonts.table.row}","colTextSize3":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily3":"{vis-materialdesign.0.fonts.table.row}","colTextSize4":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily4":"{vis-materialdesign.0.fonts.table.row}","colTextSize5":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily5":"{vis-materialdesign.0.fonts.table.row}","colTextSize6":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily6":"{vis-materialdesign.0.fonts.table.row}","colTextSize7":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily7":"{vis-materialdesign.0.fonts.table.row}","colTextSize8":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily8":"{vis-materialdesign.0.fonts.table.row}","colTextSize9":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily9":"{vis-materialdesign.0.fonts.table.row}","colTextSize10":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily10":"{vis-materialdesign.0.fonts.table.row}","colTextSize11":"small","fontFamily11":"{vis-materialdesign.0.fonts.table.row}","colTextSize12":"small","fontFamily12":"{vis-materialdesign.0.fonts.table.row}","colTextSize13":"small","fontFamily13":"{vis-materialdesign.0.fonts.table.row}","colTextSize14":"xx-small","fontFamily14":"{vis-materialdesign.0.fonts.table.row}","colTextSize15":"{vis-materialdesign.0.fontSizes.table.row}","fontFamily15":"{vis-materialdesign.0.fonts.table.row}","columnWidth15":"67","label15":"Ein- <br>speise- <br>vergütung","padding_right14":"","padding_left14":"","padding_left15":"","imageSize15":"","colTextColor15":"lightgreen"},"style":{"left":"10px","top":"5px","width":"940px","height":"357px","z-index":"10","background-color":"rgb(50,50,50)","overflow-x":"auto","overflow-y":"auto"},"widgetSet":"materialdesign"},{"tpl":"tplVis-materialdesign-Input","data":{"oid":"javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.Nettostrompreis","g_fixed":false,"g_visibility":true,"g_css_font_text":false,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":false,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","inputType":"number","inputLayout":"filled","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"inputPrefix":"","inputSuffix":"€ / kWh Nettostrompreis","inputAppendixColor":"#9c9c9c","inputTextColor":"#9c9c9c","inputMaxLength":"","g_icons":true,"inputLayoutBackgroundColor":"rgb(50,50,50)","inputLayoutBackgroundColorSelected":"rgb(50,50,50)","inputTextFontSize":"16","inputAppendixFontSize":"16","inputMask":"","g_inputLabel":false,"g_inputSubText":false,"g_counter":true,"clearIconShow":"true","showInputMessageAlways":"true","inputLayoutBorderColor":"rgb(50,50,50)","inputLayoutBorderColorSelected":"rgb(50,50,50)","inputLayoutBorderColorHover":"rgb(50,50,50)","clearIconColor":"red","showInputCounter":false,"inputAppendixFontFamily":"","inputLayoutBackgroundColorHover":"rgb(50,50,50)","exportData":"true","visibility-oid":"javascript.0.Vis.Zählertabelle","inputAlignment":"left","inputTextFontFamily":"{vis-materialdesign.0.fonts.input.text}","inputLabelColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.label;dark:vis-materialdesign.0.colors.dark.input.label; mode === \"true\" ? dark : light}","inputLabelColorSelected":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.label_selected;dark:vis-materialdesign.0.colors.dark.input.label_selected; mode === \"true\" ? dark : light}","inputLabelFontFamily":"{vis-materialdesign.0.fonts.input.label}","inputLabelFontSize":"{vis-materialdesign.0.fontSizes.input.label}","inputMessageFontFamily":"{vis-materialdesign.0.fonts.input.message}","inputMessageFontSize":"{vis-materialdesign.0.fontSizes.input.message}","inputMessageColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.message;dark:vis-materialdesign.0.colors.dark.input.message; mode === \"true\" ? dark : light}","inputCounterColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.counter;dark:vis-materialdesign.0.colors.dark.input.counter; mode === \"true\" ? dark : light}","inputCounterFontSize":"{vis-materialdesign.0.fontSizes.input.counter}","inputCounterFontFamily":"{vis-materialdesign.0.fonts.input.counter}"},"style":{"left":"188px","top":"369px","z-index":"10","width":"380px","height":"41px","font-size":"small","font-weight":"normal"},"widgetSet":"materialdesign"},{"tpl":"tplVis-materialdesign-Input","data":{"oid":"javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NettoGrundpreis","g_fixed":false,"g_visibility":true,"g_css_font_text":false,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":false,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","inputType":"number","inputLayout":"filled","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"inputPrefix":"","inputSuffix":"€ / Monat Nettogrundpreis Strom","inputAppendixColor":"#9c9c9c","inputTextColor":"#9c9c9c","inputMaxLength":"","g_icons":true,"inputLayoutBackgroundColor":"rgb(50,50,50)","inputLayoutBackgroundColorSelected":"rgb(50,50,50)","inputTextFontSize":"16","inputAppendixFontSize":"16","inputMask":"","g_inputLabel":false,"g_inputSubText":false,"g_counter":true,"clearIconShow":"true","showInputMessageAlways":"true","inputLayoutBorderColor":"rgb(50,50,50)","inputLayoutBorderColorSelected":"rgb(50,50,50)","inputLayoutBorderColorHover":"rgb(50,50,50)","clearIconColor":"red","showInputCounter":false,"inputAppendixFontFamily":"","inputLayoutBackgroundColorHover":"rgb(50,50,50)","exportData":"true","visibility-oid":"javascript.0.Vis.Zählertabelle","inputAlignment":"left","inputTextFontFamily":"{vis-materialdesign.0.fonts.input.text}","inputLabelColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.label;dark:vis-materialdesign.0.colors.dark.input.label; mode === \"true\" ? dark : light}","inputLabelColorSelected":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.label_selected;dark:vis-materialdesign.0.colors.dark.input.label_selected; mode === \"true\" ? dark : light}","inputLabelFontFamily":"{vis-materialdesign.0.fonts.input.label}","inputLabelFontSize":"{vis-materialdesign.0.fontSizes.input.label}","inputMessageFontFamily":"{vis-materialdesign.0.fonts.input.message}","inputMessageFontSize":"{vis-materialdesign.0.fontSizes.input.message}","inputMessageColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.message;dark:vis-materialdesign.0.colors.dark.input.message; mode === \"true\" ? dark : light}","inputCounterColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.counter;dark:vis-materialdesign.0.colors.dark.input.counter; mode === \"true\" ? dark : light}","inputCounterFontSize":"{vis-materialdesign.0.fontSizes.input.counter}","inputCounterFontFamily":"{vis-materialdesign.0.fonts.input.counter}"},"style":{"left":"573px","top":"369px","z-index":"10","width":"380px","height":"41px","font-size":"small","font-weight":"normal"},"widgetSet":"materialdesign"},{"tpl":"tplVis-materialdesign-Select","data":{"oid":"javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.Mehrwertsteuersatz","g_fixed":false,"g_visibility":true,"g_css_font_text":true,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":true,"g_gestures":false,"g_signals":false,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","inputType":"text","inputLayout":"regular","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"inputLayoutBackgroundColor":"rgb(50,50,50)","inputLayoutBackgroundColorSelected":"rgb(50,50,50)","inputTextColor":"#9c9c9c","g_inputAppendix":false,"g_inputSubText":false,"g_counter":true,"g_icons":true,"g_selectListLayout":true,"g_listData":true,"listDataMethod":"valueList","countSelectItems":"","g_menuItems_§0":true,"g_menuItems_§1":false,"valueList":"14;15;16;17;18;19;20;21;22","valueListLabels":"Ust 14 %;Ust 15 %;Ust 16 %;Ust 17 %;Ust 18 %;Ust 19 %;Ust 20 %;Ust 21 %;Ust 22 %","inputLayoutBackgroundColorHover":"rgb(50,50,50)","inputLayoutBorderColor":"rgb(50,50,50)","inputLayoutBorderColorHover":"rgb(50,50,50)","inputLayoutBorderColorSelected":"rgb(50,50,50)","jsonStringObject":"","g_inputLabel":true,"clearIconShow":false,"inputLabelText":"","clearIconColor":"#9c9c9c","prepandIcon":"","prepandIconColor":"#9c9c9c","prepandInnerIconColor":"#9c9c9c","appendOuterIconColor":"#9c9c9c","inputLabelColor":"#9c9c9c","inputLabelFontSize":"","collapseIconSize":"30","collapseIconColor":"#9c9c9c","clearIconSize":"30","collapseIcon":"","prepandIconSize":"","prepandInnerIcon":"percent","appendOuterIconSize":"","prepandInnerIconSize":"15","showInputMessageAlways":"true","showInputCounter":false,"listPosition":"bottom","showSelectedIcon":"no","showValue":"true","listPositionOffset":true,"listItemHeight":"","listItemBackgroundColor":"rgb(50,50,50)","listItemBackgroundHoverColor":"rgb(50,50,50)","listItemBackgroundSelectedColor":"rgb(50,50,50)","listItemRippleEffectColor":"rgb(50,50,50)","listIconSize":"30","listIconColor":"#9c9c9c","listIconHoverColor":"#9c9c9c","listIconSelectedColor":"#9c9c9c","listItemFontColor":"#9c9c9c","listItemFontHoverColor":"#9c9c9c","listItemFontSelectedColor":"#9c9c9c","listItemSubFontHoverColor":"#9c9c9c","listItemSubFontSelectedColor":"#9c9c9c","listItemValueFontColor":"#9c9c9c","listItemValueFontHoverColor":"#9c9c9c","listItemValueFontSelectedColor":"#9c9c9c","inputCounterColor":"transparent","valueListIcons":"","g_menuItems_§2":false,"g_menuItems_§3":false,"g_menuItems_§4":false,"g_menuItems_§5":false,"inputLabelColorSelected":"#9c9c9c","vibrateOnMobilDevices":"50","visibility-oid":"javascript.0.Vis.Zählertabelle","inputAlignment":"left","inputTextFontFamily":"{vis-materialdesign.0.fonts.input.text}","inputTextFontSize":"{vis-materialdesign.0.fontSizes.input.text}","inputLabelFontFamily":"{vis-materialdesign.0.fonts.input.label}","inputAppendixColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.appendix;dark:vis-materialdesign.0.colors.dark.input.appendix; mode === \"true\" ? dark : light}","inputAppendixFontSize":"{vis-materialdesign.0.fontSizes.input.appendix}","inputAppendixFontFamily":"{vis-materialdesign.0.fonts.input.appendix}","inputMessageFontFamily":"{vis-materialdesign.0.fonts.input.message}","inputMessageFontSize":"{vis-materialdesign.0.fontSizes.input.message}","inputMessageColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.message;dark:vis-materialdesign.0.colors.dark.input.message; mode === \"true\" ? dark : light}","inputCounterFontSize":"{vis-materialdesign.0.fontSizes.input.counter}","inputCounterFontFamily":"{vis-materialdesign.0.fonts.input.counter}","listItemFontSize":"{vis-materialdesign.0.fontSizes.input.dropdown.text}","listItemFont":"{vis-materialdesign.0.fonts.input.dropdown.text}","listItemSubFontSize":"{vis-materialdesign.0.fontSizes.input.dropdown.subText}","listItemSubFont":"{vis-materialdesign.0.fonts.input.dropdown.subText}","listItemSubFontColor":"{mode:vis-materialdesign.0.colors.darkTheme;light:vis-materialdesign.0.colors.light.input.menu.subText;dark:vis-materialdesign.0.colors.dark.input.menu.subText; mode === \"true\" ? dark : light}","listItemValueFontSize":"{vis-materialdesign.0.fontSizes.input.dropdown.value}","listItemValueFont":"{vis-materialdesign.0.fonts.input.dropdown.value}"},"style":{"left":"10px","top":"366px","z-index":"30","color":"#9c9c9c","width":"172px","height":"40px","text-align":"center","font-weight":"normal","line-height":"","font-size":"small","border-width":"0px","border-style":"solid","border-color":"transparent","border-radius":"0px"},"widgetSet":"materialdesign"}]@smartboart sagte in Stromzählerscript PV Anlage Finanzamt in Json oder html:
Das hier hat funktioniert.
Danke!
Bitte keine Fragen per PN, die gehören ins Forum!
Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.
-
@smartboart sagte in Stromzählerscript PV Anlage Finanzamt in Json oder html:
Das hier hat funktioniert.
Danke!
@wendy2702 Muss nochmal Fragen:
habe den Schedule zum testen auf ´4 * * * *` gestellt aber meine Tabelle stoppt mit Eintrag vom 26.02.
Sollten da nicht auch Zeilen von heute auftauchen ?
Bitte keine Fragen per PN, die gehören ins Forum!
Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.
-
@wendy2702 Muss nochmal Fragen:
habe den Schedule zum testen auf ´4 * * * *` gestellt aber meine Tabelle stoppt mit Eintrag vom 26.02.
Sollten da nicht auch Zeilen von heute auftauchen ?
@wendy2702 sagte in Stromzählerscript PV Anlage Finanzamt in Json oder html:
´4 * * * *`
Jede 4 Minute jede Stunde..
sollte ein Eintrag erfolgen mit deinem Chron...Scroll die Tabelle mal nach unten...
Schau mal im log ob entsprechend ein Eintrag erfolgt..
aktiviere mal var debug = true; und schau im log was in die Tabelle geschrieben wird.. -
@wendy2702 sagte in Stromzählerscript PV Anlage Finanzamt in Json oder html:
´4 * * * *`
Jede 4 Minute jede Stunde..
sollte ein Eintrag erfolgen mit deinem Chron...Scroll die Tabelle mal nach unten...
Schau mal im log ob entsprechend ein Eintrag erfolgt..
aktiviere mal var debug = true; und schau im log was in die Tabelle geschrieben wird..@smartboart Hm,
gibt in meiner Tabelle keinen Scrollbalken.
Im Json steht als letztes Datum auch der 26.02.
ich werde mal auf Debug stellen.
EDIT: Jetzt mal auf minütlichen lauf gestellt.
Zwei läufe im Log aber keine Änderung des JSON mehr wie es aussieht.
Bitte keine Fragen per PN, die gehören ins Forum!
Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.
-
@smartboart Hm,
gibt in meiner Tabelle keinen Scrollbalken.
Im Json steht als letztes Datum auch der 26.02.
ich werde mal auf Debug stellen.
EDIT: Jetzt mal auf minütlichen lauf gestellt.
Zwei läufe im Log aber keine Änderung des JSON mehr wie es aussieht.
@wendy2702 das ist komisch...
halte das Script mal an... Lösche die Objekte zum Script... Wenn du redis hast warte ne weile oder reboote dann mal und dann starte das Script neu.. -
@smartboart Hm,
gibt in meiner Tabelle keinen Scrollbalken.
Im Json steht als letztes Datum auch der 26.02.
ich werde mal auf Debug stellen.
EDIT: Jetzt mal auf minütlichen lauf gestellt.
Zwei läufe im Log aber keine Änderung des JSON mehr wie es aussieht.
@wendy2702 schau vorher mal ob die Datei angelegt wurde und ob diese weiter beschrieben wird... Dann liegt es am json state.. Aber da müsste Dann auch was im log stehen...
-
@wendy2702 schau vorher mal ob die Datei angelegt wurde und ob diese weiter beschrieben wird... Dann liegt es am json state.. Aber da müsste Dann auch was im log stehen...
@smartboart Datei wird angelegt.
Aktuell stehen die letzten Einträge von gestern drin.
In der Tabelle aber nur bis 26.02.
Werden alte einträge in der Tabelle nicht raus geschoben oder sollte ich einen Scrollbalken bekommen?
Bitte keine Fragen per PN, die gehören ins Forum!
Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.
-
@smartboart Datei wird angelegt.
Aktuell stehen die letzten Einträge von gestern drin.
In der Tabelle aber nur bis 26.02.
Werden alte einträge in der Tabelle nicht raus geschoben oder sollte ich einen Scrollbalken bekommen?
@wendy2702
Welches Widget verwendest du zur Anzeige ?
Du solltest eine Scrollbalken bekommen, wenn nicht dann mal die Einstellungen vom Widget prüfen. -
@smartboart Datei wird angelegt.
Aktuell stehen die letzten Einträge von gestern drin.
In der Tabelle aber nur bis 26.02.
Werden alte einträge in der Tabelle nicht raus geschoben oder sollte ich einen Scrollbalken bekommen?
@wendy2702 die Tabelle wird nur auf 12 einträge begrenzt wenn du die variable entsprechend auf true gesetzt hast:
var Begrenzung = false; // Wenn auf 12 Monatseinträge begrenzt werden soll, auf true setzen..
Wenn die Werte aber in der Datei sind, müssen sie auch im json state sein...wenn nicht stimmt damit was nicht. Die Tabelle zeigt den Inhalt des JSOn state an Was da nicht drinne ist ist auch nicht in der Tabelle. Hast den Stet mal neu angelegt wie ich es schon mal vorgeschlagen habe und oder mal im log nach Fehler geschaut wie z.B das der state nicht beschrieben werden kann oder nicht da ist?
Bei dem Script kann man eigentlich nix falsch machen. Es müssen nur die 3 Stromzähler angepasst werden , dann läuft es...
Natürlich sollten die Parameter wie Strompreis usw.auch angepasst werden. sind aber nicht essentiell für die Lauffähigkeit. -
@wendy2702 die Tabelle wird nur auf 12 einträge begrenzt wenn du die variable entsprechend auf true gesetzt hast:
var Begrenzung = false; // Wenn auf 12 Monatseinträge begrenzt werden soll, auf true setzen..
Wenn die Werte aber in der Datei sind, müssen sie auch im json state sein...wenn nicht stimmt damit was nicht. Die Tabelle zeigt den Inhalt des JSOn state an Was da nicht drinne ist ist auch nicht in der Tabelle. Hast den Stet mal neu angelegt wie ich es schon mal vorgeschlagen habe und oder mal im log nach Fehler geschaut wie z.B das der state nicht beschrieben werden kann oder nicht da ist?
Bei dem Script kann man eigentlich nix falsch machen. Es müssen nur die 3 Stromzähler angepasst werden , dann läuft es...
Natürlich sollten die Parameter wie Strompreis usw.auch angepasst werden. sind aber nicht essentiell für die Lauffähigkeit.@smartboart Ich schaue mir das morgen nochmal an.
Heute komme ich nicht mehr dazu.
-
File wird scheinbar beschrieben.
Da finde ich aktuelle Daten drin.
Allerdings kann ich den View weder im Editor noch in der VIS öffnen. Browser sagen immer das die Seite nicht mehr reagiert. Denke das liegt an den mittlerweile reichlich Werten.
Werde das nochmal von vorne Starten und den Schedule auf einmal Monatlich ändern. Mal sehen ob es dann auch bei mir läuft.
Bitte keine Fragen per PN, die gehören ins Forum!
Benutzt das Voting rechts unten im Beitrag wenn er euch geholfen hat.
-
File wird scheinbar beschrieben.
Da finde ich aktuelle Daten drin.
Allerdings kann ich den View weder im Editor noch in der VIS öffnen. Browser sagen immer das die Seite nicht mehr reagiert. Denke das liegt an den mittlerweile reichlich Werten.
Werde das nochmal von vorne Starten und den Schedule auf einmal Monatlich ändern. Mal sehen ob es dann auch bei mir läuft.
@wendy2702
Also als ich das script bearbeitet habe habe ich mit sekunden schedule getestet... Nach ein paar Einträgen kann man schon sagen das es klappt.
Dann das script gestoppt und alle states gelöscht. Dann das script im monatlichen schedule neu gestartet.
Ich arbeite mit redis und habe festgestellt, dass man hier ruihg etwas warten sollte nachdem man die states gelöscht hat... -
@wendy2702
Also als ich das script bearbeitet habe habe ich mit sekunden schedule getestet... Nach ein paar Einträgen kann man schon sagen das es klappt.
Dann das script gestoppt und alle states gelöscht. Dann das script im monatlichen schedule neu gestartet.
Ich arbeite mit redis und habe festgestellt, dass man hier ruihg etwas warten sollte nachdem man die states gelöscht hat...@smartboart Ich habe es aktuell gestoppt. Warte jetzt bis morgen und starte es dann mit monatlichem Trigger.
Danke für deine Hilfe.
-
Hallo Leute,
ArnoD war so freundlich sein script für die Aufbereitung von Zählerdaten bei Überschusseinspeisung als Unternehmer mit Umsatzsteuervoranmeldung hier im Forum zu teilen.
https://forum.iobroker.net/topic/32976/e3dc-hauskraftwerk-steuern/197
Nach Rückfrage, ob er was dagegen hätte hierfür einen neuen Threat zu eröffnen, um das Script weiter aufzubohren, hatte er dies begüßt.Hintergrund ist nun, dass diese Menge an States und Daten besser in einer Json Tabelle oder html Tabelle aufgehoben wären um die Daten in Vis darzustellen und evtl. zusätzlich als txt Datei lokal oder auf dem NAS abzulegen.
EDIT:
ich habe das Skript von ArnoD mit Hilfe von paul53 weiter aufgebohrt un um die Kostenberechnung für die Privatentnahme erweitert. Ebenfalls 2 States hinzu um die Stromkosten und mittlerweile wechselhafte MWST über vis anzupassen.EDIT:
Taelle erweitert um aktuelle Mwst und aktueller Strompreis und log Ausgabe.EDIT:
Skript erweitert, es werden nunzusätzlich alleDaten in eine CSV Datei geschrieben./* Zweck: Stromzählerscript / Smartmeter PV Anlage Tabelle für Finanzamt in Json Stand: 10.10.2020 Forumthreat: https://forum.iobroker.net/topic/35659/stromz%C3%A4hlerscript-pv-anlage-finanzamt-in-json-oder-html Änderungen: 10.10.2020 - Smartboart: Export der Liste in json auf das filesystem / Festplatte. 26.02.2020 - Smartboard: Forumswunsch Erweiterung Verguetung */ // Hausstromverbrauch aktuell berechnen ************************************************************************** createState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NetzbezugAlt', 0, {name: 'lezter Zählerstand Monatsbeginn', type: 'number', unit: 'kWh' }); createState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NetzeinspeisungAlt', 0, {name: 'lezter Zählerstand Monatsbeginn', type: 'number', unit: 'kWh' }); createState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.SolarproduktionAlt', 0, {name: 'lezter Zählerstand Monatsbeginn', type: 'number', unit: 'kWh' }); createState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.Mehrwertsteuersatz', 16, {name: 'aktueller Mehrwertsteuersatz', type: 'number', unit: '%' }); createState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.Nettostrompreis', 0.2638, {name: 'Strompreis netto pro kwh', type: 'number', unit: '€' }); createState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NettoGrundpreis', 0, {name: 'Grundpreis netto pro Monat', type: 'number', unit: '€' }); const idJson = 'javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.JsonTable'; var logging = true; var debug = false; var Begrenzung = false; // Wenn auf 12 Monatseinträge begrenzt werden soll, auf true setzen var Verguetung_kwh = 0.0903; // €pro kWh var LogPath = "/home/pi/Smartmeter/Finanzamt_Tabelle.json"; var fs = require('fs'); var logflag = true; writelog(); //Um 00:00:55 am 1 in jeden Monat speichern für das Finanzamt schedule('55 0 0 1 * *', function() { if (logging)log('Smartmeter Zählerstände FA Tabelle: Schedule Monatliche Berechnung fürs Finanzamt aktiv'); var nBezugZaehlerAktuell = Math.floor(getState('smartmeter.0.1-0:1_8_0__255.value').val); var nEinspeiseZaehlerAktuell = Math.floor(getState('smartmeter.0.1-0:2_8_0__255.value').val); var PvZaehlerAktuell=Math.floor(getState('modbus.0.holdingRegisters.12288_E3DC_Lieferung Summe'/*12288 E3dc Lieferung Summe*/).val); var MWST = getState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.Mehrwertsteuersatz').val; var NettoStromPreis = getState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.Nettostrompreis').val; var NettoGrundpreis = getState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NettoGrundpreis').val; var nBezugZaehlerAlt = getState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NetzbezugAlt').val; var nEinspeiseZaehlerAlt = getState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NetzeinspeisungAlt').val; var PvZaehlerAlt=getState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.SolarproduktionAlt').val; var nBezugZaehlerNeu = nBezugZaehlerAktuell - nBezugZaehlerAlt; var nEinspeiseZaehlerNeu = nEinspeiseZaehlerAktuell - nEinspeiseZaehlerAlt; var Einspeiseverguetung = Math.round ((nEinspeiseZaehlerNeu * Verguetung_kwh)*100)/100; var PvZaehlerNeu = PvZaehlerAktuell - PvZaehlerAlt; var EigenverbrauchNeu = PvZaehlerNeu - nEinspeiseZaehlerNeu; var AutarkieNeu = Math.round(EigenverbrauchNeu / ((nBezugZaehlerNeu+EigenverbrauchNeu)/100)); if(NettoGrundpreis > 0 ) var StromPreis = (NettoGrundpreis/(nBezugZaehlerNeu+EigenverbrauchNeu))+ NettoStromPreis; if(NettoGrundpreis == 0 ) var StromPreis = NettoStromPreis; var Entnahme = Math.round((EigenverbrauchNeu*StromPreis)*100)/100; var UstAnmeldung = Math.round((Entnahme/100*MWST)*100)/100; // Datum vom Vortag berechnen var jetzt = new Date(); var Theute = jetzt.getDate(); var Tgestern = new Date(); Tgestern.setDate(Theute-1); var DatumAkt=((Tgestern.getDate())+'.'+ (Tgestern.getMonth()+1) +'.'+ Tgestern.getFullYear()); var MonatAkt=(Tgestern.getMonth()+1); setTimeout(function(){ setState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NetzeinspeisungAlt',nEinspeiseZaehlerAktuell); setState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.NetzbezugAlt',nBezugZaehlerAktuell); setState('javascript.1.PVAnlage.Stromzaehler.Zaehlerstaende.SolarproduktionAlt',PvZaehlerAktuell); setTimeout(function(){ if(debug)log('Smartmeter Zählerstände FA Tabelle: Json aktualisiert ' + JSON.stringify(arr)); writelog(); },200); // für Json aufbereiten let obj = {}; obj.Datum = DatumAkt; obj.Einspeisung = nEinspeiseZaehlerNeu + ' kWh'; obj.Netzbezug = nBezugZaehlerNeu + ' kWh'; obj.Solarproduktion = PvZaehlerNeu + ' kWh'; obj.Eigenverbrauch = EigenverbrauchNeu + ' kWh'; obj.Autarkie = AutarkieNeu + ' %'; obj.Netzeinspeisezaehler = nEinspeiseZaehlerAktuell + ' kWh'; obj.Netzbezugszaehler = nBezugZaehlerAktuell + ' kWh'; obj.PVzaehler = PvZaehlerAktuell + ' kWh'; obj.Privatentnahme = Entnahme + ' €'; obj.Ust = UstAnmeldung + ' €'; obj.Mwst = MWST + ' %' obj.StrompreisGesamt = StromPreis + ' €/kWh'; obj.Strompreis = NettoStromPreis + ' €/kWh'; obj.Grundgebuehren = NettoGrundpreis + ' €/Monat' obj.Verguetung = Einspeiseverguetung + ' €'; let arr = []; if(existsState(idJson)) arr = JSON.parse(getState(idJson).val); arr.push(obj); if(arr.length > 12 && Begrenzung) arr.shift(); if(existsState(idJson)) setState(idJson, JSON.stringify(arr), true); else createState(idJson, JSON.stringify(arr), {type: 'string'}); },2000); }); // Funktion schreibt einen Logeintrag in das Filesystem function writelog() { var string = getState(idJson).val; if (logflag === true) { fs.readFile(LogPath, 'utf8', function(err,data){ if (!err) { fs.writeFileSync(LogPath, string ); }else{ if(logging)log("Smartmeter: Finanzamt Tabelle - Json nicht gefunden - wird angelegt"), "info"; fs.writeFileSync(LogPath, string ); } }); } ; }hier die widgets
-
Leider ist das Thema bei mir etwas eingeschlafen.
Hat jemand noch das aktuell funktionierende Script, ich kann das zuletzt laufende auf meinem Rechner leider nicht mehr finden.
@wendy2702
siehe ersten Beitrag von smartboart
Support us
752
Online32.5k
Benutzer81.6k
Themen1.3m
Beiträge