摘要
介绍用哈代-克罗斯法进行管网水力平差计算在Excel软件中实现的方法,包括计算表格设计、计算公式建立、实际应用技巧等。利用Excel的数组公式实现不编程自动进行环状管网的平差计算。该方法具有与手算习惯相同,准备工作量少,计算简单、方便,又可以多次重复使用等特点。
A new method is recommended in the paper. It uses Excel for calculating water distribution networks by Hard-Cross method. It consists of designing the computing table, setting up the computing formulas, using skills in practice and so on. For unnecessary programming it realizes to calculate pipe networks by use of array formulas in Excel. This method has some characteristics. For example, it is much the same as common usual practice, preparing amount of work is few, computing is simple and convenient.
出处
《河南科学》
2003年第3期340-342,共3页
Henan Science
关键词
给水管网
水力平差
计算
水头损失
water networks computation
water distribution networks
Excel
