Method and device for loading production data addition based on Scheduler module in numerical reservoir simulation

Abstract

The invention discloses a method and a device for loading production data and adding based on a Schedule module in numerical reservoir simulation, and solves the problems that when dynamic production data is added, due to format requirements, more prepared data, longer consumed time, huge data volume and high error rate, operation errors are caused after the data are loaded to the Schedule module, one-by-one troubleshooting is needed, and the data loading efficiency is high. In order to solve the problems of time waste and energy waste in the prior art, data preprocessing is adopted, data processing is carried out after data screening, the daily average data of the oil and water wells are quickly converted into data in a format meeting Scheduling module loading production data in ECLIPSE software, the accuracy and efficiency of data processing are improved, errors caused by huge data volume in the data arrangement process are reduced, and the data processing efficiency is improved. The precision of subsequent numerical simulation is improved; and key functions are set in batch processing, so that the working time is greatly saved, the efficiency is improved, and errors such as line crossing and line leakage caused by excessive lines are reduced. The invention is used in the technical field of oil-gas field development.

Description

Technical Field

[0001] The present invention relates to the technical field of oil and gas field development, and relates to a method and device for adding production data based on the Schedule module in reservoir numerical simulation. Background Art

[0002] Reservoir numerical simulation refers to using a computer to solve the reservoir mathematical model, simulate the underground oil and water flow, give the oil and water distribution at a specific moment, and at the same time predict the future development trend of the reservoir. After establishing a fine geological model, reservoir numerical simulation research can be carried out.

[0003] Before numerical simulation, it is necessary to have a comprehensive understanding of the research block, and as much known static and dynamic data as possible needs to be input in order to simulate the reservoir conditions closest to the real situation. According to the requirements of the mainstream numerical simulation software ECLIPSE, the reservoir numerical simulation data set includes two major categories: one is static data (initialization data), specifically including: reservoir fluid property data, physical property data, fracture and fault data; the other is dynamic data, which is all data related to time, including well completion data (perforation, recompletion, fracturing), production data of oil and water wells (monthly water injection, monthly oil production, monthly gas production, monthly water production), well event data (transfer injection, well shut-in, etc.), and pressure data (bottom hole flowing pressure).

[0004] The main tasks of reservoir numerical simulation are to predict the future of the oilfield, formulate the best development plan or adjustment plan, and predict the remaining oil enrichment areas, etc. Various static data need to be input at the initial stage of modeling. During the process of scheme prediction, dynamic production data needs to be continuously added, and this purpose can be achieved through the SCHEDULE module of the software. Due to the requirements of professional software, when adding dynamic production data, due to format requirements, a large amount of data needs to be prepared, which takes a long time and is prone to errors due to the huge amount of data. Summary of the Invention

[0005] The purpose of the present invention is to provide a method and device for adding production data based on the Schedule module in reservoir numerical simulation, which solves the problems such as high requirements for software proficiency, long data preparation time, and easy errors in adding current production dynamic data, enabling staff who do not understand the ECLIPSE software to easily complete the work of adding production dynamic data and do a good job in data preparation for reservoir numerical simulation.

[0006] The present invention provides a method for adding production data based on the Schedule module in reservoir numerical simulation, and the method includes the following steps:

[0007] Step 1: Process file preparation

[0008] Establish a data transfer file, including 1 text file named File 1; and a data table file named File 2;

[0009] Step 2 Preprocessing of production data

[0010] Based on the monthly production days preset in the model in the ECLIPSE software, the monthly oil production, monthly water production, and monthly gas production data in the monthly oil and water well report data table in File 2 are batch processed into the daily average production data of the current month using the average algorithm to form the oil and water monthly report data;

[0011] Step 3 Well name conversion

[0012] Batch define the Chinese well numbers in the oil and water monthly report data as English letters respectively;

[0013] Step 4 Data screening

[0014] Using the VLOOKUP command of the EXCEL function, match and call the well names and the daily average production data of the current month in the oil and water well monthly report data to the positions of the corresponding daily oil production, daily water production, and daily gas production data columns in File 2; place them in the corresponding columns of the conversion file and adjust the order to obtain the target daily average production data of the month, and the data type of the target daily average production data of the month is numerical;

[0015] Step 5 Data processing

[0016] According to the production data format loaded by the Schedule module in the ECLIPSE software, batch process the data in the data table in File 2 and convert it into the format required for the production data loaded by the Schedule module to obtain the target daily average production data table of the month;

[0017] Step 6 Data transfer

[0018] According to the production data format loaded by the Schedule module in the ECLIPSE software, in File 1, batch fill in the time step keywords according to the monthly production days preset in the model in the ECLIPSE software and arrange them month by month; place the daily average data of oil and water wells in File 2 into the corresponding columns in File 1 in chronological order; after modifying the file suffix to.VOL, it can be directly loaded into the software to achieve data transfer.

[0019] Preferably, for the process file preparation in Step 1, create 1 text file as a txt file and name it File 1, which is used to define the typesetting of the processed production dynamic data according to the production data format loaded by the Schedule module in the ECLIPSE software; create another data table file as an excel file and name it File 2. File 2 is a preprocessing file, which screens the data processed from the oil and water well monthly report data and converts the data format.

[0020] Preferably, in step 2 of the production data preprocessing, the monthly oil production, monthly water production, and monthly gas production data in the monthly report data table of oil and water wells are processed into the daily average production data of the current month; the preprocessing steps in the oil well monthly report data are as follows:

[0021] In step 201, first find the columns of monthly oil production, monthly water production, and monthly gas production, and divide them by the number of calendar days in the current month to obtain the daily average production data of daily oil production, daily water production, and daily gas production of the oil well;

[0022] In step S202, the columns of monthly oil production, monthly water production, and monthly gas production should also be divided by the underground density of crude oil in the target block to convert the measurement units.

[0023] Preferably, in step 3, in the monthly data file, edit the Chinese characters in the well number into English letters; according to the ECLIPSE software, the maximum number of characters allowed in the well number is 8; when converting the well name, only retain the first letter of the pinyin.

[0024] Preferably, in step 4 of data screening, copy and paste the well name in the monthly report data of oil and water wells and the daily average production data of the current month processed in step 2 into File 2 manually in batches; paste them into the fixed columns according to the production data format loaded in the Schedule module of the ECLIPSE software.

[0025] Preferably, the specific steps of step 4 data screening are as follows:

[0026] In step S301, first open File 2, create a new sheet1, and name it oil data;

[0027] In step S302, place all the oil well numbers in ascending or descending order as preset in the first column as the well number column;

[0028] In step S303, place the processed daily oil production, daily water production, and daily gas production data of the oil well in the fourth, fifth, and sixth columns vertically in the order corresponding to the well number and production date one by one;

[0029] In step S304, fill in the corresponding contents of the second, third, seventh, and eighth columns with OPEN for open well, LRAT for fixed liquid production, 1*, and / respectively;

[0030] In step S305, insert a row in the first row, write the keyword WCONHIST in the first column; write / in the first column of the last row;

[0031] In step S306, create a new sheet2 in File 2 and name it daily water production data;

[0032] In step S307, place all the water well numbers in the first column according to the preset program;

[0033] Step S308: Place the processed daily water injection data of the water well into the fifth column according to a preset program.

[0034] Step S309: Fill the corresponding contents of the second column, third column, fourth column, and sixth column with WATER, 1*, RATE, and / respectively.

[0035] Step S310: Insert a row in the first row, write the keyword WCONINJE in the first column; write / in the first column of the last row.

[0036] Among them, in step 4, data screening is to place the data in the corresponding columns of the conversion file based on the format requirements of the ECLIPSE software, adjust the order according to the ECLIPSE software data format requirements, and obtain the target monthly and daily average production data. The type of the target monthly and daily average production data is numerical, and two decimal places are reserved.

[0037] Preferably, step 5 further includes the following steps:

[0038] Step S401: Open File 1; write the time step keyword in it, and load the production dynamic data read by the ECLIPSE software according to time.

[0039] Step S402: Edit the time steps of all production dynamic data to be added this time; among them, the edited time step keywords can be reused, and only the year needs to be changed, which can be used for any reservoir numerical simulation block.

[0040] Step S403: Paste the oil data and water data in File 2 after the corresponding time step keywords in sequence, and the addition of production dynamic data is completed.

[0041] Among them, the ECLIPSE software requires input of the prediction time, start time, end time, and time interval, format: year-month-day.

[0042] The present invention provides a method for loading and adding production data based on the Schedule module in reservoir numerical simulation, which solves the problems that when adding dynamic production data, due to format requirements, a large amount of data needs to be prepared, it takes a long time, and the data volume is huge, and it is easy to make mistakes, resulting in calculation errors after the data is loaded into the Schedule module, and it is necessary to check one by one, wasting time and energy. The present invention adopts data preprocessing, performs data processing after data screening, quickly converts the daily average data of oil and water wells into the format that meets the requirements of loading production data in the Schedule module of the ECLIPSE software, improves the accuracy and efficiency of data processing, reduces the mistakes caused by the huge data volume in the data sorting process, and improves the accuracy of subsequent numerical simulation; key functions are set in batch processing, which greatly saves working time and improves efficiency, and reduces errors such as row skipping and missing rows caused by too many rows.

[0043] In another aspect of the present invention, there is also provided a device for adding production data based on the Schedule module in reservoir numerical simulation. The device includes: a reading module 501, a selection module 502, an acquisition module 503, and an update module 504;

[0044] The reading module 501 is configured to read the data of the monthly oil and water well report data sheet, perform data preprocessing, and obtain the monthly average production data;

[0045] The selection module 502 is configured to select the target reservoir block from the monthly average production data, convert the Chinese well names in the oil and water well monthly report data into English letters, and perform data screening on the daily average production data of the current month through the VLOOKUP command of the EXCEL function to obtain the target daily average production data of the month;

[0046] The acquisition module 503 is configured to generate monthly oil and water well data in the format of loading production data according to the Schedule module in the ECLIPSE software from the target daily average production data of the month, and obtain the target daily average production data sheet;

[0047] The update module 504 is configured to clear the data and start a new round of data processing work;

[0048] According to the format of loading production data in the Schedule module of the ECLIPSE software, batch process the data in the target daily average production data sheet and convert it into the format required for loading production data in the Schedule module; batch fill in the time step keywords according to the preset monthly production days in the model of the ECLIPSE software, arrange the daily average data of oil and water wells monthly, and place them in the corresponding columns in File 1 in chronological order; after modifying the file suffix name to.VOL, it can be directly loaded into the software to achieve data transfer.

[0049] The present invention provides a device for adding production data based on the Schedule module in reservoir numerical simulation, which solves the problems that when adding dynamic production data, due to format requirements, a large amount of data needs to be prepared, which takes a long time, and the data volume is huge, and it is easy to make mistakes, resulting in calculation errors after the data is loaded into the Schedule module, and it is necessary to check one by one, wasting time and energy. The present invention uses data preprocessing, performs data processing after data screening, quickly converts the daily average data of oil and water wells into the format that meets the requirements of loading production data in the Schedule module of the ECLIPSE software, improves the accuracy and efficiency of data processing, reduces the mistakes caused by the huge data volume in the data sorting process, and improves the accuracy of subsequent numerical simulation. BRIEF DESCRIPTION OF THE DRAWINGS

[0050] Figure 1It is a schematic flow chart of a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0051] Figure 2 It is a schematic flow chart of Embodiment 1 of a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0052] Figure 3 It is a schematic flow chart of the conversion of monthly and daily average data in a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0053] Figure 4 It is a schematic flow chart of the S140 process in a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0054] Figure 5 It is a block diagram of the S150 process of a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0055] Figure 6 It is a schematic structural diagram of a device of a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0056] Figure 7 It is a display diagram of the input prediction time of a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0057] Figure 8 It is a display diagram after intercepting to two decimal places of a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0058] Figure 9 It is a display diagram of splitting months and years of a method for adding production data based on the Schedule module in reservoir numerical simulation;

[0059] Figure 10 It is a display diagram of sorting after numericalization of columns I and K of a method for adding production data based on the Schedule module in reservoir numerical simulation.

[0060] Figure 11 It is a data column chart of a method for adding production data based on the Schedule module in reservoir numerical simulation Detailed implementation manners

[0061] Here, exemplary embodiments will be described in detail, and examples thereof are shown in the accompanying drawings. When the following description refers to the accompanying drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present invention.

[0062] Embodiment 1

[0063] An embodiment of the present invention provides a method for adding production data based on the Schedule module in reservoir numerical simulation, as Figure 1 shown, the method includes the following steps;

[0064] Step 1: Preparation of process files

[0065] Create a data transfer file, including 1 text file named File 1; a data table file named File 2; Step 2: Preprocessing of production data

[0066] According to the monthly production days preset in the model in the ECLIPSE software, use the average algorithm to batch process the monthly oil production, monthly water production, and monthly gas production data in the oil and water well monthly report data table in File 2 into the daily average production data of the current month, forming the oil and water monthly report data;

[0067] Step 3: Well name conversion

[0068] Batch define the Chinese well numbers in the oil and water monthly report data as English letters respectively;

[0069] Step 4: Data screening

[0070] Use the VLOOKUP command of the EXCEL function to match and call the well names and the daily average production data of the current month in the oil and water well monthly report data to the positions of the corresponding daily oil production, daily water production, and daily gas production data columns in File 2; place them in the corresponding columns of the conversion file and adjust the order to obtain the target daily average production data, and the type of the target daily average production data is numerical; retain two decimal places;

[0071] VLOOKUP is one of the most useful and important functions in Microsoft Excel. It is usually used to find specific values in a large data table, and manual intervention may be troublesome. The letter "V" in VLOOKUP stands for "vertical", so this function is sometimes also called vertical lookup.

[0072] Eclipse is a well-known cross-platform free integrated development environment (IDE). Initially mainly used for Java language development, by installing different plugins, Eclipse can support different computer languages, such as C++ and Python development tools. Eclipse itself is just a framework platform, but the support of numerous plugins makes Eclipse have the flexibility that is difficult for other IDE software with relatively fixed functions to have.

[0073] Step 5 Data processing (key description point - newly added step)

[0074] According to the production data format loaded by the Schedule module in the ECLIPSE software, batch process the data in the data table in File 2, which can be quickly implemented and converted into the format required by the Schedule module to load production data, and obtain the target monthly and daily average production data table; quickly process the conversion of a large number of production data formats, improve efficiency, and reduce the cumbersome work and mistakes caused by the large amount of data and single-well daily processing.

[0075] Step 6 Data transfer (adjustment step)

[0076] According to the production data format loaded by the Schedule module in the ECLIPSE software, in File 1, batch fill in the time step *DATE*MONTH*YEAR keywords according to the preset monthly production days in the model of the ECLIPSE software, and arrange them month by month; place the daily average data of oil and water wells in sheet-optimize 4 in File 2 into the corresponding *OIL*GAS*WATER*UPTIME columns in File 1 in chronological order; after modifying the file suffix name to.VOL, it can be directly loaded into the software to achieve data transfer.

[0077] In one embodiment, for the process file preparation in Step 1, create 1 text file as a txt file and name it File 1, which is used to define the layout of the processed production dynamic data according to the production data format loaded by the Schedule module in the ECLIPSE software; create another data table file as an excel file and name it File 2. File 2 is a preprocessing file that screens and converts the data format of the data processed from the monthly report data of oil and water wells.

[0078] In one embodiment, for the preprocessing of production data in Step 2, process the monthly oil production, monthly water production, and monthly gas production data in the monthly report data table of oil and water wells into the daily average production data of the current month; as Figure 3 shown, the processing steps in the monthly report data of oil wells are as follows;

[0079] In step 201, first find the columns of monthly oil production, monthly water production, and monthly gas production data, and divide them by the number of calendar days in the current month to obtain the daily average production data of daily oil production, daily water production, and daily gas production of the oil well. For example: in the monthly water well report data, first find the column of monthly water injection data, and divide it by the number of calendar days in the current month to obtain the daily average production data of daily water injection.

[0080] In step S202, the columns of monthly oil production, monthly water production, and monthly gas production data also need to be divided by the underground density of crude oil in the target block to convert the measurement units.

[0081] Generally, the data in the ECLIPSE software is in volume unit: cubic meter; while the data in the monthly oil well report is in mass unit: ton; therefore, unit conversion is required.

[0082] In one embodiment, in step 3, in the monthly data file, edit the Chinese characters in the well number into English letters; according to the ECLIPSE software, the maximum number of characters allowed for the well number is 8; when converting the well name, only retain the first letter of the pinyin. This enables fast and accurate data processing.

[0083] Among them, in step 4, data screening is to manually batch copy and paste the well name in the monthly oil and water well report data and the processed daily average production data of the current month into file 2; paste it into the fixed columns according to the production data format (*DATE*MONTH*YEAR*OIL*GAS*WATER*UPTIME) in the Schedule module of the ECLIPSE software. At this time, the data transfer is completed.

[0084] In one embodiment, step 4 further includes the following steps: as Figure 4 shown;

[0085] In step S301, first open file 2, create a new sheet1, and name it oil data;

[0086] In step S302, place all the oil well numbers in ascending or descending order as preset in the first column as the well number column;

[0087] In step S303, place the processed daily oil production, daily water production, and daily gas production data of the oil well in the fourth, fifth, and sixth columns vertically in the order corresponding to the well number and production date one by one;

[0088] In step S304, fill the corresponding contents of the second, third, seventh, and eighth columns with OPEN (open well), LRAT (fixed liquid production), 1* (default information, 1 can also be omitted, just leave one blank space), and / respectively;

[0089] In step S305, insert a row in the first row, write the keyword WCONHIST in the first column; write " / " in the first column of the last row.

[0090]

[0091] Step S306. In File 2, create a new sheet named Sheet2 and name it Daily Water Production Data.

[0092] Step S307. Place all well numbers in the first column according to a preset program.

[0093] Step S308. Place the processed daily water injection data of the wells in the fifth column according to a preset program.

[0094] Step S309. Fill the corresponding contents of the second, third, fourth, and sixth columns with 'WATER', 1*, 'RATE', and / respectively.

[0095] Step S310. Insert a row in the first row, write the keyword WCONINJE in the first column; write / in the first column of the last row.

[0096] Finally, the format of the daily production dynamic data of oil wells generated in Sheet1 of File 2 is as follows:

[0097] WCONHIST

[0098] 'C244”OPEN”LRAT' 2.09 16.03 0 1* /

[0099] 'D45-35”OPEN”LRAT' 2.85 1.90 0 1* /

[0100] 'D43-33”OPEN”LRAT' 0.72 7.61 0 1* /

[0101] 'D45-33”OPEN”LRAT' 0.00 11.84 0 1* /

[0102] /

[0103] Finally, the format of the daily production dynamic data of water wells generated in Sheet2 of File 2 is as follows:

[0104] WCONINJE

[0105] 'D40-31”WATER' 1* 'RATE' 23.8 /

[0106] 'XD201-3”WATER' 1* 'RATE' 9.6 /

[0107] 'D45-34”WATER' 1* 'RATE' 32.9 /

[0108] 'D41-27”WATER' 1* 'RATE' 30.0 /

[0109] / .

[0110] In one embodiment, the data screening in step 4 is placed in the corresponding (*oil* gas* water* uptime) *OIL*GAS*WATER*UPTIME column of the conversion file based on the ECLIPSE software requirement format, and the order is adjusted according to the ECLIPSE software data format requirement to obtain the target monthly and daily average production data. The type of the target monthly and daily average production data is numerical, and two decimal places are reserved.

[0111] Among them, step 5 further includes the following steps: as Figure 5 shown.

[0112] Step S401, open File 1; write the time step keyword in it, and load the production performance data read by the ECLIPSE software according to time;

[0113] Step S402, edit the time steps of all production performance data to be added this time; among them, the edited time step keywords can be reused, and only the year needs to be changed, which can be used for any reservoir numerical simulation block;

[0114] Step S403, paste the oil data and water data in File 2 after the corresponding time step keywords in turn, and the addition of production performance data is completed.

[0115] Among them, input the prediction time, start time and end time, and time interval according to the ECLIPSE software requirements, format: year-month-day.

[0116] Here is an example as Figure 7 shown.

[0117] Software requirements: Setup / time framework: input the prediction time, start time and end time, and time interval,

[0118] Format: 2002-jan-1;

[0119] Select Setup->Time Framework in the SCHEDULE main interface menu to open the Simulation Time Framework panel. You can define the report output time in the From: input box, define the report output frequency in Step By, modify it to 2, and Month can be modified to Day or Year, keep Month unchanged. Click New, add a new line, and define it in the following way:

[0120] In this panel, it is defined that a report step is output every two months from the start of production to December 31, 1973, corresponding to a set of production data, and a report step is output every month from January 1, 1974 to the end of production.

[0121] The present invention provides a method for adding production data based on the Schedule module in reservoir numerical simulation, which solves the problems that when adding dynamic production data, due to format requirements, a large amount of data needs to be prepared, which takes a long time, and the data volume is huge, and it is easy to make mistakes, resulting in calculation errors after the data is loaded into the Schedule module, and it is necessary to check one by one, wasting time and energy. The present invention adopts data preprocessing, and after data screening, data processing is carried out, quickly converting the daily average data of oil and water wells into the production data format that meets the Schedule module in the ECLIPSE software, improving the accuracy and efficiency of data processing, reducing the mistakes caused by the huge data volume in the data sorting process, and improving the accuracy of subsequent numerical simulation.

[0122] Embodiment 2

[0123] On the other hand, an embodiment of the present invention provides a device for adding production data based on the Schedule module in reservoir numerical simulation, as Figure 6 shown. The device includes: a reading module 501, a selection module 502, an acquisition module 503, and an update module 504;

[0124] The reading module 501 is used to read the data of the monthly report data table of oil and water wells, and perform data preprocessing to obtain the monthly average production data;

[0125] The selection module 502 is used to select the target reservoir block from the monthly average production data, and convert the Chinese well names in the monthly report data of oil and water wells into English letters. The daily average production data of the current month is screened through the VLOOKUP command of the EXCEL function to obtain the target daily average production data of the month;

[0126] The acquisition module 503 is used to generate monthly oil and water well data in the production data format loaded by the Schedule module in the ECLIPSE software according to the target daily average production data of the month, and obtain the target daily average production data table of the month;

[0127] The update module 504 is used to clear the data and start a new round of data processing work;

[0128] According to the production data format loaded by the Schedule module in the ECLIPSE software, batch process the data in the target monthly and daily average production data table and convert it into the format required for the Schedule module to load production data; batch fill in the time step keywords according to the preset monthly production days in the model in the ECLIPSE software, arrange the daily average data of oil and water wells month by month, and place them in the corresponding columns of File 1 in chronological order; after modifying the file suffix name to.VOL, it can be directly loaded into the software to achieve data transfer.

[0129] The present invention provides a device for adding production data based on the Schedule module in reservoir numerical simulation, which solves the problems that when adding dynamic production data, due to format requirements, a large amount of data needs to be prepared, which takes a long time, and the data volume is huge, and it is easy to make mistakes, resulting in calculation errors after the data is loaded into the Schedule module, and it is necessary to check one by one, wasting time and energy. The present invention uses data preprocessing, performs data processing after data screening, quickly converts the daily average data of oil and water wells into the format that meets the requirements of the Schedule module in the ECLIPSE software, improves the accuracy and efficiency of data processing, reduces the mistakes caused by the huge data volume in the data sorting process, and improves the accuracy of subsequent numerical simulation.

[0130] Embodiment III

[0131] The embodiments of the present invention will be described in more detail below with reference to the accompanying drawings.

[0132] Figure 1 It is a schematic flow chart of a method for adding production dynamic data in reservoir numerical simulation provided by an embodiment of the present invention, and the method for adding production dynamic data in reservoir numerical simulation provided by the embodiment of the present invention is applicable to any scenario of adding or modifying data in a reservoir numerical simulation scheme.

[0133] The method for adding production dynamic data in reservoir numerical simulation provided by this embodiment includes: as Figure 2 shown.

[0134] Step 1: Process file preparation

[0135] Step S11, file preparation: Create 1 txt file, name it File 1, which is an intermediate file used to typeset the processed production dynamic data in the format required by the ECLIPSE software; create another excel file, name it File 2, which is a preprocessing file obtained by screening and converting the data processed from the oil and water well monthly report data.

[0136] Here is an example: The original data is only for a certain small block, 432 well times. The following takes time period 2 as an example to elaborate the embodiment.

[0137] Time period 1: February 1997 - August 2012, 52096 rows vertically

[0138] Time period 2: September 2012 - March 2022, 53274 rows vertically

[0139] Create a data transfer file, including 1 text file named File 1; a data table file named File 2; basic original data: data from 2011 to 2012, a total of 2091 rows of data. Table 1 shows the form of the basic original data. For the purpose of understanding the form of the basic original data of the present invention, only part of the content is shown here, and the full content is 2091 rows

[0140] Table 1 Basic original data

[0141]

[0142] Step 2: Preprocessing of production data

[0143] Step S120, preprocessing of production data: Process the monthly oil production, monthly water production, and monthly gas production data in the monthly oil - water well report data table into the daily average production data of the current month

[0144] In the embodiment, in the oil well monthly report data, first find the corresponding columns of monthly oil production, monthly water production, and monthly gas production data, and divide by the number of calendar days in the current month to obtain the daily average production data, that is, daily oil production, daily water production, and daily gas production data

[0145] In the embodiment, in the water well monthly report data, first find the corresponding column of monthly water injection data, and divide by the number of calendar days in the current month to obtain the daily average production data, that is, daily water injection data

[0146] Make the data in the embodiment consistent with the table required by the software. For example, divide the data in columns 12, 13, and 14 in Table 2 by the number of days of the well in production in the corresponding month, that is, column 3. Batch - process the monthly oil - water well report data table into the daily average production data of the current month to form the oil - water monthly report data (daily data required in the numerical simulation);

[0147] See columns 27, 28, and 29 in Table 2; in this step, all #DIV / 0! (in columns 27 and 29, the denominators of the two columns are zero when calculating division) caused by production time being 0 are replaced with blanks, and abnormal points are removed to ensure the continuity of production time and prevent wrong - row running during data optimization and transfer

[0148] The tables and documents can be found in the basic original data table 1 of the embodiment in the embodiment folder (oilfield source data)

[0149] Table 2 Pre - processed data of the basic original data table 1

[0150]

[0151] Step 3: Well name conversion

[0152] Step S130, Well name conversion:

[0153] In the invention embodiment, in the monthly data file, the Chinese characters in the well number are edited into English letters;

[0154] Note that the ECLIPSE software allows a maximum of 8 characters for the well number. Therefore, when converting the well name, only the first letter of the pinyin is retained. For example, after conversion, Liu 85-33 becomes L85-33, and single quotes are added before and after the converted well number. For example, after conversion, Liu 85-33 becomes "L85-33".

[0155] In File 2, the data in Column 1 and Column 2 of the example basic data (Table 1 oilfield source data) are brought in, and Column 1 and Column 2 are adjusted to Column 2 and Column 1 respectively (date before well number), and sorted in the order of the well number to facilitate subsequent indicators; change the well name, select all, find and replace uniformly; it is necessary to clarify the combined characteristics of the block well names, and check for omissions after updating (which can be achieved by conventional functions). Due to the large amount of data, the replacement process is slow, but compared with replacing one by one, the method of the present invention speeds up by 500%.

[0156] Example simplification: Due to the huge amount of data, select the production data before December 2012 for operation, and only retain the data processed in Step 2 as required, forming Table 3 in File 2 as follows: Reduce the number of columns of the data;

[0157] Table 3 Basic original data Table 1 Processed data table

[0158]

[0159] Step 4: Data screening

[0160] Match and call the well name and the daily average production data of the current month processed in Step 2 in the monthly report data of oil and water wells to the daily oil production, daily water production, and daily gas production data columns at the corresponding positions in File 2, and place them in the corresponding *OIL*GAS*WATER*UPTIME columns of the conversion file according to the format requirements of the ECLIPSE software. The order is adjusted according to the software data format requirements, the data type is numerical, and the ROUND function is used to batch and accurately retain two decimal places for the daily production data.

[0161] See the first sheet in File 2, Production data collation, intercept to 2 decimal places and display in green background color, Columns I\J\K, as Figure 8 shown.

[0162] Step S140, Data screening:

[0163] In the embodiment, copy the well name and the production data after being processed in step 2 in the monthly report data of oil and water wells and paste them into File 2; paste them into the corresponding columns according to the format required by the ECLIPSE software;

[0164] In the embodiment, the format of the daily production dynamic data of an oil well is as follows:

[0165] WCONHIST

[0166] 'C244”OPEN”LRAT'2.09 16.03 0 1* /

[0167] 'D45-35”OPEN”LRAT'2.85 1.90 0 1* /

[0168] 'D43-33”OPEN”LRAT'0.72 7.61 0 1* /

[0169] 'D45-33”OPEN”LRAT'0.00 11.84 0 1* /

[0170] /

[0171] The first line "WCONHIST" represents the dynamic data of the oil well;

[0172] In the second line, "'C244'" represents the well number of the oil well; "'OPEN'" represents that the status of the oil well is open; "'LRAT'" represents the daily liquid production; "2.09" represents the daily oil production; "16.03" represents the daily water production; "0" represents the daily gas production; "1*" represents the data that can be defaulted; " / " represents the end of this sentence and cannot be defaulted;

[0173] In the third to fifth lines, the meanings of the data refer to the explanation in the second line;

[0174] The sixth line " / ", represents the end of this paragraph and cannot be defaulted;

[0175] In the embodiment of the invention, the format of the daily production dynamic data of a water well is as follows:

[0176] WCONINJE

[0177] 'D40-31”WATER'1*'RATE'23.8 /

[0178] 'XD201-3”WATER'1*'RATE'9.6 /

[0179] 'D45-34”WATER'1*'RATE'32.9 /

[0180] 'D41-27”WATER'1*'RATE'30.0 /

[0181] /

[0182] The first line "WCONINJE" represents the water well injection data;

[0183] In the second line, "'D40-31'" represents the water well number; "'WATER'" represents that the injection medium is water; "1*" represents the data that can be defaulted; "'RATE'" represents the daily injection volume (daily injection rate); "23.8" represents the daily injection volume; " / " represents the end of this sentence and cannot be defaulted;

[0184] In the third to fifth lines, the meanings of the data refer to the explanation in the second line;

[0185] The sixth line " / ", represents the end of this paragraph and cannot be defaulted;

[0186] Step S150, data transfer:

[0187] In the embodiment, according to the format required by the ECLIPSE software, write the time step keyword in File 1;

[0188] For example, the data of January 2022 is represented by the following three lines of data:

[0189] The first line: DATES

[0190] The second line: 1JAN 2022 /

[0191] The third line: /

[0192] The first line "DATES" represents the date;

[0193] The second line "1JAN 2022 / " represents January 1, 2022; the month is represented by an English abbreviation;

[0194] The third line " / ", represents the end of this paragraph and cannot be defaulted;

[0195] In the embodiment, paste the daily average data of oil and water wells in File 2 into File 1 according to the time; thus, the production data editing for 1 month is completed.

[0196] In the embodiment, for example, the monthly oil and water well data on January 1, 2022 is represented as:

[0197] DATES

[0198] 1JAN 2022 /

[0199] /

[0200] WCONHIST

[0201] 'C244”OPEN”LRAT'2.09 16.03 0 0 /

[0202] 'D45-35”OPEN”LRAT'2.85 1.90 0 0 /

[0203] 'D43-33”OPEN”LRAT'0.72 7.61 0 0 /

[0204] 'D45-33”OPEN”LRAT'0.00 11.84 0 0 /

[0205] /

[0206] WCONINJE

[0207] 'D40-31”WATER'1*'RATE'23.8 /

[0208] 'XD201-3”WATER'1*'RATE'9.6 /

[0209] 'D45-34”WATER'1*'RATE'32.9 /

[0210] 'D41-27”WATER'1*'RATE'30.0 /

[0211] 'D43-29”WATER'1*'RATE'12.8 /

[0212] /

[0213] In the embodiment, according to the above steps S110 - S150, the data of other months can be completed in sequence and summarized together, that is, the work of adding production performance data of the target research block is completed.

[0214] As Figure 3 shown, in the embodiment, preferably, step S120 includes:

[0215] Step S201, in the monthly oil well report data, first find the corresponding columns of monthly oil production, monthly water production, and monthly gas production, divide by the number of calendar days in the current month to obtain the daily average production data, that is, daily oil production, daily water production, and daily gas production data.

[0216] Step S202, generally, the data in the ECLIPSE software is in volume unit: cubic meter; while the data in the monthly oil well report is in mass unit: ton;

[0217] Therefore, the columns of monthly oil production, monthly water production, and monthly gas production data also need to be divided by the underground density of the crude oil in the target block to convert the measurement unit;

[0218] Step S203. In the embodiment, in the monthly report data of the water well, first find the corresponding monthly water injection data column, divide it by the number of calendar days in the current month to obtain the daily average data, that is, the daily water injection data.

[0219] As Figure 4 shown, in the embodiment, preferably, step S140 includes:

[0220] Step S301. First, open File 2, create a new sheet1 named oil data;

[0221] Step S302. Place all the oil well numbers in the first column according to a preset program;

[0222] Step S303. Place the processed daily oil production, daily water production, and daily gas production data of the oil wells into the fourth column, fifth column, and sixth column respectively according to a preset program;

[0223] Step S304. Fill the corresponding contents of the second column, third column, seventh column, and eighth column with 'OPEN', 'LRAT', 1*, and / respectively;

[0224] Step S305. Insert a row in the first row, write the keyword WCONHIST in the first cell; write / in the first cell of the last row;

[0225] Step S306. In File 2, create a new sheet2 named water data;

[0226] Step S307. Place all the water well numbers in the first column according to a preset program;

[0227] Step S308. Place the processed daily water injection data of the water wells into the fifth column according to a preset program;

[0228] Step S309. Fill the corresponding contents of the second column, third column, fourth column, and sixth column with 'WATER', 1*, 'RATE', and / respectively;

[0229] Step S310. Insert a row in the first row, write the keyword WCONINJE in the first cell; write / in the first cell of the last row;

[0230] Finally, the format of the daily production dynamic data of the oil wells generated in Sheet1 of File 2 is as follows:

[0231] WCONHIST

[0232] 'C244”OPEN”LRAT'2.09 16.03 0 1* /

[0233] 'D45-35”OPEN”LRAT'2.85 1.90 0 1* /

[0234] 'D43-33”OPEN”LRAT'0.72 7.61 0 1* /

[0235] 'D45-33”OPEN”LRAT'0.00 11.84 0 1* /

[0236] /

[0237] Finally, the daily production dynamic data format of the water well generated in Sheet 2 of File 2 is as follows:

[0238] WCONINJE

[0239] 'D40-31”WATER'1*'RATE'23.8 /

[0240] 'XD201-3”WATER'1*'RATE'9.6 /

[0241] 'D45-34”WATER'1*'RATE'32.9 /

[0242] 'D41-27”WATER'1*'RATE'30.0 /

[0243] /

[0244] As Figure 5 shown, in the embodiment, step S150 includes:

[0245] Step S401, open File 1; write the time step keyword in it, aiming to let the software read the production dynamic data according to time;

[0246] Step S402, edit the time steps of all production dynamic data to be added this time; for example, add the production dynamic data from January to December 2022 this time, and its time step keywords are as follows:

[0247] Specifically, the edited time step keywords can be reused, and only the year needs to be changed, which can be used for any reservoir numerical simulation block;

[0248] Step S403, paste the oil data and water data in File 2 after the corresponding time step keywords in sequence, and the addition of production dynamic data is completed.

[0249] Step 5, data processing

[0250] According to the production data format loaded by the Schedule module in the ECLIPSE software, batch optimization processing of data is carried out in File 2, which can be quickly converted into the format required by the Schedule module to load production data, quickly process the conversion of a large number of production data formats, improve efficiency, and reduce the cumbersome work and errors caused by the large amount of data and single-well daily processing.

[0251] Here is an example to illustrate Data Processing 1: Processing of year, month, and day

[0252] The time steps are day, month, and year. According to the software format requirements, for monthly data, the day is defaulted to 1. The original production time in column A needs to be split into month and year; select the text-to-columns function for operation, using the dot between the year and month as the delimiter to split the month and year. The specific operation is as Figure 9 and Figure 11 shown:

[0253] The processed format is shown in Table 5

[0254] Table of data before and after processing year, month, and day

[0255]

[0256] After splitting, they are year and month respectively. Adjust the order according to the software requirements, the day is 1, and the month and year are adjusted according to the split data. The number format is all integers, as shown in Table 6: In the first sheet of File 2, columns A, B, and C in the production data arrangement.

[0257] Table of data before adjusting month and year according to split data

[0258]

[0259] *DATE is all 1. Adjust the three columns of values to integer format, representing day, month, and year. After adjustment, it is shown in Table 7;

[0260] Table of data after adjusting month and year according to split data

[0261]

[0262] The collation of the production data date table is completed.

[0263] Step 2: Optimize and adjust the format of the data in the data preprocessing for the daily average production data of the current month;

[0264] Prepare the production file for the Schedule module: Refer to the example format and adjust the well number to the line above each group of production data. For example, select the name NAME as H71-X23 for optimization and adjustment. The specific content is as follows:

[0265]

[0266] The specific optimization and adjustment steps are as follows:

[0267] In step 501, copy the SHEET of production data collation in the daily average production data of the current month, name it Optimization 1, adjust the well names in column I, select the IF function in column J to sort according to the well numbers, with the starting serial number being 2, and use the if function for the cells below: =IF(I3=I2,J2+1,2), as shown in Table 8;

[0268] Table 8 Data table after selecting the IF function in column J of the daily average production data of the current month

[0269]

[0270] In step 502, starting from the last row, arrange all the well names in one column, i.e., column I, and set column J to 1, as shown in Table 8;

[0271] Table 9 Data table with column J set to 1 following the data in Table 8

[0272]

[0273] In step 503, move Optimization 1 and name it Optimization 2, and sort after numericalizing the values in columns I and J, as Figure 10 shown;

[0274] In step 504, after numerical sorting of columns I and J, add blank rows in front of 1, achieving blank rows above each well, laying a foundation for setting well numbers later; as shown in Table 10;

[0275] Table 10 Table with blank rows added after numerical sorting of columns I and J

[0276]

[0277] In step 505, paste *NAME in column M and start making the well number row. Refer to column B (all dates are 1) and set the function IF: =IF(B1=1,1,$M$1&I1), as shown in Table 11;

[0278] Table 11 Paste the name in column M of the table and set the function IF

[0279]

[0280] In step 506, move Optimization 2 and name it Optimization 3. After numericalizing column M, copy and insert it into column C, and delete columns A and B, as shown in Table 12;

[0281] Table 12 After numericalizing column M of the data table, copy and insert it into column C

[0282]

[0283] Step 507 renames Optimization 3 as Optimization 4, retains only the columns of Optimization 4, and deletes the others, as shown in Table 13;

[0284] Table 13 Content of the Optimization 4 Table

[0285]

[0286] Step 6, Data Transfer (Adjustment Step)

[0287] According to the production data format loaded by the Schedule module in the ECLIPSE software, in File 1, fill in the time step *DATE*MONTH*YEAR keywords in batches according to the preset monthly production days in the model and arrange them month by month; place the daily average data of oil and water wells in sheet - Optimization 4 of File 2 into the corresponding *OIL*GAS*WATER*UPTIME columns in File 1 in chronological order.

[0288] Paste the content of the Optimization 4 table into File 1 and insert fixed software keywords above, as follows:

[0289] *METRIC

[0290] *MONTHLY

[0291] *IGNORE_MISSING

[0292] *UPTIME_FRACTIONS

[0293] *UUCRATES

[0294] *DAY*MONTH*YEAR*OIL*GAS*WATER*UPTIME

[0295] The production data in the daily average production data of the month after loading is as shown below. After modifying the file suffix name, it can be directly loaded into the software to achieve data transfer.

[0296] The content of File 1 in this specific example of the embodiment is relatively large. To clarify the content, part of the content (the starting and ending data) in File 1 is as follows:

[0297] *METRIC

[0298] *MONTHLY

[0299] *IGNORE_MISSING

[0300] *UPTIME_FRACTIONS

[0301] *UUCRATES

[0302] *DAY*MONTH*YEAR*OIL*GAS*WATER*UPTIME

[0303] *NAME G17 1 8 2012 0.52 17.03 0.52 31 1 9 2012 0.50 13.00 0.47 30 1 10 2012 0.52 22.71 0.52 31 1 11 2012 0.47 18.20 0.50 30 1 12 2012 0.45 12.19 0.42 31

[0309] ……,

[0310] *NAME ZJ69 1 8 2012 2.94 120.35 1.23 31 1 9 2012 2.94 94.18 1.14 30 1 10 2012 2.94 120.74 1.17 31 1 11 2012 2.37 94.98 0.94 30

[0315] 1 12 2012 1.17 53.59 0.45 31.

[0316] After modifying the file suffix name to.VOL, it can be directly loaded into the software to achieve data transfer.

[0317] The present invention provides a method for loading production data added based on the Schedule module in reservoir numerical simulation, which solves the problems that due to the requirements of professional software, when adding a large amount of dynamic production data, due to format requirements, a large amount of data needs to be prepared, which takes a long time, and the data volume is huge, and it is easy to make mistakes, resulting in calculation errors after the data is loaded into the Schedule module, and it is necessary to check one by one, wasting time and energy. The present invention adopts data preprocessing, and after data screening, data processing is carried out, quickly converting the daily average data of oil and water wells into the production data format that meets the Schedule module in the ECLIPSE software. Key functions are set in batch processing, which greatly saves working time and improves efficiency, and reduces errors such as line skipping and missing lines caused by too many lines; improves the accuracy and efficiency of data processing, reduces mistakes caused by huge data volume in the data sorting process, and improves the accuracy of subsequent numerical simulation; key functions are set in batch processing, which greatly saves working time and improves efficiency, and reduces errors such as line skipping and missing lines caused by too many lines.

Claims

1. A method for adding production data based on the Schedule module in reservoir numerical simulation, characterized in that, the method comprises the following steps; Step 1: Process file preparation Create a data transfer file, including 1 text file named File 1; a data table file named File 2; Step 2: Production data preprocessing According to the monthly production days preset in the model in the ECLIPSE software, use the average algorithm to batch process the monthly oil production, monthly water production, and monthly gas production data in the oil and water well monthly report data table in File 2 into the daily average production data of the current month, forming the oil and water monthly report data; Step 3: Well name conversion Batch define the Chinese well numbers in the oil and water monthly report data as English letters respectively; Step 4: Data screening Use the VLOOKUP command of the EXCEL function to match and call the well names and the daily average production data of the current month in the oil and water well monthly report data to the positions of the corresponding daily oil production, daily water production, and daily gas production data columns in File 2; Place them in the corresponding columns of the conversion file and adjust the order to obtain the target daily average production data of the month, and the data type of the target daily average production data of the month is numerical; Step 5: Data processing According to the production data loading format of the Schedule module in the ECLIPSE software, batch process the data in the data table in File 2 and convert it into the format required for the production data loaded by the Schedule module to obtain the target daily average production data table of the month; Step 6: Data transfer According to the production data loading format of the Schedule module in the ECLIPSE software, in File 1, batch fill in the time step keywords according to the monthly production days preset in the model in the ECLIPSE software and arrange them month by month; Place the daily average data of oil and water wells in File 2 into the corresponding columns in File 1 according to the time sequence; After modifying the file suffix to.VOL, it can be directly loaded into the software to achieve data transfer.

2. A method for adding production data based on the Schedule module in reservoir numerical simulation according to claim 1, characterized in that, In the process file preparation in Step 1, create 1 text file as a txt file named File 1, which is used to define the layout of the processed production dynamic data according to the production data loading format of the Schedule module in the ECLIPSE software; A data table file is to create another excel file named File 2. File 2 is a preprocessing file, which screens the data processed from the oil and water well monthly report data and converts the data format.

3. A method for adding production data based on the Schedule module in reservoir numerical simulation according to claim 1, characterized in that, In Step 2: Production data preprocessing, the monthly oil production, monthly water production, and monthly gas production data in the oil and water well monthly report data table are processed into the daily average production data of the current month; The preprocessing steps in the oil well monthly report data are as follows: Step 201 First find the columns of monthly oil production, monthly water production, and monthly gas production data of the current month, divide by the number of calendar days of the current month to obtain the daily average production data of daily oil production, daily water production, and daily gas production of the oil well; In step S202, the monthly oil production, monthly water production, and monthly gas production data columns should also be divided by the underground density of crude oil in the target block to convert the measurement units.

4. A method for adding production data based on the Schedule module in reservoir numerical simulation according to claim 1, wherein, in step 3, in the monthly data file, edit the Chinese characters in the well number into English letters; according to the ECLIPSE software, the maximum number of characters allowed in the well number is 8; when converting the well name, only retain the first letter of the pinyin.

5. A method for adding production data based on the Schedule module in reservoir numerical simulation according to claim 1, wherein, in step 4, data screening is to manually batch copy and paste the well name in the monthly oil and water well report data and the processed daily average production data of the current month in step 2 into file 2; paste it into the fixed columns according to the production data format loaded in the Schedule module of the ECLIPSE software.

6. A method for adding production data based on the Schedule module in reservoir numerical simulation according to claim 5, wherein, the specific steps of step 4 data screening are as follows: Step S301, first open file 2, create a new sheet1 and name it oil data; Step S302, place all oil well numbers in ascending or descending order as preset in the first column as the well number column; Step S303, place the processed daily oil production, daily water production, and daily gas production data of the oil wells in the fourth, fifth, and sixth columns vertically in the order corresponding to the well number and production date one by one; Step S304, fill the corresponding contents of the second, third, seventh, and eighth columns with OPEN open well, LRAT fixed liquid production, 1*, / respectively; Step S305, insert a row in the first row, write the keyword WCONHIST in the first cell; write / in the first cell of the last row; Step S306, in file 2, create a new sheet2 and name it water data; Step S307, place all water well numbers in the first column according to the preset program; Step S308, place the processed daily water injection data of the water wells in the fifth column according to the preset program; Step S309, fill the corresponding contents of the second, third, fourth, and sixth columns with WATER, 1*, RATE, / respectively; Step S310, insert a row in the first row, write the keyword WCONINJE in the first column; write / in the first column of the last row.

7. A method for adding production data based on the Schedule module in reservoir numerical simulation according to claim 1, wherein, step 4 data screening is to place it in the corresponding columns of the conversion file according to the ECLIPSE software requirement format, adjust the order according to the ECLIPSE software data format requirement, and obtain the target daily average production data of the month. The target daily average production data type is numerical and retains two decimal places.

8. A method for adding production data based on the Schedule module in reservoir numerical simulation according to claim 1, wherein, step 5 further includes the following steps: Step S401: Open File 1; write the time step keyword in it, and load the ECLIPSE software to read the production performance data by time; Step S402: Edit the time steps of all production performance data to be added this time. Among them, the edited time step keywords can be reused, and only the year needs to be changed, which can be used for any reservoir numerical simulation block; Step S403: Paste the oil data and water data in File 2 after the corresponding time step keywords in sequence, and the addition of production performance data is completed.

9. A method for adding production data based on the Schedule module in reservoir numerical simulation according to claim 7, characterized in that, The ECLIPSE software requires input of the prediction time, start time and end time, and time interval, in the format: year-month-day.

10. A device for adding production data based on the Schedule module in reservoir numerical simulation, characterized in that, The device includes: a reading module 501, a selection module 502, an acquisition module 503 and an update module 504; The reading module 501 is used to read the data in the monthly oil and water well report data table, perform data preprocessing, and obtain the monthly average production data; The selection module 502 is used to select the target reservoir block from the monthly average production data, convert the Chinese well names in the monthly oil and water well report data into English letters, and perform data screening on the daily average production data of the month through the VLOOKUP command of the EXCEL function to obtain the target daily average production data of the month; The acquisition module 503 is used to generate monthly oil and water well data in the format of loading production data according to the Schedule module in the ECLIPSE software from the target daily average production data of the month, and obtain the target daily average production data table of the month; The update module 504 is used to clear the data and start a new round of data processing work; According to the format of loading production data according to the Schedule module in the ECLIPSE software, batch process the data in the target daily average production data table of the month and convert it into the format required for loading production data by the Schedule module; batch fill in the time step keywords according to the preset monthly production days in the model in the ECLIPSE software, arrange the daily average data of oil and water wells month by month, and place them in the corresponding columns in File 1 in chronological order; after modifying the file suffix to.VOL, it can be directly loaded into the software to achieve data transfer.

Images