|
[Sponsors] |
How can I export transient results data to EXCEL |
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
August 21, 2007, 17:00 |
How can I export transient results data to EXCEL
|
#1 |
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 |
|
August 21, 2007, 19:50 |
Re: How can I export transient results data to EXC
|
#2 |
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 |
|
August 22, 2007, 08:06 |
Re: How can I export transient results data to EXC
|
#3 |
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. |
|
August 27, 2007, 17:28 |
Re: How can I export transient results data to EXC
|
#4 |
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! |
|
August 30, 2007, 13:58 |
Re: How can I export transient results data to EXC
|
#5 |
Guest
Posts: n/a
|
thanks a lot to all
|
|
September 15, 2009, 11:23 |
|
#6 | |
New Member
Coen Wit
Join Date: Jul 2009
Posts: 5
Rep Power: 17 |
Quote:
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. |
||
October 15, 2009, 08:37 |
|
#7 |
Member
Join Date: Aug 2009
Posts: 42
Rep Power: 17 |
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 |
|
February 21, 2014, 20:02 |
|
#8 | |
New Member
Chandrasekhar
Join Date: Oct 2013
Location: new jersey
Posts: 24
Rep Power: 13 |
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:
|
||
February 22, 2014, 05:31 |
|
#9 |
Super Moderator
Glenn Horrocks
Join Date: Mar 2009
Location: Sydney, Australia
Posts: 17,872
Rep Power: 144 |
Try the fluent forum.
|
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to extract data from a completed transient run | Vince | CFX | 3 | November 26, 2019 06:59 |
Export data in text file | Eferal | FLUENT | 5 | April 13, 2018 11:33 |
Export CFD Solver results to text file format | Maik | Main CFD Forum | 2 | May 23, 2008 02:34 |
How to update polyPatchbs localPoints | liu | OpenFOAM Running, Solving & CFD | 6 | December 30, 2005 18:27 |
How to get the transient data ? | Lee | Siemens | 2 | September 8, 2003 04:57 |