I have to check out more often these blogs. What a bad timing, that video is from December 14, just a few days ago. You would think I just stole his idea. Luckily, i remember i proposed the same method he uses to create multiple columns in excel 2 months ago in this thread: http://groups.google.com/group/grasshopper3d/browse_thread/thread/43e2b3f2cb3d2991/
Btw, the replace stuff that is done in excel at the end of the video can be done directly in grasshopper. This way you can avoid repeating that process every time you update excel. On Dec 19, 6:07 pm, LML <[email protected]> wrote: > designalyze also had a video explaining some of that (towards the end > of the clip): > > http://www.designalyze.com/2008/12/14/streaming-data-from-grasshopper... > > LML > > On Dec 19, 6:39 am, rob <[email protected]> wrote: > > > Fantastic and fantastically straight forward! And the video is the > > perfect way to demonstrate. GH has improved so much since its > > inception. > > > I also got a response on the rhino.plug-ins newsgroup that was > > scripting based from Damien. He said the same thing about baking, > > which I was beginning to realize. (http://news2.mcneel.com/scripts/ > > dnewsweb.exe?cmd=article&group=rhino.plug-ins&item=29791&utag=) I'll > > pass your response on to him in case y'all aren't cross pollinating > > regularly. > > > Thanks. > > > On Dec 19, 9:00 am, visose <[email protected]> wrote: > > > > It may seem weird to reply to a post by creating video, but i was just > > > trying out this desktop recording software... plus my youtube account > > > is so empty... > > > > It's pretty straight forward:http://www.youtube.com/watch?v=J1ay9gqKB60 > > > Sorry for all the scrolling, next time I'll use alt-tab. > > > > On Dec 19, 12:04 am, visose <[email protected]> wrote: > > > > > rhinoscript won't be useful here. you'd have to bake the curves then > > > > manually select them and run the script every time something is > > > > changed. > > > > when the scripting component was introduced in GH, someone made a real > > > > time connection with excel. Nevertheless, you don't need scripting to > > > > output data to excel from GH. > > > > If you right click in the text note component you'll see a stream to > > > > file option. this streams the note's data to a text file and gets > > > > updated realtime. Now open excel and link that text file as a data > > > > source. all you have to do now is press the update button in excel > > > > every time you want an update or set it to update every x seconds. you > > > > can disable the dialogue that asks to search for the text file every > > > > time you press update. > > > > > On Dec 18, 5:43 pm, rob <[email protected]> wrote: > > > > > > Hi > > > > > > The goal (at this point) is to create a working excel spreadsheet of > > > > > floor plate areas from a Rhino model. This is where I'm at with it. > > > > > This is all about workflow, not really design. > > > > > > Using scripts from the Wiki, I have been able to create a script that > > > > > takes closed curves (meshes+srfs could work too), calculates their > > > > > area and extracts that info to excel. It's an alpha version, and i'm > > > > > no code monkey, but here it > > > > > is:http://groups.google.com/group/grasshopper3d/web/Excel%20-%20Curve%20... > > > > > > Additionally, from Designanalyze's spline tower tutorial I have been > > > > > able to calculate floor areas with automated floor to floor heights. > > > > > So far only outputting it into a sticky. Here's that .ghx: > > > > > http://groups.google.com/group/grasshopper3d/web/Floor%20areas.ghx?hl=en > > > > > Just plug-in any polysrf and it'll work. (Although I've had some > > > > > issues with trimmed srfs) > > > > > > There are two questions to move on the next step. 1. How to get the > > > > > script to read and extract the output from GH? 2. (mostly scripting) > > > > > How to update the same excel spreadsheet instead of creating a new one > > > > > each time? > > > > > > Any suggestions, solutions or locations of similar work is great. > > > > > > Thanks > > > > > rob > >
