PO.DE.Mud.Blend


Description

Volumes of two muds of different weights to mix for a final volume at a target weight, for building a pill or a kill-weight batch from what is in the pits. Returns two cells, both bbl: the volume of mud A, then the volume of mud B.

Formula

=LAMBDA(V_final_bbl, MW_a_ppg, MW_b_ppg, MW_target_ppg, LET( vol_a, V_final_bbl*(MW_target_ppg-MW_b_ppg)/(MW_a_ppg-MW_b_ppg), HSTACK(vol_a, V_final_bbl-vol_a)))

Parameters

Parameter Unit Description
V_final_bbl bbl Final volume wanted
MW_a_ppg ppg Weight of mud A
MW_b_ppg ppg Weight of mud B, different from A
MW_target_ppg ppg Target weight, between the two

Examples

Invocation Expected
=PO.DE.Mud.Blend(300, 10, 14, 12) [150, 150]
=PO.DE.Mud.Blend(500, 9.5, 16, 12) [307.692308, 192.307692]
=PO.DE.Mud.Blend(300, 14, 10, 12) [150, 150]

Need a custom LAMBDA? Suggest a New Lambda