pacorder

Steel Design - AS 4100

2011-12-14T13:33:00.000-08:00

The following document, is a summary and also a manual of the code AS 4100. But it is better than that, since also includes fully examples of frames, columns and connections. The latter, the mos I like it. The examples are quite straightforward and well explained.
Regarding connections you can find, for example, plate design, moment connections, flexible and rigid connections.

AS 4100 Steel Design Manual

References:
CSIBerkeley, SAP 2000
Brian Kirke
Iyad Hassan Al-Jamel

Cold Formed Steel Spreadsheet

2011-11-15T14:17:00.001-08:00

This spreadsheet can be used to calculate different sections of cold formed steel elements, regarding AS 4600 (Australian Standard). However can be extended to other international codes.

Reference: Spreadsheet from University of Melbourne (Design of Steel Structures and other materials)

Cold formed Spread sheet (AS 4600)

Australian Beams UB, UC, WB, PFC, RHS

2011-10-28T13:43:00.000-07:00

During the design of steel beams is convenient to have the properties of the range of beams available in Australia, which most of them comply with the requirements of beam compact sections.
This spreadsheet contains the steel beams supply by OneSteel, such as UB, UC, WB, PFC and others.
The main advantage of have the spreadsheet is that you can use MathCad or even Excel to have access to this data and import the sections automatically. How? Well, later we will see how. In my case I prefer use Mathcad to import all the properties, since is friendlier and clearer than Excel.

Australian AS 3600 Beams

Reinforced Concrete ACI 318-99

2011-09-12T04:19:00.000-07:00

ACI 318-99 can be seen as a quite old code, however its used doesn't lead to results too different. In fact, for a gross design the results are the same as those obtain using ACI 318-08.

The following spreadsheet shows the calculation of a rectangular beam 60x60cm, following the same example used for AS3600.Taking in count AS3600, the main difference is due to the reduction factor phi. While in ACI 318-99 is 0.875 (pure bending moment is 0.9), AS3600 used 0.791 (pure bending moment 0.8).

Therefore, the results are the same for a phi = 1.
As = 4.71*0.8 = 3.768 cm2 (AS 3600)
As = 4.179*0.9 = 3.768 cm2 (ACI 318-99)

Download Spread sheet

Reinforced Concrete AS3600

2011-09-08T16:59:00.000-07:00

To compute the reinforcement required by bending moment in a concrete section the main difference between codes, like ACI 318 and AS3600 is the reduction factor used . In ACI the reduction factor required is 0.9 (Section 9.3.2.1, ACI 318-08) however in AS3600 that value is reduced to 0.8 (Table 2.2.2, AS3600).

This is also related to the load factor combinations which are slightly different:
ACI 318 : 1.2 G + 1.6Q
AS 3600 : 1.2 G + 1.5Q

Where
G: Dead Load
Q: Live Load

Finally, in the following spreadsheet (PDF) it can be seen an example of the design of a rectangular concrete section, according AS 3600.

Download Spread Sheet (PDF)

The spreadsheet is also available in MathCAD. If you need it just ask for it.

Listado de Perfiles 2

2011-09-03T02:32:00.000-07:00

Esta es una macro que utiliza como base de datos los perfiles ICHa y pernos de anclaje Hilti, para ser presentados de forma amigable y práctica. Echa un vistazo.

Download Listado de Perfiles Macro

Pasos:
1. Descomprimir carpeta

2. Definir el directorio donde se encuentra la carpeta de imágenes. Para eso click derecho en la carpeta y copia la dirección de ubicación.
3. Copia la ruta en la celda marcada con amarillo en el spreadsheet, como por ejemplo:
"C:\Users\PC\Documents\perfiles\"

4. Luego click "BUSCAR"
5. Enjoy. Recuerda hacer clik en mis auspiciadores o hacer una donación. Cheers!

Download Listado de Perfiles Macro

Perfiles ICHA

2011-09-03T02:17:00.000-07:00

Esta es una lista de perfiles ICHA para el diseño de estructuras de acero, como secciones IN, Cajón, XL, L, HN, C, etc.

Download Perfiles ICHA

Concad

2011-08-23T17:08:00.000-07:00

Concad is a really old software to calculate reinforced concrete. However is really straight forward to use.

With Concad you can:
Calculate Reinforced Concrete
Interaction Diagrams
Deflection

The only issue is that concad is not using the last standards, instead it is using ACI 318-99. However it will give you an idea of the result.

Note: I have some problems running this software in Windows 7.

Download Concad

Vhelp spreadsheet

2011-08-15T00:33:00.000-07:00

Vhelp is based in HELP (USEPA 1994) wich is a model to predict leachate. However, the results are presented in a RTF file, which is quite difficult to understand.
I developed Vhelp Spreadsheet to read the data delivered by Vhelp report, which is a RTF file. With this spreadsheet you can transform the data in tables presenting rate, percentage and volume data in an excel file.

Steps:

Download VHelp SpreadSheet
Save your report file in txt format or also called plain text. Just go to word and save as.
Go the the sheet called read and click in the Read Button.
Select the file and excel will read all the information
Now click in rate, m3 and percentage and go the respective sheets to see the graphs.
Enjoy. If you any concern, please comment here.
Please click in my ads or make a donation, cheers!