Description
What does this Excel Sheet do?
This Excel sheet helps you calculate the maximum Stacking height possible for Concrete Coated Steel Pipes when stacked in nested confirguration
The sheet also checks the strength of the dunnage on which the pipe is resting
How to use this Excel Sheet
The user is asked for some inputs to be provided. These include the Steel, Concrete and Corrosion Coating properties, and also the ground & dunnage properties
The user has to provide all the inputs highlighted in blue.
Once the inputs are provided, the app will calculate the stacking height limits for various load cases for Steel and Concrete separately
The final stacking height is the most conservative value from all load cases
Limitations
It can be used only for nested stacking configuration
Coating stress is ignored as it is not expected to be the guiding factor
References
1. Roark’s formula for Stress & Strain, 7th Ed, Table 14-4 Case 2
2. DNV RP-F-105 Sec 6.3.9
3. AISC ASD 9th Ed. Sec F2-1
Anonymous (verified owner) –
No comment
Manish Jain (verified owner) –
Very useful for cost estimation and optimization for concrete coated pipes shipment. Quite easy method to convince the most demanding clients about the shipment plans.
Team TheNavalArch (store manager) –
Dear Manish, many thanks for your review. Happy to know it worked