Rod Pump System Design
Spreadsheet
29 rows x 3 columns
| A | B | C | |
|---|---|---|---|
| 1 | Rod Pump System Design | ||
| 2 | |||
| 3 | Well & Equipment | ||
| 4 | Pump Setting Depth | 5000 | ft |
| 5 | Plunger Diameter | 1.5 | in |
| 6 | Rod Diameter | 0.875 | in |
| 7 | Effective Stroke | 84 | in |
| 8 | Pumping Speed | 8 | SPM |
| 9 | |||
| 10 | Fluid Properties | ||
| 11 | Fluid Specific Gravity | 0.85 | |
| 12 | Fluid Level Above Pump | 4500 | ft |
| 13 | Fluid Gradient | 0.368 | psi/ft |
| 14 | |||
| 15 | Rod String | ||
| 16 | Rod Area | 0.6013204689 | in2 |
| 17 | Rod Weight in Air | 10210.42156 | lb |
| 18 | Buoyant Rod Weight | 9099.527695 | lb |
| 19 | |||
| 20 | Load Analysis | ||
| 21 | Plunger Area | 1.767145868 | in2 |
| 22 | Fluid Load | 2926.393557 | lb |
| 23 | Peak Load (PPRL) | 12025.92125 | lb |
| 24 | Minimum Load (MPRL) | 9099.527695 | lb |
| 25 | |||
| 26 | Production & Power | ||
| 27 | Theoretical Displacement | 138.4650679 | bbl/d |
| 28 | Ideal Counterbalance | 10562.72447 | lb |
| 29 | Polished Rod HP | 17.92462335 | HP |
Description
Integrated rod pump system design. Combines pump sizing, rod string analysis, load calculations, and power requirements for complete system evaluation.
Parameters:
- dp: Plunger diameter (in)
- dr: Rod diameter (in)
- L: Rod/pump setting depth (ft)
- Sp: Effective plunger stroke (in)
- N: Pumping speed (SPM)
- SG: Fluid specific gravity (dimensionless)
- H: Fluid level above pump (ft)
- G: Fluid gradient (psi/ft)
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Rod Pump System Design
- 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.