农田节水灌溉工程和人畜饮水工程中的供水管网结构复杂 ,干管、支管、毛管分支众多 ,管网经济管径、管道沿程水头损失等数据的计算任务繁重 ,费时费力 ,且易出差错。在这种情况下 ,笔者利用EXCEL电子表格软件提供的计算功能 ,实现了水利工程管网设计中经济管径和管道沿程水头损 The water supply network in farmland water-saving irrigation project, drinking water project for people and livestock has complex structure, many branches such as trunk pipe, branch pipe, capillary branch, pipe network economic pipe diameter and head loss of pipelines are heavy, time-consuming and laborious, error. In this case, I use EXCEL spreadsheet software to provide computing capabilities to achieve the water pipeline network design economic pipe diameter and pipe along the head loss