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


Advanced Sailboat Parameter Calculations & Checks
(English Units)
 

 

Description: This spreadsheet takes you input values for your sail boat and automatically calculates many of your sail boat's numerical characteristics (ratios, coefficients and parameters).  Then this spreadsheet presents various target values allowing you to quickly check and compare your sailboat's characteristics with other similar successful sail boats.  

There are several advantages and benefits to this calculative approach.  Some of these advantages are listed below.

bullet

First this method saves time.  Many of computations are quickly generated behind the scenes on your input data.   Also to modify, simply change a value in the spreadsheet and it will automatically and immediately recalculates all affected values.

bullet

Second this approach provides clear and neat documentation. 

bullet

Third this approach is cost effective because the calculative approach is already developed for you, research time is minimized to the familiarization of concepts when necessary and not to time consuming development activities.

bullet

Fourth this template is kept simple, it contains no Excel macros and there is no Visual Basic code utilized in it's creation.  Also advanced Excel features such "Goal Seek," "Solver" and "Scenarios" are not used.

bullet

Fifth, because this is a spreadsheet and not a program, the users can easily modify it to suit their particular needs. 


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

Organization and Content:

bullet

Inputs (all inputs marked with an asterisk * are affected by the vessel condition under evaluation.  This vessel condition may be light condition, half load or full load condition, or some other condition.  All asterisk values must change when the vessel condition changes.)

bullet

Inputs Sheet 1

bullet

Weight or Displacement, D, pounds, usually half load condition *

bullet

Ballast Weight, pounds, WB, in keel and in hull.

bullet

Draft, Waterline Draft, feet, from waterline to bottom of keel *

bullet

Draftc, Canoe Draft, feet, from waterline to bottom of hull *

bullet

Length Over All, LOA, feet (includes spars, bow pulpits etc.)

bullet

Length of Hull, L, LOH or LOD (for older vessels), feet (length of hull's watertight envelope stem to stern.  This does not include spars, bow pulpits, swim-steps etc., Length on Deck is the same value, except for vessels with reverse transoms, in which case the length is extended to the bottom end of the transom)

bullet

Length of Waterline, LWL, feet *

bullet

Hull Beam, Maximum, Bmax, feet (for hull only, does not include rub rails, fenders, etc.)

bullet

Maximum Waterline Beam, BWL, feet * (this value can be estimated, where BWL = 0.9 x Bmax)

bullet

Freeboard Forward, FFWD, feet*, waterline to top of hull forward

bullet

Freeboard Aft, FAFT, feet*, waterline to top of hull aft

bullet

Length of Waterline, LWL, feet *

bullet

Maximum Cross Sectional Area, Amax, square feet* (maximum cross sectional area below the waterline, this value may be found on a sectional area curved for the condition under evaluation)

bullet

Sail Area, SA, square feet, (total sail area which includes all the fore-triangle, the main, and other normal sails present {like half the area of mizzens on ketches and yawls and all the foresail area on schooners}.  It does not include stay sails nor does it include spinnakers and jibs in the fore triangle.)

bullet

Wetted Surface, WS, square feet* (hull surface area below the waterline, including fin, rudder and skeg)

bullet

Total Lateral Plane Area, ALP, square feet,* for full keeled boats this is the longitudinal projected area below the waterline including the rudder, for other boats this is just the projected area of the keel or the centerboard(s)

bullet

Weight Density of Water, g, pounds per cubic foot, 64 for salt water and 62.4 for fresh water

bullet

Exit Angle of Quarter Beam Butt, q, degrees, a example figure of this angle is provided with the spreadsheet.  This angle is used to determine if the boat is capable of planing or not.

bullet

Heeling Arm, HA, feet* (vertical distance from the center of effort of sails to the center of lateral plane of the underwater profile)

bullet

Lead, feet* (horizontal distance from the center of effort of sails to the center of lateral plane of the underwater profile)

bullet

Half Entrance Angle of Hull, a, degrees* (for waterline under evaluation)

bullet

Evaluation Operational Speed, VOP, knots (the sail boat speed that you want the spreadsheet to evaluate, this need not be the speed that the vessel can go)
 

bullet

Inputs Sheet 2  (these inputs are noted as "optional" and need not have numerical values assigned to them.  In other words this spreadsheet will automatically estimate a value if one is not specified.  If you wish the spreadsheet to estimate this value make sure that the value of the optional input is set to zero!  If you know the actual value, of an optional input, it is highly recommended that the actual value be inserted as an input, so that the spreadsheet does not automatically estimate it.  Remember actual values are superior to estimated values and they will generate more accurate results.)

bullet

Waterline Beam, BWL, feet,* maximum waterline beam

bullet

Waterplane Area, AWP, square feet* (horizontal area enclosed by the hull at the waterline.  This value may be estimated with the following formula where AWP = 0.67 x LWL x BWL.)

bullet

Vertical Center of Buoyancy, KB or VCB, feet,* vertical distance from Baseline to centroid of displaced volume.

bullet

Metacentric Radius, BM, feet,* in the transverse direction

bullet

Vertical Center of Gavity, KG or VCG, feet,* distance from Baseline

bullet

Metacentric Height, GM, feet,* where GM = KB + BM - KG.

bullet

Operational Roll Period, TOP, seconds,* boat full roll period while in operational condition

 

bullet

Outputs the following values are automatically calculated by this spreadsheet, in addition definitions, formulas, comments and various target values are normally presented for quick reference on each output.

bullet

Sail Hull Form Parameters Outputs 1

bullet

Displaced Volume, V, cubic feet

bullet

Waterplane Coefficient, CWP, dimensionless

bullet

Midship's Coefficient, CM, dimensionless

bullet

Sail Hull Form Parameters Outputs 2

bullet

Half Entrance Angle of Hull, a, degrees (acceptable target values are presented for this input)

bullet

Pounds per Inch, PPI, pounds per inch of immersion

bullet

Moment to Trim 1 Inch, MTI, foot pounds per inch trim of trim, this is an estimated value.

bullet

Length Ratio Outputs for Sailboat Characteristics

bullet

Length Beam Ratio, L/Bmax, dimensionless.  High values indicate large form stability, faster speeds (if light boat) and larger interior volume. Low values indicate gentler motions and normally safer blue water performance.

bullet

Waterline Length - Waterline Beam Ratio, LWL/BWL, dimensionless

bullet

Overhang Ratio, OR = LOD/LWL, dimensionless

bullet

Draft Ratio Outputs for Sailboats

bullet

Length to Draft Ratio, LWL/Draft, dimensionless

bullet

Length to Canoe Draft Ratio, LWL/DraftC dimensionless

bullet

Beam to Draft Ratio, BWL/Draft, dimensionless

bullet

Beam to Canoe Draft Ratio, BWL/DraftC, dimensionless

bullet

Freeboard Ratio Outputs for Sailboat Characteristics

bullet

Forward Freeboard Ratio, FFR = FFWD/LWL, dimensionless

bullet

Forward Ratio, FR = FFWD/FAFT, dimensionless

bullet

Speed Parameters for Sailboats

bullet

Operational Speed Length Ratio, SLR = VOP/LWL1/2

bullet

Recommended Operational Speed, VFN = Fn(g x LWL)1/2/1.689 based on an optimum Froude Number equal to 0.35, knots

bullet

Recommended Optimum Speed Length Ratio, SLRFN = VFN/LWL1/2

bullet

Maximum Speed Length Ratio based on DLR, SLR1 = 8.26 / DLR0.311

bullet

Maximum Speed Length Ratio based on Bottom Exit Angle, SLR2

bullet

Maximum Speed Based on DLR & Bottom Exit Angle, Vmax knots, this speed based the the lesser of SLR1 and SLR2.

bullet

Displacement Hull Speed, VHULL = 1.34 x LWL1/2 knots, maximum speed for a normal displacement hulls. This value is based on a speed length ratio (SLR) equal to 1.34. At this speed length ratio the length of the wave generated by the hull is equal to the length of the hull. However, this barrier speed does not apply to all sailboat hulls. Hulls that are very light with flat exit angles and wide beams may exceed this value and go into semi-displacement or semi-planing or even planing mode. Also hulls that are very narrow and light, like racing catamarans, can exceed this speed.

bullet

Velocity Ratio, VMAX/ VHULL = 1.88 LWL1/2SA1/3/D1/4)/ VHULL based on length, sail area, displacement and hull speed

bullet

Maximum Speed based on Velocity Ratio, knots, where VMAX =
(VMAX/ VHULL ) VHULL maximum speed
based on velocity ratio

bullet

Sail Boat Speed Maximum Expected based on all above, knots, where VME equals the greater of Vmax and  VMAX

bullet

Recommended Optimum Speed Length Ratio, SLRFN = VFN/LWL1/2

bullet

Displacement and Length Parameters for Sailing Vessels

bullet

Displacement Length Ratio, DLR = (D/2240)/(LWL/100)3, long tons / cubic feet.  Generally the vessel with the lower value will be the faster vessel. But ideal values depend on the speed length ratio range that the vessel is operating at.  Design lanes for optimal DLRs as a function of speed length ratio are given in the references.

bullet

Length Displacement Ratio, LDR = LWL / V1/3 dimensionless

bullet

Prismatic Coefficient for Sail Boats

bullet

Prismatic Coefficient, CP = V / (AMAXLWL) dimensionless

bullet

Various Parameters Involving Sails

bullet

Sail Area Displacement Ratio, SADR = SA / V2/3 dimensionless. The SADR is a measure of the power available to push the load (the displacement). Generally, the higher the value the faster the boat, provided the boat is stiff enough to handle the larger sail areas.

bullet

Sail Area Wetted Surface Ratio, SA/WS, dimensionless.  This ratio is an indicator sail boat performance in light and medium air.  

bullet

Sail Area Lateral Plane Ratio, (ALP/SA)100 percentage

bullet

Ballast Ratio for Sailing Vessels

bullet

Ballast Ratio, where BR = WB/D dimensionless. This is an indicator of stability, but it is not a very accurate one. This is because this ratio does not differentiate between bulb ballast at the bottom of the keel and ballast in the fin keel or hull. Since the location of the ballast is not taken into consideration only boats with similar ballast arrangements should be considered.

bullet

Sailboat Lead Characteristics (check for acceptable values)

bullet

Sail Boat Lead % = [(CP - CE)/LWL]100 =  (Lead/LWL)100

bullet

Stability Outputs for Sailing Craft, Sheet 1

bullet

Righting Arm at 20 degrees (estimated), GZ20 = (BWL/T)2/14.84, feet

bullet

Righting Arm at 30 degrees (estimated), GZ30 = (BWL/T)2/11.00, feet

bullet

Righting Arm at 30 degrees (estimated), GZ'30 = 0.03LWL4/D, feet

bullet

Righting Moment at 30 degrees (estimated), RM30 = the larger of GZ30D or GZ'30D, foot pounds

bullet

Screening Stability Value, used for calculating capsize screening value, SSV = (BMAX/3.28084)2/(BR x (DraftC/3.28084) x (V/3.280843)1/3)

bullet

Angle of Vanishing Stability, AVS = 110 + (400/(SSV-10)), degrees

bullet

Stability Outputs for Sailing Craft, Sheet 2

bullet

Capsize Risk Factor (or Capsize Screening Factor), where
CSF = BOA / V1/3 dimensionless. 
This parameter is an indication of a vessel's ability to resist capsizing in a violent storm.   This factor is concerned with dynamic stability in which weight and beam are predominate factors.

bullet

Roll Acceleration, AROLL = 2p(T)2Radius(qROLLp/180)/32.2

bullet

Stability Index, SI = T /(BOA x 0.3048)

bullet

Sail Boat Stiffness Factors, Sheet 1

bullet

Righting Moment at 20 degrees, RM20 = GZ20D, foot pounds

bullet

Heeling Moment at 20 degrees, HM20 = SA x HA x cos2(20 degrees)xP foot pounds, where P is 1 pound per square foot wind pressure

bullet

Wind Pressure Coefficient (Type 1), WPC = RM20/HM20 dimensionless

bullet

Righting Moment at 20 degrees (Type 2), RM'20 = DGM sin(20 degrees)foot pounds, more approximate than Type 1

bullet

Wind Pressure Coefficient (Type 2), WPC = RM'20/HM20 dimensionless

bullet

Sail Boat Stiffness Factors, Sheet 2

bullet

Upright Heeling Moment, UHM = SA x HA x P, where P is wind pressure at1 pound per square foot, results in foot pounds

bullet

Heeling Moment for 1 Degree, HM1 Degree = D x GM x Sin(1 degree) results in foot pounds

bullet

Dellenbaugh Angle, DA = UHM / HM1 Degree

bullet

 Sailing Vessel Comfort Factors

bullet

Roll Period, seconds, evaluate period input value with target values that are presented in this section

bullet

Comfort Ratio, CR = D / (0.65 x (0.7xLWL + 0.30xLOA) x Bmax1.333). This term was developed by yacht designer Ted Brewer.  Large numerical values of this parameter indicate a boat with a smoother, steadier and more comfortable motion in a seaway.  Therefore the CR parameter favors heavy sail boats with lots of overhang and a narrow beam.  Since these factors slow down a boats response in heavy weather.  

bullet

Waterplane Loading, WPL = (D/2240)/AWP, this is a heave factor comfort check

bullet

Maximum Recommended Waterplane Loading, where
WPLR = a x (D/2240)2 + b x (D/2240) + c

bullet

Factor of Safety on Waterplane Loading, FSWPL = WPL / WPLR values less than one are acceptable
 

bullet

Informational Sheets

bullet

Figures Sheet for Sailing Vessel Spreadsheet, one sheet

bullet

CP versus SLR

bullet

CP versus Fn

bullet

CP and DLR versus SLR

bullet

Quarter Beam Buttock Angles

bullet

References and Notes, one sheet

bullet

Instructions, 1 sheet

bullet

Use Terms, 2 sheets

bullet

Formulas (these sheets are for interpolations and extrapolations of target data, they are normally not included with printed output) 5 sheets.
               

Recommended Reading:

bullet

Books
bullet

Reference B-A: Arthur Edmunds, Designing Power & Sail, page 193, 1998, Bristol Fashion Publications, Harrisburg, PA.

bullet

Reference B-B: SNAME, Principles of Naval Architecture, Volumes I and II, 1988, Society of Naval Architects & Marine Engineers, Jersey City, NJ

bullet

Reference B-C: Dave Gerr, Propeller Handbook, International Marine, 1989, Camden, Maine.

bullet

Reference B-D: C. A. Marchaj, Seaworthiness, the Forgotten Factor, Chapter 4 - Boat Motions in a Seaway, 1986, International Marine, Camden, Maine.

bullet

Reference B-E: Edward M. Brady, Marine Salvage Operations, Cornell Maritime Press, 1960, Cambridge, Maryland.

bullet

Reference B-F: Dave Gerr, Nature of Boats, International Marine, 1995, Camden, Maine.

bullet

Reference B-G: Howard I. Chapelle, Yacht Designing and Planning, 1971, W. W. Norton & Company, Inc., New York, NY.

bullet

Reference B-H: Norman L. Skene and Francis S. Kinney, Skene's Elements of Yacht Design, 1973, Dodd, Mead & Company, Inc., New York, NY.

bullet

Reference B-I: Juan Baader, The Sailing Yacht, Second Edition, 1979, W. W. Norton & Company, Inc., New York, NY.

bullet

Reference B-J: Lars Larsson and Rolf E. Eliasson, Principles of Yacht Design, Second Edition, 2000, International Marine, Camden, Maine.

bullet

Reference B-K: Pierre Guttelle, The Design of Sailing Yachts, 1984, International Marine Publishing Company, Camden, Maine.

bullet

Reference B-L: Robert G. Henry & Richards T. Miller, Sailing Yacht Design, 1965, Cornell Maritime Press, Inc., Cambridge, Maryland.

bullet

Reference B-M: K. Adlard Coles & Peter Bruce (editors), Adlard Coles' Heavy Weather Sailing, 30th edition, Chapter 2 Sailing Yachts in Large Breaking Waves, pages 11-23, International Marine, Camden, Maine.

bullet

Reference B-N: C. A. Marchaj, Sailing Theory and Practice, 1964, Dodd, Mead & Company, New York, New York.

bullet

Reference B-O: C. A. Marchaj, Aero-Hydrodynamics of Sailing, 1979, Dodd, Mead & Company, New York, New York.

bullet

Reference B-P: Douglas H. C. Birt, Sailing Yacht Design, 1951, Robert Ross & Co. Limited, Southampton, UK.

bullet

Reference B-Q: Andrew G. Hammitt, Technical Yacht Design, 1975, Van Nostrand Reinhold Company, New York, New York.

bullet

Reference B-R: D. Phillips-Birt, The Naval Architecture of Small Craft, 1957, Hutchinson & Company, London, UK.

bullet

Papers
bullet

Reference P-A: Robert G. Henry and Richards T. Miller, Sailing Yacht Design - An Appreciation of a Fine Art, pages 425-490, SNAME Transactions, Volume 71, 1963 issue, Society of Naval Architects & Marine Engineers, Paramus, NJ.

bullet

Reference P-B: Richards T. Miller and Karl L. Kirkman, Sailing Yacht Design - A New Appreciation of a Fine Art, pages 187-237, SNAME Transactions, Volume 98, 1990 issue, Society of Naval Architects & Marine Engineers, Paramus, NJ.

bullet

Articles
bullet

Reference A-A: Ted Brewer, Is Your Boat Stable?, http://www.boatus.com/goodoldboat/stability.htm, Article
from Good Old Boat magazine: Volume 3, Number 2, March/April 2000.

bullet

Reference A-B: Ted Brewer, Brewer By the Numbers, www.boatus.com/goodoldboat/brewerformulas.htm, Article
from Good Old Boat magazine: Volume 3, Number 2, March/April 2000.

bullet

Reference A-C: Roger Marshall, Design By the Numbers, Motor Boating & Sailing magazine: September 1981.

bullet

Reference A-D: Roger Marshall, Design Calculatons, The Design Process Part III, Article from Boatbuilder Magazine, November/December 2004.

bullet

Web Sites
bullet

Reference W-A: John Holtrup, Several articles including: "Design Basics," Fuzzy Logic," "Estimating Stability," "Plots from Data Base," "Dynamic Stability," and "Best Offshore Cruising Boats" - updated 20 June 2000," www.johnsboatstuff.com/technica.htm.

bullet

Reference W-B: Michael Kasten, "Sail Area Ratios," http://www.kastenmarine.com/sail_area_ratios.pdf, 2001.

bullet

Reference W-C: Dan Pfeiffer, "Sailboat Design Ratios," http://dan.pfeiffer.net/boat/ratios, 2003.

bullet

Reference W-D: SailingUSA.info, "Angle of Vanishing Stability," http://www.sailingusa.info/cal_avs.htm and formulas.htm, 2001.

bullet

Reference W-E: SailingUSA.info, "Keelboat Course - Design & Stability," http://www.sailingusa.info/design_winds.htm, 1999 - 2002.

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

Download Now: click the following hyperlink to pay $50 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.


Similar Sailing Boat Product
There is another Microsoft Excel spreadsheet available that is much more concise.  It calculates the main or primary parameters for multiple sail boats for quick comparison.   You can check this other spreadsheet's characteristics by going to the Sail Boat Parameters Spread Sheet.  
 

 

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)