+- myGEKKO - Das Forum (https://forum.my-gekko.com)
+-- Forum: Software (https://forum.my-gekko.com/forumdisplay.php?fid=26)
+--- Forum: Query API (https://forum.my-gekko.com/forumdisplay.php?fid=46)
+--- Thema: Energymanager Trends über API (/showthread.php?tid=2042)
Energymanager Trends über API - Olli1980 - 05.05.2021
Hi allesamt!
Zusätzlich zu meinem anderen Posts bezüglich abgreifen der Liste des Energiemanagers, habe ich heute auch versucht, die "Trends" abzugreifen.
Das funktioniert soweit auch, aber ich bin mir nicht ganz sicher, ob ich den Output davon richtig verstehe.
Ist es so, dass aus dem Energiemanager-Trends von der API quasi (je nachdem was ich abfrage, klar) die Werte in einem 15-minuten Rhythmus wiedergegeben werden, also am Ende 96 Werte für 1 Tag, wenn man von 00:00:00 bis 23:59:59 abfragt und dass dann eine Zeile quasi der Wert von 00:00:00, die nächste von 00:15:00 etc ist und dann jede Zeile für 15 Minuten steht?
Ich hatte dann mal einfach alle Zeilen des 1 Tages zusammengerechnet und kam auf einen sehr hohen Wert (65), der so nicht gepasst hat für das was in der Liste für das Haus zb gestern stand. Daraufhin hab ich dann die 4 Werte einer Stunde als Durchschnitt gebildet, also zb für Stunde 0 Durchschnitt aus den 4 Werten (:00,:15,:30,:45) was dann zb 0,355 machte. Danach habe ich dann die 24 "Durchschnitte" aufsummiert und kam dann sehr nah an den Gesamtwert in kwh der dann auch bei dem Listeneintrag für das Haus gestern ausgewiesen wurde. Wäre die Rechnung so richtig?
Danke euch!
RE: Energymanager Trends über API - Marco - 06.05.2021
media(all 96 value) X 24
because trend are in kW (instant consumption) but you want to see allday consumption in kWh
-----------------------------------
https://live,my-gekko,com/api/v1/trend/energymanager/trend1/status?tstart=2021-04-26T15:00:00+01:00&tend=2021-04-27T15:00:00+01:00&datacount=96&username=......
{
"returnValue": 1,
"trendData": [2.40875, 0, 0.815769, 0.995687, 0.984928, 0.986063, 0.528357, 0.408867, 0.408733, 0.4084, 0.4096, 0.408933, 0.714667, 0.235, 0.222867, 0.2262, 0.225062, 0.222929, 0.223733, 0.222533, 0.223533, 0.22325, 0.223714, 0.228562, 0.236857, 0.2374, 0.314733, 2.46813, 0.24, 0.236467, 0.236062, 0.235929, 0.237187, 0.236571, 0.235867, 0.236267, 0.2374, 0.2374, 0.2372, 0.2375, 0.237071, 0.236313, 0.237357, 0.237, 0.237071, 0.237067, 0.2378, 0.236867, 0.236533, 0.242133, 0.242467, 0.242, 0.2418, 0.2418, 0.2422, 0.238067, 0.237267, 0.23725, 0.236643, 0.241, 0.233667, 0.224867, 0.2225, 0.222643, 0.222188, 0.222429, 0.224625, 0.247143, 0.279867, 0.2788, 0.7174, 0.29475, 1.0905, 1.28433, 0.7892, 0.9134, 0.6938, 0.993667, 0, 1.54573, 0, 1.14694, 0.403933, 0.3504, 0.350813, 0.461286, 0.393933, 0.285467, 0.283267, 0.280867, 0.454733, 0.487267, 0.399062, 0.33, 0.331, 0.330067],
"path": "/data/trend/",
"itemname": "EMAX0_ACT",
"tstart": 1619442000,
"tend": 1619528400,
"sampl": 900,
"datacount": 96,
"subvalue": 0,
"returnValue": 1
}
media(2.40875, 0, 0.815769, 0.995687, 0.984928, 0.986063, 0.528357, 0.408867, 0.408733, 0.4084, 0.4096, 0.408933, 0.714667, 0.235, 0.222867, 0.2262, 0.225062, 0.222929, 0.223733, 0.222533, 0.223533, 0.22325, 0.223714, 0.228562, 0.236857, 0.2374, 0.314733, 2.46813, 0.24, 0.236467, 0.236062, 0.235929, 0.237187, 0.236571, 0.235867, 0.236267, 0.2374, 0.2374, 0.2372, 0.2375, 0.237071, 0.236313, 0.237357, 0.237, 0.237071, 0.237067, 0.2378, 0.236867, 0.236533, 0.242133, 0.242467, 0.242, 0.2418, 0.2418, 0.2422, 0.238067, 0.237267, 0.23725, 0.236643, 0.241, 0.233667, 0.224867, 0.2225, 0.222643, 0.222188, 0.222429, 0.224625, 0.247143, 0.279867, 0.2788, 0.7174, 0.29475, 1.0905, 1.28433, 0.7892, 0.9134, 0.6938, 0.993667, 0, 1.54573, 0, 1.14694, 0.403933, 0.3504, 0.350813, 0.461286, 0.393933, 0.285467, 0.283267, 0.280867, 0.454733, 0.487267, 0.399062, 0.33, 0.331, 0.330067) = 0,41 kW
0,41 kW * 24h = 9,95kwH. that's correct
RE: Energymanager Trends über API - Olli1980 - 06.05.2021
(06.05.2021, 10:19)Marco schrieb: media(all 96 value) X 24
because trend are in kW (instant consumption) but you want to see allday consumption in kWh
-----------------------------------
https://live,my-gekko,com/api/v1/trend/energymanager/trend1/status?tstart=2021-04-26T15:00:00+01:00&tend=2021-04-27T15:00:00+01:00&datacount=96&username=......
{
"returnValue": 1,
"trendData": [2.40875, 0, 0.815769, 0.995687, 0.984928, 0.986063, 0.528357, 0.408867, 0.408733, 0.4084, 0.4096, 0.408933, 0.714667, 0.235, 0.222867, 0.2262, 0.225062, 0.222929, 0.223733, 0.222533, 0.223533, 0.22325, 0.223714, 0.228562, 0.236857, 0.2374, 0.314733, 2.46813, 0.24, 0.236467, 0.236062, 0.235929, 0.237187, 0.236571, 0.235867, 0.236267, 0.2374, 0.2374, 0.2372, 0.2375, 0.237071, 0.236313, 0.237357, 0.237, 0.237071, 0.237067, 0.2378, 0.236867, 0.236533, 0.242133, 0.242467, 0.242, 0.2418, 0.2418, 0.2422, 0.238067, 0.237267, 0.23725, 0.236643, 0.241, 0.233667, 0.224867, 0.2225, 0.222643, 0.222188, 0.222429, 0.224625, 0.247143, 0.279867, 0.2788, 0.7174, 0.29475, 1.0905, 1.28433, 0.7892, 0.9134, 0.6938, 0.993667, 0, 1.54573, 0, 1.14694, 0.403933, 0.3504, 0.350813, 0.461286, 0.393933, 0.285467, 0.283267, 0.280867, 0.454733, 0.487267, 0.399062, 0.33, 0.331, 0.330067],
"path": "/data/trend/",
"itemname": "EMAX0_ACT",
"tstart": 1619442000,
"tend": 1619528400,
"sampl": 900,
"datacount": 96,
"subvalue": 0,
"returnValue": 1
}
media(2.40875, 0, 0.815769, 0.995687, 0.984928, 0.986063, 0.528357, 0.408867, 0.408733, 0.4084, 0.4096, 0.408933, 0.714667, 0.235, 0.222867, 0.2262, 0.225062, 0.222929, 0.223733, 0.222533, 0.223533, 0.22325, 0.223714, 0.228562, 0.236857, 0.2374, 0.314733, 2.46813, 0.24, 0.236467, 0.236062, 0.235929, 0.237187, 0.236571, 0.235867, 0.236267, 0.2374, 0.2374, 0.2372, 0.2375, 0.237071, 0.236313, 0.237357, 0.237, 0.237071, 0.237067, 0.2378, 0.236867, 0.236533, 0.242133, 0.242467, 0.242, 0.2418, 0.2418, 0.2422, 0.238067, 0.237267, 0.23725, 0.236643, 0.241, 0.233667, 0.224867, 0.2225, 0.222643, 0.222188, 0.222429, 0.224625, 0.247143, 0.279867, 0.2788, 0.7174, 0.29475, 1.0905, 1.28433, 0.7892, 0.9134, 0.6938, 0.993667, 0, 1.54573, 0, 1.14694, 0.403933, 0.3504, 0.350813, 0.461286, 0.393933, 0.285467, 0.283267, 0.280867, 0.454733, 0.487267, 0.399062, 0.33, 0.331, 0.330067) = 0,41 kW
0,41 kW * 24h = 9,95kwH. that's correct
Thanks a lot Marco, so I was pretty close
RE: Energymanager Trends über API - Marco - 06.05.2021
yes "pretty close".
if need exact data better look to an counter, like (i'm on mygekko modbus seneca)
https://live.my-gekko.com/api/v1/var/energycosts/item1/status?username=...
{
"sumstate": {
"value": "2.31;7.08;52.52;2379.88;3.00;kWh;kW;0;0;0;0;0;0;0;0;0"
}
}
https://live.my-gekko.com/api/v1/var/energycosts/item1/?username=...
{
"name": "Contatore Enel",
"page": "Contatori",
"sumstate": {
"value": "Act.power;EnergyToday;EnergyMonth;EnergySum;PowerMax;UnitEnergy;UnitPower;EnergyToday.0-6;EnergyToday.6-12;EnergyToday.12-18;EnergyToday.18-24;EnergyYesterd.0-6;EnergyYesterd.6-12;EnergyYesterd.12-18;EnergyYesterd.18-24;SumState[0=Ok|1=ManualOff|2=ManualOn|3=Locked|4=Alarm]",
"type": "STRING",
"permission": "READ",
"index": 800100
}
}
RE: Energymanager Trends über API - Olli1980 - 06.05.2021
(06.05.2021, 15:06)Marco schrieb: yes "pretty close".
if need exact data better look to an counter, like (i'm on mygekko modbus seneca)
https://live.my-gekko.com/api/v1/var/energycosts/item1/status?username=...
{
"sumstate": {
"value": "2.31;7.08;52.52;2379.88;3.00;kWh;kW;0;0;0;0;0;0;0;0;0"
}
}
https://live.my-gekko.com/api/v1/var/energycosts/item1/?username=...
{
"name": "Contatore Enel",
"page": "Contatori",
"sumstate": {
"value": "Act.power;EnergyToday;EnergyMonth;EnergySum;PowerMax;UnitEnergy;UnitPower;EnergyToday.0-6;EnergyToday.6-12;EnergyToday.12-18;EnergyToday.18-24;EnergyYesterd.0-6;EnergyYesterd.6-12;EnergyYesterd.12-18;EnergyYesterd.18-24;SumState[0=Ok|1=ManualOff|2=ManualOn|3=Locked|4=Alarm]",
"type": "STRING",
"permission": "READ",
"index": 800100
}
}
Hi Marco,
sounds interesting, for me I think the "close enough" part is good enough.
It will actually help me to train a statistical model in the end, predicting how much how much energy will be pulled for any given hour tomorrow or the day after from the energy provider and how much energy my solar system will bring in, by basically now adding historical weather data to my historical power usage data.
Once the model is train I could then enter tomorrows weather forecast into it and predict my solar energy outcome.