NONLINEAR CURVE-FITTING USING MICROSOFT EXCEL SOLVER
NONLINEAR CURVE-FITTING USING MICROSOFT EXCEL SOLVER
复制标题
DOI：
10.1016/0039-9140(95)01446-i
复制
发表时间：
1995-04-01
期刊：
影响因子：
6.1
通讯作者：
DIAMOND, D
中科院分区：
文献类型：
--
作者：
WALSH, S;DIAMOND, D
Solver是Microsoft Excel V5.0 for Windows中集成的分析工具，已用于求解非线性方程。对测试和实验数据集进行了处理，结果表明，SOLVER可以成功地用于模拟在许多分析情况下获得的数据(例如，色谱峰和FIA峰、荧光衰变和ISE响应特性)。相对简单的用户界面，以及Excel通常免费与新PC捆绑在一起的事实，使其成为那些希望尝试求解非线性方程而无需购买和学习全新软件包的人的理想工具。迭代搜索过程的动态显示使用户能够通过搜索算法监视最优解的位置。这一点，再加上Excel几乎无处不在的可用性，使Solver成为教授迭代非线性曲线拟合技术原理的理想工具。此外，建模过程的完全控制取决于用户，用户必须提供原始数据并输入模型的方程，这与许多商业软件包捆绑在一起的仪器不同，这些仪器使用“黑箱”方法执行这些操作。
Solver, an analysis tool incorporated into Microsoft Excel V 5.0 for Windows, has been evaluated for solving non-linear equations. Test and experimental data sets have been processed, and the results suggest that solver can be successfully used for modelling data obtained in many analytical situations (e.g. chromatography and FIA peaks, fluorescence decays and ISE response characteristics). The relatively simple user interface, and the fact that Excel is commonly bundled free with new PCs makes it an ideal tool for those wishing to experiment with solving non-linear equations without having to purchase and learn a completely new package. The dynamic display of the iterative search process enables the user to monitor location of the optimum solution by the search algorithm. This, together with the almost universal availability of Excel, makes solver an ideal vehicle for teaching the principles of iterative non-linear curve fitting techniques. In addition, complete control of the modelling process lies with the user, who must present the raw data and enter the equation of the model, in contrast to many commercial packages bundled with instruments which perform these operations with a 'black-box' approach.