g hundreds of files. Normally I would simply write a VBA macro in Excel and be commended for being a life saver for doing this in under half an hour. I found myself opening Rhino/Grasshopper and achieving the same results in under 5 minutes. He then got me to do the calculations he was going to do in Excel as well (Note the explanations are for the benefit of my work colleague)
Here's the definition:As you can see I have only used components from 3 native tabs (Params, Math, Sets) and gHowl for the spreadsheet writer.
This got me wondering. "Is there scope for a stand alone Grasshopper IDE Lite version that doesn't need Rhino and any geometry components?" and "How many others have used Grasshopper for none Rhino purposes?"
Any thoughts?
----------------------
Hi my name is Danny and I am a gh addict.…
rience with VB Script. Does anyone have any experience linking data to Max similar to what can be done in Rhino. I was wondering if there was anyway to generate a color pattern similar to the effect shown but linked to size.
The link to the max script: http://www.maxforums.org/threads/maxscript_fun_examples/0001.aspxI am considering 2 solutions but any other possibilities are welcome:Solution 1:Is it possible to link Max to Excel through a vb script and then link a list of objects to a list in excel? There would need to be some way to rationally order the polygons of the mesh into a matrix via Cartesian co-ordinates so that I could map the interior edges of the facade with a matrix of values in Excel. This could wither by a list of rows and columns or a flat list. I'm not familiar with the way that max stores information about its geometry.
Solution 2:Is it possible to "call" color values from a poly line curve and then use these RGB values to generate a material? Without any experience with Max script I don't know where to start and whether or not this request would be complex or difficult to execute. Any help or advice would be greatly appreciated!
Also if anyone has any suggestions for another forum that might be better suited for this discussion, since it involves 3d max as well, that would be great. …
gt; Analysis) to access pt1 and pt2.
2. "I know a <point> component contains values for a location {x,y,z}. But can I display some sort of <point>numbering? Does GH assign a 'point number' to identify different points at all? Or is there some way to manually do this?"
[Point] parameter component stores points in a list, so this means that you can access each item individually by invoking its index (Sets > List > List Item), so you have your numbering problem solved.
3. "Can I set the panel to display a comma instead of a point to indicate the decimal mark?"
I suppose you can only solve this one via scripting. However I think when you import CSV (at least in excel) you can set what is the decimal point and what is the field separator...
Hope it helps. Best,
Eduardo…
Added by castroecosta at 6:49am on September 26, 2011
ed (selecting what you want to create from a library and entering key details, like coordinatesystem, length etc)
2. Script based (the most powerful as it gives unlimited access to the full repertoire of functions offered by GC), and I am self taught using the included tutorials in the help tab (and I had no knowledge of programming, other then maybe using 'IF' statements in Excel!). Its very well organised for beginners and you can easily be producing your own scripts within a week and doing more advanced stuff in 3months.
3. Visual based - just like GH, linking wires to components in a workspace
The overarching advantage is that rather then being restricted to recycling other peoples code that might not be suitable for your project requirements, instead you are the programmer meaning you can tailor anything you can think of to match perfectly your design intent.
As it is a CAD platform (unlike GH) technical drawings, 3d models etc can be extracted and/or setup such that you effectively have your own BIM model. The benefits in terms of costs / quality / efficiency / design exploration are hard to ignore.…
itude and longitude coordinates (real or approximately).
I will connect Zotero with Excel and then with Grasshopper, so I will have one point per building. So the thing is when I look for Spanish architects who built public buildings outside Spain during 1920-1960, I will have points in a worldwide or europeanwide scale.
My questions are:
1, Do you know any similar project? Or an easier workingflow?
2, Is it better to work in a 2D plane or a 3D world ball - and then write a definition to "unroll" the world sphere?
3, Which Grasshopper pluggin should I use? Heron, Ghowl, Sl? Another which works like any GIS?
4, Do you know if there is a Rhino file which the countries - regions are closed curves or surfaces?
Daniel,
Thank you for your time!…
wait until I'm satisfied with my new version, and it will be in a grasshopper component at that time.
Mapping Method 1: I'm not aware of this issue. It certainly isn't an issue in the version I'm using, but I'll see what I can do.
Analysis Result: I like to err on the side of giving you more information, rather than less. The text file is meant to be imported in Excel (use semicolon (I think) delimitation to divide everything by cells. You can then set it to view it at 2 decimal places yourself.
ISO Compliant: The result may not be compliant with the recommended range for your use, but the software doesn't even really know what you are simulating to begin with. ISO Compliance states that the calculation is being done in an ISO Compliant manner. So, for example, you are using one source, and not 2 to calculate the parameters.
Arthur…
n exporting data from a Square root
function to Excel I noticed that the values appearing on the Post-it
Panel have only 3 decimal places, while in older versions they had at
least 6. In general, the floating number values in the Output of
many components appear with only 3 decimal places. Even with the
simply Number -component connected to a Post-it Panel. I tried
through the Rhino display precision, but it didn't work Where can
I set the number of decimal places in the Output of floating numbers.
?
…
t on my desktop using Window 7 and office 2007. In this case it works well with xlsx file. Could you explain more about your testing conditions?
>for cons if you remove one or more lines excel then your program starts Bug.
Do you mean if one row or column in Excel been removed, the component has error? I have try that on my system and I do not have error. Can you explain your detailed steps when you see the error?
>The memory in this case is not optimized, ie it line by line do something like that.
It is true memory is not optimized and to be frank I don't know how to do that. Could you explain more on your suggestion?
Thank you!…
Added by Xiaoming Yang at 8:10pm on November 23, 2011
ttle closer attention to what type is really being returned or the exact type that you're working with. I'll explain below (BTW, this is in C# and I don't know if the VB.Net syntax/compiler causes things to behave differently).
The "old" way of doing things was fairly simple straight forward syntax (this assumes you already have gotten your workbook and worksheet references).
//Retrieve data from a given cell
someData = myWorkSheet.Cells[x,y];
// Assign data to a given cell
myWorkSheet.Cells[x,y].Value = someData;
Unfortunately this no longer works because of the object type that the mySheet.Cells[x,y] returns, which is akin to a base COM object type. So in order to be able to do anything with this, you'll need to cast the result of Cells as a range, like so.
Range cellData = (Range)myWorkSheet.Cells[x,y];
Now that you actually have a data type that you can work with, you'd think you can just use the Value property as you could before, but not really. For reasons unknown to me (and maybe this is just a C# thing), but there are separate methods for getting and setting a value; get_Value and set_Value* respectively. I will note that I did not see these pop up with intellisense in the GH editor, but it did within Visual Studio. So now the syntax above would expand to something like this.
Range cellData = (Range)myWorkSheet.Cells[x,y];
theRealData = cellData.get_Value();
To make things even trickier, there is one argument to the get_Value method of RangeValueDataType. 99.9% of the time, you won't care what that RangeValueDataType is, and because this is a COM dll, that argument is technically optional. This is definitely where there's likely going to be a C#/VB.Net split. C# does not have the concept of optional arguments, so you have to supply something. VB does, so you can get away with calling get_Value without any arguements. In order to mimic this behavior in C# you'd have to do something like this.
Range cellData = (Range)myWorkSheet.Cells[x,y];
theRealData = cellData.get_Value(System.Reflection.Missing.Value);
Hopefully that helps in actually getting to the data within Excel. One last thing though. The result of get_Value is an object, so you should probably cast that into the specific type that you're looking for. My recommendation for this is that you cast the result of get_Value as a string (which its pretty much guaranteed to be), then use Parse functions for types like int and double. See the code below (with some graceful failure for good measure).
Range cellData = (Range)myWorkSheet.Cells[x,y];
string theRealData = (string)cellData.get_Value(System.Reflection.Missing.Value);
try{
double myDoubleFromExcel = double.Parse(theRealData);
}
catch(Exception e){
Print(string.Format("{0} from Excel could not be parsed as a double.", theRealData));
return;
}
*looking over my notes, I don't explicitly say anything about set_Value, but I would be extremely surprised if A) it wasn't there, and B) its structure didn't mimic get_Value. There is a possibility though, so if what I mentioned doesn't hold true for set_Value, don't say I didn't give you a heads up.…
look like this. Where First Character of first Row is X coordinate and next character of same first row is telling No of times X coordinate is repeating.
Then next rows from 2 to 7 (6 steps) are Y, Z coordinate...like that it is going.
-3.28,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-2.916,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-2.551,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-2.187,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-1.823,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-1.458,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-1.094,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-0.729,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-0.365,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.-0.001,61.64,0.1.64,3.281-1.64,3.281-1.64,0.1.64,0.1.64,0.
…
Added by Amit Karanje at 11:01pm on November 4, 2017