ExcelFEM_ 2D (for Excel 2003).



Section Definition Page
Model Definition Page
Nodes Load Page
Member Loads Page
Results Page
Reports Page

Static structural analysis of 2D linear elastic frames and trusses. Computes the static deflections, reactions, internal element forces using direct stiffness methods.

This version works with Excel 2003 but is no longer being maintained. Excel 2003 has limitations in terms of sheet size and matrix inversion functions. The latest version of this file works with Excel 2007 and later and is being maintained. 





These videos are best viewed in full screen mode. Press play and double click the screen to maximise.

Calculation Reference
analysis of frames
finite element analysis
structural analysis

Calculation Preview

06 Sep 2011
Last Modified
07 Sep 2011
File Size:
6,751.00 Kb
File Version:
File Author:
File HomePage:
EXCEL 2007

Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 25
rgordon 12 years ago
Mr. Babacan,
I believe that did the trick! Thank you! I am getting symmetrical loading across all members of the structure (including member #17). I appreciate your putting in the time on a 2003 tool for those of us that are still working on the older MS platform.
Thanks you for being so responsive. It has been very helpful.
BABACAN 12 years ago
Mr. Gordon.
now improved.
Please be sure to check back.
Best regards.
rgordon 12 years ago
Thank you for looking at that Babacan! Values are much improved for member #17. I am still seeing substantially higher values for that member. It is as if it is picking up a "ghost" loading on that member. I also see slight ripple affects across other members. Do you think there may be another contributing issue? Thanks again. This is a very impressive effort.
rgordon 12 years ago
Thank you for a very useful too! I am running into some problems though with member 17 results. It appears there may be a calculation error? I have tried multiple frame arrangements and I continue to get output sometimes 100 - 1000x what I am getting for other members. I am working with a symmetric frame and I am not getting any error for the corresponding member on the other side even with symmetric loading and the same bounding conditions (XYM for both). Could you take a look? The calcs are locked and I am not able to easily locate the problem. Thank you!
BABACAN 14 years ago
Turan Babacan has sent a new version of EXCsta2D. It has an improved user interface improved user interface and results presentation. As you can see from my previous comments I cannot praise this highly enough. I enjoy just marvelling how Turan uses Excel in such an innovative way. Turan teaches me many new Excel tricks. This is truly great 2D beam analysis method and an essential download for all engineers.
Turan write to tell me a little about himself. "I was born in Trabzon in 1964. I am a civil engineer. I do amateur software since 1986. C + +, VB, VBA, Prolog and Fortran languages I know. From the project since 1990 and am working in the manufacturing sector. "Steel buildings, Substructure and road engineering," I'm experienced Excel is my hand up my arm. I am currently working in Istanbul."
Turan we are delighted to have such an accomplished user sharing his work on the ExcelCalcs site. Thank you.
Download link to Repository:
BABACAN 14 years ago
17. resolved the problem element. (Thanks, Robert Gordon)
BABACAN 14 years ago
Praise where praise is due Babacan. I have been investigating the spreadsheet further un-protecting worksheets, un-hiding worksheets, rows and columns so that I can see how you constructed the spreadsheet. It is like a master class in the use of Excel.
I like to see all parts of the calculations so that I can appreciate what is going on. It gives me increased confidence in using a workbook if I know what it is doing. I wonder if you have any objection to me posting the calculations in this form?
All worksheets are password protected without a setting a password (presumably to prevent accidental editing) but I notice that the 'DEVELOPERS' worksheet is password protected with a password. Is there any reason for this?
BABACAN 14 years ago
Thank you john.:blush: Embarrassed. Because of this praise. "3D" 'I'll try to be worthy of the praise. Good night.
BABACAN 14 years ago
Bravo Bravo Barvo! What a phenomenal spreadsheet. I love it. You are indeed a spreadsheet king BABACAN. Well done!
BABACAN 14 years ago
Dear John, I'll check to install and excel in English. I need some time.
Mr John Doyle, Please Do your test?
problem: "#Yok" = "#N/A" :)
BABACAN 14 years ago
BABACAN I am afraid I am still getting the #NA error in spreadsheet cells.
BABACAN 14 years ago
Mr John Doyle, I think I've solved the problem. I hope it works this time
BABACAN 14 years ago
I have uploaded your 3D frame calculation EXCsta_3D.xls

Users have been invited to comment in a separate forum thread here.
BABACAN 14 years ago
BABACAN I think all your work is excellent. Your calculations are well laid out and expertly executed. Your documents use Excel features in an innovative way (I particularly like your implementation of symbols in excel charts). It is just a shame that I cannot get EXCsta2010.xls to work (it is frustrating because it is clearly working on your machine and I can't figure out why it is not working on my machine or InfoJunkie65's machine).
Your EXCsta_3D.xls seems like another great sheet. I have been marvelling at your 3D sketching and rotational controls. I look forward to seeing the completed version. Both calculations would make excellent teaching tools for finite element analysis. I'll up load the EXCsta_3D.xls calculation as a work in progress and invite other users to comment.
BABACAN 14 years ago
Mr John Doyle
After reading your comments,
I'm working on hold EXCsta_3D software.
I would add for your review.
do you still want from me?
What are your suggestions?
Thank you.
BABACAN 14 years ago
Thanks for all your helpful comments InfoJunkie65. With regard to your comments about the use of VBA to solve frame problems I thought that you might like to take a look at one of Doug Jenkins calculations. I think it is just the thing you are looking for.
BABACAN 14 years ago
Sorry, didn’t actually change anything the other day merely looked at the workbook, seemed like something requiring a lot of study before making use of. I assumed all the #value’s on the ANKS worksheet were the typical spreadsheet problem, of not using all the cells for the current problem setup in the workbook. Given not all in English and only looked like it could handle one load case wasn’t into spending too much time looking at it.
Today, I just checked my emails, and I just made a simple change to the workbook, making the member distributed load uniform (-20) at each end, the result page is now full of #NA, and diagram filled with symbols for reactions at each node. Changing value back doesn’t fix it up.
I’ve done a manual recalc (F9) and switched iteration on, made no difference. Doesn’t appear to be any external links, or any VBA code attached. I have the following standard Excel add-in’s loaded:
1) Analysis ToolPak
2) Analysis ToolPak – VBA
3) Conditional Sum Wizard
4) Lookup Wizard
5) Solver Add-in
Help system doesn’t indicate any special Add-in for SUMIF, TRANSPOSE or any of the other various matrix/vector functions.
NameManager indicates two named ranges with errors:
1) baslik
The “I” in DIFY has a dot above. DIFY is used in several places but appears to have calculated values. Whilst baslik is not used anywhere.
May be a problem with the use of array formula.
Otherwise don’t understand why changing a single number and then changing it back doesn’t produce calculated results.
Maybe there is a difference between the Turkish and English versions of some of the built in functions.
Maybe Alex Tomanovich can help, from memory his Frame.xls workbook is also based on the matrix stiffness method, but doesn’t allow variation of the frames (Gable or Skillion).
Personally, for such complex task, I think it is better to use VBA to do the number crunching and just use the worksheets to collect the data and display the results. Write the formula once in VBA, and then place in a loop, have complex conditional and branching statements along with data validation and error trapping. No problems about whether a single cell has the same formula as an adjacent cell, plus less memory required. As I indicated TurboPascal DOS program 165kB with GUI, with data files 2kB per loadcase, compare to 3.5Mb for Excel workbook per loadcase: rapdily consume harddisk space.
Been looking at SMathStudio (=MathCAD) and SciLab (=MatLAB), discovered why prefer Excel. Excel can more readily deal with numbers, no need to define variable x1, x2 , F1 , F2 etc… Can readily calculate one sequence, decide not best approach and easily calculate with reverse sequence but retain original calculations, no new variable names. I can label cells, and name ranges afterwards, but otherwise simply use the cells like the stack of my HP RPN calculator. Basically get the numerical calculations done, but otherwise handwrite the calculations: turning Excel worksheet into a printable report at later date.
It all gets complicated as to what needs to be visible to the user and when, and also what needs to be in reports. Simply because reports are no longer an automatic output of the calculation process.
Which maybe one benefit of MatLAB. The following CUFSM application, hides calculations if use the stand alone version, but if have MatLAB can then modify and customise the formula.
Lots of good coldformed steel design information on the site along with free software. Putting such calculations, as the finite-strip method, into Excel maybe possible, and useful, but probably extremely cumbersome and error prone. I think better to have an add-in which makes use of Excel.
Use Excel as general purpose tool and central processor. Try to get all calculations done in Excel. For example for complex frames calculate actions in Excel, then type results into MicroStran/Multiframe run frame analysis, get results, and type back into Excel for member and connection design, can take a few hours. Whilst for simple frame, everything done in Excel in few minutes. The problem is it takes a lot longer to set up Kleinlogel formula than it does to use MicroStran/MultiFrame. Which is why slowly translating the TurboPascal frame program into VBA, to run within Excel: the problem with that approach however is the need to run a macro to keep the results upto date.
My basic philosophy is that should develop own engineering software, restrict purchases to general purpose tools. From another perspective I want to get rid of MicroStran from the analysis viewpoint, but not from the user interface viewpoint. That is not overly interested in developing the GUI, but want control over data inputs and results output, and the sequence of calculations. Should not be constrained by the calculations commercial software can do: for example shouldn’t be wasting time with trial and error when can rearrange the formula and calculate the objective directly. With own calculation engines, can better match calculations to the localised task at hand.
Problems with commercial software:
1) Suppliers not always fast enough at revising to new codes of practice
2) Software doesn’t always model exactly what is wanted
3) Supplier may disappear from market
The latter can be a big problem. Locally one engineer had frame analysis software with coldformed steel design built-in, he had advantage whilst the code was still valid: no one else could buy software because supplier went out of business. But unfortunaely when the coldformed code was revised he fell behind. Those who had already setup coldformed design in spreadsheets or MathCAD could easily update to the new code.
Also the coldformed industry is more interested in design of ranges of structures not individual structures, and otherwise optimum structures. Commercial software can be used, but it is cumbersome and time consuming to use depending on actual task have to perform. Most of the software is configured based on a common assumption of the task: namely checking against a code of practice. Design features tend to be relatively poor.
Anycase need different workbooks for different purposes. So that need workbooks like excsta2010 for analysis of a single loadcase, more complex workbook for the multiple loadcases need to check for the structural building codes, and yet simpler workbook for learning purposes which show the porgressive development of something larger. That is a workbook which shows a single member and a single load type, so that the procedure can be understood. From there workbooks with different load types. Then increase the number of members.
In short a set of workbooks to study and learn the matrix stiffness method. So that more complex workbooks can be developed, maintained, checked and corrected. Its not just a simple formula which can be checked in a variety of hand books.
Frame analysis, and matrix stiffness method looks like a potential project can get others contributing towards. Once got frame analysis, can then plug in various other workbooks for design in: steel, coldformed steel, timber, aluminium and concrete. With codes to suit various countries.
A potential on going open source development project. 2D frame analysis direct in Excel. Now that would generate some major productivity gains. Master Series is one of the few programs that appears to be able to do the whole job, and that is largely restricted to the UK.
As I say, most frame software requires, crunch numbers in Excel, manually transfer to the frame software, get results, and manually transfer back to Excel to finish the job. Get all calculations linked in Excel, and hours collapse to minutes.
So it would be good to see excsta2010 working. Even though it cannot handle multiple load cases it does have the potential to provide an alternative check for the critical loadcase found using other software.
The demo version of Multiframe can be obtained here:
BABACAN 14 years ago
Its a real shame I can't get the calculation working because it is superb. Maybe something has been lost in translation? When I view the calculation I see all the English equivalents of the Turkish function calls you have used. I would be interested to know if any other users manage to get it working. If I get a bit of time I'll try to workout what is going wrong.
InfoJunkie65 14 years ago
Appears can only handle one load case, but good learning tool. Just a matter of interest DOS program with GUI 165kB, Excel Workbook 3.6Mb. Amazing what can be done in excel, but not always best tool to use.
BABACAN 14 years ago
Dear John
I did not use a different extension.
work is required.
No VBA. No specific function.
No confidential information.
I'm sorry.
If you'll be happy to solve.
I used functions,
functions lists
originale türkish
Mmult = Dçarp
transpoze = devrik_dönüşüm
Minverse = dizey_ters
True = Doğru (***)
Sumiff = Etopla
index = İndis
Max = Mak
Min = Min
Abs = Mutlak
null = ""
if = eğer
and = ve
or = yada
false = yanlış (***)
vlookup = düşeyara
#N/A = #YOK :)
(***) critical
BABACAN 14 years ago
I made a simple change to the calculation by increasing the size of a load which triggered a recalculation and the return of the #NA errors just as I had seen in Excel 2010. A #N/A error which occurs when a value is not available to a function or formula. Have you got a special toolpak loaded into Excel like the analysis toolpak or the solver add-in? Or are you aware of any special functions calls?
BABACAN 14 years ago
Originally I opened the file with Excel 2010 and saw the #NA errors. Following your post I decided to open the file in Excel 2003 and it worked perfectly. I am really quite amazed with what you have achieved here BABACAN. It is a joy to use. I particularly like how you display member shear force and bending moments. Your marvellous spreadsheet seems to be full of Excel tricks and wizardry. I am enjoying going through it just to work out how you pulled it all together. I would like to thank you again for uploading this exemplary excel calculation. Bravo!
JohnDoyle[Admin] 14 years ago
This is a fantastic worksheet. Every Engineer should grab a copy.
BABACAN 14 years ago
Mr John Doyle
#N/A I do not understand what it is.
I have prepared as fully explained.
Thank you for your interest.
Note: I do not work for awards.
BABACAN 14 years ago
BABACAN this looks to be a superb spreadsheet and I am delighted to award you with a free XLC Pro(12M) subscription. I do have a few things to point out:
1) I see that the spreadsheets are protected but they can be unprotected without entering a password.
2) Row and column headings are hidden.
3) I have not figured out a way to see the results page. All I have in cells is a #N/A error which occurs when a value is not available to a function or formula. This confuses me a little because you say that no macros are used?
I would be grateful if you could help me get up and running with the spreadsheet.