PO.DE.Mud.WeightUp


Description

Weighting agent (barite, or hematite or calcium carbonate) needed to raise a mud system to a target weight, and the volume it adds to the system, with no mud removed. Returns four cells: the agent in lb, the same in 100-lb sacks, the volume added in bbl, and the final system volume in bbl.

Formula

=LAMBDA(V_bbl, MW_start_ppg, MW_target_ppg, Rho_agent_ppg, LET( added, V_bbl*(MW_target_ppg-MW_start_ppg)/(Rho_agent_ppg-MW_target_ppg), mass, 42*Rho_agent_ppg*added, HSTACK(mass, mass/100, added, V_bbl+added)))

Parameters

Parameter Unit Description
V_bbl bbl Mud volume before weighting up
MW_start_ppg ppg Current mud weight
MW_target_ppg ppg Target mud weight, below the agent's density
Rho_agent_ppg ppg Density of the weighting agent: 35 for API barite (SG 4.2)

Examples

Invocation Expected
=PO.DE.Mud.WeightUp(500, 10, 13, 35) [100227.2727, 1002.272727, 68.181818, 568.181818]
=PO.DE.Mud.WeightUp(100, 10, 13, 35) [20045.45455, 200.454545, 13.636364, 113.636364]
=PO.DE.Mud.WeightUp(800, 11.5, 12.5, 35) [52266.66667, 522.666667, 35.555556, 835.555556]

Need a custom LAMBDA? Suggest a New Lambda