Waterplane Sheet (English Units)
For a given input waterline this spreadsheet
computes hydrostatic waterplane area characteristics
relating to station half beam inputs. Basically it sums the
area under a half beam (or waterline) curve to obtain the waterplane area,
it takes moments to obtain the longitudinal center of floatation and
computes moments of inertia in both the transverse and longitudinal
If the input waterline is level, the data obtained may be used as an
input source for a vessel's "Curves of Form." Inputs are
based on a Lines Drawing with ten stations starting at zero and ending at
Station Ten. This Lines Drawing has customary half stations at each
end to compensate for vessel fineness. The numerical integrations
contained in these calculations are based on Simpson's Rules.
Though optional, this spreadsheet is best utilized in
conjunction with a Displacement
Sheet (Product Disp-e)
and Waterline Input/Output Sheet (Product
A further enhancement is dynamically combining this sheet along with a
Displacement Sheet and a Waterline Input/Output Sheet. The product that combines
all these sheets together is called a Waterline Hydrostatics Data Sheet
(Product WL-hydro-e). This
later enhanced combination facilitates faster and easier
computation for a given waterline. In the combined case, calculations
are more automated, significantly minimizing the data entry input time.
Document Type: Microsoft Excel
$10.00 US funds
Pages: Includes an template (or input)
sheet, along with an example sheet, an instructions
sheet and a use terms sheet.
automatic output generated by this spreadsheet are the
waterplane area (A),
Longitudinal center of floatation (LCF),
longitudinal moment of inertia about the LCF
and Transverse Moment of Inertia about Centerline (IT).
Note the LCF obtained is the distance from Station 5.
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
Prior to purchase, read our
User License Terms.
Important Notice to European Union Buyers:
Due to changes in international law, we no longer accept
purchases from any 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.
Click one of the following buttons to pay.
After payment you will be taken directly to the download page.
System Requirements: Windows 95/98/NT/2000/XP/Vista/Windows7
A sample document is shown below.