How to generate a Table


(Yigit) #1

Hi All,

I want to create or draw a table or matrix by using intersection points generated by CONTOUR Command from a Set of BREP…

As shown on the gh file, I have modified the x,y,z coordinates of intersection points. Because I want that; X Value will show the Row nr, Y Value will show the column nr, Z Value will be the value of the cell… (As shown on EXAMPLE 02.PNG)

Can somebody help me??

Thank you


(Yigit) #2

Sorry I forgot add my files :slight_smile:

OfsetTablosu.gh (13.9 KB)

Ornek_Govde.3dm (7.5 MB)


#3

See attached… The red components don’t really matter but you need the Null values to keep the data structure intact (5 x 6)

Edit: attachment removed…seems it is not working right yet


#4

this one should work correctly

OfsetTablosu_sg.gh (11.8 KB)


(Yigit) #5

Thank you thank you Gijs… You saved my life :slight_smile:

Last question … How can I use this table (Matrix) in EXCEL…

Copy/Paste does NOT work…

My aim is to make a table from this matrix

Thx


#6

Maybe this gives you a direction. If you have Lunchbox for grasshopper, it has some more components to directly write to an excel file. (for the sake of tidiness, I solved the red components issue)
OfsetTablosu_sg2.gh (14.9 KB)


#7

or like this, writing directly to a csv file…
OfsetTablosu_sg3.gh (12.3 KB)


(Yigit) #8

Wow Gijs… Thank you for your kind effort.
That worked very well…

Rg,


(Yigit) #9

Hi Gijs,

Since I am using OSX, I have modified your GH file… I was unable to write correct path of CSV file… See attached…

Also, I found some weird things after using gh file on different 3D Models.

Due to shape of the model, some Contours on Z Direction are not in a single piece (curve)…

See SC_01. Thats why, there are more Rows in Matrix than it should be…

And as you can see there are some useless intersection points @ 0 Level… Is there any solution to get rid out of them??

S

AhmetHulusiYildirim_Govde.3dm (71.4 KB)

TableOfOffsets.gh (10.6 KB)


#10

better then in that case to make the waterlines with plane brep intersection. This way you can keep the intersections together and get rid of the points at 0 line. Study the attached carefully, I had to change the data structure a bit to make this work.TableOfOffsets_sg.gh (20.2 KB)


(Yigit) #11

Thank you…