Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I model heat transfer using Excel?
I have been asked to use excel to model the heat transfer through a chimney.
I have broken the chimney into nodes and elements and have calculated the equation for each node. I have produced a spread sheet to solve the simultaneous equations to find the results. The spread sheet is however very large (approx. 50 pages when printed). Each of the equations uses an initial arbitrary value and the solutions from the other equations to refine and eventually solve the value for that node. Is there a way I can make the spread sheet needed to produce the results smaller? Is there a way I can get the programme to produce a convergence without the need for a very large number of columns? I only know the basics of excel and entering equations. Someone mentioned the words Goal Seek and Patterning to me, but that's as much as I know. Please Help Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I model heat transfer using Excel?
How about Solver? -- a7n9 ------------------------------------------------------------------------ a7n9's Profile: http://www.excelforum.com/member.php...o&userid=32149 View this thread: http://www.excelforum.com/showthread...hreadid=518648 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How can I transfer a Utf8 file from word to excel? | Excel Discussion (Misc queries) | |||
How do you transfer data from an input form in excel to an excel l | Excel Discussion (Misc queries) | |||
Mexport transfer from another program to excel opens at excel lau. | Excel Discussion (Misc queries) |