PO.DE.Mud.OilWaterRatio


Description

Oil-water ratio (OWR) of an oil-based or synthetic-based mud from the retort's oil and water volume percents, the figure a mud report quotes as, for example, 80/20. Returns three cells, all percent: the oil share of the liquid, the water share of the liquid, and the retort solids (100 less oil and water).

Formula

=LAMBDA(Oil_pct, Water_pct, HSTACK(100*Oil_pct/(Oil_pct+Water_pct), 100*Water_pct/(Oil_pct+Water_pct), 100-Oil_pct-Water_pct))

Parameters

Parameter Unit Description
Oil_pct vol % Oil (base fluid) volume percent from the retort
Water_pct vol % Water volume percent from the retort

Examples

Invocation Expected
=PO.DE.Mud.OilWaterRatio(56, 14) [80, 20, 30]
=PO.DE.Mud.OilWaterRatio(60, 18) [76.923077, 23.076923, 22]
=PO.DE.Mud.OilWaterRatio(51, 17) [75, 25, 32]

Need a custom LAMBDA? Suggest a New Lambda