共查询到18条相似文献,搜索用时 140 毫秒
1.
重力仪静态试验是重力勘探工作开始之前对仪器性能检查的必要环节,由于原理简单,其数据整理常不被人们重视,没有系统的方法,但整理的计算过程却又繁琐复杂,初学者在面对大量数据和多重目标时或顾此失彼,或重复计算,往往要耗费较多的工作时间。Excel电子表格具有强大的数学计算、图形显示功能,且应用广泛,易于操作,可系统整理CG-5型重力仪静态试验的原始观测记录,快速获取静态试验数据表、零点位移曲线及其拟合直线图等直观要素,同时计算得到静态零点位移曲线与直线偏差、平均零点位移率等结果参数,Excel的散点图趋势线功能也改进了静态零点位移校正参数漂移常量DRIFT的计算方法与准确度。这种静态试验数据的整理方法具有快速、准确和直观的优点。 相似文献
2.
3.
4.
利用MATLAB语言编写M文件,可以读取指定文件名下的Excel文档中基点网平差时所运用的基本参数进行计算,得到准确的平差结果;该M文件使用时不需要打开源程序,在Excel文件中输入相关数据后,打开MATLAB运行界面中直接输入M文件名就可以进行平差计算,使用简单方便. 相似文献
5.
CIPW标准矿物计算方法是一百多年前由Cross、Iddings、Pirrson和Washington四位学者设计的岩浆岩岩石化学数据的处理方法,至今在岩浆岩研究中仍发挥着重要的作用.国外学者先后开发了多款软件及Excel工作表,但国内在相关的软件开发方面却显得薄弱.本文在全面评估CIPW标准矿物计算方法的基础上,介绍了作者应用Excel VBA设计的一套计算机程序,该程序除了可计算出标准矿物组成以外,还可计算常用的岩石化学参数.经与前人的计算结果对比表明,该程序的计算结果正确的、可靠的. 相似文献
6.
7.
随着经济发展及矿产资源开发利用程度进一步提高,地质勘探向着深部、复杂地层发展,钻探施工钻孔也向着定向孔、分支孔的方向发展。地质目的对钻探工艺的要求越来越高,在控制钻孔轨迹方面也需越来越精准。本文就钻孔轨迹参数计算及成图作了详细介绍,阐述了钻孔轨迹相关概念及有关参数的计算方法;通过对Excel电子表格相关功能的研究,成功地将其应用到钻孔轨迹参数计算与处理分析中;通过对Solidworks三维制图软件的研究,成功地将其应用到钻孔轨迹监测及成图方面;通过实际工作案例验证了上述方法的可行性。 相似文献
8.
9.
《物探与化探》2020,(3)
快速成像反演方法是近几年重磁勘探定量解释的一个发展热点,由于其在计算过程中不需要加入先验信息,故而可以较为快速地估算场源的深度与密度等相关参量。DEXP(depth from extreme point)成像法由于在深度加权函数中考虑了构造指数,使得成像结果更为准确。笔者基于DEXP快速成像法的基本理论,首先,推导了重力异常及重力梯度张量的DEXP变换形式,并将其应用到场源解释之中;然后,采用理论模型试验,分别分析了数据的点距、误差、计算范围以及背景场对成像结果的影响;最后,将该成像方法应用于实测的全张量重力梯度数据,并与前人研究结果进行了对比与分析。理论模型试验与实际应用均表明:DEXP成像法能够有效压制数据噪声的影响,具有计算稳定性和准确性特点;数据的点距、计算范围和背景场均对DEXP成像结果具有一定的影响,因此在实际数据处理时,应该综合考虑它们对成像结果的影响,并且需要进行相关数据预处理以提高定量解释的精度。 相似文献
10.
11.
土钉支护结构可靠度分析的电子表格法 总被引:1,自引:0,他引:1
岩土工程中存在大量的不确定性,因此,进行土钉支护结构的可靠度分析是十分必要的。利用Excel的规划求解及VB编程功能,采用电子表格法,建立了适用于分层土体的电子表格计算模型,进行了土钉支护结构内部稳定的可靠度分析,得出了最小可靠指标及其相应的临界滑面位置。建立的电子表格模型由数据输入模块、土钉计算模块、土层计算模块、可靠指标计算模块及优化求解模块5部分组成。模型建立之后,只需改变电子表格中的输入数据,即可适用于不同土钉支护结构的可靠度分析。算例分析表明:方法正确,计算过程简单直观。它既可用于不同工况下土钉支护结构内部稳定的可靠度分析,也可简化为相应情况下的定值法分析。 相似文献
12.
13.
14.
15.
We present HNC-Plot, an Excel Visual Basic Application (Excel VBA) that can easily be used to create graphical plots of fluids associated with volcanic gases or geothermal manifestations, based on their helium, nitrogen and CO2 isotope data. HNC-Plot has been designed in a simple way; all the user has to do is to input data in an Excel spreadsheet. The spreadsheet also contains buttons which have links to Excel VBA codes that generate plots. Once, the respective button is clicked, and all required variables are defined, Excel VBA generates a plot with labels and axes. Based upon the user preferences, additional tasks such as construction of mixing lines between mantle and crustal gases or calculation of end-member proportions can also be performed. We sincerely believe geoscientists can quickly and easily create these plots, free of charge, with this application. This study also presents previously published data from related literature to show the foundations of the application and to present sample plots created with it. 相似文献
16.
At present, most calculation results regarding foundation pit dewatering are ideal values, making construction resources prone to being wasted. In order to optimize the traditional pipe well design of large wells, the linear programming solution module in Excel is used, with the total water inflow taken as the objective function, the water level drawdown used as the constraint and test condition, and a station project on the Chengdu Metro Line 7 serving as the subject of this study. The total water inflow of the traditional pipe well design is optimized by the simplex method, producing a total water inflow of 4 040.65 m3/d, which, compared with 4 829.79 m3/d, the total water inflow calculated by means of the traditional design optimization method, engenders a reduction of roughly 16% per day. The feasibility of the optimization methodology is verified by the drawdown constraint, which reveals the decrease of construction costs and the diminution of the influence that the lowered groundwater level has on the surroundings of the metro station. Finally, references are provided as to optimizing the dewatering designs for other metro stations in similar engineering and hydrogeological conditions. 相似文献
17.
At present, most calculation results regarding foundation pit dewatering are ideal values, making construction resources prone to being wasted. In order to optimize the traditional pipe well design of large wells, the linear programming solution module in Excel is used, with the total water inflow taken as the objective function, the water level drawdown used as the constraint and test condition, and a station project on the Chengdu Metro Line 7 serving as the subject of this study. The total water inflow of the traditional pipe well design is optimized by the simplex method, producing a total water inflow of 4 040.65 m~3/d, which, compared with 4 829.79 m~3/d, the total water inflow calculated by means of the traditional design optimization method, engenders a reduction of roughly 16% per day. The feasibility of the optimization methodology is verified by the drawdown constraint, which reveals the decrease of construction costs and the diminution of the influence that the lowered groundwater level has on the surroundings of the metro station. Finally, references are provided as to optimizing the dewatering designs for other metro stations in similar engineering and hydrogeological conditions. 相似文献