Unit Conversion in Petroleum Office

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

=PO.UnitConverter(Value, UnitFrom, UnitTo)

It has the following parameters:

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

Unit Converter Pane

The Petroleum Office ribbon includes a Unit Converter button in the Tools group that opens a dedicated task pane for quick conversions without writing formulas:

1. Select the Category (e.g., Pressure, Temperature, Length)
2. Choose the From unit
3. Choose the To unit
4. Type a value and read the result, or copy the matching =PO.UnitConverter(...) formula into a cell

This lets you browse all registered units organized by category and quickly find the abbreviation you need.

If you work in SI throughout, converting on every call gets tedious. The lambda catalog provides SI-unit versions of the functions that do the conversion for you.

Units

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

1. Registered Units

The add-in has a built-in library of 1,500+ units covering pressure, temperature, length, area, volume, flow rates, density, viscosity, permeability, and many more petroleum engineering categories.

2. Scaled Units

A combination of a value with a registered unit separated by a space, "640 acre" for example.

3. Unit Expressions

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: