Member Login

Contact Us
telephone

US +1 617 5008224
telephone

EU +44 113 8152220
telephone

Toll Free: Skype
post/email

Forum or Email
Like this Page?

Follow Us

Our Feeds

Total Downloads

232110

Our Services

ï»¿

Home

Calculations

Strength

Beams

^{Signup Now!}Subscribe, login and start downloading. ^{Latest Calculations!}Follow us on Twitter.

RSS

Beams RSS

Files

Page: 1 2 3 4 5 6 7 8 Next »

AASHTO LRFD Slab.xls

Short Description:

AASHTO 2004 LRFD SLAB DESIGN: This spreadsheet was created to aid in the rapid design and/or checking of Bridge Decks or Reinforced Concrete Boxes in accordance with AASHTO 2004 LRFD. The 2nd Bar layer is particularly handy for different bar sizes used in the same layer, such as in Bridge Deck Cantilevers.

Version History

Check the version history to see how this calculation has changed over time. (subscribe to this topic to be notified of changes).

Submitted By:

b1akeh

Submitted On:

29 Jan 2008

Downloads:

1625

Rating:

Total Votes:24

ACI318-08 RC Beam

Short Description:

Calculation Preview

Analysis and design of rc beam as per ACI318-08.

Version History
Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted By:

RichardFernandez

Submitted On:

24 Nov 2011

Downloads:

143

Rating:

Total Votes:6

ALUMINUM DESIGN CAPACITY

Short Description:

Calculation Preview

This sheet will help you design structural and architectural pipe on your building construction whether it is residential, commercial & plant projects. It optimizes the pipe design so that designer can attain the effective, efficient, safe and economical sizes of aluminum pipe.

STRUCTURAL DESIGN

Submitted By:

mdelacua5

Submitted On:

29 Aug 2012

Downloads:

121

Rating:

Total Votes:9

ALUMINUM RECTANGULAR TUBE DESIGN

Short Description:

Calculation Preview

This sheet will help you design structural and architectural tube on your building construction whether it is residential, commercial & plant projects. It optimizes the aluminum tube so that designer can attain the effective, efficient, safe and economical sizes of aluminum rectangular tube.

Submitted By:

mdelacua5

Submitted On:

29 Aug 2012

Downloads:

Rating:

Total Votes:4

Beam Design Functions.zip

Short Description:

Elastic Analysis of Reinforced and Prestressed Sections

The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis:

For a cross section with any applied axial load at eccentricity e, measured from the compression face, and depth of the neutral axis X below the compression face:

INA = QNA(X + e)

Where QNA and INA are the first and second moments of area about the neutral axis.

To illustrate this relationship the value of INA has been plotted for a range of neutral axis positions for a typical precast bridge beam, shown below, and compared with the value QNA(X + e) for 5 different values of e.

The intersection of the INA and QNA(X + e) lines gives the depth of the neutral axis for the corresponding value of load eccentricity, e. This is illustrated in the second graph, where the value of (INA - QNA(X + e)) is plotted against the depth of the neutral axis, X, for a load eccentricity of 1 metre above the compression face. The intersection of this line with the X axis gives the depth of the neutral axis for the specified load eccentricity.

Note: Another calculation file ULS Design Functions.zip contains User Defined Functions (UDF’s) that will find the ultimate bending capacity of any reinforced or prestressed concrete section

Version History

Check the version history to see how this calculation has changed over time.

Submitted By:

DougJenkins

Submitted On:

20 Aug 2008

Downloads:

282

Rating:

Total Votes:4

Beam Moment and Shear

Short Description:
Submitted By:: sonicboomman2008
Submitted On:: 11 Jul 2014
Downloads:: 19
Rating:: Total Votes:0

Beam with stress.xls

Short Description:: This is a modification to an Alex Tomanovich spreadsheet (Thanks Alex) for bending in a single-span beam. I added a few additional beam shapes and the option to input user defined moment of inertia and section modulus. I also added an input for allowable stress, calculations for bending stress in the beam, and the stress ratio.
P.S. As was the case with the original sheet by Alex, the sheet is protected, but there is no password.

Calculation Reference
Beam calculation
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Structural analysis
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Version History
Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.
Submitted By:: NewMechEngr
Submitted On:: 16 Feb 2009
Downloads:: 511
Rating:: Total Votes:11

BEAMANAL (metric).xls

Short Description:: "BEAMANAL" is a spreadsheet program written in MS-Excel for the purpose of analysis of either single-span or continuous-span beams subjected to virtually any type of loading configuration. Four (4) types of single-span beams and two (2) through (5) span, continuous-span beams, considered. Specifically, beam end reactions as well as the maximum moments and deflections are calculated. Plots of both the shear and moment diagrams are produced, as well as a tabulation of the shear, moment, slope, and deflection for the beam or each individual span.
Note: this is a metric units version of the original "BEAMANAL.xls" spreadsheet workbook.

This program is a workbook consisting of three (3) worksheets, described as follows:

Worksheet Name
Doc - This documentation sheet
Single-Span Beam - Single-span beam analysis for simple, propped, fixed, & cantilever beams
Continuous-Span Beam - Continuous-span beam analysis for 2 through 5 span beams

Program Assumptions and Limitations:
1.   The following reference was used in the development of this program (see below): "Modern Formulas for Statics and Dynamics, A Stress-and-Strain Approach" by Walter D. Pilkey and Pin Yu Chang, McGraw-Hill Book Company (1978), pages 11 to 21.
2.   This program uses the three (3) following assumptions as a basis for analysis:
          a. Beams must be of constant cross section (E and I are constant for entire span length).
          b. Deflections must not significantly alter the geometry of the problem.
          c. Stress must remain within the "elastic" region.
3.   On the beam or each individual span, this program will handle a full length uniform load and up to eight (8) partial uniform, triangular, or trapezoidal loads, up to fifteen (15) point loads, and up to four (4) applied moments.
4.   For single-span beams, this program always assumes a particular orientation for two (2) of the the four (4) different types. Specifically, the fixed end of either a "propped" or "cantilever" beam is always assumed to be on the right end of the beam.
5.   This program will calculate the beam end vertical reactions and moment reactions (if applicable), the maximum positive moment and negative moment (if applicable), and the maximum negative deflection and positive deflection (if applicable). The calculated values for the end reactions and maximum moments and deflections are determined from dividing the beam into fifty (50) equal segments with fifty-one (51) points, and including all of the point load and applied moment locations as well. (Note: the actual point of maximum moment occurs where the shear = 0, or passes through zero, while the actual point of maximum deflection is where the slope = 0.)
6.   The user is given the ability to input two (2) specific locations from the left end of the beam to calculate the shear, moment, slope, and deflection.
7.   The user is also given the ability to select an AISC W, S, C, MC, or HSS (rectangular tube) shape to aide in obtaining the X-axis moment of inertia for input for the purely analysis worksheets.
8.   The plots of the shear and moment diagrams as well as the displayed tabulation of shear, moment, slope, and deflection are based on the beam (or each individual span) being divided up into fifty (50) equal segments with fifty-one (51) points.
9.   For continuous-span beam of from two (2) through five (5) spans, this program utilizes the "Three-Moment Equation Theory" and solves a system simultaneous equations to determine the support moments
10. This program contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc. (Note: presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the desired cell to view the contents of that particular "comment box").
A US imperial version of this file is available.
Calculation Reference
Beam calculation
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Structural analysis
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Version History
Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.
Submitted By:: ATomanovich
Submitted On:: 09 Oct 2009
Downloads:: 495
Rating:: Total Votes:16

BEAMANAL.xls

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

Submitted By:

ATomanovich

Submitted On:

09 Oct 2009

Downloads:

2545

Rating:

Total Votes:30

beams.xls

Short Description:

Finite element beam solver based from the excellent www.gowelding.com
Theory fully explained on the gowelding site .
The gowelding site is run by John Dyson. He is a Chartered Engineer involved in the design and commissioning of pressurised plant and equipment. He is also a registered European Welding Engineer. The purpose of this web site is to share technical information in the field of welding and welding related activities. It has no affiliation to any organisation or company

Version History

Check the version history to see how this calculation has changed over time. (subscribe to this topic to be notified of changes).

Submitted By:

JohnDoyle[Admin]

Submitted On:

02 Sep 2008

Downloads:

1182

Rating:

Total Votes:4

Page: 1 2 3 4 5 6 7 8 Next »

Search Repository

Submit File

Wabtec ExcelWraps Subdomain is Launched

We are delighted to launch wabtec.excelwraps.com from where Wabtec will be trialing wraps to monitor their rail overhaul business. Wabtec Rail undertakes the overhaul, refurbishment and conversion of all types of locomotive, passenger rolling stock and freight wagon bogies. Services includ...

Feedback from HitachiWraps Openday

HitachiWraps Open Day Feedback - We were very pleased to look through the positive comments in your feedback wraps. On Friday immediately after the event we were asked to present to the Unipart board so I guess it could not be more positive than this. A cross section of organisations across t...

HitachiWraps Open Day Wednesday March 12th 2014

The high speed Class 395 fleet services are orchestrated from the Hitachi Rail depot in Ashford. The management team have a vision of replacing clipboards with iPads so that the depot, their suppliers and clients can share live information. Hitachi engineers make spreadsheets wh...

Date to be Set for HitachiWraps Open Day

Introducing ExcelWraps

Just imagine if you could design your own App linked to a cloud data engine and working on any PC, tablet or smartphone……well now you can! You design your App in Excel. We make it device independent. We supercharge with our cloud data engine. You control access...

Training Courses For London Underground

"Thanks again for your excellent course this past week." "Thank you for the course last week, found it very interesting both from the perspective of a quick refresh, but also on how we can optimise the work we do." "Thanks for a very interesting and usef...

Try Excel 2013 for Free!

I am pleased to report that XLC Ribbon works with the 32bit and 64 bit versions of Excel 2013 obtained using the free Office 365 Home Premium Preview. Excel 2013 looks a little flat and dull compared to previous versions but I think this is the influence of the new Windows 8 'metro' look and f...

Introducing XLC the Ribbon Version

New!XLC Ribbon For the first time XLC works with both 32 bit and 64 bit versions of Excel with an enhanced Office Ribbon display. It is a much simpler installation process than the previous Toolbar versions so you can be up and running in no time at all. ...

ExcelCalcs Bites the Bullet!

Hitachi have recently been awarded the largest ever UK rolling stock order and they’ll be bringing their Shinkansen bullet train technology to Europe. In August ExcelCalcs braved the stifling Japanese heat to deliver their ‘Fatigue of Welded Structures’ course to Hitachi b...

Member Login

Who's Online

Total Downloads

Our Services

Beams RSS

Files