Welcome To The New Vectorworks Community Board

Announcements

Natively available within Vectorworks software, Marionette delivers an algorithmic means to orchestrate and dictate design forms and customizations without needing to be a programmer.
Let the Marionette collaboration begin. Watch this video to learn how you can upload and share Marionette objects, nodes, and networks with your peers.

Share this post

Link to post

Share on other sites

One of my problems in reading from a window schedule spreadsheet or any with a header row is that all the cells have the same name under the header. See attached image, I selected each cell on the first column and got the results all the same in the 2 column.

So fail in this way to read from a worksheet.

Any ideas???

Also it appears that the maths in the Series and range node sees to be strange. See row 8-11 step by0.1 you end up with 2.3000000000000003.

Share this post

Link to post

Share on other sites

I'm going to try to answer all of your questions, although they may be out of order, and some may take longer for me to form a response to.

First, this file will help you get the correct values from your spreadsheet. In this case, we need to get the value of a subrow cell, instead of the value of a row cell.

I've added two brand new nodes to your network (I probably have the same ones floating around, and these ones aren't clean in the sense of descriptions, but they work. One day I'll get all of my worksheet nodes posted with correct descriptions.)

The first node is "Get Subrow Count", this will tell you how many subrows there are for a row. In your spreadsheet, row 2 has 2 subrows. I've incorporated this into your network to show you how to use it.

The second one is "Get Subrow Value", this node will provide you with the value in the subrow cell. It takes the same inputs as "Get Cell Value" as well as a "Subrow" input.

In this case, we will use 2 as our Row input, and 1 through 2 as our subrow input.

I hope this can guide you a bit.

As for the series node, that just has to do with how math is calculated. Float numbers can have infinite decimal places, sometimes they don't round out the same way that you would expect. I wouldn't worry about how far this goes, because having that many zeroes before that three means it's very, very insignificant overall.

Share this post

Link to post

Share on other sites

I am trying to get the maths right to shift a series of symbols (windows) that are in my drawing (see Design layer with Plan).I can run the network and draw all the windows in to a line (sort of) if you hit 2 on the keyboard you see them all in elevation, but I need to get width of the window + 250mm (or any number) and move it along so that no matter what size window I put in there will always be 250mm between the windows in the sheet.

Share this post

Link to post

Share on other sites

This is great Marissa. I made a little modification of your GetCell Node. The first Version was not able to return text values. I added a popup on the node to switch "number values" or "string values".

Share this post

Link to post

Share on other sites

Dom & Marissa, thanks for all this, my ultimate goal is to automate a window / door schedule as shown in the image as below. Getting them all to print out in a line was a great step forward, I can at least now just viewport them to a sheet layer. Next step is to have the dimensions to be attached automatically and have the info about the window printed under each one.

This is one tedious task for architects and automation would be fantastic.

Share this post

Link to post

Share on other sites

Back to my window schedule. The scripts calls up windows from my plan and places them in a line ready for viewporting to sheet layer for my window schedule, bur they need to be converted to a symbol first.

The top 2 networks call a list of the windows but wont place them in the drawing.

Link to post

Share on other sites

What you need to do is have windows as Window Styles and have all the parameters set by the style. That way each window will be specific to height, width and height above FFL etc.

Have all your windows in a folder and numbered so that the network will call up all the windows from the folder and place them in a row automatically. See sheet Layer viewport.

Thanks to Marissa for helping with this network earlier on and to DomC for his nodes.

Test it out and let me know how it goes.

Change your window types in the Resource Manager and don't change the heights on plan. You will notice that sizes and height above FFL are set by the style. This way you can control all the windows from here.

Share this post

Link to post

Share on other sites

You can reverse the list to make it go right to left, Hope this is what you were after?

I should look at this further because I was always wanting to add dimensions to each of the items automaticaly. What is your end format to give to the builder? it would be good to see a sample so maybe I can tailor to suite.