RWSD Posted November 12, 2009 Share Posted November 12, 2009 Hello I'm using Designer 12.5 on a Mac. I'm trying to use a worksheet to count the 3d metric capscrews on a layer. They also have their own class. I've set up the worksheet to list objects with a record, then chosen "capscrew, metric" [although I haven't given them a record]. I chose fields "Screw type", "Size", "Length", "Socket type", and "Head style". I then set up criteria for the layer and class. The worksheet certainly counts something up, I now have rows 2.1 - 2.531, but there is no data, only a column of zeros under "Length". How do I get useful information into this worksheet? Thanks Ronnie Quote Link to comment
AndiACD Posted November 12, 2009 Share Posted November 12, 2009 You may find posting this under one of the more generic listing will get more input on this "Q". Sorry i can't be of more help. Quote Link to comment
michaelk Posted November 12, 2009 Share Posted November 12, 2009 If all you are trying to do is count objects you don't need a database. In a worksheet cell type = then click the little triangle on the upper left side and choose "paste function", select COUNT. Click the little triangle again and choose "paste criteria". Set up the criteria for what you are trying to count. For example, this will count all the metric screw and nut objects in the None class: =COUNT(((INOBJECT & (PON='Screw and Nut (Metric)') & (C='None')))) If you do need to create a database, I highly recommend getting Pat Stanford's vectorscript that will return a worksheet listing all possible records and fields of a selected object. It's available in the vectorscript sharing section of this forum. It saves a lot of time, frustration and tears when creating worksheets. hth michaelk Quote Link to comment
RWSD Posted November 12, 2009 Author Share Posted November 12, 2009 Thanks for the suggestions. Unfortunately I still can't get it to work, nor Pat's vectorscript. Going home..... Quote Link to comment
michaelk Posted November 12, 2009 Share Posted November 12, 2009 Can you post a file with 5 of the objects you want to count? michaelk Quote Link to comment
RWSD Posted November 13, 2009 Author Share Posted November 13, 2009 Hello Michael thanks for the offer of help. I'm trying to list the screws by type, length etc so I can order them. I've hopefully attached a file as requested. Ronnie Quote Link to comment
mike m oz Posted November 13, 2009 Share Posted November 13, 2009 Try this - I think I have it correct. Quote Link to comment
RWSD Posted November 13, 2009 Author Share Posted November 13, 2009 Mike Yes, that's it, thanks! OK, so how do you do it? I want it to count fasteners on the 3d model layer and/or by class, and those incorporated in symbols on that layer. If I use "paste criteria" to set layer and class criteria in your worksheet with the database rows highlighted, it seems to count the fasteners while in the dialog, but it doesn't change the worksheet. Ronnie Quote Link to comment
mike m oz Posted November 13, 2009 Share Posted November 13, 2009 To get the spreadsheet to update in Vw 12.5 you need to open it and then choose Recalculate from the pop-up menu. In later versions of Vw you can right click on the spreadsheet on the drawing and choose Recalculate from the contextual menu. To set criteria you need to have the Database row visible. Select the Database row and right click. Choose Set Criteria. This will allow you to filter what fasteners you want to report on. Your not Robinson Crusoe in struggling with Vectorworks' Report capabilities. The process is not very intuitive and the documentation could be more user friendly. Quote Link to comment
RWSD Posted November 13, 2009 Author Share Posted November 13, 2009 I've been using Vectorworks since Minicad, and every time I try to use worksheets, my eyes glaze over..... When I open your worksheet in my file, it goes from Row 1, the titles, straight to Row 2.1. As there is no Row 2 [with the little diamond], I can't set criteria for the database rows, the only option I get is "Select Item". If I use the drop-down menu and "paste criteria" I still can't get it to recalculate the worksheet. Ronnie Quote Link to comment
mike m oz Posted November 13, 2009 Share Posted November 13, 2009 (edited) You need to put a checkmark against the Database Headers option to make the Database Header rows visible. You can then set or edit the 'filtering' criteria for that row. (Note: if you select the Database Header cell for each of the columns you can see the formulae that provides that column's information - make sure you don't change any of this information.) Once you have finished editing the criteria hide the Database Header row again by unchecking the Database Headers option. Edited November 13, 2009 by mike m oz Quote Link to comment
michaelk Posted November 13, 2009 Share Posted November 13, 2009 Nicely done, Mike! To see the database header row (Row 2), click the little triangle and choose "Database Headers" You only need "paste criteria" (and paste function) when you are building the worksheet. "recalculate" is all you need to update the worksheet. hth michaelk Quote Link to comment
mike m oz Posted November 13, 2009 Share Posted November 13, 2009 There is some very good information on spreadsheets and reports by Jeffrey Ouellette and others in this thread: http://techboard.vectorworks.net/ubbthreads/ubbthreads.php?ubb=showflat&Number=114417&page=1 Quote Link to comment
RWSD Posted November 13, 2009 Author Share Posted November 13, 2009 Gotcha! Nicely done indeed! If there's a list anywhere in the manuals of functions [eg your =('Screw and Nut (ISO)-3D'.size)], I've never been able to find them, or have you guys worked it out by trial and error? Many thanks guys, and hopefully this will help others too. I'll be visiting here regularly. Ronnie Quote Link to comment
GWS Posted November 13, 2009 Share Posted November 13, 2009 Worksheets are a very useful tool but there is a real need for some clear help notes, not only about function but the language required to facilitate them. I too struggle too get my head around them. They seem very 'clunky' compared to other workflows in VW. Quote Link to comment
mike m oz Posted November 14, 2009 Share Posted November 14, 2009 (edited) Ronza129 the Paste Function option opens up a dialog box which lists the available functions. You can find documentation on these in the Vectorscript Function Reference - you access this through the program Help menu. Note - one thing I omitted to mention was the use of the Sum and Order icons. When you have the Database row selected you can insert these into the column headers. You need to use these to get a useful result. If you experiment with them you can see what they do. Edited November 14, 2009 by mike m oz Quote Link to comment
Oyvind Posted November 16, 2009 Share Posted November 16, 2009 OK. But where do I find the available variables like size and screwIndex? Quote Link to comment
mike m oz Posted November 16, 2009 Share Posted November 16, 2009 You can only select from within the listed parameter's for the object's Record. Quote Link to comment
Oyvind Posted November 16, 2009 Share Posted November 16, 2009 OK, I see; Create Report. I am not used to the report manager, so I was looking for the parameters in the worksheet (paste function). Thanks! 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.