PO.WI.PA.BalancedPlug


Description

Placement of a balanced cement plug through an open-ended string: the spacer to pump behind the cement so the columns inside and outside the pipe balance, the plug height with the pipe in, its height after the pipe is pulled, and the displacement. Returns four cells: spacer behind (bbl), plug height with the pipe in (ft), plug height after pulling out (ft), displacement (bbl).

Formula

=LAMBDA(Slurry_bbl, Ahead_bbl, PlugHoleID_in, StringOD_in, StringID_in, Base_ft, LET( capA, (PlugHoleID_in^2 - StringOD_in^2)/1029.4, capP, StringID_in^2/1029.4, hIn, Slurry_bbl/(capA + capP), behind, Ahead_bbl*capP/capA, HSTACK(behind, hIn, Slurry_bbl/(PlugHoleID_in^2/1029.4), capP*(Base_ft - hIn) - behind)))

Parameters

Parameter Unit Description
Slurry_bbl bbl Slurry volume, from PO.DE.Cement.Volume (casing OD 0, the plug length as the open-hole length)
Ahead_bbl bbl Spacer pumped ahead of the cement
PlugHoleID_in in Hole or casing inside diameter at the plug
StringOD_in in Outside diameter of the string at the plug (the stinger)
StringID_in in Inside diameter of the string
Base_ft ft Depth of the string's end, the plug base

Examples

Invocation Expected
=INDEX(PO.WI.PA.BalancedPlug(37.9, 10, 6.25, 2.875, 2.44, 9600), 1, 2) 1059
=INDEX(PO.WI.PA.BalancedPlug(37.9, 10, 6.25, 2.875, 2.44, 9600), 1, 3) 1000
=PO.WI.PA.BalancedPlug(37.9, 10, 6.25, 2.875, 2.44, 9600) [1.933183, 1061.598796, 998.765056, 47.4492]
=PO.WI.PA.BalancedPlug(30, 20, 8.5, 5, 4.276, 8000) [7.739334, 471.235039, 427.432526, 125.986393]

Need a custom LAMBDA? Suggest a New Lambda