"BEAMANAL.xls" is a MS-Excel spreadsheet workbook for the analysis of single-span beams (simple, propped, fixed, or cantilever) and continuous beams of up to 5 spans. The user may apply point, uniform, and varying loads, as well as applied moments. Shear, moment, slope (rotation), and deflection are computed as well as the end reactions. Shear and moment diagrams are also plotted. There is an addtional worksheet for single-span beams that also performs AISC 9th Edition Code checks for strong-axis bending (only) as well as shear.
All the worksheets are independent and self contained, so that you can move them from one workbook to another. All the worksheets are protected, but not with a password.
Please read the "DOC" worksheet for program details as well as assumptions and limitations.

Metric version is also available .

Calculation Reference
AISC | Find on | Find on | Find on | Find on | Find on |

Calculation Preview

09 Oct 2009
Last Modified
09 Oct 2009
File Size:
3,733.50 Kb
File Version:
File Author:
Alex Tomanovich

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
JohnDoyle[Admin] 10 years ago
There are some files here and here that may be useful regarding Centrifugal acceleration and forces.
mofsubic 10 years ago
Thanks again, I had already signed up for a membership. Do you have any centrifugal spreadsheets, I want to use it for truckloads going around corners. I calculate the XY center now and than do it manually . I use the axle center and the CG elevation for the overturning. Cheers
ATomanovich 10 years ago
I'm glad it's been cleared up for you now. By the way, the 2 places for input off of the worksheet to the right are merely to allow the user to select either one or two optional locations along the beam span that may not be defined by either point loads, point moments, or the 50 beam segments.
Thanks for the offer, but I have always freely shared all of my spreadsheets. It's my way of giving back to my profession, which has been good to me. However, I'm sure that John would appreciate you either purchasing a membership or donating your own work to this website. The more people that contribute, the better it is for us all.
mofsubic 10 years ago
Dear ATomanovich:
Sorry for the last request. I now understand, And the numbers match.
You report will be very helpful and is great, I now understand.
Question: Can I only donate to the site or can I donate to your programs.
mofsubic 10 years ago
Dear ATomanovich:
Thank you for you response. I went to the side and the note says to add 2 additional points from the left. Since I have only 1 offset point, this would not be applicable.
The other formula is the single offset formula for beam bending ( non center). Using that formula and this input the, bending results, are different. Again I thank you for your time. Please again explain if possible
ATomanovich 10 years ago
I believe that you're not clear as to what my "BEAMANAL.xls" spreadsheet is displaying for results. The spreadsheet determines and displays the MAXIMUM deflection in the span. In your case of a simply supported beam with a concentrated load at ANY point between the supports, the formula is for the deflection at the location of the load. For a load not at mid span of the beam, the maximum deflection is not at the load point. The deflection is only the maximum when the load is at mid span. If you'll go off to the right of the calculation page, you can user input any location for the results to be determined, and if you input the distance as the distance to the non-centered load, you will get the correct deflection at the load location.
mofsubic 10 years ago
I am using \delta =\frac { Fa^{ 2 }(L-a)^{ 2 } }{ 3EIL } to compare
mofsubic 10 years ago
I used another the formula for "Intermediate load on beam with two simple supports" it does not match the results with your Sheet using Point loads (a) (P) Kips
I am using the attached formula to compare
SET 11 years ago
This, like the rest of your work, is a real time saver.
JohnDoyle[Admin] 11 years ago
All you need to do is use Alex's spreadsheet and select the multiple span tab. Make a three span beam with the left & right hand end spans cantilevered. I think this will give you the flexibility you need.
ATomanovich 12 years ago
I do have a metric units version. Look for the file BEAMANAL (metric).xls under Strength / Beams on this website.
AndrewLivingstone 12 years ago
First lass
But can we have this using SI units ?
ATomanovich 12 years ago
Ah ok ok, I get it!!!, your workbook is great. I use it in many of my works. Thanks a lot Mr. Tomanovich.
ATomanovich 12 years ago
Be patient! The default number of spans is = 2 when I distribute this workbook. Thus, if you input a number of spans, say 3, which is greater than the already existing data for each span length and moment of inertia, it will "TEMPORARILY" display the #DIV/0 error message, since "L" and "I" have not yet been defined for anything greater than 2 spans. Once you have defined "L" and "I" for every span of your continuous beam, then the error messages will disappear. In summary, the input data for the number of individual beam spans needs to be consistent with the number of spans selected.
ATomanovich 12 years ago
Hello Mr. Atomanovich!
I have a similar problem in the in the "Continuos-Span Beam" worksheet of the "BEAMANAL.xls. I discovered that if I select a No. of Spams greater than 2, the program give a "#DIV/0" error message for the results of support moments and reactions.
I don't know if I'm using the sheet in a incorrect way or in fact there is a mistake in the sheet.
I'll appreciate your response and support. Thank you very much.
ATomanovich 14 years ago
Mangla 14 years ago
no use in my present subscription. ADMIN> You need an XLC Pro subscription to download - this can be paid for or earned by donating a calculation.
ATomanovich 14 years ago
In each of the calculation worksheets in the "BEAMANAL.xls" workbook, I added the plots for both the slope (rotation) and deflection diagrams to compliment the shear and moment diagrams that were already included. This workbook is now version 2.5.
ATomanovich 15 years ago
I made a minor change to the "Code Check" worksheet of the "BEAMANAL.xls workbook.
Similar to the change that I made in some of the other workbooks related to structural srteel design, I removed the input data validation which originally limited the user to specific values of Fy =33, 36, or 50 ksi.
The updated workbook is now version 2.4.
Alex Tomanovich, P.E.
rfireman 15 years ago
very helpfull. I enjoyed working with this spread sheet. Thanks Alex.
ATomanovich 15 years ago
ATomanovich 15 years ago
An input data validation "glitch" was discovered in the "BEAMANAL.xls" spreadsheet workbook.
In the user input data cells for distributed/partial distributed loads, my original intent was to place input data validation on the user input values of the end distances, "e", for the distributed loads, such that "e" must be >= "b", which would prevent the user from entering bogus values for "e". The input data validation for the "e" values should have each been tied to the appropriate cell for the beginning distance, "b". Problem was, I had all of the "e" distance cells tied to the "b" distance for only the first distributed load. I have made the corrections in the worksheets as required.
The workbook is now version 2.3.
ATomanovich 16 years ago
In the "Single-Span Beam & Code Check" worksheet of the "BEAMANAL.xls"
workbook, it was discovered that if the user selected a channel shape and input a value = 0 for the unbraced length (Lb) for bending, the program would give you a "#DIV/0" error message.
This has now been corrected. What the program does is check if the user input value is <= 1' and if so it uses a value of Lb = 1'. I had already used this same logic for the W and S shapes in the beam size selection pick box, but obviously forgot to use it for channels as well. Of course, there was always the work around of inputting a small value > 0 for the unbraced length.
ATomanovich 16 years ago
Since all the units are consistent I think it would be easy to generate a metric version of this calculation. I you do please upload a copy for everyone to share. If you want a quick work around you might like to use the ChangeUnits add in for Excel. Thanks for your comments DvdHntr.
ATomanovich 16 years ago
It is a good spreadsheet but like so many not in metric so not useful and efficient for non American Engineers.