Window Placement Via Spreadsheet

A forum dedicated to the Draft, Arch and BIM workbenches development.
Forum rules
Be nice to others! Respect the FreeCAD code of conduct!
Post Reply
jamb
Posts: 3
Joined: Thu Nov 17, 2022 7:21 pm

Window Placement Via Spreadsheet

Post by jamb »

Good evening,

I'm a new user attempting to model a house with approximate dimensions which will be later updated following detailed survey. I have not managed to discover a way to place windows, doors & internal walls dynamically onto the wall, referencing a spreadsheet.
Screenshot_20221117_192525.png
Screenshot_20221117_192525.png (66.69 KiB) Viewed 925 times
Does anyone know have any pointers as to how this might be accomplished?

Thanks

John
User avatar
Roy_043
Veteran
Posts: 8550
Joined: Thu Dec 27, 2018 12:28 pm

Re: Window Placement Via Spreadsheet

Post by Roy_043 »

See the attached file for an example.
Attachments
arch_spreadsheet.FCStd
(20.36 KiB) Downloaded 23 times
jamb
Posts: 3
Joined: Thu Nov 17, 2022 7:21 pm

Re: Window Placement Via Spreadsheet

Post by jamb »

Thank you Roy_043, your time & response are much appreciated - spelling out the answer to anyone else reading this.....

Rather than placing the building 'wherever' and referencing dimensions off arbitrary bits of the building (like I will need to do with a tape measure in real life :lol: ) - the way to do it is to place a corner of the building on the origin, then use the spreadsheet to offset all the details such as doors, windows and walls from the global origin.

Because the spreadsheet was originally in the plan this is relatively straightforward, please see example below - dims in black font, co-ordinates in green
Screenshot_20221118_163015.png
Screenshot_20221118_163015.png (163.61 KiB) Viewed 807 times
Now I just need to smarten up my labelling so I don't lose track of what all the dims are.... :shock:
paullee
Veteran
Posts: 5118
Joined: Wed May 04, 2016 3:58 pm

Re: Window Placement Via Spreadsheet

Post by paullee »

Want to try something experimental and return some feedback ? :)

Intuitive Automatic Windows/Doors + Equipment Placement


https://youtu.be/_d-BZJH70xk
https://youtu.be/ozZ-jl-BSjU


phpBB [video]


phpBB [video]
jamb
Posts: 3
Joined: Thu Nov 17, 2022 7:21 pm

Re: Window Placement Via Spreadsheet

Post by jamb »

Thanks for the reply paullee, I'd need to get practicing to make use of what you've written :shock: :lol:
Post Reply