Heat transfer situation, Mechanical Engineering

Assignment Help:

The aim of this project is for you to discover how to use a spreadsheet to "model" a typical engineering problem, in this case a heat transfer situation. And to discover how this model can be used to solve problems that would otherwise require lengthy analytical or trial and error solutions.  The model can then be used as a design/analysis tool to try out various "what if" scenarios. Hot oil is used as an alternative to steam for providing process heat in some industries.  In our scenario the hot oil is being pumped to the process equipment through an insulated pipe and we want to determine the rate of heat loss per metre of pipe. The pipe is made from mild steel and is insulated with fibreglass and clad with stainless steel. Heat is being lost from the stainless steel cladding surface by convection and by radiation. The initial problem is to determine the heat loss and cladding surface temperature for various thicknesses of the fibreglass insulation.

2200_Heat Transfer Situation.png

The following data is given: hot oil temperature, ...................................... 180°C

steel pipe internal diameter, ..................................................... 80 mm

steel pipe external diameter, .................................................... 90 mm

pipe length,     ................................................................................. nominal, 1 m

inside convection heat transfer coefficient, ............................. 50 W/m2°C

steel pipe thermal conductivity, .......................................... 35 W/m°C

initial fibreglass insulation thicknesses  ........................................... 25 mm

insulation thermal conductivity, ......................................... 0.039 W/m°C

stainless steel cladding thickness ................................................... 2.6 mm

stainless steel cladding thermal conductivity,      ........................ 14 W/m°C

stainless steel emissivity, .................................................... 0.2

outside convection heat transfer coefficient,  ........................ 18 W/m2°C

ambient/surrounding surface temperature, ......................... 22°C

1727_Heat Transfer Situation1.png

At first glance this looks to be a relatively simple problem, however to solve it we need to find the surface temperature,    before we can find the heat loss,.  To solve for analytically would require the solution of a polynomial (quartic) equation.  With the spreadsheet we can solve this fairly easily using a trial and error approach or using one of the advanced tools available in Excel to automate this process...

Specific requirements:

You are required to:
Set up a spreadsheet model of the heat transfer situation, using Microsoft Excel, as detailed below.

Write a Report (Word document) with comments and results as also detailed below.
 
1. Spreadsheet Model

Set up your spreadsheet model of the heat transfer situation with an area for input values (all of the data given above), an area for intermediate answers (eg radii, Qint, Qconv, Qrad), and an area for the final results, Ts and Qloss.  Your model should be set up to be as flexible as possible to produce answers for     and       for a given insulation thickness. (Imagine other engineers might use your spreadsheet as a tool for similar heat loss situations, so make it clear, easy to use and helpful).

In your Report (Word document) :

Explain how you set up the spreadsheet and what "advanced" functions or tools you used, and how you used them to solve for  s  and  loss for a given insulation thickness.

Provide a table summarising your results ( Ts and Qloss ),  for the following insulation thicknesses:

25 mm, 50 mm, 75 mm and 100 mm.


Related Discussions:- Heat transfer situation

Maintenance requirement at storage tanks, Q. Maintenance requirement at sto...

Q. Maintenance requirement at storage tanks? Little maintenance is required at storage tanks; sometimes access is required for equipment used to remove accumulated solids (this

Solid Mensuration, How di i get the volume of a regular pentagon if the giv...

How di i get the volume of a regular pentagon if the given was a height of 9", a base of 3" and a central angle of 75

OPITZ CLASSIFICATION AND CODING SYSTEM, Ask quesOPITZ CLASSIFICATION AND CO...

Ask quesOPITZ CLASSIFICATION AND CODING SYSTEMtion #Minimum 100 words accepted#

Friction welding, FRICTION WELDING In this, friction is employed to genera...

FRICTION WELDING In this, friction is employed to generate heat b/w two sliding or rotating metal surfaces. This process is usually carried out by placing the pieces to be welded

Design ia-32 instructions, 1.  Given the data below, design IA-32 instructi...

1.  Given the data below, design IA-32 instructions to copy data in array X to array Y.   .data X   sdword   10,30,40,-10,-20,-4,-50 Y   sdword   7 dup (?)    2.  Given

Determine the reactions at the supports, Determine the reactions at the sup...

Determine the reactions at the supports: A smooth sphere weighing 200 N is resting as shown in Figure. Determine the reactions at the supports. Solution Let us fir

What uniformly distributed load per meter beam may carry?, Q. A rectangular...

Q. A rectangular beam which is 300 mm deep is simply supported over span of 5 m. What uniformly distributed load per meter beam may carry? If bending stress is not to exceed 130N/m

What is a steam turbine diaphragm, Steam turbine comprises of stages, numbe...

Steam turbine comprises of stages, number and size of the stages depends upon the break horsepower of the turbine. The stage has set of moving and fixed blades. The moving blade

Reactions at point while the system is rotating, Reactions at point while t...

Reactions at point while the system is rotating: 8 kg ball is mounted on a horizontal bar associated to a vertical shaft. Neglecting the mass of the bar and shaft what are the

Welding, Why is the quality of welds produced by submerged arc welding very...

Why is the quality of welds produced by submerged arc welding very good#Minimum 100 words accepted#

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd