Stats

State Verified Answer
Replies 5
Subscribers 3
Views 12
Members are here 0

Importing material values

Hello All,

I am trying to find a way how I can read a excel file into patran for my material creation.

Lets see in my excel file I have material values for Al 6061 (young's modulus, density and poisson's ratio) . how can I read them into patran so that I do not have input these values manually ?

Is there a specific excel format these values need to be in order for patran to read them and create the material tab?

Thank you in advance

0 edwin.goei over 7 years ago

Shaheer,

If you have material data in Excel and want to import it to Patran, the easiest way, in my opinion, is to format the data into a Nastran card, such as MAT1, then import the data as a BDF.

However, if you really want to make so that you don't have to reenter it every time, there's a good SimCompanion article that discusses how to use and add to the Material Session File Library, which can be accessed through the Utilities menu:

https://simcompanion.mscsoftware.com/infocenter/index?page=content&id=KB8021400

I believe this is what posted the last time you asked a similar question here.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shaheer.iqbal over 7 years ago

Thank you for response.

Yes the session file information shared earlier was really helpful. I will use it eventually.

But in order to enter data items in the patran database , I was trying to see how can I minimize the manually input.

You mentioned that I can format the excel file into a Nastran card format such as MAT 1.

can you share the approach for this in more detail?

how can a excel file be sorted out into bdf ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 edwin.goei over 7 years ago

To make anything into a Nastran card that can be read into Patran, such as MAT1, you'd have to follow the formatting definition as described by the Quick Reference Guide.

I took a screen shot of the page for MAT1 below.

In the Example, a material with a Young's Modulus of 3e7, Poisson's Ratio of 0.33, and other properties that are inserted into the proper field.

You would have to format your data in such a manner, following the spacing rules for the fields, or using commas to separate the fields.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Reject Answer

Cancel
0 shaheer.iqbal over 7 years ago

thank you I will give it a try :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shaheer.iqbal over 7 years ago

It worked!

I used the following approach

1) Created an excel file and each column represented grid entry per the QRG for MAT 1

2) I saved the file as .csv (This separates all the columns into comma so patran can read it)

3) Rename the .csv file as .bdf

4) import into patran as bdf

Thank for the support :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.