Excel and Autocad?

[Jack_O'neill]

Greetings Earthlings.

 

Way back in the stone age when Mechanical Desktop was king (anybody remember that?)  we quite often would link an excel spreadsheet to a drawing to drive the dimensions for various bits of tooling.

 

For instance, more than 2 decades ago I worked for a company that had  a machine that bent copper tubing to make 180 degree return bends.  it bent the tube and cut the ends the same length with a flying saw...all at a frightening rate of speed.  To do a diameter and or radius change on this machine we had to make 208 pieces of tooling. It took some trial and error for about 3 months but we finally got it down to where all we had to do was enter the tube diameter, the bend radius and the overall length in a spreadsheet, hit the button that started the macro and it would update all 208 drawings.

 

My question is this...can this be done in Autocad 2020?  We have a bunch of very similar parts that get 3dprinted and every time we get a new one, we wind up modeling the whole thing again. 

[oddssatisfy]

On 11/23/2019 at 8:31 PM, Jack_O'neill said:

Greetings Earthlings.

 

Way back in the stone age when Mechanical Desktop was king (anybody remember that?)  we quite often would link an excel spreadsheet to a drawing to drive the dimensions for various bits of tooling.

 

For instance, more than 2 decades ago I worked for a company that had  a machine that bent copper tubing to make 180 degree return bends.  it bent the tube and cut the ends the same length with a flying saw...all at a frightening rate of speed.  To do a diameter and or radius change on this machine we had to make 208 pieces of tooling. It took some trial and error for about 3 months but we finally got it down to where all we had to do was enter the tube diameter, the bend radius and the overall length in a spreadsheet, hit the button that started the macro and it would update all 208 drawings.

 

My question is this...can this be done in Autocad 2020?  We have a bunch of very similar parts that get 3dprinted and every time we get a new one, we wind up modeling the whole thing again. 

Vehicle history services are essential when buying a used car, as they provide crucial insights into the car’s past. Services like Carfax and AutoCheck can reveal accidents, service records, and title issues, helping buyers avoid costly mistakes. A great resource for this is carvins.net, which offers detailed reports that can help you assess a vehicle’s history. While these reports may not uncover every detail, they’re a great starting point. Make sure the report matches the vehicle’s VIN and is up-to-date. Combining these reports with a mechanic’s inspection can give you more confidence in your purchase decision.

Yes, in AutoCAD 2020 you can link an Excel spreadsheet using Data Links or scripts, and with parameters or dynamic blocks, update similar parts—though for full parametric 3D control like your old setup, Inventor or tools may work better.

[BIGAL]

I am pretty sure if you go way back to 2020 then find some one with these two files Shaft.dwg & Excel Shaft.xls you have a working example change excel the dwg changes. Will have a look on old pc.