My Favorite Engineering Calculation Spreadsheet
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).

