StructuresDan
Structural
- Aug 13, 2009
- 18
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
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
