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 👍🏻
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!
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! :-)
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 :-)
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...
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/
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)…
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 😊👍
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
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)!
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/
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!
You're most welcome - thank you very much! :-) My next planned couple of videos are on (i) solar diverters, and (ii) future energy market and how to derive revenue from it with solar/battery
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 :-)
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)...
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/
*** 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.
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 :-)
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!
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
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!
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 👍
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.
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.
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 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.
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
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.
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... :-)
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/
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.
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.
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 :-)
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?
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 ☺️
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!
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! 👍🏻
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...
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 😎
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
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!
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 !
What do you think of Rowan’s Carbon monitor ? Is this also a big saving on helping to pay back my solar equipment ? Apparently 10p per KW generated by my solar arrays
Hi Duncan, I just had a look at their website. I didn't realise this was a thing in the consumer space. Do you know how much these units are? I couldn't find a price...
Hi Duncan, I checked it out. I hadn't come across anything like this before (at least not in the consumer space). It does look like a way for people to make some money (£500+ a year in this case) simply by adding a small hardware unit to your solar setup. And because it's all about carbon credits, it feels like it's good for the environment. ... but I don't like the premise for these reasons: 1. It allows companies to carry on doing what they're doing (which is causing co2 and other emissions) simply by buying carbon credits - it doesn't actually reduce emissions. 2. It doesn't actually reduce carbon emissions. An argument to say that more people will go out and buy solar because of this scheme is tenuous. 3. It enables the operators of these schemes to make a far larger profit than the consumers do, which also doesn't sit will with me. 4. Basing the scheme on 'blockchain' (which I know a lot about) appears to be an obfuscation. Overall, I think those who are genuinely interested in "doing the right thing" with respect to the environment will steer clear... Maybe I should make a video?
Yes , make a video. I think it does appear to blind people with science . I know that ESE group do state this device is free if you purchase a solar system through them but on the other hand you pay more money to them for apparently a 17 year workmanship warranty (which they recon is around £1000 plus)
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.
Hi Mark, if you look at the bottom of the screen, you'll see a few tabs. Click on the one that says "Solar with Battery" and that will give you what you need... 🙂
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.
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 👍🏻
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*****
have you seen anything about Hinkley Point nuclear reactor cost of electricity contract agreement. From what I recall we get penalty if national price for power drops below a certain point. Contract suggested we still pay a higher amount irrespective of the price dropping, which sounds like it would make its way back to customers. If you could comment I'd be interested on your views
Hi Gavin, so in the big list I have of topics to create videos on, one will be on the future of energy, and part of that will cover nuclear. I'll try and make mention of Hinkley Point as well - I've still got a lot of research to do :-)
Hello, I have had a quote for a PV and battery system and now looking at running the figures to see if I can get a reasonable breakeven point. So this video has come just in time. I have put my figures in, using version 1.02, and there appears to be an issue with regards to the battery part of the calculation. It seems to start the day at 0 hour with a charge already in the battery even though there is no solar production. Is this the issue being referred to on the version notes for 1.02? The issue being "minor error with battery discharging formula". Thanks.
That’s correct, Peter. I made it so charge rolls over to the next day 👍🏻 Hope you find the spreadsheet useful for calculating your estimated payback period
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, Does the solar model consider the variance across the full calendar year - therefore being an average for the whole year? If not, what month is it modelled on?
Hi George, the model doesn’t consider any variance - it was based on the month of July. Of course, with any model, making it as accurate as possible increases the complexity geometrically (or worse)! If you wanted, you could have a drop-down month selector, selecting from various models in a separate sheet. For each model, the only considerations you have to make are the sunrise and sunset times. The model is already normalised in terms of amplitude.
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)
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.
@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! :-)
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!
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
A but if advice. From the quotes so far I can buy and install the battery for 50% of the cost of solar panels and battery. So for 50% of the outlay my unit rate of electricity will go from 34p to 7.5p. A break even much more quickly. Am I missing something? If I use I hybrid inverter in the install I can instal panels later if the business case changes?
Hi Andrew, yeah - I wish the UK government would relax a little on the VAT benefit. At present, you have to get the battery the same time as the solar panels to get that benefit, but it would help people manage their budget better to be able to get the panels first, see how they get on, then invest in a battery at a later date. What you might be able to do is agree to have a battery in the quote with the installer, but make the installation date of the battery some time away, with the option of you cancelling the battery? See what your installer says... Also, check with your installer about how you might be able to install extra panels later on... generally the size of the inverter is chosen to match the number of panels being installed. A "hybrid" inverter only affects the battery consideration (DC-coupled instead of AC). Good luck with whatever you decide!
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/)
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?
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. On the solar calculator spreadsheet for "just Battery" tab for AC-coupled batteries shouldn't charging and discharge losses be set to 3%? When charging from the grid there is a 3% loss in conversion from AC to DC and when discharging again there is a 3% loss in conversion from DC to AC. Or am I wrong?
Hiya - so, for AC-coupled batteries, the spreadsheet takes into account three conversions, but I would suggest you use my online utility instead now, as it's more powerful and easier to use: garydoessolar.com/utilities/dailymodellingutility/ For details on the conversion losses, take a look at my video here (19m30s in): ruclips.net/video/ccm1HmxELlQ/видео.html
Maintenance costs should generally low apart from the string inverter if your solution has one. These units normally only last 10 (or maybe up to 15) years.
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... :-)
Best video of this type I have seen to date. Top marks!
Thank you! That's so great to hear :-)
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.
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...
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 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 👍🏻
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! 😀
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 👍🏻
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!
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! :-)
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 :-)
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!
Truly the best explanation and breakdown of payback that ive seen. well done.
Wow, thanks Mark - you've made my day :-)
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/
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)…
Great video Gary, everything is put in simple terms and not silly jargon. Keep them coming.
Thanks for the great feedback - will do! :-)
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!
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 😊👍
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 😊
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 :-)
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 👍🏻 😀
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!
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!
Thanks, Gary. As a noob to solar, your videos are really informative.
Hi Craig, you're most welcome! Thanks for watching! :-)
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)!
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/
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
You're most welcome - thank you very much! :-) My next planned couple of videos are on (i) solar diverters, and (ii) future energy market and how to derive revenue from it with solar/battery
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 :-)
Excellent video, really enjoying the relaxed and informative approach to this mind bendingly confusing subject.
Thanks Darren - great to get feedback like this :-)
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.) 👍🏻
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)...
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/
*** 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.
Hi Gary, this is a fantastic tool. Thank you so much.
You are very welcome, Philippe. Thanks for letting me know 👍🏻
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 :-)
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!
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
Thank you for this ! You are amazing ! Im hooked !!
Hi Kimo - you're most welcome! :-) I'll keep the videos coming...
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! :-)
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!
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! :-)
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 👍
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 😀
Phenomenal video Gary. 👍👍
Wow, David - thank you! :-)
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.
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 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
Very informative video. Well done. Thanks a bunch.
You’re most welcome! 😀
Another great video Gary
Thanks Dan! Working on the next one now... solar diverters... :-)
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…
Wow great video, just starting the journey.
Thank you! 😀 I’ll keep the videos coming 👍🏻
This video alone got you a sub from me. Outstanding work
Thank you so much! Glad you enjoyed 😀👍🏻
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
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... :-)
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... :-)
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/
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.
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.
So clear so helpful
Thank you
Thanks Peter - very much appreciated - I'll keep the videos coming!
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 :-)
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...
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 👍😃
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!
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! 👍🏻
Well done sir!
Thank you :-)
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...
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 😎
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 :-)
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
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!
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 !
What do you think of Rowan’s Carbon monitor ? Is this also a big saving on helping to pay back my solar equipment ? Apparently 10p per KW generated by my solar arrays
Hi Duncan, I just had a look at their website. I didn't realise this was a thing in the consumer space. Do you know how much these units are? I couldn't find a price...
Hi Duncan, I checked it out. I hadn't come across anything like this before (at least not in the consumer space). It does look like a way for people to make some money (£500+ a year in this case) simply by adding a small hardware unit to your solar setup. And because it's all about carbon credits, it feels like it's good for the environment.
... but I don't like the premise for these reasons:
1. It allows companies to carry on doing what they're doing (which is causing co2 and other emissions) simply by buying carbon credits - it doesn't actually reduce emissions.
2. It doesn't actually reduce carbon emissions. An argument to say that more people will go out and buy solar because of this scheme is tenuous.
3. It enables the operators of these schemes to make a far larger profit than the consumers do, which also doesn't sit will with me.
4. Basing the scheme on 'blockchain' (which I know a lot about) appears to be an obfuscation.
Overall, I think those who are genuinely interested in "doing the right thing" with respect to the environment will steer clear... Maybe I should make a video?
@@GaryDoesSolar These units are apparently free to anyone signing up for solar with ESE group. It’s around £1000 to buy individually
Yes , make a video. I think it does appear to blind people with science . I know that ESE group do state this device is free if you purchase a solar system through them but on the other hand you pay more money to them for apparently a 17 year workmanship warranty (which they recon is around £1000 plus)
@@duncanmartin8965 Agreed, the video should be published at the weekend 👍
Very comprehensive- thank you.
You’re very welcome, Paul 👍🏻 😀
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.
Excellent video's. Very clear, simple to follow and VERY informative! Well done Gary. Sub'd and look forward to more content soon!
Thanks very much for the sub - much appreciated! :-) Next video just released...
Have you a down load for the spread sheet including Battery Gary?
Hi Mark, the link is in the video description, but here it is directly: www.garydoessolar.com/utilities/solarcalculator/index.html
@@GaryDoesSolar
I must be missing something, there is no battery included in this spread sheet?
Hi Mark, if you look at the bottom of the screen, you'll see a few tabs. Click on the one that says "Solar with Battery" and that will give you what you need... 🙂
Thanks for this, very helpful and great channel
It is my pleasure 😀 thanks for watching my videos 👍🏻
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.
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
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/
Thanks ❤❤
You're very welcome! :-)
have you seen anything about Hinkley Point nuclear reactor cost of electricity contract agreement. From what I recall we get penalty if national price for power drops below a certain point. Contract suggested we still pay a higher amount irrespective of the price dropping, which sounds like it would make its way back to customers. If you could comment I'd be interested on your views
Hi Gavin, so in the big list I have of topics to create videos on, one will be on the future of energy, and part of that will cover nuclear. I'll try and make mention of Hinkley Point as well - I've still got a lot of research to do :-)
Hello, I have had a quote for a PV and battery system and now looking at running the figures to see if I can get a reasonable breakeven point. So this video has come just in time. I have put my figures in, using version 1.02, and there appears to be an issue with regards to the battery part of the calculation. It seems to start the day at 0 hour with a charge already in the battery even though there is no solar production. Is this the issue being referred to on the version notes for 1.02? The issue being "minor error with battery discharging formula". Thanks.
OK, it looks like that the first value is from the previous battery charge level, from the previous day, ie 23 hour.
That’s correct, Peter. I made it so charge rolls over to the next day 👍🏻 Hope you find the spreadsheet useful for calculating your estimated payback period
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,
Does the solar model consider the variance across the full calendar year - therefore being an average for the whole year? If not, what month is it modelled on?
Hi George, the model doesn’t consider any variance - it was based on the month of July.
Of course, with any model, making it as accurate as possible increases the complexity geometrically (or worse)!
If you wanted, you could have a drop-down month selector, selecting from various models in a separate sheet. For each model, the only considerations you have to make are the sunrise and sunset times. The model is already normalised in terms of amplitude.
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! :-)
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.
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.
@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! :-)
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!
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 👍🏻
A but if advice. From the quotes so far I can buy and install the battery for 50% of the cost of solar panels and battery. So for 50% of the outlay my unit rate of electricity will go from 34p to 7.5p. A break even much more quickly. Am I missing something? If I use I hybrid inverter in the install I can instal panels later if the business case changes?
Hi Andrew, yeah - I wish the UK government would relax a little on the VAT benefit. At present, you have to get the battery the same time as the solar panels to get that benefit, but it would help people manage their budget better to be able to get the panels first, see how they get on, then invest in a battery at a later date.
What you might be able to do is agree to have a battery in the quote with the installer, but make the installation date of the battery some time away, with the option of you cancelling the battery? See what your installer says...
Also, check with your installer about how you might be able to install extra panels later on... generally the size of the inverter is chosen to match the number of panels being installed. A "hybrid" inverter only affects the battery consideration (DC-coupled instead of AC).
Good luck with whatever you decide!
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/)
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/ 👍🏻
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 :-)
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. On the solar calculator spreadsheet for "just Battery" tab for AC-coupled batteries shouldn't charging and discharge losses be set to 3%? When charging from the grid there is a 3% loss in conversion from AC to DC and when discharging again there is a 3% loss in conversion from DC to AC. Or am I wrong?
Hiya - so, for AC-coupled batteries, the spreadsheet takes into account three conversions, but I would suggest you use my online utility instead now, as it's more powerful and easier to use: garydoessolar.com/utilities/dailymodellingutility/
For details on the conversion losses, take a look at my video here (19m30s in): ruclips.net/video/ccm1HmxELlQ/видео.html
what about maintenance costs, how much you need to spend as the system ages?
Maintenance costs should generally low apart from the string inverter if your solution has one. These units normally only last 10 (or maybe up to 15) years.