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]

Need a custom LAMBDA? Suggest a New Lambda