基于Excel的遗传算法在大学生数学建模中的应用  

Application of Excel-Based Genetic Algorithm in Mathematical Modeling of College Students

作　　者：颜清[1] 苗壮[1] 徐调斌 蒋昌猛 赖鑫生[1] YAN Qing;MIAO Zhuang;XU Tiaobin;JIANG Changmeng;LAI Xinsheng(School of Mathematics and Computer Science,Shangrao Normal University,Shangrao Jiangxi 334001,China)

机构地区：[1]上饶师范学院数学与计算机科学学院,江西上饶334001

出　　处：《上饶师范学院学报》2020年第3期18-24,共7页Journal of Shangrao Normal University

基　　金：江西省教育厅科技计划资助项目(GJJ15063);国家自然科学基金项目(61562071)。

摘　　要：利用Excel表格功能、函数功能及混合编程技术,使嵌入在Excel中的遗传算法优化过程中的实时动态数据及其仿真图表形象、直观,实现了遗传算法优化过程的可视化,为大学生数学建模的教学与指导提供了崭新的解决方案。大学生通过在Excel中实现遗传算法优化过程的仿真,加深了对算法优化过程的感性认识,加强了对算法中遗传算子的理解,使大学生能在一段较短时间内掌握遗传算法的应用来解决数学建模中的优化命题,并能直接利用Excel实现遗传算法的VBA优化仿真及其混合编程来解决数学建模中的各种优化问题,也为解决数学建模中优化命题提供了崭新的解决方案。Using the Excel form function,function function and VBA mixed programming,the VBA simulation of the genetic algorithm is realized.The real-time dynamic data of the algorithm process is obtained directly in the Excel.At the same time,the simulation chart and the result of the algorithm process are obtained.It provides a new solution to solve the optimization proposition in the teaching of mathematical modeling for college students.The hybrid programming and teaching in VBA simulation by genetic algorithm enhances the perceptual knowledge of the algorithm,deepens the understanding of the process of the implementation of the algorithm,and helps the college students to use the VBA simulation of genetic algorithm to solve the optimization problems in the mathematical modeling.It provides a new solution for solving the optimization proposition in mathematical modeling.

关 键 词：遗传算法 VBA优化仿真 可视化 动态数据 数学建模 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]