Spreadsheets and Databases: Structural Design

Showing posts with label Structural Design. Show all posts

Sunday, 28 June 2015

Post Footing Design : Rutledge Formula

{Draft: thought I'd uploaded this already}

The spreadsheet can be downloaded free of charge from MiScion Pty Ltd: Rutledge.xls

Post Footing Design : Pocket Footing

{Draft: Thought I'd uploaded this already}

Spreadsheet can be downloaded free of charge at Miscion Pty Ltd : PocketFooting.xls

Thursday, 11 June 2015

Wind Loads on Doubly Pitched Building to Australian Wind Code

Taken from the ExcelCalcs.com website.

Related Posts:

Bundle of my ExcelCalcs UpLoads

The bundle can be downloaded from MiScion Pty Ltd : Spreadsheet Bundle

Wednesday, 14 January 2015

EngineLT revised to Current Wind Code

A revised version of my EngineLT application for estimating size of frames for doubly pitched moment frames, typically used in cold-formed sheds. The orginal version was written in Delphi 3 to AS1170.2:1989, the current version is written in vb.net to AS1170.2:2011. The change in language is because I use MS Excel for day to day calculations, with schTechLIB.xla in the background providing functions for wind loading, steel, cold-formed steel, and timber design. This is written in vba and kept up to date, whilst the Delphi code not kept up to date: to avoid translating languages moved over to vb.net.

The revised version of the code reads an XML data file, this file contains names of structural sections and the resistance to bending (phi.Ms) in units of kNm. The file can be added to if needed, it already contains, Cee's, RHS, SHS, UB, UC, PFC's.

It doesn't contain back to back Cee's, such are not really required. As far as the program is concerned the bay spacing is the load width of the individual portal frame. The load width of a frame can be found by halving the distance to each frame either side of the selected frame and summing. For cold-formed steel sheds with frames at 3m centres the load width of a typical frame is 3m. The load width of the end frame is 1.5m. Often for sheds made from hot rolled steel the typical frames are UB's with the end frames made from PFC's: not always practical has it hinders extending the building, and there is extra detailing merely for two frames. Any case it gives the basic idea, the internal frames can be I-sections formed from back to back Cee's and the end frame can be a single Cee. Knowing that a single Cee has a load width of 3m, then back to back Cee's form a frame with a total load width of 6m, the back-to-back frames can therefore be placed at 6m centres, whilst a single Cee can be used for the end frame. Therefore check frame for load width of 3m (bayspace = 3m) for a single Cee rather than the back-to-back Cee's at 6m centres.

It is also to be noted that whilst a given section may be structurally strong enough, it may not be practical to make an adequate moment connection between the rafter and column.: such check is not made by the application. Other issues not checked are the deflections of the frame.

The prime purpose of the application is to determine what is not suitable and reject immediately, whilst that considered suitable by the application requires further structural design.

To keep the input form simple, there are many assumptions made in the background. The assessment made by the application will not match my height/span charts as I adopted internal pressure coefficients of -0.65 and +0.7 for this application, but -0.3 and +0.4 for the charts.

I have a larger Engine application, which I am in the process of also translating from Delphi to vb.net and from AS1170.2:1989 to AS1170.2:2011, makes fewer assumptions but has more input screens and requires connection to a database of section properties, it also generates scripts (.scr) for AutoCAD LT. The original purpose of EngineLT was to severe the original programme from the Borland Database Engine (BDE), as it seemed far too complicated setting up on some other computer.

The application can be obtained here: vbEngineLT.zip

Revisions:

[14/01/2015] Original
[23/04/2016] Changed downlinks to MiScion Pty Ltd web Store

Simple Wind Loading Application: Speeds, Pressures and Pressure Coefficients

A simple application for getting wind speeds, pressures and pressure coefficients to AS1170.2 for a rectangular enclosed building with doubly pitched roof. There are two versions in the zip file download. tstwnd.exe and windyworkBench.exe. The former was written in Delphi 3 to AS1170.2:1989, whilst the latter is written in vb.net to AS1170.2:2011.

Application can be down loaded: windWorkBench.zip

Revisions:
[14/01/2015] Original
[23/04/2016] Changed download links to MiScion Pty Ltd Web Store.

Wednesday, 20 August 2014

Second Moment of Area of Built Up Section

A small spreadsheet for calculating the section properties Ixx, Zxx and phi.Ms of a simple built up section. It is set up for calculating the properties for two round bars spaced a known distance apart.

BuiltUpSection.xls

Revisions:
[20/08/2014] Original
[23/04/2016] Changed download links to MiScion Pty Ltd Web Store

Pages

Sunday, 28 June 2015

Post Footing Design : Rutledge Formula

Post Footing Design : Pocket Footing

Thursday, 11 June 2015

Wind Loads on Doubly Pitched Building to Australian Wind Code

Wednesday, 14 January 2015

EngineLT revised to Current Wind Code

Simple Wind Loading Application: Speeds, Pressures and Pressure Coefficients

Wednesday, 20 August 2014

Second Moment of Area of Built Up Section

Tuesday, 17 June 2014

Automatic Explosion of Single Level Bill of Materials into full Product Tree

More Bill of Materials Worksheets

Simple indented bill of materials worksheet

Experimenting with MS Excel Shapes layer to Draw Shed Framing Plans

Automatic generation of 3D stick diagram of American Barn style Shed

Automatic Generation of Shed framing Plans using Excel and Acad LT

Hole Punching Sheets for Cold-formed Sections

Component Lengths for Cold-formed Steel Shed with Gable Roof

Technical Library Structural Design

Strength of Bolted Joints in Cold-Formed Sheet Metal to AS4600

Structural Materials Data for Timber Design to AS1720

Structural Materials Data

Application to Generate Height versus Span Charts for Gable Frame

Wind Loads on Doubly Pitched Enclosed Building to AS1170.2