Unit conversion in Petroleum Office is based on UnitConverter() Excel function which is part on add-in function library.

Unitconverter1

=UnitConverter(Value, UnitFrom, UnitTo)

It has the following parameters:

  • Value - value you need to convert
  • UnitFrom - source unit abbreviation 
  • UnitTo - target unit abbreviation

Units

There are 3 types of units you can use with UnitConverter().

1) Registered Units

Add-in has built in extensive library of units (~1500).

Unitconverter2

By clicking the "All Units" button on Ribbon, you can find the full list of registered units, search through and copy abbreviation for selected.

Unitconverter3

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:

Unitconverter4