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.
-
LIVE
The Podcast of the Lotus Eaters
4 hours agoThe Podcast of the Lotus Eaters #913
4,619 watching -
6:37
Chris Jericho
19 hours agoThe Unsolved Mystery & Murder of Rachel Morin
733 -
20:17
PARAGRAPHIC
1 day agoLeading the Way in Costa Rica's Culinary Scene | PARAGRAPHIC
437 -
9:00
Bearing
23 hours agoMeet the Woman Trying Censor the WORLD! Australia's E-Safety Commissioner Mad with Power
1.41K17 -
9:10
DepressedGinger
12 hours ago7 MLB teams that are STRUGGLING with Attendance in 2024
7554 -
3:32:48
Due Dissidence
18 hours agoMorning Joe and Hillary SMEAR Students, DNC Fears CONVENTION CHAOS, Carville MELTS DOWN Again
28.6K143 -
1:22:39
The Late Kick with Josh Pate
16 hours agoLate Kick Live Ep 512: Portal Winners & Losers | SEC Truths + Questions | Portal Winners & Losers
43.4K5 -
1:50:27
vivafrei
22 hours agoEp. 210: Stormy Gags on Lies! Hunter Not Immune! AstraZeneca Pulled & MORE! Viva & Barnes
167K268 -
1:50:54
Jewels Jones Live
2 days agoUNDERSTANDING NEXTGEN MARXISM | A Political Rendezvous - Ep. 76
88.5K70 -
8:22:56
Akademiks
1 day agoAll Will Be Revealed! Drake vs Kendrick vs The Riddler. Who Lied, Who Snaked, Mole Finally Revealed!
191K121