Engineering with the Spreadsheets by ASCE

Today, the spreadsheet is an essential tool for engineers. Christy provides the tools needed to quickly apply the powerful analytic capability of Microsoft Excel to structural engineering applications. The book and CD-ROM present more than 50 ready-to-use Excel templates that demonstrate basic calculations and presentation techniques as well as advanced functions that may be unfamiliar to even experienced users. Applications include concrete, wind and seismic issues, foundation soil loading, the vortex shedding of tall stacks, and other engineering issues.Beneficial to professionals and college students alike, Engineering with the Spreadsheet is an indispensable resource for structural engineers.

Engineering_with_the_spreadsheets
10 Absolute Relative References.xls
11 Circular Reference.xls
12 Logic.xls
13 Database.xls
14 Regression Analysis.xls
15 Takedown.xls
16 Pole.xls
17 Numerical Integration.xls
18 Matrix Math.xls
19 Exhaust Stack Cover.xls
20 Seismic.xls
21 Wind.xls
23 Vortex Shedding.xls
24 Bolt Patterns.xls
25 Bolt Threads.xls
27 Bolt Group Pullout.xls
28 Roark Flat Plates.xls
30 Foundation Loading.xls
31 Foundation Design.xls
33 Concrete Beam.xls
34 Concrete Shear.xls
37 Tank Support Cover.xls
38 Seismic.xls
39 Seismic ASCE 7-02_05.xls
40 Celerity.xls
41 LRFD.xls
42 Pile Foundation.xls
43 Two Way Slab Loading.xls
45 Concrete Column.xls
46 Partial Shell.xls
47 Concrete Column Photos.xls
48 Concrete Shear.xls
49 Column Deck Interface.xls
50 Column Slab Moment Shear Transfer.xls
51 Bolt Group Pullout.xls
52 Embed.xls
53 Concrete Beam.xls
54 Tank Test Measurements.xls
56 LRFD Compared.xls
57 Acceleration.xls
58 Quadratic and Cubic Equations.xls
59 LISP.xls
60 Units.xls
61 Notation.xls
_2 Tips.xls
_2 Tipslinks.xls
_3 Worksheet_70.xls
_4 Editing in Excel.xls
_5 Math Editing.xls
_6 Symbols.xls
_7 Drawing in Excel.xls
_8 Pictures.xls
_9 Graphing.xls
Sample Header.xls

[su_button url=”https://drive.google.com/open?id=1VxADPlrYNG6nM2r4J79P8kQwRCi4q4NI” size=”7″ center=”yes”] Download Link[/su_button]

Excel Sheet to Design Basement Wall

This Excel sheet to design Concrete Basement Wall details strength design (durability and other considerations not included) for a new buried concrete basement wall in a single-story masonry building.

The example follows the provisions of ACI 318-11, Building Code Requirements for Structural Concrete. Throughout the example, discussion of the “in practice” decisions/situations the designer may encounter are included. Additionally, at the conclusion of the problem some “what-ifs” are evaluated.

ACI Committee E702, “Designing Concrete Structures Committee,” is part of the ACI Educational Committee structure.

Their mission is to develop educational programs and instructional materials within the area of design.

The committee has developed various design examples to illustrate the use of various ACI documents.

These examples provide step-by-step calculations with references to applicable code provisions for common member design problems, and may also include calculations for common concrete testing procedures, field data analysis, or evaluations.

[su_button url=” https://drive.google.com/open?id=1jals_5SHu1h6Lbyq1wACskjQog_-g6LT” size=”7″ center=”yes”] Download Link[/su_button]

Excel Sheet to Design Flat Slab According to Eurocode

Common practice of design and construction is to support the slabs by beams and support the beams by columns. This may be called as beam-slab construction.

The beams reduce the available net clear ceiling height. Hence in warehouses, offices and public halls some times beams are avoided and slabs are directly supported by columns.

This types of construction is aesthetically appealing also. These slabs which are directly supported by columns are called Flat Slabs.

Download Link

Microsoft Project 2016 Essential Training

Master the core features of Microsoft® Project 2016, the powerful project management software. Learn how to best set up such project components as work tasks, summary tasks, milestones, and recurring tasks. Author Bonnie Biafore, a Project Management Professional (PMP)®, also explores the different types of resources used in projects, and how to set up their availability and cost. She also shows how to link tasks together and assign resources to tasks to build a realistic project schedule. Finally, the course explains how to use Project 2016 to help evaluate your schedule and resource workloads to make sure you’re bringing a project in on time and within budget. Bonnie also shows how to use the new features in Project 2016, such as multiple timelines and the “Tell me what you want to do” field.
NOTE: This course updates our Microsoft Project 2013 Essential Training course for Project 2016, and most videos will work with both versions of the software. For Microsoft Project 2010 compatibility, see Project 2010 Essential Training.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
Topics include:
Choosing the right Project editionCreating and saving projectsSetting up calendarsCreating individual and recurring tasksLinking and timing tasksAssigning tasks to resourcesViewing your data differently with sorting, grouping, and filteringFine-tuning the project scheduleUnderstanding baseline, schedule, and actual valuesReporting on the project statusSharing projects

Topics include:
– Choosing the right Project edition
– Creating and saving projects
– Setting up calendars
– Creating individual and recurring tasks
– Linking and timing tasks
– Assigning tasks to resources
– Viewing your data differently with sorting, grouping, and filtering
– Fine-tuning the project schedule
– Understanding baseline, schedule, and actual values
– Reporting on the project status
– Sharing projects

Download Link:

https://drive.google.com/open?id=1HsTsYiQ-UIJ0kWewac3Vdwxi1VbPvYen

Light Gage Truss Design Based on AISI 2001 & ER-4943P

The most complex component designed in light gauge framed residential structures are Roof trusses.

In the design of light gauge cold formed metal trusses, the designer is meant to adhere to the requirements of Loading standards and steel design standards.

Designers need to ensure that all the loads and load combinations stipulated in NASH Standard Residential and Low-rise Steel Framing Part 1 Design Crieteria and AS 4055 are checked and that the support, restraint conditions are accurately considered in the analysis.Various loads, load combinations, wind pressure coefficients, restraint and support conditions will be discussed in this paper.

In the design of truss members, the requirement of AS/NZS 4600 should be strictly adhered. Effective length criteria for truss members is also discussed in this paper.

This paper provides an illustrative example fo truss design using light gauge cold formed steel members.

[su_button url=”https://drive.google.com/open?id=1camZDVgo6uuXtnm6x13KGUxP4KE-zA2m” size=”7″ center=”yes”] Download Link[/su_button]

Autodesk Revit 2017 for Architecture

Autodesk Revit 2017 for Architecture No Experience Required By Eric Wing

The only Revit tutorial guide based on a real project workflow Autodesk Revit Architecture No Experience Required is the ultimate real-world guide for mastering this increasingly prevalent BIM software package. Using a continuous, step-by-step tutorial, this book walks you through all project phases as you learn the basics of Revit by designing, documenting, and presenting a four-story office building. You’ll begin by learning your way around the interface and conventions, then jump right into the design by placing walls, doors, and windows. Next, you’ll work with grids, beams, foundations, dimensions, and text as you build floors layer by layer, join walls, create ceilings and roofs, and place stairs, ramps, and railings. The instruction covers construction documentation, advanced detailing, and families, as well as site considerations including grading and top surface features to provide a well-rounded, real-world Revit skill set. The companion website features downloadable ‘before and after’ tutorial files that allow you to jump in at any point and compare your work to the pros.

The shift from 2D drafting to 3D building information modeling has made Revit a must-have skill for an increasing number of design, engineering, and construction professionals. This book is designed to teach you the basics quickly, using a real-world workflow, process, and pacing.

Get acquainted with the Revit interface, then immediately start building Learn to place structural components, text, dimensions, and more Understand views, grids, editing, importing, exporting, and work sharing Generate construction documentation including schedules and material takeoffs This simple yet engaging tutorial brings together all of the major skills a Revit user needs to know to complete real workplace projects. Whether read from beginning to end as a comprehensive lesson, or used as ‘dip-in’ reference for unfamiliar tasks, Autodesk Revit Architecture No Experience Required provides invaluable practical BIM instruction for every phase of a project.

Download Link:

https://drive.google.com/open?id=1Vii6TR33c-fjYW2qchhxaB4zmVkXibGI