GoodCalculationGuide.png

We get to see lots of calculations here at the ExcelCalcs website and we have tried to distill the top ten elements of a good calculation and put them in this guide. You read about it here or you can watch it on YouTube. I hope it is useful to you all.

Training for Engineers

Our unique approach to engineering training is becoming increasingly popular for in-house training:

  • We focus on learning engineering principles by reducing complex mathematics to simple calculations and charts in Excel workbooks.
  • All calculation methods are transparent and easily readable using our XLC Excel Add-in software.
  • We offer continued access to site resources and course leader after the course has finished.

See our existing courses or ask us to develop a bespoke course for your organisation. We have just completed developing a 2 day course called "Fatigue of Welded Structures" outlined in a YouTube video. We already have some provisional dates lined up for the US. Please contact John Doyle if you are interested in the course.

Repository News

You can see many elements from the good calculation guide in the latest offerings in the Repository. The ever dependable Alex Tomanovich has produced two new calculations and updated six others. docapri is building quite a collection on the site too. From down under InfoJunkie65 adds to his impressive collection of Excel tools for engineers. azulu makes his debut calculation - we are always especially pleased to welcome new authors. sumnerdave keeps us up to speed with decked roofing design. We learned a lot about the limitations of Matricies in Excel 2003 compared to Excel 2007 and 2010 when BABACAN responded to a user comment. His ExcelFEM now works in Excel 2003. He also shares a useful tip showing the advantage of saving files as xlsb files rather than xlsxJohnDoyle tells us how to use ASME to generate stress strain curves for use in non-linear finite element analysis and how to assess cracks against fast fracture and fatigue growth. All the calculations published since the last news letter are shown below.

Uploaded Repository Folder, Calculation link, Author Details and Calculation Version History
2011 Apr. 18 This file is located in the Civil Engineering folder. UpdateIBC2006E.xls by ATomanovich. File version 1.5 view full version history.
2011 Apr. 18 This file is located in the Civil Engineering folder. UpdateASCE705S.xls by ATomanovich. File version 1.5 view full version history.
2011 Apr. 18 This file is located in the Structural Details folder. UpdateCLIPCONN.xls by ATomanovich. File version 2.2 view full version history.
2011 Apr. 18 This file is located in the Structural Details folder. UpdateRECTANGULAR SPREAD FOOTING ANALYSIS by ATomanovich. File version 3.4 view full version history.
2011 Apr. 18 This file is located in the Civil Engineering folder. New!REBARS (318M-05).xls by ATomanovich.
2011 Apr. 18 This file is located in the Civil Engineering folder. UpdateREBARS (318-05).xls by ATomanovich. File version 1.2 view full version history.
2011 Apr. 18 This file is located in the Civil Engineering folder. New!REBARS (318-08).xls by ATomanovich.
2011 Apr. 18 This file is located in the Misc. Topics folder. UpdateCONVCALC.xls by ATomanovich. File version 1.3 view full version history.
2011 Apr. 18 This file is located in the Beams folder. New!Single Angle Bending with Torsion by docapri.
2011 Apr. 18 This file is located in the Geometry folder. New!VBA Experiments with Excel Shapes Layer: Structural Framing Plans by InfoJunkie65.
2011 Apr. 06 This file is located in the Dynamics folder. New!Beam Transverse Vibration Mode Shapes - AZ.xls by azulu.
2011 Apr. 06 This file is located in the Civil Engineering folder. New!ROOFDECK.XLS by sumnerdave.
2011 Apr. 01 This file is located in the Materials folder. UpdateTrue Stress Strain Curve Generation by JohnDoyle. File version 1.1 view full version history.
2011 Mar. 29 This file is located in the Pins and Joints folder. UpdateClevis and lug design - Peterson's by JohnDoyle. File version 1.2 view full version history.
2011 Mar. 28 This file is located in the Finite Element folder. UpdateExcelFEM by BABACAN. File version 1.5 view full version history.
2011 Mar. 24 This file is located in the Fatigue folder. New!Fracture and Fatigue Calculator.xls by JohnDoyle.
2011 Mar. 24 This file is located in the Impact folder. New!Shaft Impact Calculation by JohnDoyle.