Heat Exchangers Design & Calculation Excel Workbook
Heat Exchangers Design & Calculation Excel Workbook, available at $29.99, has an average rating of 3.5, with 9 lectures, based on 50 reviews, and has 498 subscribers.
You will learn about 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 This course is ideal for individuals who are This Heat Exchanger Excel Workbook is suitable to a wide range of technical professionals but will greatly benefit : or Process, Chemical and Design Engineers or Operation, Technical Service and Maintenance Professionals or Plant Operators or Engineers, Consultants and Sales professionals or Technical professionals responsible for heat transfer equipment inspection or Technical professionals responsible for interdisciplinary energy projects It is particularly useful for This Heat Exchanger Excel Workbook is suitable to a wide range of technical professionals but will greatly benefit : or Process, Chemical and Design Engineers or Operation, Technical Service and Maintenance Professionals or Plant Operators or Engineers, Consultants and Sales professionals or Technical professionals responsible for heat transfer equipment inspection or Technical professionals responsible for interdisciplinary energy projects.
Enroll now: Heat Exchangers Design & Calculation Excel Workbook
Summary
Title: Heat Exchangers Design & Calculation Excel Workbook
Price: $29.99
Average Rating: 3.5
Number of Lectures: 9
Number of Published Lectures: 9
Number of Curriculum Items: 9
Number of Published Curriculum Objects: 9
Original Price: $29.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- 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
Target Audiences
- 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
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.
Course Curriculum
Chapter 1: About this Heat Exchanger Excel Workbook
Lecture 1: Overview the Heat Exchanger Excel Workbook
Lecture 2: Instructions to the Heat Exchanger Excel Workbook
Chapter 2: Heat Exchangers : Design, Operation and Maintenance – Online course
Lecture 1: Heat Exchangers : Design, Operation and Maintenance
Chapter 3: Other valuables Excel Workbooks and Folders
Lecture 1: The Flow of Fluids Excel Workbook
Lecture 2: Centrifugal Compressor Excel Workbook
Lecture 3: The Chemical Engineer's Reference Folder
Lecture 4: The Chemical Engineer's Reference Folder – Folder overview
Chapter 4: Downloadable resources
Lecture 1: Downloadable resources
Lecture 2: Bonus
Instructors
-
WR Training
Petroleum Petrochemical & Chemical Engineering
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 5 votes
- 3 stars: 9 votes
- 4 stars: 13 votes
- 5 stars: 21 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024