Excel link宏在数据分析中的应用

详细地讲解Excellink宏的建立、使用方法及宏函数用法 ,连接MicrosoftExcel和MATLAB的步骤及在Excel中应用MATLAB的方法 ,极大地增强了Excel处理数据的能力和图形输出的能力 ,并用两个实例验证了这个Excellink宏在数据分析过程中所显示的优越性。     

用Excel求解线性规划及线性方程组的方法

对利用美国微软公司开发的Office组件中的电子表格软件Excel求解线性规划的方法给予了介绍 ,并将该功能给予扩充 ,给出了用该软件求解线性方程组的方法     

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具有强大的数据处理功能，这使它在开发有些信息管理系统时比其它开发平台更加容易．以盐城师范学院综合素质测评系统开发为例，介绍了Excel开发信息管理系统的全过程．     

基于ASP技术的研究生网上调剂系统的实现

针对五邑大学研究生招生调剂工作的现状,叙述了建立研究生网上调剂系统的必要性,提出了基于ASP技术的调剂系统实现方案.该系统应用于实际,加快了调剂信息的收集和处理速度,节省了大量的人力和财力.     

Auto CAD实用技巧

本文详细介绍了如何把AutoCAD绘制的图形插入到Word文档;如何把Excel制作的表格插入到AutoCAD图形中,并转换成AutoCAD图元以及对象选择的几种方式。     

不编程实现管网水力平差的方法

介绍用哈代-克罗斯法进行管网水力平差计算在Excel软件中实现的方法,包括计算表格设计、计算公式建立、实际应用技巧等。利用Excel的数组公式实现不编程自动进行环状管网的平差计算。该方法具有与手算习惯相同,准备工作量少,计算简单、方便,又可以多次重复使用等特点。     

浅析在VB中调用Excel

由于Excel的应用程序对象是外部可创建对象,所以可用VB应用程序来操作Excel.本文分析了VB调用Excel的理论依据、主要方法和操作技巧;结合在VB6.0应用程序中调用Excel报表的实例,讨论了如何把它们有机地结合在一起,较好地发挥其功能.     

利用DDE技术实现不同应用之间的数据交换

阐述了如何利用DDE(dynamic data exchange)技术把显示于数据窗口的数据库中的数据自动传递到Excel电子表格中，以便灵活地操纵数据．把Excel作为DDE服务器，提供了一种在用PowerBuilder 8．0开发的应用程序中导出、打印表格类数据的方法，实现了不同应用程序之间数据交换．