Category: RESOURCES

ICE Load Analysis on Structural Steel

ICE Load Analysis on Structural Steel

 

According to the ASCE705I ASCE 7-05 code, the Spreadsheet Program written in MS-Excel for determining ice load due to the frozen rain on structural steel members. Specifically, quality and related and necessary parameters are determined to calculate the level of snow loading of different types of structural steel members.

 

Program ideas and limitations:

1. This program specifically follows section 10.0, Ice Load – ASCE 7-5 standard, “atmospheric torque,” and “minimum design load for building and other structures”.

2. This program sets the ice load based on the ASCE 7-05 code, which determines the specific diameter for a specific size and for comparative purposes, it calculates the size of ice load based on the actual size of the size.

3. This program uses the Database and Database Properties database from AISC version 13.0 “Shape Database” CD-ROM version (12/2005), and AISC 13th Edition manual list (12/2005).

 

Download Link

Wind Load Calculator Excel Spreadsheet

Wind Load Calculator Excel Spreadsheet

 

ASCE705W ASCE 7-05 Written for analysis of air load for code and structures for Spreadsheets program written in MS-Excel. In particular, air pressure is calculated by coefficients and corresponding parameters and net design calculations or calculation of air pressure.

Wind Load Calculator

This program is a workbook with the nine (9) worksheets described below.

*Simplified – Analysis using simplified method for improving home with <= 60 ‘
*MWFRS (low-rise) – main air-power resistance system for low-end house <= 60 ‘
*MWFRS (any HT) – the main wind power protection system for any height building
*Wall C and C wall components and cladding analysis
*Roof C and C – Roof material and cladding analysis
*Stack and Tank – Condensed Chimney, Stack and Vertical Tank Analysis
*Open framework (no roof) – Analyze the open framework without ceiling
*Wind Maps – Basic Wind Speed ​​Maps (Figure 6-1 for code ASCE 7-05)
*For more information on load type, read more about load count topics.

Program ideas and limitations:

1. This program uses the “ASCE 7-02 Air Load Regulation Usage Guidelines” to determine the external air pressure group used in outdoor air pressure assistants, ‘GCP’, Wall C and C and Roof C and C worksheets. . (Note: A version of this document that was applicable to the SSC 7-05 code was not available.)

2. Workshops for “MWFRS (any HT)”, “Wall C and C”, and “Roof C and C” are applicable for home with an average ceiling height of up to 500 feet.
3. For “simplified” analysis, it is applicable to low-growth house by meeting the criteria of Section 6.4.1.

4. In the worksheet for simplified analysis, the design is calculated for each side of the MWFRS air load. MDFRS design design is considered to be loaded in total length of the building length or length.

5. Worksheet for “MWFRS (Low-Rise)” is applicable for low-rise home defined in section 6.2.
6. The “open structures” worksheet is applicable for open frames without a 500 ft tall roof. It can be used for open-process-type structure and pipe / utility racks and bridges.
5. User defined steps can be used to define air pressure distribution in the worksheet for ‘Z’, “MWFRS (any HT)”, “Wall C and C”, and “Roof C and C”.

7. “May MWFRS (no HT)”, “Stack and Tank” and “Open Structures” worksheets can handle “strict” and “flexible” buildings and structures. For “strict” buildings or structures, this program uses a counting value of 0.85 or a glass effect factor, ‘g’ code code code 6.5.8.1. For “flexible” buildings or structures, this program calculates the ‘gf’ according to the vibration section 12.8.2.1, code based on the approximate time of code 6.5.8.2, where the formula X ‘X’ = City * H ^ X 0.75 is considered to be.

8. Workshops for “Wall C and C” and “Roof C and C” for flat roof buildings, Galilei roof buildings with roof corners <= 45 degrees and ceiling corners with monosclosure roof buildings <= 3 degrees.

9. “Stack and Tank” worksheet is applicable to the 600 feet long arch welded structure.

10. This program has several “comment boxes” that contain information including input or output items, usage of equations, data tables, etc. (Note: The appearance of the “Comment Box” is indicated by the “red triangle” in the top right corner of a cell, in particular the mouse pointer to move the contents of the “comment box” to the desired room.)

 

Download Link

Excel Sheet to Make a Gantt Chart in Microsoft Excel 2013

Excel Sheet to Make a Gantt Chart in Microsoft Excel 2013

 

This Gantt Chart spreadsheet is designed to to help you create a simple project schedule. You only need to know some basic spreadsheet operations, such as how to insert, delete, copy and and paste rows and cells. For more advanced uses, such as defining task dependencies, you will need to know how to enter formulas.

 

Download Link

Sheet Pile Design Spreadsheet

Sheet Pile Design Spreadsheet

 

This spreadsheet calculates the capacity of a cantilever sheet pile in English units and using common US sheeting sections. The geotechnical worksheet computes earth pressures and embedment. The Structural worksheet uses BEAMANAL spreadsheet by Alex Tomanovich, P.E. and the geotechnical analsyis worksheet to compute stresses and deflections.

 

Download Link

Canadian Seismic Design of Steel Structures

Canadian Seismic Design of Steel Structures

 

Design of Steel Structures of the Canadian Standards Association (CSA) governs the design of the majority of steel structures in Canada. Clause 27 of the standard includes the earthquake design provisions for seismic force resisting systems for which ductile seismic response is expected. Technical changes and new requirements have been incorporated in the 2009 edition of CSA S16, including modifications of the expected material properties for HSS members, consideration of protected zones, definitions of brace probable compressive and tensile resistances for capacity design and special requirements for braces intersecting columns between floors for concentrically braced steel frames, new seismic provisions for buckling restrained braced steel frames, design and detailing requirements for built-up tubular ductile links in eccentrically braced steel frames, changes to the requirements for ductile steel plate walls and for plate walls with limited ductility, including allowances for perforations and corner cut-outs in infill plates, and special provisions for steel frames of the Conventional Construction category above 15 m in height. These modifications were developed in parallel with the 2010 National Building Code of Canada (NBCC). The paper summarizes the new CSA S16-09 seismic design requirements with reference to NBCC 2010.

Basic capacity design provisions are given in CSA S16 to ascertain that minimum strength hierarchy exists along the lateral load path such that the intended ductile energy dissipation mechanism is mobilized and the integrity of the structure is maintained under strong ground shaking. In the design process, the yielding components of the SFRS may be oversized compared to the specified design seismic forces, as would be the case when drift limits, minimum member sizes or non-seismic load combinations govern the design. In this case, it is specified both in NBCC 2010 and CSA S16 that the design forces in capacity-protected elements need not exceed those induced by a storey shear determined with RoRd = 1.3. This upper bound essentially corresponds to the elastic seismic force demand reduced by 1.3, recognizing that nonyielding components will likely possess minimum overstrength. This 1.3 reduction factor only applies if the governing failure mode is ductile, and RoRd = 1.0 must be used otherwise.

This file contains formatted spreadsheets to perform the following calculations:
– Section 1: Area of equivalent diagonal brace for plate wall analysis (Walls).
– Section 2: Design of link in eccentrically braced frames (EBF).
– Section 3: Design of Bolted Unstiffened End Plate Connection (BUEP).
– Section 4: Design of Bolted Stiffened End Plate Connection (BSEP).
– Section 5: Design of Reduced Beam Section Connection (RBS).
– Section 6: Force reduction factor for friction-damped systems (Rd_friction).

Additionally, this file contains the following tables:
– Valid beam sections for moment-resisting connections (B_sections).
– Valid column sections for moment-resisting connections (C_sections).
– Valid bolt types for moment-resisting connections (Bolts).
– Database of properties of all sections (Sections Table).

Download Link

Core Wall Design Spreadsheets to Eurocode 2

Core Wall Design Spreadsheets to Eurocode 2

Core-walls  have been the most popular seismic force resisting system in western Canada for many decades, and recently have become popular on the west coast of the US for high-rise buildings up to 600 ft (180 m) high. Without the moment frames that have traditionally been used in high-rise concrete construction in the US, the system offers the advantages of lower cost and more flexible architecture.

In the US, such buildings are currently being designed using nonlinear response history analysis (NLRHA) at the Maximum Considered Earthquake (MCE) level of ground motion. In Canada, these buildings are designed using only linear dynamic (response spectrum) analysis at the MCE hazard level combined with various prescriptive design procedures.

This paper presents the background to some of the prescriptive design procedures that have recently been developed to permit the safe design of high-rise core-wall buildings using only the results of response spectrum analysis (RSA).

The series of European standards commonly known as “Eurocodes”, EN 1992 (Eurocode 2, in the following also listed as EC2) deals with the design of reinforced concrete structures – buildings, bridges and other civil engineering works. EC2 allows the calculation of action effects and of resistances of concrete structures submitted to specific actions and contains all the prescriptions and good practices for properly detailing the reinforcement.

In this spreadsheet , the principles of Eurocode 2, part 1-1 are applied to the design of core wall.

 

Download Link

Steel Beam Design Spreadsheet to BS 5950

Steel Beam Design Spreadsheet to BS 5950

 

Description:

 

Essential spreadsheet for steel design. Due to its form, easy input and clear output it reduces time required for designing steel members. It includes lateral torsional buckling check therefore is a comprehensive and an important tool for structural engineers.
Features:
– A clear and easy to read output (all on a single page);
– Quick summary of utilization factors;
– Change steel grade: S275; S355; S460;
– Supported steel sections: UC, UB, PFC;
– Design for Lateral Torsional Buckling (LTB) based on effective length;
– Loading options: UDL, 2x Partial UDL, 2x Point Load;
– ‘Live’ Loading diagram;
– Change between deflection for Dead Load + Imposed Load or Imposed Load only;
– Changeable safety factors;
– Design is based on British Standard (BS 5950:1 2000).

Download Link

Concrete Mix Design EXCEL Calculator

Concrete Mix Design EXCEL Calculator

 

Mix design plays an imperative function in civil construction projects. With the aim of obtaining the accurate measurement of any construction site, the usage of this user-friendly concrete mix design spreadsheet is absolutely necessary. This handy construction sheet will supply you the amounts of mix design for your construction site.

The concrete mix design refers to a technique for choosing suitable ingredients of concrete as well as establishing their balanced values so as to produce a concrete of the optimal strength, elasticity and feasibility as economically as possible.

The following properties are required to extend basis of choosing and proportioning of mix ingredients:

-The smallest amount of compressive strength is obligatory from structural consideration
-The adequate workability is considered necessary for complete compaction through the obtainable compacting equipment.
-Extreme water-cement ratio and supreme cement content to offer ample force for the specific site conditions
-Highest cement content to steer clear of shrinkage cracking due to temperature cycle in mass concrete.

Download link

error: Content is protected !!
Exit mobile version