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.