PO.DE.BOP.ClosingVolume


Description

The hydraulic fluid an accumulator has to deliver to operate a list of BOP functions once: each function's volume times how many there are, summed, times a design factor. Pass the volumes and the counts as two ranges of the same size, for example a stack table with one row per function. A design factor of 1 gives the bare volume to operate everything once.

Formula

=LAMBDA(Volumes_gal, Counts, DesignFactor, SUMPRODUCT(Volumes_gal, Counts) * DesignFactor)

Parameters

Parameter Unit Description
Volumes_gal gal Fluid to operate each function once (close a preventer, open a valve), from the equipment's data sheet
Counts count How many of each function there are, in the same order
DesignFactor dimensionless Factor on the total (1 for the bare volume)

Examples

Invocation Expected
=PO.DE.BOP.ClosingVolume({17.98;5.8;10.9;0.5}, {1;2;1;2}, 1) 41.48
=PO.DE.BOP.ClosingVolume({17.98;5.8;10.9;0.5}, {1;2;1;2}, 1.5) 62.22
=PO.DE.BOP.ClosingVolume({17.1;5.8;6.2;0.5}, {1;2;1;2}, 1.5) 53.85
=PO.DE.BOP.ClosingVolume({14.16;5.5;10.5}, {1;2;1}, 1) 35.66

Need a custom LAMBDA? Suggest a New Lambda