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
  • General
    • Troubleshooting
    • General Discussion
    • Architecture
    • Site Design
    • Entertainment
    • Vision and Previsualization
    • Braceworks
    • ConnectCAD
    • Energos
    • Rendering
    • Workflows
    • Buying and Selling Vectorworks Licenses
    • Hardware
  • Customization
    • 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

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. Hello, I have a room finish schedule set up with the finishes of North, East etc... Now I need the schedule to give me a surface area of each of these walls for take-offs. What Criteria / formula do I need to input in order get this read out? I'd also like to display the Gross Height of the spaces. I've tried everything I can think of. Help! Thanks!
  2. Good Day All, I would like to create a worksheet pulling in all the dimensions in a project. The main reason is to see all Leader, Trailer, and notes of both dimensions and chain dimensions. A bonus if we can pull in the dimension style. It appears that the dimension record is hidden to users any one know where to find the values for the headers, if it is even possible? Any help would be great. Small Rant; Why at this stage of VWs do I still struggle using dual dimensions. Who decided that the [ ] should be a default for secondary units? Why can't I change it by default? Why can I not have a check box on a viewport to force dimensions into imperial, metric, or both? Why do some objects have options to be either metric or imperial but not all? For instance the stake object now has the ability to choose units, but the grade object nope no choice only reports primary as per document preferences. errrrr OK rant over. Thanks for reading 🙂
  3. 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?
  4. 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
  5. In my Worksheet Database criteria Formula: I want to use a partial match on layer name - to allow for future change to the name, according to each file's needs using VectorWorks Designer 2017 The following is not finished, as I'd like to filter for any layer name, containing the word "Demolition" =IF((((L='Demolition') & (C='(Spaces-Existing-Non Living Enclosed')))=TRUE, space.area, 0) New at vectorscript, Thanks to anyone with this knowledge
  6. Hi, We have a Sheet Index Worksheet that is attached to our Title Block Border and related Sheet Numbers and Sheet Names. On the Sheet Index itself, I wanted to see if there is a way to edit only a few rows of the Sheet Index. For example, the Civil Sheets C1.0-C3.0. The grading is sometimes under a separate permit, so we'd like to differentiate these sheets somehow by making the text italic. When I try to edit the formating of an individual Sheet name cell however, it changes the formatting of all Sheet names to be italic. Please see screenshots attached. Does anyone know how I could format only the C Sheets to be italic, and the rest of the sheets's formatting to remain? Thanks in advance!
  7. 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.
  8. Version 1.0.4

    588 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
  9. 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.
  10. 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
  11. 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.
  12. 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)
  13. 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.
  14. 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
  15. 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.
  16. 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);
  17. 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?
  18. 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
  19. 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...
  20. 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
  21. 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?
  22. 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.
  23. 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
  24. 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?
  25. 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
×
×
  • Create New...