WELCOME: EXCEL ENGINE FOR SHIP CARGO ACCELERATIONS

What this Excel Sheet does

This excel sheet calculates the accelerations on a Cargo being carried by a ship
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 Nobledenton 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 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.
Assumptions
1.Cargo areas are taken considering it as a rectangular box
2.The standard motion criteria of Nobledenton are assumed to apply
3.Unrestricted Operation is assumed (Open Sea 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 cargo of big sizes which may have
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 deck. Transverse- parallel to deck in transverse direction, Longitudinal - parallel to deck in
longitudinal direction
References
1.Nobledenton Guidelines for Marine Transportation (0030-ND)Rev 5, June 2013
2.ABS RULES FOR BUILDING AND CLASSING MOBILE OFFSHORE DRILLING UNITS, 2001, C 3-1-2/1.3.2-1.3.3
Company Name: CARGO FORCES AND ACCLERATION CALCULATION
Project Name:
Doc. No:
Date:
Revision No:
Prepared By:
Page 2 of 8
CARGO FORCES AND ACCELERATIONS

General Particulars Cargo Particulars Shape factors for wind calculations

Shape Cs
Valu Particul
Units Value Units Spherical 0.40
e ar
Acceleration due to g 9.8100 m/s2 ITEM Name Cargo 1 Cylindrical Shapes (all sizes) used for crane pedestals, booms, helidecks, etc. 0.50
Gravity
ρai
Density of air 1.23 kg/m3 Weight M 1000.00 MT Hull, based on block projected area 1.00
r
Weight Contingencies(factor) f 1 - Deck houses 1.25
Length l 28.4 m Clusters of deck houses and other structures, based on block projected area 1.20
Valu Units Width w 27.8 m Isolated structural shapes (e.g., cranes, angle channel beams, etc.) 1.30
e
Vessel Name Barge 1 Height h 72.5 m Under deck areas (smooth)
Longitudinal Distance of Cargo
Overall Length L 86.00 m COG from Midship Xcg 0 m Under deck surface (exposed beams and girders) 1.40
Transverse Distance of Cargo COG
from Vessel Centerline 1.50
Overall Breadth B 27.50 m Ycg 0 m Rig derrick, each face, assuming fabricated from angle.
Vertical Distance of Cargo COG Table 1: Cargo Shape Coefficients1
Overall Depth D 5.50 m from Vessel Deck Zd 40 m
1 Source: ABS Rules for Building and Classing
Draft (Motion Centre)* T 2.10 m Cargo Shape Coefficient(Front)** Csf 1 Mobile Offshore Drilling Units, 2012, C 3-1-2/1.3.2

Block Coefficient CB 0.89 - Cargo Shape Coefficient(Side)** Css 1

** See Table 1 on the right for Shape Coefficients

Valu Units
e
Vw
Wind Speed 8.20 m/s
ind
*Motion Centre is assumed at the height of Waterline
vertically
Company Name: CARGO FORCES AND ACCLERATION CALCULATION
Project Name:
Doc. No:
Date:
Revision No:
Prepared By:
Page 3 of 8
Motion Forces Calculation

Cargo Details
Parameter Nomenclature Value Units
Cargo Name Cargo 1
Design Weight W=Mxf 1000.00 MT
Distance of CoG from Centre of Rotation*
Longitudinal Distance from Centre of Xcg 0.00 m
Rotation
Transverse Distance from Centre of Ycg 0.00 m
Rotation
Vertical Distance from Centre of Rotation Zcg = Zd + D - T 43.40 m
*The Centre of Rotation is assumed located at Midship Longitudinally, Centreline Transversely and Waterline Vertically

Design Conditions (from Nobledenton)1

Vessel L/B Ratio RLB 3.1 -
Roll Angle Фroll 20 deg.
Time Period Troll 10 s
Pitch Angle Фpitch 12.5 deg.
Time Period Tpitch 10 s
Heave Period Theave 10 s
Heave acceleration aheave 1.96 m/s2
1 Source: Nobledenton Guidelines for Marine Transportation (0030-ND), Rev 5, June 2013, Sec 7.9.1
Company Name: CARGO FORCES AND ACCLERATION CALCULATION
Project Name:
Doc. No:
Date:
Revision No:
Prepared By:
Page 4 of 8

FORCES
A. STATIC FORCES
A.1 ROLL FORCES
1. Vertical Force = WCosФroll
1.Vertical Roll Force (Static) FZRS WCosФroll
= 939.69 MT

2.Horizontal Roll Force FYRS WSinФroll

(Static)
= 342.02 MT
A.2 PITCH FORCES
1.Vertical Force (Static) FZPS WCosФpitch
= 976.30 MT

2.Horizontal Force (Static) FXPS WSinФpitch

= 216.44 MT

B. DYNAMIC FORCES
B.1 ROLL FORCES
1.Vertical Force FZRD W*4*π2*Ycg*Фroll/(Troll2*g)

= 0.00 MT

2.Horizontal Force FYRD W*4*π2*Zcg*Фroll/(Troll2*g)

= 609.66 MT
B.2 PITCH FORCES
W*4*π2*Xcg*Фpitch/
1.Vertical Force FZPD
(Tpitch2*g)
= 0.00 MT
W*4*π *Zcg*Фpitch/
2
2.Horizontal Force FXPD
(Tpitch2*g)
= 381.04 T
B.3 HEAVE-ROLL FORCES
1.Vertical Force FZHRD W*aheave*Cos(Фroll)/g)
= 187.75 T
2.Horizontal Force FYHRD W*aheave*Sin(Фroll)/g)
= 68.33 T
B.4 HEAVE-PITCH FORCES
1.Vertical Force FZHPD W*aheave*Cos(Фpitch)/g)
= 195.06 T
2.Horizontal Force FXHPD W*aheave*Sin(Фpitch)/g)
= 43.24 T
Company Name: CARGO FORCES AND ACCLERATION CALCULATION
Project Name:
Doc. No:
Date:
Revision No:
Prepared By:
Page 5 of 8

Maximum Motion Forces in Longitudinal and Transverse Directions

Forc
Direction Formula Units
e
Transverse, FTM FYRS+FYRD+FYHRD 1020.01 MT
Longitudinal, FXPS+FXPD+FXHPD 640.72 MT
FLM
F
o
Combined Vertical Forces r
Direction Case Heave Direction m Force Units
Roll to Starboard Heave Down u FZRS + FZRD + FZHRD 1127.44 MT
Longitudina Transverse

l FZRS + FZRD - FZHRD

Roll to Starboard Heave Up a 751.95 MT
Roll to Port Heave Down FZRS - FZRD + FZHRD 1127.44 MT
Roll to Port Heave Up FZRS - FZRD - FZHRD 751.95 MT
Pitch to Fwd Heave Down FZPS + FZPD + FZHPD 1171.36 MT
Pitch to Fwd Heave Up FZPS + FZPD - FZHPD 781.24 MT
l

Pitch to Af Heave Down FZPS - FZPD + FZHPD 1171.36 MT

Pitch to Af Heave Up FZPS - FZPD - FZHPD 781.24 MT
Company Name: CARGO FORCES AND ACCLERATION CALCULATION
Project Name:
Doc. No:
Date:
Revision No:
Prepared By:
Page 6 of 8

Basic Parameters *Please see Table 1 in Worksheet "Input" for shape coefficient
Particulars Notation Value Units
Cargo Name Cargo 1
Cargo Length l 28.4 m
Cargo Width w 27.8 m
Height of Cargo Bottom from BL H1 5.5 m
Height of Cargo Top from BL H2 78.0 m
Cargo Shape Coefficient (Front) CSF 1
Cargo Shape Coefficient (Side) CSS 1

Density of Air ρ 0.00123 MT/m3

Wind Speed Vwind 8.2 m/s

(Based on
Cargo Height Coefficients Height from Vessel Baseline)

Ch (Height
Zone Height from (m) Height to (m) Coefficient)
Zone 1 2.1 17.4 1.00
Zone 2 17.4 32.6 1.10
Zone 3 32.6 48.1 1.20
Zone 4 48.1 63.1 1.30
Zone 5 63.1 78.1 1.37
Zone 6 78.1 93.6 1.43

Cargo Areas in Transverse and Longitudinal Direction Factored for Height Coefficient Ch
Height
Area Height to Ch Area Transverse, AT Area Longitudinal, AT*Ch*CSF AL*Ch*CSS Cargo Height Coefficients ( Based o
from AL
Item (m) (m) (-/-) (m2) (m2) (m2) (m2) Zone Height from
Zone 1 2.1 17.4 1.00 330.8 338.0 330.8 338.0 Zone 1 0.0
Zone 2 17.4 32.6 1.10 422.6 431.7 464.8 474.8 Zone 2 15.3
Zone 3 32.6 48.1 1.20 430.9 440.2 517.1 528.2 Zone 3 30.5
Zone 4 48.1 63.1 1.30 417.0 426.0 542.1 553.8 Zone 4 46.0
Zone 5 63.1 78.1 1.37 417.0 426.0 571.3 583.6 Zone 5 61.0
Zone 6 78.1 93.6 1.43 0.0 0.0 0.0 0.0 Zone 6 76.0
Table 1: Wind Pressure Height Coefficients
Classing
Total Factored Windage Area Σ (AT*Ch*CSF) Σ (AL*Ch*CSS)
2426 2478

Wind Force in Longitudinal direction FWX = 1/2*ρ*Vwind2*Σ (AT*CSF*Ch) 10.23 MT

Wind Force in Transverse direction FWY = 1/2*ρ*Vwind2*Σ (AL*CSS*Ch) 10.45 MT
Coefficients ( Based on Height from Waterline)
 (Height to (m) Ch (Height Coefficient)
15.3 1.00
30.5 1.10
46.0 1.20
61.0 1.30
76.0 1.37
91.5 1.43
Height Coefficients1 1 Source: ABS Rules for Building and
 CARGO FORCES AND ACCLERATION CALCULATION
Company Name:
Doc. No:
Date:
Project Name:
Revision No:
Prepared By: Final Forces and Accelerations
Page 7 of 8
FORCES ACCELERATIONS
Forces - Transverse Direction Final Accelerations(Motion + Wind)
Force Value Units Direction Value Units
Transverse Motion Force, FTM 1020.01 MT Longitudinal (Max.) , aLmax 0.651 g
Transverse Wind Load, FTW 10.45 MT Transverse (Max.) ,aTmax 1.030 g
Total Transverse Force, FT 1030.46 MT Vertical (Max.),aVmax 1.171 g
Vertical (Min.),aVmin 0.752 g
Forces - Longitudinal Direction
Force Value Units
Longitudinal Motion Force, FLM 640.72 MT
Longitudinal Wind Load, FLW 10.23 MT
Total Longitudinal Force, FL 650.95 MT

Forces - Vertical Direction

Force Value Units
Maximum Vertical Force, FVMAX 1171.36 MT
Minimum Vertical Force, FVMAX 751.95 MT
Terms and Conditions
License Terms – Simple general usage terms are as follows:
1.When a template or software is purchased only one person may use it. If more people will be using
the same template or software, purchase multiple copies of the template or software equal to the
amount of people using it.
2.A non-exclusive conditional license to use templates or software is what is being purchased on this site. Copies of these template

3.These products are non-transferable. You may not purport to give anyone else rights in the
templates or software. You many not allow anyone else to have your licensed copies of templates or
software.
4.Template users assume all liability for their usage. It is up to the template or software user to verify
that all the data they incorporate, all spreadsheet or software changes they incorporate and all initial
spreadsheet and software algorithms are correct.

Liability Statement – www.thenavalarch.com has meticulous strove to assure the accuracy and quality of these templates
For instance: the input data could be corrupt, the spreadsheet or software could be improperly modified, or some other unforeseea

Please contact us us so that we may be able to correct the problem. Thank you.
Legal Disclaimer Statement – All templates, software, notes, documentation, pages and other
information are provided "as is," without warranty of any kind, either expressed or implied, including
without limitation, fitness for a particular purpose or performance. By using the templates, software or
acting on any information included within this web site, YOU AGREE TO
ASSUME THE ENTIRE RISK, for any result, performance, or lack of performance, including damage
to data and/or damage to property.
Neither the webmaster, site owner, agents, nor any third parties shall be liable to you, for -ANY-use of
these templates, software or content (including ANY INABILITY to use), for its performance, for any
incidental or consequential damages, and/or ANY claim by ANY other party.