https://www.udemy.com/course/heat-exchangers-design-calculation-excel-workbook/

Design and analyze the performance of your heat exchanger in a professional manner with this valuable Excel Workbook

What you'll learn: 

Design and analyze the performance of your heat exchanger in a professional manner with this valuable Excel Workbook

Select the appropriate shell and tube heat exchanger for your application

Get access to valuable shell and tube heat exchanger design tables according to DIN 21184 - 21191 and TEMA std to properly design shell and tube heat exchangers

Get access to useful charts and diagrams to solve daily heat exchanger problems

Requirements:

Having Microsoft Excel installed on your computer and having basic knowledge of using Excel

Having attended our "Heat Exchangers : Design, Operation and Maintenance" training course is strongly recommended

Having attended our "Flow of Fluids Through Piping Systems, Valves, Fittings and Pumps" training course is strongly recommended

Description:

This Heat Exchanger Excel Workbook provides well organized technical data in form of spreadsheet calculations, tables, charts and diagrams, indispensible for anyone involved in the design, selection, operation, maintenance or inspection of heat exchangers.

This Excel workbook presents formulae and data for :

Physical properties of the most common fluids used in heat exchangers in Oil & Gas, Petroleum, Refining and Chemical processes

Heat transfer coefficients "U" and "α"

Pressure losses in shell and tube heat exchangers (tube + shell sides)

Useful shell and tube geometrical calculations

Geometrical data of shell and tube heat exchangers according to DIN 28184 & 28191 and TEMA Standards

Guidelines for the selection of shell and tube heat exchangers

Thermal conductivity of the most common material of construction of shell and tube heat exchangers

Valuable heat exchanger charts, figures and diagrams

Numerous conversion tables

And much more...

Please refer to the table of content hereafter for further details.

IMPORTANT NOTES

We assume that Microsoft Excel is installed on your computer and that you have basic knowledge of using Excel

This Excel workbook includes Visual Basic for Application function subroutines. Macros must be enabled for them to work

DISCLAIMER

This Heat Exchanger Excel Workbook is provided by WR Training "as is" and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall the Copyright owner or contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services, loss of use, data, or profits, or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this Excel Workbook, even if advised of the possibility of such damage.

---------------------------------------------------------------------------------------------------------------------------

HEAT EXCHANGER DESIGN AND CALCULATION EXCEL WORKBOOK : TABLE OF CONTENT

An Excel VBA based engineering tool by WR Training

I/ SPREADSHEET CALCULATIONS

A. Physical properties of fluids

1. Properties of water and steam

a. saturation properties with temperature

b. saturation properties with pressure

c. properties given pressure and temperature

d. properties given pressure and enthalpy

2. Dynamic viscosity of gases

3. Kinematic viscosity

4. Weight density of liquids

formula 1

formula 2

formula 3

5. Weight density of ideal gases

6. Weight density of real gases

7. Gas compressibility factor

8. Specific gravity of gases

9. Boiling point pure component

10. Vapor pressure : pure component

11. Vapor pressure : mixture

12. Thermal conductivity of water

13. Thermal conductivity of liquids

14. Thermal conductivity of gases

15. Fouling factors of water

16. Fouling factors of other fluids

17. Specific and molar heat capacities of fluids

B. Overall heat transfer coefficient

1. Approximate overall heat transfer coefficient

2. Overall heat transfer coefficients "uα" from heat transfer coefficients "α"

3. Overall heat transfer coefficients from refinery process data

liquid hydrocarbons coolers

gaseous hydrocarbons coolers

total hydrocarbons condensers

4. Overall heat transfer coefficients from general formula

C. Heat transfer coefficients (α)

1. Approximate heat transfer coefficients

2. Tube side heat transfer coefficients as a function of the flow velocity

3. Shell side heat transfer coefficients as a function of the flow velocity

4. Tube side heat transfer coefficient

5. Shell side heat transfer coefficient

D. Heat calculations

1. Heat load

2. Heat exchange area

formula 1

formula 2

3. Corrected effective temperature difference

4. Corrected effective mean temperature difference

formula 1

formula 2

formula 3

5. Temperature efficiency factor

6. Outlet temperature of the cold fluid

7. Outlet temperature of the hot fluid

E. Pressure losses in shell & tube heat exchangers

1. Tube side pressure loss

tubes ∆P

inlet nozzle ∆P

outlet nozzle ∆P

2. Tube side pressure loss

baffle window ∆P

shell tube ∆P

nozzles ∆P

F. Useful geometrical calculations

1. Tube side

flow cross section

flow velocity in the tubes

number of tubes per pass

2. Tube side pressure loss

flow cross section

cross stream velocity through the tube bundle

longitudinal stream cross area in the baffle window

longitudinal stream velocity through the baffle window

average shell side flow cross section

average shell side flow velocity

number of baffles

number of tube rows in cross stream between the baffle windows

number of total vertical tube rows

flow cross section for the longitudinal flow in the baffle window

diametric shell to baffle clearance

G. Geometrical data of shell & tube heat exchangers according to din 28184 - 28191 and tema standards

H. shell and tube exchanger selection guide

I. dimensionless numbers

J. thermal conductivity of heat exchanger metal of construction

II/ CHARTS AND DIAGRAMS

a. Tema heat exchanger table

b. AES exchanger nomenclature

c. AEP exchanger nomenclature

d. AJW exchanger nomenclature

e. AKT exchanger nomenclature

f. BEM exchanger nomenclature

g. CFU exchanger nomenclature

h. Heat exchanger design procedure

i. Heat exchanger selection guidelines

j. Tube patterns

k. Baffles

l. LMTD

m. TEMA data sheet for shell & tube heat exchangers

n. Comparison of TEMA class R, C and B heat exchangers

o. Shell and tube exchanger features according to type of design

p. Conversion tables

NOTE

This Excel workbook includes Visual Basic for Application function subroutines. Macros must be enabled for them to work.

DISCLAIMER

This Heat Exchanger Excel Workbook is provided by WR Training "as is" and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall the Copyright owner or contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services, loss of use, data, or profits, or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this Excel Workbook, even if advised of the possibility of such damage.Who this course is for:This Heat Exchanger Excel Workbook is suitable to a wide range of technical professionals but will greatly benefit :Process, Chemical and Design EngineersOperation, Technical Service and Maintenance ProfessionalsPlant OperatorsEngineers, Consultants and Sales professionalsTechnical professionals responsible for heat transfer equipment inspectionTechnical professionals responsible for interdisciplinary energy projects

Who this course is for:

This Heat Exchanger Excel Workbook is suitable to a wide range of technical professionals but will greatly benefit :

Process, Chemical and Design Engineers

Operation, Technical Service and Maintenance Professionals

Plant Operators

Engineers, Consultants and Sales professionals

Technical professionals responsible for heat transfer equipment inspection

Technical professionals responsible for interdisciplinary energy projects