| 用EXCEL中的VBA编写“多项式的三角函数拟合单峰曲线”程序 |
| |
| 引用本文： | 马海霞,刘影,王艳红,杨信东.用EXCEL中的VBA编写“多项式的三角函数拟合单峰曲线”程序[J].菌物研究,2009,7(3):195-200. |
| |
| 作者姓名： | 马海霞 刘影 王艳红 杨信东 |
| |
| 作者单位： | [1]吉林农业大学农学院,长春130118 [2]吉林省农业科学院植保所,公主岭136100 |
| |
| 摘 要： | Excel是常用的电子表格处理软件，笔者采用基于Excel的VBA编程方法，编写了“多项式的三角函数拟合单峰曲线”程序，经教学科研工作中使用，获得了理想的效果。文中发表了该程序的源代码及使用方法，供广大科教人员下载使用。
|
| 关 键 词： | Excel VBA编程 多项式的三角函数 单峰曲线 |
Writing the Program of Fitting Single Peak Curve of Polynomial Trigonometric-Function by Using VBA on EXCEL |
| |
| MA Hai-xia,LIU Ying,WANG Yan-hong,YANG Xin-dong.Writing the Program of Fitting Single Peak Curve of Polynomial Trigonometric-Function by Using VBA on EXCEL[J].Journal of Fungal Research,2009,7(3):195-200. |
| |
| Authors: | MA Hai-xia LIU Ying WANG Yan-hong YANG Xin-dong |
| |
| Institution: | 1. College of Agronomy, Jilin Agricultural University, Changchun 130118, China ; 2. Institute of Plant Protection, Jilin Academy of Agricultural Sciences, Gongzhuling 136100, China ) |
| |
| Abstract: | Excel is a common electronic form processing software. Using VBA programming method based on Excel, we wrote the program for calculation of fitting single peak curve of polynomial trigonometric function. Its applied effect was proved to be perfect in teaching and research. The article published the procedure source code and application method of program for the general scientific and educational personnel to use. |
| |
| Keywords: | Excel |
| 本文献已被 维普 万方数据 等数据库收录！ |
