How to Run R3 on a Mac

Have a Mac and want to evaluate your oil and gas assets with R3? Not a problem!

In order to run Windows on Mac, you need to have a copy of the Windows Installation File (DVD disc or .ISO file) before you can run Windows on a Mac.

There are two ways to run Windows on a Mac,

1.  Install Windows through Boot Camp

Install your separate Windows System on a Mac

Install your separate Windows System on a Mac

 

Boot Camp allows you to install Windows alongside OS X on your Mac. Only one operating system can be running at a time, so you’ll have to restart your Mac to switch between OS X and Windows.

Here are useful links:

 

2.  Run Windows through a Virtual Machine

Virtual Machines like Parallels could allow users to execute Windows application within Mac OS

Virtual Machines like Parallels could allow users to execute Windows application within Mac OS

A virtual machine is one of the best ways to run Windows desktop software. They allow you to install Windows and other operating systems in a window on your Mac desktop. Windows will think it’s running on a real computer, but it’s actually running inside a piece of software on your Mac.

Here are useful links:

 

Once you have access to Windows on your Mac, you can install OGRE R3 with a few simple clicks. 

 

Multi-study Export

  •  

Multi-study Export

If you have more than one study that you want to export, go to:

  1. Go to: C:\Pyxis\bin\

  2. Run the TransferWizard.exe

  3. Click the File menu:

Select the Multi-Study Export(.oda) option.

  1. Select the location where you want the studies to be exported, and select the studies you want to have exported:

Click Export.

You'll see the progress and completion.

Multi-study Import

If you have more than one study that you want to export, go to:

  1. Go to: C:\Pyxis\bin\

  2. Run the TransferWizard.exe

  3. Click the File menu and select: Multi-Study Import(.oda)

  4. Point the directory to the location where the study .oda files are that you want to import.

  5. Select the studies that you want to import.

  6. Click Import Note: If you select to import a study that is already in the database you'll get this message

You'll see the progress and completion. To see these imported studies you will need to quit the TransferWizard and run AssetManager.

Using Multi Sensitivity form and US_Sensitivity model

This article will explain how to use the Multi Sensitivity form. What this form does is allow you to see how changes would affect your well. Changes that will affect the economics of a well include changes to:

  • Production
  • Price
  • Variable Costs
  • Fixed Costs
  • Capital Expenditures

You can evaluate variables in all of these areas, one area, or any combination.

 

When you click on the Multi Sensitivity form you will see this:

 

The form is divided into two sections. The top section is where you will enter your inputs. The bottom section is where the results are displayed after you run the appropriate models.

Sensitivity Inputs: These inputs are multipliers. For example: If you want to see what effect a 10% price increase would have on the NPV you would enter 1.1 into one of the sensitivity fields within the Price column. If you want to see the effect of a 10% decrease in price you would enter 0.90. The model will multiply the price you entered in the Price and Prod Tax form by this entry.

You can use as many or as few of these fields for your evaluation.

Results: This portion of the form will only be populated or updated when you run the appropriate models. (More information on that below.)

There are five tabs in this section, Production, Price, Variable Costs, Fixed Costs, and Capital. What is displayed is the result of the Sensitivity evaluation based on the corresponding inputs entered in the top portion of the form. Each tab will display different results based on the inputs corresponding to that tab.

The Process:

  1. The first thing you need to do is make sure that all of your data is entered correctly for Production Forecast, Price, Costs, Ownership, Capital, etc..
  2. On the Multi Sensitivity form you will enter the sensitivity multipliers you want to evaluate.
  3. Click the  Model icon to configure the model run. You must use the Advanced tab to set the Primary Model Override to use the model: US_Sensitivity. 
     
  4. Click Run. 
  5. To see a report about the NPV you will click the  report icon and select one of the sensitivity reports:
    MultiSensitivities.erw
    SpiderWithFactor.erw

    TornadoSensitivityGraph_Landscape.erw


When the model run is complete you will also see the results of the sensitivity calculations in the lower portion of the Multi Sensitivity form. This results section of this form actually shows the most information about how different sensitivity multipliers affect all other factors. For example, you can see that if you have the No Loss feature enabled, a change in price will affect the production because with a lower price, the well becomes uneconomic sooner resulting in less production. Those relationships are seen on this form.

Exporting data to an Excel Spreadsheet

Exporting to an Excel Spreadsheet

To export data from Pyxis to an Excel Spreadsheet you will

1. Click the File > Transfer(Import/Export)... option

1. Click the File > Transfer(Import/Export)... option

2. Select Transfer Out from the drop down selection and SpreadSheet. Then click Next.

2. Select Transfer Out from the drop down selection and SpreadSheet. Then click Next.

3. You will need to specify the file where the export will go. If you do not have a file created already, then enter (or browse to) the path and give the file a name. If the file exists, you'll select it. If it doesn't exist, enter the name you wish to use and the export process will create it. The file format supported is .xlsx only. If you do not include the .xlsx extension, the program will add it. Then click Next.

3. You will need to specify the file where the export will go. If you do not have a file created already, then enter (or browse to) the path and give the file a name. If the file exists, you'll select it. If it doesn't exist, enter the name you wish to use and the export process will create it. The file format supported is .xlsx only. If you do not include the .xlsx extension, the program will add it. Then click Next.

4. The first time you use the export you'll need to select the Study from the drop down menu. Then select the assets that you want to export data from.

4. The first time you use the export you'll need to select the Study from the drop down menu. Then select the assets that you want to export data from.

Clicking the Select Children button will select all children lower in the tree branch of the asset selected. In the screen shot example above the asset CHOCTAW was selected when the button was pushed so all leaf asset children were selected. The Include Ancestors option will make it so that the parent assets of the selected assets will also have their data exported. The Include Descendants option will make it so that all assets lower in the tree will be exported. If, instead of clicking the Select Children button the user checked the Include Descendants button then the assets CHOCTAW and HOUSLEY would also have been exported. In addition to selecting assets in the manner described above, you can also Ctrl click and Shift click to use the standard Windows customs for selecting multiple items..

Clicking the Select Children button will select all children lower in the tree branch of the asset selected. In the screen shot example above the asset CHOCTAW was selected when the button was pushed so all leaf asset children were selected.

The Include Ancestors option will make it so that the parent assets of the selected assets will also have their data exported.

The Include Descendants option will make it so that all assets lower in the tree will be exported. If, instead of clicking the Select Children button the user checked the Include Descendants button then the assets CHOCTAW and HOUSLEY would also have been exported.

In addition to selecting assets in the manner described above, you can also Ctrl click and Shift click to use the standard Windows customs for selecting multiple items..

5. When you click Next you will see the listing of Spread Sheet Profile(s). You can use the  Plus, Minus, and Duplicate icons to add, remove and duplicate for modification the profiles in the list.

5. When you click Next you will see the listing of Spread Sheet Profile(s). You can use the  Plus, Minus, and Duplicate icons to add, remove and duplicate for modification the profiles in the list.

6. Once you've added a profile, or if you want to modify and existing profile, or just see what the specific profile has configured to export, click the gear icon in the top right corner of the profile listing. The profile example shown here is a profile that will export OpCosts and a few pieces of identifying information. (Additional information in the Tips & Tricks section below) 

6. Once you've added a profile, or if you want to modify and existing profile, or just see what the specific profile has configured to export, click the gear icon in the top right corner of the profile listing. The profile example shown here is a profile that will export OpCosts and a few pieces of identifying information. (Additional information in the Tips & Tricks section below) 


 

6. Once you've added a profile, or if you want to modify and existing profile, or just see what the specific profile has configured to export, click the gear icon in the top right corner of the profile listing. The profile example shown here is a profile that will export OpCosts and a few pieces of identifying information. (Additional information in the Tips & Tricks section below) 

- You will use the  plus and minus buttons to add items to your list of data items to export. 

- Your list at the top appears as rows, but is a listing of what data will go into the various columns of the spread sheet.

- With each entry at the top you will see an example of the data in the table at the bottom. In the example above, column A row 1 is showing the label of the column that will appear on the spread sheet if you select that option (see item 7 below) and then each row below that shows that the data that will appear in that row is text. But you'll notice that column D has a label of Date and rows below that show that the data appears in a date format. Likewise for column E showing the label and the data type for that row as numbers. This data type is defined by the types in Pyxis.

- The Worksheet selection will show the names of any existing worksheets on the spreadsheet if it is an existing spreadsheet. Your profile can only export to a single worksheet. If you need data to be exported to more than one worksheet then you will need to create another profile for that worksheet.

- The Interval selection will determine how the data will be exported to the spreadsheet. Notice that Monthly is selected and in the example, column D with the date is showing monthly intervals. Please note that the data could be something like 200 bbl/day as how the data is stored in the database for a rate, but could be displayed as monthly and exported as monthly.

- To set the data that you want to export you will need to enter the type and instance of that data in Pyxis.

Type is the type of data used for the specific field.
Instance is the name of the field for that type.

When specifying the type and instance you would write the type first, then a # and then the instance name. So on our second item in this example we will specify: text#apicode

To find that information, before you have gone into the transfer wizard, go to the form where you find the data you want to export, put the cursor in the field where the data belongs, and press the F4 key. This will bring up a dialog box like this:


 

At the very top you see text#apicode and that is what you're looking for. You can copy from this dialog to paste elsewhere.

Unfortunately once you are running the Transfer Wizard and have begun defining your spreadsheet export profile, you will not be able to go back and copy/paste this type#instance. There are two tricks. First, if you have a previous version or secondary install of the software you can run it and have two copies of the software open. You can use the F4 and copy the type#instance from the one and then use the Transfer Wizard in your active install to paste. That is the easiest. 

The other thing you can do, if you don't have another installation of the program, is to identify all of the data that you are going to export, identify where it is in Pyxis, and then collect a list of type#instance needed from the F4 key and paste the list into a text file so that when you're creating the spreadsheet export profile, you have all of the type#instances you need on hand.
 

7. When you click the Options button you'll have options with respect to headers and asset path:




- If you check the option to Include Header when the spreadsheet is created the first row inserted into the file will have a header showing the Name entered in the profile. Note: If you use the option to append to an existing spreadsheet, the first row added to the spreadsheet will include the header information.

- The option Include Units in Header will add any unit specified for the data type into the header information.

- The option Units on Separate Row will separate the unit into a second row of header information.


- The option Include Asset Path(s) will add the path to the asset in the last column(s) in the spreadsheet.

- The option In Multiple Columns will use one column for each level in the path of the asset.
 

OpCost.JPG

8. After you save the profile you need to select which profiles to use for the export and specify if you want to append the data to the data already in the file. 



You need to select at least one profile. The option in the lower left corner to Append to Spreadsheet will allow you to determine if you want to append the exported data to rows immediately following the existing data or if you want to replace all data in the spreadsheet. If you check the box then the export will find the last used row (if its a new spreadsheet with no data yet then that means row 1) and add the data starting at that point. If you do not check the box you will get a warning that says that it will replace any data that is in the spreadsheet. If it is a new spreadsheet with no data, you lose nothing. If there is data, it will be replaced with whatever is being exported.
 

  1. When you click Next you are lead to a Transfer Summary. This will give you the opportunity to review information about the export

You can review the export. In this case the description line was edited to show what the column names are from the profile so that they will appear in this review.

When you click Next you'll see a final preview like this:



This example shows the final review with the Append to Spreadsheet option set. The data that is grayed out is showing what data appears on the spreadsheet and below that a sampling of what will be appended.

Click Finish and it will export the data to the spreadsheet. The speed of the export will be in direct relation to the amount of data being exported.

 

Tips and Tricks 

  1. Worksheets - When you create your profile you will want to make sure that you have the right worksheet specified. By default it will show whatever worksheets are in the workbook. If you want to have this data go to a new worksheet that doesn't already exist in the workbook then you can enter a new worksheet name here. When the export happens the new worksheet will be created to receive the exported data.
  2. Creating the file - If you don't have an existing spreadsheet to which you want to export your data, you can enter the path and file name that you want to use. If you don't put an extension on the file name it will do it for you. Again, the only file extension supported at this time is .xlsx.

 "Special Case" - There are two Data Item types that you might want to export that are "special case" items, they are ASSET_NAME and DATE. The ASSET_NAME is the name that is displayed in the tree. The DATE is needed for any stream data that is exported, so it is created automatically when you create the first Data Item that is a stream.

Saving Data When you create a profile many of the settings you make and Data Items you enter are written to .ini files and are remembered for future sessions.

 

What do we mean by the terms "Digital Stream" and "Analog Stream"?

When reading Knowledge Base articles or talking to support we will sometimes refer to Digital Stream and Analog Stream. This article explains what those are.

Digital Stream

A digital stream is a set of data that has defined increments of time which, depending on the data type used for the stream, can be Daily, Monthly, Quarterly, Semiannually, Yearly, or Undefined. The data in each cell is defined specifically by either manually entering the number, referencing another source either externally or within the software, inheriting the data, or importing the data from an outside source. But the specific number in each cell for each time increment can be changed manually. The digital stream will be some variation of this:

 

 

A digital stream can be used for production forecasting, production history, price, cost, and any other stream of data that might change from one month to the next, or one year to the next etc..

Analog Stream

An analog stream does not show date increments, but rather a beginning and ending date. The analog stream is a calculation of production forecasts based on inputs. The data that can be used to calculate the forecast include:

  • Start date
  • End date
  • Initial rate
  • Final rate
  • Curve type
  • Initial decline
  • Ending decline
  • Remaining
  • Prior @ PDS
  • Ultimate

There can be other factors but basically when you provide enough information, the rest is calculated. For example, if you provide a Start Date, Initial Rate, Final Rate, Curve Type and Initial Decline, the software will calculate the End Date, Remaining, Prior @ PSD, and Ultimate. If you were to provide the End Date, but not the Final Rate then that number will be calculated instead. Basically, with enough information provided, it will calculate the other fields. This means that the forecast for any given time increment will be calculated rather then manually entered for each increment. The analog stream will look something like this:


 Again, the analog stream is only used for production forecasts whereas digital streams are used for many different things and types of data.

Using the Well Scheduler

The Well Scheduler allows you to create a number of wells based on a Type Well.

 

When you create a drilling schedule, the newly created wells will have the same parent asset as the Type Well used. As such to create the well schedule you will find your Type Well in the Study tree and right click on the parent asset and choose Well Schedule:

 

 

You will get a dialog box to specify the schedule.

 

Here is what each of the columns represent:

Template Asset: This is the asset you want to use as your Type Well.

Start Date: This is the date that the drilling will start for this segment of the schedule. By default it will be today's date.

PSD Delay Months: This is the number of months between the completion of the drilling increment and the date used for the Production Start Date (PSD).

Number of Wells: This is the total number of wells that you intend to drill for this segment of your well schedule.

Interval Increment: This is the number of months it takes to drill a well.

Wells Per Increment:  This is the number of wells that will be created in each increment of the well drilling schedule.

 

Some examples

If you have three drilling rigs that each take two months to complete the drilling of a well and plan to drill 10 wells, you would enter 10 for the Number of Wells, 2 for Interval Increment and 3 for Wells Per Increment. 

Using the scenario above, if two of your rigs can drill a well in two months, but the third rig requires three months to drill a well, then you would need to use one line for the first two rigs and a second line in this well scheduler for the third rig,

If you plan to drill a number of wells, then take a break (perhaps because of weather) and then pick up again and continue the drilling schedule, then you would need to use one line in this well scheduler for the first segment of the drilling schedule, and another line for the next segment, the key thing to pay attention to here is the Start Date. 

If you need to use different wells as your type, you need to use a new line for the new type.

You can list several entries for the schedule using different wells as templates (type) or even the same well...you might see something when you're done that will look like this:

 


When you complete your schedule configuration, click Create. The wells will then be created and appear as sibling assets to the Type Well:


You can now rename each of the new assets to appropriate names.

Importing IHS Data

Importing IHS data

When you need to import IHS data from a .dp2 file, click File > Transfer (Import/Export). 

 

Since this is the same option as exporting make sure you specify Transfer In. 

You will need to browse to the .dri file to import.

Click Next chose what data you want to include.

You'll need to choose if you want to Update, Insert, or Reorganize your data. We'll go through each of the options.

 

 Update:

You'll need to specify the study that has the data that is being updated, and you'll need to identify the key that you will use to match the IHS data to the right asset in your database. API Code is a popular key because it is always unique. Click Finish for the transfer process to complete.

Insert:

Specify what data you want to include with the import of the IHS data and click Next. If you want to import all of the IHS data then select that asset in the left hand panel. Note that the IHS Root appears as an asset with children. When the import is complete, IHS Root will appear as an asset in your tree, and in this example it will be a child of the NM asset. Click Finish to complete the process.

Reorganize

The Reorganize option works the same way as the main Reorganize option works which is documented in the article titles How to use the Reorganize feature.