Deep water pipelay capability spreadsheet

The purpose of this study was to help the client to investigate how high strength steels could extend the deep water pipelay capability of their vessels.

The study involved writing a MS Excel sheet which accepts user inputs on pipe, coating, vessels, costs and design criteria and calculates wall thickness, ovality, and combined loading stresses.  The spreadsheet then outputs a graph of maximum pipelay depth for up to ten cases with a given diameter, coating and vessel.  It also outputs a graph of minimum wall thickness and material/welding cost for the same cases.

The spreadsheet allows the client to assess the maximum pipelay depth in deep water and cost for a variety of inputs quickly and easily.