Home
Forms Library
Squat calculation formula excel

Ship squat calculator excel 2025

squat calculation formula excel Preview on Page 1

Show details

4.1 out of 5

58 votes

The document provides a Ship Squat Calculator in Excel format, designed to calculate the squat of a ship when navigating shallow waters. It outlines two methods for squat calculation: the DNV Formula for open water and the Barrass formula applicable for both open water and confined channels. The spreadsheet allows users to input various vessel and environmental parameters to determine underkeel clearance (UKC) before and after squat, maximum ship speed, and generate related graphs. Additionally, it includes terms of use and liability disclaimers.

Here's how it works

01. Edit your squat calculation formula excel online

Type text, add images, blackout confidential details, add comments, highlights and more.

02. Sign it in a few clicks

Draw your signature, type it, upload its image, or use your mobile device as a signature pad.

03. Share your form with others

Send ship squat calculator via email, link, or fax. You can also download it, export it or print it out.

The best way to modify Ship squat calculator excel online

Ease of Setup

DocHub User Ratings on G2

Ease of Use

DocHub User Ratings on G2

With DocHub, making adjustments to your paperwork requires just a few simple clicks. Follow these quick steps to modify the PDF Ship squat calculator excel online free of charge:

Sign up and log in to your account. Sign in to the editor using your credentials or click on Create free account to evaluate the tool’s features.
Add the Ship squat calculator excel for editing. Click on the New Document option above, then drag and drop the document to the upload area, import it from the cloud, or using a link.
Modify your file. Make any adjustments required: insert text and images to your Ship squat calculator excel, highlight important details, remove sections of content and substitute them with new ones, and insert icons, checkmarks, and fields for filling out.
Finish redacting the form. Save the modified document on your device, export it to the cloud, print it right from the editor, or share it with all the people involved.

Our editor is super easy to use and effective. Try it out now!

be ready to get more

Complete this form in 5 minutes or less

Get form

Got questions?

We have answers to the most popular questions from our customers. If you can't find an answer to your question, please contact us.

How to calculate UKC and squat?

Predicting UKC for a ship in shallow water [Net UKC] = [Chart datum depth] + [Tide] -[Static draft] -[Squat, heel and wave response] (1) This article proposes a new method to assist with under-keel clearance (UKC) management, using realtime kinematic (RTK) GPS receivers.

What is the formula for squat?

Maximum squat in open waters = (Cb x V^2 )/100. Maximum squat in confined waters: Applicable only to confined channels where S = 0.1 to 0.265.

What is the formula for ship squat?

Ships squat Solution: This is the ships squat formula on open waters and the unit of the answer will be meter. Squat = Block Coefficient x Speed /100 = (0.8 x 7)/100 = (0.8 x 49)/100 = 39.2 / 100 #Squat = 0.392 m Again, the example above is that we get the value of the ships squat in open waters.

What is squat and its formula?

Ans. The simplified formula commonly used for vessels in unrestricted waters (open water conditions) reads as follows: Squat = 0.01 x Cb V2 m. In restricted waters (confined water condition), increased value of squat is found as follows: Squat = 0.02 x Cb V2 m.

What is the formula for ship drag?

The drag equation states that drag D is equal to the drag coefficient Cd times the density r times half of the velocity V squared times the reference area A. For given air conditions, shape, and inclination of the object, we must determine a value for Cd to determine drag.

ukc calculation excel

Ship squat calculator excel pdf Ship squat calculator excel free download Ship squat calculator excel download Ship squat calculator excel free Best ship squat calculator excel Ship squat calculation formula Ukc calculation excel Squat formula in confined waters

What is the formula for ship tonnage?

tonnage, in shipping, the total number of tons registered or carried or the total carrying capacity. Gross tonnage (GT) is calculated from the formula GT = K1V, where V is the volume of a ships enclosed spaces in cubic metres and K1 is a constant calculated by K1 = 0.2 + 0.02 log10 V.

What is the formula for squat on a vessel?

By various calculations, shipping scholars have got a defining value (0.7) of block coefficient. If the block coefficient is 0.7, the vessel will squat bodily. If the block coefficient is less than 0.7, the vessel will squat by stern. Finally if the block coefficient is more than 0.7, the vessel will squat by bow.

How to do squat calculation?

Maximum squat in open waters = (Cb x V^2 )/100 At this point, a consideration may arise as to the depth of water, which can be considered shallow. This depends on the depth of influence of the ship, which is approximately 5/Cb x draft. In depths above the depth of influence, the ship may be considered in shallow waters.