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

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

深切怀念我们的导师-李连捷院士

李连捷院士是杰出的土壤地理学家、我国土壤学的创始人之一，也是土壤地质学派的创史人。他有关土壤发生的地学基础背景的正确而鲜明的学术思想引导着土壤地理和土壤资源的研究、土地资源开发和研究生培养工作。他一方面不断学习国际上在这方面的学术发展动向及前沿；另一方面紧密结合中国发展的生产实际。他在20世纪50-60年代以综合考察，70年代以后以扎根基点的形式发展土壤科学、培养研究生。他一生刚正不阿、高风亮节，实为一代宗师。     

Probability Density Functions as Botanical-Climatological Transfer Functions for Climate Reconstruction

We present a new procedure, the pdf method (pdf=probability density function), for reconstructing Quaternary climate utilizing botanical data. The procedure includes the advantages of the indicator species method by considering the fossil and modern presence and absence of taxa rather than their frequencies, thus avoiding the need for modern analog plant communities. Overcoming the problematic use of absolute limits to describe climate response ranges is the main progress of the pdf method in comparison to the indicator species method. This advantage results from estimating probability density functions (pdfs) for monthly mean January and July temperature conditional on the present day occurrence of single taxa. Gaussian distributions sufficiently approximate pdfs of many, although not all, studied taxa. On the assumption of statistical independence, the procedure calculates a joint pdf as the product of the pdfs of the individual taxa. This algorithm weights each taxon according to the extent of its climate response range expressed by its covariance structure. We interpret the maximum of the resulting pdf as the most likely climate and its confidence interval as the uncertainty range. To avoid an artificial reduction of uncertainty arising from the use of numerous similar pdfs, a preselection method is proposed based on the Mahalanobis distance between pdfs. The pdf method was applied to the Carpinus phase of a profile from Gröbern, Germany, that spans the last interglaciation (Eemian). The reconstructed most probable January and July temperatures of about 0.0°C and 18.4°C barely differ from the modern values of −0.5°C and 18.3°C.     

新疆宏观生态的空间分异与变化

根据新疆环境和生态特点，将新疆划分为14个二级生态区进行了研究。结果表明，新疆荒漠与非荒漠生态景观面积大致相当，但空间分异较大。新疆北部荒漠景观占全区域的约1／3，非荒漠景观占2／3，宏观生态相对稳定；新疆东部荒漠景观占全区域的2／3以上，宏观生态十分严峻；新疆南部荒漠景观占全区域的1／2，宏观生态稳定性差。沙漠、绿洲、水体三种主要景观类型中，北疆阿尔泰山南坡、伊犁盆地及南疆叶尔羌－喀什河三角洲地区沙漠化呈降低趋势；天山北坡各段及准噶尔盆地西部，20世纪90年代以来沙漠化明显减缓；新疆东部及南部其余各地区沙漠化均呈现增强趋势。新疆水体景观的变化表现为天然和人工水体面积的消长。近50年来，新疆修建的水库和坑塘等人工水体总面积与同期天然水体缩小的面积基本相当，表明新疆水体景观再近50年来的变化主要体现为水体的空间位移。绿洲景观的变化表明，北疆地区天然绿洲与人工绿洲面积的比例已经从50年代的5：1以上下降到约1：1，南疆由6：1以上下降到3：1左右。天然绿洲的减少是绿洲生态局部劣变的标志。研究还表明，新疆宏观生态的空间分异主要受自然因素的影响，其中，区域降水量的影响最为重要。     

A STUDY OF CLOUD-SYSTEM MODEL:MACRO AND MICRO STRUCTURE SIMULATION OF CLOUD FIELD*

The macro and micro cloud physics structures and their evolution with time are the core of describing cloud fields in essence.They are necessary atmospheric environment not only in aviation and spaceflight activities but also for atmospheric radiation transfer and acid rain formation research.Unfortunately it is difficult to obtain an entire environmental cloud field by using observation methods directly.Thus,by use of computation physics method to build a cloud-systemmodel may be an indispensable way for this topic.This paper presented a cloud-system model for this goal,and simulated a real case.The results of computation showed that the macro structure of the cloud field was better consistent with real observation,and the micro structure was fairly reasonable.The output of model could provide all the information about the cloud field:(1)size-distribution spectrum of hydrometeor particles(point),(2)vertical profile(line),(3)horizontal or vertical section of macro and micro parameters(surface),and(4)cloud cover,pattern of cloud and configuration of cloud,etc.(body).     

A non‐baseline algorithm for damage locating in flexural structures using dynamic distributed macro‐strain responses

The concept of distributed strain‐sensing techniques has been proposed in our recent research, which was dedicated to utilizing the strain distributions throughout the full or partial areas of structures to detect arbitrary and unforeseen damage. An algorithm not requiring a detailed analytical model is presented for damage locating in flexural structures through the direct use of dynamic responses recorded by distributed long‐gauge strain sensors. The modal macro‐strain vector (MMSV), which has been proven to have a mapping relation with displacement mode shape, can be extracted directly from macro‐strain time‐series data, from which a damage evaluating index can be derived and used as an indicator for locating damage. Numerical examples are simulated to verify the sensitivity and effectiveness of the index in different cases. Furthermore, experimental investigations on a cantilevered beam with various long‐gauge fibre optic sensors placements are carried out to examine the feasibility and applicability of the proposed method. Copyright © 2007 John Wiley & Sons, Ltd.     

基于旅游开发的宏观环境因子系统分析

本文试图在建立旅游开发环境分析的框架对和旅游环境系统分层的基础上,采聚系统整体观来综合探讨外部宏观环境因子对旅游开发的独立或综合影响以及各因子之间的相互关系,旨在拓宽旅游研究人员以及旅游开发和管理人员的思路,并提供一种综合全面认识旅游环境的分析方法。     

安徽省地震宏观异常日报集成系统

安徽省地震宏观异常日报集成系统是由Android的App、MySQL数据库和PHP网站组合而成的应用管理系统。从设计思路、框架及主要技术实现出发,介绍集成系统的应用成效。     

山东沿海降雨云系宏观特征及人工增雨潜力的估算

针对山东省飞机人工增雨作业的实际情况，分析了山东沿海地区的降雨特征，统计了沿海云层的宏观物理量，分析了莱州湾、黄海北部和东南沿海３个地区云与降水的关系，对主要降雨天气系统计算了降雨效率及增潜力，增雨潜力在４２．５５％－６８．７９％。通过对天气系统中水汽垂直分布的分析，为飞机在山东沿海地区增雨作业最佳催化层次的选择提供了信。     

地震立体层析成像的实现方法及效果分析

立体层析成像是一种新的地震反射波层析成像方法,能为叠前深度偏移提供较为精确的宏观速度模型。本文研究了立体层析成像的实现方法,包括斜率与走时数据的拾取、离散速度模型构建和初始化、射线参数的确定、斜率和走时及射线计算以及反演问题解法等,建立立体层析成像的算法流程。并通过对Marmousi模型试验,对立体层析成像运行所需的主要参数,如初始速度模型、拾取数据量、离散网格尺寸、速度平滑权重等进行测试和分析,总结这些不同参数对立体层析反演结果的影响规律,用以指导生产实践。