Anders Blomberg Posted November 16, 2021 Share Posted November 16, 2021 (edited) Is it possible to divide quantity take offs between different properties in worksheets in some way? I have 7 different properties and it'd be super sweet if I could get a worksheet with quantities per area. Currently all I have is a worksheet with all combined quantities for all areas. The only solution I've figured out so far would be to create separate layers for all properties, but I was hoping there might be an easier way of doing it? The objects are mainly landscape areas (consisting of materials), walls (for curbs and retaining walls) and plants. No buildings for me. Edited November 16, 2021 by Anders Blomberg Quote Link to comment
Tom W. Posted November 16, 2021 Share Posted November 16, 2021 I'd say placing them on different layers would be a good way to go + not difficult. Plus perhaps it would be advantageous for presentation purposes to be able isolate each area in the event you wanted to deal with them separately in your sheets? Quote Link to comment
Anders Blomberg Posted November 16, 2021 Author Share Posted November 16, 2021 I'll have a go at dividing up the layers. So I ran into another problem. The worksheet returns an empty layer for every landscape area. It also won't "sum items" and won't return the name of the landscape area correctly. Any ideas of what I'm doing wrong here? Quote Link to comment
Pat Stanford Posted November 16, 2021 Share Posted November 16, 2021 You have to have some what to separate the properties. The three easiest would be by Layer, by Class, or by Record. Of the three, By Record would require the least changes to the drawing. By Layer or By Class might be better if you could specify them earlier in the design process. Create a Custom Record Format with a field "Property_Identifier" (name it what you want. I recommend no spaces in the name". Select all the objects for one property and Attach the record format to those objects and set the Property_Identifier field. Repeat for the other properties. You can now add a database criteria of Record.Property_Identifier is 'Property one" (or whatever you used) to limit the database to just that property. Or if you only have a few different properties, create separate Record Formats for each property. That way you don't have to set a field and then check the field you can just use Record is Present in the database criteria. The problem with this is that you will have to remember to go back and attach the record when new objects are added. It will not be automatic. HTH 2 Quote Link to comment
JMR Posted November 16, 2021 Share Posted November 16, 2021 Not sure if it's applicable in this situation, but at least for "ordinary" drawing objects, you could give a name to the property polyline (or draw a separate closed helper polyline) at the bottom of the OIP and then use that as a criteria for each worksheet (LOC or location function if I recall correctly). I've used this method to separate different building phases, bids etc. An extrusion (=an object with a volume) might also work, using the same principle, if you have stuff at multiple elevations. Or a space object that has height. 2 Quote Link to comment
Anders Blomberg Posted November 16, 2021 Author Share Posted November 16, 2021 (edited) 1 hour ago, JMR said: Not sure if it's applicable in this situation, but at least for "ordinary" drawing objects, you could give a name to the property polyline (or draw a separate closed helper polyline) at the bottom of the OIP and then use that as a criteria for each worksheet (LOC or location function if I recall correctly). I've used this method to separate different building phases, bids etc. An extrusion (=an object with a volume) might also work, using the same principle, if you have stuff at multiple elevations. Or a space object that has height. Wow, very Cool! Seems to work the way I was hoping for! Sometimes VW really delivers! EDIT: I had it set up all wrong but figured it out so now I got it exactly like I wanted. HUGE thanks @JMR! Edited November 16, 2021 by Anders Blomberg Quote Link to comment
JMR Posted November 17, 2021 Share Posted November 17, 2021 You're most welcome Anders (och hälsningar från Åbo (greetings from Turku))! 1 Quote Link to comment
Anders Blomberg Posted November 19, 2021 Author Share Posted November 19, 2021 @JMR@Pat Stanford So this worked like a charm for plants and landscape areas, but when setting the criteria to walls I weirdly only got the few rounded walls I have in the model. When removing the location criteria the worksheet picked up all walls properly. Any idea as to why this strange behaviour is happening? Quote Link to comment
Pat Stanford Posted November 20, 2021 Share Posted November 20, 2021 Are the wall objects completely within the area? If not, then it probably has to do with where VW thinks they are. I suggest you make a test file with a named polygon for a a LOC and a wall. Move the wall around and recalc the worksheet to see when VW thinks it is in the LOC. Try both the Start and End of the wall being the only part in the Loc. Also try putting only part of the thickness of the wall inside the LOC. I would try both the left and right edges of the wall and see if they react differently. 1 Quote Link to comment
JMR Posted November 20, 2021 Share Posted November 20, 2021 This could also be an issue with the 3D nature of the walls...that is, if the named polyline sits at a certain Z and the bottom(?) of the wall doesn't, the LOC function might not find it. I have ran into this with some doors and symbols not exactly at the DL elevation. Also try extruding the property polyline so that you can be sure everything sits within it, or use a space object that has height. It's worth trying at least. As to why only the rounded walls, that indeed is a bit weird. Do they have the same elevations/heights that the non-picked up walls have? Quote Link to comment
Anders Blomberg Posted November 20, 2021 Author Share Posted November 20, 2021 @JMR I did try to create a volume as a bounding box for the property, I also made an offset to start the volume at Z=-1 to make sure the walls are completely within the volume without touching the boundaries. This still yielded the same result with only the rounded wall. Quote Link to comment
Anders Blomberg Posted November 20, 2021 Author Share Posted November 20, 2021 @Pat Stanford Thanks for the suggestion. I made a trial file, attached here, and I'm still seeing some strange behaviour, although inconsistent with the issues in my project file. In the trial file I can actually filter out round walls on or outside the location boundary, no matter if it's an area or a volume boundary. In this file though, all straight walls still appears in the worksheet, no matter if they're located within or outside the boundary. Strangely this is the opposite behaviour from my project file where I don't get any straight walls at all in the worksheet. Boundary trial.vwx Quote Link to comment
JMR Posted November 21, 2021 Share Posted November 21, 2021 I can get the area boundary to work with VW 2021. A bug in 2022? For some reason, 2022 doesn't recognize the boundary properly? Also, it regards straight and round walls as same type of objects. A screenshot from 2021: A screenshot from 2022, as you can see, wall locations are not recognized: I adjusted the worksheets so that the object type criteria was removed in order to see everything that is inside a boundary. Also added the objecttypename. Enclosed are the files as well. As to the LOC search criteria being able to recognize the Z value, I think I was wrong as Pat explains the LOC here in detail: Boundary trial test 2022 v2021.vwx Boundary trial test 2022.vwx Quote Link to comment
JMR Posted November 21, 2021 Share Posted November 21, 2021 It's the creeping dementia I guess...GETSPACENAMEFOROBJ is the one that recognizes the z value, but that can't be used as search criteria, I think. I can be listed in the worksheet though and works also in 2022. Quote Link to comment
Anders Blomberg Posted November 22, 2021 Author Share Posted November 22, 2021 On 11/21/2021 at 5:57 PM, JMR said: Also, it regards straight and round walls as same type of objects. So this is a new feature for 2022 I believe. Which makes it really weird that the straight and round walls behave differently with the location filter. I guess they're still separate types under the hood somehow. On 11/21/2021 at 5:57 PM, JMR said: A bug in 2022? Anyone at VW read this? Can we look forward to a solution? 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.