Jump to content

Worksheet to count lighting devices by type on each position.

Recommended Posts



Apologies if this has been covered, I've looked through several worksheet posts and can't seem to find a solution. 


I'm trying to create a worksheet that lists the lighting positions in rows, and the instrument type across the columns. 




I can populate the headers / position names manually if necessary, but working out how to do the counts I'm getting stuck on! Any help greatly appreciated! 


Many thanks, 


Link to comment
  • Vectorworks, Inc Employee

You won't be able to get the worksheet to populate in this format.

The only way to do this is to specifiy a single worksheet by position, making the criteria. (Position contains LX 1 for example). and then line up all of the individual sheets on the page to make one sheet.

Then you can have counts  (Func = CT).

Basically counts and rows can only go do the page not down the page and across at the same time.

There is a feature request for this but this is not something the current worksheets can do.


Link to comment

@TomWhiteLight Can you clarify please?  A Worksheet Database certainly can't do what is being asked for but I think you can accomplish it with Spreadsheet cell formulas.


Since the Lighting Device record contains both the Instrument Type and the Postion, you can use a complex criteria with the Count function to get the data directly from the Lights.


In my test file I listed the Position Names in Column A and the Instrument Types in Row C.  By using a $ in the cell reference in the formula you can force it to use an absolute Row or Column reference so when you copy and paste the formula it will still work. The formula I came up with is:


=COUNT(('Lighting Device'.'Position'=$A7) & ('Lighting Device'.'Inst Type'=B$6))


But I know almost nothing about lights and positions, so I could have this completely wrong.

  • Like 2
Link to comment

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.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...