Professional tools for calculations and dimensioning of mechanical engineering problems using Excel spreadsheets.
This spreadsheet is written to analyze and design concrete one cell box culverts
Reinforcing Bar Development and Splice Length Spreadsheet is a spreadsheet program written in MS-Excel for the purpose of determining reinforcing bar development and splice lengths. Specifically, the development lengths and splice lengths for straight bars in tension as well as compression are determined. Also, the development length for standard hook bars is determined. The provisions for development and splice lengths are included for high seismic risk applications per ACI 318M-05, Chapter 21. There is also a worksheet which contains reinforcing bar data tables. This METRIC version is based on the ACI 318M-05 Code.
A spreadsheet is a computer application that simulates a paper worksheet where becoming increasingly popular in solving engineering related problems. Among the strong features of spreadsheets are their instinctive cell-based structure and easy to use capabilities.
Excel, for example, is a powerful spreadsheet with VBA robust programming capabilities that can be a powerful tool for teaching civil engineering concepts.
Spreadsheets can do basic calculations such as cost estimates, schedule and cost control, and markup estimation, as well as structural calculations of reactions, stresses, strains, deflections, and slopes.
Spreadsheets can solve complex problems, create charts and graphs, and generate useful reports. This paper highlights the use of Excel spreadsheet and VBA in teaching civilengineering concepts and creating useful applications.
The Engineering Community provide Excel Spreadsheets for Civil & Structural Engineers for structural design.
All spreadsheets that you can download are fully functional.
This collection includes following spreadsheets under following categories,
Civil Engineering Spreadsheets
Structural Details
Geotechnical Spreadsheets
Finite Element Method (FEM) Spreadsheets
This is a spreadsheet for the seismic design of primary reinforced concrete beams to EN1998-1
It performs the following resistance and ductility verifications:
5.4.1.2.1(2) Maximum beam eccentricity
5.4.1.2.1(3) Maximum beam width
5.4.3.1.1(1) Resistance in bending and shear
5.4.3.1.1(3) Effective flange width beff
5.4.3.1.2(1) Length of critical zones lcr
5.4.3.1.2(3) Curvature ductility factor – Cl. 5.2.3.4(3)
5.4.3.1.2(4) a) Minimum reinforcement at the compression zone
5.4.3.1.2(4) b) Maximum reinforcement ratio of the tension zone
5.4.3.1.2(5) Minimum reinforcement ratio of the tension zone
5.4.3.1.2(6) a) Minimum diameter of hoops within the critical regions
5.4.3.1.2(6) b) Maximum spacing of hoops within the critical regions
5.6.2.2(2) Anchorage of beam reinforcement – maximum bar diameter
Source: https://www.linkedin.com/in/andresilvacorreia
A preliminary estimation of the effectiveness of soil improvement by vibro replacement with stone columns is performed classicaly by Priebe’s method, which has been implemented in several dedicated commercial softwares. However, this method is simple enough to incorporate in a simple spreadsheet, with no special programming. The method is described extensively in “Priebe, H.J. (1995) The design of Vibro Replacement, Ground Engineering (Dec), pp 31-37.”
An implementation of Priebe’s method for infinite loaded areas and for square footings has been added to the “Downloads” section of the website. This spreadsheet, is completely free and open-source and comments and suggestions for improvement are always welcome.
Source: https://www.linkedin.com/in/andresilvacorreia
This is a spreadsheet for the analysis of laterally loaded single elastic piles. The pile-soil interaction is modelled with elasto-plastic springs defined by their stiffness and maximum force. Free or fixed conditions may be specified at the pile head.
This soil behaviour model provides excellent results and is usually sufficient to handle most of the buiding and bridge foundations design work. However, more advanced p-y or continuum models may be necessary for large rafts, high loads, offshore structures, unusual geotechnical conditions, cyclic loading, etc. As usual with any tool, proper engineering judgement is required.
An auxiliary worksheet is included in the file to demonstrate the calculation of spring properties. It presents an example that correlates CPT qc values with corrected SPT data and then proceeds to calculate springs’ stiffness and maximum passive forces.
The program allows the use of elastic piles of any shape, as the pile stiffness must be introduced directly and the soil springs properties input into the main worksheet already multiplied by their respective influence width.
Second order geometrically non-linear effects (P-Delta) are not taken into account in the analysis. Piles are assumed to remain elastic throughout the loading process.
The VBA module is, as usual, open source and the code is commented thoroughly.
Source: https://www.linkedin.com/in/andresilvacorreia
Two spreadsheets for the design of 2 and 4 piles caps by the Strut and Tie Method, taking into consideration the stress limits in EN1992-1-1.
The spreadsheet uses a combined model, allowing the use of the column reinforcement to reduce the compressive forces on the CCC(C) node at the column/cap connection. Only compressive axial forces in the column are considered.
Detailed handwritten notes of the model assumptions are also included in the files.
