[go: up one dir, main page]

CN116243386A - A method and system for constructing acoustic time-difference curves of drilling rock formations - Google Patents

A method and system for constructing acoustic time-difference curves of drilling rock formations Download PDF

Info

Publication number
CN116243386A
CN116243386A CN202211668959.3A CN202211668959A CN116243386A CN 116243386 A CN116243386 A CN 116243386A CN 202211668959 A CN202211668959 A CN 202211668959A CN 116243386 A CN116243386 A CN 116243386A
Authority
CN
China
Prior art keywords
time difference
rock formation
rock
acoustic wave
formation
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202211668959.3A
Other languages
Chinese (zh)
Other versions
CN116243386B (en
Inventor
张晓玉
高大飞
高龙
王辉
李强
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
CNNC 208 BATTALION
Original Assignee
CNNC 208 BATTALION
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by CNNC 208 BATTALION filed Critical CNNC 208 BATTALION
Priority to CN202211668959.3A priority Critical patent/CN116243386B/en
Publication of CN116243386A publication Critical patent/CN116243386A/en
Application granted granted Critical
Publication of CN116243386B publication Critical patent/CN116243386B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • EFIXED CONSTRUCTIONS
    • E21EARTH OR ROCK DRILLING; MINING
    • E21BEARTH OR ROCK DRILLING; OBTAINING OIL, GAS, WATER, SOLUBLE OR MELTABLE MATERIALS OR A SLURRY OF MINERALS FROM WELLS
    • E21B49/00Testing the nature of borehole walls; Formation testing; Methods or apparatus for obtaining samples of soil or well fluids, specially adapted to earth drilling or wells
    • GPHYSICS
    • G01MEASURING; TESTING
    • G01VGEOPHYSICS; GRAVITATIONAL MEASUREMENTS; DETECTING MASSES OR OBJECTS; TAGS
    • G01V1/00Seismology; Seismic or acoustic prospecting or detecting
    • G01V1/40Seismology; Seismic or acoustic prospecting or detecting specially adapted for well-logging
    • G01V1/44Seismology; Seismic or acoustic prospecting or detecting specially adapted for well-logging using generators and receivers in the same well
    • G01V1/48Processing data
    • GPHYSICS
    • G01MEASURING; TESTING
    • G01VGEOPHYSICS; GRAVITATIONAL MEASUREMENTS; DETECTING MASSES OR OBJECTS; TAGS
    • G01V1/00Seismology; Seismic or acoustic prospecting or detecting
    • G01V1/40Seismology; Seismic or acoustic prospecting or detecting specially adapted for well-logging
    • G01V1/44Seismology; Seismic or acoustic prospecting or detecting specially adapted for well-logging using generators and receivers in the same well
    • G01V1/48Processing data
    • G01V1/50Analysing data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/10Complex mathematical operations
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02ATECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
    • Y02A90/00Technologies having an indirect contribution to adaptation to climate change
    • Y02A90/30Assessment of water resources

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • General Physics & Mathematics (AREA)
  • Geology (AREA)
  • General Life Sciences & Earth Sciences (AREA)
  • Environmental & Geological Engineering (AREA)
  • Mining & Mineral Resources (AREA)
  • Mathematical Physics (AREA)
  • Geophysics (AREA)
  • Remote Sensing (AREA)
  • Data Mining & Analysis (AREA)
  • Acoustics & Sound (AREA)
  • Theoretical Computer Science (AREA)
  • Fluid Mechanics (AREA)
  • Mathematical Optimization (AREA)
  • Pure & Applied Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Software Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Mathematical Analysis (AREA)
  • Geochemistry & Mineralogy (AREA)
  • Computational Mathematics (AREA)
  • Algebra (AREA)
  • Geophysics And Detection Of Objects (AREA)

Abstract

本发明具体涉及一种钻孔岩层声波时差曲线构筑方法,包括:构建岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式;整理出岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式;根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线;从缺失岩层声波时差曲线钻孔的岩层声波测井数据中提取计算岩层声波时差必须的参数代入岩层声波时差回归曲线,计算得到缺失岩层声波时差曲线钻孔的岩层声波时差参数。本发明的钻孔岩层声波时差曲线构筑方法,能够获得缺失岩层声波时差曲线钻孔的岩层声波时差参数,以获取岩层在井下真实密度。

Figure 202211668959

The present invention specifically relates to a method for constructing the acoustic wave time difference curve of the drilling rock formation, comprising: constructing the relational expression between the sound wave propagation velocity of the rock formation, the depth of the rock formation, and the resistivity of the three sides of the rock formation; According to the relationship between the rock formation acoustic time difference curve and the rock formation acoustic logging data of the drilling hole, the rock formation acoustic time difference curve between the rock formation acoustic time difference and the depth of the rock formation and the three lateral resistivities of the rock formation is regressed; from the missing rock formation acoustic wave The parameters necessary for calculating the rock formation acoustic time difference are extracted from the rock formation acoustic logging data of the time difference curve drilling and substituted into the rock formation acoustic time difference regression curve, and the rock formation acoustic time difference parameters of the missing rock formation acoustic time difference curve drilling are calculated. The method for constructing the sonic time difference curve of the rock strata in the present invention can obtain the sonic time difference parameters of the rock stratum in the hole without the sonic time difference curve of the rock stratum, so as to obtain the real density of the rock strata in the well.

Figure 202211668959

Description

一种钻孔岩层声波时差曲线构筑方法和系统A method and system for constructing acoustic time difference curve of drilling rock formation

技术领域Technical Field

本发明涉及可地浸砂岩型铀矿勘查技术领域,特别是涉及一种钻孔岩层声波时差曲线构筑方法和系统。The invention relates to the technical field of in-situ leachable sandstone type uranium ore exploration, and in particular to a method and system for constructing a borehole rock stratum acoustic wave time difference curve.

背景技术Background Art

在寻找可地浸砂岩型铀矿的野外综合测井工作中,常常会因为工作条件差和路况崎曲颠簸导致声波探管出现故障,如果在测井现场声波探管出现的故障无法排除,就不得不放弃测量钻孔的岩层声波时差参数。而岩层声波时差参数在砂泥岩剖面中,能够有效的区分砂岩和泥岩。In the field comprehensive logging work of searching for in-situ leachable sandstone-type uranium deposits, the sonic probe often fails due to poor working conditions and rough and bumpy roads. If the failure of the sonic probe cannot be eliminated at the logging site, it is necessary to give up measuring the rock formation sonic time difference parameters of the borehole. The rock formation sonic time difference parameters can effectively distinguish sandstone from mudstone in the sandstone-mudstone section.

由于岩层声波传播速度与岩层密度关系密切,岩层声波时差是探知岩层在井下真实密度的有效测井参数。因为据科学研究,在小于1700米,也就是有效压力小于20MPa的埋藏深度范围内,岩层声波传播速度随着上伏地层有效压力的增大而增大,岩层密度随着岩层声波传播速度的增大而增大。Since the propagation velocity of rock formation sound waves is closely related to the density of rock formation, the rock formation sound wave time difference is an effective logging parameter for detecting the real density of rock formation in the well. Because according to scientific research, within the burial depth range of less than 1700 meters, that is, the effective pressure is less than 20MPa, the propagation velocity of rock formation sound waves increases with the increase of the effective pressure of the overlying stratum, and the density of rock formation increases with the increase of the propagation velocity of rock formation sound waves.

而寻找可地浸砂岩型铀矿的勘查钻孔深度恰好包含在小于1700米,也就是有效压力小于20MPa的埋藏深度段内,岩层的声波传播速度与岩层密度的密切关系使得在可地浸砂岩型铀矿勘查过程中,可以通过岩层声波传播速度的变化来获得岩层密度的变化。The exploration drilling depth for searching for in-situ leachable sandstone-type uranium deposits is just less than 1,700 meters, that is, within the burial depth range where the effective pressure is less than 20 MPa. The close relationship between the acoustic wave propagation velocity of the rock formation and its density means that during the exploration of in-situ leachable sandstone-type uranium deposits, the change in rock formation density can be obtained through the change in the acoustic wave propagation velocity of the rock formation.

在可地浸砂岩型铀矿勘查过程中,如果野外测井意外造成岩层声波时差参数缺失,一般会通过γ-γ法测量岩层密度,但是由于钻孔的释压作用,加之本身径向探测深度很浅,γ-γ法测量的密度已不是岩层在井下的真实密度,而是岩层释压之后的密度。所以,在可地浸砂岩型铀矿勘查过程中,野外测井意外造成的岩层声波时差参数缺失会导致无法获取岩层在井下真实密度。In the process of exploration of in-situ leachable sandstone-type uranium deposits, if the field logging accidentally causes the loss of the rock formation acoustic wave time difference parameters, the γ-γ method is generally used to measure the rock formation density. However, due to the pressure relief effect of the borehole and the shallow radial detection depth, the density measured by the γ-γ method is no longer the true density of the rock formation underground, but the density of the rock formation after pressure relief. Therefore, in the process of exploration of in-situ leachable sandstone-type uranium deposits, the loss of the rock formation acoustic wave time difference parameters caused by the field logging accident will lead to the inability to obtain the true density of the rock formation underground.

发明内容Summary of the invention

基于此,本发明针对在可地浸砂岩型铀矿勘查过程中,野外测井意外造成的岩层声波时差参数缺失导致无法获取岩层在井下真实密度的问题,提供一种钻孔岩层声波时差曲线构筑方法和系统,该方法和系统根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出缺失岩层声波时差曲线钻孔的岩层声波时差回归曲线,从而获得缺失岩层声波时差曲线钻孔的岩层声波时差参数,以获取岩层在井下真实密度。Based on this, the present invention aims at the problem that in the exploration process of in-situ leachable sandstone-type uranium deposits, the rock formation acoustic time difference parameters are lost due to accidental field logging, resulting in the inability to obtain the true density of the rock formation underground. A method and system for constructing a borehole rock formation acoustic time difference curve is provided. The method and system regress the rock formation acoustic time difference regression curve of the borehole where the rock formation acoustic time difference curve is missing based on the rock formation acoustic logging data of the borehole where the rock formation acoustic time difference curve is missing, thereby obtaining the rock formation acoustic time difference parameters of the borehole where the rock formation acoustic time difference curve is missing, so as to obtain the true density of the rock formation underground.

为了实现上述目的,本发明提供如下技术方案:In order to achieve the above object, the present invention provides the following technical solutions:

一种钻孔岩层声波时差曲线构筑方法,包括如下步骤:A method for constructing a borehole rock formation acoustic wave time difference curve comprises the following steps:

步骤1、构建岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式;Step 1, constructing a relationship between the propagation velocity of rock sound waves and the rock depth and the three-dimensional resistivity of the rock;

步骤2、将岩层声波传播速度与岩层声波时差之间的关系式代入步骤1的关系式中,整理得到岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式;Step 2, substituting the relationship between the rock formation acoustic wave propagation velocity and the rock formation acoustic wave time difference into the relationship in step 1, and obtaining the relationship between the rock formation acoustic wave time difference and the rock formation depth and the three-dimensional resistivity of the rock formation;

步骤3、根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线;Step 3, regressing the formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-dimensional resistivity of the formation according to the formation acoustic wave time difference curve of the formation acoustic wave logging data of the well borehole;

步骤4、将步骤3的岩层声波时差回归曲线作为缺失岩层声波时差曲线钻孔的岩层声波时差回归曲线,从缺失岩层声波时差曲线钻孔的岩层声波测井数据中提取计算岩层声波时差必须的参数代入岩层声波时差回归曲线,计算得到缺失岩层声波时差曲线钻孔的岩层声波时差参数。Step 4: Use the formation acoustic time difference regression curve of step 3 as the formation acoustic time difference regression curve of the borehole where the formation acoustic time difference curve is missing, extract the parameters necessary for calculating the formation acoustic time difference from the formation acoustic logging data of the borehole where the formation acoustic time difference curve is missing, and substitute them into the formation acoustic time difference regression curve to calculate the formation acoustic time difference parameters of the borehole where the formation acoustic time difference curve is missing.

进一步地,步骤1中,所述岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式为:Furthermore, in step 1, the relationship between the rock formation acoustic wave propagation velocity and the rock formation depth and the three-dimensional resistivity of the rock formation is:

Figure BDA0004013800760000021
Figure BDA0004013800760000021

式中,V为岩层声波传播速度,单位为m/s;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Where V is the acoustic wave propagation velocity of the rock formation, in m/s; H is the depth of the rock formation, in m; Rt is the three-dimensional resistivity of the rock formation, in Ω·m; M is the regional formation factor; A and N are unknown parameters.

进一步地,根据岩石声学理论,岩层声波传播速度与岩层声波时差之间的关系式如下:Furthermore, according to rock acoustic theory, the relationship between the propagation velocity of rock formation sound waves and the rock formation sound wave time difference is as follows:

Figure BDA0004013800760000031
Figure BDA0004013800760000031

将关系式(3)代入步骤1的关系式中,得到如下关系式:Substituting equation (3) into the equation in step 1, we get the following equation:

Figure BDA0004013800760000032
Figure BDA0004013800760000032

对关系式(5)整理得到岩层声波时差与岩层深度和岩层三侧向电阻率之间的统计学关系式:The statistical relationship between the acoustic time difference of the rock formation and the rock formation depth and the three-dimensional resistivity of the rock formation is obtained by sorting out the relationship (5):

Figure BDA0004013800760000033
Figure BDA0004013800760000033

式中,V为岩层声波传播速度,单位为m/s;△t为岩层声波时差,单位为μs/m;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Wherein, V is the propagation velocity of rock acoustic waves, in m/s; △t is the rock acoustic wave time difference, in μs/m; H is the rock depth, in m; Rt is the three-dimensional resistivity of the rock, in Ω·m; M is the regional formation factor; A and N are parameters to be determined.

进一步地,步骤3,根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线,包括如下步骤:Further, step 3, based on the formation acoustic wave time difference curve, the formation acoustic wave logging data of the well borehole is regressed to obtain a formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-dimensional resistivity of the formation, including the following steps:

步骤3.1、对关系式(6)两侧取对数,并移项整理得到如下关系式:Step 3.1, take the logarithm of both sides of the relationship (6), and transpose the terms to obtain the following relationship:

Figure BDA0004013800760000034
Figure BDA0004013800760000034

步骤3.2、为了方便计算,对关系式(7)进行换元,设:Step 3.2: For the convenience of calculation, replace the variables in equation (7) and assume:

Figure BDA0004013800760000035
Figure BDA0004013800760000035

步骤3.3、将关系式(8)代入关系式(7)得到:Step 3.3: Substitute equation (8) into equation (7) to obtain:

y=b0+b1 x1+b2x2(9)y=b 0 +b 1 x 1 +b 2 x 2 (9)

步骤3.4、根据关系式(9)整理岩层声波时差曲线健全钻孔各岩层声波时差参数与各岩层深度参数和各岩层三侧向电阻率参数之间的关系式如下:Step 3.4: Arrange the rock formation acoustic wave time difference curve according to the relationship (9) to improve the relationship between the acoustic wave time difference parameters of each rock formation in the borehole and the depth parameters of each rock formation and the three-dimensional resistivity parameters of each rock formation as follows:

y1=b0+b1 x11+b2x12 y 1 =b 0 +b 1 x 11 +b 2 x 12

y2=b0+b1 x21+b2x22 y 2 =b 0 +b 1 x 21 +b 2 x 22

y3=b0+b1 x31+b2x32 y 3 =b 0 +b 1 x 31 +b 2 x 32

…………………………………………………………………

yi=b0+b1 xi1+b2xi2 y i =b 0 +b 1 x i1 +b 2 x i2

步骤3.5、通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2Step 3.5, using the formation acoustic wave time difference curve to improve the formation acoustic wave logging data of the borehole to solve b 0 , b 1 and b 2 ;

步骤3.6、将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归;Step 3.6, substitute the solved b0 , b1 and b2 into the relational expression (8) to solve A, N and M; substitute A, N and M into the relational expression (6) to complete the regression of the rock formation acoustic wave time difference curve between the rock formation depth and the rock formation three-way resistivity;

所述岩层声波时差曲线健全钻孔为同一工作区和同一地层体系距离缺失岩层声波时差曲线钻孔最近的岩层声波时差曲线健全的钻孔。The rock formation acoustic wave time difference curve sound borehole is a rock formation acoustic wave time difference curve sound borehole which is closest to the missing rock formation acoustic wave time difference curve borehole in the same working area and the same formation system.

进一步地,所述岩层声波时差曲线健全钻孔的岩层声波测井数据由n个岩层声波测井数据组成,第i个岩层声波测井数据包括以下参数:岩层声波时差(△t)i、岩层深度Hi和岩层三侧向电阻率(Rt)iFurther, the formation acoustic logging data of the well-established borehole of the formation acoustic time difference curve is composed of n formation acoustic logging data, and the i-th formation acoustic logging data includes the following parameters: formation acoustic time difference (△t) i , formation depth H i and formation three-dimensional resistivity (R t ) i ;

x1={x11,x21,x31…xi1},xi1是根据岩层声波时差曲线健全钻孔岩层深度Hi计算得到的;x 1 ={x 11 , x 21 , x 31 .. x i1 }, x i1 is calculated based on the rock formation depth Hi of the rock formation acoustic wave time difference curve;

x2={x12,x22,x32…xi2},xi2是根据岩层声波时差曲线健全钻孔岩层三侧向电阻率深度(Rt)i计算得到的;x 2 ={x 12 , x 22 , x 32 .. x i2 }, x i2 is calculated based on the three-dimensional resistivity depth (R t ) i of the well-developed borehole rock formation based on the rock formation acoustic wave time difference curve;

y={y1,y2,y3…yi},yi是根据岩层声波时差曲线健全钻孔岩层声波时差(△t)i计算得到的。y={y 1 , y 2 , y 3 .. y i }, y i is calculated based on the formation acoustic wave time difference curve and the sound borehole formation acoustic wave time difference (△t) i .

进一步地,步骤3.5,通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2,包括如下步骤:Furthermore, step 3.5, solving b 0 , b 1 and b 2 by using the formation acoustic logging data of the borehole through the formation acoustic time difference curve, comprises the following steps:

步骤3.5.1、构建线性方程组如下:Step 3.5.1, construct the linear equation system as follows:

L11b1+L12b2=L1y(10)L 11 b 1 +L 12 b 2 =L 1y (10)

L21b1+L22b2=L2y(11)L 21 b 1 +L 22 b 2 =L 2y (11)

其中,in,

Figure BDA0004013800760000051
Figure BDA0004013800760000051

Figure BDA0004013800760000052
Figure BDA0004013800760000052

L21=L12(14) L21L12 (14)

Figure BDA0004013800760000053
Figure BDA0004013800760000053

Figure BDA0004013800760000054
Figure BDA0004013800760000054

Figure BDA0004013800760000055
Figure BDA0004013800760000055

Figure BDA0004013800760000056
Figure BDA0004013800760000056

步骤3.5.2、建立如下矩阵求解所述线性方程组:Step 3.5.2, establish the following matrix to solve the linear equations:

Figure BDA0004013800760000057
Figure BDA0004013800760000057

求解出b0、b1和b2Solve for b 0 , b 1 , and b 2 .

进一步地,通过拟和度来评价岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差回归曲线的回归质量,拟和度的计算公式如下:Furthermore, the regression quality of the rock formation acoustic wave time difference regression curve between the rock formation acoustic wave time difference and the rock formation depth and the rock formation three-lateral resistivity is evaluated by the fitting degree. The calculation formula of the fitting degree is as follows:

Figure BDA0004013800760000061
Figure BDA0004013800760000061

Figure BDA0004013800760000062
Figure BDA0004013800760000062

Figure BDA0004013800760000063
Figure BDA0004013800760000063

式中,Ass为各岩层声波时差观测值的平方和;Bss为各岩层声波时差观测值与回归值之差的平方和;yi为岩层声波时差观测值;

Figure BDA0004013800760000064
为岩层声波时差回归值;R2为拟和度。Where Ass is the sum of squares of acoustic time difference observations of each rock layer; Bss is the sum of squares of the difference between the acoustic time difference observations of each rock layer and the regression value; yi is the acoustic time difference observation value of the rock layer;
Figure BDA0004013800760000064
is the regression value of the rock formation acoustic wave time difference; R2 is the degree of fit.

进一步地,步骤3.5.2,建立矩阵(5)求解线性方程组(9)和(10),求解出b0、b1和b2,包括如下步骤:Further, step 3.5.2, establish matrix (5) to solve the linear equations (9) and (10) to obtain b 0 , b 1 and b 2 , including the following steps:

在Excel软件中,执行如下步骤:In Excel, follow these steps:

将岩层声波时差曲线健全钻孔的岩层声波测井数据各参数分别按列存储在Excel工作簿中;The parameters of the formation acoustic logging data of the well-developed borehole of the formation acoustic time difference curve are stored in Excel workbooks by columns;

分别通过求解对数函数“log()”计算各岩层声波时差(△t)i和各岩层深度Hi的对数并将计算得到的log(△t)i和logHi分别按列存储在所述Excel工作簿中;Calculate the logarithm of the acoustic time difference (△t) i of each rock layer and the logarithm of the depth H i of each rock layer by solving the logarithmic function "log()" respectively, and store the calculated log(△t) i and logH i in the Excel workbook by column respectively;

通过关系式(12)-(17)分别计算L11、L12、L21、L22、L1y和L2y,并将计算得到的L11、L12、L21、L22、L1y和L2y按照矩阵

Figure BDA0004013800760000065
Figure BDA0004013800760000066
分别存储在所述Excel工作簿中;L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are calculated respectively by equations (12)-(17), and the calculated L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are converted into the matrix
Figure BDA0004013800760000065
and
Figure BDA0004013800760000066
are stored in the Excel workbook respectively;

通过求解逆矩阵函数“MINVERSE()”求解出矩阵

Figure BDA0004013800760000067
的逆矩阵,通过求解矩阵积函数“MMULT()求解出矩阵
Figure BDA0004013800760000068
的逆矩阵和矩阵
Figure BDA0004013800760000069
的乘积,求解出b1和b2并存储在所述Excel工作簿中;Solve the matrix by solving the inverse matrix function "MINVERSE()"
Figure BDA0004013800760000067
The inverse matrix of the matrix is solved by solving the matrix product function "MMULT()
Figure BDA0004013800760000068
The inverse matrix and matrix
Figure BDA0004013800760000069
The product of is solved for b1 and b2 and stored in the Excel workbook;

根据关系式(18)计算出b0并存储在所述Excel工作簿中。According to the relation (18), b0 is calculated and stored in the Excel workbook.

进一步地,步骤3.6,在Excel软件中,将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归。Further, in step 3.6, in Excel software, the solved b0 , b1 and b2 are substituted into the relational equation (8) to solve A, N and M; A, N and M are substituted into the relational equation (6) to complete the regression of the rock formation acoustic wave time difference curve between the rock formation depth and the rock formation three-way resistivity.

进一步地,在Excel软件中,将计算出来的b0、b1和b2代入关系式(9),求解出岩层声波时差对数的回归值并按列存储在所述Excel工作簿中;Further, in the Excel software, the calculated b 0 , b 1 and b 2 are substituted into the relational expression (9), and the regression value of the logarithm of the acoustic time difference of the rock formation is solved and stored in the Excel workbook by column;

通过求解反对数函数“Power()”求解出岩层声波时差回归值并按列存储在所述Excel工作簿中;The rock formation acoustic wave time difference regression value is solved by solving the antilogarithmic function "Power()" and stored in the Excel workbook by column;

根据关系式(19)-(20)计算各岩层声波观测值的平方Ass,以及各岩层声波时差观测值与回归值之差的平方和Bss;According to equations (19)-(20), the square of the acoustic wave observation value of each rock layer Ass and the sum of the squares of the difference between the acoustic wave time difference observation value and the regression value of each rock layer Bss are calculated;

根据关系式(21)计算岩层声波时差回归曲线的拟和度R2The goodness of fit R 2 of the rock formation acoustic wave time difference regression curve is calculated according to equation (21).

进一步地,步骤4中,所述缺失岩层声波时差曲线钻孔的岩层声波测井数据包括以下参数:岩层深度H和岩层三侧向电阻率RtFurthermore, in step 4, the rock formation acoustic logging data of the borehole where the rock formation acoustic time difference curve is missing includes the following parameters: rock formation depth H and rock formation three-dimensional resistivity R t .

本发明还提供一种钻孔岩层声波时差曲线构筑系统,包括:The present invention also provides a drilling rock formation acoustic wave time difference curve construction system, comprising:

数据获取模块,用于获取岩层声波时差曲线健全钻孔的岩层声波测井数据和缺失岩层声波时差曲线钻孔的岩层声波测井数据,并将岩层声波时差曲线健全钻孔的岩层声波测井数据发送至曲线回归模块,将缺失岩层声波时差曲线钻孔的岩层声波测井数据发送至参数计算模块;A data acquisition module is used to acquire the formation acoustic logging data of the borehole with a sound formation acoustic time difference curve and the formation acoustic logging data of the borehole with a missing formation acoustic time difference curve, and send the formation acoustic logging data of the borehole with a sound formation acoustic time difference curve to the curve regression module, and send the formation acoustic logging data of the borehole with a missing formation acoustic time difference curve to the parameter calculation module;

曲线回归模块,用于接收数据获取模块发送的岩层声波时差曲线健全钻孔的岩层声波测井数据,根据岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式,回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线并发送至参数计算模块;The curve regression module is used to receive the formation acoustic wave time difference curve sent by the data acquisition module to improve the formation acoustic wave logging data of the borehole, and regress the formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation according to the relationship between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation, and send it to the parameter calculation module;

参数计算模块,用于接收数据获取模块发送的缺失岩层声波时差曲线钻孔的岩层声波测井数据以及曲线回归模块发送的岩层声波时差回归曲线,从缺失岩层声波时差曲线钻孔的岩层声波测井数据中提取计算岩层声波时差必须的参数代入岩层声波时差回归曲线,计算得到缺失岩层声波时差曲线钻孔的岩层声波时差参数。The parameter calculation module is used to receive the rock formation acoustic logging data of the borehole with missing rock formation acoustic time difference curve sent by the data acquisition module and the rock formation acoustic time difference regression curve sent by the curve regression module, extract the parameters necessary for calculating the rock formation acoustic time difference from the rock formation acoustic logging data of the borehole with missing rock formation acoustic time difference curve, substitute them into the rock formation acoustic time difference regression curve, and calculate the rock formation acoustic time difference parameters of the borehole with missing rock formation acoustic time difference curve.

进一步地,岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式为:Furthermore, the relationship between the acoustic time difference of the rock formation and the rock formation depth and the three-dimensional resistivity of the rock formation is:

Figure BDA0004013800760000081
Figure BDA0004013800760000081

式中,V为岩层声波传播速度,单位为m/s;△t为岩层声波时差,单位为μs/m;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Wherein, V is the propagation velocity of rock acoustic waves, in m/s; △t is the rock acoustic wave time difference, in μs/m; H is the rock depth, in m; Rt is the three-dimensional resistivity of the rock, in Ω·m; M is the regional formation factor; A and N are parameters to be determined.

进一步地,曲线回归模块接收数据获取模块发送的岩层声波时差曲线健全钻孔的岩层声波测井数据,根据岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式,回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线,包括如下步骤:Further, the curve regression module receives the formation acoustic wave time difference curve sent by the data acquisition module to improve the formation acoustic wave logging data of the borehole, and regresses the formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation according to the relationship between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation, including the following steps:

对关系式(6)两侧取对数,并移项整理得到如下关系式:Taking the logarithm of both sides of the relationship (6) and transposing the terms, we get the following relationship:

Figure BDA0004013800760000082
Figure BDA0004013800760000082

对关系式(7)进行换元,设:Substitute the variables in equation (7) and assume:

Figure BDA0004013800760000083
Figure BDA0004013800760000083

将关系式(8)代入关系式(7)得到:Substituting equation (8) into equation (7), we obtain:

y=b0+b1 x1+b2x2(9)y=b 0 +b 1 x 1 +b 2 x 2 (9)

根据关系式(9)整理岩层声波时差曲线健全钻孔各岩层声波时差参数与各岩层深度参数和各岩层三侧向电阻率参数之间的关系式如下:According to the relation (9), the relation between the acoustic wave time difference curve of each rock layer in the wellbore and the depth parameters of each rock layer and the three-dimensional resistivity parameters of each rock layer is as follows:

y1=b0+b1 x11+b2x12 y 1 =b 0 +b 1 x 11 +b 2 x 12

y2=b0+b1 x21+b2x22 y 2 =b 0 +b 1 x 21 +b 2 x 22

y3=b0+b1 x31+b2x32 y 3 =b 0 +b 1 x 31 +b 2 x 32

………………………………………………………………………

yi=b0+b1 xi1+b2xi2 y i =b 0 +b 1 x i1 +b 2 x i2

通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2Solve b 0 , b 1 and b 2 by using the formation acoustic logging data of the wellbore through the formation acoustic time difference curve;

将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归;Substitute the solved b0 , b1 and b2 into equation (8) to solve A, N and M; Substitute A, N and M into equation (6) to complete the regression of the rock formation acoustic wave time difference curve between the rock formation depth and the rock formation three-way resistivity;

所述岩层声波时差曲线健全钻孔为同一工作区和同一地层体系距离缺失岩层声波时差曲线钻孔最近的岩层声波时差曲线健全的钻孔。The rock formation acoustic wave time difference curve sound borehole is a rock formation acoustic wave time difference curve sound borehole which is closest to the missing rock formation acoustic wave time difference curve borehole in the same working area and the same formation system.

进一步地,所述岩层声波时差曲线健全钻孔的岩层声波测井数据由n个岩层声波测井数据组成,第i个岩层声波测井数据包括以下参数:岩层声波时差(△t)i、岩层深度Hi和岩层三侧向电阻率(Rt)iFurther, the formation acoustic logging data of the well-established borehole of the formation acoustic time difference curve is composed of n formation acoustic logging data, and the i-th formation acoustic logging data includes the following parameters: formation acoustic time difference (△t) i , formation depth H i and formation three-dimensional resistivity (R t ) i ;

x1={x11,x21,x31…xi1},xi1是曲线回归模块根据岩层声波时差曲线健全钻孔岩层深度Hi计算得到的;x 1 ={x 11 , x 21 , x 31 .. x i1 }, where x i1 is calculated by the curve regression module based on the formation acoustic wave time difference curve to improve the borehole formation depth Hi ;

x2={x12,x22,x32…xi2},xi2是曲线回归模块根据岩层声波时差曲线健全钻孔岩层三侧向电阻率深度(Rt)i计算得到的;x 2 ={x 12 , x 22 , x 32 .. x i2 }, where x i2 is calculated by the curve regression module based on the three-dimensional resistivity depth (R t ) i of the well-established borehole rock formation based on the rock formation acoustic wave time difference curve;

y={y1,y2,y3…yi},yi是曲线回归模块根据岩层声波时差曲线健全钻孔岩层声波时差(△t)i计算得到的。y={y 1 , y 2 , y 3 .. y i }, y i is calculated by the curve regression module according to the formation acoustic wave time difference curve of the well-established borehole rock formation acoustic wave time difference (△t) i .

进一步地,曲线回归模块通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2,包括如下步骤:Furthermore, the curve regression module solves b 0 , b 1 and b 2 by using the formation acoustic logging data of the wellbore through the formation acoustic time difference curve, including the following steps:

构建线性方程组如下:The linear equations are constructed as follows:

L11b1+L12b2=L1y(10)L 11 b 1 +L 12 b 2 =L 1y (10)

L21b1+L22b2=L2y(11)L 21 b 1 +L 22 b 2 =L 2y (11)

其中,in,

Figure BDA0004013800760000101
Figure BDA0004013800760000101

Figure BDA0004013800760000102
Figure BDA0004013800760000102

L21=L12(14) L21L12 (14)

Figure BDA0004013800760000103
Figure BDA0004013800760000103

Figure BDA0004013800760000104
Figure BDA0004013800760000104

Figure BDA0004013800760000105
Figure BDA0004013800760000105

Figure BDA0004013800760000106
Figure BDA0004013800760000106

建立如下矩阵求解所述线性方程组:The following matrix is established to solve the linear equations:

Figure BDA0004013800760000107
Figure BDA0004013800760000107

求解出b0、b1和b2Solve for b 0 , b 1 , and b 2 .

进一步地,曲线回归模块通过拟和度来评价岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差回归曲线的回归质量,拟和度的计算公式如下:Furthermore, the curve regression module evaluates the regression quality of the rock formation acoustic wave time difference regression curve between the rock formation acoustic wave time difference and the rock formation depth and the rock formation three-lateral resistivity through the fitting degree. The calculation formula of the fitting degree is as follows:

Figure BDA0004013800760000108
Figure BDA0004013800760000108

Figure BDA0004013800760000111
Figure BDA0004013800760000111

Figure BDA0004013800760000112
Figure BDA0004013800760000112

式中,Ass为各岩层声波时差观测值的平方和;Bss为各岩层声波时差观测值与回归值之差的平方和;yi为岩层声波时差观测值;

Figure BDA0004013800760000113
为岩层声波时差回归值;R2为拟和度。Where Ass is the sum of squares of acoustic time difference observations of each rock layer; Bss is the sum of squares of the difference between the acoustic time difference observations of each rock layer and the regression value; yi is the acoustic time difference observation value of the rock layer;
Figure BDA0004013800760000113
is the regression value of the rock formation acoustic wave time difference; R2 is the degree of fit.

进一步地,曲线回归模块建立矩阵(5)求解线性方程组(9)和(10),求解出b0、b1和b2,包括如下步骤:Furthermore, the curve regression module establishes the matrix (5) to solve the linear equations (9) and (10) to obtain b 0 , b 1 and b 2 , including the following steps:

调用Excel软件,执行如下步骤:Call Excel software and perform the following steps:

将岩层声波时差曲线健全钻孔的岩层声波测井数据各参数分别按列存储在Excel工作簿中;The parameters of the formation acoustic logging data of the well-developed borehole of the formation acoustic time difference curve are stored in Excel workbooks by columns;

分别通过求解对数函数“log()”计算各岩层声波时差(△t)i和各岩层深度Hi的对数并将计算得到的log(△t)i和logHi分别按列存储在所述Excel工作簿中;Calculate the logarithm of the acoustic time difference (△t) i of each rock layer and the logarithm of the depth H i of each rock layer by solving the logarithmic function "log()" respectively, and store the calculated log(△t) i and logH i in the Excel workbook by column respectively;

通过关系式(12)-(17)分别计算L11、L12、L21、L22、L1y和L2y,并将计算得到的L11、L12、L21、L22、L1y和L2y按照矩阵

Figure BDA0004013800760000114
Figure BDA0004013800760000115
分别存储在所述Excel工作簿中;L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are calculated respectively by equations (12)-(17), and the calculated L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are converted into the matrix
Figure BDA0004013800760000114
and
Figure BDA0004013800760000115
are stored in the Excel workbook respectively;

通过求解逆矩阵函数“MINVERSE()”求解出矩阵

Figure BDA0004013800760000116
的逆矩阵,通过求解矩阵积函数“MMULT()求解出矩阵
Figure BDA0004013800760000117
的逆矩阵和矩阵
Figure BDA0004013800760000118
的乘积,求解出b1和b2并存储在所述Excel工作簿中;Solve the matrix by solving the inverse matrix function "MINVERSE()"
Figure BDA0004013800760000116
The inverse matrix of the matrix is solved by solving the matrix product function "MMULT()
Figure BDA0004013800760000117
The inverse matrix and matrix
Figure BDA0004013800760000118
The product of is solved for b1 and b2 and stored in the Excel workbook;

根据关系式(18)计算出b0并存储在所述Excel工作簿中。According to the relation (18), b0 is calculated and stored in the Excel workbook.

进一步地,曲线回归模块调用Excel软件,将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归。Furthermore, the curve regression module calls Excel software, substitutes the solved b0 , b1 and b2 into the relationship (8), and solves A, N and M; substitutes A, N and M into the relationship (6) to complete the rock formation acoustic wave time difference curve regression between the rock formation depth and the rock formation three-way resistivity.

进一步地,曲线回归模块调用Excel软件,将计算出来的b0、b1和b2代入关系式(9),求解出岩层声波时差对数的回归值并按列存储在所述Excel工作簿中;Furthermore, the curve regression module calls Excel software, substitutes the calculated b 0 , b 1 and b 2 into equation (9), solves the regression value of the logarithm of the rock formation acoustic wave time difference and stores it in the Excel workbook by column;

通过求解反对数函数“Power()”求解出岩层声波时差回归值并按列存储在所述Excel工作簿中;The rock formation acoustic wave time difference regression value is solved by solving the antilogarithmic function "Power()" and stored in the Excel workbook by column;

根据关系式(19)-(20)计算各岩层声波观测值的平方Ass,以及各岩层声波时差观测值与回归值之差的平方和Bss;According to equations (19)-(20), the square of the acoustic wave observation value of each rock layer Ass and the sum of the squares of the difference between the acoustic wave time difference observation value and the regression value of each rock layer Bss are calculated;

根据关系式(21)计算岩层声波时差回归曲线的拟和度R2The goodness of fit R 2 of the rock formation acoustic wave time difference regression curve is calculated according to equation (21).

本发明的有益技术效果:Beneficial technical effects of the present invention:

本发明的钻孔岩层声波时差曲线构筑方法和系统,根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出缺失岩层声波时差曲线钻孔的岩层声波时差回归曲线;岩层声波时差回归曲线比实测岩层声波时差曲线对上伏地层有效压力更灵敏,由此计算得到的测得的岩层密度更准确;岩层声波时差回归曲线比实测岩层声波时差曲线更能准确反应岩层物性。The method and system for constructing a borehole rock formation acoustic wave time difference curve of the present invention regresses the rock formation acoustic wave time difference regression curve of the borehole with missing rock formation acoustic wave time difference curve based on the rock formation acoustic wave time difference curve of the complete borehole rock formation acoustic wave logging data; the rock formation acoustic wave time difference regression curve is more sensitive to the effective pressure of the overlying stratum than the measured rock formation acoustic wave time difference curve, and the measured rock formation density calculated thereby is more accurate; the rock formation acoustic wave time difference regression curve can more accurately reflect the physical properties of the rock formation than the measured rock formation acoustic wave time difference curve.

附图说明BRIEF DESCRIPTION OF THE DRAWINGS

图1为本发明的钻孔岩层声波时差曲线构筑方法流程示意图;FIG1 is a schematic diagram of a method for constructing a borehole rock formation acoustic time difference curve according to the present invention;

图2为本发明的钻孔岩层声波时差曲线构筑系统结构示意图;FIG2 is a schematic diagram of the structure of a drilling rock formation acoustic wave time difference curve construction system of the present invention;

图3为岩层声波时差回归曲线与实测岩层声波时差曲线对比图。FIG3 is a comparison diagram of the rock formation acoustic wave time difference regression curve and the measured rock formation acoustic wave time difference curve.

具体实施方式DETAILED DESCRIPTION

下面结合附图和具体实施方式对本发明的技术方案进行清楚、完整地描述,显然,所描述的实施例是本发明一部分实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例,都属于本发明保护的范围。The technical solution of the present invention is described clearly and completely below in conjunction with the accompanying drawings and specific implementation methods. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

参见图1,本发明提供一种钻孔岩层声波时差曲线构筑方法,包括如下步骤:Referring to FIG. 1 , the present invention provides a method for constructing a borehole rock formation acoustic wave time difference curve, comprising the following steps:

步骤1、构建岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式;Step 1, constructing a relationship between the propagation velocity of rock sound waves and the rock depth and the three-dimensional resistivity of the rock;

步骤2、将岩层声波传播速度与岩层声波时差之间的关系式代入步骤1的关系式中,整理得到岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式;Step 2, substituting the relationship between the rock formation acoustic wave propagation velocity and the rock formation acoustic wave time difference into the relationship in step 1, and obtaining the relationship between the rock formation acoustic wave time difference and the rock formation depth and the three-dimensional resistivity of the rock formation;

步骤3、根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线;Step 3, regressing the formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-dimensional resistivity of the formation according to the formation acoustic wave time difference curve of the formation acoustic wave logging data of the well borehole;

步骤4、将步骤3的岩层声波时差回归曲线作为缺失岩层声波时差曲线钻孔的岩层声波时差回归曲线,从缺失岩层声波时差曲线钻孔的岩层声波测井数据中提取计算岩层声波时差必须的参数代入岩层声波时差回归曲线,计算得到缺失岩层声波时差曲线钻孔的岩层声波时差参数。Step 4: Use the formation acoustic time difference regression curve of step 3 as the formation acoustic time difference regression curve of the borehole where the formation acoustic time difference curve is missing, extract the parameters necessary for calculating the formation acoustic time difference from the formation acoustic logging data of the borehole where the formation acoustic time difference curve is missing, and substitute them into the formation acoustic time difference regression curve to calculate the formation acoustic time difference parameters of the borehole where the formation acoustic time difference curve is missing.

进一步地,步骤1中,所述岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式为:Furthermore, in step 1, the relationship between the rock formation acoustic wave propagation velocity and the rock formation depth and the three-dimensional resistivity of the rock formation is:

V=A*HN*MRt(4)V=A*H N *M R t(4)

式中,V为岩层声波传播速度,单位为m/s;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Where V is the acoustic wave propagation velocity of the rock formation, in m/s; H is the depth of the rock formation, in m; Rt is the three-dimensional resistivity of the rock formation, in Ω·m; M is the regional formation factor; A and N are unknown parameters.

四十年代后期和五十年代初期,福斯特研究了百万英尺以上的测井资料,将岩层三侧向电阻率与岩层声波传播速度进行对比,得出岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式:In the late 1940s and early 1950s, Foster studied logging data of more than one million feet, compared the three-dimensional resistivity of the rock formation with the propagation velocity of rock sound waves, and obtained the relationship between the propagation velocity of rock sound waves and the depth of the rock formation and the three-dimensional resistivity of the rock formation:

V=K*H*C*d*Rt(1)V=K*H*C*d*Rt(1)

式中,V为岩层声波传播速度,单位为m/s;H为岩层深度,单位为m;Rt为岩层三侧向电阻率电阻率,单位为Ω·m;K、C和d均为参数,根据不同地区选取,无量纲。Where V is the acoustic wave propagation velocity of the rock formation, in m/s; H is the depth of the rock formation, in m; Rt is the three-dimensional resistivity of the rock formation, in Ω·m; K, C and d are all parameters, which are selected according to different regions and are dimensionless.

石油系统通过大量的声学实验,研究出岩层声波传播速度与岩层深度和岩层上伏地层有效压力之间的关系式:Through a large number of acoustic experiments, the petroleum system has studied the relationship between the propagation velocity of rock sound waves and the depth of the rock layer and the effective pressure of the underlying strata:

V=a*(PH)c(2)V=a*(PH) c (2)

式中,V为岩层声波传播速度,单位为m/s;P为岩层上伏地层有效压力,单位为KPa/h;H为岩层深度,单位为m;a和c均为参数。Wherein, V is the propagation velocity of sound waves in the rock formation, in m/s; P is the effective pressure of the underlying stratum in the rock formation, in KPa/h; H is the depth of the rock formation, in m; a and c are parameters.

发明人根据前人研究的岩层声波传播速度与岩层三侧向电阻率、岩层深度和岩层上伏地层有效压力之间的关系,创新性的提出一个岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式:Based on the relationship between the propagation velocity of rock sound waves and the three-dimensional resistivity of rock formations, the depth of rock formations and the effective pressure of the underlying strata of rock formations studied by previous researchers, the inventor innovatively proposed a relationship between the propagation velocity of rock sound waves and the depth of rock formations and the three-dimensional resistivity of rock formations:

Figure BDA0004013800760000141
Figure BDA0004013800760000141

式中,V为岩层声波传播速度,单位为m/s;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Where V is the acoustic wave propagation velocity of the rock formation, in m/s; H is the depth of the rock formation, in m; Rt is the three-dimensional resistivity of the rock formation, in Ω·m; M is the regional formation factor; A and N are unknown parameters.

进一步地,根据岩石声学理论,岩层声波传播速度与岩层声波时差之间的关系式如下:Furthermore, according to rock acoustic theory, the relationship between the propagation velocity of rock formation sound waves and the rock formation sound wave time difference is as follows:

Figure BDA0004013800760000142
Figure BDA0004013800760000142

将关系式(3)代入步骤1的关系式中,得到如下关系式:Substituting equation (3) into the equation in step 1, we get the following equation:

Figure BDA0004013800760000143
Figure BDA0004013800760000143

对关系式(5)整理得到岩层声波时差与岩层深度和岩层三侧向电阻率之间的统计学关系式:The statistical relationship between the acoustic time difference of the rock formation and the rock formation depth and the three-dimensional resistivity of the rock formation is obtained by sorting out the relationship (5):

Figure BDA0004013800760000144
Figure BDA0004013800760000144

式中,V为岩层声波传播速度,单位为m/s;△t为岩层声波时差,单位为μs/m;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Wherein, V is the propagation velocity of rock acoustic waves, in m/s; △t is the rock acoustic wave time difference, in μs/m; H is the rock depth, in m; Rt is the three-dimensional resistivity of the rock, in Ω·m; M is the regional formation factor; A and N are parameters to be determined.

经过大量岩层声波时差曲线健全钻孔实践验证,根据本发明提出的关系式(6)回归得到的岩层声波时差参数与实际测量的岩层声波时差参数的拟合度均在90%以上,获得了满意的结果。实践验证结果证明本发明提出的关系式(6)是正确可行的。After a large number of rock formation acoustic time difference curves and sound drilling practice verification, the rock formation acoustic time difference parameters obtained by regression of the relational equation (6) proposed in the present invention and the actual measured rock formation acoustic time difference parameters have a fitting degree of more than 90%, and satisfactory results have been obtained. The practice verification results prove that the relational equation (6) proposed in the present invention is correct and feasible.

进一步地,步骤3,根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线,包括如下步骤:Further, step 3, based on the formation acoustic wave time difference curve, the formation acoustic wave logging data of the well borehole is regressed to obtain a formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-dimensional resistivity of the formation, including the following steps:

步骤3.1、对关系式(6)两侧取对数,并移项整理得到如下关系式:Step 3.1, take the logarithm of both sides of the relationship (6), and transpose the terms to obtain the following relationship:

Figure BDA0004013800760000151
Figure BDA0004013800760000151

步骤3.2、为了方便计算,对关系式(7)进行换元,设:Step 3.2: For the convenience of calculation, replace the variables in equation (7) and assume:

Figure BDA0004013800760000152
Figure BDA0004013800760000152

步骤3.3、将关系式(8)代入关系式(7)得到:Step 3.3: Substitute equation (8) into equation (7) to obtain:

y=b0+b1 x1+b2x2(9)y=b 0 +b 1 x 1 +b 2 x 2 (9)

步骤3.4、根据关系式(9)整理岩层声波时差曲线健全钻孔各岩层声波时差参数与各岩层深度参数和各岩层三侧向电阻率参数之间的关系式如下:Step 3.4: Arrange the rock formation acoustic wave time difference curve according to the relationship (9) to improve the relationship between the acoustic wave time difference parameters of each rock formation in the borehole and the depth parameters of each rock formation and the three-dimensional resistivity parameters of each rock formation as follows:

y1=b0+b1 x11+b2x12 y 1 =b 0 +b 1 x 11 +b 2 x 12

y2=b0+b1 x21+b2x22 y 2 =b 0 +b 1 x 21 +b 2 x 22

y3=b0+b1 x31+b2x32 y 3 =b 0 +b 1 x 31 +b 2 x 32

………………………………………………………………………

yi=b0+b1 xi1+b2xi2 y i =b 0 +b 1 x i1 +b 2 x i2

步骤3.5、通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2Step 3.5, using the formation acoustic wave time difference curve to improve the formation acoustic wave logging data of the borehole to solve b 0 , b 1 and b 2 ;

步骤3.6、将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归;Step 3.6, substitute the solved b0 , b1 and b2 into the relational expression (8) to solve A, N and M; substitute A, N and M into the relational expression (6) to complete the regression of the rock formation acoustic wave time difference curve between the rock formation depth and the rock formation three-way resistivity;

所述岩层声波时差曲线健全钻孔为同一工作区和同一地层体系距离缺失岩层声波时差曲线钻孔最近的岩层声波时差曲线健全的钻孔。The rock formation acoustic wave time difference curve sound borehole is a rock formation acoustic wave time difference curve sound borehole which is closest to the missing rock formation acoustic wave time difference curve borehole in the same working area and the same formation system.

进一步地,所述岩层声波时差曲线健全钻孔的岩层声波测井数据由n个岩层声波测井数据组成,第i个岩层声波测井数据包括以下参数:岩层声波时差(△t)i、岩层深度Hi和岩层三侧向电阻率(Rt)iFurther, the formation acoustic logging data of the well-established borehole of the formation acoustic time difference curve is composed of n formation acoustic logging data, and the i-th formation acoustic logging data includes the following parameters: formation acoustic time difference (△t) i , formation depth H i and formation three-dimensional resistivity (R t ) i ;

x1={x11,x21,x31…xi1},xi1是根据岩层声波时差曲线健全钻孔岩层深度Hi计算得到的;x 1 ={x 11 , x 21 , x 31 .. x i1 }, x i1 is calculated based on the rock formation depth Hi of the rock formation acoustic wave time difference curve;

x2={x12,x22,x32…xi2},xi2是根据岩层声波时差曲线健全钻孔岩层三侧向电阻率深度(Rt)i计算得到的;x 2 ={x 12 , x 22 , x 32 .. x i2 }, x i2 is calculated based on the three-dimensional resistivity depth (R t ) i of the well-developed borehole rock formation based on the rock formation acoustic wave time difference curve;

y={y1,y2,y3…yi},yi是根据岩层声波时差曲线健全钻孔岩层声波时差(△t)i计算得到的。y={y 1 , y 2 , y 3 .. y i }, y i is calculated based on the formation acoustic wave time difference curve and the sound borehole formation acoustic wave time difference (△t) i .

进一步地,步骤3.5,通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2,包括如下步骤:Furthermore, step 3.5, solving b 0 , b 1 and b 2 by using the formation acoustic logging data of the borehole through the formation acoustic time difference curve, comprises the following steps:

步骤3.5.1、构建线性方程组如下:Step 3.5.1, construct the linear equation system as follows:

L11b1+L12b2=L1y(10)L 11 b 1 +L 12 b 2 =L 1y (10)

L21b1+L22b2=L2y(11)L 21 b 1 +L 22 b 2 =L 2y (11)

其中,in,

Figure BDA0004013800760000171
Figure BDA0004013800760000171

Figure BDA0004013800760000172
Figure BDA0004013800760000172

L21=L12(14) L21L12 (14)

Figure BDA0004013800760000173
Figure BDA0004013800760000173

Figure BDA0004013800760000174
Figure BDA0004013800760000174

Figure BDA0004013800760000175
Figure BDA0004013800760000175

Figure BDA0004013800760000176
Figure BDA0004013800760000176

步骤3.5.2、建立如下矩阵求解所述线性方程组:Step 3.5.2, establish the following matrix to solve the linear equations:

Figure BDA0004013800760000177
Figure BDA0004013800760000177

求解出b0、b1和b2Solve for b 0 , b 1 , and b 2 .

进一步地,通过拟和度来评价岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差回归曲线的回归质量,拟和度的计算公式如下:Furthermore, the regression quality of the rock formation acoustic wave time difference regression curve between the rock formation acoustic wave time difference and the rock formation depth and the rock formation three-lateral resistivity is evaluated by the fitting degree. The calculation formula of the fitting degree is as follows:

Figure BDA0004013800760000178
Figure BDA0004013800760000178

Figure BDA0004013800760000179
Figure BDA0004013800760000179

Figure BDA00040138007600001710
Figure BDA00040138007600001710

式中,Ass为各岩层声波时差观测值的平方和;Bss为各岩层声波时差观测值与回归值之差的平方和;yi为岩层声波时差观测值;

Figure BDA00040138007600001711
为岩层声波时差回归值;R2为拟和度。Where Ass is the sum of squares of acoustic time difference observations of each rock layer; Bss is the sum of squares of the difference between the acoustic time difference observations of each rock layer and the regression value; yi is the acoustic time difference observation value of the rock layer;
Figure BDA00040138007600001711
is the regression value of the rock formation acoustic wave time difference; R2 is the degree of fit.

拟合度R2是指回归曲线对观测值的拟合程度,R2最大值为1,R2越接近1,说明回归曲线对观测值的拟合程度越好,自变量对因变量的解释程度越高,自变量引起的变动占总变动的百分比高,观察点在回归曲线附近越密集。反之,R2的值越小,说明回归曲线对观测值的拟合程度越差,观察点在回归曲线附近的越少。The degree of fit R2 refers to the degree of fit of the regression curve to the observed value. The maximum value of R2 is 1. The closer R2 is to 1, the better the regression curve fits the observed value, the higher the degree of explanation of the independent variable to the dependent variable, the higher the percentage of changes caused by the independent variable in the total change, and the denser the observation points are near the regression curve. Conversely, the smaller the value of R2 , the worse the regression curve fits the observed value, and the fewer the observation points are near the regression curve.

进一步地,步骤3.5.2,建立矩阵(5)求解线性方程组(9)和(10),求解出b0、b1和b2,包括如下步骤:Further, step 3.5.2, establish matrix (5) to solve the linear equations (9) and (10) to obtain b 0 , b 1 and b 2 , including the following steps:

在Excel软件中,执行如下步骤:In Excel, follow these steps:

将岩层声波时差曲线健全钻孔的岩层声波测井数据各参数分别按列存储在Excel工作簿中;The parameters of the formation acoustic logging data of the well-developed borehole of the formation acoustic time difference curve are stored in Excel workbooks by columns;

分别通过求解对数函数“log()”计算各岩层声波时差(△t)i和各岩层深度Hi的对数并将计算得到的log(△t)i和logHi分别按列存储在所述Excel工作簿中;Calculate the logarithm of the acoustic time difference (△t) i of each rock layer and the logarithm of the depth H i of each rock layer by solving the logarithmic function "log()" respectively, and store the calculated log(△t) i and logH i in the Excel workbook by column respectively;

通过关系式(12)-(17)分别计算L11、L12、L21、L22、L1y和L2y,并将计算得到的L11、L12、L21、L22、L1y和L2y按照矩阵

Figure BDA0004013800760000181
Figure BDA0004013800760000182
分别存储在所述Excel工作簿中;L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are calculated respectively by equations (12)-(17), and the calculated L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are converted into the matrix
Figure BDA0004013800760000181
and
Figure BDA0004013800760000182
are stored in the Excel workbook respectively;

通过求解逆矩阵函数“MINVERSE()”求解出矩阵

Figure BDA0004013800760000183
的逆矩阵,通过求解矩阵积函数“MMULT()求解出矩阵
Figure BDA0004013800760000184
的逆矩阵和矩阵
Figure BDA0004013800760000185
的乘积,求解出b1和b2并存储在所述Excel工作簿中;Solve the matrix by solving the inverse matrix function "MINVERSE()"
Figure BDA0004013800760000183
The inverse matrix of the matrix is solved by solving the matrix product function "MMULT()
Figure BDA0004013800760000184
The inverse matrix and matrix
Figure BDA0004013800760000185
The product of is solved for b1 and b2 and stored in the Excel workbook;

根据关系式(18)计算出b0并存储在所述Excel工作簿中。According to the relation (18), b0 is calculated and stored in the Excel workbook.

进一步地,步骤3.6、在Excel软件中,将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归。Further, in step 3.6, in Excel software, the solved b0 , b1 and b2 are substituted into the relational equation (8) to solve A, N and M; A, N and M are substituted into the relational equation (6) to complete the regression of the rock formation acoustic wave time difference curve between the rock formation depth and the rock formation three-way resistivity.

进一步地,在Excel软件中,将计算出来的b0、b1和b2代入关系式(9),求解出岩层声波时差对数的回归值并按列存储在所述Excel工作簿中;Further, in the Excel software, the calculated b 0 , b 1 and b 2 are substituted into the relational expression (9), and the regression value of the logarithm of the acoustic time difference of the rock formation is solved and stored in the Excel workbook by column;

通过求解反对数函数“Power()”求解出岩层声波时差回归值并按列存储在所述Excel工作簿中;The rock formation acoustic wave time difference regression value is solved by solving the antilogarithmic function "Power()" and stored in the Excel workbook by column;

根据关系式(19)-(20)计算各岩层声波观测值的平方Ass,以及各岩层声波时差观测值与回归值之差的平方和Bss;According to equations (19)-(20), the square of the acoustic wave observation value of each rock layer Ass and the sum of the squares of the difference between the acoustic wave time difference observation value and the regression value of each rock layer Bss are calculated;

根据关系式(21)计算岩层声波时差回归曲线的拟和度R2The goodness of fit R 2 of the rock formation acoustic wave time difference regression curve is calculated according to equation (21).

进一步地,步骤4中,所述缺失岩层声波时差曲线钻孔的岩层声波测井数据包括以下参数:岩层深度H和岩层三侧向电阻率RtFurthermore, in step 4, the rock formation acoustic logging data of the borehole where the rock formation acoustic time difference curve is missing includes the following parameters: rock formation depth H and rock formation three-dimensional resistivity R t .

参见图2,本发明还提供一种钻孔岩层声波时差曲线构筑系统,包括:Referring to FIG. 2 , the present invention further provides a drilling rock formation acoustic wave time difference curve construction system, comprising:

数据获取模块,用于获取岩层声波时差曲线健全钻孔的岩层声波测井数据和缺失岩层声波时差曲线钻孔的岩层声波测井数据,并将岩层声波时差曲线健全钻孔的岩层声波测井数据发送至曲线回归模块,将缺失岩层声波时差曲线钻孔的岩层声波测井数据发送至参数计算模块;A data acquisition module is used to acquire the formation acoustic logging data of the borehole with a sound formation acoustic time difference curve and the formation acoustic logging data of the borehole with a missing formation acoustic time difference curve, and send the formation acoustic logging data of the borehole with a sound formation acoustic time difference curve to the curve regression module, and send the formation acoustic logging data of the borehole with a missing formation acoustic time difference curve to the parameter calculation module;

曲线回归模块,用于接收数据获取模块发送的岩层声波时差曲线健全钻孔的岩层声波测井数据,根据岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式,回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线并发送至参数计算模块;The curve regression module is used to receive the formation acoustic wave time difference curve sent by the data acquisition module to improve the formation acoustic wave logging data of the borehole, and regress the formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation according to the relationship between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation, and send it to the parameter calculation module;

参数计算模块,用于接收数据获取模块发送的缺失岩层声波时差曲线钻孔的岩层声波测井数据以及曲线回归模块发送的岩层声波时差回归曲线,从缺失岩层声波时差曲线钻孔的岩层声波测井数据中提取计算岩层声波时差必须的参数代入岩层声波时差回归曲线,计算得到缺失岩层声波时差曲线钻孔的岩层声波时差参数。The parameter calculation module is used to receive the rock formation acoustic logging data of the borehole with missing rock formation acoustic time difference curve sent by the data acquisition module and the rock formation acoustic time difference regression curve sent by the curve regression module, extract the parameters necessary for calculating the rock formation acoustic time difference from the rock formation acoustic logging data of the borehole with missing rock formation acoustic time difference curve, substitute them into the rock formation acoustic time difference regression curve, and calculate the rock formation acoustic time difference parameters of the borehole with missing rock formation acoustic time difference curve.

进一步地,岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式为:Furthermore, the relationship between the acoustic time difference of the rock formation and the rock formation depth and the three-dimensional resistivity of the rock formation is:

Figure BDA0004013800760000201
Figure BDA0004013800760000201

式中,V为岩层声波传播速度,单位为m/s;△t为岩层声波时差,单位为μs/m;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Wherein, V is the propagation velocity of rock acoustic waves, in m/s; △t is the rock acoustic wave time difference, in μs/m; H is the rock depth, in m; Rt is the three-dimensional resistivity of the rock, in Ω·m; M is the regional formation factor; A and N are parameters to be determined.

进一步地,曲线回归模块接收数据获取模块发送的岩层声波时差曲线健全钻孔的岩层声波测井数据,根据岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式,回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线,包括如下步骤:Further, the curve regression module receives the formation acoustic wave time difference curve sent by the data acquisition module to improve the formation acoustic wave logging data of the borehole, and regresses the formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation according to the relationship between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation, including the following steps:

对关系式(6)两侧取对数,并移项整理得到如下关系式:Taking the logarithm of both sides of the relationship (6) and transposing the terms, we get the following relationship:

Figure BDA0004013800760000202
Figure BDA0004013800760000202

对关系式(7)进行换元,设:Substitute the variables in equation (7) and assume:

Figure BDA0004013800760000203
Figure BDA0004013800760000203

将关系式(8)代入关系式(7)得到:Substituting equation (8) into equation (7), we obtain:

y=b0+b1 x1+b2x2(9)y=b 0 +b 1 x 1 +b 2 x 2 (9)

根据关系式(9)整理岩层声波时差曲线健全钻孔各岩层声波时差参数与各岩层深度参数和各岩层三侧向电阻率参数之间的关系式如下:According to the relation (9), the relation between the acoustic wave time difference curve of each rock layer in the wellbore and the depth parameters of each rock layer and the three-dimensional resistivity parameters of each rock layer is as follows:

y1=b0+b1 x11+b2x12 y 1 =b 0 +b 1 x 11 +b 2 x 12

y2=b0+b1 x21+b2x22 y 2 =b 0 +b 1 x 21 +b 2 x 22

y3=b0+b1 x31+b2x32 y 3 =b 0 +b 1 x 31 +b 2 x 32

……………………………………………………………………………………

yi=b0+b1 xi1+b2xi2 y i =b 0 +b 1 x i1 +b 2 x i2

通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2Solve b 0 , b 1 and b 2 by using the formation acoustic logging data of the wellbore through the formation acoustic time difference curve;

将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归;Substitute the solved b0 , b1 and b2 into equation (8) to solve A, N and M; Substitute A, N and M into equation (6) to complete the regression of the rock formation acoustic wave time difference curve between the rock formation depth and the rock formation three-way resistivity;

所述岩层声波时差曲线健全钻孔为同一工作区和同一地层体系距离缺失岩层声波时差曲线钻孔最近的岩层声波时差曲线健全的钻孔。The rock formation acoustic wave time difference curve sound borehole is a rock formation acoustic wave time difference curve sound borehole which is closest to the missing rock formation acoustic wave time difference curve borehole in the same working area and the same formation system.

进一步地,所述岩层声波时差曲线健全钻孔的岩层声波测井数据由n个岩层声波测井数据组成,第i个岩层声波测井数据包括以下参数:岩层声波时差(△t)i、岩层深度Hi和岩层三侧向电阻率(Rt)iFurther, the formation acoustic logging data of the well-established borehole of the formation acoustic time difference curve is composed of n formation acoustic logging data, and the i-th formation acoustic logging data includes the following parameters: formation acoustic time difference (△t) i , formation depth H i and formation three-dimensional resistivity (R t ) i ;

x1={x11,x21,x31…xi1},xi1是曲线回归模块根据岩层声波时差曲线健全钻孔岩层深度Hi计算得到的;x 1 ={x 11 , x 21 , x 31 .. x i1 }, where x i1 is calculated by the curve regression module based on the formation acoustic wave time difference curve to improve the borehole formation depth Hi ;

x2={x12,x22,x32…xi2},xi2是曲线回归模块根据岩层声波时差曲线健全钻孔岩层三侧向电阻率深度(Rt)i计算得到的;x 2 ={x 12 , x 22 , x 32 .. x i2 }, where x i2 is calculated by the curve regression module based on the three-dimensional resistivity depth (R t ) i of the well-established borehole rock formation based on the rock formation acoustic wave time difference curve;

y={y1,y2,y3…yi},yi是曲线回归模块根据岩层声波时差曲线健全钻孔岩层声波时差(△t)i计算得到的。y={y 1 , y 2 , y 3 .. y i }, y i is calculated by the curve regression module according to the formation acoustic wave time difference curve of the well-established borehole formation acoustic wave time difference (△t) i .

进一步地,曲线回归模块通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2,包括如下步骤:Furthermore, the curve regression module solves b 0 , b 1 and b 2 by using the formation acoustic wave time difference curve to improve the formation acoustic wave logging data of the borehole, including the following steps:

构建线性方程组如下:The linear equations are constructed as follows:

L11b1+L12b2=L1y(10)L 11 b 1 +L 12 b 2 =L 1y (10)

L21b1+L22b2=L2y(11)L 21 b 1 +L 22 b 2 =L 2y (11)

其中,in,

Figure BDA0004013800760000221
Figure BDA0004013800760000221

Figure BDA0004013800760000222
Figure BDA0004013800760000222

L21=L12(14) L21L12 (14)

Figure BDA0004013800760000223
Figure BDA0004013800760000223

Figure BDA0004013800760000224
Figure BDA0004013800760000224

Figure BDA0004013800760000225
Figure BDA0004013800760000225

Figure BDA0004013800760000226
Figure BDA0004013800760000226

建立如下矩阵求解所述线性方程组:The following matrix is established to solve the linear equations:

Figure BDA0004013800760000227
Figure BDA0004013800760000227

求解出b0、b1和b2Solve for b 0 , b 1 , and b 2 .

进一步地,曲线回归模块通过拟和度来评价岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差回归曲线的回归质量,拟和度的计算公式如下:Furthermore, the curve regression module evaluates the regression quality of the rock formation acoustic wave time difference regression curve between the rock formation acoustic wave time difference and the rock formation depth and the rock formation three-lateral resistivity through the fitting degree. The calculation formula of the fitting degree is as follows:

Figure BDA0004013800760000228
Figure BDA0004013800760000228

Figure BDA0004013800760000229
Figure BDA0004013800760000229

Figure BDA0004013800760000231
Figure BDA0004013800760000231

式中,Ass为各岩层声波时差观测值的平方和;Bss为各岩层声波时差观测值与回归值之差的平方和;yi为岩层声波时差观测值;

Figure BDA0004013800760000232
为岩层声波时差回归值;R2为拟和度。Where Ass is the sum of squares of acoustic time difference observations of each rock layer; Bss is the sum of squares of the difference between the acoustic time difference observations of each rock layer and the regression value; yi is the acoustic time difference observation value of the rock layer;
Figure BDA0004013800760000232
is the regression value of the rock formation acoustic wave time difference; R2 is the degree of fit.

进一步地,曲线回归模块建立矩阵(5)求解线性方程组(9)和(10),求解出b0、b1和b2,包括如下步骤:Furthermore, the curve regression module establishes the matrix (5) to solve the linear equations (9) and (10) to obtain b 0 , b 1 and b 2 , including the following steps:

调用Excel软件,执行如下步骤:Call Excel software and perform the following steps:

将岩层声波时差曲线健全钻孔的岩层声波测井数据各参数分别按列存储在Excel工作簿中;The parameters of the formation acoustic logging data of the well-developed borehole of the formation acoustic time difference curve are stored in Excel workbooks by columns;

分别通过求解对数函数“log()”计算各岩层声波时差(△t)i和各岩层深度Hi的对数并将计算得到的log(△t)i和logHi分别按列存储在所述Excel工作簿中;Calculate the logarithm of the acoustic time difference (△t) i of each rock layer and the logarithm of the depth H i of each rock layer by solving the logarithmic function "log()" respectively, and store the calculated log(△t) i and logH i in the Excel workbook by column respectively;

通过关系式(12)-(17)分别计算L11、L12、L21、L22、L1y和L2y,并将计算得到的L11、L12、L21、L22、L1y和L2y按照矩阵

Figure BDA0004013800760000233
Figure BDA0004013800760000234
分别存储在所述Excel工作簿中;L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are calculated respectively by equations (12)-(17), and the calculated L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are converted into the matrix
Figure BDA0004013800760000233
and
Figure BDA0004013800760000234
are stored in the Excel workbook respectively;

通过求解逆矩阵函数“MINVERSE()”求解出矩阵

Figure BDA0004013800760000235
的逆矩阵,通过求解矩阵积函数“MMULT()求解出矩阵
Figure BDA0004013800760000236
的逆矩阵和矩阵
Figure BDA0004013800760000237
的乘积,求解出b1和b2并存储在所述Excel工作簿中;Solve the matrix by solving the inverse matrix function "MINVERSE()"
Figure BDA0004013800760000235
The inverse matrix of the matrix is solved by solving the matrix product function "MMULT()
Figure BDA0004013800760000236
The inverse matrix and matrix
Figure BDA0004013800760000237
The product of is solved for b1 and b2 and stored in the Excel workbook;

根据关系式(18)计算出b0并存储在所述Excel工作簿中。According to the relation (18), b0 is calculated and stored in the Excel workbook.

进一步地,曲线回归模块调用Excel软件,将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归。Furthermore, the curve regression module calls Excel software, substitutes the solved b0 , b1 and b2 into the relationship (8), and solves A, N and M; substitutes A, N and M into the relationship (6) to complete the rock formation acoustic wave time difference curve regression between the rock formation depth and the rock formation three-way resistivity.

进一步地,曲线回归模块调用Excel软件,将计算出来的b0、b1和b2代入关系式(9),求解出岩层声波时差对数的回归值并按列存储在所述Excel工作簿中;Furthermore, the curve regression module calls Excel software, substitutes the calculated b 0 , b 1 and b 2 into equation (9), solves the regression value of the logarithm of the rock formation acoustic wave time difference and stores it in the Excel workbook by column;

通过求解反对数函数“Power()”求解出岩层声波时差回归值并按列存储在所述Excel工作簿中;The rock formation acoustic wave time difference regression value is solved by solving the antilogarithmic function "Power()" and stored in the Excel workbook by column;

根据关系式(19)-(20)计算各岩层声波观测值的平方Ass,以及各岩层声波时差观测值与回归值之差的平方和Bss;According to equations (19)-(20), the square of the acoustic wave observation value of each rock layer Ass and the sum of the squares of the difference between the acoustic wave time difference observation value and the regression value of each rock layer Bss are calculated;

根据关系式(21)计算岩层声波时差回归曲线的拟和度R2The goodness of fit R 2 of the rock formation acoustic wave time difference regression curve is calculated according to equation (21).

将本发明的钻孔岩层声波时差曲线构筑方法和系统,应用在××地区×盆地可地浸砂岩型铀矿岩层声波时差曲线健全钻孔ZKn0-3的岩层声波时差曲线回归,回归的岩层声波时差曲线拟合度R2为96.13%。The method and system for constructing the borehole rock formation acoustic wave time difference curve of the present invention are applied to the rock formation acoustic wave time difference curve regression of the rock formation acoustic wave time difference curve of the leachable sandstone type uranium ore rock formation ZKn0-3 in the × basin of the ×× area, and the regressed rock formation acoustic wave time difference curve fitting degree R2 is 96.13%.

钻孔ZKn0-3的岩层声波时差回归曲线为:The rock formation acoustic wave time difference regression curve of borehole ZKn0-3 is:

△t=1499.271*H0.09294*0.984Rt△t=1499.271*H 0.09294 *0.984 R t

式中,△t为岩层声波时差,单位为μs/m;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m。Where △t is the acoustic time difference of the rock formation, in μs/m; H is the depth of the rock formation, in m; Rt is the three-dimensional resistivity of the rock formation, in Ω·m.

参见图3,将××地区×盆地可地浸砂岩型铀矿岩层声波时差曲线健全钻孔ZKn0-3的岩层声波时差回归曲线与其实测岩层声波时差曲线进行对比,可以看出:Referring to Figure 3, the acoustic wave time difference curve of the rock formation of the in-situ leachable sandstone uranium ore in the × basin of the ×× area is compared with the rock formation acoustic wave time difference curve of the sound borehole ZKn0-3 and the actual measured rock formation acoustic wave time difference curve, and it can be seen that:

1、钻孔ZKn0-3实测岩层声波时差曲线没有大的起伏变化,自130~443米曲线明显向左偏斜;钻孔ZKn0-3岩层声波时差回归曲线从0~443米明显向左偏斜;岩层声波时差曲线向左偏斜说明岩层声波传播速度随着上伏地层有效压力增大而逐渐增大,钻孔ZKn0-3岩层声波时差回归曲线比其实测岩层声波时差曲线对上伏地层有效压力更灵敏,由此计算得到的测得的岩层密度更准确。1. The measured rock formation acoustic wave time difference curve of borehole ZKn0-3 has no major fluctuations, and the curve is obviously tilted to the left from 130 to 443 meters; the rock formation acoustic wave time difference regression curve of borehole ZKn0-3 is obviously tilted to the left from 0 to 443 meters; the leftward tilt of the rock formation acoustic wave time difference curve indicates that the propagation speed of rock formation acoustic waves gradually increases with the increase of the effective pressure of the overlying stratum, and the rock formation acoustic wave time difference regression curve of borehole ZKn0-3 is more sensitive to the effective pressure of the overlying stratum than the measured rock formation acoustic wave time difference curve, and the measured rock formation density calculated from it is more accurate.

2、钻孔ZKn0-3实测岩层声波时差曲线对钻孔剖面中的两大地质旋回,白垩系和侏罗系的物性没有差异性反映;钻孔ZKn0-3岩层声波时差回归曲线对白垩系的砾岩有较大的差异性反映,在白垩系的砾岩处,钻孔ZKn0-3岩层声波时差回归曲线与其三侧向电阻率曲线呈镜像关系,将白垩系和侏罗系两大地质旋回的交界面清晰的反映出来,钻孔ZKn0-3岩层声波时差回归曲线比其实测岩层声波时差曲线更能准确反应岩层物性。2. The measured rock formation acoustic time difference curve of borehole ZKn0-3 has no different reflection on the physical properties of the two major geological cycles in the borehole profile, the Cretaceous and Jurassic systems; the rock formation acoustic time difference regression curve of borehole ZKn0-3 has a greater difference reflection on the Cretaceous conglomerate. In the Cretaceous conglomerate, the rock formation acoustic time difference regression curve of borehole ZKn0-3 is in a mirror relationship with its three lateral resistivity curves, which clearly reflects the interface between the two major geological cycles of the Cretaceous and Jurassic systems. The rock formation acoustic time difference regression curve of borehole ZKn0-3 can more accurately reflect the physical properties of the rock formation than the measured rock formation acoustic time difference curve.

图3中,水平比例尺放大造成钻孔倾斜明显。In Figure 3 , the enlarged horizontal scale causes the borehole to be tilted significantly.

以上所述实施例仅表达了本发明的几种实施方式,其描述较为具体和详细,但并不能因此而理解为对本发明专利范围的限制。应当指出的是,对于本领域的普通技术人员来说,在不脱离本发明构思的前提下,还可以做出若干变形和改进,这些都属于本发明的保护范围。因此,本发明专利的保护范围应以所附权利要求为准。The above-mentioned embodiments only express several implementation methods of the present invention, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the patent of the present invention. It should be pointed out that, for ordinary technicians in this field, several variations and improvements can be made without departing from the concept of the present invention, and these all belong to the protection scope of the present invention. Therefore, the protection scope of the patent of the present invention shall be subject to the attached claims.

Claims (12)

1.一种钻孔岩层声波时差曲线构筑方法,其特征在于,包括如下步骤:1. A method for constructing a borehole rock formation acoustic wave time difference curve, characterized in that it comprises the following steps: 步骤1、构建岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式;Step 1, constructing a relationship between the propagation velocity of rock sound waves and the rock depth and the three-dimensional resistivity of the rock; 步骤2、将岩层声波传播速度与岩层声波时差之间的关系式代入步骤1的关系式中,整理得到岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式;Step 2, substituting the relationship between the rock formation acoustic wave propagation velocity and the rock formation acoustic wave time difference into the relationship in step 1, and obtaining the relationship between the rock formation acoustic wave time difference and the rock formation depth and the three-dimensional resistivity of the rock formation; 步骤3、根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线;Step 3, regressing the formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-dimensional resistivity of the formation according to the formation acoustic wave time difference curve of the formation acoustic wave logging data of the well borehole; 步骤4、将步骤3的岩层声波时差回归曲线作为缺失岩层声波时差曲线钻孔的岩层声波时差回归曲线,从缺失岩层声波时差曲线钻孔的岩层声波测井数据中提取计算岩层声波时差必须的参数代入岩层声波时差回归曲线,计算得到缺失岩层声波时差曲线钻孔的岩层声波时差参数。Step 4: Use the formation acoustic time difference regression curve of step 3 as the formation acoustic time difference regression curve of the borehole where the formation acoustic time difference curve is missing, extract the parameters necessary for calculating the formation acoustic time difference from the formation acoustic logging data of the borehole where the formation acoustic time difference curve is missing, and substitute them into the formation acoustic time difference regression curve to calculate the formation acoustic time difference parameters of the borehole where the formation acoustic time difference curve is missing. 2.根据权利要求1所述的钻孔岩层声波时差曲线构筑方法,其特征在于,步骤1中,所述岩层声波传播速度与岩层深度和岩层三侧向电阻率之间的关系式为:2. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 1, characterized in that in step 1, the relationship between the rock formation acoustic wave propagation velocity and the rock formation depth and the three-dimensional resistivity of the rock formation is:
Figure FDA0004013800750000011
Figure FDA0004013800750000011
式中,V为岩层声波传播速度,单位为m/s;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Where V is the acoustic wave propagation velocity of the rock formation, in m/s; H is the depth of the rock formation, in m; Rt is the three-dimensional resistivity of the rock formation, in Ω·m; M is the regional formation factor; A and N are unknown parameters.
3.根据权利要求2所述的钻孔岩层声波时差曲线构筑方法,其特征在于,步骤2中,所述岩层声波传播速度与岩层声波时差之间的关系式如下:3. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 2, characterized in that in step 2, the relationship between the rock formation acoustic wave propagation velocity and the rock formation acoustic wave time difference is as follows:
Figure FDA0004013800750000012
Figure FDA0004013800750000012
将关系式(3)代入步骤1的关系式中,得到如下关系式:Substituting equation (3) into the equation in step 1, we get the following equation:
Figure FDA0004013800750000013
Figure FDA0004013800750000013
对关系式(5)整理得到岩层声波时差与岩层深度和岩层三侧向电阻率之间的统计学关系式:The statistical relationship between the acoustic time difference of the rock formation and the rock formation depth and the three-dimensional resistivity of the rock formation is obtained by sorting out the relationship (5):
Figure FDA0004013800750000021
Figure FDA0004013800750000021
式中,V为岩层声波传播速度,单位为m/s;Δt为岩层声波时差,单位为μs/m;H为岩层深度,单位为m;Rt为岩层三侧向电阻率,单位为Ω·m;M为地区地层因子;A和N为待定参数。Wherein, V is the propagation velocity of rock acoustic waves, in m/s; Δt is the rock acoustic wave time difference, in μs/m; H is the rock depth, in m; Rt is the three-dimensional resistivity of the rock, in Ω·m; M is the regional formation factor; A and N are parameters to be determined.
4.根据权利要求3所述的钻孔岩层声波时差曲线构筑方法,其特征在于,步骤3,根据岩层声波时差曲线健全钻孔的岩层声波测井数据回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线,包括如下步骤:4. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 3 is characterized in that step 3, regressing the rock formation acoustic wave time difference curve between the rock formation acoustic wave time difference and the rock formation depth and the three-dimensional resistivity of the rock formation according to the rock formation acoustic wave time difference curve to improve the rock formation acoustic wave logging data of the borehole, comprises the following steps: 步骤3.1、对关系式(6)两侧取对数,并移项整理得到如下关系式:Step 3.1, take the logarithm of both sides of the relationship (6), and transpose the terms to obtain the following relationship:
Figure FDA0004013800750000022
Figure FDA0004013800750000022
步骤3.2、对关系式(7)进行换元,设:Step 3.2: Substitute the variables in equation (7) and assume:
Figure FDA0004013800750000023
Figure FDA0004013800750000023
步骤3.3、将关系式(8)代入关系式(7)得到:Step 3.3: Substitute equation (8) into equation (7) to obtain: y=b0+b1x1+b2x2 (9)y=b 0 +b 1 x 1 +b 2 x 2 (9) 步骤3.4、根据关系式(9)整理岩层声波时差曲线健全钻孔各岩层声波时差参数与各岩层深度参数和各岩层三侧向电阻率参数之间的关系式如下:Step 3.4: Arrange the rock formation acoustic wave time difference curve according to the relationship (9) to improve the relationship between the acoustic wave time difference parameters of each rock formation in the borehole and the depth parameters of each rock formation and the three-dimensional resistivity parameters of each rock formation as follows: y1=b0+b1x11+b2x12 y 1 =b 0 +b 1 x 11 +b 2 x 12 y2=b0+b1x21+b2x22 y 2 =b 0 +b 1 x 21 +b 2 x 22 y3=b0+b1x31+b2x32 y 3 =b 0 +b 1 x 31 +b 2 x 32 ……………………………………………………………………… yi=b0+b1xi1+b2xi2 y i =b 0 +b 1 x i1 +b 2 x i2 步骤3.5、通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2Step 3.5, using the formation acoustic wave time difference curve to improve the formation acoustic wave logging data of the borehole to solve b 0 , b 1 and b 2 ; 步骤3.6、将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归;Step 3.6, substitute the solved b0 , b1 and b2 into the relational expression (8) to solve A, N and M; substitute A, N and M into the relational expression (6) to complete the regression of the rock formation acoustic wave time difference curve between the rock formation depth and the rock formation three-way resistivity; 所述岩层声波时差曲线健全钻孔为同一工作区和同一地层体系距离缺失岩层声波时差曲线钻孔最近的岩层声波时差曲线健全的钻孔。The rock formation acoustic wave time difference curve sound borehole is a rock formation acoustic wave time difference curve sound borehole which is closest to the missing rock formation acoustic wave time difference curve borehole in the same working area and the same formation system.
5.根据权利要求4所述的钻孔岩层声波时差曲线构筑方法,其特征在于,所述岩层声波时差曲线健全钻孔的岩层声波测井数据由n个岩层声波测井数据组成,第i个岩层声波测井数据包括以下参数:岩层声波时差(Δt)i、岩层深度Hi和岩层三侧向电阻率(Rt)i5. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 4, characterized in that the rock formation acoustic wave time difference curve is composed of n rock formation acoustic wave logging data of the well-established borehole, and the i-th rock formation acoustic wave logging data includes the following parameters: rock formation acoustic wave time difference (Δt) i , rock formation depth Hi and rock formation three-dimensional resistivity (R t ) i ; x1={x11,x21,x31...xi1},xi1是根据岩层声波时差曲线健全钻孔岩层深度Hi计算得到的;x 1 ={x 11 , x 21 , x 31 .. x i1 }, x i1 is calculated based on the sound borehole rock formation depth Hi of the rock formation acoustic wave time difference curve; x2={x12,x22,x32...xi2},xi2是根据岩层声波时差曲线健全钻孔岩层三侧向电阻率深度(Rt)i计算得到的;x 2 ={x 12 , x 22 , x 32 . . . x i2 }, x i2 is calculated based on the three-dimensional resistivity depth (R t ) i of the well-developed borehole rock formation based on the rock formation acoustic wave time difference curve; y={y1,y2,y3...yi},yi是根据岩层声波时差曲线健全钻孔岩层声波时差(Δt)i计算得到的。y={y 1 , y 2 , y 3 . . . y i }, y i is calculated based on the formation acoustic wave time difference curve and the sound borehole formation acoustic wave time difference (Δt) i . 6.根据权利要求5所述的钻孔岩层声波时差曲线构筑方法,其特征在于,步骤3.5,通过岩层声波时差曲线健全钻孔的岩层声波测井数据求解b0、b1和b2,包括如下步骤:6. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 5, characterized in that step 3.5, solving b0 , b1 and b2 by using the rock formation acoustic wave time difference curve to improve the rock formation acoustic wave logging data of the borehole, comprises the following steps: 步骤3.5.1、构建线性方程组如下:Step 3.5.1, construct the linear equation system as follows: L11b1+L12b2=L1y (10)L 11 b 1 +L 1 2b 2 =L 1y (10) L21b1+L22b2=L2y (11)L 21 b 1 +L 22 b 2 =L 2y (11) 其中,in,
Figure FDA0004013800750000041
Figure FDA0004013800750000041
Figure FDA0004013800750000042
Figure FDA0004013800750000042
L21=L12 (14) L21L12 (14)
Figure FDA0004013800750000043
Figure FDA0004013800750000043
Figure FDA0004013800750000044
Figure FDA0004013800750000044
Figure FDA0004013800750000045
Figure FDA0004013800750000045
Figure FDA0004013800750000046
Figure FDA0004013800750000046
步骤3.5.2、建立如下矩阵求解所述线性方程组:Step 3.5.2, establish the following matrix to solve the linear equations:
Figure FDA0004013800750000047
Figure FDA0004013800750000047
求解出b0、b1和b2Solve for b 0 , b 1 , and b 2 .
7.根据权利要求6所述的钻孔岩层声波时差曲线构筑方法,其特征在于,通过拟和度来评价岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差回归曲线的回归质量,拟和度的计算公式如下:7. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 6 is characterized in that the regression quality of the rock formation acoustic wave time difference regression curve between the rock formation acoustic wave time difference and the rock formation depth and the rock formation three-way resistivity is evaluated by the fitting degree, and the calculation formula of the fitting degree is as follows:
Figure FDA0004013800750000051
Figure FDA0004013800750000051
Figure FDA0004013800750000052
Figure FDA0004013800750000052
Figure FDA0004013800750000053
Figure FDA0004013800750000053
式中,Ass为各岩层声波时差观测值的平方和;Bss为各岩层声波时差观测值与回归值之差的平方和;yi为岩层声波时差观测值;
Figure FDA0004013800750000054
为岩层声波时差回归值;R2为拟和度。
Where Ass is the sum of squares of acoustic time difference observations of each rock layer; Bss is the sum of squares of the difference between the acoustic time difference observations of each rock layer and the regression value; yi is the acoustic time difference observation value of the rock layer;
Figure FDA0004013800750000054
is the regression value of the rock formation acoustic wave time difference; R2 is the degree of fit.
8.根据权利要求6所述的钻孔岩层声波时差曲线构筑方法,其特征在于,步骤3.5.2,建立矩阵(5)求解线性方程组(9)和(10),求解出b0、b1和b2,包括如下步骤:8. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 6, characterized in that step 3.5.2, establishing a matrix (5) to solve the linear equations (9) and (10) to solve b0 , b1 and b2 , comprises the following steps: 在Excel软件中,执行如下步骤:In Excel, follow these steps: 将岩层声波时差曲线健全钻孔的岩层声波测井数据各参数分别按列存储在Excel工作簿中;The parameters of the formation acoustic logging data of the well-developed borehole of the formation acoustic time difference curve are stored in Excel workbooks by columns; 分别通过求解对数函数“log()”计算各岩层声波时差(Δt)i和各岩层深度Hi的对数并将计算得到的log(Δt)i和logHi分别按列存储在所述Excel工作簿中;Calculate the logarithm of the acoustic time difference (Δt) i of each rock layer and the logarithm of the depth H i of each rock layer by solving the logarithmic function "log()" respectively, and store the calculated log(Δt) i and logH i in the Excel workbook by column respectively; 通过关系式(12)-(17)分别计算L11、L12、L21、L22、L1y和L2y,并将计算得到的L11、L12、L21、L22、L1y和L2y按照矩阵
Figure FDA0004013800750000061
Figure FDA0004013800750000062
分别存储在所述Excel工作簿中;
L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are calculated respectively by equations (12)-(17), and the calculated L 11 , L 12 , L 21 , L 22 , L 1y and L 2y are converted into the matrix
Figure FDA0004013800750000061
and
Figure FDA0004013800750000062
are stored in the Excel workbook respectively;
通过求解逆矩阵函数“MINVERSE()”求解出矩阵
Figure FDA0004013800750000063
的逆矩阵,通过求解矩阵积函数“MMULT()求解出矩阵
Figure FDA0004013800750000064
的逆矩阵和矩阵
Figure FDA0004013800750000065
的乘积,求解出b1和b2并存储在所述Excel工作簿中;
Solve the matrix by solving the inverse matrix function "MINVERSE()"
Figure FDA0004013800750000063
The inverse matrix of the matrix is solved by solving the matrix product function "MMULT()
Figure FDA0004013800750000064
The inverse matrix and matrix
Figure FDA0004013800750000065
The product of is solved for b1 and b2 and stored in the Excel workbook;
根据关系式(18)计算出b0并存储在所述Excel工作簿中。According to the relation (18), b0 is calculated and stored in the Excel workbook.
9.根据权利要求8所述的钻孔岩层声波时差曲线构筑方法,其特征在于,步骤3.6,在Excel软件中,将求解出的b0、b1和b2代入关系式(8),求解出A、N和M;将A、N和M代入关系式(6),完成岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线回归。9. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 8, characterized in that, in step 3.6, in Excel software, the solved b0 , b1 and b2 are substituted into relational formula (8) to solve A, N and M; A, N and M are substituted into relational formula (6) to complete the rock formation acoustic wave time difference curve regression between the rock formation acoustic wave time difference and the rock formation depth and the three lateral resistivity of the rock formation. 10.根据权利要求9所述的钻孔岩层声波时差曲线构筑方法,其特征在于,在Excel软件中,将计算出来的b0、b1和b2代入关系式(9),求解出岩层声波时差对数的回归值并按列存储在所述Excel工作簿中;10. The method for constructing a borehole rock formation acoustic wave time difference curve according to claim 9, characterized in that, in Excel software, the calculated b 0 , b 1 and b 2 are substituted into the relational equation (9), and the regression value of the logarithm of the rock formation acoustic wave time difference is solved and stored in the Excel workbook by column; 通过求解反对数函数“Power()”求解出岩层声波时差回归值并按列存储在所述Excel工作簿中;The rock formation acoustic wave time difference regression value is solved by solving the antilogarithmic function "Power()" and stored in the Excel workbook by column; 根据关系式(19)-(20)计算各岩层声波观测值的平方Ass,以及各岩层声波时差观测值与回归值之差的平方和Bss;According to equations (19)-(20), the square Ass of the acoustic wave observation value of each rock layer and the sum of the squares of the difference between the acoustic wave time difference observation value and the regression value of each rock layer Bss are calculated; 根据关系式(21)计算岩层声波时差回归曲线的拟和度R2The goodness of fit R 2 of the rock formation acoustic wave time difference regression curve is calculated according to equation (21). 11.根据权利要求1-10任意一项所述的钻孔岩层声波时差曲线构筑方法,其特征在于,步骤4中,所述缺失岩层声波时差曲线钻孔的岩层声波测井数据包括以下参数:岩层深度H和岩层三侧向电阻率Rt11. The method for constructing a borehole rock formation acoustic wave time difference curve according to any one of claims 1 to 10, characterized in that, in step 4, the rock formation acoustic wave logging data of the borehole with missing rock formation acoustic wave time difference curve includes the following parameters: rock formation depth H and rock formation three-dimensional resistivity Rt . 12.一种钻孔岩层声波时差曲线构筑系统,其特征在于,包括:12. A drilling rock formation acoustic wave time difference curve construction system, characterized by comprising: 数据获取模块,用于获取岩层声波时差曲线健全钻孔的岩层声波测井数据和缺失岩层声波时差曲线钻孔的岩层声波测井数据,并将岩层声波时差曲线健全钻孔的岩层声波测井数据发送至曲线回归模块,将缺失岩层声波时差曲线钻孔的岩层声波测井数据发送至参数计算模块;A data acquisition module is used to acquire the formation acoustic logging data of the borehole with a sound formation acoustic time difference curve and the formation acoustic logging data of the borehole with a missing formation acoustic time difference curve, and send the formation acoustic logging data of the borehole with a sound formation acoustic time difference curve to the curve regression module, and send the formation acoustic logging data of the borehole with a missing formation acoustic time difference curve to the parameter calculation module; 曲线回归模块,用于接收数据获取模块发送的岩层声波时差曲线健全钻孔的岩层声波测井数据,根据岩层声波时差与岩层深度和岩层三侧向电阻率之间的关系式,回归出岩层声波时差与岩层深度和岩层三侧向电阻率之间的岩层声波时差曲线并发送至参数计算模块;The curve regression module is used to receive the formation acoustic wave time difference curve sent by the data acquisition module to improve the formation acoustic wave logging data of the borehole, and regress the formation acoustic wave time difference curve between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation according to the relationship between the formation acoustic wave time difference and the formation depth and the three-lateral resistivity of the formation, and send it to the parameter calculation module; 参数计算模块,用于接收数据获取模块发送的缺失岩层声波时差曲线钻孔的岩层声波测井数据以及曲线回归模块发送的岩层声波时差回归曲线,从缺失岩层声波时差曲线钻孔的岩层声波测井数据中提取计算岩层声波时差必须的参数代入岩层声波时差回归曲线,计算得到缺失岩层声波时差曲线钻孔的岩层声波时差参数。The parameter calculation module is used to receive the rock formation acoustic logging data of the borehole with missing rock formation acoustic time difference curve sent by the data acquisition module and the rock formation acoustic time difference regression curve sent by the curve regression module, extract the parameters necessary for calculating the rock formation acoustic time difference from the rock formation acoustic logging data of the borehole with missing rock formation acoustic time difference curve, substitute them into the rock formation acoustic time difference regression curve, and calculate the rock formation acoustic time difference parameters of the borehole with missing rock formation acoustic time difference curve.
CN202211668959.3A 2022-12-23 2022-12-23 Method and system for constructing acoustic time difference curve of drilling rock stratum Active CN116243386B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211668959.3A CN116243386B (en) 2022-12-23 2022-12-23 Method and system for constructing acoustic time difference curve of drilling rock stratum

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211668959.3A CN116243386B (en) 2022-12-23 2022-12-23 Method and system for constructing acoustic time difference curve of drilling rock stratum

Publications (2)

Publication Number Publication Date
CN116243386A true CN116243386A (en) 2023-06-09
CN116243386B CN116243386B (en) 2025-06-10

Family

ID=86630462

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211668959.3A Active CN116243386B (en) 2022-12-23 2022-12-23 Method and system for constructing acoustic time difference curve of drilling rock stratum

Country Status (1)

Country Link
CN (1) CN116243386B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102454399A (en) * 2010-10-26 2012-05-16 中国石油化工股份有限公司 Well logging sound wave time difference signal correction method
CN105134193A (en) * 2015-08-31 2015-12-09 中国华能集团清洁能源技术研究院有限公司 Method for rapidly selecting shale oil-gas growth layer section
AU2020101583A4 (en) * 2020-07-31 2020-09-10 China University Of Geosciences, Beijing A Method for Shale Gas Reservoirs Exploration and its System
CN113050191A (en) * 2019-12-26 2021-06-29 中国石油天然气集团有限公司 Shale oil TOC prediction method and device based on double parameters

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102454399A (en) * 2010-10-26 2012-05-16 中国石油化工股份有限公司 Well logging sound wave time difference signal correction method
CN105134193A (en) * 2015-08-31 2015-12-09 中国华能集团清洁能源技术研究院有限公司 Method for rapidly selecting shale oil-gas growth layer section
CN113050191A (en) * 2019-12-26 2021-06-29 中国石油天然气集团有限公司 Shale oil TOC prediction method and device based on double parameters
AU2020101583A4 (en) * 2020-07-31 2020-09-10 China University Of Geosciences, Beijing A Method for Shale Gas Reservoirs Exploration and its System

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
吴超凡: "利用干井测井曲线确定煤层厚度方法研究", 煤炭科技·地质与勘探, 22 August 2014 (2014-08-22) *

Also Published As

Publication number Publication date
CN116243386B (en) 2025-06-10

Similar Documents

Publication Publication Date Title
CN113901681B (en) A three-dimensional compressibility evaluation method for double sweet spots in shale gas reservoirs with full life cycle
CN110321595B (en) Fault sealing evaluation method for extracting static quality coefficient by logging
CN104564041B (en) Hyposmosis clastic reservoir rock efficiency evaluation method based on exploitation permeability limits
CN106951660A (en) Sea facies clastic rock horizontal well reservoir logging interpretation method and device
CN110058323A (en) A kind of tight sand formation brittleness index calculation method
CN113820750A (en) Method for quantitatively predicting mudstone structural cracks based on elastoplasticity mechanics
CN109931054A (en) The prediction technique of tight sandstone reservoir pressure
CN104749617A (en) Multi-scale fractured reservoir forward model establishing method
CN102220865A (en) Method for detecting pore pressure of limestone formation
CN102243672B (en) Gushing operation condition soft sensing modeling method based on hybrid multiple models in shield tunneling process
CN105700017B (en) A kind of method and apparatus of definite petroleum distribution data
CN103615230B (en) A kind of method for establishing double-shale-indicatwateractor wateractor saturation model
CN111368245A (en) A Method for Quantitative Calculation of Rock Biot Coefficient Considering Multiple Influencing Factors
KR101902779B1 (en) Method for estimating velocity of S wave from other logging data
Li et al. A quantitative model for the geological strength index based on attribute mathematics and its application
Li et al. Comparison and evaluation of overcoring and hydraulic fracturing stress measurements
CN116243386A (en) A method and system for constructing acoustic time-difference curves of drilling rock formations
CN115898368B (en) Method for extracting anisotropic resistivity of shale oil reservoir of horizontal well
CN110488367A (en) A kind of resistivity inversion Initialization Algorithms based on array lateral logging data
CN116522583A (en) Horizontal Well Formation Pressure Prediction Method Based on Linear Regression Method
CN109994161B (en) Calculation method of formation organic carbon content by trend baseline method combined with dynamic linkage method
CN114839678A (en) A calculation method of shear wave velocity in complex soil layer based on seismic wave static penetration test
CN115480315A (en) Identification method of sand body boundary based on instantaneous resistivity vector difference
CN119203597B (en) Method, device, equipment and storage medium for establishing geothermal resource deep temperature field
CN118135103B (en) Quantitative assessment method for water saturation of strong heterogeneous clastic rock reservoir

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant