Green Engineering Spreadsheets: Section-2 Dust and Pollution Collection
John Andrew, P.E.
This 4 PDH online course defines the basic: equipment, applications, and design equations of industrial dust and pollution collection equipment including: fans, cyclone collectors, bag houses, and electrostatic precipitators.
Industrial dust collection applications include: Blasting – Carpet Manufacturing - Chemical Processing - Fiber Glass - Laser Cutting - Mining - Paper Manufacturing - Pharmaceutical - Rubber Grinding - Seed Processes - Solar Panel Fabrication - Thermal/Flame Spray - Welding - Woodworking.
Dust and pollution collection system parameters are analyzed using Excel spreadsheets.
This course is Section-2 of several, “Green Engineering” courses including: G321 Insulation, M237 Heat Transfer Excel Calculations, M236 Steam & Combustion Power Cycles Spreadsheet.
1. Industrial Fans
2. Cyclone Collectors
3. Bag House Collectors
4. Electrostatic precipitators
5. Conversion Factors
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: facility managers, energy & environmental managers, industrial process engineers, mechanical engineers, and industrial plant managers, and all those involved with green engineering.
Benefit to Attendees
Attendee of this course will be able to calculate and optimize variables in a useful range of dust and pollution collection projects. Some advantages of spreadsheet calculations over hand written include:
1. easier to read.
2. better recall from archives.
3. greater accuracy.
4. faster with repeat use.
5. graphs are created automatically.
6. numerous useful formulas.
7. "Goal Seek" enables optimization.
8. solve any equation with, "Solver".
9. solve sets of linear and non-linear equations.
10. calculations and graphs may be pasted into documents and slide show presentations.
Excel and other spread sheets are used to calculate and optimize dust collection equipment parameters.
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 these documents are lost or are difficult to read. It becomes more difficult to use these documents to make improvements to existing designs. Spread sheets can be stored indefinitely and accessed electronically.
You are required to study the Excel Spreadsheet Green Engineering Spreadsheets: Section 2 - Dust and Pollution Collection This is the only study materials for this course.
The link to the Excel Spreadsheet is:
Green Engineering Spreadsheets: Section 2 - Dust and Pollution Collection (a zipped file, 890K, please download and upzip before opening the file)
You need to download above Excel Spreadsheet to study this course.
This course provides Excel spread sheets to calculate a range of basic dust collection 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 or web pages:
PDHonline Courses at http://www.pdhonline.com/
G321 Green Engineering Spreadsheets: Section-1 Insulation,
M237 Heat Transfer Excel Calculations
M236 Steam & Combustion Power Cycles Spreadsheet