有许多商用软件程序可帮助工程师进行压降计算、管道尺寸确定等。这些程序需要学习新程序的输入和输出，才能获得有用的输出。电子表格程序是大多数办公效率软件包中的基本应用程序，因此大多数工程师已经很熟悉了。本文的目的不是提供一个特定系统模型的案例研究，而是为工程师提供一种方法，用他或她已经熟悉的软件解决循环系统问题。本文介绍了压力损失计算表的制作，其中包含自动提取管道直径和管件k数据的公式- 因素。还讨论了绘制泵曲线、系统曲线和变速泵曲线的技术。引用:ASHRAE论文CD:2014 ASHRAE冬季会议，纽约

There are many commercially available software programs to assist the engineer in pressure drop calculations, pipe sizing, etc. These programs require learning the ins and outs of a new program before useful output can be obtained. Spreadsheet programs are basic applications in most office productivity software packages and are thus familiar to most engineers already. The goal of this paper is not to provide a case study of a particular system model, but to provide a methodology for an engineer to solve Hydronic system problems with software which he or she is already familiar. This paper covers the production of a pressure loss calculation table with formulae that automatically extract data for pipe diameters and fitting k-factors. Techniques for developing pump curves, system curves, and variable speed pump curves are also discussed.