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