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

Excel

Register Blogs Community New Posts Updated Threads Search

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old   August 4, 2006, 14:09
Default Excel
  #1
yolan
Guest
 
Posts: n/a
Hi all!

I would like to know how can i get my results, insert them in an Excel file and compare different cases and get some graphs. Is it possible to open the .res files in any way? I've tried making a table but i haven't succeeded. Could you help me please? Thank you very much.
  Reply With Quote

Old   August 7, 2006, 02:35
Default Re: Excel
  #2
Patrick
Guest
 
Posts: n/a
You can export all relevant data. But you will get problems if your Excel file has more than 64'000 lines (that's often the case if you export some data for every finite volume). Then you better proceed with a better tool like Matlab.
  Reply With Quote

Old   August 7, 2006, 03:55
Default Re: Excel
  #3
yolan
Guest
 
Posts: n/a
Thank you for your help Patrick but, could you explain me how I must do that exactly? I've tried and I don't succeed. Thank you again.
  Reply With Quote

Old   August 7, 2006, 06:45
Default Re: Excel
  #4
Patrick
Guest
 
Posts: n/a
CFX Post: File -> Expor: Select the values and save it as .csv file. You can open that with Excel.
  Reply With Quote

Old   August 7, 2006, 11:55
Default Re: Excel
  #5
yolan
Guest
 
Posts: n/a
Thank you very much! That has worked quite well but I would like to get a table with two columns: the first is the time (or the time step) and the other one the variable I'm interested in. I have got those data just for each time but not for all the time steps at a time. Is that possible? Thank you!!
  Reply With Quote

Old   August 8, 2006, 23:39
Default Re: Excel
  #6
HekLeR
Guest
 
Posts: n/a
Easiest route would have been to create a monitor point in CFX Pre and then export from the solver manager.

Now you will have to write a script for CFX Post instead.
  Reply With Quote

Old   August 9, 2006, 03:49
Default Re: Excel
  #7
yolan
Guest
 
Posts: n/a
Yes! I have a monitor point!!! But is it possible to export to Excel from the solver manager? is the procedure the same? Tnank you!
  Reply With Quote

Old   August 9, 2006, 11:46
Default Re: Excel
  #8
johnny
Guest
 
Posts: n/a
Right click on the monitor point graph and click export plot data.
  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
How to plot a contour from an excel file in Tecplot? gholamghar Tecplot 9 February 11, 2021 14:43
Reading MS Excel Data in STAR-CCM+ using a Macro BrenS STAR-CCM+ 1 May 20, 2010 15:38
Radiation and VBA using Excel kapo84 OpenFOAM 2 January 21, 2010 07:46
Advanced post-processing (to Excel) Felix CFX 4 May 2, 2008 14:30
how to export data to Excel bikash FLUENT 3 September 14, 2004 21:58


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