John Andrew, P.E.

Course Outline

This 4 PDH hour online course defines the design equations of several basic heat transfer systems resulting in Excel print-outs of design parameters and calculated results. The use of existing energy-efficiency technologies, such as insulation, is fundamental to successful sustainable development, as regards both the production and consumption of energy.

This course is Section-1 of several, “Green Engineering” courses including: M237 Heat Transfer Excel Calculations, M236 Steam & Combustion Power Cycles Spreadsheet.

Topics include:

1. Applications
2. Conduction
3. Convection
4. Pipe and Tanks
5. Conversion Factors
6. Math Tools

The course includes a multiple-choice quiz at the end, which is designed to enhance the understanding of the course materials.

Learning Objective

At the conclusion of this course the student will:

• Have a spread sheet useful for heat transfer calculations;
• Use the, “3E Plus® Insulation” free computer program;
• Calculate the thermal performance of both insulated and un-insulated piping, ducts, tanks, and equipment;
• Translate Btu losses into actual dollars;
• Calculate greenhouse gas emission and reductions;
• Adjust heat energy parameters to meet design specifications;
• Document design calculations in a spread sheet format;
• Convert common metric and U.S. units;
• List useful material thermal conductivities;
• Calculate convective heat transfer coefficients from measured temperatures;
• Compute theoretical convective heat transfer coefficients;
• Compute combined convective and conductive heat transfers;
• Be able to employ Excel's “Goal Seek” tool to optimize designs; and

Intended Audience

The information will be especially useful to: facility managers, energy & environmental managers, industrial process engineers, mechanical engineers, and industrial plant managers, this spreadsheet and “3E Plus® Insulation” computer program are valuable tools for determining the return on investment of an insulation upgrade on: pipes, ducts, tanks, and boilers.

Benefit to Attendees

Attendee of this course will be able to calculate and optimize variables in a useful range of heat transfer and insulation projects.

Course Introduction

Excel and other spread sheets are used to calculate and optimize heat transfer 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.

Course Content

You are required to study the Excel Spreadsheet Green Engineer Spreadsheets  Section-1 Insulation. This is the only study materials for this course. The link to the Excel Spreadsheet is:

Course Summary

This course provides Excel spread sheets to calculate a range of basic heat transfer 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.