Excel函数用于解决水文流量计算中尾数取舍问题的简单方法

Study on the simple method of Excel function to solve the problem of mantissa option in the calculation of hydrological flow

为提高水文站实测流量计算的工作效率,研究拟采用Excel软件对实测流量进行计算。对于采用Excel软件进行流量计算过程中遇到的尾数取舍问题,考虑采用Excel函数进行解决。经过研究,仅仅使用了3个Excel函数就成功地解决了流量计算过程中遇到的尾数取舍问题,使流量计算过程中的尾数取舍结果均符合水文规范的要求。从而大大地简化了实测流量的计算过程,节约了实测流量计算时间。该方法简单易学,便于推广,从而能提高水文流量测验的工作效率。

In order to improve the calculation efficiency of the measured flow of hydrological stations,the Excel software was used to calculate the measured discharge.It's considered to use Excel function to solve the mantissa option problem encountered in the process of flow calculation using Excel software.After the study,only using 3 Excel functions could successfully solve the mantissa option problem in the flow calculation,and the results were all in accordance with the requirements of the hydrological norms.Thus,the calculation process of measured flow was greatly simplified,and the computation time of measured flow was saved.This method is simple to learn and easy to popularize,so as to improve the efficiency of hydrological discharge test.