Enhancing chemical analysis with signal derivatization using simple available software packages

Derivative techniques for analytical signal processing are useful for solving some noise and signal resolution problems in various fields of study such as titrimetry, spectrophotometry, chromatography and electrochemistry. The broad use of these techniques, however, is often limited by costly inflexible built-in software packages in commercial analytical instruments. We propose here the application of commercial simple software packages such as Microsoft® Excel and Microcal Origin for signal smoothing and fitting, and for obtaining derivative analytical signals in batch and flow-based analyses, including potentiometric titration, spectrophotometry, chromatography, voltammetry and sequential injection analysis (SIA). The worldwide (especially Excel) software packages are easy-to-use for less experienced users and have also capabilities for advanced users, and therefore employing such packages can result in expansion of useful derivative techniques. We demonstrate application of the available package-aided derivative capabilities for enhancing some chemical analyses, including potentiometric acid–base titration, Bradford assay of protein, chromatographic separation of ajmaline and reserpine and anodic stripping voltammetry of copper. The derivative signals from smoothed and fitted curves offer better accuracy and precision, even for non-resolving peaks and tailing peaks. In some cases, the optimization of experimental conditions is not further required, which can lead to fast method development.     

Determination of uncertainty for hardness measurement: proposal of the standard,available software

After the next revision of the ISO-standards for hardness testing (ISO 6506–6508) an estimation of the uncertainty (ISO/IEC 17025, ISO 5725) is mandatory. The two proposed approaches of part one (ISO 6506–6508) of the ISO Standards for hardness are exemplified. The calculation approach implemented in an Excel-based file, which is available via , is announced.Presented at the Metro Trade Workshop on Traceability and Measurement Uncertainty in Testing, 30–31 January 2003, Berlin, Germany     

Excel在线性回归法测量不确定度评定中的应用

介绍了如何使用Excel电子表格进行线性回归法求得测量结果的不确定度评定,可方便地获得任一测量结果的扩展不确定度。     

改进力法计算的研究

针对传统力法的缺点, 利用VBA进行了Excel电子表格的编制, 对传统力法 进行了改进. 在保持传统力法的基本原理和计算过程的基础上, 解决了力法计算繁琐的问题, 提高了计算速度和学习效率, 增强了结构力学课程与实际的联系, 对工科课程的教学具有一 定的指导意义.     

密立根油滴实验数据处理系统设计

用VB6．0设计了密立根油滴数据处理系统,通过VB内部程序操纵Excel应用程序,运用ActiveX技术调用Excel,解决实验数据计算量大,计算过程繁琐复杂的问题,从而提高了实验效率。     

基于Excel实现物理实验数据的管理和分析

以半导体材料导电特性实验为例,介绍Excel辅助管理物理实验数据和分析处理数据的方法,以及该方法在大学物理实验教学中的应用．     

基于Excel的分析化学实验课程成绩评价系统构建与应用

借助Excel的自编公式、IF函数和跨工作表求和功能构建了分析化学实验课程成绩评价系统,研究了分析化学实验课程成绩评价系统的影响指标和指标权重,并运用该系统对学生课程成绩进行了评价,效果良好。     

Excel 在水质监测数据处理中的应用

应用Excel制作专用模板,用于环境监测数据汇总、分析和上报,既能提高报表数据的准确性和可靠性,又能减轻监测分析人员的劳动．     

打造自己的回归计算器

通过调用Excel内部函数,轻松构造出自己的回归计算器,快速获得回归方程。方法直观方便,可以极大的提高工作效率。     

Matlab软件在三线摆法测定圆环转动惯量中的应用

使用三线摆可以测量圆环的转动惯量,但测量的物理量较多,人工处理数据比较繁琐,且容易出错。因此,本文使用Matlab软件处理数据。把测量的实验数据输入Excel表格中,引入Matlab软件中运行相关程序后可以直接得到圆环的转动惯量,以及测量的百分差和相对不确定度,处理过程快捷精确。