Asee peer logo

A Spreadsheet Program For The Calculation Of Piping Systems And The Selection Of Pumps

Download Paper |


2000 Annual Conference


St. Louis, Missouri

Publication Date

June 18, 2000

Start Date

June 18, 2000

End Date

June 21, 2000



Page Count


Page Numbers

5.58.1 - 5.58.12



Permanent URL

Download Count


Request a correction

Paper Authors

author page

Craig W. Somerton

Download Paper |

NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Session 1633

A Spreadsheet Program for the Calculation of Piping Systems and the Selection of Pumps

Craig W. Somerton Department of Mechanical Engineering, Michigan State University

I. Introduction

An important topic taught in most energy related mechanical engineering courses, such as thermal design or HVAC, are piping system calculations coupled with the required pump calculations, so as to appropriately select a pump. To facilitate this instruction, an Excel workbook program, Pump_Pipe.xls, has been developed that will perform flow system calculations and pump selection analysis. The spreadsheet performs both the piping system calculations and the pump selection analysis. After a brief review of basic pump analysis and piping system analysis, this paper continues with a description of the spreadsheet. The spreadsheet is then demonstrated with a very simple flow system. Two design problems are then worked with the program. One problem deals with a large water system (part of the California State Water System), while the other problem looks at pump selection for automotive oil cooling system. Results of these problems show both the utility of the spreadsheet, as well as its shortcomings. The paper concludes with comments and recommendations.

II. Background

The basis for the pump analysis utilized in the spreadsheet is the use of the dimensionless pump parameters defined below:

& V Discharge Coefficient: CQ = (1) N D3 ∆P Head Coefficient: CH = (2) ρN 2 D 2 & Wideal Isentropic Efficiency ηs = (3) & Wactual

where N is the pump speed and D is the pump rotor diameter.

It has been seen that by using these dimensionless groupings a single set of relationships may be developed for most axial flow pumps and a second set for most centrifugal pumps (see [1]). Shelby [2] has developed a set of operating equations for these two types of pumps,

Somerton, C. W. (2000, June), A Spreadsheet Program For The Calculation Of Piping Systems And The Selection Of Pumps Paper presented at 2000 Annual Conference, St. Louis, Missouri. 10.18260/1-2--8706

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2000 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015