help i need a station offset dvb tool

[Anonymous]

autocad allows you to create station offset points
i have alot of them

can someone create a station offset tool for autocad
heres the concept

i have a spreadsheet with cells i enter
pnt station offset mh elev
1001 1000.00 2.5 lt mh 3 21.0
1002 1200.00 5.5 rt mh 6 11.0

id like it to create autoscript ie:auto-alignmrnts.scr
inside it will be
(f:adcmds 24)
1001
1000.00
-2.5
21.0
CALC mh


(PRINC "1001 1000.00 2.5 lt mh 3 21.0")
1002
1200.00
5.5
11.0
CALC mh


(PRINC "1002 1200.00 5.5 rt mh 6 11.0.")


thank you

[cadger]

yes...what part of this are you having trouble with?

[Anonymous]

🙂

[Anonymous]

i have a spreadsheet i created that id like to access thru lisp or vba
1) i added the station and offsets

in ldd - points- create points - alignments-station/offset
and then i have to enter each by hand which takes a long time

2) id like it to read the spreadsheet and bring in the station and offset automatically

this will the create the point i need

3)i am attaching the spreadsheet

4)id like to use the ldd function
(f:adcmds 24) which the will create them

thank you Edited by: whiteshield on Mar 23, 2009 3:25 PM

[cadger]

You might want to post in the http://discussion.autodesk.com/forums/forum.jspa?forumID=81 land desktop customization. If you are asking someone to write a program, you should probably include a fee and reply address. Better (for yourself) would be to dissect the conceived program/macro, read the help files, and ask specific questions on anything with which you might need a helping hand.

One thing I was curious about is why you would want to

4)id like to use the ldd function (f:adcmds 24) which the will create them

hope this helps