Composed Column Calculation Spreadsheet
Category: Excel Sheets Templates
Professional tools for calculations and dimensioning of mechanical engineering problems using Excel spreadsheets.
Concrete Special Structural Wall ACI 318-08 Spreadsheet
Concrete Special Structural Wall ACI 318-08 Spreadsheet
The International Building Code (IBC) requires all concrete walls in seismic category D, E, and F, must be designed as a Special Reinforced Concrete Shear Wall. Basically all concrete walls in the West Coast of the US must be designed as a special wall.
The calcs in this spreadsheet are transparent unlike the typical blackbox calculations.
Also the figure of the wall in the spreadsheet changes with the input parameters.
The spreadsheet checks essentially all of the applicable codes in the ACI 318-08. The spreadsheet contains extensive boolean programming to address the convoluted nature of the code provisions for special concrete structural walls.
Anyone who has designed a special concrete structural wall knows how extremely complicated it can be, and will surely appreciate how easy to use and how thorough this spreadsheet is.
IMPORTANT: If upon opening this file, a warning message about circular referencing appears, DO NOT CLICK OK. You must CLICK CANCEL, click on Tools -> Options -> Calculation tab and enable Iteration as shown in the picture to the right. or the spreadsheet will not work properly. The reason for iteration: A vertical axial load P applied eccentrically on the wall will induce a deflection in the wall. The axial load P applied eccentrially on a wall that is deflected will cause it to deflect more. If this iteration was to be calculated by hand, it will take multiple iterations before the numbers converge to an acceptable level.
Calculation Reference
Reinforced Concrete
Seismic Loads for Liquid-Containing Rectangular RC Tank Spreadsheet
Anchor Bolt Anchorage Spreadsheet
ASCE 7-10 Load Combinations Spreadsheet
AISC-ASD89 calculation for Beam-Column member Spreadsheet
AISC-ASD89 calculation for Beam-Column member Spreadsheet
The sheet is designed for calculating the Unity Ratio of a member subjecting to Moment and Axial load.
Abutment Column Design Spreadsheet
Abutment Column Design Spreadsheet
This excel spreadsheet program may be used to design rectangular columns with uneven bars.
RC Column Design for Axial load Spreadsheet According ACI
RC Column Design for Axial load Spreadsheet According ACI
Design of columns are carried over a group of columns having a low variation of design values. In this group, design is carried for the highest values of axial force, moments about Y and Z directions, shear about Y and Z directions as well as torsion. However, it is a common practice among designers to ignore shear and torsion in columns. This practice will reduce safety factor in columns which are critical structural members responsible for the safety of the structure.
Construction Budget Template Spreadsheet
Construction Budget Template Spreadsheet
Construction budget template is very important for both construction and modeling projects. This template makes you to have a comprehensive construction project budget and guarantee that you account for all important items on the list. Additionally, while the construction project is underway, use this spreadsheet as a baseline to track whether you are over or under your budgeted amounts.
The template will be helpful to create an elaborate estimating and budgeting worksheet as it includes predefined sections for all the relevant parameters such as description, vendor, estimated cost, actual cost.This template also shows how a basic construction estimate should be. The template has taken a simplistic route, including the bare essentials like construction work description, estimated job cost & so on.
RC Shear Wall Analysis and Design Spreadsheet
RC Shear Wall Analysis and Design Spreadsheet
RC shear wall analysis and design excel sheet easy to use yet innovative construction spreadsheet is used to make the design of shear walls subject to wind and dead load combination. This shear wall design spreadsheet is very useful verifying constancy toward reinforced concrete structure.
It takes huge time while measuring & then remeasuring wall stiffnesses, direct and torsional rotation component of force to then estimate reinforcement and concrete stresses for a single wall successively. This shear wall design spreadsheet can significantly decrease your design time.
Presently, the sheet does not support the earlier version of excel like Excel 2003 and so on as these do not make out iferror function.
This estimating spreadsheet contains the following exclusive characteristics :
- An apparent and simplified output (all on a single page);
- Design Reinforced Concrete walls subject to dead and wind load combination;
- Enter highest and least safety factors for Dead Load toward most troublesome load combination;
- Identify superstructure and substructure height. Wind load can be assigned to above ground part of structure;
- Identify length of wall ends obstructing tension;
- Designs horizontal and vertical reinforcement;
- Verify least/highest acceptable reinforcement areas;
- ‘Live’ wall diagram;
- Design is created on the basis of British Standard