suppose I'd like to create ER collets in FreeCAD. As you might know, there are several classes of ER collets:
- ER-11,
- ER-16,
- ER-20,
- ER-25,
- ER-32,
- ER-40 and
- ER-50.
I'd love to avoid a single selection list, i.e. something like
- ER11-...,
- ER11-7,0,
- ER11-7,5,
- ER11-8,0,
- ER16-1,0,
- ER16-1,5,
- ...
Therefore, I'd need to two property selectors for my parts: one to choose the ER class (ER-11 to ER-50) and, depending on the class, a second list of bore diameters, which is specific for that class.
What is the best way to achieve this multiple parametric behaviour?
My first idea was to spread the data onto multiple spreadsheets. The first spreadsheet will be used to select the desired ER class. This spreadsheet could very well be used to define (more or less) the (outer) geometry of the collets. Next I'd say, I'll define a spreadsheet for each ER class, which contains the list of bore diameters to be chosen in that specific ER collet class. This list could also contain geometric parameters, which might depend on the diameter of the bore. In my eyes, this would have the benefit, that the data is neatly organized and cleanly structured. Chances to mix up different data are very low, as the data of one class is well separated from other class data.
Another idea might be, to use put in the data of the different spreadsheets into on (bigger) spreadsheet, spread across multiple blocks.
So, what would be the best way to tackle this problem?
Thanks in advance
Jan