CFD Online Logo CFD Online URL
www.cfd-online.com
[Sponsors]
Home > Forums > General Forums > CFD Freelancers

1D Heattransfare Simulation Excel-Help needed!

Register Blogs Community New Posts Updated Threads Search

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old   September 18, 2014, 10:59
Default 1D Heattransfare Simulation Excel-Help needed!
  #1
New Member
 
Sebastian
Join Date: Sep 2014
Posts: 2
Rep Power: 0
Skipper141 is on a distinguished road
Hello,

i am a mechanical engineer Student. I have to demonstrate a simple Simulation of a 1d heattransfer in Excel with 10 Gridpoints.

The equation is aP*TP=aE*TE+aW*Tw
ap=2*aE; aE=aw

The equation should be solved by the thomas algorithm.
I have typed the following equations into an Excel file and activated iterations.

r1=c1/b1
ri=ci/(bi-ai*ri-1)

q1=d1/b1
qi=(di-ai*qi-1)/(bi-ai*ri-1)

Ti=qi-ri*Ti+1

But the Problem is that the values are not correct. It would be nice if someone could help me out.

I have attached my Excel file.

Sorry for my bad english and thanks for any help in advance!
Attached Files
File Type: xlsx 1D-Heattransfer.xlsx (14.4 KB, 18 views)
Skipper141 is offline   Reply With Quote

Old   October 6, 2014, 05:48
Default
  #2
Member
 
Join Date: Oct 2012
Posts: 46
Rep Power: 14
samurai_01 is on a distinguished road
Is the problem still open for correction?
samurai_01 is offline   Reply With Quote

Old   October 14, 2014, 20:51
Default
  #3
New Member
 
Sebastian
Join Date: Sep 2014
Posts: 2
Rep Power: 0
Skipper141 is on a distinguished road
Yeah sure, any help is appreciated.
Skipper141 is offline   Reply With Quote

Old   November 29, 2014, 02:01
Default
  #4
Member
 
Mehul Patel - CFD Expert
Join Date: Jul 2013
Location: Ahmedabad
Posts: 41
Rep Power: 13
Mehul Patel is on a distinguished road
Quote:
Originally Posted by Skipper141 View Post
Hello,

i am a mechanical engineer Student. I have to demonstrate a simple Simulation of a 1d heattransfer in Excel with 10 Gridpoints.

The equation is aP*TP=aE*TE+aW*Tw
ap=2*aE; aE=aw

The equation should be solved by the thomas algorithm.
I have typed the following equations into an Excel file and activated iterations.

r1=c1/b1
ri=ci/(bi-ai*ri-1)

q1=d1/b1
qi=(di-ai*qi-1)/(bi-ai*ri-1)

Ti=qi-ri*Ti+1

But the Problem is that the values are not correct. It would be nice if someone could help me out.

I have attached my Excel file.

Sorry for my bad english and thanks for any help in advance!
Hello,

Have you got any solution for your question?
__________________
Thanks,
HiTech CFD - CFD Analysis Services Provider.
http://www.hitechcfd.com/
Mehul Patel is offline   Reply With Quote

Reply

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wind Tunnel Simulation: How to measure the downforce? luckyrob STAR-CCM+ 14 September 8, 2014 13:34
compiling firefoam Farshad_Noravesh OpenFOAM 27 December 24, 2012 05:21
Needed Help on Welding Simulation Process darshankapadia FLUENT 0 August 7, 2010 09:37
Blunt body aerodynamics simulation cases needed David FLUENT 0 June 1, 2003 12:40
3-D Contaminant Dispersal Simulation Apple L S Chan Main CFD Forum 1 December 23, 1998 11:06


All times are GMT -4. The time now is 16:05.