Economical and free Microsoft Excel, Mathsoft MathCAD & Microsoft Word templates spefically designed to save you time and money. 

Hawaii Marine Templates Banner Pics
Hawaii Marine Templates
45-302 Makalani Street,
Kaneohe, HI, USA   96744-2819

Phone (808) 291-0348 
Fax (808) 247-6443
Hawaii Marine Company - naval architecture, boat & yacht design,  marine, nautical & offshore engineering, maritime expert witness, marine photography, NAVIC 10-92 submittals, nautical systems, professional engineer, stability tests, computer aided design and drafting services Those involved in nautical and professional engineering sectors can benefit from these products.  Products are suitable for use by Naval Architects, Marine, Ocean, Nautical, Offshore, Structural, Civil & Mechanical Engineers, Sailors, Ship, Yacht & Boat Designers, Vessel Owners & Operators, Boat Builders, Construction Contractors & others.
Home Page | Background | References | Stability Article | Trim Article | Barge Trim & Stability Article 
Composite EAM Article | Equivalent Area Method Example | Usage Terms | Privacy Policy | Tech Support
F. A. Q. | User Remarks | Resource Links | Related Links | Sail Boat Books | Nautical Books

Input/Output, Hydrostatics for One Waterline (English Units)

Description: This spreadsheet automatically computes hydrostatics characteristics for one waterline.  If the waterline is level this data may be used as an input source for the vessel's "Curves of Form."
     Though optional, this spreadsheet is best utilized in conjunction with a Displacement Sheet (Product Disp-e) and a Waterplane Sheet (Product WP-e).  A further enhancement is combining this sheet with a Displacement sheet and a Waterplane sheet.  In fact a product is available that combines all these sheets together, it is called Waterline Hydrostatics Data Sheet (Product WL-hydro-e).  This combination facilitates faster and easier computation for a given waterline.  In the combined case calculations are more automated, significantly minimizing entry input time.

Electronic Document Type:  Microsoft Excel spreadsheet           Cost: Free

Number of Pages: single sheet                        


  • The following dimensional and property input data are required:

    • Define the WL condition to be evaluated by entering the forward draft (TFWD), midships draft (TMID), aft draft (TAFT) and maximum draft (T).

    • Then enter in the waterline length (LWL), waterline beam (BWL), station spacing (s) and maximum hull cross sectional area (SA) below the waterline.

    • Then enter in the specific gravity (S) of the water that the vessel is in. If this is in regard to a stability test enter the average specific gravity taken at the time of stability test.

  • Items related to sectional area inputs:
    • Enter in the displaced volume (V), displacement (D), Longitudinal Center of Buoyancy (LCB) and vertical center of buoyancy (VCB).  This data is normally obtained from a displacement sheet which involves sectional area characteristics. Hawaii Marine's displacement sheet, product Disp-e, would work here. Alternatively calculative results obtained by hand calculations, CAD output or another source may inserted here.

  • Items related to half breadth inputs:
    • Enter in the waterplane area (AWP), longitudinal center of floatation (LCF), longitudinal moment of inertia (ILCF) and transverse moments of inertia (IT).  This data is normally obtained from a waterplane sheet which involves half beam characteristics. Hawaii Marine's waterplane sheet, product WP-e, would work here. Alternatively calculative results obtained by hand calculations, CAD output, planimeter or some another source may inserted here.

  • Optional Input Items:

    • Vessel name, project description, client and calculation date.


  • The automatic output generated are the tons per Inch (TPI), longitudinal metacentric radius (BML), transverse metacentric radius (BMT), distance from keel to longitudinal metacenter (KML), distance from keel to transverse metacenter (KMT), bock coefficient (CB), prismatic coefficient (CP), and miship's coefficient (CM).

Suggested Reading (see References page for more detail on these items):

  • Microsoft Excel user manuals

  • Principles of Naval Architecture, Edward V. Lewis, SNAME

  • Basic Ship Theory, Rawson & Tupper

  • Applied Naval Architecture, Robert B. Zubaly

  • Introduction to Naval Architecture, E. C. Tupper

  • Introduction to Naval Architecture, Thomas Gillmer and Bruce Johnson

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

Download Now: Click one of the following buttons to pay.  After payment you will be taken directly to the download page.

Download Now: Click the following link to download the free template.
Free Download

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

Sample: A sample document is shown below.