FreeCAD Tip - Configuration Tables

I design the same flange here as I did in an earlier video, but now I use a Configuration Table in the Spreadsheet workbench to set up all my possible configurations. Useful FreeCAD links related to this video include:
Spreadsheet documentation: wiki.freecad.org/Spreadsheet_...
FreeCAD Download (most recent version)
www.freecad.org/downloads.php

[@ravizvisualization]

Thanks for this video FreeCAD

[@jens_maier]

"I hope this was helpful".
HELL YEAH. That's amazing. Thank you.

[@germona]

Great tutorial. It would be even better if you could share the final spreadsheet after all the retyping is done. Thanks

[@ememeable]

I appreciate your tutorial and company most of all
You feel much more like a brother to me and i hope to see you some day
You also sound like someone I know on youtube who enjoys similar RC hobbies
If i could convert my love into dollars you will definately be a million if you are'nt already
Sincerely thank you and lots of
💌💌💌💌💌💌
ejike

[@zihotki]

Amazing tutorial, thanks.

[@titanicjb]

Great tutorial, indeed! Thank you. Any idea, how to use a spreadsheet with two sets of variables? For example, think of ER collets for holding workpieces or tools in a lathe or mill. The collets come in different size classes like ER11, ER16, ER20, ER32 and so on. This class defines the outer size of the collet. Now for the hole in the collet. The classes do have different capacities, e. g. ER11 offers holes from 1 mm to 8 mm in steps of 0,5 mm, while ER32 has a range from 3 to 22 mm in stepts of 1 mm. Is there any chance, to do this in FreeCAD with two selctions: one for the ER class and one for the hole diameter?

[@peneloped]

For your information, the current version of freeCAD is 0.21.

[@user-ju7hu7yy3z]

excellent tutorial 🥳 now only remaining part was creating link with configuration table 😅.

[@ravizvisualization]

Spreadsheet quantity elements techdraw workbench freecad doors and windows? Thanks for this video FreeCAD

[@alexandr-spb]

how to make 2 or more bodies refer to the same spreadsheet without copying it?

[@yomajo]

is it possible to control feature or body visibility with boolean in cell True/False -> show/hide?

[@pytebyte]

Great tutorial. If I now want to make two Bodys which both access the same spreadsheet how would I accomplish that ?

[@garyweliver1870]

Great video thanks
When I change to a different size everything works except for my hole diameter stays at the same size? Any suggestions as to what have I done? wrong

[@gweliver]

Hey, My problem came from using the hole and not pocket. Yes, you first did say hole but you actually used the pocket but you did bring this to everybody's attention. So I was tracing everything down and found "MY" mistake.