Finite element method on excel?

for those of you who know.

Would it be possible to write a "easy" FEM- program in Excel? If so, how to proceed?

Thanx

I have dabbled in FEA programs for years. Although I am not aware of
any currently available in Excel I'm sure its possible. An excellent
source of free source code is
http://www.engr.usask.ca/~macphed/fi...resources.html.

I have played with various programs available there, Aladdin for one and
FEMObject. Most are academic projects but a good base to start with.
Unfortunately you'd have to translate to VBA or build a plug-in. And
they would only be good for small models. None I've found have
bandwidth optimization.

Also graphics would be limited to 2D or 2D projections.

Some times I get the urge to do what your proposing but then my boss
comes in and back to work.

Good luck.

Ed


*** Sent via Developersdex http://www.developersdex.com ***

tahnk you Ed. ill look into that

I have to check how big matrices Excel can handle before it gets too big. I don't know if there's a built-in-limit in the program or if its the power of the computer that sets the limit.

I've done stuff with this in the past. While excel isn't the most powerful tool to implement an FEA type analysis, it can be very useful. Check out excelexpress.org for how I did it. You can open up the VBA code and take a look.