ComboCurve: Scenario Lookup Tables

ComboCurve: Scenario Lookup Tables

Scenario Lookup Tables

In this document we will discuss Scenario Lookup Tables, how to use them and the functionality they provide to the user.


Applying and using Scenario Lookup Tables

Scenario lookup tables can be used on all economic assumptions, as well as forecast and schedules. The can be applied in the scenario table by clicking on the three dotes next to the assumption you would like to apply the look up table too. The same look up table can be applied to different assumptions, be sure to insure the econ assumption your applying the lookup table to in the scenario table has a defined model in the lookup table. A quick and easy way to check and see what models are being applied while using lookup tables is to export rendered lookup tables, under the exports button in the scenario table. 

Creating Scenario Lookup Tables

Users can create lookup tables by heading lookup tables module and clicking see all. 



Then the user can select what type of lookup table they would like to create. In this case we would click the scenario tab. From here the user can click create scenario lookup tables.



When creating the lookup table the user will need to give it a name and decide if they want to be case sensitive or not. 



Once the scenario lookup table is created the user can began to build the table and define the lookup criteria. 



The lookup criteria items can be found under the headers section. The lookup table works by matching header values and/or ranges to specific economic models. Well headers should already be uploaded to the wells in the project. Economic models should already be created as well before building the lookup tables. The lookup tables can use all available well headers including project custom headers. 



Once the headers have been selected the user can copy from excel or type in the table the desired criteria to match on. If the user clicks on the cell a list of availably header options will be populated. 



The user can select the desired assumptions to match to by clicking on the assumptions button with the three horizontal lines next to it. 



Once the selected economic assumptions are selected the lookup table can be completed. The user can type, copy, or select which model they would like to assign in the lookup table.



When the lookup table is competed the user can click Validate. This will check and insure the logic is sound and insure the user does not have any logic errors in the created lookup table. If the table has passed the validation check, the user will save the lookup table and apply it in the scenario table. 

Example Lookup table

In this example we are matching Capex and Expenses to a wells type curve area, perf lateral length, and first production date. 



Well A
Type Curve Area: M1 WET GAS
Perf Lateral Length: 7500
First Prod Date: 6/15/2023

Capex: test 1 
Expenses: test 6

Well B
Type Curve Area: M1 Dry Gas
Perf Lateral Length: 11000
First Prod Date: 12/17/2023

Capex: None
Expenses: None
Well B will not be assigned as the range of perf lateral length falls outside of the match range. 

Note: If lookup values are left blank they will not be used in the look up. If the user has a case where a well matches multiple lines the priority is top to bottom, so the first line the well matches will be used. 

    • Related Articles

    • ComboCurve: Embedded Lookup Tables

      What are ELTs Embedded lookup tables (ELTs) assign specific economic inputs based on well header criteria. To better understand the functionalities, let's look at an example. In the table below, you can see a sample ELT that assigns a drilling cost ...

    • ComboCurve: Scenario Tooltip Overview Article

      Scenario Tooltip Overview Article Scenario Page (Overview of Main Screen) Top Left Hamburger Icon - to navigate to all CC sections Green Scenario Name - Quick navigation to the project landing page Top Right Guy Icon - Change name, password or log ...

    • ComboCurve: Type Curve Lookup Tables

      Summary Type Curve Lookup Tables (TC LTs) allow you to apply multiple type curves to a set of wells depending on each well's specific headers. Similar to Scenario Lookup Tables, TC LTs apply a specific type curve depending on the headers criteria ...

    • ComboCurve: Mass Export/Import Assumptions

      ComboCurve: Mass Export/Import Assumptions In this article we will discuss mass importing and exporting from the scenario main page. Model management, analysis and preservation is done through the EXPORTS and IMPORTS buttons at the top of the ...

    • ComboCurve: Expenses

      Expenses Key Key's allow the user to select which type of expense the would like to model. These key's can be stream specific or a fixed expense. Category Category's allow the user to define the type of expense they are modeling. Categories are only ...