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 |