Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

leeminardi
en respuesta a: bpeters33

Here's a way to do it with Excel and AutoCAD.

1. Import the point data into Excel and then sort. This should yield duplicate points consecutively.

leeminardi_0-1650390940820.png

2.  Layout the worksheet as seen below. Cells A1 and B1 contain the desired offset for duplicate points.  The data starts on row 3.

leeminardi_1-1650391138143.png

 

3. Cell C3 = 0. while cell C4 is:

=IF(AND(A4=A3,B4=B3),C3+1,0)

Fill column C all the way down from C4 to the last row of data.

 

4. Cell D3 is:

=CHOOSE($C3+1,A3,A3+A$1,A3+2*A$1)

and E3 (fill right from C3) is:

=CHOOSE($C3+1,B3,B3+B$1,B3+2*B$1)

Fill columns D and E down to the last row of data.

 

5. Cell G3 is:

=CONCATENATE("point ",D3,",",E3)

Fill down then copy and paste this column into AutoCAD.

 

The result should look something like this.

leeminardi_2-1650391484768.png

 

 

lee.minardi