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. I'm stuck, See attached Excel worksheet image for clarification of what I'm trying to do in VW. I've created a worksheet in Vectorworks with four different database rows in it. Each database row calculates, summarize, and displays information in a different layout than the others, but the one thing they have in common is that they all get their information from the same three layers in the VW drawing. What I'd like to do is create one place (C14,D14, and E14 in attached image) that can determine what layers are used in the four databases (rows 20, 22, 24, and 26), so the user doesn't have to edit the criteria for each database. Is that possible? In excel I can create a cell that has a pull-down list of values the user can choose from. If it's possible, I would love to do that in the VW worksheet where the pull down is a list of the layers in the VW document, then each database row would reference those cells to determine which layers to look at. I am comfortable writing my own script if that's helpful, but am hoping there's an easier way to do this within the worksheets. Any thoughts?
  2. Hello I'm trying to create a worksheet with a database row that looks for a certain record and then displays each field in it's own column. The issue i'm running into is actually making the row into a database row. Below is the code I am using at the moment. My understanding (which I suspect is wrong) is that I need to set the a formula for row 2 column 0. dynCharArray = '=DATABASE(INVIEWPORT & INSYMBOL & (R IN [Loom Note]))' vs.SetWSCellFormulaN(tempHandle,2,0,2,0,dynCharArray); When I run the code I get a popup box saying "Right Bracket Expected", no error messages from the script, just that popup box, and the script will have failed to turn the row into a database row. From my googling I'm struggling to find much documentation for building worksheets with Python Script/ Worksheet Formulas. (I'm sure it's out there I'm probably just not looking in the right places.) Would anyone be able to point me in the direction of some handy info on worksheet formulas, or give me a hint as to what i'm doing wrong here? Running VW 2020 Sp3.1
  3. We are experiencing a considerable problem where certain worksheets in a file, placed on a sheet layer, are showing up invisible upon file open. Only after recalculating do they reappear. This is happening every time I open the file.
  4. I use landmark and use additional plant records to include information about landscape areas such as seed mixes which then input into my schedules (worksheets). As these detailed soft and hard landscape drawings can get very heavy on larger sites (very painful for my work flow), I would like to split up the drawings into seperate files (eg. soft, hard, specific designed spaces) which I then reference as viewports into a drawing with the sheet layers and worksheets. This helps for a number of people to work on the project at once by splitting up the drawings in this way. This works well until I come to schedule the drawings and the records are not imported although landscape areas and plants are. Currently I have to combine my colleagues drawings before scheduling which is very time consuming and usually crashes. It seems sensible that all data is available from referenced viewports.
  5. Hello, I'm using Vectorworks 2018 SP6 (Fundamentals, Spotlight, Renderworks). For the last several months I've been maintaining a manual link between Vectorworks and Excel by going through a process of importing a CSV made from Excel as a worksheet and pasting values one column at a time into a database worksheet linked to a symbol record format. I made a couple of other posts with problems I had when I was first getting started with this project but unfortunately got no help. Once I finally got it working, albeit cumbersome, it had no real issues. I haven't needed to update either the Excel file or the Vectorworks file for a couple months but now I have new information to incorporate. All of the steps leading up to this point have been identical to what I did for months, but now I get an error message when I try to paste cells into this worksheet: "The cells you are trying to change do not allow pasting." I've never seen this before, doing it this way has always worked up to this point. Here's my troubleshooting process so far: Close without saving and restart computer Check it's the exact same number of cells copied as attempted to paste into Check file isn't accidentally open read only somehow (I can change anything else) Make sure correct Excel file was opened (I even opened an older version but got the same error) Try copying small groups of cells, which worked but only sometimes (also isn't a realistic option for 17 columns and nearly 2000 rows) Not sure what to try next. Any help is appreciated, thank you
  6. 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.
  7. 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
  8. 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
  9. 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
  10. Like we have for Viewports, can we also have out-of-date borders for Worksheets?
  11. 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?
  12. 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?
  13. 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
  14. 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
  15. 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?
  16. 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!
  17. 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.
  18. =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
  19. 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
  20. 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!
  21. 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?
  22. 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.
  23. 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.
  24. 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?
  25. 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!
×
×
  • Create New...