Returns which of McCain's five reservoir fluids a fluid is, from the three numbers a well test and a PVT report give: the initial producing gas-oil ratio, the stock-tank oil gravity and the C7+ mole fraction of the reservoir fluid. The type decides how the reservoir is studied: a black oil takes a black-oil table, a volatile oil and a gas condensate need an equation of state and compositional simulation, a wet gas a recombined well stream, and a dry gas a gas law alone. The class is returned as a number so a sheet can compare it: 1 black oil, 2 volatile oil, 3 gas condensate (retrograde gas), 4 wet gas, 5 dry gas. A sheet shows the name with `CHOOSE(class, "Black oil", "Volatile oil", "Gas condensate", "Wet gas", "Dry gas")`.
How far a correlation's values fall from measured ones, as one number: the average absolute relative error, in percent. It is the score PVT and flow-correlation studies rank correlations by, because a relative error lets a 50 scf/STB miss at 100 scf/STB count for more than the same miss at 800, and the absolute value stops misses on either side from cancelling. Give it the observed values and the computed ones, of the same shape: a column of lab points and the column a correlation gives at them, or two single values. A pair is scored only when both are numbers and the observed value is not zero, so a lab table can carry blank rows and a correlation can leave a point out. With no pair to score it returns #N/A.
A second check of a set of equilibrium ratios (K = y/x) at one pressure and temperature: Buckley observed that log K of the components falls close to a straight line against the square of their critical temperature. It needs only the critical temperatures, so it suits a quick look at a separator or flash analysis, beside the Hoffman plot (`PO.FL.QC.Hoffman`). The function returns Tc², log K, the least-squares line and its R², and each component's deviation from the line, so a sheet can draw the plot and flag the component whose analysis is out of line.
Checks a differential liberation (DL) report by mass. The residual oil at the end of the test, plus all the gas released on the way down, is the oil that was at each pressure stage; so the oil's density at each stage can be recomputed from the residual oil's density, the solution gas-oil ratios, the released gases' gravities and the oil formation volume factors, and compared with the density the laboratory reports. Stages where the two disagree point at a wrong gas volume, gas gravity or oil volume in the report, before the data go into a black-oil table. The function returns the recomputed density at each stage, its difference from the reported one, and the oil's mass per barrel of residual oil.
Lays black-oil properties out as the records of an Eclipse-format `PVTO` keyword (live oil, FIELD units), ready to turn into deck text. A PVTO record is one solution GOR: its first line gives the Rs, the bubble point at that Rs, and Bo and μo there; the lines under it are the undersaturated branch, the same oil compressed above its bubble point, each a pressure with its Bo and μo; a slash ends the record. The function computes nothing. The saturated rows (Rs in scf/STB, the bubble point, Bo and μo, one row a record, Rs rising) and each record's branch (a row of pressures and the Bo and μo at each, the same row as its record) come from the sheet, from `PO.PVT.*` or the lab. A branch can be shorter than the others: blank cells at its end are left out, so the records are ragged as PVTO's are. Entered as `=PO.PVT.Table.PVTO(Rs, Pb, Bo, Uo, Pu, Bou, Uou)` in a Microsoft 365 cell it spills the whole table. The result has a fixed shape, so a sheet can also read it a cell at a time with `INDEX`: one line for each saturated row and one for each branch column, each line Rs in Mscf/STB (on a record's first line only), pressure, Bo, μo, and "/" on the record's last line. A line a short branch doesn't use is "" throughout.
Checks the equilibrium ratios (K = y/x, gas over liquid mole fraction) of a separator test, a flash or a recombined sample. Hoffman, Crump and Hocott (1953) showed that log(K·p) of the components of a fluid at one pressure and temperature falls on a straight line against a characterization factor F built from each component's boiling point, critical temperature and critical pressure. A component well off the line has a wrong analysis (often the gas or liquid sample of one of the heavy fractions); a whole set that scatters says the separator was not at equilibrium or the samples are not a pair. The function returns F, log(K·p), the least-squares line and its R², and each component's deviation from the line, so a sheet can draw the plot and flag the outliers.
This website uses cookies to enhance your experience and analyze site usage.
By clicking "Accept", you consent to the use of cookies for analytics purposes.
Read our privacy policy