OGRE Partners
Oil & Gas Data Conversion Software Development.
We develop custom software to convert Oil and Gas data from one format to another.
Email:
info(at)ogrepartners(dot)com
Data Conversion Samples
1. IHS Energy Group data format to OGRE NextGen / Continuum data format.
2. OGRE 2.x (Windows) data format to OGRE NextGen / Continuum data format.
Click
here
to download samples as a PDF file.
Sample #1. IHS Energy Group to OGRE NextGen / Continuum
Before (IHS Energy Group data format)
After (OGRE NextGen / Continuum data format)
IHS ENERGY GROUP US PRODUCTION DATA DMP2 1.1 COMMA 2001/01/15 2 "START_US_PROD","135010021744" REC1RCI,"135010021744","","SMITH B C UNIT","","CD","O" REC1STA,"02","INA",197707,,197011,197405,"35","OK","BLAINE","360","ANADARKO BASIN" REC1LIQ,"",10875,197011, REC1FLD,053113,"WATONGA-CHICKASHA TREND","","29 16N 11W C S2 NW" REC1OPE,007294,"CONOCO INCORPORATED" REC1ENG,35011202390000,,0.0,,,,,"21744" RECWHDR,"","",35011202390000,,,"SHUT IN-GENERAL","ONSHORE",35.83570,-98.39732,"T","N",,,"","","P" REC3YTD,1970,0,191,0,0,0 REC4OIL,"OIL",0,0,0,0,0,0,0,0,0,0,191,0 REC4WEL,"WELLS",0,0,0,0,0,0,0,0,0,0,1,0 REC3YTD,1971,1,5335,0,0,0 REC4OIL,"OIL",0,709,1718,168,0,184,360,537,356,0,373,930 REC4WEL,"WELLS",0,1,1,1,0,1,1,1,1,0,1,1 REC3YTD,1972,0,4893,0,0,0 REC4OIL,"OIL",738,719,552,361,544,359,359,356,179,359,367,0 REC4WEL,"WELLS",1,1,1,1,1,1,1,1,1,1,1,0 REC3YTD,1973,1,362,0,0,0 REC4OIL,"OIL",0,184,0,0,0,0,0,0,0,0,0,178 REC4WEL,"WELLS",0,1,0,0,0,0,0,0,0,0,0,1 REC3YTD,1974,0,94,0,0,0 REC4OIL,"OIL",,,,,94,,,,,,, REC4WEL,"WELLS",,,,,,,,,,,, REC3FST,1970,11,1,191,0,0,0,4223,0,0 REC3LST,1974,05,1,94,0,0,1,272,0,0 "END_US_PROD","135010021744" "START_US_PROD","23500210296" REC1RCI,"23500210296","","SMITH B C NE NW","1","CD","G" REC1STA,"02","INA",197707,197011,197011,197407,"35","OK","BLAINE","360","ANADARKO BASIN" REC1GAS,"",387446,197102, REC1LIQ,"",11272,197011, REC1FLD,053112,"WATONGA-CHICKASHA","CUNNINGHAM","29 16N 11W C S2 NW" REC1OPE,003918,"BRACKEN ENERGY COMPANY" REC1ENG,35011202390000,1.19,0.85,9722,9524,9530,,"434147" RECWHDR,"1","",35011202390000,9722,19701112,"PLUGGED AND ABANDONED","ONSHORE",35.83570,-98.39732,"T","N",,,"","","P" REC2TST,19701112,,5659,6735,5918,"C",,,,2238,IP REC2TST,19710126,190,5470,6586,5859,"C",,,,,CAP REC2TST,19710407,31026,5185,6275,5714,"C",,,,,CAP REC2TST,19710903,47302,4494,5510,5313,"C",,,,528,CAP REC2TST,19721215,149929,2500,3182,3575,"C",,,,,CAP REC2TST,19730815,151880,2417,3079,3475,"C",,,,,CAP REC3YTD,1970,0,190,0,0,0 REC4OIL,"OIL",0,0,0,0,0,0,0,0,0,0,190,0 REC3YTD,1971,0,5330,0,68442,0 REC4OIL,"OIL",0,709,1717,168,0,183,359,536,355,0,373,930 REC4GAS,"GAS",0,10642,20194,0,0,3777,5979,6191,3295,395,6889,11080 REC3YTD,1972,0,5390,0,82383,0 REC4OIL,"OIL",737,718,552,361,544,359,359,856,179,358,367,0 REC4GAS,"GAS",9680,8908,9383,8584,8252,6295,6868,6542,5459,5604,5072,1736 REC3YTD,1973,0,362,0,67312,0 REC4OIL,"OIL",0,184,0,0,0,0,0,0,0,0,0,178 REC4GAS,"GAS",819,4,45,128,0,0,59,0,0,11813,29045,25399 REC3YTD,1974,0,0,0,169309,0 REC4GAS,"GAS",18868,45364,30753,23010,25828,23945,1541,,,,, REC3FST,1970,11,0,190,0,0,0,4217,0,50473 REC3LST,1974,07,0,0,0,1541,0,178,0,235566 "END_US_PROD","23500210296"
tag = "3.1!ASSET" (asset "SMITH B C UNIT" (data "inputs" ("ProductionRate.gas#gas1->A1->INITIAL_Y@ProductionRate.oil#oil1->A1->INITIAL_Y" "Correlation" (correlation "ProductionRate.gas#gas1->Analog.ProductionRate.gas#A1->Scalar.ProductionRate.gas#INITIAL_Y" "ProductionRate.oil#oil1->Analog.ProductionRate.oil#A1->Scalar.ProductionRate.oil#INITIAL_Y" 0.9999 true)) ("oil" "History.ProductionRate.oil" (stream "bbl/month" (monthly 1/1/1970 12/1/1974 0 0 0 0 0 0 0 0 0 0 191 0 0 709 1718 168 0 184 360 537 356 0 373 930 738 719 552 361 544 359 359 356 179 359 367 0 0 184 0 0 0 0 0 0 0 0 0 178 0 0 0 0 94 0 0 0 0 0 0 0 )))("lease" "text" "O") ("wellname" "text" "SMITH B C UNIT") )) (asset "SMITH B C NE NW 1" (data "inputs" ("gas" "History.ProductionRate.gas" (stream "MCF/month" (monthly 1/1/1970 12/1/1974 0 10642 20194 0 0 3777 5979 6191 3295 395 6889 11080 9680 8908 9383 8584 8252 6295 6868 6542 5459 5604 5072 1736 819 4 45 128 0 0 59 0 0 11813 29045 25399 18868 45364 30753 23010 25828 23945 1541 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ))) ("oil" "History.ProductionRate.oil" (stream "bbl/month" (monthly 1/1/1970 12/1/1974 0 0 0 0 0 0 0 0 0 0 190 0 0 709 1717 168 0 183 359 536 355 0 373 930 737 718 552 361 544 359 359 856 179 358 367 0 0 184 0 0 0 0 0 0 0 0 0 178 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 )))("lease" "text" "G") ("wellname" "text" "SMITH B C NE NW") ))
Sample #2. OGRE 2.x (Windows) data to OGRE NextGen / Continuum
Before (OGRE 2.x Windows data format)
After (OGRE NextGen / Continuum data format)
INSERT QUERY NAME = 'BOREN 3-15A2 PNP' FLD_NAME = 'BLUEBELL' STATE = 'UT' CNTYNAME = 'DUCHESNE' RESCAT = 'P2' PROP_SUB = '' OPR = '999001' PC = '06' SEC = '15' TWP = '1S' RGE = '2W' LOCATION = '1S2W15' MAJOR = 'O' SUMMARY = '' ENDQUERY NAME NAME = 'BOREN 3-15A2 PNP' FLD_NAME = 'BLUEBELL' STATE = 'UT' CNTYNAME = 'DUCHESNE' RESCAT = 'P2' PROP_SUB = '' OPR = '999001' PC = '06' SEC = '15' TWP = '1S' RGE = '2W' LOCATION = '1S2W15' MAJOR = 'O' SUMMARY = '' ENDNAME LINES BASE 101 BOREN 3-15A2 PNP 102 DUCHESNE, UT 103 BLUEBELL (WASATCH, LGR/CP70) 104 DEVON ENERGY 105 PROVED NON PRODUCING 111 SET PREMISE PRICE ANNUAL 117 CASE $COM_RMR 210 0.502272 0 500 1.5 OIL 04 01 2003 221 OIL 0.0000 0.442125 19.15 4.0 1 222 GAS 0.0000 0.442125 2.48 4.0 0 223 PLANT 0.0000 0.442125 13.58 4.0 0 410 OIL HARMONIC 85.0000 4400.0000 X 80.0000 MB M 460 GAS OIL LIN 2.0000 2.0000 TO LIFE 462 PLANT GAS LIN 19.2000 19.2000 TO LIFE 1000.0000 601 SET SHRINK = GAS 602 DATA SHRINK% : 42 TO LIFE ! 2000 CALCULATED BY ENGINEER 615 DATA OILP : CALL OIL 616 DATA GASP : CALL GAS 617 DATA PLANTP : CALL PLANT 622 COMPUTE GASP = GASP + -0.53 ! 2000 YE PLAN GAS DIFF 623 COMPUTE GASP = GASP - 0.0 ! 2000 YE PLAN TRANS & GATH FEE 624 COMPUTE OILP = OILP + 0.0 ! 2000 YE PLAN OIL DIFF 625 COMPUTE PLANTP = PLANTP + 6.74 ! 2000 YE PLAN PLANT DIFF 642 ! COMPUTE GASP = GASP - 0.50 644 ! COMPUTE OILP = OILP + 1.5 646 SET BTU = 1.3 ! 2000 YE PLAN BTU 650 ! COMPUTE PLANTP = PLANTP - 0.11 ! PER LEDBETTER 3/14/00 685 RISK = 1.0 686 PS = 1.0 801 INVEST -2 MOS G 175 0 0 901 &P.LOCATION 903 RESERVES FOR W90-220 (50 MBO) & LGR/CP70 (30 MBO) 904 NOMINAL LOE - COMMINGLED WITH PDP 920 USED FIELD AVG PLANT YIELD & GAS SHRINKAGE 921 NET GAS ACCOUNTS FOR SHRINKAGE FACTOR OF 48.4 (100 - 48.4 = 51.6) - 9.6 FOR FUEL ENDLINES ENDINSERT UTILITY_CASE $COM_RMR LINES BASE 106 2001 PLAN PRICING 107 DEVON ENERGY CORPORATION 120 1 99 12 12 31 2000 10 1 121 12 12 12 12 125 SET RPTFRM = 3 127 SET MAXLIFE = 2050 AD 128 0 5 10 12.5 15 20 25 30 40 50 129 55 60 65 70 75 80 85 90 95 100 640 SET DMSIZE 12 12 641 SET PRODTIME = M ENDLINES END
tag = "3.2.3!ASSET" (asset "BOREN 3-15A2 PNP" (data "inputs" ("ProductionRate.gas#gas1->A1->INITIAL_Y@ProductionRate.oil#oil1->A1->INITIAL_Y" "Correlation" (correlation "ProductionRate.gas#gas1->Analog.ProductionRate.gas#A1->Scalar.ProductionRate.gas#INITIAL_Y" "ProductionRate.oil#oil1->Analog.ProductionRate.oil#A1->Scalar.ProductionRate.oil#INITIAL_Y" 0.9999 true)) ( "streamStartDate" "date" 1/1/1999 ) ( "digitalEndDate" "date" 1/1/2049 ) ( "discountDate" "date" 12/31/2000 ) ( "discountNPV" "Rate" 10 ) ( "discountMethod" "int" 1 ) ( "gwi" "Interest.Working.Gross" ( stream "fraction" 0.0 "" (yearly 1/1/1999 1/1/2049 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 0.502272 ))) ( "cost1" "OpCost.Input.RatePerWell" ( stream "$/month" 0.0 "$" (yearly 1/1/1999 1/1/2049 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ))) ( "cost1" "OpCost.Input.Rate" ( stream "$/well/month" 0.0 "$" (yearly 1/1/1999 1/1/2049 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 ))) ("opcost" "StringList" ("cost1")) ( "tax1" "TaxRate.Advalorem" ( stream "%" 0.0 "" (yearly 1/1/1999 1/1/2049 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 ))) ( "majorPhase" "text" "oil" ) ( "psd" "date" 04/01/2003 ) ("caseIdNotes" "bigText" "101 BOREN 3-15A2 PNP 102 DUCHESNE, UT 103 BLUEBELL (WASATCH, LGR/CP70) 104 DEVON ENERGY 105 PROVED NON PRODUCING 106 2001 PLAN PRICING 107 DEVON ENERGY CORPORATION 901 &P.LOCATION 903 RESERVES FOR W90-220 (50 MBO) & LGR/CP70 (30 MBO) 904 NOMINAL LOE - COMMINGLED WITH PDP 920 USED FIELD AVG PLANT YIELD & GAS SHRINKAGE 921 NET GAS ACCOUNTS FOR SHRINKAGE FACTOR OF 48.4 (100 - 48.4 = 51.6) - 9.6 FOR FUEL ") ( "num" "NumberOfWells" ( stream "" 0.0 "" (yearly 1/1/1999 1/1/2049 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ))) ( "oil1" "Interest.Revenue.Net.oil" ( stream "fraction" 0.0 "" (yearly 1/1/1999 1/1/2049 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 ))) ( "oil1" "Price.oil" ( stream "$/bbl" 0.0 "$" (yearly 1/1/1999 1/1/2049 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 19.15 ))) ( "oil1" "TaxRate.Severance.Percent.oil" ( stream "%" 0.0 "" (yearly 1/1/1999 1/1/2049 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 ))) ( "gas1" "Interest.Revenue.Net.gas" ( stream "fraction" 0.0 "" (yearly 1/1/1999 1/1/2049 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 0.442125 ))) ( "gas1" "Price.gas" ( stream "$/mcf" 0.0 "$" (yearly 1/1/1999 1/1/2049 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 2.48 ))) ( "gas1" "TaxRate.Severance.Percent.gas" ( stream "%" 0.0 "" (yearly 1/1/1999 1/1/2049 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 ))) ("phases" "StringList" ("oil#oil1" "gas#gas1" )) ( "INVEST_TAN" "Capital.Gross" ( stream "M$" 0.0 "" (monthly 2/1/2003 2/1/2003 175.0 ))) ("INVEST_TAN" "DepreciationMethod.Book" (depreciation (schedule "schedule:ACRS7Yr") false)) ("INVEST_TAN" "DepreciationMethod.CostRecovery" (depreciation (schedule "schedule:ACRS7Yr") false)) ("INVEST_TAN" "DepreciationMethod.Foreign" (depreciation (schedule "schedule:ACRS7Yr") false)) ("INVEST_TAN" "DepreciationMethod.Tax" (depreciation (formula "formula:UOP") false)) ("oil1" "ProductionRate.oil" (stream "bbl/month" 0.0 "bbl" (yearly 04/01/2003 04/01/2003 -9.123E19) ( segment 1 ("START_DATE" "date" 04/01/2003) ("CURVE_TYPE" "int" 4 "") ("EFFECTIVE_DECLINE" "float" 0.85 "") ("INITIAL_Y" "Scalar.ProductionRate.oil" 4400.0000 "bbl/month" ) ("TOTAL_CUMULATION" "Scalar.ProductionRate.oil" 80.0 "MBBL") )) ) ( "oil_oil1_gas_gas1" "Ratio" ( stream "mcf/bbl" 0.0 "mcf/bbl" (yearly 04/01/2003 04/01/2003 -9.123E19 ) ( segment 1 ("START_DATE" "date" 04/01/2003) ("CURVE_TYPE" "int" 1 "") ( "INITIAL_Y" "Scalar.Ratio" 2.0 "mcf/bbl") ( "FINAL_Y" "Scalar.Ratio" 2.0 "mcf/bbl") ("END_DATE" "date" 1/1/2049 ) ))) ("Ratio" "StringList" ("oil_oil1_gas_gas1" )) ( "nonConvertedInfo" "bigText" "111 SET PREMISE PRICE ANNUAL 117 CASE $COM_RMR 121 12 12 12 12 125 SET RPTFRM = 3 127 SET MAXLIFE = 2050 AD 128 0 5 10 12.5 15 20 25 30 40 50 129 55 60 65 70 75 80 85 90 95 100 223 PLANT 0.0000 0.442125 13.58 4.0 0 460 GAS OIL LIN 2.0000 2.0000 TO LIFE 462 PLANT GAS LIN 19.2000 19.2000 TO LIFE 1000.0000 601 SET SHRINK = GAS 602 DATA SHRINK% : 42 TO LIFE 615 DATA OILP : CALL OIL 616 DATA GASP : CALL GAS 617 DATA PLANTP : CALL PLANT 622 COMPUTE GASP = GASP + -0.53 623 COMPUTE GASP = GASP - 0.0 624 COMPUTE OILP = OILP + 0.0 625 COMPUTE PLANTP = PLANTP + 6.74 640 SET DMSIZE 12 12 641 SET PRODTIME = M 646 SET BTU = 1.3 685 RISK = 1.0 686 PS = 1.0 " ) ( "INVEST" "StringList" ( "INVEST_TAN" )) ( "investments" "StringList" ( "INVEST" )) ( "tangible" "StringList" ( "INVEST_TAN" )) ("NAME" "text" "BOREN 3-15A2 PNP") ("FLD_NAME" "text" "BLUEBELL") ("STATE" "text" "UT") ("CNTYNAME" "text" "DUCHESNE") ("RESCAT" "text" "P2") ("PROP_SUB" "text" "") ("OPR" "text" "999001") ("PC" "text" "06") ("SEC" "text" "15") ("TWP" "text" "1S") ("RGE" "text" "2W") ("LOCATION" "text" "1S2W15") ("MAJOR" "text" "O") ("SUMMARY" "text" "") ("caseTitle" "text" "BOREN 3-15A2 PNP") ))