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

PDF(3033 KB)
PDF(3033 KB)
Journal of Agriculture ›› 2016, Vol. 6 ›› Issue (8) : 54-58. DOI: 10.11923/j.issn.2095-4050.cjas16030020

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

Author information +
History +

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.

Key words

Regional Trial; Agronomic Character Data; Excel VBA; Data Entry System

Cite this article

Download Citations
Design and Application of Agronomic Traits of Regional Trial Data Entry System Based on Excel VBA. Journal of Agriculture. 2016, 6(8): 54-58 https://doi.org/10.11923/j.issn.2095-4050.cjas16030020

References

[1]王洁,廖琴,胡小军,等.北方稻区国家水稻品种区域试验精确度分析[J].作物学报,2010,36(11):1870-1876.
[2]张斯梅,杨四军,顾克军,等.小麦区域试验产量性状及其稳定性分析[J]. 中国农学通报,2012,28(3):172-176.
[3] 许乃银,张国伟,李健,等.基于HA-GGE 双标图的长江流域棉花区域试验环境评价[J].作物学报,2012,38(12):2229-2236.
[4]吴存祥,李继存,沙爱华,等.国家大豆品种区域试验对照品种的生育期组归属[J].作物学报,2012,38(11):1977-1987.
[5]许乃银,金石桥,李健.我国棉花品种区域试验重复次数和试点数量的设计[J].作物学报, 2016,42(1):43-50.
[6]徐淑霞,李振贵,张光.大豆区试产量与主要农艺性状的灰色关联度分析[J].大豆科技,2012,28(1):28-30.
[7]曹婧华, 冉彦中, 郭金城.玉米考种系统的设计与实现[J].长春师范学院学报(自然科学版),2011,30(8):38-41.
[8]孔凡洲, 于仁成, 徐子钧,等.应用Excel软件计算生物多样性指数[J].海洋科学,2012,36(04):57-62
[9]张梅,陈玉光,李韦禄,等.基于Microsoft Excel 统计函数的农业气象预报模型研究[J].中国农学通报,2014,30(2):309-313.
[10]霍世清,张静,冯岗.EXCEL在裂区试验统计分析中的应用[J].中国农学通报,2011,27(30):159-163.
[11]刘霞,路永贵,闫当萍.EXCEL在农药毒力测定中的应用[J].中国农学通报,2009,25(19):206-208.
[12]许乃银,李健. 棉花区试总结中“品种评述”批量生成系统的构建与应用[J].中国棉花,2014,41(6):17~20.
[13]鲍祥生,梁兵,周海燕,等.VBA和EXCEL函数结合编程在数据处理中的应用*[J].石油工业计算机应用,2009,64(04):9-12
[14]朱培育,朱佳苗,赵俊香,等.EXCEL VBA数据处理软件开发[J].地震地磁观察与研究,2006,27(8):108-115.
[15]郝才超,薛霆虓. EXCEL VBA 批量处理在录井砂地比统计中的应用[J].工程地球物理学报, 2012,145(6):1672-7940.
[16]陈海生,彭峰,刘玉国.Excel VBA在医院基本药物数据统计中的应用[J].中国现代应用药学,2015,32(12):1494-1498
[17]杨振宇,杨海智,杨信东.用EXCEL中的VBA编写“质量性状遗传分析”相关程序及其在农业上的应用[J].吉林农业大学学报, 2012,34(6):692-696.
[18]桂嘉伟.基于EXCEL VBA的审计自动抽样系统设计与应用研究[J].中国管理信息化,2015,18(21):53-56.
[19]袁文华.用EXCEL VBA建立差旅费审核系统[J].中国管理信息化,2015,18(01):42-44.
[20]陈伟,王维,邹燕飞.浅谈EXCEL 20110重复数据的处理方法[J].电脑知识与技术,2015,11(22):128-129.
Share on Mendeley
PDF(3033 KB)

Accesses

Citation

Detail

Sections
Recommended

/