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
    • ConnectCAD
    • 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


About Me


Occupation


Homepage


Hobbies


Location


Skype

Found 85 results

  1. I am trying to create a worksheet with multiple formulas in it. For this I need to be able to search different criteria in each column. The type is spaces. What is the order of the text I need to input into the cell to pick up with the criteria would do in a database row? I have looked through all of the following places and it is not very clear to a novice. http://developer.vectorworks.net/index.php/VS:Function_Reference_Appendix#attrCrit http://developer.vectorworks.net/index.php/VS:Search_Criteria#Search_Criteria_Format http://app-help.vectorworks.net/2016/eng/VW2016_Guide/Worksheets/Worksheet_Functions.htm Thanks!
  2. Anyone know how to pull out the window style being used for a window in a worksheet?
  3. 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?
  4. Hi there, I am wondering if someone can help me figure out how to add a row in a report. In the attached image, I have a report using the space tool to show the space name and area. I'd like to either: 1. Add a row between 1.2 and 1.3 in order to add a sum of the Total (E) Area, and then add maybe a blank row below to separate from the (N) areas. -or- 2. Make the space labels different somehow based on whether they are (E) or (N). So when I pull a report, I could call up only the (E) or the (N), rather than both. Are either of these possible, or one easier/quicker than the other? Does anyone have any recommmendations for setting up building areas/spaces in worksheets? I am trying to set this up so that it can be used in our office template.
  5. Hello, I have a worksheet that functions as a "Sheet Index" and I'm trying to simplify the criteria that shows the active sheets. Presently my sheets have a numbering system that places an "X-number" and when I ready to have them show up on the Index, I change the X-number to a letter different than X. The only way I have been able to make the sheets no so the I recalculate is to add the criteria (Layer/is not/X-and the exact number) for each sheet. I Would like to be able to specify all the "X-" and have them not show with a single criteria. I have tried Name, Field value etc.. but haven't figured out how to make this work. I'm asking this because for some reason the edit criteria dialog window will no longer let me keep doing this. It's seems to have a reached a limit to the number of criteria of 25, because if I try doing this for some additional sheets I have recently added the function no longer continues to work. Thanks in advance
  6. I've use a lot of concrete stairs and there is no way to obtain the volume, m3 or cubic feet, of a stair, other than rebuild the stair using extrudes or converting to a generic solid and using the 3D properties, but you canont put that data on a worksheet, and in the process you destroy the parametric the stair, and if you change the model you have to redo the stairs, all of them.
  7. Version 1.0.0

    113 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.
  8. I would like the ability to add multiple rows in a worksheet not limited by the number of selected rows, or limited by dragging the bottom right handle of the ws. Currently if I want to add 7 rows in the center or a 4 row ws I need to: select rows 3&4 >insert rows, select rows 3-6 >Insert Rows select any single row from 2 to 7>Insert rows. I would like Insert Rows>selection or count?>7 enter.
  9. We are often tasked with quantifying elements in our drawings and dividing these quantities up along different sections of the design. To provide an example, the following screenshot shows an excel spreadsheet being used to track quantities across 9 medians in this case. Each row is a separate line item that we need to provide quantities for and each column to the right, a separate median. Also note that each row is potentially a different unit. It would be great if Vectorworks' worksheets had the capability to do something similar using database headers. I know it is possible by writing individual formulas in cells of a spreadsheet, but that gets cumbersome and potentially creates errors as classes modify and things shift throughout a project. Its a lot to keep track of. I also know that this could be managed by a record with separate fields for each of the medians' quantities, but again, that would have to updated each time the drawing shape changes since there is no way to link a shapes properties (i.e. area, volume, length, etc.) to a record value. We can easily separate quantities using design layers, polygon location references, records, etc, so what I am imagining is a general database header formula...L='Demo' in this example. Then in columns I could use the =C formula to summarize rows based on classes (essentially the line items from the example) above, Use the formula =AREA(LOC='MEDIAN 1'), =AREA(LOC='MEDIAN 2'), =AREA(LOC='MEDIAN 3'), etc. for all of the columns calculating quantities. I don't really have a great way of separating the units (=area, =length, =volume, etc.) though, so I would have to create a database header for each different quantity (which can screw up the order)
  10. I have created a 3d chair just by extracting multiple basic shapes. And i cannot find a way to extract volume for that. Can anyone suggest a way
  11. 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!
  12. Version 1.0.1

    171 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
  13. 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
  14. 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
  15. 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!
  16. 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
  17. 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.
  18. 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?
  19. 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.
  20. =(('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?
  21. 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
  22. 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?
  23. 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.
  24. 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
  25. 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!

 

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.

×
×
  • Create New...