Jump to content

Search the Community

Showing results for tags 'worksheet'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

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

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

Found 74 results

  1. Version 1.0.1

    109 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
  2. I'm just learning about worksheets and generating reports. I've created a worksheet for a wall style and have 2 issues i can't resolve. 1) When multiplying Net Area and Price/ SqFt, the numbers are off. (The functions maybe wrong?) 2) Using =COMPNAMEBYCLASS i have the wall components listed to determine price/sqFt. but the total Net Area for each component and the wall styles don't match up. Or are they not supposed to? Attached is the file. Any insight into what i'm doing wrong is greatly appreciated. Worksheets.vwx
  3. Jose E. Calderon

    cAN NOT find worksheet

    For some unknown reason, a created worksheet no longer displays on my sheet. I find the worksheet listed on my resources but I lost it in the sheet layer. What is the way to search for this lost items??? I opened the worksheet but it no longer displays in the page. Here is a link to th e file https://www.dropbox.com/s/km6thwwbjw59yvk/Plano_Construccion.vwx?dl=0
  4. Bas Vellekoop

    Creating a bill of materials

    I`m trying to create a bill of materials for a table design. The idea was to create a worksheet to count all the symbols in the design (every part of the table is a symbol) and add a column to type a description for every symbol. But this doesnt seem to be possible. Is this correct? I want to add text in the blue part. If this is not possible: Probably attaching record is the way to go. Only me is told that i have to 'reload/replace' all the symbols on al the design layers to give it the record/info I attached to the symbol. Is there a way to attach the record to symbol and 'send' the information in it to all exciting symbols without replacing them? Thanks!
  5. Antonio Vargas Design

    WOKSHEET RENDERING

    HI does anybody's worksheet take a long time to render? My ones have been very irregular and it takes me sometimes up to an hour to render a simple three view technical drawings. Suggestions anyone
  6. minotto

    Wall Components in Worksheet

    Is there a way to itemize each of the wall components in a wall style in the database of a worksheet? I was able to create a worksheet with the wall style showing dimensions, costs, etc without a problem. In the database header, i tried setting the criteria to the class of the component but there must be more to it since it didn't work.
  7. I'm just learning about worksheets and have learned a lot on the forum. But i can't seem to find an answer to a very basic procedure. I'm creating a Door schedule and have used the User Field 1 in each of the doors for the price. With ='Door'.'UserFld1' placed in the worksheet database header, each of the database subrows have the correct price and have been formatted with decimal and the leader $. But the database header row only shows the number of doors with a dollar sign in front. How would i show the total price of all the doors in the last cell of the column? Is there a better way to do this that i'm missing?
  8. I believe this has been asked before: Is there a way to return the length of a dimension to a worksheet? Interestingly I can report the dimension height, width, x or y center etc. but am stumped to find the call for the dimension value itself. I'm associating Setback dimensions and would like their values to automatically populate the Zoning Check worksheet.
  9. =(('Property Line'.'Area')) returns a non-numeric string. Eg. 31106 sq ft I want use the numeric value to calculate allowable Lot Coverage as prescribed by the zoning How can I extract the area as a number?
  10. 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
  11. I have a worksheet which is a plant legend made up of records for a number of different plants. I'd like to separate the legends by category ie Tree, Shrub, Vine, Groundcover etc. I have the category in the worksheet and can sort, but is there a way to make entirely separate legends for each so I can sort alphabetically within the category?
  12. It would be nice to have the option to delete a particular criteria choice within a database header rather than just using the "Fewer Choices" to eliminate just the last (bottom) criteria choice. The current methodology for eliminating criteria at the top of the list is cumbersome if you want a clean list of criteria, free from "All Object" choices. I've had criteria that are more than 10 lines long and eliminating the first, third, and seventh lines is impossible without assigning a "All Objects" choice to it. I see two options for fixing this. 1. Consider an interface with + and - buttons for each line instead of the "More Choices" and "Fewer Choices" buttons. 2. The second option would be, when changing a criteria to "All Objects", the list reorganizes to put those choices at the bottom of the list. The user could then use the "Fewer Choices" button to remove the unwanted lines.
  13. Nico Vindevogel

    Multiple records in 1 marionette script

    Hey, I added a small part of a script to explain where I get stuck. What I want to achieve is to link a record to each component made in the script. I want to use records because i want to filter the data. Unfortunately, I think only one record can be linked to an object-node. In my example I create 2 records (same name) and only one is visible. Is there a way to associate a record to each piece in the script? It is not necessary to see the records in the oip , if its possible to get the data in a regular worksheet it would be perfect. A worksheet in the script is possible (used custom nodes #Created by MFarrell) . In the worksheet I can see the data from the two parts created. Problem there is, if the object instance returns 5 times i get only one worksheet in the resource manager. Can someone help me out? Maybe i have to approach it differently. Every hint is welcome. 1objectnode2records.vwx
  14. I have a model with mass models and a landscape. For the mass model I've made an entire worksheet that gives me a lot of information instantly. Now I'm trying to find a way to do kind of the same thing for the landscape. I have made several classes ( private green, public green, water, hard surface,...) all in the same layer (landscape). I was wondering of it's possible to make a worksheet that gives me in one column the name of the class and in the other column the entire surface of all the polygons in that class? Thanks in advance!
  15. Dear All, I'm struggling with Wall Types Worksheet. I'd like to add 'Components' and 'R-Value' data from Wall Types that I have. The partial solution for the first thing is pulling the data from the 'Description' field, but it's not what I want in the end. Is there a certain field name that I can place in the worksheet? Thanks in advance, Kris
  16. Hello guys, I tried to calculate average area in worksheet where i need to divide cell B2 by cell C2, I used (=B2/C2) in cell D2 which is in my database but the result is not as expected, its not actually dividing its just showing the values in Column B. whereas addition and subtraction is working fine but not divide and multiplication. Does anyone have a solution for it, I attached my file below kindly refer it. worksheet div.vwx
  17. I am used to highlighting the entire database header, copying it, and then pasting it in the cell in column A of the row where I want it, row 12 for example. This is no longer working. Now it pastes the header starting in cell B 12, leaving A 12 blank. I've also tried highlighting the entire row 12 then pasting, I get the same result. Can someone advise I'm not looking forward to copy + pasting every single cell for 20 different headers. Thank you.
  18. Hey al, Is there a way to use a spreadsheet of X,Y,Z position data to populate the appropriate X,Y,Z fields of a symbol, fixture, or any object? For example, a designer i work with gave me an MA3D file created in 3D but i need to turn it into appropriate lighting plot paperwork. I have X,Y,Z data for every finxture and want to use an easy copy and paste to position all fixtures correctly in the drawing. I have tried using a lightwright data exchange, report functionality listing the X,Y,Z data of each fixture, and tried to create records with no luck. any time i populate the fileds in a spreadsheet, the changes do not get reflected on the fixtures. Any tips? Thanks!
  19. Hello there... I have a worksheet listing all the windows in my project. What I want to do is to sort it by layer, using my layer stacking order (or story level) to do it. Of course I could use "=L" and sort it by name, but them I get something like 1º FLOOR.... 2º FLOOR... and only them... GROUND LEVEL. Is there a way out without changing "GROUND LEVEL" to "0 GROUND LEVEL"? That you mess with other worksheets I have... Thanks, VW 2014 Felipe.
  20. Hey all, Quick worksheet question for the veterans. Is it possible to get a SUM of areas generated from space objects. The SUM function adds together the number of database objects rather than of the information they are providing. I've attached a dropbox link to a jpeg that will explain it better than I can. https://www.dropbox.com/s/z62v30i61i5965i/Worksheet Screenshot.png?dl=0
  21. Patrick Thieszen

    Labeling marionette/worksheet objects

    Using a worksheet and a marionette network, I can create 61 circles (one rank of organ pipes) with spacing based on a percentage of their diameters. I'm trying to figure out how to create number labels for the pipes. I want the largest circle to be "1" and so on with the label using the same center as it's circle. Pipe Labeling.vwx
  22. My current plant worksheets split the plants out by category (Ferns, Forbs, Graminoides, Shrubs, Trees, Vines). I would like to add a column that indicates the Planting Bed Name. I can add this bed location note within the Plant Settings dialog for the individual plant or mass. How is this accomplished when adding a Landscape Area with the specific plants defined? The plants within the bed show in the worksheet, but not the Bed name. How should the criteria be set up? (I read another post that described adding the name of the landscape area to the data tab on the OIP, and adding a formula of differentiating criteria but got lost on trying that one!)
  23. Hi, Trying to build a worksheet to reference: Sheet Number Sheet Title Sheet Description And then also be able to put them in the Title Block. Is there a way to do this? I can't figure out the syntax. Or do I have to use the TitleBlock Tool ? Thanks Ethan
  24. Hi there, I have put together a drawing and want the worksheet to count nested symbols in a specific area of the drawing. I have named a rectangle area in the drawing "000-OrderArea", and they Symbol "ProjectSeat" appears in this area both on its own, as well as being nested within two other symbols. Here is the formula in the Worksheet cell: =COUNT((INSYMBOL & (S='ProjectSeat') & (LOC='000-OrderArea'))) The Worksheet is only counting the 'loose' symbols in the area, not any of the nested ones. Any clues as to how I can get it to count ALL of the symbols in the area? Cheers, Nick

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×