ioBroker Neuigkeiten – Frühjahr 2025 🌼
30 Mar 2025, 12:22
Informationen zum Spamschutz im Forum
2 Feb 2025, 15:26
Beta-Start ioBroker-Matter Adapter
26 Jan 2025, 17:09@sammydk sagte in [Tutorial] SolarEdge -> Modbus -> ioBroker -> Grafana:
@chris87
Hallo,
ist es dir möglich von deinem Solardashboard einen Export *.json zu machen, so wie Hennerich das im Tutorial am Anfang erstellt hat?
Bin überwältigt von deinem Dashboard und da meine Solaredge noch unterwegs ist bin ich natürlich schon mal am probieren und soweit es mir möglich ist am vorbereiten.G Dietmar
Du meinst aus dem Grafana?
Hier ist meins noch mal:
{
"__inputs": [
{
"name": "DS_INFLUXDB",
"label": "InfluxDB",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
}
],
"__requires": [
{
"type": "panel",
"id": "gauge",
"name": "Gauge",
"version": ""
},
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "8.0.3"
},
{
"type": "panel",
"id": "grafana-clock-panel",
"name": "Clock",
"version": "1.1.3"
},
{
"type": "datasource",
"id": "influxdb",
"name": "InfluxDB",
"version": "1.0.0"
},
{
"type": "panel",
"id": "stat",
"name": "Stat",
"version": ""
},
{
"type": "panel",
"id": "timeseries",
"name": "Time series",
"version": ""
}
],
"annotations": {
"list": [
{
"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": null,
"links": [],
"panels": [
{
"datasource": "${DS_INFLUXDB}",
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "opacity",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": true,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"decimals": 0,
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "celsius"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Temp."
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#FF7383",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Feuchte"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#3274D9",
"mode": "fixed"
}
},
{
"id": "unit",
"value": "humidity"
}
]
}
]
},
"gridPos": {
"h": 7,
"w": 6,
"x": 0,
"y": 0
},
"hideTimeOverride": true,
"id": 46,
"options": {
"legend": {
"calcs": [
"lastNotNull"
],
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single"
}
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "Temperatur",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "modbus.0.holdingRegisters.5_TempAussen",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": "24h",
"timeShift": null,
"title": "Außentemperatur",
"type": "timeseries"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"displayName": "",
"mappings": [],
"max": 12000,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "semi-dark-green",
"value": null
}
]
},
"unit": "watt"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 5,
"x": 6,
"y": 0
},
"id": 14,
"interval": "5s",
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": false,
"text": {}
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "javascript.0.Solar.Wechselrichter.PVLeistungAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "PV Leistung",
"type": "gauge"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 35,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": true,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"decimals": 1,
"links": [],
"mappings": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "watt"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Sonnenstand"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#96D98D",
"mode": "fixed"
}
},
{
"id": "unit",
"value": "short"
},
{
"id": "min",
"value": 1
},
{
"id": "custom.axisPlacement",
"value": "hidden"
},
{
"id": "custom.lineStyle",
"value": {
"dash": [
10,
10
],
"fill": "dash"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "PV Leistung"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#FADE2A",
"mode": "fixed"
}
},
{
"id": "custom.fillOpacity",
"value": 10
},
{
"id": "custom.fillBelowTo",
"value": "Hausverbrauch"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Hausverbrauch"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#8AB8FF",
"mode": "fixed"
}
},
{
"id": "custom.fillBelowTo",
"value": "PV Leistung"
},
{
"id": "custom.lineWidth",
"value": 0
},
{
"id": "custom.lineWidth",
"value": 1
}
]
},
{
"matcher": {
"id": "byName",
"options": "TempWR"
},
"properties": [
{
"id": "unit",
"value": "short"
},
{
"id": "min",
"value": 1
},
{
"id": "custom.axisPlacement",
"value": "hidden"
}
]
}
]
},
"gridPos": {
"h": 9,
"w": 12,
"x": 11,
"y": 0
},
"id": 22,
"interval": "4m",
"options": {
"legend": {
"calcs": [
"lastNotNull"
],
"displayMode": "hidden",
"placement": "bottom"
},
"tooltip": {
"mode": "single"
}
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "PV Leistung",
"groupBy": [
{
"params": [
"2m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVLeistungAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Hausverbrauch",
"groupBy": [
{
"params": [
"2m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.Hausverbrauch",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Sonnenstand",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Sonnenstand.Elevation",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "TempWR",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "javascript.0.Solar.Wechselrichter.TempWechselrichter",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "PV",
"type": "timeseries"
},
{
"datasource": "${DS_INFLUXDB}",
"description": "",
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"0": {
"text": "standby"
},
"1": {
"text": "läuft"
}
},
"type": "value"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "blue",
"value": null
},
{
"color": "green",
"value": 1
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 6,
"x": 0,
"y": 7
},
"id": 42,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "center",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": true
},
"text": {},
"textMode": "value"
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "",
"groupBy": [],
"measurement": "0_userdata.0.Test",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Ölbrenner",
"transformations": [],
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"1": {
"text": "AUS"
},
"2": {
"text": "Nachtmodus"
},
"3": {
"text": "Starten"
},
"4": {
"text": "Produktion"
},
"5": {
"text": "Begrenzte Produktion"
},
"6": {
"text": "Herunterfahren"
},
"7": {
"text": "Fehler"
},
"8": {
"text": "Wartung"
}
},
"type": "value"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "blue",
"value": 2
},
{
"color": "semi-dark-green",
"value": 4
},
{
"color": "semi-dark-red",
"value": 7
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 5,
"x": 6,
"y": 7
},
"id": 9,
"interval": "1m",
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "modbus.1.holdingRegisters.40107_I_Status",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Wechselrichter",
"type": "stat"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 1,
"displayName": "",
"mappings": [],
"max": 60,
"min": 20,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 30
},
{
"color": "yellow",
"value": 35
},
{
"color": "green",
"value": 40
}
]
},
"unit": "celsius"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 3,
"x": 0,
"y": 9
},
"id": 5,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"text": {}
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "",
"groupBy": [],
"measurement": "modbus.0.holdingRegisters.7_TempHeizVL",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "VL-Temperatur",
"type": "gauge"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 1,
"displayName": "",
"mappings": [],
"max": 60,
"min": 20,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 38
},
{
"color": "yellow",
"value": 43
},
{
"color": "green",
"value": 47
}
]
},
"unit": "celsius"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 3,
"x": 3,
"y": 9
},
"id": 4,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"text": {}
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "modbus.0.holdingRegisters.12_TempBoilerO",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "WW-Temperatur",
"type": "gauge"
},
{
"datasource": null,
"description": "",
"gridPos": {
"h": 6,
"w": 5,
"x": 6,
"y": 9
},
"id": 48,
"options": {
"bgColor": "#181b1f",
"clockType": "24 hour",
"countdownSettings": {
"endCountdownTime": "2020-11-09T22:57:52+01:00",
"endText": "00:00:00"
},
"dateSettings": {
"dateFormat": "DD.MM.YYYY",
"fontSize": "40px",
"fontWeight": "normal",
"locale": "",
"showDate": true
},
"mode": "time",
"timeSettings": {
"fontSize": "60px",
"fontWeight": "bold"
},
"timezone": "",
"timezoneSettings": {
"fontSize": "12px",
"fontWeight": "normal",
"showTimezone": false,
"zoneFormat": "offsetAbbv"
}
},
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"transparent": true,
"type": "grafana-clock-panel"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "#F2495C",
"value": null
},
{
"color": "#73BF69",
"value": 0
},
{
"color": "#73BF69"
}
]
},
"unit": "watt"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 11,
"y": 9
},
"id": 18,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "javascript.0.Solar.Wechselrichter.ACTotalRealPower",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Import/Export",
"type": "stat"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "bars",
"fillOpacity": 35,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": true,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "none"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 8,
"x": 15,
"y": 9
},
"hideTimeOverride": false,
"id": 23,
"interval": "",
"options": {
"legend": {
"calcs": [
"min"
],
"displayMode": "hidden",
"placement": "bottom"
},
"tooltip": {
"mode": "single"
}
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "Erzeugt",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVErzeugteEnergieAktuell",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"value\") / 1000 FROM \"javascript.0.Solar.Wechselrichter.PVErzeugteEnergieTag\" WHERE $timeFilter",
"rawQuery": false,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": "3w",
"timeShift": null,
"title": "PV Erzeugung in kWh",
"type": "timeseries"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
}
]
},
"unit": "watt"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 11,
"y": 12
},
"id": 20,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "javascript.0.Solar.Wechselrichter.Hausverbrauch",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Hausverbrauch",
"type": "stat"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "Liter"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 6,
"x": 0,
"y": 15
},
"id": 52,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "center",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "javascript.0.Verbrauchszaehler.HeizölVerbrauchTotal",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Heizölverbrauch 2022",
"type": "stat"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 5,
"x": 6,
"y": 15
},
"id": 54,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "sourceanalytix.0.javascript__0__Verbrauchszaehler__StromVerbrauchTotal.cumulativeReading",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Stromverbrauch 2022",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 11,
"y": 15
},
"id": 34,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVEigenverbrauchAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Eigenverbrauch heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 15,
"y": 15
},
"id": 31,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVImportierteEnergieAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Netzbezug heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"description": "",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "€"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 19,
"y": 15
},
"id": 44,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Verbrauchszaehler.ErsparnisPVAnlageTag",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Ersparnis heute",
"type": "stat"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "€"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 6,
"x": 0,
"y": 18
},
"id": 50,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "center",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "",
"groupBy": [],
"measurement": "javascript.0.Verbrauchszaehler.HeizölKostenTotal",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Heizkosten 2022",
"type": "stat"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "€"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 5,
"x": 6,
"y": 18
},
"id": 56,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "sourceanalytix.0.javascript__0__Verbrauchszaehler__StromVerbrauchTotal.currentYear.costs.05_currentYear",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Stromkosten 2022",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 11,
"y": 18
},
"id": 27,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVErzeugteEnergieAktuell",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"value\") FROM \"javascript.0.Solar.Wechselrichter.PVErzeugteEnergieAktuell\" WHERE (\"value\" != '396.0906') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "PV Erzeugung heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 15,
"y": 18
},
"id": 29,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "center",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVExportierteEnergieAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Einspeisung heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "€"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 19,
"y": 18
},
"id": 43,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Verbrauchszaehler.ErsparnisPVAnlageTotal",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Ersparnis Total",
"type": "stat"
}
],
"refresh": "10s",
"schemaVersion": 30,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now/d",
"to": "now/d"
},
"timepicker": {
"refresh_intervals": [
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
]
},
"timezone": "",
"title": "PV Anlage",
"uid": "SrydEpzRk",
"version": 79
}
Daneben hatte ich mir noch eines für die Handyansicht gebaut. Falls das wen interessiert:
{
"__inputs": [
{
"name": "DS_INFLUXDB",
"label": "InfluxDB",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
}
],
"__requires": [
{
"type": "panel",
"id": "gauge",
"name": "Gauge",
"version": ""
},
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "8.0.3"
},
{
"type": "panel",
"id": "grafana-clock-panel",
"name": "Clock",
"version": "1.1.3"
},
{
"type": "panel",
"id": "graph",
"name": "Graph (old)",
"version": ""
},
{
"type": "datasource",
"id": "influxdb",
"name": "InfluxDB",
"version": "1.0.0"
},
{
"type": "panel",
"id": "stat",
"name": "Stat",
"version": ""
},
{
"type": "panel",
"id": "timeseries",
"name": "Time series",
"version": ""
}
],
"annotations": {
"list": [
{
"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": null,
"links": [],
"panels": [
{
"datasource": null,
"description": "",
"gridPos": {
"h": 3,
"w": 8,
"x": 0,
"y": 0
},
"id": 48,
"options": {
"bgColor": "#181b1f",
"clockType": "24 hour",
"countdownSettings": {
"endCountdownTime": "2020-11-09T22:57:52+01:00",
"endText": "00:00:00"
},
"dateSettings": {
"dateFormat": "DD.MM.YYYY",
"fontSize": "28px",
"fontWeight": "normal",
"locale": "",
"showDate": true
},
"mode": "time",
"timeSettings": {
"fontSize": "40px",
"fontWeight": "bold"
},
"timezone": "",
"timezoneSettings": {
"fontSize": "12px",
"fontWeight": "normal",
"showTimezone": false,
"zoneFormat": "offsetAbbv"
}
},
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"transparent": true,
"type": "grafana-clock-panel"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "opacity",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineStyle": {
"fill": "solid"
},
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": true,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"decimals": 0,
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "celsius"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Temp."
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#FF7383",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Feuchte"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#3274D9",
"mode": "fixed"
}
},
{
"id": "unit",
"value": "humidity"
}
]
}
]
},
"gridPos": {
"h": 7,
"w": 8,
"x": 0,
"y": 3
},
"hideTimeOverride": true,
"id": 46,
"options": {
"legend": {
"calcs": [
"lastNotNull"
],
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single"
}
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "Temperatur",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "modbus.0.holdingRegisters.5_TempAussen",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": "24h",
"timeShift": null,
"type": "timeseries"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 35,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": true,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"decimals": 1,
"links": [],
"mappings": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "watt"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Sonnenstand"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#96D98D",
"mode": "fixed"
}
},
{
"id": "unit",
"value": "short"
},
{
"id": "min",
"value": 1
},
{
"id": "custom.axisPlacement",
"value": "hidden"
},
{
"id": "custom.lineStyle",
"value": {
"dash": [
10,
10
],
"fill": "dash"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "PV Leistung"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#FADE2A",
"mode": "fixed"
}
},
{
"id": "custom.fillOpacity",
"value": 10
},
{
"id": "custom.fillBelowTo",
"value": "Hausverbrauch"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Hausverbrauch"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#8AB8FF",
"mode": "fixed"
}
},
{
"id": "custom.fillBelowTo",
"value": "PV Leistung"
},
{
"id": "custom.lineWidth",
"value": 0
},
{
"id": "custom.lineWidth",
"value": 1
}
]
},
{
"matcher": {
"id": "byName",
"options": "TempWR"
},
"properties": [
{
"id": "unit",
"value": "short"
},
{
"id": "min",
"value": 1
},
{
"id": "custom.axisPlacement",
"value": "hidden"
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 8,
"x": 0,
"y": 10
},
"id": 22,
"interval": "4m",
"options": {
"legend": {
"calcs": [
"lastNotNull"
],
"displayMode": "hidden",
"placement": "bottom"
},
"tooltip": {
"mode": "none"
}
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "PV Leistung",
"groupBy": [
{
"params": [
"2m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVLeistungAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Hausverbrauch",
"groupBy": [
{
"params": [
"2m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.Hausverbrauch",
"orderByTime": "ASC",
"policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Sonnenstand",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Sonnenstand.Elevation",
"orderByTime": "ASC",
"policy": "default",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "TempWR",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "javascript.0.Solar.Wechselrichter.TempWechselrichter",
"orderByTime": "ASC",
"policy": "default",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "PV",
"type": "timeseries"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"displayName": "",
"mappings": [],
"max": 12000,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "semi-dark-green",
"value": null
}
]
},
"unit": "watt"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 0,
"y": 18
},
"id": 14,
"interval": "5s",
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": false,
"text": {}
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "javascript.0.Solar.Wechselrichter.PVLeistungAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "PV Leistung",
"type": "gauge"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
}
]
},
"unit": "watt"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 4,
"y": 18
},
"id": 20,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "javascript.0.Solar.Wechselrichter.Hausverbrauch",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Hausverbrauch",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "#F2495C",
"value": null
},
{
"color": "#73BF69",
"value": 0
},
{
"color": "#73BF69"
}
]
},
"unit": "watt"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 4,
"y": 21
},
"id": 18,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "javascript.0.Solar.Wechselrichter.ACTotalRealPower",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Import/Export",
"type": "stat"
},
{
"aliasColors": {},
"bars": true,
"dashLength": 10,
"dashes": false,
"datasource": "${DS_INFLUXDB}",
"decimals": null,
"fieldConfig": {
"defaults": {
"links": []
},
"overrides": []
},
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 8,
"x": 0,
"y": 24
},
"hiddenSeries": false,
"hideTimeOverride": false,
"id": 23,
"interval": "",
"legend": {
"alignAsTable": true,
"avg": false,
"current": false,
"hideEmpty": false,
"hideZero": false,
"max": false,
"min": true,
"rightSide": false,
"show": false,
"total": false,
"values": true
},
"lines": false,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.0.3",
"pointradius": 0.5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Erzeugt",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVErzeugteEnergieAktuell",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"value\") / 1000 FROM \"javascript.0.Solar.Wechselrichter.PVErzeugteEnergieTag\" WHERE $timeFilter",
"rawQuery": false,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": "3w",
"timeRegions": [
{
"$$hashKey": "object:148",
"colorMode": "background6",
"fill": true,
"fillColor": "rgba(234, 112, 112, 0.12)",
"line": false,
"lineColor": "rgba(237, 46, 24, 0.60)",
"op": "time"
}
],
"timeShift": null,
"title": "PV Erzeugung in kWh",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:84",
"decimals": null,
"format": "none",
"label": "",
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"$$hashKey": "object:85",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": "1",
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 0,
"y": 30
},
"id": 27,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVErzeugteEnergieAktuell",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT last(\"value\") FROM \"javascript.0.Solar.Wechselrichter.PVErzeugteEnergieAktuell\" WHERE (\"value\" != '396.0906') AND $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "PV Erzeugung heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 4,
"y": 30
},
"id": 34,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVEigenverbrauchAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Eigenverbrauch heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 0,
"y": 33
},
"id": 29,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "center",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVExportierteEnergieAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Einspeisung heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 4,
"y": 33
},
"id": 31,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Solar.Wechselrichter.PVImportierteEnergieAktuell",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Netzbezug heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"description": "",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "€"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 0,
"y": 36
},
"id": 44,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Verbrauchszaehler.ErsparnisPVAnlageTag",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Ersparnis heute",
"type": "stat"
},
{
"cacheTimeout": null,
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"decimals": 2,
"mappings": [
{
"options": {
"match": "null",
"result": {
"text": "N/A"
}
},
"type": "special"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "€"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 4,
"y": 36
},
"id": 43,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"colorMode": "value",
"fieldOptions": {
"calcs": [
"lastNotNull"
]
},
"graphMode": "none",
"justifyMode": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "javascript.0.Verbrauchszaehler.ErsparnisPVAnlageTotal",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Ersparnis Total",
"type": "stat"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "€"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 0,
"y": 39
},
"id": 56,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "sourceanalytix.0.javascript__0__Verbrauchszaehler__StromVerbrauchTotal.currentYear.costs.05_currentYear",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Stromkosten 2021",
"type": "stat"
},
{
"datasource": null,
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "kwatth"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 4,
"y": 39
},
"id": 54,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "sourceanalytix.0.javascript__0__Verbrauchszaehler__StromVerbrauchTotal.cumulativeReading",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Stromverbrauch 2021",
"type": "stat"
},
{
"datasource": "${DS_INFLUXDB}",
"description": "",
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"0": {
"text": "standby"
},
"1": {
"text": "läuft"
}
},
"type": "value"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "blue",
"value": null
},
{
"color": "green",
"value": 1
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 8,
"x": 0,
"y": 42
},
"id": 42,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "center",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": true
},
"text": {},
"textMode": "value"
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "",
"groupBy": [],
"measurement": "0_userdata.0.Test",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "table",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Ölbrenner",
"transformations": [],
"type": "stat"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 1,
"displayName": "",
"mappings": [],
"max": 60,
"min": 20,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 30
},
{
"color": "yellow",
"value": 35
},
{
"color": "green",
"value": 40
}
]
},
"unit": "celsius"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 0,
"y": 44
},
"id": 5,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"text": {}
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "",
"groupBy": [],
"measurement": "modbus.0.holdingRegisters.7_TempHeizVL",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "VL-Temperatur",
"type": "gauge"
},
{
"datasource": "${DS_INFLUXDB}",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"decimals": 1,
"displayName": "",
"mappings": [],
"max": 60,
"min": 20,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "red",
"value": 38
},
{
"color": "yellow",
"value": 43
},
{
"color": "green",
"value": 47
}
]
},
"unit": "celsius"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 4,
"y": 44
},
"id": 4,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true,
"text": {}
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "modbus.0.holdingRegisters.12_TempBoilerO",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "last"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "WW-Temperatur",
"type": "gauge"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "€"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 0,
"y": 50
},
"id": 50,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "center",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"alias": "",
"groupBy": [],
"measurement": "javascript.0.Verbrauchszaehler.HeizölKostenTotal",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Heizkosten 2021",
"type": "stat"
},
{
"datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "rgb(200, 200, 200)",
"value": null
}
]
},
"unit": "Liter"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 4,
"x": 4,
"y": 50
},
"id": 52,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "center",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.0.3",
"targets": [
{
"groupBy": [],
"measurement": "javascript.0.Verbrauchszaehler.HeizölVerbrauchTotal",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Heizöl 2021",
"type": "stat"
}
],
"refresh": "",
"schemaVersion": 30,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now/d",
"to": "now/d"
},
"timepicker": {
"refresh_intervals": [
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
]
},
"timezone": "",
"title": "PV mobile View",
"uid": "qDQoA0Zgk",
"version": 15
}
@hennerich
besten Dank dir noch mal für die schnelle Unterstützung.
Das json von Grafana, damit meinte ich @chris87, aber auch deine Arbeit ist sehr gelungen, vor allem die Idee mit der Handyseite, schau ich mir auch schon mal an.
@hennerich
der Tip mit dem Speicher ist echt wertvoll, Ich bekomme einen LG ~10 kW, gut das Du das noch mal angesprochen hast.
Mit den beiden false false Werten lag ich ja dann doch richtig bei meiner Analyse.
Auch hierzu noch mal besten Dank
@cybtrash Hi cybtrash, ich habe das gleiche Verhalten wie bei dir. Hast du schon eine Lösung dafür gefunden?
Ich habe soeben beim Solardge Support via WhatsApp eine Aktualisierung beider Wechselrichter anstoßen lassen.
Aktuelle Versionen bei mir sind:
DSP1 1.0.1159 (Update auf 1.0.1428)
DSP2 2.0.1012 (Update auf 2.0.1206)
@cybtrash Meine Wechselrichter und Batterie wurden jetzt erfolgreich aktualisiert, jedoch ohne Erfolg.
Wechselrichter:
DSP1 = 1.0.1428
DSP2 = 2.0.1206
Kommunikationskarte (CPU) Version = 3.2724.0
Ich weiß nicht, was man noch machen kann...
Ich könnte versuchen es als Bug bei SolarEdge anzugeben.
@sammydk
Sorry, hab länger nicht mehr nachgeschaut hier.
Welches Dashboard meinst du genau?
Hab inzwischen mehrere.
MfG Chris
@chris87
Hallo Chris, leider kenne ich deine aktuellen Dashboards nicht, Habe nur ein hier im Forum von Dir gesehen und das war schon mal sehr schön, von den Inhalten und auch von der Gestalltung.
Ich benötige den/die Export einfach nur um zu lernen wie die Umsetzung erfolgt ist.
Wenn Du magst, kannst Du mir die ja auch als Export per PN zukommen lassen.
Hallo zusammen,
ich bin neu hier und versuche meinen SolarEdge Wechselrichter auszulesen. Per Modbus. Das funktioniert auch grundsätzlich aber ich komme nicht an die von euch beschriebenen "M_xxxxx" Werte. Beispiel : "M_AC_Power", "M_Exported"
Alles was mir geliefert wird seht ihr unten in der Liste. (Daten zur Produktion aber nicht zum Bezug)
Habt ihr eine Idee wie ich auch an die M-Wertekomme?
Grundsätzlich ist der Wechselrichter auf bei der RS485-1 Schrittstelle auf "Modubus (Mulit-Gerät) eingestellt und der Zähler auf "Einspeisung und Bezug (E+I)
ich wäre euch sehr dankbar wenn ihr mir helfen könnte über den Modbus auch den Bezug auszulesen damit ich diesen gegen die Produktion rechnen kann.
NM_Module: "se_inverter"
C_SunSpec_ID: "xxxxx"
C_SunSpec_DID: "103"
C_SunSpec_Length: "50"
C_Manufacturer: "SolarEdge "
C_Model: "SE10K-RWS48BEN4"
C_Version: xxxx"
C_SerialNumber: "xxxxx"
C_DeviceAddress: "1"
I_AC_Current: "0"
I_AC_CurrentA: "0"
I_AC_CurrentB: "0"
I_AC_CurrentC: "0"
I_AC_Current_SF: "-2"
I_AC_VoltageAB: "4094"
I_AC_VoltageBC: "4095"
I_AC_VoltageCA: "4080"
I_AC_VoltageAN: "2361"
I_AC_VoltageBN: "2363"
I_AC_VoltageCN: "2360"
I_AC_Voltage_SF: "-1"
I_AC_Power: "0"
I_AC_Power_SF: "0"
I_AC_Frequency: "5001"
I_AC_Frequency_SF: "-2"
I_AC_VA: "0"
I_AC_VA_SF: "0"
I_AC_VAR: "0"
I_AC_VAR_SF: "0"
I_AC_PF: "0"
I_AC_PF_SF: "0"
I_AC_Energy_WH: "7306819"
I_AC_Energy_WH_SF: "0"
I_DC_Current: "0"
I_DC_Current_SF: "0"
I_DC_Voltage: "0"
I_DC_Voltage_SF: "-1"
I_DC_Power: "0"
I_DC_Power_SF: "0"
I_Temp_Sink: "0"
I_Temp_SF: "-2"
I_Status: "2"
I_Status_Vendor: "0"
I_Event_1: "4294967295"
I_Event_2: "4294967295"
I_Event_1_Vendor: undefined
I_Event_2_Vendor: "4294967295"
I_Event_3_Vendor: "4294967295"
I_Event_4_Vendor: "0"
Wichtig! Trotz der Tatsache, dass bei mir der Energiezähler erfolgreich installiert wurde und mir mein Solarteur mitgeteilt hat, dass alles korrekt funktioniert war bei mir Modbus TCP nicht aktiviert. Darauf müsst ihr achten, sonst klappt keine Verbindung.
@hennerich Starke Arbeit erstmal! Das hat mir richtig geholfen! Ich hatte ein ähnliches Problem was den Modbus-Zugang angeht.
MOD-EDIT: Text entschärft
Bitte keine Angaben hier im Forum ...
wie man mit einem Umweg an die Einstellung kommt !
( Das kann Böse enden , bei falschen Einstellungen die man noch wo anderes machen könnte )
Bitte Editieren / löschen !
@glasfaser sagte in [Tutorial] SolarEdge -> Modbus -> ioBroker -> Grafana:
Bitte keine Angaben hier im Forum ...
Hallo und vielen Dank erst mal für die tolle Dokumentation an die Autoren, dass hat mir sehr weiter geholfen. Ich habe 2 WR von SE. Einen "Slave" und einen "Master". Also einen 3 Phasen WR (SE7K) und einen SE10K RWS (Hybrid). An dem Hybrid WR hängt ein BYD Akku. Die Einrichtung der ModBus-Schnittstelle hat hervorragend geklappt und die Werte kommen auch logisch rein. Ich habe nur ein Problem bei der Darstellung der Werte für den Hausverbrauch, sobald der Akku geladen wird. Im Grund haben ich einfach folgende Schema (vereinfacht und ohne Akku) für den Verbrauch "PV-Leistung - Netzbezug = Hausverbrauch". Nur leider funktioniert das nicht, wenn der Akku geladen wird, da der Hybrid WR dann keinen Drehstromwert angibt.
Im Aktuellen Fall bekomme ich folgende Wert auf der SE-Plattform angezeigt
Im IO-Broker bekomme ich folgende Werte
In den Akku gibt der Hybrid-WR 3.500 Watt
Der SE7K erzeugt 1.380 Watt
Der Hybrid-WR erzeugt 0 Watt Drehstrom
Wie komme ich jetzt auf den richtigen Hausverbrauch. In meiner Naivität (lassen wir mach Wandlungsverluste außen vor. damit ich muss ich wahrscheinlich einfach leben)dachte ich mir folgendes, was aber nicht richtig zu sein scheint.
Ich rechnen einfach die Leistung (AC) des SE7K (1.380 W) + Leistung (AC) des SE10K (0 Watt) + die Leistung des SE10K, die in den Akku geht, müsste eigentlich DC sein (3.500 Watt) zusammen (ziehe Netzbezug ab und rechne Export drauf) und habe dann meine PV Leistung. In dem Fall also 4.880 Watt Erzeugung. Davon ziehe ich dann die Ladeleistung (AKKU) ab und haben den Hausverbrauch, wenn über das Netz nichts läuft. Also komme ich auf folgende Werte:
PV: 4.880 W
Akku: 3.500 W
Netz: 0 W
Verbrauch: 1.380 W
Das ist aber laut Plattform falsch und ich weiß auch, dass ich aktuell keine 1.380 W verbrauche, da keine größeren Verbrauche an sind. Deswegen gehe ich davon aus, dass der Fehler bei mir liegt und die Werte aus der Plattform korrekt sind.
SE sagt mir also eine PV-Erzeugung von 4.120 Watt an. Das sind also 760 Watt Differenz zu meinen Werten. Wenn ich dies 760 Watt von meine errechneten Verbrauch abziehe, komme ich auch genau 620 Watt Verbrauch, aus der SE-Plattform. Ich habe also einen zu hohen Wert bei der Erzeugung. Entweder vom SE7K oder vom SE10K beim DC-Wert des Akku.
Ich versuche schon seit Wochen auf eine Lösung. Leider ohne Erfolg. Eine Königreich für einen Hinweis. Falls jemand eine Idee hat, bin ich mehr als Dankbar dafür. Sorry für den Langen Post. 
Beim Entladen passt es wieder. Es ist so, dass der Hybrid WR beim Laden keinen Drehstrom anzeigt, insofern nicht noch ins Netz gespeist wird. Wie ist das denn bei Anderen, die einen Hybrid WR haben?
Keiner eine Idee oder einen Hinweis?
@juri88 sagte in [Tutorial] SolarEdge -> Modbus -> ioBroker -> Grafana:
Ich habe 2 WR von SE. Einen "Slave" und einen "Master". Also einen 3 Phasen WR (SE7K) und einen SE10K RWS (Hybrid). An dem Hybrid WR hängt ein BYD Akku.
Hey, ich habe ein ähnliches System - SE9K WR (3-phasig) und SE5000H WR (1-phasig) mit LG-Speicher. Der SE5000H ist der Master, der SE9K ist Slave.
Wie komme ich jetzt auf den richtigen Hausverbrauch. In meiner Naivität (lassen wir mach Wandlungsverluste außen vor. damit ich muss ich wahrscheinlich einfach leben)dachte ich mir folgendes, was aber nicht richtig zu sein scheint.
Ich rechnen einfach die Leistung (AC) des SE7K (1.380 W) + Leistung (AC) des SE10K (0 Watt) + die Leistung des SE10K, die in den Akku geht, müsste eigentlich DC sein (3.500 Watt) zusammen.
Bis hier hin mache ich das selbe - das ist bei mir der PV-Ertrag - also das, was die Sonne aktuell liefert (in Deinen Worten - die PV Leistung)
(ziehe Netzbezug ab und rechne Export drauf) und habe dann meine PV Leistung. In dem Fall also 4.880 Watt Erzeugung. Davon ziehe ich dann die Ladeleistung (AKKU) ab und haben den Hausverbrauch, wenn über das Netz nichts läuft.
Hier ist Dein Fehler. Von dem oben genannten PV-Ertrag ziehst Du nun die Werte des Energiezählers ab (Einspeisung ist positiv, Bezug ist negativ), um Deinen Stromverbrauch im Haus zu ermitteln.
Zahlenbeispiel:
WR1 liefert 2500W
WR2 liefert 0W, läd aber mit 2000W den Speicher
Wenn Du jetzt 0W Hausverbrauch hättest, würdest Du am Energiezähler 2500W Einspeisung sehen.
Hast Du 500W Hausverbrauch, siehst Du von den 2500W des WR1 nur 2000W am Energiezähler - der Rest geht im Haus drauf - das ist dann Dein Hausverbrauch.
Ich hoffe, ich habe er verständlich erklärt.
Viele Grüße,
Strobi
@smidl hast du das Problem in den Griff bekommen?
Stehe vor der gleichen Problematik
@smidl sagte in [Tutorial] SolarEdge -> Modbus -> ioBroker -> Grafana:
Vielen Dank für das super Tutorial. Bei mir hat soweit alles funktioniert.
Ich habe den WR SolarEdge SE10K - RWS und den BYD LVS 8.0 Speicher.
Ein Problem bei der Kombination ist der Wert für die aktuelle PV-Leistung vom Dach. Der sollte in der Nacht ja bei ~0W stehen. Tut er aber nicht sondern liefert mir den Wert (annähernd) meines Hausverbrauches, welcher ja nachts aus dem Speicher entladen wird.
Den Wert sollte es doch aber geben? Zumindest im Portal oder in der mySolarEdge App ist der Wert ja bekannt.
Hat jemand von euch eine Idee, wie ich den Wert raus bekomme?
Das gleiche Problem habe ich beim Laden des Speichers. Einen zuverlässigen Wert für 40083_I_AC_Leistung bekomme ich erst, sobald der Speicher voll ist.
Ich könnte das ja auch berechnen, indem ich die Lade-/Entlade-Leistung abhängig vom 57734_Battery Register mit einbeziehe, nur ist das ja nicht gerade gewollt.Hat jemand das selbe Problem?
Hast du das Problem lösen können? Stehe vor der gleichen Problematik
Ich bin begeistert. Endlich ein super Tutorial für SE und Modbus. Besteht irgendwie die Chance das ganze auch für nen Modbus Proxy umzusetzen? Ich tue mich da gerade schwer. Ziel: OpenWB und Victron Batterie WR sollen auf den Modbus Stream des SE Zählers zugreifen können. Hintergrund: Die OpenWB fragt aktuell per Modbus den Solaredge Modbus Zähler ab. Diese Daten ruft der Victron Batterie Wechselrichter (MP2) über MQTT von der openWB ab und regelt entsprechend die Ein- bzw. Ausspeiseleistung der Batterie. Das (schwierige )Ziel natürlich: 0 Einspeisung.
Wie man auf der Grafik sieht, klappt das bei schnellen, starken Lastanstiegen so gut wie nie.
Ich verwende das Register 57716 Batterie und aus meiner Sicht geht das nur so, weil das Gleichungssystem sich sonst nicht eindeutig lösen lässt.
Wichtig! Trotz der Tatsache, dass bei mir der Energiezähler erfolgreich installiert wurde und mir mein Solarteur mitgeteilt hat, dass alles korrekt funktioniert war bei mir Modbus TCP nicht aktiviert. Darauf müsst ihr achten, sonst klappt keine Verbindung.
@hennerich Starke Arbeit erstmal! Das hat mir richtig geholfen! Ich hatte ein ähnliches Problem was den Modbus-Zugang angeht.
MOD-EDIT: Text entschärft
