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 othedirection. 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


Design of Wing Wall Spreadsheet

 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


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

 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


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

 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


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

 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

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

 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

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






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

     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.






    Engineering Materials 1: An Introduction to Properties, Applications and Design

    Engineering Materials 1: An Introduction to Properties, Applications, and Design 

    D R H Jones

    Preference :

    Innovation in engineering often means the clever use of new material — new to a particular application, but not necessarily (although sometimes) new in the sense of recently developed. Plastic paper clips and ceramic turbine-blades both represent attempts to do better with polymers and ceramics what had previously been done well with metals. And engineering disasters are frequently caused by the misuse of materials. When the plastic teaspoon buckles as you stir your tea, and when a fleet of aircraft is grounded because cracks have appeared in the tailplane, it is because the engineer who designed them used the wrong materials or did not understand the properties of those used. So it is vital that the professional engineer should know how to select materials that best fit the demands of the design — economic and aesthetic demands, as well as demands of strength and durability. The designer must understand the properties of materials and their limitations.






    Content :
    • A. Price and availability
    • B. The elastic moduli
    • C. yield strength, tensile strength, and ductility
    • D. Fast fracture, brittle fracture, and toughness
    • E. Fatigue failure
    • F. Creep deformation and fracture
    • G. Oxidation and corrosion
    • H. Friction, abrasion, and wear
    • I. Designing with metals, ceramics, polymers, and composites


    Download Engineering Materials 1: An Introduction to Properties, Applications, and Design free PDF

    LINK

    Design of Circular Water Tank Excel Sheet

     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






    Free Excel Sheet to Design Rectangular Drains

     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






    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