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

Calendars

  • Community Calendar

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

  1. 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
  2. lenny

    Materials Worksheet

    Hello I'm trying to find out the best way to export a list of materials used in walls, slabs and the roof. I'd need the material, size, volume etc. I'm not sure how to create this worksheet. Nor do i know how to look it up anywhere. Has anyone done this? Im' assuming I'd have to make record formats and add information on each walls data tab. Thank you Len
  3. Sean Harrington Architects

    Revision History Worksheets

    Hi there, I am new to creating revision history worksheets and am having some trouble ensuring all the information is populated into the sheet. The revision and date doesn't seem to be logging onto the sheet....does anybody have a solution as to why the sheet titles, drawing numbers and sheet sizes are logged but not the date and revision number? The title block revision data itself is working perfectly therefore I don't know why the worksheet isn't picking up the information. Please see attached image for reference. Kind regards and any help would be appreciated, Emma O Neill
  4. Like we have for Viewports, can we also have out-of-date borders for Worksheets?
  5. lisagravy

    Cropping worksheets

    I have a reeeeeeally long worksheet generated from a load of data in my drawing. I want to display the whole thing on a sheet, but because there is so much information it doesn't fit on the page, and as such I want to split the worksheet (probably a couple of times, and ideally with the headers repeating!) so that I can fit all the info on one page neatly. I also want to still be able to recalculate the worksheet. Is this possible?
  6. NicoleD

    Worksheet Lumber Counts

    I'm just getting into Worksheets, and I understand how to use it with symbols and finding their quantities. However, I would love to figure out how to get lumber material counts. Ideally, getting total lengths of lumber and total area of sheet goods, and then determining how many sticks/sheets are needed. I am having a tough time figuring out how to have the worksheet differentiate between 1x and ply - the only way I can think is to have different line types for each type of lumber and then put in different formulas based on the line types. Any ideas?
  7. 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?
  8. milezee

    Linking Multiple Files

    Is it possible to link multiple files so that I can create a worksheet which counts all the objects from the files linked to that project ? Scenario as follows 1- I create a master file with all my custom made symbols, attach records etc 2- I then have multiple files, different rooms, spaces etc which are part of the same project, and have symbols from the masterfile within them 3- I create a worksheet on each sheet page on each drawing with a Bill of Quantities for that specific file 4- Can I have a worksheet that will count all the objects across the multiple project files ??? So I have a complete list of all items required for the project as a whole 😊 tia
  9. 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
  10. Greetings all, Delving into more advanced worksheets prompted me to ask about these two particular records. The Truss record and the Truss Record record. As you can see in the attached screen shot, I can use one or the other and get three different results whilst specifying the exact same record columns. I'd like to better understand why. I've figured out the right combination of settings to get the info I actually need. Why do the settings on the right side give me an empty column for the user field 1 and has missing info in some of the other cells? How do I have the same items have the "Truss" record not present when the setting on the left side worked using the "Truss" record? In the middle, why does it double everything? And why the empty cells? On the left, why do I have success in setting the basic criteria to "Truss" but only need to search the "Truss Record" record? Further, why did this and the settings on the right side offer the same counts? Sometimes I feel like I'm in a feedback loop. I've attached the file to play with as well. Thanks, Scott WorksheetsForTrussCounting.vwx
  11. Tim Harland

    Spaces Volumes in Worksheets

    The Volume function in a worksheet does not seem able to calculate the volume of a space? The space has a height, Show 3D is turned on? I can see the volume of the space if I use database row but when I use the VOLUME function it returns 0. In the example screenshot the criteria in the formula are the same as for the database rows I am also getting the same figure (just the gross) for Gross and Net Volume despite having set different heights for each?
  12. Help please. We are trying (and failing miserably) to create a window schedule of a 1.5 storey house that has rooflights and dormers. We can create window and door schedules easily enough, but when we try and include dormer windows or rooflights - they are just ignored by VW - Help.
  13. Hi guys, I've created a custom formatted worksheet for our plant schedules that is just in a .vwx file on my desktop. I want everyone in my office to be able to have access to it via ourVW Workgroup. Is there a way for me to export just the worksheet into the Workgroup or do I maybe have to save the file it's in as a .sta template and access the worksheet in the Resource Manager form there? Any help is appreciated 🙂 Thanks!
  14. One of the most frustrating and time consuming experiences in VW is the copy and pasting of database header rows and other worksheet elements. It would be an incredible if, when copying and pasting a database header row, that the paste result would remember the summarization and sort settings of the original copy. Instead, it forgets all summarization and sorting and if you have a fairly complex system of these results, you have to manually restore them on all necessary columns. This is also true with merged cells. Worksheets should remember the merge and wrap text settings of copied cells and apply them to the paste. Excel does this, so should VW. Pretty basic, but a big potential time saver.
  15. 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!
  16. 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
  17. 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.
  18. 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
  19. 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!
  20. 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?
  21. 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.
  22. 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.
  23. 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?
  24. 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!
  25. Cris with no H

    WORKSHEET ROUNDED CORNERS

    Hi all. Is there a way to give worksheets on drawing rounded corners? Cris Dopher

 

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.

×