Conductor Analysis Spreadsheet

IN-PLACE CONDUCTOR / WELLHEAD / CONNECTION ANALYSIS TOOL -- Version 1.1 Well Name:

Example #1

Configuration Fixed Point Below Mudline 30.0 ft Wellhead Stick Up Above Mudline 30.00 ft LMRP/BOP Height ft 51 Conductor Specification OD Wall Thickness Grade Include secondary conductor? Include surface casing?

36.0 2.00 70 YES YES

in in ksi

Enter Vessel offsets (%) vs Shear loading at top conductor Vessel offset (%)

Shear load (kips)

0% 2% 4% 6% 8% 10%

10.0 30.0 50.0 70.0 90.0 110.0

Secondary Conductor Specification OD 28.0 in Wall Thickness 0.750 in Grade ksi 52 Surface Casing Specification OD in 22 Wall Thickness 1.000 in Grade ksi 80 Minimum Factor of safety - Pipe Minimum Factor of safety - Connection Other information Enter angle of rotation at top of BOP (bottom flex joint) Enter rotational stiffness of bottom flex joint Enter axial force at top of conductor (force from Riser) Wellhead Bending Strength

1.5 1.5

9.6 28.0 300 5000

deg kip-ft/deg kips kip-ft

Connection Specification HC-100 Tensile Yield Capacity 10250 kips Bending Moment Yield Capacity 7260 kip-ft Ultimate Tensile Yield Capacity 14040 kips Ultimate Bending Moment Yield Capacity 9650 kip-ft

SCHEMATIC DIAGRAM - BOP / WELLHEAD / CONDUCTOR

RUN

VME Factor of Safety

10.00

Example #1 Factor of Safety for Pipe Body vs % of Vessel Offset for 36 in OD;2 in Wall; X-70 Stick-Up: 30 ft; Fixed Point Below Mudline: 30 ft; LMPR/BOP Length: 51 ft Secondary Conductor Included?: YES Surface Casing Included?: YES Conductor Secondary Conductor Surface Casing

9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 0%

1%

2%

3%

4%

5%

6%

7%

8%

Vessel Offset (% of Water Depth)

9%

10%

Factor of Safety ( Plastic )

10.00

Example #1 Factor of Safety for Pipe Body vs % of Vessel Offset for 36 in OD;2 in Wall; X-70 Stick-Up: 30 ft; Fixed Point Below Mudline: 30 ft; LMPR/BOP Length: 51 ft Secondary Conductor Included?: YES Surface Casing Included?: YES Conductor Secondary Conductor Surface Casing

9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 0%

1%

2%

3%

4%

5%

6%

7%

8%

Vessel Offset (% of Water Depth)

9%

10%

Factor of Safety (FOS)

6.00

Example #1 Factor of Safety for Connection vs % of Vessel Offset for 36 in OD;2 in Wall; X-70 Stick-Up: 30 ft; Fixed Point Below Mudline: 30 ft; LMPR/BOP Length: 51 ft Secondary Conductor Included?: YES Surface Casing Included?: YES Elastic Plastic

5.00

4.00

3.00

2.00

1.00

0.00 0%

1%

2%

3%

4%

5%

6%

7%

Vessel Offset (% of Water Depth)

8%

9%

10%

Total M om e n t o n W e llhe ad (kip -ft)

Example #1 Wellhead Analysis Stick-Up: 30 ft; Fixed Point Below Mudline: 30 ft; LMPR/BOP Length: 51 ft Secondary Conductor Included?: YES Surface Casing Included?: YES

6000

5000

4000

3000

2000

1000

0

0%

1%

2%

3%

4%

5%

6%

7%

Vessel Offset (% of Water Depth)

8%

9%

10%