Kopitebushie Posted January 28, 2011 Share Posted January 28, 2011 I am currently trying to set up a furniture library in Vecotworks. I've manage to attached records to each of my furniture symbols with the relevant information attached to that record (size, cost, manufacturer etc.) I've also managed to schedule this information into a table. What I want to do now is use this table to added up where symbols are being duplicated and display this in one line, rather than list the symbol x amount of times. e.g. If I had a floor plan with the same 5x WC symbol, that the schedule would recognize that 5x of the same symbol are in the drawing a show the quantity of the symbol and NOT list the symbol 5 times in the table. Can someone please help? Quote Link to comment
Guest Wes Gardner Posted January 28, 2011 Share Posted January 28, 2011 Is the "SUM" feature what you're looking for? To use, drop the sum icon onto the DATABASE HEADER row... Quote Link to comment
Kopitebushie Posted January 31, 2011 Author Share Posted January 31, 2011 Thank you for your response. However, I am looking to add a column in the worksheet that will quantify how many of the same symbol (by symbol name) are on the drawing. This will allow me to do a take-off of all the furniture. Can someone please help? Quote Link to comment
Pat Stanford Posted January 31, 2011 Share Posted January 31, 2011 I think the formula you are looking for is =count Quote Link to comment
Kopitebushie Posted January 31, 2011 Author Share Posted January 31, 2011 Thank you Pat. I know I am being a bit dumb by asking this but I ma completely new to worksheets and formulas. Where do put the formula in the worksheet? Apologies for the stupid question Quote Link to comment
Kopitebushie Posted January 31, 2011 Author Share Posted January 31, 2011 Pat - no need to reply to my last thread. I've just worked it out. You're a genius! Thank you. You don't know how much you've help!!! Quote Link to comment
michaelk Posted January 31, 2011 Share Posted January 31, 2011 If you are building a worksheet (and not a database) then you can enter the formula into any cell. The easy way is to use the dropdown Select the symbol for the furniture piece. Click into a cell in a worksheet Type "=" (equals sign) Little arrow in upper left hand corner of work sheet > Paste Function... > Count Little arrow > Paste Criteria > Symbol Name If you look in the function bar you can see the actual syntax that VW uses: =COUNT((S='SymbolName')) [= count of all symbols with the name 'symbol name'] Once you figure that out, it's sometimes easier to just edit the criteria there. hth michael Quote Link to comment
Jonathan Pickup Posted January 31, 2011 Share Posted January 31, 2011 The Essential Tutorial Manual (http://www.nemetschek.net/training/guides.php) has a whole chapter on worksheets. I think worksheets are a very important part of Vectorworks, so many years ago I added an introduction to worksheets. worksheets are so powerful everyone should learn about them. 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.