Solar Performance Spreadsheet - Analysis and data sharing

Thanks, I just managed to open it in the sheets app and requested access that way.

I was thinking of the admin involved with the Google sheets and knocked up a simple (very simple) website that might be able to help us. It can be found at the link below. The site will allow people to register themselves and should stop any issues with people messing up other peoples data.

This is if all involved agree this is a good idea!

I am not a web developer so the site is crude at best. However, I have no problem letting people jump on and change/amend as they see fit.

At this stage it is in it's early "beta" and if people are happy to move to this type of site it would be great to get some testers first. If we're happy we can move the Sheets data over and then add some more funcionality (charts, reports etc).

I have ideas to add EV data here too and maybe some sort of API. It is all premised on allowing people see our data (the site doesn't hold anything other than a login session cookie and your email address - but I can expand on that later if any interest).

I don't want to step on anyone's toes so please let me know if you guys would prefer to keep the Google Sheets.

The site is at https://www.pvstats.eu . You will need a valid email address to register (check your SPAM folder).

Hey Chris. Thanks for taking a look at this. I think your email address is showing because you picked the username to be the same as your email address. You can make your username just "IrishCris" and then this way your email address won't show. Let me know if you want me to change your username to say, "irishcrhis". That way your email won't be displayed to anyone else.

Just a quick update. I see a few people attempted to login to the site but didn't have their account setup first.

To setup an account, first for to https://www.pvstats.eu/register.pl. You need to make up a new username (it can't be your email address) and enter a valid email address below with a password.

Once registered you will get an email sent to the address you entered. You will need to click on the link within that email to activate your account. Once activated you can then login with your newly created username and password

The first page you will see is the main page, which shows this year's production values and the user who owns them.

At the top, you can click back to last year, to see how that looked.

If you click on "My PV Data" on the left, you will be brought to your own production details

This will default to this year but you can add other years (last year, for example) by clicking the "add new year" link

Once you select a year to add you will then be able to fill out those details.

The "My Installation info" allows you to enter your PV setup, as below. You can add/edit the details on this page. Anything you enter here will be visible to when someone clicks on the "Installation Info" page. Although they will not be able to edit any of your information

Please let me know if any runs into any problems!

Thanks, I have fixed up the spelling!

Yes, graphs are on the way. They are a bit of a pain when trying to make them look OK on mobile devices but no problem on bigger screens!

Actually you can copy and paste the tables into excel easy so no need to write a tool or script to do this.👍️

Hey - I am adding a chart or two to the site. Would be good get last years data entered, if you have any. If you don't mind, I can manually move last years data from the Google sheets. Just let me know.

Also, would be good to get the word out a bit, the more users we have the better - and more useful - the data becomes.

Uploaded all my stats! Is probably only time i'll be top of the leader board 😃 before all you lads with 8+ kWp South facing arrays move to the top !!

Fair play, I'm well impressed with what you've put together! Out of curiosity, what is the site built on - and is it costing much to run?

I added my details. There's a bug when you click someone's profile, it shows the pre and post install BER to be the same value.

The kwh/kwp table is very interesting and it will be very interesting to see if it changes much from year to year. I have a modest Solar thermal install and I have monitored its output vs the solar radiation which I get from "yesterdays weather" in met eireann over the past 11 years and its remarkably how consistent the solar radiation and the solar output is, they both only vary by ~ 5% from year to year, the solar radiation (Roches Point, Cork) is 1050kwh/m2/annum. (+/- 5%).

The average kwh/kwp of the first 10 in the above table is 77.7 kwh/kwp/month = 932.4 kwh/kwp/annum. If one assumes a average solar radiation of 1050kwh/m2/annum then this will give the following PV panel efficiencies.

5M2/kwp, 932.4/(5*1050)/100 = 17.76%

5.5M2/kwp, 932.4/(5.5*1050)/100 = 16.15%

6M2/kwp, 932.4/(6.0*1050)/100 = 14.80%

6.5M2/kwp, 932.4/(6.5*1050)/100 = 13.66%

Do any other locations give info like this?

http://tramoreweathercam.com/weather/trends.htm

It would be nice if one had something like the Tramore location's live data as one can/could then monitor the "instant"panel efficiency at different solar inputs, whatever the panels orientation.

There seems to be a small error in the spreadsheet in the 2022 kwh generated per kwp section. - there is no formula in the cells in line 91 from feb onwards, all the lines below this have resulting errors as the formula is inconsistent and not calculating correctly.