基于Excel VBA的区域试验考种数据录入系统的设计与应用  

Design and Application of Agronomic Traits of Regional Trial Data Entry System Based on Excel VBA

作　　者：官晓敏 杨中路[1] 陈海峰[1] 邱德珍[1] 陈李淼[1] 张婵娟[1] 袁松丽 陈水莲[1] 张晓娟[1] 单志慧[1] 周新安[1] 

机构地区：[1]中国农业科学研究院油料作物研究所,武汉430062

出　　处：《农学学报》2016年第8期54-58,共5页Journal of Agriculture

基　　金：国家自然科学基金"大豆抗大豆花叶病毒病主效QTL的精细定位与候选基因发掘"(341014101002404)

摘　　要：为解决区域试验考种数据录入工作量大、易出错、重复计算多的问题,在Excel中建立固定数据区域,将固定数据区域划分为原始数据输入区和衍生数据计算区,结合Excel强大的公式计算功能将原始数据的计算自动化,并利用编码的Excel VBA程序自动完成对数据结果的保存、整理。以大豆考种数据为例介绍了该系统的设计与应用,固定数据区域作为数据处理的"模板",简化了大量重复操作。该系统简单易行,稳定高效,能大幅提高农作物品种区域试验工作效率,减轻劳动强度,降低错误率,具有一定的推广应用价值。In order to decrease the workload of regional trial data input,reduce the error rate and improve thework efficiency,a data entry system was established.Firstly,a fixed data input area was construct in Excel andthe input area was divided into the original data input area and the derived data computing area.Then thecomputerized original data calculation was completed through Excel＇s powerful function of formula.Finally,the preservation and processing of result data were accomplished by Excel VBA program.Using the fixed dataarea as a template to process data could simplify repetitive operations.Soybean agronomic character data wastaken for an example to evaluate the system.The results indicated that the system was simple,stable andefficient,and could greatly improve work efficiency,reduce labor intensity as well as error rate,and had acertain value of popularization and application.

关 键 词：区域试验 考种数据 EXCEL VBA 数据录入系统 

分 类 号：S565.1[农业科学—作物学]