Analysis of Concrete Slabs on Grade Spreadsheet

Analysis of Concrete Slabs on Grade Spreadsheet

 

Analysis of concrete slabs on grade is a spreadsheet program written in MS-Excel for the purpose of analysis of concrete slabs on grade. Specifically, a concrete slab on grade may be subjected to concentrated post or wheel loading.

Then for the given parameters, the slab flexural, bearing, and shear stresses are checked, the estimated crack width is determined, the minimum required distribution reinforcing is determined, and the bearing stress on the dowels at construction joints is checked. Also, design charts from the Portland Cement Association (PCA) are included to provide an additional method for determining/checking required slab thickness for flexure. The ability to analyze the capacity of a slab on grade subjected to continuous wall (line-type) load as well as stationary, uniformly distributed live loads is also provided. Loading data for fork trucks and AASHTO trucks is included.

 

Download Link

Arch Bridge Analysis using Finite Element Method

Arch Bridge Analysis using Finite Element Method

 

Arch bridges have been built from the time of the Romans onwards. There are approximately 75,000 masonry arch bridges in service on road, railway and waterway networks in the United Kingdom with the majority of these bridges built between the 17th and 19th centuries.

The assessment of old masonry arch bridges is not a simple matter as such bridges have been serving the traffic over centuries and the material may be deteriorated and weathered to a certain extent. These bridges are now carrying weights far beyond those envisaged by their builders. Since January 1999, under new European Commission Directives, the maximum allowable gross vehicle weight has been increased from 38t to 44t and simultaneously the maximum axle load increased from IOt to 11. St. Figure 1.1 shows the increase in the maximum allowable single axle load from 1967 to 1999. The increases in traffic load have compelled both local and national highway authorities to undertake assessment and strengthening of their stocks of masonry arch bridges. Abnormally large heavy loads also require special one-off assessments typical of which was the 240t oil rig leg seen in Figure 1.2 crossing Balmoor bridge, Inverugie in 1991.

Finite element analysis became famous in the last few decades mainly due to the development of powerful computers. The advantage of this method over other conventional structural analyses is that it can be used for statically indeterminate structures with irregular shapes and different boundary conditions. Non-linear material properties can also be defined giving non-linear structural behaviour up to ultimate limit state.

The concrete post-tensioned structural design is actually sections design, no matter box girder, circular column, or other sections. There are three kind of forces on each section: 1. External loads, w only without PT, section forces. The External loads can be ASD level for serviceability design, or SD level for ultimate strength design. 2. Primary equivalent loads, PT section forces. The tendon is mentally removed and replaced with all of the loads it exerts on the structure. 3. Secondary section forces from all reactions of primary PT , on free-body structure.

 

Download Link

Staircase Analysis and Design Spreadsheet

Staircase Analysis and Design Spreadsheet

 

Staircases provide means of movement from one floor to another in a structure. Staircases
consist of a number of steps with landings at suitable intervals to provide comfort and safety
for the users.

Types of Stairs
For purpose of design, stairs are classified into two types; transversely, and longitudinally
supported.
a- Transversely supported (transverse to the direction of movement):
Transversely supported stairs include:
§ Simply supported steps supported by two walls or beams or a combination of both.
§ Steps cantilevering from a wall or a beam.
§ Stairs cantilevering from a central spine beam.
b- Longitudinally supported (in the direction of movement):
These stairs span between supports at the top and bottom of a flight and unsupported at the
sides. Longitudinally supported stairs may be supported in any of the following manners:
a. Beams or walls at the outside edges of the landings.
b. Internal beams at the ends of the flight in addition to beams or walls at the outside edges of
the landings.
c. Landings which are supported by beams or walls running in the longitudinal direction.
d. A combination of (a) or (b), and (c).

e. Stairs with quarter landings associated with open-well stairs.

Download Link

Shear Strengthening of T-beam with FRP

Shear Strengthening of T-beam with FRP

 

The rehabilitation of existing reinforced concrete (RC) bridges and building becomes necessary due to ageing, corrosion of steel reinforcement, defects in construction/design, demand in the increased service loads, and damage in case of seismic events and improvement in the design guidelines. Fiber-reinforced polymers (FRP) have emerged as promising material for rehabilitation of existing reinforced concrete structures. The rehabilitation of structures can be in the form of strengthening, repairing or retrofitting for seismic deficiencies. RC T-section is the most common shape of beams and girders in buildings and bridges. Shear failure of RC T-beams is identified as the most disastrous failure mode as it does not give any advance warning before failure. The shear strengthening of RC T-beams using externally bonded (EB) FRP composites has become a popular structural strengthening technique, due to the well-known advantages of FRP composites such as their high strength-to-weight ratio and excellent corrosion resistance.

A few studies on shear strengthening of RC T-beams using externally bonded FRP sheets have been carried out but still the shear performance of FRP strengthened beams has not been fully understood. The present study therefore explores the prospect of strengthening structurally deficient T-beams by using an externally bonded fiber reinforced polymer (FRP).
This study assimilates the experimental works of glass fiber reinforced polymer (GFRP) retrofitted RC T-beams under symmetrical four-point static loading system. The thirteen number of beams were of the following configurations, (i) one number of beam was considered as the control beam, (ii) seven number of the beams were strengthened with different configurations and orientations of GFRP sheets, (iii) three number of the beams strengthened by GFRP with steel bolt-plate, and (iv) two number of beams with web openings strengthened by U-wrap in the shear zone of the beams.

The first beam, designated as control beam failed in shear. The failures of strengthened beams are initiated with the debonding failure of FRP sheets followed by brittle shear failure. However, the shear capacity of these beams has increased as compared to the control beam which can be further improved if the debonding failure is prevented. An innovative method of anchorage technique has been used to prevent these premature failures, which as a result ensure full utilization of the strength of FRP. A theoretical study has also been carried out to support few of the experimental findings.

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

Two Way Slab Design Spreadsheets to Eurocode 2

Two Way Slab Design Spreadsheets to Eurocode 2

 

Two-way spanning slabs For rectangular slabs with standard edge conditions and subject to uniformly distributed loads, normally the bending moments are obtained using tabulated coefficients. Suchcoefficients are provided later in this section.
Main reinforcement for two way slabs designs in both directions.
This situation happen when slab were supported at all four span sides and
ratio long per short span less or equivalent to two. Bending moment and shear
force for two way slab depends on ratio ly / lx and extension between his slab
and supporter whether easily supported or constrained.Two way simply supported slab
have a panel and easily supported in edge and panel can lift upward when moment acting on
it, slab is supported by beam steel or extension between slab and non monolithic beam.
Moment only exist in center part of span.
Two way slab constrained have more than one panel or in section slab edge can be prevent from lifted. This situation happen when slab connected by monolithic with the supporter or slab panel connected by monolithic between one and another and moment acting at slab edge. This type of slab has four moment value at one slab panel namely two moment amid span and two moment at direction x and y.
[su_button url=”https://drive.google.com/open?id=1I6B2Kbw5ne5sjQu4RnCMkvg63GqYaHMF” size=”5″ center=”yes”]Download Link[/su_button]

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]

 

error: Content is protected !!
Exit mobile version