Unsupported Precision Round Rail Calculator

[routercnc]

I've updated the previous gantry stiffness spreadsheet with a few minor tweaks (one slight error corrected, factor 4 re-located). New version 3 below:

This will calculate the vertical deflection of various types of section, plus twisting and resultant tool deflection due to cutting forces (on routers etc.)

Instructions for use
1. Top left boxes:
Load applied to section
Cutting force in that material (see sheet for suggested values - thank you Irving2008 for these values, borrowed from stepper motor calc sheet!)
Length of beam

2. Next set of top left boxes are for the material.
Defaults are steel, but there is a lookup table off to the left for aluminium or wood (Douglas Fir). Copy over the 3 relevant values into Young's modulus, Density, and Modulus of rigidity.

3. Geometry
The shape inputs are next in rows 15 to 17. Purple boxes.

4. Results
The yellow boxes in row 25 and below show various outputs.

Enjoy !