The Scenario
You manage a portfolio of 10 solar installations across Germany and you're the one who decides when to dispatch battery storage and when to let the grid take surplus. That decision depends on the 48-hour generation forecast for each site, and right now those forecasts live in the Corrently API — not in the workbook where your dispatch team works.
The last person who had this job set up a manual pull. They left two months ago and didn't document anything.
The bad version:
- Find the Corrently solar forecast endpoint they were using, figure out which parameters it needs — GPS coordinates, not postal codes
- Run the call for site 1, parse the 48-hour hourly series (that's 48 JSON objects), identify the peak hour and sum the daily watt-hours, enter those two values into the workbook
- Repeat for 9 more sites, losing track somewhere around site 6 of whether you're on today's peak or tomorrow's peak
Your battery dispatch team needs the updated forecast table every morning by 7 AM. The manual process takes 90 minutes and was apparently why the last manager left.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your site list — coordinates in columns A and B — calls the Corrently solar PV forecast endpoint for each installation, and writes the peak generation hour and total forecasted daily production back to the correct rows.
For each site with GPS coordinates in columns A and B, fetch the 48-hour hourly PV generation forecast from Corrently and write the peak generation hour and total forecasted daily production in Wh to columns C and D
What You Get
- Column C: the clock hour (e.g., "11:00") when the site is forecast to reach peak solar output over the next 48 hours
- Column D: total forecasted watt-hours for the first full generation day
- Sites with missing or out-of-range coordinates flagged with a note in column E
- All 10 sites updated from the same API call window so the forecasts are comparable
What If the Data Is Not Quite Ready
Coordinates are in a single column as a comma-separated pair
The export from the engineering team wrote coordinates as "52.5200,13.4050" in a single cell.
Split the coordinate pairs in column A into separate latitude and longitude values, then fetch the 48-hour PV generation forecast from Corrently for each site and write the peak generation hour and daily Wh total to columns B and C
You need tomorrow's peak hour separately from today's
Dispatch decisions are made on a day-by-day basis.
For each site with coordinates in columns A and B, fetch the 48-hour Corrently solar forecast and write today's peak generation hour to column C, today's total Wh to column D, tomorrow's peak hour to column E, and tomorrow's total Wh to column F
You want to flag sites where forecast output drops more than 30% from today to tomorrow
A big drop signals a weather event and may change dispatch strategy.
Fetch the 48-hour PV generation forecast from Corrently for each site using coordinates in columns A and B, write today's Wh to column C and tomorrow's Wh to column D, calculate the day-over-day change percentage in column E, and flag any row where the drop exceeds 30% with "WEATHER EVENT" in column F
Full pipeline: validate coordinates, fetch both days, flag drops, and surface the top producer
All cleanup, both forecast days, drop flags, and a "TOP OUTPUT" marker for the highest-generating site.
Validate that the coordinate pairs in columns A and B are within Germany's bounding box, fetch the 48-hour Corrently PV forecast for each valid site, write today's peak hour to column C and Wh total to column D, tomorrow's peak hour to column E and Wh total to column F, flag any site with a day-over-day Wh drop above 30% in column G, and mark the site with the highest today total "TOP OUTPUT" in column H
One ask, and the dispatch team has what they need at 7 AM.
Try It
Get the 7-day free trial of SheetXAI and open your solar site workbook with GPS coordinates, then ask it to pull the 48-hour PV generation forecast from Corrently for every installation. For related reads, see generating device operation schedules and the Corrently integration overview.