Design of Post-Tensioned Concrete Floor Excel Sheet

 Design of Post-Tensioned Concrete Floor 

Design of Post-Tensioned Concrete Floor methods

1- Breakdown two ways of floor into design strips in one direction and one-way slabs in other direction. Design strips work as continuous beams by banded all tendons at the column. 

The perpendicular direction like multi-span one-way slabs, using distributed tendons.

2- Specify total required effective post-tensioning forces at banded tendons, on structural drawings,

and uniform forces in distributed 

3- when tendon less than 140 ft, stress at one end. Otherwise stress at both ends.

4- the various live loading conditions should be considered by input ll zero at some spans.

Download Design of Post-Tensioned Concrete Floor Excel Sheet

LINK

 Design of Wing Wall Spreadsheet 

The proposed cast-in-situ reinforced concrete structure is a wing wall of the proposed Arch Culvert along road RD-21 ( Typical design for all wing walls). Dingwall shall be designed as a cantilever wall to safely withstand earth embankment on one side of the wall and comply with minimum factors of safety and 100 kPa recommended net allowable bearing capacity as per  RC manual.

Download Design of Wing Wall Free Spreadsheet

LINK

Project Management for Engineering, Business, and Technology

Project Management for Engineering, Business, and Technology 

John M. Nicholas,

Preference :

There is an ever-growing need for better project management within the disciplines of engineering, business, and technology, and this new edition is a direct response to that need.

By emphasizing practical applications, this book targets the ultimate purpose of project management: to unify and integrate the interests, resources, and work efforts of many stakes-holders to accomplish the overall project goal.

The book encompasses the essential background material required, from philosophy to methodology, before presenting concepts and techniques for practical application on topics including:

• Project initiation and proposals

• Scope and task definition

• Scheduling

• Budgeting

• Risk analysis

Content :

• Introduction
• What Is Project Management?
• Systems Approach and Systems Engineering
• Systems Development Cycle and Project Conception
• Project and System Definition
• Planning Fundamentals
• Project Time Planning and Networks
• Advanced Project Network Analyses and Scheduling
• Cost Estimating and Budgeting
• Project Quality Management
• Managing Risks in Projects
• Project Execution and Control
• Project Evaluation, Communication, Implementation, and Closeout
• Project Organization Structure and Integration
• Project Roles, Responsibility, and Authority
• Managing Participation, Teamwork, and Conflict
• The Management of Project Management
• Project Selection and Portfolio Management
• International Project Management

Download Project Management for Engineering, Business, and Technology free PDF

LINK

Carpentry & Construction, 5th Edition

Carpentry & Construction, 5th Edition 

Mark Miller, Rex Miller

Preference :

A complete, step-by-step guide to CARPENTRY AND CONSTRUCTION

Revised and updated, Carpentry & Construction, Fifth Edition, takes you through every step of house construction in such detail that you can use it to build your own home! Clear instructions, along with more than 1,500 photographs and illustrations, demonstrate each phase of construction--from selecting tools to pouring the foundation, to finishing the interior. This how-to handbook also covers remodeling, additions, and repairs.

Content :

• Chapter 1. Let's Get Started;
• Chapter 2. Site Preparation;
• Chapter 3. Footings and Foundations;
• Chapter 4. Concrete Slabs and Floors;
• Chapter 5. Floor Frames;
• Chapter 6. Framing Walls;
• Chapter 7. Framing the Roof;
• Chapter 8. Roofs and Roofing;
• Chapter 9. Windows and Doors;
• Chapter 10. Exterior Walls;
• Chapter 11. House Wiring;
• Chapter 12. Plumbing;
• Chapter 13. Insulation;
• Chapter 14. Interior Walls and Ceilings;
• Chapter 15. Interior Finishing;
• Chapter 16. Special Construction Methods;
• Chapter 17. Maintenance and Remodeling;
• Chapter 18. The Carpenter and the Industry;
• Chapter 19. Bathrooms;
• Chapter 20. Construction for Solar Heating;
• Chapter 21. Alternative Framing Methods;
• Chapter 22. Alternative Foundation Systems;
• Chapter 23. Private Water Systems;
• Chapter 24. Private Sewage Facilities

Download Carpentry & Construction, 5th Edition free PDF

LINK

 Ordinary Reinforced Concrete Shear Wall Design Excel Sheet 

Shear walls in buildings must be symmetrically located in a plan to reduce ill-effects of twist in buildings They could be placed symmetrically along with one or both directions in the plan. -Shear walls are more effective when located along the exterior perimeter of the building – such a layout increases the resistance of the building to twisting.

Download Free Ordinary Reinforced Concrete Shear Wall Design Excel Sheet

LINK

Modern Construction Case Studies

Modern Construction Case Studies 

Andrew Watts

Preference :

In the context of tight budgets, complex geometries, high energy efficiency, and flexible user functions mean that the requirements for technical details, and their execution in modern buildings, are very exacting. Modern Construction Case Studies presents planned, under construction and completed, innovative avant-garde projects – all designed by internationally recognized architectural practices such as Zaha Hadid, BIG, Jean Nouvel, Gensler, Lab Architecture Studio, RMJM Architecture, Nordic Office of Architecture, and others. The case studies are analyzed in a structured way under technical criteria, using text, photographs, 3D illustrations, and diagrams. They provide inspiration for new approaches that also work for smaller-scale projects.

Content :

• 1. Galaxy Soho
• 2. Evolution Tower
• 3. Hotel
• 4. Heydar Aliyev Cultural Centre
• 5. Burjuman Tower
• 6. Burj Alshaya
• 7. Dance & Music Centre
• 8. K. Çamlica TV Tower
• 9. Meixihu IC&A Centre
• 10. Federation Square
• 11. New Port Centre
• 12. City Museum Istanbul
• 13. Burjuman Apartments
• 14. KAFD Metro
• 15. Grand Théatre
• 16. The Avenues
• 17. Stone Towers
• 18. Holland Park School

Download Modern Construction Case Studies free PDF

LINK

 Cantilever Column & Footing Design Spreadsheet 

 The cantilever is basically a structural element that extends horizontally and has supported at only one end. The cantilever is the structures that are fixed at one end and free at another end.

Download Cantilever Column & Footing Design Free Spreadsheet

LINK

Risk Management for Design and Construction

Modern Construction Handbook, Third Edition 

Ovidiu Cretu

Preference :

Risk management is perhaps the hottest topic of discussion for professionals within the design and construction industry who care about the fate of their endeavors, whatever they may be. Increasingly, professionals are engaged in risk management even before the project is assigned to them. It is difficult to imagine project management without formal or informal risk management. The next paragraph presents one more reason why risk management is needed for projects that we want to succeed.

Content :

• 1: Why And What Is Risk Management?
• 2: Project Cost And Schedule Estimates
• 3: The Risk-based chapter 
• 4: Risk Elicitation Estimate
• 5: Risk Management
• 6: Risk-based Estimate Self-modeling Spreadsheet
• Risk-based Estimate Workshop

Download Risk Management for Design and Construction free PDF

LINK

 Wind Pressure on High Rise Building Calculation Excel Sheet 

This excel sheet calculate wind Pressure on high rise building. The wind load calculation is evaluated based on elementary wind speed and other aspects as kind of topography, terrain, and the usage of the building and its risk aspect for that specific region

Download Wind Pressure on High Rise Building Calculation Free Excel Sheet

LINK

Project Management, Planning and Control, Seventh Edition

Project Management, Planning and Control, Seventh Edition 

Albert Lester 

Preference :

The Modern Construction Handbook has become a building construction classic and is used as a textbook in many courses. Its systematic approach with chapters on materials, walls, roofs, construction, and environment offers clear and efficient orientation. Digital fabrication techniques are included as well (complementing traditional production processes) and presented in an instructional book for the first time. The third edition has been thoroughly updated and now provides More information more annotation of drawings, more text on the page. The updated future chapter with more emerging construction techniques. Updated essays on construction in the introduction Chapter 1. Mote technical data in the Materials Chapter. The content in this third edition has been completely reworked which makes it an even more valuable companion for students and young practitioners!"

Content :

• Chapter 1. Project Definition
• Chapter 2. Project Management
• Chapter 3. Program and Portfolio Management
• Chapter 4. Project Context (Project Environment)
• Chapter 5. Business Case
• Chapter 6. Investment Appraisal
• Chapter 7. Stakeholder Management
• Chapter 8. Project-Success Criteria
• Chapter 9. Organization Structures
• Chapter 10. Organization Roles
• Chapter 11. Project Life Cycles
• Chapter 12. Work Breakdown Structures
• Chapter 13. Estimating
• Chapter 14. Project Management Plan
• Chapter 15. Risk Management

Download Project Management, Planning, and Control, Seventh Edition free PDF

LINK

Fundamentals of Technology Project Management

Fundamentals of Technology Project Management 

Andrew Watts

Preference :

This book is a practical guide to project management in the technology sector. It is designed to help you develop the skill sets you need to be a successful project manager. The book assumes no previous knowledge of project management. It has been written with the needs of the beginner to intermediate-level project manager in mind. However, this is also an excellent book for seasoned project managers who are ready to take project management to a new level by adding more structure and methodology to the project management process.

Content :

• PART I: INTRODUCTION TO PROJECT MANAGEMENT
• PART II: PLANNING YOUR PROJECT
• PART III: CREATING THE PRODUCT
• PART IV: PROJECT COMPLETION AND CLOSE
• PART V: PROJECT DIRECTION
• PART VI: PROCESS FRAMEWORKS

Download Fundamentals of Technology Project Management free PDF

LINK

 Full Steel Building Design Calculation Free Spreadsheet 

Steel Building Design Calculation Spreadsheet contains: 

INDEX

PREAMBLE

CODES & REFERENCES

MATERIAL SPECIFICATIONS

PRIMARY LOADS

LOAD COMBINATIONS

LOAD CALCULATIONS

EQUIPMENT DATA

DESIGN OF ANCHOR BOLTS & BASE PLATE

SUPPORT REACTIONS

GEOMETRY OF STRUCTURES

Download Full Steel Building Design Calculation Free Spreadsheet

LINK

Design Of Intze Water Tank Free Excel Sheet

 DESIGN  OF INTZE WATER TANK 

A water tank is used to store water to tide over the daily requirement. In the construction of concrete structures for the storage of water and other liquids, the imperviousness of concrete is most essential.  Design of liquid retaining structure has to be based on the avoidance of cracking in the concrete having regard to its tensile strength.  Cracks can be prevented by avoiding the use of thick timber shuttering which prevents the easy escape of heat of hydration from the concrete mass the risk of cracking can also be minimized by reducing the restraints on free expansion or contraction of the structure.

Design  Of Intze Water Tank Free Excel Sheet Download

LINK

Analysis, Design and Construction of Steel Space Frames

Analysis, Design, and Construction of Steel Space Frames 

G S Ramaswamy

Preference :

The Modern Construction Handbook has become a building construction classic and is used as a textbook in many courses. Its systematic approach with chapters on materials, walls, roofs, construction, and environment offers clear and efficient orientation. Digital fabrication techniques are included as well (complementing traditional production processes) and presented in an instructional book for the first time. The third edition has been thoroughly updated and now provides More information more annotation of drawings, more text on the page. The updated future chapter with more emerging construction techniques. Updated essays on construction in the introduction Chapter 1. Mote technical data in the Materials Chapter. The content in this third edition has been completely reworked which makes it an even more valuable companion for students and young practitioners!"

Content :

• 1. Introduction to space frames
• 2. Structural design of space frame components
• 3. Preliminary design
• 4. Double-layer flat space frames
• 5. Time- and labor-saving aids for pre and post-processing tasks
• 6. Space trusses for long spans
• 7. Braced barrel vaults
• 8. Braced domes
• 9. Optimization techniques
• 10. Stability checks

Download Analysis, Design, and Construction of Steel Space Frames free PDF

LINK

Building a Successful Construction Company

Building a Successful Construction Company

Netscher, Paul

Preference :

Many people think there’s lots of easy money to be made in construction. They may be working for a construction company and see owners and senior managers driving expensive cars, or they hear of companies doing well and declaring big profits. It seems to be a fast way to make money. So, many good tradesmen give up their jobs, invest their life savings, and start their own construction business. Unfortunately, the truth is that for every rich and successful person in the construction industry there are probably at least ten others, business owners and managers, who aren’t as successful, working long hours and taking home an average salary. Furthermore, there are probably several business owners who’ve lost their companies and are once more working for a boss, sometimes even in another industry. Nearly all of these people are skilled and knowledgeable and I’m sure every one of them worked hard. Many of them probably even completed successful projects, and yet, their company wasn’t successful and eventually collapsed.

Content :

Introduction

Chapter 1 – The Right Project

Chapter 2 – Finding The Right Projects

Chapter 3 – Tendering (Preparing The Quotation)

Chapter 4 – Securing The Project

Chapter 5 – Delivering The Project

Chapter 6 – Reducing Costs

Chapter 7 – Maximising Revenue

Chapter 8 – Financial Management

Chapter 9 – Contractual

Chapter 10 – People

Chapter 11 - Managing The Company

Chapter 12 – Growing The Company

Chapter 13 – Reputation

Conclusion

Download Building a Successful Construction Company free PDF

LINK

Project Recovery: Case Studies and Techniques for Overcoming Project Failure

Project Recovery: Case Studies and Techniques for Overcoming Project Failure 

Harold Kerzner

Preference :

Most people have a relatively poor understanding of what is meant by proj- ect success and project failure. As an example, let’s assume you purchase a new car that contains a lot of electronic gadgetry. After a few days, some of the electronics fail to work correctly. Was the purchase of the new car a success or a failure? Most people would refer to this as a glitch or small problem that can be corrected. If the problem is corrected, then you would consider the purchase of the new car as a success.

Content :

• 1 Understanding Success and Failure
• 2 Causes of Project Failure
• 3 Business Case Failure
• 4 Sponsorship/Governance Failures
• 5 Project Politics and Failure
• 6 Software Failures
• 7 Safety Considerations 
• 8 Scope Creep 
• 9 Project Health Checks
• 10 Techniques for Recovering Failing Projects

Download Project Recovery: Case Studies and Techniques for Overcoming Project Failure free PDF

LINK

Project Risk Management Guidelines

Project Risk Management Guidelines 

Dale F. Cooper

Preference :

The risk management processes described in this book had their genesis well over 20 years ago when I accepted a position at the University of Southampton. There I met and worked with Dr. Chris Chapman, already an acknowledged expert in project risk, with an established relationship with BP and an extensive client base in Canada. Chris involved me in his consulting activities in North America, primarily associated with quantitative risk analyses of large projects in the hydroelectric and the oil and gas industries. This was a time of innovation, as there were few protocols or models for the kinds of risk analyses that were required for these projects, and the quantitative calculations used a form of numerical integration called the Controlled Interval and Memory approach, developed by Chris, that was implemented in bespoke software. We had to develop different model structures and forms of analysis, and new software had to be written on some occasions to accommodate the new structures. It was highly stimulating, at times exhausting, and great fun, and I learned a huge amount from Chris and the clients with whom we worked.

Content :

• Part I The basics of project risk management
• Part II Extending the basic process
• Part III Quantification of project risks
• Part IV Additional information and supporting material

Download Project Risk Management Guidelines free PDF

LINK

The Complete Book Of Underground Houses

The Complete Book Of Underground Houses 

Rob Roy

Preference :

According to Roy, underground or `earth-sheltered' houses are unexpectedly livable. Judging by his book's attractive pictures, that's easy to believe. The house he bases his point-by-point guide on is indeed a showplace. Its homey touches are just that, though, and Roy's main concern is creating such a house, from drawing up the plans to surveying the site to the actual building. Roy's instruction is insightful and comprehensive...Throughout, he covers construction and installation details that are extremely important for nonprofessionals brave enough to undertake to build their own homes

Content :

• Past & Present
• Design
• Siting & Excavation
• The Footing
• The Floor
• External Walls
• Timber Framework
• Roof Deck
• Waterproofing
• Insulation, Drainage & Backfilling
• Earth Roof
• Retaining Walls & Landscaping

Download The Complete Book Of Underground Houses free PDF

LINK

 Design of Plate Girder with I Shape according to ASCE 

Plate girder design according to LRFD is very similar to the ASD method presented in the 8th Edition Manual of Steel Construction.8 The basic approach is unchanged, with the major changes being the addition of an additional bearing strength formula to check and some new AASHTO criteria for stiffener design.

LINK

 Design of Circular Water Tank Excel Sheet 

The underground water tanks can be divided into rectangular or circular in shape. Properties Rectangular Underground Water Tank Circular Underground Water Tank When to construct? When the capacity of liquid to be stored is small Capacity of liquid to be comparatively large Maximum Principal Stress The rectangular and circular water tanks of the same capacities may have stress results less than circular tanks. e.g. for a capacity for both types, the maximum stress calculated for rectangular water tank was 5.32N/mm2 Greater than rectangular tanks e.g. For circular water tank, 7.1N/mm Resistance to pressure Less In case of resistance to all pressure exerted in the tank circular is better. Area of steel Area of reinforcement of circular tank is greater Less

Design of Circular Water Tank Excel Sheet Free Download

LINK

 Free Excel Sheet to Design Rectangular Drains 

This document contains design calculations for Surface stormwater drains ( Plant)

Total plant drains are divided into two types of drains based on the suitability /

requirements as given below. 

i) Rectangular concrete open drains  - Within the unit areas / Building areas

ii) Trapezoidal concrete open drains   - outside the building areas

The analysis is carried out based on the basic input parameters furnished in the Civil Structural

Design Basis  Document. However, furnished below for easy reference

Download Free Excel Sheet to Design Rectangular Drains

LINK

Project Management: How to Plan and Manage Successful Projects

Project Management: How to Plan and Manage Successful Projects 

Joan Knutson, Ira Bitz

Preference :

Project management is the discipline that relates all of those words that you thought of that apply to the project. This discipline cultivates the expertise to plan, monitor, track, and manage the people, the time, the budget, and the quality of the work on projects. Project management fulfills two purposes: (1) It provides the technical and business documentation to communicate the plan and, subsequently, the status that facilitates comparison of the plan against actual performance, and (2) it supports the development of the managerial skills to facilitate better management of the people and their project(s). Project management is a proactive style of management. Negotiation techniques and good communication and analytical skills are integral parts of this approach. Another key ingredient is the evaluation of performance against those objectives. Central to this management style is the application of high standards of quality to the project work.

Content :

• Chapter 1—Introduction to Project Management
• Chapter 2—Initiating a Project
• Chapter 3—Building the Project Team
• Chapter 4—A Model for Project Planning
• Chapter 5—Project Planning Techniques: Schedule, Cost, and Resource Utilization
• Chapter 6—Managing Project Change
• Chapter 7—A Model for Project Control
• Chapter 8—Project Control Techniques: Status Reports and Reviews
• Chapter 9—A Model for Earned Value: Achievement-Accomplishment Monitoring

Download Project Management: How to Plan and Manage Successful Projects free PDF

LINK

Post-Tensioned Concrete: Principles and Practice, Third Edition

Post-Tensioned Concrete: Principles and Practice, Third Edition 

K. Dirk Bondy

Preference :

Writing this book has been a labor of love and it actually began back in the mid-1990s, though I didn’t realize it at the time. Much of the early chapters were written when I was teaching Prestressed Concrete Design at California Polytechnic State University at Pomona. I was a young man at the time, but I was lucky enough to have access to some of the greatest post-tensioned concrete engineers in the world. Over the years Bryan and I have learned the art of designing and detailing post-tensioned concrete from men such as my father, Ross Ellena, Ed Workman, Merrill Walstad, Florian Barth, and Chris Deetz. We both owe a tremendous debt of gratitude to all these men for sharing their wisdom. I also want to acknowledge Trailer Martin, C.K. Allen, Bob Englekirk, and Jim Cagley who were friends of my father before I even knew I wanted to be a structural engineer and offered opportunities and served as role models for me throughout my developing career.

Content :

• 1) History of Post-Tensioned Concrete in United States Building Construction 
• 2) Design Philosophy, Equivalent Loads & Concrete Stresses on Determinate Systems.
• 3) Review of Moment Distribution 
• 4) Concrete Stresses in Indeterminate Systems 
• 5) Flexural Design 
• 6) Shear Design 
• 7) Two-Span Beam Design Example 
• 8) One-Way Slab Design Examples
• 9) Two-Way Slab Design Examples 
• 10) Two-Way Podium Slab Design Example 
• 11) Mat Foundation Design Example 
• 12) Seismic Diaphragm Design Example 
• 13) Design & Detailing for Mitigation of Restraint to Shortening Cracking 
• 14) Construction Issues and Structural Observations 
• 15) Slabs-on-Ground 
• 16) External Post-Tensioning 
• 17) About the Authors

Download Post-Tensioned Concrete: Principles and Practice, Third Edition free PDF

LINK

Learn Excel: Top Functions - Quick Reference Guide with 500 Examples

Learn Excel: Top Functions - Quick Reference Guide with 500 Examples 

Andrew Watts

Preference :

Knowing how to use the built-in functions in Microsoft Excel will turn you into a power user! There are hundreds of functions and at first, the list can seem overwhelming. Even as a Microsoft Office Expert in Excel 2013 I do not know all of the Excel functions available. In writing this eBook, I discovered several new functions that I have now incorporated into my daily use and have made my data analysis more efficient. I hope that this eBook will help you learn more about the Excel functions and that they would help you gain control over your spreadsheets!

Content :

This Lean Excel series focuses on time-saving tools that will help you reduce the waste associated with data analysis. One of the tenets of lean manufacturing theory is using specialized tools to accomplish a task. You could use a wrench to drive a nail but a hammer will get the job done much faster. Remember time is money. Think of the built-in functions as specialized tools. Let’s say you needed to find the average of a dataset that is in A1 through A5. Remember the average is the sum of all the numbers in a dataset divided by the count of numbers in that dataset. Let’s look at three ways to find the average. First, you could use the formula =(A1+A2+A3+A4+A5)/5. Second, you could use the SUM and COUNT functions =SUM(A1:A5)/COUNT(A1:A5). Or lastly, you could use the AVERAGE function =AVERAGE(A1:A5). Although all three options give you the same answer, using the AVERAGE function is clearly the most efficient. But in order to use the AVERGE function, you need to know that it exists and what requirements you need to use it.

Download Modern Learn Excel: Top Functions - Quick Reference Guide with 500 Examples free PDF

LINK