Jump to content

Search the Community

Showing results for tags 'worksheets'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

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

Calendars

  • Training Events
  • Coffee Breaks
  • Essentials Seminars
  • Webinars
  • Community Groups

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

  1. 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
  2. Like we have for Viewports, can we also have out-of-date borders for Worksheets?
  3. 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?
  4. 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
  5. 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?
  6. 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
  7. 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?
  8. 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.
  9. 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!
  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. 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.
  12. 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.
  13. 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
  14. 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!
  15. =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
  16. 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.
  17. 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?
  18. 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!
  19. 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
  20. Hi all. Is there a way to give worksheets on drawing rounded corners? Cris Dopher
  21. 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?
  22. 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?
  23. 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.
  24. 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
  25. 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.
×
×
  • Create New...