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
Ribbon Unit Converter
The Petroleum Office ribbon includes a dedicated Unit Conversion group with dropdown controls for quick conversions without writing formulas:
- Select the Category (e.g., Pressure, Temperature, Length)
- Choose the From unit
- Choose the To unit
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:
