PV Sizing Model anyone?

[Visti]

I'm wondering if anyone has any excel model on sizing PVs? Particularly one that includes the annual cycle from month to month?

 

I'm certain of the main variables that need to be considered (solar fall at geographical location, orientation to south, pitch, m2 of panels etc...) yet there's nothing via google that doesn't mean starting from first principles! 

 

Asking as we're looking to supply adequate power to our energy demands (below) and exploring non-conventional options like Sunamp! (£/yr is for a conventional gas boiler+cylinder which we're using as a baseline).

[Jeremy Harris]

Have you looked at the data available from PVGIS?  It tends to be very accurate, certainly within about 5% or so, in my experience.  The site is here: http://re.jrc.ec.europa.eu/pvgis/apps4/pvest.php#

[Visti]

Hot dang, that was quick and spot on! Never fail to disappoint @JSHarris 

 

 

That is a very useful source... it even gives a horizon outline:

 

[MikeSharp01]

It is a great resource - will be interesting to see how long the UK data remains upto date after March next year.