djobbins Posted August 25, 2017 Share Posted August 25, 2017 Hey, Is there a tool or function I can use to calculate how many instances of a given symbol I have in a drawing? or even better in a given area. Basically the same idea as the instrument key in Spotlight, but to work with all types of symbols (speakers, truss symbols, etc). Thanks Quote Link to comment
Andy Broomell Posted August 26, 2017 Share Posted August 26, 2017 Start with Tools<Reports<Create Report. List all: Symbols. Click "Add All >>" button Check the summarize button. Click OK. This will at least get you started, though further work with record formats and/or other criteria would be necessary to break down the worksheet further. Have you worked with worksheets before? Quote Link to comment
djobbins Posted August 29, 2017 Author Share Posted August 29, 2017 Nope, I've never really dug into worksheets outside of creating channel hookups etc from lighting reports, but those are all pretty automated. Is it possible to have them update in real time as I make changes? Quote Link to comment
markdd Posted August 29, 2017 Share Posted August 29, 2017 If the symbols you want to count have Light Info records attached, then you can use the Instrument Key tool and set up some criteria with the Filter button. With that, you can choose which Position, Layer/s, Classes they need to be on or you can create the criteria yourself with the fourth tab which basically offers you the choices that creating a worksheet would do. Its really useful and a reliable way of sorting fixtures. I often have several instrument summaries on the go with different criteria set up. Quote Link to comment
Pat Stanford Posted August 29, 2017 Share Posted August 29, 2017 1 hour ago, djobbins said: Is it possible to have them update in real time as I make changes? Unfortunately, to see updated information in worksheets you have to manually Recalculate them. No automatic recalc. Quote Link to comment
djobbins Posted February 20, 2018 Author Share Posted February 20, 2018 Hey, Going back to this. i had it working great right after I posted this question, but in VW2018 it doesn't seem to work the same way. Is there something I'm missing? Thanks! Quote Link to comment
Joe Golden The Other One Posted March 30, 2018 Share Posted March 30, 2018 Reports changed a bit in 2018. Here is a report you can import. It does not search inside of PIO's. Symbol Count.vwx Quote Link to comment
Andy Broomell Posted March 31, 2018 Share Posted March 31, 2018 I actually recently wanted to create a symbol count worksheet in 2018, and it seemed to be exponentially more difficult than it was in 2017. Could someone explain the most efficient steps to take in 2018 to get the exact same result as the steps I outlined above for 2017? (Not importing a worksheet but creating one). Quote Link to comment
markdd Posted March 31, 2018 Share Posted March 31, 2018 Run the Create Report command Fill in the dialogue box like so: That should give you a list of all the symbols in the drawing with the quantities. 3 Quote Link to comment
Andy Broomell Posted March 31, 2018 Share Posted March 31, 2018 Beautiful - Thank you @markdd!! Quote Link to comment
djobbins Posted December 17, 2019 Author Share Posted December 17, 2019 Hey guys, Returning to this topic from a while back. I have my symbol counting worksheets up and running, but it can't seem to handle lighting instruments in. If I drop a light in as just a symbol it will come up fine in the worksheet, but if I drop in a lighting instrument it doesn't. It works fine if I use the inventory spreadsheet that the "create reports" tool makes, but I can't get it to work within mine. Any thoughts? Dan Quote Link to comment
Pat Stanford Posted December 17, 2019 Share Posted December 17, 2019 Lighting Instruments are PIOs, not Symbols. You should be able to edit the criteria to include both Symbols and Lighting Instruments as the type of objects to count in the Criteria Builder. Quote Link to comment
djobbins Posted December 17, 2019 Author Share Posted December 17, 2019 Hey Pat, Right now I have it set as: =('Lighting Device'.'Inst Type'), which I just copy and pasted from the SL Inventory Worksheet (where it works fine). Am I missing something else? Dan 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.