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. 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?
  2. 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
  3. 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.
  4. 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.
  5. 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.
  6. 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
  7. 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
  8. Whatever function the 'Does not Contain' dropdown criterion applies isn't correct. It should be, in the case of a Symbol Name: (S<>'*STRING*')
  9. 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...
  10. 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.
  11. 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
  12. 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?
  13. 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.
  14. 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
  15. Version 1.0.0

    108 downloads

    This example shows, how to create a record format with fields from an external csv or text-tab file with marionette. This example maybe needs the following know how which is not automatically is handled by the script: 1. Save Text with excel, open office or any other application as separated text file or tab separated text file. 2. Setup the "import txt" node-popup with the needed text encoding. Try utf-8, Latin1, macLatin_2 or other encoding to handle umlauts or special character issues. 3. The Exmaple just checks the first line of the text-file and creates record fields from them 4. The path to the text-input in the attached example is related to the document path. Save first your Vectorworks document. Or use an absolute path input. 5. No warranty or charge for this script, play first on a new file or on the attached file. I whish you success with it
  16. Dear VW lovers, would anyone know if it is possible to export Renderworks Style Settings into a worksheet or excel spread sheet? I have multiple Renderworks Styles and currently I am creating screenshots and copy paste them into a file for comparison. This is a huge effort and I would love to have a faster and more convenient work around for this. Any input is much appreciated. Cheers, Grethe
  17. The worksheet sort icons do not appear for me in 2018. "To sort or summarize a group of database sub-rows: If the database header rows are not displayed, select View > Database Headers from the Worksheet menu. Select the header row of the group of sub-rows to sort or summarize; the header row has a diamond next to its number. The three icons above the left end of the column header cells become available." Nope. They don't become available. I've just exported my file back to 2016, and it works. Feeling like I wasted my money on the "upgrade".
  18. I wish the worksheet functions be would be updated to include proper tools for pulling data from 3d geometry objects (basic dimensions like delta X, delta Y, delta Z, bounding box points, radii of spheres & cylinders etc.). The worksheet functions are outdated and clearly designed for a workflow of primarily 2d objects. This thread shows some of the shortcomings - The data should be able to be calculated regardless of the current view orientation (eg. you shouldn't have to switch to Top/Plan to have it work). Thanks, Kevin
  19. it would be extremely useful to be able to control upper lower case inside the worksheet. I frequently copy paste product specific information into various schedules and it is never formatted to match my spreadsheet. The workaround is to first past into standard text box, change it then select all cut and paste into worksheet - a bit of work.
  20. Hi, i tried to create a worksheet of the revision data of all title block borders of a document. However there is neither created a sheet layer which contains this worksheet nor a worksheet. I don't understand why, might be a bug in the title block border, issue manager? I actually am working with a german Vectorworks 2018 - SP2. Thanks in advance for your help. Regards, Matteo PK2016-v2018.zip
  21. It would be nice to be able to have different presentation of a same worksheet. For exemple I have a very big worksheet with lot of information. I need different presentation to show to different persons (like hiding some columns in one presentation and not in the other). Currently we are doing that with viewports that crops the part we do not want to show.... but is it a bit annoying the way we do that. It would be much better if we could simply have many instance of the worksheet and "hide" the columns (what we can currently do by giving the colums a width of zero) so the the "hidding" occurs only in that instance of the worksheet instead of reflecting into all of them...
  22. It would be really nice to be able to use the eyedropper tool within a worksheet so to be able to reapply similar formats from on cell to another quickly
  23. I've got a problem here that I can't figure out. It seems that I cannot "summarize" columns in my takeoff worksheet. Having ver. 2018, in the database row I should be able to select a column header and press the arrow key to the right and the dialog box pops up. If I select sum values the column should compress and show an overall value. It just won't do it. Bug? You will see in the pick that under column D I have an ascending symbol a plus sign and a 1 in that little box yet the columns below do not sum up.
  24. We have a new issue, never encountered prior to VW2018. Currently we are having difficulty with Plant plug-in object visibilities...I've attached 2 screenshot videos (no narration, sorry) that show what we are encountering, but I will do my best to explain. We have (8) different classes we use to control the internal visibilities of our Plant objects. Currently, these classes are not responding to simple on/off/gray controls unless you go into each plant individually, after changing the visibilities, and then exiting the plant. Then and only then do they look correct. To make things worse, this error is compounded by the fact that as soon as one database worksheet plant schedule is recalculated, all of the active visibilities and buggy visibilities revert to a pre-altered state. I know this isn't the most clear description and I hope the screen captures do it more justice. Ultimately we need this fixed ASAP. This is a bad bug that affects our ability to produce any documents. Plant_Symbol_VW2018_Bugs.mp4 VW2018 Plant Bug 2.mp4
  25. I am trying to create a worksheet with multiple formulas in it. For this I need to be able to search different criteria in each column. The type is spaces. What is the order of the text I need to input into the cell to pick up with the criteria would do in a database row? I have looked through all of the following places and it is not very clear to a novice. http://developer.vectorworks.net/index.php/VS:Function_Reference_Appendix#attrCrit http://developer.vectorworks.net/index.php/VS:Search_Criteria#Search_Criteria_Format http://app-help.vectorworks.net/2016/eng/VW2016_Guide/Worksheets/Worksheet_Functions.htm Thanks!
×
×
  • Create New...