Marionette Maven Marissa Farrell Posted December 18, 2015 Marionette Maven Share Posted December 18, 2015 Here's the first set of worksheet nodes you can use in Marionette! I'll be adding more as the days progress, these are the ones I thought were most important. Once I get them all set, I will sort them into files so that they behave like the NURBS node section in the dropdown. Enjoy! (if there's any functionality you need sooner than later, let me know and I will prioritize for you!) Marissa 1 Quote Link to comment
dason Posted February 11, 2016 Share Posted February 11, 2016 Hi Marissa, I would like to use Marionette to take a list of about thirty x,y coordinate pairs calculated in a worksheet and create a bezier-smoothed 2d polyline from them. I have looked at all the nodes that ship with 2016, as well as the additional ones you posted above, but am not seeing how best to get that long a list of vertices translated from a worksheet to polyline. I can make an open polygon from two lists of values that represent x & y coordinates, but the list nodes only seem to be able to support 8 inputs. I have tried using your “Get Cell Value” node, but cannot manage to get it to output anything from a worksheet. That would not be ideal in any case because I need to output quite a few values and, if I understand it correctly, would have to repeat that for each one. Is it possible to grab a list directly from a worksheet? If that is not a current capability, would you be able to create a node that would do so? Thank you Quote Link to comment
AlanW Posted February 11, 2016 Share Posted February 11, 2016 (edited) Hi, To input a lot of coordinates you can do it with the any node. See the first part of this post setting up the caster and look at the first video. Haven't tried to drag it from a worksheet direct yet,b but will look at it tonight. HTH https://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=221493#Post221493 Edited February 11, 2016 by Alan Woodwell Quote Link to comment
DomC Posted February 11, 2016 Share Posted February 11, 2016 (edited) Or Maybe this one, of you want to get x,y from an external text file, till Alan finished the get worksheet node :-) https://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Main=43618&Number=218882#Post218882 Edited February 11, 2016 by DomC Quote Link to comment
Marionette Maven Marissa Farrell Posted February 11, 2016 Author Marionette Maven Share Posted February 11, 2016 Hi dason! I'm attaching a network that I hope will help/lead you in the right direction. In this document, the Get Cell Value node is a little different... the other one should have been "Get Cell Formula" but I misnamed it back when I made it. I also modified the Polygon2D node in order to smooth your poly with bezier curves. I'll update that in the shipping library at some point to have more options. Unfortunately, I couldn't get an actual polyline object to create properly, so I'm hoping the polygon is okay. How this works: The Sequence nodes will essentially loop through every row in the worksheet, starting with 1 and ending with however many rows you have. This can be modified by you if need be. You have to have an input of at least 1 for each the row and column to the "Get Cell Value" node, which I'm sure makes sense. Also, the alphabet equivalent is as expected, A=1, B=2, etc. These values are then pushed into the Point 2D node, creating the list of (x,y), and ultimately sending them through the Polygon 2D node to create your poly. I hope this helps, feel free to ask for more information if you need it. Quote Link to comment
AlanW Posted February 11, 2016 Share Posted February 11, 2016 (edited) Hi, every time I see a new node I simply laugh at what seems the endless possibilities of a programmer to manipulate a program to produce anything. Its an extension of ones mind, and Brilliant minds at that! I am so glad that I started following Marionette early so now I can follow along. Powerrrr toooo the people. Edited February 12, 2016 by Alan Woodwell Quote Link to comment
dason Posted February 14, 2016 Share Posted February 14, 2016 Thank you all for the input. Marissa, that did exactly what I needed. Thank you! Quote Link to comment
AlanW Posted February 15, 2016 Share Posted February 15, 2016 (edited) Marissa, Thanks for these nodes. This opens up a whole new are area whereby the data in the worksheet can control the geometry in the network. See file attached and a simple expansion on your network. Change the data in the worksheet and re-run. Change the name of the worksheets and make sure you tick the worksheet to update changes. Edited February 15, 2016 by Alan Woodwell Quote Link to comment
bluetzelberger Posted February 20, 2016 Share Posted February 20, 2016 Thanks for data sharing, helping me to understand Marionette, and hopfully finding my way.... Friendly regards Quote Link to comment
Guest unlimited Posted March 23, 2016 Share Posted March 23, 2016 Hi, here is a quick addition to the Worksheet nodes ( at least I didn't see it in Marissas list of worksheet nodes. I takes the Get Cell Value node which results in a and modifies it to Get Cell String for getting text data out of the cell. This is such a great tool ( marionette I mean, not my node) - I mean if I can modify a node, then anyone can Cheers, Martyn Quote Link to comment
ericjhberg Posted October 15, 2016 Share Posted October 15, 2016 (edited) On 12/18/2015 at 6:01 AM, MarissaF said: Here's the first set of worksheet nodes you can use in Marionette! I'll be adding more as the days progress, these are the ones I thought were most important. Once I get them all set, I will sort them into files so that they behave like the NURBS node section in the dropdown. Enjoy! (if there's any functionality you need sooner than later, let me know and I will prioritize for you!) Marissa The worksheet node files don't seem to be here anymore or am I missing something. I think they were there in the old forum, but didn't make the switch. I am looking for the shared Marionette nodes for worksheets but I can't locate them in this post. Thanks. Edited October 15, 2016 by ericjhberg Quote Link to comment
AlanW Posted October 15, 2016 Share Posted October 15, 2016 Hi, Attached is my latest collection of posted Nodes and they include early worksheet nodes from Marissa. See video as to where to locate them so they become available in your dropdown menu. HTH 161016_Various_Collected_Nodes.zip 2 Quote Link to comment
Nico vd Schaaf Posted May 23, 2018 Share Posted May 23, 2018 Hi! See screenshot for setup... I'm trying to insert data from a worksheet into a new worksheet created by a wrapper using the worksheet nodes. For some reason the Get Cell Value doesn't work. When I link the string to the Set Cell Value it does work so I'm guessing that it has to do with the worksheet being 'outside' of the wrapper...I can't find the solution so any help would be appreciated! Nico Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.