矩形渡槽水力计算的 Excel 求解

摘要

The hydraulic calculation of rectangle aqueduct was related to developing the bottom slope and width,and calculating the normal depth,so its analysis process was complex,and its calculation quantity was overmuch. The Excel software is used to the above analysis and cal-culation. Through writing the spreadsheet program and using IF( )function,we can result this question effectively because the desult what we want could be calculated in a short time. At last,the calculation quality is reducted,and the design efficiency is improved.%针对矩形渡槽水力计算涉及到槽身底坡和底宽的拟定、正常水深计算等问题，分析过程复杂，计算量较大的现象，将常用的Excel软件应用于矩形渡槽的水力计算，通过编制试算、IF（）语句等计算程序，实现了矩形渡槽水力计算的快速求解，减小了计算量，提高了设计效率。