An example of some techniques using spreadsheet data and spreadsheet functions and expressions.
This file demonstrates one approach to making a parametric knob with captured nut and knurled circumference, typically for 3D printing.
Initially, I set out to make an example for someone who had done a similar thing with multiple datum planes and claimed he couldn't get it to work with attachment offsets on the sketches.
So, things exemplified:
- Use of expressions of the form "condition? resultTrue : resultFalse" in the spreadsheet to get conditional values
- Use of expressions of the form "condition? resultTrue : resultFalse" to limit recomputes when the knurl count gets large
Thus the basic dimensions can be changed without waiting for long recomputes, then the control cell can be changed to produce the final knob.
- Use of miscellaneous built-in spreadsheet functions (floor(), round(), pi, tan())
Spreadsheet cells involved: Knurl count, Circumference, Chord Length, Knurl count calc, Knurl count adj
- Green cells are to be set by user, red cells are calculated (i.e. not to be changed by user)
https://github.com/macdroid53/MyShares/ ... anup.FCStd