Economical and free Microsoft Excel, Mathsoft MathCAD & Microsoft Word templates specially 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
website: www.hawaii-marine.com/templates
email: bt@hawaii-marine.com
Hawaii Marine Company - naval architecture, boat & yacht design,  marine engineering, maritime expert witness, marine photography, NAVIC 10-92 submittals, nautical systems, professional engineer, stability tests, computer aided design and drafting services Those involved with the nautical, & professional engineering sectors can benefit from these products.  Products are suitable for use by Naval Architects, Marine, Ocean, Nautical, Structural, Civil & Mechanical Engineers, Sailors, Ship, Yacht & Boat Designers, Vessel Owners & Operators, Boat Builders, Construction Contractors and 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

Hawaii Marine Templates

Templates quickly eliminate laborious computational tasks and as an added bonus give your work a neat & professional appearance.  Some Excel, MathCAD & Word templates on this website can benefit almost anybody, this includes professionals like attorneys, contractors, technicians, skilled labor, researchers, and scientists, not just marine types.  It is a lot easier to apply a template than it is to create from scratch and then format it for presentation and printing.  So leveraging your efforts (by incorporating the work of others), gives your work a polished look and saves yourself time and money too!

That said, most of the spreadsheets and templates on this site are especially suited for utilization by nautical specialists.  This includes naval architects, ship design engineers, marine engineers, ocean engineers, dredge engineers, marine salvage engineers, maritime regulators, boat designers and yacht designers. 

Never the less, in many cases these templates can be used by many types of non-nautical engineers. For example structural engineers, mechanical engineers, civil engineers, petroleum engineers, and engineering technicians.

Ship, commercial boat & yacht owners and operators can also benefit from boiler plate templates in this site.

There are also general business tracking templates that can be easily utilized by most professionals.  Lawyers, paralegals, expert witnesses, scientists, researchers, contractors, technicians, draft-persons and any others that charge by the hour, go by cost plus, labor and materials or simply want to track their expenses as they occur.

Important Notice to European Union Buyers: Due to changes in international law, we no longer accept purchases from individuals located within an EU country.  However, businesses located within the EU are allowed to make purchases, provided that they make the VAT payments for any imported items purchased electronically.  These EU businesses must specify their VAT number in the memo section on the Paypal payment pages.  These changes are effective as of July 1, 2008, and were modified for EU businesses on April 9, 2010.  

Naval War Ship   Large TEU Container Ship Underway

Template Index

Name (click titles for more info) Program
Required
Cost Download
Weights and Moments Sheet - English Units, from weights and centroids (cgs) of components it computes total weight and centroids (cgs) of all elements combined.  Product ID Number: WM-e.  MS Excel

... more info

Free Download Now!
Weights and Moments Sheet - Metric Units, from weights and centroids (center of gravities, cgs) of components it computes total weight and centroids, centers of gravities, of all elements combined.  Product ID Number: WM-m.  MS Excel

... more info

Free Download Now!
       
Area Properties for Large or Complex Cross Section including Midships Section - English Units  General used for ship cross sections, but can be used to obtain properties for any large or complex structural cross section.  From component sectional area properties, this template computes the total sectional area properties of the all the components combined.  This includes total area, area center, moment of inertia and section modulus.  Product No. SMs-e. MS Excel

... more
details

$32.00
Area Properties for Large or Complex Cross Section include Amidships Sections - Metric Units  General used for ship cross sections, but can be used to obtain properties for any large or complex structural cross section.  From component sectional area properties, this template computes the total sectional area properties of the all the components combined.  This includes total area, area center, moment of inertia and section modulus.  Product No. SMs-m. MS Excel

... more
details

$32.00
       
Section Modulus for Framing Members - English Units  From component sectional area properties, this quick and neat template computes the total sectional area properties of the all the components combined.  This includes total area, area center, section modulus and moment of inertia.  Product No. SMF-e. MS Excel

... more
details

$20.00

Section Modulus for Framing Members - Metric Units  From component sectional area properties, this quick and neat template computes the total sectional area properties of the all the components combined.  This includes total area, area center, section modulus and moment of inertia.  Product No. SMF-m. MS Excel

... more
details

$20.00

 
Area Properties for Composite Cross Sections, Equivalent Area Method - English Units  General use for simple frames or for large or complex structural cross sections.  From component sectional area properties, this template computes the total cross section transformed area properties of the all the components combined.  This includes total transformed area, area center, moment of inertia and material section modulus values. Limited to two material types.  Product No. SMc-e. MS Excel

... more
details

$35.00
Area Properties for Composite Cross Sections, Equivalent Area Method - Metric Units  General use for simple frames or for large or complex structural cross sections.  From component sectional area properties, this template computes the total cross section transformed area properties of the all the components combined.  This includes total transformed area, area center, moment of inertia and material section modulus values. Limited to two material types.  Product No. SMc-m. MS Excel

... more
details

$35.00
 

Additional MathCAD Area Property Templates (Properties Include Total Area, Centroid, Moment of Inertia and Section Modulus (English Units)

Angle Iron and Attached Plating Cut Angle Iron and Attached Plating
Fabricated Angle Iron & Plating Cut Fabricated Angle Iron & Plating
Tee Bar & Attached Plating Cut Tee Bar and Attached Plating
Fabricated Tee Bar and Plating Cut Fabricated Tee Bar and Plating
Flat Bar and Attached Plating Cut Flat Bar and Attached Plating
       
Quick Box Barge (Pontoon) Trim, List, GM Initial StabilitySummary - English Units 
Calculates total weight, the weight centers of the total weight, the loaded draft, trim and list angles, forward and aft drafts at the four corners and along centerline for a simple box barge either with deck cargo or a crane and with hook load, or both.  This is an excellent teaching tool for assimilating the basic concepts of GM stability. 
Product No. QBrg-e.
MS Excel

... more
details

$75.00

Quick Box Barge (Pontoon) Trim, List, GM Initial StabilitySummary - Metric Units 
Calculates total weight, the weight centers of the total weight, the loaded draft, trim and list angles, forward and aft drafts at the four corners and along centerline for a simple box barge either with deck cargo or a crane and with hook load, or both.  This is an excellent teaching tool for assimilating the basic concepts of GM stability. 
Product No. QBrg-m.
MS Excel

... more
details

$75.00

       
Tankage Summary - English Units  From individual tank properties this convenient spreadsheet calculates the cumulative effect of all tanks combined.  This includes each tank's and the combined free surface effects.  For each tank, the user may select a value from zero to one hundred percent full.  Product No. Tanks-e. MS Excel

... more
details

$10.00

Tankage Summary - Metric Units  From individual tank properties this convenient spreadsheet calculates the cumulative effect of all tanks combined.  This includes each tank's and the combined free surface effects.  For each tank, the user may select a value from zero to one hundred percent full.  Product No. Tanks-m. MS Excel

... more
details

$10.00
       
Trim & Stability Sheet - English Units  For a given vessel condition, this spreadsheet computes trim present and metacentric height.  Curves of Form inputs, Light Ship, passenger, crew, cargo and consumables weight information are required.  This spreadsheet only works accurately if the trim obtained from it is less than 1% of vessel length.  Product # TS-e. MS Excel

... additional
information

$35.00

Trim & Stability Sheet - Metric Units  For a given vessel condition, this spreadsheet computes trim present and metacentric height.  Curves of Form inputs, Light Ship, passenger, crew, cargo and consumables weight information are required.  This spreadsheet only works accurately if the trim obtained from it is less than 1% of the vessel length.  Product No. TS-m. MS Excel

... additional
information

$35.00

       
Displacement Sheet (Sectional Area Curve) - English Units  For a given vessel condition, with sectional area inputs this spreadsheet does numerical integrations using Simpson's Methods.  It computes displaced volume, weight, longitudinal and vertical centers of buoyancy.  Product Number Disp-e. MS Excel

... additional
information

$10.00


Waterplane Sheet (Half Breadth Inputs) - English Units For a given vessel condition, with half breadth inputs this spreadsheet does numerical integrations using Simpson's Methods.  It computes waterplane area, longitudinal center of floatation, longitudinal and transverse moment of inertias.  Product # WP-e. MS Excel

... additional
information

$10.00


Waterline Input/Output Sheet - English Units  Input for this sheet are combined data from the Displacement Sheet, Waterplane Sheet, draft data and maximum cross sectional area.  This sheet outputs tons per inch, longitudinal & transverse metacentric radii, longitudinal and transverse metacenter heights from Baseline, block coefficient, prismatic coefficient and midships coefficient.  Product Number WL-IO-e. MS Excel

... additional
information

Free Download Now!
Waterline Hydrostatics Sheet - English Units  At a given waterline condition, this template computes a vessel's hydrostatics characteristics.  It combines and streamlines the Displacement Sheet, Waterplane Sheet and the Waterline Input/Output Sheet.  If this sheet is utilized for three waterlines, "Curves of Form" can be generated from the combined output. 
Product # WL-hydro-e.
MS Excel

... additional
information

$15.00


       
Towline Pull, Static Criterion (English Units) for Z-Drive Vessels  This template checks a vessel equipped to tow for compliance with 46CFR173.095(b).  This template applies only to vessels that are equipped for towing and have Z-Drives for propulsion (i.e. Tractor Tugs, Offshore Supply Vessels, Work Boats and Fish Boats). 
Product # TowStZ-e.
MS Excel

... additional product data

Free Download Now!
Towline Pull, Static Criterion (Metric Units) for Z-Drive Vessels  This template checks a vessel equipped to tow for compliance with 46 CFR 173.095(b).  This template applies only to vessels that are equipped for towing and have Z-Drives for propulsion (i.e. Tractor Tugs, Offshore Supply Vessels, Work Boats and Fish Boats). 
Product # TowStZ-m.
MS Excel

... additional product data

Free Download Now!
Towline Pull, Dynamic Criterion (English Units) for Z-Drive Vessels  This template checks a vessel equipped to tow for compliance with 46 CFR 173.095(c) - (f).  This template applies only to vessels that are equipped for towing and have Z-Drives for propulsion (i.e. Tractor Tugs, Offshore Supply Vessels, Work Boats and Fish Boats). 
Product # TowDyZ-e.
MathCAD

... additional product data

$40.00


Towline Pull, Dynamic Criterion (Metric Units) for Z-Drive Vessels  This template checks a vessel equipped to tow for compliance with 46 CFR 173.095(c) - (f).  This template applies only to vessels that are equipped for towing and have Z-Drives for propulsion (i.e. Tractor Tugs, Offshore Supply Vessels, Work Boats and Fish Boats). 
Product # TowDyZ-m.
MathCAD

... additional product data

$40.00


Tow Vessel, Dynamic Weather Criterion (English Units)  This template checks a vessel equipped to tow for compliance with 46CFR174.145(a) - (f).  This template applies only to vessels that are equipped for towing (i.e. Tractor Tugs, Offshore Supply Vessels, Work Boats and Fish Boats).  Product # TowWth-e. MathCAD

... additional product data

$30.00


Tow Vessel, Dynamic Weather Criterion (Metric Units)  This template checks a vessel equipped to tow for compliance with 46 CFR 174.145 (a) - (f).  This template applies only to vessels that are equipped for towing (i.e. Tractor Tugs, Offshore Supply Vessels, Work Boats and Fish Boats).  Product # TowWth-m. MathCAD

... additional product data

$30.00


Displacement & Semidisplacement Hull Powering Calculations (English Units)  This template calculates displacement & semi-displacement (or semi-planing) hull powering requirements utilizing two separate methods.  The first method is applicable to a wide range of vessel types.  The second method applies to trawler with optimized displacement length ratios and prismatic coefficients.  A range of input speeds are evaluated and plotted.  Product # Pwr-Disp.

MS Excel

... additional
information

$35.00

Planing Hull Powering Calculations with Crouch's Constant (English Units)  This template calculates planing hull powering requirements using Crouch's Constant.  Calculations are made and plotted for a range of input speeds.  It applies only to planing speeds in which the speed length ratio is equal to or greater than three.  It also calculates fuel consumption rate for all input speeds.  Product # Pwr-Plng.

MS Excel

... additional
information

$25.00

Savitsky Planing Hull Calculations (English Units)  This method (either Long or Short Form) is one of the primary methods applied by experienced boat designers and naval architects to compute the hydrodynamic powering characteristics of planing vessels.  This boilerplate spreadsheet is designed to be simple to use, yet options are present for an experienced expert to tweak the calculations as desired.  Product # Savitsky.

MS Excel

... additional
information

$75.00

Advanced Sailing Boat Parameters with Recommended Target Values This spreadsheet automatically calculates an extensive list of sailboat parameters and presents recommended target values for instant assessment. Definitions for the various parameters are given and usually accompanied by commentary.  Outputs include displacement length ratio, sail area displacement ratio, sail wetted surface area ratio, length to beam ratio, hull speed, ballast ratio, capsize factor and comfort factor.  Product Number ASail-e. MS Excel

... additional product data

$50.00

Sailboat Parameter Calculations & Comparison Sheet  This spreadsheet automatically computes various primary ratios and parameters allowing quick comparisons between similar sailing boats. Outputs include displacement length ratio, sail area displacement ratio, sail wetted surface area ratio, length to beam ratio, hull speed, ballast ratio, capsize factor and comfort factor.  Product Number Sail-e. MS Excel

... additional product data

$20.00

Project Time Log (Dollar Currency)  This handy spreadsheet automatically computes computes elapsed time spent and labor cost for each session along with cumulative time and labor cost for a project.  Ideal for keeping track of project labor data. Product Number TL-Dollars. MS Excel

... additional product data

$5.00


Owner's Requirements Form - English Units  This handy information request form is normally given to people who are seeking ship, yacht and boat design services.  Among other things information includes expected approximate vessel size, hull type, service requirements, operational zones, budgetary information, equipment requirements and accommodations that are desired.  It also helps prospective home boat builders to focus on their vessel goals. Product ID Number: OWNR-RQM.  MS Word

... more info

Free Download Now!
 
Ferry Passenger Vessel Round Bottom Lobster Boat Container Freighter Unloading with Cranes

The following templates are 
planned for release at a later date

  • Curves of Form Sheets.  This involves a summary table that is dynamically tied into three or more draft evaluation sheets. 

  • Powering Calculations - Make metric versions of the the presently available power templates in English units.  Additional planing calculative regimes that includes slow speed planing boat operation, trim tab effects, appendage resistance and air resistance to the Savitsky spreadsheet already available.

  • Fishboat Stability Calculations - MathCAD templates for Torremolinos dynamic intact criterion, water on deck criteria, severe wind and wave criteria.  Calculations in English units and as per 46 CFR 28.500 Subpart E - Stability.

  • Mooring Analysis - obtaining proper scope for depth, chain or line size.  Results are dependent on vessel size and proportion inputs.

  • Propeller Matching - obtaining propeller horsepower and rpm as a function of speed and checking it against the propulsion units characteristics.

  • Seakeeping Motion Checks - to avoid resonant parametric coupling of roll, pitch and heave.  This is effect is sometimes called Dutch rolling.

  • Dynamic Loading Effects - The inertial effects of ships motions on weights are computed with this MathCAD template.

  • Simplified Stability Test Calculations - multiple page spreadsheet, Excel template.  

  • Stability Test Booklet - multiple page spreadsheet, Excel template. 

  • Advanced Sailboat Parameters Template - make this available also in metric units.  It is presently available only in English units.

  • Dynamic Stability Criteria, Vessels of Unusual Form - multiple page MathCAD template.

  • Rudder Spreadsheet Calculations - determining required area, shaft size, etc.

  • Plus much more ... contact us, at hmt@hawaii-marine.com,  if you have an immediate need, maybe we already have a template for it!