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

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

  1. 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.
  2. 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
  3. 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!
  4. 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
  5. 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.
  6. 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
  7. 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!
  8. 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!
  9. 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?
  10. 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
  11. 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.
  12. minotto

    Wall Components in Worksheet

    Is there a way to itemize each of the wall components in a wall style in the database of a worksheet? I was able to create a worksheet with the wall style showing dimensions, costs, etc without a problem. In the database header, i tried setting the criteria to the class of the component but there must be more to it since it didn't work.
  13. 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
  14. Hello, I've been trying to create a construction budget template that I can use in different projects and I need a lookup function for cell referencing. Some time ago I tried to write a python script that could do this for me but I could not get the code to work because of some issues including my lack of knowledge in programing. Here's a link to the discussion about the script where I explain in more detail what this function should accomplish: In other spreadsheet programs I can use this function, in Excel there is the VLOOKUP and HLOOKUP functions, in google sheets as well. I could export information from VW and do my budgeting in other apps but I would really like to do all inside VW.
  15. Version 1.0.0

    53 downloads

    This Marionette Script creates multiple space objects from worksheet data. A very nice and time saving Marionette script to automate a routine peace of work. Please consider, that the the script takes the area column and calculate the square with that. If you have a language settings with comma instead of points for decimal seperator, the calculation will fail. Use points as decimal character or eliminate decimal places in your list Spaces from List.vwx
  16. Nico Vindevogel

    Multiple records in 1 marionette script

    Hey, I added a small part of a script to explain where I get stuck. What I want to achieve is to link a record to each component made in the script. I want to use records because i want to filter the data. Unfortunately, I think only one record can be linked to an object-node. In my example I create 2 records (same name) and only one is visible. Is there a way to associate a record to each piece in the script? It is not necessary to see the records in the oip , if its possible to get the data in a regular worksheet it would be perfect. A worksheet in the script is possible (used custom nodes #Created by MFarrell) . In the worksheet I can see the data from the two parts created. Problem there is, if the object instance returns 5 times i get only one worksheet in the resource manager. Can someone help me out? Maybe i have to approach it differently. Every hint is welcome. 1objectnode2records.vwx
  17. 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
  18. Whatever function the 'Does not Contain' dropdown criterion applies isn't correct. It should be, in the case of a Symbol Name: (S<>'*STRING*')
  19. I don't think it is possible, but I thought I would ask anyway. Is there a way to format text as a hyperlink within a worksheet in VW?
  20. 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...
  21. 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.
  22. Hi there, I have put together a drawing and want the worksheet to count nested symbols in a specific area of the drawing. I have named a rectangle area in the drawing "000-OrderArea", and they Symbol "ProjectSeat" appears in this area both on its own, as well as being nested within two other symbols. Here is the formula in the Worksheet cell: =COUNT((INSYMBOL & (S='ProjectSeat') & (LOC='000-OrderArea'))) The Worksheet is only counting the 'loose' symbols in the area, not any of the nested ones. Any clues as to how I can get it to count ALL of the symbols in the area? Cheers, Nick
  23. 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?
  24. 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.
  25. Grethe Connerth

    Reports Records Database Worksheet Schedule

    Dear VW aficionados, could anyone please explain to me the difference between the below. Most likely I would understand a 'sketch or visualisation' to it better in comparison to reading the Help menu where I can't digest the content. --> Reports, Records, Databases, Worksheets & Schedules <-- Am getting utterly confused about these ;0)) Any input is appreciated. Cheers, Grethe

 

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.

×