| 基于Excel的化学计算方法 |
| |
| 引用本文： | 冯积社,张万生,胡浩斌.基于Excel的化学计算方法[J].化学通报,2006,69(11):865-868. |
| |
| 作者姓名： | 冯积社 张万生 胡浩斌 |
| |
| 作者单位： | 陇东学院数学系化学系 甘肃庆阳745000 |
| |
| 摘 要： | 对化学计算中遇到的求解方程或方程组的复杂计算问题,利用Excel提供的数值计算和绘制函数图像的功能,通过单变量求解和规划求解能使问题得到圆满解决。与其它软件比较,该方法对初值的选择和计算过程中迭代方法的选择、迭代次数、精度、误差等都可以进行自由设置,更能体现出门槛低、简单、快捷的特点。
|
| 关 键 词： | Excel 计算方法 单变量求解 规划求解 |
| 收稿时间： | 2006-04-24 |
| 修稿时间： | 2006-04-242006-07-20 |
The Calculation Method in Chemistry Based on Excel |
| |
| Feng Jishe,Zhuang Wansheng,Hu Haobin.The Calculation Method in Chemistry Based on Excel[J].Chemistry,2006,69(11):865-868. |
| |
| Authors: | Feng Jishe Zhuang Wansheng Hu Haobin |
| |
| Institution: | Mathematic Department, ~ Chemistry Department, Longdong University, Qingyang 745000 |
| |
| Abstract: | For the complicated calculation of find-roots in chemistry, the functions of excel are utilized for calculation. The graphs of functions can be drawn quickly and easily by using two menu-selections, goal seek and programming. In comparison with other software, it's illustrated that this method is easier and quieter. |
| |
| Keywords: | Excel Calculation method Goal seek Programming |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
