Jump to content

Dimension values to Excel


Butch

Recommended Posts

  • Replies 127
  • Created
  • Last Reply

Top Posters In This Topic

  • fixo

    59

  • Butch

    13

  • flyingjunkie

    11

  • Fordy

    9

Top Posters In This Topic

Posted Images

/offtopic

fixo, your codes helped me a lot while conding lisp + excel. Without your help I would never have finished them. I just want to thank you :D

Link to comment
Share on other sites

Forget about, back to draftboard,

tell me please where is origin point of panel from which one

we need to calculate the measurements relatively

lower left as usual or another one?

Also do you need to return just all holes on "HOLES" layer

or all holes on "Mounting holes" layer as well?

Link to comment
Share on other sites

Okay,

You didn't answer om my questions above, explain this

tell me please where is origin point of panel from which one

we need to calculate the measurements relatively

lower left as usual or another one?

Also do you need to return just all holes on "HOLES" layer

or all holes on "Mounting holes" layer as well?

Link to comment
Share on other sites

I've attached the file that shows where my origin should be. If I can get both "Holes" and "Mounting Holes" that would be great. If not, I have no problem running the app twice to get both of them.

sample.dwg

Link to comment
Share on other sites

Ok, will be back tomorrow,

from the scratch just change this expression in code:

instead of:

(cons 8 "holes")

use this one

(cons 8 "holes,mounting holes")

and try again

I need to go away from my machine

Link to comment
Share on other sites

Check DIMSCALE variable in your drawing

then change all values in code something like:

(rtos (* rad 2) 3 3) same for other values

Do it by yoursef, I' m busy with my own

Link to comment
Share on other sites

I have that worked out. I feel like it's so close I can taste it. I'm starting to understand what some of the changes you're making are doing. I'm sitting here with a book on AutoLISP trying to learn this stuff. I WISH I HAD YOUR BRAIN! lol. I honestly can't tell you how grateful I am for the help that you've given me thus far...

Link to comment
Share on other sites

Fixo,

 

I found a lsp that does exactly what I need done, but I need a few tweaks done to it. I believe VVA was the writer of the original. I sent him a message seeking his input last week, but have yet to receive a response. The coding is far too complex for me to be able to even consider making any changes to it. Here's where I'm at right now:

 

1. My Assigned origin is at the top right corner of a panel and the coordinates go into Quadrant 3 (both values negative). Where can I add a line or adjust a command with (abs so the values given are absolute values.

 

2. How does the circle numbering system work? I have 173 circles in my drawing that need dimensioned, but it looks like it just selects them and numbers them at random. Is there a way that the holes can be numbered Left to Right, Top to bottom like this, for example:

 

1 2 3 4

5 6 7

8 9 10 11

....etc...

 

The numbering really helps, but having them in an order like that would help greatly.

 

3. Is there a way to get rid of the Z-column on the spreadsheet?

 

Again, awesome program and thanks a million in advance for any help you can give!

ECoorE rev6.LSP

sample.dwg

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...