Spreadsheets

Calculation Spreadsheets

Please verify all spreadsheets.

The spreadsheets I create are very basic and not very well formatted. I do this mostly because it forces you to understand how the spreadsheet works and possibly create your own. Having said that, green text normally denotes that a value needs to be entered. Sometimes purple or orange may indicate that the value needs to be iterated. Sometimes blue is used to highlight a result.

I am currently trying to learn VBA (in my non-existent free time) and become better at creating spreadsheet calculations.  I mainly use TEDDS for calculations as it is faster (for me) and easier to follow the procedure.

Disclaimer:

The material proposed in spreadsheets is intended for use by engineers familiar with the design of the respective topic and structural engineering principles, and who accept total responsibility for the application of the procedures herein. Although every effort has been made to ensure the accuracy of the material in the spreadsheet, the author disclaims any and all liability and responsibility for the accuracy and application of the material to the full extent permitted by the law.

List of spreadsheets:

Masonry:

Shear Wall ASD – Force Equilibrium Adjusted Spacing Spreadsheet

Earth Retention

Trial Wedge Spreadsheet

Lateral Earth Pressure – Coulomb

 

 

 

1 comment for “Spreadsheets

  1. January 22, 2015 at 7:29 pm

    Good post! I would also recommend this website for spreadsheets not covered above:

    http://www.YourSpreadsheets.co.uk

    It contains a large collection of high quality yet easy to use Excel spreadsheets for engineers, architects, contractors and regular house owners. Also includes a large database of free resources: CAD/Revit titleblocks, steel sections in CAD, list of material weights etc. Extremely handy!

Thoughts? Comments? Questions?