ComboCurve: ARIES Video Tutorial - Import/Export (Scenario & Forecast) - Overview & Comparison

ComboCurve: ARIES Video Tutorial - Import/Export (Scenario & Forecast) - Overview & Comparison



  1. Macro-Enabled Excel Spreadsheet with Cashflow and Oneline Comparison between ComboCurve and ARIES
    1. Click here to navigate to the "ComboCurve: ARIES Import/Export Conversion QC and Comparison - Files" KB Article to download required files to facilitate comparison
    2. See the black "README" tab inside the sheet for instructions
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