Application for Generation of Height Span Charts Gable Frame Sheds

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


Excel/VBA Application used to generate height versus span charts for the limiting capabilities of structural sections used for gable frame sheds. Wind loading is to Australian code AS1170.2. Dimensions of frame can be changed along with most of the wind loading parameters, via the use of dialogue boxes. To change the structural sections used will have to change the VBA code.

WARNING: when run it takes about 20 minutes to generate one Excel XY chart, with several different height span curves.

NB: The opptional multiframe procedures will only work if have multiframe and provide a VBA reference to the multiframe COM object. The microstran procedures are suffering from improved feature: they don't appear to be working. I have other work books for that purpose. The span tables are working. Install into shared documents folder, and exelcalcs subfolder, and then a further subfolder schDesignEngineR01. DesignEngine is the main file, just press the big button and follow the dialogue boxes.

Calculation Reference
Excel VBA
| Find on | Find on | Find on | Find on | Find on |
Austrailian Building Code
| Find on | Find on | Find on | Find on | Find on |
Structural Analysis Of Frames
| Find on | Find on | Find on | Find on | Find on |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. 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:
05 May 2010
Submitted By:
File Date:
02 May 2010
File Author:
Conrad Harrison
File Version:
File Size:
1,121.06 Kb
File Type:
stars/4.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.


#4 InfoJunkie65 2013-06-13 01:18
Quoting sendebad:
pls. I need analysis for culvert with fixed end moment method.

Hi Sendebad,

Not sure how I can help. To me a culvert is typically a concrete u-channel, placed upside down to form a small bridge over a open drainage channel and often comes with a flat base which it sits on. So wouldn't consider it having a fixed base, probably not even a pinned base has it can slide sideways. Though being earth covered the outwards sideways movement is partially constrained. But the soil loads it and pushes it inwards.

Anycase my Kleinlogel spreadsheet has some formula for rectangular portals.

I have also uploaded extracts from Kleinloogel rigid frame formula on scribd.

It mainly lists the frames, so that get idea of what is in the book. Unfortunately at moment in the middle of office move so all my books are packed, so would be a few weeks before I can scan anything.

Roarkes formulas is another good place for rigid frame formula, and more readily available than Kleinlogel.

#3 sendebad 2013-06-12 09:40
pls. I need analysis for culvert with fixed end moment method.
#2 InfoJunkie65 2011-07-03 13:19
Some links to charts generated by the application:

Wind TC3 to AS1170.2

Wind TC2 to AS1170.2

Full range of design charts for TC3, with variable frame spacing:

Also link to Linked In group for discussing other issues related to such buildings:
#1 arul12345 2010-05-02 08:36

Please sign in or register to add a comment.

We have 3 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