PO.PTA.Fluid.FromRecovery


Description

A drill-stem test that doesn't flow to surface measures its rate by the column it recovers in the string. This gives the average rate over a flow period from the length of that column, filling the drill collars first and then the drill pipe, and calls the recovered fluid oil, water or mud from its pressure gradient. Returns two cells: the rate in bbl/d, then 1 for oil, 2 for water or 3 for mud.

Formula

=LAMBDA(Recovery_ft, Collar_ft, Collar_bblft, Pipe_bblft, Flow_h, Gradient_psift, LET( v, MIN(Recovery_ft, Collar_ft)*Collar_bblft+MAX(Recovery_ft-Collar_ft, 0)*Pipe_bblft, HSTACK(24*v/Flow_h, IF(Gradient_psift<0.4, 1, IF(Gradient_psift<=0.47, 2, 3)))))

Parameters

Parameter Unit Description
Recovery_ft ft Length of the recovered column, from the tool up
Collar_ft ft Length of the drill collars above the tool
Collar_bblft bbl/ft Capacity of the drill collars
Pipe_bblft bbl/ft Capacity of the drill pipe above them
Flow_h h Length of the flow period
Gradient_psift psi/ft Pressure gradient of the recovered fluid

Examples

Invocation Expected
=PO.PTA.Fluid.FromRecovery(68, 300, 0.00768, 0.01422, 0.05, 0.36) [250.6752, 1]
=PO.PTA.Fluid.FromRecovery(3105, 300, 0.00768, 0.01422, 4, 0.44) [253.1466, 2]
=PO.PTA.Fluid.FromRecovery(600, 300, 0.00768, 0.01422, 1, 0.52) [157.68, 3]

Need a custom LAMBDA? Suggest a New Lambda