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] |