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.

Unit Converter Overview

=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.

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:

Unit Expression Example