Mechanical handler calculations in MS Excel using the XLC add-in from ExcelCalcs.com. This calculation can be used to optimise ram sizes, lifting capacity, boom dimensions or use the same model to assess a series of model sizes.

Best Practise in making calculations with Excel

This course uses real world case studies to understand the engineering principles governing fatigue failure of welded structures. We reduce complex mathematics to simple hand calculations using Excel workbooks so that engineers at all levels can understand the concepts covered. Engineers will leave understanding how to apply the AWS rules for fatigue design and will pick up new engineering and Excel skills along the way. [More] [Less]

Static structural analysis of 3D linear elastic frames and trusses. Computes the static deflections, reactions, internal element forces using direct stiffness methods.

The user menu explained in this video. How to check your XLC subscription and get your XLC release code. Check all your downloads and check for updated calculations. Uploading documents and version control. Updating your email address, username, avatar and other details.

Ok so you have installed XLC now let’s get up and running. This video explain what to do when you start up Excel for the first time with the XLC addin loaded. Topics covered: Name and show equations; Display above and below a division line; Greek characters.

Algebraic and numeric equation displays; Equation cloning; Behaviour of EQS() functions.

Equation automatic updates; Verification of cell formula; Equation numbering.

XLC software enhances MS Excel so that cell formulae can be displayed as mathematical equations.

Ok so you have installed XLC now let’s get up and running. This video explain what to do when you start up Excel for the first time with the XLC addin loaded. Topics covered: Name and show equations; Display above and below a division line; Greek characters.

Turan Babacan's static structural analysis spreadsheet for 2D linear elastic frames and trusses. Repository Link.

Alex talks to John Doyle in March 2009 about his spreadsheets, why he chooses Excel and the approach he takes when setting out a problem.

This is best viewed in full screen model. Double click the player.

This is best viewed in full screen model. Double click the player.

This is best viewed in full screen model. Double click the player.

XLC software enhances MS Excel so that cell formulae can be displayed as mathematical equations.

I managed to track Shaiq down and I talked to him about his extensive career, his motivations for sharing his knowledge and simply to thank him.

How to make Gannt charts using the Excel REPT() function.

Learn how to size bolts so that they never come loose or break in service. How to select the correct tightening torque. Why you might consider a more accurate tightening method. Why you might choose to lubricate your bolt. How to increase the shear capacity of your joint. Remember to double click the video player. This video needs to be viewed in full screen mode. [More] [Less]

George Lungu's amazing rollercoaster animation generated using Excel scatter charts.

Mechanical handler calculations in MS Excel using the XLC add-in from ExcelCalcs.com. This calculation can be used to optimise ram sizes, lifting capacity, boom dimensions or use the same model to assess a series of model sizes.

Ok so you have installed XLC now let’s get up and running. This video explain what to do when you start up Excel for the first time with the XLC addin loaded. Topics covered: Name and show equations; Display above and below a division line; Greek characters.

This course uses real world case studies to understand the engineering principles governing fatigue failure of welded structures. We reduce complex mathematics to simple hand calculations using Excel workbooks so that engineers at all levels can understand the concepts covered. Engineers will leave understanding how to apply the AWS rules for fatigue design and will pick up new engineering and Excel skills along the way. [More] [Less]

Static structural analysis of 3D linear elastic frames and trusses. Computes the static deflections, reactions, internal element forces using direct stiffness methods.

Ok so you have installed XLC now let’s get up and running. This video explain what to do when you start up Excel for the first time with the XLC addin loaded. Topics covered: Name and show equations; Display above and below a division line; Greek characters.

If you want to know how to make excel work with tabular data in a user friendly way then this video tutorial is for you. The first part of the tutorial describes use of the Excel INDEX function for tabular lookups and the use of a combo box for selection. A second video covers the use of data validation boxes and the Excel MATCH function. [More] [Less]

Turan Babacan's static structural analysis spreadsheet for 2D linear elastic frames and trusses. Repository Link.

How to make calculations with interchangeable units simply by the use of the XLC template.

This video shows how a calculation for the solution to a generalised motion problem can be solved.

George Lungu's amazing rollercoaster animation generated using Excel scatter charts.