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

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


About Me


Occupation


Homepage


Hobbies


Location


Skype

Found 85 results

  1. To multiply, the formula should be =SUM(cell1*cell2) but when I press enter, nothing happens How do I properly multiply two cells in a Vectorworks worksheet? To add, the formula should be =SUM(cell1,cell2), when I do that it works
  2. Hello all I am new to worksheets and have been following a tutorial to set one up for building takeoffs of my project. I have started with the walls and have been able to create the worksheet with no issue except when I try to summarize the walls based on wall type. When hit summarize all of the data no longer shows, so it doesn't provide a Toal wall length or area for the summarized wall type. See the attached images below Does anyone have any idea what step I am missing? Thank you
  3. Hello community, I wonder is there a way to rename multiple database row criteria (using same object style name) in same worksheet in one action? As you can see in attachment, I have a structure of wall (can be slab, roof..) with 10 components, but each component is directed to the same style name OP02. If i want to list all components for lets say different wall style with name OP03 I have to go to change it 10 times in database criteria...and thats tedious. Also I dont want to have preformatted worksheet for 10 - 20 different wall/slab/roof style in one building. So any thought or put it other way is there a better criteria approach for calling components with simpler criteria setup? Maybe script would do it? Thanks for help.
  4. 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.
  5. it may be a banal question but is there a way to insert a column in worksheet at the right end as opposed before last col on the right? I know the instructions: To add columns to the right side of the worksheet, click and drag the bottom right corner of the worksheet - it makes no sense, clicking and dragging resizes the worksheet window
  6. Version 1.0.1

    171 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. I have had trouble editing room finishes through worksheets for spaces with Space Style. Even all the Room Finishes are by instance, whenever I attempt to change the finish using dropdown, I get a message: "One or more objects could not be updated because the selected parameter is defined by the object style". The fields are not grayed out as it would be if it was by style. If I make the space unstyled, I have no trouble changing the finishes in the worksheet. If I check "Hide Style Parameters" in Object Info Palette the option to to edit Room Finishes disappears, even when all the parameters are by instance. If I update the Space Style all the applied finishes of all the spaces that has the style turns into the default finishes (or disappear) I believe there are some issues with the overall Room Finishes by style/by instance setting, as there is no place in the Space Settings one can define it. I guess, it assumes that in all the styled spaces Roof Finishes are by style in default and overrides other "sub-properties" I can easily edit the finishes through Space Settings for the styled Spaces, but the problem that I have to go to my 100 spaces and do it room by room. Then, when I have spent several hours editing finishes to individual spaces and all looked good, for whatever reason I decided to update the Space Style, all my work was gone - all the finishes turned into the default Space Style Room Finishes. My conclusion - I can't use Space Styles for rooms with different finishes. Let me know if I have missed out something in the settings. Spece Finishes Test File.vwx
  8. I'm still using 2012 which some folk think is old but it works. From the forums it looks like the basics are being ignored with lots of Baroque 'features' added. So I'm thinking long and hard before I upgrade. No bells and whistles just the daily needs of a landscape professional. Things I'd need to make upgrading worthwhile considering: Worksheet (I hear this might be in 2020 but not confirmed) - two-way excel red\write - or at least read from live excel file - ability for cells to read colour info from classes including alpha level - cell commenting like excel - full keyboard fcn shortcuts for all actions - like Excel - ability to export xls files - ability to read text (from csv txt md mdown xls) into worksheet cells - worksheet access to text blocks and vice-versa Simplified arraying - even circular arrays are a real trial, just something simple like ACAD and Sketchup. MS Word, a real working live link from VW to word, or least to a text file. Keyboard access to rotation in object info. Image file export - Has this been improved?, e.g. for image export of non-standard size, in 2012 it was Alt F E R and the image default settings are jpeg 2000 and marquee, image filetype can't be changed in marquee so click to another Export Area type and back to format to change that and then back to reset to marquee, then draw marquee (would be great to have dropdown of remembered marquee draw boxes) and finally save. - What new files are enabled? Can the default filetype and format be changed? - Also seeing as Nemet think VW is a GIS what about being able to read height data from .tiffs?? Property Line \ Landscape subdivision lot module - full control of annotations - topolological polygon editing \ autoupdate of adjacent polygons. Text formatting; kerning, easier handling of mixed formats in a single text block. Ability of system to retain focus on a text block - I'm a non-touch typist and often look up and see I'm no longer in the txt dialog. Plantline lines like Acad had 20 years ago where basic line is drawn and output can be changed at will - makes for much smaller file sizes too. Has the snap-to-all fcn been removed? Alpha \ opacity control for gradients allowing one to have a gradient that fades out to 100% alpha\transparent (a very basic part of GIS's and R). Very useful to show graded actions on plans such as planting densities. Layers and classes - has there been any integration between these? If Classes are truly sub to Layers why can they not all be on same panel? Big time savings potential. Support for old vw formats including .mcd. AFAIK Acad goes all the way back, why not VW?? ------------------------------------ Nice to have: Colour palette referencing has been awful - has it been improved? Having to remember where a colour is as you move around the interface is just silly. Ability to filter exploded pdfs by shape and class them automatically. How is reading of live data feeds, especially GNSS \ total-station data? Printing Having saved views in batch print is annoying and wastes time. Is it still like this? Digital file export with all referenced files - like old Acad pack'n'go Inclusion of a duplicate \ overlying polygon tool.
  9. I'm working on a door worksheet, and I wonder if there is some formula to count L&R Doors. I assigned a custom record to each door, with boolean parameters (one for left and other for right). Now my worksheet do the work, but I think it can improve avoiding repeated information. Perhaps I can use the function =count, with the conditional If for the record, something like this: =COUNT (If record is 'carpinterias' and value 'izquierda' is true). Is that possible? thanks in advance.
  10. 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
  11. A worksheet created in 2016 seemed to become partly dysfunctional when opened in 2020. A function with the same basic structure, but returning different values from the fields of a record format, was used to display text in several columns of one database header. Column A ='Outline Schedule of Works'.'Work Sub-Category' Column B ='Outline Schedule of Works'.'Location' etc It worked fine in all but one column of the database header. Despite the structure being identical to the other columns. When a neighbouring function was pasted into the failing column it too became dysfunctional, returning only itself in the sub-rows. Simple fix:- delete the column. Add a new one in the same place. Formula then worked correctly.
  12. 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
  13. 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
  14. Hi, sorry, but I cannot find out how to write my marionette object's parameters into database records (or worksheet cells), which was my reason to create them – can someone point me in the right direction? I wasn't able to find example scripts ... My objective is to create a door schedule that uses simple, 2D, self-made, non-IFC door symbols with data stamps, to be placed on 2D-drawings (draftsperson does not use walls, just lines). Most parameters will be strictly database records that never appear on the drawing, but WIDTH, WALL THICKNESS, and OPENING DIRECTION (L/R) should be 'hard-wired', i.e. taken from the plan, in order to avoid common mistakes. My first approach was to calculate opening WIDTH and wall thickness from the bounding box of the door symbol/group. This works fine, but only as long as the wall layout is strictly cartesian and the doors are not rotated or mirrored. Also, we would like to use door symbols that are larger than the opening width (including frames etc.), so we would no longer be able to calculate the width from the bounding box, wich seems to be all a worksheet can access. Or is there a way to access data from objects INSIDE a group that is listed on a worksheet? So I created a marionette object that draws the door opening based on parameters, because I expected it would be easy to access those parameters from a worksheet or to write them to an attached database record ... but I find that task surprisingly difficult. Am I missing something? So far, my marionette network, run as a wrapper, can draw a door based on two parameters OPENING WIDTH and WALL THICKNESS, and attempts to attach a pre-defined database record to that object, where it correctly fills the fields for wall thickness and opening width. However, the result is a simple group (not a PIO, so it cannot be manipulated by parameter later), and it is nested twice in otherwise empty groups, unnecessarily. If I convert the wrapper into an object node, it becomes the expected parametric plug-in-object that I can modify later, but it does not attach a database record to itself or writes its data to a record that I attach manually. What am I doing wrong? test door database.vwx this is what the door symbol plus tags should look like this is my marionette object node (so far, without tags, but okay ... if it only wrote to the database !!!
  15. Hello all, I'm trying to import a CSV into my VW 2018 file via File>Import>Worsheet. Up until this point my workflow has been working fine, but I'm now trying to import the latest version of this CSV generated by Excel that now has cells that start with "E" and have a digit or two after, sometimes with a hyphen. Unfortunately, it appears that VW tries to do math on those cells and replaces them with 0e+000 and displays them as 0 if there's a hyphen (see "Worksheet View of Imported CSV.PNG) or some negative number if there isn't a hyphen What I've tried so far: - Restarting Vectorworks and my machine. Doesn't seem like the kind of problem to be resolved by this but it was worth a shot. - Using a Tab delimited worksheet instead. Same problem. - Checking that excel exported the data properly (see "Excel view before exporting CSV.PNG" and "Notepad++ view of imported CSV.PNG"). The exported file opens in other programs just fine. - Changing the cell format in the VW worksheet via Format>Cells... Doesn't help, and changing them to text just makes them display "0e+000" instead of 0. - Manually typing the data into the cells (due to the volume of cells that will eventually be involved in this, it's not a long term option but just as a test). It did work though if I first changed the cell format, but otherwise didn't work. Is there a setting somewhere for reverting all cell formats to text when importing CSVs? Do you know of another setting somewhere that might cause this or some workaround I could consider? I appreciate any help you can provide, thank you for your time! EDIT - If it helps, a friend suggested I try to recreate the problem from scratch, so I made a new csv and vwx, imported it as I had been and got the same problem.
  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, 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
  18. 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.
  19. 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?
  20. 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?
  21. 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.
  22. 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
  23. 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!
  24. 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
  25. 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.

 

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.

×
×
  • Create New...