CFD Online Logo CFD Online URL
www.cfd-online.com
[Sponsors]
Home > Forums > Software User Forums > OpenFOAM

Radiation and VBA using Excel

Register Blogs Community New Posts Updated Threads Search

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old   January 20, 2010, 16:48
Default Radiation and VBA using Excel
  #1
New Member
 
Nate
Join Date: Jan 2010
Posts: 1
Rep Power: 0
kapo84 is on a distinguished road
I will be receiving my undergraduate degree in Mechanical Engineering this April. I am currently enrolled in a CFD class in which I am learning OpenFOAM. For the class project I would really enjoy working on the following project:

I want to model the temperature rise for cold air flowing through an air duct exposed to various ambient conditions (like an a/c hose lying on the tarmac). This would obviously include radiation. I successfully created a model in Microsoft Excel using VBA which models this temperature rise.

Can I interface the model which I created in Excel with OpenFOAM so that for every parameter adjustment a new CFD model would be created?

Also, being a beginning CFD user (although fairly strong as a programmer) will I be able to tackle the challenge of radiation??

Thank you for your help in advance,

Please feel free to ask additional questions as I may have left out key information.
kapo84 is offline   Reply With Quote

Old   January 21, 2010, 05:08
Default
  #2
Senior Member
 
Elvis
Join Date: Mar 2009
Location: Sindelfingen, Germany
Posts: 620
Blog Entries: 6
Rep Power: 24
elvis will become famous soon enough
maybe my answer goes in the wrong direction but if you want to do "Parameter_Variation" Bernhard Gschaider wrote PyFoam that can be used for this!
Read more: http://openfoamwiki.net/index.php/Co...eter_Variation

perhaps Excel and PyFoam find together? Hope I did not tell complete rubbish as I'm not an expert on this topic ;-)

elvis
elvis is offline   Reply With Quote

Old   January 21, 2010, 07:46
Default
  #3
Assistant Moderator
 
Bernhard Gschaider
Join Date: Mar 2009
Posts: 4,225
Rep Power: 51
gschaider will become famous soon enoughgschaider will become famous soon enough
Quote:
Originally Posted by elvis View Post
maybe my answer goes in the wrong direction but if you want to do "Parameter_Variation" Bernhard Gschaider wrote PyFoam that can be used for this!
Read more: http://openfoamwiki.net/index.php/Co...eter_Variation

perhaps Excel and PyFoam find together? Hope I did not tell complete rubbish as I'm not an expert on this topic ;-)
Writing files that are readable for Excel is no problem in python. You can easily generate CommaSeparatedValues-files using the csv-module that comes with every python-installation. That module also does reading of CSV-files.
PyFoam has a wrapper-class PyFoam.Basics.CSVCollection that does a little bit of bookkeeping for writing files, but currently there is nothing for reading.

Bernhard
gschaider is offline   Reply With Quote

Reply

Tags
cold air, excel, openfoam, radiation, vba


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



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