XBRACING.xls
 

Description:

"XBRACING" is a spreadsheet program written in MS-Excel for the purpose of analyzing X-braced bents with tension-only systems.  From 1-story up to 10-story bents may be analyzed.  Specifically, given the bent width, the story heights, and the lateral story loads, all the member (segment) forces are determined, as well as the horizontal and vertical reactions at the supports, and the individual story drifts (horizontal deflections).

This program is a workbook consisting of eleven (11) worksheets, described as follows:

• Doc - Documentation sheet
• X(1) - Analysis of 1-story bent with tension-only X-bracing
• X(2) - Analysis of 2-story bent with tension-only X-bracing
• X(3) - Analysis of 3-story bent with tension-only X-bracing
• X(4) - Analysis of 4-story bent with tension-only X-bracing
• X(5) - Analysis of 5-story bent with tension-only X-bracing
• X(6) - Analysis of 6-story bent with tension-only X-bracing
• X(7) - Analysis of 7-story bent with tension-only X-bracing
• X(8) - Analysis of 8-story bent with tension-only X-bracing
• X(9) - Analysis of 9-story bent with tension-only X-bracing
• X(10) - Analysis of 10-story bent with tension-only X-bracing

Program Assumptions and Limitations:

1.   This program assumes that the vertical bent is fully braced, between every story, utilizing a tension-only X-bracing system.

2.   In a tension-only bracing system, one brace is assumed effective in tension while the other brace is assumed to buckle (in compression), requiring the tension brace to take all of the load.

3.   This program uses the "Method of Virtual Work" to determine the horizontal deflections at each of the story levels.  The horizontal deflection at a particular story level is determined by first applying a "dummy" unit load at that level.  Then, the member forces from the unit load are determined.  With the member forces due to the applied lateral loads already having been calculated, the horizontal deflection at that story level is:
Dn = S F*u*L/(A*E)
where:Dn = horizontal deflection at particular story level number considered (inches)
      F = force in each member due to all applied lateral story loads (kips)
      u = force in each member due to unit load applied at paricular story, 'n'
      L = length of each member in bent (inches)
      A = area of each member in bent (in.^2)
      E = modulus of elasticity of members in bent, all assumed equal (ksi)
The horizontal deflections (story drifts) determined are for the joints at the left side of the bent, with all members (segments) assumed pinned at both ends.

4.  This program contains “comment boxes” which contain information including explanations of input or output items, equations used, 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".)

Calculation Reference
AISC
| 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 On:

12 Sep 2008

Submitted By:

ATomanovich

File Date:

12 Sep 2008

File Author:

Alex Tomanovich

File Version:

1.1

File Size:

1,124.50 Kb

File Type:

xls

Downloads:

537

Rating:

Total Votes:11

Like this?:

More submitted by this user.

HTML Link:

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

<a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=272">ExcelCalcs.com calculation XBRACING.xls</a>

HTML Window:

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

<span style="font-size: 8pt">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=272">ExcelCalcs.com</a> website.<br /></span><iframe id="ExcelCalcsSample272" name="ExcelCalcsSample272" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=272" align="top" scrolling="auto" height="650" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>

Comments  

 

#2 tooeasy 2008-09-30 08:12

Alex Rocks!

 

 

#1 MSH 2008-09-09 16:16

After I used, benefited, and enjoyed your spreadsheets, finally I found the time to say, "Thank you".

 

Refresh comments list
RSS feed for comments to this post

Please sign in or register to add a comment.

JComments