Jump to content

Search the Community

Showing results for tags 'worksheet'.

  • 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. Sometimes worksheets will disappear from a sheet layer. There is nothing hiding them, their classes and layers are on, but they will not display. When I open the sheet, the worksheets flicker briefly, then disappear. The only (bad) solution seems to be a restart of VectorWorks. Does anyone have a better way to make them appear, and if so will it stop them from disappearing again? Restarting Vectorworks is not a fast process! iMac 27", 40 GB RAM, Mac OS 10.15.6 (and earlier). This is a continuing issue from vwx 2020.
  2. Is it possible to use conditional formatting on worksheets? Example 1: If a cell in a line meets a certain criteria I want the line to be highlighted blue Example 2: If a Boolean value is true, I want the text to be bold Example 3: If a record format number value exceeds a specific set amount, it is highlighted in red
  3. I have single symbol that has 4 different records attached. All 4 records have a common field 'Slot ID'. I am trying to put together a worksheet database of all of the objects. The criteria for the database any of the 4 records present. The column header is currently, ='Type Record'.'Slot ID'. I am looking for help to get all 4 records field 'Slot ID' to populate in 1 column. Is this possible? it feels like it should be but cannot seem to get my head wrapped around it. Any help would be appreciated.
  4. I'd like to be able split worksheets automatically to fit on a page. Perhaps by giving us the ability to choose the number of rows before a split is made, or by allowing us to choose the number of columns the worksheet is divided into (a bit like how we can with the General Notes object)
  5. I have a worksheet with database rows showing areas and occupant load factors from space objects. I would like to do a calculation of the occupant load based on the values of these two fields (area/occupant load factor). I understand that calculations in database fields may only be possible using scripting. Does anyone know how this might be accomplished? I've seen a file with a scripted calculation using one parameter, but not two, although I cannot seem to be able to make one parameter work.
  6. Hello, I would like to create a worksheet database whose criteria are "select all walls with the Pset_WallCommon IFC value Reference IWS-1** because here is the wall style Mark I want to use to divide my walls I tried the string =DATABASE((('Pset_WallCommon'.'Reference')='IWS-1**')) but it gives me no results, like it cannot read the IFC property When I use that field in a spreadsheet it requires the string =GETIFCPROPERTY(‘Pset_WallCommon’.’Reference’) so maybe I need to recall the IFC property some way? I tried some variants but nothing worked, can someone help me? Thank you very much
  7. Has anyone built a marionette node for a dropdown in the OIP based on a worksheet (or list) ? I have figured out how to use the "popup dialogue" node for this, but it doesn't meet my needs completely. An OIP dropdown would make my life much simpler. Screenshot of how I am currently doing it below.
  8. Hello, Recently I came across this useful script (made by @Pat Stanford) and I would really like to use it as a way to replace outdated layer name in criteria for many my spreadsheet cells within one worksheet. Can this script work with multiple cells selected, or it only function with one cell at the time? And is there around maybe updated version of script to more recent software versions? Thanks. Here is a script: Var S1,S2,S3 :String; N1 ,N2,N3,N4,N5,N6,N7 :Integer; H1 :Handle; Begin S1:=StrDialog('Enter Substring to Find','Loc1'); S2:=StrDialog('Enter Substring to Replace With', 'Loc2'); H1:=GetTopVisibleWS; GetWSSelection(H1,N5,N5,N1,N2,N5,N3,N4,N5); For N5:=N1 to N3 do Begin For N6:=N2 to N4 do Begin GetWSCellFormula(H1,N5,N6,S3); N7:=Pos(S1,S3); If N7 <> 0 then Begin Delete(S3,N7,Len(S1)); Insert(S2,S3,N7); SetWSCellFormula(H1,N5,N6,N5,N6,S3); end; end; end; ClrMessage; END; Run(FindandReplaceInWorksheet);
  9. Hello, Do we have possibility to have bidirectional workflow when using data tags with worksheets? I want to edit data tag text field from within worksheet and I thought that we can do it using DATATAGFIELD('fieldname')...but content of the text field is locked in worksheet... Is there maybe other option to achieve this?
  10. Good evening, I'm writing because I'm trying to create my own worksheet in interiorcad, to use as an automatic legend in my sheet layer. (see attached screenshot) I was able to filter the cabinet and to show some values as, for example, the Board ID using ='Custom Part - Material'.'Board' but I can't show the most important value, the material Description (as I made my own material database in the interiorcad-Master Data-Edit Boards... menu) I've seen that in the template lists of interiorcad this value I'm looking for is visible with the command [BoardDescription] but I'm not able to transform this in a worksheet string. Is it possibile to do it, so I can better organize my own legend? Thank you in advance, Martina
  11. Have looked all over for this to no avail. How do I add manually text to a cell which has data from a function call? So I have a cell B65 that has text in it In cell B91 I have =B$65, which gives me my text: Planting poly How_do_I_add_text_to_the_cell_? update - I've just found that =concat(B$65, ref_to_text_in_Another_Cell) works, but if that cell has nothing in it function returns 0, and adds that to the result Planting poly0 - oh and you've got to put a leading space in your other cell or it joins the result! So does one avoid that 0? Haven't found any manual entry solutions though...
  12. Hello, I am currently working in VW Architect 2021, and I am designing a two story residence. I would like to capture the space/room/dimensions and have that data reflected/incorporated into a VW worksheet so I can produce accurate estimations and material take offs. Any assistance that you can provide in this matter is greatly appreciated. Thanks, Ryan Russell
  13. Hi all, is there a worksheet function to determine the (projected) area of a 3D solid ? For quick numeric evaluations of Urban Design Proposals, I would like to calculate the sum of all (floor-)areas of all 3D-objects with certain selection criteria. Unfortunately, not all 3D objects have a floor area, only extrusions – and extrusions won't show up with a fill in the plan view. 3D-Solid-Additions work best for me, but they don't have an area - is there a simple way to calculate the projected area of any kinds of objects inside a worksheet?
  14. Hi all, I'm having some hard time with window schedules because the Sill is always coming with the window height function, even when we have in the tool the selection of "Structural Opening" which by default should include the sill height in, like the door threshold does, but when we add the sill to the window it adds literally the height of the sill but it doesn't add it to the "structural opening" size in the GENERAL OPTIONS for the window. Example is having a 1200mm height window (general options - Structural opening) if i add the sill of 50mm what will happen to the overall size of the window is going to 1250mm height instead of the sill being incorporated in the overall height of 1200 making the "Unit Size" smaller So with the above in mind is there a way of using the worksheet functions to "remove" the height of the sill while having it on the drawing so i can have a Realistic Structural size of the window opening ?? Hope i was clear on my explanations.
  15. HI all So I have a sparse worksheet (most cells are empty), and all I want to do is count the filled cells in the columns i.e. I just want a cell at each column base that says 7, 9, 3, 15 etc. As in the mockup image encl. I'm on Windows 2012 if it matters. Active cell contents are calculations from other cells, and sometimes manually entered numbers, and in case it matters the function in a cell looks like this. But Ideally I'd also like to be able to count plain text-filled cells later on. =(INT((K$7*$D$5*$A$30)/5)*5)+5
  16. 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?
  17. Hi folks, I would like to be able to 1) create a worksheet (vs.CreateWS) 2) create a report (?) 3) set/edit the report criteria (?) using VectorScript or Python/Marionette For neither 2 or 3 was I able to find a corresponding VS command in the developer wiki: https://developer.vectorworks.net/index.php?title=Category:VS_Function_Reference:Worksheets&pageuntil=SetWSCellFormula VS%3ASetWSCellFormula#mw-pages Does anybody have an idea if there is a way to accomplish this? Kind regards, Antonio
  18. 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
  19. Hi All, Perhaps an obvious question, or may be not.. but is there an easy way to summarise and view all the objects in my drawing so that I can make sure everything is in the correct class or on the right layer. As a VW newbie I have found myself drawing objects onto the wrong active design layer or creating objects in the wrong class. Sometimes I spot it at the time, or make a note to myself to correct it later. I know. Discipline! Some examples: Walls and doors should be in walls and doors classes (and only on certain layers) Televisions should be in an AV-TVs class and on the AV-Equipment Loudspeakers should be in the AV-Loudspeakers class on the AV-Equipment layer I only expect polylines in my audio zoning layers I was wondering if there was some means of checking things over via a worksheet for example and possibly correcting them from the worksheet too, perhaps. Spotting the things that are clearly out of place? TIA Ross.
  20. Hi, Is anybody also experiencing cells with wrap text on not to adjust and stretch (only one line of text is visible while others are cut of) to accommodate longer texts pieces even though height for row is set to 'auto fit row height'? I would normally need cell to accommodate 2-3 line of the text. I wonder if this misbehaving is caused by adjacent cells (in horizontal direction) in merged state....? See attachment (cells in orange outline). Mind you on screenshot is fixed state. Wanted to show cell structure. So far my fix is forcing cell to stretch to specific height so that all text fits in. Another issue is that even if I manage to fit text by enlarging row height (when worksheet is opened) it sometimes wont reflect that on worksheet when in not editing mode...just placed somewhere in drawing. Any idea in this issue. It is really tedious process to correct row heights when in one file i have easily 30 worksheets with same setup and each worksheet with ten rows to correct... Thank you very much
  21. Hi all, 2 questions: A: I`m wondering if it is possible to get Renderworks textures in an worksheet with an image of the texture. The idea is to create elevations with data tags which refer to a worksheet for the: material, texture, color, ... B: Is it possible to get the name of the chosen color fill in a data tag?
  22. Hello vectorworks community, I wonder how to achieve something like this: Have one symbol that its text parts are linked to one record format fields. It act as a container for storing of informations about any specific project that somebody in office was working on. Its about logging working time on daily bases...filling calendar. Informations consist of: Project ID, tasks worked on, time spent on working task, drawn by etc. Now I want to collect data through worksheet database particularly overall time spent on specific project for specific project phase. I wish I could type into one designated cell within worksheet field value (Project ID) and that way control criteria of database results. So the results show only items (symbols) where same Project ID is checked. Then whenever I need to type in different Project ID and get different results. Everything happening in one worksheet. I see that in some Preformated Reports materials quantity - take off you can type name of material directly into database header and get quantity of that material...yeah this is something closer...but i wish to have one cell apart of database where i could type in Project ID and control one database or even few databases (differ by project phase for specific project) results same time. Any idea how to achieve something like this. Is it at all possible? Thanks a lot for any input.
  23. I use object names often when I want to do a worksheet of areas, with each names object having a corresponding name in the worksheet to identify it. Is there a way that I can parse/read an object Name (e.g. D [ =AREA(N='D') ] in in D5 in image encl) and have another cell read and show/display/print that name? It sure would save a lot of double entry and avoid errors. I do not see a function enabling reading (in vw 2012) characters.
  24. Can a column in a worksheet be re-formated to display another dimension standard? USE: My file is in imperial (ft/in) I'm working on a worksheet for some LED video walls. I am pulling the module width and height fields. I'd like the worksheet to read 500mm, not 1'7 11/16" (The short answer is to finally get America on the metric system so this isn't an issue...)
  25. my clever colleague worked this out, so I hope it helps others. 2019 VECTORWORKS Useful Notes - areas calcs.pdf
×
×
  • Create New...