Print this page Fluid Power Cylinders and Motors Spreadsheet Analysis
John Andrew, P.E.
Course Outline
Step-by-step illustrated examples show how to use the spread sheet tools to optimize air and hydraulic cylinder and motor system designs. This course is divided into 8 sections:
1. Goal Seek Optimisation
2. Fluid Power Calculations-US Units
3. Fluid Power Calculations-Metric Units
4. Air Cylinder Applications
5. Hydraulic Cylinder Applications
6. Air and Hydraulic Valve Applications
7. Piston Rod Cylinders and Power Supplies
8. Basic Hydraulic Circuits
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 define and calculate:
- the design of air and hydraulic cylinder systems;
- pump or motor power;
- power of hydraulic fluid flowing through pipe;
- hydraulic cylinder piston speed;
- pipe or tubing burst pressure;
- hydraulic fluid velocity in pipe;
- heat equivalent of fluid power;
- power radiating capacity of a reservoir;
- recommended hydraulic fluid velocities in pipe;
- convert common fluid power units;
- typical air cylinder applications;
- typical air schematic diagram;
- typical hydraulic cylinder applications;
- typical hydraulic schematic diagrams;
- regenerative circuit flow rate, power, and force;
- use “Goal Seek” to optimize calculations; and
- document engineering calculations in Excel spreadsheets.
Intended Audience
The information will be especially useful to: students, process engineers, and innovators who want to a convenient method for engineering the design of industrial fluid power 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 the performance of fluid power systems.
Course Introduction
This set of spread sheets contain numerous useful fluid power formulas that are calculated automatically based on the users input data.
Course Content
You need to download and study the following spreadsheet:
Fluid Power Cylinders and Motors 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 industrial fluid power systems.
Related Links
For additional technical information related to this subject, please visit the following websites:
The United States Patent and Trademark Office Home Page at www.uspto.gov
Provides links to information about all aspects pertaining to invention patents.
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.
