Hi,
I have recently added our solar output which is loading data automatically in real time. Works fine.
Additionally, I have around 6 years of historic data which could be delivered as a CSV file. I don’t think I can upload it to pvoutput as I have thousands of data’s lines. Is anyone aware of a site where I could share this data. For no good reason other than I’d like to.
J
You could always put in in a google sheets document and make a graph in google sheets and share that file publicly.
I could but that isn’t quite searchable in an easy way.
I wanted be able to easily show peak values, good months, good years etc…
I will look at doing something like that though.
Thanks for the suggestion.
If you can manipulate your CSV file into just daily records, you can upload you daily data to PVOutput in chunks of 200 days which is about 11 uploads for 6 years. Live data can only be uploaded for the last 14 days or 90 days if you’re a donator. You won’t be able to see the details during a day, but you would be able to see daily, weekly, monthly and yearly comparisons. You can also record peak generation and export on the daily record. Take a look at the CSV Bulk Loader documentation.
Yes I had considered doing so and may do just that.
I’ll need to do some clever manipulating of my data and it wont give the full story.
However it might be an interesting exercise providing I can the summate the values automatically.
Removing the lines with zero output power took Excel many minutes of churning.
Thanks
Having initially dismissed the idea because I thought it would be too complicated I then, after your prompting, took a look at actually it turns out to be far more straight forward than I thought.
First 200 days of data uploaded. I might try and automate the spreadsheets a little more but hopefully I’ll upload the rest of the 6 years data shortly.
Thanks again.
Jerry,
Glad I could help. There’s probably an easy way to summarize your data by day using pivot tables in Excel. If it were me, I’d probably write a quick little VBA routine in Excel that would parse through the data line by line totaling the values or recording the min and max values as appropriate and then write the daily totals to a line on a new sheet when the date changes to the next day. But then again VBA and Excel are my bread and butter.
The good news is, once you get your historical data loaded, you shouldn’t have to worry about that again.
Using A SUMIF function I could quickly generate output for 200 days at a time. Interestingly even using my not that powerful laptop excel ran the command on over half a million lines of data in under 15 seconds.