SailNet Community
(http://www.sailnet.com/forums/)
 Gear and Maintenance Articles
(http://www.sailnet.com/forums/gearmaintenancearticles/)
  Creating a 12Volt Spreadsheet
(http://www.sailnet.com/forums/gearmaintenancearticles/19585creating12voltspreadsheet.html)
Creating a 12Volt Spreadsheet
<HTML><! eWebEditPro 1.8.0.2 ><P>Generating, storing, and using 12volt energy on board must be viewed as a total system. Attempts to set up the best complement of batteries, inverters, alternators, and chargers without a comprehensive 12volt spreadsheet are usually disappointing. And since every sailor uses electricity differently, a 12volt spreadsheet needs to be developed.</P><P>Begin your spreadsheet with the manufacturer's spec sheet for each of the electrical items on the boat. A good retailer's catalog may sometimes be substituted. The spreadsheet can be developed on a computer or done the oldfashioned way with paper, pencil, and calculator.</P><P>We've found that two spreadsheets are necessary, and we do them sidebyside. One is for underway when the running lights, nav instruments, and radios get a lot of use. The other is headed "At Anchor" when the entertainment appliances, anchor, and reading lights demand more power.</P><P>When setting up your spreadsheet, don't forget to incorporate items that you plan to add in the future. Heavy electrical users like12volt refrigeration, SSB radio, or radar will upset the whole plan if not included.</P><P>If you have little experience living with your systems, err toward the generous side when estimating the time each electrical appliance will be used. It's better to plan using the water maker three hours per day and then later discovering it's actually used only two hours.</P><P>Set up the column with these headings:</P><P><B>Appliance, Watts, Amps, Hours at Anchor, Hours Underway, Total Hours at Anchor, and Total Hours Underway</B></P><P>Sit at the boat's 12volt panel and fill out the Appliance column. Don't forget the hidden items such as pumps, propane solenoid, bilge blower, or loads not directly labeled. Items such as interior lights can be grouped together under one heading.</P><P>Have no fear of the Watts and Amps columns. Electrical parts manufacturers quote the usage of appliances either way and they are both measures of power consumption. If the electrical draw is quoted in amps, you can leave the watts column blank.</P><P>Specification sheets showing 12volt draw in watts will require a simple calculation to convert it to amps. For your spreadsheet, the formula is: <B>watts divided by volts = amps</B>. In round numbers, a 12volt battery is fully charged at 13 volts and completely discharged at 12 volts. A battery being charged by a generating source will usually read more than 14 volts. To convert watts to amps, we normally use12.75. Thus, our formula becomes watts /12.75 = amps.</P><P>Example: a halogen reading light is quoted by the manufacturer as 20 watts. That's: 20 / 12.75 = 1.57 amps.</P><P>If an inverter is running 120volt loads, use the same formula. Thus using the microwave for popcorn would look like this: 1,200 watts / 12.75 volts = 94.12 amps of 12volt power.</P><P>Next, estimate the number of hours each appliance is used during a 24hour day. Do this twice; once in the At Anchor column, and again in the Underway column. Use tenths of hours (six minutes = onetenth hour) to keep the math simple.</P><P>Finally, multiply the amps by the number of hours used, round to two decimal places and fill in the results in the Totals columns. Again, you must do this twice, once for Total At Anchor and once for the Total Underway columns. These results are the amount of 12volt power used by each appliance in 24 hours.</P><P>Now your spreadsheet should look like this:</P><TABLE cellSpacing=0 cellPadding=2 width=466 align=center border=1><TBODY><TR><TD align=middle bgColor=silver colSpan=7><FONT face=Arial size=2><B>12Volt Spreadsheet</B></FONT></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD><FONT face=Arial size=2><B>Hours Used</B></FONT></TD><TD align=middle><FONT face=Arial size=2><B>Total</B></FONT></TD><TD><FONT face=Arial size=2><B>Hours Used</B></FONT></TD><TD align=middle><FONT face=Arial size=2><B>Total</B></FONT></TD></TR><TR><TD><FONT face=Arial size=2><B>Appliance/Electronics</B></FONT></TD><TD align=middle><FONT face=Arial size=2><B>Watts</B></FONT></TD><TD><FONT face=Arial size=2><B>Amps</B></FONT></TD><TD align=middle><FONT face=Arial size=2><B>at Anchor</B></FONT></TD><TD><FONT face=Arial size=2><B>at Anchor</B></FONT></TD><TD align=middle><FONT face=Arial size=2><B>Underway</B></FONT></TD><TD><FONT face=Arial size=2><B>Underway</B></FONT></TD></TR><TR><TD>Running Lights</TD><TD> </TD><TD align=right>3.00</TD><TD align=right>0.00</TD><TD align=right>0.00</TD><TD align=right>10.00</TD><TD align=right>30.00</TD></TR><TR><TD>Reading Lights</TD><TD align=right>20.00</TD><TD align=right>1.57</TD><TD align=right>3.45</TD><TD align=right>5.41</TD><TD align=right>0.00</TD><TD align=right>0.00</TD></TR><TR><TD>Anchor Light</TD><TD align=right>10.00</TD><TD align=right>0.78</TD><TD align=right>9.50</TD><TD align=right>7.45</TD><TD align=right>0.00</TD><TD align=right>0.00</TD></TR><TR><TD>Navigation Instruments</TD><TD> </TD><TD align=right>0.50</TD><TD align=right>0.00</TD><TD align=right>0.00</TD><TD align=right>24.00</TD><TD align=right>12.00</TD></TR><TR><TD>Refrigerator</TD><TD> </TD><TD align=right>6.00</TD><TD align=right>8.50</TD><TD align=right>51.00</TD><TD align=right>8.00</TD><TD align=right>48.00</TD></TR><TR><TD>LPG Solenoid</TD><TD align=right>16.00</TD><TD align=right>1.25</TD><TD align=right>1.40</TD><TD align=right>1.76</TD><TD align=right>0.50</TD><TD align=right>0.63</TD></TR><TR><TD>Microwave Popcorn</TD><TD align=right>1200.00</TD><TD align=right>94.12</TD><TD align=right>0.10</TD><TD align=right>9.41</TD><TD align=right>0.00</TD><TD align=right>0.00</TD></TR><TR><TD colSpan=4><B>Totals</B></TD><TD align=right>75.03</TD><TD> </TD><TD align=right>90.63</TD></TR><TR><TD colSpan=7>Denominator for Watts Conversion = 12.75</TD></TR></TBODY></TABLE><P></P>At the bottom of the sheet, add the two Totals columns. Most sailors find they use much more juice in the Underway column than in the At Anchor. Boats with powerhungry electronics, such as radar, SSB radio and electronic charting often use two or three times as much 12volt power when sailing. <P></P><P>Keep your spreadsheet in your maintenance log. Add new appliances to the spreadsheet when you install them and review it occasionally to see if your estimates on usage hours change.</P><P>Your spreadsheet is the basis to properly sizing all other components of your 12volt system. Many experts advise having two to four times the maximum amount of amperage used daily in each battery bank. For the sample spreadsheet, where 90 amps were used in 24 hours of sailing, this would result in banks of 180to360amp hours. Perhaps 270amphour banks would be a good compromise. These batteries would be onethird drawn down underway, but only onefourth depleted in 24 hours at anchor.</P><P>Our next two articles will deal with proper sizing of charging systems based on your spreadsheet. </P></HTML>

All times are GMT 4. The time now is 09:46 PM. 
Powered by vBulletin® Version 3.8.7
Copyright ©2000  2016, vBulletin Solutions, Inc.
vBulletin Security provided by
vBSecurity v2.2.2 (Pro) 
vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by
Advanced User Tagging v3.1.0 (Pro) 
vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
(c) Marine.com LLC 20002012