Extracting Length & Angle

[SlopeSilviu]

Getting an idea of what I do:

I have the base point X and the secondary points from lets say 1 to 20 (total of 21 points)

I draw lines from X to every one of the secondary point (from point X to point 1; from point X to point 2; from point X to point 3; ........from point X to point 20)

If you click proprieties on one of the lines, you will see that it has a Length and an Angle.

I need to manually copy the length and the angle of every line, and paste it in a table on Excel/Word.

 

Problem:

I have about 100 points a day of this kind, so manually copying their length & angle is a real pain.

Is there any way faster to do this. A specific command in AutoCad (2006)

I was thinking if anyone know a name of a certain LISP, or if someone possess one that can help me with this problem.

 

If I wasn't specific enough, I will submit an example.

[designerstuart]

welcome to the CADTutor forum!

this would be a fairly easy lisp to make, i am sure. probably someone has already done it...... sorry i can't write lisp but someone who can will come along soon.

 

(maybe one of the mods should move this to the lisp forum?)

[Tyke]

You don't need a LISP routine, it can be done perfectly well using Data Extraction, which allows you to export directly to Excel.

 

When you've done it once you can use that dxe file as a template the next time you do a similar data extraction. On page 4 select just geometry and the Angle and Length properties. On page 5 select the columns you wish to export. On page 6 select "Output data to external file..." and if you want a table in your drawing too then tick that box too.

[SlopeSilviu]

I never used the Data Extraction function on AutoCAD, I haven't got the slightest idea how to use it. I guess I'll go find me some tutorials. Thank you for the quick reply. xD

[Tyke]

It's not at all difficult. Type the command "_DATAEXTRACTION" in the command line and a wizard starts, that guides you through the whole process. You can alwasy navigate backwards through the wizard if you want to change something,until you get out what you need. It's all pretty intuitive.

 

I created your 21 points and 20 lines and then did a data extraction on them in less than a minute, with a table in the drawing and an Excel file too. Give it a try.

[SlopeSilviu]

For some reason it doesn't work O_O Maybe it doesen't work on AutoCAD 2006.

Ill search some tutorials later. Thanks again for the reply.

 

Unknown command "_DATAEXTRACTION". Press F1 for help.

Unknown command "DATAEXTRACTION". Press F1 for help.

[alanjt]

This entire procedure could be accomplished with a simple LISP, but with you still in the beginning stages of CAD, it will only hinder your abilities to learn properly.

 

eg. (less than 5 minutes of coding)

[SLW210]

I do not think DATAEXTRACTION was available in AutoCAD 2006.

[Tyke]

I do not think DATAEXTRACTION was available in AutoCAD 2006.

 

Pity, just did a little video for him too:

 

[designerstuart]

maybe alan would be kind enough to give him the lisp, seeing as it will not prohibit his learning in this instance?

[SlopeSilviu]

Yeah it doesn't have the option of data extracting

Alan, I would very much appreciate it if you could and want to give me that LISP. It would help me a lot. ^_^

 

Tyke, thanks a bunch for always having a quick reply for me

Also all the other guys, thank you for the support.

[ReMark]

r2f.lsp

 

A routine to write point data to a file.

 

http://www.hghg.freeserve.co.uk/downloads.htm