Print this page Process Pumps, Valves, & Pipe Spreadsheet Analysis
John Andrew, P.E.
Course Outline
Step-by-step illustrated examples show how to use the spread sheet tools to optimize piping system designs. This course is divided into 7 sections:
1. Pump Performance Calculations
2. Process Piping Pressure Head Loss
3. Pump and Piping System Graphs
4. Free Vendor Piping System Software
5. Pressure Drop Calculator
6. Link to Pipe Sizing Spreadsheet Based on First Costs and Future Energy Costs
7. Schedule 40 Steel Pipe Dimensions
The course includes
a multiple-choice quiz at the end, which is designed to enhance the understanding
of the course materials.
Learning Objective
This course uses Excel spreadsheets to:
- document engineering calculations in Excel, Open Office or other spreadsheets;
- optimize the design of process piping systems;
- calculate Reynolds number and determine whether flow is laminar or turbulent;
- Calculate the friction factor based on Reynolds number and pipe roughness;
- select pump type based on “Specific Speed”;
- determine pump driver motor power;
- calculate common units with the spreadsheet;
- tabulate temperature, density, and viscosity of water;
- total pressure drops through pipe fittings and valves;
- use the Moody diagram to determine the pipe flow friction factor;
- Use “Goal Seek” to solve the Darcy Weisbach pipe pressure loss formula; and
- Create a piping system pressure curve and optimize pump performance.
Intended Audience
The information will be especially useful to: students, process engineers, and innovators who want to a convenient method for designing: industrial, commercial, and domestic piping systems. A useful spreadsheet for cross-over engineers from other disciplines.
Benefit to Attendees
Attendee of this course will have live spread sheets for calculating piping system pressure curves and optimizing pump performance.
Course Introduction
This set of spread sheets contain numerous useful processes piping formulas that are calculated automatically based on the users input data.
Course Content
You need to download and study the following spreadsheet:
Process Pumps, Valves, & Pipe Spreadsheet Analysis
DISCLAMER: "This spreadsheet is provided for illustrative teaching purpose only, and is not intended for use in any specific project. Anyone making use of theinformation contained in this spreadsheet does so at his/her own risk and assumes any and all resulting liability arising therefrom."
The calculations within this live spreadsheet will facilitate the initial design and engineering of many types of process piping systems. When various factors are typed into the Input cells, Excel will calculate results automatically. In addition, the powerful tool, "Goal Seek" can be used to optimize each design Calculation.
Course Summary
A brief and to the point summary is provided in these lesson notes and Excel spreadsheets that will provide information that can be used to optimize the design of process piping systems.
Related Links
Taylor Engineering – Publications
http://www.taylor-engineering.com/publications/design_guides.shtml
Quiz
Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.
DISCLAIMER: The materials contained in the online course are not intended as a representation or warranty on the part of PDH Center or any other person/organization named herein. The materials are for general information only. They are not a substitute for competent professional advice. Application of this information to a specific project should be reviewed by a registered architect and/or professional engineer/surveyor. Anyone making use of the information set forth herein does so at their own risk and assumes any and all resulting liability arising therefrom.
