Excel在水利工程闸孔尺寸计算中的应用

Application of Excel in the Calculation of Sluice Hole Size

针对闸孔尺寸设计工作计算量大的问题,将Microsoft Excel软件应用于该项工作。主要利用软件的相对引用、绝对引用、IF()函数等常规计算功能,可快速确定闸孔尺寸。通过计算机编程,实现了闸孔尺寸的快速运算。

According to the problem of large calculation in designing the sluice hole size,Microsoft Excel was applied in the work.The sluice hole size would be solved quickly by using the relative references,absolute reference and the IF（）function mainly.Through computer programming,fast calculation of sluice hole size was achieved.