Pneumatic Conveying Spreadsheet
John Andrew, P.E.
This 2 PDH Professional Development Hour course includes a series of input data and solved output equations in an Excel format. The student will type numerical parameters and Excel will perform the calculations.
Results calculated in an Excel spreadsheet cell may be adjusted to a, “What If” value using, “Goal Seek”.
The course includes
a multiple-choice quiz at the end, which is designed to enhance the understanding
of the course materials.
At the conclusion of this course the student will:
The information will be especially useful to: students, engineers, and innovators who need tools for creative pneumatic conveyor engineering calculations.
Benefit to Attendees
Attendee of this course will be able to calculate and optimize variables in a useful range pneumatic conveyor engineering projects.
Some advantages of spreadsheet calculations over hand written include:
Excel spread sheets are used in this course to calculate and optimize pneumatic conveyor parameters. Spread sheets can be stored indefinitely and accessed electronically. Optimizing design values with spreadsheets is very convenient and is often more accurate than hand calculations.
Previously calculations have been done with a calculator and written by hand with pen or pencil. Optimizing design values with a calculator is difficult and time consuming. Quite often it is impossible to read and check these documents. As time passes sometime these documents are lost or are difficult to read.
It becomes difficult to use these hand written often illegible documents to make improvements to existing designs. Spread sheets can be accessed quickly.
AIR CONDITIONING AND PSYCHROMETRICS
Pneumatic conveyor calculations determine equipment capacity necessary to meet client requirements.
If the sizing is wrong problems such as saltation and choking prevent bulk material flow.
The goal of the pneumatic conveyor processes is to provide sufficient pick-up air flow velocity for optimal performance.
You need to download and study the following spreadsheet:
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.
This course provides Excel spread sheets to calculate a range of basic pneumatic conveyor parameters. All variables can be adjusted to optimize design goals. Excel print-outs of design parameters and calculated results provide easy to read documentation for checking and future improvements.
For additional technical information related to this subject, please visit the following websites:
Fuller Bulk Handling http://www.petropages.com/fuller-bulk-handling.html
Engineering Toolbox http://www.engineeringtoolbox.com/minor-loss-air-ducts-fittings-d_208.html
Excel tutorials can be found at: www.dslimited.biz/excel_tutorials.html
Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.