[1]李 伟,李 弘,彭学成.Excel 函数用于解决水文流量计算中尾数取舍问题的简单方法[J].江苏水利,2018,(08):59-62.
　LI Wei,LI Hong,PENG Xuecheng.Study on the simple method of Excel function to solve the problem of mantissa option in the calculation of hydrological flow[J].JIANGSU WATER RESOURCES,2018,(08):59-62.
点击复制

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

《江苏水利》[ISSN:1006-6977/CN:61-1281/TN]

卷:
期数:
2018年08期
页码:
59-62
栏目:
水利信息化
出版日期:
2018-08-15

文章信息/Info

Title:
Study on the simple method of Excel function to solve the problem of mantissa option in the calculation of hydrological flow
文章编号:
1007-783（92018）08-0059-04
作者:
李 伟; 李 弘; 彭学成
四川省成都水文水资源勘测局，四川 成都 611130
Author(s):
LI Wei; LI Hong; PENG Xuecheng
Chengdu Hydrology and Water Resources Investigation Bureau of Sichuan Province，Chengdu 611130，Sichuan
关键词:
流量计算; Excel 函数; 尾数取舍
Keywords:
flow calculation; Excel function; mantissa option
分类号:
P333
文献标志码:
B
摘要:
为提高水文站实测流量计算的工作效率，研究拟采用Excel 软件对实测流量进行计算。对于采用Excel 软件进行流量计算过程中遇到的尾数取舍问题，考虑采用Excel 函数进行解决。经过研究，仅仅使用了3 个Excel 函数就成功地解决了流量计算过程中遇到的尾数取舍问题，使流量计算过程中的尾数取舍结果均符合水文规范的要求。从而大大地简化了实测流量的计算过程，节约了实测流量计算时间。该方法简单易学，便于推广，从而能提高水文流量测验的工作效率。
Abstract:
In order to improve the calculation efficiency of the measuredf low of hydrological stations, the Excel software was used to calculate the measured discharge.I'ts considered to use Excel function to solve the mantissa option problem encountered in the process of flow caluclation using Excel software.After the study, only using 3 Excel functions could successfully solve the mantsisa option problem in the flow calculation, and the results were all in accordance with the requirements o fthe hydrological norms.Thus, the calculation process of measured flow was greatly simplified, and the compuattion time of measured flow was saved.This method is simple to learn and easy to popularize, so as to imopvre the efficiency of hydrological discharge test.

参考文献/References:

[1] GB/T 8170-2008，数值修约规则与极限数值的表示和判定[S].
[2] SL 247-2012，水文资料整编规范[S].
[3] 王作鹏.Excel 2003从入门到精通[M].北京：人民邮电出版社，2013.02.
[4] 微软.在Excel中浮点运算可能会给出不准确的结果[EB/OL].https://support.microsoft.com/zh-cn/help/78113/floating-point-arithmetic-may-give-inaccurate-resultsin-excel#%2Fzh-cn%2Fkb%2F78113.

备注/Memo

备注/Memo:
收稿日期：2018-03-16
作者简介：李伟（1982—），男，工程师，硕士，主要从事水文水资源和水土保持研究工作。
更新日期/Last Update: 2018-08-15