adding holes from a bore chart
adding holes from a bore chart
(OP)
I have a series of bore chartsin excell. Is there a way to use this info to add the holes to a solid model without having tp add them all individually?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
adding holes from a bore chart
|
RE: adding holes from a bore chart
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
CAD/CAM System Analyst
Ingersoll-Rand
RE: adding holes from a bore chart
RE: adding holes from a bore chart
Most feature based functionality added since V10 has only been added to Ug/Open API, not GRIP. This includes the ability to read spreadsheet data.
Alternative method using GRIP would be to put the spreadsheet file out as CSV and read it from GRIP and then put a point at all of your locations. You would have to go through the file and add holes. GRIP could create a cylinder and subtract it from your base, if that would be good enough.
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
CAD/CAM System Analyst
Ingersoll-Rand
RE: adding holes from a bore chart
Would it be possible to add the points to a sketch based on the spreadsheet data and keep it parametric? This would cut down some of the time.
Thanks for the info. I appreciate it.
Grover "Chip" Tasker
RE: adding holes from a bore chart
Jay Hostetler
UG Specialist
Engine Systems Product Definition
Hamilton Sundstrand
RE: adding holes from a bore chart
I forgot to mention that if you use the associative point method, you should save a "Template" part for future use. The link to an Excel spreadsheet can always be changed to point to a different spreadsheet, thus the future modification of your bolt center data is merely the adjustment of the spreadsheet and the subsequent model update.
Another "point" I should touch on is that you WILL still have to create the holes, but grip or macro can handle that part. If I were you, I would investigate all options for the quickest, simplest, and easiest to modify.
Jay Hostetler
UG Specialist
Engine Systems Product Definition
Hamilton Sundstrand
RE: adding holes from a bore chart
-Derek
DL Engineering Services
specializing in CAD Design Consultation Services
www.dl-engineering.com
RE: adding holes from a bore chart
Chip