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
    • Roadmap
    • Wishlist - Feature and Content Requests
    • Known Issues
    • Wishes Granted / Issues Resolved
  • General
    • Troubleshooting
    • General Discussion
    • Architecture
    • Site Design
    • Entertainment
    • Vision and Previsualization
    • Braceworks
    • ConnectCAD
    • 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


About Me


Occupation


Homepage


Hobbies


Location


Skype

Found 65 results

  1. I have multiple stanchion objects in a drawing & am trying to easily count the total number of stanchions required using a worksheet, but I cant seem to get the total to sum. Ideally my current 38 line database row would be summarized as a single sum total number, but when I use the sum values & summarize items check boxes it just returns me a -- instead of a number. Stanchion Test.vwx
  2. Hi- This may be an easy one. Trying to make a worksheet that shows the location of symbols. The symbols are all audio equipment in a rack, and the locations are rack spaces (rectangles, each having a specific name) As symbols are shuffled, I would want the spreadsheet to show the location. I can use LOC as a boolean to see if the symbol is in a location LOC="Rack1U1" but how do I find the name of the location?
  3. I’ve been taking my first tentative steps into the world of worksheets. I’ve made a worksheet that reports on material quantities in walls using the COMPAREABYNAME function. In the case of timber cladding/siding I then convert the sqm total into a linear metre value based on the type of cladding/siding being used. So in the case of 200mm featheredge board (bevel edge siding) I multiply the sqm in a separate cell by 5.71 which gives me the total linear metres for the cladding. Hurrah! What I was wondering was, is it possible to record this sqm-to-linear-metres factor in the wall style somewhere rather than inputting it into the spreadsheet? So that if I use a different wall style that has a different type of cladding (with a different sqm-to-linear-metres factor) I won't need to remember to alter the formula in the worksheet in order for the linear metres to be returned correctly because the formula will somehow take the value from the wall style? The worksheet returns values based on the component name 'wood siding' so as long as there's only one type of siding in the file it doesn't matter what type it is. My worksheet has only spreadsheet rows. I tried creating a record format that contained the 5.71 conversion factor in it + attaching it to the walls in the drawing then inserting a database in the worksheet + managed to report the total linear metres this way, but this doesn't really gain me anything. I want my '200mm featheredge cladding' wall style to have this factor baked into it. I saw some posts from people asking if it was possible to attach records to wall styles rather than to the individual walls but they didn't get any responses so I guess not... Any advice would be great. I have only the vaguest notion of how these things work so apologies if I'm asking something stupid. Just keen to keep learning now I'm on a roll!! Thanks
  4. As we all know when we draw walls, floors (slabs) and roofs the component portion of each object representing lumber is a monolithic object that in itself can only give area and volume. How does one determine board feet or the number of joists, studs or rafters required from the data we can retrieve from these objects. A formula of course. Would anyone care to share how that is done? I haven't figured it out yet. I'd like to get estimating materials worked out more for the company I work for using the models we create. More BIM! Thanks.
  5. Hi All, In an effort to learn (and not constantly bug users), can anyone point me towards resources on database string commands? I have a few worksheets that I want to develop that will require some custom database strings. I have no problem learning the code to develop them, I just can't seem to find the resources. I don't have any background in coding but this extended downtime the live events industry is stuck in is a great opportunity to learn. Any help would be greatly appreciated! Thanks.
  6. Hi all, I was looking for some help in the worksheets and putting a letter in a row for each symbol in the data sheet. I also was wondering if the general version of Vectorworks allows you to use data tags in 2020? Also any beginners tips for worksheets and making a BOM for the documents would be helpful, like more records or symbols tips. Thanks, Colin
  7. Hi everybody any idea how to split a landscape mass planting table -worksheet that is too long - to fit in my page layout...???...scaling is not the solution as will scale the text.... Thanks in advance
  8. In order to align several databases along the same row, I believe we need to provide the ability to reference a separate database formula for different columns (using if statements). It could prove to be useful when managing different datasets that don't have related record information, or have the same record information, but isolated extraction methods. Example below illustrates something that currently isn't possible in vectorworks that is driven by databases because each orientation would require a separate database callout with the rows controlled by an if statement. If they were controlled only by one datase record request, every orientation would be blank and distributed onto later database rows (rather than the same database row). Is something like this possible?
  9. Hi Everyone, I'm having an issue with the add list node. If I create a list with the ordered list node and run it in, everything works well, but if I extract that information from a worksheet and run it into the node the result is 0 items. I've tried formatting the data as different number types (dimension, general, decimal) but same result. Anyone come across this before? Thanks! -Chris AddList_Debug.vwx AddList_Debug.vwx
  10. I have two worksheet questions. 1.) I'd like to link rows of a worksheet to instances of a PIO to store some parameters and format settings. Right now I'm creating a UUID, storing that in a hidden parameter and in the last column of the worksheet, and then I match the UUIDs to push/pull data. This is not only a bit ugly, but a user can easily change the cell, breaking the link. On the other hand, if I store the initial row number in a hidden parameter, the user could rearrange the rows and break the link that way. Is there an elegant way to link rows with Python/Vectorscript? Or maybe some methods I've overlooked that might help? 2.) The PIOs are event-enabled, so when a parameter is updated, it automatically updates the worksheet. I'd like this to work the other way around. In the SDK I found this property: kObjXPropGetWorksheetEvents = 57. To me that looks like an event-enabled PIO is aware of changes in worksheets, but I haven't been able to find any other information on what event IDs to use, or how to point a PIO at a specific worksheet. Is is possible for edits in a worksheet to trigger a parametric recalc in a specific PIO? Thanks, All!
  11. What are your experiences with doing wall area take offs within a worksheet. I see that it calculates the length of a wall from the center line points. Has anyone dealt with the inaccuracies this affords? For instance, if I have a 10' x 10' room with 6" thick walls, the wall length (which it uses for area) is only 9'-6" long (subtract half the wall thickness each end). Doesn't this cause a problem with rounding area? Do you use a factor to account for this? Do you have any preferred ways of querying the worksheet for the wall data? I can come up with a work around, but others with more experience with this function could really help me save time. Thank you.
  12. 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?
  13. 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
  14. 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.
  15. 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.
  16. 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
  17. 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
  18. Like we have for Viewports, can we also have out-of-date borders for Worksheets?
  19. 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?
  20. 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
  21. 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?
  22. 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
  23. 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?
  24. 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.
  25. 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!

 

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.

×
×
  • Create New...