Spread sheet or CSV file to contour or surface


#1

I plot mode deflection shapes from our dynamic tests, this involves massaging data into a spread sheet X,Y data with the Z axis value. I was able to plot this using Wingz, a windows 3.1 program! but not for long. I thought I could import a X,Y,Z file in sandbox then add a surface then use colour Z to get height color plot


#2

Use this plugin to import an X,Y,Z file.

Didier Bur: Cloud v8.0bxx
https://sketchucation.com/pluginstore?pln=Cloud

Cloud v8 can also triangulate the points and make faces.

Or … use TopoShaper, which has advanced features to refine and smooth the mesh.

Fredo6: TopoShaper v2.3b
https://sketchucation.com/pluginstore?pln=TopoShaper


#3

I assume that you’re looking for something like the display shown on the left in the image below?

If you can provide a few lines of your CSV file (the first three or four lines and the last one or two should be enough), I can probably help you with creating a color map of your data.


#4

Ok I have attached a simple data file which is the straight copy from the Wingz sheet followed by a Z,Y,Z coordinate listing.
the second file is the Wingz plot
The next process would be to extrude the bridge profile along to plot surface.
Thanks in advance
John
Wingz-Data.txt (374 Bytes)


#5

Thanks for the info I’ll look at these as well and let you know how I get one - Happy Easter All


#6

I edited your file to just the X,Y,Z data. The attached plugin will read ordered CSV data for any number of rows and columns. For example:

X,Y,Z
1,1,-0.07
1,2,-0.09
1,3,-0.11
1,4,-0.16
1,5,-0.18
1,6,-0.11
1,7,-0.09
2,1,-0.04
2,2,-0.12
2,3,-0.09
2,4,-0.13
2,5,-0.14
2,6,-0.07
2,7,-0.03
3,1,-0.02
3,2,-0.06
3,3,-0.07
3,4,-0.09
3,5,-0.1
3,6,-0.09
3,7,0.03

produces this:

2018-03-31_11h18_54

The plugin is very simplistic. There’s no error checking and it’s assumed that you’re working in inches. Let me know how you fare …

jimhami42_import_higgs.rbz (815 Bytes)


Z value input face draw CONTINUOUSLY ruby
#7

Thats good I like the script

I have now just adjust the scaling given the bridge deck is 20 m (60?) long and smooth the data a little
I’ll multiply the vertical axis by 50
For a recent job I superimposed the wingz contour on a jetty model
I’ll have to look up how to smooth then apply the colour contouring
any short cuts would be of a help
Thanks for your help


#8

Acid test to day I have a 60 by 60 matrix to map I’ll post the final result for you all to see
Cheers

John


#9

Hi Geo,
how can I import a XYZ-ASCII-File with over 130.000 points with TopoShaper?
Are there any possibilities?
Also I will send you a minimal example.

Best regards
Simon

sennet01dgm_example.txt (628 Bytes)


#10

I was certain it had an import function, but upon reading through the documentation.
To my chagrin, I find it does not.

Use Didier Bur’s Cloud v8.0bxx to import the coordinate points
https://sketchucation.com/pluginstore?pln=Cloud

Importing 130.000 points will take a long time, be patient.


#11

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.