Rod String Stress Analysis
Spreadsheet
22 rows x 3 columns
| A | B | C | |
|---|---|---|---|
| 1 | Rod String Stress Analysis | ||
| 2 | |||
| 3 | Input Parameters | ||
| 4 | Rod Diameter | 0.875 | in |
| 5 | Rod String Length | 5000 | ft |
| 6 | Fluid Specific Gravity | 0.85 | |
| 7 | Fluid Load | 3500 | lb |
| 8 | Peak Polished Rod Load | 12000 | lb |
| 9 | Min Polished Rod Load | 4000 | lb |
| 10 | |||
| 11 | Rod Properties | ||
| 12 | Rod Area | 0.6013204689 | in2 |
| 13 | Weight in Air | 10210.42156 | lb |
| 14 | Buoyant Weight | 9099.527695 | lb |
| 15 | |||
| 16 | Rod Stretch | ||
| 17 | Total Static Stretch | 28.62104727 | in |
| 18 | |||
| 19 | Stress Analysis | ||
| 20 | Maximum Stress | 19956.08103 | psi |
| 21 | Minimum Stress | 6652.027009 | psi |
| 22 | Stress Range | 13304.05402 | psi |
Description
Rod string stress analysis for sucker rod pumping systems. Calculates rod weight, stretch, and stress levels for fatigue assessment.
Parameters:
- d: Rod diameter (in)
- L: Rod string length (ft)
- SG: Fluid specific gravity (dimensionless)
- Fo: Fluid load on plunger (lb)
- PPRL: Peak polished rod load (lb)
- MPRL: Minimum polished rod load (lb)
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Rod String Stress Analysis
- Click on the blueprint to preview the spreadsheet template
- Click Insert to place it into your worksheet. Modify the input values to match your data.