PO.SF.Sep.LiquidRetention


Description

Returns the liquid volume a separator must hold so its liquid stays in the vessel for the design retention time, or the length of vessel of a given internal diameter that holds it. A two-phase separator holds the oil and water together for one time, long enough for the gas to come out of the liquid. A three-phase separator holds each for its own time, long enough for the water to drop out of the oil and the oil out of the water. A vertical vessel holds the liquid over its whole cross-section, so the length is the liquid height. A horizontal one is taken half full, Arnold and Stewart's design basis, so the length is the effective length the liquid occupies.

Formula

=LAMBDA(phases, orientation, qo, qw, tr_o, tr_w, d, output, IF(OR(AND(phases<>2, phases<>3), AND(orientation<>"Vertical", orientation<>"Horizontal"), qo<0, qw<0, tr_o<0, tr_w<0, d<=0), NA(), IF(OR(output="Volume", output="Length"), IF(phases=2, (qo+qw)*tr_o, qo*tr_o+qw*tr_w)/1440*IF(output="Volume", 1, 5.6145833)/IF(output="Volume", 1, PI()/4*(d/12)^2*IF(orientation="Vertical", 1, 0.5)), NA())))

Parameters

Parameter Unit Description
phases — 2 (gas-liquid: the oil and water are held together for `tr_o`; `tr_w` is not used) or 3 (gas-oil-water: oil for `tr_o`, water for `tr_w`)
orientation text "Vertical" (liquid over the whole section) or "Horizontal" (half full)
qo bbl/d Oil (or condensate) rate; 0 or more
qw bbl/d Water rate; 0 or more
tr_o min Retention time of the oil, or of all the liquid in a two-phase vessel; 0 or more
tr_w min Retention time of the water in a three-phase vessel; 0 or more
d in Vessel internal diameter
output text "Volume" liquid volume held [bbl] or "Length" liquid height (vertical) or effective length (horizontal) [ft]

Examples

Invocation Expected
=PO.SF.Sep.LiquidRetention(2, "Horizontal", 2000, 0, 3, 0, 48, "Volume") 4.166667
=PO.SF.Sep.LiquidRetention(2, "Horizontal", 2000, 0, 3, 0, 48, "Length") 3.723286
=PO.SF.Sep.LiquidRetention(2, "Vertical", 2000, 0, 3, 0, 48, "Length") 1.861643
=PO.SF.Sep.LiquidRetention(3, "Horizontal", 5000, 3000, 10, 10, 72, "Volume") 55.555556
=PO.SF.Sep.LiquidRetention(3, "Horizontal", 5000, 3000, 10, 10, 72, "Length") 22.063918
=PO.SF.Sep.LiquidRetention(3, "Vertical", 1500, 1000, 5, 8, 60, "Volume") 10.763889
=PO.SF.Sep.LiquidRetention(3, "Vertical", 1500, 1000, 5, 8, 60, "Length") 3.077917
=PO.SF.Sep.LiquidRetention(2, "Horizontal", 1500, 1000, 2, 8, 60, "Length") 1.985753
=IF(ISNA(PO.SF.Sep.LiquidRetention(4, "Horizontal", 1500, 1000, 2, 8, 60, "Length")), 1, 0) 1

Need a custom LAMBDA? Suggest a New Lambda