Excel VBA在测量数据处理中的应用

Excel是office办公软件中的一个组件,而VBA是office应用程序共享的一种通用的自动化语言,可以使常用的office应用程序自动化,并可以创建自定义的解决方案。本文对Excel2003的数据处理功能进行分析,论述通过Excel2003的VBA编辑器创建"宏"功能实现测量数据处理的优点;并结合道路工程中桩坐标及其放样数据计算实例,给出了通过VBA编程进行测量数据处理的方法。     

附加约束条件的序贯平差

从观测量分组的参数平差出发,详细推导了附加约束条件的序贯平差及其精度估计,讨论了附加约束条件的抗差序贯平差的计算过程.算例表明,推导的公式正确有效,简单实用,附加约束条件的序贯平差抗差估计能有效地抵制粗差的影响.     

Characterizing heterogeneous permeable media with spatial statistics and tracer data using sequential simulated annealing

Characterizing heterogeneous permeable media using flow and transport data typically requires solution of an inverse problem. Such inverse problems are intensive computationally and may involve iterative procedures requiring many forward simulations of the flow and transport problem. Previous attempts have been limited mostly to flow data such as pressure transient (interference) tests using multiple observation wells. This paper discusses an approach to generating stochastic permeability fields conditioned to geologic data in the form of a vertical variogram derived from cores and logs as well as fluid flow and transport data, such as tracer concentration history, by sequential application of simulated annealing (SA). Thus, the method incorporates elements of geostatistics within the framework of inverse modeling. For tracer-transport calculations, we have used a semianalytic transit-time algorithm which is fast, accurate, and free of numerical dispersion. For steady velocity fields, we introduce a transit-time function which demonstrates the relative importance of data from different sources. The approach is illustrated by application to a set of spatial permeability measurements and tracer data from an experiment in the Antolini Sandstone, an eolian outcrop from northern Arizona. The results clearly reveal the importance of tracer data in reproducing the correlated features (channels) of the permeability field and the scale effects of heterogeneity.     

Speciation analysis and significance of ecological geochemistry

Different species of one element have different activities, so it has different effects on environment and human health. To analyze qualitatively and quantitatively the speciation of a special element in sample, which is the important basis for appraising the toxicity and studying the rule of transfer and translation of elements. Since the 1970＇s, the scheme of sequential extraction has already been used at many laboratories both at home and abroard, to get the information about heavy metals＇ activity in polluted soils. Because this method has the experimental nature, many schemes of problem has taken place, the absence of consistency of these sequential extraction have been formed. Thus the complexity of the schemes, the lack of selectivity of reagent, the lack of quality control, the result mainly related to the extraction scheme used, and so on. In the face of these problems, the study of experimental methods of sequential extraction on three different soils, sediment in Dongting Lake, soil in Jiangsu Province and loess in Shanxi Province was made. Reference materials of heavy metal speciation following sequential extraction in soil and sediment had been developed. Nowadays two kinds of sequential extraction methods which are widely used are BCR （three steps） and improved Tessier methods （seven steps）. Based on three steps of BCR, water-soluble speciation and the residual speciation were increased in our research. BCR701 was determined eight times at different laboratories using BCR three steps. The results showed that determined data obtained eight times were identical to the standard value, and it is indicated that this method has good reproducibility. The stability and homogeneity experiments indicated that the preparation of three types of candidates accorded with our requirements. Eight laboratories had afforded the determined values of 12 heavy metal elements （Cu, Pb, Zn, Mn, Co, Ni, Cd, Cr, Mo, As, Sb, Hg, Se et al.） using BCR three steps. Also, these three candidates afforded the determined values by seven steps, and 12 laboratories had participated.     

Vertical variation of phosphorus forms in surface sediments from Wuli Bay, Taihu Lake, China

1IntroductionPhosphorus,an essential nutrient for the primaryproductivity in freshwater systems,is an important fac-tor controlling lacustrine eutrophication.Although ex-ternal input of phosphorus has been assumed as the vi-tal responsibility for the eutrophication of lakes(ZhuJun et al.,2005),the remobilization of phosphorus insediments has a distinct influence on it as well(Bostr m et al.,1982).The concentrations of totalphosphorus(Ptotal)in the sediments are often related tothe trophic st…     

环境样品中痕量元素的化学形态分析Ⅰ．分析技术在化学形态分析中的应用

文章介绍了形态分析的基本概念,常用的联用分析技术,如气相色谱原子吸收光谱、气相色谱原子荧光光谱、气相色谱微波诱导等离子体原子发射光谱、气相色谱电感耦合等离子体质谱、高效液相色谱电感耦合等离子体质谱等在环境样品(水、土壤、沉积物)中痕量元素化学形态(价态、金属有机化合物等)分析中的应用,土壤和沉积物中污染元素的顺序提取步骤,以形态分析发展动态。引用文献72篇。     

DAS24-3B数据采集系统采集控制模块的工作原理

DAS24-3B是中国科学院地质与地球物理研究所研制的宽频带地震数据采集系统。采集控制模块是该系统的重要组成部分。本文阐述了控制模块的工作原理，介绍了DAS24-3B系统的基本组成和采集器工作过程，并给出该系统如何与笔记本端应用程序界面通讯和联络的操作建议，使该系统能够在工作中发挥更大的作用。     

在MapInfo中实现区域对象样点布设功能

随着GIS在森林资源管理中应用的不断深入，在GIS系统中实现林业专业抽样设计功能是非常必要的。本文使用MapBasic鳊程语言实现三种样点布设功能。操作时，用鼠标点击欲布样点区域，在弹出对话框中作出回答，就能得到样点布设图和样点坐标表。     

A Linear Programming Approach to Determine the Normative Composition of Sedimentary Rocks

The analysis of modal and normative composition of sedimentary rocks is widely used for studying their sources and tectonic settings. The normative calculation of the mineral composition of rocks in this study is formulated as a linear programming problem and is solved by means of the simplex method. This enables both simultaneous and successive subtraction of a set of basic minerals from a rock sample represented by its chemical composition {SiO₂...LOI}. Such an approach provides a more exact calculation of the contribution of basic minerals in the rock. This mathematical approach is used to study two representative sets of sandstones and fine-grained rocks from a Meso- to Neoproterozoic marginal basin of southeastern Siberia (Uchur–Maya region, Yakutia) and a Pennsylvanian-Lower Permian uplifted continental block in Colorado, USA. The calculated normative mineral compositions of the Siberian sandstones are consistent with the observed modal compositions. These sandstones vary from K- Feldspar rich arkoses at the base of the sequence (the Uchur Group, lower Riphean) to quartz arenites or lithic sandstones and wacke in transgressive successions of the middle-upper Riphean. Arkoses and quartz arenites are dominant in Meso- to Neoproterozoic Siberia. These samples represent craton interior uplifted basement and quartzose, recycled orogen provenance of a stable craton in Rodinia. There are higher but consistent discrepancies between the calculated and observed compositions for the Pennsylvanian to Lower-Permian arkoses and quartz arenites (Sangre de Cristo, Belden, and Maroon Formations). The differences between the predicted and observed mineralogy may be due to uncertainties in the modes in the matrix and cement of the sandstones. This normative program should supplement modal calculations and provide better genetic constructions, especially in case of matrix-rich sandstones.     

基于遗传算法的最优证券投资组合模型

为了研究能使风险损失率最小、收益最大的最优证券投资组合问题，首先提出了多目标规划模型，并采用模糊优选法将多目标模型单目标化。随后尝试采用遗传算法来对其求解，给出了模型的遗传算法编码规则和算法步骤。最后通过实例论证了模型的合理性及遗传算法的有效性。