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


Create model in Excel for automation

Create model in Excel for automation

Create model in Excel for automation

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?


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! Already a Member? Login


White Paper - How to Capitalize on HVAC/R Trends to Drive Business Growth
According to Steve Yurek, CEO of the Air Conditioning, Heating and Refrigeration Institute, the HVAC/R industry is facing change on all fronts. This includes challenging trends on contractors and distributors like new refrigerants, growing automation, complex sensors and monitoring, green initiatives and a technician shortage. We look at these trends and outline actionable insights on how it all can be turned into a competitive advantage and business opportunity. Download Now
eBook - Manufacturing the Cars of Tomorrow
In this ebook, we'll explore how additive manufacturing is going to transform the way cars are made. This includes commentary from thought leaders such as Ford's CTO, Ken Washington, Customer case studies of ways 3D printing is being used today, and a variety of part examples where 3D printing is already impacting how automobiles are made. Download Now
White Paper - Smart Manufacturing for Semiconductor
New technologies and approaches present great opportunities for semiconductor manufacturers to achieve high levels of innovation, yield and improvement. This white paper explores some of these cutting-edge technologies and how they can be applied effectively in the semiconductor industry. Read about how Smart Manufacturing is transforming the semiconductor industry. Download Now

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