Discussion forum

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Hello: 
I'm new to AutoCAD and trying to figure out a way to create a template in Excel that will allow me to use my coordinates (XY) along with radius information to create a drawing using a SR file.

My biggest problem is, my line segments are a combination of straight lines and arcs and they vary in sequential order. 

How can I put these coordinates/radii into an excel file which I then can convert to a SCR file to use in AutoCAD?

I have attached a sample of 4 different objects (shape of a fan blade) to show exactly what I'm working with. As you will notice amny of the segments use a radius but there are some straight lines as well. I do not want to have to modify my template for every object as I have hundreds of these objects I'm tying to create.

Any assistance or thought would be greatly appreciated!!!! Thanks in advance for your help.

uploads/389666/coordinateswithradius.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ryancharrier Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 10.Jul.2013 Location: United States Using: AutoCAD 2014 Status: Offline Points: 2	Topic: Arcs/Lines & SCR Files........... Posted: 10.Jul.2013 at 21:01
	Hello: I'm new to AutoCAD and trying to figure out a way to create a template in Excel that will allow me to use my coordinates (XY) along with radius information to create a drawing using a SR file. My biggest problem is, my line segments are a combination of straight lines and arcs and they vary in sequential order. How can I put these coordinates/radii into an excel file which I then can convert to a SCR file to use in AutoCAD? I have attached a sample of 4 different objects (shape of a fan blade) to show exactly what I'm working with. As you will notice amny of the segments use a radius but there are some straight lines as well. I do not want to have to modify my template for every object as I have hundreds of these objects I'm tying to create. Any assistance or thought would be greatly appreciated!!!! Thanks in advance for your help. uploads/389666/coordinateswithradius.zip
	Ryan

heinsite Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 05.Feb.2009 Location: United States Using: AutoCAD 2014 Status: Offline Points: 640	Posted: 11.Jul.2013 at 08:53
	Ryan, This is not exactly what you're after, but it may give you a few ideas. I've never tried something quite as complex as what you're after, but there's almost always a way. You will have to convert your spreadsheet to coordinates however, or somehow figure out bearing and length values. With those you should be able to build a spreadsheet where it then becomes a simple matter of copy and paste to the command line. Good luck! Dave. uploads/35918/Excel_Automation_in_AutoCAD.zip
	Dave Hein, P.E. Hawaii District Engineer Kona International Airport AutoCAD Certified Professional Autodesk Expert Elite

Discussion forum

?CAD discussions, advices, exchange of experience

Arcs/Lines & SCR Files...........

?
CAD discussions, advices, exchange of experience