Excel VBA数组法在玉米自交系测配试验列表设计中的应用  

The Application of Excel VBA Array in the Design of Matching Test List for Maize Inbred Lines

作　　者：宋英博[1] 王囡囡[1] 张洪权[1] 樊伟民[1] 李于[1] 孟凡祥[1] 李灿东[1] 陈庆山[2] SONG Yingbo;WANG Nannan;ZHANG Hongquan;FAN Weimin;LI Yu;MENG Fanxiang;LI Candong;CHEN Qingshan(Jiamusi Branch of Heilongjiang Academy of Agricultural Sciences,Jiamusi,Heilongjiang 154007;College of Agriculture,Northeast Agricultural University,Harbin 150030)

机构地区：[1]黑龙江省农业科学院佳木斯分院,黑龙江佳木斯154007 [2]东北农业大学农学院,哈尔滨150030

出　　处：《中国农学通报》2022年第32期106-110,共5页Chinese Agricultural Science Bulletin

基　　金：黑龙江省农业科学院院级科研项目“欧洲硬粒型玉米种质评价及创新利用”(2019YYYF015);黑龙江省农业科学院院级科研项目“三江平原玉米最优施肥模型的研究与应用”(2020YYYF049);农业科技创新跨越工程玉米科技创新“高配合力、多抗、优质玉米育种素材创制与新品种选育”(HNK2019CX03)。

摘　　要：玉米自交系测配试验核心是配合力的测定,如何在测配试验列表设计中将数量庞大的被测系及测验种等数据迅速录入计算机,并快速编辑形成田间试验列表是每位育种者需要思考的问题。本研究利用VBA技术提出一种玉米自交系测配试验设计编码方法,可以实现数据快速录入计算机,并应用VBA技术优化繁琐的操作和过多的重复步骤,避免了人为操作误差,实现自动化,从而提高工作效率。结果表明,与常规Excel基础方法相比较,VBA方法具有操作简单易学,准确性更高,用时更快的优点。随着被测系规模的扩大,VBA方法优势更加明显。通过VBA方法编程调度,可简化大量的手工操作步骤,建议在玉米自交系测配试验设计中推广使用。The core of maize inbred line matching test is the determination of combining ability.How to input a huge amount of data of inbred lines and testers into the computer quickly in the design of test list,and how to edit the data to form a list of the field trials quickly need to be considered by every breeder.In this study,a coding method for matching test of maize inbred lines was proposed by using VBA technology,to realize quick data input,optimize the tedious operation with repeated steps and avoid human operation errors,thus achieving automation and high working efficiency.The results show that,compared with the conventional basic Excel method,VBA method is simple to operate and easy to learn,with higher accuracy and speed.With the expansion of the scale of the inbred lines,the advantages of VBA method has become more obvious.By using the VBA method programming scheduling,a large number of manual operation steps could be simplified.It is suggested that VBA method should be popularized in the design of maize inbred line matching test.

关 键 词：VBA数组 玉米 自交系测配试验 程序 

分 类 号：S158.3[农业科学—土壤学]