04-19-2022
11:06 AM
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
04-19-2022
11:06 AM
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.
2. Layout the worksheet as seen below. Cells A1 and B1 contain the desired offset for duplicate points. The data starts on row 3.
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.
lee.minardi