EoS Tuning Setup
Spreadsheet
25 rows x 6 columns
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | EoS Tuning Setup | |||||
| 2 | Adjustable Properties | |||||
| 3 | ||||||
| 4 | Property Table (editable - paste values from Component.Props) | |||||
| 5 | Component | Tc (K) | Pc (Pa) | omega | Mw (kg/mol) | zi |
| 6 | methane | 190.564 | 4599000 | 0.0115 | 0.01604 | 0.6 |
| 7 | ethane | 305.32 | 4872000 | 0.0995 | 0.03007 | 0.1 |
| 8 | propane | 369.83 | 4248000 | 0.1523 | 0.0441 | 0.08 |
| 9 | n-butane | 425.12 | 3796000 | 0.2002 | 0.05812 | 0.05 |
| 10 | C7 (adjustable) | 540.2 | 3120000 | 0.28 | 0.096 | 0.17 |
| 11 | ||||||
| 12 | Observed Data | |||||
| 13 | Pb observed | 15000000 | Pa | |||
| 14 | T reservoir | 373.15 | K | |||
| 15 | ||||||
| 16 | Calculated | |||||
| 17 | Pb calculated | 36826798.29 | Pa | |||
| 18 | ||||||
| 19 | Regression | |||||
| 20 | Error (%) | 145.5119886 | % | |||
| 21 | Error squared | 4.764091235E+14 | ||||
| 22 | ||||||
| 23 | Instructions | |||||
| 24 | 1. Adjust C7 properties in B10:E10 to minimize error | |||||
| 25 | 2. Or use Excel Solver: minimize B21, changing B10:D10 |
Description
Framework for EoS tuning by comparing calculated vs. observed bubble point pressures. The property table uses editable cells for Tc, Pc, omega, and Mw, enabling manual adjustment or Solver-based regression.
Tuning Workflow:
- Build initial property table from database + SCN correlations
- Copy property values to editable cells (break the formula link)
- Compare calculated bubble point vs. observed value
- Adjust C7+ properties (Tc, Pc, omega) or kij to minimize error
- Use Excel Solver to automate regression on the error cell
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for EoS Tuning Setup
- Click on the blueprint to preview
- Click Insert to place it into your worksheet. Modify the input values to match your data.