Creating a 12-Volt Spreadsheet - SailNet Community
LinkBack Thread Tools
post #1 of 1 Old 06-29-1999 Thread Starter
Contributing Authors
Join Date: Jan 2000
Posts: 266
Thanks: 0
Thanked 12 Times in 8 Posts
Rep Power: 18
Creating a 12-Volt Spreadsheet

Generating, storing, and using 12-volt 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 12-volt spreadsheet are usually disappointing. And since every sailor uses electricity differently, a 12-volt spreadsheet needs to be developed.

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 old-fashioned way with paper, pencil, and calculator.

We've found that two spreadsheets are necessary, and we do them side-by-side. 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.

When setting up your spreadsheet, don't forget to incorporate items that you plan to add in the future. Heavy electrical users like12-volt refrigeration, SSB radio, or radar will upset the whole plan if not included.

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.

Set up the column with these headings:

Appliance, Watts, Amps, Hours at Anchor, Hours Underway, Total Hours at Anchor, and Total Hours Underway

Sit at the boat's 12-volt 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.

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.

Specification sheets showing 12-volt draw in watts will require a simple calculation to convert it to amps. For your spreadsheet, the formula is: watts divided by volts = amps. In round numbers, a 12-volt 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.

Example: a halogen reading light is quoted by the manufacturer as 20 watts. That's: 20 / 12.75 = 1.57 amps.

If an inverter is running 120-volt 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 12-volt power.

Next, estimate the number of hours each appliance is used during a 24-hour day. Do this twice; once in the At Anchor column, and again in the Underway column. Use tenths of hours (six minutes = one-tenth hour) to keep the math simple.

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 12-volt power used by each appliance in 24 hours.

Now your spreadsheet should look like this:

12-Volt Spreadsheet
Hours UsedTotalHours UsedTotal
Appliance/ElectronicsWattsAmpsat Anchorat AnchorUnderwayUnderway
Running Lights
Reading Lights20.001.573.455.410.000.00
Anchor Light10.000.789.507.450.000.00
Navigation Instruments 0.500.000.0024.0012.00
Refrigerator 6.008.5051.008.0048.00
LPG Solenoid16.001.251.401.760.500.63
Microwave Popcorn1200.0094.120.109.410.000.00
Totals75.03 90.63
Denominator for Watts Conversion = 12.75

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 power-hungry electronics, such as radar, SSB radio and electronic charting often use two or three times as much 12-volt power when sailing.

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.

Your spreadsheet is the basis to properly sizing all other components of your 12-volt 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 180-to-360-amp hours. Perhaps 270-amp-hour banks would be a good compromise. These batteries would be one-third drawn down underway, but only one-fourth depleted in 24 hours at anchor.

Our next two articles will deal with proper sizing of charging systems based on your spreadsheet.

Tom Wood is offline  
Closed Thread

Quick Reply

By choosing to post the reply above you agree to the rules you agreed to when joining Sailnet.
Click Here to view those rules.

Register Now

In order to be able to post messages on the SailNet Community forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
Please note: After entering 3 characters a list of Usernames already in use will appear and the list will disappear once a valid Username is entered.

User Name:
Please enter a password for your user account. Note that passwords are case-sensitive.


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:


Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page

Posting Rules  
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is Off
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

For the best viewing experience please update your browser to Google Chrome