Wind Loads on Gable Frame to Australian Wind Code AS1170.2

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


Use workbook to check or manually generate Height/Span limit charts for coldformed c-sections or other sections, using AS1170.2 and Kleinlogel rigid frame formula (Frame III SCI steel designers manual 5th edition).

Or simply use to get the wind loads on the on doubly pitched enclosed buildings to AS1170.2. Calculates External pressure coefficients on each surface of building.

Is dependent on:

  1. AS4045.xls
  2. schStruMtrl.xls
  3. schTechLIB.xla

To reduce number of links I have to update, I have deleted member checks to AS4600, and connection design.

As I fix up the links, for use by ExcelCalc's users I will upload more complete version.

Submitted On:
18 Jan 2016
Submitted By:
File Date:
01 May 2010
File Author:
Conrad Harrison
File Version:
File Size:
231.50 Kb
File Type:
stars/2.gifTotal Votes:4
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:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#3 InfoJunkie65 2016-09-25 06:46
Have prepared a blog post with general information on setting up MS Excel environment for using my spreadsheets. Activating the add-in, updating the links, and making modifications which may be caused by using other versions of Excel. The spreadsheets are created in Excel 2003, the post is based on opening files in Excel 2016.
#2 InfoJunkie65 2012-01-31 09:27
Uploaded sample printout at scribd:

The spreadsheet can be used for calculating design wind speed, considering 8 cardinal directions and determine the pressure coefficients on a doubly pitched low rise building (house, shed etc.) If don't want the rigid frame analysis just ignore it, just use that which as application across most projects.
#1 asafory 2010-11-20 17:23
goooooooooooooo ooooooooooood

Please sign in or register to add a comment.

We have 2 guests and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics