Cargo Forces and Accelerations – Multi-Cargo





This excel-based app calculates the accelerations on multiple Cargo being carried in the same shipment by a ship in the open ocean
For each cargo, it calculates the following:
a. Accelerations due to ship motions: It calculates the accelerations due to the ship’s roll, pitch and heave, depending on the size of the cargo and size of the Vessel, in accordance with DNVGL Guidelines
b. Wind Loads: It also calculates the wind loads coming onto the Cargo in accordance with the ABS Rules for MODU
b. Final Accelerations: It also calculates the final accelerations due to motions + wind loads and reports the accelerations in Longitudinal, Transverse, and Vertical Directions in terms of ‘g’

Directions for Use
1. All the cells which require input are in the Worksheet ‘Inputs’ and have a blue background. Please fill only input cells, i.e., ones with blue background. Leave the other cells untouched, as they are output cells
2. Fill in the inputs in the Worksheet ‘Inputs’
3. Once the ‘Inputs’ sheet is completed, accelerations will be automatically calculated in the Worksheets ‘Motion Forces’ and ‘Windloads’ and reported in the ‘Final Accelerations’ worksheet.

1. Cargo areas are taken considering it as a rectangular box
2. The standard motion criteria of DNVGL-ST-N001 Sec 11.7.2 are assumed to apply
3. Only to be used for open ocean condition
4. The cargo’s own moment of inertia is ignored. Cargo is considered as a point mass. Thus this spreadsheet should be used carefully with cargoes of big sizes which may have a substantial self moment of inertia
5. Phase differences between forces are ignored. This leads to conservative results
6. The forces are resolved in the following directions: Vertical – perpendicular to the deck. Transverse- parallel to the deck in the transverse direction, Longitudinal – parallel to the deck in the longitudinal direction
7. A maximum of 10 cargo items can be added

1. DNVGL ST-N001 2016, Sec 11.7.2

Additional information

License Type


There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Please visit our FAQ page for all questions on usage of our products. For any issues, please write to

FAQs on Products

Important: Our excel-based products work only on Windows machines, and not on Macs

System Requirements:

MS Excel 2013 and up

Windows 7 and up