×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Create model in Excel for automation

Create model in Excel for automation

Create model in Excel for automation

(OP)
All,
I would like to know how to build a FEA model in Excel and import it into FEMAP. This is more like automation so that non-FEA person can simply change the material properties or change the thickness, to do some parametric studies.

Is there any process that you would like to share?

Thanks
Modeldamper

RE: Create model in Excel for automation

why excel? it is easy for a non-FEA person to change the material properties and thickness using e.g. notepad and change the .dat/.bdf file

RE: Create model in Excel for automation

Excel provides the functions of Lookup table / Index search / Data validation which makes parameters input by selection from a list of choices much easier.

Also, if it is requried to retrieve the result output from FEMAP and carry out further calculation process, running a macro from EXCEL is a good choice.

RE: Create model in Excel for automation

"Also, if it is requried to retrieve the result output from FEMAP and carry out further calculation process, running a macro from EXCEL is a good choice."

This can be done with the Femap userinterface with commands like Model > Output Process, Model > Output Calculate, etc.

This can also be done within the native API when these commands are used frequently in the same way.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close