Volume Flow Rate Unit Converter in Excel
365.2421927
Add-in Formula
=PO.UnitConverter(1, "bbl/d", "bbl/y")
Excel Lambda
=LAMBDA(x,
LET(
ratio, 365.242192650463,
x * ratio
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
f, SWITCH(from,
"bbl/d", 1.84013072833333E-06,
"mbbl/d", 0.00184013072833333,
"mmbbl/d", 1.84013072833333,
"bbl/y", 5.0381110544212E-09,
"mbbl/y", 5.0381110544212E-06,
"mmbbl/y", 0.0050381110544212,
"m3/d", 1.15740740740741E-05,
"E3m3/d", 0.0115740740740741,
"E6m3/d", 11.5740740740741,
"scf/d", 3.2774128E-07,
"mscf/d", 0.00032774128,
"mmscf/d", 0.32774128),
t, SWITCH(to,
"bbl/d", 1.84013072833333E-06,
"mbbl/d", 0.00184013072833333,
"mmbbl/d", 1.84013072833333,
"bbl/y", 5.0381110544212E-09,
"mbbl/y", 5.0381110544212E-06,
"mmbbl/y", 0.0050381110544212,
"m3/d", 1.15740740740741E-05,
"E3m3/d", 0.0115740740740741,
"E6m3/d", 11.5740740740741,
"scf/d", 3.2774128E-07,
"mscf/d", 0.00032774128,
"mmscf/d", 0.32774128),
x * f / t
)
)(1, "bbl/d", "bbl/y")
How to save as a reusable Excel function
LAMBDA is a built-in Excel feature (Microsoft 365) that lets you create custom functions without VBA. The formulas above work as-is when pasted into a cell.
To save a LAMBDA as a reusable named function:
- Go to Formulas → Name Manager → New
- Enter a name, e.g.
ConvertVolumeFlowRate - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertVolumeFlowRate(1, "bbl/d", "bbl/y")
anywhere in your workbook — no add-in required.
Conversion Factors
| Unit | Name | Factor |
|---|---|---|
| bbl/d | barrel per day | 1.84013072833333E-06 |
| mbbl/d | thousand barrels per day | 0.00184013072833333 |
| mmbbl/d | million barrels per day | 1.84013072833333 |
| bbl/y | barrels per year | 5.0381110544212E-09 |
| mbbl/y | thousand barrels per year | 5.0381110544212E-06 |
| mmbbl/y | million barrels per year | 0.0050381110544212 |
| m3/d | cubic metre per day | 1.15740740740741E-05 |
| E3m3/d | thousand cubic metre per day | 0.0115740740740741 |
| E6m3/d | million cubic metre per day | 11.5740740740741 |
| scf/d | standard cubic feet per day | 3.2774128E-07 |
| mscf/d | thousand standard cubic feet per day | 0.00032774128 |
| mmscf/d | million standard cubic feet per day | 0.32774128 |