CFD Online Logo CFD Online URL
Home > Forums > Software User Forums > ANSYS > FLUENT

Any way to export surface integrals into excel?

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

Like Tree1Likes
  • 1 Post By Carlos

LinkBack Thread Tools Display Modes
Old   March 28, 2008, 16:55
Default Any way to export surface integrals into excel?
Posts: n/a
I was wondering if there was a way for me to take surface integral results and easily transfer them to excel so that the results are actually in independant cells. As it is I have to end up continually copying and pasting results and its a waste of time.

  Reply With Quote

Old   March 28, 2008, 19:26
Default Re: Any way to export surface integrals into excel
Posts: n/a

If you want to plot the pressure distribution along a rake for example, go to the XY plot in Fluent but click write to file. This way, the plot button will change to write. Now save the file with .dat extension.

Open Excel, then go to open the file. But change the file type to all files, not just excel files or it won't see the file. At this point you will have to go through a few stages in excel before it read the data in. If you want data in individual cells, then I think its the second stage in excel where you can tick boxes such as space and colon etc. Just tick space then click finish.

Now, hey presto you have your data for usual manipulation in Excel.

saeedsalahi likes this.
  Reply With Quote

Old   March 31, 2008, 13:25
Default Re: Any way to export surface integrals into excel
Posts: n/a
Sorry I should have specified this in more detail in the original post, but the data I'm interested in is the area-weighted average, but there doesn't seem to be an option in the xy plot menu to select the area weighted average. Any way I can do this?
  Reply With Quote

Old   March 31, 2008, 15:53
Default Re: Any way to export surface integrals into excel
Posts: n/a
I am assuming you want to plot your area averaged value as a function of flow time/iteration. In this case, you will go to solve --> monitors --> surface monitors and choose whichever variable you want here. The xy plot does not provide area averaged because it plots variables as a function of a particular direaction. Once you write out the surface monitors you can follow the procedure mentioned by Carlos. It should work.

  Reply With Quote


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
How can I export transient results data to EXCEL popi CFX 8 February 22, 2014 05:31
surface integrals Lucy FLUENT 0 November 20, 2006 12:41
Surface Integrals Philip Oliver FLUENT 2 January 25, 2006 13:56
how to export data to Excel bikash FLUENT 3 September 14, 2004 20:58
problem with surface integrals tibor FLUENT 3 July 16, 2001 05:07

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