摘要
以《煤矿防治水规定释义》中的抽水试验数据为例,对作图法、最小二乘法判定的曲线类型、线性方程和Excel趋势线方法得到的曲线类型、线性方程进行了比较。结果表明,Excel趋势线方法和作图法判定的曲线类型一致,与最小二乘法计算的结果一致。通过计算S0、lgQ、lgS,利用Excel趋势线方法可快速确定抽水试验曲线类型和线性方程,方法简便快捷,正确无误。此外,以同一组抽水试验数据为例,论述了降深次数对曲线判定的影响,认为3个落程和4个落程所反映的曲线形态相近,3个落程可以满足抽水曲线类型的判定,只是对线性方程存在一定影响,表现在线性方程系数的微小变化。
Taking the pumping test data in the "Paraphrases of "Coalmine Water Control Stipulationsj "as examples, carried out comparison between curve types, linear equations from graphing method, least square method and from Excel trend line method. The result has demonstrated that curve types from Excel trend line method and graphing method are identical as well as identical with result from least square method computed. Through the computation of SO, lgQ and lgS, and using Excel trend line method can determine pumping test curve type and linear equation quickly, simple and fast, right on the beam. Besides, taking the tested data from a same group pumping test as an example, discussed the influence of drawdown number on curve determination, considered that curve configurations reflected from 3 drawdowns and 4 drawdowns are similar, 3 drawdowns can satisfy determination of curve types, only certain impact on linear equation, can find expression in subtle changes of linear equation coefficients.
出处
《中国煤炭地质》
2012年第9期41-43,共3页
Coal Geology of China