mfqd13
Mechanical
- Sep 27, 2007
- 99
Hi,
I have a Excel sheet wich calculates the insulation thickness, so that the surface temperature reaches, a user defined temperature, for example 40ºC, for safety reasons.
It happens 2 things that i consider quite strange:
1) What some people say is that as lower is the pipe diameter the less would be the insulation thickness, to reach the same surface temperature. Well, what i found is the opposite, as i insert bigger diameters, the insulation thickness increases very very much, even to stupid values...
We can see that also from the equations: as we increase the pipe diameter for the same insulation thickness, the LN(r2/r1) decreases and the heat transfer coeffecient increasesm, therefore the heat loss also increases.
I would like to see some comments.
2) i have a little macro wich uses the goal seek function, and it change increases the insulation thickness until the surface temperature lowers to the specified value: 40ºC. The problem is that excel finds a value wich represent a surface temperature value, not exact. The deviation error goes from 5 to 20%. This is very strange and is the 1st time that it happens to me. Manually, i have no problem to find the exact value. What maybe occuring?
Thanks
I have a Excel sheet wich calculates the insulation thickness, so that the surface temperature reaches, a user defined temperature, for example 40ºC, for safety reasons.
It happens 2 things that i consider quite strange:
1) What some people say is that as lower is the pipe diameter the less would be the insulation thickness, to reach the same surface temperature. Well, what i found is the opposite, as i insert bigger diameters, the insulation thickness increases very very much, even to stupid values...
We can see that also from the equations: as we increase the pipe diameter for the same insulation thickness, the LN(r2/r1) decreases and the heat transfer coeffecient increasesm, therefore the heat loss also increases.
I would like to see some comments.
2) i have a little macro wich uses the goal seek function, and it change increases the insulation thickness until the surface temperature lowers to the specified value: 40ºC. The problem is that excel finds a value wich represent a surface temperature value, not exact. The deviation error goes from 5 to 20%. This is very strange and is the 1st time that it happens to me. Manually, i have no problem to find the exact value. What maybe occuring?
Thanks