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

How can I export transient results data to EXCEL

Register Blogs Members List Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
Old   August 21, 2007, 16:00
Default How can I export transient results data to EXCEL
  #1
popi
Guest
 
Posts: n/a
Hi everybody

I'm trying to export results ( different variables ) to an excel table in a transient simulation, and I found it imposible. How can I make it? I tried to do a table in CFX-post, but this way I only create a table with differents values of variables but of a single timestep. I can't obtain a variable along all the simulationtime. I've done this, without problems, with a chart. But I wanted an easy way to take this numerical values of variables in different timesteps, and not graphically.

How can I do this???

thanks all

  Reply With Quote

Old   August 21, 2007, 18:50
Default Re: How can I export transient results data to EXC
  #2
Glenn Horrocks
Guest
 
Posts: n/a
Hi,

You could either script CFX-Post to do it or you could set a monitor point to show the value and export it from the solver manager.

Glenn Horrocks
  Reply With Quote

Old   August 22, 2007, 07:06
Default Re: How can I export transient results data to EXC
  #3
Pankaj
Guest
 
Posts: n/a
You can plot monitor points for your variables in solver manager and export this plot data as a csv(comma separated value) file,which can be opened in excel.

regards, Pankaj.
  Reply With Quote

Old   August 27, 2007, 16:28
Default Re: How can I export transient results data to EXC
  #4
Omer
Guest
 
Posts: n/a
If you know how to plot of chart. It would be easy.

What you can do is first create a POINT where the variable is needed to be plotted with respect to time.

Then Create a chart. Use the "TIME" option instead of "XY" on the first window that opens when you click the create chart button!

You can pick the POINT you want to plot results on. Pick the variable you need to plot.

You can directly see the result w.r.t time! You can export to .csv and view it in Excel!

I hope this is what you needed!

  Reply With Quote

Old   August 30, 2007, 12:58
Default Re: How can I export transient results data to EXC
  #5
popi
Guest
 
Posts: n/a
thanks a lot to all
  Reply With Quote

Old   September 15, 2009, 10:23
Default
  #6
New Member
 
Coen Wit
Join Date: Jul 2009
Posts: 5
Rep Power: 9
CoenW is on a distinguished road
Quote:
Originally Posted by Glenn Horrocks
You could either script CFX-Post to do it or you could set a monitor point to show the value and export it from the solver manager.
Sorry to kick this very old topic, but it helped me to manually do what I want: export a monitored value in a certain time-range to a .csv file.

I've created an expression for the Drag-coefficient in cfx-pre, create a separate monitor point in the solver manager. Set the horizontal scale of this monitor to 'time' for a defined range and can then export this data to a .csv file. Afterwards there is still some manual work to get max and min values and the time-averaged coefficient.

Is there any way to do this in a scripted fashion directly at runtime?

I've looked at cfx5cmds and cfx5solve -help but they give no help on exporting . cfx5export is aimed at exporting to other CFD packages, not .csv files.

I've seen some mention of similar issues which were resolved using session files, python/perl scripting by iteratively reading in .trn files. Since I'm not familiar yet with scripting of post-processing I've not tried this, but it seems like overkill if the solver gives direct access to the data I need.
CoenW is offline   Reply With Quote

Old   October 15, 2009, 07:37
Default
  #7
Member
 
Join Date: Aug 2009
Posts: 42
Rep Power: 9
cfxmar is on a distinguished road
Hello Coen,

I think Iīm trying to solve the same problem as you say.

As I see in the Solver Manager guide, Drag Force is the addition of Viscous and Pressure force values over the x axis that the .out file gives you at the end of the simulation.

The point is that I donīt know if these values are the maximum values (as the Force values vary for different time steps) over the wall for the whjole simulation...and also, for the Morison equation, force in the x axis is the addition of drag and inertial forces...?ŋ

Finally, I order CFX to simulate with batch files but I donīt know the expression to save the monitor point results

Do you have any idea?

Thank you in advance
cfxmar is offline   Reply With Quote

Old   February 21, 2014, 20:02
Default
  #8
New Member
 
Chandrasekhar
Join Date: Oct 2013
Location: new jersey
Posts: 24
Rep Power: 4
chandrasekhar is on a distinguished road
Hi
i have a doubt regarding storing of data from the fluent results cell. Suppose i have to collect the data(say area weighted temp) at 3 surfaces(say) i usually go to report fluxes and print them in TUI, then i copy them one by one into excel(i want to store the values in excel). I have to do this every time for each of the fluent cases i run. I would like to know if there is another way of doing this which isn't so time consuming. Also is it possible to store these values in an other software(say matlab).Many many thanks for replying.

with regards
Chandra Sekhar


Quote:
Originally Posted by Glenn Horrocks
;83261
Hi,

You could either script CFX-Post to do it or you could set a monitor point to show the value and export it from the solver manager.

Glenn Horrocks
chandrasekhar is offline   Reply With Quote

Old   February 22, 2014, 05:31
Default
  #9
Super Moderator
 
Glenn Horrocks
Join Date: Mar 2009
Location: Sydney, Australia
Posts: 12,638
Rep Power: 98
ghorrocks is a jewel in the roughghorrocks is a jewel in the roughghorrocks is a jewel in the rough
Try the fluent forum.
ghorrocks is offline   Reply With Quote

Reply

Thread Tools
Display Modes

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 On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export data in text file Eferal FLUENT 4 July 7, 2011 16:48
How to extract data from a completed transient run Vince CFX 2 July 15, 2008 05:05
Export CFD Solver results to text file format Maik Main CFD Forum 2 May 23, 2008 01:34
How to update polyPatchbs localPoints liu OpenFOAM Running, Solving & CFD 6 December 30, 2005 18:27
How to get the transient data ? Lee CD-adapco 2 September 8, 2003 03:57


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