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
  • 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
    • Terms of Service and Community Guidelines

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

  1. Benson Shaw

    Worksheet =Area curiosity

    =Area returns area of 2d objects and area of source object of an extrude. But returns 0 for other solids. By mistake, I found an unusual use for this extrude “=Area”: Floor Area of a massing model made from stacked extrudes. Anyone know why extrudes report via =Area but the other solids do not? =SurfaceArea is formula for total surface area of a solid. -B
  2. I'm trying to create a worksheet that auto calculates spare lighting fixtures. So far I have it setup a database row that shows symbol image, instrument type, count per fixture. I want to add a column that calculates spares. I want the spare fixture count to be 15% of the total count. I would also like this number rounded up to the nearest whole number. For example, if I have 5 fixtures, instead of the column saying .75, I want it to say 1. I have tried using the Round command. I've been trying =(Round(C3*.15)+1). In my head that should get me a minimum of 1. What always seems to happen is the formula is calculated on the total of all the fixture below, instead of each row. See Image. My next question is, how do I set the row height for the cells in 3.*. I know I can select the cells and change the height, but I want to change the default height for those cells, so anytime I add a fixture to the drawing it gets added at the correct height? Thanks.
  3. I am trying to set up an efficient office standard system for setting up Window and Door schedules using drawing templates, styled WinDoor objects, record info and worksheets. I have seen this recent thread. https://forum.vectorworks.net/index.php?/topic/58464-favoured-window-schedule-workflows/ which is great however I am using WinDoor objects rather than native window and door objects so maybe the WinDoor experts might be able to help? This is all fairly new to me so any help or suggestions from anyone would be appreciated! At the moment I am looking at setting up 2x worksheets to be used together: 1) The actual schedule that would go on the Drawing sheet. 2) A "WinDoor Housekeeping" two-way report worksheet that can be used to edit the WinDoor objects quickly and efficiently. I like this as you can quickly pick up any inconsistencies in your doors & windows and correct them. This report would reside in the Resource Manager (not be put on an actual drawings). So far so good. I have set up both worksheets. I have gone through all the available records available from the WinDoor plug-in. A couple of little things though maybe someone could help with: Is there a way I can show the WinDoor style of my windoor objects in a worksheet? It would be good to be able to cross check what style(s) are in use in a file. I can't find this as a record. The other thing is with the WinDoor user fields. The "Schedule Data" tab of the settings tab lets you use presets for the user fields. If I use the "Door Height x Door Width" preset for a user field it is picked up in the worksheet which is great however if I later edit the door size the preset value in the Schedule Data tab doesn't update (let alone update to the worksheet). Is this working as designed or am I missing something? I guess being a "preset" it is like a default initial value however the interesting thing is that for the ID Symbols if you use the second ID field for the same "Door Height x Door Width" the ID tags will auto update when you change the door dimensions. In the screen shot attached you can see the ID Symbol updated to an 810x2000 door but the preset value is still on 2010x760. To update the preset value I have to go into the settings dialogue of each WinDoor object one by one which clearly isn't what I want to do. Is there a way to "reset" or "regenerate" WinDoor objects so these fields update? Unfortunately there is no "door height" record though there is a "door width" one which auto updates to the worksheets. I've also noticed door heights shown in the OIP differ from those shown in the form dialogue too... Any help would be appreciated. Thanks
  4. Is there a way to NOT see the Label Legend on an instrument when using the image function to display thumbnails of Lighting Instruments. (without turning off the label legend classes) Many thanks Mark
  5. I've been struggling with finding a way to use keynotes effectively in Vectorworks - and for us, one of the most essential aspects is the ability to revise keynotes as a project proceeds through the design process. Our office uses keynotes with a numbered prefix keyed to the CSI division format, and all keynotes have the same number throughout a project. We only place keynotes in a sheet legend if the keynote actually appears on a sheet, and keynotes may frequently appear on many different drawings - plans, elevations, sections. Attached is a sample file showing an alternate system for placing and reporting keynotes, based on a keynote record format attached to a custom symbol. The system uses worksheets on each sheet layer to report the keynotes on that sheet, and a separate 'master' worksheet to handle global editing of keynotes. Global editing is limited - text or reference fields may be edited, but editing the actual keynote number will break the link - the keynote number is providing the key link to the worksheet. I'd love to get feedback or suggestions that would improve this system. 170527 VW 2017 test.vwx
  6. Just started setting up 2018, when I import my saved / formatted Worksheets the Database Sub-Rows are reverting to Auto Fit on import, which makes the row heights unpredictable and inconsistent. I've tried re-saving the Worksheets but the Sub-Rows will not stick or stay set to the Database Header Row, is there a way to "re-lock" the Sub-Row Heights to the Header Row?
  7. nicovanderschaaf

    =count value not a number?

    I'm setting up a worksheet retrieving values from space objects. First column contains a number, second column counts certain type of space objects and the third should multiply the value of the 1st and 2nd column...should... ...but it doesn't. I've put the formula =(VALUE(A1)*VALUE(B1) in C1 but it doesn't convert the number in B1 to an actual number (B1 has the formula =COUNT). The result in C3 is the value of A1... Surely I've done something wrong but I can't figure it out what so any help would be appreciated!
  8. Hi, I've found that the function ( =GetSpaceNameForObj ) is quite handy in schedules and worksheets. However, how does a door determine the space object it "belongs" to, when there are space objects on both sides of a wall? If I have a straight wall with a space object on both sides and I insert a door into the wall, the door "chooses" one of the space objects, based on something I can't figure out. If I manually move the border of one of the space objects away from the wall, the door object "notices" that only one space object is now adjacent to the door and the (=GetSpaceNameForObj) value changes to that one. To sum up, the door object picks one of the two spaces adjacent to a wall, based on something. The end result is that some of the doors might appear as to belonging to "room 1" and some to "room 2", even though they all open to the same direction and are inserted into the same wall. I remember that years ago when drawing with ADT the door object had a non-printing marker line that one could drag over a space object in order to assign the door to that particular space to avoid this issue. Is there some similar functionality in VW?
  9. It would be awesome if you had the ability to right-click on a worksheet, placed anywhere in a drawing and have the option to create a duplicate instance of that worksheet in the resource manager/replace the selected worksheet with said duplicate. This is a workflow that would be extremely helpful when creating duplicate sheets with different worksheet variations, each designed to total different quantities/data present on that sheet alone. Instead, when duplicated such a sheet/worksheet, the original worksheet and criteria are still present and require a cumbersome resource manager duplication and replacement workflow.
  10. rowbear97

    Worksheets and Criteria

    Thanks to the excellent and informative 2017 Design Summit and the presentation by Eric Berg on worksheets I decided to try and modify one of my very dumb worksheets into something that can query referenced files and extract data not only from a parametric objects (a hardscape in the case) and an attached record (pavement). My issue or challenge is two fold. The worksheet criteria does show the desired number objects so long as I have (record - Hardscape) in the list of criteria. If I remove this it does not show the same quantity of objects with the other criteria (record - Pavement) even though the same 17 objects have "pavement" record attached. The second part to this is that I want the worksheet "database" to pull data from both the hardscape object and the additional record "pavement" in one materials schedule. I want to not only have the available info from the hardscape but additional information in the "pavement" record to populate the worksheet as shown. I have as shown the "pavement" record and the field that I'm looking for selected however it does not fill in this information. Am I missing something or am I trying to do something that isn't there yet. I do worry that the answer to this is to move to Project Sharing, which was also a very informative presentation by Rubina Siddiqui however we aren't there just yet. As a wish item, it would be great if you are using referenced viewport as a search option that a user would be able to find the object even though it is referenced.
  11. When adding scripts to worksheets, there is a dialog box that pops up every time saying would you like to block or execute scripts in this worksheet? Question: Can we somehow block or execute this option, through a script?
  12. Hi, I wonder if anyone knows who are the best way to get the height from a solid. I'm working on a single house in a sloped terrain, their wooden posts have different heights but with a standard notched end. The Issue begins when I try to get the heights from those "solid subtractions" on the worksheets. Normally I use the "framing member tool" to get those dimensions correctly, but in this case I've to make an extra operation because the notch. I've tried to convert them in other kind of objects like "generic solid", or "extrude along path" without success, I suppose there may be a formula or something that allows me to get the dimensions I need. Thanks!
  13. Cris Dopher

    WORKSHEET ROUNDED CORNERS

    Hi all. Is there a way to give worksheets on drawing rounded corners? Cris Dopher
  14. I am working on a project that requires me to extract areas from polygons and landscape areas that are embedded within symbols and display them on a worksheet. I then need to summarise the areas by symbol name and class, Is there a way to easily do this as function within a worksheet or perhaps using marionette?
  15. Martin Crawford

    Worksheets Selection Not Working

    Hi I am having a problems with a selection that has the following: Type - Symbol Layer - Screen Class - Module This works as expected. I need to exclude a few symbols that end in x If I leave the option off completely then I get 8 objects, if I change to 'ends with' or 'contains' I get back 2 objects. If I use the 'does not end with' or 'does not contain' I get a 0. Sometimes Vectorworks is very frustrating as it feels like there is not a lot of testing going on. Can someone confirm the issue and any suggestions on a workaround? Thanks Martin
  16. 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.
  17. Hi There, Does anyone know if there's a way to turn classes off in a worksheet image? I create symbols to represent art objects for exhibition design, and I embed the 2D component of the hybrid symbols with a number for use on floor plans. This number has a different class than the image I would like to appear on the worksheet. Thanks for any help you can provide!
  18. 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
  19. 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.
  20. 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!
  21. 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,
  22. 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
  23. 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!
  24. RMcK

    Slab data Area Take-off

    Does anyone know how to get an area output for slabs in a 'slab data' worksheet?
  25. 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

 

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.

×