Thank you, you've just saved me a job. The spreadsheet is precisely what I was about to create for my parents, to help them appreciate the long-term savings of adding a battery.
If adding a battery pays off, you might better first check why Energy consumption is so high. And whether you cannot shift high consumption to sunshine hours.
Thank you Gary for yet another outstanding video tutorial. I love the way you approach this topic even more than how clearly and calmly you present all your well thought out material!!
Thank you so much for taking the time to comment. Especially on this particular video. To understand what the payback might be does require some effort - and I think many people just won’t have the time/patience 👍🏻
I am just in the process of setting up a spreadsheet for exactly the same purpose. You have explained it so clearly. It would have taken me considerable time to come to the same clarity in setting up a spread sheet. Your thinking is far ahead of mine. So THANK YOU!!!!!
Oh, I don’t know if my thinking is all that much further ahead, but thanks for the compliment 😀 and I’ve very happy to have hopefully saved you some time 👍🏻
Hi Gary, thanks for sharing. You don't need the excuse for working with a spreadsheet. Over simplifying does not help a serious user who is ready to plunge a fortune into a serious investment. Cheers.
Cheers 😀 and if you like the spreadsheet, I think you’ll really like the utility that developed from that. Try it here: garydoessolar.com/utilities/dailymodellingutility/
Hi Vincent, that's very kind of you to say - thank you! It's an incredible amount of work, taking up all my free time outside of my day job, but it's comments like this that keep me going! :-)
Thanks Gary. Excellent spreadsheet and perfectly timed for me as I am currently trying to figure out my own PV + battery install. Top of my priority list is to have a system that (within reason) minimises our dependence on the grid even during the darkest winter months. That isn't to say that cost & pay-back period are completely irrelevant but they aren't my topmost priorities. However, having spoken to several local installers, most seem to want to install a 'standard' 4Kw system that doesn't exceed the 3.68 DNO 'soft ceiling'. Whilst this would comfortably cover our summer needs it wouldn't come close during the winter. We have sufficient (suitably orientated) roof space so the (relatively) marginal cost of additional panels makes sense to me.
Thanks John 👍🏻 glad I’ve been able to help you out. Worth considering SolarEdge (and maybe other inverter manufacturers) that can handle significant oversizing (e.g. an array twice that of the inverter)…
Love the presentation style. As sums make me want go and lie down in a dark room with a G&T this video was quite a tonic. The variability of the unknowns such as the opportunity cost of the initial outlay and the impact of any future gvt 'inducements ' do shift the line on the graph considerably. Pfftt!! Keep up the good work...
As a data analyst I have to say you have some really good charts here and very well explained thank you as I have just started my solar journey with a small 3.2km system and no battery.
Thanks Philip - I'm no data scientist, so that's great to hear! :-) Great that you've taken the jump into solar, and I can see you extending your system to a battery very soon! By the way, worth looking at Octopus Energy as they have some very good export rates now (15p per kWh)!
Your presentations with a mix of technical and common sense information are very informative and easy to follow, therefore giving us guidance when deciding what kind of solar investment is good for each of us. I am really glad that your channel found me. Thank you
Very well done. I am currently evaluating solar array for my 68 sqm flat roof with two options (centralize with Fronius string inverter and decentralize with Enphase IQ7 or IQ8). Your spreadsheet is just perfect, just have to switch to €.. Watching many of your videos. very interesting.
That's great to hear - glad to have been of some help to you in this! Take a look at my most recent video (on microinverters) - could certainly be an good option for you :-)
Again brilliant Gary and confirms much of what I thought, but clearly and with a hood simple spreadsheet. I looked at the flux video and this version gives a good approach to applying corrections to the spreadsheet for the solar generation in winter and spring/autumn periods to give a reasonable estimate. Keep up the great work.
Thanks John - I really appreciate the feedback :-) Just to let you know, I've nearly finished a web app utility for the same, which allows different solar models depending on the time of year. Here is a link to an early release if you'd like to try: garydoessolar.com/utilities/dailymodellingutility/
This is the most wondefully helpful channel, not least because you teach from basic first principles and build from there. So much of what you cover is actually applicable to many areas beyond the headline topic. Despite interest in this area for years I feel so much better informed. A properly Scottish approach! Will be using your code when we join Octopus in coming weeks.
Thank you very much for these kind words. It really helps as I get some haters from time to time. I just don't know why people could have a problem with someone who's spending 100s of hours trying to educate everyone about a really important topic, but there you are! I'm very happy to have in a small way, and thank you for thinking of me wrt using my referral code - it all helps! :-) All the best for this year!
Oh My Goodness. That spreadsheet is absolutely brilliant. I am ashamed that I didn't think to analyse this issue in the same way, but you have nailed it! Thank you so much Gary for all your effort and for sharing it with us lesser minded individuals. I am having so much fun playing around with this fabulous tool! I also appreciate you answering my question on your last video. It seems that even Ecobubl has now announced that they are not currently taking any more solar PV/battery enquiries, so well done for getting your foot in the door!
Hi Ben, so great to hear you're getting a lot of value from the spreadsheet :-) and sorry about the situation with Ecobubl - it's just so crazy these days with the demand for solar. I hope you're able to find a good installer before long!
Absolutely love the breakdown on systems and costs. Oh my, that is one impressive bill to cap electricity prices! that has to be several hundred million pounds...... Having a look at the differences between France and Germany on power mix and $/kW: France has about 10% green, 70% Nuclear versus Germany about 29% green, 12% Nuclear; French domestic electricity prices are half that of Germany; Germany also has a very high retail $/kW versus wholesale price (I think this means Domestic vs Manufacturing) France gets about three billion euros per year from electricity exports. Further to this, France has very low Greenhouse gas emissions for electricity generation, but Germany produces more Greenhouse gases than any other EU country. So, I know what I'd like my electricity to cost. Going 'green' has hidden costs in the building and maintenance of your electricity grid as well. At night, nuclear and hydro keep working, but solar and wind are fickle beasts.
Hi there - thanks for the kind words. Yeah, the UK is is a bad place at the moment with regard to energy policy. The estimates are it will cost in the order of £150bn over the next 2 years just too subsidise the increased energy costs for consumers. I'll be making a video on all of this soon, including coverage of nuclear and hydro... :-)
Hey Gary, you are brilliant! From all the videos I’ve watched you are the most informative and well spoken person. Congratulations on your success. Want to ask you a question maybe asking you the same every day. Can you help me out decide what to choose as materials and equipment, and who to use as installer? Talking about house in Hornchurch/ London. Very best of luck, Regards Biser
Hi Biser, thanks for the lovely words! It's a lot of work making these videos, but comments like yours make it all worthwhile :-) Now, your question is a good one - and there is no single answer as it very much depends on your property, electricity usage, if you have (or intend to have) an EV etc. Unfortunately, l'm not really in a position to provide such individual advice, (not least because of potential liability issues - even if that advice is given free - such is the world today). You're best to speak directly to an installer about that, or post a comment onto a solar forum (e.g. this one in the UK: facebook.com/groups/2197329430289466) Good luck with your solar journey!
Hi Rob, thanks very much! You're far too kind, but I'll take the praise!! It's really hard work making the videos but comments like this, give me a warm feeling inside! I'll keep going :-)
A super helpful video again, I wish I'd found and watched this before playing with your lovely spreadsheet, as it took me a little while to figure out what to change to cater for my E/W facing roof :) Again this is great and really helpful work, thank you so much!
Hi Chris, you're most welcome. Yeah, spreadsheets are great but the modelling is getting a little too complex now, so I made a web utility instead. See what you think:
@@GaryDoesSolar Thanks for the reminder. I'll try to have a go with that over the weekend, hopefully get similar results to my own, but no don't better 😊👍
Love me a good spreadsheet. If the formulas are not too difficult, you could put them into a google sheet and share them that way. Single link will always get the latest one, you would just need to version whatever the latest is in the sheet itself
@@GaryDoesSolar Yes, Gary, and please let it "share to whoever has the link" and set it for "only viewers". @Bjørn Neyland also has available a Google Sheet with his test-drive results.
Thanks Gary for an excellent summary of how the use of solar could significantly reduce the cost of electricity for home users. I have a 6.6 kWh solar system and have been considering adding at least a 10 kWh battery to it, but the cost in Australia is still too high. I estimate the ROI would take about 10 years (the warranty period for the battery).
Hi David, thank you for the very nice feedback :-) Yeah, battery costs have increased quite a bit over the last 2 years, but with EV demand increasing, I'm expecting economies of scale, and of course newer battery technologies, to start driving those prices down again. Hopefully, in the next year or two, the ROI will drop quite a bit! Let's see...
Thanks Gary for the spreadsheet. Please could you also put a model for winter solar production?, Also, it would be quite useful to include a model for winter where we could charge battery using off-peak tariff
You're welcome. Now, the model for winter is basically the same as summer, but with less hours of sun. It would still go from 0 to 1. I'm quite busy with work at the moment, but I'll try to add this at some point.
I've just had a PV and battery system installed. 12kWp PV with 7 kWh battery storage. Just ordered an additional 3.5kWh battery for the system. Was interested in the effect on the payback period with the 3rd battery. I will feed data into your spreadsheet. Thanks for the excellent videos.
Hi Harry, thanks for the kind words - and that's a very good sized system you have there! Worth looking at Octopus Energy if you're not already with them, given they've just raised export price to 15p per kWh :-)
*** For those of you interested in using the spreadsheet, I've created a much easier to use utility here: garydoessolar.com/utilities/dailymodellingutility/ - see what you think! 😃 The more astute of you will see that in cell K10 of the "Solar with Battery" sheet is '0' rather than a formula. This looks like an error, but actually, it's a little trick - I'll explain: Rather than managing the battery level from hour 0 until hour 23, I recognised that in real-life there would be charge in the battery at hour 23 that could be used the next day (hour 0 and so on) so I essentially loop from hour 23 back to zero. But in order to void the circular reference, I intentionally zero-out the battery charge at hour 6 - just before the sun comes up (the value of cell K10 is deliberately set to 0. IMPORTANT: The side effect is that if there was still charge in the battery at hour 5, this just gets lost. Trying to model non-trivial real-world scenarios in a spreadsheet is a constraining experience! 🙂
Loving all 5 videos so far, thank you. Do you have any plans to release a revised version of your spreadsheet which can track both solar generation & battery storage, but also combining them with variable electric tariffs to charge the battery off-peak if your solar array isn't very large.
Great video. I did similar myself but yours has some extra features which are better than mine. I’m going to compare more closely. Thanks for your videos. They are really informative. Wish i was able to see before I bought my system.
You're most welcome! Yeah, I wish I'd got into solar years ago - but there was no-one round to tell me! Lol Now, my utility won't be perfect - attempting to model real-world systems to any kind of high-degree accuracy is a potential road to insanity - but hopefully it's good enough for folks to make informed decisions.
@@GaryDoesSolar agreed. I found it a real can of worms and hard to get quality information before I got mine installed. Luckily I think I’m alright but I think going again I’d have gone for even more panels. Plus a bigger inverter even if I had to wait for DNO
You are the best source of impartial advice out there on the web for newbies like me. Love the Flux web calculator, with a 5 kWp array and a 10 kW battery system it's suggesting an annual income of >£1500 pa !!
Hi Ray, thanks for the kind words. Re. the Flux calculator, remember that not every day will be sunny, and as you head towards the winter later in the year, your production will drop (the "Maximum Array Output" field is not your array size, but the maximum output you could expect for the time of year (e.g. winter will be say 20% of summer) - but yeah, you should still be able to make a nice profit :-)
Thanks for the great video and web calculator Gary. It would be interesting to see what happens as you add extra batteries to an existing setup - this is the situation I'm in with a PV installed in 2016, 3.6 Kwh DC battery/inverter in 2017 on FIT and now I'm considering adding a MyEnergi Libbi (I already have a Zappi and Eddi) for addition battery storage.
Thanks for the great feedback, Cliff. You raise a really good question, and I'm not sure the answer in fact. If the second battery was made by the same manufacturer and simply an extension of the DC-coupled connection, then I'd expect the inverter to manage it without problem. It's not likely to be possible to mix battery manufacturers in a DC-coupled setup, and if the new battery is AC-coupled, there might be a battle of wills between the two batteries... Maybe others can comment...
Just watched all your content Gary - Absolutely brilliant! Is there any chance of a version of your spreadsheet in an older version of Excel or Google sheets, please?
Thanks Rob - it’s great to get feedback like this. Now, unfortunately I don’t have a lot of time, but this might help you: support.google.com/docs/answer/9331167?hl=en-GB
Hi Gary... fantastic job on explaining the intricacies of the variables related to solar systems. I noticed a grammatical error in your spreadsheet and was thinking about letting you know - but then when you mention "if you see any errors in my spreadsheet, let me know..." so here it is: you have a paragraph of "disclaimers" on the left hand side. You actually have the word "errors" back-to-back, so you can remove one of those words and all will be well. Greg (garden grove, CA)
Excellent clear and concise and I'll use your wisdom go calculate my costs for my solar and battery journey. Thanks your effort and knowledge is greatly appreciated.
Great video again Gary, very informative! Have you had much feedback on solar tiles in UK; I have a new build and thinking of using solar tiles. Nulok have a system I’m considering. Thanks…
Hi Andrew - thanks! No, as yet I’ve not looked into that technology in any detail. Suffice to say though, it is certainly worth considering for a new roof or roof replacement. All the best with whatever approach you decide to take! 👍🏻
Cheers Andre - hope it's useful to you. Now although I used a spreadsheet in that video, I since developed a web app, which is much easier to use. Enjoy! garydoessolar.com/utilities/dailymodellingutility/
Thanks for the great video! Could you explain why it is good/okay to have a maximum inverter output that is smaller than the maximum array output? That means you are clipping in the hours with most sun, so not using all the potential of your panels…
Hi Maxim, you're most welcome about the video - and hopefully you'll like some of my other videos too :-) Now "array-oversizing" as it is termed, has many benefits. This article from SolarEdge is worth reading as it explains them in detail: www.solaredge.com/uk/solaredge-blog/oversizing
Great video again and thanks a lot for the spreadsheet. I tweaked mine a bit to include the losses across different seasons and come up with a yearly figure as well as adding a bit to include standing charge.
@@GaryDoesSolar how did you get the figure for the solar model 0>1 numbers? I thought maybe from the Europa map thing on your other video but can’t get figures that make sense
@@GaryDoesSolar do you have a link at all how to do that, or are your figures kinda ok anyway? I’m in Scotland. Can’t see anything come up doing a search
I can't find my notes where I constructed the model, but it should not matter too much that you're in Scotland - remember the '1' in the model will always be the maximum output of your array. And the sun will always rise and fall creating the same kind of bell curve 👍
This panel can put out close to 100 watts ruclips.net/user/postUgkxOqI2yqX0XVrhR2BMJciTWrHJpG8FhJyg when positioned in the appropriate southernly direction, tilted to the optimal angle for your latitude/date, and connected to a higher capacity device than a 500. The built in kickstand angle is a fixed at 50 degrees. Up to 20% more power can be output by selecting the actual date and latitude optimal angle.The 500 will only input 3.5A maximum at 18 volts for 63 watts. Some of the excess power from the panel can be fed into a USB battery bank, charged directly from the panel while also charging a 500. This will allow you to harvest as much as 63 + 15 = 78 watts.If this panel is used to charge a larger device, such as the power station, then its full output potential can be realized.
Update as of June 2023, my unit rate is currently 48.49 pence per KWH. So on your graph ( at 7 minutes) more like line number one. Thats partly why I am watching this.
Yeah, energy prices have been a bit crazy last couple of years, but it seems they’re starting to return to “normal” levels over the next year or so. I say normal, but the the UK that still means twice the price they were say 4 years ago!
I love your clear presentation style, calm voice and tidy diagrams. You should be a university lecturer! ;-) Interesting that your spreadsheet is focused on hourly consumption. I get that it's necessary because of solar hours/day and day/night cost, but the monthly variations are massive when it comes to solar generation and winter energy consumption. e.g. 6x as much from solar during summer months compared to December, and (for me) 2.5x electricity consumption in winter compared to summer. Maybe a more zoomed-out spreadsheet that looks at months instead of days to account for such seasonal differences and provide overall annual cost/saving statistics? Your energy bill shows how much you consume during the day and night rate (separately) so with some assumptions on usage an annual estimate could be obtained.
Thanks Gary - it’s great to get feedback like this! 😀 I don’t think the good university lecturers get paid enough, and maybe global video platforms like RUclips are the way forward for education - not replacing face to face interaction, but providing a means for those who can articulate knowledge well to get paid well as a result. Now, you raise a good point about the spreadsheet - it’s focussed on the hours of the day because that’s where the interactions between power consumption, solar generation and inverter/battery capability can make or break your savings potential. That said, I am indeed working on something wider than that - more on this soon 😎
Hey Gary, echo the sentiments of the other comments, great video as always, I'm learning so much from watching your videos. I just wondered where the Solar model comes from and does that need to be adjusted, I watch your other video featuring the PVGIS tool, but I can't see how you've translated the data it provides for use on the spreadsheet here.
Hi Rob, so the solar model in the free utility is a very basic bell curve that I coded up - it's a normalised profile for a South facing property in the UK. It's likely good enough for those who want to get a rough idea on how their planned system might perform during the day, but for those who want a more detailed view, then the Pro Edition of the tool is a far better option. I've been developing that a lot lately, and there are now two solar models: - An improved simulated model that takes into account the geographical location and orientations of up to there arrays - and also the number of sun hours in summer and winter - Data from the EU PVGIS system (re.jrc.ec.europa.eu/pvg_tools/en/)
Thanks Gary, first time i have come across your videos. The most informative videos i have seen on the subject so well done, and considering you started in April this year and have only done 3 videos, you have done brilliantly to get 4.8K subscribers. Just goes to show you are hitting the right level of engaging content. Thanks for posting. Have subbed and am keen to watch your upcoming content. You don’t have to convince me though of the need for solar, i already have 8KW installed - 1 4kw array facing east and one 4kw facing south. Generated 991kwh in August and was gutted to miss 1 megawatt hour by 9KW. Tesla battery beings installed soon. Cheers John
Hi John, thanks for the kind words. Yeah, I'm really happy to be getting really good traction in such a short space of time :-) I set out to share the knowledge I'd learned through my own research into solar, to save time for everybody else, and I thought that if I could recover the costs for the recording equipment etc., then great! You're ahead of the game from me. I was due to have my installation back in August, but I had problems with the company I'd contracted with, so had to start again. I should have 7.6kWp in place around the end of the year (so not too much less than you're own installation). Wow - pretty much 1MWh in a month is just amazing! Hopefully you're with Octopus Energy so you can benefit from their recent 15p/kWh export announcement :-) Good luck with the Powerwall install - I guess you'll have been waiting for that for a while!
@@GaryDoesSolar Hi Gary, yes i am with octopus and have been for a couple of years now with octopus go. Unfortunately, well not really, my original array (the 4kw west facing was fitted back in 2008 by the previous owners) and so i have a fit payment of £1500 per year on average. This was great for the first two years as our electricity bill was £1200 a year so we were up around £300. However that ended with the price rise which prompted me to add another 4kw in July this year and order the battery at the same time to get zero VAT on the battery. Big backlog so not being fitted until mid december. Still it has a really positive impact on our monthly bills, and adding a zappi to replace our podpoint has really helped to top up my EV rather than sending stupid amounts of export to the grid. Most days my car soakes up any export. for august I idid 1485 miles in my EV of which only £6.69 was paid in overnight charging giving me a cost of half a pence per mile. This would not have been possible with the podpoint which i regret getting as i wasted my govt grant getting it only the replace it six months later with the zappi at a cost of £1,000. Because i have a fit payment, i cannot sign up to another export scheme without giving up my FIT so i am in the position at the moment that my newest array attracts no payment for export. That said, my battery and car should resolve any export once fitted, so i am not too bothered. The main thing i want is to be off grid for as much of the year as possible barring the standing charge. I don’t have gas or oil, so my electric bill covers all my house, travel and mowing costs. I have a ride on electric zero turn mower to mow our field with is just shy of 2 acres and would otherwise cost me £100 a time to have it mowed professionally, so i top up the batteries when the sun is out and charge it for free. Sorry long winded response, but renewables definitely the way to go.
Hi John, it sounds like you're well on top of the situation. Loving the fact you've got an electric ride-on mover! :-) Yeah, the FiT scheme feels like an albatross on one hand, because you can't change anything, but you can't knock £1,500 a year! Thanks for the word up on PodPoint - I hate buying twice on anything.And I agree, I think we're all only get getting started on our renewable journeys - the world is changing (finally) and governments are finally waking up to that (even if in the UK, ministers are promoting fracking once more, likely mainly to secure future personal income post parliament)...
Ah now - it does look like an error, but actually isn't! I'll explain... I wanted the residual battery charge at 11pm to be used the following morning, so wrapped it around in the spreadsheet. Now, that immediately caused a "circular reference" error, as expected, so I decided to break the circle by zeroing out any battery charge left just before the sun came up. Not ideal, but we're kind of reaching the limit of what a spreadsheet can do! :-) Thanks for spotting though!
Thank you Gary for a very informative video - I have been thinking about solar for a while but this just pushed me to make my decision to go for it - I was wondering if you had any recommendations on some good solar installers in UK please?
You’re very welcome, thanks for letting me know. The only installer recommendation I can make is EcoBubl - they did a fantastic job with my own installation earlier this year 😀 They’re based near Basingstoke and I have a video about that on my Patreon. Good luck with your solar journey!
Admittedly late to the party I noticed no mention of Feed in tariff. Like you I have left OVO in favour of Octopus but do not know what to ask for to take advantage of the best arrangement for solar, EV charging and perhaps using the car battery for household. I am recommending your vids to assist with my chums interest in an array but could not understand the significance of the Fit having been withdrawn. Is there a way of paying you a consultation fee? I did watch the GO, intelligent, and flux video and need to re watch. Thanks for making us so much better informed. B
That's very kind of you to share my videos with your friends. I'm very happy that you're finding my videos educational. It's just a hobby for me (my day job is in the mobile industry) so I don't get any time outside of that for any consulting etc, but I can recommend some online forums where you can ask questions etc. and get answers from the experts there. One such is this one: facebook.com/groups/2197329430289466
Hi Gary. many thanks for your videos which are very clear and have aided in building my understanding of solar / battery solutions; I feel better able to assess alternatives. One aspect I'm left confused about is charging and discharging losses, these form important assumptions in your spreadsheet. Taking a couple of examples the GivEnergy battery is DC, looking at the inverter specs I read 6% losses in both the charging and discharging process? Tesla Powerwall is AC coupled with 10% round trip efficiency which I read to be charging losses? These numbers are significantly different to the assumptions you suggest in the spreadsheet. What have I got wrong? Thank you
Hi Adrian, great to hear that my videos are helping you - thanks! :-) Now, on the charge/discharge losses in the spreadsheet, looking at the Tesla Powerwall first, round trip losses of 10% would equate to around 3% loss each AC-DC-AC conversion (remember the PW is AC-coupled, so 3 conversions). Do you have a link for the GivEnergy losses? I can't seem to find anything on the web... thanks.
Incredible video your information is amazing thanks for figuring this out and sharing it with us. I'm definitely going to setup a solar array at the house now.
Thanks for the video. Is it possible to add dual tariff charging to the solar + battery spreadsheet please? My solar isn't enough to fully charge the battery so I will be topping up during the off-peak hours.
Hi Paul, my pleasure. Now, I did think about just that but thought it might be getting too complicated for one video. If I get time, I'll add an additional tab sheet into the file.
HI great Video and Spread sheet . Two questions: in the spreadsheet you use solar model data . Where did it come form and which month of the year is it or average. As Would like to model for each month of the year. Second on the battery sheet the price calci=ulated does not seem right as it seem it the cost are only based on the charging at night and regardless of the size of the battery it does not seem to charge for electri after it has depleted the battery! Hope you understand the above Simon
Hi Simon, thanks for the kind words. To answer your questions: 1. The solar model was taken from a sample of a south facing array near Oxford in the UK during summer. If modelling for other months of the year, it will be the same bell curve shape, but the sunrise and sunset times will be closer together. 2. Yes, the "Just Battery" sheet is purely battery and no solar, to allow you to see the effect of time of use rates. There is the opportunity for someone to combine it all into one sheet, but I didn't have time.
Thanks Gary. A really well put together presentation which I enjoyed (again!). Having now used your spreadsheet, solar with battery tab, for an upcoming installation I can see that a larger battery than what Ive been specified would lower my import costs. However what I dont know is what month or season the solar model generation numbers are based upon. If for example they are based upon the summer season then maybe a larger battery wouldnt improve the savings significantly as during the winter I might struggle to fully charge the larger battery. Are you able to clarify the month or season for those values? Many thanks and I look forward to your future videos. Ive also shared them with friends and family who are also considering the solar route.
Hi Ron, thanks for the great feedback! :-) Now, you raise an important point! The sun model I used was a summer one! Which means, in winter the number of hours the sun is out will be significantly reduced (the model is normalised so the level of solar depends only on the maximum output of the array, which you'll be reducing for winter (e.g. to 30% of summer) anyway. This can of course be fixed by using separate solar modals for each season (or even each month) but the problem is, that we're really pushing the boundaries of a spreadsheet now. The good news is that I'm working to solve this... More soon... :-) Thanks for highlighting - I really appreciate it!
Thanks for these excellent contributions Gary. Similar to one of the other comments previously, would it be possible, even if you can advise here what adjustments are necessary to calculate the solar generation for other times of the year? Is it a case of reducing the max array output by a given percentage to reflect what the average daily output for that time of year? Thanks in advance.
Hi Karl, thanks for taking the time to comment - I really appreciate the feedback. Thank you also for the kind words. Yeah, when trying to model anything real-world, the more realistic you want it to be, the more exponentially complex that model becomes! So, I thought to myself, let's just have a single solar model to cover all seasons (even though we know that the sun's hours reduce drastically in the winter) and allow the user to turn down the percentage for different seasons, according the the monthly chart in the video for the user's location. That's probably good enough to get a reasonable approximation, I felt. That said, if you go to the download link mentioned in the video and the video description, you'll see that some viewers have improved on my original spreadsheet :-) Hope that information helps!
Gary - great, great videos. Looks like, through your links, I'm going to forget all the faffing about with optimisers etc re shading. I'm getting a east/west array with more on the east than West - and was going to go 'for as much as I can get on' but your spread sheet shows my return on investment would be much slower on the step up from 4to 8 than from 0 to 4 so I think I will put more in to my batterys. Just using your spread sheet and am bit of a spread sheet novice but presume I would just add my overnight EV charging - 2 cars - typically 20-30kWh a night off peak, into those first 4 hours on the spread sheet - eg 7kWh per hour? Also assuming one of my EV's is at home for at least 6 of a day (ie between school runs) I should increase my 'home battery' to take account of that? I think it would also pretty much make my export zero. And just a thought on the season sheet. I wonder whether the hours of production are short in the summer months - I would have thought 5-6 to 8-9 might a better spread?? Cappuccino or Latte? Actually I suspect you are an Americano man.
Hi Ben, thanks for the kind words. Now, when you get your solar quotes, they should be providing an estimated annual generation figure. Worth comparing that to the spreadsheet. Although I've taken a lot of care over the model, there's always a chance I've made a mistake. Worth also checking that you've got the latest version (as I've been correcting minor errors) - and some other viewers have improved on what I've done as well. On the panels or batteries question, yeah - I'm definitely in the camp of get as much up there as you can. Battery prices will come down over time, so you could always buy one now and add to it later. Re. the EV charging, a 4-hour charging time slot is not a lot of time really, especially when you take into account the charge rate of your battery. even at a charge rate of say 4kW, that's only 16kWh compared to what your EVs actually need (maybe 5-10 times as much!) So, again, having more generation on your roof will better help with the EV charging, in my view. You're totally right about the solar model in the winter. The hours are much shorter, and so a one-size-fits-all model isn't perfect, but it likely doesn't change the outcome too much. Easily checked by zeroing out some of the hours at the start and end of the day and seeing what effect that has on the bottom line... Lattes all the way, Ben - thank you for buying me a couple! Very much appreciated :-) All the best!
Loved your videos, taking the plunge into solar PV system myself, i had a question. I have two battery options, GivEnergy that has a 3.6KWH output and FOX ESS AIO that has a 5KWH output. Which one would you recommend?
Hi Gary. Thanks for the spreadsheet which I’m finding very useful. I have a question. By using 1 as the max in the solar model at midday, doesn’t that assume that every single day in the Summer we are assuming the panels will be outputting the highest possible energy for a given time of day. Of course, that will not be the case as most days in the summer are cloudy and the panels are far from outputting their max. Even when reducing the solar model to 70% for autumn/spring and 30% for winter, I’m getting double the output in your model compared to others. Can you help me understand this better please 👍. Thanks for your time.
You’re most welcome 🙏 Now, since making that video I quickly got to the limits of the spreadsheet. So I developed a web app utility, which is way more powerful and can model solar generation profiles for different types of day across any month of the year. Here is the link: garydoessolar.com/utilities/dailymodellingutility/
@jock I have watched many of your videos Gary and subscribed. This one is particularly fascinating. I am convinced of the benefits of solar and would love to install a system but I live in the SW of France and the reviews of the larger companies here make such frightening reading that I am greatly discouraged. I don't suppose there is a way to reliably assess or evaluate an installer, or has one just has to take a leap in the dark.
Thanks John! Yeah, trying to find a reputable installer and good quality, reliable equipment is not straight-forward. I would suggest you look around your neighbourhood and chat with those who already have installations to see what their experience has been like - and whether they would recommend their installer... Good luck! :-)
Gary, this is simply the best explanation I've seen of calculating the ROI and payback. Subscribed to your channel on the back for this. Thanks for taking the time to produce such an easy to follow video. We have recently invested in the solar and battery and are seeing the benefits but being able to verify that with the guide you have put together is good. And who doesn't love a good spreadsheet?!
Hi Martyn, that's very kind of you to say - thank you! And you know that they say the world's largest spreader of disinformation is Microsoft Excel!! :-) Hope you're able to get payback before long!
@@GaryDoesSolar I'm not too bother about payback personally. One can get too obsessive about these things. We saved up hard for this system and it was simple. Get almost zero interest in the back or put on the roof and get a lot more return, which we are doing right now.
Gary thank you very much indeed. Your thorough and really helpful spreadsheeting has really chrystalised what I instinctively felt were the necessary considerations. I really like the Octopus approach to smoothing out peaks of demand locally. I have the real estate for a sizeable array, and I'm happy to design and fit the entire system for final inspection and connection by an approved sparkie but I don't think our current energy rules will allow that sensible approach. So instead I've approached the local Octopus approved fitters but they are quoting eyewatering costs (£27k) and of course throwing micro inverters/optimisers at every panel for my unshaded roof. I'm considering buying and fitting the panels and battery and then asking Octopus (installers) to come in and finish it... it would be great if you had any advice in this area. In the meantime thank you again from all of us!
It is my pleasure to help you out - thanks for taking the time to comment. Wow, £27K is an eye-watering sum! I'm avoiding offering advice to people as there are liability concerns (even if the advice is given free), take a look at my latest video published today. There's more in there about optimisers and array considerations in general. Then have a listen to the podcast I was interviewed in as that might have other useful input to help with your decision-making... All the best!
Very well presented, simple and understandable. The spreadsheet is great too. If your a newb like me. I recommend watching Gary's other videos 'A beginner's Guide to Solar' and 'How to choose Solar Wisely and Avoid costly mistakes as well. Many thanks. 5*****
Very useful series of videos thus far - just what I need at this point of the solar panel installation journey, so many thanks Gary. Question on using the spreadsheet: Do the solar model or generation numbers (kWh) need to be adjusted for location (in UK) and orientation of panels or do you recommend simply using as is?
I don't know if I can help here, but here is the website Gary mentioned about getting the numbers for the orientation of the panels based on location: re.jrc.ec.europa.eu/pvg_tools/en/ And, the calculator sheet: www.garydoessolar.com/utilities/solarcalculator/index.html
Thanks Ian - very happy to have helped you out! 😀 On the solar model, this is fixed for a south facing roof in central England, and other orientations would simply skew that model slightly (but not much). The EU link can provide you with the exact solar model for any location and orientation but it’s not the easiest utility to use.
@@thrillseeker75 The solar model in the spreadsheet is very simple in fact - looking down the column, you'll see that it is 0 for when there is no sun, and 1 when the sun is at its highest, with values in between forming a bell curve. Take the solar model you downloaded and try to fit it into that normalised range across the 24-period.
Gary... excellent videos and the spreadsheet has saved me a great deal of time and effort... its made me realise that for my circumstances reducing installation size (and therefore cost) from the optimum, within reason, does not significantly impact savings. One comment on the spreadsheet... the battery discharge calculation within the battery level formula seems to reduce the figure by the discharging losses %, rather than increasing it, assuming I am understanding the meaning of discharge losses %.
Hi Kevin - great to hear the spreadsheet has been helpful. It's only when you really get into the numbers that you see things like that. Yes, I think you're right - the discharge formula seems to be wrong, and thinking about it - it's going to be a tricky one to fix! Lol I'll try to resolve this in the next version... :-)
Ok, I think I've sorted it - see version 1.02 :-) The good news is that because the default discharge loss is only 3%, it didn't affect the calculations by much at all in previous versions.
Gary... just to repeat... thanks for an excellent spreadsheet, it will help me enormously negotiate suppliers away from their "one size fits all" 4Kw with battery offering !
It is great Gary, but I am not sure if it answers the question if the battery does pay back itselves in the period given by its lifetime given in cycles.
@@GaryDoesSolar Thank you! It is really perfect that you like the exact way of work with numbers and spreedsheets which most people skip. Afterall its beneficial to everybody who has eyes to watch and open mind to understand ☺️
Hi Gary, great explanation and model. Do you have a version of the spreadsheet which includes battery storage as well as using the Octopus flux tarfiff (flux/day/peak tariffs) - I want to model charging the battery sufficiently during flux cheap period to allow maximum export during peak period while retaining sufficient battery capacity for the remainder of dark hours, and see what this does to the business case for solar byoptomising use of the Octopus flux tariff
Hi Gary, I most certainly do! And I have a video to go with it: www.garydoessolar.com/utilities/fluxcalculator/index.html You may prefer to use the web app instead of the video, which is also available on that link. Enjoy!
Good question! In fact for the spreadsheet I just used a Solar profile for a south facing roof in central England. This could of course be improved upon… 👍🏻
@@GaryDoesSolar Thanks. Probably the best video I’ve seen on payback calculation and makes my spreadsheet look very…amateur! But it is difficult - we’re on Octopus Go Faster with five hours reduced rate 20.30-1.30. But there are a lot of “what ifs” - if we move this to this time…etc. Personally I think a battery is essential. Yes you can move the dishwashing etc to during the day but if a cloud goes over you start pulling from the grid which potentially could make it more expensive than using it at off peak hours. And I think for people who can’t have solar for whatever reason but can get on Go, a large capacity battery might be a good idea, that way you know you will never pay more than the off peak rate, as long as the tariff exists and you’re careful about simultaneous appliance usage.
Steve, I haven't ever seen such a site, but would love to! The best alternative is the scientific EU site: re.jrc.ec.europa.eu/pvg_tools/en/ - they have massive databases that cover the planet but I'm not sure how you would extract the information you're looking for.
@@ipb1966 Thanks for the kinds words. Yes, there are pitfalls with just a solar solution as the sun is not guaranteed throughout a sunny day. This is where a battery comes into its own :-)
Thanks Gary - exceptional production. Really useful, as I have just had my system installed and wanted to understand the quirks of electricity production with respect to the available sunlight during winter of 22/23. The spreadsheet is fantastic and thanks for recommending Loop. Both are invaluable. I do have a question: if my solar panels are rated to deliver 5.7kwh then even on the sunniest days in winter, the maximum production is only 3.2kwh. Does this sound right or is there a problem with the installation/configuration?
Thank you for the great feedback - I'm humbled. And I'm so happy to hear the spreadsheet has been of use to you :-) Now, in relation to your question, are you saying that your array was rated (my someone) to deliver 5.7kWh on a typical winter's day? Or was that figure quoted for a summer's day? Winters are typically 10-20% of the summer generation, but it depends where you live. In any case, if your production is only looking to be half that, then it does suggest a potential issue. What I'd do in your situation is have a chat with those living nearly you with solar installations, to get a view on the percentage generation on a typical day (e.g. 4kWh on a 6kWp array - note 'h' and 'p') and see if that matches with your own generation. I would also write a post on a solar forum that you might be a member of. Provide details of your setup and also a couple of examples of the generation you're getting (ideally graph format). Then see what responses you get. Good luck!
Hi I like the spreadsheet, looking forward to a version that caters for different times of the year, one small problem in cell K10 on the Solar and Battery tab. It doesn't seem to have a formula in it and when I enter a suitably adjusted version of the formula from cell K9 it moans about circular references :(
Thanks Steve. In fact there is only that single spreadsheet. For the other times in the year, you just adjust the value of the array output as described in the video. See my pinned comment regarding the K10 cell 👍🏻
Hi, excellent intro in to the world of solar. Just one observation on the shown amount of daily generation for 5kw system (30.26 Kwh). Specifications from suppliers I have received are only stating 14Kwh?, this obviously makes a big difference to pay bay period- any guidance appreciated
Theres another reason to install solar panels and a battery wall...that is to keep the "LIGHTS ON" when the grid goes down and it will be happening more often in the future as we see more renewables coming in to service...add to that a EV and a wood fire with a "WET BACK" and a hot plat to cook on , you've got all the bases covered !!!.🤔💕🇬🇧
Solar panels installed, but the LuxPower battery system has been delayed. It's set up to benefit from Octopus flexibility, with extra Octopus friendly functions on request. I was surprised to learn that UK DNOs severely limit what you can do when there are power-cuts😞I'll be going for continuous battery output rather than power-cut only supply. The installer is only offering four sockets in a block and I'm having difficulty deciding where they should be installed for the best outcome.
Good video Gary! I have installed 6Kw of solar panels with a 5 Kw Fronius inverter and the systems works great. I've calculated the ROI and grid in and export exactly as you did. I did this in june of this Year. Although I saw your video today (Oktober 22) for the first time. Very nice to see that you did exactly the same as I did. Now I want to expand my installation with a Victron Quattro and an battery system LiFePo4 of 10 Kw. I need to expand my self made calculation with these parameters. Would be nice to compare your spreadsheet with mine. But I can't find a link to your sheet. Is is possible retracted? Anyway my compliment how you make your video's. Very clear and helpful for everyone that is interested in this technique. Greetings, Louis. Tilburg The Netherlands.
Thank you so much for taking the time to comment, Louis :-) Sounds like you're making all the right decisions! Now, the link to the calculator is in the video description, but for ease, I've reproduced here: www.garydoessolar.com/utilities/solarcalculator/ Would love to hear if my spreadsheet tallies with yours :-)
Hi Gary great series but a quick question. Current on-grid solar withe normal inverter producing a Fit output, but if you are on the max rate that is now 60p a KW. If you replace the standard on-grid inverter with a hybrid inverter does the fit production that you receive go down as you are now potentially charging batteries and not exporting this element to the grid. How does that effect the economics of on-grid and hybrid? Cheers Duncan
Hi Duncan, glad you’re enjoying the videos 👍🏻 Great that you’re on a great FiT rate too! I think if you make any changes to your installation, including a change to your inverter, this would likely invalidate your FiT payments. Best to check…
Hi Gary, I am using your v1.01 spreadsheet and I am unsure if you have errors on K10 to K14 cells on your solar with battery tab. Using my consumption figures I have a battery level that goes from 12.10 (K9) to 0.00 on K10 for a consumption of 0.092 kWh value. this then shows a battery level of 0.74 (K11), 3.05 (K12), 6.05 (K13), 9.05 (K14) before then going back to 12.05 (K15). These are between 6am and 10am. My max consumption between these times is at 7am with 0.361 kWh consumption. I would just like to say that all 3 of your videos have been incredibly helpful and informative as we are getting quotes to have a panel and battery installation installed.
Hi Adrian, really happy to hear the videos have been useful to you, thanks! Now, for the battery Level column (K) there is a little trick I had to employ. In order to allow residual charge in the battery at hour 11 to be used overnight, I had to wrap around the formula in that column. This creates a 'circular reference' issue, so to avoid that I had to zero out any remaining charge at hour 6 (see cell K10) which is the hour before the sun comes up. I couldn't think of any other way to solve it, and I guess this is one of the limitations of trying to use a spreadsheet to model the real world! Does that explain why you're seeing what you are, or do you think there are other issues in the spreadsheet?
@@GaryDoesSolar Hi Gary, sorry for the time gap between my responding - I though RUclips would alert me to a response, but it didn't. I have tried multiple methods to try and remove the circular referencing and I can't. I did find a way though and that is if you make a cell below the table calculate that value (using your existing formula) tied to the cells that you would need and manually type that value in (or paste as text) then the table works as it should do. The circulatory reference is broken as that is just a number and not a formula. I was also thinking about the difference in production over the year and I wondered if instead of recalc'ing everything you could just drop the size of the array (kWh) to a lower value and therefore in effect generate less but in proportion to the time of year ?
No problem on the delay, Adrian. Yeah, I seem to miss notifications too. Circular references on spreadsheets do my head in! Lol Yeah, that's the only way I could find to break it - making cell K10 just '0'.And yeah, dropping the array size is the way I think works easiest (and the reason why I named it "Max array output" rather than "Array size") - next step for me will be to build an actual online utility... 🙂
@@GaryDoesSolar I think I have fixed the circ reff'ing issue Gary. I can't post the web address as RUclips keeps removing the comment no matter what I try to do with the web address. Anyway, in excel go --- File, Options (very bottom left) "Formulas" selection -> and on the right hand side is a tick box labelled "Enable iterative calculation" (I left the two maximums as default values) and select OK. I then copy n pasted the folmula from the cell below and it works fine with no circ reff'ing error. If you do this again and untick the box the circ reff'ing error returns.
Nice video but including what we you use the electricity for can be as big of a cost savings as just understanding the basic cost of replacing grid power with solar power. ie changing a heating system, replacing a petrol car with a electric car the payback period is quite a bit shorter. Also clipping is lost production never to be maximized. Any one of these could be a new video. Cheers.
Very useful. There appears to be an error in the spread sheet for solar with battery on hour 6. The battery level is set to 0, rather than the previous value + discharge.
Thanks Roy - that's now been corrected in the latest version of the spreadsheet - just click on "Check for new versions" to get it. Basically, I forgot to loop the battery level at the end of the day back to the start of the day. Thanks for spotting the error! :-)
Hi Gary, A couple of very informative and helpful videos, thank you. I've been having a close look at the spreadsheet and have a question and a suggestion; Question - On the "Solar with Battery" worksheet why is there an import cost in cell(M4) "0 Hour of Day"? (I would've thought the battery would've covered this) Suggestion - is born out of my own need to try and calculate the pay-back period. Therefore I have added a "Cost without Solar" column which I then total and use this total to calculate "Daily Savings" and "Annual Savings". This then gives me some idea of when I recoup my installation costs.
Hi John, thanks for the kind words. Now, the whole M column in the “Solar with Battery” sheet is only there so you can input the price/kWh (actually, that’s a better name for the column than “Cost/kWh”). Whatever you enter in cell M1 is automatically replicated into the rest of the column. Or, if you’re on a variable pricing throughout the day kind of tariff, you can just hard-code values throughout that same column. Does that make sense? Btw, I really like your idea of adding a new “Cost without solar” column 👍🏻 😀
@@GaryDoesSolar Thanks for the prompt reply. Sorry I didn't make it clear, the M4 cell I was referring to was on the "Solar with Battery" worksheet and is the "Grid Import(kWh)" column. I don't understand why on the "Hour 0" row there is anything being imported from the grid. I would've thought the battery would have covered this period.
Ah ok - I get it now. I think you're referring to the cell L4, not M4, yeah? Basically, there is indeed a problem, but only because I was trying to be clever about the battery charging and level... I'll explain: Rather than managing the battery level from hour 0 until hour 23, I recognised that in real-life there would be charge in the battery at hour 23 that could be used the next day (hour 0 and so on) so I essentially loop from hour 23 back to zero. But in order to void the circular reference, I intentionally zero-out the battery charge at hour 6 - just before the sun comes up (the value of cell K10 is deliberately set to 0. The side effect is that if there was still charge in the battery at hour 5, this just gets lost. But it is just a spreadsheet and of course it will have limitations. So, to your point, if you change the formula in cell J4 from: =-MIN(MAX(F4-H4,0),0,$C$13) to: =-MIN(MAX(F4-H4,0),K27,$C$13) It should solve the problem. Can you let me know if it does, and I'll upload a new version of the document. Many thanks :-)
Gary, excellent video thanks and a really helpful spreadsheet. I have solar with an EV and Octopus Go, plus a battery on order so have produced a modified version of your spreadsheet which caters for all 3 scenarios on a single sheet and allows for off-pk charging. It also overcomes the issue with Cell K10 in your "Solar with Battery" sheet. To look at solar without battery, you simply enter the Battery Capacity as 0kWh, or for battery without solar, enter the Max array output as 0kW. I have Emailed you a copy & hope you find it of interest.
Hi Mike, you’re most welcome, and thank YOU for taking the time to improve the spreadsheet! 😀 Would you be ok if I upload it so that others can try too? I’d of course credit it to “Mike P” or wherever name you prefer?
Sorry that I have only just found you. How refreshing, someone who understands what we dont! More please.
Hi Barnaby - glad to be of help! I'll keep the videos coming... :-)
There are many videos that cover this same general topic but the way you present things is outstanding. Well done. 👌👍👏
Hi Ramsey, thank you very much for the kind words! I'm touched, and will try to keep up the quality for future videos!
Thank you, you've just saved me a job. The spreadsheet is precisely what I was about to create for my parents, to help them appreciate the long-term savings of adding a battery.
No worries, Mark - very happy to have helped you out 🙏😀
If adding a battery pays off, you might better first check why Energy consumption is so high. And whether you cannot shift high consumption to sunshine hours.
Best video of this type I have seen to date. Top marks!
Thank you! That's so great to hear :-)
As a newbie to solar I've enjoyed the relaxed way Gary delivers his easy to follow videos. I've leant plenty, thank you and well done Gary.
Thank you :-) Great that you're getting a lot from my videos! More coming soon...
A great clear concise video. You are becoming the go to source for guidance on Solar.
Many thanks.
Hi Dave - you’re very kind, thank you 🙏. It certainly takes hours and hours of research, but if I can save people time, I’m well happy! 😀
Thank you Gary for yet another outstanding video tutorial. I love the way you approach this topic even more than how clearly and calmly you present all your well thought out material!!
Thank you so much for taking the time to comment. Especially on this particular video. To understand what the payback might be does require some effort - and I think many people just won’t have the time/patience 👍🏻
I am just in the process of setting up a spreadsheet for exactly the same purpose. You have explained it so clearly.
It would have taken me considerable time to come to the same clarity in setting up a spread sheet. Your thinking is far ahead of mine.
So THANK YOU!!!!!
Oh, I don’t know if my thinking is all that much further ahead, but thanks for the compliment 😀 and I’ve very happy to have hopefully saved you some time 👍🏻
Hi Gary, thanks for sharing. You don't need the excuse for working with a spreadsheet. Over simplifying does not help a serious user who is ready to plunge a fortune into a serious investment. Cheers.
Cheers 😀 and if you like the spreadsheet, I think you’ll really like the utility that developed from that. Try it here: garydoessolar.com/utilities/dailymodellingutility/
What a superb series of videos covering the challenges of solar installations. Clearly explained and very professional presentation. Thank you Gary
Hi Vincent, that's very kind of you to say - thank you! It's an incredible amount of work, taking up all my free time outside of my day job, but it's comments like this that keep me going! :-)
I wish I could put a thousand like for this video. but there is only one like button unfortunately. Thank you, Gary.
That is so very kind of you to say, Towid :-) I'll try to keep up the quality content for you!
Thanks Gary. Excellent spreadsheet and perfectly timed for me as I am currently trying to figure out my own PV + battery install.
Top of my priority list is to have a system that (within reason) minimises our dependence on the grid even during the darkest winter months. That isn't to say that cost & pay-back period are completely irrelevant but they aren't my topmost priorities. However, having spoken to several local installers, most seem to want to install a 'standard' 4Kw system that doesn't exceed the 3.68 DNO 'soft ceiling'. Whilst this would comfortably cover our summer needs it wouldn't come close during the winter. We have sufficient (suitably orientated) roof space so the (relatively) marginal cost of additional panels makes sense to me.
Thanks John 👍🏻 glad I’ve been able to help you out. Worth considering SolarEdge (and maybe other inverter manufacturers) that can handle significant oversizing (e.g. an array twice that of the inverter)…
Love the presentation style. As sums make me want go and lie down in a dark room with a G&T this video was quite a tonic. The variability of the unknowns such as the opportunity cost of the initial outlay and the impact of any future gvt 'inducements ' do shift the line on the graph considerably. Pfftt!! Keep up the good work...
Thanks David 😀 that made me chuckle! Since that video was made, I now have a utility that is more advanced than the spreadsheet - worth a look!
nice explanation of the export offsetting the daily amount to pay to the grid
Yes, and I hear that at least one of the Octopus Energy tariffs in the UK has just doubled their export rate to 15p/kWh :-)
As a data analyst I have to say you have some really good charts here and very well explained thank you as I have just started my solar journey with a small 3.2km system and no battery.
Thanks Philip - I'm no data scientist, so that's great to hear! :-) Great that you've taken the jump into solar, and I can see you extending your system to a battery very soon! By the way, worth looking at Octopus Energy as they have some very good export rates now (15p per kWh)!
Truly the best explanation and breakdown of payback that ive seen. well done.
Wow, thanks Mark - you've made my day :-)
Your presentations with a mix of technical and common sense information are very informative and easy to follow, therefore giving us guidance when deciding what kind of solar investment is good for each of us.
I am really glad that your channel found me.
Thank you
Thanks Richard - this is the very reason I started making these videos. I'll keep them coming :-)
@@GaryDoesSolar 😊
Very well done. I am currently evaluating solar array for my 68 sqm flat roof with two options (centralize with Fronius string inverter and decentralize with Enphase IQ7 or IQ8). Your spreadsheet is just perfect, just have to switch to €.. Watching many of your videos. very interesting.
That's great to hear - glad to have been of some help to you in this! Take a look at my most recent video (on microinverters) - could certainly be an good option for you :-)
Again brilliant Gary and confirms much of what I thought, but clearly and with a hood simple spreadsheet. I looked at the flux video and this version gives a good approach to applying corrections to the spreadsheet for the solar generation in winter and spring/autumn periods to give a reasonable estimate. Keep up the great work.
Thanks John - I really appreciate the feedback :-)
Just to let you know, I've nearly finished a web app utility for the same, which allows different solar models depending on the time of year. Here is a link to an early release if you'd like to try: garydoessolar.com/utilities/dailymodellingutility/
This is the most wondefully helpful channel, not least because you teach from basic first principles and build from there. So much of what you cover is actually applicable to many areas beyond the headline topic. Despite interest in this area for years I feel so much better informed. A properly Scottish approach! Will be using your code when we join Octopus in coming weeks.
Thank you very much for these kind words. It really helps as I get some haters from time to time. I just don't know why people could have a problem with someone who's spending 100s of hours trying to educate everyone about a really important topic, but there you are!
I'm very happy to have in a small way, and thank you for thinking of me wrt using my referral code - it all helps! :-) All the best for this year!
Great video Gary, everything is put in simple terms and not silly jargon. Keep them coming.
Thanks for the great feedback - will do! :-)
Oh My Goodness. That spreadsheet is absolutely brilliant. I am ashamed that I didn't think to analyse this issue in the same way, but you have nailed it! Thank you so much Gary for all your effort and for sharing it with us lesser minded individuals. I am having so much fun playing around with this fabulous tool! I also appreciate you answering my question on your last video. It seems that even Ecobubl has now announced that they are not currently taking any more solar PV/battery enquiries, so well done for getting your foot in the door!
Hi Ben, so great to hear you're getting a lot of value from the spreadsheet :-) and sorry about the situation with Ecobubl - it's just so crazy these days with the demand for solar. I hope you're able to find a good installer before long!
Thanks very much for another brilliant video. Incredibly informative and yet presented in a very simple way.... Engage, Inform, Inspire 🙏
Thank you, Nic 😀 that’s very kind of you to say 👍🏻 I’ll keep the videos coming!
Absolutely love the breakdown on systems and costs.
Oh my, that is one impressive bill to cap electricity prices! that has to be several hundred million pounds......
Having a look at the differences between France and Germany on power mix and $/kW: France has about 10% green, 70% Nuclear versus Germany about 29% green, 12% Nuclear; French domestic electricity prices are half that of Germany; Germany also has a very high retail $/kW versus wholesale price (I think this means Domestic vs Manufacturing)
France gets about three billion euros per year from electricity exports.
Further to this, France has very low Greenhouse gas emissions for electricity generation, but Germany produces more Greenhouse gases than any other EU country.
So, I know what I'd like my electricity to cost.
Going 'green' has hidden costs in the building and maintenance of your electricity grid as well. At night, nuclear and hydro keep working, but solar and wind are fickle beasts.
Hi there - thanks for the kind words. Yeah, the UK is is a bad place at the moment with regard to energy policy. The estimates are it will cost in the order of £150bn over the next 2 years just too subsidise the increased energy costs for consumers. I'll be making a video on all of this soon, including coverage of nuclear and hydro... :-)
Hey Gary, you are brilliant!
From all the videos I’ve watched you are the most informative and well spoken person. Congratulations on your success.
Want to ask you a question maybe asking you the same every day. Can you help me out decide what to choose as materials and equipment, and who to use as installer? Talking about house in Hornchurch/ London.
Very best of luck,
Regards Biser
Hi Biser, thanks for the lovely words! It's a lot of work making these videos, but comments like yours make it all worthwhile :-)
Now, your question is a good one - and there is no single answer as it very much depends on your property, electricity usage, if you have (or intend to have) an EV etc. Unfortunately, l'm not really in a position to provide such individual advice, (not least because of potential liability issues - even if that advice is given free - such is the world today). You're best to speak directly to an installer about that, or post a comment onto a solar forum (e.g. this one in the UK: facebook.com/groups/2197329430289466) Good luck with your solar journey!
Excellent video as usual Gary. Please keep making them, we all appreciate it! One of the best youtubers for explaining solar I have come across.
Hi Rob, thanks very much! You're far too kind, but I'll take the praise!! It's really hard work making the videos but comments like this, give me a warm feeling inside! I'll keep going :-)
A super helpful video again, I wish I'd found and watched this before playing with your lovely spreadsheet, as it took me a little while to figure out what to change to cater for my E/W facing roof :) Again this is great and really helpful work, thank you so much!
Hi Chris, you're most welcome. Yeah, spreadsheets are great but the modelling is getting a little too complex now, so I made a web utility instead. See what you think:
garydoessolar.com/utilities/dailymodellingutility/
@@GaryDoesSolar Thanks for the reminder. I'll try to have a go with that over the weekend, hopefully get similar results to my own, but no don't better 😊👍
Love me a good spreadsheet. If the formulas are not too difficult, you could put them into a google sheet and share them that way. Single link will always get the latest one, you would just need to version whatever the latest is in the sheet itself
Thanks Nick - I hadn’t thought of Google Sheets, but now that you mention it - I’ll check it out - thanks!
@@GaryDoesSolar Yes, Gary, and please let it "share to whoever has the link" and set it for "only viewers". @Bjørn Neyland also has available a Google Sheet with his test-drive results.
Thanks Gary for an excellent summary of how the use of solar could significantly reduce the cost of electricity for home users. I have a 6.6 kWh solar system and have been considering adding at least a 10 kWh battery to it, but the cost in Australia is still too high. I estimate the ROI would take about 10 years (the warranty period for the battery).
Hi David, thank you for the very nice feedback :-) Yeah, battery costs have increased quite a bit over the last 2 years, but with EV demand increasing, I'm expecting economies of scale, and of course newer battery technologies, to start driving those prices down again. Hopefully, in the next year or two, the ROI will drop quite a bit! Let's see...
Love your spreadsheet, and videos. It's very useful when thinking about what type of system we want. Thanks Gary
Thanks Richard - you’re most welcome 👍🏻 😀
Thanks, Gary. As a noob to solar, your videos are really informative.
Hi Craig, you're most welcome! Thanks for watching! :-)
Thanks Gary for the spreadsheet. Please could you also put a model for winter solar production?, Also, it would be quite useful to include a model for winter where we could charge battery using off-peak tariff
You're welcome. Now, the model for winter is basically the same as summer, but with less hours of sun. It would still go from 0 to 1. I'm quite busy with work at the moment, but I'll try to add this at some point.
I've just had a PV and battery system installed. 12kWp PV with 7 kWh battery storage. Just ordered an additional 3.5kWh battery for the system. Was interested in the effect on the payback period with the 3rd battery. I will feed data into your spreadsheet. Thanks for the excellent videos.
Hi Harry, thanks for the kind words - and that's a very good sized system you have there! Worth looking at Octopus Energy if you're not already with them, given they've just raised export price to 15p per kWh :-)
*** For those of you interested in using the spreadsheet, I've created a much easier to use utility here: garydoessolar.com/utilities/dailymodellingutility/ - see what you think! 😃
The more astute of you will see that in cell K10 of the "Solar with Battery" sheet is '0' rather than a formula. This looks like an error, but actually, it's a little trick - I'll explain:
Rather than managing the battery level from hour 0 until hour 23, I recognised that in real-life there would be charge in the battery at hour 23 that could be used the next day (hour 0 and so on) so I essentially loop from hour 23 back to zero. But in order to void the circular reference, I intentionally zero-out the battery charge at hour 6 - just before the sun comes up (the value of cell K10 is deliberately set to 0.
IMPORTANT: The side effect is that if there was still charge in the battery at hour 5, this just gets lost.
Trying to model non-trivial real-world scenarios in a spreadsheet is a constraining experience! 🙂
Loving all 5 videos so far, thank you. Do you have any plans to release a revised version of your spreadsheet which can track both solar generation & battery storage, but also combining them with variable electric tariffs to charge the battery off-peak if your solar array isn't very large.
Great video. I did similar myself but yours has some extra features which are better than mine. I’m going to compare more closely. Thanks for your videos. They are really informative. Wish i was able to see before I bought my system.
You're most welcome! Yeah, I wish I'd got into solar years ago - but there was no-one round to tell me! Lol
Now, my utility won't be perfect - attempting to model real-world systems to any kind of high-degree accuracy is a potential road to insanity - but hopefully it's good enough for folks to make informed decisions.
@@GaryDoesSolar agreed. I found it a real can of worms and hard to get quality information before I got mine installed. Luckily I think I’m alright but I think going again I’d have gone for even more panels. Plus a bigger inverter even if I had to wait for DNO
That is incredibly useful, thanks.
And I second the request for a Google Sheets version. 👍
You’re most welcome, Stephen 👍🏻 I’m looking into Google Sheets…
This channel is outstanding Gary. Thank you!
Great to hear! Thanks for taking the time to let me know :-) I'll keep the videos coming!
You are the best source of impartial advice out there on the web for newbies like me. Love the Flux web calculator, with a 5 kWp array and a 10 kW battery system it's suggesting an annual income of >£1500 pa !!
Hi Ray, thanks for the kind words. Re. the Flux calculator, remember that not every day will be sunny, and as you head towards the winter later in the year, your production will drop (the "Maximum Array Output" field is not your array size, but the maximum output you could expect for the time of year (e.g. winter will be say 20% of summer) - but yeah, you should still be able to make a nice profit :-)
Thanks for the great video and web calculator Gary. It would be interesting to see what happens as you add extra batteries to an existing setup - this is the situation I'm in with a PV installed in 2016, 3.6 Kwh DC battery/inverter in 2017 on FIT and now I'm considering adding a MyEnergi Libbi (I already have a Zappi and Eddi) for addition battery storage.
Thanks for the great feedback, Cliff. You raise a really good question, and I'm not sure the answer in fact. If the second battery was made by the same manufacturer and simply an extension of the DC-coupled connection, then I'd expect the inverter to manage it without problem. It's not likely to be possible to mix battery manufacturers in a DC-coupled setup, and if the new battery is AC-coupled, there might be a battle of wills between the two batteries... Maybe others can comment...
Excellent video Gary. I'm sure a lot of work went into that. Thank you.
Thanks Colin 😀 and you’re not wrong there! I’m trying to find ways to be more efficient going forward (editing etc.) 👍🏻
Excellent video, really enjoying the relaxed and informative approach to this mind bendingly confusing subject.
Thanks Darren - great to get feedback like this :-)
Thank you for this ! You are amazing ! Im hooked !!
Hi Kimo - you're most welcome! :-) I'll keep the videos coming...
Just watched all your content Gary - Absolutely brilliant! Is there any chance of a version of your spreadsheet in an older version of Excel or Google sheets, please?
Thanks Rob - it’s great to get feedback like this. Now, unfortunately I don’t have a lot of time, but this might help you: support.google.com/docs/answer/9331167?hl=en-GB
Great Video, is any chance you could make a video about BIPV products? like solar tiles/solar glass/solar siding.
Many thanks
Thanks, and I'll add to me (ever-growing) list of future topics :-)
Hi Gary... fantastic job on explaining the intricacies of the variables related to solar systems. I noticed a grammatical error in your spreadsheet and was thinking about letting you know - but then when you mention "if you see any errors in my spreadsheet, let me know..." so here it is: you have a paragraph of "disclaimers" on the left hand side. You actually have the word "errors" back-to-back, so you can remove one of those words and all will be well. Greg (garden grove, CA)
Thanks for raising this - I think I need to overhaul that webpage anyway, so I'll fix that when I do - cheers! :-)
Excellent clear and concise and I'll use your wisdom go calculate my costs for my solar and battery journey. Thanks your effort and knowledge is greatly appreciated.
It is all my pleasure - very happy to help you out 👍🏻 It’s hard work but comments like this make it all worthwhile 😀
Great video again Gary, very informative! Have you had much feedback on solar tiles in UK; I have a new build and thinking of using solar tiles. Nulok have a system I’m considering. Thanks…
Hi Andrew - thanks! No, as yet I’ve not looked into that technology in any detail. Suffice to say though, it is certainly worth considering for a new roof or roof replacement. All the best with whatever approach you decide to take! 👍🏻
Fantastic work and thanks for the detailed paramters and analysis!!
Cheers Andre - hope it's useful to you. Now although I used a spreadsheet in that video, I since developed a web app, which is much easier to use. Enjoy!
garydoessolar.com/utilities/dailymodellingutility/
Thanks for the great video! Could you explain why it is good/okay to have a maximum inverter output that is smaller than the maximum array output? That means you are clipping in the hours with most sun, so not using all the potential of your panels…
Hi Maxim, you're most welcome about the video - and hopefully you'll like some of my other videos too :-) Now "array-oversizing" as it is termed, has many benefits. This article from SolarEdge is worth reading as it explains them in detail: www.solaredge.com/uk/solaredge-blog/oversizing
Hi Gary, this is a fantastic tool. Thank you so much.
You are very welcome, Philippe. Thanks for letting me know 👍🏻
Great video again and thanks a lot for the spreadsheet. I tweaked mine a bit to include the losses across different seasons and come up with a yearly figure as well as adding a bit to include standing charge.
That's great - and exactly what I was hoping people would do... improve on the start I'd made :-)
@@GaryDoesSolar how did you get the figure for the solar model 0>1 numbers? I thought maybe from the Europa map thing on your other video but can’t get figures that make sense
I just took a daily summer profile (bell curve) from a south facing house near Oxford, UK and modelled that.
@@GaryDoesSolar do you have a link at all how to do that, or are your figures kinda ok anyway? I’m in Scotland. Can’t see anything come up doing a search
I can't find my notes where I constructed the model, but it should not matter too much that you're in Scotland - remember the '1' in the model will always be the maximum output of your array. And the sun will always rise and fall creating the same kind of bell curve 👍
This panel can put out close to 100 watts ruclips.net/user/postUgkxOqI2yqX0XVrhR2BMJciTWrHJpG8FhJyg when positioned in the appropriate southernly direction, tilted to the optimal angle for your latitude/date, and connected to a higher capacity device than a 500. The built in kickstand angle is a fixed at 50 degrees. Up to 20% more power can be output by selecting the actual date and latitude optimal angle.The 500 will only input 3.5A maximum at 18 volts for 63 watts. Some of the excess power from the panel can be fed into a USB battery bank, charged directly from the panel while also charging a 500. This will allow you to harvest as much as 63 + 15 = 78 watts.If this panel is used to charge a larger device, such as the power station, then its full output potential can be realized.
?
Update as of June 2023, my unit rate is currently 48.49 pence per KWH. So on your graph ( at 7 minutes) more like line number one. Thats partly why I am watching this.
Yeah, energy prices have been a bit crazy last couple of years, but it seems they’re starting to return to “normal” levels over the next year or so. I say normal, but the the UK that still means twice the price they were say 4 years ago!
I love your clear presentation style, calm voice and tidy diagrams. You should be a university lecturer! ;-)
Interesting that your spreadsheet is focused on hourly consumption. I get that it's necessary because of solar hours/day and day/night cost, but the monthly variations are massive when it comes to solar generation and winter energy consumption. e.g. 6x as much from solar during summer months compared to December, and (for me) 2.5x electricity consumption in winter compared to summer.
Maybe a more zoomed-out spreadsheet that looks at months instead of days to account for such seasonal differences and provide overall annual cost/saving statistics? Your energy bill shows how much you consume during the day and night rate (separately) so with some assumptions on usage an annual estimate could be obtained.
Thanks Gary - it’s great to get feedback like this! 😀 I don’t think the good university lecturers get paid enough, and maybe global video platforms like RUclips are the way forward for education - not replacing face to face interaction, but providing a means for those who can articulate knowledge well to get paid well as a result.
Now, you raise a good point about the spreadsheet - it’s focussed on the hours of the day because that’s where the interactions between power consumption, solar generation and inverter/battery capability can make or break your savings potential.
That said, I am indeed working on something wider than that - more on this soon 😎
Hey Gary, echo the sentiments of the other comments, great video as always, I'm learning so much from watching your videos.
I just wondered where the Solar model comes from and does that need to be adjusted, I watch your other video featuring the PVGIS tool, but I can't see how you've translated the data it provides for use on the spreadsheet here.
Hi Rob, so the solar model in the free utility is a very basic bell curve that I coded up - it's a normalised profile for a South facing property in the UK. It's likely good enough for those who want to get a rough idea on how their planned system might perform during the day, but for those who want a more detailed view, then the Pro Edition of the tool is a far better option. I've been developing that a lot lately, and there are now two solar models:
- An improved simulated model that takes into account the geographical location and orientations of up to there arrays - and also the number of sun hours in summer and winter
- Data from the EU PVGIS system (re.jrc.ec.europa.eu/pvg_tools/en/)
Thanks Gary, first time i have come across your videos. The most informative videos i have seen on the subject so well done, and considering you started in April this year and have only done 3 videos, you have done brilliantly to get 4.8K subscribers. Just goes to show you are hitting the right level of engaging content. Thanks for posting. Have subbed and am keen to watch your upcoming content. You don’t have to convince me though of the need for solar, i already have 8KW installed - 1 4kw array facing east and one 4kw facing south. Generated 991kwh in August and was gutted to miss 1 megawatt hour by 9KW. Tesla battery beings installed soon. Cheers John
Hi John, thanks for the kind words. Yeah, I'm really happy to be getting really good traction in such a short space of time :-) I set out to share the knowledge I'd learned through my own research into solar, to save time for everybody else, and I thought that if I could recover the costs for the recording equipment etc., then great! You're ahead of the game from me. I was due to have my installation back in August, but I had problems with the company I'd contracted with, so had to start again. I should have 7.6kWp in place around the end of the year (so not too much less than you're own installation). Wow - pretty much 1MWh in a month is just amazing! Hopefully you're with Octopus Energy so you can benefit from their recent 15p/kWh export announcement :-) Good luck with the Powerwall install - I guess you'll have been waiting for that for a while!
@@GaryDoesSolar Hi Gary, yes i am with octopus and have been for a couple of years now with octopus go. Unfortunately, well not really, my original array (the 4kw west facing was fitted back in 2008 by the previous owners) and so i have a fit payment of £1500 per year on average. This was great for the first two years as our electricity bill was £1200 a year so we were up around £300. However that ended with the price rise which prompted me to add another 4kw in July this year and order the battery at the same time to get zero VAT on the battery. Big backlog so not being fitted until mid december. Still it has a really positive impact on our monthly bills, and adding a zappi to replace our podpoint has really helped to top up my EV rather than sending stupid amounts of export to the grid. Most days my car soakes up any export. for august I idid 1485 miles in my EV of which only £6.69 was paid in overnight charging giving me a cost of half a pence per mile. This would not have been possible with the podpoint which i regret getting as i wasted my govt grant getting it only the replace it six months later with the zappi at a cost of £1,000. Because i have a fit payment, i cannot sign up to another export scheme without giving up my FIT so i am in the position at the moment that my newest array attracts no payment for export. That said, my battery and car should resolve any export once fitted, so i am not too bothered. The main thing i want is to be off grid for as much of the year as possible barring the standing charge. I don’t have gas or oil, so my electric bill covers all my house, travel and mowing costs. I have a ride on electric zero turn mower to mow our field with is just shy of 2 acres and would otherwise cost me £100 a time to have it mowed professionally, so i top up the batteries when the sun is out and charge it for free. Sorry long winded response, but renewables definitely the way to go.
Hi John, it sounds like you're well on top of the situation. Loving the fact you've got an electric ride-on mover! :-) Yeah, the FiT scheme feels like an albatross on one hand, because you can't change anything, but you can't knock £1,500 a year! Thanks for the word up on PodPoint - I hate buying twice on anything.And I agree, I think we're all only get getting started on our renewable journeys - the world is changing (finally) and governments are finally waking up to that (even if in the UK, ministers are promoting fracking once more, likely mainly to secure future personal income post parliament)...
YESSS! VIDEO 3! Keep it up Gary!
Will do. Working on the next one now... :-)
Brilliant videos, you explain the concepts very well.
Thanks David - I really appreciate the feedback! :-)
Great video again, extremely helpful, thank you!
Many thanks, Richard! I wasn’t sure how this particular video was going to go down given it’s a little spreadsheet-heavy! 🤣
@@GaryDoesSolar Hey Gary, cell k10 in the Solar with Battery spreadsheet has a value of 0 - which I think is an error. Cheers
Ah now - it does look like an error, but actually isn't! I'll explain...
I wanted the residual battery charge at 11pm to be used the following morning, so wrapped it around in the spreadsheet. Now, that immediately caused a "circular reference" error, as expected, so I decided to break the circle by zeroing out any battery charge left just before the sun came up. Not ideal, but we're kind of reaching the limit of what a spreadsheet can do! :-)
Thanks for spotting though!
Thank you Gary for a very informative video - I have been thinking about solar for a while but this just pushed me to make my decision to go for it - I was wondering if you had any recommendations on some good solar installers in UK please?
You’re very welcome, thanks for letting me know. The only installer recommendation I can make is EcoBubl - they did a fantastic job with my own installation earlier this year 😀 They’re based near Basingstoke and I have a video about that on my Patreon. Good luck with your solar journey!
Admittedly late to the party I noticed no mention of Feed in tariff. Like you I have left OVO in favour of Octopus but do not know what to ask for to take advantage of the best arrangement for solar, EV charging and perhaps using the car battery for household. I am recommending your vids to assist with my chums interest in an array but could not understand the significance of the Fit having been withdrawn. Is there a way of paying you a consultation fee? I did watch the GO, intelligent, and flux video and need to re watch. Thanks for making us so much better informed. B
That's very kind of you to share my videos with your friends. I'm very happy that you're finding my videos educational. It's just a hobby for me (my day job is in the mobile industry) so I don't get any time outside of that for any consulting etc, but I can recommend some online forums where you can ask questions etc. and get answers from the experts there. One such is this one: facebook.com/groups/2197329430289466
Hi Gary. many thanks for your videos which are very clear and have aided in building my understanding of solar / battery solutions; I feel better able to assess alternatives. One aspect I'm left confused about is charging and discharging losses, these form important assumptions in your spreadsheet. Taking a couple of examples the GivEnergy battery is DC, looking at the inverter specs I read 6% losses in both the charging and discharging process? Tesla Powerwall is AC coupled with 10% round trip efficiency which I read to be charging losses? These numbers are significantly different to the assumptions you suggest in the spreadsheet. What have I got wrong? Thank you
Hi Adrian, great to hear that my videos are helping you - thanks! :-)
Now, on the charge/discharge losses in the spreadsheet, looking at the Tesla Powerwall first, round trip losses of 10% would equate to around 3% loss each AC-DC-AC conversion (remember the PW is AC-coupled, so 3 conversions).
Do you have a link for the GivEnergy losses? I can't seem to find anything on the web... thanks.
Well presented and a pleasure to watch ✨
Thanks very much. This is what I set out to do, so it's so great to hear feedback like this! :-)
Incredible video your information is amazing thanks for figuring this out and sharing it with us. I'm definitely going to setup a solar array at the house now.
You're too kind, James, but thank you! And good luck with your solar journey... :-)
Phenomenal video Gary. 👍👍
Wow, David - thank you! :-)
Thanks for the video. Is it possible to add dual tariff charging to the solar + battery spreadsheet please? My solar isn't enough to fully charge the battery so I will be topping up during the off-peak hours.
Hi Paul, my pleasure. Now, I did think about just that but thought it might be getting too complicated for one video. If I get time, I'll add an additional tab sheet into the file.
@@GaryDoesSolar that would be great thanks
HI great Video and Spread sheet . Two questions: in the spreadsheet you use solar model data . Where did it come form and which month of the year is it or average. As Would like to model for each month of the year. Second on the battery sheet the price calci=ulated does not seem right as it seem it the cost are only based on the charging at night and regardless of the size of the battery it does not seem to charge for electri after it has depleted the battery!
Hope you understand the above Simon
Hi Simon, thanks for the kind words. To answer your questions:
1. The solar model was taken from a sample of a south facing array near Oxford in the UK during summer. If modelling for other months of the year, it will be the same bell curve shape, but the sunrise and sunset times will be closer together.
2. Yes, the "Just Battery" sheet is purely battery and no solar, to allow you to see the effect of time of use rates. There is the opportunity for someone to combine it all into one sheet, but I didn't have time.
Thanks Gary. A really well put together presentation which I enjoyed (again!). Having now used your spreadsheet, solar with battery tab, for an upcoming installation I can see that a larger battery than what Ive been specified would lower my import costs. However what I dont know is what month or season the solar model generation numbers are based upon. If for example they are based upon the summer season then maybe a larger battery wouldnt improve the savings significantly as during the winter I might struggle to fully charge the larger battery.
Are you able to clarify the month or season for those values?
Many thanks and I look forward to your future videos. Ive also shared them with friends and family who are also considering the solar route.
Hi Ron, thanks for the great feedback! :-)
Now, you raise an important point! The sun model I used was a summer one! Which means, in winter the number of hours the sun is out will be significantly reduced (the model is normalised so the level of solar depends only on the maximum output of the array, which you'll be reducing for winter (e.g. to 30% of summer) anyway.
This can of course be fixed by using separate solar modals for each season (or even each month) but the problem is, that we're really pushing the boundaries of a spreadsheet now.
The good news is that I'm working to solve this... More soon... :-)
Thanks for highlighting - I really appreciate it!
Thanks for these excellent contributions Gary. Similar to one of the other comments previously, would it be possible, even if you can advise here what adjustments are necessary to calculate the solar generation for other times of the year? Is it a case of reducing the max array output by a given percentage to reflect what the average daily output for that time of year? Thanks in advance.
Hi Karl, thanks for taking the time to comment - I really appreciate the feedback. Thank you also for the kind words.
Yeah, when trying to model anything real-world, the more realistic you want it to be, the more exponentially complex that model becomes! So, I thought to myself, let's just have a single solar model to cover all seasons (even though we know that the sun's hours reduce drastically in the winter) and allow the user to turn down the percentage for different seasons, according the the monthly chart in the video for the user's location. That's probably good enough to get a reasonable approximation, I felt.
That said, if you go to the download link mentioned in the video and the video description, you'll see that some viewers have improved on my original spreadsheet :-)
Hope that information helps!
Very informative video. Well done. Thanks a bunch.
You’re most welcome! 😀
Gary - great, great videos. Looks like, through your links, I'm going to forget all the faffing about with optimisers etc re shading. I'm getting a east/west array with more on the east than West - and was going to go 'for as much as I can get on' but your spread sheet shows my return on investment would be much slower on the step up from 4to 8 than from 0 to 4 so I think I will put more in to my batterys.
Just using your spread sheet and am bit of a spread sheet novice but presume I would just add my overnight EV charging - 2 cars - typically 20-30kWh a night off peak, into those first 4 hours on the spread sheet - eg 7kWh per hour? Also assuming one of my EV's is at home for at least 6 of a day (ie between school runs) I should increase my 'home battery' to take account of that? I think it would also pretty much make my export zero.
And just a thought on the season sheet. I wonder whether the hours of production are short in the summer months - I would have thought 5-6 to 8-9 might a better spread??
Cappuccino or Latte? Actually I suspect you are an Americano man.
Hi Ben, thanks for the kind words. Now, when you get your solar quotes, they should be providing an estimated annual generation figure. Worth comparing that to the spreadsheet. Although I've taken a lot of care over the model, there's always a chance I've made a mistake. Worth also checking that you've got the latest version (as I've been correcting minor errors) - and some other viewers have improved on what I've done as well.
On the panels or batteries question, yeah - I'm definitely in the camp of get as much up there as you can. Battery prices will come down over time, so you could always buy one now and add to it later.
Re. the EV charging, a 4-hour charging time slot is not a lot of time really, especially when you take into account the charge rate of your battery. even at a charge rate of say 4kW, that's only 16kWh compared to what your EVs actually need (maybe 5-10 times as much!) So, again, having more generation on your roof will better help with the EV charging, in my view.
You're totally right about the solar model in the winter. The hours are much shorter, and so a one-size-fits-all model isn't perfect, but it likely doesn't change the outcome too much. Easily checked by zeroing out some of the hours at the start and end of the day and seeing what effect that has on the bottom line...
Lattes all the way, Ben - thank you for buying me a couple! Very much appreciated :-) All the best!
Loved your videos, taking the plunge into solar PV system myself, i had a question. I have two battery options, GivEnergy that has a 3.6KWH output and FOX ESS AIO that has a 5KWH output. Which one would you recommend?
Thanks, Deepanshu :-) Now, I intentionally don't advise people on solar, but I will say that I went for a GivEnergy solution myself...
Wow great video, just starting the journey.
Thank you! 😀 I’ll keep the videos coming 👍🏻
Hi Gary. Thanks for the spreadsheet which I’m finding very useful.
I have a question. By using 1 as the max in the solar model at midday, doesn’t that assume that every single day in the Summer we are assuming the panels will be outputting the highest possible energy for a given time of day. Of course, that will not be the case as most days in the summer are cloudy and the panels are far from outputting their max. Even when reducing the solar model to 70% for autumn/spring and 30% for winter, I’m getting double the output in your model compared to others. Can you help me understand this better please 👍. Thanks for your time.
You’re most welcome 🙏 Now, since making that video I quickly got to the limits of the spreadsheet. So I developed a web app utility, which is way more powerful and can model solar generation profiles for different types of day across any month of the year. Here is the link: garydoessolar.com/utilities/dailymodellingutility/
@jock
I have watched many of your videos Gary and subscribed. This one is particularly fascinating. I am convinced of the benefits of solar and would love to install a system but I live in the SW of France and the reviews of the larger companies here make such frightening reading that I am greatly discouraged. I don't suppose there is a way to reliably assess or evaluate an installer, or has one just has to take a leap in the dark.
Thanks John! Yeah, trying to find a reputable installer and good quality, reliable equipment is not straight-forward. I would suggest you look around your neighbourhood and chat with those who already have installations to see what their experience has been like - and whether they would recommend their installer... Good luck! :-)
Gary, this is simply the best explanation I've seen of calculating the ROI and payback. Subscribed to your channel on the back for this. Thanks for taking the time to produce such an easy to follow video. We have recently invested in the solar and battery and are seeing the benefits but being able to verify that with the guide you have put together is good. And who doesn't love a good spreadsheet?!
Hi Martyn, that's very kind of you to say - thank you! And you know that they say the world's largest spreader of disinformation is Microsoft Excel!! :-) Hope you're able to get payback before long!
@@GaryDoesSolar I'm not too bother about payback personally. One can get too obsessive about these things. We saved up hard for this system and it was simple. Get almost zero interest in the back or put on the roof and get a lot more return, which we are doing right now.
Gary thank you very much indeed. Your thorough and really helpful spreadsheeting has really chrystalised what I instinctively felt were the necessary considerations. I really like the Octopus approach to smoothing out peaks of demand locally. I have the real estate for a sizeable array, and I'm happy to design and fit the entire system for final inspection and connection by an approved sparkie but I don't think our current energy rules will allow that sensible approach. So instead I've approached the local Octopus approved fitters but they are quoting eyewatering costs (£27k) and of course throwing micro inverters/optimisers at every panel for my unshaded roof. I'm considering buying and fitting the panels and battery and then asking Octopus (installers) to come in and finish it... it would be great if you had any advice in this area. In the meantime thank you again from all of us!
It is my pleasure to help you out - thanks for taking the time to comment. Wow, £27K is an eye-watering sum! I'm avoiding offering advice to people as there are liability concerns (even if the advice is given free), take a look at my latest video published today. There's more in there about optimisers and array considerations in general. Then have a listen to the podcast I was interviewed in as that might have other useful input to help with your decision-making... All the best!
Very well presented, simple and understandable. The spreadsheet is great too. If your a newb like me. I recommend watching Gary's other videos 'A beginner's Guide to Solar' and 'How to choose Solar Wisely and Avoid costly mistakes as well. Many thanks. 5*****
That's really kind of you to say - thank you! :-)
Btw, there's a web app version of the spreadsheet available now if you'd like to try: garydoessolar.com/utilities/dailymodellingutility/
Thank you Gary for the very informative video. I tried to download the spreadsheet however your website seems to be down.
Thanks for the kind words 👍🏻😀 Now, can you try the link please? I just tried here and it seems ok
@@GaryDoesSolar it’s probably my work network blocking it. I will try again later in the evening from home.
Did you get any joy, Beri?
@@GaryDoesSolar Yes, I could download it from home. Cheers, Gary.
Well done sir!
Thank you :-)
Very useful series of videos thus far - just what I need at this point of the solar panel installation journey, so many thanks Gary.
Question on using the spreadsheet: Do the solar model or generation numbers (kWh) need to be adjusted for location (in UK) and orientation of panels or do you recommend simply using as is?
I don't know if I can help here, but here is the website Gary mentioned about getting the numbers for the orientation of the panels based on location:
re.jrc.ec.europa.eu/pvg_tools/en/
And, the calculator sheet:
www.garydoessolar.com/utilities/solarcalculator/index.html
Thanks Ian - very happy to have helped you out! 😀 On the solar model, this is fixed for a south facing roof in central England, and other orientations would simply skew that model slightly (but not much). The EU link can provide you with the exact solar model for any location and orientation but it’s not the easiest utility to use.
Yes. See link from last video. Measure roof truss angle using your phone. Enter into re.jrc.ec.europa.eu/pvg_tools/en/
@@GaryDoesSolar I downloaded the solar model for my location but not sure which value to use in the CVS sheet. time,G(i),H_sun,T2m,WS10m,Int?
@@thrillseeker75 The solar model in the spreadsheet is very simple in fact - looking down the column, you'll see that it is 0 for when there is no sun, and 1 when the sun is at its highest, with values in between forming a bell curve. Take the solar model you downloaded and try to fit it into that normalised range across the 24-period.
So clear so helpful
Thank you
Thanks Peter - very much appreciated - I'll keep the videos coming!
Gary... excellent videos and the spreadsheet has saved me a great deal of time and effort... its made me realise that for my circumstances reducing installation size (and therefore cost) from the optimum, within reason, does not significantly impact savings.
One comment on the spreadsheet... the battery discharge calculation within the battery level formula seems to reduce the figure by the discharging losses %, rather than increasing it, assuming I am understanding the meaning of discharge losses %.
Hi Kevin - great to hear the spreadsheet has been helpful. It's only when you really get into the numbers that you see things like that.
Yes, I think you're right - the discharge formula seems to be wrong, and thinking about it - it's going to be a tricky one to fix! Lol
I'll try to resolve this in the next version... :-)
Ok, I think I've sorted it - see version 1.02 :-)
The good news is that because the default discharge loss is only 3%, it didn't affect the calculations by much at all in previous versions.
Gary... just to repeat... thanks for an excellent spreadsheet, it will help me enormously negotiate suppliers away from their "one size fits all" 4Kw with battery offering !
Another great video Gary
Thanks Dan! Working on the next one now... solar diverters... :-)
Great video. I think the overall long term trend of lower electricity prices will continue though.
Thanks. Yes, hopefully that'll be the case! Cleaner electricity too :-)
It is great Gary, but I am not sure if it answers the question if the battery does pay back itselves in the period given by its lifetime given in cycles.
As it happens, I’m about to release a video focussing on battery ROI - quite illuminating! 😳
@@GaryDoesSolar Thank you! It is really perfect that you like the exact way of work with numbers and spreedsheets which most people skip. Afterall its beneficial to everybody who has eyes to watch and open mind to understand ☺️
@@krystofsykora I think you're REALLY going to like my battery ROI video then! Hopefully being released this evening 👍😃
Hi Gary, great explanation and model. Do you have a version of the spreadsheet which includes battery storage as well as using the Octopus flux tarfiff (flux/day/peak tariffs) - I want to model charging the battery sufficiently during flux cheap period to allow maximum export during peak period while retaining sufficient battery capacity for the remainder of dark hours, and see what this does to the business case for solar byoptomising use of the Octopus flux tariff
Hi Gary, I most certainly do! And I have a video to go with it: www.garydoessolar.com/utilities/fluxcalculator/index.html
You may prefer to use the web app instead of the video, which is also available on that link. Enjoy!
Great video and thanks for the spreadsheet. But where do you get the ‘Solar model’ figures from?
Good question! In fact for the spreadsheet I just used a Solar profile for a south facing roof in central England. This could of course be improved upon… 👍🏻
Very informative Gary. Thanks for taking the time and trouble to do this. Is there a link to a website showing hourly sunshine levels?
@@GaryDoesSolar Thanks. Probably the best video I’ve seen on payback calculation and makes my spreadsheet look very…amateur! But it is difficult - we’re on Octopus Go Faster with five hours reduced rate 20.30-1.30. But there are a lot of “what ifs” - if we move this to this time…etc. Personally I think a battery is essential. Yes you can move the dishwashing etc to during the day but if a cloud goes over you start pulling from the grid which potentially could make it more expensive than using it at off peak hours. And I think for people who can’t have solar for whatever reason but can get on Go, a large capacity battery might be a good idea, that way you know you will never pay more than the off peak rate, as long as the tariff exists and you’re careful about simultaneous appliance usage.
Steve, I haven't ever seen such a site, but would love to! The best alternative is the scientific EU site: re.jrc.ec.europa.eu/pvg_tools/en/ - they have massive databases that cover the planet but I'm not sure how you would extract the information you're looking for.
@@ipb1966 Thanks for the kinds words. Yes, there are pitfalls with just a solar solution as the sun is not guaranteed throughout a sunny day. This is where a battery comes into its own :-)
Thanks Gary - exceptional production. Really useful, as I have just had my system installed and wanted to understand the quirks of electricity production with respect to the available sunlight during winter of 22/23. The spreadsheet is fantastic and thanks for recommending Loop. Both are invaluable.
I do have a question: if my solar panels are rated to deliver 5.7kwh then even on the sunniest days in winter, the maximum production is only 3.2kwh. Does this sound right or is there a problem with the installation/configuration?
Thank you for the great feedback - I'm humbled. And I'm so happy to hear the spreadsheet has been of use to you :-)
Now, in relation to your question, are you saying that your array was rated (my someone) to deliver 5.7kWh on a typical winter's day? Or was that figure quoted for a summer's day? Winters are typically 10-20% of the summer generation, but it depends where you live.
In any case, if your production is only looking to be half that, then it does suggest a potential issue. What I'd do in your situation is have a chat with those living nearly you with solar installations, to get a view on the percentage generation on a typical day (e.g. 4kWh on a 6kWp array - note 'h' and 'p') and see if that matches with your own generation. I would also write a post on a solar forum that you might be a member of. Provide details of your setup and also a couple of examples of the generation you're getting (ideally graph format). Then see what responses you get. Good luck!
@@GaryDoesSolar Thanks for the response. I will follow your suggestions.
Hi I like the spreadsheet, looking forward to a version that caters for different times of the year, one small problem in cell K10 on the Solar and Battery tab. It doesn't seem to have a formula in it and when I enter a suitably adjusted version of the formula from cell K9 it moans about circular references :(
Thanks Steve. In fact there is only that single spreadsheet. For the other times in the year, you just adjust the value of the array output as described in the video.
See my pinned comment regarding the K10 cell 👍🏻
@@GaryDoesSolar Thanks
Hi, excellent intro in to the world of solar. Just one observation on the shown amount of daily generation for 5kw system (30.26 Kwh). Specifications from suppliers I have received are only stating 14Kwh?, this obviously makes a big difference to pay bay period- any guidance appreciated
Thanks for the kind words, Gareth. Please take a look at my other videos to get an idea of the expected output of the solar array at your location 👍🏻
Theres another reason to install solar panels and a battery wall...that is to keep the "LIGHTS ON" when the grid goes down and it will be happening more often in the future as we see more renewables coming in to service...add to that a EV and a wood fire with a "WET BACK" and a hot plat to cook on , you've got all the bases covered !!!.🤔💕🇬🇧
Totally agree!
Solar panels installed, but the LuxPower battery system has been delayed. It's set up to benefit from Octopus flexibility, with extra Octopus friendly functions on request.
I was surprised to learn that UK DNOs severely limit what you can do when there are power-cuts😞I'll be going for continuous battery output rather than power-cut only supply. The installer is only offering four sockets in a block and I'm having difficulty deciding where they should be installed for the best outcome.
Good video Gary! I have installed 6Kw of solar panels with a 5 Kw Fronius inverter and the systems works great. I've calculated the ROI and grid in and export exactly as you did. I did this in june of this Year. Although I saw your video today (Oktober 22) for the first time. Very nice to see that you did exactly the same as I did. Now I want to expand my installation with a Victron Quattro and an battery system LiFePo4 of 10 Kw. I need to expand my self made calculation with these parameters. Would be nice to compare your spreadsheet with mine. But I can't find a link to your sheet. Is is possible retracted? Anyway my compliment how you make your video's. Very clear and helpful for everyone that is interested in this technique. Greetings, Louis. Tilburg The Netherlands.
Thank you so much for taking the time to comment, Louis :-) Sounds like you're making all the right decisions! Now, the link to the calculator is in the video description, but for ease, I've reproduced here:
www.garydoessolar.com/utilities/solarcalculator/
Would love to hear if my spreadsheet tallies with yours :-)
Hi Gary great series but a quick question. Current on-grid solar withe normal inverter producing a Fit output, but if you are on the max rate that is now 60p a KW. If you replace the standard on-grid inverter with a hybrid inverter does the fit production that you receive go down as you are now potentially charging batteries and not exporting this element to the grid. How does that effect the economics of on-grid and hybrid?
Cheers Duncan
Hi Duncan, glad you’re enjoying the videos 👍🏻 Great that you’re on a great FiT rate too!
I think if you make any changes to your installation, including a change to your inverter, this would likely invalidate your FiT payments. Best to check…
Hi Gary, I am using your v1.01 spreadsheet and I am unsure if you have errors on K10 to K14 cells on your solar with battery tab. Using my consumption figures I have a battery level that goes from 12.10 (K9) to 0.00 on K10 for a consumption of 0.092 kWh value. this then shows a battery level of 0.74 (K11), 3.05 (K12), 6.05 (K13), 9.05 (K14) before then going back to 12.05 (K15). These are between 6am and 10am. My max consumption between these times is at 7am with 0.361 kWh consumption.
I would just like to say that all 3 of your videos have been incredibly helpful and informative as we are getting quotes to have a panel and battery installation installed.
Hi Adrian, really happy to hear the videos have been useful to you, thanks!
Now, for the battery Level column (K) there is a little trick I had to employ. In order to allow residual charge in the battery at hour 11 to be used overnight, I had to wrap around the formula in that column. This creates a 'circular reference' issue, so to avoid that I had to zero out any remaining charge at hour 6 (see cell K10) which is the hour before the sun comes up.
I couldn't think of any other way to solve it, and I guess this is one of the limitations of trying to use a spreadsheet to model the real world!
Does that explain why you're seeing what you are, or do you think there are other issues in the spreadsheet?
@@GaryDoesSolar Hi Gary, sorry for the time gap between my responding - I though RUclips would alert me to a response, but it didn't. I have tried multiple methods to try and remove the circular referencing and I can't. I did find a way though and that is if you make a cell below the table calculate that value (using your existing formula) tied to the cells that you would need and manually type that value in (or paste as text) then the table works as it should do. The circulatory reference is broken as that is just a number and not a formula. I was also thinking about the difference in production over the year and I wondered if instead of recalc'ing everything you could just drop the size of the array (kWh) to a lower value and therefore in effect generate less but in proportion to the time of year ?
No problem on the delay, Adrian. Yeah, I seem to miss notifications too. Circular references on spreadsheets do my head in! Lol
Yeah, that's the only way I could find to break it - making cell K10 just '0'.And yeah, dropping the array size is the way I think works easiest (and the reason why I named it "Max array output" rather than "Array size") - next step for me will be to build an actual online utility... 🙂
@@GaryDoesSolar I think I have fixed the circ reff'ing issue Gary. I can't post the web address as RUclips keeps removing the comment no matter what I try to do with the web address. Anyway,
in excel go --- File, Options (very bottom left) "Formulas" selection -> and on the right hand side is a tick box labelled "Enable iterative calculation" (I left the two maximums as default values) and select OK. I then copy n pasted the folmula from the cell below and it works fine with no circ reff'ing error. If you do this again and untick the box the circ reff'ing error returns.
Thanks Adrian - I'm learning new stuff from you about Excel 🙂
Nice video but including what we you use the electricity for can be as big of a cost savings as just understanding the basic cost of replacing grid power with solar power. ie changing a heating system, replacing a petrol car with a electric car the payback period is quite a bit shorter. Also clipping is lost production never to be maximized. Any one of these could be a new video. Cheers.
Thanks very much 😀 you’ve given me some ideas 💡 👍🏻
Very useful. There appears to be an error in the spread sheet for solar with battery on hour 6. The battery level is set to 0, rather than the previous value + discharge.
Thanks Roy - that's now been corrected in the latest version of the spreadsheet - just click on "Check for new versions" to get it. Basically, I forgot to loop the battery level at the end of the day back to the start of the day.
Thanks for spotting the error! :-)
This video alone got you a sub from me. Outstanding work
Thank you so much! Glad you enjoyed 😀👍🏻
Hi Gary,
A couple of very informative and helpful videos, thank you.
I've been having a close look at the spreadsheet and have a question and a suggestion;
Question - On the "Solar with Battery" worksheet why is there an import cost in cell(M4) "0 Hour of Day"? (I would've thought the battery would've covered this)
Suggestion - is born out of my own need to try and calculate the pay-back period. Therefore I have added a "Cost without Solar" column which I then total and use this total to calculate "Daily Savings" and "Annual Savings". This then gives me some idea of when I recoup my installation costs.
Hi John, thanks for the kind words. Now, the whole M column in the “Solar with Battery” sheet is only there so you can input the price/kWh (actually, that’s a better name for the column than “Cost/kWh”). Whatever you enter in cell M1 is automatically replicated into the rest of the column. Or, if you’re on a variable pricing throughout the day kind of tariff, you can just hard-code values throughout that same column. Does that make sense?
Btw, I really like your idea of adding a new “Cost without solar” column 👍🏻 😀
@@GaryDoesSolar Thanks for the prompt reply. Sorry I didn't make it clear, the M4 cell I was referring to was on the "Solar with Battery" worksheet and is the "Grid Import(kWh)" column. I don't understand why on the "Hour 0" row there is anything being imported from the grid. I would've thought the battery would have covered this period.
Ah ok - I get it now. I think you're referring to the cell L4, not M4, yeah? Basically, there is indeed a problem, but only because I was trying to be clever about the battery charging and level... I'll explain:
Rather than managing the battery level from hour 0 until hour 23, I recognised that in real-life there would be charge in the battery at hour 23 that could be used the next day (hour 0 and so on) so I essentially loop from hour 23 back to zero. But in order to void the circular reference, I intentionally zero-out the battery charge at hour 6 - just before the sun comes up (the value of cell K10 is deliberately set to 0. The side effect is that if there was still charge in the battery at hour 5, this just gets lost. But it is just a spreadsheet and of course it will have limitations.
So, to your point, if you change the formula in cell J4 from:
=-MIN(MAX(F4-H4,0),0,$C$13)
to:
=-MIN(MAX(F4-H4,0),K27,$C$13)
It should solve the problem.
Can you let me know if it does, and I'll upload a new version of the document. Many thanks :-)
Gary, excellent video thanks and a really helpful spreadsheet. I have solar with an EV and Octopus Go, plus a battery on order so have produced a modified version of your spreadsheet which caters for all 3 scenarios on a single sheet and allows for off-pk charging. It also overcomes the issue with Cell K10 in your "Solar with Battery" sheet.
To look at solar without battery, you simply enter the Battery Capacity as 0kWh, or for battery without solar, enter the Max array output as 0kW. I have Emailed you a copy & hope you find it of interest.
Hi Mike, you’re most welcome, and thank YOU for taking the time to improve the spreadsheet! 😀
Would you be ok if I upload it so that others can try too? I’d of course credit it to “Mike P” or wherever name you prefer?
Gary, feel free to upload it or use it as you wish
Thank you!
@@GaryDoesSolarHi Gary & Mike - is Mike's spreadsheet going to be uploaded? I'd love to see it and even contribute further to it if I can.
Hi Nick, you can find Mike’s spreadsheet here: www.garydoessolar.com/utilities/solarcalculator/ 👍🏻