Jump to content

Search the Community

Showing results for tags 'worksheet'.



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

  1. 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?
  2. martinfdc

    Component Area by Class

    Hi, Establishing criteria for databases is easy: Database header cell: =CompAreaByClass('Class-1') using the previous function and establishing criteria I manage to show results only form a particular layer. What I can't do is the following, I want in a normal worksheet cell to get the area of my components but specify from which layer. I know I have to use this function: Spreadsheet cell: =CompAreaByClass(t=wall,'Class-1') What do I need to add to the function above to specify the search in a particular layer? Thanks in advance, Martín
  3. Ever since Title Blocks were revamped a couple years ago, I've been unable to create a simple Drawing Schedule (list of sheets) as a worksheet that's linked to my Sheet Layers / Title Blocks. It used to be as simple as pulling record fields from the Title Blocks, but that doesn't seem to work anymore, so I'm obviously missing something. Note that I DO NOT want to use Tools < Reports < Create Sheet List, as this creates an unlinked worksheet (an idea with I completely loathe). In my workflow I constantly re-name and re-number sheets throughout a project, so I need a worksheet that is always up to date without having to manually do anything. I see that it's possible to pull some data from TBBs, as seen in the screenshot of my test below: All I really need is 'Sheet Data'.'Sheet Title' but that doesn't seem to work? For my first column I just used =L in the column header which works fine to pull the sheet layer number. Here's an image of my simple goal, which I had in VW2017: @Nikolay Zhelyazkov @Pat Stanford
  4. Hi, I want to multiply two database values but I can't manage to do it. I attach a screenshot of the results I get.
  5. Chad Hamilton HAarchs

    Access to finishes field from worksheet

    Does anyone know how to access the Key field from the Finishes database? For example, [CT-1] would be the key with the description Ceramic Tile, 4" x 4", etc. In VW we enter finishes by editing a database and entering these values, but in a finish schedule report, we only have access to a concatenation of Key and Description (which would be Floor Finishes Edit, or Space.Finish Floor and read as "[CT-1] Ceramic Tile, 4" x 4", etc." in the finish schedule), or alternatively the finish description only (which would be Static Floor Finishes, or Space.Floor Finish and read as "Ceramic Tile, 4" x 4", etc." in the finish schedule). Ideally, we would want to use the Key field in a finish schedule, not a length description.
  6. Hi, I have made a worksheet that allows me to see what revision the different sheets are in. But when I get these squares in the end of the data. Is it possible to not have these in my worksheet?
  7. Michael Schroeder

    Worksheet Image Crop Issue

    All of a sudden my worksheet images are being cropped. Settings for Image are custom scale 1:48, Top/Plan Anyone know how to fix this?
  8. Hi does anyone know how to grab the texture of a group an display it in a worksheet? I can get the texture of objects with using "Function" and "Object Texture", but even though the group is covered by a texture I can't work out how to display it in a worksheet! I have thought of using a Marionette, to put the texture name in a record and then reference that, but you can't seem to get a texture name from a Marionette either!
  9. Hi, I'm creating my reports and to do so I need to sort my wall styles by name. Even though the wall style name is in the list of possibile answers, when I try to use the "starts with" or "ends with" "contains" etc the answer is always wrong, it is either zero or all of them. Am I writing things the wrong way and/or with the wrong syntax? Is there any other way to sort wall styles in the same class and in the same layer? Thank you in advance Martina
  10. Hi guys, Working on my first worksheets ever...in one of my first fully 3D drawing...learning BIM...and I love it! I have few questions on the way: 1. Is there a way to retrieve 'orientation' value from energos - building envelope - window/door/roof/slab/wall...for worksheet? I found energos label information available through 'records'...and some others through 'functions'.. but haven find this one yet. 2. Can I call up net area (without window/door..any openings) of facade 'orientation' awar? Lets say facade facing south has this amount of surface area while east etc...and sum opening area for same orientation is ...square meters VW has this information somewhere on background... 3. Can be particular object in one room be aware (through space object) of which space - room it belongs. I would like to show in windows/door (and maybe other) schedule where it belongs to what room...I guess we could apply this to other situation too like what and how much room finish belongs to what space... 4. What would be the easiest and most sustainable way to get this information. I am trying to add some text description to each individual component of my styles...to provide more information than the name of particular component. Do I need to attach some records...? 5. Can I retrieve some data - value from other worksheet within one file...I mean active link to some cell with sum values and use it for calculations in other worksheet? 6. (Not worksheet related one)What is the way to force VW to keep my default lists be my first and really DEFAULT (list like Lambda value, system lists etc...). I see that they will not stick default across whole vw...with some exemption. I miss this especially in energos environment where are many different lists to fill in different systems for building and 'users' will not stick first. 7. Why energos will not use my document custom units (m², m³) but use sq m, cu m etc.... Thanks a lot for reading this long list and for any advice or help. Much appreciated.
  11. You can create a database of "Data Tags" but it can't seem to filter by style, or display the style being used. Any Ideas? Optimally I want to create a database of all data tags used in a file with a certain name and call up the parameters to check their values.
  12. John Meunier

    Database CAPITALS

    Is there the ability to make a VW 2019 file ALL CAPS? Including databases and text styles. So far my workaround has been to manually type in CAPS, but the database header has got me stumped. I must be missing something. Any help is appreciated. Thank you
  13. rowbear97

    Slab Style Worksheet

    Working on building a worksheet where clients and users will see the composition of the slab styles that will be used in Hardscapes. I've managed to create in the attached just such a thing but have run into a little difficulty. When using a function to get the thickness of a component it is adding all of the components regardless of which slab they are a part. The attached file has our slabs and the worksheet with the cells in question. My vulnerability is Worksheets and I'm learning more every day but I really could use some help on this one. Your time and effort is greatly appreciated! Have a great weekend! Slab Styles.vwx
  14. rowbear97

    Worksheet Automation

    I'm working on a worksheet that has to pull data from existing parametric objects and various records attached to smart objects like borders and site models. I've been able to create a cells that pull information such as project name and project address from the Titleblock Manager yet I can't seem to crack the code on pulling the "Site Model" Cut, Fill, Net C&F Volumes. Any help in this matter would be greatly appreciated. Thanks in advance for your time and consideration!
  15. DCarpenter

    Displaying Location name

    I have a number of rooms on my drawing, and each room has a closed polygon around it that I've named that given rooms name, so when I want to summarize all the items in each room all I have to do is create a worksheet with criteria that's pretty basic. All the items on layer 'Room items' that fall within the location of 'Room1'. This works great, but what I'm struggling with is how to call out the location name 'Room1' in the resulting search criteria cells (if that makes sense). i.e. in the attached file, I'd like cell D3.1 and D3.2 to have the name of the location the items were found in. Any thoughts?
  16. I have a large convention center project with many separate areas. I want to put a hoist worksheet on my viewport. But I do to want all the hoist to show up. How do i sort the criteria for the worksheet. Do I need to create a worksheet for each area? Thanks!
  17. Benson Shaw

    Worksheet collapse or hide rows

    Worksheet database headers calling valid data cause sub rows (item rows? not sure of name) to appear below the database row. eg 12.1,12.2.12.3, etc. Is there a way to collapse or hide these sub rows and show only the summation values in the header row? thanks! -B
  18. I couldn't find any related topic so I started one. I'll try to explain my problem. I'm editing fields within a worksheet and I need to use the calculator (macOS) so when I clic the calculator to inpout some values, the worksheet in the VW window becomes invisible. All I can see is the giant X. (see attached image) This dramatically reduces my workflow because I have to keep clicking (or Command+tab) VW to see the values. The other option is to get out of the worksheet but then, when I return to VW I have to double clic everytime to get into the worksheet. Maybe it is a hardcoded macOS thing but it will be GREAT if I could see the worksheet while using the calculator.
  19. Hi all, So I have set up custom palettes with named colors, eg. I have a "Floor" palette with different, named epoxy colors such as "Nanten 340" etc. I use these palettes and color to visually assing the space object fill. Once I've a nice color scheme, I'd like to read the info to a worksheet directly. The problem is, I can't find a suitable function. I can find image, image fill, hatch etc. but not a function or a record for a color name in a palette. I've used this succesfully with images by grabbing a flooring carpet image from a manufacturer's website, naming it correctly and importing that into VW and then assigning the image fill to a space object. Then I can just read the info to my worksheet. However, this requires the extra step of creating an image and quite often one can do with colour codes(names) alone. I can also find a way to get the RGB values of the fills but this is not helpful really. Any ideas? Is there such a function/search criteria? Thanks
  20. Hi Everyone, I Have a worksheet in Vectorworks, with the CMYK values and, the code/nome of product. I need to convert this in .xml, like this below: <D>0.000000,0.117647,0.156863,0.419608</D> <N>SW 0001&#160; - Mulberry Silk</N> I trying made this with this Script below: But I have problem with separation after 0 (.), My export script doesn't put dot (.), Decimal point, after 0. MY EXPORT PLUG IN: 000000,3584070,6858410,113725 R129Abóbora I WANT IT TO BE LIKE THIS: 0.000000,0.3584070,0.6858410,0.113725 R129Abóbora PROCEDURE ExportTXTCMYK; VAR fileName : STRING; hplan : HANDLE; vcode, vnome, vcyan, vmangen, vyellow, vblack : STRING; numRows, numColumns : INTEGER; vlin : INTEGER; vboo: BOOLEAN; BEGIN fileName := 'Suvinil_CMYK.txt'; Append(fileName); hplan := GetObject('Teste2l'); IF (hplan <> NIL) THEN GetWSRowColumnCount(hplan, numRows, numColumns); vlin := 2; REPEAT vcode := GetCellStr(hplan, vlin, 1); vnome := GetCellStr(hplan, vlin, 2); vcyan := GetCellStr(hplan, vlin, 7); vmangen := GetCellStr(hplan, vlin, 8); vyellow := GetCellStr(hplan, vlin, 9); vblack := GetCellStr(hplan, vlin, 10); WriteLn(vcyan,vmangen,vyellow,vblack,vcode,vnome); WriteLn; {WriteLn('Teste Teste');} vlin := vlin+1; UNTIL(vlin>numRows); vboo := EOF('Teste_CMYK.txt'); Close('Teste_CMYK.txt'); END; RUN (ExportTXTCMYK); Sherwin-Williams Colors.xml
  21. Whatever function the 'Does not Contain' dropdown criterion applies isn't correct. It should be, in the case of a Symbol Name: (S<>'*STRING*')
  22. E Nelligan

    CABLE Worksheet: adding field

    Hi folks, Trying to make a worksheet report that includes the start and end label but it seems that the end label isnt an option. Is there another menu where I can select perameters to add? Being able to make a document that I can hand off to crew to make install is a big deal. Labels for both ends matter... *Sorry for the dodgy photos...
  23. When trying to represent an image (Planting Schedule) using the =IMAGE function, it seems that the cell formatting options of Layer Scale and Custom Scale seem to not be working properly. When selected, regardless of the scale chosen, the images miniaturize and become almost invisible. Additionally, the Auto Size setting acts differently depending on what option was previously selected...sometimes scaling symbols proportionally, sometimes not...but never responding to the relative plant definition settings for different plant objects. I don't remember this being an issue in previous versions or if this is just another NEW to 2018 bug, but I am pretty certain we haven't had this problem before. Finally, IMO the whole =IMAGE function within worksheets needs to be completely rethought to yield much better results. I have made several postings to this effect on the forum before and I'm not going to re-link them here...but this should be a prioritize FIX of an existing feature.
  24. Samuel Derenboim

    conditional cell formating

    Good afternoon everyone, can someone help me with a worksheet function? I am trying to pull out a record if a row and a column match a specific number or letter. Best i can describe is in the image below In this example - i am trying to pull out 24x36 in a work sheet if the record of column a and the row of 1 match in that cell. I am trying to do a metal panel schedule, and want to match the panel dimensions by row and column instead of putting all the information in rows. Has anyone ever attempted anything like this? the conditional statement of =if(symbol.record),statement is true, statement is false) doesn't seem to work for me, or I am (most likely)providing the wrong syntax to call out the information. Any suggestions please?
  25. ericjhberg

    Worksheets and Referenced Viewports

    So...we've come across an annoying bug. We are using a reference viewport system to build separate Production files, containing all of our sheets for a given project. These files reference in a Design file as we call it where all of the live linework is housed. The reason for this is not for discussion, it is just a workflow we have found works best for a multi-user/large multiple drawing set projects. With this workflow comes a strange bug when referencing worksheets through referenced viewports....they shrink. We often have to build our smart database worksheets/legends in the Design file and then reference those into the Production file through viewport references, but when we do, the worksheets shrink in vertical dimensions. We noticed this because we often have to put a reference symbol over the top of the worksheet for items (this is because the =image function in VW needs some serious attention), and when the worksheet and symbols come through the reference, they are no longer aligned and often are off by a completely illegible amount, no longer aligning with their intended worksheet row.

 

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.

×