Using Blueprints in Petroleum Office

Blueprints are reusable Excel worksheet components that contain pre-built calculations, labels, and formulas. They save time by providing ready-made calculation templates that you can insert into any workbook.

What Are Blueprints?

A blueprint is a small, self-contained Excel template that you insert at a specific cell location. Each blueprint includes:

  • Input labels and cells for entering your data
  • Formulas that perform the calculation using Petroleum Office functions
  • Output cells that display results

Blueprints cover various engineering disciplines including PVT correlations, decline curve analysis, material balance, and more.

Opening the Blueprint Manager

  1. Go to the Petroleum Office tab in the ribbon
  2. In the Library group, click the Blueprints button
  3. The Blueprint Manager window opens

Browsing Blueprints

The Blueprint Manager provides:

  • Search — type keywords to filter blueprints by name or description
  • Categories — blueprints are organized by engineering discipline (PVT, DCA, MBE, etc.)
  • Preview — select a blueprint to see its description and what it calculates

Inserting a Blueprint

  1. Click on the cell in Excel where you want the blueprint to start (this becomes the top-left corner)
  2. In the Blueprint Manager, select the blueprint you want
  3. Click Insert to place the blueprint at the selected cell

The blueprint inserts labels, input cells, and formulas into your worksheet. Formula references are automatically adjusted to match the insertion location.

Working with an Inserted Blueprint

After insertion:

  1. Enter your input values in the designated input cells (typically highlighted or labeled)
  2. View results in the output cells — they update automatically as you change inputs
  3. Modify formulas if needed — blueprints use standard Petroleum Office functions that you can edit

Tips

  • Target cell matters — the blueprint inserts relative to the cell you select in Excel. Make sure there's enough empty space below and to the right
  • Multiple blueprints — you can insert multiple blueprints in the same worksheet at different locations
  • Formulas are editable — after insertion, blueprint formulas behave like any other Excel formula. You can modify, copy, or extend them
  • Named ranges — some blueprints create named ranges for key parameters. These appear in Excel's Name Manager
An unhandled error has occurred. Reload X