Excel Spreadsheet for Bollard Pull Calculations (Barge)
A spreadsheet to calculate the required bollard pull to Tow a Barge.
What does this App do?
This app helps the user calculate the static bollard pull required to HOLD a barge in a given environment (tow by head)
The calculated required Bollard Pull can be used to select the right sized tug for towing a Barge
Alternatively, it can be used to check whether a selected tug is suitable for towing a Barge of not
How to use this app?
The Excel Sheet has two different sections: Inputs and Calculation
Principal particulars of the Barge and the dimensions of Cargo are to be provided in the ‘Inputs – Vessel & cargo’ worksheet
The environment inputs for calculation of static bollard pull (STALL condition) are to be provided in the ‘inputs – Environment’ worksheet
Once inputs have been provided, the app calculates the Static Bollard Pull and the Limiting Speed
For some inputs, Tables and charts are required to be referred. These Tables and charts are provided alongwith for the user to enter these inputs.
The input cells are all in blue. All parameters are in SI units
It can be used only for Cargo height upto 91.5 m from sea level
Cargo is taken to be rectangular in section
Shielding effects are ignored when calculating the windage area of cargo/superstructures
1. DNV-RP-H103, 2011, Sec 7.2.6
2. DNV-ST-N001 Table 11.13
3. ABS Rules for Building and Classing Mobile Offshore Drilling Units, 2019, C 3-1-2/1.3.2
Version Date Remarks
0.0 Oct-13 First issue
1.0 Mar-15 Updated to latest DNV rules for Additional Wave resistance
2.0 Sep-18 Typos corrected
3.0 May-20 Updated to retain DNV method. Multiple cargo option added
Anonymous (verified owner) –
Leslie Jackson (verified owner) –
Navaltik Portugal (verified owner) –
alfonso garcia (verified owner) –
Lex van der Schaaf (verified owner) –
Works fine, little bit difficult to enter all parameters, as some unknown beforehand, outcome indications are however in line with reality.
Maybe useful to limit input a little bit, if possible and make the program more userfriendly
Luca Di Rosa (verified owner) –
Nice spreadsheet, all clear and straightforward!
Ingemar Curtsell (verified owner) –
Very useful for our assessment engineering.
Marvin Weakly (verified owner) –
Excellent – exactly what I needed
Team TheNavalArch (store manager) –
Thanks Marvin. Happy to know
Glenn W. (verified owner) –
Found it very easy to use accurate I highly recommend.
Matthew Fenton (verified owner) –
Needed better instructions on how to make this work after download.
David Hawes (verified owner) –
The spreadsheet works very well and allows the user to try out various scenarios with ease. But the best thing about this the extraordinary customer service. I needed to do a tandem tow. Asked and expertly answered. I will renew.
BOBBY KURNIAWAN (verified owner) –
Excellent application that is very useful