Pile Group Analysis Spreadsheet

Pile Group Analysis Spreadsheet

 

“Pile Group Analysis Spreadsheet” is a spreadsheet program written in MS-Excel for the purpose of analysis of pile groups with rigid caps using the “elastic method”. Specifically, the properties of the pile group are calculated, and then based upon the applied vertical and horizontal loadings, the vertical and horizontal pile reactions are calculated.

There is also a worksheet to check beam and punching shear in the pile cap for a single corner pile, for the purpose of estimating the required pile cap thickness and subsequent pile cap weight.

 

Download Link

MOVING WHEEL LOADS ANALYSIS

MOVING WHEEL LOADS ANALYSIS

 

“Moving Load Analysis Spreadsheet” is a spreadsheet program written in MS-Excel for the purpose of analysis of simple-span members subjected to from one (1) up to eight (8) moving wheel loads with up to seven (7) wheel spacings. Specifically, the maximum moment and location from the left end of the member and wheel postioning, the maximum end shears, the maximum deflection, and the maximum center support reaction for two (2) adjacent simple-span members are calculated.

 

Download Link

SECTPROP – SECTION PROPERTIES ANALYSIS PROGRAM

SECTPROP – SECTION PROPERTIES ANALYSIS PROGRAM

 

“SECTPROP” is a spreadsheet program written in MS-Excel for the purpose of calculating section properties.Two methods of input data are provided, either by adding of deleting “shapes” or by defining a polygon by aseries of “points”. Specifically, the centroid location and total area are determined, as well as the centroidal andprincipal axes moments of inertia, radii of gyration, and rotation angle.

 

Download Link

Terzaghi’s Consolidation Equation – Closed Form Solution

Terzaghi’s Consolidation Equation – Closed Form Solution

Terzaghi’s one-dimensional consolidation equation simulates the visco-elastic behaviour of soils depending on the loads applied as it happens, for example, when foundation are laid and start carrying the weight of the structure.

Its application is traditionally based on Taylor’s solution that approximates experimental results by introducing non-theoretical variables that, however, contradict the actual behaviou of soils. After careful examination of the theoretical and experimental aspects connected with consolidation, the proposal of this research is a solution consisting in a non-linear equation that can be considered correct as it meets both mathematical and experimental requirements.

The solution proposed is extended to include differential equations relating to two/three dimensional consolidation by adopting a transversally isotropic model more consistent with the inner structure of soils.

Finally, this essay is complete with application examples that give more reliable results than the traditional solution. Future developments are also highlighted considering that the uniqueness theorem has not been proven yet.

 

Download Link

Terzaghi’s Consolidation Equation – Finite Difference Solution

Terzaghi’s Consolidation Equation – Finite Difference Solution

 

Terzaghi’s one-dimensional consolidation equation simulates the visco-elastic behaviour of soils depending on the loads applied as it happens, for example, when foundation are laid and start carrying the weight of the structure.

Its application is traditionally based on Taylor’s solution that approximates experimental results by introducing non-theoretical variables that, however, contradict the actual behaviou of soils. After careful examination of the theoretical and experimental aspects connected with consolidation, the proposal of this research is a solution consisting in a non-linear equation that can be considered correct as it meets both mathematical and experimental requirements.

The solution proposed is extended to include differential equations relating to two/three dimensional consolidation by adopting a transversally isotropic model more consistent with the inner structure of soils.

Finally, this essay is complete with application examples that give more reliable results than the traditional solution. Future developments are also highlighted considering that the uniqueness theorem has not been proven yet.

 

Download Link

Design Curved Beam Spreadsheet

Design Curved Beam Spreadsheet

 

Curved Beam is a beam in which the neutral axis in the unloaded condition is curved instead of straight. Or If the beam is originally curved before applying the bending moment.
Curved beams have applications in many machine members such as c – clampers , crane hooks, frames of  presses, chains, links, rings, etc
The main difference between curved beams and straight ones that the Neutral axis does not coincide with the cross section, but is shifted towards the center of curvature of the beam.
This spreadsheet will help you to design easily curved beams

Download Link

Design of Precast Prestressed Composite Beams Excel Sheet

Design of Precast Prestressed Composite Beams Excel Sheet

 

The precast prestressed concrete units are erected first and can be used to support the formwork needed for the cast in situ slab without additional scaffolding (or shoring).

In addition to its contribution to the strength and stiffness of the composite member, the cast in situ slab provides an effective means to distribute loads in the lateral direction.

The cast in situ slab can be poured continuously over the supports of precast units placed in series, thus providing continuity to a simple span system.Pre-tensioning in plant is more cost-effective than post-tensioning on site.

Because the precast 4 prestressed concrete element is factory-produced and contains the bulk of reinforcement, rigorous quality control and higher mechanical properties can be achieved at relatively low cost. The cast in situ concrete slab does not need to have high mechanical properties and thus is suitable to field conditions.

 

Download Link

error: Content is protected !!
Exit mobile version