ComboCurve: ARIES Conversions
ARIES Conversions
Below is a comparison file and video tutorial on exporting and importing ARIES databases in/out of CC.
Comparison File
The files and instructions below allow QC and comparison of any import from or export to ARIES.
If you have any further questions, please create a ticket to schedule a demo of these processes with Alan Harris.
Download the .zip file attached below including three files to facilitate comparison (if the download link does not work, email alan.harris@combocurve.com to send the files):
- A blank ARIES .accdb file to use to import the csv/txt if not using your own db -and- it also has the ComboCurve formatted objects a) AC_ONELINEONE table b) CC_ONELINE query to populate the Excel spreadsheet.
- An ARIES .SSF file to allow ARIES to output a copy/paste-able cash flow.
- A macro-enabled Excel workbook where you drop cash flows and oneline summaries for comparison between the programs. Note that this file has detailed instructions as shown in the snip describing the tabs below.
Note: ARIES sometimes has PROPNUMS that are all numeric. When these exceed 15-characters, Excel auto-converts these to scientific notation by default. This may make comparison by (X,V)LOOKUP in Excel difficult. One mitigation in O365 is to ensure "Additional Options" on File==>Options==>Data==>Automatic Data Conversion is checked to allow the popup to prevent automatic data conversion upon loading csv files into Excel.
Video Tutorial
- Attached below in this article is a zip file with a "BROKEN" sample db that's similar to the problems encountered in the video so you can follow along and try the fixes yourself. It is not exact since it was created after-the-fact but it is very similar.
Attached below in this article is a zip file with a "BROKEN" sample db that's similar to the problems encountered in the video so you can follow along and try the fixes yourself. It is not exact since it was created after-the-fact but it is very similar.
Table of Contents - Timestamps:
1:30 - Unsupported Items KB article
2:00 - Helpful and required items
4:30 - ARIES Project/Scenario/Settings
5:50 - ARIES runs w/ SSF and correct output to compare to CC
7:25 - Import to CC
8:00 - Mapping Headers
9:23 - How to remap later in the process
10:04 - Custom renamed headers
10:20 - Naming project and scenario/settings selection management
10:30 - ELT creation from ARIES Sidefiles/Lookups
11:15 - Import "forecasts only"
11:45 - Copying out ARIES Cash Flow and Oneline run to populate Comparison Spreadsheet
12:45 - Anatomy of Comparison Spreadsheet
13:10 - Overlay interpreter
13:30 - Oneline from Access Query
14:25 - CC Import finished
14:30 - Download error report
15:30 - CC Scenario - filtering
15:45 - Run Econ
16:29 - csv export of Aggregate Yearly Cash Flow & Well Oneline Cash Flow
18:36 - Running the Excel macro to "set" the comparison
19:25 - "Control" L to update the columns (if needed)
20:15 - Analyzing the comparison to identify problems
22:40 - Oneline comparison
23:40 - Single well drilldown in oneline sheet
23:15 - Using ChosenID to view in ARIES & CC, both.
26:45 - Fixed one well and update in the comparison sheet
27:25 - "All numeric" issues in Excel for Propnums/ChosenID mismatch
28:30 - Overlay line issue fix (User Defined Workstream)
30:05 - Fixing the issue in CC (Risking)
31:15 - Exporting as .txt file to update forecasts only
32:40 - Using hidden Single Well tabs to drill down w/ 1 well cash flow for deep analysis
35:30 - Analyzing another mismatch
36:00 - LOAD line in ARIES for volumetric Forecast (how to bring it in to match).
37:20 - Match to "errored lines" or "what's intended"?
39:30 - Viewing in ARIES and bringing into CC - expenses
41:10 - Dates discussion
42:00 - Importing Volumetric Forecast
44:00 - Actual or Forecast discussion
45:30 - Matched!
46:15 - Importing subsequent forecast sets through .txt (ARIES Econ Data exports)
47:30 - Exporting CC forecast sets to ARIES
48:50 - "Force Forecast History Match"
49:20 - Importing to ARIES
49:55 - Exporting full project to ARIES (ACCDB or CSV/TXT)
50:55 - Export Models as Sidefiles
51:20 - Export Forecast Also as Volumes
52:00 - Opening in ARIES and comparing the exported file in the Comparison Spreadsheet
Related Articles
ComboCurve: Import ARIES Database
Import ARIES Database For a video tutorial on import/exporting and QC tieouts of econ see the following article - ComboCurve: ARIES Conversions Also to see items unsupported see the following article - ComboCurve: ARIES Import/Export Conversions – ...ComboCurve: ARIES Import/Export Conversions – Currently Unsupported Items
The current version of the front-end ARIES import interface handles the majority of ARIES database imports and exports. Some of the more complex and less commonly used syntax, especially certain overlay definitions, might not be currently handled, ...ComboCurve: PHDWIN Forecast to ComboCurve Forecast Parameter Conversions & Importing
Importing PHDWin Forecast Parameters into ComboCurve In this article we will discuss the differences between PHDWin forecast parameters and ComboCurve parameters, how to convert between the two, and finally how to import projections from PHDWin to ...ComboCurve: Export Scenario to ARIES
Export Scenario to ARIES When exporting there are two types of exports Exports entire contents of economics into an MS Access database for use in ARIES, or A CSV file that can be copied into the AC_ECONOMIC table and a TXT file that can be imported ...ComboCurve: Discounting CC vs ARIES
Discounting CC vs ARIES Which cashflow discounting methods match between ComboCurve and ARIES? In ComboCurve, choose your Project and Scenario and go to General Options and set: Discounting Method to Yearly (N=1), and Cash Accrual Time = Mid Month In ...