Petroleum Engineering Unit Conversions
Comprehensive unit conversion reference for petroleum engineers. Live input cells in each category update all conversions automatically. Covers pressure, temperature, volume, rate, GOR, density, viscosity, compressibility, length, area, and permeability.
Petroleum Engineering Unit Conversions
Excel workbook
Inputs
Named cells you can edit — every result recalculates from them.
| Name | Description | Default | Unit |
|---|---|---|---|
P_psi |
Pressure (psi) | 2000 | psi |
T_F |
Temperature (degF) | 200 | degF |
Visc_cp |
Viscosity (cP) | 1.5 | cP |
Ct_1psi |
Compressibility (1/psi) | 1.5e-5 | 1/psi |
V_bbl |
Volume (bbl) | 1000 | bbl |
Ql_stbd |
Liquid Rate (STB/d) | 5000 | STB/d |
Qg_Mscfd |
Gas Rate (Mscf/d) | 10000 | Mscf/d |
GOR_scfstb |
GOR (scf/STB) | 500 | scf/STB |
Rho_lbft3 |
Density (lb/ft3) | 62.4 | lb/ft3 |
L_ft |
Length (ft) | 10000 | ft |
A_acres |
Area (acres) | 640 | acres |
K_mD |
Permeability (mD) | 100 | mD |
D_in |
Diameter (in) | 4.5 | in |
3 sheets, shown with the values the file opens with
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Pressure & Temperature Conversions | |||||
| 2 | Enter any value in the yellow input cells. All conversions update automatically using PO.UnitConverter. | |||||
| 3 | ||||||
| 4 | Pressure | |||||
| 5 | Pressure (psi) | 2000 | psi | |||
| 6 | bar | 137.8951459 | bar | |||
| 7 | kPa | 13789.51459 | kPa | |||
| 8 | MPa | 13.78951459 | MPa | |||
| 9 | atm | 136.0919278 | atm | |||
| 10 | ||||||
| 11 | Temperature | |||||
| 12 | Temperature (degF) | 200 | degF | |||
| 13 | degC | 93.33333333 | degC | |||
| 14 | K | 366.4833333 | K | |||
| 15 | degR | 659.67 | degR | |||
| 16 | ||||||
| 17 | Viscosity | |||||
| 18 | Viscosity (cP) | 1.5 | cP | |||
| 19 | Pa.s | 0.0015 | Pa.s | |||
| 20 | mPa.s | 1.5 | mPa.s | |||
| 21 | ||||||
| 22 | Compressibility | |||||
| 23 | Compressibility (1/psi) | 1.5E-05 | 1/psi | |||
| 24 | 1/bar | 0.0002175566066 | 1/bar | |||
| 25 | 1/kPa | 2.175566066E-06 | 1/kPa |
| A | B | C | |
|---|---|---|---|
| 1 | Volume & Rate Conversions | ||
| 2 | |||
| 3 | Volume | ||
| 4 | Volume (bbl) | 1000 | bbl |
| 5 | m3 | 158.9872949 | m3 |
| 6 | ft3 | 5614.583333 | ft3 |
| 7 | gallon (US) | 42000 | gal |
| 8 | |||
| 9 | Liquid Rate | ||
| 10 | Liquid Rate (STB/d) | 5000 | STB/d |
| 11 | m3/d | 794.9364746 | m3/d |
| 12 | |||
| 13 | Gas Rate | ||
| 14 | Gas Rate (Mscf/d) | 10000 | Mscf/d |
| 15 | MMscf/d | 10 | MMscf/d |
| 16 | m3/d | 283168.4659 | m3/d |
| 17 | |||
| 18 | Gas-Oil Ratio | ||
| 19 | GOR (scf/STB) | 500 | scf/STB |
| 20 | m3/m3 | 89.05380334 | m3/m3 |
| 21 | |||
| 22 | Density | ||
| 23 | Density (lb/ft3) | 62.4 | lb/ft3 |
| 24 | kg/m3 | 999.5521145 | kg/m3 |
| 25 | g/cm3 | 0.9995521145 | g/cm3 |
| A | B | C | |
|---|---|---|---|
| 1 | Length, Area & Permeability Conversions | ||
| 2 | |||
| 3 | Length | ||
| 4 | Length (ft) | 10000 | ft |
| 5 | m | 3048 | m |
| 6 | in | 120000 | in |
| 7 | km | 3.048 | km |
| 8 | |||
| 9 | Area | ||
| 10 | Area (acres) | 640 | acres |
| 11 | ft2 | 27878511.51 | ft2 |
| 12 | m2 | 2589998.47 | m2 |
| 13 | |||
| 14 | Permeability | ||
| 15 | Permeability (mD) | 100 | mD |
| 16 | D | 0.1 | D |
| 17 | |||
| 18 | Pipe Diameter | ||
| 19 | Diameter (in) | 4.5 | in |
| 20 | ft | 0.375 | ft |
| 21 | mm | 114.3 | mm |
| 22 | cm | 11.43 | cm |
| Name | Refers To | Comment |
|---|---|---|
| A_acres | 'Length & Area'!$B$10 | |
| Ct_1psi | 'Pressure & Temperature'!$B$23 | |
| D_in | 'Length & Area'!$B$19 | |
| GOR_scfstb | 'Volume & Rate'!$B$19 | |
| K_mD | 'Length & Area'!$B$15 | |
| L_ft | 'Length & Area'!$B$4 | |
| P_psi | 'Pressure & Temperature'!$B$5 | |
| Qg_Mscfd | 'Volume & Rate'!$B$14 | |
| Ql_stbd | 'Volume & Rate'!$B$10 | |
| Rho_lbft3 | 'Volume & Rate'!$B$23 | |
| T_F | 'Pressure & Temperature'!$B$12 | |
| V_bbl | 'Volume & Rate'!$B$4 | |
| Visc_cp | 'Pressure & Temperature'!$B$18 |
| Opens in | Needs the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates. |
| File | UnitConverter.xlsx, 10 KB |
| Category | General |
| For agents and tools | Structure (.json) · Descriptor (.md) |