Heat Exchanger Simulation in Excel

[marcsant]

I wish to create a (simplified) heat exchanger simulation (rigorous mass & heat balance + some preliminary design) in Excel with help of PRODE library,
heating / cooling curves are calculated by solving a series of HPF() flash operations which I define as macros directly in Excel page,
so far I have completed the section to create a graph with two temperature profiles (hot and cold sides) and ten points on each side (10 different zones with constant dH),
now I am looking for some simple correlations to estimate heat transfer and pressure drop in different zones (main purpose is preliminary estimates),
on each zone I know state (liquid, liquid+vapor, vapor) phase fractions and properties (which are calculated by library),
Kern gives many different correlations as well as other sources so I am puzzled about which correlations to adopt,
could you help ?
(a reference to a site or some paper giving a limited set of correlitions for the different cases would be Ok)

 

[chemlite]

you have already completed mass & energy balance (multizone analysis),
but next step (identification of correlations for heat transfer / pressure drop in different sections) may not result easy to complete,
in addition to classics as Kern etc. I suggest "Heat Exchangers, selection, rating and thermal design" by Kakac and Liu

also you may find useful this (free)

http://web.mit.edu/lienhard/

http://www/ahtt.html

 

[apetri]

marcsant,
perhaps Prode can help,
they have software for heat exchengers design / rating and may be can suggest the procedure,
just my 2 cents...