John Whyte Posted July 9, 2017 Share Posted July 9, 2017 (edited) 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) Im running VWX 2014 Architect. Although i do have a license for 2017 also, just havnt upgraded yet. Edited July 9, 2017 by John Whyte Quote Link to comment
Pat Stanford Posted July 9, 2017 Share Posted July 9, 2017 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. Quote Link to comment
John Whyte Posted July 9, 2017 Author Share Posted July 9, 2017 Thanks @pat stanford I gave that a try but i wasnt able to insert the formula, i created a test file, would you mind having a look, it seems i cant input the anything into column C. Here is a link to the test file : https://www.dropbox.com/s/jd0vwvhbaur26yr/report example v2014.vwx?dl=0 Quote Link to comment
Pat Stanford Posted July 9, 2017 Share Posted July 9, 2017 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 Quote Link to comment
John Whyte Posted July 9, 2017 Author Share Posted July 9, 2017 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 ? Quote Link to comment
Pat Stanford Posted July 9, 2017 Share Posted July 9, 2017 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. Quote Link to comment
Marc Davies Posted October 9, 2018 Share Posted October 9, 2018 (edited) Struggling to get the Spaces version to work. Edited October 9, 2018 by DaviesTheChair Quote Link to comment
Pat Stanford Posted October 9, 2018 Share Posted October 9, 2018 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. Quote Link to comment
Marc Davies Posted October 11, 2018 Share Posted October 11, 2018 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. Quote Link to comment
Pat Stanford Posted October 15, 2018 Share Posted October 15, 2018 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. Quote Link to comment
Marc Davies Posted November 28, 2018 Share Posted November 28, 2018 Update: I have discovered that in 2019 Service Pack 2, the Space object number (which automatically populates the "Name" field at the bottom of the OIP) now shows when selecting Locations in worksheet database criteria. Still not very user friendly, compared to using the "Space Name" but at least it is accessible now. Thanks for your previous input. 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.