EXPORT DATA KOORDINAT EXEL DENGAN AUTOCAD

LANGKAH-LANGKAH EXPORT

Sebelumnya buat layer di autocad yaitu :
Layer Elevasi
Layer Titik Koordinat
Layer Titik Pengamatan

Tempatkan masing-masing rumus di layer tersebut

Pada Exel Kolom : 

A = Titik Pengamatan
B = Nilai Korrdinat X
C = Nilai Koordinat Y
D = Nilai Ketinggian (Elevasi)
G = Nilai 2 (Ukuran Tinggi Huruf)
H = Nilai 0 (Posisi Huruf 0 Derajat)

UNTUK PLOTTING ANGKA KETINGGIAN <elevasi> Titik X Y Z 1 1000 1000 3.5 2 1181.804496 1080.269875 4.2635 3 1317.312481 1081.936579 3.7615 4 1297.64007 1025.565088 3.453 5 1263.195642 910.3855176 3.139 6 1218.171982 788.94989 3.1325 7 1047.854692 863.0938218 3.4615 8 1019.770169 941.3920504 3.412 RUMUS : =CONCATENATE("-","TEXT M"," ",B1,",",C1,",",G1," ",H1," ",D1)' HASIL RUMUSAN -TEXT M 1000,1000,3.5 2 0 3.5 -TEXT M 1181.80449552933,1080.26987472703 2 0 4.2635 -TEXT M 1317.31248078405,1081.9365789674 2 0 3.7615 -TEXT M 1297.64007021501,1025.56508807309 2 0 3.453 -TEXT M 1263.19564244093,910.385517571403 2 0 3.139 -TEXT M 1218.17198210263,788.949890033791 2 0 3.1325 -TEXT M 1047.85469208848,863.093821834727 2 0 3.4615 -TEXT M 1019.77016926075,941.392050387871 2 0 3.412 ENTER UNTUK PLOTTING TITIK PENGAMATAN Titik X Y Z 1 1000 1000 3.5 2 1181.804496 1080.269875 4.2635 3 1317.312481 1081.936579 3.7615 4 1297.64007 1025.565088 3.453 5 1263.195642 910.3855176 3.139 6 1218.171982 788.94989 3.1325 7 1047.854692 863.0938218 3.4615 8 1019.770169 941.3920504 3.412 RUMUS : =CONCATENATE("-","TEXT M"," ",B1,",",C1," ",G1," ",H1," ",A1)' HASIL RUMUSAN -TEXT M 1000,1000,3.5 2 0 3.5 -TEXT M 1181.80449552933,1080.26987472703 2 0 1 -TEXT M 1317.31248078405,1081.9365789674 2 0 2 -TEXT M 1297.64007021501,1025.56508807309 2 0 3 -TEXT M 1263.19564244093,910.385517571403 2 0 4 -TEXT M 1218.17198210263,788.949890033791 2 0 5 -TEXT M 1047.85469208848,863.093821834727 2 0 6 -TEXT M 1019.77016926075,941.392050387871 2 0 7 ENTER UNTUK PLOTTING TITIK KOORDINAT X,Y Titik X Y Z 1 1000 1000 3.5 2 1181.804496 1080.269875 4.2635 3 1317.312481 1081.936579 3.7615 4 1297.64007 1025.565088 3.453 5 1263.195642 910.3855176 3.139 6 1218.171982 788.94989 3.1325 7 1047.854692 863.0938218 3.4615 8 1019.770169 941.3920504 3.412 RUMUS : =CONCATENATE("Point",12," ",X1,",",Y1)' HASIL RUMUSAN : Point 1000,1000 Point 1181.80449552933,1080.26987472703 Point 1317.31248078405,1081.9365789674 Point 1297.64007021501,1025.56508807309 Point 1263.19564244093,910.385517571403 Point 1218.17198210263,788.949890033791 Point 1047.85469208848,863.093821834727 Point 1019.77016926075,941.392050387871 RUMUS : =CONCATENATE(,12," ",X1,",",Y1)' HASIL RUMUSAN : Line 1000,1000 1181.80449552933,1080.26987472703 1317.31248078405,1081.9365789674 1297.64007021501,1025.56508807309 1263.19564244093,910.385517571403 1218.17198210263,788.949890033791 1047.85469208848,863.093821834727 1019.77016926075,941.392050387871 close return

UNTUK PLOTTING DATA TERSEBUT DI AUTOCAD : 
1. JALANKAN PROGRAM AUTOCAD 
2. BLOK DATA EXEL HASIL RUMUSAN , CLICK MOUSE KANAN PILIH COPY 
3. PASTE HASIL COPY KE AUTOCAD PADA PERINTAH 
COMMAND :  ........... <Copy Blok Hasil Rumusan>

Semua rumus di atas bisa dirangkum dalam satu File yang namanya File Script 
Autocad , untuk menjalankan file di autocad  tinggal Click Tools - Run Script

HASIL EXPORT :