Good Day to you sir! Newbie inventor user here.
Would anyone know how to assign a 3d coordinate in space, and have it linked directly to a excel spreadsheet - so updates/changes to the excel can be reflected in the points? (key idea is linked to the excel sheet)
The situation is like this:
-I have 18 (could be 200 in the future) points located in 3D space.
-I know how and can import these points into a 3D sketch no problem.
- BUT - how would I link each point and its 3 coordinates to the excel sheet, so when a change is made to the excel sheet, I can update the points?
The only way I can figure it out is by manually dimensioning each point to the origin x,y,z planes.
Is this the only way? What to do with 200 points?
Any help would be greatly appreciated.
Regards
tb
Solved! Go to Solution.
Solved by Steve_Bahr. Go to Solution.
Welcome to the forum.
I don't think this can be done, other than possibly with some custom VB code. Did you search the forum for this already? If so you might be aware of some of the suggestions made in the past.
Here are a few threads on this question from the past.
What are these 200 points?
Try this. It's an IV2010 template I made for our bent tubes. Opening the template brings you directly to the base sketch. Exit the sketch. Open the spreadsheet from the model browser. Notice the many points, all specified by x, y & z coordinates. Also notice the tube od and tube wall are specified. Edit the values of those points and save the spreadsheet. Flip back to the template and hit update [the yellow thunderbolt]. Viola! You're given a 3D sketch with the curve path. Delete the line returning back to 0,0,0 and add fillets. Create the sweep. To understand how I created the workpoints, examine the model browser. How you get the point info EXPORTED to a drawing will be up to you. But I can help you with that too, since I've already done it here.
Hope that helps.
Great - i think I can use this, thanks.
So, In general, you create a workpoint with the intersection of 3 planes. Each planes is offset from the origin plans by xi, yi and zi. Is this correct?
By the way, some background on my application. Each point corresponds to a bend (or a PI) in a large diameter pipeline alignment down the side of a mountain.
Thanks again, this is great
Tom Burton
Yup, workpoints at the intersection of workplanes offset from the origin planes. Glad to help.