Home
Forms Library
Squat calculation formula excel

Ship squat calculator excel 2025

squat calculation formula excel Preview on Page 1

See 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 under keel clearance (UKC) before and after squat, maximum ship speed, and generate Speed vs UKC curves. 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.

How to use or fill out ship squat calculator excel with our platform

Ease of Setup

DocHub User Ratings on G2

Ease of Use

DocHub User Ratings on G2

Click ‘Get Form’ to open the ship squat calculator in the editor.
Begin by entering the vessel parameters in the blue-highlighted cells, including Length (L), Breadth (B), and Mean Draught (Tm). Ensure all values are accurate for precise calculations.
Input environmental parameters such as Water Depth (H) and Speed of Current (Uc) in their respective fields. This information is crucial for calculating squat accurately.
For maximum speed calculations, click on the 'Calculate' button after filling in all required inputs. The output will display the maximum speed achievable under given conditions.
To visualize data, utilize the buttons provided to generate Speed vs Underkeel Clearance curves. This feature enhances understanding of how speed affects UKC.

Start using our platform today to streamline your ship squat calculations for free!

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.

What is squat and its formula?

Squat may be calculated by the following simplified formulae: Squat = (CB X V2 ) / 100 (In open waters) Squat = 2 X (CB X V2 ) / 100 (In confined waters) #ShipSquatFormula: Find the approximate calculated squat of your vessel is proceeding to a channel #not enclosed with a width of 90 meters deep and dredge

What is a squat on a ship?

The drop of pressure below the ships bottom causes a vertical sinking of the ships hull in the water, at the same time and depending on the vessels block coefficient Cb she will trim forward or aft or will sink deeper into the water on even keel. The sum of all vertical sinking and trim is called SQUAT.

What is squat and UKC?

Squat: A major aspect of under keel clearance: A key term often seen along UKC is squat, a hydrodynamic phenomenon that can change the ships draught unexpectedly. Squat is the decrease in ships under keel clearance due to vessels movement in the shallow water.

What is the maximum squat of a ship?

At 8 knots, maximum squat is below 1 m, except for ULCC vessels which have a 1.17 m squat and a negative underkeel clearance that doesnt allow navigation. For other ships, water depth is sufficient, even for a VLCC vessel, which has an underkeel clearance of 3 m.

What is the squat and bank effect?

The restricted space underneath and alongside a vessel has a noticeable influence on both the running sink- age and trim of a vessel, also known as squat. A different bank geometry will obviously change the available space around the vessel.

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 Squat formula in confined waters Ship squat in open water and in confined channels Block coefficient formula

Related forms

be ready to get more

Complete this form in 5 minutes or less

Get form

When the block coefficient is 0.70, the vessel will squat by?

This is understood to be a function of the Block coefficient of the vessel concerned, finer lined vessels Cb 0.7 squatting by the head or bow.

How to calculate squat ship?

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.

What is the formula for squat?

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.

Ship squat calculator excel 2025

Here's how it works

How to use or fill out ship squat calculator excel with our platform

Complete this form in 5 minutes or less

Got questions?

What is squat and its formula?

What is a squat on a ship?

What is squat and UKC?

What is the maximum squat of a ship?

What is the squat and bank effect?

Complete this form in 5 minutes or less

People also ask

When the block coefficient is 0.70, the vessel will squat by?

How to calculate squat ship?

What is the formula for squat?

squat calculator ship

Try more PDF tools