gator1991,
The calculation I use is one of my many Excel applications, but no it is not currently available from my website. Sorry but it took way too much time and effort to simply give away.
I am concerned that many of the recent postings are distracting readers from finding a realistic solution to the original problem. The temperature change along the 80 foot length is negligible so simply ignore it. This heat transfer case is, like most real world HT calcs, complicated enough without introducing an additional dimension that is not needed for a solution.
Using typical HT coefficients from texts is useful but often leads to incorrect assumptions about the real world. Look back at my numbers and see that 88% of the heat transfer is via radiation. There is little to be gained from chasing down details of convection coefficients and LMTDs.
This case involves several layers of HT all acting in series and parallel at the same time;
> forced convection in the water flowing in the pipe
> conduction through an inside film layer
> conduction through the pipe wall
> conduction through an external film layer
> natural convection in the air outside the pipe
> radiation transfer between the outer pipe wall and the surroundings
The two keys to solving the HT are 1) determining the HT properties of the various fluids and materials involved and 2) finding the inside and outside surfaces of the pipe. The second of these is the most important and the most difficult.
My application includes a library of environment, materials and fluid properties (temperature sensitive in many cases) as well as a library of convection formulas for both the inner surface and outer surface of the pipe (which provide the Nusselt No values). What the application does is to set up a series of simultaneous equations for the various heat transfer modes and then solves them iteratively by adjusting the surface temperatures until all of the energy flows balance.
The heart of the calculation is the general formula for calculating the thermal resistance of the various layers involved in a pipe.
R = 1/U = 1/(2.Pi.Ri.(hci + hri))+ln(Ro/Ri)/(2.Pi.kio)+1/(2.Pi.Ro.(hco + hro))
U = Overall HT Coefficient
Ri = inside radius
hci = inside convection ceofficient
hri = internal radiation coefficient (= 0)
kio = thermal conductivity of pipe wall
With the application running I can set up and solve simple cases like this one in about 20 minutes and then spend some time checking the sensitivty of the result to various changes in conditions (e.g. wind velocity, surface coefficients, solar radiation levels). For cases where the fluid in pipe temperature changes significantly I simply re-run the calculation for the conditions further along the pipe.
If I had the time I would write out each of the equations used but that may need to wait until retirement?
The point is that this HT case can be reliably solved with an appropriate effort while the simple approach of using typical textbook values can lead to significant errors and a misunderstanding of what is really happening. While many textbooks address the theory I find Incropera and De Witt the most useful.
Sorry to be so long winded but as you can tell I had some real world cases, including personnel safety, to find solutions to and had to go the hard yards on this subject.
Dennis Kirk Engineering