Search the Community
Showing results for tags 'worksheet'.
-
Hello All I am trying to create a quantity take off of my wall assembly. If I use the preformatted wall report w/components I can get a report showing all the wall instances. The components are visible and the areas are visible. If I try to summarize the components so that I can get a total drywall or sheathing area for a particular wall type the quantities disappear. Does anyone have any ideas why this is occurring? Thank you
-
So, I'm trying to figure out a workflow to integrate ResCheck into my projects. I need to schedule my exterior walls with their desired R-Values. Please see the attached project. It's a stripped down version of what I'm working on. The problem I'm currently having is I can't seem to get the manually overridden r-values to appear in my worksheets. Only the calculated ones will appear. How do I correct this? Currently in the example, the manually entered R-Values are facetious. Once I get this problem solved, I'll correct them. Thanks, Rudy Beuc Wall R Factor.vwx
-
Hello, I have some trouble trying to edit the value of a space label. You can see in the screenshot that the value of the gross height of the label in the worksheet is 270. they're wrong and need to be changed to 306. If i try to edit the value in the workheet to 306, nothing changes and the value resets to 270. I tried to copy a 306 cel below and paste it in the 270 one but nothing happens. I never experienced something like this before. This is the first time i tried setting this type of worksheet up. Now i have to manually select each label and change the value like that which takes a lot of time considering i have to check/change around 2800 labels 🙂. Any ideas on how to fix this? King regards, Quinten
-
Hello, I've been searching around but i can't find a video about how this is made. In the Vectorworks user days (dutch). They showed a video of someone having a worksheet where it showed checkmarks if his electrical outlets were "above", "below" or "the exact hight" with a check mark, arrow up or an arrow pointing downwards. I'll add the video with the timestamp below. There you can see the sheet im talking about. Is there someone who has a similar worksheet that he wants to share with me so that i can learn from it. Huge thanks in advance! Kind regards, Quinten db
-
Hello vectorworks community, I wonder how to achieve something like this: Have one symbol that its text parts are linked to one record format fields. It act as a container for storing of informations about any specific project that somebody in office was working on. Its about logging working time on daily bases...filling calendar. Informations consist of: Project ID, tasks worked on, time spent on working task, drawn by etc. Now I want to collect data through worksheet database particularly overall time spent on specific project for specific project phase. I wish I could type into one designated cell within worksheet field value (Project ID) and that way control criteria of database results. So the results show only items (symbols) where same Project ID is checked. Then whenever I need to type in different Project ID and get different results. Everything happening in one worksheet. I see that in some Preformated Reports materials quantity - take off you can type name of material directly into database header and get quantity of that material...yeah this is something closer...but i wish to have one cell apart of database where i could type in Project ID and control one database or even few databases (differ by project phase for specific project) results same time. Any idea how to achieve something like this. Is it at all possible? Thanks a lot for any input. -
I have created my own worksheet that calculates areas from different objects. The worksheet is working fine and does what it is supposed to, but when I place the worksheet on a sheet layer and export it to a PDF-file, the values changes! They are divided by 1000...! Except the value that is below 1000! Have anyone seen this before? I have filed a bug-report about it.
-
Hello, I've looked everywhere but can't find it. Does anyone have a node that can return the number of subrows in a given row in a table? Input: Table name is OK (get worksheet) Input: Row number (Int) Output: Number of subrows (Int) Thanks!!
-
I am sharing these to help others, maybe, and perhaps collect comments and/or suggestions for improvements and refinements. There's an implicit presumption that, when using the data tag and worksheet on technical drawings, hazards have already been designed-out in earlier design stages. So these tools are used on so called "residual risks" which have to be managed. I use them before a construction issue. So at the stage when the drawing is being used for approximate-cost estimating. Meaning that the measures required for risk management get some of the budget dedicated to them so that they actually happen. Designers for construction in the UK have an obligation under the CDM Regulations. This is just one way I approach them on my small projects. There's a whole academic subject on this topic of course. And on larger projects the schedule would probably be developed into a risk-register. What do you think? One way of doing construction H & S in the UK.vwx- 3 replies
-
- 1
-
-
- health and safety
- datatag
- (and 2 more)
-
Hi folks, I've been looking around the forums for a solution to this and everything I can find doesn't quite fit the bill. I'm looking to either create a Worksheet (that I can then export to Excel) listing every class, used and unused, in the file. The specific information I need to pull would include, Class Name, Description, Fill Type, Fill Colour/Hatch/Tile, Line Type, Line Colour, and Line Weight. The reason I would like to do this is we are revamping our office workflow and part of that is consolidating and re-evaluating our class structure. Having a Master List to work through and use in Excel would speed this up considerably. Searching the forums, I've found @PatStanford's scripts that create a worksheet with the class name and fill colour as the cell background colour but I don't know enough about scripting to alter it so suite my purposes. I've attached a screenshot of what I'm hoping for. If anyone has any ideas, I would be very grateful. Thanks folks, have a great day. - Dylan
-
Hey there, I'm trying to figure out the best way to go about creating a clean position summary and I've been running myself in circles, so I wanted to see if anyone had any clever solutions. - I know there's a built-in tool, but I personally struggle a lot with making the Instrument Summary tool look good. The formatting drives me crazy. - I was inspired by Auto Plot's instrument summary and tried to build my own plug-in that could identify all lighting devices, ask me to select the lighting position I'm summarizing, and then insert that into the drawing. I got this to work partially, but never reliably. - So I then tried to build a worksheet, which worked. I created a template worksheet with a database that I filtered for the relevant positions. Then I got stuck trying to see if there were variables in Vectorworks. If there are, I could probably figure out how to automate a duplicate of that template, perform a lookup of active positions, and then drop the new worksheet into the drawing. I'm not sure if it's worth spending more time on this. It feels like what I'm trying to accomplish = A nicely formatted, summary of a lighting position that is dependable -- doesn't feel like it should be as challenging as it has been. All the information is there, I just feel stuck making it happen. Any thoughts, ideas, or reality checks are welcome.
-
I'm trying to read text from two different worksheets into a third worksheet - is this possible? I've read and searched many vonversations on here and found nothing useful. The enclosed image what I'm hoping is possible want to get the text in Cell A1 in worksheet - 0_Labels_plantList' and the text in Cell A1 in worksheet - 0_Labels_plantingSpec and combine them in Label_Plant _1. But so far I've found nothing that works, in the image is my latest failed attempt. I realise I could be using one of VWs built-in label things but i've never found them useful or attractive, partly as they are oriented to doing the same thing again and again, which is not something I've ever done.
-
I'd like to be able to use a double line or other "complex" line as a border for worksheets. Present workaround is time consuming and often forgotten by the team because the worksheets are often automated. (Draw rectangle around worksheet, change to double line type, resize if worksheet changes.) -
Using a worksheet (or a script - but I'm not a scripter) I want to intersect a collection of multiple rectangles within an enclosing polygon and get their area i.e . I want the area of the rectangles (as if I was performing an Intersection), as per encl. drawing and the shapes within the third box from left. Right-most box is a manual intersection I've been using to test things (while getting nowhere). Location in worksheets only gets some of the objects that the polygon crosses - it seems to be arbitrary re what it includes or omits. Any assistance or ideas very welcome. encl. drawing is vw2018. * what I hope to do eventually is to do the same thing by counting the intersected area of symbols (Left-most box) but that may be impossible with Vector works. counting_tests20250619.vwx
-
I have a file that makes Vectorworks freeze when i use a worksheet to report on Hardscapes. The fil has a lot of Hardscapes and I want to use a worksheet to extract materials, areas and volumes from the worksheet. The worksheet is based on a worksheet from the Library, with a few modifications. Vectorworks freezes immediately when the worksheet is activated. I have tried to start fresh with a new, blank worksheet, but as soon as the Criteria is set to Hardscape it freezes. I have also tried to copy the Hardscapes into an empty file, and do the same worksheets there. Everything works as normal... It will be a lot of work to go that way with all the other content of the file, and I don't fancy spending hours trying to import every single DesignLayer and SheetLayers to set everything up again. Any tips how to clean up a file like this? I can't share the file, because it is part of a competition and therefor it's confidential
-
I manage to get net height of a space object in a database line, but don’t manage to get it directly in a spreadsheet cell, despite following the vectorworks help. Do I do something wrong ? Vectorworks Space Net height.vwx
-
I'd like to be able split worksheets automatically to fit on a page. Perhaps by giving us the ability to choose the number of rows before a split is made, or by allowing us to choose the number of columns the worksheet is divided into (a bit like how we can with the General Notes object) -
We have a new issue, never encountered prior to VW2018. Currently we are having difficulty with Plant plug-in object visibilities...I've attached 2 screenshot videos (no narration, sorry) that show what we are encountering, but I will do my best to explain. We have (8) different classes we use to control the internal visibilities of our Plant objects. Currently, these classes are not responding to simple on/off/gray controls unless you go into each plant individually, after changing the visibilities, and then exiting the plant. Then and only then do they look correct. To make things worse, this error is compounded by the fact that as soon as one database worksheet plant schedule is recalculated, all of the active visibilities and buggy visibilities revert to a pre-altered state. I know this isn't the most clear description and I hope the screen captures do it more justice. Ultimately we need this fixed ASAP. This is a bad bug that affects our ability to produce any documents. Plant_Symbol_VW2018_Bugs.mp4 VW2018 Plant Bug 2.mp4
-
I have just noticed an inconsistency in font sizes (and possibly kerning and line height) between text boxes and worksheets – see image. In both instances I am using the same font – Calibri at 12.0 plain/unbolded (I specifically set the .0), and yet my textbox text is about 11.25 size. I'm not looking for an answer (I doubt there is one), just giving a heads up to anyone else who may encounter this, like is it still a thing in the current all singing all dancing VW2025? I am using VW 2018 on Windows.
-
Worksheets can already grab the image of objects to display things like a symbol or plant which is incredibly useful for schedules. What would improve the functioning of worksheets even more is the ability to grab the fill attributes/hatches/line types of specific objects similar to how graphic legends grab the fill attributes. I try to grab the images of items (landscape areas, hardscapes, etc...) but it just shows the actual objects not the fills or attributes of the object. I know that I could just use a graphic legend but I've found that they really don't help when making CDs for certain information as they are clunky and unable to be modified easily to look a different way, as well as the information is not able to be edited in the graphic legend like a worksheet is. That's why our firm exclusively uses worksheets for plant schedules, and all other schedules (paving, irrigation, etc.). Graphic legends also don't allow easy stacking of information or editing of information on the fly like a worksheet does unless they are being used for specific objects like doors, gates, etc. I believe this conceptually simple solution would add a lot to the functionality and usefulness of worksheets. -
Hi folks, I would like to be able to 1) create a worksheet (vs.CreateWS) 2) create a report (?) 3) set/edit the report criteria (?) using VectorScript or Python/Marionette For neither 2 or 3 was I able to find a corresponding VS command in the developer wiki: https://developer.vectorworks.net/index.php?title=Category:VS_Function_Reference:Worksheets&pageuntil=SetWSCellFormula VS%3ASetWSCellFormula#mw-pages Does anybody have an idea if there is a way to accomplish this? Kind regards, Antonio -
Does anyone know how to access the Key field from the Finishes database? For example, [CT-1] would be the key with the description Ceramic Tile, 4" x 4", etc. In VW we enter finishes by editing a database and entering these values, but in a finish schedule report, we only have access to a concatenation of Key and Description (which would be Floor Finishes Edit, or Space.Finish Floor and read as "[CT-1] Ceramic Tile, 4" x 4", etc." in the finish schedule), or alternatively the finish description only (which would be Static Floor Finishes, or Space.Floor Finish and read as "Ceramic Tile, 4" x 4", etc." in the finish schedule). Ideally, we would want to use the Key field in a finish schedule, not a length description.
-
Hi there, I am new to using records, reports, worksheets and data visualisation. They seem great, but I cant seem to make them work together. If anyone can point me in the direction of a comprehensive course or tutorial detailing all these (separately or together) I would very much appreciate it. In the meantime, is there a way of combining the data from data visualisation, different records and such into the same worksheets? I have one drawing that currently has three different tables on - data visualisation key, finish legend and finish schedule. Is there any way of combining this data into one table to be read simultaneously with the drawing. The project is quite small so it would be great not to have to spread this data across different documents. With all three tables, it looks so messy and unprofessional. Any help is always appreciated. Thank you
-
Hi all, I need to create a worksheet for local government compliance. In the past I have been doing this manually and I'm over it. In the worksheet I need to show the total number of plants and of that how many are natives and how many are exotics with percentages in the next column. I have been labelling native / exotic in the Comment 1 field of the Plant Style. I also need a total of how many species and the percentage that are native vs exotic. I have tried to work the problem with no solution.... maybe it can't be done. See attached as how I think the layout should look like.
-
Hi I have been having issues with worksheets on sheet layers. I have tried playing the worksheet on a sheet layer duplicating it as it won't fit on one landscape page. The other option I have tried is placing the worksheet on the design layer and use 2 viewports. The second viewport doesnt appear when published. Screenshot attached.
-
I have a marionette network that begins with a UI Boolean into an "If Switch," but the entire network runs regardless of if a value is sent down a certain path or not. Is there a way I can prevent part of the network from running if the "if Switch" doesn't send data down the line? Below is a screenshot of the current node structure:
