Unit conversion in Petroleum Office is based on UnitConverter() Excel function which is part on add-in function library.
=UnitConverter(Value, UnitFrom, UnitTo)
It has the following parameters:
- Value – value you need to convert
- UnitFrom – source unit abbreviation
- UnitTo – target unit abbreviation
There are 3 types of units you can use with UnitConverter().
1) Registered Units
Add-in has built in extensive library of units (~1500).
By clicking the “All Units” button on Ribbon, you can find the full list of registered units, search through and copy abbreviation for selected.
2) Scaled Units
It’s a combination of value with registered unit separated by space, “640 acre” for example.
3) Unit Expression*
You can create your own unit using simple syntax by combining any registered units and the following characters: * – as multiplication, ^ – as power. Here is an example: