BEAMANAL.xls

Rating:
31

Description


"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 Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Calculation Preview

Submitted On:
09 Oct 2009
File Size:
3,733.50 Kb
Downloads:
2836
File Version:
2.5
File Author:
Alex Tomanovich
Rating:
31

 
This download is for Registered Users Only.
Perhaps you need to login or register.
Comments: 28
JohnDoyle[Admin] 6 years ago
There are some files [url=/repository/dynamics/motion/generalised-motion-solver.xls/]here[/url] and [url=/repository/dynamics/single-dof/centripetal-force-and-acceleration.xls/]here[/url] that may be useful regarding Centrifugal acceleration and forces.
mofsubic 6 years ago
Alex:
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 6 years ago
mofsubic,
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.
Alex
mofsubic 6 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 6 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 6 years ago
mofsubic,
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.
Alex
mofsubic 6 years ago
[quote name="mofsubic"]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 \delta =\frac { Fa^{ 2 }(L-a)^{ 2 } }{ 3EIL } to compare
mofsubic 6 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 7 years ago
Alex,

This, like the rest of your work, is a real time saver.

Thanks,

Steve
JohnDoyle[Admin] 7 years ago
All you need to do is use [url=http://www.excelcalcs.com/component/option,com_remository/func,fileinfo/id,255/]Alex's spreadsheet[/url] 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 8 years ago
Andrew,
I do have a metric units version. Look for the file BEAMANAL (metric).xls under Strength / Beams on this website.
Alex
AndrewLivingstone 8 years ago
First lass

But can we have this using SI units ?
ATomanovich 8 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.
Oscar
ATomanovich 8 years ago
Oscar,
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.
Alex
ATomanovich 8 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 10 years ago
good
Mangla 10 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.
Mangla 10 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 10 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 11 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 11 years ago
very helpfull. I enjoyed working with this spread sheet. Thanks Alex.
rfireman 11 years ago
very helpfull. I enjoyed working with this spread sheet. Thanks Alex.
ATomanovich 11 years ago
Thanks.
ATomanovich 11 years ago
Thanks.
ATomanovich 11 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 12 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 12 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 [url=/component/option,com_remository/Itemid,36/func,fileinfo/id,211/]ChangeUnits add in for Excel[/url]. Thanks for your comments DvdHntr.
ATomanovich 12 years ago
It is a good spreadsheet but like so many not in metric so not useful and efficient for non American Engineers.