A nice spreadsheet that I will add to my collection of David and Amy produced spreadsheets. I look forward to putting a dc amp clamp on my stuff and figuring out my loads more precisely.
Hi David! I love your channel! Been learning a ton. We are brand new to boats, but I am pretty handy. I want to learn and you have helped a ton! I love this spreadsheet. As a software engineer by trade, I have some changes for ya for it that might help others. Also, if our alternators are crushing it and overly keeping up, is it worth putting all the AT SEA items in? Seems like that doesn't really matter too much for us?
Great episode David! And thank you for the excel sheet! I am sure that after the next part of this trilogy everyone will easily costomize the boat power supply system! Bravo!
Thanks David !!! this is some GREAT STUFF !!! I greatly Appreciate your Time in Putting this together, I would Follow you on Patreon if ever start one !!
I greatly appreciate that! We've got enough going on that I'm not really interested in doing extra for a Patreon, but if we ever meet up in the world, I wouldn't say no to a giant chocolate milkshake! 😆
Great sheet David, love your how to videos :-) If you should use the sheet to determine the size of your battery bank, would it then not be a good idea to add the power you generate from solar; alternator etc.? And then subtract it from your power draw
Thanks David! I wonder if anecdotally you have observed any major discrepancies comparing amp draw from your shunt/monitor vs published specs? I guess when looking at amps out on the shunt when you turn on an item you also would need to take into account your calculations at 12.0 v when I suspect your lithium bank is probably closer to 13 v most of the time. Thanks again!
You're correct. The 'theoretical' vs 'actual' amp draw numbers will definitely vary based on the voltage of your batteries. Which is another reason why comparing the watts/watt hour numbers is a bit easier.
Great video and spreadsheet - thanks! Just a couple comments for anyone trying to do this, for VHF (receive) and probably also SSB, I think at sea, you'll be using that 24 hours, not 10 minutes. I would think you've always got the radio on (receive) so you can listen, but are only talking (transmit) for 10 minutes a day. It's a small load, so not a major factor either way. One other point on your watermaker comparison, the 12V is perhaps more efficient, but I would suspect the 110V model puts out a lot more gph than the 12V, so you're probably running it for less time/day. Also, I don't see "Margarita Machine" anywhere on the list? Was that an error?
Yes, you're definitely correct about the VHF receiving for 24 hours at sea. As for missing the Margarita Machine, that was definitely an oversight, thanks for pointing it out! 😆 The 12v watermaker that I used as an example puts out 100l or about 26.4g per hour. And the 110v model does 30gph. So decently similar water output but still a massive difference in energy consumption.
David, appreciate sharing the knowledge. However, you put 24 hrs for the autopilot and few others. Can you..and should you guesstimate that one will be sailing for 24 hours a day? (non-stop..everyday)? I would think one would use 10-12 hours for sailing time (most want to leave in the morning at be at the next anchorage by sunset 9or slightly before). Thanks
Interesting point. My mindset when I was approaching this was around our 'cruising style' on Starry Horizons. We typically do long passages with non-stop sailing - hence the 24 hour time calculation. But there's no reason you can't adjust those times to get an estimate of how much power would be used for just a day sail.
Good work, thanks. Quick question, though, and forgive me if it's a silly one... Would you really be using your AIS 24/7, whilst at anchor? Cheers, Arvind (Perth, Western Australia)
Hi Arvind. I think the AIS on 24/7 is a personal preference thing. Some boats we know leave theirs on when anchored as an additional safety measure so other boats that are navigating can still 'see' them. We leave ours on because our Vesper AIS also acts as our anchor alarm.
Sure. We only really need to run our watermaker every 5 days based on our normal water usage. So most days we wouldn't run it. And there have definitely been places we've been where it was hot enough that we wanted to run air conditioning, even if we didn't need to make water.
A nice spreadsheet that I will add to my collection of David and Amy produced spreadsheets. I look forward to putting a dc amp clamp on my stuff and figuring out my loads more precisely.
It is kinda fun seeing just how closely the actual consumption matches the rated specs!
David, thanks so much for the spreadsheet, this is such a great head start for this project.
As always awesome content and thank you for the Power audit Excel sheet...
Awesome. I knew most of this, but the spreadsheet is nice for getting it all organized. Thanks!
Well done David! You got me hooked ...
Totally thankful for this spread sheet worksheet. This is a true gift, David. Saving tons of time, money, and frustration. 🎉✨🌞✨💪🏻
Excellent audit, will be sure to use it when I build my solar/battery bank.
Hi David! I love your channel! Been learning a ton. We are brand new to boats, but I am pretty handy. I want to learn and you have helped a ton! I love this spreadsheet. As a software engineer by trade, I have some changes for ya for it that might help others. Also, if our alternators are crushing it and overly keeping up, is it worth putting all the AT SEA items in? Seems like that doesn't really matter too much for us?
Thanks for making such a helpful tool and making it available. Cheers.
Great episode David! And thank you for the excel sheet! I am sure that after the next part of this trilogy everyone will easily costomize the boat power supply system!
Bravo!
I sure hope so!
Thanks! Great Video and download material
Excellent! Coming to the next Cruisers University: David Alton and Nigel Calder present "Boat Power"! Thanks for the worksheet!
😂 I wonder how long you have teach at Cruisers University before you get tenure...
Thanks David !!! this is some GREAT STUFF !!! I greatly Appreciate your Time in Putting this together, I would Follow you on Patreon if ever start one !!
I greatly appreciate that! We've got enough going on that I'm not really interested in doing extra for a Patreon, but if we ever meet up in the world, I wouldn't say no to a giant chocolate milkshake! 😆
@@OutChasingStars You Got it We are Located in Marathon Florida if your ever in the Area
Thanks for doing the leg work for me. ;)
Always happy to be helpful! 😀
Great sheet David, love your how to videos :-)
If you should use the sheet to determine the size of your battery bank, would it then not be a good idea to add the power you generate from solar; alternator etc.? And then subtract it from your power draw
Hey!! Spoilers for the next video!! 😉
Thanks David! I wonder if anecdotally you have observed any major discrepancies comparing amp draw from your shunt/monitor vs published specs? I guess when looking at amps out on the shunt when you turn on an item you also would need to take into account your calculations at 12.0 v when I suspect your lithium bank is probably closer to 13 v most of the time. Thanks again!
You're correct. The 'theoretical' vs 'actual' amp draw numbers will definitely vary based on the voltage of your batteries. Which is another reason why comparing the watts/watt hour numbers is a bit easier.
Good gouge. Thanks!
Great video and spreadsheet - thanks! Just a couple comments for anyone trying to do this, for VHF (receive) and probably also SSB, I think at sea, you'll be using that 24 hours, not 10 minutes. I would think you've always got the radio on (receive) so you can listen, but are only talking (transmit) for 10 minutes a day. It's a small load, so not a major factor either way. One other point on your watermaker comparison, the 12V is perhaps more efficient, but I would suspect the 110V model puts out a lot more gph than the 12V, so you're probably running it for less time/day. Also, I don't see "Margarita Machine" anywhere on the list? Was that an error?
Yes, you're definitely correct about the VHF receiving for 24 hours at sea. As for missing the Margarita Machine, that was definitely an oversight, thanks for pointing it out! 😆
The 12v watermaker that I used as an example puts out 100l or about 26.4g per hour. And the 110v model does 30gph. So decently similar water output but still a massive difference in energy consumption.
David, appreciate sharing the knowledge. However, you put 24 hrs for the autopilot and few others. Can you..and should you guesstimate that one will be sailing for 24 hours a day? (non-stop..everyday)? I would think one would use 10-12 hours for sailing time (most want to leave in the morning at be at the next anchorage by sunset 9or slightly before). Thanks
Interesting point. My mindset when I was approaching this was around our 'cruising style' on Starry Horizons. We typically do long passages with non-stop sailing - hence the 24 hour time calculation. But there's no reason you can't adjust those times to get an estimate of how much power would be used for just a day sail.
Good work, thanks.
Quick question, though, and forgive me if it's a silly one...
Would you really be using your AIS 24/7, whilst at anchor?
Cheers,
Arvind (Perth, Western Australia)
Hi Arvind. I think the AIS on 24/7 is a personal preference thing. Some boats we know leave theirs on when anchored as an additional safety measure so other boats that are navigating can still 'see' them. We leave ours on because our Vesper AIS also acts as our anchor alarm.
@@OutChasingStars Makes sense now you point that out! And thanks awfully for responding.
Stay safe and well.
Arvind
Two questions, did you ever feel the need for Air COnditioning, and zero for your watermaker?
Sure. We only really need to run our watermaker every 5 days based on our normal water usage. So most days we wouldn't run it.
And there have definitely been places we've been where it was hot enough that we wanted to run air conditioning, even if we didn't need to make water.
great job but no admiral