×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Shell and tube heat exchanger - tube length

Shell and tube heat exchanger - tube length

Shell and tube heat exchanger - tube length

(OP)
Hi all,

I know it's a bit of a long shot but I thought I would ask.

I am coding up the initial sizing procedure described in section 3.1.4 of Hewitt's Heat Exchanger Design Handbook, "Approximate Sizing of Shell and Tube Heat Exchangers" in an Excel spreadsheet.

I've come to the point where I need to select the range of shell internal diameters and tube lengths for a given outside tube heat transfer area from Figure 2 (also contained in lots of other references I have found).

Rather than let my customer look up these values from the chart themselves I'd like to have my spreadsheet do it automatically hence I would need the data tables that these curves are based on or equations which have been fitted to the data.  I'm sure that this has been done many times in the past and wanted to try and find a reference for this information before I went down the route of reading the data points and fitting some curves myself.

Can anyone help me out with this?

Many thanks

Dan  

RE: Shell and tube heat exchanger - tube length

you don't know how to do a linear regression in excel?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources