|
|||||
|
|
| Excel函数在农业气象测墒工作中的巧用 | |
| 引用本文： | 胡顺起,丰晓君,周茂山,李炳文.Excel函数在农业气象测墒工作中的巧用[J].安徽农业科学,2010,38(2):837-839,845. |
| 作者姓名： | 胡顺起 丰晓君 周茂山 李炳文 |
| 作者单位： | 1. 山东省临沂市气象局,山东临沂,276004 2. 中国气象局气象探测中心,北京,100081 3. 山东省莒南县气象局,山东莒南,276600 |
| 摘 要： | 利用Excel提供的四则运算函数编写程序完成农业气象测墒中对土壤样本数据的基本计算，用逻辑函数编写程序实现对土壤湿度持水量的查表计算工作，最终只需输入湿土＋盒重和烘干后干土＋盒重2组数据就能得到需要的含水量、干土重、土壤含水量、土壤持水量等多组数据。 |
| 关 键 词： | Excel 农业气象测墒 逻辑函数 土壤湿度持水量 IF语句 |
Application Skills of Excel Functions in Agricultural Meteorology Measured Quantity |
|
| HU Shun-qi et al.Application Skills of Excel Functions in Agricultural Meteorology Measured Quantity[J].Journal of Anhui Agricultural Sciences,2010,38(2):837-839,845. | |
| Authors: | HU Shun-qi |
| Institution: | Junan Weather Bureau in Shandong Province;Junan;Shandong 276600 |
| Abstract: | The four computing functions provided by Excel were used to compile program to complete the basic calculation of soil sample data in the agro-meteorological measuring moisture.The look-up table exercise of soil moisture holding capacity was realized by using the logic function compiling program.Finally,many sets of data(moisture demand,dry soil weight,soil moisture content,soil water holding capacity) could be obtained only after entering two sets of data(wet soil + Box weight) and(dry soil after drying + w... |
| Keywords: | Excel Agro-meteorological measuring moisture Logic function Soil moisture holding capacity IF statement |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |