I’ve just added some new functionality to BikeCAD version 19.5 described at: bikecad.ca/mitering_to_tapered_ht
Great job, and a very clear video too. I updated the original post to include the BikeCAD update.
just saw this:
what should the Theta angle represent?
Manfred @ rattleCAD
Hey Daniel,
thanks for providing the spreadsheet, that makes life so much easier as a hobby ongoing builder!
To avoid errors maybe you can add a row in the spreadsheet with something like “calculated mitering diameter”/“theoretical holesaw diameter” and with the rows “closest holesaw” and “holesaw diff” it will be easier to understand the round up/down, happening inside the spreadhseet.
Why? For my case now the result for the closest holesaw diameter is 1.75”, with a difference of -1.15mm. As I use 3D printed drums for mitering my tubes I would assume I need to simply use 1.75”-1.15mm-(sandingpaper thickness * 2) = my perfect diameter, correct?
Thanks for the feedback, I updated it to include a Theoretical Holesaw field.
The theoretical hole saw is simply W3, the measured HT diameter at the midpoint of the intersection
In the real world, you could easily get away with using W1, the smaller diameter hole saw for everything, and do some light cleanup with a file!