-

Best Concrete Design EXCEL Spreadsheet

This spreadsheet consists of many segments regarding RCC aspects as described below:

Beam Design (Flexural design, Serviceability, Shear design)
Column Design
Slab Design
Grid Floor Analysis & Design
Staircase Design (Separate Excel spreadsheet)
Combined Footing (Foundation analysis and design)
Dome Design
Isolated Footing
3 Hinged Arch Design
Circular Beam
Slender Column
Bi-Axial Column
Deflection Calculation
DESIGN OF RETAINING WALL (Lateral earth pressure theory)
DESIGN OF L Shaped Cantilever RETAINING WALL
DESIGN OF Reverse L Shaped Cantilever RETAINING WALL

Analysis of a Pole Foundation spreadsheet

POLEFDN” is a spreadsheet program written in MS-Excel for the purpose of analysis of a pole foundation assuming the use of a rigid round pier which is assumed free (unrestrained) at the top and subjected to lateral and vertical loads.

Specifically, the required embedment depth, the maximum moment and shear, the plain concrete stresses, and the soil bearing pressures are calculated.This program is a workbook consisting of six (6) worksheets, described as follows:

Doc – Documentation sheet

Pole Fdn (Czerniak) – Pole foundation analysis for free-top round piers using PCA/Czerniak method

Pole Fdn (UBC-IBC) – Pole foundation analysis for free-top round piers using UBC/IBC method

Pole Fdn (OAAA) – Pole foundation analysis for free-top round piers using OAAA method

Granular Soil (Teng) – Pole foundation analysis in granular soil using USS/Teng method

Cohesive Soil (Teng) – Pole foundation analysis in cohesive soil using USS/Teng method

Program Assumptions and Limitations:

1. Since there is not a universally accepted method for pole foundation analysis, this program offers up five (5) different methods of determining embedment length for pole foundations. The “Pole Fdn(Czerniak)” worksheet is the primary method emphasized in this program, since it provides the most detail in overall analysis. However, it does yield the most conservative embedment depth results of all the methods presented.

2. The references used in the different analysis methods in this program are as follows:

a.”Design of Concrete Foundation Piers” – by Frank Randall Portland Cement Association (PCA) – Skokie, IL, May 1968

b.”Resistance to Overturning of Single, Short Piles” – by Eli Czerniak ASCE Journal of the Structural Division, Vol. 83, No. ST2, Paper 1188, March 1957

c.1997 Uniform Building Code (UBC), Section 1806.8, page 2-45

d.Outdoor Advertising Association of America (OAAA) – New York, NY

e.”Tapered Steel Poles – Caisson Foundation Design” Prepared for United States Steel Corporation by Teng and Associates, July 1969

f.AASHTO Publication LTS-5 – Standard Specifications for Structural Supports for Highway Signs, Luminaries, and Traffic Signals (Fifth Edition, 2009)

Note: references “a” and “b” refer to the “Pole Fdn(Czerniak)” worksheet, while references “e” and “f” refer to both the “Granular Soil(Teng)” and “Cohesive Soil(Teng)” worksheets.

3. The “Pole Fdn(Czerniak)” worksheet assumes that the foundation is short, rigid, meeting the criteria that the foundation embedment length divided by the foundation diameter
4. This program will handle both horizontally as well as vertically applied loads. The vertical load may have an associated eccentricity which results in an additional overturning moment which is always assumed to add directly to the overturning moment produced by the horizontal load.

5. This program assumes that the top of the pier is at or above the top of the ground surface level.

6. This program assumes that the actual resisting surface is at or below the ground surface level. This accounts for any weak soil or any soil which may be removed at the top.

7. The “Pole Fdn(Czerniak)” worksheet assumes that the rigid pier rotates about a point located at a distance, ‘a’, below the resisting the surface. The maximum shear in pier is assumed to be at that ‘a’ distance, while the maximum moment in the pier is assume to be at a distance = ‘a/2′.

8. The “Pole Fdn(Czerniak)” worksheet calculates the “plain” (unreinforced) concrete stresses, compression, tension, and shear in the pier. The respective allowable stresses are also determined based on the strength (f’c) of the concrete. This is done to determine if steel reinforcing is actually required. However, whether minimum reinforcing is to be used or not is left up to the user. The allowable tension stress in “plain” concrete is assumed to be equal to 10% of the value of the allowable compressive stress.

9. The “Pole Fdn(Czerniak)” worksheet calculates the actual soil bearing pressures along the side of the pier at distances equal to ‘a/2′ and ‘L’. The respective allowable passive pressures at those locations are determined for comparison. However, it is left up to the user to determine the adequacy.

10. Since all overturning loads are resisted by the passive pressure against the embedment of the pier, this program assumes that the pier acts in direct end bearing to resist only the vertical loading. The bottom of pier bearing pressure is calculated, which includes the self-weight of the pier, assumed at 0.150 kcf for the concrete

Download Link

Design of highways spreadsheets

Excel spreadsheets used in Design of Highways.

List of files:

Calculation Sheet for Ts, Es etc.
MX Input for Super Elevation (IRC & AASHTO).
MX Input for Super Elevation (IRC).
Set Back Distance calculation.

Download Link

18 Masonry Design spreadsheet

AnchorageToMasonry.xls

BeamToWall.xls

BearingWallOpening.xls

BendingPostAtTopWall.xls

CollectorToWall.xls

DevelopmentSpliceMasonry.xls

Elevator-DSA-OSHPD.xls

FlushWallPilaster-CBC.xls

FlushWallPilaster-IBC.xls

GirderAtWall.xls

HorizontalBendingWall.xls

MasonryBeam.xls

MasonryBearingWall-CBC.xls

MasonryBearingWall-IBC.xls

masonrycolumn-cbc.xls

masonrycolumn-ibc.xls

masonryshearwall-cbc.xls

MasonryShearWall-IBC.xls

Download link

Pile Design by IS & IRS Codes

Download Link

Autodesk Spreadsheet Calculator for RSA Pro 2013

Engineering spreadsheet environment and spreadsheet hosting application with embedded links to Robot Structural Analysis products, allowing users to integrate their spreadsheet applications and communicate with Robot Structural Analysis.

Spreadsheet Calculator consists of a set of simple and complex calculation schemas for many areas of structural engineering. It provides a practical representation of codes and standards that can be used when performing calculations as well as detailed formulas for specific engineering problems. You can create complex calculations by selecting simple problems.

You can also add custom calculations to the existing schemas or create new schemas using the Spreadsheet Calculator tools. This way you can build a library of custom applications. Parameters can be exchanged between schemas so the output of a given calculation can serve as the input for other calculations.

Spreadsheet Calculator program is an open system.

You can have an unlimited number of new schemas, codes, libraries, languages.

Because Spreadsheet Calculator is built on COM technology, you can exchange information among other programs and engineering tools.

Output from Spreadsheet Calculator can be read as input into the Autodesk Robot Structural Analysis program. There is no need to type the information.

You can generate structure models using the Autodesk Robot Structural Analysis program.

You can perform a detailed analysis of structure data.Calculations are presented as complete technical documents containing detailed formulas, code references, and drawings. A generalized schema of a library module as well as its graphical form is maintained for all engineering problems.

Download link

Bar Bending Schedule Of Box Culvert

Definition of Bar bending

It is the method of bending reinforcing steel into shapes which are important for reinforced concrete construction.

Definition of Bar bending schedule(BBS)

Bar bending schedule alias schedule of bars refers to a list of reinforcement bars, a specified RCC work item that is shown in a tabular form for a smooth view. This table sums up all the necessary particulars of bars ranging from diameter, shape of bending, length of each bent and straight portions, angles of bending, total length of each bar, and number of each type of bar. This information can be used for making an estimate of quantities.

It includes all the details essential for fabrication of steel like bar mark, bar type and size, number of units, length of a bar, shape code, distance between stirrups (column, plinth, beam) etc.

While generating bar schedules, it is important to take proper care about length. In case of bending, bar length will be raised at the bending positions.

Benefits of the Bar Schedule:

When bar bending schedule is applied along with reinforcement detailed drawing, it makes the quality of construction superior.

Once bar bending schedule is prepared, cutting and bending of reinforcement is performed at factory and shipped to job site. This improves quick implementation at site and minimizes construction time and cost as fewer workers are needed for bar bending. Bar bending also circumvents the wastage of steel reinforcement (5 to 10%) and thus project cost is saved significantly.

It offers the perfect estimation of reinforcement steel requirement for all the structural members which are applied to workout complete reinforcement requirement for whole project.

Bar bending schedule offers the steel quantity requirement in a better way and thus delivers an option to make optimal use of the design in case of cost overflow.

The process becomes simple for site engineers to validate and approve the bar bending and cutting length throughout inspection prior to positioning of concrete with the support of bar bending schedule and thus facilitates in superior quality control.

It becomes easier to handle the reinforcement stock necessary for identified time duration.

It will facilitate to fabrication of R/F with structure.

Download Link

Surcharge Pressures Boussinesq multiple loads

This spreadsheet computes lateral pressure against retaining wall due to vertical surcharge area loads. It handles multiple area loads and uses theory of elasticity equations developed by Boussinesq. Subsequently, the spreadsheet calculates shear force and bending moment diagrams. Worksheet is protected but without password.

Download Link

Reinforced Retainig walls Design

Retaining walls must be reinforced in order to be effective. Too many forces are at work against a retaining wall that could cause it to tumble over if it is not reinforced correctly.

Download Link

“WALLPRES” – WALL PRESSURE ANALYSIS

Program Description:

“WALLPRES” is a spreadsheet program written in MS-Excel for the purpose of determining the horizontal (lateral) pressures to be applied to walls from various types of loading including lateral earth pressure, hydrostatic pressure, as well as uniform, point, line, and strip surcharge loadings.

This program is a workbook consisting of five (5) worksheets, described as follows:

Doc – documentation sheet
Wall Soil Pressures – Static horizontal soil pressure against wall
Wall Pressures from Point Load – Horizontal pressures on rigid wall from point surcharge load
Wall Pressures from Line Load – Horizontal pressures on rigid wall from continuous strip surcharge load
Wall Pressures from Strip Load – Horizontal pressures on rigid wall from continuous line surcharge load

Program Assumptions and Limitations:

1. This program is based on the following references:

a. NAVFAC DM-7.02 Manual – “Foundations & Earth Structures” (1986)
b. NAVFAC DM-7.01 Manual – “Soil Mechanics” (1986)
c. Army TM 5-818-1 / Air Force AFM 88-3, Chap. 7 (Oct. 1983) “Soils and Geology Procedures for Foundation Design of Buildings and Other Structures”
d. “Foundation Analysis and Design” (2nd Edition), by: Joseph E. Bowles McGraw-Hill, 1977
e. “USS Steel Sheet Piling Design Manual” – updated and reprinted by FHWA with permission (July 1984)
f. “Lateral Soil Pressure on Retaining Walls and Embedded Exterior Walls of Structures” Report U7-PROJ-S-RPT-STRU-6001, by: Sargent & Lundy, LLC (Feb. 26, 2009) for South Texas Project Units 3 & 4, Project No.: 12462-003

2. The resulting pressures obtained from the worksheets in this workbook can be used in the design of the stems of either cantilever or propped cantilever retaining walls, as well as for long walls of tanks and pits.

3. The equations used in the “Wall Pressures from Point Load” and “Wall Pressures from Line Load” worksheets are from References “a” through “e” above, utilizing original (1885) Boussinesq Equations modified to correlate with experimental test results. The Boussinesq equations assume the that wall is rigid and does not move, and that the wall is perfectly smooth (no shear stress between wall and soil). Thus, the equations overestimate the wall pressures for flexible walls by up to a factor of 2.

4. The equation used in the “Wall Pressures from Strip Load” worksheet is from References “d” and “e” above. Again, this equation assumes that the wall is rigid (does not move), which overestimates the wall pressures for flexible walls by up to a factor of 2. Thus, the factor of 2 appears in the numerator of this version of the equation. Other references may cite this equation without the factor of 2, which would normally be more applicable for flexible walls which are able to move at top.

5. This program contains “comment boxes” which contain information including explanations of input items, etc. (Note: presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the desired cell to view the contents of that particular “comment box”.)