One of our sub-contractors sent me a Excel spreadsheet with the locations of strain gauges that they are going to locate on one of our assemblies. The locations are given in typical x,y,z. There are 326 locations that they are going to use. I have been tasked with adding a point at every one of the locations in the assembly. So, I plan on creating a unique coordinate system for each one. Then matching coordinates as I drag and drop a "dot" (basically a ball I modeled). I would really like to not have to manually enter every one of the coordinates. Is there a faster way to enter the data?
Thanks in advance for any help you can give me on this.
One way to do this is to:
- Place your sphere.
- Pattern it so you get 326 occurrences. (use an ASM Sketch pattern)
- Drop the pattern.
- Select all the spheres (Select selection manager or identical components)
- Run occurrence properties.
- Select the data in excel and copy it.
- Select all the XYZ entries in occurrence properties, right click and run paste.
This should get your spheres in all the correct locations.
Excellent, I was hoping this would work well for you.
I don't use the XYZ option on this very much for editing but when you need to
do stuff like this it's very handy.