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

Steel Connection Design Spreadsheet

Steel Connection Design Spreadsheet

Steel Connection is divided into two common methods: bolting and welding.
Bolting is the preferred method of Steel connecting members on the site. Staggered bolt layout allows easier access for tightening with a pneumatic wrench when a connection is all bolted.  High strength bolts may be snug-tightened or slip-critical. Snug-tightened connections are referred to as bearing connections Bolts in a slip-critical connection act like clamps holding the plies of the material together.Bearing type connections may have threads included ( Type N ) or excluded ( Type X ) from the shear plane(s).  Including the threads in the shear plane reduces the strength of the connection by approximately 25%.  Loading along the length of the bolt puts the bolt in axial tension. If tension failure occurs, it usually takes place in the threaded section.Three types of high strength bolts A325, A490 (Hexagonal Head Bolts), and F1852 (Button Head Bolt). A325 may be galvanized A490 bolts must not be galvanized F1852 bolts are mechanically galvanized. High strength bolts are most commonly available in 5/8” – 1 ½” diameters. Bolting requires punching or drilling of holes. Holes may be standard size holes, oversize holes, short slotted holes, long slotted holes

 

Due to high costs of labor, extensive field -welding is the most expensive component in a steel frame. Welding should be performed on bare metal. Shop welding is preferred over field welding. The weld material should have a higher strength than the pieces being connected.Single-pass welds are more economical than multi-pass welds. The most economical size weld that may be horizontally deposited in one pass has 5/16”. Fillet welds and groove welds make up the majority of all structural welds. The strength of a fillet weld is directly proportional to the weld’s throat dimension. The capacity of a weld depends on the weld’s throat dimension and its length.

 

Download link

Contiguous Piled Wall With Ground Anchor Support Design Spreadsheet

Contiguous Piled Wall With Ground Anchor Support Design Spreadsheet

 

Contiguous Piles, structures made of piles, and pile-like structures are useful structural elements to support deep excavations and cuts in slopes, and to retain creeping or sliding slopes, not uncommonly in seismic areas.
Depending on the static system and the dimensions the structural elements transfer forcesmainly by shear (“dowel”) and/or mainly by bending (“beam”) to the ground.
In numerous cases they are particularly effective in combination with otherstructural measures like (pre-stressed)
anchors and/or drainage systems. The paper presents case histories including piles and pile-like structures, which are applied for retaining structures in slopes.
The main focus is on infrastructureprojects in creeping slopes. Two case historiesfrom Austria and Sloveniaare presented in detail. Miscellaneous projects from European countries concentrating on various aspects complement
the contribution.

Download link

Manual of engineering drawing, Second edition

Manual of engineering drawing, Second edition

Colin H. Simmons, Dennis E. Maguire

 

Preference :
 
The general trend in Engineering Design had been that the designer who was responsible for the conception and design of a particular product generally specified other aspects of the manufacturing process.
Gradually however, developments from increased computing power in all aspects of production have resulted in progressive advances in manufacturing techniques, metrology, and quality assurance. The impact of these additional requirements on the Total Design Cycle resulted in the withdrawal of BS 308 in 2000. Its replacement BS 8888 is a far more comprehensive Standard. It is important to stress that British and ISO drawing standards are not produced for any particular draughting method.

No matter how a drawing is produced, either on an inexpensive drawing board or the latest CAD equipment, the drawing must conform to the same standards and be incapable of misinterpretation.

The text which follows covers the basic aspects of engineering drawing practice required by college and university students, and also professional drawing office personnel. Applications show how regularly used standards should be applied and interpreted. Geometrical constructions are a necessary part of engineering design and analysis and examples of twoand three-dimensional geometry are provided.

Practice is invaluable, not only as a means of understanding principles, but in developing the ability to visualize shape and form in three dimensions with a high degree of fluency. It is sometimes forgotten that not only does a draughtsman produce original drawings but is also required to read and absorb the content of drawings he receives without ambiguity.

The section on engineering diagrams is included to stimulate and broaden technological interest, further study, and be of value to students engaged on project work. Readers are invited to redraw a selection of the examples given for experience, also to appreciate the necessity for the insertion and meaning of every line.

Extra examples with solutions are available in Engineering Drawing From First Principles using AutoCAD, also published by Butterworth-Heinemann. It is a pleasure to find an increasing number of young ladies joining the staff in drawing offices where they can make an effective and balanced contribution to design decisions.
Please accept our apologies for continuing to use the term ‘draughtsmen’, which is the generally understood collective noun for drawing office personnel, but implies equality in status. In conclusion, may we wish all readers every success in their studies and careers. We hope they will obtain much satisfaction from employment in the absorbing activities related to creative design and considerable pleasure from the construction and presentation of accurately defined engineering drawings.
Content :
  • 1 Drawing office management and organization
  • 2 Product development and computer-aided design
  • 3 CAD organization and applications
  • 4 Principles of first and third angle orthographic projection
  • 5 Linework and lettering
  • 6 Three-dimensional illustrations using isometric and oblique projection
  • 7 Drawing layouts and simplified methods
  • 8 Sections and sectional views
  • 9 Geometrical constructions and tangency
  • 10 Loci applications
  • 11 True lengths and auxiliary views
  • 12 Conic sections and interpenetration of solids
  • 13 Development of patterns from sheet materials
  • 14 Dimensioning principles
  • 15 Screw threads and conventional representations
  • 16 Nuts, bolts, screws and washers
  • 17 Keys and keyways
  • 18 Worked examples in machine drawing
  • 19 Limits and fits
  • 20 Geometrical tolerancing and datums
  • 21 Drawing solutions

Download Link

Over 500 Spreadsheets for Mechanical and Civil Engineering-Free Download

Over 500 Spreadsheets for Mechanical and Civil Engineering-Free Download

 

Here a big list of spreadsheets available for download from Piping, Process, Instrumentation, Mechanical, Drilling and Civil.

Civil Engineering Spreadsheets

    • Bar Schedule 8666.xls
    • Daniel-Conventional Slabs.xls
    • Daniel-Pile Caps.xls
    • Daniel-Tank Footing.xls
    • Daniel-Wind-ASCE7-05.xls
    • Daniel-Wind-IR16-7.xls
    • Steel Beam.xls
    • Tank Size Calculator.xls
    • Wind Design.xls

Beam and Pipe Spreadsheets:

    • CALCULO SOPORTES.xls
    • DIÁMETROS DE TUBERIA.xlsx
    • header & Piping sizing.xls
    • piping design info.xls
    • PIPINGS AND FITTINGS.xls
    • POLIN TIPO A.xls POLIN TIPO B.xls
    • Prontuario del Acero.xls QCF522 FIRED HEATER INSTALLATIONOF STACK, PIPING AND OUTLET MANIFOLD.xls
    • Steel_Pipe Dimens.xlsstress tables.xls
    • Tablas Varias.xls
    • Useful_Piping & Structural Data.xls

Mechanical Engineering Spreadsheets

  • BESSEL.XLS
  • CALIBTK.XLS
  • CATENARY.XLS
  • COMPRESS.XLS
  • CONE.XLS
  • CVCALCS.XLS
  • DPT.XLS
  • EXDUCT.XLS
  • FLUMLVL.XLS
  • ORIFICE.XLS
  • PACKED.XLS
  • PLATE.XLS
  • PUMPCURV.XLS
  • WEIR.XLS

Instrumentation Spreadsheets

    • CVCALCS.xls
    • CVGAS.xls
    • CVOIL.xls
    • Instt Air Consumption.xls
    • mA to PLC Raw Count Conversion.xls
    • Mercer_Pilot Valve Sizing_v5.1.xls
    • Mercer_Spring Valve Sizing_v4.99.xls
    • Orifice Calculation.xls
    • Ross_Valve Sizing.xls

Drilling Spreadsheets

    • General Formulae.xls
    • Drilling Calculation.xls
    • Assortment of Mini Applications.xls
    • Pressure Drops & Others.XLS
    • SRB Hydraulic Programs.xls
    • Hydraulics Worksheet.xls
    • Nowsco Calculation Sheets.xls
    • BASIC MUD REPORTv1.5.xls
    • MudEng2.55.xls
    • Simple Mud Engineerv1.22.xls
    • MUD MIXING.XLS
    • Hydraulic Calculations & Mudpump.xls
    • Spot Heavy Mud.xls
    • Mud Motors, Jets & Surveys.xls
    • Floating Casing.xls
    • Lubricate and Bleed Procedure.xls
    • Maximum Casing Pressure and Pit Gain.xls
    • Critical Rotary Speed.xls
    • Drill String Design.xls
    • Filling the Hole.xls
    • Volumetric Method.xls
    • Well Control.xls
    • Well Control Worksheet-Surface BOP.xls
    • Randy Smith Kill.xls
    • Kill Sheet IWCF.XLW
    • Shell Kill.xls
    • Kill Sheet7.xls
    • Kill Sheet1.xls
    • WELL CONTROL DATA SHEET for DIRECTIONAL WELLS Wt. & Wt. METHOD.xls
    • WELL CONTROL DATA SHEET for DRILLER’S METHOD.xls
    • WELL CONTROL DATA SHEET for VERTICAL WELLS Wt. & Wt. METHOD.xls
    • IDEAL KICK REMOVAL.XLS
    • Well Control.xls
    • Cement Calculations.XLS
    • CASING CEMENTING.xls
    • CEMENT.XLS
    • PRIMARY CEMENTATION.XLS
    • PUMPING RATES FOR CEMENT SPACERS.XLS
    • Buckling & Wellhead Load After Cementing.XLS
    • Squeeze Cementing Job.xls

Download Link

Autodesk Roadway Design for InfraWorks 360 Essentials

Autodesk Roadway Design for InfraWorks 360 Essentials

Autodesk Roadway Design for InfraWorks 360 Essentials, 2nd Edition allows you to begin designing immediately as you learn the ins and outs of the roadway-specific InfraWorks module. Detailed explanations coupled with hands-on exercises help you get up to speed and quickly and become productive with the module’s core features and functions. Compelling screenshots illustrate step-by-step tutorials, and the companion website provides downloadable starting and ending files so you can jump in at any point and compare your work to the pros.

  • Master the Roadway tools that go beyond the base software
  • Create new designs and add detail with step-by-step tutorials
  • Use the powerful module-specific analysis and optimization functions
  • Import and work with real-world data to quickly become productive

If you are looking for a guide that will get you up and designing right away, Autodesk Roadway Design for InfraWorks 360 Essentials, 2nd Edition is the easy-to-follow roadmap to Roadway Design mastery.

Download Link

Autodesk InfraWorks and InfraWorks 360 Essentials: Autodesk Official Press

Autodesk InfraWorks and InfraWorks 360 Essentials: Autodesk Official Press

Your guide to quickly learning InfraWorks Autodesk InfraWorks Essentials is a complete, hands–on tutorial for InfraWorks, the powerful design tool that lets you quickly generate 3D models to create infrastructure designs and proposals. This Autodesk Official Press book shows you the right way to take advantage of versatile InfraWorks features. From creating models in the context of the existing environment to crafting stunning proposals, you′ll become comfortable with every step of the design process. After working through this start–to–finish tutorial, you′ll be able to productively use InfraWorks for civil project design that′s fully integrated with existing real–world characteristics. In Autodesk InfraWorks Essentials , you′ll learn everything you need for everyday design projects. 360 full–color pages full of screenshots and illustrations Detailed step–by–steps on importing GIS and other data Create roadways, buildings, railways, and more Learn how to use the powerful Styles feature Download before and after files, so you can start anywhere This is the perfect tutorial for using InfraWorks to quickly create infrastructure designs, win project bids, speed up the approval process, and collaborate remotely across platforms.

 

Download Link

Tekla Structures for reinforced concrete Tutorial

Tekla Structures for reinforced concrete Tutorial

 

Tekla BIM software is revolutionising the concrete detailing process, enabling users to produce fully reinforced 3D models with construction level of detail and all associated documentation. By modelling all details in the 3D model, all drawings and schedules are fully coordinated with this single source of truth and updated as changes are made. In this video, Paul Walker of Tekla UK demonstrates the benefits of Tekla for rebar detailing. Mirroring a typical workflow, he uses an IFC model from Autodesk Revit to establish the concrete geometry and converts the IFC objects to native Tekla elements. Paul then demonstrates how to detail the converted objects and produce the associated drawings and rebar schedules.

error: Content is protected !!
Exit mobile version