PO.DE.TD.Buoyancy


Description

Buoyancy factor of a pipe string with one fluid inside and another outside, and its buoyed weight per foot, for hookload, torque-and-drag and buckling work. Returns two cells: BF = 1 − (ρo D² − ρi d²) / (ρs (D² − d²)), then the buoyed weight W × BF in lb/ft.

Formula

=LAMBDA(PipeW_lbft, PipeOD_in, PipeID_in, MWi_ppg, MWo_ppg, RhoSteel_ppg, LET( bf, 1 - (MWo_ppg*PipeOD_in^2 - MWi_ppg*PipeID_in^2) / (RhoSteel_ppg*(PipeOD_in^2 - PipeID_in^2)), HSTACK(bf, PipeW_lbft*bf)))

Parameters

Parameter Unit Description
PipeW_lbft lb/ft Weight in air per foot, nominal (with tool joints or couplings)
PipeOD_in in Pipe outside diameter
PipeID_in in Pipe inside diameter; 0 for a solid rod
MWi_ppg ppg Fluid density inside the pipe; 0 for an empty (floated) string
MWo_ppg ppg Fluid density in the annulus
RhoSteel_ppg ppg Steel density, 65.5 ppg (490 lb/ft³)

Examples

Invocation Expected
=PO.DE.TD.Buoyancy(19.5, 5, 4.276, 10, 10, 65.5) [0.847328244, 16.52290076]
=PO.DE.TD.Buoyancy(19.5, 5, 4.276, 12, 10, 65.5) [0.930459585, 18.1439619]
=PO.DE.TD.Buoyancy(6.5, 2.875, 2.441, 0, 8.6, 65.5) [0.529609927, 3.442464528]
=PO.DE.TD.Buoyancy(2.224, 0.875, 0, 9.152, 9.152, 65) [0.8592, 1.9108608]

Need a custom LAMBDA? Suggest a New Lambda