{ "annotations": { "list": [ { "$$hashKey": "object:137", "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "editable": true, "gnetId": null, "graphTooltip": 0, "id": 8, "links": [], "panels": [ { "cacheTimeout": null, "datasource": "Solaranzeige", "gridPos": { "h": 4, "w": 2, "x": 0, "y": 0 }, "id": 53, "links": [], "options": { "colorMode": "value", "fieldOptions": { "calcs": [ "last" ], "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "semi-dark-blue", "value": null } ] }, "unit": "watt" }, "overrides": [], "values": false }, "graphMode": "area", "justifyMode": "auto", "orientation": "auto" }, "pluginVersion": "6.7.2", "targets": [ { "groupBy": [], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT \"PVAC_Gesamtleistung\" FROM \"Netz\" WHERE $timeFilter", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_Gesamtleistung" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "PV-Leistung (AC)", "type": "stat" }, { "cacheTimeout": null, "datasource": "Solaranzeige", "description": "Anzeige der 3 Phasen einer per AC angeschlossenen PV-Anlage mit PV-Meter", "gridPos": { "h": 4, "w": 6, "x": 2, "y": 0 }, "id": 37, "links": [], "options": { "colorMode": "value", "fieldOptions": { "calcs": [ "last" ], "defaults": { "mappings": [ { "$$hashKey": "object:3320", "id": 0, "op": "=", "text": "N/A", "type": 1, "value": "null" } ], "nullValueMode": "connected", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "light-blue", "value": 80 } ] }, "title": " ", "unit": "watt" }, "overrides": [], "values": false }, "graphMode": "area", "justifyMode": "auto", "orientation": "auto" }, "pluginVersion": "6.7.2", "targets": [ { "groupBy": [], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"PVAC_Leistung_R\"), \"PVAC_Leistung_S\", \"PVAC_Leistung_T\" FROM \"Netz\" WHERE $timeFilter", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_Leistung_R" ], "type": "field" } ], [ { "params": [ "PVAC_Leistung_S" ], "type": "field" } ], [ { "params": [ "PVAC_Leistung_T" ], "type": "field" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "PV-Produktion (AC) Einzelphasen", "type": "stat" }, { "aliasColors": {}, "bars": true, "dashLength": 10, "dashes": false, "datasource": "Solaranzeige", "description": "Tagesertrag der per AC angeschlossenen PV-Anlage", "fill": 1, "fillGradient": 0, "gridPos": { "h": 4, "w": 6, "x": 8, "y": 0 }, "hiddenSeries": false, "id": 39, "legend": { "avg": false, "current": false, "max": false, "min": false, "show": false, "total": false, "values": false }, "lines": false, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "1d" ], "type": "time" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_PV-ErzeugungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "7d", "timeRegions": [], "timeShift": null, "title": "Summe PV-Erzeugung (AC)", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:456", "format": "watth", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "$$hashKey": "object:457", "format": "watth", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "cacheTimeout": null, "colorBackground": false, "colorValue": true, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": "Solaranzeige", "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 4, "w": 5, "x": 17, "y": 0 }, "id": 18, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "groupBy": [], "measurement": "Info", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Datum" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "thresholds": "", "title": "", "transparent": true, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "current" }, { "cacheTimeout": null, "circleBackground": false, "colorBackground": false, "colorValue": false, "datasource": "Solaranzeige", "decimals": null, "defaultColor": "rgb(117, 117, 117)", "description": "Anzeige Eigenverbrauch: PV-Erzeugung AC - Einspeisung/Bezug - Batterieleistung. ", "format": "watt", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 4, "w": 3, "x": 0, "y": 4 }, "hideTimeOverride": true, "id": 49, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:1442", "name": "value to text", "value": 1 }, { "$$hashKey": "object:1443", "name": "range to text", "value": 2 } ], "math": "PVAC_Leistung +Batteriestrom*Batteriespannung + Netzleistung", "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "pluginVersion": "6.7.2", "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sortOrder": "asc", "sortOrderOptions": [ { "text": "Ascending", "value": "asc" }, { "text": "Descending", "value": "desc" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": true }, "tableColumn": "", "targets": [ { "alias": "Batteriespannung", "groupBy": [], "hide": false, "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time(1m)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Spannung" ], "type": "field" } ] ], "tags": [] }, { "alias": "Batteriestrom", "groupBy": [], "hide": false, "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"Strom\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time(10s)", "rawQuery": false, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "Strom" ], "type": "field" } ] ], "tags": [] }, { "alias": "PVAC_Leistung", "groupBy": [], "hide": false, "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_Gesamtleistung" ], "type": "field" } ] ], "tags": [] }, { "alias": "Netzleistung", "groupBy": [], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "Gesamtleistung" ], "type": "field" } ] ], "tags": [] } ], "thresholds": [ { "$$hashKey": "object:609", "color": "#37872D" } ], "timeFrom": "1d", "timeShift": null, "title": "Eigenverbrauch SingleStatMath", "tooltip": { "show": true }, "type": "blackmirror1-singlestat-math-panel", "valueFontSize": "80%", "valueMappingColorBackground": "#767171", "valueMaps": [ { "$$hashKey": "object:1445", "op": "=", "text": "No data", "value": "null" } ], "valueName": "current" }, { "datasource": "Solaranzeige", "gridPos": { "h": 4, "w": 2, "x": 3, "y": 4 }, "id": 55, "options": { "colorMode": "value", "fieldOptions": { "calcs": [ "last" ], "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watt" }, "overrides": [], "values": false }, "graphMode": "area", "justifyMode": "auto", "orientation": "auto" }, "pluginVersion": "6.7.2", "targets": [ { "groupBy": [], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Gesamtleistung" ], "type": "field" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "Bezug/Einspeisung", "type": "stat" }, { "cacheTimeout": null, "datasource": "Solaranzeige", "gridPos": { "h": 4, "w": 3, "x": 5, "y": 4 }, "id": 58, "links": [], "options": { "colorMode": "value", "fieldOptions": { "calcs": [ "last" ], "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "unit": "watth" }, "overrides": [], "values": false }, "graphMode": "none", "justifyMode": "auto", "orientation": "auto" }, "pluginVersion": "6.7.2", "targets": [ { "alias": "Erzeugung", "groupBy": [ { "params": [ "1d" ], "type": "time" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT difference(last(\"PVAC_PV-ErzeugungGesamt\")) FROM \"Netz\" WHERE $timeFilter GROUP BY time(1d) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_PV-ErzeugungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "PV-Ertrag heute", "type": "stat" }, { "aliasColors": {}, "bars": true, "dashLength": 10, "dashes": false, "datasource": "Solaranzeige", "description": "Summe Überschuss-Einspeisung pro Tag", "fill": 1, "fillGradient": 0, "gridPos": { "h": 4, "w": 6, "x": 8, "y": 4 }, "hiddenSeries": false, "id": 56, "legend": { "avg": false, "current": false, "max": false, "min": false, "show": false, "total": false, "values": false }, "lines": false, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "1d" ], "type": "time" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "EinspeisungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "7d", "timeRegions": [], "timeShift": null, "title": "Summe Überschuss-Einspeisung", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:456", "format": "watth", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "$$hashKey": "object:457", "format": "watth", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Solaranzeige", "description": "Leistung einer über AC angeschlossenen PV-Anlage. Messung über PV-Meter (2. Messgerät am T10 für PV-Erzeungungsmessung)", "fill": 1, "fillGradient": 0, "gridPos": { "h": 5, "w": 8, "x": 0, "y": 8 }, "hiddenSeries": false, "id": 47, "legend": { "avg": false, "current": false, "max": false, "min": false, "show": false, "total": false, "values": false }, "lines": true, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_Gesamtleistung" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "PV-Leistung AC", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:272", "format": "watt", "label": null, "logBase": 1, "max": null, "min": "0", "show": true }, { "$$hashKey": "object:273", "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "cacheTimeout": null, "circleBackground": false, "colorBackground": false, "colorValue": false, "datasource": "Solaranzeige", "defaultColor": "rgb(117, 117, 117)", "format": "percentunit", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 5, "w": 3, "x": 8, "y": 8 }, "id": 25, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:7797", "name": "value to text", "value": 1 }, { "$$hashKey": "object:7798", "name": "range to text", "value": 2 } ], "math": "(Erzeugung-Ueberschuss)/Erzeugung", "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sortOrder": "asc", "sortOrderOptions": [ { "text": "Ascending", "value": "asc" }, { "text": "Descending", "value": "desc" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "alias": "Erzeugung", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"Strom\"), mean(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_PV-ErzeugungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] }, { "alias": "Ueberschuss", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "EinspeisungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": null, "timeShift": null, "title": "Eigenverbrauchsanteil", "tooltip": { "show": true }, "type": "blackmirror1-singlestat-math-panel", "valueFontSize": "80%", "valueMappingColorBackground": "#767171", "valueMaps": [ { "$$hashKey": "object:7800", "op": "=", "text": "No data", "value": "null" } ], "valueName": "current" }, { "cacheTimeout": null, "circleBackground": false, "colorBackground": false, "colorValue": false, "datasource": "Solaranzeige", "defaultColor": "rgb(117, 117, 117)", "format": "percentunit", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 5, "w": 3, "x": 11, "y": 8 }, "id": 57, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:7797", "name": "value to text", "value": 1 }, { "$$hashKey": "object:7798", "name": "range to text", "value": 2 } ], "math": "Ueberschuss/Erzeugung", "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sortOrder": "asc", "sortOrderOptions": [ { "text": "Ascending", "value": "asc" }, { "text": "Descending", "value": "desc" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "alias": "Erzeugung", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"Strom\"), mean(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_PV-ErzeugungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] }, { "alias": "Ueberschuss", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "EinspeisungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": null, "timeShift": null, "title": "Einspeiseanteil", "tooltip": { "show": true }, "type": "blackmirror1-singlestat-math-panel", "valueFontSize": "80%", "valueMappingColorBackground": "#767171", "valueMaps": [ { "$$hashKey": "object:7800", "op": "=", "text": "No data", "value": "null" } ], "valueName": "current" }, { "aliasColors": {}, "bars": false, "cacheTimeout": null, "dashLength": 10, "dashes": false, "datasource": "Solaranzeige", "description": "Gesamtlast:\nAnzeige : PV-Erzeugung AC - Einspeisung/Bezug. Der Wert beinhaltet die Energie für Speicherladung.", "fill": 1, "fillGradient": 0, "gridPos": { "h": 5, "w": 8, "x": 0, "y": 13 }, "hiddenSeries": false, "hideTimeOverride": true, "id": 50, "legend": { "avg": false, "current": false, "max": false, "min": false, "show": false, "total": false, "values": false }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pluginVersion": "6.7.2", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "10m" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"PVAC_Gesamtleistung\") + last(\"Gesamtleistung\") FROM \"Netz\" WHERE $timeFilter GROUP BY time(10m) fill(null)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_Gesamtleistung" ], "type": "field" }, { "params": [], "type": "last" } ], [ { "params": [ "Gesamtleistung" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "1d", "timeRegions": [], "timeShift": null, "title": "Last", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:2476", "format": "watt", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "$$hashKey": "object:2477", "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "cacheTimeout": null, "circleBackground": false, "colorBackground": false, "colorValue": false, "datasource": "Solaranzeige", "defaultColor": "rgb(117, 117, 117)", "description": "Gesamtenergieverbrauch PV-Produktion+Netzbezug", "format": "watth", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 4, "w": 3, "x": 8, "y": 13 }, "id": 60, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:7797", "name": "value to text", "value": 1 }, { "$$hashKey": "object:7798", "name": "range to text", "value": 2 } ], "math": "Erzeugung-Einspeisung+Bezug", "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sortOrder": "asc", "sortOrderOptions": [ { "text": "Ascending", "value": "asc" }, { "text": "Descending", "value": "desc" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "difference", "targets": [ { "alias": "Erzeugung", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"Strom\"), mean(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_PV-ErzeugungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] }, { "alias": "Einspeisung", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"Strom\"), mean(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "EinspeisungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] }, { "alias": "Bezug", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"Strom\"), mean(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "BezugGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": null, "timeShift": null, "title": "Energieverbrauch", "tooltip": { "show": true }, "type": "blackmirror1-singlestat-math-panel", "valueFontSize": "80%", "valueMappingColorBackground": "#767171", "valueMaps": [ { "$$hashKey": "object:7800", "op": "=", "text": "No data", "value": "null" } ], "valueName": "current" }, { "cacheTimeout": null, "datasource": "Solaranzeige", "description": "Heutiger Bezug aus dem Netz", "gridPos": { "h": 4, "w": 3, "x": 11, "y": 13 }, "id": 62, "links": [], "options": { "colorMode": "value", "fieldOptions": { "calcs": [ "last" ], "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "watth" }, "overrides": [], "values": false }, "graphMode": "area", "justifyMode": "auto", "orientation": "auto" }, "pluginVersion": "6.7.2", "targets": [ { "alias": "Erzeugung", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"Strom\"), mean(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "BezugGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "Bezug", "type": "stat" }, { "cacheTimeout": null, "datasource": "Solaranzeige", "description": "Heutige Einspeisung ins Stromnetz", "gridPos": { "h": 4, "w": 3, "x": 8, "y": 17 }, "id": 63, "links": [], "options": { "colorMode": "value", "fieldOptions": { "calcs": [ "last" ], "defaults": { "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null } ] }, "unit": "watth" }, "overrides": [], "values": false }, "graphMode": "none", "justifyMode": "auto", "orientation": "auto" }, "pluginVersion": "6.7.2", "targets": [ { "alias": "Erzeugung", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "hide": false, "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"Strom\"), mean(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "EinspeisungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "Einspeisung", "type": "stat" }, { "cacheTimeout": null, "circleBackground": false, "colorBackground": false, "colorValue": false, "datasource": "Solaranzeige", "defaultColor": "rgb(117, 117, 117)", "description": "", "format": "percentunit", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 4, "w": 3, "x": 11, "y": 17 }, "id": 61, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:7797", "name": "value to text", "value": 1 }, { "$$hashKey": "object:7798", "name": "range to text", "value": 2 } ], "math": "(Erzeugung-Einspeisung)/(Erzeugung-Einspeisung+Bezug)", "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sortOrder": "asc", "sortOrderOptions": [ { "text": "Ascending", "value": "asc" }, { "text": "Descending", "value": "desc" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "alias": "Erzeugung", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"Strom\"), mean(\"Spannung\") FROM \"Batterie\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "PVAC_PV-ErzeugungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] }, { "alias": "Ueberschuss", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "EinspeisungGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] }, { "alias": "Bezug", "groupBy": [ { "params": [ "1d" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "BezugGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "difference" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": null, "timeShift": null, "title": "Autarkiegrad", "tooltip": { "show": true }, "type": "blackmirror1-singlestat-math-panel", "valueFontSize": "80%", "valueMappingColorBackground": "#767171", "valueMaps": [ { "$$hashKey": "object:7800", "op": "=", "text": "No data", "value": "null" } ], "valueName": "current" }, { "columns": [], "datasource": "Solaranzeige", "description": "Zustand der Batterie:\nSpannung, Strom (Laden/Entladen)\nLadezustand (SOC)", "fontSize": "110%", "gridPos": { "h": 3, "w": 12, "x": 0, "y": 21 }, "id": 6, "links": [], "pageSize": 1, "scroll": false, "showHeader": true, "sort": { "col": 0, "desc": true }, "styles": [ { "$$hashKey": "object:328", "alias": "Time", "align": "auto", "dateFormat": "YYYY-MM-DD HH:mm:ss", "pattern": "Time", "type": "hidden" }, { "$$hashKey": "object:329", "alias": "Spannung", "align": "auto", "colorMode": "row", "colors": [ "#1f78c1", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 1, "mappingType": 1, "pattern": "Spannung", "thresholds": [], "type": "number", "unit": "volt" }, { "$$hashKey": "object:330", "alias": "Strom", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "Ladestrom", "thresholds": [], "type": "number", "unit": "amp" }, { "$$hashKey": "object:331", "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 1, "mappingType": 1, "pattern": "Kapazität", "thresholds": [], "type": "number", "unit": "percent" } ], "targets": [ { "alias": "Spannung", "groupBy": [], "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Spannung" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] }, { "alias": "Ladestrom", "groupBy": [], "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "Strom" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] }, { "alias": "Ladezustand", "groupBy": [], "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "refId": "D", "resultFormat": "time_series", "select": [ [ { "params": [ "SOC" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "title": "Batteriewerte", "transform": "timeseries_to_columns", "transparent": true, "type": "table" }, { "cacheTimeout": null, "datasource": "Solaranzeige", "description": "Anzeige des momentanen Energieflusses am Akku.\nGrün = Akku wird geladen\nRot = Akku wird entladen\nAnzeige der Lade-/Entladeenergie", "gridPos": { "h": 4, "w": 3, "x": 0, "y": 24 }, "id": 34, "links": [], "options": { "fieldOptions": { "calcs": [ "last" ], "defaults": { "decimals": 0, "links": [], "mappings": [], "max": 5000, "min": -5000, "nullValueMode": "connected", "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "light-red", "value": -3000 }, { "color": "light-red", "value": -1 }, { "color": "dark-yellow", "value": 1 }, { "color": "dark-green", "value": 3000 } ] }, "title": "", "unit": "watt" }, "overrides": [], "values": false }, "orientation": "horizontal", "showThresholdLabels": false, "showThresholdMarkers": false }, "pluginVersion": "6.7.2", "targets": [ { "groupBy": [], "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "query": "SELECT \"Strom\" * \"Spannung\" * (-1) FROM \"Batterie\" WHERE $timeFilter ", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Strom" ], "type": "field" } ], [ { "params": [ "Spannung" ], "type": "field" }, { "params": [ " / 100" ], "type": "math" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "Akku Ladung/Entladung aktuell", "transparent": true, "type": "gauge" }, { "datasource": "Solaranzeige", "gridPos": { "h": 4, "w": 3, "x": 3, "y": 24 }, "id": 35, "options": { "fieldOptions": { "calcs": [ "last" ], "defaults": { "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "#EAB839", "value": 20 }, { "color": "super-light-green", "value": 40 }, { "color": "dark-green", "value": 60 } ] }, "unit": "percent" }, "overrides": [], "values": false }, "orientation": "auto", "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "6.7.2", "targets": [ { "groupBy": [], "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "SOC" ], "type": "field" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "Batterieladung", "type": "gauge" }, { "cacheTimeout": null, "datasource": "Solaranzeige", "description": "Anzeige des momentanen Energieflusses am Akku.\nGrün = Akku wird geladen\nRot = Akku wird entladen\nAnzeige der Lade-/Entladeenergie", "gridPos": { "h": 4, "w": 3, "x": 6, "y": 24 }, "id": 31, "links": [], "options": { "colorMode": "value", "fieldOptions": { "calcs": [ "last" ], "defaults": { "mappings": [ { "$$hashKey": "object:489", "from": "-9999999", "id": 0, "op": "=", "text": "Akku wird geladen", "to": "-1", "type": 2, "value": "null" }, { "from": "-1", "id": 1, "operator": "", "text": "Standby", "to": "0", "type": 2, "value": "" }, { "from": "0", "id": 2, "operator": "", "text": "Akku wird entladen", "to": "999999", "type": 2, "value": "0" } ], "nullValueMode": "connected", "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "green", "value": -1 }, { "color": "dark-red", "value": 1 } ] }, "title": "", "unit": "watt" }, "overrides": [], "values": false }, "graphMode": "area", "justifyMode": "auto", "orientation": "horizontal" }, "pluginVersion": "6.7.2", "targets": [ { "groupBy": [], "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "query": "SELECT \"Strom\" * \"Spannung\" FROM \"Batterie\" WHERE $timeFilter", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Strom" ], "type": "field" } ], [ { "params": [ "Spannung" ], "type": "field" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "title": "Akku Ladung/Entladung aktuell", "type": "stat" }, { "cacheTimeout": null, "datasource": "Solaranzeige", "description": "Anzeige des momentanen Energieflusses am Akku.\nGrün = Akku wird geladen\nRot = Akku wird entladen\nAnzeige der Lade-/Entladeenergie\nNegative Leistung = Energie fließt vom Netz in den Akku\nPositive Leistung = Energie fließt vom Akku ins Netz", "gridPos": { "h": 4, "w": 3, "x": 9, "y": 24 }, "hideTimeOverride": true, "id": 33, "interval": "", "links": [], "options": { "colorMode": "value", "fieldOptions": { "calcs": [ "last" ], "defaults": { "decimals": 3, "links": [], "mappings": [], "nullValueMode": "connected", "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-green", "value": -1 }, { "color": "dark-red", "value": 0 } ] }, "title": "", "unit": "watt" }, "overrides": [], "values": false }, "graphMode": "area", "justifyMode": "auto", "orientation": "vertical" }, "pluginVersion": "6.7.2", "targets": [ { "groupBy": [ { "params": [ "1m" ], "type": "time" } ], "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"Strom\")* \"Spannung\" FROM \"Batterie\" WHERE $timeFilter", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "Strom" ], "type": "field" }, { "params": [], "type": "last" } ], [ { "params": [ "Spannung" ], "type": "field" } ] ], "tags": [] } ], "timeFrom": "12h", "timeShift": null, "title": "Akku Ladung/Entladung aktuell", "type": "stat" }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Solaranzeige", "description": "Aktueller Ladezustand der Batterie (SOC) über die letzten 24 Stunden", "fill": 1, "fillGradient": 0, "gridPos": { "h": 5, "w": 6, "x": 0, "y": 28 }, "hiddenSeries": false, "id": 45, "interval": "", "legend": { "avg": false, "current": false, "max": false, "min": false, "show": true, "total": false, "values": false }, "lines": true, "linewidth": 1, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "10m" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "Batterie", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "SOC" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "24h", "timeRegions": [], "timeShift": null, "title": "Batterie Ladezustand (SOC)", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:258", "format": "percent", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "$$hashKey": "object:259", "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": { "Statistik.mean": "#e5ac0e" }, "bars": true, "dashLength": 10, "dashes": false, "datasource": "Solaranzeige", "fill": 1, "fillGradient": 0, "gridPos": { "h": 5, "w": 6, "x": 6, "y": 28 }, "hiddenSeries": false, "id": 14, "interval": "", "legend": { "avg": false, "current": false, "max": false, "min": false, "show": false, "total": false, "values": false }, "lines": false, "linewidth": 1, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [ { "$$hashKey": "object:1916", "alias": "Statistik.last", "color": "#e5ac0e" } ], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "groupBy": [ { "params": [ "1d" ], "type": "time" } ], "measurement": "Netz", "orderByTime": "ASC", "policy": "default", "query": "SELECT non_negative_difference(last(\"Wh_NetzeinspeisungGesamt\")) , non_negative_difference(last(\"Wh_NetzbezugGesamt\")) FROM \"Summen\" WHERE $timeFilter GROUP BY time(1d)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "BezugGesamt" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [], "type": "non_negative_difference" } ] ], "tags": [] } ], "thresholds": [], "timeFrom": "4w", "timeRegions": [], "timeShift": null, "title": "Netzbezug (pro Tag)", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:1929", "format": "watth", "label": "pro Tag", "logBase": 1, "max": null, "min": "0", "show": true }, { "$$hashKey": "object:1930", "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }, { "content": "
\n\n