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

How can I import table from Excel to Ansys-fluent?

Register Blogs Community New Posts Updated Threads Search

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old   October 20, 2016, 04:08
Red face How can I import table from Excel to Ansys-fluent?
  #1
Member
 
ramin
Join Date: Jul 2016
Posts: 41
Rep Power: 9
raminostadi is on a distinguished road
Hello experts. I am working on blood flow.

I have pulse pressure boundry condition in outlet (pressure depends on time) and pulse velocity in inlet( depends on time).

I don't have pressure or velocity formula , therefore I can't use udf for define boundry condition.

I just have 2 charts for time-pressure and time-velocity and I have points of this 2 charts in Excel.

How can I import this data's table to Ansys fluent as boundry conditions?

please help me.
thank you
raminostadi is offline   Reply With Quote

Old   October 20, 2016, 13:50
Default
  #2
Senior Member
 
Lucky
Join Date: Apr 2011
Location: Orlando, FL USA
Posts: 5,668
Rep Power: 65
LuckyTran has a spectacular aura aboutLuckyTran has a spectacular aura aboutLuckyTran has a spectacular aura about
You can make a .prof file and read it into Fluent it's just a text file with coordinates or time and all the field variables.

Check out Section 3.6 in the Fluent User's Guide on reading and writing profiles. and Section 6.6 specifically on Profiles. 6.6.2 is the format for the x,y,z profile. Also search this forum for examples.

6.6.5 has the format for a transient file, which I have copy and pasted here.
((sampleprofile transient 3 0)
(time
1
2
3
)
(u
10
20
30
)
)

The parentheses aren't actually necessary but can speed things up because it allows Fluent to skip groups that are not needed.
LuckyTran is offline   Reply With Quote

Old   October 21, 2016, 01:24
Default
  #3
Senior Member
 
Paritosh Vasava
Join Date: Oct 2012
Location: Lappeenranta, Finland
Posts: 732
Rep Power: 22
vasava will become famous soon enough
I am guessing that you are simulating blood flow. Are you?

I have not seen excel directly connected to fluent. But I recommend that with excel you obtain a curve that best fits your data and create a UDF using these functions. DEFINE_PROFILE is most commonly used for time-dependent boundary conditions.
vasava is offline   Reply With Quote

Old   October 21, 2016, 01:31
Red face where should I write a .prof file
  #4
Member
 
ramin
Join Date: Jul 2016
Posts: 41
Rep Power: 9
raminostadi is on a distinguished road
thank you for your attention.
I read fluent user guid. in user guid just describe the method for writing prof file.

now I have another question.
where can I write profile file or which software can I use to write profile file.?
raminostadi is offline   Reply With Quote

Old   October 21, 2016, 02:35
Red face
  #5
Member
 
ramin
Join Date: Jul 2016
Posts: 41
Rep Power: 9
raminostadi is on a distinguished road
thank you Vasava
I have 2 problem with curve fitting
1- my boundry condition is similar to sine function not exact sine function.
2- curve fitting isn't a exact method
therefor I want to use points as a .prof file but I don't know where can I write this format for importing to fluent?
can any body help me?
raminostadi is offline   Reply With Quote

Old   October 21, 2016, 03:50
Default
  #6
Senior Member
 
Paritosh Vasava
Join Date: Oct 2012
Location: Lappeenranta, Finland
Posts: 732
Rep Power: 22
vasava will become famous soon enough
Quote:
Originally Posted by raminostadi View Post
where can I write profile file or which software can I use to write profile file.?
You can write your own matlab or C program to generate a .prof file. You just have to make sure that the data (coordinates, velocity, pressure etc.) appears in a particular format. After all its just a text file with numbers.

Here is a template of the .prof file.
Code:
((outlet point 2210)
(x
x1
x2
.
.
.
)
(y
y1
y2
.
.
.
)
(z
z1
z2
.
.
.
)
(velocity-magnitude
v1
v2
.
.
.
)
)
I think right now you don't realize that
  1. .prof file has only one profile (E.g. fully developed turbulent flow profile).
  2. The profile in the .prof file does not update with time. It is just one profile that remains same irrespective of time and iteration.
  3. Because of points 1 and 2, you can not implement time-dependent boundary conditions with .prof file.
If you have found a fluent tutorial or fluent guide that says otherwise, I would like to have a look and learn more.
vasava is offline   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
Ansys SIG$ILL error loth ANSYS 3 December 24, 2015 05:31
import to Ansys Fluent Design modeler shows 4141 parts and bodies samnath FLUENT 5 April 6, 2015 02:22
error in opening fluent in ansys workbench tmeysam92 ANSYS 3 March 12, 2013 06:10
How to import table into Fluent jorkolino FLUENT 1 August 27, 2012 11:32
export data from fluent to ansys galapago FLUENT 0 August 4, 2010 14:04


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