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

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


Complete Training Video Below


  1. Macro-Enabled Excel Spreadsheet with Cashflow and Oneline Comparison between ComboCurve and PHDWin
    1. Click here to navigate to the "ComboCurve: PHDWin 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:
0:27 - Study of .phz file for import
0:55 - Import to CC
1:15 - Subsequent imports of csv
2:10 - Naming and Partnerships
3:03 - Open in PHDWin
3:30 - Versions supported
4:08 - What imported to CC discussion
5:35 - Running econ in CC
6:00 - Comparison Spreadsheet
7:15 - Running econ in PHDWin
7:45 - Reviewing defaults/units in PHDWin
9:15 - Exporting csv Cash Flow & Oneline from CC
10:30 - Exporting econ output in PHDWin
12:20 - Comparing yearly cash flow and discussion of what the sheet has/does
14:15 - Fixing deltas - Units on NGL
15:30 - Lack of Water and NGL Rev et al on PHDWin outputs
16:15 - Export of PHDWin one liner (V2 connect on v2.11)
18:30 - Echoing Unique ID - Note: No longer needed in newest sheet!
20:15 - Looking at single well on one liner or unhiding the single well comparison tabs
21:20 - Fixing deltas - NGL volumes (and using unique ID to view well in PHDWin and CC)
24:00 - Extraneous production import and general comparison discussion
30:15 - Fixing deltas - Gas Revenue (due to gas price/diff being on $/Mcf rather than $/mmbtu basis)
36:45 - Reviewing PHDWin locations for econ inputs (to update the CC import econ inputs)
38:45 - Reimport forecasts to CC via .txt after exporting from PHDWin
39:45 - Export of CC to PHDWin (via csv files you can load manually in PHDWin)
42:00 - Discussion of all numeric Unique IDs in PHDWin that can cause problems with lookups in Excel.

Note: PHDWin sometimes has ID Codes 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.