FreeCAD: Stud Wall with Window spreadsheet

Creating a parametric spreadsheet driven stud wall with window.

The Stud Wall with window assembly.

(I create this prior to inserting spreadsheet)
1. In PartDesign WB (or your choice), create bottom & top plates and one starter stud and one end stud. Create these bodies with the same origin and transform them into position.
2. From the Draft WB: use array command to create stud array. Ok anything in the dialogue box, and fix the array from the properties panel, with 16" spacing.
3.From the BIM WB: create a window. If the dialogue box doesn't create what you want, it can be fixed from the sketch.
4. Edit the window sketch: delete constraint off the origin point, drag sketch away from origin. Create a point on the center of the bottom line of the window sketch (symmetry command). Create a vertical and horizontal dimension from the origin to the point just created, these are the window location dimensions.
5. Hide any stud that touches the window. Copy and paste four studs and four bottom plates. Transform and re-dimensions these bodies into: 2 window studs, 2 jack studs, 2 headers and 2 sill plates. Create one top and bottom cripple. Always create bodies from the same assembly origin and transform into position. This is the rough window opening, it will all be located relative to the window location point.

We now have 2 datum points in this assembly. The assembly origin and the window location point. Everything in the assembly is located relative to one or both of these two points.

The Spreadsheet

1. From the Spreadsheet WB: create a new spreadsheet.
2. Name of all the bodies and dimensions that need to be controlled.
Wall LxH, Window LxH, Window location, stud length, stud spacing, sill width, header width, jack stud length, bottom & top cripple lengths, etc..
3. Of all the features controlled by the spreadsheet, only 6 are meant to be given entries/variables: Wall LxW, Window LxW and Window WxH.
4. Create and enter in all the equations to locate bodies: Wall H= stud length +3", sill W= window width + .25", etc...
5. Add all aliases to cells, keep names short, wall length: wl, window width: winw, window location vertical: winlv, etc...
6. Move through the assembly replacing dimensions with spreadsheet aliases (or equations) via the properties panel, click silver button. type sp in the dialogue box, hit down arrow, hit enter, type appropriate alias, hit enter, it will turn blue when link is created.

IMPORTANT: FreeCAD spreadsheet uses Python functions, NOT Excel. But some functions are the same.

Python function for rounding up is: ceil()

7. When creating number of studs and number of cripples. This number can NOT be a fraction or decimal. This is the trick of this assembly.
x number of studs = wall length / 16"
rounding up to make whole integer = ceil(x)
8. Creating the cripple arrays: The cripple spacing is different top and bottom because the header is 3" wider than the sill, so two arrays are required, but only one value changes in these two equations.

I know I blasted through this quickly, and skipped a lot and no dialogue. But this for intermediate to advanced people.

Cripple spacing: puzzled solved! (mathcodeprint ;-) )

If you got anything out of it, hit the thumbs up.

Cheers.