I’d like to introduce my favorite engineering calculation spreadsheet. It’s called “An Engineer’s Toolbox” by AECCafe, and it’s available in both Excel and Google Sheets. What makes this one of my favorite spreadsheets isn’t just the fact that it helps me calculate stresses and strains – which is a major plus – but also because it comes with several different types of joint calculations. For example, if you want to know how much torque will be transmitted through a bolted joint given certain parameters (e.g., bolt diameter, length), this spreadsheet will tell you exactly how much tension or compression stress each bolt will experience during use! Another cool thing about this tool is that it can help evaluate beam stiffness during static loading conditions when combined with information about material thicknesses & modulus of elasticity values for each component used in the design process (see below).
This great spreadsheet helps me calculate stresses and strains in a variety of materials.
This great spreadsheet helps me calculate stresses and strains in a variety of materials. It is useful for mechanical engineering, and can be used to calculate stresses and strains in a variety of materials.
It has built-in formulas for calculating shear, moment, and bending moments, as well as the stiffness of beams.
The spreadsheet has built-in formulas for calculating shear, moment and bending moments, as well as the stiffness of beams. It also contains a table of maximum allowable stresses for various materials (concrete, steel).
You can use this spreadsheet to calculate:
- The maximum allowable stress in a material given its cross-sectional area and thickness
- The maximum allowable stress in a section given its thickness and length