Can Excel be Used to Solve for 2-D Transient Finite Difference in Heat Transfer?

Click For Summary

Discussion Overview

The discussion revolves around the use of software, specifically Excel and Matlab, to solve a 2-D transient finite difference problem in heat transfer. Participants explore the requirements of an assignment related to temperature distribution in a material subjected to heat generation.

Discussion Character

  • Homework-related
  • Debate/contested

Main Points Raised

  • One participant inquires about using Excel to solve a finite difference problem for a heat transfer assignment, providing specific parameters such as heat generation and material properties.
  • Another participant suggests that the original poster should consult a book on finite difference methods and implies that sharing code is against forum rules.
  • A third participant agrees with the previous comment, emphasizing that assistance should not be provided without the original poster making an attempt at the problem.
  • A different participant mentions that they were advised to use Excel for a similar assignment in their heat and mass transfer class.

Areas of Agreement / Disagreement

Participants generally agree that the original poster should attempt the problem independently before seeking help. However, there is a divergence in software preference, with some advocating for Matlab and at least one suggesting Excel.

Contextual Notes

There are unresolved aspects regarding the specific methods and formulas applicable to the finite difference approach, as well as the appropriateness of using Excel versus Matlab for this type of problem.

semeer.s
Messages
3
Reaction score
0
I am curious to know if anyone has a program that will solve for 2-D Transient finite difference I have an assignment in a heat transfer class and I am supposed to use Matlab to solve for this. The governing equation (given in the attachement) is to solve using finite difference method using matlab.



In this problem we know the heat generated (Q) as 11×106W/m2.

The material using for this study is aluminum having following material properties

ρ = 2700 kg/m3,
k = 180 W/m-K,
c=896 J/kg-K.


In this study maximum time is allowed as for generated heat (Q) is 0.5 seconds.



My assignment is to find out the temperature distribution of the sheet at the end of 0.5 Seconds.
Any help would be appreciated.
 

Attachments

Engineering news on Phys.org
You need to go read a book on finite difference methods - and apply the formulae the book gives. I doubt you'll find anyone here willing to send you code as that's against the rules.
 
This is definitely homework and J77 is right. We will not provide answers. You need to provide some form of an attempt at the problem. This is a basic problem in pretty much all PDE texts from engineering.
 
I have an assignment in my heat and mass transfer class that is almost exactly like that. We were suggested to use excel though.
 

Similar threads

Matlab report help please (Finite Difference Method)
  • · Replies 5 ·
Replies
5
Views
2K
Engineering Multi-point Boundary Value Problems Using Finite Difference Method
  • · Replies 3 ·
Replies
3
Views
3K
Engine Finite Heat Release Model (With Heat Transfer) Help
  • · Replies 2 ·
Replies
2
Views
3K
Heat transfer through a MultiLayer Cylinder (find the Temperature inside)
  • · Replies 7 ·
Replies
7
Views
3K
Some questions on heat transfer
  • · Replies 5 ·
Replies
5
Views
2K
1-D Conduction+Convection: eriving a Finite Difference Scheme
  • · Replies 18 ·
Replies
18
Views
10K
Graduate Numerical Hartree Fock with Finite Difference Matrices for Helium
  • · Replies 4 ·
Replies
4
Views
3K
Undergrad Finite Element Method: Weak form to Algebraic Equations?
  • · Replies 1 ·
Replies
1
Views
3K
Finite Difference method to solve diffusion equation
  • · Replies 3 ·
Replies
3
Views
3K
Undergrad Solving Poisson's Equation Using Finite Difference
  • · Replies 1 ·
Replies
1
Views
2K