Crack Width Calculation Spreadsheet 

This excel sheet calculates crack width. Crack width calculation is one of the serviceability requirements in the structural concrete elements. The occurrence of cracks in reinforced concrete elements is expected under service loads, due to the low tensile strength of concrete. Control of cracking is important for obtaining an acceptable appearance and for the long-term durability of concrete structures, especially those subjected to aggressive environments.

Download Crack Width Calculation Free Spreadsheet  

LINK

What Every Engineer Should Know About Excel

What Every Engineer Should Know About Excel 

Jack P. Holman

Preference :

This collection of materials involving operations in Microsoft Excel is intended primarily for engineers,

although many of the displays and topics will be of interest to other readers as well. The procedures have been generated randomly as individual segments, which were distributed to classes as the need arose. They do not take the place of the many excellent books on the subjects of numerical methods, statistics, engineering analysis, or the information that is available through the Help features of the software packages. Some of the suggestions offered will be obvious to an experienced software user but will be less apparent or even eye-opening to others. It is this latter group for whom the collection was assembled. Some of the materials were written for use in classes in engineering laboratories and heat-transfer subjects, so several of the examples are slanted in the direction of these applications. Even so, topics such as solutions to simultaneous linear and nonlinear equations and uses of graphing techniques are pervasive and easily extended to other applications.

Content :

• Introduction
• Miscellaneous Operations in Excel and Word
• Charts and Graphs
• Line Drawings, Embedded Objects, Equations, and Symbols in Excel
• Solution of Equations
• Other Operations
• Financial Functions and Calculations
• Optimization Problems
• Data Management Resources in Excel
• Office 365 and Integration with Cloud Resources

Download What Every Engineer Should Know About Excel free PDF

LINK

Seismic Design for Ordinary Concentrically Braced Frames

Concentrically Braced Frames (CBFs) are a class of structures resisting lateral loads through a vertical concentric truss system, the axes of the members aligning concentrically at the joints. CBFs tend to be efficient in resisting lateral forces because they can provide high strength and stiffness. These characteristics can also result in less favorable seismic responses, such as low drift capacity and higher accelerations. CBFs are common structural steel or composite system in .areas of any seismicity

Download Free Seismic Design for Ordinary Concentrically Braced Frames  

Link

 Design of Cantilever and Girder Excel Sheet  

Design of Cantilever and Girder Excel Sheet allows you to calculate the loads and straining actions due to different types of load then finally calculate the RFT  for the cantilever and  girder 

Download Free Design of Cantilever and Girder Excel Sheet

 

LINK

Successful Project Management

Successful Project Management 

Jack Gido,

Preference :

Project management is more than merely parceling out work assignments to individuals and hoping that they will somehow accomplish the desired result. In fact, projects that could have been successful often fail because of such take-it-for-granted approaches. Individuals need hard information and real skills to work successfully in a project environment and to accomplish project objectives. Successful Project Management is written to equip its users with both—by explaining concepts and techniques and by using numerous examples to show how they can be skillfully applied. Although the focus of the book is squarely on the practical things readers absolutely need to know to thrive in project environments, the book does not forsake objective learning; it simply challenges readers to think critically about project management principles and to apply them within the context of the real world. We capture lessons learned from years of managing projects, teaching project management, and writing extensively about it

Content :

• CHAPTER 1 Project Management Concepts
• CHAPTER 2 Identifying and Selecting Projects
• CHAPTER 3 Developing Project Proposals
• CHAPTER 4 Defining Scope, Quality, Responsibility, and Activity Sequence 
• CHAPTER 5 Developing the Schedule
• CHAPTER 6 Resource Utilization
• CHAPTER 7 Determining Costs, Budget, and Earned Value
• CHAPTER 8 Managing Risk 
• CHAPTER 9 Closing the Project
• CHAPTER 10 The Project Manager 
• CHAPTER 11 The Project Team
• CHAPTER 12 Project Communication and Documentation 
• CHAPTER 13 Project Management Organizational Structures

Download Successful Project Management free PDF

LINK

Eccentric Shear Connection Analysis Of Bolt Group Spreadsheet

BoltGroup computes the shear capacity of an eccentrically loaded bolted connection using the LRFD instantaneous center of rotation method. Great tool for design of gusset plates and plate girder bolted splices. The analysis results have been verified with AISC tables. The spreadsheet provides a design summary, detailed results, and fundamental theory and formulas. 

Shear Connection Analysis Of Bolt Group

The bolt cross-sectional area is critical to the prior calculation.  The area of bolt available for use by a shear plane will depend on whether or not the shear plane is in a region of the bolt that is threaded.  If the shear plane is in a region that is threaded then there is less area available to resist the applied shear force.  The AISC specification requires you to determine whether or not threads are included in the shear plane or not when computing the capacity of a bearing type connection.  This is not an issue in slip-critical connections since the force is transferred by friction between the connected members and not by actual shear in the bolt.  We will look at this some more when we start computing actual bolt capacities.

Download Eccentric Shear Connection Analysis Of Bolt Group Free Spreadsheet

Download