Solar Performance Spreadsheet - Analysis and data sharing

Thanks Buillit👍️

The more I look at this document the more useful I think this resource can be for people to contrast and compare their systems. In particular the first section where it has all the details of everyone's systems

What I think though is for people should to do their own analysis on this data by downloading the google sheet to excel and then you can manipulate and interrogate the data without the risk of messing things up by mistake.

This google sheet is only the data repository for people so they can copy the data out. Everybody wants to compare to systems similar to theirs such as geographical location aspect etc etc. and is very bespoke to everyone.

Here is a quick graph I did in excel where I took systems about 0.5 kWp either side of my 6.1 system.

I am sure over the next few weeks people will be posting some interesting graphs based on other metrics such as the difference in performance due to orientation. (might have a bit of work putting the orientation data into a structure that can be analyzed though...🤔😁)

Personally I think that the overwhelming message on all the relevant pages here is, regardless of who does your quote, post the details for all to review.

That's why I don't see an issue posting supplier info.

I've widely recommended the EnnisKillen Boys. I don't work for them and I don't have any vested interest in them getting business. But even if I was, would it matter? People are going to post details of their quotes anyway and others here will dissect them. If the quotes don't hold up to scrutiny then they won't get the business regardless of my recommendation.

Anyway, this has been done to death in the stickied thread and since the Mods apparently no longer cover here it's a moot point.

Good work on the spreadsheet!

Is that not a typo, I thought Champions system was 3.7KWp.

I would say I'll crack 13MWh this year with the extra generation in Jan/Feb/Mar plus a higher export cap in Summer. The reality of the situation is that if you up your kWp, unless you buy more expensive battery storage which hurts your return timescale, you're going to be exporting more and also hitting the 6kW export limit as well, effectively hamstringing your total production. You can really see this happen to me in May/Jun/Jul/Aug, easily a couple MWh missed out on purely down to this (and I have an EV). Four months of the year I average > 50kWh per day, half of that will be used by my normal daily usage, 20kWh into the battery inc losses, leaving change of 5kWh, every day. There's nowhere for the energy to go, if you're driving an EV enough every day to use that up it won't be home during peak solar hours!

Doing same already, only makes sense if you already had a decent GPU before the big price hikes happened a year ago.

"All we need is @mp3guy to come and blow me out of the water."

Oh Jaysus!!!

No it's a 2.7kWp system.

I'm a little confused, in the monthly production thread going back over the summer months, champion had it listed as a 3.6khp system, I noted that because I kept a close eye on systems that were close in size to my system (2.5)like alkers, dennismc and raytaxi.Maybe champion can clarify.

I'm not sure that we should be letting it be used on the FB group.

Why should installers have access to the data?

I joined the FB group and tried find the link but failed. I'm not sure it's a big worry,bookface algorithm will prevent it getting popular lol

Can someone make this a sticky thread?

Have updated my data there for the year.

Intersting spreadsheet, particularly cost per kWp installed and kWh per kWp

I actually think the statistics aren't fine grained enough to derive any useful conclusions, all they do is cloud the nuances of each system.

When you aggregate up like this you miss out on important aspects of each install - Is there a battery included in those prices? Is there a warranty? What types of panels? Do they have optimisers? Was it a DIY/self purchased install? Any extra electrical work required? How much shade does this individual have to deal with? And of course is it North Donegal up in the mountains by the sea full of fog or in the sunny south east?

@bullit_dodger beat me to it.

Given each install has so many different variables as it is - location, orientation, roof slope, different panel brands and kWp. I'm not sure how you could work out if one model of solis is worse better than another or any other brand.

Didn't watch the YouTube videos yet but he has an advantage in that he's changing 2-3 variables only - inverter, time of year and weather!

There is or was a company in Netherlands I think who covered their roof with different brands of panels so they could compare how each performed under almost identical conditions. Cant find link to it. Not sure if they did similar investigation of inverters. Similarly there is a long running battery test in Australia https://batterytestcentre.com.au/

Someone moved the new users from the top to the bottom on the 2021 basic production tab and now some of the production figures are misaligned. For example, my production is now in graememk(dad)'s row. I won't change anything until we figure out what's going on and can revert safely.