Rock chemical compressibility evaluation method based on element logging
By using a rock chemical compressibility assessment method based on elemental logging and constructing a compressibility index model using multiple regression analysis, the problem of insufficient adaptability of existing technologies in shale oil and gas reservoir exploration is solved. This enables more accurate compressibility assessment and optimized fracturing design, thereby improving oil and gas development efficiency and cost-effectiveness.
Patent Information
- Application Number
- CN202411236084.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-04
- Publication Date
- 2024-11-15
- Estimated Expiration
- 2044-09-04
AI Technical Summary
Existing compressibility assessment methods have low adaptability to special geological conditions in shale oil and gas reservoir exploration, cannot clearly reveal the boundaries of stratigraphic intervals, and cannot reflect the stratigraphic sedimentary cycle sequence of the block.
A rock chemical compressibility assessment method based on elemental logging was adopted. After preparing elemental logging data, rock chemical indices were calculated, and the weights of rock chemical indices with strong correlations were determined by multiple regression analysis to construct a compressibility index model.
It improves the accuracy and applicability of compressibility assessment, can more accurately reflect the chemical composition and physical properties of rocks, optimize fracturing design, increase oil and gas production, reduce ineffective fracturing attempts, and lower costs.
Smart Images

Figure CN118958962A_ABST
Abstract
Description
Technical Field
[0001] The invention belongs to the technical field of oil and gas exploration, is used for the exploration and development of shale oil and gas reservoirs in petroleum geophysics, and is particularly a rock chemical compressibility evaluation method based on element logging. Background Art
[0002] Fracturability evaluation is an important basis for measuring the response of reservoirs to fracturing transformation. Especially in the development of shale gas reservoirs, it is of great significance for selecting fracturing sections, optimizing fracturing parameters and predicting economic benefits.
[0003] In the evaluation of the compressibility of shale reservoirs, commonly used evaluation indicators include geological evaluation indicators, shale volume fracturing evaluation indicators and engineering technology evaluation indicators. These indicators can help determine the total geological reserves, geological "sweet spot" area, maturity, etc. of the reservoir, and obtain data such as the brittleness parameters, natural fractures, formation inclination, and ground stress of the reservoir rock, and then evaluate the feasibility of forming volume fractures in the reservoir. In practical applications, in addition to the brittleness index, the effect of fracture toughness on fracture extension is also considered, and the concept of compressibility index is introduced. In addition, there are studies that comprehensively evaluate the compressibility of shale reservoirs by calculating parameters such as the effective thickness, effective porosity, total organic carbon content, and brittleness index of shale reservoirs, and combining fracturing construction process parameters, microseismic monitoring results and other data. In addition, in the evaluation method of the compressibility of deep tight sandstone reservoirs, a fitting formula of fracture energy density-elastic modulus based on rock triaxial experiment is proposed, and the rock brittleness index is determined by the mineral composition method and elastic modulus-Poisson's ratio method, and the fracture development index is determined by the rock fracture criterion, which comprehensively considers the influence of rock brittleness, fracture toughness, geostress environment and the degree of natural fracture development. In the evaluation method of the compressibility of shale gas reservoirs considering the influence of fracture toughness, the critical mechanical energy release rate is introduced, and the average critical mechanical energy release rate is defined. Combined with the brittleness index, a shale gas reservoir compressibility evaluation model with the fracture development index as a quantitative indicator is established.
[0004] The existing compressibility evaluation methods mainly include the following:
[0005] (1) Shale oil reservoir compressibility evaluation method: This method is reported by the Energy Industry Shale Oil Standardization Technical Committee and specifies the evaluation indicators and methods for shale oil reservoir compressibility, which is applicable to the evaluation of shale oil reservoir compressibility.
[0006] (2) A new method for evaluating the fracturability of deep tight sandstone reservoirs: Based on triaxial rock experiments, a fitting formula was established. The mineral composition method and elastic modulus-Poisson's ratio method were used to determine the rock brittleness index and the fracture development index. The influence of rock brittleness, fracture toughness, geostress environment and the degree of natural fracture development were comprehensively considered, and the hierarchical analysis method was used to calculate the weights of each factor. An evaluation method for the fracturability of deep tight sandstone was established.
[0007] (3) Evaluation method of shale gas reservoir compressibility considering the influence of fracture toughness: On the basis of considering fracture toughness, the critical mechanical energy release rate is introduced, the influence of type I and type II fracture toughness on the development of rock cracks is integrated, and the average critical mechanical energy release rate is defined. Combined with the average critical mechanical energy release rate and brittleness index, a shale gas reservoir compressibility evaluation model is established.
[0008] (4) A new method for evaluating the compressibility of shale oil reservoirs based on physical information constraints: By establishing a neural network model constrained by physical information, accurate prediction of rock mechanical parameters is achieved. Based on the influence of rock mechanical parameters on reservoir compressibility, a compressibility evaluation method based on brittleness index and mechanical parameters is established.
[0009] (5) Shale compressibility evaluation method and its application in Jiaoshiba area: The compressibility of Jiaoshiba area was evaluated from three aspects: rock brittleness, geostress characteristics and fracture development degree. The Rickman formula combined with prestack seismic inversion prediction confirmed that the shale brittleness index was high, reflecting that the shale is easy to fracture.
[0010] (6) Research on the evaluation method of the compressibility of shale reservoirs in Weiyuan, Sichuan: By calculating the effective thickness, effective porosity, total organic carbon content, brittleness index and other parameters of the shale reservoirs, and combining them with data such as fracturing construction process parameters and microseismic monitoring results, a comprehensive evaluation of the compressibility of the shale reservoirs of the Longmaxi Formation in Weiyuan, Sichuan was conducted.
[0011] The above-mentioned methods have low adaptability to special geological conditions, cannot reflect the sedimentary cycle sequence of the block stratigraphic structure, and cannot clearly reveal the boundaries of the strata. Summary of the invention
[0012] The purpose of the present invention is to address the above problems in the prior art and to propose a rock chemical compressibility evaluation method based on element logging for judging reservoir compressibility from element logging data.
[0013] The purpose of the present invention can be achieved by the following technical solutions:
[0014] A method for evaluating rock chemical compressibility based on element logging comprises the following steps:
[0015] S1. Preparation of element logging data: Use lithology scanning element logging instrument to measure the logging curve of each element content, and reversely infer the corresponding oxide content of each element from the element content curve;
[0016] S2. Use the oxide content of each element obtained in S1 to substitute into the formula for numerical calculation based on the concept of rock chemical index, including at least one rock chemical index among the calc-alkali index, combination index, alkalinity rate, differentiation index, consolidation index, fels index, magnesia index, Larsen index, oxidation degree and oxidation rate, magnesia ratio, and weathering index. Normalize the calculated rock chemical index curves respectively and perform correlation analysis with the field fracturing test data, where the correlation is greater than 0.8 (R 2 >0.8) is a rock chemical index with a strong correlation with the compressibility index;
[0017] S3. The rock chemical index and fracturing test data with strong correlation with the compressibility index in S2 are used to determine the weights of a series of rock chemical indices with strong correlation using the multiple regression method. The multiple regression analysis used is a statistical method used to study the relationship between multiple independent variables (explanatory variables) and a dependent variable (explained variable). In multiple regression, weights usually refer to regression coefficients, which indicate the degree of influence of independent variables on dependent variables. The following is the calculation process of weights (regression coefficients) in multiple linear regression:
[0018] (1) Model building:
[0019] Determine the form of the model, that is, the dependent variable Y and multiple independent variables X 1 ,X 2 ,...,X k The standard multiple linear regression model can be expressed as:
[0020] Y=β 0 +β 1 X 1 +β 2 X 2 +...+β k X k +ε
[0021] Among them, β 0 is the intercept term, β 1 ,β 2 ,...,β k is the regression coefficient and ε is the error term.
[0022] (2) Collect data:
[0023] The data set is organized, including the data of the dependent variable and all independent variables. Here, the dependent variable is the fracturing test data, and the independent variable is the rock chemical index.
[0024] (3) Estimated regression coefficients:
[0025] Use the Ordinary Least Squares (OLS) method to estimate the regression coefficients. The goal of the least squares method is to minimize the sum of squares of the error terms, that is:
[0026]
[0027] Where n is the number of samples, Y i and X ij are the values of the dependent and independent variables for the ith observation, respectively.
[0028] (4) Solve the normal equation:
[0029] By taking the derivative of the above objective function and setting the derivative to zero, we can get a set of normal equations. This set of equations can be expressed as:
[0030] X T Xβ=X T Y
[0031] where X is the design matrix with each row corresponding to an observation and each column corresponding to an independent variable (the first column is 1 to represent the intercept term), Y is the vector of dependent variables, and β is the vector of regression coefficients.
[0032] (5) Calculate the regression coefficient:
[0033] If X T X is invertible, and the regression coefficients can be obtained by solving the linear equations:
[0034] β=(X T X) -1 X T Y
[0035] This step can be achieved by numerical methods, such as Gaussian elimination, or using statistical software packages.
[0036] (6) Model verification:
[0037] After obtaining the regression coefficients, statistical tests of the model are required, including coefficient significance tests, model goodness-of-fit tests, etc., to evaluate the effectiveness of the model and the reliability of the coefficients.
[0038] (7) Model application:
[0039] Once a model is validated, it can be used to make predictions or further analysis.
[0040] This process can be completed directly through the module functions of statistical software (such as R, Python's statsmodels or scikit-learn library, SPSS, EXCEL, etc.).
[0041] The rock chemical index is multiplied and superimposed with the weight coefficient obtained by the above multivariate regression to construct a compressibility index model based on the rock chemical index of element logging:
[0042]
[0043] In the above formula, FI represents the compressibility index of rock chemical index based on element logging, dimensionless; S i (i=1,2,3,...,n) is a rock chemical index with strong correlation, dimensionless; W i (i=1,2,3,...,n) is the weight coefficient of each rock chemical index obtained by the hierarchical analysis method, which is dimensionless; n is the number of rock chemical indices.
[0044] Preferably, the specific reverse deduction process of obtaining the oxide content from the element content curve in step S1 includes the following steps:
[0045] (1) Determine the chemical formula of the oxide: Based on the element type measured by element logging, assume that the chemical formula of the oxide formed by the element is EO x , where E is the element, O is the oxygen element, and x is the number of oxygen atoms;
[0046] (2) Calculate the relative molecular mass of the oxide: EO x The relative molecular mass The relative atomic mass of E plus the relative atomic mass of x oxygen atoms;
[0047] (3) Calculate the molar ratio of elements in oxides: Since each EO x The molecule contains 1 E atom and x oxygen atoms, so the E atom and EO x The molar ratio is 1 / (1+x);
[0048] (4) Mass percentage of known elements: Let the mass percentage of element E be w E ;
[0049] (5) Calculate the total mass of the oxide: Assume the total mass of the sample is M total , then the mass m of element E is E w E ×M total ;
[0050] (6) Calculate the mass of the oxide based on the mass of the element: xThe molar ratio of EO x Quality
[0051] (7) Calculate the mass percentage of oxides:
[0052] Based on the above steps, the mass percentage of the oxide can be obtained by reverse calculation according to the known mass percentage of the element.
[0053] Preferably, in step S2, the rock chemical index calculation steps are as follows:
[0054] (1) Calcium-base index (CA)
[0055] (Na 2 O+K 2 O) for SiO 2 The curve of CaO to SiO 2 The curves should intersect or the curves should be extended to intersect, and the foot of the intersection point is the corresponding SiO 2 The numerical value is called the calc-alkaline index, or Peacock index, and is represented by the symbol CA. There is only one CA for a rock combination;
[0056] (2) Combination index (σ)
[0057] σ=(Na 2 O+K 2 O) 2 / (SiO 2 -43)(wherein oxides are in mass percentage)
[0058] Among them, Na 2 O.K 2 O、SiO 2 Respectively represent the content of sodium oxide, potassium oxide, and silicon dioxide;
[0059] (3) Alkalinity rate (AR)
[0060]
[0061] If the SiO 2 >50%, K 2 O / Na 2 When O is greater than 1 but less than 2.5, (Na 2 O+K 2 O) with 2Na 2 O instead, without considering K 2 O content; in SiO 2 Under the same conditions, the larger the AR value, the greater the alkalinity of the rock or rock series;
[0062] Among them, Al2 O 3 , CaO, Na 2 O.K 2 O represents the content of aluminum oxide, calcium oxide, sodium oxide, and potassium oxide respectively;
[0063] (4) Differentiation Index (DI)
[0064] According to the theory of magmatic differentiation, silicate magma differentiation tends to enrich SiO 2 -NaAlSi 3 O 8 -KAlSi 3 O 8 Evolution of residual magma direction; residual SiO 2 -NaAlSi 3 O 8 -KAlSi 3 O 8 The system includes six standard minerals: quartz (q), orthoclase (or), albite (ab), nepheline (ne), leucite (lc) and hexagonal potassium nepheline (kp);
[0065] DI=q+or+ab+ne+lc+kp
[0066] Among them, q, or, ab, ne, lc, and kp represent the contents of quartz, orthoclase, albite, nepheline, leucite, and hexagonal nepheline, respectively;
[0067] (5) Consolidation index (SI)
[0068] When crystallization differentiation occurs, the SI value of the residual magma decreases rapidly; from basic rock to acidic rock, the consolidation index changes from large to small; if the degree of magma differentiation is high, the SI value becomes small, and the acidity of the rock is high; if the degree of differentiation is poor, the SI value becomes large, and the basicity of the rock is high. Therefore, SI is an important rock chemical parameter that reflects the degree of differentiation and the basicity of the rock; the specific calculation formula is as follows:
[0069]
[0070] Among them, MgO, FeO, Fe 2 O 3 、Na 2 O.K 2 O represents the content of magnesium oxide, ferrous oxide, ferric oxide, sodium oxide, and potassium oxide respectively;
[0071] (6) Long-England Index (FL)
[0072] The higher the degree of magma fractionation and crystallization, the larger the "Fels Index" is; FL is a rock chemical parameter that reflects the degree of magma fractionation and crystallization;
[0073]
[0074] Among them, Na 2 O.K 2 O and CaO represent the contents of sodium oxide, potassium oxide, and calcium oxide, respectively;
[0075] (7) Magnesium-iron index (MF)
[0076] The higher the degree of magma separation and crystallization, the greater the "magnesia index". MF is a rock chemical parameter that reflects the degree of magma separation and crystallization.
[0077]
[0078] Among them, FeO, Fe 2 O 3 , MgO represent the contents of ferrous oxide, ferric oxide, and magnesium oxide respectively;
[0079] (8) Larsen Index (LI)
[0080] The larger the LI, the greater the rock acidity, indicating that SiO 2 and K 2 O content is high, FeO * The content is low, and the specific calculation formula of LI is as follows:
[0081] LI=[(SiO 2 / 3)+K 2 O]-(CaO+MgO+FeO * )(w B % )
[0082] Among them, FeO * =FeO+0.9Fe 2 O 3 +MnO, of which SiO 2 , K 2 O, CaO, MgO, FeO, Fe 2 O 3 Respectively represent the contents of silicon dioxide, potassium oxide, calcium oxide, magnesium oxide, ferrous oxide, and ferric oxide;
[0083] (9) Oxidation degree (OX°) and oxidation rate (OX)
[0084] OX°=Fe 3+ / (Fe 3+ +Fe 2+ +Mn)(atomic number)
[0085] OX=FeO / (FeO+Fe 2 O3 )
[0086] Among them, Fe 3+ , Fe 2+ 、Mn、FeO、Fe 2 O 3 They represent the contents of ferric iron, ferrous iron, manganese, ferrous oxide, and ferric oxide respectively;
[0087] (10) Magnesium-iron ratio (M / F)
[0088]
[0089] Among them, MgO, FeO, Fe 2 O 3 , MnO, and NiO represent the contents of magnesium oxide, ferrous oxide, ferric oxide, manganese oxide, and nickel oxide, respectively;
[0090] (11) Weathering Index (WI)
[0091] The weathering process is essentially a process of desiliconization and aluminum-iron enrichment. The more silicon is reduced and the more Fe 2 O 3 、Al 2 O 3 The more enriched, the more thorough the weathering is and the higher the degree of weathering is; conversely, the lower the degree of weathering is.
[0092]
[0093] Among them, (X) a represents the atomic % of element X divided by its atomic weight; the denominator in the function is the strength of the bond between each element and oxygen;
[0094] The oxide content inferred based on element logging data is substituted into the above 11 rock chemical index definition formulas to calculate the rock chemical index curve.
[0095] Preferably, in step S2, the contents of normalization of each rock chemical index curve are as follows:
[0096] The range transformation method is used; the parameters in the range transformation are divided into two types: positive index and reverse index. The larger the index value of the positive index, the better, and the smaller the index value of the reverse index, the better;
[0097] For positive indicators, the normalized value of the rock chemical index S i The calculation formula is:
[0098]
[0099] For the reverse index, the normalized value S of the rock chemical index iThe calculation formula is:
[0100]
[0101] In the formula, S i is the normalized value of the parameter, X i is the original value before parameter normalization, max X i is the maximum value of the rock chemical index curve, min X i It is the minimum value of the rock chemical index curve.
[0102] Preferably, in step S2, after normalizing each rock chemical index curve, correlation analysis is performed with the field fracturing test data. The correlation analysis mainly evaluates the linear relationship between variables, that is, whether they are related in a straight line form, and uses the correlation coefficient to quantify the strength of the linear relationship between the variables. The specific steps are as follows:
[0103] (1) Collect normalized rock chemical index data and field fracturing test data to ensure the accuracy and completeness of the data;
[0104] (2) Preprocessing the two sets of data for correlation analysis, including processing missing values, outliers and erroneous data; the above-mentioned processing of missing values, outliers and erroneous data, that is, processing unreasonable rock chemical index data and field fracturing test data and meaningless values, belongs to the existing technical means, so it will not be analyzed in detail here.
[0105] (3) Use the scatter plot visualization tool in EXCEL to display the relationship between the two sets of data, select the linear correlation analysis method, intuitively evaluate the correlation between them and calculate the correlation coefficient;
[0106] Preferably, in step S3, a multivariate regression method is used to determine the weights of a series of rock chemical indices with strong correlation, and the specific steps are as follows:
[0107] It can be directly realized through the multiple regression option in the data analysis module in EXCEL. The specific steps for multiple regression analysis using the data analysis toolkit in Excel are as follows:
[0108] Step 1: Prepare the data
[0109] Ensure that the data is properly organized in the Excel worksheet, including a column of dependent variables, i.e., field fracturing test data, and multiple columns of independent variables, i.e., rock chemical indices;
[0110] Step 2: Enable the data analysis toolkit;
[0111] Step 3: Open the data analysis dialog box;
[0112] Step 4: Select multiple regression;
[0113] Step 5: Set regression parameters;
[0114] 1. Input Y area: Select the column where the field fracturing test is located;
[0115] 2. Input X area: Select the column where the rock chemical index is located;
[0116] 3. Output area: Select a cell to start outputting the results of the regression analysis; Excel will display at least the regression statistics, regression coefficient, R 2 value;
[0117] Step 6: Review and analyze the results;
[0118] After clicking "OK", Excel will generate the results of the regression analysis in the specified output area, including:
[0119] Regression statistics: at least the number of observations, R 2 Value, adjusted R 2 value;
[0120] Regression coefficients: coefficient, standard error, t-statistic, and P-value for each independent variable;
[0121] Coefficient: represents the expected change in the dependent variable for each unit change in the independent variable;
[0122] Through steps 1 to 6, multiple regression analysis was performed using Excel to determine the rock chemical index weight coefficient.
[0123] Compared with the prior art, the present invention has the following beneficial effects:
[0124] 1. The present invention proposes to use the rock chemical index of element logging as evaluation data, and finally obtain the compressibility index after a series of calculations. This not only overcomes the limitations of existing similar technologies that rely on indoor mechanics-related experimental data, but also makes full use of element logging data to evaluate compressibility from a new perspective, providing a theoretical basis for reservoir fracturing programs.
[0125] 2. Improve the accuracy of assessment: By using element logging data to directly calculate the chemical index of rocks, this method can more accurately reflect the chemical composition and corresponding physical properties of rocks. Compared with traditional physical logging methods, the detailed analysis of chemical composition provides a deeper understanding of rock properties and helps to more accurately assess the compressibility of rocks.
[0126] 3. Optimize fracturing design: By analyzing the correlation between rock chemical index and fracturing test data, it is possible to identify which chemical indexes are closely related to the compressibility of rocks. Such analysis makes fracturing design more targeted, thereby optimizing resource extraction and increasing oil and gas production.
[0127] 4. Data-driven decision support: The compressibility index model is constructed by combining the rock chemical index and actual fracturing data using the multivariate regression method, providing a powerful data-driven tool. This method adjusts and optimizes the model based on actual data, ensuring the practicality and effectiveness of the decision support system.
[0128] 5. Improve operational efficiency and cost-effectiveness: Accurate fracturing assessment can guide more effective fracturing operations and reduce ineffective or inefficient fracturing attempts, thereby saving costs and reducing environmental impact. Through scientific prediction and evaluation, operational plans can be more reasonable and avoid excessive use of resources and time.
[0129] 6. Wide applicability: This method is not limited to a specific type of rock or geological structure. Its analysis method based on rock chemical composition is applicable to a variety of lithologies and geological environments, enhancing its applicability in different oil fields around the world.
[0130] In summary, this invention, by combining modern element logging technology with advanced data analysis technology, can provide a more scientific, accurate and cost-effective evaluation method for rock fracturing in oil and gas development. This has important practical and economic significance for improving the efficiency of oil and gas development and reducing development risks and costs. BRIEF DESCRIPTION OF THE DRAWINGS
[0131] Figure 1 It is a graph of the Chang Ying index and the fracturing test data in the present invention.
[0132] Figure 2 It is a graph of magnesium-iron index and fracturing test data in the present invention.
[0133] Figure 3 It is a curve diagram of the combination index and the fracturing test data in the present invention.
[0134] Figure 4 It is a curve diagram of consolidation index and fracturing test data in the present invention.
[0135] Figure 5 It is a curve diagram of weathering index and fracturing test data in the present invention.
[0136] Figure 6 It is a curve diagram of Larsen index and fracturing test data in the present invention.
[0137] Figure 7 It is a curve diagram of alkalinity rate and fracturing test data in the present invention.
[0138] Figure 8 It is a curve diagram of magnesium-iron ratio and fracturing test data in the present invention.
[0139] Fig. 9It is a curve diagram of oxidation degree and fracturing test data in the present invention.
[0140] Fig.10 It is a curve diagram of oxidation rate and fracturing test data in the present invention.
[0141] Fig.11 It is a curve diagram of the calcium-alkali index and the fracturing test data in the present invention.
[0142] Fig.12 It is a curve diagram of differentiation index and fracturing test data in the present invention.
[0143] Fig.13 It is a diagram of the actual application processing results of the present invention.
[0144] Fig.14 The present invention (Na 2 O+K 2 O) for SiO 2 The curve of CaO to SiO 2 Graph of the curve. DETAILED DESCRIPTION
[0145] The following are specific embodiments of the present invention and the accompanying drawings to further describe the technical solution of the present invention, but the present invention is not limited to these embodiments.
[0146] Embodiment 1
[0147] A rock chemical compressibility evaluation method based on element logging, characterized in that the compressibility evaluation method comprises the following steps:
[0148] S1. Preparation of element logging data: Use lithology scanning element logging instrument to measure the logging curve of each element content, and reversely infer the corresponding oxide content of each element from the element content curve;
[0149] The lithology scanning element logging instrument here can specifically adopt LithoScanner, ECS and other equipment.
[0150] The specific reverse deduction process of obtaining the oxide content from the element content curve in step S1 includes the following steps:
[0151] (1) Determine the chemical formula of the oxide: Based on the element type measured by element logging, assume that the chemical formula of the oxide formed by the element is EO x , where E is the element, O is the oxygen element, and x is the number of oxygen atoms;
[0152] (2) Calculate the relative molecular mass of the oxide: EO x The relative molecular mass The relative atomic mass of E plus the relative atomic mass of x oxygen atoms; for example, the relative atomic mass of oxygen is about 16 g / mol.
[0153] (3) Calculate the molar ratio of elements in oxides: Since each EO x The molecule contains 1 E atom and x oxygen atoms, so the E atom and EO x The molar ratio is 1 / (1+x);
[0154] (4) Mass percentage of known elements: Let the mass percentage of element E be w E ;
[0155] (5) Calculate the total mass of the oxide: Assume the total mass of the sample is M total , then the mass m of element E is E w E ×M total ;
[0156] (6) Calculate the mass of the oxide based on the mass of the element: x The molar ratio of EO x Quality
[0157] (7) Calculate the mass percentage of oxides:
[0158] Based on the above steps, the mass percentage of the oxide can be obtained by reverse calculation according to the known mass percentage of the element.
[0159] The conventional calculation method is to inversely calculate the mass percentage of an element to obtain the mass percentage of its oxide, so it will not be described in detail here.
[0160] S2. Use the oxide content of each element obtained in S1 to substitute into the formula for numerical calculation based on the concept of rock chemical index, including at least one rock chemical index among the calc-alkali index, combination index, alkalinity rate, differentiation index, consolidation index, fels index, magnesia index, Larsen index, oxidation degree and oxidation rate, magnesia ratio, and weathering index. Normalize the calculated rock chemical index curves respectively and perform correlation analysis with the field fracturing test data, where the correlation is greater than 0.8 (R 2 >0.8) is a rock chemical index with a strong correlation with the compressibility index;
[0161] In step S2, the rock chemical index calculation steps are as follows:
[0162] (1) Calcium-base index (CA)
[0163] (Na 2 O+K 2O) for SiO 2 The curve of CaO to SiO 2 The curve in Fig.14 The curves should intersect or extend to intersect, and the foot of the intersection point should be the SiO 2 The numerical value is called the calc-alkaline index, or Peacock index, and is represented by the symbol CA. There is only one CA for a rock combination;
[0164] (2) Combination index (σ)
[0165] σ=(Na 2 O+K 2 O) 2 / (SiO 2 -43)(wherein oxides are in mass percentage)
[0166] Among them, Na 2 O.K 2 O、SiO 2 Respectively represent the content of sodium oxide, potassium oxide, and silicon dioxide;
[0167] (3) Alkalinity rate (AR)
[0168]
[0169] If the SiO 2 >50%, K 2 O / Na 2 When O is greater than 1 but less than 2.5, (Na 2 O+K 2 O) with 2Na 2 O instead, without considering K 2 O content; in SiO 2 Under the same conditions, the larger the AR value, the greater the alkalinity of the rock or rock series;
[0170] Among them, Al 2 O 3 , CaO, Na 2 O.K 2 O represents the content of aluminum oxide, calcium oxide, sodium oxide, and potassium oxide respectively;
[0171] (4) Differentiation Index (DI)
[0172] According to the theory of magmatic differentiation, silicate magma differentiation tends to enrich SiO 2 -NaAlSi 3 O 8 -KAlSi 3 O 8 The residual magma evolves in the direction of the rock. Bowen pointed out that the residual SiO 2-NaAlSi 3 O 8 -KAlSi 3 O 8 The system includes six standard minerals: quartz (q), orthoclase (or), albite (ab), nepheline (ne), leucite (lc) and hexagonal potassium nepheline (kp); CP Thornton and OF Tuttle (1960) called the sum of the mass percentages of the above six standard minerals the differentiation index (DI).
[0173] DI=q+or+ab+ne+lc+kp
[0174] Among them, q, or, ab, ne, lc, and kp represent the contents of quartz, orthoclase, albite, nepheline, leucite, and hexagonal potassium nepheline respectively; because these six standard minerals will not appear at the same time, if q is present, ne, lc, and kp will not appear; if kp is present, or, ab, etc. will not appear. Therefore, DI is actually only the sum of two or three of these six minerals.
[0175] (5) Consolidation index (SI)
[0176] When crystallization differentiation occurs, the SI value of the residual magma decreases rapidly; from basic rock to acidic rock, the consolidation index changes from large to small; if the degree of magma differentiation is high, the SI value becomes small, and the acidity of the rock is high; if the degree of differentiation is poor, the SI value becomes large, and the basicity of the rock is high. Therefore, SI is an important rock chemical parameter that reflects the degree of differentiation and the basicity of the rock; the specific calculation formula is as follows:
[0177]
[0178] Among them, MgO, FeO, Fe 2 O 3 、Na 2 O.K 2 O represents the content of magnesium oxide, ferrous oxide, ferric oxide, sodium oxide, and potassium oxide respectively;
[0179] (6) Long-England Index (FL)
[0180] The higher the degree of magma fractionation and crystallization, the larger the "Fels Index" is; FL is a rock chemical parameter that reflects the degree of magma fractionation and crystallization;
[0181]
[0182] Among them, Na 2 O.K 2 O and CaO represent the contents of sodium oxide, potassium oxide, and calcium oxide, respectively;
[0183] (7) Magnesium-iron index (MF)
[0184] The higher the degree of magma separation and crystallization, the greater the "magnesia index". MF is a rock chemical parameter that reflects the degree of magma separation and crystallization.
[0185]
[0186] Among them, FeO, Fe 2 O 3 , MgO represent the contents of ferrous oxide, ferric oxide, and magnesium oxide respectively;
[0187] (8) Larsen Index (LI)
[0188] The Larsen Index is a method of expressing rock acidity. It can be positive or negative. The larger the LI, the greater the rock acidity, indicating that SiO 2 and K 2 O content is high, FeO * The content is low, and the specific calculation formula of LI is as follows:
[0189] LI=[(SiO 2 / 3)+K 2 O]-(CaO+MgO+FeO * )(w B % )
[0190] Among them, FeO * =FeO+0.9Fe 2 O 3 +MnO, of which SiO 2 , K 2 O, CaO, MgO, FeO, Fe 2 O 3 Respectively represent the contents of silicon dioxide, potassium oxide, calcium oxide, magnesium oxide, ferrous oxide, and ferric oxide;
[0191] (9) Oxidation degree (OX°) and oxidation rate (OX)
[0192] OX°=Fe 3+ / (Fe 3+ +Fe 2+ +Mn) (number of atoms)
[0193] OX=FeO / (FeO+Fe 2 O 3 )
[0194] Among them, Fe 3+ , Fe 2+ 、Mn、FeO、Fe 2 O 3 They represent the contents of ferric iron, ferrous iron, manganese, ferrous oxide, and ferric oxide respectively;
[0195] (10) Magnesium-iron ratio (M / F)
[0196]
[0197] Among them, MgO, FeO, Fe 2 O 3 , MnO, and NiO represent the contents of magnesium oxide, ferrous oxide, ferric oxide, manganese oxide, and nickel oxide, respectively;
[0198] (11) Weathering Index (WI)
[0199] The weathering process is essentially a process of desiliconization and aluminum-iron enrichment. The more silicon is reduced and the more Fe 2 O 3 、Al 2 O 3 The more enriched, the more thorough the weathering is and the higher the degree of weathering is; conversely, the lower the degree of weathering is.
[0200]
[0201] Among them, (X) a represents the atomic % of element X divided by its atomic weight; the denominator in the function is the strength of the bond between each element and oxygen;
[0202] The oxide content inferred based on element logging data is substituted into the above 11 rock chemical index definition formulas to calculate the rock chemical index curve.
[0203] In step S2, the contents of normalization of each rock chemical index curve are as follows:
[0204] The range transformation method is used; the parameters in the range transformation are divided into two types: positive index and reverse index. The larger the index value of the positive index, the better, and the smaller the index value of the reverse index, the better;
[0205] For positive indicators, the normalized value of the rock chemical index S i The calculation formula is:
[0206]
[0207] For the reverse index, the normalized value S of the rock chemical index i The calculation formula is:
[0208]
[0209] In the formula, S i is the normalized value of the parameter, X i is the original value before parameter normalization, max X iis the maximum value of the rock chemical index curve, min X i It is the minimum value of the rock chemical index curve.
[0210] In step S2, after normalizing each rock chemical index curve, correlation analysis is performed with the field fracturing test data. The correlation analysis mainly evaluates the linear relationship between variables, that is, whether they are related in a straight line form, and uses the correlation coefficient to quantify the strength of the linear relationship between variables. The specific steps are as follows:
[0211] The rock chemical indices include: calc-alkaline index, combination index, alkalinity rate, differentiation index, consolidation index, fels index, magnesia-iron index, Larsen index, oxidation degree and oxidation rate, magnesia-iron ratio, and weathering index.
[0212] (1) Collect normalized rock chemical index data and field fracturing test data to ensure the accuracy and completeness of the data;
[0213] (2) Preprocessing the two sets of data for correlation analysis, including processing missing values, outliers and erroneous data; the above three preprocessing methods are existing data processing methods and belong to the prior art.
[0214] (3) Use the scatter plot visualization tool in EXCEL to display the relationship between the two sets of data, select the linear correlation analysis method, intuitively evaluate the correlation between them and calculate the correlation coefficient;
[0215] In Excel, the correlation coefficient R 2 (coefficient of determination) is often used to measure the goodness of fit of a regression model. Calculate R 2 The steps are as follows:
[0216] ① Calculate the total sum of squares (SST):
[0217] This is a measure of the total deviation of the data points from the mean of the data. It is calculated as:
[0218]
[0219] Among them, Y i is the ith observation, The average of all observations.
[0220] ② Calculate the regression sum of squares (SSR):
[0221] This is a measure of the sum of deviations of the values predicted by the regression line from the mean of the data. It is calculated as:
[0222]
[0223] in, is the ith value predicted by the regression equation.
[0224] ③Calculate the residual sum of squares (SSE):
[0225] This is a measure of the total deviation of the actual observed values from the values predicted by the regression line. It is calculated as:
[0226]
[0227] in, is the ith value predicted by the regression equation.
[0228] ④ Calculate R 2 value:
[0229] R 2 The value can be calculated by the following formula:
[0230] Or, equivalently:
[0231] This formula shows that R 2 is the proportion of the variation explained by the regression model to the total variation.
[0232] Calculating R in Excel 2 There are two ways:
[0233] 1. Use the data analysis toolkit:
[0234] ① Make sure the Data Analysis Toolkit is enabled. You can manage add-ins in "File" → "Options" → "Add-ins".
[0235] ②Go to the "Data" tab and click the "Data Analysis" button.
[0236] ③Select “Regression” analysis and click “OK”.
[0237] ④Set the input Y area (dependent variable) and input X area (independent variable).
[0238] ⑤Select an output area or a new worksheet to display the results.
[0239] ⑥ Click "OK" and Excel will output the data including R 2 The regression analysis results including the values.
[0240] 2. Use the formula:
[0241] If you do not use a data analysis tool, you can also calculate R manually. 2First, calculate SST, SSR, and SSE, then use the above formula to calculate R 2 (4) Use EXCEL to calculate the correlation coefficient, evaluate the significance of the correlation coefficient, and interpret the correlation between rock chemical index and fracturing test data based on the value of the correlation coefficient and the significance result. 2 The value ranges from 0 to 1. The closer the value is to 1, the stronger the explanatory power of the model is, that is, the model can better predict the changes in the dependent variable, the compressibility index.
[0242] (4) Use EXCEL to calculate the correlation coefficient, evaluate the significance of the correlation coefficient, and interpret the correlation between the rock chemical index and the fracturing test data based on the value of the correlation coefficient and the significance result. 2 The value ranges from 0 to 1. The closer the value is to 1, the stronger the explanatory power of the model is, that is, the model can better predict the changes in the dependent variable, the compressibility index.
[0243] S3. The rock chemical index and fracturing test data with strong correlation with the compressibility index in S2 are used to determine the weights of a series of rock chemical indices with strong correlation by multiple regression method. The rock chemical index is multiplied and superimposed with the weight coefficient obtained by multiple regression to construct a compressibility index model of rock chemical index based on element logging:
[0244]
[0245] In the above formula, FI represents the compressibility index of rock chemical index based on element logging, dimensionless; S i (i=1,2,3,...,n) is a rock chemical index with strong correlation, dimensionless; W i (i=1,2,3,...,n) is the weight coefficient of each rock chemical index obtained by the hierarchical analysis method, which is dimensionless; n is the number of rock chemical indices.
[0246] In step S3, the weights of a series of rock chemical indices with strong correlation are determined by using the multivariate regression method. The specific steps are as follows:
[0247] This step can be directly implemented through the multiple regression option in the data analysis module in EXCEL. The specific steps for using the data analysis toolkit to perform multiple regression analysis in Excel are as follows:
[0248] Step 1: Prepare the data
[0249] Make sure your data is organized correctly in an Excel worksheet, including a column for the dependent variable (the field fracturing test data in this study) and multiple columns for the independent variables (the rock chemical indices in this study).
[0250] Step 2: Enable Data Analysis Toolkit
[0251] 1. Click the "File" menu.
[0252] 2. Select "Options".
[0253] 3. In the Excel Options window, select Add-ins.
[0254] 4. Select "Excel Add-ins" in the management box at the bottom, and then click "Go".
[0255] 5. Check "Analysis ToolPak" and "Analysis ToolPak-VBA", and then click "OK".
[0256] Step 3: Open the Data Analysis dialog box
[0257] 1. Click the "Data" tab.
[0258] 2. In the "Analysis" group, click the "Data Analysis" button.
[0259] Step 4: Select Multiple Regression
[0260] 1. In the Data Analysis dialog box, select Regression from the list, and then click OK.
[0261] Step 5: Set regression parameters
[0262] 1. Input Y Area: Select the column where the field fracturing tests are located.
[0263] 2. Input X area: Select the column where the rock chemical index is located.
[0264] 3. Output area: Select a cell to start outputting the results of the regression analysis. Excel will display the regression statistics, regression coefficients, R 2 Value, etc.
[0265] Step 6: Review and analyze the results
[0266] After clicking "OK", Excel will generate the results of the regression analysis in the specified output area. This includes:
[0267] -Regression statistics: including number of observations, R 2 Value, adjusted R 2 Value, etc.
[0268] - Regression coefficients: coefficient, standard error, t-statistic, and P-value for each independent variable.
[0269] -Coefficient: It indicates the expected change in the dependent variable for each unit change in the independent variable.
[0270] Through the above steps, multiple regression analysis was performed using Excel to determine the rock chemical index weight coefficient.
[0271] Embodiment 2
[0272] The above rock chemical index compressibility evaluation method based on element logging is applied to guide the on-site well compressibility evaluation. The correlation between the rock chemical index and the fracturing test data is obtained based on the analysis, that is, the R in the fitting equation of the two sets of discrete points. 2 Size, processing analysis diagram as follows Figures 1 to 12 shown.
[0273] Based on the correlation analysis results of the above application wells, the following 8 rock chemical indices with correlation coefficients greater than 0.8 were extracted, and the following compressibility coefficient model of rock chemical indices based on element logging was constructed:
[0274]
[0275] In the above formula,
[0276] FI stands for Rock Chemical Index Compressibility Index,
[0277] LI represents the normalized Larsen index, corresponding to the weight a,
[0278] MF represents the normalized magnesium-iron index, corresponding to the weight b,
[0279] represents the normalized magnesium-iron ratio, corresponding to the weight c,
[0280] AR represents the normalized alkalinity rate, corresponding to the weight d,
[0281] ZHZS represents the normalized combined index, corresponding to the weight e,
[0282] FL represents the normalized Long-English Index, corresponding to the weight f,
[0283] SI represents the normalized consolidation index, corresponding to the weight g,
[0284] WI represents the normalized weathering index, corresponding to the weight h.
[0285]
[0286] The final compressibility evaluation effect is as follows: Fig.13As shown in the figure, the upper lamina type of the block is sand-mud interlayer, and the lower interlayer type is sandstone. The compressibility index gradually increases with depth, and there is a relatively obvious stratigraphic interface in the middle. The rock chemical index evaluation results based on element logging are more accurate than conventional rock mechanics evaluation results and closer to the field fracturing test data. The rock chemical index compressibility curve contains rich stratigraphic information, which sensitively and continuously reflects the stratification and cyclic characteristics of the measured strata, and clearly reveals the sedimentary cyclicity of the three-layer strata in the block.
[0287] The rock chemical compressibility evaluation method based on element logging can effectively guide the oilfield compressibility evaluation and fracturing scheme design. In practical applications, it is necessary to comprehensively consider factors such as the chemical composition, structural characteristics and external environment of the rock to select an appropriate compressibility evaluation method, which is of great significance for accurately evaluating the mechanical behavior and failure characteristics of the rock.
[0288] The specific embodiments described herein are merely examples of the spirit of the present invention. Those skilled in the art may make various modifications or additions to the specific embodiments described or replace them in similar ways, but they will not deviate from the spirit of the present invention or exceed the scope defined by the appended claims.
[0289] In the description of the present invention, it should be noted that, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.
Claims
1. A method for evaluating rock chemical compressibility based on element logging, characterized in that: The compressibility evaluation method comprises the following steps: S1. Preparation of element logging data: Use lithology scanning element logging instrument to measure the logging curve of each element content, and reversely infer the corresponding oxide content of each element from the element content curve; S2. Use the oxide content of each element obtained in S1 to substitute into the formula for numerical calculation based on the concept of rock chemical index, including at least one rock chemical index among calc-alkali index, combination index, alkalinity rate, differentiation index, consolidation index, fels index, magnesia index, Larsen index, oxidation degree and oxidation rate, magnesia ratio, and weathering index. Normalize the calculated rock chemical index curves respectively and perform correlation analysis with the field fracturing test data, where the correlation is greater than 0.8 (R 2 >0.8) is a rock chemical index with a strong correlation with the compressibility index; S3. The rock chemical index and fracturing test data with strong correlation with the compressibility index in S2 are used to determine the weights of a series of rock chemical indices with strong correlation by multiple regression method. The rock chemical index is multiplied and superimposed with the weight coefficient obtained by multiple regression to construct a compressibility index model of rock chemical index based on element logging: In the above formula, FI represents the compressibility index of rock chemical index based on element logging, dimensionless; S i (i=1,2,3,...,n) is a rock chemical index with strong correlation, dimensionless; W i (i=1,2,3,...,n) is the weight coefficient of each rock chemical index obtained by the hierarchical analysis method, which is dimensionless; n is the number of rock chemical indices.
2. The method for evaluating rock chemical compressibility based on element logging according to claim 1, characterized in that: The specific reverse deduction process of obtaining the oxide content from the element content curve in step S1 includes the following steps: (1) Determine the chemical formula of the oxide: Based on the element type measured by element logging, assume that the chemical formula of the oxide formed by the element is EO x , where E is the element, O is the oxygen element, and x is the number of oxygen atoms; (2) Calculate the relative molecular mass of the oxide: EO x The relative molecular mass The relative atomic mass of E plus the relative atomic mass of x oxygen atoms; (3) Calculate the molar ratio of elements in oxides: Since each EO x The molecule contains 1 E atom and x oxygen atoms, so the E atom and EO x The molar ratio is 1 / (1+x); (4) Mass percentage of known elements: Let the mass percentage of element E be w E ; (5) Calculate the total mass of the oxide: Assume the total mass of the sample is M total , then the mass m of element E is E w E ×M total ; (6) Calculate the mass of the oxide based on the mass of the element: x The molar ratio of EO x Quality (7) Calculate the mass percentage of oxides: Based on the above steps, the mass percentage of the oxide can be obtained by reverse calculation according to the known mass percentage of the element.
3. The method for evaluating rock chemical compressibility based on element logging according to claim 1 or 2, characterized in that: In step S2, the rock chemical index calculation steps are as follows: (1) Calcium-base index (CA) The curve of (Na2O+K2O) versus SiO2 and the curve of CaO versus SiO2 should intersect or intersect when the curves are extended. The SiO2 value corresponding to the foot of the intersection on the horizontal axis is called the calc-alkaline index, or the Peacock index, represented by the symbol CA. There is only one CA for a rock combination. (2) Combination index (σ) σ=(Na2O+K2O) 2 / (SiO2-43)(wherein oxide is mass percentage) Among them, Na2O, K2O, and SiO2 represent the contents of sodium oxide, potassium oxide, and silicon dioxide, respectively; (3) Alkalinity rate (AR) If the SiO2 of the rock is greater than 50%, and K2O / Na2O is greater than 1 but less than 2.5, (Na2O+K2O) in the formula is replaced by 2Na2O, regardless of the K2O content; under the same SiO2 conditions, the greater the AR value, the greater the alkalinity of the rock or rock series; Among them, Al2O3, CaO, Na2O, and K2O represent the contents of aluminum oxide, calcium oxide, sodium oxide, and potassium oxide, respectively; (4) Differentiation Index (DI) According to the theory of magmatic differentiation, silicate magma differentiation evolves towards the direction of enriched SiO2-NaAlSi3O8-KAlSi3O8 residual magma; the residual SiO2-NaAlSi3O8-KAlSi3O8 system includes six standard minerals: quartz (q), orthoclase (or), albite (ab), nepheline (ne), leucite (lc) and hexagonal potassium nepheline (kp); DI=q+or+ab+ne+lc+kp Among them, q, or, ab, ne, lc, and kp represent the contents of quartz, orthoclase, albite, nepheline, leucite, and hexagonal nepheline, respectively; (5) Consolidation index (SI) When crystallization differentiation occurs, the SI value of the residual magma decreases rapidly; from basic rock to acidic rock, the consolidation index changes from large to small; if the degree of magma differentiation is high, the SI value becomes small, and the acidity of the rock is high; if the degree of differentiation is poor, the SI value becomes large, and the basicity of the rock is high. Therefore, SI is an important rock chemical parameter that reflects the degree of differentiation and the basicity of the rock; the specific calculation formula is as follows: Among them, MgO, FeO, Fe2O3, Na2O, and K2O represent the contents of magnesium oxide, ferrous oxide, ferric oxide, sodium oxide, and potassium oxide, respectively; (6) Long-England Index (FL) The higher the degree of magma separation crystallization, the larger the "Fels Index"; FL is a rock chemical parameter that reflects the degree of magma separation crystallization; Among them, Na2O, K2O, and CaO represent the contents of sodium oxide, potassium oxide, and calcium oxide, respectively; (7) Magnesium-iron index (MF) The higher the degree of magma separation and crystallization, the greater the "magnesium-iron index". MF is a rock chemical parameter that reflects the degree of magma separation and crystallization. Among them, FeO, Fe2O3, and MgO represent the contents of ferrous oxide, ferric oxide, and magnesium oxide, respectively; (8) Larsen Index (LI) The larger the LI, the greater the rock acidity, indicating that the SiO2 and K2O contents are high, and FeO * The content is low, and the specific calculation formula of LI is as follows: LI=[(SiO2 / 3)+K2O]-(CaO+MgO+FeO * )(w B %) Among them, FeO * =FeO+0.9Fe2O3+MnO, where SiO2, K2O, CaO, MgO, FeO, and Fe2O3 represent the contents of silicon dioxide, potassium oxide, calcium oxide, magnesium oxide, ferrous oxide, and iron oxide, respectively; (9) Oxidation degree (OX°) and oxidation rate (OX) OX°=Fe 3+ / (Fe 3+ +Fe 2+ +Mn) (number of atoms) OX=FeO / (FeO+Fe2O3) Among them, Fe 3+ , Fe 2+ , Mn, FeO, and Fe2O3 represent the contents of ferric iron, ferrous iron, manganese, ferrous oxide, and ferric oxide, respectively; (10) Magnesium-iron ratio (M / F) Among them, MgO, FeO, Fe2O3, MnO, and NiO represent the contents of magnesium oxide, ferrous oxide, ferric oxide, manganese oxide, and nickel oxide, respectively; (11) Weathering Index (WI) The weathering process is essentially a process of desiliconization and aluminum-iron enrichment. The more silicon is reduced and the more Fe2O3 and Al2O3 are enriched, the more thorough the weathering is and the higher the degree of weathering is. Conversely, the lower the degree of weathering is. Among them, (X) a represents the atomic % of element X divided by its atomic weight; the denominator in the function is the strength of the bond between each element and oxygen; The oxide content inferred based on element logging data is substituted into the above 11 rock chemical index definition formulas to calculate the rock chemical index curve.
4. The method for evaluating rock chemical compressibility based on element logging according to claim 3, characterized in that: In step S2, the contents of normalization of each rock chemical index curve are as follows: The range transformation method is used; the parameters in the range transformation are divided into two types: positive index and reverse index. The larger the index value of the positive index, the better, and the smaller the index value of the reverse index, the better; For positive indicators, the normalized value of the rock chemical index S i The calculation formula is: For the reverse index, the normalized value S of the rock chemical index i The calculation formula is: In the formula, S i is the normalized value of the parameter, X i is the original value before parameter normalization, max X i is the maximum value of the rock chemical index curve, min X i It is the minimum value of the rock chemical index curve.
5. The method for evaluating rock chemical compressibility based on element logging according to claim 4, characterized in that: In step S2, after normalizing each rock chemical index curve, correlation analysis is performed with the field fracturing test data. The correlation analysis mainly evaluates the linear relationship between variables, that is, whether they are related in a straight line form, and uses the correlation coefficient to quantify the strength of the linear relationship between variables. The specific steps are as follows: (1) Collect normalized rock chemical index data and field fracturing test data to ensure the accuracy and completeness of the data; (2) Preprocess the two sets of data for correlation analysis, including processing missing values, outliers, and erroneous data; (3) Use the scatter plot visualization tool in EXCEL to display the relationship between the two sets of data, select the linear correlation analysis method, intuitively evaluate the correlation between them and calculate the correlation coefficient; (4) Use EXCEL to calculate the correlation coefficient, evaluate the significance of the correlation coefficient, and interpret the correlation between the rock chemical index and the fracturing test data based on the value of the correlation coefficient and the significance result.
6. The method for evaluating rock chemical compressibility based on element logging according to claim 5, characterized in that: In step S3, the weights of a series of rock chemical indices with strong correlation are determined by using the multivariate regression method. The specific steps are as follows: It can be directly realized through the multiple regression option in the data analysis module in EXCEL. The specific steps for multiple regression analysis using the data analysis toolkit in Excel are as follows: Step 1: Prepare the data Ensure that the data is properly organized in the Excel worksheet, including a column of dependent variables, i.e., field fracturing test data, and multiple columns of independent variables, i.e., rock chemical indices; Step 2: Enable the data analysis toolkit; Step 3: Open the data analysis dialog box; Step 4: Select multiple regression; Step 5: Set regression parameters; 1. Input Y area: Select the column where the field fracturing test is located; 2. Input X area: Select the column where the rock chemical index is located; 3. Output area: Select a cell to start outputting the results of the regression analysis; Excel will display at least the regression statistics, regression coefficient, R 2 value; Step 6: Review and analyze the results; After clicking "OK", Excel will generate the results of the regression analysis in the specified output area, including: Regression statistics: at least the number of observations, R 2 Value, adjusted R 2 value; Regression coefficients: coefficient, standard error, t statistic, and P value for each independent variable; Coefficient: represents the expected change in the dependent variable for each unit change in the independent variable; Through steps 1 to 6, multiple regression analysis was performed using Excel to determine the rock chemical index weight coefficient.
Citation Information
Patent Citations
Method for determining fracturing index of shale formation
CN105221140A
Deep shale gas horizontal well fracturing differentiation design method based on logging data
CN113090258A
Shale oil fracturing potential prediction method, system, equipment and terminal
CN114548520A
Shale reservoir compressibility evaluation method
CN115749756A
Fractability evaluation method based on broken rock block mass fractal
CN116291330A
Cited By
Deep coal reservoir compressibility evaluation method and system based on physical information constraint
CN120832826A
