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

Design of Concrete Retaining Wall as per BS 8110:2005

Design of Concrete Retaining Wall as per BS 8110:2005

 

Retaining walls provide lateral support to vertical slopes of soil. They retain soil which would otherwise collapse into a more natural shape. The retained soil is sometimes referred to as backfill.Retaining walls can be constructed of many different materials and with a variety of building techniques.
All advice or information from the British Cement Association and/or The Concrete Centre is intended for those who will evaluate the significance and limitations of its contents and take responsibility for its use and application. No liability (including that for negligence) for any loss resulting from such advice or information is accepted by the BCA, TCC or their subcontractors, suppliers or advisors. Users should note that all TCC software and publications are subject to revision from time to time and should therefore ensure that they are in possession of the latest version.

Download Link

RC Spreadsheets Version 4B

RC Spreadsheets Version 4B

 

The popular RC-spreadsheets package version 4 was issued following the amendment to the UK National Annex to Eurocode 2 in December 2009. These Excel spreadsheets are intended as aids for design to both Eurocode 2 and BS 8110-1:1997.

Version 4B.2 provides updates to Version 4B.1 that reflect developments and improvements particularly with respect to punching shear, column design and pilecap design as well as applying bug fixes.

What does RC Spreadsheets do?
For the experienced engineer, the spreadsheets allow the rapid production of clear and accurate design calculations. For post-graduates and new engineers they encourage understanding of concrete design and help the gaining of experience by studying ‘what if’ scenarios. The individual user is able to answer their own questions by chasing through the cells to understand the logic used.

Since their release in January 2000, the RC Spreadsheets have proved to be enormously popular. They are written for engineers by engineers. The original spreadsheets have evolved and been added to and the usefulness and robustness of the product have been enhanced by users feedback. If you have any comments please let us know.

Download Link

Retaining Wall with Anchors Analysis and Design Spreadsheet

Retaining Wall with Anchors Analysis and Design Spreadsheet

This spreadsheet provides the design and analysis of retaining wall with anchors.
Retaining walls with anchors shall be dimensioned to ensure that the total lateralload, Ptotal, plus any additional horizontal loads, are resisted by the horizontal component of the anchor Factored Design Load Thi, of all the anchors and the reaction, R, at or below the bottom of the wall. The embedded vertical elements shall ensure stability and sufficientpassive resistance against translation. The calculated embedment length shall be the greater of that calculated by the Designer or Geotechnical Services.

Typical design steps for retaining walls with ground anchors are as follows:

Step 1 : Establish project requirements including all geometry, external loading conditions (temporary and/ or permanent, seismic, etc.), performance criteria, and construction constraints. Consult with Geotechnical Services for the requirements.

Step 2 : Evaluate site subsurface conditions and relevant properties of the in situ soil or rock; and any specifications controlled fill materials including all materials strength parameters, ground water levels, etc. This step is to be performed by Geotechnical Services.

Step 3 : Evaluate material engineering properties, establish design load and resistance factors, and select level of corrosion protection. Consult with Geotechnical Services for soil and rock engineering properties and design issues.

Step 4 : Consult with Geotechnical Services to select the lateral earth pressure distribution acting on back of wall for final wall height. Add appropriate water, surcharge, and seismic pressures to evaluate total lateral pressure. Check stability at intermediate steps during contruction. Geotechnical numerical analysis may be required to simulate staged construction. Consult Geotechnical Services for the task, should it be required.

Step 5 : Space the anchors vertically and horizontally based upon wall type and wall height. Calculate individual anchor loads. Revise anchor spacing and geometry if necessary.

Step 6 : Determine required anchor inclination and horizontal angle based on right-of-way limitations, location of appropriate anchoring strata, and location of underground structures.

Step 7 : Resolve each horizontal anchor load into a vertical force component and a force along the anchor.

Step 8 : Structure Design checks the internal stability and Geotechnical Services checks the external stability of anchored system. Revise ground anchor geometry if necessary.

Step 9 : When adjacent structures are sensitive to movements Structure Design and Geotechical Services shall jointly decide the appropriate level and method of analysis required. Revise design if necessary. For the estimate of lateral wall movements and ground surface settlements, geotechnical numerical analysis is most likely required. Consult with Geotechnical Services for the task, should it be required.

Step 10 : Structure Design analyzes lateral capacity of pile section below excavation subgrade.
Geotechnical Services analyzes vertical capacity. Revise pile section if necessary.

Step 11 : Design connection details, concrete facing, lagging, walers, drainage systems, etc.
Consult with Geotechnical Services for the design of additional drainage needs.

Step 12 : Design the wall facing architectural treatment as required by the Architect.

Download Link

Excel Construction Management Templates

Excel Construction Management Templates

 

Excel Construction Management Templates are very important for managers as it’s very difficulit to manage construction projects. they Require alot of stakeholders, details and documentation. So we provide more than 15 free excel construction management templates to download and use themthe templates involve :
  • Construction Timeline
  • Construction Budget
  • Construction Estimator
  • Bid Tabulation Template
  • Abstract of Bids Template
  • Subcontractor Documentation Tracker
  • Construction Documentation Tracker
  • Daily/Weekly Inspection Report
  • Contractor Progress Payment Template
  • Change Order Request Summary
  • Change Order Log
  • Request for Information Log
  • Residential Remodel Project Timeline
  • Certified Wage & Hour Payroll Form
  • Time & Materials Invoice
  • Project Punchlist
  • Project Closeout Checklist
  • Construction Management with Smartsheet

Download link

Design of Bridge Slab Spreadsheet

Design of Bridge Slab Spreadsheet

 

Reinforced Slab Bridges used For short spans, a solid reinforced concrete slab, generally cast in-situ rather than precast, is the simplest design to about 25m span, such voided slabs are more economical than prestressed slabs.
Slab bridges are defined as structures where the deck slab also serves as the main load-carrying component. The span-to-width ratios are such that these bridges may be designed for simple 1-way bending as opposed to 2-way plate bending. This design guide provides a basic procedural outline for the design of slab bridges using the LRFD Code and also includes a worked example.
The LRFD design process for slab bridges is similar to the LFD design process. Both codes require the main reinforcement to be designed for Strength, Fatigue, Control of Cracking, and Limits of Reinforcement. All reinforcement shall be fully developed at the point of necessity. The minimum slab depth guidelines specified in Table 2.5.2.6.3-1 need not be followed if the reinforcement meets these requirements.
For design, the Approximate Elastic or “Strip” Method for slab bridges found in Article 4.6.2.3 shall be used.
According to Article 9.7.1.4, edges of slabs shall either be strengthened or be supported by an edge beam which is integral with the slab. As depicted in Figure 3.2.11-1 of the Bridge Manual, the #5 d1 bars which extend from the 34 in. F-Shape barrier into the slab qualify as shear reinforcement (strengthening) for the outside edges of slabs.
When a 34 in. or 42 in. F-Shape barrier (with similar d1 bars) is used on a slab bridge, its structural adequacy as an edge beam should typically only need to be verified. The barrier should not be considered structural. Edge beam design is required for bridges with open joints and possibly at stage construction lines. If the out-to-out width of a slab bridge exceeds 45 ft., an open longitudinal joint is required.

Download Link

error: Content is protected !!
Exit mobile version