Excel函数在农业气象测墒工作中的巧用

Application Skills of Excel Functions in Agricultural Meteorology Measured Quantity

利用Excel提供的四则运算函数编写程序完成农业气象测墒中对土壤样本数据的基本计算,用逻辑函数编写程序实现对土壤湿度持水量的查表计算工作,最终只需输入湿土+盒重和烘干后干土+盒重2组数据就能得到需要的含水量、干土重、土壤含水量、土壤持水量等多组数据。

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 ＋ weight of boxes）.