Create model in Excel for automation

[modeldamper]

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

 

[FSB1]

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

 

[faremusai]

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.

 

[TG_eng]

"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.