Category: Excel Sheets Templates

Professional tools for calculations and dimensioning of mechanical engineering problems using Excel spreadsheets.

Wind Analysis for Trussed Tower Based on ASCE 7-16

Wind Analysis for Trussed Tower Based on ASCE 7-16

 

Wind analysis for trussed tower sheet examines structural forces present in a four-sided truss tower modeled as a support system for a wind turbine. Case I examined only forces due to the weight of the nacelle and rotor, while Case II also incorporated lateral wind force. All forces were idealized as concentrated forces and theoretic analysis was completed using static equilibrium concepts and truss/frame analysis techniques. A PASCO Structure kit was used to construct a model and validate theoretical findings. Weights were applied to the model and the resulting axial forces were measured using load cells. Experimental data concurred with the theoretical analysis within the measured uncertainty, indicating the tower was accurately analyzed as a frame/truss structure.
Main Wind Force Resisting System
• Elements of the structure which are essential to keeping
the entire structure from collapsing due to wind.
Components and Cladding
• Elements (Structural or Non-Structural) which transmit
wind forces to the Main Wind Force Resisting System.
• Not essential for overall structural stability

[su_button url=”https://drive.google.com/open?id=1wth6EHBTj5z297kISIZ8OhTSOIUpkYyg” size=”7″ center=”yes”] Download Link[/su_button]

Concrete Creep, Shrinkage Factors and Tensile Strength Calculation

Concrete Creep, Shrinkage Factors and Tensile Strength Calculation

This spreadsheet provides values of creep factors, concrete tensile strengths and free shrinkage strains for use with finite element slab design programs that take account of concrete cracking (non-linear analysis). The methods used are those recommended in Concrete Society Technical Report No TR58. With programs that do not account for cracking, substantially higher creep factors should be employed, to allow for the increased displacements caused by cracking and shrinkage.If each stage is analysed with its’ own φ factor and fctm, then ζ and fctm for the critical load case should be used at subsequent stages. If the calculation method employed does not do this, say NO at cell J14. For slabs with nominal or low restraint use fctmfl, and for severe restraint use fctm. An intermediate value may be used.

 

[su_button url=”https://drive.google.com/open?id=1q0AKfsR3mCG6HuFXv0-2Om7TDp–VsDL” size=”7″ center=”yes”] Download Link[/su_button]

Prestressed Post-Tensioned Concrete Section

Prestressed Post-Tensioned Concrete Section

 

Prestress is defined as a method of applying pre-compression to control the stresses resulting due to external loads below the neutral axis of the beam tension developed due to external load which is more than the permissible limits of the plain concrete. The pre-compression applied (may be axial or eccentric) will induce the compressive stress below the neutral axis or as a whole of the beam c/s. Resulting either no tension or compression.Prestressed concrete is basically concrete in which internal stresses of a suitable magnitude and distribution are introduced so that the stresses resulting from the external loads are counteracted to a desired degree.

Download Link

Circular Column Analysis and Design spreadsheet

Circular Column Analysis and Design spreadsheet

Circular Column is an Excel Spreadsheet template for the design of Circular columns using BS8110. Because of its shape, all columns are considered as subjected to uniaxial bending.
When it is required to consider a column with bi-axial bending, the two eccentricities can be combined to make it a column having one eccentricity moment. RoundCol can hold design information for up to 200 columns. Using a pull down combo box, the design information for any column can be retrieved, amended and re-saved for design use as and when necessary. Each Column in RoundCol can have up to 6 Loading Cases.
Although the design results are displayed for one load case at a time, Circular Column checks the design for all 6 loading cases in one step. If a column fails the design checks for any of its load cases, the Fail-Code is shown indicating the failure. Detailed results for any load case can be displayed by the click of its radio button and also printed as and when required.

[su_button url=”https://drive.google.com/open?id=18cbKBJ0XtqZlEChQwrgl4RyNmmgtPq79″ size=”7″ center=”yes”] Download Link[/su_button]

 

Prestressed Concrete Circular Hollow Pole/Pile Design Based on ACI 318-14 & AASHTO 17th

Prestressed Concrete Circular Hollow Pole/Pile Design Based on ACI 318-14 & AASHTO 17th

 

Prestressed concrete circular hollow poles offer several advantages, Compared with normally reinforced concrete poles.
Prestressed poles are lighter and stronger, and they require less reinforcing steel.
The concrete is generally in compression, so cracking is unlikely except from rough handling, and the concrete that is used is usually of higher strength so it can withstand the prestressing operation.
Due to the special manufacturing process, in which the poles are spun at high speeds, they have a smoother surface that is denser and less permeable.
This lower permeability in combination with the absence of cracks prevents corrosion of reinforcement or prestressing
wire.

Download Link

Seismic Earth Pressure of Deep Stiff Wall Spreadsheet

Seismic Earth Pressure of Deep Stiff Wall Spreadsheet

 

Seismic Earth Pressure of Deep Stiff Wall Spreadsheet is very important sheet. Building codes are guiding documents for design and construction specifications to meet a prescribed acceptable amount of risk. Generally, provisions are adopted in response to poor performance; this is especially true for seismic provisions. Changes to U.S. building codes in response to poor performance during earthquakes were published in the SEAOC Blue Book (2009). However, despite no observation of damage to basements due directly to seismic earth pressure, provisions have been introduced into building codes that impact design and costs.

Download Link

Concrete Box Culvert analysis and Design Spreadsheet

Concrete Box Culvert analysis and Design Spreadsheet

 

A culvert is a structure that allows water to flow under a road, railroad, trail, or similar obstruction.

Typically embedded so as to be surrounded by soil, a culvert may be made from a pipe, reinforced concrete or other material.

It’s a structure that carries water above land is known as an aqueduct.

Download Link

error: Content is protected !!
Exit mobile version