PO.FL.Type.Classify


Description

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")`.

Formula

=LAMBDA(gor, api, cplus, IF(OR(gor<0, api<0, cplus<0, cplus>1), NA(), IF(cplus>=0.125, IF(AND(gor<1750, api<45, cplus>0.2), 1, 2), IF(OR(gor<15000, cplus>=0.04), 3, IF(gor<100000, 4, 5)))))

Parameters

Parameter Unit Description
gor scf/STB Initial producing gas-oil ratio, separator and stock-tank gas per stock-tank barrel; 0 or more
api °API Stock-tank oil gravity; 0 for a dry gas that makes no liquid
cplus frac C7+ (heptanes-plus) mole fraction of the reservoir fluid, 0 to 1

Examples

Invocation Expected
=PO.FL.Type.Classify(646, 40.5, 0.4066) 1
=PO.FL.Type.Classify(1749, 44.9, 0.2001) 1
=PO.FL.Type.Classify(1750, 44.9, 0.2001) 2
=PO.FL.Type.Classify(1000, 45, 0.3) 2
=PO.FL.Type.Classify(1000, 35, 0.2) 2
=PO.FL.Type.Classify(3500, 42, 0.125) 2
=PO.FL.Type.Classify(3000, 45, 0.1249) 3
=PO.FL.Type.Classify(14999, 55, 0.0399) 3
=PO.FL.Type.Classify(15000, 55, 0.0399) 4
=PO.FL.Type.Classify(20000, 55, 0.04) 3
=PO.FL.Type.Classify(99999, 65, 0.01) 4
=PO.FL.Type.Classify(100000, 0, 0.005) 5

Need a custom LAMBDA? Suggest a New Lambda