Jump to content

Search the Community

Showing results for tags 'worksheets'.



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 47 results

  1. Sean Harrington Architects

    Worksheets/schedules

    Hi All, We are using worksheets to generate a schedule of areas from information associated with Space Objects. Several of the upper floors within the building are exact duplicates of lower floors so for the purposes of efficency we have used design layer viewports on the design layer associated with a particular floor that is an exact duplicate of a lower floor. However, this is causing an issue when generating schedules. For example, Floor 3 is an exact duplicate of Floor 1, therefore on Design Layer 3, I have created a design layer viewport which shows design layer 1. I would like to generate a worksheet which shows information associated with Space Objects on design layer 3. Of course all these spaces are contained within a viewport, so when I choose “set criteria” on the database header row, I have checked the dialog box to include components within both referenced and unreferenced design layer viewports. However even with these boxes checked, the objects meeting my set criteria do not include anything within the design layer viewport. I have even stripped back all the criteria parameters to only list objects “whose layer is layer 3”, and kept the "include components within both referenced and unreferenced design layer viewports” dialog boxes checked and the returned list still only contains 1 object (i.e the viewport itself). Is there a way to resolve this issue? Any help would be appreciated.
  2. I would like to create a worksheet of all the Viewports in my drawing and most specifically what scale they are. Available criteria for viewports are limited. Is there a worksheet function I could use to achieve this? Many thanks. Mark
  3. I 'd like to see more input space provided for leaders and trailers when formatting cells in worksheets. See pic. 7 is just not enough. That number can be up for debate.
  4. Samuel Derenboim

    Property Line PIO Area Summaries

    Good afternoon Everyone, I'm having a real problem with calculating area summaries for the Property line plug in object. I've been trying a number functions additional to =('property line'.'area') in order to convert this string into a numeric value. I've tried =value, =area, =round, =num, =str2num, etc... and I can't for the life of me get it to work. Anyone had any similar problems - VW 2018 SP2 PS - I checked the VW forum records, there was a similar wishlist item, but for some reason =area function worked in that instance. Any help please? Thank you in advance!
  5. Hi, I use worksheets as a speedier way to enter data into title blocks, but sometimes my sheets exceed my screen size. It would be great to be able to freeze a column so that I can keep track of object IDs as I scroll horizontally, or freeze rows so I can keep track of my headings as I scroll vertically. Thanks,
  6. Greetings, I am generating worksheets to quickly export lighting instrument information for paperwork and labelling purposes on my shows. I'm able to get almost everything I'm looking for in the proper format except for my fixture positions. Often it is helpful to get the X or Y coordinates of a lighting fixture relative to a center point on a truss for quick placement on site as load in is happening. Currently when I request the 'x location' or y location' values in the lighting reports set-ups I get a string of very long numbers that don't quite translate to any useful real world units (see attached screen shot and file). I know there has to be a way to edit the format of these units, but I cant seem to find it. Any information or thoughts would be awesome as my current work around is to tediously use the measuring tool to find my x & y positions unit by unit...very time-consuming. Note: I've tried changing units within my document preferences and it doesn't seem to effect the worksheet output Thanks! x-position tester.vwx
  7. thinkingpencil

    Window Area

    In Jim's Knowledge Base list of window functions for worksheets I cannot find "Overall Window Area". Is there such a function to return the elevational area of the window? For now I use the obvious workaround :WindowWidth*WindowHeight. Before using this workaround I was using the function "Area" . This returns a value for each window in my database worksheet. But the value is larger, though not much, than Width*Height. I guess Area is too simplistic for using with the 3D Window object , being normally for 2D objects. PS I am finding VWX2016 a truly rewarding experience!
  8. RMcK

    Slab data Area Take-off

    Does anyone know how to get an area output for slabs in a 'slab data' worksheet?
  9. Hello, I am developing worksheets to give me take-offs for my zoning and code area requirements for permits. I am currently doing this through assigned zones in space labels which seems to tie everything together well. However, it is taking a long time to change the settings, class settings, label setting to the space labels in each new project. Is there a way to change and save the default space label settings so that this is already done? Thanks, Rebecca
  10. I'm just learning about Worksheets. It seems wall, door, window and slabs are all represented in the choices for possible functions, but not floors. Why is that? I've created a couple of floor objects and would like to create a worksheet with the names of the materials and sqft. How would this be done?
  11. As part of our running wish list requests of past, we have asked that the =IMAGE function in worksheets work better (see previous post links below, Item #4 in link 1). In v2017, the worksheet resolution feature was added to enhance this functionality, but it's only part of the solution. Upon experimenting with the new functionality, a problem still exists with the worksheet representation and 1:1 vector-based matching of the symbol in the drawing. The current version's symbols are very clear, but are a very light lineweight, appearing very faint compared to intentionally dark items in a drawing. We need a way for these visibilities to match, so that there is no mistaking the worksheet representation with the drawing representation.
  12. 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!
  13. As far as I can tell, NNA door & window objects do not include a record field that report the net vent area (WinDoor objects provide these), and doors don't have a field for net glazed area. Any tips on how to calculate / report these in a glazing / fenestration schedule? Thanks! Cheers, Markus
  14. I have several VAA titleblocks. All have one revision entries. Have used the VAA Revise Issue Print command to create a Document Transmittal as shown below. Not all revisions are showing up in the Transmittal. Any ideas why?
  15. I've been trying to get data from a worksheet by Python script. Here is the basic code: def FindTable(): hLayer = vs.GetParent( vs.FObject() ) vs.EnableDrawingWorksheetPalette(True, None) while hLayer != None: h = vs.FInLayer( hLayer ) while h != None: # worksheet? if vs.GetTypeN(h) == 56: rows, cols = vs.GetWSRowColumnCount(h) cellnum = vs.GetCellStr(h,1,1) vs.AlrtDialog( vs.Concat('Cell 1 ',cellnum,' Name: ',vs.GetName(h),' visible: ',vs.AreWorksheetGridLinesVisible(h),' rows=', rows, ' cols=', cols) ) h = vs.NextObj( h ) hLayer = vs.NextLayer( hLayer ) return 0 It doesn't work and returns 0 rows and columns. I guess "Worksheet container" type is not good and these APIs don't work but the cycle returns only handle with type 56 even without any 'if' condition. Maybe "Worksheet" type is what I'm looking for? types and IDs But how can I obtain it?
  16. VerhoevenJ

    Records and worksheets

    I have made a symbol and attached a record. In this record I have made a field where you can give a length and a drop down menu that has 4 options. Now I want to make a worksheet that gives me the sum of the length fields with the specific option selected in the drop down menu. Can anyone help me? Worksheet_&_records.vwx
  17. rowbear97

    Worksheets

    I'm clearly out of my league here! I've looked around and done a little experimentation yet I am no where closer to finding a solution. I'm working on a project where I want to inventory symbols. In this worksheet I have created criteria that counts all the symbols and sums up the symbols with the same name giving me a count that is accurate. Here is the tricky part. I want to take the inventory of different symbols by name and add them together as well as multiply one particular symbol by two to give me a final total number of units. What am I missing or is this a functionality that doesn't exist?
  18. Josh NZ

    Worksheet Borders

    I have a worksheet which im wanting to show with an outline to the perimeter only. Have gone into the format cells dialog and unticked "inside". Then ticked "outside". In the review it appears how I want it to. As soon as I exit thou every cell has a border. What am I missing?
  19. ericjhberg

    HELP!!! Worksheets 2017

    I converted a previous file to 2017 and started editing worksheets I already had in the drawing set. After editing the worksheets, they no longer appear on the sheets, but rather show a big X through it. I can still edit the worksheet, but it never appears unless I duplicate its instance in the resource browser and place the duplicate. Even then, after editing the duplicate, it does the same thing. Help!
  20. I have several VAA Titleblocks in a template. I also have a worksheet which shows the info from all titleblocks. As its in a template there are no revisions. However all the titleblocks show the current revision as A, even thou the list of all revisions shows as no entries. Images should hopefully show in more detail.
  21. Bruno Sá

    Worksheet issue

    Hello everyone, need some help with worksheets... I'm trying to create my own space area worksheet for a new template in VW2016. I created 5 spaces to be listed and test the worksheet, but the space named Living Room isnt listed with the correct name, insted of this it appears as another bath! In the image you can see that the value of the area listed is correct (43,41m2) but the space name is shown as "bath". I tried to create the space in diferent ways, check all the fields in the object info pallete, and redraw the example for the spaces as well for the worksheet! Can someone help me? Thanks! Bruno.
  22. Im trying to get a worksheet to to give me true lengths and widths of 3d rectangles, I had rotated in space. I could get the worksheet to only report correct dimensions If the object was aligned to parallel to the screen plane. The dims would change as you switched to different views. Some one can teach me how can worksheet be programed to calculate the true dims, no metter in what view the 3D solid are. Thanks Rui

 

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.

×