Member Login

Like this Page?

Follow Us

Our Feeds

Contact Us
post/email

Forum or Email
telephone

US +1 617 5008224
telephone

EU +44 113 8152220
telephone

Toll Free: Skype

Live Chat

Total Downloads

182682

Our Services

ï»¿

Home

Repository

Strength

Beams

TORSION9.xls

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

ExcelCalcs Lego-Like Way to Engineering

Like a child selecting parts to construct a Lego model engineers bring together blocks of science to create new designs. These building blocks could be a load calculation, a beam calculation, a weld calculation, a fatigue calculation or any other calculation from a myriad of engineering topics. As...

iPhone, Android and Mobile Device Access

The site is optimised for browsing on mobile devices like the iPhone or Android phones. To create a web app icon browse to http://www.excelcalcs.com/navigate/ and ‘Add to Home Screen’. You will find an icon much like an app icon on your home screen which will bring you straight back...

ExcelCalcs Trailblazers

I have been chasing up feedback from new users signing up to XLC Pro accounts in the last month. I am delighted with their positive feedback. “I started using XLC but I am now insisting that my whole team use the add-in .“ “It is a great tool for validation and pres...

Increasing Engineering Confidence

Engineering training - “I run a team of engineers and whilst there are plenty of soft options for training expounding the latest management techniques there is precious little to develop the engineering skills of my team”. This is a familiar story we hear from clients of our trai...

Join our Corporate Partners Scheme

You are probably familiar with our tools of mass knowledge distribution on our website but ExcelCalcs also works more closely with corporate partners providing engineering training and engineering consultancy services. What’s more these services and ExcelCalcs subscriptions are availa...

Introducing ExcelCalcs eFormulas

ExcelCalcs eFormulas aims to replace traditional engineering formula books providing innovative functionality to copy from our webpages and paste directly into Excel. Once in Excel it is easily edited to suit your own problems this functionality is far more flexible than 'stuck on the web'&n...

Deciphering Spreadsheets with XLC

At some time or other you will have been given someone else’s spreadsheet only to be left scratching your head not having a clue as to what the calculation is doing. If you are wise you will not use it because you can’t understand it. If you are wiser still you’ll use our...

Make Amazing Calculations

In our good calculation guide we emphasise the importance of sketches in calculations but you can produce interactive 3D wireframe sketches by incorporating Turan Babacan’s latest upload. Turan uses 3D charts to great effect in his Excel FEM programs. Andy Pope also has a 3D chart spr...

Coming Soon XLC Ribbon

A new version of XLC is in the final stages of development which will be compatible with the 64 bit version of Excel 2010 (currently it works with the 32 bit version of Excel 2010, 2007 2003 and 2000). We’ll keep you posted with progress. Please send us details of any features you ...

TORSION9.xls

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:

"TORSION9" SIMPLIFIED TORSION ANALYSIS FOR STEEL BEAMS

Program Description:
"TORSION9" is a spreadsheet program written in MS-Excel for the purpose of simplified analysis and code checking of steel beams subjected to torsional loading. Specifically, six (6) different beam and loading configurations can be analyzed / code checked per the AISC 9th Edition Allowable Stress Design (ASD) Manual. Both actual and allowable stresses are computed, with the final result being a computed "stress ratio" of actual stress/allowable stress. Finally, the total angle of twist resulting from the torsional loading is determined.
This program is a workbook consisting of seven (7) worksheets, described as follows:
Cantilever - Ecc. Conc. Load = Cantilever Beam with Eccentric Concentrated Load at Free End
Simple Span - Ecc. Conc. Load = Simple Span Beam with Eccentric Concentrated Load Applied at Midspan
Cont. Span - Ecc. Conc. Load = Continuous Beam with Eccentric Concentrated Load Applied at All Midspans
Cantilever - Ecc. Unif. Load = Cantilever Beam with Eccentric Uniformly Distributed Load
Simple Span - Ecc. Unif. Load = Simple Span Beam with Eccentric Uniformly Distributed Load
Cont. Span - Ecc. Unif. Load = Continuous Beam with Eccentric Uniformly Distributed Load on All Spans

Program Assumptions and Limitations:
1.   The simplified torsion analysis used is this program is based on the following reference: USS Steel Design Manual (1981), Chapter 7: Torsion (Figures 7.9 & 7.10, pages 157-169), by: R.L. Brockenbrough & B.G. Johnston
2.   This program is valid for AISC W, S, M, and HP shapes.
3.   This program uses the database of member dimensions and section properties from the "AISC Shapes Database", Version 3.0 (2001) as well as the AISC 9th Edition (ASD) Manual (1989).
4.   This program follows the procedures and guidelines of the AISC 9th Edition Allowable Stress (ASD) Manual (1989).
5.   When the value of 'Lb' is input = 0 (or actually <= 1.0 ft.), this program will use a value = 1.0 ft.
6. This program utilizes an "Allowable Stress Increase Factor" (ASIF) which is a multiplier of any of the calculated allowable stresses Fa, Fbx, and Fby and also the Euler column buckling stresses F'ex and F'ey. It is used and appears ONLY in the stress ratio calculation. Typically a value of 1.0 may be used. However, a value of 1.333 may be used for load combinations which include wind or seismic loads.
7. This program does not calculate or check shear or deflection in member
8. This program does not consider deduction for holes in members subjected to tension.
9. 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".)

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 On:

29 May 2009

Submitted By:

ATomanovich

File Date:

29 May 2009

File Author:

Alex Tomanovich

File Version:

1.0

File Size:

801.00 Kb

File Type:

xls

Downloads:

206

Rating:

Total Votes:2

Like this?:

More submitted by this user.

HTML Link:

Copy code below to your web page to create link to this page:

HTML Window:

Copy code below to your web page to create a dynamic window to this download:

Comments

#1 sumnerdave 2009-05-29 13:27

If only you had submitted this spreadsheet two weeks ago! This is a wonderful addition. USS Steel Design Manual (1981) is out of print and, currently, there is only one copy available. Thanks again, Alex!

Refresh comments list
RSS feed for comments to this post

Please sign in or register to add a comment.

JComments

Member Login

Who's Online

Total Downloads

Our Services

TORSION9.xls

Comments