Spreadsheet model of the heat transfer situation

Assignment Help Computer Engineering
Reference no: EM131088

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.

826_Computer Systems Management.png

The following data is given:

hot oil temperature, Thot oil............................................................ 180°C

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

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

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

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

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

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

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

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

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

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

outside convection heat transfer coefficient, ........................... 18 W/mC

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

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...

You are required to:

  • Set up a spreadsheet model of the heat transfer situation, using Microsoft Excel, as detailed below.
  • Write a Report with comments and results as also detailed below.

1. Spreadsheet Model

2. Further Analysis

3. "What if" analysis

Reference no: EM131088

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Implementation of type data structures

How can string and word variable type data structures be implemented?

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

  Security policy document project

Analyze security requirements and develop a security policy

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Mathematics in computing

Write the selection sort algorithm

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Write a recursive implementation of euclids algorithm

Write a recursive implementation of Euclids algorithm

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Write an essay on wifi performance

Write an essay on WiFi performance

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