CAJ | 학술논문

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