automatic distribution of excel coordinate poles

[lucalbero]

Hello.
with this post I would like to have any suggestions that can solve this problem.
on autocad I have a line (which represents a road), on excel instead I have the position (extracted from very specific calculations) of some poles that I have to place on the road as in the example represented by the design (of course the design is a simplification).

I wanted to know if there is a way, after calculating the position of the poles on excel, to automatically position the balls on the autocad design representing the poles.

any suggestion will be useful to find a possible solution. Thank you very much.

 

[Cristallo]

pulled out of excel the coordinates of each pole, maybe in csv format
created a script (it is a txt file with .scr extension) that contains many lines with this format:

_ circuit ptpalo1 diam
_ circuit ptpalo2 diam
_circle ptpalo3;diam
etc.
the initial command is the classic circle. the space is equivalent to a ptpalo keyboard enter must be in x,y format (for example 123.456,789.000) the decimal separator must be "point" the separator between x and y must be "virgola"

once you create the file.scr, by autocad command _script, upload the file you created and the game is done.

 

[lucalbero]

Thanks endlessly for the crystal suggestion,
but the coordinates of each pole must follow the line, how can I calculate then the coordinates of the poles to suggest to autocad to place the circles on the line?

I can find the coordinates of start and end of the line on autocad but if I have to place a pole 200 meters from the beginning of my road how do I know which position covers on autocad i.e. on my line? in excel calculation the distances of my poles but how can I convert them to coordinates that guarantee me to place them on my line in autocad?

 

[dieva]

If you want to try this program I wrote on the fly.
If you have the distances you can 'staccarle' on the road (pline, spiline) and a circle will be drawn to the desired distance.