PVForecast Wert extrahieren

icebear

Hallo, ich bräuchte mal wieder das geballte Schwarmwissen, ich würde gerne aus den DP vom PVForecast Adapter die Zeit mit dem höchsten "geschätzten Ertrag" in einen neue DP schreiben.

Ich hab schon mal rumgesucht ob das einer schonmal gemacht hat, bin aber nicht wirklich fündig geworden. Die meisten filtern hier nach dem Ertrag, ich möchte aber die Zeit haben, in welcher Stunde der meiste zu erwartende Ertrag ist.

Vielleicht kann ja einer mit einem Blockly oder JS helfen, wie das zu bewerkstelligen ist.

Hier die DP.

hours today.png

und hier das ganze nochmal als json data

[
  {
    "t": 1724385600000,
    "y": 0
  },
  {
    "t": 1724387400000,
    "y": 0
  },
  {
    "t": 1724389200000,
    "y": 0
  },
  {
    "t": 1724391000000,
    "y": 0.137
  },
  {
    "t": 1724392800000,
    "y": 0.597
  },
  {
    "t": 1724394600000,
    "y": 1.046
  },
  {
    "t": 1724396400000,
    "y": 1.437
  },
  {
    "t": 1724398200000,
    "y": 1.967
  },
  {
    "t": 1724400000000,
    "y": 2.503
  },
  {
    "t": 1724401800000,
    "y": 2.978
  },
  {
    "t": 1724403600000,
    "y": 3.327
  },
  {
    "t": 1724405400000,
    "y": 3.629
  },
  {
    "t": 1724407200000,
    "y": 3.899
  },
  {
    "t": 1724409000000,
    "y": 4.078
  },
  {
    "t": 1724410800000,
    "y": 4.188
  },
  {
    "t": 1724412600000,
    "y": 4.16
  },
  {
    "t": 1724414400000,
    "y": 4.001
  },
  {
    "t": 1724416200000,
    "y": 3.637
  },
  {
    "t": 1724418000000,
    "y": 3.075
  },
  {
    "t": 1724419800000,
    "y": 2.532
  },
  {
    "t": 1724421600000,
    "y": 2.012
  },
  {
    "t": 1724423400000,
    "y": 1.603
  },
  {
    "t": 1724425200000,
    "y": 1.323
  },
  {
    "t": 1724427000000,
    "y": 0.992
  },
  {
    "t": 1724428800000,
    "y": 0.649
  },
  {
    "t": 1724430600000,
    "y": 0.375
  },
  {
    "t": 1724432400000,
    "y": 0.16
  },
  {
    "t": 1724434200000,
    "y": 0.025
  },
  {
    "t": 1724436000000,
    "y": 0
  },
  {
    "t": 1724437800000,
    "y": 0
  },
  {
    "t": 1724439600000,
    "y": 0
  },
  {
    "t": 1724441400000,
    "y": 0
  },
  {
    "t": 1724472000000,
    "y": 0
  },
  {
    "t": 1724473800000,
    "y": 0
  },
  {
    "t": 1724475600000,
    "y": 0
  },
  {
    "t": 1724477400000,
    "y": 0.255
  },
  {
    "t": 1724479200000,
    "y": 0.78
  },
  {
    "t": 1724481000000,
    "y": 1.202
  },
  {
    "t": 1724482800000,
    "y": 1.521
  },
  {
    "t": 1724484600000,
    "y": 2.071
  },
  {
    "t": 1724486400000,
    "y": 2.609
  },
  {
    "t": 1724488200000,
    "y": 3.089
  },
  {
    "t": 1724490000000,
    "y": 3.503
  },
  {
    "t": 1724491800000,
    "y": 3.848
  },
  {
    "t": 1724493600000,
    "y": 4.118
  },
  {
    "t": 1724495400000,
    "y": 4.311
  },
  {
    "t": 1724497200000,
    "y": 4.426
  },
  {
    "t": 1724499000000,
    "y": 4.469
  },
  {
    "t": 1724500800000,
    "y": 4.44
  },
  {
    "t": 1724502600000,
    "y": 4.342
  },
  {
    "t": 1724504400000,
    "y": 4.177
  },
  {
    "t": 1724506200000,
    "y": 3.949
  },
  {
    "t": 1724508000000,
    "y": 3.662
  },
  {
    "t": 1724509800000,
    "y": 3.368
  },
  {
    "t": 1724511600000,
    "y": 3.082
  },
  {
    "t": 1724513400000,
    "y": 2.651
  },
  {
    "t": 1724515200000,
    "y": 2.197
  },
  {
    "t": 1724517000000,
    "y": 1.699
  },
  {
    "t": 1724518800000,
    "y": 1.174
  },
  {
    "t": 1724520600000,
    "y": 0.619
  },
  {
    "t": 1724522400000,
    "y": 0.152
  },
  {
    "t": 1724524200000,
    "y": 0
  },
  {
    "t": 1724526000000,
    "y": 0
  },
  {
    "t": 1724527800000,
    "y": 0
  }
]

oder json table

[
  {
    "Time": "2024-08-23 06:00:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-23 06:30:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-23 07:00:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-23 07:30:00",
    "Total": "0,137",
    "SüdWest": "0,054",
    "NordOst": "0,083"
  },
  {
    "Time": "2024-08-23 08:00:00",
    "Total": "0,597",
    "SüdWest": "0,176",
    "NordOst": "0,421"
  },
  {
    "Time": "2024-08-23 08:30:00",
    "Total": "1,046",
    "SüdWest": "0,245",
    "NordOst": "0,801"
  },
  {
    "Time": "2024-08-23 09:00:00",
    "Total": "1,437",
    "SüdWest": "0,311",
    "NordOst": "1,126"
  },
  {
    "Time": "2024-08-23 09:30:00",
    "Total": "1,967",
    "SüdWest": "0,627",
    "NordOst": "1,340"
  },
  {
    "Time": "2024-08-23 10:00:00",
    "Total": "2,503",
    "SüdWest": "1,038",
    "NordOst": "1,465"
  },
  {
    "Time": "2024-08-23 10:30:00",
    "Total": "2,978",
    "SüdWest": "1,465",
    "NordOst": "1,513"
  },
  {
    "Time": "2024-08-23 11:00:00",
    "Total": "3,327",
    "SüdWest": "1,846",
    "NordOst": "1,481"
  },
  {
    "Time": "2024-08-23 11:30:00",
    "Total": "3,629",
    "SüdWest": "2,195",
    "NordOst": "1,434"
  },
  {
    "Time": "2024-08-23 12:00:00",
    "Total": "3,899",
    "SüdWest": "2,523",
    "NordOst": "1,376"
  },
  {
    "Time": "2024-08-23 12:30:00",
    "Total": "4,078",
    "SüdWest": "2,790",
    "NordOst": "1,288"
  },
  {
    "Time": "2024-08-23 13:00:00",
    "Total": "4,188",
    "SüdWest": "3,007",
    "NordOst": "1,181"
  },
  {
    "Time": "2024-08-23 13:30:00",
    "Total": "4,160",
    "SüdWest": "3,105",
    "NordOst": "1,055"
  },
  {
    "Time": "2024-08-23 14:00:00",
    "Total": "4,001",
    "SüdWest": "3,072",
    "NordOst": "0,929"
  },
  {
    "Time": "2024-08-23 14:30:00",
    "Total": "3,637",
    "SüdWest": "2,800",
    "NordOst": "0,837"
  },
  {
    "Time": "2024-08-23 15:00:00",
    "Total": "3,075",
    "SüdWest": "2,279",
    "NordOst": "0,796"
  },
  {
    "Time": "2024-08-23 15:30:00",
    "Total": "2,532",
    "SüdWest": "1,768",
    "NordOst": "0,764"
  },
  {
    "Time": "2024-08-23 16:00:00",
    "Total": "2,012",
    "SüdWest": "1,293",
    "NordOst": "0,719"
  },
  {
    "Time": "2024-08-23 16:30:00",
    "Total": "1,603",
    "SüdWest": "0,963",
    "NordOst": "0,640"
  },
  {
    "Time": "2024-08-23 17:00:00",
    "Total": "1,323",
    "SüdWest": "0,794",
    "NordOst": "0,529"
  },
  {
    "Time": "2024-08-23 17:30:00",
    "Total": "0,992",
    "SüdWest": "0,595",
    "NordOst": "0,397"
  },
  {
    "Time": "2024-08-23 18:00:00",
    "Total": "0,649",
    "SüdWest": "0,389",
    "NordOst": "0,260"
  },
  {
    "Time": "2024-08-23 18:30:00",
    "Total": "0,375",
    "SüdWest": "0,225",
    "NordOst": "0,150"
  },
  {
    "Time": "2024-08-23 19:00:00",
    "Total": "0,160",
    "SüdWest": "0,096",
    "NordOst": "0,064"
  },
  {
    "Time": "2024-08-23 19:30:00",
    "Total": "0,025",
    "SüdWest": "0,015",
    "NordOst": "0,010"
  },
  {
    "Time": "2024-08-23 20:00:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-23 20:30:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-23 21:00:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-23 21:30:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-24 06:00:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-24 06:30:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-24 07:00:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-24 07:30:00",
    "Total": "0,255",
    "SüdWest": "0,033",
    "NordOst": "0,222"
  },
  {
    "Time": "2024-08-24 08:00:00",
    "Total": "0,780",
    "SüdWest": "0,110",
    "NordOst": "0,670"
  },
  {
    "Time": "2024-08-24 08:30:00",
    "Total": "1,202",
    "SüdWest": "0,130",
    "NordOst": "1,072"
  },
  {
    "Time": "2024-08-24 09:00:00",
    "Total": "1,521",
    "SüdWest": "0,201",
    "NordOst": "1,320"
  },
  {
    "Time": "2024-08-24 09:30:00",
    "Total": "2,071",
    "SüdWest": "0,582",
    "NordOst": "1,489"
  },
  {
    "Time": "2024-08-24 10:00:00",
    "Total": "2,609",
    "SüdWest": "1,044",
    "NordOst": "1,565"
  },
  {
    "Time": "2024-08-24 10:30:00",
    "Total": "3,089",
    "SüdWest": "1,506",
    "NordOst": "1,583"
  },
  {
    "Time": "2024-08-24 11:00:00",
    "Total": "3,503",
    "SüdWest": "1,940",
    "NordOst": "1,563"
  },
  {
    "Time": "2024-08-24 11:30:00",
    "Total": "3,848",
    "SüdWest": "2,335",
    "NordOst": "1,513"
  },
  {
    "Time": "2024-08-24 12:00:00",
    "Total": "4,118",
    "SüdWest": "2,682",
    "NordOst": "1,436"
  },
  {
    "Time": "2024-08-24 12:30:00",
    "Total": "4,311",
    "SüdWest": "2,976",
    "NordOst": "1,335"
  },
  {
    "Time": "2024-08-24 13:00:00",
    "Total": "4,426",
    "SüdWest": "3,215",
    "NordOst": "1,211"
  },
  {
    "Time": "2024-08-24 13:30:00",
    "Total": "4,469",
    "SüdWest": "3,400",
    "NordOst": "1,069"
  },
  {
    "Time": "2024-08-24 14:00:00",
    "Total": "4,440",
    "SüdWest": "3,530",
    "NordOst": "0,910"
  },
  {
    "Time": "2024-08-24 14:30:00",
    "Total": "4,342",
    "SüdWest": "3,603",
    "NordOst": "0,739"
  },
  {
    "Time": "2024-08-24 15:00:00",
    "Total": "4,177",
    "SüdWest": "3,617",
    "NordOst": "0,560"
  },
  {
    "Time": "2024-08-24 15:30:00",
    "Total": "3,949",
    "SüdWest": "3,571",
    "NordOst": "0,378"
  },
  {
    "Time": "2024-08-24 16:00:00",
    "Total": "3,662",
    "SüdWest": "3,464",
    "NordOst": "0,198"
  },
  {
    "Time": "2024-08-24 16:30:00",
    "Total": "3,368",
    "SüdWest": "3,287",
    "NordOst": "0,081"
  },
  {
    "Time": "2024-08-24 17:00:00",
    "Total": "3,082",
    "SüdWest": "2,980",
    "NordOst": "0,102"
  },
  {
    "Time": "2024-08-24 17:30:00",
    "Total": "2,651",
    "SüdWest": "2,484",
    "NordOst": "0,167"
  },
  {
    "Time": "2024-08-24 18:00:00",
    "Total": "2,197",
    "SüdWest": "1,999",
    "NordOst": "0,198"
  },
  {
    "Time": "2024-08-24 18:30:00",
    "Total": "1,699",
    "SüdWest": "1,496",
    "NordOst": "0,203"
  },
  {
    "Time": "2024-08-24 19:00:00",
    "Total": "1,174",
    "SüdWest": "0,991",
    "NordOst": "0,183"
  },
  {
    "Time": "2024-08-24 19:30:00",
    "Total": "0,619",
    "SüdWest": "0,479",
    "NordOst": "0,140"
  },
  {
    "Time": "2024-08-24 20:00:00",
    "Total": "0,152",
    "SüdWest": "0,096",
    "NordOst": "0,056"
  },
  {
    "Time": "2024-08-24 20:30:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-24 21:00:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  },
  {
    "Time": "2024-08-24 21:30:00",
    "Total": "0,000",
    "SüdWest": "0,000",
    "NordOst": "0,000"
  }
]

paul53

@icebear sagte: als json data

Enthält das JSON nur die Werte von heute? Falls nicht, muss man den Tag prüfen.

icebear

@paul53 said in PVForecast Wert extrahieren:

Enthält das JSON nur die Werte von heute? Falls nicht, muss man den Tag prüfen.

Ersteinmal vielen Dank für deine schnelle Antwort.

Das ist nur für 'Heute', für den nächsten Tag gibt es ein extra json.

Ich habs jetzt mal ausprobiert, bekomm aber folgenden Fehler.

javascript.0
2024-08-23 17:16:30.783	error	script.js.Energie_Strom.PVPrognose: scheduleById(id=pvforecast.0.summary.JSONData,time=[ { "t": 1724385600000, "y": 0 }, { "t": 1724387400000, "y": 0 }, { "t": 1724389200000, "y": 0 }, { "t": 1724391000000, "y": 0.137 }, { "t": 1724392800000, "y": 0.597 }, { "t": 1724394600000, "y": 1.046 }, { "t": 1724396400000, "y": 1.437 }, { "t": 1724398200000, "y": 1.967 }, { "t": 1724400000000, "y": 2.503 }, { "t": 1724401800000, "y": 2.978 }, { "t": 1724403600000, "y": 3.327 }, { "t": 1724405400000, "y": 3.629 }, { "t": 1724407200000, "y": 3.899 }, { "t": 1724409000000, "y": 4.078 }, { "t": 1724410800000, "y": 4.188 }, { "t": 1724412600000, "y": 4.16 }, { "t": 1724414400000, "y": 4.001 }, { "t": 1724416200000, "y": 3.637 }, { "t": 1724418000000, "y": 3.075 }, { "t": 1724419800000, "y": 2.532 }, { "t": 1724421600000, "y": 2.012 }, { "t": 1724423400000, "y": 1.603 }, { "t": 1724425200000, "y": 1.323 }, { "t": 1724427000000, "y": 0.992 }, { "t": 1724428800000, "y": 0.649 }, { "t": 1724430600000, "y": 0.375 }, { "t": 1724432400000, "y": 0.16 }, { "t": 1724434200000, "y": 0.025 }, { "t": 1724436000000, "y": 0 }, { "t": 1724437800000, "y": 0 }, { "t": 1724439600000, "y": 0 }, { "t": 1724441400000, "y": 0 }, { "t": 1724472000000, "y": 0 }, { "t": 1724473800000, "y": 0 }, { "t": 1724475600000, "y": 0 }, { "t": 1724477400000, "y": 0.255 }, { "t": 1724479200000, "y": 0.78 }, { "t": 1724481000000, "y": 1.202 }, { "t": 1724482800000, "y": 1.521 }, { "t": 1724484600000, "y": 2.071 }, { "t": 1724486400000, "y": 2.609 }, { "t": 1724488200000, "y": 3.089 }, { "t": 1724490000000, "y": 3.503 }, { "t": 1724491800000, "y": 3.848 }, { "t": 1724493600000, "y": 4.118 }, { "t": 1724495400000, "y": 4.311 }, { "t": 1724497200000, "y": 4.426 }, { "t": 1724499000000, "y": 4.469 }, { "t": 1724500800000, "y": 4.44 }, { "t": 1724502600000, "y": 4.342 }, { "t": 1724504400000, "y": 4.177 }, { "t": 1724506200000, "y": 3.949 }, { "t": 1724508000000, "y": 3.662 }, { "t": 1724509800000, "y": 3.368 }, { "t": 1724511600000, "y": 3.082 }, { "t": 1724513400000, "y": 2.651 }, { "t": 1724515200000, "y": 2.197 }, { "t": 1724517000000, "y": 1.699 }, { "t": 1724518800000, "y": 1.174 }, { "t": 1724520600000, "y": 0.619 }, { "t": 1724522400000, "y": 0.152 }, { "t": 1724524200000, "y": 0 }, { "t": 1724526000000, "y": 0 }, { "t": 1724527800000, "y": 0 }]): cannot create schedule - invalid format (HH:MM:SS or H:M:S required)

Edit: Sorry, hab mich verklickt, hatte den flaschen Trigger-Baustein ausgewählt.

paul53

@icebear sagte: Das ist nur für 'Heute', für den nächsten Tag gibt es ein extra json.

Ich sehe aber im geposteten JSON Daten von heute und morgen alle 30 Minuten.

icebear

@paul53

Ah, sorry war mein Fehler, das json ist wohl doch für heute und morgen.

Man müsste also auch den Tag prüfen.

paul53

@icebear sagte: Man müsste also auch den Tag prüfen.

... was im gezeigten Skript erfolgt.

Community Forum

NEWS

PVForecast Wert extrahieren

Support us

959

32.5k

81.9k

1.3m