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.
-
38:20
Degenerate Plays
15 hours agoDoctor, Doctor, Give Me The News - Assassin's Creed : Part 12
125 -
24:37
GameLeap RAID Shadow Legends
16 hours ago15 BEST EPICS You MUST MAX in 2024 (Every Faction) - Raid Shadow Legends Tier List
311 -
48:25
Cut Jib Newsletter Speaks: The Podcast!
3 days ago $0.06 earnedCut Jib Newsletter Speaks, the Podcast. Our Speech is violence, their violence is speech Edition!
38 -
15:50
RealitySurvival
10 hours agoKeystone Meats - Next Level Long Term Food Storage!
3251 -
2:48:50
vivafrei
21 hours agoEp. 229: P Diddy DENIED BAIL! Pool SUES Kamala Harris! Jamie Raskin "DISQUALIFYING" Trump & MORE!
158K468 -
1:59:11
Nerdrotic
13 hours agoAncient Apocalypse Returns - Atlantis Puzzle Review | Forbidden Frontier #075
163K26 -
LIVE
Vigilant News Network
20 hours agoVaccine Horror Shocks the World: Exclusive Update - Media Blackout
2,225 watching -
1:25:19
Josh Pate's College Football Show
11 hours agoTennessee Silences OU | Michigan Beats USC | Hugh Freeze Problem | Early UGA-Alabama Thoughts
73.7K4 -
6:34:23
Barstool Gambling
18 hours agoDave Portnoy, Big Cat, and Co Sweat Out the Sunday Slate | Barstool Gambling Cave
80.5K9 -
25:34
Stephen Gardner
15 hours ago🔥Trump MUST BE KEPT ALIVE at all costs! | Exclusive RFK JR Interview!!
151K276