基于Excel的钻孔单位涌水量换算  

Excel-based Conversion of Specific Inflow in Borehole

作　　者：孙尚云 王大设 陈从磊[2] 

机构地区：[1]淮北矿业股份公司地测处,安徽淮北235000 [2]安徽理工大学地球与环境学院,安徽淮南232001

出　　处：《安徽理工大学学报（自然科学版）》2013年第3期20-23,共4页Journal of Anhui University of Science and Technology:Natural Science

基　　金：国家自然科学基金资助项目(51174256)

摘　　要：针对目前利用钻孔单位涌水量评价含水层富水性所存在的问题,介绍了一种利用抽水试验资料结合Excel的函数计算与图表功能进行钻孔单位涌水量换算方法,在线型绘制、线型的选择判别和综合对比分析的基础上,只对1次或2次降深抽水试验数据进行处理,就可以使单位涌水量换算和含水层富水性评价工作更加完善。该计算过程快捷、简便,大大提高了运算效率与计算的准确性。In view of the existing problems in water -bearing layer evaluation by currently used specific inflow in borehole , a method of conversion of specific inflow in borehole was introduced .On the basis of linear mapping , linear selection criteria and comprehensive analysis of pumping test data with Excel functional calculation and graph function , only processing one or two times drawdown pumping test data , specific inflow conversion and wa-ter-rich aquifer evaluation can be more perfect .The calculation process is quick , simple and operational effi-ciency and calculation accuracy greatly improved .

关 键 词：函数计算 单位涌水量 井径换算 

分 类 号：P641.2[天文地球—地质矿产勘探]