Jump to content

Forecast data visualisation


Recommended Posts

Hello PVSol community & solar PV designers,

You're welcome to request a spreadsheet that visualises the forecast data exported from PVSol, example results below, from me via Linkedin - just fire me a message. 

I have personally created it, so happy to share. It's a long time coming, I created this because I feel the PVSol diagram editor doesn't meet what I look for in a forecast illustration. Most of all, I think PVSol is missing something that explains the forecast day-to-day life of the solar PV system (without the vertical axes changing with the day too). 

This spreadsheet creates graphs that illustrate forecasted: energy consumption, solar generation, solar export, battery charge, battery discharge, energy curtailment. Per day, and you can click a scrollbar to scroll through the days of the year. The spreadsheet only works with PVSol exported data, either hourly and minute data. Without amending the spreadsheet (which otherwise is easy), it would work up to 3 inverters, so up to 450kWp? Minute interval datasets can reach 500MB so you'll need a good computer.

Comments/Criticism to the spreadsheet welcome!

No doubt something like this will be integrated into future versions of PVSol.





  • Like 1
Link to comment
Share on other sites

Hi Jordan,


It looks really good, thanks for offering to share with the community! I don't use LinkedIn (or any other social media) anymore, would it be possible for you to send the spreadsheet here via a private message? If so I'd be very happy to try it out and give you some feedback on it.


Best regards

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...