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
  • 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

  1. 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
  2. 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.
  3. 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)
  4. 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.
  5. 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
  6. Version 1.0.4

    485 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
  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. 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
  9. 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);
  10. 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?
  11. 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
  12. 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...
  13. 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
  14. 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?
  15. 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.
  16. 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
  17. 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?
  18. 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?
  19. Hello, Is there any chance to report in worksheet database length of structural member. Simple column type member or straight horizontal member.... There is for structural m. property: 'lenght'... when added to worksheet it changes to: ='StructuralMember'.'CenterPointLength'...but doesnt report lenght value. I know we dont have lenght field in OIP for structural member ... but one would expect that such a basic property of member can be easily available and reportable. Or am I am missing something obvious? would welcome if there is at least some math calculation alternative to be able report lenght value in worksheet or data tag as well. Since introduction of material resource we abandoned framing member but we feel that this tool is not really fully developed... Thanks for any suggestions.
  20. 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
  21. 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
  22. 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.
  23. 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
  24. 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?
  25. 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.
×
×
  • Create New...