wellebracht

This is a Vectorworks Worksheet that I am trying to duplicate, but the list data I am grabbing from an outside Excel Sheet. I have made a worksheet that counts certain symbols inside Rooms that I'm using as a key, that I want to duplicate/rename from provided list and place on corresponding Sheet Layer. Excel Reference.xlsx Excel Reference Marionette.vwx

Hello! So, I'm trying to create a Marionette system to grab data from an Excel from a particular row, grab that data into a list, and use that list to create/duplicate/rename Sheet layers, design layers, and worksheets. I have the design layer and sheet layer side if it working properly, but I'm a little stuck on the worksheet part. There are some nodes I have found to select symbols, or duplicate objects, but none of them seem to grab a worksheet handle (i know a worksheet is not a symbol, but i tried anyway). Anyone have an idea on how I can accomplish the remainder of this task?

So, I'm not sure if I just am filling out the formula incorrectly, or if I'm running into a bug. I cannot seem to get the =GetSpaceNameforOBJ function to work within a report. I can filter a report with that criteria, and it works just fine, but I cannot seem to get that same data to appear within the spreadsheet itself. Am I just using the wrong context within the spreadsheet?

Is there a way for me to add a filter to a worksheet or equipment summary key that will only count the symbols that exist within a Space Object? I have about 34 separate rooms with a slightly different layout in each room, and would like to have a worksheet or equipment summary key filter out all the gear I have within each room independently.