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

Click For Summary
The discussion centers on solving a 2-D transient heat transfer problem using finite difference methods, specifically for an assignment requiring the use of Matlab. The problem involves calculating temperature distribution in aluminum with specified properties after 0.5 seconds of heat generation. Participants emphasize the importance of understanding finite difference methods and discourage sharing code due to academic integrity rules. One user mentions that similar problems can be tackled using Excel, suggesting it as an alternative tool. Overall, the conversation highlights the need for individual effort in solving engineering problems while providing guidance on resources.
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.
 
Had my central air system checked when it sortta wasn't working. I guess I hadn't replaced the filter. Guy suggested I might want to get a UV filter accessory. He said it would "kill bugs and particulates". I know UV can kill the former, not sure how he thinks it's gonna murder the latter. Now I'm finding out there's more than one type of UV filter: one for the air flow and one for the coil. He was suggesting we might get one for the air flow, but now we'll have to change the bulb...

Similar threads

  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K
Replies
7
Views
3K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 18 ·
Replies
18
Views
10K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 1 ·
Replies
1
Views
1K