欢迎访问《农学学报》,

农学学报 ›› 2016, Vol. 6 ›› Issue (8): 54-58.doi: 10.11923/j.issn.2095-4050.cjas16030020

• 农业信息 农业气象 • 上一篇    下一篇

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

官晓敏,杨中路,周新安   

  1. 中国农业科学研究院油料作物研究所,中国农业科学研究院油料作物研究所,中国农业科学研究院油料作物研究所
  • 收稿日期:2016-03-23 修回日期:2016-06-12 接受日期:2016-06-20 出版日期:2016-08-23 发布日期:2016-08-23
  • 通讯作者: 周新安 E-mail:guximihubei@163.com
  • 基金资助:
    国家自然科学基金“大豆抗大豆花叶病毒病主效QTL的精细定位与候选基因发掘”(341014101002404)。

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

  • Received:2016-03-23 Revised:2016-06-12 Accepted:2016-06-20 Online:2016-08-23 Published:2016-08-23

摘要: 为解决区域试验考种数据录入工作量大、易出错、重复计算多的问题,建立了本系统。(方法)在Excel中建立固定数据区域,将固定数据区域划分为原始数据输入区和衍生数据计算区,结合Excel强大的公式计算功能将原始数据的计算自动化,并利用编码的Excel VBA程序自动完成对数据结果的保存、整理。固定数据区域作为数据处理的“模板”,简化了大量重复操作。(结果)基于Excel VBA编制了区域试验考种数据录入系统,并以大豆考种数据为例介绍了该系统的设计与应用。(结论)该系统简单易行,稳定高效,能大幅提高农作物品种区域试验工作效率,减轻劳动强度,降低错误率,具有一定的推广应用价值。

关键词: 酰基辅酶A结合蛋白, 酰基辅酶A结合蛋白, 植物, 第四类ACBP, 进化

Abstract: In order to decrease the workload of regional trial data inputing, reduce the error rate and improve the work efficiency, we established the data entry system. (method) Firstly, we construct a fixed data inputing area in Excel that is divided into the original data inputing area and the derived data computing area, then complete the computerized original data calculation through Excel’s powerful function of formula, finally, accomplish the preservation and processing of result data quickly by Excel VBA program. Using the fixed data area as a template to process data can simplify a large number of repetitive operations. (result) An accurate and efficient agronomic traits data entry and sorting system was established based on Excel VBA, in addition, descripting the design and application of the system in this paper, taking soybean agronomic traits data for example. (conclusion)The system is simple, stable and efficient, which can greatly improve the work efficiency, reduce the labor intensity as well as error rate and has a certain value of popularization an application.