Search the Community

Hi VW-Forum, Is it possible to refer to a database field (type: pop-up) in a Spreadsheet cell within a worksheet and to be able to select (list) the pop-up entries in that Spreadsheet cell? Greetings and thanks for help Tobi

We are looking at moving more schedules to online shared resources. This collaboration with contractors, clients etc. is super helpful. Right now we have to have all of our automated schedules as stand-a-lone Vectorworks worksheets, and shared schedules like finish schedules as google. It would be great if we could export and import google sheets to directly sync and overwrite the shared files.

I would like to use the formula =SURFACEAREA('RIGHT NET'; 'min height from base=..') in a worksheet, but as a value, I want to refer to a cell from which I want to retrieve the slab thickness. Can these formulas refer to other cells, or other cells within other worksheets?

Hello, may I have some help with making a simple inventory count worksheet? I have done Spotlight -> inventory and equipment lists filtered to lighting devices clicked the generate worksheet button Set column A to summarize so that each device is not it's own row How do I modify the COUNT formula to appropriately display the count rather than just (1)? Thank you

Hi there, I have a worksheet on the cover sheet (sheet layer) of my drawing set that automatically updates based on the titleblock data of all other sheets within that same file to generate a drawing list. This works great for me. However, my project is now split over two files, one for my suite of plans and the other for my construction details. This is to enable me to have my plans use meters as units and my details use millimetres. Can the titleblock data from my construction details file be pulled into the worksheet in my plans file to create a full drawing list? If this has been discussed before please point me in the direction of previous discussion. And as always, all help is very much appreciated. James

Hi Everyone, Does anyone know how to get a Worksheet to list the Truss with only the 2D symbol nmae, rather than out _3D at the end of the name in the list? It's only the bits of truss that I have in a vertical position. Whichmakes sense I suppose. Is there a way to insert it so It doesn't append the name in the worksheet with _3D? I've attached a few images of my orksheet and the Criteria... Hopefully someone will know the answer...

Good morning. I'm very new to vwx and still finding my way around. I'm trying to create a worksheet for a plant schedule and whilst it is picking up the plants I have placed individually, it isn't counting the plants that I have specified in the landscape area settings. All the plants I'm trying to report on are on the same layer, but different classes.

Hello, I have several files that each have an equipment summary with counts in a worksheet. Is there a way I can bring all of those worksheets into a file as a referenced resource so I can add them all together? Thank you in advance, Nick

I'm back into VW after a several year hiatus--the cable tool has changed a ton from a rogue plugin to... something. Anyway, I'm simply trying to get a report of my cable runs, listing starting device, ending device, and length of run (ideally both drawn length and parts). I need this in order to generate cable labels. I'd also love a worksheet of my distributor devices with the attributes of their records, too. I'm quite sure it's simple but I'll be darned if it isn't confounding me. Does anyone have any bright tips? I'm nearly to the point of opening a spreadsheet and making such a thing manually from my cable lables, but that's so anathema to what VW is supposed to be about. Thank you. Luke

After working in Vectorworks for more than 5 years in the realm of event production and planning, I wanted to see if we could get updates/webinars for the following topics: 1. Portable toilet symbols (regular portable toilets and accessible portable toilet symbols which can be integrated into worksheet data for inventory) 2. Tent Tool - Similar to any tool where you can customize each tent by length, width, height, style, wall numbers, and ballasting options (ie: walls on 3 sides or all 4). Also, be able to incorporate tent and wall counts into a worksheet for inventory. 3. Event Fence Panel Tool - Similar to the current fence tool but for temporary fencing (ie: 6' panels, 8' panels, crush barricade, 4' panels etc.) It would be great to also be able to track each in a worksheet for inventory. 4. Webinar on how to integrate VectorWorks Landmark and Spotlight to create large outdoor festival base maps using ARCGis or similar mapping data in Vectorworks! Many event professionals create festivals/events in various nontypical event spaces such as parks, roadways etc. Since this type of base map data may not be available, it would be cool to learn how Vectorworks users can combine Landmark and Spotlight tools, to create proper outdoor base plans to build an event. Andrew

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?

Does anyone know if Text in Worksheet Cell has a limitation for the length when it shows digits? @Pat Stanford Please see attached VW file. In my project I need to read Latitude and Longitude of my stakes in two different columns formatted to show either 9 or 12 Decimal Places Digits. Then I am trying to use Concat function, but first I need to understand why the TEXT format in the last column trims and rounds my 12 digits number into 8 digit maximum?Test TEXT length in Worksheet.vwx

Can I build a housekeeping worksheet that will list plant objects and also let me know if they have a data tag connected to them? I love using Data Tags as plant object tags, and they are so much better in my workflow than plant tags. But I get so stressed when proofing a planting plan and trying to make sure I have EVERY plant object called out. And there is almost always one plant object that the contactor finds that I don't have tagged. Could be nice for landscape areas and hardscapes too.

Hello! I have a big, complicated worksheet to calculate individual beam loads for me and I'd like to represent this nicely on my drawing. Is there a way to visually and dynamically reference an individual cell from a data tag? My backup plan is to create a new worksheet for each beam because I can reference worksheets from other worksheets, but this is very cumbersome. Thoughts? Thanks ahead of time!

I'm having some drawings with quite long drawing titles. When inserting drawing list worksheet (with DB row showing title blocks records), those text lines aren't fitting into reasonable width of the cell and normal way would be to divide this text in 2 rows into 1 cell. Somehow I didn't manage to find solution for this. anyone know how to do that?

Is there a formula I can use to make the title of a worksheet appear in a data tag. I know about #N# where I can add a name in the OIP, but I want Vectorworks to pick up the worksheet title given in the RM. This one:

Hello As I usually do, I enjoy reading the Vectorworks blog because often I come across use cases that I can incorporate into my workflow, and this time was no different. I found this, which I have attached in a screenshot. However, even after attending two University webinars on Worksheets, I haven't been able to understand how to create that presentation by area and even analyze the value of each area by the amount paid for each ticket. Curiously, I made a post about something similar (How I can analyze areas and attendees at an event). However, I'm understanding that my approach might not have been quite right as I didn't receive any responses. Where can I find information on this? Or some explanation that would allow me to explore until I achieve the expected result?

Hi, I just figured out how easy it is on Revit to apply alternate colours to schedules wereas in Vectorworks it is very painful at the moment. I am currently working at very long door schedules at the moment (100 door instances) and it would be a real benefit for contractor to read these in alternate colours. Unfortunately in VW you have to draw individual rectangles and place them at the back of the worksheet, spaced accordingly but then if you edit the worsheet it is just a nightmare. In Revit you have to just tick a box in the info pallette, I would really love this feature could become available in VW, too! Thank you Federico

Can we please get the ability to freeze rows/columns, and the ability to edit more than one cell at a time? Thanks!

Hello As im not really used to working with worksheets/excel in general i now turn to the community. I am trying to make a worksheet template for hoists, to make an automatic X/Y list for sending out to riggers onsite. The idea im trying to make happen is that once imported into the current document im working on it displays the hoists i put in the drawing, sorted on +-/XY, and also if i delete a hoist it will also disappear from there Any help or pointers as to how to get there, or if my idea just isnt doable would be much appreciated! Kind Regards Sebbe

I am putting together a space list for a building program. I can make a big list where every space is itemized. I can also create a summary of spaces by the Custom Space Name. Is there any way to develop a count of spaces by the custom space name. I would like this worksheet to say that there are, "6 Prep Labs, and 10 Offices". Sum Values appears to aggregate the square feet.

Is there a way to make this worksheet with its rows using alternating colors?

Hi VW-Forum, I'm kind of stumped and need help with a formula. Idea: If there is a certain value in a Spreadsheet cell, then show the content of a database field with a certain value in an other Spreadsheet cell. Please find attached the test file with a further description. Greetings and thanks for help Tobi 24-02-29 Test.vwx

I asked AI to write me a script with the function named in the topic. It gave me this, but it doesn't work. I'm an outsider, what do you think, is it a mess or are there just some small bugs in it? PROCEDURE SelectTextObjects; VAR worksheet : HANDLE; num_rows : INTEGER; row : INTEGER; cell_data : STRING; text_objects : ARRAY[1..1000] OF HANDLE; i : INTEGER; BEGIN { Get the active worksheet } worksheet := GetWSByName('hrsz'); { Get the number of rows in column A of the worksheet } num_rows := GetWSCellNumRows(worksheet, 1); { Loop through each row in column A of the worksheet } FOR row := 1 TO num_rows DO BEGIN { Get the data in the current row of column A } cell_data := GetWSCellFormulaN(worksheet, 1, row); { Find text objects that match the data in the current row of column A } text_objects := FindText(cell_data); { Select the text objects that match the data in the current row of column A } FOR i := 1 TO Count(text_objects) DO BEGIN SetSelect(text_objects[i], TRUE); END; END; END; Run(SelectTextObjects);

How can I convert a mm dim to feet and inches. I can do the math and get a decimal number, however I would like to display as 10' 5 3/16" I see there is a FormatField option as a function, however I am unable to find any documentation on how it works. Thanks Martin