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. 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 😃
  2. 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.
  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. 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
  5. 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
  6. 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
  7. 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! 😄
  8. 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
  9. 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.
  10. 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.
  11. 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.
  12. 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?
  13. 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.
  14. 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.
  15. 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 🙂
  16. 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!
  17. I have single symbol that has 4 different records attached. All 4 records have a common field 'Slot ID'. I am trying to put together a worksheet database of all of the objects. The criteria for the database any of the 4 records present. The column header is currently, ='Type Record'.'Slot ID'. I am looking for help to get all 4 records field 'Slot ID' to populate in 1 column. Is this possible? it feels like it should be but cannot seem to get my head wrapped around it. Any help would be appreciated.
  18. 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)
  19. Has anyone built a marionette node for a dropdown in the OIP based on a worksheet (or list) ? I have figured out how to use the "popup dialogue" node for this, but it doesn't meet my needs completely. An OIP dropdown would make my life much simpler. Screenshot of how I am currently doing it below.
  20. Good evening, I'm writing because I'm trying to create my own worksheet in interiorcad, to use as an automatic legend in my sheet layer. (see attached screenshot) I was able to filter the cabinet and to show some values as, for example, the Board ID using ='Custom Part - Material'.'Board' but I can't show the most important value, the material Description (as I made my own material database in the interiorcad-Master Data-Edit Boards... menu) I've seen that in the template lists of interiorcad this value I'm looking for is visible with the command [BoardDescription] but I'm not able to transform this in a worksheet string. Is it possibile to do it, so I can better organize my own legend? Thank you in advance, Martina
  21. Hello, I am currently working in VW Architect 2021, and I am designing a two story residence. I would like to capture the space/room/dimensions and have that data reflected/incorporated into a VW worksheet so I can produce accurate estimations and material take offs. Any assistance that you can provide in this matter is greatly appreciated. Thanks, Ryan Russell
  22. Hi all, is there a worksheet function to determine the (projected) area of a 3D solid ? For quick numeric evaluations of Urban Design Proposals, I would like to calculate the sum of all (floor-)areas of all 3D-objects with certain selection criteria. Unfortunately, not all 3D objects have a floor area, only extrusions – and extrusions won't show up with a fill in the plan view. 3D-Solid-Additions work best for me, but they don't have an area - is there a simple way to calculate the projected area of any kinds of objects inside a worksheet?
  23. Hi all, I'm having some hard time with window schedules because the Sill is always coming with the window height function, even when we have in the tool the selection of "Structural Opening" which by default should include the sill height in, like the door threshold does, but when we add the sill to the window it adds literally the height of the sill but it doesn't add it to the "structural opening" size in the GENERAL OPTIONS for the window. Example is having a 1200mm height window (general options - Structural opening) if i add the sill of 50mm what will happen to the overall size of the window is going to 1250mm height instead of the sill being incorporated in the overall height of 1200 making the "Unit Size" smaller So with the above in mind is there a way of using the worksheet functions to "remove" the height of the sill while having it on the drawing so i can have a Realistic Structural size of the window opening ?? Hope i was clear on my explanations.
  24. Have looked all over for this to no avail. How do I add manually text to a cell which has data from a function call? So I have a cell B65 that has text in it In cell B91 I have =B$65, which gives me my text: Planting poly How_do_I_add_text_to_the_cell_? update - I've just found that =concat(B$65, ref_to_text_in_Another_Cell) works, but if that cell has nothing in it function returns 0, and adds that to the result Planting poly0 - oh and you've got to put a leading space in your other cell or it joins the result! So does one avoid that 0? Haven't found any manual entry solutions though...
  25. Hello, Do we have possibility to have bidirectional workflow when using data tags with worksheets? I want to edit data tag text field from within worksheet and I thought that we can do it using DATATAGFIELD('fieldname')...but content of the text field is locked in worksheet... Is there maybe other option to achieve this?
×
×
  • Create New...