Oil Viscosity Correlation Comparison
Spreadsheet
34 rows x 4 columns
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Oil Viscosity Analysis | |||
| 2 | Fluid Properties | |||
| 3 | API Gravity | 30 | °API | |
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | Dead Oil Viscosity vs Temperature | |||
| 8 | Temperature (°F) | Uod (cp) | Viscosity Class | |
| 9 | 100 | 8.197112442 | Light | |
| 10 | 120 | 6.40322515 | Light | |
| 11 | 140 | 5.265794848 | Light | |
| 12 | 160 | 4.484278951 | Light | |
| 13 | 180 | 3.915671167 | Light | |
| 14 | 200 | 3.483905059 | Light | |
| 15 | 220 | 3.145032865 | Light | |
| 16 | ||||
| 17 | Saturated Oil Viscosity at T=180°F | |||
| 18 | Rs (scf/STB) | Uod (cp) | Uob (cp) | Viscosity Reduction (%) |
| 19 | 0 | 3.915671167 | 3.916586038 | 0 |
| 20 | 100 | 3.915671167 | 2.207269271 | 0.4364302867 |
| 21 | 200 | 3.915671167 | 1.583207249 | 0.5957685512 |
| 22 | 300 | 3.915671167 | 1.255838065 | 0.6793538932 |
| 23 | 400 | 3.915671167 | 1.052455137 | 0.7312825183 |
| 24 | 500 | 3.915671167 | 0.9129428844 | 0.7669034012 |
| 25 | 600 | 3.915671167 | 0.8107953867 | 0.7929841503 |
| 26 | ||||
| 27 | API Gravity Effect at T=180°F, Rs=300 scf/STB | |||
| 28 | API | Uod (cp) | Uob (cp) | |
| 29 | 20 | 16.07124678 | 3.326874856 | |
| 30 | 25 | 7.378264946 | 1.944330279 | |
| 31 | 30 | 3.915671167 | 1.255838065 | |
| 32 | 35 | 2.29686165 | 0.8691478306 | |
| 33 | 40 | 1.444197206 | 0.6310509579 | |
| 34 | 45 | 0.9533185792 | 0.4738127328 |
Description
Compare oil viscosity calculations showing the progression from dead oil through saturated conditions. Dead oil viscosity depends only on temperature and API gravity, while saturated oil viscosity also depends on solution GOR.
Viscosity Components:
- Dead Oil (Uod): Oil with no dissolved gas - highest viscosity
- Saturated Oil (Uob): Oil with dissolved gas - viscosity decreases with Rs
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Oil Viscosity Correlation Comparison
- 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.