PO.DE.Cement.Volume
Description
Slurry volume of one cement stage (a lead or a tail): the open-hole annulus with an excess, the overlap inside the previous casing, and the shoe track. Call it once per slurry; a lead usually has no shoe track, a tail no overlap. Returns four cells, all bbl: the total, then the open-hole, overlap and shoe-track parts.
Formula
=LAMBDA(Dh_in, OD_in, ID_in, PrevID_in, OH_ft, CH_ft, Shoe_ft, Excess, LET(
voh, (Dh_in^2 - OD_in^2)/1029.4*OH_ft*(1 + Excess),
vch, (PrevID_in^2 - OD_in^2)/1029.4*CH_ft,
vsh, ID_in^2/1029.4*Shoe_ft,
HSTACK(voh + vch + vsh, voh, vch, vsh)))Parameters
| Parameter | Unit | Description |
|---|---|---|
Dh_in |
in | Open-hole diameter (bit size or caliper average) |
OD_in |
in | Casing outside diameter; 0 for a plug in open hole |
ID_in |
in | Casing inside diameter, for the shoe track |
PrevID_in |
in | Inside diameter of the previous casing, for the overlap |
OH_ft |
ft | Open-hole length this slurry fills |
CH_ft |
ft | Length inside the previous casing; 0 for none |
Shoe_ft |
ft | Shoe-track length (shoe to float collar); 0 for none |
Excess |
fraction | Open-hole excess, 0.3 for 30%; applied to the open hole only |
Examples
| Invocation | Expected |
|---|---|
=PO.DE.Cement.Volume(12.25, 9.625, 8.681, 12.347, 2000, 500, 80, 0.3) |
[179.939332, 145.032908, 29.049827, 5.856597] |
=PO.DE.Cement.Volume(12.25, 9.625, 8.681, 12.347, 1500, 500, 0, 0.5) |
[154.559074, 125.509247, 29.049827, 0] |
=PO.DE.Cement.Volume(6.25, 0, 0, 0, 1000, 0, 0, 0) |
[37.946862, 37.946862, 0, 0] |