Planner Release Notes V2.2

Planner Version 2.2

💵 Operating Expenses (OPEX)

While the Planner already supports capex and revenue, many companies are interested in seeing more economic metrics directly in their plans.
 
Planner 2.2 introduces support for opex modeling. This enables you to see opex results (live!) as you make changes to your scenarios, so you can better understand how your cash flow profile is affected.

 You can add opex models under the Assumptions tab in the same way that you'd add capex models. Each expense includes:

• Category: how the expenses should be grouped together in results (same as capex)
• Description: an optional name for tracking (same as capex)
• Source: whether the expense is a fixed cost or a variable cost associated with a specific product
• Timing: when to start applying the expense, relative to production or on a specific date
• Cost: either a fixed amount or calculated amount

Opex models currently require production to exist on the well using the opex model. This is a temporary limitation because the Planner uses the end of the production forecast to determine when to end the expense. This limitation will be removed in the future once the Planner includes other options to control the expense end (e.g., based on operating income, manual dates, etc.).
 
 In the Inventory tab, you can select which opex model to use for each well (just like capex and production). This also provides a summary of the total opex as a quick way to check that the well costs are in the range you'd expect.

When you start using opex in your plans, a new opex metric will be added to the schedule view. This works like the other economic metrics, and you can switch between gross and net results.
 
 Opex results are also included in the Excel and Parquet exports:

Opex results are also included in the new Spotfire exports, so let's jump right into that!

📊 Spotfire Integration

 If you've ever tried to use Parquet with Spotfire, you've probably noticed that Spotfire doesn't support directly importing from Parquet files. Some companies use third-party commercial tools to import Parquet files into Spotfire, but that's not the kind of user experience the Planner wants to support.
 
Planner 2.2 includes a direct integration for Spotfire using the Spotfire Binary Data File (sbdf) format. This is a format that Spotfire uses to transport data around efficiently, and it's very similar to the Parquet format internally.
 
 To get started with Spotfire integration, you can add the new integration under the Settings tab:

In the Spotfire export settings, you can specify which folder location to use for exports, along with an optional scenario name to group exported files together (under a folder). When you click "Export to Spotfire", the Planner will create sbdf files in that location:

 These files can be brought directly into Spotfire as a data source at the same time. They also work with Spotfire's data source reloading functionality. This allows you to make changes in the Planner then re-export the files to the same location to see the refreshed results in Spotfire.

 These files can be used in Spotfire the same way you'd use any other data tables:

As part of the Spotfire integration, the Pod2 team developed an open source library for reading and writing sbdf files. You can check it out at Pod2's GitHub repository if you'd like to see how the library works or do something similar in your own projects.

📃 Header Export

The "attributes" export has been converted to a "headers" export in Planner 2.2. The headers export includes the same columns you can import with the headers import. This makes it much easier to make bulk updates without keeping extra Excel templates around.
 
 Here's what the headers export looks like:

 This opens up an Excel document including all of the built-in headers (asset template, capex model, etc.) and custom attributes (like the previous attributes export):

 The headers export is really great because it allows you to make quick changes in Excel, then copy and paste this grid back into the Planner's header import. You don't have to reformat it or make any other changes. This should be a huge time saver for bulk updates or quick QC checks (e.g., making sure wells have the right asset templates and models assigned).

🟰 More Math Functions

Planner 2.2 adds several math functions which can be useful when writing formulas for capex amounts, opex amounts, activity durations, or production scaling factors:

• power(exponent, base): returns the base raised to the power of the exponent provided
• exp(exponent): returns the mathematical constant "e" raised to the power of the exponent provided
• log(number, base): returns the logarithm of a number with a specified base
• ln(number): returns the natural logarithm of a number
• min(number 1, number 2): returns the smaller of two numbers
• max(number 1, number 2): returns the larger of two numbers

🚮 Bulk Delete Specific Assets

If you're trying to remove many assets from a plan at the same time, previously this required you to remove all assets and recreate the assets you'd like to keep. Instead Planner 2.2 offers a way to bulk delete specific assets from your plan by pasting a list of assets to delete:

🏎️ Performance

More performance optimizations have been added in version 2.2 especially around interactions on the schedule view. Through those performance changes, we also identified several more performance optimizations that we'd like to apply in future releases.

We're committed to making the Planner faster every release, even as the Planner adds more detail into the calculation (like opex!).