I figured out how to pass the attributes (specifically the measurement from a rotated dimension) of a block to an excel spreadsheet. I did this by converting each linear dimension I took into its own block and define consistent attribute tags throughout.
What I mean by consistent attribute tags is that I gave each block a tag for the dimension's measurement with the name "EEK". I then made an attribute extraction file (attached below) and called the ATTEXT command to pass the attributes to a '.txt' file. I then passed the text into excel and used a SUM function there to add my measurements.
Is there any way I can add the numbers for the measurements within AutoCAD LT?
Solved! Go to Solution.
I figured out how to pass the attributes (specifically the measurement from a rotated dimension) of a block to an excel spreadsheet. I did this by converting each linear dimension I took into its own block and define consistent attribute tags throughout.
What I mean by consistent attribute tags is that I gave each block a tag for the dimension's measurement with the name "EEK". I then made an attribute extraction file (attached below) and called the ATTEXT command to pass the attributes to a '.txt' file. I then passed the text into excel and used a SUM function there to add my measurements.
Is there any way I can add the numbers for the measurements within AutoCAD LT?
Solved! Go to Solution.
Solved by pendean. Go to Solution.
Solved by steven-g. Go to Solution.
No not within LT, but you can get it fairly quickly using excel, using the "list" command in LT, select the dimensions and create the list then copy your command history (F2) or look at keeping a log file which is easy to acces. Paste the results into an excel sheet and use the split data to columns function to separate the x and y values (if your using LT it should be safe to ignore z)
Now filter the results just to show the "1st and 2nd extension defining points", from there you can use a simple formula to work out the distances for each set of points.
=SQRT(((B7-B8)^2)+((C7-C8)^2))
You should only place the formula once for each set of points, see the attached image that shows you the results
No not within LT, but you can get it fairly quickly using excel, using the "list" command in LT, select the dimensions and create the list then copy your command history (F2) or look at keeping a log file which is easy to acces. Paste the results into an excel sheet and use the split data to columns function to separate the x and y values (if your using LT it should be safe to ignore z)
Now filter the results just to show the "1st and 2nd extension defining points", from there you can use a simple formula to work out the distances for each set of points.
=SQRT(((B7-B8)^2)+((C7-C8)^2))
You should only place the formula once for each set of points, see the attached image that shows you the results
I wasn't exactly accurate with the title, but I meant how could I add up the measurements associated with multiple linear dimensions
I wasn't exactly accurate with the title, but I meant how could I add up the measurements associated with multiple linear dimensions
The log file you're talking about is just a txt file with the command history pasted in right? Or is it something a little more involved?
The log file you're talking about is just a txt file with the command history pasted in right? Or is it something a little more involved?
@Anonymous wrote:
The log file you're talking about is just a txt file with the command history pasted in right? Or is it something a little more involved?
Correct, you need to turn it on in Autocad's options, and set a path that is easy to find, Autocad then creates a logfile for every drawing you open, and keeps a record of the complete command line history, it uses the drawing name followed by a series of numbers, giving a unique name everytime you open a drawing, just be aware this is a folder you should then regularly empty as it can quickly contain thousands of files. The other advantage is it gives you record of all the files you have opened over a given time period, great for keeping track of projects you have worked on for time sheets..
And yes it is just a txt file it has a .log extension but you can just change that to .txt or even .xls and it can be opened straight up with excel
@Anonymous wrote:
The log file you're talking about is just a txt file with the command history pasted in right? Or is it something a little more involved?
Correct, you need to turn it on in Autocad's options, and set a path that is easy to find, Autocad then creates a logfile for every drawing you open, and keeps a record of the complete command line history, it uses the drawing name followed by a series of numbers, giving a unique name everytime you open a drawing, just be aware this is a folder you should then regularly empty as it can quickly contain thousands of files. The other advantage is it gives you record of all the files you have opened over a given time period, great for keeping track of projects you have worked on for time sheets..
And yes it is just a txt file it has a .log extension but you can just change that to .txt or even .xls and it can be opened straight up with excel
Can't find what you're looking for? Ask the community or share your knowledge.