extending the boundary of spreadsheet programming: lessons learned from chinese governmental projects

ICSE

ON THE SIGNIFICANCE OF WAVELENGTH POSITIONING ACCURACY IN MULTICOMPONENT ANALYSIS TECHNIQUES FOR THE CORRECTION OF LINE INTERFERENCES IN INDUCTIVELY COUPLED PLASMA ATOMIC EMISSION-SPECTROMETRY

The present paper reports some definite evidence for the significance of wavelength positioning accuracy in multicomponent analysis techniques for the correction of line interferences in inductively coupled plasma atomic emission spectrometry (ICP-AES). Using scanning spectrometers commercially available today, a large relative error, DELTA(A) may occur in the estimated analyte concentration, owing to wavelength positioning errors, unless a procedure for data processing can eliminate the problem of optical instability. The emphasis is on the effect of the positioning error (deltalambda) in a model scan, which is evaluated theoretically and determined experimentally. A quantitative relation between DELTA(A) and deltalambda, the peak distance, and the effective widths of the analysis and interfering lines is established under the assumption of Gaussian line profiles. The agreement between calculated and experimental DELTA(A) is also illustrated. The DELTA(A) originating from deltalambda is independent of the net analyte/interferent signal ratio; this contrasts with the situation for the positioning error (dlambda) in a sample scan, where DELTA(A) decreases with an increase in the ratio. Compared with dlambda, the effect of deltalambda is generally less significant.

The characteristics of BSRs and their derived heat flow on the profile 973 in the northeastern South China Sea

Processing of a recently acquired seismic line in the northeastern South China Sea by Project 973 has been conducted to study the character and the distribution of gas hydrate Bottom-Simulating Reflectors (BSRs) in the Hengchun ridge. Analysis of different-type seismic profiles shows that the distribution of BSRs can be revealed to some extents by single-channel profile in this area, but seismic data processing plays an important role to resolve the full distribution of BSRs in this area. BSR' s in the northeastern South China Sea have the typical characteristics of BSRs on worldwide continental margins: they cross sediment bed reflections, they are generally parallel to the seafloor and the associated reflections have strong amplitude and a negative polarity. The characteristics of BSRs in this area are obvious and the BSRs indicate the occurrence of gas hydrate-bearing sediments in the northeastern South China Sea. The depth of the base of the gas-hydrate stability zone was calculated using the phase stability boundary curve of methane hydrate and gas hydrate with mixture gas composition and compared with the observed BSR depth. If a single gradient geothermal curve is used for the calculation, the base of the stability zone for methane hydrate or gas hydrate with a gas mixture composition does not correspond to the depth of the BSRs observed along the whole seismic profile. The geothermal gradient therefore changes significantly along the profile. The geothermal gradient and heat flow were estimated from the BSR data and the calculations show that the geothermal gradient and heat flow decrease from west to east, with the increase of the distance from the trench and the decrease of the distance to the island arc. The calculated 2 heat flow changes from 28 to 64 mW/m(2), which is basically consistent with the measured heat flow in southwestern offshore Taiwan.

海洋重力资料预处理软件的编制及应用

首先应用Visual Basic 6.0计算机语言，根据我们所熟知的海洋重力数据的处理步骤和海洋重力测量规范内容，开发出一套海洋重力资料整理软件，以便能使资料整理工作成为一体化，提高工作效率，保证数据处理的准确性。应用该软件对南海某工区的实际重力资料进行了处理，得到了满意的处理结果，证明该软件使用方便，计算准确可靠，能够快速准确的处理采集到的重力数据。对数据处理结果进行了分析和应用。 通过分析Eötvös校正值与重力仪读数之间的变化关系，可以对重力仪的动态性能进行分析和评价。得到2级海况条件下重力仪的实际阻尼延迟时间约为60s，比厂方推荐的理论值（110s）更接近实际，有助于减小数据处理过程中的定位误差，提高测量精确度。通过对重力仪的灵敏性进行分析，验证重力仪在测量过程中的准确性和可靠性，为获得精确的数据提供可靠的保障。 对该套规则重力测网数据，分别采用60s阻尼延迟时间和110s阻尼延迟时间进行阻尼延迟校正，然后进行交点差计算和平差处理，得到的结果显示：采用60s阻尼延迟时间对数据进行阻尼延迟校正后得到的测量精度为1.40mGal，经过平差后的测量精度为0.77mGal；而采用110s阻尼延迟时间对数据进行阻尼延迟校正后得到的测量精度为1.62mGal，经过平差后的测量精度为0.96mGal。此结果验证了利用船只机动转向法确定海洋重力仪的实际阻尼延迟时间的必要性和应用价值。 最后，对宋文尧等人的平差方法和刘保华等人的最小二乘平差方法进行了分析比较，从推导原理和计算结果两方面证明了两种方法在规则海洋重力测网平差作用上是等效的。对于不规则重力测网平差，最小二乘平差方法具有强大的优势，且计算机程序运算实现方便。

电机转速自适应测量方法及其在DSP上的实现

本文在分析几种常用的基于编码器测速方法的基础上,提出了一种高性能的自适应速度测量方法。该方法选择一个可变的时间周期和编码器脉冲数来测量单位时间内的编码器脉冲数,再通过简单的计算得到转速的测量值。数字信号处理器(DSP)芯片集成有正交脉冲编码电路,并且数据处理速度快,实时性强。本文中提出的方法在电机控制专用DSP芯片TMS320 LF2407A上进行了实现。实验研究表明,可以在提高低速时的测速准确度的同时,提高系统的响应时间。该方法已经在自主研发的全数字伺服驱动系统中得到了成功应用。