Marine Templates - stability, structural, powering, weights & moments, stability tests, time & project logs, owners requirements Savitsky planing semi-displacement semi-planning resistance

Hawaii Marine Templates
Economical and free Excel, MathCAD & Word processing templates that save time & money.  Those involved with the Nautical, Engineering & Professional Sectors will benefit from these products.  Products here are suitable for use by Naval Architects, Marine, Ocean, Nautical, Structural, Civil & Mechanical Engineers, Ship, Yacht & Boat Designers, Sailors, Vessel Owners & Operators, Boat Builders, Construction Contractors, Attorneys & other Professionals.

Excel spreadsheets MathCAD Word boilerplate trim stability area centroid moment of inertia section modulus metacenter tank capacity characteristics waterplane hydrostatics tow tug sail CFR 49 waterline

E-mail - hmt@hawaii-marine.com    Web Site - http://hawaii-marine.com/templates
45-302 Makalani St., Kaneohe, Hawaii, USA   96744-2819
Phone/Fax (808) 247-6443


Planing Hull Calculations
(Crouch's Formula, English Units)

 

Description: This boilerplate spreadsheet performs planing boat powering calculations using Crouch's formula (a planing boat power prediction method).  Result graphs are automatically generated and show speed in knots versus brake horsepower required.  Because the input weight is important, this spreadsheet is setup to conveniently calculate the vessel's weight in various operational conditions.  This template also checks to see if the vessel will go it's intended range, if the installed horsepower is adequate and if the stern's quarter butt exit angle permits the input speed.

These calculations apply to planing vessels that operate at a speed length ratios, V / LWL1/2, of 3 and greater.  Vessel's must have a aft quarter butt exit angle of 2 degrees or less for these calculations to apply.  A example drawing of this angle is provided with the calculations.

These computations are based on procedures described by Skene's Elements of Yacht Design and Dave Gerr's Propeller Handbook.  Unless otherwise noted, the calculative procedures contained in this spreadsheet are primarily adapted from Reference D.  This reference is recommended reading.  The other references contain supplemental information, but they are not required for implementation or understanding of these calculations.  This template is designed to be used with English units.

There are advantages and benefits associated with this calculative method.  First this approach saves time.  Numerous computations are automatically and quickly done on your input data.  This approach is also cost effective because the calculations are already setup for you.  As a result your research time is minimized to familiarization of concepts when necessary and not in time consuming procedural development activities.
 

Electronic Document Type:  Microsoft Excel spreadsheet           Cost: $20 US funds
 

Number of Pages: Inputs Sheet, Output Sheet, References, Figure and Notes Sheet, Use Terms Page and Instructions Page.       
               

Inputs:  

bullet

Hull characteristics
bullet

Length Over All, LOA, feet (optional input)

bullet

Length of Waterline, LWL, feet

bullet

Beam on Waterline, BWL, feet (optional input)

bullet

Exit Angle, qAFT, of Aft Quarter Butt, an explanatory diagram is provided on the References Sheet of this template.  This value is critical for proper hull operation and it is therefore checked in this analysis.  For complet details about this requirement refer to Pages 12 and 13 of Reference D. 

bullet

Constant for Crouch's formula, representative values given on outputs sheet.  Alternatively this value may be calculated based on input (speed, weight and horsepower) provided from a similar vessel.

bullet

Weight information
bullet

Vessel light ship weight, pounds, the weight without any people, luggage, personal gear, provisions, stores, fluids or cargo on board

bullet

Weight margin on light ship, percent.  This is optional input and default values are provided.

bullet

Cargo weight, pounds, usually can be left at zero default value.  Examples of cargo weight are fuel drums on deck, weight of fish and ice on board.

bullet

Number of crew and number of passengers, integer

bullet

Additional equipment not included in light ship, pounds

bullet

Duration of voyage, days, for calculating provisions and stores, this value can often be left at it's default value which is equal to zero

bullet

Personal crew gear and passenger luggage, pounds, can be set to zero

bullet

Portions of total fluid capacities to be applied in analysis, default values that are set at 2/3 are provided, however these values may be specified as inputs.

bullet

Main propulsion fuel tank capacity, gallons, & fuel type (diesel or gasoline).  This is a highly recommended input value, if provided an estimate of the vessel's range will be automatically computed by this spreadsheet.

bullet

Potable water tank capacity, gallons

bullet

Sewage holding tank capacity, gallons

bullet

Propulsion Plant Details:
bullet

Installed brake horsepower, if unknown guess an amount, this value can be easily changed once these calculations are done.

bullet

Parasitic loads, horsepower, for pumps, generators, etc.

bullet

Continuous operating rpm, percentage of maximum, guideline values are given on the input sheet, simply select the applicable rpm percentage

bullet

Shafting efficiency, ratio, guideline values are given, select appropriate value

bullet

Propeller efficiency, ratio, a default value is present, however another value may be substituted in the calculations

bullet

Vessel range required, nautical miles, optional input.  If this value is specified this spreadsheet will automatically determine if the tanks provided are adequate to make the voyage distance specified by this input.

Outputs:  

bullet

For each of the input speeds the following is output are computed by this template:
bullet

Effective Horse Power, EHP

bullet

Brake Horse Power, BHP

bullet

Continuous Horsepower, BHP0

bullet

Estimated Range, nautical miles, from fuel consumption rate and tank capacity

bullet

The total operational weight is automatically computed based on light ship margin selected, cargo present, persons aboard, voyage duration which affects stores and provisions, selected operational tank capacities and gear on board.

bullet

Supplemental values like displacement length ratio, estimated maximum possible displacement speed, estimated fuel consumption rate, speed length ratios.

bullet

Calculative Checks are made for the following criteria:
bullet

Check if installed horsepower will meet the required horsepower needed for continuously operating at the speed computed.  It is important to know that If the speed involved is not a continuous operating speed this check should be ignored.  These speeds include those used for burst mode operation (operations only for short periods at this speed) and transitory speeds (when accelerating or decelerating towards a continuous operating speed).

bullet

Check if range requirements will be meet at the speed evaluated.  If this check is met the fuel tanks are adequately sized, if not the fuel tanks should be increased in size, but only for continuous operating speeds.

bullet

Check if hull bottom aft exit angle at quarter butt is appropriate for speed computed.  If this check is not met the bottom shape at the aft end of the hull should be flattened more so this speed can be reached by the hull.
 

Recommended Reading:

bullet

Reference A: Doug Shryverk, article entitled "Making Sense of Engine Options," Motor Boating and Sailing, February 1977 issue. 

bullet

Reference B: Valentine Jenkins, article entitled "Building Fast Boats that Don't Break," Professional Boatbuilder Magazine, Oct.-Nov. 1997 issue.

bullet

Reference C: Lorne Campbell, Letter to Editor regarding article entitled "Building Fast Boats that Don't Break," by Valentine Jenkins, Professional Boatbuilder Magazine, Oct.-Nov. 1997 issue.

bullet

Reference D: Dave Gerr, Propeller Handbook, International Marine, 1989, Camden, Maine.

bullet

Reference E: Dave Gerr, Nature of Boats, International Marine, 1995, Camden, Maine.

bullet

Reference F: John Teale, article entitled "Teale on Trawlers," Motor Boating and Sailing, June 1981 issue.

bullet

Reference G: Robert P. Beebe, article entitled "Trawlers - Designing by the Numbers," Motor Boating and Sailing, January 1977 issue.

bullet

Reference H: Alfred D. Isaacson, paper entitled "Sewage Polution Control: A Guide for the Ship Owner & Design," SNAME Marine Technology, July 1977 issue..

bullet

Reference I: S9086-C6-STM-010/CH-096R1 "Naval Ships' Technical Manual Chapter 096 Weights & Stability," NAVSEA, 2 August 1996.

bullet

Reference J: Detroit Allison Diesel, article entitled "Calculating Hull Speed," Motor Boating and Sailing, February 1978 issue.

bullet

Reference K: Robert P. Beebe and James F. Leishman, Voyaging Under Power, Third Edition, International Marine, 1994, Camden, Maine.

Terms: Prior to purchase, read our End User License Terms.

Download Now: click the following hyperlink to pay $20 fee and then immediately download the zip file containing the template.

Minimum System Requirements: Windows 95/98/NT/2000/XP

Sample: A sample of an output page is shown below.

Copyright © 1997- 2008 Hawaii Marine Company, 45-302 Makalani St., Kaneohe, HI   96744 - 2819 
U. S. A.   Phone/Fax Line: (808) 247-6443  
Emergencies (808) 291-0348.  This site last modified on: 03/07/08 09:54 PM.

emailCLR.gif (4349 bytes)

This web site created and marketed by Advanced Technology Associates Hawaii.  For questions or comments about this web site send e-mail to Brian Trenhaile at bt@atah.net.

flowani.gif (14628 bytes)