taavilooke Posted June 12, 2019 Share Posted June 12, 2019 Hi! I'm drawing an apartment building and I need to set up a separate sheet layer for each apartment's plan with the area of that apartment displayed next to it. It's quite easy to set up a worksheet that sums up the area of each apartment (using Occupant Name for example). However in the worksheet all the areas are in one table. Is it possible to look up that corresponding value from the worksheet and display that separately from the other values? Thanks, Taavi Quote Link to comment
Boh Posted June 12, 2019 Share Posted June 12, 2019 I think you might need to explain a bit more clearly what you want. Quote Link to comment
taavilooke Posted June 12, 2019 Author Share Posted June 12, 2019 Ok, let me try. Firstly, I have a worksheet like this that has all rooms summed up per apartment. Secondly, I have sheet layers with the plans of each apartment 1 through 12. What I would like to do is display the summed-up area of each apartment next to the plan. So the question is whether it's somehow possible to automatically look up the area from the worksheet and place that next onto the sheet layer as text? I mean I could always simply copy the values as text next to the plan, but it would be nice to keep that link automatic, so that when I update the plans, the area updates as well. Other way I could think of was to create a separate worksheet for each apartment and place that onto the sheet layer, but this seems like a lot of hassle to achieve something that should be easy to do. Quote Link to comment
JMR Posted June 12, 2019 Share Posted June 12, 2019 A dumb workaround is to create a viewport next to the plan, showing a suitably cropped worksheet with only the desired apartment values visible. That means though, that your spreadsheet size, location and arrangement should never change. There is probably a way to script-populate a custom record and then display this value in a symbol next to the plan, but that is beyond my skills unfortunately. Quote Link to comment
Hans-Olav Posted June 12, 2019 Share Posted June 12, 2019 @taavilooke I would use space objects to show area of apartments. We usually have three sets of spaces classed in three different classes, Net room, gross apartment and total floor area. Quote Link to comment
taavilooke Posted June 12, 2019 Author Share Posted June 12, 2019 Just now, Hans-Olav said: @taavilooke I would use space objects to show area of apartments. We usually have three sets of spaces classed in three different classes, Net room, gross apartment and total floor area. That would be nice approach. Is it possible to get the net apartment area (substracting the area of walls inside the apartment) with this approach automatically though? Drawing a space object with the perimeter walls of the apartment easily gets the gross area, but I can't find a way to substract the area of walls this way. Having to draw the space boundary manually would be a lot of hassle... Quote Link to comment
Hans-Olav Posted June 12, 2019 Share Posted June 12, 2019 @taavilooke If you use the bucket mode you can click inside walls and the space is created automatically Quote Link to comment
taavilooke Posted June 12, 2019 Author Share Posted June 12, 2019 @Hans-Olav Well yes, but this creates spaces one room at a time. To get the area of the whole apartment with one space object, this one space has to encompass the whole apartment, right? But this one element doesn't know there are walls inside the space that it has to substract to get the net area (like the walls here). Quote Link to comment
Hans-Olav Posted June 12, 2019 Share Posted June 12, 2019 Thats right, I meant when you make the room only. I guess if you have classed the walls systematically, you could theoretically turn off interior walls and click once for the apartment. We draw the apartments manually DomC has made some marionette scripts to make the process more automatic : 1 Quote Link to comment
Boh Posted June 12, 2019 Share Posted June 12, 2019 You must have existing geometry (like polygons) to get those areas to appear in your worksheet. If so you can turn them into space objects by using the "Create objects from shapes" command (right click on poly). Alternatively do this (see vid) 2019-06-13 09-32-03.mp4 Quote Link to comment
taavilooke Posted June 13, 2019 Author Share Posted June 13, 2019 DomC's script does exactly what I need. That Marionette thing might actually be useful at one point. Thanks! Quote Link to comment
elepp Posted June 13, 2019 Share Posted June 13, 2019 Alternatively you could create a single worksheet for each apartment with a modified search criteria to only get the area without the individual rooms. Downside is that you have to create a lot of worksheets though. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.