Jump to content
John Whyte

Symbol count report, segmented by room / area ?

Recommended Posts

We produce our lighting drawings using custom symbols for light fittings. We then run a Symbol count report inside of VWX to get the QTYs of light fittings. 

 

This currently works fine but give us a total number of fittings across the whole project. What we'd like to be able to do is run the report but further segment it, by room / area. 

 

Is there a way to be able to define rooms / areas and run this report so it would output something like the below report mockup (see attached screenshot below)

 

596243576ba1c_ScreenShot2017-07-09at15_52_04.png.cbb39e6be3522aab4e58a3723434112f.png

 

Im running VWX 2014 Architect. Although i do have a license for 2017 also, just havnt upgraded yet.

 

 

Edited by John Whyte

Share this post


Link to post

I tested this in VW2017. You will have to see if you can make it work in 2014. I am pretty sure it will work with polys, not so sure it will work with Spaces in 2014.

 

Create a Worksheet Database with criteria that will include all of the light symbols. Set a column to be the Symbol Name and drag a SUM tile to the column header so you will get some line for each symbol.

 

If you already have polygons or spaces in the drawing that match with the rooms/areas you can use those, if not, draw polygons to represent the rooms and give them names in the OIP (Data tab top in 2014, every tab bottom in 2017)

 

Enter a formula of =Sum((LOC='MyAreaName)).  The double parens is important. Replace MyAreaName with the names from the OIP. If you are using spaces copy and paste the Space Name rather than replacing it with your own if you want the Space to work properly. Repeat this for each area.

 

This should give you what you are looking for.

 

Write back if you need more help.

Share this post


Link to post

OK, I opened your file in VW2017, setup the worksheet then exported to VW2014.

 

It appears to work here. If it does note work for you, let me know and I can send you the 2017 file and you can install and play there and see if you can work out how to make it work in 2014.

 

 

report example v2014 v2017 v2014.vwx

Share this post


Link to post

That works great in 2014, thanks 

 

It seems my issue was with being to insert a new column. 

 

I could insert a column, but it would always insert left rather than insert to the right. When they where inserted left it did not let me edit the cells, but i can see when they where inserted to the right it did. 

 

How do you insert a column to the right of an existing column ? 

Share this post


Link to post

Scroll so you can see the bottom right corner of the worksheet. Hover over the corner and the cursor will change to kind of a couple of lines with a square at the corner. Click and drag to add new columns at the right or rows at the bottom.

 

Or add columns to the left and then copy/past the formula back to where you want it to be.

Share this post


Link to post

Can you post a simple file with a couple of spaces and a few different symbols in each space. I will see if I can make it work so you can see exactly what is required in your file.

Share this post


Link to post

Hi Pat, thanks for the reply. I have been working on the Report Example file you provided above, but added a Space object to test it. I copied and pasted the object name of the Space Object (from the bottom of OIP) but it doesn't seem to work with or without the curly braces.

 Also tried Sum((Loc(SpaceName ='MySpaceName'))) and variations thereof but no deal. Of all the pop up options for calculating, SpaceName seems not to be available for the cells.

 

I can get it to work vertically down the rows, but not horizontally across the columns.

Share this post


Link to post

Loc does not take a criteria, but rather the name of an object. I think it has to be the name that shows at the bottom of the OIP. I don't know if the SpaceName will work or not.

 

Loc('OIP_Name_of_My_Space')  should get you what you are looking for.

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.

×