欢迎访问《农学学报》,

农学学报 ›› 2016, Vol. 6 ›› Issue (12): 47-55.doi: 10.11923/j.issn.2095-4050.cjas16090019

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

利用Excel编制育种数据清单

郭莉,马现斌,李有明   

  1. 襄阳市农业科学院,襄阳市农业科学院,襄阳市农业科学院
  • 收稿日期:2016-09-30 修回日期:2016-11-16 接受日期:2016-11-25 出版日期:2016-12-27 发布日期:2016-12-27
  • 通讯作者: 李有明 E-mail:842792335@qq.com
  • 基金资助:

Processing Breeding Data Listings in Excel

  • Received:2016-09-30 Revised:2016-11-16 Accepted:2016-11-25 Online:2016-12-27 Published:2016-12-27

摘要: 编制育种数据清单是育种的前提准备工作。文中分享了使用电子表格Microsoft Excel编制育种数据清单的几个小技巧。Excel中“if”、“ vlookup”、“rand”、“=”、“ &”、“$”等函数及符号,以及一些菜单命令的巧用,可以快速、准确地得到育种数据清单。

关键词: 森林蔬菜, 森林蔬菜, 开发利用价值, 层次分析法, 大盘山

Abstract: Processing breeding data listings was the precondition of breeding. Currently, Microsoft Excel was mainly and widely used to process breeding data listings. In this article, a few tips were shared by using Microsoft Excel to process breeding data listings. In excel, opportunely using some of the menu commands, functions and symbols, such as "if", "vlookup", "rand", "=", "&", "$" and so on, the breeding data listing with detailed information could be quickly and accurately obtained. As processing breeding data listings in excel, the use of some functions and commands that could help to solve the continuity and correlation of breeding data listings should be especially noticed, in order to solve the problems of processing breeding data listings.

中图分类号: