Jump to content
taavilooke

Lookup from worksheets in text objects?

Recommended Posts

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

Share this post


Link to post

I think you might need to explain a bit more clearly what you want.

Share this post


Link to post

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?

 

image.thumb.png.0034a2b2260dce2943cdb6246aebca83.png

 

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.

Share this post


Link to post

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.

 

 

Share this post


Link to post

@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. 

Share this post


Link to post
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...

Share this post


Link to post

@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).

image.thumb.png.be47bad597dab16d16423d8cba53956c.png

Share this post


Link to post

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 :

 

 

  • Like 1

Share this post


Link to post

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).

image.thumb.png.65b0a56a785d589caa392022795a698f.png

 

Alternatively do this (see vid)

Share this post


Link to post

DomC's script does exactly what I need. That Marionette thing might actually be useful at one point. Thanks!

Share this post


Link to post

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.

Bildschirmfoto 2019-06-13 um 10.05.22.png

Bildschirmfoto 2019-06-13 um 10.05.34.png

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×