Jump to content

Search the Community

Showing results for tags 'worksheet'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Announcements
    • Announcements
    • News You Need
    • Job Board
  • Feedback
    • Roadmap
    • Wishlist - Feature and Content Requests
    • Known Issues
    • Wishes Granted / Issues Resolved
    • Forum Feedback
  • General
    • Troubleshooting
    • General Discussion
    • Architecture
    • Site Design
    • Entertainment
    • Vision and Previsualization
    • Braceworks
    • ConnectCAD
    • Energos
    • Rendering
    • Workflows
    • Buying and Selling Vectorworks Licenses
    • Hardware
  • Customization
    • AI Visualizer
    • Marionette
    • Vectorscript
    • Python Scripting
    • SDK
    • 3rd Party Services, Products and Events
    • Data Tags
  • Solids Modeling and 3D Printing
    • Subdivision
    • Solids Modeling
    • 3D Printing
  • Vectorworks in Action
  • Archive
    • Resource Sharing
    • Machine Design

Calendars

  • Training Events
  • Coffee Breaks
  • Essentials Seminars
  • Webinars
  • Community Groups

Categories

  • Knowledgebase
    • Tech Bulletins
    • Troubleshooting
    • Workflows
    • How To
    • FAQs

Categories

  • Marionette - Objects
  • Marionette - Networks
  • Marionette - Nodes
  • Marionette - Menu Commands

Product Groups

There are no results to display.


Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Occupation


Homepage


Hobbies


Location


Skype

  1. Hey, I'm currently trying to make a worksheet that displays lot areas with their numbers. I want to also display a building footprint on a separate column that is still within the same row as the area based on the respective lot numbers. Both the lots and the building footprints are spaces but they are on their own classes "Building Footprint" & "Lots". What I'm struggling with is that I can't seem to add more criteria to the columns to display AREA based on the class that the object is on. I've tried the code lines: =AREA(CLASS('Buildable Footrpint')) =AREA(CLASS='Buildable Footprint') But neither of these work. The second code line returns the value #OPCODE?. I've attached an excel spreadsheet with the general idea of what I am trying to achieve. The overall criteria for the database is: =DATABASE(INVIEWPORT & (INSYMBOL & (INCLSUBX)) & (PON='Space')) Thanks for the help.
  2. Hello, we are trying to find a way with Pythenscript to Refrence VW-Worksheets a bit flexibel. We are having different Worksheets. We want to Refence one Worksheet with another Worksheet and trying to find out a way that Worksheetname for Reference can be flexible. At the moment with VW-Ref Function, the Worksheetname ist fixed and needs tobe changed if the Worksheetname has been updated. We also try to Run Python-Script in Vectorworks but not able to find out a way, how to retrive a PS result in a Worksheet. We are using this Function: =DATENBANKDURCHSCRIPT(120; 'Landschaft/Script.py') but unfortunately can not see what ist the output. We tried to find a Solution to List all our current Worksheet in some kind of Meta-Worksheet. The Python Script should iterate these objects and we would like to process the results within the RunScript Worksheet-Function but without success so far 😐: def list_all_tables(): # Eine leere Liste, um die Handles aller gefundenen Tabellen zu speichern table_handles = [] # Erste Objekt im Dokument h = vs.FActLayer() # Durch alle Objekte im Dokument iterieren while h != vs.Handle(0): # Überprüfen, ob das aktuelle Objekt eine Tabelle (Worksheet) ist if vs.GetTypeN(h) == 47: # 47 ist der Objekttyp für Worksheets in Vectorworks # Das Handle der Tabelle zur Liste hinzufügen table_handles.append(h) # Zum nächsten Objekt übergehen h = vs.NextObj(h) # Alle gefundenen Tabellenhandles an die Tabellenschnittstelle übergeben for id, h in enumerate(table_handles, start=1): vs.WSScript_AddHandleId(h, id) # Die Funktion aufrufen, um alle Tabellen aufzulisten list_all_tables() We would be very grateful for any tips or information 😃
  3. Hi I have a column with decimal values representing power consumption, in watts. In the next column I would like to know how many of my 600w power supply units I have to allocate. So I need to round up, but I cannot seem to make it work, it just writes out the formula indicating that something is not right. =ROUND(F2/600, 1) works , but rounds anything under 600 to zero. the worksheet function is documented as follows: roundup(number, digits) Rounds the specified number up to a specified number of decimal digits. =roundup(2.345, 2) returns 2.35 If I use the formula from the example, I get the same result, it just writes out the formula Any ideas? Cheers F
  4. Version 1.0.4

    843 downloads

    This Marionette Script creates multiple space objects from worksheet data. A very nice and time saving Marionette script to automate a routine peace of work. Please consider, that the the script takes the area column and calculate the square with that. If you have a language settings with comma instead of points for decimal seperator, the calculation will fail. Use points as decimal character or eliminate decimal places in your list
  5. Anyone having difficulty to list in database worksheet materials that are part of wall or roof style components? I am able to generate list of <any> is present materia just those that are part of slab styles....? Any idea? Thanks.
  6. Recalculating a referenced worksheet when using design layer referencing breaks the referenced design layers. Vectorworks 2024 files are attached and a brief description. Bug Submitted. Vectorworks 2023 this wasn't an issue as worksheets were not referenced but replaced if on a referenced design layer import with the same name. Master File.vwx Referenced Worksheet.vwx Description.pdf
  7. I'm experimenting with moving our planting schedule/legends from worksheets to graphic legends. I'm having an issue with the legend maintaining its size and the symbols aligning all on the center. What settings am I missing? Is it possible to manually adjust the list order? similar to how keynote numbering works? Based on the attached screenshot (the right image) can graphic legends achieve this? and are they ideally supposed to replace worksheets for this level of data? is there a way to connect the symbol with the correct lineweight and viewport setting into a worksheet? I know there is the image function... but it appears broken with not an accurate line weight. The current worksheet looks good. and is achieved by adding individual plant viewports and dragging them into place.. which becomes a tedious movement exercise prone to error whenever that sheet is updated.. I'm at a bit of a loss on how to speed up this documentation and looking for a few answers or recommendations on what is the best practice. thanks in advance
  8. Alright VW Friends, we need some help troubleshooting a particular workflow that has become problematic. The challenge... How do you create a legend that is specific to the items being identified by Data Tags within a given viewport using Records and Data Tags? Because this is a technical question, I'm going to have to get into the weeds a little with our particular challenge. We have grown particularly fond of using specific custom record formats, coupled with data tags, to more easily manage callouts/keynotes in a drawing. It is very easy to create "Master" legends that summarize specific information in a variety of ways for all "similar" objects across a drawing/file using isolation techniques like class, record format, layer, etc. The difficulty lies in using the same record information to query a subset of those objects that appear in specific viewports, and exclude those that do not appear. In the landscape architecture world, it is not uncommon to have projects where improvements span multiple sheets and/or viewports. These are typically separated by match lines. In the image below, we have a simplified scenario where improvements are divided into (4) different viewports... Notice that there are (7) objects in the drawing, each attached with the same record format and identified using the fields ID# and DESCRIPTION. The large circle, which is actually clipped into two objects by the serpentine "sidewalk", exists in all (4) of the viewports. In the attachments to this post are exports of each sheet layer as an individual image where it is possible to see that data tags, placed in the annotations of each viewport, can easily identify the objects by their ID#. I've also attached the VW file used to create this example. QUESTION: Now...how do you populate each of the unique worksheets with the items identified by the data tags (or even those that are clearly visible in the viewport)? The goal, given this example, is to provide legends (worksheets) that should include items as follows: Sheet 1 P-1 P-2 P-3 Sheet 2 P-1 P-2 P-3 Sheet 3 P-1 P-2 P-4 Sheet 4 P-1 P-3 P-4 You will also notice that the legends (actually worksheets in VW) do not correctly indicate the objects that are visible...or even those that have Data Tags. Sheet 3 doesn't include any...this is because our methodology, up until now, has been to use the Location...is within criteria in each unique worksheet to query the objects that fall within shapes that represent each viewport (gray dashed squares). For example, Schedule - Sheet 1, is querying ALL objects with 1) Record attached, and 2) Location is within Shape 01 Schedule - Sheet 2, is querying ALL objects with 1) Record attached, and 2) Location is within Shape 02 Schedule - Sheet 3, is querying ALL objects with 1) Record attached, and 2) Location is within Shape 03 Schedule - Sheet 4, is querying ALL objects with 1) Record attached, and 2) Location is within Shape 04 The problem arises because the Location...is within criteria only successfully queries objects where the Center Point falls within the identified Object. This is why Sheet 3 doesn't return anything but should include P-1, P-2, and P-4. There are technically two P-1s in this viewport because the large circle is being clipped by the serpentine path, but both of their respective center points fall outside of the Shape 03. Similarly the center of P-2, the serpentine sidewalk, is in Shape 02; and the center of P-4, the rectangular deck is in Shape 04. We have various workarounds to try and remedy this situation using this "Location Based" workflow, but they are needlessly complicated and result in errors that are difficult to track down and timely to troubleshoot. They are not worth mentioning and the goal of this post is to try and find another, better way. It seams to me that a solution might already exist, but as someone who knows VW quite well, I have struggled for a long time to figure out what it could be. A solution that does work, but we want to avoid at ALL costs is...clipping the objects by their specific viewports so that each object is firmly located "within" each specific viewport. This is a terrible method because it destroys all sense of greater geometry, creates more opportunity for error, and does not facilitate easy revisions if geometries require editing. I could think of two solutions, but both are NOT CURRENT functionality within VW that I am aware of: Query Data Tags and Report Their Linkage - The problem with our workflow is that it is querying the objects...not the data tags. It is possible to place the correct data tags on each sheet, regardless of where the object's center is, and it is possible to build a query/report of specific data tags on a given sheet layer. What IS NOT possible is to link the query of a data tag to the data of the object it is tagging. Intersection Criteria - If, instead of the only location based criteria being available being either "Is Within" or "Is Not Within", potentially adding an "Intersects With" option could mitigate the issue of an objects center point driving the query results. This is functionality common to many GIS software programs and it is one that I think could benefit a lot of use cases... Calling all helpful users to help figure out the best workflow for this @Eric Gilbey, PLA @bgoff @rowbear97 @Tony Kostreski @Vlado @Pat Stanford VW Sheet Legends and Data Tags.vwx
  9. Hello, Is there a way to get de name of the wall where my door is inserted into a worksheet? In the example below my opening should return "BW0.1" so i can easily count the openings in all concrete walls. If not posible with a normal function i am a bit familiar with worksheetfunctions so that could maybe be an solution but this makes the worksheets realy slow so i try to avoid them as much as possible. Thanks a lot! 😄
  10. We have window schedule (worksheet database type) reporting dimensions in feet and inches but would like to have it also in metric units as cm, m...Is there formula to do the convert? We have looked into worksheet functions and found 'ToUnit' but not luck so far to make it work. Primary file units are feet and inches. Thanks for any advice. Pavol
  11. Has anyone worked out a way to add comment text to a worksheet cell where there's already math going on in that cell> e.g.: =($W$3*O16)*2 {W3 is type ModA, '2' is a kludge} I have tried (text) [text] {text} "text" !text and it just disables the function. Not being able to document complex worksheets is a pain and very unprofessional of VW to build such a thing. Also is there a way to view or export a worksheet to see which cells have links to other cells? Are either of these situations possible in newer versions of VW? System is VW2018.
  12. I have about ten classes each of which includes a number of hexagons (ranging from one to about forty, and created using the Regular Polygon tool). VW does not retain Regular Polygon as a criteria object though so how do I count them in Worksheet? If it matters all hexagons are the same size 346m² A script would only be useful if the answer is written back to the worksheet, or another worksheet. I only use VW's workshet function so only looking for worksheet solutions, I've not had fun or success using the DB thing - and basically don't trust it not to profoundly f&^% up my drawings.
  13. When I'm doing plant orders I like to colour cells once I know an order is complete for that particular plant. I do everything in worksheets as have never found the plant database thing useful to how I work. Doing this manually is tedious: 1 select cell 2 right click 3 format 4 select format tab 5 dropdown 6 solid 7 Select colour 8 Ok I do not yet work with Marionette but have seen a few work nodes that mention colouring worksheet cells, but haven't found anything like this.
  14. Hello all I am new to worksheets and have been following a tutorial to set one up for building takeoffs of my project. I have started with the walls and have been able to create the worksheet with no issue except when I try to summarize the walls based on wall type. When hit summarize all of the data no longer shows, so it doesn't provide a Toal wall length or area for the summarized wall type. See the attached images below Does anyone have any idea what step I am missing? Thank you
  15. Hi, I have been looking into using worksheets to show the lengths of rolls of grass needed for plans that we are working on. We usually just show the grass rolls as red rectangles overlaying the shape of the grass we want to cover and use the dimension tool to show the length, but due to needing to now include additional information, it makes more sense to show it all in a worksheet. I have attached an image of the space below and the worksheet showing the length of each roll, moving from left to right. Is there some way that I can label each roll with a number or letter (1-6) and show those numbers on the worksheet so it can be easily referenced?
  16. I have a worksheet of plant counts by area - see attached. Each block of text in the worksheet is a plant label for one polygon. What I want to do is sum the totals for each species across the different label areas. I want to do the summing in another worksheet so I can send a nice tidy list to my plant supplier and planter. I have highlighted a couple of plant names to illustrate this, e.g. I want to get the total number of sophora microphylla across all labels. I imagine I need an if statement (or similar) in my other worksheet that whenever it comes across Sophora microphylla it goes across 2 columns, gets that number and adds it to a running total - I wouldn't have a clue how to do this but no doubt someone here else has with an inventory or related problem. In the final case there may be ~ 100 labels. I'm using this method as it works best for my sites and far faster and less complicated than the plant tags landscape areas, also this way I can skim backwards and forwards through the different areas in the table. I don't really want to use vectorworks’ database, but I trust the worksheet system.
  17. I want to shorten and join strings like this 'Coprosma hawera ' that are in a single cell to CopHaw and have them in another worksheet cell. The case would be nice but it's not a must-have. Has anyone solved this. VW screenshot of what I want to see. Excel example enclosed below, but I wouldn't have a clue how to do this in vectorworks.
  18. Ever since Title Blocks were revamped a couple years ago, I've been unable to create a simple Drawing Schedule (list of sheets) as a worksheet that's linked to my Sheet Layers / Title Blocks. It used to be as simple as pulling record fields from the Title Blocks, but that doesn't seem to work anymore, so I'm obviously missing something. Note that I DO NOT want to use Tools < Reports < Create Sheet List, as this creates an unlinked worksheet (an idea with I completely loathe). In my workflow I constantly re-name and re-number sheets throughout a project, so I need a worksheet that is always up to date without having to manually do anything. I see that it's possible to pull some data from TBBs, as seen in the screenshot of my test below: All I really need is 'Sheet Data'.'Sheet Title' but that doesn't seem to work? For my first column I just used =L in the column header which works fine to pull the sheet layer number. Here's an image of my simple goal, which I had in VW2017: @Nikolay Zhelyazkov @Pat Stanford
  19. Version 1.0.2

    178 downloads

    More powerful, than a database or text application. A Vectorworks integrated label-script-example with Marionette. The attached example shows how to import address data from a worksheet (could be other data and sources) and additionally places symbol beside the address. The power of Vectorworks and Marionette allows us to put everything you like dynamically on that labels. As example sort by male and female names (if possibly :-) and generate a individual pictures. Just infinite possibilities.
  20. Hello, I have a room finish schedule set up with the finishes of North, East etc... Now I need the schedule to give me a surface area of each of these walls for take-offs. What Criteria / formula do I need to input in order get this read out? I'd also like to display the Gross Height of the spaces. I've tried everything I can think of. Help! Thanks!
  21. Good Day All, I would like to create a worksheet pulling in all the dimensions in a project. The main reason is to see all Leader, Trailer, and notes of both dimensions and chain dimensions. A bonus if we can pull in the dimension style. It appears that the dimension record is hidden to users any one know where to find the values for the headers, if it is even possible? Any help would be great. Small Rant; Why at this stage of VWs do I still struggle using dual dimensions. Who decided that the [ ] should be a default for secondary units? Why can't I change it by default? Why can I not have a check box on a viewport to force dimensions into imperial, metric, or both? Why do some objects have options to be either metric or imperial but not all? For instance the stake object now has the ability to choose units, but the grade object nope no choice only reports primary as per document preferences. errrrr OK rant over. Thanks for reading 🙂
  22. I don't think it is possible, but I thought I would ask anyway. Is there a way to format text as a hyperlink within a worksheet in VW?
  23. In my Worksheet Database criteria Formula: I want to use a partial match on layer name - to allow for future change to the name, according to each file's needs using VectorWorks Designer 2017 The following is not finished, as I'd like to filter for any layer name, containing the word "Demolition" =IF((((L='Demolition') & (C='(Spaces-Existing-Non Living Enclosed')))=TRUE, space.area, 0) New at vectorscript, Thanks to anyone with this knowledge
  24. Hi, We have a Sheet Index Worksheet that is attached to our Title Block Border and related Sheet Numbers and Sheet Names. On the Sheet Index itself, I wanted to see if there is a way to edit only a few rows of the Sheet Index. For example, the Civil Sheets C1.0-C3.0. The grading is sometimes under a separate permit, so we'd like to differentiate these sheets somehow by making the text italic. When I try to edit the formating of an individual Sheet name cell however, it changes the formatting of all Sheet names to be italic. Please see screenshots attached. Does anyone know how I could format only the C Sheets to be italic, and the rest of the sheets's formatting to remain? Thanks in advance!
  25. Hello, Is there any chance to report in worksheet database length of structural member. Simple column type member or straight horizontal member.... There is for structural m. property: 'lenght'... when added to worksheet it changes to: ='StructuralMember'.'CenterPointLength'...but doesnt report lenght value. I know we dont have lenght field in OIP for structural member ... but one would expect that such a basic property of member can be easily available and reportable. Or am I am missing something obvious? would welcome if there is at least some math calculation alternative to be able report lenght value in worksheet or data tag as well. Since introduction of material resource we abandoned framing member but we feel that this tool is not really fully developed... Thanks for any suggestions.
×
×
  • Create New...